{
  "spec": "fio",
  "spec_version": "0.3.0",
  "capabilities": {
    "profile": "full-v0"
  },
  "manifest": {
    "id": "ohfa-lihtc-9pct-2023",
    "name": "OHFA 2023 9% LIHTC Underwriting Model",
    "workbook": {
      "uri": "ohfa-lihtc-9pct-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'!C244"
      },
      "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!C244; effective default 0.0.",
      "default": 0,
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "market_floor_area",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Project Details'!C243"
      },
      "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!C243; effective default 0.0.",
      "default": 0,
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "acquisition_basis",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Budget & Costs'!F256"
      },
      "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!F256; effective default 0.",
      "default": 0,
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "rehabilitation_basis",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Budget & Costs'!G282"
      },
      "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!G282; effective default 0.",
      "default": 0,
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "new_construction_basis",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Budget & Costs'!H281"
      },
      "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!H281; effective default 0.",
      "default": 0,
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "rehab_qct_fraction",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Housing Credits'!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 Housing Credits!D13; effective default 0.0.",
      "default": 0,
      "constraints": {
        "min": 0,
        "max": 1
      }
    },
    {
      "id": "new_qct_fraction",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Housing Credits'!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 Housing Credits!E13; effective default 0.0.",
      "default": 0,
      "constraints": {
        "min": 0,
        "max": 1
      }
    },
    {
      "id": "rehab_credit_rate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Housing Credits'!D31"
      },
      "schema": {
        "type": "number"
      },
      "description": "Annual decimal credit rate 0..1; nonnegative unless stated. Default 0.09 (blank numeric source cells act as zero).  Source location Housing Credits!D31; effective default 0.09.",
      "default": 0.09,
      "constraints": {
        "min": 0,
        "max": 1
      }
    },
    {
      "id": "new_credit_rate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Housing Credits'!E31"
      },
      "schema": {
        "type": "number"
      },
      "description": "Annual decimal credit rate 0..1; nonnegative unless stated. Default 0.09 (blank numeric source cells act as zero).  Source location Housing Credits!E31; effective default 0.09.",
      "default": 0.09,
      "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 blank. Source location Project Details!C20; effective default .",
      "default": "",
      "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 (blank numeric source cells act as zero).  Source location Budget & Costs!E83; effective default 0.",
      "default": 0,
      "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": "mbe_wbe_developer",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Development Team'!D70"
      },
      "schema": {
        "type": "string"
      },
      "description": "Text enum Yes / No; Yes activates a 15% rehabilitation/new-construction basis boost when program is 9% Competitive. Default Yes. Source location Development Team!D70; effective default Yes.",
      "default": "Yes",
      "constraints": {
        "enum": [
          "Yes",
          "No"
        ]
      }
    },
    {
      "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.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'!G243"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD, positive principal; nonnegative unless stated. Default 0 (blank numeric source cells act as zero).  Source location Budget & Costs!G243; effective default 0.",
      "default": 0,
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "senior_loan_rate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Budget & Costs'!H243"
      },
      "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!H243; effective default 0.06.",
      "default": 0.06,
      "constraints": {
        "min": 0,
        "max": 1
      }
    },
    {
      "id": "senior_loan_amortization",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Budget & Costs'!K243"
      },
      "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!K243; effective default 0.",
      "default": 0,
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "income_escalation",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cashflow'!J29"
      },
      "schema": {
        "type": "number"
      },
      "description": "Decimal annual fraction; nonnegative unless stated. Default 0.02 (blank numeric source cells act as zero).  Source location Cashflow!J29; effective default 0.02.",
      "default": 0.02,
      "constraints": {
        "min": 0,
        "max": 1
      }
    },
    {
      "id": "expense_escalation",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cashflow'!J30"
      },
      "schema": {
        "type": "number"
      },
      "description": "Decimal annual fraction; nonnegative unless stated. Default 0.03 (blank numeric source cells act as zero).  Source location Cashflow!J30; effective default 0.03.",
      "default": 0.03,
      "constraints": {
        "min": 0,
        "max": 1
      }
    },
    {
      "id": "acquisition_credit_rate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Housing Credits'!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 Housing Credits!C31; effective default 0.04.",
      "default": 0.04,
      "constraints": {
        "min": 0,
        "max": 1
      }
    },
    {
      "id": "acquisition_credit_reduction",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Housing Credits'!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 Housing Credits!C37; effective default 0.0.",
      "default": 0,
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "rehabilitation_credit_reduction",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Housing Credits'!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 Housing Credits!D37; effective default 0.0.",
      "default": 0,
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "new_construction_credit_reduction",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Housing Credits'!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 Housing Credits!E37; effective default 0.0.",
      "default": 0,
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "gross_equity",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Housing Credits'!C48"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD, positive equity proceeds; nonnegative unless stated. Default 0 (blank numeric source cells act as zero).  Source location Housing Credits!C48; effective default 0.",
      "default": 0,
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "equity_bridge_interest",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Housing Credits'!C49"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD, positive deduction; nonnegative unless stated. Default 0 (blank numeric source cells act as zero).  Source location Housing Credits!C49; effective default 0.",
      "default": 0,
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "equity_other_deductions",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Housing Credits'!C52"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD, positive deduction; nonnegative unless stated. Default 0 (blank numeric source cells act as zero).  Source location Housing Credits!C52; effective default 0.",
      "default": 0,
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "annual_credit_requested",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Housing Credits'!C43"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD per year, request is separate from eligible ceiling; nonnegative unless stated. Default 0 (blank numeric source cells act as zero).  Source location Housing Credits!C43; effective default 0.0.",
      "default": 0,
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "annual_credit_eligible",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Housing Credits'!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": "'Housing Credits'!C39"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD per year; calculated from publisher's workbook formulas."
    },
    {
      "id": "rehabilitation_credit",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Housing Credits'!D39"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD per year; calculated from publisher's workbook formulas."
    },
    {
      "id": "new_construction_credit",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Housing Credits'!E39"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD per year; calculated from publisher's workbook formulas."
    },
    {
      "id": "applicable_fraction",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Housing Credits'!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'!C94"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD per year; calculated from publisher's workbook formulas."
    },
    {
      "id": "year_one_cashflow",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Cashflow'!C108"
      },
      "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'!D108"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD per year; calculated from publisher's workbook formulas."
    },
    {
      "id": "senior_debt_service",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Cashflow'!C96"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD per year; calculated from publisher's workbook formulas."
    },
    {
      "id": "year_one_dscr",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Cashflow'!C109"
      },
      "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": "'Housing Credits'!C54"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD, signed; calculated from publisher's workbook formulas."
    }
  ]
}
