CAGR

A end up calculating CAGR a lot in Excel. Exciting for me.

Here’s the macro-template for idiots I’ve finally found success with:

(last/first)^(1/(LastYear-FirstYear))-1

Have fun!



(Source: http://bit.ly/xVhTmM)