A free risk-weighted assets calculator in Excel, from the exposures up
Credit, market, operational and CVA risk on the standardised and internal-model ladders, the mortgage book split at the secured threshold, capital ratios against requirements and buffers, and the output floor schedule: six sheets, no macros.
The file rebuilds the risk-weighted assets of Northbank, a fictional €80.2 billion bank. On the standardised approach they come to €44.8 billion; on internal models, €29.9 billion, or 66.7% of standardised. With €4.06 billion of common equity that gives a CET1 ratio of 13.57%. In 2026 the output floor sits at 55% and does not bind; it starts to bind in 2029, at 70%, adding €1.47 billion of RWA and taking the CET1 ratio to 12.94%. Underneath, the mortgage book weighs 27.75% band by band but 25.26% on its average loan: a 248.5 basis point understatement.
Get the template
One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other 129 free models.
RWA_Calculator.xlsx (30 KB)
You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.
The book behind this model
This file is one worked case from Financial Regulation. The book explains every assumption, every sheet and the decision the numbers support, chapter by chapter.
The Financial Model Library: all 130 models from this site in one download, organised by theme, plus two modelling books in DRM-free PDF (Financial Modeling from First Principles and Real Estate Financial Modeling).
This free file stays free. Secure checkout by Stripe.
Not on Amazon: 19 paperbacks by Julian R. Sterling on markets, funds and compliance, printed on demand and shipped worldwide. Browse the bookshop →
What is in the file
Six sheets. Blue on pale yellow is an input; everything else is a formula over the inputs.
Read me
What the workbook does and the three experiments to run first.
Inputs
The bank at 31 December 2026: exposures, weights, the mortgage book by loan-to-value band, capital, requirements, buffers and the transitional schedules for the output floor and equity weights.
The loan split
Every mortgage split at the 55% threshold into a secured and an unsecured part, band by band, against the shortcut of weighting the average loan.
The bank
Credit risk on and off balance sheet on both ladders, market, operational and CVA risk, the floor, capital read by name, the three ratios, Pillar 2, buffers and the distribution trigger.
The output floor
The floor rate year by year from 2025 to 2030, the RWA at the floor, whether it binds and the CET1 ratio that year.
Checks
Every figure the book prints against the live formula: 39 lines, all pass.
What the worked case returns
Measure
Value
Total assets
€80.24bn
RWA, standardised
€44.83bn
RWA, internal models
€29.91bn
Internal as a share of standardised
66.7%
CET1 ratio
13.57%
Tier 1 and total capital ratios
15.31%, 18.36%
Mortgage book weight, band by band
27.75%
Weight on the average loan
25.26%
First year the output floor binds
2029 (70%)
Additional RWA in 2029 and 2030
€1.47bn, €2.59bn
The loan split is convex in loan-to-value, so a portfolio is not its average loan. Weighting the average gives a lower figure than weighting each band, and on a €21 billion book the shortcut understates RWA by about €520 million. The sign is guaranteed by the convexity; the file tests it.
How to use it on your own bank
Replace the exposures and weights on Inputs with your own balance sheet.
Enter your mortgage book by loan-to-value band to see the split at work.
Read The bank for the ratios against the requirement and the distribution trigger.
Move the model year on Inputs to see the output floor and the equity weights phase in.
Keep Checks as the pattern for your own reconciliations.
Questions people ask about it
Is this RWA calculator really free?
Yes. It is a companion file to a book. The file costs nothing. You enter an email address, the download opens at once, and you can leave the reader list in one click.
Does it use macros or circular references?
No macros and no circular reference: exposure times weight, summed by ladder.
Does it compute internal-model risk weights?
No. Internal-model weights are inputs per exposure class, as a bank would read them from its own models; the file shows what they do to RWA, the floor and the ratios. Standardised weights, including the mortgage split, are computed.
Can I use it for a real bank?
You can reuse the structure. Northbank and every figure in it are fictional, and nothing here is regulatory advice.
The rest of the files
This template is one of the four companion workbooks for Financial Regulation: the others build the capital stack, the two liquidity ratios, and resolution and concentration. Free, like this one.
If this book helped, or didn’t, a few lines on Amazon are worth more than they look: they are what the next reader goes on. Write a review. The template stays free either way.