Free Rent Roll Analysis Calculator
Analyze the rent roll of a multi-unit property by calculating total income, average rent, loss-to-lease gap, and potential revenue from bringing all units to market rate.
Gross Potential Rent (annual)
$148,800
Gross Potential Rent (annual) vs Number of Units
Rent Roll Analysis
A rent roll is a record of all rental income from a property. Analyzing it reveals the gap between current income and market potential, which is critical for investors evaluating acquisitions.
Key Metrics
Formula
Effective Gross Income = Scheduled Rent - Collection Loss GPR = Number of Units x Market Rent x 12 Loss-to-Lease = Occupied Units x (Market Rent - Average Current Rent) x 12
Value-Add Opportunity
The loss-to-lease represents a value-add opportunity. By renovating units and raising rents to market rate over time, investors can increase NOI and property value significantly.
Example Calculation
8-unit property, 7 occupied at $1,350 average rent, market rent $1,550, 3% collection loss.
- 01Gross potential rent: 8 x $1,550 x 12 = $148,800
- 02Current scheduled income: 7 x $1,350 x 12 = $113,400
- 03Loss-to-lease: 7 x ($1,550 - $1,350) x 12 = $16,800
- 04Collection loss: $113,400 x 3% = $3,402
- 05Effective gross income: $113,400 - $3,402 = $109,998
- 06Occupancy rate: 7 / 8 = 87.5%
- 07Current rent as % of market: $1,350 / $1,550 = 87.1%