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.
Capital_Limits: Eligible Tier 1 capital, OCC Part 32 unimpaired capital, all five regulatory thresholds (0.25% / 5% / 10% / 15% / 25%), ALCO early warnings, and live Master Compliance Dashboard.
Meridian_CRM_Group: Control + 5% economic interdependence aggregation, CCFs (40% revolver, 50% standby L/C, 10% UCC floor), SA-CCR, and maturity-mismatched CDS haircut with 3-month cliff check.
GSIB_TB_LookThrough: EuroGlobal 15% inter-G-SIB cap, SFT haircuts & collateral substitution, QCCP novation, Vanguard trading book seniority & options JTD, Fund B / CLO 1 / CLO 2 look-through, and Unknown Client remediation.
Regimes_Comparison: Four-regime side-by-side comparison (BCBS LEX30, US Reg YY SCCL, US OCC Part 32, EU CRR2 Art. 402) plus Sovereign, QCCP, and LEX30.33 SOE exemptions.
Controls: 10 live accounting and substitution conservation checks verified with zero errors across input mutations.