Family office AI prompt

Net worth over time by entity

A stacked chart of net worth by entity, with the drivers called out.

For
Principal, COO
Topic
Net worth
The prompt
Copy

Chart our net worth by entity over the last [three] years, month-end by month-end, and tell me which entities drove the change.

Example output · Claude with Masttro connected
Example answer from Claude connected to Masttro MCP: a stacked chart of net worth by entity, with the drivers called out

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

What to look for
1
A month-by-month chart

Net worth at each month-end over the period, stacked by entity so you see both the total and its parts.

2
Ownership share applied

Each vehicle is counted at the family's share of it, so jointly held entities aren't overstated.

3
The drivers called out

The answer names the entities that moved the total most, not just the shape of the line.

Before you run it

Replace [three] with the number of years you want to chart. Up to 36 month-ends are available.

Ask next

Follow-up prompts

Show the same chart by asset class.

Copy

Which months had the biggest jumps, and what caused them?

Copy

Plot [JW Foundation] on its own.

Copy
Why it's useful

Why look at net worth as a trend by entity?

A single month-end figure can hide a slow drift. One entity may be growing steadily while another is being drawn down to fund the family, and the total can look flat the whole time.

Charting each entity month by month shows when the mix changed and which part of the structure caused it. That is usually the conversation a principal or trustee wants to have, and it is hard to rebuild from spreadsheets.

01
See the drift, not the snapshot

Month-end values over years show trends a single report misses.

02
Stacked by entity

The chart keeps every vehicle visible inside the total.

03
Easy to narrow

Follow-ups switch the view to asset classes or isolate one entity.

FAQ

Questions about this prompt

How far back can the chart go?

Up to 36 month-ends, so three years by default. Ask for fewer years by changing [three].

How are partly owned entities counted?

At ownership share. Holdings are rolled up to each investment vehicle at the family's percentage, which avoids counting the same asset twice.

Can I chart a single entity?

Yes. Use the follow-up that plots one entity on its own, and replace the bracketed name with the entity you want.

Is the chart interactive?

That depends on the AI tool. Claude can draw the chart in the conversation, and you can ask it to add filters or turn it into an interactive view.

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