formualizer

Excel workbook · Catalog edition 2026

NDHFA Multifamily Exhibit A Operating Cashflow

North Dakota Housing Finance Agency (NDHFA)

Calculate first-year effective rental income, operating expenses, net operating income and cash after debt service for a single rent cohort.

Inputs
9
Outputs
5
File size
448 KB
Verification
Independent scenario check

Try it

Try it loads a copy of this file from formualizer.com.

Operating BudgetB6:H107

Saved workbook valuesInputOutput

RowBCDEFGH
6# BRRent Restriction# UnitsPBVMonthly RentAnnual Income
7$-$-
57$-
65Management Fees0.00%$-
74Electricity $-
85Repairs$-
96Real Estate Taxes$-
99Property Hazard and Liability Insurance$-

What was checked

Changed-input scenarios match an independent calculation.

Scope and limitations

Catalog calculations, not certification.

Filename and workbook modified date; not independently confirmed publication date.

What first-year NOI and cash after debt service does a single rent cohort support? Selected expense categories only: all omitted expenses and other cohorts retain zero/blank defaults. Not a complete application or compliance analysis. Annual debt service is entered directly. Publisher vacancy is max(7%,1/units), with 7% fallback at zero units; reserves reduce NOI. No NDHFA endorsement.

    What it computes

    Ports for the compact flow: quick_operating_cashflow. The full port contract includes all 14 ports.

    Inputs (9)
    Port / descriptionType / constraints / default
    units

    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.

    Type: integer

    Constraints: min: 0

    Default: 0

    monthly_rent

    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.

    Type: number

    Constraints: min: 0

    Default: 0

    management

    USD/year, positive management fees deducted from income. Omitted expenses and other cohorts retain publisher zero/blank defaults.

    Type: number

    Constraints: min: 0

    Default: 0

    electricity

    USD/year, positive electricity expense deducted from income. Omitted expenses and other cohorts retain publisher zero/blank defaults.

    Type: number

    Constraints: min: 0

    Default: 0

    repairs

    USD/year, positive repairs expense deducted from income. Omitted expenses and other cohorts retain publisher zero/blank defaults.

    Type: number

    Constraints: min: 0

    Default: 0

    taxes

    USD/year, positive real estate taxes deducted from income. Omitted expenses and other cohorts retain publisher zero/blank defaults.

    Type: number

    Constraints: min: 0

    Default: 0

    insurance

    USD/year, positive property hazard and liability insurance deducted from income. Omitted expenses and other cohorts retain publisher zero/blank defaults.

    Type: number

    Constraints: min: 0

    Default: 0

    reserve_per_unit

    USD/unit/year, positive replacement reserve contribution; publisher includes reserve in NOI deductions. Omitted expenses and other cohorts retain publisher zero/blank defaults.

    Type: number

    Constraints: min: 0

    Default: 0

    annual_debt_service

    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.

    Type: number

    Constraints: min: 0

    Default: 0

    Outputs (5)
    Port / descriptionType / constraints / default
    effective_income

    USD/year, income after publisher vacancy deduction.

    Type: number

    operating_expenses

    USD/year, expenses including replacement reserve contributions.

    Type: number

    noi

    USD/year, income less expenses including reserves.

    Type: number

    total_debt_service

    USD/year, total entered annual debt payments.

    Type: number

    cash_after_debt

    USD/year, NOI less annual debt payments; negative means deficit.

    Type: number

    Questions this workbook answers

    • What NOI does my North Dakota multifamily operating budget support?
    • How much cash remains after annual debt service?
    • How does the NDHFA vacancy floor affect a small property?

    For agents

    Connect an MCP client to the catalog endpoint:

    https://catalog.formualizer.com/v1/mcp

    Slug: nd-multifamily-exhibit-a · Edition: 2026

    search_workbooks
    Optional arguments: query (string), theme (string), tag (string).
    inspect_workbook
    Required: slug (string). Optional: edition (string), flow (string).
    evaluate_workbook
    Required: slug (string), inputs (object). Optional: edition (string), flow (string), cellOverrides (object), selectCells (array of strings), trace (boolean).
    {
      "name": "evaluate_workbook",
      "arguments": {
        "slug": "nd-multifamily-exhibit-a",
        "edition": "2026",
        "flow": "quick_operating_cashflow",
        "inputs": {
          "units": 60,
          "monthly_rent": 1000,
          "management": 36000,
          "electricity": 30000,
          "repairs": 48000,
          "taxes": 42000,
          "insurance": 24000,
          "reserve_per_unit": 300,
          "annual_debt_service": 240000
        }
      }
    }

    cellOverrides sets individual cells. selectCells reads at most 256 cells per request. trace requests formula lineage.

    Flows

    quick_operating_cashflow

    Single-cohort operating cashflow

    9 input ports · 5 output ports. Full membership in the port contract.

    REST example

    Bundle scenario: quick_operating_cashflow_stabilized · Flow: quick_operating_cashflow

    curl 'https://catalog.formualizer.com/v1/models/nd-multifamily-exhibit-a/2026/evaluate?flow=quick_operating_cashflow' \
      -H 'Content-Type: application/json' \
      --data '{"inputs":{"units":60,"monthly_rent":1000,"management":36000,"electricity":30000,"repairs":48000,"taxes":42000,"insurance":24000,"reserve_per_unit":300,"annual_debt_service":240000}}'

    Expected response

    Expected values from the bundle, subject to the check level above.

    {
      "outputs": {
        "effective_income": 669600,
        "operating_expenses": 198000,
        "noi": 471600,
        "total_debt_service": 240000,
        "cash_after_debt": 231600
      }
    }

    Looking for another spreadsheet? Request a workbook.