Answer the last question

The Wildhorse Products Co. currently has debt with a market value of $275 millian outstanding. The debt consists of 9 percent coupon bonds (semiannual coupon payments) that have a maturity of 15 years and are currently priced at $1,445.45 per bond. The firm also has an issue of 2 million preferred shares outstanding with a market price of $19.00 per share. The preferred shares pay an annual dividend of $1.20. Wildhorse also has 14 million shares of common stock outstanding with a price of $20.00 per share. The firm is expected to pay a $2.20 common dividend one year from today, and that dividend is expected to increase by 4 percent per year forever. If Wildhorse is subject to a 28 percent marginal tax rate. Excel Template (Note: This template includes the problem statement as it appears in your textbook. The problem assigned to you here may have different values. When using this template, copy the problem statement from this screen for easy reference to the values you've been given here, and be sure to update ary values that may have been pre-entered in the template based on the textbook version of the problem.) Problem 13.24 a1-a5 (Excel Video)(a1) Your answer is correct. Calculate the weights for debt, comman equity, and preferred equity. (Round final answers to 4 decimal piaces, es. 1.2514) Debt Preferred equity Common equity Problem 13.24 a1-a5 (Excel Video)(a2) Your answer is correct. Calculate the cost of debt. (Round intermediate colculations to 4 decimal ploces, eg. 12514 and final answer to 2 decimal places, eg. 15.25\%) Cost of debt \% eTextbook and Media Problem 13.24 a1-a5 (Excel Video)(a3) Your answer is correct. Calculate the cost of preferred equity. (Round intermediate colculations to 4 decimal places, eg. 1.2514 and finai answer to 2 decimal plocec eg. 15.25\%) Cost of preferred equity eTextbook and Media Attempts: 2 of 3 used Problem 13.24 a1-a5 (Excel Video)(a4) Your answer is correct. Calculate the cost of common equity. (Round intermedlate caiculations to 4 decimal places, eg. 1.2514 and final answer to 2 decimai ploces eg. 15.25\%). Cost of common equity \% eTextbook and Media Problem 13.24 a1-a5 (Excel Video)(a5) Your answer is incorrect. What is the firm's weighted average cost of capital? (Round intermediate caiculations to 4 decimal ploces, eg. 1.2514 and final answer to 2 decimal places, eg. 15.25\%,J