|
<br />
<br />Mounds View, Minnesota
<br />$6,000,000 General Obligation CIP Bonds, Series 2017A
<br />Assumes Current Market BQ AA Rates plus 25bps
<br />Debt Service Schedule
<br />Date Principal Coupon Interest Total P+I
<br />105%
<br />Overlevy
<br />02/01/2018 --119,236.88 119,236.88 125,198.72
<br />02/01/2019 240,000.00 1.400%158,982.50 398,982.50 418,931.63
<br />02/01/2020 245,000.00 1.600%155,622.50 400,622.50 420,653.63
<br />02/01/2021 250,000.00 1.750%151,702.50 401,702.50 421,787.63
<br />02/01/2022 255,000.00 1.900%147,327.50 402,327.50 422,443.88
<br />02/01/2023 260,000.00 2.100%142,482.50 402,482.50 422,606.63
<br />02/01/2024 265,000.00 2.200%137,022.50 402,022.50 422,123.63
<br />02/01/2025 270,000.00 2.300%131,192.50 401,192.50 421,252.13
<br />02/01/2026 275,000.00 2.400%124,982.50 399,982.50 419,981.63
<br />02/01/2027 280,000.00 2.500%118,382.50 398,382.50 418,301.63
<br />02/01/2028 290,000.00 2.550%111,382.50 401,382.50 421,451.63
<br />02/01/2029 295,000.00 2.650%103,987.50 398,987.50 418,936.88
<br />02/01/2030 305,000.00 2.750%96,170.00 401,170.00 421,228.50
<br />02/01/2031 310,000.00 2.850%87,782.50 397,782.50 417,671.63
<br />02/01/2032 320,000.00 2.950%78,947.50 398,947.50 418,894.88
<br />02/01/2033 330,000.00 3.050%69,507.50 399,507.50 419,482.88
<br />02/01/2034 340,000.00 3.150%59,442.50 399,442.50 419,414.63
<br />02/01/2035 350,000.00 3.200%48,732.50 398,732.50 418,669.13
<br />02/01/2036 360,000.00 3.300%37,532.50 397,532.50 417,409.13
<br />02/01/2037 375,000.00 3.350%25,652.50 400,652.50 420,685.13
<br />02/01/2038 385,000.00 3.400%13,090.00 398,090.00 417,994.50
<br />Total $6,000,000.00 -$2,119,161.88 $8,119,161.88 $8,525,119.97
<br />Significant Dates
<br />Dated 5/01/2017
<br />First Coupon Date 2/01/2018
<br />Yield Statistics
<br />Bond Year Dollars $72,460.00
<br />Average Life 12.077 Years
<br />Average Coupon 2.9245955%
<br />Net Interest Cost (NIC)3.0073998%
<br />True Interest Cost (TIC)2.9963368%
<br />Bond Yield for Arbitrage Purposes 2.8944994%
<br />All Inclusive Cost (AIC)3.0961484%
<br />IRS Form 8038
<br />Net Interest Cost 2.9245955%
<br />Weighted Average Maturity 12.077 Years
<br />Series 2017A GO CIP Bonds | SINGLE PURPOSE | 3/ 7/2017 | 8:27 AM
<br />
|