Cash Flow Prediction: See the Gap 3 Months Before It Hits

Cash Flow Prediction: The Early-Warning System That Sees the Gap 90 Days Out

Your bank balance only tells you what you have today—never what you’ll be short three months from now. Cash flow prediction is an early-warning system: one asset-ratio formula turns your sales plan into the cash your receivables and inventory will lock up, so the gap shows itself 90 days before it hits. Refresh it every month-end and it rolls forward, surfacing trouble while there’s still time to arrange money calmly.

You may know this picture: 1:30am on the 28th, Maybank2u showing RM231,500, RM120K of payroll due on the 1st, RM180K of supplier POs on the 5th, and two customers who “should” pay somewhere in between… should. Placing that bet every month isn’t a discipline problem—it’s a tool problem. Here’s the early-warning system that retires it.

”Good Business Means Enough Cash”—The Lie That Sinks Owners

Most owners believe it: win more orders, grow the business, and the cash will take care of itself.

It’s exactly the opposite. The better business gets, the tighter cash gets. That’s not you failing to run the company—it’s how the mechanics of business actually work.

Walk through a big order. First you spend cash to buy stock—inventory up, cash down. You deliver, and the customer pays in 60 days—receivables up, cash still hasn’t come back. On the P&L you’re profitable, the report looks beautiful, but your bank account is leaner than last month.

So cash flow was never about “are you making money.” It’s about when money comes back and when it has to go out. That timing gap is the thing torturing you at 1am on the 28th.

The good news: that gap can be calculated in advance.

The Prediction Method: One Formula, 90 Days of Warning

The logic is simple. If cash is being eaten by assets (inventory + receivables), then if you can predict how much those assets will grow, you’ve predicted how much cash will disappear.

And how much assets grow follows sales. Your receivables and inventory hold a fairly stable ratio to revenue—as long as your customers’ payment terms don’t change and your stocking habits don’t change, that ratio doesn’t jump around. Pin it down, and you can see the future.

There’s only one core formula:

Projected Asset Amount = (Asset Amount ÷ Revenue) × Projected Revenue

Three steps to run it:

Step 1: Calculate Your Asset Ratios

Pull out your decision accounts (the internal numbers you run the business on—not the tax-reporting set). You only need three figures. Say Chen runs a packaging-materials business doing RM7.2M a year:

Monthly Revenue:  RM600K
Receivables:      RM900K   →  Receivables ratio = 900 ÷ 600 = 1.5
Inventory:        RM600K   →  Inventory ratio   = 600 ÷ 600 = 1.0

In plain terms: for every RM1 of business he does, RM1.50 sits in his customers’ hands and RM1.00 sits in the warehouse.

Step 2: Apply the Next 3 Months’ Sales Plan

In March, Chen lands a new retail-chain customer and his sales plan jumps from RM600K to RM800K. Apply the formula:

Projected Receivables = 1.5 × RM800K = RM1.2M   (RM300K more than now)
Projected Inventory   = 1.0 × RM800K = RM800K   (RM200K more than now)

New cash locked up = RM300K + RM200K = RM500K

Step 3: Project Month-End Cash and Flag the Gap in Red

Projected Month-End Cash = Opening Cash + Expected Collections − Expected Payments − New Cash Locked in Assets

In March, Chen does RM200K more business. At a 10% net margin, that’s RM80K of profit on paper—but RM500K of extra cash gets locked away. Net it out, and his account ends up roughly RM420K lighter than today. If he’s only holding RM230K right now, March is the month it blows up.

Here’s the difference that changes everything: it’s only January. He’s seen the hole more than two months out, so he can arrange things calmly—negotiate a credit line with the bank (banks love lending to people who look like they don’t need it), ask the new customer for a 30% deposit, push suppliers for longer terms, or simply stagger the delivery schedule on that order.

Every month-end, drop the oldest month, add a new one, and recalculate. That’s a rolling 3-month forecast. You stay 90 days ahead of every crisis.

Side note: to find out what your own ratios come to—and which month dips below the safety line—start with the free AI profit diagnosis — a real consultant, 30-45 minutes, no hard selling.

6 Things You Can Do This Week

How do you set the safety line? Bare minimum: next month’s payroll + fixed overheads. To sleep properly, hold 1.5 months of fixed overheads.

Want to expand this three-month projection into a full 12-month sheet? The hands-on tutorial is here: how to build a cash flow forecast, step by step.

Two warnings. First, if your receivables ratio comes out above 2.0, or your inventory ratio keeps climbing, that’s no longer a forecasting problem—too much cash is stuck. Fix that first with working capital optimization and dig the locked cash back out. Second, if you’ve already started stretching suppliers or covering the company with personal savings, read this first: 5 Signs Your Cash Flow is About to Break.

FAQ

What is a rolling 3-month cash flow forecast?

A rolling 3-month cash flow forecast is a cash projection that you update every month and that always looks 3 months ahead. You calculate the ratio of receivables and inventory to revenue (Asset ÷ Revenue), multiply those ratios by your sales plan for the next 3 months to project how much assets will grow, and since asset growth locks up cash, you derive the month-end cash balance for each month. You refresh it at every month-end, so a cash gap becomes visible up to 90 days early.

Why does cash get tighter when business gets better?

Because assets up means cash down. When revenue grows, inventory and receivables grow in proportion—you spend cash to buy stock, but customers don’t pay for 30 to 60 days. For example, if monthly revenue rises from RM600K to RM800K, at a receivables ratio of 1.5 and inventory ratio of 1.0, around RM500K of cash gets locked into new assets—far more than the roughly RM80K of profit booked that month. This is the mechanics of business, not poor management.

Can an owner build this forecast without a CFO?

Yes. You only need three numbers: monthly revenue, total receivables, and total inventory—one Excel sheet does it. The key isn’t the tool, it’s the discipline: update it once a month, compare last month’s forecast against actuals and ask why they differ (that’s profit-leak detection), and the ratios get sharper over time. For companies above RM5M in annual revenue, the owner should read this sheet personally rather than hand it entirely to the accounts team.

Get the Numbers Right, and You’re Half-Won

Cash flow prediction is just the start of the “Calculate Right” step. In the Budget Management (3+1)-Day Program, we use your own company’s figures to build the next 12 months’ profit plan, breakeven red line, and cash projection in one sitting. Or, book a strategy call and let us work through the numbers with you.

Explore the Budget Management (3+1)-Day Program

Book a Strategy Call