real-estate

Automate real estate underwriting with DCF, cap rate, and NAV outputs.

2|Updated Mar 26, 2026
One-click install
npx skills add https://github.com/tmcga/alpha-stack --skill real-estate-tmcga
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: real-estate
Source: https://github.com/tmcga/alpha-stack/tree/main/skills/real-estate
Command: npx skills add https://github.com/tmcga/alpha-stack --skill real-estate-tmcga

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Real estate investment analysis matches the complexity of underwriting across property valuation, development, REIT analytics, debt structuring, and market analysis, enabling transparent, auditable cash-flow models.

Core Features & Use Cases

  • Direct capitalization, DCF (10-year hold), and comparable sales valuation
  • NAV/FFO/AFFO modeling for REITs and equity waterfall analysis
  • Development pro forma, value-add economics, lease analysis, and debt sizing
  • Sensitivity analysis to cap rate movements, occupancy, and rent growth
  • Capital stack design: senior mortgage, mezzanine, and equity layering

Quick Start

Underwrite a stabilized multifamily asset in a selected market using provided NOI and cap rate assumptions.

Frequently Asked Questions about real-estate

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

FAQPage Schema
How do I underwrite a real estate acquisition using DCF and direct capitalization?▼

Real estate underwriting automates DCF and direct capitalization by taking NOI and cap rate inputs to deliver auditable cash-flow models. It applies disciplined valuation across stabilized, value-add, and development opportunities.

Can I model REIT analytics like NAV, FFO, and AFFO for portfolio optimization?▼

Yes, REIT analytics modeling supports NAV, FFO, and AFFO outputs. It handles portfolio optimization by applying transparent cash-flow models to equity waterfall analysis and REIT-level valuation metrics.

What's the best way to structure debt and the capital stack for a development pro forma?▼

Debt structuring designs the capital stack by layering senior mortgage, mezzanine, and equity. It sizes development pro forma debt using explicit LTV and DSCR inputs to ensure rigorous cash-flow modeling.

How does sensitivity analysis work for cap rate movements, occupancy, and rent growth?▼

Sensitivity analysis tests cash-flow models against cap rate movements, occupancy changes, and rent growth assumptions. It delivers auditable outputs that show how value-add economics and lease analysis respond to market shifts.

Does this real estate underwriting tool support value-add economics and lease analysis?▼

Yes, value-add economics and lease analysis are supported. It underwrites acquisitions and development by modeling stabilized opportunities and applying direct capitalization, DCF, and comparable sales valuation.

When do I need explicit NOI, LTV, and DSCR inputs for real estate cash-flow modeling?▼

Explicit NOI, LTV, and DSCR inputs are needed when underwriting acquisitions, development, or REIT analysis. They drive disciplined cash-flow modeling and deliver DCF, direct capitalization, and NAV/FFO/AFFO outputs.