|
Schedule 1
<br />Indian River County, Florida
<br />Board of County Commissioners
<br />Investments By Type
<br />December 31, 2017
<br />Restricted Cash - Housing Account $367,442.01
<br />Total Portfolio $409,459,268.72
<br />Note: See separate investment report for OPES funds.
<br />19
<br />2ef2
<br />12/31/17
<br />Coupon/
<br />Purchase
<br />Maturity
<br />Years To
<br />Yield To
<br />Original
<br />Portfolio
<br />Investment Type CUSIP
<br />Yield
<br />Date
<br />Date
<br />Maturity
<br />Maturity
<br />Par Amount
<br />Book Value
<br />%
<br />Treasury Note 91282SP20
<br />0.750%
<br />11/18/16
<br />01/31/18
<br />0.08
<br />0.850%
<br />5 3,000,000.00
<br />$
<br />2,996,430.00
<br />Treasury Note 912828UR9
<br />0.750%
<br />03/31/16
<br />02/28/18
<br />0.16
<br />0.750%
<br />S 2,000,000.00
<br />5
<br />2,000,000.00
<br />Treasury Note 912828UR9
<br />0.750%
<br />12/04/15
<br />02/28/18
<br />0.16
<br />1.004%
<br />$ . 3,000,000.00
<br />$
<br />2,983,140.00
<br />Treasury Note 91282a168
<br />1.000%
<br />12/04/15
<br />03/1S/18
<br />0.20
<br />1.055%
<br />S 3,000,000.00
<br />S
<br />2,996,250.00
<br />Treasury Note 912828UU2
<br />0.750%
<br />03/31/16
<br />03/31/18
<br />o.25
<br />0.753%
<br />$ 2,000,000.00
<br />$
<br />1,999,900.00
<br />TreasuryNote 912828UU2
<br />0.750%
<br />12/04/15
<br />03/31/18
<br />0.25
<br />1.050%
<br />S 3,000,000.00
<br />5
<br />2,979,390.00
<br />Treasury Note 91292SK25
<br />0.750%
<br />12/07/15
<br />04/15/18
<br />0.29
<br />1.070%
<br />$ 3,000,000.00
<br />$
<br />2,977,710.00
<br />Treasury Note 91282SUZI
<br />0.625%
<br />03/31/16
<br />04/30/18
<br />0.33
<br />0.769%
<br />$ 2,000,000.00
<br />S
<br />1,994,060.00
<br />Treasury Note 912828UZ1
<br />0.625%
<br />02/18/16
<br />04/30/18
<br />0.33
<br />0.780%
<br />S 3,000,000.00
<br />5
<br />2,989,882.50
<br />Treasury Note 912828XA3
<br />1.000%
<br />11/30/15
<br />05/15/18
<br />0.37
<br />1.090%
<br />$ 3,000,000.00
<br />$
<br />2,993,430.00
<br />Treasury Note 9128281151
<br />0.875%
<br />11/18/16
<br />05/31/18
<br />0.41
<br />0.947%
<br />$ 3,000,000.00
<br />$
<br />2,996,718.75
<br />Treasury Note 912828XF2
<br />1.125%
<br />12/16/16
<br />06/15/18
<br />OAS
<br />1.132%
<br />$ 2,000,000.00
<br />$
<br />1,999,780.00
<br />Treasury Note 91282SR43
<br />0.625%
<br />12/09/16
<br />06/30/18
<br />0.50
<br />0.999%
<br />$ 3,000,000.00
<br />$
<br />2,982,660.00
<br />Treasury Note 912828893
<br />0.625%
<br />11/18/16
<br />06/30/18
<br />0.50
<br />0.952%
<br />$ 3,000,000.00
<br />S
<br />2,984,296.88
<br />TreasuryNote 91282SXKI
<br />0.875%
<br />12/16/16
<br />07/15/18
<br />0.54
<br />1.162%
<br />S 2,000,000.00
<br />S
<br />1,991,020.00
<br />Treasury Note 912828568
<br />0.750%
<br />12/09/16
<br />07/31/18
<br />0.58
<br />1.038%
<br />$ 2,000,000.00
<br />S
<br />1,990,625.00
<br />Treasury Note 912828563
<br />0.750%
<br />11/30/16
<br />07/31/18
<br />0.58
<br />1.048%
<br />S 3,000,000.00
<br />$
<br />4985,234.38
<br />Treasury Note 912828KS2
<br />1.000%
<br />12/12/16
<br />08/15/18
<br />0.62
<br />L075%
<br />$ 3,000,000.00
<br />$
<br />2,996,250.00
<br />Treasury Note 912828203
<br />0.750%
<br />12/09/16
<br />08/31/18
<br />0.67
<br />1.057%
<br />S 2,000,000.00
<br />$
<br />1,989,540.00
<br />Treasury Note 912828203
<br />0.750%
<br />11/30/16
<br />08/31/18
<br />0.67
<br />1066%
<br />S 31000,000.00
<br />$
<br />2,983,590.00
<br />Treasury Note 91282BL40
<br />1.000%
<br />11/30/16
<br />09/15/18
<br />0.71
<br />1.080%
<br />$ 3,000,000.00
<br />S
<br />2,995,770.00
<br />Treasury Note 912828742
<br />0.750%
<br />12/09/16
<br />09/30/18
<br />0.75
<br />1.078%
<br />$ 3,000,000.00
<br />$
<br />2,982,420.00
<br />Treasury Note 9128281.815
<br />0.875%
<br />11/30/16
<br />10/15/18
<br />0.79
<br />1.080%
<br />5 3,000,000.00
<br />$
<br />2,988,633.00
<br />Treasury Note 912828783
<br />0.750%
<br />12/09/16
<br />10/31/18
<br />0.83
<br />1.093%
<br />$ 3,000,000.00
<br />$
<br />2,980,800.00
<br />Treasury Note 912828W97
<br />1.250%
<br />09/14/17
<br />03/31/19
<br />1.25
<br />1.332%
<br />S 2,000,000.00
<br />S
<br />1,997,500.00
<br />Treasury Note 91282SR44
<br />0.875%
<br />08/29/17
<br />05/15/19
<br />1.37
<br />1.273%
<br />5 2,000,000.00
<br />$
<br />1,986,562.50
<br />Treasury Note 912828WSS
<br />1.625%
<br />11/30/17
<br />06/30/19
<br />1.50
<br />1.728%
<br />S 3,000,000.00
<br />5
<br />2,995,200.00
<br />Treasury Note 912S28TC4
<br />1.000%
<br />09/14/17
<br />06/30/19
<br />1.50
<br />1.336%
<br />5 3,000,000.00
<br />$
<br />2,982,187.50
<br />Treasury Note 91828282KS
<br />1.375%
<br />12/01/17
<br />07/31/19
<br />1.58
<br />1.817%
<br />$ 3,000,000.00
<br />$
<br />2,978,906.25
<br />Treasury Note 912828080
<br />1.625%
<br />11/30/17
<br />08/31/19
<br />1.61
<br />1.752%
<br />5 3,000,000.00
<br />$
<br />2,993,437.50
<br />Treasury Note 91282SF62
<br />1500%
<br />12/12/17
<br />10/31/19
<br />1,63
<br />1.797%
<br />$ 3,000,000.00
<br />$
<br />2,983,560.00
<br />Treasury Note 91282SV31
<br />1.37S%
<br />12/18/17
<br />01/15/20
<br />2.04
<br />1.845%
<br />$ 3,000,000.00
<br />5
<br />2,971,406.25
<br />Treasury Note 91282SW63
<br />1.625%
<br />12/12/17
<br />03/15/20
<br />2.21
<br />1.845%
<br />S 3,000,000.00
<br />$
<br />2,985,420.00
<br />Treasury Note 912828X21
<br />1.500%
<br />12/12/17
<br />04/15/20
<br />2.29
<br />1.857%
<br />5 3,000,000,00
<br />$
<br />2,975,SBO.00
<br />S 93,0110,000.00
<br />S
<br />92,607,200.51
<br />22.74%
<br />Regions Bank Money Market
<br />526,441,210.29
<br />6.49%
<br />Regions Bank Lockbox Accounts
<br />$4,929,963.33
<br />1.21%
<br />TO Bank Checking Account
<br />$28,921,640.29
<br />7.10%
<br />Wells Fargo Bank Checking Account
<br />52,225,614.58
<br />0.55%
<br />BankUnded Money Market
<br />538,641,731.83
<br />9.49%
<br />Harbor Community Bank CD
<br />0.650%
<br />02/04/16
<br />02104118
<br />0.10
<br />$3,101,56612
<br />0.76%
<br />National Bank of Commerce CO
<br />0.850%
<br />05/11/17
<br />05/11/16
<br />036
<br />$6,105,322.07
<br />1.50%
<br />Oculina Bank CD
<br />0.880%
<br />04/23/16
<br />04/26/18
<br />0.32
<br />52,029,864.78
<br />0.50%
<br />Valley National Bank Government Interest Checking
<br />$15,045,037.06
<br />3.68%
<br />Marine Bank Business Money Market
<br />S5,002.055.18
<br />1.23%
<br />Total General Cash & Equivalents - Unrestricted
<br />$389,466,057.64
<br />Restricted Cash -Bond Covenants (held by BNY/Mellon)
<br />Fidelity Institutional Treasury Money Market -Utilities Debt Service Reserve
<br />$27,002.86
<br />Treasury Note 91282BR93
<br />0.625%
<br />06/30/16
<br />06/30/18
<br />0.50
<br />0.745%
<br />$1,490,000.00
<br />$1,473,872.80
<br />Treasury Note 91282SU40
<br />1,000%
<br />11/30/16
<br />11/30/18
<br />0.92
<br />1.085%
<br />$1,030,000.00
<br />51,022,676.70
<br />Treasury Note 912828XV77
<br />1.250%
<br />06/30/17
<br />06/30/19
<br />1.50
<br />1.345%
<br />$1,630,000.00
<br />$1,595,719.30
<br />Total Restricted Bond Reserve - adjusted for fair market value
<br />$4,119,271.66
<br />1.01%
<br />Restricted Cash - Landfill
<br />FACC-Florida Local Govt Investment Trust -Landfill Closure & Postclosure Reserves
<br />- adjusted for fair mkt value
<br />S
<br />13,724,448.83
<br />3.37%
<br />Total Pooled Cash & Equivalents
<br />$407,309,778.13
<br />100.00%
<br />Restricted Cash - Health Insurance
<br />TO Bank - BCBS Claims Account
<br />51,698,048.58
<br />Citibank - BCBS Imprest Acct
<br />$84,000.00
<br />Total Restricted Cash - Health Insurance
<br />$1,782,048.58
<br />Restricted Cash - Housing Account $367,442.01
<br />Total Portfolio $409,459,268.72
<br />Note: See separate investment report for OPES funds.
<br />19
<br />2ef2
<br />
|