✔
4
Table 1. A cash flow statement of the Whitmer farm
Cash Flow Statement Name Whitmer Farm Projected for 19 91 Actual for 19 90 Date completed Jan. 1991
Period Last Year
Jan. Feb. March April May June July Aug. Sept. Oct. Nov. Dec.
Totals
Cash Inflows
1. Crop sales
98,210 15,500 78,500 12,000 106,000
2. Livestock and livestock product sales
23,414 14,400 10,350 3,840 28,590
3. Government payments
12,786 6,700 2,280 8,980
4. Capital sales
2,300 0
5. Other farm income
0
6. Nonfarm income
2,800 800 800 800 800 3,200
7. Total cash inflow (Lines 1 thru 6)
139,510 15,200 23,000 3,80 0 0 0 10,350 0 0 82,340 12,000 800 146,770
Cash Operating Expenses
8. Seed
7,100 5,000 2,500 7,500
9. Fertilizer, lime, chemicals
25,800 21,500 5,500 27,000
10. Feed
3,750 800 600 800 700 800 1,100 4,800
11. Livestock purchased for resale
9,165 3,825 5,750 9,575
12. Vet, medicine, breeding fees
250 50 50 50 50 50 50 300
13. Fuel, oil, lubricants
4,25 350 350 350 450 500 500 900 500 250 4,150
14. Utilities
1,740 200 200 150 150 150 150 150 150 150 150 200 200 2,000
15. Repairs
2,740 100 100 300 300 500 500 200 200 300 400 200 100 3,200
16. Taxes, insurance
3,625 950 1,725 950 3,625
17. Hired labor
1,80 450 300 400 1,150
18. Rent, leases
13,500 0 13,500 13,500
19. Machine hire
10,500 10,500 10,500
20. Supplies, miscellaneous, others
2,115 400 150 150 150 150 150 400 150 150 150 150 150 2,300
21. Total cash operating expenses (Lines 8 thru 20)
85,390 1,900 450 5,425 5,600 27,400 7,50 1,500 1,000 9,425 2,950 26,200 700 89,600
Other Cash Outflows
22. Capital purchases
29,700 29,700
23. Family living
14,400 1,300 1,300 1,300 1,300 1,300 1,300 1,300 1,300 1,300 1,300 1,300 1,300 15,600
24. Other withdrawls and income taxes
1,475 4,200 4,200
25. Intermediate loan principal payments
3,600 1,850 8,250 10,100
26. Intermediate loan interest payments
1,710 875 2,900 3,775
27. Long-term loan principal payments
2,750 2,900 2,900
28. Long-term loan interest payments
7,980 7,830 7,830
29. Total cash outflow (Lines 21+22 thru 28)
117,305 3,200 12,480 40,625 9,625 28,700 8,350 2,800 2,300 10,725 15,400 27,500 2,000 163,705
Cash Flow Summary
30. Beginning cash balance
1,500 1,800 12,320 2,275 1,500 1,500 1,500 9,50 6,750 1,500 18,200 2,700
31. Inflows - outflows (Lines 7-29)
12,000 10,520 (545) (625) (700) 8,350 7,550 (300) (725) 66,940 (500) (200)
32. Cash position (Lines 30+31)
13,500 12,320 (225) (350) (200) (850) 9,50 6,750 (975) 68,440 2,700 1,500
33. New borrowing: operation
8,850 28,700 8,350 5,475
34. New borrowing: intermediate
27,500
35. New borrowing: long-term
36. Operating loan principal payments
11,250 47,890
37. Operating loan interest payments
450 2,350
38. Ending cash balance (Lines 32+33+34+35-36-37)
1,800 12,320 2,275 1,500 1,500 1,500 9,50 6,750 1,500 18,200 2,700 1,500
Loan Balances End of Period
39. Operating (previous period line 39+33-36)
11,250 0 0 0 8,850 37,550 45,900 45,900 45,900 51,375 3,485 3,485 3,485
40. Intermediate (previous period line 40+34-25)
17,000 17,000 17,000 44,500 42,650 42,650 42,650 42,650 42,650 42,650 34,400 34,400 34,400
41. Long-term (previous period line 41+35-27)
88,700 88,700 85,800 85,800 85,800 85,800 88,800 85,800 85,800 85,800 85,800 85,800 85,800