Learn How To Value A Company And Build A Dcf Model

The Ultimate Guide to Company Valuation For Aspiring Investment Bankers and Corporate Finance Practitioners

Last updated 2022-01-10 | 4.5

- Be able to build a Cash Flow statement
- Know how to value a company
- Be able to build a Valuation model from scratch

What you'll learn

Be able to build a Cash Flow statement
Know how to value a company
Be able to build a Valuation model from scratch
Know how to create a model with multiple scenarios
Be able to perform sensitivity analysis
Know how to create professional and good-looking advanced charts

* Requirements

* Basic Microsoft Excel knowledge
* A high level of concentration
* Basic understanding of Financial Statements

Description

Would you like to learn how to value a company?

Even people who don't have a Finance degree can take this course and learn how to build a complete Discounted Cash Flow Model! 

Attention! You will have to go through the videos and the course materials in order to obtain the promised result! 

If you want to:

  • Improve your Microsoft Excel modeling skills

  • Learn how to value a company

  • Understand what drives a company's value

Then this is the right course for you!

What we offer:

  • Well designed and easy to understand materials

  • Detailed and comprehensible explanations

  • Regular course updates

By the completion of this course you will:

  • Be able to build a Cash Flow statement

  • Know how to value a company

  • Be able to build a Valuation model from scratch

  • Know how to create a model with multiple scenarios

  • Be able to perform sensitivity analysis

  • Know how to create professional and good-looking advanced charts

The instructor of this course has extensive experience in Financial Modeling:

  • Worked in the Financial advisory unit of a top-tier consulting firm

  • Experience in M&A transactions carried out in Italy, Germany, Switzerland and Poland

  • Worked in the in-house Mergers & Acquisitions department of one of the largest semiconductor firms in the world

  • Financial advisor in multiple M&A deals with sizes ranging from €2 million up to €5 billion


About the course:

  • An unconditional Udemy 30 day money-back guarantee – because we believe in the quality of our content

  • No significant previous experience is needed in order to understand the course well and benefit fully from its content

  • Unlimited access to all course materials

  • Emphasis on learning by doing

  • You can always contact us for any clarification free of charge

  • Our goal is to take your Valuation skills to the next level

Make an investment that will pay for itself in terms of career perspectives, positive feedback and personal growth. 

Just go ahead and subscribe to this course! Nowadays the job market has become very competitive. If you don't acquire these skills now you will miss an opportunity to separate yourself from others. Don't risk your future success! 

Let's start learning together now! 

Who this course is for:

  • Aspiring Investment Bankers
  • Graduates who pursue a career in Corporate Finance
  • Professionals who would like to deepen their Valuation skills

Course content

11 sections • 76 lectures

Why value a company? Preview 01:36

Company valuation - Theoretical framework Preview 10 pages

The investor's perspective Preview 03:12

What drives a firm's value? Preview 01:57

Calculating Unlevered free cash flows Preview 04:33

Using an appropriate discount factor Preview 03:58

Estimating cost of debt Preview 00:55

Estimating cost of equity Preview 04:41

Forecasting future cash flows Preview 02:31

Caclulating Terminal value Preview 02:24

Discounting future cash flows Preview 01:44

Calculating Enterprise and Equity value of the firm Preview 01:10

Learning by doing - Learn how to value a company - Case study introduction Preview 01:03

A quick summary of the various stages of a complete DCF valuation Preview 06:34

Let's go through the structure of the DCF model we will create in Excel Preview 02:57

A glimpse at the company we are valuing - Cheeseco Preview 01:11

Modeling the top line of the financial model Preview 03:56

This is how you can build flexible financial models in Excel Preview 02:16

Modeling other items: Other revenues and Cogs Preview 03:51

Modeling other items: Operating expenses and D&A Preview 02:27

Modeling other items: Interest expenses, Extraordinary Items and Taxes Preview 02:43

How to forecast balance sheet items - The practical and easy to understand way Preview 00:42

A key concept for finance practitioners - the "Days" methodology Preview 01:34

Learn how to calculate "Days" Preview 01:20

How to use "Days" in order to project the future development of some BS items Preview 02:22

Forecasting Property, plant & equipment, Other assets and Other liabilities Preview 02:21

Excel best practices! Create a good-looking and clean output sheet in your model Preview 02:36

Applying what we learned in practice - Populating the P&L sheet Preview 02:29

This is how you can create a clean output Balance Sheet in your financial model Preview 01:53

Completing the Output BS Sheet For the Historical Period Preview 03:43

Learn how to calculate unlevered free cash flows Preview 03:18

Important! Reconcile UFCF to Net Cash flow Preview 01:53

A very useful lesson! Learn how to calculate cash flows Preview 06:38

Arriving to actual net cash flow figures and performing a check with cash Preview 03:57

The fast and effective way to modify multiple cell references in Excel Preview 04:01

Introducing weighted average cost of capital and perpetuity growth rate Preview 01:55

Learn how to find the present value of future cash flows in financial models Preview 02:59

Calculating continuing value and enterprise value of the business Preview 02:21

Final steps! Calculate equity value of the business under consideration Preview 01:27

Excel tools in practice - sensitivity analysis for WACC and perpetuity growth Preview 04:40

Excel tools in practice - An application of Goal Seek Preview 01:41

Recap of the financial model with charts and hypothesis testing Preview 04:27

Congratulations! You made it! Preview 02:06

Introduction to Mergers & Acquisitions Preview 15 pages

Organizing external inputs in a 'Drivers' sheet Preview 03:54

The input data we will work with Preview 01:27

Forecasting Tesla's expected deliveries Preview 14:08

Comparing delivery figures with the ones of industry peers Preview 02:54

Estimating an average selling price of Tesla vehicles Preview 04:50

Calculating automotive revenue Preview 04:37

Peer comparison: Gross profit % Preview 02:18

Calculating automotive gross profit Preview 02:49

Calculating automotive cost of sales Preview 02:04

Forecasting 'energy' and 'services' revenue Preview 02:53

Calculating 'energy' and 'services' gross profit and cost of sales Preview 02:47

Forecasting operating expenses Preview 05:16

Building a fixed asset roll forward: estimating Capex Preview 06:20

Building a fixed asset roll forward: D&A schedule Preview 05:42

Peer comparison: D&A as a percentage of revenues Preview 01:26

Calculating DSO, DIO, DPO Preview 01:54

Producing a clean P&L output sheet Preview 01:29

Fill in the P&L output sheet Preview 01:54

Calculating investments in working capital Preview 01:58

Forecasting unlevered free cash flow Preview 05:31

Forecasting other assets Preview 03:53

Forecasting other liabilities Preview 02:13

Completing unlevered free cash flow Preview 03:42

Modeling Tesla's financing needs in the forecast period Preview 04:55

Calculating net income Preview 01:23

Bridging unlevered free cash flow to net cash flow Preview 03:58

Balancing the Balance sheet Preview 00:57

Estimating Weighted average cost of capital (WACC) Preview 06:07

Performing discounted cash flow valuation (DCF) Preview 03:34

Calculating enterprise value, equity value, and price per share Preview 02:10

Final comments Preview 03:49

Next steps Preview 00:29