Cre-agent-skills cre-underwriting

CRE Underwriting analysis suite — 3 specialist skills for building pro formas, running sensitivity scenarios, and writing investment committee memos for multifamily acquisitions.

install

source · Clone the upstream repo

git clone https://github.com/ahacker-1/cre-agent-skills

Claude Code · Install into ~/.claude/skills/

T=$(mktemp -d) && git clone --depth=1 https://github.com/ahacker-1/cre-agent-skills "$T" && mkdir -p ~/.claude/skills && cp -r "$T/claude-code-plugins/cre-underwriting" ~/.claude/skills/ahacker-1-cre-agent-skills-cre-underwriting && rm -rf "$T"

manifest: claude-code-plugins/cre-underwriting/SKILL.md

source content

CRE Underwriting Suite

You have access to 3 specialist underwriting skills for commercial real estate multifamily acquisitions.

Available Skills

Skill	File	Use When
Financial Model Builder	`skills/financial-model-builder.md`	User needs a 5-year pro forma with NOI, debt service, cash flow, reversion, and return metrics (IRR, equity multiple, CoC)
Scenario Analyst	`skills/scenario-analyst.md`	User wants to stress-test a deal across 27 scenarios varying rent growth, vacancy, and exit cap rate
IC Memo Writer	`skills/ic-memo-writer.md`	User needs to synthesize all analysis into a structured investment committee memorandum with go/no-go recommendation

How to Use

Read the user's request to determine which skill is needed
Load the full skill file — e.g.,
```
Read skills/financial-model-builder.md
```
Follow the Strategy steps exactly
Produce output in the specified format
Run Quality Checks before delivering results

For deeper analysis, load knowledge bases:

```
knowledge/underwriting-calc.md
```
— every CRE financial formula
```
knowledge/multifamily-benchmarks.md
```
— industry benchmarks by property class and region

If the user says "$ARGUMENTS", use that to determine which skill to load.

Quick Reference

Financial Model Builder — Builds: 5-year pro forma (GPI → Vacancy → EGI → OpEx → NOI → Debt Service → Cash Flow → Reversion). Calculates: IRR, equity multiple, cash-on-cash, cap rate, debt yield, DSCR. Models: stabilization, renovation impact, refinancing.

Scenario Analyst — Runs: 27 scenarios (3×3×3 matrix) across rent growth (low/base/high), vacancy (low/base/high), and exit cap rate (low/base/high). Outputs: sensitivity tables, break-even analysis, probability-weighted returns, downside risk quantification.

IC Memo Writer — Produces: 11-section investment committee memo with executive summary, market overview, property description, financial analysis, risk assessment, and go/no-go recommendation. Includes: 3 appendices (pro forma, scenario matrix, comparable sales).