<br />CWCBPROJWK4 \ 04/28/98 \ 08:36 AM
<br />
<br />Assumptions:
<br />Water revenue Includes anticipated increases In rates in 1999 and 2001.
<br />Tap fee revenue includes an annual increase In the per tap rate of $200 per tap from 1999 to 2008.
<br />Tax revenue Increases by approximately 2% per year but is capped at under 10% of total revenues.
<br />Investment Income is based upon 5.5% earnings on funds available for investment , '
<br />Personnel costs Increase at 2.5% with additional positions added as follows: (1999) 1, (2000) 1, (2001) 2, (2008) 1,
<br />(2017) 1, (2020) 1, (2023) 1, (2026) 1. (2029) 1. and (2032) 1.
<br />Other operating costs Increase at 2.5% per year.
<br />General Capital Includes normal equipment acquisition and replacement. and normal line expansion and replacement
<br />Other Major Capital includes Flrellne Upgrades. Upper Supply Pipeline, Major Dlstrlbution LIne replacements and Major Plant Upgrades.
<br />Debt Service Coverage = (Water Revenues + Tax Revenues + Investment Income + Other Misc. Income - Personnel Costs - Other Operating Costs
<br />
<br />(2011
<br />
<br />2,
<br />
<br />(2014)
<br />
<br />1,
<br />
<br />Contingency) I (All Debt Service)
<br />
<br />I
<br />
<br />I
<br />I
<br />
<br />Act.
<br />Act.
<br />Budget
<br />Proj.
<br />Pro].
<br />Proj.
<br />Proj.
<br />Proj.
<br />Proj.
<br />Proj.
<br />Proj.
<br />proj.
<br />Proj.
<br />Proj.
<br />Proj.
<br />Proj.
<br />Proj.
<br />Proj.
<br />Proj.
<br />Proj.
<br />Proj.
<br />Proj.
<br />Proj.
<br />Proj.
<br />Proj.
<br />Proj.
<br />Proj.
<br />Proj.
<br />proj.
<br />proj.
<br />Proj.
<br />Proj.
<br />Proj.
<br />Proj.
<br />Proj.
<br />proj.
<br />Proj.
<br />
<br />1996
<br />1997
<br />1998
<br />1999
<br />2000
<br />2001
<br />2002
<br />2003
<br />2004
<br />2005
<br />2006
<br />2007
<br />2008
<br />2009
<br />2010
<br />2011
<br />2012
<br />2013
<br />2014
<br />2015
<br />2016
<br />2017
<br />2018
<br />2019
<br />2020
<br />2021
<br />2022
<br />2023
<br />2024
<br />2025
<br />2026
<br />2027
<br />2028
<br />2029
<br />2030
<br />2031
<br />2032
<br />
<br />25.198,021
<br />27.386,779
<br />30,222,~90
<br />30,723.469
<br />32.408,199
<br />27.266.115
<br />22,407.277
<br />21,648,643
<br />19,303,647
<br />16,649,624
<br />16.315,797
<br />16.125,393
<br />17,585,962
<br />17.511,736
<br />16,889.370
<br />14.934,769
<br />16.421,334
<br />18.006,737
<br />19,695,265
<br />18,660,484
<br />18.879,423
<br />21,139,746
<br />23,460,537
<br />25.913.834
<br />28,505,250
<br />27,920,240
<br />32,274,357
<br />31.782,325
<br />36,339,072
<br />34.998,482
<br />39,743,524
<br />44.666.620
<br />49.835.366
<br />55.260.362
<br />60,856.277
<br />66,723,725
<br />72.874,304
<br />
<br />20.66
<br />19.91
<br />20.08
<br />22.79
<br />22.79
<br />23.95
<br />24.46
<br />24.46
<br />24.85
<br />24.85
<br />24.84
<br />24.84
<br />24.84
<br />24.84
<br />24.84
<br />24.84
<br />24.84
<br />24.84
<br />24.84
<br />24.84
<br />24.84
<br />24.84
<br />24.84
<br />24.84
<br />24.84
<br />24.84
<br />24.84
<br />24.84
<br />24.84
<br />24.84
<br />24.84
<br />24.64
<br />24.84
<br />24.84
<br />24.84
<br />24.84
<br />24.84
<br />
<br />5,402,478
<br />5,316,574
<br />5,500.000
<br />6,368,000
<br />6,495,360
<br />6,963.519
<br />7,252,789
<br />7.397.845
<br />7.665,802
<br />7.819,118
<br />7,975.500
<br />8.135.010
<br />8,297.710
<br />8,463,664
<br />8.632.937
<br />8,805,596
<br />8,981,708
<br />9,161,342
<br />9,344,569
<br />9.531,460
<br />9,722.089
<br />9,916,531
<br />10,114.862
<br />10,317.159
<br />10.523.502
<br />10.733,972
<br />10,948.651
<br />11,167.624
<br />11,390,976
<br />11,618.796
<br />11,851,172
<br />12,088,195
<br />12.329.959
<br />12,576,558
<br />12,828.089
<br />13,084,651
<br />13.346,344
<br />
<br />2,577,653
<br />2,926.093
<br />2,000,000
<br />1,332,936
<br />1.439,515
<br />1.549.953
<br />1,664,112
<br />1,782.282
<br />1,904,544
<br />2,030,979
<br />2,159,943
<br />2,293,214
<br />2.430.878
<br />2.479.496
<br />2.529.086
<br />2,579.668
<br />2,631,261
<br />2,683,886
<br />2,737,564
<br />2,792.315
<br />2,848.161
<br />2,905,124
<br />2,963,226
<br />3.022,491
<br />3,082,941
<br />3.144,600
<br />3,207,492
<br />3,271.642
<br />3,337.070
<br />3,403,817
<br />3,471,893
<br />3,541.331
<br />3,612,158
<br />3,684,401
<br />3,758,089
<br />3.833.251
<br />3,909,916
<br />
<br />193,515
<br />171,330
<br />139,500
<br />142,290
<br />145.136
<br />148.039
<br />151.000
<br />154,020
<br />157,100
<br />160.242
<br />163.447
<br />166,716
<br />170,050
<br />173.451
<br />176,920
<br />180,458
<br />184.067
<br />187,748
<br />191.503
<br />195,333
<br />199,240
<br />203,225
<br />207,290
<br />211,436
<br />215.665
<br />219,978
<br />224,378
<br />228.866
<br />233,443
<br />238,112
<br />242,874
<br />247,731
<br />252.686
<br />257.740
<br />262.895
<br />268.153
<br />273.516
<br />
<br />1,519.405
<br />1.862,454
<br />1,840.000
<br />1,562.509
<br />1.476.939
<br />1,229.416
<br />1.090,384
<br />1,013,569
<br />889,843
<br />815,894
<br />802.919
<br />834,356
<br />868,668
<br />851.427
<br />787.647
<br />776,064
<br />852,095
<br />933,125
<br />949,305
<br />929,113
<br />990.474
<br />1.103,857
<br />1.222,016
<br />1.346,872
<br />1.396.531
<br />1.489,816
<br />1,585.403
<br />1,686,005
<br />1,760,604
<br />1,849,865
<br />2.089.151
<br />2,338,924
<br />2,601.119
<br />2,873.887
<br />3,157.605
<br />3.455.051
<br />3,776,717
<br />
<br />857,834
<br />901.157
<br />1.004,130
<br />1,022,204
<br />1,040.604
<br />1,059,335
<br />1.078,403
<br />1,097.814
<br />1,117,575
<br />1.137,691
<br />1.158,169
<br />1,179,016
<br />1,200,238
<br />1.221,842
<br />1.243.835
<br />1,266,224
<br />1,289,016
<br />1,312.218
<br />1,335,838
<br />1,359,883
<br />1,384.361
<br />1,409.279
<br />1,434,646
<br />1.460.470
<br />1,486,758
<br />1.513,520
<br />1,540,763
<br />1 ,568,497
<br />1.096,730
<br />1,625.471
<br />1.654,729
<br />1.684,514
<br />1.714,835
<br />1.745,702
<br />1.777,125
<br />1.809,113
<br />1,841,677
<br />
<br />157,637
<br />397.321
<br />500,000
<br />5,924,472
<br />2.679
<br />
<br />10,000,000
<br />10.000.000
<br />
<br />724,793
<br />106,998
<br />
<br />11.433,315
<br />11,574.929
<br />11,090,628
<br />26,352,411
<br />20,600.233
<br />10,950.262
<br />11.236,688
<br />11,445.530
<br />11,734,864
<br />11,963,924
<br />12,259.978
<br />12.608,312
<br />12,967,544
<br />13,189,880
<br />13.370,425
<br />13,608,010
<br />13,938,147
<br />14,278.319
<br />14,558,779
<br />14,808,104
<br />15,144,325
<br />15,538,016
<br />15,942,040
<br />16.358.428
<br />16,705.397
<br />17,101,886
<br />17.506,687
<br />17,922,634
<br />18,323,828
<br />18,736,061
<br />19,309,819
<br />19.900.695
<br />20,510,757
<br />21,138.288
<br />21,783,803
<br />22,450,219
<br />23,148,170
<br />
<br />2.412,080
<br />2,542,413
<br />2,641.825
<br />2,755,908
<br />2,867.856
<br />3,032.785
<br />3,108,605
<br />3,186,320
<br />3,265,978
<br />3,347,627
<br />3,431,318
<br />3,517.101
<br />3,665,029
<br />3,756,655
<br />3.850.571
<br />4,007.035
<br />4,107,211
<br />4,209,891
<br />4,380,138
<br />4,489.641
<br />4,601,882
<br />4,786,929
<br />4,906,602
<br />5,029.267
<br />5.229,999
<br />5,360,749
<br />5.494,768
<br />5,713,137
<br />0,800,960
<br />6,002,364
<br />6,239,423
<br />6.395.409
<br />6.555,294
<br />6,813.176
<br />6.983,505
<br />7,158,093
<br />7,437.045
<br />
<br />1,329,230
<br />1,484,187
<br />1,519,297
<br />1,557,279
<br />1,596,211
<br />1.636.116
<br />1,677,019
<br />1,718,944
<br />1,761,918
<br />1,805,966
<br />1,851,115
<br />1,897,393
<br />1,944,828
<br />1,993.449
<br />2,043,285
<br />2,094,367
<br />2,146,726
<br />2,200,394
<br />2.255,404
<br />2,311,789
<br />2,369.584
<br />2,428,824
<br />2,489,545
<br />2,551.784
<br />2,615,579
<br />2,680.968
<br />2,747,992
<br />2,816.692
<br />2.887,109
<br />2,959,287
<br />3,033,269
<br />3,109.101
<br />3,186,829
<br />3,266,500
<br />3,348,163
<br />3,431,867
<br />3,517,664
<br />
<br />300,000
<br />300.000
<br />300,000
<br />300,000
<br />300,000
<br />300,000
<br />300,000
<br />300,000
<br />300,000
<br />300,000
<br />306,000
<br />312,120
<br />318.362
<br />324,729
<br />331,224
<br />337,848
<br />344,605
<br />351 ,497
<br />358,527
<br />365,698
<br />373.012
<br />380,472
<br />388,081
<br />395,843
<br />403.760
<br />411,835
<br />420,072
<br />428,473
<br />437,042
<br />445.783
<br />454,699
<br />463,793
<br />473.069
<br />482,530
<br />492,181
<br />
<br />1,656,884
<br />1,973,537
<br />2.595,487
<br />2,590.000
<br />2,535,000
<br />2,560,000
<br />2.545,000
<br />2,525,000
<br />2.570,000
<br />2,515,000
<br />2.555,000
<br />2,618,875
<br />2,684,347
<br />2.751,456
<br />2,820.242
<br />2,890,748
<br />2,963,017
<br />3,037,092
<br />3,113,019
<br />3,190,844
<br />3,270.615
<br />3,352,380
<br />3,436.190
<br />3,522.095
<br />3,610,147
<br />3,700,401
<br />3.792.911
<br />3,887,734
<br />3,984.927
<br />4,084,550
<br />4,186,664
<br />4,291,331
<br />4,398,614
<br />4,508,579
<br />4,621,293
<br />4.736,825
<br />4,855.246
<br />
<br />476,240
<br />635,730
<br />1,000,000
<br />15,000,000
<br />15,000,000
<br />
<br />6,000,000
<br />
<br />4,000,000
<br />
<br />5,000,000
<br />
<br />3.217,000
<br />1,962,000
<br />
<br />1,637,000
<br />2,194,000
<br />3.488,000
<br />
<br />2,083,000
<br />2,119,000
<br />
<br />4,000,000
<br />
<br />,082,433
<br />72.515
<br />172,800
<br />
<br />2,287,690
<br />2,195,236
<br />2,360,340
<br />2,464,494
<br />3,443,250
<br />4.280.199
<br />4,364,698
<br />3,977,262
<br />4,371.991
<br />4,329.158
<br />4.312,949
<br />2,814,374
<br />2,804,566
<br />2,804,566
<br />2.804,566
<br />2.804.566
<br />2,804,566
<br />2,804,566
<br />2,283,394
<br />2,283,394
<br />2.283,394
<br />2,283,394
<br />2,283,394
<br />2,283,394
<br />1,446.601
<br />609,808
<br />559,288
<br />536,489
<br />016,34~
<br />516.345
<br />490,325
<br />490.325
<br />490,325
<br />490,325
<br />490,325
<br />490,325
<br />o
<br />
<br />9,244,557
<br />8.739,118
<br />10,589,749
<br />24,667,681
<br />25,742,317
<br />15.809.100
<br />11,995,322
<br />13,790,526
<br />14,388,887
<br />12,297,751
<br />12,450,382
<br />11,147,743
<br />13,041,770
<br />13,812,246
<br />15.325.026
<br />12,121,445
<br />12,352,744
<br />12,589,791
<br />15,593,560
<br />14,589,165
<br />12,884,002
<br />13,217,225
<br />13.488.743
<br />13.767.012
<br />17,290.407
<br />12,747,769
<br />17.998.719
<br />13,365,887
<br />19,664,418
<br />13,991,019
<br />14,386,723
<br />14,731,949
<br />15,085,761
<br />15,542.373
<br />15,916,355
<br />16.299,640
<br />16,302,136
<br />
<br />2,188,758
<br />2,835,811
<br />500,879
<br />1,684,730
<br />(5.142,084)
<br />(4.858,838)
<br />(758,634)
<br />(2,344,996)
<br />(2.654.023)
<br />(333,827)
<br />(190,404)
<br />1,460,569
<br />(74.226)
<br />(622,366)
<br />(1,954.601 )
<br />1,486,565
<br />1,585,403
<br />1,688.528
<br />(1,034,781)
<br />218,939
<br />2,260,323
<br />2,320,791
<br />2,453,297
<br />2.591,416
<br />(585,010)
<br />4,354,117
<br />(492.032)
<br />4,556,747
<br />:1.34M90)
<br />4,745,042
<br />4,923,096
<br />5.168,746
<br />5.424.996
<br />5,595,915
<br />5,867,448
<br />6.150,579
<br />6,846,034
<br />
<br />1.850
<br />1.925
<br />1.704
<br />1.819
<br />1.276
<br />1.035
<br />1.028
<br />1.121
<br />1.030
<br />1.035
<br />1.047
<br />1.635
<br />1.648
<br />1.657
<br />1.651
<br />1.641
<br />1.684
<br />1.728
<br />2.120
<br />2.130
<br />2.175
<br />2.212
<br />2.282
<br />2.354
<br />3.725
<br />9.052
<br />10.107
<br />10.642
<br />11.279
<br />11.508
<br />12.498
<br />13.071
<br />13.668
<br />14.094
<br />14.727
<br />15.387
<br />
<br />Year
<br />
<br />Amount
<br />Available
<br />for
<br />Appropriation
<br />Beg. of Year
<br />
<br />Average
<br />Monthly
<br />Bill
<br />
<br />Water
<br />Revenue
<br />
<br />Tap
<br />Fee
<br />Revenue
<br />
<br />Other
<br />Misc.
<br />Income
<br />
<br />Investment
<br />Income
<br />
<br />Tax
<br />Revenue
<br />(Net of
<br />Treas. Fees)
<br />
<br />Advances
<br />From CWCB
<br />Loan
<br />
<br />Proceeds
<br />from
<br />Borrowing
<br />
<br />Contributions
<br />Toward
<br />Fireline
<br />Upgrades
<br />
<br />Total
<br />Revenues
<br />
<br />Personnel
<br />Costs
<br />
<br />Other
<br />Operating
<br />Costs
<br />
<br />Contingency
<br />
<br />General
<br />Capital
<br />
<br />Plateau
<br />Creek
<br />Pipeline
<br />Capital
<br />
<br />other
<br />Major
<br />Capital
<br />
<br />Debt
<br />Service
<br />( SChedule
<br />Attached)
<br />
<br />Total
<br />Expenditures
<br />
<br />Revenues
<br />over
<br />( Under)
<br />ExpenditureS
<br />
<br />Debt
<br />Service
<br />Coverage
<br />
<br />UTE WATER CONSERVANCY DISTRICT
<br />PROJECTED FUNDS AVAILABLE WITH PLATEAU CREEK PIPELINE PROJECT
<br />
|