fund-operations

TVPI equals realized proceeds plus current fair market value divided by total invested capital, while DPI equals realized proceeds divided by total invested. This Skill computes both automatically from a fund_inputs.json file listing each investment's invested amount, current FMV, and realized proceeds.

IRR is computed using the Newton-Raphson method on dated cash flows, solving for the rate where net present value equals zero. Provide capital call and distribution dates in YYYY-MM format; if dates are unavailable, a simplified approximation derives IRR from MOIC and fund age.

A European waterfall returns all LP capital first, then pays the preferred return at the hurdle rate, then lets the GP catch up, and finally splits remaining profits 80/20. The carry model here uses total realized proceeds, invested capital, hurdle rate, and fund age to compute carry earned.

No external packages are required. The scripts use only the Python 3 standard library (json, math, datetime, os, sys), so they run in any standard Python 3 environment without pip installs.

The exact XIRR method requires at least two dated cash flow entries in fund_inputs.json. If fewer than two cash flows exist or date parsing fails, the script falls back to a simplified IRR derived from the MOIC raised to the inverse of fund age.