| A | C | D | E | F | G | H | I | J | ||
|---|---|---|---|---|---|---|---|---|---|---|
1 | Year >> | 2024-2025 | 2025-2026 | 2026-2027 | 2027-2028 | 2028-2029 | 2029-2030 | 2030-2031 | 2031-2032 | |
2 | Capital Outlay Mills >> | 7.57 | 6.079 | 6.169 | 6.031 | 6 | 6 | 6 | 6 | |
3 | Valuation | $78,190,307 | $74,850,000 | $73,750,000 | $72,750,000 | $72,000,000 | $72,000,000 | $71,000,000 | $71,000,000 | |
4 | Property Tax Revenue | $591,901 | $455,013 | $454,964 | $438,755 | $432,000 | $432,000 | $426,000 | $426,000 | |
5 | State Aid Revenue | $124,299 | $95,553 | $95,542 | $92,139 | $90,720 | $90,720 | $89,460 | $89,460 | |
6 | Gen Fund & Supp Gen Portion | $250,000 | $250,000 | $250,000 | $250,000 | $250,000 | $250,000 | $250,000 | $250,000 | |
7 | Projected Total Revenue | $966,200 | $800,566 | $800,506 | $780,894 | $772,720 | $772,720 | $765,460 | $765,460 | |
8 | Prior Year Carryover Balance | $323,675 | $500,440 | $192,545 | $59,527 | -$1,092,941 | -$1,892,677 | -$3,885,796 | -$6,004,231 | |
9 | Projected Grand Total Expense | $789,435 | $1,108,461 | $933,524 | $1,933,362 | $1,572,456 | $2,765,839 | $2,883,895 | $979,438 | |
10 | Projected Year End Balance | $500,440 | $192,545 | $59,527 | -$1,092,941 | -$1,892,677 | -$3,885,796 | -$6,004,231 | -$6,218,209 | |
11 | Deferrred Maintenance | |||||||||
12 | HVAC | $51,659 | $12,051 | $0 | $610,805 | $163,348 | $213,697 | $865,805 | $574,528 | |
13 | Vehicle | $128,986 | $301,518 | $115,780 | $283,963 | $301,518 | $186,837 | $44,900 | $0 | |
14 | Roofing | $114,707 | $0 | $0 | $342,410 | $652,590 | $466,410 | $80,290 | $49,910 | |
15 | Landscaping | $0 | $0 | $0 | $0 | $0 | $7,895 | $0 | $0 | |
16 | Safety & Security | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
17 | Technology | $148,550 | $87,684 | $30,000 | $0 | $0 | $0 | $0 | $0 | |
18 | Athletic Uniform | $8,033 | $4,526 | $0 | $27,707 | $0 | $8,500 | $0 | $0 | |
19 | Additional Projects | $ 2,500 | $ 104,600 | $ 20,000 | $ 20,000 | $ 20,000 | $ 20,000 | $ 20,000 | $ 20,000 | |
20 | Deferred Maint Totals | $454,435 | $510,379 | $165,780 | $1,284,885 | $1,137,456 | $903,339 | $1,010,995 | $644,438 | |
21 | Projected Remaining w Deferred Maint | $835,440 | $790,627 | $827,271 | -$444,464 | -$1,457,677 | -$2,023,296 | -$4,131,331 | -$5,883,209 | |
22 | Property Condition Assessment Findings | |||||||||
23 | AES Exterior Sidewalks/Pavement | $41,205 | ||||||||
24 | AES Retaining Wall / Fix Railing | $24,496 | ||||||||
25 | AES Foundation Repairs / Masonry Repairs / Masonry Tuckpointing | $37,097 | $38,952 | |||||||
26 | AES Window Replacement | $160,867 | ||||||||
27 | AES Electrical Panel/Transformer/Ext Transformer | $47,107 | ||||||||
28 | AES Water Heaters | $40,182 | ||||||||
29 | AES Plumbing Lines | $1,537,900 | ||||||||
30 | HES Exterior Sidewalks | $31,405 | ||||||||
31 | HES Retaining Wall Fix / Railing | $33,172 | ||||||||
32 | HES Foundation Repairs / Masonry Repairs / Masonry Tuckpointing | $60,592 | $63,477 | |||||||
33 | HES Steel Lintel Prep/Paint | $11,777 | ||||||||
34 | HES Ceiling Tile/Ceiling Repairs/Roof Access | $36,823 | ||||||||
35 | HES Plumbing Lines | $1,527,500 | ||||||||
36 | HES Water Heaters | $32,151 | ||||||||
37 | PCA Totals | $0 | $263,082 | $332,744 | $63,477 | $0 | $1,527,500 | $1,537,900 | $0 | |
38 | Projected Remaining w/ deferred maint & PCA | $835,440 | $527,545 | $494,527 | -$507,941 | -$1,457,677 | -$3,550,796 | -$5,669,231 | -$5,883,209 | |
39 | Additional Projects | |||||||||
40 | CHS Paging System | $150,000 | ||||||||
41 | Bleachers (AES, HES, CHS) | $100,000 | $100,000 | $100,000 | ||||||
42 | Track Replacement | $160,000 | $160,000 | $160,000 | $160,000 | $160,000 | $160,000 | $160,000 | $160,000 | |
43 | FB/Track RR Replacement | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
44 | Wrestling Space | $175,000 | $175,000 | $175,000 | $175,000 | $175,000 | $175,000 | $175,000 | $175,000 | |
45 | Additional Projects Total | $335,000 | $335,000 | $435,000 | $585,000 | $435,000 | $335,000 | $335,000 | $335,000 | |
46 | Project Remaining w/ additional projects | $500,440 | $192,545 | $59,527 | -$1,092,941 | -$1,892,677 | -$3,885,796 | -$6,004,231 | -$6,218,209 |