Family office AI prompt

24-month liquidity projection

Three cash paths over 24 months, the month a shortfall could start, and how to cover it.

For
Principal, COO
Topic
Cash and liquidity
The prompt
Copy

Project our liquidity over the next 24 months under three scenarios: base case, accelerated capital calls, and accelerated calls with delayed distributions. Use our cash, liquid investments, unfunded commitments, past capital calls and distributions, and [$800,000] a month in living and operating costs. Show when we could fall below a [$15M] cash buffer, how big the gap would be, and which liquid assets could cover it.

Example output · Claude with Masttro connected
Example answer from Claude connected to Masttro MCP: three cash paths over 24 months, the month a shortfall could start, and how to cover it

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

What to look for
1
Three cash paths

Base case, accelerated calls, and accelerated calls with delayed distributions.

2
The shortfall month

When cash could fall below your buffer, and by how much.

3
What could cover it

The liquid assets that could fill the gap.

Before you run it

Replace [$800,000] with your monthly spending and [$15M] with the cash buffer you keep.

Ask next

Follow-up prompts

What happens if we fund the next capital call from the operating entity?

Copy

Add a new [$5M] private equity commitment and show its J-curve.

Copy

Turn this into an interactive chart with sliders for each assumption.

Copy
Why it's useful

Why model liquidity under more than one scenario?

Capital calls rarely arrive on schedule, and distributions slow down exactly when markets are weak. A single projection gives false comfort.

This prompt uses your cash, liquid holdings, unfunded commitments and call and distribution history to draw three paths over 24 months, including family spending. The answer shows when a shortfall could start and what you would sell or draw to cover it.

01
Plans for the bad case

Accelerated calls and delayed distributions are modeled directly.

02
Your own numbers

Built from your commitments and history, plus the spending you set.

03
A clear action

Names the liquid assets that could close a gap.

FAQ

Questions about this prompt

Where do the assumptions come from?

Cash, liquid holdings, unfunded commitments and past calls and distributions come from Masttro. Spending and the cash buffer are the figures you put in the prompt.

Is this a forecast?

No. It is a scenario model based on your history. Fund notices and GP guidance can change the timing.

Can I add a new commitment?

Yes. A follow-up adds a new private equity commitment and shows its J-curve.

Can I make it interactive?

Yes. The last follow-up turns the projection into a chart with sliders for each assumption.

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