DCF Modeling Copyright 2008 © by Wall Street Prep‚ Inc. ***************************** SAMPLE PAGES FROM TUTORIAL GUIDE ***************************** Table of contents SECTION 1: OVERVIEW DCF in theory and in practice Unlevered vs. levered DCF SECTION 2: MODELING THE DCF Modeling unlevered free cash flows Discounting to reflect stub year and mid-year adjustment Terminal value using growth in perpetuity approach Terminal value using exit multiple approach Calculating net debt Shares outstanding
Premium Discounted cash flow Free cash flow Generally Accepted Accounting Principles
discounted cash flow (DCF In finance‚ discounted cash flow (DCF) analysis is a method of valuing a project‚ company‚ or asset using the concepts of the time value of money. All future cash flows are estimated and discounted to give their present values (PVs) — the sum of all future cash flows‚ both incoming and outgoing‚ is the net present value (NPV)‚ which is taken as the value or price of the cash flows in question. Using DCF analysis to compute the NPV takes as input cash flows and a discount
Premium Generally Accepted Accounting Principles Investment Balance sheet
Literature Review of DCF An important consideration when using the DCF approach to valuation is its validity and usefulness in valuing companies and their stock prices. Various studies have established that a strong correlation between estimated future cash flows and the value of a firm exists (Copeland et al‚ 1994 ; Brealey and Myers ‚ 2000; Jones‚ 1998 ). In their study of 51 highly leveraged transactions (HLTs) ‚ Kaplan and Ruback (1995) found that the valuations using the DCF methods are within
Premium Discounted cash flow Net present value
Edition Richard A. Brealey and Stewart C. Myers George Reeby proposes to sell 90‚000 shares‚ or about 22%‚ of his company. How much are those shares worth? We have to value the company using George’s forecasts. The forecasts presented in Tables 4.10 and 4.11 do not show free cash flow and financing requirements. These are calculated in Table 1. Note that free cash flow for 2005 is -$2.3 million. But dividends are $2.0‚ so the company will need 2.3 + 2.0 = $4.3 million in outside equity
Premium Discounted cash flow Generally Accepted Accounting Principles Stock market
Exam 2 Part 2 Answer any EIGHT of the ten questions. Each question is worth 5 points. Return your answers to me by 11:59 PM Sunday 11 November 2012 1. A number of publicly traded firms pay no dividends yet investors are willing to buy shares in these firms. How is this possible? Does this violate our basic principle of stock valuation? Explain. Our basic principle of stock valuation is that the value of a share of stock is simply equal to the present value of all of the expected dividends
Premium Discounted cash flow Net present value Time value of money
ANALYSIS FOR FINANCIAL MANAGEMENT 10TH Edition Robert C. Higgins Additional Problems Chapter 7 – Discounted Cash Flow Techniques page 247 A brief tutorial on Excel financial functions (problems to follow) You may find the following Excel‚ built-in financial functions helpful when analyzing the problems below. (To access these functions‚ select Insert‚ Functions‚ and choose Financial.) =PV(rate‚ nper‚ pmt‚ fv‚ type) returns the present value of a series of cash flows
Premium Net present value Rate of return Internal rate of return
CHAPTER 4 DISCOUNTED CASH FLOW VALUATION Solutions to Questions and Problems 10. To find the future value with continuous compounding‚ we use the equation: FV = PVeRt a. b. c. d. FV = $1‚000e.12(5) FV = $1‚000e.10(3) FV = $1‚000e.05(10) FV = $1‚000e.07(8) = $1‚822.12 = $1‚349.86 = $1‚648.72 = $1‚750.67 23. We need to find the annuity payment in retirement. Our retirement savings ends at the same time the retirement withdrawals begin‚ so the PV of the retirement withdrawals will be the FV of
Premium Cash flow Net present value Rate of return
P HILIP MORRIS INTERNATIONAL Financial Analysis Executive Summary In this paper we have analysed the performance of Phillip Morris in order to decide whether or not to invest in the company. We have completed an overview of the competitive scenario‚ profitability and risk indicators‚ as well as contingencies and aspects to keep in mind for the future development of the firm. We think that in order to evaluate the current situation of the firm we have to give enough weight to quantitative
Premium Balance sheet Asset
(Reuters) Philip Morris International Inc. (PMI)‚ incorporated in 1987‚ is engaged in the manufacture and sale of cigarettes and other tobacco products through its subsidiaries and affiliates. Its products are sold in approximately 160 countries. PMI’s portfolio comprises both international and local brands. Its portfolio comprises both international and local brands‚ which include Marlboro‚ Merit‚ Parliament‚ Virginia Slims‚ L&M‚ Chesterfield‚ Bond Street‚ Lark‚ Muratti‚ Next‚ Philip Morris and Red &
Premium Stock Generally Accepted Accounting Principles Asset
Facts / Problems A. Philip Morris The leading producer of cigarettes in the United States is losing market share of their premium brand cigarette Marlboro to the discount market cigarette. B. The Cigarette markets fastest growing segment is the discount cigarette. C. Philip Morris got into the discount market late and only in a defensive move. D. Profit margins on premium brands are 10 times that of discount cigarettes. 2. Possible Solutions: A. Philip Morris can lower their prices on their
Premium Marketing Pricing Cigarette