Loading...
HomeMy WebLinkAboutTreasurer GF - Mark presented2022-2026 Budget Projection and Five -Year Budget Outlook Updated 9-29-21 7% increase for unions over 3 years (thru 2023) 2020 2021 2021 2022 2022 2023 2023 2024 2024 2025 2025 2025 2026 GENERAL FUND 2019 original 2020 Adopted projected Prof projected Prof projected Proi projected Proi projected Proi projected Actual Budget Actual Budget Budget Incr Budget Incr Budget Incr Budget Incr Budget Incr Budget Beginning Fund Balance 4,768,135 5,548,731 6,626,048 6,758,716 7,796,446 6,565,146 6,583,361 6,868,445 6,890,195 6,836,763 Revenues 19,828,847 20,595,564 20,993,483 20,706,694 20,953,072 4.2% 21,914,822 4.8% 22,957,968 2.0% 23,417,127 2.9% 24,096,224 3.0% 24,816,701 Additional Sales Tax Projected 1,044,000 New Revenues CARES funds 2,536,650 One time funds Received 2,482,096 557,000 643,000 PILT 500,000 530,000 550,000 550,000 550,000 One time funds Received 417,000 171,841 Other One time revenues 304,720 162,410 TOTAL REVENUES 22,310,943 20,900,284 24,666,543 20,706,694 22,811,913 22,414,822 23,487,968 23,967,127 24,646,224 25,366,701 142,965 144,734 Expenditures Base Budget (19,884,981) (21,070,984) (20,756,531) (21,755,703) (21,755,703) 3.6% (22,585,528) 3.6% (23,616,167) 3.2% (24,371,885) 3.2% (25,139,599) 3.2% (25,944,066) To Capital Improvement Fund (1,000,000) One time costs (568,049) (386,996) (332,686) (288,697) (288,697) Other one time costs (348,928) (1,032,064) Unbudgeted COVID costs (1,058,000) (1,350,000) Budget Cuts Additions to base budget (45,000) (210,000) Other additions to base TOTAL EXPENDITURES: (20,453,030) (21,457,980) (23,496,145) (22,044,400) (24,471,464) (22,795,528) (23,616,167) (24,371,885) (25,139,599) (25,944,066) Year -End Adjustments Interfund Loan Reimb. Estimated carryover at 1.75% 375,515 385,777 428,251 398,922 413,283 426,508 439,943 454,021 Ending Fund Balance 6,626,048 5,366,550 7,796,446 5,806,787 6,565,146 6,583,361 6,868,445 6,890,195 6,836,763 6,713,419 Recomd. Reserves - 15% of Expend. 2019 3,067,955 3,218,697 3,524,422 3,306,660 3,670,720 3,419,329 3,542,425 3,655,783 3,770,940 3,891,610 Unreserved Fund Balance 3,558,094 2,147,853 4,272,024 2,500,127 2,894,426 3,164,032 3,326,020 3,234,412 3,065,823 2,821,809 Diff. in Rev and Expendi (no carryover): 1,857,913 (557,696) 1,170,398 (1,337,706) (1,659,551) (380,706) (128,200) (404,758) (493,375) (577,365) 2021 Budget Projection and Six -Year Budget Outlook Draft for Mark 7-21-21 7% increase for unions over 3 years (thru 2023) 2020 2021 2021 2022 2022 2023 2023 2024 2024 2025 2025 2025 2026 GENERAL FUND 2019 original 2020 Adopted projected Proi projected Proj projected Proi projected Proi projected Proi projected Actual Budget Actual Budget Budget Incr Budget Incr Budget Incr Budget Incr Budget Incr Budget Beginning Fund Balance 4,768,135 5,548,731 6,626,048 6,758,716 7,796,446 6,584,034 6,293,270 6,221,984 6,084,246 5,869,050 Revenues 19,828,847 20,595,564 20,993,483 20,706,694 20,812,208 0.9% 21,899,518 4.7% 22,917,845 2.9% 23,587,047 2.8% 24,256,919 3.0% 24,982,201 Additional Sales Tax Projected 900,000 New Revenues CARES funds 2,536,650 One time funds Received 2,482,096 557,000 643,000 PILT One time funds Received 417,000 Other One time revenues 304,720 162,410 TOTAL REVENUES 22,310,943 20,900,284 24,666,543 20,706,694 22,355,208 21,899,518 22,917,845 23,587,047 24,256,919 24,982,201 Expenditures Base Budget (19,884,981) (21,070,984) (20,756,531) (21,755,703) (21,755,703) 3.6% (22,585,528) 3.6% (23,398,607) 3.2% (24,147,363) 3.2% (24,908,005) 3.1% (25,690,116) To Capital Improvement Fund (1,000,000) One time costs (568,049) (386,996) (332,686) (288,697) (288,697) Other one time costs (348,928) (548,000) Unbudgeted COVID costs (1,058,000) (1,350,000) Budget Cuts Additions to base budget (45,000) Other additions to base TOTAL EXPENDITURES: (20,453,030) (21,457,980) (23,496,145) (22,044,400) (23,987,400) (22,585,528) (23,398,607) (24,147,363) (24,908,005) (25,690,116) Year -End Adjustments Interfund Loan Reimb. Estimated carryover at 1.75% 375,515 385,777 419,780 395,247 409,476 422,579 435,890 449,577 Ending Fund Balance 6,626,048 5,366,550 7,796,446 5,806,787 6,584,034 6,293,270 6,221,984 6,084,246 5,869,050 5,610,712 Recomd. Reserves - 15% of Expend. 2019 3,067,955 3,218,697 3,524,422 3,306,660 3,598,110 3,387,829 3,509,791 3,622,104 3,736,201 3,853,517 Reserved for one-time following year Unreserved Fund Balance 3,558,094 2,147,853 4,272,024 2,500,127 2,985,924 2,905,441 2,712,192 2,462,142 2,132,850 1,757,194 Diff. in Rev and Expendi (no carryover): 1,857,913 (557,696) 1,170,398 (1,337,706) (1,632,192) (686,010) (480,762) (560,316) (651,086) (707,916) 2021 Budget Projection and Six -Year Budget Outlook 5% increase for unions over 3 years 1-25-21 3.5% incr in sales tax over 2020 actual 2020 2021 2021 2022 2022 2023 2023 2024 2024 2025 2025 2025 2026 GENERAL FUND 2019 original 2020 original projected Proi projected Proi projected Proi projected Proi projected Proi projected Actual Budget Actual Budget Budget Incr Budget Incr Budget Incr Budget Incr Budget Incr Budget Beginning Fund Balance 4,768,135 5,548,731 6,626,048 6,758,716 7,796,446 6,589,692 6,121,969 5,535,093 4,881,136 4,136,023 Revenues 19,828,847 20,595,564 20,993,483 20,706,694 20,606,286 0.6% 21,131,984 4.7% 22,114,622 2.9% 22,760,369 2.8% 23,406,763 3.0% 24,106,625 Additional Sales Tax Projected 400,000 New Revenues CARES funds 2,536,650 One time funds Received 2,482,096 557,000 288,697 400,000 One time funds Received 417,000 Other One time revenues 304,720 162,410 TOTAL REVENUES 22,310,943 20,900,284 24,666,543 20,706,694 21,294,983 21,531,984 22,114,622 22,760,369 23,406,763 24,106,625 Expenditures Base Budget (19,884,981) (21,070,984) (20,756,531) (21,755,703) (21,755,703) 3.2% (22,491,560) 3.2% (23,105,851) 3.1% (23,831,374) 3.2% (24,582,063) 3.1% (25,353,939) To Capital Improvement Fund (1,000,000) One time costs (568,049) (386,996) (332,686) (288,697) (288,697) Other one time costs (348,928) Unbudgeted COVID costs (1,058,000) (828,131) Budget Cuts 100,000 Additions to base budget (30,000) Other additions to base TOTAL EXPENDITURES: (20,453,030) (21,457,980) (23,496,145) (22,044,400) (22,902,531) (22,391,560) (23,105,851) (23,831,374) (24,582,063) (25,353,939) Year -End Adjustments Interfund Loan Reimb. Estimated carryover at 1.75% 375,515 385,777 400,794 391,852 404,352 417,049 430,186 443,694 Ending Fund Balance 6,626,048 5,366,550 7,796,446 5,806,787 6,589,692 6,121,969 5,535,093 4,881,136 4,136,023 3,332,402 Recomd. Reserves - 15% of Expend. 2019 3,067,955 3,218,697 3,524,422 3,306,660 3,435,380 3,358,734 3,465,878 3,574,706 3,687,309 3,803,091 Reserved for one-time following year Unreserved Fund Balance 3,558,094 2,147,853 4,272,024 2,500,127 3,154,313 2,763,235 2,069,215 1,306,430 448,713 (470,688) Diff. in Rev and Expendi (no carryover): 1,857,913 (557,696) 1,170,398 (1,337,706) (1,607,548) (859,575) (991,229) (1,071,006) (1,175,299) (1,247,314) 2021 Budget Projection and Six -Year Budget Outlook Scenario A - 5% increase for unions over 3 years 1-20-21 2020 2021 2021 2022 2022 2023 2023 2024 2024 2025 2025 GENERAL FUND 2019 original 2020 original projected Proi projected Proi projected Proi projected Proi projected Actual Budget Actual Budget Budget incr Budget incr Budget Incr Budget incr Budget Beginning Fund Balance 4,768,135 5,548,731 6,626,048 6,758,716 7,796,446 6,285,771 5,718,983 5,020,712 4,246,267 Revenues 19,828,847 20,595,564 20,993,483 20,706,694 20,706,694 3.3% 21,385,874 2.7% 21,956,876 3.0% 22,606,800 2.8% 23,233,008 Additional Sales Tax Projected New Revenues CARES funds 2,536,650 One time funds Received 2,482,096 557,000 288,697 One time funds Received 417,000 Other One time revenues 304,720 162,410 TOTAL REVENUES 22,310,943 20,900,284 24,666,543 20,706,694 20,995,391 21,385,874 21,956,876 22,606,800 23,233,008 Expenditures Base Budget (19,884,981) (21,070,984) (20,756,531) (21,760,109) (21,760,109) 3.2% (22,478,676) 3.2% (23,058,674) 3.2% (23,797,705) 3.2% (24,561,611) To Capital Improvement Fund (1,000,000) One time costs (568,049) (386,996) (332,686) (288,697) (288,697) Other one time costs (348,928) Unbudgeted COVID costs (1,058,000) (828,131) Budget Cuts 135,000 Additions to base budget (30,000) Other additions to base TOTAL EXPENDITURES: (20,453,030) (21,457,980) (23,496,145) (22,048,806) (22,906,937) (22,343,676) (23,058,674) (23,797,705) (24,561,611) Year -End Adjustments Interfund Loan Reimb. Estimated carryover at 1.75% 375,515 385,854 400,871 391,014 403,527 416,460 429,828 Ending Fund Balance 6,626,048 5,366,550 7,796,446 5,802,458 6,285,771 5,718,983 5,020,712 4,246,267 3,347,493 Recomd. Reserves - 15% of Expend. 2019 3,067,955 3,218,697 3,524,422 3,307,321 3,436,041 3,351,551 3,458,801 3,569,656 3,684,242 Reserved for one-time following year Unreserved Fund Balance 3,558,094 2,147,853 4,272,024 2,495,137 2,849,731 2,367,431 1,561,911 676,611 (336,749) Diff. in Rev and Expendi (no carryover): 1,857,913 (557,696) 1,170,398 (1,342,112) (1,911,546) (957,803) (1,101,798) (1,190,905) (1,328,603) fund balance as percent of base budget 33% 25% 38% 27% 29% 25% 22% 18% 14% 2021 Budget Projection and Six -Year Budget Outlook Scenario B - 4.5% increase for unions over 3 years 1-20-21 2020 2021 2021 2022 2022 2023 2023 2024 2024 2025 2025 GENERAL FUND 2019 original 2020 original projected Proi projected Proi projected Proi projected Proi projected Actual Budget Actual Budget Budget incr Budget incr Budget Incr Budget incr Budget Beginning Fund Balance 4,768,135 5,548,731 6,626,048 6,758,716 7,796,446 6,285,771 5,687,979 4,957,713 4,150,247 Revenues 19,828,847 20,595,564 20,993,483 20,706,694 20,706,694 3.3% 21,385,874 2.7% 21,956,876 3.0% 22,606,800 2.8% 23,233,008 Additional Sales Tax Projected New Revenues CARES funds 2,536,650 One time funds Received 2,482,096 557,000 288,697 One time funds Received 417,000 Other One time revenues 304,720 162,410 TOTAL REVENUES 22,310,943 20,900,284 24,666,543 20,706,694 20,995,391 21,385,874 21,956,876 22,606,800 23,233,008 Expenditures Base Budget (19,884,981) (21,070,984) (20,756,531) (21,760,109) (21,760,109) 2.8% (22,400,232) 3.2% (23,091,239) 3.2% (23,831,314) 3.2% (24,596,299) To Capital Improvement Fund (1,000,000) One time costs (568,049) (386,996) (332,686) (288,697) (288,697) Other one time costs (348,928) Unbudgeted COVID costs (1,058,000) (828,131) Budget Cuts 25,000 Additions to base budget (30,000) Other additions to base TOTAL EXPENDITURES: (20,453,030) (21,457,980) (23,496,145) (22,048,806) (22,906,937) (22,375,232) (23,091,239) (23,831,314) (24,596,299) Year -End Adjustments Interfund Loan Reimb. Estimated carryover at 1.75% 375,515 385,854 400,871 391,567 404,097 417,048 430,435 Ending Fund Balance 6,626,048 5,366,550 7,796,446 5,802,458 6,285,771 5,687,979 4,957,713 4,150,247 3,217,392 Recomd. Reserves - 15% of Expend. 2019 3,067,955 3,218,697 3,524,422 3,307,321 3,436,041 3,356,285 3,463,686 3,574,697 3,689,445 Reserved for one-time following year Unreserved Fund Balance 3,558,094 2,147,853 4,272,024 2,495,137 2,849,731 2,331,695 1,494,027 575,550 (472,053) Diff. in Rev and Expendi (no carryover): 1,857,913 (557,696) 1,170,398 (1,342,112) (1,911,546) (989,358) (1,134,363) (1,224,514) (1,363,291) fund balance as percent of base budget 33% 25% 38% 27% 29% 25% 21% 17% 13% 2021 Budget Projection and Six -Year Budget Outlook updated 12-3-20 2020 2020 2021 2021 2022 2022 2023 2023 2024 2024 2025 2025 GENERAL FUND 2019 original projected original projected Proi projected Proi projected Proi projected Proi projected Actual Budget Budget Budget Budget incr Budget incr Budget Incr Budget incr Budget Beginning Fund Balance 4,768,135 5,548,731 6,626,048 5,366,549 6,758,716 6,061,680 5,494,891 4,810,093 4,064,781 Revenues 19,828,847 20,595,564 20,603,944 21,158,533 20,706,694 3.3% 21,385,874 2.7% 21,956,876 3.0% 22,606,800 2.8% 23,233,008 Additional Sales Tax Projected New Revenues CARES/FEMA funds 2,536,600 One time funds Received 2,482,096 557,000 288,697 One time funds Received 200,000 Other One time revenues 304,720 304,720 TOTAL REVENUES 22,310,943 20,900,284 24,202,264 21,158,533 20,995,391 21,385,874 21,956,876 22,606,800 23,233,008 Expenditures Base Budget (19,884,981) (21,070,984) (20,900,562) (21,085,087) (21,557,444) 3.2% (22,478,676) 3.2% (23,044,962) 3.2% (23,768,053) 3.2% (24,515,507) To Capital Improvement Fund (1,000,000) One time costs (568,049) (386,996) (386,996) (288,697) Other one time costs (348,928) Unbudgeted COVID costs (1,886,131) Budget Cuts 150,000 135,000 Additions to base budget (125,700) (232,665) Other additions to base TOTAL EXPENDITURES: (20,453,030) (21,457,980) (24,498,317) (21,085,087) (22,078,806) (22,343,676) (23,044,962) (23,768,053) (24,515,507) Year -End Adjustments Interfund Loan Reimb. Estimated carryover at 1.75% 375,515 428,721 368,989 386,379 391,014 403,287 415,941 429,021 Ending Fund Balance 6,626,048 5,366,550 6,758,716 5,808,984 6,061,680 5,494,891 4,810,093 4,064,781 3,211,304 Recomd. Reserves - 15% of Expend. 2019 3,067,955 3,218,697 3,674,748 3,162,763 3,311,821 3,351,551 3,456,744 3,565,208 3,677,326 Reserved for one-time following year Unreserved Fund Balance 3,558,094 2,147,853 3,083,968 2,646,221 2,749,859 2,143,340 1,353,349 499,573 (466,023) Diff. in Rev and Expendi (no carryover): 1,857,913 (557,696) (296,053) 73,446 (1,083,415) (957,803) (1,088,085) (1,161,253) (1,282,499) fund balance as percent of base budget 33% 25% 32% 28% 28% 24% 21% 17% 13% 2021 Budget Projection and Six -Year Budget Outlook updated 11-30-20 - Draft for Mark 2020 2020 2021 2021 2021 2022 2022 2023 2023 2024 2024 2025 2025 GENERAL FUND 2019 original projected original Prof projected Prof projected Prof projected Proi projected Proi projected Actual Budget Budget Budget incr Budget incr Budget Incr Budget incr Budget incr Budget Beginning Fund Balance 4,768,135 5,548,731 6,626,048 5,366,549 6,075,239 5,273,821 4,873,610 4,360,734 3,792,854 Revenues 19,828,847 20,595,564 20,603,944 21,158,533 20,706,694 3.3% 21,385,874 2.7% 21,956,876 3.0% 22,606,800 2.8% 23,233,008 Additional Sales Tax Projected New Revenues CARES/FEMA funds One time funds Received 2,482,096 557,000 146,211 One time funds Received 200,000 Other One time revenues 304,720 304,720 TOTAL REVENUES 22,310,943 20,900,284 21,665,664 21,158,533 20,852,905 21,385,874 21,956,876 22,606,800 23,233,008 Expenditures Base Budget (19,884,981) (21,070,984) (20,900,562) (21,085,087) 2.5% (21,553,038) 3.2% (22,474,131) 3.2% (22,869,977) 3.2% (23,587,460) 3.2% (24,329,118) To Capital Improvement Fund (1,000,000) One time costs (568,049) (386,996) (386,996) (254,321) Other one time costs (348,928) Unbudgeted COVID costs Budget Cuts 150,000 300,000 Additions to base budget (125,700) (232,665) Other additions to base TOTAL EXPENDITURES: (20,453,030) (21,457,980) (22,612,186) (21,085,087) (22,040,024) (22,174,131) (22,869,977) (23,587,460) (24,329,118) Year -End Adjustments Interfund Loan Reimb. Estimated carryover at 1.75% 375,515 395,713 368,989 385,700 388,047 400,225 412,781 425,760 Ending Fund Balance 6,626,048 5,366,550 6,075,239 5,808,984 5,273,821 4,873,610 4,360,734 3,792,854 3,122,505 Recomd. Reserves - 15% of Expend. 2019 3,067,955 3,218,697 3,391,828 3,162,763 3,306,004 3,326,120 3,430,497 3,538,119 3,649,368 Reserved for one-time following year Unreserved Fund Balance 3,558,094 2,147,853 2,683,411 2,646,221 1,967,817 1,547,491 930,237 254,735 (526,863) Diff. in Rev and Expendi (no carryover): 1,857,913 (557,696) (946,522) 73,446 (1,187,119) (788,258) (913,101) (980,660) (1,096,109) fund balance as percent of base budget 33% 25% 29% 28% 24% 22% 19% 16% 13% 2021 Budget Projection and Six -Year Budget Outlook updated 11-16-20 by Anne 2020 2020 2021 2021 2021 2022 2022 2023 2023 2024 2024 2025 2025 GENERAL FUND 2019 original projected original Prof projected Prof projected Prof projected Proi projected Proi projected Actual Budget Budget Budget incr Budget incr Budget incr Budget incr Budget Incr Budget Beginning Fund Balance 4,768,135 5,548,731 6,626,048 5,366,549 6,075,239 5,127,610 4,785,191 4,331,961 3,825,639 Revenues 19,828,847 20,595,564 20,603,944 21,158,533 20,706,694 3.3% 21,385,874 2.7% 21,956,876 3.0% 22,606,800 2.8% 23,233,008 Additional Sales Tax Projected New Revenues CARES/FEMA funds One time funds Received 2,482,096 557,000 One time funds Received 200,000 Other One time revenues 304,720 304,720 TOTAL REVENUES 22,310,943 20,900,284 21,665,664 21,158,533 20,706,694 21,385,874 21,956,876 22,606,800 23,233,008 Expenditures Base Budget (19,884,981) (21,070,984) (20,900,562) (21,085,087) 2.5% (21,553,038) 2.9% (22,415,310) 3.2% (22,809,269) 3.2% (23,524,806) 3.2% (24,264,452) To Capital Improvement Fund (1,000,000) One time costs (568,049) (386,996) (386,996) (254,321) Other one time costs (348,928) Unbudgeted COVID costs Budget Cuts 150,000 300,000 Additions to base budget (125,700) (232,665) Other additions to base TOTAL EXPENDITURES: (20,453,030) (21,457,980) (22,612,186) (21,085,087) (22,040,024) (22,115,310) (22,809,269) (23,524,806) (24,264,452) Year -End Adjustments Interfund Loan Reimb. Estimated carryover at 1.75% 375,515 395,713 368,989 385,700 387,018 399,162 411,684 424,628 Ending Fund Balance 6,626,048 5,366,550 6,075,239 5,808,984 5,127,610 4,785,191 4,331,961 3,825,639 3,218,823 Recomd. Reserves - 15% of Expend. 2019 3,067,955 3,218,697 3,391,828 3,162,763 3,306,004 3,317,296 3,421,390 3,528,721 3,639,668 Reserved for one-time following year Unreserved Fund Balance 3,558,094 2,147,853 2,683,411 2,646,221 1,821,606 1,467,895 910,571 296,918 (420,845) Diff. in Rev and Expendi (no carryover): 1,857,913 (557,696) (946,522) 73,446 (1,333,330) (729,436) (852,393) (918,006) (1,031,444) fund balance as percent of base budget 33% 25% 29% 28% 24% 21% 19% 16% 13% 2021 Budget Projection and Six -Year Budget Outlook Updated by Anne 10-21-20 Draft for Mark & Patty 2020 2020 2021 2021 2021 2022 2022 2023 2023 2024 2024 2025 2025 GENERAL FUND 2019 original projected original Prof projected Prof projected Prof projected Proi projected Proi projected Actual Budget Budget Budget incr Budget incr Budget Incr Budget incr Budget incr Budget Beginning Fund Balance 4,768,135 5,548,731 6,626,048 5,366,549 6,504,673 5,935,682 5,398,045 4,747,093 4,047,483 Revenues 19,828,847 20,595,564 20,460,291 21,158,533 o.9% 20,634,203 3.4% 21,485,766 2.7% 22,063,734 3.0% 22,727,852 2.7% 23,348,322 Additional Sales Tax Projected 150,000 New Revenues CARES/FEMA funds 2,536,600 One time funds Received 2,482,096 557,000 One time funds Received 200,000 Other One time revenues 304,720 304,720 TOTAL REVENUES 22,310,943 20,900,284 24,058,611 21,158,533 20,784,203 21,485,766 22,063,734 22,727,852 23,348,322 Expenditures Base Budget (19,884,981) (21,070,984) (21,012,918) (21,085,087) 2.5% (21,517,531) 3.2% (22,415,678) 3.2% (23,119,272) 3.2% (23,844,745) 3.2% (24,594,661) To Capital Improvement Fund (1,000,000) One time costs (568,049) (386,996) (386,996) Other one time costs (348,928) Unbudgeted COVID costs (1,886,131) Budget Cuts 150,000 Additions to base budget (125,700) (216,000) Other additions to base TOTAL EXPENDITURES: (20,453,030) (21,457,980) (24,610,673) (21,085,087) (21,733,531) (22,415,678) (23,119,272) (23,844,745) (24,594,661) Year -End Adjustments Interfund Loan Reimb. Estimated carryover at 1.75% 375,515 430,687 368,989 380,337 392,274 404,587 417,283 430,407 Ending Fund Balance 6,626,048 5,366,550 6,504,673 5,808,984 5,935,682 5,398,045 4,747,093 4,047,483 3,231,551 Recomd. Reserves - 15% of Expend. 2019 3,067,955 3,218,697 3,691,601 3,162,763 3,260,030 3,362,352 3,467,891 3,576,712 3,689,199 Reserved for one-time following year Unreserved Fund Balance 3,558,094 2,147,853 2,813,072 2,646,221 2,675,652 2,035,693 1,279,203 470,771 (457,649) Diff. in Rev and Expendi (no carryover): 1,857,913 (557,696) (552,062) 73,446 (949,328) (929,911) (1,055,539) (1,116,893) (1,246,339) fund balance as percent of base budget 33% 25% 31% 28% 28% 24% 21% 17% 13% 2021 Budget Projection and Six -Year Budget Outlook Updated by Anne 10-21-20 Draft for Mark & Patty 2020 2020 2021 2021 2021 2022 2022 2023 2023 2024 2024 2025 2025 GENERAL FUND 2019 original projected original Prof projected Prof projected Prof projected Proi projected Proi projected Actual Budget Budget Budget incr Budget incr Budget incr Budget incr Budget incr Budget Beginning Fund Balance 4,768,135 5,548,731 6,626,048 5,366,549 6,504,673 5,785,682 5,294,545 4,692,362 4,043,384 Revenues 19,828,847 20,595,564 20,460,291 21,158,533 o.9% 20,634,203 3.4% 21,335,766 2.7% 21,909,699 3.0% 22,569,180 2.7% 23,185,319 Additional Sales Tax Projected New Revenues CARES/FEMA funds 2,536,600 One time funds Received 2,482,096 557,000 One time funds Received 200,000 Other One time revenues 304,720 304,720 TOTAL REVENUES 22,310,943 20,900,284 24,058,611 21,158,533 20,634,203 21,335,766 21,909,699 22,569,180 23,185,319 Expenditures Base Budget (19,884,981) (21,070,984) (21,012,918) (21,085,087) 2.5% (21,517,531) 3.2% (22,415,678) 3.2% (22,912,856) 3.2% (23,631,714) 3.2% (24,374,792) To Capital Improvement Fund (1,000,000) One time costs (568,049) (386,996) (386,996) Other one time costs (348,928) Unbudgeted COVID costs (1,886,131) Budget Cuts 150,000 200,000 Additions to base budget (125,700) (216,000) Other additions to base TOTAL EXPENDITURES: (20,453,030) (21,457,980) (24,610,673) (21,085,087) (21,733,531) (22,215,678) (22,912,856) (23,631,714) (24,374,792) Year -End Adjustments Interfund Loan Reimb. Estimated carryover at 1.75% 375,515 430,687 368,989 380,337 388,774 400,975 413,555 426,559 Ending Fund Balance 6,626,048 5,366,550 6,504,673 5,808,984 5,785,682 5,294,545 4,692,362 4,043,384 3,280,470 Recomd. Reserves - 15% of Expend. 2019 3,067,955 3,218,697 3,691,601 3,162,763 3,260,030 3,332,352 3,436,928 3,544,757 3,656,219 Reserved for one-time following year Unreserved Fund Balance 3,558,094 2,147,853 2,813,072 2,646,221 2,525,652 1,962,193 1,255,434 498,627 (375,748) Diff. in Rev and Expendi (no carryover): 1,857,913 (557,696) (552,062) 73,446 (1,099,328) (879,911) (1,003,158) (1,062,533) (1,189,472) fund balance as percent of base budget 33% 25% 31% 28% 27% 24% 20% 17% 13% 2021 Budget Projection and Six -Year Budget Outlook Updated by Anne 10-12-20 2020 2020 2021 2021 2021 2022 2022 2023 2023 2024 2024 2025 2025 GENERAL FUND 2019 original projected original Prof projected Prof projected Prof projected Proi projected Proi projected Actual Budget Budget Budget incr Budget incr Budget Incr Budget incr Budget incr Budget Beginning Fund Balance 4,768,135 5,548,731 6,626,048 5,366,549 6,005,274 5,286,283 4,893,396 4,392,615 3,848,289 Revenues 19,828,847 20,595,564 20,460,291 21,158,533 o.9% 20,634,203 3.4% 21,335,766 2.7% 21,909,699 3.0% 22,569,180 2.7% 23,185,319 Additional Sales Tax Projected New Revenues CARES/FEMA funds One time funds Received 2,482,096 557,000 One time funds Received 200,000 Other One time revenues 304,720 304,720 TOTAL REVENUES 22,310,943 20,900,284 21,522,011 21,158,533 20,634,203 21,335,766 21,909,699 22,569,180 23,185,319 Expenditures Base Budget (19,884,981) (21,070,084) (21,012,918) (21,085,087) 2.5% (21,517,531) 3.2% (22,415,678) 3.2% (22,809,648) 3.2% (23,525,198) 3.2% (24,264,857) To Capital Improvement Fund (1,000,000) One time costs (568,049) (386,996) (386,996) Other one time costs (161,572) Unbudgeted COVID costs Budget Cuts 150,000 300,000 Additions to base budget (125,700) (216,000) Other additions to base TOTAL EXPENDITURES: (20,453,030) (21,457,080) (22,537,186) (21,085,087) (21,733,531) (22,115,678) (22,809,648) (23,525,198) (24,264,857) Year -End Adjustments Interfund Loan Reimb. Estimated carryover at 1.75% 375,499 394,401 368,989 380,337 387,024 399,169 411,691 424,635 Ending Fund Balance 6,626,048 5,367,434 6,005,274 5,808,984 5,286,283 4,893,396 4,392,615 3,848,289 3,193,386 Recomd. Reserves - 15% of Expend. 2019 3,067,955 3,218,562 3,380,578 3,162,763 3,260,030 3,317,352 3,421,447 3,528,780 3,639,728 Reserved for one-time following year Unreserved Fund Balance 3,558,094 2,148,872 2,624,696 2,646,221 2,026,253 1,576,044 971,168 319,509 (446,342) Diff. in Rev and Expendi (no carryover): 1,857,913 (556,796) (1,015,175) 73,446 (1,099,328) (779,911) (899,950) (956,017) (1,079,537) fund balance as percent of base budget 33% 25% 29% 28% 25% 22% 19% 16% 13% 2021 Budget Projection and Six -Year Budget Outlook Updated by Anne 7-31-20 (2) 2020 2020 2021 2021 2021 2022 2022 2023 2023 2024 2024 2025 2025 GENERAL FUND 2019 original projected original Prof projected Prof projected Prof projected Proi projected Proi projected Actual Budget Budget Budget incr Budget incr Budget Incr Budget incr Budget incr Budget Beginning Fund Balance 4,768,135 5,548,731 6,626,048 5,366,549 5,886,726 4,586,582 4,271,588 3,851,898 3,388,424 Revenues 19,828,847 20,595,564 20,161,405 21,158,533 0.6% 20,282,373 4.1% 21,118,007 2.7% 21,686,082 3.0% 22,336,664 2.7% 22,946,455 Additional Sales Tax Projected New Revenues CARES/FEMA funds 457,147 One time funds Received 2,482,096 557,000 One time funds Received 200,000 Other One time revenues 304,720 304,720 TOTAL REVENUES 22,310,943 20,900,284 21,680,272 21,158,533 20,282,373 21,118,007 21,686,082 22,336,664 22,946,455 Expenditures Base Budget (19,884,981) (21,070,084) (21,012,918) (21,085,087) 2.2% (21,441,972) 3.2% (22,114,759) 3.2% (22,499,513) 3.2% (23,206,248) 3.2% (23,935,668) To Capital Improvement Fund (1,000,000) One time costs (568,049) (386,996) (386,996) Other one time costs (161,572) Unbudgeted COVID costs (281,739) (524,967) Budget Cuts 150,000 300,000 Additions to base budget (125,700) Other additions to base TOTAL EXPENDITURES: (20,453,030) (21,457,080) (22,818,925) (21,085,087) (21,966,939) (21,814,759) (22,499,513) (23,206,248) (23,935,668) Year -End Adjustments Interfund Loan Reimb. Estimated carryover at 1.75% 375,499 399,331 368,989 384,421 381,758 393,741 406,109 418,874 Ending Fund Balance 6,626,048 5,367,434 5,886,726 5,808,984 4,586,582 4,271,588 3,851,898 3,388,424 2,818,085 Recomd. Reserves - 15% of Expend. 2019 3,067,955 3,218,562 3,422,839 3,162,763 3,295,041 3,272,214 3,374,927 3,480,937 3,590,350 Reserved for one-time following year Unreserved Fund Balance 3,558,094 2,148,872 2,463,887 2,646,221 1,291,541 999,374 476,971 (92,514) (772,266) Diff. in Rev and Expendi (no carryover): 1,857,913 (556,796) (1,138,653) 73,446 (1,684,566) (696,752) (813,432) (869,584) (989,213) fund balance as percent of base budget 33% 25% 28% 28% 21% 19% 17% 15% 12% 2020 Budget Projection and Six -Year Budget Outlook Updated by Anne 7-17-20 2020 2020 2021 2021 2021 2022 2022 2023 2023 2024 2024 2025 2025 GENERAL FUND 2019 original projected original Prof projected Prof projected Proi projected Prof projected Proi projected Actual Budget Budget Budget incr Budget incr Budget incr Budget Incr Budget incr Budget Beginning Fund Balance 4,768,135 5,548,731 6,626,048 5,366,549 5,706,388 4,922,024 4,607,030 4,187,339 3,723,865 Revenues 19,828,847 20,595,564 20,161,405 21,158,533 0.6% 20,282,373 4.1% 21,118,007 2.7% 21,686,082 3.0% 22,336,664 2.7% 22,946,455 Additional Sales Tax Projected New Revenues One time funds Received 2,482,096 557,000 One time funds Received 200,000 Other One time revenues 304,720 304,720 TOTAL REVENUES 22,310,943 20,900,284 21,223,125 21,158,533 20,282,373 21,118,007 21,686,082 22,336,664 22,946,455 Expenditures Base Budget (19,884,981) (21,070,084) (21,012,918) (21,085,087) 2.2% (21,441,972) 3.2% (22,114,759) 3.2% (22,499,513) 3.2% (23,206,248) 3.2% (23,935,668) To Capital Improvement Fund (1,000,000) One time costs (568,049) (386,996) (386,996) Other one time costs (161,572) Budget Cuts 150,000 300,000 Additions to base budget (125,700) Other additions to base TOTAL EXPENDITURES: (20,453,030) (21,457,080) (22,537,186) (21,085,087) (21,441,972) (21,814,759) (22,499,513) (23,206,248) (23,935,668) Year -End Adjustments Interfund Loan Reimb. Estimated carryover at 1.75% 375,499 394,401 368,989 375,235 381,758 393,741 406,109 418,874 Ending Fund Balance 6,626,048 5,367,434 5,706,388 5,808,984 4,922,024 4,607,030 4,187,339 3,723,865 3,153,526 Recomd. Reserves - 15% of Expend. 2019 3,067,955 3,218,562 3,380,578 3,162,763 3,216,296 3,272,214 3,374,927 3,480,937 3,590,350 Reserved for one-time following year Unreserved Fund Balance 3,558,094 2,148,872 2,325,810 2,646,221 1,705,728 1,334,816 812,412 242,928 (436,824) Diff. in Rev and Expendi (no carryover): 1,857,913 (556,796) (1,314,061) 73,446 (1,159,599) (696,752) (813,432) (869,584) (989,213) fund balance as percent of base budget 33% 25% 27% 28% 23% 21% 19% 16% 13% 2020 Budget Projection and Six -Year Budget Outlook Updated by Anne 7-15-20 (draft for Mark) 2020 2020 2021 2021 2021 2022 2022 2023 2023 2024 2024 2025 2025 GENERAL FUND 2019 original projected original Prof projected Prof projected Proi projected Prof projected Proi projected Actual Budget Budget Budget Incr Budget incr Budget Incr Budget Incr Budget Incr Budget Beginning Fund Balance 4,768,135 5,548,731 6,626,048 5,366,549 5,639,961 5,106,184 4,749,700 4,275,842 3,753,370 Revenues 19,828,847 20,595,564 20,151,144 21,158,533 -0.05% 20,141,068 4.2% 20,980,951 2.7% 21,547,437 3.1% 22,204,633 2.8% 22,815,261 Additional Sales Tax Projected New Revenues One time funds Received 2,482,096 557,000 PILT 441,000 441,000 441,000 441,000 441,000 One time funds Received 200,000 Other One time revenues 304,720 304,720 TOTAL REVENUES 22,310,943 20,900,284 21,212,864 21,158,533 20,582,068 21,421,951 21,988,437 22,645,633 23,256,261 Expenditures Base Budget (19,884,981) (21,070,084) (21,070,084) (21,085,087) 2.1% (21,491,955) 3.2% (22,166,346) 3.2% (22,862,386) 3.2% (23,580,769) 3.2% (24,322,211) To Capital Improvement Fund (1,000,000) One time costs (568,049) (386,996) (386,996) Other one time costs (161,572) Budget Cuts 150,000 Additions to base budget (125,700) Other additions to base TOTAL EXPENDITURES: (20,453,030) (21,457,080) (22,594,352) (21,085,087) (21,491,955) (22,166,346) (22,862,386) (23,580,769) (24,322,211) Year -End Adjustments Interfund Loan Reimb. Estimated carryover at 1.75% 375,499 395,401 368,989 376,109 387,911 400,092 412,663 425,639 Ending Fund Balance 6,626,048 5,367,434 5,639,961 5,808,984 5,106,184 4,749,700 4,275,842 3,753,370 3,113,059 Recomd. Reserves - 15% of Expend. 2019 3,067,955 3,218,562 3,389,153 3,162,763 3,223,793 3,324,952 3,429,358 3,537,115 3,648,332 Revenue Stabilization Reserve Reserved for one-time following year 0 Unreserved Fund Balance 3,558,094 2,148,872 2,250,808 2,646,221 1,882,391 1,424,748 846,484 216,255 (535,273) Diff. in Rev and Expendi (no carryover): 1,857,913 (556,796) (1,381,488) 73,446 (909,886) (744,395) (873,949) (935,135) (1,065,950) 2020 Budget Projection and Six -Year Budget Outlook Updated by Anne 7-7-20 (draft for Mark) 2020 2020 2021 2021 2021 2022 2022 2023 2023 2024 2024 2025 2025 GENERAL FUND 2019 original projected original Proi projected Proi projected Proj projected Proi projected Proi projected Actual Budget Budget Budget Incr Budget Incr Budget Incr Budget Incr Budget Incr Budget Beginning Fund Balance 4,769,506 5,548,731 6,524,659 5,366,549 5,538,572 4,922,536 4,409,597 3,807,675 3,155,129 Revenues 19,828,847 20,595,564 20,151,144 21,158,533 0.7% 20,282,126 3.8% 21,052,847 2.9% 21,652,853 3.1% 22,313,265 2.7% 22,915,724 Additional Sales Tax Projected New Revenues One time funds Received 2,482,096 557,000 PILT 441,000 441,000 441,000 441,000 441,000 One time funds Received 200,000 Other One time revenues 304,720 304,720 TOTAL REVENUES 22,310,943 20,900,284 21,212,864 21,158,533 20,723,126 21,493,847 22,093,853 22,754,265 23,356,724 Expenditures Base Budget (19,987,741) (21,070,084) (21,070,084) (21,085,087) 3.2% (21,719,249) 3.2% (22,398,765) 3.2% (23,100,026) 3.2% (23,823,726) 3.2% (24,570,586) To Capital Improvement Fund (1,000,000) One time costs (568,049) (386,996) (386,996) Other one time costs (161,572) Budget Cuts 150,000 Additions to base budget (125,700) Other additions to base TOTAL EXPENDITURES: (20,555,790) (21,457,080) (22,594,352) (21,085,087) (21,719,249) (22,398,765) (23,100,026) (23,823,726) (24,570,586) Year -End Adjustments Interfund Loan Reimb. Estimated carryover at 1.75% 375,499 395,401 368,989 380,087 391,978 404,250 416,915 429,985 Ending Fund Balance 6,524,659 5,367,434 5,538,572 5,808,984 4,922,536 4,409,597 3,807,675 3,155,129 2,371,253 Recomd. Reserves - 15% of Expend. 2019 3,083,369 3,218,562 3,389,153 3,162,763 3,257,887 3,359,815 3,465,004 3,573,559 3,685,588 Revenue Stabilization Reserve Reserved for one-time following year 0 Unreserved Fund Balance 3,441,291 2,148,872 2,149,419 2,646,221 1,664,649 1,049,782 342,671 (418,429) (1,314,335) Diff. in Rev and Expendi (no carryover): 1,755,153 (556,796) (1,381,488) 73,446 (996,123) (904,918) (1,006,172) (1,069,461) (1,213,862) 2020 Budget Projection and Six -Year Budget Outlook Updated by Anne 4-30-20 2020 2020 2021 2021 2021 2022 2022 2023 2023 2024 2024 2025 2025 GENERAL FUND 2019 original projected original Proi projected Proi projected Proj projected Proi projected Proi projected Actual Budget Budget Budget incr Budget Incr Budget incr Budget incr Budget Incr Budget Beginning Fund Balance 4,769,506 5,548,731 6,524,659 5,366,549 4,774,559 4,057,044 3,574,468 3,120,366 2,726,705 Revenues 19,828,847 20,595,564 19,630,573 21,158,533 1.3% 19,893,623 3.0% 20,490,431 3.4% 21,187,106 3.5% 21,937,130 3.5% 22,713,704 Additional Sales Tax Projected One time funds Received 2,482,096 384,850 PILT 384,150 384,150 384,150 384,150 384,150 New Revenues Other One time revenues 304,720 304,720 TOTAL REVENUES 22,310,943 20,900,284 20,320,143 21,158,533 20,277,773 20,874,581 21,571,256 22,321,280 23,097,854 Expenditures Base Budget (19,987,741) (21,070,084) (21,070,084) (21,085,087) 3.2% (21,719,249) 3.2% (22,037,565) 3.2% (22,417,667) 3.2% (23,119,532) 3.2% (23,843,858) To Capital Improvement Fund (1,000,000) One time costs (568,049) (386,996) (386,996) Other one time costs (30,572) Budget Cuts 150,000 350,000 300,000 Additions to base budget (125,700) Other additions to base TOTAL EXPENDITURES: (20,555,790) (21,457,080) (22,463,352) (21,085,087) (21,369,249) (21,737,565) (22,417,667) (23,119,532) (23,843,858) Year -End Adjustments Interfund Loan Reimb. Estimated carryover at 1.75% 375,499 393,109 368,989 373,962 380,407 392,309 404,592 417,268 Ending Fund Balance 6,524,659 5,367,434 4,774,559 5,808,984 4,057,044 3,574,468 3,120,366 2,726,705 2,397,969 Recomd. Reserves - 15% of Expend. 2019+ 3,083,369 3,218,562 3,369,503 3,162,763 3,205,387 3,260,635 3,362,650 3,467,930 3,576,579 Revenue Stabilization Reserve Reserved for one-time following year 0 Unreserved Fund Balance 3,441,291 2,148,872 1,405,056 2,646,221 851,657 313,833 (242,284) (741,225) (1,178,610) Diff. in Rev and Expendi (no carryover): 1,755,153 (556,796) (2,143,209) 73,446 (1,091,476) (862,984) (846,411) (798,253) (746,004) 2019 Budget Projection and Six -Year Budget Outlook 2/6/20 2020 2021 GENERAL FUND 2017 2018 2019 projected Prof Actual Actual Actual Budget incr Beginning Fund Balance 4,304,390 4,005,224 4,769,506 6,524,659 Revenues 18,283,880 19,505,232 19,828,847 19,991,079 2.9% Additional Sales Tax Projected One time funds Received 863,272 1,295,727 2,482,096 New Revenues 400,000 Other One time revenues 19,037 304,720 TOTAL REVENUES 19,166,189 20,800,959 22,310,943 20,695,799 Expenditures Base Budget (18,293,903) (18,872,269) (19,987,741) (20,660,976) 3.4% To Capital Improvement Fund (1,000,000) One time costs (1,169,330) (411,000) (568,049) (386,996) Other one time costs (753,419) Additions to base budget (274,255) Other additions to base (135,753) TOTAL EXPENDITURES: (19,463,233) (20,036,688) (20,555,790) (22,457,980) Year -End Adjustments (2,122) 11 Interfund Loan Reimb. Estimated carryover at 1.75% 393,015 Ending Fund Balance 4,005,224 4,769,506 6,524,659 5,155,493 Recomd. Reserves - 15% of Expend. 2019+ 1,946,323 2,003,669 3,083,369 3,368,697 Revenue Stabilization Reserve 726,000 726,000 Reserved for one-time following year 516,000 466,907 0 Unreserved Fund Balance 816,901 1,572,930 3,441,291 1,786,796 Diff. in Rev and Expendi (no carryover): (297,044) 764,271 1,755,153 (1,762,181) increase in Base budget expenditures 4.6% 3.2% 5.9% (info only) 2020-2021 Salaries and Benefits For 2020, uses CBA's and a 1.75 increase to exempt For 2021, uses a 3.1% increase 2019 One time revenue received 301,809 = Sheriff grants and PAO PT contract 2019 Other one time revenue received 537,000 PILT = Over Budget 600,000 = Investment earnings over budget 270,648 = Sales tax over budget 250.000 = DNR Timber sales over budaet 1,657, 648 2019 expenses 444,836 = adds in the adopted budget 800.000 = supplemental budget appropriations 2021 2022 2022 2023 2023 2024 2024 2025 2025 projected Proj projected Proj projected Proj projected Proj projected Budget incr Budget incr Budget incr Budget incr Budget 5,155,493 4,270,778 3,262,024 2,121,809 842,363 20,154,260 2.9% 20,738,734 2.9% 21,340,157 2.9% 21,959,021 2.9% 22,595,833 20,154,260 20,738,734 21,340,157 21,959,021 22,595,833 (21,413,715) 3.4% (22,134,847) 3.4% (22,880,786) 3.4% (23,652,385) 3.4% (24,450,527) (21,413,715) (22,134,847) (22,880,786) (23,652,385) (24,450,527) 374,740 387,360 400,414 413,917 427,884 4,270,778 3,262,024 2,121,809 842,363 (584,447) 3,212,057 3,320,227 3,432,118 3,547,858 3,667,579 1,058,720 (58,203) (1,310,309) (2,705,495) (4,252,026) (1,259,455) (1,396,113) (1,540,629) (1,693,363) (1,854,694) Pivot Proj Diff 2020 One time revenue 216,720 = Sheriff transfer from Capital 88,000 = Increase in Child Support Enforcement grant 304,720 = total one time revenue 2020 expenses 386,996 = one-time 2020 asks = remainder of 2019 reservation after one-time adopted 386,996 = total one time adds 274,255 = ongoing 2020 asks 35,753 = increase in 911 Dispatch costs 100,000 = ongoing equity pay adjustments 410,008 = total ongoing adds 2019 Proj Rev 21,787,243 21700457.00 86,786 2020 rev 2020 Exp 2021 rev 2021 Exp 20,900,284 21,457,980 Pivot 21,057,709 21,085,007 20,683,556 21,674,700 Proj 20,969,822 21,413,715 216,728 (216,720) Diff 87,887 (328,708) 20,378,836 20,595,564 2.69% i budget asks 2019 Budget Projection and Six -Year Budget Outlook 11-23-19 zozo 2020 2021 2021 2022 2022 2023 2023 2024 2024 2025 2025 GENERAL FUND 2017 2018 2019 2019 Pro, projected Prof projected Prof projected Prof projected Prof projected Prof projected Actual Actual Budget Projected mor Bud et inor Budget inor Budget incr Budget inor Budget Incr Budget Beginning Fund Balance 4,304,390 4,005,224 4,769,506 4,769,506 5,548,731 5,366,549 4,700,107 4,768,259 4,736,180 4,597,005 Revenues 18,283,880 19,505,232 19,418,779 19,827,786 3.9% 20,595,564 2.9% 21,158,533 2.9% 21,815,639 2.9% 22,448,292 2.9% 23,099,293 2.9% 23,769,172 Additional Sales Tax Projected One time funds Received 863,272 1,295,727 245,809 301,809 New Revenues Other One time revenues 19,037 1,657,648 304,720 TOTAL REVENUES 19,166,189 20,800,959 19,664,588 21,787,243 20,900,284 21,158,533 21,815,639 22,448,292 23,099,293 23,769,172 Expenditures Base Budget (18,293,903) (18,872,269) (19,987,979) (19,987,979) 0.7% (20,122,996) 3.4% (21,413,715) 3.4% (22,134,847) 3.4% (22,880,786) 3.4% (23,652,385) 3.4% (24,450,527) To Capital Improvement Fund One time costs (1,169,330) (411,000) (444,836) (444,836) (386,996) Other one time costs (753,419) (949,392) (537,980) (800,000) Additions to base budget (274,255) Other additions to base (135,753) TOTAL EXPENDITURES: (19,463,233) (20,036,688) (20,432,815) (21,382,207) (21,457,980) (22,213,715) (22,134,847) (22,880,786) (23,652,385) (24,450,527) Year -End Adjustments (2,122) 11 Interfund Loan Reimb. Estimated carryover at1.75% 357,574 374,189 375,515 388,740 387,360 400,414 413,917 427,884 Ending Fund Balance 4,005,224 4,769,506 4,358,853 5,548,731 5,366,549 4,700,107 4,768,259 4,736,180 4,597,005 4,343,535 Recomd. Reserves -15% of Expend.2019+ 1,946,323 2,003,669 3,064,922 3,207,331 3,218,697 3,332,057 3,320,227 3,432,118 3,547,858 3,667,579 Revenue Stabilization Reserve 726,000 726,000 Reserved for one-time following year 516,000 466,907 333,670 708,256 Unreserved Fund Balance 816,901 1,572,930 960,261 1,633,144 2,147,852 1,368,050 1,448,032 1,304,062 1,049,147 675,956 Diff. in Rev and Expendi(no carryover): (297,044) 764,271 (768,227) 405,036 (557,696) (1,055,182) (319,208) (432,493) (553,092) (681,354) 2019 Budget Projection and Five -Year Budget Outlook 11-7-19 2020 2020 zozs 2021 zozz 2022 zozs 2023 zoza 2024 zozs 2025 GENERAL FUND 2017 2018 2019 2019 Prof projected Proi projected Pro, projected P,o, projected P,o, projected Proi projected Actual Actual Bud et Projected Inor Budget Inc, Budget Inor Budget Inor Budget Inor Budget Inor Budget Beginning Fund Balance 4,304,390 4,005,224 4,901,967 4,769,506 5,608,722 4,858,256 4,800,822 4,693,248 4,532,088 4,313,729 Revenues 18,283,880 19,505,232 19,418,779 19,741,000 4.3% 20,580,137 2.9% 21,176,961 2.9% 21,791,093 2.9% 22,423,035 2.9% 23,073,303 2.9% 23,742,428 Additional Sales Tax Projected One time funds Received 863,272 1,295,727 245,809 301,809 New Revenues Other One time revenues 19,037 1,657,648 88,000 TOTAL REVENUES 19,166,189 20,800,959 19,664,588 21,700,457 20,668,137 21,176,961 21,791,093 22,423,035 23,073,303 23,742,428 Expenditures Base Budget (18,293,903) (18,872,269) (19,987,979) (19,987,979) 2.7% (20,532,449) 3.2% (21,612,616) 3.2% (22,288,719) 3.2% (22,986,458) 3.2% (23,706,525) 3.2% (24,449,634) To Capital Improvement Fund One time costs (1,169,330) (411,000) (444,836) (444,836) (386,996) Other one time costs (753,419) (800,000) (470,652) Additions to base budget (274,255) Other additions to base (135,753) TOTAL EXPENDITURES: (19,463,233) (20,036,688) (20,432,815) (21,232,815) (21,800,105) (21,612,616) (22,288,719) (22,986,458) (23,706,525) (24,449,634) Year -End Adjustments (2,122) 11 Interfund Loan Reimb. Estimated carryover at1.75% 357,574 371,574 381,502 378,221 390,053 402,263 414,864 427,869 Ending Fund Balance 4,005,224 4,769,506 4,491,314 5,608,722 4,858,256 4,800,822 4,693,248 4,532,088 4,313,729 4,034,392 Recomd. Reserves -15% of Expend.2019+ 1,946,323 2,003,669 2,043,282 3,184,922 3,270,016 3,241,892 3,343,308 3,447,969 3,555,979 3,667,445 Revenue Stabilization Reserve 726,000 726,000 726,000 Reserved for one-time following year 516,000 466,907 333,670 857,648 Unreserved Fund Balance 816,901 1,572,930 1,388,363 1,566,152 1,588,240 1,558,930 1,349,940 1,084,119 757,751 366,947 Diff. in Rev and Expendi (no carryover): (297,044) 764,271 (768,227) 467.642 (1,131,968) (435,655) (497,626) (563,424) (633,222) (707,206) increase in Base budget expenditures (info only) 2020-2021 Salaries and Benefits For 2020, uses CBNs and a 1.75 increase to exempt For 2021, uses a 3.1 % increase 2019 One time revenue received 301,809 = Sheriff grants and PAO PT contract 2019 Other one time revenue received 537,000 PILT= Over Budget 600,000 = Investment earnings over budget 270,648 = Sales tax over budget 250.000 = DNR Timber sales over budaet 1,657,648 2019 expenses 444,836 = adds in the adopted budget 800.000 = supplemental budget appropriations 4.6% 3.2% 5.9% 2020 One time revenue - = PILT over budgeted revenues 88,000 = Increase in Child Support Enforcement grant 88,000 = total one time revenue 2020 expenses 386,996 = one-time 2020 asks 470,652 = remainder of 2019 reservation after one-time adopted budget asks 857,648 = total one time adds 274,255 = ongoing 2020 asks 35,753 = increase in 911 Dispatch costs 100,000 = ongoing equity pay adjustments 410,008 = total ongoing adds ncrease from 2.2% ncrease from 2.8% eserve at 15% C:\Users\julies\AppData\Local\Microsoft\Windows\INetCache\Content.Ouflmk\JCTWXNY3\General Fund Budget Projections 9-29-2021.xls General Fund Budget Projections 9-29-2021.xlsx 2019 Budget Projection and Five -Year Budget Outlook 10-29-19 zozo 2020 2121 2021 2oz2 2022 2oz3 2023 2oz4 2024 GENERAL FUND 2015 2016 2017 2018 2019 2019 Proj projected Proj projected Proj projected Pro, projected Proj projected Actual Actual Actual Actual Budget Projected Incr Budget Incr Budget Incr Budget Incr Budget Incr Budget Beginning Fund Balance 2,762,006 3,593,450 4,304,390 4,005,224 4,901,967 4,769,506 5,608,722 5,222,036 4,983,775 4,689,588 4,335,842 Revenues 17,298,966 17,702,654 18,283,880 19,505,232 19,418,779 19,741,000 4.3% 20,580,137 2.9% 21,176,961 2.9% 21,791,093 2.9% 22,423,035 2.9% 23,073,303 Additional Sales Tax Projected One time funds Received 1,660,000 1,574,362 863,272 1,295,727 245,809 301,809 500,000 New Revenues Other One time revenues 19,037 1,657,648 127,000 TOTAL REVENUES 18,958,966 19,277,016 19,166,189 20,800,959 19,664,588 21,700,457 21,207,137 21,176,961 21,791,093 22,423,035 23,073,303 Expenditures Base Budget (16,954,773) (17,489,670) (18,293,903) (18,872,269) (19,987,979) (19,987,979) 3.6% (20,710,790) 3.2% (21,796,664) 3.2% (22,478,657) 3.2% (23,182,474) 3.2% (23,908,813) To Capital Improvement Fund (880,000) (300,000) One time costs (297,461) (782,500) (1,169,330) (411,000) (444,836) (444,836) (492,779) Other one time costs (753,419) (800,000) (364,869) Additions to base budget (274,255) Other additions to base (135,753) TOTAL EXPENDITURES: (18,132,234) (18,572,170) (19,463,233) (20,036,688) (20,432,815) (21,232,815) (21,978,446) (21,796,664) (22,478,657) (23,182,474) (23,908,813) Year -End Adjustments 4,712 6,094 (2,122) 11 Interfund Loan Reimb. Estimated carryover at 1.75% 357,574 371,574 384,623 381,442 393,376 405,693 418,404 Ending Fund Balance 3,593,450 4,304,390 4,005,224 4,769,506 4,491,314 5,608,722 5,222,036 4,983,775 4,689,588 4,335,842 3,918,736 Recomd. Reserves - 15% of Expend. 2019+ 1,813,223 1,857,217 1,946,323 2,003,669 2,043,282 3,184,922 3,296,767 3,269,500 3,371,799 3,477,371 3,586,322 Revenue Stabilization Reserve 440,000 502,000 726,000 726,000 726,000 Reserved for one-time following year 417,250 607,000 516,000 466,907 333,670 857,648 Unreserved Fund Balance 922,977 1,338,173 816,901 1,572,930 1,388,363 1,566,152 1,925,269 1,714,276 1,317,789 858,471 332,414 Diff. in Rev and Expendi (no carryover): 826,732 704,846 (297,044) 764,271 (768,227) 467,642 (771,309) (619,703) (687,564) (759,439) (835,510) increase in Base budget expenditures (info only) 2020-2021 Salaries and Benefits For 2020, uses CBA's and a 1.75 increase to exempt For 2021, uses a 3.1 % increase 2019 One time revenue received 301,809 = Sheriff grants and PAO PT contract 2019 Other one time revenue received 537,000 PILT = Over Budget 600,000 = Investment earnings over budget 270,648 = Sales tax over budget 250.000 = DNR Timber sales over budget 1,657,648 2019 expenses 444,836 = adds in the adopted budget 800.000 = supplemental budget appropriations 3.4% 3.2% 4.6% 3.2% 5.9% 2020 One time revenue 500,000 = expected PILT over budgeted revenues 127,000 = Increase in Child Support Enforcement grant 627,000 = total one time revenue 2020 expenses 492,779 = one-time 2020 asks 364,869 = remainder of 2019 reservation after one-time adopted budget asks 857,648 = total one time adds 274,255 = ongoing 2020 asks 35,753 = increase in 911 Dispatch costs 100,000 = ongoing equity pay adjustments 410,008 = total ongoing adds rease from 2.2 % rease from 2.8 % erve at 15 % 2019 Budget Projection and Five -Year Budget Outlook 10-29-19 GENERAL FUND 2015 2016 2017 2018 2019 Actual Actual Actual Actual Budget Beginning Fund Balance 2,762,006 3,593,450 4,304,390 4,005,224 4,901,967 Revenues 17,298,966 17,702,654 18,283,880 19,505,232 19,418,779 Additional Sales Tax Projected One time funds Received 1,660,000 1,574,362 863,272 1,295,727 245,809 New Revenues Other One time revenues 19,037 TOTAL REVENUES 18,958,966 19,277,016 19,166,189 20,800,959 19,664,588 Expenditures Base Budget (16,954,773) (17,489,670) (18,293,903) (18,872,269) (19,987,979) To Capital Improvement Fund (880,000) (300,000) One time costs (297,461) (782,500) (1,169,330) (411,000) (444,836) Other one time costs (753,419) Additions to base budget Other additions to base TOTAL EXPENDITURES: (18,132,234) (18,572,170) (19,463,233) (20,036,688) (20,432,815) Year -End Adjustments 4,712 6,094 (2,122) 11 Interfund Loan Reimb. Estimated carryover at 1.75% 357,574 Ending Fund Balance 3,593,450 4,304,390 4,005,224 4,769,506 4,491,314 Recomd. Reserves - 15% of Expend. 2019+ 1,813,223 1,857,217 1,946,323 2,003,669 2,043,282 Revenue Stabilization Reserve 440,000 502,000 726,000 726,000 726,000 Reserved for one-time following year 417,250 607,000 516,000 466,907 333,670 Unreserved Fund Balance 922,977 1,338,173 816,901 1,572,930 1,388,363 Diff. in Rev and Expendi (no carryover): 826,732 704,846 (297,044) 764,271 (768,227) increase in Base budget expenditures (info only) 2020-2021 Salaries and Benefits For 2020, uses CBA's and a 1.75 increase to exempt For 2021, uses a 3.1% increase 2019 One time revenue received 301,809 = Sheriff grants and PAO PT contract 2019 Other one time revenue received 537,000 PILT = Over Budget 600,000 = Investment earnings over budget 270,648 = Sales tax over budget 250.000 = DNR Timber sales over budaet 1,657, 648 2019 expenses 444,836 = adds in the adopted budget 800.000 = supplemental budget appropriations 3.4% 3.2% 4.6% 3.2% 2020 One time revenue 500,000 = expected PILT over budgeted revenues 127000 = Increase in Child Support Enforcement grant 2020 expenses 267,758 = one-time 2020 asks 589'890 = remainder of 2019 reservation after one-time; 857,648 = total one time adds 318,022 = ongoing 2020 asks 47,000 = increase in 911 Dispatch costs 100,000 = ongoing equity pay adjustments 465,022 = total ongoing adds 2020 2020 2021 2021 2022 2022 2023 2023 2024 2024 2019 Poi projected Poi projected Poi projected Proj projected Poi projected Projected inor Budget inor Budget inor Budget inor Budget inor Budget 4,769,506 5,608,722 5,210,986 4,961,321 4,655,365 4,289,474 19,741,000 4.3% 20,580,137 2.9% 21,176,961 2.9% 21,791,093 2.9% 22,423,035 2.9% 23,073,303 301,809 500,000 1,657,648 127,000 21,700,457 21,207,137 21,176,961 21,791,093 22,423,035 23,073,303 (19,987,979) 3.6% (20,710,790) 3.2% (21,808,270) 3.2% (22,490,635) 3.2% (23,194,835) 3.2% (23,921,570) (444,836) (311,525) (800,000) (546,123) (274,255) (147,000) (21,232,815) (21,989,693) (21,808,270) (22,490,635) (23,194,835) (23,921,570) 371,574 384,820 381,645 393,586 405,910 418,627 5,608,722 5,210,986 4,961,321 4,655,365 4,289,474 3,859,834 3,184,922 3,298,454 3,271,241 3,373,595 3,479,225 3,588,236 857,648 1,566,152 1,912,532 1,690,081 1,281,770 810,248 271,598 467,642 (782,556) (631,309) (699,542) (771,801) (848,268) 5.9% adopted budget asks increase from 2.2% increase from 2.8% reserve at 15% C:\Users\julies\AppData\Local\Microsoft\Windows\INetCache\Content.Outlook\JCTWXNY3\General Fund Budget Projections 9-29-2021.xlsx General Fund Budget Projections 9-29-2021.xlsx 2019 Budget Projection and Five -Year Budget Outlook -Scenario 2 no extra revenue June 20, 2019 for Mark by A. Sears (no increased timber and investment rev in 2020) 2020 2020 2021 2021 2022 2022 2023 2023 7024 2024 GENERAL FUND 2015 2016 2017 2018 2019 2019 Proj projected Proj projected Proj projected Proj projected Proi projected Actual Actual Actual Actual Budget Projected Incr Budget Incr Budget Incr Budget Incr Budget Incr Budget Beginning Fund Balance 2,762,006 3,593,450 4,304,390 4,005,224 4,901,967 4,769,606 5,452,074 4,600,266 4,416,100 4,166,587 3,847,602 Revenues 17,298,966 17,702,654 18,283,880 19,505,232 19,418,779 19,741,000 2.2% 20,175,302 2.8% 20,748,281 2.8% 21,337,532 2.8% 21,943,518 2.8% 22,566,714 Additional Sales Tax Projected One time funds Received 1,660,000 1,574,362 863,272 1,295,727 245,809 245,809 New Revenues Other One time revenues 19,037 1,557,000 TOTAL REVENUES 18,958,966 19,277,016 19,166,189 20,800,959 19,664,588 21,543,809 20,175,302 20,748,281 21,337,532 21,943,518 22,566,714 Expenditures Base Budget (16,954,773) (17,489,670) (18,293,903) (18,872,269) (19,987,979) (19,987,979) 2.7% (20,535,650) 3.2% (21,305,278) 3.2% (21,971,547) 3.2% (22,659,137) 3.2% (23,368,729) To Capital Improvement Fund (880,000) (300,000) One time costs (297,461) (782,500) (1,169,330) (411,000) (444,836) (444,836) (757,000) Other one time costs (753,419) (800,000) Additions to base budget (109,000) Other additions to base TOTAL EXPENDITURES: (18,132,234) (18,572,170) (19,463,233) (20,036,688) (20,432,815) (21,232,815) (21,401,650) (21,305,278) (21,971,547) (22,659,137) (23,368,729) Year -End Adjustments 4,712 6,094 (2,122) 11 Interfund Loan Reimb. Estimated carryover at 1 75% 357,574 371,574 374,529 372,842 384,502 396,535 408,953 Ending Fund Balance 3,693,450 4,304,390 4,006,224 4,769,606 4,491,314 6,462,074 4,600,256 4,416,100 4,166,687 3,847,602 3,464,439 Recomd. Reserves - 10% of Expend. 1,813,223 1,857,217 1,946,323 2,003,669 2,043,282 2,123,282 2,140,165 2,130,628 2,197,166 2,266,914 2,336,873 Revenue Stabilization Reserve 440,000 502,000 726,000 726,000 726,000 868,158 868,168 868,168 868,158 868,168 868,168 Reserved for one-time following year 417,250 607,000 516,000 466,907 333,670 757,000 Unreserved Fund Balance 922,977 1,338,173 816,901 1,572,930 1,388,363 1,703,635 1,591,933 1,417,414 1,101,274 713,431 249,408 Diff. in Rev and Expendi (no carryover): 826,732 704,846 (297,044) 764,271 (768,227) 310,994 (1,226,348) (556,998) (634,016) (715,619) (802,016) increase in Base budget expenditures 3.4% 3.2% 4.6% 3.2% 5.9% (info only) For 2020, this gives a 0% union increase and a 1.75 increase to exempt, adds rec. mgt position of 109K For 2021, this estimates a 1.66% increase for all One time breakdown'19 537,000 PILT 600,000 investment 140,000 Timber Exise 280000 DNRTimber 1,557,000 2019 Budget Projection and Five -Year Budget Outlook - Worst Case April 14, 2019 2019 2020 2020 2021 2021 2021 2022 2021 2023 GENERAL FUND 2016 2016 2017 2018 1 2019 Proi 1 projected Prof 1 projected Proj projected Proi 1 projected Actual Actual Actual Actual I -Projected Incr Budget Inor Budget Inor Budget Incr Budget Beginning Fund Balance 2,762,006 3,593,450 4,304,390 4,005,224 4,769,506 3,851,537 3,583,144 3,437,154 3,239,256 Revenues 17,298,966 17,702,654 18,283,880 19,505,232 0.8% 19,664,588 2.9% 20,234,861 2.9% 20,821,672 2.9% 21,425,501 2.9% 22,046,840 Additional Sales Tax Projected One time funds Received 1,660,000 1,574,362 863,272 1,295,727 355,000 New Revenues Other One time revenues 19,037 TOTAL REVENUES 18,958,966 19,277,016 19,166,189 20,800,959 20,019,588 20,234,861 20,821672 21,425,501 22,046,840 Expenditures Base Budget (16,954,773) (17,489,670) (18,293,903) (18,872,269) 5.9% (19,987,979) 3.2% (20,571,109) 3.2% (21,341,132) 3.2% (22,008,548) 3.2% (22,697,322) To Capital Improvement Fund (880,000) (300,000) One time costs (297,461) (782,500) (1,169,330) (411,000) (444,836) (189,060) Other one time costs (753,419) (877,676) Additions to base budget (108,282) Other additions to base TOTAL EXPENDITURES: (18,132,234) (18,572,170) (19,463,233) (20,036,688) (21,310,491) (20,868,451) (21,341,132) (22,008,548) (22,697,322) Year-EndAdjustments4,712 6,094 (2,122) 11 Interfund Loan Reimb. Estimated carryover at 1.75% 372,934 365,198 373,470 385,150 397,203 Ending Fund Balance 3,593,450 4,304,390 4,005,224 4,769,506 3,851,537 3,583,144 3,437,154 3,239,256 2,985,978 Recomd. Reserves- 10%of Expend. 1,813,223 1,857,217 1,946,323 2,003,669 2,131,049 2,086,845 2,134,113 2,200,855 2,269,732 Revenue Stabilization Reserve 440,000 502,000 726,000 726,000 868,158 868,158 868,158 868,158 868,158 Reserved for one-time following year 417,250 607,000 516,000 466,907 7,571 Unreserved Fund Balance 922,977 1,338,173 816,901 1,572,930 844,758 628,141 434,883 170,243 151,912 Diff. in Rev and Expendi (no carryover): 826,732 704,846 (297,044) 764,271 (1,290,903) (633,590) (519,460) (583,048) (650,482) increase in Base budget expenditures 3.4% 3.2% 4.6% 3.2% 5.9% (info only) PILT over budget DPA and appraiser Public Records C \Users\julies\AppData\Lwal\Microsoft\Windows\INetCache\Content.Outlmk\JCTNXNY3\Generel Fund Budget Projections 9-29-2021.xim Generel Fund Budget Projections 9-29-2021.x1sx 2019 Budget Projection and Five -Year Budget Outlook April 14, 2019 2019 2020 2020 2021 2021 2021 2022 2021 2023 GENERAL FUND 2016 2016 2017 2018 1 2019 Proj 1 projected Pmj 1 projected Proj projected Proj 1 projected Actual Actual Actual Actual I -Projected Incr Budget Inor Budget Inor Budget Inor Budget Beginning Fund Balance 2,762,006 3,593,450 4,304,390 4,005,224 4,769,506 4,328,018 4,059,626 3,913,636 3,715,738 Revenues 17,298,966 17,702,654 18,283,880 19,505,232 0.8% 19,664,588 2.9% 20,234,861 2.9% 20,821,672 2.9% 21,425,501 2.9% 22,046,840 Additional Sales Tax Projected One time funds Received 1,660,000 1,574,362 863,272 1,295,727 500,000 New Revenues Other One time revenues 19,037 TOTAL REVENUES 18,958,966 19,277,016 19,166,189 20,800,959 20,164,588 20,234,861 20,821672 21,425,501 22,046,840 Expenditures Base Budget (16,954,773) (17,489,670) (18,293,903) (18,872,269) 5.9% (19,987,979) 3.2% (20,571,109) 3.2% (21,341,132) 3.2% (22,008,548) 3.2% (22,697,322) To Capital Improvement Fund (880,000) (300,000) One time costs (297,461) (782,500) (1,169,330) (411,000) (444,836) (189,060) Other one time costs (753,419) (540,290) Additions to base budget (108,282) Other additions to base TOTAL EXPENDITURES: (18,132,234) (18,572,170) (19,463,233) (20,036,688) (20,973,105) (20,868,451) (21,341,132) (22,008,548) (22,697,322) Year -End Adjustments 4,712 6,094 (2,122) 11 Interfund Loan Reimb. Estimated carryover at 1.75% 367,029 365,198 373,470 385,150 397,203 Ending Fund Balance 3,593,450 4,304,390 4,005,224 4,769,506 4,328,018 4,059,626 3,913,636 3,715,738 3,462,460 Recomd. Reserves- 10%of Expend. 1,813,223 1,857,217 1,946,323 2,003,669 2,097,311 2,086,845 2,134,113 2,200,855 2,269,732 Revenue Stabilization Reserve 440,000 502,000 726,000 726,000 868,158 868,158 868,158 868,158 868,158 Reserved for one-time following year 417,250 607,000 516,000 466,907 Unreserved Fund Balance 922,977 1,338,173 816,901 1,572,930 1,354,979 1,104,623 911,366 646,726 324,669 Diff. in Rev and Expendi (no carryover): 826,732 704,846 (297,044) 764,271 (808,517) (633,590) (519,460) (583,048) (650,482) increase in Base budget expenditures 3.4% 3.2% 4.6% 3.2% 5.9% (info only) PILT over budget DPA and appraiser Public Records 2019 Budget Projection and Five -Year Budget Outlook December 6, 2018 2019 GENERAL FUND 2015 2016 2017 2018 2018 Actual Actual Actual Budget** projected incr Beginning Fund Balance 2,762,006 3,593,450 4,304,390 4,395,109 4,188,548 Revenues 17,298,966 17,702,654 18,283,880 18,582,629 19,330,403 0.5% Additional Sales Tax Projected One time funds Received 1,660,000 1,574,362 863,272 1,295,727 New Revenues Other One time revenues 19,037 TOTAL REVENUES 18,958,966 19,277,016 19,166,189 18,582,629 20,626,130 Expenditures Base Budget (16,954,773) (17,489,670) (18,293,903) (18,865,110) (19,176,238) 4.2% To Capital Improvement Fund (880,000) (300,000) One time costs (297,461) (782,500) (1,169,330) (411,000) (411,000) Other One time costs (500,000) Additions to base budget (140,000) Other additions to base TOTAL EXPENDITURES: (18,132,234) (18,572,170) (19,463,233) (19,416,110) (20,087,238) Year -End Adjustments 4,712 6,094 177,000 (177,000) Interfund Loan Reimb. Estimated carryover at 1.75% 339,782 351,527 Ending Fund Balance 3,593,450 4,304,390 4,184,346 3,901,410 4,901,967 Recomd. Reserves - 10% of Expend. 1,813,223 1,857,217 1,946,323 1,941,611 2,008,724 Revenue Stabilization Reserve 440,000 502,000 726,000 726,000 726,000 Reserved for one-time following year 417,250 607,000 516,000 104,000 557,197 Unreserved Fund Balance 922,977 1,338,173 996,023 1,129,799 1,610,046 Diff. in Rev and Expendi (no carryover): 826,732 704,846 (297,044) (833,481) 538,892 increase in Base budget expenditures 3.4% 3.2% 4.6% 3.9% (info only) 2020 2020 2021 2021 2021 2022 2021 2023 2019 Proj projected Proj projected Poi projected Poi projected Budget inor Budget inor Budget inor Budget inor Budget 4,901,967 4,491,314 4,032,483 3,845,337 3,605,724 19,418,779 2.9% 19,981,924 2.9% 20,569,392 2.9% 21,165,905 2.9% 21,779,716 245,809 19,664,588 19,981,924 20,569,392 21,165,905 21,779,716 (19,987,979) 2.7% (20,471,169) 3.2% (21,126,247) 3.2% (21,786,787) 3.2% (22,468,464) (444,836) (333,670) (20,432,815) (20,804,839) (21,126,247) (21,786,787) (22,468,464) 357,574 364,085 369,709 381,269 393,198 4,491,314 4,032,483 3,845,337 3,605,724 3,310,174 2,043,282 2,080,484 2,112,625 2,178,679 2,246,846 726,000 726,000 726,000 726,000 726,000 333,670 1,388,362 1,225,999 1,006,713 701,045 337,327 (768,227) (822,916) (556,855) (620,882) (688,748) 2019 Budget Projection and Five -Year Budget Outlook December 5, 2018 GENERAL FUND 2015 2016 2017 2018 2018 Actual Actual Actual Budget" projected Beginning Fund Balance 2,762,006 3,593,450 4,304,390 4,395,109 4,188,548 Revenues 17,298,966 17,702,654 18,283,880 18,582,629 19,330,403 Additional Sales Tax Projected One time funds Received 1,660,000 1,574,362 863,272 1,295,727 New Revenues Other One time revenues 19,037 TOTAL REVENUES 18,958,966 19,277,016 19,166,189 18,582,629 20,626,130 Expenditures Base Budget (16,954,773) (17,489,670) (18,293,903) (18,865,110) (19,176,238) To Capital Improvement Fund (880,000) (300,000) Other Adjustments One time costs (297,461) (782,500) (1,169,330) (411,000) (411,000) Other One time costs (500,000) Additions to base budget (140,000) Other additions to base TOTAL EXPENDITURES: (18,132,234) (18,572,170) (19,463,233) (19,416,110) (20,087,238) Year -End Adjustments 4,712 6,094 177,000 (177,000) Interfund Loan Reimb. Estimated carryover at 1.75% 339,782 351,527 Ending Fund Balance 3,593,450 4,304,390 4,184,346 3,901,410 4,901,967 Recomd. Reserves - 10% of Expend. 1,813,223 1,857,217 1,946,323 1,941,611 2,008,724 Revenue Stabilization Reserve 440,000 502,000 726,000 726,000 726,000 Reserved for one-time following year 417,250 607,000 516,000 104,000 557,197 Unreserved Fund Balance 922,977 1,338,173 996,023 1,129,799 1,610,046 1.5% 1.5% 1.75% 1.75% 1.75% Diff. in Rev and Expendi (no carryover): 826,732 704,846 (297,044) (833,481) 538,892 increase in Base budget expenditures 3.4% 3.2% 4.6% 3.9% (info only) 2019 2020 2020 2021 2021 2021 2022 2021 2023 2019 Prof projected Proi projected Proi projected Proi projected Incr Budget Incr Budget inor Budget Incr Budget Incr Budget 4,901,967 4,491,314 3,976,986 3,732,568 3,433,850 0.5% 19,418,779 2.9% 19,981,924 2.9% 20,569,392 2.9% 21,165,905 2.9% 21,779,716 245,809 19,664,588 19,981,924 20,569,392 21,165,905 21,779,716 4.2% (19,987,979) 2.7% (20,527,654) 3.2% (21,184,539) 3.2% (21,846,945) 3.2% (22,530,547) (444,836) (333,670) (20,432,815) (20,861,324) (21,184,539) (21,846,945) (22,530,547) 357,574 365,073 370,729 382,322 394,285 4,491,314 3,976,986 3,732,568 3,433,850 3,077,303 2,043,282 2,086,132 2,118,454 2,184,694 2,253,055 726,000 726,000 726,000 726,000 726,000 333,670 1,388,362 1,164,854 888,115 523,155 98,249 1.75% 1.75% 1.75% 1.75% 1.75% (768,227) (879,401) (615,147) (681,040) (750,831) 2019 Budget Projection and Five -Year Budget Outlook November 19, 2019 draft for Mark 2019 2019 202o 2020 2021 2021 2021 2022 2021 2023 GENERAL FUND 2015 2016 2017 2018 2018 projected Proj projected Proj projected Proj projected Proj projected Actual Actual Actual Budget. projected Incr Budget incr Budget incr Budget incr Budget incr Budget Beginning Fund Balance 2,762,006 3,593,450 4,304,390 4,395,109 4,188,548 4,901,967 4,544,896 4,085,597 3,897,970 3,657,860 Revenues 17,298,966 17,702,654 18,283,880 18,582,629 19,330,403 0.5% 19,418,324 2.9% 19,981,455 2.9% 20,568,910 2.9% 21,165,409 2.9% 21,779,205 Additional Sales Tax Projected One time funds Received 1,660,000 1,574,362 863,272 1,295,727 245,809 New Revenues Other One time revenues 19,037 TOTAL REVENUES 18,958,966 19,277,016 19,166,189 18,582,629 20,626,130 19,664,133 19,981,455 20,568,910 21,165,409 21,779,205 Expenditures Base Budget (16,954,773) (17,489,670) (18,293,903) (18,865,110) (19,176,238) 3.9% (19,932,979) 2.7% (20,471,169) 3.2% (21,126,247) 3.2% (21,786,787) 3.2% (22,468,464) To Capital Improvement Fund (880,000) (300,000) One time costs (297,461) (782,500) (1,169,330) (411,000) (411,000) Other One time costs (500,000) (444,836) (333,670) Additions to base budget (140,000) Other additions to base TOTAL EXPENDITURES: (18,132,234) (18,572,170) (19,463,233) (19,416,110) (20,087,238) (20,377,815) (20,804,839) (21,126,247) (21,786,787) (22,468,464) Year -End Adjustments 4,712 6,094 177,000 (177,000) Interfund Loan Reimb. Estimated carryover at 1.75% 339,782 351,527 356,612 364,085 369,709 381,269 393,198 Ending Fund Balance 3,593,450 4,304,390 4,184,346 3,901,410 4,901,967 4,544,896 4,085,597 3,897,970 3,657,860 3,361,800 Recomd. Reserves - 10% of Expend. 1,813,223 1,857,217 1,946,323 1,941,611 2,008,724 2,037,782 2,080,484 2,112,625 2,178,679 2,246,846 Revenue Stabilization Reserve 440,000 502,000 726,000 726,000 726,000 726,000 726,000 726,000 726,000 726,000 Reserved for one-time following year 417,250 607,000 516,000 104,000 557,197 333,670 Unreserved Fund Balance 922,977 1,338,173 996,023 1,129,799 1,610,046 1,447,445 1,279,113 1,059,345 753,182 388,954 Diff. in Rev and Expendi (no carryover): 826,732 704,846 (297,044) (833,481) 538,892 (713,682) (823,384) (557,337) (621,378) (689,259) increase in Base budget expenditures 3.4% 3.2% 4.6% 3.9% (info only) 2019 Budget Projection and Five -Year Budget Outlook October 26 draft with corrections 2019 2019 202o 2020 2021 2021 2021 2022 2021 2022 GENERAL FUND 2014 2015 2017 2018 2018 Proj projected Proj projected Proj projected Proj projected Proj projected Actual Actual Actual Budget. projected Incr Budget incr Budget incr Budget incr Budget Incr Budget Beginning Fund Balance 2,670,046 2,762,006 4,304,390 4,395,109 4,184,346 3,942,099 3,953,610 3,816,803 3,687,703 3,507,212 Revenues 16,530,822 17,298,966 18,283,880 18,582,629 18,632,629 5.5% 19,664,558 2.9% 20,234,830 2.9% 20,829,734 2.9% 21,433,796 2.9% 22,055,377 Additional Sales Tax Projected One time funds Received 847,422 1,660,000 863,272 1,295,727 772,000 New Revenues Other One time revenues 13,500 19,037 TOTAL REVENUES 17,391,744 18,958,966 19,166,189 18,582,629 19,928,356 20,436,558 20,234,830 20,829,734 21,433,796 22,055,377 Expenditures Base Budget (16,393,232) (16,954,773) (18,293,903) (18,865,110) (18,935,110) 4.1% (19,706,434) 2.7% (20,610,933) 3.2% (21,324,147) 3.2% (21,999,275) 3.2% (22,687,752) To Capital Improvement Fund (550,000) (880,000) One time costs (342,000) (297,461) (1,169,330) (411,000) (411,000) Other One time costs (13,500) (1,143,766) (807,418) (71,558) Additions to base budget (140,000) (75,000) (52,000) (8,000) Other additions to base (40,000) (200,000) TOTAL EXPENDITURES: (17,298,732) (18,132,234) (19,463,233) (19,416,110) (20,529,876) (20,788,852) (20,734,491) (21,332,147) (21,999,275) (22,687,752) Year -End Adjustments (1,052) 4,712 177,000 Estimated carryover at 1.75% 339,782 359,273 363,805 362,854 373,313 384,987 397,036 Ending Fund Balance 2,762,006 3,593,450 4,184,346 3,901,410 3,942,099 3,953,610 3,816,803 3,687,703 3,507,212 3,271,872 Recomd. Reserves - 10% of Expend. 1,684,873 1,813,223 1,946,323 1,941,611 2,052,988 2,078,885 2,073,449 2,133,215 2,199,928 2,268,775 Revenue Stabilization Reserve 440,000 440,000 726,000 726,000 726,000 726,000 726,000 726,000 726,000 726,000 Reserved for one-time following year 417,250 516,000 104,000 255,976 71,558 Unreserved Fund Balance 637,133 922,977 996,023 1,129,799 907,135 1,077,167 1,017,354 828,488 581,284 277,096 Diff.in Rev and Expendi(no carryover): 93,012 826,732 (297,044) (833,481) (601,520) (352,294) (499,661) (502,412) (565,479) (632,375) increase in Base budget expenditures 3.4% 4.6% 3.9% Additions to Base 2019 2020 2021 increases for Deputies 52,000 8,000 (Sheriff deputies receive additional 1.75% in 2020 and additional 0.25% in 2021 in addition to calculated base) 2019 Budget Projection and Five -Year Budget Outlook October 25, 2018 (draft for Mark & Philip 2019 2019 202o 2020 2021 2021 2021 2022 2021 2022 GENERAL FUND 2014 2015 2017 2018 2018 Proj projected Proj projected Proj projected Proj projected Proj projected Actual Actual Actual Budget. projected Incr Budget incr Budget incr Budget incr Budget Incr Budget Beginning Fund Balance 2,670,046 2,762,006 4,304,390 4,395,109 4,184,346 3,942,099 3,953,610 3,801,505 3,656,618 3,459,835 Revenues 16,530,822 17,298,966 18,283,880 18,582,629 18,632,629 5.5% 19,664,558 2.9% 20,234,830 2.9% 20,829,734 2.9% 21,433,796 2.9% 22,055,377 Additional Sales Tax Projected One time funds Received 847,422 1,660,000 863,272 1,295,727 772,000 New Revenues Other One time revenues 13,500 19,037 TOTAL REVENUES 17,391,744 18,958,966 19,166,189 18,582,629 19,928,356 20,436,558 20,234,830 20,829,734 21,433,796 22,055,377 Expenditures Base Budget (16,393,232) (16,954,773) (18,293,903) (18,865,110) (18,935,110) 3.6% (19,616,434) 2.7% (20,518,503) 3.2% (21,340,215) 3.2% (22,015,858) 3.2% (22,704,865) To Capital Improvement Fund (550,000) (880,000) One time costs (342,000) (297,461) (1,169,330) (411,000) (411,000) Other One time costs (13,500) (1,143,766) (897,418) (71,558) Additions to base budget (140,000) (75,000) (52,000) (8,000) Other additions to base (40,000) (200,000) (108,000) TOTAL EXPENDITURES: (17,298,732) (18,132,234) (19,463,233) (19,416,110) (20,529,876) (20,788,852) (20,750,061) (21,348,215) (22,015,858) (22,704,865) Year -End Adjustments (1,052) 4,712 177,000 Estimated carryover at 1.75% 339,782 359,273 363,805 363,126 373,594 385,278 397,335 Ending Fund Balance 2,762,006 3,593,450 4,184,346 3,901,410 3,942,099 3,953,610 3,801,505 3,656,618 3,459,835 3,207,681 Recomd. Reserves - 10% of Expend. 1,684,873 1,813,223 1,946,323 1,941,611 2,052,988 2,078,885 2,075,006 2,134,821 2,201,586 2,270,487 Revenue Stabilization Reserve 440,000 440,000 726,000 726,000 726,000 726,000 726,000 726,000 726,000 726,000 Reserved for one-time following year 417,250 516,000 104,000 255,976 71,558 Unreserved Fund Balance 637,133 922,977 996,023 1,129,799 907,135 1,077,167 1,000,499 795,797 532,249 211,195 Diff.in Rev and Expendi(no carryover): 93,012 826,732 (297,044) (833,481) (601,520) (352,294) (515,231) (518,481) (582,061) (649,489) increase in Base budget expenditures 3.4% 4.6% 3.9% Additions to Base 2019 2020 2021 increases for Deputies 52,000 8,000 (Sheriff deputies receive additional 1.75% in 2020 and additional 0.25% in 2021 in addition to calculated base) 2019 Budget Projection and Five -Year Budget Outlook July 19. 2018 2019 2019 202o 2020 2021 2021 2021 2022 2021 2022 GENERAL FUND 2014 2015 2017 2018 2018 Proj projected Proj projected Proj projected Proj projected Proj projected Actual Actual Actual Budget. projected Incr Budget incr Budget incr Budget incr Budget Incr Budget Beginning Fund Balance 2,670,046 2,762,006 4,304,390 4,395,109 4,184,346 4,677,103 4,448,536 3,568,035 3,442,424 3,287,570 Revenues 16,530,822 17,298,966 18,283,880 18,582,629 18,632,629 2.8% 19,154,343 2.9% 19,709,819 2.9% 20,289,287 2.9% 20,877,677 2.9% 21,483,129 Additional Sales Tax Projected One time funds Received 847,422 1,660,000 863,272 1,295,727 New Revenues Other One time revenues 13,500 19,037 TOTAL REVENUES 17,391,744 18,958,966 19,166,189 18,582,629 19,928,356 19,154,343 19,709,819 20,289,287 20,877,677 21,483,129 Expenditures Base Budget (16,393,232) (16,954,773) (18,293,903) (18,865,110) (18,935,110) 2.2% (19,490,152) 2.4% (20,093,996) 3.1% (20,770,522) 3.1% (21,407,156) 3.1% (22,055,278) To Capital Improvement Fund (550,000) (880,000) One time costs (342,000) (297,461) (1,169,330) (411,000) (411,000) Other One time costs (13,500) (395,670) (193,000) (811,072) Additions to base budget (140,000) (45,000) (52,000) (8,000) Other additions to base (sal. study) (40,000) TOTAL EXPENDITURES: (17,298,732) (18,132,234) (19,463,233) (19,416,110) (19,781,780) (19,728,152) (20,957,068) (20,778,522) (21,407,156) (22,055,278) Year -End Adjustments (1,052) 4,712 177,000 Estimated carryover at 1.75% 339,782 346,181 345,243 366,749 363,624 374,625 385,967 Ending Fund Balance 2,762,006 3,593,450 4,184,346 3,901,410 4,677,103 4,448,536 3,568,035 3,442,424 3,287,570 3,101,389 Recomd. Reserves - 10% of Expend. 1,684,873 1,813,223 1,946,323 1,941,611 1,978,178 1,972,815 2,095,707 2,077,852 2,140,716 2,205,528 Revenue Stabilization Reserve 440,000 440,000 726,000 726,000 726,000 726,000 726,000 726,000 726,000 726,000 Reserved for one-time following year 417,250 516,000 104,000 1,004,072 811,072 Unreserved Fund Balance 637,133 922,977 996,023 1,129,799 968,853 938,649 746,328 638,572 420,854 169,861 Diff. in Rev and Expendi (no carryover): 93,012 826,732 (297,044) (833,481) 146,576 (573,810) (1,247,250) (489,235) (529,480) (572,149) increase in Base budget expenditures 3.4% 4.6% 3.9% Additions to Base 2019 2020 2021 .5 Fte deputy 45,000 increases for Deputies 52,000 8,000 (Sheriff deputies receive additional 1.75% in 2020 and additional 0.25% in 2021 in addition to calculated base) 2019 Budget Projection and Five -Year Budget Outlook July 12,2018 rev 2019 2019 202o 2020 2021 2021 2021 2022 2021 2022 GENERAL FUND 2014 2015 2017 2018 2018 Proj projected Proj projected Proj projected Proj projected Proj projected Actual Actual Actual Budget. projected Incr Budget incr Budget incr Budget incr Budget Incr Budget Beginning Fund Balance 2,670,046 2,762,006 4,304,390 4,395,109 4,184,346 4,619,136 4,390,568 3,568,035 3,442,424 3,287,570 Revenues 16,530,822 17,298,966 18,283,880 18,582,629 18,632,629 2.8% 19,154,343 2.9% 19,709,819 2.9% 20,289,287 2.9% 20,877,677 2.9% 21,483,129 Additional Sales Tax Projected One time funds Received 847,422 1,660,000 863,272 1,295,727 New Revenues Other One time revenues 13,500 19,037 TOTAL REVENUES 17,391,744 18,958,966 19,166,189 18,582,629 19,928,356 19,154,343 19,709,819 20,289,287 20,877,677 21,483,129 Expenditures Base Budget (16,393,232) (16,954,773) (18,293,903) (18,865,110) (18,935,110) 2.2% (19,490,152) 2.4% (20,093,996) 3.1% (20,770,522) 3.1% (21,407,156) 3.1% (22,055,278) To Capital Improvement Fund (550,000) (880,000) One time costs (342,000) (297,461) (1,169,330) (411,000) (411,000) Other One time costs (13,500) (454,670) (193,000) (752,072) Additions to base budget (140,000) (45,000) (52,000) (8,000) Other additions to base (sal. study) (40,000) TOTAL EXPENDITURES: (17,298,732) (18,132,234) (19,463,233) (19,416,110) (19,840,780) (19,728,152) (20,898,068) (20,778,522) (21,407,156) (22,055,278) Year -End Adjustments (1,052) 4,712 177,000 Estimated carryover at 1.75% 339,782 347,214 345,243 365,716 363,624 374,625 385,967 Ending Fund Balance 2,762,006 3,593,450 4,184,346 3,901,410 4,619,136 4,390,568 3,568,035 3,442,424 3,287,570 3,101,389 Recomd. Reserves - 10% of Expend. 1,684,873 1,813,223 1,946,323 1,941,611 1,984,078 1,972,815 2,089,807 2,077,852 2,140,716 2,205,528 Revenue Stabilization Reserve 440,000 440,000 726,000 726,000 726,000 726,000 726,000 726,000 726,000 726,000 Reserved for one-time following year 417,250 516,000 104,000 945,072 752,072 Unreserved Fund Balance 637,133 922,977 996,023 1,129,799 963,986 939,681 752,228 638,572 420,854 169,861 Diff. in Rev and Expendi (no carryover): 93,012 826,732 (297,044) (833,481) 87,576 (573,810) (1,188,250) (489,235) (529,480) (572,149) increase in Base budget expenditures 3.4% 4.6% 3.9% Additions to Base 2019 2020 2021 .5 Fte deputy 45,000 increases for Deputies 52,000 8,000 (Sheriff deputies receive additional 1.75% in 2020 and additional 0.25% in 2021 in addition to calculated base) 2018 Budget Projection and Five -Year Budget Outlook - Scenario 2 March 15, 2018 revised 2019 2019 2020 2020 2021 2021 2021 2022 2021 2022 GENERAL FUND 2015 2016 2017 2018 2018 Proj projected I Proj projected Proj projected I Proj projected Proj projected Bu Actual Actual Actual Budget* projected incr Budget incr Budget incr Budget incr Budget incr Budget Beginning Fund Balance 2,762,006 3,593,450 4,304,390 4,395,109 4,184,346 3,690,647 3,534,939 3,281,256 2,976,415 2,632,776 Revenues 17,298,966 17,702,654 18,283,880 18,582,629 18,582,629 2.8% 19,102,943 2.9% 19,656,928 2.9% 20,234,842 2.9% 20,821,652 2.9% 21,425,480 Additional Sales Tax Projected One time funds Received 1,660,000 1,574,362 863,272 New Revenues (levy shift) Other One time revenues 19,037 TOTAL REVENUES 18,958,966 19,277,016 19,166,189 18,582,629 18,582,629 19,102,943 19,656,928 20,234,842 20,821,652 21,425,480 Expenditures Base Budget (16,954,773) (17,489,670) (18,293,903) (18,865,110) (18,865,110) 3.1% (19,601,680) 3.1% (20,213,253) 3.1% (20,897,529) 3.1% (21,542,281) 3.1% (22,198,900) To Capital Improvement Fund (880,000) (300,000) One time costs (297,461) (782,500) (1,169,330) (411,000) (411,000) Other One time costs Additions to base budget (140,000) (140,000) (52,000) (8,000) Other additions to base TOTAL EXPENDITURES: (18,132,234) (18,572,170) (19,463,233) (19,416,110) (19,416,110) (19,601,680) (20,265,253) (20,905,529) (21,542,281) (22,198,900) Year -End Adjustments 4,712 6,094 177,000 Estimated carryover at 1.75% 339,782 339,782 343,029 354,642 365,847 376,990 388,481 Ending Fund Balance 3,593,450 4,304,390 4,184,346 3,901,410 3,690,647 3,534,939 3,281,256 2,976,415 2,632,776 2,247,836 Recomd. Reserves - 10% of Expend. 1,813,223 1,857,217 1,946,323 1,941,611 1,941,611 1,960,168 2,026,525 2,090,553 2,154,228 2,219,890 Revenue Stabilization Reserve 440,000 502,000 726,000 726,000 726,000 726,000 726,000 726,000 726,000 726,000 Reserved for one-time following year 417,250 607,000 516,000 104,000 104,000 Unreserved Fund Balance 922,977 1,338,173 996,023 1,129,799 919,036 848,771 528,730 159,862 (247,452) (698,054) Diff. in Rev and Expendi (no carryover): 826,732 704,846 (297,044) (833,481) (833,481) (498,738) (608,325) (670,687) (720,629) (773,420) Included in 2018 expenditures in this model is an is additional $140,000 for potential expenditures that are planned, but not included in the final budget. Scenario 2 - All Employees increase is approx 1.7% per year for years 2018 - 2023 Sheriff deputies and corrections receive additional 1.75% in 2020 and additional 0.25% in 2021 2018 Budget Projection and Five -Year Budget Outlook - Scenario 1 March 15, 2018 2019 2019 2020 2020 2021 2021 2021 2022 GENERAL FUND 2015 2016 2017 2018 2018 Prof projected Prof projected Proi projected Proi projected Bu Actual Actual Actual Budget** projected �ncr Budget Incr Budget Incr Budget Incr Budget Beginning Fund Balance 2,762,006 3,593,450 4,304,390 4,395,109 4,184,346 3,690,647 3,534,939 3,332,346 3,088,049 Revenues 17,298,966 17,702,654 18,283,880 18,582,629 18,582,629 2.8% 19,102,943 2.9% 19,656,928 2.9% 20,234,842 2.9% 20,821,652 Additional Sales Tax Projected One time funds Received 1,660,000 1,574,362 863,272 New Revenues (levy shift) Other One time revenues 19,037 TOTAL REVENUES 18,958,966 19,277,016 19,166,189 18,582,629 18,582,629 19,102,943 19,656,928 20,234,842 20,821,652 Expenditures Base Budget (16,954,773) (17,489,670) (18,293,903) (18,865,110) (18,865,110) 3.1% (19,601,680) 3.1% (20,213,253) 3.1% (20,843,906) 3.1% (21,478,736) To Capital Improvement Fund (880,000) (300,000) One time costs (297,461) (782,500) (1,169,330) (411,000) (411,000) Other One time costs Additions to base budget (140,000) (140,000) Other additions to base TOTAL EXPENDITURES: (18,132,234) (18,572,170) (19,463,233) (19,416,110) (19,416,110) (19,601,680) (20,213,253) (20,843,906) (21,478,736) Year -End Adjustments 4,712 6,094 177,000 Estimated carryover at 1.75% 339,782 339,782 343,029 353,732 364,768 375,878 Ending Fund Balance 3,593,450 4,304,390 4,184,346 3,901,410 3,690,647 3,534,939 3,332,346 3,088,049 2,806,843 Recomd. Reserves - 10% of Expend. 1,813,223 1,857,217 1,946,323 1,941,611 1,941,611 1,960,168 2,021,325 2,084,391 2,147,874 Revenue Stabilization Reserve 440,000 502,000 726,000 726,000 726,000 726,000 726,000 726,000 726,000 Reserved for one-time following year 417,250 607,000 516,000 104,000 104,000 Unreserved Fund Balance 922,977 1,338,173 996,023 1,129,799 919,036 848,771 585,020 277,659 (67,031) Diff. in Rev and Expendi (no carryover): 826,732 704,846 (297,044) (833,481) (833,481) (498,738) (556,325) (609,065) (657,084) Included in 2018 expenditures in this model is an is additional $140,000 for potential expenditures that are planned, but not included in the final budget. Scenario 1 - All union and exempt increase is approx 1.7% per year for years 2018 - 2023 2018 Budget Projection and Five -Year Budget Outlook December 6, 2017 2018 2018 2019 2019 2020 2020 2021 2021 2021 2022 GENERAL FUND 2014 2015 2016 2017 2017 Proj projected Proj projected Proj projected Proj projected Proj projected Actual Actual Actual Budget Projected Incr Budget" incr Budget incr Budget incr Budget Incr Budget Beginning Fund Balance 2,670,046 2,762,006 3,593,450 4,113,545 4,304,390 4,391,795 3,898,096 3,742,388 3,539,795 3,295,498 Revenues 16,530,822 17,298,966 17,702,654 18,041,838 18,056,838 1.9% 18,582,629 2.8% 19,102,943 2.9% 19,656,928 2.9% 20,234,842 2.9% 20,821,652 Additional Sales Tax Projected 186,000 One time funds Received 847,422 1,660,000 1,574,362 863,272 New Revenues (levy shift) Other One time revenues 13,500 TOTAL REVENUES 17,391,744 18,958,966 19,277,016 18,041,838 19,106,110 18,582,629 19,102,943 19,656,928 20,234,842 20,821,652 Expenditures Base Budget (16,393,232) (16,954,773) (17,489,670) (18,152,507) (18,152,507) 3.9% (18,865,110) 3.1% (19,601,680) 3.1% (20,213,253) 3.1% (20,843,906) 3.1% (21,478,736) To Capital Improvement Fund (550,000) (880,000) (300,000) One time costs (342,000) (297,461) (782,500) (479,330) (1,169,330) (411,000) Other One time costs (13,500) Additions to base budget (202,000) (35,000) (140,000) Other additions to base TOTAL EXPENDITURES: (17,298,732) (18,132,234) (18,572,170) (18,833,837) (19,356,837) (19,416,110) (19,601,680) (20,213,253) (20,843,906) (21,478,736) Year -End Adjustments (1,052) 4,712 6,094 Estimated carryover at 1.75% 279,478 338,132 339,782 343,029 353,732 364,768 375,878 Ending Fund Balance 2,762,006 3,593,450 4,304,390 3,601,024 4,391,795 3,898,096 3,742,388 3,539,795 3,295,498 3,014,292 Recomd. Reserves - 10% of Expend. 1,684,873 1,813,223 1,857,217 1,863,184 1,932,184 1,941,611 1,960,168 2,021,325 2,084,391 2,147,874 Revenue Stabilization Reserve 440,000 440,000 502,000 600,000 726,000 726,000 726,000 726,000 726,000 726,000 Reserved for one-time following year 417,250 607,000 127,000 516,000 104,000 Unreserved Fund Balance 637,133 922,977 1,338,173 1,010,840 1,217,611 1,126,485 1,056,220 792,469 485,108 140,419 Diff. in Rev and Expendi (no carryover): 93,012 826,732 704,846 (791,999) (250,727) (833,481) (498,738) (556,325) (609,065) (657,084) Included in 2018 expenditures in this model is an is additional $140,000 for potential expenditures that are planned, but not included in the final budget. 2018 Budget Projection and Five -Year Budget Outlook November 20, 2017 2018 2018 2019 2019 2020 2020 2021 2021 2021 2022 GENERAL FUND 2014 2015 2016 2017 2017 Proj projected Proj projected Proj projected Proj projected Proj projected Actual Actual Actual Budget Projected Incr Budget" incr Budget incr Budget incr Budget Incr Budget Beginning Fund Balance 2,670,046 2,762,006 3,593,450 4,113,545 4,304,390 4,391,795 3,879,484 3,717,416 3,517,857 3,286,586 Revenues 16,530,822 17,298,966 17,702,654 18,041,838 18,056,838 2.0% 18,605,358 2.8% 19,126,308 2.9% 19,680,971 2.9% 20,259,592 2.9% 20,847,120 Additional Sales Tax Projected 186,000 One time funds Received 847,422 1,660,000 1,574,362 863,272 New Revenues (levy shift) Other One time revenues 13,500 TOTAL REVENUES 17,391,744 18,958,966 19,277,016 18,041,838 19,106,110 18,605,358 19,126,308 19,680,971 20,259,592 20,847,120 Expenditures Base Budget (16,393,232) (16,954,773) (17,489,670) (18,152,507) (18,152,507) 4.2% (18,907,187) 3.1% (19,631,936) 3.1% (20,234,636) 3.1% (20,855,839) 3.1% (21,496,114) To Capital Improvement Fund (550,000) (880,000) (300,000) One time costs (342,000) (297,461) (782,500) (479,330) (1,169,330) (411,000) Other One time costs (13,500) Additions to base budget (202,000) (35,000) (140,000) Other additions to base TOTAL EXPENDITURES: (17,298,732) (18,132,234) (18,572,170) (18,833,837) (19,356,837) (19,458,187) (19,631,936) (20,234,636) (20,855,839) (21,496,114) Year -End Adjustments (1,052) 4,712 6,094 Estimated carryover at 1.75% 279,478 338,132 340,518 343,559 354,106 364,977 376,182 Ending Fund Balance 2,762,006 3,593,450 4,304,390 3,601,024 4,391,795 3,879,484 3,717,416 3,517,857 3,286,586 3,013,774 Recomd. Reserves - 10% of Expend. 1,684,873 1,813,223 1,857,217 1,863,184 1,932,184 1,945,819 1,963,194 2,023,464 2,085,584 2,149,611 Revenue Stabilization Reserve 440,000 440,000 502,000 600,000 726,000 726,000 726,000 726,000 726,000 726,000 Reserved for one-time following year 417,250 607,000 127,000 516,000 104,000 Unreserved Fund Balance 637,133 922,977 1,338,173 1,010,840 1,217,611 1,103,666 1,028,222 768,393 475,002 138,163 Diff. in Rev and Expendi (no carryover): 93,012 826,732 704,846 (791,999) (250,727) (852,829) (505,628) (553,665) (596,248) (648,994) Included in 2018 expenditures in this model is an is additional $140,000 for potential expenditures that are planned, but not included in the final budget. 2018 Budget Projection and Five -Year Budget Outlook draft 10-26-17 (revised 3:00 p.m.) 2017 zols 2018 2019 2019 2020 2020 2021 2021 2021 2022 GENERAL FUND 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 Final 2017 Proj projected Proj projected Proi projected Proi projected Proi projected Actual Actual Actual Actual Actual Actual Actual Actual Actual Actual Budge Projected lncr Budget lncr Budget lncr Budget lncr Budget lncr Bud et 1 Beginning Fund Balance 2,480,323 3,317,256 2,799,352 2,381,014 2,324,208 2,988,072 2,507,002 2,670,046 2,762,006 3,593,450 4,113,545 4,304,390 4,414,393 3,872,896 3,713,697 3,518,889 3,286,466 2 Revenues 14,175,115 14,761,000 14,752,219 14,830,905 15,178,836 15,531,807 15,854,760 16,530,822 17,298,966 17,702,654 18,041,838 18,056,838 2.1% 18,531,637 3.0% 19,170,975 2.9% 19,734,602 2.9% 20,314,799 2.9% 20,903,928 3 Additional Sales Tax Projected 186,000 90,000 a One time funds Received 830,000 847,422 1,660,000 1,574,362 863,272 5 New Revenues (levy shift) 216,000 219,550 6 Other One time revenues 197,000 927,000 255,000 13,500 7 TOTAL REVENUES 14,175,115 14,761,000 14,752,219 15,243,905 16,325,386 15,531,807 16,939,760 17,391,744 18,958,966 19,277,016 18,041,838 19,106,110 18,621,637 19,170,975 19,734,602 20,314,799 20,903,928 8 9 Expenditures Base Budget (13,838,182) (15,280,080) (14,919,557) (15,300,711) (15,086,522) (15,522,786) (15,691,716) (16,393,232) (16,954,773) (17,449,670) (18,152,507) (18,152,507) 4.3% (18,931,462) 3.1 % (19,674,478) 3.1 % (20,284,387) 3.1 % (20,913,203) 3.1 % (21,561,512) 10 To Capital Improvement Fund (251,000) (325,000) (100,000) (400,000) (550,000) (880,000) (300,000) 11 One time costs (169,000) (430,000) (342,000) (297,461) (782,500) (479,330) (1,146,330) (416,000) 12 Other One time costs (255,000) (13,500) 13 Additions to base budget (40,000) (202,000) (35,000) (92,000) 14 Other additions to base (65,000) 15 TOTAL EXPENDITURES: (13,838,182) (15,280,080) (15,170,557) (15,300,711) (15,661,522) (16,016,786) (16,776,716) (17,298,732) (18,132,234) (18,572,170) (18,833,837) (19,333,837) (19,504,462) (19,674,478) (20,284,387) (20,913,203) (21,561,512) 16 Year -End Adjustments (1,052) 4,712 6,094 17 Interfund Loan Reimb. 500,000 18 Estimated carryover at 1.5% 279,478 337,730 341,328 344,303 354,977 365,981 377,326 19 Ending Fund Balance 3,317,256 2,798,176 2,381,014 2,324,208 2,988,072 2,503,093 2,670,046 2,762,006 3,593,450 4,304,390 3,601,024 4,414,393 3,872,896 3,713,697 3,518,889 3,286,466 3,006,210 ecom mended 10% of Expend. 1,383,818 1,528,008 1,491,956 1,530,071 1,566,152 1,601,679 1,677,672 1,684,873 1,813,223 1,857,217 1,863,184 1,929,884 1,950,446 1,967,448 2,028,439 2,091,320 2,156,151 420 21 en Reenue Stabilization Reserve 100,000 100,000 440,000 440,000 440,000 502,000 600,000 726,000 726,000 726,000 726,000 726,000 726,000 22 r one-ti expend in following year 494,942 100,000 417,250 607,000 127,000 416,000 23 Unreserved Fund Balance 1,933,438 1,270,168 889,058 794,137 826,978 701,414 552,374 637,133 922,977 1,338,173 1,010,840 1,342,509 1,196,450 1,020,249 764,450 469,146 124,058 24 25 carryover est. 1.5% 1.5% 1.5% 1.5% 1.5% 1.5% 1.75% 1.75% 1.75% 1.75% 1.75% 1.75% 26 27 Diff. in Rev and Expendi (no carryo% 336,933 (519,080) (167,338) (56,806) 663,864 (484,979) 163,044 93,012 826,732 704,846 (791,999) (227,727) (882,825) (503,502) (549,785) (598,403) (657,583) 28 29 Difference in Base Rev & Expend. 336,933 (519,080) (167,338) (469,806) 92,314 9,021 163,044 137,590 344,193 212,984 (312,669) 55,331 (466,825) 30 31 days of cash reserve 87 67 57 55 70 57 58 58 72 85 70 83 72 69 63 57 51 32 days of cash res. w/o 1 time 58 55 64 73 67 75 33 34 Base Revenues over prior year 4.1 % -0.1 % 0.5% 2.3% 2.3% 2.1 % 4.3% 4.6% 2.3% 1.9% 3.1 % 2.1 % 2.9% 2.9% 2.9% 2.9% 35 Base Expenditures over prior year 10.4% -2.4% 2.6% -1.4% 2.9% 1.1 % 4.5% 3.4% 3.2% 5.0% 4.0% 5.0% 3.1 % 3.1 % 3.1 % 3.1 % 36 (no capital transfers or one-time) -----Includes base budget adds in expend % calculation------ 37 38 fund balance as a percent of base expenditures 39 24.0% 18.3% 16.0% 15.2% 19.8% 16.1 % 17.0% 16.8% 21.2% 24.7% 20.1 % 24.4% 20.6% 18.9% 17.3% 15.7% 13.9% 40 unreserved fund balance plus revenue stabilization reserve as a percent of base expenditures 41 14.0% 8.3% 6.0% 5.2% 6.1 % 5.2% 6.3% 6.6% 8.0% 10.6% 9.0% 11.4% 10.2% 8.9% 7.3% 5.7% 3.9% NOTES: 2011 first year of sales tax (1/2 year) 2010 and 2011 - 502K was transferred from SW equip. fund to cap imp to cover debt 2014 first year of PUD privilege tax - partial year 2018 Budget Projection and Five -Year Budget Outlook draft 10-26-17 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 2017 2019 2018 2019 2019 2020 2020 2021 2021 2021 2022 GENERAL FUND 2007 2008 2009 2010 2011 2012 2013 2014 I 2015 I 2016 Final 2017 Proi projected Proi projected Proi projected Proi projected Proi projected Actual Actual Actual Actual Actual Actual Actual Actual Actual Actual Budge Projected lncr Budget lncr Budget lncr Budget lncr Budget lncr Budget Beginning Fund Balance 2,480,323 3,654,189 2,799,352 2,381,014 2,324,208 2,988,072 2,507,002 2,670,046 2,762,006 3,593,450 4,113,545 4,304,390 4,414,393 3,872,896 3,713,697 3,518,889 3,286,466 Revenues 14,175,115 14,761,000 14,752,219 14,830,905 15,178,836 15,531,807 15,854,760 16,530,822 17,298,966 17,702,654 18,041,838 18,056,838 2.1% 18,531,637 3.0% 19,170,975 2.9% 19,734,602 2.9% 20,314,799 2.9% 20,903,928 Additional Sales Tax Projected 186,000 90,000 One time funds Received 830,000 847,422 1,660,000 1,574,362 863,272 New Revenues (levy shift) 216,000 219,550 Other One time revenues 197,000 927,000 255,000 13,500 TOTAL REVENUES 14,175,115 14,761,000 14,752,219 15,243,905 16,325,386 15,531,807 16,939,760 17,391,744 18,958,966 19,277,016 18,041,838 19,106,110 18,621,637 19,170,975 19,734,602 20,314,799 20,903,928 Expenditures Base Budget (13,838,182) (15,280,080) (14,919,557) (15,300,711) (15,086,522) (15,522,786) (15,691,716) (16,393,232) (16,954,773) (17,449,670) (18,152,507) (18,152,507) 4.3% (18,931,462) 3.1 % (19,674,478) 3.1 % (20,284,387) 3.1 % (20,913,203) 3.1 % (21,561,512) To Capital Improvement Fund (251,000) (325,000) (100,000) (400,000) (550,000) (880,000) (300,000) One time costs (169,000) (430,000) (342,000) (297,461) (782,500) (479,330) (1,146,330) (416,000) Other One time costs (255,000) (13,500) Additions to base budget (40,000) (202,000) (35,000) (92,000) Other additions to base (65,000) TOTAL EXPENDITURES: (13,838,182) (15,280,080) (15,170,557) (15,300,711) (15,661,522) (16,016,786) (16,776,716) (17,298,732) (18,132,234) (18,572,170) (18,833,837) (19,333,837) (19,504,462) (19,674,478) (20,284,387) (20,913,203) (21,561,512) Year -End Adjustments (1,052) 4,712 6,094 Estimated carryover at 1.5% 279,478 337,730 341,328 344,303 354,977 365,981 377,326 Ending Fund Balance 3,654,189 2,616,029 2,381,014 2,324,208 2,988,072 2,503,093 2,670,046 2,762,006 3,593,450 4,304,390 3,601,024 4,414,393 3,872,896 3,713,697 3,518,889 3,286,466 3,006,210 Recommended 10% of Expend. 1,383,818 1,528,008 1,491,956 1,530,071 1,566,152 1,601,679 1,677,672 1,684,873 1,813,223 1,857,217 1,863,184 1,929,884 1,950,446 1,967,448 2,028,439 2,091,320 2,156,151 Revenue Stabilization Reserve 100,000 100,000 440,000 440,000 440,000 502,000 600,000 726,000 726,000 726,000 726,000 726,000 726,000 one-time expend in following year 494,942 100,000 417,250 607,000 127,000 416,000 Unreserved Fund Balance 2,270,371 19088,021 889,058 794,137 8269978 701,414 552,374 637,133 9229977 1,338,173 19010,840 1,3429509 1,1969450 1,020,249 764,450 469,146 1249058 carryover est. 1.5% 1.5% 1.5% 1.5% 1.5% 1.5% 1.75% 1.75% 1.75% 1.75% 1.75% 1.75% Diff. in Rev and Expendi (no carryo% 336,933 (519,080) (167,338) (56,806) 663,864 (484,979) 163,044 93,012 826,732 704,846 (791,999) (227,727) (882,825) (503,502) (549,785) (598,403) (657,583) 27 Difference in Base Rev & Expend. 336,933 (519,080) (167,338) (469,806) 92,314 9,021 163,044 137,590 28 days of cash reserve 96 62 57 55 70 57 58 58 29 days of cash res. w/o 1 time 58 55 30 Base Revenues over prior year 4.1 % -0.1 % 0.5% 2.3% 2.3% 2.1 % 4.3% 31 Base Expenditures over prior year 10.4% -2.4% 2.6% -1.4% 2.9% 1.1 % 4.5% 32 (no capital transfers or one-time) fund balance as a percent of expenditures 33 26.4% 17.1 % 15.7% 15.2% 19.1 % 15.6% 15.9% 16.0% unreserved fund balance as a percent of expenditures 34 16.4% 7.1 % 6.0% 5.2% 5.5% 4.5% 3.5% 3.9% NOTES: 2011 first year of sales tax (1/2 year) 2010 and 2011 - 502K was transferred from SW equip. fund to cap imp to cover debt 344,193 252,984 (110,669) 90,331 (309,825) 72 85 70 83 72 69 63 57 51 64 73 67 75 4.6% 2.3% 1.9% 3.1 % 2.1 % 2.9% 2.9% 2.9% 2.9% 3.4% 3.2% 5.0% 4.0% 5.0% 3.1 % 3.1 % 3.1 % 3.1 % -----Includes base budget adds in expend % calculation------ 19.8% 23.2% 19.1 % 22.8% 19.9% 18.9% 17.3% 15.7% 13.9% 5.4% 7.7% 5.6% 7.4% 6.3% 5.2% 3.8% 2.2% 0.6% 2018 Budget Projection and Five -Year Budget Outlook draft 10-16-17 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 2017 2019 2018 2019 2019 2020 2020 2021 2021 2021 2022 GENERAL FUND 2007 2008 2009 2010 2011 2012 2013 2014 I 2015 I 2016 Final 2017 Proi projected Proi projected Proi projected Proi projected Proi projected Actual Actual Actual Actual Actual Actual Actual Actual Actual Actual Budge Projected lncr Budget lncr Budget lncr Budget lncr Budget lncr Budget Beginning Fund Balance 2,480,323 3,317,256 2,799,352 2,381,014 2,324,208 2,988,072 2,507,002 2,670,046 2,762,006 3,593,450 4,113,545 4,304,390 4,414,393 3,445,508 3,091,426 2,892,193 2,851,709 Revenues 14,175,115 14,761,000 14,752,219 14,830,905 15,178,836 15,531,807 15,854,760 16,530,822 17,298,966 17,702,654 18,041,838 18,056,838 2.1% 18,531,637 3.0% 19,170,975 2.9% 19,734,602 2.9% 20,314,799 2.9% 20,903,928 Additional Sales Tax Projected 186,000 90,000 One time funds Received 830,000 847,422 1,660,000 1,574,362 863,272 New Revenues (levy shift) 216,000 219,550 Other One time revenues 197,000 927,000 255,000 13,500 TOTAL REVENUES 14,752,219 15,243,905 16,325,386 15,531,807 16,939,760 17,391,744 18,958,966 19,277,016 18,041,838 19,106,110 18,621,637 19,170,975 19,734,602 20,314,799 20,903,928 Expenditures Base Budget (13,838,182) (15,280,080) (14,919,557) (15,300,711) (15,086,522) (15,522,786) (15,691,716) (16,393,232) (16,954,773) (17,449,670) (18,152,507) (18,152,507) 4.3% (18,931,462) 3.1 % (20,122,832) 3.1 % (20,488,890) 3.1 % (20,917,846) 3.1 % (21,360,099) To Capital Improvement Fund (251,000) (325,000) (100,000) (400,000) (550,000) (880,000) (300,000) One time costs (169,000) (430,000) (342,000) (297,461) (782,500) (479,330) (1,146,330) (416,000) Other One time costs (255,000) (13,500) Additions to base budget (40,000) (202,000) (35,000) (92,000) 250,000 200,000 200,000 200,000 Other additions to base (500,000) TOTAL EXPENDITURES: (15,170,557) (15,300,711) (15,661,522) (16,016,786) (16,776,716) (17,298,732) (18,132,234) (18,572,170) (18,833,837) (19,333,837) (19,939,462) (19,872,832) (20,288,890) (20,717,846) (21,160,099) Year -End Adjustments (1,052) 4,712 6,094 Estimated carryover at 1.5% 279,478 337,730 348,941 347,775 355,056 362,562 370,302 Ending Fund Balance 3,317,256 2,798,176 2,381,014 2,324,208 2,988,072 2,503,093 2,670,046 2,762,006 3,593,450 4,304,390 3,601,024 4,414,393 3,445,508 3,091,426 2,892,193 2,851,709 2,965,840 Recommended 10% of Expend. 1,383,818 1,528,008 1,491,956 1,530,071 1,566,152 1,601,679 1,677,672 1,684,873 1,813,223 1,857,217 1,863,184 1,929,884 1,993,946 1,987,283 2,028,889 2,071,785 2,116,010 Revenue Stabilization Reserve 100,000 100,000 440,000 440,000 440,000 502,000 600,000 726,000 726,000 726,000 726,000 726,000 726,000 one-time expend in following year 494,942 100,000 417,250 607,000 127,000 416,000 Unreserved Fund Balance 1,933,438 1,270,168 889,058 794,137 826,978 701,414 552,374 637,133 922,977 1,338,173 1,010,840 1,342,509 725,562 378,143 137,304 53,925 123,831 carryover est. 1.5% 1.5% 1.5% 1.5% 1.5% 1.5% 1.75% 1.75% 1.75% 1.75% 1.75% 1.75% Diff. in Rev and Expendi (no carryo% 336,933 (519,080) (167,338) (56,806) 663,864 (484,979) 163,044 93,012 826,732 704,846 (791,999) (227,727) (1,317,825) (701,857) (554,288) (403,046) (256,170) 27 Difference in Base Rev & Expend. 336,933 (519,080) (167,338) (469,806) 92,314 9,021 163,044 137,590 344,193 252,984 (110,669) 90,331 (309,825) 28 days of cash reserve 87 67 57 55 70 57 58 58 72 85 70 83 63 57 52 50 51 29 days of cash res. w/o 1 time 58 55 64 73 67 75 30 Base Revenues over prior year 4.1 % -0.1 % 0.5% 2.3% 2.3% 2.1 % 4.3% 4.6% 2.3% 1.9% 3.1 % 2.1 % 2.9% 2.9% 2.9% 2.9% 31 Base Expenditures over prior year 10.4% -2.4% 2.6% -1.4% 2.9% 1.1 % 4.5% 3.4% 3.2% 5.0% 4.0% 7.3% 3.1 % 3.1 % 3.1 % 3.1 % 32 (no capital transfers or one-time) -----Includes base budget adds in expend % calculation------ fundbalance as a percent of expenditures 33 24.0% 18.3% 15.7% 15.2% 19.1 % 15.6% 15.9% 16.0% 19.8% 23.2% 19.1 % 22.8% 17.3% 15.6% 14.3% 13.8% 14.0% NOTES: (52,969) 2011 first year of sales tax (1/2 year) 2010 and 2011 - 502K was transferred from SW equip. fund to cap imp to cover debt