PLEASE USE EXCEL AND SHOW ALL THE FORMULAS USED- EXPLAIN WITH DETAIL INFORMATION. THANK YOU

Which of the following are ways that a firm can reduce cash flows in order to prevent managers from wastefully spending excess cash flows? Check all that apply ? Increasing the amount of debt in the firm's target capital structure in the hope that higher debt-service requirements will force managers to be more disciplined Funneling excess cash flows back to shareholders through stock repurchases Funneling excess cash flows back to shareholders through higher dividends ? Minimizing the amount of debt in the firm's capital structure so that the firm can borrow money at a reasonable rate when good investment opportunities arise Green Goose Automation Company currently has no debt in its capital structure, but it is considering using some debt and reducing its outstanding equity. The firm's unlevered beta is 1.25, and its cost of equity is 12.25%. Because the firm has no debt in its capital structure, its weighted average cost of capital (WACC) also equals 12.25%. The risk-free rate of interest (rRF) is 3.5%, and the market risk premium (RP) is 7%. Green Goose's marginal tax rate is 30% Green Goose is examining how different levels of debt will affect its costs of debt and equity, as well as its WACC. The firm has collected the financial information that follows to analyze its weighted average cost of capital (WACC). Complete the following table Before-Tax Cost of Debt (rd) Levered Beta (b) 1.25 Bond Cost of Equity (rs) 12.25% 13.79% 16.31% D/A E/A Ratio Ratio D/E Ratio Rating 1.0 0.8 0.6 0.00 0.25 0.67 1.50 WACC 12.25% 12.21% 0.0 0.2 8.4% 8.9% 1.83 2.56 4.75 0.6 13.23% 0.2 14.3% 36.75%