|
City of Centerville
<br />Exhibit A
<br />Purchase of Trail Project
<br />Refinance of Hidden Springs Project
<br />Fund 402 to Pay 602
<br />Trail Project
<br />825,000.00
<br />Loan Summary
<br />HWden Springs
<br />283,311.88
<br />Payment Type Annual
<br />1,108,311.88
<br />Loan Amount 1,108,311.88
<br />Interest Rate
<br />1M%
<br />Term
<br />15
<br />Payment
<br />83,061.72
<br /># Payment Date
<br />Loan Balance
<br />Principal
<br />Interest
<br />Payment
<br />Balance @ 12131
<br />1
<br />2010
<br />1,108,311.88
<br />1,108,311.88
<br />2
<br />2011
<br />1,108,311.88
<br />1,108,311.88
<br />3
<br />2012
<br />1,108,311.88
<br />-
<br />-
<br />1,108,311.88
<br />4
<br />2013
<br />1,108,311.88
<br />16,624,68
<br />16,624.68
<br />1,108,311.88
<br />5
<br />2014
<br />1,108,311.88
<br />16,624.68
<br />16,624M
<br />1,108,311.88
<br />6
<br />2015
<br />1,108,311.88
<br />66,437.04
<br />16,624.68
<br />83.061.72
<br />1,041,874,83
<br />7
<br />2016
<br />1,041,874.83
<br />67,433,60
<br />15,628.12
<br />83,061.72
<br />974,44124
<br />8
<br />2017
<br />974,441,24
<br />68,445.10
<br />14,616.62
<br />83,061,72
<br />905,996.14
<br />9
<br />2018
<br />905,996.14
<br />69,471.78
<br />13,589,94
<br />83,061.72
<br />836,524.36
<br />10
<br />2019
<br />836,524.36
<br />70,513.85
<br />12,547,87
<br />83,061.72
<br />766,010,50
<br />11
<br />2020
<br />766,010.50
<br />71,571.56
<br />11,490.16
<br />83,061.72
<br />694,438.94
<br />12
<br />2021
<br />694,438.94
<br />72,645.14
<br />10,416.58
<br />83,061.72
<br />621,793,81
<br />13
<br />2022
<br />621,793.81
<br />73,734.81
<br />9,326.91
<br />83,061.72
<br />548,059,00
<br />14
<br />2023
<br />548,059.00
<br />74,840.83
<br />8,220.88
<br />83,06112
<br />473,218.16
<br />15
<br />2024
<br />473,218,16
<br />75,963.45
<br />7,098.27
<br />83,061.72
<br />397,254,71
<br />16
<br />2025
<br />397,254.71
<br />77,102.90
<br />5,958.82
<br />83,061,72
<br />320,151.82
<br />17
<br />2026
<br />320,151,82
<br />78,259.44
<br />4,802,28
<br />63,061.72
<br />241,892.37
<br />18
<br />2027
<br />241,892.37
<br />79,433,33
<br />3,628,39
<br />83,061.72
<br />162,459.04
<br />19
<br />2028
<br />162,459,04
<br />80,624.83
<br />2,436.89
<br />83,061.72
<br />81,834.21
<br />20
<br />2029
<br />81,834.21
<br />81,834.21
<br />1,227,51
<br />83,061.72
<br />(0,00)
<br />1,108,311.88
<br />
|