$9,200,000
<br /> City of Roseville, Minnesota
<br /> General Obligation Bonds, Series 2012A (Post-Sale)
<br /> $10M Current Projects Portion
<br /> DEBT SERVICE SCHEDULE
<br /> Date Principal Coupon Interest Total P+I
<br /> 09/01/2013 - - 238,291.67 238,291.67
<br /> 03/01/2014 430,000.00 2.000% 142,975.00 572,975.00
<br /> 09/01/2014 - - 138,675.00 138,675.00
<br /> 03/01/2015 505,000.00 3.000% 138,675.00 643,675.00
<br /> 09/01/2015 - - 131,100.00 131,100.00
<br /> 03/01/2016 510,000.00 3.000% 131,100.00 641,100.00
<br /> 09/01/2016 - - 123,450.00 123,450.00
<br /> 03/01/2017 530,000.00 2.000% 123,450.00 653,450.00
<br /> 09/01/2017 - - 118,150.00 118,150.00
<br /> 03/01/2018 535,000.00 2.000% 118,150.00 653,150.00
<br /> 09/01/2018 - - 112,800.00 112,800.00
<br /> 03/01/2019 565,000.00 3.000% 112,800.00 677,800.00
<br /> 09/01/2019 - - 104,325.00 104,325.00
<br /> 03/01/2020 565,000.00 4.000% 104,325.00 669,325.00
<br /> 09/01/2020 - - 93,025.00 93,025.00
<br /> 03/01/2021 615,000.00 4.000% 93,025.00 708,025.00
<br /> 09/01/2021 - - 80,725.00 80,725.00
<br /> 03/01/2022 630,000.00 4.000% 80,725.00 710,725.00
<br /> 09/01/2022 - - 68,125.00 68,125.00
<br /> 03/01/2023 680,000.00 4.000% 68,125.00 748,125.00
<br /> 09/01/2023 - - 54,525.00 54,525.00
<br /> 03/01/2024 700,000.00 3.000% 54,525.00 754,525.00
<br /> 09/01/2024 - - 44,025.00 44,025.00
<br /> 03/01/2025 715,000.00 3.000% 44,025.00 759,025.00
<br /> 09/01/2025 - - 33,300.00 33,300.00
<br /> 03/01/2026 720,000.00 3.000% 33,300.00 753,300.00
<br /> 09/01/2026 - - 22,500.00 22,500.00
<br /> 03/01/2027 740,000.00 3.000% 22,500.00 762,500.00
<br /> 09/01/2027 - - 11,400.00 11,400.00
<br /> 03/01/2028 760,000.00 3.000% 11,400.00 771,400.00
<br /> Total $9,200,000.00 - $2,653,516.67 $11,853,516.67
<br /> SIGNIFICANT DATES
<br /> Dated Date 11/01/2012
<br /> Delivery Date 11/20/2012
<br /> First Coupon Date 9/01/2013
<br /> Accrued Interest from 11/01/2012 to 11/20/2012 15,091.81
<br /> Yield Statistics
<br /> Accrued Interest from 11/01/2012 to 11/20/2012 15,091.81
<br /> Bond Year Dollars $82,481.11
<br /> Average Life 8.965 Years
<br /> Average Coupon 3.2171204%
<br /> Net Interest Cost(NIC) 2.2430873%
<br /> True Interest Cost(TIC) 2.1083212%
<br /> Bond Yield for Arbitrage Purposes 1.9922515%
<br /> All Inclusive Cost(AIC) 2.1699807%
<br /> IRS Form 8038
<br /> Net Interest Cost 2.0117191%
<br /> Weighted Average Maturity 8.934 Years
<br /> Z012A GO Bonds•Post-Sal/ $10M Current Projects For/ 10/ZZ/2012/ 12:45 PM
<br /> ,,, Springsted
<br />
|