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--


--
RyGuy


"Fenil Shah" wrote:

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.