deal-attribution-tracker

Analyzes CRE fund deal-level returns and reconciles GP carry across American and European waterfall structures.

Updated Apr 1, 2026
One-click install
npx skills add https://github.com/chibus0368-pixel/om-analyzer --skill deal-attribution-tracker
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: deal-attribution-tracker
Source: https://github.com/chibus0368-pixel/om-analyzer/tree/main/skills/deal-attribution-tracker
Command: npx skills add https://github.com/chibus0368-pixel/om-analyzer --skill deal-attribution-tracker

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Analyzes and reconciles deal-by-deal carry with aggregate fund economics to ensure accurate attribution, clawback sizing, and governance-ready reporting across a multi-deal CRE portfolio.

Core Features & Use Cases

  • Deal-level attribution for realized, unrealized, and partially realized investments, including DPI/TVPI/IRR calculations per deal.
  • American (deal-by-deal) and European (whole-fund) waterfall modeling with stress testing scenarios to quantify clawback risk.
  • Integrated deal-team carry attribution, vesting considerations, and departure rules for retention planning.

Quick Start

Provide fund deal data (invested capital, distributions, current value, investment dates, exit dates) to generate a full waterfall, KPI metrics, and clawback exposure.

Frequently Asked Questions about deal-attribution-tracker

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I calculate deal-level carry and clawback exposure across a CRE portfolio?

To calculate deal-level carry and clawback exposure, input per-deal investments, distributions, and current values to model American or European waterfalls and quantify clawback risk. This process reconciles deal-by-deal returns with aggregate fund economics for governance-ready reporting.

What is the difference between American and European waterfall structures for GP carry?

American waterfall structures calculate GP carry deal-by-deal, whereas European waterfalls apply carry on a whole-fund basis. Stress testing both models with mixed realized and unrealized positions reveals distinct clawback risk profiles for accurate deal attribution.

How do I track DPI and TVPI for partially realized commercial real estate investments?

Tracking DPI and TVPI for partially realized investments requires analyzing per-deal invested capital, distributions, and current values. Computing these metrics alongside RVPI ensures accurate deal-level attribution across mixed realized and unrealized CRE fund positions.

Can I benchmark unrealized CRE fund positions against vintage cohorts?

Yes, you can benchmark unrealized CRE fund positions against vintage cohorts by inputting fund-level benchmarks and current values. This enables consistent attribution and risk assessment when comparing mixed realized and unrealized deal performance.

How do I model deal-team carry attribution and vesting for retention planning?

Modeling deal-team carry attribution involves applying integrated vesting considerations and departure rules to the computed GP carry. This ensures accurate retention planning by tracking individual deal-team exposure across the carry waterfall.

What inputs are needed to stress test clawback risk for a multi-deal CRE fund?

Stress testing clawback risk requires inputs of per-deal investments, distributions, current values, hurdle rates, carry rates, and fund-level benchmarks. Applying these across American or European waterfall structures quantifies potential clawback exposure accurately.