Preparing a student-housing leasing calendar for a debt request
A practical guide for commercial real estate sponsors to build a leasing calendar that shows lenders how student-housing cash flow aligns with the academic year, with a concrete evidence checklist and worksheet.
A practical guide for commercial real estate sponsors to build a leasing calendar that shows lenders how student-housing cash flow aligns with the academic year, with a concrete evidence checklist and worksheet.
Why a leasing calendar matters for student-housing debt
Student housing has a cash-flow pattern tied to the academic calendar, not the calendar year. Lenders use the leasing calendar to see when rents are collected, when vacancies spike between terms, and how the property covers debt service during low-income months. The OCC Commercial Real Estate Lending handbook notes that properties with volatile cash flows may warrant a higher debt yield [1]. A well-prepared leasing calendar helps you show the lender how you manage that volatility.
What a student-housing leasing calendar should include
Include these elements: - Lease start and end dates by unit or bed, tied to the academic term - Rent collection months – when each lease's rent is due and paid - Vacancy periods – weeks or months between lease terms when units are empty - Renewal rates – the percentage of existing tenants you expect to renew - Pre-leasing activity – leases signed before the term starts, with a target percentage - Security deposits and fees – when these are collected and whether they are refundable or applied to rent
How to build the calendar
- Record your lease inventory. List every unit or bed, its current lease term, rent amount, and move-in/move-out date.
- Identify term breaks. Mark the months when most leases end and new ones begin – typically May/June and August/September.
- Estimate renewals. Use your property's historical renewal rate from the T-12 or your own records. If you do not have a rate, ask the actual lender what they consider reasonable for student housing in your market.
- Project pre-leasing. Lenders want to see that you have a plan to fill units before the term starts. Record your target pre-leasing percentage for each term.
- Calculate monthly gross rent. Multiply the number of leased units each month by the monthly rent. This gives you a month-by-month income projection.
- Add collected income. Gross rent is not the same as collected income. Subtract expected delinquencies and late payments. Lenders will compare your collected income to your debt obligations.
- Show debt service coverage. For each month, subtract your operating expenses and debt service from collected income. The result is your equity cash flow. If any month shows negative cash flow, explain how you will cover the shortfall (e.g., reserves, parent guarantees, or a line of credit).
Evidence checklist for your debt request
Include these documents with your leasing calendar: - Current rent roll – a snapshot of all current leases, including move-in dates, rent, and lease end dates - T-12 operating statement – the trailing twelve months of income and expenses, broken out by month - Lease form – the standard lease agreement you use, so the lender can see key terms like lease duration, renewal options, and late fees - Pre-leasing report – a summary of leases signed for upcoming terms, with a comparison to your target - Renewal history – a record of renewal rates for the past two to three years - Budget for capital expenditures – any planned improvements to units or common areas that could affect leasing - Property management agreement – if you use a third-party manager, include the agreement so the lender can evaluate their leasing process
How lenders use the calendar in underwriting
Lenders use the leasing calendar to: - Calculate debt yield. Debt yield is NOI divided by loan amount [1]. Lenders may apply a stressed debt yield using normalized or higher-rate levels to test the loan's viability in a rising-rate environment [1]. Your calendar helps them see whether NOI is sustainable. - Assess cash-flow volatility. A leasing calendar showing periods of negative cash flow may lead the lender to scrutinize the property's ability to service debt year-round. - Evaluate the business plan. A strong pre-leasing target and a realistic renewal rate show the lender you understand the property's market. - Determine loan structure. The calendar may influence whether the loan is structured as a bridge loan (for properties in transition) or a permanent loan (for stabilized properties).
Suggested worksheet: monthly cash-flow projection
Create a table with these columns for each month of the academic year: - Month - Projected gross rent (from leasing calendar) - Less: vacancy allowance (from calendar's vacancy periods) - Less: bad debt/delinquency allowance - Equals: collected income - Less: operating expenses (from T-12 or budget) - Equals: NOI - Less: debt service (principal and interest) - Equals: equity cash flow
For any month where equity cash flow is negative, add a note explaining the source of funds to cover the shortfall.
How far in advance should I prepare the leasing calendar?
Prepare the calendar at least 90 days before the start of the next academic term. Lenders need time to review the calendar and incorporate it into their underwriting. If you are requesting a loan for an acquisition, prepare the calendar as part of the loan request package.
Should I include summer months if the property is primarily leased on a 9-month academic schedule?
Yes. Include summer months even if occupancy drops to zero. Lenders need to see the full cash-flow picture to assess the property's ability to cover debt service year-round. If you have summer programs or short-term rentals, include those as well.
Does the leasing calendar replace the rent roll and T-12?
No. The leasing calendar supplements the rent roll and T-12. The rent roll provides a current snapshot; the T-12 provides historical context. The leasing calendar projects future income. Lenders expect all three documents as part of a complete loan request.
We prepare the loan request, choose lenders suited to the property and plan, and negotiate terms through closing. Send us the property, the business plan, and the amount and timing you need. We will tell you how we would approach it.
Run the numbers on your deal
Try your own NOI, value and lender tests to see which one limits the loan: DSCR, LTV or debt yield.
Talk through your financing
Working on a real property? Send us the deal and a financing advisor will review it and get back to you. It costs nothing to ask and does not commit you to anything.
Requests are reviewed by Wraith Real Estate, a commercial real estate debt advisor (not a lender).