How to Get a Single Date-Based Present Value
What you are doing wrong is you entered $1.91 as the payment, not the future
value. FV is the fourth parameter of the PV function, not the third.
Regards,
Fred.
"Will" wrote in message
...
When I enter a discount of 5% and a payment on 1/1/2009 of $191 this way:
=PV(5%,(DATE(2009,1,1)-TODAY())/365,-$1.91)
I am getting back 43 cents as the answer. $1.91 discounted at 5% for a
few months is certainly not 43 cents. What am I doing wrong?
--
Will
"Fred Smith" wrote in message
...
If you want a present value, just use PV, as in:
=PV(5%,(Date(2009,1,1)-today())/365,0,-2)
To determine why you got a #NAME error with XNPV, lookup XNPV in help.
Regards,
Fred.
"Will" wrote in message
...
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
|