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/01-asset-class-norms.md
View on GitHub# Asset Class Norms (LP perspective)
A factual baseline for screening passive deals. The ranges here are **screening
heuristics, not underwriting** — use them to spot when a deal's claimed return,
hold, or risk profile is far enough outside category norm to warrant deeper
questions, and to flag absent disclosures against the typical baseline.
## How to read this file
- **"Variable" is a real value.** Where current-cycle conditions make a
category's norms genuinely unstable (post-2020 office, regulatory-sensitive
STR, cycle-sensitive development), the cell says *variable* with a one-line
reason. *Variable* is the file's honest answer — it tells the analyst the
baseline is the **deal's own underwriting**, not a category default.
- **Absent disclosures flag against this baseline.** A deal that omits hold
period, fee structure, or return expectation when the category baseline has
one is a flag, not a neutral silence.
- **Ranges are net to LP, not gross.** Gross IRRs are not directly comparable
across categories — fee stacks differ enough that gross-on-gross misleads.
## At a glance
| Asset class | Typical hold | Common deal types | Net IRR to LP (target/range) | Risk tier |
|---|---|---|---|---|
| Multifamily — value-add | 5–7 yrs | Equity syndication | 12–18% target; realized closer to 12–15% blended | Med |
| Multifamily — core / core-plus | 7–10 yrs | Equity, preferred equity, fund | 8–12% | Med-Low |
| Industrial | 5–10 yrs | Equity, fund | 10–15% value-add; 7–10% stabilized | Med-Low |
| Retail — necessity (grocery-anchored, service) | 7–10 yrs | Equity, fund | 8–12% | Med |
| Retail — experiential / large-format / mall | — | — | *variable* — post-2020 demand shift; tenant-mix dependent | High |
| Office | — | — | *variable* — post-2020 occupancy reset; class-A trophy ≠ class-B/C | High |
| Mixed-Use | composite | Equity | *variable* — underwrite to weakest / most-uncertain component | Med-High |
| Single Family Rental (SFR) | 5–10 yrs | Fund, equity | 8–14% | Med |
| Short-Term Rental (STR) | 3–7 yrs | Equity, fund | *variable* — regulatory + operational sensitivity dominates per-market | Med-High |
| Development (ground-up) | 3–5 yrs | Equity, preferred equity | 18–22% target; realized often below on cycle misses | High |
| Hard Money / Bridge Loan | 6–18 mo per loan (3–5 yr fund) | Debt fund, individual debt | 8–10% net (11–13% gross common) | Low-Med (senior secured, 65–75% LTV typical) |
| Private Credit (fund) | 3–7 yrs | Debt fund | 8–12% | Low-Med (senior secured) |
| Other | — | — | — | Apply this file's discipline to the closest analog; the mismatch itself is a flag |
---
## Multifamily — value-add
Stabilized acquisitions with a renovation / reposition thesis (unit interiors,
amenities, operations). The dominant retail-LP syndication category.
- **Hold.** 5–7 years; refi-at-stabilization business plans sometimes extend.
- **Returns.** Target net IRR 14–18%, equity multiple 1.5–2.0x. Realized
performance across vintages tends to cluster 12–15% net IRR blended (ILPA /
NCREIF realized data), with wider dispersion than the marketing range
suggests. Cash-on-cash 5–8% after stabilization.
- **Key LP risks.** Rent-growth assumption (slowing-cycle deals are exposed),
**exit cap rate** (the single biggest swing in most pro formas), and refi
risk (if the plan depends on a refi at lower rates).
- **Essential disclosures.** Rent roll, T-12 actuals (not just trailing-3 or
trailing-6), pro forma exit cap with sensitivity, debt structure and maturity,
refi assumptions, GP track record on **prior multifamily exits** (not just
acquisitions).
## Multifamily — core / core-plus
Stabilized, high-occupancy assets with light or no value-add. Lower risk,
lower return.
- **Hold.** 7–10 years; cash-flow-driven.
- **Returns.** Net IRR 8–12%. Cash flow dominates over exit appreciation.
- **Key LP risks.** Cap-rate compression / decompression; interest-rate
sensitivity on cash flow when fixed-rate debt rolls.
- **Essential disclosures.** Occupancy history (5+ years), T-12 NOI, full debt
structure (rate, term, amortization, prepayment), exit cap assumption.
## Industrial
Logistics, warehouse, last-mile, light industrial. Benefited from a structural
e-commerce tailwind through the 2010s and 2020s.
- **Hold.** 5–10 years.
- **Returns.** Value-add 10–15% net IRR; stabilized core 7–10%.
- **Key LP risks.** Tenant credit (often single-tenant or few-tenant assets),
lease expirations vs business-plan exit, market vacancy in the submarket
(not just metro-wide), replacement cost vs the deal's basis.
- **Essential disclosures.** Tenant credit profile, lease term and rent steps,
submarket vacancy and absorption, replacement cost benchmark.
## Retail — necessity (grocery-anchored / service-oriented)
Recession-resistant retail with daily-needs anchors and high traffic.
- **Hold.** 7–10 years.
- **Returns.** Net IRR 8–12%.
- **Key LP risks.** Anchor lease term and anchor credit (loss of an anchor can
cascade through cotenancy clauses), inline tenant rollover, parking ratio in
markets where it matters.
- **Essential disclosures.** Anchor lease term and rent, anchor credit rating
or sales-PSF, cotenancy clauses, inline tenant roll schedule.
## Retail — experiential / large-format / mall
*Variable.* The post-2020 omnichannel shift hit traditional retail unevenly:
malls and big-box are uniformly stressed, while curated experiential retail
(entertainment, lifestyle centers in high-income trade areas) is highly
deal-specific. **Treat any range as a deal-by-deal underwriting, not a
category baseline.**
- **Key LP risks.** Tenant rent-to-sales ratios (a healthy retailer at 8–10%;
a stressed retailer at 15%+ is a default candidate), lease term remaining,
whether replacement tenants are realistically available at the assumed rent.
- **Essential disclosures.** Tenant-by-tenant rent and sales, lease expirations,
cotenancy exposure, any tenant credit warnings (Moody's / S&P watch lists).
## Office
*Variable.* The post-2020 occupancy reset is still working through (2025–26).
Class-A trophy in resilient markets (Sun Belt, secondary growth metros) is
holding up; class-B and class-C, especially in commute-heavy CBDs, is
dislocated. Pricing creates both opportunity and value-trap. **A claimed return
for "office" with no class / market / WFH-mix disclosure is unscreenable.**
- **Key LP risks.** **Physical** occupancy (not just leased — leased space can
sit dark), sublease overhang in the submarket, debt maturity timing vs
business plan, market reabsorption pace.
- **Essential disclosures.** Class (A trophy vs A vs B vs C), submarket
reabsorption rate, physical occupancy, sublease overhang, lease expiration
schedule, debt maturity, capex required to compete (move-in-ready vs
vanilla shell).
## Mixed-Use
Composite of residential / retail / office / parking / hotel / other. **Risk
is dominated by the weakest or most-uncertain component, not the mix average.**
- **Hold.** Component-weighted.
- **Returns.** *Variable* — defer to the deepest underwritten component;
if one component is "variable" (office, experiential retail), the deal's
return is variable.
- **Essential disclosures.** Revenue breakdown by component, sensitivity
analysis if a softening component drops by a stated %, capex allocation
by component.
## Single Family Rental (SFR)
Institutionalized residential rental, often via aggregators. A maturing
asset class (2010s–2020s growth) with shorter institutional track record than
multifamily.
- **Hold.** 5–10 years; cash-flow-driven.
- **Returns.** Net IRR 8–14%.
- **Key LP risks.** Market-level SFR rent and tenant demand, property age and
capex schedule (SFR has more dispersed capex than multifamily), eviction
process exposure by jurisdiction, scale economics (a 50-home portfolio is
not the same business as a 5,000-home portfolio).
- **Essential disclosures.** Market-level rent and absorption, average property
age and capex reserve, geographic concentration, operator scale and
property-management approach.
## Short-Term Rental (STR)
Per-property or fund. Regulatory environment and operational quality dominate
returns by a wide margin.
- **Hold.** 3–7 years.
- **Returns.** *Variable* — a strong STR market with stable regulation can
return 15%+ net; the same property under restrictive municipal regulation
can return low single digits or be forced into long-term-rental conversion.
- **Key LP risks.** Local regulatory regime **and its trajectory** (the
regulatory cycle is the dominant risk), operator track record on ADR /
occupancy, dependency on a single platform's ranking algorithm, fixed-cost
coverage in low season.
- **Essential disclosures.** Local STR regulation today and any pending
ordinances, operator's realized (not projected) ADR / occupancy on
comparable properties, fixed-cost breakeven occupancy.
## Development (ground-up)
Entitlement, construction, lease-up, exit. High return, high risk, cycle-timing
exposure.
- **Hold.** 3–5 years.
- **Returns.** Target net IRR 18–22%. Realized returns often below target on
construction-cost overruns, financing-cost spikes, or lease-up misses.
- **Key LP risks.** Entitlement status (entitled-but-not-permitted is a
different deal than shovel-ready), construction-cost contingency, debt
structure (construction-to-perm vs separate takeout), market absorption,
GP's specific development experience (development experience is not
fungible with acquisition experience).
- **Essential disclosures.** Entitlement and permit status, hard-cost budget
with contingency %, debt structure including takeout assumptions, market
absorption assumptions with comp evidence, GP's last three development
exits with realized timing and budget vs underwritten.
## Hard Money / Bridge Loan (fund or direct)
Senior secured short-duration debt against real estate, typically for fix-and-
flip or quick-acquisition borrowers.
- **Hold.** 6–18 months per loan; fund-level commitment 3–5 years.
- **Returns.** Net IRR to LP 8–10%; gross 11–13% before fees is common.
- **Risk position.** Senior secured. Typical LTV 65–75% on **ARV** (after-repair
value, not as-is) — note the distinction; an ARV-based 70% LTV can be 100%+
on current value.
- **Key LP risks.** Average portfolio LTV on **as-is** value (not just ARV),
default and foreclosure process competence (workouts are a craft skill),
geographic concentration, fund-level credit losses through prior cycles
(especially 2020 and 2022–23 rate spikes).
- **Essential disclosures.** Average loan LTV (as-is and ARV), default rate
history, foreclosure process and recovery rate, geographic mix, sponsor
history through a downturn.
## Private Credit (fund)
Senior secured private corporate or real-estate lending. Broader than just
real estate.
- **Hold.** 3–7 years (committed capital, with distribution schedule).
- **Returns.** Net IRR 8–12%.
- **Risk position.** Senior secured corporate loans; recovery rates historically
~60–80% on defaults, but with wide dispersion by vintage and credit quality.
- **Key LP risks.** Portfolio diversification (number of loans, sector
concentration), fund-level leverage (BDC-style leverage amplifies both
returns and losses), seniority position in the capital stack, vintage
exposure to credit cycles.
- **Essential disclosures.** Loan count and average loan size, sector mix,
fund leverage ratio, seniority position, historical default rate and
recovery rate (preferably through-cycle).
## Other
If the deal doesn't fit a named category, that mismatch is itself a flag.
Apply this file's discipline to the closest analog (e.g. "this is structured
like a hard-money fund but secured by mobile-home parks") and ask the GP why
the analog doesn't apply.
---
## Provenance
"Industry survey norms" throughout `references/` means the broad consensus of
the sources below; each other file lists only the sources unique to it. When the
cycle shifts faster than these files, they lag — re-baseline against recent
realized deal flow.
- **NCREIF.** NPI (National Property Index) and ODCE (Open-end Diversified Core
Equity Fund Index) for institutional realized real-estate returns.
- **Preqin.** Cross-category private-markets performance data.
- **ILPA.** LP-side reporting standards and aggregated LP performance.
- **Sector trade groups.** NMHC (multifamily), NAIOP (industrial / office /
commercial), ICSC (retail), MBA (debt).
- **LP marketing.** Cross-section of recent offerings from EquityMultiple,
CrowdStreet, RealtyMogul, direct GP emails.
*Last reviewed: 2026-05-29. Recalibrate when realized IRRs for a category
cross the range threshold materially, or when a regulatory / rate-environment
shift changes the underlying economics (the 2020 office reset is the canonical
example).*
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 |