Companion files · The Private Markets Career Guides
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 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 3 and 4
October counts by grade, cohort survival ratios, the forecast and its error, three scenarios, and the fictional state aid formula step by step. Tabs: Cover, Counts, Ratios, Forecast, Scenarios, Formula. A Checks tab puts the figures printed in the book beside the cells that compute them.
Download workbook 126 KBChapters 4, 5 and 12
Taxable value, mills, the levy, collections and their months, and what one mill is worth. Tabs: Cover, Value, Rate, Collections, Mill. A Checks tab puts the figures printed in the book beside the cells that compute them.
Download workbook 218 KBChapters 6 and 7
Positions and FTE, the salary schedule, benefits, the loaded cost of a position, and current expenditure per pupil. Tabs: Cover, Positions, Schedule, Benefits, Loaded Cost, Cost per Pupil. A Checks tab puts the figures printed in the book beside the cells that compute them.
Download workbook 325 KBChapters 10 and 11
The budget the board voted, its amendments, the actual figures of each monthly close and every variance with its sign. Tabs: Cover, Original, Final, Actual, Variance. A Checks tab puts the figures printed in the book beside the cells that compute them.
Download workbook 422 KBChapters 9, 12 and 13
Cash by month against the floor, the tax anticipation note, the five classes of fund balance in months against the policy, and the food service limit. Tabs: Cover, Cash Forecast, Note, Fund Balance, Food Service. A Checks tab puts the figures printed in the book beside the cells that compute them.
Download workbook 523 KBChapter 16
Close a school, leave positions unfilled or ask the voters, then the three-year plan, all projections. Tabs: Cover, Options, Three-Year Plan. A Checks tab puts the figures printed in the book beside the cells that compute them.
Download workbook 620 KBAppendix B
The first ninety days: reading the district’s numbers; The budget calendar and the board’s vote; The enrollment forecast; The monthly close and the report to the finance committee; Federal grants: allowable spending, effort tests, reimbursements; Cash and the tax anticipation note; Preparing the audit; A cost reduction plan, including a school closure.
Download the toolkit42 KBRead first
What each file holds, which workbook answers which chapter, and the two inputs to change first.
Download the read-me6 KB| 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.