Trucking Expense Spreadsheet 46178 | Useful Spreadsheets For Financial Planning

Partial file snippet.

Sheet 1: Quarterly Cash Flow - Example

	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		Cash Flow Statement
		

		

	
	
		

		

		

		For the Year:
		

		2020
		

		

		

		

		

		

		

		

	
	
		Category
		

		Qtr 1
		

		Qtr 2
		

		Qtr 3
		

		Qtr 4
		

		Total
		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Cash Inflows:
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Sale of Market Lambs
		

		

		

		

		

		$20,592 
		

		$5,148 
		

		$25,740 
		

		

	
	
		

		Sale of culls
		

		

		

		$620 
		

		

		

		$1,000 
		

		$1,620 
		

		

	
	
		

		Sale of wool
		

		

		

		

		

		$435 
		

		

		

		$435 
		

		

	
	
		

		Revenue from Custom Work
		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Other Cash Inflows (Transfers, Misc., etc.)
		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Non-Farm Income
		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		A
		Total Cash Inflows
		

		$0 
		

		$620 
		

		$21,027 
		

		$6,148 
		

		$27,795 
		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Cash Outflows:
		

		

		

		

		

		

		

		

		

		

		Rows 16-39 can come directly from your Schedule F tax form
		

	
	
		

		Car & Truck Expenses
		

		

		

		

		

		

		

		

		

		$0 
		

		Do Not include your annual Depreciation & Section 179 Expense from your Schedule F.
	
	
		

		Chemicals
		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Conservation Expenses
		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Custom Hire
		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Employee Benefits
		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Feed Purchased
		

		$739 
		

		

		

		

		

		$3,800 
		

		$4,539 
		

		

	
	
		

		Fertilizer & Lime
		

		

		

		$436 
		

		

		

		$693 
		

		$1,129 
		

		

	
	
		

		Freight & Trucking
		

		

		

		

		

		$487 
		

		$68 
		

		$555 
		

		

	
	
		

		Gasoline, fuel, oil
		

		

		

		$2,178 
		

		$3,000 
		

		

		

		$5,178 
		

		

	
	
		

		Insurance
		

		$1,000 
		

		

		

		

		

		

		

		$1,000 
		

		

	
	
		

		Labor hired
		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Pension & Profit-Sharing
		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Rent or lease - M&E
		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Rent/lease - other 
		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Repairs
		

		

		

		$300 
		

		

		

		

		

		$300 
		

		

	
	
		

		Seeds & Plants Purchased
		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Storage & Warehousing
		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Supplies Purchased
		

		$100 
		

		

		

		

		

		$100 
		

		$200 
		

		

	
	
		

		Taxes (property)
		

		

		

		$1,000 
		

		

		

		$1,000 
		

		$2,000 
		

		

	
	
		

		Utilities
		

		$25 
		

		$20 
		

		$20 
		

		$25 
		

		$90 
		

		

	
	
		

		Vet, breeding, medicine
		

		

		

		$931 
		

		

		

		$931 
		

		$1,862 
		

		

	
	
		

		Marketing
		

		

		

		

		

		$1,000 
		

		$322 
		

		$1,322 
		

		

	
	
		

		Other
		

		$400 
		

		$400 
		

		$400 
		

		$400 
		

		$1,600 
		

		

	
	
		

		Capital Purchases (Cash)
		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Principal Payments - Term Debt
		

		$712 
		

		$713 
		

		$712 
		

		$713 
		

		$2,850 
		

		

	
	
		

		Interest Payments - Term Debt
		

		$313 
		

		$312 
		

		$313 
		

		$312 
		

		$1,250 
		

		

	
	
		

		Family Living Expenses
		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Income Taxes (including SE & Payroll taxes)
		

		

		

		$1,000 
		

		

		

		

		

		$1,000 
		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		B
		Total Cash Outflows
		

		$3,289 
		

		$7,290 
		

		$5,932 
		

		$8,364 
		

		$24,875 
		

		

	
	
		C
		Net Cash Flow
		

		($3,289)
		

		($6,670)
		

		$15,095 
		

		($2,216)
		

		$2,921 
		

		

	
	
		

		(Line A - Line B)
		

		

		

		

		

		

		

		

		

		(A - B)
		

		

	
	
		D
		Beginning Cash Balance
		

		
		Alex White:
Enter your Checking Account Balance for January 1.
		$5,000 
		

		$1,712 
		

		$1,000 
		

		$9,898 
		

		$5,000 
		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		(D 1)
		

		

	
	
		E
		Unadjusted Cash Balance
		

		$1,712 
		

		($4,959)
		

		$16,095 
		

		$7,682 
		

		$7,921 
		

		

	
	
		

		(Line C + Line D)
		

		

		

		

		

		

		

		

		

		(C + D)
		

		

	
	
		F
		Mininum Balance Desired
		

		
		Alex White:
Enter the minimum cash balance you want to keep on hand or in your checking account.
		$1,000 
		

		$1,000 
		

		$1,000 
		

		$1,000 
		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		G
		Cash Avail. to Repay Operating Loan
		

		$712 
		

		$0 
		

		$15,095 
		

		$6,682 
		

		

		

		

	
	
		

		(If E > F, E - F, 0)
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		H
		Operating Loan Needed
		
		Alex White:
Enter the APR for your Operating Line of Credit
		8.00% APR
		$0 
		

		$5,959 
		

		$0 
		

		$0 
		

		$5,959 
		

		

	
	
		

		(If F > E, F - E, 0)
		

		

		

		

		

		

		

		

		

		(H1+H2+H3+H4)
		

		

	
	
		I
		Cumulative Operating Loan Balance
		
		Alex White:
Enter the outstanding balance of your operating loan as of January 1.
		$0 
		$0 
		

		$5,959 
		

		$5,959 
		

		$0 
		

		$0 
		

		

	
	
		

		(Existing Op Loan - Op Loan Principal Paid in previous qtr. + Line H )
		

		

		

		

		

		

		

		

		(I4 - M4)
		

		

	
	
		J
		Accrued Interest on Operating Loan
		
		Alex White:
Enter the amount of accrued interest on your operating loan as of January 1.
		$0 
		$0 
		

		$119 
		

		$238 
		

		$0 
		

		$0 
		

		

	
	
		

		(I x Int Rate/4 + Acc Int from previous qtr - Op. Interest Paid in previous qtr.
		

		

		

		

		

		

		

		

		

		(J4 - K4)
		

		

	
	
		K
		Interest Paid on Operating Loan
		

		$0 
		

		$0 
		

		$238 
		

		$0 
		

		$238 
		

		

	
	
		

		(If G > J, J, G)
		

		

		

		

		

		

		

		

		

		(K1+K2+K3+K4)
		

		

	
	
		L
		Cash Available to Repay Op Loan Principal
		

		$712 
		

		$0 
		

		$14,857 
		

		$6,682 
		

		

		

		

	
	
		

		(G - K)
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		M
		Operating Loan Principal Repaid
		

		$0 
		

		$0 
		

		$5,959 
		

		$0 
		

		$5,959 
		

		

	
	
		

		(If L > I, I, L)
		

		

		

		

		

		

		

		

		

		(M1+M2+M3+M4)
		

		

	
	
		N
		Ending Cash Balance
		

		$1,712 
		

		$1,000 
		

		$9,898 
		

		$7,682 
		

		$7,682 
		

		

	
	
		

		(Line E + H - K - M)
		

		

		

		

		

		

		

		

		

		(E + H - K - M)
		

		

	



Sheet 2: Quarterly Cash Flow - Blank

	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		Cash Flow Statement
		

		

	
	
		

		

		

		For the Year:
		

		2020
		

		

		

		

		

		

		

		

	
	
		Category
		

		Qtr 1
		

		Qtr 2
		

		Qtr 3
		

		Qtr 4
		

		Total
		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Cash Inflows:
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Revenue from Custom Work
		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Other Cash Inflows (Transfers, Misc., etc.)
		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Non-Farm Income
		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		A
		Total Cash Inflows
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Cash Outflows:
		

		

		

		

		

		

		

		

		

		

		Rows 16-38 can come directly from your Schedule F tax form
		

	
	
		

		Car & Truck Expenses
		

		

		

		

		

		

		

		

		

		$0 
		

		Do Not include your annual Depreciation & Section 179 Expense from your Schedule F.
	
	
		

		Chemicals
		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Conservation Expenses
		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Custom Hire
		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Employee Benefits
		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Feed Purchased
		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Fertilizer & Lime
		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Freight & Trucking
		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Gasoline, fuel, oil
		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Insurance
		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Labor hired
		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Pension & Profit-Sharing
		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Rent or lease - M&E
		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Rent/lease - other 
		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Repairs
		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Seeds & Plants Purchased
		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Storage & Warehousing
		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Supplies Purchased
		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Taxes (property)
		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Utilities
		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Vet, breeding, medicine
		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Marketing
		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Other
		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Capital Purchases (Cash)
		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Principal Payments - Term Debt
		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Interest Payments - Term Debt
		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Family Living Expenses
		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Income Taxes (including SE & Payroll taxes)
		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		B
		Total Cash Outflows
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		

	
	
		C
		Net Cash Flow
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		

	
	
		

		(Line A - Line B)
		

		

		

		

		

		

		

		

		

		(A - B)
		

		

	
	
		D
		Beginning Cash Balance
		

		
		Alex White:
Enter your Checking Account Balance for January 1.
		$5,000 
		

		$5,000 
		

		$5,000 
		

		$5,000 
		

		$5,000 
		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		(D 1)
		

		

	
	
		E
		Unadjusted Cash Balance
		

		$5,000 
		

		$5,000 
		

		$5,000 
		

		$5,000 
		

		$5,000 
		

		

	
	
		

		(Line C + Line D)
		

		

		

		

		

		

		

		

		

		(C + D)
		

		

	
	
		F
		Mininum Balance Desired
		

		
		Alex White:
Enter the minimum cash balance you want to keep on hand or in your checking account.
		$1,000 
		

		$1,000 
		

		$1,000 
		

		$1,000 
		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		G
		Cash Avail. to Repay Operating Loan
		

		$4,000 
		

		$4,000 
		

		$4,000 
		

		$4,000 
		

		

		

		

	
	
		

		(If E > F, E - F, 0)
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		H
		Operating Loan Needed
		
		Alex White:
Enter the APR for your Operating Line of Credit
		8.00% APR
		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		

	
	
		

		(If F > E, F - E, 0)
		

		

		

		

		

		

		

		

		

		(H1+H2+H3+H4)
		

		

	
	
		I
		Cumulative Operating Loan Balance
		
		Alex White:
Enter the outstanding balance of your operating loan as of January 1.
		$0 
		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		

	
	
		

		(Existing Op Loan - Op Loan Principal Paid in previous qtr. + Line H )
		

		

		

		

		

		

		

		

		(I4 - M4)
		

		

	
	
		J
		Accrued Interest on Operating Loan
		
		Alex White:
Enter the amount of accrued interest on your operating loan as of January 1.
		$0 
		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		

	
	
		

		(I x Int Rate/4 + Acc Int from previous qtr - Op. Interest Paid in previous qtr.
		

		

		

		

		

		

		

		

		

		(J4 - K4)
		

		

	
	
		K
		Interest Paid on Operating Loan
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		

	
	
		

		(If G > J, J, G)
		

		

		

		

		

		

		

		

		

		(K1+K2+K3+K4)
		

		

	
	
		L
		Cash Available to Repay Op Loan Principal
		

		$4,000 
		

		$4,000 
		

		$4,000 
		

		$4,000 
		

		

		

		

	
	
		

		(G - K)
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		M
		Operating Loan Principal Repaid
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		

	
	
		

		(If L > I, I, L)
		

		

		

		

		

		

		

		

		

		(M1+M2+M3+M4)
		

		
	
		N
		Ending Cash Balance
		

		$5,000 
		

		$5,000 
		

		$5,000 
		

		$5,000 
		

		$5,000 
		

		

	
	
		

		(Line E + H - K - M)
		

		

		

		

		

		

		

		

		

		(E + H - K - M)
		

		

	



Sheet 3: Monthly Cash Flow - Blank

	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		Cash Flow Statement
		

		

	
	
		

		

		

		For the Year:
		

		2020
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Category
		

		January
		

		February
		

		March
		

		April
		

		May
		

		June
		

		July
		

		August
		

		September
		

		October
		

		November
		

		December
		

		Total
		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Cash Inflows:
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Sales Revenues: Enterprise A
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Sales Revenues: Enterprise B
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Sales Revenues: Enterprise C
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Revenue from Custom Work
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Other Cash Inflows (Transfers, Misc., etc.)
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Non-Farm Income
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		A
		Total Cash Inflows
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Cash Outflows:
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		Rows 16-37 can come directly from your Schedule F tax form
		

	
	
		

		Car & Truck Expenses
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		$0 
		

		Do Not include your annual Depreciation & Section 179 Expense from your Schedule F.
	
	
		

		Chemicals
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Conservation Expenses
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Custom Hire
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Employee Benefits
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Feed Purchased
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Fertilizer & Lime
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Freight & Trucking
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Gasoline, fuel, oil
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Insurance
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Labor hired
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Pension & Profit-Sharing
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Rent or lease - M&E
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Rent/lease - other 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Repairs
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Seeds & Plants Purchased
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Storage & Warehousing
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Supplies Purchased
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Taxes (property)
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Utilities
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Vet, breeding, medicine
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Other
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Cash Transfers (to other accounts)
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Capital Purchases (Cash)
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Principal Payments - Term Debt
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Interest Payments - Term Debt
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Family Living Expenses
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		Income Taxes (including SE & Payroll taxes)
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		$0 
		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		B
		Total Cash Outflows
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		

	
	
		C
		Net Cash Flow
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		

	
	
		

		(Line A - Line B)
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		(A - B)
		

		

	
	
		D
		Beginning Cash Balance
		

		
		Alex White:
Enter your Checking Account Balance for January 1.
		$1,000 
		

		$1,000 
		

		$1,000 
		

		$1,000 
		

		$1,000 
		

		$1,000 
		

		$1,000 
		

		$1,000 
		

		$1,000 
		

		$1,000 
		

		$1,000 
		

		$1,000 
		

		$1,000 
		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		(D 1)
		

		

	
	
		E
		Unadjusted Cash Balance
		

		$1,000 
		

		$1,000 
		

		$1,000 
		

		$1,000 
		

		$1,000 
		

		$1,000 
		

		$1,000 
		

		$1,000 
		

		$1,000 
		

		$1,000 
		

		$1,000 
		

		$1,000 
		

		$1,000 
		

		

	
	
		

		(Line C + Line D)
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		(C + D)
		

		

	
	
		F
		Mininum Balance Desired
		

		
		Alex White:
Enter the minimum cash balance you want to keep on hand or in your checking account.
		$1,000 
		

		$1,000 
		

		$1,000 
		

		$1,000 
		

		$1,000 
		

		$1,000 
		

		$1,000 
		

		$1,000 
		

		$1,000 
		

		$1,000 
		

		$1,000 
		

		$1,000 
		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		G
		Cash Avail. to Repay Operating Loan
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		

		

		

	
	
		

		(If E > F, E - F, 0)
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		H
		Operating Loan Needed
		
		Alex White:
Enter the APR for your Operating Line of Credit
		6.00% APR
		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		

	
	
		

		(If F > E, F - E, 0)
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		(H1+H2+H3+H4)
		

		

	
	
		I
		Cumulative Operating Loan Balance
		
		Alex White:
Enter the outstanding balance of your operating loan as of January 1.
		$0 
		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		

	
	
		

		(Existing Op Loan - Op Loan Principal Paid in previous month + Line H )
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		(I4 - M4)
		

		

	
	
		J
		Accrued Interest on Operating Loan
		
		Alex White:
Enter the amount of accrued interest on your operating loan as of January 1.
		$0 
		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		

	
	
		

		(I x Int Rate/12 + Acc Int from previous month - Op. Interest Paid in previous month.
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		(J4 - K4)
		

		

	
	
		K
		Interest Paid on Operating Loan
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		

	
	
		

		(If G > J, J, G)
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		(K1+K2+K3+K4)
		

		

	
	
		L
		Cash Available to Repay Op Loan Principal
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		

		

		

	
	
		

		(G - K)
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		M
		Operating Loan Principal Repaid
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		$0 
		

		

	
	
		

		(If L > I, I, L)
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		(M1+M2+M3+M4)
		

		

	
	
		N
		Ending Cash Balance
		

		$1,000 
		

		$1,000 
		

		$1,000 
		

		$1,000 
		

		$1,000 
		

		$1,000 
		

		$1,000 
		

		$1,000 
		

		$1,000 
		

		$1,000 
		

		$1,000 
		

		$1,000 
		

		$1,000 
		

		

	
	
		

		(Line E + H - K - M)
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		(E + H - K - M)

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

...Sheet quarterly cash flow example statement for the year category qtr total inflows sale of market lambs culls wool revenue from custom work other transfers misc etc nonfarm income a outflows rows can come directly your schedule f tax form car amp truck expenses do not include annual depreciation section expense chemicals conservation hire employee benefits feed purchased fertilizer lime freight trucking gasoline fuel oil insurance labor hired pension profitsharing rent or lease m e rentlease repairs seeds plants storage warehousing supplies taxes property utilities vet breeding medicine marketing capital purchases principal payments term debt interest family living including se payroll b c net line d beginning balance alex white enter checking account january unadjusted mininum desired minimum you want to keep on hand in g avail repay operating loan if gt h needed apr credit hhhh i cumulative outstanding as existing op paid previous j accrued amount x int rate acc k kkkk l available r...

Related files

Share

Help

Cash Flow Statement
			For the Year:	2020
Category			January	February	March	April	May	June	July	August	September	October	November	December	Total

	Cash Inflows:
	Sales Revenues: Enterprise A														$0
	Sales Revenues: Enterprise B														$0
	Sales Revenues: Enterprise C														$0
	Revenue from Custom Work														$0
	Other Cash Inflows (Transfers, Misc., etc.)														$0
	Non-Farm Income														$0

A	Total Cash Inflows		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0

	Cash Outflows:															Rows 16-37 can come directly from your Schedule F tax form
	Car & Truck Expenses														$0		Do Not include your annual Depreciation & Section 179 Expense from your Schedule F.
	Chemicals														$0
	Conservation Expenses														$0
	Custom Hire														$0
	Employee Benefits														$0
	Feed Purchased														$0
	Fertilizer & Lime														$0
	Freight & Trucking														$0
	Gasoline, fuel, oil														$0
	Insurance														$0
	Labor hired														$0
	Pension & Profit-Sharing														$0
	Rent or lease - M&E														$0
	Rent/lease - other														$0
	Repairs														$0
	Seeds & Plants Purchased														$0
	Storage & Warehousing														$0
	Supplies Purchased														$0
	Taxes (property)														$0
	Utilities														$0
	Vet, breeding, medicine														$0
	Other														$0
	Cash Transfers (to other accounts)														$0
	Capital Purchases (Cash)														$0
	Principal Payments - Term Debt														$0
	Interest Payments - Term Debt														$0
	Family Living Expenses														$0
	Income Taxes (including SE & Payroll taxes)														$0

B	Total Cash Outflows		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
C	Net Cash Flow		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
	(Line A - Line B)														(A - B)
D	Beginning Cash Balance		Alex White: Enter your Checking Account Balance for January 1. $1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000
															(D 1)
E	Unadjusted Cash Balance		$1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000
	(Line C + Line D)														(C + D)
F	Mininum Balance Desired		Alex White: Enter the minimum cash balance you want to keep on hand or in your checking account. $1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000

G	Cash Avail. to Repay Operating Loan		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
	(If E > F, E - F, 0)
H	Operating Loan Needed	Alex White: Enter the APR for your Operating Line of Credit 6.00% APR	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
	(If F > E, F - E, 0)														(H1+H2+H3+H4)
I	Cumulative Operating Loan Balance	Alex White: Enter the outstanding balance of your operating loan as of January 1. $0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
	(Existing Op Loan - Op Loan Principal Paid in previous month + Line H )														(I4 - M4)
J	Accrued Interest on Operating Loan	Alex White: Enter the amount of accrued interest on your operating loan as of January 1. $0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
	(I x Int Rate/12 + Acc Int from previous month - Op. Interest Paid in previous month.														(J4 - K4)
K	Interest Paid on Operating Loan		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
	(If G > J, J, G)														(K1+K2+K3+K4)
L	Cash Available to Repay Op Loan Principal		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
	(G - K)
M	Operating Loan Principal Repaid		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
	(If L > I, I, L)														(M1+M2+M3+M4)
N	Ending Cash Balance		$1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000
	(Line E + H - K - M)														(E + H - K - M)

Related files

Share

Share to social media

Help

Login Area