Please show solution in Excel.

Ilumina Corp 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 debt (wa) 0.25 0.35 0.50 Percent financed with equity (W) 0.75 0.65 0.50 Debt-to-equity ratio (D/S) 0.25/0.75 = 0.33 0.35/0.65 = 0.5385 0.50/0.50 = 1.00 After-tax cost of debt (%) 7.5% 8.4% 9.0% The company uses the CAPM to estimate its cost of common equity, Is. The risk-free rate is 5% and the market risk premium is 6%. Ilumina estimates that its beta with 10% debt is 1. 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