How to separate in-place rent from stabilized rent in an acquisition model
Learn to build a concrete rent reconciliation workpaper that separates actual in-place rent from projected stabilized rent, helping you present a clear underwriting story to lenders.
Learn to build a concrete rent reconciliation workpaper that separates actual in-place rent from projected stabilized rent, helping you present a clear underwriting story to lenders.
When you acquire a property that is not yet fully leased or is collecting rent below market, the lender will want to see two numbers: what the property is producing today (in-place rent) and what it could produce once it reaches a normal, sustainable occupancy and rent level (stabilized rent). Mixing them up can confuse the underwriting or make the business plan look riskier than it is.
This guide walks you through building a rent reconciliation workpaper that keeps those two figures separate and shows how you get from one to the other. The workpaper is a document you prepare, not a form the lender requires. It helps you explain the gap and how your plan closes it.
Why lenders look at in-place versus stabilized rent
A lender evaluating an acquisition needs to understand the property's current cash flow and its potential. The current rent roll shows what tenants are actually paying, but the property may have vacancy or below-market leases that a new owner expects to improve. Bank supervisory guidance notes that for a property that is not stabilized, an as-stabilized value may be appropriate for calculating the loan-to-value ratio, based on the lender's underwriting standards [1]. That means the lender may consider the property's value after it reaches stabilized occupancy, not just its current value.
However, the lender also needs to see that the debt service can be covered during the lease-up or rent-roll period. That is why you present both figures. The in-place rent supports the loan payments while the property is still transitioning; the stabilized rent supports the long-term valuation and exit.
Build a rent reconciliation workpaper
A rent reconciliation workpaper is a simple spreadsheet or table that lists every unit or space, the current tenant, the in-place rent, the market rent you project, and the difference. It also tracks whether the space is occupied or vacant. The goal is to show, unit by unit, how total gross potential rent moves from today's actual to the stabilized projection.
Suggested columns for the workpaper
- Unit or space identifier
- Tenant name (or "vacant")
- Lease expiration date
- Current monthly base rent
- Projected stabilized monthly market rent
- Rent differential (market minus current)
- Notes on concessions, free rent, or tenant improvements
For vacant units, the current rent column is zero, and the market rent column shows what you expect to achieve based on the sponsor's documented assumptions or market data. This makes the vacancy gap visible.
Record the current rent roll as a snapshot
The rent roll is a snapshot of who is in place and what they are paying as of a specific date. It does not show historical collections or payment timing. To understand whether rents have been rising or falling, and whether tenants are paying on time, you need the trailing twelve months (T-12) of operating statements. The T-12 may be prepared on a cash or accrual basis and shows actual collections month by month, including late payments, vacancies, and concessions that may not appear on the rent roll.
When you compare the rent roll to the T-12, you may find differences. For example, the rent roll might show a tenant paying a certain monthly rent, but the T-12 may reflect a lower amount collected last month due to concessions or other adjustments. You need to reconcile those figures to get an accurate picture of collected income.
How to prepare the comparison
- Pull the current rent roll and note the date.
- Pull the T-12 operating statements for the same property.
- For each month, record gross potential rent, actual collected rent, and any concessions or bad debt.
- Compare the rent roll total to the average of the most recent three months of collected rent. If they differ by more than a few percent, investigate why.
This comparison helps you identify collection losses, which the OCC handbook flags as important to examine [1]. It also shows whether the property's economic occupancy (what you actually collect) matches its physical occupancy (what is leased).
Separate income components in the pro forma
Once you have the rent roll and T-12 reconciled, you build the pro forma. The pro forma should clearly separate:
- Gross potential rent: the total if every space were leased at market rate
- Vacancy and collection loss: a deduction for expected vacancy and non-payment
- Effective gross income: what you expect to actually collect, distinct from rent-loss gaps
- Operating expenses: property taxes, insurance, management, utilities, repairs
- Net operating income (NOI): effective gross income minus operating expenses
- Debt service: principal and interest payments on the loan
- Capital expenditures (capex): reserves for roof, HVAC, parking lot, etc.
- Equity cash flow: NOI minus debt service minus capex
Do not confuse NOI with debt service. NOI is the property's income before debt payments; debt service is what you pay the lender. Equity cash flow is what is left for you.
Show the transition from in-place to stabilized
In the pro forma, create two columns or two scenarios. The first uses the in-place rent roll and current vacancy. The second uses the stabilized market rents and a stabilized vacancy rate, as supported by the lender's underwriting criteria or the sponsor's documented assumptions.
Then show how you expect to move from one to the other. For example:
- Initial period: use in-place rent, with a lease-up schedule for vacant spaces
- Subsequent periods: assume some below-market leases roll to market rent
- Later period: assume full stabilization
These are scenarios to present to the lender, not market benchmarks.
This is not a prediction; it is a scenario you present to the lender. The lender will test it against market data. The OCC handbook advises evaluating future demand and supply by understanding current and planned development activity in the local market [1]. You should be ready to discuss why you believe rents will grow and vacancy will fall.
Identify assumptions and source facts
Every number in the workpaper and pro forma is either a fact or an assumption. Label them clearly.
Facts come from the rent roll, the T-12, the lease agreements, and the property's operating history. For example, current base rent per lease is a fact. Historical collection loss is a fact.
Assumptions are your projections. For example, the market rent you assign to a vacant unit is an assumption. The vacancy rate you use for stabilization is an assumption. The lease-up timeline is an assumption.
When you present the workpaper to a lender, you can say: "Here is the in-place rent, verified by the rent roll and T-12. Here is my stabilized projection, based on comparable properties and market reports. Here is how I plan to close the gap." That is much stronger than mixing facts and guesses together.
Prepare a one-page evidence checklist
Alongside the workpaper, prepare a one-page checklist of the evidence you have gathered. This helps the lender see that you have done the homework.
Evidence checklist for rent reconciliation
- [ ] Current rent roll with date
- [ ] T-12 operating statements
- [ ] Rent roll to T-12 reconciliation
- [ ] Lease abstracts for top 10 tenants by square footage
- [ ] Market rent comparables from a third-party source or appraiser
- [ ] Vacancy and collection loss history
- [ ] Lease expiration schedule
- [ ] Capital expenditure plan and reserves
- [ ] Pro forma with in-place and stabilized scenarios
- [ ] Sources and uses of funds for the acquisition
This checklist is not a lender requirement; it is a suggested way to prepare information for the financing discussion.
FAQs
Does the lender always use stabilized rent for underwriting?
No. The lender may use in-place rent for the initial years of the loan and stabilized rent for later years, or may require a blended approach. Bank supervisory guidance says that an as-stabilized value may be appropriate for a property that is not stabilized, but the lender decides based on the specific property and business plan [1]. Ask the actual lender how they treat the transition period.
What if my stabilized rent assumption is higher than what the market supports?
The lender will compare your assumption to appraisals and market data. If the gap is too large, they may discount your projection or require more equity. The OCC handbook notes that supply can overestimate demand, leading to prolonged lease-up and declines in rental rates [1]. It is safer to use conservative assumptions and show upside as a sensitivity, not the base case.
Do I need an appraisal to separate in-place from stabilized rent?
An appraisal is typically required for the loan, and it will include both as-is and as-stabilized values. But you can and should prepare your own rent reconciliation workpaper before the appraisal. It helps you think through the numbers and gives you a document to discuss with the lender and appraiser. The workpaper is your analysis; the appraisal is the third-party opinion.
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).