CAGR

The CAGR function returns the compound annual growth rate of an investment.

Syntax

CAGR(n, bv, ev)

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.

Examples

CAGR(4, 3000, 48000)

An investment that grew from $3,000 to $48,000 in 4 periods has a return rate of 100% for each period.

CAGR(10, [Beginning Investment], [Ending Investment])

Calculate the annual rate of return of an investment over a period of 10 years, as a percentage: