Excel workbook · Catalog edition 2025
PHFA 2025 Core Application Operating Underwriting
Pennsylvania Housing Finance Agency (PHFA)
Calculate net operating income, debt service coverage and cash flow in the PHFA multifamily operating budget and its first two pro forma years.
- Inputs
- 55
- Outputs
- 13
- File size
- 303 KB
- Verification
- Independent scenario check
Try it
Try it loads a copy of this file from formualizer.com.
Saved workbook valuesInputOutput
| Row | C | D | E | F | G | H | X |
|---|---|---|---|---|---|---|---|
| 190 | TOTAL OPERATING DISBURSEMENTS | $- | |||||
| 191 | |||||||
| 192 | NET OPERATING INCOME (NOI) | $- | |||||
| 193 | |||||||
| 194 | Primary Debt Service | $- | |||||
| 201 | PRIMARY DEBT SERVICE COVERAGE | 0.00% | |||||
| 204 | PennHOMES Debt Service | $- | |||||
| 209 | SECONDARY CASH FLOW | $- |
What was checked
Changed-input scenarios match an independent calculation.
Scope and limitations
Catalog calculations, not certification.
The date is the workbook's modified timestamp, not a confirmed publication date.
Pennsylvania Housing Finance Agency application operating budget and first-two-year proforma sensitivities.
What it computes
Ports for the compact flow: quick_operating_budget. The full port contract includes all 68 ports.
Inputs (14)
| Port / description | Type / constraints / default |
|---|---|
gross_residentialUSD/year, positive gross residential income entered directly; independent of unit rent-roll entries. Publisher baseline 0. | Type: number Constraints: min: 0 Default: 0 |
gross_commercialUSD/year, positive gross commercial income. Publisher baseline 0. | Type: number Constraints: min: 0 Default: 0 |
residential_vacancyDecimal fraction 0..1, residential vacancy deduction applied to gross residential. Publisher baseline 0.05. | Type: number Constraints: min: 0; max: 1 Default: 0.05 |
commercial_vacancy_amountUSD/year, positive commercial vacancy deduction; independent of the separate proforma commercial vacancy fraction. Publisher baseline 0. | Type: number Constraints: min: 0 Default: 0 |
laundryUSD/year, positive laundry income. Publisher baseline 0. | Type: number Constraints: min: 0 Default: 0 |
managementUSD/year, positive management operating disbursement deducted from income. Publisher baseline 0. | Type: number Constraints: min: 0 Default: 0 |
electricityUSD/year, positive electricity operating disbursement deducted from income. Publisher baseline 0. | Type: number Constraints: min: 0 Default: 0 |
maintenance_contractsUSD/year, positive maintenance contracts operating disbursement deducted from income. Publisher baseline 0. | Type: number Constraints: min: 0 Default: 0 |
office_salariesUSD/year, positive office salaries operating disbursement deducted from income. Publisher baseline 0. | Type: number Constraints: min: 0 Default: 0 |
real_estate_taxUSD/year, positive real estate tax operating disbursement deducted from income. Publisher baseline 0. | Type: number Constraints: min: 0 Default: 0 |
insuranceUSD/year, positive insurance operating disbursement deducted from income. Publisher baseline 0. | Type: number Constraints: min: 0 Default: 0 |
replacement_reserveUSD/year, positive replacement reserve operating disbursement deducted from income; reserve is included in publisher NOI. Publisher baseline 0. | Type: number Constraints: min: 0 Default: 0 |
primary_debtUSD/year, positive primary debt service disbursement deducted after NOI. Publisher baseline 0. | Type: number Constraints: min: 0 Default: 0 |
pennhomes_debtUSD/year, positive PennHOMES secondary debt service disbursement deducted after NOI. Publisher baseline 0. | Type: number Constraints: min: 0 Default: 0 |
Outputs (5)
| Port / description | Type / constraints / default |
|---|---|
effective_gross_incomeUSD/year after budget vacancy plus laundry | Type: number |
operating_disbursementsUSD/year positive, includes replacement reserve and investor fees | Type: number |
budget_noiUSD/year, effective income less all operating disbursements | Type: number |
budget_dscrRatio NOI / total primary debt; publisher returns zero if denominator zero | Type: number |
secondary_cashflowUSD/year signed cash after primary and secondary debt | Type: number |
Questions this workbook answers
- What NOI and debt coverage does my Pennsylvania affordable housing budget support?
- Stress PHFA rental vacancy and debt-service cashflow
- Compare first-two-year PHFA operating proforma assumptions
Questions and answers
Is this certification or endorsed by PHFA?
No PHFA endorsement. Use the publisher application for submissions to the publisher.
For agents
Connect an MCP client to the catalog endpoint:
https://catalog.formualizer.com/v1/mcpSlug: phfa-core-application · Edition: 2025
- search_workbooks
- Optional arguments: query (string), theme (string), tag (string).
- inspect_workbook
- Required: slug (string). Optional: edition (string), flow (string).
- evaluate_workbook
- Required: slug (string), inputs (object). Optional: edition (string), flow (string), cellOverrides (object), selectCells (array of strings), trace (boolean).
{
"name": "evaluate_workbook",
"arguments": {
"slug": "phfa-core-application",
"edition": "2025",
"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
}
}
}cellOverrides sets individual cells. selectCells reads at most 256 cells per request. trace requests formula lineage.
Flows
quick_operating_budget
Quick annual operating budget
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.
14 input ports · 5 output ports. Full membership in the port contract.
full_underwriting_budget_proforma
Full annual budget and first two proforma years
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.
55 input ports · 13 output ports. Full membership in the port contract.
REST example
Bundle scenario: quick_operating_budget_stabilized · Flow: quick_operating_budget
curl 'https://catalog.formualizer.com/v1/models/phfa-core-application/2025/evaluate?flow=quick_operating_budget' \
-H 'Content-Type: application/json' \
--data '{"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}}'Expected response
Expected values from the bundle, subject to the check level above.
{
"outputs": {
"effective_gross_income": 750000,
"operating_disbursements": 258000,
"budget_noi": 492000,
"budget_dscr": 2.05,
"secondary_cashflow": 222000
}
}Looking for another spreadsheet? Request a workbook.