How to separate occupied, leased and available apartment units
A practical guide for sponsors to prepare a unit status evidence checklist that distinguishes occupied, leased and available units, and shows how each category affects the financing discussion.
A practical guide for sponsors to prepare a unit status evidence checklist that distinguishes occupied, leased and available units, and shows how each category affects the financing discussion.
Identify the three unit statuses on a current rent roll
A rent roll is a snapshot of the property on a single date. For financing, each unit should be classified into one of three statuses: occupied, leased but not yet occupied, or available. Occupied means a tenant is in possession under a signed lease, whether rent is current or not. Leased but not yet occupied means a lease is signed but the tenant has not taken possession, often because of a future start date or unit preparation. Available means the unit is vacant and not under any lease. Recording the status for every unit on the rent roll, and noting the date of the snapshot, is a suggested practice to help a lender assess the property's current income stability and the time needed to reach full occupancy.
Prepare a trailing twelve-month operating statement
A trailing twelve-month, or T-12, is a historical report of income and expenses for each of the past twelve months. It is not a snapshot; it shows how the property performed over time. For each month, record gross rent, collected income, and any concessions or bad debt. The T-12 allows you to compare the rent roll's snapshot of occupied units against the actual cash collected, a common underwriting practice. Differences between signed leases and collected income may indicate collection issues or rent concessions not visible on the snapshot. Distinguish gross rent (the total of all signed rents) from collected income (what actually arrived) when reviewing the T-12.
Reconcile the rent roll and the T-12
To reconcile, compare the rent roll's occupied units with the T-12's collected income for the most recent month. If the rent roll shows a unit as occupied but no rent was collected for that unit in the T-12, identify the reason: a new tenant who has not yet paid, a non-paying tenant, or a data error. This reconciliation helps you identify whether the property's income is stable or whether there are units that are occupied but not generating cash flow. For financing, lenders typically want to see that collected income supports the debt service, not just signed leases.
Calculate net operating income and debt service coverage
Net operating income (NOI) is collected income minus operating expenses, excluding debt service. Capital expenditures (capex) are not operating expenses but are recorded separately. To calculate NOI, start with collected income from the T-12, subtract operating expenses such as property management, repairs, utilities, and insurance. Do not subtract debt service or capex at this stage. Then compare NOI to the proposed annual debt service (principal and interest payments) to assess whether NOI sufficiently covers debt service according to the lender's actual test or the sponsor's documented assumption.
Distinguish equity cash flow from NOI
Equity cash flow is what remains after NOI covers debt service and any required reserves. It is not the same as NOI. To calculate equity cash flow, start with NOI, subtract annual debt service, and subtract any capex or reserve contributions. The result is the cash flow available to the sponsor. Lenders may ask for a pro forma that shows this calculation over the loan term, including assumptions about rent growth, expense inflation, and vacancy. Distinguish gross rent, collected income, NOI, debt service, and equity cash flow clearly in your pro forma to avoid confusion.
Prepare a unit status evidence checklist
Create a document that lists each unit number, its status (occupied, leased but not occupied, available), the monthly gross rent, the actual rent collected in the most recent month, and any concessions or free rent periods. Include the date of the rent roll and the months covered by the T-12. This checklist is a suggested way to organize information for a lender; it is not a mandatory form. It helps you identify units that are occupied but not paying, units that are leased but not yet generating income, and units that are available and need to be filled. The checklist also shows the lender that you have a clear picture of the property's income position.
Ask the actual lender about unit release and phase financing
For multifamily properties with multiple buildings or phases, lenders may require unit release prices and phase financing. Bank supervisory guidance notes that for multiple-unit loans, the maximum number of units financed should consider the expected rate of unit sales and the loan tenor. [1] Release prices are calculated to ensure the loan is paid down as units are sold. [1] This is guidance for banks, not a binding rule for every borrower. Ask the actual lender whether they require a release schedule, and if so, what release price formula they use. Also ask whether the property is considered owner-occupied or non-owner-occupied, as this affects underwriting. For properties where the primary source of repayment is predominantly from third-party income, the property is classified as non-owner-occupied. [1]
Frequently asked questions
What is the difference between a rent roll and a T-12? A rent roll is a snapshot of current unit status on a single date. A T-12 is a historical report of income and expenses for the past twelve months. The rent roll shows who is in place; The T-12 reports historical income and expenses on its stated accounting basis over time. Reconcile the two to identify gaps between signed leases and cash flow.
How do I calculate net operating income? Start with collected income from the T-12, subtract operating expenses such as property management, repairs, utilities, and insurance. Do not subtract debt service or capital expenditures. The result is NOI. Then compare NOI to annual debt service to see if the property generates enough income to cover loan payments.
What is a unit release price? A unit release price is the amount paid to the lender to release a unit from the loan when it is sold. It is calculated to ensure the loan is paid down as units are sold. The formula may be based on the proportionate debt plus an acceleration factor. Ask the actual lender what release price formula they use.
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).