How to Analyze Historical Data for Forecasting – Part 6

 

In my previous video posts in the Forecasting series, I covered importance of historical analysis and how to project financial statements.

See the previous videos in this series here:

1. How to Analyze Historical Data for Forecasting – Part 1

2. How to Analyze Historical Data for Forecasting – Part 2

3. How to Analyze Historical Data for Forecasting – Part 3

4. How to Analyze Historical Data for Forecasting – Part 4

5. How to Analyze Historical Data for Forecasting – Part 5

I also covered the different variables that we need to forecast based on historical data and the concept of Net Debt level. I also explained with an example how to calculate Earnings Before Interest and Tax (EBIT) and its year-on-year growth in percentage(%) terms.

EBIT is an essential variable for calculating DCF valuation.

I also explained how to forecast purchase of fixed assets and increase in net working capital.

In this video, you’ll learn how to use AVERAGE function in Microsoft Excel to calculate the average of the growth percentages.

Have any queries? Write in ‘Comments’ below.

Free Download: Financial Modeling Videos



View All BIWS Courses –Free $97 Bonus for FinanceWalk Readers

1x1.trans How to Analyze Historical Data for Forecasting   Part 6

Speak Your Mind

*