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.
| Line | Example figure | Where it comes from |
|---|---|---|
| Contracted support hours a week | 400 | Package schedule in the framework paperwork |
| Paid hours a week | 448 | Contracted hours plus 12% for travel, cover and training |
| Gross pay rate an hour | £12.71 | National Living Wage, 21 and over, April 2026 |
| Employer National Insurance | 15% above £5,000 a year | Secondary threshold, modelled per head not as a blanket percentage |
| Holiday accrual | 12.07% of hours worked | Irregular-hours accrual method |
| Pension, sleep-ins, mileage | Separate lines | Auto-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.
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.
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.