Lookback Reconciliation Calculator

Lookbacks true-up American waterfall distributions to meet European pref requirement.

Cumulative LP distributions

LP capital contributed

Pref rate %

Weighted hold years

Cumulative GP promote

GP lookback clawback

$6,000,000

Required LP pref distribution

$76,348,526

LP shortfall vs pref

$18,348,526

How the math works

Required pref = capital × (1+rate)^years. Shortfall = required − distributed. Clawback = min(shortfall, GP promote).

$50M × 1.08^5.5 = $76.6M required. $58M received = $18.6M shortfall. $6M GP → $6M clawback.

How to Use

Enter cumulative LP distributions.
Enter cumulative LP capital contributed.
Enter pref rate %.
Enter weighted hold years.
Enter cumulative GP promote.
Read lookback adjustment.

Frequently Asked Questions

What is a lookback?

A provision in American waterfall that at fund termination (or other trigger) ensures LP received their preferred return across all deals in aggregate, not just deal-by-deal. If fund overall returned 6% and pref was 8%, GP must return promote already paid until LP gets to 8%. This protects LPs from 'heads I win tails you lose' scenario — GP catches promote on winners but LP bears losses on losers without true-up.

When does lookback trigger?

Fund wind-down / final distribution. Dissolution event (fund termination, GP resignation). Typically calculated at end of specified hold period (7-10 years) regardless of whether all assets disposed. GP must return promote or provide clawback payment. Institutional funds require LP protective covenants including lookback — amateur syndications often don't, which is a red flag for sophisticated LPs.

Lookback vs clawback?

Used interchangeably but slightly different. Lookback: mechanical formula calculating excess promote paid, applied at specified trigger. Clawback: contractual GP obligation to return excess promote, whatever amount. Lookback is simpler (formula). Clawback is more flexible but more contentious (dispute-prone). Most institutional funds use both: lookback formula + clawback liability backed by escrowed promote or GP balance sheet.

How do GPs fund lookbacks?

GP promote escrow (10-30% of each distribution held back). GP balance sheet (GP pays from operating capital). GP personal guarantee (rare — sophisticated LPs require). Some funds have 'GP catch-up catchup' — LPs get extra distribution before GP promote resumes after lookback trigger. Each structure has different implications; experienced fund counsel drafts. Sponsor pushback during fundraise common — but rarely gets to optional status in institutional fundraising.