Qtr1	Qtr2	Qtr3	Qtr4	2020
Sales	35000	125000	52000	65000	277000
Interest	11400	75000	10000	72000	168400
Investment Income	18475	14900	16500	42000	91875
Other	15000	22000	14500	40000	91500
Total	79875	236900	93000	219000	628775

1.Complete the formulas in cells provided for revenues* for 2021. 2021 revenues have Increased by 1/2% over 2020 values. 2. Complete the formulas in cells provided for expenses for 2021. 2021 expenses have decreased by 1/4% over 2020 values. 3. Using the correct function or formula calculate the total expenses and losses in the cells provided.

Cut E Copy 1 Clipboard 1 1 Home 7 8 Format Painter A 9 10 11 4 14 15 16 Y 17 Insert 8 G B 4 5 Revenues and gains 6 *Sales revenue *Interest revenue *Investment Income *Other revenue Arial Page Layout B I U ~ X 4 fx Total revenue and gains **Interest expense ***Computer (operating) **Depreciation Y 12 Expenses and losses 13 **Cost of goods sold **Selling and admin administrative 41 - Font 18 19 Income before taxes 20 Income tax expense (25%) 21 Net Income C KPT Enterprises 10 Formulas Total expenses and losses COMPARITIVE INCOME STATEMENT for years ended 31 December 2020 QuarterlyRevenue A Y D Y Data 5 *P 2020 55,000 125.000 53,500 53,500 35.000 Income Statement Review EE E WH View 2021 Alignment ErWrap Text Tell me what Merge & Center F Aggregates Quarterly Revenue Chart T E G Tax Rate 25%