1

Why value a company?

2

Company Valuation - Theoretical Framework

3

The investor's perspective

4

Calculating Unlevered free cash flows

5

Using an appropriate discount factor

6

Estimating cost of debt

7

Estimating cost of equity

8

Forecasting future cash flows

9

Caclulating Terminal value

10

Discounting future cash flows

11

Calculating Enterprise and Equity value of the firm

12

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

13

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

14

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

15

A Glimpse At the Company We Are Valuing - Cheeseco

16

Modeling the Top Line of the Financial Model

17

This Is How You Can Build Flexible Financial Models in Excel

18

Modeling Other Items: Other Revenues and Cogs

19

Modeling Other Items: Operating Expenses and D&A

20

Modeling Other Items: Interest Expenses, Extraordinary Items and Taxes

21

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

22

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

23

Learn How to Calculate "Days"

24

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

25

Forecasting Property Plant & Equipment, Other assets and Other liabilities

26

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

27

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

28

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

29

Completing the Output BS Sheet For the Historical Period

30

Learn How to Calculate Unlevered Free Cash Flows

31

Important! Reconcile UFCF to Net Cash Flow

32

A Very Useful Lesson! Learn How To Calculate Cash Flows

33

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

34

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

35

Introducing Weighted Average Cost of Capital and Perpetuity Growth Rate

36

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

37

Calculating Continuing Value and Enterprise Value of the Business

38

Final Steps! Calculate Equity Value of the Business Under Consideration

39

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

40

Excel tools in Practice - An Application of Goal Seek

41

Recap of the Financial Model with Charts and Hypothesis Testing