Private Equity Portfolio Model - Capital Calls, Carry Waterfall, TVPI, DPI & Net IRR (Excel)

Description
Model a private equity fund from capital calls to LP net returns. The Private Equity Portfolio Model is an institutional-grade Excel model built to a rigorous value framework used by professional investors and advisors. It builds capital calls, deployment, a carry waterfall, TVPI, DPI and net IRR, in a clean, formula-driven workbook you can open and use in minutes. It is fully documented and auditable, ready to drop into a data room or an investment committee pack.

Every model is scenario-driven (a single switch flexes Base, Upside and Downside), reorganised where relevant into NOPLAT, invested capital and ROIC so you can see the return on capital against the cost of capital and the economic profit created, and independently verified through a live Checks dashboard that reads MODEL OK with zero formula errors. An executive dashboard summarises the headline results and charts at a glance, so the story is clear before anyone opens a single formula.


What you get: a protected, formula-driven Excel workbook (no macros), a scenario manager, the full model build, a Sources and Audit tab, a live Checks dashboard, an executive dashboard, and a plain-English documentation guide. Single-seat commercial licence. Default inputs are illustrative and ready to replace with your own numbers. No fluff, no locked black boxes: clear structure, honest assumptions, and a model you can defend in front of an investor, lender or board.