Public Housing Authority Operating Model

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.

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.

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.

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.