|
Schedule 2
<br />Indian
<br />River County, Florida
<br />Board of County Commissioners
<br />Investment By Maturity Date
<br />December 31,
<br />2017
<br />12/31/17
<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 9128282KS
<br />1.375%
<br />12/18/17
<br />07/31/19
<br />1.58
<br />1.817%
<br />$ 3,000,000.00
<br />5
<br />2,978,906.25
<br />5 11,000,000.00
<br />FHLMC Bullet 3137EADK2
<br />1.250%
<br />03/30/17
<br />08/01/19
<br />1.58
<br />1.402%
<br />5 3,000,000.00
<br />$
<br />2,989,560.00
<br />FFC8 Bullet 3133EHUK7
<br />1.400%
<br />08/14/17
<br />08/14/19
<br />1.62
<br />1.400%
<br />5 2,000,000.00
<br />$
<br />2,000,000.00
<br />FHLB Callable 3130ABWXO
<br />1.500%
<br />08/22/17
<br />08/22/19
<br />1.64
<br />1.500%
<br />5 2,000,000.00
<br />$
<br />2,000,000.00
<br />FNMA Bullet 313SGOP49
<br />1.000%
<br />05/05/17
<br />08/28/19
<br />1.66
<br />1.442%
<br />5 2,000,000.00
<br />$
<br />1,979,946.00
<br />Treasury Note 912828D80
<br />1.625%
<br />11/30/17
<br />08/31/19
<br />1.67
<br />1.752%
<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.69
<br />1.500%
<br />$ 2,000,000.00
<br />$
<br />2,000,000.00
<br />FNMA Callable 3135GOPS6
<br />1.250%
<br />11/30/17
<br />09/20/19
<br />1.72
<br />1.842%
<br />$ 2,000,000.00
<br />$
<br />1,979,060.00
<br />FHLB Bullet 313OA9EP2
<br />1.000%
<br />05/10/17
<br />09/26/19
<br />1.74
<br />1.436%
<br />$ 2,000,000.00
<br />$
<br />1,979,660.00
<br />FHLB Bullet 313OA9EP2
<br />1.000%
<br />05/11/17
<br />09/26/19
<br />1.74
<br />1.435%
<br />$ 2,000,000.00
<br />$
<br />1,979,750.00
<br />$ 8,000,000.00
<br />FHLMC Bullet 3137EADM8
<br />1.250%
<br />05/04/17
<br />10/02/19
<br />1.75
<br />1.451%
<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.78
<br />1.946%
<br />$ 2,000,000.00
<br />$
<br />1,970,800.00
<br />FHLB Bullet 3130ASTD89
<br />1.450%
<br />07/18/17
<br />10/18/19
<br />1.80
<br />1.450%
<br />$ 2,000,000.00
<br />5
<br />2,000,000.00
<br />FNMA Bullet 3135GOR39
<br />1.000%
<br />06/30/17
<br />10/24/19
<br />1.81
<br />1.425%
<br />$ 2,000,000.00
<br />$
<br />1,980,694.00
<br />Treasury Note 912828F62
<br />1.500%
<br />12/12/17
<br />10/31/19
<br />1.83
<br />1.797%
<br />$ 3,000,000.00
<br />$
<br />2,983,560.00
<br />$ 12,000,000.00 ,
<br />FFCB Callable 3133EGA62
<br />1.160%
<br />11/30/17
<br />11/01/19
<br />1.84
<br />1.866%
<br />5 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.87
<br />1.433%
<br />$ 2,000,000.00
<br />5
<br />1,997,300.00
<br />$ 4,000,000.00
<br />FFCB Callable 31-33EGJVS
<br />1.200%
<br />12/08/17
<br />01/06/20
<br />2.02
<br />1.955%
<br />$ 2,000,000.00
<br />$
<br />1,969,400.00
<br />Treasury Note 912828V31
<br />1.375%
<br />12/18/17
<br />01/15/20
<br />2.04
<br />1.845%
<br />$ 3,000,000.00
<br />$
<br />2,971,406.25
<br />FNMA Bullet 313SGOA78
<br />1.625%
<br />12/08/17
<br />01/21/20
<br />2.06
<br />1.862%
<br />5 3,000,000.00
<br />$
<br />2,985,270.00
<br />$ 8,DDO,000.00
<br />FFCB Callable 3133EHR70
<br />1.7401A
<br />11/14/17
<br />02/14/20
<br />2.12
<br />1.740%
<br />5 2,000,000.00
<br />$
<br />2,000,000.00
<br />FFCB Callable 3133EGAES
<br />1.360%
<br />12/21/17
<br />02/18/20
<br />2.13
<br />1.991%
<br />5 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 />2.16
<br />1.688%
<br />$ 2,000,000.00
<br />$
<br />1,991,360.00
<br />$ 7,000,000.00
<br />FFC8 Callable 3133EHLX2
<br />1.500%
<br />10/23/17
<br />03/05/20
<br />2.18
<br />1.716%
<br />$ 2,000,000.00
<br />$
<br />1,990,000.00
<br />Treasury Note 91282SW63
<br />1.625%
<br />12/12/17
<br />03/15/20
<br />2.21
<br />1.845%
<br />$ 3,000,000.00
<br />5
<br />2,985,420.00
<br />FHLMC 3134GBE84
<br />1.700%
<br />11/21/17
<br />03/27/20
<br />2.24
<br />1.776%
<br />$ 2,000,000.00
<br />$
<br />1,996,500.00
<br />$ 7,000,000.00
<br />Treasury Note 912828X21
<br />1.500%
<br />12/12/17
<br />04/15/20
<br />2.29
<br />1.857%
<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.30
<br />1-858%
<br />$ 2,000,000.00
<br />$
<br />1,977,300.00
<br />FHLMC Callable 3134GBQ88
<br />1.750%
<br />10/30/17
<br />04/30/20
<br />2.33
<br />1.750%
<br />$ 2,000,000.00
<br />$
<br />2,000,000.00
<br />S 7,000,000.00
<br />FHLMC Bullet 3137EADR7
<br />1.375%
<br />11/21/17
<br />05/01/20
<br />2.33
<br />1.823%
<br />$ 2,000,000.00
<br />5
<br />1,978,660.00
<br />FHLB - SX Call 3130ACN83
<br />1.700%
<br />11/21/17
<br />05/15/20
<br />2.37
<br />1.869%
<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.39
<br />2.013%
<br />$ 3,000,000.00
<br />$
<br />2,987,040.00
<br />FNMA Callable 3136G4LQ4
<br />1.750%
<br />12/08/17
<br />05/28/20
<br />2.41
<br />1.875%
<br />$ 3,000,000.00
<br />$
<br />2,991,000.00
<br />$ 10,000,000.00
<br />FHLB Callable 3130ABNQS
<br />1.625%
<br />12/08/17
<br />06/26/20
<br />2.49
<br />1.907%
<br />5 2,000,000.00
<br />$
<br />1,986,000.00
<br />$ 2,000,000.00
<br />Sub Total - General Investment
<br />$ 258,000,000.00
<br />$
<br />257,032,051.51
<br />$ 258,000,000.00
<br />Regions Bank Money Market
<br />$26,441,210.29
<br />Regions Lockbox Accounts
<br />$4,919,963.33
<br />TD Bank Checking Account
<br />$28,921,640.29
<br />Wells Fargo Bank Checking Account
<br />$2,225,614.58
<br />BankUnited Money Market
<br />$38,641,731.83
<br />Harbor Community Bank CD
<br />0.850%
<br />02/04/16
<br />02/04/18
<br />0.10
<br />$3,101,566.72
<br />National Bank of Commerce CD
<br />0.850%
<br />05/11/16
<br />05/11/18
<br />0.36
<br />$6,105,322.07
<br />Oculina Bank CD
<br />0.880%
<br />04/23/16
<br />04/26/18
<br />0.32
<br />$2,029,864.78
<br />Valley National Bank Government Interest Checking
<br />$15,045,037.06
<br />Marine Bank Business Money Market
<br />$5,002,055.18
<br />Total General Cash & Equivalents -Unrestricted
<br />5
<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 912828R93
<br />0.625%
<br />06!30/16
<br />06/30/18
<br />0.50
<br />0.745%
<br />$1,480,000.00
<br />$1,473,872.80
<br />Treasury Note 912828U40
<br />1.000%
<br />11/30/16
<br />11/30/18
<br />0.92
<br />1.085%
<br />$1,030,000.00
<br />$1,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,610,000.00
<br />$1,595,719.30
<br />Total Restricted Bond Reserve - adjusted for fair market value
<br />$4,119,271.66
<br />Restricted Cash - Landfill
<br />FACC-Florida Local Govt Investment Trust -Landfill Closure 8 Postclosure Reserves - adjusted for `air mkt value
<br />5
<br />13,724,448.83
<br />Total Pooled Cash & Equivalents
<br />S
<br />407,309,778.13
<br />Restricted Cash - Health Insurance
<br />TD Bank - BCBS Claims Account
<br />$1,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
<br />$367,442.01
<br />Total Portfolio
<br />S
<br />409,459,268.72
<br />1
<br />21
<br />Note: See separate investment report
<br />for OPER funds.
<br />2of2
<br />
|