|
ATTACHMENT 3
<br />Debt Study Projected ending fund balances -42,500.00 -50,000.00 -20,000.00 -95,000.00 -97,500.00 -152,500.00 -100,000.00
<br />0.00
<br />Projected Year 2021-2023 Fund
<br />2022
<br />Projected
<br />Excess 10% Hedge
<br />Available for
<br />2023+2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040
<br />- 503/ B4 08 1,227 - 1,227 (23,000) (35,000) - -
<br />(60,615) 345/503 576,622 - 516,007 (50,000) (50,000) (55,009) (56,835) (61,800) (60,615)
<br />(10,000) 365/2008 15,000 (1,500) 3,500 (5,000) (15,000) (5,000) (20,000) (5,000) (5,000)
<br />- 512/2009 - - -
<br />- 514/2010 - - - -
<br />- 516/2011 - - -
<br />(116,000) 518/2012 116,000 - - (5,000) (5,000) (40,475) (40,000) (40,000) (36,000)
<br />- 520/2013 - - - (25,000) (45,000) (35,000) (32,500) - -
<br />- 522/2014 - - (12,500) (5,000) (30,000) (35,000)
<br />(165,000) 524/2015 165,000 - - (30,000) (35,000) (20,000) (40,000) (40,000) (40,000) (35,000) (30,000) (20,000)
<br />(100,000) 526/2016 110,000 (11,000) (1,000) (20,000) (25,000) (20,000) (20,000) (20,000) (20,000) (20,000)
<br />(125,000) 528/2017 155,000 (15,500) 14,500 (20,000) (105,000) (125,000)
<br />(30,000) 530/2018 100,000 (10,000) 60,000 (79,792) (15,000) (15,000) (15,000) (15,000) (15,000) (15,000) (15,000)
<br />(65,000) 531&2/19 80,000 (8,000) 7,000 (35,000) (30,000)
<br />(297,000) 311/502 371,200 (37,120) 37,080 (35,000) (55,000) (60,000) (75,000) (70,000) (150,000) (147,000) (65,000)
<br />(968,615) 1,690,049 (83,120) 638,314 - - (127,500) (195,000) (200,009) (290,310) (504,092) (490,615) (297,000) (171,000) (65,000) (55,000) (15,000) (15,000) - - - - - - - - - - - -
<br />CUMULATIVE -127,500.00 -322,500.00 -395,009.00 -490,319.00 -794,402.00 -994,707.00 -787,615.00
<br />WO 311 -92,500.00 -140,000.00 -140,009.00 -215,310.00 -354,300.00 -340,615.00 -150,000.00 -106,000.00 -65,000.00 -55,000.00
<br />BAL DS FUNDS (142,500) (50,000) (20,000) (95,000) (97,500) (152,500) (100,000)
<br />-
<br />311.00 (17,500) (7,500) (10,000) (7,500) (25,000) (55,000) (95,000)
<br />345 DEBT SEVICE 56,028.98 55,029.24 54,029.75 57,980.20 61,830.17 60,615.00
<br />1,913,699.00 2,893,671.00 -0.33
<br />228,585.00 1,827,205.91 1,833,431.01 -406,490.00
<br />344,897.00 361,207.00 344,882.00 2,487,181.00
<br />2,487,181.00 224,877.32 227,430.00
<br />2,775,790.23 2,863,743.01 2,918,395.45 2,893,671.00 3,033,001.30 2,979,170.00 2,955,240.57 2,359,828.30 2,173,860.71 2,135,165.35 2,015,305.11 1,976,556.68 2,109,520.32 1,956,218.50 1,995,731.39 1,977,748.44 1,786,005.29 1,744,179.23 1,712,841.49 1,405,384.19
<br />2,775,790.23 2,891,895.34 2,931,684.78 2,994,787.06 3,136,322.93 3,148,744.71 3,215,548.60 2,852,650.60 2,740,769.12 2,781,268.34 2,705,388.27 2,641,412.57 2,579,464.98 2,465,793.28 2,329,097.00 2,273,299.00 2,072,850.00 1,909,072.00 1,732,421.00 1,500,740.00
<br />0.00 -28,152.33 -13,289.33 -101,116.06 -103,321.63 -169,574.71 -260,308.03 -492,822.30 -566,908.41 -646,102.99 -690,083.16 -664,855.89 -469,944.66 -509,574.78 -333,365.61 -295,550.56 -286,844.71 -164,892.77 -19,579.51 -95,355.81
<br />2,413,290.23 2,405,743.01 2,480,886.45 2,487,181.00 2,487,180.67 2,487,181.00 2,487,180.57 2,244,828.30 2,123,860.71 2,060,165.35 1,965,305.11 1,926,556.68 1,909,520.32 1,956,218.50 1,995,731.39 1,977,748.44 1,786,005.29 1,744,179.23 1,712,841.49
<br />2,413,290.23 2,473,895.34 2,554,184.78 2,630,787.06 2,680,822.93 2,766,244.71 2,850,548.60 2,850,548.60 2,740,769.12 2,746,090.34 2,705,388.27 2,641,412.57 2,579,464.98 2,515,793.28 2,504,097.00 2,573,299.00 2,572,850.00 2,559,072.00 2,532,421.00
<br />0.00 -68,152.33 -73,298.33 -143,606.06 -193,642.26 -279,063.71 -363,368.03 -605,720.30 -616,908.41 -685,924.99 -740,083.16 -714,855.89 -669,944.66 -559,574.78 -508,365.61 -595,550.56 -786,844.71 -814,892.77 -819,579.51
<br />1,833,431.01 1,914,886 1,927,204 1,913,699 1,985,860 1,976,110 2,076,413 2,027,471 2,060,165 1,965,305 1,926,557 1,909,520 1,956,219 1,995,731 1,977,748 1,786,005 1,744,179 1,712,841 1,405,384
<br />344,882.00 343,347.00 341,602.00 344,897.00 272,683.00 11,845,237$
<br />227,430.00 222,653.00 218,375.00 228,585.00 228,638.00
<br />2,405,743.01 2,480,886.45 2,487,181.00 2,487,180.67 2,487,181.00
<br />1,935,204.00
<br />8,000.00
<br />3,295.00
<br />2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030
<br />231,288 231,594 236,622 236,049 235,114 238,929 237,182 93,627
<br />2893671
<br />406,490
<br />2,487,181 2016B 104,370 102,585 106,050 104,160 102,270 105,630 103,635 96,390
<br />502.00 2009 REFUND 2017A 123,060 120,068 122,325 124,425 126,368 128,152 129,780
<br />227,430 222,653 228,375 228,585 228,638 233,782 233,415 96,390 0
<br />In fund 401 not levied 2017a FD TAX ABT 68,880 72,555 70,823 69,090 67,358 70,875 68,985 72,345 70,298
<br />BOND 2012A
<br />105.91 2006 503 215,808.76 221,898.75 222,528.74
<br />2007 503 166,767.46 168,657.46 170,442.47 166,783.20
<br />2012 518 143,641.95 140,596.96 142,801.95 139,573.20 141,358.20 142,864.95 138,580.96 139,546.95 140,032.58
<br />526,218.17 531,153.17 535,773.16 306,356.40 141,358.20 142,864.95 138,580.96 139,546.95 140,032.58
<br />-0.17 -0.17 -0.16 -0.40 -0.20 0.05 0.04 0.05 0.42
<br />27,567.00
<br />-21,272.4500000001
<br />2,010.00 #REF!
<br />2,011.00 #REF!
<br />#REF!
<br />116,180.00
<br />#REF!
<br />137,340 133,140 134,190 135,030 135,660 136,080 131,040
<br />125,653$ 121,883$ 123,363$ 124,633$ 125,694$ 126,544$ 121,934$
<br />11,687.00 11,257.00 10,827.00 10,397.00 9,966.00 9,536.00 9,106.00
<br />2,905,358.00 3,044,258.30 2,989,997.00 2,965,637.57 2,369,794.30 2,183,396.71 2,144,271.35
<br />#REF!#REF!#REF!#REF!#REF!#REF!#REF!
<br />Z:\Budget 2022\03 09 debt levy ws\final 2022 debt levy .xlsx 12/30/2021
<br />77
|