|
City of Ramsey, Minnesota
<br />$3,970,000 General Obligation CIP 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 />06/18/2015 - -
<br />12/01/2015 48,629.47 48,629.47 48,629.47
<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,478,646.97 $5,448,646.97
<br />Yield Statistics
<br />Bond Year Dollars
<br />Average Life
<br />Average Coupon
<br />Net Interest Cost (NIC)
<br />True Interest Cost (TIC)
<br />Bond Yield for Arbitrage Purposes
<br />All Inclusive Cost (AIC)
<br />IRS Form 8038
<br />$48,512.53
<br />12.220 Years
<br />3.0479693%
<br />3.1461708%
<br />3.1290493%
<br />3.0077365%
<br />3.2507182%
<br />Net Interest Cost
<br />Weighted Average Maturity
<br />2015A GO CIP Bonds - PreS I SINGLE PURPOSE I 2/23/2015 I 3:59 PM
<br />3.0479693%
<br />12.220 Years
<br />0 LEADERS IN PUBLIC FINANCE
<br />EHLERS
<br />
|