A pre-built spreadsheet that shows exactly when cash gets tight — before it becomes a crisis. AR aging, scenario planning, and runway all in one place.
Secure checkout via Stripe · Instant access · 7-day refund guarantee
Ships with realistic SaaS startup sample data so you see the format immediately. Replace the numbers — takes 15 minutes.
| Week | Starting Cash | MRR Inflows | AR Collections | Total Outflows | Net Cash | Ending Balance | Runway Signal |
|---|---|---|---|---|---|---|---|
| Wk 1 — May 12 | $847,500 | $62,000 | $18,400 | $(94,200) | =SUM(C2:D2)-E2 | $833,700 | ● 8.8 mo |
| Wk 2 — May 19 | $833,700 | $62,000 | $9,200 | $(88,500) | =SUM(C3:D3)-E3 | $816,400 | ● 8.6 mo |
| Wk 5 — Jun 9 | $779,100 | $62,000 | $4,100 | $(112,800) | =SUM(C6:D6)-E6 | $732,400 | ◐ 6.1 mo |
| Wk 9 — Jul 7 | $651,200 | $62,000 | $22,600 | $(98,400) | =SUM(C10:D10)-E10 | $637,400 | ◐ 5.3 mo |
| Wk 13 — Aug 4 | $512,800 | $62,000 | $6,800 | $(96,200) | =SUM(C14:D14)-E14 | $485,400 | ▼ 4.1 mo |
Sample data — Acme SaaS Startup. Replace with your numbers in 15 minutes.
Week-by-week visibility flags trouble 6–8 weeks before it hits. You stop firefighting and start managing.
Base, Downside (−20%), and Upside (+20%) tabs recalculate automatically. Walk into any board meeting prepared.
0–30, 31–60, 61–90, and 90+ day buckets with collection probability assumptions. Know which receivables will actually land.
Green (>6 mo), yellow (3–6 mo), red (<3 mo). Conditional formatting you don't have to build. Formula cells are locked so you can't accidentally break it.
Click each tab to see what's on it.
13 rows (one per week) showing starting cash, inflows by category (MRR, AR collections, one-time), outflows by category (payroll, SaaS tools, rent, COGS), net cash, and ending balance.
Exact copy of Base Case with revenue inflows reduced by 20%. Recalculates automatically when you update Base Case assumptions.
Same structure with revenue inflows increased by 20%. Shows your best-case runway and cash position if growth accelerates.
Breaks outstanding receivables into buckets — 0–30, 31–60, 61–90, and 90+ days — with collection probability assumptions you can tune.
Auto-calculates months of runway at current burn rate. Adjustable assumptions for burn change and new ARR.
Step-by-step: replace sample data with yours. No finance degree required. Built for founders who need it done this week, not next quarter.
Instant access to Google Sheets. No account required. 7-day refund guarantee.
Secure checkout · Powered by Stripe · Instant Google Sheets link