Calculate value at the end of nth year using CAGR
 

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.

Answer: Calculate value at the end of nth year using CAGR
 

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.

Calculate value at the end of nth year using CAGR
 

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.

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)

Calculate value at the end of nth year using CAGR
 

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.

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)