|
Schedule 2
<br />Indian River County, Florida
<br />Board of County Commissioners
<br />Investment By Maturity Date
<br />September 30, 2018
<br />Regions Bank Money Market
<br />Regions Lockbox Accounts
<br />TD Bank Checking Account
<br />BankUnited Money Market
<br />National Bank of Commerce CD 2.500%, 05/11/18 05/11/20 1.61
<br />Valley National Bank Government Interest Checking
<br />Marine Bank Business Money Markel
<br />Total General Cash & Equivalents - Unrestricted
<br />09/30/18
<br />Original
<br />Par Amount Book Value Mo Cash Flow
<br />$ 3,000,000.00 $ 2,985,420.00
<br />$ 2,000,000.00 $ 1,996,500.00
<br />$ 3,000,000.00 $ 2,929,687.50 $ 10,000,000.00
<br />$ 2,000,000.00 $ 1,974,600.00
<br />$ 3,000,000.00 $ 2,975,580.00
<br />$ 2,000,000.00 $ 1,977,300.00
<br />$ 3,000,000.00 $ 2,940,600.00
<br />$ 2,000,000.00 $ 2,000,000.00 $ 12,000,000.00
<br />$ 2,000,000.00 $ 1,978,660.00
<br />$ 2,000,000.00 $ 1,991,800.00
<br />$ 3,000,000.00 $ 2,987,040.00
<br />$ 3,000,000.00 $ 2,991,000.00
<br />$ 3,000,000.00 $ 2,935,781.25 $ 13,000,000.00
<br />$ 3,000,000.00 $ 3,000,000.00
<br />$ 2,000,000.00 $ 1,972,080.00
<br />$ 2,000,000.00 $ 1,986,000.00
<br />$ 3,000,000.00 $ 2,943,570.00
<br />$ 3,000,000.00 $ 2,929,950.00 $ 13,000,000.00
<br />$ 3,000,000.00 $ 2,954,790.00
<br />$ 3,000,000.00 $ 2,938,359.00
<br />$ 3,000,000.00 $ 2,941,350.00
<br />$ 3,000,000.00 $ 2,943,960.00 $ 12,000,000.00
<br />$ 3,000,000.00 $ 2,998,050.00
<br />$ 2,000,000.00 $ ,1,966,600.00
<br />$ 3,000,000.00 $ 2,964,420.00
<br />$ 3,000,000.00 $ 2,966,700.00 $ 11,000,000.00
<br />$ 3,000,000.00 $ 2,920,320.00
<br />$ 3,000,000.00 $ 2,910,450.00
<br />$ 3,000,000.00 $ 3,000,000.00
<br />$ 3,000,000.00 $ 3,000,000.00 $ 12,000,000.00
<br />$ 3,000,000.00 $ 2,910,000.00
<br />$ 3,000,000.00 $ 2,934,120.00
<br />$ 3,000,000.00 $ 2,940,690.00 $ 9,000,000.00
<br />$ 3,000,000.00 $ 2,998,500.00
<br />$ 3,000,000.00 $ 2,906,700.00 $ 6,000,000.00
<br />$ 3,000,000.00 $ 2,965,500.00 $ 3,000,000.00
<br />$ 269,000,000.00 $ 266,694,737.19 $ 269,000,000.00
<br />$13,606,270.76
<br />$1,886,541.19
<br />$16,023,452.63
<br />$21,984,621.91
<br />$6,183,336.53
<br />$20,234,260.25
<br />$5,049,039.46
<br />$ 351,662,259.92
<br />Restricted Cash -Bond Covenants (held by BNY/Mellon)
<br />Coupon/
<br />Purchase
<br />Maturity
<br />Years To
<br />Yield To
<br />Investment Type
<br />CUSIP
<br />Yield
<br />Date
<br />Date
<br />Maturity
<br />Maturity
<br />Treasury Note
<br />912828W63
<br />1.625%
<br />12/12/17
<br />03/15/20
<br />1.46
<br />1.845%
<br />FHLMC
<br />3134GBEB4
<br />1.700%
<br />11/21/17
<br />03/27/20
<br />1.49
<br />1.776%
<br />Treasury Note
<br />912828UV0
<br />1.125%
<br />07/06/18
<br />03/31/20
<br />1.50
<br />2.513%
<br />FFCB Callable
<br />3133EHC50
<br />1.680%
<br />03/13/18
<br />04/03/20
<br />1.51
<br />2.316%
<br />Treasury Note
<br />912828X21
<br />1.500%
<br />12/12/17
<br />04/15/20
<br />1.54
<br />1.857%
<br />FHLMC Bullet
<br />3137EAEF2
<br />1.375%
<br />11/21/17
<br />04/20/20
<br />1.56
<br />1.858%
<br />FFCB Callable
<br />3133EHHA4 -
<br />1.620%
<br />05/16/18
<br />04/27/20
<br />1.58
<br />2.670%
<br />FHLMC Callable -
<br />3134GBQSB
<br />1.750%
<br />10/30/17
<br />04/30/20
<br />1.58
<br />1.750%
<br />FHLMC Bullet -
<br />3137EADR7
<br />1.375%
<br />11/21/17
<br />05/01/20
<br />1.59
<br />1.823%
<br />FHLB Callable .
<br />3130ACN83
<br />1.7000/
<br />11/21/17
<br />05/15/20
<br />1.62
<br />1.869%
<br />FFCB Callable
<br />3133EHT78
<br />1.830%
<br />12/21/17
<br />05/20/20
<br />1.64
<br />2.014%
<br />FNMA Callable
<br />3136G4LQ4
<br />1.750%
<br />12/08/17
<br />05/28/20
<br />1.66
<br />1.875%
<br />Treasury Note
<br />912828VF4
<br />1.375%
<br />07/06/18
<br />05/31/20
<br />1.67
<br />2.535%
<br />FFCB Callable
<br />3133EJEK1
<br />2.450%
<br />03/01/18
<br />06/01/20.
<br />1.67
<br />2.450%
<br />FHLB Bullet
<br />313383HU8
<br />1.750%
<br />03/23/18
<br />06/12/20
<br />1.70
<br />2.399%
<br />FHLB Callable
<br />3130ABNQ5
<br />1.625%
<br />12/08/17
<br />06/26/20
<br />1.74
<br />1.907%
<br />FHLB Callable
<br />3130ABNM4
<br />1.640%
<br />06/25/18
<br />06/29/20
<br />1.75
<br />2.606%
<br />FNMA Callable
<br />3136G3UR4
<br />1.380%
<br />03/23/18
<br />06/30/20
<br />1.75
<br />2.443%
<br />FHLB Callable
<br />3130ABNV4
<br />1.750%
<br />03/15/18
<br />07/13/20
<br />1.79
<br />2.419%
<br />Treasury Note
<br />912828218
<br />1.500%
<br />08/14/18
<br />07/15/20
<br />1.79
<br />2.604%
<br />FNMA Bullet
<br />3135GOT60
<br />1.500%
<br />03/15/18
<br />07/30/20
<br />1.83
<br />2.351%
<br />Treasury Note
<br />912828XM7
<br />1.625%
<br />08/14/18
<br />07/31/20
<br />1.84
<br />2.608%
<br />FFCB Callable
<br />3133EJMSS
<br />2.625%
<br />05/03/18
<br />08/03/20
<br />1.84
<br />2.656%
<br />FFCB Callable
<br />3133EHUE1
<br />1.650%
<br />03/19/18
<br />08/10/20
<br />1.86
<br />2.372%
<br />FHLB Callable
<br />3130ACTK0
<br />1.875%
<br />03/19/18
<br />08/25/20
<br />1.90
<br />2.379%
<br />Treasury Note
<br />912828VV9
<br />2.125%
<br />08/01/18
<br />08/31/20
<br />1.92
<br />2.676%
<br />FNMA Callable
<br />3136G36136
<br />1.450%
<br />04/30/18
<br />09/15/20
<br />1.96
<br />2.610%
<br />FFCB Callable
<br />3133EGVK8.
<br />1.350%
<br />05/10/18
<br />09/21/20
<br />1.98
<br />2.661%
<br />FHLMC
<br />3134GSXS9
<br />2.750%
<br />09/28/18
<br />09/28/20
<br />2.00
<br />2.750%
<br />FHLB Callable
<br />3130ADSF0
<br />2.500%
<br />03/29/18
<br />09/29/20
<br />2.00
<br />- 2.500%
<br />FFCB Callable
<br />3133EGXU4
<br />1.370%
<br />05/10/18
<br />10/06/20
<br />2.02
<br />2.665%
<br />Treasury Note
<br />9128282Z2
<br />1.625%
<br />09/10/18
<br />10/15/20
<br />2.04
<br />2.709%
<br />Treasury Note
<br />912828WC0
<br />1.750%
<br />09/10/18
<br />10/31/20
<br />2.09
<br />2.707%
<br />FFCB Callable
<br />3133EJMX4
<br />2.680%
<br />05/10/18
<br />11/02/20
<br />2.09
<br />2.701%
<br />FFCB Callable
<br />3133EGF42
<br />1.360%
<br />05/10/18
<br />11/09/20
<br />2.11
<br />2.655%
<br />FHLMC Bullet
<br />3137EAEL9
<br />2.375%
<br />09/21/18
<br />02/16/21
<br />2.38
<br />2.873%
<br />Sub Total - General Investments
<br />Regions Bank Money Market
<br />Regions Lockbox Accounts
<br />TD Bank Checking Account
<br />BankUnited Money Market
<br />National Bank of Commerce CD 2.500%, 05/11/18 05/11/20 1.61
<br />Valley National Bank Government Interest Checking
<br />Marine Bank Business Money Markel
<br />Total General Cash & Equivalents - Unrestricted
<br />09/30/18
<br />Original
<br />Par Amount Book Value Mo Cash Flow
<br />$ 3,000,000.00 $ 2,985,420.00
<br />$ 2,000,000.00 $ 1,996,500.00
<br />$ 3,000,000.00 $ 2,929,687.50 $ 10,000,000.00
<br />$ 2,000,000.00 $ 1,974,600.00
<br />$ 3,000,000.00 $ 2,975,580.00
<br />$ 2,000,000.00 $ 1,977,300.00
<br />$ 3,000,000.00 $ 2,940,600.00
<br />$ 2,000,000.00 $ 2,000,000.00 $ 12,000,000.00
<br />$ 2,000,000.00 $ 1,978,660.00
<br />$ 2,000,000.00 $ 1,991,800.00
<br />$ 3,000,000.00 $ 2,987,040.00
<br />$ 3,000,000.00 $ 2,991,000.00
<br />$ 3,000,000.00 $ 2,935,781.25 $ 13,000,000.00
<br />$ 3,000,000.00 $ 3,000,000.00
<br />$ 2,000,000.00 $ 1,972,080.00
<br />$ 2,000,000.00 $ 1,986,000.00
<br />$ 3,000,000.00 $ 2,943,570.00
<br />$ 3,000,000.00 $ 2,929,950.00 $ 13,000,000.00
<br />$ 3,000,000.00 $ 2,954,790.00
<br />$ 3,000,000.00 $ 2,938,359.00
<br />$ 3,000,000.00 $ 2,941,350.00
<br />$ 3,000,000.00 $ 2,943,960.00 $ 12,000,000.00
<br />$ 3,000,000.00 $ 2,998,050.00
<br />$ 2,000,000.00 $ ,1,966,600.00
<br />$ 3,000,000.00 $ 2,964,420.00
<br />$ 3,000,000.00 $ 2,966,700.00 $ 11,000,000.00
<br />$ 3,000,000.00 $ 2,920,320.00
<br />$ 3,000,000.00 $ 2,910,450.00
<br />$ 3,000,000.00 $ 3,000,000.00
<br />$ 3,000,000.00 $ 3,000,000.00 $ 12,000,000.00
<br />$ 3,000,000.00 $ 2,910,000.00
<br />$ 3,000,000.00 $ 2,934,120.00
<br />$ 3,000,000.00 $ 2,940,690.00 $ 9,000,000.00
<br />$ 3,000,000.00 $ 2,998,500.00
<br />$ 3,000,000.00 $ 2,906,700.00 $ 6,000,000.00
<br />$ 3,000,000.00 $ 2,965,500.00 $ 3,000,000.00
<br />$ 269,000,000.00 $ 266,694,737.19 $ 269,000,000.00
<br />$13,606,270.76
<br />$1,886,541.19
<br />$16,023,452.63
<br />$21,984,621.91
<br />$6,183,336.53
<br />$20,234,260.25
<br />$5,049,039.46
<br />$ 351,662,259.92
<br />Restricted Cash -Bond Covenants (held by BNY/Mellon)
<br />Fidelity Institutional Treasury Money Market -Utilities Debt Service Reserve
<br />$
<br />17,443.41
<br />Treasury Note 912828U40 1.000% 11/30/16 11/30/18
<br />0.17 1.085% $1,030,000.00
<br />$1,028,032.70
<br />Treasury Note 912828XV77 1.250% 06/30/17 06/30/19
<br />0.75 .1.345% $1,610,000.00
<br />$1,594,656.70
<br />Treasury Note 912828R93 2.500% 07/02/18 06/30/20
<br />1.75 2.538% $1,525,000.00
<br />$1,517,131.00
<br />Total Restricted Bond Reserve - adjusted for fair market value
<br />$
<br />4,157,263.81
<br />Restricted Cash - Landfill
<br />FL CLASS -Landfill Closure & Postclosure Reserves
<br />$
<br />14,091,025.86
<br />Total Pooled Cash & Equivalents
<br />$
<br />369,910,549.59
<br />Restricted Cash - Health Insurance
<br />TD Bank - BCBS Claims Account
<br />$741,410.40
<br />Citibank - BCBS Imprest Acct
<br />$84,000.00
<br />Total Restricted Cash - Health Insurance
<br />$825,410.40
<br />Restricted Cash - Housing Account - $378,351.31
<br />Total Portfolio $ 311,114,311.30
<br />Note: See separate Investment report for OPEB funds.
<br />34
<br />2 oft
<br />
|