$15,685,000
<br /> City of Roseville, Minnesota
<br /> General Obligation Bonds, Series 2012A (Post-Sale)
<br /> Issue Summary
<br /> Derivation Of Form 8038 Yield Statistics
<br /> Maturity Issuance Value Price Issuance Price Exponent Bond Years
<br /> 11/20/2012 - - - - -
<br /> 03/01/2014 430,000.00 102.106% 439,055.80 1.2805556x 562,235.34
<br /> 03/01/2015 855,000.00 105.778% 904,401.90 2.2805556x 2,062,538.78
<br /> 03/01/2016 900,000.00 107.953% 971,577.00 3.2805556x 3,187,312.33
<br /> 03/01/2017 940,000.00 105.342% 990,214.80 4.2805556x 4,238,669.46
<br /> 03/01/2018 955,000.00 105.765% 1,010,055.75 5.2805556x 5,333,655.50
<br /> 03/01/2019 975,000.00 111.498% 1,087,105.50 6.2805556x 6,827,626.49
<br /> 03/01/2020 1,010,000.00 118.087% 1,192,678.70 7.2805556x 8,683,363.54
<br /> 03/01/2021 1,080,000.00 118.456% 1,279,324.80 8.2805556x 10,593,520.08
<br /> 03/01/2022 1,095,000.00 118.911% 1,302,075.45 9.2805556x 12,083,983.55
<br /> 03/01/2023 1,155,000.00 118.499% 1,368,663.45 10.2805556x 14,070,620.63
<br /> 03/01/2024 1,185,000.00 107.704% 1,276,292.40 11.2805556x 14,397,287.32
<br /> 03/01/2025 1,225,000.00 106.091% 1,299,614.75 12.2805556x 15,959,991.14
<br /> 03/01/2026 1,250,000.00 104.505% 1,306,312.50 13.2805556x 17,348,555.73
<br /> 03/01/2027 1,295,000.00 103.038% 1,334,342.10 14.2805556x 19,055,146.49
<br /> 03/01/2028 1,335,000.00 102.493% 1,368,281.55 15.2805556x 20,908,102.24
<br /> Total $15,685,000.00 - $17,129,996.45 - $155,312,608.62
<br /> IRS Form 8038
<br /> Weighted Average Maturity=Bond Years/Issue Price 9.067 Years
<br /> Total Interest from Debt Service 4,599,466.67
<br /> Accrued Interest from 11/01/2012 to 11/20/2012 (25,898.06)
<br /> Reoffering(Premium)or Discount (1,444,996.45)
<br /> Total Interest 3,128,572.16
<br /> NIC=Interest/(Issue Price*Average Maturity) 2.0143710%
<br /> Bond Yield for Arbitrage Purposes 1.9922515%
<br /> 2012,4 GO Bonds-Past-Sal/issue Summary/ 10/22/2012/ 12.45 PM
<br /> Springsted
<br />
|