Complete the following analysis. Do not hard code values in your calculations.

Leave the "Basis" input blank in the YIELD function. You must use the built$-$in

Excel function to answer this question.

Dinklage Corp. has $8$ million shares of common stock outstanding. The current share

price is $$73.$ The most recent dividend was $$3\mathrm{.}90$ and the dividend growth rate is $6$

percent. The company also has two bond issues outstanding. The first bond issue has a

face value of $$85$ million, a $7$ percent coupon, and sells for $97$ percent of par. The second

issue has a face value of $$50$ million, an $8$ percent coupon, and sells for $108$ percent of

par. The first issue matures in $21$ years, the second in $6$ years. What are the company's

capital structure weights on a market value basis? Assume that the overall cost of debt is

the weighted average of that implied by the two outstanding debt issues. Both bonds

make semiannual payments. The tax rate is $21$ percent. What is the company's WACC?

Market value of equity

Market value of first bond

Market value of second bond

Market value of debt & equity

Market value weight of equity

Market value weight of first bond

Market value weight of second bond

Cost of equity

Pretax cost of first bond

Aftertax cost of first bond

Pretax cost of second bond

Aftertax cost of second bond

WACC

$**$PLEASE SHOW EXCEL FORMULAS$**$