Excel Lab 2 Sensitivity Analysis Practice Exercise 1 Directions: 16. Make sure that you downloaded the incomestatement file from Blackboard 17. Upload it to Office 360 and open it with Microsoft Excel 18. In Cell B2, type your name (If your name is John Smith, type John Smith) 19. In Cell B3, type For the Month Ending June 30, 2020 20. Go back to Cell B3, and replace June 30, 2020 with the last day of the current month 21. Go to the following cells and enter the following formulas or functions: Cell Formula or Function DS -C6+C7 DIS -SUM(C11:C18) D20 DS-D18 D49 the sum function that would enable you to add Cells C23 to 048 D51 the formula that would enable you to subtract Cell D49 from D20 D56 the sum of Cells C54 and CS5 D58 The Net Operating Income + Total other Income 22. Change the Sales Returns and Allowances in C7 to -1000 23. Enter the Ending Inventory (Cell C17) of -1728.45 24. Look at the Net Income (or Loss) in Cell DS8. Type 2910.10 into Cell C54 and see what effect it has on the bottom line. 25. What would happen if you had a rent of 12000? Record it 26. Display the formula View of the spreadsheet (CTRL-) 27. Print the active sheet as a PDF. and download it to your device for submission to the instructor on Blackboard. Use the file name, Income Statement, followed by your first and last name. B D A 1 Income Statement 2 Name 3 Time Period 4 5 Revenue 6 Gross Sales 7. Less: Sales Returns and Allowances 8 Net Sales $ 145,000.00 $ 1,000.00 9 10 Cost of Goods Sold 11 Beginning Inventory 12 Add Purchases 13 Freight-in 14 Direct Labor 15 Indirect Expenses 16 Inventory Available 17 Less: Ending Inventory 18 Cost of Goods Sold 19 20 Gross Profit (Loss) 21 22 Expenses 23 Advertising $ 15,000.00 $ 5,000.00 $ 250.00 $ 500.00 $ 45.00 $ 20,795.00 $ 200.00