Operating evidence and financing
What this package helps you examine
Student housing turns an academic calendar into a cash-flow and execution calendar. A strong preleasing percentage is not enough unless signed contracts, collections, turnover readiness and financing dates align. Prepare the evidence by bed and lease period, while keeping property units and program classifications distinct.
Reconcile beds, units and leases
Identify rentable beds, legal units, by-bed leases, whole-unit leases and any master lease. Report preleasing on a clearly stated denominator and date. Distinguish applications, signed leases, deposits, guaranties and cash collections. A canceled or contingent contract is not the same as a paying resident, and a bed-level occupancy metric should not be silently converted into a unit-level program test.
Model the academic-year cash pattern
Map lease commencement, payment installments, summer occupancy and concessions to the actual calendar. Schedule the concentrated turnover period, cleaning, repairs, furniture and marketing costs before the next rent cycle. Annual income may look adequate while the turnover month requires a material cash advance. Maintain a case for delayed opening or weaker final leasing without assuming all vacant beds fill at the start of term.
Document demand and execution fit
Support the demand case with relevant institution, enrollment, transportation and competing-supply evidence rather than relying on a nearby campus name. Fannie Mae distinguishes student-housing categories and additional documentation in its program materials; the model does not determine that classification. Confirm current program criteria, actual operating history and lender acceptance before using a student-housing execution in the funding plan.
Use the workbook
- Use Assumptions!D5 for Base (1) or Downside (2), and the labeled scenario input rows. Enter source data in Academic Leasing!D10:L21; preserve formula cells and an untouched workbook copy.
- The example uses the summer paying fraction in May-July and the academic fraction in other months; this is an illustrative calendar. Turn concessions and physical turn costs are separate. Reconcile the bed/unit denominator and actual collection periods.
- Reconcile Operations to Summary. Apply the entered lender adjustment separately to the modeled cash flow. Sizing uses amortizing debt service, while first-year payments reflect the entered interest-only period.
- In Assumptions, replace illustrative value, LTV, DSCR, debt yield, rate, amortization and requested ceiling with the intended scenario. Review capacities in Debt and Funding. The smallest modeled capacity does not establish eligibility or approval.
- Closing equity includes the entered opening cash and restricted reserves. Additional operating cash need is measured after that opening cash, so do not add it twice. Inspect monthly cash and remaining principal at maturity.
- Read Review for model conventions and limitations. Save each scenario with its supporting evidence and date; actual lender definitions, legal rights and professional findings control the transaction.
Questions to prepare for a lender
What does the preleasing percentage actually count?
Dated bed and unit inventory, signed lease register and cancellations.
When do signed leases produce collected cash?
Lease installment schedules, deposits, guaranties and collection history.
What must be completed before move-in?
Turnover work plan, vendor commitments and readiness checklist.
How dependent is demand on a specific institution?
Relevant enrollment, campus access and competing-supply evidence.
What happens if the leasing cycle misses its target?
Delayed occupancy, concession and turnover-cash scenario.
Which program classification applies?
Lender review of current rules, property facts and operating history.
03 / Prepare
Build the evidence file
Use this as a preparation checklist. The lender determines the documents, definitions and review conditions for the actual transaction.
Cash flow and operations
- Bed and unit roll with lease type and occupancy definitions.
- Executed leases, guaranties, deposits and payment schedules.
- Preleasing history, cancellations and conversion to actual collections.
- Monthly operating statements organized around the academic cycle.
- Turnover, furniture, cleaning and repair costs by timing.
- Marketing, utility and management expenses with contract support.
Property and collateral
- Plans and legal unit/bed inventory with actual-use evidence.
- Condition assessment and concentrated turnover work scope.
- Furniture and equipment ownership and replacement schedule.
- Transportation/access evidence used in the demand or program case.
- Environmental and other required third-party reports.
- Construction or major renovation readiness evidence where applicable.
Sponsor and execution
- Sponsor and manager experience with academic-year leasing and turnover.
- Ownership, borrowing authority and guarantor documents.
- Liquidity after other academic-cycle and portfolio commitments.
- Turnover vendor capacity and contingency arrangements.
- Portfolio debt and guarantees relevant to available support.
- Equity authorization for delayed leasing or move-in.
Closing and funding
- Written lender classification and required documentation list.
- Closing schedule aligned with leasing, turnover and move-in milestones.
- Reserve and holdback conditions with acceptable readiness evidence.
- Insurance, title and payoff requirements.
- Material management or institutional agreement consents.
- Dated funding plan through the lowest-cash point of the school-year cycle.
Watch for these assumptions
- An application or deposit is not automatically a signed, collectible lease.
- A by-bed occupancy percentage is not interchangeable with a unit-based eligibility test.
- Do not spread concentrated turnover spending evenly when cash is due before move-in.
- A missed academic leasing window can alter the timing of recovery, not merely the annual occupancy average.
Before you rely on the result
- State the denominator and date on every leasing statistic.
- Fund turnover before counting the next semester's collections.
- Confirm the selected program using current criteria and actual property history.
Scope and limitations
- Educational analysis; not a financing offer, appraisal, legal opinion or program eligibility determination.
- Workbook figures and thresholds are illustrative editable assumptions, not current lender quotes or universal underwriting standards.
- Document requests depend on the lender, transaction, jurisdiction and property; address unresolved issues with the relevant qualified professional.
Sources and applicability
These references support the stated asset and risk context. The questions and document lists are preparation tools, not a statement that every lender requires or accepts the same package. Actual contracts, applicable rules and the chosen lender determine the transaction requirements.
- Fannie Mae — Student HousingFrequently Asked Questions: property types, documentation and operating history · Checked 2026-10-21Source-specific context; numerical examples and decision workflow are original hypothetical analysis.