Free calculator · bank treasury, CFO, ALCO
Loss and reserve scenario: charge-offs, provision, and capital
Stress a bank's net charge-offs: provision needed to hold its allowance ratio and the after-tax hit to CET1 or leverage capital, with peers. No account or key needed. Every number is labelled filed, derived, or assumed.
Example
STIFEL BANK&TRUST: a 0.76% net charge-off rate on $15.22B of loans means $116.1M of charge-offs and a $116.1M provision to hold its allowance at 0.56% of loans. After tax that takes its CET1 ratio from 10.97% to 10.22% (-75 bp), and a 4.0% net charge-off rate would take it to the 7.0% floor. Inputs: Stress net charge-off rate (annual): source-derived; Change in allowance-to-loans ratio: 0; Loan growth over the year: 0; Tax rate on the provision: 21; Share of the provision absorbed by earnings: 0; Capital floor for the breakeven: source-derived.
Loss and reserve scenario: charge-offs, provision, and capital
Stress a bank's net charge-offs: provision needed to hold its allowance ratio and the after-tax hit to CET1 or leverage capital, with peers.
STIFEL BANK&TRUST: a 0.76% net charge-off rate on $15.22B of loans means $116.1M of charge-offs and a $116.1M provision to hold its allowance at 0.56% of loans. After tax that takes its CET1 ratio from 10.97% to 10.22% (-75 bp), and a 4.0% net charge-off rate would take it to the 7.0% floor.
- Loans and leases held for investment
- $15.22BFiled
- Allowance for credit losses on loans
- $84.6MFiled
- Allowance to loans
- 0.56%Derived
- Current annualized net charge-off rate · Schedule RI-B latest quarter annualized over Schedule RC-K average loans
- 0.17%Derived
- Capital measure used · CET1 capital over risk-weighted assets (Schedule RC-R)
- CET1 ratioDerived
- CET1 ratio, before
- 10.97%Filed
- Equity to assets, before
- 6.84%Filed
- Stress net charge-off rate (annual) · Reference only: 90th percentile among $10B–$50B banks
- 0.76%Assumed
- Change in allowance-to-loans ratio
- +0.0 bpAssumed
- Loan growth
- 0.00%Assumed
- Tax rate on the provision
- 21.00%Assumed
- Share of provision absorbed by earnings
- 0.00%Assumed
- Capital floor · Reference: 4.5% CET1 minimum plus 2.5% conservation buffer
- 7.00%Assumed
- Net charge-offs in the stress
- $116.1MDerived
- Provision needed to hold the allowance ratio
- $116.1MDerived
- Allowance after the stress
- $84.6MDerived
- Allowance to loans after
- 0.56%Derived
- After-tax capital impact
- $91.7MDerived
- CET1 ratio, after
- 10.22%Derived
- Change in CET1 ratio
- −75.3 bpDerived
- Equity to assets, after
- 6.37%Derived
- Net charge-off rate that takes capital to the floor
- 4.02%Derived
| Scenario | Net charge-off rate | Provision to hold ACL/loans | After-tax capital impact | CET1 ratio after | Change |
|---|---|---|---|---|---|
| This bank's current annualized net charge-off rate | 0.17% | $26.4M | $20.9M | 10.80% | −17.1 bp |
| Median among $10B–$50B banks | 0.11% | $16.9M | $13.3M | 10.86% | −10.9 bp |
| 90th percentile among $10B–$50B banks | 0.76% | $116.1M | $91.7M | 10.22% | −75.3 bp |
| 90th percentile among all banks | 0.31% | $47.3M | $37.4M | 10.67% | −30.7 bp |
| Measure | This bank | Peer median | Comparison point | Comparison point is |
|---|---|---|---|---|
| Net charge-off rate, annualized | 0.17% | 0.11% | 0.76% | 90th percentile |
| Allowance to loans | 0.56% | 1.18% | 0.94% | 25th percentile (thinner cushion) |
| CET1 ratio | 10.97% | 13.00% | 12.24% | 25th percentile (thinner cushion) |
Filed: Reported directly in the bank's FFIEC Call Report. Derived: Calculated by OptimaYield from filed figures using the method described below. Assumed: An assumption you entered or a scenario input, not a reported figure.
Questions and answers
How is the provision calculated?
It is the net charge-offs in the stress plus the change in the allowance needed to hold the allowance-to-loans ratio (plus any build you set) on ending loans. A provision is never negative in this tool.
Why does the tool show CET1 for some banks and the leverage ratio for others?
Banks that use the community bank leverage ratio framework report no risk-weighted assets, so a CET1 ratio cannot be computed for them. The tool uses the Tier 1 leverage ratio for those banks, and for the few special-purpose banks whose capital exceeds risk-weighted assets.
What does the breakeven NCO rate mean?
It is the annual net charge-off rate at which the bank's capital ratio would fall exactly to the capital floor, given the same tax, earnings, growth, and reserve assumptions. A higher breakeven means more loss-absorbing headroom.
Where do the peers come from?
From the latest Call Reports of banks in the same reported asset band as the selected bank: median and 90th percentile net charge-off rates, allowance ratios, and capital ratios.
Use it from code or an AI assistant
The same calculation is available as a free JSON and CSV API, an OpenAPI description, and a remote MCP server, so analysts, scripts, and AI assistants get identical numbers.
curl "https://www.optimayield.com/api/tools/loss-reserve-scenario/run?certificate=57311"- Machine-readable definition and input schema
- OpenAPI description
- MCP server:
https://www.optimayield.com/api/mcp(tool nameloss_reserve_scenario) - llms.txt
More free tools
- Net interest income rate-shock calculator: Estimate how a Fed funds move changes a bank's loan yield, deposit cost, and net interest income, using its own filed pass-through history.
- Margin capture report: loan beta versus deposit beta: Compare a bank's loan beta with its deposit beta and rank the spread against its asset-band peers, from FFIEC filings.
- Maturity wall refinancing calculator: See how much of a bank's time deposits mature within a year and what rolling them over, or replacing what runs off, would add to interest cost.
- Deposit pricing decision: Defend, Match, or Lead: Price holding, matching, or beating the market rate on a bank's deposits: annual cost, balances at risk, breakeven retention, and sensitivity.