Please answering using excel and show formulas. If you can, attach a google sheets link.

1. The target capital structure for ABC Company is 20% debt, 40% preferred, and 40% common equity. The before-tax cost of debt is 3.50%, the yield on the preferred is 8%, the cost of common stock is 15%, and the tax rate is 30%. What is the WACC? 2. ABC Company has 20% in debt and remainder in common equity. The cost of debt is 3.50%, the cost of common stock is 15%, and the tax rate is 30%. What is the WACC