|
06/18/2012
<br /> ATTACHMENT2
<br /> C�/O}RAdYY�00d G41
<br /> RsfYn�q S�scl�l Taoc Bonds,Serlss 2012(PacHYc Shoros)
<br /> Deb�t Servke ScFis�k�s
<br /> Prior Bonds Bond
<br /> Payment Date Principal Coupon Interest Period Total Bond Year Total Debt Service Year Savinqs
<br /> 3/1/12
<br /> 9/1/12 0 0.00% 9,373.96 9,373.96 9,373.96 1,979,080.00 1,969,706.04
<br /> 3/1/13 56,243.75 56,243.75
<br /> 9/1/13 1,365,000 1.25% 56,243.75 1,421,243.75 1,477,487.50 1,979,580.00 502,092.50
<br /> 3/1/14 47,712.50 47,712.50
<br /> 9/1/14 1,385,000 2.00% 47,712.50 1,432,712.50 1,480,425.00 1,978,470.00 498,045.00
<br /> 3/1/15 33,862.50 33,862.50
<br /> 9/1/15 1,410,000 2.25% 33,862.50 1,443,862.50 1,477,725.00 1,981,062.50 503,337.50
<br /> 3/1/1 6 18,000.00 18,000.00
<br /> 9/1/16 1,440,000 2.50% 18,000.00 1,458,000.00 1,476,000.00 1,976,622.50 500,622.50
<br /> 3/1/17 0.00 0.00
<br /> 9/1/17 0 0.00% 0.00 0.00 0.00 311,815.00 311,815.00
<br /> 5,600,000 321,011.46 5,921,011.46 5,921,011.46 10,206,630.00 4,285,618.54
<br /> Accrued 0.00 0.00
<br /> Total Debt Service 321,011.46 5,921,011.46
<br /> NIC 2.64091% using 98.85%
<br /> TIC 2.65784% using 98.85%
<br /> Bond Yield 2.27579% using 99.80%
<br /> All-In TIC 4.43016% using 94.61%
<br /> Average Rate 2.19996%
<br /> Average Life 2.6057 years
<br /> 8086 Av. Life 2.6042 years
<br /> Dated 8/1/12
<br /> Delivery 8/1/12
<br /> Gross Savings 4,046,078.54
<br /> Gross NPV Savings 3,876,550.92
<br /> Less DSRF Contribution (2,097,587)
<br /> Less surplus held by City -
<br /> Less Bond Fund Balance (2,059,053)
<br /> Plus New DSRF 560,000
<br /> Adjusted Gross Savings 279,910.33 = 5.00% of Refunding Bonds
<br /> = 3.91% of Refunded Bonds
<br /> Prepared by William Euphrat Municipal Finance, Inc., 5/31/12 Page 2
<br /> RESO. 15197
<br /> MUFF#505
<br />
|