Barry Vee Inc. uses a mixture of common stock, preferred stock, and debt to finance its operations. In its capital structure, the market value of the companys equity is three times greater than the market value of its preferred stock. The company has a weighted average cost of capital of 9.5 percent. The companys cost of equity is 18.4 percent, its cost of preferred is 12.8 percent, and its pre-tax cost of debt is 3 percent. The corporate tax rate is 21 percent.

What are the capital structure weights? (Please show in excel with formulas if possible)