Companion files

Bank Management

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.

Everything on this page, in one archive

Download the ZIP278 KB

Twelve workbooks, the printable documents and the read-me. Each group below can also be downloaded on its own. Last revised 24 September 2026.

Get an email if these files are corrected

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 list

Run by MailerLite, off this site. How your address is used.

The four workbooks

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

The same models, for your own bank

The 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.

The documents the chapters describe

Thirteen pages to print and use. A4, with margins wide enough for US Letter.

Forty questions, marked by the file

A workbook that marks itself. Answer in the yellow cells; the marking fills in as you go.

Three cases the book does not work

New 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.

Conventions used throughout

Blue texta hardcoded input — you may edit these
Yellow fillan input cell; everything else on the sheet is a formula
Black texta formula — do not overtype these
Checks sheetthe 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
ADDEDa figure the book does not give, used in the cases and marked wherever it appears

How they are built

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.

Opening the files

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.

What changed, and when

24 Sep 2026The 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.

Articles on this book

Also by Julian R. Sterling

The other books with companion files. The full list of titles is on the author page.

Go beyond the companion files

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 analysis

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.