|
Attachment B
<br />City of Roseville, MN
<br />$7,705,000 General Obligation Bonds, Series 2020A
<br />Issue Summary
<br />Assumes Current Market BQ AAA rates plus 20bps
<br />Debt Service Schedule
<br />DatePrincipalCouponInterestTotal P+IFiscal Total
<br />12/30/2020-----
<br />08/01/2021--29,487.2529,487.25-
<br />02/01/2022970,000.000.400%25,155.00995,155.001,024,642.25
<br />08/01/2022--23,215.0023,215.00-
<br />02/01/2023980,000.000.450%23,215.001,003,215.001,026,430.00
<br />08/01/2023--21,010.0021,010.00-
<br />02/01/2024980,000.000.500%21,010.001,001,010.001,022,020.00
<br />08/01/2024--18,560.0018,560.00-
<br />02/01/2025990,000.000.550%18,560.001,008,560.001,027,120.00
<br />08/01/2025--15,837.5015,837.50-
<br />02/01/2026990,000.000.650%15,837.501,005,837.501,021,675.00
<br />08/01/2026--12,620.0012,620.00-
<br />02/01/20271,000,000.000.750%12,620.001,012,620.001,025,240.00
<br />08/01/2027--8,870.008,870.00-
<br />02/01/20281,005,000.000.900%8,870.001,013,870.001,022,740.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$7,705,000.00-$272,837.25$7,977,837.25-
<br />Yield Statistics
<br />Bond Year Dollars$35,593.49
<br />Average Life4.620 Years
<br />Average Coupon0.7665370%
<br />Net Interest Cost (NIC)1.0263037%
<br />True Interest Cost (TIC)1.0322992%
<br />Bond Yield for Arbitrage Purposes0.7645684%
<br />All Inclusive Cost (AIC)1.2706133%
<br />IRS Form 8038
<br />Net Interest Cost0.7665370%
<br />Weighted Average Maturity4.620 Years
<br />2020A GO Wat Rev Bonds & | Issue Summary | 11/ 2/2020 | 9:48 AM
<br />
<br />
<br />
|