# The School Business Official: companion files

Julian R. Sterling

## What is here

- SBO_1_Enrollment_and_State_Aid.xlsx (Chapters 3 and 4; Enrollment and State Aid workbook of Appendix A): tabs Cover, Counts, Ratios, Forecast, Scenarios, Formula, then Checks. October counts by grade (4,852, 4,755 and 4,638 students), cohort survival ratios, the February forecast and its error (-9 students in FY2026), three scenarios for October 2026, and the fictional state aid formula step by step ($28,057,779 then $28,074,150 of foundation aid).
- SBO_2_Levy_and_Revenue.xlsx (Chapters 4, 5 and 12; Levy and Revenue workbook): tabs Cover, Value, Rate, Collections, Mill, then Checks. Taxable value, the operating rate in mills, the levy ($34,454,000 in FY2026), collections ($33,351,472) and their months, and what one mill is worth ($2,140,000).
- SBO_3_Payroll_and_Staffing.xlsx (Chapters 6 and 7; Payroll and Staffing workbook): tabs Cover, Positions, Schedule, Benefits, Loaded Cost, Cost per Pupil, then Checks. Positions and FTE, the salary schedule by step and lane, benefits by position type, the loaded cost of a position in FY2027 ($98,952 for a classroom teacher, a projection), and current expenditure per pupil ($13,787.83 then $14,694.21).
- SBO_4_Budget_and_Variance.xlsx (Chapters 10 and 11; Budget and Variance workbook): tabs Cover, Original, Final, Actual, Variance, then Checks. The FY2026 budget voted in June 2025, its amendment, the final budget, the actual figures and each variance with its sign, and the result of the year (-$1,759,526).
- SBO_5_Cash_and_Fund_Balance.xlsx (Chapters 9, 12 and 13; Cash and Fund Balance workbook): tabs Cover, Cash Forecast, Note, Fund Balance, Food Service, then Checks. Thirteen monthly columns of cash against the floor of $2,500,000, the tax anticipation note ($119,000 of interest in FY2026; lowest month-end cash $3,142,823), the five classes of fund balance and months of expenditures (1.53 then 1.03) against the board's policy, and the food service fund's three-month limit.
- SBO_6_Decisions.xlsx (Chapter 16; Decisions workbook): tabs Cover, Options, Three-Year Plan, then Checks. Option A, close Brennickford Elementary ($969,144 a year, net), option B, leave positions unfilled ($1,190,108 a year), option C, an added levy ($2,637,210 collected if the voters approve it), and the three-year plan. All projections, never results.
- SBO_School_Business_Official_Checklists.docx: the 8 check-lists of Appendix B, editable (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).

## How to use the workbooks

Each workbook opens on a cover tab that names the chapters it serves, lists its tabs in reading order and states the fiscal years loaded. Each tab that Appendix A describes holds its own inputs: the case's figures in blue on a light blue background, an empty yellow column for yours, and a Used column that takes your figure when you type one and the case figure otherwise; every formula reads the Used column. Where the case figures sit in a grid (counts by grade, ratios, the salary schedule, positions, budget lines, months of cash), they are typed in place: overwrite them with your own. Black type is a formula, green type a link to another tab. Every cell that divides stays empty, never an error, until its divisor is entered. Rebuild the case first: the Checks tab of each workbook compares the live cells with the figures printed in the book and reads ALL CHECKS OK while the yellow cells are empty. Each of the 18 exercises of Appendix A is done in the workbook it names.

The arithmetic is plain: add, subtract, multiply, divide and round. When a figure is rounded, the note at the top of the tab says how, and which chapter explains it.

Two inputs to try first:

1. In SBO_1_Enrollment_and_State_Aid.xlsx, on Counts, lower one grade of the October 2025 count: the ratios, the weighted students, the cushion and foundation aid move at once.
2. In SBO_5_Cash_and_Fund_Balance.xlsx, on Note, change the month the note is repaid: the interest and every month-end cash after it move, and the tab flags any month under the floor.

To use a workbook on your own district, fill the yellow cells from your student information reports, the county's certification, the payroll register, the general ledger and the bank statements, in the order Appendix A gives, and keep a copy with the case for comparison. Keep the fiscal year aligned: the case runs from 1 July to 30 June. Date every input. The workbooks are separate files with no link between them: when the decisions workbook needs a loaded cost or the value of a mill, copy the figure across.

## A word of caution

Halvenbrook Public Schools, the city of Halvenbrook, Quessendale County, the district's board, officers and staff, Thornavel Bank and Gaskerley & Associates are fictional. The state aid formula of the case is fictional and matches the formula of no state. Salaries, premiums, contribution rates, aid amounts, taxable values, tax rates, prices and costs are teaching assumptions, not market norms, targets or recommendations, and 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. No real district, agency, bank, audit firm, rating agency or software is described or recommended. Nothing here is legal, tax or accounting advice.
