|
<br />
<br />
<br />Northland Securities, Inc. Page 5
<br />Attachment 1 – Preliminary Debt Service Schedules
<br />
<br />Total Combined 2023A Bonds
<br />
<br />
<br />*Assumes Bank Qualified “Aa1” Rates as of April 21, 2023, plus 0.25%.
<br />Date Principal Coupon Interest Total P+I Fiscal Total
<br />07/06/2023 -----
<br />02/01/2024 140,000.00 3.200%108,006.52 248,006.52 248,006.52
<br />08/01/2024 --92,595.00 92,595.00 -
<br />02/01/2025 440,000.00 3.100%92,595.00 532,595.00 625,190.00
<br />08/01/2025 --85,775.00 85,775.00 -
<br />02/01/2026 455,000.00 3.100%85,775.00 540,775.00 626,550.00
<br />08/01/2026 --78,722.50 78,722.50 -
<br />02/01/2027 470,000.00 3.050%78,722.50 548,722.50 627,445.00
<br />08/01/2027 --71,555.00 71,555.00 -
<br />02/01/2028 480,000.00 3.050%71,555.00 551,555.00 623,110.00
<br />08/01/2028 --64,235.00 64,235.00 -
<br />02/01/2029 495,000.00 3.050%64,235.00 559,235.00 623,470.00
<br />08/01/2029 --56,686.25 56,686.25 -
<br />02/01/2030 510,000.00 3.050%56,686.25 566,686.25 623,372.50
<br />08/01/2030 --48,908.75 48,908.75 -
<br />02/01/2031 530,000.00 3.100%48,908.75 578,908.75 627,817.50
<br />08/01/2031 --40,693.75 40,693.75 -
<br />02/01/2032 545,000.00 3.200%40,693.75 585,693.75 626,387.50
<br />08/01/2032 --31,973.75 31,973.75 -
<br />02/01/2033 555,000.00 3.350%31,973.75 586,973.75 618,947.50
<br />08/01/2033 --22,677.50 22,677.50 -
<br />02/01/2034 580,000.00 3.450%22,677.50 602,677.50 625,355.00
<br />08/01/2034 --12,672.50 12,672.50 -
<br />02/01/2035 160,000.00 3.600%12,672.50 172,672.50 185,345.00
<br />08/01/2035 --9,792.50 9,792.50 -
<br />02/01/2036 165,000.00 3.700%9,792.50 174,792.50 184,585.00
<br />08/01/2036 --6,740.00 6,740.00 -
<br />02/01/2037 170,000.00 3.800%6,740.00 176,740.00 183,480.00
<br />08/01/2037 --3,510.00 3,510.00 -
<br />02/01/2038 180,000.00 3.900%3,510.00 183,510.00 187,020.00
<br />Total $5,875,000.00 -$1,361,081.52 $7,236,081.52 -
<br />Yield Statistics
<br />
<br />Bond Year Dollars $40,895.49
<br />Average Life 6.961 Years
<br />Average Coupon 3.3281950%
<br />
<br />Net Interest Cost (NIC)3.5149515%
<br />True Interest Cost (TIC)3.5330018%
<br />Bond Yield for Arbitrage Purposes 3.3152525%
<br />All Inclusive Cost (AIC)3.7162818%
<br />
<br />IRS Form 8038
<br />Net Interest Cost 3.3281950%
<br />Weighted Average Maturity 6.961 Years
<br />
<br />Optional Redemption
<br />02/01/2031 @100.000%
|