|
<br />
<br />
<br />Northland Securities, Inc. Page 5
<br />Attachment 1 – Preliminary Debt Service Schedules
<br />
<br />
<br />
<br />*Assumes Bank Qualified “Aa1” Rates as of June 9, 2025, plus 0.50%.
<br />Date Principal Coupon Interest Total P+I Fiscal Total
<br />08/14/2025 -----
<br />08/01/2026 --81,164.26 81,164.26 -
<br />02/01/2027 150,000.00 3.500%42,102.50 192,102.50 273,266.76
<br />08/01/2027 --39,477.50 39,477.50 -
<br />02/01/2028 195,000.00 3.500%39,477.50 234,477.50 273,955.00
<br />08/01/2028 --36,065.00 36,065.00 -
<br />02/01/2029 200,000.00 3.550%36,065.00 236,065.00 272,130.00
<br />08/01/2029 --32,515.00 32,515.00 -
<br />02/01/2030 210,000.00 3.650%32,515.00 242,515.00 275,030.00
<br />08/01/2030 --28,682.50 28,682.50 -
<br />02/01/2031 215,000.00 3.750%28,682.50 243,682.50 272,365.00
<br />08/01/2031 --24,651.25 24,651.25 -
<br />02/01/2032 225,000.00 3.850%24,651.25 249,651.25 274,302.50
<br />08/01/2032 --20,320.00 20,320.00 -
<br />02/01/2033 235,000.00 3.950%20,320.00 255,320.00 275,640.00
<br />08/01/2033 --15,678.75 15,678.75 -
<br />02/01/2034 240,000.00 4.050%15,678.75 255,678.75 271,357.50
<br />08/01/2034 --10,818.75 10,818.75 -
<br />02/01/2035 250,000.00 4.150%10,818.75 260,818.75 271,637.50
<br />08/01/2035 --5,631.25 5,631.25 -
<br />02/01/2036 265,000.00 4.250%5,631.25 270,631.25 276,262.50
<br />Total $2,185,000.00 -$550,946.76 $2,735,946.76 -
<br />Yield Statistics
<br />Bond Year Dollars $13,883.60
<br />Average Life 6.354 Years
<br />Average Coupon 3.9683286%
<br />Net Interest Cost (NIC)4.1650536%
<br />True Interest Cost (TIC)4.1819569%
<br />Bond Yield for Arbitrage Purposes 3.9516071%
<br />All Inclusive Cost (AIC)4.6767382% IRS Form 8038
<br />Net Interest Cost 3.9683286%
<br />Weighted Average Maturity 6.354 Years Optional Redemption
<br />02/01/2033 @100.000%
|