|
$14,460,000
<br />City of Elk River, Minnesota
<br />Electric Revenue Bonds, Series 2021B
<br />Issue Summary
<br />DEBT SERVICE SCHEDULE
<br />DatePrincipalCouponInterestTotal P+I
<br />08/01/2021----
<br />02/01/2022--191,882.13191,882.13
<br />08/01/2022335,000.000.500%133,871.25468,871.25
<br />02/01/2023--133,033.75133,033.75
<br />08/01/2023395,000.000.550%133,033.75528,033.75
<br />02/01/2024--131,947.50131,947.50
<br />08/01/2024395,000.000.600%131,947.50526,947.50
<br />02/01/2025--130,762.50130,762.50
<br />08/01/2025400,000.000.650%130,762.50530,762.50
<br />02/01/2026--129,462.50129,462.50
<br />08/01/2026400,000.000.750%129,462.50529,462.50
<br />02/01/2027--127,962.50127,962.50
<br />08/01/2027405,000.000.850%127,962.50532,962.50
<br />02/01/2028--126,241.25126,241.25
<br />08/01/2028410,000.001.000%126,241.25536,241.25
<br />02/01/2029--124,191.25124,191.25
<br />08/01/2029410,000.001.150%124,191.25534,191.25
<br />02/01/2030--121,833.75121,833.75
<br />08/01/2030415,000.001.350%121,833.75536,833.75
<br />02/01/2031--119,032.50119,032.50
<br />08/01/2031420,000.001.550%119,032.50539,032.50
<br />02/01/2032--115,777.50115,777.50
<br />08/01/2032430,000.001.700%115,777.50545,777.50
<br />02/01/2033--112,122.50112,122.50
<br />08/01/2033435,000.001.750%112,122.50547,122.50
<br />02/01/2034--108,316.25108,316.25
<br />08/01/2034445,000.001.850%108,316.25553,316.25
<br />02/01/2035--104,200.00104,200.00
<br />08/01/2035450,000.001.900%104,200.00554,200.00
<br />02/01/2036--99,925.0099,925.00
<br />08/01/2036460,000.002.000%99,925.00559,925.00
<br />02/01/2037--95,325.0095,325.00
<br />08/01/2037470,000.002.050%95,325.00565,325.00
<br />02/01/2038--90,507.5090,507.50
<br />08/01/2038480,000.002.050%90,507.50570,507.50
<br />02/01/2039--85,587.5085,587.50
<br />08/01/2039490,000.002.050%85,587.50575,587.50
<br />02/01/2040--80,565.0080,565.00
<br />08/01/2040500,000.002.100%80,565.00580,565.00
<br />02/01/2041--75,315.0075,315.00
<br />08/01/2041510,000.002.150%75,315.00585,315.00
<br />02/01/2042--69,832.5069,832.50
<br />08/01/2042520,000.002.300%69,832.50589,832.50
<br />02/01/2043--63,852.5063,852.50
<br />08/01/2043535,000.002.300%63,852.50598,852.50
<br />02/01/2044--57,700.0057,700.00
<br />08/01/2044545,000.002.300%57,700.00602,700.00
<br />02/01/2045--51,432.5051,432.50
<br />08/01/2045560,000.002.300%51,432.50611,432.50
<br />02/01/2046--44,992.5044,992.50
<br />08/01/2046570,000.002.300%44,992.50614,992.50
<br />02/01/2047--38,437.5038,437.50
<br />08/01/2047585,000.002.500%38,437.50623,437.50
<br />02/01/2048--31,125.0031,125.00
<br />08/01/2048600,000.002.500%31,125.00631,125.00
<br />02/01/2049--23,625.0023,625.00
<br />08/01/2049615,000.002.500%23,625.00638,625.00
<br />02/01/2050--15,937.5015,937.50
<br />08/01/2050630,000.002.500%15,937.50645,937.50
<br />02/01/2051--8,062.508,062.50
<br />08/01/2051645,000.002.500%8,062.50653,062.50
<br />Total$14,460,000.00-$5,359,965.88$19,819,965.88
<br />SIGNIFICANT DATES
<br />Dated Date..........................................................................................................................................................5/13/2021
<br />Delivery Date.......................................................................................................................................................5/13/2021
<br />First Coupon Date................................................................................................................................................2/01/2022
<br />Yield Statistics
<br />Bond Year Dollars................................................................................................................................................$247,858.00
<br />Average Life........................................................................................................................................................17.141 Years
<br />Average Coupon..................................................................................................................................................2.1625148%
<br />Net Interest Cost (NIC).........................................................................................................................................2.2558585%
<br />True Interest Cost (TIC)........................................................................................................................................2.2498337%
<br />Bond Yield for Arbitrage Purposes.........................................................................................................................2.1335381%
<br />All Inclusive Cost (AIC).........................................................................................................................................2.2932331%
<br />IRS Form 8038
<br />Net Interest Cost.................................................................................................................................................2.1625148%
<br />Weighted Average Maturity...................................................................................................................................17.141 Years
<br />File | Working Elk River MN.sf | 2021 Electric Rev Bonds 3 | SINGLE PURPOSE | 1/22/2021 | 1:45 PM
<br />Page 6
<br />334
<br />
|