Rent Roll Analysis

Rent Roll Summary

A one-look roll-up of the property: unit and occupancy counts, total in-place and market rent, loss to lease, and the source system, so a reviewer can orient before reading unit detail.

Source System

The property management system that produced the export, which drives how every field is mapped and normalized downstream.

Normalized Unit Rent Roll

The core deliverable: one row per unit mapped onto a standard schema so rent rolls from any PMS line up, including vacant, model, down, and employee units, with a source-system label on every row.

Unit Mix Summary

The unit mix aggregated to one row per floor plan, showing counts, average size, occupancy, and average in-place versus market rent and loss to lease by type.

Occupancy and Vacancy Analysis

Physical versus economic occupancy with true rentable vacancy separated from non-revenue model, down, and employee units, and an occupancy count that must foot to total units.

Charge Code Normalization

A crosswalk mapping each source charge code to a standard revenue category (base rent, parking, pet, storage, utility/RUBS, concession) so rent from different systems is comparable and not double-counted.

Concessions and Loss to Lease

Unit-level concessions and the gap between market and in-place rent, with per-unit and portfolio loss-to-lease percentages and outlier flags.

Lease Expiration Schedule and WALT

The lease rollover schedule by period with the share of units and rent expiring, plus weighted average lease term remaining, to surface turnover risk.

Data Quality and Reconciliation

The reconciliation and data-quality checks an analyst runs before trusting a rent roll: unit-count and occupancy footing, rent totals, missing dates, rent outliers, duplicate units, and status-rent mismatches.