Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
2-Capital Cash Flows
City of Otsego Pavement Management Fund Cash Flow Summary Revised: August 23, 2024 -10.00%-5.56%-5.88%-6.25%-6.67%-7.14%-7.69%-8.33%-9.09%-10.00%Change in Property Tax Levy Actual Forecast 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 Comments Revenues Property Taxes 1,100,000$ 1,000,000$ 900,000$ 850,000$ 800,000$ 750,000$ 700,000$ 650,000$ 600,000$ 550,000$ 500,000$ 450,000$ Intergovernmental (MSA)296,100 334,677 336,350 338,032 339,722 341,421 343,128 344,844 346,568 348,301 350,042 351,792 MSA Maintenance (1/2% Annual Inflation) Intergovernmental (Other)- 9,635 - - - - - - - - - - Franchise Fees (Actual)900,252 - - - - - - - - - - - Actual Franchise Fee Receipts Franchise Fees (Future)- 900,252 909,255 918,347 927,531 936,806 946,174 955,636 965,192 974,844 984,592 994,438 Based on Prior Year Actual Franchise Fees (New Growth)- 9,003 9,093 9,183 9,275 9,368 9,462 9,556 9,652 9,748 9,846 9,944 Based on Expected Growth (1% Increase) Special Assessments (Actual)107,985 - - - - - - - - - - - Actual Wright County Settlements Special Assessments (Levied)- 50,294 72,224 66,332 60,480 51,244 49,456 47,668 45,880 42,592 31,121 16,693 Existing levied assessments ($151k Deferred Not Included) Special Assessments (Future)- -- - 22,154 21,521 20,888 47,202 60,990 59,153 57,316 68,176 Assessments on future projects Investment Interest 232,320 - - - - - - - - - - - Refunds & Reimbursements 2,063 - - - - - - - - - - - Total 2,638,720 2,303,861 2,226,921 2,181,895 2,159,162 2,110,360 2,069,108 2,054,906 2,028,282 1,984,638 1,932,917 1,891,044 Expenses Engineering 212,170 - - - - - - - - - - - Other Charges & Services 2,300 - - - - - - - - - - - Capital Outlay 2,283,710 - - - - - - - - - - - Capital Outlay (CIP-Maintenance)- 216,400 279,265 310,223 323,763 274,851 319,606 301,138 280,505 330,828 264,298 270,390 2024 (CIP Budget) / 2025-2034 (CIP Budget) Capital Outlay (CIP-Microsurface)- 457,818 - 281,880 206,447 147,562 443,307 210,460 216,814 736,267 464,696 476,313 2024 (As Bid) / 2025-2034 (CIP Budget) Capital Outlay (CIP-Mill+Overlay)- 906,184 1,266,794 828,702 1,763,089 1,934,451 572,325 1,135,454 98,914 1,138,657 1,097,803 1,125,248 2024 (As Bid) / 2025-2034 (CIP Budget) Capital Outlay (CIP-Renewal)- 1,057,443 - 831,258 - - 1,011,131 569,973 - - 476,424 488,335 2024 (As Bid) / 2025-2034 (CIP Budget) Total 2,498,180 2,637,845 1,546,059 2,252,063 2,293,299 2,356,864 2,346,369 2,217,025 596,233 2,205,752 2,303,221 2,360,286 Cash Balance - Beginning 5,346,134 5,573,912 5,239,928 5,920,790 5,850,622 5,716,485 5,469,981 5,192,719 5,030,600 6,462,649 6,241,535 5,871,231 Balance Sheet Effects 87,238 Revenues 2,638,720 2,303,861 2,226,921 2,181,895 2,159,162 2,110,360 2,069,108 2,054,906 2,028,282 1,984,638 1,932,917 1,891,044 Expenditures (2,498,180) (2,637,845) (1,546,059) (2,252,063) (2,293,299) (2,356,864) (2,346,369) (2,217,025) (596,233) (2,205,752) (2,303,221) (2,360,286) Cash Balance - Ending 5,573,912$ 5,239,928$ 5,920,790$ 5,850,622$ 5,716,485$ 5,469,981$ 5,192,719$ 5,030,600$ 6,462,649$ 6,241,535$ 5,871,231$ 5,401,989$ Cash Balance - % of Next Year Capital 211%339%263%255%243%233%234%844%293%271%249% Projection - Capital Improvement Plan Y:\Budget\2025\Cash Flows\Capital Funds 201-Pavement Management Item 2 City of Otsego Trail Management Fund Cash Flow Summary Revised: August 23, 2024 7.69%8.57%7.89%7.32%6.82%6.38%6.00%5.66%5.36%5.08%4.84% Actual Forecast 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 Comments Revenues Property Taxes 65,000$ 70,000$ 76,000$ 82,000$ 88,000$ 94,000$ 100,000$ 106,000$ 112,000$ 118,000$ 124,000$ 130,000$ Investment Interest 9,217 - - - - - - - - - - - Total 74,217 70,000 76,000 82,000 88,000 94,000 100,000 106,000 112,000 118,000 124,000 130,000 Expenses Capital Outlay 134,450 - - - - - - - - - - - Capital Outlay (CIP-Maintenance)- 63,162 70,000 72,000 74,000 76,000 78,000 80,000 82,000 84,000 86,000 88,000 2024 (Quoted) / 2025-2034 (CIP Budget) Capital Outlay (CIP-Renewal)- - - 100,000 - - 115,000 - - 130,000 - - 2025-2034 (CIP Budget) Total 134,450 63,162 70,000 172,000 74,000 76,000 193,000 80,000 82,000 214,000 86,000 88,000 Cash Balance - Beginning 261,239 201,006 207,844 213,844 123,844 137,844 155,844 62,844 88,844 118,844 22,844 60,844 Balance Sheet Effects - Revenues 74,217 70,000 76,000 82,000 88,000 94,000 100,000 106,000 112,000 118,000 124,000 130,000 Expenditures (134,450) (63,162) (70,000) (172,000) (74,000) (76,000) (193,000) (80,000) (82,000) (214,000) (86,000) (88,000) Cash Balance - Ending 201,006$ 207,844$ 213,844$ 123,844$ 137,844$ 155,844$ 62,844$ 88,844$ 118,844$ 22,844$ 60,844$ 102,844$ Cash Balance - % of Next Year Capital 318%297%124%167%181%81%79%108%56%27%69% Projection - Capital Improvement Plan Y:\Budget\2025\Cash Flows\Capital Funds 202-Trail Management City of Otsego Park Equipment Fund Cash Flow Summary Revised: August 23, 2024 6.25%5.88%5.56%5.26%0.00%0.00%0.00%0.00%0.00%0.00% Actual Forecast 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 Comments Revenues Property Taxes 70,000$ 400,000$ 425,000$ 450,000$ 475,000$ 500,000$ 500,000$ 500,000$ 500,000$ 500,000$ 500,000$ 500,000$ Contributions - Soccer 12,500 12,500 12,500 12,500 12,500 12,500 12,500 12,500 12,500 12,500 - - Boreal Soccer - Lighting Contribution Investment Interest 16,815 - - - - - - - - - - - Transfers In 66,042 - - - - - - - - - - - Total 165,357 412,500 437,500 462,500 487,500 512,500 512,500 512,500 512,500 512,500 500,000 500,000 Expenses Capital Outlay 735,234 - - - - - - - - - - - Capital Outlay (CIP)- - 80,000 580,000 830,000 500,000 - 560,000 - 575,000 - 565,000 2025-2034 (CIP Budget) Total 735,234 - 80,000 580,000 830,000 500,000 - 560,000 - 575,000 - 565,000 Cash Balance - Beginning 675,502 113,334 525,834 883,334 765,834 423,334 435,834 948,334 900,834 1,413,334 1,350,834 1,850,834 Balance Sheet Effects 7,709 Revenues 165,357 412,500 437,500 462,500 487,500 512,500 512,500 512,500 512,500 512,500 500,000 500,000 Expenditures (735,234) - (80,000) (580,000) (830,000) (500,000) - (560,000) - (575,000) - (565,000) Cash Balance - Ending 113,334$ 525,834$ 883,334$ 765,834$ 423,334$ 435,834$ 948,334$ 900,834$ 1,413,334$ 1,350,834$ 1,850,834$ 1,785,834$ Cash Balance - % of Next Year Capital #DIV/0!657%152%92%85%#DIV/0!169%#DIV/0!246%#DIV/0!328%#DIV/0! Projection - Capital Improvement Plan Y:\Budget\2025\Cash Flows\Capital Funds 205-Park Equipment City of Otsego Capital Equipment Revolving Fund Cash Flow Summary Revised: August 23, 2024 6.82%4.80%4.54%5.76%4.80%6.87%0.30%0.98%3.39%5.09% Actual Forecast 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 Comments Revenues Property Taxes 477,325$ 550,393$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ Property Taxes (Building)- - 11,065 11,065 11,065 11,065 11,065 11,065 11,065 11,065 13,061 13,061 Based on Equipment Depreciation Property Taxes (Streets)- - 489,485 508,276 528,057 554,924 575,362 616,060 617,658 618,933 640,783 679,634 Based on Equipment Depreciation Property Taxes (Parks)- - 87,387 96,788 104,972 115,177 127,456 135,779 136,504 142,722 145,077 146,898 Based on Equipment Depreciation Investment Interest 11,880 - - - - - - - - - - - Transfers In 2,150 - - - - - - - - - - - Total 491,355 550,393 587,937 616,129 644,094 681,166 713,883 762,904 765,227 772,720 798,921 839,593 Expenses Capital Outlay - Building 29,267 - - - - - - - - - - - Replacement CIP - Buildings - 40,826 - - - - - - - 39,877 - - 2025-2034 (CIP Budget) Capital Outlay - Streets 302,670 - - - - - - - - - - - Replacement CIP - Streets - 390,000 202,606 452,836 811,281 449,444 182,103 92,944 615,181 414,607 680,709 263,330 2025-2034 (CIP Budget) Additions CIP - Streets - 100,000 40,732 92,000 - - 312,512 - - - - - 2025-2034 (CIP Budget) Capital Outlay - Parks 97,333 - - - - - - - - - - - Replacement CIP - Parks - 70,000 18,500 84,098 - 255,700 33,305 15,098 183,197 70,000 37,918 65,032 2025-2034 (CIP Budget) Additions CIP - Parks - - 69,500 61,000 85,000 - 56,000 - - - - - 2025-2034 (CIP Budget) Total 429,270 600,826 331,338 689,934 896,281 705,144 583,920 108,042 798,378 524,484 718,627 328,362 Cash Balance - Beginning 383,997 449,479 399,046 655,645 581,840 329,653 305,675 435,638 1,090,500 1,057,349 1,305,585 1,385,879 Balance Sheet Effects 3,397 Revenues 491,355 550,393 587,937 616,129 644,094 681,166 713,883 762,904 765,227 772,720 798,921 839,593 Expenditures (429,270) (600,826) (331,338) (689,934) (896,281) (705,144) (583,920) (108,042) (798,378) (524,484) (718,627) (328,362) Cash Balance - Ending 449,479$ 399,046$ 655,645$ 581,840$ 329,653$ 305,675$ 435,638$ 1,090,500$ 1,057,349$ 1,305,585$ 1,385,879$ 1,897,110$ Cash Balance - % of Next Year Capital 75%120%95%65%47%52%403%137%202%182%422% Projection - Capital Improvement Plan Y:\Budget\2025\Cash Flows\Capital Funds 206-Capital Equipment City of Otsego Fire Reserves Fund Cash Flow Summary Revised: August 23, 2024 Actual Forecast 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 Comments Revenues Property Taxes (Reserves)210,000$ 210,000$ 190,000$ -$ -$ -$ -$ -$ -$ -$ -$ -$ Property Taxes (Fleet)- - 6,189 19,020 20,500 30,862 30,862 38,263 38,263 38,263 38,263 43,068 Apparatus Replacement Reserve Property Taxes (Equipment)- - - - 131,608 138,188 145,098 152,353 159,970 167,969 176,367 185,186 Equipment Replacement Reserve Investment Interest 84,232 - - - - - - - - - - - Intergovernmental 2,445,223 - - - - - - - - - - - ARPA & Public Safety Aid Funding Miscellaneous - - - - - - - - - - - 574,252 Sale of Excess Property - Odean & 75th Debt Issuance - 1,099,349 - - - - - - - - - - Bond Proceeds - Reimburse Soft Costs Transfers In - - - 75,000 10,000 35,000 - 41,520 - - - - Lawful Gambling Contributions (Fund 216) Total 2,739,455 1,309,349 196,189 94,020 162,108 204,050 175,960 232,136 198,233 206,232 214,630 802,506 Expenses Other Charges & Services 1,313 - - - - - - - - - - - Capital Outlay (Land)- - - - - - - - - - - 250,000 Fire Station Parcel (West) Capital Outlay (Equipment)20,000 - - 1,369,512 - - - - - - - - 2025-2034 (CIP Budget) Capital Outlay (Vehicles)- 216,188 725,817 2,919,798 10,000 35,000 - 85,000 - - - 102,643 2025-2034 (CIP Budget) Capital Outlay (Building)- 1,099,349 - - - - - - - - - - Architectural & Preconstruction CM Total 21,313 1,315,537 725,817 4,289,310 10,000 35,000 - 85,000 - - - 352,643 Cash Balance - Beginning 2,083,833 4,802,434 4,796,246 4,266,618 71,328 223,436 392,486 568,446 715,582 913,815 1,120,047 1,334,677 Balance Sheet Effects 459 Revenues 2,739,455 1,309,349 196,189 94,020 162,108 204,050 175,960 232,136 198,233 206,232 214,630 802,506 Expenditures (21,313) (1,315,537) (725,817) (4,289,310) (10,000) (35,000) - (85,000) - - - (352,643) Cash Balance - Ending 4,802,434$ 4,796,246$ 4,266,618$ 71,328$ 223,436$ 392,486$ 568,446$ 715,582$ 913,815$ 1,120,047$ 1,334,677$ 1,784,540$ Projection - Capital Improvement Plan Y:\Budget\2025\Cash Flows\Capital Funds 214-Fire Reserve City of Otsego City Buildings & Property Maintenance Cash Flow Summary Revised: August 23, 2024 0.00%242.86%25.00%6.67%6.25%5.88%5.56%5.26%5.00%4.76%4.55% Actual Forecast 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 Comments Revenues Property Taxes 35,000$ 35,000$ 120,000$ 150,000$ 160,000$ 170,000$ 180,000$ 190,000$ 200,000$ 210,000$ 220,000$ 230,000$ Investment Interest 3,924 - - - - - - - - - - - Total 38,924 35,000 120,000 150,000 160,000 170,000 180,000 190,000 200,000 210,000 220,000 230,000 Expenses Capital Outlay (City Hall)9,357 25,490 - - - - - - - - - - Capital Outlay (CH/PW CIP)- - 55,620 61,692 101,500 140,000 - - - - - - 2025-2034 (CIP Budget) Capital Outlay (PC CIP)- - 24,720 58,000 65,000 24,000 81,000 - - - - - 2025-2034 (CIP Budget) Capital Outlay (IT CIP)- - 160,600 - - - - 134,775 - - - - 2025-2034 (CIP Budget) Total 9,357 25,490 240,940 119,692 166,500 164,000 81,000 134,775 - - - - Cash Balance - Beginning 88,597 118,164 127,674 6,734 37,042 30,542 36,542 135,542 190,767 390,767 600,767 820,767 Balance Sheet Effects - Revenues 38,924 35,000 120,000 150,000 160,000 170,000 180,000 190,000 200,000 210,000 220,000 230,000 Expenditures (9,357) (25,490) (240,940) (119,692) (166,500) (164,000) (81,000) (134,775) - - - - Cash Balance - Ending 118,164$ 127,674$ 6,734$ 37,042$ 30,542$ 36,542$ 135,542$ 190,767$ 390,767$ 600,767$ 820,767$ 1,050,767$ Projection - Capital Improvement Plan Y:\Budget\2025\Cash Flows\Capital Funds 439-Buildings & Property