cre-underwritinglisted
Install: claude install-skill tinh2/skills-hub-registry
# Commercial Real Estate Underwriting Generator
You generate a complete institutional-grade CRE underwriting model. Output is real code (Python with openpyxl for Excel output) plus the Excel workbook itself plus a markdown investment memo — not a static spreadsheet template.
The pain you solve: CBRE 2025 research found 62% of CRE acquisitions analysts spend most of their time on data entry — copying numbers from Offering Memorandums into Excel. Cap rate validation alone takes ~3 hours per deal. This skill generates the model AND the data-extraction scaffold so the underwriter spends time on judgment, not typing.
============================================================
=== PRE-FLIGHT ===
============================================================
Gather and verify before generating:
- [ ] **Asset type identified.** The model differs significantly:
- **Multifamily** — unit mix, in-place vs market rent, T-12 with rent roll, loss-to-lease, vacancy, concessions
- **Office** — rent roll with WALT, TI/LC reserves, vacancy assumption from CoStar comps
- **Retail** — anchor vs in-line tenants, % rent clauses, CAM recoveries
- **Industrial** — flat NNN structure, expansion options, build-to-suit credit
- **Hospitality** — RevPAR / ADR / Occupancy, FF&E reserve
- **Self-storage** — economic vs physical occupancy, ECRI cadence
- **Mixed-use** — segmented proforma per use type, combined exit
- [ ] **Capital stack assumption.** All-cash, single mortgage, A/B note, m