A % v Conditional Formatting Format as Table Cell Styles Paste Font Alignment Number Cells Editin 18 A c D E Comparative G Common-Size xxx1 (%) xxx2(%) Diff. (5) Diff.%) 319 1 2 Income Statement Year xxx1 Year xxx2 3 Revenue: 4 Food $87,000.00 $94,000.00 5 Beverage $43,000.00 $47,000.00 6 Total revenue 7 8 Cost of sales: 9 Food $31,570.00 $33,462.00 10 Beverage $1,987.00 $2,154.00 11 Total cost of sales 12 13 Gross profit 14 15 Controllable expenses: 16 Salaries & wages $32,000.00 $34,680.00 17 Employee benefits $6,500.00 $7,500.00 16 Direct operating expenses $6,000.00 $6,000.00 Music & entertainment $1,000.00 $1,000.00 20 Marketing $3,000.00 $3,000.00 21 Energy & utilities $6,400.00 $6,200.00 22 Admin & General (A&G) $4,000.00 $4,500.00 23 Repairs & maintenance $2,000.00 $2,400.00 24 Total controllable expenses 25 26 Earnings before fixed costs 27 Rent & Occ. costs $8,000.00 $9,000.00 28 EBDIT 29 Less depreciation $4,000.00 $4,000.00 30 EBIT Less interest $500.00 $500.00 32 EBT 33 Income tax (40%) 34 Net income (or loss) 35 36 Complete the sheet by filling in the gray cells. 37 30 points 38 Everything to 2 decimal places!!! 31 39 40 Income Statement +