|
Expenses
<br />4arevsch.wk4 7/27/95
<br />(2) Reconnect Fees - based on 10/94 revenues.
<br />(3) Projected 2 - Account Clerk II for Sebastian System & Operations Coordinator
<br />(4) Projected 1 - Sewer Service Worker for maintenance of facilities.
<br />(5) Projected 1 - Water Service Worker for maintenance of facilities.
<br />General Personnel Expenses (3)
<br />General Personnel Benefits
<br />$63,178
<br />$64,757
<br />$66,376
<br />$68,036
<br />$69,737
<br />$71,480
<br />$73,267
<br />$75,099
<br />$76,976
<br />$78,901
<br />SCHEDULE 4
<br />$35,760
<br />$17,014
<br />$36,654
<br />$17,439
<br />$37,570
<br />$17,875
<br />$38,509
<br />$18,322
<br />$39,472
<br />$18,780
<br />INDIAN RIVER
<br />COUNTY
<br />$42,507
<br />$43,570
<br />$44,659
<br />Sewer Personnel Benefits
<br />$10,423
<br />$10,684
<br />$10,951
<br />$11,225
<br />ANALYSIS
<br />OF CITY OF SEBASTIAN UTILITIES ACQUISITION
<br />$12,088
<br />$20,224
<br />$12,390
<br />$20,730
<br />$12,700
<br />�►
<br />C
<br />Water Personnel Expenses (5)
<br />Water Personnel Benefits
<br />CITY OF SEBASTIAN UTILITIES TEN YEAR PROFORMA CASH FLOW STATEMENT
<br />$17,439
<br />$17,875
<br />$18,322
<br />OQ
<br />Revenues
<br />1995
<br />1996
<br />1997
<br />1998
<br />1999
<br />2000
<br />2001
<br />2002
<br />2003
<br />2004
<br />$11,793
<br />$20,236
<br />Water Sales
<br />Sewer Sales
<br />$533,976
<br />$552,665
<br />$572,008
<br />$592,029
<br />$612,750
<br />$634,196
<br />$656,393
<br />$679,367
<br />$703,144
<br />S727,754
<br />00
<br />Sewer Rev. Increase Blk.
<br />$265,062
<br />$16,938
<br />$274,339
<br />$17,531
<br />$283,941
<br />$18,144
<br />$293,879
<br />$304,165
<br />$314,811
<br />$325,829
<br />$337,233
<br />$349,036
<br />5361,252
<br />I -A
<br />Rate Equalization Charge (6%)
<br />$48,959
<br />$50,672
<br />$52,446
<br />$18,779
<br />$54,281
<br />$19,437
<br />$56,181
<br />$20,117
<br />$58,147
<br />$20,821
<br />$60,183
<br />$21,550
<br />$62,289
<br />$22,304
<br />$23,085
<br />$24,368
<br />Penalties & Interest (1)
<br />$23,964
<br />$24,803
<br />$25,671
<br />$26,569
<br />$27,499
<br />$28,462
<br />$29,458
<br />$30,489
<br />$64,469
<br />$31,556
<br />$66,725
<br />$32,660
<br />S326,480
<br />Reconnect Fees (2)
<br />Projected Revenue
<br />$8,676
<br />$8,980
<br />$9,294
<br />$9,619
<br />$9,956
<br />$10,304
<br />$10,665
<br />$11,038
<br />$11,425
<br />$11,824
<br />Debt Service (P&I)
<br />$360,868
<br />$897,575
<br />$928,990
<br />$961,504
<br />$995,157
<br />$1,029,987
<br />$1,066,037
<br />$1,103,348
<br />$1,141,965
<br />$1,181,934
<br />$1.223,302
<br />Expenses
<br />(1) Penalties & Interest - based on 10/94 revenues.
<br />(2) Reconnect Fees - based on 10/94 revenues.
<br />(3) Projected 2 - Account Clerk II for Sebastian System & Operations Coordinator
<br />(4) Projected 1 - Sewer Service Worker for maintenance of facilities.
<br />(5) Projected 1 - Water Service Worker for maintenance of facilities.
<br />General Personnel Expenses (3)
<br />General Personnel Benefits
<br />$63,178
<br />$64,757
<br />$66,376
<br />$68,036
<br />$69,737
<br />$71,480
<br />$73,267
<br />$75,099
<br />$76,976
<br />$78,901
<br />Sewer Personnel Expenses (4)
<br />$35,760
<br />$17,014
<br />$36,654
<br />$17,439
<br />$37,570
<br />$17,875
<br />$38,509
<br />$18,322
<br />$39,472
<br />$18,780
<br />$40,459
<br />$19,250
<br />$41,470
<br />$19,731
<br />$42,507
<br />$43,570
<br />$44,659
<br />Sewer Personnel Benefits
<br />$10,423
<br />$10,684
<br />$10,951
<br />$11,225
<br />$11,505
<br />$11,793
<br />$12,088
<br />$20,224
<br />$12,390
<br />$20,730
<br />$12,700
<br />$21,248
<br />$13,017
<br />Water Personnel Expenses (5)
<br />Water Personnel Benefits
<br />$17,014
<br />$17,439
<br />$17,875
<br />$18,322
<br />$18,780
<br />$19,250
<br />$19,731
<br />$20,224
<br />$20,730
<br />$21,248
<br />Sewer General Operating Expenses(6)
<br />$10,423
<br />$17,885
<br />$10,684
<br />$18,333
<br />$10,951
<br />$18,791
<br />$11,225
<br />$19,261
<br />$11,505
<br />$19,742
<br />$11,793
<br />$20,236
<br />$12,088
<br />$12,390
<br />$12,700
<br />$13,017
<br />Water General Operating Expenses(7)
<br />$44,724
<br />$45,843
<br />$46,989
<br />$48,163
<br />$49,367
<br />$50,602
<br />$20,742
<br />$51,867
<br />$21,260
<br />$53,163
<br />$21,792
<br />$54,492
<br />$22,337
<br />$55,855
<br />Sewer General O & M Expenses
<br />Water General O & M Expenses
<br />$25,000
<br />$20,000
<br />$25,625
<br />$26,266
<br />$26,922
<br />$27,595
<br />$28,285
<br />$28,992
<br />$29,717
<br />$30,460
<br />$31,222
<br />09h,
<br />In Projected Expenses
<br />$261,422
<br />$20,500
<br />$267,958
<br />$21,013
<br />$274,657
<br />$21,538
<br />$281,523
<br />$22,076
<br />$288,561
<br />$22,628
<br />$295,775
<br />$23,194
<br />$23,774
<br />$24,368
<br />524,977
<br />$303,170
<br />$310,749
<br />$318,517
<br />S326,480
<br />Net Revenue after Expenses
<br />$636,152
<br />$661,032
<br />$686,848
<br />$713,634
<br />$741,426
<br />$770,262
<br />$800179
<br />$831,217
<br />$863,417
<br />$896.822
<br />Debt Service (P&I)
<br />$360,868
<br />$360,868
<br />$360,868
<br />$360,868
<br />$360,868
<br />$360,868
<br />$360,868
<br />$360,868
<br />$360,868
<br />S360,868
<br />Debt Service Coverage
<br />1.76
<br />1.83
<br />1.90
<br />1.98
<br />2.05
<br />2.13
<br />2.22
<br />2.30
<br />2.39
<br />2.49
<br />Amortization - Water & Sewer Capacity
<br />Sewer Renewal & Replacement
<br />$148,230
<br />$13,253
<br />$148,230
<br />$148,230
<br />$148,230
<br />$148,230
<br />$148,230
<br />$148,230
<br />$148,230
<br />$148,230
<br />$148,230
<br />(9)
<br />Water Renewal & Replacement (10)
<br />$26,699
<br />$13,584
<br />$27,366
<br />$13,924
<br />$28,050
<br />$14,272
<br />$28,752
<br />$14,629
<br />$29,470
<br />$14,995
<br />$30,207
<br />$15,370
<br />$15,754
<br />$16,148
<br />$16,551
<br />Net Revenue
<br />SR71n,2
<br />tiroona
<br />evicrc
<br />irZ4c4.,
<br />$30,962
<br />$31,736
<br />$32,530
<br />$33.343
<br />1
<br />1
<br />1
<br />(1) Penalties & Interest - based on 10/94 revenues.
<br />(2) Reconnect Fees - based on 10/94 revenues.
<br />(3) Projected 2 - Account Clerk II for Sebastian System & Operations Coordinator
<br />(4) Projected 1 - Sewer Service Worker for maintenance of facilities.
<br />(5) Projected 1 - Water Service Worker for maintenance of facilities.
<br />(6) Projected incremental sewer treatment expenses - 36,501 (volume X $.49/th gals) No. Co. Pit. Cost.
<br />(7) Projected incremental water production expenses-111.811(volume X $.40/th gal)s RO Prod. & Transmission.
<br />(8) Amortization of Replacement Plant Capacity
<br />calculated on $2,964,604 over 20 year period
<br />,
<br />(9) Projected at 5% of Sewer Sales.
<br />(10) Projected at 5% of Water Sales.
<br />CZ
<br />01) Sales Growth is Projected at 3.5% per year and Expenses are projected to increase at 2.5%.
<br />1
<br />1
<br />1
<br />
|