|
City of Ramsey, Minnesota
<br />$875,000 General Obligation Bonds, Series 2014A
<br />Assumes Current Market BQ AA+ Rates plus 25bps
<br />Dec 15th Principal Payments
<br />Proof Of Bond Yield @ 2.0106491%
<br />Date
<br />11/15/2014
<br />06/15/2015
<br />12/15/2015
<br />06/15/2016
<br />12/15/2016
<br />06/15/2017
<br />12/15/2017
<br />06/15/2018
<br />12/15/2018
<br />06/15/2019
<br />12/15/2019
<br />06/15/2020
<br />12/15/2020
<br />06/15/2021
<br />12/15/2021
<br />06/15/2022
<br />12/15/2022
<br />06/15/2023
<br />12/15/2023
<br />06/15/2024
<br />12/15/2024
<br />Total
<br />Cashflow
<br />8,701.88
<br />87,458.75
<br />7,198.75
<br />92,198.75
<br />6,837.50
<br />91,837.50
<br />6,370.00
<br />91,370.00
<br />5,796.25
<br />90,796.25
<br />5,116.25
<br />90,116.25
<br />4,308.75
<br />94,308.75
<br />3,363.75
<br />93,363.75
<br />2,351.25
<br />97,351.25
<br />1,235.00
<br />96,235.00
<br />$976,315.63
<br />Derivation Of Target Amount
<br />Par Amount of Bonds
<br />Original Issue Proceeds
<br />2014 GO Bonds - PreSale R I Equipment Portion 111/ 5/2014 1 12:30 PM
<br />Present Cumulative
<br />PV Factor Value PV
<br />1.0000000x
<br />0.9883976x 8,600.92 8,600.92
<br />0.9785599x 85,583.63 94,184.54
<br />0.9688201x 6,974.29 101,158.84
<br />0.9591773x 88,434.95 189,593.78
<br />0.9496304x 6,493.10 196,086.88
<br />0.9401786x 86,343.65 282,430.53
<br />0.9308208x 5,929.33 288,359.86
<br />0.9215562x 84,202.59 372,562.45
<br />0.9123837x 5,288.40 377,850.85
<br />0.9033026x 82,016.49 459,867.34
<br />0.8943119x 4,575.52 464,442.86
<br />0.8854106x 79,789.89 544,232.75
<br />0.8765980x 3,777.04 548,009.79
<br />0.8678730x 81,848.02 629,857.81
<br />0.8592349x 2,890.25 632,748.06
<br />0.8506828x 79,422.94 712,171.00
<br />0.8422158x 1,980.26 714,151.26
<br />0.8338331x 81,174.69 795,325.95
<br />0.8255338x 1,019.53 796,345.49
<br />0.8173171x 78,654.51 875,000.00
<br />$875,000.00
<br />$875,000.00
<br />$875,000.00
<br />lelLEADERS IN PUBLIC FINANCE
<br />EHLERS
<br />
|