OCTOBER MONTHLY REPORT2017.PDF

Royce T. Flora, Treasurer
301 West Jefferson St., Rm. 100
Phoenix, Arizona 85003
Maricopa County Phone: (602) 506-8511
Fax: (602) 506-1102
Treasurer http://treasurer.maricopa.gov
DATE: November 06, 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 October 2017
Secured property tax collections during the month of October equaled $1,606,033,574 and
increased the 2017 year to date collections to $1,974,899,583 or 41% of the adjusted 2017 levy of
$4,783,265,913. The chart below reflects the 2017 collected and uncollected levy amount and
corresponding percentages for the 2017 property tax year.
OCTOBER
2017
Uncollected Levy
$2,808,366,330
59% 41111
gib
Collected Levy
$1,974,899,583
41%
• Collected Levy • Uncollected Levy
The County's General Fund Balance totaled $278,158,831.49 effective October 31, 2017.
Warrants outstanding of $4,398,837.14 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.
Wed under oath,
Russell K. Pearce
Chief Deputy Treasurer
STATE OF ARIZONA ) ss.
COUNTY OF MARICOPA )
This instrument was acknowledged before me this 7th day of November 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.
J9ta,k / 7
Notary Public My Commission Expires
KAREN D. SMITH
Notary Public - Arizona
Maricopa County
My Comm. Expires Dec 15, 2017

Investments Portfolio Summary Page 1 of 1
Maricopa County Treasurer Investments
Portfolio Summary Report
10/31/2017 - 161 Investments
Issue Type Count Par Value Market Value Book Value YTM DTM
FCDN 2 $65,000,000.00 $64,385,741,67 $64,385,741.67 1,227007% 169
FFCB 14 $299,113,000.00 $298,728,133.00 $299,048,738.64 1.079699% 430
FHDN 22 $500,300,000.00 $498,043,337.63 $498,043,337.63 1.119869% 91
FHLB 14 $252,000,000.00 $251,828,550.00 $251,882,244.58 1.343707% 593
FHLMC 33 $767,425,000.00 $757,554,750.00 $767,424,388.89 1.316130% 594
FMCDN 6 $167,000,000.00 $165,775,228.47 $165,775,228.47 1.187529% 166
FNDN 3 $60,000,000.00 $59,925,337.50 $59,925,337.50 1.005001% 38
FNMA 27 $631,875,000.00 $606,523,781.25 $631,781,275.69 1.335433% 755
SDPB 22 $56,575,000.00 $59,694,851.05 $59,694,851.05 1.379488% 404
TANS 10 $215,000,000.00 $215,369,850.00 $215,369,850.00 1.490523% 260
TNote 8 $188,200,000.00 $188,472,953.13 $188,254,929,69 1.113674% 423
Report Totals: 161 $3,202,488,000.00 $3,166,302,513.70 $3,201,585,923.81 1.255951% 455
file:///ClUsers/Thompsonm007/AppData/Local/Temp/tmpFDAC.html 11/6/2017

Investments Portfolio Page 1 of 5
Marieopa County Treasurer 'Investments
Portfolio Report
10/31/2017 - 161 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% 260
2017000137 TANS $35,000,000 07/18/2018 $35,060,550.00 7/26/2017 $35,060,550.00 1.6700% 1.4905% 260
2017000138 TANS $23,000,000 07/18/2018 $23,039,790.00 7/26/2017 $23,039,790.00 1.6700% 1.4905% 260
2017000139 TANS $14,000,000 07/18/2018 $14,024,220.00 7/26/2017 $14,024,220,00 1.6700% 1.4905% 260
2017000140 TANS $16,000,000 07/18/2018 $16,027,680.00 7/26/2017 $16,027,680.00 1.6700% 1.4905% 260
2017000141 TANS $10,000,000 07/18/2018 $10,017,300.00 7/26/2017 $10,017,300.00 1.6700°k 1.4905% 260
2017000142 TANS $41,000,000 07/18/2018 $41,070,930.00 7/26/2017 $41,070,930.00 1.6700% 1.4905% 260
2017000143 TANS $10,000,000 07/18/2018 $10,017,300.00 7/26/2017 $10,017,300.00 1.6700% 1.4905% 260
2017000144 TANS $3,000,000 07/18/2018 $3,005,190.00 7/26/2017 $3,005,190.00 1.6700% 1.4905% 260
2017000154 TANS $15,000,000 07/18/2018 $15,023,850.00 8/24/2017 $15,023,850.00 1.6700°k 1.4910% 260
10 Acct 10-151- $215,000,000.00 $215,369 , 85 0 .00 $215,369,850.00 1.490523% 260
156 Totals:
Account 10-151-556 FIXED INCOME
Invest # Type Face Amt Mat Date Market Value MV Date Book Value Rate YTM DTM
2015000132 FHLMC $25,000,000 06/22/2018 $25,152,500.00 8/31/2016 $25,077,250,00 1.2500% 1.1433% 234
2015000175 FHLMC $20,000,000 06/29/2018 $20,000,000.00 8/31/2016 $20,000,000.00 1.0500% 1.0500% 241
2015000205 FHLMC $25,000,000 07/27/2018 $24,960,000.00 8/31/2016 $25,000,000.00 1.0000% 1.0000% 269
2015000206 FHLMC $25,000,000 10/29/2018 $25,012,500.00 8/31/2016 $25,000,000.00 1.1000% 1.1000% 363
2015000207 FHLMC $15,000,000 10/29/2018 $15,007,500.00 8/31/2016 $15,000,000.00 1.1000% 1.1000% 363
2015000208 FFCB $25,000,000 07/30/2018 $24,980,000.00 8/31/2016 $24,990,500.00 0.8750% 0.8890% 272
2015000212 FHLMC $30,000,000 08/03/2018 $30,009,000.00 8/31/2016 $30,000,000.00 1.0000% 1.0000% 276
2015000213 FNMA $35,000,000 05/03/2019 $35,014,000.00 8/31/2016 $35,000,000.00 1.2600% 1.2600% 549
2015000214 FFCB $30,000,000 08/02/2018 $30,000,000.00 8/31/2016 $30,000,000.00 1.0200% 1.0200% 275
2015000222 FNMA $25,000,000 10/29/2018 $25,000,000.00 8/31/2016 $25,000,000.00 1.1250% 1.1250% 363
2015000223 FHLMC $15,000,000 04/26/2018 $14,997,000.00 8/31/2016 $15,000,000,00 0.9500% 0.9500% 177
2015000226 FNMA $15,000,000 11/16/2018 $14,988,000.00 8/31/2016 $14,985,000.00 1.1600% 1.1940% 381
2015000238 FHLB $20,000,000 12/28/2018 $20,040,000.00 8/31/2016 $20,000,000.00 1.3300% 1.3300% 423
2016000038 FHLB $15,000,000 12/28/2018 $15,033,000.00 8/31/2016 $15,000,000.00 1.2500% 1.2500% 423
2016000055 FHLMC $22,425,000 07/27/2018 $22,425,000.00 8/31/2016 $22,425,000.00 1.0000% 1.0000% 269
2016000082 FNMA $20,000,000 06/13/2019 $20,022,000.00 8/31/2016 $20,000,000.00 1.4000% 1.4000% 590
2016000083 FHLB $20,000,000 05/23/2018 $20,010,000.00 8/31/2016 $19,993,000.00 1.0000% 1.0177% 204
2016000085 FHLB $17,000,000 06/29/2018 $17,001,700.00 8/31/2016 $16,959,030.00 0.8750% 0.9911% 241
2016000086 FHLMC $25,000,000 05/24/2019 $24,895,000.00 8/31/2016 $24,970,000,00 1.3000% 1.3413% 570
2016000098 FHLMC $25,000,000 12/28/2017 $24,990,000.00 8/31/2016 $25,000,000.00 0.8000% 0.8000% 58
2016000102 FNMA $20,000,000 06/28/2019 $20,000,000.00 8/31/2016 $19,984,800.00 1.2000% 1.2259% 605
2016000103 FHLMC $30,000,000 06/27/2018 $29,988,000.00 8/31/2016 $30,000,000.00 0.9100% 0.9100% 239
2016000104 FNMA $30,000,000 07/05/2019 $29,877,000.00 8/31/2016 $30,000,000.00 1.1400% 1.1400% 612
file:///C :/LTsers/Thompsonm007/AppData/L ocal/Temp/tmpFCEE.html 11/6/2017

Investments Portfolio Page 2 of 5
2016000110 FFCB $25,000,000 07/05/2019 $24,945,000.00 8/31/2016 $25,000,000.00 1.0200% 1.0200% 612
2016000111 FNMA $25,000,000 07/12/2019 $24,910,000.00 8/31/2016 $25,000,000.00 1.0500% 1.0500% 619
2016000114 FFCB $25,000,000 01/13/2020 $24,882,500.00 8/31/2016 $25,000,000.00 1.2400% 1.2400% 804
2016000115 FNMA $25,000,000 07/26/2019 $24,820,000.00 8/31/2016 $25,000,000.00 1.0000% 1.0000% 633
2016000119 FFCB $22,090,000 01/07/2019 $22,021,521.00 8/31/2016 $22,073,432.50 1.0000% 1.0303% 433
2016000121 FHLB $20,000,000 10/11/2019 $19,902,000.00 8/31/2016 $19,978,000.00 1.1250% 1.1596% 710
2016000130 FFCB $20,000,000 03/22/2018 $19,974,000.00 8/31/2016 $20,003,400.00 0.8000% 0.7898% 142
2016000131 FFCB $25,000,000 03/22/2018 $24,967,500.00 8/31/2016 $25,000,000.00 0.8000% 0.8000% 142
2016000134 FHLB $20,000,000 05/18/2018 $19,968,000.00 8/31/2016 $20,000,000.00 6.9000% 0.9000% 199
2016000135 FNMA $20,000,000 07/26/2019 $19,930,000.00 8/31/2016 $20,000,000.00 1.1250% 1.1250% 633
2016000136 FFCB $26,000,000 00/27/2019 $25,950,600.00 8/31/2016 $25,997,400.00 0.9500% 0.9535% 604
2016000148 FNMA $20,000,000 01/28/2020 $19,930,000.00 8/31/2016 $20,000,000,00 1.3300% 1.3300% 819
2016000149 FHLB $14,435,000 04/26/2019 $14,400,356.00 8/31/2016 $14,435,000.00 1.1000% 1.1000% 542
2016000150 FHLB $5,565,000 04/26/2019 $5,551,644.00 8/31/2016 $5,565,000.00 1.1000% 1.1000% 542
2016000157 FNMA $30,000,000 08/16/2019 $29,934,000.00 8/31/2016 $30,000,000.00 1.2000°k 1.2000% 654
2016000158 FNMA $20,000,000 08/23/2019 $19,978,000.00 8/31/2016 $20,000,000.00 1.2500°k 1.2500% 661
2016000164 FHLMC $20,000,000 09/21/2018 $20,000,000.00 9/8/2016 $20,000,000,00 1.0000% 1.0000% 325
2016000166 FNMA $20,000,000 09/15/2020 $20,000,000.00 9/9/2016 $20,000,000.00 1.4500% 1.4500% 1050
2016000173 FNMA $25,000,000 10/17/2019 $275,000.00 10/6/2016 $24,946,250.00 1.1000% 1.1732% 716
2016000176 FNMA $30,000,000 10/17/2019 $30,000,000.00 10/6/2016 $30,000,000.00 1.2300% 1.2300% 716
2016000180 FNMA $25,000,000 07/27/2020 $25,000,000.00 10/7/2016 $25,000,000.00 1,4000% 1.4000% 1000
2016000191 FNMA $30,000,000 10/27/2020 $30,000,000.00 10/11/2016 $30,000,000.00 1.4050% 1.4050% 1092
2016000194 FFCB $13,073,000 01/28/2019 $13,073,000.00 10/12/2016 $13,073,000.00 1.2700% 1.2700% 454
2016000195 FHLMC $30,000,000 11/02/2020 $30,000,000.00 10/12/2016 $30,000,000.00 1.3650% 1.3650% 1098
2016000196 FHLMC $25,000,000 10/26/2018 $25,000,000.00 10/12/2016 $25,000,000.00 1.0500% 1.0500% 360
2016000198 FHLMC $30,000,000 11/02/2018 $30,000,000.00 10/18/2016 $30,000,000.00 0.9300% 0.9300% 367
2016000200 FNMA $17,965,000 10/28/2019 $17,960,508.75 10/19/2016 $17,960,508.75 1.2500% 1.2585% 727
2016000201 FNMA $18,910,000 09/30/2019 $18,905,272.50 10/19/2016 $18,905,272.50 1.2500% 1.2587% 699
2016000206 FNMA $25,000,000 07/28/2020 $25,000,000.00 10/24/2016 $25,000,000.00 1.3000% 1.3000% 1001
2016000209 FNMA $20,000,000 07/28/2020 $20,000,000.00 10/25/2016 $20,000,000.00 1.3500% 1.3500% 1001
2016000212 FHLMC $20,000,000 11/27/2019 $20,000,000.00 10/27/2016 $20,000,000.00 1.3000% 1.3000% 757
2016000215 FHLMC $20,000,000 11/10/2020 $20,000,000.00 10/27/2016 $20,000,000.00 1.4000°k 1.4000% 1106
2016000233 FHLMC $20,000,000 11/27/2019 $20,000,000.00 11/9/2016 $20,000,000.00 1.3000% 1.3000% 757
2016000237 FFCB $25,000,000 12/05/2018 $25,000,000.00 11/18/2016 $24,975,355.25 1.1000% 1.1497% 400
2016000238 FNMA $25,000,000 11/26/2019 $25,000,000.00 11/22/2016 $25,000,000.00 1.5000% 1.5000% 756
2016000239 FNMA $15,000,000 05/26/2020 $15,000,000.00 11/23/2016 $15,000,000.00 1.6250% 1.6250% 938
2016000241 FHLMC $25,000,000 12/13/2019 $25,000,000.00 11/15/2016 $25,000,000.00 1.5100% 1.5100% 773
2016000243 FNMA $20,000,000 06/29/2020 $20,000,000.00 12/14/2016 $20,000,000.00 1.7500% 1.7500% 972
2016000245 FNMA $25,000,000 01/17/2020 $25,000,000.00 12/22/2016 $25,000,000,00 1.7500% 1.7500% 808
2017000004 FNMA $30,000,000 01/27/2020 $30,000,000.00 1/6/2017 $30,000,000.00 1.7000% 1.7000% 818
2017000007 FHLB $10,000,000 07/30/2020 $10,000,000.00 1/12/2017 $10,000,000.00 1.7500% 1.7500% 1003
2017000017 FHLMC $15,000,000 05/25/2018 $14,998,500.00 2/9/2017 $14,998,500.00 1.0000% 1.0078% . 206
2017000047 FHLMC $10,000,000 03/27/2020 $170,000.00 3/27/2017 $10,000,000.00 1.7000% 1.7000% 878
2017000048 FHLMC $25,000,000 07/11/2019 $25,000,000.00 3/28/2017 $25,000,000.00 1.5000% 1.5000% 618
2017000059 FHLMC $20,000,000 01/26/2021 $20,000,000.00 4/18/2017 $20,000,000.00 1.7500% 1.7500% 1183
2017000060 FFCB $25;000,000 05/21/2018 $24,999,750.00 4/18/2017 $24,994,500,00 1.1000% 1.1203% 202
2017000061 FHLMC $20,000,000 05/15/2020 $20,000,000.00 4/18/2017 $20,000,000.00 1.7000% 1.7000% 927
file:///ClUsers/Thompsonm007/AppData/Local/Temp/tmpFCEE.html 11/6/2017

Investments Portfolio Page 3 of 5
FHLMC $25,000,000 08/16/2019 $25,000,000.00 4/24/2017 $25,000,000.00 1.5000°k 1.5000% 654
2017000070 FHLB $25,000,000 07/26/2019 $24,963,250.00 4/26/2017 $24,963,250.00 1.3750°k 1.4417% 633
2017000074 FHLMC $25,000,000 05/11/2018 $24,946,000.00 4/27/2017 $24,946,000.00 1.0000% 1.2078% 192
2017000079 FH LB $30,000,000 02/03/2020 $30,000,000.00 4/28/2017 $30,000,000.00 1.6000% 1.6000% 825
2017000091 FHLMC $30,000,000 08/17/2020 $30,000,000.00 5/3/2017 $30,000,000.00 1.7000% 1.7000% 1021
2017000095 FHLMC $25,000,000 05/18/2020 $25,000,000.00 5/5/2017 $25,000,000.00 1.7000% 1.7000% 930
2017000096 FFCB $12,250,000 05/17/2021 $12,250,000.00 5/5/2017 $12,250,000.00 1.9700% 1,9700% 1294
2017000113 FHLMC $20,000,000 12/27/2019 $20,000,000.00 6/28/2017 $20,000,000.00 1.5500% 1.5500% 787
2017000114 FHLB $25,000,000 06/29/2020 $25,000,000.00 6/28/2017 $25,000,000.00 1.6900% 1.6900% 972
2017000122 FHLMC $30,000,000 08/07/2020 $30,000,000.00 7/6/2017 $30,000,000.00 1.8500% 1.8500°/o 1011
2017000123 FHLMC $30,000,000 07/19/2019 - $30,000,000.00 7/6/2017 $30,000,000.00 1.5000% 1.5000% 626
2017000149 FHLMC $25,000,000 04/13/2020 $25,023,750.00 8/7/2017 $25,023,750.00 1.8000% 1.7634% 895
2017000150 FHLB $15,000,000 06/26/2020 $14,981,100.00 8/8/2017 $15,010,214.58 1.6250°k 1.6702% 969
2017000158 FHLMC $20,000,000 09/29/2020 $19,980,000.00 10/2/2017 $19,983,888.89 1.7500% 1.7848% 1064
2017000173 FNMA $20,000,000 09/28/2020 $19,980,000.00 10/17/2017 $19,999,444,44 1.7500% 1.7852% 1063
2017000176 FHLB $15,000,000 04/17/2019 $14,977,500.00 10/2/2017 $14,978,750.00 1,5000% 1.6015% 533
2017000100 FHDN $13,600,000 11/15/2017 $13,528,838.00 5/16/2017 $13,528,838.00 1.0350% 1.0549% 15
2017000116 FHDN $45,000,000 06/27/2018 $44,460,037.50 7/3/2017 $44,460,037.50 1.2100% 1.2417% 239
2017000117 FMCDN $45,000,000 05/29/2018 $44,516,200,00 7/5/2017 $44,516,200.00 1.1800% 1.2094% 210
2017000120 FHDN $15,000,000 12/29/2017 $14,917,133.33 7/6/2017 $14,917,133.33 1.1300% 1.1521% 59
2017000128 FCDN $40,000,000 06/27/2018 $39,507,200.00 7/10/2017 $39,507,200.00 1.2600% 1.2934% 239
2017000129 FMCDN $40,000,000 05/31/2018 $39,573,400.00 7/10/2017 $39,573,400.00 1.1850% 1.2144% 212
2017000130 FHDN $35,000,000 17/29/2017 $34,818,787.50 7/10/2017 $34,818,787.50 1,0900% 1.1109% 59
2017000133 FHDN $30,000,000 12/26/2017 $29,850,600.00 7/12/2017 $29,850,600.00 1.0800% 1,1005% 56
2017000135 FCDN $25,000,000 12/27/2017 $24,878,541.67 7/21/2017 $24,878,541.67 1.1000% 1.1207% 57
2017000155 FHDN $20,000,000 12/29/2017 $19,946,588.89 9/27/2017 $19,946,588.89 1.0450% 1.0624% 59
2017000156 FHDN $25,000,000 12/29/2017 $24,933,236.11 9/27/2017 $24,933,236.11 1.0450% 1.0624% 59
2017000162 FNDN $15,000,000 11/20/2017 $14,980,612.50 10/3/2017 $14,980,612.50 0.9900% 1.0050% 20
2017000163 FHON $25,000,000 10/04/2018 $24,666,333.33 10/4/2017 $24,666,333.33 1.3200% 1.3564% 338
2017000175 FHDN $15,000,000 11/13/2017 $14,988,693.75 10/16/2017 $14,988,693.75 1.0050% 1.0197% 13
2017000183 FHDN $20,000,000 01/10/2018 $19,953,372,22 10/24/2017 $19,953,372.22 1.0900% 1.1077% 71
2017000184 FHDN $20,000,000 12/28/2017 $19,961,955.56 10/24/2017 $19,961,955.56 1.0700% 1,0869% 58
2017000185 RION $25,000,000 01/05/2018 $24,946,000.00 10/24/2017 $24,946,000.00 1,0800% 1.0974% 66
2017000186 FHDN $15,000,000 11/28/2017 $14,985,620.83 10/24/2017 $14,985,620.83 1.0150% 1.0301% 28
2017000187 FHDN $15,000,000 11/20/2017 $14,991,162.50 10/27/2017 $14,991,162.50 1.0100% 1.0246% 20
2017000188 FHDN $15,000,000 11/24/2017 $14,989,479.17 10/27/2017 $14,989,479.17 1.0100% 1.0247% 24
2017000189 FMCDN $12,000,000 02/14/2018 $11,959,875.00 10/27/2017 $11,959,875.00 1.1250% 1.1445% 106
2017000190 FHDN $15,000,000 12/05/2017 $14,984,775.00 10/27/2017 $14,984,775.00 1.0150% 1.0301% 35
2017000191 FNDN $15,000,000 12/13/2017 $14,981,850.00 10/27/2017 $14,981,850.00 0.9900% 1.0050% 43
2017000192 FMCDN $25,000,000 01/26/2018 $24,932,472.22 10/30/2017 $24,932,472.22 1.1050% 1.1234% 87
2017000193 FHDN $20,000,000 01/26/2018 $19,945,244.44 10/30/2017 $19,945,244.44 1.1200% 1.1387% 87
2017000195 FNDN $30,000,000 12/15/2017 $29,962,875.00 10/30/2017 $29,962,875.00 0.9900% 1.0050% 45
2017000196 FMCDN $20,000,000 03/30/2018 $19,902,500,00 10/30/2017 $19,902,500.00 1.1700% 1.1921% 150
2017000197 FHDN $20,000,000 01/23/2018 $19,948,200.00 10/30/2017 $19,948,200.00 1.1100% 1.1283% 84
2017000198 FMCDN $25,000,000 03/15/2018 $24,890,781.25 10/30/2017 $24,890,781.25 1.1650% 1.1864% 135
2017000199 FHDN $30,000,000 01/29/2018 $29,916,000.00 10/30/2017 $29,916,000.00 1.1200% 1.1387% 90
2017000200 FHDN $25,000,000 01/23/2018 $24,935,250.00 10/30/2017 $24,935,250.00 1.1100% 1.1283% 84
file:///C:/Users/Thompsonm007/AppData/Local/Temp/tmpFCEE.html 11/6/2017

Investments Portfolio Page 4 of 5
TNote $30,000,000 12/31/2017 $30,003,000.00 8/31/2016 $29,852,343.75 0.7500% 0.9872°k 61
2015000241 TNote $20,000,000 12/31/2017 $20,066,000.00 8/31/2016 $19,972,656.25 1.0000% 1.0684°k 61
2016000160 TNote $25,000,000 12/15/2018 $25,225,000.00 8/31/2016 $25,250,976.56 1.2500% 0.8043°k 410
2016000230 TNote $30,000,000 06/30/2018 $29,927,343.75 11/7/2016 $29,927,343.75 0.6250% 0.7738°4 242
2017000006 TNote $25,000,000 06/30/2019 $25,169,921.88 1/10/2017 $25,169,921.88 1.6250% 1.3421°4 607
2017000089 TNote $30,000,000 06/30/2020 $30,105,468.75 5/3/2017 $30,105,468.75 1.6250% 1.4995°4 973
2017000994 TNote $25,000,000 05/15/2019 $24,777,343.75 5/5/2017 $24,777,343.75 0.8750% 1.322416 561
124 Acct 10-151- $2,845,313,000.00 $2,805,978,646.15 $2,841,255,167.37 1.233528% 479
556 Totals:
Account 10-151-567 COUNTY SCHOOL BONDS
Invest # Type Face Amt Mat Date Market Value M V Date Book Value Rate YT M DIM
2013000162 SDPB $75,000 01/01/2018 $89,799.75 5/15/2013 $89,799.75 5.2300% 0.861516 62
2013000167 SDPB $4,190,000 01/01/2018 $5,100,696.50 5/15/2013 $5,100,696.50 5.6500% 0.8424°4 62
2013000175 SDPB $4,530,000 01/01/2018 $4,820,690.10 5/17/2013 $4,820,690.10 2.3000% 0.876816 62
2013000187 SDPB $8,600,000 01/01/2018 $9,656,252.00 5/23/2013 $9,656,252,00 3.6500% 0.9123°4 62
2013000206 SDPB $370,000 01/01/2018 $411,636.10 6/5/2013 $411,636.10 3.6200% 1.0747% 62
2013000241 SDPB $235,000 07/01/2018 $237,876.40 7/24/2013 $237,876.40 1.9800% 1.7146°k 243
2013000289 SDPB $16,775,000 07/01/2018 $16,862,062.25 10/1/2013 $16,862,062.25 1.9750% 1.8576% 243
2014000091 SDPB $3,000,000 07/01/2018 $3,000,000.00 5/1/2014 $3,000,000.00 1.6300% 1.6300°k 243
2014000131 SDPB $135,000 07/01/2018 $138,221,10 7/3/2014 $138,221.10 2.2900% 1.6616% 243
2014000132 SDPB $370,000 07/01/2019 $375,072.70 7/3/2014 $375,072.70 2.2900°k 1.9921% 608
2015000073 SDPB $1,500,000 07/01/2018 $1,500,000.00 5/12/2015 $1,500,000.00 1.2700% 1.2700°k 243
2015000074 SDPB $3,000,000 07/01/2019 $3,000,000.00 5/12/2015 $3,000,000.00 1.5700% 1.5700°k 608
2016000168 SDPB $2,025,000 07/01/2020 $2,190,888.00 9/1/2016 $2,190,888.00 3.5700% 1.3245°4 974
2016000169 SDPB $4,130,000 07/01/2021 $4,532,881.50 9/1/2016 $4,532,881.50 3.5700% 1.4191°4 1339
2016000181 SDPB $1,040,000 07/01/2018 $1,040,000.00 10/6/2016 $1,040,000.00 1.0300% 1.0300°4 243
2016000182 SDPB $1,030,000 07/01/2019 $1,030,000.00 10/6/2016 $1,030,000.00 1.1300% 1.130016 608
2016000183 SDPB $1,650,000 07/01/2020 $1,650,000.00 10/6/2016 $1,650,000.00 1.3000% 1.3000% 974
2016000184 SDPB $1,355,000 07/01/2021 $1,355,000.00 10/6/2016 $1,355,000.00 1.4200% 1.4200°4 1339
2016000185 SDPB $210,000 07/01/2018 $217,028.70 10/6/2016 $217,028.70 3.0000% 1.0434°4 243
2016000186 SDPB $215,000 07/01/2019 $225,734.95 10/6/2016 $225,734.95 3.0000% 1.1315°4 608
2016000187 SDPB $1,045,000 07/01/2020 $1,166,011.00 10/6/2016 $1,166,011.00 4.5000% 1.281816 974
2016000188 SDPB $1,095,000 07/01/2021 $1,095,000.00 10/6/2016 $1,095,000.00 1.4200% 1.4200°4 1339
22 Acct 10-151- $56,575,000.00 $59,694,851.05 $59,694,851.05 1.379488% 404
567 Totals:
Account 32-001-534 MIHS MAIN DEPOSITORY
Invest # Type Face Amt Mat Date Market Value MV Date Book Value Rate YTM DTM
2017000147 FHDN $50,300,000 02/02/2018 $50,009,517.50 7/27/2017 $50,009,517.50 1.1000% 1.1218% 94
1 Acct 32-001-534 $50,300,000.00 $50,009, 517.50 $50,009,517.50 1.121756 0/a 94
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% 366
2017000104 FFCB $13,300,000 11/26/2018 $13,292,818.00 5/18/2017 $13,292,818.00 1.2200% 1.2561% 391
2017000099 FHDN $6,400,000 11/15/2017 $6,366,512.00 5/16/2017 $6,366,512.00 1.0350% 1.0549% 15
3 Acct 32-535-534
file:///ClUsers/Thompsontn007/AppData/Local/Temp/tmpFCEE.html 11/6/2017

Investments Portfolio Page 5 of 5
Totals: $32,100,000.00 $32,050,774.00 $32,057,662.89 1.231972% 306
Account 32-700-534 IVIIHS DEBT INTEREST & REDEMPTION FUND
Invest if 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% 227
1 Acct 32-700-534 $3,200,000.00 $3,198,875.00 $3,198,875.00 1.152830% 227
Totals:
Report Totals: $3,202,488,000.00 $3,166,302,513.70 $3,201,585,923.81 1.255951% 455
file:///ClUsers/Thompsonm007/AppData/Local/Temp/tmpFCEE.html 11/6/2017

PROGRAM
040 030 040 040 030 040 030 040 040 035 030 040 030 040 030 040 030 040 030 040 030 950 945 781 768 766 714 066 FUND
ID:
WTR
014 014 011 011 009 009 009 008 008 008 007 007 006 006 006 006 005 005 005 004 004 004 003 003 003 002 002 002 001 001 001 000 000 000 000 000 000 000 000 DISTRICT
District District District District District District District District District District District WARRANT OTSTND_WT_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 Fund
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
= = = = = = = = - = - = = - = = = = = = = = = - = . = = = = -- = - = = = = - = NUMBER
MARICOPA
OUTSTANDING
WARRANT
171,561.41 44,442.09 1,334,116.79 1,334,116.79 145,743.45 138,896.18 6,847.27 314,074.81 303,915.00 10,159.81 192,993.68 192,993.68 456,237.66 391,059.90 18,508.70 46,669.06 429,013.77 383,998.97 45,014.80 1,516,455.37 1,287,300.15 229,155.22 3,584,641.93 3,509,579.28 75,062.65 956,391.36 943,118.39 13,272.97 438,924.48 415,280.67 23,643.81 4,977,996.10 115,629.23 10,117.55 109,646.51 4,370,053.24 28,783.90 336,452.88 7,312.79 WARRANTS COUNTY
AMOUNT
-
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 DISTRICT
by TREASURER'S
FUND
68 61 635 635 71 61 10 86 68 18 54 54 279 165 4 110 145 94 51 1,038 622 416 324 181 143 32 23 9 193 124 69 13,897 47 9 297 1,354 28 11,616 546 -
L.4
OFFICE
.2- 4cqf 31-OCT-2017
Y
0
5
7
PAGE:
31-OCT-2017
582

Program
31-120-000 Total - 1 30-100-000 Total - 1 30-099-000 30-094-000 30-093-000 30-092-000 30-091-000 30-090-000 30-086-000 30-077-000 30-066-000 30-064-000 30-053-000 30-052-000 30-061-000 30-060-005 33-059-005 30-050-000 30-049-000 30-048-000 30-045-000 30-044-000 30-043-090 30-042-000 30-041-000 30-036-000 30-035-009 30-934-009 30-083-000 30-023-000 30-027-000 30-026-000 Total - 1 30-025-199 30-025-191 30-025-190 30-025-189 30-025-188 30-025-187 30-025-186 30-025-185 30-025-184 Number Account ID: ACC
SHERIFF COUNTY GENERAL TREAS SUSPENSE BANK SUSPENSE SUSPENSE TEMP HID UNIDENTIFIED EXCESS RECORDER CURRENT PROBLEM TRUST TAYLOR UNDISTRIBUTED UNDISTRIBUTED REDEMPTION ELDERLY ELDERLY GPLET GOLF CIVIL UPPS TAXPAYER IRS INTEREST SURTAX LITIGATION RESOLUTION CASHIER'S BACK TAX REFUND DES CLEARING DEP ACCT DEP ACCOUNT CE? ACCT CE? ACCT DEP ACCOUNT CE? ACCOUNT CE? ACCT CE? ACCT CE? ACCT FUND_BAL_MTD
WAREHOUSE GENERAL FUNDS SUSPENSE-PREPAYMENTS SERVICE CHARGE MORTGAGE CASHIER'S FD MONEY WIRES PROCEEDS FEE PAX HOLDING CHECK FUND FOR GRAZING TAX HOLDING ASSISTANCE ASSISTANCE HOLDING COURSE PENALTY RESOLUTION INFORMATION AND ASSIGN PENDING HOLDING HOLDING CLEARING REVENUE COUNTRY HIGHLAND DESERT WEST NORTH PENDERGAST ENVIR JUVENILE Description
FUNDS COMPANIES TO BE FROM REFUNDING HOLDING NON-DELIVERABLE ACT INTEREST HOLD - CONVERSION HOLDING IMPOUNDS WITHHOLDING HOLD/HG DEBITS/CREDITS PROCESSING CC RIDGE CC TEMPE VALLEY SCHOOL SERVICES CT
APPR OR TRUSTEE INCOME COLLECTIONS INVESTMENT FUND HE RESOLUTIONS MEADOWS JO CC CC
UNKNOWN SALES REFUNDS 2149 SERVICE
196,578.80- 131,808,454.19 131,808,494.19 36,263,708.67 2,397,484.72 1,389,446.88 749,650.84 455,970.85 22,306,431.40 5,958.83 99,222.10 235,551.01 247,138.42 86,762,63- 130,147.66 5,581,752.68 1.00 1,550,240.39 309,599.86 398.55 22,155.04 11,296.56 3,747.35 37,469.91- 891,767.07 14,424,309,65 2,510,951.63 131,620.79 73,261.70 123,393.78 170,801.96 111,378.11 91,214.57 Balance Opening Treasurer's MARICOPA
Report COUNTY
46,057,554.17 46,057,554.17 1,127,212,885.95 595.34- 1,165,326.97 493,593169.75- 2,484,484.70 1,402.00 3,263,627.39 2,172,586.06 1,698,515,343.36 2,293,913.02 148,00 3,166.95 6,812.86- 3,735.17 30,193.90- 350,166.41 559,557.79 985,793.62- 2,531,181.61 27,538.99 7,770.27 14,801.35 8,184.45 11,361.55 342,611.71 Distribution Income for the Month
of TREASURER'
OCT,
126,220.98 98,308,245.03 98,308,245.03 1,613,776,127.22 45.45 9,725.81 1,611,138,359.16 117.01 2,614,134.46 13,745.13 From -- 2017 S OFFICE
Transfer
3114,781.95 198,596,640.38 198,596,640.38 2,641,495.53 18,023.26 2,621,568.25 1,904.00 15,145.90 510.67 263.92 585.69 482.61 568.81 To
4,337.78- 4,387.78- 6,179,294.21 17,977.83 107,331.41 3,308,410.47 3,582,00 2,195,781.29 398.55 545,812.66 Disbursements
16,017.63- 278,158,831.49 278,158,831.49 452,837,331.28- 2,396,889.38 2,584,773.85 642,319.43 493,137,198.90- 21,472,779.82 3,778.63 3,363,049.49 235,551.01 247,138.42 2,172,586.36 88,230.38- 228,162.36 2,967,618.22 1.00 1,550,240.39 311,651.86 3,166.95 15,342.18 11,296.56 7482.52 67,663,61- 1,241,933.48 13,453,661.93 5,042,113.24 159,670.65 81,295.89 138,780.82 179,469.02 123,308.57 413,826.28 2alance Closing PAGE:
02-NOV-2017
2

PROGRAM
TOTAL 1968 1969 1970 1971 1972 1973 1974 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1906 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 YEAR ID: APP
95,659,212,677.90 116,414,184.58 126,692,073.74 138,694,628.82 165,623,012.50 191,805,552.44 224,505,828.94 251,690,646.52 294,189,512.68 332,481,242.68 360,443,065.88 365,594,731.04 382,783,606.36 373,230,675.34 402,942,488.72 451,214,378.40 530,525,148.42 600,944,379.84 721,770,831.08 870,295,854.72 1,049,880,299.56 1,181,440,841.12 1,306,266,536.54 1,445,084,095.32 1,485,482,338.84 1,477,426,592.42 1,476,046,063.04 1,507,769,663.58 1,683,783,514.12 1,631,715,958.46 1,800,100,859.36 1,939,463,904.72 2,108,718,697.02 2,290,234,573.96 2,595,278,869.32 2,792,576,236.72 3,049,037,955.00 3,246,259,075.84 3,489,841,477.20 3,660,387,436.00 4,001,594,678.74 4,288,606,572.70 4,593,263,862.98 4,411,089,394.04 4,138,461,193.04 4,045,298,460.92 4,019,480,209.28 4,243,506,812.16 4,364,407,727.86 4,643,191,878.76 4,791,587,056.58 LEVY_RPT_MONTH_SUM
LEVY
BEGINNING MARICOPA
4,569,819,879.45 331.83 922.38 1,998.26 4,111.30 5,885.92 6,216.48 8,954.20 10,864.89 12,599.20 12,427.08 17,517.20 15,972.66 11,278.23 13,532.33 11,576.64 28,887.27 21,166.00 86,095.02 17,523.14 22,363.14 3,284,760.26- 8,122,159.39 7,952,626.39 2,207,553.16 3,577,213.60 1,190,791.47 1,128,169.02- 758,266.74- 78,784.46- 651,506.18- 762,845.98- 679,575.16- 572,605.45- 641,280.31 1,279,965.51- 733,659.05- 631,066.16 577,196.39 705,551.71- 563,773.53- 26,193,803.23 87,191,419.53 42,843,440.07- 20,885,710.11 1,061,586.41- 1,260,896.37 1,762,694.62 3,514,737.10 35,514,363.85 4,423,390,654.03 BALANCE
SECURED
LEVY COUNTY
1,610,592,247.60 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00• .00 .00 .00 .00 .00 8.16- 8.24- 8.14- 8.92- 0.66- 9.00- 2.46- 2.42- 2.42- 161.37 8.66- 9.38- 36.88 791.64- 7,093.91- 1,677.50- 4,465.68- 3,882.26- 6,711.82- 5,663.94 6,258.13 8,440.81 23,533.26 218,760.63 4,320,517.39 1,606,033,574.46 COLLECTIONS AND ACTIVITY TREASURER
FOR
OCT 2017 S
9,237,640.06- .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 2.06- 5.27- 136.14- 138.03- 971.68- 7,974.81- 2,249.55- 2,630.26- 3,671.01- 6,488.30- 2,691.19- 1,564.86- 1,591.25- 25,034.01- 28,277.60- 163,464.65- 8,990,749.39- ADJUSTMENTS OFFICE
ENDING
2,949,989,991.79 331.83 922.38 1,998.26 4,111.30 5,885.92 6,216.48 8,954.20 10,864.89 12,599.20 12,427.08 17,517.30 15,972.66 11,278.23 13,532.33 11,576.64 28,887.27 21,166.00 86,095.02 17,523.14 22,353.14 3,284,780.26- 8,122,159.39 7,952,626.39 2,207,553.16 3,577,221.76 1,190,799.71 1,128,160.88- 758,257.82- 78,775.80- 651,497.18- 762,043.52- 679,572.74- 572,603.03- 641,116.88 1,279,962.12- 733,785.81- 630,891.25 577,016.35 706,432.61- 564,345.58- 26,195,638.65 87,191,630.78 42,843,215.55- 20,877,354.98 1,069,409.40- 1,250,864.31 1,714,127.35 3,267,698.87 31,030,381.81 2,808,366,330.18 BALANCE
PAGE: 02-NOV-2017
1

PROGRAM
TOTAL 1968 1969 1970 1971 1972 1973 1974 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 YEAR ID: APP
,
2,325,116,156.87 4,195,165.19 5,918,654.86 10,386,975.66 12,084,654.91 13,623,766.21 13,177,965.26 13,296,922.12 19,169,042.79 23,204,794.95 26,779,663.13 26,615,308.42 29,722,220.00 30,075,323.04 36,683,300_76 37,836,109.79 73,434,045.21 53,570,953.57 50,507,999.56 76,956,283.43 88,991,362.81 96,811,185.54 113,929,972.43 122,744,902.09 131,562,120.56 140,629,687.78 154,917,045.68 162,209,939.25 113,747,601.86 102,673,692.06 115,134,253.32 122,881,710.56 122,871,629.32 138,497,672.37 19,330,396.80 16,903,615.38 LEVY_RPT_MONTH_SUM
.00 .00 LEVY
BEGINNING
MARICOPA
405,479,489.59- 2,320,992.14- 1,422,511.95- 433,497.42- 1,719,922.67- 2,953,558.51- 5,836,677.39- 5,472,248.17- 2,664,351.52- 2,691,654.20- 5,929,694.62- 6,812,702_12- 6,557,551_22- 17,272,723.82- 18,055,558.20- 22,905,046.43- 6,576,315.56- 12,928,887.66- 28,111,564.10- 25,772,613.27- 7,162,377.74- 21,536,144.42- 7,916,568.30- 950,427.40- 6,349,435_71- 17,542,008.94- 14,418,422.22- 8,107,024.00 28,750,866.17- 35,071,600.42- 22,886,220.37- 25,511,216.65- 28,449,736.93- 9,260,219.88- 673,719.66- 3,063,385.19 13,314,7100.48- 197,750.52- BALANCE
UNSECURED
LEVY COUNTY
AND
COLLECTIONS ACTIVITY
190.38 .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 .D0 35.80 27.18 18.37 32.81 35.74 40.48 .00 .00 TREASURER'S
FOR
OCT
2017
ADJUSTMENTS
.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 .30 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 OFFICE
ENDING
405,479,679.97- 2,320,992.14- 1,422,511.95- 433,497.42- 1,719,922.67- 2,953,558.51- 5,836,677.39- 5,472,248.17- 2,664,351.52- 2,691,654.20- 5,929,894.62- 6,812,702.12- 6,557,551.22- 17,272,723.82- 18,055,558.20- 22,905,048.43- 6,576,315.56- 12,928,687.66- 28,111,564.10- 25,772,613.27- 7,162,377.74- 21,536,144.42- 7,916,568.30- 950,427.40- 6,349,435.71- 17,542,008.94- 14,416,422.22- 8,107,024.00 28,750,866.17- 35,071,836.22- 22,886,257.55- 25,511,235.02- 26,449,769.74- 9,260,255.62- 673,760.14- 3,063,385.19 13,314,700.48- 197,750.62- BALANCE
PAGE: 02-NOV-2017
1