Lease expiration schedules for an apartment refinance package
A lease expiration schedule is more than a list of dates—it is a tool that shows lenders how stable your property's income is. This guide explains what to include, how to prepare it, and how it affects the financing discussion.
A lease expiration schedule is more than a list of dates—it is a tool that shows lenders how stable your property's income is. This guide explains what to include, how to prepare it, and how it affects the financing discussion.
What a lease expiration schedule shows a lender
A lease expiration schedule lists each unit in your apartment property, the current tenant, the lease start and end dates, the monthly rent, and any concessions. It is a snapshot of your rental income at a point in time. Lenders use it to assess how much of your income is at risk of changing in the near future. If many leases expire in the same year, the property could face a drop in rent or higher vacancy when those tenants move out or renew at lower rates. The schedule helps the lender see that risk before it happens.
How to prepare a lease expiration schedule
To create the schedule, you will need a current rent roll that shows every unit and its lease end date. List each unit by number, the tenant name, the lease start and end dates, the current monthly rent, and any rent concessions or free rent periods. Also note whether the lease is a fixed-term lease or a month-to-month tenancy. If a unit is vacant, mark it as vacant and show the last rent and the date it became vacant. This gives the lender a complete picture of your current occupancy and income.
A suggested way to organize the information is to sort the units by lease expiration date, from the earliest to the latest. This makes it easy to see how many leases expire each month or each year. You can also group them by lease type, such as one-year leases, two-year leases, and month-to-month. The goal is to show the lender the pattern of expirations and the potential income volatility.
What a trailing twelve months of operating statements shows
A lease expiration schedule is a snapshot, but a trailing twelve months (T-12) of operating statements shows the historical performance of the property. The T-12 is a report of income and expenses for each of the past twelve months. It shows how much rent was actually collected, not just what was billed. It also shows operating expenses, such as utilities, maintenance, property taxes, and insurance. The lender compares the T-12 to the rent roll to see if the property's income is stable or if it fluctuates with lease expirations. If many leases expired in the past year and rents dropped, the T-12 will show that decline. If rents stayed the same, the T-12 confirms the income is stable.
When you prepare both documents, you should reconcile the rent roll snapshot with the T-12. The rent roll shows the current rent for each unit, while the T-12 shows the actual rent collected each month. If a unit was vacant for part of the year, the T-12 will show lower income for those months. The lender will want to see that the current rent roll is consistent with the T-12's recent months. If there is a big difference, you should be ready to explain it, such as a recent rent increase or a change in occupancy.
How lease expirations affect the financing discussion
A property with many leases expiring in the next year is riskier to a lender than one with leases spread out over several years. The OCC Commercial Real Estate Lending handbook notes that properties with shorter lease terms are vulnerable to declining market values as rents decline and leases are renewed at lower rental rates, and that as expiring leases cause project cash flows to decline, developers could be unable to meet scheduled mortgage payments [1]. This means the lender will look at your lease expiration schedule to see how much of your income is at risk. If a large portion of your leases expire in the same year, the lender may require a higher debt service coverage ratio, a lower loan-to-value ratio, or a reserve for rent loss. The lender may also ask for a rent roll projection that shows what the income would be if all expiring leases renewed at current market rents or if they all turned over to new tenants at market rents.
If your property has long-term leases with staggered expirations, the lender may view it as more stable and offer better terms. The OCC handbook also discusses that retail properties with anchor tenants signing leases of 20 to 25 years may have more predictable income, but that anchor tenants' leases may include co-tenancy clauses that allow rent decreases or termination if another anchor ceases operations [1]. For apartments, the same principle applies: a mix of lease terms can reduce risk, but you should be aware of any clauses that could reduce income unexpectedly.
How to present the lease expiration schedule to a lender
When you submit your financing request, include the lease expiration schedule as a separate document or as a tab in your rent roll spreadsheet. Label it clearly and include the date it was prepared. Also include a summary that shows the number of leases expiring each quarter or each year for the next three to five years. This summary helps the lender quickly see the expiration pattern. If you have a plan for managing lease expirations, such as a marketing strategy to attract new tenants or a rent increase plan, include that in your business plan. The business plan should explain how you will maintain or increase income as leases expire.
Evidence checklist for your lease expiration schedule
- [ ] Current rent roll with unit numbers, tenant names, lease start and end dates, monthly rent, and concessions.
- [ ] Lease expiration schedule sorted by expiration date, showing the number of leases expiring each month and each year for the next three to five years.
- [ ] Trailing twelve months of operating statements (T-12) showing actual rent collected and operating expenses for each month.
- [ ] Reconciliation between the rent roll snapshot and the T-12, explaining any differences in rent amounts or occupancy.
- [ ] Business plan that includes your strategy for managing lease expirations, such as marketing, rent increases, or capital improvements.
- [ ] Pro forma with assumptions that show projected income and expenses after lease expirations.
- [ ] If the property has any rent-controlled or rent-stabilized units, a note on how those leases expire and how rent increases are limited.
Frequently asked questions
Does the lender need a lease expiration schedule for every unit, or just for the ones expiring soon?
The lender needs a schedule for every unit, including those with long-term leases. The schedule shows the full picture of your income stability. Even if no leases expire soon, the lender wants to see that your income is not concentrated in a few tenants who could all leave at once.
How far into the future should the lease expiration schedule go?
A schedule covering the next three to five years is typical. This matches the typical loan term and allows the lender to see the risk of lease expirations during the loan period. If your property has very long leases, such as ten-year terms, you can show fewer years, but include all leases that expire during the loan term.
What if my property has mostly month-to-month tenancies?
Month-to-month tenancies are riskier because tenants can leave with short notice. The lender will want to see a longer history of stable occupancy and rent collection. You should include a note in your schedule showing the average length of stay for month-to-month tenants and the historical turnover rate. The T-12 will be especially important to show that the property has maintained stable income despite the flexible lease terms.
Model this deal and request financing
Run a refinance model with your own numbers in the financing workbench. Results are calculated on the server with the assumptions shown. If you choose to send the request, you get a preliminary lender-package PDF and can attach your rent roll, T-12 or OM.
Opens the financing workbench operated by Wraith Real Estate. Nothing goes to any lender without Wraith's review and your agreement.
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).