Case #92 Macmillan and Grunski Consulting Discounted Cash Flow Analysis Summary of Case The case starts off with introducing Sandra Macmillan‚ a bachelor’s degree holder in Economics who worked for Peace Corps. She was offered a job in a regional brokerage firm in Seattle and became very familiar to the work environment and operations of the firm. She also decided to get her MBA from a prestigious university to help her take her job to the next level. After a few years‚ Sandra decided
Premium Discounted cash flow Finance Investment
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
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 10%‚ on average‚ of the market value of the transactions‚ providing a strong relation between the market value and discounted cash flow forecasts. In addition‚ they found that the DCF methods
Premium Discounted cash flow Net present value
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 financing. Table 2 shows that the book value of equity is forecasted to grow from $40.71 million in 2004 to $63.31 million at the end of 2010. Table 3 works out earnings‚ dividends and free cash flow for 2011. By that time Reeby Sports should
Premium Discounted cash flow Generally Accepted Accounting Principles Stock market
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 on the stock. According to the dividend growth model‚ an asset that has no expected cash flows has a value of zero‚ so if investors are willing to purchase shares of stock in firms that pay no dividends‚ they evidently expect that the firms will begin paying dividends at some point in the future. 2. Explain why some bond investors are
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
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 using the treasury stock method Modeling the weighted average cost of capital (WACC) Sensitivity analysis using data tables Modeling synergies ***************************** SAMPLE PAGES FROM TUTORIAL
Premium Discounted cash flow Free cash flow Generally Accepted Accounting Principles
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
This case is designed to introduce discounted cash flow valuation techniques in a cross-border setting. Groupe Ariel’s Mexican subsidiary is proposing the purchase and installation of some cost-saving equipment in its plant in Monterrey. The headquarters at Ariel requires a discounted cash flow analysis and an estimated net present value for expenditures of this magnitude. The issue is whether the analysis should be performed in euros or pesos. Relevant cash flows and appropriate discount rates are
Premium Net present value Discounted cash flow Internal rate of return