Problem 13.1: Please layout your calculation of this problem in the excel file that needs to be submitted on Connect.

Hero Manufacturing has 9 million shares of common stock outstanding. The current share price is $72 and the book value per share is $3. The company also has two bond issues outstanding. The first bond issue has a face value of $70 million, a coupon rate of 6.4 percent and sells for 109.5 percent of par. The second issue has a face value of $57.8 million, a coupon rate of 8.3 percent and sells for 113.3 percent of par. The first issue matures in 7 years, the second in 27 years.

Suppose the companys stock has a beta of 1.1. The risk-free rate is 3.3 percent and the market risk premium is 7.2 percent. Assume that the overall cost of debt is the weighted average implied by the two outstanding debt issues. Both bonds make semiannual payments. The tax rate is 22 percent. What is the companys WACC? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.)

Please lay out how you calculate cost and weight of each capital, and WACC in the excel file