The standard for AI in senior-housing acquisitions

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.

Senior-housing acquisitionsWorked re-underwrite15 minute read

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.

Case after the resident-file review

Scroll to inspect →

Underwriting lineInitial caseResident-level caseMovement
Average occupied units152159+7
Average occupancy84.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.

Average occupied units by resident support level

Scroll to inspect →

Resident typeInitial occupied unitsResident-level caseRevised monthly fee per occupied unit
Independent living5248$4,750
Assisted living — low support3024$5,550
Assisted living — medium support2427$6,350
Assisted living — high support1422$7,300
Memory care — standard support2422$7,900
Memory care — high support816$8,900
Total occupied units15215988.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.

Care-staffing reconciliation

Scroll to inspect →

Staffing measureInitial caseResident-level caseUnderwriting effect
Direct-care hours per occupied resident day2.252.71Higher AL and memory-care support
Scheduled care FTEs6372Added evening and overnight coverage
Open care positions512Unfilled roster covered by overtime and agency
Agency shifts per week1441Annual contract labor rises by $0.440M
Overtime as a share of direct-care hours3.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.

Year 1 revenue and NOI reconciliation

Scroll to inspect →

Model lineInitial caseResident-level caseMovement
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.

Capital effects at the same purchase price

Scroll to inspect →

Model outputInitial caseResident-level caseMovement
Year 1 NOI$2.796M$2.364M−$0.432M
Going-in NOI yield7.77%6.57%−120 bps
Debt yield at 60% LTV12.94%10.94%−200 bps
Day-one loan proceeds$21.600M$18.912M−$2.688M
Interest-only DSCR after sizing1.73×1.67×−0.06×
Purchase-price equity$14.400M$17.088M+$2.688M
Alternate operating treatments

Scroll to inspect →

Operating caseTreatmentOccupancyOperating expenseYear 1 NOILoan
Resident-level baseCurrent resident mix, open positions, overtime and agency schedule88.3%$10.019M$2.364M$18.912M
Direct-hire recoveryFill nine open care positions and reduce agency shifts over six months88.3%$9.599M$2.784M$21.600M
Current care pricingBill current assessed care levels at scheduled rates after notice periods88.3%$10.031M$2.592M$20.736M
Agency downsideOpen positions persist and agency coverage rises through the forecast year88.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.

Source-to-model reconciliation

Scroll to inspect →

Current sourceModel treatment
Resident census and daily occupancy fileOccupied unit, move-in date and care setting established
Resident agreements and fee schedulesHousing, care, community and ancillary charges assigned by resident
Assessments, service plans and change noticesCurrent support requirements reconciled to billed care level and effective date
Staffing grid, timecards and open-position reportRequired coverage, overtime and direct labor rebuilt by shift
Agency invoices and food-service recordsContract labor and variable resident cost carried at observed usage
Management agreement, debt quote and acquisition modelFees 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.