C153719 Feasibility Study

• Contract/PO #: C153719
• Contractor Name: Johnstown, Town of
• Contract Type: Loan
• Water District: 13
• County: Larimer
• County: Weld
• Bill Number: SB 94-029
• Loan Projects - Doc Type: Feasibility Study

-

-

-

Total Projecteost
Annual Operating Expenses
Number of Customers
Golden Technologies (GTC)-
Water Fees (per customer)
Water Fee (GTC)
Tap Fee
Innation (per year)
Growth (per year)
Interest Rate on RElS8IVeS

'l'Vurot
0..........

-
VI

1
2
3
.
5
.
7
8
.
10
11
12
13
,.
15
.18
17
18
,.
20
21
22
23
2.
25
26
27
28
29
30

Totals : ~", S28

,WIeIr-Ftf:;c;- "'~
tM8IiU'.. rat :
ToWn ",._;~,:

$320,758.41
5491,428.12
S50B,239.62
5495,187.25
~,(lCJJ.:\\
$564,117.76
$588,6n.36
S614,754.n
$642,0455.39
$669,900.20
$684,931.59
$719,368_29
$755,941.52
$794,797.44
$837,912.80
$881,728.06
$928,238.09
$979,582.67
$1,034,037.10
$1,090,000.45
$1,093,3n.68
$1,158,533.03
$1,227,988.62
$1,302,028.29
$1,380,954.58
$1,465,090_00
$1,554,nS_35
$1,650,386.14
$1,752,304.04
$1,757,655.04

-

.Assumptions

-

-

-

-

-

-

Table 3

-

-

-

-

-

Town of Johnstown
Raw Water Improvement Projects
Schedule of Revenues and Expenditures - 2.5% Growth without Golden Technologies

':, 'fWlll!W:" ,:, ,:
, 'RMh~.;'ro,.'
. OTe.

$0.00
$0.00
$0.00
$0.00
'""...
$0.00
$0.00
$000
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

.73 ,'. ,,', $0.00

$2,600,000_00
5366,607.00
791
o
S405.51
$253,000.00
$0.00
4.00%
2._
..00%

, f':: ';!."" ;:~:j

$0.00
$0.00
$0.00
$0.00
'""....
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$000
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

.i':i'f;,:i

T__
." FH'ReV.....

S320,758.41
5491,428.12
$508,239.62
5495,187.25
~'?~.....
5564,117.76
SS88,677.36
5614,754.72
$642,4155.39
$669,900.20
5684,931.59
$719,368.29
$755,941.52
$794,797.44
$837,912.80
$881,728.06
$928,238.09
$979,582.67
$1,0341,037.10
$1,090,000.415
$1,093,3n.68
$1,158,533.03
$1,227,988.62
$1,302,028.29
$1,380,95ot.58
$1,465,090.00
$1,554,778.35
$1,650,386.141
$1,i'52,3CM.04
$1,757,655.04

2.73

AnbUal,OpIiraUng ,
. EX.....

$2741,955.25
$293,102.30
$312,447.05
$333,068.55
~~.~
$378,4184.415
$403,41&1.412
S430,093.07
$458,479.22
S488,738.85
$520,995.61
$555,381.32
$592,036.49
$631,110.89
$672,7641.21
$717,166.65
$7641,4199.65
$8141,956.63
$868,7413.77
$926,080.85
$987,202.19
$1 ,052,357.~
$1,121,813.13
$1,195,852.80
$1,274,779.08
$1,358,914.50
$1,448,602.86
$1,544,210.65
$1,&16,128.55
$1,754,m.04

,178.254.65

-

-

-

-

.

'FinanCing' :

,""-",.,

'" Loan ~1'Vt
'.,. ( "f'ulld.'

Annual

$22,889.72
$26,252.21
$26,278.89
$17,484,37
""'1-,~.trJ
$17,430.38
$17,487.56
$17,533,07
$17,566.58
$17,405.62

1197,B82.42

Source

CWCB loan
CWPDA loan

Share

75"
25"

Principal

$1,950,000.00
$650,000.00

"..-

4.00%
Variable

y....

30
20

Notes:
.. Enter number of years to include GTC water fees, use 100 for indefinate number of years

Aecum.

522,889.72
$419,141.93
$75,420.83
$66,697.70
l&1I,~~.?~
$101,682.09
$119,169,65
$136,702.72
$154,269.30
$171,674.92
$171,674.92
$171,674.92
$171,674.92
$171,674,92
$171,674.92
$171,674.92
$171,674.92
$171,674.92
$171,674.92
$171,674.92
$109,886.69
$109,886.69
$109,686.69
$109,886,69
$109,886.69
$109,886.69
$109,886.69
5109,886.69
$109,886.69
$0.00

Payments-on
<:weB......

$112,768.69
$112,768.69
$112,768.69
$112,768.69
$112,768.69
$112,768.69
$112,768.69
$112,768.69
$112,768.69
$112,768.69
$112,768.69
$112,768 69
$112,768.69
$112,768.69
$112,768.69
$112,768.69
$112,768.69
$112,768.69
$112,768.69
$112,768.69
$112,768.69
$112,768.69
$112,768.69
$112,768,69
$112,768.69
$112,768.69
$112,768.69
$112,768.69
$112,768.69
$112,768.69

....

"'...........

~ _ ,..,~o
. CWPOALOM-

$30,303.52
$62,253.43
$61,270.24
$62,075.00
$62,771.43
$61,535.15
$62,106.86
$62,562.04
$62,897.06
$61,287.54
$61,467.79
$61,51S.77
$61,436.83
$61,218.35
$62,680.39
$62,093.21
$61,270.24
562,157.84
$62,825.14
$61,451.40
$61,788.24

Oft
.~~C'

$85,825.00
$87,500.00
$88,750.00
$89,590.00

1,268.970.47 ",1351 .00

""'--.'10"
-'R~F~'
. ,

$1,373.38
$2,948.52
$4,525.25
$4,001.86
$5,055.10
$6,100.93
$7,150.18
$8,202.16
$9,256.16
$10,300.50
$10,300.50
$10,300.50
$10,300.50
$10,300.50
$10,300.50
$10,300.50
$10,300.50
$10,300.50
$10,300.50
$10,300,50
$6,593.20
$6,593.20
$6,593,20
$6,593,20
$6,593.20
$6,593.20
$6,593,20
$6,593.20
$6,593.20
$0.00

, 7.80

Payment

$112,768,69
Variable

":"~""TGIlII.-!;""! ,"
'ExpOndiii....,:

~ ".

$525,368.80
$578,928.12
$596,989.62
S584,m.25
5543,090.11
$564,117.76
$588,6n.36
$614,7~.72
$642,4155.39
$669,900.20
$684,931.59
$719,368.29
$755,941.52
$794,797.44
5837,912.80
$881,728.06
5928,238.09
$979,582.67
$1,034,037.10
51,090,000.45
$f ,093,3n.68
$1,158,533.03
$1,227,988.62
$f ,302,028.29
$1,380,954.58
$1,465,090.00
$1,554,nS.35
$1,650,386.14
$1,7523CM.04
$1,757:655.04

S28 ,8S3.12