if you can show work please!

Assume that you have just been hired as business manager of Campus Del(CD), which is located adjacent to the campus. Its Free Cash Flow(FCA) IS $400,000, Because the university's enrollment is capped, FCF is expected to be constant over time. Because no expansion capital is required, CD pays out all earnings as dividends. CD currently has no debt-It is an all-equity firm-and its 100,000 shares outstanding selling at 540 per share. The firm's federal-plus-state tax rate is 35% On the basis of statements made in your finance text, you belleve that CD's shareholders would be better off if some debt financing was used. When you suggested this to your new boss, she encouraged you to pursue the idea but to provide support for the suggestion In today's market, the risk-free rate is 5% and the market risk premium is 5%. CD's unlevered beta is 10. CD currently has no debt, so its cost of equity (and WACC) is 10%. If the firm was recapitalized, debt would be issued and the borrowed funds would be used to repurchase stock. After speaking with a local investment banker, you obtain the following estimates of the cost of debt at different debt levels in thousands of dollars: Debt/Asset Ratio Bond Rating Yield 0 0.125 AA 8.096 0.250 A 9.0% 0.375 BBB 11.0% 0.500 BB 13.0% Now answer the following questions: What is the optimal capital structure for Debt/Asset ratio) in the above table? 2) What is the firm value under the optimal capital structure? 3) What is the stock price under the optimal capital structure Submit an excel file showing your answers and steps. Following steps in the lecture is recommended Assume that you have just been hired as business manager of Campus Del(CD), which is located adjacent to the campus. Its Free Cash Flow(FCA) IS $400,000, Because the university's enrollment is capped, FCF is expected to be constant over time. Because no expansion capital is required, CD pays out all earnings as dividends. CD currently has no debt-It is an all-equity firm-and its 100,000 shares outstanding selling at 540 per share. The firm's federal-plus-state tax rate is 35% On the basis of statements made in your finance text, you belleve that CD's shareholders would be better off if some debt financing was used. When you suggested this to your new boss, she encouraged you to pursue the idea but to provide support for the suggestion In today's market, the risk-free rate is 5% and the market risk premium is 5%. CD's unlevered beta is 10. CD currently has no debt, so its cost of equity (and WACC) is 10%. If the firm was recapitalized, debt would be issued and the borrowed funds would be used to repurchase stock. After speaking with a local investment banker, you obtain the following estimates of the cost of debt at different debt levels in thousands of dollars: Debt/Asset Ratio Bond Rating Yield 0 0.125 AA 8.096 0.250 A 9.0% 0.375 BBB 11.0% 0.500 BB 13.0% Now answer the following questions: What is the optimal capital structure for Debt/Asset ratio) in the above table? 2) What is the firm value under the optimal capital structure? 3) What is the stock price under the optimal capital structure Submit an excel file showing your answers and steps. Following steps in the lecture is recommended