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 D8 -C6+C7 D18 -SUM(CII:C18) D20 D8-018 D49 the sum function that would enable you to add Cells C23 to C48 D51 the formula that would enable you to subtract Cell D49 from D20 D56 the sum of Cells C54 and C55 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 D58. 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. 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 D8 -C6+C7 D18 -SUM(CII:C18) D20 D8-018 D49 the sum function that would enable you to add Cells C23 to C48 D51 the formula that would enable you to subtract Cell D49 from D20 D56 the sum of Cells C54 and C55 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 D58. 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 

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 D8 D18 D20 D49 D51 D56 D58 Formula or Function. -C6+C7 =SUM(C11:C18) -D8-D18 the sum function that would enable you to add Cells C23 to C48 the formula that would enable you to subtract Cell D49 from D20 the sum of Cells C54 and C55 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 D58. 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.