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:
- Open a new Excel sheet and click on an empty cell where you want to display the result.
- Type the equal sign (=) to start the formula.
- Type the beginning value (4.50) followed by an asterisk (*).
- Type an opening bracket "(".
- Type 1 plus the CAGR (15.71%) in decimal form (0.1571) followed by a closing bracket ")".
- Type the caret (^) symbol to indicate exponentiation.
- Type the value of n (11).
- 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.