Articles

How far can water and sewer revenue fall before the rate covenant is reached?

The covenant tests net revenues, not revenues. Because operating costs do not fall with sales, each 1 per cent drop in revenue removes 2.27% of net revenues.

The system earns net revenues of $82.0 million against senior debt service of $47 million, a coverage of 1.74x. The rate covenant requires 1.20x, or $56.4 million of net revenues, so revenues can fall by 13.76% before it is reached. The 8 per cent stress case leaves coverage at 1.43x, comfortably above the covenant; the same decline would reach 1.00x only at 18.82%.

A utility revenue bond is repaid from the system’s net revenues, and the bond documents usually promise to set rates so that net revenues cover senior debt service by a stated multiple. The question for the analyst is how much room that promise leaves. This article answers it for the water and sewer system in the book’s city case, using the inputs on the Inputs sheet.

The assumptions

ItemValue
Operating revenues, fiscal 2025$186.0 million
Operation and maintenance expenses$104.0 million
Senior annual debt service$47.0 million
Unrestricted cash$75.0 million
Rate covenant (net revenues to senior debt service)1.20x
Revenue decline in the stress case8%
Net revenues = operating revenues − operation and maintenance expenses. Depreciation and interest are not deducted: debt service is the next claim on net revenues.

Step 1: net revenues and coverage

Net revenues are what is left after the cost of running the system, and coverage is that amount divided by debt service:

Coverage = (revenues − O&M) ÷ senior debt service. In Excel: =(B2-B3)/B4, with revenues in B2, O&M in B3 and debt service in B4.

186 − 104 = $82.0 million, and 82 ÷ 47 = 1.74x. Unrestricted cash of $75.0 million is 263.2 days of operating expenses (75 ÷ 104 × 365).

Step 2: the stress case

The stress case takes 8 per cent off revenues and leaves costs alone:

Stressed net revenues = revenues × (1 − decline) − O&M. In Excel: =B2*(1-B5)-B3.

186 × 0.92 = 171.12, less 104 gives $67.12 million. Coverage falls from 1.74x to 67.12 ÷ 47 = 1.43x. An 8 per cent fall in revenue is an 18.1% fall in net revenues, because the 104 of costs does not move.

Step 3: the decline that reaches the covenant

Turn the question round. The covenant needs net revenues of 1.20 × 47 = $56.4 million. Whatever net revenues exceed that is the room for a revenue decline:

Break-even decline = (net revenues − covenant × debt service) ÷ revenues. In Excel: =(B6-B7*B4)/B2, with net revenues in B6 and the covenant in B7.

(82 − 56.4) ÷ 186 = 25.6 ÷ 186 = 13.76%. Against 1.00x the room is (82 − 47) ÷ 186 = 18.82%.

Revenue declineRevenues ($m)Net revenues ($m)CoverageOver the 1.20x covenant
0%186.0082.001.74x0.54x
4%178.5674.561.59x0.39x
8%171.1267.121.43x0.23x
12%163.6859.681.27x0.07x
13.76%160.4056.401.20x0.00x
16%156.2452.241.11x-0.09x
20%148.8044.800.95x-0.25x
Operating costs held at $104 million. The covenant is reached at 13.76% and coverage is below 1.00x from 18.82%.

Step 4: why the gearing matters

Net revenues are 44.1% of revenues, so each 1 per cent of revenue ($1.86 million) is 1.86 ÷ 82 = 2.27% of net revenues, and 0.040x of coverage. The covenant ceiling is also a cost ceiling: with revenues unchanged, operating costs could rise by 25.6 million, or 24.6%, before 1.20x is reached.

What if revenue fell 16 per cent?

The common mistakes

Takeaway

The system has 1.74x of coverage and a 13.76% revenue cushion against a 1.20x covenant. Compute it in three lines: net revenues, the net revenues the covenant needs, and the difference as a share of revenues. Then check the gearing, because a utility with high fixed costs loses net revenues about 2.3 times faster than it loses revenue. For the general-obligation side of the same city, see The Municipal Bond Analyst.

Reproducing it in the workbook

The inputs are in Municipal_Bond_Analyst_Model.xlsx: rows 38 to 43 of the Inputs sheet hold revenues, costs, debt service, cash, the 1.20x covenant and the 8 per cent stress. The Water and Sewer sheet computes net revenues, coverage, days cash on hand, stressed coverage, the net revenues the covenant needs and the revenue decline that reaches it. The table of declines and the 16 per cent case above are not in the workbook; they use the same formulas with a different decline.

Questions readers ask

How do you calculate debt service coverage for a water and sewer system?

Net revenues divided by senior debt service, where net revenues are operating revenues less operation and maintenance expenses. Here 186 less 104 is 82, and 82 divided by 47 is 1.74x.

How far can revenue fall before a 1.20x rate covenant is reached?

13.76% in this case: net revenues of 82 less the 56.4 the covenant needs, divided by revenues of 186.

Why does a small fall in revenue cut coverage so much?

Operating costs do not fall with revenue. Each 1 per cent of revenue is 2.27% of net revenues here, so an 8 per cent fall removes 18.1% of them.

The workbooks behind this article

Every figure above is built from the inputs in the free companion files for The Municipal Bond Analyst, which also cover the city’s fund balance, debt ratios and pensions, the pricing of a 20-maturity issue and the tax-equivalent yield. No account and no email address.

Open the companion files →

Not on Amazon: 19 paperbacks by Julian R. Sterling on energy, infrastructure and land, printed on demand and shipped worldwide. Browse the bookshop →

Also on this site

Reading guide: credit, private credit and distressed debt → · All 1908 articles →