PLEASE WRITE THE FORMULAS

A B D E 1 NM +00 2 3 4 Pro Forma Income Statement Example 1 5 2015 Actual 2016 ProForma Sales Revenue $100.000,0 $135.000,0 7 Less Cost Of Goods Sold 8 Fixed Cost $40.000,0 $40.000,0 9 Variable Cost 40% $40.000,0 10 Gross Profits $20.000,0 #i VALOR! 11 Less Operating Expenses 12 Fixed Cost $5.000,0 $5.000,0 13 Variable Cost 5% $5.000,0 14 Operating Profits $10.000,0 15 Less Interest Expense $1.000,0 $1.000,0 16 Net Profit Before Taxes $9.000,0 17 Less Taxes 0,15 $1.350,0 18 Net Profits After Taxes $7.650,0 19 20 21 22 23 24 Pro Forma Income Statement Example 2 25 2015 Actual 2016 ProForma 26 Sales Revenue $325.000,0 $550.000,0 27 Less Cost Of Goods Sold 28 Fixed Cost $50.000,0 $50.000,0 29 Variable Cost 40% $130.000,0 30 Gross Profits $145.000,0 31 Less Operating Expenses 32 Fixed Cost $15.000,0 $15.000,0 33 Variable Cost 5% $16.250,0 34 Operating Profits $113.750,0 35 Less Interest Expense $5.000,0 $5.000,0 36 Net Profit Before Taxes $108.750,0 37 Less Taxes 0,15 $16.312,5 38 Net Profits After Taxes $92.437,5 39 40