How to Get a Single Date-Based Present Value

Posted to microsoft.public.excel.misc

Will[_3_]

external usenet poster

Posts: 15

How to Get a Single Date-Based Present Value

I want to get a present value of:

Amount: $2
Date of Payment: 1/1/2009
Discount Rate: 5%

I tried to use XNPV for this with:

XNPV(Discount,Amount,Date)

but it gives a #NAME? error.

Is my usage incorrect, or is this the wrong function for what I want here?

--
Will

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Which XL formula calculates Present Value of a single lump-sum Payment in 2027?	EagleOne	Excel Discussion (Misc queries)	2	October 11th 07 07:48 PM
Isolating single row based on date comparison	[email protected]	Excel Worksheet Functions	3	October 25th 06 05:42 PM
Changing color of single bar based on x-axis date value	[email protected]	Charts and Charting in Excel	2	August 4th 06 05:17 PM
FILL DATES IN VARIOUS CELLS BASED ON A DATE ENTERED IN A SINGLE C.	dencrowell	Excel Discussion (Misc queries)	1	April 14th 05 04:11 AM
How do I calculate present value of a single sum?	Carmen	Excel Worksheet Functions	9	March 29th 05 07:27 PM

All times are GMT +1. The time now is 09:46 AM.

Menu

About Us