Problem 13.1: Please layout your calculation of this problem in the excel file that needs to be submitted on Connect. Hero Manufacturing has 7.7 million shares of common stock outstanding. The current share price is $85 and the book value per share is $6. The company also has two bond issues outstanding. The first bond issue has a face value of $80 million, a coupon rate of 6.5 percent and sells for 106.9 percent of par. The second issue has a face value of $65.5 million, a coupon rate of 7 percent and sells for 110.7 percent of par. The first issue matures in 10 years, the second in 26 years. Suppose the company's stock has a beta of 1.4.The risk-free rate is 3 percent and the market risk premium is 6.9 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 24 percent. What is the companys WACC?

Please lay out how you calculate cost and weight of each capital, and WACC in the excel file that you need to submit in Connect. Please lay out your input information separately and label it clearly.(Excel part: 10 points)

WACC.

PLEASE SHOW IN EXCEL