|
City of Orono, Minnesota
<br />Stormwater 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 />$ 727,184
<br />$ 742,450 $
<br />776,103
<br />$ 814,718
<br />$ 839,159
<br />$ 864,334
<br />$ 890,264
<br />$ 916,971
<br />$ 944,481
<br />Other receipts
<br />246
<br />9
<br />2,529
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />Payments to suppliers/service providers
<br />(295,582)
<br />(210,669)
<br />(199,015)
<br />(198,598)
<br />(205,146)
<br />(212,318)
<br />(217,181)
<br />(223,728)
<br />(230,281)
<br />Payments to employees
<br />(78,982)
<br />(166,635)
<br />(195,970)
<br />(174,403)
<br />(182,823)
<br />(190,136)
<br />(197,741)
<br />(205,652)
<br />(213,878)
<br />Net Cash from Operating Activities
<br />352,866
<br />365,155
<br />383,647
<br />441,717
<br />451,190
<br />461,880
<br />475,342
<br />487,591
<br />500,322
<br />Cash Flows from Noncapital Financing Activities
<br />Transfers out
<br />-
<br />(1,003,600)
<br />(454,564)
<br />(510,300)
<br />(142,980)
<br />(243,200)
<br />(310,800)
<br />(182,430)
<br />(158,685)
<br />Cash Flows from Capital and Related Financing Activities
<br />Acquisition of capital assets
<br />(160,089)
<br />(289)
<br />(233,547)
<br />(100,000)
<br />(356,000)
<br />(158,000)
<br />(205,000)
<br />(185,000)
<br />(245,000)
<br />Connection fees received
<br />16,119
<br />5,251
<br />21,180
<br />14,609
<br />15,047
<br />15,498
<br />15,963
<br />16,442
<br />16,935
<br />Net Cash from Capital and Related Financing Activities
<br />(143,970)
<br />4,962
<br />(212,367)
<br />(85,391)
<br />(340,953)
<br />(142,502)
<br />(189,037)
<br />(168,558)
<br />(228,065)
<br />Cash Flows From Investing Activities
<br />Investment earnings (loss)
<br />(83,351)
<br />115,941
<br />65,447
<br />40,338
<br />36,929
<br />37,054
<br />40,451
<br />40,930
<br />46,256
<br />Net Increase (Decrease) in Cash and Cash Equivalents
<br />125,545
<br />(517,542)
<br />(217,837)
<br />(113,636)
<br />4,186
<br />113,232
<br />15,956
<br />177,533
<br />159,828
<br />Cash and Cash Equivalents, January 1
<br />1,954,420
<br />2,079,965
<br />1,562,423
<br />1,344,586
<br />1,230,950
<br />1,235,136
<br />1,348,368
<br />1,364,324
<br />1,541,857
<br />Cash and Cash Equivalents, December 31
<br />$ 2,079,965
<br />$ 1,562,423 $
<br />1,344,586
<br />$ 1,230,950
<br />$ 1,235,136
<br />$ 1,348,368
<br />$ 1,364,324
<br />$ 1,541,857
<br />$ 1,701,685
<br />Target Cash Reserve
<br />$ 295,126
<br />$ 299,546 $
<br />294,050
<br />$ 297,792
<br />$ 301,414
<br />$ 304,531
<br />$ 308,145
<br />$ 311,840
<br />$ 315, 666
<br />Projected Cash in Excess of Target
<br />$ 933,158
<br />$ 933,723
<br />$ 1,043,838
<br />$ 1,056,179
<br />$ 1,230,017
<br />$ 1,386,119
<br />Average Monthly Bill (Residential User)
<br />$ 16.32
<br />$ 16.81
<br />$ 17.31
<br />$ 17.83
<br />$ 18.37
<br />$ 18.92
<br />Average Percentage Increase
<br />3%
<br />3%
<br />3%
<br />3%
<br />3%
<br />Average Monthly Dollar Increase
<br />$ 0.49
<br />$ 0.50
<br />$ 0.52
<br />$ 0.53
<br />$ 0.55
<br />Average Annual Dollar Increase
<br />$ 5.88
<br />$ 6.05
<br />$ 6.23
<br />$ 6.42
<br />$ 6.61
<br />Five Year Average Capital Expenses
<br />$ 200,800
<br />12 118
<br />
|