Question: Please help me! can u teach me step by step by showing all the formulas please. INDEX MATCH OBJECTIVE Use the Excel INDEX and MATCH

Please help me! can u teach me step by step by showing all the formulas please.

Please help me! can u teach me step by step byPlease help me! can u teach me step by step by
INDEX MATCH OBJECTIVE Use the Excel INDEX and MATCH functions to summarize and analyze financial data. INSTRUCTIONS "1. 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. 7. Complete the Change Analysis section by entering formulas to calculate the dollar amount and percentage change between the two years being analyzed. v X X e , 3. Inthe Change Analysis section, remove the yellow cell highlighting and correct any cell formatting so formula results are displayed properly. 2. 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. A B C D E F G Change Analysis Worksheet IN Years Ending Dec 31 Income Statement 2016 2017 2018 2019 2020 6 Service Revenue 99,495 $ 109,047 $ 119,624 $ 130,391 $ 240,821 Product Revenue 208,940 $ 228,998 $ 251,210 $ 273,820 $ 295,724 8 COGS S 96,680 $ 108,715 $ 120,833 S 130,060 145,800 9 Gross Profit S 211,755 $ 229,329 $ 250,002 $ 274,151 $ 390,745 10 11 Wages Expense 71,367 $ 80,436 $ 83,577 $ 86,577 $ 88,977 12 Rent Expense 14,400 $ 14,400 14,400 $ 18,000 $ 18,000 13 Insurance Expense 12,613 $ 13,691 15,556 $ 15,856 15,956 14 Legal and Professional Expenses 12,000 $ 12,000 14,500 $ 14,500 $ 15,500 15 Miscellaneous Expense 17,000 $ 12,000 $ 7,000 $ 32,000 $ 2,500 16 Earnings Before Tax S 84,375 $ 96,802 $ 114,969 $ 107,218 S 249,812 17 18 Tax 11,675 $ 13,760 $ 14,914 $ 13,244 $ 41,362 19 Net Income 72,700 $ 83,042 $ 100,055 $ 93,975 $ 208,449 20 21 22 Change Analysis 23 $ Change % Change ENTER YEAR 1 ENTER YEAR 2 Increase Increase 24 HERE HERE [Decrease) (Decrease) 25 ENTER LINE ITEM 1 HERE 26 ENTER LINE ITEM 2 HERE 27 ENTER LINE ITEM 3 HERE 28 Instructions Sheet1 +

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!