formualizer

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.

Pages 201-204C190:AC209

Saved workbook valuesInputOutput

RowCDEFGHX
190TOTAL OPERATING DISBURSEMENTS$-
191
192NET OPERATING INCOME (NOI)$-
193
194Primary Debt Service$-
201PRIMARY DEBT SERVICE COVERAGE0.00%
204PennHOMES Debt Service$-
209SECONDARY 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 / descriptionType / constraints / default
    gross_residential

    USD/year, positive gross residential income entered directly; independent of unit rent-roll entries. Publisher baseline 0.

    Type: number

    Constraints: min: 0

    Default: 0

    gross_commercial

    USD/year, positive gross commercial income. Publisher baseline 0.

    Type: number

    Constraints: min: 0

    Default: 0

    residential_vacancy

    Decimal 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_amount

    USD/year, positive commercial vacancy deduction; independent of the separate proforma commercial vacancy fraction. Publisher baseline 0.

    Type: number

    Constraints: min: 0

    Default: 0

    laundry

    USD/year, positive laundry income. Publisher baseline 0.

    Type: number

    Constraints: min: 0

    Default: 0

    management

    USD/year, positive management operating disbursement deducted from income. Publisher baseline 0.

    Type: number

    Constraints: min: 0

    Default: 0

    electricity

    USD/year, positive electricity operating disbursement deducted from income. Publisher baseline 0.

    Type: number

    Constraints: min: 0

    Default: 0

    maintenance_contracts

    USD/year, positive maintenance contracts operating disbursement deducted from income. Publisher baseline 0.

    Type: number

    Constraints: min: 0

    Default: 0

    office_salaries

    USD/year, positive office salaries operating disbursement deducted from income. Publisher baseline 0.

    Type: number

    Constraints: min: 0

    Default: 0

    real_estate_tax

    USD/year, positive real estate tax operating disbursement deducted from income. Publisher baseline 0.

    Type: number

    Constraints: min: 0

    Default: 0

    insurance

    USD/year, positive insurance operating disbursement deducted from income. Publisher baseline 0.

    Type: number

    Constraints: min: 0

    Default: 0

    replacement_reserve

    USD/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_debt

    USD/year, positive primary debt service disbursement deducted after NOI. Publisher baseline 0.

    Type: number

    Constraints: min: 0

    Default: 0

    pennhomes_debt

    USD/year, positive PennHOMES secondary debt service disbursement deducted after NOI. Publisher baseline 0.

    Type: number

    Constraints: min: 0

    Default: 0

    Outputs (5)
    Port / descriptionType / constraints / default
    effective_gross_income

    USD/year after budget vacancy plus laundry

    Type: number

    operating_disbursements

    USD/year positive, includes replacement reserve and investor fees

    Type: number

    budget_noi

    USD/year, effective income less all operating disbursements

    Type: number

    budget_dscr

    Ratio NOI / total primary debt; publisher returns zero if denominator zero

    Type: number

    secondary_cashflow

    USD/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/mcp

    Slug: 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.