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 |
How to Get a Single Date-Based Present Value
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 |
How to Get a Single Date-Based Present Value
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 |
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 |
All times are GMT +1. The time now is 11:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com