On the Sheet1 worksheet in this file, in the Change Analysis section, enter the appropriate INDEX and MATCH formula to analyze TWO years and THREE income statement line items.

Complete the Change Analysis section by entering formulas to calculate the dollar amount and percentage change between the two years being analyzed.

In the Change Analysis section, remove the yellow cell highlighting and correct any cell formatting so formula results are displayed properly.

To show your formulas are correct, input the years 2016 and 2020 and input the income statement line items Service Revenue, Insurance Expense, and Net Income. Submt your completed file with these years and accounts displayed.

Change Analysis Worksheet Years Ending Dec 31 Income Statement Tax Net Income Change Analysis ENTER LINE ITEM 1 HERE ENTER LINE ITEM 2 HERE ENTER LINE ITEM 3 HERE Change Analysis Worksheet Years Ending Dec 31 Income Statement Tax Net Income Change Analysis ENTER LINE ITEM 1 HERE ENTER LINE ITEM 2 HERE ENTER LINE ITEM 3 HERE