Small Business Financial Article
Rich Best has spent 28 years in the financial services industry, as an advisor, a managing partner, directors of training and marketing, and now as a consultant to the industry. Rich has written extensively on a broad range of personal finance topics and is published on several top financial sites. Recent books include The American Family Survival Bible and Annuity Facts Revealed: What You MUST Know Before You Invest.

Cash-Flow Forecasting & Management

Cash-Flow Forecasting & Management

How to Predict Cash Crunches 3-6 Months in Advance and Keep Your Business Alive During Rapid Growth

Rapid growth is every small business owner’s dream-until the day their bank account hits zero while revenue is at an all-time high. The paradox is all too common: sales booming, receivables swelling, payroll due, suppliers paying COD, and suddenly you can’t cover rent. The cause? Poor cash-flow visibility. The solution? Careful, proactive cash-flow forecasting and disciplined management.

Why Most Forecasts Fail During Growth

Traditional P&L projections show if the business is profitable on paper, but they don’t tell you if you’ll run out of money next Thursday. Growth magnifies every cash delay.

  • Customers stretch from 30 to 60 or 90 day terms
  • Inventory must be bought 60-120 days before it turns into cash
  • New hires are paid today for work that generates revenue months from now
  • Landlords and cloud providers still want money up front

A company growing 100% year over year can be both highly profitable and technically insolvent at the same time.

The 13-Week + 6-Month Rolling Forecast Framework

The most battle-tested method used by CFOs of high-growth companies worldwide is the combination of a detailed 13-week cash flow forecast and a broader 6-12-month rolling model.

1. Build the 13-Week Direct Cash-Flow Model (Weekly Granularity)

Forget the indirect method you learned in accounting class. Build a direct cash model that answers one question: “How much cash will be in the bank every Friday for the next 13 weeks?”

Key rows for Cash Inflows

  • Cash sales & credit-card receipts this week (by day if possible)
  • Collections from Accounts Receivable: take your AR aging report, apply historical collection % by bucket (0-30, 31-60, 61-90, 90+), and map exact expected deposit dates
  • Confirmed investor tranches, credit-line draws, grants, tax credits, refunds-only include if signed and dated
  • One-time inflows (asset sales, insurance claims, etc.)

Key rows for Cash Outflows

  • Payroll + employer taxes + 401k withholding (use exact pay dates)
  • Rent, utilities, insurance premiums
  • All vendor payments: pull open AP, match to PO terms, and list exact due dates
  • Debt service, credit-card payments, lease payments
  • Capex (tag every server purchase, office build-out, or tooling with the exact check/EFT date)
  • Owner draws, distributions, or tax payments

Update this model every single Monday morning after the weekend bank feed posts. The ritual takes 20-40 minutes once it’s built. The output is a single line that shows your lowest cash balance over the next 13 weeks. If that number ever goes below your safety buffer (usually 8-12 weeks of burn), you act immediately.

The 6-12 Month Forecast

The 13-week forecast is your tactical (“don’t bounce a check next month”) tool. The 6-12 month forecast is your strategic (“don’t go out of business in Q3”) tool.

Think of it as a simple spreadsheet that answers one question: “If we actually do everything we say we’re going to do, when will we run out of money (or need to raise more)?”

You update this more extended forecast every month (not just once a year like an old-school budget).

Instead of guessing random numbers like “marketing expense = $200k in June,” you connect the forecast to the real things that drive your business. Here’s what that looks like in plain English:

  1. Sales → Cash (with all the delays built in) You put in your sales pipeline or target. The model automatically adds the normal delays you always see:
    • Deal gets signed → counts as “booked.”
    • Revenue might be recognized over 12 months (common in SaaS)
    • You send the invoice 5-15 days after signing
    • Customer actually pays you 45-70 days after the invoice (this is called DSO - days sales outstanding) → So a deal you close tomorrow might not turn into cash for 3-4 months.
  2. Subscriptions or recurring revenue: If you sell annual contracts paid upfront, there is a big cash spike when the deal closes. If you sell monthly plans, cash trickles in slowly each month. The model shows you exactly which type you’re selling and when the cash will hit the bank.
  3. People you plan to hire: You paste in your hiring plan (or export it from BambooHR, Rippling, etc.). The model instantly calculates:\\
    • Salary + taxes + health insurance + laptop + recruiting fees
    • And it knows you pay people today, even though the new salesperson won’t close their first deal for 4-6 months.
  4. Marketing and sales spending: You put in how much you plan to spend on ads, events, Salesforce licenses, etc. The model shows how long it takes to get that money back from the customers you acquire (this is called CAC payback period). If payback jumps from 6 months to 14 months, you’ll see the cash drain immediately.
  5. Inventory or cost of goods (if you sell physical products): You have to buy or build products 60-120 days before you sell them and get paid. The model shows that cash going out the door months before it comes back.

Real-life example - why this saves companies:

The sales leader walks in and says: “Great news! We’re going to 4x revenue this year!” Everyone cheers.

You open the 6-12-month model. Thirty seconds later, you say: “Cool. That plan also creates an $18 million cash hole between May and August because customers pay us slowly and we have to hire and buy inventory upfront.”

Now you can fix it while you still have time - maybe raise money, slow hiring, get annual prepayments, speed up collections, etc. Without this model, you only discover the $18 million hole when you literally have two weeks of cash left. Game over.

In short, the 6-12-month model turns your growth plan into a cash plan. It shows you the happy path (“we hit our numbers”) and exactly how much cash you’ll burn (or need) along the way-months before it happens.

Five Early-Warning Signals of an Impending Crunch

Catch these 3-6 months early, and you survive. Miss them, and you die.

  1. Days Sales Outstanding (DSO) creeping 10+ days above your historical average
  2. Accounts Payable aging stretching >15 days beyond agreed terms (you’re now financing growth with suppliers-who will eventually revolt)
  3. Cash conversion cycle flipping from negative to positive (you now need cash to fund every new $1 of revenue)
  4. Forecasted cash low point dropping below your 2-3-month operating buffer
  5. Revenue growth is dramatically outpacing gross profit growth (you’re adding volume at near-zero or negative margin)

Practical Levers to Pull When a Crunch Appears 3-6 Months Out

You now have time-your most valuable asset in a cash crisis. Use it:

  • Renegotiate supplier terms from net-30 to net-60 or move high-volume items to consignment
  • Offer 1-2 % early-payment discounts (costs less than a credit line and accelerates cash dramatically)
  • Require 20-50% deposits on orders >$50K or switch large deals to annual upfront payments
  • Pause non-revenue-generating hires; move to contractors or offshore where possible
  • Draw down your existing revolver or credit line early (banks love lending to growing, healthy companies; they freeze when you’re bleeding)

Tools & Cadence That Actually Work in the Real World

  • <$10M ARR: Use Excel/Google Sheets + Tiller or Float (cheap and sufficient)
  • $10M-100M ARR: Use Dryrun, Runway, Pry, Jirav, or Mosaic
  • $100M ARR: Use Anaplan, Pigment, or Cube with live bank/ERP integrations
  • Cadence: 30-minute 13-week cash review every Monday with CEO, CFO/controller, and head of sales ops; full 6-12-month re-forecast the first week of every month tied to board package

The Bottom Line

Profit is opinion, but cash is fact. Companies die from cash shortages, not a lack of profit. A disciplined 13-week + 6-12-month rolling cash forecast gives you the only superpower that matters in rapid growth: time-3 to 6 months-to fix a problem before it becomes fatal.

Build the model this week. Run the Monday meeting. Your future self, your team, your investors, and your family will thank you.