|
City of Elk River
<br />Utility Rate Study
<br />Sewer Fund
<br />2009 2010 2011
<br />1 Revenue Growth assumption - non -usage
<br />2.00%
<br />2.00%
<br />2-00%
<br />2.00%
<br />2.00%
<br />2.00 %
<br />2.00%
<br />2.00%
<br />2.00%
<br />2.00%
<br />2.00%
<br />2.00%
<br />2 Investment income yield
<br />(233,774)
<br />(454,471)
<br />(602,138)
<br />1.00%
<br />1.50%
<br />1.50%
<br />2.00%
<br />2.00%
<br />2.00%
<br />2.00%
<br />2.00%
<br />2.00%
<br />2-00%
<br />2.00%
<br />2.00%
<br />3 Expense growth - personnel & internal
<br />2.00%
<br />2.00%
<br />2.00%
<br />2.00%
<br />2.00%
<br />2.00%
<br />2.00%
<br />2.00%
<br />2.00%
<br />2.00%
<br />2.00%
<br />2.00%
<br />4 Expense growth - all other
<br />5.00%
<br />5.00%
<br />5.00%
<br />5.00%
<br />5.00%
<br />5.00°x6
<br />5.00%
<br />5.00%
<br />5.00 %
<br />5.00%
<br />5.00%
<br />5.00%
<br />5
<br />6
<br />105,647
<br />242,230
<br />286,466
<br />111,400
<br />231,683
<br />237,475
<br />266,375
<br />320,109
<br />405,315
<br />524,256
<br />537,362
<br />550,796
<br />372,827
<br />382,147
<br />391,701
<br />7 Operating Revenues
<br />71,859
<br />49,895
<br />73,733
<br />48,550
<br />72,271
<br />69,706
<br />32,620
<br />21,900
<br />25,646
<br />35,387
<br />38,934
<br />40,410
<br />42,663
<br />41,793
<br />41,558
<br />8 Usage Fee
<br />1,500,247
<br />1,465,988
<br />1,487,669
<br />1,554 A54
<br />1,602,192
<br />1,651,240
<br />1,719,358
<br />1,793,644
<br />1,877,568
<br />1,975.897
<br />2,084,522
<br />2,198,331
<br />2,31 1,934
<br />2,433,682
<br />2,561,120
<br />9 Grant
<br />-
<br />-
<br />-
<br />-
<br />285,740
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />10 Other
<br />2,362
<br />1,725
<br />5,615
<br />-,7K
<br />2,000
<br />2,000
<br />2.000
<br />2.000
<br />2,000
<br />2.000
<br />2,000
<br />2,000
<br />2.000
<br />2,000
<br />2,000
<br />1,889932
<br />11 Total Operating Revenues 1,502,609 1,467,713 1,493,284 1,556,204
<br />1,653,240
<br />1,721,358
<br />1,795,644
<br />1,879,568
<br />1,977,897
<br />2,086,522
<br />2,200,331
<br />2,313,934
<br />2,435,682
<br />2,563,120
<br />12
<br />31
<br />13 Operating Expenses (including depreciation)
<br />32 Cash Available for Capital Outlay
<br />14 Personal Services
<br />398,696
<br />441,059
<br />457,612
<br />480,550
<br />491,500
<br />501,330
<br />511,357
<br />521,584
<br />532,015
<br />542,656
<br />553,509
<br />564,579
<br />575.871
<br />587,388
<br />599,136
<br />15 Supplies
<br />100,903
<br />89,443
<br />121,117
<br />174,900
<br />262,300
<br />275,415
<br />289,186
<br />303,645
<br />318,827
<br />334,769
<br />351,507
<br />369,082
<br />387,537
<br />406,913
<br />427,259
<br />16 Depreciation
<br />833,135
<br />993,042
<br />993,043
<br />993,600
<br />993,600
<br />993,600
<br />993,600
<br />993,600
<br />993,600
<br />993,600
<br />993,600
<br />993,600
<br />993,600
<br />993,600
<br />993,600
<br />17 Other Services & Charges
<br />403,649
<br />398,640
<br />523,650
<br />466,750
<br />687,250
<br />721,613
<br />757,693
<br />795,578
<br />835.357
<br />877,125
<br />920,981
<br />967,030
<br />1,015,381
<br />1,066,150
<br />1,119,458
<br />2434,650
<br />18 Total Operating Expenses 1,736,383 1,922,184 2,095,422 2,115,800
<br />2,491,958
<br />2,551,835
<br />2,614407
<br />2,679,799
<br />2,748,149
<br />2,819,597
<br />2,894,291
<br />2,972,388
<br />3,054,052
<br />3,139,453
<br />19
<br />20 Net Operations (including depreciation)
<br />(233,774)
<br />(454,471)
<br />(602,138)
<br />(559,596)
<br />(544,718)
<br />(838,717)
<br />(830,478)
<br />(818,762)
<br />(800,231)
<br />(770,252)
<br />(733,074)
<br />(693,960)
<br />(658,454)
<br />(618,370)
<br />(576,333)
<br />21
<br />22
<br />23 Non - operating revenues (expenses)
<br />24 Connection Charges
<br />105,647
<br />242,230
<br />286,466
<br />111,400
<br />231,683
<br />237,475
<br />266,375
<br />320,109
<br />405,315
<br />524,256
<br />537,362
<br />550,796
<br />372,827
<br />382,147
<br />391,701
<br />25 Investment income
<br />71,859
<br />49,895
<br />73,733
<br />48,550
<br />72,271
<br />69,706
<br />32,620
<br />21,900
<br />25,646
<br />35,387
<br />38,934
<br />40,410
<br />42,663
<br />41,793
<br />41,558
<br />27 Assessment Income
<br />2,176
<br />15.407
<br />2,066
<br />2,500
<br />2,500
<br />2,500
<br />2,500
<br />2,500
<br />2,500
<br />2,500
<br />2,500
<br />2,500
<br />2,500
<br />2,500
<br />2,500
<br />28 Other income (expense)
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />29 Total non operating revenue (expenses)
<br />179,682
<br />307,532
<br />362,265
<br />162,450
<br />306,454
<br />309,680
<br />301,496
<br />344,509
<br />433,461
<br />562,143
<br />578,796
<br />593,706
<br />417,990
<br />426,440
<br />435,759
<br />30
<br />31
<br />32 Cash Available for Capital Outlay
<br />33 Net operations including depreciation (line 20)
<br />(233,774)
<br />(454,471)
<br />(602,138)
<br />(559,596)
<br />(544,718)
<br />(838,717)
<br />(830,478)
<br />(818,762)
<br />(800,231)
<br />(770,252)
<br />(733,074)
<br />(693,960)
<br />(658,454)
<br />(618,370)
<br />(576,333)
<br />34 Add non operating revenues (line 29 )
<br />179,682
<br />307,532
<br />362,265
<br />162,450
<br />306,454
<br />309,680
<br />301,496
<br />344,509
<br />433,461
<br />562,143
<br />578,796
<br />593,706
<br />417,990
<br />426,440
<br />435,759
<br />36 Add back other non -cash expense (line )
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />37 Add back depreciation (line 16 )
<br />833,135
<br />993,042
<br />993,043
<br />993,600
<br />993,600
<br />993,600
<br />993,600
<br />993,600
<br />993,600
<br />993,600
<br />993,600
<br />993,600
<br />993,600
<br />993,600
<br />993,600
<br />38 Other Reconciliations to income
<br />(79,930)
<br />16,587
<br />(8,545)
<br />39 Transfers In (out)
<br />(65,000)
<br />(65,000)
<br />(90,000)
<br />(115,000)
<br />(115,000)
<br />(120,750)
<br />(126,788)
<br />(133,127)
<br />(139,783)
<br />(146,772)
<br />(154,111)
<br />(161,817)
<br />(169,907)
<br />(178,403)
<br />(187,323)
<br />40 Total Cash Available for Capital Outlay
<br />634,113
<br />797;690
<br />654,625
<br />481,454
<br />640,336
<br />343,813
<br />337,830
<br />386,220
<br />487,047
<br />638,718
<br />685,210
<br />731,530
<br />583,229
<br />623,268
<br />665,703
<br />41
<br />42 Cashflows from Capital Activities
<br />43 Capital (from CIP and Operating Budgets)
<br />(319,054)
<br />-
<br />-
<br />(470,000)
<br />(611;480)
<br />(3,161,482)
<br />(677,491)
<br />-
<br />(5,129,788)
<br />-
<br />(150,000)
<br />(157,500)
<br />(165,375)
<br />(173,644)
<br />(182,326)
<br />44 Bond Proceeds:,
<br />45 Existing Debt (P &I)
<br />(197,452)
<br />(202,415)
<br />(197,115)
<br />(201,038)
<br />(199,891)
<br />(198,344)
<br />(196,384)
<br />(198,900)
<br />46 Sale of Capital Assets
<br />47 Debt (P&I) - 2017 Bonds (15 Yr Term at 4.00%
<br />(461,379)
<br />(461,379)
<br />(461,379)
<br />(461,379)
<br />(461,379)
<br />(461,379)
<br />48 Total Cashflow from Capital Activities
<br />(516,506)
<br />(202,415)
<br />(197,115)
<br />(671,038)
<br />(811,371)
<br />(3,359,826)
<br />(873,875)
<br />(198,900)
<br />0
<br />(461,379)
<br />(611,379)
<br />(618,879)
<br />(626,754)
<br />(635,023)
<br />(643,705)
<br />49
<br />50
<br />51 Cash Flow
<br />117,607
<br />595,275
<br />457,510
<br />(189,584)
<br />(171,035)
<br />(3,016,012)
<br />(536;045)
<br />187;320
<br />487,047
<br />177,339
<br />73,832
<br />112,651
<br />(43,525)
<br />(11,755)
<br />21,999
<br />52
<br />53 Beginning Cash
<br />3,837,262
<br />3954,869;
<br />4,550,144
<br />5,007,654
<br />4,818,070
<br />4,647,036
<br />1,631,023
<br />1,094,979
<br />1,282,298
<br />1,769;345
<br />1;946684
<br />2,020,516:
<br />2133,167
<br />2,089,642
<br />2,077,888
<br />54
<br />55 Ending Cash balance
<br />55
<br />3.954,869
<br />_
<br />4 550,144
<br />5,007;654
<br />4.818.070
<br />4:647,036
<br />1,631:02.3
<br />1;094,979
<br />_
<br />9,282,298
<br />- 1,769,345
<br />1;946;684
<br />2,020 6 "16
<br />2,133,167
<br />2,089;642
<br />_Z07__
<br />56
<br />57
<br />58 Target cash reserve amount (note 1)
<br />854,039
<br />861,686
<br />952,227
<br />960,991
<br />1,118,869
<br />1,143,563
<br />1,178,018
<br />,1,0104033
<br />1;504,478
<br />1,538:653
<br />1.5 74377
<br />1,611,724
<br />1, 650,77:1
<br />1,591,605
<br />1,172,926
<br />59
<br />60 Total Cash Available (line 56 + Line 58)
<br />3,100,830
<br />3,688,458 ;
<br />4,055,427
<br />3,857,080
<br />3,528,167
<br />485,460
<br />(83,039)
<br />271,895
<br />264,867
<br />408,031
<br />446,139
<br />521,443
<br />438,869
<br />486,283
<br />926,960
<br />61
<br />62 Capital outlay coverage
<br />1.23
<br />3.94
<br />3.32
<br />012
<br />0.79
<br />0.10
<br />0.39
<br />1.94
<br />N/A
<br />1.38
<br />1.12
<br />1.18
<br />0.93
<br />0.98
<br />1.03
<br />63
<br />64
<br />65 Beginning Accumulated Depreciation -Note 4
<br />11,971,258
<br />12662,155
<br />13,655,198
<br />'14,648798
<br />15,642,398
<br />96,635998
<br />17,629,598
<br />18,623,198
<br />19,616,798
<br />20,610,398
<br />21,706,594
<br />22,802,790
<br />23901,985
<br />25,004,331
<br />26,109,984
<br />66 Annual Depreciation
<br />690,897
<br />993,043
<br />993,600
<br />993,600
<br />993,600
<br />993,600
<br />993,600
<br />993,600
<br />993,600
<br />1,096,196
<br />1,096,196
<br />1,099,196
<br />1,102,346
<br />1,105,653
<br />1,109,126
<br />67 Ending Accumulated Depreciation
<br />12 ,662,155
<br />13,655,198
<br />14,648,798
<br />15,642,398
<br />16,635998
<br />17,629,598
<br />18,623,198
<br />19,616,798
<br />20,610,398
<br />21,706,594
<br />22,802,790
<br />23,901,985
<br />25,004,331
<br />26,109,984
<br />27,219,110
<br />68 Ending cash balance as a percent
<br />09/06/209?
<br />69 of ending accumulated depreciation
<br />3'1.2%
<br />33.3 %
<br />34.2%
<br />30.8%
<br />27.9%
<br />9.3%,
<br />5.9%
<br />6.`.i %
<br />o
<br />a.610
<br />9.0%
<br />8,9%
<br />8.9%
<br />8.4%
<br />8.0%
<br />7.7%
<br />
|