Vacancy credit loss and concession double counting

Vacancy, concessions, and bad debt describe different reasons gross rent fails to become collected income. They should remain identifiable, but they must not be deducted twice when moving between a gross-potential-rent schedule, an operating statement, and a lender worksheet. The essential question is what losses are already reflected in the starting figure.

For a program-specific example, Fannie Mae’s Small Mortgage Loan NCF table identifies physical vacancy, concessions, and bad debt separately. The official indexed version inspected carries a June 2, 2026 effective date; direct retrieval returned an access restriction. The example below explains reconciliation mechanics and deliberately does not reproduce that program’s numerical minimums or claim that one table applies to all commercial loans.

Define the loss categories at the unit or lease level

Physical vacancy represents space or units without paying occupancy under the chosen gross-rent convention. A concession is an agreed reduction or incentive, such as an explicitly scheduled free-rent period. Bad debt concerns amounts that became due but are not expected to be collected. A vacant unit should not simultaneously generate a tenant receivable for the same assumed rent unless a separate valid obligation exists.

Use the rent roll, executed leases, concession schedule, charge ledger, aging report, and collections. Identify employee units, models, owner-occupied units, and other nonrevenue uses separately. Their treatment depends on the applicable methodology; do not hide them inside a generic vacancy percentage.

Set the period and rent basis. Current market rent annualized from a snapshot, contractual rent for the actual historical year, and collected trailing income are different starting points. The worksheet must name which it uses before applying a loss percentage.

Reconcile a hypothetical gross-to-net waterfall

Assume annual gross potential rent of $1,200,000 under a stated fictional rent schedule. Physical vacancy accounts for $60,000, executed concessions for $36,000, and unpaid amounts classified as collection loss for $24,000. The categories do not overlap. Net rental income is $1,080,000.

The total loss is $120,000, or 10% of gross potential rent. A statement that begins with $1,104,000 of charges already reflects vacancy and concessions in this illustration. It needs the remaining $24,000 collection adjustment to reach the same net amount. A statement beginning with $1,080,000 of net collections already reflects all three modeled losses.

Starting from that net figure and subtracting the full $120,000 again produces $960,000. The second waterfall does not become conservative underwriting merely because it is lower; it is a duplicate deduction unless it represents a clearly separate, justified future stress.

Apply a hypothetical aggregate floor correctly

Suppose an invented lender convention requires combined rental losses of at least 8% of this same gross potential rent. The minimum is $96,000. Because the documented combined losses are already $120,000, no additional aggregate-floor deduction is required under that assumed convention.

If documented losses had instead totaled $72,000, the incremental deduction would be $24,000: $96,000 minus $72,000. It would not be an extra $96,000 on top of the already deducted losses. This arithmetic applies only to the explicitly defined aggregate floor. A real program may specify a different base, recent-collection test, category treatment, or separate adjustment.

Record whether a lender’s percentage is a total required allowance, an additional stress, or a minimum applied to a particular category. Those instructions are not interchangeable. Obtain clarification before presenting a second deduction as a requirement.

Quantify why the classification matters

Assume operating expenses of $600,000 and no other income adjustments. Correct cash flow is $480,000. The duplicate-loss case produces only $360,000. At a hypothetical 1.25-times coverage requirement and 8% annual debt-service constant, those numerators imply cash-flow limits of $4.8 million and $3.6 million, respectively.

The $1.2 million difference comes entirely from deducting the same losses twice. Other lender constraints may reduce the actual difference in final principal. The lesson is to fix the income bridge before negotiating a ratio or arguing that the lender’s leverage is too low.

Keep a genuine downside case separate

A forecast can reasonably assume future collections deteriorate beyond historical experience. Show that as a new scenario. Identify the tenants, renewal period, concession strategy, market evidence, or concentration event supporting the extra loss. Preserve the base case so the investor can see which difference reflects evidence and which reflects a stress assumption.

Do not automatically add a tenant-default scenario to an allowance that already includes the same tenant and period. Map losses by tenant, unit, month, and cause. A vacancy after a lease termination and an uncollectible balance from an earlier occupied period can both be valid, but their dates and obligations must make the distinction clear.

Use a one-deduction control

Give each material adjustment an identifier and mark the schedules where it appears. A reviewer should be able to trace a concession from its lease amendment to tenant billing and then to the lender bridge without seeing it deducted again under another label. Reconcile the final net figure to collected income or explain the remaining differences.

This control makes the result more reliable in either direction. It prevents an investor from overstating income by omitting a loss and from understating it by repeating the same deduction. Once the starting basis and loss categories are explicit, the lender-specific underwriting method becomes a reviewable calculation rather than a dispute over ambiguous NOI labels.