The open-source catalog uses industry-standard assumptions. Your firm has its own underwriting criteria, reporting templates, and workflows. I build skills tuned to exactly how your team works.
Generic, one-off.
Engineered skills bundle deterministic Python calculators. Every one of the 21 below was reviewed as pure standard-library code with no network, shell, or credential access, and each links to its source so you can read exactly what runs. This is the full set the catalog counts, not a sample.
Financial calculators 12
construction_estimator.pyProduces a TDC (Total Development Cost) estimate for a CRE project by CSI division, with regional adjustment, soft cost layering, contingency, and sensitivity analysis.
proration_calculator.pyCalculates per diem prorations for property tax, rent, insurance, and CAM/OpEx at a commercial real estate closing.
quick_screen.pyBack-of-napkin deal screening: cap rate, price per unit/SF, rent vs market, DSCR at assumed financing, cash-on-cash, replacement cost ratio.
debt_sizing.pySizes a CRE loan against simultaneous DSCR, LTV, and debt yield constraints.
fund_fee_modeler.pyModels blended management fee economics for institutional fund raises.
waterfall_calculator.pyCalculates GP/LP distributions through a multi-tier promote waterfall with preferred return accrual and a GP catch-up.
option_valuation.pyCalculates termination fees, renewal option cap rate impact, and compares conservative/moderate/aggressive option packages by NPV impact.
covenant_tester.pyTests loan covenants (DSCR, LTV, debt yield) against multi-year projections.
monte_carlo_simulator.pyStochastic simulation engine for CRE investment returns.
npv_trade_out.pyCompares renewal NPV vs trade-out NPV for a lease expiration decision.
tenant_credit_scorer.pyCalculates HHI concentration index, WALT-weighted credit score, expected annual loss per tenant, and occupancy cost ratios for a commercial property rent roll.
transfer_tax.pyCalculates state and local transfer taxes for CRE transactions.
Data-pipeline tools 9
map_charge_codes.pyMaps rent-roll charge codes (or, when codes are absent, charge descriptions) to the canonical chart of accounts, and T-12 account lines to canonical account slugs.
grade_ingestion.pyScores a normalized payload (+ its validation report and optional tie-out) the way the rent-roll data-quality rubric defines: a weakest-link A/B/C letter is PRIMARY, a 0-100 weighted score is the secondary readout.…
emit_load_plan.pyEmits a reviewable, FK-ordered load plan for a target-model profile: the table load order (every FK target precedes its referrer), the upsert keys (the primary key) per table, and each table's dependencies. The plan…
validate_payload.pyRuns type / range / nullability and cross-field reconciliation checks over a canonical payload produced by normalize_tokens.
reconcile_rent_roll_t12.pyReconciles a normalized rent roll against a normalized T-12 on a STATED, CONSISTENT basis and never forces a tie.
infer_schema.pyInfers a column schema (type, nullability, detected unit, per-column confidence) and a grain guess from an unknown tabular token stream — the doc_type: auto path, used when an extracted table arrives without a known…
emit_sql_ddl.pyEmits reviewable CREATE TABLE DDL for a target-model profile.
map_to_target_model.pyMaps a canonical payload into a chosen target-model profile (raw_landing, normalized_relational, star_schema, data_vault, hybrid_recommended) and reports the row counts and representative rows per table. This proves…
normalize_tokens.pyTransforms a tokenized/extracted CRE document (rent roll, T-12, or operating statement) into canonical, typed, provenance-stamped records that downstream ingestion calculators consume.