|
Page 7
<br />
<br />
<br />$3,985,000
<br />City of Elk River, Minnesota
<br />General Obligation Capital Improvement Plan and Equipment Bonds, Series 2021A
<br />Capital Improvement Plan Portion
<br />NET DEBT SERVICE SCHEDULE
<br />Date Principal Coupon Interest Total P+I CIF Net New D/S 105% Levy
<br />02/01/2022 --42,009.38 42,009.38 (42,009.38)--
<br />02/01/2023 175,000.00 0.550%60,252.50 235,252.50 -235,252.50 247,015.13
<br />02/01/2024 180,000.00 0.750%59,290.00 239,290.00 -239,290.00 251,254.50
<br />02/01/2025 180,000.00 0.850%57,940.00 237,940.00 -237,940.00 249,837.00
<br />02/01/2026 180,000.00 0.900%56,410.00 236,410.00 -236,410.00 248,230.50
<br />02/01/2027 180,000.00 1.000%54,790.00 234,790.00 -234,790.00 246,529.50
<br />02/01/2028 185,000.00 1.200%52,990.00 237,990.00 -237,990.00 249,889.50
<br />02/01/2029 185,000.00 1.350%50,770.00 235,770.00 -235,770.00 247,558.50
<br />02/01/2030 190,000.00 1.450%48,272.50 238,272.50 -238,272.50 250,186.13
<br />02/01/2031 190,000.00 1.500%45,517.50 235,517.50 -235,517.50 247,293.38
<br />02/01/2032 195,000.00 1.550%42,667.50 237,667.50 -237,667.50 249,550.88
<br />02/01/2033 200,000.00 1.600%39,645.00 239,645.00 -239,645.00 251,627.25
<br />02/01/2034 200,000.00 1.650%36,445.00 236,445.00 -236,445.00 248,267.25
<br />02/01/2035 205,000.00 1.700%33,145.00 238,145.00 -238,145.00 250,052.25
<br />02/01/2036 210,000.00 1.750%29,660.00 239,660.00 -239,660.00 251,643.00
<br />02/01/2037 210,000.00 1.800%25,985.00 235,985.00 -235,985.00 247,784.25
<br />02/01/2038 215,000.00 1.850%22,205.00 237,205.00 -237,205.00 249,065.25
<br />02/01/2039 220,000.00 1.900%18,227.50 238,227.50 -238,227.50 250,138.88
<br />02/01/2040 225,000.00 1.950%14,047.50 239,047.50 -239,047.50 250,999.88
<br />02/01/2041 230,000.00 2.000%9,660.00 239,660.00 -239,660.00 251,643.00
<br />02/01/2042 230,000.00 2.200%5,060.00 235,060.00 -235,060.00 246,813.00
<br />Total $3,985,000.00 -$804,989.38 $4,789,989.38 (42,009.38)$4,747,980.00 $4,985,379.00
<br />SIGNIFICANT DATES
<br />Dated Date............................................................................................................................................................5/20/2021
<br />Delivery Date.........................................................................................................................................................5/20/2021
<br />First Coupon Date.................................................................................................................................................2/01/2022
<br />Yield Statistics
<br />Bond Year Dollars..................................................................................................................................................$46,613.43
<br />Average Life..........................................................................................................................................................11.697 Years
<br />Average Coupon....................................................................................................................................................1.7269473%
<br />Net Interest Cost (NIC)...........................................................................................................................................1.8295358%
<br />True Interest Cost (TIC)..........................................................................................................................................1.8298781%
<br />Bond Yield for Arbitrage Purposes...........................................................................................................................1.6426246%
<br />All Inclusive Cost (AIC)...........................................................................................................................................1.9382412%
<br />IRS Form 8038
<br />Net Interest Cost...................................................................................................................................................1.7269473%
<br />Weighted Average Maturity.....................................................................................................................................11.697 Years
<br />2021A GO CIP and EC Bonds | Capital Improvement Plan | 3/ 1/2021 | 9:56 AM
<br />
|