|
City of Orono, Minnesota
<br />Sewer Fund
<br />Cash Flow Projections - Detailed
<br />For the Years Ending December 31, 2025 through 2030
<br />Rate Study Projections
<br />Actual Results
<br />Estimated
<br />Estimated
<br />Estimated
<br />Estimated
<br />Estimated
<br />Estimated
<br />2022
<br />2023
<br />2024
<br />2025
<br />2026
<br />2027
<br />2028
<br />2029
<br />2030
<br />Projected Rate Increase
<br />Fixed Rates
<br />3%
<br />3%
<br />3%
<br />3%
<br />3%
<br />Cash Flows from Operating Activities
<br />Receipts from customers and users
<br />$ 2,298,522
<br />$ 2,264,458 $
<br />2,344,148
<br />$ 2,311,919
<br />$ 2,378,204
<br />$ 2,455,111
<br />$ 2,529,565
<br />$ 2,606,275
<br />$ 2,685,312
<br />Other receipts
<br />5,454
<br />2,329
<br />15,460
<br />19,261
<br />19,839
<br />20,434
<br />21,047
<br />21,678
<br />22,328
<br />Payments to suppliers/service providers
<br />(1,235,866)
<br />(1,327,558)
<br />(1,442,077)
<br />(1,414,509)
<br />(1,473,154)
<br />(1,534,368)
<br />(1,598,268)
<br />(1,664,982)
<br />(1,734,634)
<br />Payments to employees
<br />(324,170)
<br />(349,994)
<br />(338,934)
<br />(353,299)
<br />(370,475)
<br />(385,294)
<br />(400,706)
<br />(416,735)
<br />(433,404)
<br />Net Cash from Operating Activities
<br />743,940
<br />589,235
<br />578,597
<br />563,372
<br />554,414
<br />555,883
<br />551,638
<br />546,236
<br />539,602
<br />Cash Flows from Noncapital Financinq Activities
<br />Transfers out
<br />(82,500)
<br />(1,046,750)
<br />(792,360)
<br />(186,100)
<br />(114,720)
<br />(121,100)
<br />(14,600)
<br />(12,960)
<br />(4,860)
<br />Cash Flows from Capital and Related Financing Activities
<br />Capital grants received
<br />508,911
<br />Acquisition of capital assets
<br />(575,896)
<br />(1,073,996)
<br />(547,952)
<br />(430,000)
<br />(870,000)
<br />(600,000)
<br />(520,000)
<br />(520,000)
<br />(520,000)
<br />Connection fees received
<br />11,210
<br />21,530
<br />20,153
<br />Special assessments
<br />42,024
<br />56,226
<br />-
<br />Net Cash from Capital and Related Financing Activities
<br />(522,662)
<br />(487,329)
<br />(527,799)
<br />(430,000)
<br />(870,000)
<br />(600,000)
<br />(520,000)
<br />(520,000)
<br />(520,000)
<br />Cash Flows From Investing Activities
<br />Investment earnings (loss)
<br />(120,929)
<br />134,358
<br />69,119
<br />49,639
<br />49,546
<br />38,123
<br />34,310
<br />35,851
<br />37,325
<br />Net Increase (Decrease) in Cash and Cash Equivalents
<br />17,849
<br />(810,486)
<br />(672,443)
<br />(3,089)
<br />(380,760)
<br />(127,094)
<br />51,348
<br />49,127
<br />52,067
<br />Cash and Cash Equivalents, January 1
<br />3,119,705
<br />3,137,554
<br />2,327,068
<br />1,654,625
<br />1,651,536
<br />1,270,776
<br />1,143,682
<br />1,195,030
<br />1,244,157
<br />Cash and Cash Equivalents, December 31
<br />S 3,137,554
<br />S 2,327,068 S
<br />1,654,625
<br />S 1,651,536
<br />S 1,270,776
<br />S 1,143,682
<br />S 1,195,030
<br />S 1,244,157
<br />S 1,296. 224
<br />Target Cash Reserve
<br />S 1,007,388
<br />$ 1,033,253 S
<br />1,029,952
<br />$ 1,048,907
<br />S 1,067,916
<br />$ 1,087,744
<br />S 1,108,429
<br />$ 1,130,010
<br />S 1,152. 226
<br />Projected Cash in Excess of Target
<br />$ 602,629
<br />S 202,861
<br />$ 55,939
<br />S 86,601
<br />$ 114,148
<br />S 143. 998
<br />Average Monthly Bill (4,000 Gallons)
<br />S 73.21
<br />S 75.41
<br />S 77.67
<br />S 80.00
<br />S 82.40
<br />S 84.87
<br />Average Percentage Increase
<br />3%
<br />3%
<br />3%
<br />3%
<br />3%
<br />Average Monthly Dollar Increase
<br />$ 2.20
<br />$ 2.26
<br />$ 2.33
<br />$ 2.40
<br />$ 2.47
<br />Average Annual Dollar Increase
<br />$ 26.36
<br />$ 27.15
<br />$ 27.96
<br />$ 28.80
<br />$ 29.66
<br />Five Year Average Capital Expenses
<br />$ 588,000
<br />10 116
<br />
|