Farm cashflow forecaster

How it works

Enter what you expect to receive and pay each month from July to June, your opening bank balance and your overdraft limit. The forecaster shows the closing balance for each month, the tightest month and any months over the limit. Your figures stay in your browser.

The working

Closing balance for a month = opening balance + receipts - payments - BAS paid (or + BAS refunded).
When GST is switched on, each line you mark as carrying GST is grossed up by 10% in the bank account, and the net GST for each quarter is paid or refunded in the BAS month: 28 October, 28 February and 28 April. The April to June quarter is due 28 July, after this year ends, so it shows as GST owing at 30 June.
Headroom = closing balance + overdraft limit. A negative headroom means the account would be over its limit that month.

General information only. This calculator doesn't take account of your circumstances and isn't tax, credit or financial product advice. Check figures with your accountant before relying on them.

Want the numbers done for you?

Farm CFO builds the budget, the monthly cashflow and the tests your lender will run, at a fixed price.

Bank Review Pack Ask Nick

Questions

Do I enter figures with or without GST?

Without. Enter every sale and cost excluding GST, then tick the lines that carry GST. The forecaster adds the GST to the bank account and settles it in the BAS months, which keeps each line easy to check against your budget. Your accountant can confirm which of your sales and costs carry GST.

How do I show an overdraft?

Enter the opening balance as a negative number if the account is overdrawn, and the overdraft limit as a positive number. The chart shows the limit as a line, so you can see how close each month comes.

Is my data saved or sent anywhere?

No. The figures are kept in your own browser so they are still there when you come back on the same device, and nothing is sent to Farm CFO or anyone else. Use Download CSV to keep a copy, or the Excel template for a version you can edit offline.

Can I test a bad season with these figures?

Yes. Open the season stress test on the same device and it picks up your forecast, then lets you cut prices, lift costs, delay sales and add interest to see what happens to the overdraft.

Sources

Other calculators

Bank review ratio checkWork out the ratios a lender looks at in a farm annual review: interest cover, debt service cover, debt to assets, equity, current ratio and debt per DSE or per sow.Season stress testTest a farm cashflow against lower prices, higher costs, delayed sales and higher interest, and see the effect on the overdraft and the months over limit.Seasonal repayment scheduleWork out farm loan repayments monthly, quarterly, half-yearly or annually, see the yearly schedule and which months repayments fall in, to match them to sale months.

Line	Jul	Aug	Sep	Oct	Nov	Dec	Jan	Feb	Mar	Apr	May	Jun	Year
Receipts
													$575,000
													$150,000
													$255,000
													$12,000
Operating costs
													$173,000
													$105,000
													$39,000
													$68,000
													$32,000
													$108,000
													$132,000
													$38,000
Interest
													$90,000
Loan principal
													$120,000
Drawings and capital
													$84,000
													$45,000
Receipts incl. GST	$0	$0	$0	$225,500	$176,000	$77,000	$99,000	$242,000	$154,000	$38,500	$66,000	$12,000	$1,090,000
Payments incl. GST	$64,500	$87,100	$133,000	$57,400	$118,500	$56,800	$55,200	$71,700	$131,600	$119,000	$128,400	$67,800	$1,091,000
BAS paid (refund negative)	$6,000			-$17,100				$35,300		$29,000			$53,200
Closing balance	-$250,500	-$337,600	-$470,600	-$285,400	-$227,900	-$207,700	-$163,900	-$28,900	-$6,500	-$116,000	-$178,400	-$234,200
Headroom to limit	$349,500	$262,400	$129,400	$314,600	$372,100	$392,300	$436,100	$571,100	$593,500	$484,000	$421,600	$365,800