|
City of Mounds View
<br /> Water Utility 2007 Rate Study
<br /> 3% 3% 3% 3% 3%
<br /> Actual Actual Budget Projected Projected Projected Projected Projected
<br /> 2005 2006 2007 2008 2009 2010 2011 2012
<br /> Expenditures
<br /> Personnel services $ 252,539 $ 209,350 $ 278,181 $ 286,526 $ 295,122 $ 303,976 $ 313,095 $ 322,488
<br /> Supplies&materials 37,286 38,549 57,603 39,705 40,897 42,124 43,387 44,689
<br /> Contractual services 138,982 129,429 201,611 133,312 137,311 141,431 145,673 150,044
<br /> Rehabilitate wells&tanks 98,363 - - - 60,000 60,000 - 60,000
<br /> Water service line repairs 34,421 51,991 35,000 36,050 37,132 38,245 39,393 40,575
<br /> Depreciation 214,797 230,125 215,000 237,029 244,140 251,464 259,008 266,778
<br /> Debtservice-interest 51,312 46,941 44,338 42,862 37,700 31,850 25,570 18,825
<br /> Transfers to other funds 68,850 73,735 76,422 78,115 79,858 81,654 85,503 85,409
<br /> Contingency - - 15,000 15,000 15,000 15,000 15,000 15,000
<br /> Total Expenditures 896,549 780,120 923,155 868,600 947,159 965,743 926,629 1,003,807
<br /> Revenues
<br /> Metered water sales 648,563 736,624 656,400 727,200 775,680 824,160 872,640 921,120
<br /> Meter charge 45,038 39,267 42,000 39,267 39,267 39,267 39,267 39,267
<br /> Water tower space rental 64,088 68,940 64,000 71,008 72,428 73,877 75,354 76,862
<br /> Water service line repair fee 47,413 46,977 46,000 46,977 46,977 46,977 46,977 46,977
<br /> Investment income 27,786 68,238 39,375 56,633 51,356 43,923 30,528 35,830
<br /> Miscellaneous revenues 34,689 585,976 19,000 19,570 19,570 19,570 19,570 19,570
<br /> Transfers from vehicle fund - - - - - 125,000 - 28,000
<br /> Total Revenues 867,576 1,546,022 866,775 960,655 1,005,278 1,172,774 1,084,337 1,167,625
<br /> Net Income (28,973) 765,902 (56,380) 92,056 58,119 207,031 157,707 163,818
<br /> Net assets-begining of year 3,731,039 3,702,066 4,467,968 4,467,968 4,560,024 4,618,143 4,825,174 4,982,881
<br /> Net assets-end of year $ 3,702,066 $ 4,467,968 $ 4,411,588 $ 4,560,024 $ 4,618,143 $ 4,825,174 $ 4,982,881 $ 5,146,700
<br /> Cash flows
<br /> Deduct:
<br /> Capital outlays-equipment $ 33,407 $ 18,649 $ 178,315 $ 150,000 $ - $ 125,000 $ - $ 28,000
<br /> Construction - - 80,000 165,000 350,000 575,000 30,000 30,000
<br /> Debt service-principal 175,000 180,000 185,000 190,000 200,000 205,000 210,000 215,000
<br /> Add back:
<br /> Depreciation 214,797 230,125 215,000 237,029 244,140 251,464 259,008 266,778
<br /> Miscellaneous asset and liability change! 30,411 (92,689) - - - - - -
<br /> Cash-Beginning of Year 1,175,255 1,183,083 1,887,772 1,887,772 1,711,857 1,464,115 1,017,610 1,194,325
<br /> Cash-End of Year $ 1,183,083 $ 19887,772 $ 19603,077 $ 19711,857 $ 19464,115 $ 19017,610 $ 19194,325 $ 19351,922
<br /> Water rate per 1,000 gallons used $ 1.50 $ 1.50 $ 1.50 $ 1.50 $ 1.60 $ 1.70 $ 1.80 $ 1.90
<br /> Annual based on 20,000 gallons per quarter $ 120.00 $ 120.00 $ 120.00 $ 128.00 $ 136.00 $ 144.00 $ 152.00
<br />
|