Thread: Calculate value at the end of nth year using CAGR
View Single Post
  #5   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,

We meet again! Thank u once again for coming to my rescue. Wish u a very
Happy New Year!

Tk Care,
Fenil.

"joeu2004" wrote:

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