|
Mounds View, Minnesota
<br />$6,140,000 General Obligation Water Revenue Bonds, Series 2020A
<br />Assumes Current Market BQ AAA Credit Enhanced Rates plus 25bps
<br />(AA Underlying Rating)
<br />Debt Service Schedule
<br />Date Principal
<br />Coupon
<br />Interest
<br />Total P+I
<br />Fiscal Total
<br />12/30/2020
<br />-
<br />-
<br />08/01/2021 -
<br />-
<br />41,448.31
<br />41,448.31
<br />-
<br />02/01/2022 380,000.00
<br />0.450%
<br />35,358.75
<br />415,358.75
<br />456,807.06
<br />08/01/2022 -
<br />-
<br />34,503.75
<br />34,503.75
<br />-
<br />02/01/2023 390,000.00
<br />0.500%
<br />34,503.75
<br />424,503.75
<br />459,007.50
<br />08/01/2023 -
<br />-
<br />33,528.75
<br />33,528.75
<br />-
<br />02/01/2024 390,000.00
<br />0.550%
<br />33,528.75
<br />423,528.75
<br />457,057.50
<br />08/01/2024 -
<br />-
<br />32,456.25
<br />32,456.25
<br />-
<br />02/01/2025 390,000.00
<br />0.650%
<br />32,456.25
<br />422,456.25
<br />454,912.50
<br />08/01/2025 -
<br />-
<br />31,188.75
<br />31,188.75
<br />-
<br />02/01/2026 395,000.00
<br />0.800%
<br />31,188.75
<br />426,188.75
<br />457,377.50
<br />08/01/2026 -
<br />-
<br />29,608.75
<br />29,608.75
<br />-
<br />02/01/2027 395,000.00
<br />0.950%
<br />29,608.75
<br />424,608.75
<br />454,217.50
<br />08/01/2027 -
<br />-
<br />27,732.50
<br />27,732.50
<br />-
<br />02/01/2028 400,000.00
<br />1.050%
<br />27,732.50
<br />427,732.50
<br />455,465.00
<br />08/01/2028 -
<br />-
<br />25,632.50
<br />25,632.50
<br />-
<br />02/01/2029 405,000.00
<br />1.150%
<br />25,632.50
<br />430,632.50
<br />456,265.00
<br />08/01/2029 -
<br />-
<br />23,303.75
<br />23,303.75
<br />-
<br />02/01/2030 410,000.00
<br />1.250%
<br />23,303.75
<br />433,303.75
<br />456,607.50
<br />08/01/2030 -
<br />-
<br />20,741.25
<br />20,741.25
<br />-
<br />02/01/2031 415,000.00
<br />1.350%
<br />20,741.25
<br />435,741.25
<br />456,482.50
<br />08/01/2031 -
<br />-
<br />17,940.00
<br />17,940.00
<br />-
<br />02/01/2032 420,000.00
<br />1.450%
<br />17,940.00
<br />437,940.00
<br />455,880.00
<br />08/01/2032 -
<br />-
<br />14,895.00
<br />14,895.00
<br />-
<br />02/01/2033 425,000.00
<br />1.550%
<br />14,895.00
<br />439,895.00
<br />454,790.00
<br />08/01/2033 -
<br />-
<br />11,601.25
<br />11,601.25
<br />-
<br />02/01/2034 435,000.00
<br />1.650%
<br />11,601.25
<br />446,601.25
<br />458,202.50
<br />08/01/2034 -
<br />-
<br />8,012.50
<br />8,012.50
<br />-
<br />02/01/2035 440,000.00
<br />1.750%
<br />8,012.50
<br />448,012.50
<br />456,025.00
<br />08/01/2035 -
<br />-
<br />4,162.50
<br />4,162.50
<br />-
<br />02/01/2036 450,000.00
<br />1.850%
<br />4,162.50
<br />454,162.50
<br />458,325.00
<br />Total $6,140,000.00
<br />-
<br />$7079422.06
<br />$698479422.06
<br />-
<br />Yield Statistics
<br />Bond Year Dollars
<br />$50,928.72
<br />Average Life
<br />8.295 Years
<br />Average Coupon
<br />1.3890434%
<br />Net Interest Cost (NIC)
<br />1.5337162%
<br />True Interest Cost (TIC)
<br />1.5359018%
<br />Bond Yield for Arbitrage Purposes
<br />1.3797379%
<br />All Inclusive Cost (AIC)
<br />1.6693439%
<br />IRS Form 8038
<br />Net Interest Cost
<br />1.3890434%
<br />Weighted Average Maturity
<br />8.295 Years
<br />Series 2020A GO Wat Rev B I SINGLE PURPOSE 1 11/ 4/2020 1 8:15 AM
<br />EHLERS
<br />!'V9LIC F�NIA NCE AOVISOPS
<br />Page 7
<br />
|