Loading...
HomeMy Public PortalAbout5 Year Financial Forecast as of 04192018FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION FY2023 PROJECTION 1 42,772,643$ 42,251,163$ 43,282,716$ 44,505,955$ 45,495,370$ 2 8,182,779$ 8,241,433$ 8,281,525$ 8,321,997$ 8,381,887$ 3 706,662$ 712,683$ 718,771$ 724,927$ 348,867$ 4 1,101,200$ 1,109,295$ 1,131,211$ 1,153,350$ 1,165,165$ 5 131,975$ 128,418$ 114,542$ 85,691$ 72,772$ 52,895,259$ 52,442,992$ 53,528,765$ 54,791,920$ 55,464,061$ FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION FY2023 PROJECTION 1 40,200,028$ 40,976,281$ 42,276,045$ 43,785,846$ 45,204,181$ 2 7,252,525$ 6,399,425$ 6,295,305$ 6,348,116$ 6,401,873$ 3 706,662$ 720,795$ 735,211$ 749,915$ 764,914$ 4 1,143,467$ 1,109,295$ 1,131,211$ 1,153,350$ 1,165,165$ 5 131,975$ 128,418$ 114,542$ 85,691$ 72,772$ 49,434,657$ 49,334,214$ 50,552,314$ 52,122,919$ 53,608,905$ FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION FY2023 PROJECTION 1 1,888,705$ 414,596$ 139,783$ 9,600$ 9,600$ 2 295,618$ -$ -$ -$ -$ 3 100,000$ -$ -$ -$ -$ 4 -$ -$ -$ -$ -$ 5 -$ -$ -$ -$ -$ 2,284,323$ 414,596$ 139,783$ 9,600$ 9,600$ FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION FY2023 PROJECTION 1 683,911$ 860,285$ 866,888$ 873,557$ 880,293$ 2 -$ -$ -$ -$ -$ 3 -$ -$ -$ -$ -$ 4 -$ -$ -$ -$ -$ 5 Road Betterments -$ -$ -$ -$ -$ 683,911$ 860,285$ 866,888$ 873,557$ 880,293$ 1. ESTIMATED REVENUES RESOURCES TOWN OF BREWSTER FINANCIAL FORECAST MUNICIPAL BUDGET FISCAL YEAR 2019 (April 19, 2018) 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 C. Other Special Charges & Assessments 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 Sub-total Charges & Assessments General Fund Special Revenue Funds - Receipts Reserved for Appropriation Special Revenue Funds - Revolving Funds Special Revenue Funds - Community Preservation Road & Water Betterments Sub-total Operating Budgets General Fund Revenues Special Revenue Funds - Receipts Reserved for Appropriation Special Revenue Funds - Revolving Funds Special Revenue Funds - Community Preservation Road & Water Betterments 4/20/2018 Page 1 of 14 TOWN OF BREWSTER FINANCIAL FORECAST MUNICIPAL BUDGET FISCAL YEAR 2019 (April 19, 2018) 52,402,891$ 50,609,096$ 51,558,985$ 53,006,076$ 54,498,798$ 492,368$ 1,833,896$ 1,969,779$ 1,785,844$ 965,263$ Adjusted Surplus or Deficit *Surplus is not within the General Fund, therefore it is restricted as to the purpose it can be expended by MGL. Deficit will result in a requirement for either a Prop 2 1/2 Override, new revenue source, budget reductions or a combination thereof. 2. GRAND TOTAL ESTIMATED EXPENDITURES 3. PROJECTED RESTRICTED SURPLUS OR (DEFICIT*) 4/20/2018 Page 2 of 14 FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION FY2023 PROJECTION 1 30,648,080$ 32,289,319$ 33,221,552$ 34,177,091$ 35,156,518$ 2 766,202$ 807,233$ 830,539$ 854,427$ 878,913$ 3 160,239$ 125,000$ 125,000$ 125,000$ 125,000$ 4 Excess Levy Capacity -$ 5 Proposition 2 1/2 Operating Override -$ -$ -$ -$ -$ 6 1,856,765$ 1,813,315$ 1,602,115$ 1,554,665$ 1,504,215$ 7 -$ 276,666$ 508,749$ 698,333$ 677,917$ 8 160,727$ 164,745$ 168,864$ 173,085$ 177,413$ 9 714,798$ -$ -$ -$ -$ 34,306,811$ 35,476,278$ 36,456,819$ 37,582,601$ 38,519,976$ Projected Excess 34,306,811$ 35,476,278$ 36,456,819$ 37,582,601$ 38,519,976$ FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION FY2023 PROJECTION 1 1,844,817$ 1,854,041$ 1,863,311$ 1,872,628$ 1,881,991$ 2 1,522,945$ 1,561,019$ 1,600,044$ 1,640,045$ 1,681,046$ b. Other Excise Tax 1,360,808$ 1,388,024$ 1,415,784$ 1,444,100$ 1,472,982$ 160,210$ 160,210$ 160,210$ 160,210$ 160,210$ 6,875$ 6,875$ 6,875$ 6,875$ 6,875$ 536,454$ 536,454$ 533,772$ 533,772$ 533,772$ f. Fees 115,770$ 118,085$ 120,447$ 122,856$ 125,313$ g. Rentals 66,856$ 67,524$ 67,862$ 68,032$ 68,032$ h. Departmental Revenue 130,949$ 135,074$ 139,329$ 140,025$ 140,725$ i. License & Permits 779,375$ 801,953$ 771,709$ 787,143$ 755,657$ j. Special Assessments -$ -$ -$ -$ -$ k. Fines & Forfeits 27,326$ 27,599$ 27,875$ 28,154$ 28,435$ l. Investment Income 47,268$ 47,741$ 48,218$ 48,700$ 49,187$ m. Medicaid Reimbursement 70,110$ 70,285$ 70,461$ 70,813$ 71,167$ -$ -$ -$ -$ -$ o. Miscellaneous Non-Recurring -$ -$ -$ -$ -$ 3 -$ -$ -$ -$ -$ 4 -$ -$ -$ -$ -$ 6,669,762$ 6,774,885$ 6,825,898$ 6,923,354$ 6,975,394$ 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 Use Excess Levy Capacity Maximum Allowable Tax Levy County Maintenance of Effort - 6A Raised in Levy TOWN OF BREWSTER FINANCIAL FORECAST GENERAL FUND FISCAL YEAR 2019 (April 19, 2018) 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) Estimated Receipts Sub-total 4/20/2018 Page 3 of 14 TOWN OF BREWSTER FINANCIAL FORECAST GENERAL FUND FISCAL YEAR 2019 (April 19, 2018) FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION FY2023 PROJECTION 1 790,952$ -$ -$ -$ -$ 2 Overlay Surplus -$ -$ -$ -$ -$ 3 Repurpose old articles (completed and/or closed)520,118$ -$ -$ -$ -$ 4 Borrowing 485,000$ -$ -$ -$ -$ 1,796,070$ -$ -$ -$ -$ 42,772,643$ 42,251,163$ 43,282,716$ 44,505,955$ 45,495,370$ 2. ESTIMATED EXPENDITURES FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION FY2023 PROJECTION 1 11,723,022$ 11,965,482$ 12,212,792$ 12,465,048$ 12,722,349$ 2 Elementary School Operating Budget Inc. Fringe Benefits & Ret.9,748,546$ 9,992,260$ 10,242,066$ 10,498,118$ 10,760,571$ 3 a.Town Fringe Benefits 2,102,386$ 2,312,625$ 2,567,013$ 2,875,055$ 3,248,812$ b.Town Retirement / Pension Expense (FY18 Forward)1,694,546$ 1,864,001$ 2,050,401$ 2,255,441$ 2,480,985$ c.General Insurance 513,850$ 562,666$ 616,119$ 674,650$ 738,742$ 4 10,397,696$ 10,657,638$ 10,924,079$ 11,197,181$ 11,477,111$ 5 Cape Cod Technical School Assessment 845,458$ 866,594$ 888,259$ 910,466$ 933,227$ 6 Other Expense & Assessments (Previously Shown in Town Expense)980,149$ 289,855$ 297,101$ 304,529$ 312,142$ 38,005,653$ 38,511,121$ 39,797,831$ 41,180,487$ 42,673,939$ FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION FY2023 PROJECTION 1 1,778,450$ 1,738,750$ 1,525,209$ 1,469,750$ 1,420,850$ 2 220,763$ 214,963$ 209,163$ 203,363$ 197,563$ 3 115,162$ 114,782$ 115,093$ 113,913$ 113,913$ 4 Cape Cod Technical School Assessment -$ -$ -$ -$ -$ 5 Issuance Costs 30,000$ 70,000$ 70,000$ 70,000$ 70,000$ 6 Short Term Debt Principal & Interest 50,000$ 50,000$ 50,000$ 50,000$ 50,000$ 7 Future Town Principal & Interest (Authorized / Unissued)-$ 276,666$ 508,749$ 698,333$ 677,917$ 8 Future Schools Principal & Interest (Authorized / Unissued)-$ -$ -$ -$ -$ 9 -$ -$ -$ -$ -$ 2,194,375$ 2,465,161$ 2,478,214$ 2,605,359$ 2,530,243$ 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 C. Other Available Funds (One Time Source / Not Guaranteed Each Year): Other Available Funds Sub-total 1. GRAND TOTAL ESTIMATED REVENUES A. Operating Budgets - Town & Schools: Town Salaries & Expense Nauset Regional School Assessment Insurance Free Cash 4/20/2018 Page 4 of 14 TOWN OF BREWSTER FINANCIAL FORECAST GENERAL FUND FISCAL YEAR 2019 (April 19, 2018) FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION FY2023 PROJECTION 1 -$ 5,100$ 5,100$ 5,100$ 5,100$ 2 Skipping Program 4,500$ 4,500$ 4,500$ 4,500$ 4,500$ 3 -$ 404,996$ 130,183$ -$ -$ a.Town 1,488,500$ -$ -$ -$ b.School 395,705$ -$ -$ -$ -$ 1,888,705$ 414,596$ 139,783$ 9,600$ 9,600$ FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION FY2023 PROJECTION 1 653,748$ 660,285$ 666,888$ 673,557$ 680,293$ 2 -$ -$ -$ -$ -$ 3 Overlay Reserve for Abatements 30,163$ 200,000$ 200,000$ 200,000$ 200,000$ 4 Prior Year Overlay & Other Deficits -$ -$ -$ -$ -$ 5 Prior Year Snow & Ice Deficit Raised on Recap -$ -$ -$ -$ -$ 683,911$ 860,285$ 866,888$ 873,557$ 880,293$ 42,772,644$ 42,251,162$ 43,282,716$ 44,669,003$ 46,094,074$ (0)$ 0$ 0$ (163,048)$ (598,704)$ Deficit will result in a requirement for either a Prop 2 1/2 Override, new revenue source, budget reductions or a combination thereof. C. Warrant Articles for Annual / Special Town Meeting Unpaid Bills Capital Expenditures (Doesn't include prior Road / Fire Station bans) Adjusted Surplus or Deficit 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*) 4/20/2018 Page 5 of 14 FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION FY2023 PROJECTION 1 827,640$ 831,778$ 835,937$ 840,117$ 844,317$ 2 3,787,922$ 3,806,862$ 3,806,862$ 3,806,862$ 3,825,896$ 3 281$ 283$ 284$ 286$ 287$ 4 8,091$ 8,092$ 8,092$ 8,093$ 8,094$ 5 3,557,318$ 3,592,891$ 3,628,820$ 3,665,108$ 3,701,759$ 6 Water Department (Borrowing)-$ -$ -$ -$ 1$ 7 Sale of Cemetery Lots (MGL Chp 114, S 15, 25)1,527$ 1,528$ 1,530$ 1,531$ 1,533$ 8,182,779$ 8,241,433$ 8,281,525$ 8,321,997$ 8,381,887$ FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION FY2023 PROJECTION 1 827,640$ 835,916$ 844,276$ 852,718$ 861,246$ 2 3,148,327$ 3,170,365$ 3,192,558$ 3,214,906$ 3,237,410$ 3 Waterways Improvement Fund (MGL Chp 40 S 5G)-$ -$ -$ -$ -$ 4 -$ -$ -$ -$ -$ 5 1,695,025$ 1,728,926$ 1,763,504$ 1,798,774$ 1,834,750$ 6 Sale of Cemetery Lots (MGL Chp 114, S 15, 25)-$ -$ -$ -$ -$ 5,670,992$ 5,735,207$ 5,800,337$ 5,866,398$ 5,933,405$ FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION FY2023 PROJECTION 1 -$ -$ -$ -$ -$ 2 836,977$ -$ -$ -$ -$ 3 Water Department 744,556$ 664,218$ 494,968$ 481,718$ 468,468$ 1,581,533$ 664,218$ 494,968$ 481,718$ 468,468$ A. Receipts Reserved for Appropriation 1. ESTIMATED REVENUES RESOURCES TOWN OF BREWSTER FINANCIAL FORECAST SPECIAL REVENUE FUND - RECEIPTS RESERVED FOR APPROPRIATION FISCAL YEAR 2019 (April 19, 2018) 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: 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/20/2018 Page 6 of 14 TOWN OF BREWSTER FINANCIAL FORECAST SPECIAL REVENUE FUND - RECEIPTS RESERVED FOR APPROPRIATION FISCAL YEAR 2019 (April 19, 2018) FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION FY2023 PROJECTION 1 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 2 -$ -$ -$ -$ -$ 52,618$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 243,000$ -$ -$ -$ -$ 295,618$ -$ -$ -$ -$ 7,548,143$ 6,399,425$ 6,295,305$ 6,348,116$ 6,401,873$ 634,636$ 1,842,008$ 1,986,220$ 1,973,880$ 1,980,014$ *Surplus is not within the General Fund, therefore it is restricted as to the purpose it can be expended by MGL. 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 RESTRICTED SURPLUS OR (DEFICIT*) Ambulance Receipts Reserved (MGL Chp 40 S 5F) Golf Receipts Reserved (MGL Chp 40 S 5F) Waterways Improvement Fund (MGL Chp 40 S 5G) Sub-total Capital Capital Expenditures from Revenues Water Department Wetlands Protection (MGL Chp 131 S40) Wetlands Protection (MGL Chp 131 S40) Water Department Sale of Cemetery Lots (MGL Chp 114, S 15, 25) Unpaid Bills C. Special Revenue Fund - Capital / Unpaid Bills Spending Limit Adjusted Surplus or Deficit Deficit will result in a requirement for new revenue sources, increases in fee structure, budget reductions or a combination thereof. 4/20/2018 Page 7 of 14 FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION FY2023 PROJECTION 1 150,272$ 150,272$ 150,272$ 150,272$ 150,272$ 2 91,390$ 92,761$ 94,152$ 95,565$ 96,998$ 3 100,000$ 101,000$ 102,010$ 103,030$ 104,060$ 341,662$ 344,033$ 346,434$ 348,867$ 351,330$ FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION FY2023 PROJECTION 1 365,000$ 368,650$ 372,337$ 376,060$ 379,820$ 365,000$ 368,650$ 372,337$ 376,060$ 379,820$ 706,662$ 712,683$ 718,771$ 724,927$ 731,151$ FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION FY2023 PROJECTION 1 150,272$ 153,277$ 156,343$ 159,470$ 162,659$ 2 91,390$ 93,218$ 95,082$ 96,984$ 98,923$ 3 100,000$ 102,000$ 104,040$ 106,121$ 108,243$ 4 365,000$ 372,300$ 379,746$ 387,341$ 395,088$ 706,662$ 720,795$ 735,211$ 749,915$ 764,914$ Estimated Receipts Sub-total B. Revolving Funds (Other) 1. ESTIMATED REVENUES RESOURCES A. Revovling Funds (MGL Chp 44 S 53E1/2) Recreation Crosby Mansion Telecommunications 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 TOWN OF BREWSTER FINANCIAL FORECAST SPECIAL REVENUE FUNDS - REVOLVING FUNDS FISCAL YEAR 2019 (April 19, 2018) 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 4/20/2018 Page 8 of 14 TOWN OF BREWSTER FINANCIAL FORECAST SPECIAL REVENUE FUNDS - REVOLVING FUNDS FISCAL YEAR 2019 (April 19, 2018) FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION FY2023 PROJECTION 1 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 2 -$ -$ -$ -$ -$ -$ -$ -$ 100,000$ -$ -$ -$ -$ -$ -$ -$ -$ 100,000$ -$ -$ -$ -$ 806,662$ 720,795$ 735,211$ 749,915$ 764,914$ (100,000)$ (8,112)$ (16,440)$ (24,989)$ (33,763)$ Deficit will result in a requirement for new revenue sources, increases in fee structure, budget reductions or a combination thereof. *Capital covered by existing fund balance in Telecommunications fund. *Surplus is not within the General Fund, therefore it is restricted as to the purpose it can be expended by MGL. 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 Crosby Mansion (MGL Chp 44 S 53 E 1/2) Telecommunications (MGL Chp 44 S 53 E 1/2) 3. PROJECTED RESTRICTED SURPLUS OR (DEFICIT*) Sub-total Warrant Articles Cable Franchise Fees (MGL Chp 44 S 53F 3/4) 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) 4/20/2018 Page 9 of 14 FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION FY2023 PROJECTION 1 Community Preservation Surcharge (MGL Ch44B) (3%)957,565$ 968,680$ 996,647$ 1,025,313$ 1,054,696$ 2 143,635$ 135,615$ 129,564$ 123,038$ 105,470$ 3 -$ 5,000$ 5,000$ 5,000$ 5,000$ 4 Community Preservation Gifts, Grants, Donations -$ -$ -$ -$ -$ 5 -$ -$ -$ -$ -$ 6 Community Preservation Proceeds from Bond Sales -$ -$ -$ -$ -$ 7 Offset: Community Preservation Abatements -$ -$ -$ -$ -$ 8 Use of Fund Balance Reserves (ATM / STM Votes)-$ -$ -$ -$ -$ 1,101,200$ 1,109,295$ 1,131,211$ 1,153,350$ 1,165,165$ FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION FY2023 PROJECTION 1 55,060$ 55,465$ 56,561$ 57,668$ 58,258$ 2 255,672$ 358,920$ 376,984$ 422,031$ 427,643$ 3 140,000$ 71,784$ 75,397$ 84,406$ 85,529$ 4 181,000$ 71,784$ 75,397$ 84,406$ 85,529$ 5 35,000$ 215,352$ 226,190$ 253,219$ 256,586$ 6 Debt Service Principal & Interest 294,928$ 335,990$ 320,683$ 251,620$ 251,620$ 7 181,807$ -$ -$ -$ -$ 1,143,467$ 1,109,295$ 1,131,211$ 1,153,350$ 1,165,165$ (42,267)$ -$ -$ -$ -$ 3,304,326$ 3,262,059$ 3,262,059$ 3,262,059$ 3,262,059$ 3,262,059$ 3,262,059$ 3,262,059$ 3,262,059$ 3,262,059$ Note: *Projection Year and End of Year Fund Balance are estimates for forecasting purposes only. Amount shown as the deficit variance is covered by existing fund balances. *Surplus is not within the General Fund, therefore it is restricted as to the purpose it can be expended by MGL. 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 4. PRIOR YEAR FUND UNRESERVED BALANCE* 5. END OF YEAR FUND UNRESERVED BALANCE* 2. GRAND TOTAL ESTIMATED EXPENDITURES 3. PROJECTED RESTRICTED SURPLUS OR (DEFICIT*) A. Operating Budgets Historic Resources Community Housing Budgeted Reserves 2. ESTIMATED EXPENDITURES TOWN OF BREWSTER FINANCIAL FORECAST SPECIAL REVENUE FUND - COMMUNITY PRESERVATION FUNDS FISCAL YEAR 2019 (April 19, 2018) Administrative Expenses 4/20/2018 Page 10 of 14 FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION FY2023 PROJECTION 1 126,097$ 122,753$ 109,097$ 80,466$ 72,772$ 2 -$ -$ -$ -$ -$ 3 Water Betterments (Fund 033)5,878$ 5,665$ 5,445$ 5,225$ -$ 4 -$ -$ -$ -$ -$ 131,975$ 128,418$ 114,542$ 85,691$ 72,772$ 131,975$ 128,418$ 114,542$ 85,691$ 72,772$ FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION FY2023 PROJECTION 1 105,310$ 102,560$ 89,498$ 61,460$ 54,360$ 2 5,878$ 5,665$ 5,445$ 5,225$ -$ 3 20,787$ 20,193$ 19,599$ 19,006$ 18,412$ $131,975 $128,418 $114,542 $85,691 $72,772 FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION FY2023 PROJECTION 1 -$ -$ -$ -$ -$ 2 Road Betterment - Prell Circle -$ -$ -$ -$ -$ 3 Road Betterment - South Pond Drive / Captain Fitts -$ -$ -$ -$ -$ 4 Road Betterment - Ebenezer Lane -$ -$ -$ -$ -$ 5 Road Betterment - Moss Lane, Commons Way, Magnet Way -$ -$ -$ -$ -$ 6 Road Betterment - Tower Hill Circle -$ -$ -$ -$ -$ 7 Road Betterment - Leona Terrace -$ -$ -$ -$ -$ 8 To Be Determined -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 131,975$ 128,418$ 114,542$ 85,691$ 72,772$ -$ -$ -$ -$ -$ TOWN OF BREWSTER FINANCIAL FORECAST BETTERMENTS FISCAL YEAR 2019 (April 19, 2018) Sub-total Betterment Assessment Road Betterments (To Be Determined) 1. ESTIMATED REVENUES RESOURCES Road Betterments (Fund 035) Bond Proceeds 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 Road Betterments Debt Principal & Interest Projection 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/20/2018 Page 11 of 14 FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION FY2023 PROJECTION a. 1 State Local Aid 0.50%0.50%0.50%0.50%0.50% 2 Motor Vehicle Excise 2.50%2.50%2.50%2.50%2.50% 3 Other Excise Tax 2.00%2.00%2.00%2.00%2.00% 4 Penalties & Interest on Taxes & Excise 0.00%0.00%0.00%0.00%0.00% 5 Payments in Lieu of Taxes 0.00%0.00%0.00%0.00%0.00% 6 Charges for Services (Transfer Station)-0.50%0.00%-0.50%0.00%0.00% 7 Fees 2.00%2.00%2.00%2.00%2.00% 8 Rentals 2.00%1.00%0.50%0.25%0.00% 9 Departmental Revenue 3.15%3.15%3.15%0.50%0.50% 10 License & Permits -7.77%2.90%-3.77%2.00%-4.00% 11 Special Assessments 0.00%0.00%0.00%0.00%0.00% 12 Fines & Forfeits 1.00%1.00%1.00%1.00%1.00% 13 Investment Income 1.00%1.00%1.00%1.00%1.00% 14 Medicaid Reimbursement 0.00%0.25%0.25%0.50%0.50% 15 Miscellaneous Recurring 0.00%0.00%0.00%0.00%0.00% 16 Miscellaneous Non-Recurring 0.00%0.00%0.00%0.00%0.00% 17 MLBC State Grant (BLLibrary) (TBD)0.00%0.00%0.00%0.00%0.00% b. 1 Ambulance 0.50%0.50%0.50%0.50%0.50% 2 Golf 0.75%0.50%0.00%0.00%0.50% 3 Waterways Improvement 0.50%0.50%0.50%0.50%0.50% 4 Wetlands Protection 0.01%0.01%0.01%0.01%0.01% 5 Water Department 1.00%1.00%1.00%1.00%1.00% 6 Sale of Cemetery Lots 0.10%0.10%0.10%0.10%0.10% c. 1 Recreation 0.00%0.00%0.00%0.00%0.00% 2 Crosby Mansion 1.50%1.50%1.50%1.50%1.50% 3 Telecommunications 1.00%1.00%1.00%1.00%1.00% 4 Cable Franchise Fees 4.75%4.75%4.75%4.75%4.75% d.Community Preservation 1 State Match 18%18%18%18%18% e.Betterments (Offset Debt Exp)0.00%0.00%0.00%0.00%0.00% 1. ESTIMATED REVENUES RESOURCES Forecast Assumptions TOWN OF BREWSTER FINANCIAL FORECAST ASSUMPTIONS FISCAL YEAR 2019 (April 19, 2018) General Fund Local Revenue Receipts for Appropriation Revolving Funds 4/20/2018 Page 12 of 14 Forecast Assumptions TOWN OF BREWSTER FINANCIAL FORECAST ASSUMPTIONS FISCAL YEAR 2019 (April 19, 2018) FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION FY2023 PROJECTION a. 1 Town Salaries & Expense 2.00%2.00%2.00%2.00%2.00% 2 Elementary Schools Operating Budget 2.50%2.50%2.50%2.50%2.50% 3 Town & Elementary Schools Shared Exp Fringe Benefits 6.00%10.00%11.00%12.00%13.00% Retirement / Pension Expense 10.00%10.00%10.00%10.00%10.00% General Insurance 9.50%9.50%9.50%9.50%9.50% 4 Nauset Regional School Assessment 2.50%2.50%2.50%2.50%2.50% 5 Cape Cod Technical School Assessment 2.50%2.50%2.50%2.50%2.50% 6 Assessments 2.50%2.50%2.50%2.50%2.50% b. 1 Ambulance 1.00%1.00%1.00%1.00%1.00% 2 Golf 0.70%0.70%0.70%0.70%0.70% 3 Waterways Improvement 0.00%0.00%0.00%0.00%0.00% 4 Wetlands Protection 0.00%0.00%0.00%0.00%0.00% 5 Water Department 2.00%2.00%2.00%2.00%2.00% 6 Sale of Cemetery Lots 0.00%0.00%0.00%0.00%0.00% c. 1 Recreation 2.00%2.00%2.00%2.00%2.00% 2 Crosby Mansion 2.00%2.00%2.00%2.00%2.00% 3 Telecommunications 2.00%2.00%2.00%2.00%2.00% 4 Cable Franchise Fees 2.00%2.00%2.00%2.00%2.00% d.Community Preservation 1 Administrative Exp 1.50%1.50%1.50%1.50%1.50% 2 Open Space 50.00%50.00%50.00%50.00%50.00% 3 Historic Resources 10.00%10.00%10.00%10.00%10.00% 4 Community Housing 10.00%10.00%10.00%10.00%10.00% 5 Other 30.00%30.00%30.00%30.00%30.00% e.Betterments 0.00%0.00%0.00%0.00%0.00% 2. ESTIMATED OPERATING EXPENSE General Fund Receipts for Appropriation Revolving Funds 4/20/2018 Page 13 of 14 Fiscal Year Total Taxable Valuation Tax Revenue Allowable from New Growth % Change $ Change Tax Rate $0.01 on the Tax Rate Raises Total Taxable Valuation Tax Revenue Allowable from New Growth % Change $ Change Tax Rate Number of Parcels Average Tax Bill Average Value 2012 3,346,182,410$ 15,711,601$ 0.47%109,039$ 6.94$ 33,618.94$ 2,467,125,260$ 10,363,500$ 0.42%71,923$ 6.94$ 5,476 3,140$ 452,426.73 2013 3,251,967,110$ 22,085,120$ 0.67%164,313$ 7.44$ 32,740.52$ 2,408,484,750$ 15,876,550$ 0.65%118,122$ 7.44$ 5,490 3,285$ 441,595.87 2014 3,313,114,540$ 28,328,980$ 0.85%224,366$ 7.92$ 33,414.44$ 2,459,674,620$ 16,138,920$ 0.65%127,820$ 7.92$ 5,506 3,561$ 449,657.38 2015 3,379,744,690$ 20,197,538$ 0.59%165,216$ 8.18$ 33,999.42$ 2,518,910,250$ 15,362,180$ 0.61%125,663$ 8.18$ 5,518 3,757$ 459,273.73 2016 3,474,653,670$ 24,653,928$ 0.70%203,641$ 8.26$ 34,993.08$ 2,595,613,510$ 14,347,340$ 0.55%118,509$ 8.26$ 5,532 3,897$ 471,793.36 2017 3,619,158,270$ 42,611,145$ 1.16%359,212$ 8.43$ 36,617.69$ 2,693,113,400$ 12,242,510$ 0.45%103,204$ 8.43$ 5,548 4,111$ 487,627.24 2018 3,781,892,170$ 38,031,550$ 1.00%314,141$ 8.26$ 38,199.23$ 2,838,908,040$ 22,043,100$ 0.77%182,076$8.26$ 5,558 4,219$ 510,778.70 TOWN OF BREWSTER FINANCIAL PROJECTIONS FISCAL YEAR 2018 All Categories Single Family Home 4/20/2018 Page 14 of 14