VC
Cap Tables
LP/GP
Fund Economics
Carry
Waterfall Calc
Python
Not Excel
Python automation for PE/VC financial modeling: VC cap table generation, LP/GP fund economics calculations, carried interest waterfalls, and scenario analysis. Replaces manual Excel modeling with reproducible, version-controlled Python that runs in seconds.
VC cap tables and fund economics in Python. Reproducible, version-controlled, and 100× faster than Excel.
Tech Stack
PythonPandasNumPyopenpyxlPlotlyJupyterDuckDB
Features
Cap Table Engine
Full VC cap table: pre/post-money, pro-rata, anti-dilution, option pool shuffle — all automated.
Fund Economics
LP/GP economics: management fees, carried interest, hurdle rates, preferred return calculations.
Waterfall Model
Carry distribution waterfall for multiple fund scenarios with European vs American waterfall options.
Scenario Analysis
Run 100+ exit scenarios in seconds. Plotly visualizations for LP reports and IC presentations.
How It Works
01
Input
Fund terms + portfolio companies → structured Python dataclasses
→
02
Model
Cap table engine + economics calculator → scenario matrix
→
03
Waterfall
Carry distribution engine with configurable waterfall structure
→
04
Report
Plotly charts + openpyxl Excel export for LP/IC presentations