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
Discounted Cash Flow Homework Problems Please post the answers (and show your work) in the assignments section by midnight the last day of the week assigned. 1. Calculate the future value of 1‚535 invested today for 8 years at 6 percent. (5 points) $1535 * 1.5938 = $2‚446 2. What is the total present value of the following cash stream‚ discounted at 8 percent? (5 points) |Year |Amount |Rate |PV | |1 | $ 400
Premium Investment Time Net present value
Chen Bin Shen Qiyang Tan Yajie Wang Jiaqi Zhang Copyright © 2012 by Steris’s Group from Weatherhead School in Case Western Reserve University All rights reserved. No part of this publication may be reproduced‚ distributed‚ or transmitted in any form or by any means‚ including photocopying‚ recording‚ or other electronic or mechanical methods‚ without the prior written permission of the publisher‚ except in the case of brief quotations embodied in critical reviews and certain other noncommercial uses
Premium Discounted cash flow Revenue Weighted average cost of capital
In finance‚ the discounted cash flow (DCF) analysis is a method of valuing a project‚ company or asset using the concepts of time value of money (Wikipedia‚ 2004). Three inputs are required to use the DCF‚ also called dividend-yield-plus-growth-rate approach‚ include: the current stock price‚ the current dividend‚ and the marginal investor’s expected dividend growth rate. The stock price and the dividend are east to obtain‚ but the expected growth rate is difficult to estimate (Ehrhardt & Brigham
Premium Discounted cash flow Net present value Investment