|
IM
<br />Ci of Centerville, Minnesota
<br />$1,255,000 General Obligation Improvement Refunding Bonds, Series 2021A
<br />2013A Refunding - Final
<br />Debt Service Comparison
<br />Date
<br />Total P+I
<br />Net New DIS
<br />Old Net DIS
<br />Savings
<br />02/01/2022
<br />125,986.39
<br />122,914,37
<br />18m 8,206.26
<br />65,391.89
<br />02/01/2023
<br />133,000.00
<br />133,000.00
<br />185,106.26
<br />52,106,26
<br />02/01/2024
<br />120,800.00
<br />120,800.00
<br />186,812.50
<br />66,012,50
<br />02/0112025
<br />108,800.00
<br />108„800.00
<br />182,812,50
<br />74,012,50
<br />02/01/2026
<br />257,000.00
<br />257,000.00
<br />183,812.50
<br />(73,187.50)
<br />02/01/2027
<br />232,200.00 ................
<br />............... 232,240.00
<br />184,275.00
<br />(47,925.00)
<br />02/0112028
<br />212,800.00
<br />212,800.00
<br />179,600.00
<br />(33,200.00)
<br />02/0112029
<br />188,700.00
<br />188,700m
<br />154,500.00
<br />(34,200.00)
<br />Total
<br />$1,379,286.39
<br />$1,376,114,37
<br />$1,445,125.02_
<br />$69,010.65
<br />PV Analysis Summary (Net to Net)
<br />Cross PN7 Debt Service Savings .....................
<br />70,303.66
<br />Net 6"'%' Cashflowv Savings @ 0.893*/ and Yield)..... ........................................
<br />70,303.66
<br />Contingency or Rounding Amount,—. ............ ..
<br />3,172.02
<br />Net Present Value Benefit
<br />$73,475.66
<br />Net PV Benefit 1$1,392,143.41 PV Refunded Debt Service
<br />5.278%
<br />Net P1 Benefit / $1,285,000 Refunded Principal...
<br />5.718%
<br />Net PV Bene $1,255,000 Refanding Principal ..........................
<br />5.855%
<br />Refunding Bond Information
<br />Refunding Dated Date
<br />3/31/2021
<br />Refunding Delivery Date
<br />3/31 /2021
<br />13wf-fi—IReria I fo1P[4aU FUR.r4613 1 2041202/ 11 19AM
<br />Northland Securities, Inc.
<br />Public Finance Page 2
<br />
|