|
City of Arden Hills, Minnesota
<br />$4,645,000 General Obligation CIP Bonds, Series 2025
<br />Assumes Current Market BQ AAA Rates
<br />10 Years
<br />Net Debt Service Schedule
<br />Date
<br />Principal
<br />Coupon
<br />Interest
<br />Total P+I
<br />CIF Net New D/S
<br />Fiscal Total
<br />05/15/2025
<br />-
<br />-
<br />02/01/2026
<br />93,546.67
<br />93,546.67
<br />(93,546.67) -
<br />08/01/2026
<br />65,775.00
<br />65,775.00
<br />65,775.00
<br />-
<br />02/01/2027
<br />410,000.00
<br />2.750%
<br />65,775.00
<br />475,775.00
<br />475,775.00
<br />541,550.00
<br />08/01/2027
<br />-
<br />-
<br />60,137.50
<br />60,137.50
<br />60,137.50
<br />-
<br />02/01/2028
<br />420,000.00
<br />2.750%
<br />60,137.50
<br />480,137.50
<br />480,137.50
<br />540,275.00
<br />08/01/2028
<br />-
<br />-
<br />54,362.50
<br />54,362.50
<br />54,362.50
<br />-
<br />02/01/2029
<br />435,000.00
<br />2.750%
<br />54,362.50
<br />489,362.50
<br />489,362.50
<br />543,725.00
<br />08/01/2029
<br />-
<br />-
<br />48,381.25
<br />48,381.25
<br />48,381.25
<br />-
<br />02/01/2030
<br />445,000.00
<br />2.750%
<br />48,381.25
<br />493,381.25
<br />493,381.25
<br />541,762.50
<br />08/01/2030
<br />-
<br />-
<br />42,262.50
<br />42,262.50
<br />42,262.50
<br />-
<br />02/01/2031
<br />455,000.00
<br />2.750%
<br />42,262.50
<br />497,262.50
<br />497,262.50
<br />539,525.00
<br />08/01/2031
<br />-
<br />-
<br />36,006.25
<br />36,006.25
<br />36,006.25
<br />-
<br />02/01/2032
<br />470,000.00
<br />2.800%
<br />36,006.25
<br />506,006.25
<br />506,006.25
<br />542,012.50
<br />08/01/2032
<br />-
<br />-
<br />29,426.25
<br />29,426.25
<br />29,426.25
<br />-
<br />02/01/2033
<br />480,000.00
<br />2.800%
<br />29,426.25
<br />509,426.25
<br />509,426.25
<br />538,852.50
<br />08/01/2033
<br />-
<br />-
<br />22,706.25
<br />22,706.25
<br />22,706.25
<br />-
<br />02/01/2034
<br />495,000.00
<br />2.900%
<br />22,706.25
<br />517,706.25
<br />517,706.25
<br />540,412.50
<br />08/01/2034
<br />-
<br />-
<br />15,528.75
<br />15,528.75
<br />15,528.75
<br />-
<br />02/01/2035
<br />510,000.00
<br />2.950%
<br />15,528.75
<br />525,528.75
<br />525,528.75
<br />541,057.50
<br />08/01/2035
<br />-
<br />-
<br />8,006.25
<br />8,006.25
<br />8,006.25
<br />-
<br />02/01/2036
<br />525,000.00
<br />3.050%
<br />8,006.25
<br />533,006.25
<br />533,006.25
<br />541,012.50
<br />Total $4,645,000.00
<br />- $858,731.67 $5,503,731.67 (93,546.67) $5,410,185.00 -
<br />Significant Dates
<br />Dated
<br />5/15/2025
<br />First Coupon Date
<br />Yield Statistics
<br />2/01/2026
<br />Bond Year Dollars
<br />Average Life
<br />$29,893.11
<br />6.436 Years
<br />Average Coupon
<br />Net Interest Cost (NIC)
<br />True Interest Cost (TIC)
<br />2.8726741%
<br />3.0591385%
<br />3.0785566%
<br />Bond Yield for Arbitrage Purposes
<br />All Inclusive Cost (AIC)
<br />2.8681724%
<br />3.3399105%
<br />IRS Form 8038
<br />Net Interest Cost
<br />2.8726741%
<br />Weighted Average Maturity
<br />6.436 Years
<br />Series 2025A GO CIP Bonds I SINGLE PURPOSE 1 8/28/2024 1 2:11 PM
<br />REHLERS
<br />PUBLIC FINANCE ADVISORS
<br />
|