|
City of Little Canada, Minnesota
<br />$1,555,000 General Obligation CIP Bonds, Series 2014
<br />Assumes Current Market BQ AA Rates plus 25bps
<br />$1.5M project costs
<br />Debt Service Schedule
<br />106%
<br />Date Principal Coupon Interest Total P +I Overlevy Fiscal Total
<br />2/01/2014 -
<br />2/01/2015 65,000.00 0,700% 44,547.50 109,547.50 115,024.8 115,024.88
<br />8/01/2015 - 22,046.25 22,046.25 23,148.5 -
<br />2/01/2016 65,000.00 0.800% 22,046.25 87,046.25 91,398.5 114,547.13
<br />8/01/2016 - 21,786.25 21,786.25 22,875.5 -
<br />2/01 /2017 65,000.00 1.100% 21,786.25 86,786.25 91,125.5 114,001.13
<br />8/01/2017 - - 21.428.75 21,428.75 22,500.1 -
<br />2/01 /2018 65,000.00 1.400% 21,428.75 86,428,75 90,750.1 113,250.38
<br />8/01/2018 - - 20,97175 20,973.75 22,022.4
<br />2/01/2019 65,000.00 1.700% 20,973.75 85,973.75 90,272.4 112,294.88
<br />8/01/2019 20,421.25 20,421.25 21,442.3 -
<br />2/01/2020 65,000.00 2.000% 20,421.25 85,421.25 89,692.3 111,134.63
<br />8/01/2020 - 9,771.25 19.771,25 20.759.8
<br />2/01/2021 70,000.00 2.200% 9,771.25 89,771.25 94,259.8 115,019.63
<br />8/01/2021 - - 9,001.25 19,001.25 19,951.3
<br />2/01/2022 70,000.00 2.400% 9,001.25 89,001.25 93,451.3 113,402.63
<br />8/01/2022 - - 8,161.25 18,161.25 19,069.3 -
<br />2/01/2023 70,000.00 2.650% 8,161.25 88,161.25 92,569.3 111,638.63
<br />8/01/2023 - 7,233.75 17,233.75 18,095.44
<br />2/01/2024 75,000.00 2.800% 7,233.75 92,233.75 96,845.44 114,940.88
<br />8/01/2024 - - 6,183.75 16,183.75 16,992.94
<br />2/01/2025 75,000.00 2.950% 6,183,75 91,183.75 95,742.94 112,735.88
<br />8/01/2025 - - 5,077.50 15.077.50 15,831.38
<br />2/01/2026 75,000.00 3.150% 5,077.50 90,077.50 94,581.38 110,412.75
<br />8/01/2026 - - 3,896.25 13,896.25 14,591.06
<br />2/01/2027 80,000.00 3.35090 3,896.25 93,896.25 98,591.06 113,182.13
<br />8/01/2027 - - 2,55625 12,556.25 13,184.06
<br />2/01/2028 85,000.00 3,50086 2,556.25 97,556.25 102,434.06 115,618.13
<br />8/01/2028 - - 1,068.75 11,068.75 11,622.19
<br />2/01/2029 85,000.00 3.650% 1,068.75 96,068.75 100,872.19 112,494.38
<br />8/01/2029 - - 9,517.50 9.517.50 9,993.38
<br />2/01/2030 90,000.00 3.80086 9,517.50 99,517.50 104,493.38 114,48675
<br />8/01/2030 7,807.50 7,807.50 8,197.88
<br />2/01/2031 90,000,00 3.900% 7,807.50 97.807.50 102,697.88 110,895.75
<br />8/01/2031 - 6,052.50 6,052.50 6,355.13
<br />2/01/2032 95,000.00 4.000% 6,052.50 101,052.50 106,105.13 112,460.25
<br />8/01/2032 - - 4,152.50 4,152.50 4,360,13
<br />2/01/2033 100,000.00 4,000% 4,15250 104,152.50 109,360.13 113,720.25
<br />8/01/2033 - - 2.152,50 2,152.50 2,260.1
<br />2/01/2034 105,000.00 4.100% 2,152,50 107,152,50 112,510.13 114,770.25
<br />Total 51,555,000.00 5603,125.00 52,158,125.00 82,266,031.25
<br />Significant Dates
<br />Doled
<br />First Coupon Date
<br />Yield Statistics
<br />2/01/2014
<br />2/01/2015
<br />Bald Year Dollars
<br />Average Life
<br />Average Coupon
<br />Not Interest Cost (NIC)
<br />Tmc Interest Cost (fIC)
<br />Mond Yield for Arbitrage Purposes
<br />All Inclusive Cost (AIC)
<br />IRS Form 8038
<br />Ncl Interest Cost
<br />Weighted Average Maturity
<br />Series 2014 GOCIP Bons 1 SINGLE PURPOSE 1 72212013 1 8:38 AM
<br />517,705.00
<br />11.386 Years
<br />3.4065236%
<br />3.5119175%
<br />3.4803390%
<br />3.5482807%
<br />3.7196129%
<br />3.4065236%
<br />11.386 Years
<br />EHLERS
<br />LLAMAS IN NOM FINANCE
<br />6
<br />
|