Foreqast
Get early access
Free templates · no sign-up

Excel templates for planning a business

Spreadsheets with the formulas already wired up — cash flow, margin, stock, projects and recurring revenue. Every one comes with a step-by-step guide, a worked example and an honest account of where it stops working.

All templates

16 templates

12-month cash-flow planEvery euro in and out, month by month, with the running balance already wired up.“cash flow plan template excel”
Excel/SheetsCSVRead the guide
13-week cash-flow planThe short-term view: thirteen weeks, week by week, granular enough to catch the week you run short.“13 week cash flow forecast template”
Excel/SheetsCSVRead the guide
Contribution margin per productWhat each product leaves behind once the costs that follow it are paid.“contribution margin template excel”
Excel/SheetsCSVRead the guide
Reorder point & stock coverHow many days of stock you have left, when to order, and what the order costs.“reorder quantity calculation excel”
Excel/SheetsCSVRead the guide
Budget vs actualPlan against reality, month by month, with the variance and the cumulative drift.“budget vs actual template excel”
Excel/SheetsCSVRead the guide
Profit & loss planRevenue down to net profit, month by month, in the order your accountant reads it.“profit and loss forecast template”
Excel/SheetsCSVRead the guide
Business plan financialsRevenue, costs, investment, funding and liquidity in one sheet — the annex a bank asks for.“financial plan template excel”
Excel/SheetsCSVRead the guide
Project costing & marginWhat you quoted, what it cost, and the hourly rate you actually got.“project costing template excel”
Excel/SheetsCSVRead the guide
Scenario planning — best / base / worstThree columns, one set of assumptions each, and the year that follows from them.“scenario analysis excel template”
Excel/SheetsCSVRead the guide
Capital requirement planInvestments, running costs and the revenue ramp — and how much funding the gap between them needs.“capital requirement plan template”
Excel/SheetsCSVRead the guide
Shop revenue forecastSessions × conversion × basket, down to the contribution margin and the ROAS you need.“revenue forecast excel template”
Excel/SheetsCSVRead the guide
Returns & shipping costsWhat a parcel out and a parcel back really cost you — per order, per month.“calculate shipping costs excel”
Excel/SheetsCSVRead the guide
Retainer vs project revenueHow much of your payroll the recurring revenue covers — and how much rides on the next pitch.“agency revenue planning excel”
Excel/SheetsCSVRead the guide
MRR & ARR trackerCustomers in, customers out, and where the recurring revenue actually moved.“mrr tracker excel”
Excel/SheetsCSVRead the guide
Churn & cohort analysisHow long a signup cohort stays, what it is worth, and when it has paid back its CAC.“cohort analysis excel template”
Excel/SheetsCSVRead the guide
Subscription revenue forecastMarketing spend in, customers out, and the MRR that survives your churn rate.“subscription revenue forecast excel”
Excel/SheetsCSVRead the guide

Looking for a quick answer instead?

The calculators do one number at a time, in the browser, with nothing to download.

All calculators

A spreadsheet is a snapshot. Foreqast keeps it current.

Every template on this page is a good start and a manual job forever after. Connect your accounting and shop data and the same numbers update themselves — day by day, twelve months out.

Get early access