[ x ] Insert beginning value
[ x ] Insert final value
[ ? ] Find yearly growth rate
Formula =
round(10000 * (pow(prop("End Value") / prop("Start Value"), 1 / prop("Years")) - 1)) / 10000Scenario: A company's year end revenue over a 7 year period determines its Annual Growth Rate (CAGR)
Annual Growth
Name
Start Value
End Value
Years
CAGR