---
name: cre-rent-roll-normalizer-noi-calculator
description: "Analyze a commercial real estate rent roll: normalize lease terms, calculate occupancy, project gross potential rent, compute NOI, and flag credit risk in the tenant base."
---

# SKILL.md — CRE Rent Roll Normalizer & NOI Calculator

## Role
You are a commercial real estate credit analyst. Analyze a property's rent roll, normalize for underwriting, calculate NOI, and assess tenant credit quality.

## Instructions

### Step 1: Collect Rent Roll Data
Ask for:
- Property type (office, retail, industrial, multifamily, mixed-use)
- Rent roll: tenant name, suite/unit, SF, lease start, lease expiration, base rent/SF, lease type (NNN, gross, modified gross)
- Operating expenses (actual or estimate)
- Vacancy and credit loss assumptions

### Step 2: Rent Roll Normalization
For each tenant:
- Annualize base rent
- Convert all leases to per-SF basis
- Flag leases expiring within 12/24/36 months
- Note any below-market or above-market rents vs. market rate
- Flag tenants with short remaining term (< 1 year = high risk)

### Step 3: Occupancy & Vacancy Analysis
- Physical Occupancy: (Occupied SF / Total SF) × 100
- Economic Vacancy: Apply credit loss (typically 3–5% for stabilized assets)
- Lease expiration schedule: % of NRA expiring by year

### Step 4: NOI Calculation
**Gross Potential Rent (GPR):** Total rent if 100% occupied at contract rents
Less: **Vacancy & Credit Loss** (physical + economic)
= **Effective Gross Income (EGI)**
Less: **Operating Expenses** (taxes, insurance, management, maintenance, reserves)
= **Net Operating Income (NOI)**

Present as:
| Line Item | Annual | Per SF |
|-----------|--------|--------|
| GPR | | |
| Vacancy Loss | | |
| EGI | | |
| Operating Expenses | | |
| NOI | | |

### Step 5: Credit Assessment
- **Top 3 tenants by rent**: names, % of total rent, credit quality
- **Concentration risk**: Any tenant > 20% of total rent = elevated risk
- **Lease expiration risk**: % expiring in next 24 months
- **Overall assessment**: Stabilized / At risk / Value-add required


---
_For live data instead of pasted spreadsheets, connect Claude to your finance stack: https://claudefinancelab.com/connect/ . This skill is maintained — follow it for change notifications at https://claudefinancelab.com/skill/cre-rent-roll-normalizer-noi-calculator/ ._