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
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
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:
