Tutorials > Financial Modeling Build A Complete Dcf Valuation Model

Financial Modeling Build A Complete Dcf Valuation Model


Date: 4 August 2022 | Posted by: voska89
Financial Modeling Build A Complete Dcf Valuation Model
Last updated 4/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.36 GB | Duration: 5h 21m
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

Homepage
https://www.udemy.com/course/learn-how-to-value-a-company-and-build-a-dcf-model/


DOWNLOAD LINK


Links are Interchangeable - No Password - Single Extraction

See full article