The URL can be used to link to this page

Home My Public Portal AboutFY2018 - FY2023 General Fund Financial ForecastFY2018 BUDGET FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION FY2023 PROJECTION 1 29,589,263$ 30,648,080$ 31,564,282$ 32,478,389$ 33,415,349$ 34,375,732$ 2 739,732$ 766,202$ 789,107$ 811,960$ 835,384$ 859,393$ 3 319,085$ 150,000$ 125,000$ 125,000$ 125,000$ 125,000$ 4 Excess Levy Capacity -$ 5 Proposition 2 1/2 Operating Override -$ -$ -$ -$ -$ 6 1,462,481$ 1,352,165$ 1,319,815$ 1,117,615$ 1,082,165$ 1,046,715$ 7 650,000$ 910,416$ 1,126,249$ 1,299,583$ 1,262,917$ 8 156,807$ 160,727$ 164,745$ 168,864$ 173,086$ 177,413$ 32,267,368$ 33,727,174$ 34,873,365$ 35,828,077$ 36,930,566$ 37,847,171$ Projected Excess 714,798$ 31,552,570$ 33,727,174$ 34,873,365$ 35,828,077$ 36,930,566$ 37,847,171$ FY2018 BUDGET FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION FY2023 PROJECTION 1 1,835,639$ 1,844,817$ 1,854,041$ 1,863,311$ 1,872,628$ 1,881,991$ 2 1,485,800$ 1,522,945$ 1,561,019$ 1,600,044$ 1,640,045$ 1,681,046$ b. Other Excise Tax 1,334,125$ 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$ 160,210$ 6,875$ 6,875$ 6,875$ 6,875$ 6,875$ 6,875$ 539,150$ 536,454$ 536,454$ 533,772$ 533,772$ 533,772$ f. Fees 113,500$ 115,770$ 118,085$ 120,447$ 122,856$ 125,313$ g. Rentals 65,545$ 66,856$ 67,524$ 67,862$ 68,032$ 68,032$ h. Departmental Revenue 126,950$ 130,949$ 135,074$ 139,329$ 140,025$ 140,725$ i. License & Permits 845,000$ 779,375$ 801,953$ 771,709$ 787,143$ 755,657$ j. Special Assessments -$ -$ -$ -$ -$ -$ k. Fines & Forfeits 27,055$ 27,326$ 27,599$ 27,875$ 28,154$ 28,435$ l. Investment Income 46,800$ 47,268$ 47,741$ 48,218$ 48,700$ 49,187$ m. Medicaid Reimbursement 70,110$ 70,110$ 70,285$ 70,461$ 70,813$ 71,167$ -$ -$ -$ -$ -$ -$ o. Miscellaneous Non-Recurring -$ -$ -$ -$ -$ -$ 3 -$ -$ -$ -$ -$ -$ 4 -$ -$ -$ -$ -$ -$ 6,656,759$ 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 County Maintenance of Effort - Raised in Levy Maximum Allowable Tax Levy TOWN OF BREWSTER FINANCIAL FORECAST GENERAL FUND FISCAL YEAR 2019 (February 16,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 2/16/2018 Page 1 of 4 TOWN OF BREWSTER FINANCIAL FORECAST GENERAL FUND FISCAL YEAR 2019 (February 16,2018) FY2018 BUDGET FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION FY2023 PROJECTION 1 1,695,241$ 914,120$ -$ -$ -$ -$ 2 Overlay Surplus 300,000$ -$ -$ -$ -$ -$ 3 Repurpose old articles (completed and/or closed)-$ 510,118$ -$ -$ -$ -$ 4 Borrowing 634,938$ 485,000$ -$ -$ -$ -$ 2,630,179$ 1,909,238$ -$ -$ -$ -$ 40,839,508$ 42,306,175$ 41,648,250$ 42,653,974$ 43,853,920$ 44,822,565$ C. Other Available Funds (One Time Source / Not Guaranteed Each Year): Other Available Funds Sub-total 1. GRAND TOTAL ESTIMATED REVENUES Free Cash 2/16/2018 Page 2 of 4 TOWN OF BREWSTER FINANCIAL FORECAST GENERAL FUND FISCAL YEAR 2019 (February 16,2018) 2. ESTIMATED EXPENDITURES FY2018 BUDGET FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION FY2023 PROJECTION 1 10,919,011$ 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,510,777$ 9,725,206$ 9,968,336$ 10,217,545$ 10,472,983$ 10,734,808$ 3 a.Town Fringe Benefits 1,955,140$ 2,102,386$ 2,417,744$ 2,780,405$ 3,197,466$ 3,677,086$ b.Town Retirement / Pension Expense (FY18 Forward)1,559,034$ 1,694,546$ 1,864,001$ 2,050,401$ 2,255,441$ 2,480,985$ c.General Insurance 530,100$ 513,850$ 562,666$ 616,119$ 674,650$ 738,742$ 4 9,953,157$ 10,397,696$ 10,657,638$ 10,924,079$ 11,197,181$ 11,477,111$ 5 Cape Cod Technical School Assessment 831,711$ 845,458$ 866,594$ 888,259$ 910,466$ 933,227$ 6 245,308$ 262,851$ 269,422$ 276,158$ 283,062$ 290,138$ 35,504,238$ 37,285,813$ 38,593,098$ 39,987,397$ 41,478,368$ 43,076,959$ FY2018 BUDGET FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION FY2023 PROJECTION 1 1,219,520$ 1,186,412$ 1,159,113$ 956,522$ 915,663$ 885,013$ 2 226,563$ 220,763$ 214,963$ 209,163$ 203,363$ 197,563$ 3 114,632$ 115,162$ 114,782$ 115,093$ 113,913$ 113,913$ 4 Cape Cod Technical School Assessment -$ -$ -$ -$ -$ -$ 5 Issuance Costs 30,000$ 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$ 50,000$ 7 Future Town Principal & Interest (Authorized / Unissued)507,188$ 746,500$ 1,003,666$ 1,216,249$ 1,386,333$ 1,346,417$ 8 Future Schools Principal & Interest (Authorized / Unissued)-$ -$ -$ -$ -$ -$ 9 -$ -$ -$ -$ -$ -$ 2,147,903$ 2,348,837$ 2,612,524$ 2,617,027$ 2,739,272$ 2,662,906$ 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 A. Operating Budgets - Town & Schools: Town Salaries & Expense Nauset Regional School Assessment Other Expense & Assessments (Previously Shown in Town Expense) Insurance 2/16/2018 Page 3 of 4 TOWN OF BREWSTER FINANCIAL FORECAST GENERAL FUND FISCAL YEAR 2019 (February 16,2018) FY2018 BUDGET FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION FY2023 PROJECTION 1 15,369$ -$ 5,100$ 5,100$ 5,100$ 5,100$ 2 Skipping Program 4,500$ 4,500$ 4,500$ 4,500$ 4,500$ 4,500$ 3 -$ -$ -$ -$ -$ -$ a.Town 1,869,295$ 1,548,000$ -$ -$ -$ -$ b.School 434,451$ 461,238$ -$ -$ -$ -$ 2,323,615$ 2,013,738$ 9,600$ 9,600$ 9,600$ 9,600$ FY2018 BUDGET FY2019 PROJECTION FY2020 PROJECTION FY2021 PROJECTION FY2022 PROJECTION FY2023 PROJECTION 1 647,275$ 653,748$ 660,285$ 666,888$ 673,557$ 680,293$ 2 -$ -$ -$ -$ -$ -$ 3 Overlay Reserve for Abatements 216,477$ -$ -$ -$ -$ -$ 4 Prior Year Overlay & Other Deficits -$ -$ -$ -$ -$ -$ 5 Prior Year Snow & Ice Deficit Raised on Recap -$ -$ -$ -$ -$ -$ 863,752$ 653,748$ 660,285$ 666,888$ 673,557$ 680,293$ 40,839,508$ 42,302,136$ 41,875,507$ 43,280,912$ 44,900,797$ 46,429,757$ (0)$ 4,039$ (227,257)$ (626,937)$ (1,046,877)$ (1,607,192)$ 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*) 2/16/2018 Page 4 of 4