The lvanhoe Products Co. currently has debt with a market value of $250 mellion 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,423.92 per bond. The firm also has an issue of 2 million preferred shares outstanding with a market price of $1500 pet share The preferred shares pay an annual dividend of \$1.20. Ivanhoe also has 14 million shares of common stock outstanding with a price of $20.00 per share. The firm is expected to pary a $2.20 common dividend one year from today, and that dividend is expected to increace by 4 percent per year forever. If Ivanhoe is subject to a 28 percent marginal tax rate. Bxcel Template (Note: This template includes the problem statement as it appears in your textbook. The protlen awsigned to you here may have different values. When using this template, coov the problem statement from this screen foc easy reference to the values you've heen given here, and be sure to update any values that may have been pre-entered in the template based on the toxtbook version of the problem.) Problem 13.24 a1.a5 (Excel Video)(a1) Calculate the weights for debt, common equity, and preferred equity, (Round finol anwers to 4 decimal phaces 8. 1.2514. Debt Prefierted equity Common nquity