CAGR
The CAGR function returns the compound annual growth rate of an investment.
CAGR is part of the set of financial functions that Sigma supports.
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: