<br />City of' Arden Hills
<br />Utility Rate Study
<br />Base Model
<br />
<br />1 Revenue growth assumption. non.usage
<br />2 Investment income yield
<br />3 Expense growth. personnel & intemal
<br />4 Expense growth. contractual
<br />5 Expense growth. non personnel
<br />6
<br />7 MCES growth assumption
<br />8
<br />9 Beginning net assets
<br />10
<br />11 Operating Revenues
<br />12 Water sales
<br />13 Sewer charges
<br />14 Miscellaneous
<br />15 Other
<br />16 Total Operating Revenues
<br />17
<br />18 Operating Expenses
<br />19 Personnel
<br />20 Additional Personnel
<br />21 Supplies and maintenance
<br />22 Other services and charges
<br />23 Rent
<br />24 Insurance
<br />25 Depreciation
<br />26 Purchased services
<br />27 Purcl1ased water
<br />28 Utilities
<br />29 MCES charges
<br />30 General Fund admin charge
<br />31 Total Operating Expenses
<br />32
<br />33 Nel Operations
<br />34 Non operating revenues (expenses)
<br />35 Investment income
<br />36 Other income (expense)
<br />37 Transfers
<br />38 Tolal non operating revenue (expenses)
<br />39
<br />40 Nel increase (decrease) in resources
<br />41
<br />42 Capital contributions
<br />43 Other
<br />44 Ending net assets
<br />45 CIPFunding
<br />46 Currenl Year Capital
<br />47 Bond Proceeds
<br />48 Bond P&l. Future .20 yrs at 5.5%
<br />49 Bond P&I. Future .20 yrs at 5.5%
<br />50 Bond Prin . Existing
<br />51
<br />52 Beginning Cash
<br />53 Add net operations (line 34)
<br />54 Add back depreciation (line 25)
<br />55 Add net non operating (line 38)
<br />56 Add capital and bOnd (lines 46.50)
<br />57 Net change in balance sheet items
<br />58 Ending Cash
<br />59
<br />60 Ending net assets
<br />
<br />6,360,854
<br />
<br />998,732
<br />
<br />1,775
<br />1,000.507
<br />
<br />213,395
<br />
<br />30,512
<br />59,176
<br />16,995
<br />17,917
<br />165,669
<br />22,900
<br />663,269
<br />11,275
<br />
<br />1,201,108
<br />
<br />(2C}f,C'
<br />
<br />26,861
<br />
<br />26,861
<br />
<br />._,f'.,
<br />
<br />15,275
<br />6,202,389
<br />
<br />1,569,978
<br />
<br />1,104,910
<br />
<br />6,202,389
<br />
<br />2004
<br />
<br />Actual
<br />2005
<br />2.00%
<br />3.50%
<br />6.00%
<br />
<br />3.50%
<br />6.00%,
<br />
<br />3.00%
<br />
<br />3,00%
<br />
<br />6,202,389
<br />
<br />1,136,556
<br />
<br />3,375
<br />49
<br />1,139,980
<br />
<br />227.969
<br />
<br />30,716
<br />86,065
<br />27,333
<br />21.297
<br />158,509
<br />24,252
<br />732,411
<br />12,524
<br />
<br />1,321,076
<br />
<br />i"",;,;;;,;,
<br />
<br />32,365
<br />
<br />32,365
<br />
<br />i.~t.2.T',',
<br />
<br />6,053,658
<br />
<br />1.104,910
<br />(181,09(0)
<br />158,509
<br />32,365
<br />(2-~O., 76)
<br />214,246
<br />988,758
<br />
<br />6,053,658
<br />
<br />3.50%
<br />6.00%
<br />
<br />3.00%
<br />
<br />6,053,658
<br />
<br />1,280.751
<br />
<br />173
<br />3,020
<br />1,283,94<1
<br />
<br />220,630
<br />
<br />33,867
<br />48,461
<br />27,333
<br />21,679
<br />168,877
<br />25,639
<br />833,569
<br />15,928
<br />
<br />1,395.983
<br />
<br />,. ~2 029;
<br />
<br />SO,556
<br />
<br />50,556
<br />
<br />(6,l.f::,)
<br />
<br />5,992,175
<br />
<br />o
<br />
<br />988,758
<br />
<br />(112.039)
<br />
<br />168,877
<br />50,556
<br />
<br />(203.955)
<br />
<br />64,282
<br />956,<179
<br />
<br />5,992,175
<br />
<br />2006
<br />
<br />5,992,175
<br />
<br />1,313,750
<br />
<br />350
<br />1,800
<br />1,315,900
<br />
<br />245,070
<br />
<br />66,350
<br />59,533
<br />30,250
<br />23,000
<br />90,000
<br />21,500
<br />840,000
<br />18,750
<br />
<br />1,394,453
<br />
<br />(IE.:;:;:::,
<br />
<br />28,000
<br />
<br />28,000
<br />
<br />,..J''',;:,''
<br />\~'~.--~i
<br />
<br />5,9<11,622
<br />
<br />o
<br />
<br />o
<br />
<br />956,479
<br />
<br />{ 78 .55=~)
<br />
<br />90,000
<br />28,000
<br />o
<br />
<br />995.926
<br />
<br />5,9<11,622
<br />
<br />Budoe\
<br />2007
<br />2.00%
<br />3.SO%
<br />6,00%
<br />
<br />3.00%
<br />
<br />5.941,622
<br />
<br />1,373,825
<br />
<br />350
<br />1,800
<br />1,375,975
<br />
<br />249,199
<br />
<br />64,009
<br />57,105
<br />19,625
<br />17,250
<br />180,000
<br />20,000
<br />958,000
<br />19,900
<br />
<br />27,892
<br />1,612,980
<br />
<br />';:2f',c.o,S:
<br />
<br />28,000
<br />
<br />28.000
<br />
<br />i20S,C05}
<br />
<br />5,732,617
<br />
<br />o
<br />
<br />(";2; 169':
<br />
<br />o
<br />
<br />995,926
<br />
<br />(237.005)
<br />
<br />180,000
<br />28,000
<br />(12U69)
<br />
<br />845,752
<br />
<br />5,732,617
<br />
<br />2008
<br />2.00%
<br />3.50%
<br />6.00%
<br />5.00%
<br />5.00%
<br />
<br />5,732,617
<br />
<br />1,546,869
<br />
<br />357
<br />1,836
<br />1,549,062
<br />
<br />264,151
<br />
<br />67,209
<br />59,960
<br />20,803
<br />18,113
<br />189,000
<br />21,000
<br />1,005,900
<br />20,895
<br />
<br />29,566
<br />1,696,596
<br />
<br />'.'.753","
<br />
<br />25,373
<br />
<br />25,373
<br />
<br />';~:;"c,'
<br />
<br />5,610,455
<br />
<br />121;',1 (';C)
<br />
<br />o
<br />
<br />845,752
<br />(~~7.53,~)
<br />189,000
<br />25,373
<br />(2,2,,80)
<br />
<br />700,410
<br />
<br />5,610,455
<br />
<br />WalerFund
<br />
<br />2009
<br />2,00%
<br />3.00%
<br />6.00%
<br />5.00%
<br />5,00%
<br />
<br />5,610,455
<br />
<br />1,639,681
<br />
<br />364
<br />1,873
<br />1,6-41,918
<br />
<br />280,000
<br />
<br />70.570
<br />62,958
<br />22,051
<br />19,018
<br />198,450
<br />22,050
<br />1,056,195
<br />21,940
<br />
<br />31,339
<br />1,784,571
<br />
<br />. .~2 .E~;3
<br />
<br />21,012
<br />
<br />21,012
<br />
<br />" c'~
<br />
<br />5.488,814
<br />
<br />- . S 7.~
<br />
<br />o
<br />
<br />700,410
<br />( ;,~ ;';.6.5 3}
<br />198,450
<br />21,012
<br />0:,571.)
<br />
<br />705,646
<br />
<br />5,488,814
<br />
<br />2010
<br />2.00%
<br />3.00%
<br />6.00%
<br />5.00%
<br />5.00%
<br />
<br />5,488,814
<br />
<br />1.738,062
<br />
<br />37'
<br />1,910
<br />1,740,343
<br />
<br />296,800
<br />
<br />74,098
<br />66,106
<br />23,374
<br />19,969
<br />208,373
<br />23,153
<br />1,109,005
<br />23.037
<br />
<br />33,220
<br />1,877,134
<br />
<br />,,3C.'?SC',
<br />
<br />21,169
<br />
<br />21,169
<br />
<br />; , ~:=., G:; ;
<br />
<br />5,373,194
<br />
<br />(56:!}S,~)
<br />
<br />766,000
<br />
<br />o
<br />
<br />705,646
<br />r,36.79:))
<br />208,373
<br />21,169
<br />203,246
<br />
<br />1,001,6-43
<br />
<br />5,373,194
<br />
<br />2011
<br />2.00%
<br />3.00%
<br />6.00%
<br />5.00%
<br />5.00%
<br />
<br />5,373,194
<br />
<br />1,842,346
<br />
<br />379
<br />1,948
<br />1,844,673
<br />
<br />314,608
<br />o
<br />77,803
<br />69,411
<br />24,776
<br />20,967
<br />218,791
<br />24,310
<br />1,164,455
<br />24,189
<br />
<br />35,213
<br />1,974,524
<br />
<br />(,79.2;;.
<br />
<br />30,049
<br />
<br />30,049
<br />
<br />i~,S ,202;
<br />
<br />5,273,391
<br />
<br />(202 ,2 f' :~','
<br />
<br />(~.09c)
<br />
<br />o
<br />
<br />1,001,643
<br />(129.851)
<br />218,791
<br />30,049
<br />(256,97',)
<br />
<br />853,661
<br />
<br />5,273,391
<br />
<br />2012
<br />2.00%
<br />3.00%
<br />6.00%
<br />5.00%
<br />5.00%
<br />
<br />5.273,391
<br />
<br />1,952,886
<br />
<br />386
<br />1,987
<br />1,955,260
<br />
<br />333,484
<br />o
<br />81,69<1
<br />72,882
<br />26,263
<br />22,016
<br />229,731
<br />25,526
<br />1,222,678
<br />25,398
<br />o
<br />37,326
<br />2,076,996
<br />
<br />25,610
<br />
<br />25,610
<br />
<br />i':;i';',,;0)
<br />
<br />5,177,265
<br />
<br />:3.582:
<br />
<br />(6",092)
<br />
<br />o
<br />
<br />853,661
<br />
<br />(12',,735)
<br />
<br />229,731
<br />25,610
<br />(67,68;)
<br />
<br />919,584
<br />
<br />5,177,265
<br />
<br />2013
<br />2.00%
<br />3.00%
<br />6.00%
<br />5.00%
<br />5.00%
<br />
<br />5,177,265
<br />
<br />2,070,060
<br />
<br />394
<br />2,027
<br />2,072,481
<br />
<br />353,494
<br />o
<br />85,778
<br />76,526
<br />27.838
<br />23,117
<br />241,217
<br />26,802
<br />1,283,812
<br />26,668
<br />o
<br />39,565
<br />2.184,817
<br />
<br />32,185
<br />
<br />32,185
<br />
<br />(8[:1
<br />
<br />5,097,114
<br />
<br />(323.t.57'
<br />262,000
<br />(~,DS8)
<br />
<br />o
<br />
<br />919,584
<br />
<br />(112,336.:
<br />241,217
<br />32,185
<br />
<br />(125,555)
<br />
<br />955,095
<br />
<br />5,097,114
<br />
<br />2014
<br />2,00%
<br />3.50%
<br />6.00%
<br />5.00%
<br />5.00%
<br />
<br />5,097,114
<br />
<br />2,194,263
<br />
<br />402
<br />2,068
<br />2,196.733
<br />
<br />374,703
<br />o
<br />90,067
<br />80,352
<br />29.509
<br />24,272
<br />253,278
<br />28.142
<br />1,348,002
<br />28,001
<br />o
<br />41,939
<br />2,298,267
<br />
<br />i101,52.;,
<br />
<br />33.428
<br />
<br />33,428
<br />
<br />(f2,100)
<br />
<br />5,029,009
<br />
<br />(5,0(;,7:
<br />
<br />{6".OS2)
<br />
<br />(26. 1 02.~
<br />
<br />o
<br />
<br />955,095
<br />
<br />(":0;,531,)
<br />253,278
<br />33,428
<br />(S5.267)
<br />
<br />1,045,001
<br />
<br />5,029,009
<br />
<br />2015
<br />2.00%
<br />3.50%
<br />6.00%
<br />5.00%
<br />5.00%
<br />
<br />Pro'ected
<br />2016
<br />2.00%
<br />3.50%
<br />6.00%
<br />5.00%
<br />5.00%
<br />
<br />5,029,009
<br />
<br />2,325,919
<br />
<br />410
<br />2,109
<br />2.328,438
<br />
<br />397,185
<br />o
<br />94,570
<br />84,370
<br />31,279
<br />25,486
<br />265,942
<br />29,549
<br />1,415,402
<br />29,401
<br />o
<br />44,456
<br />2,417,642
<br />
<br />(3S,2D.,
<br />
<br />36,575
<br />
<br />36,575
<br />
<br />':;'.',e-.'"
<br />
<br />4,976,380
<br />
<br />(S+.,63'
<br />
<br />(6",OSE:,
<br />
<br />(26.102)
<br />
<br />o
<br />
<br />1,045,001
<br />(88, 2 O.~ )
<br />265,9<12
<br />36,575
<br />(189.363)
<br />
<br />1,068,951
<br />
<br />4,976,380
<br />
<br />4,976,380
<br />
<br />2,465.474
<br />
<br />418
<br />2,151
<br />2,468,043
<br />
<br />421,016
<br />o
<br />99,299
<br />88,589
<br />33<156
<br />26,760
<br />279,239
<br />31,027
<br />1,486,172
<br />30,871
<br />o
<br />47,123
<br />2,543,253
<br />
<br />;~. b ;;-0::-'
<br />
<br />37,413
<br />
<br />37,413
<br />
<br />(~'7 .7~:(;j
<br />
<br />4,938,584
<br />
<br />(1,::;,.35?)
<br />
<br />o
<br />
<br />434,400
<br />(5-'-:.095)
<br />(25,102)
<br />o
<br />
<br />1,068,951
<br />
<br />(75,20S)
<br />
<br />279,239
<br />37,413
<br />(87.197:
<br />
<br />1,223.196
<br />
<br />4,938,584
<br />
<br />2017
<br />2.00%
<br />3.50%
<br />6.00%
<br />5,00%
<br />5.00%
<br />
<br />4,938,584
<br />
<br />2.613.402
<br />
<br />427
<br />2,194
<br />2,616,023
<br />
<br />446,277
<br />o
<br />104,264
<br />93,018
<br />35,145
<br />28,098
<br />293,201
<br />32,578
<br />1,560,481
<br />32,415
<br />o
<br />49,950
<br />2,675.429
<br />
<br />,'5S"!):',,
<br />
<br />42,812
<br />
<br />42,812
<br />
<br />i'.f'-,'"<::T'
<br />, ,-.~_..;
<br />
<br />4,921,990
<br />
<br />(;!07,535)
<br />
<br />(6/'.092)
<br />
<br />(:! C. ~ 02)
<br />(3G,350)
<br />
<br />1,223,196
<br />
<br />(5SA05)
<br />
<br />293,201
<br />42,812
<br />(33~,18q
<br />
<br />1,165,618
<br />
<br />.4,921,990
<br />
<br />2018
<br />2.00%
<br />3.50%
<br />6,00%
<br />5.00%
<br />5.00%
<br />
<br />4,921,990
<br />
<br />2,770,207
<br />
<br />435
<br />2.238
<br />2,772,880
<br />
<br />473,054
<br />o
<br />109,477
<br />97,669
<br />37,254
<br />29,503
<br />307,861
<br />34,207
<br />1,638,505
<br />34,036
<br />o
<br />52,947
<br />2,814,514
<br />
<br />(.~', ,G3,~'
<br />
<br />40,797
<br />
<br />40,797
<br />
<br />4,921,153
<br />
<br />(61,.098)
<br />(26.102)
<br />(36,350)
<br />
<br />1.165,618
<br />(,,1.63-1)
<br />307,861
<br />40,797
<br />(126,551)
<br />
<br />1,346,092
<br />
<br />4,921,153
<br />
<br />2019
<br />2.00%
<br />3.50%
<br />6.00%
<br />5.00%
<br />5.00%
<br />
<br />4,921,153
<br />
<br />2,936,419
<br />
<br />444
<br />2,283
<br />2,939,146
<br />
<br />501.437
<br />o
<br />114,951
<br />102,552
<br />39,489
<br />30,979
<br />323.254
<br />35,917
<br />1,720,430
<br />35,738
<br />o
<br />56.124
<br />2,960,872
<br />
<br />ninE)
<br />
<br />47,113
<br />
<br />47,113
<br />
<br />(237)
<br />
<br />25,387
<br />
<br />4,946,540
<br />
<br />o
<br />
<br />(1,,6.85::;)
<br />
<br />(6'::,095)
<br />(26,;02)
<br />(36.350)
<br />
<br />1,346,092
<br />(21'-126)
<br />323,254
<br />47,113
<br />
<br />{273.t.O,,)
<br />
<br />1,421,329
<br />
<br />4,946,540
<br />
<br />2020
<br />2.00%
<br />3.50%
<br />6,00%
<br />5.00%
<br />5.00%
<br />
<br />4.946,540
<br />
<br />3,053,876
<br />
<br />453
<br />2,328
<br />3,056,657
<br />
<br />531,524
<br />o
<br />120,699
<br />107,680
<br />41,859
<br />32,527
<br />339,417
<br />37,713
<br />1,806,452
<br />37,524
<br />o
<br />59,492
<br />3<114,886
<br />
<br />49,747
<br />
<br />49,747
<br />
<br />(2.1.2::"
<br />
<br />4,938,058
<br />
<br />(6-1.092)
<br />(26.,02)
<br />(36,250)
<br />
<br />1,421,329
<br />(52.229)
<br />339,417
<br />49.747
<br />
<br />(,26.55;)
<br />
<br />1,625.713
<br />
<br />4,938,058
<br />
<br />2021
<br />2,00%
<br />3.50%
<br />6.00%
<br />5.00%
<br />5.00%
<br />
<br />4,938,058
<br />
<br />3.176,031
<br />
<br />462
<br />2,375
<br />3,178,868
<br />
<br />563,415
<br />o
<br />126,733
<br />113,064
<br />44,370
<br />34,154
<br />356,388
<br />39,599
<br />1,896,774
<br />39,401
<br />o
<br />63,061
<br />3,276,959
<br />
<br />"?-:O<:'
<br />
<br />(S2.CS'i
<br />
<br />56,900
<br />
<br />56,900
<br />
<br />"",,;,,',
<br />
<br />4,896,866
<br />
<br />o
<br />
<br />(2:33.6S5)
<br />
<br />(6".095)
<br />(26.102)
<br />
<br />(35,3:,0)
<br />
<br />1,625,713
<br />(S8-,09~ )
<br />356,388
<br />56,900
<br />
<br />(350,246)
<br />
<br />1,580,663
<br />
<br />4,896,866
<br />
<br />2022
<br />2.00%
<br />3.SO%
<br />6.00%
<br />5.00%
<br />5.00%
<br />
<br />2023
<br />2.00%
<br />3.50%
<br />6.00%
<br />5,00%
<br />5.00%
<br />
<br />4,896,866
<br />
<br />3,303,072
<br />
<br />471
<br />2,423
<br />3,305,966
<br />
<br />597,220
<br />o
<br />133.070
<br />118,717
<br />47,032
<br />35,862
<br />374,207
<br />41,579
<br />1,991,613
<br />41,371
<br />o
<br />66,845
<br />3,447,515
<br />
<br />:,C:,550
<br />
<br />55,323
<br />
<br />55,323
<br />
<br />(26zn
<br />
<br />4,810,640
<br />
<br />o
<br />
<br />(54,098
<br />
<br />(2E',,02,:
<br />(35.35C')
<br />
<br />1,580,663
<br />(11,',,5::.D,:
<br />374,207
<br />55.323
<br />fi2E.551)
<br />
<br />1,742,093
<br />
<br />4,810,640
<br />
|