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

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

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

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