Family office AI prompt

Asset classes against the portfolio

A ranked list of asset-class returns with the laggards marked.

For
Principal, COO, MFO/advisor
Topic
Performance
The prompt
Copy

Rank our asset classes by year-to-date TWR as of [month-end] and flag any that trail the consolidated portfolio.

Example output · Claude with Masttro connected
Example answer from Claude connected to Masttro MCP: a ranked list of asset-class returns with the laggards marked

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

What to look for
1
A ranked list

Every asset class ordered by year-to-date time-weighted return.

2
The portfolio benchmark

The consolidated TWR for the same period, so each class is judged against the whole.

3
The laggards flagged

Asset classes trailing the consolidated return are marked for a closer look.

Before you run it

Replace [month-end] with the date you want returns measured to.

Ask next

Follow-up prompts

Show the same ranking using IRR.

Copy

Which holdings pulled [Commodities] down?

Copy

Compare this ranking with the last 12 months.

Copy
Why it's useful

Why compare each asset class to the whole portfolio?

An asset class with a positive return can still be a drag. If equities, alternatives and fixed income all rose but one rose far less than the family's overall result, that class is the place to ask questions.

This prompt measures every class against the consolidated time-weighted return for the same period, so the comparison is like for like and free of the timing of contributions and withdrawals.

01
Time-weighted, like for like

TWR removes the effect of money moving in and out.

02
Judged against your own result

The yardstick is the family's portfolio, not a generic index.

03
A clear next step

Follow-ups switch to IRR or drill into the holdings behind a laggard.

FAQ

Questions about this prompt

Why time-weighted return?

TWR strips out the effect of contributions and withdrawals, so each asset class is judged on its investments rather than on when cash arrived.

What counts as trailing?

Any asset class whose year-to-date TWR is below the consolidated portfolio's TWR for the same period.

Can I use IRR instead?

Yes. The first follow-up reruns the same ranking using IRR, which reflects the timing of cash flows.

Which asset classes are included?

Every asset class in your Masttro holdings that you have permission to see.

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