Loading...
HomeMy WebLinkAboutExel 2015 Final Scenario2015 2016 2017 2018 Revenue Rate $10,573,975 $10,668,833 $10,764,640 $10,861,405 Misc 586,047 576,213 589,021 590,626 Total $11,160,022 $11,245,046 $11,353,661 $11,452,031 Expenses O&M $7,960,471 $8,158,152 $8,361,502 $8,570,689 CIP from Rates 952,004 2,700,000 2,777,000 2,856,230 Net Debt 2,261,112 1,646,884 1,648,180 1,646,885 Working Capital 150,706 155,227 159,884 164,680 Total $11,324,293 $12,660,263 $12,946,566 $13,238,484 Bal/(Def) ($164,272) ($1,415,217) ($1,592,905) ($1,786,453) Rate Adjustment 0.0% 6.0% 5.0% 3.0% Additional Rate Revenue $0 $640,130 $1,216,404 $1,590,001 Bal/(Deo after Adj. ($164,272) ($775,087) ($376,500) ($196,452) 2014 Add'I Pipeline Replcmnt $0 $600,000 $618,000 $636,540 Input Pipeline Replacement 0 600,000 618,000 636,540 $10,000,000 $8,000,000 $6,000,000 $4,000,000 $2,000,000 $0 $90.00 �Rn nn 2015 Water Reserve Fund 2016 2017 2018 20 Total Ending Reserve Balances Residential Average Mo yvv.vv $70.00 $60.00 $50.00 $40.00 $30.00 $20.00 $10.00 $0.00 2016 2017 2018 2019 Proposed Rate Residential Monthly Average Rate [1] $60.48 $60.48 $60.48 $60.48 After Proposed Rate AdjustmE $60.48 $64.11 $67.31 $69.33 Monthly $ Change 0.00 3.63 3.21 2.02 Cumulative $ Change 0.00 3.63 6.83 8.85 [1] Residential Monthly Average Rate does not include zone surcharges; assumes 3/4" Meter a 2019 2020 2021 2022 2023 2024 $10,959,138 $11,057,848 $11,157,545 $11,258,239 $11,359,940 $11,462,658 595,471 602,858 609,885 620,838 636,022 651,818 $11,554,609 $11,660,706 $11,767,430 $11,879,077 $11,995,962 $12,114,476 $9,035,885 $9,264,768 $9,500,245 $9,742,511 $9,991,769 $10,248,223 2,682,119 3,021,643 3,107,963 3,896,785 4,188,184 4,188,185 1,650,439 1,647,880 1,483,609 603,445 604,873 601,233 169,621 174,709 179,950 185,349 190,909 194,964 $13,538,064 $14,108,999 $14,271,767 $14,428,090 $14,975,735 $15,232,605 ($1,983,455) ($2,448,294) ($2,504,337) ($2,549,013) ($2,979,772) ($3,118,129) 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% $1,981,212 $2,390,764 $2,819,415 $3,267,952 $3,737,195 $4,227,997 ($2,243) ($57,530) $315,078 $718,939 $757,423 $1,109,868 $655,636 $675,305 400,000 675,305 -Proposed Rates $695,564 $716,431 695,564 716,431 $737,924 $693,650 737,924 693,650 119 2020 2021 2022 2023 2024 Minimum Fund Balance inthly Bill Comparison $60.48 $60.48 $60.48 $60.48 $60.48 $60.48 $71.41 $73.56 $75.76 $78.04 $80.38 $82.79 2.08 2.14 2.21 2.27 2.34 2.41 10.93 13.08 15.28 17.56 19.90 22.31 nd 5,000 gallons Balance Rate Funded Capital