In Parts a and b, clearly label the calculation of the required ratios and solve using Excel

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,


 (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?