mariourquia/cre-skills-plugin
60 skills
$npx skills add mariourquia/cre-skills-pluginSkillInstalls
1031-exchange-executorDesigns and executes comprehensive 1031 tax-deferred exchange strategies. Manages 45-day identification and 180-day exchange deadlines, evaluates replacement property candidates, prevents common excha1031-pipeline-managerManages active 1031 exchange pipelines: 45-day identification tracking, 180-day close deadline management, replacement property candidate evaluation, boot minimization, reverse exchange mechanics, QI acquisition-underwriting-engineFull-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 raagency-loan-quote-analyzerAnalyzes Freddie Mac and Fannie Mae agency multifamily quotes (lease-up and stabilized) into a decision-ready package. Reconciles each quote's DSCR/LTV/LTPP sizing constraints, prices rate buy-downs aamos-icomm-demo-orchestratorThin 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,annual-budget-engineProduces institutional-quality annual operating budgets with IREM/BOMA benchmarking, component-specific escalators, NOI sensitivity grids, budget-to-value linkage, reserve adequacy testing, and IC chaasset-ops-cockpitTop-level workspace for ongoing asset management and property operations. Routes through budgeting, performance monitoring, capex, NOI optimization, compliance, maintenance, and vendor management. Manbuilding-systems-maintenance-managerBuilding systems monitoring, preventive maintenance program management, equipment lifecycle tracking, inspection coordination, and compliance documentation. Covers HVAC, elevator, fire/life safety, rocam-reconciliation-calculatorCalculates 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 casecapex-prioritizerEvaluates competing capital expenditure projects using IRR/NPV, interaction effects, residual value at disposition, covenant impact, replacement cost benchmarking, and 'do nothing' deferral cost analycapital-projects-developmentTop-level workspace for development and construction projects. Routes through land analysis, pro forma modeling, entitlements, budgeting, cost estimation, project management, and procurement. Manages capital-raise-machineProduces the full operational infrastructure for an active capital raise: data room structure, investor tracking, capital call notices, LP onboarding workflow, waterfall explainer, and crisis communiccapital-stack-optimizerSynthesizes outputs from loan-sizing-engine, mezz-pref-structurer, and JV waterfall to determine the optimal capital mix for a CRE deal. Evaluates 3-5 alternatives across WACC, equity IRR, leverage secarbon-audit-complianceConducts building-level carbon audit, benchmarks against local Building Performance Standards (NYC LL97, DC BEPS, Boston BERDO 2.0, Denver, Colorado, Maryland, St. Louis), calculates penalty exposure,climate-risk-assessmentAssesses physical and transition climate risk for CRE properties and portfolios. Translates hazard exposure (flood, wind, wildfire, extreme heat, sea level rise) and regulatory/market shifts into finaclosing-checklist-trackerGenerates and tracks comprehensive closing checklists for CRE transactions (acquisitions, dispositions, refinancings). Backward-schedules deadlines from closing date, assigns responsibilities, identifcoi-compliance-checkerValidates certificates of insurance against lease and contract requirements. Compares coverage types, limits, endorsements, and expiration dates field-by-field, flags deficiencies, and generates cure comp-snapshotProduces 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 calcompliance-regulatory-response-kitBuilding code violations, OSHA responses, ADA compliance, fire safety, environmental compliance during construction, entitlement tracking, community stakeholder communication. Triggers: code violationconstruction-budget-gc-analyzerBenchmarks a GC's construction budget against market costs by CSI division, evaluates contract structure (GMP vs. cost-plus vs. stipulated sum), reviews GC fee and general conditions, and establishes construction-cost-estimatorProduces ground-up construction cost estimates by CSI MasterFormat division with regional adjustments, soft cost layering, contingency framework, and sensitivity analysis. Accepts floor plans, buildinconstruction-procurement-contracts-engineGC selection, bid leveling, GMP/lump sum negotiation, CO compliance, punch list management, and design team evaluation for Development Managers.construction-project-command-centerCentral command for ground-up development and major renovation projects. Manages RFIs, submittals, change orders, draw requests, schedule tracking, safety compliance, and lender reporting. Triggers oncost-segregation-analyzerEvaluates 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, cpi-escalation-calculatorCalculates CPI rent escalations per lease-specific clause definitions, handles year-over-year, cumulative-from-base, and compounded methods, applies floor/ceiling logic, generates tenant notification creative-seller-financingStructures non-traditional acquisition financing using seller participation (carryback notes, master leases, earnouts, JV contributions) and analyzes loan assumption vs. new financing decisions. Quantcrisis-special-situations-playbookEmergency response for CRE special situations: environmental remediation, condemnation, tenant bankruptcy, partnership disputes, fund wind-down, side letter negotiation. Triggers: crisis, remediation,dd-command-centerGenerates a comprehensive, timeline-driven due diligence plan for commercial property acquisitions with 6 workstream checklists, risk matrix, third-party report ordering guide, decision gates, closingdeal-attribution-trackerTracks deal-level performance attribution and GP carry across a multi-deal fund: realized vs unrealized returns, carry waterfall across full fund, clawback exposure, deal team attribution, and GP co-ideal-intakeTop-level workspace for deal evaluation. Routes through screening, underwriting, structuring, and IC presentation. Manages persistent deal context across sessions.deal-quick-screenFast 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. Trdeal-underwriting-assistantLightweight 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 2-wdebt-covenant-monitorCalculates DSCR, LTV, occupancy, and debt yield per loan-specific definitions, projects forward to catch breaches before they happen, and generates lender compliance certificates.debt-portfolio-monitorBuilds and maintains an institutional-quality CRE debt fund portfolio monitoring framework. Produces traffic-light dashboard, watchlist with objective triggers, maturity wall analysis, concentration tdev-proforma-engineBuilds a full ground-up development pro forma at monthly granularity from land closing through construction, lease-up, and stabilization. Produces TDC budget, monthly draw schedule with compounding indisposition-prep-kitProduces a complete disposition preparation package: T-12 normalization, rent roll scrub, data room index, buyer Q&A, retrade defense, broker selection, marketing timeline, value story, and buyer targdisposition-strategy-engineProduces a comprehensive sell/hold/refinance analysis with market cycle positioning, tax impact quantification, marginal return on equity, buyer universe assessment, and 15 selectable disposition scendistressed-acquisition-playbookGenerates a comprehensive acquisition strategy for distressed CRE assets acquired through REO, note purchase, special servicing, receivership, or bankruptcy. Covers compressed DD, valuation waterfall,distribution-notice-generatorGenerates individual LP distribution notices with per-investor share calculations, tax characterization, waterfall tier explanation, and batch processing for 50-200+ investors.document-to-data-room-extractorConverts 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 reviewdocument-to-databaseExecutable orchestrator that turns tokenized/extracted CRE document content (rent rolls, T-12s, operating statements, Prose Frontier narrative artifacts) into validated, typed, auditable, target-modeldocument-to-warehouse-pipelineOrchestration skill that assembles the OUTPUT of single-document extractors into validated, warehouse-ready tabular datasets. It does not re-extract individual documents; it sits above the extractors emerging-manager-evaluatorEvaluates 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 prentitlement-feasibilityAssesses whether a proposed development is achievable under current zoning or requires discretionary approvals, quantifies entitlement risk (timeline, cost, probability), and calculates entitlement vaestoppel-certificate-generatorAutomates 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 cofund-formation-toolkitEnd-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 includifund-lp-reportingTop-level workspace for fund management and LP communications. Routes through fund formation, investor updates, pitch decks, capital raises, lifecycle management, compliance, performance attribution, fund-operations-compliance-dashboardInstitutional fund management operations: regulatory compliance monitoring, fee calculations, capital account statements, subscription processing, AML/KYC, Form D filings, LPAC governance, and fund exfund-raise-negotiation-engineTracks 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 comfund-terms-comparatorCompare 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, clafunds-flow-calculatorCalculate 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 exchanggp-performance-evaluatorAnalyze 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 ic-deck-composerComposes professional INSTITUTIONAL committee decks from source-grounded model outputs, warehouse exhibits, and memo narrative, following brand-guideline conventions (executive-summary-first, explicitic-memo-generatorProduces 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 vic-red-team-challengerPressure-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), knowicomm-context-builderAssembles a source-grounded Investment Committee Q&A context pack from upstream underwriting, diligence, debt, and risk outputs. Indexes every deal fact to a citable sourceRef, builds a question-and-ainsurance-risk-managerInsurance program review, coverage adequacy testing, contractor insurance verification, builder's risk/OCIP/CCIP evaluation, and property tax escrow management for AM, PM, and Development.investor-lifecycle-managerLP lifecycle management: investor meetings, benchmark comparison, cash management, audit coordination, re-up solicitation, GIPS composites, satisfaction tracking. Triggers: investor meeting, LP relatijv-waterfall-architectDesigns, calculates, and explains joint venture equity waterfall structures for GP/LP partnerships. Three modes: Structure (term sheet from scratch), Calculate (distributions under specific scenarios)land-residual-hbu-analyzerDetermines 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 l