Companion files
What a Bank Is Worth, and Which Number the Depositor Reads
These are the companion files of Bank 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 rather than a typed constant, the four readings of capital are bridged to the dollar, and each workbook ends with a Checks sheet setting the printed figure beside the computed one: 91 controls in all, every one green. Around them: the same four 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. Nothing is locked, protected or watermarked.
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, and each closes on its checks sheet. Download these four104 KB
Chapters 1, 2, 14 and 24
The same bank, on the same day, reads 11.40 per cent on published common equity tier 1, 8.66 with the available-for-sale mark recognised, 2.09 on tangible common equity with both marks taken, and 3.88 on economic value with the deposit franchise included. All four are defensible and all four are used. The distance between the highest and the lowest is 9.31 percentage points.
Enter your own balance sheet and the sheet returns all four at once, on risk-weighted assets and on tangible assets so that only the numerators differ, with the bridge from the first reading to the fourth closing to the dollar. It is the exhibit chapter twenty-seven says belongs at the front of every committee pack, and it takes about twenty minutes to fill in. Revised: the bridge this paragraph describes was missing from the first file. It now closes at the foot of the Four readings sheet, from 639,600 to 278,809, with a difference of nought.
Download the workbook23 KBChapters 3 to 8
Net interest income before and after the shock, decomposed into the asset side and the liability side, with the beta as an input rather than a result. The same behaviour measured on all non-maturity deposits is 35 per cent; measured on the interest-bearing book alone it is 54. Both describe this bank. Neither is stated with its denominator in most disclosures.
The sheet also solves for the beta at which the year's pre-tax profit reaches zero — 61.72 per cent, against the 35 assumed — and prices what contract floors and reset dates take away from a floating-rate book the model assumes reprices in full. On this bank the floating book's effective first-year beta is 78 per cent, not 100, and the difference is 55 per cent of the year's net income.
Revised: the floors do not cost the year, the reset lag does. The floors lower the move in the margin by raising year 0, where a 3.95 per cent index sits under a 4.50 per cent floor; corrected pre-tax income is 25,476, not 21,757, and the loss after tax is 30.77 per cent of net income, not 55. And the margin charges the 35 per cent to the savings book alone, which is 22.68 per cent across all non-maturity deposits; read across all of them, as chapter six reads it, pre-tax income is 10,620 and the break-even of 40.00 per cent is five points away.
Download the workbook28 KBChapters 7, 9, 11 and 16
The weighted repricing gap, the price change of each portfolio under duration and convexity, and the economic value of equity including the deposit franchise — which is where the whole argument lives, because the franchise rests on an assumed deposit life that nobody can observe.
So the central sheet prints the surface rather than the point: economic equity as a function of deposit life and deposit beta, running from 608,716 at the generous corner to minus 44,722 at the severe one, where the bank is economically insolvent. A second grid sets earnings sensitivity beside value sensitivity on the same shocks, where they differ by a factor of eleven — and where quadrupling the hundred basis point figure overstates the four hundred point answer by 25 per cent. Revised: the factor of eleven sets a value change after tax against an earnings change before tax; on one basis it is 14.77. And it is the franchise, not the equity, that differs by a factor of 6.86 between the corners: one equity corner is negative, so the two have no ratio.
Download the workbook29 KBChapters 15, 17 and 25
Mobilizable liquidity by source and haircut, against uninsured deposits. Total coverage is 97.32 per cent, which is the figure that reaches the board pack. Coverage that does not breach the well-capitalized threshold is 90.91, and the difference between those two numbers is a policy choice nobody has been asked to make.
Days to exhaustion at any outflow rate you enter: 48.7 at two per cent of the uninsured base a day, 3.9 at twenty-five. The share of the held-to-maturity book sellable before the published ratio breaks: 83.60 per cent. And the threshold the book turns on — the deposit outflow at which the franchise premium disappears and the fourth reading collapses onto the third: 28.02 per cent. Re-verified: every figure stands. Two proofs are added: sell exactly 83.60 per cent of the book and the published ratio lands on 6.50 per cent; lose exactly 28.02 per cent of the franchise deposits and the fourth reading lands on the third.
Download the workbook26 KBThe four workbooks with the 61 inputs of their shared Inputs sheet emptied. The checks sheets count what is still missing and test what holds for any inputs.
All chapters · the committee pack
The four readings, the margin and the beta, the gap and the surface, and the liquidity, with the same formulas and every input emptied: the balance sheet, the rates, the durations and convexities, the deposit behaviour, the year’s profit, the liquidity sources, the transfer curve and the floating book. The axes of the surface, the two horizons and the days table stay, because they are the axes of their tables, not data.
The book’s 61 inputs are listed in a text file inside the archive. Type them back in and the book’s figures come back with them: 11.40 per cent published, 278,809 of economic equity, 97.32 per cent coverage.
Download the blank set96 KBThirteen pages to print and use. A4, with margins wide enough for US Letter.
Chapters 1 to 25 · the committee pack
The committee exhibit: four readings of one balance sheet, with the bridge. The marks, portfolio by portfolio, and who owns each one. The margin before and after the shock, line by line. The transfer-pricing statement. The loaded cost of a deposit against wholesale money. The deposit beta stated with its denominator. The repricing gap weighted by behaviour. The floating book as written, from the loan tape. The surface, with a blank grid for your own. Earnings beside value on one tax basis. What a buyer would pay. The liquidity sources and the two coverage figures. The run: days, thresholds, and the decisions agreed before the first day. Sagebrook’s figures beside a blank column on every page.
Download the PDF32 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 four readings, six on margin and transfer pricing, seven on the beta and the floors, seven on gap, value and the buyer, seven on liquidity and the run, 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: that is your revision list.
Nothing is hidden. The marking sheet holds every answer, every tolerance, and the reason for each answer.
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.
Chapters 17 and 25 · Case one
The Days sheet says a real run accelerates and never runs one. Run: starting at 2 per cent of the uninsured base a day and growing by half each day (ADDED), the liquidity lasts 7.96 days, not 48.66. On one clock the three thresholds fall in the same order at every speed: the franchise premium first (day 6.85, or day 30.46 at a constant 2 per cent), then the published ratio, then the cash. The bank a buyer would pay for is gone before the money is.
Chapter 17 · Case two
The 6.41 points between 97.32 and 90.91 per cent coverage are 191,098: 6.15 hours of the 25 per cent run. Closing them takes 53,925 of new equity, 5.62 years of the year’s retained profit, or risk-weighted assets 14.79 per cent lower. A facility lending at par (ADDED, as from 12 March 2023) takes coverage to 113.24 per cent without selling anything. It is a capital decision, taken years before the run.
Chapters 3, 6, 9 and 14 · Case three
The workbooks read the 35 per cent on the savings book in the margin and on all non-maturity deposits in the franchise. Read consistently one way, Sagebrook earns 36,800 before tax and is worth 361,276; the other way, 10,620 and 259,174, with net income below the dividend. The break-even, 40.00 per cent on all non-maturity deposits, is 17.32 points away on the first reading and 5.00 on the second.
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, with a PASS or a FAIL; in the blank set and the cases, each control states its own verdict and the file ends ALL OK |
| ADDED | a figure the book does not give, used in the cases and marked wherever it appears |
Each file has one Inputs sheet, and it carries the only entered values: the balance
sheet, the yields and contractual costs, the durations and convexities, the behavioural
assumptions, the haircuts and the transfer curve. Everything else is computed from them. Where
two readings are defensible, both are shown and neither is chosen — which is the argument
of the book rather than a hedge.
Two inputs deserve more suspicion than the rest, and the book says so at length: the assumed life of non-maturity deposits and the deposit beta. They are judgments, not measurements. The Surface sheet exists so that you can see what your own answer does when they move, before you quote it.
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, 91 checks. The bridge from the first reading to the fourth, described and missing, is added. Chapter 8’s corrected pre-tax income is 25,476, not 21,757: the floors raise year 0, and only the reset lag costs the year, 30.77 per cent of net income, not 55. The margin charges the 35 per cent beta to the savings book alone, 22.68 per cent across all non-maturity deposits (case three). Value over earnings at 100 basis points is 14.77 on one tax basis, not eleven. The read-me’s sixty-eight inputs are sixty-one. Added: a blank set, thirteen working documents, forty questions that mark themselves, and three cases. |
Also available as a standalone free template: Bank stress test: PPNR, CET1 and MDA.
More in regulation and compliance, with free companion files. The full list of titles is on the author page.
Bank 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.
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.