Family office AI prompt

Closed-end fund scorecard

One row per fund with the standard private markets multiples, best to worst.

For
COO, MFO/advisor
Topic
Alternatives
The prompt
Copy

Show each closed-end fund’s vintage, paid-in capital, current value, TVPI, DPI and since-inception XIRR as of [month-end], ranked by XIRR, and flag the ones dragging the portfolio.

Example output · Claude with Masttro connected
Example answer from Claude connected to Masttro MCP: one row per fund with the standard private markets multiples, best to worst

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

What to look for
1
One row per fund

Vintage, paid-in capital and current value for every closed-end fund.

2
The standard multiples

TVPI, DPI and since-inception XIRR, ranked best to worst.

3
Drag flagged

Funds pulling the private markets result down are marked.

Before you run it

Replace [month-end] with the valuation date you report on.

Ask next

Follow-up prompts

Which funds have a TVPI below [1.0x]?

Copy

Group the funds by vintage year.

Copy

Which funds have not reported a valuation in the last [12] months?

Copy
Why it's useful

Why keep a fund scorecard?

Private markets reporting usually arrives fund by fund in different formats and on different dates. Without one table, it is hard to tell which commitments are working.

This prompt lays out the multiples every GP reports in a single ranked view, with the last valuation date for each fund. The COO gets a consistent scorecard, and stale marks are easy to spot.

01
Consistent measures

TVPI, DPI and XIRR for every fund in one table.

02
Ranked

Best and worst performers are obvious at a glance.

03
Valuation dates shown

See which numbers rest on old marks.

FAQ

Questions about this prompt

What do TVPI and DPI mean?

TVPI is total value (distributions plus remaining value) divided by paid-in capital. DPI is distributions divided by paid-in capital, the part already returned as cash.

Why XIRR?

XIRR is an IRR that uses the actual dates of each call and distribution, which suits private funds.

Can I group by vintage?

Yes. A follow-up groups funds by vintage year.

Can I find funds with old valuations?

Yes. The last follow-up lists funds without a valuation in the last 12 months.

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