Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My Public Portal
About
Budget Projection
FY2018 BUDGET PROJECTION •BUDGET / ATM TIMELINE •MUNICIPAL FINANCIAL FORECAST •GENERAL FUND OPERATING EXPENSE SUMMARY Town of Brewster 2198 Main Street Brewster, MA 02631 2017 Election/Town Meeting Schedule ANNUAL TOWN MEETING May 1st, 2017 Last day to register to vote: April 11th ~~ Open until 8pm. Last day to post warrant: April 10th Warrant Closes: February 15th ANNUAL TOWN ELECTION May 16th, 2017 Last day to obtain nomination papers: March 24th ~~ Open until 5pm. Last day to submit nomination papers: March 28th ~~ Open until 5pm. Last day to submit proposition 2 ½ questions to the Town Clerk: April 11th Last day to withdraw nomination papers: April 13th ~~ Open until 5pm. Last day to register to vote: April 26th ~~ Open until 8pm. Last day to post warrant: May 9th SPECIAL TOWN MEETING November 13th, 2017 Due to Thanksgiving Last day to post warrant: October 23rd (Bylaw) Last day to register to vote: November 3rd ~~Open until 8pm. FY2013 ACTUALS FY2014 ACTUALS FY2015 ACTUALS FY2016 ACTUALS FY2017 BUDGET FY2018 PROJECTION FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION 1 33,931,460$ 35,821,626$ 36,591,043$ 37,787,660$ 38,157,952$ 40,354,345$ 38,781,567$ 39,765,840$ 40,628,004$ 41,704,497$ 2 6,760,019$ 6,813,918$ 6,770,247$ 7,500,706$ 7,630,084$ 8,537,766$ 8,180,449$ 8,325,681$ 8,473,506$ 8,623,971$ 3 602,219$ 643,671$ 629,681$ 658,686$ 661,483$ 664,320$ 667,173$ 670,042$ 672,926$ 675,827$ 4 1,011,568$ 1,968,144$ 1,492,914$ 1,282,929$ 1,687,931$ 1,424,149$ 1,103,144$ 1,135,997$ 1,168,772$ 1,202,367$ 5 175,383$ 346,913$ 126,886$ 451,789$ 309,599$ 445,620$ 445,620$ 445,620$ 445,620$ 445,620$ 42,480,649$ 45,594,272$ 45,610,771$ 47,681,771$ 48,447,049$ 51,426,200$ 49,177,952$ 50,343,179$ 51,388,828$ 52,652,283$ FY2013 ACTUALS FY2014 ACTUALS FY2015 ACTUALS FY2016 ACTUALS FY2017 BUDGET FY2018 PROJECTION FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION 1 29,952,443$ 31,266,491$ 32,294,248$ 34,771,683$ 35,345,672$ 36,735,125$ 37,109,034$ 37,974,591$ 38,728,517$ 39,692,099$ 2 5,262,211$ 5,023,949$ 5,290,247$ 5,234,042$ 6,139,276$ 6,603,598$ 6,656,124$ 6,711,002$ 5,772,050$ 5,810,130$ 3 500,845$ 700,157$ 598,048$ 530,675$ 924,174$ 681,432$ 914,177$ 670,042$ 640,926$ 675,827$ 4 627,178$ 1,911,994$ 2,545,942$ 1,024,808$ 1,429,441$ 1,424,149$ 1,103,144$ 1,135,997$ 1,168,772$ 1,202,367$ 5 242,771$ 205,159$ 153,896$ 172,409$ 152,222$ 152,090$ 138,250$ 134,240$ 125,162$ 96,107$ 36,585,448$ 39,107,749$ 40,882,381$ 41,733,616$ 43,990,785$ 45,596,394$ 45,920,728$ 46,625,872$ 46,435,427$ 47,476,529$ FY2013 ACTUALS FY2014 ACTUALS FY2015 ACTUALS FY2016 ACTUALS FY2017 BUDGET FY2018 PROJECTION FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION 1 1,955,243$ 2,935,011$ 2,446,879$ 2,537,275$ 2,014,349$ 2,734,615$ 130,600$ 80,600$ 80,600$ 80,600$ 2 925,551$ 1,872,262$ 1,655,256$ 2,001,728$ 1,527,583$ 1,508,256$ 1,790,100$ 1,724,100$ 1,697,100$ 1,744,900$ 3 -$ 25,000$ 32,500$ 7,500$ 32,000$ -$ 32,000$ -$ 32,000$ -$ 4 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 5 160,880$ 218,345$ 329,136$ 526,975$ 152,561$ 247,920$ 247,920$ 247,920$ 247,920$ 247,920$ 3,041,674$ 5,050,618$ 4,463,771$ 5,073,478$ 3,726,493$ 4,490,791$ 2,200,620$ 2,052,620$ 2,057,620$ 2,073,420$ FY2013 ACTUALS FY2014 ACTUALS FY2015 ACTUALS FY2016 ACTUALS FY2017 BUDGET FY2018 PROJECTION FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION 1 976,026$ 1,065,562$ 1,051,391$ 1,268,557$ 1,152,516$ 884,605$ 894,466$ 904,441$ 914,532$ 924,740$ 2 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 3 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 4 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 5 Road Betterments -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 976,026$ 1,065,562$ 1,051,391$ 1,268,557$ 1,152,516$ 884,605$ 894,466$ 904,441$ 914,532$ 924,740$ 40,603,147$ 45,223,929$ 46,397,543$ 48,075,651$ 48,869,794$ 50,971,789$ 49,015,814$ 49,582,933$ 49,407,580$ 50,474,690$ 1,877,502$ 370,343$ (786,772)$ (393,880)$ (422,744)$ 454,411$ 162,138$ 760,246$ 1,981,248$ 2,177,593$ 1. ESTIMATED REVENUES RESOURCES TOWN OF BREWSTER FINANCIAL FORECAST FISCAL YEAR 2018 (April 18, 2017) MUNICIPAL BUDGET Special Revenue Funds - Community Preservation Road & Water Betterments Sub-total Operating Budgets Special Revenue Funds - Community Preservation Special Revenue Funds - Receipts Reserved for Appropriation General Fund Special Revenue Funds - Receipts Reserved for Appropriation Special Revenue Funds - Revolving Funds Road & Water Betterments Sub-total Warrant Article Budgets B. Warrant Articles for Annual & Special Town Meeting Deficit will result in a requirement for either a Prop 2 1/2 Override, new revenue source, budget reductions or a combination thereof. C. Other Special Charges & Assessments 2. GRAND TOTAL ESTIMATED EXPENDITURES 3. PROJECTED SURPLUS OR (DEFICIT*) Adjusted Surplus or Deficit Sub-total Charges & Assessments General Fund Special Revenue Funds - Receipts Reserved for Appropriation Special Revenue Funds - Revolving Funds 1. GRAND TOTAL ESTIMATED REVENUES General Fund Operating Expenses Special Revenue Funds - Revolving Funds Special Revenue Funds - Community Preservation A. Operating Budgets 2. ESTIMATED EXPENDITURES General Fund Revenues Special Revenue Funds - Receipts Reserved for Appropriation Special Revenue Funds - Revolving Funds Special Revenue Funds - Community Preservation Road & Water Betterments 4/18/2017 Page 1 of 14 FY2012 ACTUALS FY2013 ACTUALS FY2014 ACTUALS FY2015 ACTUALS FY2016 ACTUALS FY2017 BUDGET FY2018 PROJECTION FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION 1 23,407,563$ 24,903,654$ 25,889,558$ 26,787,992$ 27,622,908$ 28,517,123$ 29,589,263$ 30,503,995$ 31,416,595$ 32,327,009$ 33,260,185$ 2 585,189$ 622,591$ 647,239$ 669,700$ 690,573$ 712,928$ 739,732$ 762,600$ 785,415$ 808,175$ 831,505$ 3 109,038$ 164,313$ 224,366$ 165,216$ 203,642$ 359,212$ 175,000$ 150,000$ 125,000$ 125,000$ 125,000$ 4 Proposition 2 1/2 Operating Override 799,522$ 199,000$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 5 (101,413)$ (141,284)$ 221,109$ 178,705$ 979,348$ 761,949$ 612,325$ 587,625$ 569,825$ 387,025$ 375,825$ 6 -$ -$ -$ -$ -$ -$ 255,000$ -$ -$ -$ -$ 7 134,520$ 144,224$ 142,731$ 146,299$ 149,025$ 152,751$ 155,806$ 158,922$ 162,101$ 165,343$ 168,649$ 24,934,419$ 25,892,498$ 27,125,003$ 27,947,912$ 29,645,496$ 30,503,963$ 31,527,126$ 32,163,142$ 33,058,935$ 33,812,552$ 34,761,164$ Projected Excess 38,822$ 136,919$ 23,726$ 31,221$ 354,165$ 139,225$ 24,895,597$ 25,755,580$ 27,101,277$ 27,916,691$ 29,291,330$ 30,364,738$ 31,527,126$ 32,163,142$ 33,058,935$ 33,812,552$ 34,761,164$ FY2012 ACTUALS FY2013 ACTUALS FY2014 ACTUALS FY2015 ACTUALS FY2016 ACTUALS FY2017 BUDGET FY2018 PROJECTION FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION 1 1,760,242$ 2,345,339$ 2,378,406$ 2,228,681$ 1,748,800$ 1,800,457.00$ 1,824,079$ 1,833,200$ 1,842,366$ 1,851,578$ 1,860,835$ 2 1,158,083$ 1,215,487$ 1,334,770$ 1,350,026$ 1,411,479$ 1,190,000$ 1,482,053$ 1,556,156$ 1,633,963$ 1,715,662$ 1,801,445$ b. Other Excise Tax 1,104,555$ 1,148,779$ 1,265,366$ 1,257,868$ 1,310,046$ 1,178,700$ 1,318,650$ 1,377,066$ 1,438,070$ 1,501,777$ 1,568,305$ 131,767$ 151,331$ 127,868$ 183,757$ 177,214$ 87,000$ 171,400$ 181,256$ 191,678$ 202,699$ 214,354$ 6,846$ 6,861$ 6,870$ 6,873$ 6,878$ 6,800$ 6,878$ 6,878$ 6,878$ 6,878$ 6,878$ 598,632$ 395,786$ 529,997$ 537,122$ 527,386$ 412,074$ 525,100$ 506,196$ 487,973$ 470,406$ 453,472$ f. Fees 131,140$ 103,357$ 90,745$ 131,185$ 108,957$ 90,000$ 104,800$ 111,717$ 119,090$ 126,950$ 135,329$ g. Rentals 59,060$ 51,652$ 65,488$ 61,506$ 77,560$ 50,000$ 70,914$ 74,694$ 78,675$ 82,868$ 87,285$ h. Departmental Revenue 42,313$ 29,971$ 19,300$ 109,806$ 155,455$ 42,000$ 151,595$ 156,370$ 161,296$ 166,377$ 171,618$ i. License & Permits 678,877$ 718,892$ 777,199$ 820,807$ 766,727$ 632,000$ 737,780$ 645,558$ 564,863$ 494,255$ 432,473$ j. Special Assessments 34,609$ 23,085$ 12,731$ 11,423$ 11,041$ 16,519$ 10,277$ 12,302$ 14,725$ 17,626$ 21,098$ k. Fines & Forfeits 14,859$ 29,806$ 31,306$ 38,922$ 33,099$ 23,000$ 33,105$ 34,926$ 36,847$ 38,873$ 41,011$ l. Investment Income 24,957$ 22,153$ 21,648$ 20,231$ 135,760$ 20,000$ 71,283$ 74,847$ 78,590$ 82,519$ 86,645$ m. Medicaid Reimbursement -$ 21,636$ 42,304$ 38,074$ 49,639$ 30,000$ 42,000$ 46,200$ 50,820$ 55,902$ 61,492$ 81,919$ -$ -$ -$ -$ -$ 1,050$ 1,061$ 1,071$ 1,082$ 1,093$ o. Miscellaneous Non-Recurring 11,819$ 224,396$ 280,215$ 165,120$ 37,581$ 122,184$ -$ -$ -$ -$ -$ 3 544,696$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 4 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 6,384,374$ 6,488,530$ 6,984,212$ 6,961,401$ 6,557,621$ 5,700,734$ 6,550,964$ 6,618,425$ 6,706,905$ 6,815,452$ 6,943,334$ FY2012 ACTUALS FY2013 ACTUALS FY2014 ACTUALS FY2015 ACTUALS FY2016 ACTUALS FY2017 BUDGET FY2018 PROJECTION FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION 1 994,825$ 1,664,851$ 1,696,137$ 1,647,058$ 1,757,763$ 1,935,480$ 1,089,100$ -$ -$ -$ -$ 2 Overlay Surplus 50,000$ 22,500$ 40,000$ 65,893$ 180,946$ 157,000$ 300,000$ -$ -$ -$ -$ 3 Repurpose old articles (completed and/or closed)-$ -$ -$ -$ -$ -$ 100,127$ 4 Borrowing -$ -$ -$ -$ -$ -$ 634,938$ 5 -$ -$ -$ -$ -$ -$ 152,090$ -$ -$ -$ -$ 1,044,825$ 1,687,351$ 1,736,137$ 1,712,951$ 1,938,709$ 2,092,480$ 2,276,255$ -$ -$ -$ -$ 32,324,796$ 33,931,460$ 35,821,626$ 36,591,043$ 37,787,660$ 38,157,952$ 40,354,345$ 38,781,567$ 39,765,840$ 40,628,004$ 41,704,497$ 1. ESTIMATED REVENUES RESOURCES A. Property Tax: Projected Excess Capacity Future Debt Exclusion Prior Year Levy Limit Proposition 2 1/2 Increase New Growth (Estimate for Future Years) Debt Exclusion Cape Cod Commission Levy Exclusion Maximum Allowable Tax Levy TOWN OF BREWSTER FINANCIAL FORECAST GENERAL FUND FISCAL YEAR 2018 (April 18, 2017) Property Tax Levy Sub-total B. Estimated Local Receipt Categories: State Local Aid Town Local Receipts MSBA State Grant Reimbursement (Eddy School Capital) a. Motor Vehicle Excise c. Penalties & Interest on Taxes and Excise d. Payments in Lieu of Taxes e. Charges for Services (Transfer Station) n. Miscellaneous Recurring MLBC State Grant Reimbursement (BLLibrary) C. Other Available Funds (One Time Source / Not Guaranteed Each Year): Other Available Funds Sub-total 1. GRAND TOTAL ESTIMATED REVENUES Estimated Receipts Sub-total Free Cash Road Betterment (Offset LT and ST Notes) 4/18/2017 Page 2 of 14 TOWN OF BREWSTER FINANCIAL FORECAST GENERAL FUND FISCAL YEAR 2018 (April 18, 2017) FY2012 ACTUALS FY2013 ACTUALS FY2014 ACTUALS FY2015 ACTUALS FY2016 ACTUALS FY2017 BUDGET FY2018 PROJECTION FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION 1 6,768,609$ 7,094,598$ 7,314,961$ 7,533,193$ 7,917,435$ 8,184,329$ 8,118,978$ 8,224,406$ 8,331,099$ 8,439,072$ 8,548,341$ 2 1,781,674$ 2,499,612$ 2,637,602$ 2,769,839$ 2,562,758$ 2,443,244$ 2,800,032$ 2,900,032$ 3,001,033$ 3,103,043$ 3,206,073$ 3 Elementary School Operating Budget Inc. Fringe Benefits & Ret.5,806,687$ 5,903,284$ 6,149,010$ 6,295,351$ 7,836,679$ 8,720,731$ 9,510,777$ 9,624,906$ 9,740,405$ 9,857,290$ 9,975,578$ 4 a.Town Fringe Benefits 2,993,664$ 2,864,983$ 2,949,511$ 3,087,130$ 3,274,124$ 2,265,811$ 1,955,140$ 2,150,654$ 2,365,719$ 2,602,291$ 2,862,520$ b.Town Retirement / Pension Expense (FY18 Forward)1,381,855$ 1,561,817$ 1,697,692$ 1,915,455$ 2,003,851$ 2,044,690$ 1,559,034$ 1,683,757$ 1,818,457$ 1,963,934$ 2,121,049$ c.General Insurance 287,075$ 322,059$ 343,837$ 365,758$ 446,479$ 460,050$ 530,100$ 580,460$ 635,603$ 695,985$ 762,104$ 5 9,021,380$ 9,140,858$ 9,197,550$ 9,333,243$ 9,548,627$ 9,567,678$ 9,953,157$ 10,052,689$ 10,153,215$ 10,254,748$ 10,357,295$ 6 Cape Cod Technical School Assessment 694,838$ 667,110$ 702,591$ 734,873$ 723,538$ 828,976$ 831,711$ 879,534$ 930,108$ 983,589$ 1,040,145$ 7 -$ -$ -$ -$ -$ -$ 200,308$ 202,311$ 213,944$ 226,246$ 239,255$ 28,735,782$ 30,054,321$ 30,992,754$ 32,034,842$ 34,313,491$ 34,515,509$ 35,459,237$ 36,298,749$ 37,189,583$ 38,126,198$ 39,112,360$ FY2012 ACTUALS FY2013 ACTUALS FY2014 ACTUALS FY2015 ACTUALS FY2016 ACTUALS FY2017 BUDGET FY2018 PROJECTION FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION 1 121,204$ 264,790$ 255,249$ 245,664$ 236,542$ 420,063$ 406,163$ 387,263$ 375,263$ 198,063$ 182,463$ 2 -$ -$ -$ -$ -$ 240,791$ 226,563$ 220,763$ 214,963$ 209,163$ 203,363$ 3 (372,767)$ (366,668)$ 18,488$ 4,456$ 221,650$ 117,277$ 114,632$ 122,259$ 114,782$ 115,093$ 113,913$ 4 Cape Cod Technical School Assessment -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 5 Issuance Costs -$ -$ -$ -$ -$ -$ 30,000$ 30,000$ 30,000$ 30,000$ 30,000$ 6 Short Term Debt Principal & Interest -$ 9,286$ -$ 52,032$ 50,000$ 50,000$ 50,000$ 50,000$ 50,000$ 7 Future Town Principal & Interest -$ -$ -$ -$ -$ -$ 338,527$ -$ -$ -$ -$ 8 Future Schools Principal & Interest 9 -$ -$ -$ -$ -$ -$ 110,003$ -$ -$ -$ -$ (251,563)$ (101,878)$ 273,737$ 259,406$ 458,192$ 830,163$ 1,275,888$ 810,285$ 785,008$ 602,319$ 579,739$ Betterments Sub-total Debt Obligations Sub-total Operating Budgets B. Debt Budgets - Town & Schools: Nauset Regional School Debt Assessment Town Principal & Interest Elementray School Principal & Interest 2. ESTIMATED EXPENDITURES A. Operating Budgets - Town & Schools: Town Salaries Town Expenses Nauset Regional School Assessment Assessments (Previously Shown in Town Expense) Insurance 4/18/2017 Page 3 of 14 TOWN OF BREWSTER FINANCIAL FORECAST GENERAL FUND FISCAL YEAR 2018 (April 18, 2017) FY2012 ACTUALS FY2013 ACTUALS FY2014 ACTUALS FY2015 ACTUALS FY2016 ACTUALS FY2017 BUDGET FY2018 PROJECTION FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION 1 5,265$ 2,030$ 18,001$ -$ 4,315$ 970$ 15,369$ 5,100$ 5,100$ 5,100$ 5,100$ 2 62,839$ 65,269$ 78,938$ 86,187$ 88,087$ 101,959$ Moved to Operating -$ -$ -$ -$ 3 Local Business Funding 24,500$ 26,000$ 26,000$ 26,000$ 26,000$ 26,000$ Moved to Operating 26,000$ 26,000$ 26,000$ 26,000$ 4 Brewster Town Band 2,000$ 2,000$ 2,000$ 3,500$ 3,500$ 3,500$ Moved to Operating -$ -$ -$ -$ 5 Skipping Program 4,500$ 4,500$ 4,500$ 4,500$ 4,500$ 4,500$ 4,500$ 4,500$ 4,500$ 4,500$ 4,500$ 6 Revaluation Services 72,500$ 72,500$ 65,000$ 69,500$ 69,500$ 72,000$ Moved to Operating -$ -$ -$ -$ 7 Fuel Assistance 10,000$ 10,000$ 10,000$ 14,000$ 12,500$ 10,000$ Moved to Operating 10,000$ 10,000$ 10,000$ 10,000$ 8 Tax Title 5,000$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 9 Banking Charges -$ -$ 5,000$ -$ -$ -$ -$ -$ -$ -$ -$ 10 Contractual Obligations (Debt Service Paydowns)-$ 36,888$ -$ -$ 141,723$ -$ 366,000$ -$ -$ -$ -$ 11 -$ -$ -$ -$ -$ -$ -$ a.Town 483,850$ 1,197,132$ 2,020,572$ 1,775,466$ 1,980,150$ 1,433,825$ 1,869,295$ -$ -$ -$ -$ b.School 406,804$ 538,924$ 555,000$ 437,726$ 207,000$ 352,435$ 434,451$ -$ -$ -$ -$ 12 -$ -$ 75,000$ -$ -$ -$ 45,000$ 15,000$ 15,000$ 15,000$ 15,000$ 13 Insurance Fund 15,000$ 30,000$ -$ -$ Moved to Operating 20,000$ 20,000$ 20,000$ 20,000$ 14 Government Study -$ -$ 10,000$ -$ -$ -$ -$ -$ -$ -$ -$ 15 Coastal Community Resilience Planning & Assessment -$ -$ 50,000$ -$ -$ -$ -$ 50,000$ -$ -$ -$ 16 -$ -$ -$ -$ -$ 9,160$ -$ -$ -$ -$ -$ 1,077,258$ 1,955,243$ 2,935,011$ 2,446,879$ 2,537,275$ 2,014,349$ 2,734,615$ 130,600$ 80,600$ 80,600$ 80,600$ FY2012 ACTUALS FY2013 ACTUALS FY2014 ACTUALS FY2015 ACTUALS FY2016 ACTUALS FY2017 BUDGET FY2018 PROJECTION FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION 1 584,814$ 609,479$ 561,762$ 531,540$ 636,425$ 668,850$ 675,539$ 682,294$ 689,117$ 696,008$ 702,968$ 2 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 3 Overlay Reserve for Abatements 376,722$ 366,547$ 382,862$ 394,991$ 412,995$ 436,078$ 207,066$ 210,172$ 213,325$ 216,524$ 219,772$ 4 Prior Year Overlay & Other Deficits 19$ -$ 1,471$ 2,443$ -$ 1,512$ 2,000$ 2,000$ 2,000$ 2,000$ 2,000$ 5 Prior Year Snow & Ice Deficit Raised on Recap -$ -$ 119,467$ 122,418$ 219,136$ 46,075$ -$ -$ -$ -$ -$ 961,555$ 976,026$ 1,065,562$ 1,051,391$ 1,268,557$ 1,152,516$ 884,605$ 894,466$ 904,441$ 914,532$ 924,740$ 30,523,032$ 32,883,711$ 35,267,064$ 35,792,518$ 38,577,515$ 38,512,537$ 40,354,345$ 38,134,100$ 38,959,632$ 39,723,649$ 40,697,439$ 1,801,764$ 1,047,749$ 554,562$ 798,525$ (789,854)$ (354,584)$ 0$ 647,467$ 806,207$ 904,355$ 1,007,059$ Orleans Council on Aging Day Center Program C. Warrant Articles for Annual / Special Town Meeting Unpaid Bills Human Services Contracts Adjusted Surplus or Deficit Deficit will result in a requirement for either a Prop 2 1/2 Override, new revenue source, budget reductions or a combination thereof. Sub-total ATM Warrant Articles D. Other Special Charges & Assessments State Local Aid Charges & Offsets County Assessments (Other Than Retirement) Sub-total Charges & Assessments 2. GRAND TOTAL ESTIMATED EXPENDITURES 3. PROJECTED SURPLUS OR (DEFICIT*) Stabilization Fund Capital Expenditures from Revenues 4/18/2017 Page 4 of 14 FY2013 ACTUALS FY2014 ACTUALS FY2015 ACTUALS FY2016 ACTUALS FY2017 BUDGET FY2018 PROJECTION FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION 1 796,618$ 894,625$ 871,128$ 1,008,254$ 1,028,419$ 1,048,987$ 1,069,967$ 1,091,367$ 1,113,194$ 1,135,458$ 2 3,272,928$ 3,270,588$ 3,308,706$ 3,527,125$ 3,588,849$ 3,927,022$ 3,995,745$ 4,065,670$ 4,136,820$ 4,209,214$ 3 12,199$ 10,843$ 8,134$ 17,449$ 17,536$ 17,624$ 17,712$ 17,801$ 17,890$ 17,979$ 4 16,470$ 31,748$ 21,189$ 18,291$ 18,293$ 18,295$ 18,296$ 18,298$ 18,300$ 18,302$ 5 2,656,854$ 2,602,089$ 2,559,790$ 2,922,112$ 2,973,249$ 3,022,097$ 3,074,984$ 3,128,796$ 3,183,550$ 3,239,262$ 6 Water Department (Borrowing)-$ -$ -$ -$ -$ 500,000$ -$ -$ -$ -$ 7 Sale of Cemetery Lots (MGL Chp 114, S 15, 25)4,950$ 4,025$ 1,300$ 7,475$ 3,738$ 3,741$ 3,745$ 3,749$ 3,752$ 3,756$ 6,760,019$ 6,813,918$ 6,770,247$ 7,500,706$ 7,630,084$ 8,537,766$ 8,180,449$ 8,325,681$ 8,473,506$ 8,623,971$ FY2013 ACTUALS FY2014 ACTUALS FY2015 ACTUALS FY2016 ACTUALS FY2017 BUDGET FY2018 PROJECTION FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION 1 369,100$ 361,320$ 379,004$ 358,936$ 534,910$ 856,706$ 865,273$ 873,926$ 882,665$ 891,492$ 2 2,375,567$ 2,370,253$ 2,397,863$ 2,370,118$ 2,675,679$ 3,128,018$ 3,149,914$ 3,171,964$ 3,194,167$ 3,216,526$ 3 Waterways Improvement Fund (MGL Chp 40 S 5G)-$ 20,000$ -$ -$ 24,750$ -$ 4 4,920$ 18,625$ 23,313$ 9,790$ 19,000$ -$ -$ -$ -$ -$ 5 1,252,119$ 1,023,871$ 1,038,171$ 1,064,805$ 1,363,433$ 1,051,973$ 1,073,012$ 1,094,473$ 1,116,362$ 1,138,689$ 6 Sale of Cemetery Lots (MGL Chp 114, S 15, 25)7,500$ 12,000$ -$ -$ -$ 5,000$ 5,000$ 5,000$ 5,000$ 4,009,206$ 3,786,069$ 3,838,350$ 3,803,649$ 4,613,022$ 5,036,697$ 5,093,200$ 5,170,112$ 5,198,194$ 5,251,708$ FY2013 ACTUALS FY2014 ACTUALS FY2015 ACTUALS FY2016 ACTUALS FY2017 BUDGET FY2018 PROJECTION FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION 1 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 2 778,950$ 777,200$ 784,200$ 784,450$ 788,200$ 795,200$ 795,200$ 800,800$ -$ -$ 3 Water Department 474,055$ 460,680$ 667,697$ 645,943$ 738,054$ 720,624$ 683,468$ 658,018$ 493,968$ 480,718$ 4 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 5 Forecasted Debt - Golf -$ -$ -$ -$ -$ 51,077$ 84,256$ 82,072$ 79,888$ 77,704$ 6 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 1,253,005$ 1,237,880$ 1,451,897$ 1,430,393$ 1,526,254$ 1,566,901$ 1,562,924$ 1,540,890$ 573,856$ 558,422$ A. Receipts Reserved for Appropriation TOWN OF BREWSTER FINANCIAL FORECAST SPECIAL REVENUE FUND - RECEIPTS RESERVED FOR APPROPRIATION FISCAL YEAR 2018 (April 18, 2017) 1. ESTIMATED REVENUES RESOURCES Ambulance Receipts Reserved (MGL Chp 40 S 5F) Golf Receipts Reserved (MGL Chp 40 S 5F) Ambulance Receipts Reserved (MGL Chp 40 S 5F) Water Department Sub-total Operating Budgets B. Special Revenue Fund - Debt Spending Limit: Forecasted Debt - Ambulance Forecasted Debt - Water Department Sub-total Debt Obligations Wetlands Protection (MGL Chp 131 S40) Ambulance Receipts Reserved (MGL Chp 40 S 5F) Golf Receipts Reserved (MGL Chp 40 S 5F) Waterways Improvement Fund (MGL Chp 40 S 5G) Water Department Golf Receipts Reserved (MGL Chp 40 S 5F) 1. GRAND TOTAL ESTIMATED REVENUES 2. ESTIMATED EXPENDITURES A. Operating Budgets Wetlands Protection (MGL Chp 131 S40) 4/18/2017 Page 5 of 14 FY2013 ACTUALS FY2014 ACTUALS FY2015 ACTUALS FY2016 ACTUALS FY2017 BUDGET FY2018 PROJECTION FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION 1 -$ -$ 694$ -$ -$ -$ -$ -$ -$ -$ -$ 20$ 347$ -$ 49$ -$ 350$ 350$ 350$ 350$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 2 284,000$ 451,500$ 497,600$ 436,500$ 351,000$ -$ 581,000$ 563,000$ 536,000$ 536,000$ 183,603$ 531,620$ 74,650$ 221,279$ 272,869$ 258,756$ 270,000$ 270,000$ 270,000$ 270,000$ -$ -$ -$ 38,000$ -$ -$ 38,000$ -$ -$ 37,800$ -$ -$ -$ 10,000$ -$ -$ 10,000$ -$ -$ 10,000$ 7,500$ 54,566$ -$ 750$ -$ 750$ 750$ 750$ 750$ 436,448$ 820,556$ 1,081,965$ 1,282,654$ 891,915$ 1,249,500$ 890,000$ 890,000$ 890,000$ 890,000$ 3 -$ -$ -$ 13,295$ 4 14,000$ 14,000$ -$ -$ 11,000$ -$ -$ -$ -$ -$ 925,551$ 1,872,262$ 1,655,256$ 2,001,728$ 1,527,583$ 1,508,256$ 1,790,100$ 1,724,100$ 1,697,100$ 1,744,900$ 6,187,762$ 6,896,211$ 6,945,503$ 7,235,770$ 7,666,859$ 8,111,854$ 8,446,224$ 8,435,102$ 7,469,150$ 7,555,030$ 572,256$ (82,293)$ (175,256)$ 264,936$ (36,775)$ 425,912$ (265,774)$ (109,421)$ 1,004,355$ 1,068,941$ FY2013 ACTUALS FY2014 ACTUALS FY2015 ACTUALS FY2016 ACTUALS FY2017 BUDGET FY2018 PROJECTION FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION 1 570,455$ 713,973$ 795,778$ 789,608$ 1,002,426$ 1,144,935$ 1,337,217$ 960,911$ 615,351$ 309,880$ 2 904,897$ 839,705$ 431,200$ 482,847$ 620,830$ 472,882$ 217,930$ (1,789)$ (179,232)$ 493,070$ 3 Waterways Improvement Fund (MGL Chp 40 S 5G)28,484$ 40,683$ 51,526$ 59,660$ 39,109$ 36,645$ 54,269$ 33,981$ 27,032$ 44,921$ 4 Sale of Cemetery Lots (MGL Chp 114, S 15, 25)11,729$ 9,179$ 1,204$ 2,504$ 9,979$ 13,717$ 17,458$ 16,203$ 14,951$ 13,704$ 5 42,172$ 53,722$ 66,845$ 64,721$ 63,222$ 62,515$ 80,809$ 89,106$ 107,404$ 125,704$ 6 2,306,998$ 2,787,230$ 3,070,212$ 2,842,170$ 2,770,880$ 2,739,727$ 2,739,727$ 3,168,230$ 3,654,535$ 4,337,755$ FY2013 ACTUALS FY2014 ACTUALS FY2015 ACTUALS FY2016 ACTUALS FY2017 BUDGET FY2018 PROJECTION FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION 1 713,973$ 795,778$ 789,608$ 1,002,426$ 1,144,935$ 1,337,217$ 960,911$ 615,351$ 309,880$ 17,846$ 2 839,705$ 431,200$ 482,847$ 620,830$ 472,882$ 217,930$ (1,789)$ (179,232)$ 493,070$ 1,215,408$ 3 Waterways Improvement Fund (MGL Chp 40 S 5G)40,683$ 51,526$ 59,660$ 39,109$ 36,645$ 54,269$ 33,981$ 27,032$ 44,921$ 25,100$ 4 Sale of Cemetery Lots (MGL Chp 114, S 15, 25)9,179$ 1,204$ 2,504$ 9,979$ 13,717$ 17,458$ 16,203$ 14,951$ 13,704$ 12,460$ 5 53,722$ 66,845$ 64,721$ 63,222$ 62,515$ 80,809$ 89,106$ 107,404$ 125,704$ 134,006$ 6 2,787,230$ 3,070,212$ 2,842,170$ 2,770,880$ 2,739,727$ 2,739,727$ 3,168,230$ 3,654,535$ 4,337,755$ 5,067,610$ Note: *Projection Year and End of Year Fund Balance are estimates for forecasting purposes only. Ambulance Receipts Reserved (MGL Chp 40 S 5F) Golf Receipts Reserved (MGL Chp 40 S 5F) Waterways Improvement Fund (MGL Chp 40 S 5G) 2. GRAND TOTAL ESTIMATED EXPENDITURES 3. PROJECTED SURPLUS OR (DEFICIT*) Ambulance Receipts Reserved (MGL Chp 40 S 5F) Golf Receipts Reserved (MGL Chp 40 S 5F) Water Department Waterways Improvement Fund (MGL Chp 40 S 5G) Sub-total Warrant Articles Capital Expenditures from Revenues Water Department Wetlands Protection (MGL Chp 131 S40) Wetlands Protection (MGL Chp 131 S40) Water Department Hazardous Waste Collection Program Sale of Cemetery Lots (MGL Chp 114, S 15, 25) Contractual Obligations Golf Receipts Reserved (MGL Chp 40 S 5F) Unpaid Bills C. Warrant Articles for Annual Town Meeting Adjusted Surplus or Deficit Deficit will result in a requirement for new revenue sources, increases in fee structure, budget reductions or a combination thereof. Water Department PROJECTED FUND BALANCE PRIOR YEAR FUND BALANCE* END OF YEAR FUND BALANCE* Wetlands Protection (MGL Chp 131 S40) Ambulance Receipts Reserved (MGL Chp 40 S 5F) Golf Receipts Reserved (MGL Chp 40 S 5F) Water Department Wetlands Protection (MGL Chp 131 S40) Ambulance Receipts Reserved (MGL Chp 40 S 5F) Golf Receipts Reserved (MGL Chp 40 S 5F) 4/18/2017 Page 6 of 14 FY2013 ACTUALS FY2014 ACTUALS FY2015 ACTUALS FY2016 ACTUALS FY2017 BUDGET FY2018 PROJECTION FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION 1 152,189$ 170,710$ 146,764$ 146,983$ 147,203$ 147,424$ 147,645$ 147,866$ 148,088$ 148,310$ 2 60,423$ 76,358$ 70,525$ 82,375$ 82,375$ 82,400$ 82,424$ 82,449$ 82,474$ 82,499$ 3 102,354$ 92,691$ 93,693$ 94,267$ 94,833$ 95,402$ 95,974$ 96,550$ 97,129$ 97,712$ 314,965$ 339,759$ 310,982$ 323,625$ 324,411$ 325,225$ 326,043$ 326,865$ 327,691$ 328,521$ FY2013 ACTUALS FY2014 ACTUALS FY2015 ACTUALS FY2016 ACTUALS FY2017 BUDGET FY2018 PROJECTION FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION 1 287,254$ 303,912$ 318,699$ 335,062$ 337,072$ 339,095$ 341,129$ 343,176$ 345,235$ 347,307$ 287,254$ 303,912$ 318,699$ 335,062$ 337,072$ 339,095$ 341,129$ 343,176$ 345,235$ 347,307$ 602,219$ 643,671$ 629,681$ 658,686$ 661,483$ 664,320$ 667,173$ 670,042$ 672,926$ 675,827$ FY2013 ACTUALS FY2014 ACTUALS FY2015 ACTUALS FY2016 ACTUALS FY2017 BUDGET FY2018 PROJECTION FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION 1 139,727$ 167,750$ 146,394$ 157,667$ 200,000$ 169,032$ 147,645$ 147,866$ 148,088$ 148,310$ 2 82,596$ 127,997$ 78,812$ 70,743$ 200,000$ 78,000$ (41)$ 82,449$ 82,474$ 82,499$ 3 76,750$ 112,947$ 65,000$ 66,300$ 97,626$ 95,400$ 179,762$ 96,550$ 65,129$ 97,712$ 4 201,772$ 291,463$ 307,843$ 235,965$ 426,548$ 339,000$ 586,811$ 343,176$ 345,235$ 347,307$ 500,845$ 700,157$ 598,048$ 530,675$ 924,174$ 681,432$ 914,177$ 670,042$ 640,926$ 675,827$ Property Tax Levy Sub-total B. Revolving Funds (Other) TOWN OF BREWSTER FINANCIAL FORECAST SPECIAL REVENUE FUNDS - REVOLVING FUNDS FISCAL YEAR 2018 (April 18, 2017) 1. ESTIMATED REVENUES RESOURCES A. Revovling Funds (MGL Chp 44 S 53E1/2) Recreation Crosby Mansion Telecommunications Cable Franchise Fees (MGL Chp 44 S53F 3/4) 1. GRAND TOTAL ESTIMATED REVENUES 2. ESTIMATED EXPENDITURES A. Operating Spending Limit Recreation (MGL Chp 44 S 53 E 1/2) Estimated Receipts Sub-total Crosby Mansion (MGL Chp 44 S 53 E 1/2) Telecommunications (MGL Chp 44 S 53 E 1/2) Cable Franchise Fees (MGL Chp 44 S53F 3/4) Sub-total Operating Budgets 4/18/2017 Page 7 of 14 FY2013 ACTUALS FY2014 ACTUALS FY2015 ACTUALS FY2016 ACTUALS FY2017 BUDGET FY2018 PROJECTION FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION 1 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 2 -$ -$ -$ 7,500$ -$ -$ -$ -$ -$ -$ -$ 32,500$ -$ -$ -$ -$ -$ -$ -$ 25,000$ -$ -$ 32,000$ -$ 32,000$ -$ 32,000$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 25,000$ 32,500$ 7,500$ 32,000$ -$ 32,000$ -$ 32,000$ -$ 500,845$ 725,157$ 630,548$ 538,175$ 956,174$ 681,432$ 946,177$ 670,042$ 672,926$ 675,827$ 101,373$ (81,486)$ (868)$ 120,511$ (294,691)$ (17,112)$ (279,004)$ -$ -$ -$ FY2013 ACTUALS FY2014 ACTUALS FY2015 ACTUALS FY2016 ACTUALS FY2017 BUDGET FY2018 PROJECTION FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION 1 76,797$ 89,259$ 92,219$ 92,590$ 74,405$ 21,608$ -$ -$ -$ -$ 2 133,728$ 111,554$ 59,915$ 19,128$ 30,760$ (86,865)$ (82,465)$ -$ -$ -$ 3 113,572$ 139,176$ 93,920$ 122,612$ 150,579$ 115,786$ 115,788$ -$ -$ -$ 4 127,179$ 212,661$ 225,110$ 235,966$ 335,063$ 245,587$ 245,682$ -$ -$ -$ FY2013 ACTUALS FY2014 ACTUALS FY2015 ACTUALS FY2016 ACTUALS FY2017 BUDGET FY2018 PROJECTION FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION 1 89,259$ 92,219$ 92,590$ 74,405$ 21,608$ -$ -$ -$ -$ -$ 2 111,554$ 59,915$ 19,128$ 30,760$ (86,865)$ (82,465)$ -$ -$ -$ -$ 3 139,176$ 93,920$ 122,612$ 150,579$ 115,786$ 115,788$ -$ -$ -$ -$ 4 212,661$ 225,110$ 235,966$ 335,063$ 245,587$ 245,682$ -$ -$ -$ -$ Note: *Projection Year and End of Year Fund Balance are estimates for forecasting purposes only. PROJECTED FUND BALANCE Cable Franchise Fees (MGL Chp 44 S 53F 3/4) 2. GRAND TOTAL ESTIMATED SPENDING LIMIT C. Warrant Articles for Annual Town Meeting Unpaid Bills Capital Expenditures from Revenues Cable Franchise Fees (MGL Chp 44 S 53F 3/4) Deficit will result in a requirement for new revenue sources, increases in fee structure, budget reductions or a combination thereof. Recreation (MGL Chp 44 S 53 E 1/2) Recreation (MGL Chp 44 S 53 E 1/2) Crosby Mansion (MGL Chp 44 S 53 E 1/2) Telecommunications (MGL Chp 44 S 53 E 1/2) Recreation (MGL Chp 44 S 53 E 1/2) Cable Franchise Fees (MGL Chp 44 S 53F 3/4) Crosby Mansion (MGL Chp 44 S 53 E 1/2) Telecommunications (MGL Chp 44 S 53 E 1/2) Cable Franchise Fees (MGL Chp 44 S 53F 3/4) Crosby Mansion (MGL Chp 44 S 53 E 1/2) Telecommunications (MGL Chp 44 S 53 E 1/2) Crosby Mansion (MGL Chp 44 S 53 E 1/2) Telecommunications (MGL Chp 44 S 53 E 1/2) END OF YEAR FUND BALANCE* Recreation (MGL Chp 44 S 53 E 1/2) PRIOR YEAR FUND BALANCE* 3. PROJECTED SURPLUS OR (DEFICIT*) Sub-total Warrant Articles 4/18/2017 Page 8 of 14 FY2013 ACTUALS FY2014 ACTUALS FY2015 ACTUALS FY2016 ACTUALS FY2017 BUDGET FY2018 PROJECTION FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION 1 Community Preservation Surcharge (MGL Ch44B) (3%)758,511$ 795,958$ 819,852$ 861,778$ 787,252$ 887,678$ 915,120$ 942,498$ 969,810$ 997,806$ 2 235,599$ 476,816$ 301,307$ 291,928$ 168,971$ 177,536$ 183,024$ 188,500$ 193,962$ 199,561$ 3 6,077$ 6,551$ 4,987$ 7,135$ -$ 5,000$ 5,000$ 5,000$ 5,000$ 5,000$ 4 Community Preservation Gifts, Grants, Donations -$ 25,000$ 360,000$ 37,088$ -$ -$ -$ -$ -$ -$ 5 11,381$ 3,819$ 6,768$ 85,000$ -$ -$ -$ -$ -$ -$ 6 Community Preservation Proceeds from Bond Sales -$ 660,000$ -$ -$ -$ -$ -$ -$ -$ -$ 7 Offset: Community Preservation Abatements -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 8 Use of Fund Balance Reserves (ATM / STM Votes)-$ -$ -$ -$ 731,708$ 353,935$ -$ -$ -$ -$ 1,011,568$ 1,968,144$ 1,492,914$ 1,282,929$ 1,687,931$ 1,424,149$ 1,103,144$ 1,135,997$ 1,168,772$ 1,202,367$ FY2013 ACTUALS FY2014 ACTUALS FY2015 ACTUALS FY2016 ACTUALS FY2017 BUDGET FY2018 PROJECTION FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION 1 3,209$ -$ 9,137$ 9,754$ 15,000$ 15,000$ 16,547$ 17,040$ 17,532$ 18,035$ 2 34,594$ 762,916$ 653,403$ 327,807$ 175,000$ 232,674$ 370,291$ 391,484$ 415,279$ 466,356$ 3 202,359$ 23,938$ 509,396$ 10,500$ 255,000$ 107,021$ 74,058$ 78,297$ 83,056$ 93,271$ 4 28,433$ 629,318$ 871,077$ 131,932$ 598,000$ 107,021$ 74,058$ 78,297$ 83,056$ 93,271$ 5 -$ 142,023$ 164,782$ 216,645$ -$ 660,000$ 222,174$ 234,890$ 249,167$ 279,813$ 6 Debt Service Principal & Interest 358,582$ 353,799$ 338,147$ 328,169$ 376,441$ 302,433$ 346,015$ 335,990$ 320,683$ 251,620$ 7 -$ -$ -$ -$ 10,000$ -$ -$ -$ -$ -$ 627,178$ 1,911,994$ 2,545,942$ 1,024,808$ 1,429,441$ 1,424,149$ 1,103,144$ 1,135,997$ 1,168,772$ 1,202,367$ 384,390$ 56,150$ (1,053,028)$ 258,122$ 258,490$ (0)$ -$ -$ -$ -$ 3,225,012$ 3,609,402$ 3,665,553$ 2,612,525$ 2,870,647$ 3,129,137$ 3,129,137$ 3,129,137$ 3,129,137$ 3,129,137$ 3,609,402$ 3,665,553$ 2,612,525$ 2,870,647$ 3,129,137$ 3,129,137$ 3,129,137$ 3,129,137$ 3,129,137$ 3,129,137$ Note: *Projection Year and End of Year Fund Balance are estimates for forecasting purposes only. TOWN OF BREWSTER FINANCIAL FORECAST SPECIAL REVENUE FUND - COMMUNITY PRESERVATION FUNDS FISCAL YEAR 2018 (April 18, 2017) 1. ESTIMATED REVENUES RESOURCES Community Preservation State Match Community Preservation Other Revenue Community Preservation Interest Open Space Other (Historic, Housing, or Recreation) 1. GRAND TOTAL ESTIMATED REVENUES 2. ESTIMATED EXPENDITURES 4. PRIOR YEAR FUND BALANCE* 5. END OF YEAR FUND BALANCE* 2. GRAND TOTAL ESTIMATED EXPENDITURES 3. PROJECTED SURPLUS OR (DEFICIT*) A. Operating Budgets Administrative Expenses Historic Resources Community Housing Budgeted Reserves 4/18/2017 Page 9 of 14 RESERVED FUND BALANCE Spring ATM and Fall STM Transfers ATM Appropriations / Transfers Projected End of Year Balance w/o FY17 Revenue Note FY17 Est. Revenue Projected End of Year Balance w FY17 Revenue Open Space 198,728.00$ (352,433)$ (88,087)$ 499,980$ 411,893$ Historic Resources 242,057.00$ (30,000)$ 116,156$ 99,996$ 216,152$ Community Housing 725,213.00$ (40,000)$ (2,435)$ 99,996$ 97,561$ Reserve For CPA 699,129.75$ (675,000)$ 271,497$ 271,867$ 543,364$ Assumptions: FY2018 PROJECTION FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION Revenue: State Match 20%20%20%20%20% Expense Administration 1.50%1.50%1.50%1.50%1.50% (Split After Administration Expense and Debt Service Applied) Open Space 50%50%50%50%50% Historic Resources 10%10%10%10%10% Community Housing 10%10%10%10%10% Other 30%30%30%30%30% 272,367$ (25,000)$ 159,099$ (255,000)$ (89,648)$ (598,000)$ Start of Year Balance Spring ATM and Fall STM Appropriations 614,071$ (548,453)$ 4/18/2017 Page 10 of 14 FY2013 ACTUALS FY2014 ACTUALS FY2015 ACTUALS FY2016 ACTUALS FY2017 BUDGET FY2018 PROJECTION FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION 1 175,383$ 196,397$ 126,886$ 224,715$ 309,599$ 197,700$ 197,700$ 197,700$ 197,700$ 197,700$ 2 -$ 150,516$ -$ 227,074$ -$ -$ -$ -$ -$ -$ 3 -$ -$ -$ -$ -$ 247,920$ 247,920$ 247,920$ 247,920$ 247,920$ 175,383$ 346,913$ 126,886$ 451,789$ 309,599$ 445,620$ 445,620$ 445,620$ 445,620$ 445,620$ 175,383$ 346,913$ 126,886$ 451,789$ 309,599$ 445,620$ 445,620$ 445,620$ 445,620$ 445,620$ FY2013 ACTUALS FY2014 ACTUALS FY2015 ACTUALS FY2016 ACTUALS FY2017 BUDGET FY2018 PROJECTION FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION 1 235,519$ 198,106$ 147,056$ 165,819$ 145,882$ 146,000$ 132,372$ 128,575$ 119,717$ 90,882$ 2 7,253$ 7,053$ 6,840$ 6,590$ 6,340$ 6,090$ 5,878$ 5,665$ 5,445$ 5,225$ 242,771$ 205,159$ 153,896$ 172,409$ $152,222 $152,090 $138,250 $134,240 $125,162 $96,107 FY2013 ACTUALS FY2014 ACTUALS FY2015 ACTUALS FY2016 ACTUALS FY2017 BUDGET FY2018 PROJECTION FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION 1 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 2 Road Betterment - Prell Circle 160,880$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 3 Road Betterment - South Pond Drive / Captain Fitts -$ 209,345$ -$ -$ -$ -$ -$ -$ -$ -$ 4 Road Betterment - Ebenezer Lane -$ 9,000$ 309,136$ -$ -$ -$ -$ -$ -$ -$ 5 Road Betterment - Moss Lane, Commons Way, Magnet Way -$ -$ 5,000$ 115,475$ -$ -$ -$ -$ -$ -$ 6 Road Betterment - Tower Hill Circle -$ -$ 15,000$ 405,000$ -$ -$ -$ -$ -$ -$ 7 Road Betterment - Leona Terrace -$ -$ -$ 6,500$ 152,561$ -$ -$ -$ -$ -$ 8 To Be Determined -$ -$ -$ -$ -$ 247,920$ 247,920$ 247,920$ 247,920$ 247,920$ 160,880$ 218,345$ 329,136$ 526,975$ 152,561$ 247,920$ 247,920$ 247,920$ 247,920$ 247,920$ 403,651$ 423,504$ 483,032$ 699,384$ 304,783$ 400,010$ 386,170$ 382,160$ 373,082$ 344,027$ (228,268)$ (76,591)$ (356,146)$ (247,595)$ 4,816$ 45,611$ 59,450$ 63,460$ 72,539$ 101,593$ 221,936$ (6,332)$ (82,923)$ (439,069)$ (686,664)$ (681,848)$ (636,238)$ (576,788)$ (513,328)$ (440,789)$ (6,332)$ (82,923)$ (439,069)$ (686,664)$ (681,848)$ (636,238)$ (576,788)$ (513,328)$ (440,789)$ (339,196)$ Note: *Projection Year and End of Year Fund Balance are estimates for forecasting purposes only. Sub-total Betterment Assessment Road Betterments (To Be Determined) TOWN OF BREWSTER FINANCIAL FORECAST BETTERMENTS FISCAL YEAR 2018 (April 18, 2017) 1. ESTIMATED REVENUES RESOURCES Road Betterments (Fund 035) Bond Proceeds 4. PRIOR YEAR FUND BALANCE* 5. END OF YEAR FUND BALANCE* 1. GRAND TOTAL ESTIMATED REVENUES 2. ESTIMATED EXPENDITURES A. Road Betterments - Debt Expense 2. GRAND TOTAL ESTIMATED EXPENDITURES 3. PROJECTED SURPLUS OR (DEFICIT*) Sub-total Warrant Articles Sub-total Debt Obligations C. Warrant Articles for Annual Town Meeting Road Betterment - Allen Dr Road Betterments Debt Principal & Interest Water Betterments Debt Principal & Interest 4/18/2017 Page 11 of 14 TOWN OF BREWSTER FISCAL YEAR 2018 As of April 18, 2017 TOWN ADMINISTRATOR BOARD OF SELECTMEN FINANCE COMMITTEE CATEGORY EXPENDED EXPENDED EXPENDED EXPENDED APPROPRIATED RECOMMENDED RECOMMENDED RECOMMENDED GENERAL GOVERNMENT Finance Committee $ 87,670 $ 85,104 $ 103,697 $ 109,885 $ 112,095 $ 105,700 $ 105,700 $ 105,700 Finance & Operations $ 645,759 $ 680,060 $ 701,394 $ 732,834 $ 771,950 $ 865,649 $ 865,649 $ 865,649 Legal $ 133,558 $ 209,031 $ 197,595 $ 154,249 $ 165,640 $ 165,600 $ 165,600 $ 165,600 Moderator $ 300 $ 300 $ 300 $ 300 $ 300 $ 300 $ 300 $ 300 Planning $ 147,568 $ 147,519 $ 155,370 $ 162,065 $ 170,582 $ 165,527 $ 165,527 $ 165,527 Selectmen / Administration $ 385,078 $ 395,846 $ 405,579 $ 464,807 $ 428,048 $ 435,275 $ 435,275 $ 435,275 Town Clerk $ 148,418 $ 131,745 $ 153,566 $ 156,795 $ 176,545 $ 171,927 $ 171,927 $ 171,927 SUBTOTAL GENERAL GOVERNMENT $ 1,548,352 $ 1,649,605 $ 1,717,502 $ 1,780,935 $ 1,825,160 $ 1,909,978 $ 1,909,978 $ 1,909,978 SAFETY & PROTECTION Building Inspections $ 317,748 $ 352,526 $ 356,107 $ 377,630 $ 381,010 $ 381,355 $ 381,355 $ 381,355 Fire Department $ 1,756,921 $ 1,833,413 $ 1,930,320 $ 1,946,904 $ 2,032,772 $ 1,741,711 $ 1,741,711 $ 1,741,711 Health Department $ 196,611 $ 203,162 $ 211,305 $ 219,135 $ 226,109 $ 226,092 $ 226,092 $ 226,092 Natural Resources $ 264,242 $ 273,678 $ 257,709 $ 288,189 $ 301,623 $ 309,146 $ 309,146 $ 309,146 Police Department $ 2,183,751 $ 2,268,945 $ 2,277,383 $ 2,410,195 $ 2,518,200 $ 2,546,098 $ 2,546,098 $ 2,546,098 SUBTOTAL SAFETY & PROTECTION $ 4,719,273 $ 4,931,723 $ 5,032,824 $ 5,242,054 $ 5,459,714 $ 5,204,402 $ 5,204,402 $ 5,204,402 MAINTENANCE Public Buildings $ 98,047 $ 109,931 $ 117,176 $ 125,254 $ 121,539 $ 161,416 $ 161,416 $ 161,416 Public Works $ 1,362,964 $ 1,374,602 $ 1,428,165 $ 1,429,715 $ 1,538,579 $ 1,652,140 $ 1,652,140 $ 1,652,140 Snow & Ice Removal $ 244,467 $ 249,418 $ 348,136 $ 192,075 $ 151,000 $ 154,775 $ 154,775 $ 154,775 Utilities $ 522,803 $ 508,600 $ 502,381 $ 411,139 $ 434,188 $ 438,560 $ 438,560 $ 438,560 SUBTOTAL MAINTENANCE $ 2,228,281 $ 2,242,551 $ 2,395,859 $ 2,158,183 $ 2,245,306 $ 2,406,891 $ 2,406,891 $ 2,406,891 HUMAN SERVICES Council on Aging $ 200,774 $ 199,340 $ 208,342 $ 222,050 $ 247,997 $ 254,332 $ 254,332 $ 254,332 Veteran's Services $ 36,688 $ 41,461 $ 55,304 $ 64,092 $ 58,767 $ 65,100 $ 65,100 $ 65,100 SUBTOTAL HUMAN SERVICES $ 237,462 $ 240,801 $ 263,646 $ 286,143 $ 306,764 $ 319,432 $ 319,432 $ 319,432 CULTURE & RECREATION Brewsters Ladies Library $ 528,207 $ 538,853 $ 540,868 $ 540,330 $ 557,178 $ 606,893 $ 606,893 $ 606,893 Recreation $ 115,474 $ 119,914 $ 121,635 $ 126,680 $ 131,596 $ 135,647 $ 135,647 $ 135,647 Millsites $ 3,926 $ 4,000 $ 4,000 $ 4,000 $ 4,000 $ 4,000 $ 4,000 $ 4,000 SUBTOTAL CULTURE & RECREATION $ 647,607 $ 662,767 $ 666,503 $ 671,011 $ 692,774 $ 746,540 $ 746,540 $ 746,540 FY2018 GENERAL FUND FY2013 FY2014 FY2015 FY2016 FY2017 Summary 4/18/2017 TOWN ADMINISTRATOR BOARD OF SELECTMEN FINANCE COMMITTEE CATEGORY EXPENDED EXPENDED EXPENDED EXPENDED APPROPRIATED RECOMMENDED RECOMMENDED RECOMMENDED FY2018 GENERAL FUND FY2013 FY2014 FY2015 FY2016 FY2017 TOWN CONTRACTUAL OBLIGATIONS $ - $ - $ - $ - $ - $ 331,768 $ 331,768 $ 331,768 SUBTOTAL TOWN CONTRACTUAL OBLIGATIONS $ - $ - $ - $ - $ - $ 331,768 $ 331,768 $ 331,768 EDUCATION Elementary Schools $ 5,903,284 $ 6,149,010 $ 6,295,351 $ 7,836,679 $ 8,720,731 $ 9,510,777 $ 9,510,777 $ 9,510,777 Nauset Regional Schools $ 8,774,190 $ 9,216,038 $ 9,337,699 $ 9,770,277 $ 9,684,955 $ 9,953,157 $ 9,953,157 $ 9,953,157 Cape Cod Technical Schools $ 667,110 $ 702,591 $ 734,873 $ 728,538 $ 828,976 $ 831,711 $ 831,711 $ 831,711 SUBTOTAL EDUCATION $ 15,344,584 $ 16,067,639 $ 16,367,923 $ 18,335,494 $ 19,234,662 $ 20,295,645 $ 20,295,645 $ 20,295,645 DEBT SERVICE Principal & Interest $ 2,468,598 $ 2,752,759 $ 2,467,764 $ 2,875,189 $ 2,875,279 $ 1,275,888 $ 1,275,888 $ 1,275,888 SUBTOTAL DEBT SERVICE $ 2,468,598 $ 2,752,759 $ 2,467,764 $ 2,875,189 $ 2,875,279 $ 1,275,888 $ 1,275,888 $ 1,275,888 INSURANCE AND FRINGE BENEFITS General Insurance $ 322,059 $ 343,837 $ 365,758 $ 391,289 $ 460,050 $ 530,100 $ 530,100 $ 530,100 Fringe Benefits Including OPEB $ 4,426,799 $ 4,646,938 $ 4,999,272 $ 5,277,976 $ 4,310,501 $ 3,514,174 $ 3,514,174 $ 3,514,174 SUBTOTAL INSURANCE & FRINGE BENEFITS $ 4,748,858 $ 4,990,775 $ 5,365,030 $ 5,669,265 $ 4,770,551 $ 4,044,274 $ 4,044,274 $ 4,044,274 OTHER OPERATING EXPENSE & ASSESSMENTS Assessments $ 44,715 $ 45,150 $ 46,230 $ 48,319 $ 47,687 $ 47,848 $ 47,848 $ 47,848 Alewives Committee $ 1,692 $ 1,738 $ - $ 3,379 $ 3,400 $ 2,000 $ 2,000 $ 2,000 Local Service Funding $ 103,269 $ 116,938 $ 129,687 $ 130,087 $ 141,459 $ 150,460 $ 150,460 $ 150,460 SUBTOTAL OTHER OPERATING EXPENSE & ASSESSMENTS $ 149,676 $ 163,826 $ 175,917 $ 181,785 $ 192,546 $ 200,308 $ 200,308 $ 200,308 GRAND TOTAL OF GENERAL FUND OPERATING BUDGETS $ 32,092,692 $ 33,702,447 $ 34,452,967 $ 37,200,059 $ 37,602,756 $ 36,735,125 $ 36,735,125 $ 36,735,125 Summary 4/18/2017