BW

BudgetWise

Dynamic Scenario Tool · Sample School Data

Fiscal overview

Strategic projection through FY 2030-31

Base year FY 2026-27 · projections run through FY 2030-31

Year 1 surplus / (deficit)

-$3,637,008

Baseline -$3,637,008

Cumulative change through 2030-31

+$0

Scenario vs. baseline

Ending fund balance

$16,381,041

+$0 vs. baseline

First deficit year

2027-28

1.48 mills would cover it

Impact through FY 2030-31

Scenario surplus or deficit by year against the baseline forecast.

FY 2027-28 warning: expenditures outpace revenue in this scenario; 1.48 mills would close that year's gap.

Base year: FY 2026-27 as budgeted

The starting point. Forecast years use the detailed annual figures maintained on the Assumptions page.

Total revenue & financing sources
$101,333,802
Total expenditures & uses
$101,833,848
Budgetary reserve (in uses)
$500,000
Budgeted result
-$500,046

Scenario detail by year

LineFY 2027-28FY 2028-29FY 2029-30FY 2030-31
Real estate taxes$68,393,937$70,613,732$72,907,074$75,136,305
Other local revenue$9,529,000$9,513,000$9,337,000$9,321,000
State revenue$23,054,550$23,814,620$24,370,726$24,827,204
Federal revenue$1,780,000$1,723,720$1,687,440$1,651,160
Total revenue$102,757,487$105,665,072$108,302,240$110,935,669
Salaries$37,893,578$39,174,678$40,550,152$41,965,234
Health insurance$11,419,480$12,561,428$13,817,572$15,199,330
PSERS$12,912,078$13,548,722$14,454,768$14,959,388
Social Security$2,898,858$2,996,862$3,147,986$3,210,340
Other benefits$1,081,600$1,218,664$1,356,672$1,495,668
Debt service$6,541,096$6,931,096$7,101,096$7,361,096
Capital projects$0$0$0$0
Other operating$33,647,805$34,565,219$35,395,211$36,269,678
Total expenditures$106,394,495$110,996,669$115,823,457$120,460,734
Surplus / (deficit)-$3,637,008-$5,331,596-$7,521,217-$9,525,065
Ending fund balance$38,758,920$33,427,323$25,906,106$16,381,041

Baseline revenue and expenditures come from the detailed annual figures on the Assumptions page. Scenario changes are applied on top of those business-office projections through FY 2030-31.