Real-world financial planning examples

Budget & Forecast Examples

Realistic financial planning examples with actual numbers, formulas, and annotations. See how UK finance teams build budgets, forecasts, and reports.

Line Item
Q1
Q2
Q3
Revenue
£1,200k
£1,280k
£1,350k
COGS
(£360k)
(£384k)
(£405k)
Gross Profit
£840k
£896k
£945k
Salaries & Wages
(£480k)
(£492k)
(£510k)

Annual Budget Example

A 120-person B2B software company based in Manchester with £5.2M annual revenue. The business sells a subscription product to mid-market companies and is forecasting 18% growth this year. The finance team is building the annual budget for FY2026.

View example
P&L Line
Jan (A)
Feb (A)
Mar (A)
Revenue
£310k
£325k
£298k
Direct Costs
(£155k)
(£163k)
(£149k)
Gross Profit
£155k
£162k
£149k
OpEx
(£98k)
(£101k)
(£97k)

Rolling Forecast Example

A 75-person professional services firm in Birmingham with £3.8M revenue. The CFO has moved from static annual budgets to a rolling 12-month forecast that is updated monthly. This view shows the March update with Jan-Mar actuals locked.

View example
Cash Flow
Wk 1
Wk 2
Wk 3
Opening Balance
£185k
£142k
£168k
Customer Receipts
£62k
£78k
£45k
Other Income
£3k
£1k
£2k
Supplier Payments
(£68k)
(£28k)
(£52k)

13-Week Cash Flow Forecast Example

A 40-person e-commerce company in Leeds with £2.8M revenue. The business is profitable but cash-tight due to inventory purchasing cycles. The finance team runs a weekly 13-week cash forecast to ensure the company never drops below its £50k minimum cash threshold.

View example
P&L Line
Budget
Actual
£ Var
Revenue
£1,020k
£1,065k
+£45k
Direct Costs
(£510k)
(£545k)
(£35k)
Gross Profit
£510k
£520k
+£10k
Salaries
(£285k)
(£280k)
+£5k

Budget vs Actual Variance Report Example

A 60-person marketing agency in London with £4.1M revenue. The Head of Finance produces a monthly BvA (Budget vs Actual) report for the leadership team. This March report shows YTD Q1 performance against the annual budget.

View example
KPI
January
Target
Status
ARR
£6.52M
£6.40M
Ahead
MRR Growth
2.8%
2.5%
Ahead
Gross Margin
72.1%
70.0%
Ahead
Net Burn
(£45k)
(£60k)
Ahead

Board Report Example

A 90-person fintech company in Edinburgh with £6.5M ARR. The CFO presents a monthly board pack covering financial performance, key metrics, and cash position. This is the February board report, covering January performance.

View example
Statement
Line Item
FY2025
P&L
Revenue
£8,500k
P&L
Net Income
£680k
BS
Total Assets
£5,200k
BS
Total Equity
£3,100k

Three-Statement Financial Model Example

A 150-person manufacturing company in Sheffield with £8.5M revenue. The FP&A team maintains a three-statement model that links the P&L, Balance Sheet, and Cash Flow statement. This is the FY2025 annual summary used for lender reporting and strategic planning.

View example
SaaS Metric
Q1
Q2
Q3
Starting MRR
£168k
£185k
£204k
New MRR
£12k
£14k
£16k
Expansion MRR
£8k
£9k
£10k
Churned MRR
(£3k)
(£4k)
(£5k)

SaaS Budget Example

A 35-person B2B SaaS company in Bristol with £2.1M ARR. The company is post-Series A and needs a budget that speaks the language of SaaS metrics while maintaining a proper P&L. This budget bridges operational SaaS KPIs with financial reporting.

View example
Department
FTE
Avg Salary
ER NI
Engineering
38
£68k
£356k
Product
8
£62k
£68k
Sales
18
£55k
£137k
Marketing
10
£52k
£72k

Headcount Plan Example

A 100-person technology company in Cambridge with £7M revenue. The People team and Finance team collaborate on the annual headcount plan, which feeds directly into the P&L budget. This plan covers all departments with fully loaded costs including employer NI (13.8%), pension (5%), and benefits.

View example
P&L Line
Downside
Base Case
Upside
Revenue
£3,800k
£4,500k
£5,400k
Gross Profit
£2,280k
£2,700k
£3,240k
Total OpEx
(£2,100k)
(£2,250k)
(£2,400k)
EBITDA
£180k
£450k
£840k

Scenario Analysis Example

A 55-person logistics technology company in Reading with £4.5M revenue. The CFO is preparing for a board meeting and needs to present three scenarios: base case (the plan), upside case (if two large contracts close), and downside case (if the market softens). The scenarios share the same cost structure but vary revenue and growth assumptions.

View example
Category
Q1
Q2
Q3
Team Costs
£155k
£160k
£165k
Paid Acquisition
£48k
£55k
£62k
Content & SEO
£22k
£25k
£25k
Events & Sponsorships
£15k
£45k
£10k

Departmental Budget Example

A 80-person B2B SaaS company in London with £5.8M ARR. The VP Marketing is building the annual marketing budget for FY2026. The department has 10 people and a total budget of £1.2M covering team costs, paid channels, content, events, and software tools.

View example
Revenue Driver
Q1
Q2
Q3
Active Users
12,500
14,200
16,100
Transactions/User
3.2
3.4
3.5
Avg Transaction Value
£85
£87
£88
Take Rate
8.5%
8.5%
8.5%

Revenue Model Example

A 45-person marketplace company in Manchester with three revenue streams: transaction fees, subscriptions, and advertising. The Head of FP&A is building a driver-based revenue model that starts from operational metrics (users, transactions, ARPU) and builds up to total revenue.

View example
P&L Summary
Jan Actual
Jan Budget
£ Var
Revenue
£528k
£510k
+£18k
Gross Profit
£369k
£357k
+£12k
OpEx
(£305k)
(£295k)
(£10k)
EBITDA
£64k
£62k
+£2k

Monthly Management Report Example

A 110-person healthcare technology company in Oxford with £6.2M revenue. The FP&A team produces a monthly management pack by the 10th working day of each month. This February pack covers January performance and is distributed to the CEO, CTO, VP Sales, VP Operations, and department heads.

View example
KPI
Dec
Jan
Feb
Revenue Growth (YoY)
22%
24%
26%
Gross Margin
62.5%
63.1%
64.0%
EBITDA Margin
14.2%
15.0%
15.8%
Cash Conversion
88%
92%
95%

Finance KPI Dashboard Example

A 70-person professional services company in Glasgow with £5.5M revenue. The CFO has built a KPI dashboard that tracks 8 key metrics monthly. This dashboard is the first page of every management report and board pack, providing a 30-second health check of the business.

View example
Capex Item
FY2026
FY2027
FY2028
Production Equipment
£420k
£180k
£250k
Warehouse Expansion
£350k
--
--
IT Infrastructure
£120k
£80k
£90k
Vehicles
£65k
£45k
£50k

Capex Plan Example

A 200-person manufacturing company in Coventry with £12M revenue. The Finance Director is building a 3-year capital expenditure plan for board approval. The company needs to invest in new production equipment, warehouse expansion, and IT infrastructure to support the growth plan.

View example
Metric
December
January
February
ARR
£1,650k
£1,720k
£1,810k
MRR
£137.5k
£143.3k
£150.8k
Net New MRR
+£8.2k
+£5.8k
+£7.5k
Gross Burn
£105k
£108k
£112k

Investor Report Example

A 25-person Series A SaaS startup in London with £1.8M ARR. The CEO sends a monthly investor update to 12 investors. The update covers key metrics, milestones, asks, and a brief narrative. This is the February update, sent on the 5th of March.

View example
Budget Summary
FY2026 (A)
FY2027 (B)
Growth
Revenue
£9,200k
£10,800k
+17.4%
Gross Profit
£5,520k
£6,480k
+17.4%
Total OpEx
(£4,600k)
(£5,300k)
+15.2%
EBITDA
£920k
£1,180k
+28.3%

Budget Presentation Example

A 130-person digital agency in London with £9.2M revenue. The CFO is presenting the FY2027 budget to the board of directors. The presentation follows a structured format covering strategic context, P&L summary, key assumptions, departmental allocations, and investment cases.

View example
Week
Activity
Owner
Output
Day 1-3
Close books, import actuals
Controller
Trial balance
Day 4-6
Variance analysis
FP&A Analyst
BvA report
Day 7-8
Update rolling forecast
FP&A Manager
Updated model
Day 9-10
Management pack
FP&A Manager
Monthly pack

FP&A Workflow Example

A 150-person mid-market company in Leeds with £11M revenue. The FP&A team of three people runs a disciplined planning cadence covering monthly close, quarterly reforecasts, and annual budgeting. This workflow ensures the business always has a current view of performance and outlook.

View example
Shared Cost
Total
Consulting
Advisory
IT Support
£480k
£168k
£120k
HR
£320k
£128k
£80k
Finance
£420k
£147k
£105k
Facilities
£580k
£174k
£145k

Cost Allocation Example

A 180-person professional services firm in London with £14M revenue and four operating departments: Consulting, Advisory, Technology, and Research. Central costs (IT, HR, Finance, Facilities) totalling £1.8M per year need to be allocated to each department for true profitability analysis.

View example
Driver
Assumption
Q1
Q2
Starting Customers
--
420
445
New Customers
8%/qtr
38
40
Churned Customers
3%/qtr
(13)
(13)
Ending Customers
--
445
472

Driver-Based Budget Example

A 50-person subscription business in Edinburgh with £3.2M ARR. The FP&A team is replacing last year's static spreadsheet budget with a driver-based model where every line item is linked to an operational assumption. Changing one driver automatically recalculates the entire P&L.

View example
P&L Line
Original Budget
Q2 Reforecast
£ Change
Revenue
£7,500k
£7,050k
(£450k)
Gross Profit
£4,875k
£4,583k
(£292k)
Total OpEx
(£3,900k)
(£3,750k)
+£150k
EBITDA
£975k
£833k
(£142k)

Q2 Reforecast Example

A 95-person healthcare company in Bristol with £7.5M revenue. After Q1 actuals came in 8% below budget on revenue, the CFO is conducting a Q2 reforecast. The reforecast updates the full-year outlook while preserving the original budget as a baseline for performance measurement.

View example

Build it yourself

Recreate any example in Grove FP in minutes

Every example on this page can be built in Grove FP using our template library and formula engine. No spreadsheet wrangling required.

Request Early Access