Extra Credit Excel Sims Seved Help Save & Exit Return on Investment (ROn and Residual Income - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri - 11 Alignment Number Conditional Format as Formatting- Table Styles Paste Cell BIU- Cells Editing Clipboard Font Styles Adams Corporation evaluates divisional managers based on ROI. Operating A1 1 Adams Corporation evaluates divisional managers based on ROI. Operating results for the 2 company's Northern Division for last year are given below: %24 Sales 27,000,000 4. Variable expenses 16,200,000 Contribution margin 10,800,000 Fixed expenses 8,805,000 1.995.000 Net operating income 9,500,000 Average divisional operating assets 10 11 12 The Northern Division has an opportunity to add a new product line at the beginning of the year as follows: 13 2,500,000 Average required investment Net operating income 14 400,000 15 16 15% 17 Adams Corporation's minimum acceptable rate of return 18 19 Assuming the company accepts all projects that meet or exceed the minimum rate of return, compute the following: Extra Credit Excel Sims Seved Help Save & Exit Return on Investment (ROn and Residual Income - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri - 11 Alignment Number Conditional Format as Formatting- Table Styles Paste Cell BIU- Cells Editing Clipboard Font Styles Adams Corporation evaluates divisional managers based on ROI. Operating A1 1 Adams Corporation evaluates divisional managers based on ROI. Operating results for the 2 company's Northern Division for last year are given below: %24 Sales 27,000,000 4. Variable expenses 16,200,000 Contribution margin 10,800,000 Fixed expenses 8,805,000 1.995.000 Net operating income 9,500,000 Average divisional operating assets 10 11 12 The Northern Division has an opportunity to add a new product line at the beginning of the year as follows: 13 2,500,000 Average required investment Net operating income 14 400,000 15 16 15% 17 Adams Corporation's minimum acceptable rate of return 18 19 Assuming the company accepts all projects that meet or exceed the minimum rate of return, compute the following