Companion files · The Private Markets Career Guides

The City Manager

How to Run a City by the Numbers: General Fund Budgets, Tax Revenue, Labor Contracts, Pensions, Capital Plans, Utility Rates and the City Council.

These are the companion files of the book. Six workbooks follow the City of Tarrowfield, the fictional city of the case, across two fiscal years and a five-year forecast: revenue, staffing and labor, pension and benefits, capital and debt, water rates, and the reserve and forecast reviewed with the council in November 2026. Each opens on one sheet of inputs with their source documents and ends on a check sheet. A toolkit holds the check-lists of Appendix B in editable form.

The six workbooks, the toolkit and the read-me, in one archive151 KB

The archive holds the six workbooks, the toolkit and 00_START_HERE.md. No macros, no circular references, no external links, no password. The workbooks recalculate in Excel, LibreOffice or Google Sheets.

The files

Three numbers to reproduce first

One cent of rate$760,927 collected in FY2026: one cent per $100 of taxable value, times the collection rate
Full cost of a police position$155,049 in FY2026 for a salary of $95,172: salary, payroll taxes, pension and health
Unassigned balance10.0 percent of expenditures, or 36.4 days, at 30 June 2026, against a policy of 17 percent

The files are provided as they are, without warranty of any kind. The model is illustrative: the City of Tarrowfield, Marrowdale County, the city’s officials, its staff and every party are fictional; the taxable values, rates, salaries, premiums, payments, charges and costs are the book’s assumptions, not market terms or the practice of any real city. Nothing here promises that a budget will balance. Where state law sets a rule, ask the city attorney.