{
  "spec": "fio",
  "spec_version": "0.3.0",
  "capabilities": {
    "profile": "full-v0"
  },
  "manifest": {
    "id": "phfa-core-application-2025",
    "name": "PHFA 2025 Core Application Operating Underwriting",
    "workbook": {
      "uri": "core_application-vba-free.xlsx",
      "locale": "en-US",
      "date_system": 1900
    }
  },
  "ports": [
    {
      "id": "gross_residential",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X114"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "USD/year, positive gross residential income entered directly; independent of unit rent-roll entries. Publisher baseline 0.",
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "gross_commercial",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X115"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "USD/year, positive gross commercial income. Publisher baseline 0.",
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "other_rental",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X116"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "USD/year, positive other rental income. Publisher baseline 0.",
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "residential_vacancy",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!K118"
      },
      "schema": {
        "type": "number"
      },
      "default": 0.05,
      "description": "Decimal fraction 0..1, residential vacancy deduction applied to gross residential. Publisher baseline 0.05.",
      "constraints": {
        "min": 0,
        "max": 1
      }
    },
    {
      "id": "commercial_vacancy_amount",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X119"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "USD/year, positive commercial vacancy deduction; independent of the separate proforma commercial vacancy fraction. Publisher baseline 0.",
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "laundry",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X122"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "USD/year, positive laundry income. Publisher baseline 0.",
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "advertising",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X125"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "USD/year, positive advertising operating disbursement deducted from income. Publisher baseline 0.",
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "office_telephone",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X126"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "USD/year, positive office telephone operating disbursement deducted from income. Publisher baseline 0.",
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "management",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X127"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "USD/year, positive management operating disbursement deducted from income. Publisher baseline 0.",
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "legal",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X128"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "USD/year, positive legal operating disbursement deducted from income. Publisher baseline 0.",
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "audit",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X129"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "USD/year, positive audit operating disbursement deducted from income. Publisher baseline 0.",
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "misc_admin",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X130"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "USD/year, positive misc admin operating disbursement deducted from income. Publisher baseline 0.",
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "fuel_oil",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X133"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "USD/year, positive fuel oil operating disbursement deducted from income. Publisher baseline 0.",
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "electricity",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X134"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "USD/year, positive electricity operating disbursement deducted from income. Publisher baseline 0.",
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "water",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X135"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "USD/year, positive water operating disbursement deducted from income. Publisher baseline 0.",
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "gas",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X136"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "USD/year, positive gas operating disbursement deducted from income. Publisher baseline 0.",
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "sewer",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X137"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "USD/year, positive sewer operating disbursement deducted from income. Publisher baseline 0.",
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "maintenance_supplies",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X140"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "USD/year, positive maintenance supplies operating disbursement deducted from income. Publisher baseline 0.",
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "maintenance_contracts",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X141"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "USD/year, positive maintenance contracts operating disbursement deducted from income. Publisher baseline 0.",
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "rubbish",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X142"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "USD/year, positive rubbish operating disbursement deducted from income. Publisher baseline 0.",
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "security",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X143"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "USD/year, positive security operating disbursement deducted from income. Publisher baseline 0.",
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "repairs",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X144"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "USD/year, positive repairs operating disbursement deducted from income. Publisher baseline 0.",
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "elevator",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X145"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "USD/year, positive elevator operating disbursement deducted from income. Publisher baseline 0.",
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "hvac",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X146"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "USD/year, positive hvac operating disbursement deducted from income. Publisher baseline 0.",
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "grounds",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X147"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "USD/year, positive grounds operating disbursement deducted from income. Publisher baseline 0.",
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "painting",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X148"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "USD/year, positive painting operating disbursement deducted from income. Publisher baseline 0.",
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "vehicles",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X149"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "USD/year, positive vehicles operating disbursement deducted from income. Publisher baseline 0.",
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "misc_maintenance",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X150"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "USD/year, positive misc maintenance operating disbursement deducted from income. Publisher baseline 0.",
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "office_salaries",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X167"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "USD/year, positive office salaries operating disbursement deducted from income. Publisher baseline 0.",
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "manager_salaries",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X168"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "USD/year, positive manager salaries operating disbursement deducted from income. Publisher baseline 0.",
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "employee_free_rent",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X169"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "USD/year, positive employee free rent operating disbursement deducted from income. Publisher baseline 0.",
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "maintenance_salaries",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X170"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "USD/year, positive maintenance salaries operating disbursement deducted from income. Publisher baseline 0.",
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "payroll_tax",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X171"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "USD/year, positive payroll tax operating disbursement deducted from income. Publisher baseline 0.",
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "workers_comp",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X172"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "USD/year, positive workers comp operating disbursement deducted from income. Publisher baseline 0.",
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "benefits",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X173"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "USD/year, positive benefits operating disbursement deducted from income. Publisher baseline 0.",
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "real_estate_tax",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X176"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "USD/year, positive real estate tax operating disbursement deducted from income. Publisher baseline 0.",
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "insurance",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X177"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "USD/year, positive insurance operating disbursement deducted from income. Publisher baseline 0.",
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "misc_tax",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X178"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "USD/year, positive misc tax operating disbursement deducted from income. Publisher baseline 0.",
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "supportive_services",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X181"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "USD/year, positive supportive services operating disbursement deducted from income. Publisher baseline 0.",
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "replacement_reserve",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X183"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "USD/year, positive replacement reserve operating disbursement deducted from income; reserve is included in publisher NOI. Publisher baseline 0.",
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "investor_fee",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X185"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "USD/year, positive investor fee operating disbursement deducted from income. Publisher baseline 0.",
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "broadband",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X187"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "USD/year, positive broadband operating disbursement deducted from income. Publisher baseline 0.",
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "other_expense",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X188"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "USD/year, positive other expense operating disbursement deducted from income. Publisher baseline 0.",
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "primary_debt",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X194"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "USD/year, positive primary debt service disbursement deducted after NOI. Publisher baseline 0.",
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "service_fee",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X195"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "USD/year, positive service fee debt/service disbursement deducted after NOI. Publisher baseline 0.",
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "credit_enhancement",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X196"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "USD/year, positive credit enhancement debt/service disbursement deducted after NOI. Publisher baseline 0.",
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "other_service_fee",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X197"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "USD/year, positive other service fee debt/service disbursement deducted after NOI. Publisher baseline 0.",
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "pennhomes_debt",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X204"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "USD/year, positive PennHOMES secondary debt service disbursement deducted after NOI. Publisher baseline 0.",
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "secondary_other_1",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X205"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "USD/year, positive secondary other 1 debt/service disbursement deducted after NOI. Publisher baseline 0.",
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "secondary_other_2",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X206"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "USD/year, positive secondary other 2 debt/service disbursement deducted after NOI. Publisher baseline 0.",
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "residential_growth",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Proforma'!C4"
      },
      "schema": {
        "type": "number"
      },
      "default": 0.02,
      "description": "Decimal fraction 0..1 per year, residential/laundry and management-fee escalation. Publisher baseline 0.02.",
      "constraints": {
        "min": 0,
        "max": 1
      }
    },
    {
      "id": "commercial_growth",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Proforma'!C5"
      },
      "schema": {
        "type": "number"
      },
      "default": 0.02,
      "description": "Decimal fraction 0..1 per year, commercial/other rental escalation. Publisher baseline 0.02.",
      "constraints": {
        "min": 0,
        "max": 1
      }
    },
    {
      "id": "expense_growth",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Proforma'!C6"
      },
      "schema": {
        "type": "number"
      },
      "default": 0.03,
      "description": "Decimal fraction 0..1 per year, operating expense escalation excluding management and replacement reserve. Publisher baseline 0.03.",
      "constraints": {
        "min": 0,
        "max": 1
      }
    },
    {
      "id": "proforma_residential_vacancy",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Proforma'!C13"
      },
      "schema": {
        "type": "number"
      },
      "default": 0.05,
      "description": "Decimal fraction 0..1, independent proforma residential vacancy control; set alongside budget vacancy to align. Publisher baseline 0.05.",
      "constraints": {
        "min": 0,
        "max": 1
      }
    },
    {
      "id": "proforma_commercial_vacancy",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Proforma'!C14"
      },
      "schema": {
        "type": "number"
      },
      "default": 0.1,
      "description": "Decimal fraction 0..1, independent proforma commercial vacancy control; does not update budget commercial vacancy amount. Publisher baseline 0.1.",
      "constraints": {
        "min": 0,
        "max": 1
      }
    },
    {
      "id": "effective_gross_income",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X123"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD/year after budget vacancy plus laundry"
    },
    {
      "id": "operating_disbursements",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X190"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD/year positive, includes replacement reserve and investor fees"
    },
    {
      "id": "budget_noi",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X192"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD/year, effective income less all operating disbursements"
    },
    {
      "id": "primary_debt_total",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X198"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD/year positive primary debt and service fees"
    },
    {
      "id": "initial_cashflow",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X200"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD/year signed cash after primary debt"
    },
    {
      "id": "budget_dscr",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X201"
      },
      "schema": {
        "type": "number"
      },
      "description": "Ratio NOI / total primary debt; publisher returns zero if denominator zero"
    },
    {
      "id": "secondary_cashflow",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Pages 201-204'!X209"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD/year signed cash after primary and secondary debt"
    },
    {
      "id": "year1_noi",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Proforma'!D65"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD/year, first 12-month proforma NOI using independent proforma vacancy controls"
    },
    {
      "id": "year1_dscr",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Proforma'!D72"
      },
      "schema": {
        "type": "number"
      },
      "description": "Ratio first-year NOI / total primary debt; publisher returns zero if primary_debt alone is zero"
    },
    {
      "id": "year1_secondary_cashflow",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Proforma'!D77"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD/year signed first-year cash after all debt"
    },
    {
      "id": "year2_noi",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Proforma'!E65"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD/year second-year NOI; replacement reserve grows by fixed 3 percent regardless of expense_growth"
    },
    {
      "id": "year2_secondary_cashflow",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Proforma'!E77"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD/year signed second-year cash after all debt"
    },
    {
      "id": "year2_dscr",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Proforma'!E72"
      },
      "schema": {
        "type": "number"
      },
      "description": "Ratio second-year NOI / total primary debt; publisher returns zero if primary_debt alone is zero"
    }
  ]
}
