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

What is the formula for DPBP? ›

Discounted payback period is calculated by the formula: DPB = Year before DPB occurs + Cumulative Discounted Cash flow in year before recovery ÷ Discounted cash flow in year after recovery.

Is there a DCF formula in Excel? ›

DCF Formula in Excel

MS Excel has two formulas that can be used to calculate discounted cash flow, which it terms as “NPV.” This formula assumes that all cash flows received are spread over equal time periods, whether years, quarters, months, or otherwise.

How to build a DCF model from scratch? ›

In this article, we will provide a step-by-step guide on how to build a DCF model from scratch.
  1. Step 1: Understand the Basics of a DCF Model. ...
  2. Step 2: Build a Cash Flow Projection. ...
  3. Step 3: Determine the Discount Rate. ...
  4. Step 4: Calculate the Terminal Value. ...
  5. Step 5: Discount Future Cash Flows. ...
  6. Step 6: Sensitivity Analysis.
Feb 15, 2023

How to discount future cash flows in Excel? ›

You can calculate the discount rate on an investment in Excel with the following formula:Discount rate = (future cash flow / present value) 1/ n – 1In this equation, the future cash is the amount that the investor would receive at the end, the present value is the amount they could invest at the time and "n" is the ...

How to calculate dpp? ›

Identify the last year in which the cumulative balance was negative. The discounted payback period is calculated by adding the year to the absolute value of the period's cumulative cash flow balance and dividing it by the following year's present value of cash flows.

What is the formula for discounted payback period DPBP? ›

Discounted Payback Period Formula

First, we must discount (i.e., bring to the present value) the net cash flows that will occur during each year of the project. Second, we must subtract the discounted cash flows from the initial cost figure in order to obtain the discounted payback period.

How to calculate DCF step by step? ›

Steps in the DCF Analysis
  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.

What is a good DCF value? ›

If the DCF value calculated is higher than the current cost of the investment, the opportunity should be considered. If the calculated value is lower than the cost, then it may not be a good opportunity, or more research and analysis may be needed before moving forward with it.

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.

What is a DCF model for beginners? ›

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).

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? ›

This approach looks at a company's future expected cash flows and discounts those cash flows to the present. While analysts sometimes rely on a “back of the envelope” approach when building the DCF, a rigorous DCF analysis requires a full 3-statement model to feed the cash flow forecasts.

What is the 2 stage DCF model? ›

This is called the 2-stage DCF model. The first stage is to forecast the unlevered free cash flows explicitly (and ideally from a 3-statement model). The second stage is the total of all cash flows after stage 1. This typically entails making some assumptions about the company reaching mature growth.

What is the formula for discounting? ›

How to calculate discount rate. There are two primary discount rate formulas - the weighted average cost of capital (WACC) and adjusted present value (APV). The WACC discount formula is: WACC = E/V x Ce + D/V x Cd x (1-T), and the APV discount formula is: APV = NPV + PV of the impact of financing.

What discount rate to use for DCF? ›

For SaaS companies using DCF to calculate a more accurate customer lifetime value (LTV), we suggest using the following discount rates: 10% for public companies. 15% for private companies that are scaling predictably (say above $10m in ARR, and growing greater than 40% year on year)

What is the formula for payback profit? ›

To calculate the payback period you can use the mathematical formula: Payback Period = Initial investment / Cash flow per year For example, you have invested Rs 1,00,000 with an annual payback of Rs 20,000. Payback Period = 1,00,000/20,000 = 5 years.

What is the formula for the FV of payments? ›

FV of an annuity, if the payments are made at the end of the period (i.e., end of the month or year) is calculated as FV = PMT x [(1+r)n - 1)]/r, where FV = future value of an annuity stream, PMT = dollar amount of each annuity payment, r = the discount (interest) rate, and n = number of periods in which payments will ...

Top Articles
Latest Posts
Article information

Author: Tuan Roob DDS

Last Updated:

Views: 5886

Rating: 4.1 / 5 (42 voted)

Reviews: 89% of readers found this page helpful

Author information

Name: Tuan Roob DDS

Birthday: 1999-11-20

Address: Suite 592 642 Pfannerstill Island, South Keila, LA 74970-3076

Phone: +9617721773649

Job: Marketing Producer

Hobby: Skydiving, Flag Football, Knitting, Running, Lego building, Hunting, Juggling

Introduction: My name is Tuan Roob DDS, I am a friendly, good, energetic, faithful, fantastic, gentle, enchanting person who loves writing and wants to share my knowledge and understanding with you.