|
City of Arden Hills, Minnesota
<br />$4,660,000 General Obligation CIP Bonds, Series 2025
<br />Assumes Current Market BQ AAA Rates
<br />20 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 />109,582.22
<br />109,582.22
<br />(109,582.22) -
<br />08/01/2026
<br />77,050.00
<br />77,050.00
<br />77,050.00
<br />-
<br />02/01/2027
<br />175,000.00
<br />2.750%
<br />77,050.00
<br />252,050.00
<br />252,050.00
<br />329,100.00
<br />08/01/2027
<br />-
<br />-
<br />74,643.75
<br />74,643.75
<br />74,643.75
<br />-
<br />02/01/2028
<br />180,000.00
<br />2.750%
<br />74,643.75
<br />254,643.75
<br />254,643.75
<br />329,287.50
<br />08/01/2028
<br />-
<br />-
<br />72,168.75
<br />72,168.75
<br />72,168.75
<br />-
<br />02/01/2029
<br />185,000.00
<br />2.750%
<br />72,168.75
<br />257,168.75
<br />257,168.75
<br />329,337.50
<br />08/01/2029
<br />-
<br />-
<br />69,625.00
<br />69,625.00
<br />69,625.00
<br />-
<br />02/01/2030
<br />190,000.00
<br />2.750%
<br />69,625.00
<br />259,625.00
<br />259,625.00
<br />_ 329,250.00
<br />08/01/2030
<br />-
<br />-
<br />67,012.50
<br />67,012.50
<br />67,012.50
<br />-
<br />02/01/2031
<br />195,000.00
<br />2.750%
<br />67,012.50
<br />262,012.50
<br />262,012.50
<br />329,025.00
<br />08/01/2031
<br />-
<br />-
<br />64,331.25
<br />64,331.25
<br />64,331.25
<br />-
<br />02/01/2032
<br />200,000.00
<br />2.800%
<br />64,331.25
<br />264,331.25
<br />264,331.25
<br />328,662.50
<br />08/01/2032
<br />-
<br />-
<br />61,531.25
<br />61,531.25
<br />61,531.25
<br />-
<br />02/01/2033
<br />205,000.00
<br />2.800%
<br />61,531.25
<br />266,531.25
<br />266,531.25
<br />328,062.50
<br />08/01/2033
<br />-
<br />-
<br />58,661.25
<br />58,661.25
<br />58,661.25
<br />-
<br />02/01/2034
<br />210,000.00
<br />2.900%
<br />58,661.25
<br />268,661.25
<br />268,661.25
<br />327,322.50
<br />08/01/2034
<br />-
<br />-
<br />55,616.25
<br />55,616.25
<br />55,616.25
<br />-
<br />02/01/2035
<br />215,000.00
<br />2.950%
<br />55,616.25
<br />270,616.25
<br />270,616.25
<br />326,232.50
<br />08/01/2035
<br />-
<br />-
<br />52,445.00
<br />52,445.00
<br />52,445.00
<br />-
<br />02/01/2036
<br />225,000.00
<br />3.050%
<br />52,445.00
<br />277,445.00
<br />277,445.00
<br />329,890.00
<br />08/01/2036
<br />-
<br />-
<br />49,013.75
<br />49,013.75
<br />49,013.75
<br />-
<br />02/01/2037
<br />230,000.00
<br />3.150%
<br />49,013.75
<br />279,013.75
<br />279,013.75
<br />328,027.50
<br />08/01/2037
<br />-
<br />-
<br />45,391.25
<br />45,391.25
<br />45,391.25
<br />-
<br />02/01/2038
<br />235,000.00
<br />3.200%
<br />45,391.25
<br />280,391.25
<br />280,391.25
<br />325,782.50
<br />08/01/2038
<br />-
<br />-
<br />41,631.25
<br />41,631.25
<br />41,631.25
<br />-
<br />02/01/2039
<br />245,000.00
<br />3.300%
<br />41,631.25
<br />286,631.25
<br />286,631.25
<br />328,262.50
<br />08/01/2039
<br />-
<br />-
<br />37,588.75
<br />37,588.75
<br />37,588.75
<br />-
<br />02/01/2040
<br />250,000.00
<br />3.400%
<br />37,588.75
<br />287,588.75
<br />287,588.75
<br />325,177.50
<br />08/01/2040
<br />-
<br />-
<br />33,338.75
<br />33,338.75
<br />33,338.75
<br />-
<br />02/01/2041
<br />260,000.00
<br />3.600%
<br />33,338.75
<br />293,338.75
<br />293,338.75
<br />326,677.50
<br />08/01/2041
<br />-
<br />-
<br />28,658.75
<br />28,658.75
<br />28,658.75
<br />-
<br />02/01/2042
<br />270,000.00
<br />3.750%
<br />28,658.75
<br />298,658.75
<br />298,658.75
<br />327,317.50
<br />08/01/2042
<br />-
<br />-
<br />23,596.25
<br />23,596.25
<br />23,596.25
<br />-
<br />02/01/2043
<br />280,000.00
<br />3.850%
<br />23,596.25
<br />303,596.25
<br />303,596.25
<br />327,192.50
<br />08/01/2043
<br />-
<br />-
<br />18,206.25
<br />18,206.25
<br />18,206.25
<br />-
<br />02/01/2044
<br />290,000.00
<br />3.950%
<br />18,206.25
<br />308,206.25
<br />308,206.25
<br />326,412.50
<br />08/01/2044
<br />-
<br />-
<br />12,478.75
<br />12,478.75
<br />12,478.75
<br />-
<br />02/01/2045
<br />305,000.00
<br />4.000%
<br />12,478.75
<br />317,478.75
<br />317,478.75
<br />329,957.50
<br />08/01/2045
<br />-
<br />-
<br />6,378.75
<br />6,378.75
<br />6,378.75
<br />-
<br />02/01/2046
<br />315,000.00
<br />4.050%
<br />6,378.75
<br />321,378.75
<br />321,378.75
<br />327,757.50
<br />Total $4,660,000.00
<br />-
<br />$2,008,317.22
<br />$6,668,317.22
<br />(109,582.22) $6,558,735.00
<br />-
<br />Significant Dates
<br />Dated
<br />_
<br />5/15/2025
<br />First Coupon Date
<br />2/01/2026
<br />Yield Statistics
<br />Bond Year Dollars
<br />$56,968.78
<br />Average Life
<br />12.225 Years
<br />Average Coupon
<br />3.5252946%
<br />Net Interest Cost (NIC)
<br />3.6234536%
<br />True Interest Cost (TIC)
<br />3.6167188%
<br />Bond Yield for Arbitrage Purposes
<br />3.4905474%
<br />All Inclusive Cost (AIC)
<br />3.7730918%
<br />IRS Form 8038
<br />Net Interest Cost
<br />3.5252946%
<br />Weighted Average Maturity
<br />12.225 Years
<br />Series 2025A GO CIP Bonds I SINGLE PURPOSE
<br />1 8/28/2024 1 2:09 PM
<br />14EHLERS
<br />PUBLIC FINANCE ADVISORS
<br />
|