please help with excel step-by-step (detailed) much appreciated **IMPORTANT** PLEASE MAKE SURE TO USE EXCEL WITH FORMULAS

1. Iluminte Corp is trying to determine its optimal capital structure. The companys 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 (wd)	Percent financed with equity (wc)	Debt-to-equity ratio (D/S)	After-tax cost of debt (%)
0.25	0.75	0.25/0.75 = 0.33	7.5%
0.35	0.65	0.35/0.65 = 0.5385	8.4%
0.50	0.50	0.50/0.50 = 1.00	9.0%

The company uses the CAPM to estimate its cost of common equity, r_s. The risk-free rate is 5% and the market risk premium is 6%. Iluminte estimates that its beta with 10% debt is 1. The companys tax rate, T, is 40%. On the basis of this information, what is the companys optimal capital structure, and what is the firms cost of capital at this optimal capital structure?

PLEASE HELP WITH EXCEL STEP-BY-STEP (IN FULL detail) much appreciated **IMPORTANT** I WANT TO LEARN