Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Investment Report, 2018 2nd 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 Public Funds Investment Act, and is being managed under the investment strategy developed and approved by the governing board of the City of Paris. W. E. Anderson, Finance Director ?-13-/8 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: 04/01/2018, End Date: 06/30/2018 YTM Portfolio @ Trade Settlement Maturity Face Description CU SIP/Ticker Name Cost Date Date Date Amount/Shares Principal Price Interest/Dividends Total Buy T-Bill0 COP 8/9/2018 912796PU7 General 1.627 4/5/2018 4/6/2018 8/9/2018 6,000,000.00 5,966,760.00 99.446 0.00 5,966,760.00 Fund GO Bonds T-Note 1.25 912828M64 2018 1.896 5/8/2018 5/9/2018 11/15/2018 1,300,000.00 1,295,701.99 99.669384 7,855.66 1,303,557.65 11/15/2018 Construction Fd Sub Total/ 7,300,000.00 7,262,461.99 7,855.66 7,270,317.65 Average Deposit Raymond COP 1992 James-GIP MM9236 Water& 0.000 6/30/2018 6/30/2018 N/A 6,439.16 6,439.16 100 0.00 6,439.16 MM Sewer Bond Raymond COP 1992 James-GIP MM9236 Water& 0.000 6/30/2018 6/30/2018 N/A 74,119.85 74,119.85 100 0.00 74,119.85 MM Sewer Bond Raymond COP Water James -CIP MM9217 Contract 0.000 6/30/2018 6/30/2018 N/A 1,643.95 1,643.95 100 0.00 1,643.95 MM Raymond COP Water James -CIP MM9217 Contract 0.000 6/30/2018 6/30/2018 N/A 18,586.94 18,586.94 100 0.00 18,586.94 MM Raymond Water& James -CIP MM9241 Sewer 0.000 6/30/2018 6/30/2018 N/A 2,427.93 2,427.93 100 0.00 2,427.93 MM Contingency Raymond Water& James -CIP MM9241 Sewer 0.000 6/30/2018 6/30/2018 N/A 33,779.99 33,779.99 100 0.00 33,779.99 MM Contingency Raymond COP James -CIP MM5517 Community 0.000 6/30/2018 6/30/2018 N/A 28.83 28.83 100 0.00 28.83 MM Development Raymond COP James -CIP MM5517 Community 0.000 6/30/2018 6/30/2018 N/A 929.11 929.11 100 0.00 929.11 MM Development Raymond COP James -CIP MM9279 General 0.000 6/30/2018 6/30/2018 N/A 275.60 275.60 100 0.00 275.60 MM Fund Raymond COP James -CIP MM9279 General 0.000 6/30/2018 6/30/2018 N/A 1,940.16 1,940.16 100 0.00 1,940.16 MM Fund Raymond COP 1992 James -CIP MM9236 Water& 0.000 5/31/2018 5/31/2018 N/A 6,592.23 6,592.23 100 0.00 6,592.23 MM Sewer Bond Raymond COP 1992 James -CIP MM9236 Water& 0.000 5/31 /2018 5/31/2018 N/A 74,691 .71 74,691.71 100 0.00 74,691.71 MM Sewer Bond Raymond COP Water James -CIP MM9217 Contract 0.000 5/31 /2018 5/31/2018 N/A 1,685.01 1,685.01 100 0.00 1,685.01 MM Raymond COP Water James -CIP MM9217 Contract 0.000 5/31 /2018 5/31/2018 N/A 20,121 .57 20,121.57 100 0.00 20,121.57 MM Raymond Water& James -CIP MM9241 Sewer 0.000 5/31 /2018 5/31/2018 N/A 2,486.65 2,486.65 100 0.00 2,486.65 MM Contingency Raymond Water& James -CIP MM9241 Sewer 0.000 5/31 /2018 5/31/2018 N/A 30,990.96 30,990.96 100 0.00 30,990.96 MM Contingency Raymond COP James -CIP MM5517 Community 0.000 5/31/2018 5/31/2018 N/A 32.78 32.78 100 0.00 32.78 MM Development 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 James -CIP MM5517 Community 0.000 5/31/2018 5/31/2018 N/A 1,185.62 1,185.62 100 0.00 1,185.62 MM Development Raymond COP James -CIP MM9279 General 0.000 5/31/2018 5/31/2018 N/A 108.00 108.00 100 0.00 108.00 MM Fund Raymond COP James -CIP MM9279 General 0.000 5/31/2018 5/31/2018 N/A 4,002,456.55 4,002,456.55 100 0.00 4,002,456.55 MM Fund Raymond COP 1992 James -CIP MM9236 Water& 0.000 4/30/2018 4/30/2018 N/A 6,743.03 6,743.03 100 0.00 6,743.03 MM Sewer Bond Raymond COP 1992 James -CIP MM9236 Water& 0.000 4/30/2018 4/30/2018 N/A 76,514.35 76,514.35 100 0.00 76,514.35 MM Sewer Bond Raymond COP Water James -CIP MM9217 Contract 0.000 4/30/2018 4/30/2018 N/A 1,725.04 1,725.04 100 0.00 1,725.04 MM Raymond COP Water James -CIP MM9217 Contract 0.000 4/30/2018 4/30/2018 N/A 20,403.13 20,403.13 100 0.00 20,403.13 MM Raymond Water& James -CIP MM9241 Sewer 0.000 4/30/2018 4/30/2018 N/A 2,551 .10 2,551 .10 100 0.00 2,551.10 MM Contingency Raymond Water& James -CIP MM9241 Sewer 0.000 4/30/2018 4/30/2018 N/A 35,123.01 35,123.01 100 0.00 35,123.01 MM Contingency Raymond COP James -CIP MM5517 Community 0.000 4/30/2018 4/30/2018 N/A 36.75 36.75 100 0.00 36.75 MM Development Raymond COP James -CIP MM5517 Community 0.000 4/30/2018 4/30/2018 N/A 1,181 .22 1,181 .22 100 0.00 1,181.22 MM Development Raymond COP James -CIP MM9279 General 0.000 4/30/2018 4/30/2018 N/A 359.37 359.37 100 0.00 359.37 MM Fund Raymond COP James -CIP MM9279 General 0.000 4/30/2018 4/30/2018 N/A 2,477.04 2,477.04 100 0.00 2,477.04 MM Fund Raymond COP James -CIP MM9279 General 0.000 4/30/2018 4/30/2018 N/A 5,966,760.00 5,966,760.00 100 0.00 5,966,760.00 MM Fund Raymond COP PEG James -DP MM9914 Account 0.000 6/30/2018 6/30/2018 N/A 925.56 925.56 100 0.00 925.56 MM Raymond COP PEG James -DP MM9914 Account 0.000 6/30/2018 6/30/2018 N/A 10,774.91 10,774.91 100 0.00 10,774.91 MM Raymond COP PEG James -DP MM9914 Account 0.000 5/31 /2018 5/31/2018 N/A 942.61 942.61 100 0.00 942.61 MM Raymond COP PEG James -DP MM9914 Account 0.000 5/31/2018 5/31/2018 N/A 8,169.64 8,169.64 100 0.00 8,169.64 MM Raymond COP PEG James -DP MM9914 Account 0.000 4/30/2018 4/30/2018 N/A 958.71 958.71 100 0.00 958.71 MM Raymond COP PEG James -DP MM9914 Account 0.000 4/30/2018 4/30/2018 N/A 7,804.39 7,804.39 100 0.00 7,804.39 MM GO Bonds Raymond MMD950 2018 0.000 6/30/2018 6/30/2018 James MM Construction N/A 0.89 0.89 100 0.00 0.89 Fd Raymond GO Bds MMM526 2017 Const. 0.000 6/30/2018 6/30/2018 N/A 30,727.65 30,727.65 100 0.00 30,727.65 James MM Fund Raymond GO Bds MMM526 2017 Const. 0.000 6/30/2018 6/30/2018 N/A 7,000,000.00 7,000,000.00 100 0.00 7,000,000.00 James MM Fund GO Bonds Raymond MMD950 2018 0.000 5/31/2018 5/31 /2018 James MM Construction N/A 8,125.75 8,125.75 100 0.00 8,125.75 Fd https://v4 .tracker.us.com/ Apps/PrintBW.aspx 2/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 GO Bonds Raymond MMD950 2018 0.000 5/31 /2018 5/31/2018 N/A 1,303,563.60 1,303,563.60 100 0.00 1,303,563.60 James MM Construction Fd Raymond COP Water James-CIP MM5281 and Sewer 0.000 6/30/2018 6/30/2018 N/A 53.42 53.42 100 0.00 53.42 MM Fund Raymond COP Water James-CIP MM5281 and Sewer 0.000 5/31 /2018 5/31/2018 N/A 17.79 17.79 100 0.00 17.79 MM Fund Raymond COP Water James-CIP MM5281 and Sewer 0.000 5/31 /2018 5/31/2018 N/A 1,000,000.00 1,000,000.00 100 0.00 1,000,000.00 MM Fund Sub Total I 19,766,461.56 19,766,461.56 0.00 19,766,461.56 Average Interest FHLB 0.875 GO Bds 6129/2018 3130A8BD4 2017 Const. 0.000 6/29/2018 6/29/2018 6/29/2018 0.00 0.00 30,625.00 30,625.00 Fund FHLMC COP 1992 MBS 1.5 3137GA2D8 Water& 0.000 611/2018 6/1/2018 8/15/2020 0.00 0.00 36.64 36.64 8/15/2020 Sewer Bond FHLMC COP 1992 MBS 1.5 3137GA2D8 Water& 0.000 5/1/2018 5/1/2018 8/15/2020 0.00 0.00 38.46 38.46 8/15/2020 Sewer Bond FNMA MBS Water& 23/1/2023 31417FQT8 Sewer 0.000 6/1/2018 611/2018 31112023 0.00 0.00 76.16 76.16 Contingency FNMA MBS COP 2 3/112023 31417FQT8 General 0.000 611/2018 6/1/2018 31112023 0.00 0.00 95.20 95.20 Fund FNMA MBS COP 1992 23/1/2023 31417FQT8 Water& 0.000 611/2018 6/1/2018 311/2023 0.00 0.00 276.07 276.07 Sewer Bond FNMA MBS 31418ARF7 COP Water 0.000 611/2018 6/1/2018 311./2023 0.00 0.00 189.29 189.29 23/1/2023 Contract FNMA MBS Water& 2 3/1 12023 31418ARF7 Sewer 0.000 61112018 6/1/2018 311/2023 0.00 0.00 366.75 366.75 Contingency FNMA MBS COP 1992 2 3/112023 31418ARF7 Water& 0.000 6/112018 6/1 /2018 311/2023 0.00 0.00 436.31 436.31 Sewer Bond FNMA MBS Water& 2 3/112023 31417FQT8 Sewer 0.000 5/1 12018 5/112018 311/2023 0.00 0.00 78.28 78.28 Contingency FNMA MBS COP 2 3/112023 31417FQT8 General 0.000 5/112018 5/1 /2018 311/2023 0.00 0.00 97.85 97.85 Fund FNMA MBS COP 1992 2 3/112023 31417FQT8 Water& 0.000 5/112018 5/1/2018 311/2023 0.00 0.00 283.75 283.75 Sewer Bond FNMAMBS 31418ARF7 COP Water 0.000 5/1/2018 2 3/112023 Contract 5/1 /2018 3/1/2023 0.00 0.00 195.89 195.89 FNMAMBS Water& 23/1/2023 31418ARF7 Sewer 0.000 5/112018 5/1 /2018 31112023 0.00 0.00 379.54 379.54 Contingency FNMAMBS COP 1992 2 3/112023 31418ARF7 Water& 0.000 5/112018 5/1 /2018 3/112023 0.00 0.00 451.53 451.53 Sewer Bond FNMA MBS Water& 27/1/2023 31418AU22 Sewer 0.000 6/112018 6/1 /2018 7/112023 0.00 0.00 478.35 478.35 Contingency FNMA MBS Water& 2 7/112023 31418AU22 Sewer 0.000 5/112018 5/1/2018 7/112023 0.00 0.00 491.52 491.52 Contingency FNMAMBS COP Water 2.5 31418AZ35 Contract 0.000 6/112018 6/1/2018 11/1/2023 0.00 0.00 353.03 353.03 11/1/2023 FNMAMBS Water& 2.5 31418AZ35 Sewer 0.000 611/2018 611 /2018 11/1/2023 0.00 0.00 383.88 383.88 11/112023 Contingency https://v4.tracker.us.com/Apps/PrintBW.aspx 3/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 31418AZ35 Water& 0.000 6/1/2018 6/1 /2018 11/1/2023 0.00 0.00 610.10 610.10 11/1/2023 Sewer Bond FNMA MBS COP Water 2.5 31418AZ35 Contract 0.000 5/1/2018 5/1/201 8 11/1/2023 0.00 0.00 363.56 363.56 11/1/2023 FNMA MBS Water& 2.5 31418AZ35 Sewer 0.000 5/1/2018 5/1/2018 11/1/2023 0.00 0.00 395.32 395.32 11/1/2023 Contingency FNMA MBS COP 1992 2.5 31 418AZ35 Water& 0.000 5/1/2018 5/1/2018 11/1/2023 0.00 0.00 628.28 628.28 11/1/2023 Sewer Bond FNMA MBS 31 418BBA3 COP Water 0.000 6/25/2018 6/25/2018 3/1/2024 0.00 0.00 75.23 75.23 2.5 3/1/2024 Contract FNMA MBS COP 1992 2.5 3/1/2024 31418BBA3 Water& 0.000 6/25/2018 6/25/2018 3/1/2024 0.00 0.00 364.87 364.87 Sewer Bond FNMA MBS 31418BBA3 COP Water 0.000 5/25/2018 5/25/2018 3/1/2024 0.00 0.00 77.18 77.18 2.5 3/1/2024 Contract FNMA MBS COP 1992 2.5 3/1/2024 31418BBA3 Water& 0.000 5/25/2018 5/25/2018 3/1/2024 0.00 0.00 374.32 374.32 Sewer Bond FNMA MBS 31418BBA3 COP Water 0.000 4/25/2018 4/25/2018 3/1/2024 0.00 0.00 79.48 79.48 2.5 3/1/2024 Contract FNMA MBS COP 1992 2.5 3/1/2024 31418BBA3 Water& 0.000 4/25/2018 4/25/2018 3/1/2024 0.00 0.00 385.49 385.49 Sewer Bond FNMAMBS 31418BZS8 COP Water 0.000 6/1/2018 6/1 /2018 3/1/2026 0.00 0.00 220.83 220.83 2.5 3/1/2026 Contract FNMAMBS Water& 2.5 3/1/2026 31418BZS8 Sewer 0.000 6/1/2018 6/1 /2018 3/1/2026 0.00 0.00 357.23 357.23 Contingency FNMA MBS COP 1992 2.5 3/1/2026 31418BZS8 Water& 0.000 6/1/2018 6/1 /2018 3/1/2026 0.00 0.00 870.35 870.35 Sewer Bond FNMA MBS 31418BZS8 COP Water 0.000 5/1/2018 5/1 /2018 3/1/2026 0.00 0.00 224.00 224.00 2.5 3/1/2026 Contract FNMAMBS Water& 2.5 3/1/2026 31418BZS8 Sewer 0.000 5/1/2018 5/1/2018 3/1/2026 0.00 0.00 362.35 362.35 Contingency FNMA MBS COP 1992 2.5 3/1/2026 31418BZS8 Water& 0.000 5/1/2018 5/1 /2018 3/1/2026 0.00 0.00 882.81 882.81 Sewer Bond FNMAMBS 31418CJK1 COP Water 0.000 6/1/2018 6/1/2018 4/1/2027 0.00 0.00 190.99 190.99 2.5 4/1/2027 Contract FNMA MBS Water& 2.5 4/1/2027 31418CJK1 Sewer 0.000 6/1/2018 6/1 /2018 4/1/2027 0.00 0.00 305.24 305.24 Contingency FNMA MBS COP 1992 2.5 4/1/2027 31 418CJK1 Water& 0.000 6/1/2018 6/1 /2018 4/1/2027 0.00 0.00 526.92 526.92 Sewer Bond FNMA MBS 31418CJK1 COP Water 0.000 5/1/2018 5/1/2018 4/1/2027 0.00 0.00 195.00 195.00 2.5 4/1/2027 Contract FNMA MBS Water& 2.5 4/1/2027 31418CJK1 Sewer 0.000 5/1/2018 5/1/2018 4/1/2027 0.00 0.00 311 .65 311 .65 Contingency FNMA MBS COP 1992 2.5 4/1/2027 31418CJK1 Water& 0.000 5/1/2018 5/1 /2018 4/1/2027 0.00 0.00 537.98 537.98 Sewer Bond FNMA MBS 3138WHT85 COP Water 0.000 6/1/2018 6/1/2018 8/1/2026 0.00 0.00 155.69 155.69 2.5 8/1/2026 Contract FNMA MBS Water& 2.5 8/1/2026 3138WHT85 Sewer 0.000 6/1/2018 6/1 /2018 8/1/2026 0.00 0.00 459.66 459.66 Contingency FNMAMBS 3138WHT85 COP PEG 0.000 6/1/2018 2.5 8/1/2026 Account 6/1/2018 8/1/2026 0.00 0.00 585.69 585.69 FNMAMBS COP 1992 2.5 8/1/2026 3138WHT85 Water & 0.000 6/1/2018 6/1 /2018 8/1/2026 0.00 0.00 1,230.70 1,230.70 Sewer Bond FNMA MBS 3138WHT85 COP Water 0.000 5/1/2018 5/1 /2018 8/1/2026 0.00 0.00 157.89 157.89 2.5 8/1/2026 Contract https://v4 .tracker. us.com/Apps/PrintBW.aspx 4/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 FNMA MBS Water& 2.5 8/1/2026 3138WHT85 Sewer 0.000 5/1/2018 5/1/2018 8/1/2026 0.00 0.00 466.14 466.14 Contingency FNMAMBS 3138WHT85 COP PEG 0.000 5/1/2018 5/1/2018 8/1/2026 0.00 0.00 593.96 593.96 2.5 8/1/2026 Account FNMAMBS COP 1992 2.5 8/1/2026 3138WHT85 Water& 0.000 5/1/2018 5/1 /2018 8/1/2026 0.00 0.00 1,248.06 1,248.06 Sewer Bond FNMAMBS COP Water 2.5 31417C3C7 Contract 0.000 6/1/2018 6/1 /2018 9/21/2027 0.00 0.00 458.52 458.52 9/21/2027 FNMA MBS COP PEG 2.5 31417C3C7 Account 0.000 6/1/2018 6/1 /2018 9/21/2027 0.00 0.00 339.65 339.65 9/21/2027 FNMA MBS COP 1992 2.5 31417C3C7 Water& 0.000 6/1/2018 6/1/2018 9/21/2027 0.00 0.00 1,995.42 1,995.42 9/21/2027 Sewer Bond FNMA MBS COP Water 2.5 31417C3C7 Contract 0.000 5/1/2018 5/1/2018 9/21/2027 0.00 0.00 470.35 470.35 9/21/2027 FNMA MBS COP PEG 2.5 31417C3C7 Account 0.000 5/1/2018 5/1/2018 9/21/2027 0.00 0.00 348.40 348.40 9/21/2027 FNMA MBS COP 1992 2.5 31417C3C7 Water& 0.000 5/1/2018 5/1/2018 9/21/2027 0.00 0.00 2,046.88 2,046.88 9/21/2027 Sewer Bond FNMAMBS COP 1992 3.5 31417YTE7 Water& 0.000 6/1/2018 6/1/2018 10/1/2020 0.00 0.00 90.48 90.48 10/1/2020 Sewer Bond FNMAMBS COP 1992 3.5 31417YTE7 Water& 0.000 5/1/2018 5/1/2018 10/1/2020 0.00 0.00 96.02 96.02 10/1/2020 Sewer Bond GNMAMBS COP 4 9/20/2018 36202DZA2 General 0.000 6/1/2018 6/1/2018 9/20/2018 0.00 0.00 7.21 7.21 Fund GNMAMBS COP 4 9/20/2018 36202DZA2 General 0.000 5/1/2018 5/1/2018 9/20/2018 0.00 0.00 10.09 10.09 Fund GNMAMBS COP 4 9/20/2019 36202EBM0 Community 0.000 6/1/2018 6/1/2018 9/20/2019 0.00 0.00 28.83 28.83 Development GNMAMBS COP 4 9/20/2019 36202EBM0 Community 0.000 5/1/2018 5/1/2018 9/20/2019 0.00 0.00 32.78 32.78 Development GO Bonds T-Note 1.25 912828M64 2018 0.000 5/15/2018 5/15/2018 11 /15/2018 0.00 0.00 8,125.00 8,125.00 11/15/2018 Construction Fd Sub Total/ 0.00 0.00 62,620.10 62,620.10 Average Matured FHLB 0.875 GO Bds 6/29/2018 3130A8BD4 2017 Const. 0.000 6/29/2018 6/29/2018 6/29/2018 7,000,000.00 7,000,000.00 0 0.00 7,000,000.00 Fund T-Bill0 COP Water 5/31 /2018 912796PH6 and Sewer 0.000 5/31 /2018 5/31/2018 5/31/2018 1,000,000.00 1,000,000.00 0 0.00 1,000,000.00 Fund T-Bill 0 COP 5/31/2018 912796PH6 General 0.000 5/31 /2018 5/31/2018 5/31/2018 4,000,000.00 4,000,000.00 0 0.00 4,000,000.00 Fund Sub Total/ 12,000,000.00 12,000,000.00 0.00 12,000,000.00 Average Principal Pay Down FHLMC COP 1992 MBS 1.5 3137GA2D8 Water& 0.000 6/30/2018 6/30/2018 8/15/2020 1,503.31 1,503.31 0 0.00 1,503.31 8/15/2020 Sewer Bond FHLMC COP 1992 MBS 1.5 3137GA2D8 Water& 0.000 5/31/2018 5/31/2018 8/15/2020 1,455.24 1,455.24 0 0.00 1,455.24 8/15/2020 Sewer Bond FHLMC COP 1992 MBS 1.5 3137GA2D8 Water& 0.000 4/30/2018 4/30/2018 8/15/2020 2,397.38 2,397.38 0 0.00 2,397.38 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 FNMAMBS Water& 23/1/2023 31417FQT8 Sewer 0.000 6/30/2018 6/30/2018 3/1/2023 1,078.93 1,078.93 0 0.00 1,078.93 Contingency FNMAMBS COP 23/1/2023 31417FQT8 General 0.000 6/30/2018 6/30/2018 3/1/2023 1,348.66 1,348.66 0 0.00 1,348.66 Fund FNMA MBS COP 1992 23/1/2023 31417FQT8 Water& 0.000 6/30/2018 6/30/2018 3/1/2023 3,911.11 3,911 .11 0 0.00 3,911 .11 Sewer Bond FNMA MBS 31418ARF7 COP Water 0.000 6/30/2018 6/30/2018 3/1/2023 3,397.26 3,397.26 0 0.00 3,397.26 23/1/2023 Contract FNMA MBS Water& 23/1/2023 31418ARF7 Sewer 0.000 6/30/2018 6/30/2018 3/1/2023 2,967.92 2,967.92 0 0.00 2,967.92 Contingency FNMA MBS Water& 23/1/2023 31418ARF7 Sewer 0.000 6/30/2018 6/30/2018 3/1/2023 3,614.27 3,614.27 0 0.00 3,614.27 Contingency FNMAMBS COP 1992 23/1/2023 31418ARF7 Water& 0.000 6/30/2018 6/30/2018 3/1/2023 2,592.28 2,592.28 0 0.00 2,592.28 Sewer Bond FNMAMBS COP 1992 23/1/2023 31418ARF7 Water& 0.000 6/30/2018 6/30/2018 3/1/2023 5,238.40 5,238.40 0 0.00 5,238.40 Sewer Bond FNMAMBS Water& 23/1/2023 31417FQT8 Sewer 0.000 5/31 /2018 5/31/2018 3/1/2023 1,272.28 1,272.28 0 0.00 1,272.28 Contingency FNMAMBS COP 23/1/2023 31417FQT8 General 0.000 5/31/2018 5/31/2018 3/1/2023 1,590.35 1,590.35 0 0.00 1,590.35 Fund FNMAMBS COP 1992 23/1/2023 31417FQT8 Water& 0.000 5/31 /2018 5/31/2018 3/1/2023 4,612.02 4,612.02 0 0.00 4,612.02 Sewer Bond FNMAMBS 31418ARF7 COP Water 0.000 5/31 /2018 5/31/2018 3/1/2023 3,962.70 3,962.70 0 0.00 3,962.70 23/1/2023 Contract FNMAMBS Water& 23/1/2023 31418ARF7 Sewer 0.000 5/31 /2018 5/31/2018 3/1/2023 3,461 .91 3,461 .91 0 0.00 3,461 .91 Contingency FNMA MBS Water& 23/1/2023 31418ARF7 Sewer 0.000 5/31 /2018 5/31 /2018 3/1/2023 4,215.83 4,215.83 0 0.00 4,215.83 Contingency FNMA MBS COP 1992 23/1/2023 31418ARF7 Water& 0.000 5/31 /2018 5/31 /2018 3/1/2023 2,933.30 2,933.30 0 0.00 2,933.30 Sewer Bond FNMA MBS COP 1992 23/1/2023 31418ARF7 Water& 0.000 5/31 /2018 5/31 /2018 3/1/2023 6,200.73 6,200.73 0 0.00 6,200.73 Sewer Bond FNMAMBS Water& 23/1/2023 31417FQT8 Sewer 0.000 4/30/2018 4/30/2018 3/1/2023 1,333.57 1,333.57 0 0.00 1,333.57 Contingency FNMAMBS COP 23/1/2023 31417FQT8 General 0.000 4/30/2018 4/30/2018 3/1/2023 1,666.96 1,666.96 0 0.00 1,666.96 Fund FNMAMBS COP 1992 23/1/2023 31417FQT8 Water& 0.000 4/30/2018 4/30/2018 3/1/2023 4,834.20 4,834.20 0 0.00 4,834.20 Sewer Bond FNMAMBS 31418ARF7 COP Water 0.000 4/30/2018 4/30/2018 3/1/2023 4,101 .84 4,101 .84 0 0.00 4,101.84 23/1/2023 Contract FNMAMBS Water& 23/1/2023 31418ARF7 Sewer 0.000 4/30/2018 4/30/2018 3/1/2023 3,583.47 3,583.47 0 0.00 3,583.47 Contingency FNMA MBS Water& 23/1/2023 31418ARF7 Sewer 0.000 4/30/2018 4/30/2018 3/1/2023 4,363.85 4,363.85 0 0.00 4,363.85 Contingency FNMA MBS COP 1992 23/1/2023 31418ARF7 Water& 0.000 4/30/2018 4/30/2018 3/1/2023 3,036.29 3,036.29 0 0.00 3,036.29 Sewer Bond FNMA MBS COP 1992 2 3/1/2023 31418ARF7 Water& 0.000 4/30/2018 4/30/2018 3/1/2023 6,418.45 6,418.45 0 0.00 6,418.45 Sewer Bond FNMA MBS Water& 27/1/2023 31418AU22 Sewer 0.000 6/30/2018 6/30/2018 7/1/2023 3,269.93 3,269.93 0 0.00 3,269.93 Contingency https://v4.tracker.us.com/Apps/PrintBW.aspx 6/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 FNMA MBS Water& 27/1/2023 31418AU22 Sewer 0.000 6/30/2018 6/30/2018 7/1/2023 5,146.15 5,146.15 0 0.00 5,146.15 Contingency FNMAMBS Water& 27/1/2023 31418AU22 Sewer 0.000 5/31/2018 5/31 /2018 7/1/2023 3,070.67 3,070.67 0 0.00 3,070.67 Contingency FNMAMBS Water& 27/1/2023 31418AU22 Sewer 0.000 5/31/2018 5/31/2018 7/1/2023 4,832.55 4,832.55 0 0.00 4,832.55 Contingency FNMAMBS Water& 27/1/2023 31418AU22 Sewer 0.000 4/30/2018 4/30/2018 7/1/2023 3,371.47 3,371.47 0 0.00 3,371.47 Contingency FNMAMBS Water& 27/1/2023 31418AU22 Sewer 0.000 4/30/2018 4/30/2018 7/1/2023 5,305.94 5,305.94 0 0.00 5,305.94 Contingency FNMAMBS COP Water 2.5 31418AZ35 Contract 0.000 6/30/2018 6/30/2018 11/1/2023 4,417.35 4,417.35 0 0.00 4,417.35 11/1/2023 FNMA MBS Water& 2.5 31418AZ35 Sewer 0.000 6/30/2018 6/30/2018 11/1/2023 4,803.33 4,803.33 0 0.00 4,803.33 11/1/2023 Contingency FNMAMBS COP 1992 2.5 31418AZ35 Water& 0.000 6/30/2018 6/30/2018 11/1/2023 7,633.86 7,633.86 0 0.00 7,633.86 11/1/2023 Sewer Bond FNMA MBS COP Water 2.5 31418AZ35 Contract 0.000 5/31/2018 5/31/2018 11/1/2023 5,050.55 5,050.55 0 0.00 5,050.55 11/1/2023 FNMA MBS Water& 2.5 31418AZ35 Sewer 0.000 5/31/2018 5/31/2018 11/1/2023 5,491.86 5,491.86 0 0.00 5,491.86 11/1/2023 Contingency FNMA MBS COP 1992 2.5 31418AZ35 Water& 0.000 5/31/2018 5/31/2018 11/1/2023 8,728.13 8,728.13 0 0.00 8,728.13 11/1/2023 Sewer Bond FNMA MBS COP Water 2.5 31418AZ35 Contract 0.000 4/30/2018 4/30/2018 11/1/2023 5,704.01 5,704.01 0 0.00 5,704.01 11/1/2023 FNMA MBS Water& 2.5 31418AZ35 Sewer 0.000 4/30/2018 4/30/2018 11/1/2023 6,202.41 6,202.41 0 0.00 6,202.41 11/1/2023 Contingency FNMA MBS COP 1992 2.5 31418AZ35 Water& 0.000 4/30/2018 4/30/2018 11/1/2023 9,857.41 9,857.41 0 0.00 9,857.41 11/1/2023 Sewer Bond FNMA MBS 31418BBA3 COP Water 0.000 6/30/2018 6/30/2018 3/1/2024 781.65 781.65 0 0.00 781.65 2.5 3/1/2024 Contract FNMA MBS COP 1992 2.5 3/1/2024 31418BBA3 Water& 0.000 6/30/2018 6/30/2018 3/1/2024 3,791.02 3,791.02 0 0.00 3,791.02 Sewer Bond FNMAMBS 31418BBA3 COP Water 0.000 5/31/2018 5/31/2018 3/1/2024 935.18 935.18 0 0.00 935.18 2.5 3/1/2024 Contract FNMAMBS COP 1992 2.5 3/1/2024 31418BBA3 Water& 0.000 5/31/2018 5/31/2018 3/1/2024 4,535.62 4,535.62 0 0.00 4,535.62 Sewer Bond FNMAMBS 31418BBA3 COP Water 0.000 4/30/2018 4/30/2018 3/1/2024 1,105.92 1,105.92 0 0.00 1,105.92 2.5 3/1/2024 Contract FNMAMBS COP 1992 2.5 3/1/2024 31418BBA3 Water& 0.000 4/30/2018 4/30/2018 3/1/2024 5,363.70 5,363.70 0 0.00 5,363.70 Sewer Bond FNMAMBS 31418BZS8 COP Water 0.000 6/30/2018 6/30/2018 3/1/2026 2,648.27 2,648.27 0 0.00 2,648.27 2.5 3/1/2026 Contract FNMAMBS Water& 2.5 3/1/2026 31418BZS8 Sewer 0.000 6/30/2018 6/30/2018 3/1/2026 4,283.96 4,283.96 0 0.00 4,283.96 Contingency FNMA MBS COP 1992 2.5 3/1/2026 31418BZS8 Water& 0.000 6/30/2018 6/30/2018 3/1/2026 10,437.29 10,437.29 0 0.00 10,437.29 Sewer Bond FNMA MBS 31418BZS8 COP Water 0.000 5/31/2018 5/31 /2018 3/1/2026 1,518.43 1,518.43 0 0.00 1,518.43 2.5 3/1/2026 Contract FNMA MBS Water& 2.5 3/1/2026 31418BZS8 Sewer 0.000 5/31/2018 5/31/2018 3/1/2026 2,456.29 2,456.29 0 0.00 2,456.29 Contingency FNMA MBS COP 1992 2.5 3/1/2026 31418BZS8 Water& 0.000 5/31/2018 5/31/2018 3/1/2026 5,984.41 5,984.41 0 0.00 5,984.41 Sewer Bond https://v4.tracker.us.com/Apps/PrintBW.aspx 7/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 31418BZS8 COP Water 0.000 4/30/2018 4/30/2018 3/1/2026 3,006.84 3,006.84 0 0.00 3,006.84 2.5 3/1/2026 Contract FNMA MBS Water& 2.5 3/1/2026 31418BZS8 Sewer 0.000 4/30/2018 4/30/2018 3/1/2026 4,864.00 4,864.00 0 0.00 4,864.00 Contingency FNMA MBS COP 1992 2.5 3/1/2026 31418BZS8 Water& 0.000 4/30/2018 4/30/2018 3/1/2026 11 ,850.47 11,850.47 0 0.00 11,850.47 Sewer Bond FNMAMBS 31418CJK1 COP Water 0.000 6/30/2018 6/30/2018 4/1/2027 1,464.58 1,464.58 0 0.00 1,464.58 2.5 4/1/2027 Contract FNMA MBS Water& 2.5 4/1/2027 31418CJK1 Sewer 0.000 6/30/2018 6/30/2018 4/1/2027 2,340.72 2,340.72 0 0.00 2,340.72 Contingency FNMAMBS COP 1992 2.5 4/1/2027 31418CJK1 Water& 0.000 6/30/2018 6/30/2018 4/1/2027 4,040.68 4,040.68 0 0.00 4,040.68 Sewer Bond FNMAMBS 31418CJK1 COP Water 0.000 5/31/2018 5/31/2018 4/1/2027 1,925.36 1,925.36 0 0.00 1,925.36 2.5 4/1/2027 Contract FNMAMBS Water& 2.5 4/1/2027 31418CJK1 Sewer 0.000 5/31/2018 5/31/2018 4/1/2027 3,077.14 3,077.14 0 0.00 3,077.14 Contingency FNMAMBS COP 1992 2.5 4/1/2027 31418CJK1 Water& 0.000 5/31 /2018 5/31/2018 4/1/2027 5,311 .93 5,311.93 0 0.00 5,311 .93 Sewer Bond FNMAMBS 31418CJK1 COP Water 0.000 4/30/2018 4/30/2018 4/1/2027 1,363.25 1,363.25 0 0.00 1,363.25 2.5 4/1/2027 Contract FNMAMBS Water& 2.5 4/1/2027 31418CJK1 Sewer 0.000 4/30/2018 4/30/2018 4/1/2027 2,178.76 2,178.76 0 0.00 2,178.76 Contingency FNMAMBS COP 1992 2.5 4/1/2027 31418CJK1 Water& 0.000 4/30/2018 4/30/2018 4/1/2027 3,761.10 3,761.10 0 0.00 3,761 .10 Sewer Bond FNMAMBS 3138WHT85 COP Water 0.000 6/30/2018 6/30/2018 8/1/2026 2,125.33 2,125.33 0 0.00 2,125.33 2.5 8/1/2026 Contract FNMAMBS Water& 2.5 8/1/2026 3138WHT85 Sewer 0.000 6/30/2018 6/30/2018 8/1/2026 6,274.78 6,274.78 0 0.00 6,274.78 Contingency FNMA MBS 3138WHT85 COP PEG 0.000 6/30/2018 6/30/2018 8/1/2026 7,995.28 7,995.28 0 0.00 7,995.28 2.5 8/1/2026 Account FNMA MBS COP 1992 2.5 8/1/2026 3138WHT85 Water& 0.000 6/30/2018 6/30/2018 8/1/2026 16,800.20 16,800.20 0 0.00 16,800.20 Sewer Bond FNMA MBS 3138WHT85 COP Water 0.000 5/31/2018 5/31/2018 8/1/2026 1,054.21 1,054.21 0 0.00 1,054.21 2.5 8/1/2026 Contract FNMA MBS Water& 2.5 8/1/2026 3138WHT85 Sewer 0.000 5/31/2018 5/31/2018 8/1/2026 3,112.43 3,112.43 0 0.00 3,112.43 Contingency FNMA MBS 3138WHT85 COP PEG 0.000 5/31/2018 5/31/2018 8/1/2026 3,965.84 3,965.84 0 0.00 3,965.84 2.5 8/1/2026 Account FNMA MBS COP 1992 2.5 8/1/2026 3138WHT85 Water& 0.000 5/31 /2018 5/31/2018 8/1/2026 8,333.27 8,333.27 0 0.00 8,333.27 Sewer Bond FNMA MBS 3138WHT85 COP Water 0.000 4/30/2018 4/30/2018 8/1/2026 1,327.59 1,327.59 0 0.00 1,327.59 2.5 8/1/2026 Contract FNMAMBS Water& 2.5 8/1/2026 3138WHT85 Sewer 0.000 4/30/2018 4/30/2018 8/1/2026 3,919.54 3,919.54 0 0.00 3,919.54 Contingency FNMAMBS 3138WHT85 COP PEG 0.000 4/30/2018 4/30/2018 8/1/2026 4,994.26 4,994.26 0 0.00 4,994.26 2.5 8/1/2026 Account FNMAMBS COP 1992 2.5 8/1/2026 3138WHT85 Water& 0.000 4/30/2018 4/30/2018 8/1/2026 10,494.26 10,494.26 0 0.00 10,494.26 Sewer Bond FNMAMBS COP Water 2.5 31417C3C7 Contract 0.000 6/30/2018 6/30/2018 9/21/2027 3,752.50 3,752.50 0 0.00 3,752.50 9/21/2027 FNMA MBS COP PEG 2.5 31417C3C7 Account 0.000 6/30/2018 6/30/2018 9/21/2027 2,779.63 2,779.63 0 0.00 2,779.63 9/21/2027 FNMA MBS COP 1992 2.5 31417C3C7 Water& 0.000 6/30/2018 6/30/2018 9/21/2027 16,330.34 16,330.34 0 0.00 16,330.34 9/21/2027 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 FNMA MBS COP Water 2.5 31417C3C7 Contract 0.000 5/31/2018 5/31/2018 9/21/2027 5,675.14 5,675.14 0 0.00 5,675.14 9/21/2027 FNMA MBS COP PEG 2.5 31417C3C7 Account 0.000 5/31/2018 5/31/2018 9/21/2027 4,203.80 4,203.80 0 0.00 4,203.80 9/21/2027 FNMAMBS COP 1992 2.5 31417C3C7 Water& 0.000 5/31/2018 5/31 /2018 9/21/2027 24,697.35 24,697.35 0 0.00 24,697.35 9/21/2027 Sewer Bond FNMAMBS COP Water 2.5 31417C3C7 Contract 0.000 4/30/2018 4/30/2018 9/21/2027 3,793.68 3,793.68 0 0.00 3,793.68 9/21/2027 FNMAMBS COP PEG 2.5 31417C3C7 Account 0.000 4/30/2018 4/30/2018 9/21 /2027 2,810.13 2,810.13 0 0.00 2,810.13 9/21/2027 FNMAMBS COP 1992 2.5 31417C3C7 Water& 0.000 4/30/2018 4/30/2018 9/21 /2027 16,509.53 16,509.53 0 0.00 16,509.53 9/21/2027 Sewer Bond FNMAMBS COP 1992 3.5 31417YTE7 Water& 0.000 6/30/2018 6/30/2018 10/1/2020 1,841.36 1,841.36 0 0.00 1,841.36 10/1/2020 Sewer Bond FNMAMBS COP 1992 3.5 31417YTE7 Water& 0.000 5/31/2018 5/31/2018 10/1/2020 1,899.71 1,899.71 0 0.00 1,899.71 10/1/2020 Sewer Bond FNMAMBS COP 1992 3.5 31417YTE7 Water& 0.000 4/30/2018 4/30/2018 10/1/2020 1,991 .56 1,991.56 0 0.00 1,991.56 10/1/2020 Sewer Bond GNMAMBS COP 4 9/20/2018 36202DZA2 General 0.000 6/30/2018 6/30/2018 9/20/2018 591 .50 591.50 0 0.00 591.50 Fund GNMAMBS COP 4 9/20/2018 36202DZA2 General 0.000 5/31/2018 5/31/2018 9/20/2018 866.20 866.20 0 0.00 866.20 Fund GNMAMBS COP 4 9/20/2018 36202DZA2 General 0.000 4/30/2018 4/30/2018 9/20/2018 810.08 810.08 0 0.00 810.08 Fund GNMAMBS COP 4 9/20/2019 36202EBMO Community 0.000 6/30/2018 6/30/2018 9/20/2019 929.11 929.11 0 0.00 929.11 Development GNMAMBS COP 4 9/20/2019 36202EBMO Community 0.000 5/31/2018 5/31/2018 9/20/2019 1,185.62 1,185.62 0 0.00 1,185.62 Development GNMAMBS COP 4 9/20/2019 36202EBMO Community 0.000 4/30/2018 4/30/2018 9/20/2019 1,181 .22 1,181.22 0 0.00 1,181.22 Development Sub Total I 421,250.15 421,250.15 0.00 421,250.15 Average Withdraw Raymond COP 1992 James -CIP MM9236 Water& 0.000 6/30/2018 6/30/2018 N/A 80,561 .85 80,561 .85 0 0.00 80,561 .85 MM Sewer Bond Raymond COP Water James -CIP MM9217 Contract 0.000 6/30/2018 6/30/2018 N/A 20,231 .66 20,231 .66 0 0.00 20,231 .66 MM Raymond Water& James -CIP MM9241 Sewer 0.000 6/30/2018 6/30/2018 N/A 36,209.10 36,209.10 0 0.00 36,209.10 MM Contingency Raymond COP James -CIP MM5517 Community 0.000 6/30/2018 6/30/2018 N/A 957.94 957.94 0 0.00 957.94 MM Development Raymond COP James -CIP MM9279 General 0.000 6/30/2018 6/30/2018 N/A 4,002,042.63 4,002,042.63 0 0.00 4,002,042.63 MM Fund Raymond COP 1992 James -CIP MM9236 Water& 0.000 5/31/2018 5/31/2018 N/A 81 ,281 .61 81,281.61 0 0.00 81,281.61 MM Sewer Bond Raymond COP Water James -CIP MM9217 Contract 0.000 5/31/2018 5/31/2018 N/A 21 ,805.83 21,805.83 0 0.00 21,805.83 MM Raymond Water& James -CIP MM9241 Sewer 0.000 5/31/2018 5/31/2018 N/A 33,476.37 33,476.37 0 0.00 33,476.37 MM Contingency https://v4.tracker.us.com/Apps/PrintBW.aspx 9/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 Raymond COP James -CIP MM5517 Community 0.000 5/31 /2018 5/31/2018 N/A 1,218.43 1,218.43 0 0.00 1,218.43 MM Development Raymond COP James-GIP MM9279 General 0.000 5/31 /2018 5/31/2018 N/A 2,810.45 2,81 0.45 0 0.00 2,810.45 MM Fund Raymond COP 1992 James -CIP MM9236 Water& 0.000 4/30/2018 4/30/201 8 NIA 83,256.04 83,256.04 0 0.00 83,256.04 MM Sewer Bond Raymond COP Water James -CIP MM9217 Contract 0.000 4/30/2018 4/30/2018 N/A 22,127.90 22,127.90 0 0.00 22,127.90 MM Raymond Water& James -CIP MM9241 Sewer 0.000 4/30/2018 4/30/2018 N/A 37,674.10 37,674.10 0 0.00 37,674.10 MM Contingency Raymond COP James -CIP MM5517 Community 0.000 4/30/2018 4/30/2018 N/A 1,217.94 1,217.94 0 0.00 1,217.94 MM Development Raymond COP James -CIP MM9279 General 0.000 4/30/2018 4/30/2018 N/A 5,002,590.47 5,002,590.47 0 0.00 5,002,590.47 MM Fund Raymond COP James -CIP MM9279 General 0.000 4/30/2018 4/30/2018 N/A 5,966,760.00 5,966,760.00 0 0.00 5,966,760.00 MM Fund Raymond COP PEG James -DP MM9914 Account 0.000 6/30/2018 6/30/2018 N/A 11 ,700.50 11,700.50 0 0.00 11,700.50 MM Raymond COP PEG James -DP MM9914 Account 0.000 5/31/2018 5/31/2018 N/A 9,112.09 9,112.09 0 0.00 9,112.09 MM Raymond COP PEG James -DP MM9914 Account 0.000 4/30/2018 4/30/2018 N/A 8,763.03 8,763.03 0 0.00 8,763.03 MM GO Bonds Raymond MMD950 2018 0.000 6/30/2018 6/30/2018 N/A 8,125.75 8,125.75 0 0.00 8,125.75 James MM Construction Fd GO Bonds Raymond MMD950 2018 0.000 5/31/2018 5/31/2018 N/A 1,303,563.60 1,303,563.60 0 0.00 1,303,563.60 James MM Construction Fd Raymond GO Bds MMW438 2016 Const. 0. 000 4/30/2018 4/30/2018 N/A 198.76 198.76 0 0.00 198.76 James MM Fund Raymond GO Bds MMM526 2017 Const. 0.000 4/30/2018 4/30/2018 N/A 396.47 396.47 0 0.00 396.47 James MM Fund Raymond COP Water James-GIP MM5281 and Sewer 0.000 6/30/2018 6/30/2018 N/A 1,000,017.79 1,000,017.79 0 0.00 1,000,017.79 MM Fund Sub Total/ 17,736,100.31 17,736,100.31 0.00 17,736,100.31 Average https://v4.tracker.us.com/Apps/PrintBW.aspx 10/10