|
Loan Payment Analysis
<br />City of Cooper
<br />Loan Amowrt
<br />Sunple Icrterest Rate
<br />Acmual Payment
<br />Loan F�mded
<br />EXHIBIT C-3
<br />CITY OF COOPER, TEXAS AMORTIZATION
<br />SCHEDULE FOR ITS PORTION OF THE SIB LOAN
<br />10.29.2012
<br />$147,600.00
<br />3.68% 360 basis
<br />$ ] 0,43027
<br />Prepaid Irnerest $ 1,357.92 u� the fust payment onty
<br />Year # Date Balance Itrterest Rate Icrterest Payment(PMT; Prmcipal
<br />1 03/29/2013
<br />2 03/29/2014
<br />3 03/29/2015
<br />4 03/29/2016
<br />5 03/29/2017
<br />6 03/29/2018
<br />7 03/29/2019
<br />8 �03/29/2020
<br />9 03/29/2021
<br />10 03/29/2022
<br />I 1 03/29/2023
<br />12 �03/29/2024
<br />13 03/29/2025
<br />14 03/29/2026
<br />15 03/29/2027
<br />16 03/29/2028
<br />17 03/29/2029
<br />] 8 03/29/2030
<br />19 03/29/2031
<br />20 03/29/2032
<br />$147,600.00
<br />$140,790.85
<br />$135,541.68
<br />$13Q09935
<br />$124,456.73
<br />$118,606.47
<br />$112,540.92
<br />$ ] 06,252.15
<br />$99,731.96
<br />$92,971.83
<br />$85,962.92
<br />$78,696.09
<br />$71,161.84
<br />$63,35032
<br />$55,25134
<br />$46,854.32
<br />$38,14829
<br />$29,121.88
<br />$19,763 29
<br />$1Q06031
<br />0.0368
<br />0.0368
<br />0.0368
<br />0.0368
<br />0.0368
<br />0.0368
<br />0.0368
<br />0.0368
<br />0.0368
<br />0.0368
<br />0.0368
<br />0.0368
<br />0.0368
<br />0.0368
<br />0.0368
<br />0.0368
<br />0.0368
<br />0.0368
<br />0.0368
<br />0.0368
<br />$3,621.12
<br />$5,181.10
<br />$4,987.93
<br />$4,787.66
<br />$4,580.01
<br />$4,364.72
<br />$4,141.51
<br />$3,910.08
<br />$3,670.14
<br />$3,42136
<br />$3,163.44
<br />$2,896.02
<br />$2,618.76
<br />$2,33129
<br />$2,03325
<br />$ ] ,72424
<br />$1,403.86
<br />$1,071.69
<br />$72729
<br />$37022
<br />Totals
<br />$ I 0,430.27
<br />$10,43027
<br />$1 Q430.27
<br />$10,43027
<br />$10,43027
<br />$10,43027
<br />$10,43027
<br />$10,430.27
<br />$10,43027
<br />$ ] 0,43027
<br />$1Q43027
<br />$ ] 0,43027
<br />$10,430.27
<br />$ ] 0,43027
<br />$ ] 0,43027
<br />$1 Q430.27
<br />$1 Q43027
<br />$10,430.27
<br />$10,43027
<br />$10,43027
<br />5208,605.40
<br />95422970.15 C-3 -1
<br />$6, 809.15
<br />$5,249.17
<br />$5,44234
<br />$5,642.61
<br />$5,850.26
<br />$6,065.55
<br />$6,288.76
<br />$6,520.19
<br />$6,760.13
<br />$7,008.91
<br />$7,266.83
<br />$7,534.25
<br />$7, 811.51
<br />$8,098.98
<br />$8,397.02
<br />$8,706.03
<br />$9,026.41
<br />$9,358.58
<br />$9,702.98
<br />$ ] 0,06031
<br />$147,600.00
<br />Irrterest
<br />$3,621.12
<br />$5,181.10
<br />$4,987.93
<br />$4,787.66
<br />$4,580.01
<br />$4,364.72
<br />$4,141.51
<br />$3,910.08
<br />$3,670.14
<br />$3,421.36
<br />$3,163.44
<br />$2,896.02
<br />$2,618.76
<br />$2,331.29
<br />$2,03325
<br />$1,72424
<br />$1,403.86
<br />$1,071.69
<br />$72729
<br />$37022
<br />$61,005.66
<br />Balance after PMT Ctm�ulative Irrteresl
<br />$140,'790.85
<br />$135,541.68
<br />$130,09935
<br />$124,456.73
<br />$1 ] 8,606.47
<br />$112,540.92
<br />$ ] 06,252.15
<br />$99,731.96
<br />$92,971. 83
<br />$85,962.92
<br />$78,696.09
<br />$71,161.84
<br />$63,35032
<br />$55,25134
<br />$46,85432
<br />$38,14829
<br />$29,121.88
<br />$19,76329
<br />$10,060.31
<br />$0.00
<br />$3,621.12
<br />$8,80222
<br />$13,790.16
<br />$18,577.81
<br />$23,157.82
<br />$27,522.54
<br />$31,664.04
<br />$35,574.12
<br />$39,24426
<br />$42,665.62
<br />$45,829.06
<br />$48,725.08
<br />$51,343.83
<br />$53,675.12
<br />$55,70837
<br />$57,432.61
<br />$58,836.47
<br />$59,908.15
<br />$6Q635.44
<br />$61,005.66
<br />
|