Rent Roll Analysis Calculator

About the Rent Roll Analysis Calculator

A rent roll is the most fundamental document in multi-family real estate investing. It lists every unit, its current rent, occupancy status, and lease terms. Analyzing the rent roll reveals crucial metrics: average rent, occupancy rate, loss-to-lease (how much below market current rents are), and concentration risk.

Buyers, lenders, and appraisers all request the rent roll as the first document in due diligence. Understanding how to analyze it separates amateur investors from professionals.

This calculator lets you input a simplified rent roll and quickly produces key metrics: total income, average rent, occupancy rate, loss-to-lease, and income per square foot. Use it to evaluate properties quickly or to track your own portfolio's performance.

Homebuyers, investors, and real-estate professionals all benefit from precise rent roll analysis figures when evaluating properties, negotiating deals, or planning long-term investment strategies. Save this calculator and revisit it whenever market conditions or your financial situation changes.

From first-time buyers to seasoned portfolio managers, access to precise rent roll analysis data empowers smarter negotiations, sharper investment analysis, and stronger financial planning. Adjust the inputs above to reflect your specific deal terms and explore how different variables shift the bottom line.

From first-time buyers to seasoned portfolio managers, access to precise rent roll analysis data empowers smarter negotiations, sharper investment analysis, and stronger financial planning. Adjust the inputs above to reflect your specific deal terms and explore how different variables shift the bottom line.

When This Page Helps

Quick rent roll analysis reveals whether a property's income supports its asking price. Loss-to-lease analysis shows value-add potential. Occupancy and average rent trends drive investment decisions.

How to Use the Inputs

1. Enter each unit with its current rent, market rent, square footage, and occupancy status.
2. Mark occupied or vacant for each unit.
3. View the summary: total income, average rent, occupancy, and loss-to-lease.
4. Use the analysis to evaluate acquisition potential or track performance.
5. Add or remove units to match your property.

Example Calculation

Tips & Best Practices

• Always verify the rent roll against actual bank deposits — sellers sometimes inflate numbers.
• Look for units significantly below market rent: these are value-add opportunities.
• Check lease expiration dates for concentration risk: if 50% of leases expire in one month, you face mass turnover risk.
• Compare average rents across unit types to spot pricing anomalies.
• Track rent roll metrics monthly to monitor portfolio health.
• High occupancy (95%+) may mean you're underpriced; consider testing rent increases.

Reading a Rent Roll Like a Pro

Start with occupancy: is it at or above market? Then look at average rents vs. comps: are you at, above, or below market? Calculate loss-to-lease: this is your value-add runway. Finally, check the lease expiration schedule: are expirations spread out or clustered?

Loss-to-Lease as a Value Indicator

A property with $2,000/month in loss-to-lease across 20 units has $24,000/year in untapped income. At a 6% cap rate, capturing that income adds $400,000 in property value. This is exactly why value-add investors buy properties with aging rents.

Seasonal Patterns

Rent rolls fluctuate seasonally. Summer typically shows higher occupancy and rents (peak moving season). Winter shows softer numbers. Always compare rent rolls year-over-year for the same month to identify true trends.

Frequently Asked Questions

• What is a rent roll?

  A rent roll is a snapshot of all units in a rental property showing: unit number, type, square footage, current rent, market rent, occupancy status, tenant name, lease start/end dates, and security deposit. It is the primary income document for multi-family properties.

• What is loss-to-lease?

  Loss-to-lease is the difference between what a tenant currently pays and what the unit would rent for at market rate. If a tenant pays $1,100 but market rent is $1,250, the loss-to-lease is $150/month. Reducing loss-to-lease is the fastest way to increase property income and value.

• What metrics should I look at on a rent roll?

  Key metrics: occupancy rate, average rent, loss-to-lease, rent per square foot, lease expiration schedule, concentration of any single tenant, and trend vs. prior year. These tell you about income stability, upside potential, and risk.

• How often should I review the rent roll?

  Monthly for properties you manage. During acquisition due diligence, request the current rent roll plus trailing 12-month rent rolls to see trends. Compare the rent roll to bank statements to verify accuracy.

• Can a rent roll be misleading?

  Yes. Sellers may include phantom income (from units about to vacate), exclude concessions, or use aspirational market rents. Always verify with bank deposits, tax returns, and physical inspection. "Trust but verify" is the rule.

• What is a good occupancy rate?

  Stabilized properties typically target 93–97% occupancy. Below 90% suggests pricing, condition, or management issues. Above 97% may indicate you're underpriced. Lease-up properties may be 60–80% during initial phases.