The above formulas show how simple compounding interest works in Excel. However, when it comes to calculating the future value of your investment, these formulas are inadequate. Besides, you cannot use these formulas to calculate the future value (final value with different compounding periods – d...
Step 1:Use the generic CAGR formula in Excel. If the beginning value is in cell B2, the ending value is in cell B11, and the number of periods is 9, enter the following formula: =(B11 / B2)^(1 / 9) - 1 Step 2:PressEnterto compute the CAGR. Step 3:Format the result as a...