CAGR

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])

Screen_Shot_2020-10-20_at_4.55.39_PM.png
    Formatted as a percent:
Screen_Shot_2020-10-20_at_4.54.23_PM.png