The Ivanhoe Products Co$.$ currently has debt with a market value of $$250$ million 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\mathrm{.}92$ per bond. The firm also

has an issue of $2$ million preferred shares outstanding with a market price of $$14\mathrm{.}00$ per share. The preferred shares pay an annual

dividend of $$1\mathrm{.}20.$ Ivanhoe also has $14$ million shares of common stock outstanding with a price of $$20\mathrm{.}00$ per share. The firm is

expected to pay a $$2\mathrm{.}20$ common dividend one year from today, and that dividend is expected to increase by $6$ percent per year

forever. If Ivanhoe 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 any values that may have been pre$-$entered in the template based on the textbook version

of the problem.$)$