f. Complete the formulas in cells provided for revenues* for 2019. 2019 revenues have increased by 3/4% over 2018 values.

g. Complete the formulas in cells provided for expenses for 2019. 2019 expenses have decreased by 1/2% over 2018 values.

h. Using the correct function or formula calculate the total expenses and losses in the cells provided.

i. Using all relevant cells calculate the income tax expenses for each year.

H9 F G Tax Rate 25% B E 1 MSC Global Shipping Company 2 COMPARITIVE INCOME STATEMENT 3 for years ended 31 December 4 2018 2019 5 Revenues and gains 6 *Sales revenue 167,000 7 *Interest revenue 414,000 8 *Investment Income 38,300 9 *Other revenue 102,300 10 Total revenue and gains 11 12 Expenses and losses 13 **Cost of goods sold 560,000.00 14 **Selling and admin administrative 205,500.00 15 ***Computer (operating) 68,000.00 16 **Depreciation 36,500.00 17 **Interest expense 29,000.00 18 Total expenses and losses 19 Income before taxes 20 Income tax expense (25%) 21 Net Income 22 Income Statement Employee Department Contacts 2018 Quarterly Revenue Aggregates +