# The City Manager: companion files

Julian R. Sterling

## What is here

- CM_1_Revenue.xlsx (Chapters 5 to 8; Revenue workbook of Appendix A): sheets Inputs, Calculations, Monthly Sales, then Checks. The levy ($41,758,200 in FY2026), one cent of rate as the city collects it ($760,927), the sales tax ($24,800,000 then $24,320,000) month by month, and general fund revenue by source.
- CM_2_Staffing_and_Labor.xlsx (Chapters 4, 9 and 10; Staffing and Labor workbook): sheets Inputs, Calculations, Full Cost, Contract Term, then Checks. Budgeted, vacant and filled positions, personnel cost by department, the full cost of a filled position ($155,049 for a police position paid $95,172), overtime, and the police and fire contracts over their term.
- CM_3_Pension_and_Benefits.xlsx (Chapter 11; Pension and Benefits workbook): sheets Inputs, Calculations, Rate Change, then Checks. Pension contributions and health by department for FY2025 and FY2026, each new rate beside the prior one in dollars, and the effect of an extra pension payment (a projection).
- CM_4_Capital_and_Debt.xlsx (Chapter 13; Capital and Debt workbook): sheets Inputs, Calculations, Deferral, then Checks. The five-year capital plan ($59,000,000), the fire station bonds and their interest ($11,110,650), a street bond, the debt service levy, and the cost of deferring street work.
- CM_5_Water_Rates.xlsx (Chapter 14; Water Rates workbook): sheets Inputs, Net Revenue, Calculations, Rate Paths, then Checks. Net revenue of the water and sewer fund, coverage (1.95 then 1.89) against the covenant, a household's bill ($71.21 in FY2026), uniform against tiered rates, and the two rate paths to FY2031, all projections.
- CM_6_Reserve_and_Forecast.xlsx (Chapters 12, 15 and 16; Reserve and Forecast workbook): sheets Inputs, Calculations, Forecast, Adopted Plan, then Checks. Unassigned balance in percent and in days against the council's policy (10.0 percent and 36.4 days at 30 June 2026, against 17 percent), the FY2027 structural gap (-$4,387,796), the five-year forecast without action and with the adopted plan, the plan measure by measure and a sales tax stress test, all projections.
- CM_City_Manager_Checklists.docx: the 8 check-lists of Appendix B, editable (The first ninety days: reading the numbers; The budget calendar; Presenting the budget to the council; Preparing a labor negotiation; Reviewing the reserve and the five-year forecast; The capital plan and borrowing; Reviewing water rates; The monthly report to the council).

## How to use the workbooks

Each workbook opens on an input sheet. Every number of the case is typed there once, in blue type on a light blue fill, with the document it comes from beside it and a short Conventions block above; the other sheets only read from it. A calculation sheet follows, one step per row, written out in words; black type is a formula, green type a link to another sheet. Every division returns a blank, never an error, when its divisor is zero or empty, and the check sheet flags it. Values are rounded for display only (the book adds lines rounded to the dollar, so the check sheet compares a few of its totals within five dollars), and the calculated cells are protected against overtyping, with no password. Rebuild the case first: the Checks sheet of each workbook puts the live cells beside the figures printed in the book and reads ALL CHECKS OK; below the comparisons it counts the input tests that need a look. Each of the 15 exercises of Appendix A is done in the workbook it names.

The arithmetic is plain: add, subtract, multiply, divide, and raise to a power for compound growth and level bond payments.

Two inputs to try first:

1. In CM_1_Revenue.xlsx, on Inputs, change the FY2026 operating rate: the levy, current-year collections and general fund revenue move at once, and one cent of rate stays the unit to quote.
2. In CM_4_Capital_and_Debt.xlsx, on Inputs, change the years deferred: the cost of the deferred street project moves, and the added cost per year deferred shows why a one-time cut should stay one-time.

To use a workbook on your own city, replace the shaded cells of the input sheet from named documents (the assessor's certified value, the adopted budget, the actuarial letter, the bond documents, the rate ordinance), and keep a copy with the case for comparison. Date every input. The workbooks are separate files with no link between them: when the Reserve and Forecast workbook needs a figure from another workbook, copy it across.

## A word of caution

The City of Tarrowfield, Marrowdale County, Kellorne, Wintersedge and the city's officials and staff are fictional. Taxable values, rates, salaries, premiums, payments, charges and costs are teaching assumptions, not market norms, targets or recommendations, and nothing here promises that any budget will balance or any vote will pass. Where state law sets a rule, ask the city attorney. No real city, county, agency, union, association, rating agency, consulting firm, bank or software is described or recommended. Nothing here is legal, tax or investment advice.
