Which XL formula calculates Present Value of a single lump-sum Payment in 2027?

E

EagleOne

Have used XNPV, NPV for a stream of payments but
what about a single payment 19 years hence?

Assume a 5% discount rate
In 2027 a payment od $1,000,000

How do you fill in the PV function?

TIA EagleOne
 
J

joeu2004

Assume a 5% discount rate
In 2027 a payment od $1,000,000
How do you fill in the PV function?
Click to expand...

I would do:

=pv(5%, 2027 - year(today()), 0, -1000000)

You might want to use ROUND() around that. And of course, "2027 -
year(today())" could be replaced with a constant (20, today).
 
E

EagleOne

Thanks! Perfect

joeu2004 said:
I would do:

=pv(5%, 2027 - year(today()), 0, -1000000)

You might want to use ROUND() around that. And of course, "2027 -
year(today())" could be replaced with a constant (20, today).
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Present value of individual uneven payments 1
Present Value of a Continuously Compounded Annuity Payment 5
present value of a future amount 4
Financial Calc: present cash value of a future amount 2
Sum a $ amount in part of a field 1
calculating the present value of X 2
How do I calculate present value of a single sum? 9
Count number of cols which contain a value(s) in it less than x(array formula?) 1

Top