Turning a rent roll into lender-ready underwritten revenue

A rent roll is a record of apartments and leases at a particular date. It is not automatically an annual revenue forecast. Turning it into lender-ready revenue means showing what is contractually billed, what is forgiven, what is collectible, and what changes over the forecast period. The borrower should be able to trace the result back to individual units and reconcile it to the operating statements.

Freddie Mac's appraisal chapter specifies a borrower-certified rent roll with unit information, contract rent, concessions and other charges, dated within thirty days before the as-is appraisal's effective date.^[1] That is a requirement for the cited appraisal process, not the reporting deadline for every loan. It illustrates the level of detail needed to explain a large multifamily property's income.

Establish the inventory before annualizing rent

Reconcile the rent roll's apartment count to the property's legal and physical inventory. Identify occupied, vacant, model, employee, management-office and unavailable units. A unit removed from the leasing inventory should not disappear from the property's cost or condition analysis. A signed lease with a future start date should not be treated as current collections without an explicit timing assumption.

Use a frozen export for the financing package. Record the report date, accounting cutoff and who certified it. Preserve the original rather than overwriting it when a lease changes. Then provide a change log showing move-ins, move-outs, signed renewals, concessions and material delinquency since that date.

Freddie's servicing reporting chapter separately defines rent-roll information and requires certifications for relevant annual and quarterly assessments.^[2] Those servicing definitions have their own applicability. An owner should not assume that a report accepted after closing also satisfies the appraisal package's recency and detail requirements. Confirm the requested format for each purpose.

Choose a coherent starting rent basis

The two common modeling starting points are contractual rent for occupied units plus a supported rent assumption for vacant units, or a market-rent schedule with a carefully supported bridge to actual leases. Whichever method is used, the final revenue must reflect lease rights and realistic timing. An arbitrary loss-to-lease adjustment cannot correct an unsupported market-rent starting point.

Freddie's explanatory appraisal guidance warns against treating every apartment as if it immediately earns current market rent. It discusses existing leases, renewal decisions, downtime and supported expectations; the current appraisal chapter requires consideration of historical and current rents and comparisons.^[3][1] The durable principle is to model how actual leases change, rather than replace them with the sponsor's preferred end state.

For each material cohort, show lease expiration, expected renewal, renewal rent, vacancy duration, new-lease rent and concession. A building-wide percentage can be useful for a sensitivity, but the underwriting forecast should explain why it fits the actual expiration schedule. A large rent increase on leases that cannot reset for another year has little effect on near-term collections.

Build a revenue bridge without duplicate vacancy

Consider an original hypothetical 400-unit property with 380 occupied apartments, each at $2,500 monthly contractual rent. The twenty vacant apartments have an assumed $2,600 monthly market rent. For a deliberately simplified annual budget, assume the 380 apartments remain occupied at the stated rents, the twenty remain vacant, and no rent escalations occur.

Occupied contractual rent annualizes to $11.4 million. Adding $624,000 of potential rent for the vacant apartments produces $12.024 million of gross potential rent under this defined basis. Subtracting the same $624,000 as vacancy returns the forecast to $11.4 million before concessions and collection loss.

If the model starts directly from the occupied $11.4 million, it must not subtract that vacant-unit allowance again. The allowance was never included in that starting figure. This is a reconciliation issue, not a reason to ignore other expected turnover, vacancy or credit loss. The model's starting basis determines which deductions remain necessary.

Assume 100 occupied leases provide one free $2,500 month inside the budget period. That concession costs $250,000. Add a separate $200,000 estimate of uncollectible rent not already included in concessions. Net residential revenue is $10.95 million. If supported other income is $650,000, total revenue is $11.6 million before operating expense.

Separate a concession from an unpaid receivable

A concession changes what the resident is required to pay under the lease or approved agreement. Delinquency concerns an amount owed but unpaid. A collection-loss forecast concerns the portion expected not to be recovered. The owner's package should explain those categories, their timing and any overlapping accounting entries.

Freddie's appraisal requirements call for analysis of concessions, discounts, abatements, vacancy and collection loss.^[1] Do not simply label every revenue reduction “vacancy.” The detail allows a lender to distinguish a cost of signing leases from weak collectability at already occupied apartments.

Reconcile concessions to signed leases and the resident ledger. Identify whether free rent is recognized when used, spread over a lease term in an accounting report, or reflected in a separate underwriting deduction. Reconcile the forecast on one consistent basis. An owner should not subtract the same lease incentive from both a net-rent ledger and a separate concession schedule.

The OCC's multifamily underwriting discussion directs attention to actual collections, occupancy and leasing conditions; its broader income analysis distinguishes reported cash results from supported stabilized income.^[4] That supports checking a rent roll against collection evidence. A fully occupied apartment with a material unpaid balance cannot be assumed to generate full cash merely because its contract rent remains listed.

Verify other income and expense implications

Break other income into parking, utilities, pet charges, application fees, commercial income and other material categories. Explain whether each receipt is recurring, collectible and associated with a separate expense. A utility reimbursement can produce gross income while corresponding utility bills remain a cash cost. Showing the receipt without the related expense overstates the net benefit.

Freddie's appraisal chapter permits other-income recognition under specified historical, market and continuation conditions.^[1] That rule belongs to its appraisal analysis and should not be expanded into a guarantee that every new fee supports mortgage proceeds. Ask the lender what evidence is needed for a category that has little operating history.

Under the example's assumed $4.5 million recurring operating expense, the $11.6 million supported revenue produces $7.1 million before any separate recurring replacement allowance. By comparison, annualizing all 400 units at $2,600 without vacancy, concessions or credit loss produces $12.48 million of rent and $8.63 million after the same other income and expense. The $1.53 million difference is a revenue assumption, not improved property performance.

At an illustrative 1.30 coverage requirement and 7.4% debt constant, that unsupported difference would imply approximately $15.904 million of extra loan capacity. Neither sizing assumption is a quote. The sensitivity shows why a seemingly small choice about rent-roll treatment can become a material equity surprise.

Deliver evidence rather than a larger spreadsheet

The useful package contains the certified inventory, a rent bridge, lease and concession samples, receivable aging, collection reconciliation, expiration cohorts and support for other income. Explain differences between the frozen rent roll, trailing statements and forecast. Freddie's current appraisal requirements call for explanations when forecast rents or vacancy differ from observed conditions.^[1]

Maintain a second view showing expected monthly cash, especially when concessions are front-loaded. Annual effective revenue can be reasonable while several months have weak collections. The OCC's income-generating-capacity framework calls for testing assumptions under stressed conditions.^[4] An owner can use that approach to compare slower leasing, lower renewals and weaker collections without rewriting the base facts.

The decision output is an auditable revenue forecast. Each increase should have a contractual or operational explanation, and each deduction should appear once. That lets a lender assess the income claim and lets ownership identify whether a proceeds shortfall comes from rent assumptions, timing, collectability or a genuine operating problem.