Cost of Capital, Capital Budgeting and Financial Planning

Assignment Cost of Capital, Capital Budgeting and pecuniary Planning Chapter(s) 9, 10, 12 Group Name Student Name(s) Date operating instructions HW Assignments go away be uploaded to Kean Blackboard and mustiness be accessed from there. You must have in groups where assigned (or independently if not assigned to groups) on prep atomic number 18dness assignments. Points atomic number 18 noted against each question. You atomic number 18 needful to submit radical Work assignments electronically on Kean Blackboard using MS-Office or different text editor. You are required to complete your assignments as per the due regard indicated by the Professor.Total Points in Assignment hundred (Points scored pull up stakes be scurfy down to a maximum of 15 towards the final spirit level) Assignment secern I Cost of Capital During the last few years, get to Davis Industries has been to a fault constrained by the high toll of metropolis to support many capital enthr atomic nu mber 53ments. Recently, though, capital live have been declining, and the troupe has decided to calculate seriously at a major expansion program that has been proposed by the marting department. Assume that you are an assistant to Leigh Jones, the monetary vice-president. Your first task is to yard Harry Daviss exist of capital.Financial put upmentsJones has provided you with the following data, which she believes may be relevant to your task a) The firms valuateation put is 40%. b) The current expense of Harry Daviss 12% coupon, biyearly payment, noncallable bonds with 15 years bear on to maturity is $1,153. 72. Harry Davis does not use short- status interest-bearing debt on a permanent hindquarters. unsanded bonds would be privately placed with no flotation follow. c) The current equipment casualty of the firms 10%, $100 par value, quarterly dividend, continual best-loved contrast is $116. 95. Harry Davis would flummox flotation make ups passable to 5% of the proceeds on a fresh issue. ) Harry Daviss common stock is bring inly merchandising at $50 per share. Its last dividend (D0) was $3. 12, and dividends are judge to farm at a constant footstep of 5. 8% in the predictable future. Harry Daviss beta is 1. 2 the digest on T-bonds is 5. 6% and the market adventure premium is estimated to be 6%. For the all over-own-bond-yield-plus-judgmental- encounter-premium approach, the firm uses a 3. 2%judgmental risk premium. e) Harry Daviss patsy capital body structure is 30% pertinacious-term debt, 10% prefer stock, and 60%common justness. To sustain you structure the task, Leigh Jones has asked you to answer the following questions. . What sources of capital should be included when you estimate Harry Daviss weighted median(a) court of capital (WACC)? Should the serving costs be figured on a forwards-tax or an after-tax basis? Should the costs be historical (embedded) costs or new (marginal) costs? (5 focuss) Sources of capi tal 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 integrity to be considered before tax When it comes to corporate financing, most firms incorporate tax effects in the cost of capital.For this reason, percentage costs should be mensurable on an after-tax basis. In financial management the WACC is employ primarily to make investment decisions and these decisions hinge on outsideizes expected future returns versus the cost of new or marginal capital that will be used to finance these rolls. 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 racing shell of a Bond.The current price of Harry Daviss 12% coupon, semiannual payment, noncallabl e bonds with 15 years proceeding to maturity is $1,153. 72. We used the RATE spotlight in Excel 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 calculate 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 = enliven Rate Tax Savings = rd rdT We calculate that the rd is 10%, and it is stated in a higher place 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 adaptation is necessary, as preferred dividends are not tax deductible.Dps is the Preferred dividend = . 10($100) = $10 Pps is the preferred 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? differentiate the preferred stock yield to the yield to maturity on the debt and rationalize the risk/return trade- take out between preferred stock and debt from an investors point of view. (3 points) Preferred stocks are riskier to investors than debt.Corporations own most preferred stock, because 70% of preferred dividends are non-taxable to corporations. Therefore, preferred stock often has a trim 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 consistent with the higher risks of preferred stock. 5. Harry Davis doesnt plan to issue new shares of common stock. use the CAPM approach, what is Harry Daviss estimated cost of equity? (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% important 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 t he firm has historically make 15% on equity (ROE) and retained 62% of earnings, and investors expect this situation to continue in the future. How could you use this information to estimate the future dividend evolution rate, and what ontogeny rate would you get? Is this consistent with the 5. 8% festering rate provided by Jones? (2 points) Payout rate = 100% 62% = 38% ROE = 15% Growth from earnings retention cast 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. feel 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 as well as be constant. 8. What is the cost of equity base on the bond-yield-plus-judgmental-risk-premium metho d? (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= rd + 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% utmost 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 WAC C= 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 neutralise? (2 points) 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 gradatory 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 odd you $1 million to do with as you please.You are not an inventor and you do not have a trade skill that you keep market however, you have decided that you would like to pur chase at least one established licence in the fast-foods area, maybe two (if net incomeable). The problem is that you have never been one to stay with any project for withal long, so you figure that your time frame 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) certification L, Lisas Soups, Salads, Stuff and (2) certification S, Sams Fabulous Fried Chicken.The crystalize property flows shown below include the price you would receive for selling the franchise in course of study 3 and the compute of how each franchise will do over the three-year period. certify Ls silver flows will start off slowly but will increase quite an quickly as people become more health conscious, duration license Ss silver flows will start off high but will trail off as new(prenominal) chicken competitors enter the marketplace and as people become more health conscious and avoid fried foods. Franchise L serves breakfast and lunch, composition Franchise S serves only dinner, so it is possible for you to invest in some(prenominal) franchises.You see these franchises as perfect complements to one opposite You could attract both the lunch and dinner 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 working capital requirements, and tax effects are all included in these cash flows. You also have made subjective risk assessments of each franchise, and concluded 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 accepted. . What is the disparity between independent and in return unshared 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. in return exclusive projects are two different methods of attaining the aforementioned(prenominal) result. If one is accepted the other would be rejected. If Costco were considering relocating its corporate headquarters to Los Angeles or New York, only one of the 2 locations will be selected indeed rejecting the alternate location.When projects are inversely exclusive, it means they do the same telephone line or have the same purpose. 2. intend the term net present value (NPV). What is each franchises NPV? (4 points) Net Present observe 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 large 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 C F0L = -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 over if the cost of capital changed? (4 points)NPV is slackly regarded as the best single seeing fire criterion, primarily because it is directly related to the firms central address of maximizing the stocks intrinsic value. NPV tells us how the project contributes to shareholder wealth. The big the NPV the more value the project adds and thus the higher the stock price. A negative NPV indicates sufficient 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 hand indicates that the inflow of cash is larger than the outflow.NPV rules dictate that if projects are independent, both projects should be accepted as long as they have a peremptory 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 sign cost.In other words it forces the NPV to be zero. IRR is an estimate of the projects rate of return and it is alike(p) to th e 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 expect 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? According 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 pecuniary resource used to finance the project, then the difference is a bonus 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 threshold above which the project is considered profitable, r is the threshold above which IRR is considered profitable In the spring whe re 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. reconstruct NPV writes 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 Profile for Franchise S LCost of Capital = 10% Year = 0 1 2 3 Project 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 is the NPV. IRR is the discount rate at which profile line crosses the X axis. Profiles crossover at an 8. 68% cost of ca pital. 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) rank conflicts occur 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 * quantify 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 size of it (scale) difference Signifi keept difference in invested amount bed cause a conflict When either measure or size differences occur, the f irm 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 cash flows can be reinvested is a critical issue. Therefore, whenever conflict exists between mutually exclusive projects, NPV method is wear out 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 down-to-earth 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 special IRR (MIRR) rectifies this problem by assuming reinvestment at the WACC or any other reasonable rate. Using excel function MIRR, we calculated 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 tete-a-tete 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 forefinger of profitability. In addition, the MIRR eliminates the ten-fold IRR problem because there can never be more than one MIRR, and it can be compared with t he cost of capital when deciding on evaluate 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. However, MIRR is superior to the regular IRR as an indicator of a projects true rate of return. Part tercet Forecasting Financial Statements Matthews Industries most recent financial statements are useable in the attached Excel worksheet and also in the partial model file Ch12 P11 mannikin 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 supererogatory funds needed will be obtained by using notes collectable. accomplish the partial model and answer the following questions. 1. Assu me 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 external 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 fall to 2. 55%, self-supporting growth g would fall 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 second 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 Bu ild a Model. xls. If Matthews assumes that external financing is achieved through 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 Model. 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