|
City of Arden Hills, Minnesota
<br />$4,650,000 General Obligation CIP Bonds, Series 2025
<br />Assumes Current Market BQ AAA Rates
<br />15 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 />100,039.11
<br />100,039.11
<br />(100,039.11) -
<br />08/01/2026
<br />70,340.00
<br />70,340.00
<br />70,340.00
<br />-
<br />02/01/2027
<br />255,000.00
<br />2.750%
<br />70,340.00
<br />325,340.00
<br />325,340.00
<br />395,680.00
<br />08/01/2027
<br />-
<br />-
<br />66,833.75
<br />66,833.75
<br />66,833.75
<br />-
<br />02/01/2028
<br />260,000.00
<br />2.750%
<br />66,833.75
<br />326,833.75
<br />326,833.75
<br />393,667.50
<br />08/01/2028
<br />-
<br />-
<br />63,258.75
<br />63,258.75
<br />63,258.75
<br />-
<br />02/01/2029
<br />265,000.00
<br />2.750%
<br />63,258.75
<br />328,258.75
<br />328,258.75
<br />391,517.50
<br />08/01/2029
<br />-
<br />-
<br />59,615.00
<br />59,615.00
<br />59,615.00
<br />-
<br />02/01/2030
<br />275,000.00
<br />2.750%
<br />59,615.00
<br />334,615.00
<br />334,615.00
<br />394,230.00
<br />08/01/2030
<br />-
<br />-
<br />55,833.75
<br />55,833.75
<br />55,833.75
<br />-
<br />02/01/2031
<br />280,000.00
<br />2.750%
<br />55,833.75
<br />335,833.75
<br />335,833.75
<br />391,667.50
<br />08/01/2031
<br />-
<br />-
<br />51,983.75
<br />51,983.75
<br />51,983.75
<br />-
<br />02/01/2032
<br />290,000.00
<br />2.800%
<br />51,983.75
<br />341,983.75
<br />341,983.75
<br />393,967.50
<br />08/01/2032
<br />-
<br />-
<br />47,923.75
<br />47,923.75
<br />47,923.75
<br />-
<br />02/01/2033
<br />300,000.00
<br />2.800%
<br />47,923.75
<br />347,923.75
<br />347,923.75
<br />395,847.50
<br />08/01/2033
<br />-
<br />-
<br />43,723.75
<br />43,723.75
<br />43,723.75
<br />-
<br />02/01/2034
<br />305,000.00
<br />2.900%
<br />43,723.75
<br />348,723.75
<br />348,723.75
<br />392,447.50
<br />08/01/2034
<br />-
<br />-
<br />39,301.25
<br />39,301.25
<br />39,301.25
<br />-
<br />02/01/2035
<br />315,000.00
<br />2.950%
<br />39,301.25
<br />354,301.25
<br />354,301.25
<br />393,602.50
<br />08/01/2035
<br />-
<br />-
<br />34,655.00
<br />34,655.00
<br />34,655.00
<br />-
<br />02/01/2036
<br />325,000.00
<br />3.050%
<br />34,655.00
<br />359,655.00
<br />359,655.00
<br />394,310.00
<br />08/01/2036
<br />-
<br />-
<br />29,698.75
<br />29,698.75
<br />29,698.75
<br />-
<br />02/01/2037
<br />335,000.00
<br />3.150%
<br />29,698.75
<br />364,698.75
<br />364,698.75
<br />394,397.50
<br />08/01/2037
<br />-
<br />-
<br />24,422.50
<br />24,422.50
<br />24,422.50
<br />-
<br />02/01/2038
<br />345,000.00
<br />3.200%
<br />24,422.50
<br />369,422.50
<br />369,422.50
<br />393,845.00
<br />08/01/2038
<br />-
<br />-
<br />18,902.50
<br />18,902.50
<br />18,902.50
<br />-
<br />02/01/2039
<br />355,000.00
<br />3.300%
<br />18,902.50
<br />373,902.50
<br />373,902.50
<br />392,805.00
<br />08/01/2039
<br />-
<br />-
<br />13,045.00
<br />13,045.00
<br />13,045.00
<br />-
<br />02/01/2040
<br />365,000.00
<br />3.400%
<br />13,045.00
<br />378,045.00
<br />378,045.00
<br />391,090.00
<br />08/01/2040
<br />-
<br />-
<br />6,840.00
<br />6,840.00
<br />6,840.00
<br />-
<br />02/01/2041
<br />380,000.00
<br />3.600%
<br />6,840.00
<br />386,840.00
<br />386,840.00
<br />393,680.00
<br />Total $4,650,000.00 - $1,3529794.11
<br />Significant Dates
<br />Dated
<br />First Coupon Date
<br />Yield Statistics
<br />Bond Year Dollars
<br />Average Life
<br />Average Coupon
<br />Net Interest Cost (NIC)
<br />True Interest Cost (TIC)
<br />Bond Yield for Arbitrage Purposes
<br />All Inclusive Cost (AIC)
<br />IRS Form 8038
<br />Net Interest Cost
<br />Weighted Average Maturity
<br />Series 2025A GO CIP Bonds I SINGLE PURPOSE 1 8/28/2024 1 2:10 PM
<br />g'ZEHLERS
<br />PUBLIC FINANCE ADVISORS
<br />$6,002,794.11 (100,039.11) $5,902,755.00 -
<br />5/15/2025
<br />2/01/2026
<br />$42,991.67
<br />9.246 Years
<br />3.1466426%
<br />3.2764352%
<br />3.2867024%
<br />3.1314377%
<br />3.4794575%
<br />3.1466426%
<br />9.246 Years
<br />
|