Family office AI prompt

Private equity against public markets

Each fund ranked against the S&P 500, with the ones that beat public markets named.

For
COO, MFO/advisor
Topic
Alternatives
The prompt
Copy

Analyze each of our private equity funds using actual contributions, distributions and current NAV. Calculate IRR, TVPI, DPI and RVPI, then compare each fund against the [S&P 500] using the Kaplan-Schoar PME and Direct Alpha. Rank the funds by performance against public markets and tell me which have earned enough to justify their illiquidity.

Example output · Claude with Masttro connected
Example answer from Claude connected to Masttro MCP: each fund ranked against the S&P 500, with the ones that beat public markets named

Illustrative output based on Masttro's demo family office data.

What to look for
1
Fund-level multiples

IRR, TVPI, DPI and RVPI from actual contributions, distributions and NAV.

2
Against public markets

Kaplan-Schoar PME and Direct Alpha against the index you name.

3
Worth the lock-up?

Funds ranked by how much they beat public markets.

Before you run it

Replace [S&P 500] with the public index you want to compare against.

Ask next

Follow-up prompts

Use [MSCI World] instead of the S&P 500.

Copy

Show the same ranking by vintage year.

Copy

Which funds would we re-up with on this evidence?

Copy
Why it's useful

Why compare private equity with public markets?

A private equity fund can report a healthy IRR and still trail what the same money would have earned in an index fund. Since private equity locks capital up for years, beating public markets is the test that matters.

This prompt uses dated cash flows and NAV from Masttro and asks the AI to calculate public market equivalents. Index levels come from the AI tool, not Masttro.

01
The right yardstick

PME measures against what public markets would have returned.

02
Uses real cash flows

Dated contributions and distributions, not summary figures.

03
Supports re-up decisions

A follow-up asks which managers to back again.

FAQ

Questions about this prompt

What is Kaplan-Schoar PME?

A ratio comparing a fund's cash flows with the same flows invested in a public index. Above 1.0 means the fund beat the index.

What is Direct Alpha?

An annualized measure of how much a fund outperformed the index, using the same cash flows.

Where do index levels come from?

From the AI tool. Masttro supplies the fund cash flows and NAV.

Can I use a different index?

Yes. The first follow-up switches to MSCI World, or name any index in the prompt.

Masttro MCP

Run this prompt on your own Masttro data

Connect Claude or ChatGPT to the data you consolidate in Masttro. Read-only, scoped to each person's permissions, and switched on by your Super Admin.

Claude or ChatGPT
You paste the prompt here
Your AI tool
Masttro MCP
Applies your Masttro permissions
Read-only
Your Masttro data
Holdings, transactions and performance across every entity