The project decision

Cedar Hollow has one piece of work to pay for and three ways to pay for it.

Cedar Hollow is an invented town. Every name, ordinance and figure on this page was made up to teach with, and nothing here is a projection of any water system.

The whole lesson, in reading order, with the worked answers behind a control you open. This is what the screen shows when it has no script to run, and it is the same lesson.

The interactive workspace needs JavaScript. Everything it teaches is on this page.

Step 1 of 3. What the choice moves

Where this sits

This sits under the money model: one piece of work, three ways to pay for it, and one balance that absorbs whichever is chosen.

The picture

Every box here is at the end of an arrow out of the funding plan, except the debt service already promised.

The idea

A council deciding how to pay for a piece of work is choosing which year the money leaves. Spending cash takes it all in one year. Borrowing takes a smaller amount every year for several years and costs interest. Putting the work off takes it later and costs a year of construction inflation. The promises already made to lenders sit outside all three.

The detail

At thirty percent above the adopted schedule the work costs 1,050,000 dollars in FY2029 on two of the plans and 1,102,500 a year later on the third, because a year of waiting is a year of construction inflation. The debt service already promised is 500,000 dollars a year on every plan and in every year.

What the work costs, done in FY2029 the same under two of the three plans

Debt service already promised flat across every plan and every year

In the room

A buyer asks We want to borrow for this. Does that put us in breach?

You say Not by itself. Your covenant counts the senior lien, and a subordinate borrowing sits underneath it. What moves your coverage is what you charge.

Never say Borrowing is safe for you.

The covenant on the screen is invented, and the one binding a real utility is a sentence in its own ordinance that somebody has to read.

Where it touches the work

The plan the learner switches is one of two controls over a table computed once at build time, and a combination the table does not hold comes back as a refusal.

Before the question

Move the funding plan through all three settings. Which of these four is the same in every year under every plan?

The line the plan leaves alone

Choose one.

plan adopted, rate 130
ReadingFY2028FY2029FY2030FY2031FY2032
What the rates bring in$1.41M$1.51M$1.57M$1.63M$1.69M
What the work costs$0$1.05M$0$0$0
What the lender puts in$0$0$0$0$0
Debt service already promised$500k$500k$500k$500k$500k
Debt service on the new borrowing$0$0$0$0$0
Cash carried into the next year$758k-$48k$731k$1.04M$1.39M
Show the worked answer

The debt service already promised. The other three all move: the work costs a year more if it is put off, the lender only puts money in under the borrowing plan, and the cash carried forward absorbs whatever the other two do. Debt service on money already borrowed was set by a schedule the council signed years ago, so a decision about the next project cannot touch it. That is why it is the first figure to read when somebody asks what a utility can afford.

Written next to the question in this repository. It is not a source and it is not a citation.

Where to go next

Step 2 of 3. The year the money leaves

Where this sits

This sits under the project decision, on the balance every one of the three plans ends up passing through.

The picture

Everything the plan moves arrives at one balance, and that balance is the only line that can go below zero.

The idea

A capital plan is affordable over five years and unaffordable in one of them at the same time. The balance carried from each year into the next is where that shows up. In a year that ends below nothing somebody does not get paid, and a comfortable five-year total does not change it.

The detail

At thirty percent above the adopted schedule the deepest year on the adopted plan ends about 48,500 dollars below zero. Under the borrowing plan the deepest year ends about 581,500 dollars above it, and the closing balance after five years is 204,000 dollars lower.

The deepest year, adopted below zero

The deepest year, borrowing above zero

Closing balance against the adopted plan lower by the interest

In the room

A buyer asks Our five-year plan balances. Why are you asking about one year?

You say Because the year is what you have to fund. If FY2029 comes up short you need a line of credit that year, however the five years add up.

Never say You will run out of money in FY2029.

A projection under one set of assumptions is not a forecast, and a room hears the second when you say the first.

Where it touches the work

The deepest year is read off the table as one whole-horizon figure at the combination the question was asked at, and the question pins that combination when it is asked.

Before the question

Rates are set thirty percent above the adopted schedule. Against the adopted plan, where does the borrowing plan leave the worst year of cash?

Where the worst year ends

Choose one.

plan borrow, rate 130
ReadingFY2028FY2029FY2030FY2031FY2032
What the rates bring in$1.41M$1.51M$1.57M$1.63M$1.69M
What the work costs$0$1.05M$0$0$0
What the lender puts in$0$630k$0$0$0
Debt service already promised$500k$500k$500k$500k$500k
Debt service on the new borrowing$0$0$110k$110k$110k
Cash carried into the next year$758k$582k$747k$947k$1.19M
Show the worked answer

Higher. On the adopted plan the worst year ends about forty-eight thousand dollars below zero, because the whole of the work is paid in one year and the state grant arrives the year after. Borrowing sixty percent of it puts the worst year about five hundred and eighty thousand above zero. What it costs is the closing balance: two hundred and four thousand dollars less at the end of the five years, which is the interest. A council choosing between them is choosing whether to pay that to avoid a year it cannot cover.

Written next to the question in this repository. It is not a source and it is not a citation.

Where to go next

Step 3 of 3. What the covenant does not see

Where this sits

This sits under the project decision and reaches across to the covenant model, which is where the sentence being read comes from.

The picture

Nothing the funding plan reaches is inside the ratio the ordinance tests.

The idea

A covenant is a sentence in a document, and a ratio is what somebody computes from it. When the sentence can be read two ways, there are two ratios, and they can fall on opposite sides of the multiple the document sets. The choice between them is a question about the document and it is not a question about the money.

The detail

At ten percent above the adopted schedule, FY2032 reads 1.18 with the general fund transfer subtracted and 1.28 with it left out. The ordinance sets 1.25. Same projection, same year, one reading under and one reading over.

FY2032, transfer subtracted under the multiple

FY2032, transfer left out over the multiple

What the ordinance sets a multiple of debt service

In the room

A buyer asks So are we in compliance or not?

You say Under one reading of 5.03(b) you are, and under the other you are not, in one of the five years. Your bond counsel decides which reading the document supports, and I can show you both.

Never say You are in compliance.

Nothing here reads a real ordinance, and saying it about a named agency on the strength of a teaching example is the mistake this whole repository refuses.

Where it touches the work

Both readings are computed by the same engine over the same projection, and the two are reported as two separate figures so that a screen cannot quietly show one of them under the other one name.

Before the question

The council asks whether borrowing for this project puts Cedar Hollow in breach of its rate covenant. Answer them, and say where you read it.

What you tell the council

Ninety words at most.

Where you read it

Choose at least one. The last option is a real answer.

plan borrow, rate 110
ReadingFY2028FY2029FY2030FY2031FY2032
What the rates bring in$1.19M$1.28M$1.33M$1.37M$1.43M
What the work costs$0$1.05M$0$0$0
What the lender puts in$0$630k$0$0$0
Debt service already promised$500k$500k$500k$500k$500k
Debt service on the new borrowing$0$0$110k$110k$110k
Cash carried into the next year$541k$132k$56k$5k-$15k
Show the worked answer

The funding choice does not move either coverage figure at all. Both readings of the covenant are identical under all three plans at any rate index, because the ordinance counts senior debt service and the new borrowing is subordinate to it. What moves coverage is the rate index. At ten percent above the adopted schedule the two readings of the same sentence disagree in the final year: with the general fund transfer subtracted, coverage is 1.18 and under the multiple the ordinance sets; with the transfer left out it is 1.28 and above it. So the honest answer to the council is that the borrowing is not what decides this, the reading of section 5.03(b) is, and somebody has to ask bond counsel which reading the document supports. Every figure here belongs to an invented town.

Written next to the question in this repository. It is not a source and it is not a citation.

Where to go next