Skip to content

Financial plan (debt / PAYGO)

The asset risk register says which pipes to renew and the capital plan optimiser says what to do to each one. The financial plan answers the question the people who hold the budget actually ask: how do we pay for it, and what does it do to rates?

Open it from the register: Financial plan (20-yr).

It follows the workflow small and mid-size utilities use (the UNC Environmental Finance Center’s Plan to Pay model, grounded in AWWA Manual M1 revenue requirements and WEF MOP 27 wastewater financing):

CIP schedule -> debt capacity -> PAYGO plug -> rate smoothing
  1. Schedule the risk-ranked programme across a 20-year horizon (worst-risk first, with dig-once bundling and inflation).
  2. Debt capacity - fund long-life renewals with debt: cheap State Revolving Fund (SRF) loans first, then market revenue bonds. Grants reduce the principal.
  3. PAYGO plug - use cash from rates for the rest (and for recurring rehab), down to the days-cash floor.
  4. Rate smoothing - solve for the least steady annual rate increase that funds the whole plan while keeping the utility healthy.

Two credit metrics are held above target in every year of the plan:

  • Debt-service coverage ratio (DSCR) = net operating revenue / annual debt service. Typically 1.2x-1.5x for revenue bonds.
  • Days cash on hand = unrestricted reserves / (annual O&M / 365). Typically 90-180 days, to absorb an emergency main break.

You do not set the mix - it falls out of two principles:

  • Intergenerational equity - long-life assets (replacements, upsizing) are debt-financed so the future users who benefit share the cost; short-life rehab (relining) is paid in cash.
  • Rate smoothing - big-capex years borrow to avoid a rate spike; quiet years pay cash and rebuild reserves.

A small, cash-tight utility funding a large plant lands near the SRF-heavy mix of the classic Plan-to-Pay example (roughly 80% debt / 20% PAYGO); a strong metro utility funds far more from PAYGO, minimising interest and protecting its credit rating - the same engine, different finances.

Because the capital programme is tied to simulated hydraulic risk, the plan can show what a spreadsheet cannot: how much risk you buy down at each rate ceiling. The affordability chart sweeps the rate increase and reports the risk retired and the high-risk pipes still unfunded - the honest trade-off for a rate case.

Under Edit utility finances, each field is one number the plan needs. Hover the label in the app for a tooltip, or use this reference:

InputWhat it is
Annual rate revenueIncome from user charges - the bills customers pay. The base the rate increase is applied to.
Annual O&MOperations & Maintenance: recurring running costs (staff, power, chemicals, repairs). Grows with inflation.
Cash reservesUnrestricted cash on hand - the emergency buffer, measured in “days cash”.
Existing accountsNumber of billed connections (optional). If entered, the plan shows the typical monthly-bill impact.
DSCR targetDebt-Service Coverage Ratio floor: net operating revenue ÷ annual debt payments. Lenders/bonds want 1.2-1.5x; the plan holds every year at or above this.
Days-cash targetMinimum days of O&M the utility could pay from reserves (90-180 typical). The plan never draws reserves below this.
InflationAssumed annual rise in construction costs, used to escalate future spend.
HorizonNumber of years the plan is spread across (usually 20).
SRF rate / termState Revolving Fund loan: a low-interest government loan. The cheapest debt, drawn first; term matched to the asset’s long life.
Bond rate / termRevenue bond: municipal debt repaid from utility revenues. Higher rate, larger and longer than SRF; drawn after the SRF.
Max rate increaseAffordability ceiling - the largest annual increase you will pass. Above it, the plan flags the shortfall instead of over-charging.
Target debt shareThe share of long-life renewals funded by borrowing vs cash. Higher = less rate pressure now; lower = less interest paid.

Export a board-ready financing PDF with the funding schedule, credit metrics and, if you enter the number of accounts, the monthly-bill impact.