Please show excel work and formulas so I can learn.

Aaron Athletics is trying to determine its optimal capital structure. The company's capital structure consists of debt and common stock. In order to estimate the cost of debt, the company has produced the following table: Percent financed with Percent financed Debt-to-equity ratio (D/S) Before-tax cost of debt (wa) with equity (w.) debt 0.30 0.70 0.30/0.70 = 0.43 A 8.0% 0.40 0.60 0.40/0.60 = 0.67 BBB 8.8% Bond rating 0.50 0.50 0.50/0.50 = 1.00 BB 9.6% The company uses the CAPM to estimate its cost of common equity, s. The risk-free rate is 5% and the market risk premium is 6%. Aaron Athletics estimates that if it had no debt its beta would be 1.0. (Its "unlevered beta," bu equals 1.0.) The company's tax rate, T, is 40%. On the basis of this information, what is the company's optimal capital structure, and what is the firm's cost of capital at this optimal capital structure