PE firms running portfolio companies have one tool they trust above almost any other: the 13-week cash flow forecast. It's not glamorous, it doesn't require expensive software, and it's the single most powerful instrument for surviving the next quarter. Most founders don't have one — and many learn the hard way why they should.

This is the founder's version of the 13-week cash flow model. Built in a spreadsheet, updated weekly, owned by the founder until you have a CFO. It will change how you make decisions.

Why 13 Weeks?

Three months is short enough that you can predict events with reasonable accuracy. It's long enough that you can see consequences before they hit. And weekly granularity is the right resolution: monthly hides cliffs, daily creates noise.

For most growth-stage businesses, the difference between "we have 18 months of runway" and "we have 18 months of runway but we'll be cash-negative in week 9 if vendor X delays payment" is the difference between sleeping and not sleeping. Monthly forecasts hide that. Weekly ones surface it.

The Structure

One spreadsheet. 13 columns (one per week). Rows organised in three sections:

Section 1: Cash Inflows

  • Customer revenue (broken by segment if useful)
  • Receivables collection (B2B businesses with credit terms)
  • Other inflows (refunds-in, deposits, etc.)
  • Subtotal: Total inflows

Section 2: Cash Outflows

  • Salaries (split fixed and variable)
  • Vendor payables (split by category — marketing, fulfilment, tech, professional fees)
  • Tax outflows (GST, TDS, advance tax)
  • Rent and recurring overheads
  • One-off planned spends (inventory pre-buys, capex, marketing pushes)
  • Subtotal: Total outflows

Section 3: Net + Position

  • Net cash flow this week (inflows − outflows)
  • Opening cash balance
  • Closing cash balance

The closing balance row is the one that matters. It tells you, week by week, exactly how much money you'll have. If any week is negative, you have an action item. If the trend line is heading down, you have a strategic problem.

Most founders run their business on what's in the bank account today. The 13-week shows you what'll be in the bank account 90 days from today, given everything you currently know.

Building It in Excel or Sheets

Don't buy software for this. A simple sheet does it better than any tool because you can model what you actually need.

Practical tips:

  • Lock the structure for a quarter. Don't redesign columns mid-quarter; you lose the trend.
  • Build assumptions into a separate tab. Salary growth, AR collection days, CPM trends — keep them visible.
  • Show actuals + forecast on the same row. First few weeks are actuals (locked), rest are forecast. As weeks pass, actuals replace forecasts.
  • Two scenarios: Base and Conservative. Base is what you expect. Conservative is "what if revenue lands 30% lower." If conservative is still survivable, you're fine.

Updating It Weekly

Every Monday, 30 minutes:

  1. Plug in last week's actuals.
  2. Update the next 12 weeks' forecasts based on what changed (closed deals, missed deadlines, vendor delays).
  3. Read the closing-balance row. Are any weeks negative or trending negative?
  4. If yes — what action triggers? Slow a payable, accelerate a receivable, defer a hire.

Reading It for Runway Decisions

The 13-week is the right tool for the next 90 days. For runway decisions (12+ months), you still need a longer-horizon model. But the 13-week shows you something the longer model can't: what could go wrong before runway becomes the problem.

Three patterns to watch:

  • Receivables pile-up. Revenue rising on the P&L but cash not arriving. Common in B2B businesses with extending payment terms.
  • Marketing burn drift. Spend creeping up week-on-week without a corresponding revenue lift. Classic CAC degradation.
  • Vendor lumpiness. Big payments concentrating in certain weeks while inflows are smooth. Liquidity risk even when overall cash is fine.

Why this discipline pays for itself

The 13-week takes 30 minutes a week to maintain. It will, over the course of any year, identify at least one cash event you would otherwise have missed. The cost of being surprised by cash is always higher than the cost of being prepared.

The Honest Caveat

This isn't a substitute for a real finance function. As you scale past ₹10 Cr ARR, you need accrual-basis accounting, proper FP&A, and a CFO or controller who manages the full system. The 13-week is the founder's bridge tool — it works for the period when you can't afford that infrastructure but can't afford to fly blind either.

Working through this and want hands-on help? Explore our Financial advisory services — we offer retained partnerships, project sprints, and 30-day audits.