Bonne Terre, MO, Proposed Sewer Rates Scenario 2.7
<br /> Chart 1 B-Costs and Net Income n.,.rs�_•<,., s
<br /> (First year costs and net incomes areactuat,subsequent Inflation/De-
<br /> years are projected.) flation(-)Year Beginning Year Beginning Year Beginning Year Beginning Year Beginning Year Beginning Year Beginning Year Beginning Year Beginning Year Beginning Year Beginning
<br /> Factor 10/1/05 10/1/06 10/1/07 10/1/08 1011/09 1011/10 10/1/11 10/1112 10/1/13 1011114 10/1/15
<br /> Salaries,Benefits,Training for Administration Staff 3,0% $0 $0 $0 $0 $0 $0 _ $0 $0 $0 $0 $0
<br /> Billing,Office Operation,Rent&Other Overhead 5.0% $41,937 $44.034 $46,236 $48,547 $50,975 $53,523 $56,200 $59,010 $61,960 $65,058 $68,311
<br /> Insurance&Bonding 5.0% $13,412 ,_$14,083 $14,787 $15,526 $16,302 $17,117 $17,973 $18,872 $19,815 $20,806 $21,847
<br /> Accounting,Legal,Engineering,Medical,etc. 3.0% $0 .___$0 $0- $0 _ $0 $0 -_ _- _$0 s0 . _ _$0 $0 $0
<br /> Existing Debt and Related Expenses 0.0% $972,816 $972,816 $972,816 $972,816 ___$972,816 $972,816_ -_ $972,816____ _$972,816__ $972,816 $972,816 $972,816
<br /> Existing Debt Reserve Payments 0.0%_____ $0 $0 _ $0 - _$0__ $0 $0 $0 $0 $0 $o $0
<br /> Other Reserve Payments 0.0%____--$0 __--__$0 $0 $0- __-_ $0___----___$0 $0. ..._._.__ $0 ._ $0 $0 $0
<br /> Salaries,Benefits,Training for Operations Staff 5.0%____$14,335 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
<br /> Electricity&Utilities for Operations 5.0% $68,948 $72,395 $76,015 __$79,816 __ $83,807 $87,997 . _ $92,397___- _$97,017 _ $101,868 $106,961 $112,309
<br /> System Improvements 5.0% $3,633 $3815 $4,005__ $4,206 $4,416 $4,637_ $4,869 _ $5,112 __ _$5,368_ _ -__$5,636_ $5,918
<br /> Chemicals&Supplies 5.0% $1,199 $1,259_- s1,322_____ $1,388 $1,458 $1,530 $1,607 $1,687 $1,772 $1,860____ $1,953
<br /> Sludge Removal 5.0%_ $73,958____$38,828 $40,769 __142,808 _$44,948-,_ _$47,195____$49,555 $52,033 _ $54,635 $57,366 $60,235
<br /> Regular Maintenance&Repairs 5.0%__ -$61,318__ $48,288_ $50,703 __ _$53,238_.____ $55,900 -_ $58,695 _-__$61_629_ __$64,711 __-_$67,946 .......$71,344 $74,911
<br /> Vehicle Maintenance,Fuel,Insurance 5.0% $10,482 $11,006 $11,556 $12,134 $12,741 $13,378 $14,047 $14,749 $15,487 $16,261 $17,074
<br /> Tools and Equipment 3.0%___$2,102 $2,165_ ___$2,230------$2,297 $2,366-----__$2,437___$2,510__ $2,586 $2,663 __$2,743 $2,825
<br /> Capital Expense 0.0% $19,406 $19,406__ _$19,406 $19,406 $19,406_____$19,406__ $19,406 $19,406 $19,406 _ _ $19,406
<br /> Payment to Replacement Account 0.0% $111,606 $111,606 _ $111_606 $111,606__$111,606 ----$111,606 _ $111,606_$111,606 $111,606 $111,606 $111,606
<br /> Surchargeable Sewer Services(Adjustment) 5.0% _ $0 $0 _ $0 $0 _ _ $0 $0 $0 $0 _ $0 $0 $0
<br /> Inflow&infiltration(Adjustment) 1.0% $0 ---------$�-----------$0------ $�--------- $0 ___$�-------- -$0---------$0----------$0- $0-
<br /> Dues,Training,Uniforms 5.0%_ $1,274 _ $1,337 $1,404 $1,474 _$1,548 $1,625 $1_707 __ $1,792 $1,882 $1,976 _ $2,075
<br /> Professional Services-Alliance 4.5% $235,644 $224,040___.$234,122 __$244,657 $255,667 _$267,172 $279,195 __ $291,758 $304,887 $318,607 $332,945
<br /> Payment to Debt Service Account 5.0% $20,997 $22,047___ $23,149___ $24,307 $25,522 ______$26.798_______$28,138__ $29,545 $31,022 $32,573 $34,202
<br /> Assumed Cost Increase 5%for New Facil 5.0% $0 $0 $0 $80,521 $84,547 $88,774 $93,213 $97,873 $102,767_ $107,905 $113,301
<br /> Temporary Hold on Replacements 0.0% f$96 EUS) _-=5966061___ ,.__$0 ___ $0_ $0 $0 ___$0 __ $0 $0 $0 $0
<br /> User Charge Analysis Services&Staff Time 5.0% _$0 $4,761 $285 $285_ $5,249 $314 $314 $5,787 $346 $346 $6,380
<br /> Total Operating Costs$1,556,461 $1,495,279 $1,610,411 $1,715,032 $1,749,272 $1,775,022 $1,807,181 $1,846,359 $1,876,246 $1,913,272 $1,958,112
<br /> Net Income(or Loss) ($0) $180,926 $316,320 $424,087 $578,843 $794,324 $894,995 $962,542 $1,047,547 $1,128,151 $1,209,847
<br /> Working Capital Goal:35% In Dollars,That is: $544,761 $523,348 $563,644 $600,261 $612,245 $621,258 $632,513 $646,226 $656,686 $669,645 $685,339
<br />
|