Loading...
HomeMy Public PortalAboutExhibit MSD 18Z Tables G-1 through K-10Exhibit MSD 18Z B C D. E R G H l K 7 FII > F '2413P'Ak+G ee , ', d tr iR to Comm Review ; _i er t 8 EiPlY13"I' ., B+ latl 13eht eevlce 3uue 27 : 1l 1 1Q,I►3 =I 9 Input Reference BD -11 2010 2011 2012 — . 2013 2014 { 2015 2016 Bonds 13 i Existing Revenue 14 : Series 2004A Revenue Bonds 0.0% Stormwater Related 15 , Actual ; 1 9,621,084: 9,758,234 9,880,384 1 10,016,784 , 10,148,844 10,299,781 1, 10,435,181 16 1 Accrued - ;_ 1—___ j _1 , 9,643,942 , 9,778,592 1 9,903,117 10,038,794: 10,174,000 10,322,348 1 10,461,148 17 1 1 I-..____. 0.0% r.. 18 1. Series 2006C Revenue Bonds Stormwater Related I 19 Actual 2,902,000 L 2,902,000 2,902,000 i 2,902,000 1 2,902,000: 2,902,000 2,902,000 20 Accrued 1 L_ 2,902,000 1 2,902,000 ; 2,902,000 2,902,000 2,902,000 i 2,902,000,4 2,902,000 21 i , i 0.0% — a 22 i Series 2008A Revenue Bonds Stormwater Related 23 Actual L 1,632,435 1,632,435 ; 1,632,435 1 1,632,435 1 1,632,435 1,632,435 4 1,632,435 24 — ; Accrued __..__..._ , .i 1,632,435 1 1,632,435_1 1,632,435 1,632,435.1 1__ , 1,632,435£ . 1,632,435 _-.1,632,435 25 26 Series 2010A Taxable BABs 0.0% — Stormwater Related .. — 27 Total -Actual 1,285,880 4,977,600: 4,977,600 1 4,977,600; 4,977,600 4,977,600 4,977,600 28 Total - Accrued ; +i 2,115,480 4,977,600 . 4,977,600 1 4,977,600 4,977,600 4,977,600 4,977,600 29 Credits - Actual 450,058 L 1,742,160: 1,742,160 1 1,742,160 1,742,160 1,742,160 1,742,160 30 Credits - Accrued 740,418 1,742160 1,742,160 1,742,160: 1,742,1601 1,742,160 1,742,160 31 Net - Actual 835,822 , 3,235,440 i 3,235,440. 3,235,440 i 3,235,440 � 3,235,440 3,235,440 32 Net - Accrued 1 1 1,375,062 1 3,235,440—r 3,235,440 i 3,235,440 3,235,440 1 3,235,440 3,235,440 33 1 L .. i 34 — Series 20 Revenue Bonds —.. 0.0% Stormwater Related -- -+-- 35 Actual 36 Accrued 37 L 38 Total Existinglevenue Bonds 1 39 Actual 15,441,399 _ 19,270,269— 19,392,419 T 19,528,819 19,660,8791 19,811,816 , 19,947,216 40 Accrued 16,293,857 19,290,627 1 19,415,152 19,550,829 19,686,035 1 19,834,383 , 19,973,183 41 Maximum Debt Service (Actual) 30,691,125 30,691,125 30,691,125 1 30,691,I25 30,691,125'1 30,691,125 42 Stormwater Portion (Accrued) 0, 0 0 0 1 0 i 0! -- — 0 43 t- f —..._._1-_ 44 , _ D E F G H 1 J K 45 File, Y201r P'AYGORate , _ ..,,. > ar Rate Review Yet^ 1k 46 ;DE T2 -18 i t1ng Debt Serv3e June 27 211 i1 10 O a.rz , 47 Input Reference BD -1148 2010 2011 2012 2014 ' 2015 2013 1 50 _- - $ $ $ ! $ .1. ...._2016 $ $ 51 Existing State - -_i_..__....-$ Revolving Fund Loans 52 Series 2004B SRF MSD 1 0.0% Stormwater Related 53 Actual 2,205,942 . 3,396,622__ 3,396,206 2,568,518.1_ 2,544,971 3,428,115 ; 3,431,641 54 Accrued i {` 2,804,082 f 3,402,226 1 2,560,757_ 2,990,568 3,436,190 ; 3,438,481 55 , -- .-. 2 0.0% -2,988,349 L--_ 1 - - 56 Series 2004B SRF MSD .--- _ - Stormwater_ Related 57 Actual 1 6,599,777 6,614 793 -I 6,609,208 6,615,416 1 6,628,026 ` 6,636,568T __._.. 6,650,438 ! 6,641 109 ` 6,658,268 6,651,552 6,669,180 58 Accrued 6,622,925 ! 6,632 646 _.... 6,643,559 59 ' 1 T ; 60 Series 2004B SRF MSD 3 0.0% Stormwater Related 61 Actual _1 1,323,918 ' 667,509 ' 515,917 1,191,395: 1,171,7621 484,167 484,432 62 Accrued 998 463 :. 592,863 ' 854,443 1,184,078 830,465 485,137 485,359 63 l.._ j _ .. f_ .. _f 64 Series 2005A SRF ; OM Stormwater Related 65 Actual 424,397 425 434 1 426,387 441,199 ` 425,826.1 425,194 424,128 66 Accrued ( 426,239_ j 428,179 1 443,120 ( 427,702 427,425 1 426,412 ! 430,268 67 _ _ 68 Series 2006A SRF L 0A% Stormwater Related 69 Actual 2,836,0191_ 2,834,605 1 2,836,136 2,835,807_ 2,836,614 1 2,834,330 I 2 2,597,593 70 Accrued : 2,840,891 j 2,843,019 2,843,828 ; 2,847,236 I 2,845,292 2,607,519 2,962,842 71 Series 2006B SRF ! 0.0%' 72 Stormwater Related ! 73 Actual 899,520 ;- 899,367 899,119 ' 903,728 1 903,141 ' 902,390 i 901,463 74 Accrued 902,877 902,657 907,331 906,799 1 906,107 905,248: 904,204 75 E__ I 76 Series 2008B SRF 0.0% Stormwater Related 77 Actual 2,573,868 2,485,959 i 2,482,250 2,483,511 I- 2,480,116 2,481,626 1 2,483,362 78 Accrued 2,489,588 2,488,505 ; 2,487,306 4. 2,486,276 ' 2,485,371 !, 2,487,044 2,486 374 79 i 80 Series 2009A Direct Loan 0.0% Stormwater Related 81 Actual 65,294 864,000 1 1,394,609 ' 1,397,830 1,401,215 ; 1,404,653_ i 1 1,408,134 82 Accrued 1 i 233,194 1,392,987 ; 1,396,223T 1,399,528: 1,402,890 1 1,406,40- 1,409,950 83 i T 1 84 Series 2010A Direct Loan 0.0% Stormwater Related 85 Actual ! 0 ' 109,912: 118,114 f 494,055 , 494 135 ! 494,279 494,384 86 Accrued 50,855 118,114 ; 306,066: 494,111 ' 494,224 ; 494299 494,534 87 :2011A ; 88 Series Direct Loan 0.0%-: Stormwater Related - - __ _ . _ ._ 89 Actual i ... --....---_-_.--- 2,451,110 ^ 2,450,035+._.___.2,447,900 90 ---------._.._....,----__.._.--_.--- Accrued -- - - 0 322,208 i 2,451,748_1 2,451,250 ` 2,450,701511 2 2,449,100 1 2,447,435 92 Total Existing State Revolving Fund Loans - 1_______-.---- --.__.---_-.-_! ._-.----_.._.._...-_ 16,928,736 : 18,292,616 L 20,232,613 0 232,613= 21,395,192 - _ 21,345 457 ; -__._._.. 21 324 5899 93 Actual __-_- 21,545,898' 94 Accrued 17,360,982 ; 19,113,6841 21,311,060: 21,401,297: 21,483,485 i 21,355,619 , 21,728,627 95 Maximum Debt Service (Actual) I 21,865,087. 21,865,087T 21,865,087_4_ 21,865,087 21,865,087 21,865,087 96 Stormwater Portion (Accrued) 0 0' 0 0 0 0 • 0 i 98 Total Existing Debt Service(Actual) 32,370,135 37,562,885 39,625,031 40,924,0101 41,006,335 ' 41,357,715 : 41,271,806 99 Maximum Debt Service (Actual) . 43,232 219 43 232,219 43,232,219 _._ 43,232,219 43,232,219 43,232,219 100 -_.I 2010 2011 ` 2012_ 2013 2014 2015 2016 X101 H 1 A Il C° 1 13 E [ F [ ("r i 1 t ;1 «013PAYGORat Rule Y+ s 102 P upmed WW De lat "xervlse ,fun+ 2ik 7011 10;113 a ta. 6- 103 103 Input Reference BD -11 � I 104 Ref. —_ _— 2012 2011 ! 2013 2014 I 2015 2016 —=�—� -- — —_ 107 Revenue Bonds , Assumed issued on first day of selected month. € €)8 0-7 Amount of Issue - $ ! 0 i 52,020,000 ; 0 0 o o 109 Month Issued (1=7u1y, 2 -August, etc) 11 2 1 1 1 1 5.50% 5.50% 5.50% 5.50% 5.50% 5.50% 110 . Bond Interest Rate - % 1 111 i-- Bond Term -years 7 30 30 30 ` 30 30 30 112 ual Annual Debt Service -$ i 0 1 3,579300 1 0! 0 0 I 0 113 J_ 1.40% of amount issued 4 114 Bond Issuance Expense - $ .__-. t 0 ; 728.300 ! 0 115 _ Stormwater Portion - % 0.0% 0.0%: 0.0% 0.0% 0.0% 0.0% 1 — — 16 t T _ . _. _ -- or actual 117 Series 2011 Revenue Bonds (From proposed _ debt service schedule) 118 Actual 119 Accrued 120 j Actual r. —0 : O — 0 1 0 ;_. I21 Accrued i 0 0 0` 0 1 0. 0 122 Maximum (Actual : 0 0 0 0 0; 0 r.__. 1....__.___._._......._ 123 124 -Series 2012 Revenue Bonds (Fram proposed or actual,debt service schedule) 125 ! Actual i26 Accrued 127 Actual 1,430 550 ' 3,579300 1 3,579300 3,579,300 3.579,300 128 Accrued ! _ 3,281,000 T 337930(F 3,579,300' 3,579,300 1 3.579_300 129 2011 & 2012 Combined Actual I 1,430,550 3,579,300 3,579,300 3,579,300 ---3 5 3.579,300 3.579.300 --- 0 3,579,300 130 Maximum Actual 3,579,300 ! 3,579,300 3,579.300 131 ---- - -- — 132 iSeries 2013 Revenue Bonds (From proposed or actual debt service schedules — 133 _ _; I Actual 4 f 1 134 Accrued I 135 Actual 0 0 0 0 136 Accrued T i 0 0 0 0 137 2011, 2012 & 2013 Combined Actual 3,579,300 3.579,300 3,579,300 1 3,579,300 138 Ma� Maximum (Actual), 3,579,300 1 3,579,300 3,579,300 3.579.300 139 1 140 Series 2014 Revenue Bonds (From_proposed or actual debt service schedule) E 141 Actual j 1 1- 142 Accrued r_—_ 143 Actual 1+ 1 144 Accrued 0 p p 145 2011, 2012, 2013 & 2014 Combined Actual I 3,579.300 3,579,300 I 3,579.300 146 Maximum (Actual)' 3.579,300 + 3,579,300 ' 3,579,300 147 fi 148 Series 2015 Revenue Bonds (From proposed or actual debt service schedule) ( 149 Actual 150 Accrued I T j L 151 Actual a ! L I0 j 0 152 Accrued a 01 0 153 2011. 2012. 2013, 2014 & 2015 Combined Actual i 3.579,300 3,579,300 254 Maximum (Actual)! ! 3,579,3001 3,579300 155 -;— � — —L.- - _ ' , — — --- 156 Proposed Revenue Bond Debt Service --i 157 r 2011 ._...---.------_., _- of ;.--._-__...__--_.._—,. o! 0 o� ,__._. _.-- a' 0 158 2012 —_ • 3.281,000 ; 3,579,300 ! 3,579,300 I 3,579,300 ! 3,579,300 159 2013 2014 r___....... -___r..— —._. f--------........._----_ i--- — —.._-.-- .-.. 0 _-__._._-- -_-0_ 0[ 0 0 0 160 161 2015 —. —_.. — r —0 , 0 2016 —..__.._..- __ . _._— . _._.._______Y---_--_._ 0 162 ! _..- 163 2017 T._.__,___,.... —.--- .;_.__._____—_- 164 018 j___,__._..__—_.___. 165 2 2019 i .— ^_-.____--_y_ 2020. ; I 66 " -' _. _.. _.._.-....-----_...-_- 167 2021 I68 2022 ; 169 2023 L .._.___...---_..._---- ---3___— 2024 ' —_____...___...._.______T_.._..._..._.._ 170 71 2025 _.__._______. 172 2026 y 173 2027 174 2028 . i 175 -20291_ 176 2030 ; r— 178 Total Proposed (Accrued) Q.;. 3,281,000 3,579,300'. 3,579,300 3,579,300 3,579,300 179 Total Proposed (Actual) 0 1,430.600 1 3.579.300 3 579 300 3.579,300 3.579,300 180 Total Existing &Proposed (Actual) 19 270,300 20.823101 23,108.100 23240200: 23,391.10 ; 0 23,526,500 181 Total Stormwater (Accrued) 0 1 0 t 0 0! 0 1 0 I I B C D E I• G 193 File: [A'1i20#24'A tati4l tii i C^ F+ts emt txaitast f P€ ' VOt SR Dt $7 ttt t,n w, tErt a a i7t 28 t i t0iiii 194 I IS de ' Bond Expense Override: 230,000 2012 i 2013 2014 2015 2016 i9€r' Ref.]_ L L _ I 2011 198 „ _. __ . _---- 1r1 --_—... $ __- .-.- $ I a._._.-,1 $ __.L a__..__ Loans ! ; Assumed issued — 149 State Revolving on first day of selected month 'iltl 0-7 1/__ of issue # 1- $ 37,000,000 39,999,300 ! ._....__..._ 0 ----------0- 20 I Month Issued (l=July,2=Au tg—tst, etc) 6 5 5 5 5 5 202 ._..___ Amount of Issue # 2 $ ; 0 0 ; 03 -._ ._. 2 Au t, etc 12 Month Issued 1 Jul 10 04 Bond Interest Rate - % 2.50% t 2.50% 2.50% 2.50% 2.50% : 2.50% ?t}5 ' Bond Term - years). 20 20 20 20 20 20 Equal Annual Debt Service # I - S ' 2,373,400 I 2,565,800 ' 0 0 I 0 0 207 Equal Annual Debt Sery ice # 2 - $ ; 0 0 208 0.65% of amount issued 0.� 260,000 -.. 209 ! Bond Issuance Expense l� _ Bond Issuance Expense # I- $ r-- � 1 230.000 � 0 1 ' p 0 p �— _ --_ -- —(— 210 # 2$ 322,200 211; l L _-- -r 212 Series 2011 SRF Loans (From prop or actual debt service schedule) _ 213 Actual -used 214 Accrued t5' j Actual -t-__ t . _ 226 ._... Accrued 0 f 0 217 t I -----' �__..... - � __--_ �--- - + 218 2012 SRF Loans (From proposed or actual debt service schedule) 219 _. _,Series Actual 220. __._..1 _. Accrued _ ........ 221 Actual — — 499991 2,565,800 I 2,565,800 1 2,565,800 , 2,565,800 - —2,565,800 Accrued 1 1 t` t— 1,711,000 i 2,565,800 r 2 565,800 '. 2 565,800 u 1 ( .224 _ iSSeries 2013 SRF LoansjFrom proposed or actual deCservice scheduled — 1— -- 1 — 225 Actual 1 226 i ' Accrued 227 i Actual rt I 29 Accrued -I I 0 0 0� 0 23t0 Series 2014 SRF Loans (From proposed or actual debt service schedule) r ?32_ Actual 1- I 7 i-- Accrued ) , r 233 Actual j 1 p 0 0 234 Accrued 0 ! 0 235 1 _. _L l 236 __.____ Series 2015 SRF Loans (From proposed or actual debt service schedule) 23' Actual 1 238 1 Accrued ' 1 30 1 Actual 0 i 0 240 Accrued 1 i 1 r 0 0 ---- _. 242 ;Proposed SRF Loans Debt Service r 243 ;2011 : 0' 0 1 0 0___ 0' 0 ;44 12012 1 ._. —' i 711000 1 2,565 800 2,565,800 I 2 565,800 r 2,565,800 45 2013?— —_ ' t _.--= 0 0 0 ' 1t ; 201�4 i __ _.... ._._..� L _—�_.__.___ i — —i — 0— - 0 h _. 247 _ !2015 248 2016 0 240 ; 2017 1 - 1 -_-__-....__.- _r_._-.-----.. _..�____ 250 2018 ----_. 251 x2019_L I — -- i I —...-- 252 120201; —.---__} 253 1 1-- —� -, 254 --_'202 _.. 2022 `._-----.__._..---------___-- 255 S 2023 i — -- — - 256 `2024 ; 1 —..__.-- .._. .._ .. — —...__...._._... 257 -, ----1- — 2025 —....... 258 2026 r 259 12027 260 2028 1 261 : 2029 _. _._..-----_..,__._ 262 2030 .._ ._......._._.:..— _ — - = —.4__--._.__.._ 264 _Total Proposed (Accrued _ 0 1 1.711,000 2565,8007 2,565,80007 2,565,800 : 2.565,800 265 Total Proposed (Actual) : _ fl 500000 2,565,800 2,565,800;i_ 2,561800 ' 2,565,800 266 Total Existtngic Pressed (Actual) I8,292,6001,- 20,732,600 Total Senior and Subordinate Debt 1 ; 23 961000 ; — —..._- 23,911,300;1 24,111 700 23 890.400 267 268 12011 Debt Service (Actual) } 37,562,885 , 39.625,031" 40,924,010 41,006,335 , 41,357,715 41,271.806 269 2012 Debt Service (Actual) 41,555,573. _. - 47,069,110.; .._ 47151.435 47502,8157 47,416,906 270 2013 Debt Service (Actual) 1 47069 110 1 47,151,435 475628i5 ' 47 416 906 271 2014 & Beyond Debt Service (Actual - - 47,151,435 1 47,502,815;; 47,416,906 272 Maximum (Fxisttng & Proposed) _ 43,232,200 49,377,300 49,377 300 , 49,377,300 49,377,300 49,377,300 73 Subordinate Debt Only 274 Maximum (Cumulative Proposed) - 2,373,400 4,939,200 _ 4,934 200 4,939,200 4,939,200 4,939,200 275 _ i Maximum (Existing & Proposed) 24,238,48'7 26,804,287 26,804.287 26,804,287 , 26,804,287 ; 26,804,287 . ... . . 276 - A B C, D �: ,- F G 11 (. . ,. J L 285 FI>e:FY20t4'iG 9a i1 # =1=urReeA t[isi ler4d _'86 C:t)IJY p t Sri` lutac23 2001 287 288 Ref. 1' i -I 1. 2011 2012 , 2013 2014 i 2015 1 2016 2017 selected month. 1 j i 0 0 291 .General Obligation Bonds ! !Assumed issued on first day of i. Amount of Issuegi -$ —__ 0 j 0 0 r. Q 292 293 1 Month Issued (l =July, 2=August, etc) 4 7 2 4 4 4 ' 4 294 i Bond Interest Rate - % i 4.75% 4.75% 4.75% 4.75% 4.75% 4.25% 4.25% 295 ; Bond Term .years 20 20 20 20 20 20 20 296 Equal Annual Debt Service #1 - $ F 0 0 j 0 i 0 0 0 1 0 297 i 1 ! 130% of amount issued , 298 ! Bond Issuance Expense -$ j 1 0 I 0, 0 0 0 0 0 299 L( [ 1 1 i nor 0 01 0 300 Series 2011 General Obl ation Bonds (From proposed actual debt service schedule) i 301 Actual _-- )_ 302 1 Accrued ----_._._ 1 '. 0 I 0 303 i Actual i 0 l 0 304 Accrued 0 0.1 0 i 0 '_, 0 1 0. 0 305 '. -f 306 : Series 2012 General Obligation Bonds�From proposed or actual debt service schedule) j I 307 1 Actual Accrued .--• T , 308 __... . 309 Actual : Q ' 0 0 0 r . ,. . .. t Accrued 311._.___.____1._..----.-__�.__.._.___.. 1 f 312 : Series 2013 General Obligation Bonds (From proposed or actual debt service schedule'. ; 313 Actual 314 1._ Accrued .1_ - ----..._.._. L _.._ ..._ � .. . -.._ ..... _...... _ '. 315 1 Actual i 0 1 Q! 0 -0 0 316 Accrued � i 0 f 0 0 . 0 0 317 l.__ L 318 ---_.- __.i_- _ 4Series 2014 General Oblation Bonds (Fromproposed or actual debt service schedule) i ' _.-- 319 Actual 1 1 i ----'Y 310 . - Accrued r -- 321 i Actual i 0 1 0 0 Q 322 Accrued j 1 0 0 0! 0 323 ! 1 �i r nor F i 324 Series 2015 General Obligation Bonds (From -proposed actual debt service schedul) i 325 Actual -T 326 f. Accrued 1 327 Actual 1--- l 1 0 0• 0 328 Accrued I 0 0 1 0 329 I { -i 330 Proposed General Obli ation Bonds Debt Service 1 I 331 2011 1 0 0 0 0 1 0 1, 0' ! 0 332 2012 i 0 0 0 i 0 0 0 333 12013 00 Z r 0, 0 0i 334 2014 I t ' 00� 0 ' 0 . 0 335 2015 ' i i T- fl� 0_ 336 2016 T rt......- - -... �L 0 0 337 ;2017 1 ' 338 ,2018 f 1 - 1 - 339 ;2019 1 340 1 1 12020 I ! 1 L 341 +2021 1 - . - 342 12022 i 7 343 12023 i _- k 344 i 2024 , -1- f_.____ 345 _12025 346 ,2026: 347 2027 t r._.._...--. ----- �------- - -;- 348 4. t ---- 2028 r - -._. 349 1 2 2 3 0 9 ' - 1 --- 350 _ : 2030 j i 1 ------ 1 - ---_ : -._..---------1-- 351 2031 ; 1 --- i-- 35/ 2032 I ' 1_ ..._-_.. _.77177 353 2 _......033.1__ .._.-..... .--- --- 2035: ----------_.._.-._-_-_i—___..- 355 • 358 t ---._r....- r..._..— -.....__- _,.._..- 2038 - r.. 359 2039 1 -_.__-.-.--- 360 --__-_. .---__.--{ 360 2040 ' --t-- __ _ - 361 - ; 2041 i___ --------�--------�-------.._._---_. 2042 ; ' -- 362 -... 363 2043 ; i -1- - - 1 364 '2044 - ... 365 :2045 .._-_..------- 367 Total Proposed fAccruedl Proposed (Actual ! 0' 0 i 0 0 0' 0 `. s__-.._..-...__-_ _..- ._ ....__ _..__ __..-----_........ �.__._.,_...._._ _..__---.._.... --------_- .---.......-- p . + 368 .Total 369 - . • 3 1 i � r - --- -.- ! 021 Annual _. __ _. _. 370 .... . __.. 6 cceasc_ V 1_ r- 30,820,823 31437,240_ 32r0 5,984 ` Assessed - $1000 32,707,304 371 , ', Indicated TaxRate 0000. 0000 0000.• 0. 0 0 0. 0000' 372 � 4 Typical Monthly Tax Bill on a $150,000 house. 0.001. ' 0.00 0.00.. 373 . ... . _ .. _ _. - .. _0.00 _ , . . .. . . 1 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 B I C E 1 F File: FY2013P YGARat , D 1 - For Rate Gom mixtlo AR - ArnoldDebt Repa,+ meat June 2T, 2011 10:03 a .m . Input Reference RD- Pri ncipal (c ontributions) and interest fr om the Ct., of Arn old to reserve capacity in the Lower Meramec River Wastewater Treatme nt Pla nt . i G 410 411 412 413 414 415 416 Payme nt Int erest 1 Pri ncipal 25 432 % 2006 , 2007 1 16,700,000 1,105,460 721,440 384,020 1 16,315,980 2008 16,315,980 , 1,105,460 1 704,850 400,609 ' 15,915,371 2009 15,915,371 1 1,105,460 I 687,544 r 417,916 15,497455 2010 j 15,497,4551- 1,105,460 1 669,490 435,970 I 15,061,486 2011 i• 15,061,486 h 1,105,4601 650,656, 454,803T 14,606,682 2012 14,606,682 1 1,105,460: 631,009 474,451 1 14,132,232 1 2013 { 14,132,232 1,105,460 610 512 494,947; 13,637,2841 2014 13,637,284 ( 1,105,460 1 589,131 r 516,329 1 13,120,955 2015 13,120,955 _ _ 1,105,460 i 566,825 538,634 12 582,321 2016 12,582,321 fi - 1,105,4601 543,556 561,903 ; 12,020,418 i • 2017 12, 020,418 , 1,105,460 1 519,282 586,178 11,434 240 2018 11,434,240 1,105,460 1 493,959 611,500 , 10,822,7401 2019 10,822,740 1 105 460 i• 467,542j 637,917 i 10,184,822 2020 10,184,822 1- 1,105,460 1 439,984 1 665,475 1 9,519,347 2021 9,519,3471 1,105,460 411,236 694,224 8,825,1231 2022 8,825,123 1,105,460 381,245 724,214 1 8,100,909 1 ' 2023 8,100,909 1,105,460 , 349,959 755,500 7,345,408 2024 7,345,408 1,105,460 ' 317,322-11- - 788,138 6,557,270_1_ 2025 6,557,270 1,105,460 283,274 822,186 5,735,085 j, 2026 5,735,085 , 1,105,460 I 247,756 857,704: 4,877,381 1 2027 4,877,381 1,105,460 ' 210,703 894,757 i_ 3,982,624 2028 3,982,624] 1,105,460 172,049 933,410 ! 3,049,214 ! 2029 3,049,214 1,105,4601 131,726 973,7347 2,075,480 2030 2,075,480 1105460 89661 1,015,799 1,059,681 1 2031 3- 1,059,681 1,105,460 45,778 (0) H EOY.._.I Ver 1a G-6 2032 _...- ._.___.. (��... -. ,. 1,105,460 1 (0) 2033 2034 2035 2036 r 1,059,681 1,105,460 A 13 C D E �w F f G 1� 1 J K 426 Ctrl -F File FY2013PAYG©Rat :,, es. DRAFT -For Rate Commission Review Ver la 427. Ctrl -X CFLN - Cash Flow to ut ,inns 27r /.01I 10:03 a.tu: G-7 428 Input Reference BD -12 G I Selcct 0, I, or 2: 1 Three sets of da 429 Alternate PAYG Rate Proposal Test Year j 430 Ref."Description ; ; 2011 1 2012 2013 2014 2015 2016 432 ! Resistance/Lag Percent (assumes 1 month billing 1g) 0.0% 8.3% 20.3% 8.3% 8.3% 8.3% 433 ! -Full Year Revenue Increase 0.0% 4.3% 144.0% 0.0% 0.0% 0.0% 434 ;Months Rate Effective New Debt: • 12 12 12 12 12 12 435 Revenue Bond Proceeds - $ 2,585,000,000 0' 52,020,000 0 0 0 0 436 G-3 Month of Revenue Bond Issued i May August j July July July I July 437 State Revolving Loan Proceeds #1- 8,1- 37,000,000 39,999,300 0 0 0 0 438 G-3Month of SRF Loan #1 Issued 1 j December j November November November I November November 439 State Revolving Loan Proceeds #2- 0 . 0 -- Average House Value: 150,000 440 i Month of SRF Loan #2 Issued June I April I 1 441 LGO Bond Proceeds i I. 0 0 0 0 i) 0 442 Month of d GO Bonds Issue i October anuary August i October j October October 443 —_, GO Bond Balance (Min Capital Balance) _-- 444 G t0 :Commercial Paper ; 0 j 0 I 0 0 0 0 445 :Grants/Developer Contributions_ $ (BD -12) 0 t 1,sttfi,tlfltl 11 tJ 0 446 '. Deposits to Emergency Fund Reserve 0 0 0 0 447 _ ;Cash Financing_of Construction $ 6.000,000 7,150,000 272,050,000 324.400.000 313,550,000 307.750, 0i0 448 I ! 1,950,0 ! L i 1,000,000 min. 449 ;Minimum EOY Fund Balances ! min. operating balance - capital balance 450 G-11 j Net Annual Balance (Operations) - __.J. $ 451 G-11 EOY Operations Balance - $ I a = _ ,. •, r - f ;: g 452 G-10 EOY Capital Program Balance - $ 1 8,668,600 4,050,61 4 4,519,700 92,794,900 146,535,900 2- 453 G_18 Minimum Monthly Capital Pros. Balance - $ 8,668,600 972,600 4,089,500 11,842,200 97, 52,704) _ IS t* ,000 454 G-18 Month of Minimum Monthly Balance 1 June July i July I July ! July July 455 Debt Service Covera e r ! 456 G-11 Revenue Bond J 4.23 x 4.22 x 14.03 x 16.23 xi 15.68 x 15.34 x 457 Percent Debt Financed 458 1Cumulative J IImprovement Fund CIRP Projects 1 1,265,000 2;000,000 2,000,000 2,000,000 2,000,000 2,000,000 459 ',CIRP Adjustments 0 . 0 0 0 0 0 0 13 J C D r--7-----1 I G H I J 461 File: FV2013PAYGORates. DRAFT _ For Rate + rre rnisslu 11e ie Ver 1a 462 FBAL - Fund Balances June 27 2011 10:03 a.rn. -8 463 Input Reference BD -5 — Wastewater Stormwater Combined E j 464 , -- FY 2011 ! FY 2011 FY 2011 Interest Earnings Rate: 465 ! BOY BOY BOY r 2011 thru I 466 _ _ I Balance (a) Balance Balance (a) 2014 1 2015 468 i 469 t 1 !Short Term 1.00% 1.00% 470 7 Long Term i 1.20% 1.20% 471 i TCapital Program 1 I.00% < 1.00% 472 Operations ,'(Net of encumbrances) ! 'How split between WW & SW? 473 General Fund Balance 10,803,000 3,500,000 ; 14,303,000 474 Special Funds 1_-._.___--__ 475 Real Property Improvements & Alterations 2,607 900 2,407,900 200,000 476 WBU Fund 10,294,800 ' 0 10,294 ,800 j 477 Sanitary Replacement Fund Operating Allowance 0 0 , 479 Subtotal ; 23,505,700 ; 3,700,000 ' 27,205,700 ' 480 Less Operating Reserve p g (-0 days) — —. . 21— , 808,800: 2,912,300 _— 24,721,100 , 4- 482 Unrestricted Operations Beginning Balance 1,696,900 787,700 ! 2,484,600 - 483 J — — _ 484 Capital Financing i 485 Construction Funds 1 —265,491,200 486 Fund Balance (Sanitary Replacement only) 265,491,200 =265491200-178998200 487 Fund Balance (Stormwater Replacement only) 10,531,500 10,531,500 I 488 Less: Encumbrances 86,493,000 178,998,200 2,942,400 :' 181,940,6001— —._ 489 Special Funds I I L 490 Improvement I 411,000 0 411,000 ; 491 Emergency Fund 5,073,300 0 6,073,300 493 Subtotal I 6,484,300 0 [ 6,484,300 1- ___._. 494 Transfer to/(from) Operations 0 0 ; 0 i 496 Unrestricted Capital Program Beginning Balance j 92,977,300 7,589,100 .__ _..___ 100,5-6,400 166:5-4;40o Assumed to be _..-_.. _-__..... all Wastewater re 497 ! j 1 498 Total Operations and'Ca Capital Fund Balance _-___ —__... — p —_-- ! 94 674 200 ! 8 376 800 ! '— __ __._.____ .._____ 103,051,000 499 ' i__--.__----_._ —'_—.> r__--- --_-_-_.___. 500 (a) : A s of June 30 2010. .— -- 501 ! i t � i _.�._t--__—_. 502 1 B D E F G H J L 5118 Fite: . _ , „ i� 1 O to [3 Fo R CQm ai iar Review !`er 589 CIPFIN`- CiP'FinancialPlnn ,lune27.2411 tll;il am Ci-lQ 590 i Input Reference BD- :was 18 ! 1 XFer113 I Xfer 2 for Bonds 591 Table 3_9 592 Wastewater Capital Improvement Pro rant Financin 593 r___.__. 54a --. Line I----_--- —J Fiscal Year Ending June 30, 596 Ref. I No I Description 1 2011 2012 2013 1 2014 I 2015 2016 : 2017 598 $$ ` $.—_ $ 7 $ $ —.__-- .._—_$ —__.---- 599 Source of Funds 1 600 G-8 ' I , Beginning of Year Balance I 92,977,300 : 8,668,600 4,050,60.0 I 4,519,7.00 ' 92,794,900 j 146,535,900 j 222,812,100 601 0-3 1 2 4 Revenue Bond Proceeds 1 0. 52,020,0001 0 01 0; 0; 602 G-3 1 3 State Revolving Loan Proceeds 37,000,000 I 39,999,300 i 0' 0 i 0 L 0 0 603 4 _ Commercial Paper _— 9_11 0 0 0 t 0 01_— 604 — ; 1 General Obligation Bonds — — , 0 •r__ i....._..._._..__.01-- 0 0 0 I 0 605 G-7_1_ -_._...__._. 5 ! Cash Financing of Construction _.._ _ .. _0 _ _ _ 37 50,000 I 38,438,000 ! 273,377,0004_: 325,767,000rt 314,958,0001 309,200,000 ; 2.97,794,000 606 G-7 1 6 ff Grants & Contributions a 4 ! 454,800 ; 474,500 1 1,494,900: 516,300 i 538,600 1 561,900 586,200 607 G-18 ; 7 ; Interest Income @b) ' 2,768,900 L 2,120,800 —r--1,404,200 I 1,419,900 1,874,400 2,527,300': 2,672,100 609 : 8 Total Funds Available 1 1 170,451,000 141,721,200. 280,326,700 ; 332,222,900 - 410,165,900 I 458,825,100 I 523,864,400 610 , !Application of Funds 1 1 F-3-1- 9 Major Capital Improvemen — 158,223,000 Fri 31,103,000, 273,807,0001 237,428,000. 261,630,000 234,013,004_0 344,165,000 612 B-19': 10 , Improvement Fund Projects! 1,265,0007 2,000,0001_ 2000,000 ( 2,000,000 2,000,000 i 2,000,000 2,000,000 613 11 Deposits to Improvement Reserve 0 € 0 0 0 0T 0 ` 0 p° R — .. 614 0-3 ! 12 1 Issuance Costs c 552 00 988,300 I 0r S) � >2 0� 0` 0= 0 615 G-131 13 1 Revenue Bond Reserve Fund (d) � 1,742,200 3,579,3001 0' 0 I 0 0 C 0 617 14 jTotal Application of Funds ! 161,782,400 I 137,670,600': 275,807,000 239,428,000 ; 263,630,000 I 236,013,000 I 346,165,000 618 i Ii L 619 15 End of Year Fund Balanee i- 8,668,600 4,050,6001 4,519,700 92,794,900 146,535,900 222,812,100' 177,699,400 620 I ! L 1 1 I I i 621 (a) , Includes anticipated contributions from the City_of Arnold to reserve capacifin the Lower Meramec River Wastewater Treatment Plant. 622 (b) I Interest income is estimated at 1% of the average of the beginningand end of year balances. 1 (— I 623 i (c) i Issuance Costs are estimated at 1.40% of the issue amount for Revenue Bonds, 0.65% of the issue amount for SRF Loans, and $25,000 per issue for commercial Pape 624 (d) The required balance in the Revenue Bond Reserve Fund is determined to be the maximum principal and interest payment on senior debt. T 625 I L L ! I I 626 mm Su ary of Financing Available for the Five -Year Std Period 1 627 _ _ 1 I Debt I L 122,157,300: 9.4%;Net of issuance costs and bond reserve requirements T- 628 1 :Cash Financierfrom Revenues i 1,287,725,000 ; 99.3% Net of Improvement Fund Projects 629 LGrants, Interest & Misc. Revenue I 16,156,5001 1.2% I 630 — :Use of Fund Balance j i 129,834,800 -10.0° - 1 632 Total Major Capital Improvements —I 1,296,204,0001 100.0%I ( r L 633 1 1 i 1,296,20440001 Check I '4^ i1•fl28 ' Al 0R4 vr'ft?taa k0o tgtaa27,2488 84.4 am. (,.I1 1x51; €p• 1_. L' XFerl15 652 .__ _._ Table 3-11 653 Comparison of ProJcted Wastewater Revenue Under Existing --- Rates With Projected Revenue Requirements 654 655 - i - L_ f t 5t Line 1 Fiscal Year Ending June 30, 658 , No. lDescri lion j -�----�-----.. ------ 2011 2012 2013 2014 1 2015 2016 660. 1 I 4_. $ $ --�- __`_$ j__ 1 $ I 8 I 8 661 1 L 's I 1 i 662 k -d$ t 1 Revenue Under Existing Rates (a) 795,600 i 212,030,000 211,019,700 t _210 681,8001- 210,501 ' 210A31,800 663 l Additional Revenue Required ___i__213 i j i 1 1" 664 Fiscal 4- Revenue ! Months j - i (- 665 i----_Year '- Increase Effective I 667 l t 2011 0.0% 12 i 0 1 0' 0; 0' 0 668 G-7 ' 2 2012 ' 4.3% I 12 ! 8 357,50 9,073,800 1 9 059,30 i 9,051,600 ; 9,048,600 669 G-7 i 3 2013 1 144.0% T (- 252,491,30 316,156,90 i 316,051,800 670 ': G-7 , 4 2014 0,0°/ --...-----:.-.__...--- 2 _ i2 _ �- . ., i--2 ---_._.._�_.------i 1 _316,427,20 ._------------- _..-... _..0 : 0 671 - i G-7 5 . 2016 0.0% 12 _-..-j.------.__,_-_-, 672 G-7 ! 6 _.. . i 674 : 7 Total Additional Revenue T 0 ` ,8,357,50: _261,565,10 I 0 325,486,50 325,208,50 325,100,400 676 i 8 Total Service Charge Revenue ',,,,,_213,795,600 _ 220 387 500_,, 1 536,168,300 535 710,30 L 20 677 Ad Valorem Tax Revenue KGO _472,584,890 _535,532 Bonds) _ 01 0 0 0 0 ' 0 678 9 _Other O�eratmg_Revenue _ (750,50) 3,382,40 (5,856,50)1"- (7,945 00l� (7,767,10) 679 B-19 . 10 :Connection Fee Revenue .(7,858,300) f i 1,25090 1,288,000 1, 132700 1367000 1,408,000_,. 1,450000 680 0.13 11 Interest Income -Reserve Funds -. 888,80 964,30 X03,70; 1,020,001)1 1,038,600 1,057,000 681 12 ilnteresthicome - Operations _-_-- r,.._ , 3080; 47,30 _ , 50,000 50,100 j 50,20: 50,30 682 13 flnterest income - Amold j 650,700 i 631,000 610,50 , 589,10 I_ 566,800 ' 543,600 684 14 Subtotal Other Revenue ! 2 069 80__' 6,313,-00 i (2,865,300)] (4,918,80 14,794,70)1 14x666,20) 686 1 15 rTotal Revenue i 215,865,40 ! 226,70,50 ' 469,719,50 I 531,349,50 1 530,915,601 530866,00 687 688 a,2.1 l6 f Operation and Maintenance Else 134,394,80 138 803 800 ! 145,469,00 ' 15,997 156,751,70_1 162,141,600 689 17 =AdditionalO&MSb) 1 1 0I OT ,70 112,401 2,159,800 7,484,101 7,942,500 690 G-1,2 Stormwater Program Supporter 1 ,0 0 0 0 '..0 0 18 Net _ _ ; 81,470,60: 87,89870 L 324,138,I0 ! 377,11800 -366,679,80 '1 360,781,900 693692 1 l 694 Debt Service 1- 695 -1 19 j Existing Senior Revenue Bonds i 19,290,60 19,415,20 19,559,800 1 %68 0 6,0 19,834,401 19,973,200 696 �-3 I 20 _i Proposed Senior Revenue Bonds I 01 3,281,00 I 3,,577 0 r 3,579,30 3,579304 3,579,300 697 ! Application of Bond Reserves ! 0 I 0 1 0. 0 I 0 t 0 699 21 I Total Senior Revenue Bonds 19,290,60 1 22,-696,20 23,130,10 f 23,265,300 + 23,413.770 i 23,552,500 700 G-1 22 ; Existing State Revolving Fund Loans (0_ I 19,113,700 ' 21,311,10 21,401,300 1 21,483,500 i 21,355,60 21,_72160 701 23 Proposed State Revolving Fund Loans (e) 0 I 1,711,000-r 2,565,80 2,565,800 2,565,800 i 2 565,80 703 24 Total State Revolving Fund Loans 1 19,113,70 ' 23,022,10] 23,967,10 L 24,049,300 0 23921,4 , 24,294,40 704 G-9 25 Commercial Papa 0, 0 i 0 1 0 0 i 0 705 r General Obligation Bonds 0 '. 01 0 0 0 706 i Short-tenn Debt Service 01 0 i-- 708 26 Total Debt Service 1 38,404,300 r 45,718,300 j 47,097,20 r 47,314,60 ' 47,335,100 X47,846 90 709 i 710 D-25 27 1 Routine Annual Improvements i 2,378,600T 2,461,90 2,535 7000 i 2,611,800 2,690,10 ! 2,770,90 711 G-7 28 'Cash Financing of Major Improvements .l 37,250,000 1 38,438,000 ', 273,377,000 ; 325,767,000 I 314,958,000 309,200,000 712 G-13_29 _,Additions to Operating Reserve 674,500 73 500 's 1,126,200 r 1,41800 1,673,900 ; 974,600 713 _i i 714 30 i Net Annual Balanc jdi 2,763,20 's 540,00. 2,00 ' 6,600 ° 22,700: (10,50_0) 715 J j -r 1 716 -: 31.__'Begirming of Year Balance_(e)__ 1,6966 90 ' 4,46010 y- _ 5,00,10 _ 5 002 100 ; 5,08,70 i 5,031 400 717 ` 32 End of Year Balance (e) i i 4,460-,10 7 5,000 ,1 5,002,100 5,008,700 i t_.__. r..__ . 5 031,40 5,020,90 718 719 E , Actual Debt Service (f) �-- - - ------1___. ; - .._..---------- ! -`----... 1- --- --- ------ 720 33 i Senior Bonds 19, 770, 300? 20, 823, 001 23,108, 100 i 23,240,200; 21391,10 23,526,50 721 34 SRF Loans = . Service Covers a 18192,60' 20,732 6023 --_-- ' 961 0 ,0+ 23,911300 1 24,I 11,70 j 23,8900 722 - 'Debt ,4 723 i 35 j Revenue Bonds (g) 4.23 xi 4.22 xi 14.03 x f_,-- 16.23 x 15.68 x i 15.34 x 724 ; 36 Total Debt h 2.17 x 2.12 x' 6.89 x. 8.0 x; 7.72 xi 7.61 x under existing wastewater 726 _ (a)_ 'Revenue rates effective July 1_, 2010 1 727 - Jb) O&M costs related to anticipated regutatoryprojects. These projects include imp Loved disinfection at the Missouri River WWTP 728 Fm. 2013 and 2014; ex_pansion of the Missouri River W WTP in 2015; and Capacity, Management, Operation, and Maintenance CMOM 729 i :program activities related to anticipated Consent Decree requirements in 201611 - - _- f 730 Y(c) iDebt service on State Revolving Fund (SRF) Loans are net of the state's interest subsidy. 731 t (d) Negative balances indicate need to drawdown available fiend balance. 732 '. (e) Does not include funds set aside - for a minimum opexating_reserve equal to 60 days of operating expenses. 733 (f) IPa ment to Bondholders per Table 3-10,"paid through Sinking Fund. --_y_-._...---..-1----.___-.., _-,--_ 734 ..__ (g) ,The Bond Ordinance requires net revenue to equal or exceed 1.25x actual senior lien debt service. r 735 , 1112_, The Bond Ordinance requires net revenue to equator exceed 1.15x total actual debt service. . 736 737 Interest Income - Reserve Funds w/o new bonds 888,800 ' 918,90 931,_0 , 947-500 966,10 984,500 738 r Current Accrued Senior Revenue Bonds ,_, . Only_._- 0 Q_...._-.-_. 0�__......._. 1.00% 739 Actual Senior Debt Service w/ Current ._.-..,_ - _.0 ,_,. _____. 0 ._. Bonds 19,270,30: 19,392,400 19,528,800 E 19,660,90 19,811,80: 19,947,20 740 Existing SRF Actual Debt Service 18,292,60: 20,232,60 21 395,20 21,345,500, 2 1545 90 1 _ . 21,324,60 _ .; r_- ' 741 742 Cumulative Revenue increase 000°/ 4.309'° 154.49% 154.49%; 154.49% 154.49% 743 'Full Year Additional Wastewater Sales 0 9,117,300 326,008 60 325,486,50 325,208,40 325,10,30_ 744 ' Difference of Full Year less Additional Revenue 0 759,800 64,443,500 1 0 L (10)1 (100) A l 13 [ CI D 1 E F 1 G . H 1 I 7 K 1 L 753 Hike :20 4YGO to t� � ��` �# �► S: ` RA�'L'- Fqr. ' te' tnissio Ike ievr' SWCE «:St4rntw ateC sb.. ow `, �_ .:: ...; .. .., .. _. i:.' � >�i ,� .3u+te27;•201�;� 10:04:a .m: , .. . .., .,:..,. ,. G:I2 754 755 Inp ut Reference BD -5 I � X XFer133 756 1- 757 Table 46 _ __ . . .._. _. 758 Comparison of Proje cted St ormwater Re venue Under Existing 759 _ Rates and Taxes With Pr ojected Revenue Requirements 760 1 761 Line J. Test Year 762 No. 2011 2012 2013 2014 2015 2016 . 764 . .. _-$ {, $ $ $ $ $ 765 766 Stormwater Operati ons Stormwater User Charge Reven ue - -- 767 C-19 1 j Flat Rate 1,181900 1,356,100 1,353,600 1,352,200 1,351,100 1,350,300 768 769 2 Impervious A rea Charges 3,625,300 0 4_ 0- 0 0 0 Ad Valorem Taxes 770 C-19 3 D istrict -Wide 4,903,100 4,948,100 4,993,100 5,038,100 5,083,100 5,128,100 771 C-19 4 Stormwater O&M 9,911,700 10,003,200 10,094,700 10,186,200 10,277,700 10,369,200 772 773 C-22 5 Other Revenue 469,400 481,300 494,200 507,900 521,900 536,400 G-13 6 Interest Income -Reserve Fun ds 41,500 I 45,000 I 45,200 45,800 46,400 46,800 774 7 7 Interest In come -O perations Interfun d Reven ue -___T p 93,100 94,500 1 79,500 , 64,000 0 46,300 0 28,200 0 775 776 Wastewater Support 0 0' 0 0 0 0 778 _ 8 Total Stormwater Operating Revenu e 20,226,000 16,928,200 17,060,300 17,194,200 17,326,500 17,459,000 779 J 1 780 E-22 9 O ep ation and Maintenance Wense 17,738,300 17,720,700 17,887,200 18,239 600 18,532,600 18,609,200 G -I Debt Service i 0 0 0 0 0 0 781 782 E-22 10 Rou tin e Annu al Improvements __ _... 526,300 544,700 561,000 --1 . 577,800 - 595,200 613,000 783 E.-1 11 Cash Financing of Major Improvements 0 0 0 0 0 0 784 G-13 12 Additio ns toOperati Reserve _ 90,100 _ 100 30,100 60,700 ' .i .,0-6-6 _ 15,500 785 13 Tran sfer to Stormwater Eme e»Fu nd _ 250,000 787 14 Tota l Rev enue Reuiremen ts 18,354,700 18,515,500 18,478,300 18,878,100 19,178,800 19,237,700 788 789 790 15 N et Ann ual Balan ce 1,871,300 (1,587,300) (1,418,000) (1,683,900) (1,852,300) (1,778,700) 16 jBeginnin g of Year Balance 8,376,800 10,248,100 8,660,800 7,242,800 5,558,900 3,706,600 I 17 End of Year Balan ce 10,248,100 8,660,800 7,242,800 5,558,900 3,706,600 1,927,900 791 , 792 OMCI Subdistricts 793 794 18 OMCI Rev enue Under Existing Rates 10,410,000 9,936,000 ' 10,035,000 10,239,000 10,264,000 10,289,000 ' 19 Interest In come 425,300 427,800 456,900 544,600 653,100 762,900 795 796 - 20 OM CI Ex istin g Major Improv ements 9,400,000 11L 308,000 3,730,000 0 0 0 In terfund Operations Transfers 0 0 0 0 0 0 797 21 Net Annual Balan ce 1,435,300 (944,200) 6,761, 900 10,783 ,600 10,917,100 11,051,900 798 1 22 BegjnningofYear Balance BD -5 41x8)4,3.Q0_ • 43,249,400 42,305,200 49,067,100 59,850,700 I 70,767,800 799 800 j 23 En d of Year Balance i 43,249,400 42,305,200 49,067,100 59,850,700 I 70,767,800 81,819,700 f 801 t{ 13 J C B I E F G 1---1-1-1--11-11-1-7-.1-1 K r, L J M 8#73 FLte i Y2fl13PA (GR t DRAFT.. For Raw Certn!Ab20011 Review ig R low Foods ,1w a 27.2011 10:44 HAW G- 14 804 R 805 Ttnpu� i lieference 11th, ED- was Sl and 2 # , _ : 3 806 i 1 Line'-.--- - .3..3....3.3__.- 7_. __ -----_ ._ Fiscal Year Ending June 30, --- -_ 2017 2018 Si18 __ L No. 'Fund Description L - _i 2011 2012 ! 2013 2014 ; ._._ ;, _ .. .._ .3.3..3..3.--_ j 2015 2016 _, 810 _,_. - $ T$ 30,691,100 $ i $ .. Y S ... $ -- --- - $ $ 812 1 1 Beginning of Year Balance:: 32,433,300 I 3,579,300 36.012,600 36.012,600 36.012,600 ...._ 0 4 813 2 Additioas 1.742,200 0 0 - .-_- �.-.... 0 p4_ 814 3 1 End of Year Balance 32,433,300 I 36,012,600 j 36,012,600 ; 1 36_,012,600 ! 36,012,600 1 36.012,600. i 36,012,600 1 432,200 i - 432,200 36,012,600 432,200 815 y 4 ' Interest Income 378,700 1 410,700 432,200 432.200 i 432,2001 816 Wastewater Operating Reserve i 60'days of next year's Operating requirements f j 817 G-8 1 5 + Beginning of Year Balanced 21,808,800: 22.483,300 i 23,221,800 ' 24.348,000: 25,766,000 I 27,439,900 1 28,414,500 4 29,920,600 818 6 Additions I End of Year Balance j 674,500 1 738,500: 23,221 800 274,200 23,221,800�L . days of next year's ! 3,002,400 . 100 3 002_500 1 36.0001. 3002 500 daysofnextyear'sOperatingre r 25.485,700 738,600. 1,126,200 I 24,348,000 Tr --__ .3.3.3.3-285,400 24,348.000 Operatinirequirements 3,002 500 30 100 3,032 600 36,200,1 3,032.600 ; 26,224,300. ' 1,418,000 L, 25.766,000 i _--_ 300,700 r- 25,766,000 i 1 3032,600 60 7000 1,673,900 1 27,439,900 1 , 319,200 I 27,439,900 r 3,093,300 - 51.000 • 3,144,300: 37,400 r 3 144,300 - 974,600 I 1,506,100 1 ,500 C 29,920 28,414 ,600 335,100 350,000 1.208,600_ 31,129,200 366300 31,129,200 3.331.300 93,300 3,453,200 40 700 3 331 300 - 0 33,158,600 1,301.900 819 ; 7 22,483,300 265,800 820 . 8 ; Interest Income __ 821 .3..3.3.3..._ 60 days of next year's Operating requiremen 22,483,300 60 2,912,300 90,100 - . 3.002,400 35.500 3.002 400 I . . `,._. . 60 24,721,100 - 28,414,500. - _ 3,144`30D 15 500 3 159 800 37,800 3,159,800: i 29,920,600 ; 00. 3,159,800 ' ' 78,200 _. - 3 331.300 ' 1 38,9007 3,238,000_4 __.. r a- ' : 1,584,3001 ' 823 Stormwater O t�er Reserve ating Res „ - _r_ B innin�of Year Balance ( Additions 824 9 825 10 826 I 11 J__ End of Year Balance 1 Interest Income t ` 60 days of next year's Operating requirement Total O Operating Reserve r- - : pe SR Being of Year Balance : _A_dditions 1 _ 3 093 300r 36.800 i ' 3093,300 uirements � 27,380,600 827 _.. . 1 12 828 829 830 831 13 -._ 31,574,300.._._ 28,859,3ti0 T 1,724,9001 30 584 200 990,100 832 14_ 764600; 25,485 700 4ti3O% 38,404300 15,361,700 1,156,300 ( 1 1,478,700: 833 15 End of Year Balance t 26,224,300-1 27,380,600 to earn 28,859,300 i 30,584,200 ; 31,574,300 I 33,158,600 1 34,460.500 834 1 i Principal and Interest Account rolling level of funds available interest income ! 835 i 16 r Total Annual Debt Service ! 3 45,718,3007 18,287.300 47,097,200 47,314,600 I 47,335.100 1 18,925.800 1 18,934,000 I 47,846,900 ( 47.923300 ; 19,138,800+ 19,169,500 1 48,113,200 836 4 17 i Average Balance Available ; 18,838,900 19,245,300 837 : 18 -t Interest Income 1 184.300 t 219,400 1 226,100 227,100 f 227.200_41 229,700 + 230,000 230,900 838 _ General Fund Reserve for Wastewater Encumbrances ; Average Balance Available I 839 - 19 5,000,0001 5.000,000 60.000 r 60,000 ; 5,000,000- I 5,000,000 ; 5,000,000 5.000,000 5,0.00,000 1 60,000 60,000: 5.000,000 60.000 840 I 20 r1 Interest Income f L 60.000 60,000 ; 60,000 841 1 21 a I ' Interest Income to W W Operating Fund '� $ 1 888,800 964,300 � 1,003,700 ; 1.020,000 - 1,038,600 i 1,057,000 1� 1,072,200 1 1.089.400 842 General Fund Reserve for Stormwater Encumbrances Average Balance Available 8 � and 500,000 = ._ 0 6,000 ' Emergenc rLReserve 1 i 843 _ 22 750,000 ( 750,000 ' 750,000 ; 750,000 , 750,000 ; 750,000 750,000 844 1 'Deposit to Emergency Reserves 1 r- 250,000 1 0.i_-_ 9,000 ; _._ 0 _- 9.000: 0 r 0 0 o 845 23 1 Interest Income . 9,000 1 9.000 I 9,000 _ 9,000 1 9.000 846 ; 24 1 Interest Income to SW Operating Fund j 41,500 , 45,000 54,000,000' 6,073,300 I 0 L 45,200 1 minimum requirement 45,800 1 46,40T1jj 46,800 47,900 ! 49,700 847 L ! Emergency g Y Reserve � - 1 848 849 G-8 22 . Beginning of Year Balance 1 6,073,300 ' - 0: 6.073,300 I Y 72,900 ' 178,998,200' `. 2,148_000: 6.073_300 0 I 6,073,300E 0 ;; 6,073,300 0 : 6.073,300 0 6,073,300 1 0- 6,073,300 0 23 i Additions ' 850 - . 24 : End of Year Balance 1 ! --'- - 6. 073,301 6,073,300 1 6.073300 1 6,073,300 1 -�- ---- - 72,900 ! 50.000,000 600,00 0 6,073,300 72,900 - - 50,000,000 600,000 6,073300 I 72,900 6,073,300_ 72,900 50,000,000 60 0 0,00 .. 851 _1 25 Interest Income ; - - _. _...-._-...._-....3..3.3..3. r- 72,900 ' 72,900 72,900 i 852 '_ `Reserve for Capital Improvement Encumbrances ' Beginning of Year Balance ; Interest Income i-.-.3..3..3.3 - ' - ' 50,000;000 600,000: 853 ; 26 1 27 _ 143,198,560 107,398,920 1,718,400 : ; - 1,288,800 � i ' 71,599,280_ 859,200: .1 854 855 1 B C D E F G H .. I 858 859 860 File: FY2013PAY URate . 1i F • r tc a l lu Review Ver la I G-11 j i ;XFer9 !XFer114 861 Table 3-10 862 Projected Wastewater Debt Service Requirements 863 i T 864 Existing L Proposed r Existing f Proposed i Commercial --- Fiscal I 865 -r- Revenue f Revenue SRF SRF Paper 866 Year 4__ Bonds Bonds 1 Loans Loans Notes Total r! I 868 $ 1-• $— - ; $ — t $ $ $ .. __.._.. 869 870 Payments to Sinking Fund 871 ; 2011 19 290,600 0 ! 19,113,700 ' CT -IL 07 38,404,300 872 2012 19,415,200 3,281,000 , 21,311,100 I 1,711,000 0 1 45,718,300 873 I 2013 - 19 550,800 3,579,300 1- 21,401,300 I 2,565,800 I 0 I 47,097,200 874 2014 19,686 000 ! ._._ 3,579,300 21,483,500t 2,565,800 .... . .... . . .... 0 � 477 314 600 875 2015 ! 19,834,400 ' 3,579,300 21,355,600 ' 2,565 800 0 47,335,100 876 2016 19,973,200 1 3,579,300-[ 21,728,600 I 2,565,800 0 47,846,900 877 j 2017 20,128,800 j 3,579 300 21 649,800 I 2,565,800 1 0 I 47 923 700 878 2018 20,290,400 j 3,579,300 21,677,700 I 2,565,800 0 ` 48,113,200 879 2019 20,480,700 ' 29,274,600 21,698,300 I 2,565,800 0 I 74,019,400 880 2020 20,649,100 61,475,100_4 21,713,900 2,565,800 0 [ 106,403,900 881 I 1 2021 20,816,900 f 61,475,100 ; 21,829,100 '; 4,062,500 0 I 108,183,600 882 T 2022 20,997,500) 93,350,300 21,839,800 ' 6,307,600 0 E 142,495,200 883 2023 21,191,600+ 93,350,3001 21,754,400+ 8,552,700 0I 144,849,000 884 , i 2024--L 21,383,000 I 107,011,100 21,753,900 10,797,800 0 ! 160,945,800 885 2025 22,108,500 114,817,300 I 20,038,000 13,042,900 0 i 170,006,700 886 2026 25,571,900 123,599,200 T 14,954,400 I 15,288,000 0 1 179,413,500 887 , 2027 28,951,200 j 137,585,300 8,026,200 17,533,100 0 192,095,800 888 I 2028 29,783,600 151,246,100 6,868,400 19,778,200:. 0I 207,676,300 889 ! I 2029 30,221,900 151,246,100 { 5,635,500 22,023,300 € 0 209,126,800 890 L 2030 _I 32,405,500 j 151,246,100 j 3,659,300 ' 22,771,700 01 10,082,600 891 I 1 I j I 892 I Payments to Bondholders 893 2011 j 19,270,300 ; 0 18,292,600 ! 0 0 1 37,562,900 894 4 2012 1 19,392,400E 1,430,600 20,232,600 500,000 0 ; 41,555,600 895 ! 2013 1 19,528,800 3,579,300 21,395,200 ! 2,565,800 ; 0 47,069,100 896 . 2014 } 19,660,900 ! 3,579,300 21,345,500 2,565,800 0 i 47,151,500 897 2015 ' 19,811,800 I 3,5_79_,300_ 21,545,900 2,565,800 , 0 ':. 47,502,800 898 I 2016 ! 19,947,200 3,579,300 21,324,600 , 2,565,800 0 47,416,900 A B C D E F � G B I J K 915 F r AYGORnf a, DRA d Fps ar n lss(ua e e des _ 916 eCJ -Gam 'i etl ash Fla raga June 27 10;04 a m 1 917 1 - L 918 Combined Wastewater Cash Flow Summary Table 419 r 1- —4 _--... -I-- — — 1_920 Year Ending June Line _._._ __ — Fiscal 30, f 922 No. !Descrip_tion 1 2011 2012 ` 2013 1 2014 2015 2016 924 i i $ $ s s $ $ -I 925 __ ;Source of Funds 1 926 G-1144 1 Service Charge Revenue ' 213,795,600--ji 220,387,500 472,584,800 i 536,168,300 1 535,710,300 ! 535,532,200 927 G-11 i 2 1 Other Operating Revenue i (750,500)1 3,382,400 (5,856,500)1 (7,945,00)1 (7,858,300);_ (7,767,100) 928 G-11 3 Interest Income (a} 4,339,2001 3,763,400 3,068,400 i 3,079,100 ` 3,530,000 ! 4,178,200 929 G -I 1 4 41. Connection Fee Revenue + 1,250,000 ! 1,288,000 1 1,327,000 1 1,367,000_1 1,408,000 1 1,450,000 930 G-10 1 5 1 Revenue Bond Proceeds 1 r 0 1 52,020,000 0 f 0 0! 0 93I G-10 ! 6 ! State Revolving Fund Proceeds _ ! 37,000,000 1 39,999,300 0 ( 0 I, 0 0 932 G-101 7 1 Grants 454,800 474,500 1,494,900 1. 516,300 " 538,600 561,900 934 I 8 `Total Funds Available ' 256,089,100 ' 321,315,100 472,618 600* 533,185 700 ' 533 328,600 r 533,955,200 935 ' ;Application of Funds 1 936 G-11 ' 9 11 Operation and Maintenance E pense 134,394,800 138,803,800 145,582 400 L154,131,500_, 164,235,800 ; 170,084,100 937 G-11 i 10 . Debt Service 1 38,404,300 ': 45,718,300 47,097,200 1 47,314,600 r 47,335,100 47,846,900 938 G-111 11 I Routine Annual Improvements 2,378 600 1 2,461,900 2,535,700 1— 2,611,800 2,690,100 2,770,900 939 G-11 r 12 1 Additions to Working Capital Reserve 674,500 738,500 1 1,126,200 1,418,000 1,673,900 974,600 940 G-101 13 1 Major Capital Improvements 158,223,000 131,103,000 273,807,000 237,428,000 261,630,000 234,013,000 941 G-10 1 14 + Improvement Fund Projects ` 1 1,265,000 1 2,000,000 2,000,000 ! 2,000,000 2,000,000 ! 2,000,000 942 G-10 i 15 1 Issuance Costs 552,200 1 988,300 0 0 0 0 943 G-10 ; 16 _ I Revenue Bond Reserve Fund 1,742,200 3,579,300 0 1 0 0 0 945 — I7 !Total Application of Funds 1 337,634,600 i 325,393,100T 472,147,5007 444,903,900 479,564,900 457,689,500 946 1 1 i 947 l 18 [Net Annual Balance 1 (81,545,500)1 (4,078,000)r 471,100. 88,281,800 1 53,763,700 76,265,700 948 1 949 19 1Beginning of Year Balance 94,674,200 1 13,128,700 ' 9,050,700 = 9,521,800 97,803,600 151,567,300 950 20 LEnd of Year Balance 13,128,700 j 9,050,700 I 9,521,800 97,803,600 151,567,300 227,833,000 951 1 d__. 1 952 ( (a) 1Includes interest earnings on the Capital Fund, g p Emergency Reserve, g y Operating Fund, Bond Reserve, Operating Reserve, r 953 I 'Principal and Interest Account, General Fund Reserve for Encumbrances, and Reserve for Capital Improvement Encumbrances) 954 I Check:1 0 0 1 0 1 0 1 0 j 0 13 C D E F G H 1 1 J K 955 Fii YO Rates, M- Fund Balance Summaev D - Fir R to C itt vl Veat l uue 27 201 10:04 a m O-Ife 956 957 Input ' Reference BD -6 ] , ( 1 958 _ Wastewater Fund Balance Summary Table 959 - - ;Line No. t 1 960 i. _. - ; Fiscal Year End June 30, 962 Fund Description 2011 2012 2013 �_ 2014 2015 2016 964 L____ _ _ - __.-- -L----.__ .i_____ $ $ j -- . __ i------- --- 965 �. _ 966 G-111 :Operating Fund (a) i 1 ; 967 F _Beginning Balance I - 1 1,696,900 - 4,460,100 ! 5,000,100 i — 1- 5,002,100 1 5,008,700 1 5,031,400 968 t- _-----' - 6,600: 22,700 ! 2,763,200 540,000 j 2,000 1 (10,500) 970 Ending Balance I 4,460,100 5,000,100 5,002,100 5,008,700 lam- 5,031,400! 5,020,900 971 1 . i : 1 L_, LBond Reserve 1----- 972 G-13 973 Beginning Balance 30,691,I00 32,433,300 1 36,012,600 I 36,012,600_ : 36,012,600 ; 36,012,600 974 Deposit from Bond Sale + 1,742,200 3,579,300 _ 0_T 0 ; 0 •, 0 976 Ending Balance 32,433,300 I 36,012,600 I 36,012,600: 36,012,600 I _ 36,012,600 j 36,012,600 ._ . - .._ . _ . . . . . . . 9 ..- 978 G 10' Capital Funds (b) _..... .. .._.._ ... . 979 I Beginning Balance 92,977,300 I 8,668,600 i 4,050,600_1 4,519,700 92,794,900 ' 146,535,900 980 j ' Sources of Funds I 77,473,700 i 133,052,600 1 276,276,100 1 327,703,200 317,371,000 312,289,200 981 I I ApplicationofFunds ' (161,782,400)1 (137,670,600) (275,807,000)1 (239,428,000), (263,630,000) (236,013,000) 983 I 1 Ending Balance 8,668,600 I 4,050,600 4,519,700 11 92,794,900 146,535,900 222,812,100 984 1 1 1 1 l 985 G-131 Emergency Fund j ! T L 986 i_ Beginning Balance 1- - ~ 6,073,300 1 6,073,300 6,073,300 6,073,300 ( 6,073,300 6,073,300 987 ' j Additions i_ j 0 - 0 0 j 0 0` 0 989 Ending Balance - - - 6,073,300 j 6,073,300 ; 6,073,300 6,073,300 ; 6,073,300 1 6,073,300 990 I 1 r -Operating 1- 991 G-13 1 Reserve 1 G 992 1 Beginning Balance 7 21,808,800 22,483,300 23,221,800 1 24,348,000 25,766,000 27,439,900_ 993 I -j : Additions I l _ 674,500: 738,500 1 1,126,200 ' 1,418,000 , 1,673,900 974,600 995 T Endin Balance 22,48- 3,3001 23,221,800 L 24,348,000 ! 25,766,000 27,439,900 28,414,500 996 ; 1 1 I 1 1 I 997 G-13 1 Principal and Interest Account 1 rt 998 L Average Balance Available ,,1 1 15,361,700 18,287,300 L 18,838,900: 18,925,800 18,934,000 I 19,138,800 999 -1 Recommended/Required EndingzBalance i 1 1000 1 ( i 1001 Stormwater OMCI Funds j r 1002 ! Average Balance Available 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 1003 I 1i ----_. --I- ; I i 1004 ;All Funds i : ------.�.__ 1005 , + Total Beginning Balance - 193,609,100 117,405,900 118,197,300 I 119,881,500 209,589,500 ' 265,231,900 1006 114,480,300 j - - I Total Ending Balance : -- 117,645,700 I 119,794,600: 209,581,300 265,027,100 ' 342,472,200 — _ ,._ - --- IL 1007 — 1008 G-13 i :General Fund Reserve for Encumbrances 1009 Average Balance Available W-...5,000,000 5,000,000 - 5,000,000 ' 5,000,000 ^ 5,000,000 r 5,000,000 I010 - --- 1011 GG=13 Reserve for Capital Improvement Encumbrances 1012 ; Beginning of Year Balance 178,998,200 i 143,198,560_1 107,398,9201 71,599,280 I _ 50,000,000. 50,000,000 - ..... 1013 1014 (a) i Consists of the General Fund, Oprating Funds, and the WBU Fund. 1 1015 ' (b)__,: Consists of the Construction Funds, and the Special Funds excluding the WBU Fund and the Emergency Fund_: 1016 I .__. A B C D E F G 1-I' 1 j Mr _ File: FY2t113P�sYt;t}Rntcs DRAF[ a FAr ate onntnissieu:Revie v Yer la 1018. COQ = Revenue Ri!ri4 Coversee labia ' June 2 2Q11 ` 10:04 a.rg. G-17 1019 2010 revenue increase: 9.0% Xfer 11 for Bonds -� 1020 1021 Table 14 1022 Debt Service Coverage Under Indicated Revenue Levels - . - 1023 - - - 1025 ,___ _ l Line . __.._---_ Y_-_ -_-___._ - Fiscal Year Endiug June 30, 1027 Ref. ; No. Description r - ._ T 20I1 2012 2013 2014 2015 1029 1030 LRate Covenant Coverage j _: i I 1 1031 G_1_ l I 1 Projected Actual Net Revenue (a1 8.1,470,600 ` 87,896,700 I 324,138,100 377,118,000 j 366,679,800 1032 Projected Actual Debt Service 1033 ! -111-r Becoming Due in Each_Fiscal Year (b) 1034 di 2 i Senior Lien Bonds 1 I 19,270,300 1 20,823,000 i 23,108,100: 23,240,200' 23,391,100 1035 G-11 i 3 Total Debt c ( ) ! 37,562,900 41,555,600 47,069,100 47,151,500 47,502,800 1036 ; Projected Actual Net Revenue as a j 1037 L Percent of Debt Service 1038 i 4 . Senior Bonds(d)__ 4.23 x 4.22 x 14.03 x, 16.23 x' 15.68 x 1039 5 i Total Debte) r 2.17x. 2.12 xi;, 6.89 xr 8.00x! 7.72 x I 1040 Additional Pari e Bond Covers _-! 1 1041 ; Projected Maximum Annual Debt Service (f) .___. ___ _L____.___. I 1042 G-3 r 6 ! Senior Bonds Only 32,433,300 36,012,6007- 36,012,600 I 36,012,600 j 36,012,600 1043 1 7 All Senior and Subordinate Bonds 43,232,200 j 49,377,300 49,377,300 __E I _49,377,300_4_49,377,300.j 1044 Preceding Year Test G 1 1045 8 Net Revenue for Prior Fiscal Year 58,614,700 I 81,470,600 i 87,896,700j 324,138,100, 377,118,000 1046 I 9 Net Revenue Adjustment (g) 18,591,700' 9,193,200 ! 318,452,100 1 0 0 1048 10 Adjusted Net Revenue 77,206,400 , 90,663,800 406,348,8001 324,138,100 , 377,118,000 1049 I 1 Adjusted Net Revenue for Preceding 1050 Year as a Percent of Debt Service I 1 E 1051 1 11 Senior Bonds (h) 2.38 xi 2.52 xi 11.28 xj 9.00 xi- 10.47 x 1052 I 12 Total Debt (i) 1.79 x' 1.84 x 8.23 x# 6.56 x 7.64 x i 1 f 1053 'Ensuing Year Test I _ 1054 13 ; Net Revenue for Ensuing Fiscal Year I- 87,896,700 ; 324,138,1001 377,118,000 366,679,8001 360,781,900 1055 G_ -I 1 : 14 L Net Revenue Adjustment (j (8,357,500)t (252,491,300)1 0 j 0 0 1057 f 15 I Adjusted Net Revenue j 79,539,200 71,6.46 ,800 377,118,000 j 366,679,8.00 360,781,900 1058 i _ Projected Actual Net Revenue for Ensuing j I ! 1059 1 Fiscal Year as a Percent of Debt Service i 1060 _ - j 16 Senior Bonds (k) _^ -j_--__ r 2.45 x 1.99 x 10.47 x; 10.18 xT_ 10.02 x 106I i 17 i Total Debt (1) 1.84 xi 1.45 x 7.64 xi 7.43 x! 7,31 x 1062 -ri , 1063 ___. �i.__ I (a) ;Net revenue as shown on Line 18 of Table 11. Includes the impact of adopted i _s_____ J_.-.. rate increases each year, which will be fully_ . 1064 operative in the years indicated by Table 11. " 1065 (b) : Projected actual ofprincipal and interest from the Sinking Fund to bondholders. -- Sinking debt obligations,. - ----<---- 1066 -payments � c :Includes , �) _-__.___senior revenue bond and subordinate 1067 ? (d) [Line 1 / Line 2. The Bond Ordinance requires __ -; net revenue to equal or exceed 1.25x actual debt service. 1068 ' (e) Line 1 / Line 3. The Bond Ordinance requires net revenue to equal or exceed 1.15x actual debt service. 1069 (f) ilVfaximum future debt service for all series of revenue bonds issued in.previous years or during the current fiscal year. 10701 (g) I Adjustment for revenue increases to be fully_operative July 1 of the current fiscal year as permitted by_the Bond Ordinance. 1071 ; (h) 'Line 10 / Line 6. The Bond Ordinance requires adjusted net revenue for the preceding fiscalyear to equal or exceed 1.25x 1072 the maximum annual debt service on all then outstanding senior lien revenue bonds. 1073 ; (i) . Line 10 / Line 7. The Bond Ordinance requires adjusted net revenue for the.precedingliscal - year to equal or • 1074 exceed 1.15x the maximum annual debt service on all then outstanding debt obliations. _ - 1075 - (j) 'A4ustment for revenue increases not for the ensuing year coverage test unless already authorized 1076 -permitted by the Board., _.. _ 1077 (k) Line 15 - Line 6. The Bond Ordinance requires net revenue for the ensuing three fiscal years to equal or exceed 1.25x 1078 ; the maximum annual debt service on all then outstanding senior lien revenue bonds. _ 1079 ' (1) 'Line 15 / Line 7. The Bond Ordinance requires net revenue for the ensuing three fiscal years to equal or 1080 exceed 1.15x the maximum annual debt service on all then outstanding debt obligations. -_. 1081 o f OO t_ • O 881 8888831888 h1 41 -I 000 L41 o 0 io .71 - N I j 7 4 0 0 rol M a o�_ OO 0 o�0 1y� 1S 'mreom �!' h o 0 iv $ .1. o0 0 0 a! ?.. 1 ti w is i ofc 1 0�O1�o'.I....�. ,Ii ,.`1, s P 0 .. ._. ._1-.- 0 0000fo Jot-. _ F,1, m,1. 8.pori O 1 O � ,1 - J } O1O n •1 N1, rl a 1_ 1-I 00 j 1. 4•-1 O oIOlolo 1 Sj iol„i e, 2 d-1 L loO 10i , -'1 .. Q Xi a ,4 ,„ 1.i.. O 1888.q ? vi1II alh 1 b 1.� Oo0 1 .i. .... .j. o/o ae'8` 'i la`.dl v! [� IP_i,�, 4 j f 1 to 11 1 .4 .r.. ... o oofO 88'81§8 nl of 1^ blpi M;:d',o� I � 1 ,.. i o1O:O'O L5i v<<. ,di ni Q' l..l 0� of 881 '8 d iIn i o i 1 _ ;cif; ar ii lo o 8 ,C PI ., I O . Oof . C O;O 8; =fl V N f o o I L. 0 o 0 0 0 0 0 0 �0 0 0 �1 11 0 0000 O it .1. 04 0' 0 it i �' 11f L_ I ' Oi o1 0' O, of o=. o, OI O, o' I of �;o O' o , 0 0 of `11*P 88 s 1 i 11 1 i .,ri a r � � 8;88888888;888 88'8888818 8,8/818 818 818:8x818818'818;81 'I"S� q �� r I l0 ", � n rv'13 a ci m ri n a ", N a P ni ",IH a 5Ia cr if a i = 1' `Na a:l� 11 J'11 oo fir t ool wl�il 25'.25 z5 25� jil'i.`i. a 4628,8001 0 • 0 ' 0 i 0 ` 37,9004'4 3,104. 20 205,000 I. 13_: ,943,000. 1_ 0 0 0 i 0 [ 37,900 ' 3,103,800 y� 196,400 ; 13,7 ;,668,600 0 I 0 I 0 0' 39,500 3,203,200 i 153,2001 tt C 972. 600 ' 52 020,000 i 0 ' 0 0 39,500 ! 3,203,200 i 186,800 ; HS ,U2_,b00 0 : 0 0 i 01 _. 39,500 t. 3,203,200 180,3001 11,C 353,700._..._.. ..__. _. 04 0i. .. . .. .—_ 0 0 39.500: 3,203200;._. __. ... 173,900'_ II, C .678. 4 w 0 ._. 39. 999.300 j .. -- -_ � �. 0!___. ..,..,39,500 , 3,203,2004_ 200,8W� -11,C ,769,300 i 0' 0 0: 0 39,500 3,203,200 , 194.400: I I C 014,5001 . 0 ' 0 _._ .__0 -. _._._.. _. 0 39,5004 },203,200 188,000 ; 11, C ,453,300 i 0 ; 0 ; 0 ' 04. ...._.... 39,5004 3,203,200 7 181, 500 i I l,C 783 600 4, . 0 0 ' 0 0• 39,500 ' 3.203,200 i_ 175.100: 11,C .111.5004. .. _ 0 0 I QT. . .. . __. .0' .. _39,500: 1203200' 168,7001 11,C .431,000 i 0 O 0' 0 J 39,500 3203,200 L 162,3007 11,(; .744,100 i 0 L. 0 1 0 1 0' 40,000___;4, 3,202,800 4 155,800 ' 11,C ,050,600. 0' 0' 0 0 124,600 I 22,78{,400= 116,800 as A89,5000 ., O f 0. 0 0, _ I24600 22,781,400 _.^116,900 22,9 ,128,500 , 0 ; 0 : 0 , —__ 0 t 124,600 _ 22,781,400 ', 116,9001___ _ 22, 9 NP a: P P U P a s PIP P P 1 I �l N1§4' mid 1 i 1 '111`i1''`i .-j a s 1 11 A8181 `i'11m I -I I i8; Ivi o�n 1 1 _ N, 1 1 .1 8i$8'8888�88888 8 8188 s1881881818181a181 }8 1 �!� _ ; I�,..Ie1��N.8i�1 _818 1 Ial 8,81 ,1 8 >0 8 4t18ao8=- In4h ~-1- - - i-!.-.1mbi=1�, 1 i I -,u olM xlFl 1 1 ij,P1 1p, ;N1rv! , SIN4P 51 .3,3'_1-'�.� • L 888818,818188858 1-1_1 +.r ..„ 88181818'881818808'81 , ., .. I y� i 1 I§ Ib.O, Z$I§ .. $8 88188888881888 n n n pr, , ° NNNN , 1: � ,: r- P. , <,:- �1� -ti<-I-In?-^I1", e . "Ig1AIA I<(&ry 8,,' N Al" 1"181"-}8''81li nIn i�'A 1n1 81-.i j j� 81 q y �' 1 I L ....._LI.1 }} ; 1_1. 1 i 88 � g8I$§$888§$i$§8 .. §888;81818§881§18 818'88888!8'8• ,81818' 81888,88; -= 414 4e^ <v^41ae $4 313141314441414 414;4*** *4,41.141* 1 ,/ ^^. T �, j 1 00 000 o000Oo001O1 O o� �o o1o000 o00�0t O4OIOO`O 'O o'OL0I0.0 , 01OO o'O�~ ' I I i I i I i I 1 1 1 1 1 1 1 1 orol0000ootoojoo to 00 00lo!o; .�_., o0 0 �'1j1; dio`.i i 1 t .ol 1010 O Cr; !_o (O; 11 I ' 1i • I I j i 1 i 11 1 i l 1 ,_o 00 �o ... _. 0� 0000�i oio . oj 0.1-o oor�a + i.i� 010 _ 010 i 1 I ,a4 ao •. 1l I I . • , o. �0 o o 0 0........ �0 0 1 0 0 0 0 O,. 1 ol0 I olo of oioEo i o�ol0 0 oio 0 ' j 0101 oQ� 251 ; 0 , 3 t 1 1' I l j 1---•._.r• 8 8188$8$88, r L rt si& 88881s81s88 I I I. 1 _. 1. _ 8 § t , � ' gg&1§18848181§1 _ I 1 . 1 ,5 I 1.._ 0 g m = ? o aM-, ."I ol� n l"3 �IrP.i $=1° oE1 $I „In ,il '..fa �i� ^ I.,{Ih El II ^, Il . d 4d v -. P'' v ..- • W 4 vlb VI1- �4 Poo, O_,o - - i I �1 R �. X1'14 ^Inw I ao 3�1 _--JI-1_- ._ 1 .�.i.! I t .HfLH1 a 1Tt U 3. z C 9 $Yj1 0 @. c� , iT°�°�',$$',i i1 .d 2 '`3 i ( , f E i yyi O, z yy�� 6 .,1n-11 ..j O+, j� I k § O'T 17'� ,,yggy w <al I . S� .. ..1,..„,.,,..,,,., r N N o r M 4 4 4 .v 114 a Hi oN 4 N1r N C4 NI41, 1 Io ry H h 9 1 o 0 o NIP, ry ovl N ory N rir 31 N1 . . . 44440 vl ,n vl vlv ,n v, vl bbb . ,0 '0,0.01 ... .n P. 7 8 A I B 1 c File: FY2013PAYGORates. OCCIP - CIP Original Cost Input Reference BD -14 D E F G DRAFT - For Rate Commission Review June 27, 2011 10:04 a.m. H Ver la H-1 J 9 I0 11 12 13 14 16 Line I No Description 18 19 20 21 22 23 25 26 27 28 29 30 31 32 33 34 35, 36 37 38 39 40 41 43 45 46 47, 49 50 51 52 H-4 1l Represents costs for projects as they are first incurred. Capital improvement projects are assumed to be placed in service the year after costs are first incurred. i ` 1 ; Note: this is 2010 CWIP per auditied financials. 1 2013-2016 f - - - -- ; 2010 _, Original Cost (After Inflation) (a) Average CWIP $ Collection System 1Samtary Sewers 2 :Storm Sewers: 3 Combined Sewers 4I Pumping Stations 5 Total Collection System 198,384,500 Treatment Facilities 6 ; Raw Wastewater Pumping 7 !Preliminary Treatment 8 Primary Sedimentation Aeration/Reaeration/Nitrification 9 Basins 10 Equipment 11 rSecondary Sedimentation 12 1Recirculation Pumping 13 Chlorination 14 Lagoons & Aeration Equipment 15 Sludge Treatment 16 Vacuum Filtration 17 Incineration T 18 By Pass & Outfall Works 19 Administrative & General 20 Total Treatment Facilities 21 Subtotal 22 General Plant; BD -14 183,828,556 55,717,000 16,237,686 41,320,977 20,341,000 30,220,369 10,981,000 271,607,588 r 87,039,000 4,194 49,831,184 169,674,226 588,708 55,329,177 11,861 7,366,787 0 1,101,333 1,283,196 130,631 665,034 13,008,189 880,000 I. 2,688,000 3,366,800 16,842,600 6,148,900 3,319,500 26,311,000 114,299,300 116,563,500 150,077,300 41,727,900 ! _ 42,554,500 ' 54,789,600 22,526,800 j 22,973,000 f 29,578,100 178,554,000; 182,091,000 234,445,000 1,293,500 512,000 3,951,000 1,564,300 4,948,800 1,959,300 8,373,800 I 12,308,300 4,873,000 2,668,000 , 3,921,600 i 1,552,600 7,809,500 11,478,900 4,544,700 417,000 ; 612,900 242,700 _619,800 _911,000 `. 360,700 455,100 668,900 I 264,800 8,279,900 12,170,300 f 4,818,400 2,165,500 3,183,000 1,260,200 7,242,400 10,645,200 4,214,600 890,400 1,308,700 518,200 9,630,800 14,155,900 L 5,604,500 298,994,520 j 55,487,000 570,602,108 142,526,000 32,074,500 0 14,039,000 23 Land 12,683,000 0 1,658,000. 24 Total . 251,719,500 ; 570,602,108 158,223,000; Check . .,._ 158,223,000 (a) Allocated on the basis of plant investment (H-4). 4,500 13,600 17,100 27,600 84,200 105,500 42,400 262,400 13,500 83,600 39,500 1- 244,800 --------- 2,100 , 13,100 3,100 19,400 2,300 14,300 41,900 259,500 11,000 67,900 36,700 227,000 4,500 27,900 48,800 301,800 81,558,000 32,290,000 r 281,000 1,739,000 107,869,000 210,844,000 If 182,372,000 236,184,000 17,505,000 44,124,000 35,409,000 24,287,000 5,729,000 18,839,000 r 19,647,000 1,159,000 131,103,000 273,807,000 237,428,000 261,630,000 131,103,000 273,807,000 237,428,000 261,630,000 A B C D E F G 1 1-1 DRAFT - For Rate Commission Review June 27, 2011 10:04 a.m. 53 54 55 56 57 58 59 61 File: FY2013PAYGORates. CIPDPR - CIP Depreciation 11-1 I Capital improvement projects are assumed to be placed in service the year after costs are first incurred. Depreciation on these improvements is incurred during the year after they are placed in service. For example, a project with costs scheduled in 2011 I is assumed to be placed in service by the end of 2012 and will begin . depreciate ^^" _Line No 63 64 65 66 67 68 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 88 90 91 93 94 95 96 Description Collection System !Sanitary Sewers rStorm Sewers' Combined Sewers Pumping Stations !Total Collection System Treatment Facilities 6 JRaw Wastewater Pumping 30 7 'Preliminary Treatment __ 30 8 Primary Sedimentation 30 Aeration/Reaeration/N itrification 9 Basins_ _ 30 10 i- Equipment ment qp-- 20 11 Secondary Sedimentation 30 12 ;Recirculation Pumping ! 30 13 }Chlorination F j 30 14 'Lagoons & Aeration Equipment _ _ 30 15 `Sludge Treatment 30 16 ; Vacuum Filtration 30 17 i Incineration 1 30 18 'By Pass & Outfall Works 30 19 I Administrative & General 1 30 20 Total Treatment Facilities 21 !Subtotal 22 j General Plant Estimated Useful Life 2011 50 50 50 30 01 Annual Depreciation Ver la 11-2 2012 2013 . 2014 2015 Original Cost of project (11-1)./.Useful Life (a) 3,676,600 4,790,900 5,127,800 7,413,700 324,800 l 324,800 324,800 324,800 826,400 + 1,233,200 1,356,200.', 2,190,800 1,007,300 ! 1,373,400 1,484,000 ; 2,234,900 5,835,100 7,722,300 8,292,800 12,164,200 100 29,500 72,600 89,700 1,661,000 1,750,600 1,882,300T 1,934,500 5,655,800. 5,768,000 , 5,933,000 I 5,998,300 0 t 279,100t 689,400 851,800 29,400 , 162,800 l 358,900 '1- 436,500 1,844,300 {' 2,104,600 ! 2,487,300 2,638,700 400 1 14,300 ` 34,700 42,800 245,600 266,200 296,600 308,600 0 4 0 i.. 15,200 1 37,500 0 1 36,700 1 312,700 I 718,400 42,800 ! 115,0001 221,100 4,400 245,800 ' 600,600 741, t 00 22,200 L 51,800 95,500 112,700 433,600 I 754,600 1,226,500 1,413,300 t. 9,976,300 - 11,870,2001 14,654,400 15,756,400 0 I 15,811,400 I 19,592,500 I 22,947,200 27,920,600 702,000 1 1,577,200 r 3,783,400 46,300 879,000 263,100 23 'Total 0 1 15,811,400' 20,294,5001 24,524,400 31,704,000 Total System Depreciation .1 54,011,800 69,823,200 74,306,300 78,536,200 85,715,800 (a) Assumes each project takes two years to go into service, therefore, no depreciation the first two year. 1 A ► B C D E F 97 98 99 100 101 103 File: FY2013PAYGORates. OCLDCIP - CIP Original Cost less Depreciation ► G DRAFT - For Rate Commission Review June 27, 2011 10:04 a.m. Ver la 11-3 HH-1 1. .. H-2 Line I No j_ Description 105 106 107 108 109 110 1 I 2 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 130 I32 133 134 136 137 i Collection System 1 ;Sanitary Sewers 2 Storm Sewers 3 !Combined Sewers 4 [ Pumping Stations 5 'Total Collection System 'Treatment Facilities 6 j Raw Wastewater Pumping 7 Preliminary Treatment 8 i Primary Sedimentation Aeration/Reaeration/N itrifieation Basins 10 Equipment 11 {Secondary Sedimentation 12 1Recirculation Pumping 13 Chlorination 1 14 Lagoons & Aeration Equipment 15 ;SludgeTreatment 16 Vacuum Filtration 17 ':Incineration 18 By Pass & Outfall Works 19 Administrative & General 20 !Total Treatment_ Facilities 21 Subtotal 22 'General Plant F 23 Land 24 tTotal Check 1 Original Cost Less Depreciation 2011 2012 $ $ Total Original Cost (H -I) 183,828,556 235,868,956 ! 16,237,686 15,912,886 41,320,977 } 60,835,577 1 30,220,369 j 40,194,069 2013 2014 2015 $ $ less Cummulative Depreciation (H-2) 2.47,920,656 357,092,156 1 466,241,956 15,588,086 1 15,263,286 t 14,938,486 65,751,277 106,122,977 1 146,486,677 42,140,169 1 63,182,969: 83,921,069 271,607,588 r 352,811,488 ' 371,400,188 ; 1 4,194 i 884,094 2,148,094 1 49,831,184 ' 50,858,184 1 53,058,584 1 169,674,226 167,385,226 ' 166,566,026 !' 0, 0, 0 0 ' 8,373,800 20,403,000 24,586,600 588,708 3,227,308. _ 6,986,108 8,179,808 55,329,177 61,294,377 1 70,668,677 72,726,077 11,861 428,461 1,027,061 1,235,061 7,366,787 7,740,987_. 8,385,787 I 8,449,887 0 455,100 1,108,800 1,336,100 1,101,333 . 9,344,533 j 21,202,133.1 1,283,196 3,405,896 ! 6,473,896 130,631 7,368,631 , 17,768,031 1 665,034 1,533,234 1 2,790,134 ` 13,008,189 22,205,389 I 35,606,689.1 541,661,388 I 711,588,188 2,587,494 • 52,740,584 162,592,326 25,302,133 7,512,996 21,382,031 3,212,834 39,984,689 298,994,520 344,505,220 414,193,020 431,828,620 2,502,294 50,819,684 156,611,126 0 2.3,777,200 7,756,808 70,126,877 1,194,361 8,144,387 1,292,100 24,465,033 7,260,896 20,677,631 3,104,634 38,620,189 416,353,220 570,602,10.8 697,316,708 ; 785,593,208 ! 973,490,008 1,127,941,408 0 14,039,000 30,842,000 73,388,800 105,014,400 0 1 1,658,000 7,387,000 1 26,226,000 45,873,000 570,602,108 , 713,013,708.4 570,602,108 713,013,708 I 823,822,208 1 1,073,104,808 1,278,828,808 823,822,208 1,073,104,808 ; 1,278,828,808 139 140 141 A B C File: FY2013PAYGORates. PPE - Plant, Property & Equipment Input Reference BD -15 D E F DRAFT - For Rate Commission Review June 27, 2011 10:04 a.m. G Ver la H-4 H 142 143 144 145 146 147 149 150 151 152 153 154 155 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 175 Line No Description _. Collection System 1 I Sanitary Sewers 2 Storm Sewers !Combined Sewers 4 Pumping Stations 5 TTotal Collection System Treatment Facilities 6 [Raw Wastewater Pumping 7 Preliminary Treatment 8 Primary Sedimentation Aeration!Reaeration/Nitrification 9 Basins Fixed Asset Listing as of June 30, 2010 10 i Equipment 11 !Secondary Sedimentation 12 :Recirculation Pumping 13 Chlorination I 14 ; Lagoons & Aeration Equipment 15 Sludge Treatment 16 t Vacuum Filtration 17 incineration 18 By Pass & Outfall Works 19 Administrative & General 20 177 178 179 181 182 183 184 21 22 23 Total Treatment Facilities Subtotal Estimated Plant Investment_ General Plant j Land 24 Total Estimated Plant Inves 1CWIP H-1 Total Capital Assets Total OC w/o Land ent (1) Original Cost 855,638,000 577,741,000 312,373,000 168,634,000 1,914,386,000 11,899,000 36,345,000 45,523,000 (2) (3) (4) June 30, 2010 j June 30, 2010 Annual j Accumulated Book Value Depreciation 1 Depreciation OCLD 13,767,300 9,295,900 5,026,100 2,713,400 30,802,700 169,262,700 126,133,600 152,311,000 73,527,300 686,375,300 4.51,607,400 160,062,000 95,106,700 521,234,600 i 1,393,151,400 328,200 5,352,200 1,002,500 23,293,400 1,255,700 20,992,900 113,222,000 2,429,000 48,210,200 36,074,000 1,741,300 19,604,200 105,593,000 2,912,600 49,044,700 5,638,000 155,500 3,120,800 8,380,000 231,200 2,256,700 6,153,000 169,700 3,561,300 111,953,000 3,088,000 47,180,000 29,280,000 807,600 16,830,900 97,924,000 2,701,100 50,859,500 12,039,000 332,100 5,365,700 130,218,000 3,591,800 59,742,200 750,241,000 ; 20,746,300 355,414,700 2,664,627,000 j 51,549,000 r 876,649,300 64,195,000 2,462,800 39,026,900 28,129,000 2,756,951,000 6,546,800 13,051,600 24,530,100 65,011,800 16,469,800 56,548,300 2,517,200 _ 6,123,300 2,591,700 64,773,000 12,449,100 47,064,500 6,673,300 70,475,800 394,826,300 ,787,977,700 25,168,100 28,129,000 54,011,800 915,676,200 ! 1,841,274,800 570,602,100 .. . _. 2,411,876,900 2,728,822,000 i (depreciable plant investment) A 1 B c F 1 G H DRAFT - For Rate Commission Review June 27, 2011 10:04 a.m. 185 File: FY2013PAYCORates. 186 OCLD - OCLD of Existing Plant 187 188 190 Line , 191_ No Description , _ 193 I 1- „ 194 1 195 _ Collection System 196 1 Sanitary, Sewers 197 2 __ Storm Sewers] 198 3 Combined Sewers 199 4 Pumping Stations 201 5 TTotal Collection System 202 __ Treatment Facilities 203 6 'Raw Wastewater Pumping 204 7 1 Preliminary Treatment 1 205 8 _Primary Sedimentation 206 Aoration/Reaeration/Nitrification 207 9 Basins 1 208 10 i Equipment_ 209 __ 1 I i Secondary Sedimentation 210 12 ' Recirculation Pumping 211 13 !Chlorination 1 212 14 !Lagoons & Aeration Equipment 213 15 ' Sludge Treatment 214 16 Vacuum Filtration 215 17 Incineration 1 216 18 By Pass & Outfall Works 217 19 I Administrative & General 219 20 Total Treatment Facilities 221 21 Subtotal OCLD 222 22 General Plant 223 23 Land 225 24 Total OCLD L 226 2010 $ li-4 OCLD for Year Ending Lune 30 K Ver 1a 11-5 2011 2012 Test Year 1 2013 2014 2015 $ , $ $ $ Previous Year's OCLD less Annual Depreciation (H-4) 1 2016 686,375,300 672,608,000 658,840,700 1 645,073,400 631,306,100 617,538,800 _ 603,771,500 451,607,400 1 442,311,500 433,015,600. 423 719,700 414,423,800 405,127,900 ` 395,832,000 160,062,000_ 155,035,900 ; 150,009,800 144,983,700 139,957,600 134,931,500 129,905,400 95,106,700 92 393,300 i 89,679,900 ! 86,966,500 84,253,100 81,539,700 78,826,300 1,393,151,400 j 1,362,348,700 , 1,331,546,000 fi 1,300,743,300 1,269,940,600. 1,239,137,900 1 1,208,335,200 � 6,546,800 5,890,400 13,051,600 I 11,046,600 24,530,100 ! 1 22,018,700 65,011,800 62,582,800 60,153,800 16,469,800 14,728,500 12,987,200 56,548,300 53,635,700 _ 50,723,100 2,517,200 j , 2,36L700 2,206,200 6,123,300 5,892,100 5,660,900 1 2,591,700 2,422,000 ( 2,252,300 64,773,000 61,685,000. 58,597,0001_ 12,449,100 1 11,641,500 10,833,900 47,064,500 44,363,400 41,662,300? 6,673,300_ 6,341,200 6,009,100 70,475,800 66,884,000 63,292,200 394,826,300 374,080,000 , 353,333,700 1,787,977,700 1,736,428,700 1 1,684,879,700 25,168,100 22,705,300 20,242,500 28,129,000 28 129,000 ` 28,129,000 1,841,274,800 1,787,263,000 1,733 251,200 6,218,600 1 12,049,100 23,274,400 5,562,200 10,044,100 20,763,000 ,l 57,724,800 11,245,900 47,810,500 2,050,700 5,429,700 2,082,600 55,509,000 10,026 300 38,961,200 5,677,000 59,700,400 332,587,400 1,633,330,700 1 17,779,700 28,129,000 1,679,239,400 r 1 5,234,000 4,905,800 4,577,600 9,041,600 8,039,100 7,036,600 19,507,300 18,251,600 16,995,900 55,295,800 52,866,800 1 50,437,800 9,504,600 7,763,300 r 6,022,000 44,897,900 41,985,300 ( 39,072,700 1,895,200 1,739,700 1,584,200 5,198,500 4,967,300 4,736,100 1,912,900 1 1,743,200 1,573,500 52,421,000 49,333,0004 46,245,000 9,218,700 8,411,100 7,603,500 36,260,300 33,559,000 30,857,900 5,344,900 5,012,800 ' 4,680,700 56,108,600 ` 52,5I6,800 48,925,000 311,841,100 291,094,800 i 270,348,500 ,581,781,700 1,530,232,700 1,478,683,700 15,316,900 12,854,100 10,391,300 28,129,000 28,129,000 28,129,000 ,625,227,600 1,571,215,800 1,517,204,000 227 228 229 230 232 233 234 235 236 238 239 240 241 242 243 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 263 265 266 267 269 270 A B C File: FY2013PAYGORates. INV - Investment Summary Line No Description =Collection System _ 1 Sanitary Sewers 2 Storm Sewers 3 j Combined Sewers 4 'Pumping Stations 5 j Total Collection System D E DRAFT - For Rate Commission Review June 27, 2011 10:04 a.m. Treatment Facilities 6 !Raw Wastewater Pumping 7 rPreliminary Treatment 8 , Primary Sedimentation Aeration/Reaeration/Nitrification 9 Basins 10 Equipment 11 !Secondary Sedimentation 12 Recirculation Pumping 13 Chlorination L _ 14 ;Lagoons & Aeration Equipment 15 Sludge Treatment 16 !Vacuum Filtration 17 Incineration 1 18 'By Pass & Outfall Works 19 Administrative & General 20 Total Treatment Facilities 21 Subtotal 22 ' General Plant 23 (Land 24 Total F Ver la 11-6 G Test Year 2013 (1)..._... j (2) Existing CIP Net OCLD C Related Plant OCLD Investment Investment H-5 645,073,000 423,720,000 144,984,000 86,966,000 1,300,743,000 H-3 (3). Total OCLD Plant Investment 247,921,000 ! 892,994,000 15,588,000 439,308,000 65,751,000 210,735,000 42,140,000 ? 129,106,000 371,400,000 I 1,672,143,000 5,562,000 ! 2,148,000 7,710,000 10,044,000 53,059,000 [ 63 103,000 20,763,000 166,566,000 187,329,000 57,725,000 I 20,403,000 78,128,000 11,246,000 6,986,000 18,232,000 47,811,000 70 669,000 L 118,480,000 2,051,000 i --_1,027,000 3,078,000 5,430,000 8,386,000 ; 13,816,000 2,083,000. 1,109,000 3,192,000 55,509,000 21,202,000 76,711,000 10,026,000 6,474,000 16,500,000 38,961,000 17,768,000 56,729,000 5,677,000 2,790,000 8,467,000 59,699,000 _ 35,606,000 95,305,000 332,587,000 414,193,000 746,780,000 1,633,330,00 785,593,000 LL 2,418,923,000 17,780,000 3.0,842,000 j 48,622,000 28,129,000 00 � 7,387,000 35,516,000 1,679,239,000 823,822,000 2,503,061,000 A B c D E F G H DRAFT - For Rate Commission Review June 27.2011 10:04 a.m. 271 272 File: FY2013PAYGORates. SWIA - Stormwater Investment Allocation Ver la H-7 273 274 276 277 278 279 280 282 283 284 285 286 288 289 290 291 292 294 295 296 297 298 300 301 302 303 305 306 307 308 309 310 311 312 314 315 317 318 319 320 321 322 323 Existing Plant in Service [-1=5 Storm Sewers H-5 Combined Sewers H-5 Pumping Stations Total Capital Improvements H-3 t Storm Sewers H-3 Combined Sewers H-3 G Pumping Stations Total 1 Total Combined Investment Storm Sewers Combined Sewers Pumping Stations Total 2011 442,312,000 433,016,000 155,036,000 150,010,000 92,393,000 89,679,000 2013 2014 2015 423,720,000 1 414,424,000 405,128,000 144,984,000 ! 139,958,000 134,932,000 1 86,966,000 84,253,000 ' 81,539,000 689,741,000 ' 672,705,000 655,670,000 638,635,000 621,599,000 16,238,000 15,913,000 15,588,000 I 15,263,000 14,93 8,000 41,321,000 - 60,836,000 65,751,000. 106,123,000 146,487,000 ' 30,220,000 40,193,000 L 42,140,000 63,183,000 1 83,921,000 , 87,779,000 116,942,000 L 123,479,000 184,569,000 458,550,000 448,929,000 196,357,000 210,846,0001 122,613,000 I 129,872,000 777,520,000. 789, 647,000 Total System Investment without Land & General Plant H-5 Plant In Service H-3 Capitallmprovements Total Land & General Plant (a) H-5 Plant In Service H-3 I Capital Improvements Total :Total System 0.0% 15.0% ---- { Stormwater Investment Storm Sewers Combined Sewers Pumping Stations Subtotal Land & General Plant (b) Total Stormwater Related Percentage Stormwater Check Per 1-4 1,736,429,000 1,684,880,000 570,603,000 , 697,316,000 2,307,032,000 2,382,196,000 50,834,000 48,371,000 (1,000) 15,698,000 50,833,000 64,069,000 439,308,000 210,735,000 129,106,000 779,149,000 823,204,000 2016 395,832,000 129,905,000 78,826,000 604,563,000 14,614,000 198,234,000 110,499,000 245,346,000 1 323,347,000 429,687,000 j 420,066,000 410,446,000 246,081,000 F 281,419,000 328,139,000 147,436,000 . 165,460,000 189,325,000 1,633,330,000 785,593,000 2 418 923000 45,909,000 38,229,000 866,945,000 ' 927,910,000 1,581,782,000 1 1,530,233,000 973,490,000 1 1,127,941,000 2,555,272,000 2,658,174,000 43,446,000 40,983,000 99,615,000 150,888,000 191 871 000 84,138,000 143,061,000 1,478,684,000 1,332,247,000 2,810,931,000 38,520,000 170,779,000 209,299,000 2,357,865,000 , 2,446,265,000 2,503,061,000 2,698,333,000 2,850,045,000 3,020,230,000 458,550,000 448,929,000 439,308,000: 429,687,000 1 420,066,000 0 0 0 0 0 18,392,000 19,481,000 19,366,000 ' 22,115,000 I 24,819,000 41 0,446,000 0 28,399,000 476,942,000 1 468,410,000 458,674,000 451,802,000 ' 444,885,000 438,845,000 10,509,000 L 12,598,000 15,954,000 ; 25,295,000 32,112,000 j 32,676,000 487,451,000. 481,008,000 474,628,000: 477,097,000 476,997,000 , 471,521,000 20.67%1 _ 19.66%l 18.96%' 17.68% 16.74%1 15.61% I 18.96%1 _(a) Total Investment less Collection System and Treatment Facilities. — (b) :Total Land & General Plant_investment allocated on the basis of the subtotal of Stormwater Investment to the Total System Investmer A 1 a C 13 E F G 1 H 7 8 9 10 i 12 13 14 15 16 18 19 20 File: FY2013PAVGORetes. OMPER - O&M Allocation Percentages Input Reference BD -17 12 1 Line{ No. I Description 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45. 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67, 68 70 71 73 74 75 76 77 Personnel Services [ _ Administration and -Management (a) 2 C EngineeringI Operations 3 _ Collection System Pump Stations 5 Wastewater Treatment 6 1_ .Support 7 Finance 8 Information Systems 9 _ 'Average Alt Other j 10 Administration and Management (a) 11 ---_--Engineering-- __ . .. _.. O rations_j _ 12 _Collection System _. 13 Pump Stations_ _ 14 Wastewater Treatment 5 : Support 1 -- 16 ' Finance 17 Information Systems __ • 18 Average.-". , Utillties Operations" 19 Pump Stations 20 Wastewater Treatment 21 Average 1 22 Water Backup Program 23 Headquarters Building; 24 ,Total O&M Epense 25 Allocations to Operating Reserve t Less Costs Met From Other Revenue ' Other Revenue DRAFT - For Rate Commission Review June 27, 2011 10:04 a.m. Table 3-14 Percentage of Wastewater Operation and Maintenance Expense by Functional Cost Components Test Year 2013 100.0% 100.0% 100.0% !00.0% 109.0%,1 0.0% 100.0% 0.0%t -.....100.0% 100.0% 0.0% 0.0%ir 0,0%1 0.0% 12.0 51.4% 100.0%' Volume __ Capacity S S 5.4% 100.0%. !00.0% 100.0% 23.5% 88.0%] 8.7% 48.6% 0.0% 0.0% 100.0% 0.0% !00.0% 0.0% , 100.0% 100.0%t 0.0%I 100.0% 100,0% _--_ 0.0% _ 100.0% 100.0%: 0.0% 100.0% 100.0% 1.0% 99.0% 100.0 % 4.1% 95.9% 00"% 100.0%i 0.0% 100.0% T 11)0.0%r.. 0.0% 100.0% 0.0% 100.0% 100.0% 0.0%1 100.0%,_ 0.0%'~_ 100.0% 0.0%' 00.0% 100.0% 100.0% 100.0% 100.0 % 100,0 % 109,0°4 _ 4.6% 19.1% 11.6%i 56.0% 34.7% 38.9% 100% 77.6% 100.0% 100.0% 16.7% 53.2%1 1 64.6% 81.3% 2.1% 2.7% 100.0%1 - 100.0% 18.2% 30.3% 46.7% 18,4%1 44.0% 12.6% 18.8% 14.1%C 48.7%' 14.1% 48.6% Direct Suspended Solids_. • . { BOD K 1 L 1 M 2.5% 25.5% 9.4%] 34.1% 12.6% 8.0% 10.6% 32.1 f 9.4 2,9% 2.3% 2.8% All Customers 19.7% 32.5% 15.8% 26.0%J $ 3.5% 16.1% 100.0% Ver la 1-1 1XFer118 Non- Residential Customers 8.3% 0.2% 5.9% 2.6% 6.9% 0.3% 3.9% 100.0% 0.0%I 0.0% 100.0 % 9.6%T 12.3%4. 13.7% 9.7% 12.3%i 13.7%. 26 Wastewater Revenue Adjustments __. .. .. . , 100.0% _- - - _ . 0%'_ _ _ 0.0% 0.0% 90 27 Connection and Other Fees 100.0% 15.4%__ 10.5%, 34.5% 28 MiscellaneousRevenue ; 100.0%.[. 25.0%L 0.0%1 0.0%1 29 I_ Interest income 100.0% _ j 11.G% 40.08 7 9% 30 Full Year Rate Adjustment _ 100.0%1_ 16.7% 57.4% 11.4%, 3l Average 100.0%� 28 52.7/0 Sa� 8 32 f Net O&M.. nse - == r ° , 100.0%0' • -_-_-- .._ 18.8% 49.9%' 9.6%' (a) , Includes Board of Trustees, Rate Commission, Civil Service Commission, Office of Secretary:. Treasurer , Executive Director, Office_ of 1 [General Counsel, and Office of Human Resources. I ; 0.5% 0.4% 1.6% 1.6% i fi 0.0% 10.0% L 00% 28.8%1 0.0% 10.8% 0.0% 75.0% 0.0% 10,1% 29.0% 1.3% 14.5% 0A%' 0.0% 12.5%{ •-3.0%I -0.4% 12.3%1-1 8.4% _. 1.0% A B C D 0 F G H K L 78 79 80 81 82 83 84 85 86 88 89 90 92 93 94 95 96 97 98 99 100 101 102 104 105 106 107 108 109 110 1111 112 113 114 115, 117 119 120 121 122 123 124 125 127 128 129 130 131 132, 133 134 135 136 137 138 139 140 141 142 144 145 146 147 149 150 151 152 153 154 155 156, 157 158 159 File: FY20l3PAYGORates. OMALLOC • Allocated O&M Expense D-29 1-1 Line t No. !Description 1 Personnel Services I Administration and Management (a) 2 ' Engineering; _ Operations 3 Collection System 4 Pump Stations 5 Wastewater Treatment Support Finance Information Systems - Total -- - All Other 10 Administration and Management (al -11 Engineering] Operations 12 Collection System 13 Pump Stations 14 Wastewater Treatment 15 Support 16 Finance 17 Informa_tion Systems IS 'Total I9 Subtotal Direc Expenses 20 Total lndirect (b) lltiiitles Operations 1 21 Pump Stations 22 Wastewater treatment 23 Subtotal rt 24 [Water Backup 2S Headquarters Building 26 Total O&M Expense 27 •Additional O&M (c) 28 ' Add't to Operating.Reserve (d) !Less Costs Met From Other Revenue Other Revenue 29 I Wastewater Revenue -Adjustments_ (11,590,600) _ 30 Connection and Other Fees 2,082,800 31 . Miscellaneous Revenue 3,651,300 32 Interest Income (e) i 1,664,200 33 ; Full Year Rate Adjustment (f) 1 (64,443,500) 34 =Total (68,635,800)1 - DRAFT - For Rate Commission Review June 27, 2011 10:04 a.m. Table 3-15 Allocation of Wastewater Operation and Maintenance Expense to Functional Cost Components Test Year 2013 Total 5 4,579,600 19,477,100 17,898500 3.895,500 _1 0 17.125,300 ' 0 3.947,100 473,700 5,199,600 2,672,800 6,445,600 6,445,600 - 78,568.300 14,171,700 Direct ( Ver la I-2 ,XFer119 M Non - Suspended L All - Residential Capacity Solids BOO Customers Customers $ 17,898.500: j 17,898.500 3.895,500 F 3,895,500 17.125,300 4,024,400 2,859,900 4,367.000 3,473,400 . 301,300 1.848,600 j 327.000 2,526.800 1 0 64,396,600 5,377,500 41,616,700 5,180.900 486,900 - i 9,713,200 ' 9,713,200 1 0 - -- 1,305.600 0 ' 1,305,600 60,000 1,061,500 27,400 30,000 36,600 90,100 4,214,400. ; 0 4,214,400 4,214,400 2,091,600` 0 2,091,600 2,091,600 10,754,600 0 : 10,754,600 2,054,200 ! 1,957,300 ! 3,258,600 l 3,452,200 4,060,600 ; 40.600 4,020,000 465,200 1,878,400 737,900 781,700 11,184,200? 460,500 10,723,700 ; 4,043,900 ' 4,043,900 1 0 68),700 1,616,600 5,839,700 437,300 I 559,200 2,526.800 { 6,802,900 34,300 3.767,700.1 1,650,900 156.800 10,723,700.1 47,368,100 14,258,200 33,109,900 2.579.400 11.203,200 4,023,900 4,263.900 ( 10.917,100 122,400 97,506,500 7,956,900 52,819,900 9,204,800 0,066,800 14,684,800 1,773.300 28,429,900 : 28,429,900 2,320.100 15,400,700 _ 2,683,800 3,226,700 ; 4,281,600 - 517,000 2.695,200 1 _ 10,877,600 13,572,800 ,. i 35 'Net O&M Expense 215,343,400 36 _ ;Stormwater Program Support - 0 . 37 ,Adjusted Net O&M Expense 215,343400 (a) i Includes Board of Trustees, Rate Commission. Civil Service Commission, Office of Secretary,- Treasurer, xe E cutive Director, Office of 1 !General Counsel, and Office of Human Resources. i j _(b) Allocated based on Line 19. I _ (c) Additional costs due to anticipated regult _ Personnel services costs are allocated based on Line 5. utilities are allocated based on Line 22, and all other costs are allocated based on Line 14. (d) _ Allocated based on Lines 26 and 27. _ i _ _ i j (e) ;Allocated 29.086 of interest income directly to All Customers based on relative revenue receipts with remainder allocated based on Line 26 less 'All Customer costs. 1. . (f) ',Allocated based on Line 26 Tess All Customers, and Nonresidential Customers costs. i45,469.000 - 112.400 1,126,200 Indirect Total $ 4,579,600 ; 0 0 ( 19,477,100 2,695200 _ _ (,509,300 1,185,900 10,877,600 3.774,500 , 1,370,600 t 2,142,900 3.535,200 13,572,800 5.283,800 ( 2,556,500 2,1.42,90.0; 3.535.200 5,000000 L 5,000 959,800 1.4.5,469,000 20,560.800I 70,7.77,100 14,031.500 17,828,700 112,400 r 26,600 1 _ 18.800.1 28.700.1. 38,300 1,126,200 159,300 547,700 108,800 ! 138,200 (11,590,600) i (10,431,500) 0 =_ 0 _ 0 1 2,082.800 I 321,300 j 219,000 717,700 600,500 3,651,300 1 912,800 0 0 1 0 1,664,200 ' 193,500 666.I00 i 132,100 167,800 (64,443,500) i (I0.755,100)1 (37,022,700) -_ (7,339,700)_ „ (9,326,000) ,:-- (68,635:800) ' (19,759,000):.(36,137,600). (6.489,900). (8,557,700)' ; 215343,400 40.505,700 :107.481200 20.658.900 26,562.900 18.018.300 0 0 215,343.400: 40,505,700 ' 107.481,_00 20,658,900 19,926,200 ! 2,344,700 154,100 18,100 (1,159,100)1 0 0 ; 224,300 2.738,500 0 482,600 1 22.100 2,062,000 -- 246,400 2,116.400 26.562,900 j 18,018,300 i 2,116,400 A B C D E F G H I K 160 161 162 163 164 165 166 167 168 170 171 172 174 175 176 177 178 179 180 182 183 184 185 186 187 188 190 191 192 193 194 File: FY2013PAYGO Rates. DRAFT - For Rate Commission Re view AOMALLOC - Additi onal Allocated O&M Expense J une 27, 2011 10:04 a.m. Ver la I -2a Table 3-15a Allocation of Additi onal Wastewater Operation and Maintenance Expense to Functional C ost Comp onents Test Year 2013 Line No . Description Total Collection System Personnel Services Supplies Utilities Contractual Services Total WWTP Improvemen ts Perso nnel Services Supplies Utilities Contractual Services Tota Total Addition al O&M Direct Suspe nded T otal Indirect Total Vol ume Capacity Solids BO D 112,400 0 0 112,400 112,400 -t 0 0 0 112,400 26,600 0 0' 0 0' 0 0 0 18,800 28,700. 0? 0 38,300 0 112,400 26,600 18,800 28,700 , 38,300 112,400 26,600 18,800- - 28-,-700 38,300 A B C F G H K 195 File: FY2013PAYGORates. 96 AOR - Allocated Other Revenue 197 Inp ut Ref erence BD -18 198 0-4 , 1-1 199 200 20 202 203 204 Line 205 No. 207 208 Other Revenue - 209 ! Wastewater Revenue A djustments 210 Connection an d Other Fees 211 — Construction Inspection Fees 212 Plan Review Fees 213 Submittal Fees 214 Waste hauler Permits 215 ' Wastewater Mo nitorin _Costs Fees 216 Pretreatment Discharge Permits 217 All Other 218 Miscellane ous Reven ue 220 Total O&M Expense (a)_ 2211 222 •Othe r Rev en ue - $ 223 Wastewater Revenue A djustments (11,590,6.00) (10,431,500) 224 Conn ection an d Other Fees 225 Construction In spectio n Fees 106,100 53,000: 53,100 0 : 0 226 Plan Review Fees 66,400 33,200 33,200: 0 0 T. 227 Su bmittal Fees 90,200 45,100 1 45,100 ' 0 0 0 0 228 Waste haule r Permits 1,464,600 , 102,500 r 0 717,700 • 600,500 0 43,900 229 Wastewater M onitoring_Costs Fees 0 i 0; 0 i 0 0. 0 0 230 • Pretreatment Disch ge Permits 180,400: 0 r 0 0 0 0 180,400 All Other 175,100 87,500 87,600 0 0 : 0 0 232 Miscellaneous Reve nue 3,651,300 I 912,800 0 0 : 0 ' 2,738,500 0 234 !Total (5,856,500); (9,197,400). 219,000 717 700 600 500: 1,579,400 224,300 DRAFT - For Rate Commissi on Review June 27, 2011 10:04 a.m. All ocation of Other Wastewater Revenue E xpense to F unctional Cost Comp onents Test Year 2013 Total Wastewater V olume • —1 11 Ver la I-3 • All Residential Capacity_Solids BOD Customers Customers 100 .0% 90 .0% 100 .0 %! 50.0% 100 .0%! 50.0% 100 .0%i 50.0% 100.0% 7 .0% 100.0 %• 100.0%' 100.0% 50 .0% 100.0% 25.0 %' 14.1 %; 100.0%: -1- 50.0% 50.0% 50.0% 50 .0% 48 .7%-" 49 .0% 41 .0% 9.6% 10 .0 %i 3 .0% 100.0% 100 .0% 75.0% 12.3% 13.7%: 1 .6% 235 236 (a) Allocated based on Line 26 on Pale 237 0 0' (1,159,100) 0 Or 0. 0 A 1 B C D E F G H 3 238 239 240 241 242 243 244 245 246 247 248 249 251 252 253 254 255 256 258 259 260 261 262 263 266 267 268 269 270 271 272 273 274 276 278 279 281 282 283 284 285 286 287 290 291 292 294 295 297 298 299 300 301 302 303 304 Line No. Description I I File: FY2013PAYGORates. PALLOC - Allocated Plant Investment DRAFT - For Rate Commission Review June 27, 2011 10:04 a.m. Ver la 1-4 HH-77I Table 3-13 Allocation of Estimated Wastewater Plant Investment and Other Capital Costs to Functional Cost Components Test Year 2013 (1) (2) (3)_ Total (a) Volume [ Capacity Collection System I Sanitary Sewers Storm Sewers; 2 Combined Sewers 3 Pumping Stations 4 j Total Collection System Treatment Facilities 5 I Raw Wastewater Pumping 6 1 Preliminary Treatment 7 Primary Sedimentation 8 Aeration/Reaeration/Nitrification 9 Secondary Sedimentation 10 +Recirculation Pumping 11 i Chlorination ft 12 Lagoons & Aeration Equipment 13 Sludge Treatment 14 Dewatering 15 Incineration 16 By Pass & Outfall Works 17 ' Administrative & General (b 18 Total Treatment Facilities c_. 19 Subtotal Estimated Plant Investment 20 Land & General Plant (c) 21 Total Estimated Plant Investment 22 Routine Capital Improvements (d) Cash Financing of lmpro_ vements 23 Collection System 24 ' Wastewater Treatment (e) 25 ; Land & General Plant (c) H-6 892,994,000 210,735,000 j 109,740,000 4t. 1,213,469,0001 892,994,000 210,735,000 109,740,000 1,213,469,000 7,710,000 7,710,000 63,103,000 63,103,000 187,329,000. 187,329,000 96,360,000 96,360,000 118,480,000 118,480,00C- 3,078,000 3,078,000 13,816,000 13,81.6,00.0_ 3,192,000 r I 3,192,000 76,711,000 38,356,000 38,355,000 16,500,000 8,250,000 i 8,250,000 56,729,000 28,365,000 28,364,000 8,467,000 8,467,000 95,305,000 47,208,000' 11,598,000 10,968,000: 25,531,000 746,780,000 369,911,000 90,878,000 85,939,000 fi 200,052,000 ,960,249,000 369,911,000 t 1,304,347,0007 85,939,000 i 200,052,000 ; 458,674,000 72,087,000 13,603,000 1 47,967,000 , 3,160,000 7,357,000 1 12,051,000 2• ,032,336,000 383,514,000 1 1,352,314,000 89,099,000. 207,409,000 470,725,000 XFer1 17 (4) (5) Suspended Solids BOD Stormwater H-7 439,308,000 0 j 19,366,000 458,674,000 2,535,700 478,400 L 1,687,300 , 111,200 . _t. — ---i 215453200 215,453,200 L 9,315,400 ; 4,614,300 1,133,600 1,072,000: 2,495,500 48,608,400 ' 9,172,700 32,344,000 , 2, 131,000 ; 4,960,700 . 258,800 1 26 Less: Connection Fee Revenue (d) 1,327,000 ; 250,400 883,000 ; 58,200 135,400 27 Change in Funds Available (d) T (2,000) (400) (1,300)i (100)1 (200)1 28 ;Net Cash Financed Capital Costs 29 Debt Service (d) 30 ' Total Net Capital Costs i 274,587,700 t 14,015,400 249,736,400 ; 3,256,100 7,579,800 1 47,097,200 I 8,887,500 31,338,400' 2,064,800 , 4,806,500 , 321,684,9001 22,902,900 281,074,8001 5,320,900 12,386,300 • 31 'Estimated Replacements (c) t 64,366,600 1 12,146,4001 42,829,400 i 2,821,900 6,568,900 ' 9,939,700 32 tNet Other Capital Cost j , 257,318,3001 10,756,5001 238,2454001 2,499,000 j 5,817,400 j I1 i (a) j Excludes $470,725,000 of investment related to the stormwater system . (b) Allocated based on all other treatment facilities (Lines 5 through (6). (c) Allocated based on Line 19. i (d) Allocated based on Line 21. Allocated based on Line 18. I (e) A B C D E F G 7 8 9 0 11 12 13 4 15 17 18 19 20 2 22 2 24 26 27 28 29 0 31 33 34 35 36 37 39 4 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 File: FY2013PAYGORates. COS - Cost of Service DRAFT - Fo June 27, 201 Rate Commission Review Ver la 10:05 a.m. J-1 G - Table 3-12 Wastewater Cost of Service Test Year 2013 Line No. Description Revenue Requirements i 'Operation & Maintenance Expense 2 `Debt Service 3 Routine Capital Improvements 4 ; Cash Financing of Major Improvements 5 Additions to Operating Reserve Stormwater Support 6 Total Revenue Requirements met from 0 Other Operating Revenue 7 Wastewater Billing Adjustments 8 Inspection and Other Fees 9 Miscellaneous Revenue 10 Subtotal 11 Interest Income 12 Connection Fee Revenue 13 !Change in Available Fund Balances 14 'Full Year Rate Adjustment (a) 15 Total 16 Net Costs to be met from Charges Operating Capital XFer 116 Total $ 145,581,400: 145,581,400 47,097,200 47,097,200 2,535,700 2,535,700 273,377,000 273,377,000 1,126,200 ; 1,126,200 0 0 146,707,600 ; 323,009,900 469,717,500 her Sources (11,590,600) 2,082,800 3,651,300 (5,856,500): 1,664,200 1,327,000 (2,000)' (64,443,500); (68,635,800) 1,325,000 215,343,400 ; 321,684,900 Total Cost of Service (11,590,600) 2,082,800 3,651,300 0 (5,856,500) 1,664,200 1,327,000 (2,000) (64,443,500) (67,310,800) 537,028,300 (a) Required to adjust for normal billing lag andany partial year implementation of increased u increased wastewater rates. 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 82 83 84 85 86 87 A B File: FY2013PAYGORates. UI - Units of Service Inputs c D E F G DRAFT - For Rate Commission Review June 27, 2011 10:05 a.m. H Ver la J-2 In_ filtration/Inflow as a percent of Influent Flow Percent of Total I/I Allocated to Stormwater Percent of Total I/I Allocated to Wastewater Allocation of Infiltration/Inflow: Customer Related Volume Related Capacity Factors Contributed Normal Wastewater Strength Threshold Limits Suspended Solids BOD COD Wastewater Strengths: Average Contributed Average I/I WWTP Influent (Values below should closely match) Calculated Reported J-6 0.0% 100.0% Suspended Solids 220 100 d-4 I 3-Yr Avg. 55.0% of total flow 59.2% 0.0% of total flow 55.0% of total flow 40.0% of Wastewater Allocated 111 60.0% of Wastewater Allocated I/1 1.73 4.19 300 mg/I 300 mg/I 600 mg/I BOD 175 mg/I 10 mg/I A B C F G 88 File: FY2013PAYGORates. DRAFT - For Rate Commission Review 89 SUl - System Units Page 1 June 27, 2011 10:05 a.m. 90 Input Reference BD -19 91 92 94 96 97 . Bissell Point (includes digested sludge pumped from Coldwater Creep) - - j 98 I 2004 48,368 1 132.2 155 ' 309 ; 99 i 2005 48,136 i 131.9 110 175 100 2006 1 41,970 L 115.0 108 ; 184 F 101 2007 43,346 r 118.8 100 1 218 102 2008 51,395 f 140.4 76_ 103 2009 50,401 138.1 79 104 2010 59,339 162.6 58 105 Lemay 106 2004 1 44,638 122.0 89 ; 107 2005 41,318 _ 113.2 75 108 2006 36,339_ 99.6 75 j 109 2007 - 44,358 121.5 78 110 _ 2008 13 LO 68 111 2009 139.9 12 2010 135.4 Fiscal Year Flow Mg Strength Flow BOD ! TSS { mgd ... .1 - mg/( mg/1 47 964 51,080 49,411 13 Coldwater Creek 14 15 116 117 118 119 120 121 % 1. 122 Digested L. J. 123 Solids Coldwater Creek Digested Sludge Adjustment Est. BOD Percent Reduction: 11.0% 124 1 60% 2004 0.219) 1,447. 16,044 ' 2 893 (9 )1 (5,275)- 125 _..__ (8O)1 ( T 2,637)F 29,247 ' 125 1.60% 2005 _. .. (80)i... (0219)7 1,629 _ 16,000, 3,257 I (2,977) (29,247)! (5,954)1 126 1.60% 2006 (80) (0.219}` 1,372 16,000 " 2,744 ! (2,508) (29,247)1 (5,016)1 127 1.60% 2007 80 (0.219), 1,560 ; 16,000 3,120 (2,852)1 (29,247)! _ (5,704) __......__.. t. 128 1.60% 2008 180}; .. (0.219) 1,372 16,044 1 2,744 (2,501) (29,247) (5,002)} 129 1.60% 1 2009 1 (80)L (0.219)1 1,421 t_ __16,000 2,843 (2,598)1 (29,247). (5,197)1 (30 1.60% 2010 (80) (0.219)T 1,874 16,000: 3,748 (3,426) (29,247)1 (6,851)1 1. 131 Missouri River 30.5 II :.. ! 512 44,999 58,728 ' 130,167 0.35 f } - 134 2006 9,836 26.9 164 186 483 ' 40,502: 57,937 1 129,554 ] 0.31 132 2004 [ 1,157 � 177 231 133 r 2005 11,739 , 32.2 I 151 216 1 510: 36,858 3 41,803 ! 114,620. 0.32 135 2007 . 10,237 28.0 1 169 244 L. 561 i 39,531 57,074 ; 131,223 ! 0.30 136 2008 10,029 27.4 L 166 [1 .._. _ _.._ _..__ _. . ....__ . . .__._ 256 ' 550. 37,936 58,504 125,691 0.30 137 } 2009 _ _ I 10,153: _ 27.8 j 158 I 239 511 36,654 ; _ 55,445 118,546 1 _ _ _ 0.31 ' 38 J 2010 11,799 32.3 136 204 452 36,6651 54,998 121,859 0.30 139 ! I I 2004 9,311 j 25.4 2005 11,613 1 31.8 ' 2006 7,283 20.0 2007 8,222 22.5 2008 1. .. 9,503 26.0 2009 10,135 27.8 2010 10,732 29.4 105 98 Loadings COD BOD g/l _Ibs/day_ Ver la J-3 TS5 COD BOD/COD lbs/day L Ibs/day ...1. 414 t 170,834 340,566_( 456,293 r 324 120,986 192,478 : 3 56,3 59 366 1 103,570 : 176,453 1 350,989 334 99,043 ' 215,913 1 330,802 ' 176 261 , 89,006. 206,119 ; 305,665 180 ! 262 90,979 ; 207,293 301,727 165 218 78,640 ' 223,716 1 295,577 -12811- 230. 90,527 128 I 228 I 70,807 I I 127 _ 243 I 62,274 IL 121 1 210 . 79,057 130 187 . 74,321 225 246 1 122,550_ 204 250 110,643 1 130,197 120,843 105,451 122,640 142,084 262,607 230,318 j I 113 130. 308 23,975 27,582 1. 65,348 102 ! 122 291 27,066_ 32,373 77,217 137 172 I 439 22,798 1_ 28,623 L 73,055 138 191 : 417 25,926 LI 35,883 i 78,341 105 ' 150 325' 22,737 32,482 I 70,377 102 169: 337 23,621 39,137 ' 78,042 127 282 485 31,143 69,152 118,931 0.37 0.34 0.30 0.30 0.29 0.30 0.27 233,947 1 0.39 215,252 ' 0.33 201,768 0.31 212,845 i 0.37 204,382 j, 0.36 287_117: 0.43 282,252 1- 0.39 0.37 0.35 0.31 0.33 0.32 0.30 0.26 A B C D E 1 F G 140 141 142 143 144 146 148 149 150 151 152 153 154 155 156 157 158 159 160. 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175, 177 179 180 181 182 183 184 185 186 187 188 189 190 191 192 File: FY2013PAYGORates. DRAFT - For Rate Commission Review SU2 - System Units Page 2 June 27, 2011 10:05 a.m. Input Reference BD -19 Fiscal Year Grand Glaize 2004 6,3961 2005 2006 2007 2008 2009 2010 Strength Loadings Flow Flow BOD mg mgd mg/1 TSS COD mg/1 . mg/1 K Ver la J-4 BOD TSS COD 1 BOD/COD lbs/day lbs/day lbs/day r r 17.5 ; 133 ! 176 1 403 L_ 19,384 25,652 1 58,736 1 0.33 6,764 ' 18.5 1 109 I _ 154 ': 362 ' 16,846 j 23,801 '__ 55,948 _ 0.30 5,636 1 15.4 118 180 ' 427 15,196 i 23,180 f 54,989 0.28 5,739 ! 15.7 110 1 174. 387 `: 14,425 , 22,817 ; 50,748: 0.28 5,751 ' 15.7 ; 105 I 169 381 I 13,760 , 22,147_] 49,929 ] 0.28 5,358 14.7 112 7__ 187 f . � , 389 ; 13,712 ; 22,894 1 47,624' 0.29 5,984 16.4 101 193 365 13,810 26,389 49,907 ' 0.28 Lower Meramec (Baumgartner & Meramec Lagoons) - Estimated Values ; 2004 0' 0.0 01 o 0T 2005 0 1 0 9 F 0! 0 2006 3,881 10.6 1 83 93 r 2007 1,239 t 10.2 124 I 178 j 2008 4,590 12.5 140 202 2009 4,599 12.6 1 130 1 169 2010 5,001 13.7 120 145 Fenton -- - --- 2004 1,447 1r 4.0 2005 _ 1 313 3.6 2006 1,321 ' .__ _.... 3.6 2007 1,649 4.5 1. ------ - ------ 2008 1,837 5.0 ' 2009 1,662 4.6 f 2010 1,902 5.2 Combined Wastewater Treatment Facilities Billable 1 Percent Year Volume I/I Flow _ __. ____.- _ . . .__.._ 2004 2005 2006 s 2007 , 2008 2009 2010 3 -Year Averagel 5 -Year Average' Use!. m�a B-7 166I t 350 161 ._._.. .. 353 274 6941 171 341 139 1 250 206 1 457 , 118 262 01 153 11 369! 390 f 330 318 589 768 ; 952 586r 695 1 1,012 1 579 Strength . Oj 7,360 10,503 14,643I 13,661 I 13,712 01 0 o• 0 8,247 13,568 0.54 15,076 1 31,254 0.34 21,128 j 40,791.1_..._.. 0.36 17,759 1 34,678 ' 0.39 16,5691 36,338 0.38 5,472 11,536 19,414 0.28 4,829 10,587 23,034 0.21 8,270 20,948 28,7351 _ -_0:29 6,443 12,848 22,080: 0.29 5,818 10,465 29,092 0.20 7,823 17,355 , 38,431 0.20 -_ - ------ -. .__. .._ _. ..---------.. ..--- 5,128 11,386 1 25,163 0.20 COD Loadings BOD TSS BOD ____ ._ TSS mg/l J mg/1 1 Ibs/day 1. Ibs/day 1 331 128 1 205 1 349 I 352,555 ; 565,013 0 152.6 1 53.9% 331 101 C 148 311 _ 278,059 1 .37 408,772 0.32 165.8 ' 43.0% 291 105 ` 1551 345 1 253,820 ' 375,457 0.30 160.9 49.9%i 321 102 1 169. 1 320 , 272,074 453,003 0.32 159.6 y 55.4/°1_ 358 86_' 155 1 277 255,720 _! 463,680 0.31 0 151.2 58.6%. 365 101 195 ; 297 306,401 593,243 0.34 i... 145.2 63.2%t 395: 87 I 183 ( 282 1 286,315 , 603,281 0.31 152.0 59.2% 373 r 91 178 286 282,812: 553,401 0.32 156.5 j_ __ 54.8%4 346 96 j 171 ! 304 274,866 j 497,733 0.32 BOD/COD Ratio 55.00%1 100 170 193 194 A B File: FY2013PAYGORates. II - Infiltration/Inflow C 195 196 197 198 199 200 202 203 204 205 206 207 208 210 211 212 213 215 216 217 218 219 221 222 224 225 226 Customer Related Volume Related Line No. 40.0% J_2 60,0%' J-2 Metered Customers 1 Single Family_ 2 Multifamily: Non -Residential 3 Anheuser-Busch 4 All Other 5 Total Unmetered Customers 6 Single Family 7 -- Multifamily Total 8 Total System 9 rSingle Family 10 Multifamily] 11 Non -Residential . 12 Total Wastewater Program 13 Total Stormwater Program 14 Total System 15 Total Treated Wastewater D E F G DRAFT - For Rate Commission Review June 27, 2011 10:05 a.m. H Customer Volume Number of Contributed Related 1 Related Bills Volume j Infiltration Infiltration B-6 3,624,610 248,640 Ccf B-9 24,458,200 8,639,400 12 . 1,306,700 297,650 ! 21,829,400 4,170,912 56,233,700 676,300 ! 7,234,100 233,830 j 4,700,200 910,130 I 11,934,300 4,300,910 31,692,300 482,470 13,339,600 297,662 , 23,136,100 100.0% 5,081,042 0.0%{ 5,081,042 68,168,000 68,168,000 Ver la J-5 (5) Total Infiltration Ccf Ccf Ccf Alloc on (1) Alloc on (2) } (3) + (4) 23,773,800 17,936,000. 4.1,709,800 1,630,800 6,335,600 7,966,400 100 t 958,200 958,300 1,952,300 a 16,008,200 I 17,960,500 27,357,000 ' 41,238,000 j 68,595,000 4,435,900 1,533,700 5,969,600 - 5,305,000 1 9,740,900 3,446,800 4,980,500 8,751,800 ; 14,721,400 28,209,700 23,241,000. 51,450,700 3,164,500 ! 9,782,400 12,946,900 1_952,400 16,966,400 18,918,800 33,326,600 49,989,800 83,316,400 0, 0 33,326,600.; 49,989,800 83,316,400 151,484,400 A B c F G 1 H 1 I 1 J I K 227 File: FY2013PAY GORates. 228 ST R - Strength Allocatio n 229 230 233 235 236 237 238 246 247 DRAFT - F or Rate Commissi on Review June 27, 2011 10:05 a .m. Ver la J-6 234 248 M etered Custo mers 249 Single Family 250 Multifamily 251 Non -Residential 252 Anheuser-Bu sch 253 All Other 255 Total Stre ngths: TSS • BOD 256 Un metered Custo mers 257 Side Family 258 Multifamily 260 Total 261 Surcharl e 262 Anheuser-Busch 263 All O ther 264 Tota l System 265 Sin gle Fames 266 Multifami 267 No n -Residential 268 Surcharge _ 270 Total 271 Total - lbs/day_ 272 _---_. _ _._. Calculated Reported Normal Average Average Percent • Normal Strength Influent ! I nfl uent ' VI of Total ' Strength Limits I/1 Strengths f Strength Stre ngth Flow mg/1 mg/1 mg/1 m l i m l m 1 • J12 3-2 J-2 • J-2 J-2 J-2 220 300 100 1- --- 171 :170 1 55.0 % 175 ; 300 10 - 101 100 j< Values in box sho uld 7------ 'closet' match. (SeeJ-2) Contributed Loadin C ontributed —,-, s g Volume TSS BOD (5) (6) (7). (8) Assigned Assigned I/I Loadings Total L oadings _— I nfiltration ' TSS BOD TSS BOD Ccf pounds po und JJ5 Contr . Vol. x Nor mal Strength s Ccf t pounds _p ou nds i pounds mounds J-5 Assig ned Infll . x I/1 Strengths (2) + (5) (3) +_(6) • 24,458,200 33,576,200 i 26,708,400 : 41,709,800 , 26,026,900 2,602,700 I_59,603,100 T 29,311,100 8,639,400 :' 11,860,200 ! 9,434,200 , 7,966,400 4,971,000 497,100 : 16,831,200 9,931,300 1,306,700. 1,793,800-f 1,426,900 i 958,300 i 598,000 59,800 2,391,800 I,486,700 21,829,400 ; 29,967,400 1 23,837,700 ' 17,960,500 F 11,207,400 1,120,700 T41,174,800 ' 24,958,400 56,233,700 ; 77,197,600 , 61,407,200 68,595,000 42,803,300 4,280,300 120,000,900 65,687,500 7,234,100 9,931,000 7,899,600 9,740,900 , 6,078,300 607,800 16,009,300 8,507,400 4,700,200 6,452,400 5,132,600 ! 4,980,500 3,107,800 310,800 9,560,200 , 5,443,400 11,93 0 16,383,400 r- 13,032,200: 14,721,400. 9,186,100 918,600 25,569,500: 13,950,800 9,400,000 3,200,000 6,600,000 12,800,000 31,692,300. 43,507,200 34,608,000 j 51,450,700: 32,105,200 3,210,500 i 75,612,400. 37,818,500 13, 339,600 , 18,312,600: 14,566,800 j 12,946,900' 8,078,800 807,900 26,391,400 15,374,700 23,136,100' 31,761,200 ; 25,264,600 ; 18,918,800' 11,805,400 1,180,500. 43,566,600 26,445,100 16,000,000 T 16,000,000 —i 68,168,000, 93,581,000 74,439,400 i 83,316,400: 51,989,400 5,198,900 x161,570,400 95,638,300 442,659 . 262,023 A B C D E F G H 273 274 275 276 277 278 279 280 281 283 284 285 286 287 288 289 290 292 293 294 295 297 298 299 300 301 303 304 305 306 File: FY2013PAYGORates. DRAFT - For Rate Commission Review CAPA - Capacity Allocations June 27, 2011 10:05 a.m. Contributed Volume Capacity Factor I/1 Volume Capacity Factor Ver la J-7 Metered Customers Single Family Multifamily Non -Residential Anheuser-Busch All Other Total Unmetered Customers Single Family Multifamily Total Total System Single Family_ Multifamily Non -Residential Total Max Day/Average Day Ratio 1.73 .J-2 4.19 IJ-2 Contributed Volume Ccf_ 1-6 (2) Volume Related Capacity Ccf/day 1.73x(1)/365 24,458,200 115,925 8,639,400 40,948 1,306,700 6,193 21,829,400 A 103,465 (3) nfiltration Volume Capacity Capacity (4) (5) Infiltration 1 Related r Total Ccf Ccf/day Ccf/day J -6 i 4.19x (3)/365 I (2) + (4) 41,709,800 j 478,806 594,731 7,966,400 ' 91,450 1 132,398 958,300 11,001 17,194 17,960,500 206,177 309,642 56,233,700 ; 266,532 ' 68,595,000 787,433 j 1,053,965 7,234,100 4,700,200 34,288 22,278 11,934,300 L 56,565 31,692,300 13,339,600 23,136,100 68,168,000 150,213 63,226 109,659 9,740,900 4,980,500 r. . 4,721,400_ 51,450,700 12,946,900 18,918,800 323,098. 83,316,400 111,820 146,108 57,173 79,451 168,994 225,559 590,626 ' 740,839 148,623 211,849 217,177 i 326,836 956,427 ; 1,279,524 3.08 A B C D E F G H I J K M 307 308 309 310 311 312 313 314 316 317 319 320 321 322 323 324 325 326 328 329 330 331 333 334 335 336 337 338 339 340 341 343 344 345 346 Fite: FY2013PAYG ORates . US - Units of Ser vice DRAFT - For Rate C ommissio n Re view Ju ne 27, 2011 10:05 a.m . Ver la J-8 Line N o. Cu stomer Class Mete red Customers 1 Sin gle Family, 2 Multifamily N on -Residential 3_ An heu ser-Bu sch All Other To tal Tabl e 3-16 Wastewater Units of Service Test Year 2013 (k _. (2) tom..._ ' (4) (5) (6) Volume Capacity ---ty Contributed Ccf J-7 Infiltration I nflow Total Treated Infiltration Total Contributed , Inflow 1 Treated (7) (8) XFer120 (9)(10) Wastewater Strength N on - Suspended 1 All R esidential Solids B OD Customers . Cust om ers Ccf Ccf Ccf/day ! Ccf/d ay Ccfiday Pounds Pounds Bills Equi v. Bills J-7 (1)+(2) J-7 J-7 .. ....... . 24,458,200 41,709,800 66,168,000 115,925 8,639,400 1 7,966,400: 16,605,800 40,9487 91,450 132,398 T 16,831,200 9,931,300_1 248,640 478,806: 594,731 59,603,100 ; 29,311,100 3,624,610 1,306,700 958,300 2,265,000 6,193 11,001 17,194 2,391,800. 1,486,700: 12 12 7 -21,829,400: 17,960,500 I 39,789,900 ' 103,4651-206,177 309,642 • 41,174,800 24,958,400 297,650 1,023,410 . 56,233700 68,595,000 ! 124,828,700: 266,532 1 787,433 ; 1,053,965: 120,000,900: 65,687,500 4,170,912 1,023,422 t Un metere d Custome rs 6 Sin gle Fami 7,234,100 1 9,740,900: 16,975,000 I 7 'Mu ltifamily 4,700,200 4,980,500: 9,680,700 • 34,288 ! 111,820 146,108 1 16,009,300: 8,507,400 676,300-1- 22,278 1 57,173: 79 ,451 9,560,200 11 5,443,400: 233,830 8 Tota l 11,934,300 14,721,400 i 26,655,700 _ Surcharge 9 An heuser-Busch 10 �A llO ther Total System 11 Single Family! 12 Multifamily 13 !Non -Residentia l 14 Surcharge 1- -15 !TOW 56,565 ; 168,994 225,559 25,569,500 13,950,800 , 910,130 9,400,000 1 3,200,000? 6,600,000 ' 12,800,000 31,692,300 1 51,450,700 83,143,000 1 150,213 590,626 1 740,839 , 75,612,400 ' 37,818,500 1 4,300,910 - 13,339,600 12,946,900 26,286,500 1 63,226 ' 148,623 211,849 26,391,400 ; 15,374,700 482,470 _23,136,100 , 18,918,800 42,054,900 a 109,659 217,177' 326,836 ; 43,566,600 26,445,100 297,662 ! 1,023,422 16,000,000 1 16,000,000 • Ccf - H undred Cu bic Feet ' 68,168,000 83,316,400 ! 151,484,400 i _ y...__ 323,098 1 956,427: 1,279,524 : 161,570,400 ; 95,638,300 1 5,081,042 ' 1,023,422 347 348 349 350 351 352 353 354 355 357 A B c 1 D E F 1 G 1 H 1 1 1 File: FY2013PAYGORates. DRAFT - For Rate Commission Review UCOST - Allocated Cost of Service June 27, 2011 10:05 a.m. 1-2 1 1-4 J_8 Line No. LDescription Table 3-17 Allocation of Wastewater Cost of Service to Customer Classes Test Year 2013 359 360 361 363 364 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 [Costs of Service (2) Volume (3) Capacity (4) (5) (6). Wastewater Strength All _ TSS _ HOD_ Customers 1 1Net O&M Expense 1-2 215,343,400 40,505,700 107,481,200 1 20,658,900 ' 26,562,900 r 18,0 2 :Estimated Replacements 1-+ 64 366,600 12,146,400: 42,829,400 1 2,821,900 L 6,568,900 3 Total OM&R 1 279,710,000_ . 52,652,1001 150,310,600 1 23,480,8001 33,131,8001 Net Capital Costs 1-4 257,318,300 10,756,500.: 238,245,400 ! 2,499,000 ' 5,817,400 1 Total `Number of Units 'Units of Service J-8 r 15 Unit Costs - $/unit 7 OM&R Line 3 / Line 6 8 +Total 1 Line 5 / Line 1r Single Family Metered 9 1 Units of Service 10 11 12 Cost - $ 1 Line 9 x Line 8 242,674,400 Unmetered Units of Service Cost - $ I Line 11 x Line 8 59,911,500 Multi Family Metered i 13 f Units of Service 14 Cost - $ !Line 13 x Line 8 54,789,300 CUnmetered 15 1 Units of Service 16 1 Cost - $ ',Line 15 x Line 8 Non -Residential 1 Anheuser-Busch 17 . Units of Service 18 Cost - $ Line 17 x Line 8 7,159,600 All Other 19 Units of Service 20 1 Cost - $ Line 19 x Line 8' 130,642,000 Surcharge Anheuser-Busch 21 Units of Service 22 ` Cost - $ : Line 21 x Line 81 2,814,700 All Other 1 23 1 Units of Service i- 24 Cost - $ Line 23 x Line 8! 6,274,200 1 537,028,300 32,762,600 --fi 25 Total Cost - $ 1 1 Ccf - Hundred Cubic Feet 1 I 'Non -Residential Rounding 1 1 537,028,300 1 63,408,600 } 388,556,000 r 25,979,800 1 38,949,200 I ,484,400 i 1,279,524 Ccf Ccf/day 0.34757 117.47382 0.41858 1 '303.67224 8,300 1 Ver la J-9 XFer l 2l . (7) . Non- Residential Customers 2,116,400 18,018,300. 2,116,400 18,018,3001 2,116,400 161,570,400 95,638,300 5,081,042 [ 1,023,422 Pounds Pounds Bills —1 Equiv. Bills 0.14533 r 0.34643: 3.54618 0.16080 s 0.40726 j _ 3.546 18 27,696,700 ' 180,603,200. 9,583,900 29,311,100 2,853,5101 66,168,000 594 731 59,603,100 11,937,100 + 12,853,5001 16,975,000 146,108 , 16,009,300 8,507,400 1 676,300 7,105,400 44,368,900 2,574,200 3,464,700 1 2,398,300 1 16,605,800 6,950,900 i 9,680,700 4,052,200 132,398 16,831,200 40,205.700 2,706,400 2,265,000 i 948,1001 39,789,900 16,655,300 1 9,931,300 248,640 _ 4,044,600 1 881,700 1 79,451 9,560,200 5,443,400 233,830 I 24,127,100 1,537,200 2,216,900 829,200 1 _ 17,194 2,391,800 r 1,486,700 5,221,400 1_ 384,600 605,500. 309,642 1 4.1,174,800 r 24,958,400. 297,650 1,023,410 94,029,700 6,620,700. 10,164,300 1,055,600 2.116,400 2.06796 2.06796 63,408,600 388,556,000. 1 0+ 9,400,000 3,200,000 1,511,500 1,303,200 6,600,000 f 12,800,000 1,061,300 5,212,906'1 25,979,800 38,949,2001 18,018,3001 100 (100)1 12 2,116,400 A B C D E F G H 411 412 413 414 415 416 417 418 419 420 421 422 423 425 426 427 428 429 430 431 File: FY2013PAYCORates. COMP - COS/Existing Revenue Comparison DRAFT - For Rate Commission Review Ver la June 27, 2011 10:05 a.m. J-10 ine 1 I No. Customer Class 433 434 435 436 438 439 440 441 442 444 445 447 448 449 450 451 452 453 Table 3-18 Comparison of Wastewater Cost of Service With Revenue Under Existing Rates Test Year 2013 Metered Customers 1 j Single Family 2 LMultifamily ;Non -Residential (b) 3 ; Anheuser-Busch 4 All Other 5 1 -Total . _. . .. iUnmetered Customers 6 Single Family 7 Multifamily 8 Total 10 Total System_ Single Family Multifamily J-9 (1) Allocated Cost of Service (2) Revenue Under Existing _ Rates (a) B-15 .1 242,674,400 90,536 400 54,789,300 20,275,800 (3) Indicated Revenue Increase 168.0 170.2 9,974,300 4,641 100 114.9 136,916200 } 61,194,900 123.7 444,354,200 ' 176,648,200 151.5 59,911,500 22,215,800 32,762,600 12,155,700 92,674,100 1 r 302,585,900 4 87,551,900 34,371,500 112,752,200 32,431,500 11 Non -Residential j 146,890 500 65,836,000 12 ;Total 1 537,028,300 ' 211,019,700 13 1 Approved Increase for 2012 ; 1 9,073,800 14 :Adjusted Total , 537,028,300 1220,093,500 (a) 1 Existing Rates effective July 1, 2010. Does not include customer July, 1, 2011. ; 1 (b) ' Includes Cost of Service associated with Surcharges. class impact of approved user charges that will be effective on 169.7 169.5 169.6 168.4 170.0 123.1 154.5 4.3 144.0 XFer122 A B C F G H 454 File: FY2013PAYGORates. 455 COSR - Cost of Service Rate Design 456 50.0% Low Income Subsidy (B-1) 457 458 459 DRAFT - For Rate Commission Review June 27, 2011 10:05 a.m. Ver la J-11 46C 462 463 L 464 Billing & Collection Charge 465 Customer Costs - 466 Total Bills 467 Low Income Adjustment -••- 469 Equivalent Bills I 47C Billing & Collection Charge - $Bill 471 System Availability Charge 472 Customer Related 1/1 473 Customer Related Cap. 1/1 474 Customer Related 1/1 BOD 475 Customer Related 1/1 TSS - 477 Total 478 Equivalent Bills 479 System Availability Charge - $Bi11 480 Compliance Charge 481 Total 482 Non-residential Bills 483 Tier 1 Compliance Charge - $/Bill 484 Volume Charge 485 Volume Contributed 486 Volume Related 1/ 487 Volume Related Capacity 488 Volume Related 111 Capacity 489 Volume Related I/I BOD 490 Volume Related 1/1 TSS 491 BOD Contributed 1 492 TSS Contributed 494 Total 495 Total Billable Volume - Ccf 496 Low Income Adjustment - Ccf 498 Equivalent Billable Volume - Ccf, 499 Volume Charge - $/Ccf 500 Extra Strength Surcharge - $/pound 501, TSS 502 BOD 503 504 505 Total Cost of Service 506 Check 507 Difference 508 Units of Service Check - 509 Infiltration Inflow (1/1) 510 Contributed Volume; 511 Capacity 512 BOD i_ 5 3 TSS 514 68 ,168,000 (102,600) 68,065,4001 JJ=5 J-6, J-7 5,081,042 _ _ (13,370)1 5,067,672 (2) Total Unit Cost $/Unit 9 (3) r (4) (5).. OM&R Allocated Allocated Unit j Total OM&R Cost Cost Cost (1)x(2). L (1)x(3) - .(4)-_(5) -- (66)_. Allocated Capital Cost 18,018,300', 18,018,300 5,067,672 ' 5,067,672 5,067,672 $3.556 $3.556 t $0.000 33,326,600 0.41858 0.34757 13,949,905 11,583,473 2,366,432 382,571 303.67224 , 117.47382 116,176,086 44,942,035 71,234,051 2,079,560 ` 0.40726 0.34643 846,912 720,418 126,494 _20,795,7601- 0.16080 0.14533 3,343,865 3,022,2191 321,646 - 134,316,768 ' 60,268,1451 74,048,623 5,067,672 5,067,672 5,067,672 $26.505__L $11.8931 $14.612 68,168,000 2,116,400 2,116,400 0 1,023,4221 1,023,422 1,023,422 $2.068 $2.068 ; $0.000 0.41858 0.34757 28,533,878 23,693,452 j 4,840,426 49,989,800 0.41858 0.34757 20,924,816 17,375,175 I 3,549,641 323,098 303.67224 ' 117.47382 98,115,785 37,955,514 1- 60,160,271 573,856 303.67224 117.47382 174,264,129 67,413,052 ' 106,851,077 3,119,340 0.40726 0.34643 1,270,368 1,080,627 189,741 31,193,640. 0.16080 0.14533 5,015,798 1 4,533,3281 482,470 74,439,400 0.40726 0.34643 30,315,837 25,787,904 ; 4,527,933 93,581,000: 0.16080 ; 0.14533 ; 15 047 408 13,599,9961 1,447,412 373,488,019 191,439,048 # 182,048,971 -. _... . .. r-- 6.8,0.65,400 68,065,400 68,065,400 $5.488 $2.8131 $2.675 16,000,0061 0.16080 j 0.14533 j 2,572,7291 2,325,258 247,471 16,000,000: 0.40726 ' 0.34643 ' 6,516,084 1 5,542,851 1 973,233 t 83,316,400, 83,316,400 68,168,0001 68,168,000 1,279,524 { 1,279,524 95,638,3001 95,638,300 161,570,400 161,570,400 tai 537,028,300 1537,028,300 iL 0 .� 0 1 1B ase Charge 152,335,068 Compliance 2,116,400 Volume 373,488,019 Surcharge 9,088,813 I Total 1537,028,300 Check , 537,028,300 515 516 517 518 519 520 521 522 524 525 527 528 529 530 531 532 533 534 535 537 538 539 540 541 A B 1 C D E F G H File: FY2013PAYGORates. DRAFT - For Rate Commission Review Ver la UMUC - Unmetered User Charges June 27, 2011 10:05 a.m. J-12 Line No. 2 3 4 5 6 Unit Charge_- $/Ccf Total OM&R 7 Capital Determination of Unmetered Wastewater User Charges Fiscal Year 2013 Billable Volume - gpd Billable Volume - Ccf/mo. Wastewater Charge - $/mo Total 1 Line 1 x Line 41 OM&R , Line 2XLine 4 [Line 5_ Line 6; 2.440 Ccf - hundred cubic feet IOM&R - Operation, maintenance, and replacements ine 3 '365 / 12 / 748 Housing Attributes Water Rooms Closets 5.490 2.813 16 ! 0.651 5.490 ! 5.490 2.813 60 3.57 13.39 1.83 6.86 i 2.813 Separate Showers 5.490 2.813 50 i 50 2.033 2.033 11.16 j - 5.72 5.44 11.16 5.72 5.44 542 543 544 545 546 547 548 549 550 552 553 555 556 557 554 560 562 563 564 565 566 567 568 564 570 571 572 573 574 575 576 577 A B C File: FY2013PAYGORates. RCOMP - Rate Comparison B-11 J-11 me No. 3 10 Billing and Collection Charge System Availability Charge Residential Base Charge Tier 1 Compliance Charge 11.40 0.00' D { DRAFT - For Rate Commission Review June 27, 2011 10:05 a.m. E F G Comparison of Existing and Cost of Service Rates (Proposed Rates Effective July 1, 2012) L.. OM&R Portion 2.60 8.80 Existing Rates (a) H Proposed Rates (a) Capital . . OM&R Capital j Portion . Total Portion C Portion 30.85 Tier 1 Non -Residential Base Charge 42.25 0.00 Volume Charge er Ccf per room per water closet per bath L per separate shower 2.02 1.32 4.93y 4.111 4.11 Extra Strength Surcharge 11 Suspended Solids over 300 m 1 222.62 12 C BOD over 300 mg/1 596.72 13 COD over 600 mg/1 298.36 ,_ Ccf - Hundred Cubic Feet rmg/1_ milligram per liter (a) Rates for qualified low income residential users are 50 percent of the regular rates above. $ 2.60! 8.80 ; 11.89 14.61 11.401 30.85 42.25 356.1- 15.45 0.00 1 3.56 26.50 I 14.61 30.06 2.07 0.00 ( 2.07 1 17.52 14.61 32.13 1 K Ver la J-13 Increase Over Existing 36.8% 201.2% 163.7% -24.0% 2.02 2.81 2.68 5.49 171.7% 1.32 1.83 1.74 3.57 170.5% 4.93 1 6.86 6.53. 13.39 ; 171.6% 4.11 . 5.72 5.44 11.161 171.5% 4.11 I 5.72 5.44. 11.16 ; _ 171.5% i 222.62 ! 290.66 30.93 596.72 I 692.86 121.66 298.36 346.43 60.83 -* 321.60 i 44.5% 814.52 , 36.5% 407.26 i 36.5% A B C D E F G H I J K 578 579 580 File: FY2013PAY GO Rates. PEU C - Projected St ormwater Rates C-18 581 582 583 584 585 586 588 589 590 591 592 593 594 595 596 597 598 60C 60I 602 603 604 605 606 607 608 609 610 611 612 613 614 616 617 618 619 620 621 622 623 624 G-12 _ DRAFT - F or Rate Commissio n Re view J une 27, 2011 10:05 a .m . Bad Debt Provisio n 0.00% percent of the a nnual Stormwater revenue. Stromwater Credit 0.00%percent of the annual Stormwater reve nue . • Table 4-8 Calculatio n and Pr ojection of St ormwater Impervious Rates and Revenue 'Total Revenue Requirements - Basic Services To tal Revenue Requirements - E nha nced Services 'Less: Flat R ate Revenue (a)! Less: Ad Valorem Administratio n Tax (b) 5 Less: Ad V alo rem Stormwater Tax (b) 6 Less: Other Revenue 7 !Less: Interest Income - Reserve Funds 8 Plus: Stormwater Polic _Credit Plus: Bad D ebt Provisions (c) _ Net Cost to be met from Charges 11 Basic Services 12 Enhan ced Services Ver la J-14 2013 2014 2015 2016 18,354,700 ; 18,515,500 18,478,300 18,878,100: 19,178,80L19,237,700 19,237,700 0i 0; 0 o' 0. 0 (1,181,900); (1,356,1001 (1,353,600 (1,352,200) (1,351,100) (1,350,300) (4,903,100); (4,948,100)! (4,993,100) (5,038,100), (5,083,1001 (5,128,100) (9,911 ,700), (10,003,200)] (10,094,700) X0,186,200), (10,277,700))(I0,369,200) (469,400)! _ (481,300), (494,200). (507,900). (521,900)! (536,400) (41,500), (45,000) (45,200)^ (45,800): (46,400)1 X46,800) 0' 0! 0• 0' 0! 0 0! 0o 0' 0' 0: 0 ! 1,847,100 1,681,800 1,497,500 1,747,900L 1,898,600 i 1,806,900 1,847,100 1,681,800 , 1,497,500 1,747,900 ; 1,898,600 r1,806,900 0 0: Pro jected Billable Impervious A rea - 100 sq. ft. 13 : Basic Services I 0 0 0; 0 25,895,250 i 25 767,000 ' 25,684,700 25,602,200 25,519,800 25,437,400 14 En hanced Services 25,846,500 T 25,718,250 25,635,950 25,553,450 25,471,050 : 25,388,650. rProjected stormwater service charge per 100 square feet impervious areal Basic Services i 0.0713 ;- 0.0653 ; 0.1166 0.1365: 0 .1488 0 .1421 En han ced Services 0.0000: 0.0000 0 .0000 0 .0000 0 .0000 ' 0.0000 _ (annu alized rate - billable monthly Projected annual str rmwater serv ice charge (d) - $/100 sq. 15 ' Basic Services 1 0.0000 0.0000 0 .0000 0 .0000 0.0000 0.0000 16 Enhanced Services 0.0000 0.0000 0.0000 0.0000 0.0000 0 .0000 17 Total Charge - 0.0000 0.0000 • 0.0000 0.0000: 0 .0000 ' 0 .0000 18 ; Sto rmwater Service Charge Revenu e 3,625,300 ' 0 i 0 67 0 . 0 19 Indicated Wastewater Support Requirement (1,778,200)? -1,681,800 : 1,497,500 1,747,900: 1,898,600 ! 1,806,900 0. 0000 , 0.0000 'o.0000 , 0.0000 • 0 .0000 (a) ! Flat rate charge were rein stated on August 1, 2010 with multifamily customers charged on per unit basis effecti ve February I, 20 L1. (b) Ad Valorem Taxes were rein stated on August 1, 2010 an d certified___by the Missouri State Au ditor on October 1, 2010{ (c) !,Based on 0% of annual Sto rmwater reven ue. -- - (d) Fiscal Year 2011 includes one month of imperviou s area charge rev enues A B 1 C 1 D E F G FI J K 630 631 632 633 634 635 636 637 638 639 641 642 643 644 645 646 641 .648 649 65C. 651 653 654 655 656 657 658 659 660 661 662 664 665 666 667 668 669 670 671 672 673 674 675 676 677 678 674 680 681 682 683 684 685 File: FY2013PAYGORates. SWCOMP - COS Rates Comparison G-12 ` J-14 Line l No. 1 Stormwater Operations ' Stormwater User Charge Revenue Flat Rate (a) Impervious Area Charges (a) I Ad Valorem Taxes (b) Administration Stormwater -Other Revenue interest Income - Reserve Funds 1 DRAFT - For Rate Commission Review June 27, 2011 10:05 a.m. Ver la J-15 Table 4-8 Comparison of Projected Stormwater Revenue Under Proposed Rates and Taxes with Projected Revenue Requirements Total Stormwater erating Revenue 8 Operation and Maintenance Expense Debt Service 9 !Capital Outlay _I -- 10 I -Cash Financing of Basic Services 11 Cash Financing of Enhanced Services 12 Additions to Operating_ Reserve 13 !Stormwater Policy Credit I4 [Bad Debt Provision (c) 15 (Total Revenue Requirements 16 1Transfer from OMC1 Fund 17 Net Stormwater Operations Annual Balance 18 B Binning of Year Balance 19 ;End of Year Balance OMCI Fund_ 20 IOMCi Revenue Under rProposed Rates _ 21 Interest Income 22 I Less: OMCI Existing Major improvements (d) 23 Less: OMCI Reconfigured Enhanced Service 24 TransfertoOperations ! Test Year 2011 2012 ' 2013 I 2014 2015 - 2016 $ $ 1,181,900 r 1,356,1001 1,353,6001 1,3.52,200 1,351,►00 1,350,300 3,625,300: 0 0 0 i 0 4,903,100 ! 4,948,100E 4,993,100 I 5,038,t00 I 5,083,100 f 5,128,100 9,911,700 ' 10,003,200 i 10,094,700 L 10,I86,200 10,277,700 i _ 10,369,200 469,400 481,300: 494,200' 507,900 , 521,900 t 536,400 - 41,500 45,0001 45,2001 45,8001 46,4001 46,800 20,132,900 16,833,7001 16,980,800 ' 17,130 200 `: 17,280,200 ' 17,430,800 17,738,300 17,720,700 17,887 200 L 18,239,600 ! 18,532,600 18,609,200 ---- ------- 0 544,700 561,000 577,800 595,200 613,000 o 0 0 100 30,100 60,700 526,300 18,354,700 0 0 0 0 0t 0 0 51,000 _-- 15,500 T 0 0 0 0 }... 0 0; 0 0 18,265,500 1 18,478,300 I 18,878,100 ' 0. 0 0' 1,778,200 (1,431,800) (1,497,500) (1,747,900) 8,376,800 10,155,000 8,723,200.1 7,225,700 10,155,000 8,723,200 7,225,700 5,477,800 9,178,800 19,237,700 0 0 (1,898,600) (1,806,900) 5,477,800 3,579,200 3,579,200 - 1,772,300 10,410,000 9,936,000 i 10,035,000 10,239,000 10,264,000_ I0,289 000 425,300 ' 427,800 456,900 5.44,600 653,100 i 7.6.2,9.00 9,400,000. 11,308,000 , 3,730,000 0 C 0 I 0 o 01 0 0' i 25 Net OMCI Fund Annual Balance 1,435,300 ! (944,200)1_ 6,761,900 26 'Beginning of Year Balance i 41,814,1001 43,249,400 42,305,200 27 End of Year Balance 43,249,400 42,305,200 i 49,067,100 �.. .. -1- (a) Fiscal Year 2011 includes one month of impervious area charge revenue: (b) `Ad Valorem Taxes are expected to be phased out by March 2008. _ (c) Based on 0% of annual Stormwater revenue. (d) ; Represents the use of current subdistrict revenue until total depletion, at which time reconfigured subdistrict revenues will replenish, 01 10,783,600 49,067,100 59,850,700 10,917,100: 11,051,900 59,850,700_ 70,767,800 70,767,800 ( 81,819,700 A B C D E F G I-1 J 7 8 9 10 II 12 14- 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33' 34 35 36 37 38 39 File: FY2013PAYCORates. ARATES - Alternative Rates Compliance Charge Weighting I Existing Factors Rates DRAFT - For Rate Commission Review June 27, 2011 10:05 a.m. Ver la K-1 Billing and Collection Charge System Availability Charge Compliance Charge Tier1 Tier 2 Tier 3 Tier 4 Tier 5 Volume Charge per Ccf per room per water closet per bath per separate shower Extra Strength Surcharge 1.000 19.485 41.494 60.839 80.170 J-13 Select Alternative Rates (0 - 4) 4 TY 2013 I 2 3 4 1 4 Cost of Service Alternative Rates Rates ! A Existing Rates i J-13 , x 144 % _2.60 i _ 3.55 6.35 2.65 8.80 . 26.50 30.85 30.85 30.85 30.85 30.85 21.45 9.20 2.05 75.25 31.95 23.00 40.30 75.25 31.95 _ 40.30 85.80 75.25 31.95 85.80 I 125.80 75.25 31.95 125.80 i 165.80 75.25 31.95 165.80 2.02 5.49 1.32 3.57 4.93 13.39 4.11 11.16 4.11 11.16 Suspended Solids over 300 mg/1 222.62 321.60 BOD over 300 mg/1 596.72 814.52 COD over 600 mg/l 298.36 ; 407.26 Ccf - Hundred Cubic Feet mg/1- milligram per liter I 4.93 3.22 12.03 10.03 10.03 543.19 1,456.00 728.00 2.11 1.38 5.15 4.30 4.30 231.35 620.14 310.07 1 5.45 3.55 13.30 T 11.08 11.08 I 267.35 685.94 342.97 Proposed 1 Percent Rates_ J Increase 3.25 3.25 1 26.50 26.50 23.00` 40.30 j 85.80 125.80 165.80 5.45 3.55 13.30 11.08 11.08 267.35 685.94 342.97 25.0% 201.1% -25.4% 30.6% 178.1% 307.8% 437.4% 169.8% 168.9% 169.8% 169.6% 169.6% 20.1% 15.0% 15.0% 40 41 42 43 44 45 46 48 49 50 51 52 53 55 56 A B C D E F G File: FY2013PAYGORates. DRAFT - For Rate Commission Review Ver la PREV2 - Revenue Under Proposed Rates June 27, 2011 10:06 a.m. K-2 J-1 K_3 -t Revenue from Base Total _COS Revenue from Compliance Charge j _ Revenue from Extra Strength Surcharge Revenue from Volume Charge Total Cost of Service, ! I 1 537,028,300 Revenue Under Proposed Rates Billable Proposed Units 1 Rates $ Ccf $/Ccf 150,763,500 7,337,800 7,592,000 371,627,800 j 68,065,338 537,321,100 5.46 A B C F G H 57 58 59 60 61 62 63 65 66 68 69 70 71 72 74 75 76 77 File: FY2013PAYGORates. DRC - Detailed Revenue Calculation DRAFT - For Rate Commission Review June 27, 2011 10:06 a.m. Ver la K-3 Total Bills B-6 Surcharge Loads 13-10 B Volume & Fixtures -9 1 Low Income Billing Units B-14 ! (1) . . �. (2) (3)_ Billable Units General Low - Service .._ Service 1 Income Total Metered Customers Single Family Bills Volume Total Multifamily Bills Volume 79 Total 80 Non -Residential 81 Anheuser-Busch 82 Bills 83 Tier 1 Bills 84 Volume 85 All Other 86 Bills 87 Tier 1 Bills 88 Tier 2 Bills 89 Tier 3 Bills 90 Tier 4 Bills 91 Tier 5 Bills 92 Volume _ 93 Surcharge 94 Anheuser-Busch 95 SS 96 BOD 97 COD 98 All Other 99 SS 100 BOD 101 COD 103 Total 104 105 Unmetered Customers 106 Single Family 107 Bills 1 3,608,850 24,359,300 j 15,760t 3,624,610 I 98,900 } 24,458,200 246,840 1,800 , 248,640 t 8,639,400 { 0 8,639,400 ' 12 12 1 1,306,700 297,650 279,900 5,210 8,040 2,710 1,790 21,829,400 4,700 1,600 T- 3,300 [ 5,100 2,500 " 108 Rooms 109 Water Closets 110 Baths 111 _ Separate Showers 113 Total 114 Multifamily _ 115 Bills 1 668,020 4,541,630 [ 968,240 765,250 133,700 i _ L 232,930 116 Rooms 2,667,090 1. 117 r Water Closets ' 667,360 118 Baths 621,750 119 Separate ShowersF 27,190 121 Total 123 Total Revenue 124 Revenue from Base 125 Revenue from Compliance Charges 126 Revenue from Extra Strength Surcharges 127 Revenue from Volume Charges 1 28 (4) (5) . . Proposed Rates General ' Low - Service 1 Income S/Unit KK1 29.75! 5.45 1 $/Unit (4) x 50% (7) Revenue (8) General i Low - Service 1 Income $ $ (1)x (4) (2) x (5)_ 14.880 1107,363,300 2.730 1 132,758,200 [ 240,121,5001 Total (6)+(7) 234,500 1 107,597,800 270,000 4 133,028,200 504,500 240,626,000 29.75: 14.880 1 7,343,500 _26,800 5.45 2.730: 47,084,700 0 12 ' 29.75 12 23.00 1,306,700 5.45 297,650 ! 29.75 279,900 23.00 5,210 1 40.30 8,040 85.80 2,710 125.80_ 1,790 165.80 21,829,400 i 5.45 4,700 267.35 €,600 685.94 0 , 342.97 3,300 267.35 5,100 685.94 [ 2,500 _ 342.97 8,280 676,300 i 57,170 4,598,800 1 11,560 979,800 t 9,950 775,200 1,700 135,400 900 4 233,830 10,310 2,677,400 ' 2,340 669,7001 2,250 624,000 110 27,300 i 29 Impact of low-income program on typical residential customer with 8 Ccf/month billable volume 54 428 200 j 26,800 400 300 '- 7,121,500 8,855,100_ 6,437,700f 210,000 689,800 340,900 { 296,800 118,970,200 1,256,500 i €,097,500 0J 882,300 3,498,300 1 857,400 -I-150,514,700 7,370,300 47,084,700 54,455,000 400 300 7,121,500 8,855,100 0 i 6,437,700 210,000 689,800 340,900 296,800 118,970,200 0 1,256,500 1,097,500 0 882,300 3,498,300 _ 857,400 0 _150,514,700_ 2.9.75 i 14.880 19,873,600 1 123,200 ; 19,996,800 3.55 4 1.780 16,122,800 l 101,800 { 16,224,600 13.30 ! 6.650 12,877,600 ! 76,900 1 12,954,500 11.08. 5.540' 8,479,000 j 55,100 ' 8,534,100 11.08 5.540 1,481,400 ! 9,400 j 1,490,800 58,834,400 1 366,400 59,200,800 29.75 14.880 4 6,929 700 1 13,400 6,943,100 3.55 j 1.780 ! 9,468,200 18,400 1 9,486,600 13.30 1 6.650 i 8,875,900 15,600 8,891,500 11.08 f 5.540,4 6,889,000 12,500 1 6,901,500 11.08 5.540 301,300 600 301,900 32,464,100 _ 60,500.1 32,524,600 536,362,9001 958,200 , 537,321,100 150,365,600 397,900 ! 150,763,500 7,337,800 1 0 . 7,337,800 7,592,0001 0 i 7,592,000 371,067,500 560,300 , 371,627,800 j . i $0.113 1/bill A B C D E F G 131 132 133 134 135 136 137 I38 139 140 141 142 143 145 146 147 148 File: FY2013PAYGORates. DRAFT - For Rate Commission Review Ver la COMP2 - Proposed/COS Revenue June 27, 2011 10:06 a.m. K-4 Table 3-23 Comparison of Wastewater Cost of Service With Revenue Under Proposed Rates Test Year 2013 Line No. 149 150 151 153 154 155 156 158 159 160 161 162 164 165 166 167 168 Customer Class Metered Customers 1 Single Family' 2 Multifamily _Non -Residential (a) 3 Anheuser-Busch 4 All Other Total Unmetered Customers 6 Single Family] 7 Multifamily 8 Total Total System 9 ' Single Family; 10 Multifamily 11 Non -Residential (a) 12 Total (a) Includes revenue and surcharge customers. (1) Revenue Under Proposed Rates K-3 (2) (3) Revenue As Allocated a Percent Cost of of Cost of Service Service $ J-9 240,626,000 242,674,400 54,455,000 54,789,300 9,476,200 9,974,300 141,038,509_ 136,916,200_ 445,595,700 59,200,800 32,524,600 91,725,400 444,3 54,200 59,911,500 32,762,600 % (1)/(2) 99.2 99.4 95.0 103.0 100.3 98.8 99.3 92,674,100 i 99.0 299,826,800 ; 302,585,900 99.1 86,979,600 87,551,900 99.3 150,514,700 146,890,500 } 102.5 537,321,100 ' 537,028,300 100.1 allocated cost of service associated with XFer126 A 1 13 C D E G H K 169 170 File: FY2013PAYGORates. DRAFT- For Rate Commission Review TB - Typical Bills June 27, 2011 10:06 a.m. Ver la K-5 171 172 173 174 175 177 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 No. ;Customer Class }Single Fami Small IMedium Medium per 50 Largest Cities Large *e - Multifamily Small Medium Large_ 1. Billed Vastewater Volume Ccf B8 $ $ $ K-1 .. K-8 iC 8 (a) 5 21.50 1 21.50 22.40 8- } ._.-- {. ... . . _.._ -_- I 28.73 10 31.60 31.60 20 51:80 51.80 32.95 27.56 27.56 ' r 54.05 [XFer12 for Bonds Typical Bill Comparison Existing Typical Wastewater Bills Rates 2011 . 2012 J 2013 i 2014 1 2015 2016 r - $ $ $ - - $-- K-8 K-8 K-8 K-8 57.00. 57.30 57.6574 73.35 73.65 .00 84.25 I 84.55 I 84.90 ' 138.75 1 139.05 : 139.40 I 58.05 74.40 85.30 139.80_ 20 51.80 : 51.80 54.05 13875 I 139.05 j 139,40 139.80 40 92.20 , 92.20 96.25 247.75 248.05 248.40 ! 248.80 60 132.60 132.60 138.45 : 356.75 357.05 357.40 L 357.80 Non -Residential - Notmal Strength with Tier 2 Env_ ironmental Compliance Charge 8 70 1 183.65 , 183.65 r 191.50 � Small 91 Medium 1 . 100 : 244.25 244.25 254.80 10 Medium per 50 Largest Cities 134 I. 312.93 L 312.93 326.54 11 1 Large 160 1 365.45 1 365.45 381.40 T E. I Non -Residential - Excess Strength with Tier 2 Environmental Compliance Charge (b) , T _ 70 210.49 i 210.49 100 ' 282.60 1 282.60 160 1 426.80 1 426.80 1 l2 Small 13 Average 14 Carge . . . _ __. iCcf- Hundred Cubic Feet 451.55 1 454.25 456.10 . 457.85 615.05 617.75 619.60 ; 621.35 800.35 : 803,05 [ 804.90 806.65 942.05 ' 944.75 946.60 948.35 219.39 482.78 485.48 294.65 659.66 _ 662.36 445.16 1,013.4 1,016.13 (a) Based on proposed 2012 approved rates to be effective July I, 2011. j (b) Assumes suspended solids excess strength of 150 m9/1 and biochemical oxygen demand excess strenl th of 150 mg/l. t T.. (c) Assumessuspended solids excess strength of 1155 mg/land biochemical oxygen demand excess strength of 390mg/I. 15 Anheuser-Busch (c) 1 281,000 T 997,121 C 997,121 1 1,039,260 1 2,036,762 ; 2,036,755 487.33 664.21 1,017.98 489.08 665.96 1,019.73 2,036,748 2,036,742 210 211 212 213 214 215 216 217 218 219 220 222 223 224 226 227 228 229 230 231 232 233 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 A B C D E F G File: FY2013PAYGORates. DRAFT - For Rate Commission Review Ver la PRATES - Proposed Rates June 27, 2011 10:06 a.m. K-6 J-11 J12 K=1 Table 3-19 Proposed Wastewater Rates User/Capital Charge Breakdown (Rates Effective July 1, 2012) No. i Type of Monthly Charge Base Charge - $/Bill 1 Billing & Collection Charge 2 System Availability Charge 3 Total Base (Residential) Service Charge ,Compliance Charge - $/Bill (a) 4 Tier 1 5 Tier 2 6 Tier3 7 Tier 4 8 Tier 5 (Total Nonresidential Service Charge i Tier 1 Tier 2 Tier 3 Tier 4 Tier 5 Volume Charge 9 Metered - $/Ccf Unmetered - $/Bill 10 Each Room 11 Each Water Close 12 Each Bath! 13 Each Separate Shower Extra Strength Surcharges - $!ton (a) 14 Suspended Solids over 300 mg/1 15 j BOD over 300 mg/1 16 1 COD over 600 mg/1 Ccf - Hundred Cubic Feet mg/1,-milligram per liter (a) Applicable only to non-residential customers. User L Charge XFer123 Total Capital Wastewater Charge Charge 3.25 0.00 11.88 14.62 15.13 j 14.62 1 23.00 40.30 0.00 85.80 0.00 125.80 0.00 165.80 0.00 38.13 14.62 55.43 14.62 100.93 14.62 r 140.93 14.62 180.93 14.62 3.25 26.50 29.75 23.00 40.30 85.80 125.80 165.80 52.75 70.05 115.55 155.55 195.55 2.77 2.68 5.45 1.83 1.72 6.86 6.44 5.72 , 5.36 5.72 1 5.36 290.66 1 692.86 346.43 1 (23.31) (6.92)- (3.46)1 3.55 13.30 11.08 11.08 267.35 685.94 342.97 259 260 261 262 263 264 265 266 267 269 270 A B C D E F G File: FY2013PAYGORates. DRAFT - For Rate Commission Review Ver la PRATES2 - Proposed Rates 2 June 27, 2011 10:06 a.m. K-7 K-1 Table 3-20 Proposed Wastewater Rates by Customer Class (Rates Effective July 1, 2012) Line No i Type of Monthly Charge J 272 273 274 275 277 278 279 280 281 282 283 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 Base Charge - $/Bill 1 Billing and Collection Charge _ 2 System Availability Charge 3 j Total Base (Residential) Service Charge 6 Compliance Charge (a) Tier 1 Tier 2 { Tier 3 Tier 4 8 Tier 5 Total Nonresident Tier 1 Tier 2 Tier 3 Tier 4 Tier 5 - r 9 I per Ccf 10 per room 11 ! per water closet 12 { per bath ! 13 per separate shower Service Charge (a Volume Charge Extra Strength Surcharge - $/ton (a) 14 Suspended Solids over 300mg/1 15 BOD over 300 mg/1 16 t COD over 600 mg/1 Ccf - Hundred Cubic Feet mg/l.- milligram per liter (a) Applicable only to non-residential customers. Note__ : Rates for qualified low income residential users are 50 percent of the i regular rates above. XFer124 Metered Unmetered 1 Non - Residential f Residential Residential $ ( $ 3.25 26.50 29.75 3.55 13.30 11.08 11.08 3.25 26.50 29.75 5.45 $ 3.25 26.50 29.75 23.00 40.30_ 85.80 125.80 165.80 52.75_ 7.0.05 115.55 _ 155.55 195.55 5.45 267.35 685.94 j 342.97 308 309 310 311 312 313 314 315 317 A I B I C File: FY2013PAYGORates. D E F G DRAFT - For Rate Commission Review CRATES - Comparison of Rates June 27, 2011 10:06 a.m. Line ':. No. Type of Mon 319 320 321 322 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355, 357 358 359 360 361 362 363 364 365 H 1 1 Table 3-21 Comparison of Existing and Proposed Wastewater Rates tBase Charge $/Bill _ _ i Billing & Collection Charge 2 System Availability Charge- _._ _... , .. - -- _ �._ .. _.. ._._. 3 Total Base (Residential) Service Charge ]Compliance Charge - S/Bill (b) _ 4 1 Tier I 1 5 j Tier 2 6 Tier 7 J Tier.4 1 Tier 5 1 Tier l Tier 2 Tier 3 Tier 4 j 1 Tier 5 �Total Nonresidential Service Charge Volume Charge 9 Metered - $/Ccf Unmetered - $/Bill 10 Each Room 11 1 Each Water Closet 12 rj Each Bath 13 I Each Separate Shower Extra Strength Surcharges - $/ton (b) 14 Suspended Solids over 3.00 mg/( _ 15 1 BOD over 300 mg/1 16 1 COD over 600 mg/1 1 Typical Residential Bill - S/Bill (c) 17 User Charge Portion 1 18 Capital Charge Portion 19 } Total '4 Ccf - Hundred Cubic Feet mg/l -milligram per liter (a) '2012 approved rates to be effective July I, 2011. (b) ' Applicable only to non-residential customers. (c) !Based on contributed wastewater volume of 8 Ccf per month. Low Income Impact on Typical Residential Bill - SICcf Annual Percentage Increase in Typical Residential Bid Proposed Wastewater Charges K Ver la K -S j XFerl25 Existing K-i 1. _ 2.60 x-- 8.80; 11.40 30.85 30.85 30.85 1 30.85 30.85 42.25 1 42.25 42.25-1- 42.25' 42.25 2011 . 2012 (a) , 2013 2014 2015 2016 K-1 K -1 K-1 2.60 2.651 8.80 I. 9.20 11.40; 11.85 1 30.85 1 30.85 30.85 30.85 30.85 42.25 1 42.25 42.25 1 42.25 42.25 31.95 31.95 f 31.95 3I.95 1 31.95 43.80 I 43.80 43.80 43.80 43.80 2.02 2.02 2.11 1.32 1.32 4.93 1 4.93 4.11 I 4.11 4.11 . 4.11 i F 222.62 j 222.62 231.35 t 596.72 ;_ 596.72 620.14 1 298.36 298.36 1 310.07 I K -I K -I 3.25 > 3.45 26.50 26.60 29.75 r 30.05 r-- 23.00 40.30 85.80 1 125.80 165.80 16.00 42.70 90.90 133.30 175.65 K-1 1 - - 3.60 j 3.70 26.80 " 27.10 30.40 30.80 9.00 44.20 j 94.20 E 138.10 181.95 2.35 45.55 97.05 142.30 187.50 52.75 46.05 39.40 r 33.15 70.05 72.75 74.60 _ 76.35 115.55 120.95 124.60 ' 127.85 155.55 163.35 168.50 173.10 195.55 1 205.70 212.35 218.30 5.45 I 5.45 j 5.45 ; 5.45 1.38 1 3.55 3.55 1 3.55 3.55 5.15 1 13.30 ` 13.30 13.30 13.30 4.30 11.08 11.08 11.08 11.08 4.30 11.08 11.08 11.08 11.08 267.35 1 685.94 342.97 1 267.35 _ 267.35 267.35 685.94 j 685.94 i 685.94 342.97 ( -_342.97 1 342.97 26.30 ! 24.28 26.19 37.29 ' 30.71 III 1.26 1.26 2.54 36.06 42.94 27.56 ' 27.56 1 28.73 ' 73.35 I 73.65 ; 33.41 . 35.31 40.59 t 39.09 74.00 j_ 74.40 50.031 1 $0.039 1 $0.108 1 $0.126 , $0.154 0.00%1 4.25%1 155.31%'. 0.41%' 0.48%1 $0.174 0.54% 366 367 368 369 370 371 372 373 375 A B c File: FY2013PAYGORates. D E F G H DRAFT - For Rate Commission Review Ver la COMR - Comparison of OM&R Rates June 27, 2011 10:06 a.m. K-9 Comparison of Existing and Proposed User Charges Line No. Type of Monthly Charge (OM&R Portion of Rates 377 378 379 380 382 383 384 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 405 406 407 408 409 410 411 Base Charge - $Bill 1 Billing & Collection Charge 2 - - System Availability Charge 3 f Total Base (Residential) Service Charge 4 { Tier 1 Compliance Charge - $/Bill (a) 5 1 Total Tier 1 Nonresidential Service Charge Volume Charge __ 6 Metered - $/Ccf Unmetered - $Bill 7 t Each Room 8 Each Water Closet 9 Each Bath[ 10 L Each Separate Shower 2 Extra Strength Surcharges - $/ton (a) Suspended Solids over 300 mg/I BOD over 300 mg/1 13 COD over 600 mg/1 Typical Residential Bill - $Bill (b) 14 User Charge Portion 15 Capital Charge Portion 16 Total Ccf - Hundred Cubic Feet mg/i - milligram per liter (a) (Applicable only to nonresidential customers. (b) Based on contributed wastewater volume of 8 Ccf per month. Existing K-1 2.60E 8.80 11.40 30.85 • 42.25 1 1.32 4.93 4.11 4.11 Proposed User Charges 2.60 8.80 _l 11.40 2012 2013 K-6 i K-6 2.65 6.41 3.25 11.88 9.06 15.13 30.85 31.95 42.25 41.01 1.32 4.93 4.11 4.11E 1.03 3.86 3.22 3.22 222.62 222.62 178.05 596.72 596.72 515.70 298.36 298.36 257.85 23.00 38.13 2.77 1.83 6.86 5.72 5.72 290.66 692.86 346.43 26.30 26.30 26.19 37.29 1.26 1.26 2.54 36.06 27.56 27.56 28.73 ; 73.35 A B 1 C D E F G H 412 413 414 415 416 418 419 420 File: FY2013PAYGORates. DRAFT - For Rate Commission Review Ver la CVC - Component Volume Charges June 27, 2011 10:06 a.m. K-10 k22 I K-6 Volume Charge Components 421 422 424 425 Volume Component ; _... .... . Wastewater Strength Components ' BOD !175 parts/1,000,000 parts x 6,240 lbs/Ccf / 2,000 lbs/ton x $685.94/ton = SS 220 parts/1,000,000 parts x 6,240 ibs/Ccf / 2 j Total Volume Charge Volume Charge $/Ccf 4.90 0.37 0.18 5.45