|
City of South Bend, Indiana
<br /> Major Moves Fund 412 Interfund Loan to NE Residential TIF Fund 436
<br /> Eddy Street Commons
<br /> Interfund Loan Amortization Schedule
<br /> November 11, 2013
<br /> Original Principal -$3,942,529 (costs paid by Major Moves Fund) Revised
<br /> Payments -Semi-annual, beginning August 15, 2011 through February 15, 2026.
<br /> Thirty (30) payments. Interest rate -5%
<br /> NE Residental TIF Expenditures -#436-1050-460-38-01 (Principal), #436-1050-460-38-02 (Interest)
<br /> Major Moves Revenue-#412-0000-399-02-06 (Principal), #412-0000-399-02-07(Interest)
<br /> Payment- $186,218.00
<br /> Beginning 5% Ending
<br /> Payment Payment Principal Total Interest Principal Principal
<br /> Number Date Balance Paid Paid Paid Balance
<br /> 1 8/15/2011 3,942,529.00 195,888.00 98,56323 97,324.78 3,845,204.23
<br /> 2 2/1512012 3,845,20423 195,888.00 96,130.11 99,757.89 3,745,446.33
<br /> 3 8/15/2012 3,745,446.33 195,888.00 93,636.16 102,251.84 3,643,194.49
<br /> 4 2/15/2013 3,643,194.49 195,888.00 91,079.86 104.808.14 3,538,386.35
<br /> 5 8/15/2013 3,538,386.35 195,888.00 88,459.66 107.428.34 3,430,958.01
<br /> 6 2/15/2014 3,430,958.01 186,218.00 85,773.95 100.444.05 3,330,513.96
<br /> 7 8/15/2014 3,330,51196 186,218.00 83,262.85 102,955.15 3,227,558.81
<br /> 8 2/15/2015 3,227,558.81 186,218.00 80,688.97 105,529.03 3,122,029.78
<br /> 9 8/15/2015 3,122,029.78 186,218.00 78,050.74 108,167.26 3,013,862.52
<br /> 10 2/15/2016 3,013,862.52 186,218.00 75,346.56 110,871.44 2,902,991.09
<br /> 11 8/15/2016 2,902,991.09 186,218.00 72,574.78 113,64122 2,789,347.86
<br /> 12 2/15/2017 2,789,347.86 186,218.00 69,733.70 116,484.30 2,672.863.56
<br /> 13 8/15/2017 2,672,863.56 186,218.00 66,821.59 119,396.41 2,553,467.15
<br /> 14 2/15/2018 2,553,467.15 186,218.00 63,836.68 122,381.32 2.431,085.83
<br /> 15 8/15/2018 2,431,085.83 186,218.00 60,777.15 125,440.85 2,305,644.97
<br /> 16 2/15/2019 2,305,64497 186,218.00 57,641.12 128,576.88 2,177,068.10
<br /> 17 8/15/2019 2,177,06810 186,218.00 54,426.70 131,791.30 2,045,276.80
<br /> 18 2/15/2020 2,045,276.80 186,218.00 51,131.92 135,086.08 1,910,190.72
<br /> 19 8/15/2020 1,910,190.72 186,218.00 47,754.77 138,463.23 1,771,727.49
<br /> 20 2/15/2021 1,771,727.49 186,218.00 44,293.19 141,924.81 1,629,802.68
<br /> 21 8/15/2021 1,629,802.68 186,218.00 40,745.07 145,472.93 1,484,329.74
<br /> 22 2/15/2022 1,484,329.74 186,218.00 37,108.24 149,109.76 1,335,219.99
<br /> 23 8/15/2022 1,335,219.99 186,218.00 33,380.50 152,837.50 1,182,382.49
<br /> 24 2/15/2023 1,182,382.49 186,218.00 29,559.56 156,658.44 1,025,724.05
<br /> 25 8/15/2023 1,025,724.05 186,218.00 25,643.10 160,574.90 865,149.15
<br /> 26 2/15/2024 865,14915 186,218.00 21,628.73 164,589.27 700,559.88
<br /> 27 8/15/2024 700,559.88 186,218.00 17,514.00 168,704.00 531,855.88
<br /> 28 2/15/2025 531,855.88 186,218.00 13,296.40 172,92160 358,934.27
<br /> 29 8/15/2025 358,934.27 186,218.00 8,973.36 177,244.64 181,689.63
<br /> 30 2/15/2D26 181,689.63 186,231.87 4,542.24 181,689.63
<br /> Total 5,634,903.87 1,692,374.87 3,942,529.00
<br />
|