Tag Archives: cagr

Calculating CAGR for historical data with Excel

One very common task that we are faced with when analyzing historical data is the calculation of compound annual growth rate (CAGR). While possible to calculate by hand, it’s a somewhat tedious equation so fortunately for us Microsoft Excel has built in functions to do the calculations for us. This quick tutorial will show you how, using historical EPS data for Caterpillar (CAT). Continue reading

Tagged , ,