A free Basel III Leverage Ratio & SLR Calculator in Excel
Full LEV30 Total Exposure Measure, Modified SA-CCR derivatives, SFT netting and E* add-on, finalized OBS CCFs, cross-jurisdictional compliance matrix (Basel III, US April 2026 eSLR, EU aLR, UK PRA), stress L-MDA quartiles, and FTP leverage pricing.
Pre-loaded with Meridian Global Bancorp ($85,000.00M Tier 1 capital, $1,975,000.00M TEM, 4.30% Basel III Leverage Ratio). Edit any blue input cell to test how repo compression, derivative netting, G-SIB surcharge buckets, or central bank reserve exemptions move your leverage headroom across Basel III, US eSLR, EU CRR3, and UK PRA.
Get the Excel calculator
One 6-tab Excel workbook, no macros, nothing locked. Enter your email address and the download opens immediately, along with the other free practitioner models.
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 Basel III Leverage Ratio Handbook works through every LEV30 and LEV40 formula on Meridian Global Bancorp: Modified SA-CCR, written CDS offsets, SFT netting and E* pools, 10%-100% OBS CCFs, G-SIB L-MDA quartiles, US April 2026 eSLR, EU CRR2/CRR3, UK PRA, optimization, and FTP.
Dashboard_LR: Capital numerator, RWA vs. leverage binding-constraint test, 4-component TEM summary with LR1 accounting bridge, and 7-row cross-jurisdictional compliance matrix.
OnBS_OBS_CCFs: On-balance-sheet asset schedule, LEV30.7 capital deductions, LR1 accounting total, finalized Basel III OBS CCFs (10%/20%/40%/50%/100%), and legacy BCBS 270 comparison.
Derivatives_SA_CCR: 4 netting sets under Modified SA-CCR (alpha = 1.4, PFE multiplier = 1.00), written credit derivative offsets and LEV30.34 PFE deduction, plus risk-based SA-CCR surcharge contrast.
SFT_Netting_AddOn: Gross SFT assets, LEV30.37(1) cash netting, MNA vs. non-MNA E* counterparty credit risk pools, and agency SFT indemnity add-on.
Optimization_Stress_FTP: Repo/derivative/OBS compression program, AT1 issuance, severely adverse stress test with automatic L-MDA payout quartiles, FTP leverage charge, and window-dressing gap.
Controls: 8 dynamic accounting and regulatory identity checks with live PASS/FAIL counters.