|
City of Ramsey, Minnesota
<br />$7,645,000 General Obligation CIP Bonds, Series 2010
<br />Assumes Current Market BO AA+ Rates plus 50bps
<br />Wrap Around 2012A Bonds - $7.6M Cash
<br />Debt Service Schedule
<br />Date Principal coupon Interest Total P+I Fiscal Total
<br />] 211512019 -
<br />0611512020 - 15,0,203.75 150,203.75
<br />12/1512020 - 150,203.75 150,203.75 300.407,50
<br />06115/2021 150,203,75 150,203.75
<br />12/1512021 150,203.75 150,203.75 300,407.50
<br />0611+2022 - - 150,203.75 150,203,75
<br />12115/2022 1.50,203.75 , 150,203.75 300,407.50
<br />06/ I5/2023 150,203.75 150,203.75
<br />12115/2023 150,203,75 150,203.75 300,40750
<br />06/11.'2024 - 150,203,75 150.243,75
<br />12/192024 - 150,203.75 150,243.75 300.407.50
<br />06/15/2025 150,203.75 150,203.75
<br />12/192025 150,203.75 150,203.75 300,407.50
<br />06115/2026 150.203.75 150 203,75
<br />12115/2026 150,203.75 150,203.75 300,407.50
<br />06+192027 150,203.75 150, 03.75
<br />12115/2027 154,203,75 150,203.75 300,407.50
<br />06/15/2028 154.203.75 150,203,75
<br />12/151/2028 - 150,203.75 150,203.75 300,407.50
<br />06115/2029 150,203.75 150 03.75
<br />12115/2029 150,203.75 150,203.75 300,407.50
<br />06/15/2030 150,203.75 150,203.75
<br />12115/2030 /50,203.75 150203.75 300,407.50
<br />O W-15/2031 150,203.75 150,203.75 -
<br />1211512031 150,203.75 150,203.75 340,407..50
<br />0611512032 150,203,75 150,203.75
<br />12/15/2032 835,060.00 3.700% 150,203.75 985,203,75 1,135,40750
<br />06115/2033 - 134,756.25 134,756,25 -
<br />12115/2033 865,060.00 3.800% 134,756.25 999,756.25 1,134,512.54
<br />061192034 31I,221.7,5 118,321.25 . -
<br />17)1512034 900,000.00 3.854% 118,321,23 1018,12125 1,1304250
<br />06/1512035 100,996.25 100,996.25
<br />12/1512035 935,000.00 3.900% 100,996.25 1035,99625 1,136,492,.50
<br />06115/2016 - 82,763.75 82,763.75
<br />1211512036 970,000,00 3,95E% 82,763,75 1,052,76175 1,135,527.50
<br />0611512037 - - 63,606.25 63,606 25 -
<br />1211512037 1,005,000.00 4.00(I% 63,606.25 1,068,606.25 1,132 212.50
<br />06/15003R - 43,506,23 43,506.25 -
<br />12/1512038 1,045,000.00 4 05(1% 43,506,23 1,013R,506 25 1,132,012.50
<br />05)1512039 - 22,345.00 2,2,345.00 -
<br />1211512039 1,090,000,00 4.100% 22,345.00 1,112,345.00 1,134,690.00
<br />Total S7,645,000.00 S6,037,817.50 512,602,887.50
<br />Yield Statistics
<br />Bond Year Do/ karR
<br />Average Life,
<br />Average Coupon
<br />Net Inlror Cost (NC)
<br />True 1.nturesl Csasl (TIC)
<br />Bond Yield For Arbil rage Purposes
<br />All tut usdve Cost (Ale)
<br />1RS Form 00313
<br />$127,660.00
<br />16.698 Years
<br />3,9463321%1
<br />4.0062177%
<br />4.0247059%
<br />3.9416012%
<br />4.0962009%
<br />Net Interest Cost
<br />W elglled, Average Maturity
<br />201E1GOCIP 4vrdt-#7,5M I SmicA.EPURPO$g 111i7/2091 11:$0Au
<br />3.9453 #21 %
<br />16.69& Years
<br />4151 EHLERS
<br />LENDERS IN RUHLIG FIr(1 HC
<br />
|