Family office AI prompt

Stale valuations

Every fund with an out-of-date valuation, sorted by value, with the share of net worth it affects.

For
COO, MFO/advisor
Topic
Data quality
The prompt
Copy

Which of our private investments haven’t been revalued in the last [two quarters]? Sort them by value, show the date and age of each valuation, and tell me how much of our net worth rests on stale numbers.

Example output · Claude with Masttro connected
Example answer from Claude connected to Masttro MCP: every fund with an out-of-date valuation, sorted by value, with the share of net worth it affects

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

What to look for
1
Every stale valuation

Private investments not revalued within your window.

2
Date and age

When each was last valued and how old that is.

3
Share of net worth

How much of the family's wealth rests on stale numbers.

Before you run it

Replace [two quarters] with the age at which you treat a valuation as stale.

Ask next

Follow-up prompts

Draft a request to each general partner for their latest statement.

Copy

Which of these feed our performance and IRR figures?

Copy

Show the same list by entity.

Copy
Why it's useful

Why measure how much of net worth rests on stale valuations?

Private funds report quarterly at best, and some marks lag much further. When a large share of net worth is valued months ago, the headline figure is less reliable than it looks.

This prompt measures the last valuation date of every closed-end fund against your month-end and puts a percentage on the problem, which is the number a principal should know before trusting the total.

01
A reliability check

Shows how current the net worth figure really is.

02
Sorted by value

The largest stale positions come first.

03
Easy follow-through

A follow-up drafts requests to each GP.

FAQ

Questions about this prompt

Which investments are checked?

Every closed-end fund in Masttro, measured against the month-end you report on.

Can it request updated statements?

Yes. The first follow-up drafts a request to each general partner.

Does it affect performance figures?

A follow-up shows which stale funds feed your performance and IRR figures.

Can I see it by entity?

Yes. The last follow-up groups the list by entity.

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