# HUD CNA Reserve for Replacement Financial Factors Site-served catalog guide. Service API contracts remain at catalog.formualizer.com. - [Workbook page](https://formualizer.com/catalog/hud-cna-reserve-factors) - [Subject guide (text)](https://formualizer.com/catalog/subjects/real-estate/llms.txt) - [Subject guide (JSON)](https://formualizer.com/catalog/subjects/real-estate/llms.json) - [Publisher page](https://www.hud.gov/hud-partners/multifamily-cna) - [Ports (text)](https://formualizer.com/catalog/agents/hud-cna-reserve-factors/v30.3/ports/llms.txt) - [Ports (JSON)](https://formualizer.com/catalog/agents/hud-cna-reserve-factors/v30.3/ports/llms.json) - [OpenAPI](https://catalog.formualizer.com/v1/models/hud-cna-reserve-factors/v30.3/openapi.json) - [TypeScript types](https://catalog.formualizer.com/v1/models/hud-cna-reserve-factors/v30.3/types.d.ts) - [SheetPort manifest](https://catalog.formualizer.com/v1/models/hud-cna-reserve-factors/v30.3/fio.yaml) - [Evaluate endpoint (POST)](https://catalog.formualizer.com/v1/models/hud-cna-reserve-factors/v30.3/evaluate) - [MCP endpoint (POST)](https://catalog.formualizer.com/v1/mcp) ```json { "schemaVersion": 1, "kind": "workbook", "key": "hud-cna-reserve-factors/v30.3", "title": "HUD CNA Reserve for Replacement Financial Factors", "summary": "Test reserve deposits and mortgage debt service against the pinned HUD CNA example, with annual reserve balances and minimum-balance diagnostics.", "edition": "v30.3", "html": "https://formualizer.com/catalog/hud-cna-reserve-factors", "parent": { "text": "https://formualizer.com/catalog/subjects/real-estate/llms.txt", "json": "https://formualizer.com/catalog/subjects/real-estate/llms.json" }, "publisher": "U.S. Department of Housing and Urban Development (HUD — Multifamily CNA e-Tool)", "publisherPageUrl": "https://www.hud.gov/hud-partners/multifamily-cna", "verificationLevel": "scenario-independent-arithmetic", "verificationExplanation": "Changed-input scenarios match an independent calculation.", "rightsExplanation": "The bundle classifies this government source as public domain.", "limitations": [ "Pinned historic v30.3 example; latest publisher edition not checked.", "456 units are derived from the original financial schedule; no unit-count input is exposed.", "This flow varies trial deposits and the fixed 20-year inflated-needs schedule, not a new CNA component inventory.", "Publisher trial amortization diagnostic C65:C74 references original eTool balances; preserve and interpret with care.", "Risk and DSC adjustment cells remain zero as instructed by the workbook. DSC output equals the assumed coverage without an NOI adjustment.", "Source diagnostic I65:J65 divides by zero for years with no needs; these error cells are excluded from outputs.", "MATCH shim supports exact matches only; all calls in the pinned source use 0 or FALSE.", "Runtime MATCH with FALSE returns #N/A for three risk-analysis formulas. The runtime adapter implements exact-match semantics for all MATCH uses in this pinned workbook; no source formula edits." ], "releaseBlockers": [], "licenseClass": "public-domain-gov", "disclaimer": "Catalog calculations, not certification.", "removal": "Entries are removed on the publisher’s request.", "flows": [ { "id": "quick_reserve_analysis", "title": "Quick reserve analysis", "description": "Main decision inputs; omitted inputs retain the pinned source example defaults.", "inputPorts": [ "initial_reserve", "annual_deposit_per_unit", "initial_deposit_escalation", "deposit_change_year", "new_deposit_escalation", "mortgage_amount", "mortgage_coupon", "mortgage_years", "annual_mip", "assumed_dscr" ], "outputPorts": [ "year1_reserve", "year10_reserve", "year20_reserve", "annual_debt_service", "assumed_case_dscr", "first10_result" ] }, { "id": "full_reserve_analysis", "title": "Full reserve analysis", "description": "USD unless labeled USD/unit/year; percentage inputs use decimal fractions. Fixed 456-unit, 20-year source example. Full flow adds annual inflated needs, minimum reserve and amortization mitigation.", "inputPorts": [ "initial_reserve", "annual_deposit_per_unit", "initial_deposit_escalation", "deposit_change_year", "new_deposit_escalation", "mortgage_amount", "mortgage_coupon", "mortgage_years", "annual_mip", "assumed_dscr", "amortization_mitigation_fraction", "required_minimum_year1", "needs_year_1", "needs_year_2", "needs_year_3", "needs_year_4", "needs_year_5", "needs_year_6", "needs_year_7", "needs_year_8", "needs_year_9", "needs_year_10", "needs_year_11", "needs_year_12", "needs_year_13", "needs_year_14", "needs_year_15", "needs_year_16", "needs_year_17", "needs_year_18", "needs_year_19", "needs_year_20" ], "outputPorts": [ "year1_reserve", "year10_reserve", "year20_reserve", "annual_debt_service", "assumed_case_dscr", "first10_result", "later_result", "mitigation_result", "monthly_payment", "debt_service_per_unit", "annual_deposit_total", "risk_additional_deposit_per_unit" ] } ], "example": { "id": "funded_reserve", "flow": "quick_reserve_analysis", "inputs": { "initial_reserve": 1000000, "annual_deposit_per_unit": 900 }, "expectedOutputs": { "year1_reserve": 1420400, "year10_reserve": 2879318.215989068, "year20_reserve": 3394110.179226563, "annual_debt_service": 987988.5169231384, "assumed_case_dscr": 1.2, "first10_result": "PASS" }, "inputsJson": "{\"initial_reserve\":1000000,\"annual_deposit_per_unit\":900}", "expectedOutputsJson": "{\"year1_reserve\":1420400,\"year10_reserve\":2879318.215989068,\"year20_reserve\":3394110.179226563,\"annual_debt_service\":987988.5169231384,\"assumed_case_dscr\":1.2,\"first10_result\":\"PASS\"}" }, "ports": { "text": "https://formualizer.com/catalog/agents/hud-cna-reserve-factors/v30.3/ports/llms.txt", "json": "https://formualizer.com/catalog/agents/hud-cna-reserve-factors/v30.3/ports/llms.json" }, "service": { "openapi": "https://catalog.formualizer.com/v1/models/hud-cna-reserve-factors/v30.3/openapi.json", "types": "https://catalog.formualizer.com/v1/models/hud-cna-reserve-factors/v30.3/types.d.ts", "fio": "https://catalog.formualizer.com/v1/models/hud-cna-reserve-factors/v30.3/fio.yaml", "evaluate": "https://catalog.formualizer.com/v1/models/hud-cna-reserve-factors/v30.3/evaluate", "mcp": "https://catalog.formualizer.com/v1/mcp" } } ```