|
City of Elk River, Minnesota
<br /> $9,685,000 G.O. Refunding Bonds, Series 2013A
<br /> Crossover Refunding of
<br /> $10,000,000 G.O. Bonds, Series 2007
<br /> Crossover Escrow Fund Cashflow
<br /> Date Net P+I -Transfers Receipts Disbursements Cash Balance
<br /> 02/12/2013 - - - - -
<br /> 07/30/2013 0.75 - 0.75 - 0.75
<br /> 07/31/2013 105,923.88 - 105,923.88 - 105,924.63
<br /> 08/01/2013 - - - 105,924.27 0.36
<br /> 01/30/2014 2,667.75 - 2,667.75 - 2,668.11
<br /> 01/31/2014 2,460.00 - 2,460.00 - 5,128.11
<br /> 02/01/2014 107,691.00 - 107,691.00 112,818.75 0.36
<br /> 07/30/2014 55,157.75 - 55,157.75 - 55,158.11
<br /> 07/31/2014 2,460.00 - 2,460.00 - 57,618.11
<br /> 08/01/2014 55,201.00 - 55,201.00 112,818.75 0.36
<br /> 01/30/2015 57,868.75 - 57,868.75 - 57,869.11
<br /> 01/31/2015 106,460.00 - 106,460.00 - 164,329.11
<br /> 02/01/2015 2,711.00 - 2,711.00 112,818.75 54,221.36
<br /> 02/02/2015 (54,221.00) - (54,221.00) - 0.36
<br /> 07/30/2015 57 868.75 - 57 868.75 - 57 869.11
<br /> 07/31/2015 1,290.00 - 1,290.00 - 59,159.11
<br /> 08/01/2015 54,221.00 - 54,221.00 112,818.75 561.36
<br /> 01/30/2016 57,868.75 - 57,868.75 - 58,430.11
<br /> 01/31/2016 130,290.00 - 130,290.00 - 188,720.11
<br /> 02/01/2016 (75,901.00) - (75,901.00) 112,818.75 0.36
<br /> 07/30/2016 57,868.75 - 57,868.75 - 57,869.11
<br /> 08/01/2016 54,950.00 - 54,950.00 112,818.75 0.36
<br /> 01/30/2017 9,316,868.75 - 9,316,868.75 - 9,316,869.11
<br /> 02/01/2017 20,951.00 (1.36) 20,951.00 9,337,818.75 -
<br /> Total $10,120,656.88 (1.36) $10,120,656.88 $10,120,655.52 -
<br /> Investment Parameters
<br /> Investment Model[PV,GIC,or Securities' Securities
<br /> Default investment yield target Bond Yield
<br /> Cost of Investments Purchased with Bond Proceeds 9,871,525.68
<br /> Total Cost of Investments $9,871,525.68
<br /> Target Cost of Investments at bond yield $9,401,494.08
<br /> Actual sositive or ne•ative arbitra_e (470,031.60)
<br /> Yield to Receipt 0.6549193%
<br /> Yield for Arbitrage Purposes 1.9428772%
<br /> Series 2013 Xovr Ref Ser I SINGLE PURPOSE I 1/15/2013 I 12:50 PM
<br /> EHLERS
<br /> LENDERS IN PUBLIC FINANCE Page 7
<br />
|