ATTACHMENT 2
Out Year Financial Planning Tool
1r202/23 Actual 12023/24 Atal 2021/25 Estimate NY 2025726 Proi. N 2026/27 Proi. П 3027/78 Pro TV 2028/29 Pr FY 2029/30 Proj. Average Major Revenues
11.968,447 5 12,368,280|3 13.534,643 14,732,117 15.548,500 16.248,183 16,979,351 17,743,421 $ 15,296,169 200010 | < 300,138 $ 434,106 487,400 $29,000 539.580 SSO 222| K5: 220< 522 602 426 510 969.422 S1 - 2915 3 972.543 1.025.774 150000 924,120 942.602 961,454 S 960,684 971,779 253,779 S 279,184 290,000 303,960 310,039 316,2405 322,565 293,723 289,279 S 346,150 435,300 535,909 | SO CAE CRE BAS 180 газ 2,395,200 ananannum 2.522,882 2,558,568 2.756.821 2.249,181 131111 S 541,092 559,725| 570,920 503.085 16: 860
467,571 615,700 706,271 727,459 749,283 771,761 645,40₴ Park 624,930 5 164,392 wanna 66,500 31.294 82.920 84.578 86,270 29,260 573,859 5. 2,578,297 1.427,783 1.293,580 | 1345 841 1419,752 Stream
2.663,605| 2.771,578 2,500,000 2.600,000 2,704,000 2,812,160 2 024 646 > RAd 862 12830315 233008 3 947,113 nonu 1,433,225 1,836,000 0 us es us 1,909,440 0,985,818 2,065,250 | 1,718,066 1,350,000 S 150,000
1,707,322 213,415
23,773,232 S 22,438,046$ 24,406,354| 26,221,669 | 27,169,566| 28,224,944|| 29,323,487 | 30,467,0175 31,657,434 $ 27,075,750 ins
200705301 5 17.625,7581 19.031,3021 (20,170.200) (21.178.7101| (22,237,646) (23,349,528) (24,517,004) $ (19,750,361) (4,990,557) S (S.890.0001 4.800.0001 (2,739,955)
861,871) 5 (861,371) 861,871) (861,9711 (861,8711 (861,871) (861,871) 261 8711 1881 871) (182.419) 1.268, 23) $ (22,902)
6.400.819)5 (1,223,001)| (1,519,569) (1,839.866) [en uses is us uses es (1,990,000)| (2,115,000) 12378000) 3 (2,428,000) (2,351,389) 26,506,176)S 2222174218 (25,600,630) 26.862 2021 (27.671,937) 24,030,581)| (25,214,517) 26 690 2001 C (27,806,875)) $ (25,723,844) 2,732,940) 51 2063035 (1.194,276 358,927 (502,371 4,194,363 4,108,970 3,877,518 | 2,351,905 16,318,279 13,585,335 13.791.638 12.597,362 12,956,289 12.453,918 12,658,281 $ 12,805,913
16.385235 5 13,791,638 $ 12,597,362 12,956,289 9a02 01- 16,648,281 ти 107 010 3,098,062) 5 1526,125) S (2,827,314)| [3,301,510) (3,475,3071| [3,652,897) | (3,859,129)| (4,041,751) (3,318,303) (3.098.05235 (2.827.314)| [3.082,6311| 3.301.510] (3.475.3071| 13652,8971 (3.859.129)| (4.041.751) 20 7 7,389,211 5 8,536,35 $ 6,942,734 6.791.027 5.850,893 9,697.663| 9,461,457 7,336,610 S 10013753308303/ 7,521,213 Proj. u Proj. u Proj. a Total
Bike/Ped Master Plan 135000 8 1,250,000 1A85 250,000 3 AB.CI| 500,000 13-A.B 1 3000 900 $ 1,500,000 1,000,000 1,000,000 5,000.025 Draisage Master Pins 2,825,0002-A.8CS 735,000 2,600,000 = 250,000 2,250,000 2,500,000 | 2,500,000 8.335.060 Park Master Plan 1,700,000$ 200,000 3-A.B.C|S 1,950,000 150,000 15 &15A | 450,000 250,000 250,000 250,000 Federal Funding (Eschco) Grant 600,000 5 75,000 1.380,000 • es es us 1,380,000 1,125,0005 1,500,0005 240,000 5 840,000 840,000 nunnunnum 840,000 840,000 28 840,000 840,000 4,200,076 Long Term Liablities (Pensicn UAL)
Long Term Liabilities (OPEB UAL)
nema Conde
Green Infrastructure Plan 14000 , 300,000 5 200,000 2:0 S 175,00 14,8 , 210,000 200,000 23 250,000 29 s 250,000 250,000 1.085.069 Traffic Safety Improvement
Affordable Housing Allocation
Facility Replacement/impravements 500.0007-A,8C5 530000 12ABC S $00,000 24-1,8 500000 304485 $00,000 500,000 2,500,000 Totals S 7,640,0005 5,300.000 5 5,890,000 5,830,000 4,800,000 3,990,000 $,590,000 5,340,000| 5,340,000 $ 25,550,000 12 Net Avallable Fund Balance (After Set Asides) 7,389,2115 8,739,3875 6,942,734 6,791,027 5,850,898 5,707,668| 3,871,457 1,996,610| 141,927 Ree'd Minimum Unallecated Fund Balence (5%) S 1,032,687 51 842,042 5 942,438 1.027,542 1,100,503 1,158,436 | 1,286,376| 1,347,250 Long Term Liablity
• PERS UAL 19.018.949 5] 17,750,706|5 16,527,705 | 15,008,136 13.168,270 | 11,178,270 | 9,063,270 6,685,270 4,257,270 H6 COPES UAL S 689971 8 603300 8 5.171.228 11 3,447,486 2.723,741 4s v
2.585,615|1 861.873