SEPTEMBER 2018 MONTHLY REPORT.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.marieopa.gov
DATE: October 09, 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 September 2017
Secured property tax collections during the month of September equaled $346,459,901 and
increased the 2017 year to date collections to $368,866,009 or 8% of the adjusted 2017 levy of
$4,792,256,663. The chart below reflects the 2017 collected and uncollected levy amount and
corresponding percentages for the 2017 property tax year.
SEPTEMBER
Uncollected Levy 2017
$4,423,390,654
92%
Collected Levy
$368,866,009 8%
• Collected Levy • Uncollected Levy
The County's General Fund Balance totaled $131,808,494.19 effective September 30, 2017.
Warrants outstanding of $4,633,795.25 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,
7
Royce T. Flora
Maricopa County Treasurer
STATE OF ARIZONA ) ss.
COUNTY OF MAR1COPA )
This instrument was acknowledged before me this 9th day of October 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.
1--) Lr_,h6cY,
Notary Public My Commission Expires
KAREN D. SMITH
Notary Public - Arizona
Maricopa County
My Comm. Expires Dec 15, 2017

Investments Portfolio Page 1 of 4
Maricopa County Treasurer Investments
Portfolio Report
09/30/2017 - 142 Investments
Account 10-151-156 COUNTY SCHOOL TANS
Invest # Type. Face Amt Mat Date Market Value MV Date Book Value Rate YTM DTM
2017000136 TANS $48,000,000 07/18/2018 $48,083,040.00 7/26/2017 $48,083,040.00 1.6700% 1.4905% . 291
2017000137 TANS $35,000,000 07/18/2018 $35,060,550.00 7/26/2017 $35,060,550.00 1.6700% 1.4905% 291
2017000138 TANS $23,000,000 07/18/2018 $23,039,790.00 7/26/2017 $23,039,790.00 1.6700% 1.4905% 291
2017000139 TANS $14,000,000 07/18/2018 $14,024,220.00 7/26/2017 $14,024,220.00 1.6700% 1.4905% 291
2017000140 TANS $16,000,000 07/18/2018 $16,027,680.00 7/26/2017 $16,027,680.00 1.6700% 1.4905% 291
2017000141 TANS $10,000,000 07/18/2018 $10,017,300.00 7/26/2017 $10,017,300.00 1.6700% 1.4905% 291
2017000142 TANS $41,000,000 07/18/2018 $41,070,930.00 7/26/2017 $41,070,930.00 1.6700% 1.4905% 291
2017000143 TANS $10,000,000 07/18/2018 $10,017,300.00 7/26/2017 $10,017,300.00 1,6700% 1.4905% 291
2017000144 TANS $3,000,000 07/18/2018 $3,005,190.00 7/26/2017 $3,005,190.00 1.6700% 1.4905% 291
2017000154 TANS $15,000,000 07/18/2018 $15,023,850.00 8/24/2017 $15,023,850.00 1.6700% 1,4910% 291
10 Acct 10-151- $215,000,000.00 $215,369,850.00 $215,369,850.00 1.490523°/a 291
156 Totals:
Account 10-151-556 FIXED INCOME
Invest # Type Face Amt Mat Date Market Value MV Date Book Value Rate VIM DTM
2014000206 FNMA $25,000,000 10/26/2017 $25,042,500.00 8/31/2016 $24,888,250.00 0.8750% 1.0299% 26
2015000132 FHLMC $25,000,000 06/22/2018 $25,152,500.00 8/31/2016 $25,077,250.00 1.2500% 1.1433% 265
2015000175 FHLMC $20,000,000 06/29/2018 $20,000,000.00 8/31/2016 $20,000,000.00 1.0500% 1.0500% 272
2015000205 FHLMC $25,000,000 07/27/2018 $24,960,000.00 8/31/2016 $25,000,000.00 1.0000% 1.0000% 300
2015000206 FHLMC $25,000,000 10/29/2018 $25,012,500.00 8/31/2016 $25,000,000.00 1.1000% 1.1000% 394
2015000207 FHLMC $15,000,000 10/29/2018 $15,007,500.00 8/31/2016 $15,000,000.00 1.1000% 1,1000% 394
2015000208 FFCB $25,000,000 07/30/2018 $24,980,000.00 8/31/2016 $24,990,500.00 0.8750°k 0.8890% 303
2015000212 FHLMC $30,000,000 08/03/7018 $30,009,000.00 8/31/2016 $30,000,000.00 1,0000% 1.0000% 307
2015000213 FNMA $35,000,000 05/03/2019 $35,014,000.00 8/31/2016 $35,000,000.00 1.2600% 1.2600% 580
2015000214 FFC13 $30,000,000 08/02/2018 $30,000,000.00 8/31/2016 $30,000,000.00 1.0200% 1.0200% 306
2015000222 FNMA $25,000,000 10/29/2018 $25,000,000.00 8/31/2016 $25,000,000.00 1.1250% 1.1250% 394
2015000223 FHLMC $15,000,000 04/26/2018 $14,997,000.00 8/31/2016 $15,000,000.00 0,9500% 0.9500% 208
2015000226 FNMA $15,000,000 11/16/2018 $14,988,000.00 8/31/2016 $14,985,000.00 1.1600% 1.1940% 412
7015000238 FHLB $20,000,000 12/28/2018 $20,040,000.00 8/31/2016 $20,000,000.00 1.3300% 1.3300% 454
2016000038 FHLB $15,000,000 12/28/2018 $15,033,000.00 8/31/2016 $15,000,000.00 1.2500% 1.2500% 454
2016000055 FHLMC $22,425,000 07/27/2018 $22,425,000.00 8/31/2016 $22,425,000.00 1.0000% 1.0000°k 300
2016000082 FNMA $20,000,000 06/13/2019 $20,022,000.00 8/31/2016 $20,000,000.00 1.4000% 1.4000% 621
2016000083 FHLB $20,000,000 05/23/2018' $20,010,000.00 8/31/2016 $19,993,000.00 1.0000% 1.0177% 235
2016000085 FHL8 $17,000,000 06/29/2018 $17,001,700.00 8/31/2016 $16,959,030.00 0.8750% 0.9911% 272
2016000086 FHLMC $25,000,000 05/24/2019 $24,895,000.00 8/31/2016 $24,970,000.00 1.3000% 1.3413% 601
2016000098 FHLMC $25,000,000 12/28/2017 $24,990,000.00 8/31/2016 $25,000,000.00 0.8000% 0.8000% 89
2016000102 FNMA $20,000,000 06/28/2019 $20,000,000.00 8/31/2016 $19,984,800.00 1.2000% 1.2259% 636
2016000103 FHLMC $30,000,000 06/27/2018 $29,988,000.00 8/31/2016 $30,000,000.00 0.9100% 0,9100% 270
file:///ClUsers/Thompsonm007/App Data/Local/Temp/tmp162E.htm I 10/10/2017

Investments Portfolio Page 2 of 4
2016000104 FNMA $30,000,000 07/05/2019 $29,877,000.00 8/31/2016 $30,000,000.00 1.1400% 1.1400% 643
2016000110 FFCB $25,000,000 07/05/2019 $24,945,000.00 8/31/2016 $25,000,000.00 1.0200% 1.0200% 643
2016000111 FNMA $25,000,000 07/12/2019 $24,910,000.00 8/31/2016 $25,000,000.00 1.0500°/a 1.0500% 650
2016000114 FFCB $25,000,000 01/13/2020 $24,882,500.00 8/31/2016 $25,000,000.00 1.2400% 1.2400% 835
2016000115 FNMA $25,000,000 07/26/2019 $24,820,000.00 8/31/2016 $25,000,000.00 1.0000% 1.0000% 664
2016000119 FFCB $22,090,000 01/07/2019 $22,021,521.00 8/31/2016 $22,073,432.50 1.0000% 1.0303% 464
2016000121 FHLB $20,000,000 10/11/2019 $19,902,000.00 8/31/2016 $19,978,000.00 1.1250% 1.1596% 741
2016000130 FFCB $20,000,000 03/22/20-18 $19,974,000.00 8/31/2016 $20,003,400.00 0.8000% 0.7898% • 173
2016000131 FFCB $25,000,000 03/22/2018 $24,967,500.00 8/31/2016 $25,000,000.00 0.8000% 0.8000% 173
2016000134 FHLB $20,000,000 05/18/2018 $19,968,000.00 8/31/2016 $20,000,000.00 0.9000% 0.9000% 230
201600 0135 FNMA $20,000,000 07/26/2019 $19,930,000.00 8/31/2016 $20,000,000.00 1,1250% 1.1250% 664
2016000136 FFCB $26,000,000 06/27/2019 $25,950,600.00 8/31/2016 $25,997,400.00 0.9500% 0.9535% 635
2016000148 FNMA $20,000,000 01/28/2020 $19,930,000.00 8/31/2016 $20,000,000.00 1.3300% 1.3300% 850
2016000149 FHLB $14,435,000 04/26/2019 $14,400,356.00 8/31/2016 $14,435,000.00 1.1000% 1.1000% 573
2016000150 FHLB $5,565,000 04/26/2019 $5,551,644.00 8/31/2016 $5,565,000.00 1.1000% 1.1000% 573
2016000157 FNMA $30,000,000 08/16/2019 $29,934,000.00 8/31/2016 $30,000,000.00 1.2000% 1.2000% 685
2016000158 FNMA $20,000,000 08/23/2019 $19,978,000.00 8/31/2016 $20,000,000.00 1.2500% 1.2500% 697
2016000164 FHLMC $20,000,000 09/21/2018 $20,000,000.00 9/8/2016 $20,000,000.00 1.0000% 1.0000% 356
2016000166 FNMA $20,000,000 09/15/2020 $20,000,000.00 9/9/2016 $20,000,000.00 1.4500% 1.4500% 1081
2016000173 FNMA $25,000,000 10/17/2019 $275,000.00 10/6/2016 $24,946,250.00 1.1000% 1.1732% 747
2016000176 FNMA $30,000,000 10/17/2019 $30,000,000.00 10/6/2016 $30,000,000.00 1.2300% 1.2300% 747
2016000180 FNMA $25,000,000 07/27/2020 $25,000,000.00 10/7/2016 $25,000,000.00 1.4000% 1.4000% 1031
2016000191 FNMA $30,000,000 10/27/2020 $30,000,000.00 10/11/2016 $30,000,000.00 1.4050% 1.4050% 1123
2016000194 FFCB $13,073,000 01/28/2019 $13,073,000.00 10/12/2016 $13,073,000.00 1.2700% 1.2700% 485
2016000195 FHLMC $30,000,000 11/02/2020 $30,000,000.00 10/12/2016 $30,000,000.00 1.3650% 1.3650°/o 1129
2016000196 FHLMC $25,000,000 10/26/2018 $25,000,000.00 10/12/2016 $25,000,000.00 1.0500% 1.0500% 391
2016000198 FHLMC $30,000,000 11/02/2018 $30,000,000.00 10/18/2016 $30,000,000.00 0.9300% 0.9300% 398
2016000200 FNMA $17,965,000 10/28/2019 $17,960,508.75 10/19/2016 $17,960,508.75 1.2500% 1.2585°/o 758
2016000201 FNMA $18,910,000 09/30/2019 $18,905,272.50 10/19/2016 $18,905,272.50 1.2500% 1.2587% 730
2016000206 FNMA $25,000,000 07/28/2020 $25,000,000.00 10/24/2016 $25,000,000.00 1.3000% 1.3000% 1032
2016000209 FNMA $20,000,000 07/28/2020 $20,000,000.00 10/25/2016 $20,000,000.00 1.3500% 1.3500% 1032
2016000212 FHLNIC $20,000,000 11/27/2019 $20,000,000.00 10/27/2016 $20,000,000.00 1.3000% 1.3000% 788
2016000215 FHLN1C $20,000,000 11/10/2020 $20,000,000.00 10/27/2016 $20,000,000.00 1.4000% 1.4000% 1137
2016000233 F FILM C $20,000,000 11/27/2019 $20,000,000.00 11/9/2016 $20,000,000.00 1.3000% 1.3000% 788
2016000237 FFCB $25,000,000 12/05/2018 $25,000,000.00 11/18/2016 $24,975,355.25 1.1000% 1.1497% 431
2016000238 FNMA $25,000,000 11/26/2019 $25,000,000.00 11/22/2016 $25,000,000.00 1.5000% 1.5000% 787
2016000239 FNMA $15,000,000 05/26/2020 $15,000,000.00 11/23/2016 $15,000,000.00 1.6250% 1.6250% 969
2016000241 FHLMC $25,000,000 12/13/2019 $25,000,000.00 11/15/2016 $25,000,000.00 1.5100% 1.5100% 804
2016000243 FNMA $20,000,000 06/29/2020 $20,000,000.00 12/14/2016 $20,000,000.00 1.7500°/o 1.7500°/o 1003
2016000245 FNMA $25,000,000 01/17/2020 $25,000,000.00 12/22/2016 $25,000,000.00 1.7500% 1.7500% 839
2017000004 FNMA $30,000,000 01/27/2020 $30,000,000.00 1/6/2017 $30,000,000.00 1.7000% 1 .7000% 849
2017000007 FHLB $10,000,000 07/30/2020 $10,000,000.00 1/12/2017 $10,000,000.00 1.7500% 1.7500% 1034
2017000017 FHLMC $15,000,000 05/25/2018 $14,998,500.00 2/9/2017 $14,998,500.00 1.0000% 1.0078°/o 237
2017000047 FHLMC $10,000,000 03/27/2020 $170,000.00 3/27/2017 $10,000,000.00 1.7000% 1.7000% 909
2017000048 FHLMC $25,000,000 07/11/2019 $25,000,000.00 3/28/2017 $25,000,000.00 1.5000% 1.5000% 649
2017000059 FHLMC $20,000,000 01/26/2021 $20,000,000.00 4/18/2017 $20,000,000.00 1.7500% 1.7500% 1214
2017000060 FFCB $25,000,000 05/21/2018 $24,999,750.00 4/18/2017 $24,994,500.00 1.1000% 1.1203% 233
file :NC JUsers/Thompsonm007/AppData/Local/Temp/tmp162E.html 10/10/2017

Investments Portfolio Page 3 of 4
FHLMC $20,000,000 05/15/2020 $20,000,000.00 4/18/2017 $20,000,000.00 1.7000% 1.7000% 958
2017000067 FHLMC $25,000,000 08/16/2019 $25,000,000.00 4/24/2017 $25,000,000.00 1.5000% 1.5000% 685
2017000070 FHLB $25,000,000 07/26/2019 $24,963,250,00 4/26/2017 $24,963,250.00 1.3750% 1.4417% 664
2017000074 FHLMC $2)5,000,000 05/11/2018 $24,946,000.00 4/27/2017 $24,946,000.00 1.0000% 1.2078% 223
2017000079 FHLB $30,000,000 02/03/2020 $30,000,000.00 4/28/2017 $30,000,000.00 1.6000% 1.6000% 856
2017000091 FHLMC $30,000,000 08/17/2020 $30,000,000.00 5/3/2017 $30,000,000.00 1.7000% 1.7000% 1052
2017000095 FHLMC $25,000,000 05/18/2020 $25,000,000.00 5/5/2017 $25,000,000.00 1.7000% 1.7000% 961
2017000096 FFCB $12,250,000 05/17/2021 $12,250,000.00 5/5/2017 $12,250,000.00 1.9700% 1.9700% 1325
2017000113 FHLMC $20,000,000 12/27/2019 $20,000,000.00 6/28/2017 $20,000,600.00 1.5500% 1.5500% 818
2017000114 FHLB $25,000,000 06/29/2020 $25,000,000.00 6/28/2017 $25,000,000.00 1.6900% 1.6900% 1003
2017000122 FHLMC $30,000,000 08/07/2020 $30,000,000.00 7/6/2017 $30,000,000.00 1.8500% 1.8500% 1042
2017000123 FHLMC $30,000,000 07/19/2019 $30,000,000.00 7/6/2017 $30,000,000.00 1.5000% 1.5000% 657
2017000149 FHLMC $25,000,000 04/13/2020 $25,023,750.00 8/7/2017 $25,167,500.00 1.8000% 1.7634% 926
2017000150 FMB $15,000,000 06/26/2020 $14,981,100.00 8/8/2017 $15,010,214.58 1.6250% 1.6702% 1000
2017000100 FHDN $13,600,000 11/15/2017 $13,528,838.00 5/16/2017 $13,528,838.00 1.0350% 1.0549% 46
2017000109 FMCDN $35,000,000 10/13/2017 $34,869,406.25 5/31/2017 $34,869,406.25 0.9950% 1.0126% 13
2017000116 FHDN $45,000,000 06/27/2018 $44,460,037.50 7/3/2017 $44,460,037.50 1.2100% 1.2417% 270
2017000117 FMCDN $45,000,000 05/29/2018 $44,516,200.00 7/5/2017 $44,516,200.00 1.1800% 1.2094% 241
2017000120 FHDN $15,000,000 12/29/2017 $14,917,133.33 7/6/2017 $14,917,133.33 1.1300% 1.1521% 90
2017000126 FNDN $35,000,000 10/23/2017 $34,894,854.17 7/7/2017 $34,894,854.17 1.0300% 1.0475% 23
2017000127 FHDN $30,000,000 10/06/2017 $29,920,754.17 7/7/2017 $29,920,754.17 1.0450% 1.0623% 6
2017000128 FCDN $40,000,000 06/27/2018 $39,507,200.00 7/10/2017 $39,507,200.00 1.2600°k 1.2934% 270
2017000129 FMCDN $40,000,000 05/31/2018 $39,573,400.00 7/10/2017 $39,573,400.00 1.1850°k 1.2144% 243
2017000130 FHDN $35,000,000 12/29/2017 $34,818,787.50 7/10/2017 $34,818,787.50 1.0900% 1.1109% 90
2017000133 FHDN $30,000,000 12/26/2017 $29,850,600.00 7/12/2017 $29,850,600.00 1.0800% 1.1005% 87
2017000135 FCDN $25,000,000 12/27/2017 $24,878,541.67 7/21/2017 $24,878,541.67 1.1000% 1.1207% 88
2017000155 FHDN $20,000,000 12/29/2017 $19,946,588.89 9/27/2017 $19,946,588.89 1.0450% 1.0624% 90
2017000156 FHDN $25,000,000 12/29/2017 $24,933,236.11 9/27/2017 $24,933,236.11 1.0450% 1.0624% 90
2015000235 TNote $30,000,000 12/31/2017 $30,003,000.00 8/31/2016 $29,852,343.75 0.7500% 0.9872% 92
2015000241 TNote $20,000,000 12/31/2017 $20,066,000.00 8/31/2016 $19,972,656.25 1.0000% 1.0684% 92
2016000160 TNote $25,000,000 12/15/2018 $25,225,000.00 8/31/2016 $25,250,976.56 1.2500% 0,8043% 441
2016000230 TNote $30,000,000 06/30/2018 $29,927,343.75 11/7/2016 $29,927,343.75 0.6250% 0.7738% 273
2017000006 TNote $25,000,000 06/30/2019 $25,169,921.88 1/10/2017 $25,169,921.88 1.6250% 1.3421°k 638
2017000089 TNote $30,000,000 06/30/2020 $30,105,468.75 5/3/2017 $30,105,468.75 1.6250% 1.4995% 1004
2017000094 TNote $25,000,000 05/15/2019 $24,777,343.75 5/5/2017 $24,777,343.75 0.8750% 1.3224% 592
105 Acct 10-151- 62,513,313,000.00 $2,474,945,607.97 $2,510,187,045.86 1.238520% 538
556 Totals:
Account 10-151-567 COUNTY SCHOOL BONDS
Invest # Time Face Amt Mat Date Market Value NPJ 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% 93
2013000167 SDPB $4,190,000 01/01/2018 $5,100,696.50 5/15/2013 $5,100,696.50 5.6500% 0.8424% 93
2013000175 SDPB $4,530,000 01/01/2018 $4,820,690.10 5/17/2013 $4,820,690.10 2.3000% 0.8768% 93
2013000187 SDPB $8,600,000 01/01/2018 $9,656,252.00 5/23/2013 $9,656,252.00 3.6500°k 0.9123% 93
2013000206 SDPB $370,000 01/01/2018 $411,636.10 6/5/2013 $411,636.10 3.6200% 1.0747% 93
2013000241 SDPB $235,000 07/01/2018 $237,876.40 7/24/2013 $237,876.40 1.9800% 1.7146% 274
2013000289 SDPB $16,775,000 07/01/2018 $16,862,062.25 10/1/2013 $16,862,062.25 1.9750% 1.8576% 274
2014000091 SDPB $3,000,000 07/01/2018 $3,000,000.00 5/1/2014 $3,000,000.00 1.6300% 1.6300% 274.
file:///ClUsers/Thompsonm007/AppData/Local/Temp/tmp162E.html 10/10/2017

Investments Portfolio Page 4 of 4
2014000131 SDPB $135,000 07/01/2018 $138,221.10 7/3/2014 $138,221.10 2.2900% 1.6616% 274
2014000132 SDPB $370,000 07/01/2019 $375,072.70 7/3/2014 $375,072.70 2.2900% 1.9921% 639
2015000073 SDPB $1,500,000 07/01/2018 $1,500,000.00 5/12/2015 $1,500,000.00 1.2700% 1.2700% 274
2015000074 S DP B $3,000,000 07/01/2019 $3,000,000.00 5/12/2015 $3,000,000.00 1.5700% 1.5700% 639
2016000168 SDPB $2,025,000 07/01/2020 $2,190,888.00 9/1/2016 $2,190,888.00 3.5700% 1.3245% 1005
2016000169 SDPB $4,130,000 07/01/2021 $4,532,881.50 9/1/2016 $4,532,881.50 3.5700% 1.4191°/a 1370
2016000181 SDPB $1,040,000 07/01/2018 $1,040,000.00 10/6/2016 $1,040,000.00 1.0300% 1.0300% 274
2016000182 SDPB $1,030,000 07/01/2019 $1,030,000,00 10/6/2016 $1,030,000.00 1.1300% 1.1300°/o 639
2016000183 SDPB $1,650,000 07/01/2020 $1,650,000.00 10/6/2016 $1,650,000.00 1 . 3000°/a 1.3000% 1005
2016000184 SDPB $1,355,000 07/01/2021 $1,355,000.00 10/6/2016 $1,355,000.00 1.4200% 1 .4200°/.3 1370
2016000185 SDPB $210,000 07/01/2018 $217,028.70 10/6/2016 $217,028.70 3.0000% 1.0434% 274
2016000186 SDPB $215,000 07/01/2019 $225,734.95 10/6/2016 $225,734.95 3.0000% 1.1315°/o 639
2016000187 SDPB $1,045,000 07/01/2020 $1,166,011.00 10/6/2016 $1,166,011.00 4.5000% 1.2818% 1005
2016000188 SDPB $1,095,000 07/01/2021 $1,095,000.00 10/6/2016 $1,095,000.00 1.4200% 1.4200% 1370
22 Acct 10-151- $56,575,000.00 $59,694,851.05 $59,694,851.05 1.379488% 435
567 Totals:
Account 32-001-534 MILIS 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% 125
1 Acct 32-001-534 $50,300,000.00 $50,009,517.50 $50,009,517.50 1.121756 0/0 125
Totals:
Account 32-535-534 MIMS 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°/a 397
2017000104 FFCB $13,300,000 11/26/2018 $13,292,818.00 5/18/2017 $13,292,818.00 1.2200% 1.2561% 422
2017000099 FHDN $6,400,000 11/15/2017 $6,366,512.00 5/16/2017 $6,366,512.00 1.0350% 1.0549% 46
3 Acct 32-535-534 $32,100,000.00 $32,050,774.00 $32,057,662.89 1.231972% 337
Totals:
Account 32-700-534 ATMS 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% 258
1 Acct 32-700-534 $3,200,000.00 $3,198,875.00 $3,198,875.00 1.152830% 258
Totals:
Report Totals: $2,870,488,000.00 $2,835,269,475.52 $2,870,517,802.30 1.257959 0/a 508
file:///ClUsers/Thompsonm007/AppData/Local/Temp/tmp162E.html 10/10/2017

PROGRAM
030 040 040 020 040 030 040 020 040 035 030 040 030 040 030 040 030 040 030 040 030 950 945 781 768 766 714 066 FUND ID:
WTR
014 011 011 009 009 009 008 008 008 007 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
247,533.07 3,225,386.04 3,229,386.04 215,005.63 212,047.28 2,958.35 156,160.10 141,127.15 15,032.95 127,012.80 123,745.42 3,267.38 1,122,548.16 709,457.68 344,308.53 68,781.95 653,817.43 558,019.19 95,798.24 6,584,495.80 3,370,877.17 3,213,618.63 551,973.79 485,333_41 66,640.38 81,866.68 79,191.55 2,675.13 907,166.07 823,170.02 83,956.05 5,281,113.37 13,271.21 18,568.02 269,243.49 4,595,746.68 38,048.57 339,021.61 7,213.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
-
266 821 821 145 139 6 107 79 28 78 75 3 370 223 8 139 223 101 122 1,640 804 836 280 184 96 39 35 4 301 143 158 14,360 18 15 522 1,441 32 11,740 592
OFFICE
30-SEP-2017
PAGE:
29-SEP-2017
653

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 20-090-000 30-086-000 30-077-000 30-066-000 30-064-000 30-063-000 30-062-000 30-061-000 30-060-000 30-059-000 30-050-000 30-049-000 30-048-000 30-045-000 30-044-000 30-043-000 30-042-000 30-041-000 30-036-000 30-035-000 30- 034-0 30-033-000 30-028-000 30-027-0G0 30-026-000 Total - 1 30-025-199 30-025-191 30-025-190 30-025-186 30-025-188 30-025-187 30-025-186 30-025-1135 30-025-184 Number Account Program ID. ACC
00
SHERIFF COUNTY GENERAL TREAS SUSPENSE BANK SUSPENSE SUSPENSE TEMP SILO 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 DEP DEP ACCT DIP ACCOUNT PEP ACCT DIP ACCT DEP ACCOUNT DEP ACCOUNT DEP ACCT PEP AC= GAP ACCI FUND_BAL_NTD
WAREHOUSE GENERAL EDNDS SUSPENSE-PREPAYMENTS SERVICE CHARGE MORTGAGE CASHIER'S FD MONEY WIRES PROCEEDS FEE TAX HOLDING CHECK FUND FOR GRAZING TAX HOLDING ASSISTANCE ASSISTANCE HOLDING COURSE PENALTY RESOLUTION INFORMATION AND ASSIGN PENDING HOLDING HOLDING CLEARING CLEARING REVENUE COUNTRY HIGHLAND DESERT WEST NORTH PENDERGAST ENVIR JUVENILE Description
FUNDS COMPANIES TO BE PROM REFUNDING HOLDING NON-DELIVERABLE ACT INTEREST COLLECTIONS HOLD - CONVERSION HOLDING IMPOUNDS WITHHOLDING HOLDING DEBITS/CREDITS PROCESSING MEADOWS CC RIDGE JO TEMPE VALLEY SCHOOL SERVICES CT
APPR OR TRUSTEE INCOME INVESTMENT FUND HE RESOLUTIONS CC CC CC
UNKNOWN SALES REFUNDS 2149 SERVICE
89,017.33- 79,098,986.34 79,098,986.34 41,577,711.15 4,106,873.33 737,839.04 722,190.11 1,758.39- 21,900,841.42 4,350.56 10,220.58 235,551.01 246,628.87 5,887,046.17 1,101,842.03- 159,813.96 5,581,752.613 1.00 1,550,240.39 295,026.63 32,179.99 10,563.15 508,244.89 31,971.40- 723,917.19 14,491,133.94 3,128,169.49 161,295.59 81,717.87 137,431.81 186,688.81 129,722.09 471,783.30 Balance Opening Treasurer's MARICCPA
Report COUNTY
47,698,777.46 47,698,777.46 357,467,756.11 854,833.93- 440,872.81 457,729.24 1,369,212 3,092.88 88,701.52 1,419,210-85 347,729,176.55 1,297,608.14 2,142.00 296.55 10,024.95- 504,497.54- 5,497.81- 167,849,98 5,437,615.68 83,890.52- 617,217.86- 30,032.01- 8,711.87- 14,496.26- 16,373,02- 18,760.12- 380,568.73- Distribution Income for the Month
24 of TREASURER'S
----- SEP,
297,904.61 91,100,617.65 91,100,617.65 356,345,362.56 1,029,410.36 2,335.03 1,350.00 7,306,257.02 347,956,099.50 138,70 733.41 1.39 49,047.15 From --------- 2017 OFFICE
Transfer
190,343.14 96,114,348.00 96,114,348.00 1,315,161.58 54,412.88 4,070.06 300.00 509.55 1,241,972.25 12,429.23 1,465.82 .69 17,066.23 356.21 255.70 458.22 486.17 416.14 To
2,999.96 2,999.96 7,691,557 39,557.20 27,460.73- 962,272.26 1,484.63_ 1,327,135.74 5,388,566.53 Disbursements
61
196,578.60- 131,808,494.19 131,808,494.19 36,263,708.67 2,397,484.72 1,399,446.88 749,650.94 - 370 5, 45 22,306,431.40 5,958.83 99,222.10 235,551.01 247,138.42 66,782.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.15 37,469.91- 891,767.07 14,424,309.65 2,510,951.63 121,620.79 73,261.70 123,393.78 170,601.96 111,378.11 51,214.57 Balance Closing PACE:
35 03-OCT-2017
2

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 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,585,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,888,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,920,365,803.10 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,363.14 3,284,780.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,124.98 577,324.35 700,467.49- 563,265.91- 26,198,816.38 87,196,201.47 42,838,948.84- 20,888,656.77 1,059,480.53- 1,266,814.53 1,792,428.15 2,844,535.58 40,879,424.65 4,769,180,949.23 BALANCE
SECURED
LEVY COUNTY
AND
247,453,311.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 .00 .00 .00 .00 .00 .00 .00 .00 27.56 94.70 4,652.24 132.68 4,953.38 4,716.92 4,422.32 2,759.93 1,913.51 5,708.18 64,267.59- 940,828.95- 1,969,125.80 346,459,901.26 COLLECTIONS ACTIVITY TREASURER'S
FOR
SEP
3,092,611.76- .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 31.26- 33.26- 431.98- 374.94- 59.77- 65.02- 68.91- 186.73- 192.37- 210.03- 94,001.12- 270,627.43- 3,395,935.00- 669,606.06 ADJUSTMENTS 2017 OFFICE
ENDING
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.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,363.14 3,284,780.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
PAGE: 03-OCT-2017
1

PROGRAM
ID:
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 1393 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 YEAR APP
2,325,116,156.87 4,195,165.19 5,918,654.86 10,386,975.86 12,084,654.91 13,623,786.21 13,177,965.26 15,296,922.12 19,189,042.79 23,204,794.95 26,779,663.13 28,615,308.42 29,722,220.00 30,075,323.04 36,683,330.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,582,120.56 140,629,687.78 154,917,045.68 162,209,939.25 113,747,601.86 102,673,892.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,260.66- 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,887.66- 28,111,564.10- 25,772,613.27- 7,182,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,862.95- 35,071,797.03- 22,886,230.37- 25,511,216.65- 28,449,736-92- 9,260,158.51- 873,664.74- 3,063,441.15 13,314,650.42- 197,750.52- BALANCE
UNSECURED
LEVY COUNTY
AND
COLLECTIONS ACTIVITY
91.78 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .30 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 3.22 3.39 .00 .00 22.34- 37.16 24.56 28.28 17.51 .00 TREASURER'S
FOR
SEP
2017
ADJUSTMENTS
137.15- .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 22.35- 24.21- 30.36- 27.68- 32.55- .00 OFFICE
ENDING
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,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,887.66- 28,111,564.10- 25,772,613.27- 7,182,277.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,800.42- 22,886,230.37- 25,511,216.65- 28,449,736.93- 9,260,219.88- 873,719.66- 3,063,385.19 13,314,700.48- 197,750.52- BALANCE
PAGE: 03-OCT-2017
1