Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 4th 07, 06:00 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: May 2007
Posts: 1
Default How do I calculate NPV of perpetual annuity.

What is the method to calculate NPV from perpetual annuity.

  #2   Report Post  
Old May 4th 07, 12:25 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
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 08:32 PM
How to calculate the RATE in annuity? [email protected] Excel Discussion (Misc queries) 2 November 9th 05 08:23 AM
How to calculate the RATE in annuity? [email protected] Excel Worksheet Functions 2 November 9th 05 08: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 03:50 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017