Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Investment Report, 2018 1st Quarter
COMPLIANCE STATEMENT The investment portfolio presented in these reports conforms in all respects to the investment policies of the City of Paris, all relevant provisions of the Publ ic Funds Investment Act, and is being managed under the investment strategy developed and approved by the govern ing board of the City of Paris. 2), s:. ~---- W. E. Anderson, Finance Director Date 1/30/2019 Tracker Report City of Paris Transactions Summary QUARTERLY Transaction Summary -Detail Group By: Action Portfolio / Report Group: All Portfolios Begin Date: 01/01/2018, End Date: 03/31/2018 YTM Portfolio @ Trade Settlement Maturity Face Description CU SIP/Ticker Name Cost Date Date Date Amount/Shares Principal Price Interest/Dividends Total Buy FHLB 0.875 GO Bds 6/29/2018 3130A8BD4 2017 Const. 1.675 3/20/2018 3/20/2018 6/29/2018 7,000,000.00 6,984,600.00 99.78 13,781.25 6,998,381 .25 Fund FNMAMBS COP Water 2.5 31417C3C7 Contract 2.500 3/14/2018 3/19/2018 9/21 /2027 229,559.71 229,559.71 100 286.95 229,846.66 9/21/2027 FNMAMBS COP PEG 2.5 31417C3C7 Account 2.519 3/14/2018 3/19/2018 9/21 /2027 170,044.23 169,778.54 99.843752 212.56 169,991 .10 9/21/2027 FNMAMBS COP 1992 2.5 31417C3C7 Water& 2.500 3/14/2018 3/19/2018 9/21/2027 999,009.84 999,009.84 100 1,248.76 1,000,258.60 9/21/2027 Sewer Bond T-Bill 0 COP Water 5/31/2018 912796PH6 and Sewer 1.360 2/5/2018 2/6/2018 5/31/2018 1,000,000.00 995,770.00 99.577 0.00 995,770.00 Fund T-Bill0 COP 5/31/2018 912796PH6 General 1.360 2/5/2018 2/6/2018 5/31 /2018 4,000,000.00 3,983,080.00 99.577 0.00 3,983,080.00 Fund Sub Total I 13,398,613.78 13,361,798.09 15,529.52 13,377,327.61 Average Deposit Raymond COP 1992 James-GIP MM9236 Water& 0.000 3/31/2018 3/31/2018 N/A 4,764.38 4,764.38 100 0.00 4,764.38 MM Sewer Bond Raymond COP 1992 James-GIP MM9236 Water& 0.000 3/31 /2018 3/31/2018 N/A 53,001 .76 53,001.76 100 0.00 53,001 .76 MM Sewer Bond Raymond COP 1992 James-GIP MM9236 Water& 0.000 3/31/2018 3/31/2018 N/A 998,697.65 998,697.65 100 0.00 998,697.65 MM Sewer Bond Raymond COP Water James-GIP MM9217 Contract 0.000 3/31/2018 3/31/2018 N/A 1,273.71 1,273.71 100 0.00 1,273.71 MM Raymond COP Water James-GIP MM9217 Contract 0.000 3/31/2018 3/31/2018 N/A 13,759.43 13,759.43 100 0.00 13,759.43 MM Raymond COP Water James -CIP MM9217 Contract 0.000 3/31/2018 3/31/2018 N/A 229,487.97 229,487.97 100 0.00 229,487.97 MM Raymond Water& James -CIP MM9241 Sewer 0.000 3/31/2018 3/31/2018 N/A 2,607.00 2,607.00 100 0.00 2,607.00 MM Contingency Raymond Water& James -CIP MM9241 Sewer 0.000 3/31/2018 3/31/2018 N/A 30,088.00 30,088.00 100 0.00 30,088.00 MM Contingency Raymond COP James -CIP MM5517 Community 0.000 3/31/2018 3/31/2018 N/A 43.98 43.98 100 0.00 43.98 MM Development Raymond COP James-GIP MM5517 Community 0.000 3/31/2018 3/31/2018 N/A 2,178.75 2,178.75 100 0.00 2,178.75 MM Development Raymond COP James-GIP MM9279 General 0.000 3/31/2018 3/31/2018 N/A 120.05 120.05 100 0.00 120.05 MM Fund Raymond COP James-GIP MM9279 General 0.000 3/31/2018 3/31/2018 N/A 3,212.68 3,212.68 100 0.00 3,212.68 MM Fund Raymond COP James-GIP MM9279 General 0.000 3/31/2018 3/31/2018 N/A 5,000,000.00 5,000,000.00 100 0.00 5,000,000.00 MM Fund https://v4.tracker.us.com/Apps/PrintBW.aspx 1/10 1/30/2019 Tracker Report YTM Portfolio @ Trade Settlement Maturity Face Description CU SIP/Ticker Name Cost Date Date Date Amount/Shares Principal Price Interest/Dividends Total Raymond COP 1992 James -CIP MM9236 Water& 0.000 2/28/2018 2/28/2018 N/A 4,871.86 4,871 .86 100 0.00 4,871 .86 MM Sewer Bond Raymond COP 1992 James-CIP MM9236 Water& 0.000 2/28/2018 2/28/2018 N/A 54,671.20 54,671 .20 100 0.00 54,671.20 MM Sewer Bond Raymond COP Water James-CIP MM9217 Contract 0.000 2/28/2018 2/28/2018 N/A 1,302.17 1,302.17 100 0.00 1,302.17 MM Raymond COP Water James -CIP MM9217 Contract 0.000 2/28/2018 2/28/2018 N/A 14,448.53 14,448.53 100 0.00 14,448.53 MM Raymond Water& James -CIP MM9241 Sewer 0 .000 2/28/2018 2/28/2018 N/A 2,667.97 2,667.97 100 0.00 2,667.97 MM Contingency Raymond Water& James -GIP MM9241 Sewer 0.000 2/28/2018 2/28/2018 N/A 33,192.51 33,192.51 100 0.00 33,192.51 MM Contingency Raymond COP James -GIP MM5517 Community 0.000 2/28/2018 2/28/2018 N/A 48.99 48.99 100 0.00 48.99 MM Development Raymond COP James -GIP MM5517 Community 0.000 2/28/2018 2/28/2018 N/A 1,504.04 1,504.04 100 0.00 1,504.04 MM Development Raymond COP James -GIP MM9279 General 0.000 2/28/2018 2/28/2018 N/A 126.46 126.46 100 0.00 126.46 MM Fund Raymond COP James -GIP MM9279 General 0.000 2/28/2018 2/28/2018 N/A 3,082.56 3,082.56 100 0.00 3,082.56 MM Fund Raymond COP James -CIP MM9279 General 0.000 2/28/2018 2/28/2018 N/A 3,983,080.00 3,983,080.00 100 0.00 3,983,080.00 MM Fund Raymond COP 1992 James -GIP MM9236 Water& 0.000 1/31 /2018 1/31/2018 N/A 4,991.77 4,991.77 100 0.00 4,991.77 MM Sewer Bond Raymond COP 1992 James-GIP MM9236 Water& 0.000 1/31/2018 1/31/2018 N/A 59,885.45 59,885.45 100 0.00 59,885.45 MM Sewer Bond Raymond COP Water James -CIP MM921 7 Contract 0.000 1/31/2018 1/31/2018 N/A 1,332.23 1,332.23 100 0.00 1,332.23 MM Raymond COP Water James-GIP MM9217 Contract 0.000 1/31/2018 1/31/2018 N/A 15,068.40 15,068.40 100 0.00 15,068.40 MM Raymond Water& James-CIP MM9241 Sewer 0.000 1/31/2018 1/31/2018 N/A 2,734.30 2,734.30 100 0.00 2,734.30 MM Contingency Raymond Water& James-GIP MM9241 Sewer 0.000 1/31/2018 1/31/2018 N/A 35,159.27 35,159.27 100 0.00 35,159.27 MM Contingency Raymond COP James -GIP MM5517 Community 0.000 1/31/2018 1/31/2018 N/A 54.58 54.58 100 0.00 54.58 MM Development Raymond COP James-CIP MM5517 Community 0.000 1/31/2018 1/31/2018 N/A 1,675.24 1,675.24 100 0.00 1,675.24 MM Development Raymond COP James-CIP MM9279 General 0.000 1/30/2018 1/30/2018 N/A 131.45 131.45 100 0.00 131.45 MM Fund Raymond COP James -CIP MM9279 General 0.000 1/30/2018 1/30/2018 N/A 2,224.87 2,224.87 100 0.00 2,224.87 MM Fund Raymond COP PEG James -DP MM9914 Account 0.000 3/31/2018 3/31/2018 N/A 614.41 614.41 100 0.00 614.41 MM Raymond COP PEG James -DP MM9914 Account 0.000 3/31/2018 3/31/2018 N/A 4,812.55 4,812.55 100 0.00 4,812.55 MM Raymond COP PEG James -DP MM9914 Account 0.000 3/31/2018 3/31/2018 N/A 169,991.10 169,991 .10 100 0.00 169,991.10 MM https://v4.tracker.us.com/Apps/PrintBW.aspx 2/10 1/30/2019 Tracker Report YTM Portfolio @ Trade Settlement Maturity Face Description CU SIP/Ticker Name Cost Date Date Date Amount/Shares Principal Price Interest/Dividends Total Raymond COP PEG James -DP MM9914 Account 0.000 2/28/2018 2/28/2018 N/A 624.95 624.95 100 0.00 624.95 MM Raymond COP PEG James-DP MM9914 Account 0 .000 2/28/2018 2/28/2018 N/A 5,054.84 5,054.84 100 0.00 5,054.84 MM Raymond COP PEG James -DP MM9914 Account 0.000 1/31/2018 1/31/2018 N/A 643.20 643.20 100 0.00 643.20 MM Raymond COP PEG James -DP MM9914 Account 0.000 1/31/2018 1/31/2018 N/A 8,726.38 8,726.38 100 0.00 8,726.38 MM Raymond GO Bds MMW438 2016 Const. 0.000 3/31 /2018 3/31 /2018 N/A 42,698.76 42,698.76 100 0.00 42,698.76 James MM Fund Raymond GO Bds MMW438 2016 Const. 0.000 3/31 /2018 3/31 /2018 N/A 4,000,000.00 4,000,000.00 100 0.00 4,000,000.00 James MM Fund Raymond GO Bds MMM526 2017 Const. 0.000 3/31/2018 3/31/2018 N/A 40,396.47 40,396.47 100 0.00 40,396.47 James MM Fund Raymond GO Bds MMM526 2017 Const. 0.000 3/31 /2018 3/31/2018 N/A 6,998,381.25 6,998,381.25 100 0.00 6,998,381.25 James MM Fund Raymond GO Bds MMM526 2017 Const. 0.000 3/31/2018 3/31/2018 N/A 8,000,000.00 8,000,000.00 100 0.00 8,000,000.00 James MM Fund Raymond COP Water James-GIP MM5281 and Sewer 0.000 2/28/2018 2/28/2018 N/A 995,770.00 995,770.00 100 0.00 995,770.00 MM Fund Sub Total I 30,829,203.12 30,829,203.12 0.00 30,829,203.12 Average Interest FHLB 1 GO Bds 3/9/2018 3130AAXT0 2016 Const. 0.000 3/9/2018 3/9/2018 3/9/2018 0.00 0.00 20,000.00 20,000.00 Fund FHLB 1.125 GO Bds 9/14/2018 3130A6AE7 2016 Const. 0.000 3/14/2018 3/14/2018 9/14/2018 0.00 0.00 22,500.00 22,500.00 Fund FHLMC COP 1992 MBS 1.5 3137GA2D8 Water& 0.000 3/1/2018 3/1 /2018 8/15/2020 0.00 0.00 43.95 43.95 8/15/2020 Sewer Bond FHLMC COP 1992 MBS 1.5 3137GA2D8 Water& 0.000 2/1 /2018 2/1/2018 8/15/2020 0.00 0.00 46.37 46.37 8/15/2020 Sewer Bond FNMAMBS Water & 23/1/2023 31417FQT8 Sewer 0.000 3/1 /2018 3/1/2018 3/1/2023 0.00 0.00 83.78 83.78 Contingency FNMAMBS COP 23/1/2023 31417FQT8 General 0.000 3/1 /2018 3/1 /2018 3/1/2023 0.00 0.00 104.72 104.72 Fund FNMAMBS COP 1992 23/1/2023 31417FQT8 Water& 0.000 3/1 /2018 3/1/2018 3/1/2023 0.00 0.00 303.69 303.69 Sewer Bond FNMAMBS 31418ARF7 COP Water 0.000 3/1 /2018 3/1/2018 3/1/2023 0.00 0.00 208.61 208.61 23/1/2023 Contract FNMAMBS Water& 23/1/2023 31418ARF7 Sewer 0.000 3/1 /2018 3/1 /2018 3/1/2023 0.00 0.00 404.18 404.18 Contingency FNMAMBS COP 1992 23/1/2023 31418ARF7 Water& 0.000 3/1 /2018 3/1/2018 3/1/2023 0.00 0.00 480.85 480.85 Sewer Bond FNMAMBS Water& 23/1/2023 31417FQT8 Sewer 0.000 2/1 /2018 2/1/2018 3/1/2023 0.00 0.00 86.87 86.87 Contingency FNMAMBS COP 23/1/2023 31417FQT8 General 0.000 2/1 /2018 2/1/2018 3/1/2023 0.00 0.00 108.59 108.59 Fund FNMAMBS COP 1992 31417FQT8 Water& 0.000 2/1/2018 2/1/2018 3/1/2023 0.00 0.00 314.90 314.90 23/1/2023 Sewer Bond https://v4 .tracker.us.com/ Apps/PrintBW.aspx 3/10 1/30/2019 Tracker Report YTM Portfolio @ Trade Settlement Maturity Face Description CU SIP/Ticker Name Cost Date Date Date Amount/Shares Principal Price Interest/Dividends Total FNMAMBS 31418ARF7 COP Water 0.000 2/1/2018 2/1 /2018 3/1/2023 0.00 0.00 215.20 215.20 23/1/2023 Contract FNMAMBS Water& 23/1/2023 31418ARF7 Sewer 0.000 2/1/2018 2/1/2018 3/1/2023 0.00 0.00 416.95 416.95 Contingency FNMAMBS COP 1992 23/1/2023 31418ARF7 Water& 0.000 2/1/2018 2/1/2018 3/1/2023 0.00 0.00 496.04 496.04 Sewer Bond FNMAMBS Water& 27/1/2023 31418AU22 Sewer 0.000 3/1/2018 3/1/2018 7/1/2023 0.00 0.00 518.51 518.51 Contingency FNMAMBS Water& 27/1/2023 31418AU22 Sewer 0.000 2/1/2018 2/1/2018 7/1/2023 0.00 0.00 534.21 534.21 Contingency FNMAMBS COP Water 2.5 31418AZ35 Contract 0.000 3/1/2018 3/1/2018 11/1/2023 0.00 0.00 385.79 385.79 11/1/2023 FNMAMBS Water& 2.5 31418AZ35 Sewer 0.000 3/1/2018 3/1/2018 11/1/2023 0.00 0.00 419.50 419.50 11/1/2023 Contingency FNMAMBS COP 1992 2.5 31418AZ35 Water& 0.000 3/1/2018 3/1/2018 11/1/2023 0.00 0.00 666.70 666.70 11/1/2023 Sewer Bond FNMAMBS COP Water 2.5 31418AZ35 Contract 0.000 2/1/2018 2/1 /2018 11/1/2023 0.00 0.00 396.41 396.41 11/1/2023 FNMAMBS Water& 2.5 31418AZ35 Sewer 0.000 2/1/2018 2/1 /2018 11/1/2023 0.00 0.00 431 .05 431 .05 11/1/2023 Contingency FNMAMBS COP 1992 2.5 31418AZ35 Water& 0.000 2/1/2018 2/1/2018 11/1/2023 0.00 0.00 685.06 685.06 11/1/2023 Sewer Bond FNMAMBS 31418BBA3 COP Water 0.000 3/25/2018 3/25/2018 3/1/2024 0.00 0.00 81.83 81.83 2.5 3/1/2024 Contract FNMAMBS COP 1992 2.5 3/1/2024 31418BBA3 Water& 0.000 3/25/2018 3/25/2018 3/1/2024 0.00 0.00 396.90 396.90 Sewer Bond FNMAMBS 31418BBA3 COP Water 0.000 2/25/2018 2/25/2018 3/1/2024 0.00 0.00 84.13 84.13 2.5 3/1 /2024 Contract FNMAMBS COP 1992 2.5 3/1 /2024 31418BBA3 Water& 0.000 2/25/2018 2/25/2018 3/1/2024 0.00 0.00 408.05 408.05 Sewer Bond FNMAMBS 31418BBA3 COP Water 0.000 1/25/2018 1/25/2018 3/1/2024 0.00 0.00 86.11 86.11 2.5 3/1 /2024 Contract FNMAMBS COP 1992 2.5 3/1/2024 31418BBA3 Water& 0.000 1/25/2018 1/25/2018 3/1/2024 0.00 0.00 417.66 417.66 Sewer Bond FNMAMBS 31418BZS8 COP Water 0.000 3/1/2018 3/1/2018 3/1/2026 0.00 0.00 233.47 233.47 2.5 3/1 /2026 Contract FNMAMBS Water& 2.5 3/1 /2026 31418BZS8 Sewer 0.000 3/1/2018 3/1/2018 3/1/2026 0.00 0.00 377.68 377.68 Contingency FNMAMBS COP 1992 2.5 3/1 /2026 31418BZS8 Water& 0.000 3/1/2018 3/1 /2018 3/1/2026 0.00 0.00 920.16 920.16 Sewer Bond FNMA MBS 31418BZS8 COP Water 0.000 2/1/2018 2/1/2018 3/1/2026 0.00 0.00 236.72 236.72 2.5 3/1 /2026 Contract FNMAMBS Water& 2.5 3/1/2026 31418BZS8 Sewer 0.000 2/1/2018 2/1/2018 3/1/2026 0.00 0.00 382.94 382.94 Contingency FNMAMBS COP 1992 31418BZS8 Water& 0.000 2/1/201 8 2/1/2018 3/1/2026 0.00 0.00 932.97 932.97 2.5 3/1/2026 Sewer Bond FNMAMBS 31418CJK1 COP Water 0.000 3/1/2018 3/1/2018 4/1/2027 0.00 0.00 200.57 200.57 2.5 4/1 /2027 Contract FNMAMBS Water& 31418CJK1 Sewer 0.000 3/1/201 8 3/1/2018 4/1/2027 0.00 0.00 320.56 320.56 2.5 4/1/2027 Contingency FNMAMBS COP 1992 31418CJK1 Water& 0.000 3/1/2018 3/1/2018 4/1/2027 0.00 0.00 553.37 553.37 2.5 4/1 /2027 Sewer Bond https://v4.tracker.us.com/Apps/PrintBW.aspx 4/10 1/30/2019 Tracker Report YTM Portfolio @ Trade Settlement Maturity Face Description CUSIP/Ticker Name Cost Date Date Date Amount/Shares Principal Price Interest/Dividends Total FNMAMBS 31418CJK1 COP Water 0.000 2/1/2018 2/1/2018 4/1/2027 0.00 0.00 203.46 203.46 2.5 4/1/2027 Contract FNMAMBS Water& 2.5 4/1/2027 31418CJK1 Sewer 0.000 2/1/2018 2/1/2018 4/1/2027 0.00 0.00 325.18 325.18 Contingency FNMAMBS COP 1992 2.5 4/1/2027 31418CJK1 Water& 0.000 2/1/2018 2/1/2018 4/1/2027 0.00 0.00 561 .34 561.34 Sewer Bond FNMAMBS 3138WHT85 COP Water 0.000 3/1/2018 3/1/2018 8/1/2026 0.00 0.00 163.32 163.32 2.5 8/1/2026 Contract FNMAMBS Water& 2.5 8/1/2026 3138WHT85 Sewer 0.000 3/1/2018 3/1/201 8 8/1/2026 0.00 0.00 482.18 482.18 Contingency FNMAMBS 3138WHT85 COP PEG 0.000 3/1/2018 3/1/2018 8/1/2026 0.00 0.00 614.39 614.39 2.5 8/1/2026 Account FNMAMBS COP 1992 2.5 8/1/2026 3138WHT85 Water& 0.000 3/1/2018 3/1/2018 8/1/2026 0.00 0.00 1,290.99 1,290.99 Sewer Bond FNMAMBS 3138WHT85 COP Water 0.000 2/1/2018 2/1/2018 8/1/2026 0.00 0.00 166.12 166.12 2.5 8/1/2026 Contract FNMAMBS Water& 2.5 8/1/2026 3138WHT85 Sewer 0.000 2/1/2018 2/1/2018 8/1/2026 0.00 0.00 490.44 490.44 Contingency FNMAMBS 3138WHT85 COP PEG 0.000 2/1/2018 2/1/2018 8/1/2026 0.00 0.00 624.92 624.92 2.5 8/1/2026 Account FNMAMBS COP 1992 2.5 8/1/2026 3138WHT85 Water& 0.000 2/1/2018 2/1/2018 8/1/2026 0.00 0.00 1,313.12 1,313.12 Sewer Bond FNMAMBS COP 1992 3.5 31417YTE7 Water& 0.000 3/1/2018 3/1/2018 10/1/2020 0.00 0.00 107.30 107.30 10/1/2020 Sewer Bond FNMAMBS COP 1992 3.5 31417YTE7 Water& 0.000 2/1/2018 2/1/2018 10/1/2020 0.00 0.00 113.52 113.52 10/1/2020 Sewer Bond GNMAMBS COP 4 9/20/2018 36202DZA2 General 0.000 3/1/2018 3/1/2018 9/20/2018 0.00 0.00 15.31 15.31 Fund GNMAMBS COP 4 9/20/2018 36202DZA2 General 0.000 2/1/2018 2/1/2018 9/20/2018 0.00 0.00 17.85 17.85 Fund GNMAMBS COP 4 9/20/2019 36202EBM0 Community 0.000 3/1/2018 3/1/2018 9/20/2019 0.00 0.00 43.98 43.98 Development GNMAMBS COP 4 9/20/2019 36202EBM0 Community 0.000 2/1/2018 2/1/2018 9/20/2019 0.00 0.00 48.99 48.99 Development T-Note 1 GOBds 3/15/2018 912828J68 2017 Const. 0.000 3/15/2018 3/15/2018 3/15/2018 0.00 0.00 40,000.00 40,000.00 Fund Sub Total I 0.00 0.00 102,067.46 102,067.46 Average Matured FHLB 1 GO Bds 3/9/2018 3130AAXT0 2016 Const. 0.000 3/9/2018 3/9/2018 3/9/2018 4,000,000.00 4,000,000.00 0 0.00 4,000,000.00 Fund T-Bill0 COP 3/29/2018 912796LS6 ·General 0.000 3/29/2018 3/29/2018 3/29/2018 5,000,000.00 5,000,000.00 0 0.00 5,000,000.00 Fund T-Note 1 GO Bds 3/15/2018 912828J68 2017 Const. 0.000 3/15/2018 3/15/2018 3/15/2018 8,000,000.00 8,000,000.00 0 0.00 8,000,000.00 Fund Sub Total/ 17,000,000.00 17,000,000.00 0.00 17,000,000.00 Average Principal Pay Down FHLMC COP 1992 MBS 1.5 3137GA2D8 Water& 0.000 3/30/2018 3/30/2018 8/15/2020 1,993.43 1,993.43 0 0.00 1,993.43 8/15/2020 Sewer Bond FHLMC COP 1992 MBS 1.5 3137GA2D8 Water& 0.000 2/28/2018 2/28/2018 8/15/2020 1,936.00 1,936.00 0 0.00 1,936.00 8/15/2020 Sewer Bond https://v4.tracker.us.com/Apps/PrintBW.aspx 5/10 1/30/2019 Tracker Report YTM Portfolio @ Trade Settlement Maturity Face Description CU SIP/Ticker Name Cost Date Date Date Amount/Shares Principal Price Interest/Dividends Total FHLMC COP 1992 MBS 1.5 3137GA2D8 Water& 0.000 1/31/2018 1/31/2018 8/15/2020 2,238.31 2,238.31 0 0.00 2,238.31 8/15/2020 Sewer Bond FNMAMBS Water& 23/1/2023 31417FQT8 Sewer 0.000 3/31/2018 3/31/2018 3/1/2023 1,966.24 1,966.24 0 0.00 1,966.24 Contingency FNMAMBS COP 23/1/2023 31417FQT8 General 0.000 3/31/2018 3/31/2018 3/1/2023 2,457.80 2.457.80 0 0.00 2.457.80 Fund FNMAMBS COP 1992 23/1/2023 31417FQT8 Water& 0.000 3/31/2018 3/31/2018 3/1/2023 7,127.62 7,127.62 0 0.00 7,127.62 Sewer Bond FNMAMBS 31418ARF7 COP Water 0.000 3/31/2018 3/31/2018 3/1/2023 3,528.81 3,528.81 0 0.00 3,528.81 23/1/2023 Contract FNMAMBS Water& 23/1/2023 31418ARF7 Sewer 0.000 3/31/2018 3/31/2018 3/1/2023 3,082.85 3,082.85 0 0.00 3,082.85 Contingency FNMAMBS Water& 23/1/2023 31418ARF7 Sewer 0.000 3/31/2018 3/31/2018 3/1/2023 3,754.22 3,754.22 0 0.00 3,754.22 Contingency FNMAMBS COP 1992 23/1/2023 31418ARF7 Water& 0.000 3/31/2018 3/31/2018 3/1/2023 2,612.12 2,612.12 0 0.00 2,612.12 Sewer Bond FNMAMBS COP 1992 23/1/2023 31418ARF7 Water& 0.000 3/31/2018 3/31/2018 3/1/2023 5,521 .79 5,521 .79 0 0.00 5,521.79 Sewer Bond FNMAMBS Water& 23/1/2023 31417FQT8 Sewer 0.000 2/28/2018 2/28/2018 3/1/2023 1,855.32 1,855.32 0 0.00 1,855.32 Contingency FNMAMBS COP 23/1/2023 31417FQT8 General 0.000 2/28/2018 2/28/2018 3/1/2023 2,319.16 2,319.16 0 0.00 2,319.16 Fund FNMAMBS COP 1992 23/1/2023 31417FQT8 Water& 0.000 2/28/2018 2/28/2018 3/1/2023 6,725.55 6,725.55 0 0.00 6,725.55 Sewer Bond FNMAMBS 31418ARF7 COP Water 0.000 2/28/2018 2/28/2018 3/1/2023 3,954.77 3,954.77 0 0.00 3,954.77 23/1/2023 Contract FNMAMBS Water& 23/1/2023 31418ARF7 Sewer 0.000 2/28/2018 2/28/2018 3/1/2023 3,454.98 3.454.98 0 0.00 3.454.98 Contingency FNMAMBS Water& 23/1/2023 31418ARF7 Sewer 0.000 2/28/2018 2/28/2018 3/1/2023 4,207.39 4,207.39 0 0.00 4,207.39 Contingency FNMAMBS COP 1992 23/1/2023 31418ARF7 Water& 0.000 2/28/2018 2/28/2018 3/1/2023 2,927.43 2,927.43 0 0.00 2,927.43 Sewer Bond FNMAMBS COP 1992 23/1/2023 31418ARF7 Water& 0.000 2/28/2018 2/28/2018 3/1/2023 6,188.32 6,188.32 0 0.00 6,188.32 Sewer Bond FNMAMBS Water& 23/1/2023 31417FQT8 Sewer 0.000 1/31/2018 1/31/2018 3/1/2023 1,162.97 1,162.97 0 0.00 1,162.97 Contingency FNMAMBS COP 23/1/2023 31417FQT8 General 0.000 1/31/2018 1/31/2018 3/1/2023 1.453.71 1.453.71 0 0.00 1,453.71 Fund FNMAMBS COP 1992 23/1/2023 31417FQT8 Water& 0.000 1/31/2018 1/31/2018 3/1/2023 4,215.76 4,215.76 0 0.00 4,215.76 Sewer Bond FNMAMBS 31418ARF7 COP Water 0.000 1/31/2018 1/31/2018 3/1/2023 3,765.76 3,765.76 0 0.00 3,765.76 23/1/2023 Contract FNMA MBS Water& 23/1/2023 31418ARF7 Sewer 0.000 1/31/2018 1/31/2018 3/1/2023 3,289.86 3,289.86 0 0.00 3,289.86 Contingency FNMAMBS Water& 23/1/2023 31418ARF7 Sewer 0.000 1/31/2018 1/31/2018 3/1/2023 4,006.31 4,006.31 0 0.00 4,006.31 Contingency FNMAMBS COP 1992 23/1/2023 31418ARF7 Water& 0.000 1/31/2018 1/31/2018 3/1/2023 2,787.52 2,787.52 0 0.00 2,787.52 Sewer Bond FNMAMBS COP 1992 23/1/2023 31418ARF7 Water& 0.000 1/31/2018 1/31/2018 3/1/2023 5,892.57 5,892.57 0 0.00 5,892.57 Sewer Bond https://v4.tracker.us.com/Apps/PrintBW.aspx 6/10 1/30/2019 Tracker Report YTM Portfolio @ Trade Settlement Maturity Face Description CUSIPfTicker Name Cost Date Date Date Amount/Shares Principal Price Interest/Dividends Total FNMAMBS Water& 27/1/2023 31418AU22 Sewer 0.000 3/31 /2018 3/31/2018 7/1/2023 2,918.99 2,918.99 0 0.00 2,918.99 Contingency FNMAMBS Water& 27/1/2023 31418AU22 Sewer 0.000 3/31/2018 3/31/2018 7/1/2023 4,593.85 4,593.85 0 0.00 4,593.85 Contingency FNMAMBS Water& 27/1/2023 31418AU22 Sewer 0.000 2/28/2018 2/28/2018 7/1/2023 3,660.91 3,660.91 0 0.00 3,660.91 Contingency FNMAMBS Water& 27/1/2023 31418AU22 Sewer 0.000 2/28/2018 2/28/2018 7/1/2023 5,761.46 5,761.46 0 0.00 5,761.46 Contingency FNMAMBS Water& 27/1/2023 31418AU22 Sewer 0.000 1/31/2018 1/31/2018 7/1/2023 3,621.65 3,621.65 0 0.00 3,621.65 Contingency FNMAMBS Water& 27/1/2023 31418AU22 Sewer 0.000 1/31/2018 1/31/2018 7/1/2023 5,699.68 5,699.68 0 0.00 5,699.68 Contingency FNMAMBS COP Water 2.5 31418AZ35 Contract 0.000 3/31/2018 3/31/2018 11/1/2023 4,967.76 4,967.76 0 0.00 4,967.76 11/1/2023 FNMAMBS Water& 2.5 31418AZ35 Sewer 0.000 3/31/2018 3/31/2018 11/1/2023 5,401 .83 5,401.83 0 0.00 5,401.83 11/1/2023 Contingency FNMAMBS COP 1992 2.5 31418AZ35 Water& 0.000 3/31/2018 3/31/2018 11/1/2023 8,585.06 8,585.06 0 0.00 8,585.06 11/1/2023 Sewer Bond FNMAMBS COP Water 2.5 31418AZ35 Contract 0.000 2/28/2018 2/28/2018 11/1/2023 5,099.38 5,099.38 0 0.00 5,099.38 11/1/2023 FNMAMBS Water& 2.5 31418AZ35 Sewer 0.000 2/28/2018 2/28/2018 11/1/2023 5,544.96 5,544.96 0 0.00 5,544.96 11/1/2023 Contingency FNMAMBS COP 1992 2.5 31418AZ35 Water& 0.000 2/28/2018 2/28/2018 11/1/2023 8,812.52 8,812.52 0 0.00 8,812.52 11/1/2023 Sewer Bond FNMAMBS COP Water 2.5 31418AZ35 Contract 0.000 1/31/2018 1/31/2018 11/1/2023 4,593.52 4,593.52 0 0.00 4,593.52 11 /1/2023 FNMA MBS Water& 2.5 31418AZ35 Sewer 0.000 1/31/2018 1/31/2018 11/1/2023 4,994.89 4,994.89 0 0.00 4,994.89 11 /1/2023 Contingency FNMAMBS COP 1992 2.5 31418AZ35 Water& 0.000 1/31/2018 1/31 /2018 11/1/2023 7,938.31 7,938.31 0 0.00 7,938.31 11/1/2023 Sewer Bond FNMAMBS 31418BBA3 COP Water 0.000 3/31/2018 3/31 /2018 3/1/2024 1,128.43 1,128.43 0 0.00 1,128.43 2.5 3/1 /2024 Contract FNMAMBS COP 1992 2.5 3/1 /2024 31418BBA3 Water& 0.000 3/31/2018 3/31 /2018 3/1/2024 5,472.86 5,472.86 0 0.00 5,472.86 Sewer Bond FNMAMBS 31418BBA3 COP Water 0.000 2/28/2018 2/28/2018 3/1/2024 1,103.60 1,103.60 0 0.00 1,103.60 2.5 3/1/2024 Contract FNMAMBS COP 1992 2.5 3/1/2024 31418BBA3 Water& 0.000 2/28/2018 2/28/2018 3/1/2024 5,352.46 5,352.46 0 0.00 5,352.46 Sewer Bond FNMAMBS 31418BBA3 COP Water 0.000 1/31/2018 1/31 /2018 3/1/2024 951 .14 951 .14 0 0.00 951.14 2.5 3/1 /2024 Contract FNMAMBS COP 1992 2.5 3/1 /2024 31418BBA3 Water& 0.000 1/31/2018 1/31 /2018 3/1/2024 4,613.00 4,61 3.00 0 0.00 4,613.00 Sewer Bond FNMAMBS 31418BZS8 COP Water 0.000 3/31/2018 3/31 /2018 3/1/2026 1,541 .52 1,541 .52 0 0.00 1,541.52 2.5 3/1 /2026 Contract FNMAMBS Water& 2.5 3/1/2026 31418BZS8 Sewer 0.000 3/31/2018 3/31 /2018 3/1/2026 2,493.64 2,493.64 0 0.00 2,493.64 Contingency FNMAMBS COP 1992 2.5 3/1 /2026 31418BZS8 Water& 0.000 3/31/2018 3/31 /2018 3/1/2026 6,075.41 6,075.41 0 0.00 6,075.41 Sewer Bond FNMAMBS 31418BZS8 COP Water 0.000 2/28/2018 2/28/2018 3/1/2026 1,560.22 1,560.22 0 0.00 1,560.22 2.5 3/1/2026 Contract FNMAMBS Water& 2.5 3/1/2026 31418BZS8 Sewer 0.000 2/28/2018 2/28/2018 3/1/2026 2,523.88 2,523.88 0 0.00 2,523.88 Contingency https://v4.tracker.us.com/Apps/PrintBW.aspx 7/10 1/30/2019 Tracker Report YTM Portfolio @ Trade Settlement Maturity Face Description CUSIP!Ticker Name Cost Date Date Date Amount/Shares Principal Price Interest/Dividends Total FNMAMBS COP 1992 2.5 3/1/2026 31418BZS8 Water& 0.000 2/28/2018 2/28/2018 3/1/2026 6,149.10 6,149.10 0 0.00 6,149.10 Sewer Bond FNMAMBS 31418BZS8 COP Water 0.000 1/31/2018 1/31/2018 3/1/2026 2,068.41 2,068.41 0 0.00 2,068.41 2.5 3/1/2026 Contract FNMAMBS Water& 2.5 3/1/2026 31418BZS8 Sewer 0.000 1/31/2018 1/31/2018 3/1/2026 3,345.96 3,345.96 0 0.00 3,345.96 Contingency FNMAMBS COP 1992 2.5 3/1/2026 31418BZS8 Water& 0.000 1/31/2018 1/31/2018 3/1/2026 8,151.98 8,151 .98 0 0.00 8,151.98 Sewer Bond FNMAMBS 31418CJK1 COP Water 0.000 3/31/2018 3/31/2018 4/1/2027 1,31 3.62 1,313.62 0 0.00 1,313.62 2.5 4/1/2027 Contract FNMAMBS Water& 2.5 4/1/2027 31418CJK1 Sewer 0.000 3/31/2018 3/31/2018 4/1/2027 2,099.44 2,099.44 0 0.00 2,099.44 Contingency FNMAMBS COP 1992 2.5 4/1/2027 31418CJK1 Water& 0.000 3/31/2018 3/31/2018 4/1/2027 3,624.17 3,624.17 0 0.00 3,624.17 Sewer Bond FNMAMBS 31418CJK1 COP Water 0.000 2/28/2018 2/28/2018 4/1/2027 1,386.87 1,386.87 0 0.00 1,386.87 2.5 4/1/2027 Contract FNMAMBS Water& 2.5 4/1/2027 31418CJK1 Sewer 0.000 2/28/2018 2/28/2018 4/1/2027 2,216.52 2,216.52 0 0.00 2,216.52 Contingency FNMAMBS COP 1992 2.5 4/1/2027 31418CJK1 Water& 0.000 2/28/2018 2/28/2018 4/1/2027 3,826.29 3,826.29 0 0.00 3,826.29 Sewer Bond FNMAMBS 31418CJK1 COP Water 0.000 1/31/2018 1/31/2018 4/1/2027 1,369.90 1,369.90 0 0.00 1,369.90 2.5 4/1/2027 Contract FNMAMBS Water& 2.5 4/1/2027 31418CJK1 Sewer 0.000 1/31/2018 1/31/2018 4/1/2027 2,189.40 2,189.40 0 0.00 2,189.40 Contingency FNMAMBS COP 1992 2.5 4/1/2027 31418CJK1 Water& 0.000 1/31/2018 1/31/2018 4/1/2027 3,779.46 3,779.46 0 0.00 3,779.46 Sewer Bond FNMAMBS 3138WHT85 COP Water 0.000 3/31/2018 3/31/2018 8/1/2026 1,279.29 1,279.29 0 0.00 1,279.29 2.5 8/1/2026 Contract FNMAMBS Water& 2.5 8/1/2026 3138WHT85 Sewer 0.000 3/31/2018 3/31/2018 8/1/2026 3,776.94 3,776.94 0 0.00 3,776.94 Contingency FNMAMBS 3138WHT85 COP PEG 0.000 3/31/2018 3/31 /2018 8/1/2026 4,812.55 4,812.55 0 0.00 4,812.55 2.5 8/1/2026 Account FNMAMBS COP 1992 2.5 8/1 /2026 3138WHT85 Water& 0.000 3/31/2018 3/31/2018 8/1/2026 10,112.45 10,112.45 0 0.00 10,112.45 Sewer Bond FNMA MBS 3138WHT85 COP Water 0.000 2/28/2018 2/28/2018 8/1/2026 1,343.69 1,343.69 0 0.00 1,343.69 2.5 8/1 /2026 Contract FNMAMBS Water& 2.5 8/1/2026 3138WHT85 Sewer 0.000 2/28/2018 2/28/2018 8/1/2026 3,967.09 3,967.09 0 0.00 3,967.09 Contingency FNMAMBS 3138WHT85 COP PEG 0.000 2/28/2018 2/28/2018 8/1/2026 5,054.84 5,054.84 0 0.00 5,054.84 2.5 8/1 /2026 Account FNMAMBS COP 1992 2.5 8/1 /2026 3138WHT85 Water& 0.000 2/28/2018 2/28/2018 8/1/2026 10,621.57 10,621 .57 0 0.00 10,621.57 Sewer Bond FNMAMBS 3138WHT85 COP Water 0.000 1/31/2018 1/31/2018 8/1/2026 2,319.67 2,319.67 0 0.00 2,319.67 2.5 8/1 /2026 Contract FNMAMBS Water& 2.5 8/1/2026 3138WHT85 Sewer 0.000 1/31/2018 1/31/2018 8/1/2026 6,848.55 6,848.55 0 0.00 6,848.55 Contingency FNMAMBS 3138WHT85 COP PEG 0.000 1/31/2018 1/31/2018 8/1/2026 8,726.38 8,726.38 0 0.00 8,726.38 2.5 8/1/2026 Account FNMA MBS COP 1992 2.5 8/1 /2026 3138WHT85 Water& 0.000 1/31/2018 1/31/2018 8/1/2026 18,336.43 18,336.43 0 0.00 18,336.43 Sewer Bond FNMAMBS COP 1992 3.5 31417YTE7 Water& 0.000 3/31/2018 3/31/2018 10/1/2020 1,876.85 1,876.85 0 0.00 1,876.85 10/1/2020 Sewer Bond FNMAMBS COP 1992 3.5 31417YTE7 Water& 0.000 2/28/2018 2/28/2018 10/1/2020 2,131.96 2,131 .96 0 0.00 2,131.96 10/1/2020 Sewer Bond https://v4.tracker.us.com/Apps/PrintBW.aspx 8/10 1/30/2019 Tracker Report YTM Portfolio @ Trade Settlement Maturity Face Description CU SIP/Ticker Name Cost Date Date Date Amount/Shares Principal Price Interest/Dividends Total FNMAMBS COP 1992 3.5 31417YTE7 Water& 0.000 1/31/2018 1/31/2018 10/1/2020 1,932.11 1,932.11 0 0.00 1,932.11 10/1/2020 Sewer Bond GNMAMBS COP 4 9/20/2018 36202DZA2 General 0.000 3/31/2018 3/31/2018 9/20/2018 754.88 754.88 0 0.00 754.88 Fund GNMAMBS COP 4 9/20/2018 36202DZA2 General 0.000 2/28/2018 2/28/2018 9/20/2018 763.40 763.40 0 0.00 763.40 Fund GNMAMBS COP 4 9/20/2018 36202DZA2 General 0.000 1/31/2018 1/31/2018 9/20/2018 771 .16 771 .16 0 0.00 771.16 Fund GNMAMBS COP 4 9/20/2019 36202EBM0 Community 0.000 3/31/2018 3/31/2018 9/20/2019 2,178.75 2,178.75 0 0.00 2,178.75 Development GNMAMBS COP 4 9/20/2019 36202EBM0 Community 0.000 2/28/2018 2/28/2018 9/20/2019 1,504.04 1,504.04 0 0.00 1,504.04 Development GNMAMBS COP 4 9/20/2019 36202EBM0 Community 0.000 1/31/2018 1/31/2018 9/20/2019 1,675.24 1,675.24 0 0.00 1,675.24 Development Sub Total/ 341,746.46 341,746.46 0.00 341,746.46 Average Withdraw Raymond COP 1992 James -CIP MM9236 Water& 0.000 3/31/2018 3/31/2018 N/A 67,263.73 67,263.73 0 0.00 67,263.73 MM Sewer Bond Raymond COP 1992 James -CIP MM9236 Water& 0.000 3/31/2018 3/31/2018 N/A 998,697.65 998,697.65 0 0.00 998,697.65 MM Sewer Bond Raymond COP Water James -CIP MM9217 Contract 0.000 3/31/2018 3/31/2018 N/A 20,528.94 20,528.94 0 0.00 20,528.94 MM Raymond COP Water James -CIP MM9217 Contract 0.000 3/31/2018 3/31/2018 N/A 229,487.97 229,487.97 0 0.00 229,487.97 MM Raymond Water& James -CIP MM9241 Sewer 0.000 3/31/2018 3/31/2018 NIA 38,670.75 38,670.75 0 0.00 38,670.75 MM Contingency Raymond COP James -CIP MM5517 Community 0.000 3/31/2018 3/31/2018 N/A 2,222.73 2,222.73 0 0.00 2,222.73 MM Development Raymond COP James -CIP MM9279 General 0.000 3/31/2018 3/31/2018 N/A 3,332.73 3,332.73 0 0.00 3,332.73 MM Fund Raymond COP 1992 James-CIP MM9236 Water& 0.000 2/28/2018 2/28/2018 N/A 50,046.26 50,046.26 0 0.00 50,046.26 MM Sewer Bond Raymond COP Water James-CIP MM9217 Contract 0.000 2/28/2018 2/28/2018 N/A 10,255.14 10,255.14 0 0.00 10,255.14 MM Raymond Water& James -CIP MM9241 Sewer 0.000 2/28/2018 2/28/2018 N/A 29,884.95 29,884.95 0 0.00 29,884.95 MM Contingency Raymond COP James -CIP MM5517 Community 0.000 2/28/2018 2/28/2018 N/A 1,553.03 1,553.03 0 0.00 1,553.03 MM Development Raymond COP James -CIP MM9279 General 0.000 2/28/2018 2/28/2018 N/A 3,209.02 3,209.02 0 0.00 3,209.02 MM Fund Raymond COP James -CIP MM9279 General 0.000 2/28/2018 2/28/2018 N/A 3,983,080.00 3,983,080.00 0 0.00 3,983,080.00 MM Fund Raymond COP 1992 James -CIP MM9236 Water& 0.000 1/31/2018 1/31/2018 N/A 64,876.25 64,876.25 0 0.00 64,876.25 MM Sewer Bond Raymond COP Water James -CIP MM9217 Contract 0.000 1/31/2018 1/31/2018 N/A 16,400.38 16,400.38 0 0.00 16,400.38 MM Raymond COP 2013 James -GIP MM5687 Construction 0.000 1/31/2018 1/31/2018 N/A 335.53 335.53 0 0.00 335.53 MM Fund https://v4.tracker.us.com/Apps/PrintBW.aspx 9/10 1/30/2019 Tracker Report YTM Portfolio @ Trade Settlement Maturity Face Description CU SIP/Ticker Name Cost Date Date Date Amount/Shares Principal Price Interest/Dividends Total Raymond Water& James -GIP MM9241 Sewer 0.000 113112018 113112018 NIA 37,892.98 37,892.98 0 0.00 37,892.98 MM Contingency Raymond COP James-GIP MM5517 Community 0.000 113112018 113112018 NIA 1,729.82 1,729.82 0 0.00 1,729.82 MM Development Raymond COP James -GIP MM9279 General 0.000 113012018 113012018 NIA 2,356.30 2,356.30 0 0.00 2,356.30 MM Fund Raymond COP PEG James -DP MM9914 Account 0.000 313112018 313112018 NIA 5,426.97 5,426.97 0 0.00 5,426.97 MM Raymond COP PEG James -DP MM9914 Account 0.000 313112018 313112018 NIA 169,991 .10 169,991.10 0 0.00 169,991 .10 MM Raymond COP PEG James-DP MM9914 Account 0.000 2/2812018 2/2812018 NIA 5,679.86 5,679.86 0 0.00 5,679.86 MM Raymond COP PEG James -DP MM9914 Account 0.000 113112018 113112018 NIA 9,369.49 9,369.49 0 0.00 9,369.49 MM Raymond GO Bds MMW438 2016 Const. 0.000 313112018 313112018 NIA 4,042,500.00 4,042,500.00 0 0.00 4,042,500.00 James MM Fund Raymond GO Bds MMM526 2017 Const. 0.000 313112018 313112018 NIA 6,998,381.25 6,998,381.25 0 0.00 6,998,381.25 James MM Fund Raymond GO Bds MMM526 2017 Const. 0.000 313112018 313112018 NIA 8,040,000.00 8,040,000.00 0 0.00 8,040,000.00 James MM Fund Raymond COP Water James-GIP MM5281 and Sewer 0.000 212812018 212812018 NIA 995,770.00 995,770.00 0 0.00 995,770.00 MM Fund Sub Total/ 25,828,942.83 25,828,942.83 0.00 25,828,942.83 Average https://v4.tracker.us.com/Apps/PrintBW.aspx 10/10