formualizer

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.

17. Cash Flow and ReservesA9:I27

Saved workbook valuesInputOutput

RowABCDEFI
9Inflation RateAmountVacancy AssumptionGrowth Assumption %Gross rental income
10Gross rental income (from Unit Mix - Total Monthly Rent)$07.00%2.00%0
22NET RENTAL/OTHER INCOME$0$0.00
23TOTAL OPERATING EXPENSES$03.00%0
24NET OPERATING INCOME$0$0.00
25DEBT SERVICE$0$0
26NET CASH FLOW$0$0.00
27DEBT 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 / descriptionType / constraints / default
    units

    Whole 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_rent

    USD/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_tier

    Decimal 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

    vacancy

    Decimal 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

    management

    USD/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

    electricity

    USD/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

    maintenance

    USD/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

    taxes

    USD/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

    insurance

    USD/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_reserve

    USD/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_principal

    USD, 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_rate

    Decimal 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_years

    Years, 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_schedule

    Set 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 / descriptionType / constraints / default
    effective_income

    USD/year, residential income after vacancy.

    Type: number

    operating_expenses

    USD/year, selected operating expenses plus replacement reserve.

    Type: number

    noi

    USD/year, income minus operating expenses including reserve.

    Type: number

    total_debt_service

    USD/year, annual debt payments excluding TIF.

    Type: number

    cash_after_debt

    USD/year, NOI minus annual debt; negative is a shortfall.

    Type: number

    dscr

    Ratio, 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/mcp

    Slug: 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.