|
Schedule 2
<br />Indian River County, Florida
<br />Board of County Commissioners
<br />Investment By Maturity Date
<br />December 31, 2018
<br />12/31/18
<br />Coupon/ Purchase Maturity Years To Yield To Original
<br />Investment Type CUSIP Yield Date Date Maturity Maturity Par Amount Book Value Mo Cash Flow
<br />FFCB Callable 3133EHC50 1.680% - 03/13/18 04/03/20 1.26 2.316% $ 2,000,000.00 $ 1,974,600.00
<br />Treasury Note 912828X21 1.50014 12/12/17 04/15/20 1.29 1.857% $ 3,000,000.00 $ 2,975,580.00
<br />FHLMC Bullet 3137EAEF2 1.375% 11/21/17 04/20/20 1.30 1.858% $ 2,000,000.00 $ 1,977,300.00
<br />FHLMC Bullet 3137EAEM7 2.500% 12/10/18 04/23/20 1.31 2.724% $ 3,000,000.00 $ 2,990,970.00
<br />FFCB Callable 3133EHHA4 1.620% 05/16/18 04/27/20 1.32 2.670% $ 3,000,000.00 $ 2,940,600.00
<br />FHLMC Callable 313468088 , 1.750% 10/30/17 04/30/20 1.33 1.750% $ 2,000,000.00 $ 2,000,000.00 $ 15,000,000.00
<br />FHLMC Bullet 3137EADR7 1.375% 11/21/17 05/01/20 1.33 1.823% $ 2,000,000.00 $ 1,978,660.00
<br />FFCB Bullet 3133EIQ51 2.760% 12/03/18 05/05/20 1.35 2.815% $ 3,000,000.00 $ 2,997,660.00
<br />FHLB - 1X Call 3130ACN83 1.700% 11/21/17 05/15/20 1.37 _ 1.869% $ 2,000,000.00 $ 1,991,800.00
<br />FFCB Callable 3133EHT78 1.830% 12/21/17 05/20/20 1.39 • 2.014% $ 3,000,000.00 $ 2,987,040.00
<br />FNMA Callable 313664104 1.750% 12/08/17 05/28/20 1.41 1.875% $ 3,000,000.00 $ 2,991,000.00
<br />Treasury Note 912828VF4 1.375% 07/06/18 05/31/20 1.42 2.535% $ - 3,000,000.00 $ 2,935,781.25 5 16,000,000.00
<br />FFCB Callable 3133EJEK1 2.450% 03/01/18 06/01/20 1.42 2.450% $ 3,000,000.00 $ 3,000,000.00
<br />FHLB Bullet 313383H U8 1.750% 03/23/18 06/12/20 1.45 2.399% $ 2,000,000.00 $ 1,972,080.00
<br />FHLB Callable 3130ABN0.5 1.625% 12/08/17 06/26/20 1.49 1.907% $ 2,000,000.00 $ 1,986,000.00
<br />FHLB Callable 3130ABNM4 1.640% 06/25/18 06/29/20 1.50 2.606% $ 3,000,000.00 $ 2,943,570.00
<br />Treasury Note 912828XY1 2.500% 12/07/18 06/30/20 1.50 2.745% $ 3,000,000.00 $ 2,988,750.00
<br />FNMA Callable 3136G3UR4 1.380% 03/23/18 06/30/20 1.50 2.443% $ 3,000,000.00 $ 2,929,950.00 $ 16,000,000.00
<br />FHLB Callable 3130ABNV4 1.750% 03/15/18 07/13/20 1.53 2.419% $ 3,000,000.00 $ 2,954,790.00
<br />FHLMC Callable 3134GBXV9 1.850% 12/12/18 07/13/20 1.53 2.823% $ 3,000,000.00 $ 2,955,000.00
<br />Treasury Note 9128282J8 1.500% 08/14/18 07/15/20 1.54 2.604% $ 3,000,000.00 $ 2,938,359.00
<br />FNMA Bullet 3135G0T60 1.500% 03/15/18 07/30/20 1.58 2.351% $ 3,000,000.00 $ 2,941,350.00
<br />Treasury Note 912828XM7 1.625% 08/14/18 07/31/20 1.58 2.608% $ 3,000,000.00 $ 2,943,960.00 $ 15,000,000.00
<br />FFCB Callable 31330MS5 2.625% 05/03/18 08/03/20 1.59 2.656% $ 3,000,000.00 $ 2,998,050.00
<br />FFCB Callable 3133EHUE1 1.650% 03/19/18 08/10/20 1.61 2.372% $ 2,000,000.00 $ 1,966,600.00
<br />Treasury Note ; 912828NT3 2.625% 12/07/18 08/15/20 1.62 2.747% $ _ 2,000,000.00 $ 1,995,937.50
<br />FHLB Callable 3130ACTKO 1.875% 03/19/18 08/25/20 1.65 2.37996 $ 3,000,000.00 $ 2,964,420.00
<br />FHLMC Callable 313468025 1.700% 11/30/18 08/28/20 1.66 2.817% $ 3,000,000.00 $ 2,943,300.00
<br />Treasury Note 9128284Y3 2.625% 12/07/18 08/31/20 1.67 2.746% $ 2,000,000.00 $ 1,995,885.00
<br />Treasury Note 912828W9 2.125% 08/01/18 08/31/20 1.67 2.676% $ 3,000,000.00 $ 2,966,700.00 $ 18,000,000.00
<br />FHLB Bullet 3130A66T9 1.625% 12/12/18 09/11/20 1.70 2.792% $ 3,000,000.00 $ 2,940,660.00
<br />FNMA Callable 313663686 1.450% 04/30/18 09/15/20 1.71 2.610% $ 3,000,000.00 $ 2,920,320.00
<br />FFCB Callable 3133EGVK8 1.350% 05/10/18 09/21/20 1.73 2.661% $ 3,000,000.00 $ 2,910,450.00
<br />FHLMC 3134GSXS9 2.750% 09/28/18 09/28/20 1.75 2.750% $ 3,000,000.00 $ 3,000,000.00
<br />FHLB Callable 3130ADSFO 2.50096 03/29/18 09/29/20 1.75 2.500% $ 3,000,000.00 $ 3,000,000.00
<br />Treasury Note 912828582 2.750% 12/07/18 09/30/20 1.75 2.751% $ 3,000,000.00 $ 2,999,850.00 $ 18,000,000.00
<br />FFCB Callable 3133EGXU4 1.370% 05/10/18 10/06/20 1.77 2.665% $ 3,000,000.00 $ 2,910,000.00
<br />Treasury Note 9128282Z2 1.625% 09/10/18 10/15/20 1.79 2.709% $ 3,000,000.00 $ 2,934,120.00
<br />FHLB Callable 3130AF4R5 3.000% 10/30/18 10/30/20 1.83 3.000% $ 3,000,000.00 $ 3,000,000.00
<br />Treasury Note 912828WC0 1.750% 09/10/18 10/31/20 1.84 2.707% $ 3,000,000.00 $ 2,940,690.00 $ 12,000,000.00
<br />FFCB Callable 3133EJMX4 2.680% 05/10/18 11/02/20 1.84 2.701% $ 3,000,000.00 $ 2,998,500.00
<br />FFCB Callable 3133E6 F42 1.360% 05/10/18 11/09/20 1.86 2.655% $ 3,000,000.00 $ 2,906,700.00 $ 6,000,000.00
<br />Treasury Note 9128283Q1 2.000% 12/18/18 01/15/21 2.04 2.685% $ 3,000,000.00 $ 2,958,750.00
<br />FHLB Callable 3130ADG30 2.300% 11/30/18 01/26/21 2.07 2.909% $ 3,000,000.00 $ 2,962,050.00
<br />Treasury Note 912828B58 2.125% 12/18/18 01/31/21 2.09 2.686% $ 3,000,000.00 $ 2,965,500.00 $ 9,000,000.00
<br />Treasury Note 912828316 2.250% 12/21/18 02/15/21 2.13 2.656% $ 3,000,000.00 $ 2,974,650.00
<br />FHLMC Bullet 3137EAEL9 2.375% 09/21/18 02/16/21 2.13 2.873% $ 3,000,000.00 $ 2,965,500.00
<br />FNMA Bullet 313560120 1.375% 12/10/18 02/26/21 2.16 2.761% $ 3,000,000.00 $ 2,911,377.00 $ 9,000,000.00
<br />FNMA Bullet 313560U27 2.500% 11/29/18 04/13/21 2.28 2.919% $ 3,000,000.00 $ 2,971,350.00
<br />FHLMC Callable 313465980 3.000% 10/23/18 04/23/21 2.31 3.000% $ 3,000,000.00 $ 3,000,000.00 $ 6,000,000.00
<br />FH LB Callable 3130AFAR8 3.100% 11/05/18 05/05/21 2.35 3.100% $ 3,000,000.00 $ 3,000,000.00 $ 3,000,000.00
<br />Sub Total - General Investments $ 314,000,000.00 $ 311,129,098.37 $ 314,000,000.00
<br />Regions Bank Money Market $19,668,234.32
<br />Regions Lockbox Accounts $909,522.42
<br />TD Bank Checking Account $13,661,376.84
<br />BankUnited Money Market $32,113,457.33
<br />National Bank of Commerce CD 2.500% 05/11/18 05/11/20 1.36 56,222,409.61
<br />Valley National Bank Government Interest Checking $20,345,541.21
<br />Marine Bank Business Money Market $5,064,972.20
<br />FL CLASS - BOCC Funds $15,040,771.03
<br />Total General Cash & Equivalents - Unrestricted $ 424,155,383.33
<br />Restricted Cash -Bond Covenants (held by BNY/Mellon]
<br />Fidelity Institutional Treasury Money Market -Utilities Debt Service Reserve $ 38,453.85
<br />Treasury Note 912828XV77 1.250% 06/30/17 06/30/19 0.50 1.345% $1,610,000.00 $1,599,937.50
<br />Treasury Note 912828R93 2.500% 07/02/18 06/30/20 1.50 2.538% $1,525,000.00 $1,523,810.50
<br />Treasury Note 9128285Q95 2.750% 11/30/18 11/30/20 1.92 2.836% $i,045,000.00 51,049,733.85
<br />Total Restricted Bond Reserve - adjusted for fair market value $ 4,211,935.70
<br />Restricted Cash - Landfill
<br />FL CLASS -Landfill Closure & Postclosure Reserves
<br />Total Pooled Cash & Equivalents
<br />Restricted Cash - Health Insurance
<br />TD Bank - BCBS Claims Account
<br />Citibank - BCBS Imprest Acct
<br />Total Restricted Cash - Health Insurance
<br />Restricted Cash - Housing Account
<br />Total Portfolio
<br />Note: See separate Investment report for OPEB funds.
<br />2 oft
<br />$ 13,097,265.71
<br />$ 441,464,584.74
<br />52,369,673.01
<br />584,000.00
<br />52,453,673.01
<br />5349,843.35
<br />$ 444,268,101.10
<br />23
<br />
|