NEED HELP WITH QUESTION PLEASE!

1. A manufacturer wants to determine its WACC. Today, 1/1/2018, the firm issued 7,000 bonds that will mature in 1/1/2038 with $1,000 face value. These bonds will pay a 9% coupon rate semiannually and are currently selling for $950. The firm has 100,000 preferred shares of stock outstanding with a book value of $40, but currently selling for $50 per share. The most recent preferred and common dividends were $3.50 and $2.50 per share, respectively. The firms EPS five years ago was $8.00 and it expects to increase its next dividend payment by the implied 5-year earnings per share growth rate. Flotation costs on debt and preferred equity are both 3%, but 7% in the case of common stocks. The common stock is selling today for $25 and the firms tax rate and payout ratio are 40% and 25%, respectively. The firm has 200,000 shares of common stock outstanding with the same book value as that of its preferred stock.

a) Calculate the book value and market value weights for each source of capital.

b) Calculate the component costs of capital (i.e., debt, preferred equity, retained earnings, and new common equity).

1. Determine the weighted average costs of capital using both the market and the book value weights

I will provide a picture of the required template below, PLEASE show calculations

Paste BI U v a. A IM = M Open recovered workbooks? Your recent changes were saved. Do you want to continu x Office Update To keep up-to-date with security updates, fixes, and improvements, cho A10 Xv fx Flotation Costs on Debt and Preferred B C D E F 1 Manufacturer 2 Tax Rate 40% 3 Payout Ratio 25% 4 Settlement Date 1/1/18 5 Maturity Date 1/1/2038 6 Frequency 2 7 Face Value $ 1,000 8 Coupon Rate 9.00% 9 Selling Price $950 10 Flotation Costs on Debt and Preferred 3.00% 11 Preferred Dividend $3.50 Preferred/Con mon Stock Book Value $40 13 Preferred Price $50 14 Last Common Dividend (D.) $2.50 15 EPS 5 Years Ago $8.00 16 Price on Common Share $25.00 17 Flotation Costs on Common Equity 7.00% 18 19 Source Quantity Book Value 20 Common 21 Preferred 22 Debt 23 Totals 24 25 Yield to Maturity 26 After-tax Cost of Debt 27 Cost of Preferred Equity 28 Growth Rate 29 Cost of Retained Earnings 30 Cost of New Common Equity 31 32 Weighted Average Cost of Capital 33 Book Value Weights 34 With Retained Earnings 35 With New Common Equity 36 Market Value Weights 37 With Retained Earnings 38 With New Common Equity 39 Market Value BV Weights My Weights an #1 #2 #3 #4 + Paste BI U v a. A IM = M Open recovered workbooks? Your recent changes were saved. Do you want to continu x Office Update To keep up-to-date with security updates, fixes, and improvements, cho A10 Xv fx Flotation Costs on Debt and Preferred B C D E F 1 Manufacturer 2 Tax Rate 40% 3 Payout Ratio 25% 4 Settlement Date 1/1/18 5 Maturity Date 1/1/2038 6 Frequency 2 7 Face Value $ 1,000 8 Coupon Rate 9.00% 9 Selling Price $950 10 Flotation Costs on Debt and Preferred 3.00% 11 Preferred Dividend $3.50 Preferred/Con mon Stock Book Value $40 13 Preferred Price $50 14 Last Common Dividend (D.) $2.50 15 EPS 5 Years Ago $8.00 16 Price on Common Share $25.00 17 Flotation Costs on Common Equity 7.00% 18 19 Source Quantity Book Value 20 Common 21 Preferred 22 Debt 23 Totals 24 25 Yield to Maturity 26 After-tax Cost of Debt 27 Cost of Preferred Equity 28 Growth Rate 29 Cost of Retained Earnings 30 Cost of New Common Equity 31 32 Weighted Average Cost of Capital 33 Book Value Weights 34 With Retained Earnings 35 With New Common Equity 36 Market Value Weights 37 With Retained Earnings 38 With New Common Equity 39 Market Value BV Weights My Weights an #1 #2 #3 #4 +