Family office AI prompt

Risk, return and the efficient frontier

Where the portfolio sits on the efficient frontier, and a better mix at the same risk.

For
COO, MFO/advisor
Topic
Risk and scenarios
The prompt
Copy

Using our current holdings, calculate our expected annualized return, volatility, Sharpe ratio and correlation across asset classes. Then build an efficient frontier and show whether a different allocation could raise expected return without adding risk. Keep illiquid assets fixed, show the proposed allocation and quantify the improvement.

Example output · Claude with Masttro connected
Example answer from Claude connected to Masttro MCP: where the portfolio sits on the efficient frontier, and a better mix at the same risk

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

What to look for
1
Current risk and return

Expected return, volatility, Sharpe ratio and correlations.

2
The efficient frontier

Where the portfolio sits against the best available mixes.

3
A better allocation

A proposed mix at the same risk, with illiquid assets held fixed.

Before you run it

Run as written. Use the follow-ups to loosen constraints on real estate.

Ask next

Follow-up prompts

Show the correlation matrix.

Copy

What allocation gives the same return with the least risk?

Copy

Rerun allowing a [10%] change in real estate.

Copy
Why it's useful

Why plot the portfolio on an efficient frontier?

Most family portfolios grew by accretion: a mandate here, a property there. The result is rarely the most efficient mix for the risk the family is taking.

This prompt measures the current portfolio and shows whether a different allocation could raise expected return without more risk. It keeps illiquid assets fixed, because they can't be rebalanced on paper.

01
A quantified improvement

Shows how much a better mix could add.

02
Realistic constraints

Illiquid holdings stay where they are.

03
Assumptions stated

Capital market assumptions come from the AI and are shown.

FAQ

Questions about this prompt

Where do the assumptions come from?

Holdings and historical returns come from Masttro. Forward-looking capital market assumptions come from the AI tool.

Why keep illiquid assets fixed?

Private funds and property can't be resized quickly, so the proposal only moves assets that can actually be traded.

Can I see the correlations?

Yes. The first follow-up shows the correlation matrix.

Is this investment advice?

No. It is an analysis to discuss with your CIO or advisers.

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