Calculating CAGR in Excel | Financial Modeling Tutorial | Excel Tutorial | 2020 [Update] | Part(5/5)

Показать описание

In this video, we will learn how to calculate CAGR in Excel

We have an Income Statement of a firm that we help us in calculating CAGR
While Calculating CAGR we will use IFERROR
So the Formula for CAGR will be
The Present Year Divide by the Base Year raises to 1 divide by period ( here the period is 4 yrs )
The Same Formula will be Applied for the Forecasting Column Just the period will change to 5yr
Now Drag the formula to the whole column and get the Calculations done in it.

Make the requires Columns for Trend Analysis
Then Calculate Trend Analysis For it the Formula will be :
IFERROR(Sales of 2015 Divide by Sales of 2014 - 1),"NM"
Drag the Formula to all the columns of Trend Analysis

You can make changes in the datasheet i.e changing the color, alignment, etc.

Calculating CAGR in Excel | Project Finance Tutorial | Excel Tutorial | 2020 [Update]
#CAGRcalculation #Excel #FinancialModelingTutorial #YodaLearning

Keep Yourself Updated. Follow us Now !!