Financial Oversight Committee · Phase 1 Recovery Reporting
Iowa City Community School District

General Fund 13-Week Rolling Cash Forecast

Forecast horizon: week of October 5, 2026 through week of January 4, 2027  ·  Built from week-ending October 2 actuals  ·  Report ID: FOC-CF13-2026-W40
Forecast purpose. The 13-week rolling cash forecast is the early-warning tool used during Phase 1 of the district's financial recovery plan. It is rebuilt each Monday from the prior week's actual close. Projected vs. actual variance is tracked weekly; trailing-quarter accuracy is reported at the bottom of this exhibit.
Week ending Beginning cash State aid Prop tax / other in Payroll out Other out Ending cash Days cash
Oct 9, 2026 $25.6M — $0.8M ($9.6M) ($4.1M) $12.7M 22
Oct 16, 2026 $12.7M $18.5M $0.6M ($0.4M) ($3.2M) $28.2M 49
Oct 23, 2026 $28.2M — $0.7M ($9.7M) ($3.8M) $15.4M 27
Oct 30, 2026 $15.4M — $0.5M ($0.4M) ($4.6M) $10.9M 19
Nov 6, 2026 — trough $10.9M — $6.2M ($9.7M) ($3.4M) $4.0M 7
Nov 13, 2026 $4.0M $18.5M $0.6M ($0.4M) ($3.1M) $19.6M 34
Nov 20, 2026 $19.6M — $0.7M ($9.7M) ($3.6M) $7.0M 12
Nov 27, 2026 $7.0M — $0.4M ($0.4M) ($2.8M) $4.2M 7
Dec 4, 2026 — tax disbursement $4.2M $18.5M $24.3M ($9.8M) ($3.5M) $33.7M 59
Dec 11, 2026 $33.7M — $0.8M ($0.4M) ($4.1M) $30.0M 53
Dec 18, 2026 $30.0M — $0.6M ($9.8M) ($3.7M) $17.1M 30
Dec 25, 2026 $17.1M — $0.4M ($0.4M) ($2.6M) $14.5M 25
Jan 1, 2027 $14.5M — $0.5M ($9.8M) ($3.3M) $1.9M 3
Committee note — troughs identified in the forecast The forecast shows projected cash dipping to $4.0M (7 days) for the week of November 6 — the trough between the October state aid receipt and the December property tax disbursement — and again to $1.9M (3 days) for the week of January 1, the trough between the December tax disbursement and the January state aid receipt. These dips are recurring annual patterns and are forecasted in advance. Action: the Operations Director has prepared contingency drawdown notices with MidwestOne against the standing Revenue Anticipation Warrant capacity for both windows, to be issued only if scheduled receipts are delayed.
Forecast accuracy — prior four weeks
Week ending Sep 11: +1.3%  ·  Week ending Sep 18: −0.4%  ·  Week ending Sep 25: +2.1%  ·  Week ending Oct 2: −0.8%. Trailing-quarter average variance within ±1.5% — within tolerance band.
Phase 2 step-down trigger
When the trailing-quarter trough no longer breaches the yellow zone of days cash on hand, the forecast steps down to a bi-weekly cadence.
Built by: Chief Financial Officer's office.  Reviewed by: FOC Chair, weekly.  Distribution: Board, Superintendent, CFO, COO, Operations Director, FOC members.  Methodology: Rolled from prior week-ending GL actual cash. Inflows from state aid schedule, county property tax disbursement schedule, and standard revenue accruals. Outflows from payroll calendar, standing AP commitments, and the bond debt service schedule.