|
Preliminary
<br />Cit of Ramse EDA, Minnesota Scenario B
<br />yy
<br />G.O. Refunding Bonds, Series 2012 (Level DS to 2031)
<br />2005A (Assumes Old Reserve Earnings at 2.50%)
<br />DebtServiceComparison
<br />DebtServiceComparison
<br />DateTotal P+INet New D/SOld Net D/SSavings
<br />12/15/20121,121,114.891,119,828.341,489,406.77369,578.43
<br />12/15/20131,120,065.001,120,065.001,473,516.50353,451.50
<br />12/15/20141,121,965.001,121,965.001,476,841.50354,876.50
<br />12/15/20151,117,675.001,117,675.001,470,504.00352,829.00
<br />,,.,,.,,.,.
<br />12/15/201611172150011172150014728915035567650
<br />12/15/201611172150011172150014728915035567650
<br />12/15/20171,120,542.501,120,542.501,468,579.00348,036.50
<br />12/15/20181,117,195.001,117,195.001,442,779.00325,584.00
<br />12/15/20191,121,795.001,121,795.001,436,341.50314,546.50
<br />12/15/20201,119,162.501,119,162.501,455,941.50336,779.00
<br />12/15/20211,119,725.001,119,725.001,411,001.50291,276.50
<br />12/15/20221,118,345.001,118,345.001,361,061.50242,716.50
<br />12/15/20231,119,962.501,119,962.501,436,331.50316,369.00
<br />12/15/20241,119,837.501,119,837.501,444,784.00324,946.50
<br />,,.,,.,,.,.
<br />12/15/202511179100011179100014556265033771650
<br />12/15/202511179100011179100014556265033771650
<br />12/15/20261,119,577.501,119,577.501,493,641.50374,064.00
<br />12/15/20271,119,667.501,119,667.50(25,118.50)(1,144,786.00)
<br />12/15/20281,117,647.501,117,647.50-(1,117,647.50)
<br />12/15/20291,118,937.501,118,937.50-(1,118,937.50)
<br />12/15/20301,118,337.501,118,337.50-(1,118,337.50)
<br />12/15/20311,120,262.501,120,262.50-(1,120,262.50)
<br />Total$22,386,939.89$22,385,653.34$21,764,129.27(621,524.07)
<br />PV Analysis Summary (Net to Net)
<br />Gross PV Debt Service Savings.....................2,081,843.02
<br />Effects of changes in DSR investments.............(1,541,517.49)
<br />Net PV Cashflow Savings @ 2.452%(Bond Yield).....540,325.53
<br />Contingency or RoundingAmount....................1,286.55
<br />,.
<br />NetPresentValueBenefit$54161208
<br />NetPresentValueBenefit$54161208
<br />Net PV Benefit / $19,771,843.02 PV Refunded Debt Service2.739%
<br />Net PV Benefit / $17,040,000 Refunded Principal...3.178%
<br />Net PV Benefit / $17,690,000 Refunding Principal..3.062%
<br />Refunding Bond Information
<br />Refunding Dated Date 5/01/2012
<br />RefundingDeliveryDate5/01/2012
<br />RefundingDeliveryDate5/01/2012
<br />05ref 1200 | SINGLE PURPOSE | 2/ 7/2012 | 10:49 AM
<br />Northland Securities
<br />PublicFinance
<br />Page2
<br />PublicFinance Page2
<br />
<br />
|