Shop · Family and Care

Care Home Fees Runway Calculator: photo 1 of 5 from its Etsy listing
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

£9 Buy on Etsy

Instant download: Etsy takes the payment and sends you the files straight away.

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.

Care Home Fees Runway Calculator: photo 2 of 5Care Home Fees Runway Calculator: photo 3 of 5Care Home Fees Runway Calculator: photo 4 of 5Care Home Fees Runway Calculator: photo 5 of 5

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