Skip to main content
Commercial Real Estate Underwriting Tool

Unit-Level Rent Roll Extractor

Upload, paste, or configure your unit tenant lease schedule to instantly auto-calculate physical occupancy, economic occupancy, gross scheduled rent, average rent per square foot, and vacancy loss for commercial lender underwriting.

Answer-First Canonical Definition

How do commercial lenders use rent rolls to evaluate occupancy and gross rental income?

Commercial real estate underwriters analyze the unit-by-unit rent roll to verify gross contractual income, physical occupancy, economic occupancy, and tenant rollover risk before calculating property Net Operating Income (NOI) and Debt Service Coverage Ratio (DSCR).

Underwriting Formula:Physical Occupancy = (Occupied Units ÷ Total Units) × 100% | Economic Occupancy = (Actual Billed Rent ÷ Gross Potential Rent) × 100%
Institutional Benchmarks
Stabilized Physical Occupancy≥ 90.0%Conventional lender threshold for permanent commercial financing.
Economic Occupancy Variance< 5.0% GapA wide gap between physical and economic occupancy signals concessions or uncollected rent.
Tenant Rollover Risk< 25% Expiry/YrLenders penalize properties with concentrated lease expirations within 12–24 months.
Lender Takeaway: Before submitting your CRE or multifamily loan package, audit your unit rent roll to ensure unit numbers, square footages, contractual rent amounts, and lease expiration dates exactly match the executed lease agreements in your borrower vault.
Governing Standard: FDIC Part 365 Real Estate Lending Guidelines & Interagency Commercial Real Estate Underwriting StandardsOfficial Guidelines
Physical Occupancy
87.5%
< 90%
7 of 8 units leased
Economic Occupancy
85.9%
Collected vs scheduled market
Monthly Billed
$12,325
$147,900/yr actual
Annual Potential
$172,200
$14,350/mo at 100%
Vacancy Loss
$2,025
14.1% of scheduled gross
Avg Rent / SqFt
$2.13
$1,761/unit monthly avg
Unit-by-Unit Lease Schedule (8 units)Under 90% physical occupancy benchmark
Unit #Tenant NameType / LayoutSq FtStatusCurrent Rent ($)Market Rent ($)Lease ExpiryNotes / Lease TermsActions
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
Physical vs. Economic Occupancy

Physical Occupancy (87.5%): Measures leased space against total capacity. High physical occupancy with low economic occupancy indicates rent concessions or collection leakage.

Economic Occupancy (85.9%): Compares actual collected rent against scheduled potential. Banks underwrite actual cash collections rather than theoretical full capacity.

Lease Rollover & Expiration Risk

Underwriters evaluate what percentage of tenant leases expire within the next 12 to 24 months. Concentrated expirations require higher debt service reserve escrows.

Ensure long-term commercial tenants have signed renewals or renewal option notices on file before submitting your loan package.

Market vs. In-Place Rent Delta

Gross Annual Potential is $172,200 vs. current billed rent of $147,900.

The difference of $24,300/yr reflects vacancy loss and loss-to-lease, representing value-add upside for refinancing or acquisitions.

Transfer Rent Roll Data into Underwriting Models

Auto-fill $147,900 annual gross income and 87.5% occupancy directly into your Five C's Capacity assessment or the Real Estate Loan Application wizard.