please reference the cells used in calculation

Adams Corporation evaluates divisional managers based on Return on investment (ROI) and has provided the operating results of the Northem Division from last year The Controller has asked you to compute the ROl and Residual income based on data from last year and if the divsion adds a new product ilne The Northern Division has an opportunity to add a new product line as follows: Adams Corporation's minimum acceptable rate of return 15% Required: Compute the following 1. Northern Division ROl for last year 2. Northern Disiston ROI if new product line is added 3. Determine whether the Northern Division manager wil ACCEPT or REJECT the new product ine based on ROI. 4. Northern Dision residual income for last year 5. Northern Disison residual income if the new product line is added 6. Determine whether the Northern Division manoger will ACCEPT or REJECT the new product line based on residual income. Adams Corporation evaluates divisional managers based on ROI. Operating results for the company's Northern Division for last year are given below: Sales. Variable expenses Contribution matgin Fixed expenses Netoperating income Divisional operating assets \begin{tabular}{|r|} \hline$27,000,000 \\ \hline 16,200,000 \\ \hline 10,800,000 \\ \hline 8,805,000 \\ \hline$1,995,000 \\ \hline$9,500,000 \\ \hline \end{tabular} The Northern Division has an opportunity to add a new product line as follows: Alequired investment Net operating income 52,500,000 5400,000 Adams Corporation's minimum acceptable rate of return 15% Required: Compute the following: (Use celis Ad to 817 from the given information to complete this question.) 1. Northern Division ROl for last year 2. Northern Division ROl if new product line is added 3. Write an If statement to determine whether the Northern Division manager will ACCEPY or REIECT the new product line based on ROI. 4. Northern Division residual income for fast year 5. Northern Division residual income if the new product line is added 6. Determine whether the Northern Division manager Will ACCEPT or REECT the new product line based on residual income