Attachment B
<br />City of Roseville, MN
<br />$2,570,000 General Obligation Bonds, Series 2020A
<br />Water Revenue
<br />Debt Service Schedule
<br />DatePrincipalCouponInterestTotal P+IFiscal Total
<br />12/30/2020-----
<br />08/01/2021--11,374.9511,374.95-
<br />02/01/2022250,000.000.400%9,703.75259,703.75271,078.70
<br />08/01/2022--9,203.759,203.75-
<br />02/01/2023250,000.000.450%9,203.75259,203.75268,407.50
<br />08/01/2023--8,641.258,641.25-
<br />02/01/2024255,000.000.500%8,641.25263,641.25272,282.50
<br />08/01/2024--8,003.758,003.75-
<br />02/01/2025255,000.000.550%8,003.75263,003.75271,007.50
<br />08/01/2025--7,302.507,302.50-
<br />02/01/2026255,000.000.650%7,302.50262,302.50269,605.00
<br />08/01/2026--6,473.756,473.75-
<br />02/01/2027255,000.000.750%6,473.75261,473.75267,947.50
<br />08/01/2027--5,517.505,517.50-
<br />02/01/2028260,000.000.900%5,517.50265,517.50271,035.00
<br />08/01/2028--4,347.504,347.50-
<br />02/01/2029260,000.001.000%4,347.50264,347.50268,695.00
<br />08/01/2029--3,047.503,047.50-
<br />02/01/2030265,000.001.100%3,047.50268,047.50271,095.00
<br />08/01/2030--1,590.001,590.00-
<br />02/01/2031265,000.001.200%1,590.00266,590.00268,180.00
<br />Total$2,570,000.00-$129,333.70$2,699,333.70-
<br />Yield Statistics
<br />Bond Year Dollars$14,496.31
<br />Average Life5.641 Years
<br />Average Coupon0.8921839%
<br />Net Interest Cost (NIC)1.1049277%
<br />True Interest Cost (TIC)1.1106225%
<br />Bond Yield for Arbitrage Purposes0.7645684%
<br />All Inclusive Cost (AIC)1.3073975%
<br />IRS Form 8038
<br />Net Interest Cost0.8921839%
<br />Weighted Average Maturity5.641 Years
<br />2020A GO Wat Rev Bonds & | Water Revenue | 11/ 2/2020 | 9:48 AM
<br />
<br />
<br />
|