Click to turn the sound on
8 hours
14 lectures
14 tests
Lecture 1/14: Overview of Sample Co business and input data. Getting started with Excel
Finance

Financial Modelling in Excel

You will learn how to…
Analyze operating and financial performance
Read and comprehend bank financial statements
Confidently use Microsoft Excel
Perform financial analysis of your project
Natasha Zagvozdina
Ex-Renaissance Capital
Lecturer's bio
Lecturer's bio

Natasha has got 14 years of experience in the investment banking industry, with the majority of the time dedicated to analyzing consumer goods and retail companies. Ms. Zagvozdina was part of EMEA equity research department at Morgan Stanley. Day-to-day duties as a lead consumer analyst included financial analysis (financial modeling, forecasting, and valuation), publishing of in-depth research reports on retail and consumer goods companies and regular marketing of her ideas to the largest investors in the US, UK, and continental Europe.

Video course
Started: 3488
Rating: 90%

What is this course about?

This course on advanced financial modelling in Excel is about equity valuation. You will see how financial model is being built in Excel in the real time by a professional research analyst. You will learn how to use DCF method, multiples based analysis and sum of the parts valuation. The speaker will also give you a guide on how to read financial accounts, what major changes in the key figures can mean and how to make assumptions when doing a forecast. You will learn how to value any company and will not allow anyone to fool you on the business valuations.

 

Who is this course for?

  • VPs of sales
  • Strategic planning managers
  • Analysts
  • Everyone who works with numbers and tables
  • Financial managers

Course Program

2
16:59
Airline catering division: sales modelling
3
16:25
Airline catering division: historical cost items reconstruction
4
15:00
Airline division: costs modelling and P&L calculation
5
15:00
Event catering division modelling
6
15:22
RLH division modelling
7
16:07
Sample Co P&L modelling
8
27:00
Sample Co Cash Flow statement modelling
9
23:12
Sample Co Balance Sheet modelling, finalisation of CF statement modelling
10
13:09
Getting ready for DCF valuation
11
17:41
WACC calculation
12
11:33
DCF valuation
13
17:19
Multiples and sum of the parts valuation
14
10:54
Closing remarks and useful pieces of advice Exam
Get diploma