Same same, but different

In order to calculate the (average) annual growth rate over multiple year, use this formula:

CAGR: =((End Value/Start Value)^(1/(Periods - 1)) - 1

This entry was posted on Friday, February 25th, 2011 at 8:58 am and is filed under Excel. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.