1

Why value a company?

2

Company Valuation - Theoretical Framework

3

The investor's perspective

4

What drives a firm's value?

5

Calculating Unlevered free cash flows

6

Using an appropriate discount factor

7

Estimating cost of debt

8

Estimating cost of equity

9

Forecasting future cash flows

10

Caclulating Terminal value

11

Discounting future cash flows

12

Calculating Enterprise and Equity value of the firm

13

Learning by Doing - Learn How to Value a Company - Introduction to Case Study 2

14

A Quick Summary of The Various Stages of a Complete DCF Valuation

15

Let's Go Through The Structure of the DCF Model That We Will Create in Excel

16

A Glimpse At the Company We Are Valuing - Cheeseco

17

Modeling the Top Line of the Financial Model

18

This Is How You Can Build Flexible Financial Models in Excel

19

Modeling Other Items: Other Revenues and Cogs

20

Modeling Other Items: Operating Expenses and D&A

21

Modeling Other Items: Interest Expenses, Extraordinary Items and Taxes

22

How to Forecast Balance Sheet Items - The Practical and Easy to Understand Way

23

A Key Concept for Finance Practitioners - the "Days" Methodology

24

Learn How to Calculate "Days"

25

How to Use "Days" in Order to Project the Future Development of Some BS Items

26

Forecasting Property Plant & Equipment, Other assets and Other liabilities

27

Excel Best Practices! Create a Good-looking and Clean Output Sheet in Your Model

28

Applying What We Learned in Practice - Populating the P&L Sheet

29

This is How you Can Create a Clean Output Balance Sheet in Your Financial Model

30

Completing the Output BS Sheet For the Historical Period

31

Learn How to Calculate Unlevered Free Cash Flows

32

Important! Reconcile UFCF to Net Cash Flow

33

A Very Useful Lesson! Learn How To Calculate Cash Flows

34

Arriving to Actual Net Cash Flow Figures and Performing a Check with Cash

35

The Fast and Effective Way to Modify Multiple Cell References in Excel

36

Introducing Weighted Average Cost of Capital and Perpetuity Growth Rate

37

Learn How to Find The Present Value of Future Cash Flows in Financial Models

38

Calculating Continuing Value and Enterprise Value of the Business

39

Final Steps! Calculate Equity Value of the Business Under Consideration

40

Excel Tools in Practice - Sensitivity Analysis for WACC and Perpetuity Growth

41

Excel tools in Practice - An Application of Goal Seek

42

Recap of the Financial Model with Charts and Hypothesis Testing