Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Corporate Valuation Mastery - DCF | DDM | Relative Valuation
Rating: 4.5 out of 5(37 ratings)
1,088 students

Corporate Valuation Mastery - DCF | DDM | Relative Valuation

Unlock the secrets of corporate valuation and become an Excel valuation expert with our comprehensive course!
Last updated 7/2024
English

What you'll learn

  • Dividend Discount Model (DDM): Understand the intrinsic value of a company using the Dividend Discount Model and calculate required rates of return.
  • Growth Company Valuation: Learn to apply DDM to growth companies and calculate their intrinsic value.
  • Discounted Cash Flow (DCF) Analysis: Master the DCF method to forecast cash flows, calculate terminal values, and discount explicit period cash flows.
  • Working Capital Management: Understand and calculate working capital, and link it to the Free Cash Flow to Firm (FCFF).
  • Sensitivity Analysis: Perform sensitivity analysis to evaluate how changes in assumptions affect the valuation outcome.
  • Capital Structure Analysis: Understand the components of a company's capital structure and calculate the cost of debt and equity.
  • Options and Convertibles Valuation: Learn to value in-the-money convertibles and stock options using the treasury stock method.
  • Relative Valuation Techniques: Apply different relative valuation methods including PE, PBV, and PCF ratios to compare companies.
  • Comparable Company Analysis: Conduct comprehensive comparable company analysis to benchmark a target company's valuation.
  • Financial Modeling in Excel: Develop robust financial models in Excel, integrating various valuation methods and financial metrics.

Course content

3 sections115 lectures12h 45m total length
  • Corporate Valuations - Overview2:07
  • Ddm - Dividend Discount Model- Intrinsic Value5:42
  • Ddm - Dividend Discount Model- Required Rate Of Return6:31

    Apply the dividend discount model to infer the required rate of return from market price, intrinsic value, and the next-year dividend. Explore sensitivity with growth and data tables.

  • Ddm - Dividend Discount Model- Compare Intrinsic And Market Price5:04

    Demonstrates using the dividend discount model to compare intrinsic value and market price, signaling undervaluation or overvaluation and highlighting how dividends, growth, and cost of equity drive decisions.

  • Ddm - Intrinsic Value Of Growth Companies4:02

    Compute intrinsic value for growth companies with a two-stage dividend discount model, separating explicit cash flows 2008–2011 from a terminal value from 2012 onward using the dividend discount formula.

  • Ddm - Dividend Discount Model- Present Value8:12

    Explore the dividend discount model by calculating the present value of explicit cash flows and terminal value at 15%, learning to apply NPV formulas and assess sensitivity with data tables.

  • Introduction To Dcf4:53

    Explore a mechanical basic discounted cash flow exercise using a three-tab workbook—projection of free cash flow to the firm, capital structure, and cost of capital.

  • Forecasting Income Statement Ebitda6:26

    Learn to forecast revenue and EBITDA using growth rates and drivers, with costs as a percentage of sales (60% COGS, 6.5% SG&A) and EBITDA as revenue minus COGS and SG&A.

  • Understanding The Working Capital2:30

    Forecast working capital by estimating assets (accounts receivable, inventory, prepaid expenses) and liabilities (accounts payable, accrued expenses) as a percent of cogs for the free cash flow to the firm.

  • Completing The Working Capital Calculations2:42

    Forecast the income statement using a 13% depreciation of sales, compute EBIT from EBITDA, apply a 33% tax rate, and project capex at 13.3% of sales to derive FCFF.

  • Linking The Free Cash Flow To Firm Fcff7:06

    Learn how to link ebit, taxes, depreciation, capex, and changes in working capital to forecast free cash flow to the firm using current assets minus current liabilities.

  • Discounting The Explicit Period Cash Flows5:12

    Compute the present value of explicit period cash flows from the free cash flow to the firm with an 8% cost of capital, and compare npv and xnpv using dates.

  • Calculation Of Terminal Values6:49

    Compute terminal values using perpetuity growth and exit multiple methods for 2016 FCF, with g=4.5% and WACC=8%, yielding a 1227 terminal value and a 790 present value.

  • Dcf Valuation Summary6:22

    Compute the total enterprise value by summing the npv of the explicit period and terminal value, then derive the fair equity value and share price from net debt.

  • Dcf Sensitivity Analysis7:18

    Analyze sensitivity analysis of DCF valuations using two dimensional data tables to vary perpetuity growth and WACC, comparing perpetuity growth and EBITDA multiple methods to show valuation ranges.

  • Understanding The Capital Structure11:47

    Classify a company's capital structure into short-term debt, long-term debt, and equity-like instruments. Evaluate revolvers, bonds, convertible bonds, and convertible preferred stocks to understand wacc components.

  • Options Treasury Stock Method6:18

    Use the treasury stock method to analyze employee stock options, distinguishing in-the-money vs out-of-the-money, and show how 1,000 in-the-money options dilute shares and lower earnings per share.

  • Options Explained2:03

    Explore the treasury stock method for dilution, focusing on options exercisable versus outstanding, the lock-in period, and the role of strike and market prices in analysis.

  • Calculation Of In The Money Convertibles4:28

    analyze the calculation of in the money convertible securities from the capital structure, focusing on convertible preferred and convertible debt, using issue prices, conversion terms, and a market price test.

  • Calculation Of In The Money Stock Options5:10

    Compute in the money stock option proceeds using strike versus market price, apply an if condition in Excel, and assess the resulting share buyback and dilution.

  • Calculation Of Debt Equity Ratio4:06

    Calculate the fully diluted market value of equity by adjusting for options and convertibles, then compute total debt and the debt-to-equity ratio to reveal the capital structure.

  • Cost Of Debt Calculations4:05

    Use a synthetic rating method from Damodaran, based on EBIT and interest expense, to determine debt cost, then apply a small-cap spread to the risk-free rate and tax-adjust for 5.70%.

  • Cost Of Equity Calculation7:32

    Apply CAPM to calculate cost of equity using comparable analysis, unlevering and re-levering betas, with a 5% risk-free rate, 5% market risk premium, and ABC's 0.79 levered beta.

  • Enterprise Value Calculation Completing The Missing Links3:29

    Link the cost of capital to final discounted cash flow calculations, adjust debt, cash, and fully converted shares, and evaluate terminal value with exit multiples for valuation outcomes.

  • Introduction To Relative Valuation7:49

    Explore relative valuation by defining market value relative to key statistics and using equity and enterprise value multiples; build a comparable sheet to compare peers and assess value drivers.

  • Relative Valuations Enterprise Value And Equity Value5:18

    Explore enterprise value and equity value multiples, including EV/sales, EV/ebitda, EV/ebit, and price to earnings, and learn how to choose industry-relevant multiples for banks, telecom, and mining.

  • Relative Valuations Comparable Comp Sheet6:17

    Compare enterprise value and equity value multiples within an upstream oil and gas comparable sheet, highlighting EV to EBITDA and price to cash flows for Exxon, Shell, BP, and Petrobras.

  • Understanding Pe Ratio6:45

    Explore equity value multiples, especially price to earnings, and how they fit into relative valuations. Learn forward vs trailing p/e and how sector comparables determine overvaluation or undervaluation.

  • Forward And Trailing Pe3:18

    Compare forward and trailing p/e ratios using current price and either expected or historical earnings; investors should prioritize forward p/e for evaluating today's price, with trailing p/e offering historical context.

  • Advantages And Limitations Of Pe4:26

    Examine how negative earnings render price-to-earnings non meaningful and how accounting policy differences and balance sheet risk affect comparability.

  • Understanding Pbv Ratio2:13

    Explore the price to book value (pbv) and book value per share, or shareholder's equity, for relative valuation of tangible assets, with banking often relying on pbv.

  • Why Pbv Is Used In Banks8:10

    Use price to book value to value banks, because money-based assets and deposits are marked to market, making book value a close proxy for market value.

  • Pbv And Roe Used For Energy Sector2:12

    Understand how price to book value equals price to earnings times ROE, and how a low ROE with high PBV indicates overvaluation, especially in energy sectors with government-regulated ROE.

  • Understanding Pcf Ratio3:00

    Explore how price to cash flows supplements price to earnings in relative valuation, comparing sector and company cash flow per share and using cash flow statements to assess cash generation.

  • Why Pcf Used In Oil Gas Gold Real Estate3:03

    Identify sectors valued by cash flows—gold, oil and gas, metals, mining, real estate—with stable cash flows, and note price-to-cash-flow limits and takeover signals.

Requirements

  • Basic Understanding of Finance: Familiarity with fundamental financial concepts such as cash flow, revenue, expenses, and net income.
  • Microsoft Excel Proficiency: Basic to intermediate skills in Microsoft Excel, including functions, formulas, and data analysis tools.
  • Mathematics and Statistics: A good grasp of basic mathematics and statistics to understand and apply valuation models.
  • Accounting Knowledge: Understanding of basic accounting principles and financial statements (income statement, balance sheet, cash flow statement).
  • Analytical Skills: Ability to analyze financial data and interpret results.

Description

Course Introduction

Welcome to "Corporate Valuation - Beginner to Pro in Microsoft Excel," a comprehensive course designed to equip you with the skills and knowledge to master corporate valuation using Microsoft Excel. Whether you are a novice or an experienced professional, this course will take you from the basics of valuation models to advanced techniques, providing you with practical, real-world applications.

Section 1: Corporate Valuation Fundamentals

In this section, you'll start with an overview of corporate valuations, understanding their significance and application. You'll dive into the Dividend Discount Model (DDM), learning how to calculate intrinsic value, required rate of return, and compare intrinsic and market prices. This section also covers the intrinsic value of growth companies, present value concepts, and introduces the Discounted Cash Flow (DCF) model. You'll forecast income statements and EBITDA, understand working capital, link free cash flow to the firm (FCFF), and discount explicit period cash flows. The section concludes with the calculation of terminal values, DCF valuation summary, sensitivity analysis, understanding capital structure, and various methods for calculating cost of debt and equity.

Section 2: Comprehensive Relative Valuation Training

This section delves into relative valuation techniques, starting with an introduction and the different types of relative valuation. You'll explore earning and book multiples, EV ratios, PE ratios, and PBV ratios, including their advantages and disadvantages. The course will guide you through the process of finding comparable companies, conducting benchmarking analysis, and working on various financial statements. You'll also learn about trading multiples, industry averages, and relative valuation sheets, providing a holistic understanding of how to perform comprehensive relative valuations.

Section 3: DCF - Discounted Cash Flow

In this section, you'll focus on the Discounted Cash Flow (DCF) method, beginning with an introduction and course outline. You'll explore various valuation methodologies, basic concepts of DCF, terminal value concepts, and the common traits of DCF values. The section covers important accounting equations, the advantages of DCF, steps involved in the DCF process, and predicting cash flows. You'll work through a case study to predict terminal values, calculate cost of debt and equity, and understand beta. The section concludes with creating a sensitivity table, finalizing the case study, and preparing for common interview questions.

Conclusion

By the end of this course, you will have a deep understanding of corporate valuation techniques, including DDM, DCF, and relative valuation methods. You will be able to apply these concepts using Microsoft Excel to analyze and value companies effectively. Whether you aim to enhance your professional skills or advance your career, this course provides the essential tools and knowledge to achieve your goals.

Who this course is for:

  • Finance Students: Those pursuing finance-related degrees who want to deepen their understanding of corporate valuation.
  • Investment Bankers: Professionals in investment banking looking to enhance their valuation skills.
  • Financial Analysts: Analysts seeking to improve their ability to value companies and assess investment opportunities.
  • Accountants: Accountants interested in gaining insights into valuation techniques and financial modeling.
  • Corporate Finance Professionals: Individuals working in corporate finance who want to refine their valuation methods.
  • Investors and Traders: Investors and traders aiming to make informed decisions based on company valuations.
  • Entrepreneurs and Business Owners: Entrepreneurs and business owners seeking to understand the value of their businesses and potential investment opportunities.
  • Consultants: Consultants who provide financial advice and need a robust understanding of valuation models.
  • Aspiring Finance Professionals: Individuals aspiring to start a career in finance, investment banking, or financial analysis.
  • Anyone Interested in Finance: Anyone with a keen interest in corporate finance and valuation techniques, regardless of their background or experience level.