Cashflow Forecast 13 Week 2025

Tab 1 — 13-Week Cash Flow (main working sheet)

• Auto-generating week headers with dates (set once in cell H4, all 13 weeks update)

• Opening cash balance in Week 1 (user input) → Weeks 2–13 auto-link to prior week’s ending balance

• Cash Inflows — 11 line items: sales, invoice collections, recurring revenue, retainers, digital sales, deposits, tax refunds, loan proceeds, owner contributions, asset sales

• Cash Outflows — 20+ line items across 5 groups: Payroll, Vendors/Suppliers, Fixed Expenses, Variable Expenses, Tax Payments, Capital/Owner Draws

• Net Cash Flow — auto-calculated per week

• Ending Cash Balance — auto-cascades week to week

• Liquidity Alert panel — set your minimum reserve once, alerts fire automatically with ⚠ flags any week cash drops below it

• Cash Runway — shows weeks of runway remaining at current burn rate per week

• 13-Week Summary Metrics — 10 KPIs including avg weekly inflow/outflow, weeks positive, weeks below reserve

Tab 2 — Actuals vs Forecast

• Enter what actually happened each week (blue cells)

• Forecast numbers pull automatically from Tab 1

• Variance calculated automatically — shows you where your forecast was off

Tab 3 — Scenario Planner

• Model Base Case, Best Case, and Worst Case with simple assumption inputs

• Projected 13-week outcomes calculate instantly for all three scenarios side by side

Tab 4 — Instructions & Guide

• Step-by-step setup, key concept explanations, 2025 tax due dates, best practices, disclaimer