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.
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).
Physical Occupancy = (Occupied Units ÷ Total Units) × 100% | Economic Occupancy = (Actual Billed Rent ÷ Gross Potential Rent) × 100%| Unit # | Tenant Name | Type / Layout | Sq Ft | Status | Current Rent ($) | Market Rent ($) | Lease Expiry | Notes / Lease Terms | Actions |
|---|---|---|---|---|---|---|---|---|---|
$ | $ | ||||||||
$ | $ | ||||||||
$ | $ | ||||||||
$ | $ | ||||||||
$ | $ | ||||||||
$ | $ | ||||||||
$ | $ | ||||||||
$ | $ |
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.
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.
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.