Please answer using EXCEL ONLY!!! Other answers will not be accepted. I will upvote a correct answer

6. Macbeth Spot Removers is entirely equity financed. Use the following information. Data Number of shares 2,200 Price per share S 34 Market value of shares $ 74,800 Expected operating income 11,220 S Return on assets 15% Macbeth now decides to issue $37,400 of debt and to use the proceeds to repurchase stock. Suppose that Ms. Macbeth's investment bankers have informed her that since the new issue of debt is risky, debtholders will demand a return of 11.3%, which is 2.7% above the risk-free interest rate. Assume corporate tax rate is zero. A. What are the company's overall cost of capital after the debt issue? B. What is the cost of equity after the debt issue? C. Suppose that the beta of the unlevered stock was 0.60. What will BA, BE, and BD be after the change to the capital structure? 6. Macbeth Spot Removers is entirely equity financed. Use the following information. Data Number of shares 2,200 Price per share S 34 Market value of shares $ 74,800 Expected operating income 11,220 S Return on assets 15% Macbeth now decides to issue $37,400 of debt and to use the proceeds to repurchase stock. Suppose that Ms. Macbeth's investment bankers have informed her that since the new issue of debt is risky, debtholders will demand a return of 11.3%, which is 2.7% above the risk-free interest rate. Assume corporate tax rate is zero. A. What are the company's overall cost of capital after the debt issue? B. What is the cost of equity after the debt issue? C. Suppose that the beta of the unlevered stock was 0.60. What will BA, BE, and BD be after the change to the capital structure