|
CITY OF SOUTH BEND
<br />Erskine Village Project
<br />Debt Service and Estimated Coverage
<br />Rate Interest Total
<br />$
<br />99,200.67 $
<br />99,200.67
<br />175,060.00
<br />175,060.00 $
<br />_Date
<br />Principal
<br />4/19/2005'-
<br />g/1 /2005'
<br />175,060.00
<br />2/1/2006
<br />175,060.00
<br />8/1/2006-
<br />6.10%
<br />2/1/2007`.'
<br />320,060.00
<br />8/1/2007
<br />170,637.50
<br />2/1/2008
<br />$ 145,000.00
<br />8/1/2008
<br />.
<br />2/1/2009
<br />155,000.00
<br />8/1/2009
<br />6.10%
<br />2/1/2010
<br />165,000.00
<br />8/1/2010
<br />160,877.50
<br />2/1/2011
<br />175,000.00
<br />8/1/2011
<br />335,877.50
<br />2/1/2012
<br />185,000.00
<br />8/1/2012
<br />6.10%
<br />2/1/2013
<br />195,000.00
<br />8/1/2013
<br />149,897.50
<br />2/1/2014
<br />210,000.00
<br />8/1/2014
<br />344,897.50
<br />2/I/2015 "
<br />220,000.00
<br />8/1/2015
<br />6.10%
<br />2/1/2016
<br />235,000.00
<br />/1/2016
<br />137,545.00
<br />/1/2017
<br />250,000.00
<br />8/1/2017
<br />357,545.00
<br />2/1/2018
<br />265,000.00
<br />8/1/2018
<br />6.10%
<br />2/1/2019
<br />280,000.00
<br />8/1/2019
<br />123, 667.50
<br />2/1/2020
<br />300,000.00
<br />8/1/2020
<br />373,667.50
<br />2/1/2021
<br />315,000.00
<br />8/1/2021
<br />6.10%
<br />2/1/2022
<br />335,000.00
<br />8/1/2022
<br />107,960.00
<br />2/1/2023
<br />360,000.00
<br />8/1/2023
<br />387,960.00
<br />2/1/2024
<br />385,000.00
<br />8/1/2024
<br />6.10%
<br />2/1/2025
<br />410,000.00
<br />8/1/2025
<br />90,270.00
<br />2/1/2026
<br />435,000.00
<br />8/1/2026
<br />405,270.00
<br />2/1/2027
<br />465,000.00
<br />80,662.50
<br />Total
<br />$ 5,485,000,00
<br />hi Capitalized interest
<br />69,356.25
<br />CITY OF SOUTH BEND
<br />Erskine Village Project
<br />Debt Service and Estimated Coverage
<br />Rate Interest Total
<br />$
<br />99,200.67 $
<br />99,200.67
<br />175,060.00
<br />175,060.00 $
<br />175,060.00
<br />175,060.00
<br />175,060.00
<br />175,060.00
<br />175,060.00
<br />175,060.00
<br />6.10%
<br />175,060.00
<br />320,060.00
<br />170,637.50
<br />170,637.50
<br />6.10%
<br />170,637.50
<br />325,637.50
<br />165,910.00
<br />165,910.00
<br />6.10%
<br />165,910.00
<br />330,910.00
<br />160,877.50
<br />160,877.50
<br />6.10%
<br />160,877.50
<br />335,877.50
<br />155,540.00
<br />155,540.00
<br />6.10%
<br />155,540.00
<br />340,540.00
<br />149,897.50
<br />149,897.50
<br />6.10%
<br />149,897.50
<br />344,897.50
<br />143,950.00
<br />143,950.00
<br />6.10%
<br />143,950.00
<br />353,950.00
<br />137,545.00
<br />137,545.00
<br />6.10%
<br />137,545.00
<br />357,545.00
<br />130,835.00
<br />130,835.00
<br />6.10%
<br />130,835.00
<br />365,835.00
<br />123, 667.50
<br />123, 667.50
<br />6.10%
<br />123,667.50
<br />373,667.50
<br />116,042.50
<br />116,042.50
<br />6.10%
<br />116,042.50
<br />381,042.50
<br />107,960.00
<br />107,960.00
<br />6.10%
<br />107,960.00
<br />387,960.00
<br />99,420.00
<br />99,420.00
<br />6.10%
<br />99,420.00
<br />399,420.00
<br />90,270.00
<br />90,270.00
<br />6.10%
<br />90,270.00
<br />405,270.00
<br />80,662.50
<br />80,662.50
<br />6.75%
<br />80,662.50
<br />415,662.50
<br />69,356.25
<br />69,356.25
<br />6.75%
<br />69,356.25
<br />429,356.25
<br />57,206.25
<br />57,206.25
<br />6.75%
<br />57,206.25
<br />442,206.25
<br />44,212.50
<br />44,212.50
<br />6.75%
<br />44,212.50
<br />454,212.50
<br />30,375.00
<br />30,375.00
<br />6.75%
<br />30,375.00
<br />465,375.00
<br />15,693.75
<br />15,693.75
<br />6.75%
<br />15,693.75
<br />480,693.75
<br />Fiscal Total
<br />274,260.67 (1)
<br />350,120.00 (1)
<br />495,120.00
<br />496,275.00
<br />496,820.00
<br />496,755.00
<br />496,080.00
<br />494,795.00
<br />497,900.00
<br />495,090.00
<br />496,670.00
<br />497,335.00
<br />497,085.00
<br />495,920.00
<br />498,840.00
<br />495,540.00
<br />496,325.00
<br />498,712.50
<br />499,412.50
<br />498,425.00
<br />495,750.00
<br />496,387.50
<br />EXHIBIT B
<br />TIF Revenues Period
<br />Available Covera¢e
<br />. _ 1
<br />$ 684,187.00
<br />684,187.00
<br />684,187.00
<br />684,187.00
<br />684,187.00
<br />684,187.00
<br />684,187.00
<br />684,187.00
<br />684,187.00
<br />684,187.00
<br />684,187.00
<br />684,187.00
<br />684,187.00
<br />684,187.00
<br />684,187.00
<br />684,187.00
<br />684,187.00
<br />684,187.00
<br />684,187.00
<br />684,187.00
<br />$ 5,074,618.17 $ 10,559,618.17 $ 10,559,618.17 $ 13,683,740.00
<br />Revised to Reflect Results of BonAPricing
<br />M
<br />138.2%
<br />137.9%
<br />137.7%
<br />137.7%
<br />137.9%
<br />138.3%
<br />137.4%
<br />138.2%
<br />137.8%
<br />137.6%
<br />137.6%
<br />138.0%
<br />137.2%
<br />138.1%
<br />137.9%
<br />137.2%
<br />137.0%
<br />137.3%
<br />138.0%
<br />137.8%
<br />
|