Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Debt - BTA by Fund
City of Otsego Debt Service Fund Budget ‐ 2019 Fund 375 ‐ G.O. Improvement Refunding Bonds, Series 2012A Mississippi Shores Frontage & Waterfront East Actual Actual Year‐to‐Date Budget Budget Fund Department Object Account Description 2017 2018 2019 2019 2020 Revenues 375 47000 36100 SPECIAL ASSESSMENTS 384,480$ 55,686$ ‐$ 52,103$ 49,890$ 375 47000 36102 SPECIAL ASSESSMENTS INTEREST ‐ ‐ ‐ ‐ ‐ 375 47000 36210 INVESTMENT EARNINGS ‐ ‐ ‐ ‐ ‐ TOTAL 384,480 55,686 ‐ 52,103 49,890 Expenditures 375 47000 601 PRINCIPAL 190,000 205,000 ‐ 210,000 205,000 375 47000 602 INTEREST 20,100 16,300 6,100 12,200 8,000 375 47000 620 FISCAL AGENT FEE'S 852 667 ‐ 500 500 375 47000 720 TRANSFERS OUT 149,234 ‐ ‐ ‐ ‐ TOTAL 360,186 221,967 6,100 222,700 213,500 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES 24,294$ (166,281)$ (6,100)$ (170,597)$ (163,610)$ Fund 375 ‐ G.O. Improvement Refunding Bonds, Series 2012A Account Number City of Otsego Debt Service Fund Budget ‐ 2019 Fund 376 ‐ G.O. Improvement Bonds, Series 2018A Mississippi Shores Renewal & Kadler Avenue Construction Actual Actual Year‐to‐Date Budget Budget Fund Department Object Account Description 2017 2018 2019 2019 2020 Revenues 376 47000 31010 CURRENT AD VALOREM TAXES ‐$ ‐$ ‐$ 79,293$ 91,757$ 376 47000 36100 SPECIAL ASSESSMENTS ‐ 99,515 10,915 146,536 159,120 376 47000 36210 INTEREST EARNINGS ‐ 8,254 ‐ ‐ ‐ 376 47000 39230 BOND PREMIUM ‐ 58,475 ‐ ‐ ‐ 376 47000 39300 BOND PROCEEDS ‐ 52,509 ‐ ‐ ‐ TOTAL ‐ 218,753 10,915 225,829 250,877 Expenditures 376 47000 601 PRINCIPAL ‐ ‐ ‐ ‐ 170,000 376 47000 602 INTEREST ‐ ‐ 38,559 73,262 66,856 376 47000 620 FISCAL AGENT FEE'S ‐ 71,670 ‐ 500 500 376 47000 720 TRANSFERS OUT ‐ ‐ ‐ ‐ ‐ TOTAL ‐ 71,670 38,559 73,762 237,356 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES ‐$ 147,083$ (27,644)$ 152,067$ 13,521$ Fund 376 ‐ G.O. Improvement Bonds, Series 2018A Account Number City of Otsego Debt Service Fund Budget ‐ 2019 Fund 380 ‐ G.O. Improvement Refunding Bonds, Series 2010D & Series 2011A Queens Avenue & CSAH 42 Actual Actual Year‐to‐Date Budget Budget Fund Department Object Account Description 2017 2018 2019 2019 2020 Revenues 380 47000 31010 CURRENT AD VALOREM TAXES 225,000$ 215,000$ ‐$ 205,000$ 195,000$ 380 47000 36100 SPECIAL ASSESSMENTS 64,183 235,754 ‐ 127,394 114,770 380 47000 39200 TRANSFERS IN 2,008 ‐ ‐ ‐ ‐ TOTAL 291,192 450,754 ‐ 332,394 309,770 Expenditures 380 47000 601 PRINCIPAL 455,000 465,000 480,000 480,000 485,000 380 47000 602 INTEREST 123,225 113,855 54,518 104,066 93,784 380 47000 620 FISCAL AGENT FEE'S 1,209 839 495 1,000 1,000 TOTAL 579,434 579,694 535,013 585,066 579,784 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES (288,243)$ (128,939)$ (535,013)$ (252,672)$ (270,014)$ Fund 380 ‐ G.O. Improvement Refunding Bonds, Series 2010D & 2011A Account Number City of Otsego Debt Service Fund Budget ‐ 2019 Fund 385 ‐ G.O. Improvement Refunding Bonds, Series 2010B City Hall & Public Works Garage Actual Actual Year‐to‐Date Budget Budget Fund Department Object Account Description 2017 2018 2019 2019 2020 Revenues 385 47000 31010 CURRENT AD VALOREM TAXES 430,000$ 440,000$ ‐$ 450,000$ 460,000$ 385 47000 39203 TRANSFERS IN ‐ ‐ ‐ ‐ ‐ TOTAL 430,000 440,000 ‐ 450,000 460,000 Expenditures 385 47000 601 PRINCIPAL 435,000 445,000 ‐ 455,000 470,000 385 47000 602 INTEREST 59,423 50,070 19,695 39,390 27,560 385 47000 620 FISCAL AGENT FEE'S 357 667 ‐ 500 500 TOTAL 494,780 495,737 19,695 494,890 498,060 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES (64,780)$ (55,737)$ (19,695)$ (44,890)$ (38,060)$ Fund 385 ‐ G.O. Improvement Refunding Bonds, Series 2010B Account Number City of Otsego Debt Service Fund Budget ‐ 2019 Fund 395 ‐ G.O. Improvement Bonds, Series 2007B Friendship Addition & Waterfront East Actual Actual Year‐to‐Date Budget Budget Fund Department Object Account Description 2017 2018 2019 2019 2020 Revenues 395 47000 36100 SPECIAL ASSESSMENTS 163,481$ 12,714$ ‐$ 11,894$ 11,376$ TOTAL 163,481 12,714 ‐ 11,894 11,376 Expenditures 395 47000 601 PRINCIPAL ‐ ‐ ‐ ‐ ‐ 395 47000 602 INTEREST ‐ ‐ ‐ ‐ ‐ 395 47000 620 FISCAL AGENT FEE'S ‐ ‐ ‐ ‐ ‐ TOTAL ‐ ‐ ‐ ‐ ‐ EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES 163,481$ 12,714$ ‐$ 11,894$ 11,376$ Fund 395 ‐ G.O. Improvement Bonds, Series 2007B Account Number City of Otsego Debt Service Fund Budget ‐ 2019 Fund 399 ‐ G.O. Equipment Certificates, Series 2010A Jet Vac Truck Actual Actual Year‐to‐Date Budget Budget Fund Department Object Account Description 2017 2018 2019 2019 2020 Revenues 399 47000 39203 TRANSFERS IN 49,000$ 48,000$ ‐$ 41,000$ ‐$ TOTAL 49,000 48,000 ‐ 41,000 ‐ Expenditures 399 47000 601 PRINCIPAL 45,000 45,000 ‐ 40,000 ‐ 399 47000 602 INTEREST 4,000 2,650 650 1,300 ‐ 399 47000 620 FISCAL AGENT FEE'S 852 667 ‐ 500 ‐ TOTAL 49,852 48,317 650 41,800 ‐ EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES (852)$ (317)$ (650)$ (800)$ ‐$ Account Number Fund 399 ‐ G.O. Equipment Certificates, Series 2010A City of Otsego Debt Service Fund Budget ‐ 2019 Fund 360 ‐ G.O. Revenue Refunding Bonds, Series 2009A & Series 2010C Water & Sanitary Sewer Infrastructure + Buildings Actual Actual Year‐to‐Date Budget Budget Fund Department Object Account Description 2017 2018 2019 2019 2020 Revenues 360 47000 34406 WATER AVAILABILITY + CONNECTION CHARGES 1,029,991$ 966,004$ 626,214$ 445,250$ 449,750$ 360 47000 36100 SPECIAL ASSESSMENTS 6,928 96,356 ‐ 21,602 28,056 360 47000 36210 INVESTMENT EARNINGS 53,552 71,917 ‐ ‐ ‐ 360 47000 36213 INVESTMENT FAIR MARKET VALUE ADJUSTMENT (22,265) (20,667) ‐ ‐ ‐ 360 47000 39200 TRANSFERS IN 93,820 93,820 93,820 93,820 93,820 TOTAL 1,162,026 1,207,431 720,034 560,672 571,626 Expenditures 360 47000 510 LAND ACQUISITION / EASEMENTS 4,632 ‐ ‐ ‐ ‐ 360 47000 530 IMPROVEMENTS OTHER THAN BLDG ‐ 20,955 ‐ ‐ ‐ 360 47000 601 PRINCIPAL ‐ ‐ ‐ 799,200 840,600 360 47000 602 INTEREST 345,358 315,940 143,912 287,824 255,856 360 47000 620 FISCAL AGENT FEE'S 714 528 ‐ 750 750 360 47000 650 DEBT SERVICE AMORTIZATION'S (28,398) (28,397) ‐ (28,398) (28,398) 360 47000 750 TRANSFER OUT ‐ CAPITAL ASSETS 40,830 ‐ ‐ ‐ ‐ TOTAL 363,135 309,026 143,912 1,059,376 1,068,808 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES 798,891$ 898,405$ 576,122$ (498,704)$ (497,182)$ Fund 360 ‐ G.O. Revenue Refunding Bonds, Series 2009A & 2010C Account Number City of Otsego Debt Service Fund Budget ‐ 2019 Fund 361 ‐ G.O. Revenue Refunding Bonds, Series 2009A & Series 2010C Water & Sanitary Sewer Infrastructure + Buildings Actual Actual Year‐to‐Date Budget Budget Fund Department Object Account Description 2017 2018 2019 2019 2020 Revenues 361 47000 34407 SEWER AVAILABILITY + CONNECTION CHARGES 2,526,404$ 2,973,952$ 1,966,262$ 1,403,600$ 1,417,750$ 361 47000 36100 SPECIAL ASSESSMENTS 13,716 159,042 ‐ 62,113 60,137 361 47000 36210 INVESTMENT EARNINGS 110,191 170,925 ‐ ‐ ‐ 361 47000 36213 INVESTMENT FAIR MARKET VALUE ADJUSTMENT (45,813) (49,119) ‐ ‐ ‐ 361 47000 39200 TRANSFERS IN 106,180 166,790 166,790 166,790 166,790 TOTAL 2,710,678 3,421,590 2,133,052 1,632,503 1,644,677 Expenditures 361 47000 510 LAND ACQUISITION / EASEMENTS 4,632 ‐ ‐ ‐ ‐ 361 47000 601 PRINCIPAL ‐ ‐ ‐ 1,420,800 1,494,400 361 47000 602 INTEREST 613,969 561,670 255,843 511,686 454,854 361 47000 620 FISCAL AGENT FEE'S 991 805 ‐ 1,500 1,500 361 47000 650 DEBT SERVICE AMORTIZATION'S (50,485) (50,484) ‐ (50,484) (50,484) 361 47000 750 TRANSFER OUT ‐ CAPITAL ASSETS 40,830 ‐ ‐ ‐ ‐ TOTAL 609,937 511,992 255,843 1,883,502 1,900,270 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES 2,100,741$ 2,909,598$ 1,877,209$ (250,999)$ (255,593)$ Fund 361 ‐ G.O. Revenue Refunding Bonds, Series 2009A & 2010C Account Number