The formula for calculating CAGR manually is: = ( end / start) ^ (1 / periods) - 1. In the example shown, the formula in H7 is: = ( C11 / C6) ^ (1 / B11) - 1. where C11 is the ending value in year 5, C6 is the starting value or initial investment, and B11 is the total number of periods. The first part of the formula is a measure of total return. We can use the following formula to find the ending value of some investment after a certain amount of time: A = P(1 + r/n) nt. where: A: Final Amount; P: Initial Principal; r: Annual. You can elect a monthly income from your TSP that will be based on the current value in your Thrift. Similar to how the charts above were calculated, if we use a google sheet and enter =FV (7%, 30, 0, -10000) in a cell, the calculation result will give us exactly $76,122.55, which represents annually compounded interest over 30 years starting with a $10,000 initial investment. Answer: Are you talking of sales growth or net profit growth .whichever it is it is simple .if 1st value is 100 and in 2nd it is 150 below this row your formulae to type will be B minus A ÷A or B-A/A is the formulae to get growth % by formatimg the formulae cell as percentage field and copy this. Step_4: Now press ENTER. The result will come along in decimal form. 🔗 2 Ways to Calculate Bacterial Growth Rate in Excel. Decimal to Percentage. Step_5: Select cell C3. Step_6: Select the Home tab. Step_7: Click on the ‘%’ icon from the Number group. Step_8: Double-click on the Fill Handle to fill down the formula from cell C3 to C13. Final Result ↓.