alirezarezvani/claude-skills / finance/skills/passive-deal-screener
passive-deal-screener
VerifiedUse when a passive investor shares a private deal (syndication, preferred equity, bridge fund, private credit) to screen as an LP. Stress-tests it, computes fee drag with fee_drag_calculator.py and compares terms with benchmark_comparator.py.
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 9.4 KB |
| evals/evals.json | config | 13.2 KB |
| examples/README.md | markdown | 1.2 KB |
| examples/equity-syndication/input.md | markdown | 734 B |
| examples/equity-syndication/output.md | markdown | 19.9 KB |
| examples/hard-money-fund/input.md | markdown | 608 B |
| examples/hard-money-fund/output.md | markdown | 15.9 KB |
| examples/private-credit-fund/input.md | markdown | 676 B |
| examples/private-credit-fund/output.md | markdown | 17.0 KB |
| references/01-asset-class-norms.md | markdown | 12.8 KB |
| references/02-fee-stack-library.md | markdown | 16.9 KB |
| references/03-red-flag-library.md | markdown | 18.2 KB |
| references/04-question-bank.md | markdown | 16.5 KB |
| references/05-benchmark-returns.md | markdown | 15.4 KB |
| references/data/README.md | markdown | 3.2 KB |
| references/data/etf-comparators-snapshot.md | markdown | 7.3 KB |
| references/data/fred-10yr-snapshot.md | markdown | 2.6 KB |
| references/data/ncreif-npi-snapshot.md | markdown | 3.1 KB |
| references/data/preqin-vintage-note.md | markdown | 3.4 KB |
| scripts/benchmark_comparator.py | script | 20.0 KB |
| scripts/fee_drag_calculator.py | script | 18.5 KB |
references/data/ncreif-npi-snapshot.md
View on GitHub# NCREIF NPI Snapshot
The **NCREIF Property Index (NPI)** — the institutional private commercial
real-estate benchmark — measures unlevered total return on a large pool of
institutional-quality properties held by NCREIF members. It is the closest thing
to an "unlevered, in-place" baseline for private equity real estate, which makes
it the grounding figure for the financing-story flag (`03` → `GEN-07`): a deal
whose levered IRR towers over the NPI is earning its excess from leverage and
cap-rate movement, not operations.
**As of:** Q2 2026 (most recent reported; released late July 2026)
**Captured:** 2026-09-27
**Source:** IREI's report of NCREIF's quarterly release (2026-07-27). NPI detail
beyond the headline is membership-gated.
## Values
| Metric | Value | Period |
|---|---|---|
| NPI total return (quarterly) | 1.29% | Q2 2026 |
| — income return | 1.17% | Q2 2026 |
| — appreciation return | 0.12% | Q2 2026 |
| NPI total return (prior quarter) | 1.24% | Q1 2026 |
| NPI total return (trailing 4-quarter) | 5.00% | Q3 2025 – Q2 2026 |
| NPI total return (full year) | 4.9% (≈ 4.8% income, ≈ 0.2% appreciation) | 2025 † |
The trailing four-quarter income/appreciation split was not publicly reported
for Q2 2026. Read together, the index's ~5% return is still **almost entirely
income**: Q2 2026 appreciation was 0.12% against 1.17% income, the same shape as
2025's ≈0.2% appreciation against ≈4.8% income. Returns rose for four consecutive
quarters (the highest trailing four-quarter figure since Q4 2022), but there is
still no meaningful appreciation at the institutional index level. That is the
empirical anchor for LP skepticism of deals underwriting large appreciation.
Index scope at Q2 2026: 13,160 properties, $943B market value.
## By property type (2025 full year) †
| Property type | 2025 total return |
|---|---|
| Retail | 6.8% |
| Residential | 5.3% |
| Industrial | 4.5% |
| Office | 3.4% |
These pair with `01-asset-class-norms.md`: office lagging is consistent with the
post-2020 *variable* office baseline.
† Full-year figures, carried from the June 2026 snapshot (RCLCO / Capital
Economics annual recaps). Refreshed once a year, when the next full-year results
are published, not every quarter.
## How `05` uses this
NPI is the **unlevered private-RE baseline**. The design-review DoD for `05`
(2026-06-01) requires an unlevered comparator alongside each headline ETF return
so the skill can separate "clears the illiquidity hurdle" from "IRR is driven by
leverage, not alpha." If a syndication's *unlevered* projected return doesn't
beat the NPI for its property type, the LP is being paid for leverage risk, not
operating skill.
## Provenance / gated-source note
Quarterly headline figures come from one outlet, **IREI**, which reports each
NCREIF quarterly release (total, income, appreciation, trailing four quarters,
index size). **Property-level detail, ODCE fund-level returns, and the full
sub-type/region matrices are membership-gated** behind NCREIF and are not
captured. On refresh, pull the next quarter's headline from IREI; if NCREIF
membership becomes available, replace with the primary release.
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| finishing-a-development-branchobra/superpowersUse when implementation is complete, all tests pass, and you need to decide how to integrate the work | Stars: 323k | Updated | Claude CodeCodex | Verified | Install |
| systematic-debuggingobra/superpowersUse when encountering any bug, test failure, or unexpected behavior, before proposing fixes | Stars: 323k | Updated | Claude CodeCodex | Verified | Install |
| test-driven-developmentobra/superpowersUse when implementing any feature or bugfix, before writing implementation code | Stars: 323k | Updated | Claude CodeCodex | Verified | Install |
| skill-creatoranthropics/skillsCreate new skills, modify and improve existing skills, and measure skill performance. Use when users want to create a skill from scratch, edit, or optimize an existing skill, run evals to test a skill, benchmark skill performance with variance analysis, or optimize a skill's description for better triggering accuracy. | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |