How to Analyze a Rent Roll
Master rent roll analysis for commercial real estate acquisitions. This guide covers key metrics to calculate, how to assess tenant quality and lease risk, comparing rents to market, and red flags that could sink a deal.
What is Rent Roll Analysis?
A rent roll is a snapshot of a property's tenant roster at a point in time. Rent roll analysis is the process of examining this data to understand income stability, identify risks, and assess value. For commercial real estate investors, it's one of the most critical due diligence activities.
The rent roll tells you who is paying rent, how much they're paying, and how long they're committed. Combined with market data, it reveals whether rents are sustainable, where upside exists, and what risks could impact NOI.
Income Stability
Understand how reliable the property's income stream is based on tenant quality, lease terms, and occupancy levels.
Value-Add Potential
Identify below-market leases expiring soon that can be renewed at higher rents, boosting NOI and property value.
Risk Assessment
Spot concentration risks, rollover exposure, above-market rents, and other factors that could threaten projected returns.
Key Rent Roll Metrics
These are the essential metrics to calculate when analyzing any commercial rent roll. They form the foundation of your due diligence.
| Metric | Formula | Example | What It Tells You |
|---|---|---|---|
| Physical Occupancy | Occupied SF ÷ Total Rentable SF | 45,000 ÷ 50,000 = 90% | Percentage of space under lease |
| Economic Occupancy | Collected Rent ÷ Potential Gross Rent | $85,000 ÷ $100,000 = 85% | Accounts for concessions and bad debt |
| Weighted Avg Lease Term (WALT) | Σ(Rent × Months Remaining) ÷ Total Rent | 4.2 years | Income-weighted avg time to expiration |
| Average Rent PSF | Total Annual Rent ÷ Occupied SF | $1,080,000 ÷ 45,000 = $24/SF | Compare to market for upside/risk |
| Largest Tenant % | Largest Tenant Rent ÷ Total Rent | $25,000 ÷ $100,000 = 25% | Concentration risk indicator |
Pro Tip
Always calculate both physical and economic occupancy. A property can show 95% physical occupancy but only 80% economic occupancy due to concessions, free rent periods, or collection issues.
Step-by-Step: How to Analyze a Rent Roll
Verify Data Quality and Completeness
Before analyzing, ensure you're working with reliable data. A rent roll with errors or missing information will lead to flawed conclusions.
Verify totals match
Sum the rent column and compare to any stated total. Differences indicate missing rows or calculation errors.
Check for missing data
Look for blank lease dates, missing square footage, or empty tenant names. These gaps must be resolved before analysis.
Cross-reference with T12
The rent roll's total monthly rent × 12 should approximately equal the T12's rental income. Large discrepancies need explanation.
Analyze Occupancy and Vacancy
Occupancy is the starting point for understanding a property's income potential. Calculate both physical and economic occupancy to get the full picture.
Physical Occupancy
Occupied SF ÷ Total SF
How much space is under lease? Compare to market averages for the property type and submarket.
Economic Occupancy
Collected ÷ Potential
How much of potential rent is actually collected? Accounts for concessions, bad debt, and collection issues.
Key questions to answer:
- How does occupancy compare to the submarket and property class?
- Is vacancy concentrated in certain unit types or floors?
- How long have vacant units been empty?
- What's the broker's lease-up timeline and is it realistic?
Assess Lease Rollover Risk
Build a lease expiration schedule showing how much rent expires in each year. Heavy concentration of expirations creates risk—if multiple tenants leave or renegotiate at once, NOI can drop significantly.
Example Rollover Schedule
Rollover Risk
In this example, 35% of rent expires in Year 1—a significant concentration. Investigate which tenants are expiring, their renewal probability, and what happens to NOI if they leave or renew at market rates.
Evaluate Tenant Concentration
Identify how much rent depends on your largest tenants. High concentration means if one tenant leaves, the property's income drops dramatically.
Concentration benchmarks:
- Low risk: No tenant >15%, top 3 <40%
- Moderate risk: Largest tenant 15-25%, top 3 40-50%
- High risk: Any tenant >25%, or top 3 >50%
For concentrated tenants, research their credit quality, industry outlook, and remaining lease term. A 30% tenant with 8 years remaining and investment-grade credit is different from one with 18 months left.
Compare Rents to Market
Calculate rent per square foot for each lease and compare to current market rates. This reveals upside potential and rolldown risk.
Below-Market Leases
Tenants paying less than current market rates represent upside potential. When these leases expire, you can renew at higher rents.
Above-Market Leases
Tenants paying more than market represent rolldown risk. At renewal, they may demand lower rent or leave.
Important considerations:
- Compare apples to apples—NNN rents to NNN comps, gross to gross
- Adjust for TI/LC packages given at lease signing
- Consider escalations—a lease signed at $20 with 3% bumps may be at market today
- Weight by square footage to get property-wide mark-to-market
Identify Red Flags and Opportunities
Look beyond the numbers for qualitative factors that affect value. These details are often in the lease abstracts or notes field.
High Near-Term Rollover
highMore than 25-30% of rent expiring within 12 months creates refinancing risk and income uncertainty.
Single Tenant Concentration
highOne tenant representing >25% of rent means significant vacancy risk if they leave or default.
Month-to-Month Leases
mediumMajor tenants on MTM can leave with 30 days notice. Treat as imminent rollover risk.
Below-Market Long Leases
mediumTenants locked in at low rents for years means you inherit unfavorable terms with no near-term upside.
Related Party Tenants
mediumTenants related to the seller may not be arm's-length. Verify they will stay post-sale at stated rents.
Rent Roll / T12 Mismatch
highIf rent roll income doesn't match T12 collected rent, investigate concessions, vacancies, or bad debt.
Recent Tenant Departures
mediumMultiple tenants leaving recently could indicate property issues, management problems, or market softness.
Unusual Lease Terms
lowFree rent periods, TI allowances, early termination rights, or expansion options affect value.
Analysis by Property Type
Different property types have unique considerations when analyzing rent rolls.
Office
- Focus on WALT and tenant credit quality
- Watch for co-working and sublease exposure
- Assess remote work impact on renewal probability
Retail
- Anchor tenant health is critical
- Look for co-tenancy and kick-out clauses
- Analyze percentage rent and sales requirements
Industrial
- Tenant operations fit with building specs
- Clear heights, loading, and power capacity
- E-commerce vs traditional distribution
Multifamily
- Unit mix and floorplan demand
- Turnover rates and renewal percentages
- Rent control / stabilization restrictions
Automate Your Rent Roll Analysis
Manual rent roll analysis is time-consuming. Calculating metrics, building rollover schedules, and comparing to market rents across multiple properties can consume hours per deal. Modern tools can automate much of this work.
Auto-Calculate Metrics
Instantly compute occupancy, WALT, concentration ratios, and rent PSF.
Generate Rollover Schedules
Automatically build lease expiration charts by year, weighted by rent or SF.
Flag Issues Automatically
Detect concentration risks, near-term expirations, and data quality problems.
Export Analysis-Ready Data
Get clean data that feeds directly into your underwriting models.
Analyze Any Rent Roll in Seconds
CleanRoll.ai standardizes and analyzes rent rolls from any source. Upload your file and get key metrics, rollover analysis, and data quality checks instantly.
3 free documents, no credit card required
Frequently Asked Questions
Common questions about rent roll analysis