# OHFA 2023 9% LIHTC Underwriting Model Site-served catalog guide. Service API contracts remain at catalog.formualizer.com. - [Workbook page](https://formualizer.com/catalog/ohfa-lihtc-9pct) - [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-9pct/2023/ports/llms.txt) - [Ports (JSON)](https://formualizer.com/catalog/agents/ohfa-lihtc-9pct/2023/ports/llms.json) - [OpenAPI](https://catalog.formualizer.com/v1/models/ohfa-lihtc-9pct/2023/openapi.json) - [TypeScript types](https://catalog.formualizer.com/v1/models/ohfa-lihtc-9pct/2023/types.d.ts) - [SheetPort manifest](https://catalog.formualizer.com/v1/models/ohfa-lihtc-9pct/2023/fio.yaml) - [Evaluate endpoint (POST)](https://catalog.formualizer.com/v1/models/ohfa-lihtc-9pct/2023/evaluate) - [MCP endpoint (POST)](https://catalog.formualizer.com/v1/mcp) ```json { "schemaVersion": 1, "kind": "workbook", "key": "ohfa-lihtc-9pct/2023", "title": "OHFA 2023 9% LIHTC Underwriting Model", "summary": "Ohio Housing Finance Agency 2023 9% LIHTC eligible credit sizing, operating budget and cashflow sensitivity from the AHFA source application.", "edition": "2023", "html": "https://formualizer.com/catalog/ohfa-lihtc-9pct", "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", "vacancy", "mbe_wbe_developer" ], "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", "mbe_wbe_developer", "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", "annual_credit_requested" ], "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_full", "flow": "full_underwriting_budget_cashflow", "inputs": { "units": 60, "monthly_tenant_rent": 950, "low_income_floor_area": 54000, "acquisition_basis": 2000000, "rehabilitation_basis": 6000000, "program": "9% Competitive", "rent_limit_ami_fraction": 0.6, "first_year_vacancy": 0.07, "vacancy": 0.07, "annual_office_expense": 100000, "annual_electricity": 90000, "annual_maintenance_supplies": 60000, "annual_insurance": 40000, "annual_replacement_reserve": 18000, "senior_loan_amount": 3000000, "senior_loan_rate": 0.06, "senior_loan_amortization": 30 }, "expectedOutputs": { "annual_credit_eligible": 700999.9999999999, "acquisition_credit": 80000, "rehabilitation_credit": 620999.9999999999, "new_construction_credit": 0, "applicable_fraction": 1, "effective_gross_income": 636120, "operating_expenses": 308000, "budget_noi": 328120, "year_one_noi": 328120, "year_one_cashflow": 112281.81094500751, "year_two_cashflow": 115764.21094500742, "senior_debt_service": 215838.1890549925, "year_one_dscr": 1.520212903178129, "net_equity": 0 }, "inputsJson": "{\"units\":60,\"monthly_tenant_rent\":950,\"low_income_floor_area\":54000,\"acquisition_basis\":2000000,\"rehabilitation_basis\":6000000,\"program\":\"9% Competitive\",\"rent_limit_ami_fraction\":0.6,\"first_year_vacancy\":0.07,\"vacancy\":0.07,\"annual_office_expense\":100000,\"annual_electricity\":90000,\"annual_maintenance_supplies\":60000,\"annual_insurance\":40000,\"annual_replacement_reserve\":18000,\"senior_loan_amount\":3000000,\"senior_loan_rate\":0.06,\"senior_loan_amortization\":30}", "expectedOutputsJson": "{\"annual_credit_eligible\":700999.9999999999,\"acquisition_credit\":80000,\"rehabilitation_credit\":620999.9999999999,\"new_construction_credit\":0,\"applicable_fraction\":1,\"effective_gross_income\":636120,\"operating_expenses\":308000,\"budget_noi\":328120,\"year_one_noi\":328120,\"year_one_cashflow\":112281.81094500751,\"year_two_cashflow\":115764.21094500742,\"senior_debt_service\":215838.1890549925,\"year_one_dscr\":1.520212903178129,\"net_equity\":0}" }, "ports": { "text": "https://formualizer.com/catalog/agents/ohfa-lihtc-9pct/2023/ports/llms.txt", "json": "https://formualizer.com/catalog/agents/ohfa-lihtc-9pct/2023/ports/llms.json" }, "service": { "openapi": "https://catalog.formualizer.com/v1/models/ohfa-lihtc-9pct/2023/openapi.json", "types": "https://catalog.formualizer.com/v1/models/ohfa-lihtc-9pct/2023/types.d.ts", "fio": "https://catalog.formualizer.com/v1/models/ohfa-lihtc-9pct/2023/fio.yaml", "evaluate": "https://catalog.formualizer.com/v1/models/ohfa-lihtc-9pct/2023/evaluate", "mcp": "https://catalog.formualizer.com/v1/mcp" } } ```