- Before
- Closes the quarter's official returns, then fields 30–40 “why” questions a week. “I can explain the 142 basis points. What takes the day is finding the PM's reason and proving every number.”
- Now
- Opens a draft already bound to the official cells, with the PM's reasons quoted and seven checks run; she reads, approves with a reason code and signs.
Performance attribution analysis, one consultant question at a time
Thursday, October 15, 16:42 ET. James Whitcombe of Hartwell Consulting Group writes on behalf of the Lakeshore County Employees' Retirement Fund, which has $1.24 billion in Quillfield's Global Equity strategy: “Ahead of the Lakeshore board on November 4: why did Global Equity lag the benchmark by 142bp in Q3, and is Marcus still holding Tessaro?” Here is what happens next, screen by screen, in the working solution.
- 01Friday, 09:20 ET
The overnight work, and what needs her
Anika Sorensen · Performance analyst, equitiesAnika signed the quarter's official returns on October 9: 141 of 148 strategies are final. Her Today screen opens with an ask box and what the agents did overnight — 11 new questions logged, 9 drafted, every draft bound to the official Q3 attribution. Hartwell's question is first in Needs you: Marcus Hale reviewed the reasons at 08:12, 7 of 7 checks passed, due Monday at 16:42.
“Answers use only official, signed-off returns and documents you are entitled to see · every figure is cited.”
- 02Overnight · 2 min 41 s
The agents did the reading, and every step is on the trail
Intake agent, Attribution reader, Context reader, NarratorThe Intake agent logged the email as PQ-26Q3-0418 with its CRM case and a tier-A clock of two business days. The Attribution reader read the official attribution ATT-GEQ-26Q3-v2, period Final. The Context reader read 14 Global Equity PM notes and found the reasons: Marcus Hale's July 22 note, his September 9 note, two Tessaro trades in the blotter and Tessaro's August 12 announcement, in German. The Narrator drafted six sentences, 142 words, for a consultant.
The Context reader quotes the PM. It never turns his notes into a new reason.
- 03One look
Each sentence lights the attribution cells it relies on
Anika Sorensen · Performance analyst, equitiesOn the left, the answer: Global Equity returned 1.84% before fees (1.65% after) against 3.26% for the Norvale Global All Cap Index, so it lagged by 142bp before fees and 161bp after. On the right, the official Brinson-Fachler grid by sector. When Anika points at “Most of the gap was stock selection in Health Care, which cost 96bp”, row 14 lights up — portfolio return −6.39%, benchmark 2.18%, selection −96bp — and the rest dims.
“Hover a sentence to see the cells it relies on.”
- 04One click on a citation
The reason, in the issuer's own words
Context readerCitation 3 opens Tessaro Health's ad hoc announcement of August 12 in German, with the English beside it, sentence by sentence: organic sales growth now expected at 2–4%, previously 7–9%, after an FDA warning letter on the Lörrach plant. The share price line shows CHF 88.40 on June 30 and CHF 60.82 on September 30, −31.2%. The same panel lists every source behind the answer: official returns, the attribution report, both PM notes, the trade blotter and the FX report.
- 05Before anyone signs
Seven checks, and a disclosure test that knows the recipient
Consistency agent · Disclosure agentThe Consistency agent recomputed every figure: 14 checked, 0 differences. The effects add to the total — allocation −39, selection −94, interaction −1, currency −8, −142bp. It added the after-fee figures because the draft showed before-fee figures, and matched the Q3 factsheet, two earlier answers and the benchmark in Lakeshore's investment management agreement. The Disclosure agent found the September 30 Tessaro weight is public only from October 30, but Hartwell has a holdings confidentiality agreement on file, signed March 3, 2025, with a 15-day lag.
“Gross paired with net · Net-of-fee figures added (1.65%, −161bp) · equal prominence.”
- 06When no note explains a driver
The agents ask the PM instead of guessing
Marcus Hale · Portfolio manager, Global EquityMarcus reviewed Hartwell's answer at 08:12 and changed one phrase to his own words: “a one-off” became “contained to one plant”. On another of his strategies, Global Equity Income lost 31bp in September from Consumer Staples selection, mostly Lianhe Foods. No note, minute or trade explained holding it through the warning, so the Context reader's confidence was 0.71, below the 0.85 floor. It asked Marcus instead. Once he replies, his words are quoted in the answer and cited to his reply.
“I found no note, minute or trade that explains holding it through the warning. In one or two sentences, what was your reasoning?”
- 07Any question, in plain words
She asks the agents — and one refuses
Anika Sorensen · Performance analyst, equitiesAnika asks why Global High Yield lagged in Q3. The Consistency agent will not answer yet: the period is preliminary while a price challenge on Varenne Telecom 7.25% 2029 is open with the fund administrator, and it is expected to be final on October 21. She asks which strategies lagged by more than 100bp. The Attribution reader lists four final strategies with their largest effect, each from the official Q3 attribution, and offers to prepare answers for all four.
“I will not answer that yet. Any figure I gave you now could change.”
- 08Signed
She approves with a reason code and her signature
Anika Sorensen · Performance analyst, equitiesAnika chooses A1 · Numbers agree with the official returns, and signs as Performance Analyst, Equities. The signature is recorded with the time and the answer version. Until she signs, the client team cannot send: the Send button turns on only after an analyst signs.
“I have checked the answer against the official returns and sign as Anika Sorensen, Performance Analyst, Equities.”
- 09Sent the same morning
Only the client team sends, and the CRM is written as it happens
Owen Marsh · Consultant relations managerOwen opens the approved answer, reads the email to James Whitcombe — copied to himself and to Elena Vasquez, subject “Global Equity · Q3 2026 attribution (Lakeshore board, Nov 4)” — and sends it. The Delivery agent logs it to CRM case CRM-CS-2610-0412 and writes the evidence pack. Hartwell has a cited answer on Friday morning; the clock allowed until Monday afternoon.
The Delivery agent sends nothing on its own. A person on the client team presses Send.
- 10When returns are restated
Every answer a restatement made wrong, found and corrected
Attribution reader · Lucia Moretti, Head of Performance MeasurementInternational Small Cap's Q2 2026 was restated on October 2, after the spin-off of Brevik Marine from Halvard Group was booked late: the excess moved from −118bp to −137bp. The Attribution reader found the three answers already sent to Stanmore Partners, Larkspur Consulting and Grafton Union Pension Trust that quoted the old figure, and drafted corrections. Lucia Moretti approves them before anything goes out.