The standard for AI in student-housing acquisitions

When student-housing preleasing outruns executed rent

This article works through a 1,240-bed acquisition whose June preleasing report shows 95.2% committed. It follows those beds through lease execution, guaranty requirements, first-installment collection and concessions to show how the same report becomes 91.6% at move-in—and reduces loan proceeds by $5.231 million.

Student-housing acquisitionsWorked re-underwrite15 minute read

A preleasing percentage can be accurate under the operator's definition and still be unusable as contracted revenue. An approved application, a resident-signed lease awaiting a guarantor and a lease with its first installment collected may all sit in the same headline count. They do not carry the same probability or the same rent into the academic year.

That is the issue here. The June 30 report counts 1,181 beds. The supporting file contains 1,126 leases with the resident and guarantor requirements complete, 24 resident-signed leases with a guaranty or deposit outstanding and 31 approved applications without a resident signature. By move-in, late conversions add 28 beds and first-installment defaults remove 18, leaving 1,136.

The following case is illustrative rather than client data. The property has 1,240 rentable beds and a $100 million purchase price. The senior loan is the lower of 60% LTV and a 13.0% minimum Year 1 debt yield, with interest-only debt service at 7.0%. The academic-year case uses twelve equal installments and a two-week August turn.

The acquisition case at the June reporting cutoff

The initial case reads all 1,181 reported beds as contracted and carries the scheduled lease installments by floor plan. That produces 95.2% occupancy, $12.400 million of scheduled annual bed rent and $120,000 of concessions.

The move-in case replaces the single count with the status of each bed at the cutoff and the activity that follows it. It removes incomplete lease packages from contracted rent, adds the late leases that actually complete, removes first-installment defaults and applies the concession attached to each surviving lease.

The result is not merely 45 fewer beds. Scheduled bed rent falls by $470,000 and concessions increase by $190,000 because late-cycle leases are more heavily promoted. Effective bed rent is $660,000 below the preleasing case.

Case at move-in

Scroll to inspect →

Underwriting linePreleasing caseMove-in caseMovement
Reported beds1,1811,136−45
Reported occupancy95.2%91.6%−360 bps
Scheduled annual bed rent$12.400M$11.930M−$0.470M
Concessions($0.120M)($0.310M)−$0.190M
Year 1 NOI$7.830M$7.120M−$0.710M
Day-one loan proceeds$60.000M$54.769M−$5.231M

Converting the preleasing report into contracted beds

The June report is reconciled to resident signatures, guaranties, deposit alternatives and bed assignments. The 1,126 completed packages enter contracted rent. The 55 incomplete records remain in the leaseup schedule with their current status; they do not receive the economics of an executed lease merely because they appear in the headline.

The reconciliation continues after the cutoff. Eighteen completed leases fail to make the first installment and are cancelled under the property process. Twelve of the resident-signed files, six approved applications and ten new prospects complete before move-in. That produces 1,136 move-in beds.

A later leasing report can still show velocity without rewriting the June underwriting record. Each added bed carries its actual execution date, floor plan, installment amount and promotion. Each lost bed carries the cancellation date and the rent removed from the academic-year case.

Bed-status reconciliation

Scroll to inspect →

June 30 statusPreleasing reportUnderwriting treatment
Resident and guarantor complete1,126 bedsContracted, subject to first-installment collection
Resident-signed; guaranty or deposit outstanding24 bedsRemaining leaseup until requirement is satisfied
Approved application; resident signature outstanding31 bedsRemaining leaseup until lease execution
Total reported preleasing1,181 beds1,126 contracted at the cutoff
First-installment defaults after cutoffNot reflected18 beds removed
Late conversions and new leases before move-inNot reflected28 beds added
Move-in case1,136 beds

Rebuilding effective rent by lease and floor plan

The 1,136 beds are then grouped by assigned floor plan without replacing lease-level economics with an average asking rate. Studio and one-bedroom leases contribute $1.670 million of scheduled rent; two-bedroom leases contribute $3.440 million; four-bedroom leases contribute $6.820 million.

Concessions are read from the lease and addendum. A free installment reduces the annual contract value by that installment even though the resident occupies the bed for the full term. A recurring monthly discount remains in every applicable installment. The revised case contains $310,000 of concessions rather than the $120,000 carried in the June case.

The floor-plan view matters because the remaining vacancy is not evenly distributed. A leaseup assumption for a four-bedroom bed uses the available four-bedroom inventory, its current rate and its current promotion. It does not use the average achieved rent on the studio inventory that filled earlier in the cycle.

Move-in rent by floor plan

Scroll to inspect →

Floor planMove-in bedsScheduled rentConcessionsEffective bed rent
Studio and one-bedroom140$1.670M($0.070M)$1.600M
Two-bedroom340$3.440M($0.100M)$3.340M
Four-bedroom656$6.820M($0.140M)$6.680M
Total1,136$11.930M($0.310M)$11.620M

Carrying the academic-year file into Year 1 NOI

The twelve installments are placed in the months required by each lease rather than converted to a daily rent across the physical occupancy period. The August turn remains outside resident occupancy even though annual rent is paid in equal installments. Late leases begin on their actual contract date and do not receive revenue for a prior vacant installment.

Effective bed rent falls from $12.280 million to $11.620 million. Parking, utility reimbursements and other resident revenue falls by another $50,000 because the charges are attached to occupied beds and selected lease packages rather than applied at a fixed percentage of rent.

Total operating expense remains $5.000 million. Lower occupied-bed utilities and payment costs offset higher late-cycle marketing and turn labor in this case; property taxes, payroll, security, internet and most contract services do not move with 45 beds. Year 1 NOI falls from $7.830 million to $7.120 million.

Year 1 revenue and NOI reconciliation

Scroll to inspect →

Model linePreleasing caseMove-in caseMovement
Scheduled annual bed rent$12.400M$11.930M−$0.470M
Concessions($0.120M)($0.310M)−$0.190M
Effective bed rent$12.280M$11.620M−$0.660M
Parking, utility reimbursements and other revenue$0.550M$0.500M−$0.050M
Total property revenue$12.830M$12.120M−$0.710M
Operating expenses including turn($5.000M)($5.000M)
Year 1 NOI$7.830M$7.120M−$0.710M

Carrying move-in rent into debt and equity

At the $100 million purchase price, the preleasing NOI produces a 7.83% going-in yield. The $60 million loan is constrained by 60% LTV and opens at a 13.05% debt yield, just above the 13.0% minimum.

The move-in NOI produces a 7.12% yield. At 60% LTV, debt yield falls to 11.87%. The debt-yield constraint sizes proceeds at $54.769 million, $5.231 million below the preleasing case. Required purchase-price equity increases from $40.000 million to $45.231 million.

The remaining beds can still be leased before or after move-in, but the treatment must specify the floor plan, start installment and concession required. Filling 24 beds with one installment free does not produce the same annual rent as the 24 beds in the original June count. Reaching 1,181 beds with deeper late-cycle concessions recovers occupancy without recovering the original effective rent.

Capital effects at the same purchase price

Scroll to inspect →

Model outputPreleasing caseMove-in caseMovement
Year 1 NOI$7.830M$7.120M−$0.710M
Going-in NOI yield7.83%7.12%−71 bps
Debt yield at 60% LTV13.05%11.87%−118 bps
Day-one loan proceeds$60.000M$54.769M−$5.231M
Interest-only DSCR after sizing1.86×1.86×
Purchase-price equity$40.000M$45.231M+$5.231M
Alternate late-leaseup treatments

Scroll to inspect →

Leaseup caseTreatmentMove-in bedsEffective bed rentYear 1 NOILoan
Verified move-inExecuted leases and first-installment status through move-in1,136$11.620M$7.120M$54.769M
Fill 24 bedsOne installment free on remaining two- and four-bedroom inventory1,160$11.840M$7.320M$56.308M
Reach reported countFill to 1,181 beds with deeper late-cycle concessions1,181$11.980M$7.440M$57.231M
Late-leaseup downsideTwenty-six further losses without replacement before move-in1,110$11.320M$6.860M$52.769M

Reworking the case in Cap Orbit

Cap Orbit can work across the dated preleasing reports, leasing definitions, resident leases, guaranties, deposit records, bed assignments, floor-plan inventory, concession addenda, first-installment file, cancellations, move-in report, debt quote and existing acquisition workbook in the same deal. Every reported bed can be resolved to its current lease status and assigned economics.

Source-to-model reconciliation

Scroll to inspect →

Current sourceModel treatment
Dated preleasing report and leasing definitionsHeadline count separated into applications, signatures and completed leases
Resident lease, guaranty and deposit recordsContracted bed, installment schedule and support status established
Floor-plan inventory and bed assignmentsLeased beds matched to rentable beds, unit type and assigned rate
Concession addenda and leasing ledgerFree installments and recurring discounts applied to the correct lease
First-installment, cancellation and move-in filesPost-cutoff failures and late conversions carried into the move-in case
Debt quote and acquisition workbookEffective bed rent carried through NOI, debt yield, proceeds and equity

From there, you can have Cap Orbit rebuild the move-in case by bed, apply the correct installment schedule and concession, map occupied beds to parking and utility charges and update the existing model through revenue, turn, NOI, debt yield, proceeds and equity. The June report remains the June report; the underwriting changes when the underlying bed changes status.

The same deal record supports the late-cycle cases that matter here: fill selected floor plans with one installment free, deepen concessions to reach the reported bed count, carry a delayed start date or hold remaining beds vacant. Each case returns the same connected outputs—executed beds, move-in occupancy, scheduled rent, concessions, effective rent, NOI, debt and equity.

The standard for AI on this asset class is an acquisition case in which every reported bed resolves to an executable lease, a floor plan, an installment schedule, a concession and the capital supported by the resulting rent.