Companion files
A Practitioner’s Guide to Mandates, Performance, and What the Client Actually Earned
These are the companion files of Asset Management by Julian R. Sterling.The book on Amazon →
The four Excel workbooks that go with the book, corrected where they were wrong. Every figure the book prints is reproduced in them by a live formula, and each ends with a Checks sheet: 160 controls, each now tested to half a unit of the last decimal the book prints, every sheet ALL OK. Around them: the same models with the inputs emptied, thirteen working documents to print, forty questions that mark themselves, and three cases the book names and never takes to a number.
Free to download. No sign-up, no email address, nothing to fill in.
Twelve workbooks, the printable documents and the read-me. Each group below can also be downloaded on its own. Last revised 24 September 2026.
Reading the paperback or the Kindle edition? The same book is also sold as a DRM-free PDF: searchable, printable, yours on any device. $19.99, instant download.Buy the PDF edition → Free sample
Finished the book? Two or more PDF editions bought together are 15% off. Browse the PDF editions →
The working models behind the books, built out for live deals: the Pro models →
Optional. When a workbook on this page is corrected or a new worked case goes up, readers on the list get one email, plus a short note when a new book comes out. The downloads do not need it.
Join the reader listRun by MailerLite, off this site. How your address is used.
These carry the book’s own figures, so that every number it prints can be traced to a live formula. Where the book is wrong, the check row says so and carries the corrected figure. Download these four94 KB
Chapters 1, 4, 5, 7 and 14
The four returns of the mandate computed from one set of inputs, with the benchmark beside them: time-weighted gross 5.0887, time-weighted net 4.8012, rolling three-year net 6.8290, money-weighted net 4.1272, benchmark 4.7455. The spread of 2.7017 points and the ratio to the net outperformance are live cells, not captions, so both move when you change an assumption. Revised: the spread is now taken over the four mandate returns only (the first version let the benchmark into the range), and the gross-to-money-weighted distance is 0.9614, not the 0.9615 of Chapter 16.
Underneath is the engine the other three workbooks share: the annual returns built from five segments rather than typed above them, and the account run year by year — flow, opening value, value before fees, average assets, fee, closing value, net return. Edit a segment weight and the terminal value of 549,908,879.55 moves, and so does every headline number in the book.
Download the workbook20 KBChapters 4, 5 and 14
The chain-linking one year at a time, with the cumulative factor visible at each step and the fifth root taken on the page, for the gross series, the net series and the benchmark. Beside it, the arithmetic mean of the five years and the gap between it and the annualised return, which is volatility drag rather than a rounding difference.
Then the scheme's own number: the cash-flow series solved for the rate that discounts it to zero, 4.1272 per cent, with the discounting column shown so the solution can be checked rather than trusted. The cash flows are inputs. Move the 120,000,000 out of Year 2 and the −180,000,000 out of Year 3 and watch the gross time-weighted return refuse to move (the net one moves by a fraction of a basis point, through the fee breakpoint) while every money-weighted figure does — including the 6,357,745.18 the timing cost. New: the timing cost split flow by flow, 14,469,294.80 for the late transfer less 8,111,549.62 for the early payment, netting exactly (the book prints 14,469,310.14 and 8,111,557.49 and leaves 7.47 unexplained); and the payment out was 28.5 per cent of the value it was paid from, not 26.8.
Download the workbook23 KBChapters 8, 9, 10 and 11
The Brinson decomposition written out segment by segment and year by year: allocation, selection and interaction, each from its own formula, each with its five-segment column showing where the number came from. The row that matters is the reconciliation, which subtracts the active return from the sum of the three and must read zero in every year. It does. An attribution that does not reconcile is not an attribution.
The five-year averages follow — allocation 0.2582 against selection 0.1030, so 69.6 per cent of the skill was in the asset mix — with the arithmetic sum of 0.3712 set beside the geometric outperformance of 0.3432 and the 0.0280 of compounding between them shown rather than smoothed. The second sheet builds tracking error, both information ratios and both Sharpe ratios, and reports that the manager beat the index on return and lost to it on Sharpe by 0.0099. Revised: the net information ratio is the mean of the five net active returns over the tracking error, 0.1262; the first version subtracted the compound fee drag from the arithmetic gross mean and printed 0.1268, as the book does. A new sheet prices Chapter 3’s benchmark decisions: rebalancing worth 0.5010 in Year 2, and a fully invested composite that is a higher bar in three years of five, not four.
Download the workbook27 KBChapters 12, 13 and 15
The fee schedule taken apart: what is charged at each rate, the fee, and the effective rate in basis points falling from 28.1658 as the mandate grows past the breakpoint and rising again when 180,000,000 leaves. Then the number for the front page of a fee negotiation — fees took 83.7893 per cent of the gross outperformance.
The passive counterfactual runs the identical cash flows at the benchmark return and a fee rate you set, ending at 547,495,942.65 against the active 549,908,879.55: active management finished 2,412,936.89 ahead having charged 6,263,206.77 more. The fee at which the two finish level is now solved by running both accounts again: the index would need minus 3.08 basis points, because the mandate beat even a free index, and the mandate could have charged a flat 36.00 before merely tying it (the first version added the gap to the passive fee and showed 13.9). The last sheet is every three-year window on the record — 5.1900, 3.5956 and 6.8290 — a spread of 3.2334 points from the start date alone.
Download the workbook27 KBThe four workbooks with every input emptied. The checks sheets count what is still missing and test what holds for any inputs.
Chapters 1 to 15
The four workbooks with the same formulas and every blue cell emptied: the funding, the fee schedule, the five flows, the benchmark weights and returns, the portfolio weights and returns, and the passive fee. The steps stay: the Dietz weight, the trial rate, the points of weight moved, the fee concessions. Each sheet stays blank until its inputs are complete.
The book’s inputs are listed in a text file inside the archive. Type them back in and the book’s figures come back with them: 4.8012 net, 4.1272 money-weighted, 549,908,879.55 at the end of Year 5.
Download the blank set79 KBThirteen pages to print and use. A4, with margins wide enough for US Letter.
Chapters 1 to 18
The four numbers on one page, with the line every return must carry. Reading the mandate: five statements, two silences and the two paragraphs to add. The benchmark interrogated. Time-weighted and money-weighted return built by hand, with the seams to check. The fee year by year, with what is not in the net return. Attribution that reconciles. The risk page, with the years of data each ratio would need.
The benchmark as an account. The flow effect, addressed to its owner, with a line for the next known payment. Every window with its benchmark. Opening a composite. And the decision paper to retain or replace a manager, with the transition cost and the sentence for the minute.
Download the PDF31 KBA workbook that marks itself. Answer in the yellow cells; the marking fills in as you go.
All parts of the book
Seven on the mandate and the question, seven on measuring the return, seven on where it came from, seven on what the client pays and earns, six on practice, and six on the three cases below. Numbers are marked to a tolerance, multiple choice to the letter, and the score sheet counts your errors part by part.
Download the question book17 KBNew material, not a restatement. Three situations the chapters name and never take to a number. Each case is one workbook: the note is the first sheet, the model is the rest, and a checks sheet closes it. Type your own figures in and every finding recomputes.
Chapter 14 · Case one
Chapter 14 names the choice between funding a payment from a cash sleeve and from the whole portfolio and never prices it. Setting the 180,000,000 premium aside when the transfer arrived (the premium known in advance, the sleeve at the cash rate: ADDED) would have ended Year 5 18,347,427 higher, and cut the 0.6739 gap between what the manager returned and what the money earned to 0.0456.
That was Year 2, not skill. On the book’s own five-year means, setting the premium aside costs 3,779,826 in expectation and removes a swing of 12,838,976: the trustees are pricing a liability, not timing a market.
Chapters 6 and 12 · Case two
The same schedule on the same mandate for ten more years, paying out 7 per cent a year (ADDED). The effective rate rises every year, from 28.20 to 29.81 basis points, and the escalator costs 455,383 against the 27.9668 the schedule charged over the first five years. The rate reaches 30 basis points by Year 10 at a payout of 7.22 per cent: a threshold, not a forecast.
The concession that keeps its value is the breakpoint: 150,000,000 lower saves 1,950,000 over the ten years, against 1,250,000 for five points off the headline.
Chapter 18 · Case three
Chapter 18 says a termination is the largest flow a scheme chooses and prices only its explicit cost. At the book’s 25 basis points plus one month out of the market (ADDED), the expected cost is 2,360,163, 4.89 years of the incumbent’s margin; one standard deviation of that month is 11,594,658, 24 years of it.
A replacement expected to beat its benchmark by 0.15 a year (ADDED) repays the cost in 2.9 years, and would need 77 years of data to show that edge at a t-statistic of 2.
Download the three cases39 KB| Blue text | a hardcoded input — you may edit these |
| Yellow fill | an input cell; everything else on the sheet is a formula |
| Black text | a formula — do not overtype these |
| Checks sheet | the printed figure beside the computed one, to half a unit of the last decimal the book prints, with a PASS or a FAIL; the sheet ends ALL OK |
| ADDED | a figure the book does not give, used in the cases and marked wherever it appears |
A workbook that agrees with a book proves nothing on its own — the author wrote both. What the Checks sheets do is different: they force the model to reproduce a number that was printed before the model existed, from a formula rather than from the number itself.
On this book the discipline earned its place twice. The portfolio weight matrix was laid out transposed on the first build, which reproduced the benchmark perfectly and every portfolio return wrongly — a defect invisible to anyone reading the sheet, and caught in one line by the Checks tab. And the effective fee rate printed in Chapters 6 and 12 was checked against the wrong quantity in the first draft of the controls; the workbook was right and the control was wrong, which is its own useful reminder that a failing check is a question, not a verdict.
The third lesson came later, and it was about the checks themselves. Every one of the hundred compared the printed figure with a tolerance of 0.005, and on a return held as a fraction that is half a percentage point: the net outperformance of 0.0556 would have passed at zero. A check is only as good as its tolerance. They now test to half a unit of the last printed decimal, and all hundred still pass. The figures the files correct were found the other way, by recomputing every chapter line by line.
Where a shortcut and the full computation disagree, both are shown. Subtracting the four printed returns gives a spread of 2.7018 where the unrounded series gives 2.7017; the arithmetic average of the annual attribution is 0.3712 where the geometric outperformance is 0.3432. Neither gap is an error, and neither is hidden.
Asset Management develops the complete framework behind these models, with the assumptions, trade-offs and worked examples tied together.
View the book on Amazon Read the related analysisAlso as an ebook on Apple Books · Google Play · DRM-free PDF edition ($19.99).
The workbooks open in Microsoft Excel, LibreOffice Calc, Google Sheets and Numbers; the PDF prints on A4 or US Letter. They use no macros and no add-ins, so nothing needs to be enabled or trusted. If your spreadsheet asks to update links on opening, decline — there are none.
| 24 Sep 2026 | The four workbooks corrected: the checks now test to half a unit of the last printed decimal (160, up from 100; they used to allow half a percentage point on every return). Net information ratio 0.1262, not 0.1268. The fee at which active and passive finish level is minus 3.08 basis points, not 13.9. Four figures of the book corrected in the files: the payout was 28.5 per cent of the value it came from, not 26.8; the two flow terms of Chapter 14 are 14,469,294.80 and 8,111,549.62; the gross-to-money-weighted distance is 0.9614; a fully invested composite is a higher bar in three years, not four. Added: a blank set, thirteen working documents, forty questions that mark themselves, and three cases. |
More in corporate finance, with free companion files. The full list of titles is on the author page.
Also available as a standalone free template: brinson attribution model.
These files accompany Asset Management. The book is on Amazon.
If this book helped — or didn’t — a few lines on Amazon are worth more than they look: they are what the next reader goes on. Write a review. The workbook stays free either way.