The URL can be used to link to this page

Home My Public Portal AboutGeneral Fund 5 Year Financial Forecast as of 03192018FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION FY2023 PROJECTION 1 30,648,080$ 31,574,521$ 32,488,884$ 33,426,106$ 34,386,759$ 2 766,202$ 789,363$ 812,222$ 835,653$ 859,669$ 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,086$ 177,413$ 33,592,013$ 34,743,610$ 35,705,834$ 36,812,842$ 37,730,972$ Projected Excess 33,592,013$ 34,743,610$ 35,705,834$ 36,812,842$ 37,730,972$ 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$ Estimated Receipts Sub-total MLBC State Grant Reimbursement (BLLibrary) 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 TOWN OF BREWSTER FINANCIAL FORECAST GENERAL FUND FISCAL YEAR 2019 (March 19, 2018) 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 County Maintenance of Effort - 6A Raised in Levy Maximum Allowable Tax Levy 3/16/2018 Page 1 of 3 TOWN OF BREWSTER FINANCIAL FORECAST GENERAL FUND FISCAL YEAR 2019 (March 19, 2018) FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION FY2023 PROJECTION 1 939,087$ -$ -$ -$ -$ 2 Overlay Surplus -$ -$ -$ -$ -$ 3 Repurpose old articles (completed and/or closed)520,118$ -$ -$ -$ -$ 4 Borrowing 485,000$ -$ -$ -$ -$ 1,944,205$ -$ -$ -$ -$ 42,205,981$ 41,518,495$ 42,531,732$ 43,736,196$ 44,706,367$ 2. ESTIMATED EXPENDITURES FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION FY2023 PROJECTION 1 11,743,820$ 11,986,696$ 12,234,430$ 12,487,119$ 12,744,861$ 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,417,744$ 2,780,405$ 3,197,466$ 3,677,086$ 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)262,851$ 269,422$ 276,158$ 283,062$ 290,138$ 37,309,153$ 38,617,021$ 40,011,918$ 41,503,503$ 43,102,722$ 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$ Town Salaries & Expense Nauset Regional School Assessment Insurance Free Cash 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: 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 3/16/2018 Page 2 of 3 TOWN OF BREWSTER FINANCIAL FORECAST GENERAL FUND FISCAL YEAR 2019 (March 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 Cultural Council 10,000$ -$ -$ -$ -$ 4 -$ -$ -$ -$ -$ a.Town 1,568,500$ -$ -$ -$ -$ b.School 465,705$ -$ -$ -$ -$ 2,048,705$ 9,600$ 9,600$ 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 -$ -$ -$ -$ -$ 4 Prior Year Overlay & Other Deficits -$ -$ -$ -$ -$ 5 Prior Year Snow & Ice Deficit Raised on Recap -$ -$ -$ -$ -$ 653,748$ 660,285$ 666,888$ 673,557$ 680,293$ 42,205,981$ 41,752,067$ 43,166,620$ 44,792,019$ 46,322,857$ (0)$ (233,572)$ (634,889)$ (1,055,823)$ (1,616,490)$ Deficit will result in a requirement for either a Prop 2 1/2 Override, new revenue source, budget reductions or a combination thereof. 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*) C. Warrant Articles for Annual / Special Town Meeting Unpaid Bills Capital Expenditures (Doesn't include prior Road / Fire Station bans) 3/16/2018 Page 3 of 3