Use balance and income statements given below (if "Calc" - you need to fill in the space first) in order to come up with both pro-forma statements. As a final step - calculate EFN. Tax rate and dividend payour ratio stay the same. PLEASE PROVIDE EXCEL FORMULAS
Times New Roman 11 WAA SE Share % Paste B Conditional Formatting Forratas Table Call Styles HUM A 2 Number CA Elina Ideas Sansive J21 x FIN A B C E F G 1 L Assets Balance bet 50,000 Det Equity Cake Total 20,000 12.000 Calo Calo Cala 25,000 Total Cole Culo 20% S% 30% Use balance and incantatemat gives below ar "Cake - you need to fill in the space flest) in order to come up with both pro-farea statements. As a final step calculate EFN. Tax rate and dividend 1 payow ratio stay the same 2 3 3 Income Statement 4 Sales 5 Costs 6 Taxable income 7 Tuxes (20%) 8. Net income 9 10 Dividend paid 11 12 Other Inputs 13 Tax rate 14 Percent increase in sales 15 Dividend payout ratio 16 17 18 4.1 Pro-forme ES 19 20 Proforma income men 21 Salal 22 Costs 23 Taxable income 24 Taxes (20%) 25 Ne Income 26 w 27 Dividends 2 Add To RE 29 30 31 32 33 34 35 36 37 38 39 40 4.2 Pro-forme RS 4.3 EFN External financing Assets Proforma balance sheet Debt Equity Tosal IT Total 2 5 1 3 + al Ready IT Focus English (United States Times New Roman 11 WAA SE Share % Paste B Conditional Formatting Forratas Table Call Styles HUM A 2 Number CA Elina Ideas Sansive J21 x FIN A B C E F G 1 L Assets Balance bet 50,000 Det Equity Cake Total 20,000 12.000 Calo Calo Cala 25,000 Total Cole Culo 20% S% 30% Use balance and incantatemat gives below ar "Cake - you need to fill in the space flest) in order to come up with both pro-farea statements. As a final step calculate EFN. Tax rate and dividend 1 payow ratio stay the same 2 3 3 Income Statement 4 Sales 5 Costs 6 Taxable income 7 Tuxes (20%) 8. Net income 9 10 Dividend paid 11 12 Other Inputs 13 Tax rate 14 Percent increase in sales 15 Dividend payout ratio 16 17 18 4.1 Pro-forme ES 19 20 Proforma income men 21 Salal 22 Costs 23 Taxable income 24 Taxes (20%) 25 Ne Income 26 w 27 Dividends 2 Add To RE 29 30 31 32 33 34 35 36 37 38 39 40 4.2 Pro-forme RS 4.3 EFN External financing Assets Proforma balance sheet Debt Equity Tosal IT Total 2 5 1 3 + al Ready IT Focus English (United States
