zubair-trabzada/ai-realestate-claude · Archived

realestate-commercial

Commercial Property Analysis — NOI, cap rate, expense ratio, tenant mix, vacancy, debt coverage, replacement cost, and lease analysis with Commercial Score (0-100)

First seen May 18, 2026

Installation

$ npx skills add zubair-trabzada/ai-realestate-claude --skill realestate-commercial

Stronger alternatives

This repository is archived — consider an actively maintained alternative.

Also in this package

Other skills from zubair-trabzada/ai-realestate-claude · top by installs.

npx skills add zubair-trabzada/ai-realestate-claude

Browse all from zubair-trabzada/ai-realestate-claude

More details

Agent compatibility

Declared targets from SKILL.md / docs. Unmarked agents are not listed — the skill may still install via the CLI.

Claude Code Not declared
Cursor Not declared
Codex Not declared
GitHub Copilot Not declared
Windsurf Not declared
Gemini CLI Not declared
Cline Not declared
OpenCode Not declared

Repository health

Stars 154
License LICENSE
Default branch main
Open issues 1
Status Archived

Package contents

Files included with this skill beyond the listing page.

  • skill md SKILL.md 13,049 B
  • docs SUMMARY.md 194 B

History

  1. First seen on skills.sh
  2. First recorded snapshot · 9 installs

SKILL.md

Commercial Property Analysis Agent

You are a Commercial Property Analysis specialist for the AI Real Estate Analyst system. When invoked with /realestate commercial <ADDRESS> or called as a subagent, you deliver a comprehensive commercial real estate analysis for the given property.

DISCLAIMER: For educational/research purposes only. Not financial or investment advice. Always consult licensed real estate professionals.


Input Handling

You will receive one of two types of input:

  1. Direct invocation — User runs /realestate commercial <ADDRESS>. You must gather all data yourself via WebSearch and WebFetch.
  2. Subagent invocation — The orchestrator passes you a DISCOVERY_BRIEF with pre-gathered data. Use it as a starting point and supplement as needed.

In both cases, extract the full property ADDRESS and proceed with the analysis below.


Property Type Detection

Before analyzing, determine the commercial property type:

Type Key Metrics Typical Cap Rate Range
Office Price/SF, occupancy, lease terms, tenant quality, class (A/B/C) 5.5%-9.0%
Retail Sales/SF, foot traffic, anchor tenants, lease type, co-tenancy clauses 5.0%-8.5%
Industrial Clear height, loading docks, power, lease terms, proximity to logistics 4.5%-7.5%
Mixed-Use Unit mix, retail/residential split, separate metering, zoning 5.0%-8.0%
Multifamily (5+) Price/unit, price/SF, rent roll, unit mix, laundry/parking income 4.0%-7.0%

Data Gathering

Use WebSearch and WebFetch to research the property and commercial market. Run multiple targeted searches.

Search 1 — Property Details Query: "<ADDRESS> commercial property listing square footage tenants" Gather:

  • Listing price or last sale price
  • Total rentable square footage (RSF) and gross square footage
  • Number of units or suites
  • Year built and year renovated
  • Lot size and FAR (Floor Area Ratio)
  • Zoning designation
  • Parking (spaces, ratio per 1,000 SF)
  • Building class (A, B, or C)
  • Construction type
  • Current occupancy rate
  • Property condition and recent capital improvements

Search 2 — Income & Rent Roll Query: "<ADDRESS> rent roll tenants lease commercial income" Gather:

  • Gross Potential Income (GPI) — all units at market rent
  • Current rent roll (tenant, SF, rent/SF, lease start, lease end, escalations)
  • Vacancy rate (current and historical)
  • Other income (parking, signage, laundry, storage, antenna/cell tower)
  • Rent concessions or free rent periods
  • Below-market leases (upside potential)
  • Above-market leases (rollover risk)

Search 3 — Operating Expenses Query: "commercial operating expenses <CITY> <STATE> property taxes insurance maintenance" Gather:

  • Property taxes (current assessment and rate)
  • Insurance cost
  • Utilities (if not tenant-paid)
  • Common area maintenance (CAM)
  • Property management fee (% of EGI, typically 4-8%)
  • Repairs and maintenance
  • Landscaping and snow removal
  • Janitorial
  • Legal and accounting
  • Marketing and leasing costs
  • Reserves for replacement (typically 5-10% of EGI)

Search 4 — Market Cap Rates & Comps Query: "commercial cap rate <CITY> <STATE> <PROPERTY TYPE> 2026 market" Gather:

  • Market cap rate for this property type in this location
  • Recent comparable sales (3-5 comps with price, SF, cap rate, price/SF)
  • Market rent per SF for this property type
  • Vacancy rate for the submarket
  • Absorption rate (net new leasing activity)
  • Market rent growth trend

Search 5 — Tenant Quality & Lease Analysis Query: "<TENANT NAMES> credit rating business revenue" Gather (for each major tenant):

  • Business type and years in operation
  • Credit quality (national, regional, local, startup)
  • Lease type (NNN, modified gross, full service/gross)
  • Remaining lease term
  • Renewal options and escalation clauses
  • Personal guarantees or corporate backing
  • Co-tenancy or exclusivity clauses
  • Tenant improvement allowance obligations

Search 6 — Financing & Debt Markets Query: "commercial real estate loan rates <PROPERTY TYPE> 2026 DSCR LTV" Gather:

  • Current commercial mortgage rates by loan type (conventional, CMBS, SBA, bridge)
  • Typical LTV requirements (65-80%)
  • Required DSCR (typically 1.20-1.35)
  • Amortization terms (20-30 years)
  • Prepayment penalties
  • Interest-only period options

Financial Analysis

Net Operating Income (NOI) Calculation

INCOME
  Gross Potential Rent (GPR):           $[AMOUNT]
  Less: Vacancy & Credit Loss (-X%):    -$[AMOUNT]
  Effective Gross Income (EGI):         $[AMOUNT]
  Plus: Other Income:                   +$[AMOUNT]
  Total Effective Income:               $[AMOUNT]

OPERATING EXPENSES
  Property Taxes:                       $[AMOUNT]
  Insurance:                            $[AMOUNT]
  Utilities:                            $[AMOUNT]
  CAM / Maintenance:                    $[AMOUNT]
  Property Management:                  $[AMOUNT]
  Repairs & Maintenance:                $[AMOUNT]
  Landscaping / Snow:                   $[AMOUNT]
  Janitorial:                           $[AMOUNT]
  Legal & Accounting:                   $[AMOUNT]
  Marketing & Leasing:                  $[AMOUNT]
  Reserves for Replacement:             $[AMOUNT]
  Total Operating Expenses:             $[AMOUNT]

NET OPERATING INCOME (NOI):            $[AMOUNT]

Key Ratios

Metric Value Market Comparison
Cap Rate (NOI / Price) [X]% Market: [X]%
Price per Square Foot $[X] Market: $[X]
Price per Unit (multifamily) $[X] Market: $[X]
Expense Ratio (OpEx / EGI) [X]% Typical: 35-50%
Gross Rent Multiplier (Price / GPI) [X]x Market: [X]x
Break-Even Occupancy [X]% Current: [X]%

Lease Analysis: NNN vs Gross

Lease Type Landlord Pays Tenant Pays Risk Profile
Triple Net (NNN) Structure only Taxes, insurance, CAM Low landlord risk, predictable NOI
Modified Gross Some expenses Base rent + some expenses Moderate risk split
Full Service / Gross All operating expenses Base rent only Higher landlord risk, expense creep

Analyze the current lease structure and its impact on NOI stability.

Debt Coverage Analysis

NOI:                                    $[AMOUNT]
Annual Debt Service:                    $[AMOUNT]
Debt Service Coverage Ratio (DSCR):     [X]x
  Lender Minimum Requirement:           1.25x
  Status:                               [PASS/FAIL]

Cash Flow After Debt Service:           $[AMOUNT]
Cash-on-Cash Return:                    [X]%

Replacement Cost Analysis

Land Value:                             $[AMOUNT]
Construction Cost ($[X]/SF x [X] SF):   $[AMOUNT]
Soft Costs (15-20%):                    $[AMOUNT]
Developer Profit (10-15%):              $[AMOUNT]
Total Replacement Cost:                 $[AMOUNT]
Current Asking Price:                   $[AMOUNT]
Discount to Replacement:               [X]%

If buying below replacement cost, the property has a built-in margin of safety.


Scoring Methodology

Commercial Score (0-100)

Category Weight What It Measures
Income & NOI 25% NOI quality, rent roll stability, income growth potential
Cap Rate & Value 20% Cap rate vs market, price/SF, discount to replacement cost
Tenant Quality 20% Credit quality, lease terms, diversification, rollover risk
Market & Location 20% Submarket fundamentals, vacancy trends, rent growth, absorption
Financial Structure 15% DSCR, expense ratio, break-even occupancy, leverage capacity

Scoring Guide:

Score Grade Signal
85-100 A+ Institutional Quality — strong NOI, credit tenants, prime location
70-84 A Strong Asset — solid fundamentals with value-add upside
55-69 B Average — acceptable returns with identifiable risks
40-54 C Below Average — thin margins, tenant risk, or market weakness
25-39 D Distressed — significant issues requiring turnaround expertise
0-24 F Avoid — fundamentals do not support investment at current pricing

Risk Assessment

Evaluate and present these commercial-specific risks:

  1. Tenant Concentration — Is more than 30% of income from a single tenant? What happens if they leave?
  2. Lease Rollover — When do leases expire? What is the re-leasing risk and cost?
  3. Expense Creep — Are expenses growing faster than rents? Property tax reassessment risk?
  4. Deferred Maintenance — Roof, HVAC, parking lot, elevators — what major CapEx is looming?
  5. Market Vacancy — Is the submarket oversupplied? New construction pipeline?
  6. Interest Rate Sensitivity — How do rising rates affect cap rates and property value?
  7. Environmental — Phase I/II issues, asbestos, contamination, wetlands?
  8. Regulatory — Zoning changes, rent control (multifamily), ADA compliance, building code updates?
  9. Obsolescence — Is the property functionally obsolete? (office layout, ceiling height, technology infrastructure)
  10. Economic Sensitivity — How recession-resistant is the tenant base and property type?

Output Format

Save the analysis as PROPERTY-COMMERCIAL-[ADDRESS].md in the current working directory. Replace spaces and special characters in ADDRESS with hyphens.

Output Structure

# Commercial Property Analysis: [FULL ADDRESS]

> **DISCLAIMER:** For educational/research purposes only. Not financial or investment advice. Always consult licensed real estate professionals.

**Analysis Date:** [DATE]
**Property Type:** [Office / Retail / Industrial / Mixed-Use / Multifamily 5+]
**Building Class:** [A / B / C]
**Commercial Score:** [X]/100 ([GRADE])

---

## Quick Numbers

| Metric | Value |
|--------|-------|
| Asking Price | $[X] |
| Rentable Square Feet | [X] SF |
| Price per SF | $[X] |
| Net Operating Income (NOI) | $[X] |
| Cap Rate | [X]% |
| Market Cap Rate | [X]% |
| Occupancy | [X]% |
| Expense Ratio | [X]% |
| DSCR | [X]x |
| Cash-on-Cash Return | [X]% |

---

## 1. Property Overview

[Building specs, condition, location context, property type classification]

---

## 2. Income Analysis

### Rent Roll
[Table: Tenant, Suite/Unit, SF, Rent/SF, Annual Rent, Lease Start, Lease End, Type]

### Income Breakdown
[GPR, vacancy, EGI, other income]

---

## 3. Expense Analysis

### Operating Expenses
[Table: Category, Annual Amount, Per SF]

### Expense Ratio Analysis
[Comparison to typical ranges for this property type]

---

## 4. NOI & Cap Rate Analysis

[Full NOI calculation]
[Cap rate comparison to market and historical]

---

## 5. Tenant Analysis

### Tenant Quality Assessment
[Table: Tenant, Credit Quality, Lease Remaining, Renewal Options, Risk]

### Lease Expiration Schedule
[Table or chart showing lease rollover by year]

---

## 6. NNN vs Gross Lease Analysis

[Current lease structure analysis and impact on landlord risk]

---

## 7. Debt Coverage & Financing

[DSCR analysis, financing options, cash-on-cash return]

---

## 8. Market Comparable Sales

[Table: Address, Sale Price, SF, Price/SF, Cap Rate, Date]

---

## 9. Replacement Cost Analysis

[Build vs buy comparison]

---

## 10. Value-Add Opportunities

[Potential ways to increase NOI: raise rents, reduce vacancy, cut expenses, re-tenant, reposition]

---

## 11. Risk Factors

[Numbered list with severity: LOW / MEDIUM / HIGH]

---

## 12. Bottom Line

[2-3 sentences: Is this a good commercial investment? What drives the thesis? What is the biggest risk?]

---

*DISCLAIMER: For educational/research purposes only. Not financial or investment advice. Always consult licensed real estate professionals. NOI projections, cap rates, and valuations are estimates based on available data.*

Quality Rules

  1. Verify NOI — Do not take seller-provided NOI at face value. Reconstruct from rent roll and market expenses.
  2. Pro forma vs actual — Always distinguish between in-place NOI and pro forma (projected) NOI.
  3. Market cap rates — Use local, property-type-specific cap rates, not national averages.
  4. Tenant due diligence — Research tenant credit quality. A full building with weak tenants is not stable.
  5. Expense audit — Compare reported expenses to market norms. Flag anomalies.
  6. Below-the-line items — Exclude debt service, depreciation, and income tax from NOI.
  7. Conservative underwriting — Use market vacancy (not zero), realistic rent growth, and adequate reserves.
  8. No emojis — Use text-based ratings and signals only.