Companion files

Financial Regulation

A Practitioner’s Guide to Finding the Constraint That Actually Binds

These are the companion files of Financial Regulation 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, and each workbook ends with a Checks sheet setting the printed figure beside the computed one: 203 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 ZIP361 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 four148 KB

The same models, for your own bank

The four workbooks with the 233 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

There is one Inputs sheet in each file, and it carries the only entered values: the balance sheet, the funding, the risk weights, the loan-to-value bands, the national buffer rates, the requirements. Everything else is computed from them. Where the texts permit two readings, both are shown and neither is chosen — that is the subject of chapter 17.

The workbooks were checked by moving the inputs and confirming that every dependent figure moved with them. Shifting eight points of the mortgage book from the lowest loan-to-value band to the highest moves the portfolio weight, the standardised total, the floor trajectory and the funding factor together. Raising the internal weight on corporate lending moves the binding year of the output floor from 2029 to 2030 through the lookup.

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, 203 checks. Chapter 4’s shortcut does not always understate: above the 55 per cent threshold the weight is concave, and on the book’s upper bands the average loan overstates by 69.5 basis points. Chapter 10’s backstop cannot be reached by lowering internal weights while the floor stands: the lowest density is 29.36 per cent, above the switch at 25.10. Chapter 13’s switches all on give 94.76 per cent, not the most favourable reading, which is 96.53. The double count misstates the headroom by 1,486.5 million and produces a shortfall of 170.6 million, not one of 1,486.5. Added: a blank set, thirteen working documents, forty questions that mark themselves, and three cases.

Go beyond the companion files

Financial Regulation 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

These files accompany Financial Regulation. 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.

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.