| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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). |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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). |
| Reply |
| 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 | |||
Linear Mode
