|
Loan Payment Analysis
<br />City of Cooper
<br />Loan Amoiurt
<br />Srtmy�le Interest Rate
<br />Atmual Paycrent
<br />Loan Fimded
<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 />$10,430.27
<br />Prepaid [rrterest $ 1,357.92 in the frtst paymerrt only
<br />Year # Date Balance Irrterest Rate Irrterest Payment(PMT; Principal Irterest
<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 />11 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 />18 03/29/2030
<br />19 03/29/2031
<br />20 03/29/2032
<br />95422970.15
<br />$147,600.00
<br />$140,790.85
<br />$135,541.68
<br />$13Q099.35
<br />$124,456.73
<br />$ ll 8,606.47
<br />$112,540.92
<br />$106,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.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,033.25
<br />$1,72424
<br />$1,403.86
<br />$1,071.69
<br />$727.29
<br />$370.22
<br />Totals
<br />$ ] 0,430.27
<br />$10,4302�
<br />$10,43027
<br />$10,43027
<br />$10,43027
<br />$10,43027
<br />$10,43027
<br />$10,430.27
<br />$1Q43027
<br />$10,430.27
<br />$ I Q43027
<br />$10,43027
<br />$10,43027
<br />$1 Q43027
<br />$10,430.27
<br />$10,43027
<br />$10,43027
<br />$10,43027
<br />$1 Q43027
<br />$]0,43027
<br />$208,605.40
<br />C-3-1
<br />$6,809.15
<br />$5,24917
<br />$5,44234
<br />$5,642.61
<br />$5,85026
<br />$6,065.55
<br />$6,288.76
<br />$6,520.19
<br />$6,760.13
<br />$7,00891
<br />$7,266.83
<br />$7,53425
<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 />$1Q06031
<br />$147,600.00
<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,724.24
<br />$1,403.86
<br />$1,071.69
<br />$727.29
<br />$370.22
<br />$61,005.66
<br />Balance after PMT Ciurndative hrteresl
<br />$140,790.85
<br />$135,541.68
<br />$130,099.35
<br />$124,456.73
<br />$118,606.47
<br />$1 12,540.92
<br />$106,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,251.34
<br />$46,85432
<br />$38,148.29
<br />$29,121.88
<br />$19,763.29
<br />$10,06031
<br />$0.00
<br />$3,62112
<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,244.26
<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 />$60,635.44
<br />$61,005.66
<br />
|