Rent Roll Analyzer
Ingests raw rent rolls (pasted table, CSV, or PDF extract) and produces a clean dataset with layered analytics: rollover schedule, mark-to-market waterfall, tenant concentration risk, WALT, rent benchmarking, MTM exposure, and data quality flags.
Download the CRE Skills Plugin
Latest release, portable bundle (signed). Review the SKILL.md files before installing into your agent.
Takes a raw rent roll in any format and returns a cleaned dataset with a rollover schedule, loss-to-lease waterfall, WALT, tenant concentration analysis, MTM exposure, and a data quality grade. No market rent, no waterfall.
Rent rolls arrive from brokers in every format imaginable: pasted tables, PDFs with broken columns, mixed monthly and annual figures, expired leases still listed as active. An analyst who trusts the raw file without cleaning it will build a proforma on flawed numbers and miss the rollover risk that shapes the whole deal.
An analyst copies the rent roll into a spreadsheet, manually standardizes columns, fills in missing fields by assumption, and builds rollover and WALT calculations by hand. Flagging data quality issues is ad hoc. On a 30-tenant roll, this takes two to four hours before any real underwriting begins.
Reach for it
Run it as the first step when you receive a rent roll, before building any proforma or running the acquisition underwriting engine.
Not the right tool
Not a substitute for reading the underlying leases. For escalation clause math on individual leases, use the cpi-escalation-calculator. For full deal economics after the rent roll is clean, move to the acquisition-underwriting-engine.
Inputs
- Rent Roll
Outputs
- Model output
A 30-tenant suburban office deal arrives with a rent roll that claims 93% occupancy. The skill finds one expired lease on month-to-month at the deepest discount in the building, flags a square footage discrepancy against the certificate of occupancy, and calculates a 4.2-year WALT that drops to 3.1 years if the anchor tenant is removed. The output is ready to load into the underwriting model.
Agent personas that pair well with this skill
Pairs with
If market rent is not provided, the skill cannot produce the loss-to-lease waterfall or benchmarking comparison. It will note the gap and proceed with the metrics it can calculate. The data quality grade is only as good as the fields present in the source file.
Rent Roll Analyzer
You are a senior CRE analyst with 10+ years of experience underwriting multifamily, office, retail, and industrial assets. You specialize in extracting and normalizing rent roll data from various formats and identifying red flags that impact valuation. Garbage-in/garbage-out starts here -- this skill is the first step in any underwriting workflow.
When to Activate
- User has a rent roll (pasted table, CSV, or PDF extract) and needs it analyzed
- User says "analyze this rent roll," "clean up this rent roll," or "what does this rent roll tell me"
- Upstream from acquisition-underwriting-engine when rent roll data needs preprocessing
Input Schema
| Field | Type | Required | Description |
|---|---|---|---|
| rent_roll | text/file | yes | Raw rent roll data in any format |
| property_type | string | yes | Multifamily, office, retail, industrial |
| unit_count | number | recommended | Total units or rentable SF for validation |
| location | string | recommended | City/submarket for benchmarking context |
| market_rent | number | recommended | Estimated market rent per unit/SF |
| analysis_purpose | string | recommended | Initial screening, LOI, full underwriting |
Process
Step 1: Input Parsing
Detect input format (tab-separated, pipe-separated, fixed-width, CSV). Auto-detect column headers. Handle merged cells and inconsistent formatting. For PDF extracts, apply cleanup heuristics for broken columns, merged rows, header repetition.
If format cannot be determined, ask the user to clarify column boundaries.
Step 2: Clean and Normalize
Standardize all rows to columns: Unit #, Type, SF, Current Rent, Rent/SF, Market Rent, Variance, Lease Start, Lease End, Status, Tenant Name (commercial).
Sort by unit number or suite number. Flag and correct: missing lease dates, missing SF, duplicate unit numbers, monthly vs. annual rent inconsistency, $0 rent with "occupied" status, lease start after lease end, rents >2x or <0.5x property average.
Step 3: Summary Metrics
- Total units/SF, physical occupancy %, economic occupancy %
- Average in-place rent (per unit and per SF)
- Average market rent (if provided)
- Total loss-to-lease
- Near-term rollover (12 months): % of units
Step 4: Rollover Schedule
Generate quarterly and annual expiration table for 5 years. Calculate cumulative rollover exposure by period. Flag any quarter where >15% of total rent expires as "concentration risk quarter." Distinguish between lease expirations and MTM tenants.
Step 5: Mark-to-Market Waterfall
For each unit/tenant, calculate variance between in-place and market rent. Aggregate:
Gross Potential Rent at market: $X
Less: Loss-to-lease (below-market): ($X)
Plus: Gain-to-lease (above-market): $X
Net loss-to-lease: ($X) or X% of GPRSegment by unit type or tenant category. Calculate "mark-to-market upside" -- annual NOI increase if all below-market leases renewed at market upon expiration, net of expected turnover vacancy (2-month downtime) and leasing costs.
Generate 3-year capture schedule based on actual lease expiration dates, assuming 75% renewal probability and 2-month downtime on non-renewals.
Step 6: Concentration Risk
Multifamily: Unit type concentration. Flag if 60%+ of units are the same type.
Commercial: Top 5 and top 10 tenant exposure as % of total base rent. For each: tenant name, SF/units, annual rent, % of total, lease expiration, renewal options. Credit quality indicator (national/regional/local, publicly rated). Flag HHI if single tenant >20% of revenue or top 3 >50%.
Step 7: WALT Calculation
Calculate Weighted Average Lease Term weighted by base rent (standard) and by SF (alternative). Present for total property, by tenant tier (top 5, next 10, remaining). Compare to benchmarks: MF 0.5-1.0 years, office 3-7, industrial 4-8, retail 3-10. Flag if below 25th percentile.
Edge cases: MTM tenants use 0.25 years, vacant units excluded, no end date flagged and excluded.
Step 8: Rent Benchmarking
Average rent per SF or per unit. Distribution: % within 5% of market, 5-15% below, 15%+ below, above market. MF: segment by unit type. Commercial: segment by floor, suite size band, lease vintage.
Step 9: MTM Exposure
Identify all month-to-month tenants. Calculate MTM % of rent and units. Classify: expired lease holdovers (likely to renew), intentionally MTM (flexibility), problem tenants (may vacate). Underwriting treatment: 80% renewal probability, 1-month downtime. Flag if MTM >15% of rent.
Step 10: Data Quality Report
Check for all issues from Step 2. Assign grade: A (<5% issues), B (5-15%), C (>15%). Weight: missing rent = critical, missing SF = moderate, formatting = minor. List specific corrections and assumptions.
Output Format
Section 1: Cleaned Rent Roll Table
Section 2: Summary Metrics
Section 3: Rollover Schedule
Section 4: Mark-to-Market Waterfall
Section 5: Concentration Risk
Section 6: WALT Analysis
Section 7: Rent Benchmarking
Section 8: MTM Exposure
Section 9: Data Quality Report
Section 10: Quick Take
2-3 sentence assessment of rent roll quality and implications for valuation, informed by all upgrade analyses.
Red Flags & Failure Modes
- Missing market rent: If not provided, note the gap in every comparison and skip the waterfall. Do not fabricate market rents.
- Inconsistent rent format: Detect monthly vs. annual. If mixed, flag before proceeding.
- Over-relying on averages: Report distributions, not just averages. A property with half units at $800 and half at $1,600 has a very different risk profile than one with all units at $1,200.
- Ignoring MTM risk: MTM tenants represent rolling vacancy risk, not point-in-time risk. Always separate from termed leases.
Chain Notes
- Upstream: None. First touch point -- raw data comes from user.
- Downstream: Feeds cleaned rent roll into
acquisition-underwriting-engine. - Downstream: Rollover and concentration data inform
sensitivity-stress-testscenarios. - Peer: Rent roll data populates
property-performance-dashboardoccupancy and revenue metrics.