|
City of Arden Hills, Minnesota
<br />$4,675,000 General Obligation CIP Bonds, Series 2025
<br />Assumes Current Market BQ AAA Rates plus 75bps
<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 />125,793.78
<br />125,793.78
<br />(125,793.78) -
<br />08/01/2026
<br />88,448.75
<br />88,448.75
<br />88,448.75
<br />-
<br />02/01/2027
<br />240,000.00
<br />3.500%
<br />88,448.75
<br />328,448.75
<br />328,448.75
<br />416,897.50
<br />08/01/2027
<br />-
<br />-
<br />84,248.75
<br />84,248.75
<br />84,248.75
<br />-
<br />02/01/2028
<br />250,000.00
<br />3.500%
<br />84,248.75
<br />334,248.75
<br />334,248.75
<br />418,497.50
<br />08/01/2028
<br />-
<br />-
<br />79,873.75
<br />79,873.75
<br />79,873.75
<br />-
<br />02/01/2029
<br />260,000.00
<br />3.500%
<br />79,873.75
<br />339,873.75
<br />339,873.75
<br />419,747.50
<br />08/01/2029
<br />-
<br />-
<br />75,323.75
<br />75,323.75
<br />75,323.75
<br />-
<br />02/01/2030
<br />265,000.00
<br />3.500%
<br />75,323.75
<br />340,323.75
<br />340,323.75
<br />415,647.50
<br />08/01/2030
<br />-
<br />-
<br />70,686.25
<br />70,686.25
<br />70,686.25
<br />-
<br />02/01/2031
<br />275,000.00
<br />3.500%
<br />70,686.25
<br />345,686.25
<br />345,686.25
<br />416,372.50
<br />08/01/2031
<br />-
<br />-
<br />65,873.75
<br />65,873.75
<br />65,873.75
<br />-
<br />02/01/2032
<br />285,000.00
<br />3.550%
<br />65,873.75
<br />350,873.75
<br />350,873.75
<br />416,747.50
<br />08/01/2032
<br />-
<br />-
<br />60,815.00
<br />60,815.00
<br />60,815.00
<br />-
<br />02/01/2033
<br />295,000.00
<br />3.550%
<br />60,815.00
<br />355,815.00
<br />355,815.00
<br />416,630.00
<br />08/01/2033
<br />-
<br />-
<br />55,578.75
<br />55,578.75
<br />55,578.75
<br />-
<br />02/01/2034
<br />305,000.00
<br />3.650%
<br />55,578.75
<br />360,578.75
<br />360,578.75
<br />416,157.50
<br />08/01/2034
<br />-
<br />-
<br />50,012.50
<br />50,012.50
<br />50,012.50
<br />-
<br />02/01/2035
<br />320,000.00
<br />3.700%
<br />50,012.50
<br />370,012.50
<br />370,012.50
<br />420,025.00
<br />08/01/2035
<br />-
<br />-
<br />44,092.50
<br />44,092.50
<br />44,092.50
<br />-
<br />02/01/2036
<br />330,000.00
<br />3.800%
<br />44,092.50
<br />374,092.50
<br />374,092.50
<br />418,185.00
<br />08/01/2036
<br />-
<br />-
<br />37,822.50
<br />37,822.50
<br />37,822.50
<br />-
<br />02/01/2037
<br />340,000.00
<br />3.900%
<br />37,822.50
<br />377,822.50
<br />377,822.50
<br />415,645.00
<br />08/01/2037
<br />-
<br />-
<br />31,192.50
<br />31,192.50
<br />31,192.50
<br />-
<br />02/01/2038
<br />355,000.00
<br />3.950%
<br />31,192.50
<br />386,192.50
<br />386,192.50
<br />417,385.00
<br />08/01/2038
<br />-
<br />-
<br />24,181.25
<br />24,181.25
<br />24,181.25
<br />-
<br />02/01/2039
<br />370,000.00
<br />4.050%
<br />24,181.25
<br />394,181.25
<br />394,181.25
<br />418,362.50
<br />08/01/2039
<br />-
<br />-
<br />16,688.75
<br />16,688.75
<br />16,688.75
<br />-
<br />02/01/2040
<br />385,000.00
<br />4.150%
<br />16,688.75
<br />401,688.75
<br />401,688.75
<br />418,377.50
<br />08/01/2040
<br />-
<br />-
<br />8,700.00
<br />8,700.00
<br />8,700.00
<br />-
<br />02/01/2041
<br />400,000.00
<br />4.350%
<br />8,700.00
<br />408,700.00
<br />408,700.00
<br />417,400.00
<br />Total $4,675,000.00 - $1,712,871.28 $6,387,871.28 (125,793.78) $6,262,077.50 -
<br />Significant Dates
<br />Dated 5/15/2025
<br />First Coupon Date 2/01/2026
<br />Yield Statistics
<br />Bond Year Dollars $43,874.44
<br />Average Life 9.385 Years
<br />Average Coupon 3.9040296%
<br />Net Interest Cost (NIC)
<br />4.0318944%
<br />True Interest Cost (TIC)
<br />4.0447484%
<br />Bond Yield for Arbitrage Purposes
<br />3.8852561 %
<br />All Inclusive Cost (AIC)
<br />4.2417281%
<br />IRS Form 8038
<br />Net Interest Cost
<br />3.9040296%
<br />Weighted Average Maturity
<br />9.385 Years
<br />Series 2025A GO CIP Bonds I SINGLE PURPOSE 1 8/28/2024 1 2:13 PM
<br />rg'ZEHLERS
<br />PUBLIC FINANCE ADVISORS
<br />
|