|
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 />Debt Service Schedule
<br />105% of
<br />Date
<br />Principal
<br />Coupon
<br />Interest
<br />Total P+I
<br />CIF Net New D/S
<br />Total
<br />02/01/2026
<br />-
<br />-
<br />125,793.78
<br />125,793.78
<br />(125,793.78) -
<br />-
<br />02/01/2027
<br />240,000.00
<br />3.500%
<br />176,897.50
<br />416,897.50
<br />416,897.50
<br />437,742.38
<br />02/01/2028
<br />250,000.00
<br />3.500%
<br />168,497.50
<br />418,497.50
<br />418,497.50
<br />439,422.38
<br />02/01/2029
<br />260,000.00
<br />3.500%
<br />159,747.50
<br />419,747.50
<br />419,747.50
<br />440,734.88
<br />02/01/2030
<br />265,000.00
<br />3.500%
<br />150,647.50
<br />415,647.50
<br />415,647.50
<br />436,429.88
<br />02/01/2031
<br />275,000.00
<br />3.500%
<br />141,372.50
<br />416,372.50
<br />416,372.50
<br />437,191.13
<br />02/01/2032
<br />285,000.00
<br />3.550%
<br />131,747.50
<br />416,747.50
<br />416,747.50
<br />437,584.88
<br />02/01/2033
<br />295,000.00
<br />3.550%
<br />121,630.00
<br />416,630.00
<br />416,630.00
<br />437,461.50
<br />02/01/2034
<br />305,000.00
<br />3.650%
<br />111,157.50
<br />416,157.50
<br />416,157.50
<br />436,965.38
<br />02/01/2035
<br />320,000.00
<br />3.700%
<br />100,025.00
<br />420,025.00
<br />420,025.00
<br />441,026.25
<br />02/01/2036
<br />330,000.00
<br />3.800%
<br />88,185.00
<br />418,185.00
<br />418,185.00
<br />439,094.25
<br />02/01/2037
<br />340,000.00
<br />3.900%
<br />75,645.00
<br />415,645.00
<br />415,645.00
<br />436,427.25
<br />02/01/2038
<br />355,000.00
<br />3.950%
<br />62,385.00
<br />417,385.00
<br />417,385.00
<br />438,254.25
<br />02/01/2039
<br />370,000.00
<br />4.050%
<br />48,362.50
<br />418,362.50
<br />418,362.50
<br />439,280.63
<br />02/01/2040
<br />385,000.00
<br />4.150%
<br />33,377.50
<br />418,377.50
<br />418,377.50
<br />439,296.38
<br />02/01/2041
<br />400,000.00
<br />4.350%
<br />17,400.00
<br />417,400.00
<br />417,400.00
<br />438,270.00
<br />Total
<br />$4,675,000.00
<br />-
<br />$1,712,871.28
<br />$6,387,871.28
<br />(125,793.78) $6,262,077.50
<br />$6,575,181.38
<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 />$43,874.44
<br />Average Life
<br />9.385 Years
<br />Average Coupon
<br />3.9040296%
<br />Net Interest Cost (NlC) 4.0318944%
<br />True Interest Cost (TIC) 4.0447484%
<br />Bond Yield for Arbitrage Purposes 3.8852561%
<br />All Inclusive Cost (AIC) 4.2417281%
<br />Series 2025A GO CIP Bonds I SINGLE PURPOSE 1 8/28/2024 1 2:13 PM
<br />i4'EHLERS
<br />IN PUBLIC FINANCE ADVISORS
<br />
|