Preliminary
<br /> City of Centerville, Minnesota
<br /> $1,545,000.00 General Obligation Improvement Bonds, Series 2013A
<br /> (interest rates based on 8/8/12 market plus .20 %)
<br /> (AA rated / 15 -year term)
<br /> Debt Service Schedule
<br /> Date Principal Coupon Interest Total P +I Fiscal Total
<br /> 08/01:2013 - - - - -
<br /> 08/01/2014 - 32,070.00 32,070.00 -
<br /> 02/01/2015 10,000.00 0-700% 16.035.00 26,035.00 58,105.00
<br /> 08/01/2015 - - 16,000.00 16,000.00 -
<br /> 02/01/2016 20,000.00 0.850% 16,000.00 36,000.00 52,000.00
<br /> 08/01/2016 - 15,915.00 15,915.00 -
<br /> 02/01/2017 20,000.00 1.000°% 15,915.00 35,915.00 51,830.00
<br /> 08/01/2017 - - 15.815.00 15,815.00 -
<br /> 02/01/2018 20,000.00 1.200% 15,815.00 35,815.00 51.630.00
<br /> 08/01/2018 - - 15,695.00 15,695.00
<br /> 02/01/2019 20,000.00 1.350% 15.695.00 35,695.00 51,390.00
<br /> 08/01/2019 - - 15,560.00 15,560.00 -
<br /> 02/01/2020 25,000.00 1.500% 15360.00 40,560.00 56,120.00
<br /> 08/01/2020 - - 15.372.50 15.372.50 -
<br /> 02/01/2021 140,000.00 1.650% 15,372.50 155,372.50 170,745.00
<br /> 08/01/2021 - - 14,217.50 14 17.50 -
<br /> 02/01/2022 145.000.00 1.750!'., 14,217.50 159 217.50 173,435.00
<br /> 08/01/2022 - - 12,948.75 12,948.75 -
<br /> 02/01/2023 150,000.00 1.900% 12,948.75 162,948.75 175,897.50
<br /> 08/01/2023 - - 11,523.75 11.523.75 -
<br /> 02/01/2024 155.000.00 2.000% 11,523.75 166,523.75 178.04730
<br /> 08/01/2024 - - 9,973.75 9,973.75 -
<br /> 02/01/2025 160,000.00 2.150% 9,973.75 169,973.75 179,947.50
<br /> 08/01/2025 - - 8,253.75 8,253.75 -
<br /> 02/01/2026 165,000.00 2.250% 8,253.75 173.253.75 181,507.50
<br /> 08/01/2026 - - 6,397.50 6,397.50 -
<br /> 02/01 /2027 170,000.00 2.350% 6.397.50 176,397.50 182,795.00
<br /> 08/01/2027 - - 4,400.00 4,400.00 -
<br /> 02/01 /2028 170,000.00 2.500% 4.400.00 174,400.00 178,800.00
<br /> 08/01/2028 - - 2,275.00 2,275.00 -
<br /> 02/01/2029 175,000.00 2.600% 2,275.00 177,275.00 179,550.00
<br /> Tonal S1,545,000.00 - S376,800.00 51.921,800.00 -
<br /> Date And Term Structure
<br /> Dated 8/01/2013
<br /> Delivery Date 8/01/2013
<br /> First Coupon Date 8/01/2014
<br /> First available call date 2/01. 2020
<br /> Call Price 100.0000000%
<br /> Yield Statistics
<br /> Bond Year Dollars 517,20750
<br /> Average Life 1 1.138 Yeats
<br /> Average Coupon 2.1897428%
<br /> Net Interest Cost (NW) 2.2795293%
<br /> True Interest Cost (TIC) 281549134
<br /> All inclusive Cost (AIC) 2.4625661%
<br /> IRS Form 8038
<br /> Net Interest Cost 2.189742854
<br /> Weighted Average Maturity 1 1.138 Yeats
<br /> Bond Yield for Arbitrage Purposes 2.1789215:4
<br /> 2013 429 1 SINGLE PURPOSE 1 81212012 1 12:18 PM
<br /> Northland Securities Inc.
<br /> Public Finance Page 2
<br />
|