This is the Hub's skills library, part of how AI.Edge and the A.CRE Accelerator teach the practical application of AI in commercial real estate. Browse them to see how a skill changes your AI's behavior, then try them in Claude, ChatGPT, or Gemini.
Operate the A.CRE Apartment Acquisition Model (file `Original-Apartment-Acquisition-Model-v2_5.xlsx` or any v2.x apartment acquisition model) on the user's behalf, whether uploaded to chat or open…
Operate the A.CRE Ground Lease Valuation Model on behalf of the user, whether the model is uploaded to a chat conversation or open live in Excel via the Claude add-in. Use whenever the user works…
Designs and executes comprehensive 1031 tax-deferred exchange strategies. Manages 45-day identification and 180-day exchange deadlines, evaluates replacement property candidates, prevents common…
Manages active 1031 exchange pipelines: 45-day identification tracking, 180-day close deadline management, replacement property candidate evaluation, boot minimization, reverse exchange mechanics,…
Coordinates the handoff from deal close to an operating asset. Fires when Dealpath
emits the deal-close event (Handoff 1 + Handoff 3 in
reference/connectors/_core/stack_wave4/lifecycle_handoffs.md).…
Full-cycle acquisition underwriting engine. Takes a deal package (rent roll, T-12, OM, financing terms) and produces institutional-quality output: T-12 normalization, 10-year proforma, Linneman cap…
Generates and tracks comprehensive closing checklists for CRE transactions (acquisitions, dispositions, refinancings). Backward-schedules deadlines from closing date, assigns responsibilities,…
Produces a fast, credible comparable analysis (rent comps and sales comps) for active deals, appraisal reviews, or pricing validation. Includes adjustment grids, confidence scoring, effective rent…
Evaluates whether a cost segregation study is worth pursuing for a CRE property by estimating reclassifiable components, quantifying PV of accelerated depreciation, modeling recapture at…
Structures non-traditional acquisition financing using seller participation (carryback notes, master leases, earnouts, JV contributions) and analyzes loan assumption vs. new financing decisions.…
Generates a comprehensive, timeline-driven due diligence plan for commercial property acquisitions with 6 workstream checklists, risk matrix, third-party report ordering guide, decision gates,…
Top-level workspace for deal evaluation. Routes through screening, underwriting, structuring, and IC presentation. Manages persistent deal context across sessions.
Fast go/no-go screening tool for inbound CRE deals. Takes a raw OM, broker email, or listing and returns a KEEP/KILL verdict with back-of-napkin returns, key assumptions, and a diligence checklist.…
Lightweight deal underwriting for single-asset CRE transactions. Computes going-in cap rate, stabilized cap, CoC return, DSCR, levered/unlevered IRR, equity multiple, and breakeven occupancy. Runs…
Generates a comprehensive acquisition strategy for distressed CRE assets acquired through REO, note purchase, special servicing, receivership, or bankruptcy. Covers compressed DD, valuation…
Automates estoppel certificate population for CRE transactions. Performs three-way cross-reference (lease vs. rent roll vs. GL), flags every discrepancy before certificates reach tenants, generates…
Calculate and verify funds flow, prorations, wire instructions, and the settlement statement for CRE acquisition closings. Branches by all-cash vs. financed (single tranche vs. multiple), 1031…
Produces a complete investment committee memo from underwriting outputs: 1-page executive summary with risk-adjusted return framing, full 6-section IC memo body, sensitivity grids, and property-type…
Pre-IC packet assembly for each IC cycle. Assembles the docket, pulls each
deal's memo and cross-references, tracks IC conditions from prior decisions
through to completion, consumes the sensitivity…
Determines the maximum supportable land price by computing residual land value across multiple use types and selecting highest-and-best-use (HBU). Applies entitlement probability discounts, Linneman…
Generates a complete, copy-paste-ready Letter of Intent with negotiation strategy memo, three-tier pricing table, ten non-price levers, seller psychology brief, and broker cover email. Triggers on…
Generates structured CRE market research memos covering MSA, submarket, and sector-level conditions. Synthesizes supply/demand fundamentals, rent trends, cap rate movements, capital markets…
Stochastic simulation engine for CRE returns. Distributional inputs (not just point estimates), correlation matrices, 1000+ trial simulation, percentile return reporting, probability of loss, and…
Deconstructs an offering memorandum to expose the broker's embedded assumptions, reverse-engineers the purchase price needed to hit target returns, and produces a defensible bid range. Triggers on…
Evaluates whether investing capital gains into a Qualified Opportunity Zone Fund produces superior after-tax returns vs. a non-OZ alternative. Quantifies deferral, 10-year exclusion, compliance…
Weekly review of every deal in the pipeline by stage (sourcing, loi_signed,
psa_signed, ic_approved, debt_term_sheet, close, funded). Produces a
stage-by-stage scorecard, flags stalled deals beyond…
Post-acquisition asset onboarding to property management, TI project coordination, and development-to-stabilization transition bridging Acquisitions, PM, and Development.
Pre-close shadow setup. Fires at IC approval (Handoff 1 in
reference/connectors/_core/stack_wave4/lifecycle_handoffs.md) before the deal
actually closes. Creates placeholder property in AppFolio…
Per-deal closing discipline. Tracks PSA / financing key-date countdown
(LOI expiry, PSA expiry, DD period end, financing contingency, close
target, tax lookback), open contingencies and their…
Analyzes a Purchase & Sale Agreement draft, identifies problematic provisions, and produces a risk-tiered redline strategy with specific markup language, negotiation talking points, and a battle…
Standardizes rent roll data from any source format into a consistent underwriting template, validates data integrity (SF reconciliation, revenue reconciliation, date consistency, rent…
Takes a completed base case underwriting and produces comprehensive sensitivity analysis, stress testing, and breakeven analysis. Generates tornado charts, multi-dimensional sensitivity grids,…
Full-lifecycle CRE deal sourcing engine: target identification, lead scoring (0-100), multi-channel outreach (mail, call, email, LinkedIn), broker relationship cultivation, CRM pipeline schema, and…
Produces a decision-grade submarket brief that strips broker narratives to reveal what is actually happening in a market. IC-memo-ready output with no-fluff mandate, range-based forecasting, supply…
Produces a forward-looking supply/demand analysis for a specific submarket and property type. Combines quantitative pipeline tracking with disruption overlays (PropTech, ESG/climate, insurance…
Normalizes trailing 12-month operating statements for CRE acquisition underwriting. Removes one-time items, reprices below-market contracts, adjusts for tax reassessment, grosses up for vacancy,…
Analyze ALTA title commitments, surveys, and Schedule B exceptions for CRE acquisitions. Identifies title defects, chain breaks, lien conflicts, and cure requirements. Triggers on 'title…
Prepare entity transfer documents, closing document packages, and assignment agreements for CRE acquisitions. Branches by entity type (LLC, LP, DST, UPREIT, C-Corp, S-Corp, trust), ownership chain…