Everything needs to be answered in excel function form.

FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In X Calibri - 11 A A % M Paste BIU- > A Cells Alignment Number Conditional Format as Cell Formatting Table Styles Styles Editing Clipboard Font 13 A1 fx Adams Corporation evaluates divisional managers based on ROI. Operating B D - E F 1 Adams Corporation evaluates divisional managers based on ROI. Operating results for the company's Northern Division for last year are given below: 2 3 4 5 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 10 Average divisional operating assets S 9.500.000 12 The Northern Division has an opportunity to add a new product line at the beginning of the year as follows: 14 Average required investment Net operating income 2.500,000 400.000 17 thn minimum rental tanfratum FUL Styles A1 fo Adams Corporation evaluates divisional managers based on ROI. Operating B D E 10 Average divisional operating assets $ 9,500,000 11 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 return 15% 18 19 Compute the following: 20 21 Northern Division ROI for last year 22 23 Northern Division ROI if new product line is added 25 Write an IF statement to determine whether the Northern Division 26 manager will ACCEPT OF REJECT the new product line based on ROI. 26 Northern Division residual income for last year 30 Northern Division residual income if the new product line is added 32 metaminoharhartha Nnethorn en son Simulation 0 Saved Jipboard Font Styles A1 Adams Corporation evaluates divisional managers based on ROI. Operating A B D E 15 F Net operating income 400,000 16 17 Adams Corporation's minimum acceptable rate of return 15% 26 19 Compute the following: 20 21 Northern Division ROI for last year 22 23 Northern Division ROI if new product line is added 24 25 Write an IF statement to determine whether the Northern Division 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 32 Write an IF statement to determine whether the Northern Division manager 35 will ACCEPT or REIECT the new product line based on residual income 34 35 36