|
<br />
<br />
<br />Northland Securities, Inc. Page 6
<br />Attachment 1 – Preliminary Debt Service Schedules
<br />Total Combined 2024A Bonds
<br />
<br />
<br />*Assumes Bank Qualified “Aa1” Rates as of April 19, 2024, plus 0.25%.
<br />Date Principal Coupon Interest Total P+I Fiscal Total
<br />07/02/2024 -----
<br />02/01/2025 35,000.00 3.800%103,697.38 138,697.38 138,697.38
<br />08/01/2025 --88,643.75 88,643.75 -
<br />02/01/2026 430,000.00 3.600%88,643.75 518,643.75 607,287.50
<br />08/01/2026 --80,903.75 80,903.75 -
<br />02/01/2027 450,000.00 3.450%80,903.75 530,903.75 611,807.50
<br />08/01/2027 --73,141.25 73,141.25 -
<br />02/01/2028 465,000.00 3.300%73,141.25 538,141.25 611,282.50
<br />08/01/2028 --65,468.75 65,468.75 -
<br />02/01/2029 480,000.00 3.300%65,468.75 545,468.75 610,937.50
<br />08/01/2029 --57,548.75 57,548.75 -
<br />02/01/2030 490,000.00 3.300%57,548.75 547,548.75 605,097.50
<br />08/01/2030 --49,463.75 49,463.75 -
<br />02/01/2031 510,000.00 3.300%49,463.75 559,463.75 608,927.50
<br />08/01/2031 --41,048.75 41,048.75 -
<br />02/01/2032 525,000.00 3.350%41,048.75 566,048.75 607,097.50
<br />08/01/2032 --32,255.00 32,255.00 -
<br />02/01/2033 545,000.00 3.400%32,255.00 577,255.00 609,510.00
<br />08/01/2033 --22,990.00 22,990.00 -
<br />02/01/2034 565,000.00 3.450%22,990.00 587,990.00 610,980.00
<br />08/01/2034 --13,243.75 13,243.75 -
<br />02/01/2035 580,000.00 3.550%13,243.75 593,243.75 606,487.50
<br />08/01/2035 --2,948.75 2,948.75 -
<br />02/01/2036 35,000.00 3.650%2,948.75 37,948.75 40,897.50
<br />08/01/2036 --2,310.00 2,310.00 -
<br />02/01/2037 40,000.00 3.750%2,310.00 42,310.00 44,620.00
<br />08/01/2037 --1,560.00 1,560.00 -
<br />02/01/2038 40,000.00 3.850%1,560.00 41,560.00 43,120.00
<br />08/01/2038 --790.00 790.00 -
<br />02/01/2039 40,000.00 3.950%790.00 40,790.00 41,580.00
<br />Total $5,230,000.00 -$1,168,329.88 $6,398,329.88 -
<br />Yield Statistics
<br />
<br />Bond Year Dollars $34,056.31
<br />Average Life 6.512 Years
<br />Average Coupon 3.4305832%
<br />
<br />Net Interest Cost (NIC)3.6302231%
<br />True Interest Cost (TIC)3.6572961%
<br />Bond Yield for Arbitrage Purposes 3.4259876%
<br />All Inclusive Cost (AIC)3.8763615%
<br />
<br />IRS Form 8038
<br />Net Interest Cost 3.4305832%
<br />Weighted Average Maturity 6.512 Years
<br />
<br />Optional Redemption
<br />02/01/2032 @100.000%
|