Operating Revenues
<br />Usage Fee
<br />Other
<br />Total Operating Revenues
<br />Operating Expenses (including depreciation)
<br />Personal Services
<br />Supplies
<br />Depreciation
<br />Other Services & Charges
<br />Total Operating Expenses
<br />Net Operations (including depreciation)
<br />Non-operating revenues (expenses)
<br />Connection Charges
<br />Investment income
<br />Other income (expense)
<br />Total non operating revenue (expenses)
<br />Sewer Fund
<br />Actual Budget Budget I Estimate
<br />2015 2016 2017 2018 1 2019 2020 2021 2022 2023
<br />1,812,117
<br />1,917,991
<br />1,915,000
<br />2,020,000
<br />2,161,245
<br />2,273,929
<br />2,391,429
<br />2,516,744
<br />2,648,244
<br />6,359
<br />3,199
<br />4,000
<br />102,000
<br />2,000
<br />2,000
<br />2,000
<br />2,000
<br />2,000
<br />1,818,476
<br />1,921,190
<br />1,919,000
<br />2,122,000
<br />2,163,245
<br />2,275,929
<br />2,393,429
<br />2,518,744
<br />2,650,244
<br />453,554
<br />581,334
<br />550,800
<br />640,500
<br />653,310
<br />666,376
<br />679,704
<br />693,298
<br />707,164
<br />108,816
<br />114,855
<br />206,800
<br />195,000
<br />204,750
<br />214,988
<br />225,737
<br />237,024
<br />248,875
<br />1,017,240
<br />983,689
<br />1,425,000
<br />1,425,000 '
<br />1,425,000 '
<br />1,425,000 '
<br />1,425,000 '
<br />1,425,000 '
<br />1,425,000
<br />461,914
<br />532,855
<br />552,000
<br />626,950
<br />658,298
<br />691,212
<br />725,773
<br />762,062
<br />800,165
<br />2,041,524
<br />2,212,733
<br />2,734,600
<br />2,887,450
<br />2,941,358
<br />2,997,576
<br />3,056,214
<br />3,117,383
<br />3,181,203
<br />(223,048)
<br />(291,543)
<br />(815,600)
<br />(765,450)
<br />(778,112)
<br />(721,647)
<br />(662,784)
<br />(598,639)
<br />(530,959)
<br />748,936 587,300
<br />90,135 48,005
<br />1,718,360 663,356
<br />2,557,431 1,298,661
<br />500,000 500,000 515,000 530,450 546,364 562,754 579,637
<br />80,000 80,000 41,906 43,084 45,217 48,360 52,612
<br />580,000 580,000 556,906 573,534 591,580 61 1,1 14 632,249
<br />Cash Available for Capital Outlay
<br />Net operations including depreciation
<br />(223,048)
<br />(291,543)
<br />(815,600)
<br />(765,450)
<br />(778,112)
<br />(721,647)
<br />(662,784)
<br />(598,639)
<br />(530,959)
<br />Add non operating revenues
<br />2,557,431
<br />1,298,661
<br />580,000
<br />580,000
<br />556,906
<br />573,534
<br />591,580
<br />611,114
<br />632,249
<br />Add back depreciation
<br />1,017,240
<br />983,689
<br />1,425,000
<br />1,425,000
<br />1,425,000
<br />1,425,000
<br />1,425,000
<br />1,425,000
<br />1,425,000
<br />Other Reconciliations to income
<br />(325,539)
<br />197,942
<br />Transfers In (out)
<br />880,000
<br />(119,255)
<br />(130,000)
<br />(150,000)
<br />(157,500)
<br />(165,375)
<br />(173,644)
<br />(182,326)
<br />(191,442)
<br />Total Cash Available for Capital Outlay
<br />3,906,084
<br />2,069,494
<br />1,059,400
<br />1,089,550
<br />1,046,294
<br />1,111,512
<br />1,180,152
<br />1,255,149
<br />1,334,847
<br />Cashflows from Capital Activities
<br />Capital (from CIP and Operating Budgets)
<br />(10,820,930)
<br />(4,466,806)
<br />(1,750,500)
<br />(366,250)
<br />(300,0007
<br />(300,000)
<br />(300,000)
<br />(300,000)
<br />(300,000)
<br />Debt (P&I)-2014 Bonds (20 Yr Term at 2.96%
<br />(261,499)
<br />(672,405)
<br />(669,355)
<br />(671,155)
<br />(667,805)
<br />(669,305)
<br />(670,605)
<br />(671,705)
<br />(666,518)
<br />Total Cashflow from Capital Activities
<br />(11,082,429)
<br />(5,139,211)
<br />(2,419,855)
<br />(1,037,405)
<br />(967,805)
<br />(969,305)
<br />(970,605)
<br />(971,705)
<br />(966,518)
<br />Cash Flow
<br />(7,176,345)
<br />(3,069,717)
<br />(1,360,455)
<br />52,145
<br />78,489
<br />142,207
<br />209,547
<br />283,444
<br />368,330
<br />Beginning Cash
<br />14,348,133
<br />7,171,788
<br />4,102,071
<br />2,741,616
<br />2,793,761
<br />2,872,250
<br />3,014,457
<br />3,224,004
<br />3,507,449
<br />Ending Cash balance
<br />7,171,788 4,102, 071 2,741, 616 2,793,761 2,872,250 3,014,457 3,224, 004 3,507,449 3,875,779
<br />Target cash reserve amount (note 1) 1,693,167 1,775,722
<br />Total Cash Available 5,478,621 2,326,350
<br />Capital outlay coverage 0.35 0.40
<br />Note1: Target cash reserve equals 6 mos of operating
<br />expenses, plus 100% of next years debt
<br />2,038,455 2,111,530
<br />703,161 682,231
<br />0.44 1.05
<br />2,139,984 2,169,393 2,199,812 2,225,209 2,255,619
<br />732,266 845,064 1,024,193 1,282, 240 1,620,160
<br />1.08 1.15 1.22 1.29 1.38
<br />2015 2016 2017 2018 2019 2020 2021 2022 2023
<br />Rate Increase 3.00% 3.00% 3.00% 3.001/6 3.00% 3.00% 3.00% 3.00% 3.00%
<br />Connection Charge Increase 3.00% 3.00% 3.00% 3.001/6 3.00% 3.00% 3.00% 3.00% 3.00%
<br />
|