Why Your Rent Roll Fails the Lender Model: Reconciling Billings, Concessions, Loss-to-Lease, and Bad Debt Into Underwritten EGI

A sponsor walks into a lender's office with a rent roll showing 94 percent occupancy and $2.1 million in annual billings. The lender nods, pulls out a spreadsheet, and begins subtracting. Within minutes, that $2.1 million becomes $1.7 million in underwritten effective gross income. The sponsor watches the leverage evaporate. The lender is not being conservative. The lender is being precise.

The rent roll you present is a statement of contractual obligation. It is not income. The lender's job is to convert it into income the property will actually collect, retain, and deploy to service debt. That conversion is not linear. It is a series of deliberate, mechanical adjustments that most sponsors either misunderstand or discover too late in the process.

This brief walks through how lenders deconstruct your rent roll and why the path from billings to underwritten EGI determines whether your deal funds or reprices.

Billings Are Not Revenue

Start here: the rent roll shows what tenants are contractually obligated to pay. This is billings. Billings are gross, unadjusted, and assume perfect collection. In a lender's model, billings are the first line item, not the last. The work begins immediately after.

Lenders distinguish between in-place rents (what existing tenants pay) and market rents (what new tenants would pay on renewal or re-lease). This distinction matters because it flags roll-down risk. If your in-place rent on a 40 percent expiring block is $18 per square foot and market rents are $16, lenders model the loss on renewal. Some will bake in a haircut immediately. Others will flag it as a risk factor and demand a higher debt service coverage ratio to compensate. Either way, the loss-to-lease creates a headwind that billings alone do not capture.

Concessions Are Deferred Rent Reductions

Concessions come in forms: free rent, below-market renewal rates, tenant improvement allowances, and parking waivers. Each reduces actual cash collections below contract rent. A lender's model treats a concession as a direct reduction to revenue. If a new tenant receives three months of free rent on a three-year lease, the lender amortizes that concession across the full term and reduces annual billings accordingly. The sponsor who quotes the headline rent without mentioning the concession will find the lender's EGI sharply lower than expected.

The mechanics matter. A sponsor might structure a deal as $20 per square foot with two months free. A lender translates this into an effective rate of approximately $19.33 per square foot spread across 36 months. If the sponsor's pro forma assumed $20 per square foot without adjustment, the lender's model will show materially lower revenue. Multiply this across a 200-unit apartment building or a 100,000 square foot office property, and the gap grows quickly.

Some lenders apply a blanket concession assumption based on market practice and lease term. Others demand a lease-by-lease accounting. The more sophisticated lenders require both, plus a sensitivity analysis showing how concessions vary by tenant creditworthiness and lease length. This is not pedantry. Concessions are cash that does not flow, and debt service requires cash.

Loss-to-Lease Signals Pricing Risk

Loss-to-lease emerges when in-place rent exceeds market rent. It is the lender's early warning system for a building that has been overrented or a market that has softened. A 200-unit property with 60 percent of units expiring in the next 18 months at $1,600 per month in-place rent, facing a market rate of $1,450 per month, carries a loss-to-lease of approximately $18,000 per month on those units. Annualized, that is $216,000 of lost revenue that the sponsor's rent roll does not yet reflect because the leases have not rolled.

Lenders model loss-to-lease in two ways. Conservative lenders assume the full loss on all expiring leases immediately. Moderate lenders assume a staged re-leasing schedule with partial loss recognition. Both approaches reduce EGI. The sponsor who fails to quantify loss-to-lease in the underwriting package will watch the lender impose it unilaterally, and the leverage will fall.

Bad Debt Adjustments Reflect Collection Reality

Bad debt is the revenue that is billed but never collected. A sponsor might argue that their property has a 2 percent bad debt rate because their collection history supports it. A lender will often apply a 3 to 5 percent bad debt assumption regardless, based on asset class, geography, and tenant profile. Multifamily properties in secondary markets might carry a 4 percent assumption. Office properties with small-tenant rosters might carry 5 percent. Class A retail in prime locations might carry 2 percent. The lender is not impugning your management. The lender is pricing for statistically likely default.

Bad debt adjustments can be straightforward (a percentage of gross billings) or more granular (applied by tenant or lease cohort). A lender reviewing a property with a single large anchor tenant might apply a lower bad debt rate to that tenant and a higher rate to smaller tenants. A lender reviewing a mixed-use property might apply different rates to residential, retail, and office components. The more transparent your historical collection data, the more negotiable the lender's bad debt assumption becomes. The more opaque your data, the higher the lender's assumption.

Vacancy and Turnover Assumptions Close the Gap

Vacancy and turnover assumptions sit at the bottom of the waterfall. These are not deductions from in-place rent. These are adjustments to market rent on units or space that will be vacant or in lease-up during the underwriting period. A lender might assume a 5 percent physical vacancy rate on a property with 94 percent occupancy, recognizing that turnover and re-leasing cycles create temporary downtime. This is especially true for multifamily, where a 10 to 15 day turnover between tenants is normal, and leasing takes time.

The lender's vacancy assumption often exceeds the sponsor's historical vacancy rate. This is intentional. The lender is stress-testing the asset for normal operating friction. A sponsor with a 2 percent historical vacancy might face a 5 percent modeled vacancy. The difference is not an insult. It is a buffer for market disruption, tenant quality deterioration, or management transition.

When you add all these adjustments together, the path from billings to underwritten EGI becomes clear. A property with $2.1 million in gross billings might have $1.8 million in adjusted billings after loss-to-lease and concessions. After bad debt, it becomes $1.71 million. After vacancy, it lands at $1.62 million. The lender now has underwritten EGI. This is the income the property will produce with reasonable reliability. This is the income against which debt service is measured.

The sponsors who understand this waterfall before underwriting begins are the ones who arrive with clean, detailed rent rolls, documented concession schedules, market rent comparables, and historical collection data. They do not argue with the lender's bad debt assumption. They provide evidence that supports a lower one. They do not hide loss-to-lease. They quantify it and explain the path to mitigation. They do not present gross billings as if it were net income. They present a reconciliation that the lender can audit and defend to a credit committee.

The conversion from rent roll to underwritten EGI is not negotiable. The mechanics are fixed. What is negotiable is the precision and transparency with which you present the data. Lenders respect sponsors who speak their language. That language is reconciliation.

What I'm watching next

• How multifamily properties with elevated expiration cliffs (40 percent-plus of leases rolling in a 18-month window) will face lender-imposed loss-to-lease haircuts that force sponsor equity injection or restructuring before closing.
• Whether lenders begin applying higher bad debt assumptions to properties in secondary markets facing tenant credit stress, and whether sponsors can offset this with personal guarantees or collateral pledges.
• The emergence of lender-mandated lease-by-lease concession accounting as a standard underwriting requirement, forcing sponsors to submit full lease abstracts rather than summary rent rolls, which will slow underwriting timelines and expose previously hidden deal friction.