USING THE INCOME STATEMENT ACCOUNTS DATA FILE: PREPARE A CONSOLIDATED INCOME STATEMENT FOR BOTH YEARS PREPARE A BAR CHART SHOWING THE TREND OF TOTAL NET INCOME (PROFIT) OVER THIS TIME MAKE A PIE CHART SHOWING REVENUE CONTRIBUTION FOR PRODUCTS 1 TO 4 FOR 2019 QUARTER 1 AND 2020 QUARTER 2 COMPANY XYZ CONSOLIDATED INCOME STATEMENT 2020 QTR 1 2020 QTR 2 2020 QTR 3 2020 QTR 4 2021 QTR 1 2021 QTR 2 2021 QTR 3 2021 QTR 4 INCOME EXPENSE 2020 QTR 1 2020 QTR 2 2020 QTR 3 2020 QTR 4 2021 QTR 1 2021 QTR 2 2021 QTR 3 2021 QTR 4 NET INCOME [PROFIT] - - - - - - - - LIST OF INCOME ITEMS FOR COMPANY XYZ 2020 2021 QTR 1 4010 REVENUE - PRODUCT 1 1,000.00 1,040.00 QTR 1 4020 REVENUE - PRODUCT 2 2,000.00 2,040.00 QTR 1 4030 REVENUE - PRODUCT 3 3,000.00 3,150.00 QTR 1 4040 REVENUE - PRODUCT 4 4,000.00 4,160.00 QTR 1 4600 Interest Income 66.00 69.30 QTR 1 4700 Other Income 77.00 82.39 QTR 1 4800 Finance Charge Income 88.00 89.76 QTR 1 4900 Sales Returns and Allowances (99.00) (105.93) QTR 1 4950 Sales Discounts (500.00) (520.00) QTR 2 4010 REVENUE - PRODUCT 1 1,250.00 1,337.50 QTR 2 4020 REVENUE - PRODUCT 2 2,500.00 2,600.00 QTR 2 4030 REVENUE - PRODUCT 3 3,750.00 3,825.00 QTR 2 4040 REVENUE - PRODUCT 4 5,000.00 5,250.00 QTR 2 4600 Interest Income 82.50 84.98 QTR 2 4700 Other Income 96.25 101.06 QTR 2 4800 Finance Charge Income 110.00 113.30 QTR 2 4900 Sales Returns and Allowances (123.75) (132.41) QTR 2 4950 Sales Discounts (625.00) (637.50) QTR 3 4010 REVENUE - PRODUCT 1 1,062.50 1,115.63 QTR 3 4020 REVENUE - PRODUCT 2 2,125.00 2,210.00 QTR 3 4030 REVENUE - PRODUCT 3 3,187.50 3,251.25 QTR 3 4040 REVENUE - PRODUCT 4 4,250.00 4,547.50 QTR 3 4600 Interest Income 70.13 71.53 QTR 3 4700 Other Income 81.81 85.09 QTR 3 4800 Finance Charge Income 93.50 100.05 QTR 3 4900 Sales Returns and Allowances (105.19) (107.29) QTR 3 4950 Sales Discounts (531.25) (547.19) QTR 4 4010 REVENUE - PRODUCT 1 1,168.75 1,215.50 QTR 4 4020 REVENUE - PRODUCT 2 2,337.50 2,431.00 QTR 4 4030 REVENUE - PRODUCT 3 3,506.25 3,611.44 QTR 4 4040 REVENUE - PRODUCT 4 4,675.00 4,815.25 QTR 4 4600 Interest Income 77.14 79.45 QTR 4 4700 Other Income 89.99 96.29 QTR 4 4800 Finance Charge Income 102.85 106.96 QTR 4 4900 Sales Returns and Allowances (115.71) (123.81) QTR 4 4950 Sales Discounts (584.38) (607.75) LIST OF EXPENSE ITEMS FOR COMPANY XYZ 2020 2021 QTR 1 6010 Advertising Expense 267.75 278.46 QTR 1 6050 Amortization Expense 136.50 140.60 QTR 1 6100 Auto Expense 46.81 48.22 QTR 1 6150 Bad Debt Expense 187.25 200.36 QTR 1 6200 Bank Charges 36.75 39.32 QTR 1 6250 Cash Over and Short 0.00 - QTR 1 6300 Commission Expense 178.50 191.00 QTR 1 6350 Depreciation Expense 18.73 19.66 QTR 1 6400 Employee Benefit Program 540.75 578.60 QTR 1 6550 Freight Expense 0.00 - QTR 1 6600 Gifts Expense 9.19 9.37 QTR 1 6650 Insurance - General 202.13 206.17 QTR 1 6700 Interest Expense 91.00 93.73 QTR 1 6750 Professional Fees 18.38 18.93 QTR 1 6800 License Expense 18.38 19.29 QTR 1 6850 Maintenance Expense 91.00 93.73 QTR 1 6900 Meals and Entertainment 36.75 37.85 QTR 1 6950 Office Expense 17.85 18.21 QTR 1 7000 Payroll Taxes 0.00 - QTR 1 7050 Printing 18.73 19.10 QTR 1 7150 Postage 18.20 18.56 QTR 1 7200 Rent 918.75 964.69 QTR 1 7250 Repairs Expense 135.19 137.89 QTR 1 7300 Salaries Expense 2253.13 2,365.78 QTR 1 7350 Supplies Expense 535.50 551.57 QTR 1 7400 Taxes - FIT Expense 0.00 - QTR 1 7500 Utilities Expense 275.63 283.89 QTR 1 7900 Gain/Loss on Sale of Assets 0.00 - QTR 2 6010 Advertising Expense 240.98 248.20 QTR 2 6050 Amortization Expense 102.38 107.49 QTR 2 6100 Auto Expense 33.80 34.81 QTR 2 6150 Bad Debt Expense 216.30 227.12 QTR 2 6200 Bank Charges 43.68 44.55 QTR 2 6250 Cash Over and Short 0.00 - QTR 2 6300 Commission Expense 165.38 173.64 QTR 2 6350 Depreciation Expense 13.52 14.19 QTR 2 6400 Employee Benefit Program 606.38 630.63 QTR 2 6550 Freight Expense 0.00 - QTR 2 6600 Gifts Expense 7.21 7.43 QTR 2 6650 Insurance - General 148.71 151.68 QTR 2 6700 Interest Expense 98.18 100.14 QTR 2 6750 Professional Fees 21.84 22.28 QTR 2 6800 License Expense 14.04 14.75 QTR 2 6850 Maintenance Expense 102.99 106.08 QTR 2 6900 Meals and Entertainment 29.96 30.56 QTR 2 6950 Office Expense 21.84 22.93 QTR 2 7000 Payroll Taxes 0.00 - QTR 2 7050 Printing 20.02 21.02 QTR 2 7150 Postage 16.85 17.70 QTR 2 7200 Rent 803.25 859.48 QTR 2 7250 Repairs Expense 160.65 168.68 QTR 2 7300 Salaries Expense 2027.81 2,129.20 QTR 2 7350 Supplies Expense 401.63 413.67 QTR 2 7400 Taxes - FIT Expense 0.00 - QTR 2 7500 Utilities Expense 204.75 210.89 QTR 2 7900 Gain/Loss on Sale of Assets 0.00 - QTR 3 6010 Advertising Expense 328.62 341.77 QTR 3 6050 Amortization Expense 136.93 142.40 QTR 3 6100 Auto Expense 44.36 45.69 QTR 3 6150 Bad Debt Expense 292.11 300.87 QTR 3 6200 Bank Charges 57.33 58.48 QTR 3 6250 Cash Over and Short 0.00 - QTR 3 6300 Commission Expense 208.85 223.46 QTR 3 6350 Depreciation Expense 17.40 18.62 QTR 3 6400 Employee Benefit Program 773.27 788.74 QTR 3 6550 Freight Expense 0.00 - QTR 3 6600 Gifts Expense 9.46 9.84 QTR 3 6650 Insurance - General 197.07 204.95 QTR 3 6700 Interest Expense 130.13 134.03 QTR 3 6750 Professional Fees 27.85 28.40 QTR 3 6800 License Expense 17.40 18.62 QTR 3 6850 Maintenance Expense 130.13 139.24 QTR 3 6900 Meals and Entertainment 37.86 40.51 QTR 3 6950 Office Expense 27.85 29.24 QTR 3 7000 Payroll Taxes 0.00 - QTR 3 7050 Printing 26.03 26.55 QTR 3 7150 Postage 21.50 22.57 QTR 3 7200 Rent 1074.94 1,150.18 QTR 3 7250 Repairs Expense 212.94 223.59 QTR 3 7300 Salaries Expense 2610.56 2,688.88 QTR 3 7350 Supplies Expense 537.47 575.09 QTR 3 7400 Taxes - FIT Expense 0.00 - QTR 3 7500 Utilities Expense 273.85 287.55 QTR 3 7900 Gain/Loss on Sale of Assets 0.00 - QTR 4 6010 Advertising Expense 237.25 242.00 QTR 4 6050 Amortization Expense 143.58 150.76 QTR 4 6100 Auto Expense 40.31 43.13 QTR 4 6150 Bad Debt Expense 255.53 273.41 QTR 4 6200 Bank Charges 44.99 45.89 QTR 4 6250 Cash Over and Short 0.00 - QTR 4 6300 Commission Expense 170.35 175.46 QTR 4 6350 Depreciation Expense 15.66 15.98 QTR 4 6400 Employee Benefit Program 945.95 974.32 QTR 4 6550 Freight Expense 0.00 - QTR 4 6600 Gifts Expense 7.50 8.02 QTR 4 6650 Insurance - General 212.65 227.54 QTR 4 6700 Interest Expense 154.65 157.75 QTR 4 6750 Professional Fees 35.05 35.75 QTR 4 6800 License Expense 20.08 20.89 QTR 4 6850 Maintenance Expense 143.14 153.16 QTR 4 6900 Meals and Entertainment 30.28 31.80 QTR 4 6950 Office Expense 25.80 27.60 QTR 4 7000 Payroll Taxes 0.00 - QTR 4 7050 Printing 28.63 29.20 QTR 4 7150 Postage 15.97 17.09 QTR 4 7200 Rent 806.20 838.45 QTR 4 7250 Repairs Expense 156.63 161.33 QTR 4 7300 Salaries Expense 2129.400 2,193.28 QTR 4 7350 Supplies Expense 399.26 411.24 QTR 4 7400 Taxes - FIT Expense 0.00 - QTR 4 7500 Utilities Expense 208.85 219.29 QTR 4 7900 Gain/Loss on Sale of Assets 0.00