formualizer

Source subject area

Affordable housing spreadsheet calculators

Publisher spreadsheets in the catalog's Real estate subject area. Read each workbook's calculation checks, limitations and publisher download.

7 editions

Real estate

U.S. Department of Housing and Urban Development (HUD — Multifamily CNA e-Tool)

HUD CNA Reserve for Replacement Financial Factors

Test reserve deposits and mortgage debt service against the pinned HUD CNA example, with annual reserve balances and minimum-balance diagnostics.

Edition v30.332 inputs · 12 outputsIndependent scenario check

North Dakota Housing Finance Agency (NDHFA)

NDHFA Multifamily Exhibit A Operating Cashflow

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

Edition 20269 inputs · 5 outputsIndependent scenario check

Ohio Housing Finance Agency (OHFA)

OHFA 2023 4% LIHTC Underwriting Model

Ohio Housing Finance Agency 2023 4% LIHTC eligible credit sizing, operating budget and cashflow sensitivity from the AHFA source application.

Edition 202339 inputs · 14 outputsIndependent scenario check

Ohio Housing Finance Agency (OHFA)

OHFA 2023 9% LIHTC Underwriting Model

Ohio Housing Finance Agency 2023 9% LIHTC eligible credit sizing, operating budget and cashflow sensitivity from the AHFA source application.

Edition 202341 inputs · 14 outputsIndependent scenario check

Pennsylvania Housing Finance Agency (PHFA)

PHFA 2025 Core Application Operating Underwriting

Calculate net operating income, debt service coverage and cash flow in the PHFA multifamily operating budget and its first two pro forma years.

Edition 202555 inputs · 13 outputsIndependent scenario check

Rhode Island Housing (RIHousing)

RIHousing ELI One-Bedroom Subsidy Projection

Project the first-year, five-year and fifteen-year subsidy deficits for one-bedroom units with and without CES referrals using entered rent limits.

Edition 20266 inputs · 4 outputsIndependent scenario check

Wisconsin Housing and Economic Development Authority (WHEDA)

WHEDA 2027 Project Concept Multifamily Operating Cashflow

First-year residential NOI, debt coverage and cash after debt for one 60%-CMI rent cohort with selected annual expenses.

Edition 202714 inputs · 6 outputsIndependent scenario check

Scope and limitations

Catalog calculations, not certification.

Looking for another spreadsheet? Request a workbook.