Excel workbook · Catalog edition 2026
Federal Reserve SCALE CECL Calculator
Federal Reserve System (Supervision Outreach — SCALE Method)
Estimate source-preserved seven-segment CECL allowances with qualitative, historical and individually assessed loan adjustments.
- Inputs
- 185
- Outputs
- 17
- File size
- 44 KB
- Verification
- Independent scenario check
Try it
Try it loads a copy of this file from formualizer.com.
Saved workbook valuesInputOutput
| Row | B | C | D | E | F | J | P |
|---|---|---|---|---|---|---|---|
| 11 | Portfolio Segment (1) | End of Period Loan Balance | Loans Assessed on Individual Basis | CECL ACL Lifetime Loss Rate | CECL ACL | ||
| 12 | Real Estate - Construction | - | $- | 0.0000% | $- | ||
| 13 | Real Estate - Commercial | - | $- | 0.0000% | $- | ||
| 14 | Real Estate - Residential | - | $- | 0.0000% | $- | ||
| 15 | Commercial | - | $- | 0.0000% | $- | ||
| 16 | Credit Cards | - | $- | 0.0000% | $- | ||
| 18 | Additional Segments (1) | - | $- | 0.0000% | $- | ||
| 28 | 0.00% |
What was checked
Changed-input scenarios match an independent calculation.
Scope and limitations
Catalog calculations, not certification.
2026 is a catalog snapshot label; source blank tool has no 2026 release marker.
- 2026 labels this catalog snapshot; the supplied blank workbook does not identify a 2026 publisher edition. No live check of the publisher's latest release was performed.
- The source uses H16 = 0, not D16-F16: credit-card pooled losses are always zero even when balances and proxy rates are supplied. Preserved without formula correction.
- Source O25 is blank although E25:K25 balances enter segment totals. Row 25 deducts individual balances from pools but contributes no individual allowance. Use rows 9:24 for calculated individual losses.
- Historical performance adjustment is the difference of fourteen unweighted 2007–2020 annual net-loss ratios, applied once to pooled balance; it is not multiplied by remaining life.
- Signed adjustments and pooled balances are not clamped by source formulas. Ensure individual balances do not exceed segment balances and review negative allowance outcomes.
- The blank tool contains no embedded peer loss-rate dataset. Supply proxy lifetime loss rates and justified qualitative assumptions. Numerical inputs use decimal ratios, not displayed percentage points.
- Quick-flow count is twelve inputs and six outputs. Full maps all numeric domain assumptions; presentation labels, years and narrative text are not mapped.
- Publisher attribution does not establish reuse licensing or GAAP suitability. This entry is listed for reference only; no workbook redistribution permission is established.
What it computes
Ports for the compact flow: quick_allowance. The full port contract includes all 202 ports.
Inputs (12)
| Port / description | Type / constraints / default |
|---|---|
construction_balanceNonnegative USD end-of-period loans; blank source default = zero. Individually assessed balances must not exceed this amount. | Type: number Constraints: nullable: true; min: 0 Default: null |
construction_proxy_rateNonnegative decimal lifetime loss rate: 0.01 = 1%; source default 0. Not an annual rate. | Type: number Constraints: min: 0 Default: 0 |
construction_q_adjustmentSigned additive decimal lifetime-rate adjustment: 0.005 = +0.5 percentage point; source default 0. | Type: number Default: 0 |
commercial_real_estate_balanceNonnegative USD end-of-period loans; blank source default = zero. Individually assessed balances must not exceed this amount. | Type: number Constraints: nullable: true; min: 0 Default: null |
commercial_real_estate_proxy_rateNonnegative decimal lifetime loss rate: 0.01 = 1%; source default 0. Not an annual rate. | Type: number Constraints: min: 0 Default: 0 |
commercial_real_estate_q_adjustmentSigned additive decimal lifetime-rate adjustment: 0.005 = +0.5 percentage point; source default 0. | Type: number Default: 0 |
residential_real_estate_balanceNonnegative USD end-of-period loans; blank source default = zero. Individually assessed balances must not exceed this amount. | Type: number Constraints: nullable: true; min: 0 Default: null |
residential_real_estate_proxy_rateNonnegative decimal lifetime loss rate: 0.01 = 1%; source default 0. Not an annual rate. | Type: number Constraints: min: 0 Default: 0 |
residential_real_estate_q_adjustmentSigned additive decimal lifetime-rate adjustment: 0.005 = +0.5 percentage point; source default 0. | Type: number Default: 0 |
commercial_balanceNonnegative USD end-of-period loans; blank source default = zero. Individually assessed balances must not exceed this amount. | Type: number Constraints: nullable: true; min: 0 Default: null |
commercial_proxy_rateNonnegative decimal lifetime loss rate: 0.01 = 1%; source default 0. Not an annual rate. | Type: number Constraints: min: 0 Default: 0 |
commercial_q_adjustmentSigned additive decimal lifetime-rate adjustment: 0.005 = +0.5 percentage point; source default 0. | Type: number Default: 0 |
Outputs (6)
| Port / description | Type / constraints / default |
|---|---|
total_loansTotal end-of-period loans, USD. | Type: number |
pooled_balanceTotal pooled loans, USD; credit-card source H16 is a constant zero. | Type: number |
base_pooled_allowanceUSD pooled allowance before historical adjustment. | Type: number |
individual_allowanceUSD individual allowances for rows 9:24 only; source O25 is blank. | Type: number |
total_allowanceSigned USD total allowance; source does not floor negative results. | Type: number |
reserve_ratioDecimal total allowance / total loans; 0.01 = 1%. Source returns zero when allowance is zero. | Type: number |
Questions this workbook answers
- How does the Federal Reserve SCALE CECL tool calculate allowance?
- Are SCALE loss rates entered as percentages?
- Does 2026 identify a new Federal Reserve SCALE release?
Questions and answers
How does the Federal Reserve SCALE CECL tool calculate allowance?
For each source segment it multiplies pooled balance by proxy lifetime loss rate plus qualitative adjustment, adds a historical institution-minus-peer adjustment, and adds individual-loan allowances. See documented credit-card and row-25 source quirks.
Are SCALE loss rates entered as percentages?
Use decimals: 0.02 means 2%. Qualitative and historical inputs use the same decimal convention.
Does 2026 identify a new Federal Reserve SCALE release?
No. It is this catalog snapshot label; the supplied blank workbook has no dated 2026 release marker.
For agents
Connect an MCP client to the catalog endpoint:
https://catalog.formualizer.com/v1/mcpSlug: fed-scale-cecl · Edition: 2026
- search_workbooks
- Optional arguments: query (string), theme (string), tag (string).
- inspect_workbook
- Required: slug (string). Optional: edition (string), flow (string).
- evaluate_workbook
- Required: slug (string), inputs (object). Optional: edition (string), flow (string), cellOverrides (object), selectCells (array of strings), trace (boolean).
{
"name": "evaluate_workbook",
"arguments": {
"slug": "fed-scale-cecl",
"edition": "2026",
"flow": "quick_allowance",
"inputs": {
"construction_balance": 10000000,
"construction_proxy_rate": 0.02,
"construction_q_adjustment": 0.005
}
}
}cellOverrides sets individual cells. selectCells reads at most 256 cells per request. trace requests formula lineage.
Flows
quick_allowance
Quick SCALE allowance
Twelve balance/rate/qualitative inputs for four main segments; all omitted assumptions retain source defaults. For credit cards, other consumer, history or individual loans use full_allowance.
12 input ports · 6 output ports. Full membership in the port contract.
full_allowance
Full SCALE allowance
All numeric domain inputs: seven segments, 17 individual-loan rows and 14 institution/peer annual loss ratios. Text narrative and borrower labels do not change calculations. Outputs preserve all source formulas.
185 input ports · 17 output ports. Full membership in the port contract.
REST example
Bundle scenario: construction · Flow: quick_allowance
curl 'https://catalog.formualizer.com/v1/models/fed-scale-cecl/2026/evaluate?flow=quick_allowance' \
-H 'Content-Type: application/json' \
--data '{"inputs":{"construction_balance":10000000,"construction_proxy_rate":0.02,"construction_q_adjustment":0.005}}'Expected response
Expected values from the bundle, subject to the check level above.
{
"outputs": {
"total_loans": 10000000,
"pooled_balance": 10000000,
"base_pooled_allowance": 250000,
"individual_allowance": 0,
"total_allowance": 250000,
"reserve_ratio": 0.025
}
}Looking for another spreadsheet? Request a workbook.