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?
Worked example: How do you calculate a deposit beta, and on which deposits?
Worked example: How do you calculate a bank's uninsured deposit coverage ratio?
Worked example: How do you calculate a bank's EVE sensitivity to a rate shock?
Worked example: How do you calculate a bank's net interest margin (NIM)?
Worked example: How do you calculate a bank's tangible common equity (TCE) ratio?
Worked example: How does funds transfer pricing work at a bank?
Worked example: How do you calculate a bank's all-in cost of deposits?
Worked example: What price to tangible book should a bank trade at?
Worked example: How do you calculate a core deposit intangible (CDI)?
Worked example: How do you calculate the earn-back period on a bank's bond loss trade?
Worked example: How do you calculate a bank's Texas ratio?
Worked example: How do you calculate a bank's efficiency ratio?
Worked example: How do you calculate a bank's loan-to-deposit ratio?
Worked example: How do you calculate ROA and ROE for a bank?
Worked example: How do you calculate a bank's repricing gap?
Worked example: How do you calculate a bank's internal capital generation rate?
Worked example: How do you calculate a bank's liquidity survival horizon?
Worked example: How do you calculate a bank's pre-provision net revenue (PPNR)?
Worked example: How do you calculate a bank's net charge-off ratio?
Worked example: How do you calculate a CECL allowance with the WARM method?
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?
Worked example: How do you calculate a mortgage risk weight under loan splitting?
Worked example: How do you calculate the LCR when part of the buffer is pledged?
Worked example: How do you calculate the net stable funding ratio (NSFR)?
Worked example: How do you calculate the output floor on risk-weighted assets?
Worked example: How do you calculate a bank's leverage ratio, and when does it bind?
Worked example: How do you calculate a bank's maximum distributable amount (MDA)?
Worked example: How do you calculate a bank's countercyclical capital buffer?
Worked example: How do you calculate a bank's CET1 ratio from its balance sheet?
Worked example: How do you calculate a bank's MREL requirement?
Worked example: How do you calculate operational risk capital under Basel III?
Worked example: How do you calculate a bank's large exposure limit?
Worked example: How do you calculate a bank's risk-weighted assets (RWA)?
Worked example: How much can a bank lend with its excess capital?
Worked example: How do you calculate SA-CCR exposure at default for derivatives?
Worked example: How does tier 2 capital amortise in its final five years?
Worked example: How much capital does an undrawn credit line use under Basel III?
Worked example: How does the 40% cap on Level 2 assets work in the LCR?
Worked example: How do you calculate LCR net cash outflows from run-off rates?
Worked example: How does an IRB expected loss shortfall reduce CET1?
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?
Worked example: How do you calculate the Solvency II spread risk charge on a bond?
Worked example: How does the symmetric adjustment change a Solvency II equity charge?
Worked example: How do you aggregate Solvency II market risk charges?
Worked example: How do you calculate return on Solvency II capital for a fund?
Worked example: How do you calculate the marginal SCR of an investment?
Worked example: How do you calculate the Solvency II currency risk charge on a fund?
Worked example: How is a leveraged real estate fund charged under Solvency II?
Worked example: How do you calculate the Solvency II interest rate risk charge?
Worked example: How is the Solvency II matching adjustment calculated?
Worked example: How much capital does Solvency II long-term equity status save?
Worked example: How is infrastructure equity charged under Solvency II?
Worked example: How do you calculate the Solvency II concentration risk charge?
Worked example: How do you calculate a Solvency II ratio? A worked example
Worked example: How is a CLO tranche charged under Solvency II?
Worked example: How much does the Solvency II volatility adjustment release?
Worked example: Solvency II type 1 vs type 2 equity: what does the difference cost?
Worked example: How do you calculate LAC DT under Solvency II?
Worked example: Can you calculate the Solvency II spread charge from average duration?
Worked example: How much private equity fits under a 150% Solvency II ratio?
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?
Worked example: How much markdown breaches the AIFMD II 175% leverage cap?
Worked example: When is a fund a loan-originating AIF under the 50% test?
Worked example: How do you calculate AIFMD leverage: gross vs commitment method?
Worked example: How is the AIFMD II 20% single-borrower limit calculated?
Worked example: How does the AIFMD II 5% loan retention rule work in numbers?
Worked example: How do you calculate AuM for the AIFMD 100 and 500 million thresholds?
Worked example: How is an anti-dilution levy calculated under AIFMD II?
Worked example: How do you calculate the Annex IV portfolio liquidity profile?
Worked example: How do you calculate an AIFM's own funds requirement?
Worked example: How do you calculate a fund's redemption coverage ratio?
Worked example: How does a side pocket work in an open-ended fund?
Worked example: How do you calibrate a redemption gate for an open-ended fund?
Worked example: How is a redemption in kind calculated?
Worked example: How long should a fund's redemption notice period be?
Worked example: How does dual pricing work in an open-ended fund?
Worked example: How do you set a redemption fee range for an open-ended fund?
Worked example: Swing pricing vs anti-dilution levy: who pays the cost?
Worked example: Does a subscription line count towards the AIFMD II leverage limit?
Worked example: How much return does AIFMD II cost 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
Worked example: How much will CBAM cost per tonne of steel from 2026 to 2034?
Worked example: Is it worth staying under the CBAM 50 tonne threshold?
Worked example: How do you calculate CBAM embedded emissions for a steel product?
Worked example: How do you calculate CBAM embedded emissions for cement?
Worked example: How do you calculate CBAM embedded emissions for aluminium?
Worked example: How is the CBAM certificate price calculated for 2026 imports?
Worked example: How do you calculate CBAM embedded emissions for ammonium nitrate?
Worked example: How do you calculate CBAM direct emissions with a mass balance?
Worked example: How do you calculate CBAM embedded emissions for hydrogen?
Worked example: How is the CBAM free allocation adjustment calculated?
Worked example: CBAM default values vs actual emissions: what do defaults cost?
Worked example: How do you calculate CBAM certificates for imported electricity?
Worked example: How do you calculate a CBAM surcharge per tonne?
Worked example: How is carbon price paid abroad deducted from CBAM certificates?
Worked example: What is the CBAM penalty for not surrendering certificates?
Worked example: Should CBAM costs go into inventory or straight to expense?
Worked example: How much does CBAM add to the unit cost of an EU-made product?
Worked example: How do you hedge CBAM certificate costs with EUA futures?
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
Worked example: How many KYC periodic reviews a year does the AMLR imply?
Worked example: How do you calculate indirect beneficial ownership through a chain?
Worked example: How do you calculate a customer AML risk score?
Worked example: How do you calculate the false positive rate of AML alerts?
Worked example: How is the maximum AML fine calculated under AMLD6?
Worked example: How do you calculate residual risk in an AML risk assessment?
Worked example: When do linked transactions trigger the €10,000 CDD threshold?
Worked example: How do you set an AML transaction monitoring threshold?
Worked example: How does Jaro-Winkler scoring work in sanctions name screening?
Worked example: How much does KYC cost per customer? An onboarding cost model
Worked example: How do you apply the 50 per cent ownership rule in sanctions?
Worked example: How do you detect cash structuring below a €10,000 threshold?
Worked example: How do you detect a pass-through account in AML monitoring?
Worked example: How long will it take to clear an AML alert backlog?
Worked example: How do you apply Benford's law to AML transaction data?
Worked example: How do you calculate a peer group z-score in AML monitoring?
Worked example: How do you measure the detection rate of AML transaction monitoring?
Worked example: How do you test whether a client's source of wealth is plausible?
Worked example: How do you detect over-invoicing in trade-based money laundering?
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?
Worked example: How do you test whether deal allocations favour one fund?
Worked example: What does a compliance test sample with two exceptions prove?
Worked example: How do you calculate net performance under the SEC Marketing Rule?
Worked example: How do you calculate a fee overcharge refund with interest?
Worked example: How many basis points of fee is a misallocated fund expense?
Worked example: How do you calculate regulatory AUM (RAUM) for Form ADV?
Worked example: What does a pay-to-play violation cost an adviser in fees?
Worked example: How do you calculate net worth for accredited investor status?
Worked example: How are Section 16(b) short-swing profits calculated?
Worked example: How do you calculate the ERISA 25 per cent plan asset test?
Worked example: How do you calculate beneficial ownership for a 13D or 13G filing?
Worked example: How do you calculate investments for qualified purchaser status?
Worked example: How do you count investors for the 3(c)(1) 100-investor limit?
Worked example: How is the Form 13F $100 million threshold calculated?
Worked example: How do you calculate the FINRA 5130 10% de minimis for a fund?
Worked example: How do you calculate a trade error reimbursement for a fund?
Worked example: How is loss avoided calculated in an insider trading case?
Worked example: How do you allocate a partially filled trade pro rata across funds?
Worked example: How is the profit on a Rule 105 short sale violation calculated?
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