{
  "spec": "fio",
  "spec_version": "0.3.0",
  "capabilities": {
    "profile": "full-v0"
  },
  "manifest": {
    "id": "ohfa-lihtc-4pct-2023",
    "name": "OHFA 2023 4% LIHTC Underwriting Model",
    "workbook": {
      "uri": "ohfa-lihtc-4pct-2023.xlsx",
      "locale": "en-US",
      "date_system": 1900
    }
  },
  "ports": [
    {
      "id": "units",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Budget & Costs'!C9"
      },
      "schema": {
        "type": "number"
      },
      "description": "Residential units, count; first rent-roll cohort; nonnegative unless stated. Default 0 (blank numeric source cells act as zero).  Source location Budget & Costs!C9; effective default 0.",
      "default": 0,
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "monthly_tenant_rent",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Budget & Costs'!I9"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD per unit per month, positive income; nonnegative unless stated. Default 0 (blank numeric source cells act as zero).  Source location Budget & Costs!I9; effective default 0.",
      "default": 0,
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "low_income_floor_area",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Project Details'!C230"
      },
      "schema": {
        "type": "number"
      },
      "description": "Square feet, low-income rental area; paired with market floor area; nonnegative unless stated. Default 0 (blank numeric source cells act as zero).  Source location Project Details!C230; effective default 0.",
      "default": 0,
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "market_floor_area",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Project Details'!C229"
      },
      "schema": {
        "type": "number"
      },
      "description": "Square feet, market rental area; applicable fraction is lesser of unit and floor fractions; nonnegative unless stated. Default 0 (blank numeric source cells act as zero).  Source location Project Details!C229; effective default 0.",
      "default": 0,
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "acquisition_basis",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Budget & Costs'!F253"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD, building acquisition eligible basis allocation; nonnegative unless stated. Default 0 (blank numeric source cells act as zero).  Source location Budget & Costs!F253; effective default 0.",
      "default": 0,
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "rehabilitation_basis",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Budget & Costs'!G279"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD, residential rehabilitation eligible basis allocation; nonnegative unless stated. Default 0 (blank numeric source cells act as zero).  Source location Budget & Costs!G279; effective default 0.",
      "default": 0,
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "new_construction_basis",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Budget & Costs'!H278"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD, residential new construction eligible basis allocation; nonnegative unless stated. Default 0 (blank numeric source cells act as zero).  Source location Budget & Costs!H278; effective default 0.",
      "default": 0,
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "rehab_qct_fraction",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'LIHTCs'!D13"
      },
      "schema": {
        "type": "number"
      },
      "description": "Decimal fraction 0..1 of rehabilitation qualifying for 30% QCT/DDA boost; nonnegative unless stated. Default 0 (blank numeric source cells act as zero).  Source location LIHTCs!D13; effective default 0.0.",
      "default": 0,
      "constraints": {
        "min": 0,
        "max": 1
      }
    },
    {
      "id": "new_qct_fraction",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'LIHTCs'!E13"
      },
      "schema": {
        "type": "number"
      },
      "description": "Decimal fraction 0..1 of new construction qualifying for 30% QCT/DDA boost; nonnegative unless stated. Default 0 (blank numeric source cells act as zero).  Source location LIHTCs!E13; effective default 0.0.",
      "default": 0,
      "constraints": {
        "min": 0,
        "max": 1
      }
    },
    {
      "id": "rehab_credit_rate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'LIHTCs'!D31"
      },
      "schema": {
        "type": "number"
      },
      "description": "Annual decimal credit rate 0..1; nonnegative unless stated. Default 0.04 (blank numeric source cells act as zero).  Source location LIHTCs!D31; effective default 0.04.",
      "default": 0.04,
      "constraints": {
        "min": 0,
        "max": 1
      }
    },
    {
      "id": "new_credit_rate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'LIHTCs'!E31"
      },
      "schema": {
        "type": "number"
      },
      "description": "Annual decimal credit rate 0..1; nonnegative unless stated. Default 0.04 (blank numeric source cells act as zero).  Source location LIHTCs!E31; effective default 0.04.",
      "default": 0.04,
      "constraints": {
        "min": 0,
        "max": 1
      }
    },
    {
      "id": "program",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Project Details'!C20"
      },
      "schema": {
        "type": "string"
      },
      "description": "Text program switch: 4% LIHTC or 9% Competitive; activates competitive basis boost tests. Source default 4% LIHTC. Source location Project Details!C20; effective default 4% LIHTC.",
      "default": "4% LIHTC",
      "constraints": {
        "enum": [
          "",
          "4% LIHTC",
          "9% Competitive"
        ]
      }
    },
    {
      "id": "rent_limit_ami_fraction",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Budget & Costs'!G9"
      },
      "schema": {
        "type": "number"
      },
      "description": "Decimal fraction 0..1, rent affordability AMI; does not override rent-limit compliance; nonnegative unless stated. Default 0 (blank numeric source cells act as zero).  Source location Budget & Costs!G9; effective default 0.",
      "default": 0,
      "constraints": {
        "min": 0,
        "max": 1
      }
    },
    {
      "id": "first_year_vacancy",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Budget & Costs'!E83"
      },
      "schema": {
        "type": "number"
      },
      "description": "Decimal fraction 0..1, first-year cashflow vacancy; nonnegative unless stated. Default 0.07 (blank numeric source cells act as zero).  Source location Budget & Costs!E83; effective default 0.07.",
      "default": 0.07,
      "constraints": {
        "min": 0,
        "max": 1
      }
    },
    {
      "id": "vacancy",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Budget & Costs'!E82"
      },
      "schema": {
        "type": "number"
      },
      "description": "Decimal fraction 0..1, annual operating budget vacancy; nonnegative unless stated. Default 0.07 (blank numeric source cells act as zero).  Source location Budget & Costs!E82; effective default 0.07.",
      "default": 0.07,
      "constraints": {
        "min": 0,
        "max": 1
      }
    },
    {
      "id": "monthly_rental_subsidy",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Budget & Costs'!M9"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD per unit per month; nonnegative unless stated. Default 0 (blank numeric source cells act as zero).  Source location Budget & Costs!M9; effective default 0.",
      "default": 0,
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "unit_square_feet",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Budget & Costs'!F9"
      },
      "schema": {
        "type": "number"
      },
      "description": "Square feet per cohort unit; nonnegative unless stated. Default 0 (blank numeric source cells act as zero).  Source location Budget & Costs!F9; effective default 0.",
      "default": 0,
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "annual_residential_fees",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Budget & Costs'!F91"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD per year, positive income; nonnegative unless stated. Default 0 (blank numeric source cells act as zero).  Source location Budget & Costs!F91; effective default 0.0.",
      "default": 0,
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "annual_other_income",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Budget & Costs'!F92"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD per year, positive income; nonnegative unless stated. Default 0 (blank numeric source cells act as zero).  Source location Budget & Costs!F92; effective default 0.0.",
      "default": 0,
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "annual_commercial_income",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Budget & Costs'!F93"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD per year, positive income; nonnegative unless stated. Default 0 (blank numeric source cells act as zero).  Source location Budget & Costs!F93; effective default 0.0.",
      "default": 0,
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "annual_interest_income",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Budget & Costs'!F98"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD per year, positive income; nonnegative unless stated. Default 0 (blank numeric source cells act as zero).  Source location Budget & Costs!F98; effective default 0.",
      "default": 0,
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "annual_laundry_income",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Budget & Costs'!F103"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD per year, positive income; nonnegative unless stated. Default 0 (blank numeric source cells act as zero).  Source location Budget & Costs!F103; effective default 0.0.",
      "default": 0,
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "annual_office_expense",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Budget & Costs'!F116"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD per year, positive expense; nonnegative unless stated. Default 0 (blank numeric source cells act as zero).  Source location Budget & Costs!F116; effective default 0.0.",
      "default": 0,
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "annual_electricity",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Budget & Costs'!F132"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD per year, positive expense; nonnegative unless stated. Default 0 (blank numeric source cells act as zero).  Source location Budget & Costs!F132; effective default 0.0.",
      "default": 0,
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "annual_maintenance_supplies",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Budget & Costs'!F147"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD per year, positive expense; nonnegative unless stated. Default 0 (blank numeric source cells act as zero).  Source location Budget & Costs!F147; effective default 0.0.",
      "default": 0,
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "annual_insurance",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Budget & Costs'!F162"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD per year, positive expense; nonnegative unless stated. Default 0 (blank numeric source cells act as zero).  Source location Budget & Costs!F162; effective default 0.0.",
      "default": 0,
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "annual_replacement_reserve",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Budget & Costs'!F172"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD per year, positive expense; nonnegative unless stated. Default 0 (blank numeric source cells act as zero).  Source location Budget & Costs!F172; effective default 0.0.",
      "default": 0,
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "senior_loan_amount",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Budget & Costs'!G240"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD, positive principal; nonnegative unless stated. Default 0 (blank numeric source cells act as zero).  Source location Budget & Costs!G240; effective default 0.0.",
      "default": 0,
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "senior_loan_rate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Budget & Costs'!H240"
      },
      "schema": {
        "type": "number"
      },
      "description": "Decimal fraction 0..1, annual interest; nonnegative unless stated. Default 0.06 (blank numeric source cells act as zero).  Source location Budget & Costs!H240; effective default 0.0.",
      "default": 0,
      "constraints": {
        "min": 0,
        "max": 1
      }
    },
    {
      "id": "senior_loan_amortization",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Budget & Costs'!K240"
      },
      "schema": {
        "type": "number"
      },
      "description": "Years, positive amortization term when loan amount >0; nonnegative unless stated. Default 0 (blank numeric source cells act as zero).  Source location Budget & Costs!K240; effective default 0.",
      "default": 0,
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "income_escalation",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cashflow'!J25"
      },
      "schema": {
        "type": "number"
      },
      "description": "Decimal annual fraction; nonnegative unless stated. Default 0.02 (blank numeric source cells act as zero).  Source location Cashflow!J25; effective default 0.02.",
      "default": 0.02,
      "constraints": {
        "min": 0,
        "max": 1
      }
    },
    {
      "id": "expense_escalation",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cashflow'!J26"
      },
      "schema": {
        "type": "number"
      },
      "description": "Decimal annual fraction; nonnegative unless stated. Default 0.03 (blank numeric source cells act as zero).  Source location Cashflow!J26; effective default 0.03.",
      "default": 0.03,
      "constraints": {
        "min": 0,
        "max": 1
      }
    },
    {
      "id": "acquisition_credit_rate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'LIHTCs'!C31"
      },
      "schema": {
        "type": "number"
      },
      "description": "Annual decimal credit rate 0..1; nonnegative unless stated. Default 0.04 (blank numeric source cells act as zero).  Source location LIHTCs!C31; effective default 0.04.",
      "default": 0.04,
      "constraints": {
        "min": 0,
        "max": 1
      }
    },
    {
      "id": "acquisition_credit_reduction",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'LIHTCs'!C37"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD per year, positive credit reduction; nonnegative unless stated. Default 0 (blank numeric source cells act as zero).  Source location LIHTCs!C37; effective default 0.0.",
      "default": 0,
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "rehabilitation_credit_reduction",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'LIHTCs'!D37"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD per year, positive credit reduction; nonnegative unless stated. Default 0 (blank numeric source cells act as zero).  Source location LIHTCs!D37; effective default 0.0.",
      "default": 0,
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "new_construction_credit_reduction",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'LIHTCs'!E37"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD per year, positive credit reduction; nonnegative unless stated. Default 0 (blank numeric source cells act as zero).  Source location LIHTCs!E37; effective default 0.0.",
      "default": 0,
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "gross_equity",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'LIHTCs'!C48"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD, positive equity proceeds; nonnegative unless stated. Default 0 (blank numeric source cells act as zero).  Source location LIHTCs!C48; effective default 0.",
      "default": 0,
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "equity_bridge_interest",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'LIHTCs'!C49"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD, positive deduction; nonnegative unless stated. Default 0 (blank numeric source cells act as zero).  Source location LIHTCs!C49; effective default 0.",
      "default": 0,
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "equity_other_deductions",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'LIHTCs'!C52"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD, positive deduction; nonnegative unless stated. Default 0 (blank numeric source cells act as zero).  Source location LIHTCs!C52; effective default 0.",
      "default": 0,
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "annual_credit_eligible",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'LIHTCs'!C41"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD per year, eligible ceiling before a separate requested amount; calculated from publisher's workbook formulas."
    },
    {
      "id": "acquisition_credit",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'LIHTCs'!C39"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD per year; calculated from publisher's workbook formulas."
    },
    {
      "id": "rehabilitation_credit",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'LIHTCs'!D39"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD per year; calculated from publisher's workbook formulas."
    },
    {
      "id": "new_construction_credit",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'LIHTCs'!E39"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD per year; calculated from publisher's workbook formulas."
    },
    {
      "id": "applicable_fraction",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'LIHTCs'!C27"
      },
      "schema": {
        "type": "number"
      },
      "description": "Decimal fraction 0..1, rounded to four decimal places; calculated from publisher's workbook formulas."
    },
    {
      "id": "effective_gross_income",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Budget & Costs'!F111"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD per year; calculated from publisher's workbook formulas."
    },
    {
      "id": "operating_expenses",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Budget & Costs'!F178"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD per year, includes replacement reserve; calculated from publisher's workbook formulas."
    },
    {
      "id": "budget_noi",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Budget & Costs'!F180"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD per year, signed net income; calculated from publisher's workbook formulas."
    },
    {
      "id": "year_one_noi",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Cashflow'!C92"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD per year; calculated from publisher's workbook formulas."
    },
    {
      "id": "year_one_cashflow",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Cashflow'!C104"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD per year, after hard debt and mortgage insurance; calculated from publisher's workbook formulas."
    },
    {
      "id": "year_two_cashflow",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Cashflow'!D104"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD per year; calculated from publisher's workbook formulas."
    },
    {
      "id": "senior_debt_service",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Cashflow'!C94"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD per year; calculated from publisher's workbook formulas."
    },
    {
      "id": "year_one_dscr",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Cashflow'!C105"
      },
      "schema": {
        "type": "number"
      },
      "description": "Ratio; source returns zero if no hard debt; calculated from publisher's workbook formulas."
    },
    {
      "id": "net_equity",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'LIHTCs'!C54"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD, signed; calculated from publisher's workbook formulas."
    }
  ]
}
