Extracted text (via pymupdf_layout)
31012 characters
Royce T. Flora, Treasurer 301 West Jefferson St., Rm. 100 Phoenix, Arizona 85003 Phone: (602) 506-8511 Fax: (602) 506-1102 http:Mreasurer.maricopa.gov Maricopa County Treasurer DATE: September 11, 2017 TO Denny Barney, Chairman Steve Chucri, Supervisor, District 2 Bill Gates, Supervisor, District 3 Clint Hickman, Supervisor, District 4 Steve Gallardo, Supervisor, District 5 SUBJECT: Treasurer's Collections and Investment Summary for August 2017 Total secured property tax collections through the 2016 tax year ending in August equaled $4,579,542,318 or 99.1% of the adjusted 2016 levy of $4,620,421,742. Property taxes of $6,067,776 were collected the month of August 2017 for the 2016 tax year. On August 28th, 2017 the 2017 property taxes posted. Total secured property tax collections starting on August 28th, 2017 for the 2017 tax year equaled $22,406,107 or 0.5% of the adjusted 2017 levy of $4,791,587,057. The charts below reflect the collected and uncollected levy amounts and corresponding percentages for the 2016 and 2017 tax year. AUGUST AUGUST Collected Levy 2016 Uncollected 2017 $4,579,542,318 Levy 99.1% $4,769,180,949 99.5% Uncollected Collected Levy Levy $22,406,107 $40,879,425 0.5% 0.9% • Collected Levy • Uncollected Levy • Collected Levy • Uncollected Levy The County's General Fund Balance totaled $79,098,986.34 effective August 31, 2017. Warrants outstanding of $5,376,523.29 will post against the fund balances when presented. The $21,473,929 unencumbered balance, of the County Municipal Line of Credit and the $13,526,071 Workers Compensation Liability Letter of Credit remain unused. Submitted under oath, Russell K. Pearce Chief Deputy Treasurer STATE OF ARIZONA ) ss. COUNTY OF MARICOPA ) This instrument was acknowledged before me this 11th day of September 2017, by Russell K. Pearce, as Chief Deputy Treasurer of Maricopa County, State of Arizona, known to me to be the person whose name is subscribed to the foregoing instrument and who acknowledged to me that they executed the same for and on behalf of the State of Arizona for the purpose and consideration therein expressed. 0- dmaLL Notary Public My Commission Expires KAREN D. SMITH Notary Public - Arizona Maricopa County My Comm. Expires Dec 15, 2017 Investments Portfolio Maricopa County Treasurer Investments Portfolio Report 08/31/2017 - 153 Investments Account 10-151-156 COUNTY SCHOOL TANS Invest * Type Face Amt Mat Date Market Value MV Date Book Value Rate YTM DIM 2017000136 TANS $48,000,000 07/18/2018 $48,083,040.00 7/26/2017 $48,083,040,00 1.6700% 1.4905% 321 2017000137 TANS $35,000,000 07/18/2018 $35,060,550.00 7/26/2017 $35,060,550.00 1,6700% 1,4905% 321 2017000138 TANS $23,000,000 07/18/2018 $23,039,790.00 7/26/2017 $23,039,790.00 1.6700% 1,4905% 321 2017000139 TANS $14,000,000 07/18/2018 $14,024,220.00 7/26/2017 $14,024,220.00 1.6700% 1.4905% 321 2017000140 TANS $16,000,000 07/18/2018 $16,027,680.00 7/26/2017 $16,027,680.00 1.6700% 1.4905% 321 2017000141 TANS $10,000,000 07/18/2018 $10,017,300.00 7/26/2017 $10,017,300.00 1.6700% 1.4905% 321 2017000142 TANS $41,000,000 07/18/2018 $41,070,930.00 7/26/2017 $41,070,930.00 1.6700% 1.4905% 321 2017000143 TANS $10,000,000 07/18/2018 $10,017,300.00 7/26/2017 $10,017,300.00 1.6700% 1,4905% 321 2017000144 TANS $3,000,000 07/18/2018 $3,005,190.00 7/26/2017 $3,005,190,00 1.6700% 1,4905% 321 2017000154 TANS $15,000,000 07/18/2018 $15,023,850.00 8/24/2017 $15,023,850.00 1.6700% 1,4910% 321 10 Acct 10-151- $215,000,000.00 $215,369,850.00 $215,369,850.00 1.490523% 321 156 Totals: Account 10-151-556 FIXED INCOME Invest # Type Face Amt Mat Date Market Value MV Date Book Value Pate YTM 2014000206 FNMA $25,000,000 10/26/2017 $25,042,500.00 8/31/2016 $24,888,250.00 0.8750% 1.0299% 56 2015000132 FHLMC $25,000,000 06/22/2018 $25,152,500.00 8/31/2016 $25,077,250.00 1.2500% 1.1433% 295 2015000175 FHLMC $20,000,000 06/29/2018 $20,000,000.00 8/31/2016 $20,000,000.00 1.0500% 1.0500% 302 2015000205 FHLMC $25,000,000 07/27/2018 $24,960,000.00 8/31/2016 $25,000,000.00 1.0000% 1.0000% 330 2015000206 FHLMC $25,000,000 10/29/2018 $25,012,500.00 8/31/2016 $25,000,000.00 1.1000% 1.1000% 424 2015000207 FHLMC $15,000,000 10/29/2018 $15,007,500.00 8/31/2016 $15,000,000.00 1.1000% 1.1000% 424 2015000208 FFCB $25,000,000 07/30/2018 $24,980,000.00 8/31/2016 $24,990,500.00 0.8750% 0.8890% 333 2015000212 FHLMC $30,000,000 08/03/2018 $30,009,000.00 8/31/2016 $30,000,000.00 1.0000% 1.0000% 337 2015000213 FNMA $35,000,000 05/03/2019 $35,014,000.00 8/31/2016 $35,000,000.00 1.2600% 1.2600% 610 2015000214 FFCB $30,000,000 08/02/2018 $30,000,000.00 8/31/2016 $30,000,000,00 1,0200% 1.0200% 336 2015000222 FNMA $25,000,000 10/29/2018 $25,000,000.00 8/31/2016 $25,000,000.00 1.1250% 1.1250% 424 2015000223 FHLMC $15,000,000 04/26/2018 $14,997,000.00 8/31/2016 $15,000,000.00 0.9500% 0.9500% 238 2015000226 FNMA $15,000,000 11/16/2018 $14,988,000.00 8/31/2016 $14,985,000.00 1.1600% 1.1940% 442 2015000238 FHLB $20,000,000 12/28/2018 $20,040,000.00 8/31/2016 $20,000,000.00 1.3300% 1.3300% 484 2016000038 FHLB $15,000,000 12/28/2018 $15,033,000.00 8/31/2016 $15,000,000.00 1.2500% 1.2500% 484 2016000055 FHLMC $22,425,000 07/27/2018 $22,425,000.00 8/31/2016 $22,425,000.00 1.0000% 1.0000% 330 2016000082 FNMA $20,000,000 06/13/2019 $20,022,000.00 8/31/2016 $20,000,000.00 1.4000% 1.4000% 651 2016000083 FHLB $20,000,000 05/23/2018 $20,010,000.00 8/31/2016 $19,993,000.00 1.0000% 1.0177% 265 2016000085 FHLB $17,000,000 06/29/2018 $17,001,700.00 8/31/2016 $16,959,030.00 0.8750% 0.9911% 302 2016000086 FHLMC $25,000,000 05/24/2019 $24,895,000.00 8/31/2016 $24,970,000.00 -1.3000% 1.3413% 631 2016000098 FHLMC $25,000,000 12/28/2017 $24,990,000.00 8/31/2016 $25,000,000.00 0.8000% 0,8000% 119 2016000102 FNMA $20,000,000 06/28/2019 $20,000,000.00 8/31/2016 $19,984,800.00 1.2000% 1.2259% 666 2016000103 FHLMC $30,000,000 06/27/2018 $29,988,000.00 8/31/2016 $30,000,000.00 0.9100% 0,9100% 300 2016000104 FNMA $30,000,000 07/05/2019 $29,877,000.00 8/31/2016 $30,000,000.00 1.1400% 1.1400% 673 2016000110 FFCB $25,000,000 07/05/2019 $24,945,000.00 8/31/2016 $25,000,000.00 1.0200% 1.0200% 673 2016000111 FNMA $25,000,000 07/12/2019 $24,910,000.00 8/31/2016 $25,000,000.00 1,0500% 1.0500% 680 2016000114 FFCB $25,000,000 01/13/2020 $24,882,500.00 8/31/2016 $25,000,000.00 1.2400% 1.2400% 865 2016000115 FNMA $25,000,000 07/26/2019 $24,820,000,00 8/31/2016 $25,000,000.00 1,0000% 1.0000% 694 2016000119 FFCB $22,090,000 01/07/2019 $22,021,521.00 8/31/2016 $22,073,432.50 1.0000% 1.0303% 494 file:////treasishares/Userflome/thompsonm007/My%20Documents/Portfolio%20Report%20(detailed)%2Orev%208_31_17html[9/12/2017 1:49:33 PM] Investments Portfolio 2016000121 FHLB $20,000,000 10/11/2019 $19,902,000.00 8/31/2016 $19,978,000.00 1.1250% 1.1596% 771 2016000130 FFCB $20,000,000 03/22/2018 $19,974,000.00 8/31/2016 $20,003,400.00 0.8000% 0,7898% 203 2016000131 FFCB $25,000,000 03/22/2018 $24,967,500.00 8/31/2016 $25,000,000.00 .8000 0/0 0.8000% 203 2016000134 FHLB $20,000,000 05/18/2018 $19,968,000.00 8/31/2016 $20,000,000.00 0.9000% 0.9000% 260 2016000135 FNMA $20,000,000 07/26/2019 $19,930,000.00 8/31/2016 $20,000,000.00 1.12500/o 1.1250% 694 2016000136 FFCB $26,000,000 06/27/2019 $25,950,600.00 8/31/2016 $25,997,400.00 0.9500% 0.9535% 665 2016000148 FNMA $20,000,000 01/28/2020 $19,930,000.00 8/31/2016 $20,000,000.00 1.3300% 1.3300% 880 2016000149 FHLB $14,435,000 04/26/2019 $14,400,356.00 8/31/2016 $14,435,000.00 1.1000% 1.1000% 603 2016000150 rEiLB $5,565,000 04/26/2019 $5,551,644.00 8/31/2016 $5,565,000.00 1.1000% 1.1000 0/u 603 2016000157 FNMA $30,000,000 08/16/2019 $29,934,000.00 8/31/2016 $30,000,000.00 1.2000% 1.2000% 715 2016000158 FNMA $20,000,000 08/23/2019 $19,978,000.00 8/31/2016 $20,000,000.00 1.2500% 1.2500 0/u 722 2016000164 FHLMC $20,000,000 09/21/2018 $20,000,000.00 9/8/2016 $20,000,000.00 1.0000% 1.0000% 386 2016000166 FNMA $20,000,000 09/15/2020 $20,000,000.00 9/9/2016 $20,000,000.00 1.4500% 1.4500% 1111 2016000173 FNMA $25,000,000 10/17/2019 $275,000,00 10/6/2016 $24,946,250.00 1.1000% 1.1732% 777 2016000176 FNMA $30,000,000 10/17/2019 $30,000,000,00 10/6/2016 $30,000,000.00 1.2300% 1.2300% 777 2016000180 FNMA $25,000,000 07/27/2020 $25,000,000.00 10/7/2016 $25,000,000.00 1.4000% 1.4000% 1061 2016000191 FNMA $30,000,000 10/27/2020 $30,000,000.00 10/11/2016 $30,000,000.00 1.4050% 1.4050% 1153 2016000194 FFCB $13,073,000 01/28/2019 $13,073,000.00 10/12/2016 $13,073,000.00 1.2700% 1.2700% 515 2016000195 FHLMC $30,000,000 11/02/2020 $30,000,000.00 10/12/2016 $30,000,000.00 1.3650% 1.3650% 1159 2016000196 FHLMC $25,000,000 10/26/2018 $25,000,000.00 10/12/2016 $25,000,000.00 1.0500% 1.0500% 421 2016000198 FHLMC $30,000,000 11/02/2018 $30,000,000.00 10/18/2016 $30,000,000.00 0.9300% 0.9300% 428 2016000200 FNMA $17,965,000 10/28/2019 $17,960,508.75 10/19/2016 $17,960,508.75 1.2500% 1.2585% 788 2016000201 FNMA $18,910,000 09/30/2019 $18,905,272.50 10/19/2016 $18,905,272.50 1.2500% 1.2587% 760 2016000206 FNMA $25,000,000 07/28/2020 $25,000,000.00 10/24/2016 $25,000,000.00 1.3000% 1.3000% 1062 2016000209 FNMA $20,000,000 07/28/2020 $20,000,000.00 10/25/2016 $20,000,000.00 1.3500% 1.3500% 1062 2016000212 FHLMC $20,000,000 11/27/2019 $20,000,000.00 10/27/2016 $20,000,000.00 1.3000% 1.3000% 818 2016000215 FHLMC $20,000,000 11/10/2020 $20,000,000.00 10/27/2016 $20,000,000.00 1.4000% 1,4000% 1167 2016000233 FHLMC $20,000,000 11/27/2019 $20,000,000.00 11/9/2016 $20,000,000.00 1.3000% 1.3000% 818 2016000237 FFCB $25,000,000 12/05/2018 $25,000,000.00 11/18/2016 $24,975,355.25 1.1000% 1.1497% 461 2016000238 FNMA $25,000,000 11/26/2019 $25,000,000.00 11/22/2016 $25,000,000.00 1.5000% 1.5000% 817 2016000239 FNMA $15,000,000 05/26/2020 $15,000,000.00 11/23/2016 $15,000,000.00 1,6250% 1.6250% 999 2016000241 FHLMC $25,000,000 12/13/2019 $25,000,000.00 11/15/2016 $25,000,000.00 1.5100% 1.5100% 834 2016000243 FNMA $20,000,000 06/29/2020 $20,000,000.00 12/14/2016 $20,000,000.00 1.7500% 1.7500% 1033 2016000245 FNMA $25,000,000 01/17/2020 $25,000,000.00 12/22/2016 $25,000,000.00 1.7500% 1.7500% 869 2017000004 FNMA $30,000,000 01/27/2020 $30,000,000.00 1/6/2017 $30,000,000.00 1.7000% 1.7000% 879 2017000007 FHLB $10,000,000 07/30/2020 $10,000,000.00 1/12/2017 $10,000,000.00 1.7500% 1.7500% 1064 2017000017 FHLMC $15,000,000 05/25/2018 $14,998,500.00 2/9/2017 $14,998,500.00 1.0000% 1.0078% 267 2017000031 FHLMC $25,500,000 09/29/2020 $25,500,000.00 3/2/2017 $25,500,000.00 2.0000% 2.0000% 1125 2017000034 FFCB $12,000,000 03/13/2020 $12,000,000.00 3/6/2017 $12,000,000.00 1,8000% 1.8000% 925 2017000047 FHLMC $10,000,000 03/27/2020 $170,000.00 3/27/2017 $10,000,000.00 1,7000% 1.7000% 939 2017000048 FHLMC $25,000,000 07/11/2019 $25,000,000.00 3/28/2017 $25,000,000.00 1.5000% 1.5000% 679 2017000059 FHLMC $20,000,000 01/26/2021 $20,000,000.00 4/18/2017 $20,000,000.00 1.7500% 1.7500% 1244 2017000060 FFCB $25,000,000 05/21/2018 $24,999,750.00 4/18/2017 $24,994,500.00 1.1000% 1.1203% 263 2017000061 FHLMC $20,000,000 05/15/2020 $20,000,000.00 4/18/2017 $20,000,000.00 1.7000% 1.7000% 988 2017000067 FHLMC $25,000,000 08/16/2019 $25,000,000.00 4/24/2017 $25,000,000.00 1.50000/0 1.5000% 715 2017000070 FHLB $25,000,000 07/26/2019 $24,963,250.00 4/26/2017 $24,963,250.00 1.3750% 1.4417% 694 2017000074 FHLMC $25,000,000 05/11/2018 $24,946,000,00 4/27/2017 $24,946,000.00 1.0000% 1.2078% 253 2017000079 FHLB $30,000,000 02/03/2020 $30,000,000,00 4/28/2017 $30,000,000.00 1.6000% 1.6000°/.3 886 2017000091 FHLMC $30,000,000 08/17/2020 $30,000,000,00 5/3/2017 $30,000,000.00 1.7000% 1.7000% 1082 2017000095 FHLMC $25,000,000 05/18/2020 $25,000,000.00 55/2017 $25,000,000.00 1.7000% 1.7000% 991 2017000096 FFCB $12,250,000 05/17/2021 $12,250,000.00 5/5/2017 $12,250,000.00 1.9700% 1.9700% 1355 2017000113 FHLMC $20,000,000 12/27/2019 $20,000,000.00 6/28/2017 $20,000,000.00 1.5500% 1.5500% 848 2017000114 FHLB $25,000,000 06/29/2020 $25,000,000.00 6/28/2017 $25,000,000.00 1.6900% 1.6900% 1033 2017000122 FHLMC $30,000,000 08/07/2020 $30,000,000.00 7/6/2017 $30,000,000.00 1.8500% 1.8500% 1072 2017000123 FHLMC $30,000,000 07/19/2019 $30,000,000.00 7/6/2017 $30,000,000.00 1.5000% 1.5000% 687 2017000149 FHLMC $25,000,000 04/13/2020 $25,023,750.00 8/7/2017 $25,167,500.00 1.8000% 1.7634% 956 2017000150 FHLB $15,000,000 06/26/2020 $14,981,100.00 8/8/2017 $15,010,214.58 1.6250% 1.6702% 1030 file:////treasishares/Userflome/thompsonm007/My%20Doeuments/Portfolio%20Report °A20(rietailed)%2Orev%208_31 17.html[9/12/2017 1:49:33 PM] Investments Portfolio 2017000100 FHDN $13,600,000 11/15/2017 $13,528,838.00 5/16/2017 $13,528,838.00 1.0350% 1.0549% 76 2017000109 FM CON $35,000,000 10/13/2017 $34,869,406.25 5/31/2017 $34,869,406.25 0.9950% 1,0126% 43 2017000116 FHDN $45,000,000 06/27/2018 $44,460,037.50 7/3/2017 $44,460,037.50 1.2100% 1,2417% 300 2017000117 FMCDN $45,000,000 05/29/2018 $44,516,200,00 7/5/2017 $44,516,200.00 1.1800% 1.2094% 271 2017000118 FHDN $35,000,000 09/11/2017 $34,933,227.78 7/5/2017 $34,933,227.78 1.0100% 1.0260% 11 2017000119 FHDN $40,000,000 09/12/2017 $39,922,555.56 7/6/2017 $39,922,555.56 1.0250% 1.0413% 12 2017000120 FHDN $15,000,000 12/29/2017 $14,917,133.33 7/6/2017 $14,917,133.33 1.1300% 1.1521% 120 2017000124 FHDN $6,600,000 09/06/2017 $6,588,537.08 7/7/2017 $6,588,537.08 1.0250% 1.0410 0/u 6 2017000125 FHDN $30,500,040 09/06/2017 $30,447,285.83 7/7/2017 $30,447,285.83 1.0200% 1.0360% 6 2017000126 FNDN $35,000,000 10/23/2017 $34,894,854.17 7/7/2017 $34,894,854.17 1.0300% 1.0475% 53 2017000127 FHDN $30,000,000 10/06/2017 $29,920,754.17 7/7/2017 $29,920,754.17 1,0450% 1.0623% 36 2017000128 FCDN $40,000,000 06/27/2018 $39,507,200.00 7/10/2017 $39,507,200.00 1,2600% 1.2934% 300 2017000129 FMCDN $40,000,000 05/31/2018 $39,573,400.00 7/10/2017 $39,573,400.00 1.1850% 1.2144% 273 2017000130 FHDN $35,000,000 12/29/2017 $34,818,787.50 7/10/2017 $34,818,787.50 1.0900% 1.1109% 120 2017000131 FHDN $25,000,000 09/07/2017 $24,959,822.92 7/11/2017 $24,959,822.92 1.0150% 1.0308% 7 2017040132 FHDN $40,000,000 09/19/2017 $39,922,566.67 7/12/2017 $39,922,566.67 1.0100% 1,0260% 19 2017000133 FHDN $30,000,000 12/26/2017 $29,850,600.00 7/12/2017 $29,850,600.00 1,0800% 1,1005% 117 2017000134 FHDN $35,000,000 09/13/2017 $34,944,466.67 7/18/2017 $34,944,466.66 1.0200% 1.0358% 13 2017000135 FCDN $25,000,000 12/27/2017 $24,878,541.67 7/21/2017 $24,878,541.67 1,1000 0/0 1.1207% 118 2017000145 FHDN $40,000,000 09/20/2017 $39,937,238.89 7/26/2017 $39,937,238.89 1.0270% 1.0429% 20 2017000146 FHDN $22,000,000 09/22/2017 $21,964,922.22 7/27/2017 $21,964,922.22 1.0250% 1.0409% 22 2017000148 FHDN $25,000,000 09/14/2017 $24,966,500.00 7/28/2017 $24,966,500,00 1.0050% 1.0203% 14 2017000151 FHDN $30,000,000 09/26/2017 $29,961,068.33 8/9/2017 $29,961,068.33 0,9940% 1.0091% 26 2015000235 -Mote $30,000,000 12/31/2017 $30,003,000.00 8/31/2016 $29,852,343.75 0,7500% 0.9872% 122 2015000241 TNote $20,000,000 12/31/2017 $20,066,000.00 8/31/2016 $19,972,656.25 1.0000% 1.0684% 122 2016000160 TNote $25,000,000 12/15/2018 $25,225,000,00 8/31/7016 $25,250,976.56 1.2500% 0.8043% 471 2016000230 TNote $30,000,000 06/30/2018 $29,927,343.75 11/7/2016 $29,927,343.75 0.6250% 0.7738% 303 2017000006 TNote $25,000,000 06/30/2019 $25,169,921.88 1/10/2017 $25,169,921.88 1.6250% 1.3421% 668 2017000089 TNote $30,000,000 06/30/2020 $30,105,468.75 5/3/2017 $30,105,468.75 1.6250% 1.4995% 1034 2017000094 TNote $25,000,000 05/15/2019 $24,777,343.75 5/5/2017 $24,777,343.75 0.8750% 1.3224% 622 116 Acct 10-151- $2,834,913,000.00 $2,796,113,974.92 $2,831,355,412.80 1.226517% 518 556 Totals; Account 10-151-567 COUNTY SCHOOL BONDS Invest # Type Face Amt Mat Date Market Value MV Date Book Value Rate YTM DTM 2013000162 SDPB $75,000 01/01/2018 $89,799.75 5/15/2013 $89,799.75 5.2300% 0.8615% 123 2013000167 SDPB $4,190,000 01/01/2018 $5,100,696.50 5/15/2013 $5,100,696.50 5.6500% 0.8424% 123 2013000175 SDPB $4,530,000 01/01/2018 $4,820,690.10 5/17/2013 $4,820,690.10 2.3000% 0.8768% 123 2013000187 SDPB $8,600,000 01/01/2018 $9,656,252.00 5/23/2013 $9,656,252.00 3.6500% 0.9123% 123 2013000206 SDPB $370,000 01/01/2018 $411,636.10 6/5/2013 $411,636.10 3.6200% 1.0747% 123 2013000741 SDPB $235,000 07/01/2018 $237,876.40 7/24/2013 $237,876.40 1,9800% 1.7146% 304 2013000289 SDPB $16,775,000 07/01/2018 $16,862,062.25 10/1/2013 $16,862,062.25 1.9750% 1.8576% 304 2014000091 SDPB $3,000,000 07/01/2018 $3,000,000.00 5/1/2014 $3 ,000,000.00 1.6300% 1.6300% 304 2014000131 SDPB $135,000 07/01/2018 $138,221.10 7/3/2014 $138,221.10 2.2900% 1.6616% 304 2014000132 SDPB $370,000 07/01/2019 $375,072.70 7/3/2014 $375,072.70 2.2900% 1.9921% 669 2015000073 SDPB $1,500,000 07/01/2018 $1,500,000.00 5/12/2015 $1,500,000.00 1.2700% 1.2700% 304 2015000074 SDPB $3,000,000 07/01/2019 $3,000,000.00 5/12/2015 $3,000,000,00 1.5700% 1.5700% 669 2016000168 SDPB $2,025,000 07/01/2020 $2,190,888.00 9/1/2016 $2,190,888,00 3.5700% 1.3245% 1035 2016000169 SDPB $4,130,000 07/01/2021 $4,532,881.50 9/1/2016 $4,532,881.50 3.5700% 1,4191% 1400 2016000181 SDPB $1,040,000 07/01/2018 $1,040,000.00 10/6/2016 $1,040,000.00 1.0300% 1.0300% 304 2016000182 SDPB $1,030,000 07/01/2019 $1,030,000.00 10/6/2016 $1,030,000.00 1.1300% 1.1300% 669 2016000183 SDPB $1,650,000 07/01/2020 $1,650,000.00 10/6/2016 $1,650,000.00 1.3000% 1.3000% 1035 2016000184 SDPB $1,355,000 07/01/2021 $1,355,000.00 10/6/2016 $1,355,000.00 1.4200% 1.4200% 1400 2016000185 SDPB $210,000 07/01/2018 $217,028.70 10/6/2016 $217,028.70 3,0000% 1.0434% 304 2016000186 SDPB $215,000 07/01/2019 $225,734.95 10/6/2016 $225,734.95 3.0000% 1.1315% 669 2016000187 SDPB $1,045,000 07/01/2020 $1,166,011.00 10/6/2016 $1,166,011.00 4.5000% 1.2818% 1035 file:////treas/shares/UserHomelthompsonm007/My%20Documents/Portfolio%20Report%20(detailed)%2Orev%208_31_17.html(9/12/2017 1:49:33 PM] Investments Portfolio 2016000188 SDPB $1,095,000 07/01/2021 $1,095,000.00 10/6/2016 $1,095,000.00 1.4200% 1.4200% 1400 22 Acct 10-151- $56,575,000.00 $59,694,851.05 $59,694,851.05 1.379488% 465 567 Totals: Account 32-001-534 MIHS MAIN DEPOSITORY Invest # Type Face Amt Mat Date Market Value MV Date Book Value Rate YTM PTM 2017000147 FHDN $50,300,000 02/02/2018 $50,009,517.50 7/27/2017 $50,009,517.50 1,1000% 1.1218% 155 1 Acct 32-001- $50,300,000.00 $50,009,517.50 $50,009,517.50 1.121756% 155 534 Totals: Account 32-535-534 MIHS MCOPA HEALTH PLAN Invest # Type Face Amt Mat Date Market Value MV Date Book Value Rate YTM DTM 2017000098 FFCB $12,400,000 11/01/2018 $12,391,444.00 5/16/2017 $12,398,332.89 1.2500% 1.2975% 427 2017000104 FFCB $13,300,000 11/26/2018 $13,292,818.00 5/18/2017 $13,292,818.00 1.2200% 1.2561% 452 2017000099 , FHDN $6,400,000 11/15/2017 $6,366,512.00 5/16/2017 $6,366,512.00 1.0350% 1.0549% 76 3 Acct 32-535- $32,100,000.00 $32,050,774.00 $32,057,662.89 1.231972% 367 534 Totals: Account 32-700-534 MIHS DEBT INTEREST & REDEMPTION FUND Invest # Type Face Amt Mat Date Market Value MV Date Book Value Rate YTM DTM 2017000105 TNote $3,200,000 06/15/2018 $3,198,875.00 5/19/2017 $3,198,875,00 1.1250% 1.1528% 288 1 Acct 32-700- $3,200,000.00 $3,198,875.00 $3,198,875.00 1.152830% 288 534 Totals: Report Totals: $3,192,088,000.00 $3,156,437,842.47 $3,191,686,169.24 1.245340% 496 file:////treas/shares/Userliome/thompsonm007/1vIy%20Documents/Portfolio%2OReport%20(detailed)°A2Orev%208_31_17.httnl[9/12/2017 1:49:33 MO Investments Portfolio Summary Maricopa County Treasurer Investments Portfolio Summary Report 08/31/2017 - 153 Investments Issue Type Count Par Value Market Value Book Value !IM . D IM FCDN 2 $65,000,000.00 $64,385,741.67 $64,385,741.67 1.227007% 230 FFCB 15 $311,113,000.00 $310,728,133.00 $311,048,738.64 1.107482% 508 FHDN 19 $554,400,000,00 $552,420,371.95 $552,420,371.94 1.071306% 69 FHLB 13 $237,000,000.00 $236,851,050.00 $236,903,494.58 1.327392% 658 FHLMC 33 $772,925,000.00 $763,074,750.00 $773,084,250.00 1.326566% 659 FMCDN 3 $120,000,000.00 $118,959,006.25 $118,959,006.25 1.153666% 205 FNDN 1 $35,000,000.00 $34,894,854.17 $34,894,854.17 1.047452% 53 FNMA 27 $636,875,000.00 $611,586,281.25 $636,670,081.25 1.309312% 777 SDPB 22 $56,575,000.00 $59,694,851.05 $59,694,851.05 1.379488% 465 TANS 10 $215,000,000.00 $215,369,850.00 $215,369,850.00 1.490523% 321 TNote 8 $188,200,000.00 $188,472,953.13 $188,254,929.69 1.113674% 484 Report Totals: 153 $3,192,088,000.00 $3,156,437,842.47 $3,191,686,169.24 1.245340% 496 file:///11/Administration/Investments/Portfolio%20Summary%20Report%208-31-17.html[9/12/2017 9:45:42 AM] 1 05-SEP-2017 PAGE: BALANCE 197,750.52- 13,314,650.42- 3,062,441.15 873,664.74- 9,260,158.51- 28,449,736.92- 25,511,216.65- 22,886,230.37- 35,071,797.03- 28,750,862.95- 8,107,024.00 14,418,422.22- 17,542,008.94- 6,349,435.71- 950,427.40- 7,916,568.30- 21,536,144.42- 7,182,377.74- 25,772,613.27- 28,111,564.10- 12,928,887.66- 6,576,315.56- 22,905,048.43- 18,055,558.20- 17,272,723.82- 6,557,551.22- 6,812,702.12- 5,929,894.62- 2,691,654.20- 2,664,351.52- 5,472,248.17- 5,836,677.39- 2,953,558.51- 1,719,922.67- 433,497.42- 1,422,511.95- 2,320,992.14- 405,479,260.66- ENDING OFFICE .00 362.75- 546.22- 558.65- 568.57- 419.54- 22.60- 23.78- 25.89-' .00 .00 :00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 2,528.00- 2017 ADJUSTMENTS AUG TREASURER'S FOR ACTIVITY .00 199.17 63.79 83.57 199.20 23.23 .00 .00 .00 .00 .00 .09 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 569.05 COLLECTIONS AND COUNTY LEVY UNSECURED BALANCE 197,750.52- 13,314,088.50- 3,064,051.16 873,022.52- 9,259,390.74- 28,449,294.15- 25,511,194.05- 22,886,206.59- 35,071,771.14- 28,750,862.95- 8,107,024.00 14,418,422.13- 17,542,008.94- 6,349,435.71- 950,427.40- 7,916,568.30- 21,536,144.42- 7,182,377.74- 25,772,613.27- 28,111,564.10- 12,928,887.66- 6,576,315.56- 22,905,048.43- 18,055,558.20- 17,272,723.82- 6,557,551.22- 6,812,702.12- 5,929,894.62- 2,691,654.20- 2,664,351.52- 5,472,248.17- 5,836,677.39- 2,953,558.51- 1,719,922.67- 433,497.42- 1,422,511.95- 2,320,992.14- 405,476,163.61- MARICOPA BEGINNING LEVY .00 CO LEVY_RPT_MONTH_SUM 16,903,615.38 19,330,396.80 138,497,672.37 122,871,629.32 122,881,710.56 115,134,253.32 102,673,892.06 113,747,601.86 162,209,939.25 154,917,045.68 140,629,687.78 131,582,120.56 122,744,902.09 113,929,972.43 96,811,185.54 88,991,362.81 76,956,283.43 50,507,999.56 53,570,953.57 73,434,045.21 37,836,109.79 36,683,300.76 30,075,323.04 29,722,220.00 28,615,308.42 26,779,663.13 23,204,794.95 19,189,042.79 15,296,922.12 13,177,965.26 13,623,786.21 12,084,654.91 10,386,975.86 5,918,654.86 4,195,165.19 2,325,116,156.87 APP ID: YEAR 2004 2003 2002 2001 2000 1999 1998 1997 1996 1995 1994 1993 1992 1991 1990 1989 1988 1987 1986 1985 1984 1983 1982 1981 1980 1979 1978 1977 1976 1975 1974 1973 1972 1971 1970 1969 1968 TOTAL PROGRAM 05-SEP-2017 PAGE: BALANCE 4,769,180,949.23 40,879,424.65 2,844,535.58 1,792,428.15 1,266,814.53 1,059,480.53- 20,888,656.77 42,838,948.84- 87,196,201.47 26,198,816.38 563,265.91- 700,467.49- 577,324.35 631,124.98 733,659.05- 1,279,965.51- 641,280.31 572,605.45- 679,575.16- 762,845.98- 651,506.18- 78,784.46- 758,266.74- 1,128,169.02- 1,190,791.47 3,577,213.60 2,207,553.16 7,952,626.39 8,122,159.39 3,284,780.26- 22,363.14 17,523.14 86,095.02 21,166.00 28,887.27 11,576.64 13,532.33 11,278.23 15,972.66 17,517.30 12,427.08 12,599.20 10,864.89 8,954.20 6,216.48 5,885.92 4,111.30 1,998.26 922.38 331.83 4,920,365,803.10 ENDING OFFICE .00 493,758.89- 401,735.00- 140,400.08- 41,867.83- 27,717.19- 9,187.13- 11,878.97- 9,153.42- 2,784.36- 1,990.67- 1,623.44- 216.36- 89.12 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 1,142,224.22- 2017 ADJUSTMENTS AUG TREASURER'S FOR ACTIVITY 273,898.60- 32,588.05- 34,235.52- 22,317.71- 1,019.90- 6,714.72- 4,245.72- 691.10 790.38 417.50 306.16 217.14 85.46 .00 117.86 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 ' .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 COLLECTIONS 22,406,107.35 6,067,775.73 28,101,488.46 AND COUNTY LEVY SECURED BALANCE 4,791,587,056.58 47,440,959.27 2,972,371.98 1,900,240.18 1,274,446.84 1,054,081.05- 20,896,824.00 42,833,784.59- 87,201,109.17 26,202,291.84 560,484.86- 698,426.55- 577,846.87 631,253.00 733,573.59- 1,279,965.51- 641,398.17 572,605.45- 679,575.16- 762,845.98- 651,306.18- 78,784.46- 758,266.74- 1,128,169.02- 1,190,791.47 3,577,213.60 2,207,553.16 7,952,626.39 8,122,159.39 3,284,730.26- 22,363.14 17,523.14 86,095.02 21,166.00 28,887.27 11,576.64 13,532.33 11,278.23 15,972.66 17,517.30 12,427.08 12,599.20 10,864.89 8,954.20 6,216.48 5,885.92 4,111.30 1,998.26 922.38 331.83 4,949,609,515.78 MARICOPA BEGINNING LEVY_RPT_MONTH_SUM LEVY 4,791,587,056.58 4,643,191,878.76 4,364,407,727.86 4,243,506,812.16 4,019,480,209.28 4,045,298,460.92 4,138,461,193.04 4,411,089,394.04 4,593,263,862.913 4,288,606,572.70 4,001,594,678.74 3,660,387,436.00 3,489,841,477.20 3,246,259,075.84 3,049,037,955.00 2,792,576,236.72 2,595,278,869.32 2,290,234,573.96 2,108,718,697.02 1,939,463,904.72 1,800,100,859.36 1,631,715,958.46 1,683,783,514.12 1,507,769,663.58 1,476,046,063.04 1,477,426,592.42 1,485,482,338.84 1,445,084,095.32 1,306,266,536.54 1,181,440,841.12 1,049,888,299.56 870,295,854.72 721,770,831.08 600,944,379.84 530,525,148.42 451,214,378.40 402,942,488.,72 373,230,675.34 382,783,606.36 365,594,731.04 360,443,065.88 332,481,242.68 294,189,512.68 251,690,646.52 224,585,828.94 191,805,552.44 165,623,012.50 138,694,628.82 126,632,073.74 116,414,184.58 95,659,212,677.90 APP ID: YEAR 2017 2016 2015 2014 2013 2012 2011 2010 2009 2008 2007 2006 2005 2004 2003 2002 2001 2000 1999 1998 1997 1996 1995 1994 1993 1992 1991 1990 1989 1988 1987 1986 1985 1984 3.983 1982 1981 1980 1979 1978 1977 1976 1975 1974 1973 1972 1971 1970 1969 1968 TOTAL PROGRAM 671 31-AUG-2017 PAGE: 31-AUG-2017 OFFICE 543 33 1,256 579 5 48 263 143 406 39 39 115 181 296 1,350 843 2,193 142 126 268 130 10 191 331 3 61 64 32 98 130 4 2 92 98 907 907 13 11,877 14,341 - FUND TREASURER'S by DISTRICT COUNT Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: - WARRANTS AMOUNT 6,588.52 323,825.74 45,124.15 5,331,399.14 304,298.24 9,287.43 109,834.57 6,130,357.79 134,063.64 684,787.67 818,851.31 53,060.18 53,060.18 76,934.24 643,420.38 720,354.62 3,420,561.29 3,557,453.24 6,978,014.53 146,163.58 2,138,859.59 2,285,023.17 61,377.58 72,701.86 1,554,522.33 1,688,601.77 914.01 69,729.00 70,643.01 21,440.81 301,893.65 323,334.46 2,070.71 70,534.49 325,968.89 398,574.09 2,094,150.24 2,094,150.24 7,815.07 COUNTY WARRANT OUTSTANDING MARICOPA = = = = = .- = = = = = = = = = = = = = =. = = - = - = = = = = = = = = = = = = NUMBER Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total WARRANT Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund OTSTND_WT_FUND District District District District District District District District District District District DISTRICT 000 000 000 000 000 000 000 000 001 001 001 002 002 003 003 003 004 004 004 005 005 005 006 006 006 006 007 007 007 008 008 008 009 009 009 009 011 011 014 WTR ID: FUND 066 714 766 768 781 945 950 030 040 040 030 040 030 040 030 040 030 035 040 030 040 030 040 030 035 040 040 030 PROGRAM 2 05-SEP-2017 PAGE. Closing Balance 471,783.30 129,722.09 186,688.81 137,431.81 81,717.87 161,296.59 3,128,169.49 14,491,133.94 723,917.19 21,271.40- 508,244.83 10,563.15 32,179.99 295,028,63 1,550,240.39 1.00 5,581,752.68 159,813.96 1,101,842.03- 5,887,046.17 246,628.87 235,551.01 10,220.58 4,350.56 21,900,841.42 1,758.39- '722,190.11 737,839.04 4,106,873.33 41,577,711.15 79,098,986.34 79,098,986.34 89,017,33- Disbursements 395,036.16 395,036.16 1,509,852.15 842.35 2,533,697.32 3,288.50 1,516,990.02 27,810.05- 383,760.83 5,920,621.72 11,006,696-59 11,006,696.59 To 389,58 433.65 470.64 259.55 612.47 14,442.27 70,583.25 362.00 13,938,616.62 17,225,71 14,026,787.58 23,013,362.16 23,013,063.16 249,401.98 Transfer OFFICE From 495.55 28,376.98 .23 7,288.04 43,509,106.52 70,583.25 1,270.00 64.88 43,616,689.90 123,461,802.04 123,461,802.04 213,084.34 2017 REASURER'S AUG, of T Month the Income Distribution 165,401.50 12,002.46 13,922.87 14,783.81 7,739.36 20,342.40 943,880.16 3,355,108.90 1,538,229.13 355,924.45- 23,064.83- 22,249.99 1,181,524.20- 851.90 2,583,310.16 28,559,726.25 2,477,518.12 79,271.25- 2,149.53 1,908,764.28 3,393.97- 7,390,232.05- 1,040,307.75 29,110,696.19 50,609,174.71 50,609,174.71 COUNTY for Report MARICOPA Treasurer's Opening Balance 306,381.80 117,330.05 172,332.29 122,177.36 73,718.96 140,341.72 2,579,325.49 11,477,114.48 1,009,258.39 5,906.34- 475,994..90 10,563.15 1,213,704.19 842.35 293,814.73 1,550,240.39 1.00 5,581,752.66 117,483.76 91,079.38- 2,436,529.05 246,628.87 235,551.01 159,075.22 5,489.56 21,510,337.16 1,635.58 694,380.06 8,128,071.09 3,433,165.58 47,977,539.00 139,944,927,10 139,944,927,10 125,234.57- SERVICE 2149 REFUNDS SALES UNKNOWN SCHOOL DC VALLEY pc SC DC MEADOWS PROCESSING RESOLUTIONS HOLDING HE FUND INVESTMENT HOLD COLLECTIONS INCOME NON-DELIVERABLE TRUSTEE OR APPR BE COMPANIES Description CT JUVENILE SERVICES PENDERGA.ST NORTH TENTH WEST RIDGE DESERT JO HIGHLAND COUNTRY REVENUE HOLDING DEBITS/CREDITS HOLDING PENDING ASSIGN WITHHOLDING INFORMATION IMPOUNDS HOLDING CONVERSION - ASSISTANCE ASSISTANCE HOLDING TAX INTEREST ACT FOR HOLDING HOLDING REFUNDING FROM WIRES TO MONEY CASHIER'S MORTGAGE CHARGE FUNDS WAREHOUSE ACCT ENVIR ACCT ACCT ACCOUNT ACCOUNT ACCT ACCT ACCOUNT ACCT CLEARING CLEARING REFUND TAX CASHIER'S RESOLUTION LITIGATION AND SUBTAX INTEREST TAXPAYER RESOLUTION PENALTY COURSE HOLDING ELDERLY ELDERLY REDEMPTION UNDISTRIBUTED UNDISTRIBUTED GRAZING TAYLOR FUND TRUST CHECK PROBLEM TAX CURRENT FEE RECORDER PROCEEDS EXCESS UNIDENTIFIED FD HLD SUSPENSE SUSPENSE SERVICE SUSPENSE-PREPAYMENTS SUSPENSE FUNDS TREAS GENERAL GENERAL COUNTY SHERIFF FUND_BAL_MTD DEP DEP DEP DEP DEP DEP DEP DEP DEP CE? BACK IRS UPPS CIVIL GOLF CPLET TEMP BANK ACC ID: Account Number 30-025-184 30-025-185 30-025-186 30-025-187 30-025-188 30-025-189 30-025-190 30-025-191 30-025-199 1 - Total 30-026-000 30-027-000 30-92E-000 30-033-000 30-034-000 30-035-000 30-036-000 30-041-000 30-042-030 30-243-000 30-044-000 30-045-000 30-045-300 30-049-000 30-050-000 30-059-000 30-060-000 30-061-000 30-062-000 30-063-000 30-064-000 30-066-000 30-077-000 30-086-000 30-090-000 30-091-000 30-092-000 30-093-000 30-094-003 30-099-000 1 - Total 30-100-000 1 - Total 31-120-000 Program