|
City of Mounds ViewStorm Water Utility 2010 Rate Study0.15% 3%3%3%3%ActualActualActual Budget Projected Projected Projected Projected Projected2007 2008 2009 2010 2011 2012 2013 2014 2015ExpensesPersonnel services 78,929 85,715 85,800 84,475 84,897 87,444 90,068 92,770 95,553 Supplies & materials 2,827 9,905 9,929 12,876 12,876 13,262 13,660 14,070 14,492 Contractual services 24,200 69,456 23,761 92,993 92,993 95,783 98,656 101,616 104,664 Depreciation 34,337 31,878 31,878 35,000 35,000 36,000 37,000 38,000 39,000 Transfers to other funds 6,000 16,000 46,000 56,000 56,000 56,000 56,000 56,000 56,000 Total Expenses146,293 212,954 197,368 281,344 281,766 288,489 295,384 302,456 309,709 Revenues0% 0% 0% 0% 0%Storm water service fee 208,411 224,391 243,342 250,718 250,718 250,718 250,718 250,718 250,718 Investment income 67,448 57,985 33,176 25,000 28,472 42,181 43,394 43,791 44,242 Transfers from vehicle fund - - - - 34,000 - - - - Total Revenues275,859 282,376 276,518 275,718 313,190 292,899 294,112 294,509 294,960 Net Income129,566 69,422 79,150 (5,626) 31,424 4,410 (1,272) (7,947) (14,749) Net assets - beginning of year2,513,042 2,642,608 2,712,030 2,712,030 2,706,404 2,737,828 2,742,238 2,740,966 2,733,019 Net assets - end of year2,642,608 2,712,030 2,791,180 2,706,404 2,737,828 2,742,238 2,740,966 2,733,019 2,718,270 Cash Flows Net Income129,566$ 69,422$ 79,150$ (5,626)$ 31,424$ 4,410$ (1,272)$ (7,947)$ (14,749)$ Deduct:Capital outlays - equipment - - (2,046) - (34,000) - - - - Construction - - - (48,000) (50,000) - (22,500) (15,000) (514,000) Add back:Depreciation 34,337 31,878 31,878 35,000 35,000 36,000 37,000 38,000 39,000 Change in receivables/payables2,575 6,167 (5,865) - - - - - - Cash - begining of Year1,065,187 1,231,665 1,339,132 1,442,249 1,423,623 1,406,047 1,446,457 1,459,685 1,474,738 Cash - end of year1,231,665$ 1,339,132$ 1,442,249$ 1,423,623$ 1,406,047$ 1,446,457$ 1,459,685$ 1,474,738$ 984,989$ Quarterly residential service fee7.50$ 8.25$ 9.00$ 10.00$ 10.00$ 10.00$ 10.00$ 10.00$ 10.00$ Annual fee30.00 33.00 36.00 40.00 40.00 40.00 40.00 40.00 40.00 20
|