Companion files · The Private Markets Career Guides

The School Business Official

How to Run a School District's Finances: Enrollment, State Aid, Property Tax Levies, Payroll, Federal Grants, Fund Balance, Cash Flow and the Board.

These are the companion files of the book. Six workbooks follow Halvenbrook Public Schools, the fictional district of the case, across two fiscal years: enrollment and state aid, the levy and revenue, payroll and staffing, the budget and its variances, cash and fund balance, and the decisions the board faced in the second year. Each keeps the case’s figures in one column and an empty column for yours. A toolkit holds the check-lists of Appendix B in editable form.

The six workbooks, the toolkit and the read-me, in one archive168 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

Foundation aid$40,914,150 - $12,840,000 = $28,074,150 in FY2026: formula cost less the local share
One mill$2,140,000,000 / 1,000 = $2,140,000 of tax on FY2026 taxable value
Months of expenditures$5,874,387 / $5,714,229.42 = 1.03 months of unassigned balance at 30 June 2026, against a policy of 1.5 to 2.5

The files are provided as they are, without warranty of any kind. The model is illustrative: Halvenbrook Public Schools, the city of Halvenbrook, Quessendale County, the board, the officers, the staff, the bank, the audit firm and every party are fictional; the state aid formula is fictional and matches the formula of no state; the salaries, rates, values, prices and aid amounts are the book’s assumptions, not market terms or the practice of any real district. Nothing here promises a balanced budget or the outcome of any vote. Where state law sets a calendar, a limit or a procedure, ask counsel.