The answers are suppose to be in the yellow boxes. They Have to be in EXCEL formulas not just regular formulas. Would appreciate if the formulas were referenced to my excel sheet. Thanks

Return on Investment (ROI) and Residual Income - Excel 7 00 X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In X Calibri 11 96 Paste - Cells Editing Alignment Number Conditional Format as Cell Formatting Table Styles Styles Clipboard Font NING HACCP202 SED 700 spring 2021 Question -CH10 Ees-Cornet Question 1- CH 10 EXCEL Exercise - Connect CH 10 EXCEL Exercise 6 Save Help 10 Averige divisional operating assets S 9.500.000 1 oints 155 BOK References 12 The Northern Division has an opportunity to add a new product line at the beginning of the year as follows: 13 14 Average required investment $ 2.500.000 15 Net operating income $ 400.000 16 17 Adams Corporation's minimum acceptable rate of retum 18 19 Compute the following 20 21 Northern Division ROI for last year 22 23 Northern Division Rol if new product line is added 24 25 Write an IF statement to determine whether the Northern Division 26 manager will ACCEPT or REJECT the new product line based on ROI 27 28 Northern Division residual income for last year 29 30 Northern Division residual income if the new product line is added 31 32 Write an IF statement to determine whether the Northern Division manager 33 Will ACCEPT or REJECT the new product line based on residual income Sheet1 READY Attemptis) 100% Me Graw Prev Next Return on Investment (ROI) and Residual Income - Excel 7 00 X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In X Calibri 11 96 Paste - Cells Editing Alignment Number Conditional Format as Cell Formatting Table Styles Styles Clipboard Font NING HACCP202 SED 700 spring 2021 Question -CH10 Ees-Cornet Question 1- CH 10 EXCEL Exercise - Connect CH 10 EXCEL Exercise 6 Save Help 10 Averige divisional operating assets S 9.500.000 1 oints 155 BOK References 12 The Northern Division has an opportunity to add a new product line at the beginning of the year as follows: 13 14 Average required investment $ 2.500.000 15 Net operating income $ 400.000 16 17 Adams Corporation's minimum acceptable rate of retum 18 19 Compute the following 20 21 Northern Division ROI for last year 22 23 Northern Division Rol if new product line is added 24 25 Write an IF statement to determine whether the Northern Division 26 manager will ACCEPT or REJECT the new product line based on ROI 27 28 Northern Division residual income for last year 29 30 Northern Division residual income if the new product line is added 31 32 Write an IF statement to determine whether the Northern Division manager 33 Will ACCEPT or REJECT the new product line based on residual income Sheet1 READY Attemptis) 100% Me Graw Prev Next