cre-skills-plugin

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 rate decomposition, probability-weighted scenarios, replacement cost analysis, and go/no-go recommendation. Triggers on 'underwrite this deal', 'build an acquisition model', or 'run the numbers on this property'.

Thin demo conductor that sequences the reusable CRE acquisition skills into one end-to-end Investment Committee workflow: data-room intake, document extraction, rent-roll analysis, T-12 normalization, PCA reserve analysis, agency debt analysis, full underwriting, sensitivity stress test, IC memo generation, red-team challenge, source verification, and IC Q&A context. It orchestrates and hands off; it does not re-derive numbers itself. Every stage proposes work for human review and pauses at named gates. Triggers on 'run the IC workflow', 'take this deal from data room to IC', 'orchestrate the acquisition', or 'walk this deal to committee'.

Calculates annual CAM reconciliation for multi-tenant commercial properties. Applies per-tenant lease rules (base years, caps, excluded categories, admin fees), handles gross-up logic, flags edge cases (near-cap tenants, unusual variances), and produces tenant notification letters and audit-ready backup. Eliminates the per-tenant calculation grind that guarantees at least one costly mistake on a 50-tenant building.

Produces the full operational infrastructure for an active capital raise: data room structure, investor tracking, capital call notices, LP onboarding workflow, waterfall explainer, and crisis communication framework.

Validates certificates of insurance against lease and contract requirements. Compares coverage types, limits, endorsements, and expiration dates field-by-field, flags deficiencies, and generates cure notices.

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 calculations, replacement cost anchor, and assumption validation.

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 disposition, and determining breakeven hold period. Applies the One Big Beautiful Bill Act's permanent 100% bonus depreciation for qualified property placed in service after 2025-01-19 (and the pre-2025-01-19 TCJA phase-down for earlier placements), and accounts for passive activity limitations and state decoupling.

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, closing condition tracker, and contingency removal strategy. Scales dynamically to 30/45/60/90-day DD periods. Triggers on 'DD period', 'due diligence', 'inspection period', 'feasibility period', or when ordering third-party reports.

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. Triggers on 'quick screen this deal', 'should I look at this?', or any new deal flow needing triage.

Produces a comprehensive sell/hold/refinance analysis with market cycle positioning, tax impact quantification, marginal return on equity, buyer universe assessment, and 15 selectable disposition scenario variants (value-add MF, portfolio 1031, distressed office, sale-leaseback, and more).

Generates individual LP distribution notices with per-investor share calculations, tax characterization, waterfall tier explanation, and batch processing for 50-200+ investors.

Converts a raw CRE data room (OM, T-12, rent roll, PCA, ALTA survey, leases, agency debt quotes) into a single typed fact table with per-fact sourceRefs, extraction confidence scores, and human review state. Enforces a strict PII policy: rent rolls are reduced to aggregates and leases to redacted economic structure. Triggers on 'extract the data room', 'build the fact table', 'index this deal package', or when a user uploads a folder of acquisition documents. Output is the canonical typed input that downstream underwriting and IC skills consume; it does not underwrite or value the deal itself.

Evaluates first-time and second-time CRE fund managers for institutional LP allocation. Different benchmarks, operational DD emphasis, team pedigree assessment, and track record reconstruction from prior employer deals.

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 cover letters, and tracks the signature chase across the entire tenant roster. A single incorrect estoppel can derail a closing.

End-to-end fund formation toolkit covering entity structuring (syndication vs. fund vs. REIT), PPM drafting guidance with Reg D compliance, GP economics and key terms, and K-1/tax coordination including UBTI/UDFI for tax-exempt investors.

Top-level workspace for fund management and LP communications. Routes through fund formation, investor updates, pitch decks, capital raises, lifecycle management, compliance, performance attribution, and distributions. Manages persistent fund context across sessions.

Institutional fund management operations: regulatory compliance monitoring, fee calculations, capital account statements, subscription processing, AML/KYC, Form D filings, LPAC governance, and fund expense ratios. Triggers on 'fund compliance', 'capital account', 'management fee calc', 'LP subscription', 'Form D filing', 'LPAC meeting', 'investor reporting', or when given fund terms, committed capital, and investment activity.

Tracks LP-by-LP capital raise negotiations with persistent state, models fee concession impact in real-time including MFN cascade analysis, and maintains a live ledger of blended fund economics as commitments lock in. Scales from 10-LP seed funds to 300+ LP institutional raises.

Compare fund terms against market norms and produce a terms comparison matrix with fee load analysis and negotiation recommendations. Benchmarks management fee, carried interest, preferred return, clawback, key person clause, GP commitment, fee offsets, and fund life against market data segmented by fund type (closed-end PE, open-end core, co-invest, separate account), fund size, and strategy. Produces total fee load projections at different return scenarios and identifies LP-favorable and GP-favorable outliers. Triggers on 'fund terms', 'term comparison', 'fee benchmarking', 'management fee comparison', 'carry structure', 'promote comparison', 'preferred return', 'clawback', 'key person clause', 'GP commitment', 'fee load analysis', 'terms negotiation', or when an LP needs to evaluate whether a GP's proposed terms are market-competitive.

Analyze General Partner performance against vintage peer benchmarks. Computes fee drag (gross-to-net spread), DPI/TVPI/IRR vs vintage peers, deal-level return dispersion, key person risk, style drift detection, and produces a GP scorecard with performance, fees, risk, and re-up recommendation. Branches by fund strategy (core, value-add, opportunistic), fund vintage, and fund size. Triggers on 'GP performance', 'GP evaluation', 'GP track record', 'vintage benchmark', 'fee drag', 'gross to net spread', 'fund performance analysis', 'manager evaluation', 'GP scorecard', 'DPI TVPI comparison', 'fund quartile ranking', or when an LP needs to evaluate a GP's quantitative performance.

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 variant templates (apartment, NNN, land, bridge, trophy office, industrial).

Pressure-tests a deal recommendation before it reaches the investment committee. Takes underwriting and stress-test outputs and produces a structured adversarial review: known risks (quantified), known unknowns (diligence gaps), unknown unknowns (regime and tail risks), disconfirming-evidence prompts, what-would-break-the-deal trigger thresholds, and the sharp IC challenge questions with the grounded answers the deal team should prepare. Triggers on 'red team this deal', 'pressure-test the recommendation', 'what would the IC ask', 'play devil's advocate', or as the adversarial gate between underwriting and the IC memo.

LP lifecycle management: investor meetings, benchmark comparison, cash management, audit coordination, re-up solicitation, GIPS composites, satisfaction tracking. Triggers: investor meeting, LP relations, benchmark, NCREIF, ODCE, audit PBC, re-up, GIPS, capital call, distribution, investor reporting.

Designs, calculates, and explains joint venture equity waterfall structures for GP/LP partnerships. Three modes: Structure (term sheet from scratch), Calculate (distributions under specific scenarios), Explain (LP-facing plain-language education). Triggers on 'waterfall', 'promote', 'preferred return', 'GP/LP split', 'JV structure', or 'carry'.

Extracts structured data from commercial lease documents (30+ fields), flags ambiguous provisions for legal review, cross-references amendments, and builds the critical dates calendar. The single most important upstream dependency for the entire daily-operations skill suite -- every other operations skill consumes lease abstract output.

Unified lease administration compliance audit covering CAM reconciliation, percentage rent verification, insurance tracking, escalation audits, and environmental compliance. Quantifies revenue recovery opportunities with probability-weighted waterfall analysis. Triggers on 'audit lease compliance', 'CAM reconciliation', 'percentage rent audit', 'insurance certificates', or property disposition/refinancing prep.

Lease amendment drafting, standard lease template refresh, expansion/contraction option analysis, and build-to-suit proposal evaluation for Leasing and Asset Management.

Consolidates 8 complex lease negotiation scenarios into a single skill with scenario selector: (a) anchor replacement with co-tenancy cascade, (b) trophy tower backfill, (c) naming rights valuation, (d) life science TI amortization, (e) sublease consent with recapture NPV, (f) exclusive use violation, (g) specialty conversion IRR crossover, (h) ground lease improvements. Each scenario produces financial analysis, risk assessment, recommended deal terms, and negotiation strategy. Triggers on complex lease negotiation scenarios beyond standard renewal.

Designs optimal lease option packages (renewal, expansion, contraction, termination, ROFO/ROFR, purchase) for asset managers negotiating with tenants. Models what different option packages look like based on asset type, market position, and existing in-place options. Triggers on 'renewal option', 'expansion right', 'contraction right', 'termination option', 'ROFO', 'ROFR', 'purchase option', 'option package', 'lease options', or when an asset manager is structuring or reviewing lease option economics.

Top-level workspace for leasing workflows. Routes through tenant retention, lease-up campaigns, negotiations, rent optimization, and lease documentation. Manages persistent leasing context across sessions.

Analyzes whether to renew an existing tenant or trade out for a new one with full financial comparison. Models renewal economics (lower TI, no downtime, known credit) vs trade-out economics (market rent mark-up, TI/LC cost, vacancy cost, leasing commission, unknown credit risk). Produces NPV comparison with breakeven analysis.

Generates a full-stack lease-up operations plan for new developments, major vacancies, or acquisitions requiring rapid absorption. Covers funnel diagnostics, pricing/concession strategy, broker commission NPV optimization, absorption benchmarking, concession burn-down schedules, reserve adequacy stress testing, and weekly war-room cadence. Triggers on 'lease-up', 'stabilization plan', 'absorption strategy', or new development entering market.

Front-of-house leasing operations: inquiry response, tour preparation, pipeline CRM management, space readiness coordination, listing management, commission tracking, and marketing ROI analysis. Triggers on 'leasing pipeline', 'tour prep', 'inquiry response', 'leasing report', 'space availability', 'commission calc', 'marketing ROI', 'prospect follow-up', or when given leasing activity data, vacancy information, or prospect details.

Marketing material creation, broker event planning, TI cost benchmarking, marketing plan development, and commission structure benchmarking for Leasing Directors.

Prepares quarterly lender compliance certificates using loan-specific financial metric definitions. Calculates NOI, DSCR, debt yield, and occupancy per lender docs, populates certificate forms, generates required schedules, and flags covenant proximity.

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 'draft an LOI', 'build an offer', 'help me structure the bid', or when an acquisitions team is ready to submit.

Generate structured data requests for Limited Partners to send to General Partners across all stages of the LP-GP relationship. Produces request templates for initial due diligence, quarterly monitoring, annual review, and re-up evaluation. Branches by asset class (CRE, PE, credit), fund type (open-end, closed-end, co-invest, separate account), and reporting period. Triggers on 'LP data request', 'GP reporting', 'LP due diligence', 'fund reporting requirements', 'ILPA standards', 'LP questionnaire', 'DDQ', 'data room checklist', 'investor reporting', or when an LP needs to formulate what information to demand from a GP.

Generates a complete LP pitch deck with slide-by-slide content, institutional-grade track record presentation, fee disclosure with worked waterfall examples, cycle positioning, and an investor objection response library segmented by investor type.

Generates structured CRE market research memos covering MSA, submarket, and sector-level conditions. Synthesizes supply/demand fundamentals, rent trends, cap rate movements, capital markets conditions, and forward-looking signals into investment-grade market commentary. Triggers on 'write a market memo', 'market update', 'submarket analysis', or when a user provides market data and asks for a written synthesis. Designed to feed the AMOS deal pipeline and supplement reit-profile-builder output.

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 'reverse price this OM', 'what should I actually pay?', or when an OM needs critical analysis.