formualizer

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.

Tab 1 - SummaryB11:P28

Saved workbook valuesInputOutput

RowBCDEFJP
11Portfolio Segment (1)End of Period Loan BalanceLoans Assessed on Individual BasisCECL ACL Lifetime Loss RateCECL ACL
12Real Estate - Construction-$-0.0000%$-
13Real Estate - Commercial-$-0.0000%$-
14Real Estate - Residential-$-0.0000%$-
15Commercial-$-0.0000%$-
16Credit Cards-$-0.0000%$-
18Additional Segments (1)-$-0.0000%$-
280.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 / descriptionType / constraints / default
construction_balance

Nonnegative 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_rate

Nonnegative decimal lifetime loss rate: 0.01 = 1%; source default 0. Not an annual rate.

Type: number

Constraints: min: 0

Default: 0

construction_q_adjustment

Signed additive decimal lifetime-rate adjustment: 0.005 = +0.5 percentage point; source default 0.

Type: number

Default: 0

commercial_real_estate_balance

Nonnegative 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_rate

Nonnegative 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_adjustment

Signed additive decimal lifetime-rate adjustment: 0.005 = +0.5 percentage point; source default 0.

Type: number

Default: 0

residential_real_estate_balance

Nonnegative 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_rate

Nonnegative 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_adjustment

Signed additive decimal lifetime-rate adjustment: 0.005 = +0.5 percentage point; source default 0.

Type: number

Default: 0

commercial_balance

Nonnegative 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_rate

Nonnegative decimal lifetime loss rate: 0.01 = 1%; source default 0. Not an annual rate.

Type: number

Constraints: min: 0

Default: 0

commercial_q_adjustment

Signed additive decimal lifetime-rate adjustment: 0.005 = +0.5 percentage point; source default 0.

Type: number

Default: 0

Outputs (6)
Port / descriptionType / constraints / default
total_loans

Total end-of-period loans, USD.

Type: number

pooled_balance

Total pooled loans, USD; credit-card source H16 is a constant zero.

Type: number

base_pooled_allowance

USD pooled allowance before historical adjustment.

Type: number

individual_allowance

USD individual allowances for rows 9:24 only; source O25 is blank.

Type: number

total_allowance

Signed USD total allowance; source does not floor negative results.

Type: number

reserve_ratio

Decimal 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/mcp

Slug: 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.