|
Preliminary
<br />$630,000.00
<br />City of Lake Elmo, Minnesota
<br />G.O. Equipment Certificates, Series 2007A 1 100 Ft. Ladder Truck
<br />Debt Service Schedule
<br />Date Principal
<br />Coupon
<br />Interest
<br />Total P+I
<br />Fiscal Total
<br />02/0112007 -
<br />-
<br />-
<br />-
<br />-
<br />08101/2007 -
<br />-
<br />11,836.25
<br />11,836.25
<br />-
<br />02/01/2008 55,000.00
<br />3.500%
<br />11,83626
<br />66,836.25
<br />78,672.50
<br />08/01/2008 -
<br />-
<br />10,84625
<br />10,846.25
<br />-
<br />02/01/2009 55,000.00
<br />3.600%
<br />10,84625
<br />65,846.25
<br />76,692.50
<br />08/01/2009 -
<br />9,856.25
<br />9,856.25
<br />-
<br />021012010 55,000.00
<br />3.650%
<br />9,856.25
<br />64,856.25
<br />74,712.50
<br />08/0112010 -
<br />-
<br />8,852.50
<br />8,852.50
<br />-
<br />02/01/2011 60,000.00
<br />3.650 %
<br />8,852.50
<br />68,852.50
<br />77,705.00
<br />08/01/2011 -
<br />-
<br />7,767.50
<br />7,757.50
<br />-
<br />02/01/2012 60,000.00
<br />3.700%
<br />7,767.50
<br />67,757.50
<br />75,515.00
<br />08/01/2012
<br />6,647.50
<br />6,647.50
<br />-
<br />02/01/2013 65,000.00
<br />3.750%
<br />6,647.50
<br />71,647.50
<br />78,296.00
<br />08/01/2013 -
<br />-
<br />5,428.76
<br />5,428.75
<br />-
<br />02/01/2014 65,000.00
<br />3.800%
<br />5,428.75
<br />70,428.75
<br />75,857.50
<br />08/01/2014 -
<br />-
<br />4,193.75
<br />4,193.75
<br />-
<br />02/0112015 70,000.00
<br />3.850%
<br />4,193.75
<br />74,193.75
<br />78,387.50
<br />08/012015
<br />2,846.25
<br />2,846.25
<br />-
<br />02/01/2016 70,000.00
<br />3.900%
<br />2,846.25
<br />72,846.25
<br />75,692,50
<br />08101/2016 -
<br />-
<br />1,48125
<br />1,481.25
<br />--
<br />02/0112017 75.000.00
<br />3.950%
<br />1,481.25
<br />76,481.25
<br />77,962.50
<br />Total $630,000.00
<br />-
<br />$139,492.60
<br />$769,492.60
<br />-
<br />Yield Statistics
<br />Dated
<br />2JO112007
<br />Delivery Date
<br />2/01f2007
<br />First Coupon Date
<br />8/012007
<br />First available call date
<br />1210112013
<br />Call Price
<br />100.0000000%
<br />Bond Year Dollars
<br />$3,655.00
<br />Average Life
<br />5.802 Years_
<br />Average Coupon
<br />3.8164843
<br />Net Interest Cost (NIC)
<br />4A267442%
<br />True Interest Cost (TIC)
<br />4.1733588%
<br />Bond Yield for Arbitrage Purposes
<br />3.8117680%
<br />All Inclusive Cost (AIC)
<br />4.4323608%
<br />IRS Form 8038
<br />Net Interest Cost
<br />3.8164843 %
<br />Weighted Average Maturity
<br />5.802 Years
<br />2007S,Uipp MCert a 11=51200611:10PM
<br />Northland Securities
<br />Public Finance
<br />Page 2
<br />
|