Hello!

Can you please help? If possible, show me how in excell?

The Saunders Investment Bank has the following financing outstanding.

Debt:43,000 bonds with a coupon rate of 4.8 percent and a current price quote of 104.7; the bonds have 12 years to maturity and a par value of $1,000. 15,500 zero coupon bonds with a price quote of 23.3, 27 years until maturity, and a par value of $10,000. Both bonds have semiannual compounding.

Preferred stock:138,000 shares of 3.3 percent preferred stock with a current price of $85and a par value of $100.

Common stock:1,960,000 shares of common stock; the current price is $75and the beta of the stock is 1.15.

Market:The corporate tax rate is 23 percent, the market risk premium is 6.8 percent, and the risk-free rate is 3.3 percent.

What is the WACC for the company?(Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.)

Thank you!