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

-

-

-

-

-

-

-

-

-

-

Table 5

-

-

-

-

-

Assumptions ,;.
Total Project Cost 52,600,000.00
Annual Operating Expenses $366,607.00
Number of Customer!> 791
Golden Technologies (GTCt 0
Water Fees (per customer) ( $253.00<i.Dll L.J
Water Fee (GTC)
Tap Fee _.00
Inflation (per year) ..-
Growth (per year) 1.08%
Interest Rate on Reserves 5.-

I,Y~"',';
o,N.-
,-Ii""

N
....

T.....

)",'=:':-~F
,-'. '; town ',~",';i'l

1
2
3
.
5
5
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
2.
25
26
27
28
29
3D

$320,758.41
5487,367.58
5499,642.52
5481,535.49
$523 820.18
$538,617.19
$556,280.89
$574,740.16
$594,039.18
S612,232.n
$617,091.99
S640,359.06
$664,682.62
$690,119.97
$718,552.26
$746,317.05
snS,298.58
$807,517.64
$841,121.56
$874,371.85
$853,025.63
$891,288.26
$931,511.16
$973,794.75
$1,018,244.62
$1,064,971.75
$1,114,092.80
$1,165,730.42
$1,220,013.54
$1,173,784.20

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

~::.~~~::;
, O'tc

SO.OO
SO.OO
SO.OO
so 00
SO.OO
SO.OO
SO.OO
SO.OO
SO.OO
SO.OO
SO.OO
SO.OO
SO.OO
SO.OO
SO.OO
SO.OO
so 00
SO.OO
SO.OO
SO.OO
SO.OO
50.00
50.00
SO.OO
SO.OO
so 00
50.00
50.00
SO.OO
SO.OO

.03 ,;~:: ""IO.DO

,;\;~!'::J,~~~"~~'

50.00
50.00
50.00
SO.OO
SO.OO
SO.OO
50.00
50.00
50.00
50.00
SO.OO
SO.OO
SO.OO
SO.OO
50.00
50.00
50.00
SO.OO
SO.OO
SO.OO
50.00
5000
50.00
5000
SO.OO
so 00
SO.OO
50.00
50.00
50.00

","",,,,
,", ,

-

-

-

-

. . Flnanclnif' . '... '. . .
So.... Sh... Principal ,....... v.... Payment
ewes Loan 75" $1,950,000_00 ..- 3D $112,768.69
,/ CWPDA Loan 25" $650,000_00 Variable 20 Variable

'rTCltlfWater ;
"F.. Revenun "

$320,758.41
$487,367.58
$499,642.52
$481,535.49
$523:820.18
$538,617.19
$556,280.89
$574,740.16
$594,039.18
$612,232.72
$617,091.99
$640,359.06
5664,682.62
5690,119.97
$718,552.26
$746,317.05
$775,298.58
$807,517.64
$841,121.56
$874,371.85
$853,025.63
$891,288.26
$931,511.16
$973,794.75
$1,018,244.62
$1,064,971.75
$1,114,092.80
$1,165,730.42
$1,:l2O,013.54
$1,173,784.20

.'" ,170,82.03

~~""I
-,;~...

$274,955.25
$289,041.76
$303,849.94
$319,416.79
$335,781.15
$352,983.89
$371,067.96
$390,078.51
$410,063.01
$431,071.36
$453,156.01
$476,3n.10
$500,777.59
$526,433.43
$553,403.67
$581,755.64
5611,560.15
$642,891.60
$675,828.22
$710,452.25
$746,850.14
$785,112.77
$825,335.66
$867,619.26
$912,069.13
$958,796.26
$1,007,917.31
$1,059,554.93
$1,113,838.04
$1,170,902.20

18,t68,135M

Nole"
. Enter number of years to include GTe water fees, use 100 for indefinate number of years.

f ':Loan'Ras,rve"
. ',.' ';f'uitd; ,
Annual AccuM.

$22,889.72
$26,252.21
$26,278.89
$17,484.37
$17554.01
$17,430.38
$17,487.56
$17,533.07
$17,566.58
$17,405.62

187

$22,8B9.n
$49,141.93
$75,420.63
$66,697.70
$84 251.71
$101,682.09
$119,169.65
$136,702.n
$154,269.30
$171,614.92
$171,614.92
$171,674.92
$171,674.92
$171,674.92
$171,614.92
$171,614.92
$171,674.92
$171,674.92
$171,674.92
$171,614.92
$109,886.69
$109,886.69
$109,886.69
$109,886.69
$109,886.69
$109,886.69
$109,886.69
$109,886.69
$109,886.69
50.00

2

~'~ SO,"

'OR"
~aLaa,.,'"

$112,768.69
$112,768.69
$112,768.69
$112,768.69
$112768.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

13,183,860.80 <"';<1' 1

,:!WO Ocr 'P:alVni.....;OfI
"CWPoALliiiI . iIond~i
-.. ..

$30,303.52
$62,253.43
$61,270.24
$62,075.00
$62771.43
$61,535.15
$62,106.86
$62,562.04
$62,897.06
561,287.54
$61,461.79
$61,518.77
$61,436.83
$61,218.35
$62,680.39
$62,093.21
$61,270.24
$62,157.84
$62,825.14
$61,451.40
561,788.24

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

,...

1 ...

:'?t~Gn,;.;. ;::'i;;t;:~I~f';'
'~'..hd$ :.~iId~'"

$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
56,593.20
$6,593.20
$6,593.20
$6,593.20
56,593.20
56,593.20
56,593.20
$6,593.20
$6,593.20
50.00

$525,368.80
$574,867.58
$588,392.52
$57~,~~.4~
~<23 ",'''A
$538,617.19
$556,280.89
$574,740.16
$594,039.18
$612,232.n
$617,091.99
$640,359.06
$664,682.62
S690,119.97
$718,552.26
$746,317.05
$775,298.58
$807,517.64
$841,121.56
$874,371.85
$853,025.83
$891,288.26
$931,511.16
$973,794.75
$1,018,244.62
$1,064,971.75
$1,114,092.80
$1,165,730.42
$1,220,013.54
$1,173,784.20

,257.80' S23 1374.43