Please provide answers in Excel Formulas only!

1 Adams Corporation evaluates divisional managers based on ROI. Operating results for the 2 company's Northern Division for last year are given below: Sales Variable expenses Contribution margin Fixed expenses Net operating income 27,000,000 16,200,000 10,800,000 8,805,000 1,995,000 4 9 Average divisional operating assets 9,500,000 10 12 The Northern Division has an opportunity to add a new product line at the beginning of the year as follows: 13 14 15 16 17 Adams Corporation's minimum acceptable rate of returrn 18 19 Compute the following 20 21 Northern Division ROI for last year Average required investment Net operating income 2,500,000 400,000 15% 21.00% 19.96% 23 Northern Division ROl if new product line is added 24