Senior Living Model
Healthcare Financial Model (Free Excel Download)
Plan senior-living operations from units, occupancy, care mix, resident fees, staffing, food costs, capex, debt service, and facility-level EBITDA.
professionals from Deloitte
Used by professionals from
About this model
Model senior living facility economics across care levels (independent, assisted, memory care) with acuity mix and labour cost drivers. The model projects unit inventory by care level, census and occupancy with admission and discharge rates, revenue per bed by acuity (higher acuity = higher daily rate), and staffing ratios (nurse-to-resident, aide-to-resident). Operating expenses include food, utilities, supplies, insurance, and nursing labour (the largest cost, 40-50% of revenue). Output: facility profitability by care level, EBITDA margin, and sensitivity to census and wage assumptions.
Revenue drivers are granular: independent living generates lower daily rates (£80-120/day) but high occupancy (95%+); memory care commands premiums (£150-250/day) with lower occupancy (75-85%) due to acuity limits. Labour cost structure is non-linear - you need a minimum daily shift (e.g., 2 nurses) even at low census; as census grows you add staff in steps. The model captures this staircase effect rather than treating labour as a simple % of revenue. Debt service and covenant tracking (DSCR 1.2x+) work for operator or acquisition finance.
Target: operators, investors, lenders evaluating senior living acquisitions or mergers. Essential for regulatory compliance (staff ratios, training costs) and understanding margin sensitivity to occupancy and wage inflation.
What every model includes
Live formulas, no hardcoded values
Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.
All assumptions in one tab
Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.
Statements always balancing
For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.
Distinct schedules for clarity
Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.
No hidden macros or external links
There are no unexplained external workbook links or macros to undermine auditability or portability.
Changes flow through the model
Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.
What's inside the Senior Living Model
- Acuity-based revenue with tiered level-of-care service fees
- Census-linked labour and staffing requirements
- Entrance fee and community fee amortisation tracking
- Development lease-up and stabilisation modelling
- Debt service coverage and investor return analysis
- Unit inventory by care level (independent, assisted, memory care)
- Census and occupancy forecasts with admission and discharge rates
- Revenue per unit by care level and ancillary services
Senior Living Model: Care Levels, Staffing, Cash Sweep and Returns
A senior living model captures the operating and financial relationships of a single care facility. This template forecasts independent living, assisted living and memory care operations, with occupancy ramp, payer mix, staffing by role, a cash sweep and investor returns.
Here we explain the documented mechanics so you can judge whether the structure fits your evaluation.
Care-level occupancy and ramp-up
The model separates independent living, assisted living and memory care, each with its own beds and monthly rate. Occupancy ramps differently by level: memory care stabilises slowest.
- Occupied beds by level drive both revenue and staffing. A live Bear/Base/Bull scenario toggle applies an occupancy delta to the first forecast year so lease-up flows through the whole model.
- Length-of-stay by level then determines annual move-outs, each triggering a matched move-in; these events drive turnover capex and marketing or move-in costs.
Revenue, payer mix and staffing costs
Revenue is a blended care rate scaled by payer mix. Five payer slices—private pay, Medicare, Medicaid, LTCI and VA—must sum to one hundred percent, and each applies a rate factor relative to private pay.
- Ancillary revenue adds a per-resident monthly charge. Staffing uses hours per resident day by role, with separate wages and inflation rates.
- Agency labour is modelled as substitution: a share of hours is filled at the full loaded wage multiplied by an agency rate, and the remainder at the permanent wage. A CMS five-star staffing rating is computed from RN and total nurse HPRD thresholds.
Operating costs, NOI and debt service
Operating costs are decomposed into property tax, utilities, repairs and maintenance, marketing, activities, housekeeping and general admin, each inflating with operating inflation. Insurance splits into property and casualty plus professional liability.
- EBITDARM subtracts revenue costs, staffing, food, marketing and move-in, facility opex and insurance. NOI further deducts management fee, maintenance capex reserve and triple-net rent, and is the basis for the DSCR covenant.
- During the initial interest-only period, NOI under-covers by design; later years target a higher coverage ratio. An Own versus Lease toggle gates the capital structure.
Cash sweep, returns and practical use
A stepped cash floor makes the cash sweep real. The effective reserve is the higher ramp-up reserve during lease-up and the minimum cash reserve once stabilised.
- Distributions equal any pre-distribution cash above that floor, so the returns stream reconciles to the cash flow statement, and closing cash never goes negative. The exit capitalises forward NOI at a multiple.
- The model reports levered IRR and MOIC against the actual equity check. A scenario toggle re-forecasts all three cases.
Users can explore occupancy ramp, care rates, payer mix, staffing hours and wage inflation as the most influential levers.
Formatted to IB standards
Named theme colors repaint the whole workbook in one click, on top of an investment-banking structure with clear input, output, and cross-sheet reference styling - brand-ready, institutional-grade, and fully auditable.
Created by ex-finance professionals
Hey, I’m Alex and I created Finamodel.
Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.
Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.
I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.
Having a template library on hand cuts a first build from hours to minutes.
Need help finding your model? You’ll find me in the Finamodel app!
Frequently asked
What is a senior living financial model?+
It is a model used to forecast revenue, staffing costs, and returns for senior housing facilities including independent living, assisted living, and memory care communities.
What should a senior living model include?+
It should include acuity-based revenue, census-linked staffing, entrance or community fee logic, lease-up modelling, and return metrics such as IRR and DSCR.
Who uses senior living models?+
Senior housing operators, developers, healthcare REITs, private equity firms, and lenders use them for underwriting, development feasibility, and performance reporting.
How does acuity affect the financial model?+
Higher-acuity residents in assisted living or memory care generate more revenue per unit but also require more staffing, so the resident mix directly affects both income and operating costs.
Can I model both rental and entrance fee structures?+
Yes. The model supports pure monthly rental communities as well as continuing care retirement communities (CCRCs) with upfront entrance fees and their associated amortisation.
Have more financial modelling questions? Contact us
Related templates
Hospital Operating Model
Operating model for hospital systems including inpatient/outpatient volumes, payer mix, DRG reimbursement, and staffing cost drivers.
Medical Device Financial Model
Revenue and profitability model for medical device companies including R&D, regulatory, manufacturing, and distribution.
Real Estate Development Pro Forma Model
Land cost, construction budget, lease assumptions, and project IRR for commercial and residential development.
Gym and Fitness Studio Operating Model
Operating model for fitness franchises and independent gyms including membership revenue, class scheduling, and facility utilization.
