Excel workbook · Catalog edition 2027
WHEDA 2027 Project Concept Multifamily Operating Cashflow
Wisconsin Housing and Economic Development Authority (WHEDA)
First-year residential NOI, debt coverage and cash after debt for one 60%-CMI rent cohort with selected annual expenses.
- Inputs
- 14
- Outputs
- 6
- File size
- 2557 KB
- Verification
- Independent scenario check
Try it
Try it loads a copy of this file from formualizer.com.
Saved workbook valuesInputOutput
| Row | A | B | C | D | E | F | I |
|---|---|---|---|---|---|---|---|
| 9 | Inflation Rate | Amount | Vacancy Assumption | Growth Assumption % | Gross rental income | ||
| 10 | Gross rental income (from Unit Mix - Total Monthly Rent) | $0 | 7.00% | 2.00% | 0 | ||
| 22 | NET RENTAL/OTHER INCOME | $0 | $0.00 | ||||
| 23 | TOTAL OPERATING EXPENSES | $0 | 3.00% | 0 | |||
| 24 | NET OPERATING INCOME | $0 | $0.00 | ||||
| 25 | DEBT SERVICE | $0 | $0 | ||||
| 26 | NET CASH FLOW | $0 | $0.00 | ||||
| 27 | DEBT COVERAGE RATIO (Minimum of 1.15) | 0.000 | $0.00 |
What was checked
Changed-input scenarios match an independent calculation.
Scope and limitations
Catalog calculations, not certification.
Internal modified date, not a confirmed publication date. Source label: 2027 Project Concept Multifamily Application.
Set income_tier=0.6 to route rents into the publisher summary. All omitted expenses, other income and cohorts remain blank/zero. First-loan debt service uses monthly level payments and requires payment_schedule=Must Pay/Hard Debt; reserves reduce NOI. This bounded calculation uses the 2027 Project Concept Multifamily Application; it does not validate rents, complete underwriting, credit eligibility or approval. No WHEDA endorsement.
What it computes
Ports for the compact flow: quick_operating_cashflow. The full port contract includes all 20 ports.
Inputs (14)
| Port / description | Type / constraints / default |
|---|---|
unitsWhole units in a single cohort; all other cohorts remain empty. All omitted costs, other income and cohorts retain publisher blank/zero defaults. | Type: integer Constraints: min: 0 Default: 0 |
monthly_rentUSD/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. | Type: number Constraints: min: 0 Default: 0 |
income_tierDecimal 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. | Type: number Constraints: one of: 0, 0.6 Default: 0 |
vacancyDecimal fraction 0..1 of gross residential rent deducted for vacancy. All omitted costs, other income and cohorts retain publisher blank/zero defaults. | Type: number Constraints: min: 0; max: 1 Default: 0.07 |
managementUSD/year, positive residential management expense deducted from income. All omitted costs, other income and cohorts retain publisher blank/zero defaults. | Type: number Constraints: min: 0 Default: 0 |
electricityUSD/year, positive electricity expense deducted from income. All omitted costs, other income and cohorts retain publisher blank/zero defaults. | Type: number Constraints: min: 0 Default: 0 |
maintenanceUSD/year, positive maintenance contract expense deducted from income. All omitted costs, other income and cohorts retain publisher blank/zero defaults. | Type: number Constraints: min: 0 Default: 0 |
taxesUSD/year, positive real estate and personal property taxes deducted from income. All omitted costs, other income and cohorts retain publisher blank/zero defaults. | Type: number Constraints: min: 0 Default: 0 |
insuranceUSD/year, positive property/liability insurance deducted from income. All omitted costs, other income and cohorts retain publisher blank/zero defaults. | Type: number Constraints: min: 0 Default: 0 |
annual_reserveUSD/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. | Type: number Constraints: min: 0 Default: 0 |
loan_principalUSD, positive first permanent loan principal. Other loans remain zero. All omitted costs, other income and cohorts retain publisher blank/zero defaults. | Type: number Constraints: min: 0 Default: 0 |
loan_rateDecimal fraction annual interest rate; monthly level payments are assumed. All omitted costs, other income and cohorts retain publisher blank/zero defaults. | Type: number Constraints: min: 0; max: 1 Default: 0 |
amortization_yearsYears, monthly amortization period; zero retains blank-baseline debt service. All omitted costs, other income and cohorts retain publisher blank/zero defaults. | Type: number Constraints: min: 0; max: 50 Default: 0 |
payment_scheduleSet 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. | Type: string Constraints: one of: , Must Pay/Hard Debt Default: blank string |
Outputs (6)
| Port / description | Type / constraints / default |
|---|---|
effective_incomeUSD/year, residential income after vacancy. | Type: number |
operating_expensesUSD/year, selected operating expenses plus replacement reserve. | Type: number |
noiUSD/year, income minus operating expenses including reserve. | Type: number |
total_debt_serviceUSD/year, annual debt payments excluding TIF. | Type: number |
cash_after_debtUSD/year, NOI minus annual debt; negative is a shortfall. | Type: number |
dscrRatio, NOI divided by debt rounded to three decimals; publisher returns zero at zero debt. | Type: number |
Questions this workbook answers
- What first-year NOI and debt coverage does a Wisconsin rent cohort support?
- Stress selected expenses and vacancy in the WHEDA project concept workbook
- How much cash remains after annual debt service?
For agents
Connect an MCP client to the catalog endpoint:
https://catalog.formualizer.com/v1/mcpSlug: wi-multifamily-application · Edition: 2027
- 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": "wi-multifamily-application",
"edition": "2027",
"flow": "quick_operating_cashflow",
"inputs": {
"units": 60,
"monthly_rent": 1000,
"income_tier": 0.6,
"vacancy": 0.07,
"management": 36000,
"electricity": 30000,
"maintenance": 48000,
"taxes": 42000,
"insurance": 24000,
"annual_reserve": 18000,
"loan_principal": 3000000,
"loan_rate": 0.06,
"amortization_years": 30,
"payment_schedule": "Must Pay/Hard Debt"
}
}
}cellOverrides sets individual cells. selectCells reads at most 256 cells per request. trace requests formula lineage.
Flows
quick_operating_cashflow
Single-cohort first-year operating cashflow
14 input ports · 6 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/wi-multifamily-application/2027/evaluate?flow=quick_operating_cashflow' \
-H 'Content-Type: application/json' \
--data '{"inputs":{"units":60,"monthly_rent":1000,"income_tier":0.6,"vacancy":0.07,"management":36000,"electricity":30000,"maintenance":48000,"taxes":42000,"insurance":24000,"annual_reserve":18000,"loan_principal":3000000,"loan_rate":0.06,"amortization_years":30,"payment_schedule":"Must Pay/Hard Debt"}}'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": 215838.18905499252,
"cash_after_debt": 255761.81094500748,
"dscr": 2.185
}
}Looking for another spreadsheet? Request a workbook.