HELP

Adams Corporation evaluates divisional managers based on Return on Investment (ROI) and has provided the operating results of the Northern DIvision from last year. The Controller has asked you to compute the ROI and Residual Income based on data from last year and If the division adds a new product line. The Northern Division has an opportunity to add a new product IIne as follows: Adams Corporation's minimum acceptable rate of return 15% Requilred: Compute the following: 1. Northern DIvision ROI for last year 2. Northern DIvision ROI If new product line is added 3. DetermIne whether the Northern DIvIsIon manager will ACCEPT or REJECT the new product IIne based on ROI. 4. Northern Division residual Income for last year 5. Northern Division residual Income If the new product IIne Is added 6. DetermIne whether the Northern DIvIsIon manager will ACCEPT or REJECT the new product IIne based on residual Income. Navlgation: 1. Use the Open Excel In New Tab button to launch this question. 2. When finlshed in Excel, use the Save and Return to Assignment button In the lower right to return to Connect