# PHFA 2025 Core Application Operating Underwriting Site-served catalog guide. Service API contracts remain at catalog.formualizer.com. - [Workbook page](https://formualizer.com/catalog/phfa-core-application) - [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.phfa.org/mhp/developers/housingapplication.aspx) - [Ports (text)](https://formualizer.com/catalog/agents/phfa-core-application/2025/ports/llms.txt) - [Ports (JSON)](https://formualizer.com/catalog/agents/phfa-core-application/2025/ports/llms.json) - [OpenAPI](https://catalog.formualizer.com/v1/models/phfa-core-application/2025/openapi.json) - [TypeScript types](https://catalog.formualizer.com/v1/models/phfa-core-application/2025/types.d.ts) - [SheetPort manifest](https://catalog.formualizer.com/v1/models/phfa-core-application/2025/fio.yaml) - [Evaluate endpoint (POST)](https://catalog.formualizer.com/v1/models/phfa-core-application/2025/evaluate) - [MCP endpoint (POST)](https://catalog.formualizer.com/v1/mcp) ```json { "schemaVersion": 1, "kind": "workbook", "key": "phfa-core-application/2025", "title": "PHFA 2025 Core Application Operating Underwriting", "summary": "Pennsylvania Housing Finance Agency application operating budget and first-two-year proforma sensitivities. Catalog calculations, not certification; no PHFA endorsement.", "edition": "2025", "html": "https://formualizer.com/catalog/phfa-core-application", "parent": { "text": "https://formualizer.com/catalog/subjects/real-estate/llms.txt", "json": "https://formualizer.com/catalog/subjects/real-estate/llms.json" }, "publisher": "Pennsylvania Housing Finance Agency (PHFA)", "publisherPageUrl": "https://www.phfa.org/mhp/developers/housingapplication.aspx", "verificationLevel": "scenario-independent-arithmetic", "verificationExplanation": "Changed-input scenarios match an independent calculation.", "rightsExplanation": "The workbook download opens on the publisher’s site.", "limitations": [], "releaseBlockers": [], "licenseClass": "reference-only", "disclaimer": "Catalog calculations, not certification.", "removal": "Entries are removed on the publisher’s request.", "flows": [ { "id": "quick_operating_budget", "title": "Quick annual operating budget", "description": "What NOI, debt coverage and residual cash does this operating budget support? Annual income and debt service are direct inputs, not amortization or rent-roll derivations. All expenses/debt are positive deductions; cash may be negative. Aggregate annual USD assumptions and ratios only; unit mix and per-unit outputs are outside this contract. Catalog calculations, not certification. No PHFA endorsement.", "inputPorts": [ "gross_residential", "gross_commercial", "residential_vacancy", "commercial_vacancy_amount", "laundry", "management", "electricity", "maintenance_contracts", "office_salaries", "real_estate_tax", "insurance", "replacement_reserve", "primary_debt", "pennhomes_debt" ], "outputPorts": [ "effective_gross_income", "operating_disbursements", "budget_noi", "budget_dscr", "secondary_cashflow" ] }, { "id": "full_underwriting_budget_proforma", "title": "Full annual budget and first two proforma years", "description": "How do the detailed operating expenses, debt fees and independent proforma vacancy/escalation controls change NOI and first-two-year cash? Includes all mapped budget lines. First year is 12 months; no operating-month scaling. Aggregate annual USD assumptions and ratios only; unit mix and per-unit outputs are outside this contract. Catalog calculations, not certification. No PHFA endorsement.", "inputPorts": [ "gross_residential", "gross_commercial", "other_rental", "residential_vacancy", "commercial_vacancy_amount", "laundry", "advertising", "office_telephone", "management", "legal", "audit", "misc_admin", "fuel_oil", "electricity", "water", "gas", "sewer", "maintenance_supplies", "maintenance_contracts", "rubbish", "security", "repairs", "elevator", "hvac", "grounds", "painting", "vehicles", "misc_maintenance", "office_salaries", "manager_salaries", "employee_free_rent", "maintenance_salaries", "payroll_tax", "workers_comp", "benefits", "real_estate_tax", "insurance", "misc_tax", "supportive_services", "replacement_reserve", "investor_fee", "broadband", "other_expense", "primary_debt", "service_fee", "credit_enhancement", "other_service_fee", "pennhomes_debt", "secondary_other_1", "secondary_other_2", "residential_growth", "commercial_growth", "expense_growth", "proforma_residential_vacancy", "proforma_commercial_vacancy" ], "outputPorts": [ "effective_gross_income", "operating_disbursements", "budget_noi", "primary_debt_total", "initial_cashflow", "budget_dscr", "secondary_cashflow", "year1_noi", "year1_dscr", "year1_secondary_cashflow", "year2_noi", "year2_secondary_cashflow", "year2_dscr" ] } ], "example": { "id": "quick_operating_budget_stabilized", "flow": "quick_operating_budget", "inputs": { "gross_residential": 720000, "gross_commercial": 60000, "residential_vacancy": 0.05, "commercial_vacancy_amount": 6000, "laundry": 12000, "management": 36000, "electricity": 30000, "maintenance_contracts": 48000, "office_salaries": 60000, "real_estate_tax": 42000, "insurance": 24000, "replacement_reserve": 18000, "primary_debt": 240000, "pennhomes_debt": 30000 }, "expectedOutputs": { "effective_gross_income": 750000, "operating_disbursements": 258000, "budget_noi": 492000, "budget_dscr": 2.05, "secondary_cashflow": 222000 }, "inputsJson": "{\"gross_residential\":720000,\"gross_commercial\":60000,\"residential_vacancy\":0.05,\"commercial_vacancy_amount\":6000,\"laundry\":12000,\"management\":36000,\"electricity\":30000,\"maintenance_contracts\":48000,\"office_salaries\":60000,\"real_estate_tax\":42000,\"insurance\":24000,\"replacement_reserve\":18000,\"primary_debt\":240000,\"pennhomes_debt\":30000}", "expectedOutputsJson": "{\"effective_gross_income\":750000,\"operating_disbursements\":258000,\"budget_noi\":492000,\"budget_dscr\":2.05,\"secondary_cashflow\":222000}" }, "ports": { "text": "https://formualizer.com/catalog/agents/phfa-core-application/2025/ports/llms.txt", "json": "https://formualizer.com/catalog/agents/phfa-core-application/2025/ports/llms.json" }, "service": { "openapi": "https://catalog.formualizer.com/v1/models/phfa-core-application/2025/openapi.json", "types": "https://catalog.formualizer.com/v1/models/phfa-core-application/2025/types.d.ts", "fio": "https://catalog.formualizer.com/v1/models/phfa-core-application/2025/fio.yaml", "evaluate": "https://catalog.formualizer.com/v1/models/phfa-core-application/2025/evaluate", "mcp": "https://catalog.formualizer.com/v1/mcp" } } ```