Skip to content

Care Home Accounts and Funding

A Lender-Ready 24 to 36 Month Forecast for a Supported Living Contract

11 November 2026 · 5 min read

A supported living forecast a lender will accept is built from care hours upward, not from a contract value downward. The model that gets funded shows contracted support hours by package, a fully loaded staff cost per hour built on the 2026-27 stack of the £12.71 National Living Wage plus employer National Insurance at 15% above the £5,000 secondary threshold plus holiday accrual at 12.07% of hours worked, and a monthly cash line running 24 to 36 months so the point of deepest funding need is visible rather than averaged away.

Why does the model start with hours rather than income?

Because hours are the only input a lender can check. A commissioner's framework paperwork states the packages, the weekly hours and the agreed rate, so a forecast built from hours can be tested line by line against a document that already exists. A forecast built from an annual contract value cannot be tested at all, and it hides the two variables that actually move the outcome: how quickly packages start, and how many paid hours it takes to deliver a chargeable hour.

Build the hours sheet before anything else. One row per package, with waking support hours a week, sleep-in nights a week, the agreed rate for each, and the month the package is expected to start. The rest of the model is arithmetic on that sheet.

What goes into a fully loaded cost per hour?

The gross rate is only the start of the answer. From 1 April 2026 the National Living Wage is £12.71 for workers aged 21 and over, with £10.85 for those aged 18 to 20 and £8.00 for under-18s and first-year apprentices, so the age mix in your rota changes the number. On top of the gross rate the model adds employer National Insurance at 15% on earnings above the secondary threshold of £5,000 a year, which is £96 a week, and holiday accrual for irregular-hours staff at 12.07% of the hours they work in each pay period.

Then add the hours you pay for but cannot invoice. Travel between one person's home and the next is working time for National Minimum Wage purposes in a dispersed service, and reimbursed mileage runs at the Approved Mileage Allowance Payment rate of 55p a mile for the first 10,000 business miles from 6 April 2026. Sickness cover, induction, supervision and mandatory training are all paid hours that no commissioner pays for. Our reference on the 2026-27 care worker pay rates sets out the stack in full, and the sleep-in and travel time rules cover the night cost separately.

One allowance sits outside the per-hour figure. Employment Allowance reduces the employer National Insurance bill by up to £10,500 a year, but check three things first. Support commissioned by councils or the NHS can make public-sector work more than half of what you do, and then only a charity can claim, though HMRC says public funding doesn't settle that by itself. A company whose sole director is its one employee above the threshold can't claim. And a connected group gets one claim, not one per company. It is a business-level relief, so it belongs in the overhead block, applied once, not spread across every contract you model.

What does the hours-to-cost bridge look like?

It turns a weekly package schedule into paid hours and then into cost. The figures below are an example for illustration, not a rate any commissioner has agreed, and your own rota and age mix will produce different numbers.

LineExample figureWhere it comes from
Contracted support hours a week400Package schedule in the framework paperwork
Paid hours a week448Contracted hours plus 12% for travel, cover and training
Gross pay rate an hour£12.71National Living Wage, 21 and over, April 2026
Employer National Insurance15% above £5,000 a yearSecondary threshold, modelled per head not as a blanket percentage
Holiday accrual12.07% of hours workedIrregular-hours accrual method
Pension, sleep-ins, mileageSeparate linesAuto-enrolment, awake-hours assumption, 55p a mile

Model employer National Insurance per head rather than as a flat percentage of payroll. A supported living rota built largely of part-time staff puts many workers close to or below the weekly threshold, and a blanket percentage overstates the cost.

How should the ramp and the cash line be built?

Package starts are the ramp. Staff are recruited ahead of them, so the cost curve leads the income curve by one to two months at the front of the contract, and that lag is the funding gap the lender is being asked to cover. Show it as a monthly cash line with an opening balance, not as an annual surplus.

Two timing effects deepen it. Staff are paid weekly or monthly while local authority invoices settle on the commissioner's payment run, and a rate that is agreed in principle may be invoiced only once the package is formally confirmed. Carry a separate debtor-days assumption, and carry a void assumption for the weeks a package is paused through hospital admission or a placement ending. The same discipline applies to occupancy elsewhere in care, as our note on agency cost and occupancy control sets out.

Build the 12-month forecast here: set your hours ramp, rates, pay and overheads, and it lays out income and each cost line month by month, with the cash you need to fund the start.

Calculator

Build the 12-month forecast CQC asks home care agencies for

Enter your care hours, the rates you'll charge and what you'll pay. You get twelve months of income, each cost line month by month, profit or loss, your cash balance and the lowest point it reaches, which is the funding you need.

Months from April 2027 use your April 2027 wage and any rate rise you enter below.

Leave at 0 if the forecast starts when care starts. Enter the months of rent, salary and set-up costs with no fees coming in if you want those in the twelve.

Face-to-face care hours delivered each week (travel isn't included here).

Hours grow in equal steps each month from the first figure to the target, then hold.

%

The rest is charged at your private rate. Enter 100 if every hour is council funded, or 0 if none is.

£

An example figure. Use the rate in your council's framework or contract.

£

An example figure. Use the rate your pricing research supports; CQC's guidance asks how you decided your pricing.

%

Only enter a rise your contract or the council's fee review supports. At 0 the April 2027 pay rise comes straight out of your margin.

Private clients are assumed to pay in the month. You pay carers from the first call either way.

£

The National Living Wage for workers aged 21 and over is £12.71 from 1 April 2026.

£

£13.21 is the rate the Government has accepted from 1 April 2027 for workers aged 21 and over; the regulations aren't made yet.

Used to work out how many carers you employ, because employer NIC and pension are worked per person.

Travel between calls is working time for the minimum wage, so it's paid at the carer's hourly rate.

Paid at 55p a mile, the approved rate for the first 10,000 business miles in a tax year.

Only used when you enter travel per visit: it turns your per-visit travel and miles into per-hour figures.

%

An allowance for the paid hours and costs nobody invoices for. 10% matches our true cost of a care hour calculator.

%

Your workplace pension contribution, on pay between £6,240 and £50,270 a year, the same band our true cost of a care hour calculator uses.

£

An example figure; enter your own. Leave at 0 if you'll manage the service yourself and take no salary.

£
£

Care planning, rostering and call monitoring systems, phones and IT.

£
£
£

Office supplies, professional fees, bank charges and anything else that runs every month.

CQC's annual fee for a home care location is £239 plus £54.305 for each service user.

£

Your result

Your answer's ready. Press below to see it.

What does the tax and structure layer add?

Two corrections, and both usually push the cost up. The first is the corporation tax rate the projected profit actually meets, which is 19% only up to £50,000 of profit. Where the operating company sits alongside a property company or other related entities, the associated company rules divide that threshold and the one above it between them, so a model that assumes the small profits rate shows a tax charge well below the real one.

VAT is the second, and it belongs in the model as a cost rather than a recovery. Registration with the Care Quality Commission puts your support income inside the welfare exemption, so the VAT on set-up costs, vehicles and professional fees never comes back. Fee levels themselves sit inside the Care Act 2014 statutory guidance and the market sustainability framework, which is the basis for a fee review rather than a promise of an uplift. Longer-term durability matters too: the ONS survival data for care businesses is the evidence a lender weighs against a three-year plan, and our page for supported living providers covers the structure decisions that sit underneath the model.

Want this checked against your specific situation?

Leave your details and a one-line summary. We'll come back to you, with no obligation.

We'll only use your details to respond to your enquiry. We don't pass them to any other firm. See our Privacy Policy.

What does a lender look at first?

The assumptions tab. Every figure that is not derived belongs in one place, sourced, dated and labelled, with the framework rate, the pay rates, the ramp profile, the debtor days and the void assumption each showing where they came from. A model with hard-coded numbers buried in formulas is treated as untested. Your accountant prepares the pack in that form and a specialist reviews the pay stack and the associated company position before it goes out. Registering a new service as well? CQC asks for its own 12-month forecast with the business plan, and we'll build that with you too.

Everything above assumes an English service. A supported living forecast for Scotland, Wales or Northern Ireland runs against a different regulator and different commissioning arrangements, so the registration and fee-setting assumptions in the model need checking locally before it goes to a lender.

Frequently asked questions

Run it monthly for 24 months as the minimum and 36 months where the framework place or the lease runs that far. A lender is testing two things: whether the contract covers its own cost once the service is at full occupancy, and whether you can fund the months before it gets there. Both questions live in the first 18 months, so an annual three-column forecast hides exactly the period the lender cares about. Thirty-six months also lets you show a second-year pay uplift rather than assuming today's rates hold forever.

Six inputs carry almost all of the outcome: contracted support hours by package and by week, the hourly rate the commissioner has agreed, the ramp profile showing how many packages start in each month, the fully loaded staff cost per hour, the fixed overhead that runs whether or not the packages fill, and the payment terms and expected lag on local authority invoices. Everything else in the model is derived from those six. A lender that cannot see all six will usually ask for the model back.

The gross hourly rate, employer National Insurance at 15% on earnings above the £5,000 annual secondary threshold, holiday accrual at 12.07% of hours worked for irregular-hours staff, pension contributions, paid travel time between calls where the service is dispersed, and the cover cost for sickness and training hours that are paid but not chargeable. Modelling only the gross rate understates the true cost of an hour by a wide margin and is how a supported living forecast falls apart in year one.

Sleep-in shifts are costed separately from waking support hours. Following the Supreme Court decision in Royal Mencap Society v Tomlinson-Blake, a worker who is permitted to sleep is entitled to the National Minimum Wage only for the time they are awake for the purposes of working, not for the sleeping period, provided sleeping facilities are supplied. The model should therefore carry a sleep-in allowance line plus a separate assumption for expected awake hours, rather than costing the whole night at the hourly rate.

Only where the contract says so, and label the assumption clearly either way. The Care Act statutory guidance expects a council to have evidence that what it pays covers the agreed care and leaves providers a reasonable return; that guidance and the market sustainability framework are the basis on which you open a fee review. It is not a guarantee of an annual uplift. A lender reads an unexplained rate rise in year two as the number that makes the model work, so if you do assume one, show the contract clause or the fee review timetable it rests on.

Yes, but as a cost line rather than a recovery line. A Care Quality Commission registered provider's support services fall inside the welfare exemption, so the input VAT on set-up spend, vehicles, professional fees and consumables is not reclaimable and every one of those lines belongs in the model at its gross figure. Where the provider also makes taxable supplies, a partial exemption calculation decides whether any of that input tax comes back, and we review the position before the figures go to a lender.

Care Home Accounts and Funding

Need specialist care sector finance advice?

Tell us about your care service and we will come back within 24 hours.

Get in touch

Step 1 of 2 · About you

Optional: a bit more detail (helps us prepare)