# Public Housing Authority Operating Model Model public housing operations with rent roll by bedroom count, operating expense allocation, and capital reserve funding. Handles multiple subsidy sources and distinguishes public and subsidy accounting without blending revenue streams. - Canonical: https://finamodel.com/templates/public-housing-model - Excel download: https://finamodel.com/templates/public-housing.xlsx - Category: Public Finance - Model type: Sector planning - Difficulty: Intermediate - Audiences: Public sector, Developers & sponsors, Housing authorities, Municipal officials, Nonprofit operators, Consultants - Tags: public-housing, rent-roll, operating-reserve, capital-planning, affordability ## Overview Model affordable/public housing operations with rent caps tied to area median income (AMI), government subsidy income, and capital reserve funding requirements. This template projects regulated rental income (capped at ~30% of target AMI band), government housing voucher subsidies (tenants pay their share, government pays the gap), and ancillary income from parking/services. Revenue is driven by unit count, occupancy rate (typically 95–98% for subsidized housing), and rent escalation limited to AMI growth (1–3% annually, not market rates). The workbook contains a revenue sheet showing the rent-roll by unit type and occupancy dynamics, operating expenses as a % of revenue (property management, utilities, repairs, insurance, compliance), a dedicated capital reserves sheet tracking replacement reserve deposits and drawals for capital repairs, a debt schedule with interest-only and amortising periods, and a three-statement model. Key covenants include DSCR (typically 1.15–1.20x minimum for subsidized housing), maximum LTV, and mandatory reserve funding levels. The model captures the lease-up period post-development (typically 6–12 months to stabilised occupancy) and handles both senior debt and potential subordinate soft debt from municipalities or grants. Target users are mission-driven developers, public housing authorities, institutional real estate investors with ESG mandates, and lenders to affordable housing projects valued at $20M to $500M+. ## What's included - Housing unit inventory by bedroom type and target rent level - Tenant income and rent revenue from multiple subsidy sources - Maintenance, utilities, and property management costs - Debt service on original construction debt - Capital replacement reserve funding and lifecycle planning - Housing unit inventory by bedroom and target rent level - Operating surplus and reserve adequacy metrics ## How the Public Housing Model Captures Regulated Rent, Subsidy and Debt The public housing model supports development, acquisition and operation decisions under rent caps and subsidy rules. It links unit-mix rents, utility allowances, voucher income, operating cost escalation and reserve funding to NOI, CFADS and loan sizing. ### Documented operating drivers The template organis es around regulated rent, subsidy and cost assumptions. Revenue starts from a three-type unit-mix table by AMI band rather than one blended rent, so each unit type keeps its own regulated rent. - Gross potential rent is annualised and grown with AMI-linked rent growth. A utility allowance is deducted because regulated rents are net of utilities. - Subsidy income scales with voucher tenants and the payment standard less tenant contribution, while ancillary income scales with occupied units. On the cost side, property management, payroll, utilities, repairs, insurance, compliance and property tax are detailed, with annual opex escalation and replacement reserves per unit. These drivers make the model responsive to both regulatory and operating changes without blending revenue streams. ### Calculation flow through the model The model follows a clear sequence from assumptions to returns. Gross potential rent feeds net potential rent after utility allowances. - Occupancy is set by a lease-up assumption in Year 1 and a stabilised rate thereafter, producing vacancy loss and net rental income. Net rental income, subsidy income and ancillary income combine into effective gross income. - Operating expenses are deducted to reach net operating income, and a replacement reserve deposit is subtracted to arrive at cash flow available for debt service. Loan sizing takes the binding minimum of an LTV loan and a DSCR loan, where DSCR uses stabilised CFADS and nets soft-debt interest. Senior debt amortises after an interest-only period, while soft debt remains interest-only until disposition. Cash flow, tax and terminal value then drive levered returns. ### Key outputs and checks The template reports effective gross income, NOI, CFADS, DSCR and LTV by period, then builds levered cash flow, net sale proceeds, equity IRR and equity multiple pre-tax and after-tax. A checks area monitors DSCR floor, sources equal uses, vacancy floor, reserve balance, cash non-negative, operating expenses per unit, LTV cap and NOI margin. - These outputs are useful for testing whether a project remains viable when regulated rent growth is slower than operating cost inflation, or when subsidy assumptions change. Because subsidy and ancillary income scale with occupied units, the model shows how lease-up timing affects early cash flow and reserve needs. - The checks are tied to input thresholds rather than fixed inline values, so the review stays consistent. ### Practical use and limitations This template is suited to evaluating a single public housing project under rent caps, subsidy structures and lender covenants. It helps compare development versus acquisition scenarios by changing unit mix, regulated rents, subsidy share and financing terms. - The supporting sheets separate assumptions, revenue, operating expenses, capital reserves, debt schedule and cash flow, so each part of the underwriting can be inspected. The public download is a values-only preview; it shows the model's logic and layout but does not contain live formulas or automatically recalculate. - The design assumes no circular references because debt is sized upfront from development cost, which keeps the calculation flow predictable but also means later refinements must be made in the assumptions. ## Rent roll and income scheduling Track tenant income levels, utility allowances, and rent contributions to forecast shelter rent and operating subsidy income by unit type. ## Maintenance and capital reserve planning Model routine maintenance, capital improvement cycles, and reserve adequacy to address deferred maintenance and extend asset life. ## Multi-source revenue and operating surplus Handle public housing operating subsidies, tenant payments, and other revenue to show net operational cash flow and reserve adequacy. ## Rent roll and income scheduling Track tenant income levels, utility allowances, and rent contributions to forecast shelter rent and operating subsidy income by unit type. ## Maintenance and capital reserve planning Model routine maintenance, capital improvement cycles, and reserve adequacy to address deferred maintenance and extend asset life. ## Multi-source revenue and operating surplus Handle public housing operating subsidies, tenant payments, and other revenue to show net operational cash flow and reserve adequacy. ## Features - **Rent roll and income scheduling:** Tracks tenant income levels, utility allowances, and rent contributions to forecast shelter rent and subsidy income. - **Maintenance and capital planning:** Models routine maintenance, capital improvement cycles, and reserve adequacy to address deferred maintenance. - **Multisource revenue modeling:** Handles public housing operating subsidies, tenant payments, and other revenue to show net operational cash flow. ## Use cases - **Asset management and capital planning:** Plan major repairs, replacements, and modernization spending to extend asset life and improve resident outcomes. - **Operating budget and rent policy:** Forecast operating expenses to set annual budgets and determine rent contributions that preserve affordability. - **Financing and grant applications:** Support funding applications with credible operating projections and capital needs assessments. ## Frequently asked questions ### What is a public housing financial model? A model that forecasts rent revenue by unit, operating subsidies, maintenance costs, capital reserves, and debt service for a public housing authority portfolio. ### How is public housing tenant rent calculated? Tenants typically pay 30% of household income or the basic rent, whichever is higher, with the housing authority covering the difference through operating subsidies. ### What is a capital replacement reserve? A reserve funded annually to cover major repairs and replacements, ensuring long-term capital sustainability without requiring sudden rent increases or emergency borrowing. ### Can I model mixed-income or mixed-finance portfolios? Yes. The model supports blended portfolios with public housing, project-based rental assistance, and mixed-income units in the same operating framework. ### How do I support a financing or grant application? The model produces credible operating projections and capital needs assessments that support HUD filings, grant applications, and lender underwriting requirements. ## Related templates - [Multifamily Residential Model](https://finamodel.com/templates/multi-family-model) - [Real Estate Development Pro Forma Model](https://finamodel.com/templates/real-estate-model) - [Student Housing Development Model](https://finamodel.com/templates/student-housing-model)