Public Housing Authority Operating ModelFree Financial Model Download
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.
Free download. No sign-up required.
About this model
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+.
Recolor to your brand.
Formatted to IB standards.
Named theme colors repaint the whole workbook in one click, on top of an investment-banking structure with blue inputs, black formulas, and green cross-sheet links.
- Brand-ready
- Institutional grade
- Fully auditable
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
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.
Frequently asked
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.
Alex Tapio
Founder of Finamodel • Professional Financial Modeller • Ex-Deloitte
Related templates
Multifamily Residential Model
Investment model for multifamily apartment communities with unit economics, rents, occupancy, and NOI.
Real Estate Development Pro Forma Model
Land cost, construction budget, lease assumptions, and project IRR for commercial and residential development.
Student Housing Development Model
Pro forma development model for student housing with lease-up assumptions, occupancy, rental rates, and development cash flow.
Pension Fund Asset Allocation Model
Liability-driven investment strategy, asset allocation, and funding ratio analysis for pension plan portfolios.