|
City of Circle Pines, Minnesota
<br />$2,065,000 General Obligation Bonds, Series 2016
<br />Assumes Current Market BQ "AA" Rate plus 15bps
<br />10 Years
<br />Debt Service Schedule
<br />Date Principal Coupon Interest
<br />03/15/2016 - - -
<br />02/01/2017 200,000.00 0.750% 25,438.00
<br />08/01/2017 - - 13,740.00
<br />02/01/2018 195,000.00 0.900% 13,740.00
<br />08/01/2018 - 12,862.50
<br />02/01/2019 200,000.00 1.100% 12, 862.50
<br />08/01/2019 - - 11,762.50
<br />02/01/2020 200,000.00 1.200% 11,762.50
<br />08/01/2020 - - 10,562.50
<br />02/01/2021 205,000.00 1.350% 10,562.50
<br />Total P+I
<br />08/01/2021 - - 9,178.75
<br />02/01/2022 205,000.00 1.500% 9,178.75
<br />08/01/2022 - - 7,641.25
<br />02/01/2023 210,000.00 1.600% 7,641.25
<br />08/01/2023 - - 5,961.25
<br />02/01/2024 215,000.00 1.700% 5,961.25
<br />08/01/2024 - - 4,133.75
<br />02/01/2025 215,000.00 1.850% 4,133.75
<br />08/01/2025 - - 2,145.00
<br />02/01/2026 220,000.00 1.950% 2,145.00
<br />225,438.00
<br />13,740.00
<br />208,740.00
<br />12,862.50
<br />212,862.50
<br />11,762.50
<br />211,762.50
<br />10,562.50
<br />215,562.50
<br />9,178.75
<br />214,178.75
<br />7,641.25
<br />217,641.25
<br />5,961.25
<br />220,961.25
<br />4,133.75
<br />219,133.75
<br />2,145.00
<br />222,145.00
<br />Fiscal Total
<br />225,438.00
<br />222,480.00
<br />225,725.00
<br />223,525.00
<br />226,125.00
<br />223,357.50
<br />225,282.50
<br />226,922.50
<br />223,267.50
<br />224,290.00
<br />Total $2,065,000.00 $181,413.00 $2,246,413.00
<br />Yield Statistics
<br />Bond Year Dollars
<br />Average Life
<br />Average Coupon
<br />$11,317.61
<br />5.481 Years
<br />1.6029266%
<br />Net Interest Cost (NIC) 1.8218774%
<br />True Interest Cost (TIC)
<br />Bond Yield for Arbitrage Purposes
<br />All Inclusive Cost (AIC)
<br />1.8297073%
<br />1.5964595%
<br />2.2049559%
<br />IRS Form 8038
<br />Net Interest Cost 1.6029266%
<br />Weighted Average Maturity 5.481 Years
<br />Series 2016 GO Bonds -10 1 SINGLE PURPOSE 1 2/ 9/2016 1 8:05 AM
<br />EHLERS
<br />LEADERS IN PUBLIC FINANCE
<br />
|