View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bpeltzer bpeltzer is offline
external usenet poster
 
Posts: 171
Default 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.