8 practitioner guides by Julian R. Sterling, best read first at the top. Each one is built on a single worked case, and every figure it prints is a live formula in a free workbook.
The quickest way into regulation, compliance and banking is Bank Management, the most read title in this list. The others go deeper into one job or one asset each. Every book below has a free companion page with the workbooks, so the arithmetic can be checked before the book is bought.
What a Bank Is Worth, and Which Number the Depositor Reads
The four workbooks behind Bank Management: the four capital readings of one balance sheet, the deposit beta measured two ways, the economic value of equity across the whole surface of its assumptions, and the liquidity that lasts 3.9 days.
Worked example: What would a buyer actually pay for a bank reporting 11.40 per cent capital?
A Practitioner's Guide to Finding the Constraint That Actually Binds
The four workbooks behind Financial Regulation: the loan split that makes a portfolio weigh more than its average loan, the output floor with its binding year computed, the liquidity buffer before and after encumbrance, and the subordination rule written both permitted ways.
Worked example: Does an additional tier 1 shortfall reduce headroom to the distribution trigger?
A Practitioner's Guide to Solvency II Charges, the Look-Through Rule, and Why the Same Fund Costs Two Insurers Different Amounts
The six corrected workbooks behind every figure in Insurance Capital for Asset Managers, with a blank set, thirteen working documents, forty questions and three cases. Free, no sign-up.
Worked example: What does it cost when an insurer cannot look through a fund?
Loan Origination, Liquidity Management Tools, Delegation and Reporting under Directive (EU) 2024/927
Chapter 11 calls the reverse stress level the most useful number a liquidity test produces, and never computes it. Here it is — with €124m unaccounted for.
Worked example: How do you compute the reverse stress level for an open-ended credit fund?
The book says budgeting only the 2026 lump sum understates 2027 “substantially”. Substantially is a factor of exactly two. Plus a term counted twice.
Worked example: What a CBAM certificate buffer costs to hold
82,062 analyst-days, the month beyond which no headcount recovers a one-year window, and an asymmetry sharper than the chapter says — €21.5 million.
Worked example: The month an AML remediation trigger has to be armed by
A Practical Career and Implementation Guide to Building, Running, and Defending a Compliance Program
Turning “test periodically” into a number you can defend: the grey zone as a fee of 2.06 per cent instead of 2.00, and a broken deal allocated four ways.
Worked example: How many expense allocations do you have to test?
The money and the instruments, the 35 per cent content test worked, and what a proposal actually costs to write. Every figure in a dated input cell.
Worked example: At what odds of procurement does an EDF development grant pay back?
Coming soon on Amazon · Free companion files
Start with Bank Management by Julian R. Sterling. It is the most read title in this list, and like the others it is built on one fully specified worked case whose every printed figure is reproduced in a free Excel workbook.
Yes. Every title in this guide has a free companion page on julianrsterling.com with the workbooks, blank templates and checklists. They need no account and no email address.
Analysts, associates and managers who need to compute the numbers rather than describe them: each book follows one case from the first input to the decision, at practitioner level.
Real estate investing, finance and fund management · Private equity and private markets · Credit, private credit and distressed debt · Infrastructure, data centres and energy · Corporate finance, valuation and markets · Business operations: cost, contracts, pricing and supply chain · Personal finance and investing for beginners