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.
Saved workbook valuesInputOutput
| Row | B | C | D | E | F | G | H |
|---|---|---|---|---|---|---|---|
| 6 | # BR | Rent Restriction | # Units | PBV | Monthly Rent | Annual Income | |
| 7 | $- | $- | |||||
| 57 | $- | ||||||
| 65 | Management Fees | 0.00% | $- | ||||
| 74 | Electricity | $- | |||||
| 85 | Repairs | $- | |||||
| 96 | Real Estate Taxes | $- | |||||
| 99 | Property 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 / description | Type / constraints / default |
|---|---|
unitsCount, 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_rentUSD/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 |
managementUSD/year, positive management fees deducted from income. Omitted expenses and other cohorts retain publisher zero/blank defaults. | Type: number Constraints: min: 0 Default: 0 |
electricityUSD/year, positive electricity expense deducted from income. Omitted expenses and other cohorts retain publisher zero/blank defaults. | Type: number Constraints: min: 0 Default: 0 |
repairsUSD/year, positive repairs expense deducted from income. Omitted expenses and other cohorts retain publisher zero/blank defaults. | Type: number Constraints: min: 0 Default: 0 |
taxesUSD/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 |
insuranceUSD/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_unitUSD/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_serviceUSD/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 / description | Type / constraints / default |
|---|---|
effective_incomeUSD/year, income after publisher vacancy deduction. | Type: number |
operating_expensesUSD/year, expenses including replacement reserve contributions. | Type: number |
noiUSD/year, income less expenses including reserves. | Type: number |
total_debt_serviceUSD/year, total entered annual debt payments. | Type: number |
cash_after_debtUSD/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/mcpSlug: 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.