|
NORTHLAND
<br />SECURITIES
<br />EXHIBIT D - DEBT SERVICE COMPARISON
<br />Date Total P+I
<br />Net New D/S
<br />-
<br />Old Net D/S
<br />S ayin s
<br />__ ......
<br />®
<br />02/01/2022 125,9$6.39
<br />122,814.37
<br />188,20b.26
<br />65,391.89
<br />02/01/2023 133,000.00
<br />133,000.00
<br />185,106.26
<br />52,106.26
<br />02101/2024 120,800,00
<br />120,800.00
<br />186,812.50
<br />66,012.50
<br />02/01/2025 108,800.00
<br />108,800.00
<br />182,812.50
<br />74,012.50
<br />02/01/2026 257,000.00
<br />257,000.00
<br />183,812.50
<br />(73,187,50)
<br />02/01/2027 232,200.00
<br />232,200.00
<br />184,275.00
<br />(47,925.00)
<br />02/01/2028 212,800.00
<br />212,800.00
<br />179,600.00
<br />(33,200.00)
<br />02/01/2029 188,700.00
<br />188,700.00
<br />154,500,00
<br />(34,200.00)
<br />... _____________.
<br />Total $1,379,2$6.39
<br />$1 376,114.37
<br />$1,445125.02 „
<br />$69,010.65
<br />PV Analysis Summary (Net to Net)
<br />Cross PV Debt Service Savings. ....................
<br />70,303.66
<br />Net PVCashflowSavings :^; 0.893%(Bond Yield).....
<br />70,303.66
<br />Contingency or Rounding Amount ....................
<br />3,172.02
<br />Net Present Value Benefit
<br />$73,475.68
<br />Net PV Benefit / $1,392,143.41 PV Refunded Debt Service
<br />5.278%
<br />Net PV Benefit / $1,285,000 Refunded Principal...
<br />5.718%
<br />Net PV Benefit / $1,255,000 Refunding 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 />Page 6
<br />
|