What are the implications of different payout levels for Rockboros capital structure and unused debt capacity? Complete the table below and explain your results.

(If you use excel, please show functions if possible)

2. What are the implications of different payout levels for Beckbare's capital structure and unused debt capacity? Complete the table below and explain your results Ta 0% Dividend 20% 40% 50% $786.4 $7864 $786.4 $786.4 Net profit Less dividends Earnings retained New debt 786.4 375.6 375.6 375.6 375.6 Increase in assets Initial debt (2014) Ending debt (2021) 120.4 120.4 120.4 120.4 Initial equity (2014) Earnings retained Ending equity (2021) 423.8 423.8 423.8 423.8 Total capital Debt total capital Debt equity Debt capacity Debt capacity used Unused debt capacity Ratio of debt capacity used to increase dividends paid Change in debt Increase in cash 2. What are the implications of different payout levels for Beckbare's capital structure and unused debt capacity? Complete the table below and explain your results Ta 0% Dividend 20% 40% 50% $786.4 $7864 $786.4 $786.4 Net profit Less dividends Earnings retained New debt 786.4 375.6 375.6 375.6 375.6 Increase in assets Initial debt (2014) Ending debt (2021) 120.4 120.4 120.4 120.4 Initial equity (2014) Earnings retained Ending equity (2021) 423.8 423.8 423.8 423.8 Total capital Debt total capital Debt equity Debt capacity Debt capacity used Unused debt capacity Ratio of debt capacity used to increase dividends paid Change in debt Increase in cash