How to show rental income during a phased apartment renovation
A practical evidence checklist for sponsors preparing a loan request when a multifamily property's income is temporarily disrupted by phased renovation work. Explains how to document pre-renovation stabilized income, renovation-phase rent loss, and projected post-renovation income so lenders can underwrite the property's income-generating capacity.
A practical evidence checklist for sponsors preparing a loan request when a multifamily property's income is temporarily disrupted by phased renovation work. Explains how to document pre-renovation stabilized income, renovation-phase rent loss, and projected post-renovation income so lenders can underwrite the property's income-generating capacity.
When a multifamily property undergoes a phased renovation, the rent roll becomes a moving target. Some units are offline, others rent at a discount, and the trailing twelve months (T-12) of operating statements may show a mix of pre-renovation, in-construction, and partially completed units. Lenders need to see through the noise to the property's income-generating capacity. This guide walks through the specific evidence to prepare and how it affects the financing discussion.
Start with a pre-renovation stabilized rent roll and T-12
A current rent roll is a snapshot of today's leased units, rents, and concessions. A T-12 is twelve historical months of income and expense data. During a phased renovation, these two documents may tell different stories. The rent roll might show lower occupancy because units are offline, while the T-12 includes months before the renovation began. [1] The OCC handbook notes that historical, current, and projected rental rates are part of analyzing income-generating capacity. As a practical step, prepare a pre-renovation stabilized rent roll (the last full month before any unit was taken offline) and a T-12 that covers at least the twelve months before the first renovation phase started. Label each clearly. Compare the two: identify which months in the T-12 reflect pre-renovation conditions and which include renovation activity. This comparison helps a lender understand the property's baseline income before disruption.
Reconcile the rent roll and T-12 timing difference
The current rent roll is a point-in-time report; the T-12 is a historical record. They will not match. Explain the timing difference in a brief reconciliation schedule. For example: "The current rent roll shows occupancy reduced due to units offline for renovation. The T-12 reflects a mix of pre-renovation and renovation months." This reconciliation prevents a lender from assuming the property is permanently underperforming. [1] The OCC handbook notes that NOI analysis may assume market vacancy rates above or below actual rates. Your reconciliation schedule should account for this by clearly separating renovation disruption from stabilized operations.
Create a renovation-phase income and expense workpaper
Lenders need to see the actual cash flow during the renovation, not just pro forma projections. Build a simple workpaper with three columns: pre-renovation stabilized (annualized from the T-12), renovation-phase actual (monthly or quarterly), and post-renovation projected. Include these line items:
- Gross potential rent (all units at market rent, assuming full occupancy)
- Vacancy and collection loss (including units offline for renovation, as documented)
- Effective gross income (gross potential rent minus vacancy and collection loss; note that rent-loss gap is not effective gross income)
- Operating expenses (property taxes, insurance, management, utilities, repairs, replacement reserves)
- Net operating income (NOI)
- Debt service (existing or proposed loan payments)
- Debt service coverage ratio (DSCR) (expressed as the lender's actual test or the sponsor's documented assumption)
- Equity cash flow (NOI minus debt service)
[1] The OCC handbook states that repayment of loans financing income-producing CRE typically depends on the property's ability to service debt from cash flow. Separately, the handbook notes that NOI analysis may assume market vacancy rates above or below actual rates. Your workpaper should show both the actual renovation-phase NOI and the projected stabilized NOI. This allows the lender to stress-test the property under both normal and stressed conditions.
Document the renovation budget and its effect on income
A phased renovation has a capital expenditure budget that directly affects rental income. Prepare a schedule that links each renovation phase to the expected rent increase and the period of income loss. Provide specific unit counts offline and duration without including dollar amounts. [1] The OCC handbook notes that some capital expenditures used to calculate NOI may not appear as expenses on tax returns, such as replacement reserves for HVAC, roofs, and parking lots. While tax returns can be helpful, they may be prepared on a cash basis, reflecting only income and expenses actually received or paid during the year. As a practical step, your renovation budget should include all hard costs (construction, materials, contractor fees) and soft costs (permits, design, interest reserve). This helps the lender understand the total capital need and the timing of income recovery.
Prepare a post-renovation pro forma with clear assumptions
A pro forma is only as useful as the assumptions behind it. List every assumption, including stabilized occupancy based on the lender's actual test or the sponsor's documented assumption, market rent per unit, operating expense ratio, replacement reserve amount, and capitalization rate used for valuation. [1] The OCC handbook says that inadequately supported or questionable analysis should be challenged. Therefore, list every assumption in your pro forma. Your assumptions should be grounded in comparable properties, market reports, or the property's own pre-renovation performance. If you assume a rent premium after renovation, show comparable renovated properties in the same market that have achieved that premium. If you assume a lower vacancy rate, explain why the renovated property will attract and retain tenants better.
Distinguish gross rent, collected income, NOI, and debt service
Lenders use different metrics for different purposes. Gross rent is the total rent if all units were leased at full market rates. Collected income is what actually comes in after vacancy, concessions, and bad debt. NOI is collected income minus operating expenses (including replacement reserves). Debt service is the loan payment (principal and interest). Equity cash flow is what remains after debt service. [1] The OCC handbook defines gross income as revenue assuming full occupancy before vacancy and credit losses, and distinguishes it from effective gross income. It also notes that debt-service coverage calculations for covenant compliance may differ from the DSCR used for underwriting. In your workpaper, show each metric separately. Do not equate a cap rate with a debt constant; the cap rate is used for valuation (NOI divided by value), while the debt constant is the annual debt service divided by the loan amount. Use these terms distinctly without implying specific numerical benchmarks.
Suggested workpaper: renovation income and expense reconciliation
Create a single-page workpaper with the following columns:
- Line item (gross potential rent, vacancy/collection loss, effective gross income, operating expenses, NOI, debt service, DSCR, equity cash flow)
- Pre-renovation stabilized (annualized from T-12)
- Renovation-phase actual (monthly or quarterly, from current rent roll and operating statements)
- Post-renovation projected (from pro forma)
- Notes (explain differences, e.g., "10 units offline for Phase 1")
This workpaper gives the lender a single document that reconciles the three periods. It shows that the renovation is a temporary disruption, not a permanent decline.
FAQs
How do I handle units that are partially renovated but not yet leased?
List those units as "offline for renovation" in the vacancy and collection loss line. Do not include them in gross potential rent until they are ready for lease. In the post-renovation projection, include them at the expected market rent once complete.
Should I use cash basis or accrual basis for the T-12?
Use the same basis as your financial statements and clearly identify whether the T-12 is cash or accrual basis. If your tax returns are cash basis, note that in the workpaper. [1] The OCC handbook warns that tax returns prepared on a cash basis reflect only income and expenses actually received or paid, which may differ from accrual-based NOI. If you use cash basis, add a note explaining any timing differences (e.g., "real estate taxes accrued but not paid in the current year").
Can I include projected income from units not yet renovated?
Yes, but only in the post-renovation projected column. The renovation-phase actual column should reflect only current reality. Lenders will compare the two to assess the credibility of your projections. If the gap is large, be prepared to explain how the renovation will close it.
Closing invitation
Send us the property, the business plan, the amount you need, and the timing. We will tell you how we would approach it.
Model this deal and request financing
Run a multifamily acquisition or value-add 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).