28
positions in the sample: fund commitments, an SPV, and direct deals
10 years
of projected capital calls and distributions
6
views: dashboard, investments, capital calls, K-1s, alerts, and modeling

The situation

Private equity is hard to track in a spreadsheet. Capital is called over years, distributions arrive unevenly, K-1s show up as PDFs months after year end, and every manager reports in its own format. Answering "what is it worth, what has it returned, and how much is still uncalled?" means rebuilding the numbers by hand.

The goal was one place where every commitment and direct deal answers those questions on its own, and shows when cash is likely to go out and come back.

What I built

  • A dashboard with total value, multiples (MOIC, which is TVPI at the fund level, plus DPI and RVPI), IRR computed from the investor's own cash flows (XIRR), and committed, called, and uncalled capital, plus a chart of portfolio value over time.
  • A liquidity outlook: base-case capital calls and distributions for each of the next ten years, with the running net shown as a line so you can see where the J-curve turns, and a probability-weighted ten-year total across the base, upside, and downside cases.
  • An investments table with value trends and results against the plan, a capital-calls view of every fund commitment and what is still uncalled, and a K-1 grid showing which tax forms have arrived, by partnership and year.
  • Alerts for upcoming capital calls, missing K-1s, and new valuations, and a modeling view that blends the three scenarios into one projection.

Values, returns, and capital figures are computed from the dated transactions and valuations underneath them, and the outlook from each position's plan, so the dashboard, the tables, and the outlook draw on the same records and agree with each other.

For your business

The same pattern fits a sponsor or a portfolio company. Monthly reporting packages arrive in different formats; a custom build counts every company's numbers the same way, shows results against plan, and flags what needs attention before the board meeting.

Why custom

Each manager's investor portal shows only its own funds, and packaged portfolio software is built for large offices and priced to match. A custom build puts every commitment and direct deal in one place, in the investor's own categories, with no per-seat fee.

Built with

Next.js static export · TypeScript · Tailwind CSS · Recharts · built with Claude Code

Have a workflow like this?

Scoping a project costs nothing, and most take a 30-minute call. Tell me where the time goes.