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

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

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

On Oct 11, 10:47 am, EagleOne wrote:
Assume a 5% discount rate
In 2027 a payment od $1,000,000
How do you fill in the PV function?

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).

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

Thanks! Perfect

joeu2004 wrote:

On Oct 11, 10:47 am, EagleOne wrote:
Assume a 5% discount rate
In 2027 a payment od $1,000,000
How do you fill in the PV function?

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).