|
$10,000,000
<br /> City of Elk River, Minnesota
<br /> Electric Revenue Bonds, Series 2016A
<br /> NET DEBT SERVICE SCHEDULE
<br /> Date Principal Coupon Interest Total P+I DSR Existing Net Net New D/S
<br /> D/S
<br /> 02/01/2017 - - 133,479.81 133,479.81 (3,892.55) 670,334.56 799,921.82
<br /> 02/01/2018 - - 243,922.50 243,922.50 (7,114.68) 673,385.00 910,192.82
<br /> 02/01/2019 465,000.00 1.350% 243,922.50 708,922.50 (7,114.68) 474,988.75 1,176,796.57
<br /> 02/01/2020 470,000.00 1.500% 237,645.00 707,645.00 (7,114.68) 256,162.50 956,692.82
<br /> 02/01/2021 480,000.00 1.650% 230,595.00 710,595.00 (7,114.68) 257,732.50 961,212.82
<br /> 02/01/2022 485,000.00 1.800% 222,675.00 707,675.00 (7,114.68) 112,732.50 813,292.82
<br /> 02/01/2023 495,000.00 1.900% 213,945.00 708,945.00 (7,114.68) - 701,830.32
<br /> 02/01/2024 505,000.00 2.050% 204,540.00 709,540.00 (7,114.68) - 702,425.32
<br /> 02/01/2025 515,000.00 2.100% 194,187.50 709,187.50 (7,114.68) - 702,072.82
<br /> 02/01/2026 525,000.00 2.250% 183,372.50 708,372.50 (7,114.68) - 701,257.82
<br /> 02/01/2027 535,000.00 2.400% 171,560.00 706,560.00 (7,114.68) - 699,445.32
<br /> 02/01/2028 550,000.00 2.500% 158,720.00 708,720.00 (7,114.68) - 701,605.32
<br /> 02/01/2029 565,000.00 2.600% 144,970.00 709,970.00 (7,114.68) - 702,855.32
<br /> 02/01/2030 580,000.00 2.650% 130,280.00 710,280.00 (7,114.68) - 703,165.32
<br /> 02/01/2031 595,000.00 2.750% 114,910.00 709,910.00 (7,114.68) - 702,795.32
<br /> 02/01/2032 610,000.00 2.800% 98,547.50 708,547.50 (7,114.68) - 701,432.82
<br /> 02/01/2033 630,000.00 2.950% 81,467.50 711,467.50 (7,114.68) - 704,352.82
<br /> 02/01/2034 645,000.00 3.050% 62,882.50 707,882.50 (7,114.68) - 700,767.82
<br /> 02/01/2035 665,000.00 3.150% 43,210.00 708,210.00 (7,114.68) - 701,095.32
<br /> 02/01/2036 685,000.00 3.250% 22,262.50 707,262.50 (718,582.18) - (11,319.68)
<br /> Total $10,000,000.00 - $3,137,094.81 $13,137,094.81 (850,538.97) $2,445,335.81 $14,731,891.65
<br /> SIGNIFICANT DATES
<br /> Dated Date 7/14/2016
<br /> Delivery Date 7/14/2016
<br /> First Coupon Date 2/01/2017
<br /> Yield Statistics
<br /> Bond Year Dollars $116,737.22
<br /> Average Life 11.674 Years
<br /> Average Coupon 2.6873132%
<br /> Net Interest Cost(NIC) 2.7986744%
<br /> True Interest Cost(TIC) 2.7947711%
<br /> Bond Yield for Arbitrage Purposes 2.6610456%
<br /> All Inclusive Cost(AIC) 2.8892451%
<br /> IRS Form 8038
<br /> Net Interest Cost 2.6873132%
<br /> Weighted Average Maturity 11.674 Years
<br /> Series 2016 Electric Rev SINGLE PURPOSE 4/29/20/6,223 PM
<br /> Springsted Page8
<br /> 173
<br />
|