formualizer

Excel workbook · Catalog edition 2026-Q3

NCUA Simplified CECL WARM Tool

National Credit Union Administration (NCUA)

Estimate credit loss allowances across 13 portfolio segments using historical loss rates, remaining maturities and individually assessed loans.

Inputs
68
Outputs
12
File size
1161 KB
Verification
Independent scenario check

Try it

Try it loads a copy of this file from formualizer.com.

Tab 1 - SummaryA5:F19

Saved workbook valuesOutput

RowABCDEF
5Loan Portfolio SegmentLoan BalanceLoss Assessed on Individual BasisLoss Assessed on Pooled BasisTotal Estimated LossReserve Ratio
6Unsecured Credit Card Loans (1)$-$-$-$-0.00%
7Payday Alternative Loans (2)$-$-$-$-0.00%
8Non-Federally Guaranteed Student Loans (3)$-$-$-$-0.00%
9All Other Unsecured Loans/Lines of Credit (4)$-$-$-$-0.00%
10New Vehicle Loans (5)$-$-$-$-0.00%
11Used Vehicle Loans (6)$-$-$-$-0.00%
19Total Loans and Leases (14)$-$-$-$-0.00%

What was checked

Changed-input scenarios match an independent calculation.

Scope and limitations

Catalog calculations, not certification.

Overview!A3: For September 30, 2026

Estimates credit-union allowance for credit losses using 13 portfolio segments, historical annual loss rates, peer weighted-average remaining maturity, qualitative adjustments and individually assessed loans.

  • No live check of the publisher's latest release was performed.
  • Not a compliance certification or NCUA endorsement.
  • Fixed individual-loan table covers source A29:E94; source SUMIF ranges also include row 95, which is outside Table5. No row-95 inputs are exposed.
  • Source lookup historical rates cover qualifying institutions; Blank CU supplies rates through Q adjustments. C5 mixes string Blank and numeric charter keys: use numeric cellOverrides for charter selection; string numeric IDs do not match.
  • Quarter-end/name display approximate VLOOKUP ranges end at row 4229 while source Data extends through 4333; preserved, not corrected.
  • WARM is a portfolio-level proxy, with peer maturity values converted from months to years; it is not simply contractual maturity.
  • Quantitative pooled loss uses the unadjusted historical rate and peer WARM; qualitative pooled loss is combined loss less quantitative loss. Individual allowances are added separately.
  • Signed adjustments can produce negative applicable rates or remaining life; the source flags potential recoveries and expects management review. These assumptions are not silently clamped.
  • No previous edition was supplied, so no quarter-over-quarter rule or data changes are asserted.
  • The runtime restores the source Table5 table metadata before calculation so individual-loan summary formulas can resolve their table references. Source formulas and values are preserved.

What it computes

Ports for the compact flow: quick_allowance_check. The full port contract includes all 80 ports.

Inputs (4)
Port / descriptionType / constraints / default
credit_union_number

Baseline literal Blank selects externally supplied loss-rate assumptions. Numeric CU charter selection requires cellOverrides on Tab 0 - Input!C5; numeric strings do not match numeric Data keys.

Type: string

Default: "Blank"

credit_cards_balance

Unsecured Credit Card Loans

Type: number

Units: currency: USD

Constraints: min: 0

Default: 0

credit_cards_q_factor

Additive annual loss-rate adjustment as a decimal (0.01 = one percentage point). With Blank CU, this supplies the annual rate.

Type: number

Default: 0

credit_cards_warm_adjustment

Additive adjustment to peer WARM, in years; signed.

Type: number

Default: 0

Outputs (2)
Port / descriptionType / constraints / default
allowance_summary

Type: record

Shape: 5 fields: total_loan_balance: number, individual_allowance: number, pooled_allowance: number, total_allowance: number, reserve_ratio: number

segment_summary

13 source portfolio segments; reserve ratio is a decimal. Field prefixes identify the 13 source segments. Fixed rows exclude total/check status/notes.

Type: record

Shape: 78 fields: credit_cards_segment: string, credit_cards_loan_balance: number, credit_cards_individual_allowance: number, credit_cards_pooled_allowance: number, credit_cards_total_allowance: number; remaining fields in the linked API contract

Questions this workbook answers

  • Estimate credit union CECL allowance for September 2026
  • Calculate NCUA WARM allowance by loan segment
  • Stress credit union loan balances and qualitative loss factors
  • Build a 2026 Q3 CECL reserve schedule

Questions and answers

How does the NCUA WARM tool estimate pooled losses?

For each of 13 segments, pooled balance is the nonnegative difference between total loans and individually assessed loans. The tool multiplies this by the historical annual loss rate plus the qualitative loss-rate adjustment, and by peer WARM in years plus its adjustment.

Can I supply my own loss-rate assumption?

Yes. The source instructions say to use Blank as the CU Number and enter the loss rate in Tab 4 loss-rate adjustments when the tool does not provide historical rates. Rates use decimals: 0.01 means 1%.

How are individually assessed loans handled?

Each loan has a segment, balance and expected collections. Its allowance is max(balance minus expected collections, 0). The balance is removed from the pooled calculation for its segment.

Does use of this tool establish GAAP compliance?

No. The source disclaimer assigns management responsibility for methodology suitability, documentation, GAAP conformity and adequate credit-risk coverage.

What does the 2026 Q3 edition mean?

The original workbook Overview identifies September 30, 2026. The pilot pins that workbook hash and peer WARM data; it does not refresh to later quarters automatically.

For agents

Connect an MCP client to the catalog endpoint:

https://catalog.formualizer.com/v1/mcp

Slug: ncua-cecl-warm · Edition: 2026-Q3

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": "ncua-cecl-warm",
    "edition": "2026-Q3",
    "flow": "full_portfolio_warm_schedule",
    "inputs": {
      "credit_union_number": "Blank",
      "total_assets": 23925000,
      "credit_cards_balance": 1000000,
      "credit_cards_q_factor": 0.01,
      "credit_cards_warm_adjustment": 0,
      "payday_alternative_balance": 100000,
      "payday_alternative_q_factor": 0.01,
      "payday_alternative_warm_adjustment": 0,
      "student_loans_balance": 250000,
      "student_loans_q_factor": 0.01,
      "student_loans_warm_adjustment": 0,
      "other_unsecured_balance": 750000,
      "other_unsecured_q_factor": 0.01,
      "other_unsecured_warm_adjustment": 0,
      "new_vehicle_balance": 2000000,
      "new_vehicle_q_factor": 0.01,
      "new_vehicle_warm_adjustment": 0,
      "used_vehicle_balance": 3000000,
      "used_vehicle_q_factor": 0.01,
      "used_vehicle_warm_adjustment": 0,
      "leases_balance": 100000,
      "leases_q_factor": 0.01,
      "leases_warm_adjustment": 0,
      "other_secured_balance": 500000,
      "other_secured_q_factor": 0.01,
      "other_secured_warm_adjustment": 0,
      "first_lien_residential_balance": 5000000,
      "first_lien_residential_q_factor": 0.01,
      "first_lien_residential_warm_adjustment": 0,
      "junior_lien_residential_balance": 1000000,
      "junior_lien_residential_q_factor": 0.01,
      "junior_lien_residential_warm_adjustment": 0,
      "other_real_estate_balance": 250000,
      "other_real_estate_q_factor": 0.01,
      "other_real_estate_warm_adjustment": 0,
      "commercial_real_estate_balance": 1500000,
      "commercial_real_estate_q_factor": 0.01,
      "commercial_real_estate_warm_adjustment": 0,
      "commercial_other_balance": 500000,
      "commercial_other_q_factor": 0.01,
      "commercial_other_warm_adjustment": 0
    }
  }
}

cellOverrides sets individual cells. selectCells reads at most 256 cells per request. trace requests formula lineage.

Flows

quick_allowance_check

Quick allowance check

Illustrative credit-card balance and annual loss-rate check; all omitted ports retain source baseline defaults. Select the full flow for other segments or individual loans.

4 input ports · 2 output ports. Full membership in the port contract.

full_portfolio_warm_schedule

Full portfolio WARM schedule

All 13 balances, qualitative rates, WARM adjustments, documentation and 66 individual-loan rows; reports segment and pooled loss schedules.

68 input ports · 12 output ports. Full membership in the port contract.

REST example

Bundle scenario: reference_portfolio · Flow: full_portfolio_warm_schedule

curl 'https://catalog.formualizer.com/v1/models/ncua-cecl-warm/2026-Q3/evaluate?flow=full_portfolio_warm_schedule' \
  -H 'Content-Type: application/json' \
  --data '{"inputs":{"credit_union_number":"Blank","total_assets":23925000,"credit_cards_balance":1000000,"credit_cards_q_factor":0.01,"credit_cards_warm_adjustment":0,"payday_alternative_balance":100000,"payday_alternative_q_factor":0.01,"payday_alternative_warm_adjustment":0,"student_loans_balance":250000,"student_loans_q_factor":0.01,"student_loans_warm_adjustment":0,"other_unsecured_balance":750000,"other_unsecured_q_factor":0.01,"other_unsecured_warm_adjustment":0,"new_vehicle_balance":2000000,"new_vehicle_q_factor":0.01,"new_vehicle_warm_adjustment":0,"used_vehicle_balance":3000000,"used_vehicle_q_factor":0.01,"used_vehicle_warm_adjustment":0,"leases_balance":100000,"leases_q_factor":0.01,"leases_warm_adjustment":0,"other_secured_balance":500000,"other_secured_q_factor":0.01,"other_secured_warm_adjustment":0,"first_lien_residential_balance":5000000,"first_lien_residential_q_factor":0.01,"first_lien_residential_warm_adjustment":0,"junior_lien_residential_balance":1000000,"junior_lien_residential_q_factor":0.01,"junior_lien_residential_warm_adjustment":0,"other_real_estate_balance":250000,"other_real_estate_q_factor":0.01,"other_real_estate_warm_adjustment":0,"commercial_real_estate_balance":1500000,"commercial_real_estate_q_factor":0.01,"commercial_real_estate_warm_adjustment":0,"commercial_other_balance":500000,"commercial_other_q_factor":0.01,"commercial_other_warm_adjustment":0}}'

Expected response

Expected values from the bundle, subject to the check level above.

{
  "outputs": {
    "total_loan_balance": 15950000,
    "individual_allowance": 0,
    "pooled_allowance": 592744.8637286993,
    "total_allowance": 592744.8637286993,
    "reserve_ratio": 0.03716268738110967
  }
}

Looking for another spreadsheet? Request a workbook.