|
<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 Fiscal Total
<br />05/01/2017 -----
<br />02/01/2018 --119,236.88 119,236.88 119,236.88
<br />08/01/2018 --79,491.25 79,491.25 -
<br />02/01/2019 240,000.00 1.400%79,491.25 319,491.25 398,982.50
<br />08/01/2019 --77,811.25 77,811.25 -
<br />02/01/2020 245,000.00 1.600%77,811.25 322,811.25 400,622.50
<br />08/01/2020 --75,851.25 75,851.25 -
<br />02/01/2021 250,000.00 1.750%75,851.25 325,851.25 401,702.50
<br />08/01/2021 --73,663.75 73,663.75 -
<br />02/01/2022 255,000.00 1.900%73,663.75 328,663.75 402,327.50
<br />08/01/2022 --71,241.25 71,241.25 -
<br />02/01/2023 260,000.00 2.100%71,241.25 331,241.25 402,482.50
<br />08/01/2023 --68,511.25 68,511.25 -
<br />02/01/2024 265,000.00 2.200%68,511.25 333,511.25 402,022.50
<br />08/01/2024 --65,596.25 65,596.25 -
<br />02/01/2025 270,000.00 2.300%65,596.25 335,596.25 401,192.50
<br />08/01/2025 --62,491.25 62,491.25 -
<br />02/01/2026 275,000.00 2.400%62,491.25 337,491.25 399,982.50
<br />08/01/2026 --59,191.25 59,191.25 -
<br />02/01/2027 280,000.00 2.500%59,191.25 339,191.25 398,382.50
<br />08/01/2027 --55,691.25 55,691.25 -
<br />02/01/2028 290,000.00 2.550%55,691.25 345,691.25 401,382.50
<br />08/01/2028 --51,993.75 51,993.75 -
<br />02/01/2029 295,000.00 2.650%51,993.75 346,993.75 398,987.50
<br />08/01/2029 --48,085.00 48,085.00 -
<br />02/01/2030 305,000.00 2.750%48,085.00 353,085.00 401,170.00
<br />08/01/2030 --43,891.25 43,891.25 -
<br />02/01/2031 310,000.00 2.850%43,891.25 353,891.25 397,782.50
<br />08/01/2031 --39,473.75 39,473.75 -
<br />02/01/2032 320,000.00 2.950%39,473.75 359,473.75 398,947.50
<br />08/01/2032 --34,753.75 34,753.75 -
<br />02/01/2033 330,000.00 3.050%34,753.75 364,753.75 399,507.50
<br />08/01/2033 --29,721.25 29,721.25 -
<br />02/01/2034 340,000.00 3.150%29,721.25 369,721.25 399,442.50
<br />08/01/2034 --24,366.25 24,366.25 -
<br />02/01/2035 350,000.00 3.200%24,366.25 374,366.25 398,732.50
<br />08/01/2035 --18,766.25 18,766.25 -
<br />02/01/2036 360,000.00 3.300%18,766.25 378,766.25 397,532.50
<br />08/01/2036 --12,826.25 12,826.25 -
<br />02/01/2037 375,000.00 3.350%12,826.25 387,826.25 400,652.50
<br />08/01/2037 --6,545.00 6,545.00 -
<br />02/01/2038 385,000.00 3.400%6,545.00 391,545.00 398,090.00
<br />Total $6,000,000.00 -$2,119,161.88 $8,119,161.88 -
<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:26 AM
<br />
|