Companion files · The Private Markets Career Guides
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 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.
Chapters 5 to 8
The levy and one cent of rate, the sales tax with a month-by-month sheet, and general fund revenue by source. Sheets: Inputs, Calculations, Monthly Sales. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 117 KBChapters 4, 9 and 10
Positions budgeted, vacant and filled, personnel cost by department, the full cost of a position, overtime, and labor contracts over their term. Sheets: Inputs, Calculations, Full Cost, Contract Term. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 223 KBChapter 11
Pension contributions and health by department, and each new rate beside the prior one in dollars. Sheets: Inputs, Calculations, Rate Change. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 316 KBChapter 13
The five-year capital plan, bond payments and interest, the debt service levy, and the cost of deferring street work. Sheets: Inputs, Calculations, Deferral. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 415 KBChapter 14
Water and sewer net revenue, coverage against the covenant, a household’s bill, tiered rates and two rate paths, all projections. Sheets: Inputs, Net Revenue, Calculations, Rate Paths. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 523 KBChapters 12, 15 and 16
The reserve in percent and in days, the structural gap, the five-year forecast and the adopted plan, all projections. Sheets: Inputs, Calculations, Forecast, Adopted Plan. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 622 KBAppendix B
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.
Download the toolkit41 KBRead first
What each file holds, which workbook answers which chapter, and the two inputs to change first.
Download the read-me5 KB| 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 balance | 10.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.