Cost of Capital, Capital Budgeting and Financial Planning

Assignment Cost of Capital, Capital Bud thruming and Financial Planning Chapter(s) 9, 10, 12 Group Name Student Name(s) Date book of instructions HW Assignments exit be uploaded to Kean Blackboard and must be accessed from there. You must work in groups where assigned (or independently if not assigned to groups) on homework assignments. Points be noted against individually question. You atomic number 18 required to submit Home Work assignments electronically on Kean Blackboard development MS-Office or other(a) text editor. You argon required to complete your assignments as per the due date indicated by the Professor.Total Points in Assignment 100 (Points scored go away be scaled d suffer to a utmost of 15 towards the final grade) Assignment Part I Cost of Capital During the closing curtain few years, Harry Davis Industries has been too constrained by the high approach of capital to make many capital investments. Recently, though, capital be have been declining, and th e company has decided to look seriously at a major elaboproportionn program that has been proposed by the marketing department. Assume that you are an assistant to Leigh J integritys, the financial vice-president. Your first task is to estimate Harry Daviss constitute of capital.Financial StatementsJ aces has provided you with the following data, which she believes may be relevant to your task a) The firms tax swan is 40%. b) The current footing of Harry Daviss 12% coupon, semiannual payment, noncallable bonds with 15 years stay to maturity is $1,153. 72. Harry Davis does not use short-term have-to doe with-bearing debt on a permanent prat. New bonds would be privately placed with no floatation woo. c) The current price of the firms 10%, $100 par value, quarterly dividend, perpetual preferred course is $116. 95. Harry Davis would incur flotation costs equal to 5% of the proceeds on a unexampled issue. ) Harry Daviss common stock is currently ex qualify at $50 per share. Its last dividend (D0) was $3. 12, and dividends are expected to bewilder at a constant rate of 5. 8% in the foreseeable future. Harry Daviss beta is 1. 2 the mother on T-bonds is 5. 6% and the market take a chance indemnity is estimated to be 6%. For the over-own-bond-yield-plus-judgmental- put on the line-premium approach, the firm uses a 3. 2%judgmental risk premium. e) Harry Daviss fair game capital structure is 30% long-term debt, 10% preferred stock, and 60%common justice. To help you structure the task, Leigh Jones has asked you to answer the following questions. . What sources of capital should be include when you estimate Harry Daviss weighted average cost of capital (WACC)? Should the component costs be figured on a forward-tax or an after-tax basis? Should the costs be historical (embedded) costs or new (marginal) costs? (5 points) Sources of capital to be included to estimate WACC are * Long term debt to be considered after tax * Preferred stock to be considered before tax ( preferred stock is not tax deductible) * Common equity to be considered before tax When it comes to corporate financing, most firms incorporate tax effects in the cost of capital.For this reason, component costs should be wagerd on an after-tax basis. In financial management the WACC is used primarily to make investment decisions and these decisions hinge on get winds expected future issuances versus the cost of new or marginal capital that volition be used to finance these visits. Thus the relevant cost it marginal cost of new debt to be raised during the planning period 2. What is the market interest rate on Harry Daviss debt, and what is the component cost of this debt for WACC purposes? (3 points) Pre -Tax cost of Debt is the YTM in the case of a Bond.The current price of Harry Daviss 12% coupon, semiannual payment, noncallable bonds with 15 years remaining to maturity is $1,153. 72. We used the RATE function in go past to calculate the YTM n 30 PV -1153. 72 pmt 60 FV 1000 Rate (i) 5% =RATE(30,60,-1153. 72,1000) = 5% Since this is a semiannual rate, we multiplied by 2 to find the annual rate, which is the pre-tax cost of debt. 5% x 2 = 10% = rd After tax component cost of debt = Interest Rate Tax Savings = rd rdT We cypher that the rd is 10%, and it is stated above that the tax rate is 40%. rd(1 T) = 10. %(1 0. 40) = 10. 0%(0. 60) = 6. 0 = 6% component cost of debt, which is the after-tax cost of debt. 3. What is the firms cost of preferred stock? (3 points) The current price of the firms 10%, $100 par value, quarterly dividend, perpetual preferred stock is $116. 95. Harry Davis would incur flotation costs equal to 5% of the proceeds on a new issue. The cost of preferred stock is simply the preferred dividend divided by the price the company will receive if it issues new preferred stock. No tax adjustment is necessary, as preferred dividends are not tax deductible.Dps is the Preferred dividend = . 10($100) = $10 Pps is the preferr ed stock price = $116. 95 F is the flotation cost as a percentage of proceeds = 5% rps = Dps / Pps(1-F) = $10 / 111. 10 = 0. 09 = 9% cost of preferred stock 4. Would you expect Harry Daviss preferred stock to be more than riskier or less riskier to investors than its debt? Compare the preferred stock yield to the yield to maturity on the debt and explain the risk/return trade-off between preferred stock and debt from an investors point of view. (3 points) Preferred stocks are riskier to investors than debt.Corpo rations own most preferred stock, because 70% of preferred dividends are non-taxable to corporations. Therefore, preferred stock often has a lower before-tax yield than the before-tax yield on debt. But, the after-tax costs to the issuer are higher on preferred stock than debt. This is self-consistent with the higher risks of preferred stock. 5. Harry Davis doesnt plan to issue new shares of common stock. Using the CAPM approach, what is Harry Daviss estimated cost of equi ty? (2 points) Harry Daviss beta is 1. 2 the yield on T-bonds is 5. 6% and the market risk premium is estimated to be 6%.Risk-free rate 5. 6% Market risk premium 6% Beta 1. 2 rs = Risk-free rate + (Market risk premium) (Beta) rs = rRF + (RPM) bi rs = . 056 + (. 06)(1. 2) = 0. 128 = 12. 8% estimated cost of equity using CAPM approach 6. What is the estimated cost of equity using the discounted capital flow (DCF) approach? (2 points) Harry Daviss common stock is currently selling at $50 per share. Its last dividend (D0) was $3. 12, and dividends are expected to grow at a constant rate of 5. 8% in the foreseeable future. P0 = $50 D0 = $3. 12 g = 5. 8% D1 = $3. 30 rs = D1/P0 + g D1= D0(1+g)= $3. 12(1+. 058) = $3. 30 s = ($3. 30/$50)+5. 8% = 6. 6% +5. 8% = 12. 4% estimated cost of equity using DCF approach 7. Suppose the firm has historically earned 15% on equity (ROE) and retained 62% of fee, and investors expect this situation to continue in the future. How could you use this informa tion to estimate the future dividend growth rate, and what growth rate would you get? Is this consistent with the 5. 8% growth rate provided by Jones? (2 points) Payout rate = 100% 62% = 38% ROE = 15% Growth from earnings retention mock up g = (Retention rate)(ROE) g = (1 Payout rate)(ROE) g = (1 0. 38)(15%) = 9. %. Using the Earnings Retention Model, the estimated future dividend growth rate is 9. 3%, which is almost twice the growth rate provided by Jones, and hence inconsistent. Note that the earning retention model assumes the retention and payout rate will remain constant, as will the ROE on new investments. Under these assumptions, the earnings growth and dividends growth rate will also be constant. 8. What is the cost of equity based on the bond-yield-plus-judgmental-risk-premium method? (2 points) For the over-own-bond-yield-plus-judgmental-risk-premium approach, the firm uses a 3. %judgmental risk premium. We calculated earlier that the companys bond yield is 10%. rs= r d + Judgmental risk premium rs= 10. 0% + 3. 2% = 13. 2% cost of equity based on bond-yield-plus-judgmental-risk-premium method 9. What is your final estimate for the cost of equity, rs? (2 points) CAPMrs = 12. 8% DCF rs= 12. 4% Bond-yield-plus-judgmental-risk-premium risk rs = 13. 2% Average rs= 12. 8% Final estimate for the cost of equity, rs = 12. 8% 10. What is Harry Daviss weighted average cost of capital (WACC)? (2 points) The firms tax rate is 40%.Harry Daviss target capital structure is 30% long-term debt, 10% preferred stock, and 60%common equity. We calculated earlier that the pre-tax cost of debt, rd is 10%, the cost of preferred stock, rps is 9% and the cost of equity, rs is 12. 8%. Wd = 30% rd = 10% T = 40% Wps = 10% rps = 9% Ws = 60% rs = 12. 8% WACC= wdrd(1 T) + wpsrps + wsrs WACC= 0. 30(. 10)(1 ? 0. 40) + 0. 10(. 09) + 0. 60(. 128) = . 1038 = 10. 38% weighted average cost of capital 11. What four common mistakes in estimating the WACC should Harry Davis avoid? (2 poi nts) Four common mistakes that are to be avoided are 1.Using current cost of debt (instead of historical cost of debt) 2. Mixing current and historical measures to calculate MRP 3. Using book weights to estimate the weight for capital structure (instead of market weights) 4. Misidentifying the capital component sources Part II Capital Budgeting You have just graduate from the MBA program of a large university, and one of your favorite courses was Todays Entrepreneurs. In fact, you enjoyed it so much you have decided you want to be your own boss. While you were in the masters program, your grandfather died and left you $1 million to do with as you please.You are not an inventor and you do not have a trade skill that you derriere market however, you have decided that you would like to purchase at least one established franchise in the fast-foods area, maybe deuce (if profitable). The problem is that you have never been one to stay with any project for too long, so you figure that your time put together is three years. After three years you will sell off your investment and go on to something else. You have narrowed your selection down to two choices (1) immunity L, Lisas Soups, Salads, Stuff and (2) Franchise S, Sams Fabulous Fried Chicken.The net cash flows shown below include the price you would receive for selling the franchise in Year 3 and the forecast of how each franchise will do over the three-year period. Franchise Ls cash flows will start off slowly but will increase rather quickly as people become more health conscious, while Franchise Ss cash flows will start off high but will trail off as other chicken competitors ship the marketplace and as people become more health conscious and avoid fried foods. Franchise L serves breakfast and lunch, while Franchise S serves only dinner party, so it is possible for you to invest in both franchises.You see these franchises as perfect complements to one another You could attract both the lunch and dinne r crowds and the health conscious and not so health conscious crowds without the franchises directly competing against one another. Here are the net cash flows (in thousands of dollars) Depreciation, salvage values, net works capital requirements, and tax effects are all included in these cash flows. You also have made subjective risk assessments of each franchise, and cerebrate that both franchises have risk characteristics that require a return of 10%. You must now determine whether one or both of the franchises should be authorized. . What is the residuum between independent and mutually exclusive projects? (2 points) Independent projects are those projects whose cash flows are not affected by other projects. If Costco is considering opening a new store in Los Angeles and another one in New York, they would be independent. Mutually exclusive projects are two different methods of attaining the same result. If one is accepted the other would be rejected. If Costco were consider ing relocating its corporate headquarters to Los Angeles or New York, only one of the 2 locations will be selected thus rejecting the alternate location.When projects are mutually exclusive, it means they do the same job or have the same purpose. 2. subtend the term net present value (NPV). What is each franchises NPV? (4 points) Net Present Value is defined as the present value of projects cash inflows minus the present value of its costs. It tells us how the project contributes to shareholder wealth. The larger the NPV the more value the project adds and thus the higher the stock price. NPV = CF0 + CF1/ (1+r)1 + CF2/(1+r)2 + CF3/(1+r)3.. + CFN/(1+r)N r = 10% Franchise L CF0L = -100 CF1L = 10 CF2L = 60 CF3L = 80NPVL= CF0L + CF1L/ (1+r)1 + CF2L/(1+r)2 + CF3L/(1+r)3 = -100 +10/(1+. 10)1 + 60/(1. 10)2 + 80/(1. 10)3 = -100 + 9. 09 + 49. 59 + 60. 11 = $18. 79 Franchise S CF0S = -100 CF1S = 70 CF2S = 50 CF3S = 20 NPVS= CF0S + CF1S/ (1+r)1 + CF2S/(1+r)2 + CF3S/(1+r)3 = -100 +70/(1+. 10)1 + 50/(1. 10)2 + 20/(1. 10)3 = -100 + 63. 64 + 41. 32 + 15. 03 = $19. 99 3. What is the rationale behind the NPV method? According to NPV, which franchise or franchises should be accepted if they are independent? Mutually exclusive? How would the NPVs change if the cost of capital changed? (4 points)NPV is generally regarded as the best single screening criterion, primarily because it is directly related to the firms central goal of maximizing the stocks intrinsic value. NPV tells us how the project contributes to shareholder wealth. The larger the NPV the more value the project adds and thus the higher the stock price. A negative NPV indicates suitable cash is not being generated from the project to meet cost associated with the project. Zero NPV indicates that cash generated is only sufficient to cover costs. Positive NPV on the other go indicates that the inflow of cash is larger than the outflow.NPV rules dictate that if projects are independent, both projects should be accept ed as long as they have a decreed NPV. In this case both Franchise S L have positive NPVs and should be accepted. If projects are mutually exclusive, then the project with the larger NPV should be selected. In this case, Franchise S has a higher NPV indicating that the returns from investing in Franchise S is larger and thus Franchise S should be selected. 4. Define the term internal rate of return (IRR). What is each franchises IRR? (4 points) IRR is the discount rate that forces the PV of the inflow of a project to equal the initial cost.In other words it forces the NPV to be zero. IRR is an estimate of the projects rate of return and it is comparable to the YTM on a bond. NPV = CF0 + CF1/ (1+IRR)1 + CF2/(1+IRR)2 + CF3/(1+IRR)3.. + CFN/(1+IRR)N = 0 Using Excel function IRR Expected net cash flows Year (t) Franchise L Franchise S 0 ($100) ($100) 1 10 70 2 60 50 3 80 20 IRR 18. 13% 23. 56% IRRL = 18. 13% IRRS = 23. 56% 5. What is the logic behind the IRR method? Acco rding to IRR, which franchises should be accepted if they are independent? Mutually exclusive? How would the IRRs change if cost of capital changed? 4 points) IRR is an estimate of a projects rate of return. If the return exceeds the cost of funds used to finance the project, then the difference is a support that goes to the firms stockholders and causes the stock price to rise. So if the WACC/hurdle rate(r) is less than the estimated return IRR, it indicates project will be profitable. As in NPV where zero is the limen above which the project is considered profitable, r is the threshold above which IRR is considered profitable In the condition where Franchise S and L are independent, both franchises have positive IRRs and thus both franchises should be accepted.However, when both franchises are mutually exclusive, the franchise with the larger IRR has to be selected, which in this case Franchise S. 6. Construct NPV pro single files for Franchises L and S. At what discount rate do the profiles cross? From the NPV profile which franchise or franchises should be accepted if they are independent? Mutually exclusive? Explain. (6 points) NPV visibility for Franchise S LCost of Capital = 10% Year = 0 1 2 3 working class S -100. 00 70 50 20 Project L -100. 00 10 60 80 r NPVS NPVL 0% $40. 00 $50. 00 5% $29. 29 $33. 05 8. 68% $22. 32 $22. 32 10% $19. 98 $18. 78 15% $11. 83 $6. 67 18. 126% $7. 23 $0. 00 20% $4. 63 -$3. 70 23. 564% $0. 00 -$10. 20 On this plot the X Axis is the cost of capital and the Y axis of rotation is the NPV. IRR is the discount rate at which profile line crosses the X axis. Profiles crossover at an 8. 68% cost of capital. Based on the plot, the NPV for both Franchise S and Franchise L have NPVs above the cost of capital indicating cash inflow is larger than the costs and thus both projects should be selected if they are independent of each other.On the other hand, if the projects are mutually exclusive, the project with the larger x-intercept (higher IRR), which is Franchise S, should be accepted. 7. What is the underlying cause of ranking conflicts between NPV and IRR? (3 points) Ranking conflicts advance when cost of Capital is higher than crossover rate which causes NPV and IRR to point in different directions. The two basic conditions that cause these conflicts are * Timing difference When one project receives majority of the cash early while the other receives it later.This is the reason for conflict between Franchise S Franchise L * Project sizing (scale) difference Significant difference in invested amount can cause a conflict When either clock or size differences occur, the firm will have different amounts of funds to invest in other projects depending on which of the two mutually exclusive projects it chooses. Given this situation, the rate of return at which differential gear cash flows can be reinvested is a critical issue. Therefore, whenever conflict exists between mutually exclusive projects, NPV method is better to use. 8.What is the reinvestment rate assumption, and how does it affect the NPV versus IRR conflict? (3 points) NPV calculation is based on the assumption that cash inflows can be reinvested at the projects risk adjusted WACC, whereas the IRR calculation is based on the assumption that cash inflows can be reinvested at the IRR itself. Since NPV assumes reinvestment at cost of capital which is more realistic and is typically lower than the IRR (cash flows generally cannot be reinvested at heir IRR), so NPV is the more reasonable method. NPV should be used to choose between mutually exclusive projects. . Define the term modified IRR (MIRR). Find the MIRRs for Franchises L and S. (4 points) IRR overstates the expected rate of return for accepted projects because cash flows cannot be reinvested at the IRR. The Modified IRR (MIRR) rectifies this problem by assuming reinvestment at the WACC or any other reasonable rate. Using go by function MIRR, we ca lculated the MIRR for Franchise L and S. WACC 10% year 1 1 2 3 Franchise L ($100) 10 60 80 Franchise S ($100) 70 50 20 MIRRL 16. 50% MIRRS 16. 89% 10.What are the MIRRs advantages and disadvantages vis-a-vis the regular IRR? What are the MIRRs advantages and disadvantages vis-a-vis the NPV? (4 points) MIRR has two significant advantages over IRR. First, MIRR assumes reinvestments at cost of capital rather than investment at IRR which is generally not correct. Thus, MIRR is usually a better indicator of profitability. In addition, the MIRR eliminates the multiple IRR problem because there can never be more than one MIRR, and it can be compared with the cost of capital when deciding on accept or rejecting projects.MIRR does not always lead to the same decision as NPV in the case of mutually exclusive projects where difference in size and timing can give rise to conflicts. In these considerations, NPV is a better indicator as it selects the project that maximizes value. H owever, MIRR is superior to the regular IRR as an indicator of a projects true rate of return. Part III Forecasting Financial Statements Matthews Industries most recent financial statements are available in the attached Excel worksheet and also in the partial model file Ch12 P11 Build a Model. xls from the textbooks web site.Matthews Industries financial planners must forecast the companys financial results for the coming year. The forecast will be based on the forecasted financial statements method, and any additional funds needed will be obtained by using notes payable. Complete the partial model and answer the following questions. 1. Assume that the firms 2010 profit margin, payout ratio, capital intensity ratio, and spontaneous liabilities to sales ratio remain constant. If sales grow by 10% in 2011, what is the required away capital the firm will need in 2011 as calculated by the AFN equation? 10 points) AFNMatthews = Addl Reqd Assets ? Spontaneous liabilities ? Addn to RE = (A0*/S0)? S ? (L0*/S0)? S ? S1 ? M ? (1POR) = (A0*/S0)(gS0) ? (L0*/S0)(gS0) ? S1 ? M ? (1POR) = $660 ? $74. 70 ? $257. 73 AFNMatthews = $327. 27 million The required external capital for 2011 as calculated by AFN is 327. 27 Million. 2. If 2010 ratios remain constant, what is Matthews self-supporting growth rate?How will the self-supporting growth rate change if each of the following changes occur (1) the profit margin declines, (2) the payout ratio increases, or (3) the capital intensity ratio declines? (10 points) PM(1 POR)(S0) $234. 30 Self-supporting g = = = 4. 17% A0* L0* PM(1 POR)S0 $5,615. 70 Mathews self-supporting growth is calculated to be 4. 17%. Effect on Self-Supporting growth when all ratios are kept constant except one ratio is changed as follows 1) When the profit margin declines, the self-supporting growth percentage drops.Assuming that everything else is constant and M go ons to 2. 55%, self-supporting growth g would fal l to 2. 96% 2) When Payout-ratio increases, self-supporting growth percentage drops. Assuming that everything else is constant and POR increases to 55%, self-supporting growth g would fall to 3. 39% 3) When capital intensity ratio (A0*/S0) declines, it does not change the self-supporting growth 3. Matthews management has reviewed its financial statements and arrived at two possible scenarios for 2011.The first scenario assumes a steady state while the game scenario, the target scenario, shows some improvement in ratios toward industry-average values. Forecasted values for the scenarios are shown in the partially completed file Ch12 P11 Build a Model. xls. If Matthews assumes that external financing is achieved by means of notes payable and financing feedbacks are not considered because the new notes payable are added at the end of the year, what are the firms forecasted AFN, EPS, DPS, and year-end stock price under each scenario? (14 points) Using the file Chapter 12P11 Build a Mo del. ls, forecasted values for scenarios are as follows Forecasted Values Steady State Target State AFN $324. 40 Million -332. 50 Million EPS $3. 16 $5. 66 DPS $1. 42 $2. 41 Year-end Stock Price $25. 27 $70. 79 See excel file submitted separately for detailed calculations on Part III. Scoring Sheet Question Max Points Points scored Part I 1 5 2 3 3 3 4 3 5 2 6 2 7 2 8 2 9 2 10 2 11 2 Part II 1 2 2 4 3 4 4 4 5 4 6 6 7 3 8 3 9 4 10 4 Part III 1 10 2 10 3 14 TOTAL 100 Points towards final grade 15