Calculator · Excel + PDF

The Practice P&L Sensitivity Tool.

Three-scenario forward modelling of a UK GP practice across three years.

What this Calculator is for

A single year's P&L tells you what happened. It does not tell you what is likely to happen, or what would happen if the funding mix changed, or how sensitive the partnership's drawings are to a 5% shift in staff costs or a 10% change in list size.

This Calculator does that work. The user enters a small number of practice-specific inputs. The Calculator produces three years of projected P&L under each of three scenarios, plus sensitivity analysis on the variables that materially move the bottom line.

What's inside

7 sheets in a single Excel file, plus an accompanying PDF user guide.

  1. Inputs — practice-specific data the user enters once
  2. Assumptions — UK 2026/27 funding parameters and cost benchmarks
  3. Scenarios — the three forward-looking cases the Calculator runs
  4. P&L projections — three years' projected P&L for each scenario
  5. Sensitivity — how the bottom line responds to changes in key variables
  6. Summary — a one-page output for printing or sharing
  7. Methodology — what the Calculator does and doesn't do

How it reads

"A sensitivity analysis is not a prediction. It is a structured account of what would happen under different assumptions, which is a different and more honest thing. The use of a sensitivity tool is not to know what the future will be — it is to know which variables matter, which do not, and where the partnership's exposure actually lies."
— from the PDF user guide, Reading the output

Who it's for

  • GPs considering a partnership offer. Turns the practice's current P&L into a three-year forward view of what the partnership is actually offering.
  • New partners planning their first year. The drawings projection tells you what's available to draw without endangering working capital.
  • Practice managers briefing the partnership. The summary output is the financial picture the partnership board actually needs.

What's not in this Calculator

It is a tool, not regulated advice. It does not provide personalised financial, legal, or tax recommendations. Those require a qualified professional who knows your full circumstances. The calculator's purpose is to make those conversations substantive rather than passive.

It focuses on UK clinical practice specifically — the regulatory and commercial environment of the UK.

What's related