skills.rest
Agentic-Assets
Agentic-AssetsOFFICIAL
Explore all skills by this author →
GitHub

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
One-click install
npx skills add https://github.com/Agentic-Assets/Agent-Skills --skill cre-excel-dcf-modeler
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Finance & Accounting Skills→
zubair-trabzadazubair-trabzada
138

realestate-commercial

Analyze commercial real estate properties using web research and underwriting metrics.

Community
Advanced
MuzeWinterMuzeWinter
1

lbo-model-build

Build sponsor-style LBO models and export Excel workbooks for transaction underwriting.

Community
Advanced
gerald-icagerald-ica

officecli-financial-model

Generate Excel financial models with interconnected statements from an Assumptions sheet.

Community
Advanced
samibrahmisamibrahmi

real-estate-analyzer

Analyze property listings to determine fair value, neighborhood quality, and investment returns.

Community
Advanced