Built a 10-tab private equity LP reporting excel model — here’s what’s inside

Been working on a PE fund reporting template for the past few weeks and finally finished it. Figured this community might find the structure interesting even if PE isn’t your thing.

What’s in it:

• Waterfall calculator with American/European toggle and inputtable preferred return • J-curve pulling live from a cash flow schedule • ILPA 2.0 aligned fee schedule across 22 expense categories • Dashboard with 4 auto-populating charts • Per-LP capital account statements with auto-calculated ownership % • Subscription facility IRR impact (shows returns with and without the credit line) 

The whole thing uses industry-standard color coding — blue for inputs, black for formulas, green for cross-sheet links. 586 formulas, zero errors.

Happy to share the link if anyone wants to check it out or use it as a reference for building something similar.