The City of Duncanville Investment Portfolio Summary For the Quarter - PowerPoint PPT Presentation

The City of Duncanville Investment Portfolio Summary For the Quarter Ended 30 th June ,2017 We are building a vibrant, inclusive community, driven by a commitment to democratic principles and service above self

The City of Duncanville Account Summary Book Value Market Value Investment Beginning 3/31/17 $ 26,182,613 $ 26,182,613 Investment Purchases 10,060,693 10,060,693 Investment Maturities 11,000,000 11,000,000 Investment at end 6/30/2017 $ 25,243,307 $ 25,243,307

The City of Duncanville Distribution By Maturity 1 to 2 years, $4,000,000 90 to 180 days, $2,000,000 Under 30 Days, $13,243,307

The City of Duncanville Distribution By Investment Type Certificates of Deposit 24% Money Market Funds 44% LOGIC 32%

City of Duncanville Benchmark Comparison The City of Duncanville Yield Summary For The Quarter Ended June 30, 2017 Earnings and Yield Summary Quarter Ended 6/30/17 Plus Prior Quarter Ended 3/31/17 1.2000% PERCENTAGE YIELD 1.0000% 0.8000% 0.6000% 0.4000% 0.2000% 0.0000% January-17 February-17 March-17 April-17 May-17 June-17 January-17 February-17 March-17 April-17 May-17 June-17 City Portfolio Performance 0.8688% 0.8092% 0.9303% 1.0613% 1.0897% 1.0728% 90 Day T-Bill 0.5215% 0.5310% 0.7473% 0.7984% 0.8890% 0.9814% LOGIC 0.9818% 0.8938% 0.8934% 1.0582% 1.0958% 1.0513% TexPool 0.5379% 0.4924% 0.6330% 0.6927% 0.7775% 0.8697%

The City of Duncanville City of Duncanville Investment Portfolio Summary For Quarter Ending June 30, 2017 Purchase Maturity CD Security Par Purchase Book Gain / Current Date Date Number Type Value Coupon Price Yield Principal Value (loss) D - T - M 30-Jun-17 30-Jun-17 Open LOGIC $ 8,185,859.76 1.068% 100.000 1.068% $ 8,185,859.76 $ 8,185,859.76 $ - 0 30-Sep-15 30-Jun-17 Open Southside MM 4,052,659.80 1.020% 1.020% 4,052,659.80 4,052,659.80 - 0 30-Jun-17 30-Jun-17 Open NEX Bank MM 7,000,000.00 1.460% 1.460% 7,000,000.00 7,000,000.00 - 0 30-Jun-17 30-Jun-17 Open TEXPOOL 4,787.98 0.780% 100.000 0.780% 4,787.98 4,787.98 - 0 30-Sep-15 30-Sep-17 3851-11202078 Comerica CD 2,000,000.00 0.590% 100.000 0.590% 2,000,000.00 2,000,000.00 - 92 06-Jul-16 06-Jul-19 12071 Tex Sec CD 4,000,000.00 0.850% 100.000 0.850% 4,000,000.00 4,000,000.00 - 736 TOTALS $ 25,243,307.54 $ 25,243,307.54 $ 25,243,307.54 $ - Distribution by Maturity Distribution by Investment Type Par Book Value Percent Percent Value Under 30 Days $ 19,243,307.54 76.23% U. S. Treasury Bills / Notes / Bonds 0.00% $ - 30 to 90 Days - 0.00% U. S. Agencies & Instrumentalities 0.00% - 90 to 180 days 2,000,000.00 7.92% Certificates of Deposit 23.77% 6,000,000.00 180 days to 1 year - 0.00% LOGIC 32.43% 8,185,859.76 1 to 2 years 4,000,000.00 15.85% TEXPOOL 0.02% 4,787.98 Totals $ 25,243,307.54 100.00% Money Market Funds 43.78% 11,052,659.80 Repurchase Agreements 0.00% - Totals 100.00% $ 25,243,307.54

City of Duncanville The City of Duncanville Investment Transaction Detail Report For Quarter Ending June 30, 2017 Investment Purchase Transaction Information Investment Maturities Transaction Information Fund Fund No. Transactions Total No. Transactions Total Date Purchase Date Purchase Date Maturity Date Maturity CUSIP Number Open Southside Texas Security Bank NEX Bank Open CUSIP Number Open Southside Open Security Type LOGIC Money Market CD Money Market TexPool Security Type LOGIC Money Market TexPool Par Value $ 51,201.23 $ 9,483.34 $ 3,000,000.00 $ 7,000,000.00 $ 9.33 $ 10,060,693.90 Par Value $ - $ - $ - $ - Book Value 51,201.23 9,483.34 3,000,000.00 7,000,000.00 9.33 10,060,693.90 Book Value - - - - Market Value 51,201.23 9,483.34 3,000,000.00 7,000,000.00 9.33 10,060,693.90 Market Value - - - - General 001 28,320.00 7,112.51 1,500,000.00 5,000,000.00 9.33 6,535,441.84 General 001 8,000,000.00 - - 8,000,000.00 Utility 002 15,116.44 2,370.84 1,500,000.00 2,000,000.00 - 3,517,487.28 Utility 002 3,000,000.00 - - 3,000,000.00 Debt Services 005 188.82 - - - - 188.82 Debt Services 005 - - - - Employee Benefit 007 844.11 - - - - 844.11 Employee Benefit 007 - - - - Self Ins. 008 613.76 - - - - 613.76 Self Ins. 008 - - - - Hotel/Motel Tax 010 531.03 - - - - 531.03 Hotel/Motel Tax 010 - - - - Economic Development 012 821.52 - - - - 821.52 Economic Development 012 - - - - Grant Fund 013 - - - - - - Grant Fund 013 - - - - Community Services 014 43.32 - - - - 43.32 Community Services 014 - - - - Drainage Fees 015 - - - - - - Drainage Fees 015 - - - - Capital Replacement 016 1,427.78 - - - - 1,427.78 Capital Replacement 016 - - - - Utility Capital Improvement 017 584.97 - - - - 584.97 Utility Capital Improvement 017 - - - - Court Technology 018 - - - - - - Court Technology 018 - - - - Solid Waste 019 635.86 - - - - 635.86 Solid Waste 019 - - - - Street 020 - - - - - - Street 020 - - - - Drainage Const. 023 - - - - - - Drainage Const. 023 - - - - Parks 024 - - - - - - Parks 024 - - - - Capital Improvement 025 - - - - - - Capital Improvement 025 - - - - Lib. & Rec. 4B 027 - - - - - - Lib. & Rec. 4B 027 - - - - Traffic Enforcement Program 031 986.56 - - - - 986.56 Traffic Enforcement Program 031 - - - - Abandoned Asset Forfeiture 050 - - - - - - Abandoned Asset Forfeiture 050 - - - - State Asset Forfeiture 051 - - - - - - State Asset Forfeiture 051 - - - - Federal Asset Forfeiture 052 - - - - - - Federal Asset Forfeiture 052 - - - - Court Security 225 742.92 - - - - 742.92 Court Security 225 - - - - Juvenile Case Manager 230 343.68 - - - - 343.68 Juvenile Case Manager 230 - - - - EDC C.O. CIP 455 - - - - - - EDC C.O. CIP 455 - - - -

City of Duncanville The City of Duncanville Schedule of Market Value of Investments By Maturity Dates and Fund For Quarter Ending June 30, 2017 Fund No. Total Date Purchase 06-Jul-15 30-Sep-15 Date Maturity 06-Jul-17 30-Sep-17 CUSIP Number Open Open Open Open CD # 12071 3851-11202078 Security Type LOGIC TexPool Southside MM Nex Bank MM TX SEC BANK Comerica CD Par Value $ 8,185,859.76 $ 4,787.98 $ 4,052,659.80 $ 7,000,000.00 $ 4,000,000.00 $ 2,000,000.00 $ 25,243,307.54 Beginning Book Value 19,134,658.53 4,778.65 4,043,176.46 - 1,000,000.00 - 28,028,606.91 Beginning Market Value 19,134,658.53 4,778.65 4,043,176.46 - 1,000,000.00 - 28,028,606.91 Ending Book Value 8,185,859.76 4,787.98 4,052,659.80 7,000,000.00 4,000,000.00 2,000,000.00 25,243,307.54 Ending Market Value 8,185,859.76 4,787.98 4,052,659.80 7,000,000.00 4,000,000.00 2,000,000.00 25,243,307.54 General 001 2,612,548.74 4,787.98 3,039,494.85 5,000,000.00 2,400,000.00 800,000.00 13,856,831.57 Utility 002 2,664,298.31 - 1,013,164.95 2,000,000.00 1,500,000.00 400,000.00 7,577,463.26 Debt Services 005 70,753.57 - - - 100,000.00 200,000.00 370,753.57 Employee Benefit 007 316,298.83 - - - - 200,000.00 516,298.83 Self Ins. 008 229,983.51 - - - - 200,000.00 429,983.51 Hotel/Motel Tax 010 198,984.56 - - - - - 198,984.56 Economic Development 012 307,835.37 - - - - 200,000.00 507,835.37 Grant Fund 013 - - - - - - - Community Services 014 16,234.51 - - - - - 16,234.51 Drainage Fees 015 - - - - - - - Capital Replacement 016 535,011.45 - - - - - 535,011.45 Utility Capital Improvement 017 219,196.67 - - - - - 219,196.67 Court Technology 018 - - - - - - - Solid Waste 019 238,266.99 - - - - - 238,266.99 Street 020 - - - - - - - Parks 024 - - - - - - - Capital Improvement 025 - - - - - - - Traffic Enforcement Program 031 369,679.73 - - - - - 369,679.73 Abandoned Asset Forfeiture 050 - - - - - - - State Asset Forfeiture 051 - - - - - - - Federal Asset Forfeiture 052 - - - - - - - Court Security 225 278,383.55 - - - - - 278,383.55 Juvenile Case Manager 230 128,783.55 - - - - - 128,783.55 EDC C.O. CIP 455 - - - - - - -