Please answer the following questions based n the above figure

A. Using all relevant cells calculate the income tax expenses for each year. B. Using the correct function or formula calculate the net income.

C. Format the comparative income statement use dollars signs where necessary. All values are to have the thousand separator format with no decimal places.

rearna brown X File Home Insert Page Layer Formule Share Ang 10 asset_mgmt000_opers 2140 - Lacel Data Beie WEN Hels Tel me what you want to do Wrap lext General 12 Num Hau Good = = = Merge Center $ % 13 Conditonal Formats Check Cell Explanatory...pl Furmatting Table Algement Number Ses Atom Neutral X Calculation Xar Copy Format Pantai 20 Parte BIU Nul Inset Delete commet Clear Sort & Find Filur. Si Edring Clipboard Fan Cell K14 . A B F G 1 J K L M Format Shape x 1 D E Storme Imports Company (SIC) COMPARITIVE INCOME STATEMENT for years ended 31 December H Tax Rate 30% 2 3 2019 Roline Solidine Gradient line $1,430,650.00 $515,336.25 S52,893.75 $90, 171.25 $2,089,051.25 5 2018 6 Revenues and gains 7 *Sales revenue $1,420,000.00 8 *Interest revenue $511,500.00 9 *Investment Income $52,500.00 10 *Other revenue $89,500.00 11 Discuss with CEO and Import Team) $2,073,500.00 12 13 Expenses and losses 14 **Cost of goods sold $460,000.00 15 **Selling and admin administrative $195,000.00 16 ***Computer (operating) $186,990.00 17 **Depreciation $55,000.00 18 **Interest expense $25,200.00 19 Total expenses and losses $922.190.000 20 Income before taxes 21 Income tax expense (30%) 22 Net Income 23 $458,850.00 $194,512.50 $186,522.53 S54,862.50 $25,137.00 $919,884.53 Employee Department Contacts Green Savings Duarterly Revenue - 2018 Statement of Income Aggregates Quarterly Revenue chart - 2018 Comparing Experts + 120 10 Type here to search O 12:07 PM 01522000