|
<br />-
<br />
<br />-
<br />
<br />-
<br />
<br />-
<br />
<br />-
<br />
<br />-
<br />
<br />-'-
<br />
<br />-
<br />
<br />-
<br />
<br />-
<br />
<br />-
<br />
<br />-
<br />
<br />-
<br />
<br />-
<br />
<br />-
<br />
<br />-
<br />
<br />-
<br />
<br />-
<br />
<br />Table 4
<br />
<br />Town of Johnstown
<br />Raw Water Improvement Projects
<br />Schedule of Revenues and Expenditures -1.08% Growth with Golden Technologies
<br />
<br />" ,': ',AStUmbtions "
<br />
<br />.' . FI...ndng. 7'"~,;, ' , ,- '~.;'-~+..
<br />"uon so"", Principal ,....... y.... payment
<br />ewes loan 75% $1,950,000,00 '.00% 30 $112,768,69
<br />CWPQA Loan 25% $650,000,00 Variable 20 Variable
<br />
<br />T etal Project Cost
<br />Annual Operating Expenses
<br />Number of ClJStOmers
<br />Golden Technologies (GTC).
<br />Water Fees (per customer)
<br />Water Fee (GTC)
<br />Tap Fee
<br />Inflation (per year)
<br />Growth (per year)
<br />Interest Rate on ReseMilS
<br />
<br />$2,600,000,00
<br />$366,607.00
<br />7.'
<br />100
<br />S405.51
<br />$253,000.00
<br />SO.OO
<br />'00%
<br />1.08%
<br />6.00%
<br />
<br />Notes:
<br />. Enter number of years to include GTC water fees, use 100 for Indefinate number of years.
<br />
<br />-
<br />00
<br />
<br />, ~....!'f ~'yt war ""\~!,,:,.' .' T8p,'~ ~; ."T~.~! AnnualOperatfna ~n !MM1Ve . !"OYments on ' .n;'~ i, __,' ,O!' Wf~ Oft,"" ,""~#'L;J~,jt~.
<br /> '_";~ii"b"'> e,_' ~~i16
<br />O' , ..,...tt.r ),1 F-. bw~. Ex,...... . Fund !'WC8 ...... ... CWPDA LoMi. c............., ,~~~
<br />. Town . '. GTC'" Annual ACeilln. ' . .. .'
<br />1 $320,758.41 $253,000,00 SO.OO $573,758.41 $366,607.00 $22,889.72 522,889.72 $112,768.69 $30,303.52 $85,825.00 $1,373.38 5617,020.55
<br />2 $327,869.25 $255,845.58 SO.OO $583,714.83 S385,389,01 $26,252.21 $49,141.93 $112,768,69 $62,253.43 $87,500.00 $2,948.52 $671,214.83
<br />3 $339,124.73 5261,801.10 SO.OO $600,925.83 ~05, 133.26' $26,278.89 $75,420.83 $112,768.69 $61,270.24 $88,750.00 $4,525.25 $689,675.83
<br />. $333,386.45 $254,621.29 SO.OO $588,007.75 ~25,889.05 $17,484.37 $66,697.70 $112,768.69 $62,075.00 $89,590.00 ~,OO1.86 $677,597.75
<br />S un,1.'N.lIf m~~1.l!..'\~ "'."" ~,lf,l.n 'Softfo1 ,"Wb..~ "."l,$21.'M '$b.Il,~"l.1"l "\"lY.i:,78tl.&I S62,n1.43 $5,055.10 $635,747.23
<br />6 $375,550.89 $280,727.59 SO.OO 1656,278.49 ~70,645.18 $17,430.38 $101,682.09 $112,768.69 $61,535.15 $6,100.93 5656,278.49
<br />7 $390,894.87 $289,075.34 so 00 $679,970.21 ~94,757.27 $17,487.56 $119,169.65 $112,768.69 $62,106.86 $7,150.18 $679,970.21
<br />6 S406,998.15 $297,768.17 SO.OO $704,766.33 5520,104.68 $17,533.07 $136,702.72 $112,768.69 $62,562.04 $8,202.16 $704,766.33
<br />. ~23,903.83 $306,823.02 SO.OO $730,726.85 $546,750.68 $17,566.58 $154,269.30 $112,768.69 $62,897.06 $9,256.16 $730,726.85
<br />10 ~40,496.74 $315,426.42 SO.OO $755,923.17 $574,761.81 $17,405.62 $171,674.92 $112,768.69 561,287.54 $10,300.50 $755,923.17
<br />11 $449,622.75 $318,521.25 SO.OO $768,144.00 $604,208 01 $171,674.92 $112,768.69 $61,467.79 $10,300.50 $768,144.00
<br />12 $469,853.25 $329,296.52 so 00 $799,149.76 $635,162.80 $171,674.92 $112,768.69 $61,518.n $10,300.50 $799,149.76
<br />13 ~91 ,099.23 S340,509.26 SO.oo $831,608.49 5667,703.46 $171,674.92 $112,768.69 $61,436.83 $10,300.50 $831,608.49
<br />" $513,417.47 $352,180.32 SO.OO $865,597.78 $701,911.24 $171,674.92 $112,768.69 $61,218.35 $10,300.50 $865,597.78
<br />15 $537,952.61 $365,067.54 SO.OO $903,020.15 $737,871.56 $171,674.92 $112,768.69 $62,680.39 $10,300.50 $903,020.15
<br />16 S562,552.n $377,682.83 SO.OO S940,235.60 $n5,674.19 $171,674.92 $112,768.69 $62,093.21 $10,300.50 $940,235.60
<br />17 S588,362.03 $390,789.94 SO.OO $979,151.97 $815,413.53 $171,674.92 $112,768.69 $61,270.24 $10,300.50 $979,151.97
<br />18 $616,621.20 $405,187.64 SO.OO $1,021,814.84 S857,188.80 $171,674.92 $112,768.69 $62,157.84 $10,300.50 $1,021,814.84
<br />1. $646,269.40 ~2O,128.23 SO.OO $1,066,397.63 $901,104.29 $171,674.92 $112,768.69 $62,825.14 $10,300.50 $1,066,397.63
<br />20 $676,261.16 ~34,928.11 SO.OO $1,111,189.27 5947,269.67 $171,674.92 $112,768.69 561,451.40 $10,300.50 $1,111,189.21
<br />21 $673,470.32 ~28,505.36 SO.OO $1,101,975.68 $995,800.19 $109,886.69 $112,768.69 561,788.24 $6,593.20 $1,101,975.68
<br />22 $707,589.00 $445,403.52 SO.OO $1,152,992.52 $1,046,817.02 $109,886.69 $112,768.69 $6,593.20 $1,152,992.52
<br />23 $743,571.02 $463,052.03 SO.OO $1,206,623.05 $1,100,447.55 $109,886.69 $112,768.69 $6,593.20 $1,206,623.05
<br />2. $781,518.02 $481,483.16 SO.OO $1,263,001.17 $1,156,825.68 $109,886.69 $112,768.69 $6,593.20 $1,263,001.17
<br />25 $821,537.14 $500,730.53 SO.OO $1,322,267.67 $1,216,092.18 $109,886.69 $112,768.69 $6,593.20 $1,322,267.67
<br />28 $863,741.30 $520,829.20 SO.OO $1,384,570.50 $1,278,395.01 $109,886.69 $112,768.69 $6,593.20 $1,384,570.50
<br />27 S90B,249.53 $541,815.70 SO.OO $1,450,065 24 $1,343,889.74 $109,886.69 $112,768.69 $6,593.20 $1,450,065.24
<br />28 $955,187.27 $563,728.12 SO.OO $1,518,915.39 $1,412,739.90 $109,886.69 $112,768.69 $6,593.20 $1,518,915.39
<br />29 $1,004,686.74 $586,606.15 SO.OO $1,59'1,292.89 $1,485,117.39 $109,886.69 $112,768.69 $6,593.20 $1,591,292.89
<br />30 $991,413.49 $572,671.45 SO.OO $1,564,084.94 $1,561,202.93 SO.OO $112,768.69 $0.00 $1,564,084.94
<br />-" 1112A,O.U8 . .-'11127 ,12 -.;::r;):" .'f ,351 17.60 .878.581.28 187,882.42 "'- SO.80 S3.,3O,060.80 -' 11.268,970.47 1351;665..00 ' '.. 221,257.80 S2I 661 011.71
<br />
|