Family Office AI Prompts
The questions family offices ask, ready to paste into Masttro intelligence or an external AI such as Claude or ChatGPT using Masttro's MCP server. A real sample output to each prompt is included.
Net worth and consolidated wealth
The full picture across entities, custodians and currencies, in one reporting currency.
Net worth by entity
What was our consolidated net worth at [month-end] in [USD], broken out by investment vehicle and asset class?
CopyOne net worth figure, then every investment vehicle split by asset class.

Illustrative output based on Masttro's demo family office data.
Month-end market values for every position, converted to your reporting currency and summed by investment vehicle (the entities in your Masttro structure) and by asset class.
- Now break it down by custodian, then by entity.
- Which three investment vehicles grew the most since [December 31]?
- Show the same table in [EUR].
What moved net worth
How has our net worth changed since [December 31], and why? Split the change into market performance, income, deposits, withdrawals and transfers, and name the positions behind the biggest moves.
CopyStart and end value, the change split by source, and the positions that drove it.

Illustrative output based on Masttro's demo family office data.
Opening and closing market value, deposits, withdrawals, transfers, realized and unrealized gains, and income for the period, with position-level detail.
- Run the same breakdown for the last month only.
- Which asset class contributed most of the market gain?
- List the deposits and withdrawals over [$1,000,000] behind that change.
Net worth over time by entity
Chart our net worth by entity over the last [three] years, month-end by month-end, and tell me which entities drove the change.
CopyA stacked chart of net worth by entity, with the drivers called out.

Illustrative output based on Masttro's demo family office data.
Up to 36 month-ends of holdings, rolled up by investment vehicle at ownership share.
- Show the same chart by asset class.
- Which months had the biggest jumps, and what caused them?
- Plot [JW Foundation] on its own.
Holding statement
Build a holding statement for [Client 1] at [month-end]: every position by investment vehicle with quantity, price, market value and share of the total, as a document I can download.
CopyA downloadable statement of every position, grouped by entity.

Illustrative output based on Masttro's demo family office data.
Every position at month-end with quantity, price, market value, currency and entity.
- Add each position’s year-to-date return.
- Make a version for [JW Foundation] only.
- Export it as a spreadsheet.
Performance and returns
TWR, IRR and since-inception XIRR by vehicle, asset class, account or custom grouping.
Asset classes against the portfolio
Rank our asset classes by year-to-date TWR as of [month-end] and flag any that trail the consolidated portfolio.
CopyA ranked list of asset-class returns with the laggards marked.

Illustrative output based on Masttro's demo family office data.
Time-weighted returns grouped by asset class, plus the consolidated TWR for the same period.
- Show the same ranking using IRR.
- Which holdings pulled [Commodities] down?
- Compare this ranking with the last 12 months.
Entity and account ranking
Rank our investment vehicles and accounts by [quarter-to-date] TWR, best to worst, and tell me what drove the top and bottom three.
CopyEvery entity ranked by return, with the reason behind the best and worst.

Illustrative output based on Masttro's demo family office data.
TWR grouped by investment vehicle or bank account for the period, with position-level P&L behind each.
- Do the same at the account level.
- Show year to date instead.
- Which positions explain [Dharma Trust]’s result?
Alternatives against equities
Compare the 12-month IRR of our alternative investments against our equities as of [month-end], reported in [EUR].
CopyTwo IRR figures side by side, in the currency you choose.

Illustrative output based on Masttro's demo family office data.
IRR grouped by asset class for a 12-month period, converted to the reporting currency you name.
- Add fixed income and real estate to the comparison.
- Show the same comparison year to date.
- Which alternative investments had the highest IRR?
Top contributors and detractors
Give me the top five contributors and detractors to [this month’s] performance, and explain anything that looks like a booking rather than a market move.
CopyThe five biggest gains and losses, with bookings separated from market moves.

Illustrative output based on Masttro's demo family office data.
Position-level P&L for the period, split into realized and unrealized gains and income.
- Show me how each of these figures was derived, with the source positions and transactions.
- Break the net result down by asset class.
- Run the same list for the quarter.
Realized and unrealized gains by entity
Compare our realized and unrealized gains by entity [year to date], and list the positions with the largest unrealized losses, for our tax planning discussion.
CopyRealized and unrealized gains for each entity, with the biggest paper losses listed.

Illustrative output based on Masttro's demo family office data.
Period realized and unrealized gains by position, grouped by investment vehicle.
- Which of those losses sit in taxable entities?
- Show the same split for the last 12 months.
- List realized gains by transaction date.
Review across the families you serve
Across all the families we serve, which had the largest drawdown [last month], and which have more than [30%] of net worth in alternatives?
CopyThe families with the biggest losses and the heaviest alternatives exposure, in one view.

Illustrative output based on Masttro's demo family office data.
Month-to-date TWR and asset-class holdings for each client in your Masttro tenant.
- Total our assets across every family.
- Which families have capital calls due before year end?
- Show each family’s exposure to [technology].
The quarter in three sentences
The principal will ask how we did [this quarter]. Give me the three-sentence answer, net of fees, then a one-page backup, then the question they’ll ask next and how to answer it.
CopyA three-sentence answer, the backup, and the likely next question.

Illustrative output based on Masttro's demo family office data.
Quarterly TWR and P&L, net of fees recorded in Masttro, by entity and asset class.
- Make the three sentences less technical.
- Add a chart to the backup.
- What would the answer be for the year to date?
Cash and liquidity
Balances by currency, account and entity, and where idle cash is building up.
Cash and near-cash by currency
How much cash and near-cash liquidity did we hold at [month-end] across all entities, custodians and currencies, reported in [USD]?
CopyTotal cash and near-cash, then a breakdown by currency, entity and custodian.

Illustrative output based on Masttro's demo family office data.
Cash, bank accounts and short-dated money market or Treasury holdings, with each one’s local currency, custodian, entity and value in your reporting currency.
- Which investment vehicle holds the most cash?
- How has total cash changed over the last [3] month-ends?
- List cash accounts holding less than [$50,000].
Idle cash
Which entities and accounts have held more than [$500,000] in cash at each of the last [three] month-ends, and how much of it could be put to work after our known capital calls?
CopyThe accounts where cash has sat above your threshold, and how much is spare.

Illustrative output based on Masttro's demo family office data.
Month-end cash balances by account, custodian and entity, plus unfunded commitments from closed-end funds.
- What did those balances total at the latest month-end?
- Show the same list in [CHF].
- Which of these accounts earn interest?
Liquidity by asset class
Break down our liquidity by asset class, from cash to illiquid, and give me a simple 12-month cash projection based on that.
CopyNet worth sorted by how fast it turns into cash, plus a 12-month cash outlook.

Illustrative output based on Masttro's demo family office data.
Holdings by asset class and security type, plus closed-end fund commitments and distribution history.
- How much could we raise in [30] days without selling real estate?
- Show the same tiers by entity.
- What happens if no distributions arrive this year?
Capital call and distribution calendar
Build a capital call and distribution calendar for the next [two quarters] from our closed-end funds, month by month, and show the net cash need each month.
CopyExpected calls and distributions by month, with the net cash need.

Illustrative output based on Masttro's demo family office data.
Unfunded commitments, past call and distribution timing for each closed-end fund. Future dates are estimates, since Masttro holds commitments and history rather than notices.
- Which calls are due in the next [30] days?
- Show the same calendar by investment vehicle.
- Can our current cash cover every month?
Distributions and contributions this year
Summarize all distributions and contributions across the family [this year], by entity and by type.
CopyMoney in and out for the year, by entity and type.

Illustrative output based on Masttro's demo family office data.
Deposits, withdrawals, transfers, capital calls and fund distributions by investment vehicle for the period.
- Show it month by month.
- Which entity funded the most capital calls?
- Separate family withdrawals from investment flows.
Alternatives and private markets
Capital calls, distributions, unfunded commitments, NAV and fund-level IRR.
Review across the families you serve
Across all the families we serve, which had the largest drawdown [last month], and which have more than [30%] of net worth in alternatives?
CopyThe families with the biggest losses and the heaviest alternatives exposure, in one view.

Illustrative output based on Masttro's demo family office data.
Month-to-date TWR and asset-class holdings for each client in your Masttro tenant.
- Total our assets across every family.
- Which families have capital calls due before year end?
- Show each family’s exposure to [technology].
Capital called and still uncalled
How much have we been called across our private funds [year to date], by fund and investment vehicle, and how much commitment is still uncalled?
CopyCapital called this year by fund and entity, plus what is still uncalled.

Illustrative output based on Masttro's demo family office data.
Capital call transactions for the period, matched to each closed-end fund’s commitment, capital called and unfunded commitment.
- Which funds have the most unfunded commitment left?
- How much did we receive in distributions over the same period?
- Show only the calls paid in the last [three] months.
Capital call and distribution calendar
Build a capital call and distribution calendar for the next [two quarters] from our closed-end funds, month by month, and show the net cash need each month.
CopyExpected calls and distributions by month, with the net cash need.

Illustrative output based on Masttro's demo family office data.
Unfunded commitments, past call and distribution timing for each closed-end fund. Future dates are estimates, since Masttro holds commitments and history rather than notices.
- Which calls are due in the next [30] days?
- Show the same calendar by investment vehicle.
- Can our current cash cover every month?
Closed-end fund scorecard
Show each closed-end fund’s vintage, paid-in capital, current value, TVPI, DPI and since-inception XIRR as of [month-end], ranked by XIRR, and flag the ones dragging the portfolio.
CopyOne row per fund with the standard private markets multiples, best to worst.

Illustrative output based on Masttro's demo family office data.
Commitment, capital called, distributions, market value, TVPI, DPI, RVPI and cumulative XIRR for each closed-end fund, plus its last valuation date.
- Which funds have a TVPI below [1.0x]?
- Group the funds by vintage year.
- Which funds have not reported a valuation in the last [12] months?
Vintage year diversification
How diversified are we across vintage years in our private equity commitments? Show commitments by vintage and flag any gaps or concentrations.
CopyCommitments by vintage year, with the gaps and clusters called out.

Illustrative output based on Masttro's demo family office data.
Commitment, vintage year and first investment date for each closed-end fund.
- Show TVPI by vintage year.
- Which vintages still have unfunded commitments?
- What would a steady annual commitment pace look like from here?
Stale valuations
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.
CopyEvery 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.
The last valuation date and value of every closed-end fund, measured against your month-end.
- Draft a request to each general partner for their latest statement.
- Which of these feed our performance and IRR figures?
- Show the same list by entity.
Entities and ownership
Questions about the structure itself: which entity, trust and branch owns what, and where.
Net worth over time by entity
Chart our net worth by entity over the last [three] years, month-end by month-end, and tell me which entities drove the change.
CopyA stacked chart of net worth by entity, with the drivers called out.

Illustrative output based on Masttro's demo family office data.
Up to 36 month-ends of holdings, rolled up by investment vehicle at ownership share.
- Show the same chart by asset class.
- Which months had the biggest jumps, and what caused them?
- Plot [JW Foundation] on its own.
Entity and account ranking
Rank our investment vehicles and accounts by [quarter-to-date] TWR, best to worst, and tell me what drove the top and bottom three.
CopyEvery entity ranked by return, with the reason behind the best and worst.

Illustrative output based on Masttro's demo family office data.
TWR grouped by investment vehicle or bank account for the period, with position-level P&L behind each.
- Do the same at the account level.
- Show year to date instead.
- Which positions explain [Dharma Trust]’s result?
Realized and unrealized gains by entity
Compare our realized and unrealized gains by entity [year to date], and list the positions with the largest unrealized losses, for our tax planning discussion.
CopyRealized and unrealized gains for each entity, with the biggest paper losses listed.

Illustrative output based on Masttro's demo family office data.
Period realized and unrealized gains by position, grouped by investment vehicle.
- Which of those losses sit in taxable entities?
- Show the same split for the last 12 months.
- List realized gains by transaction date.
Real estate by entity
Which investment vehicles hold our real estate, and what was each property worth at [month-end]?
CopyEach property with its owning entity and value.

Illustrative output based on Masttro's demo family office data.
Real estate positions by investment vehicle, with property type, market value and year-to-date return.
- Which properties lost value year to date?
- Total our real estate by country.
- Show the income our real estate has produced this year.
What sits under a trust
Which entities sit under the [Dharma Trust], and what does each one hold today? Show ownership percentages and avoid double counting.
CopyThe trust’s sub-entities, ownership share and holdings, without double counting.

Illustrative output based on Masttro's demo family office data.
The entity structure under the node you name, with holdings valued at each entity’s ownership share.
- Show the same view for [JW Foundation].
- Which of these entities hold assets outside the US?
- Draw this as an org chart.
Explain the structure to a new trustee
Explain our ownership structure in plain English for a new trustee: who owns what, where the money sits, and which entities hold the largest assets. Include a simple diagram.
CopyA plain-English walkthrough of the structure with a simple diagram.

Illustrative output based on Masttro's demo family office data.
The entity structure and holdings by investment vehicle.
- Write this as a one-page memo I can send.
- Add what each entity is used for.
- Explain it for someone outside finance.
Currency exposure by entity
Which entities hold assets in more than one currency, and what share of each entity is outside [USD]?
CopyEach multi-currency entity with its currencies and non-USD share.

Illustrative output based on Masttro's demo family office data.
Holdings by investment vehicle with each position’s local currency and value in your reporting currency.
- What would a 10% fall in [GBP] do to each entity?
- Show the same in [EUR] as the base currency.
- Which positions make up the non-USD share?
Equity drawdown by entity
Model a [20%] equity drawdown across the structure. Which entities take the biggest hit? Show your assumptions, including how you treat private equity.
CopyThe loss by entity under a market fall, with the assumptions stated.

Illustrative output based on Masttro's demo family office data.
Holdings by entity and asset class, with security types so listed and private equity can be treated separately.
- Run the same test at [30%].
- Which single positions lose the most?
- How much liquid capital would we have left?
Transactions and activity
Large movements, income and activity by entity or account.
Large transactions review
List all transactions over [$250,000] in the [90 days] to [month-end], grouped by investment vehicle, and flag anything unusual.
CopyEvery large transaction under the entity that made it, with the odd ones flagged.

Illustrative output based on Masttro's demo family office data.
Transaction date, type, asset, amount and investment vehicle for each transaction in the period.
- Which of these were capital calls or distributions?
- Total the buys and sells by asset class.
- Show withdrawals over [$100,000] only.
Distributions and contributions this year
Summarize all distributions and contributions across the family [this year], by entity and by type.
CopyMoney in and out for the year, by entity and type.

Illustrative output based on Masttro's demo family office data.
Deposits, withdrawals, transfers, capital calls and fund distributions by investment vehicle for the period.
- Show it month by month.
- Which entity funded the most capital calls?
- Separate family withdrawals from investment flows.
Allocation and concentration
Where wealth sits, and which positions carry the most weight.
Currency exposure by entity
Which entities hold assets in more than one currency, and what share of each entity is outside [USD]?
CopyEach multi-currency entity with its currencies and non-USD share.

Illustrative output based on Masttro's demo family office data.
Holdings by investment vehicle with each position’s local currency and value in your reporting currency.
- What would a 10% fall in [GBP] do to each entity?
- Show the same in [EUR] as the base currency.
- Which positions make up the non-USD share?
Largest positions
What were our [10] largest positions at [month-end], and what share of total net worth is each? Combine positions held in more than one entity.
CopyThe biggest positions ranked, each as a share of net worth.

Illustrative output based on Masttro's demo family office data.
Position-level market values across every entity, combined where the same asset is held more than once, ranked and divided by total net worth.
- Which custodian holds each of these positions?
- How has each of these performed year to date?
- Show the top 10 inside the [Dharma Trust] only.
Concentration by asset class, sector and geography
Where are we most concentrated by asset class, sector and geography? Flag anything above [15%] of net worth.
CopyThree concentration views, with anything over your threshold flagged.

Illustrative output based on Masttro's demo family office data.
Holdings with asset class, sector and geographic exposure for every position.
- How has our sector mix shifted over the past year?
- What is our total exposure to [emerging markets]?
- Show the same view for [JW Foundation] only.
Exposure to a single company
What is our total exposure to [Apple] across every entity, held directly or through ETFs and funds? Show where it sits.
CopyDirect and look-through exposure to one company, entity by entity.

Illustrative output based on Masttro's demo family office data.
Every position in that company across entities, plus ETF holdings. Look-through weights inside ETFs come from Claude, since Masttro doesn’t hold fund constituents.
- Run the same check for [NVIDIA] and [Microsoft].
- What share of our listed equity is in the top five US tech names?
- Which entity would be hit hardest if [Apple] fell 30%?
The three biggest risks
What are the three biggest financial risks in our portfolio right now, and why? Put a number on each.
CopyThree risks, each with a dollar figure and the reason it matters.

Illustrative output based on Masttro's demo family office data.
Holdings, performance and closed-end fund data, used to size concentration, liquidity and valuation risk.
- What could we do about each one?
- Which of these has grown in the last year?
- Rank the same risks for [JW Foundation].
Risk and scenarios
Test how the family's wealth holds up before markets decide for you. These prompts run historical stress tests, Monte Carlo projections and concentration checks on your live Masttro data, so the principal sees the downside in plain numbers.
Equity drawdown by entity
Model a [20%] equity drawdown across the structure. Which entities take the biggest hit? Show your assumptions, including how you treat private equity.
CopyThe loss by entity under a market fall, with the assumptions stated.

Illustrative output based on Masttro's demo family office data.
Holdings by entity and asset class, with security types so listed and private equity can be treated separately.
- Run the same test at [30%].
- Which single positions lose the most?
- How much liquid capital would we have left?
Rate cut impact
Model the impact of a [200bps] rate cut on our fixed income and real estate holdings, and on what we pay on our loans. Show your assumptions.
CopyThe estimated gain on bonds and property, and the saving on loans, with assumptions.

Illustrative output based on Masttro's demo family office data.
Fixed income positions with type and maturity where available, real estate values by property, and loan balances.
- Run the same for a [100bps] rise.
- Which bond positions gain the most?
- How sensitive is each property to a change in cap rates?
The three biggest risks
What are the three biggest financial risks in our portfolio right now, and why? Put a number on each.
CopyThree risks, each with a dollar figure and the reason it matters.

Illustrative output based on Masttro's demo family office data.
Holdings, performance and closed-end fund data, used to size concentration, liquidity and valuation risk.
- What could we do about each one?
- Which of these has grown in the last year?
- Rank the same risks for [JW Foundation].
Principal briefings
Plain-language summaries a principal can read in two minutes.
Explain the structure to a new trustee
Explain our ownership structure in plain English for a new trustee: who owns what, where the money sits, and which entities hold the largest assets. Include a simple diagram.
CopyA plain-English walkthrough of the structure with a simple diagram.

Illustrative output based on Masttro's demo family office data.
The entity structure and holdings by investment vehicle.
- Write this as a one-page memo I can send.
- Add what each entity is used for.
- Explain it for someone outside finance.
Monthly principal summary
Write a one-page summary of [October 2026] for the principal: net worth, performance, allocation, cash, capital flows and anything unusual.
CopyA short written briefing with the month’s numbers and items to look at.

Illustrative output based on Masttro's demo family office data.
Holdings, month-to-date performance and the month’s transactions, written up as a one-page briefing.
- Turn this into five bullet points.
- Add a comparison with the same month last year.
- Write it in [Spanish].
Meeting briefing
Prepare a briefing for my meeting with the [Wilson family] on [Friday]: where they stand, what changed since our last review, anything I should flag, and the questions they are likely to ask.
CopyA meeting-ready briefing with flags and likely questions.

Illustrative output based on Masttro's demo family office data.
Current holdings, recent performance and transactions, and closed-end fund commitments for the family.
- Cut it to half a page.
- Add a short answer to each likely question.
- Draft the follow-up email for after the meeting.
The quarter in three sentences
The principal will ask how we did [this quarter]. Give me the three-sentence answer, net of fees, then a one-page backup, then the question they’ll ask next and how to answer it.
CopyA three-sentence answer, the backup, and the likely next question.

Illustrative output based on Masttro's demo family office data.
Quarterly TWR and P&L, net of fees recorded in Masttro, by entity and asset class.
- Make the three sentences less technical.
- Add a chart to the backup.
- What would the answer be for the year to date?
Explain it to the next generation
Explain our holdings and overall strategy to my [24-year-old] in one page, with no jargon.
CopyA one-page plain-language explanation for the next generation.

Illustrative output based on Masttro's demo family office data.
Holdings by asset class and entity, written up without technical terms.
- Add a short glossary of the words they will hear in meetings.
- Explain what a trust is and why we use one.
- Make it a five-minute talk instead.
Holding statement
Build a holding statement for [Client 1] at [month-end]: every position by investment vehicle with quantity, price, market value and share of the total, as a document I can download.
CopyA downloadable statement of every position, grouped by entity.

Illustrative output based on Masttro's demo family office data.
Every position at month-end with quantity, price, market value, currency and entity.
- Add each position’s year-to-date return.
- Make a version for [JW Foundation] only.
- Export it as a spreadsheet.
Data quality
Find the gaps before the family does. These prompts look for missing prices, stale valuations, unreconciled transactions and holdings with no entity attached, so your team can fix the data before it reaches a report.
Stale valuations
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.
CopyEvery 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.
The last valuation date and value of every closed-end fund, measured against your month-end.
- Draft a request to each general partner for their latest statement.
- Which of these feed our performance and IRR figures?
- Show the same list by entity.
Interactive dashboards
Ask for a dashboard and the AI tool builds one from live Masttro data, with filters you can use in the chat.
Public equities
Listed equity exposure by custodian, currency and entity.
Alternatives against equities
Compare the 12-month IRR of our alternative investments against our equities as of [month-end], reported in [EUR].
CopyTwo IRR figures side by side, in the currency you choose.

Illustrative output based on Masttro's demo family office data.
IRR grouped by asset class for a 12-month period, converted to the reporting currency you name.
- Add fixed income and real estate to the comparison.
- Show the same comparison year to date.
- Which alternative investments had the highest IRR?
Exposure to a single company
What is our total exposure to [Apple] across every entity, held directly or through ETFs and funds? Show where it sits.
CopyDirect and look-through exposure to one company, entity by entity.

Illustrative output based on Masttro's demo family office data.
Every position in that company across entities, plus ETF holdings. Look-through weights inside ETFs come from Claude, since Masttro doesn’t hold fund constituents.
- Run the same check for [NVIDIA] and [Microsoft].
- What share of our listed equity is in the top five US tech names?
- Which entity would be hit hardest if [Apple] fell 30%?
Equity drawdown by entity
Model a [20%] equity drawdown across the structure. Which entities take the biggest hit? Show your assumptions, including how you treat private equity.
CopyThe loss by entity under a market fall, with the assumptions stated.

Illustrative output based on Masttro's demo family office data.
Holdings by entity and asset class, with security types so listed and private equity can be treated separately.
- Run the same test at [30%].
- Which single positions lose the most?
- How much liquid capital would we have left?
Public equity exposure
What was our public equity exposure at [month-end] by custodian, currency and region?
CopyListed equity by custodian, currency and region.

Illustrative output based on Masttro's demo family office data.
Equity positions with custodian, local currency, geographic exposure and market value.
- What is our exposure to [Apple] through these funds?
- How did each custodian’s equity perform year to date?
- What happens if equities fall [20%]?
Fixed income
Bonds and other fixed income by maturity, currency and issuer.
Rate cut impact
Model the impact of a [200bps] rate cut on our fixed income and real estate holdings, and on what we pay on our loans. Show your assumptions.
CopyThe estimated gain on bonds and property, and the saving on loans, with assumptions.

Illustrative output based on Masttro's demo family office data.
Fixed income positions with type and maturity where available, real estate values by property, and loan balances.
- Run the same for a [100bps] rise.
- Which bond positions gain the most?
- How sensitive is each property to a change in cap rates?
Fixed income by custodian
List our fixed income holdings at [month-end] by custodian and currency, with market value and accrued interest.
CopyFixed income by custodian and currency, with accrued interest.

Illustrative output based on Masttro's demo family office data.
Fixed income positions with custodian, local currency, market value and accrued interest.
- What would a [200bps] rate cut do to these holdings?
- Which bonds mature in the next [12] months?
- Show the same in [BRL].
Cash
Cash and deposits across every bank and custodian.
Cash and near-cash by currency
How much cash and near-cash liquidity did we hold at [month-end] across all entities, custodians and currencies, reported in [USD]?
CopyTotal cash and near-cash, then a breakdown by currency, entity and custodian.

Illustrative output based on Masttro's demo family office data.
Cash, bank accounts and short-dated money market or Treasury holdings, with each one’s local currency, custodian, entity and value in your reporting currency.
- Which investment vehicle holds the most cash?
- How has total cash changed over the last [3] month-ends?
- List cash accounts holding less than [$50,000].
Idle cash
Which entities and accounts have held more than [$500,000] in cash at each of the last [three] month-ends, and how much of it could be put to work after our known capital calls?
CopyThe accounts where cash has sat above your threshold, and how much is spare.

Illustrative output based on Masttro's demo family office data.
Month-end cash balances by account, custodian and entity, plus unfunded commitments from closed-end funds.
- What did those balances total at the latest month-end?
- Show the same list in [CHF].
- Which of these accounts earn interest?
Liquidity by asset class
Break down our liquidity by asset class, from cash to illiquid, and give me a simple 12-month cash projection based on that.
CopyNet worth sorted by how fast it turns into cash, plus a 12-month cash outlook.

Illustrative output based on Masttro's demo family office data.
Holdings by asset class and security type, plus closed-end fund commitments and distribution history.
- How much could we raise in [30] days without selling real estate?
- Show the same tiers by entity.
- What happens if no distributions arrive this year?
Private equity
Buyout and growth funds, direct investments and co-investments.
Alternatives against equities
Compare the 12-month IRR of our alternative investments against our equities as of [month-end], reported in [EUR].
CopyTwo IRR figures side by side, in the currency you choose.

Illustrative output based on Masttro's demo family office data.
IRR grouped by asset class for a 12-month period, converted to the reporting currency you name.
- Add fixed income and real estate to the comparison.
- Show the same comparison year to date.
- Which alternative investments had the highest IRR?
Capital called and still uncalled
How much have we been called across our private funds [year to date], by fund and investment vehicle, and how much commitment is still uncalled?
CopyCapital called this year by fund and entity, plus what is still uncalled.

Illustrative output based on Masttro's demo family office data.
Capital call transactions for the period, matched to each closed-end fund’s commitment, capital called and unfunded commitment.
- Which funds have the most unfunded commitment left?
- How much did we receive in distributions over the same period?
- Show only the calls paid in the last [three] months.
Capital call and distribution calendar
Build a capital call and distribution calendar for the next [two quarters] from our closed-end funds, month by month, and show the net cash need each month.
CopyExpected calls and distributions by month, with the net cash need.

Illustrative output based on Masttro's demo family office data.
Unfunded commitments, past call and distribution timing for each closed-end fund. Future dates are estimates, since Masttro holds commitments and history rather than notices.
- Which calls are due in the next [30] days?
- Show the same calendar by investment vehicle.
- Can our current cash cover every month?
Closed-end fund scorecard
Show each closed-end fund’s vintage, paid-in capital, current value, TVPI, DPI and since-inception XIRR as of [month-end], ranked by XIRR, and flag the ones dragging the portfolio.
CopyOne row per fund with the standard private markets multiples, best to worst.

Illustrative output based on Masttro's demo family office data.
Commitment, capital called, distributions, market value, TVPI, DPI, RVPI and cumulative XIRR for each closed-end fund, plus its last valuation date.
- Which funds have a TVPI below [1.0x]?
- Group the funds by vintage year.
- Which funds have not reported a valuation in the last [12] months?
Vintage year diversification
How diversified are we across vintage years in our private equity commitments? Show commitments by vintage and flag any gaps or concentrations.
CopyCommitments by vintage year, with the gaps and clusters called out.

Illustrative output based on Masttro's demo family office data.
Commitment, vintage year and first investment date for each closed-end fund.
- Show TVPI by vintage year.
- Which vintages still have unfunded commitments?
- What would a steady annual commitment pace look like from here?
Venture capital
Venture funds and direct stakes, by vintage year.
Capital called and still uncalled
How much have we been called across our private funds [year to date], by fund and investment vehicle, and how much commitment is still uncalled?
CopyCapital called this year by fund and entity, plus what is still uncalled.

Illustrative output based on Masttro's demo family office data.
Capital call transactions for the period, matched to each closed-end fund’s commitment, capital called and unfunded commitment.
- Which funds have the most unfunded commitment left?
- How much did we receive in distributions over the same period?
- Show only the calls paid in the last [three] months.
Venture capital positions
Show our venture capital and growth positions at [month-end] with cost, current value, TVPI and since-inception XIRR.
CopyEach venture position with cost, value and return.

Illustrative output based on Masttro's demo family office data.
Capital called, distributions, market value, TVPI and XIRR for each venture and growth fund.
- Which of these are still calling capital?
- Group them by first investment year.
- Which have been written down?
Hedge funds
Hedge fund allocations and their returns.
Hedge fund returns
How have our hedge fund holdings performed [year to date] and over the last 12 months, as of [month-end]?
CopyYear-to-date and 12-month returns for each hedge fund.

Illustrative output based on Masttro's demo family office data.
Hedge fund positions with market value, TWR for the periods requested and last valuation date.
- Which have the oldest valuations?
- How much is still uncommitted to [Early Funding]?
- Compare these with a hedge fund index.
Real estate
Commercial, residential and land, held directly or through entities.
Real estate by entity
Which investment vehicles hold our real estate, and what was each property worth at [month-end]?
CopyEach property with its owning entity and value.

Illustrative output based on Masttro's demo family office data.
Real estate positions by investment vehicle, with property type, market value and year-to-date return.
- Which properties lost value year to date?
- Total our real estate by country.
- Show the income our real estate has produced this year.
Rate cut impact
Model the impact of a [200bps] rate cut on our fixed income and real estate holdings, and on what we pay on our loans. Show your assumptions.
CopyThe estimated gain on bonds and property, and the saving on loans, with assumptions.

Illustrative output based on Masttro's demo family office data.
Fixed income positions with type and maturity where available, real estate values by property, and loan balances.
- Run the same for a [100bps] rise.
- Which bond positions gain the most?
- How sensitive is each property to a change in cap rates?
Real estate by type
What was our real estate worth at [month-end], split between commercial, residential, industrial and land, and by country?
CopyReal estate by property type and by country.

Illustrative output based on Masttro's demo family office data.
Real estate positions with property type, country and market value.
- Which property type returned most this year?
- Show the income each property produced.
- How much of our real estate is held outside USD?
Collectibles and lifestyle
Art, jewelry, motor vehicles, yachts, aircraft and collections.
Lifestyle assets
List our art, collections, aircraft, yachts and cars by holding entity, with their value at [month-end].
CopyEvery lifestyle asset with its owning entity and value.

Illustrative output based on Masttro's demo family office data.
Collections and motor vehicle positions by investment vehicle, with market value and last valuation.
- Which of these haven’t been appraised in the last [two] years?
- Total our lifestyle assets by entity.
- Which are insured, and for how much?
MCP Setup
Connected in three steps.
Walk through the real setup in the demo below: switch on access, connect your AI tool and ask your first question.
Step 1
Enable
Your Super Admin enables MCP access for selected people.
Step 2
Connect
Each person connects a compatible AI tool and signs in with their Masttro credentials.
Step 3
Ask
Masttro returns only the data that person is permitted to see.
See Masttro MCP in action
Book a demo to see Masttro MCP connected to an AI tool, and why more than 400 family offices in 40+ countries choose Masttro.
Masttro MCP and API access with no additional Masttro charge
750+ direct custodian feeds, with no third-party aggregators
Entities, trusts and ownership structures in one system, so your AI tool works from who owns what
Fixed pricing, not AUM-based, so growth does not raise your platform costs


