Help please! answer must be in the exact Excel formula!! I got a few figured out but the two that are left blank in the highlighted area i cannot figure out the correct exact Excel Formula!

Please help!

1. Compute return on investment (ROI). 2. Compute residual income 30 All answers must be entered as a formula. Click OK to begin. OK 1. Compute return on investment (ROD. 2. Compute residual income. XL Return on Investment (ROI) and Residual Income - Excel 2 - Ar X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri - AA 96 LE Paste BIU- > -A- des Editing Alignment Number Conditional Format as del Formatting Table Styles Styles Clipboard Font A A1 Adams Corporation evaluates divisional managers based on ROI. Operating 8 C D es 1 E F 2 4 Adams Corporation evaluates divisional managers based on ROI. Operating results for the company's Northern Division for last year are given below: 3 Sales $ 27,000,000 Variable expenses 16,200,000 Contribution margin 10,800,000 Fixed expenses 8,805.000 Net operating income $ 1.995.000 5 6 7 8 9 10 Average divisional operating assets 11 $ 9.500,000 12 The Northern Division has an opportunity to add a new product line at the beginning of the year as follows: 13 14 15 Average required investment Net operating income $ $ 16 2,500,000 400,000 17 Adams Corporation's minimum acceptable rate of return 18 15% 19 Assuming the company accepts all projects that meet or exceed the minimum rate of retum, compute the following: 20 Prex 3 of 3 1. Compute return on Investment (ROI), 2. Compute residual income. XB Return on Investment (ROI) and Residual Income - Excel ? - 5 X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri 111 % Paste BI U A Alignment Number Cells Editing Conditional Format as Cell Formatting Table Styles Stiles Clipboard Font A1 Adams Corporation evaluates divisional managers based on ROI. Operating A B D E F es 15 Net operating income $ 400,000 16 17 Adams Corporation's minimum acceptable rate of return 15% 18 19 Assuming the company accepts all projects that meet or exceed the minimum cate of return, compute the following: 20 21.00% 19.96% 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 $ 570,000 $ 595,000