Cash flow surprises kill profitable businesses. A 12-week rolling cash flow model gives you 90 days of early warning—enough time to act before a crisis hits. This guide walks you through the model structure, the inputs that matter most, and a ready-to-use weekly template framework.
Why 12 Weeks?
Monthly P&L reports tell you what happened. A 12-week rolling cash flow model tells you what is about to happen—with enough lead time to adjust. The QBE Singapore SME Survey (2025) found that cash flow stress was the #1 operational concern among SMEs, ahead of rising costs. Most of that stress is preventable—it stems from poor visibility, not poor performance.
12 weeks (90 days) is the operational sweet spot: long enough to see inventory purchase cycles, payroll commitments, and receivables timing; short enough to forecast with reasonable accuracy; and perfectly aligned with a typical Singapore SME’s trade credit and supplier payment terms.
The Model Architecture
Your 12-week model has three layers:
Layer 1: Opening Cash Balance
Start with your actual bank balance as of today. Not accounting cash—real money in your operating account(s).
Layer 2: Cash Inflows (Weekly)
- Collected revenue — the week of actual cash receipt, not invoice date. Segment by payment method: credit terms (30/60/90 days), upfront, COD, subscription auto-debit.
- Other inflows — grant disbursements (note: ESG grants are reimbursement-based), loan drawdowns, asset sales, security deposits returned.
Layer 3: Cash Outflows (Weekly)
- Fixed outflows: payroll, rent, loan repayments, subscriptions, insurance
- Variable outflows: inventory purchases, supplier payments, logistics, marketing, sales commissions
- Irregular outflows (schedule explicitly): GST payments (quarterly in Singapore), corporate tax instalments, annual renewals, equipment maintenance
The Five Inputs That Move the Needle Most
1. Accounts Receivable (AR) Timing
The biggest cash flow lever most businesses ignore. If you invoice SGD $100K in Week 1 on 60-day terms, that cash does not appear until Week 9. Map your AR aging weekly: 0–30 days, 31–60 days, 61–90 days, 90+ days (flag for collection).
Quick win: Tighten payment terms from net 60 to net 30 for your top 5 customers. If they push back, offer a 1–2% early payment discount—cheaper than a credit line.
2. Accounts Payable (AP) Timing
You control when you pay suppliers (within terms). Stretching AP from net 30 to net 45 on $200K monthly supplier spend buys you $33K of additional float—essentially free working capital. Do this deliberately, not accidentally.
3. Inventory Purchase Planning
For product businesses, inventory is often the single largest cash outflow. Link your inventory purchase schedule to your 12-week model: when do POs need to be placed, when does payment clear, and when do you collect revenue from sales? This reveals your cash valley—the weeks between paying for inventory and collecting revenue. Knowing this in advance lets you arrange bridging credit before you need it.
4. Burn Rate Tracking
For pre-profitability businesses: net weekly burn = total outflows − total inflows. Your forward runway is calculated as:
Weeks of runway = Opening cash balance ÷ average weekly net burn
If runway drops below 12 weeks, that is your trigger to act: fundraise, cut costs, accelerate collections, or draw on your credit facility.
5. Scenario Columns
Never run a single forecast. Build three columns for each week: base case (most likely), downside (20% revenue miss), and stress case (40% revenue miss). The stress case is your covenant test—if you can survive it, you are properly capitalised.
12-Week Model Template
| Wk 1 | Wk 2 | Wk 3 | … | Wk 12 | Total | |
|---|---|---|---|---|---|---|
| Opening Balance | ||||||
| Customer collections (AR) | ||||||
| New sales (upfront/COD) | ||||||
| Total Inflows | ||||||
| Payroll | ||||||
| Rent & utilities | ||||||
| Inventory purchases | ||||||
| Marketing & sales | ||||||
| Loan repayments | ||||||
| GST/tax | ||||||
| Total Outflows | ||||||
| Net Cash Flow | ||||||
| Closing Balance | ||||||
| Minimum Safe Balance | SGD X | SGD X | SGD X | SGD X | ||
| Surplus / (Deficit) |
Minimum safe balance tip: Set your floor at 4 weeks of fixed operating costs. This is your non-negotiable buffer.
Three Warning Signals to Monitor Weekly
- Closing balance falls below your minimum safe floor. Investigate the cause immediately—collection delay, large outflow, or structural cash shortfall?
- AR aging worsens week-over-week. More receivables slipping to 61–90 days is an early revenue quality signal. Chase before the 60-day mark.
- Inventory purchase cycle misaligned with revenue timing. Buying inventory 8 weeks before you collect cash, but your credit line only covers 4 weeks, is a structural gap—fix it with supplier terms negotiation or trade financing.
Recommended Tools
- Google Sheets or Excel: Best for full flexibility and formula control. Start here.
- Float: Integrates with Xero/QuickBooks and auto-populates AR/AP. SGD ~$80–$150/month.
- Fathom or Futrli: Advanced FP&A tools for scenario modelling. Suited for SGD $2M+ revenue businesses.
Recommendation for most Singapore SMEs: Start in Google Sheets, manually update weekly (30 minutes per week), then graduate to Float once you have clean accounting data.
Your Action Plan
- This week: Pull your last 8 weeks of actual bank statements and categorise every inflow and outflow.
- Next week: Build your base case 12-week model using the template above.
- Week 3: Add your downside and stress scenarios.
- Ongoing: Update every Monday morning, 30 minutes, non-negotiable.
