How to show tenant rollover assumptions in a property financing model
A practical guide for CRE sponsors to prepare a tenant rollover evidence file, showing how lease expiration data, renewal probability, and re-leasing cost assumptions affect the financing discussion.
A practical guide for CRE sponsors to prepare a tenant rollover evidence file, showing how lease expiration data, renewal probability, and re-leasing cost assumptions affect the financing discussion.
This guide explains how to prepare a tenant rollover workpaper that separates documented facts from reasoned assumptions, and how that workpaper influences the terms a lender may offer.
Prepare a tenant rollover workpaper
A tenant rollover workpaper is a spreadsheet or table that lists every lease expiring within the next three to five years. For each lease, record:
The workpaper should total the projected rent at risk each year and the capital needed to re-lease space that turns over. This is a suggested way to prepare information, not a mandatory lender process.
Distinguish source facts from assumptions
A lender or underwriter needs to see which numbers are contractual and which are your judgment. The OCC handbook notes that re-leasing costs can be projected by analyzing the rent roll and using an assumption about the probability of renewals [1]. In your workpaper, clearly label each column:
- Fact: Lease expiration date, contractual rent, renewal option language
- Assumption: Renewal probability, market leasing commission rate, tenant improvement cost per square foot
Explain the timing difference between rent roll and trailing twelve months
A current rent roll is a snapshot of who is in place today and what they pay. A trailing twelve months (T-12) operating statement shows what was actually collected over the past year. These two documents may show different totals because:
- The rent roll includes contractual rent; The T-12 reports historical income and expenses on its stated accounting basis, which may include vacancies, concessions, or bad debt.
- The rent roll shows current occupancy; the T-12 may include tenants who have since vacated.
When comparing totals, note the timing difference. A lender will want to see both documents and understand why they differ. This is not a rule, but a practical step to prepare a coherent file.
Distinguish gross rent, collected income, NOI, capex, debt service, and equity cash flow
Your pro forma should show each of these line items separately. Gross rent is the total contractual rent before any deductions. Collected income (effective gross income) subtracts vacancy and collection loss. Net operating income (NOI) subtracts operating expenses from collected income. Capital expenditures (capex) are improvements that last beyond one year, such as a new roof or HVAC. Debt service is the loan payment. Equity cash flow is what remains after all expenses, capex, and debt service.
Re-leasing costs—leasing commissions and tenant improvements—are not always considered an operating expense in calculating NOI but are an important consideration when analyzing cash flow [1]. In your model, show re-leasing costs as a separate line item below NOI, so the lender can see the full cash flow impact of tenant turnover.
Show how rollover assumptions affect debt service coverage
Lenders underwrite to a debt service coverage ratio, typically NOI divided by annual debt service. If your rollover assumptions predict a period of higher vacancy or significant re-leasing costs, NOI may drop in those years. Your model should show the projected coverage ratio for each year of the loan term, not just the first year.
Identify co-tenancy and other lease clauses that affect rollover risk
Some retail leases include co-tenancy clauses that permit a rent decrease or lease termination if an anchor tenant ceases operations [1]. These clauses make the success of anchor tenants even more critical to the viability of the property [1]. In your workpaper, flag any leases with co-tenancy, continuous operations, or termination rights. If an anchor tenant's lease expires and is not renewed, co-tenancy clauses could trigger rent reductions for other tenants, amplifying the rollover risk.
Prepare an evidence checklist for the rollover file
Include the following documents in your financing request:
- Current rent roll (snapshot date)
- Trailing twelve months of operating statements (identify the period)
- Copies of leases expiring within the next three years (or a lease abstract)
- Historical renewal rates for the property (if available)
- Market leasing commission and tenant improvement cost estimates (source and date)
- Your tenant rollover workpaper with facts and assumptions clearly labeled
This checklist is a suggested way to organize information. Submission is a preliminary request, not an engagement or lender submission [2].
Should I include re-leasing costs in the operating expense line?
No. Re-leasing costs—leasing commissions and tenant improvements—are not always considered an operating expense in calculating NOI [1]. Show them as a separate line item below NOI in your cash flow projection. This allows the lender to see both the NOI and the full cash flow impact.
Does a co-tenancy clause always trigger if an anchor tenant leaves?
Not automatically. The lease language determines the trigger. Some co-tenancy clauses require a minimum occupancy percentage; others specify a named anchor tenant. Review the actual lease language and note the clause in your workpaper. The OCC handbook states that co-tenancy clauses make the success of anchor tenants even more critical to the viability of the property [1].
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).