SEPTEMBER MONTHLY REPORT.PDF

Maricopa County — Formal (2017-10-25)

View PDF Item 156 Meeting page

Extracted text (via pymupdf_layout) 28181 characters
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: 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,
Royce T. Flora
Maricopa County Treasurer
STATE OF ARIZONA ) ss.
COUNTY OF MARICOPA )
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.
POiLa 01 7
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°k 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% 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.250016 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°k 1.1000% 394
2015000207 FHLMC $15,000,000 10/29/2018 $15,007,500.00 8/31/2016 $15,000,000.00 1.1000°k 1.1000% 394
2015000208 FFCB $25,000,000 07/30/2018 $24,980,000.00 8/31/2016 $24,990,500.00 0.8750% 0.8890% 303
2015000212 FHLMC $30,000,000 08/03/2018 $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 FFCB $30,000,000 08/02/2018 $30,000,000.00 8/31/2016 $30,000,000.00 1.0200°k 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
2015000238 FHLB $20,000,000 12/28/2018 $20,040,000.00 8/31/2016 $20,000,000.00 1.3300°k 1.3300% 454
2016000038 FHLB $15,000,000 12/28/2018 $15,033,000.00 8/31/2016 $15,000,000.00 1.250016 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% 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.000016 1.0177% 235
2016000085 FHLB $17,000,000 06/29/2018 $17,001,700.00 8/31/2016 $16,959,030.00 0.8750% 0.991116 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.800016 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 FH1MC $30,000,000 06/27/2018 $29,988,000.00 8/31/2016 $30,000,000.00 0.9100% 0.9100% 270
file:///C JUsers/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% 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°k 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/2018 $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
201.6000135 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°k 573
2016000150 FHLB $5,565,000 04/26/2019 $5,551,644.00 8/31/2016 $5,565,000.00 1,1000% 1.1000°/o 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% 692
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°k 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°/a 485
2016000195 FHLMC $30,000,000 11/02/2020 $30,000,000.00 10/12/2016 $30,000,000.00 1.3650% 1.3650% 1129
2016000196 FHLMC $25,000,000 10/26/2018 $25,000,000.00 10/12/2016 $25,000,000.00 1.0500% 1.0500°k 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% 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 FHLMC $20,000,000 11/27/2019 $20,000,000.00 10/27/2016 $20,000,000.00 1.3000°k 1.3000% 788
2016000215 FHLMC $20,000,000 11/10/2020 $20,000,000.00 10/27/2016 $20,000,000.00 1.4000% 1.4000% 1137
2016000233 FHLMC $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°/o 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% 1.7500% 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°/o 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% 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 FH LMC $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:///C:/Users/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/2619 $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 0/0 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 FFC8 $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,000.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°/0 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 FHLB $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% 1.2934% 270
2017000129 FMCDN $40,000,000 05/31/2018 $39,573,400.00 7/10/2017 $39,573,400.00 1.1850% 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.10000/0 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 Mote $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°/0 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/201.9 $24,777,343.75 5/5/2017 $24,777,343.75 0.8750% 1.3224% 592
105 Acct 10-151- 82,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 # 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% 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% 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 SDPB $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% 1370
2016000181 SDPB $1,040,000 07/01/2018 $1,040,000.00 10/6/2016 $1,040,000.00 1.0300 0/0 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% 639
2016000183 SDPB $1,650,000 07/01/2020 $1,650,000.00 10/6/2016 $1,650,000.00 1.3000% 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% 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°/0 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.37948806 435
567 Totals:
Account 32-001-534 MIES MAIN DEPOSITORY
Invest # Tyne 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% 125
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% 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 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% 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.2579590/0 508
file:///ClUsers/Thompsonm007/AppData/Local/Temp/tmp162E.html 10/10/2017

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

2
03-OCT-2017 PAGE: Closing Balance 91,214.57 111,373.11 170,801,96 123,393.78 73,261.70 131,620.79 2,510,951.83 14,424,309.85 891,767.07 37,469.91- 3,747.35 11,296.56 22,155.04 398.55 309,599.86 1,550,240.39 1.00 5,561,752.68 130,147.66 66,752.63- 247,138.42 235,551.01 99,222.10 5,958.83 22,306,431.40 455,970.85 749,950.84 1,389,446.88 2,397,484.72 36,263,708.67 131,808,494.19 131,808,494.19 196,578.60-
Disbursements 5,388,568.53 1,327,135.74 1,484.61 962,272.26 27,460.73- 39,557.20 7,691,557.91 2,999.96 2,999.96
TO 416.14 486.17 458.22 255.70 356.21 17,066.23 .99 1,466.82 12,429.23 1,241,972.25 509.55 300.00 4,070.06 54,412.68 1,315,161.58 96,114,343.00 96,114,348.00 190,343.14
Transfer
OFFICE From 49,047.15 1.39 733.41 138.70 347,956,089.50 7,306,257.02 1,350.00 2,335.03 1,029,410.36 356,345,362.56 91,100,617.65 91,100,617.65 297,904.61
2017
TREASURER'S SEP, of
Month the Income Distribution 380,598.73- 18,760.12- 16,373.02- 14,496.26- 8,711.87- 30,032.01- 617,217.88- 83,890.52- 5,437,615.58 167,649.88 5,497.33.- 504,497.54- 10,024.95- 398.55 2,142.00 1,297,608.14 347,729,176.55 1,419,210.85 88,701.52 3,092.88 1,369,212.24 457,729.24 640,872.61 694,833.93- 357,407,756.11 47,698,777.46 47,698,777.45
COUNTY for Report
ARICORA Treasurer's Opening Balance 471,783.30 129,722.09 186,688.81 137,431.81 81,717.87 161,299.59 3,123,169.49 14,491,133.94 723,917.19 31,971.40- 508,244.89 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.97 235,551.01 10,220.58 4,250.56 21,900,841.42 1,756.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-
M
SERVICE 2149 REFUNDS SALES UNKNOWN
SCHOOL CC VALLEY CC JO CC MEADOWS PROCESSING RESOLUTIONS HOLDING HS FUND INVESTMENT HOLD COLLECTIONS INCOME NON-DELIVERABLE TRUSTEE OR APPR BE COMPANIES
DeSCriptiOD CT JuvaILE SERVICES PENDERGAST NORTH TEMPE WEST DESERT RIDGE CC 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 PONDS WAREHOUSE
ACCT ENVIR AC= ACCT ACCOUNT ACCOUNT ACCT ACCT ACCOUNT ACCT CLEARING CLEARING REFUND TAX CASHIER'S RESOLUTION LITIGATION AND SURTAX 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 RLD SUSPENSE SUSPENSE SERVICE SUSPENSE-PREPAYMENTS SUSPENSE maps GENERAL GENERAL COUNTY SHERIFF
FUND_EAL_MTD DEP DES DES DEP DEP DEP DEP DEp DEP DES BACK IRS UPPS CIVIL GOLF GPLET TEMP BANK TRESS
ACC ID: Account NuMber 30-025-184 30-025-185 30-025-136 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-028-000 30-033-000 30-034-000 30-035-000 30-026-000 30-041-000 30-042-000 30-043-000 30-044-000 30-045-000 30-048-000 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 20-090-000 30-091-000 30-092-000 30-093-000 30-094-000 30-099-000 1 - Total 30-100-000 1 - Total 00 0-0 12 31-
Program

1
03-OCT-2017 PAGE:
BALANCE 4,423,390,654.03 35,514,363.85 3,514,737.10 1,762,694.62 1,260,896.37 1,061,586.41- 20,885,710.11 42,843,440.07- 87,191,419.53 26,193,803.23 563,773.53- 705,551.71- 577,196.39 631,066.16 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,569,819,879.45
ENDING
OFFICE 270,627.43- 94,001.12- 210.03- 192.37- 186.73- 68.91- 65.02- 59.77- 374.94- 431.98- 33.26- 31.26- .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
ADJUSTMENTS 669,606.06 3,395,935.00- 3,092,611.76-
2017
SEP
TREASURER'S FOR ACTIVITY 940,828.95- 64,267.59- 5,708.13 1,913.51 2,759.93 4,422.32 4,716.92 4,953.38 132.68 4,652.24 94.70 27.56 .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
COLLECTIONS 346,459,901.26 1,969,125.80 247,453,311.89
AND
COUNTY LEVY
SECURED 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
MARICOPA
BEGINNING
LEVY
LEVY_RPT_MONTH_SUM 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.98 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,692,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 1983 1982 1981 1980 1979 1978 1977 1976 1975 1974 1973 1972 1971 1970 1969 1968 TOTAL
PROGRAM

1
03-OCT-2017 PAGE:
BALANCE 197,750.52- 13,314,700.48- 3,063,385.19 873,719.66- 9,260,219.88- 28,449,736.93- 25,511,216.65- 22,886,230.37- 35,071,800.42- 28,750,866.17- 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,489.59-
ENDING
OFFICE .00 32.55- 27.68- 30.36- 24.21- 22.35- .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 137.15-
2017 ADJUSTMENTS
SEP
TREASURER'S FOR
ACTIVITY .00 17.51 28.28 24.56 37.16 22.34- .00 .00 3.39 3.22 .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 91.78
COLLECTIONS
AND
COUNTY LEVY
UNSECURED BALANCE 197,750.52- 13,314,650.42- 3,063,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-
MARICOPA BEGINNING
LEVY .00 .00
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.34 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