formualizer
Workbook catalog

Workbook editions 13–24

Valuation and CECL spreadsheet calculators

Federal Reserve System (Supervision Outreach — SCALE Method)

Federal Reserve SCALE CECL Calculator

Estimate source-preserved seven-segment CECL allowances with qualitative, historical and individually assessed loan adjustments.

Edition 2026185 inputs · 17 outputsIndependent scenario check

Institutional Limited Partners Association (ILPA)

ILPA Reporting Template — LP Quarterly Reconciliation

Reconcile quarterly LP capital, management fees, partnership expenses, offsets, commitments and accrued incentive allocations using ILPA v1.1 source formulas.

Edition v1.157 inputs · 17 outputsIndependent scenario check

National Credit Union Administration (NCUA)

NCUA Simplified CECL WARM Tool

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

Edition 2026-Q368 inputs · 12 outputsIndependent scenario check

Actuarial value calculator spreadsheets

Centers for Medicare & Medicaid Services (CMS / CCIIO)

CMS Actuarial Value (AV) Calculator 2025

Explore CMS 2025 actuarial value, metal tiers and Silver CSR scenarios with reproducible inputs.

Edition 2025217 inputs · 6 outputsEngine regression check

Centers for Medicare & Medicaid Services (CMS / CCIIO)

CMS Actuarial Value (AV) Calculator 2027

Explore CMS 2027 actuarial value, metal tiers and Silver CSR scenarios with reproducible inputs.

Edition 2027217 inputs · 6 outputsEngine regression check

Affordable housing spreadsheet calculators

U.S. Department of Housing and Urban Development (HUD — Multifamily CNA e-Tool)

HUD CNA Reserve for Replacement Financial Factors

Test reserve deposits and mortgage debt service against the pinned HUD CNA example, with annual reserve balances and minimum-balance diagnostics.

Edition v30.332 inputs · 12 outputsIndependent scenario check

North Dakota Housing Finance Agency (NDHFA)

NDHFA Multifamily Exhibit A Operating Cashflow

Calculate first-year effective rental income, operating expenses, net operating income and cash after debt service for a single rent cohort.

Edition 20269 inputs · 5 outputsIndependent scenario check

Ohio Housing Finance Agency (OHFA)

OHFA 2023 4% LIHTC Underwriting Model

Ohio Housing Finance Agency 2023 4% LIHTC eligible credit sizing, operating budget and cashflow sensitivity from the AHFA source application.

Edition 202339 inputs · 14 outputsIndependent scenario check

Ohio Housing Finance Agency (OHFA)

OHFA 2023 9% LIHTC Underwriting Model

Ohio Housing Finance Agency 2023 9% LIHTC eligible credit sizing, operating budget and cashflow sensitivity from the AHFA source application.

Edition 202341 inputs · 14 outputsIndependent scenario check

Pennsylvania Housing Finance Agency (PHFA)

PHFA 2025 Core Application Operating Underwriting

Calculate net operating income, debt service coverage and cash flow in the PHFA multifamily operating budget and its first two pro forma years.

Edition 202555 inputs · 13 outputsIndependent scenario check

Rhode Island Housing (RIHousing)

RIHousing ELI One-Bedroom Subsidy Projection

Project the first-year, five-year and fifteen-year subsidy deficits for one-bedroom units with and without CES referrals using entered rent limits.

Edition 20266 inputs · 4 outputsIndependent scenario check

Wisconsin Housing and Economic Development Authority (WHEDA)

WHEDA 2027 Project Concept Multifamily Operating Cashflow

First-year residential NOI, debt coverage and cash after debt for one 60%-CMI rent cohort with selected annual expenses.

Edition 202714 inputs · 6 outputsIndependent scenario check

Scope and limitations

Catalog calculations, not certification.

Looking for another spreadsheet? Request a workbook.