USE FORMULA ! than answer for example

=b1+b3

=32

I NEED THE FORMULA!

Pont Styles E28 X f F D 1 Adams Corporation evaluates divisional managers based on ROI. Operating results for the 2 company's Northern Division for last year are given below: 3 4 $ 5 6 Sales Variable expenses Contribution margin Fixed expenses Net operating income 27,000,000 16,200,000 10,800,000 8,805,000 1995.000 7 8 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: Average required investment $ 2,500,000 Net operating income $ 400,000 13 14 15 16 18 17 Adams Corporation's minimum acceptable rate of return 15% 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 21.00% 22 A 3 C D E F 15 $ 400,000 Net operating income 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 rate of return, compute the following: 20 21 Northern Division ROI for last year 21.00% 22 19.96% + 23 Northern Division Rol 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 30 Northern Division residual income if the new product line is added 32 Write an IF statement to determine whether the Northern Division manager 33 Will ACCEPT OF REJECT the new product line based on residual income 34 35 29 31 36 37