� $1,270,000
<br />City of Pequot Lakes, Minnesota
<br />General Obligation Utility Refunding Bonds, Series 2012A
<br />Current Refunding of Series 2000A
<br />�
<br />Date
<br />02/01/2013
<br />02/01/2014
<br />02/01 /2015
<br />02/01 /2016
<br />02/01 /2017
<br />02/01 /2018
<br />02/01l2019
<br />02/01/2020
<br />02/01 /2021
<br />02/01 /2022
<br />02/01 /2023
<br />02/01/2024
<br />02J01/2025
<br />02/01/2026
<br />02/01/2027
<br />02/01 /2028
<br />02/01 /2029
<br />02/01/2030
<br />02/01/2031
<br />Total
<br />Yeld Statistics
<br />Principal
<br />70,000.00
<br />55,000.00
<br />55,000.00
<br />60,000.00
<br />60,000.00
<br />60,000.00
<br />60,000.00
<br />60,000.00
<br />60,000.00
<br />65,000.00
<br />65,000.00
<br />65,000.00
<br />70,000.00
<br />70,000.00
<br />75,000.00
<br />75,000.00
<br />80,000.00
<br />80,000.00
<br />85,000.00
<br />$1,270,000.00
<br />Debt Service Schedule
<br />Coupon
<br />0.700%
<br />0.750%
<br />1.000%
<br />1.150%
<br />1.400%
<br />1.650%
<br />1.900%
<br />2.150%
<br />2.300%
<br />2.450%
<br />2.600%
<br />2.750%
<br />2.900%
<br />3.000%
<br />3.100%
<br />3.150%
<br />3.300%
<br />3.450%
<br />3.600%
<br />Interest
<br />15,065.00
<br />29,640.00
<br />29,227.50
<br />28,677.50
<br />27,987.50
<br />27,147.50
<br />26,157.50
<br />25,017.50
<br />23,727.50
<br />22,347.50
<br />20,755.00
<br />19,065.00
<br />17,277.50
<br />15,247.50
<br />13,147.50
<br />10,822.50
<br />8,460.00
<br />5,820.00
<br />3,060.00
<br />$368,650.00
<br />Total P+I
<br />85,065.00
<br />&4,640.00
<br />84,227.50
<br />88,677.50
<br />87,987.50
<br />87,147.50
<br />86,157.50
<br />85,017.50
<br />83,727.50
<br />87,347.50
<br />85,755.00
<br />84,065.00
<br />87,277.50
<br />85,247.50
<br />88,147.50
<br />85,822.50
<br />88,460.00
<br />85,820.00
<br />88,060.00
<br />$1,638,650.00
<br />BondYear pollars .................................................................................................................................................... $12,825.00
<br />AverageLife ............................................................................................................................................................ 10.098 Years
<br />AverageCoupon ...................................................................................................................................................... 2.8744639%
<br />Nethterest Cost (NIC) .............................................................................................................................................. 2.9932943%
<br />TrueInterest Cost (TIC) ............................................................................................................................................ 2.9786741 %
<br />Bond Yield for Arbitrage Purposes .......................................................................................................................... 2.8363414%
<br />Allhclusive Cost (AIC) ............................................................................................................................................. 3.2930331%
<br />IRS Form 8038
<br />NetInterest Cost ....................................................................................................................................................... 2.8744639%
<br />WeightedAverage Maturity ...................................................................................................................................... 10.098 Years
<br />� 2012A RejBonds 1000A I 2000A Current Rejund�rtg I 5 23 d0l2 I z'aSPM
<br />ax�.,
<br />`�� Sprin�s�ed
<br />Page 6
<br />
|