Rent roll · Loan documents

Underwrite the rent roll unit by unit, with every figure on its page.

Rent roll analysis for lenders ties every row to the T-12 and the leases before a figure reaches the credit decision. Occupancy, rollover and in-place rent arrive with the page each came from, and a flag shows where the roll and the file disagree. Your analyst picks up where LenderBox stops.

RENT ROLL · ILLUSTRATIVE96 UNITS · AS OF 09/30/2026
The roll as the borrower sent it, read row by row
96-UNIT APARTMENT COMMUNITY · RENT ROLL AS OF 09/30/2026 · PAGE 1 OF 2
UNITRENTSTATUSSTARTEND
5101Resident1,285.00Leased11/01/2510/31/26
2102Resident1,275.00MTM07/01/2506/30/26
103Vacant1,295.00Vacant
104Resident1,310.00Leased03/01/2602/28/27
105Resident1,300.00Leased09/01/2608/31/27
106Resident1,280.00Leased01/01/2612/31/26
107Resident1,290.00Leased06/01/2605/31/27
5108Resident1,265.00Leased12/01/2511/30/26
88 MORE UNITS ON PAGES 1 AND 2 · PAGE 2 SUMMARY
Total units96
1Occupied91 · 94.8%
Vacant5 · 5.2%
2Month to month4
3Gross potential rent, monthly123,833.33
4Average rent per unit1,289.93
READ FROM THIS DOCUMENT, EACH FIGURE CITED
1Occupancy91 of 96 · 94.8%Rent roll, p. 2
2Month to month4 unitsRent roll, pp. 1 to 2
3Gross potential rent$1,486,000 a yearRent roll, p. 2
4Average rent$1,290 a unitRent roll, p. 2
5Rolling within six months50 units · 54.9%Rent roll, pp. 1 to 2
Economic loss above physical vacancy6.0%
The roll shows 5.2% of units empty. The T-12 lost $89,000 to vacancy, concessions and bad debt, 6.0% of gross potential rent, so the higher figure is underwritten.
Rent roll, p. 2T-12, p. 3
What a credit officer checks on a rent roll

Six tests the roll has to survive before committee.

All 96 rows are tested against the T-12, the leases, the estoppel and the market, on the illustrative 96-unit refinance.

THE CHECKON THE SAMPLE FILE · ILLUSTRATIVE
The roll against the T-12
With rents flat over the year, scheduled rent annualized should equal gross potential rent on the operating statement.
TIES OUT
$123,833.33 a month, times 12, is $1,486,000: the T-12 figure.
Rent roll, p. 2T-12, p. 3
Physical vacancy against economic loss
Empty units on the rent roll date, set beside what the property actually lost to vacancy, concessions and bad debt.
FLAGGED
5.2% physical against 6.0% economic. Underwritten at the greater of the T-12 actual and the 5.0% policy floor: $89,000.
Rent roll, p. 2T-12, p. 3
Lease rollover
Expirations by month, with month-to-month leases counted as expiring now.
ON THE RECORD
The busiest month has 9 expirations, 9.9% of occupied units. 50 units, 54.9%, are month to month or roll within six months, as expected on 12-month apartment leases.
Rent roll, pp. 1 to 2
Concentration
The largest resident and any non-residential lease, measured against income.
TIES OUT
Largest resident: one unit, 1.1% of occupied units. The rooftop antenna lease brings $14,400 a year, 1.0% of effective gross income, and is confirmed by estoppel.
Rent roll, p. 2T-12, p. 3
Concessions
Free rent and recurring discounts in the lease addenda, set beside the concession line on the T-12.
ON THE RECORD
$5,800 of concessions over the year, 0.4% of gross potential rent. Ten residential leases are audited against their rows on the roll.
T-12, p. 3Leases
In-place rent against market
Rents well above the market may not renew at the same level.
TIES OUT
Average rent of $1,290 a unit is in line with its market, shown as market data from third-party data providers.
Rent roll, p. 2Market data
What LenderBox returns

All 96 rows, reduced to the figures behind the decision.

Your analyst starts from figures that already agree, or from a flag that says exactly where they do not.

CITED TO THE PAGEEvery figure from the rent roll is cited to its document and page, so a reviewer opens page 2 from the number itself.
FLAGGED, WITH THE REASONWhere the roll and the T-12 disagree, both figures arrive side by side with their pages for your analyst to settle.
HELD FOR A PERSONUnclear rows hold the review open until your analyst has signed off on every one of them.
CURRENT, OR ASKED FOR AGAINYour policy sets how old a rent roll can be; an older one is flagged and a current one requested from the borrower before committee.
See the rent roll inside a complete spread →
WHERE THE FIGURES GO · ILLUSTRATIVESAME SAMPLE FILE
Gross potential rent into coverage, sizing and the memo
SPREADGross potential rent $1,486,000
Rent roll, p. 2
POLICY CHECKCoverage 1.31x against your 1.25x minimum
T-12, p. 3Policy §4.1
MAXIMUM SUPPORTABLE LOAN$9,252,146, set by the stress test
CREDIT MEMOOccupancy and rollover drafted into the property section, each figure cited

Which rent roll, which vacancy, which reserve.

Reading the roll
LENDERBOX DOESReads all 96 rows in whatever layout the property manager exported, and cites each figure to its page.
STAYS WITH YOUR TEAMWhich rent roll is the controlling version when two arrive.
Tying out
LENDERBOX DOESSets the roll beside the T-12 and the leases and shows every gap with both pages.
STAYS WITH YOUR TEAMWhich figure to rely on when they disagree.
Vacancy
LENDERBOX DOESShows physical vacancy, economic loss and your policy floor side by side.
STAYS WITH YOUR TEAMThe vacancy and credit loss figure you underwrite.
Rollover and market
LENDERBOX DOESBuilds the expiration schedule and sets in-place rent beside its market.
STAYS WITH YOUR TEAMWhether renewal risk calls for a reserve or a change in structure.
The memo
LENDERBOX DOESDrafts occupancy, rollover and vacancy into the property section.
STAYS WITH YOUR TEAMThe recommendation your committee votes on.

Each rent roll the loan sees, until it is repaid in full.

01 · FIRST LOOKA summary roll in the offering memo returns policy flags and a first sizing before anyone opens the full file.
02 · UNDERWRITING · THIS DOCUMENTThe full roll is read, tied to the T-12 and the leases, and spread.
03 · CREDIT DECISIONCommittee sees occupancy, rollover and the vacancy it underwrote, each figure cited.
04 · CLOSINGThe ten lease audits are cleared before closing.
05 · LIFE OF THE LOANEach new rent roll is read against the underwriting case, with covenant monitoring on the loan.

Rent roll questions from the underwriting desk

Does it read every row of the rent roll?

Yes, every row: unit, tenant, lease start and end, rent and status, plus the totals. From them it reports occupancy, gross potential rent, average rent, month-to-month leases and the expiration schedule, each cited to the page it came from.

Does it check the rent roll against the T-12?

Yes. Annualized rent is set beside gross potential rent on the operating statement, and physical vacancy beside the T-12 vacancy and credit loss. Where they disagree, both figures appear with their pages, and your analyst decides which one to rely on.

Can the rent roll arrive in any format?

Yes. Rent rolls can arrive as spreadsheets, Word files, scans or PDFs, in whatever layout the property manager used. A figure LenderBox is unsure of waits for your analyst to confirm.

Does it handle office, retail and industrial rent rolls?

Yes. Multifamily, hotel, retail, office, industrial and mixed-use deals are covered. On a commercial property, expirations by tenant and by year, and tenant concentration, are read from the rent roll and the leases.

How are month-to-month leases on the roll treated?

As expiring now. On the sample, four units are month to month; with leases rolling within six months, that is 50 units.

Send the rent roll your analysts dread.

Bring your messiest rent roll. The demo can run on your own deal documents, unit by unit, with each figure on its page.

Bring a deal
30 MINUTES. NO COMMITMENT. 90-DAY MONEY-BACK GUARANTEE.
Not ready to talk? See pricing