|
Water Utility –Cash Flows
<br />5
<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.00%10.00%6.00%6.00%6.00%2.00%2.00%2.00%2.00%2.00%
<br />Operating Revenues 2,165,773 2,147,766 2,182,059 2,397,282 2,539,333 2,690,039 2,849,619 2,906,138 2,963,806 3,022,540 3,082,561 3,143,686
<br />Operating and Maintenance Expense 1,601,171 1,662,534 1,750,066 1,802,568 1,856,645 1,912,344 1,969,715 2,028,806 2,089,670 2,152,360 2,216,931 2,283,439
<br />Net Before Debt Service 564,602 485,232 431,993 594,714 682,688 777,695 879,904 877,332 874,136 870,179 865,629 860,247
<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 234,461 234,461 234,461 234,461 234,461 234,461 234,461 234,461 234,461
<br />Total Debt Service 0 0 0 234,461 234,461 234,461 234,461 234,461 234,461 234,461 234,461 234,461
<br />Net Revenues 564,602 485,232 431,993 360,253 448,227 543,234 645,443 642,871 639,675 635,718 631,168 625,786
<br />Interest Income 12,315 35,943 20,000 6,380 4,915 0 2,481 0 9,846 11,370 22,332 23,287
<br />Transfers Out (68,396)(68,396)(100,000)(100,000)(100,000)(100,000)(100,000)(100,000)(100,000)(100,000)(100,000)(100,000)
<br />Other Non Operating Revenues/(Expenses)984 5,565 0 5,015 4,872 4,729 4,585 4,442 4,298 1,014 983 953
<br />Net Annual Cash Flow 509,505 458,344 351,993 271,648 358,014 447,963 552,509 547,313 553,819 548,102 554,483 550,026
<br />Capital Projects (128,427)(162,284)(3,021,000)(416,120)(689,585)(273,182)(731,581)0 (477,621)0 (506,708)0
<br />Bond Proceeds 0 0 2,000,000 0 0 0 0 0 0 0 0 0
<br />Net Cash Flow after Capital Projects 381,078 296,060 (669,007)(144,472)(331,571)174,781 (179,071)547,313 76,198 548,102 47,775 550,026
<br />Ending Cash Balance 798,259 1,094,319 425,312 280,840 0 124,050 (0)492,292 568,490 1,116,592 1,164,367 1,714,394
<br />Due to PIR Fund 0 0 0 0 50,731 0 55,021 0 0 0 0 0
<br />Targeted Working Capital 800,586 831,267 1,109,494 1,135,745 1,162,784 1,190,633 1,219,318 1,248,864 1,279,296 1,310,641 1,342,927 1,376,181
<br />Unrestricted Cash Over/(Under) Target (2,327)263,052 (684,182)(854,905)(1,213,514)(1,066,583)(1,274,339)(756,572)(710,806)(194,049)(178,559)338,213
<br />WATER FUND
<br />Projected
<br />Proposed Quarterly Rate Increase
|