Senior Living / CCRC Village Development Financial Model

Description

The CCRC village development model captures the full continuum of care—independent living, assisted living, memory care, and skilled nursing—within a single integrated campus. It accommodates phased construction, allowing investors to model sequential openings, lease-up, and stabilization across multiple buildings and levels of care. The financial framework reflects the unique interplay between real estate development, healthcare services, and hospitality operations.

One of the model’s central features is the entrance fee revenue stream, which is modeled with flexible refund provisions (non-refundable, partially refundable declining balance, or fully refundable). Monthly service fees and ancillary revenues are projected for each care segment, with escalation tied to contract terms and CPI indices. The model also tracks resident turnover, mortality, and transfers between care levels, ensuring accurate timing of entrance fee refunds and re-issuances.

On the operating side, staffing is driven by resident acuity, census, and regulatory minimums for each care line. Expenses are built up from detailed assumptions for labor, food service, medical supplies, housekeeping, and administrative overhead, with distinct cost structures for residential and healthcare units. The model generates a unit-level P&L and consolidates into a single entity view.

The financing module handles development-phase equity, construction loans, mini-perm and permanent debt, as well as reservation deposits. Interest during construction is capitalized and draws are scheduled against project milestones. A waterfall structure allocates cash flows and returns to different capital layers, and the exit valuation is based on stabilized NOI with adjustments for entrance fee liabilities.

Built-in scenario manager and sensitivity tables allow stress-testing on key variables such as occupancy ramp speed, entrance fee pricing, construction cost overruns, and care utilization mix. The model provides a clear view of cash breakeven points, minimum occupancy thresholds, and the impact of refinancing or selling the asset.

Modeling specifics

• Independent living unit-level occupancy ramp with distinct absorption profiles for studios, one-bedroom, and two-bedroom apartments.
• Entrance fee modeling: amortization schedules, refund liability balance (refundable and non-refundable portions), and recurring fee re-issuance upon resident turnover.
• Multi-level care demand modeling: transitions between IL→AL→SNF/MC driven by utilization rates and length-of-stay assumptions.
• Staffing module with labor cost drivers based on resident days by care level, acuity adjustment factors, and regulatory ratios (e.g., nursing hours per resident day).
• Phased construction sequencing with milestone-based equity calls and loan draws, automatic capitalization of interest during construction, and asset placing in service.
• Waterfall cash flow distribution: operating cash flow before debt, mandatory debt service, reserve funding, and investor distributions with LP/GP splits.
• Exit valuation via direct capitalization of stabilized NOI, with explicit deduction of outstanding entrance fee refund obligations to reflect true equity value.
• Scenario manager covering key value levers: initial entrance fee levels, occupancy ramp duration, construction cost overrun, and care level mix shifts.
• Integration of ancillary services (rehabilitation therapy, dialysis, pharmacy, dining) with demand linked to resident population and care level.

What's included in the base version

• Integrated monthly P&L, Cash Flow, and Balance Sheet (15-year projection)
• Detailed construction budget & capex phasing schedule with drawdown mechanics
• Unit-mix and multi-level absorption model (IL, AL, MC, SNF)
• Entrance fee revenue & refund liability schedule (turnover-based)
• Staffing & operating expense build-up by care segment
• Monthly service fee & ancillary revenue projection (rehab, dining, etc.)
• Debt schedule with multiple tranches and interest during construction
• Stabilized NOI calculation & cap-rate exit valuation
• Scenario manager & sensitivity tables on key business drivers
• Executive dashboard with KPIs: occupancy, NOI, cash-on-cash, levered IRR

Common modeling mistakes

• Assuming all independent living units achieve equal occupancy rates from day one — overstates early entrance fee and monthly fee revenue by 10–20% due to varying desirability of unit types.
• Treating entrance fee refund liabilities as equity rather than a future cash outflow — inflates net asset value by 30–60% and masks liquidity risk at exit.
• Using the same expense growth rate for skilled nursing and independent living — distorts operating margin by 4–7 percentage points because healthcare labor costs escalate faster than general inflation.
• Ignoring the licensing and survey ramp-up for skilled nursing beds — leads to overestimation of first-year skilled nursing revenue by 15–25%.
• Capitalizing all pre-opening marketing and staffing costs without splitting into operating expenses — artificially boosts project IRR by 2–4% by transferring operating losses to the balance sheet.
• Overlooking resident turnover and mortality in entrance fee re-issuance modeling — understates future entrance fee revenue by 15–30% in the long-term plan.