|
Schedule 2
<br />Indian River County, Florida
<br />Board of County Commissioners
<br />Investment By Maturity Date
<br />March 31, 2018
<br />Restricted Cash - Housing Account $351,910.89
<br />Total Portfolio S 404521,654.46
<br />Note: See separate investment report for OPER funds.
<br />19
<br />2 oft
<br />03131118
<br />Coupon!
<br />Purchase
<br />Maturity
<br />Years To
<br />Yield To
<br />Original
<br />Investment Type CUSIP
<br />Yield
<br />Date
<br />Date
<br />Maturity
<br />Maturity
<br />Par Amount
<br />Book Value
<br />Mo Cash Flow
<br />Treasury Note 9128282K5
<br />1.375%
<br />212/18/17
<br />07/31/19
<br />1.33
<br />1.817%
<br />$
<br />3,000,000.00
<br />$
<br />2,978,906.25
<br />$ 11,000,000.00
<br />FHLMC Bullet 3137EAOK2
<br />1.250%
<br />03/30/17
<br />08/01/19
<br />1.34
<br />1.402%
<br />$
<br />3,000,000.00
<br />S
<br />2,989,560.00
<br />FFCB Bullet 3133EHUK7
<br />1.400%
<br />08/14/17
<br />08/14/19
<br />1,37
<br />1.400%
<br />S
<br />2,00%000.00
<br />$
<br />2,000,000.00
<br />FHLB Callable 3130ASWK0
<br />1.500%
<br />08/22/11
<br />08/22/19
<br />1.39
<br />1.500%
<br />$
<br />2,000,000.00
<br />S
<br />2,000,000.00
<br />FNMA Bullet 3135GOP49
<br />1.000%
<br />05/05/17
<br />08/28119
<br />1.41
<br />1.442%
<br />S
<br />2,000,000.00
<br />S
<br />1,979,946.00
<br />Treasury Note 912828080
<br />1.625%
<br />11/30/17
<br />08/31%19
<br />1.42
<br />1.752%
<br />$
<br />3,000,000.00
<br />$
<br />2,993,437.50
<br />$ 12,000,000.00
<br />FHLMC Callable 3134GA7A6
<br />1.500%
<br />05/11/17
<br />09/09/19
<br />1.44
<br />1.500%
<br />S
<br />2,000,000.00
<br />S
<br />2,000,000.00
<br />FNMA Callable 3135GOPS6
<br />1.250%
<br />11/30/17
<br />09/20/19
<br />1.47
<br />1.842%
<br />5
<br />2,000,000.00
<br />$
<br />1,979,060.00
<br />FHLB Bullet 3130A9EP2
<br />1.D00%
<br />05/10/17
<br />09/26/19
<br />1.49
<br />1.436%
<br />S
<br />2,000,000.00
<br />5
<br />1,979,660.00
<br />FHLB Bullet 313OA9EP2
<br />1.000%
<br />05/11/17
<br />09/26/19
<br />1.49
<br />1.435%
<br />$
<br />2,000,000.00
<br />$
<br />1,979,750.00
<br />$ 8,000,000.00
<br />FHLMC Bullet 3137EADM8
<br />1.25096
<br />05/04/17
<br />10/02/19
<br />1.51
<br />1.451%
<br />$
<br />3,000,000.00
<br />$
<br />2,985,780.00
<br />FFCB Callable 3133EGXK6
<br />1.120%
<br />12/21/17
<br />10/11/19
<br />1.53
<br />1.946%
<br />$
<br />2,000000.00
<br />5
<br />1,970,800.00
<br />FHLB Bullet 3130ASTO89
<br />1.450%
<br />07/18/17
<br />10/18119
<br />1.55
<br />1.450%
<br />$
<br />2,000,000.00
<br />S
<br />2,000,000.00
<br />FNMA Bullet 3135GOR39
<br />1.000%
<br />06/30/17
<br />10124/19
<br />1.57
<br />1.425%
<br />5
<br />2,000,000.00
<br />S
<br />1,980,694.00
<br />Treasury Note 91282SF62
<br />1.500%
<br />12/12/17
<br />10/31119
<br />1.59
<br />1.797%
<br />5
<br />3,000,000.00
<br />$
<br />2,983,560.00
<br />S 12,000,000.00
<br />FFCB Callable 3133EGA62
<br />1.160%
<br />11/30/17
<br />11/01/19
<br />1.59
<br />1.866%
<br />$
<br />2,000,000.00
<br />$
<br />1,973,500.00
<br />FHLB Bullet 3130AA3R7
<br />1.375%
<br />06/30/17
<br />11/15/19
<br />1.63
<br />1.433%
<br />$
<br />2,OOD,000.00
<br />$
<br />1,997,300.00
<br />$ 4,000,000.00
<br />FFCB Callable 3133£G1V8
<br />1.200%
<br />12/08/17
<br />01/06/20
<br />1.77
<br />1.955%
<br />S
<br />2,000,000.00
<br />S
<br />1,969,400.00
<br />Treasury Note 91282SV31
<br />1.375%
<br />12/18/17
<br />01/15/20
<br />1.79
<br />1.845%
<br />S
<br />3,000,000.00
<br />$
<br />2.971,406.25
<br />FNMA Bullet 313SGOA78
<br />1.625%
<br />12108/17
<br />01/21120
<br />1.81
<br />1.862%
<br />$
<br />3,000,000.00
<br />$
<br />Z985,270.00
<br />$ 8,000,000.00
<br />FFCSCaliable 3133EHR70
<br />1.740%
<br />11/14/17
<br />02/14/20
<br />1.88
<br />1.740%
<br />$
<br />2,000,000.00
<br />S
<br />2,000,000.00
<br />FFCB Callable 3133EGAES
<br />1.360%
<br />12/21/17
<br />02/1.8/20
<br />1.89
<br />1.991%
<br />S
<br />3,000,000.00
<br />$
<br />2,960,160.00
<br />FNMA Bullet 3135GOT29
<br />1.500%
<br />10/23/17
<br />02/28/20
<br />1.92
<br />1.688%
<br />S
<br />2,000,000.00
<br />S
<br />1,991,360.00
<br />$ 7,000,000.00
<br />FFCB Callable 3133EHLX2
<br />1.500%
<br />10/23/17
<br />03/05/20
<br />1.93
<br />1.716%
<br />$
<br />2,000,000.00
<br />S
<br />1,990,000.00
<br />Treasury Note 91282BW63
<br />1.625%
<br />12/12/17
<br />03/15/20
<br />1.96
<br />1.845%
<br />$
<br />3,000,000.00
<br />$
<br />2,985,420.00
<br />FHLMC 3134GBES4
<br />1.700%
<br />1V21/17
<br />03/27120
<br />1.99
<br />1.776%
<br />$
<br />2,000,000.00
<br />$
<br />1,996,500.00
<br />$ 7,000,000.00
<br />FFCB Callable 3133EHCSO
<br />1.680%
<br />03/13/18
<br />04/03/20
<br />2.01
<br />2.316%
<br />S
<br />2,000,000.00
<br />$
<br />1,974,600.00
<br />Treasury Note 912828X21
<br />1.50096
<br />12/12/17
<br />04/15120
<br />2.04
<br />1.857%
<br />$
<br />3,000,000.00
<br />$
<br />2,975,580.00
<br />FHLMC Bullet 3137EAEF2
<br />1.375%
<br />11/21/17
<br />04/20/20
<br />2.06
<br />1.858%
<br />5
<br />2,000,000.00
<br />$
<br />1,977,300.00
<br />FHLMC Callable 3134GBM
<br />1.750%
<br />10/30/17
<br />04/30/20
<br />2.08
<br />1.750%
<br />$
<br />2,000,000.00
<br />$
<br />2,000,000.00
<br />$ 9,000,000.00
<br />FHLMCBuIlet 3137EAOR7
<br />1.375%
<br />11/21/17
<br />05/01/20
<br />2.09
<br />1.823%
<br />$
<br />2,000,000.00
<br />$
<br />1,978,660.00
<br />FHLB -1X 313GACN83
<br />1.700%
<br />11/21/17
<br />05/15/20
<br />2.13
<br />1.869%
<br />$
<br />2,000,000.00
<br />$
<br />1,991,800.00
<br />FFCB Callable 3133EHT78
<br />1.830%
<br />12/21/17
<br />05/20/20
<br />2.14
<br />2.013%
<br />5
<br />3,00,000.00
<br />S
<br />2,987,040.00
<br />FNMACaliable 3136454LQ4
<br />1.750%
<br />12/08/17
<br />05118120
<br />2.16
<br />1.875%
<br />S
<br />3,000,000.00
<br />S
<br />2,991,000.00
<br />5 10,000,000.00
<br />FFCB Callable 3133EJEKI
<br />2.450%
<br />03/01/18
<br />06/01/20
<br />2.17
<br />2.450%
<br />$
<br />3,000,000.00
<br />$
<br />3,000,000.00
<br />FHLB Bullet 313383HU8
<br />1.750%
<br />03/23/18
<br />06/12/20
<br />2.20
<br />2.399%
<br />$
<br />2,000,000.00
<br />$
<br />1,972,080.00
<br />FHLBCallabie 3130ABNQS
<br />1.625%
<br />12/08/17
<br />06/26/20
<br />2.24
<br />1.907%
<br />S
<br />2,000,000.00
<br />$
<br />1,986,000.00
<br />FNMACaIlable 3136G3UR4
<br />1.380%
<br />03/23/18
<br />06/30/20
<br />2.25
<br />2.443%
<br />$
<br />3,000,000.00
<br />$
<br />2,929,950.00
<br />S 10,000,0DO.Oo
<br />FHLBCallable 3130ABNV4
<br />1.750%
<br />03/15/18
<br />07J13/20
<br />2.29
<br />2.41996
<br />$
<br />3,000,000.00
<br />S
<br />2,954,790.00
<br />FNMA Bullet 3135GOT60
<br />1.500%
<br />03/15/18
<br />0713C/20
<br />2.33
<br />2.351%
<br />$
<br />3000,000,00
<br />$
<br />Z941,350.00
<br />S 6,000,000.00
<br />FFCBCallable 3133EHUEI
<br />1.6$096
<br />03/19/18
<br />08/10120
<br />2.36
<br />2.372%
<br />S
<br />2,000,000.00
<br />5
<br />1,966,600.00
<br />FHLBCatlable 3130ACTKO
<br />1.875%
<br />03/19/18
<br />08/25/20
<br />2.41
<br />2.379%
<br />$
<br />3,000,000.00
<br />$
<br />2,964,420.00
<br />S 5,000,000.00
<br />FHLBCailabio 3130ADSFO
<br />2.500%
<br />03/29/18
<br />09/29/20
<br />2.50
<br />2.500%
<br />S
<br />3,000.000.00
<br />S
<br />3,000,000.00
<br />$ 3,000,000.00
<br />Sub Total- General Imestments
<br />S
<br />284,000,000.00
<br />S
<br />282,618,636.01
<br />$ 254,000,000.00
<br />Regions Bank Money Market
<br />$16,506,274.84
<br />Regions Lockbox Accounts
<br />$5,832,955.15
<br />TO Bank Checking Account
<br />$16,228,985.91
<br />Wells Fargo Bank Checking Account
<br />5427,768.02
<br />BankUnited Money Market
<br />$34,769,132.03
<br />National Bank of Commerce CO
<br />0.850%
<br />05/11/17
<br />05/11/18
<br />0.11
<br />$6,118,190.09
<br />Ooulina Bank CO
<br />0.880%
<br />04/23/16
<br />04/26/18
<br />0.07
<br />$2,033,978.27
<br />Valley National Bank Government Interest Checking
<br />$15,096,169.73
<br />Marine Bank Business Money Market
<br />$5,017,66782
<br />Total General Cash & Equivalents - Unrestricted
<br />$
<br />384,649,757.87
<br />Restricted Cash -Bond Covenants /held by 8NY1Mellonl
<br />Fidelity Institutional Treasury Money Market -Utilities Debt Service Reserve
<br />$
<br />41,690.36
<br />Treasury Note 91282SR93
<br />0.625%
<br />06/30/16
<br />06730/18
<br />0.25
<br />0.745%
<br />51,480,000.00
<br />$1,475,693.20
<br />Treasury Note 91282SU40
<br />1.000%
<br />11/30/16
<br />11/30/18
<br />0.67
<br />1.085%
<br />$1,030,000.00
<br />$1,023,078.40
<br />Treasury Note 912828XV77
<br />1,250%
<br />06/30/17
<br />06/30/19
<br />1.25
<br />1.345%
<br />S1,610,000.00
<br />$1.591.388.40
<br />Total Restricted Bond Reserve - adjusted for fair market value
<br />54,131,850.36
<br />Restricted Cash - Landfill
<br />FACC-Florida Loral Govt Investment Trust -Landfill Closure 8 Postclosure Reserves - adjusted
<br />for fair mkt value
<br />S
<br />13,575,836.73
<br />Total Pooled Cash 3 Equivalents
<br />S
<br />402,357,444.96
<br />Restricted Cash - Health Insurance
<br />TO Bank - BCBS Claims Account
<br />51,729,298.61
<br />Citibank - BCBS Imprest Acct
<br />$84,000,00
<br />Total Restricted Cash - Health Insurance
<br />$1,812,298.61
<br />Restricted Cash - Housing Account $351,910.89
<br />Total Portfolio S 404521,654.46
<br />Note: See separate investment report for OPER funds.
<br />19
<br />2 oft
<br />
|