C153664 Engineering report

• Contract/PO #: C153664
• Contractor Name: Fort Lupton, City of & Fort Lupton Water Utility Enterprise
• Contract Type: Loan
• Water District: 1
• County: Weld
• Bill Number: HB 93-1273
• Loan Projects - Doc Type: Feasibility Study

?~ ~~/:ln ~~'r( ,-'.

Table 1 /;4,<2 /$ VU- .:::4:# ~VaZ-
,~/:? /;.w~/A::>

I

, f 1, #~
~
f~
~ /

Line
rm.. nQ~crIotlDn

I

I

Water Utility
Projected Revenues and Revenue Requirements

I

I

Revenue
Revenue from Existing Water Rates
1 Contract
2 Retail

1QS3
$

o
917.700

1W4
$

145.600
917.700

111115
$

150.000
917.700

19l1!I
$

154.500
917.700

'\

J.Jl9Z
$

159.100
917.700

Additional Retail Water Rate Revenue Required:
Revenue Months
Year iJJmaOll E!tll<:liYll
3 1993 0.00% 2 0 0 0 0 0
4 1994 0.00% 12 0 0 0 0
5 1995 0.00% 12 0 0 0
6 1996 0.00% 12 0 0
7 1997 45.00% 12 413.000

917.700 1.063.300 1.067.700 1.072.200 1.489.600
____/~~-_-__-------------.--b-------------------------.-._._
C 230.000 230.000 230.000 230.000 23O.tJ()()'
. 165.000 330.000 330.000
11t!1. J 0 0 0 30.000 '- 79.200
'(trl 17.800 22.700 21.600 18.600 10.400
m~ m~ m~ m~ m~
'- ---~-----------------_._--_._--------~
..' 1,175,600 1,326,100 1,494,400 1,690,900 '" 2:149,500
==-===;=;;;=--=== ============ ============ ============ ============

I

I

I

8 Additional Water Rate Revenue Required

9 Total Water Rate Revenue

I

10 Sales Tax Revenue (a)
11 Property Tax Revenue (b)
12 Hudson Treatment Revenue
13 Interostlneome (e)
14 Miscellaneous Revenue

I

15 Totol Revenue

I

Revenue Requirements
Operation & Maintenance Expense (d)
16 City
17 Hudson
Debt Service
Existin9 (e)
16 CBT Purchases
19 Series 1992
20 All Olher
Proposed
21 Revenue Bonds (n
22 CO. Water Conservation Board Loan (9)
23 FmHA Loan (h)

I

I

I

24 T olal Debl Service
25 Transfer To (From) Capital Fund 0)
26 Transfer To (From) Dobl Service Reserve Ol

27 Total Revenue ~Inlments

26 Annuel Surplus (Detlcll)

29 Beginning Fund Bol","",
30 Ending Fund Balanca

o

o

o

o

413.000

496.700
500.000
o

1,343.400

665.400
750.000
o

1,796.200

305.600
800.000
o

1,638.600

/
/
~

;: :':~

;/'-/

333,400 346.700 360.800 503.200 741.800
0 0 0 30.000 79.200
193.500 187.600 360.300 0 0
271,300 273.100 269.000 269.500 269.500
36.000 36.000 36.100 36.100 13.000
0 0 0 0 0
0 0 0 0 154.400
0 0 0 0 693.300

500.800
250.000
o

1,064,200

1.130.200
190.000
o

2.141,200

=~==~=.=... ........... ....E..==== =z===_===== =========_=

I

91,400

(17,300)

(301,600)

52,100

6.300

-=--======= =========== ===:======- =-=.=====.. =--==.-.=.-

423.200 514.600 497,300 195.500 247.600
514,600 497.300 195~5OO 247.600 255,900
=-========= ==========- ==-=-====== =========== ===========

I

31 Desired 0&1.1 Resorve (k)

32 Required P&I Resorvo (I)

33 Cumuleave Avelleble Surplus (Deftcll) (rn)

34 Debt Service eoverego (n)

I

62.200
194.200
238.200

65.500
350,900
60,900

89,000
56,900
49,600

124,100
49,200
74,300

162,900
50.000
23,000

=========== =======.... =========== =========== ===========

I

35 Overall Annual Rate Incroose Required
38 Curnuletlve Reloll Rote Increase Required

I

168.17% 197.16% 165.39% 376.63% 117.55%
0.00% 0.00% 0.00% 0.00% 6
0.00% 0.00% 0.00% 0.00% 4~
-4-