Cash Flow Forecast Spreadsheet, 12 Month and 13 Week Runway Dashboard, Excel Google Sheets

Know your cash before you run out of it.

Most small businesses do not fail because they are unprofitable. They fail because they run out of cash without seeing it coming. This spreadsheet is the forward view that stops that happening: type in what you expect to earn and spend, and it shows you your cash position for the next twelve months, week by week for the next thirteen, and exactly which month gets tight.

WHAT'S INSIDE

12-Month Cash Flow Forecast
Income, costs, net cash flow and closing cash for every month of the year. Your cost of delivery calculates itself from a percentage you set once.

13-Week Rolling Cash Flow
The short-term view finance teams actually watch. Thirteen weeks is far enough ahead to fix a problem and near enough that the numbers are still real. It flags your lowest week and counts any week that goes below zero.

Profit & Loss and Margins
Gross and net profit, and both margins, calculated for you.

Cash Runway and Burn
How many months of cash the business has left at your current burn. If your plan generates cash it tells you that instead, rather than showing a meaningless number.

One-Screen KPI Dashboard
Every figure that matters in one place, updating as you type.

Setup, Instructions and Troubleshooting tabs
Beginner-friendly. Fill the yellow cells. Everything else calculates.

HOW IT WORKS
1) Open Setup and enter your business name, start month and opening cash.
2) Type your expected income and costs into the yellow cells.
3) Read your forecast, runway and KPIs straight away.

WHY THIS ONE
- Forward-looking, not a bookkeeping record of what already happened.
- The 13-week rolling view is the part cheaper templates leave out, and it is the part that catches problems early.
- Comes pre-filled with a worked example so you can see it working before you trust it. Delete it in one step.
- Works in Microsoft Excel and Google Sheets. No formulas to build.
- Clean and readable, not a wall of grey cells.

GOOGLE SHEETS
Upload to Google Drive and choose File > Save as Google Sheets. All formulas carry over.

INSTANT DOWNLOAD
Available immediately after purchase. Digital product - no physical item is shipped.

NOTE
This is a planning template, not financial, tax or accounting advice. Check tax rules for your own country. LaunchwardStudio is an independent creator and is not affiliated with, endorsed by or sponsored by Microsoft, Google or Etsy.