Dairy Hub

Dairy Business, Finance & Labor

How to Build a Monthly Cash Flow Projection for a Dairy

Tractor and milk tanker at a dairy

A cash flow projection is a month-by-month estimate of the money coming in and going out of your dairy. It answers a simple question: will there be enough in the account to cover the bills in each month, or will you need the line of credit? Lenders want one. More to the point, you want one, because it tells you about the lean months before you are standing in them.

You do not need special software. A spreadsheet with twelve columns, or a legal pad and some patience, will do the job. What you need is last year's records, a realistic milk price and a willingness to write down the numbers you would rather not look at.

Step 1: Gather your starting numbers

Pull together the records from the last year or two: milk checks, feed bills, labor, loan statements, tax returns, bank statements. If your records are a mix of notebook pages and receipts in a coffee can, now is a good time to settle on a better setup, and what to track and where is a good place to start. Then write down the cash you have on hand at the start of the projection.

Step 2: Set up the monthly grid

Create columns for each month, starting from the month you want the projection to begin. Rows go down the left side in two groups: cash coming in, and cash going out. At the bottom, add rows for net cash flow, beginning balance and ending balance.

Step 3: Estimate cash coming in

  • Milk sales. Multiply expected hundredweight shipped each month by the price you expect to be paid. Use your own check history for production, and be careful with the price. The milk check line by line shows what really lands in the account after deductions and hauling.
  • Cull cows and calves. Estimate how many animals leave each month and what they bring. These are lumpy, not steady.
  • Other income. Crop sales, custom work, patronage refunds, government payments, off-farm income if you use it for the business.
  • Loan proceeds. Only include a loan if it is approved. A loan that is merely hoped for is not cash.

Production is seasonal on many farms. A grazing herd that freshens in spring will ship more in summer. Herds in the Southeast may see a summer dip from heat stress. Do not spread annual milk evenly across twelve months unless your herd really does ship that way.

Step 4: Estimate cash going out

  • Feed. The biggest line for most dairies. Include purchased feed, mineral, commodities, and the cost of growing forage if you farm.
  • Labor. Wages, payroll taxes, workers compensation and benefits. Include your own pay or family draw.
  • Herd costs. Veterinary, breeding, supplies, milking supplies, DHI testing, bedding.
  • Utilities and fuel. Higher in winter for heating and in summer for cooling and fans.
  • Repairs and maintenance. Average it over the year, then add a bump for the month the TMR mixer decides to quit.
  • Insurance and taxes. Many are paid in lumps, so put them in the month they actually come due.
  • Loan payments. Principal and interest on every term loan, lease and line.
  • Capital purchases. Equipment, building projects, replacement heifers if you buy them.

Step 5: Calculate net cash and running balance

For each month, subtract total cash out from total cash in. Add that result to the prior month's ending balance. The new number is your running cash position. Wherever the ending balance dips below zero, you have found a month that needs the operating line or some other fix.

A good projection shows when that dip happens, how deep it goes and how long it lasts. That is what your lender wants to see, and it is what your operating line of credit should be sized to cover.

Step 6: Stress-test it

A projection that shows twelve good months in a row is wishful thinking with column headers.

Your first draft is a best guess. Now stress it. Run a second version with the milk price a few dollars per hundredweight lower. Run another with feed costs higher. Look at what happens to the low point in the balance. If a modest price drop pushes you into a hole you cannot get out of, you have found the risk, and now you can plan for it.

  1. Lower milk price by a realistic amount and see what changes.
  2. Raise feed cost by a similar amount.
  3. Delay one large cull or heifer sale by two months.
  4. Add an unplanned repair bill in a month with little cash.

The point is not to scare yourself. The point is to learn which numbers matter most. Most farmers find milk price and feed cost dominate, which points to tools like Dairy Margin Coverage and a careful look at feeding.

Common mistakes

  • Mixing up profit and cash. Depreciation lowers profit but does not take cash out of the bank. A loan principal payment takes cash out but does not show as an expense. A projection works on cash, so include both properly.
  • Forgetting family living. It comes out of the same account, whether the budget admits it or not.
  • Using the best month as the average month. The month the heifer sale went well is not a plan.
  • Setting it and forgetting it. A projection is only useful if you compare it against actual results each month and update it.
  • Leaving out the tax bill. Taxes arrive whether or not you budgeted for them. The year-round tax planning calendar shows when to expect them.

Keep it alive

Each month, enter what actually happened beside what you projected. The difference tells you where your estimates are off. After a year or two your projection gets a lot sharper, and the process takes less time. Pair it with a yearly farm budget and the two feed each other. For a deeper look at how farm business specialists approach this, University of Wisconsin Extension's dairy program is a decent place to find farm management resources.

Quick answers

How far ahead should a dairy cash flow projection go?

Twelve months is standard, and lenders usually expect it. Rolling it forward each month so you always see a year ahead works well for many farms.

What is the difference between a budget and a cash flow projection?

A budget estimates income and expenses for the year in total. A cash flow projection breaks it into months and tracks when the money actually moves, which shows timing problems a yearly budget hides.

Do I include depreciation in a cash flow projection?

No, because depreciation is not a cash payment. Include loan principal and interest, equipment purchases and other real cash outflows instead.

More from farm.FM Need a break from the paperwork? Farm humor and funny farm stories are always in season at farm.FM.