# How to Analyze Historical Data for Forecasting – Part 5

In my previous video posts (Part -1, Part - 2, Part - 3 and Part- 4) in the Forecasting series, I covered importance of historical analysis and how to project financial statements.

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.

In this video, I've explained how to forecast purchase of fixed assets and increase in net working capital.

You'll learn how to take a clue from past data.

[S3VIDEO file='https://www.financewalk.com/blog/videos/Analysis of Historical Data- Part 5.mp4' authurl='false' sitemap='true' vol='100']

Have any queries? Write in ‘Comments’ below.

Next Batch Starts on 11th March, 2019
- Classroom Course with Placement Assistance: Our Full-Time Financial Modeling Investment Banking Course (6 Weeks) starts on 11th March, 2019 and 2.5 Months Weekend Workshop starts on 6th April, 2019 in New Delhi, India.

- Online Course with Placement Assistance: Join our Online Financial Modeling Investment Banking course with Placement Assistance from anywhere in the world.

- CFA Level - I: 9th March, 2019

- See Testimonials.

Only a few seats remain. Interested candidates can contact me.

### 7 thoughts on “How to Analyze Historical Data for Forecasting – Part 5”

1. After this video is there any videos relating to analyzing part………….

• thank you sir.

2. Maybe I’m missing something , but this video doesn’t really tell me anything . It took some forecast figures form another source , copied them on to a key ratios sheet , and then calcuated theme as percentages of EBIT / EBITDA – no forecasting involved?

What was the purpose of this video ?

• Hi Peter,

This video tells you how to analyze historical data for forecasting. That’s precisely the name and the purpose of the article.

Want to Create a Lucrative Career in Investment Banking?