{
  "spec": "fio",
  "spec_version": "0.3.0",
  "capabilities": {
    "profile": "full-v0"
  },
  "manifest": {
    "id": "nd-multifamily-exhibit-a-2026",
    "name": "NDHFA Multifamily Exhibit A Operating Cashflow",
    "workbook": {
      "uri": "MultifamilyExhibitA05.11.2026.xlsx",
      "locale": "en-US",
      "date_system": 1900
    }
  },
  "ports": [
    {
      "id": "units",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Operating Budget'!E7"
      },
      "schema": {
        "type": "integer"
      },
      "default": 0,
      "constraints": {
        "min": 0
      },
      "description": "Count, nonnegative whole units in a single non-staff rent cohort; other cohorts remain empty. Omitted expenses and other cohorts retain publisher zero/blank defaults."
    },
    {
      "id": "monthly_rent",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Operating Budget'!G7"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "constraints": {
        "min": 0
      },
      "description": "USD/unit/month, positive gross rent for the single cohort; vacancy is computed by the publisher as max(7%,1/units). Omitted expenses and other cohorts retain publisher zero/blank defaults."
    },
    {
      "id": "management",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Operating Budget'!H65"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "constraints": {
        "min": 0
      },
      "description": "USD/year, positive management fees deducted from income. Omitted expenses and other cohorts retain publisher zero/blank defaults."
    },
    {
      "id": "electricity",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Operating Budget'!H74"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "constraints": {
        "min": 0
      },
      "description": "USD/year, positive electricity expense deducted from income. Omitted expenses and other cohorts retain publisher zero/blank defaults."
    },
    {
      "id": "repairs",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Operating Budget'!H85"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "constraints": {
        "min": 0
      },
      "description": "USD/year, positive repairs expense deducted from income. Omitted expenses and other cohorts retain publisher zero/blank defaults."
    },
    {
      "id": "taxes",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Operating Budget'!H96"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "constraints": {
        "min": 0
      },
      "description": "USD/year, positive real estate taxes deducted from income. Omitted expenses and other cohorts retain publisher zero/blank defaults."
    },
    {
      "id": "insurance",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Operating Budget'!H99"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "constraints": {
        "min": 0
      },
      "description": "USD/year, positive property hazard and liability insurance deducted from income. Omitted expenses and other cohorts retain publisher zero/blank defaults."
    },
    {
      "id": "reserve_per_unit",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Operating Budget'!G107"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "constraints": {
        "min": 0
      },
      "description": "USD/unit/year, positive replacement reserve contribution; publisher includes reserve in NOI deductions. Omitted expenses and other cohorts retain publisher zero/blank defaults."
    },
    {
      "id": "annual_debt_service",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'30-yr Cash Flow Projection'!C21"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "constraints": {
        "min": 0
      },
      "description": "USD/year, positive debt source 1 payment entered directly, not derived from the separate payment estimator. Other debt payments remain zero. Omitted expenses and other cohorts retain publisher zero/blank defaults."
    },
    {
      "id": "effective_income",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Operating Budget'!H57"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD/year, income after publisher vacancy deduction."
    },
    {
      "id": "operating_expenses",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'30-yr Cash Flow Projection'!C14"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD/year, expenses including replacement reserve contributions."
    },
    {
      "id": "noi",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'30-yr Cash Flow Projection'!C16"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD/year, income less expenses including reserves."
    },
    {
      "id": "total_debt_service",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'30-yr Cash Flow Projection'!C33"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD/year, total entered annual debt payments."
    },
    {
      "id": "cash_after_debt",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'30-yr Cash Flow Projection'!C35"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD/year, NOI less annual debt payments; negative means deficit."
    }
  ]
}
