Please solve this using Excel and show the respective formula or cell reference! Thank you.

4) (20 points) Patented Products is considering changing its capital structure. Patented currently has no debt and no preferred stock, but it would like to add some debt to take advantage of the tax shield. Its investment banker has indicated that the pre-tax cost of debt under various possible capital structures would be as follows: Patented uses the CAPM to estimate its cost of common equity, r5, and at the time of the analysis the risk-free rate is 5%, the market risk premium is 6%, and the company's tax rate is 25%. Patented estimates that its beta now (which is unlevered since it has no debt) is 0.8 . Based on this information, what is the firm's optimal capital structure, and what would be the weighted average cost of capital at the optimal capital structure