Attachment B
<br />City of Roseville, MN
<br />$5,135,000 General Obligation Bonds, Series 2020A
<br />Current Refund 2011A GO
<br />Debt Service Schedule
<br />DatePrincipalCouponInterestTotal P+IFiscal Total
<br />12/30/2020-----
<br />08/01/2021--18,112.3018,112.30-
<br />02/01/2022720,000.000.400%15,451.25735,451.25753,563.55
<br />08/01/2022--14,011.2514,011.25-
<br />02/01/2023730,000.000.450%14,011.25744,011.25758,022.50
<br />08/01/2023--12,368.7512,368.75-
<br />02/01/2024725,000.000.500%12,368.75737,368.75749,737.50
<br />08/01/2024--10,556.2510,556.25-
<br />02/01/2025735,000.000.550%10,556.25745,556.25756,112.50
<br />08/01/2025--8,535.008,535.00-
<br />02/01/2026735,000.000.650%8,535.00743,535.00752,070.00
<br />08/01/2026--6,146.256,146.25-
<br />02/01/2027745,000.000.750%6,146.25751,146.25757,292.50
<br />08/01/2027--3,352.503,352.50-
<br />02/01/2028745,000.000.900%3,352.50748,352.50751,705.00
<br />Total$5,135,000.00-$143,503.55$5,278,503.55-
<br />Yield Statistics
<br />Bond Year Dollars$21,097.18
<br />Average Life4.109 Years
<br />Average Coupon0.6802025%
<br />Net Interest Cost (NIC)0.9722794%
<br />True Interest Cost (TIC)0.9789428%
<br />Bond Yield for Arbitrage Purposes0.7645684%
<br />All Inclusive Cost (AIC)1.2456125%
<br />IRS Form 8038
<br />Net Interest Cost0.6802025%
<br />Weighted Average Maturity4.109 Years
<br />2020A GO Wat Rev Bonds & | Current Refund 2011A GO | 11/ 2/2020 | 9:48 AM
<br />
<br />
<br />
|