Calculate value at the end of nth year using CAGR

[Fenil Shah]

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.

 

[ryguy7272]

I set it up like this:
PV in A2 = -4.5
I in B2 = .1571
N in C2 = 11
FV in B3 = 22.41
The function in B3 is =FV(B2,C2,0,A2)


Happy New Year,
Ryan--

 

[joeu2004]

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)

 

[Fenil Shah]

Hey, thank u so much! A very Happy New Year to you too!

Tk care,
Fenil.

 

[Fenil Shah]

Hi,

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

Tk Care,
Fenil.