Financial Modeling: Build A Complete Dcf Valuation Model

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

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 skillsLearn how to value a companyUnderstand what drives a company's valueThen this is the right course for you!What we offer:Well designed and easy to understand materialsDetailed and comprehensible explanationsRegular course updatesBy the completion of this course you will:Be able to build a cash flow statementKnow how to value a companyBe able to build a valuation model from scratchKnow how to create a model with multiple scenariosBe able to perform sensitivity analysisKnow how to create professional and good-looking advanced chartsThe instructor of this course has extensive experience in Financial Modeling:Worked in the Financial advisory unit of a top-tier consulting firmExperience in M&A transactions carried out in Italy, Germany, Switzerland and PolandWorked in the in-house Mergers & Acquisitions department of one of the largest semiconductor firms in the worldFinancial advisor in multiple M&A deals with sizes ranging from €2 million up to €5 billionAbout the course:An unconditional Udemy 30 day money-back guarantee – because we believe in the quality of our contentNo significant previous experience is needed to understand the course well and benefit fully from its contentUnlimited lifetime access to all course materialsEmphasis on learning by doingYou can always contact us for any clarification free of chargeOur goal is to take your Valuation skills to the next levelMake 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! 

Overview

Section 1: Introduction to Company Valuation

Lecture 1 Why value a company?

Lecture 2 Company valuation - Theoretical framework

Lecture 3 The investor's perspective

Lecture 4 What drives a firm's value?

Section 2: The technical tools you need when valuing a company

Lecture 5 Calculating Unlevered free cash flows

Lecture 6 Using an appropriate discount factor

Lecture 7 Estimating cost of debt

Lecture 8 Estimating cost of equity

Lecture 9 Forecasting future cash flows

Lecture 10 Caclulating Terminal value

Lecture 11 Discounting future cash flows

Lecture 12 Calculating Enterprise and Equity value of the firm

Section 3: Learn how to build a Discounted Cash Flow model in Excel - Introduction

Lecture 13 Learning by doing - Learn how to value a company - Case study introduction

Lecture 14 A quick summary of the various stages of a complete DCF valuation

Lecture 15 Let's go through the structure of the DCF model we will create in Excel

Lecture 16 A glimpse at the company we are valuing - Cheeseco

Section 4: Forecasting of key P&L items

Lecture 17 Modeling the top line of the financial model

Lecture 18 This is how you can build flexible financial models in Excel

Lecture 19 Modeling other items: Other revenues and Cogs

Lecture 20 Modeling other items: Operating expenses and D&A

Lecture 21 Modeling other items: Interest expenses, Extraordinary Items and Taxes

Section 5: Forecasting of key Balance Sheet items

Lecture 22 How to forecast balance sheet items - The practical and easy to understand way

Lecture 23 A key concept for finance practitioners - the "Days" methodology

Lecture 24 Learn how to calculate "Days"

Lecture 25 How to use "Days" in order to project the future development of some BS items

Lecture 26 Forecasting Property, plant & equipment, Other assets and Other liabilities

Section 6: Creating clean output sheets

Lecture 27 Excel best practices! Create a good-looking and clean output sheet in your model

Lecture 28 Applying what we learned in practice - Populating the P&L sheet

Lecture 29 This is how you can create a clean output Balance Sheet in your financial model

Lecture 30 Completing the Output BS Sheet For the Historical Period

Section 7: Learn how to calculate Unlevered Free Cash Flows and Net Cash Flows

Lecture 31 Learn how to calculate unlevered free cash flows

Lecture 32 Important! Reconcile UFCF to Net Cash flow

Lecture 33 A very useful lesson! Learn how to calculate cash flows

Lecture 34 Arriving to actual net cash flow figures and performing a check with cash

Lecture 35 The fast and effective way to modify multiple cell references in Excel

Section 8: Calculating present value of cash flows within the forecast period

Lecture 36 Introducing weighted average cost of capital and perpetuity growth rate

Lecture 37 Learn how to find the present value of future cash flows in financial models

Section 9: Calculating continuing value, enterprise value and equity value of the business

Lecture 38 Calculating continuing value and enterprise value of the business

Lecture 39 Final steps! Calculate equity value of the business under consideration

Section 10: Additional analyses accompanying the financial model

Lecture 40 Excel tools in practice - sensitivity analysis for WACC and perpetuity growth

Lecture 41 Excel tools in practice - An application of Goal Seek

Lecture 42 Recap of the financial model with charts and hypothesis testing

Lecture 43 Congratulations! You made it!

Lecture 44 Introduction to Mergers & Acquisitions

Section 11: Valuation of Tesla

Lecture 45 Organizing external inputs in a 'Drivers' sheet

Lecture 46 The input data we will work with

Lecture 47 Forecasting Tesla's expected deliveries

Lecture 48 Comparing delivery figures with the ones of industry peers

Lecture 49 Estimating an average selling price of Tesla vehicles

Lecture 50 Calculating automotive revenue

Lecture 51 Peer comparison: Gross profit %

Lecture 52 Calculating automotive gross profit

Lecture 53 Calculating automotive cost of sales

Lecture 54 Forecasting 'energy' and 'services' revenue

Lecture 55 Calculating 'energy' and 'services' gross profit and cost of sales

Lecture 56 Forecasting operating expenses

Lecture 57 Building a fixed asset roll forward: estimating Capex

Lecture 58 Building a fixed asset roll forward: D&A schedule

Lecture 59 Peer comparison: D&A as a percentage of revenues

Lecture 60 Calculating DSO, DIO, DPO

Lecture 61 Producing a clean P&L output sheet

Lecture 62 Fill in the P&L output sheet

Lecture 63 Calculating investments in working capital

Lecture 64 Forecasting unlevered free cash flow

Lecture 65 Forecasting other assets

Lecture 66 Forecasting other liabilities

Lecture 67 Completing unlevered free cash flow

Lecture 68 Modeling Tesla's financing needs in the forecast period

Lecture 69 Calculating net income

Lecture 70 Bridging unlevered free cash flow to net cash flow

Lecture 71 Balancing the Balance sheet

Lecture 72 Estimating Weighted average cost of capital (WACC)

Lecture 73 Performing discounted cash flow valuation (DCF)

Lecture 74 Calculating enterprise value, equity value, and price per share

Lecture 75 Final comments

Section 12: Multiples valuation

Lecture 76 What are valuation multiples and why we use them?

Lecture 77 What types of valuation multiples are there?

Lecture 78 Trading vs transaction valuation multiples

Lecture 79 Main principles of multiples valuation

Lecture 80 Comparison of earnings multiples (P/E vs EV/EBITDA)

Lecture 81 Introduction to the exercise

Lecture 82 High-level assessment of peer companies

Lecture 83 Assessment of P&L data - comparable companies

Lecture 84 How to adjust EBIT - theoretical framework

Lecture 85 How to adjust EV - theoretical framework

Lecture 86 How to adjust EBIT - practical example - Volkswagen

Lecture 87 How to adjust EV - practical example - Volkswagen

Lecture 88 Conclusion of the practical exercise

Section 13: Next steps

Lecture 89 Next steps

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