The URL can be used to link to this page

5 - Debt Service Cash FlowsCity of Otsego Debt Service Funds - Cash Flows Analysis Fund 350 - G.O. Improvement Bonds, Series 2003A Waterfront West / 85th Street / Page Avenue 4 t Revised: May 15, 2017 Actual Projected 2016 2017 2018 2019 2020 2021 2022 Revenues: Property Taxes $ - $ - $ - $ - $ - $ - $ - Special Assessments 802 770 738 706 674 643 611 Interest on Investments - - - - - - - Total 802 770 738 706 674 643 611 Expenditures: Principal - - - - - - - Interest - - - - - - Transfers Out - - - - - - - Total - - - - - - - Cash Balance - Beginning 823 2,008 2,778 3,516 4,222 4,896 5,539 Change in Accruals 383 - - - - - - Revenues 802 770 738 706 674 643 611 Expenditures - - - - - - - Cash Balance - Ending $ 2,008 $ 2,778 $ 3,516 $ 4,222 $ 4,896 $ 5,539 $ 6,150 Blue cells = projections. City of Otsego 2 Debt Service Funds - Cash Flows Analysis Fund 350 - G.O. Improvement Bonds, Series 2004A Quaday Avenue 4 �) Revised: May 15, 2017 Actual Projected 2016 2017 2018 2019 2020 2021 2022 Revenues: Property Taxes $ - $ - $ - $ - $ - $ - $ - Special Assessments 4,056 - - - - - Interest on Investments - - - - - - - Total 4,056 - - - - - Expenditures: Principal - - - - - - Interest - - - - - - Transfers Out - - - - - Total - - - - - - Cash Balance - Beginning (153,291) (150,760) (150,760) (150,760) (150,760) (150,760) (150,760) Change in Accruals (1,525) - - - - - - Revenues 4,056 - - - Expenditures - - - - - - - Cash Balance - Ending $ (150,760) $ (150,760) $ (150,760) $ (150,760) $ (150,760) $ (150,760) $ (150,760) 63,557.89 118-500-263201: Elk River Rogers Post #5518 22,462.23 118-500-274103: Gilbert Darkenwald Trust 28,230.93 118-500-271400: D&Y Family Ltd. Partnership 10,567.46 118-500-274202: Billie Darkenwald Trust 91,788.82 Total 26,546.27 118-500-274203: D&Y Family Ltd. Partnership 59,575.96 Total 151,364.78 Grand Total - Deferred Assessments City of Otsego A 3 Debt Service Funds - Cash Flows Analysis Fund 375 - G.O. Improvement Refunding Bonds, #A Series 2012A Mississippi Shores Frontage & Waterfront East Revised: May 15, 2017 Actual Projected 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 Revenues: Special Assessments $ 232,519 $ 134,406 $ 129,078 $ 123,749 $ 118,420 $ 113,091 $ 5,938 $ 5,700 $ 5,463 $ 5,225 $ 4,988 Interest on Investments - - - - - - - - - - - Bond Proceeds Transfers In - - - - - - - - - - - Total 232,519 134,406 129,078 123,749 118,420 113,091 5,938 5,700 5,463 5,225 4,988 Expenditures: Principal 195,000 190,000 205,000 210,000 205,000 195,000 - - - - - Interest 24,000 20,100 16,300 12,200 8,000 3,900 Fiscal Agent Fees 808 500 500 500 500 500 Transfers Out - - - - - - Total 219,808 210,600 221,800 222,700 213,500 199,400 - - - - - Cash Balance - Beginning 619,743 632,436 556,242 463,520 364,569 269,489 183,180 189,118 194,818 200,281 205,506 Change in Accruals (18) Revenues 232,519 134,406 129,078 123,749 118,420 113,091 5,938 5,700 5,463 5,225 4,988 Expenditures (219,808) (210,600) (221,800) (222,700) (213,500) (199,400) - - - - - Cash Balance - Ending $ 632,436 $ 556,242 $ 463,520 $ 364,569 $ 269,489 $ 183,180 $ 189,118 $ 194,818 $ 200,281 $ 205,506 $ 210,494 Principal Balance 1,005,000 815,000 610,000 400,000 195,000 - - - - - - Blue cells = projections. City of Otsego Debt ServiceFunds - Cash Flows Analysis Fund 380 - G.O. Improvement Refunding Bonds, Series 2010D & Series 2011A 4191 Queens Avenue & CSAH 42 Revised: May 15, 2017 4J Actual Projected 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Comments Revenues: Property Taxes $ 225,000 $ 225,000 $ 215,000 $ 205,000 $ 195,000 $ 195,000 $ 400,000 $ 400,000 $ 350,000 $ 350,000 $ 325,000 $ 325,000 $ 325,000 $ - $ - Stagnant until 2022 when 2010B (Fund 385) is paid off. Special Assessments 120,657 67,701 132,094 127,394 122,694 117,994 113,294 63,698 61,361 59,024 56,687 6,286 6,052 5,818 5,584 Not included = Development Deferrals ($733k) Interest on Investments - - - - - - - - - - - - - - - Bond Proceeds Transfers In - - - - - - - - - - - - - - - Total 345,657 292,701 347,094 332,394 317,694 312,994 513,294 463,698 411,361 409,024 381,687 331,286 331,052 5,818 5,584 Expenditures: Original Book Levies Principal (2010D) 80,000 80,000 85,000 85,000 85,000 90,000 95,000 95,000 100,000 100,000 105,000 110,000 110,000 - - 2010D 2011A Total Interest (2010D) 35,233 33,633 31,813 29,773 27,541 25,048 22,293 19,348 16,225 12,925 9,543 5,885 1,980 2011 30,814 30,814 Principal (2011A) 365,000 375,000 380,000 395,000 400,000 415,000 425,000 435,000 200,000 210,000 215,000 230,000 235,000 2012 21,901 21,901 Interest (2011A) 96,993 89,593 82,043 74,293 66,243 57,578 48,019 37,588 29,450 23,810 17,645 10,970 3,760 2013 22,447 - 22,447 Fiscal Agent Fees 1,120 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 2014 21,601 267,579 289,180 Transfers Out - - - - - - - - - - - - - 2015 106,189 272,430 378,619 Total 578,345 579,225 579,855 585,065 579,784 588,625 591,311 587,935 346,675 347,735 348,188 357,855 351,740 - 2016 105,097 282,426 387,523 2017 109,255 286,962 396,217 Cash Balance - Beginning 1,629,086 1,396,360 1,109,836 877,075 624,404 362,314 86,683 8,666 (115,571) (50,885) 10,404 43,903 17,334 (3,354) 2,464 2018 107,701 301,893 409,594 Change in Accruals (38) 2019 106,147 306,009 412,155 Revenues 345,657 292,701 347,094 332,394 317,694 312,994 513,294 463,698 411,361 409,024 381,687 331,286 331,052 5,818 5,584 2020 122,147 361,778 483,925 Expenditures (578,345) (579,225) (579,855) (585,065) (579,784) (588,625) (591,311) (587,935) (346,675) (347,735) (348,188) (357,855) (351,740) - - 2021 124,703 367,895 492,598 Cash Balance - Ending $ 1,396,360 $ 1,109,836 $ 877,075 $ 624,404 $ 362,314 $ 86,683 $ 8,666 $ (115,571) $ (50,885) $ 10,404 $ 43,903 $ 17,334 $ (3,354) $ 2,464 $ 8,048 2022 121,611 373,111 494,722 2023 123,769 132,060 255,829 Principal Balance 5,055,000 4,600,000 4,135,000 3,655,000 3,170,000 2,665,000 2,145,000 1,615,000 1,315,000 1,005,000 685,000 345,000 - - 2024 120,304 248,588 368,891 Blue cells = projections. 2025 122,089 247,664 369,752 2026 123,701 256,641 380,342 2027 119,658 254,646 374,304 Total - Bond Documents 5,568,813 Projected 4,362,562 (More) / Less than Original 1,206,251 City of Otsego Debt Service Funds - Cash Flows Analysis Fund 385 - G.O. Improvement Refunding Bonds, Series 2010B City Hall & Public Works Garage M Revised: May 15, 2017 Total Actual I 494,923 495,570 Projected 498,060 494,900 Cash Balance - Beginning 2016 2017 2018 2019 2020 2021 Comments Revenues: (18) 2019 519,106 2020 522,438 2021 Property Taxes $ 415,000 $ 430,000 $ 440,000 $ 450,000 $ 460,000 $ 460,000 Levy amounts modified to meet actual needs. Interest on Investments - - - - - - Bond Proceeds - 175,212 $ 119,642 $ 74,752 $ 36,692 $ 1,792 Transfers In 1,120 - - - - - Total 416,120 430,000 440,000 450,000 460,000 460,000 Expenditures: Principal 425,000 435,000 445,000 455,000 470,000 480,000 Interest 67,923 59,423 50,070 39,390 27,560 14,400 Fiscal Agent Fees 313 500 500 500 500 500 Transfers Out - - - - - - Total 493,236 494,923 495,570 494,890 498,060 494,900 Cash Balance - Beginning 317,268 240,134 175,212 119,642 74,752 36,692 Change in Accruals (18) 2019 519,106 2020 522,438 2021 Revenues 416,120 430,000 440,000 450,000 460,000 460,000 Expenditures (493,236) (494,923) (495,570) (494,890) (498,060) (494,900) Cash Balance - Ending $ 240,134 $ 175,212 $ 119,642 $ 74,752 $ 36,692 $ 1,792 Principal Balance 2,285,000 1,850,000 1,405,000 950,000 480,000 - Blue cells = projections. Total - Bond Documents Projected (More) / Less than Original 5 Original Book Levy 2011 231,148 2012 247,089 2013 243,939 2014 240,789 2015 521,139 2016 517,569 2017 519,144 2018 519,824 2019 519,106 2020 522,438 2021 519,120 4,601,302 3,714,235 887,067 City of Otsego Debt Service Funds - Cash Flows Analysis Fund 395 - G.O. Improvement Bonds, Series 2007E Friendship Addition & Waterfront East k' Revised: May 15, 2017 Actual I Projected 2016 2017 2018 2019 2020 2021 Revenues: Special Assessments $ 91,492 $ 48,116 $ 46,191 $ 44,267 $ 42,342 $ 40,418 Interest on Investments - - - - - - Bond Proceeds - - - - - Transfers In - - - - - - Total 91,492 48,116 46,191 44,267 42,342 40,418 Expenditures: Principal 100,000 - - - - - Interest 4,000 - - - - - Fiscal Agent Fees 313 - - - - Transfers Out - - - - Total 104,313 - - - - - Cash Balance - Beginning (175,044) (187,883) (139,767) (93,576) (49,309) (6,967) Change in Accruals (18) Revenues 91,492 48,116 46,191 44,267 42,342 40,418 Expenditures (104,313) - - - - - Cash Balance - Ending $ (187,883) $ (139,767) $ (93,576) $ (49,309) $ (6,967) $ 33,451 Principal Balance - - - - - - Blue cells = projections. City of Otsego Debt Service Funds - Cash Flows Analysis Fund 399 - G.O. Equipment Certificates, Series 2010A Jet Vac Truck Revised: May 15, 2017 Blue cells = projections. Actual Projected 2016 2017 2018 2019 Revenues: Transfers In - Water $ 10,000 $ 9,800 $ 9,600 $ 8,200 Transfers In - Sewer 40,000 39,200 38,400 32,800 Transfers In - Storm - - - - Transfers In - Other - - - - Interest on Investments - - - - Bond Proceeds - - - - Total 50,000 49,000 48,000 41,000 Expenditures: Principal 45,000 45,000 45,000 40,000 Interest 5,350 4,000 2,650 1,300 Fiscal Agent Fees 808 500 500 500 Transfers Out - - - - Total 51,158 49,500 48,150 41,800 Cash Balance - Beginning 314 (187) (12) 513 Change in Accruals 657 675 675 650 Revenues 50,000 49,000 48,000 41,000 Expenditures (51,158) (49,500) (48,150) (41,800) Cash Balance - Ending $ (187) $ (12) $ 513 $ 363 Principal Balance 130,000 85,000 40,000 - Blue cells = projections.