City of South Bend
<br />Douglas Road Project
<br />Mishawaka TIF Loan
<br />Amortization of Loan to Project to be
<br />Repaid from Project TIF Revenue
<br />Prepared 1/13/09
<br />Original
<br />Capitalized
<br />New
<br />Principal
<br />Interest
<br />Principal
<br />Payment
<br />Principal
<br />1,150,000
<br />0
<br />1,150,000
<br />$45,811.67
<br />Rate
<br />0.05
<br />Term (Yrs)
<br />20
<br />Payment
<br />Interest
<br />Principal
<br />Balance
<br />Beginning Balance
<br />1,150,000
<br />8/15/2009
<br />45,812
<br />28,750
<br />17,062
<br />1,132,938
<br />2/15/2010
<br />45,812
<br />28,323
<br />17,488
<br />1,115,450
<br />8/15/2010
<br />45,812
<br />27,886
<br />17,925
<br />1,097,525
<br />2/15/2011
<br />45,812
<br />27,438
<br />18,374
<br />1,079,151
<br />8/15/2011
<br />45,812
<br />26,979
<br />18,833
<br />1,060,318
<br />2/15/2012
<br />45,812
<br />26,508
<br />19,304
<br />1,041,015
<br />8/15/2012
<br />45,812
<br />26,025
<br />19,786
<br />1,021,228
<br />2/15/2013
<br />45,812
<br />25,531
<br />20,281
<br />1,000,947
<br />8/15/2013
<br />45,812
<br />25,024
<br />20,788
<br />980,159
<br />2/15/2014
<br />45,812
<br />24,504
<br />21,308
<br />958,852
<br />8/15/2014
<br />45,812
<br />23,971
<br />21,840
<br />937,011
<br />2/15/2015
<br />45,812
<br />23,425
<br />22,386
<br />914,625
<br />8/15/2015
<br />45,812
<br />22,866
<br />22,946
<br />891,679
<br />2/15/2016
<br />45,812
<br />22,292
<br />23,520
<br />868,159
<br />8/15/2016
<br />45,812
<br />21,704
<br />24,108
<br />844,051
<br />2/15/2017
<br />45,812
<br />21,101
<br />24,710
<br />819,341
<br />8/15/2017
<br />45,812
<br />20,484
<br />25,328
<br />794,013
<br />2/15/2018
<br />45,812
<br />19,850
<br />25,961
<br />768,052
<br />8/15/2018
<br />45,812
<br />19,201
<br />26,610
<br />741,441
<br />2/15/2019
<br />45,812
<br />18,536
<br />27,276
<br />714,166
<br />8/15/2019
<br />45,812
<br />17,854
<br />27,958
<br />686,208
<br />2/15/2020
<br />45,812
<br />17,155
<br />28,656
<br />657,552
<br />8/15/2020
<br />45,812
<br />16,439
<br />29,373
<br />628,179
<br />2/15/2021
<br />45,812
<br />15,704
<br />30,107
<br />598,071
<br />8/15/2021
<br />45,812
<br />14,952
<br />30,860
<br />567,212
<br />2/15/2022
<br />45,812
<br />14,180
<br />31,631
<br />535,580
<br />8/15/2022
<br />45,812
<br />13,390
<br />32,422
<br />503,158
<br />2/15/2023
<br />45,812
<br />12,579
<br />33,233
<br />469,925
<br />
|