|
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 />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 />109,582.22
<br />109,582.22
<br />(109,582.22) -
<br />-
<br />02/01/2027
<br />175,000.00
<br />2.750%
<br />154,100.00
<br />329,100.00
<br />329,100.00
<br />345,555.00
<br />02/01/2028
<br />180,000.00
<br />2.750%
<br />149,287.50
<br />329,287.50
<br />329,287.50
<br />345,751.88
<br />02/01/2029
<br />185,000.00
<br />2.750%
<br />144,337.50
<br />329,337.50
<br />329,337.50
<br />345,804.38
<br />02/01/2030
<br />190,000.00
<br />2.750%
<br />139,250.00
<br />329,250.00
<br />329,250.00
<br />345,712.50
<br />02/01/2031
<br />195,000.00
<br />2.750%
<br />134,025.00
<br />329,025.00
<br />329,025.00
<br />345,476.25
<br />02/01/2032
<br />200,000.00
<br />2.800%
<br />128,662.50
<br />328,662.50
<br />328,662.50
<br />345,095.63
<br />02/01/2033
<br />205,000.00
<br />2.800%
<br />123,062.50
<br />328,062.50
<br />328,062.50
<br />344,465.63
<br />02/01/2034
<br />210,000.00
<br />2.900%
<br />117,322.50
<br />327,322.50
<br />327,322.50
<br />343,688.63
<br />02/01/2035
<br />215,000.00
<br />2.950%
<br />111,232.50
<br />326,232.50
<br />326,232.50
<br />342,544.13
<br />02/01/2036
<br />225,000.00
<br />3.050%
<br />104,890.00
<br />329,890.00
<br />329,890.00
<br />346,384.50
<br />02/01/2037
<br />230,000.00
<br />3.150%
<br />98,027.50
<br />328,027.50
<br />328,027.50
<br />344,428.88
<br />02/01/2038
<br />235,000.00
<br />3.200%
<br />90,782.50
<br />325,782.50
<br />325,782.50
<br />342,071.63
<br />02/01/2039
<br />245,000.00
<br />3.300%
<br />83,262.50
<br />328,262.50
<br />328,262.50
<br />344,675.63
<br />02/01/2040
<br />250,000.00
<br />3.400%
<br />75,177.50
<br />325,177.50
<br />325,177.50
<br />341,436.38
<br />02/01/2041
<br />260,000.00
<br />3.600%
<br />66,677.50
<br />326,677.50
<br />326,677.50
<br />343,011.38
<br />02/01/2042
<br />270,000.00
<br />3.750%
<br />57,317.50
<br />327,317.50
<br />327,317.50
<br />343,683.38
<br />02/01/2043
<br />280,000.00
<br />3.850%
<br />47,192.50
<br />327,192.50
<br />327,192.50
<br />343,552.13
<br />02/01/2044
<br />290,000.00
<br />3.950%
<br />36,412.50
<br />326,412.50
<br />326,412.50
<br />342,733.13
<br />02/01/2045
<br />305,000.00
<br />4.000%
<br />24,957.50
<br />329,957.50
<br />329,957.50
<br />346,455.38
<br />02/01/2046
<br />315,000.00
<br />4.050%
<br />12,757.50
<br />327,757.50
<br />327,757.50
<br />344,145.38
<br />Total $4,660,000.00 - $2,008,317.22 $6,668,317.22 (109,582.22) $6,558,735.00 $6,886,671.75
<br />Significant Dates
<br />Dated
<br />First Coupon Date
<br />Yield Statistics
<br />5/15/2025
<br />2/01/2026
<br />Bond Year Dollars $56,968.78
<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 />Series 2025A GO CIP Bonds I SINGLE PURPOSE 1 8/28/2024 1 2:09 PM
<br />12.225 Years
<br />3.5252946%
<br />3.6234536%
<br />3.6167188%
<br />3.4905474%
<br />3.7730918%
<br />1;4'EHLERS
<br />IN PUBLIC FINANCE ADVISORS
<br />
|