Family and Care
Care Home Fees Runway Calculator
Care Home Fees Calculator UK, How Long Will Savings Last in a Care Home, Self Funder Planner, Elderly Parent Care Costs, Excel & Sheets
How long will Mum or Dad's savings last in a care home, and when should the council start to help?
Put in the weekly fee, their income and savings. This spreadsheet works out the weekly shortfall, the month savings reach the upper limit, when to ask the council for a financial assessment, and what happens after that, using the 2026/27 rules for England, Wales, Scotland and Northern Ireland.




What's inside (5 tabs)
- Start Here: Their nation, the 2026/27 rules and the answer
- Money: Fee, income, other costs, savings and home
- Runway: 120 months: who pays and what to do next
- Compare Homes: How long savings last at each home
- Guide: How the means test works, in plain English
What it does
- The date council help should start, and when to ask for an assessment
- 10-year month-by-month runway with yearly fee rises
- The 'tariff' stage between the limits, worked out for you
- 12-week property disregard, NHS nursing care and Scottish free personal care built in
- Compare up to 8 care homes side by side, including possible top-ups
What you get
- 1 Excel file (.xlsx): care_home_fees_runway.xlsx
- A step-by-step PDF setup guide
- A Google Sheets link (in a PDF): one click and Google makes you your own copy, no uploading
- Example data already filled in so you can see how it works. Clear it in seconds
What you need
- Microsoft Excel 2010 or newer (including Microsoft 365), on Mac or PC
- OR a free Google account to use it in Google Sheets (the guide shows you how)
- Best on a computer or tablet. Not made for Apple Numbers
Please note
- This is a digital download. No physical item will be sent
- A planning tool, not financial advice. Every council does its own final assessment
- Figures are for the 2026/27 tax year. They're in one place in the file, so they're easy to update
- For your own personal use. Please don't resell or share the file
How it's made
Designed by me, built with the help of AI tools, then checked formula by formula against the official rules.
Care Home Fees Runway Calculator £9
Buy on Etsy


