|
$4,365,000.00 City of Ramsey, Minnesota
<br />General Obligation Bonds, Series• 2011 A
<br />FINAL
<br />Proof Of Bond Yield @ 2.6701816%
<br />Date
<br />09/07/2011
<br />08/01/2012
<br />02/01/2013
<br />08/01/2013
<br />02/01/2014
<br />08/01/2014
<br />02/01/2015
<br />08/01/2015
<br />02/01/2016
<br />08/01/2016
<br />02/01/2017
<br />08/01/2017
<br />02/01/2018
<br />08/01/2018
<br />02/01/2019
<br />08/01/2019
<br />02/01/2020
<br />08/01/2020
<br />02/01/2021
<br />08/01/2021
<br />02/01/2022
<br />08/01/2022
<br />02/01/2023
<br />08/01/2023
<br />02/01/2024
<br />08/01/2024
<br />02/01/2025
<br />08/01/2025
<br />02/01/2026
<br />08/01/2026
<br />02/01/2027
<br />08/01/2027
<br />02/01/2028
<br />08/01/2028
<br />02/01/2029
<br />08/01/2029
<br />02/01/2030
<br />08/01/2030
<br />02/01/2031
<br />08/01/2031
<br />02/01/2032
<br />Cashflow
<br />99,994,58
<br />274,542.50
<br />52,342.50
<br />317,342.50
<br />49,692.50
<br />319,692.50
<br />46,992.50
<br />421,992.50
<br />43,242.50
<br />388,242.50
<br />39,792.50
<br />389,792.50
<br />36,292.50
<br />396,292.50
<br />32,602.50
<br />397,602.50
<br />28,313.75
<br />398,313.75
<br />23,596.25
<br />403,596.25
<br />18,561.25
<br />108,561.25
<br />17,233.75
<br />112,233.75
<br />15,832.50
<br />115,832.50
<br />14,257,50
<br />114,257.50
<br />12,682.50
<br />117,682.50
<br />10,923.75
<br />115,923,75
<br />9,165.00
<br />119,165.00
<br />7,020.00
<br />122,020.00
<br />4,777.50
<br />124,777.50
<br />2,437.50
<br />127,437.50
<br />PV Factor
<br />1.0000000x
<br />0.9764101x
<br />0.9635459x
<br />0.9508511x
<br />0.9383237x
<br />0.9259612x
<br />0.9137617x
<br />0.9017229x
<br />0.8898427x
<br />0.8781190x
<br />0.8665498x
<br />0.8551329x
<br />0.8438666x
<br />0.8327486x
<br />0.8217771 x
<br />0.8109502x
<br />0.8002659x
<br />0.7897224x
<br />0.7793178x
<br />0,7690503x
<br />0.7589181x
<br />0.7489193x
<br />0.7390523x
<br />0.7293153x
<br />0.7197065x
<br />0.7102244x
<br />0,7008672x
<br />0,6916333x
<br />0.6825210x
<br />0.6735288x
<br />0.6646550x
<br />0.6558982x
<br />0.6472567x
<br />0.6387291x
<br />0.6303138x
<br />0.6220094x
<br />0.6138145x
<br />0.6057275x
<br />0.5977470x
<br />0.5898717x
<br />0.5821001x
<br />Present Cumulative
<br />Value PV
<br />97,635.72 97,635.72
<br />264,534.29 362,170.01
<br />49,769.93 411,939.93
<br />297,769.98 709,709.91
<br />46,013.33 755,723.24
<br />292,122.76 1,047,846.00
<br />42,374.21 1,090,220.21
<br />375,506.93 1,465,727.14
<br />37,972.06 1,503,699.20
<br />336,431.44 1,840,130.64
<br />34,027.88 1,874,158.52
<br />328,932.86 2,203,091.38
<br />30,222.53 2,233,313.90
<br />325,664.12 2,558,978.02
<br />26,439.00 2,585,417.03
<br />318,187.74 2,903,604.77
<br />22,360.00 2,925,964.77
<br />310,413.01 3,236,377,78
<br />18,146.70 3,254,524,48
<br />306,296.49 3,560,820.97
<br />13,900.88 3,574,721.85
<br />80,232.44 3,654,954.29
<br />12,568, 84 3,667,523,13
<br />80,775.36 3,748,298.49
<br />11,244.63 3,759,543.12
<br />81,183.20 3,840,726.32
<br />9,860.96 3,850,587,28
<br />77,983.14 3,928,570.42
<br />8,542.03 3,937,1 12.45
<br />78,218.26 4,015,330.71
<br />7,164.87 4,022,495.58
<br />75,032.42 4,097,528.00
<br />5,853.95 4,103,381.95
<br />75,111.35 4,178,493.30
<br />4,366.51 4,182,859.81
<br />74,897.64 4,257,757.45
<br />2,893,86 4,260,651.31
<br />74,585.37 4,335,236,69
<br />1,437.81 4,336,674.50
<br />74,181.38 4,410,855, 88
<br />Total $5,451,054.58
<br />$4,410,855.88
<br />Derivation Of Target Amount
<br />Par Amount of Bonds
<br />Reoffering Premium or (Discount)
<br />Accrued Interest from 09/01/2011 to 09/07/2011
<br />Original Issue Proceeds
<br />$4,365,000.00
<br />44,037.80
<br />1,818.08
<br />$4,410,855.88
<br />GO Bonds 2011A FINAL I Issue Summary 1 8/11/2011 14:32 PM
<br />Northland Securities Inc.
<br />Public Finance
<br />
|