|
City of Arden Hills, Minnesota
<br />$4,690,000 General Obligation CIP Bonds, Series 2025
<br />Assumes Current Market BQ AAA Rates plus 75bps
<br />20 Years
<br />Net Debt Service Schedule
<br />Date
<br />Principal
<br />Coupon
<br />Interest
<br />Total P+I
<br />CIF
<br />Net New D/S
<br />Fiscal Total
<br />05/15/2025
<br />-
<br />-
<br />02/01/2026
<br />135,939.56
<br />135,939.56
<br />(135,939.56)
<br />-
<br />08/01/2026
<br />95,582.50
<br />95,582.50
<br />95,582.50
<br />-
<br />02/01/2027
<br />160,000.00
<br />3.500%
<br />95,582.50
<br />255,582.50
<br />255,582.50
<br />351,165.00
<br />08/01/2027
<br />-
<br />-
<br />92,782.50
<br />92,782.50
<br />92,782.50
<br />_
<br />02/01/2028
<br />170,000.00
<br />3.500%
<br />92,782.50
<br />262,782.50
<br />262,782.50
<br />355,565.00
<br />08/01/2028
<br />-
<br />-
<br />89,807.50
<br />89,807.50
<br />89,807.50
<br />-
<br />02/01/2029
<br />175,000.00
<br />3.500%
<br />89,807.50
<br />264,807.50
<br />264,807.50
<br />354,615.00
<br />08/01/2029
<br />-
<br />-
<br />86,745.00
<br />86,745.00
<br />86,745.00
<br />-
<br />02/01/2030
<br />180,000.00
<br />3.500%
<br />86,745.00
<br />266,745.00
<br />266,745.00
<br />353,490.00
<br />08/01/2030
<br />-
<br />-
<br />83,595.00
<br />83,595.00
<br />83,595.00
<br />-
<br />02/01/2031
<br />185,000.00
<br />3.500%
<br />83,595.00
<br />268,595.00
<br />268,595.00
<br />352,190.00
<br />08/01/2031
<br />-
<br />-
<br />80,357.50
<br />80,357.50
<br />80,357.50
<br />-
<br />02/01/2032
<br />195,000.00
<br />3.550%
<br />80,357.50
<br />275,357.50
<br />275,357.50
<br />355,715.00
<br />08/01/2032
<br />-
<br />-
<br />76,896.25
<br />76,896.25
<br />76,896.25
<br />-
<br />02/01/2033
<br />200,000.00
<br />3.550%
<br />76,896.25
<br />276,896.25
<br />276,896.25
<br />353,792.50
<br />08/01/2033
<br />-
<br />-
<br />73,346.25
<br />73,346.25
<br />73,346.25
<br />-
<br />02/01/2034
<br />205,000.00
<br />3.650%
<br />73,346.25
<br />278,346.25
<br />278,346.25
<br />351,692.50
<br />08/01/2034
<br />-
<br />-
<br />69,605.00
<br />69,605.00
<br />69,605.00
<br />-
<br />02/01/2035
<br />215,000.00
<br />3.700%
<br />69,605.00
<br />284,605.00
<br />284,605.00
<br />354,210.00
<br />08/01/2035
<br />-
<br />-
<br />65,627.50
<br />65,627.50
<br />65,627.50
<br />-
<br />02/01/2036
<br />220,000.00
<br />3.800%
<br />65,627.50
<br />285,627.50
<br />285,627.50
<br />351,255.00
<br />08/01/2036
<br />-
<br />-
<br />61,447.50
<br />61,447.50
<br />61,447.50
<br />-
<br />02/01/2037
<br />230,000.00
<br />3.900%
<br />61,447.50
<br />291,447.50
<br />291,447.50
<br />352,895.00
<br />08/01/2037
<br />-
<br />-
<br />56,962.50
<br />56,962.50
<br />56,962.50
<br />-
<br />02/01/2038
<br />240,000.00
<br />3.950%
<br />56,962.50
<br />296,962.50
<br />296,962.50
<br />353,925.00
<br />08/01/2038
<br />-
<br />-
<br />52,222.50
<br />52,222.50
<br />52,222.50
<br />-
<br />02/01/2039
<br />250,000.00
<br />4.050%
<br />52,222.50
<br />302,222.50
<br />302,222.50
<br />354,445.00
<br />08/01/2039
<br />-
<br />-
<br />47,160.00
<br />47,160.00
<br />47,160.00
<br />-
<br />02/01/2040
<br />260,000.00
<br />4.150%
<br />47,160.00
<br />307,160.00
<br />307,160.00
<br />354,320.00
<br />08/01/2040
<br />-
<br />-
<br />41,765.00
<br />41,765.00
<br />41,765.00
<br />-
<br />02/01/2041
<br />270,000.00
<br />4.350%
<br />41,765.00
<br />311,765.00
<br />311,765.00
<br />353,530.00
<br />08/01/2041
<br />-
<br />-
<br />35,892.50
<br />35,892.50
<br />35,892.50
<br />-
<br />02/01/2042
<br />280,000.00
<br />4.500%
<br />35,892.50
<br />315,892.50
<br />315,892.50
<br />351,785.00
<br />08/01/2042
<br />-
<br />29,592.50
<br />29,592.50
<br />29,592.50
<br />-
<br />02/01/2043
<br />295,000.00
<br />4.600%
<br />29,592.50
<br />324,592.50
<br />324,592.50
<br />354,185.00
<br />08/01/2043
<br />-
<br />-
<br />22,807.50
<br />22,807.50
<br />22,807.50
<br />-
<br />02/01/2044
<br />305,000.00
<br />4.700%
<br />22,807.50
<br />327,807.50
<br />327,807.50
<br />350,615.00
<br />08/01/2044
<br />-
<br />-
<br />15,640.00
<br />15,640.00
<br />15,640.00
<br />-
<br />02/01/2045
<br />320,000.00
<br />4.750%
<br />15,640.00
<br />335,640.00
<br />335,640.00
<br />351,280.00
<br />08/01/2045
<br />-
<br />-
<br />8,040.00
<br />8,040.00
<br />8,040.00
<br />-
<br />02/01/2046
<br />335,000.00
<br />4.800%
<br />8,040.00
<br />343,040.00
<br />343,040.00
<br />351,080.00
<br />Total $4,690,000.00
<br />-
<br />$2,507,689.56
<br />$7,197,689.56
<br />(135,939.56)
<br />$7,061,750.00
<br />-
<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 />$58,465.11
<br />Average Life
<br />12.466 Years
<br />Average Coupon
<br />4.2892069%
<br />Net Interest Cost (NIC)
<br />4.3854694%
<br />True Interest Cost (TIC)
<br />4.3787402%
<br />Bond Yield for Arbitrage Purposes
<br />4.2481600%
<br />All Inclusive Cost (AIC)
<br />4.5395776%
<br />IRS Form 8038
<br />Net Interest Cost
<br />4.2892069%
<br />Weighted Average Maturity
<br />12.466 Years
<br />Series 2025A GO CIP Bonds I SINGLE PURPOSE
<br />1 8/28/2024 1 2:13 PM
<br />14EHLERS
<br />PUBLIC FINANCE ADVISORS
<br />
|