Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default How do I calculate NPV of perpetual annuity.

What is the method to calculate NPV from perpetual annuity.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Perpetual calander BIL Excel Worksheet Functions 0 January 15th 06 09:32 PM
How to calculate the RATE in annuity? [email protected] Excel Discussion (Misc queries) 2 November 9th 05 09:23 AM
How to calculate the RATE in annuity? [email protected] Excel Worksheet Functions 2 November 9th 05 09:23 AM
How to calculate the accumulated payments from an annuity at yr 10 jmuirman Excel Worksheet Functions 1 August 8th 05 08:05 PM
How do I calculate the accumulated payments from an annuity at yr jmuirman New Users to Excel 2 August 7th 05 04:29 PM


All times are GMT +1. The time now is 12:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"