|
City of Orono, Minnesota
<br />Water 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 />Usage Rates
<br />25%
<br />3%
<br />3%
<br />3%
<br />3%
<br />Fixed Rates
<br />25%
<br />3%
<br />3%
<br />3%
<br />3%
<br />Cash Flows from Operating Activities
<br />Receipts from customers and users
<br />$
<br />1,798,081
<br />$ 1,630,529
<br />$ 1,294,702
<br />$ 1,095,803
<br />$ 1,390,043
<br />$ 1,432,804
<br />$ 1,476,826
<br />$ 1,522,147
<br />$ 1,568,807
<br />Other receipts
<br />18,922
<br />20,395
<br />24,682
<br />20,113
<br />134,717
<br />135,339
<br />135,979
<br />136,638
<br />137,317
<br />Payments to suppliers/service providers
<br />(562,832)
<br />(783,869)
<br />(627,466)
<br />(661,491)
<br />(681,335)
<br />(701,774)
<br />(722,829)
<br />(744,514)
<br />(766,852)
<br />Payments to employees
<br />(328,900)
<br />(341,147)
<br />(340,735)
<br />(352,830)
<br />(369,906)
<br />(384,702)
<br />(400,090)
<br />(416,094)
<br />(432,737)
<br />Net Cash from Operating Activities
<br />925,271
<br />525,908
<br />351,183
<br />101,595
<br />473,519
<br />481,667
<br />489,886
<br />498,177
<br />506,535
<br />Cash Flows from Noncapital Financing Activities
<br />Transfers out
<br />(15,000)
<br />(1,010,499)
<br />(135,979)
<br />(900)
<br />-
<br />(35,640)
<br />-
<br />(17,820)
<br />(11,880)
<br />Transfers in
<br />750,000
<br />Net Cash from Noncapital Financing Activities
<br />(15,000)
<br />(1,010,499)
<br />(135,979)
<br />749,100
<br />(35,640)
<br />(17,820)
<br />(11,880)
<br />Cash Flows from Capital and Related Financing Activities
<br />Intergovernmental
<br />460,000
<br />-
<br />Acquisition of capital assets
<br />(497,615)
<br />(859,360)
<br />(131,122)
<br />(377,200)
<br />(641,800)
<br />(578,600)
<br />(509,500)
<br />(50,400)
<br />(261,300)
<br />Special assessments received
<br />9,524
<br />27,601
<br />7,331
<br />15,171
<br />15,626
<br />16,095
<br />16,578
<br />17,075
<br />17,587
<br />Principal paid on long-term debt
<br />(85,000)
<br />(85,000)
<br />(85,000)
<br />(11,544)
<br />(9,350)
<br />(6,919)
<br />(4,306)
<br />(1,500)
<br />-
<br />Interest paid on long-term debt
<br />(17,181)
<br />(15,429)
<br />(13,569)
<br />(90,000)
<br />(90,000)
<br />(95,000)
<br />(95,000)
<br />(100,000)
<br />Net Cash from Capital and Related Financing Activities
<br />(130,272)
<br />(932,188)
<br />(222,360)
<br />(463,573)
<br />(725,524)
<br />(664,424)
<br />(592,228)
<br />(134,825)
<br />(241L
<br />Cash Flows from Investing Activities
<br />Investment earnings (loss)
<br />(49,505)
<br />70,250
<br />8,862
<br />8,067
<br />19,922
<br />12,960
<br />6,797
<br />3,930
<br />14,414
<br />Net Increase (Decrease) in Cash and Cash Equivalents
<br />730,494
<br />(1,346,529)
<br />1,706
<br />395,189
<br />(232,083)
<br />(205,437)
<br />(95,545)
<br />349,462
<br />265,356
<br />Cash and Cash Equivalents, January 1
<br />883,219
<br />1,613,713
<br />267,184
<br />268,890
<br />664,079
<br />431,996
<br />226,559
<br />131,014
<br />480,476
<br />Cash and Cash Equivalents, December 31
<br />$
<br />1,613,713
<br />$ 267,184
<br />$ 268,890
<br />$ 664,079
<br />$ 431,996
<br />$ 226,559
<br />$ 131,014
<br />$ 480,476
<br />$ 745,832
<br />Target Cash Reserve
<br />$
<br />813,183
<br />$ 772,119
<br />$ 786,624
<br />$ 793,660
<br />$ 805,038
<br />$ 811,536
<br />$ 823,152
<br />$ 731,397
<br />$ 741, 776
<br />Projected Cash in Excess of Target
<br />$
<br />800,530
<br />$
<br />$
<br />$
<br />$
<br />$
<br />$ -
<br />$ -
<br />$ 4,356
<br />Average Monthly Bill (4,000 Gallons)
<br />$ 52.35
<br />$ 65.44
<br />$ 67.40
<br />$ 69.42
<br />$ 71.51
<br />$ 73.65
<br />Average Percentage Increase
<br />25%
<br />3%
<br />3%
<br />3%
<br />3%
<br />Average Monthly Dollar Increase
<br />$ 13.09
<br />$ 1.96
<br />$ 2.02
<br />$ 2.08
<br />$ 2.15
<br />Average Annual Dollar Increase
<br />$ 157.05
<br />$ 23.56
<br />$ 24.26
<br />$ 24.99
<br />$ 25.74
<br />Five Year Average Capital Expenses
<br />$ 431,500
<br />114
<br />
|