|
City of Little Canada, Minnesota
<br />$2,060,000 General Obligation CIP Bonds, Series 2014
<br />Assumes Current Market BQ AA Rates plus 25bps
<br />$2M project costs
<br />Debt Service Schedule
<br />105%
<br />Date Principal Coupon Interest Total P +I Overlevy Fiscal Total
<br />02/01/2014 - - - - -
<br />02/01/2015 85,000.00 0.700% 9085.00 144,085.00 151,289.25 151,289.25
<br />08/01/2015 - - 9,245.00 29,245.00 30,707.25 -
<br />02/01/2016 85,000.00 0.800% 9,245.00 114,245.00 119,957.25 150,664.50
<br />08/01/2016 8,905.00 28,905.00 30,350.25 -
<br />02/01 /2017 85,000.00 1.100% 8,905,00 113,905.00 119,600.25 149,950.50
<br />08/01/2017 8,437.50 28,437.50 29,859.38
<br />02/01/2018 85,000.00 1400% 8,437,50 113,437.50 119,109.38 148,968.75
<br />08/01 /2018 - - 7,842.50 27,842.50 29,234.63
<br />02/01/2019 85,000.00 1700% 7,842.50 112,842.50 118,484.63 147,719.25
<br />08/01/2019 - 7,120.00 27,120.00 28,476.00
<br />02/01/2020 90,000.00 2000% 7,120.00 117,120.00 122,976.00 151,452.00
<br />08/01/2020 - - 6,220.00 26,220.00 27.531.00
<br />02/01/2021 90,000.00 2.200% 6,220.00 116,220.00 122,031.00 149,562.00
<br />08/01/2021 - - 5,230.00 25,230.00 26.491.50
<br />02/01/2022 95,000.00 2,400% 5,230.00 120,230.00 126,241.50 152,733.00
<br />08/01/2022 - - 4,090.00 24,090.00 25,294.50 -
<br />02/01/2023 95,000.00 2.650% 4,090.00 119,090.00 125,044.50 150,339,00
<br />08/01/2023 - - 2,831.25 22,831.25 23,972.81
<br />02/01/2024 95,000.00 7800% 2,831.25 117,831.25 123,722.81 147,695.63
<br />08/01/2024 - 1,501.25 21,501.25 22,576.31
<br />02/01/2025 100,000.00 2950% 1,501.25 121,501.25 127,576.31 150,152.63
<br />08/01/2025 - - 0,026.25 20,026.25 21,027.56
<br />02/01/2026 105,000.00 1150% 0,026.25 125,026.25 131,277.56 152,305,13
<br />08/012026 8,372.50 18,372.50 19,291.13
<br />02/01/2027 105,000.00 3.350% 8,372.50 123,372.50 129,541.13 148,832.25
<br />08/01/2027 6,613.75 16.613,75 17,444.44
<br />02/01/2028 110,000.00 1500% 6,613.75 126,613,75 132,944.44 150,388.88
<br />08/01/2028 4,68875 14,688.75 15,423.19
<br />02101/2029 115,000.00 3.650% 4,688.75 129,688.75 136,173.19 151,596.38
<br />08/01/2029 - - 2,590.00 12,590.00 13,219.50 -
<br />02/01/2030 120,000.00 1800% 2,590.00 132,590.00 139,219.50 152,439.00
<br />08/01/2030 - - 0,310.00 10,310.00 10,825.50
<br />02/01 /2031 120,000.00 3900% 0,310.00 130,310.00 136,825.50 147,651.00
<br />08/01/2031 - 7,970.00 7,970.00 8,368.50
<br />02/01/2032 125,000.00 4.000% 7,970.00 132,970.00 139,618.50 147,987.00
<br />08/01/2032 - - 5,470.00 5,470.00 5.74350
<br />02/01/2033 130,000.00 4.000% 5,470.00 135,470.00 142,243.50 147,987,00
<br />08/01/2033 - - 2,870.00 2,870.00 3,013,50
<br />02/01/2034 140,000.00 4.100% 2,870.00 142,870.00 150,013,50 153,027.00
<br />Total 52,060,000.00
<br />Significant Dates
<br />Dated
<br />First Coupon Date
<br />Yield Statistics
<br />5799,752.50
<br />52,859,752.50 53,002,740.13
<br />2/01 /2014
<br />2/01/2015
<br />Mond Year Dollars
<br />Average Life
<br />Average Coulon
<br />Net Interest Cost (NIC)
<br />Tim Interest Cost (TIC)
<br />Bond Yield for Arbitrage Purposes
<br />All Inclusive (lost (ADC)
<br />IRS Form 8038
<br />Net Internal COSI
<br />Weighted Average Maturity
<br />Series 2014 GO CIP Bonds 1 SINGLE PURPOSE 1 7/22/2013 1 8.38 AM
<br />523,480.00
<br />11.398 Years
<br />34061009%
<br />3.5113820%
<br />34799842%
<br />3.3480744%
<br />36707274%
<br />34061009%
<br />11.398 Yms
<br />EHLERS
<br />IIIADI:as I1I POOL IC lllIAtICE
<br />8
<br />
|