all answers must be entered as formula

Adams Corporatios evaluates divisional managers based on ROI. Operating results for the 2 company's Northern Division for last year are given below: The Northern Division has an opportunity to add a new product line at the beginning of the year as follows: \begin{tabular}{|r|l|rr|} \hline 14 & Average required investment & 5 & 2,500,000 \\ \hline 15 & Net openating income & 5 & 400,000 \\ \hline 16 & & & \\ \hline \end{tabular} 17 Adams Corporation's minimum acceptable rate of return 15% 19 Compute the following: \begin{tabular}{|l|l|} \hline 20 & \\ \hline 21 & Northern Division ROI for last year \\ \hline 22 & \end{tabular} Northem Division ROI if new product line is added Write an IF statement to determine whether the Northern Division 26 manager will ACCEPT or REJECT the new product line based on ROI. Northern Division residual income for last year Nortbern Division residual income if the new product line is added Write an IF statement to determine whether the Northern Division manager 33 will ACCEIT or REJECT the new product line based on residual income 34 35 16 37