|
City of Onawa, to - Water Rate Study
<br />November 23, 2010
<br />Page 4
<br />Water Utility - Financial P14ections
<br />(Projected Water Rate Adjustment Average
<br />Projected
<br />16.00%
<br />16.00%
<br />16.00%
<br />5.00%
<br />0.00%
<br />0.00%
<br />0.00%
<br />0.00%
<br />13.67%
<br />0.00%
<br />Change
<br />Change
<br />i 2011 -2007
<br />2012-2022
<br />2011
<br />2012
<br />2013
<br />2014
<br />2015
<br />2016
<br />2017
<br />2018
<br />2019
<br />2020
<br />2021
<br />!Operating Revenues
<br />Charges for Services (Growth from
<br />new customers only!) 6.95%
<br />0.00%
<br />387,000
<br />448,920
<br />520,747
<br />604,067
<br />634,270
<br />634,270
<br />634,270
<br />634,270
<br />634,270
<br />721,002
<br />721,002
<br />Other Revenue 0.00%
<br />2.00%
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />Total Operating Revenue
<br />387,000
<br />448,920
<br />520,747
<br />604,067
<br />634,270
<br />634,270
<br />634,270
<br />634;270
<br />634,270
<br />721,002
<br />721,002
<br />Operating Expenses
<br />Production 1.79%
<br />5.00%
<br />97,911
<br />102,807
<br />107,947
<br />113,345
<br />119,012
<br />124,962
<br />131,211
<br />137,771
<br />144,660
<br />151,893
<br />159,`487
<br />Distribution - .1.78 %
<br />3.00%
<br />17 42
<br />181,838
<br />187,293
<br />192,912
<br />198,699
<br />204,660
<br />210,800
<br />217,124
<br />223,637
<br />230,347
<br />237,257
<br />Customer Aocounts/Administration 3A2%
<br />3.00%
<br />69,272
<br />71,350
<br />73,491
<br />75,696
<br />77,966
<br />80,305
<br />82,715
<br />85,196
<br />87,752
<br />90,384
<br />93,096
<br />Other Miscellaneous Expenses 0.00%
<br />0.00 %,
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />Existing Depreciation
<br />32,865
<br />31,222
<br />29,661
<br />28,178
<br />26,769
<br />25,430
<br />24,159
<br />22,951
<br />21,803
<br />20,713
<br />19,677
<br />New Depreciation
<br />-
<br />39,735
<br />43,937
<br />50,393
<br />53,378
<br />59,962
<br />63,110
<br />65,929
<br />68,871
<br />71,946
<br />79,623
<br />Total Operating Expenses
<br />376,590
<br />426,952
<br />442,328
<br />460,523
<br />475,824
<br />495,320
<br />511,994
<br />528,971
<br />546,723
<br />565,283
<br />589,140
<br />Operating Income (Loss)
<br />10,410
<br />21.,968
<br />78,419
<br />143,544
<br />158,447
<br />138,950
<br />122,276
<br />105,300
<br />87,547
<br />155,720
<br />131,862
<br />(Non Operating Revenues (Expenses)
<br />State or Federal Grants
<br />340,000
<br />Interest Income
<br />2.00%
<br />6,129
<br />5,125
<br />3,644
<br />2,249
<br />3,617
<br />3,993
<br />5,466
<br />6,775
<br />7,759
<br />8,396
<br />8,014
<br />Interest Expense Existing Debt
<br />-
<br />Interest Expense New Debt
<br />-
<br />(35,200)
<br />(33,751)
<br />(32174)
<br />(30,766)
<br />(29129)
<br />(27,661)
<br />(26,061)
<br />(24,430)
<br />(22,766)
<br />(21,068)
<br />Sale ofMereharrdise
<br />16,427
<br />16,427
<br />16,427
<br />16,427
<br />16,427
<br />16,427
<br />16,427
<br />6,427
<br />16,427
<br />16,427
<br />16,427
<br />Existing Special Assessments
<br />-
<br />New Special Assessments
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />Gain on Sale of Fixcd Assets
<br />-
<br />Other
<br />1,309
<br />1,309
<br />1,309
<br />1,309
<br />1,309
<br />1,309
<br />1,309
<br />1,309
<br />1,309
<br />1,309
<br />1,309
<br />Total Non Operating Revenues (Expense. �
<br />363,865
<br />(12,339)
<br />(12,371)
<br />(12,288)
<br />(9,413)
<br />(7,500)
<br />(4,458)
<br />(1,550)
<br />1,065
<br />3,366
<br />4,682
<br />Net Income (Loss) Before Transfers
<br />374,275
<br />9,629
<br />66,048
<br />131,256
<br />149,034
<br />131,450
<br />11.7,818
<br />103,749
<br />88,612
<br />159,086
<br />136,544
<br />Operating Transfers
<br />Transfers In
<br />-
<br />Transfers (Out)
<br />-
<br />Total Operating Transfers
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />Net Income (Loss)
<br />374,275
<br />9,629
<br />66,048
<br />1.31,256
<br />149,034
<br />131,450
<br />117,818
<br />103,749
<br />88,612
<br />159,086
<br />136,544
<br />Beginning Cash & Investments
<br />269,610
<br />256,250
<br />182,200
<br />112,461
<br />180,875
<br />199,635
<br />273,321
<br />338,744
<br />387,931
<br />419,788
<br />400,713
<br />Net Income
<br />374,275
<br />9,629
<br />66,048
<br />131,256
<br />149,034
<br />131,450
<br />117,818
<br />103,749
<br />88,612
<br />159,086
<br />136,544
<br />iDepeciation
<br />32,865
<br />70,957
<br />73,597
<br />78,571
<br />80,146
<br />85,392
<br />87,269
<br />88,880
<br />90,674
<br />92,659
<br />99,300
<br />lAcnuisition and Construction ofAssets
<br />(7,180.500)
<br />(82,200)
<br />(135300)
<br />(66,050)
<br />(133.550)
<br />(64.7501
<br />(59,698)
<br />(61,868)
<br />(64122)
<br />(185.950)
<br />(65,175)
<br />(Proceeds from New Long -Term Debt
<br />760,000
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />IPaymentsonNewLong-Terra Debt
<br />(72, 436)
<br />(73,885)
<br />(75362)'
<br />(76,869)
<br />(78,407)
<br />(79,975)
<br />(81,575)
<br />(83,206)
<br />(84,870)
<br />(86,568)
<br />(Payments on Existing Long -Term Debt
<br />-
<br />-
<br />IEnding Cash Balance
<br />256,250
<br />182,200
<br />112,461
<br />180,875
<br />199,635
<br />273,321
<br />338,744
<br />387,931
<br />419,788
<br />400,713
<br />484,815
<br />Minimum Cash Balance
<br />For4gtro. Pperations
<br />94,148
<br />106,738
<br />110,582
<br />115,131
<br />118,956
<br />123,830
<br />127998
<br />132,243
<br />136,681
<br />141,321
<br />147,285
<br />For debt service
<br />I
<br />107,636 I
<br />107,636 I
<br />107\63
<br />107,636
<br />107,636
<br />107,636 I
<br />10636 I
<br />107,636
<br />107,636
<br />107,636 I
<br />123,827
<br />Minimum Cash Balance Required
<br />201,783
<br />214,374
<br />218,218 I
<br />222,767
<br />226,592
<br />231,466
<br />23634
<br />239,878
<br />244,317
<br />248,957
<br />271,112
<br />Amount Over (Under) Minimum
<br />54,467
<br />(32,174)
<br />(105,757)
<br />(41,892)
<br />(26,95
<br />41,855
<br />103,110
<br />148,052
<br />175,472
<br />151,756
<br />213,702
<br />Public
<br />Sector Advisors
<br />
|