Forecasting with CAGR

To further dive into the MSFT stock data, we want to forecast the average close price on an annual basis using a Compound Annual Growth Rate (CAGR). The CAGR for a given investment will tell us how much that given investment (in this case the MSFT stock) would be expected to grow on an annual basis.

You can read more about CAGR here.

If you lost progress, load the workbook 3_5_CAGR.pbix from the Exercises folder on the Desktop.