Gross potential rent versus collected rent in an apartment loan model
A practical guide to preparing an evidence checklist that distinguishes gross potential rent, collected income, NOI, capex, debt service, and equity cash flow for multifamily financing discussions.
A practical guide to preparing an evidence checklist that distinguishes gross potential rent, collected income, NOI, capex, debt service, and equity cash flow for multifamily financing discussions.
Understand the income layers in an apartment loan model
When you present a multifamily property to a lender, the underwriter will reconstruct your operating statement into a consistent format. The first step is to distinguish gross potential rent (GPR) from collected rent. GPR is the theoretical income if every unit were leased at market rent and every tenant paid. Collected rent is what actually hit your bank account after vacancies, concessions, and bad debt. The gap between them reflects vacancy and collection loss allowances, which adjust GPR to effective gross income (EGI). [1] The OCC handbook notes that for income-producing properties, the lender assesses the adequacy of cash flow to meet debt service requirements and comments on trends in NOI, vacancy, and expenses. Your job is to provide the raw data so the underwriter can verify each layer.
Prepare a current rent roll as a snapshot
A current rent roll is a list of every unit, the tenant name, lease start and end dates, the contracted monthly rent, any concessions, and the actual amount collected in the most recent month. This is a point-in-time document showing current occupancy and rent in place, not historical collections. [1] The OCC guidance says the lender will review current rent rolls and leases to evaluate cash flow. Record the date of the snapshot and note any units that are vacant, rented but not yet occupied, or in notice. Do not blend this with historical data yet.
Prepare a trailing twelve-month (T-12) operating statement
The T-12 is a historical record of actual income and expenses for each of the past twelve months. State whether it uses cash or accrual accounting and reconcile collections separately when needed. The timing difference is critical: the rent roll shows expected collections for the current month; The T-12 reports historical income and expenses on its stated accounting basis over the past year. Compare the two to identify seasonal patterns, collection problems, or rent growth. Lenders typically review trailing twelve months of operating statements for existing properties as part of assessing cash flow adequacy. [1] The OCC handbook expects the lender to review current rent rolls and leases and comment on trends in NOI, vacancy, and expenses. Sum the collected rent column to determine total collections over the trailing twelve months. Compare that to the rent roll's gross potential to calculate your actual vacancy and collection loss.
Distinguish gross rent, collected income, NOI, capex, debt service, and equity cash flow
Build a simple income waterfall on one page: - Gross potential rent: sum of all unit rents at market or lease rates, assuming full occupancy. - Vacancy and collection loss: the difference between GPR and actual collected rent from the T-12. - Effective gross income (EGI): collected rent plus any other income (parking, laundry, fees). - Operating expenses: property taxes, insurance, utilities, management, repairs, reserves for replacement. - Net operating income (NOI): EGI minus operating expenses. This is the cash available to pay debt service before capital expenditures. - Capital expenditures (capex): roof, HVAC, parking lot, unit renovations. These are not operating expenses; they come after NOI. - Debt service: principal and interest on the loan. - Equity cash flow: NOI minus capex minus debt service. [1] The OCC guidance says the lender evaluates the adequacy of cash flow to meet debt service requirements. Do not equate a cap rate with a debt constant; a cap rate values the property, while a debt constant is the annual debt payment divided by the loan amount. They measure different things.
Reconcile the rent roll and T-12 totals
Print the rent roll and the T-12 side by side. Identify every unit that appears on the rent roll but had no collection in a given month on the T-12. That is a vacancy or a non-payment. Also identify any unit on the T-12 that is not on the current rent roll (a former tenant who paid last year). Total the differences and calculate your actual collection rate. [1] The OCC handbook says the lender will comment on trends in vacancy and expenses. If the T-12 shows a downward trend in collected rent while the rent roll shows higher potential rent, the lender will inquire about the reasons. Record your explanation, such as seasonal variation, renovation activity temporarily removing units, or market conditions.
Identify the reporting basis and reconcile periods
Your financial statements may be on an accrual basis or a cash basis. A T-12 may be prepared on a cash or accrual basis. Identify that basis and show any reconciliation necessary to explain collections, receivables and incurred expenses. If your statements are accrual, note the difference: accrued rent is income recognized but not yet received. The lender will focus on cash-basis collections because that is what services the debt. [1] The OCC handbook states that the lender should assess the ability of the borrower to repay the loan in a timely manner, which typically focuses on cash flow. Reconcile the periods: the rent roll is a snapshot, the T-12 is twelve historical months, and your pro forma projects forward. Do not mix them without adjusting for timing.
Suggested way to prepare the evidence checklist
Create a single-page document titled "Income Evidence Checklist" with the following items: - Date of current rent roll. - Gross potential rent (monthly and annualized). - Number of units, occupied and vacant. - Average collected rent per unit from T-12. - Total collected rent for each of the past 12 months. - Vacancy and collection loss percentage, calculated as the difference between gross potential rent and collected rent divided by gross potential rent. - Operating expenses for each of the past 12 months. - NOI for each of the past 12 months. - Any capital expenditures in the past 12 months. - Debt service on existing loans (if any). - Equity cash flow (NOI minus capex minus debt service).
Record each number and the source document. Do not assume the lender will accept your totals; they will verify against the source. [1] The OCC handbook says the lender will review current rent rolls and leases and assess trends in NOI, vacancy, and expenses. Your checklist provides the starting point for their analysis.
FAQs
How do I explain a gap between rent roll potential and T-12 collected rent?
Compare the two documents month by month. Identify units that were vacant or non-paying. If the gap is large, the lender will want to know why. Record the reasons: market rent growth that has not yet been realized, a renovation program that temporarily removes units, or a collection problem. The T-12 reflects historical collections; the rent roll reflects forward expectations. The lender will use both to project stabilized income.
Should I include capital expenditures in operating expenses?
No. Capital expenditures are separate from operating expenses. Operating expenses are recurring costs to maintain the property; capex is a long-term investment that extends the life of an asset. Lenders typically distinguish between operating expenses and capital expenditures, as capex is a long-term investment that extends the life of an asset. Include capex in your cash flow waterfall after NOI, not before, because it reduces equity cash flow but not debt service capacity.
What if my financial statements are on an accrual basis?
Convert the income and expense line items to a cash basis for the T-12. Accrual statements may show rent revenue that was not yet collected or expenses that were not yet paid. The lender needs to see actual cash flow because that is what services the debt. [1] The OCC handbook says the lender evaluates the ability of the borrower to repay the loan in a timely manner, which typically focuses on cash flow.
Closing invitation
We will tell you how we would approach the financing. Submit your request through the website.
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).