can I get the answer

- 1 FILE Calibri - 11 - 4 5 au 20 5. Return on Investment (ROI) and Residual Income - Excel ? 6 X HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In X A A % Paste BIU- E- Alignment Number Conditional Format as Cell Cells Editing Formatting Table Styles Clipboard Font Styles A1 fo Adams Corporation evaluates divisional managers based on ROI. Operating A B D E F 1 Adams Corporatiod evaluates divisional managers based on ROI. Operating results for the 2 company's Northern Division for last year are given below: 3 Sales $ 27,000,000 Variable expenses 16,200,000 6 Contribution margin 10,800,000 7 Fixed expenses 8,805,000 8 Net operating income 1.995.000 9 10 Average divisional operating assets S 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 15% 17 Adams Corporation's minimum acceptable rate of return 18 19 Compute the following: 20 21 Northern Division ROI for last year 22 23 Northern Division ROI if new product line is added 24 Sheet1 100% READY Hint Show Me Attemnts 1. Compute return on investment (ROI) 2. Compute residual income. KU 7 - Return on Investment (ROI) and Residual Income - Excel PAGE LAYOUT FORMULAS REVIEW VIEW FILE HOME INSERT DATA Sign In Calibri - 11 Paste BIU- A A % M Alignment Number Conditional Format as Cell Cells Editing Formatting Table Styles Styles Adams Corporation evaluates divisional managers based on ROI. Operating Clipboard Font AI X - A B D E F 9 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 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 Sheet1 ** 100% Saved 1. Compute return on investment (ROI) 2. Compute residual income. FILE Calibri - 11 Font 5 Return on Investment (ROI) and Residual Income - Excel ? 6 X HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In A A % 9 M Paste BIU- Alignment Number Conditional Format as Cell Cells Editing Formatting Table Styles Clipboard Styles > A Adams Corporation evaluates divisional managers based on ROI. Operating B D F 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% Al v E > 18 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 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 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 31 Sheet1 E READY 100%