Please answer completely and an excel example is uploaded.

F28 , fx BCDE No Taxes Firm A Firm With Taxes Firm A Firm B B 4 Capital Structure 5 Equity 6 Debt 7 Capital & Cost of Debt 9 Operating Performance 10 Sales 11 EBIT 12 Taxes $1,000.00 $0.00 $1,000.00 5.00% $500.00 $500.00 $1,000.00 5.00% $1,000.00 $0.00 $1,000.00 5.00% $500.00 $500.00 $1,000.00 5.00% $800.00 $150.00 0.00% Firm A $150.00 $0.00 $150.00 $0.00 $150.00 $800.00 $150.00 0.00% Firm B $150.00 $25.00 $125.00 $0.00 $125.00 $800.00 $150.00 35.00% Firm A $150.00 $0.00 $150.00 $52.50 $97.50 $800.00 $150.00 35.00% Firm B $150.00 $25.00 $125.00 $43.75 $81.25 $150.00 $0.00 $150.00 $125.00 $25.00 $150.00 $97.50 $0.00 $97.50 $81.25 $25.00 $106.25 $0.00 $0.00 $0.00 $8.75 14 EBIT 15 Interest Expense 16 EBT 17 Tax Expense 18 Net Income available for shareholders 19 Distributions 20 Total Distributed to Shareholders 21 Total Distributed to Bondholders 22 Total Distributed to all Stakeholders Tax Benefits (Per Period) 23 Associated with Debt 24 Return Measures 25 Cost of equity (Net Income / Equity) 26 Cost of debt 27 Proportion of Equity Equity/ (Equity+Debt)] 28 Proportion of Debt Debt/(Equity+Debt) WACC (Cost of Equity * Prop Equity + 29 Cost of Debt *(1-tax rate) * Prop Debt) 30 DuPont Equation 31 1. Profit Margin (Net Income / Sales) 32 2. Asset Turnover (Sales/ Total Assets) 33 3. Financial Leverage (Total Assets / Equity) 34 ROE (1*2*3) 15.00% 5.00% 100.00% 0.00% 25.00% 5.00% 50.00% 50.00% 9.75% 5.00% 100.00% 0.00% 16.25% 5.00% 50.00% 50.00% 15.00% 15.00% 9.75% 9.75% 18.75% 80.00% 100.00% 15.00% 15.63% 80.00% 200.00% 25.00% 12.19% 80.00% 100.00% 9.75% 10.16% 80.00% 200.00% 16.25% No Taxes Firm A Firm B With Taxes; Case 1 Firm A Firm B With Taxes; Case 2 Firm A Firm B $3,000.00 $0.00 $3,000.00 7.50% $1,750.00 $1,250.00 $3,000.00 7.50% $3,000.00 $0.00 $3,000.00 7.50% $1,750.00 $1,250.00 $3,000.00 7.50% $3,000.00 $0.00 $3,000.00 7.50% $500.00 $2,500.00 $3,000.00 7.50% $1,800.00 $600.00 0.00% $1,800.00 $600.00 0.00% $1,800.00 $600.00 35.00% $1,800.00 $600.00 35.00% $1,800.00 $600.00 35.00% $1,800.00 $600.00 35.00% 4 Capital Structure 5 Equity 6 Debt 7 Capital 8 Cost of Debt 9 Operating Performance 10 Sales 11 EBIT 12 Taxes 13 EBIT 14 Interest Expense 15 EBT 16 Tax Expense 17 Net Income available for shareholders 18 Distributions 19 Total Distributed to Shareholders 20 Total Distributed to Bondholders 21 Total Distributed to all Stakeholders Tax Benefits (Per Period) 22 Associated with Debt 23 Return Measures 24 Cost of equity (Net Income / Equity) 25 Cost of debt 26 Proportion of Equity [Equity/(Equity+Debt)] 27 Proportion of Debt (Debt/(Equity+Debt) WACC (Cost of Equity * Prop Equity + 28 Cost of Debt *(1-tax rate) * Prop Debt) 29 DuPont Equation 30 1. Profit Margin (Net Income / Sales) 31 2. Asset Turnover (Sales/ Total Assets) 32 3. Financial Leverage (Total Assets / Equity) 33 ROE (1*2*3) 34 Please fill the sheet titled 'Example2S' in the excel file named 'Capital structure illustration - excel file' and answer the following questions. 1/No Taxes, Firm A Total Distributed to Bondholders $0.00 $ 600.00 $93.75 2/No Taxes, Firm B Total distributed to all stakeholders $506.25 $ 600 $ 93.75 3/No Taxes, Firm B cost of equity and cost of debt 7.5% and 20% 28.93% and 7.5% 28.93% and 20% 4/With Taxes Case 1, Firm B Total distributed to all stakeholders $390 $486.25 $422.81 5/With Taxes Case 1, Firm B cost of equity and cost of debt 7.5% and 18.8% 18.8% and 7.5% 13% and 7.5% 6/No Taxes, Firm B cost of equity and cost of debt 7.5% and 20% 28.93% and 7.5% 28.93% and 20% 7/No Taxes. Firm A profitability, asset turnover and financial leverage 33.33%, 60% and 100% 28.13%, 60% and 171.43% 21.67%, 60% and 100% 8/With Taxes, Case 1, Firm A profitability, asset turnover and financial leverage 28.13%, 60% and 171.43% 21.67%, 60% and 100% 33.33%, 60% and 100%