Blog
Why a Trend Line Is Not a Cash Flow Forecast
A straight line through last year misses the timing that drains cash. How to forecast with drivers, read a 12-month forecast, and act when it turns negative.
By Matthew Dettman, ChFC, CLU, founder of Second Difference Solutions. Updated .
Short answer: A trend line assumes next year repeats last year's pattern, but cash moves on drivers: how fast revenue grows, how much of each sale you keep as gross margin, how long customers take to pay, how long you take to pay suppliers, and what your fixed costs are. A driver-based forecast sets those five inputs directly, so it shows when cash will run low and which lever fixes it. A trend line can only show where the line goes.
Most small business owners who forecast at all do it the same way. They look at last year's bank balance or net income, see which direction it has been heading, and extend the line. If cash rose about $4,000 a month last year, the forecast says it will rise about $4,000 a month this year.
That method is quick, and it is usually wrong in the ways that matter. It cannot see the customer who just moved to 60-day terms, the hire you plan for March, or the supplier who now wants to be paid faster. Those changes drain a bank account while the P&L still looks healthy, the gap we cover in why profitable businesses run out of cash.
Below: forecasting from drivers, reading the result month by month, and what to do when the line dips below zero.
Why a Trend Line Misleads
A trend line treats your business as one number moving in one direction. Cash responds to decisions and to timing, and a trend line has no place to record either. Three blind spots show up again and again:
- It averages away the low point. A seasonal business can show a rising annual trend and still have two months where cash nearly runs out.
- It ignores working capital. When sales grow, receivables and inventory grow with them. Growth uses cash before it produces cash.
- It cannot answer "what if." If a large customer starts paying 15 days later, a trend line has no input to change. You can only redraw it by hand.
The Five Drivers That Move Cash
A driver-based forecast starts from a short list of assumptions. Each one is something you can observe in your books and influence in your business.
1. Revenue growth
Start with a growth rate for the year or, if your sales are seasonal, an estimate for each month. Be honest about the base: last year's revenue, adjusted for what you know has changed, such as a lost contract, a price increase or a new location.
2. Gross margin
Gross margin is the share of each sales dollar left after the direct cost of delivering it. At a 40% margin, $100,000 of monthly revenue leaves $40,000 to cover everything else. A two-point margin slip on that revenue is $2,000 a month that never reaches the bank, and the loss grows as sales grow.
3. Collection days
Collection days (also called days sales outstanding, or DSO) measure how long customers take to pay. Picture a company selling $100,000 a month. At 30 days, it carries roughly $99,000 in receivables. If customers slip to 45 days, receivables rise to about $148,000. Revenue and profit have not changed, but about $49,000 of cash now sits with customers instead of in your account. Our post on the financial KPIs every small business should track shows how to calculate DSO from your own statements.
4. Payables days
Payables days work the other way: they measure how long you take to pay suppliers. If that same company buys $60,000 a month in materials and its main supplier shortens terms from 35 days to 20, accounts payable falls by roughly $30,000. That is $30,000 of cash leaving earlier than it used to, with no change in what you buy.
5. Fixed costs
Rent, salaries, insurance, software and loan payments arrive whether sales come in or not. Model them as dollar amounts with their own growth rate, not as a percentage of revenue. That keeps the forecast honest when sales dip, because these costs do not shrink when revenue does. It also shows the true weight of a commitment: a new hire at $5,500 a month needs about $165,000 of extra annual revenue at a 40% margin just to cover that salary.
Add debt payments, planned equipment purchases and tax payments as known amounts in the months they fall, and the forecast responds to the decisions you actually make.
How to Read a 12-Month Forecast
A 12-month forecast is a table of months, each with cash coming in, cash going out and an ending balance. Five habits make it useful:
- Find the low point first. The balance in month twelve matters less than the lowest balance along the way. Note which month it falls in and how deep it goes.
- Compare it with a floor. Decide the smallest cash balance you are comfortable holding; one month of fixed costs is a simple starting point. A forecast that stays positive but dips below that floor is still a warning.
- Keep actuals and forecast separate. Each month, replace the forecast month with what actually happened and note the gap. After a few months you will know which driver you tend to get wrong, and that is the one to watch.
- Test the sensitive drivers. Change collection days by ten, or margin by two points, and see how far the low point moves. The driver that moves it most is where your attention belongs.
- Mark the lumpy months. Quarterly estimated taxes, annual insurance premiums and loan balloon payments are easy to forget and easy to forecast. Put each one in the month it is due.
For the near term, a 12-month view pairs well with a weekly one. Our guide to building a 13-week cash flow forecast covers the week by week method for the next quarter.
What to Do When the Forecast Turns Negative
A forecast that shows cash going negative is not bad news. It is early news, and early news gives you options. Work through it in order.
Check the assumptions. Before you act, confirm the dip is real. A typo in a fixed cost or a growth rate set too high can create a shortfall that does not exist.
Size the gap and the timing. Two numbers matter: the deepest shortfall, which sets the size of the fix, and the first month it appears, which sets how much time you have.
Pull the working capital levers first. These free up cash without changing your profit:
- Invoice promptly, follow up on overdue accounts, and consider deposits or progress billing on large jobs.
- Ask key suppliers for longer terms before you need them. Paying late without an agreement damages relationships and credit.
- Reduce inventory that is not moving.
Then look at the timing of spending. Defer discretionary purchases, push a planned hire back a quarter, or lease equipment instead of buying it outright.
Revisit price and margin. If the forecast is negative in every scenario you try, the problem may be structural rather than timing, and a price or cost change on your lowest-margin work can matter more than any timing fix.
Arrange financing early. A line of credit is easier to obtain before you need it, and a forecast that shows the gap and your plan to close it makes a stronger case to a lender. Talk with your accountant or banker before the month arrives, not during it.
How 2diff Business Builds a Driver-Based Forecast
2diff Business connects to your QuickBooks® Online account and uses your most recent year of actual results as the base for its forecast. On the Forecast tab, the Drivers method builds the projection from the inputs described above: revenue growth, cost of goods sold as a percent of revenue, operating expenses as a dollar figure with their own growth rate, and receivable, inventory and payable days. Any box you leave blank uses your base year, so you only change what you expect to change.
Cash is the balancing figure. When the projection would push cash below the minimum you set, the shortfall appears as Needed Financing, with the peak amount and the first year you need it. The app never borrows on its own; you decide how to close the gap. Switch Frequency to Quarterly or Monthly and the tables break the projection out period by period; the Trajectory chart above them stays annual, with your actual history drawn as a solid line and the forecast as a dashed continuation. 2diff Business only reads your accounting data and never writes to your books.
Without QuickBooks Online, 2diff Business also works from a few annual figures you type in, which gives an annual view rather than a monthly one. You can try the demo with sample data without connecting any accounts, or compare plans on the pricing page.
Related Reading
- Cash Flow Forecasting for Small Business: A Plain Guide: The intro: what a forecast is, the common mistakes, and a 13-week starter method
- Why Profitable Businesses Run Out of Cash: Why profit and cash move on different timelines
- 5 Financial KPIs Every Small Business Should Track: Including days sales outstanding and operating cash flow
- 5 Financial Numbers Every Small Business Owner Should Review Monthly: A monthly routine that pairs well with a rolling forecast
- How to Build a 13-Week Cash Flow Forecast: The week by week method for the next quarter
- How to Set Business Goals and Hold Your Plan Accountable: Set goals beside the forecast and check both against actuals each month
This content is for educational purposes only and does not constitute financial, tax, accounting, or legal advice. Consult with a qualified professional for advice specific to your situation.