Calculate ROI, Sales Margin, and Capital Turnover for every company using the information below.

1 A 1 Company 2 3 4 5 1 1 1 1 6 1 3 8 1 9 1 10 11 1 1 2 12 13 14 15 16 17 2 2 2 2 2 2 2 Investment Income 1 1.409735483 2 21.75802149 3 4204067211 4 378,5927608 5 424.5894653 6 578.1635577 7 1209.456373 8 1397.208844 9 2417.582167 10 5859.946852 11 22.75293304 12 47.8585 295 13 62.25139281 14 99.51902666 15 427,1814783 16 2489.07476 17 6236.916668 18 21310,68739 19 10784.09774 20 22553.14818 21 19685. 15626 22 32946.33587 23 131638.4636 24 1.07367938 25 33.6705354 26 241.1165172 27 234.3893771 28 499.7945015 29 758,0515591 30 694.7722288 31 660.9104697 32 1038.432233 33 2488.60286 34 2030.875117 35 3755,087504 36 3592.429569 37 16047.37107 38 16284.30182 39 1.029553252 Sales 0.141 0.513 4.426 3.99 29.305 24.033 66.089 17.133 174.01 512.951 -1.149 1.594 -1.075 2.218 98.414 170.581 355.6 1054.9 492.115 -393.523 3137.878 2054.523 8273 0.316 1.156 48,098 -17.321 13.641 23.174 -144.207 106.6 -56 141.377 -86 24.7 197 506 828.786 -0.03 Industry 2.224 23.734 40.457 215.315 887.245 541.545 540.112 674.314 3386.726 7386.626 31.184 37.61 39.594 204.168 959.934 2124.988 3567.5 5548.4 4937.063 15724.844 11800.116 22272.895 43604 2.09 11.348 440.804 353.467 84.422 457.374 295.844 1174.7 1509 1559.334 1892.5 3925.a 1445 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 38 34 35 36 37 38 29 2 3 3 3 3 3 3 3 3 3 3 4 4 4 4 4 7082 4 4 00 13649.287 0.542 4 Company Data D C A Company 4 5 5 5 5 5 5 5 5 5 5 5 6 18 19 50 51 52 53 54 55 56 57 6 6 6 6 6 6 58 59 60 61 02 63 Investment Income 40 124.2932249 41 119.8973355 42 74.8248633 43 172.7858617 44 168.386964 45 311.0611509 46 709.6863127 47 430.2213229 48 1100.396805 49 952.118519 50 1354.906771 51 1823.276774 52 3586,412743 53 3162.653495 54 3150.373208 55 2447.844514 56 4860.042603 57 8356.342442 58 29018.87046 1.56346676 60 16.89531072 61 31.99035096 62 55.72558543 63 65.86606639 64 68.28566925 55 99.96601179 06 288.3825149 67 385.1040397 904.0504425 69 637,887805 20 1812.34238 71 1134.739919 72 4853.009447 73 17525.547 74 5.75767493 75 44.39379986 76 117.3546549 77 91. 1980114 78 252 3746893 Sales -0.577 -0.721 15.931 7.463 13.557 17.236 56.672 -34.314 137.349 - 19.461 55.983 6.499 10.459 241,9 295.078 274,4 167 680.3 4833 -0.105 1.358 4.396 0.969 15.788 -0.212 1.635 33.138 9.865 4.923 30.9 -112.9 121.38 228.9 1012.14 -0.B41 -10.783 -0.832 5.016 3.208 Industry 76.332 194.873 142.298 221.03 168.446 317.017 792.907 307.624 1103.202 1741.779 1752.40 1617.64 2294.533 4071.4 3039.112 5966.9 5390 9611.8 30274 1.637 16.854 22.995 6.715 93.278 112.505 122.696 200.727 656,267 577.247 1164.5 1467.7 1193.975 2740.5 12711.744 5.59 39.632 30.442 100.203 79.925 6 6 6 7 7 7 7 7 7 7 64 65 66 67 00 7 70 71 72 2 7 8 8 8 8 74 75 76 77 78 79 8 8 8 Company Data 8 1 Company 80 81 82 83 84 8 9 9 9 9 9 9 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 Investment Income 79 261.4851901 80 687.8867749 31 896.8341029 82 878.8895513 83 2208.94644 34 2743.717447 85 4624.442031 86 3559.989496 87 4418.438574 88 5643.892269 89 23822,40596 90 18563,76329 91 17.5545982 92 473.8426893 93 331.6016618 94 624.0962484 95 1848.037891 96 2292.440195 97 927.184169 38 1934.083052 99 930.0109647 100 41.50820287 Sales -2.241 -73.282 25.641 79.423 192.248 131.883 -1047.96 788.7 694 147.212 820 - 157 1.863 25.625 13.739 -55.2% 101.614 236.1 -66.637 77.68 27.626717 10.082105 Industry 375.096 666.011 406.812 951.466 2205.683 2525.532 3886.072 6643,9 3244 2707.115 7002 12413 26.03 254,134 129.79 589.89 505.841 1700.1 715.656 896.377 421.364044 27.05592 9 9 9 9 10 10 10 10 10 10 10 10 10 10 1 A 1 Company 2 3 4 5 1 1 1 1 6 1 3 8 1 9 1 10 11 1 1 2 12 13 14 15 16 17 2 2 2 2 2 2 2 Investment Income 1 1.409735483 2 21.75802149 3 4204067211 4 378,5927608 5 424.5894653 6 578.1635577 7 1209.456373 8 1397.208844 9 2417.582167 10 5859.946852 11 22.75293304 12 47.8585 295 13 62.25139281 14 99.51902666 15 427,1814783 16 2489.07476 17 6236.916668 18 21310,68739 19 10784.09774 20 22553.14818 21 19685. 15626 22 32946.33587 23 131638.4636 24 1.07367938 25 33.6705354 26 241.1165172 27 234.3893771 28 499.7945015 29 758,0515591 30 694.7722288 31 660.9104697 32 1038.432233 33 2488.60286 34 2030.875117 35 3755,087504 36 3592.429569 37 16047.37107 38 16284.30182 39 1.029553252 Sales 0.141 0.513 4.426 3.99 29.305 24.033 66.089 17.133 174.01 512.951 -1.149 1.594 -1.075 2.218 98.414 170.581 355.6 1054.9 492.115 -393.523 3137.878 2054.523 8273 0.316 1.156 48,098 -17.321 13.641 23.174 -144.207 106.6 -56 141.377 -86 24.7 197 506 828.786 -0.03 Industry 2.224 23.734 40.457 215.315 887.245 541.545 540.112 674.314 3386.726 7386.626 31.184 37.61 39.594 204.168 959.934 2124.988 3567.5 5548.4 4937.063 15724.844 11800.116 22272.895 43604 2.09 11.348 440.804 353.467 84.422 457.374 295.844 1174.7 1509 1559.334 1892.5 3925.a 1445 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 38 34 35 36 37 38 29 2 3 3 3 3 3 3 3 3 3 3 4 4 4 4 4 7082 4 4 00 13649.287 0.542 4 Company Data D C A Company 4 5 5 5 5 5 5 5 5 5 5 5 6 18 19 50 51 52 53 54 55 56 57 6 6 6 6 6 6 58 59 60 61 02 63 Investment Income 40 124.2932249 41 119.8973355 42 74.8248633 43 172.7858617 44 168.386964 45 311.0611509 46 709.6863127 47 430.2213229 48 1100.396805 49 952.118519 50 1354.906771 51 1823.276774 52 3586,412743 53 3162.653495 54 3150.373208 55 2447.844514 56 4860.042603 57 8356.342442 58 29018.87046 1.56346676 60 16.89531072 61 31.99035096 62 55.72558543 63 65.86606639 64 68.28566925 55 99.96601179 06 288.3825149 67 385.1040397 904.0504425 69 637,887805 20 1812.34238 71 1134.739919 72 4853.009447 73 17525.547 74 5.75767493 75 44.39379986 76 117.3546549 77 91. 1980114 78 252 3746893 Sales -0.577 -0.721 15.931 7.463 13.557 17.236 56.672 -34.314 137.349 - 19.461 55.983 6.499 10.459 241,9 295.078 274,4 167 680.3 4833 -0.105 1.358 4.396 0.969 15.788 -0.212 1.635 33.138 9.865 4.923 30.9 -112.9 121.38 228.9 1012.14 -0.B41 -10.783 -0.832 5.016 3.208 Industry 76.332 194.873 142.298 221.03 168.446 317.017 792.907 307.624 1103.202 1741.779 1752.40 1617.64 2294.533 4071.4 3039.112 5966.9 5390 9611.8 30274 1.637 16.854 22.995 6.715 93.278 112.505 122.696 200.727 656,267 577.247 1164.5 1467.7 1193.975 2740.5 12711.744 5.59 39.632 30.442 100.203 79.925 6 6 6 7 7 7 7 7 7 7 64 65 66 67 00 7 70 71 72 2 7 8 8 8 8 74 75 76 77 78 79 8 8 8 Company Data 8 1 Company 80 81 82 83 84 8 9 9 9 9 9 9 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 Investment Income 79 261.4851901 80 687.8867749 31 896.8341029 82 878.8895513 83 2208.94644 34 2743.717447 85 4624.442031 86 3559.989496 87 4418.438574 88 5643.892269 89 23822,40596 90 18563,76329 91 17.5545982 92 473.8426893 93 331.6016618 94 624.0962484 95 1848.037891 96 2292.440195 97 927.184169 38 1934.083052 99 930.0109647 100 41.50820287 Sales -2.241 -73.282 25.641 79.423 192.248 131.883 -1047.96 788.7 694 147.212 820 - 157 1.863 25.625 13.739 -55.2% 101.614 236.1 -66.637 77.68 27.626717 10.082105 Industry 375.096 666.011 406.812 951.466 2205.683 2525.532 3886.072 6643,9 3244 2707.115 7002 12413 26.03 254,134 129.79 589.89 505.841 1700.1 715.656 896.377 421.364044 27.05592 9 9 9 9 10 10 10 10 10 10 10 10 10 10