Discounted Cash Flow (“DCF”) - ppt video online download (2024)

Presentation on theme: "Discounted Cash Flow (“DCF”)"— Presentation transcript:

1 Discounted Cash Flow (“DCF”)
Section 1 Discounted Cash Flow (“DCF”)

2 PV of projection period
Valuation implied by a DCF model is known as the intrinsic value, as opposed to the market value Important alternative to market-based valuation techniques such as comparable companies and precedent transactions Forward looking, focus on cash generation, recognise time value of money Projected FCF is derived from a variety of assumptions and judgments about its expected financial performance DCF – Overview Overview Free Cash Flow Income Statement Earning before interest and tax (“EBIT”) Less: Taxes (at the Marginal Tax Rate) = EBIAT Balance Sheet Plus: Depreciation and Amortization Less: Capex Less: Increase/(Decrease) in NWC Cash Flow Statement = FCF DCF PV of projection period PV of terminal value

3 DCF – Key drivers Driver Comment Financial Projections
Management forecasts Wall Street consensus estimates Generally helpful when performing DCF based on more than one operating scenario Equity Risk Premium Financial and market trends, recommended US equity risk premium (vs. US treasury bond): 5.00% % Cost of Equity and Weighted Average Cost of Capital (“WACC”) Equity Beta Company’s predicted Beta Historical adjusted Beta, past two or five years, e.g. Bloomberg Cross check with Beta for peer companies Capital Structure Forward looking, or expected Capital Structure Correspond expected interest rate Risk-Free Rate Long-term treasury security as the proxy for risk free rate Shorter-term can be appropriate if warranted by the circ*mstance (finite life and no terminal value) Size Premium Greater risk for smaller companies, e.g. Ibbotson Size premium is normally added to the Cost of Equity 3

4 DCF – FCF Calculation

5 DCF – WACC Cost of Equity (re) Cost of Debt (rd) CAPM:
rf : risk-free rate rm: expected return on the market SP: size premium Beta calculation: Unlevering Beta (peer group): βL: levered or equity Beta βU: unlevered Beta 2) Leveraged Beta (target): rd: long-term cost of debt based on the current yield on its existing term loan Market interest rate that the firm has to pay on its borrowing. It depends upon three components: The general level of interest rates The default premium The firm’s tax rate Alternatively, rd can be extrapolated from that of its peers Beta – measure of the covariance between the rate of return on a company’s stock and the overall market return

6 DCF – WACC Calculation and output

7 Comparable Company Analysis (“Trading Comps”)
Section 2 Comparable Company Analysis (“Trading Comps”)

8 Trading Comps – Identify Key Characteristics
Business Profile Sector – industry or markets in which a company operates Products and services – core business model Customers and end markets – opportunities and risks of underlying markets Distribution channels – key driver of operating strategy and performance Geography – different fundamental business drivers and characteristics for different regions Financial Profile Size – similar size in a given sector are more likely to have similar multiples Profitability – ability to convert sales into profit, “margins” Growth profile – historical and estimated future financial performance Return on investment – ability to provide earnings to its capital providers Credit profile – creditworthiness as a borrower Information can be found on Google Finance (open to all), Bloomberg / Factset / Capital IQ (subscription required) or Competition Sections in company presentations / annual reports Remember to check valuation date, financials refer to the same period (LTM and projected )

9 Trading Comps – Key Matrix
Claim of equity investors Claim of debt investor Basic Shares Outstanding In-the-Money Options and Warrants + + In-the-Money Convertibles

10 Trading Comps – ConAgra / RalcorpTransaction
Note: Key multiples for Public Comps: EV / Revenue EV / EBITDA EV / EBIT P / E …But why not EV / Net Income?...

11 Precedent Transaction Analysis (“M&A Comps”)
Section 3 Precedent Transaction Analysis (“M&A Comps”)

12 M&A Comps – Points to Note
Source of information? Public Targets: proxy statements, company fillings, equity and fixed income research reports, press releases Private targets: depends on type of acquirer and/or acquisition financing WSJ Deal Journal / Bloomberg / Factset / Capital IQ Deal Dynamics! Strategic buyer vs. financial sponsor Motivations Sale process and nature of the deal Purchase consideration Industry + Geography + Size + Time

13 M&A Comps

14 Football Field – Valuation Summary

15 What do investment banks do?
Corporates Corporates are companies that actually make products or provide services Their customers could be other businesses, consumers, or both Professional services Consulting firms City law firms Audit Tax Risk Give clients strategy advice Improve management Technology Legal aspects of the functioning of their businesses Disputes with other parties Corporate finance Examples: Markets M&A: Advise corporates on mergers, sales and purchases of companies and corporate restructuring Equity: Advise corporates on initial public offerings (IPOs) of shares on a public exchange and further offerings of share Debt: Advise on loan packages for corporate clients which may be funded by them or institutional investors Goldman Sachs Morgan Stanley JP Morgan Credit Suisse Deutsche Bank UBS Barclays Research: Gather and interpret market data for trading or sales colleagues, or for clients Sales: Advise clients on potential trades, typically institutional investors or corporates Trading: Trade shares, bonds and other tradable assets with and on behalf of clients, typically institutional investors or corporates Private equity firms Asset management firms Hedge fund managers Invest money in shares in companies, often taking private control of publicly-listed companies They aim to improve the businesses they invest in and then sell their stake later for a profit Invest money entrusted to them by their clients, usually pension funds, insurance companies and retail banks, which hold large pools of individual savings Tend to stay “long”, that is, they hold assets for the long term Invest money entrusted to them by various investors Tend to use a variety of complex investment strategies, including short selling (selling borrowed shares hoping their value will fall before they have to buy them back), using borrowed money, and using derivatives

16 Map of an investment bank
Corporate finance Markets M&A Capital markets (ECM/DCM) Loan finance Trading Sales Research Structured finance Syndication Asset management Specialists in particular products, industries or regions are found across the bank Product specialists Industry specialists Regional specialists Compliance Finance Risk management Operations IT

Download ppt "Discounted Cash Flow (“DCF”)"

Discounted Cash Flow (“DCF”) -  ppt video online download (2024)

FAQs

How do you calculate discounted cash flow DCF? ›

The discounted cash flow (DCF) formula is equal to the sum of the cash flow in each period divided by one plus the discount rate (WACC) raised to the power of the period number.

How to learn DCF valuation? ›

The following steps are required to arrive at a DCF valuation:
  1. Project unlevered FCFs (UFCFs)
  2. Choose a discount rate.
  3. Calculate the TV.
  4. Calculate the enterprise value (EV) by discounting the projected UFCFs and TV to net present value.
  5. Calculate the equity value by subtracting net debt from EV.
  6. Review the results.

How to forecast revenue growth rate in DCF? ›

One way to estimate the growth rate in a DCF model is to look at the historical growth of the company or project. You can use the past financial statements or projections to calculate the average annual growth rate of the cash flows over a certain period.

How do you calculate free cash flow for DCF valuation? ›

To calculate the Free Cash Flow (FCF) of the company for each year of the forecast period, you must use the formula: Revenue - COGS - OPEX - Taxes + D&A - CAPEX - Change in WC. Additionally, you should calculate the tax rate and effective tax rate of the company using historical data or statutory rates.

What is the difference between NPV and DCF? ›

The main difference between discounted cash flow vs. net present value is that net present value subtracts upfront year 0 costs (in actual dollars estimated) from the sum of the present value of the cash flows. The discounted cash flow method doesn't subtract these initial costs that include capital expenditures.

Is DCF Modelling hard? ›

No, DCF (Discounted Cash Flow) analysis is not necessarily the hardest analysis in finance. It is a widely used method to determine the value of an investment based on its expected future cash flows, but its accuracy and usefulness depends on the quality and reliability of the inputs and assumptions used.

Do you need a 3 statement model for DCF? ›

Three-statement models are the foundation on which more advanced financial models are built, such as discounted cash flow (DCF) models, merger models, leveraged buyout (LBO) models, and various other types of financial models.

What is a simple DCF model? ›

A DCF model is a specific type of financial modeling tool used to value a business. DCF stands for Discounted Cash Flow, so a DCF model is simply a forecast of a company's unlevered free cash flow discounted back to today's value, which is called the Net Present Value (NPV).

What is the first step in DCF valuation? ›

The first step in the DCF model process is to build a forecast of the three financial statements based on assumptions about how the business will perform in the future. On average, this forecast typically goes out about five years. Of course, there are exceptions, and it may be longer or shorter than this.

Is DCF a good valuation technique? ›

DCF Valuation is extremely sensitive to assumptions related to perpetual growth rate and discount rate. Any minor tweaking here and there, and the DCF Valuation will fluctuate wildly and the fair value so generated won't be accurate. It works best only when there is a high degree of confidence about future cash flows.

What does DCF tell you? ›

Discounted cash flow (DCF) is a method of valuation used to determine the value of an investment based on its return in the future–called future cash flows. DCF helps to calculate how much an investment is worth today based on the return in the future.

How to DCF in Excel? ›

To calculate the DCF in Excel, follow these steps:
  1. Step 1: Organize Your Data. ...
  2. Step 2: Calculate Present Value for Each Cash Flow. ...
  3. =CashFlow / (1 + DiscountRate)^Year. ...
  4. =B2 / (1 + $F$2)^A2. ...
  5. Step 3: Calculate the Present Value of Terminal Value. ...
  6. =TerminalValue / (1 + DiscountRate)^LastYear. ...
  7. Step 4: Sum the Present Values.
Oct 9, 2023

Does DCF use revenue or profit? ›

Basically, DCF is a calculation of a company's current and future available cash, designated as free cash flow, determined as operating profit, depreciation, and amortization, minus capital and operational expenses and taxes.

What is a good growth rate for DCF? ›

The long-term growth rate assumption should generally range between 2% to 4% to reflect a realistic, sustainable rate.

What is the discount rate DCF method? ›

The DCF Formula

In essence, this equation simply adds up all future business cash flows, but discounts each one. A discount rate, or discount 'factor', is calculated and applied to each year's cash flow, in order to arrive at the present value.

How to do a dcf in Excel? ›

To calculate the DCF in Excel, follow these steps:
  1. Step 1: Organize Your Data. ...
  2. Step 2: Calculate Present Value for Each Cash Flow. ...
  3. =CashFlow / (1 + DiscountRate)^Year. ...
  4. =B2 / (1 + $F$2)^A2. ...
  5. Step 3: Calculate the Present Value of Terminal Value. ...
  6. =TerminalValue / (1 + DiscountRate)^LastYear. ...
  7. Step 4: Sum the Present Values.
Oct 9, 2023

What is the formula for the discount factor? ›

How is the discount factor calculated? The discount factor can be calculated using the formula: Discount Factor = 1 / (1 + r)^n, where “r” is the discount rate and “n” is the number of periods.

What is the formula for discounted cash flow NPV? ›

NPV Formula. To calculate net present value, you need to determine the cash flows for each period of the investment or project, discount them to present value, and subtract the initial investment from the sum of the project's discounted cash flows.

Top Articles
Latest Posts
Article information

Author: Clemencia Bogisich Ret

Last Updated:

Views: 6301

Rating: 5 / 5 (80 voted)

Reviews: 87% of readers found this page helpful

Author information

Name: Clemencia Bogisich Ret

Birthday: 2001-07-17

Address: Suite 794 53887 Geri Spring, West Cristentown, KY 54855

Phone: +5934435460663

Job: Central Hospitality Director

Hobby: Yoga, Electronics, Rafting, Lockpicking, Inline skating, Puzzles, scrapbook

Introduction: My name is Clemencia Bogisich Ret, I am a super, outstanding, graceful, friendly, vast, comfortable, agreeable person who loves writing and wants to share my knowledge and understanding with you.