Cash Planning Model

13-Week Cash Flow & Runway Planner

This is the weekly liquidity file that should stay open when collections timing gets messy, supplier negotiations get real, or the board starts asking how much room is actually left. The job is not to predict perfectly. The job is to make cash movement explainable early enough to change behavior.

Weekly cadence Runway alerts Collections visibility Base / downside / stress

Back to Toolkit Download Workbook (.xlsx) Book a Fit Call

Structure

Weekly cash should be boring, repeatable, and brutally clear.

Section	Include	Do not bury
Inflows	Collections by customer group, tax refunds, debt drawdowns, other confirmed receipts	Expected billings that are not yet collectible
Outflows	Payroll, vendors, rent, taxes, debt service, capex, one-offs	Committed payments hidden inside generic overhead
Alerts	Minimum cash threshold, runway weeks, covenant proximity, funding gap	Soft commentary without a trigger number

Example Output

Sample weekly bridge.

Week	Opening cash	Inflows	Outflows	Closing cash	Signal
Wk 1	INR 6.40 Cr	INR 0.92 Cr	INR 1.30 Cr	INR 6.02 Cr	Normal
Wk 4	INR 5.46 Cr	INR 0.41 Cr	INR 1.12 Cr	INR 4.75 Cr	Collections watch
Wk 9 stress	INR 3.82 Cr	INR 0.33 Cr	INR 1.27 Cr	INR 2.88 Cr	Funding gap alert

Operating Cadence

How to keep the file decision-useful.

Update the file on the same weekday every week before management review.
Review top overdue receivables and top expected outflows every cycle.
Separate timing risk from true spend risk so leadership does not overreact to every dip.
Track base and downside in the same file; do not create parallel liquidity truths.
Escalate any week that crosses minimum cash or covenant comfort limits.

Key Logic

Weekly cash bridge Closing cash = Opening cash + Total inflows - Total outflows

Runway Runway weeks = Closing cash / Forward average weekly net burn

Collections slippage impact Slip impact = Delayed receipts this week - delayed receipts recovered next week

Warning Triggers

Closing cash below floor set by CFO / board
Two or more major collections shift in the same 2-week window
Debt service or payroll week covered only by optimistic receipts

When This Tool Shines

Use it when the business needs sharper cash ownership than a monthly report can provide, especially around payroll, debt, supplier timing, and fundraising readiness.

Adapt To Your Context

Cash planning works only when someone owns the movements.

Adapt the inflow and outflow lines to your operating reality, but keep collections and committed cash obligations visible at weekly level. If the file is clean and the team still cannot act on it, the problem is not the workbook anymore. It is cadence and ownership.

Back to Tool Pages Book a Fit Call