|
Sewer Utility –Cash Flows
<br />14
<br />City of Arden Hills, MN
<br />Actual Estimated
<br />Description 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027
<br />4.00%10.00%5.00%5.00%5.00%5.00%3.00%3.00%3.00%3.00%
<br />Operating Revenues 1,742,946 1,767,222 1,800,965 1,980,619 2,079,486 2,183,678 2,292,307 2,406,495 2,478,520 2,553,081 2,630,186 2,708,659
<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 240,591 373,433 424,086 478,615 536,093 597,594 615,352 634,017 653,551 672,725
<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 240,591 311,887 362,540 281,449 338,927 283,873 301,632 320,297 275,078 294,253
<br />Interest Income 0 196 0 (0)0 3,581 105 8,390 4,672 6,926 9,542 11,525
<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 144,591 185,887 236,540 159,029 213,032 166,264 180,304 201,223 158,620 179,777
<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 139,591 (406,363)912,180 (278,061)662,828 (297,446)180,304 209,274 158,620 157,868
<br />Ending Cash Balance 0 0 (0)0 286,447 8,385 671,213 373,767 554,071 763,345 921,965 1,079,833
<br />Due to PIR Fund 425,522 358,961 219,370 625,733 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,061,103)(1,490,872)(738,420)(1,041,312)(520,614)(844,404)(691,233)(574,659)(444,825)(316,607)
<br />SEWER FUND
<br />Projected
<br />Proposed Quarterly Rate Increase
|