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.
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.
Scroll to inspect →
| Underwriting line | Preleasing case | Move-in case | Movement |
|---|---|---|---|
| Reported beds | 1,181 | 1,136 | −45 |
| Reported occupancy | 95.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.
Scroll to inspect →
| June 30 status | Preleasing report | Underwriting treatment |
|---|---|---|
| Resident and guarantor complete | 1,126 beds | Contracted, subject to first-installment collection |
| Resident-signed; guaranty or deposit outstanding | 24 beds | Remaining leaseup until requirement is satisfied |
| Approved application; resident signature outstanding | 31 beds | Remaining leaseup until lease execution |
| Total reported preleasing | 1,181 beds | 1,126 contracted at the cutoff |
| First-installment defaults after cutoff | Not reflected | 18 beds removed |
| Late conversions and new leases before move-in | Not reflected | 28 beds added |
| Move-in case | — | 1,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.
Scroll to inspect →
| Floor plan | Move-in beds | Scheduled rent | Concessions | Effective bed rent |
|---|---|---|---|---|
| Studio and one-bedroom | 140 | $1.670M | ($0.070M) | $1.600M |
| Two-bedroom | 340 | $3.440M | ($0.100M) | $3.340M |
| Four-bedroom | 656 | $6.820M | ($0.140M) | $6.680M |
| Total | 1,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.
Scroll to inspect →
| Model line | Preleasing case | Move-in case | Movement |
|---|---|---|---|
| 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.
Scroll to inspect →
| Model output | Preleasing case | Move-in case | Movement |
|---|---|---|---|
| Year 1 NOI | $7.830M | $7.120M | −$0.710M |
| Going-in NOI yield | 7.83% | 7.12% | −71 bps |
| Debt yield at 60% LTV | 13.05% | 11.87% | −118 bps |
| Day-one loan proceeds | $60.000M | $54.769M | −$5.231M |
| Interest-only DSCR after sizing | 1.86× | 1.86× | — |
| Purchase-price equity | $40.000M | $45.231M | +$5.231M |
Scroll to inspect →
| Leaseup case | Treatment | Move-in beds | Effective bed rent | Year 1 NOI | Loan |
|---|---|---|---|---|---|
| Verified move-in | Executed leases and first-installment status through move-in | 1,136 | $11.620M | $7.120M | $54.769M |
| Fill 24 beds | One installment free on remaining two- and four-bedroom inventory | 1,160 | $11.840M | $7.320M | $56.308M |
| Reach reported count | Fill to 1,181 beds with deeper late-cycle concessions | 1,181 | $11.980M | $7.440M | $57.231M |
| Late-leaseup downside | Twenty-six further losses without replacement before move-in | 1,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.
Scroll to inspect →
| Current source | Model treatment |
|---|---|
| Dated preleasing report and leasing definitions | Headline count separated into applications, signatures and completed leases |
| Resident lease, guaranty and deposit records | Contracted bed, installment schedule and support status established |
| Floor-plan inventory and bed assignments | Leased beds matched to rentable beds, unit type and assigned rate |
| Concession addenda and leasing ledger | Free installments and recurring discounts applied to the correct lease |
| First-installment, cancellation and move-in files | Post-cutoff failures and late conversions carried into the move-in case |
| Debt quote and acquisition workbook | Effective 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.