Problem 5 XYZ company faces variable costs of debt and equity depending on the capital structure of the firm as given in table below. (a) Calculate the weighted average cost of capital (WACC) at each tax rate (from 10% to 70% by increments of 10%) by filling out the table on next page. Make sure to report weighted average cost of capital numbers at 4 decimal places of accuracy such as 12.3456% or 1.0023%. Hint: You can easily do mistakes if you make manual calculations. Instead, you might want to use Microsoft Excel to create a spreadsheet model where you repeatedly keep changing tax rates. (b) What is the minimum weighted average cost of capital at each tax rate? 10% tax rate 20% tax rate 30% tax rate 40% tax rate 50% tax rate 60% tax rate 70% tax rate Weighted Average Cost of Capital (c) What is the optimal capital structure at each tax rate? 30% 10% tax rate 20% tax rate 70% tax rate 40% tax rate 50% tax rate 60% tax rate tax rate Optimal Capital Structure D=_% DE_% DE_% DE_%D=_% DE_%D=- E-_-_% E=__% E= ____% E= _% E= ___% E= __%E=____% (d) Fill out the blanks: "As the tax rate increases from 10% to 70% the debt ratio (D/V) at the optimal capital structure _ (increases/decreases/stays the same)." "As the tax rate increases from 10% to 70% the weighted average cost of capital at the optimal capital structure (increases/decreases/stays the same)." Weighted Average Cost of Capital (WACC) at various tax rates Proportion of Debt [= D/(D+E)] 0% Cost of Debt Cost of Equity 10% tax rate 20% tax rate 30% tax rate 40% tax rate 50% tax rate 60% tax rate 70% tax rate 4 50% 9.25% 5% 4.65% 9.50% 9.80% 10% 4.85% Weighted Average Cost of Capital (WACC) at various tax rates Proportion of Debt [-D/(D+E)) Cost of Debt Cost of Equity 10% tax rate 20% tax rate 30% tax rate 40% tax rate 50% tax rate 60% tax rate 70% tax rate 0% 4.50% 9.25% 9.50% 5% 4.65% 10% 4.85% 9.80% 15% 5.10% 10.15% 20% 5.40% 10.55% 25% 5.80% 11.00% 30% 6.30% 11.50% 35% 6.90% 12.05% 40% 7.60% 45% 8.40% 12.65% 13.35% 14.15% 50% 9.32% 10.37% 15.05% 55% 60% 11.56% 16.05% 65% 12.90% 17.15% 70% 14.40% 18.35% 75% 19.65% 16.07% 17.92% 80% 21.05%