PLEASE SHOW ALL WORK IN EXCEL!!!!

PLEASE SHOW ALL WORK IN EXCEL!!!!

Dani Corporation has 7 million shares of common stock outstanding. The current share price is $67, 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 $60 million, has a coupon rate of 7 percent, and sells for 92 percent of par. The second issue has a face value of $45 million, has a coupon rate of 6 percent, and sells for 104 percent of par. The first issue matures in 22 years, the second in 7 years.

Suppose the most recent dividend was $4.15 and the dividend growth rate is 4.2 percent. 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 23 percent. What is the companys WACC?

Note: Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.

WACC:_%

PLEASE SHOW ALL WORK IN EXCEL!!!!

PLEASE SHOW ALL WORK IN EXCEL!!!!