Question

1. Compute the DuPont ratios for the average farm in Georgia and Indiana for 2010 - 2016. Specically compute

a. Gross margin ratio,

b. Asset turnover ratio,

c. Operating returns on assets, and

d. Rate of return on Equity.

Using the data in the table sheet. Assume that the Income statement values occur during the year while the balance sheet numbers are for the end of year { the 2009 column for each state contains the balance sheet for the end of 2009 and the beginning of 2010 while the income statement values for 2010 represent costs and returns for 2010.

129,115 156,833 177,716 197,70 188,590 159,110 166447 24,384 30,404 30,272 29,719 33,934 28,08226,994 85,418 107,792 114,396 127,90 134,177 110,630 111,470 84403 116,773 157,173 137,644 149,645 121,789 106,316 39,347 52,452 21,219 17461 52,694 66,641 96,096 74,504 70,097 68,918 60,249 2,658 16,659 20,622 25,691 21,136 23,12 27.978 23,770 59,973 83,585 98,292 101891 112,388 90,390 78,711 48,339 693784,129 87,613 95,154 72,13 63,707 3,015 4,7204358 1557 3,024 7 14,405 14,643 28,327 35,764 18,921 17373 20,231 101,222 116,654 128,010 141,353 132,908 120,680 124,370 74,191 87,136 94,058 103,342 95,744 85,711 84,860 Total ash experves 8,667 13,875 11,411 1207 11450 9,080 9,443 1.545 1.287 1.079 # 5,8077030 9,113 7,830 8,543 10,177 7469 12,665 16,185 21,003 20,085 21,860 18,796 18,28:3 2573 3258 40283. 12,792 13,440 16,062 17514 16,832 15,68115,982 23,921 27,604 32,477 33,762 30439 28,264 27496 1,835 1,932 2,132 A 8,166 8,477 13,401 11,200 12,263 13,291 #N/A 592 8351 341 7516 s. 6,084 4,945 6,603 5,974 5,033 7,281 7414 8539 9458 8,667 8,636 7,901 1405 183 146 1518 1730 2157 2 27,031 29,518 33,953 38,010 3,164 34969 39,510 11,584 14,229 14,163 14,278 17,234 18,206 15,004 2,576 2,644 3,275 3,033 2,783 3,276 3,083 3,764 3,473 3,520 4362 4456 2,998 3,394 3,20 3,604 3,719 3.,345 4,022 4,430 6,486 6,755 5,578 24430 33,18 58,831 35,753 257 31,399 27,604 7881 12,18 13,522 12,020 12,1599,952 ,620 5,278 5,165 7,168 58s8 5,620 5.582 14,181 16,294 18,426 20,849 20,74018480 23,424 27,893 40,184 49,706 56427 55,682 38,430 42,077 12,658 16475 16,031 19.316 15,602 13,57611857 Rent and lease payments Net cashfarm income 3,878 4,682 1.620 1.112 #N/A #N/A 12,696 -1866 4,461 N/A 7,9508,823 34,673 8491 8,948 6,701 6,9145,929 4,590 5,682 5.285 24,326 28,233 55284 29,920 32,505 26,251 24,614 42,953 42,284 60,734 44,942 2835839.375 890,122 779,335 758,085 821558 857,503 887,106 913,082 921,381 80,921 43,109 41,550 32423 85し566 965,531 1,087.922 1,228,946 1,256949 1,244,067 1,206,177 1,194.969 90,730 148,813 126,811 138,591 128,033 128910 112,281 113,022 4,245 25,331 /A 54745,077 4,565 5,979 6,077 4318 39,232 47,941 54,493 40,665 55,185 51,1146,758 45,012 8,170 8,208 10,415 7,856 11,652 10,093 2157 ,708 3,105 2,447 2,103 12,909 45,073 37412 55,639 23,245 24,225 24,363 20,590 867484 721,836 686,037 718,097 776,583 843,997 871,532 888,958 50425 56,098 47,133 47,333 760,836 816,718 961,111 1,090,355 1,128,916 1,115,157 1,093,896 1,081,947 7711192 2913 1508 Assetr Land and buiding 787,014 637919 596,782 611323 673,196 729,546 758,795 783,599 Assets Operators dwellin 86,332 69,653 85,957 89,100 78,224 60,435 75,207 69,517 Assets Farm equipment 66,959 68,246 71384 90314 82,865 86944 85,369 81,958 Assets Breeding anima 13,264 15,104 17,101 15268 17,609 25,999 26,536 21388 46,067 39,408 56,405 68,909 67,221 90,527 86,639 74,719 9,697 11,200 16,651 17,305 22,772 23,623 24,836 Liabilities: Notes payable 2404 3,36 2,892688 7,346 9,179 10,660 13405 65649 702,711 829,418 931,279 974,734 959.397 947,868 923,025 106,331 101,466 112,539 108,278 108,848 86,645 98,022 85,291 92,315 101,158 119,150 144,537 137,153 133,563 129,965 144,313 11,320 12,043 11,608 13,120 15.341 15,1914405 1,869 94,680 104,411 107,879 123,487 133,379 162,389 157,250 155,574 29,288 33,380 33,609 42,356 43,658 58,508 52,227 51,256 14,726 17,614 16,516 22,358 21441 32,944 27,179 26,599 7539 8,155 8,777 10,529 11698 13,893 14,223 12,849 3,686 4,522 4,393 4313 3.986 352348590 154 1,902 2,565 2,447 2,110 Liabilities: Accounts payal 1.902 1,679 1.860 867 1,902 2,460 2,618 2,272 36,439 29,711 45,205 52,258 49,916 67,755 63,016 49,883 4,393 4,708 5,329 6,043 6,833 7,149 65,392 71,030 74,269 81,132 89,721 103,882 105,023 104,318 8888 9,511 10,976 15,860 17,762 21,998 22,969 17,557 56,504 61,519 63,293 65,272 71959 81,884 82,054 86,761 756836 861,121 980,043 1,105,459 1,123,570 1,081,677 1,048,927 1,039.395 32,439 25,271 40,512 45,246 41,490 55,436 51,851 #N/A 844,054 739927 701,680 752,643 790,282 796,579 826,443 846,662