please post formulas

1 10 points eBook Print References Mc Graw 1 Return on Investment (ROI) and Residual income-Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In ABC Show/Hide Comment 36 Spelling Research Thesauna Translate New Comment Delete Previous Next Show All Comments Show link Changes Proofing Language Comments A1 X fo Adams Corporation evaluates divisional managers based on ROL. Operating A 11 C D E P 1 Adams Corporation evaluates divisional managers based on ROL. Operating results for the 2 company's Northern Division for last year are given below: 3 4 Sales $ 5 Variable expenses 27,000,000 16,200,000 10,800,000 8.305.000 6 Contribution margin 7 Fixed expenses S 1.995.000 8 Net operating income 9 9.500.000 10 Average divisional operating assets 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 14 Average required investment 1 of 1 Score answer > Prov 74 x Simulation i 879 Saved Fixed expenses Net operating income 8,805,000 1.995.000 9 10 Average divisional operating assets 9.500.000 11 12 The Northern Division has an opportunity to add a new product line at the beginning of the year as follows: 13 14 Average required investment. 2,500,000 400,000 15 Net operating income 16 17 Adams Corporation's minimum acceptable rate of return 15% 18 19 Compute the following: 20 21 Northern Division ROI for last year 22 23 Northern Division ROI if new product line is added 24 25 Write an IF statement to determine whether the Northern Division 26 manager will ACCEPT or REJECT the new product line based on ROI. 27 28 Northern Division residual income for last year 29 30 Northern Division residual income if the new product line is added Sheet1 www *** READY www Coorn onewer Help Corporation's minimum acceptable rate of return 18 19 Compute the following: 20 21 Northern Division ROI for last year 22 23 Northern Division ROI if new product line is added 24 25 Write an IF statement to determine whether the Northern Division 26 manager will ACCEPT or REJECT the new product line based on ROI. 27 28 Northern Division residual income for last year 29 30 Northern Division residual income if the new product line is added 31 32 Write an IF statement to determine whether the Northern Division manager 33 will ACCEPT or REJECT the new product line based on residual income 34 35 36 37 Sheet1 *** A 15%