This paper circulates around the core theme of Assignment To complete the following assignment, go to this week’s Assignment link in the together with its essential aspects. It has been reviewed and purchased by the majority of students thus, this paper is rated 4.8 out of 5 points by the students. In addition to this, the price of this paper commences from £ 99. To get this paper written from the scratch, order this assignment now. 100% confidential, 100% plagiarism-free.
Assignment To complete the following assignment, go to this week’s Assignment link in the… 1 answer below » Assignment To complete the following assignment, go to this week’s Assignment link in the left navigation. Weighted Average Cost Complete the Mini Case on Nealon Inc. from the end of Chapter 9 and submit to instructor. In Parts a and b, clearly label the calculation of the required ratios and solve using Excel. Use formulas to calculate the ratios and format the cells to insert a comma if there is more than three numbers. Round percentages to two decimal places as a percentage. No narrative analysis is called for, so clearly label the calculations so that management will be able to View complete question » Assignment To complete the following assignment, go to this week’s Assignment link in the left navigation. Weighted Average Cost Complete the Mini Case on Nealon Inc. from the end of Chapter 9 and submit to instructor. In Parts a and b, clearly label the calculation of the required ratios and solve using Excel. Use formulas to calculate the ratios and format the cells to insert a comma if there is more than three numbers. Round percentages to two decimal places as a percentage. No narrative analysis is called for, so clearly label the calculations so that management will be able to comprehend them. The balance sheet that follows indicates the capital structure for Nealon Inc. Flotation costs are (a) 15 percent of market value for a new bond issue, and (b) $2.01 per share for preferred stock. The dividends for common stock were $2.50 last year and are projected to have an annual growth rate of 6 percent. The firm is in a 34 percent tax bracket. What is the weighted average cost of capital if the firm’s finances are in the following proportions? TYPE OF FINANCING PERCENTAGE OF FUTURE FINANCING Bonds (8%, $1,000 par, 16-year maturity) 38% Preferred stock (5,000 shares outstanding, $50 par, $1.50 dividend) 15% Common equity 47% Total 100% a. Market prices are $1,035 for bonds, $19 for preferred stock, and $35 for common stock. There will be sufficient internal common equity funding (i.e., retained earnings) available such that the firm does not plan to issue new common stock. Calculate the firm’s weighted average cost of capital. b. In part a we assumed that Nealon would have sufficient retained earnings such that it would not need to sell additional common stock to finance its new investments. Consider the situation now, when Nealon’s retained earnings anticipated for the coming year are expected to fall short of the equity requirement of 47 percent of new capital raised. Consequently, the firm foresees the possibility that new common shares will have to be issued. To facilitate the sale of shares, Nealon’s investment banker has advised management that they should expect a price discount of approximately 7 percent, or $2.45 per share. Under these terms, the new shares should provide net proceeds of about $32.55. What is Nealon’s cost of equity capital when new shares are sold, and what is the weighted average cost of the added funds involved in the issuance of new shares? Attachments: Q.-Attachment….docx View less » Sep 17 2015 01:37 PM
