|
City of Arden Hills, Minnesota
<br />$4,670,000 General Obligation CIP Bonds, Series 2025
<br />Assumes Current Market BQ AAA Rates plus 75bps
<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 />- -
<br />02/01/2026
<br />119,022.22
<br />119,022.22
<br />(119,022.22) -
<br />08/01/2026
<br />83,687.50
<br />83,687.50
<br />- 83,687.50
<br />-
<br />02/01/2027
<br />400,000.00
<br />3.500%
<br />83,687.50
<br />483,687.50
<br />- 483,687.50
<br />567,375.00
<br />08/01/2027
<br />-
<br />-
<br />76,687.50
<br />76,687.50
<br />- 76,687.50
<br />-
<br />02/01/2028
<br />410,000.00
<br />3.500%
<br />76,687.50
<br />486,687.50
<br />- 486,687.50
<br />563,375.00
<br />08/01/2028
<br />-
<br />-
<br />69,512.50
<br />69,512.50
<br />- 69,512.50
<br />-
<br />02/01/2029
<br />425,000.00
<br />3.500%
<br />69,512.50
<br />494,512.50
<br />- 494,512.50
<br />564,025.00
<br />08/01/2029
<br />-
<br />-
<br />62,075.00
<br />62,075.00
<br />- 62,075.00
<br />-
<br />02/01/2030
<br />440,000.00
<br />3.500%
<br />62,075.00
<br />502,075.00
<br />- 502,075.00
<br />564,150.00
<br />08/01/2030
<br />-
<br />-
<br />54,375.00
<br />54,375.00
<br />- 54,375.00
<br />-
<br />02/01/2031
<br />455,000.00
<br />3.500%
<br />54,375.00
<br />509,375.00
<br />- 509,375.00
<br />563,750.00
<br />08/01/2031
<br />-
<br />-
<br />46,412.50
<br />46,412.50
<br />- 46,412.50
<br />-
<br />02/01/2032
<br />475,000.00
<br />3.550%
<br />46,412.50
<br />521,412.50
<br />- 521,412.50
<br />567,825.00
<br />08/01/2032
<br />-
<br />-
<br />37,981.25
<br />37,981.25
<br />- 37,981.25
<br />-
<br />02/01/2033
<br />490,000.00
<br />3.550%
<br />37,981.25
<br />527,981.25
<br />- 527,981.25
<br />565,962.50
<br />08/01/2033
<br />-
<br />-
<br />29,283.75
<br />29,283.75
<br />- 29,283.75
<br />-
<br />02/01/2034
<br />505,000.00
<br />3.650%
<br />29,283.75
<br />534,283.75
<br />- 534,283.75
<br />563,567.50
<br />08/01/2034
<br />-
<br />-
<br />20,067.50
<br />20,067.50
<br />- 20,067.50
<br />-
<br />02/01/2035
<br />525,000.00
<br />3.700%
<br />20,067.50
<br />545,067.50
<br />- 545,067.50
<br />565,135.00
<br />08/01/2035
<br />-
<br />-
<br />10,355.00
<br />10,355.00
<br />- 10,355.00
<br />-
<br />02/01/2036
<br />545,000.00
<br />3.800%
<br />10,355.00
<br />555,355.00
<br />- 555,355.00
<br />565,710.00
<br />Total $4,670,000.00
<br />- $1,099,897.22 $5,769,897.22 (119,022.22) $5,650,875.00 -
<br />Significant Dates
<br />Dated
<br />5/15/2025
<br />First Coupon Date
<br />2/01/2026
<br />Yield Statistics
<br />Bond Year Dollars
<br />$30,345.89
<br />Average Life
<br />6.498 Years
<br />Average Coupon
<br />3.6245345%
<br />Net Interest Cost (NIC)
<br />3.8092053%
<br />True Interest Cost (TIC)
<br />3.8331482%
<br />Bond Yield for Arbitrage Purposes
<br />3.6185476%
<br />All Inclusive Cost (AIC)
<br />4.0983427%
<br />IRS Form 8038
<br />Net Interest Cost
<br />3.6245345%
<br />Weighted Average Maturity
<br />6.498 Years
<br />Series 2025A GO CIP Bonds I SINGLE PURPOSE 1 8/28/2024 1 2:14 PM
<br />i44EHLERS
<br />PUBLIC FINANCE ADVISORS
<br />
|