Occupancy is the whole forecast
In most businesses you can trim costs when revenue disappoints. A nursery cannot. Statutory ratios mean that a room open to children must be staffed to ratio whether it holds its full complement or half of it, so the cost base barely moves while the income does. That is what makes occupancy the dominant variable and what makes the first eighteen months the dangerous period.
Model it month by month, and be pessimistic. Enquiries convert slowly because parents visit several settings and then wait for a start date that suits their leave. Word of mouth, which is how nurseries genuinely fill, needs a cohort of happy families to exist first. A forecast that reaches 85% occupancy in month six describes a nursery nobody has ever run.
The realistic shape is a slow first two terms, acceleration once the first families start recommending you, and a September step when children move up and new starters arrive together. Build that shape in, and make sure the funding lasts through the shallow part of it.
The age mix decides profitability
Two nurseries with identical occupancy can have very different results, because the ratio for the under-twos is far tighter than for three and four year olds. A baby place consumes much more staff time than a preschool place, and fees rarely rise in proportion.
That produces a familiar pattern: baby rooms operate close to break-even or below and act as the pipeline, while preschool rooms carry the profit — and preschool is also where funded hours concentrate, at rates that may not cover cost. The plan needs to model each room separately with its own ratio, its own fee and its own funded proportion. A blended average across the setting conceals precisely the structural problem you need to find.
Funded hours are income you cannot price
Government funded entitlement is paid at a rate your local authority sets. You cannot negotiate it, it may not keep pace with wage increases, and the rules on what you can charge alongside it are specific.
For planning purposes, treat funded and private income as two separate revenue lines with different characteristics. Private hours can be repriced annually. Funded hours cannot, and if the settlement rises by less than your wage bill does, that portion of your income has gone backwards in real terms without any decision on your part. A plan that shows the split explicitly, and shows what happens if the funded rate is held flat while wages rise, is a considerably more credible document than one that blends everything into a single average fee.
Where SquarePlan fits
You enter your registered places by age band, your expected occupancy ramp, your fee structure, the funded proportion and the staffing each room requires. SquarePlan builds the monthly cash flow, break-even point and profit and loss, with payroll costs including employer National Insurance and pension calculated underneath. Push the occupancy ramp out by six months and you can see immediately how much working capital that costs — which is the question to answer before signing a lease.