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
|