|
Sewer Utility –Cash Flows UPDATED
<br />23
<br />City of Arden Hills, MN
<br />Actual Estimated
<br />Description 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027
<br />6.50%6.50%6.50%6.50%3.50%3.50%3.50%3.50%3.50%3.50%
<br />Operating Revenues 1,742,946 1,767,222 1,844,876 1,964,589 2,092,514 2,227,880 2,305,772 2,386,544 2,470,197 2,556,744 2,646,384 2,739,039
<br />Operating and Maintenance Expense 1,362,274 1,616,573 1,560,374 1,607,185 1,655,401 1,705,063 1,756,215 1,808,901 1,863,168 1,919,063 1,976,635 2,035,934
<br />Net Before Debt Service 380,672 150,649 284,502 357,404 437,113 522,818 549,557 577,643 607,029 637,680 669,748 703,105
<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 61,546 61,546 197,166 197,166 313,720 313,720 313,720 378,472 378,472
<br />Total Debt Service 0 0 0 61,546 61,546 197,166 197,166 313,720 313,720 313,720 378,472 378,472
<br />Net Revenues 380,672 150,649 284,502 295,858 375,567 325,652 352,391 263,923 293,309 323,960 291,276 324,633
<br />Interest Income 0 196 0 (0)(0)4,092 1,175 9,642 5,690 7,853 10,526 12,724
<br />Transfers Out (96,870)(96,870)(126,000)(126,000)(126,000)(126,000)(126,000)(126,000)(126,000)(126,000)(126,000)(126,000)
<br />Other Non Operating Revenues/(Expenses)306,498 53,095 30,000 0 0 (0)0 0 0 0 0 0
<br />Net Annual Cash Flow 590,300 107,070 188,502 169,858 249,567 203,743 227,566 147,565 172,999 205,813 175,802 211,356
<br />Capital Projects (363,668)(40,509)(530,000)(592,250)(424,360)(437,091)(450,204)(463,710)0 (491,950)0 (521,909)
<br />Bond Proceeds 0 0 525,000 0 1,100,000 0 900,000 0 0 500,000 0 500,000
<br />Net Cash Flow after Capital Projects 226,632 66,561 183,502 (422,392)925,207 (233,347)677,363 (316,145)172,999 213,864 175,802 189,447
<br />Ending Cash Balance 0 0 (0)(0)327,356 94,009 771,371 455,226 628,225 842,089 1,017,891 1,207,338
<br />Due to PIR Fund 425,522 358,961 175,459 597,851 0 0 0 0 0 0 0 0
<br />Targeted Working Capital 681,137 808,287 841,733 865,139 1,024,866 1,049,697 1,191,828 1,218,171 1,245,304 1,338,004 1,366,790 1,396,440
<br />Unrestricted Cash Over/(Under) Target (1,106,659)(1,167,248)(1,017,192)(1,462,990)(697,510)(955,689)(420,456)(762,944)(617,079)(495,915)(348,899)(189,101)
<br />SEWER FUND
<br />Projected
<br />Proposed Quarterly Rate Increase
|