How do I forecast cash flow for a dairy?

A month-by-month method that works

SHEBOYGAN, Wisconsin — To forecast cash flow for a dairy, build a month-by-month table of cash coming in and cash going out for the next twelve months, starting from your actual bank balance, and update it every month with real numbers. Cash flow differs from profit. A farm can be profitable on paper and still run out of cash in the month the feed bill, the loan payment and the tax bill all land together. The forecast tells you when that month is coming.

Set up the framework

Use a spreadsheet with twelve monthly columns. Start with your beginning cash balance. List cash inflows on top and outflows below, then calculate net cash for each month and the ending balance, which becomes the next month's starting point. Templates are available from farm finance programs such as the Center for Farm Financial Management, and extension programs like Ohio State's farm office and Iowa State's Ag Decision Maker publish worksheets and guidance.

Forecast inflows

The main inflow is the milk check. Use your handler's payment schedule; many pay in two installments, so put each in the right month. Estimate milk volume based on herd size, expected production and seasonal patterns, then apply a conservative price from your scenario budget. Add cull cow and calf sales, program payments such as Dairy Margin Coverage payments from FSA (put them in only when they are likely, not hoped for), crop sales and any off-farm income.

Forecast outflows

List expenses by month: feed, labor, vet and breeding, supplies, utilities, fuel, repairs, insurance, rent, loan principal and interest, taxes and family living draws. Many are lumpy. Insurance premiums, property taxes, equipment payments, seed and fertilizer, and Dairy Revenue Protection premiums from RMA-backed policies come due at specific times. Look at last year's bank statements to find them. The IRS Publication 225 helps with tax timing.

Look for the pinch months

Scan the ending balances. Where does cash go lowest or negative? That is the month to plan for. Options include timing purchases differently, arranging an operating line of credit in advance, adjusting a loan payment schedule or building a reserve. Talk with your lender before the pinch, not during it. Information on FSA loan options is at farmers.gov/loans.

Run a low-price version

Copy your forecast and lower the milk price and production. Raise feed cost. See what happens. If the low version runs out of cash, decide what you would change. This links your forecast to your scenario budget and gives you a plan rather than a surprise.

Update every month

At month end, enter actual numbers, compare to forecast, find the differences and roll the forecast forward so it always covers the next twelve months. Differences teach you: if feed is always higher than expected, adjust. Keep the forecast simple enough that you will actually update it. A complex spreadsheet updated twice a year is worth less than a plain one updated monthly.

Share it

Show the forecast to your lender, accountant and farm partners. Lenders tend to respond well to farmers who bring a clear, current cash flow plan. The SBA business plan guide has a useful structure for presenting financial projections. A forecast is a conversation starter with people who can help, and that is worth more than it sounds.