Financial Modelling Tool for Senior Care Homes

Project Setup

• Project name : Senior Care Home – Residential Facility
• Time period : Monthly (ideal for tracking care fees, staffing, and facility running costs)

Income Components

Component: Resident Income

Sub-components:

• Standard Residential Care – 20 residents at £3,000/month = £60,000/month
• Nursing Care Surcharge – 10 residents needing nursing care at £500/month = £5,000/month
• Respite Care (Short-term stays) – Avg. 2 per month at £2,000 = £4,000/month

Component: Additional Services Income

Sub-components:

• Physiotherapy & Wellness Programs – Avg. £1,000/month total
• Hairdressing & Grooming – Avg. £500/month
• Family Meals / Visitor Dining – Avg. £300/month
• Subsidies from Local Authority or NHS Continuing Healthcare – £10,000/month (for eligible residents)

Expenditure Components

Component: Staffing Costs

Sub-components:

• Care Staff Salaries – 15 staff at avg. £2,200/month = £33,000/month
• Nursing Staff – 5 staff at avg. £3,000/month = £15,000/month
• Kitchen & Cleaning Staff – 6 staff at avg. £1,800/month = £10,800/month
• Agency Staff (variable cover) – £2,000/month average
• Staff Training & Development – £500/month

Component: Operational Costs

Sub-components:

• Food & Catering – £3,500/month
• Utility Bills – Electricity, Gas, Water – £2,500/month
• Laundry Services – £800/month
• Medical Supplies & PPE – £1,000/month
• Insurance – £4,000/year (£333/month)
• Facility Maintenance – £1,200/month average
• Activities Budget – £500/month

Component: Administrative Costs

Sub-components:

• Software Subscriptions (e.g. care management system, Brixx) – £300/month
• Marketing & Website – £400/month
• Legal & Accounting – £1,200/year (£100/month)
• Office Supplies – £100/month

Asset Components

Component: Fixed Assets

Sub-components:

• Care Home Property (Owned) – Purchase price: £1,200,000, appreciation rate: 2% annually
• Medical Equipment – £40,000, depreciated over 5 years
• Furniture & Fixtures – £60,000, depreciated over 5 years
• Minibus for Resident Transport – £25,000, depreciated over 6 years

Component: Current Assets

Sub-components:

• Cash Reserves – Starting with £100,000
• Accounts Receivable (unpaid resident fees) – £10,000
• Consumables Inventory – £5,000

Funding Components

Component: Mortgage or Business Loan

Sub-components:

• Commercial Mortgage – £800,000 at 4.5% interest, 20-year term
• Repayments: Approx. £5,000/month (interest + capital)

Component: Personal Investment

Sub-components:

• Initial Equity Injection – £400,000

Component: Grants or Support Funding

Sub-components:

• Government Start-up Grant (if applicable) – £20,000

Scenario Planning in Brixx

Occupancy Scenarios

• Model 80%, 90%, and full occupancy to see revenue impact
• Include seasonality for respite care

Wage Increases

• Explore the impact of national living wage increases on staff costs

Utility Cost Surges

• Spike gas/electric by 20% in a scenario to stress test cash flow

Regulatory Changes

• Add unexpected cost component for compliance updates (£10k annually)

Dashboard & Reporting

Cash Flow Report

• Visualise monthly fee income vs staffing and operational costs

Balance Sheet

• Show building value appreciation, equipment depreciation, and mortgage balance reduction

Profit & Loss Statement

• Track profitability trends, service cost breakdowns

Custom KPIs

• Revenue per Resident
• Staff Cost per Resident
• Occupancy Rate
• EBITDA Margin
• Care Quality Score (optional input-based metric)