When senior-housing occupancy improves faster than the labor model
This article works through a 180-unit senior-housing acquisition whose occupancy rises by 390 basis points while Year 1 NOI falls by $432,000. It follows the resident mix through care fees, staffing coverage, overtime and agency labor to show why seven additional occupied units reduce loan proceeds by $2.688 million.
An occupied unit is not a fixed revenue line with a fixed expense margin in senior housing. The same apartment can require a different staffing pattern after a new assessment, a transfer from independent to assisted living or a change in overnight support. The care fee and the labor schedule do not always change on the same date.
That is the issue here. Average occupancy increases from 152 to 159 units. Independent-living and low-support residents decline by ten, while high-support assisted-living and memory-care residents increase by sixteen. Revenue rises by $817,000. Direct labor, agency coverage, food and management fees increase operating expense by $1.249 million.
The following case is illustrative rather than client data. The community contains 60 independent living, 80 assisted-living and 40 memory-care units. The purchase price is $36 million. The senior loan is the lower of 60% LTV and a 12.5% minimum Year 1 debt yield, with interest-only debt service at 7.5%.
The acquisition case before the resident-file review
The initial case carries 152 average occupied units at 84.4% occupancy. Resident fees and services total $11.266 million. Direct labor is $4.400 million, contract labor is $280,000 and total property operating expense is $8.770 million. Year 1 NOI is $2.796 million.
The revised case uses the current resident census, assessment, service plan, billed care level and move-in date for each occupied unit. It then maps the resulting coverage requirements to the staffing grid, open positions, timecards and agency invoices.
Average occupancy increases to 88.3% and resident fees and services increase by $847,000. The higher-acuity mix requires more evening, overnight and two-person coverage than the initial staffing case. Year 1 NOI falls to $2.364 million.
Scroll to inspect →
| Underwriting line | Initial case | Resident-level case | Movement |
|---|---|---|---|
| Average occupied units | 152 | 159 | +7 |
| Average occupancy | 84.4% | 88.3% | +390 bps |
| Resident fees and services | $11.266M | $12.113M | +$0.847M |
| Property operating expenses | ($8.770M) | ($10.019M) | −$1.249M |
| Year 1 NOI | $2.796M | $2.364M | −$0.432M |
| Day-one loan proceeds | $21.600M | $18.912M | −$2.688M |
Rebuilding the occupied mix from resident assessments
The seven-unit occupancy gain contains a substantial mix change. Independent living falls from 52 to 48 occupied units. Low-support assisted living falls from 30 to 24. High-support assisted living rises from 14 to 22, and high-support memory care doubles from eight to sixteen.
Each resident is assigned the housing and care fee in the current agreement, assessment and notice file. The model does not apply a portfolio RevPOR increase to every occupied unit. A resident can require a higher support level before the related fee becomes billable, and a new move-in can receive a temporary housing concession while paying full care charges.
On that basis, resident fees and services are $12.113 million. The amount is $847,000 above the initial case, but it is attached to a materially different coverage requirement. The revenue file therefore determines which service plans must enter the staffing schedule.
Scroll to inspect →
| Resident type | Initial occupied units | Resident-level case | Revised monthly fee per occupied unit |
|---|---|---|---|
| Independent living | 52 | 48 | $4,750 |
| Assisted living — low support | 30 | 24 | $5,550 |
| Assisted living — medium support | 24 | 27 | $6,350 |
| Assisted living — high support | 14 | 22 | $7,300 |
| Memory care — standard support | 24 | 22 | $7,900 |
| Memory care — high support | 8 | 16 | $8,900 |
| Total occupied units | 152 | 159 | 88.3% occupancy |
Converting service plans into a staffed schedule
The staffing case is rebuilt by shift and care setting. Direct-care hours rise from 2.25 to 2.71 per occupied resident day. The schedule requires 72 care FTEs rather than 63 after adding evening and overnight coverage for the revised assisted-living and memory-care mix.
The payroll roster has twelve open care positions. Existing staff cover part of the gap through overtime; agency shifts increase from 14 to 41 per week. Direct labor rises by $650,000 and contract labor rises by $440,000 on the observed wage and invoice rates.
Those costs do not disappear because the annual plan contains a recruiting assumption. The base case phases a direct hire into the roster when the position is actually filled and removes the corresponding agency shift on the same date. Until then, the forecast carries the staffed coverage used to operate the current resident mix.
Scroll to inspect →
| Staffing measure | Initial case | Resident-level case | Underwriting effect |
|---|---|---|---|
| Direct-care hours per occupied resident day | 2.25 | 2.71 | Higher AL and memory-care support |
| Scheduled care FTEs | 63 | 72 | Added evening and overnight coverage |
| Open care positions | 5 | 12 | Unfilled roster covered by overtime and agency |
| Agency shifts per week | 14 | 41 | Annual contract labor rises by $0.440M |
| Overtime as a share of direct-care hours | 3.8% | 7.2% | Direct labor rises by $0.650M |
Carrying the resident mix into Year 1 NOI
Total property revenue increases from $11.566 million to $12.383 million. Community fees and other revenue fall by $30,000 because the revised move-in schedule contains more waived community fees, while the housing and care lines follow the resident-level schedule.
Direct and contract labor account for $1.090 million of the expense increase. Food rises by $120,000 with occupied resident days and service mix. The management fee increases by $41,000 on the larger revenue base. Other property expenses remain effectively unchanged.
Property operating expense reaches $10.019 million. NOI falls from $2.796 million to $2.364 million and the margin falls from 24.2% to 19.1%. The revised margin is a consequence of the current resident and labor files, not a margin assumption applied after the revenue forecast.
Scroll to inspect →
| Model line | Initial case | Resident-level case | Movement |
|---|---|---|---|
| Resident fees and services | $11.266M | $12.113M | +$0.847M |
| Community fees and other revenue | $0.300M | $0.270M | −$0.030M |
| Total property revenue | $11.566M | $12.383M | +$0.817M |
| Direct labor and related expense | ($4.400M) | ($5.050M) | −$0.650M |
| Contract labor | ($0.280M) | ($0.720M) | −$0.440M |
| Food | ($0.900M) | ($1.020M) | −$0.120M |
| Other property operating expenses | ($2.612M) | ($2.610M) | +$0.002M |
| Management fee | ($0.578M) | ($0.619M) | −$0.041M |
| Year 1 NOI | $2.796M | $2.364M | −$0.432M |
Carrying the staffing case into debt and equity
At the $36 million purchase price, the initial NOI produces a 7.77% going-in yield. The $21.6 million loan is constrained by 60% LTV and opens at a 12.94% debt yield, above the 12.5% minimum.
The resident-level NOI produces a 6.57% yield. At 60% LTV, debt yield falls to 10.94%. The debt-yield constraint sizes proceeds at $18.912 million, $2.688 million below the initial case. Required purchase-price equity increases from $14.400 million to $17.088 million.
The direct-hire case fills nine open positions over six months and removes the corresponding agency schedule, restoring $420,000 of NOI. The current-care-pricing case bills completed assessments after the applicable notice periods. The agency downside leaves the open positions in place and carries the higher coverage cost through the forecast year.
Scroll to inspect →
| Model output | Initial case | Resident-level case | Movement |
|---|---|---|---|
| Year 1 NOI | $2.796M | $2.364M | −$0.432M |
| Going-in NOI yield | 7.77% | 6.57% | −120 bps |
| Debt yield at 60% LTV | 12.94% | 10.94% | −200 bps |
| Day-one loan proceeds | $21.600M | $18.912M | −$2.688M |
| Interest-only DSCR after sizing | 1.73× | 1.67× | −0.06× |
| Purchase-price equity | $14.400M | $17.088M | +$2.688M |
Scroll to inspect →
| Operating case | Treatment | Occupancy | Operating expense | Year 1 NOI | Loan |
|---|---|---|---|---|---|
| Resident-level base | Current resident mix, open positions, overtime and agency schedule | 88.3% | $10.019M | $2.364M | $18.912M |
| Direct-hire recovery | Fill nine open care positions and reduce agency shifts over six months | 88.3% | $9.599M | $2.784M | $21.600M |
| Current care pricing | Bill current assessed care levels at scheduled rates after notice periods | 88.3% | $10.031M | $2.592M | $20.736M |
| Agency downside | Open positions persist and agency coverage rises through the forecast year | 88.3% | $10.550M | $1.833M | $14.664M |
Reworking the case in Cap Orbit
Cap Orbit can work across the daily census, resident agreements, fee schedules, assessments, service plans, change notices, staffing grid, employee roster, open positions, timecards, agency invoices, food-service records, management agreement, debt quote and existing acquisition model in the same deal. Each occupied unit can be tied to its current fees and required coverage.
Scroll to inspect →
| Current source | Model treatment |
|---|---|
| Resident census and daily occupancy file | Occupied unit, move-in date and care setting established |
| Resident agreements and fee schedules | Housing, care, community and ancillary charges assigned by resident |
| Assessments, service plans and change notices | Current support requirements reconciled to billed care level and effective date |
| Staffing grid, timecards and open-position report | Required coverage, overtime and direct labor rebuilt by shift |
| Agency invoices and food-service records | Contract labor and variable resident cost carried at observed usage |
| Management agreement, debt quote and acquisition model | Fees and revised NOI carried through debt yield, proceeds and equity |
From there, you can have Cap Orbit rebuild resident fees by effective date, identify service-plan changes that have not reached billing, translate the resident mix into a shift-level staffing schedule and update direct labor, overtime, agency, food, management fees, NOI, debt and equity in the existing model.
The same deal record supports the operating cases that matter here: fill open positions on a specific schedule, change agency coverage as hires arrive, bill assessed care after notice or carry vacancies in selected care settings. Each case returns the same connected outputs—resident mix, billed fees, staffed hours, labor cost, NOI, debt and equity.
The standard for AI on this asset class is a resident-level operating case in which occupancy, care revenue and staffed coverage resolve into the same Year 1 NOI and capital requirement.