Welo A D 13 14 Average required investment 15 Net operating income 2.500.000 16 s 400 000 17 Adams Corporation's minimum acceptable rate of return 18 15% 19 Assuming the company accepts all projects that meet or exceed the minimum rate of return, compute the following 20 21 Northern Division ROI for last year 22 21.00% 23 Northern Division ROI 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 570.000 28 Northern Division residual income for last year 29 $ 595.000 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 34 35 36 $ ACCEPT Layout Views Workbook Views Gridlines Headings Zoom 100% Zoom to Window Macros Selection Zoom Macros Show 123 A B D E F Sales Variable expenses Contribution margin Fixed expenses Net operating income 27.000.000 16,200,000 10,800.000 8,805,000 1.995,000 Average divisional operating assets 9.500.000 s $ 4 2 The Northern Division has an opportunity to add a new product line at the beginning of the year as follows: 3 Average required investment 2,500,000 5 Net operating income 400,000 16 17 Adams Corporation's minimum acceptable rate of return 1595