Free financial model templates

Budget & Forecast Templates

Pre-built financial models with formulas, structure, and formatting built in. Download any template for free -- no account required.

fx=SUM(Revenue[Q1:Q4]) - SUM(OpEx[Q1:Q4])
Account
Q1
Q2
Total
Revenue
385k
412k
797k
COGS
(148k)
(159k)
(307k)
Gross Profit
237k
253k
490k
OpEx
(99k)
(105k)
(204k)
EBITDA
138k
148k
286k

Annual Operating Budget

Full-year operating budget with revenue, COGS, and departmental OpEx. Pre-built formulas for gross margin, EBITDA, and net income.

fx=Opening + Inflows - Outflows
Item
Wk 1
Wk 2
Wk 3
Opening
120k
95k
108k
Inflows
45k
62k
38k
Outflows
(70k)
(49k)
(55k)
Closing
95k
108k
91k

13-Week Cash Flow Forecast

Weekly cash flow projection for the next quarter. Tracks receivables, payables, payroll, and discretionary spend.

fx=Salary * (1 + ER_NI + Benefits%)
Role
FTE
Salary
Loaded
Engineers
12
780k
1.02M
Sales
6
390k
510k
Finance
3
195k
255k
Total
21
1.37M
1.79M

Workforce Planning Model

Position-level headcount plan with fully loaded cost calculations. Includes salary, employer taxes, benefits, and equipment.

fx=Customers * ARPU * (1 - Churn)
Driver
Q1
Q2
Q3
Customers
180
210
245
ARPU
Β£520
Β£535
Β£550
Churn
3.2%
2.8%
2.5%
Revenue
94k
112k
135k

Revenue Forecast

Driver-based revenue model with assumptions for new customers, expansion, churn, and pricing changes.

fx=SUMIF(Dept, "Sales", Amount)
Category
Budget
Actual
Var
Salaries
95k
92k
+3k
Software
12k
14k
-2k
Travel
8k
6k
+2k
Total
115k
112k
+3k

Department Budget Pack

Standardised budget template for department heads. Pre-populated with common expense categories that roll up to the master budget.

fx=Actual / Budget - 1
KPI
Actual
Budget
Var %
Revenue
797k
780k
+2.2%
EBITDA
286k
270k
+5.9%
Cash
450k
420k
+7.1%
Headcount
58
55
+5.5%

Board Reporting Pack

Executive summary dashboard with P&L, BvA analysis, cash flow, and key metrics. One-click export to PDF.

All templates

Browse the full library

24 free templates across budgeting, forecasting, and reporting β€” each with step-by-step guides and best practices.

Budgeting

Free

Annual Operating Budget Template

Download a free annual operating budget template with pre-built P&L formulas, departmental roll-ups, and quarterly phasing. Excel-compatible.

Free

Departmental Budget Template

Free departmental budget template for department heads. Pre-populated expense categories, budget vs actual tracking, and automatic roll-up to the master budget.

Free

Zero-Based Budget Template

Free zero-based budgeting template. Build every line item from scratch with justification fields, priority ranking, and approval tracking.

Free

Project Budget Template

Free project budget template with phase-based cost tracking, resource allocation, and earned value analysis. Track spend against milestones.

Free

Capital Expenditure Budget Template

Free capital expenditure budget template with asset register, depreciation schedules, and ROI analysis. Track CapEx against approved limits.

Free

Marketing Budget Template

Free marketing budget template with channel-level spend tracking, CAC calculations, and campaign ROI analysis. Plan paid, organic, and events.

Free

IT Budget Template

Free IT budget template covering infrastructure, SaaS licences, headcount, and project costs. Track run-the-business vs change-the-business spend.

Free

Startup Budget Template

Free startup budget template with burn rate tracking, runway calculations, and fundraising scenario modelling. Built for seed to Series A companies.

FreeπŸ‡ͺπŸ‡Ί

Multi-Currency Budget Model

Free multi-currency budget template with exchange rate tables, automatic translation, and FX variance analysis. Built for European finance teams managing EUR and local currencies.

FreeπŸ‡ΊπŸ‡Έ

US Budget Model Template

Free multi-department budget template with US tax considerations, state-level payroll modeling, and GAAP-aligned structure. Built for US finance teams.

Reporting

Free

Board Report Template

Free board reporting template with P&L summary, KPI dashboard, budget vs actual analysis, and commentary sections. Board-ready in minutes.

Free

Variance Analysis Template

Free budget vs actual variance analysis template with price/volume decomposition, RAG status, and commentary fields. Identify and explain deviations.

Free

Monthly Close Checklist Template

Free monthly close checklist template with task assignments, due dates, and completion tracking. Close your books faster and more consistently.

Free

KPI Dashboard Template

Free KPI dashboard template with financial and operational metrics, trend tracking, and threshold alerts. Track the metrics that matter.

Free

Budget vs Actual Report Template

Free budget vs actual report template with monthly and YTD views, percentage variance, and trend analysis. Compare plan to performance at a glance.

Free

Management Report Template

Free monthly management report template with P&L summary, operational highlights, risks, and action items. Keep your leadership team informed.

Free

Investor Update Template

Free monthly investor update template with KPI summary, financial highlights, product milestones, and ask section. Keep your investors informed.

Free

Financial Review Template

Free quarterly financial review template with period-over-period analysis, trend identification, and strategic recommendations. Drive better decisions.

FreeπŸ‡ͺπŸ‡Ί

IFRS P&L Template

Free IFRS-compliant income statement template with proper classification of expenses, finance costs, and tax. Designed for European finance teams reporting under IFRS.

FreeπŸ‡ͺπŸ‡Ί

EU Subsidiary Consolidation Template

Free consolidation workbook for multi-entity EU groups. Includes intercompany elimination, currency translation, and IFRS-compliant consolidated financial statements.

FreeπŸ‡ΊπŸ‡Έ

US GAAP P&L Template

Free US GAAP-compliant profit and loss template with ASC 606 revenue structure, operating expense breakdown, and EPS calculation. Designed for US finance teams.

FreeπŸ‡ΊπŸ‡Έ

US SaaS Metrics Dashboard Template

Free SaaS metrics dashboard template with ARR waterfall, NRR, CAC payback, and Rule of 40 tracking. Built for US SaaS finance teams in USD.

Custom models

Need a custom template?

Our team can help you build a model tailored to your business. All templates are included on every plan.

Talk to our team