Free Excel templates

A free Large Exposures & SCCL Calculator in Excel

25% Tier 1 cap, 15% inter-G-SIB limit, connected counterparties, SA-CCR & SFT haircuts, CRM substitution, trading book offsetting, CLO look-through, Unknown Client, and EU CRR2 comparison.

Pre-loaded with Cresthaven Global Bank ($20,000.00M Tier 1 capital, $5,000.00M general cap, $3,000.00M G-SIB cap). Edit any blue input cell to test capital shocks, CDS maturity mismatches, QCCP novation, or look-through thresholds while the dynamic Controls tab checks every substitution identity in real time.

Get the Excel calculator

One Excel workbook, no macros, nothing locked. Enter your email address and the download opens immediately, along with the other free practitioner models.

Large_Exposures_SCCL_Calculator.xlsx (23 KB)

You join the reader list: occasional notes when new models or handbooks release. Unsubscribe in one click. How your address is used.

The book behind this calculator

The Large Exposures Handbook walks through the entire Cresthaven Global Bank case across 15 chapters: BCBS LEX10 to LEX40, US Reg YY SCCL, OCC Part 32, EU CRR2, UK PRA, FR 2590, and COREP C 26 to C 31.

DRM-free PDF, $19.99 → · Paperback, $32.99, shipped worldwide

What is inside the 5 tabs

Related reading