cre-excel-dcf-modeler

Generate NOI-based cash flows, debt schedules, and return metrics in Excel.

Updated Feb 1, 2026

Search Tags:#excel #dcf #underwriting #irr #debt-schedule #cre #equity-multiple

Ready to run

npx skills add https://github.com/Agentic-Assets/Agent-Skills --skill cre-excel-dcf-modeler

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: cre-excel-dcf-modeler
Source: https://github.com/Agentic-Assets/Agent-Skills/tree/main/skills/cre-excel-dcf-modeler
Command: npx skills add https://github.com/Agentic-Assets/Agent-Skills --skill cre-excel-dcf-modeler

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

CRE underwriting for CRE acquisitions is time-consuming and error-prone when built from scratch in Excel; this skill provides a structured, repeatable DCF framework with NOI-based cash flows, debt schedules, and investor-return metrics.

Core Features & Use Cases

Institutional-grade CRE underwriting workbook following ARGUS conventions
NOI-based cash flow waterfall with debt schedule, IRR, equity multiple, cash-on-cash, and debt yield
Supports multi-property-type underwriting (office, retail, industrial, multifamily, mixed-use) with IO and amortizing debt, cap rate exits, and sensitivity analysis
Comprehensive validation checks, cross-sheet references, and standard CRE formatting for ready-to-present analyses

Quick Start

Open the CRE Excel DCF Modeler and fill in the Assumptions tab to generate the 7-tab underwriting workbook.

Frequently Asked Questions about cre-excel-dcf-modeler

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I build a CRE DCF model in Excel with a debt schedule and IRR?▼

To build a CRE DCF model in Excel, you need NOI-based cash flows, a debt schedule with IO or amortizing options, and return metrics like IRR and equity multiple, which this modeler automates into a structured 7-tab workbook.

Can I underwrite mixed-use and multifamily acquisitions using the same Excel model?▼

Yes, the same Excel model underwrites mixed-use, multifamily, office, retail, and industrial acquisitions, applying NOI-based cash flows and cap rate exits uniformly across all supported CRE property types.

What's the best way to add sensitivity analysis to a real estate underwriting workbook?▼

The best way to add sensitivity analysis is using a structured DCF framework that includes cap rate exits and varying debt scenarios, generating ready-to-present return metrics like IRR and cash-on-cash.

Does this CRE underwriting model work with ExcelJS workflows?▼

Yes, the generated 7-tab underwriting workbook uses standard CRE formatting, cross-sheet references, and validation checks, ensuring full compatibility with both native Excel and ExcelJS workflows.

How do NOI-based cash flow waterfalls work in commercial real estate underwriting?▼

NOI-based cash flow waterfalls distribute property income by first funding operating expenses and debt service, then allocating remaining cash flows to equity to calculate returns like equity multiple and debt yield.