The URL can be used to link to this page

Home My Public Portal About2018 Debt Service Summary as of 09182017Town of Brewster Debt Service Summary As of September 18, 2017 FISCAL 2018 - 2022 Principal Interest Principal Interest Principal Interest Principal Interest Principal Interest Principal Interest Existing Long Term Debt 2,589,400$ 872,358$ 2,575,400$ 767,645$ 2,610,400$ 672,908$ 1,505,200$ 571,077$ 1,410,000$ 509,047$ 1,400,000$ 448,948$ Existing Short Term Debt 40,000$ 1,077$ 26,848$ 10,259$ 26,848$ 9,185$ 26,848$ 8,111$ 26,848$ 7,038$ 26,848$ 5,964$ Forecasted Debt (Unissued)-$ -$ 360,321$ 156,747$ 1,092,039$ 902,569$ 1,899,667$ 1,579,946$ 2,548,786$ 2,097,409$ 2,742,342$ 2,106,039$ Total Expense by Classification 2,629,400$ 873,435$ 2,962,569$ 934,651$ 3,729,287$ 1,584,662$ 3,431,715$ 2,159,134$ 3,985,634$ 2,613,494$ 4,169,190$ 2,560,951$ 3,502,835$ 3,897,220$ 5,313,949$ 5,590,849$ 6,599,128$ 6,730,141$ Principal Interest Principal Interest Principal Interest Principal Interest Principal Interest Principal Interest Road Betterment 123,418$ 24,466$ 99,848$ 26,249$ 99,848$ 22,905$ 89,848$ 19,249$ 64,848$ 15,618$ 59,848$ 12,924$ Water Betterment 5,000$ 1,090$ 5,000$ 878$ 5,000$ 665$ 5,000$ 445$ 5,000$ 225$ -$ -$ Water Receipts 520,000$ 190,624$ 615,000$ 193,468$ 615,000$ 169,218$ 465,000$ 144,968$ 465,000$ 126,718$ 465,000$ 108,468$ CPC Receipts 260,000$ 95,878$ 260,000$ 86,015$ 260,000$ 75,990$ 255,000$ 65,683$ 195,000$ 56,620$ 195,000$ 48,545$ Excluded Debt 935,000$ 454,781$ 1,063,333$ 522,165$ 1,795,051$ 1,246,986$ 2,437,679$ 1,898,513$ 3,086,798$ 2,391,875$ 3,280,354$ 2,376,405$ Golf Receipts 740,000$ 96,277$ 747,000$ 64,520$ 782,000$ 34,640$ 12,000$ 3,360$ 12,000$ 2,880$ 12,000$ 2,400$ Tax Rate 45,982$ 10,320$ 172,388$ 41,357$ 172,388$ 34,258$ 167,188$ 26,917$ 156,988$ 19,559$ 156,988$ 12,209$ Total Projected Revenue Source 2,629,400$ 873,435$ 2,962,569$ 934,651$ 3,729,287$ 1,584,662$ 3,431,715$ 2,159,134$ 3,985,634$ 2,613,494$ 4,169,190$ 2,560,951$ 3,502,835$ 3,897,220$ 5,313,949$ 5,590,849$ 6,599,128$ 6,730,141$ *NOTE: EXISTING SHORT TERM AND UNISSUED DEBT IS FOR PROJECTION PURPOSES ONLY *NOTE: FORECAST DOES NOT INCLUDE FY2018 - FY2022 TOWN CAPITAL REQUESTS Debt Expenditures by Classification 20222018201920202021 2023 Projected Revenue Source 2018 2019 2020 2021 2022 2023 Debt Service Summary Page 1 of 5 Existing Long Term Debt Existing Short Term Debt Forecasted Debt (Unissued) Total Expense by Classification Road Betterment Water Betterment Water Receipts CPC Receipts Excluded Debt Golf Receipts Tax Rate Total Projected Revenue Source *NOTE: EXISTING SHORT TERM AND UNISSUED DEBT IS FOR PROJECTION PURPOSES ONLY *NOTE: FORECAST DOES NOT INCLUDE FY2018 - FY2022 TOWN CAPITAL REQUESTS Debt Expenditures by Classification Projected Revenue Source Principal Interest Principal Interest Principal Interest Principal Interest Principal Interest Principal Interest 1,385,000$ 389,238$ 1,370,000$ 329,814$ 1,320,000$ 270,811$ 1,240,000$ 234,760$ 1,160,000$ 200,358$ 1,040,000$ 170,698$ 26,848$ 4,890$ 26,848$ 3,816$ 26,848$ 2,742$ 26,848$ 1,668$ 14,848$ 594$ -$ -$ 2,632,911$ 2,069,389$ 2,593,911$ 1,945,341$ 2,588,911$ 1,822,850$ 2,581,811$ 1,700,562$ 2,543,880$ 1,578,556$ 2,543,880$ 1,458,067$ 4,044,759$ 2,463,517$ 3,990,759$ 2,278,971$ 3,935,759$ 2,096,403$ 3,848,659$ 1,936,990$ 3,718,728$ 1,779,508$ 3,583,880$ 1,628,765$ 6,508,276$ 6,269,730$ 6,032,162$ 5,785,649$ 5,498,236$ 5,212,645$ Principal Interest Principal Interest Principal Interest Principal Interest Principal Interest Principal Interest 59,848$ 10,430$ 49,848$ 7,936$ 49,848$ 5,742$ 44,848$ 4,348$ 44,848$ 3,054$ 30,000$ 1,810$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 360,000$ 90,183$ 355,000$ 76,934$ 355,000$ 63,876$ 295,000$ 52,863$ 295,000$ 42,973$ 175,000$ 32,963$ 195,000$ 40,470$ 195,000$ 32,395$ 150,000$ 24,250$ 140,000$ 18,113$ 60,000$ 12,300$ 60,000$ 10,050$ 3,392,911$ 2,315,654$ 3,353,911$ 2,156,406$ 3,348,911$ 1,998,715$ 3,336,811$ 1,858,827$ 3,298,880$ 1,719,321$ 3,298,880$ 1,582,532$ 12,000$ 1,920$ 12,000$ 1,440$ 12,000$ 960$ 12,000$ 480$ -$ -$ -$ -$ 25,000$ 4,860$ 25,000$ 3,860$ 20,000$ 2,860$ 20,000$ 2,360$ 20,000$ 1,860$ 20,000$ 1,410$ 4,044,759$ 2,463,517$ 3,990,759$ 2,278,971$ 3,935,759$ 2,096,403$ 3,848,659$ 1,936,990$ 3,718,728$ 1,779,508$ 3,583,880$ 1,628,765$ 6,508,276$ 6,269,730$ 6,032,162$ 5,785,649$ 5,498,236$ 5,212,645$ 2024 2025 2026 2027 2028 2024 2029 2025 2026 2027 2028 2029 Debt Service Summary Page 2 of 5 Existing Long Term Debt Existing Short Term Debt Forecasted Debt (Unissued) Total Expense by Classification Road Betterment Water Betterment Water Receipts CPC Receipts Excluded Debt Golf Receipts Tax Rate Total Projected Revenue Source *NOTE: EXISTING SHORT TERM AND UNISSUED DEBT IS FOR PROJECTION PURPOSES ONLY *NOTE: FORECAST DOES NOT INCLUDE FY2018 - FY2022 TOWN CAPITAL REQUESTS Debt Expenditures by Classification Projected Revenue Source Principal Interest Principal Interest Principal Interest Principal Interest Principal Interest Principal Interest 1,035,000$ 146,198$ 1,025,000$ 121,090$ 720,000$ 95,031$ 670,000$ 76,106$ 670,000$ 57,500$ 510,000$ 38,500$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 2,543,880$ 1,337,580$ 2,543,880$ 1,217,091$ 2,543,880$ 1,096,602$ 2,543,880$ 976,115$ 2,410,547$ 855,627$ 2,277,214$ 741,805$ 3,578,880$ 1,483,778$ 3,568,880$ 1,338,181$ 3,263,880$ 1,191,633$ 3,213,880$ 1,052,221$ 3,080,547$ 913,127$ 2,787,214$ 780,305$ 5,062,658$ 4,907,061$ 4,455,513$ 4,266,101$ 3,993,674$ 3,567,519$ Principal Interest Principal Interest Principal Interest Principal Interest Principal Interest Principal Interest 30,000$ 1,160$ 20,000$ 490$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 170,000$ 28,113$ 170,000$ 23,250$ 170,000$ 18,175$ 170,000$ 13,050$ 170,000$ 7,550$ 40,000$ 2,000$ 60,000$ 7,800$ 60,000$ 5,475$ 30,000$ 3,075$ 30,000$ 2,100$ 30,000$ 1,050$ -$ -$ 3,298,880$ 1,445,745$ 3,298,880$ 1,308,476$ 3,063,880$ 1,170,383$ 3,013,880$ 1,037,071$ 2,880,547$ 904,527$ 2,747,214$ 778,305$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 20,000$ 960$ 20,000$ 490$ -$ -$ -$ -$ -$ -$ -$ -$ 3,578,880$ 1,483,778$ 3,568,880$ 1,338,181$ 3,263,880$ 1,191,633$ 3,213,880$ 1,052,221$ 3,080,547$ 913,127$ 2,787,214$ 780,305$ 5,062,658$ 4,907,061$ 4,455,513$ 4,266,101$ 3,993,674$ 3,567,519$ 2034 20352030203120322033 2030 2031 2032 2033 2034 2035 Debt Service Summary Page 3 of 5 Existing Long Term Debt Existing Short Term Debt Forecasted Debt (Unissued) Total Expense by Classification Road Betterment Water Betterment Water Receipts CPC Receipts Excluded Debt Golf Receipts Tax Rate Total Projected Revenue Source *NOTE: EXISTING SHORT TERM AND UNISSUED DEBT IS FOR PROJECTION PURPOSES ONLY *NOTE: FORECAST DOES NOT INCLUDE FY2018 - FY2022 TOWN CAPITAL REQUESTS Debt Expenditures by Classification Projected Revenue Source Principal Interest Principal Interest Principal Interest Principal Interest Principal Interest Principal Interest 510,000$ 24,125$ 510,000$ 14,375$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 2,160,547$ 634,650$ 2,149,930$ 531,205$ 2,149,930$ 430,309$ 2,149,930$ 329,412$ 1,788,446$ 228,515$ 1,102,485$ 145,578$ 2,670,547$ 658,775$ 2,659,930$ 545,580$ 2,149,930$ 430,309$ 2,149,930$ 329,412$ 1,788,446$ 228,515$ 1,102,485$ 145,578$ 3,329,322$ 3,205,510$ 2,580,239$ 2,479,342$ 2,016,961$ 1,248,063$ Principal Interest Principal Interest Principal Interest Principal Interest Principal Interest Principal Interest -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 40,000$ 1,000$ 40,000$ 1,000$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 2,630,547$ 657,775$ 2,619,930$ 544,580$ 2,149,930$ 430,309$ 2,149,930$ 329,412$ 1,788,446$ 228,515$ 1,102,485$ 145,578$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 2,670,547$ 658,775$ 2,659,930$ 545,580$ 2,149,930$ 430,309$ 2,149,930$ 329,412$ 1,788,446$ 228,515$ 1,102,485$ 145,578$ 3,329,322$ 3,205,510$ 2,580,239$ 2,479,342$ 2,016,961$ 1,248,063$ 2036 2036 2037 2038 2039 2040 2041 2037 2038 2039 2040 2041 Debt Service Summary Page 4 of 5 Existing Long Term Debt Existing Short Term Debt Forecasted Debt (Unissued) Total Expense by Classification Road Betterment Water Betterment Water Receipts CPC Receipts Excluded Debt Golf Receipts Tax Rate Total Projected Revenue Source *NOTE: EXISTING SHORT TERM AND UNISSUED DEBT IS FOR PROJECTION PURPOSES ONLY *NOTE: FORECAST DOES NOT INCLUDE FY2018 - FY2022 TOWN CAPITAL REQUESTS Debt Expenditures by Classification Projected Revenue Source Principal Interest Principal Interest Principal Interest Principal Interest -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 471,083$ 94,790$ 315,458$ 73,967$ 197,901$ 59,370$ 197,901$ 49,475$ 471,083$ 94,790$ 315,458$ 73,967$ 197,901$ 59,370$ 197,901$ 49,475$ 565,873$ 389,425$ 257,271$ 247,376$ Principal Interest Principal Interest Principal Interest Principal Interest -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 471,083$ 94,790$ 315,458$ 73,967$ 197,901$ 59,370$ 197,901$ 49,475$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 471,083$ 94,790$ 315,458$ 73,967$ 197,901$ 59,370$ 197,901$ 49,475$ 565,873$ 389,425$ 257,271$ 247,376$ 2042 2043 2042 2044 2045 2043 2044 2045 Debt Service Summary Page 5 of 5