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.

Hi Fenil,

Sure, I can help you with that.

To calculate the value at the end of the 11th year using CAGR in Excel, you can use the following formula:

Formula:

=Beginning Value * (1+CAGR)^n 


In your case, the beginning value is 4.50 and the CAGR is 15.71%. So, the formula will be:

Formula:

=4.50*(1+15.71%)^11 


To enter this formula in Excel, follow these steps:

1. Open a new Excel sheet and click on an empty cell where you want to display the result.
2. Type the equal sign (=) to start the formula.
3. Type the beginning value (4.50) followed by an asterisk (*).
4. Type an opening bracket "(".
5. Type 1 plus the CAGR (15.71%) in decimal form (0.1571) followed by a closing bracket ")".
6. Type the caret (^) symbol to indicate exponentiation.
7. Type the value of n (11).
8. Press Enter to get the result.

The formula should look like this:

Formula:

=4.50*(1+0.1571)^11 


The result will be the value of your return at the end of the 11th year.

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.

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)

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

Tk care,
Fenil.

"ryguy7272" wrote:

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.

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)