Compound Annual Growth Rates (CAGR) in Excel

Please purchase the course before starting the lesson.

CAGR (compound annual growth rate) is a common requirement in spreadsheets. What we are generally asking is what is the average growth in an amount over a number of years, taking compounding into account.

There is unfortunately no CAGR formula in Excel currently but there are a few ways of achieving it with other functions.

To see the full course contents click here.

Back to: Online Financial Modelling, Budgeting and Forecasting Course > Time Value of Money- Debt, NPV, IRR