|
Preliminary
<br />Cit of Ramse EDA, Minnesota Scenario C
<br />yy
<br />G.O. Refunding Bonds, Series 2012 (Ascending Debt Service)
<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/2012997,740.00996,453.451,489,406.77492,953.32
<br />12/15/20131,016,037.501,016,037.501,473,516.50457,479.00
<br />12/15/20141,038,397.501,038,397.501,476,841.50438,444.00
<br />12/15/20151,059,630.001,059,630.001,470,504.00410,874.00
<br />,,.,,.,,.,.
<br />12/15/201610796600010796600014728915039323150
<br />12/15/201610796600010796600014728915039323150
<br />12/15/20171,098,412.501,098,412.501,468,579.00370,166.50
<br />12/15/20181,115,432.501,115,432.501,442,779.00327,346.50
<br />12/15/20191,135,227.501,135,227.501,436,341.50301,114.00
<br />12/15/20201,157,595.001,157,595.001,455,941.50298,346.50
<br />12/15/20211,172,720.001,172,720.001,411,001.50238,281.50
<br />12/15/20221,170,560.001,170,560.001,361,061.50190,501.50
<br />12/15/20231,171,317.501,171,317.501,436,331.50265,014.00
<br />12/15/20241,170,272.501,170,272.501,444,784.00274,511.50
<br />,,.,,.,,.,.
<br />12/15/202511723650011723650014556265028326150
<br />12/15/202511723650011723650014556265028326150
<br />12/15/20261,172,885.001,172,885.001,493,641.50320,756.50
<br />12/15/20271,171,782.501,171,782.50(25,118.50)(1,196,901.00)
<br />12/15/20281,168,502.501,168,502.50-(1,168,502.50)
<br />12/15/20291,168,487.501,168,487.50-(1,168,487.50)
<br />12/15/20301,171,537.501,171,537.50-(1,171,537.50)
<br />12/15/20311,171,887.501,171,887.50-(1,171,887.50)
<br />Total$22,580,450.00$22,579,163.45$21,764,129.27(815,034.18)
<br />PV Analysis Summary (Net to Net)
<br />Gross PV Debt Service Savings.....................2,048,617.05
<br />Effects of changes in DSR investments.............(1,537,020.85)
<br />Net PV Cashflow Savings @ 2.474%(Bond Yield).....511,596.20
<br />Contingency or RoundingAmount....................1,286.55
<br />,.
<br />NetPresentValueBenefit$51288275
<br />NetPresentValueBenefit$51288275
<br />Net PV Benefit / $19,738,617.05 PV Refunded Debt Service2.598%
<br />Net PV Benefit / $17,040,000 Refunded Principal...3.010%
<br />Net PV Benefit / $17,690,000 Refunding Principal..2.899%
<br />Refunding Bond Information
<br />Refunding Dated Date 5/01/2012
<br />RefundingDeliveryDate5/01/2012
<br />RefundingDeliveryDate5/01/2012
<br />05ref 1000 | SINGLE PURPOSE | 2/ 7/2012 | 10:47 AM
<br />Northland Securities
<br />PublicFinance
<br />Page2
<br />PublicFinance Page2
<br />
<br />
|