<br />City of Arden Hills
<br />Utlllty Rate Study
<br />8aseModel
<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 Watersales
<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 Purchased water
<br />28 Utilities
<br />29 MCES charges
<br />30 General Fund admin charge
<br />31 Total Operating Expenses
<br />32
<br />33 Net Operations
<br />34 Non operating revenues (expenses)
<br />35 Investment income
<br />36 Other income (expense)
<br />37 Transfers
<br />38 Total non operating revenue (expenses)
<br />39
<br />40 Net increase (decrease) in resources
<br />41
<br />42 Capital contributions
<br />43 Other
<br />44 Ending net assets
<br />45 CIP Funding
<br />46 Current Year Capital
<br />47 Bond Proceeds
<br />48 Bond P&I. Future -20 yrs aI5.5%
<br />49 Bond P&I- Future -20 yrs at 5,5%
<br />50 Bond Prin - Existing
<br />S1
<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 nelassets
<br />
<br />4.262,554
<br />
<br />829,277
<br />105,300
<br />630
<br />935,207
<br />
<br />252,204
<br />
<br />17,417
<br />29,673
<br />16,995
<br />17,917
<br />128,308
<br />11,882
<br />
<br />24,645
<br />582,027
<br />
<br />1,081,068
<br />
<br />::1.~5JoC'
<br />
<br />25,136
<br />53,459
<br />
<br />78,595
<br />
<br />(67,;,60:
<br />
<br />7,520
<br />4,202,808
<br />
<br />958,132
<br />
<br />620,489
<br />
<br />4,202,808
<br />
<br />2004
<br />
<br />Sewer Fund
<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 />4,202,808
<br />
<br />1,014,300
<br />40,950
<br /><20
<br />1,055,670
<br />
<br />262,037
<br />
<br />41,869
<br />33,118
<br />27.333
<br />21,736
<br />123,225
<br />10,779
<br />
<br />23,667
<br />569,425
<br />
<br />1,113,189
<br />
<br />';:." ::; ~ ~-'
<br />
<br />11,986
<br />
<br />11,986
<br />
<br />{,;5,5::::::)
<br />
<br />4,157,275
<br />
<br />o
<br />
<br />620,489
<br />
<br />(57.51S)
<br />
<br />123,225
<br />11,986
<br />
<br />(2S7.2(4)
<br />
<br />(5,153)
<br />
<br />422,764
<br />
<br />4,157,275
<br />
<br />4,157,275
<br />
<br />1,061,873
<br />
<br />875
<br />1,062,748
<br />
<br />253,874
<br />
<br />26,582
<br />30,009
<br />27,333
<br />21,679
<br />133,561
<br />26,978
<br />
<br />24,294
<br />623,319
<br />
<br />1,167,629
<br />
<br />,1G':,::t:'
<br />
<br />'1,041
<br />
<br />11,041
<br />
<br />(S3,8,:D
<br />
<br />4,063,435
<br />
<br />o
<br />
<br />...22,764
<br />
<br />(;o,~.551 )
<br />
<br />133,561
<br />11,041
<br />
<br />(55,211)
<br />
<br />(138,716)
<br />267,558
<br />
<br />4,063,435
<br />
<br />2006
<br />
<br />3.50%
<br />6.00%
<br />
<br />3.00%
<br />
<br />4,063,435
<br />
<br />1,145,000
<br />11,400
<br />850
<br />1,157,250
<br />
<br />286,100
<br />
<br />20,600
<br />70,283
<br />31,000
<br />23,000
<br />123.225
<br />12,300
<br />
<br />28,800
<br />716,624
<br />o
<br />1,311,932
<br />
<br />':;.',,652:,
<br />
<br />10,000
<br />
<br />10,000
<br />
<br />/1.,.,,6[',;'
<br />
<br />3,918,753
<br />
<br />o
<br />
<br />'1080GO:
<br />
<br />267,558
<br />
<br />(15?',E52)
<br />
<br />123.225
<br />10,000
<br />
<br />(;00,080')
<br />
<br />146,101
<br />
<br />3,918,753
<br />
<br />BudQet
<br />2007
<br />2.00%
<br />3.50%
<br />6.00%
<br />
<br />3.00%
<br />
<br />3,918,753
<br />
<br />1,180,600
<br />400
<br />850
<br />1,181,850
<br />
<br />290,997
<br />
<br />29,509
<br />53.538
<br />20,125
<br />17,250
<br />145,000
<br />20,667
<br />
<br />30.400
<br />750,000
<br />30.384
<br />1,387,870
<br />
<br />70s_we!
<br />
<br />10,000
<br />
<br />10,000
<br />
<br />,ocCO;;::;
<br />
<br />3,722,733
<br />
<br />i?1S,857)
<br />
<br />146,101
<br />
<br />(205.C-:!O.1
<br />
<br />145,000
<br />10,000
<br />
<br />(219.957)
<br />
<br />(12':,676)
<br />
<br />3,722,733
<br />
<br />2008
<br />2.00%
<br />3.50%
<br />6.00%
<br />
<br />5.00%
<br />
<br />5.00%
<br />
<br />3.722,733
<br />
<br />1,329,496
<br />
<br />1,329,496
<br />
<br />308,457
<br />
<br />30,9~
<br />56,215
<br />21,333
<br />18,285
<br />152,250
<br />21,700
<br />
<br />31,920
<br />787,500
<br />32,207
<br />1,460,851
<br />
<br />, '-" ,~'~,""
<br />
<br />(,~ 3'1
<br />
<br />,...:,...
<br />
<br />'"~ :-C
<br />
<br />3,587,007
<br />
<br />':;-f'},':'~::
<br />
<br />(,2~.576)
<br />
<br />(-,31.355.\
<br />
<br />152,250
<br />
<br />(.:.371)
<br />(27, 3:'.~ )
<br />
<br />(1'::5.695)
<br />
<br />3,587,007
<br />
<br />2009
<br />2.00%
<br />3.50%
<br />6.00%
<br />
<br />5.00%
<br />
<br />5.00%
<br />
<br />3,587,007
<br />
<br />1,490,445
<br />
<br />1,490,445
<br />
<br />326,964
<br />
<br />32,534
<br />59,026
<br />22,612
<br />19,382
<br />159,863
<br />22,785
<br />
<br />33,516
<br />826,875
<br />34,139
<br />1,537,696
<br />
<br />(:.7,2:',1
<br />
<br />i5,C9~<
<br />
<br />':;,C~S
<br />
<br />;::/
<br />
<br />3,53-'1,657
<br />
<br />ilB~-_;;S(,)
<br />
<br />(1:'5.695\
<br />(0.25,::
<br />159,863
<br />
<br />{5,OSS,
<br />
<br />( 1E5,76.~1
<br />
<br />(223,9,:6i
<br />
<br />3,534,657
<br />
<br />2010
<br />2.00%
<br />3,50%
<br />6.00%
<br />
<br />2011
<br />2.00%
<br />3.50%
<br />6.00%
<br />5.00%
<br />5,00%
<br />
<br />5.00%
<br />
<br />5.00%
<br />
<br />5.00%
<br />
<br />3,534,657
<br />
<br />1,675,664
<br />
<br />1,675,664
<br />
<br />346,582
<br />
<br />34,160
<br />61,977
<br />23,969
<br />20,545
<br />167,856
<br />23,925
<br />
<br />35,192
<br />868,219
<br />36.188
<br />1,618,612
<br />
<br />57,052
<br />
<br />:7.838)
<br />
<br />'::e::;,e
<br />
<br />~,C.,r.;
<br />
<br />49.21':
<br />
<br />3,583,871
<br />
<br />p5:~,OSS::
<br />
<br />(223.9(,6)
<br />57,052
<br />167,856
<br />0.838)
<br />
<br />(355.095)
<br />
<br />(361.975)
<br />
<br />3,583,871
<br />
<br />3,583.871
<br />
<br />1,776,204
<br />
<br />1,776.204
<br />
<br />367,377
<br />
<br />35.868
<br />65,076
<br />25,':07
<br />21,778
<br />176,248
<br />25,121
<br />
<br />36,951
<br />911,630
<br />38,359
<br />1,703,816
<br />
<br />72,388
<br />
<br />(,2.Gb:
<br />
<br />{',2,669;
<br />
<br />59,719
<br />
<br />3.643,590
<br />
<br />(i'.~ :,94'
<br />
<br />(30-,,975':
<br />
<br />72,388
<br />176,248
<br />(12,669)
<br />(7:'.19:')
<br />
<br />(200.201)
<br />
<br />3,643,590
<br />
<br />2012
<br />2.00%
<br />3.50%
<br />6,00%
<br />5.00%
<br />5.00%
<br />
<br />2013
<br />2.00%
<br />350%
<br />6.00%
<br />5.00%
<br />5.00%
<br />
<br />5.00%
<br />
<br />4.00%
<br />
<br />3,643,590
<br />
<br />1,882,776
<br />
<br />1,882.776
<br />
<br />389,420
<br />
<br />37,662
<br />68,330
<br />26,932
<br />23,084
<br />185,061
<br />26,377
<br />
<br />38,799
<br />957,211
<br />40,661
<br />1,793,536
<br />
<br />89,241
<br />
<br />0.007)
<br />
<br />17CC7'
<br />
<br />82,234
<br />
<br />3.725,824
<br />
<br />(1_102,02',\
<br />1,108,100
<br />
<br />(200,20i)
<br />
<br />89,241
<br />185,061
<br />(7.CCi7)
<br />19
<br />
<br />67,113
<br />
<br />3,725,824
<br />
<br />4.00%
<br />
<br />3,725,824
<br />
<br />1,995,743
<br />
<br />1,995,743
<br />
<br />412,785
<br />
<br />39,545
<br />71,746
<br />28,548
<br />24,469
<br />194,314
<br />27,696
<br />
<br />40,739
<br />1,005,072
<br />43,100
<br />1,888,013
<br />
<br />107,730
<br />
<br />2,349
<br />
<br />2,349
<br />
<br />110,078
<br />
<br />3,835,902
<br />
<br />iE5.SF
<br />
<br />67.113
<br />107,730
<br />194,314
<br />2,349
<br />
<br />(85.9 ~ 7 i
<br />
<br />282,589
<br />
<br />3,835,902
<br />
<br />2014
<br />2.00%
<br />3.50%
<br />6.00%
<br />5.00%
<br />5.00%
<br />
<br />3,835,902
<br />
<br />2,115,488
<br />
<br />2,115,488
<br />
<br />437,552
<br />
<br />41,522
<br />75,333
<br />30,261
<br />25,938
<br />204,030
<br />29,081
<br />
<br />42,776
<br />1,055,325
<br />45,686
<br />1.987,503
<br />
<br />127,984
<br />
<br />9,891
<br />
<br />9.891
<br />
<br />137,875
<br />
<br />3,973,777
<br />
<br />o
<br />
<br />(3,BCD
<br />
<br />I BE, 9 ~ I' )
<br />
<br />282,589
<br />127,984
<br />204,030
<br />9,891
<br />(92,7,7)
<br />
<br />531,776
<br />
<br />3,973,777
<br />
<br />Pro'ected
<br />2015
<br />2.00%
<br />3.50%
<br />6.00%
<br />5.00%
<br />5,00%
<br />
<br />4.00%
<br />
<br />3,973,777
<br />
<br />2,242,417
<br />
<br />2.242,417
<br />
<br />463.805
<br />
<br />43,598
<br />79,100
<br />32,076
<br />27,494
<br />214,231
<br />30,535
<br />
<br />44,915
<br />1,108,092
<br />48,427
<br />2,092,273
<br />
<br />150,144
<br />
<br />18,612
<br />
<br />18,612
<br />
<br />168,756
<br />
<br />4,142.534
<br />
<br />;'.':'.1(8)
<br />
<br />(5,2:,9',7)
<br />
<br />531,776
<br />150,144
<br />214,231
<br />18,612
<br />(203,Oe,~)
<br />
<br />711,679
<br />
<br />4,142,534
<br />
<br />2016
<br />2.00%
<br />3.50%
<br />6.00%
<br />5.00%
<br />5.00%
<br />
<br />4.00%
<br />
<br />4,142,534
<br />
<br />2,320,901
<br />
<br />2,320,901
<br />
<br />491,633
<br />
<br />45,778
<br />83,055
<br />34,001
<br />29,144
<br />224,943
<br />32,061
<br />
<br />47,160
<br />1,163,496
<br />51,333
<br />2,202,604
<br />
<br />118.297
<br />
<br />24,909
<br />
<br />24,909
<br />
<br />143,206
<br />
<br />':,285,739
<br />
<br />(5:;,10','
<br />
<br />(135_917,;
<br />
<br />711,679
<br />118,297
<br />224,943
<br />24,909
<br />(i,~,~.Oi 7)
<br />
<br />935,810
<br />
<br />4,285,739
<br />
<br />2017
<br />2.00%
<br />3.50%
<br />6.00%
<br />5.00%
<br />5.00%
<br />
<br />4.00%
<br />
<br />':,285,739
<br />
<br />2,402,133
<br />
<br />2,402,133
<br />
<br />521,131
<br />
<br />48,067
<br />87,208
<br />36,041
<br />30,892
<br />236,190
<br />33,664
<br />
<br />49,518
<br />1,221,671
<br />54.413
<br />2,318,796
<br />
<br />83,337
<br />
<br />32,753
<br />
<br />32,753
<br />
<br />116,091
<br />
<br />':,401,830
<br />
<br />(89,S",':;}
<br />
<br />(85.9',,)
<br />
<br />935,810
<br />83,337
<br />236,190
<br />32,753
<br />(172.e92)
<br />
<br />1,109,199
<br />
<br />4,401,830
<br />
<br />2018
<br />2.00%
<br />3.50%
<br />6.00%
<br />5.00%
<br />5.00%
<br />
<br />4.00%
<br />
<br />4,401,830
<br />
<br />2,474,197
<br />
<br />2,474,197
<br />
<br />552,399
<br />
<br />50,470
<br />91.568
<br />38,203
<br />32,746
<br />2':7,999
<br />35,348
<br />
<br />51,994
<br />1,282,755
<br />57,678
<br />2,441,160
<br />
<br />33,037
<br />
<br />38,822
<br />
<br />38.822
<br />
<br />71,859
<br />
<br />4,473,689
<br />
<br />(S2_Cr'.:,
<br />
<br />{68,S-,?1
<br />
<br />1.109.199
<br />33,037
<br />247,999
<br />38,822
<br />(181,59,)
<br />
<br />1,247,465
<br />
<br />4,473,689
<br />
<br />2019
<br />2,00%
<br />3.50%
<br />6.00%
<br />5.00%
<br />5.00%
<br />
<br />4.00%
<br />
<br />4,473,689
<br />
<br />2,548,423
<br />
<br />2,548,423
<br />
<br />585,543
<br />
<br />52,994
<br />96,147
<br />40,495
<br />34,710
<br />260,399
<br />37,115
<br />
<br />54,594
<br />1,346,892
<br />61,139
<br />2,570,028
<br />
<br />(;;"SC~;\
<br />
<br />43,661
<br />
<br />43,661
<br />
<br />22,056
<br />
<br />4,495,744
<br />
<br />(12S,":'.')
<br />
<br />(28.S,?)
<br />
<br />1,247,465
<br />(2UCE,)
<br />260,399
<br />43,661
<br />(275,358)
<br />
<br />1,251.562
<br />
<br />4,495,744
<br />
<br />2020
<br />2.00%
<br />3.50%
<br />6.00%
<br />5.00%
<br />5,00%
<br />
<br />4.00%
<br />
<br />4,495,744
<br />
<br />2,624,875
<br />
<br />2.624.875
<br />
<br />620,676
<br />
<br />55,644
<br />100,954
<br />42,925
<br />36,793
<br />273,419
<br />38,971
<br />
<br />57,324
<br />1,414,237
<br />64,807
<br />2,705,749
<br />
<br />(fG2?3';,
<br />
<br />43,805
<br />
<br />43,805
<br />
<br />(37,009
<br />
<br />4,458,676
<br />
<br />'95,::',(,
<br />
<br />r'i,c,-
<br />\V~.-
<br />
<br />1,251,562
<br />(EC.2i':j)
<br />273.419
<br />43,805
<br />
<br />( ~ 5 7 ) 35:
<br />
<br />1,300,678
<br />
<br />4.458,676
<br />
<br />2021
<br />2.00%
<br />3,50%
<br />6.00%
<br />5.00%
<br />5.00%
<br />
<br />4.00%
<br />
<br />4,458,676
<br />
<br />2,703,622
<br />
<br />2,703,622
<br />
<br />657,916
<br />
<br />58.426
<br />106,002
<br />45,501
<br />39,001
<br />287,090
<br />40,919
<br />
<br />60,190
<br />1,484,949
<br />68,695
<br />2,848,688
<br />
<br />':':S'::>::C,
<br />
<br />45,524
<br />
<br />...5,524
<br />
<br />(~;S,S:.:'
<br />
<br />4,359,133
<br />
<br />iS2,31S;
<br />
<br />{85_S17)
<br />
<br />1,300,678
<br />
<br />(145.066)
<br />
<br />287,090
<br />45,524
<br />(187)35)
<br />
<br />1,300,990
<br />
<br />4,359,133
<br />
<br />2022
<br />2.00%
<br />3.50%
<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.00%
<br />
<br />4.00%
<br />
<br />4,359,133
<br />
<br />2,784,730
<br />
<br />2.784,730
<br />
<br />697,391
<br />
<br />61,347
<br />111,302
<br />48,231
<br />41,341
<br />301,445
<br />42,965
<br />
<br />63,199
<br />1,559.196
<br />72,817
<br />2,999,234
<br />
<br />~'-'--<
<br />
<br />45.535
<br />
<br />45,535
<br />
<br />;1U.9(;(;
<br />
<br />4,190,164
<br />
<br />195.315:'
<br />
<br />{2SS;7:
<br />
<br />1,300,990
<br />
<br />(21'~ ,50:i )
<br />
<br />301,445
<br />45,535
<br />(",2-7,235.\
<br />
<br />1,246,231
<br />
<br />4,190,164
<br />
|