|
City of Ramsey, Minnesota
<br />$3,970,000 General Obligation Bonds, Series 2015A
<br />Assumes Current Market BQ AA+ Rates plus 25bps
<br />Debt Service Schedule
<br />Date Principal Coupon Interest Total P+I Fiscal Total
<br />05/07/2015 -
<br />12/01/2015 60,861.42 60,861.42 60,861.42
<br />06/01/2016 - - 53,701.25 53,701.25 -
<br />12/01/2016 - - 53,701.25 53,701.25 107,402.50
<br />06/01/2017 - - 53,701.25 53,701.25 -
<br />12/01/2017 170,000.00 1.100% 53,701.25 223,701.25 277,402.50
<br />06/01/2018 - - 52,766.25 52,766.25 -
<br />12/01/2018 175,000.00 1.300% 52,766.25 227,766.25 280,532.50
<br />06/01/2019 - - 51,628.75 51,628.75 -
<br />12/01/2019 175,000.00 1.550% 51,628.75 226,628.75 278,257.50
<br />06/01/2020 - - 50,272.50 50,272.50 -
<br />12/01/2020 180,000.00 1.800% 50,272.50 230,272.50 280,545.00
<br />06/01/2021 - - 48,652.50 48,652.50 -
<br />12/01/2021 180,000.00 2.000% 48,652.50 228,652.50 277,305.00
<br />06/01/2022 - - 46,852.50 46,852.50 -
<br />12/01/2022 185,000.00 2.150% 46,852.50 231,852.50 278,705.00
<br />06/01/2023 - - 44,863.75 44,863.75 -
<br />12/01/2023 190,000.00 2.250% 44,863.75 234,863.75 279,727.50
<br />06/01/2024 - - 42,726.25 42,726.25 -
<br />12/01/2024 195,000.00 2.400% 42,726.25 237,726.25 280,452.50
<br />06/01/2025 - - 40,386.25 40,386.25 -
<br />12/01/2025 195,000.00 2.500% 40,386.25 235,386.25 275,772.50
<br />06/01/2026 - - 37,948.75 37,948.75 -
<br />12/01/2026 200,000.00 2.650% 37,948.75 237,948.75 275,897.50
<br />06/01/2027 - - 35,298.75 35,298.75 -
<br />12/01/2027 210,000.00 2.800% 35,298.75 245,298.75 280,597.50
<br />06/01/2028 - - 32,358.75 32,358.75 -
<br />12/01/2028 215,000.00 2.950% 32,358.75 247,358.75 279,717.50
<br />06/01/2029 - - 29,187.50 29,187.50 -
<br />12/01/2029 220,000.00 3.100% 29,187.50 249,187.50 278,375.00
<br />06/01/2030 - - 25,777.50 25,777.50 -
<br />12/01/2030 225,000.00 3.250% 25,777.50 250,777.50 276,555.00
<br />06/01/2031 - - 22,121.25 22,121.25 -
<br />12/01/2031 235,000.00 3.350% 22,121.25 257,121.25 279,242.50
<br />06/01/2032 - - 18,185.00 18,185.00 -
<br />12/01/2032 240,000.00 3.450% 18,185.00 258,185.00 276,370.00
<br />06/01/2033 - - 14,045.00 14,045.00 -
<br />12/01/2033 250,000.00 3.550% 14,045.00 264,045.00 278,090.00
<br />06/01/2034 - - 9,607.50 9,607.50 -
<br />12/01/2034 260,000.00 3.600% 9,607.50 269,607.50 279,215.00
<br />06/01/2035 - - 4,927.50 4,927.50 -
<br />12/01/2035 270,000.00 3.650% 4,927.50 274,927.50 279,855.00
<br />Total $3,970,000.00 - $1,490,878.92 $5,460,878.92
<br />Yield Statistics
<br />Bond Year Dollars $48,964.67
<br />Average Life 12.334 Years
<br />Average Coupon 3.0448056%
<br />Net Interest Cost (NIC) 3.1421003%
<br />True Interest Cost (TIC) 3.1243978%
<br />Bond Yield for Arbitrage Purposes 3.0041087%
<br />All Inclusive Cost (AIC) 3.2450343%
<br />IRS Form 8038
<br />Net Interest Cost 3.0448056%
<br />Weighted Average Maturity 12.334 Years
<br />2015A GO Fire Station Bon 1 SINGLE PURPOSE
<br />1/20/2015 1 2:23 PM
<br />9 LEADERS IN PUBLIC FINANCE
<br />EHLERS
<br />
|