Monthly Budget Template 40697 | Monthly Cash Flow Budget

Partial file snippet.

Sheet 1: Dairy Mo Cash Flow Budget 

	
	
	
	
	
	
		

		

		FARM NAME:  
		

		
	
		

		

		Date Prepared:  
		

		
	
		DAIRY FARM  CASH FLOW PROJECTION
		
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		1 
		2 
		3 
		4 
		5 
		6 
		7 
		8 
		9 
		10 
		11 
		12 
		13
	
	
		Blue Text = Editable
		

		

		

		

		

		

		

		

		

		Minimum Cash Balance = 
		

		

		

		

		

		

	
	
		Black/Red Text = Calculated
		

		

		

		Monthly Cash Flow Budget/Projection 
		

	
	
		

		

		

		

		January
		February
		March
		April
		May
		June
		July
		August
		September
		October
		November
		December
		 Total 
	
	
		1 
		Cash Balance, Beginning
		

		

		

		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		 -   
	
	
		2 
		

		Cows Milking Prior Month(1)
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		3 
		

		lb. in Tank/ Cow/Day 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		4 
		

		Day in Month
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		5 
		

		Cwt. Shipped
		

		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
	
	
		6 
		

		Milk Price(2)
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		7 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		8 
		Cash Sales
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		9 
		

		Milk (Calc. based on above)
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		10 
		

		Grain
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		11 
		

		Livestock
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		12 
		

		Contract 
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		13 
		

		Government Payments
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		14 
		

		Coop Distributions
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		15 
		

		Custom Hire
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		16 
		

		Miscellaneous
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		17 
		Total Cash Sales
		

		

		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
	
	
		18 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		19 
		Cash Cost of Sales
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		20 
		

		Car & Truck
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		21 
		

		Chemicals & Spray
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		22 
		

		Conservation Exp
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		23 
		

		Custom Hire
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		24 
		

		Employee Benefits
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		25 
		

		Feed
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		26 
		

		Fertilizer/Line
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		27 
		

		Freight & Trucking(2)
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		28 
		

		Gas, Fuel, Oil
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		29 
		

		Insurance
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		30 
		

		Labor
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		31 
		

		Pension/Profit Sharing
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		32 
		

		Rent
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		33 
		

		Repairs and Maintence
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		34 
		

		Seeds and Plants
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		35 
		

		Storage/Warehousing
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		36 
		

		Supplies
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		37 
		

		Taxes
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		38 
		

		Utilities
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		39 
		

		Veterinary, Breeding, Med
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		40 
		

		Miscellaneous
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		41 
		

		Miscellaneous
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		42 
		

		Miscellaneous
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		43 
		Total Cash Operating Expenses
		

		

		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
	
	
		44 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		45 
		

		Operating Expense Ratio
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		46 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		47 
		Cash Operating Profit/(Loss)
		

		

		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
	
	
		48 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		49 
		Other Income/(Expense)
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		50 
		

		Non-Farm Salary/Wages
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		51 
		

		Interest Income
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		52 
		

		Interest Expense
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		53 
		Total Other Income/(Expense)
		

		

		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
	
	
		54 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		55 
		Net Cash Income/(Loss)
		

		

		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
	
	
		56 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		57 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		58 
		New Term Loan Advances
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		59 
		Sch. Term Principal Payments
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		60 
		Owner Contributions
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		61 
		Owner Withdrawals/Living
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		62 
		Capital Purchases
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		63 
		Capital Sales
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		64 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		65 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		66 
		Net Cash Flow B4 Cash/Oper. Loans
		

		

		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
	
	
		67 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		68 
		Available Cash (Deficit)(3)
		

		

		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
	
	
		69 
		Operating Loan Advances
		

		

		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
	
	
		70 
		Operating Principal Payments
		

		

		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
	
	
		71 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		72 
		Change in cash(4)
		

		

		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
	
	
		73 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		74 
		Cash Balance, Ending
		

		

		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
	
	
		75 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		76 
		Operating Loan Balance
		

		

		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
	
	
		77 
		Ave. Monthly Operating Loan Balance
		

		

		0 
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		78 
		Maximum Operating Loan Balance
		

		

		0 
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		(1)
		Production for each month is based on the milk shipped the prior month; thus cow numbers, days in month, and Lbs. in tank are from prior month.
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		(2)
		If using gross milk price, deduct milk marketing expenses under freight & trucking;  or  If using mailbox price, freight & trucking below is only for non-milk expenses.  
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		(3)
		Available Cash (Deficit) is:  Beginning cash balance plus Net Cash Flow B4 CAsh/Oper. Loans
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		(4)
		Change in cash is:  Net Cash Flow B4 Cash/Oper. Loans plus Operating Loan Advances less Operating Principal Payments
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	



Sheet 2: General Mo Cash Flow Budget

	
	
	
	
	
	
		

		

		FARM NAME:  
		

		
	
		

		

		Date Prepared:  
		

		
	
		GENERAL FARM BUSINESS CASH FLOW PROJECTION
		
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		1 
		2 
		3 
		4 
		5 
		6 
		7 
		8 
		9 
		10 
		11 
		12 
		13
	
	
		Blue Text = Editable
		

		

		

		

		

		

		

		

		

		Minimum Cash Balance = 
		

		

		

		

		

		

	
	
		Black/Red Text = Calculated
		

		

		

		Monthly Cash Flow Budget/Projection
		

	
	
		

		

		

		

		January
		February
		March
		April
		May
		June
		July
		August
		September
		October
		November
		December
		 Total 
	
	
		1 
		Cash Balance, Beginning
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		2 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		3 
		Cash Sales
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		4 
		

		Custom Hire
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		5 
		

		Grain
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		6 
		

		Livestock
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		7 
		

		Contract 
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		8 
		

		Government Payments
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		9 
		

		Coop Distributions
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		10 
		

		Miscellaneous
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		11 
		

		Miscellaneous
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		12 
		Total Cash Sales
		

		

		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
	
	
		13 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		14 
		Cash Cost of Sales
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		15 
		

		Car & Truck
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		16 
		

		Chemicals & Spray
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		17 
		

		Conservation Exp
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		18 
		

		Custom Hire
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		19 
		

		Employee Benefits
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		20 
		

		Feed
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		21 
		

		Fertilizer/Line
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		22 
		

		Freight & Trucking*
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		23 
		

		Gas, Fuel, Oil
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		24 
		

		Insurance
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		25 
		

		Labor
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		26 
		

		Pension/Profit Sharing
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		27 
		

		Rent
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		28 
		

		Repairs and Maintence
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		29 
		

		Seeds and Plants
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		30 
		

		Storage/Warehousing
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		31 
		

		Supplies
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		32 
		

		Taxes
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		33 
		

		Utilities
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		34 
		

		Veterinary, Breeding, Med
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		35 
		

		Miscellaneous
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		36 
		

		Miscellaneous
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		37 
		

		Miscellaneous
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		38 
		Total Cash Operating Expenses
		

		

		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
	
	
		39 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		40 
		

		Operating Expense Ratio
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		41 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		42 
		Cash Operating Profit/(Loss)
		

		

		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
	
	
		43 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		44 
		Other Income/(Expense)
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		45 
		

		Non-Farm Salary/Wages
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		46 
		

		Interest Income
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		47 
		

		Interest Expense
		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		48 
		Total Other Income/(Expense)
		

		

		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
	
	
		49 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		50 
		Net Cash Income/(Loss)
		

		

		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
	
	
		51 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		52 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		53 
		New Term Loan Advances
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		54 
		Sch. Term Principal Payments
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		55 
		Owner Contributions
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		56 
		Owner Withdrawals/Living
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		57 
		Capital Purchases
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		58 
		Capital Sales
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		0 
	
	
		59 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		60 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		61 
		Net Cash Flow B4 Cash/Oper. Loans
		

		

		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
	
	
		62 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		63 
		Available Cash (Deficit)(1)
		

		

		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
	
	
		64 
		Operating Loan Advances
		

		

		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
	
	
		65 
		Operating Principal Payments
		

		

		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
	
	
		66 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		67 
		Change in cash(2)
		

		

		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
	
	
		68 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		69 
		Cash Balance, Ending
		

		

		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
	
	
		70 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		71 
		Operating Loan Balance
		

		

		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
		0 
	
	
		72 
		Ave. Monthly Operating Loan Balance
		

		

		0 
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		73 
		Maximum Operating Loan Balance
		

		

		0 
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		(1)
		Available Cash (Deficit) is:  Beginning cash balance plus Net Cash Flow B4 CAsh/Oper. Loans
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		(2)
		Change in cash is:  Net Cash Flow B4 Cash/Oper. Loans plus Operating Loan Advances less Operating Principal Payments
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	



Sheet 3: Equip & Livestock Cap Budget

	
	
	
	
	
	
	
		Farm Name:  
		

		
	
		

		

		

		

		

		

		

		

	
	
		

		Machinery & Cattle Replacement, Major Repair Planner*
		
	
		 
		

		

		

		

		

		

		

	
	
		Capital Assets
		2021
		2022
		2023
		2024
		2025
		2026
		2027
	
	
		SP Forage Harvester
		

		

		

		

		

		

		

	
	
		PT Forage Harvesters
		

		

		

		

		

		

		

	
	
		Combine
		

		

		

		

		

		

		

	
	
		Merger
		

		

		

		

		

		

		

	
	
		Tractor 1-     160    HP
		

		

		

		

		

		

		

	
	
		Tractor 2-               HP
		

		

		

		

		

		

		

	
	
		Tractor 3-               HP
		

		

		

		

		

		

		

	
	
		Tractor 4-               HP
		

		

		

		

		

		

		

	
	
		Tractor 5-               HP
		

		

		

		

		

		

		

	
	
		Tractor 6-               HP
		

		

		

		

		

		

		

	
	
		Corn Planter
		

		

		

		

		

		

		

	
	
		No-Till Drill
		

		

		

		

		

		

		

	
	
		Skid Loader
		

		

		

		

		

		

		

	
	
		Mixer Wagon
		

		

		

		

		

		

		

	
	
		Car
		

		

		

		

		

		

		

	
	
		Manure Spreader
		

		

		

		

		

		

		

	
	
		Forage Wagons
		

		

		

		

		

		

		

	
	
		Dump Trucks
		

		

		

		

		

		

		

	
	
		Field Sprayer
		

		

		

		

		

		

		

	
	
		Pay Loader
		

		

		

		

		

		

		

	
	
		Bull Dozer
		

		

		

		

		

		

		

	
	
		Pickup Truck
		

		

		

		

		

		

		

	
	
		Cows
		

		

		

		

		

		

		

	
	
		CAFO Plan
		

		

		

		

		

		

		

	
	
		Stock Trailer
		

		

		

		

		

		

		

	
	
		Misc/Other
		

		

		

		

		

		

		

	
	
		Misc/Other
		

		

		

		

		

		

		

	
	
		Misc/Other
		

		

		

		

		

		

		

	
	
		TOTALS
		 $-   
		 $-   
		 $-   
		 $-   
		 $-   
		 $-   
		 $-   
	
	
		

		

		

		

		

		

		

		

	
	
		*  Capital items purchased that are depreciated.

The words contained in this file might help you see if this file matches what you are looking for:

...Sheet dairy mo cash flow budget farm name date prepared projection blue text editable minimum balance blackred calculated monthly budgetprojection january february march april may june july august september october november december total beginning cows milking prior month lb in tank cowday day cwt shipped milk price sales calc based on above grain livestock contract government payments coop distributions custom hire miscellaneous cost of car amp truck chemicals spray conservation exp employee benefits feed fertilizerline freight trucking gas fuel oil insurance labor pensionprofit sharing rent repairs and maintence seeds plants storagewarehousing supplies taxes utilities veterinary breeding med operating expenses expense ratio profit loss other income nonfarm salarywages interest net new term loan advances sch principal owner contributions withdrawalsliving capital purchases b cashoper loans available deficit change ending ave maximum production for each is the thus cow numbers days lb...

Related files

Share

Help

		FARM NAME:
		Date Prepared:
DAIRY FARM CASH FLOW PROJECTION

			1	2	3	4	5	6	7	8	9	10	11	12	13
*Blue Text = Editable*									Minimum Cash Balance =
*Black/Red Text = Calculated*			Monthly Cash Flow Budget/Projection
			January	February	March	April	May	June	July	August	September	October	November	December	Total
1	Cash Balance, Beginning			0	0	0	0	0	0	0	0	0	0	0	-
2		Cows Milking Prior Month(1)
3		lb. in Tank/ Cow/Day
4		Day in Month
5		Cwt. Shipped	0	0	0	0	0	0	0	0	0	0	0	0	0
6		Milk Price(2)
7
8	Cash Sales
9		Milk (Calc. based on above)													0
10		Grain													0
11		Livestock													0
12		Contract													0
13		Government Payments													0
14		Coop Distributions													0
15		Custom Hire													0
16		Miscellaneous													0
17	Total Cash Sales		0	0	0	0	0	0	0	0	0	0	0	0	0
18
19	Cash Cost of Sales
20		Car & Truck													0
21		Chemicals & Spray													0
22		Conservation Exp													0
23		Custom Hire													0
24		Employee Benefits													0
25		Feed													0
26		Fertilizer/Line													0
27		Freight & Trucking(2)													0
28		Gas, Fuel, Oil													0
29		Insurance													0
30		Labor													0
31		Pension/Profit Sharing													0
32		Rent													0
33		Repairs and Maintence													0
34		Seeds and Plants													0
35		Storage/Warehousing													0
36		Supplies													0
37		Taxes													0
38		Utilities													0
39		Veterinary, Breeding, Med													0
40		Miscellaneous													0
41		Miscellaneous													0
42		Miscellaneous													0
43	Total Cash Operating Expenses		0	0	0	0	0	0	0	0	0	0	0	0	0
44
45		Operating Expense Ratio
46
47	Cash Operating Profit/(Loss)		0	0	0	0	0	0	0	0	0	0	0	0	0
48
49	Other Income/(Expense)
50		Non-Farm Salary/Wages													0
51		Interest Income													0
52		Interest Expense													0
53	Total Other Income/(Expense)		0	0	0	0	0	0	0	0	0	0	0	0	0
54
55	Net Cash Income/(Loss)		0	0	0	0	0	0	0	0	0	0	0	0	0
56
57
58	New Term Loan Advances														0
59	Sch. Term Principal Payments														0
60	Owner Contributions														0
61	Owner Withdrawals/Living														0
62	Capital Purchases														0
63	Capital Sales														0
64
65
66	Net Cash Flow B4 Cash/Oper. Loans		0	0	0	0	0	0	0	0	0	0	0	0	0
67
68	Available Cash (Deficit)(3)		0	0	0	0	0	0	0	0	0	0	0	0	0
69	Operating Loan Advances		0	0	0	0	0	0	0	0	0	0	0	0	0
70	Operating Principal Payments		0	0	0	0	0	0	0	0	0	0	0	0	0
71
72	Change in cash(4)		0	0	0	0	0	0	0	0	0	0	0	0	0
73
74	Cash Balance, Ending		0	0	0	0	0	0	0	0	0	0	0	0	0
75
76	Operating Loan Balance		0	0	0	0	0	0	0	0	0	0	0	0	0
77	Ave. Monthly Operating Loan Balance		0
78	Maximum Operating Loan Balance		0

	*(1)*	*Production for each month is based on the milk shipped the prior month; thus cow numbers, days in month, and Lbs. in tank are from prior month.*
	*(2)*	*If using gross milk price, deduct milk marketing expenses under freight & trucking; or If using mailbox price, freight & trucking below is only for non-milk expenses.*
	*(3)*	*Available Cash (Deficit) is: Beginning cash balance plus Net Cash Flow B4 CAsh/Oper. Loans*
	*(4)*	Change in cash is: Net Cash Flow B4 Cash/Oper. Loans plus Operating Loan Advances less Operating Principal Payments

		FARM NAME:
		Date Prepared:
GENERAL FARM BUSINESS CASH FLOW PROJECTION

			1	2	3	4	5	6	7	8	9	10	11	12	13
*Blue Text = Editable*									Minimum Cash Balance =
*Black/Red Text = Calculated*			Monthly Cash Flow Budget/Projection
			January	February	March	April	May	June	July	August	September	October	November	December	Total
1	Cash Balance, Beginning
2
3	Cash Sales
4		Custom Hire													0
5		Grain													0
6		Livestock													0
7		Contract													0
8		Government Payments													0
9		Coop Distributions													0
10		Miscellaneous													0
11		Miscellaneous													0
12	Total Cash Sales		0	0	0	0	0	0	0	0	0	0	0	0	0
13
14	Cash Cost of Sales
15		Car & Truck													0
16		Chemicals & Spray													0
17		Conservation Exp													0
18		Custom Hire													0
19		Employee Benefits													0
20		Feed													0
21		Fertilizer/Line													0
22		Freight & Trucking*													0
23		Gas, Fuel, Oil													0
24		Insurance													0
25		Labor													0
26		Pension/Profit Sharing													0
27		Rent													0
28		Repairs and Maintence													0
29		Seeds and Plants													0
30		Storage/Warehousing													0
31		Supplies													0
32		Taxes													0
33		Utilities													0
34		Veterinary, Breeding, Med													0
35		Miscellaneous													0
36		Miscellaneous													0
37		Miscellaneous													0
38	Total Cash Operating Expenses		0	0	0	0	0	0	0	0	0	0	0	0	0
39
40		Operating Expense Ratio
41
42	Cash Operating Profit/(Loss)		0	0	0	0	0	0	0	0	0	0	0	0	0
43
44	Other Income/(Expense)
45		Non-Farm Salary/Wages													0
46		Interest Income													0
47		Interest Expense													0
48	Total Other Income/(Expense)		0	0	0	0	0	0	0	0	0	0	0	0	0
49
50	Net Cash Income/(Loss)		0	0	0	0	0	0	0	0	0	0	0	0	0
51
52
53	New Term Loan Advances														0
54	Sch. Term Principal Payments														0
55	Owner Contributions														0
56	Owner Withdrawals/Living														0
57	Capital Purchases														0
58	Capital Sales														0
59
60
61	Net Cash Flow B4 Cash/Oper. Loans		0	0	0	0	0	0	0	0	0	0	0	0	0
62
63	Available Cash (Deficit)(1)		0	0	0	0	0	0	0	0	0	0	0	0	0
64	Operating Loan Advances		0	0	0	0	0	0	0	0	0	0	0	0	0
65	Operating Principal Payments		0	0	0	0	0	0	0	0	0	0	0	0	0
66
67	Change in cash(2)		0	0	0	0	0	0	0	0	0	0	0	0	0
68
69	Cash Balance, Ending		0	0	0	0	0	0	0	0	0	0	0	0	0
70
71	Operating Loan Balance		0	0	0	0	0	0	0	0	0	0	0	0	0
72	Ave. Monthly Operating Loan Balance		0
73	Maximum Operating Loan Balance		0

	*(1)*	*Available Cash (Deficit) is: Beginning cash balance plus Net Cash Flow B4 CAsh/Oper. Loans*
	*(2)*	Change in cash is: Net Cash Flow B4 Cash/Oper. Loans plus Operating Loan Advances less Operating Principal Payments

Farm Name:

	Machinery & Cattle Replacement, Major Repair Planner*

Capital Assets	2021	2022	2023	2024	2025	2026	2027
SP Forage Harvester
PT Forage Harvesters
Combine
Merger
Tractor 1- 160 HP
Tractor 2- HP
Tractor 3- HP
Tractor 4- HP
Tractor 5- HP
Tractor 6- HP
Corn Planter
No-Till Drill
Skid Loader
Mixer Wagon
Car
Manure Spreader
Forage Wagons
Dump Trucks
Field Sprayer
Pay Loader
Bull Dozer
Pickup Truck
Cows
CAFO Plan
Stock Trailer
Misc/Other
Misc/Other
Misc/Other
TOTALS	$-	$-	$-	$-	$-	$-	$-

* Capital items purchased that are depreciated.

Related files

Share

Share to social media

Help

Login Area