Enter the initial value, final value, and number of periods an investment has been compounding to calculate the CAGR of that investment.

## CAGR Formula

The following formula is used to calculate the final value of an initial investment undergoing compounding interest or growth.

FV = IV (1 + (CAGR/100)/m) ^ mt

- Where FV is the final value
- IV is the initial value
- r is the rate of growth (%)
- m is the compounding frequency (assuming 1 = compounding each year)
- t is the total time invested

## How to calculate CAGR

The formula above outlines how to calculate the final value of an investment, but how do you figure out the CAGR (%) given the final value and initial value? This is a little more complicated and requires some re-arranging of the formula. After some redistribution we find that the formula so solve for CAGR is the following:

CAGR = (FV / IV)^{1 / t} – 1

## How can CAGR be used?

CAGR is a measure of return on an investment that shows the rate in terms of equal return each year. It does not show the actual return rate of each year. This can be helpful in showing a true approximation of return since markets can fluctuate year to year.

Analyzing an investment on an average basis allows a individual or business to more accurately estimate the return moving forward. One year that investment might be down and the next it might be up. However, on an average basis it will return at the CAGR.

## Related Terms

cagr calculator |

how to calculate cagr |

cagr formula |

cagr formula excel |

cagr excel |

compound growth calculator |

annual growth rate formula |

compound annual growth rate calculator |

calculate cagr in excel |

compound growth formula |

compound growth rate |

compound annual growth rate formula |

annual growth rate calculator |

compound annual growth rate excel |

growth rate formula excel |

cagr calc |

cagr calculator online |

how to calculate compound annual growth rate |

cagr equation |

compound monthly growth rate |

cagr calculation formula |

compound growth rate formula |

how to calculate end value from cagr in excel |

compound growth rate calculator |

average annual growth rate formula |

average annual growth rate calculator |

growth rate excel |

how to compute cagr |

cagr computation |

cagr formula example |

annual growth calculator |

how do you calculate cagr |

compound annual growth calculator |

compound annual return |

how to find cagr |

calculate growth rate in excel |

average growth rate excel |

cagr growth calculator |

cagr calcul |

how to calculate compound growth |

annual growth formula |

cagr calculator excel download |

compound growth formula excel |

compound growth rate excel |

excel compound growth |

cagr formula online |

compound average growth rate formula |

average annual growth rate excel |

annual growth rate excel |

compound annual growth rate formula excel |

how to calculate compound growth rate |

annual growth rate formula excel |

average annual growth rate formula excel |

3 year cagr calculator |

cagr calculator india |

compound monthly growth rate calculator |

3 year cagr formula excel |

compound monthly growth rate formula |

calculate compound annual growth rate excel |

how to work out cagr |

compound annual return calculator |

cagr equation excel |

calculation of cagr in excel |

5 year cagr calculator |

calculate annual growth rate excel |

using cagr to calculate future value |

5 year cagr formula excel |

how to compute for cagr |

calculation cagr |

find cagr |

cagr excel function |

cagr to annual growth rate |

how to calculate cagr formula |

compound average growth rate calculator |

how to calculate 5 year cagr |

cumulative growth formula |

how to calculate cagr in excel with negative number |

compound growth calculator excel |

cagr calc in excel |

compound growth calc |

calculate yearly growth rate |

how to calculate cagr for sip |

how to calculate cagr growth |

how do i calculate cagr |

revenue cagr calculator |

how to calculate cagr manually |

compounded annual return formula |

excel calculate compound growth |

cagr future value calculator |

how to calculate compound annual growth |

cumulative growth rate formula |

average annual growth formula |

compound average return |

compound growth rate formula excel |

calculating future value using cagr in excel |

how do you calculate compound annual growth rate |

mean annual growth rate calculator |

absolute return to cagr calculator |

cagr percentage calculator |

cumulative annual growth rate calculator |

cagr no excel |

how to compute compound annual growth rate |

stock cagr calculator |

cumulative growth formula excel |

cagr growth formula excel |

constant annual growth rate formula |

compound annual growth excel |

mean annual growth rate formula |

compounded annual growth formula |

cagr growth rate formula |

how to cagr |

computing cagr in excel |

how to work out cagr in excel |

cumulative annual growth rate formula |

cagr math |

formula of annual growth rate |

how to calculate cagr in mutual fund |

how to use cagr in excel |

cagr formula xls |

compound annual growth rate calculator online |

compound annual rate of return formula |

finding annual growth rate |

how to calculate cagr in calculator |

how do i calculate compound annual growth rate |

formula for calculating cagr in excel |

how to calculate compounded annual return |

how to calculate cagr from annual growth rates |

excel function for cagr |

calculation of cagr online |

compound growth formula calculator |

annual compound growth |

cagr example excel |

formula to calculate annual growth rate |

cagr calculator excel formula |

cagr growth rate calculator |

cagr investment calculator |

compound annual rate of return calculator |

compound average return formula |

formula cagr in excel |

example of cagr |

excel formula for annual growth rate |

calculate cagr return |

cumulative average growth rate formula |

compute annual growth rate |

how to calculate cagr with multiple investments |

cagr growth excel |

compute compound annual growth rate |

how to calculate cagr of sip |

annual growth formula excel |

annual growth percentage calculator |

calculator for cagr |

annual compound rate of growth |

cagr calculator app |

formula to calculate growth rate in excel |

cagr calculator example |

future value using cagr |