|
$7,680,000
<br />City of Elk River, Minnesota
<br />General Obligation Capital Improvement Plan Bonds, Series 2020A
<br />Public Safety Expansion
<br />DEBT SERVICE SCHEDULE
<br />DatePrincipalCouponInterestTotal P+I105% LevyFiscal Total
<br />12/29/2020------
<br />08/01/2021--69,603.7269,603.7273,083.91-
<br />02/01/2022--59,097.5059,097.5062,052.38135,136.28
<br />08/01/2022--59,097.5059,097.5062,052.38-
<br />02/01/2023345,000.000.600%59,097.50404,097.50424,302.38486,354.75
<br />08/01/2023--58,062.5058,062.5060,965.63-
<br />02/01/2024345,000.000.650%58,062.50403,062.50423,215.63484,181.25
<br />08/01/2024--56,941.2556,941.2559,788.31-
<br />02/01/2025345,000.000.700%56,941.25401,941.25422,038.31481,826.63
<br />08/01/2025--55,733.7555,733.7558,520.44-
<br />02/01/2026350,000.000.850%55,733.75405,733.75426,020.44484,540.88
<br />08/01/2026--54,246.2554,246.2556,958.56-
<br />02/01/2027350,000.001.000%54,246.25404,246.25424,458.56481,417.13
<br />08/01/2027--52,496.2552,496.2555,121.06-
<br />02/01/2028355,000.001.100%52,496.25407,496.25427,871.06482,992.13
<br />08/01/2028--50,543.7550,543.7553,070.94-
<br />02/01/2029360,000.001.200%50,543.75410,543.75431,070.94484,141.88
<br />08/01/2029--48,383.7548,383.7550,802.94-
<br />02/01/2030365,000.001.300%48,383.75413,383.75434,052.94484,855.88
<br />08/01/2030--46,011.2546,011.2548,311.81-
<br />02/01/2031370,000.001.400%46,011.25416,011.25436,811.81485,123.63
<br />08/01/2031--43,421.2543,421.2545,592.31-
<br />02/01/2032375,000.001.500%43,421.25418,421.25439,342.31484,934.63
<br />08/01/2032--40,608.7540,608.7542,639.19-
<br />02/01/2033380,000.001.600%40,608.75420,608.75441,639.19484,278.38
<br />08/01/2033--37,568.7537,568.7539,447.19-
<br />02/01/2034385,000.001.700%37,568.75422,568.75443,697.19483,144.38
<br />08/01/2034--34,296.2534,296.2536,011.06-
<br />02/01/2035390,000.001.800%34,296.25424,296.25445,511.06481,522.13
<br />08/01/2035--30,786.2530,786.2532,325.56-
<br />02/01/2036400,000.001.850%30,786.25430,786.25452,325.56484,651.13
<br />08/01/2036--27,086.2527,086.2528,440.56-
<br />02/01/2037405,000.001.950%27,086.25432,086.25453,690.56482,131.13
<br />08/01/2037--23,137.5023,137.5024,294.38-
<br />02/01/2038415,000.002.000%23,137.50438,137.50460,044.38484,338.75
<br />08/01/2038--18,987.5018,987.5019,936.88-
<br />02/01/2039425,000.002.100%18,987.50443,987.50466,186.88486,123.75
<br />08/01/2039--14,525.0014,525.0015,251.25-
<br />02/01/2040430,000.002.150%14,525.00444,525.00466,751.25482,002.50
<br />08/01/2040--9,902.509,902.5010,397.63-
<br />02/01/2041440,000.002.200%9,902.50449,902.50472,397.63482,795.25
<br />08/01/2041--5,062.505,062.505,315.63-
<br />02/01/2042450,000.002.250%5,062.50455,062.50477,815.63483,131.25
<br />Total$7,680,000.00-$1,662,498.72$9,342,498.72$9,809,623.66-
<br />SIGNIFICANT DATES
<br />Dated...................................................................................................................................................................12/29/2020
<br />Delivery Date........................................................................................................................................................12/29/2020
<br />First Coupon Date.................................................................................................................................................8/01/2021
<br />Yield Statistics
<br />Bond Year Dollars.................................................................................................................................................$92,742.67
<br />Average Life..........................................................................................................................................................12.076 Years
<br />Average Coupon....................................................................................................................................................1.7925932%
<br />Net Interest Cost (NIC)..........................................................................................................................................1.9168079%
<br />True Interest Cost (TIC)..........................................................................................................................................1.9162715%
<br />Bond Yield for Arbitrage Purposes..........................................................................................................................1.7742370%
<br />All Inclusive Cost (AIC)..........................................................................................................................................1.9666110%
<br />IRS Form 8038
<br />Net Interest Cost...................................................................................................................................................1.7925932%
<br />Weighted Average Maturity....................................................................................................................................12.076 Years
<br />2020A GO CIP Bonds 20 Yr | Public Safety Expansion | 10/22/2020 | 3:25 PM
<br />Page 13
<br />
|