Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
3-DSF Cash Flows
City of OtsegoDebt Service Funds ‐ Cash Flows AnalysisFund 375 ‐ G.O. Improvement Refunding Bonds, Series 2012AMississippi Shores Frontage & Waterfront EastRevised: June 3, 2021Actual Budget2020 2021 2022 2023 2024 2025 2026 CommentsRevenues:Special Assessments 34,911$ 33,045$ 5,938$ 5,700$ 5,463$ 5,225$ 4,988$ There are no delinquent balances.Interest on Investments ‐ ‐ ‐ ‐ ‐ ‐ ‐ Bond Proceeds ‐ ‐ ‐ ‐ ‐ ‐ ‐ Transfers In ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 34,911 33,045 5,938 5,700 5,463 5,225 4,988 Expenditures:Principal 205,000 195,000 ‐ ‐ ‐ ‐ ‐ Interest 8,000 3,900 ‐ ‐ ‐ ‐ ‐ Fiscal Agent Fees 656 500 ‐ ‐ ‐ ‐ ‐ Transfers Out ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 213,656 199,400 ‐ ‐ ‐ ‐ ‐ Cash Balance ‐ Beginning347,936 169,174 2,819 8,757 14,457 19,920 25,145 Change in Accruals (17) Revenues34,911 33,045 5,938 5,700 5,463 5,225 4,988 Expenditures(213,656) (199,400) ‐ ‐ ‐ ‐ ‐ Cash Balance ‐ Ending169,174$ 2,819$ 8,757$ 14,457$ 19,920$ 25,145$ 30,133$ Close Fund in 2021, Reclass AssessmentsPrincipal Balance195,000 ‐ ‐ ‐ ‐ ‐ ‐ Blue cells = projections.ProjectedX:\Budget\2022\Cash Flows\Debt Service Funds375-IMP 2012AItem 3.5 City of OtsegoDebt Service Funds ‐ Cash Flows AnalysisFund 376 ‐ G.O. Improvement Bonds, Series 2018AMississippi Shores Renewal & Kadler Avenue ConstructionRevised: June 3, 2021Actual Budget2020 2021 2022 2023 2024 2025 2026 CommentsRevenues:Property Taxes 91,758$ 94,551$ 97,187$ 94,415$ 102,144$ 104,308$ 106,313$ Levy per Bond Issuance DocumentsSpecial Assessments 193,999 139,013 135,122 131,230 127,338 123,446 119,554 Not included = $966 delinquent balance.Interest on Investments‐ ‐ ‐ ‐ ‐ ‐ ‐ Bond Proceeds‐ ‐ ‐ ‐ ‐ ‐ ‐ Transfers In‐ ‐ ‐ ‐ ‐ ‐ ‐ Total285,757 233,564 232,309 225,645 229,482 227,754 225,867 Expenditures:Principal170,000 180,000 185,000 190,000 190,000 200,000 205,000 Interest66,856 61,606 56,131 50,506 44,806 38,956 32,881 Fiscal Agent Fees656 500 500 500 500 500 500 Transfers Out‐ ‐ ‐ ‐ ‐ ‐ ‐ Total237,512 242,106 241,631 241,006 235,306 239,456 238,381 Cash Balance ‐ Beginning380,989 428,683 420,141 410,819 395,458 389,634 377,932 Change in Accruals(551) Revenues285,757 233,564 232,309 225,645 229,482 227,754 225,867 Expenditures(237,512) (242,106) (241,631) (241,006) (235,306) (239,456) (238,381) Cash Balance ‐ Ending428,683$ 420,141$ 410,819$ 395,458$ 389,634$ 377,932$ 365,418$ Debt Service Until 2034Principal Balance2,135,000 1,955,000 1,770,000 1,580,000 1,390,000 1,190,000 985,000 Blue cells = projections.ProjectedX:\Budget\2022\Cash Flows\Debt Service Funds376-IMP 2018AItem 3.5 City of OtsegoDebt Service Funds ‐ Cash Flows AnalysisFund 380 ‐ G.O. Improvement Refunding Bonds, Series 2020AQueens Avenue & CSAH 42Revised: June 3, 2021Actual Budget2020 2021 2022 2023 2024 2025 2026 CommentsRevenues:Property Taxes 195,000$ 195,000$ 450,000$ 450,000$ 425,000$ 400,000$ 375,000$ Special Assessments 134,571 110,304 105,838 56,476 54,373 52,270 50,168 Not included = Deferrals ($558k)Interest on Investments‐ ‐ ‐ ‐ ‐ ‐ ‐ Bond Proceeds3,262,200 ‐ ‐ ‐ ‐ ‐ ‐ Transfers In‐ ‐ ‐ ‐ ‐ ‐ ‐ Total3,591,771 305,304 555,838 506,476 479,373 452,270 425,168 Expenditures:Principal3,655,000 505,000 475,000 495,000 270,000 280,000 290,000 Interest119,834 73,156 88,300 68,900 53,600 42,600 31,200 Fiscal Agent Fees63,517 500 500 500 500 500 500 Transfers Out‐ ‐ ‐ ‐ ‐ ‐ ‐ Total3,838,351 578,656 563,800 564,400 324,100 323,100 321,700 Cash Balance ‐ Beginning732,230 485,614 212,262 204,300 146,376 301,649 430,819 Change in Accruals(36) Revenues3,591,771 305,304 555,838 506,476 479,373 452,270 425,168 Expenditures(3,838,351) (578,656) (563,800) (564,400) (324,100) (323,100) (321,700) Cash Balance ‐ Ending485,614$ 212,262$ 204,300$ 146,376$ 301,649$ 430,819$ 534,287$ Debt Service Until 2028Principal Balance2,950,000 2,445,000 1,970,000 1,475,000 1,205,000 925,000 635,000 Blue cells = projections.ProjectedX:\Budget\2022\Cash Flows\Debt Service Funds380-IMP 2020AItem 3.5 City of OtsegoDebt Service Funds ‐ Cash Flows AnalysisFund 385 ‐ G.O. Improvement Refunding Bonds, Series 2010BCity Hall & Public Works GarageRevised: June 3, 2021Actual Actual Actual Actual Actual Actual Budget2015 2016 2017 2018 2019 2020 2021 CommentsRevenues:Property Taxes 410,000$ 415,000$ 430,000$ 440,000$ 450,000$ 460,000$ 460,000$ Interest on Investments ‐ ‐ ‐ ‐ ‐ ‐ ‐ Bond Proceeds ‐ ‐ ‐ ‐ ‐ ‐ ‐ Transfers In ‐ 1,120 ‐ ‐ ‐ ‐ ‐ Total 410,000 416,120 430,000 440,000 450,000 460,000 460,000 Expenditures:Principal 420,000 425,000 435,000 445,000 455,000 470,000 480,000 Interest 76,323 67,923 59,423 50,070 39,390 27,560 14,400 Fiscal Agent Fees 331 313 357 667 674 656 500 Transfers Out ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 496,654 493,236 494,780 495,737 495,064 498,216 494,900 Cash Balance ‐ Beginning401,578 317,268 240,134 175,399 119,477 74,420 36,187 Change in Accruals 2,344 (18) 45 (185) 7 (17) Revenues410,000 416,120 430,000 440,000 450,000 460,000 460,000 Expenditures(496,654) (493,236) (494,780) (495,737) (495,064) (498,216) (494,900) Cash Balance ‐ Ending317,268$ 240,134$ 175,399$ 119,477$ 74,420$ 36,187$ 1,287$ Close Fund in 2021Principal Balance2,710,000 2,285,000 1,850,000 1,405,000 950,000 480,000 ‐ Blue cells = projections.X:\Budget\2022\Cash Flows\Debt Service Funds385-IMP 2010BItem 3.5