{
  "spec": "fio",
  "spec_version": "0.3.0",
  "capabilities": {
    "profile": "full-v0"
  },
  "manifest": {
    "id": "wi-multifamily-application-2027",
    "name": "WHEDA 2027 Project Concept Multifamily Operating Cashflow",
    "workbook": {
      "uri": "2027-multifamily-application.xlsx",
      "locale": "en-US",
      "date_system": 1900
    }
  },
  "ports": [
    {
      "id": "units",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'11. Unit Mix'!H16"
      },
      "schema": {
        "type": "integer"
      },
      "default": 0,
      "constraints": {
        "min": 0
      },
      "description": "Whole units in a single cohort; all other cohorts remain empty. All omitted costs, other income and cohorts retain publisher blank/zero defaults."
    },
    {
      "id": "monthly_rent",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'11. Unit Mix'!K16"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "constraints": {
        "min": 0
      },
      "description": "USD/unit/month, positive monthly net rent; no utility allowance is added to income. All omitted costs, other income and cohorts retain publisher blank/zero defaults."
    },
    {
      "id": "income_tier",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'11. Unit Mix'!I16"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "constraints": {
        "enum": [
          0,
          0.6
        ]
      },
      "description": "Decimal fraction. Set 0.6 to activate this cohort in the 60% CMI rent summary. Baseline 0 represents blank/unclassified; rent does not flow into income until a recognized tier is selected. This is a routing assumption, not rent-limit validation. All omitted costs, other income and cohorts retain publisher blank/zero defaults."
    },
    {
      "id": "vacancy",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'17. Cash Flow and Reserves'!E10"
      },
      "schema": {
        "type": "number"
      },
      "default": 0.07,
      "constraints": {
        "min": 0,
        "max": 1
      },
      "description": "Decimal fraction 0..1 of gross residential rent deducted for vacancy. All omitted costs, other income and cohorts retain publisher blank/zero defaults."
    },
    {
      "id": "management",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'16. Projected Operating Costs'!D17"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "constraints": {
        "min": 0
      },
      "description": "USD/year, positive residential management expense deducted from income. All omitted costs, other income and cohorts retain publisher blank/zero defaults."
    },
    {
      "id": "electricity",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'16. Projected Operating Costs'!D31"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "constraints": {
        "min": 0
      },
      "description": "USD/year, positive electricity expense deducted from income. All omitted costs, other income and cohorts retain publisher blank/zero defaults."
    },
    {
      "id": "maintenance",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'16. Projected Operating Costs'!D40"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "constraints": {
        "min": 0
      },
      "description": "USD/year, positive maintenance contract expense deducted from income. All omitted costs, other income and cohorts retain publisher blank/zero defaults."
    },
    {
      "id": "taxes",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'16. Projected Operating Costs'!D51"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "constraints": {
        "min": 0
      },
      "description": "USD/year, positive real estate and personal property taxes deducted from income. All omitted costs, other income and cohorts retain publisher blank/zero defaults."
    },
    {
      "id": "insurance",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'16. Projected Operating Costs'!D52"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "constraints": {
        "min": 0
      },
      "description": "USD/year, positive property/liability insurance deducted from income. All omitted costs, other income and cohorts retain publisher blank/zero defaults."
    },
    {
      "id": "annual_reserve",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'16. Projected Operating Costs'!D86"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "constraints": {
        "min": 0
      },
      "description": "USD/year, positive annual replacement reserve; publisher deducts this in operating expenses before NOI. All omitted costs, other income and cohorts retain publisher blank/zero defaults."
    },
    {
      "id": "loan_principal",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'12. Funding Sources'!E11"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "constraints": {
        "min": 0
      },
      "description": "USD, positive first permanent loan principal. Other loans remain zero. All omitted costs, other income and cohorts retain publisher blank/zero defaults."
    },
    {
      "id": "loan_rate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'12. Funding Sources'!K11"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "constraints": {
        "min": 0,
        "max": 1
      },
      "description": "Decimal fraction annual interest rate; monthly level payments are assumed. All omitted costs, other income and cohorts retain publisher blank/zero defaults."
    },
    {
      "id": "amortization_years",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'12. Funding Sources'!M11"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "constraints": {
        "min": 0,
        "max": 50
      },
      "description": "Years, monthly amortization period; zero retains blank-baseline debt service. All omitted costs, other income and cohorts retain publisher blank/zero defaults."
    },
    {
      "id": "payment_schedule",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'12. Funding Sources'!J11"
      },
      "schema": {
        "type": "string"
      },
      "default": "",
      "constraints": {
        "enum": [
          "",
          "Must Pay/Hard Debt"
        ]
      },
      "description": "Set Must Pay/Hard Debt to activate annual first-loan debt service. Blank baseline produces zero service. All omitted costs, other income and cohorts retain publisher blank/zero defaults."
    },
    {
      "id": "effective_income",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'17. Cash Flow and Reserves'!D22"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD/year, residential income after vacancy."
    },
    {
      "id": "operating_expenses",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'17. Cash Flow and Reserves'!D23"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD/year, selected operating expenses plus replacement reserve."
    },
    {
      "id": "noi",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'17. Cash Flow and Reserves'!I24"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD/year, income minus operating expenses including reserve."
    },
    {
      "id": "total_debt_service",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'17. Cash Flow and Reserves'!I25"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD/year, annual debt payments excluding TIF."
    },
    {
      "id": "cash_after_debt",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'17. Cash Flow and Reserves'!I26"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD/year, NOI minus annual debt; negative is a shortfall."
    },
    {
      "id": "dscr",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'17. Cash Flow and Reserves'!I27"
      },
      "schema": {
        "type": "number"
      },
      "description": "Ratio, NOI divided by debt rounded to three decimals; publisher returns zero at zero debt."
    }
  ]
}
