Can I Afford This Property?Commercial real estate financing, worked out

How delinquent apartment rent changes the financing discussion

Delinquent rent on a rent roll is not the same as lost rent. This guide explains how to separate collected income from unpaid balances, reconcile the trailing twelve months with the current snapshot, and present the information so a lender can underwrite the property's actual cash flow.

Source: CodexTopic: Multifamily income evidence1287 wordsUpdated 2026-11-19

Delinquent rent on a rent roll is not the same as lost rent. This guide explains how to separate collected income from unpaid balances, reconcile the trailing twelve months with the current snapshot, and present the information so a lender can underwrite the property's actual cash flow.

Separate collected income from unpaid balances on the rent roll

A current rent roll is a snapshot of who is supposed to pay and how much. It shows gross rent, but it does not tell you what was actually collected. To show a lender the true economic occupancy, you need to identify the portion of rent that is delinquent and distinguish it from concessions or vacancy. The OCC handbook notes that even when a rent roll indicates high occupancy, actual collections should be examined to determine true economic occupancy and evaluate management's collection effectiveness [1].

Suggested way to prepare: create a rent roll that lists each unit, the contract rent, any concessions, any unpaid balance, and the number of months delinquent. Total the unpaid column separately so the lender can see the gross rent and the collection loss side by side.

Reconcile the trailing twelve months with the current snapshot

A trailing twelve-month operating statement (T-12) shows twelve historical months of income and expenses, reported on either a cash or accrual basis. It covers a different time period than the current rent roll, which is a single point in time. Comparing the two directly can mislead if you do not account for the timing difference. For example, a T-12 may include months when a now-delinquent tenant was still paying, so the trailing twelve-month collection rate may appear stronger than the current snapshot suggests.

Suggested way to prepare: on a single workpaper, list the trailing twelve months by month. Show gross potential rent, actual collected rent, and any write-offs for each month, specifying whether the T-12 is cash or accrual basis. Then show the current month's rent roll with the same categories. Add a note explaining any large variance between the trailing twelve-month average collection rate and the current month's rate. This helps the lender assess whether the delinquency is a new trend or a temporary spike.

Distinguish gross rent, collected income, NOI, debt service, and equity cash flow

Lenders underwrite cash flow to meet debt service requirements. The OCC handbook says that for income-producing properties, the analysis should assess the adequacy of cash flow to meet debt service and comment on trends in NOI, vacancy, and expenses [1]. To do that, you need to separate the layers of cash flow:

  • Gross rent: the total of all contract rents before any deductions.
  • Collected income: gross rent minus vacancy, concessions, and delinquent rent not expected to be recovered.
  • Net operating income (NOI): collected income minus operating expenses.
  • Debt service: the scheduled principal and interest payments on the loan.
  • Equity cash flow: NOI minus debt service.

If delinquent rent is not collected, it reduces collected income and therefore NOI. This can weaken the property's debt service coverage ratio compared to what gross rent alone would indicate. Lenders will want to see whether the delinquency is likely to be cured or whether it represents a permanent loss.

Identify warning indicators that affect the financing discussion

The OCC handbook lists several warning indicators that can jeopardize debt repayment, including delinquent lease payments from major tenants, increasing vacancy and turnover rates, and liberal concessions [1]. When delinquent rent appears on the rent roll, a lender will assess whether it is concentrated among a few large tenants or spread across many smaller ones. Concentration in a major tenant is a more serious risk because losing that tenant's income could significantly reduce NOI.

Suggested way to prepare: create a tenant concentration schedule that shows each tenant's share of total gross rent. Highlight any tenant that represents a significant portion of gross rent and note whether that tenant is current or delinquent. Also note the lease expiration dates for those tenants.

Evaluate management's collection practices

A lender will assess whether the property management is effective at collecting rent. The OCC handbook states that a property manager's ability and experience should be carefully evaluated, and that collection losses are a property-specific consideration [1]. If the rent roll shows chronic delinquency, the lender may question whether management is enforcing lease terms or pursuing evictions when necessary.

Suggested way to prepare: include a brief narrative that describes the management's collection process, such as when late fees are applied, how many days of delinquency trigger a notice, and what the eviction timeline looks like in the local jurisdiction. Also include a summary of any collection lawsuits or evictions filed in the past twelve months.

Present the information so a lender can underwrite actual cash flow

A lender will use the rent roll and T-12 to project future cash flow. If delinquent rent is not clearly separated, the lender may assume a higher collection rate than the property is actually achieving. The OCC handbook says that the analysis should consider the potential effect on future debt-service coverage from tenant turnover [1]. Delinquent rent can signal tenant dissatisfaction or financial distress, which may lead to higher turnover and lower future income.

Suggested way to prepare: build a simple pro forma that shows multiple scenarios for the next twelve months reflecting different assumptions about the cure rate of delinquent rent. For each scenario, show the projected NOI and debt service coverage ratio based on the lender's actual underwriting tests or the sponsor's documented assumptions. This gives the lender a range of outcomes and shows that you have considered the risk.

Ask the actual lender about their underwriting assumptions

Every lender has its own underwriting criteria. Some may apply a haircut to delinquent rent automatically; others may ask for a reserve or a guaranty if delinquency exceeds a certain threshold. The OCC handbook is bank supervisory guidance and does not bind every borrower or nonbank lender [1]. The best way to know what a specific lender will require is to ask them directly.

Suggested way to prepare: before submitting the loan request, call the lender's underwriter and ask: How do you treat delinquent rent that is more than 60 days old? Do you require a collection reserve? Do you consider delinquent rent as income when calculating debt service coverage? Record the answers and adjust your presentation accordingly.

Frequently asked questions

Does delinquent rent always reduce the loan amount a lender will offer?

Not necessarily. A lender may still offer the same loan amount if the delinquency is temporary and the property has strong underlying fundamentals, such as a good location and occupancy. However, the lender may require a reserve or a guaranty to cover the risk. The best approach is to show the lender the full picture and ask how they treat it.

Should I include delinquent rent as income in my pro forma?

No. Delinquent rent beyond the lender's aging threshold is unlikely to be collected. Include only rent that you reasonably expect to collect based on documented assumptions. Including delinquent rent as income may lead the lender to adjust it downward, which can hurt your credibility.

Can I use a rent roll that shows only collected rent?

You can, but a lender will want to see gross rent and collection losses separately. Showing only collected rent prevents the lender from assessing the magnitude of delinquency or management effectiveness. Provide both gross rent and collected amounts.


It is not a guarantee of loan approval or environmental clearance. Submission is a preliminary request, not an engagement or lender submission.*

Ready to move forward? Send us the property, the business plan, the amount you need, and your target 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.

Open the acquisition model

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.

Contact us

Requests are reviewed by Wraith Real Estate, a commercial real estate debt advisor (not a lender).

Sources

  1. OCC Commercial Real Estate Lending handbook
  2. Wraith commercial real estate debt