Loading...
HomeMy Public PortalAboutBrewster Financial Forecast FY16-FY254:49 PM12/2/2019 Brewster Financial Forecast FY16-FY25 *for informational purposes only* FY 2016 Budget FY 2016 Actuals FY 2017 Budget FY 2017 Actuals FY 2018 Budget FY 2018 Actuals FY 2019 Budget FY 2019 Actuals FY 2020 Budget FY 2021 Projection FY 2022 Projection FY 2023 Projection FY 2024 Projection FY 2025 Projection REVENUES Real Estate Taxes Prior Yr Property Tax Limit 27,622,908 27,622,908 28,517,123 28,517,123 29,589,263 29,589,263 30,648,080 30,648,080 31,766,927 33,179,671 34,184,163 35,188,767 36,218,486 37,273,948 2.5% Levy Growth 690,573 690,573 712,928 712,928 739,732 739,732 766,202 766,202 794,173 829,492 854,604 879,719 905,462 931,849 New Growth 203,642 203,642 359,212 359,212 319,085 319,085 354,749 354,749 309,571 175,000 150,000 150,000 150,000 150,000 Potential Operating Override 0 0 0 0 0 0 0 0 309,000 0 0 0 0 0 Levy Limit 28,517,123 28,517,123 29,589,263 29,589,263 30,648,080 30,648,080 31,769,031 31,769,031 33,179,671 34,184,163 35,188,767 36,218,486 37,273,948 38,355,797 Debt Exclusions- Town 979,348 979,348 761,949 761,949 1,462,481 1,462,481 1,931,715 1,931,715 2,388,797 1,602,115 1,554,665 1,504,215 1,454,765 1,411,315 Debt Exclusions- Schools 0 0 0 0 0 0 0 0 0 416,500 416,500 416,500 416,500 416,500 Nauset HS Building Debt Exclusion 0 0 0 0 0 0 0 0 0 0 3,387,682 3,387,711 3,387,398 3,386,643 Cape Cod Comm. Asses. +2.5%149,025 149,025 152,751 152,751 156,807 156,807 160,727 160,727 168,354 172,563 176,877 181,299 185,831 190,477 Current Yr Property Tax Levy 29,645,496 29,645,496 30,503,963 30,503,963 32,267,368 32,267,368 33,861,473 33,861,473 35,736,822 36,375,341 40,724,491 41,708,211 42,718,442 43,760,732 Other Revenues Cherry Sheet (State Aid) +1.5%1,738,130 1,753,639 1,788,487 1,803,736 1,823,400 1,816,675 1,840,629 1,843,319 1,868,238 1,896,262 1,924,706 1,953,577 1,982,880 2,012,623 Estimated Local Receipts 3,841,999 4,710,901 3,900,277 4,981,841 4,821,120 5,369,046 5,134,184 5,641,090 4,608,942 4,797,593 5,157,413 5,544,218 5,960,035 6,407,037 Short Term Rentals Revenue 0 0 0 0 0 0 0 0 0 250,000 250,000 250,000 250,000 250,000 Free Cash 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Overlay Surplus 375,000 375,000 125,000 125,000 0 0 0 0 50,000 0 0 0 0 0 Transfers In To General Fund Waterways RRFA 0 0 0 0 0 0 0 0 5,000 0 0 0 0 0 Cable RRFA 12,000 12,000 13,000 13,000 0 0 0 0 7,200 7,200 7,200 7,200 7,200 7,200 Telecomm. Revolving +2.5%66,300 66,300 67,626 67,626 0 0 0 0 65,000 66,625 68,291 69,998 71,748 73,542 Road Betterments RRFA 165,819 165,819 145,882 145,882 0 0 0 0 151,436 102,623 88,235 79,785 76,735 63,710 Ambulance RRFA 298,810 298,810 300,410 300,410 0 0 0 0 0 448,550 459,764 471,258 483,039 495,115 Transfer fr Special Revenue 398,253 398,253 365,953 365,953 0 0 0 0 154,400 0 0 0 0 0 Bond Premium Amortization 0 0 47,814 47,814 0 0 0 0 35,810 32,371 28,931 25,492 22,053 18,614 Indirect Costs from Water +2%0 0 0 0 0 0 0 0 0 130,000 132,600 135,252 137,957 140,716 Indirect Costs from Golf +2%0 0 0 0 0 0 0 0 0 100,000 102,000 104,040 106,121 108,243 TOTAL REVENUES 36,541,807 37,426,218 37,258,412 38,355,225 38,911,888 39,453,089 40,836,286 41,345,882 42,682,848 44,206,564 48,943,630 50,349,031 51,816,210 53,337,533 EXPENDITURES Cherry Sheet Charges +1.5%599,255 636,425 656,880 611,991 635,036 657,501 679,088 615,511 624,563 633,931 643,440 653,092 662,888 672,832 Overlay Reserve +2.5%400,000 412,995 400,000 436,078 200,000 216,477 200,000 211,554 400,000 250,000 256,250 262,656 269,223 275,953 Operating Budget General Govt 1,946,446 1,789,171 2,013,959 1,791,960 2,125,908 1,954,177 2,339,099 2,119,077 2,143,191 2,158,755 2,171,123 2,183,752 2,196,646 2,209,812 Public Safety 5,129,014 5,020,002 5,307,505 5,192,549 5,256,274 5,218,174 5,447,941 5,374,323 5,874,780 6,342,920 6,353,902 6,365,104 6,376,530 6,388,184 Education +2.5%17,817,809 17,275,649 17,983,836 17,352,360 18,440,571 17,709,775 19,130,846 18,504,660 19,591,056 20,080,832 20,582,853 21,097,425 21,624,860 22,165,482 Public Works 1,626,464 1,625,790 1,787,379 1,714,798 1,848,681 1,950,561 2,080,586 1,934,113 1,892,521 1,954,101 2,019,513 2,035,246 2,051,306 2,067,702 Human Services 540,249 535,344 583,080 568,983 703,465 695,681 755,990 749,734 839,506 849,849 860,297 870,852 881,516 892,291 Culture & Recreation 696,566 685,639 711,924 706,498 803,774 798,220 892,494 868,383 910,426 915,080 919,828 924,670 929,610 934,648 Debt 1,168,462 1,168,909 1,445,918 1,669,624 1,509,449 1,614,449 2,313,310 2,233,660 2,899,521 2,284,085 5,582,691 5,516,045 5,461,768 5,393,251 Local Assessments 0 0 0 0 11,280 11,280 12,190 12,190 15,840 15,840 16,157 16,480 16,810 17,146 Employee Benefits 4,939,408 4,810,102 5,310,580 5,178,097 5,488,935 5,327,971 5,826,281 5,614,244 6,365,746 7,315,373 8,314,902 9,318,375 10,379,778 11,503,431 Utilites 2%482,816 403,238 430,088 365,104 337,123 289,636 456,473 374,315 417,171 425,514 434,025 442,705 451,559 460,590 Liability Insurance 391,689 389,991 460,050 421,309 426,616 421,409 437,789 387,455 393,000 412,605 433,189 454,802 477,494 501,320 Subtotal Operating Expenses:34,738,923 33,703,835 36,034,319 34,961,282 36,952,077 35,991,333 39,692,999 38,172,153 41,342,758 42,754,956 47,688,481 49,225,455 50,847,877 52,533,857 TOTAL EXPENDITURES 35,738,178 34,753,255 37,091,199 36,009,352 37,787,113 36,865,311 40,572,087 38,999,218 42,367,321 43,638,887 48,588,171 50,141,204 51,779,988 53,482,642 REVENUES less EXPENDITURES 803,629 2,672,963 167,213 2,345,873 1,124,775 2,587,778 264,199 2,346,664 315,527 567,677 355,459 207,827 36,222 -145,109 Brewster Financial Forecast FY16-FY25 *for informational purposes only* FY 2016 Budget FY 2016 Actual FY 2017 Budget FY 2017 Actual FY20 18 Budget FY 2018 Actual FY 2019 Budget FY 2019 Actual FY 2020 Budget FY 2021 Estimate FY 2022 Estimate FY 2023 Estimate FY2024 Estimate FY2025 Estimate General Government 114 Moderator S & W 300 300 300 300 300 300 300 300 300 300 300 300 300 300 Subtotal 300 300 300 300 300 300 300 300 300 300 300 300 300 300 122 Selectmen S & W 425,332 423,761 380,848 377,039 394,447 394,181 458,202 449,950 430,942 430,942 430,942 430,942 430,942 430,942 Oper Exp 51,615 48,265 66,860 54,517 55,355 52,836 57,855 51,974 49,350 50,337 51,344 52,371 53,418 54,486 Subtotal 476,947 472,025 447,708 431,556 449,802 447,016 516,057 501,924 480,292 481,279 482,286 483,313 484,360 485,428 128 Greenhead Fly S & W Oper Exp 1,250 1,250 1,250 1,250 1,250 1,250 3,000 3,000 1,750 1,785 1,821 1,857 1,894 1,932 Subtotal 1,250 1,250 1,250 1,250 1,250 1,250 3,000 3,000 1,750 1,785 1,821 1,857 1,894 1,932 131 Finance Committee S & W 4,500 5,865 5,450 4,402 1,000 3,484 4,700 4,566 4,700 4,700 4,700 4,700 4,700 4,700 Oper Exp 600 220 250 231 4,700 293 0 254 0 Subtotal 5,100 6,085 5,700 4,633 5,700 3,777 4,700 4,821 4,700 4,700 4,700 4,700 4,700 4,700 133 Reserve Fund Oper Exp 103,800 0 106,395 0 100,000 0 100,000 0 100,000 102,500 105,063 107,689 110,381 113,141 +2.5% Subtotal 103,800 0 106,395 0 100,000 0 100,000 0 100,000 102,500 105,063 107,689 110,381 113,141 135 Accountant S & W 172,869 172,868 192,604 180,278 156,091 157,923 275,886 209,315 188,757 188,757 188,757 188,757 188,757 188,757 Oper Exp 27,690 24,126 45,690 36,785 30,961 47,627 41,065 100,523 38,065 38,826 39,603 40,395 41,203 42,027 Subtotal 200,559 196,995 238,294 217,063 187,052 205,550 316,951 309,838 226,822 227,583 228,360 229,152 229,960 230,784 141 Assessor Dept S & W 127,638 127,637 138,279 138,101 137,858 133,194 115,356 105,276 117,807 117,807 117,807 117,807 117,807 117,807 Oper Exp 2,265 1,791 2,850 1,711 79,150 84,861 81,950 68,316 12,500 12,750 13,005 13,265 13,530 13,801 Subtotal 129,903 129,429 141,129 139,812 217,008 218,056 197,306 173,593 130,307 130,557 130,812 131,072 131,337 131,608 147 Treasurer/Collector S & W 225,034 220,982 238,855 234,780 235,625 224,176 238,541 238,134 250,870 250,870 250,870 250,870 250,870 250,870 Oper Exp 26,185 20,167 25,445 14,641 25,445 14,176 24,845 16,671 24,845 25,342 25,849 26,366 26,893 27,431 Subtotal 251,219 241,149 264,300 249,421 261,070 238,353 263,386 254,805 275,715 276,212 276,719 277,236 277,763 278,301 151 Legal Oper Exp 181,600 154,249 165,640 137,436 165,600 137,025 165,640 113,497 175,640 179,153 182,736 186,391 190,118 193,921 Subtotal 181,600 154,249 165,640 137,436 165,600 137,025 165,640 113,497 175,640 179,153 182,736 186,391 190,118 193,921 155 Information Technology S & W 90,363 90,363 93,311 93,311 95,647 95,868 98,463 98,463 101,896 101,896 101,896 101,896 101,896 101,896 Oper Exp 74,899 74,899 78,916 78,910 122,756 99,655 163,555 160,051 124,551 127,042 129,583 132,175 134,818 137,514 Subtotal 165,262 165,262 172,227 172,221 218,403 195,523 262,018 258,513 226,447 228,938 231,479 234,071 236,714 239,410 161 Clerk S & W 127,410 127,389 139,188 136,734 135,784 136,000 150,140 148,727 153,157 153,157 153,157 153,157 153,157 153,157 Oper Exp 22,115 20,832 28,357 26,659 30,750 25,847 29,125 27,889 23,625 24,098 24,579 25,071 25,572 26,084 Subtotal 149,525 148,220 167,545 163,393 166,534 161,847 179,265 176,616 176,782 177,255 177,736 178,228 178,729 179,241 163 Registrar S & W 9,100 8,576 9,000 8,971 9,024 7,992 9,000 8,464 9,000 9,000 9,000 9,000 9,000 9,000 Subtotal 9,100 8,576 9,000 8,971 9,024 7,992 9,000 8,464 9,000 9,000 9,000 9,000 9,000 9,000 175 Planning S & W 147,277 135,033 163,332 136,864 164,436 162,066 157,646 152,736 169,315 169,315 169,315 169,315 169,315 169,315 Oper Exp 3,655 1,997 3,750 1,325 5,690 1,486 4,060 2,078 2,000 2,040 2,081 2,122 2,165 2,208 Subtotal 150,932 137,030 167,082 138,189 170,126 163,552 161,706 154,814 171,315 171,355 171,396 171,437 171,480 171,523 192 Public Buildings S & W 100,949 100,945 104,039 98,451 127,254 128,291 131,412 131,277 135,763 135,763 135,763 135,763 135,763 135,763 Oper Exp 15,500 23,428 18,500 24,801 46,785 45,645 28,358 27,616 28,358 28,925 29,504 30,094 30,696 31,310 Subtotal 116,449 124,374 122,539 123,252 174,039 173,936 159,770 158,893 164,121 164,688 165,267 165,857 166,459 167,073 193 Drummer Boy Museum Oper Exp 500 358 850 731 0 0 0 0 0 0 0 0 0 0 Subtotal 500 358 850 731 0 0 0 0 0 0 0 0 0 0 195 Town Reports Oper Exp 4,000 3,871 4,000 3,733 0 0 0 0 0 0 0 0 0 0 Subtotal 4,000 3,871 4,000 3,733 0 0 0 0 0 0 0 0 0 0 Total General Government S & W 1,430,772 1,413,719 1,465,206 1,409,230 1,457,467 1,443,475 1,639,646 1,547,207 1,562,507 1,565,957 1,565,957 1,565,957 1,565,957 1,565,957 Oper Exp 515,674 375,452 548,753 382,730 668,442 510,702 699,453 571,869 580,684 592,798 605,166 617,795 630,689 643,855 Total 1,946,446 1,789,171 2,013,959 1,791,960 2,125,908 1,954,177 2,339,099 2,119,077 2,143,191 2,158,755 2,171,123 2,183,752 2,196,646 2,209,8124:49 PM12/2/2019 Page 6 of 73 Brewster Financial Forecast FY16-FY25 *for informational purposes only* FY 2016 Budget FY 2016 Actual FY 2017 Budget FY 2017 Actual FY20 18 Budget FY 2018 Actual FY 2019 Budget FY 2019 Actual FY 2020 Budget FY 2021 Estimate FY 2022 Estimate FY 2023 Estimate FY2024 Estimate FY2025 Estimate Public Safety 210 Police S & W 2,309,823 2,268,548 2,397,800 2,396,217 2,474,178 2,450,517 2,534,690 2,527,139 2,702,091 2,702,091 2,702,091 2,702,091 2,702,091 2,702,091 Oper Exp 104,900 141,647 120,400 125,170 124,020 121,054 132,020 110,408 132,520 135,170 137,874 140,631 143,444 146,313 Subtotal 2,414,723 2,410,195 2,518,200 2,521,387 2,598,198 2,571,571 2,666,710 2,637,547 2,834,611 2,837,261 2,839,965 2,842,722 2,845,535 2,848,404 220 Fire & Rescue S & W 1,805,474 1,716,523 1,870,782 1,763,454 1,816,789 1,815,369 1,791,996 1,791,996 2,108,680 2,323,680 2,323,680 2,323,680 2,323,680 2,323,680 Oper Exp 229,490 227,464 231,990 232,847 91,715 91,785 197,700 187,815 95,050 335,172 341,875 348,713 355,687 362,801 Subtotal 2,034,964 1,943,987 2,102,772 1,996,300 1,908,504 1,907,155 1,989,696 1,979,811 2,203,730 2,658,852 2,665,556 2,672,393 2,679,367 2,686,481 241 Building S & W 376,240 372,480 374,960 366,487 384,275 380,874 402,995 394,529 413,583 413,583 413,583 413,583 413,583 413,583 Oper Exp 5,710 5,150 6,050 4,892 6,050 5,390 6,025 3,479 6,025 6,146 6,268 6,394 6,522 6,652 Subtotal 381,950 377,630 381,010 371,379 390,325 386,265 409,020 398,008 419,608 419,729 419,851 419,977 420,105 420,235 244 Weights & Measures S & W Oper Exp 9,000 9,180 9,364 9,551 9,742 Subtotal 0 0 0 0 0 0 0 0 0 9,000 9,180 9,364 9,551 9,742 296 Natural Resources S & W 250,277 246,120 258,423 258,097 267,731 274,924 290,151 285,344 354,467 354,467 354,467 354,467 354,467 354,467 Oper Exp 47,100 42,069 47,100 45,386 91,516 78,260 92,364 73,613 62,364 63,611 64,884 66,181 67,505 68,855 Subtotal 297,377 288,189 305,523 303,483 359,247 353,184 382,515 358,958 416,831 418,078 419,351 420,648 421,972 423,322 Total Public Safety S & W 4,741,814 4,603,671 4,901,965 4,784,254 4,942,973 4,921,684 5,019,832 4,999,008 5,578,821 5,793,821 5,793,821 5,793,821 5,793,821 5,793,821 Oper Exp 387,200 416,330 405,540 408,295 313,301 296,490 428,109 375,315 295,959 549,099 560,081 571,283 582,708 594,363 Total 5,129,014 5,020,002 5,307,505 5,192,549 5,256,274 5,218,174 5,447,941 5,374,323 5,874,780 6,342,920 6,353,902 6,365,104 6,376,530 6,388,184 Education 300 300 Stony Brook Elementary 3,762,836 3,467,103 3,850,598 3,557,868 3,923,926 3,546,742 3,879,124 3,640,549 3,955,634 4,054,525 4,155,888 4,259,785 4,366,280 4,475,437 301 NRSD Assessment 9,770,277 9,770,277 9,684,955 9,684,955 9,953,157 9,953,157 10,397,696 10,397,696 10,812,935 11,083,258 11,360,340 11,644,348 11,935,457 12,233,843 excluded debt taken out 301 NRSD Capital 221,897 221,897 222,435 221,897 231,451 231,451 241,705 241,705 247,133 253,311 259,644 266,135 272,789 279,608 +2.5% 302 CCT Assessment 723,538 723,538 828,976 828,976 831,711 831,711 845,458 845,458 753,875 772,722 792,040 811,841 832,137 852,940 excluded debt taken out 317 Eddy Elementary 3,339,261 3,092,834 3,396,872 3,058,664 3,500,326 3,146,714 3,766,863 3,379,252 3,821,479 3,917,016 4,014,941 4,115,315 4,218,198 4,323,653 Total Education 17,817,809 17,275,649 17,983,836 17,352,360 18,440,571 17,709,775 19,130,846 18,504,660 19,591,056 20,080,832 20,582,853 21,097,425 21,624,860 22,165,482 Public Works 422 DPW Administration S & W 1,018,308 981,917 1,168,139 987,366 1,095,134 1,047,150 1,118,360 1,090,026 1,259,522 1,204,853 1,204,853 1,204,853 1,204,853 1,204,853 Oper Exp 604,156 639,874 614,640 723,326 593,392 636,570 801,936 691,834 627,484 584,979 647,679 660,632 673,845 687,322 +50K in FY21 & FY22 for solid waste Subtotal 1,622,464 1,621,790 1,782,779 1,710,692 1,688,526 1,683,720 1,920,296 1,781,859 1,887,006 1,789,832 1,852,532 1,865,485 1,878,698 1,892,175 423 Snow & Ice S & W 0 0 0 0 50,800 60,941 50,800 48,201 54,669 54,669 54,669 54,669 54,669 S&I budget included in highway '20 budget Oper Exp 0 0 0 0 103,975 202,233 103,975 100,800 103,975 106,574 109,239 111,970 114,769 Subtotal 0 0 0 0 154,775 263,174 154,775 149,001 0 158,644 161,243 163,908 166,639 169,438 424 Sreet Lighting S & W Oper Exp 4,000 4,000 4,600 4,106 5,380 3,667 5,515 3,252 5,515 5,625 5,738 5,853 5,970 6,089 Subtotal 4,000 4,000 4,600 4,106 5,380 3,667 5,515 3,252 5,515 5,625 5,738 5,853 5,970 6,089 Total Public Works S & W 1,018,308 981,917 1,168,139 987,366 1,145,934 1,108,091 1,169,160 1,138,226 1,259,522 1,259,522 1,259,522 1,259,522 1,259,522 1,259,522 Oper Exp 608,156 643,874 619,240 727,432 702,747 842,470 911,426 795,886 632,999 694,579 759,991 775,724 791,784 808,180 Total 1,626,464 1,625,790 1,787,379 1,714,798 1,848,681 1,950,561 2,080,586 1,934,113 1,892,521 1,954,101 2,019,513 2,035,246 2,051,306 2,067,702 Human Services 510 Board of Health S & W 197,497 197,184 203,926 203,486 210,190 211,284 219,898 220,311 233,925 233,925 233,925 233,925 233,925 233,925 Oper Exp 22,547 21,951 22,383 21,470 22,442 21,349 24,278 24,084 25,968 26,487 27,017 27,557 28,109 28,671 Subtotal 220,044 219,135 226,309 224,956 232,632 232,632 244,176 244,395 259,893 260,412 260,942 261,482 262,034 262,596 541 Council on Aging S & W 199,641 199,640 226,523 226,046 236,930 238,026 244,698 244,420 316,235 316,235 316,235 316,235 316,235 316,235 Oper Exp 30,424 27,938 30,074 26,389 23,275 18,526 38,775 38,295 27,190 32,290 37,390 42,490 47,590 52,690 Subtotal 230,065 227,578 256,597 252,435 260,205 256,552 283,473 282,715 343,425 348,525 353,625 358,725 363,825 368,925 543 Veteran's Services Oper Exp 90,140 88,631 100,174 91,592 89,668 85,787 102,601 96,883 107,554 109,705 111,899 114,137 116,420 118,7484:49 PM12/2/2019 Page 7 of 73 Brewster Financial Forecast FY16-FY25 *for informational purposes only* FY 2016 Budget FY 2016 Actual FY 2017 Budget FY 2017 Actual FY20 18 Budget FY 2018 Actual FY 2019 Budget FY 2019 Actual FY 2020 Budget FY 2021 Estimate FY 2022 Estimate FY 2023 Estimate FY2024 Estimate FY2025 Estimate Subtotal 90,140 88,631 100,174 91,592 89,668 85,787 102,601 96,883 107,554 109,705 111,899 114,137 116,420 118,748 560 Local Funding / Public Assistance Oper Exp 0 0 0 0 120,960 120,710 125,740 125,740 128,634 131,207 133,831 136,507 139,238 142,022 Subtotal 0 0 0 0 120,960 120,710 125,740 125,740 128,634 131,207 133,831 136,507 139,238 142,022 Total Human Services S & W 397,138 396,824 430,449 429,532 447,120 449,309 464,596 464,731 550,160 550,160 550,160 550,160 550,160 550,160 Oper Exp 143,111 138,520 152,631 139,451 256,345 246,372 291,394 285,002 289,346 299,689 310,137 320,692 331,356 342,131 Total 540,249 535,344 583,080 568,983 703,465 695,681 755,990 749,734 839,506 849,849 860,297 870,852 881,516 892,291 Culture & Recreation 610 Library S & W 411,309 404,892 413,749 412,443 452,940 447,100 476,272 447,323 483,267 483,267 483,267 483,267 483,267 483,267 Oper Exp 139,519 135,438 143,429 141,343 162,835 163,940 167,170 176,797 173,275 176,741 180,275 183,881 187,558 191,310 Subtotal 550,828 540,330 557,178 553,786 615,775 611,040 643,442 624,120 656,542 660,008 663,542 667,148 670,825 674,577 630 Recreation S & W 114,463 114,165 118,671 118,671 123,849 123,845 180,702 177,119 189,489 189,489 189,489 189,489 189,489 189,489 Oper Exp 12,625 12,515 12,925 12,923 13,400 13,404 12,950 12,954 8,995 9,175 9,358 9,546 9,736 9,931 Subtotal 127,088 126,680 131,596 131,594 137,249 137,249 193,652 190,073 198,484 198,664 198,847 199,035 199,225 199,420 635 Golf S & W 0 0 0 0 0 0 0 0 0 0 Oper Exp 0 0 0 0 0 0 0 Total 0 0 0 0 0 0 0 0 0 0 0 0 0 0 660 Local Funding Oper Exp 0 0 4,500 4,500 34,000 34,000 35,000 35,000 35,000 35,700 36,414 37,142 37,885 38,643 Subtotal 0 0 4,500 4,500 34,000 34,000 35,000 35,000 35,000 35,700 36,414 37,142 37,885 38,643 691 OKH Intergovernmental Oper Exp 9,750 9,750 9,750 9,750 9,750 9,750 9,950 9,950 9,950 10,149 10,352 10,559 10,770 10,986 Subtotal 9,750 9,750 9,750 9,750 9,750 9,750 9,950 9,950 9,950 10,149 10,352 10,559 10,770 10,986 692 Memorial/ Veterans Day Oper Exp 1,500 1,500 1,500 1,500 1,000 1,000 1,500 1,500 1,500 1,530 1,561 1,592 1,624 1,656 Subtotal 1,500 1,500 1,500 1,500 1,000 1,000 1,500 1,500 1,500 1,530 1,561 1,592 1,624 1,656 698 Arts Council Oper Exp 0 0 0 0 0 0 600 300 600 612 624 637 649 662 Subtotal 0 0 0 0 0 0 600 300 600 612 624 637 649 662 699 Old Mill Sites Committee S & W 0 0 0 0 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 Oper Exp 4,000 4,000 4,000 3,552 2,500 2,500 2,500 2,484 2,500 2,550 2,601 2,653 2,706 2,760 Subtotal 4,000 4,000 4,000 3,552 2,500 2,500 2,500 2,484 2,500 2,550 2,601 2,653 2,706 2,760 297 Alewives Committee S & W 2,500 2,500 2,500 2,500 1,100 1,097 3,450 3,450 3,450 3,450 3,450 3,450 3,450 3,450 Oper Exp 900 879 900 -684 900 84 900 6 900 918 936 955 974 994 Subtotal 3,400 3,379 3,400 1,817 2,000 1,181 4,350 3,456 4,350 4,368 4,386 4,405 4,424 4,444 Total Culture & Recreation S & W 528,272 521,557 534,920 533,614 579,389 573,542 661,924 629,392 677,706 677,706 677,706 677,706 677,706 677,706 Oper Exp 168,294 164,083 177,004 172,884 224,385 224,678 230,570 238,991 232,720 237,374 242,122 246,964 251,904 256,942 Total 696,566 685,639 711,924 706,498 803,774 798,220 892,494 868,383 910,426 915,080 919,828 924,670 929,610 934,648 Debt Service 700 Debt Service Oper Exp 1,168,462 1,168,909 1,445,918 1,669,624 1,509,449 1,614,449 2,313,310 2,233,660 2,288,229 0 0 0 0 0 Debt for Wtr & Golf is subtracted Exempt Debt 1,602,115 1,554,665 1,504,215 1,454,765 1,411,315 Exempt Debt- School 611,292 416,500 416,500 416,500 416,500 416,500 amounts are not actual Non-Exempt Debt 234,870 192,633 175,783 170,633 145,670 Nauset HS- EXEMPT 3,387,682 3,387,711 3,387,398 3,386,643 20 year level debt @ 4.25% Debt Costs 30,600 31,212 31,836 32,473 33,122 Total Debt Service 1,168,462 1,168,909 1,445,918 1,669,624 1,509,449 1,614,449 2,313,310 2,233,660 2,899,521 2,284,085 5,582,691 5,516,045 5,461,768 5,393,251 4:49 PM12/2/2019 Page 8 of 73 Brewster Financial Forecast FY16-FY25 *for informational purposes only* FY 2016 Budget FY 2016 Actual FY 2017 Budget FY 2017 Actual FY20 18 Budget FY 2018 Actual FY 2019 Budget FY 2019 Actual FY 2020 Budget FY 2021 Estimate FY 2022 Estimate FY 2023 Estimate FY2024 Estimate FY2025 Estimate Other Expenses & Assessments 840 Local Assessments & Charges Oper Exp 0 0 0 0 11,280 11,280 12,190 12,190 15,840 15,840 16,157 16,480 16,810 17,146 Total Assessment 0 0 0 0 11,280 11,280 12,190 12,190 15,840 15,840 16,157 16,480 16,810 17,146 Employee Benefits & Insurance 910 Empl. Benefits and Other Insurance Health Ins +5%, +7%2,914,365 2,797,687 3,243,594 3,138,287 3,266,638 3,173,976 3,532,014 3,298,936 3,788,614 3,978,045 4,256,508 4,554,463 4,873,276 5,214,405 +5% in '21, then +7% thereafter Health Ins -Tri -Town +5%, +7%12,075 12,920 13,825 14,792 15,828 +5% in '21, then +7% thereafter Life +3%0 0 0 0 2,791 2,669 2,909 2,874 7,065 7,277 7,495 7,720 7,952 8,190 Medicare +4%180,843 188,110 195,181 184,614 195,148 189,446 198,097 203,957 214,646 223,232 232,161 241,448 251,105 261,150 Unemployment +2%24,661 4,781 13,674 -334 72,000 13,370 31,000 47,817 54,070 55,151 56,254 57,380 58,527 59,698 Health Ins Opt Out Stipend 21,000 21,000 21,000 21,000 21,000 7 people @ 3K each Sick Leave Incentive 0 0 0 0 0 0 0 0 12,500 13,500 13,500 13,500 13,500 13,500 actual amount paid in '20 $13,500 Union Wage Step Increases +2%175,000 354,375 538,234 726,690 919,857 Wage Adjustments ('COLA') +2.5%241,030 488,086 741,318 1,000,881 1,266,933 2.5%; subject to results of Wage & Compensation study Subtotal 3,119,869 2,990,578 3,452,449 3,322,566 3,536,577 3,379,461 3,764,020 3,553,584 4,064,395 4,275,780 4,565,339 4,874,835 5,205,652 5,559,270 911 Retiremement / Pension Contribution Transfer to OPEB 50,000 50,000 75,000 75,000 55,000 55,000 100,000 100,000 200,000 250,000 300,000 300,000 300,000 300,000 *Start at 250K for '21, then 300K ongoing Retirement Assessment +12%, +10% 1,764,301 1,764,333 1,783,131 1,780,531 1,846,223 1,846,221 1,959,661 1,959,661 2,084,351 2,334,473 2,567,920 2,824,712 3,107,184 3,417,902 +12% for FY21, then +10% ongoing Actuarial Services 0 0 0 0 2,600 2,600 2,600 1,000 4,500 4,590 4,682 4,775 4,871 4,968 State Liability 238 191 0 0 222 0 0 0 0 Deferred Comp- Town Admin. 5,000 5,000 0 0 0 0 0 0 0 Contractual Obligations 0 0 0 0 48,314 44,689 0 0 0 0 0 0 0 0 Subtotal 1,819,539 1,819,523 1,858,131 1,855,531 1,952,359 1,948,510 2,062,261 2,060,661 2,288,851 2,589,063 2,872,602 3,129,488 3,412,055 3,722,870 Total Benefits & Insurance 4,939,408 4,810,102 5,310,580 5,178,097 5,488,935 5,327,971 5,826,281 5,614,244 6,353,246 6,864,843 7,437,941 8,004,323 8,617,707 9,282,141 Utilities 940 Utilities Electricity 157,198 107,368 157,199 112,141 124,350 88,094 119,134 81,933 102,181 104,225 106,309 108,435 110,604 112,816 Natural Gas 48,200 35,865 47,200 33,712 44,030 29,494 39,095 33,189 36,250 36,975 37,715 38,469 39,238 40,023 Gasoline 87,420 74,525 61,451 54,591 75,000 75,841 85,352 66,940 72,000 73,440 74,909 76,407 77,935 79,494 Diesel 73,760 59,740 48,738 43,090 60,000 58,262 69,574 68,918 73,000 74,460 75,949 77,468 79,018 80,598 Telephone 66,000 61,169 66,000 52,555 63,000 1,120 61,190 59,773 62,000 63,240 64,505 65,795 67,111 68,453 Postage 33,000 33,609 32,000 34,026 -62,307 29,080 32,803 29,010 32,500 33,150 33,813 34,489 35,179 35,883 CVEC 5,950 13,141 6,200 27,572 13,750 1,801 36,612 25,495 28,000 28,560 29,131 29,714 30,308 30,914 Heating Fuel 8,488 5,807 8,500 3,559 7,300 4,819 6,567 6,795 7,040 7,181 7,324 7,471 7,620 7,773 System Repairs 2,800 12,013 2,800 3,858 12,000 1,125 6,146 2,262 4,200 4,284 4,370 4,457 4,546 4,637 Subtotal 482,816 403,238 430,088 365,104 337,123 289,636 456,473 374,315 417,171 425,514 434,025 442,705 451,559 460,590 Liability Insurance 945 Liability Insurance Workers Compensation +5%159,518 159,518 183,446 190,570 196,800 155,774 193,238 191,762 200,000 210,000 220,500 231,525 243,101 255,256 removed 17K for Golf Bonds +2%1,290 1,185 1,290 925 1,400 1,150 1,400 1,689 1,500 1,530 1,561 1,592 1,624 1,656 Fire/ Police Accident +5%47,438 51,362 53,930 40,132 59,400 50,180 54,774 55,391 -15,000 -15,750 -16,538 -17,364 -18,233 -19,144 General Liability +5%183,443 177,926 221,384 189,682 169,016 214,305 188,377 138,613 206,500 216,825 227,666 239,050 251,002 263,552 removed 75K for Golf Subtotal 391,689 389,991 460,050 421,309 426,616 421,409 437,789 387,455 393,000 412,605 433,189 454,802 477,494 501,320 TOTAL SALARIES/WAGES 8,116,304.00 7,917,687.37 8,500,679.00 8,143,996.12 8,572,882.86 8,496,101.89 8,955,158.00 8,778,564.73 9,641,216.08 10,297,696.08 10,724,126.83 11,161,218.35 11,609,237.16 12,068,456.43 TOTAL EXPENSES 26,622,619 25,786,148 27,533,640 26,817,286 28,379,194 27,495,231 30,737,841 29,393,588 31,701,542 32,457,260 36,964,354 38,064,237 39,238,640 40,465,400 GRAND TOTAL 34,738,923 33,703,835 36,034,319 34,961,282 36,952,077 35,991,333 39,692,999 38,172,153 41,342,758 42,754,956 47,688,481 49,225,455 50,847,877 52,533,857 4:49 PM12/2/2019 Page 9 of 73