You are provided with Sales, Expenses, and beginning & ending Assets values for the year. These are shown for three operating divisions: East, Central and West. Calculate the Residual income, Simplified ROI, and DuPont ROI methods. Assume a target rate of return of 29%. Rank the performance of each division for ROI and Residual Value. East Division Central Division West Division Sales Expenses Net Income 11,520,000 10,720,000 Sales Expenses Net Income 7,360,000 5,544,000 Sales Expenses Net Income 4,064,000 3,392,000 Assets: 12/01/19 Assets: 12/31/19 Investment - annual avg. 2,640,000 2,784,000 Assets: 12/01/19 Assets: 12/31/19 Investment. annual avg. 4,480,000 5,440,000 Assets: 12/01/19 Assets: 12/31/19 Investment - annual avg. 1,920,000 2,160,000 Target Rate of Return 29.00% Target Rate of Return 29.00% Target Rate of Return 29.00% Net Income Investment - annual ave. ROI Simplified Return on Investment Method Net Income Investment - annual avg. ROI Net Income Investment - annual avg. ROI 11,520,000 Dupont Method - Return on Investment Method Profit Margin Sales 7,360,000 Net Income Profit Margin Sales 2 Net Income 3 Profit Margin 4,064,000 Sales Net Income Profit Margin 11,520,000 7,360,000 4,064,000 Asset Turnover Sales Investment - annual avg. Asset turnover 5 Sales 7 Investment - annual avg. 8 Asset turnover Sales Investment - annual avg. Asset turnover 0 Dupont Method - Return on investment Central Division - ROI 1 East Division - ROI 2 West Division - ROI Residual income Net Income Required return Residual income Net Income Required return Residual income 3 4 Net Income 35 Required return 36 Residual income 37 38 39 ROI - DuPont Method 40 Residual Income 41 Division Performance - Rank: Best=1, Worst =3