| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Present Value of a Continuously Compounded Annuity Payment | Excel Worksheet Functions | |||
| Amortisation with a lump sum principal payment during term | Excel Worksheet Functions | |||
| Looking for Excel SS which calculates Mortgage Payment with PMI | Excel Worksheet Functions | |||
| how to compute interest for a lump sum | Excel Discussion (Misc queries) | |||
| How do I calculate present value of a single sum? | Excel Worksheet Functions | |||
Threaded Mode
