Attachment B
<br />City of Roseville, MN
<br />$5,135,000 General Obligation Bonds, Series 2020A
<br />Current Refund 2011A GO
<br />Debt Service Comparison
<br />DateTotal P+INet New D/SOld Net D/SSavings
<br />03/01/2021-602.49-(602.49)
<br />03/01/2022753,563.55753,563.55796,982.5043,418.95
<br />03/01/2023758,022.50758,022.50802,685.0044,662.50
<br />03/01/2024749,737.50749,737.50796,930.0047,192.50
<br />03/01/2025756,112.50756,112.50799,555.0043,442.50
<br />03/01/2026752,070.00752,070.00795,607.5043,537.50
<br />03/01/2027757,292.50757,292.50800,532.5043,240.00
<br />03/01/2028751,705.00751,705.00798,637.5046,932.50
<br />Total$5,278,503.55$5,279,106.04$5,590,930.00$311,823.96
<br />PV Analysis Summary (Net to Net)
<br />Gross PV Debt Service Savings.....................300,186.53
<br />Net PV Cashflow Savings @ 0.765%(Bond Yield).....300,186.53
<br />Contingency or Rounding Amount....................(602.49)
<br />Net Present Value Benefit $299,584.04
<br />Net PV Benefit / $5,417,541.05 PV Refunded Debt Service5.530%
<br />Net PV Benefit / $5,020,000 Refunded Principal...5.968%
<br />Net PV Benefit / $5,135,000 Refunding Principal..5.834%
<br />Refunding Bond Information
<br />Refunding Dated Date 12/30/2020
<br />Refunding Delivery Date 12/30/2020
<br />2020A GO Wat Rev Bonds & | Current Refund 2011A GO | 11/ 2/2020 | 9:48 AM
<br />
<br />
<br />
|