CRE Underwriting analysis suite — 3 specialist skills for building pro formas, running sensitivity scenarios, and writing investment committee memos for multifamily acquisitions.
The English summary is being prepared. Showing the original description.
See how to installReview the instructions the agent will receive before you install.
You have access to 3 specialist underwriting skills for commercial real estate multifamily acquisitions.
| 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 |
Read skills/financial-model-builder.mdFor deeper analysis, load knowledge bases:
knowledge/underwriting-calc.md — every CRE financial formulaknowledge/multifamily-benchmarks.md — industry benchmarks by property class and regionIf the user says "$ARGUMENTS", use that to determine which skill to load.
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).
Built and maintained by The AI Consulting Network, the commercial real estate AI consulting practice of Avi Hacker, J.D., and part of CRE Agent Skills, an open-source library of AI skills for commercial real estate.
If this skill saved you time and you want systems like it built inside your firm, reach out. We would love to work with you.
Copyright 2026 Avi Hacker, J.D. / The AI Consulting Network. Licensed under the Apache License 2.0. This attribution notice must be retained in all copies, redistributions, and derivative works of this file.
No reviews yet. Tell others what you thought.
No login needed. Share how it worked for you, ask a question, or note where it did not run.
No comments yet. Be the first to write one.
CRE Asset Management analysis suite — 9 specialist skills for post-acquisition multifamily operations including annual budgeting, monthly variance analysis, rent collection, renewal decisions, lease-up tracking, capex execution, NOI improvement, hold/sell/refi scenario analysis, and quarterly asset review memos.
The English summary is being prepared. Showing the original description.
CRE Brokerage Investment Sales v1 - 8 specialist skills for U.S. seller-side commercial investment sales brokers, covering assignment intake, broker opinion of value, listing proposal, OM and teaser drafting, buyer process management, bid leveling, negotiation support, and PSA-to-close coordination.
The English summary is being prepared. Showing the original description.
CRE Capital Markets and Debt Maturity suite - 8 specialist skills for maturity diagnostics, refinance proceeds gaps, extensions, workouts, rescue capital, term sheet comparison, CMBS special servicing readiness, lender updates, and recap IC memos.
The English summary is being prepared. Showing the original description.
CRE Closing management suite — 2 specialist skills for closing checklist coordination and funds flow preparation for multifamily acquisitions.
The English summary is being prepared. Showing the original description.
CRE Development and Construction suite - 8 specialist skills for U.S. site/entitlement screening, budget and yield-on-cost, construction loan sizing, GC contracts, draw review, schedule risk, lease-up pro forma, and IC memo writing.
The English summary is being prepared. Showing the original description.
CRE Document Ingestion suite — 4 specialist skills for classifying and extracting structured data from deal documents including rent rolls, T-12 financials, and offering memoranda.
The English summary is being prepared. Showing the original description.