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.