Please show Excel Formulas as well. Thank you.

12/8/12 Chapter: Problem: 15 12 Reacher Technology has consulted with investment bankers and determined the interest rate it would pay for different capital structures, as shown below. Data for the risk-free rate, the market risk premium, an estimate of Reacher's unlevered beta, and the tax rate are also shown below. Based on this information, what is the firm's optimal capital structure and what is the weighted average cost of capital at the optimal structure? Input Data Risk-free rate Market risk premium Unlevered beta Tax rate 4.5% 5.5% 0.8 40.0% Percent Financed with Debt (w.) 0% 10% 20% 30% 40% 50% 60% 70% Before-tax Cost Debt (rd) 6.0% 6.1% 7.0% 8.0% 10.0% 12.5% 15.5% 18.0% Fill in formulas in the yellow cells to find the optimum capital structure. Levered Beta Cost of Equity WACC Debt/Value Equity/Value Debt/Equity A-T Cost of Ratio (wa) Ratio (ws) Katio (w/w Debt (ra) 0% 1.0 0.00 10% 0.9 0.11 20% 0.8 0.25 30% 0.7 0.43 40% 0.6 0.67 50% 0.5 1.00 60% 0.4 1.50 70% 0.3 2.33 WACC at optimum debt ratio = Optimum debt ratio = 12/8/12 Chapter: Problem: 15 12 Reacher Technology has consulted with investment bankers and determined the interest rate it would pay for different capital structures, as shown below. Data for the risk-free rate, the market risk premium, an estimate of Reacher's unlevered beta, and the tax rate are also shown below. Based on this information, what is the firm's optimal capital structure and what is the weighted average cost of capital at the optimal structure? Input Data Risk-free rate Market risk premium Unlevered beta Tax rate 4.5% 5.5% 0.8 40.0% Percent Financed with Debt (w.) 0% 10% 20% 30% 40% 50% 60% 70% Before-tax Cost Debt (rd) 6.0% 6.1% 7.0% 8.0% 10.0% 12.5% 15.5% 18.0% Fill in formulas in the yellow cells to find the optimum capital structure. Levered Beta Cost of Equity WACC Debt/Value Equity/Value Debt/Equity A-T Cost of Ratio (wa) Ratio (ws) Katio (w/w Debt (ra) 0% 1.0 0.00 10% 0.9 0.11 20% 0.8 0.25 30% 0.7 0.43 40% 0.6 0.67 50% 0.5 1.00 60% 0.4 1.50 70% 0.3 2.33 WACC at optimum debt ratio = Optimum debt ratio =