Meridian Family Trust · Wealth Case · As of 2026-06-30
Illustrative workflow — reference data · Draft for review
Source-backed portfolio review evidence report connecting portfolio YTD returns, IPS compliance rules, custodian holdings feeds, and benchmark comparisons.
Each portfolio metric, asset allocation figure, and compliance rule status used in the review pack appears below with its exact source link and review status.
“Portfolio YTD return of +8.4% outperforming 60/40 benchmark (+7.8%)”
SourcedCustodian report — Custodian_Export_Q2.xlsx · Performance sheet · cell B4 · value +0.084 · as of 2026-06-30
“Total portfolio value reached $14.82 million with a net YTD total return of +8.4%, compared to +7.8% for the custom 60/40 benchmark.”
“Public Equity allocation weight of 26.5% remains compliant with IPS ceiling (< 70.0%)”
Derived — verifiedCustodian report — Custodian_Export_Q2.xlsx · Allocation sheet · cell C12 · value 3,927,300 · as of 2026-06-30
Custodian report — Custodian_Export_Q2.xlsx · Allocation sheet · cell C4 · value 14,820,000 · as of 2026-06-30
How it is derived: Public Equity asset value ($3.93M) divided by Total Portfolio Value ($14.82M). IPS v4.2 §2.1 specifies maximum equity allocation ceiling of 70.0%.
“Apple Inc. (AAPL) holding weight of 6.5% exceeds the single-stock IPS concentration cap of 6.0%”
IPS Breach — rebalance requiredInvestment Policy Statement — IPS_v4.2.pdf · Section 3.1 Concentration Rules · p. 6 · as of 2026-06-30
Custodian report — Custodian_Export_Q2.xlsx · Holdings sheet · row 4 · AAPL value $963,300 (6.5%) · as of 2026-06-30
What to verify: Rule breach. IPS v4.2 §3.1 caps individual equity positions at 6.0% of total portfolio value. An advisor must review rebalancing proposal or request waiver authorization prior to client presentation.
“Microsoft Corp. (MSFT) holding weight of 7.2% exceeds the single-stock IPS concentration cap of 6.0%”
IPS Breach — rebalance requiredInvestment Policy Statement — IPS_v4.2.pdf · Section 3.1 Concentration Rules · p. 6 · as of 2026-06-30
Custodian report — Custodian_Export_Q2.xlsx · Holdings sheet · row 5 · MSFT value $1,067,040 (7.2%) · as of 2026-06-30
What to verify: Rule breach. Position appreciated rapidly over Q1/Q2. Advisor rebalancing proposal required before quarterly client meeting.
“Weighted portfolio yield of 3.4% meets the IPS income target (> 3.2%)”
Derived — verifiedCustodian report — Custodian_Export_Q2.xlsx · Yield sheet · cell D8 · value 0.034 · as of 2026-06-30
How it is derived: Sum of asset yields weighted by position market value across fixed income, dividend equity, and cash holdings.
“Fixed Income allocation of 28.0% ($4.15M) provides downside buffer with 5.2-year duration”
Sourced — verify before useCustodian report — Custodian_Export_Q2.xlsx · FixedIncome sheet · cell B10 · value 4,149,600 · as of 2026-06-30
What to verify: Confirm duration calculation matches benchmark index changes following recent Federal Reserve rate shifts before client presentation.
“Private Credit commitment of $1.50M (10.1% weight) fully called with 11.2% net IRR”
Derived — needs analystQuarterly Manager Report — PrivateCredit_Q2_Statement.pdf · p. 3 · as of 2026-06-30
What to verify: Net IRR is reported on a quarter-lagged basis by fund administrator. Advisor must confirm lag footnote is included in final presentation pack.
Candidate material rejected at source review. No claim in the review pack relies on it.
Unverified third-party crypto allocation pitch
Excluded — IPS policyUnapproved asset class: IPS v4.2 explicitly restricts crypto assets. Excluded from portfolio review per workflow policy rules.