P&L Planning Model | Step-by-Step FP&A Guide

Every finance function has one document that everything else revolves around: the P&L plan. It is the financial story of the next three years, approved by the board, shared with investors, and used to set targets for every team in the business. It is also, more often than not, built as a sprawling, hardcoded Excel file that breaks the moment someone changes a growth assumption. If you have ever opened a “budget” spreadsheet and found dozens of manually typed numbers with no clear logic connecting them, you have seen what a P&L plan looks like when built badly.

This post builds a clean, driver-based 3-year P&L for PlanCo, a fictional B2C subscription business, using professional modelling conventions from the start. By the end you will know exactly how to structure a planning model that holds up under scrutiny — from a CFO review, a board presentation, or a job interview.

Plan, Budget, Forecast — Getting the Terminology Right

These three words are often used interchangeably in casual conversation but they mean very different things in a finance function, and confusing them in front of a CFO is a quick way to lose credibility.

A strategic plan covers a 3–5 year horizon. It is directional and high-level, approved by the board once a year. It answers the question: where is this business going, and is that direction financially viable? The plan sets the ambition.

A budget is the 12-month operationalised version of the plan. It is far more granular — monthly breakdowns, headcount by name, approved capital expenditure projects. The budget is what teams are held accountable to throughout the year.

A forecast (also called a rolling forecast, Latest Estimate, or Year-End Forecast depending on the organisation) is a mid-year update. It combines actual results to date with refreshed assumptions for the remaining months. A good forecast answers: “Given what we now know, where will we end the year?”

In this post, we are building the strategic plan — a 3-year P&L that gives leadership a credible financial roadmap. The budget model (post five in this series) goes one level deeper into monthly granularity and headcount timing.

The P&L Structure

Before writing a single formula, it is worth establishing the structure your model will follow. A professional P&L plan runs from top to bottom like this:

Revenue
  − Cost of Goods Sold / Cost of Revenue
= Gross Profit             [Gross Margin %]
  − Sales & Marketing
  − Research & Development
  − General & Administrative
= EBITDA                   [EBITDA Margin %]
  − Depreciation & Amortisation
= EBIT                     [EBIT Margin %]
  − Net Interest Expense
= Pre-tax Profit
  − Tax
= Net Profit               [Net Margin %]

Each subtotal line has a corresponding margin percentage calculated against revenue. This is not optional — showing only absolute values without margin percentages is a red flag in any professional model. The margin trend is usually more informative than the absolute numbers, because it shows whether the business is becoming more or less efficient as it scales.

There are four margin lines worth memorising:

Gross margin signals pricing power and the cost efficiency of delivery
EBITDA margin is the most widely used profitability metric in FP&A and valuation
EBIT margin shows profitability after the cost of assets (D&A) is included
Net margin is the bottom line after financing costs and tax — less useful for operational analysis but essential for equity investors

For PlanCo, a subscription business with primarily digital delivery, we would expect a gross margin above 60% (minimal per-unit delivery cost), and EBITDA margins that are initially negative as the business invests in growth before turning positive by Year 3.

Building the Revenue Plan

Revenue modelling comes first. It drives most of the downstream cost and investment decisions, so if the revenue build is weak, the whole model is compromised.

For a subscription business like PlanCo, revenue is a function of subscriber count and average revenue per user. The clean way to model this is with a subscriber waterfall:

Closing Subscribers = Opening Subscribers + New Adds − Churned Subscribers

Where:
  Churned Subscribers = Opening Subscribers × Monthly Churn Rate

Revenue = Average Subscribers × ARPU × 12
  (Average Subscribers = (Opening + Closing) / 2)

Using the average of opening and closing subscribers — rather than just closing — gives a more accurate revenue figure because new subscribers added during the year only contribute revenue for part of the year.

Here are PlanCo’s Year 1–3 assumptions and the resulting revenue build:

Metric	Year 1	Year 2	Year 3
Opening subscribers	8,000	12,800	18,880
New adds	5,600	7,680	9,600
Annual churn rate	5.0%	4.5%	4.0%
Churned subscribers	(400)	(576)	(755)
Closing subscribers	13,200	19,904	27,725
Average subscribers	10,600	16,352	23,303
ARPU (£/month)	£12.00	£12.60	£13.23
Revenue (£000s)	£1,526	£2,477	£3,694

The ARPU grows at 5% per year, reflecting a modest annual price increase. Churn improves gradually as PlanCo refines its product and retention programmes. Together, these two dynamics significantly compound: Year 3 revenue is more than 2.4× Year 1 even though new subscriber additions only grow by 71%.

This subscriber waterfall is also the foundation of a revenue bridge — a tool that decomposes the year-on-year revenue movement into its component parts: the volume effect (more subscribers) versus the price effect (higher ARPU). This bridge format is explored in depth in the variance analysis post.

Building the Cost Model

Once revenue is established, costs can be modelled from drivers rather than guesswork. For PlanCo, we break costs into four categories, each with a different modelling approach.

Cost of Revenue covers the direct costs of delivering the subscription service:

Hosting and infrastructure: modelled at 8% of revenue (scales with usage)
Customer support: headcount-driven — one support agent per 1,500 subscribers, at a fully-loaded cost of £35,000 per head

Sales and Marketing covers subscriber acquisition:

Performance marketing: modelled as Cost per Acquisition (CPA) × New Adds — if PlanCo targets a CPA of £18 per new subscriber, and adds 5,600 in Year 1, marketing spend is £101k
Brand and fixed spend: £60k per year, increasing with a 3% annual inflation uplift

Research and Development covers product engineering:

Engineering headcount × fully-loaded cost per head (salary + employer NI + pension + equipment)
Software licences: per-seat, growing with headcount

General and Administrative covers the fixed overhead of running the business:

Finance, HR, legal, executive team: largely fixed costs with step-ups when the business crosses revenue thresholds (for example, adding a dedicated Head of Finance once revenue exceeds £2m)

Pulling all of this together gives the following 3-year cost and headcount summary:

Department	Year 1 HC	Year 2 HC	Year 3 HC	Year 1 Cost (£000)	Year 2 Cost (£000)	Year 3 Cost (£000)
Customer support	9	13	19	£315	£455	£665
Engineering / R&D	6	8	10	£360	£480	£600
Sales & Marketing	3	4	5	£165	£222	£283
G&A	4	5	6	£220	£280	£345
Total headcount	22	30	40	—	—	—
Performance marketing	—	—	—	£101	£138	£173
Infrastructure	—	—	—	£122	£198	£296
Total costs	—	—	—	£1,283	£1,773	£2,362

Customer support headcount is calculated directly from the subscriber model: 13,200 closing subscribers in Year 1 ÷ 1,500 per agent = 8.8, rounded up to 9 agents. This direct linkage between the revenue drivers and the cost model is what makes a driver-based approach so much more credible than simply applying a percentage uplift to last year’s actuals.

Assembling the P&L and Key Outputs

With revenue and costs built from drivers, assembly is straightforward. Link each line into the P&L structure and calculate margin percentages:

PlanCo 3-Year P&L Summary (£000s)

	Year 1	Year 2	Year 3
Revenue	£1,526	£2,477	£3,694
Cost of Revenue	(£437)	(£653)	(£961)
Gross Profit	£1,089	£1,824	£2,733
Gross Margin %	71.4%	73.6%	74.0%
Sales & Marketing	(£266)	(£365)	(£461)
R&D	(£360)	(£480)	(£600)
G&A	(£220)	(£280)	(£345)
EBITDA	£243	£699	£1,327
EBITDA Margin %	15.9%	28.2%	35.9%
Depreciation & Amortisation	(£45)	(£60)	(£75)
EBIT	£198	£639	£1,252
Net Interest	(£30)	(£25)	(£18)
Pre-tax Profit	£168	£614	£1,234
Tax (25%)	(£42)	(£154)	(£309)
Net Profit	£126	£460	£925
Net Margin %	8.3%	18.6%	25.0%

A few things to note in this output. Gross margin improves modestly from 71% to 74% as infrastructure costs (the most variable element of COGS) scale slightly below revenue. EBITDA margin expands dramatically — from 16% to 36% — because the fixed cost base (G&A, engineering) grows more slowly than revenue. This is the operating leverage story: subscription businesses that reach sufficient scale should show significant margin expansion.

For a SaaS or subscription business, one additional metric is worth calculating: the Rule of 40. This combines the revenue growth rate and the FCF (or EBITDA) margin percentage. A score above 40 is generally considered a sign of a healthy, balanced subscription business.

Rule of 40 = Revenue Growth Rate + EBITDA Margin %

Year 2: 62% revenue growth + 28% EBITDA margin = 90 ✓ (above threshold)
Year 3: 49% revenue growth + 36% EBITDA margin = 85 ✓ (above threshold)

PlanCo scores well because it is still in high-growth mode. As growth moderates, the EBITDA margin needs to expand to maintain a healthy score.

The One-Page Board Summary

A 10-tab planning model is an internal tool. What the board sees is a single summary page — and how well you distil complexity into clarity is as important a skill as how well you build the model itself.

A professional board summary page contains four charts and three tables. The four charts are: a revenue bar chart by year; an EBITDA margin percentage trend line; a subscriber count waterfall; and a FCF bridge (optional if the model includes a cash flow statement). The three tables are: a 5-row P&L summary (Revenue, Gross Profit, EBITDA, EBIT, Net Profit); a KPI summary (5 key metrics: subscriber count, ARPU, gross margin, EBITDA margin, Rule of 40); and a headcount summary by department.

What the CFO cares about: are revenues growing at the rate implied by the strategy? Are margins improving, or is the business investing in growth without a path to profitability? Is the plan self-funding, or does it require additional capital? These three questions should be answerable from your one-page summary in under 60 seconds.

One practical tip: build the summary page last, after the model is complete. Use hard links to your model outputs rather than typed numbers — if an assumption changes, the summary updates automatically.

Key Takeaways

A P&L plan is built from drivers — subscriber counts, headcount, CPA, churn — not from “last year plus X%”. If you cannot explain where every number came from, the plan is not credible.
Revenue modelling comes first. The subscriber waterfall (or equivalent) determines almost every downstream cost and investment decision.
Always show both absolute values and margin percentages. The margin trend is usually the more informative of the two.
Separate your inputs (assumptions) from your calculations (engine) from your outputs (summary). A model where assumptions are scattered throughout calculation tabs is difficult to audit and impossible to hand off.
The one-page board summary is a communication skill. Invest as much care in it as in the underlying model.

Practice

Build the PlanCo P&L model for three years using the assumptions above. Then change one assumption — increase the annual churn rate from 5% to 8% in Year 1, holding all other inputs constant — and trace the full impact through from subscriber count to EBITDA margin. Write a two-sentence board commentary explaining the change in financial outcome, as if presenting to a CFO who has not seen the model.

P&L Planning Model: How to Build a Forward-Looking Profit & Loss from Scratch