COLORADO WATER CONSER [CATION BOARD
<br />LOAN REPAYMENT SCHEDULE
<br />Borrower Farmers Pawnee Canal
<br />Company
<br />Loan Contract Number C150272
<br />Principal $255,530.00
<br />Interest Rate 2.50%
<br />Frequency
<br />Annual
<br />Term (In Years)
<br />30
<br />First Payment Due
<br />June 1, 2013
<br />Payment Amount
<br />$12,208.62
<br />Loan
<br />Payment
<br />Annual
<br />Payment
<br />I Annual
<br />Payment
<br />Principal
<br />Interest
<br />Principal
<br />BALANCE
<br />No.
<br />Due Date
<br />Amount
<br />2
<br />1- Jun -14
<br />$12,208.62
<br />$ 255,530.00
<br />1
<br />1- Jun -13
<br />$12,208.62
<br />$
<br />5,820.37
<br />$
<br />6,388.25
<br />$
<br />249,709.63
<br />2
<br />1- Jun -14
<br />$12,208.62
<br />$
<br />5,965.88
<br />$
<br />6,242.74
<br />$
<br />243,743.75
<br />3
<br />1- Jun -15
<br />$12,208.62
<br />$
<br />6,115.03
<br />$
<br />6,093.59
<br />$
<br />237,628.72
<br />4
<br />1- Jun -16
<br />$12,208.62
<br />$
<br />6,267.90
<br />$
<br />5,940.72
<br />$
<br />231,360.82
<br />5
<br />1- Jun -17
<br />$12,208.62
<br />$
<br />6,424.60
<br />$
<br />5,784.02
<br />$
<br />224,936.22
<br />6
<br />1- Jun -18
<br />$12,208.62
<br />$
<br />6,585.21
<br />$
<br />5,623.41
<br />$
<br />218,351.01
<br />7
<br />1- Jun -19
<br />$12,208.62
<br />$
<br />6,749.84
<br />$
<br />5,458.78
<br />$
<br />211,601.17
<br />8
<br />1- Jun -20
<br />$12,208.62
<br />$
<br />6,918.59
<br />$
<br />5,290.03
<br />$
<br />204,682.58
<br />9
<br />1- Jun -21
<br />$12,208.62
<br />$
<br />7,091.56
<br />$
<br />5,117.06
<br />$
<br />197,591.02
<br />10
<br />1- Jun -22,
<br />$12,208.62
<br />$
<br />7,268.84
<br />$
<br />4,939.78
<br />$
<br />190,322.18
<br />11
<br />1- Jun -23
<br />$12,208.62
<br />$
<br />7,450.57
<br />$
<br />4,758.05
<br />$
<br />182,871.61
<br />12
<br />1- Jun -24
<br />$12,208.62
<br />$
<br />7,636.83
<br />$
<br />4,571.79
<br />$
<br />175,234.78
<br />13
<br />1- Jun -25
<br />$12,208.62
<br />$
<br />7,827.75
<br />$
<br />4,380.87
<br />$
<br />167,407.03
<br />14
<br />1- Jun -26
<br />$12,208.62
<br />$
<br />8,023.44
<br />$
<br />4,185.18
<br />$
<br />159,383.59
<br />15
<br />1- Jun -27
<br />$12,208.62
<br />$
<br />8,224.03
<br />$
<br />3,984.59
<br />$
<br />151,159.56
<br />16
<br />1- Jun -28
<br />$12,208.62
<br />$
<br />8,429.63
<br />$
<br />3,778.99
<br />$
<br />142,729.93
<br />17
<br />1- Jun -29
<br />$12,208.62
<br />$
<br />8,640.37
<br />$
<br />3,568.25
<br />$
<br />134,089.56
<br />18
<br />1- Jun -30
<br />$12,208.62
<br />$
<br />8,856.38
<br />$
<br />3,352.24
<br />$
<br />125,233.18
<br />19
<br />1- Jun -31
<br />$12,208.62
<br />$
<br />9,077.79
<br />$
<br />3,130.83
<br />$
<br />116,155.39
<br />20
<br />1- Jun -32
<br />$12,208.62
<br />$
<br />9,304.74
<br />$
<br />2,903.88
<br />$
<br />106,850.65
<br />21
<br />1- Jun -33
<br />$12,208.62
<br />$
<br />9,537.35
<br />$
<br />2,671.27
<br />$
<br />97,313.30
<br />22
<br />1- Jun -34
<br />$12,208.62
<br />$
<br />9,775.79
<br />$
<br />2,432.83
<br />$
<br />87,537.51
<br />23
<br />1- Jun -35
<br />$12,208.62
<br />$
<br />10,020.18
<br />$
<br />2,188.44
<br />$
<br />77,517.33
<br />24
<br />1- Jun -36
<br />$12,208.62
<br />$
<br />10,270.69
<br />$
<br />1,937.93
<br />$
<br />67,246.64
<br />25
<br />1- Jun -37
<br />$12,208.62
<br />$
<br />10,527.45
<br />$
<br />1,681.17
<br />$
<br />56,719.19
<br />26
<br />1- Jun -38
<br />$12,208.62
<br />$
<br />10,790.64
<br />$
<br />1,417.98
<br />$
<br />45,928.55
<br />27
<br />1- Jun -39
<br />$12,208.62
<br />$
<br />11,060.41
<br />$
<br />1,148.21
<br />$
<br />34,868.14
<br />28
<br />1- Jun-40
<br />$12,208.62
<br />$
<br />11,336.92
<br />$
<br />871.70
<br />$
<br />23,531.22
<br />29
<br />1- Jun-41
<br />$12,208.62
<br />$
<br />11,620.34
<br />$
<br />588.28
<br />$
<br />11,910.88
<br />30
<br />1- Jun -42
<br />$12,208.65
<br />$
<br />11,910.88
<br />$
<br />297.77
<br />$
<br />-
<br />TOTALS 1 $366,258.63 1 $255,530.00 1 $110,728.63 1 $0.00
<br />Amon Farmers Pawnee C150272 1008.xls SSB 6/5/2012
<br />
|