Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I calculate NPV of perpetual annuity.
What is the method to calculate NPV from perpetual annuity.
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I calculate NPV of perpetual annuity.
If the first payment is due a year from now, the PV is simply the annual
payment divided by the interest rate. Ex: $1000 paid annually, with an interest rate of 8% is $12500. "Kalsang" wrote: What is the method to calculate NPV from perpetual annuity. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Perpetual calander | Excel Worksheet Functions | |||
How to calculate the RATE in annuity? | Excel Discussion (Misc queries) | |||
How to calculate the RATE in annuity? | Excel Worksheet Functions | |||
How to calculate the accumulated payments from an annuity at yr 10 | Excel Worksheet Functions | |||
How do I calculate the accumulated payments from an annuity at yr | New Users to Excel |