|
City of Little Canada, Minnesota
<br />$2,570,000 General Obligation CIP Bonds, Series 2014
<br />Assumes Current Market BQ AA Rates plus 25bps
<br />$2.5M project costs
<br />Debt Service Schedule
<br />105%
<br />Date Principal Coupon Interest Total P +I Overlevy Fiscal Total
<br />2/01/2014 - • - -
<br />2/01/2015 105,000.00 0.700% 71765.00 178,765.00 187,703.25 187,703.25
<br />8/012015 36,515.00 36,515.00 38,340.75
<br />2/01/2016 105,000.00 0.800% 36,515.00 141,515.00 148,590.75 186,931.50
<br />8/01/2016 - 36,095.00 36,095.00 37,899.75 -
<br />2/01/2017 105,000.00 1.100% 36,095.00 141,095.00 148,149.75 186,049.50
<br />8/01/2017 - - 35,517.50 35,517.50 37,293.38
<br />2/01/2018 105,000.00 1.400% 35,517.50 140,517.50 147,543.38 184,836.75
<br />8/01/2018 - 34,782.50 34,782.50 3%521.63 -
<br />2/01 /2019 110,000.00 1.700% 34,782.50 144,782.50 152,021.63 188,543.25
<br />8/01/2019 - - 31,847.50 33,847.50 35,539.88
<br />2/01/2020 110,000.00 2,00056 33,847.50 143,847.50 151,039.88 186,579.75
<br />8/01/2020 - - 32,747.50 32,747.50 34,384.88
<br />2101/2021 115,000.00 2.200% 32,747.50 147,747.50 155,134.88 189,519.75
<br />6/01/2021 - - 31,482.50 31,482.50 33,056.63 •
<br />2/012022 115,000.00 2.400% 31,482.50 146,482.50 153,806.63 186,863.25
<br />8/012022 - - 30,102.50 30,102.50 31,607.63 -
<br />2/01/2023 120,000.00 2.65056 30,102.50 150,102.50 157,607.63 189,215.25
<br />8/01/2023 - 28,512.50 28,512.50 29,938.13
<br />2/01/2024 120,00000 2.800% 28,512.50 148,512.50 155,938.13 185,876.25
<br />8/01/2024 - 26,832.50 26,832.50 28,174.13
<br />2/01/2025 125,000.00 2.950% 26,832.50 151,832.50 159,424.13 187,598.25
<br />8/01/2025 - - 24,988.75 24,988.75 26,238.19
<br />2/01/2026 130,000.00 3.150% 24,988.75 154,988.75 162,738.19 188,976.38
<br />8/01/2026 - - 22,941.25 22,941.25 24,088.31
<br />2/01/2027 135,000.00 3.350% 22,941 25 157,941.25 165,838.31 189,92663
<br />8/01/2027 - - 20,680.00 20,680.00 21,714.00 -
<br />2/01/2028 135,000.00 3.500% 20,680.00 155,680.00 163,464.00 185,178.00
<br />8/01/2028 - 18,317.50 18,317.50 19,233.38 -
<br />2/01/2029 140,000.00 3.650% 18,317.50 158,317.50 166,233.38 185,466.75
<br />8/01/2029 - 15,762.50 15,762.50 16,550.63
<br />2/01/2030 145,000.00 3.80006 15,762.50 160,762.50 168,800.63 185,351.25
<br />8/01/2030 13,007.50 13,007.50 13,657.88
<br />2/01/2011 155,000.00 3.900% 13,007.50 168,007.50 176,407.88 190,065.75
<br />8/01/2031 - - 9,985.00 9,985.00 10,484.25
<br />2/01/2032 160,000.00 4.000% 9,985.00 169,985.00 178,484.25 188,968.50
<br />8/01/2032 - - 6,785.00 6,785.00 7,124.25
<br />2/01/2033 165,000.00 4.000% 6,785.00 171,785.00 180,374.25 187,498.50
<br />8/01/2033 3,485.00 3,485.00 3,659.25
<br />2/01/2034 170,000.00 4.100% 3,485.00 173,485.00 182,159 25 185,818.50
<br />Total 52,570,000.00 - 5998, 540.00 83,568,540.00 53,746,967.00
<br />Significant Dates
<br />Dared
<br />First Coupon Date
<br />Yield Statistics
<br />2/01/2014
<br />2/01/2015
<br />Doled Year Dollars
<br />Average Lifc
<br />Average Coupon
<br />Net Interest Cost (NIC)
<br />Tnle Interest Cost (TIC)
<br />Bond Yield for Arbitrage l'ulposes
<br />All Inclusive Cost (ACC)
<br />IRS Form 8038
<br />Net Interest Cost
<br />Weighted Average Maturity
<br />So/os cote 00 CIP Bonds I SINGLE PURPOSE 1 702)2013 1 839 NA
<br />529,315.00
<br />11.407 Years
<br />3.4062425%
<br />3.5114447%
<br />3.4800886%
<br />3.3482752%
<br />36500987%
<br />3.4062425%
<br />11.407 Years
<br />EHLERS
<br />LLAULRS IN 1000110, nl101001.
<br />10
<br />
|