|
<br />
<br />City of St Anthony, Minnesota
<br />$3,100,000 General Obligation Bonds, Series 2021A
<br />Issue Summary - New Money & Current Ref 2013B
<br />Assumes Current Market BQ AA Rates plus 20bps
<br />Proof of Bond Yield @ 1.0136593%
<br />Date Cashflow PV Factor Present Value
<br />Cumulative
<br />PV
<br />05/18/2021 -1.0000000x --
<br />02/01/2022 137,539.58 0.9929194x 136,565.72 136,565.72
<br />08/01/2022 12,268.75 0.9879124x 12,120.45 148,686.17
<br />02/01/2023 297,268.75 0.9829306x 292,194.55 440,880.72
<br />08/01/2023 11,698.75 0.9779739x 11,441.07 452,321.79
<br />02/01/2024 301,698.75 0.9730423x 293,565.63 745,887.42
<br />08/01/2024 11,046.25 0.9681355x 10,694.27 756,581.69
<br />02/01/2025 291,046.25 0.9632534x 280,351.29 1,036,932.98
<br />08/01/2025 10,346.25 0.9583960x 9,915.80 1,046,848.79
<br />02/01/2026 290,346.25 0.9535630x 276,863.45 1,323,712.24
<br />08/01/2026 9,576.25 0.9487545x 9,085.51 1,332,797.75
<br />02/01/2027 289,576.25 0.9439701x 273,351.34 1,606,149.08
<br />08/01/2027 8,666.25 0.9392100x 8,139.43 1,614,288.51
<br />02/01/2028 288,666.25 0.9344738x 269,751.04 1,884,039.55
<br />08/01/2028 7,616.25 0.9297615x 7,081.30 1,891,120.84
<br />02/01/2029 292,616.25 0.9250729x 270,691.37 2,161,812.21
<br />08/01/2029 6,333.75 0.9204080x 5,829.63 2,167,641.85
<br />02/01/2030 176,333.75 0.9157666x 161,480.57 2,329,122.41
<br />08/01/2030 5,483.75 0.9111487x 4,996.51 2,334,118.92
<br />02/01/2031 175,483.75 0.9065540x 159,085.49 2,493,204.41
<br />08/01/2031 4,548.75 0.9019825x 4,102.89 2,497,307.31
<br />02/01/2032 179,548.75 0.8974340x 161,133.15 2,658,440.46
<br />08/01/2032 3,498.75 0.8929085x 3,124.06 2,661,564.52
<br />02/01/2033 98,498.75 0.8884058x 87,506.86 2,749,071.38
<br />08/01/2033 2,905.00 0.8839258x 2,567.80 2,751,639.19
<br />02/01/2034 97,905.00 0.8794684x 86,104.35 2,837,743.54
<br />08/01/2034 2,263.75 0.8750334x 1,980.86 2,839,724.39
<br />02/01/2035 97,263.75 0.8706209x 84,679.85 2,924,404.25
<br />08/01/2035 1,575.00 0.8662306x 1,364.31 2,925,768.56
<br />02/01/2036 101,575.00 0.8618624x 87,543.67 3,013,312.23
<br />08/01/2036 800.00 0.8575162x 686.01 3,013,998.24
<br />02/01/2037 100,800.00 0.8531920x 86,001.76 3,100,000.00
<br />Total $3,314,794.58 -$3,100,000.00 -
<br />Derivation Of Target Amount
<br />
<br />Par Amount of Bonds $3,100,000.00
<br />
<br />Original Issue Proceeds $3,100,000.00
<br />Series 2021A GO Bds CR 13 | Issue Summary | 2/19/2021 | 12:38 PM
<br />
<br />
|