Solve the following problem on a single Excel worksheet. Show all your work. Use formulas for all calculations. Provide notation for all outside sources. The PeepsRNasty Corporation has hired you to evaluate its capital structure and to recommend potential alterations. You have been given the following information: The firm is currently financed with a capital structure that is comprised of 100% equity (0% debt), and the firm's beta is 1.0. The firm is considering changing its capital structure to include some amount of debt, although the company is not certain how much debt it should take on; however, the firm is certain that it would not take on more than 50% debt (i.e., a debt-to-equity ratio of 1). If the firm decides to include debt in its capital structure, it will use the funds raised through debt to repurchase shares of stock (essentially swapping equity for debt). The risk-free rate of interest is 6%, the return on the market is 12%, and the firm's tax rate is 40%. If the firm takes on debt, it expects that its cost of debt will follow the table below. % Debt Cost of Debt 0% 0% 10% 7% 20% 8% 30% 8.5% 40% 10% 50% 12% First, build a spreadsheet that demonstrates the following items: The firm's levered beta The firm's cost of equity The firm's WACC . 1111 Make sure to calculate these values for 6 capital structure combinations that correspond to the table above (i.e., 100% equity/0% debt, 90% equity/10% debt, 80% equity/20% debt, ..., 50% equity/50% debt). Second, identify which capital structure is optimal (best) for the company