|
Schedule 2
<br />Indian River County, Florida
<br />Board of County Commissioners
<br />Investment By Maturity Date
<br />June 30,2018
<br />Restricted Cash - Housing Account S351,910.89
<br />Total Portfolio S 389,495,532.75
<br />Note: See separate Investment report for OPER funds,
<br />60
<br />201-2
<br />06/30/18
<br />Coupon/
<br />Purchase
<br />Maturity
<br />Years To
<br />Yield To
<br />Original
<br />Investment Type CUSIP
<br />Yield
<br />Date
<br />Dale
<br />Maturity
<br />Maturity
<br />Par Amount
<br />. Book Value
<br />Mo Cash Flow
<br />FHLMC Bullet 3137EADM8
<br />1.250%
<br />05/04/17
<br />10/02/19
<br />1.26
<br />1.451%
<br />5 3,000,000.00
<br />5 2,985,780.00
<br />FFCBCailable 3133EGXK6
<br />1.120%
<br />12/21/17
<br />10/11/19
<br />1.28
<br />1.946%
<br />S 2,000,000.00
<br />$ 1.970,800.00
<br />FHLB Bullet 3130ABT089
<br />1.450%
<br />07/18/17
<br />lo/la/19
<br />1.30
<br />1450%
<br />S 2.000,000.00
<br />S 2,000,000.00
<br />FNMA Bullet 3135GOR39
<br />1.000%
<br />06/30/17
<br />10/24/19
<br />132
<br />1.425%
<br />S 2,000,000.00
<br />5 1.980,694.00
<br />Treasury Note 912828F62
<br />1.500%
<br />12/12/17
<br />10/31/19
<br />1.14
<br />1.797%
<br />$ 3,000,000.00
<br />S 2,983.560.00
<br />S 12,000,000.00
<br />FFCB Callable 3133EGA62
<br />1164%
<br />:11/30/17
<br />11/01!19
<br />1,34
<br />1.866%
<br />5 2,000,000.00
<br />S 1,973,500.00
<br />FHLB Bullet 3130AA3R7
<br />1.375%
<br />06/30/17
<br />11/15/19
<br />1.38
<br />1.433%
<br />S 2.000,000.00
<br />$ 1,997,300.00
<br />S 4,000,000,00
<br />FFCB Callable 3133EGNS
<br />1.200%
<br />12/08/17
<br />01/06/20
<br />1.52
<br />1.955%
<br />S 2,000,000.00
<br />$ 1,969,400.00
<br />Treasury Note 91282BV31
<br />1.375%
<br />12/18117
<br />01/3,S/20
<br />1.55
<br />1.845%
<br />5 3,000,000.00
<br />5 2,971,406.25
<br />FNMA Bullet 3135GOA78
<br />1.625%
<br />12/08/17
<br />01/21/20
<br />1.56
<br />1.862%
<br />S 3,000,000.00
<br />S 2,985,270.00
<br />Treasury Note 912828357
<br />2.000%
<br />05/03/18
<br />01/31/20
<br />1.59
<br />2.460%
<br />5 31000,000.00
<br />S 2,976,562.50
<br />$ 11,0M.000.00
<br />FHLB Callable 3130ABC69
<br />1.600%
<br />05/.16/18
<br />02/03/20
<br />1.60
<br />2.634%
<br />5 3,000,000.00
<br />$ 2,948,310.00
<br />FFCB Callable 3133EHR70
<br />1340%
<br />11/14/17
<br />02/14/20
<br />1.63
<br />1.740%
<br />$ 2,0110,000.00
<br />$ 2,000,000.00
<br />FFCB Callable 3133EGAE5
<br />1.360%.
<br />12/21/17
<br />02/18/20
<br />1.64
<br />1.991%
<br />$ 3,000,000.00
<br />S 2,960,160.00
<br />FNMA Bullet 3135GOT29
<br />1.500%
<br />10/23/17
<br />02/28/20
<br />1.67
<br />1.688%
<br />$ 2,000,000.00
<br />S 1,991,360.00
<br />S 10,000,000.00
<br />FFCB Callable 3133EHLX2
<br />ISM
<br />10/23/17
<br />03/65/20
<br />1.58
<br />1.716%
<br />$ 2,000.00,00
<br />$ 1,990,000.00
<br />Treasury Note 912828W63
<br />1.625%
<br />12/12/17
<br />03/15/20
<br />1.71
<br />1.845%
<br />S 3.000,000.00
<br />S 2,985,420.00
<br />FHLMC 3134GSE64
<br />1.700%
<br />I1/21/17
<br />03/27/20
<br />1.74
<br />1.776%
<br />S 2,000,000.00
<br />S 1,996,500.00
<br />5 7,000,000.00
<br />FFCB Callable 3133EHCSO
<br />1680%
<br />03/13/18
<br />04/03/20
<br />1.76
<br />2.316%
<br />$ 2,000,000.00
<br />S 1.974,600.00
<br />Treasury Note 912828X21
<br />1.500%
<br />12/12/17
<br />04/15/20
<br />1.79
<br />1.857%
<br />$ 3,000,000.00
<br />S 2.975,580.00
<br />FHLMC Bullet 3137EAEF2
<br />1.375%
<br />11/21/17
<br />04/20/20
<br />1.81
<br />1.858%
<br />$ 2,000,000.00
<br />$ 1,977,300.00
<br />FFCB Callable 3133EHHA4
<br />1.620%
<br />05/16/18
<br />04/27/20
<br />1.83
<br />2.670%
<br />S 3,000,000.00
<br />$ 2,940,600.00
<br />FHLMC Callable 3134GBQ88
<br />1.750%
<br />10/30/17
<br />04/30/20
<br />1.84
<br />1.750%
<br />$ 2,000,000.00
<br />$ 2,000,000.00
<br />S 12,(X10,000.00
<br />FHLMC Bullet 3137EADR7
<br />1.375%
<br />11/21/17
<br />05/01/20
<br />1.84
<br />1.823%
<br />S 2,000.000.00
<br />5 1.978,660.00
<br />FHLB - IX 3130ACN83
<br />1.700%
<br />11/21/17
<br />05/.15/20
<br />1188
<br />1.869%
<br />S 2,000,00000
<br />5 1,991,800.00
<br />FFCB Callable 3133EHT78
<br />1.830%
<br />12/21/17
<br />05/20/20
<br />7,89
<br />2.013%
<br />S 3.000,000.00
<br />5 2,987,040.00
<br />FNMA Caltable 3136G4LQ4
<br />1.750%
<br />12MI17
<br />05/28/20
<br />1.91
<br />1.875%
<br />S 3,000,00.00
<br />S 2,991,000.00
<br />$ 10,000,000.00
<br />FFCB Callable 3133EJEKI
<br />2.450%
<br />03/01/18
<br />06/01/20
<br />1.92
<br />2.450%
<br />$ 3,000,000.00
<br />$ 3,000,000.00
<br />FHLB Bullet 313383HU8
<br />1.750%
<br />03/23/18
<br />06/12/20
<br />195
<br />2.399%
<br />S 2,000,000.00
<br />$ 1.972,080.00
<br />FHLB Callable 3130ASNOS
<br />1.625%
<br />12/08/17
<br />00/26/20
<br />1.99
<br />1.907%
<br />$ 2,000,000.00
<br />S 1.986,000.0D
<br />FHLB Callable 3130ABNM4
<br />1.640%
<br />06/25/18
<br />'06/29/20
<br />7.D0
<br />2.60696
<br />S 3,000,000.00
<br />$ 2,943,570.00
<br />FNMA Callable 3136G3UR4
<br />1.380%
<br />03/23/18
<br />06130/20
<br />2.00
<br />2.443%
<br />$ 3,000,000.00
<br />S 2,929,950.00
<br />S 13,000,000.00
<br />FHLB Callable 3130ABNV4
<br />1.750%
<br />03/15/18
<br />07/13/20
<br />2.44
<br />2.419%
<br />5 3,000,000.00
<br />$ 2,954,790.00
<br />FNMA Bullet 3135GOT60
<br />1.500%
<br />03/15/18
<br />07/30/20
<br />2.08
<br />2.351%
<br />S 3,040,000.00
<br />$ 2,941,350.00
<br />S 6.000,000.00
<br />FFCB Callable 3133EIMS5
<br />2.625%
<br />05/03/18
<br />08/0380
<br />7.10
<br />2.656%
<br />S 3,000,000.00
<br />S 2,998,050.00
<br />FFCB Callable 3133EHUEI
<br />1.650%
<br />03/19/18
<br />08/10/20
<br />2.12
<br />2.372%
<br />S 2,000,000.00
<br />S 1,966,600.00
<br />FHLO Callable 3130ACTKO
<br />1.875%
<br />03/19/18
<br />08/25/20
<br />2.16
<br />2.379%
<br />$ 3.000,000.00
<br />5 2,964,420.00
<br />5 8,000,000.00
<br />FNMA Callable 313663686
<br />1.450%
<br />04/30/18
<br />09/15/20
<br />2.21
<br />2.61096
<br />5 3,000,000.00
<br />$ 2,920,3I0.00
<br />FFCB Callable 3133EGVK8
<br />1.350%
<br />05/10/18
<br />09/21/20
<br />2.23
<br />2.661%
<br />S 31000,000.00
<br />S 2,910,450,00
<br />FHLB Callable 3130ADSFO
<br />2.500%
<br />03/29/18
<br />09/19/20
<br />125
<br />2.50096
<br />$ 3,000.000.00
<br />5 3,000,000.00
<br />$ 910001000.00
<br />FFCB Callable 3.133EGXU4
<br />1.370%
<br />05/10/18
<br />10/06/20
<br />2.27
<br />2.665%
<br />5 3,000,000.00
<br />5 2.910,000.00
<br />$ 3,000,000.00
<br />FFCB Callable 3133EJMX4
<br />2.680%
<br />05/10/18
<br />11/02/20
<br />2.35
<br />2.701%
<br />S 3,000,000.00
<br />$ 2,998,500.00
<br />FFCB Callable 3133EGF42
<br />1.360%
<br />oslm/la
<br />11/09120
<br />2.36
<br />2.655%
<br />S 3,000,000.00
<br />S 2.906,700.00
<br />5 6,000,000.00
<br />Sub Total - General Investments
<br />S 281.000,000,00
<br />5 279,085,777.26
<br />$ 281,000,000.00
<br />Regions Bank Money Market
<br />S13,553,443.86
<br />Regions Lockbox Accounts
<br />$7,472,254.89
<br />TD Bank Checking Account
<br />$21,144,700.84
<br />Wells Fargo Bank Checking Account
<br />$16,573.14
<br />BankUnited Money Market
<br />$21,891,369.10
<br />National Bank of Commerce CD
<br />2.500%
<br />05/11/18
<br />05/11/20
<br />1.87
<br />56,145,340.93
<br />Valley National Bank Government Interest Checking
<br />S15,157,950.88
<br />Marine Bank Business Money Market
<br />55,033,329.20
<br />Total General Cash & Equivalents - Unrestricted
<br />S 369,498,740.10
<br />Restricted Cash -Bond Covenants (hold
<br />by BNYlMellonl
<br />Fidelity Institutional Treasury Money Market -Utilities Debt Service Reserve
<br />S 46,840.36
<br />Treasury Nate 91287.8R93
<br />0.625%
<br />06/30/16
<br />06130/18
<br />0.25
<br />0.745%
<br />$1,480,000.00
<br />$1,480,000.00
<br />Treasury Note 912828040
<br />1.0000/0
<br />11/30116
<br />11/30118
<br />0.67
<br />1.085%
<br />$1,030,000,00
<br />$1.023,416.50
<br />Treasury Note 912828XV77
<br />1.250%
<br />06/30/17
<br />06/30/19
<br />1.25
<br />1.345%
<br />51,610,000.00
<br />$1,592,386.60
<br />Total Restricted Bond Reserve - adjusted for fair market value
<br />$4,144,643.46
<br />Restricted Cash - Landfill
<br />FL CLASS -Landfill Closure & Postclosure
<br />Reserves
<br />S 13,591,853.34
<br />Total Pooled Cash & Equivalents
<br />S 387,235,236.90
<br />Restrigtod Cash - Health Insurance
<br />TO Bank . BCBS Clairns Account
<br />$1,824,384,96
<br />Citibank - BCBS Imprest Acct
<br />584,004,00
<br />Total Restricted Cash - Health Insurance
<br />$1,908,384.96
<br />Restricted Cash - Housing Account S351,910.89
<br />Total Portfolio S 389,495,532.75
<br />Note: See separate Investment report for OPER funds,
<br />60
<br />201-2
<br />
|