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.

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