$15,685,000
<br /> City of Roseville, Minnesota
<br /> General Obligation Bonds, Series 2012A (Post-Sale)
<br /> Issue Summary
<br /> Proof Of Bond Yield @ 1.9922515%
<br /> Date Cashflow PV Factor Present Value Cumulative PV
<br /> 11/20/2012 - 1.0000000x - -
<br /> 09/01/2013 408,916.67 0.9846454x 402,637.92 402,637.92
<br /> 03/01/2014 675,350.00 0.9749338x 658,421.57 1,061,059.50
<br /> 09/01/2014 241,050.00 0.9653181x 232,689.92 1,293,749.42
<br /> 03/01/2015 1,096,050.00 0.9557971x 1,047,601.44 2,341,350.86
<br /> 09/01/2015 228,225.00 0.9463701x 215,985.31 2,557,336.17
<br /> 03/01/2016 1,128,225.00 0.9370360x 1,057,187.48 3,614,523.65
<br /> 09/01/2016 214,725.00 0.9277940x 199,220.57 3,813,744.22
<br /> 03/01/2017 1,154,725.00 0.9186432x 1,060,780.26 4,874,524.48
<br /> 09/01/2017 205,325.00 0.9095826x 186,760.05 5,061,284.53
<br /> 03/01/2018 1,160,325.00 0.9006114x 1,045,001.91 6,106,286.44
<br /> 09/01/2018 195,775.00 0.8917286x 174,578.18 6,280,864.62
<br /> 03/01/2019 1,170,775.00 0.8829335x 1,033,716.49 7,314,581.11
<br /> 09/01/2019 181,150.00 0.8742251x 158,365.88 7,472,946.99
<br /> 03/01/2020 1,191,150.00 0.8656026x 1,031,062.59 8,504,009.59
<br /> 09/01/2020 160,950.00 0.8570652x 137,944.64 8,641,954.23
<br /> 03/01/2021 1,240,950.00 0.8486120x 1,053,085.01 9,695,039.24
<br /> 09/01/2021 139,350.00 0.8402421x 117,087.74 9,812,126.98
<br /> 03/01/2022 1,234,350.00 0.8319548x 1,026,923.38 10,839,050.36
<br /> 09/01/2022 117,450.00 0.8237492x 96,749.34 10,935,799.70
<br /> 03/01/2023 6,227,450.00 0.8156246x 5,079,261.12 16,015,060.82
<br /> 09/01/2023 20,025.00 0.8075800x 16,171.79 16,031,232.61
<br /> 03/01/2024 20,025.00 0.7996149x 16,012.29 16,047,244.89
<br /> 09/01/2024 20,025.00 0.7917283x 15,854.36 16,063,099.25
<br /> 03/01/2025 20,025.00 0.7839194x 15,697.99 16,078,797.24
<br /> 09/01/2025 20,025.00 0.7761876x 15,543.16 16,094,340.40
<br /> 03/01/2026 20,025.00 0.7685321x 15,389.86 16,109,730.25
<br /> 09/01/2026 20,025.00 0.7609520x 15,238.06 16,124,968.32
<br /> 03/01/2027 20,025.00 0.7534468x 15,087.77 16,140,056.09
<br /> 09/01/2027 20,025.00 0.7460155x 14,938.96 16,154,995.05
<br /> 03/01/2028 1,355,025.00 0.7386576x 1,000,899.46 17,155,894.51
<br /> Total $19,907,516.67 - $17,155,894.51 -
<br /> Derivation Of Target Amount
<br /> Par Amount of Bonds $15,685,000.00
<br /> Reoffering Premium or(Discount) 1,444,996.45
<br /> Accrued Interest from 11/01/2012 to 11/20/2012 25,898.06
<br /> Original Issue Proceeds $17,155,894.51
<br /> 2012A GO Bonds-Post-Sal/ Issue Summary/ 10/22/2012/ 12 45 PM
<br /> r Spngsted
<br />
|