|
$2,030,000
<br />City of Lino Lakes, Minnesota
<br />General Obligation New Money and Refunding Bonds, Series 2012A
<br />NET DEBT SERVICE SCHEDULE
<br />Date
<br />Principal Coupon Interest Total P +I Capitalized Net New D/S 105% Fiscal Total
<br />Interest Overlevy
<br />02/01/2013
<br />08/01/2013 - - 18,874.66 18,874.66 (16,021.33) 2,853.33 2,996.00
<br />02/01/2014 70,000.00 0.600% 13,271.25 83,271.25 (11,265.00) 72,006.25 75,606.56 78,602.56
<br />08/01/2014 - 13,061.25 13,061.25 - 13,061.25 13,714.31
<br />02/01/2015 220,000.00 0.700% 13,061.25 233,061.25 233,061.25 244,714.31 258,428.63
<br />08/01/2015 12,291.25 12,291.25 - 12,291.25 12,905.81
<br />02/01/2016 230,000.00 0.750% 12,291.25 242,291.25 - 242,291.25 254,405.81 267,311.63
<br />08/01/2016 - 11,428.75 11,428.75 11,428.75 12,000.19
<br />02/01/2017 225,000.00 0.950% 11,428.75 236,428.75 236,428.75 248,250.19 260,250.38
<br />08/01/2017 10,360.00 10,360.00 - 10,360.00 10,878.00
<br />02/01/2018 230,000.00 1.150% 10,360.00 240,360.00 240,360.00 252,378.00 263,256.00
<br />08/01/2018 9,037.50 9,037.50 9,037.50 9,489.38
<br />02/01/2019 230,000.00 1.350% 9,037.50 239,037.50 239,037.50 250,989.38 260,478.75
<br />08/01/2019 7,485.00 7,485.00 7,485.00 7,859.25
<br />02/01/2020 160,000.00 1.550% 7,485.00 167,485.00 167,485.00 175,859.25 183,718.50
<br />08/01/2020 - 6,245.00 6,245.00 - 6,245.00 6,557.25
<br />02/01/2021 160,000.00 1.700% 6,245.00 166,245.00 166,245.00 174,557.25 181,114.50
<br />08/01/2021 4,885.00 4,885.00 4,885.00 5,129.25
<br />02/01/2022 165,000.00 1.800% 4,885.00 169,885.00 169,885.00 178,379.25 183,508.50
<br />08/01/2022 - 3,400.00 3,400.00 - 3,400.00 3,570.00
<br />02/01/2023 170,000.00 1.950% 3,400.00 173,400.00 173,400.00 182,070.00 185,640.00
<br />08/01/2023 - 1,742.50 1,742.50 - 1,742.50 1,829.63
<br />02/01/2024 170,000.00 2.050% 1,742.50 171,742.50 - 171,742.50 180,329.63 182,159.25
<br />Total $2,030,000.00 - $192,018.41 $2,222,018.41 (27,286.33) $2,194,732.08 $2,304,468.68
<br />SIGNIFICANT DATES
<br />Dated Date 11/15/2012
<br />Delivery Date 11/15/2012
<br />First Coupon Date 8/01/2013
<br />Yield Statistics
<br />Bond Year Dollars $12,513.56
<br />Average Life 6.164 Years
<br />Average Coupon 1.5344832%
<br />Net hterest Cost (NC) 1.6642625%
<br />True hterest Cost (TIC) 1.6631891%
<br />Bond Yield for Arbitrage Purposes 1.5253735%
<br />All hclusive Cost (AIC) 2.0198265%
<br />IRS Form 8038
<br />Net hterest Cost 1.5344832%
<br />Weighted Average Maturity 6.164 Years
<br />2012A GO New Money and Re 1 issue Summary 1 9/11/2012 1 8:29 AM
<br />•
<br />n
<br />Page 6
<br />•
<br />•
<br />w
<br />
|