# OHFA 2023 4% LIHTC Underwriting Model Site-served catalog guide. Service API contracts remain at catalog.formualizer.com. - [Workbook page](https://formualizer.com/catalog/ohfa-lihtc-4pct) - [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://ohiohome.org/ppd/resources.aspx) - [Ports (text)](https://formualizer.com/catalog/agents/ohfa-lihtc-4pct/2023/ports/llms.txt) - [Ports (JSON)](https://formualizer.com/catalog/agents/ohfa-lihtc-4pct/2023/ports/llms.json) - [OpenAPI](https://catalog.formualizer.com/v1/models/ohfa-lihtc-4pct/2023/openapi.json) - [TypeScript types](https://catalog.formualizer.com/v1/models/ohfa-lihtc-4pct/2023/types.d.ts) - [SheetPort manifest](https://catalog.formualizer.com/v1/models/ohfa-lihtc-4pct/2023/fio.yaml) - [Evaluate endpoint (POST)](https://catalog.formualizer.com/v1/models/ohfa-lihtc-4pct/2023/evaluate) - [MCP endpoint (POST)](https://catalog.formualizer.com/v1/mcp) ```json { "schemaVersion": 1, "kind": "workbook", "key": "ohfa-lihtc-4pct/2023", "title": "OHFA 2023 4% LIHTC Underwriting Model", "summary": "Ohio Housing Finance Agency 2023 4% LIHTC eligible credit sizing, operating budget and cashflow sensitivity from the AHFA source application.", "edition": "2023", "html": "https://formualizer.com/catalog/ohfa-lihtc-4pct", "parent": { "text": "https://formualizer.com/catalog/subjects/real-estate/llms.txt", "json": "https://formualizer.com/catalog/subjects/real-estate/llms.json" }, "publisher": "Ohio Housing Finance Agency (OHFA)", "publisherPageUrl": "https://ohiohome.org/ppd/resources.aspx", "verificationLevel": "scenario-independent-arithmetic", "verificationExplanation": "Changed-input scenarios match an independent calculation.", "rightsExplanation": "The workbook download opens on the publisher’s site.", "limitations": [ "Scalarize Cashflow legacy TRANSPOSE CSE formula across C:S to direct references to MLP Amortization U2:U18. No source file edits or table hydration. Source #REF diagnostics remain outside mapped outputs." ], "releaseBlockers": [], "licenseClass": "reference-only", "disclaimer": "Catalog calculations, not certification.", "removal": "Entries are removed on the publisher’s request.", "flows": [ { "id": "quick_lihtc_credit_sizing", "title": "Quick LIHTC credit sizing", "description": "Eligible basis, applicable fractions, credit rates and boost activation; single low-income rent cohort, acquisition/rehab/new construction allocations. Annual credit ceiling is distinct from requested credits and equity. Other competitive pool boosts use full cellOverrides.", "inputPorts": [ "units", "monthly_tenant_rent", "low_income_floor_area", "market_floor_area", "acquisition_basis", "rehabilitation_basis", "new_construction_basis", "rehab_qct_fraction", "new_qct_fraction", "rehab_credit_rate", "new_credit_rate", "program", "rent_limit_ami_fraction", "first_year_vacancy", "vacancy" ], "outputPorts": [ "annual_credit_eligible", "acquisition_credit", "rehabilitation_credit", "new_construction_credit", "applicable_fraction" ] }, { "id": "full_underwriting_budget_cashflow", "title": "Full underwriting budget and cashflow", "description": "Eligible basis, applicable fractions, credit rates and boost activation; all mapped rent, operating expense, senior debt and annual cashflow assumptions. Additional rent cohorts, detailed cost rows and competitive pool switches use cellOverrides. Not an award or compliance determination.", "inputPorts": [ "units", "monthly_tenant_rent", "low_income_floor_area", "market_floor_area", "acquisition_basis", "rehabilitation_basis", "new_construction_basis", "rehab_qct_fraction", "new_qct_fraction", "rehab_credit_rate", "new_credit_rate", "program", "rent_limit_ami_fraction", "first_year_vacancy", "vacancy", "monthly_rental_subsidy", "unit_square_feet", "annual_residential_fees", "annual_other_income", "annual_commercial_income", "annual_interest_income", "annual_laundry_income", "annual_office_expense", "annual_electricity", "annual_maintenance_supplies", "annual_insurance", "annual_replacement_reserve", "senior_loan_amount", "senior_loan_rate", "senior_loan_amortization", "income_escalation", "expense_escalation", "acquisition_credit_rate", "acquisition_credit_reduction", "rehabilitation_credit_reduction", "new_construction_credit_reduction", "gross_equity", "equity_bridge_interest", "equity_other_deductions" ], "outputPorts": [ "annual_credit_eligible", "acquisition_credit", "rehabilitation_credit", "new_construction_credit", "applicable_fraction", "effective_gross_income", "operating_expenses", "budget_noi", "year_one_noi", "year_one_cashflow", "year_two_cashflow", "senior_debt_service", "year_one_dscr", "net_equity" ] } ], "example": { "id": "rehabilitation_quick", "flow": "quick_lihtc_credit_sizing", "inputs": { "units": 60, "monthly_tenant_rent": 950, "low_income_floor_area": 54000, "acquisition_basis": 2000000, "rehabilitation_basis": 6000000, "program": "4% LIHTC", "rent_limit_ami_fraction": 0.6, "first_year_vacancy": 0.07, "vacancy": 0.07 }, "expectedOutputs": { "annual_credit_eligible": 320000, "acquisition_credit": 80000, "rehabilitation_credit": 240000, "new_construction_credit": 0, "applicable_fraction": 1 }, "inputsJson": "{\"units\":60,\"monthly_tenant_rent\":950,\"low_income_floor_area\":54000,\"acquisition_basis\":2000000,\"rehabilitation_basis\":6000000,\"program\":\"4% LIHTC\",\"rent_limit_ami_fraction\":0.6,\"first_year_vacancy\":0.07,\"vacancy\":0.07}", "expectedOutputsJson": "{\"annual_credit_eligible\":320000,\"acquisition_credit\":80000,\"rehabilitation_credit\":240000,\"new_construction_credit\":0,\"applicable_fraction\":1}" }, "ports": { "text": "https://formualizer.com/catalog/agents/ohfa-lihtc-4pct/2023/ports/llms.txt", "json": "https://formualizer.com/catalog/agents/ohfa-lihtc-4pct/2023/ports/llms.json" }, "service": { "openapi": "https://catalog.formualizer.com/v1/models/ohfa-lihtc-4pct/2023/openapi.json", "types": "https://catalog.formualizer.com/v1/models/ohfa-lihtc-4pct/2023/types.d.ts", "fio": "https://catalog.formualizer.com/v1/models/ohfa-lihtc-4pct/2023/fio.yaml", "evaluate": "https://catalog.formualizer.com/v1/models/ohfa-lihtc-4pct/2023/evaluate", "mcp": "https://catalog.formualizer.com/v1/mcp" } } ```