Configuration
Facility Structure
Spread over reference rate (SOFR/EURIBOR etc.).
Bank's internal funding cost over reference rate.
Credit & Capital Inputs — from T198 / T201
From T198: annual PD × LGD × EAD.
CET1 ratio the bank allocates against this RWA. Minimum regulatory 4.5%.
Allocated origination, servicing, and overhead costs per annum.
Hurdle Rate
Minimum RAROC to approve the facility. Typically 10–15% for corporate lending.
Used to compute economic profit (EVA). Typically CAPM-derived.
About This Tool
RAROC Formula Chain
NII = (Margin − CoF) × Loan
Fees = Upfront/M + Annual Fee
────────────────────────
Rev = NII + Fees
− EL = PD × LGD × EAD
− OpEx= % × Loan
────────────────────────
RANI = Rev − EL − OpEx
EC = RWA × CET1%
RAROC = RANI / EC × 100
────────────────────────
EP = RANI − CoE × EC
Economic Profit (EP)
EP = RANI − (Cost of Equity × Economic Capital). Positive EP = the deal creates value above the cost of capital. Negative EP = the deal destroys shareholder value even if RAROC is positive.
Minimum Margin
The minimum all-in margin (bps) at which RAROC equals the hurdle rate. This is the floor below which the deal should not be approved without additional fee income, collateral, or volume compensation.
Workflow Integration
Feed outputs from T198 (Expected Loss), T201 (RWA), and T197 (rating/sector) into this tool for an end-to-end credit decision model. Run T202 first to stress-test RAROC under adverse scenarios.
RAROC Pricing Results
RAROC vs hurdle
Annual P&L Waterfall
Minimum Margin to Meet Hurdle Rate
bps all-in margin
Margin Sensitivity — RAROC at ±150bps
All-In Margin (bps) Net Spread (bps) NII (annual) RANI RAROC vs. Hurdle Economic Profit
Pricing Commentary