Discounted Cash Flow Techniques - 2294 Words

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. =FV(rate, nper, pmt, pv, type) returns the future value of a series of cash flows. =PMT(rate, nper, pv, fv, type) calculates the periodic payment for a loan based on constant payments and a constant interest rate.†¦show more content†¦He presents this as obvious proof of gouging on the part of the money changers. Do you agree? Why, why not? 5) In 1984, the city council of the town of Patterson agreed that their community badly in need of a modern hotel that would cost approximately $25 million. To finance construction members of the council organized the Patterson Hotel Corporation. Through strenuous promotion they raised $15 million by selling 15,000 shares of stock at $1,000 per share. They secured the other $10 million necessary to build the hotel as a loan provided by a local bank on a 10 year, 14 percent mortgage that called for uniform annual payments sufficient to pay interest and to extinguish the debt at the end of 10 years. Upon completion, the Patterson Hotel Corporation leased the hotel to a national company that operated a chain of hotels. The lease ran for 30 years and contained a clause permitting the lessee to purchase the hotel for $10 million at the end of the 30-year period. The lessee agreed to furnish the hotel and pay all taxes (including income taxes) and operating expenses, and was to meet the interest and repayment obligations on the mortgage during the first 10 years of the lease. During the last 20 years of the lease, the operating company agreed to make payments sufficient to permit annual dividends of $400 per share. No payments at all were to be made to the stockholders during the first 10 years. This was the most favorable operatingShow MoreRelatedJet Blue Case Ipo1175 Words   |  5 Pagescontrol of management and is expensive. There are Free Cash Flow techniques and relative valuation techniques that we can use to value Jetblue’s share, however we are going to use the Free Cash Flow technique for this case as this is an IPO and the company had no history whatsoever that we can rely on except by using its similar competitor statistics and assumptions to value Jetblue. In conclusion, we have calculated that using Free Cash Flow technique, the share price is $57 and therefore the currentRead MoreValuation Is The Price Of Everything, But The Value Of Nothing1646 Words   |  7 Pagesan effect on corporate decisions, including projects to develop and where to find funds, and on the dividend policy. In such a way to study the topic, we will discuss first the Net Asset Value and its advantages and disadvantages, then the Discounted cash flow method and to finish the dividend discount model. The net asset value (NAV) method measures the value of a fund’s assets. It enables investors to analyse a fund’s performance market and industry standards such as Moody’s. The NAV is theRead MoreEssay on Capital 20Budget 20Analysis 20Group 20P1648 Words   |  7 Pagesalong with the different sale ranges. Keywords: NPV, NPV Profile, NPV, IRR, multiple IRRs, ranking conflict of NPV vs. IRR, payback period, profitability index, discount rate, cost of capital concept, cash flow analysis, cash flow timeline, conventional cash flow stream, non-conventional cash flow stream, sunk cost, opportunity cost, independent projects, mutually exclusive projects Overview of the Capital Budgeting Process Every business requires some source of funds to maintain operationRead MoreQuestions On Financial Concepts On Valuation1717 Words   |  7 PagesThere are four main parts in the manager’s work box for investment valuation opportunities.  ¬ Net Present Values  ¬ Accounting rated of return  ¬ Real Options  ¬ Payback rules NPV implement require estimates of appropriate discount rate and expected cash flows. And there’s the rub. This is only of use of information at the time of assessment. NPV method was first time developed for bonds value. Little investors in bonds can do it for alternative the final principal paid or yield rate and coupon they receiveRead MoreJetblue Ipo Essay1223 Words   |  5 Pages(transparency) * IPO expenses | * Liquidity of stock increases | * Owner restricted to immediate cash-out | * Easier to raise capital in the future | * Sharing of future earnings with outsiders | | * Legal liability | Exhibit A in the appendix outlines some additional key advantages and disadvantages of going public through the IPO process. IPO Valuation Techniques Deriving a value for an IPO is the critical part of the process. In both fixed price and book building offersRead MoreGuillermo Furniture Analysis1411 Words   |  6 Pagesalternatives Guillermo Furniture may use and will include a sensitivity analysis. Financial and valuation topics covered will include net present value (NPV) and weighted average cost of capital (WACC) and will discuss how these alternatives, or techniques, are used to reduce risk. Guillermo Navallez is the successful owner of Guillermo Furniture for many years now. Located in Sonora, Mexico, Guillermos store is specialized in custom made chairs, tables, and many other handcrafted productsRead MorePrince S.A.: valuation of a cross border joint-venture Essay1657 Words   |  7 Pagesmulti-currency cash flows, currency risk and political risk being taken into account in our valuation model? 4. What is the relevant cost of capital for Jersey? For R.T. Nakit? Can they be different? Why? 5. What is the Dinar (Pound) value of the joint venture R.T. Nakit (jersey)? What are the project’s value drivers? 1- The data presented on exhibit 3.7 is, indeed following some of the assumptions stated on exhibit 3.1: minimum cash level is 10% of total assets, which was proved by dividing cash by totalRead MoreCost of Capital Using Discounted Cash Flow Approach1060 Words   |  5 PagesIn 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 BrighamRead MoreThe Issue Bonds Generally Go Through A Series Of Steps894 Words   |  4 Pagesdebt financing of capital investments. Leasing offers the use that is usually the option to obtain capital benefit. For ot her cooperatives, certain changes in the economy might give strength to cooperatives to try to distinguish and to advance both cash flow and profit accomplishment through the use of long-term capital leasing plans. 3. Discuss the two major types of leases. There are two type of leases the operating and the capital. Operating leases is sometimes called a service lease that generallyRead MoreValuation of Kia Motors2358 Words   |  10 Pages Date: Jan 30, 2013 Table of Contents 1. Introduction 1 2. Valuation Methodology 2 2.1. Discounted Cash Flow 2 2.2. Terminal Value 3 2.3. Weighted Average Cost of Capital 3 2.3.1 Cost of Equity 4 2.3.2 Cost of Debt 4 2.4. Free Cash Flow 4 3. Calculation of WACC for Kia motors 5 4. Calculation of Free Cash Flow for Kia motors 5 5. Estimation of the value for Kia motors at the end of 2011 6 6. Conclusion 6 References 7 Appendix -1 8