enter as formula

D 1 Adams Corporation evaluates divisional managers based on ROI. Operating results for the 2 company's Northern Division for last year are given below: 3 4 5 6 7 8 9 Sales Variable expenses Contribution margin Fixed expenses Net operating income B Average required investment Net operating income 19 Compute the following: 20 READY 16 17 Adams Corporation's minimum acceptable rate of return 18 21 Northern Division ROI for last year 22 Corporation evaluates divisional managers based on ROI. Operating 10 Average divisional operating assets 11 12 The Northern Division has an opportunity to add a new product line at the beginning of the year as follows: 13 14 15 23 Northern Division ROI if new product line is added 24 Sheet1 27,000,000 16,200,000 10,800,000 $ $ 8,805,000 1.995.000 9.500.000 2,500,000 400,000 # [2] 15% E 1 F 100% EL Exercise (NOTE, you have to enter formul... Clipboard a AI A E Font 19 Compute the following: 20 13 14 15 16 17 Adams Corporation's minimum acceptable rate of return 18 35 36 21 B Average required investment Net operating income 21 Northern Division ROI for last year 22 23 Northern Division ROI if new product line is added 24 READY Attempt(s) Styles Adams Corporation evaluates divisional managers based on ROI. Operating E 28 Northern Division residual income for last year 29 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 30 Northern Division residual income if the new product line is added 31 Sheet1 $ C Seved 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 34 2,500,000 400,000 BE D 15% F 100%