Loading...
102609 CC WS AgPCITY OF SHOREWOOD CITY COUNCIL WORK SESSION MONDAY, OCTOBER 2, 2009 100001100 B. Review Agenda 2. RATE STUDY DISCUSSION Mayor Liz& ' Bailey Turgeon Woodruff Zerby - 5755 COUNTRY CLUB ROAD COUNCIL CHAMBERS 5:30 P.M. Attachments Estimated Estimated Time in Start Time Minutes (Clock Time) Finance 90 minutes 5:30 p.m. Director's CAF 3. ADJOURN 7:00 p.m. TION FORM Department Finance Cound|VVork,session: 10/26/2009 Item Number: 2 From: Bonnie Burton, Finance Director/Treasurer iL'1 ° Attached is a memo from Northland Strategies that outlines the next iteration of findings from the utility system financial planning and rate analysis. Mr. Rusty Fifield, Senior Vice President - Director of Northland Strategies, will again be at the council work-session to review and discuss the information provided in this report. Staff is seeking guidance and direction from the City Council aowemove forward with analysis of alternatives. Options 1. For Council information and consideration only. Staff Recommendation No Council action required. Council Action: vi E CL C 40 m Ic o o m 40 c em v C >* 40 c own 0 c Ic an IA W o c 4w 40 CL CC >* 4w M C 4w WN mw CL c c 4w w 2 LIM 7 00 1 � Q- D 0 CL u V) 0.m 0 c-) �C v fl s-+ v WN �^4 OR o0 d a v a d a C) V) 0 fv 06 06 0 n 0 0 Q) u Qj u Ca U 0 u u 0 • 66 U u 7E 0 u 0 CZ u - 2 A u U 'I) u C) m Z; N CS O u US O 06 C) u a) U Q) On 0 u rq (z �4 C :� u M Q) > J. - (U (u 0 0 SS S a) Cu a) 0) C04 C-4 u biD W 0 Ca coo. o o Q 8888 lo '0 E Q) C,3 r > u G S to 1Q) - 45 E W m r C: Qy 0 't U E � C8 m 1:). (z -q - .5 C:) 0 :Z N -t4 x u u aj In Lf) . S u X 0 2 '0 > > m m E 4�a 4) Cu E Q Q) LS C) W G C f} — u v) ) N - 2 7- o - - - - - - -< g UO > 0 Im • > V v bb V) 0 4 7 (A 5 V) o o co Ln 0 0 0 0 0 0 0 0 U) 0 0 9 " " 9 q q q O0 19 1: N 1; h C� - m t U) Ln Ln Ln N 0 ro �o N 00 m 0 rl N N N N 71 m N Ln �o ko N re) vw E o Ln to M 0 0 Ln to Ln Ln to to 0 Ln Z C o to m r = Ln. Ln, M N r; N. N, N Ln. r�. 0) E = 0 la N q 0 N N ko rq 0 a ko N 0 tt1 ae N rn rq Ln M m N 40 0 0 to u"l 0 0 a 0 0 0 0 C) to 0 %A 0 0 0 0 Ln 0 V) 0 N Ln M m m u1 i U')* Ln Ln Zt' rn* cn* �0' m 4 M Va CA rl Ln It to rq M cr E 41 0 0 0 0 0 0 0 0 0 E a 0 0 0 0 0 0 0 0 flu C� C� Lq C� q q C� C� q C� Ln r, 0 0 0 0 0 tn 0 'n 't Ln r, 0 E E I v A 3 M a F Sn� m� ,c88S riSSS , coNg 2n N a • TSo& �� HU a� n $ ^ R gTN 3� r °:no 80 c Z a�Rm� nk $Pi r � = � 3 d cfi SO Ca,� g B SM� R o _ M1 s c o M b , ry �q� a rv� N r�e E � sm 0 O cv 0 al Q- Ol 0 O = CD rN 0 0 U 0 0 10 tz ;3 LA Ci4 C t4 CU M N a� Cli O Cc, In > CU oci cq N 'm 0 5 Iq Iq N 0 ra. cz W 0 N 10 ci 16 00 Co 00 4� CD -- r-k. CU cc ' cz bA W > 0 cz yi >, CZ U 4 m , C c : 2! CD �-o :3 w IZ W a) LO a) C7 - 6 :2 2 . E 0 0 T 0 r-L ." W z 2 � E 0 0 0 > U al Q- Ol 0 O = CD rN 0 0 U 0 i O EM 0-m 0 <D CD 0 2 u 0 R R LU EM 0-m 0 <D CD 0 2 u 0 i A A o � L tR 2 �Q zs to ^� � N � �"�� � �m � ^"4" � <�n�e�nN �o= ry�o Im 0 0 Em 0-m 0 C) C) 0 C) 0 V m O �o 00 "r � 00 tr) 00 "1 ll r* O� A c N ro [- N 0 00 c a = I . 11 . u — ID vi � a cy co 0 L, C� cs . 0 0 Lr) o p > 0 m rq Ln C: F-4 Lr) 0 0 V, 0) -j in 7 45 W W > c o 0 , rq m Cq Cq 0 rL 41 0 rl W vi ryi — U 0 a) OC US Mczl- co 0 10 cq In rq 0 C) m 2 . a m It O N O 00 u 10 0 0 V) C: < CT V) ( • E r-4 0 U A c N ro [- N 0 00 c a = I . 11 . u — ID vi � a cy co 0 L, C� cs . 0 0 Lr) o p > 0 tA 1 4- VI bA Ul O bjD r. O u 0 0 t5 u 0) v. 0 m 0 u 0 UO) o o U 0 , Cq Cq 0 > (Z U 0 a) w .— 0 US Mczl- C) 'o u 0 tA 1 4- VI bA Ul O bjD r. O u 0 0 t5 u 0) v. 0 m 0 u 0 UO) (Z C: CD (V o 0 u ;-4 Q) C) vi vi cd 06 ss ro W , g Lri 00 .0 aIY 4, r m vi 2: u o o a o 0 .0 . q �!Oaqqq �2 C O Im I I a a) ice+ *� .'4 (U ' u > 7:) o U CU CL u cz Cl. w Cl. tA V) ' w � � n � �, cn � c 't3 (Z C: CD (V o 0 u ;-4 Q) C) vi vi cd 06 ss ro W , g Lri 00 .0 aIY 4, r m vi 2: u o o a o 0 .0 . q �!Oaqqq �2 C O Im I I a a) ice+ *� .'4 (U ' u > o U CU (Z C: CD (V o 0 u ;-4 Q) C) vi vi cd 06 ss ro W , g Lri 00 .0 aIY 4, r m vi 2: u o o a o 0 .0 . q �!Oaqqq �2 C O Im I 1 ip om M ill oil 11y 1 r aill 11F F 1 1 !IV 1 111ol !IV 1 4 " 1 A' v OR 1 my cmg "Irl mull! v ! 1 1 W! 1 m All! HFUll 11 — 111 HV AI 11 P 1� om M I m /� / \ � � u \ / 3 /� \k cz Table 3 Water Revised Projections Water Fund 601 Budget 6-Month Projected 1 2 3 4 5 6 7 8 9 10 11 12 13 14 is 16 17 is 19 20 2006 2007 2008 2009 2009 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Revenues Taxes - Assessments - - - - 9,866 - - - - - - - - - - - - - - - - - - - - - Charges for Services 585,112 666,897 583,500 Water Sales 670,000 269,308 629,498 629,498 629,498 629,498 629,498 629,498 629,498 629,498 629,498 629,498 629,498 629,498 629,498 629,498 629,498 629,498 629,498 629,498 629,498 629,498 629,498 Connection Fees 10,000 5,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 Cellular Antenna Rental 85,000 111,839 111,839 112,000 112,000 112,000 112,000 112,000 112,000 112,000 112,000 112,000 112,000 112,000 112,000 112,000 112,000 112,000 112,000 112,000 112,000 112,000 112,000 Other 7,000 2,800 7,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 Bond Proceeds 1,402,585 396 - - - - - - - - - - - - - - - - - - - - - - - - Miscellaneous 163,218 193,008 130,000 145,000 39,130 145,000 58,603 53,802 51,549 50,847 50,282 47,704 45,948 43,644 40,746 37,330 33,271 15,478 9,793 3,378 (465) (5,071) (10,381) (14,381) (19,218) Total Revenues 2,150,915 860,301 713,500 917,000 437,943 903,337 816,101 811,300 809,047 808,345 807,780 805,202 803,446 801,142 798,244 794,828 790,769 772,976 767,291 760,876 757,033 752,427 747,117 743,117 738,280 -- (24,940) 732,558 Expenditures Staffing 75,163 86,677 109,659 100,029 49,953 100,029 102,030 104,070 108,233 112,562 117,065 121,747 126,617 131,682 136,949 142,427 148,124 154,049 160,211 166,620 173,284 180,216 187,424 194,921 202,718 210,827 Supplies/Materials 53,323 52,757 76,625 71,350 17,771 71,350 72,777 74,233 77,202 80,290 83,502 86,842 90,315 93,928 97,685 101,592 105,656 109,882 114,278 118,849 123,603 128,547 133,689 139,036 144,598 150,382 Support Services/Char 94,756 123,233 96,425 100,100 52,346 100,100 102,102 104,144 108,310 112,642 117,148 121,834 126,707 131,775 137,046 142,528 148,229 154,159 160,325 166,738 173,407 180,344 187,558 195,060 202,862 210,977 Debt Service - - - - 306,144 306,144 370,333 351,538 278,398 281,103 278,940 277,815 278,808 280,595 277,010 278,050 278,629 278,763 278,446 111,050 111,694 107,231 - - - - Capital Outlay - 494,000 149,000 15,117 149,000 272,000 290,000 272,000 250,000 340,000 284,800 296,192 308,040 320,361 333,176 F -- 999,803 360,363 374,777 389,768 405,359 421,574 438,437 455,974 474,213 493,181 Transfers - 310,000 260,000 260,000 - - - - - - - - - - - - - - - - - - - - - - Deprecation 184,105 201,790 185,000 202,000 119,196 272,925 271,333 283,460 296,926 306,776 317,405 334,405 348,645 363,455 355,562 359,774 376,433 426,423 444,441 463,180 482,669 502,937 524,015 545,937 568,736 546,859 Total Expenditures 407,347 774,457 1,221,709 882,479 560,527 999,547 1,190,574 1,207,444 1,141,068 1,143,373 1,254,059 1,227,443 1,267,284 1,309,475 1,324,613 1,357,548 2,056,875 1,483,639 1,532,479 1,416,205 1,470,016 1,520,848 1,471,123 1,530,929 1,593,127 1,612,226 Fund Balance Beginning Cash Balance 2,356,223 2,693,608 2,939,760 2,693,608 2,616,551 2,793,265 2,690,125 2,577,441 2,542,346 2,514,094 2,385,219 2,297,384 2,182,191 2,037,312 1,866,505 1,663,559 773,887 489,647 168,901 (23,248) (253,563) (519,047) (719,037) (960,911) (1,247,023) Net Income 1,743,568 85,844 (508,209) 34,521 (96,210) (374,473) (396,144) (332,022) (335,028) (446,279) (422,241) (463,839) (508,333) (526,369) (562,720) (1,266,105) (710,663) (765,188) (655,329) (712,983) (768,421) (724,005) (787,811) (854,847) (879,668) Depreciation 184,105 201,790 185,000 202,000 272,925 271,333 283,460 296,926 306,776 317,405 334,405 348,645 363,455 355,562 359,774 376,433 426,423 444,441 463,180 482,669 502,937 524,015 545,937 568,736 546,859 Other Cash Flow Impact (1,590,288) (41,482) - - - - - - - - - - - - - - - - - - - - - - - Ending Cash Balance 2,693,608 2,939,760 2,616,551 2,930,129 2,793,265 2,690,125 2,577,441 2,542,346 2,514,094 2,385,219 2,297,384 2,182,191 2,037,312 1,866,505 1,663,559 L773,887] 489,647 168,901 (23,248) (253,563) (519,047) (719,037) (960,911) (1,247,023) (1,579,832) Change Factors Revenues Charges for Services 0% 0% 0% 0% OV. 0% 0% OV. 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% Bond Proceeds 0% 0% 0% 096 BIA 0% 0% 0% 0% 0% 0% 09/o 0% 0% 0% 09/6 0% 0% 0% 0% InvestmentRote 2.0% 2.0% 2.06 2.0% 2.096 2.0% 2.0% 2.0% 2.0% 2.0% 2.0116 2.0% 2.0% 2.0% 2.0% 2.0% 2.0% 2.0% 2.016 2.0% Expenditures Staffing 211. 2% 496 491. 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 49s Supplies /Materials 2% 2% 4% 4% 4% 4% 4% 4% 4% 4% 4% 49/. 4% 41/6 4% 4% 4% 4% 4% 4% Support Services /Charges 2% 2% 4% 4% 4% 4% 4% 4% 4% 4% 4% 496 4% 4% 4% 4% 4% 4% 496 4% Capital Outlay 2016 2% 4% 4% 4% 4% 4% 491. 4% 4% 4% 4% 496 496 496 4% 4% 496 4% 4% Deprecation 0% 0% 0% 09/. 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% City Council Workshop - October 26, 2009 Table 5 Storm Sewer CIP _ P As You Go Stormwater 70% 0% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 0 1 6 4% 4% 4% Investment Rate 2.0% 2.09 2.0% 2.0% 2.0% Fund 631 2.0% 2.0% 2.0% Budget 6 -Month Projected 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 NA 2006 2007 2008 2009 2009 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Revenues Staffing 2% 2% 4% 4% 49 1 . 4°% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% Supplies /Materials 2% 2% Intergovernmental - - - - 5,658 4% 4% 4% 4% 4% 4° %a 4% 4% 4% 4% 4% 4% Support Services /Charges 2% 2% 4°%a 4% 4% 4% 4% 49/. Bond Proceeds - - - - - 4% 4% 4% 4% 4% 4% Capital Outlay 2% 2% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% Assessments 4% 4% 4% 4% 4% Deprecation 0% 096 0% 0% 0% 0% 0% 096 0% 0% 0% 0% 0% 0% 096 0% 0916 0% 0% 0% Charges for Services 69,177 164,347 218,000 218,000 90,259 187,547 318,830 318,830 331,583 344,846 358,640 372,985 387,905 403,421 419,558 436,340 453,794 471,946 490,823 510,456 530,875 552,110 574,194 597,162 621,048 645,890 Miscellaneous 72,323 14,579 10,000 10,000 4,684 10,000 8,696 6,721 6,714 5,395 4,867 3,698 3,305 2,981 2,634 2,265 1,871 1,452 1,006 532 29 (505) (1,071) (1,670) (2,304) (2,975) Transfers 25,000 41,049 - 300,000 - - - - - - - - - - - - _ _ _ _ _ - _ - Total Revenues 166,500 219,975 228,000 528,000 100,601 197,547 327,526 325,550 338,297 350,241 363,507 376,683 391,210 406,402 422,192 438,605 455,665 473,397 491,829 510,988 530,903 551,605 573,123 595,492 618,744 642,915 Expenditures Staffing 10,193 26,707 47,880 65,381 3,727 65,381 66,689 68,022 70,743 73,573 76,516 79,577 82,760 86,070 89,513 93,093 96,817 100,690 104,717 108,906 113,262 117,793 122,504 127,405 132,501 137,801 Supplies /Materials 1,871 750 6,700 8,800 501 8,800 8,976 9,156 9,522 9,903 10,299 10,711 11,139 11,585 12,048 12,530 13,031 13,552 14,095 14,658 15,245 15,854 16,489 17,148 17,834 18,547 Support Services /Charge 42,733 14,132 59,100 8,600 32,169 25,000 25,500 26,010 27,050 28,132 29,258 30,428 31,645 32,911 34,227 35,596 37,020 38,501 40,041 41,643 43,309 45,041 46,843 48,716 50,665 52,691 Debt Service 4,438 2,466 - 65,000 - - - - - - - - - - - - _ _ _ _ _ _ _ - _ _ Capital Outlay 90,056 - 100,000 614,000 - - 325,128 222,682 296,962 265,019 305,904 275,591 281,881 293,156 304,882 317,078 329,761 342,951 356,669 370,936 385,774 401,204 417,253 433,943 451,300 469,352 Transfers - 52,500 - - - - - - - - - - - _ _ - _ _ _ _ - _ _ _ Deprecation 19,833 19,833 20,000 20,000 - 20,000 19,833 36,089 47,223 62,071 75,322 90,618 104,397 118,491 133,149 148,393 164,247 180,735 197,883 215,716 234,263 253,552 273,612 294,474 316,172 338,737 Total Expenditures 169,124 116,388 233,680 781,781 36,398 119,181 446,125 361,959 451,501 438,698 497,299 486,923 511,822 542,213 573,820 606,691 640,876 676,430 713,405 751,859 791,852 833,444 876,700 921,686 968,472 1,017,129 Fund Balance Beginning Cash Balance 300,316 275,951 322,116 275,951 336,436 434,802 336,035 335,715 269,735 243,348 184,879 165,256 149,041 131,721 113,243 93,551 72,586 50,289 26,596 1,441 (25,245) (53,532) (83,497) (115,217) (148,774) Net Income (2,624) 103,587 (5,680) (253,781) 78,366 (118,600) (36,409) (113,204) (88,458) (133,792) (110,240) (120,612) (135,811) (151,627) (168,085) (185,211) (203,032) (221,576) (240,871) (260,948) (281,839) (303,577) (326,194) (349,728) (374,214) Depreciation 19,833 19,833 20,000 20,000 20,000 19,833 36,089 47,223 62,071 75,322 90,618 104,397 118,491 133,149 148,393 164,247 180,735 197,883 215,716 234,263 253,552 273,612 294,474 316,172 338,737 Other Cash Flow Impact (41,574) (77,255) - - - - - - - - - - - _ _ _ _ _ _ _ _ _ _ _ - Ending Cash Balance 275,951 322,116 336,436 42,170 434,802 336,035 335,715 269,735 243,348 184,879 165,256 149,041 131,721 113,243 93,551 72,586 50,289 26,596 1,441 (25,245) (53,532) (83,497) (115,217) (148,774) (184,251) Rafe Schedule Less 10,000 SOFT 450 450 450 450 450 450 450 450 450 450 450 450 450 450 450 450 450 450 450 450 450 Rate $70.59 $18.00 $18.00 $18.72 $19.47 $20.25 $21.06 $21.90 $22.78 $23.69 $24.64 $25.62 $26.65 $27.71 $28.82 $29.98 $31.18 $32.42 $33.72 $35.07 $36.47 10,000 - 50,000 SOFT 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 Rate $15.12 F $25.70 $25.70 $26.73 $27.80 $28.91 $30.07 $32.27 $32.52 $33.82 $35.18 $36.58 $38.05 $39.57 $41.15 $42.80 $44.51 $46.29 $48.14 $50.07 $52.07 Over50,000SQFT 465 465 465 465 465 465 465 465 465 465 465 465 465 465 465 465 465 465 465 465 465 Rate $19.68 $33.46 $33.46 $34.79 $36.19 $37.63 $39.14 $40.70 $41.33 $44.03 $45.79 $47.62 $49.52 $51.50 $53.56 $55.77 $57.93 $60.25 $62.66 $65.17 $67.78 Other 78 78 78 78 78 78 78 78 78 78 78 78 78 78 78 78 78 78 78 78 78 $35.00 $59.50 $59.50 $61.88 $64.36 $66.93 $69.67 $72.39 $75.29 $78.30 $81.43 $84.69 $88.07 $91.60 $95.26 $99.07 $103.03 $107.16 $711.44 $115.90 $120.54 Change factors Revenues Charges for Services 70% 0% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 0 1 6 4% 4% 4% Investment Rate 2.0% 2.09 2.0% 2.0% 2.0% 2.0% 2.0% 2.0% 2.0% 2.0% 2.0% 2.0% 2.0% 2.0% 2.09 2.0% 2.0% 2.0% 2.0% 2.0% Transfers NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA Expenditures Staffing 2% 2% 4% 4% 49 1 . 4°% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% Supplies /Materials 2% 2% 4% 49 1 6 4% 4% 4% 496 4% 4% 4% 4% 4% 4° %a 4% 4% 4% 4% 4% 4% Support Services /Charges 2% 2% 4°%a 4% 4% 4% 4% 49/. 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% Capital Outlay 2% 2% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% Deprecation 0% 096 0% 0% 0% 0% 0% 096 0% 0% 0% 0% 0% 0% 096 0% 0916 0% 0% 0% City Council Workshop - October 26, 2009 Table 6 Storm Seer CIP - Internal Loans Stormwater 2 3 4 5 6 7 Fund 631 9 10 11 Budget 6-Month Projected 14 2006 2007 2008 2009 2009 2009 Revenues 2011 2012 2013 2014 2015 2016 Intergovernmental - - - - 5,658 - Bond Proceeds - _ _ _ _ _ Assessments - - - - - - Charges for Services 69,177 164,347 218,000 218,000 90,259 187,547 Miscellaneous 72,323 14,579 10,000 10,000 4,684 10,000 Transfers 25,000 41,049 - 300,000 - - Total Revenues 166,500 219,975 228,000 528,000 100,601 197,547 Expenditures 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 325,128 - 222,682 - 296,962 - 265,019 - 305,904 - 275,591 - 281,881 - 293,156 - 304,882 - 317,078 329,761 342,951 356,669 370,936 385,774 401,204 417,253 433,943 451,300 469,352 208,177 231,076 256,495 284,709 316,027 350,790 389,377 432,209 479,752 - 532,524 - 591,102 - 591,102 - 591,102 - 591,102 - 591,102 - 591,102 - 591,102 - 591,102 - 591,102 - 591,102 8,696 9,550 9,837 9,222 7,883 5,680 4,257 3,216 2,927 3,299 4,575 6,692 8,460 9,855 10,855 11,434 11,566 11,223 10,379 9,001 542,001 463,308 563,294 558,951 629,814 632,061 675,516 728,581 787,561 852,901 925,438 940,746 956,231 971,894 987,731 1,003,740 1,019,920 1,036,268 1,052,781 1,069,456 Staffing 10,193 26,707 47,880 65,381 3,727 65,381 66,689 68,022 70,743 73,573 76,516 79,577 82,760 86,070 89,513 93,093 96,817 100,690 104,717 108,906 113,262 117,793 122,504 127,405 132,501 137,801 Supplies /Materials 1,871 750 6,700 8,800 501 8,800 8,976 9,156 9,522 9,903 10,299 10,711 11,139 11,585 12,048 12,530 13,031 13,552 14,095 14,658 15,245 15,854 16,489 17,148 17,834 18,547 Support Services /Charge 42,733 14,132 59,100 8,600 32,169 25,000 25,500 26,010 27,050 28,132 29,258 30,428 31,645 32,911 34,227 35,596 37,020 38,501 40,041 41,643 43,309 45,041 46,843 48,716 50,665 52,691 Debt Service 4,438 2,466 - 65,000 - - F --- 73 - ,0331 73,033 73,033 73,033 73,033 61,905 61,905 61,905 61,905 61,905 74,073 74,073 74,073 74,073 74,073 90,121 90,121 90,121 90,121 90,121 4% 4% 4% 4°%a 4% 4% 4% 4% 50,020 50,020 50,020 50,020 50,020 63,318 63,318 63,318 63,318 63,318 77,036 77,036 77,036 77,036 77,036 93,726 93,726 93,726 93,726 4% 4% 4% 4% 491 4% 496 4% 4% 66,706 66,706 66,706 66,706 66,706 65,851 65,851 65,851 65,851 65,851 80,118 80,118 80,118 80,118 80,118 97,475 97,475 97,475 4% 4% 4% 4% 4% 4% Deprecation 0% 0% 0° %a 59,530 59,530 59,530 59,530 59,530 68,485 68,485 68,485 68,485 68,485 83,322 83,322 83,322 83,322 83,322 101,374 101,374 68,714 68,714 68,714 68,714 68,714 71,224 71,224 71,224 71,224 71,224 86,655 86,655 86,655 86,655 86,655 105,429 Capital Outlay 90,056 - 100,000 614,000 - - 325,128 222,682 296,962 265,019 305,904 275,591 281,881 293,156 304,882 317,078 329,761 342,951 356,669 370,936 385,774 401,204 417,253 433,943 451,300 469,352 Transfers - 52,500 - - - - - - - - - - - - - - - - - _ _ - _ _ _ - Deprecation 19,833 19,833 20,000 20,000 - 20,000 19,833 36,089 47,223 62,071 75,322 90,618 104,397 118,491 133,149 148,393 164,247 180,735 197,883 215,716 234,263 253,552 273,612 294,474 316,172 338,737 Total Expenditures 169,124 116,388 233,680 781,781 36,398 119,181 519,158 485,012 641,259 687,988 815,30 793,800 831,996 861,532 902,093 937,474 983,828 1,033,099 1,084,341 1,137,633 1,193,056 1,250,697 1,310,643 1,372,987 1,437,824 1,505,255 Fund Balance Beginning Cash Balance 300,316 275,951 322,116 275,951 336,436 434,802 477,478 491,863 461,121 394,155 283,990 212,868 160,785 146,325 164,942 228,762 334,619 423,001 492,774 542,751 571,688 578,283 561,172 518,928 450,056 Net Income (2,624) 103,587 (5,680) (253,781) 78,366 22,843 (21,704) (77,965) (129,037) (185,488) (161,739) (156,480) (132,951) (114,532) (84,573) (58,390) (92,353) (128,110) (165,739) (205,326) (246,956) (290,722) (336,718) (385,043) (435,800) Depreciation 19,833 19,833 20,000 20,000 20,000 19,833 36,089 47,223 62,071 75,322 90,618 104,397 118,491 133,149 148,393 164,247 180,735 197,883 215,716 234,263 253,552 273,612 294,474 316,172 338,737 Other Cash Flow Impact (41,574) (77,255) - - - - - - - - - - - - - - - - - _ _ _ - _ _ Ending Cash Balance 275,951 322,116 336,436 42,170 434,802 477,478 491,863 461,121 394,155 283,990 212,868 160,785 146,325 164,942 228,762 334,619 423,001 492,774 542,751 571,688 578,283 561,172 518,928 450,056 352,993 Rate Schedule Less10,000SQFT 450 450 450 450 450 450 450 450 450 450 450 450 450 450 450 450 450 450 450 450 450 Rate $10.59 $11.75 $73.05 $14.48 $16.08 $17.84 $19.81 $21.99 $24.47 $27.09 $30.07 $33.38 $33.38 $33.38 $33.38 $33.38 $33.38 $33.38 $33.38 $33.38 $33.38 10,000- 50,000SQFT 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 Rate $15.12 $16.78 $18.63 $20.68 $22.95 $25.48 $28.28 $31.39 $34.84 $38.68 $42.93 $47.65 $47.65 $47.65 $47.65 $47.65 $47.65 $47.65 $47.65 $47.65 $47.65 Over 50, 000 SOFT 465 465 465 465 465 465 465 465 465 465 465 465 465 465 465 465 465 465 465 465 465 Rate $19.68 $21.84 $24.25 $26.91 $29.88 $33.16 $36.81 $40.86 $45.35 $50.34 $55.88 $62.03 $62.03 $62.03 $62.03 $62.03 $62.03 $62.03 $62.03 $62.03 $62.03 Other 78 78 78 78 78 78 78 78 78 78 78 78 78 78 78 78 78 78 78 78 78 $35.00 $38.85 $43.12 $47.87 $53.13 $58.98 $65.46 $72.67 $80.66 $89.53 $99.38 $110.31 $170.37 $110.31 $770.31 $110.31 $110.31 $110.31 $110.31 $110.31 $110.31 Change Factors Revenues Charges for Services I t % 11% 11% 11% 11% 11% 11 % 11% 11% 17% 11% 0% 0% 09 1 0 0% 0% 0% 09/6 0% 0% lnvestmentRote 2.0% 2.0% 2.0% 2.0% 2.0 °% 2.0% 2.0% 2.0% 2.0% 2.0% 2.0% 2.0% 2.09 2.0% 2.0 1 10 2.0% 2.0% 2.0% 2.0% 2.0% Transfers NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA Expenditures Staffing 29t 24% 4% 4 4% 4% 4% 4% 4% 4% 4% 4 1 6 4% 4% 4% 4% 4% 4% 4% 4% Supplies /Materials 2% 296 4% 4% 4% 4°%a 4% 4% 4% 4% 0 1 0 4% 4% 4% 4% 4% 4% 4% 496 4% Support Services /Charges 2% 2% 0o 4% 4% 0 1 0 4% 4% 4% 4% 4% 4% 491 4% 496 4% 4% 4% 4% 4% Capital Outlay 2% 2% 4% 4% 4% 4% 4% 4% 49 1 0 496 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% Deprecation 0% 0% 0° %a 0% 0% 0% 0% 0% 0% 0% 096 0% 0% 0% 0% 096 0% 0% 0% 096 City Council Workshop - October 26, 2009 Table 9 Sanitary Sewer Revised Projections Sanitary Sewer Fund 611 Budget 6 -Month 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 2006 2007 2008 2009 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Revenue Assessments - - - - - - - - - - - - - - - Other - - - 1,550 450 1,550 1,550 1,550 1,550 1,550 1,550 1,550 1,550 1,550 1,550 1,550 1,550 1,550 1,550 1,550 1,550 1,550 1,550 1,550 1,550 1,550 Charges for Services 991,659 1,046,199 950,500 816,000 391,874 811,980 811,980 828,220 853,066 887,189 922,676 959,583 997,967 1,037,885 1,079,401 1,122,577 1,167,480 1,214,179 1,262,746 1,313,256 1,365,786 1,420,418 1,477,235 1,536,324 1,597,777 1,661,688 Investment Income - - - 120,000 45,737 87,099 84,622 58,459 56,794 54,994 54,020 53,095 50,632 48,058 45,372 42,572 39,656 36,623 33,471 30,200 26,807 23,291 19,653 15,891 12,004 7,993 Transfers - 112,500 60,000 125,000 - - - - - - - - - - - - - - - - - - - - - - Total Revenue 991,659 1,158,699 1,010,500 1,062,550 438,061 900,629 898,152 888,229 911,410 943,733 978,247 1,014,228 1,050,148 1,087,493 1,126,323 1,166,699 1,208,686 1,252,352 1,297,768 1,345,006 1,394,143 1,445,259 1,498,438 1,553,765 1,611,331 1,671,231 Expenditures Staffing 46,260 85,257 90,236 94,638 26,841 94,638 96,531 98,461 102,400 106,496 110,756 115,186 119,793 124,585 129,568 134,751 140,141 145,747 151,577 157,640 163,945 170,503 177,323 184,416 191,793 199,465 Supplies/Materials 17,864 11,559 14,100 30,600 3,363 30,600 31,212 31,836 33,110 34,434 35,811 37,244 38,734 40,283 41,894 43,570 45,313 47,125 49,010 50,971 53,010 55,130 57,335 59,629 62,014 64,494 Support Services/Chart 517,448 645,152 639,282 641,216 293,498 641,216 665,582 706,183 730,899 756,481 782,957 810,361 838,724 868,079 898,462 929,908 962,455 996,140 1,031,005 1,067,091 1,104,439 1,143,094 1,183,102 1,224,511 1,267,369 1,311,727 Debt Service - - - - - - - - - - - - - - - - - - Capital Outlay 299,000 258,000 12,282 258,000 413,000 135,000 135,000 95,000 95,000 174,600 181,584 188,847 196,401 204,257 212,428 220,925 229,762 238,952 248,510 258,451 268,789 279,540 290,722 302,351 Transfers - 300,000 - - 1,000,000 1 - - - - - - - - - - - - - - - - - - - Deprecation 204,064 210,138 205,000 205,000 106,947 219,701 207,908 225,781 232,531 77,467 80,346 85,096 84,988 94,067 103,509 113,329 123,542 134,163 145,210 156,698 168,645 181,071 193,993 207,433 221,410 234,485 Total Expenditures 785,636 952,106 1,247,618 1,529,454 442,931 1,244,155 2,414,233 1,197,262 1,233,940 1,069,878 1,104,871 1,222,487 1,263,822 1,315,861 1,369,835 1,425,816 1,483,878 1,544,101 1,606,564 1,671,351 1,738,549 1,808,249 1,880,543 1,955,529 2,033,307 2,112,521 Fund Balance Beginning Cash Balance 3,550,499 3,958,627 4,387,061 3,958,627 4,354,943 4,231,118 2,922,945 2,839,693 2,749,695 2,701,017 2,654,739 2,531,577 2,402,891 2,268,590 2,128,587 1,982,799 1,831,149 1,673,563 1,509,977 1,340,329 1,164,568 982,649 794,537 600,205 399,639 Net Income 206,023 206,593 (237,118) (466,904) (343,526) (1,516,081) (309,033) (322,530) (126,145) (126,624) (208,259) (213,674) (228,368) (243,512) (259,117) (275,192) (291,749) (308,796) (326,345) (344,406) (362,990) (382,106) (401,764) (421,976) (441,290) Depreciation 204,064 210,138 205,000 205,000 219,701 207,908 225,781 232,531 77,467 80,346 85,096 84,988 94,067 103,509 113,329 123,542 134,163 145,210 156,698 168,645 181,071 193,993 207,433 221,410 234,485 Other Cash Flow Impact (1,959) 11,703 - - - - - - - - - - - - - - - - - - - - - - - Ending Cash Balance 3,958,627 4,387,061 4,354,943 3,696,723 4,231,118 2,922,945 2,839,693 2,749,695 2,701,017 2,654,739 2,531,577 2,402,891 2,268,590 2,128,587 1,982,799 1,831,149 1,673,563 1,509,977 1,340,329 1,164,568 982,649 794,537 600,205 399,639 192,833 Change Factors Revenue Charges for Services 096 2% 3% 49/. 4% 4% 4% 4% 4% 4% 4% 49S 4% 4% 4% 4% 4% 4% 496 4% Investmentincome 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% Transfers NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA Investment Rate 2.0% 2.0% 2.0% 2.0% 2.091. 2.0% 2.0% 2.0% 2.096 2.0% 2.0% 2.0% 2.096 2.0% 2.0% 2.096 2.0% 2.0% 2.0% 2.0% Expenditures Staffing 296 2% 411. 4% 4% 4% 4e, 496 4% 49s 416 4% 4% 416 4% 4% 4% 4% 4% 4% Supplies /Materials 2% 2% 4% 49 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4916 4% 4% 496 4% 4% Support Services /Charges 3.8% 6.1% 3 .5% 3.5V. 4% 4% 4% 496 4% 4% 4% 4% 4% 4% 4 °%n 4% 4% 4% 4% 4% Capital Outlay 2% 2% 4% 4% 4% 4% 4s, 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% Deprecation 0% OV. 0% 0% 0% 0% 0% 0% 090 0% 0% 0% 0% 0% 096 096 0% 0% 0% 0% Rates Residential 2,776 2,776 2,776 2,776 2,776 2,776 2,776 2,776 2,776 2,776 Z 776 2,776 2,776 2,776 2,776 2,776 2,776 2,776 2,776 2,776 2,776 $70.00 $70.00 $71.40 $73.54 $7648 $79.54 $82.72 $86.03 $89.48 $93.05 $96.78 $700.65 $104.67 $108.86 $173.21 $717.74 $122.45 $127.35 $732.44 $137.74 $143.25 LowIncome 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 $45.00 $45.00 $45.90 $47.28 $49.17 $57.73 $53.18 $55.31 $57.52 $59.82 $62.27 $64.70 $67.29 $69.98 $72.78 $75.69 $78.72 $81.87 $85.14 $88.55 $92.09 Commercial Flat 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 $70.00 $70,00 $71.40 $73.54 $76.48 $79.54 $82.72 $86.03 $8948 $93.05 $96.78 $100.65 $104.67 $708.86 $113.21 $117.74 $122.45 $127.35 $732.44 $137.74 $743.25 Commercial Other 43 43 43 43 43 43 43 43 43 43 43 43 43 43 43 43 43 43 43 43 43 190 190 193.80 799.61 207.60 275.90 224.54 233.52 242.86 252.58 262.69 273.19 284.11 295.48 307.30 319.59 332.37 345.67 359.49 373.87 388.83 Total Customers 2,828 2,828 2,828 2,828 2,828 2,828 2,828 2,828 2,828 2,828 2,828 2,828 2,828 2,828 2,828 2,828 2,828 2,828 2,828 2,828 2,828 City Council Workshop -October 26, 2009