Thread: Calculate value at the end of nth year using CAGR
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joeu2004 joeu2004 is offline
external usenet poster
  
Posts: 2,059
Default Calculate value at the end of nth year using CAGR
On Jan 1, 9:30*pm, Fenil Shah
wrote:
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.

=fv(15.71%, 11, 0, -4.50)
Reply With QuoteReply With Quote