|
Fina1
<br /> City of Centerville, Minnesota
<br /> G.O. Improvement Refunding Bonds, Series 2011A
<br /> Refunding Summary
<br /> Dated 04/01I2071 � Delivered 04/1412011
<br /> ' Issue
<br /> 2004 20Q7 Summary
<br /> Sources Of Funds
<br /> Par Amount of Bonds 1,115,000.00 $1,645,000.00 $2,760,000.00
<br /> Accrued Interest from 04/01l2011 to 04114l2011 561.17 1,014.27 1,575.44
<br /> Total3ources ;1,115,561.17 :1,&18,014.27 �2,751,575.44
<br /> Uses Of Funds
<br /> Deposit to Current Refunding Fund ,142.87 1,614,841. 2,710,984.77
<br /> Costs of Issuance � 10,988.41 16,211.59 27,2�.00
<br /> Total Undeiwriters Discount (0.689%) 7,677.01 11,326.t7 19,003.18
<br /> Rounding Amount 191.71 2,620.34 2,812.05
<br /> Deposit to Debt Service Fund 561.17 1,014.27 1,575.44
<br /> Total Uses 51,115,561.17 51,646,014.27 52,761,575.44
<br /> Flow of Funds Detail
<br /> State and Local Govemment Series (SLGS) rates for
<br /> Date of OMP Candidates
<br /> Primary Purpose Fund Solution Method Net Funded Net Funded Net Funded
<br /> Total Cost of Investments $1,096,142.87 $1,614,841.90 $2,710,984.77
<br /> Interest Eamings � 0.070°k 25.68 158.10 183.98
<br /> Total Drews $1,096,168.75 $1,615,000.00 $2,711,168.75
<br /> PV Analysis Summary (Net to Net)
<br /> Net PV Cashflow Savings � 7.853%(Bond Yield) 83,472.11 122,911.03 206,383.14
<br /> Accrued Interest Credit to Debt Service Fund 561.17 1,014.27 1,575.44
<br /> Contingency or Rounding Amount 191.71 2,620.34 2,812.05
<br /> Net Present Value Benefit $84,224.99 $126,545.64 $210,770.63
<br /> Net PV Benefit /$2,700,000 Refunded Principal 7.763% 7.836% 7.806%
<br /> Net PV Benefit 1$2,760,000 Refunding Prinapal 7.554% 7.693% 7.637%
<br /> Bond Statistics
<br /> Average Life 4.322 Years 5.469 Years 5.005 Years
<br /> ' Average Coupon 1.6797925% 1.9585036% 1.8612876%
<br /> Net Interest Cost (NIC) 1.8391079% 2.084402496 1.9988423%
<br /> Bond Yield for Arbitrage Purposes 1.5530851% 1.8530851% 1.8530851%
<br /> True Interest Cost (TIC) 1.8423189% 2.0849342% 1.5988655%
<br /> AII Inclusive Cost (AIC) 2.0861391% 2.2804922°� 2.2123147%
<br /> Ref ( IssueSummary ( 3/23/2011 � 10:54AM
<br /> Northland Securities
<br /> Public Finance ' Pags �
<br /> �_
<br />
|