LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 17
Default Calculate value at the end of nth year using CAGR

Hi,

Could somebody pl. help me find the value of my return at the end of the nth
year using compunded annual growth rate formula? I am unable to get it.

My beginning value is 4.50 and the CAGR is 15.71%. I need to find the value
after 11 years, i.e. n=11. I need this value asap. I don't know how to
calculate it on excel. Pl. pl. help.

Fenil.
 
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
How do I calculate CAGR in Excel? melshult Excel Worksheet Functions 2 February 21st 07 05:54 PM
How do I calculate CAGR other than using XIRR function? rrigney Excel Worksheet Functions 2 July 10th 06 12:06 AM
Calculate the CAGR Bruce Excel Worksheet Functions 6 June 7th 05 02:17 PM
how do i calculate CAGR for a series of years of revenues? NuttinButFun2 Excel Worksheet Functions 1 April 18th 05 10:08 PM
How do I calculate CAGR when there are periodic additional investm Roger Phillips Excel Worksheet Functions 3 March 1st 05 02:10 AM


All times are GMT +1. The time now is 04:33 AM.

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

About Us

"It's about Microsoft Excel"