|
City of Little Canada, Minnesota
<br />$2,570,000 General Obligation CIP Bonds, Series 2014
<br />Assumes Current Market BQ M Rates plus 25bps
<br />$2.5M project costs
<br />Debt Service Schedule
<br />Date Principal Coupon
<br />03/03/2014
<br />02/01/2015 110,000.00 070054
<br />08/01/2015 -
<br />02/01/2016 105,000.00 0.850%
<br />08/01/2016 - 02/01/2017 105,000, 00 1.100%
<br />08/01/2017
<br />02/01/2018 105,000.00 1,40054
<br />08/01 /2018
<br />02/01/2019 110,000.00 1.750%
<br />08/01/2019
<br />02/01/2020 110,000.00 2.10054
<br />08/01/2020
<br />02/01/2021 115,000.00 2.400%
<br />08/01/2021
<br />02/01/2022 115,000.00 2.600%
<br />08/01/2022
<br />02/01/2023 120,000.00 2.800%
<br />08/01/2023
<br />02/01/2024 120,000.00 2.950'%
<br />08/01/2024 - -
<br />02/01/2025 125,000.00 3.050%
<br />08/01/2025 - -
<br />02/01/2026 130,000.00 3.150%
<br />08/01/2026 -
<br />02/01/2027 135,000.00 3.300%
<br />08/01/2027 - -
<br />02/01/2028 135,000.00 3.400%
<br />08/01/2028 - -
<br />02/01/2029 140,000.00 3.500%
<br />08/01/2029 -
<br />02/01/2030 145,000.00 3.600%
<br />08/01/2030 -
<br />02/01/2031 150,000.00 3.850%
<br />08/01/2031 - 02/01/2032 160,000.00 3,95054
<br />08/01/2032 -
<br />02/01/2033 165.000,00 4.050%
<br />08/01/2033 - 02/01/2034 170,000.00 4.150%
<br />Interest Total P +I
<br />,492.83
<br />,653.75
<br />,653.75
<br />6,207.50
<br />,207.50
<br />5,630.00
<br />5,630.00
<br />,895.00
<br />4,895.00
<br />3,932.50
<br />3,932.50
<br />2,777.50
<br />2,777.50
<br />1,397.50
<br />1,397.50
<br />9,902.50
<br />9,902.50
<br />8,222,50
<br />8,222.50
<br />6,452.50
<br />6,452.50
<br />4,546.25
<br />4,546.25
<br />2,498.75
<br />2,498.75
<br />0,271.25
<br />0,271,25
<br />7,976.25
<br />7,976,25
<br />5,526.25
<br />5,526.25
<br />2,916.25
<br />2,916.25
<br />0.028.75
<br />0,028.75
<br />6,868.75
<br />6,868.75
<br />3,527.50
<br />3,527.50
<br />177,492.83
<br />36,653 .75
<br />141,653.75
<br />36,207.50
<br />141,207.50
<br />35,630.00
<br />140,630.00
<br />34,895.00
<br />144,895.00
<br />33,932.50
<br />143,932.50
<br />32,777.50
<br />147,777.50
<br />31,397.50
<br />146,397,50
<br />29,902.50
<br />149,902.50
<br />28,222.50
<br />148,222.50
<br />26,452.50
<br />151,452,50
<br />24,546.25
<br />154,546.25
<br />22,498.75
<br />157;198.75
<br />20,271.25
<br />155,271.25
<br />17,976.25
<br />157,976.25
<br />15,526.25
<br />160,526.25
<br />12,916.25
<br />162,916.25
<br />10,028.75
<br />170,028.75
<br />6,86875
<br />171,868.75
<br />3,527.50
<br />173,527.50
<br />105%
<br />Ovorlevy Fiscal Total
<br />186,367.47 186,367.47
<br />38,486.44 -
<br />148736,14 187,222.88
<br />38 017.88
<br />148,267.88 186,285.75
<br />37,411.50
<br />147,661.50 185,073.00
<br />36,63975
<br />152,13975 188,779.50
<br />35,629.13 -
<br />151,129.13 186,758.25
<br />34,116 38
<br />155,166.38 189,582,75
<br />32,967,38 -
<br />153,717.38 186,684.75
<br />31,397.63
<br />157,397.63 188,795.25
<br />29,633.63 -
<br />155,633.63 185,267.25
<br />27,775.13
<br />159,025.13 186,800 25
<br />25,773.56
<br />162,273.56 188,047.13
<br />23,623.69
<br />165,373,69 188,997,38
<br />21,28 .81
<br />163,034.81 184,319,63
<br />18,875.06
<br />165,875.06 184,750.13
<br />16,302.56
<br />168, 552, 56 184,85 5.13
<br />13,562.06 -
<br />171,062.06 184,624,13
<br />10,530.19
<br />178,530.19 189,060,38
<br />7,212.19
<br />180,462.19 187,674.38
<br />3,703.88
<br />182,203.88 185,907.75
<br />Total 52,570,000.00 - 5987,955.33 53,557,955.33 53,735,853.10
<br />Significant Dates
<br />Dated 3/03/201.1
<br />First Coupon Date 2/01/2015
<br />Yield Statistics
<br />lsond Year Dollars
<br />Average Life
<br />Average Coupon
<br />Net Interest Cost (NC)
<br />'l'nte Interest Cost ('I'ICt)
<br />Ilond Yield for Arbitrage Purposes
<br />All Inclusive Cost (ADC
<br />IRS Form 8038
<br />Net Interest Cost
<br />Weighted Average MaRoily
<br />Serios 2014 GO CIP 80505 1 SINGLE POAPO
<br />529,006.56
<br />11.287 Yeats
<br />3.4059726%
<br />3.5122934%
<br />3.4851754%
<br />3.3519178%
<br />3.6570690%
<br />1211812013 1 &Y/ AM
<br />3.4059726%
<br />11.287 Years
<br />EHLERS
<br />AEI RS 111011111 III I INANC1
<br />
|