Returns the rate of return of an investment over a length of time, defined as (ev / bv )^(1 / n) - 1.
Usage
CAGR(n, bv, ev)
n (required) The number of periods of the investment.
bv (required) The beginning value.
ev (required) The end value.
Example
(1) Calculates the annual rate of return of an investment over a period of 10 years:
CAGR(10, [Beginning Investment], [Ending Investment])
Formatted as a percent: