View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fenil Shah[_2_] Fenil Shah[_2_] is offline
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.