# Senior Living Model Build a senior living model for independent living, assisted living, and memory care facilities with tiered care-level revenue, staffing models linked to resident census, and investor return outputs. - Canonical: https://finamodel.com/templates/senior-living-model - Excel download: https://finamodel.com/templates/senior-living.xlsx - Category: Healthcare - Model type: Underwriting - Difficulty: Intermediate - Audiences: Developers & sponsors, CFOs & FP&A, Operators, Healthcare investors, Facility managers, PE sponsors - Tags: senior-care, staffing, occupancy, ebitda ## Overview 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's included - 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 - Labor staffing ratios and wage assumptions by acuity - Operating expenses (food, utilities, supplies, insurance) - EBITDA margin analysis and cash flow sensitivity ## 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. ## Built for senior housing economics Use this model when you need to forecast revenue, staffing, and returns for a senior living facility where resident acuity, census, and care levels drive the financial outcome. ## Handles the complexity of care-level transitions A useful senior living model should show how resident mix changes between independent living, assisted living, and memory care affect revenue, costs, and staffing requirements. ## Better than a generic real estate template This gives you a purpose-built framework for senior housing that accounts for care-level economics, occupancy-driven variable costs, and entrance fee structures. ## Built for senior housing economics Use this model when you need to forecast revenue, staffing, and returns for a senior living facility where resident acuity, census, and care levels drive the financial outcome. ## Handles the complexity of care-level transitions A useful senior living model should show how resident mix changes between independent living, assisted living, and memory care affect revenue, costs, and staffing requirements. ## Better than a generic real estate template This gives you a purpose-built framework for senior housing that accounts for care-level economics, occupancy-driven variable costs, and entrance fee structures. ## Features - **Care level and acuity modeling:** Model distinct economics for independent, assisted, and memory care units, accounting for different staffing ratios and service requirements. - **Census and admission/discharge dynamics:** Project occupancy by modeling admission rates, length of stay, and discharge patterns to forecast revenue stability. - **Staffing and labor cost drivers:** Model nursing, care aides, dietary, and administrative staff separately with acuity-driven ratios to capture true cost structure. ## Use cases - **Facility acquisition and valuation:** Underwrite acquisitions by modeling occupancy ramp-up, acuity mix stabilization, and operational leverage as scale grows. - **Expansion and new community development:** Evaluate new community development vs. acquisition by comparing development cost, pre-opening burn, and ramp-up timeline. - **Operational improvement planning:** Model the impact of staffing efficiency, acuity mix shift, and rate increases on EBITDA margin. ## Frequently asked questions ### 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. ## Related templates - [Hospital Operating Model](https://finamodel.com/templates/hospital-model) - [Medical Device Financial Model](https://finamodel.com/templates/medtech-model) - [Real Estate Development Pro Forma Model](https://finamodel.com/templates/real-estate-model)