← ClaudeAtlas

cre-underwritinglisted

Generate an institutional-grade commercial real estate underwriting model — input schema (T-12 income, T-3 trailing, rent roll, debt terms, exit assumptions), calc engine (Cap Rate, NOI, Cash-on-Cash, IRR, DSCR, Debt Yield, ROI, Equity Multiple, levered & unlevered returns), 10-year proforma, sensitivity tables (cap rate × growth × exit cap), partner waterfall (pref + carry tiers), and PDF/Markdown investment memo. Solves the
tinh2/skills-hub-registry · ★ 4 · AI & Automation · score 73
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