|
Ehlers
<br />Leaders in Public Finance
<br />Page 2
<br />56
<br />St Anthony, MN
<br />$3,000,000 G.Q. Bonds, Series 2011
<br />Issue Summary - New Money & Current Refunding of
<br />Series 2003A
<br />Debt Service Schedule
<br />Date Principal
<br />Coupon
<br />Interest
<br />Total P+I
<br />Fiscal Total
<br />03/15/2011 -
<br />-
<br />-
<br />-
<br />-
<br />02/01/2012 125,000.00
<br />0.800%
<br />68,969.19
<br />193,969.19
<br />193,969.19
<br />08/01/2012 -
<br />-
<br />38,786.25
<br />38,786.25
<br />-
<br />02/01/2013 235,000.00
<br />1.094%q
<br />38,786.25
<br />273,786.25
<br />312,572.50
<br />08/01/2013 -
<br />-
<br />37,501.25
<br />37,501.25
<br />02/01/2014 240,000.00
<br />1.392%
<br />37,501.25
<br />277,501.25
<br />315,002.50
<br />08/01/2014 -
<br />-
<br />35,831.25
<br />35,831.25
<br />-
<br />02/01/2015 240,000.00
<br />1.692%
<br />35,831.25
<br />275,831.25
<br />311,662.50
<br />08/01/2015 -
<br />-
<br />33,801.25
<br />33,801.25
<br />-
<br />02/01/2016 245,000.00
<br />1.994%
<br />33,801.25
<br />278,801.25
<br />312,602.50
<br />08/01/2016 -
<br />-
<br />31,358.75
<br />31,358.75
<br />-
<br />02/01/2017 250,000.00
<br />2.392%
<br />31,358.75
<br />281,358.75
<br />312,717.50
<br />08/01/2017 -
<br />-
<br />28,368.75
<br />28,368.75
<br />-
<br />02/01/2018 260,000.00
<br />2.692%
<br />28,368.75
<br />288,368.75
<br />316,737.50
<br />08/01/2018
<br />-
<br />24,868.75
<br />24,868.75
<br />-
<br />02/01/2019 265,000.00
<br />2.891%
<br />24,868.75
<br />289,868.75
<br />314,737.50
<br />08/01/2019 -
<br />-
<br />21,038.75
<br />21,038.75
<br />-
<br />02/01/2020 125,000.00
<br />3.150%
<br />21,038.75
<br />146,038.75
<br />167,077.50
<br />08/01/2020 -
<br />-
<br />19,070.00
<br />19,070.00
<br />-
<br />02/01/2021 130,000.00
<br />3.250%
<br />19,070.00
<br />149,070M
<br />16$ 140.00
<br />08/01/2021 -
<br />-
<br />16,957.50
<br />16,957.50
<br />-
<br />02101/2022 135,000.00
<br />3.400%
<br />16,957.50
<br />151,957.50
<br />168,915.00
<br />08/01/2022
<br />-
<br />14;662.50
<br />14,662.50
<br />-
<br />02/0112023 140,000.00
<br />3.600%
<br />14,662.50
<br />154,662.50
<br />169,325.00
<br />08/01/2023 -
<br />-
<br />12,142.50
<br />12,142.50
<br />02/01/2024 145,000.00
<br />3.750°x6
<br />12,142.50
<br />157,142.50
<br />169,285.00
<br />08/01/2024 -
<br />-
<br />9,423.75
<br />9,423.75
<br />-
<br />02/01/2025 150,000.00
<br />3.900%
<br />9,423.75
<br />159,423.75
<br />168,847.50
<br />08/01/2025 -
<br />-
<br />6,498.75
<br />6,498.75
<br />-
<br />02/01/2026 1551000.00
<br />4.050%
<br />6,498.75
<br />161,498.75
<br />167,997.50
<br />08/01/2026 -
<br />-
<br />3,360.00
<br />3,360.00
<br />-
<br />02/01/2027 160,000.00
<br />4.200%
<br />3,360.00
<br />163,360.00
<br />166,720.00
<br />Total $3,000,000.00
<br />-
<br />$736,309.19
<br />$3,736,309.19
<br />-
<br />Yield Statistics
<br />Bond Year Dollars
<br />$23,033.33
<br />Average Life
<br />7.678 Years
<br />Average Coupon
<br />3.1967114%
<br />Net Interest Cost (NIC)
<br />3.3595189%
<br />True Interest Cost (TIC)
<br />3.3332389%
<br />Bond Yield for Arbitrage Purposes
<br />3.1433987%n
<br />All Inclusive Cost AICA
<br />��—
<br />3.4980539%
<br />IRS Form 8038
<br />Net Interest Cast
<br />3.1967114%
<br />Weighted Averaa Maturity
<br />7.678 Years
<br />Ser 2011 New Money & Cur I Issue Summary 1 21912011 1 2:59 PM
<br />Ehlers
<br />Leaders in Public Finance
<br />Page 2
<br />
|