Storm Water Utility –Cash Flows UPDATED
<br />34
<br />City of Arden Hills, MN
<br />Actual Estimated
<br />Description 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027
<br />2.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%
<br />Operating Revenues 812,044 837,717 831,549 839,647 848,028 856,480 865,002 873,681 882,431 891,265 900,169 909,145
<br />Operating and Maintenance Expense 390,935 405,735 489,764 504,457 519,591 535,178 551,234 567,771 584,804 602,348 620,418 639,031
<br />Net Before Debt Service 421,109 431,982 341,785 335,190 328,438 321,302 313,769 305,910 297,627 288,917 279,751 270,114
<br />Existing Debt Service (P&I)0 0 0 0 0 0 0 0 0 0 0 0
<br />Projected Debt Service (P&I)0 0 0 0 0 0 0 0 0 0 0 0
<br />Total Debt Service 0 0 0 0 0 0 0 0 0 0 0 0
<br />Net Revenues 421,109 431,982 341,785 335,190 328,438 321,302 313,769 305,910 297,627 288,917 279,751 270,114
<br />Interest Income 3,862 13,777 5,000 2,636 4,324 4,907 8,059 8,343 11,346 9,806 12,615 10,594
<br />Transfers Out (65,499)(65,499)(74,000)(74,000)(74,000)(74,000)(74,000)(74,000)(74,000)(74,000)(74,000)(74,000)
<br />Other Non Operating Revenues/(Expenses)770 0 0 0 0 0 0 0 0 0 0 0
<br />Net Annual Cash Flow 360,242 380,260 272,785 263,826 258,762 252,208 247,828 240,253 234,973 224,723 218,366 206,708
<br />Capital Projects (108,022)0 (755,000)(128,750)(212,180)0 (225,102)0 (358,216)0 (380,031)0
<br />Bond Proceeds 0 0 0 0 0 0 0 0 0 0 0 0
<br />Net Cash Flow after Capital Projects 252,220 380,260 (482,215)135,076 46,582 252,208 22,726 240,253 (123,242)224,723 (161,665)206,708
<br />Ending Cash Balance 312,817 693,077 210,862 345,938 392,520 644,729 667,454 907,708 784,466 1,009,189 847,524 1,054,232
<br />Targeted Working Capital 234,483 241,883 284,882 293,428 302,231 311,298 320,637 330,256 340,164 350,369 360,880 371,706
<br />Unrestricted Cash Over/(Under) Target 78,335 451,195 (74,020)52,510 90,289 333,430 346,817 577,452 444,302 658,820 486,644 682,525
<br />Proposed Quarterly Rate Increase
<br />Projected
<br />STORM WATER FUND
|