Cash Flow Statement worksheet Cash Flow Statements 4061 Leanne Brown
Directions: Fill in the following chart from the receipts and expenditures given below. Make sure to complete the math within the chart. Then explain the benefits of having this on hand, would it be beneficial outside of the business world?
Corn Hay Beans Government payments Custom work Dividends, refunds, resale Cash, rent, other Livestock products Misc. Income Non-breeding livestock raised Livestock purchased for resale Breeding livestock sale Machinery, equipment, building sales Inflow from loans Non-farm receipts Hired labor Repairs Interest feed Seed, plants, other Fertilizers and chemicals Machine hire Supplies Breeding fees Misc. expense Vet medicine Fuel and oil Storage Taxes Insurance Utilities Cash rent Freight and trucking Conservation expense Livestock purchased for retail Breeding stock purchase BEEF Machinery and equipment purchased Land and building improvement Outflow from loans Non-farm expenses and investments Family living Crop Sales 1200 1600 6600 27,500 400 7900 9800 125 900 1100 1400 62,600 65,400 6600 27,900 17,860 2425 1100 2000 21,600 32,000 650 81,500 1500 2300 800 600 100 1300 1050 4100 25 85 325 300 120 400 6900 20 450 2700 5300 2100 2100 1900 9000 476,700 12,900 12,300 7300 36,100 850 200 19,100 20,150 12,673 1750 1260 10,675
160
2000 5000 650 50,200 2200 1500 1600 12,000 300 5000 600 2440 200 25 85,000 4900 2100 150 10,000 450 12,500 300 908 300 10,300 700 85 800 300 260,000 3800 2500 1400 1100 21,600 27,000
500 1800 1450 3400 200 300 2700 450 50 925 865 400 600 140
1025 500 150
18,200 1500 275 1000
70 500 5750 100
400 500 1300
650
74,050 9300
18,500 42,000 216,000 1750 3500 1500 1700 2100
1925 1830 2900 16,500 560 450 2700 74,700 3250 17,850 2100 140,000 416,500 290 300 2000 1200 11,750
Previous Months total: Jan: 19,290 Feb: 8555 Mar: -236,163 April: 19,062 May: 39,487 June: 2732
Cash Flow Statement
Receipts Crop Sales Corn Hay Beans Line 1 2 3 4 4 6 7 8 10 12 14 A 16 18 18 B C 20 21 D 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 E 45 46 47 48 49 F G 50 51 FL H I J K January February March April May June 6 month Subtotal
Government payments Custom work Dividends, refunds, resale Cash, rent, other Livestock products Misc. Income Non-breeding livestock raised Operating Sales Total Livestock purchased for resale Breeding livestock sale Machinery, equipment, building sales Capitol sales total Total farm receipts INFLOW FROM LOANS NON-FARM RECEIPTS TOTAL DOLLARS AVAILABLE Expenditures Hired labor Repairs Interest feed Seed, plants, other Fertilizers and chemicals Machine hire Supplies Breeding fees Misc. expense Vet medicine Fuel and oil Storage Taxes Insurance Utilities Cash rent Freight and trucking Conservation expense Operating expenditures total Livestock purchased for retail Breeding stock purchase BEEF Machinery and equipment purchased Land and building improvement Capital expenses total Total farm expenses Outflow from loans Non-farm expenses and investments Family living TOTAL DOLLARS USED Cash difference for month Cash balance beginning of month Cash balance end of month
From John Deere “Farm and Ranch Business Management”