租金名册分析计算器公式

## 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

- **Gross Potential Rent (GPR)**: Total income if every unit were leased at market rate
- **Loss-to-Lease**: Revenue lost because current rents are below market rate
- **Vacancy Loss**: Revenue lost from unoccupied units
- **Collection Loss**: Revenue lost from non-payment or delinquency
- **Effective Gross Income**: What you actually collect

### 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.

计算示例

8-unit property, 7 occupied at $1,350 average rent, market rent $1,550, 3% collection loss.

  1. Gross potential rent: 8 x $1,550 x 12 = $148,800
  2. Current scheduled income: 7 x $1,350 x 12 = $113,400
  3. Loss-to-lease: 7 x ($1,550 - $1,350) x 12 = $16,800
  4. Collection loss: $113,400 x 3% = $3,402
  5. Effective gross income: $113,400 - $3,402 = $109,998
  6. Occupancy rate: 7 / 8 = 87.5%
  7. Current rent as % of market: $1,350 / $1,550 = 87.1%