CAGR
Last updated
Was this helpful?
Last updated
Was this helpful?
The CAGR function returns the compound annual growth rate of an investment.
The CAGR function syntax has the following arguments:
n
(required) The number of periods of the investment.
bv
(required) The beginning value.
ev
(required) The end value
The general formula for the CAGR function is:
(ev / bv )^(1 / n) - 1.
An investment that grew from $3,000 to $48,000 in 4 periods has a return rate of 100% for each period.
Calculate the annual rate of return of an investment over a period of 10 years, as a percentage:
