|
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 />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 />135,939.56
<br />135,939.56
<br />(135,939.56) -
<br />-
<br />02/01/2027
<br />160,000.00
<br />3.500%
<br />191,165.00
<br />351,165.00
<br />351,165.00
<br />368,723.25
<br />02/01/2028
<br />170,000.00
<br />3.500%
<br />185,565.00
<br />355,565.00
<br />355,565.00
<br />373,343.25
<br />02/01/2029
<br />175,000.00
<br />3.500%
<br />179,615.00
<br />354,615.00
<br />354,615.00
<br />372,345.75
<br />02/01/2030
<br />180,000.00
<br />3.500%
<br />173,490.00
<br />353,490.00
<br />353,490.00
<br />371,164.50
<br />02/01/2031
<br />185,000.00
<br />3.500%
<br />167,190.00
<br />352,190.00
<br />352,190.00
<br />369,799.50
<br />02/01/2032
<br />195,000.00
<br />3.550%
<br />160,715.00
<br />355,715.00
<br />355,715.00
<br />373,500.75
<br />02/01/2033
<br />200,000.00
<br />3.550%
<br />153,792.50
<br />353,792.50
<br />353,792.50
<br />371,482.13
<br />02/01/2034
<br />205,000.00
<br />3.650%
<br />146,692.50
<br />351,692.50
<br />351,692.50
<br />369,277.13
<br />02/01/2035
<br />215,000.00
<br />3.700%
<br />139,210.00
<br />354,210.00
<br />354,210.00
<br />371,920.50
<br />02/01/2036
<br />220,000.00
<br />3.800%
<br />131,255.00
<br />351,255.00
<br />351,255.00
<br />368,817.75
<br />02/01/2037
<br />230,000.00
<br />3.900%
<br />122,895.00
<br />352,895.00
<br />352,895.00
<br />370,539.75
<br />02/01/2038
<br />240,000.00
<br />3.950%
<br />113,925.00
<br />353,925.00
<br />353,925.00
<br />371,621.25
<br />02/01/2039
<br />250,000.00
<br />4.050%
<br />104,445.00
<br />354,445.00
<br />354,445.00
<br />372,167.25
<br />02/01/2040
<br />260,000.00
<br />4.150%
<br />94,320.00
<br />354,320.00
<br />354,320.00
<br />372,036.00
<br />02/01/2041
<br />270,000.00
<br />4.350%
<br />83,530.00
<br />353,530.00
<br />353,530.00
<br />371,206.50
<br />02/01/2042
<br />280,000.00
<br />4.500%
<br />71,785.00
<br />351,785.00
<br />351,785.00
<br />369,374.25
<br />02/01/2043
<br />295,000.00
<br />4.600%
<br />59,185.00
<br />354,185.00
<br />354,185.00
<br />371,894.25
<br />02/01/2044
<br />305,000.00
<br />4.700%
<br />45,615.00
<br />350,615.00
<br />350,615.00
<br />368,145.75
<br />02/01/2045
<br />320,000.00
<br />4.750%
<br />31,280.00
<br />351,280.00
<br />351,280.00
<br />368,844.00
<br />02/01/2046
<br />335,000.00
<br />4.800%
<br />16,080.00
<br />351,080.00
<br />351,080.00
<br />368,634.00
<br />Total $4,690,000.00 - $2,507,689.56 $7,197,689.56 (135,939.56) $7,061,750.00 $7,414,837.50
<br />Significant Dates
<br />Dated
<br />First Coupon Date
<br />Yield Statistics
<br />5/15/2025
<br />2/01/2026
<br />Bond Year Dollars $58,465.11
<br />Average Life 12.466 Years
<br />Net Interest Cost (
<br />True Interest Cost
<br />Bond Yield for At
<br />All Inclusive Cost
<br />Series 2025A GO CIP Bonds I SINGLE PURPOSE 1 8/28/2024 1 2:13 PM
<br />4.2892069%
<br />4.3854694%
<br />4.3787402%
<br />4.2481600%
<br />4.5395776%
<br />IQEHLERS
<br />IN PUBLIC FINANCE ADVISORS
<br />
|