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.
Saved workbook valuesOutput
| Row | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 5 | Loan Portfolio Segment | Loan Balance | Loss Assessed on Individual Basis | Loss Assessed on Pooled Basis | Total Estimated Loss | Reserve Ratio |
| 6 | Unsecured Credit Card Loans (1) | $- | $- | $- | $- | 0.00% |
| 7 | Payday Alternative Loans (2) | $- | $- | $- | $- | 0.00% |
| 8 | Non-Federally Guaranteed Student Loans (3) | $- | $- | $- | $- | 0.00% |
| 9 | All Other Unsecured Loans/Lines of Credit (4) | $- | $- | $- | $- | 0.00% |
| 10 | New Vehicle Loans (5) | $- | $- | $- | $- | 0.00% |
| 11 | Used Vehicle Loans (6) | $- | $- | $- | $- | 0.00% |
| 19 | Total 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 / description | Type / constraints / default |
|---|---|
credit_union_numberBaseline 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_balanceUnsecured Credit Card Loans | Type: number Units: currency: USD Constraints: min: 0 Default: 0 |
credit_cards_q_factorAdditive 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_adjustmentAdditive adjustment to peer WARM, in years; signed. | Type: number Default: 0 |
Outputs (2)
| Port / description | Type / 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_summary13 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/mcpSlug: 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.