Please help!! Answers have to be submitted as Excel formulas!!
1. Compute return on investment (ROI. 2. Compute residual income. Return on Investment (ROI) and Residual Income Excel HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW Sign In H Conditional Format as Cell Cells Editing Formatting" Table" Styles Paste Alignment Number Clipboard r Font Styles A1 X - Adams Corporation evaluates divisional managers based on ROI. Operating 1Adams Corporation evaluates divisional managers based on ROI. Operating results for the 2company's Northern Division for last year are given below: 4 Sales Variable expenses Contribution margin Fixed expenses Net operating income 27,000,000 16 10,800,000 8,805,0 10 Average divisional operating assets 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 return 18 19 20 21 Northern Division ROI for last year Average required investment Net operating income 2,500,000 400,000 15% ning he comphat met r esced he minimum rate f trm.hefoliowing 23 Northern Division ROI if new product line is added 24 19 Assuming the company accepts all projects that meet or exceed the minimum rate of return, compute the following: 20 21 Northern Division ROI for last year 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 1. Compute return on investment (ROI. 2. Compute residual income. Return on Investment (ROI) and Residual Income Excel HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW Sign In H Conditional Format as Cell Cells Editing Formatting" Table" Styles Paste Alignment Number Clipboard r Font Styles A1 X - Adams Corporation evaluates divisional managers based on ROI. Operating 1Adams Corporation evaluates divisional managers based on ROI. Operating results for the 2company's Northern Division for last year are given below: 4 Sales Variable expenses Contribution margin Fixed expenses Net operating income 27,000,000 16 10,800,000 8,805,0 10 Average divisional operating assets 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 return 18 19 20 21 Northern Division ROI for last year Average required investment Net operating income 2,500,000 400,000 15% ning he comphat met r esced he minimum rate f trm.hefoliowing 23 Northern Division ROI if new product line is added 24 19 Assuming the company accepts all projects that meet or exceed the minimum rate of return, compute the following: 20 21 Northern Division ROI for last year 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
