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).
The method: EFC “Plan to Pay”
Section titled “The method: EFC “Plan to Pay””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- Schedule the risk-ranked programme across a 20-year horizon (worst-risk first, with dig-once bundling and inflation).
- Debt capacity - fund long-life renewals with debt: cheap State Revolving Fund (SRF) loans first, then market revenue bonds. Grants reduce the principal.
- PAYGO plug - use cash from rates for the rest (and for recurring rehab), down to the days-cash floor.
- Rate smoothing - solve for the least steady annual rate increase that funds the whole plan while keeping the utility healthy.
Financial-health targets
Section titled “Financial-health targets”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.
The debt-to-PAYGO ratio is an output
Section titled “The debt-to-PAYGO ratio is an output”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.
Affordability vs risk
Section titled “Affordability vs risk”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.
What each input means
Section titled “What each input means”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:
| Input | What it is |
|---|---|
| Annual rate revenue | Income from user charges - the bills customers pay. The base the rate increase is applied to. |
| Annual O&M | Operations & Maintenance: recurring running costs (staff, power, chemicals, repairs). Grows with inflation. |
| Cash reserves | Unrestricted cash on hand - the emergency buffer, measured in “days cash”. |
| Existing accounts | Number of billed connections (optional). If entered, the plan shows the typical monthly-bill impact. |
| DSCR target | Debt-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 target | Minimum days of O&M the utility could pay from reserves (90-180 typical). The plan never draws reserves below this. |
| Inflation | Assumed annual rise in construction costs, used to escalate future spend. |
| Horizon | Number of years the plan is spread across (usually 20). |
| SRF rate / term | State Revolving Fund loan: a low-interest government loan. The cheapest debt, drawn first; term matched to the asset’s long life. |
| Bond rate / term | Revenue bond: municipal debt repaid from utility revenues. Higher rate, larger and longer than SRF; drawn after the SRF. |
| Max rate increase | Affordability ceiling - the largest annual increase you will pass. Above it, the plan flags the shortfall instead of over-charging. |
| Target debt share | The 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.