# NCUA Simplified CECL WARM Tool Site-served catalog guide. Service API contracts remain at catalog.formualizer.com. - [Workbook page](https://formualizer.com/catalog/ncua-cecl-warm) - [Subject guide (text)](https://formualizer.com/catalog/subjects/finance/llms.txt) - [Subject guide (JSON)](https://formualizer.com/catalog/subjects/finance/llms.json) - [Publisher page](https://ncua.gov/regulation-supervision/regulatory-compliance-resources/cecl-accounting-standards/simplified-cecl-tool) - [Ports (text)](https://formualizer.com/catalog/agents/ncua-cecl-warm/2026-Q3/ports/llms.txt) - [Ports (JSON)](https://formualizer.com/catalog/agents/ncua-cecl-warm/2026-Q3/ports/llms.json) - [OpenAPI](https://catalog.formualizer.com/v1/models/ncua-cecl-warm/2026-Q3/openapi.json) - [TypeScript types](https://catalog.formualizer.com/v1/models/ncua-cecl-warm/2026-Q3/types.d.ts) - [SheetPort manifest](https://catalog.formualizer.com/v1/models/ncua-cecl-warm/2026-Q3/fio.yaml) - [Evaluate endpoint (POST)](https://catalog.formualizer.com/v1/models/ncua-cecl-warm/2026-Q3/evaluate) - [MCP endpoint (POST)](https://catalog.formualizer.com/v1/mcp) ```json { "schemaVersion": 1, "kind": "workbook", "key": "ncua-cecl-warm/2026-Q3", "title": "NCUA Simplified CECL WARM Tool", "summary": "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.", "edition": "2026-Q3", "html": "https://formualizer.com/catalog/ncua-cecl-warm", "parent": { "text": "https://formualizer.com/catalog/subjects/finance/llms.txt", "json": "https://formualizer.com/catalog/subjects/finance/llms.json" }, "publisher": "National Credit Union Administration (NCUA)", "publisherPageUrl": "https://ncua.gov/regulation-supervision/regulatory-compliance-resources/cecl-accounting-standards/simplified-cecl-tool", "verificationLevel": "scenario-independent-arithmetic", "verificationExplanation": "Changed-input scenarios match an independent calculation.", "rightsExplanation": "The bundle classifies this government source as public domain.", "limitations": [ "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." ], "releaseBlockers": [], "licenseClass": "public-domain-gov", "disclaimer": "Catalog calculations, not certification.", "removal": "Entries are removed on the publisher’s request.", "flows": [ { "id": "quick_allowance_check", "title": "Quick allowance check", "description": "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.", "inputPorts": [ "credit_union_number", "credit_cards_balance", "credit_cards_q_factor", "credit_cards_warm_adjustment" ], "outputPorts": [ "allowance_summary", "segment_summary" ] }, { "id": "full_portfolio_warm_schedule", "title": "Full portfolio WARM schedule", "description": "All 13 balances, qualitative rates, WARM adjustments, documentation and 66 individual-loan rows; reports segment and pooled loss schedules.", "inputPorts": [ "credit_union_number", "total_assets", "credit_cards_balance", "credit_cards_q_factor", "credit_cards_warm_adjustment", "credit_cards_q_justification", "credit_cards_warm_justification", "payday_alternative_balance", "payday_alternative_q_factor", "payday_alternative_warm_adjustment", "payday_alternative_q_justification", "payday_alternative_warm_justification", "student_loans_balance", "student_loans_q_factor", "student_loans_warm_adjustment", "student_loans_q_justification", "student_loans_warm_justification", "other_unsecured_balance", "other_unsecured_q_factor", "other_unsecured_warm_adjustment", "other_unsecured_q_justification", "other_unsecured_warm_justification", "new_vehicle_balance", "new_vehicle_q_factor", "new_vehicle_warm_adjustment", "new_vehicle_q_justification", "new_vehicle_warm_justification", "used_vehicle_balance", "used_vehicle_q_factor", "used_vehicle_warm_adjustment", "used_vehicle_q_justification", "used_vehicle_warm_justification", "leases_balance", "leases_q_factor", "leases_warm_adjustment", "leases_q_justification", "leases_warm_justification", "other_secured_balance", "other_secured_q_factor", "other_secured_warm_adjustment", "other_secured_q_justification", "other_secured_warm_justification", "first_lien_residential_balance", "first_lien_residential_q_factor", "first_lien_residential_warm_adjustment", "first_lien_residential_q_justification", "first_lien_residential_warm_justification", "junior_lien_residential_balance", "junior_lien_residential_q_factor", "junior_lien_residential_warm_adjustment", "junior_lien_residential_q_justification", "junior_lien_residential_warm_justification", "other_real_estate_balance", "other_real_estate_q_factor", "other_real_estate_warm_adjustment", "other_real_estate_q_justification", "other_real_estate_warm_justification", "commercial_real_estate_balance", "commercial_real_estate_q_factor", "commercial_real_estate_warm_adjustment", "commercial_real_estate_q_justification", "commercial_real_estate_warm_justification", "commercial_other_balance", "commercial_other_q_factor", "commercial_other_warm_adjustment", "commercial_other_q_justification", "commercial_other_warm_justification", "individual_loans" ], "outputPorts": [ "total_loan_balance", "individual_allowance", "pooled_allowance", "total_allowance", "reserve_ratio", "allowance_summary", "segment_summary", "individual_summary", "pooled_balances", "loss_rates", "warm_schedule", "pooled_loss_components" ] } ], "example": { "id": "reference_portfolio", "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 }, "expectedOutputs": { "total_loan_balance": 15950000, "individual_allowance": 0, "pooled_allowance": 592744.8637286993, "total_allowance": 592744.8637286993, "reserve_ratio": 0.03716268738110967 }, "inputsJson": "{\"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}", "expectedOutputsJson": "{\"total_loan_balance\":15950000,\"individual_allowance\":0,\"pooled_allowance\":592744.8637286993,\"total_allowance\":592744.8637286993,\"reserve_ratio\":0.03716268738110967}" }, "ports": { "text": "https://formualizer.com/catalog/agents/ncua-cecl-warm/2026-Q3/ports/llms.txt", "json": "https://formualizer.com/catalog/agents/ncua-cecl-warm/2026-Q3/ports/llms.json" }, "service": { "openapi": "https://catalog.formualizer.com/v1/models/ncua-cecl-warm/2026-Q3/openapi.json", "types": "https://catalog.formualizer.com/v1/models/ncua-cecl-warm/2026-Q3/types.d.ts", "fio": "https://catalog.formualizer.com/v1/models/ncua-cecl-warm/2026-Q3/fio.yaml", "evaluate": "https://catalog.formualizer.com/v1/models/ncua-cecl-warm/2026-Q3/evaluate", "mcp": "https://catalog.formualizer.com/v1/mcp" } } ```