MONTHLY REP JANUARY2018.PDF

Maricopa County — Formal (2018-03-07)

View PDF Item 54 Meeting page

Extracted text (via pymupdf_layout) 33662 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: February 07, 2018
TO: Steve Chucri, Chairman
Denny Barney, Supervisor, District 1
Bill Gates, Supervisor, District 3
Clint Hickman, Supervisor, District 4
Steve Gallardo, Supervisor, District 5
SUBJECT: Treasurer's Collections and Investment Summary for January 2018
Secured property tax collections during the month of December equaled $141,919,716 and
increased the 2018 year to date collections to $2,755,590,100 or 58% of the adjusted 2018 levy of
$4,775,970,070. The chart below reflects the 2018 collected and uncollected levy amount and
corresponding percentages for the 2017 property tax year.
JANUARY
2018 Uncollected
Levy
$2,020,379,970
42%
Collected Levy
$2,755,590,100
58%
• Collected Levy • Uncollected Levy
The County's General Fund Balance totaled $282,096,601.97 effective January 31, 2018.
Warrants outstanding of $5,012,726.35 will post against the fund balances when presented.

The $22,890,673 unencumbered balance, of the County Municipal Line of Credit and the
$12,109,327 Workers Compensation Liability Letter of Credit remain unused.
Submitted under oath,
JusselrK. A
Pearce
Chief Deputy Treasurer
STATE OF ARIZONA ) ss.
COUNTY OF MARICOPA )
This instrument was acknowledged before me this 7th day of February 2018, 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.
caw d-x_ed
Notary Public My Commission Expires
ot I -V KAREN D SMITH
'IA Notary Public — Arizona
Marioopa County
My Comm. Expires Dec 15, 2021

Investments Portfolio Summary Page 1 of 1
Maricopa County Treasurer Investments
Portfolio Summary Report
01/31/2018 - 178 Investments
Issue Type Count Par Value Market Value Book Value YTM DIM
FCDN 3 $90,000,000.00 $88,866,075.00 $88,866,075.00 1.396576% 193
FFCB 16 $320,613,000.00 $320,204,153.00 $320,521,758.64 1.125090% 376
FHDN 14 $435,300,000.00 $432,837,912.48 $432,837,912,48 1.223131% 58
FHLB 19 $354,000,000.00 $354,029,200.00 $354,053,780.00 1.487393% 578
FHLMC 53 $1,249,318,000.00 $1,239,368,858.48 $1,249,270,664.95 1.504656% 709
FMCDN 9 $237,788,000.00 $236,230,071.55 $236,075,206.34 1,218929% 85
FNMA 30 $696,875,000.00 $671,264,381.25 $696,629,542.36 1.394694% 698
SCFD 4 $234,000.00 $258,978.78 $258,978.78 2.346510% 1105
SDPB 17 $38,810,000.00 $39,615,776,60 $39,615,776.60 1.603567% 469
TANS 8 $169,000,000.00 $169,292,370.00 $169,292,370.00 1.405936% 168
TNote 5 $108,200,000.00 $108,476,609,38 $108,502,585.94 1.251340% 549
Report 178 $3,700,138,000.00 $3,660,444,386.52 $3,695,924,651.09 1.384469% 504
Totals:
file:///ClUsers/Thompsorun007/AppData/Local/Temp/tmp9D23.html 2/7/2018

Investments Portfolio Page 1 of 5
Maricopa County Treasurer Investments
Portfolio Report
01/31/2018 - 178 Investments
Account 10-151-156 COUNTY SCHOOL TANS
Xnvest # 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.670014 1.4905% 168
2017000137 TANS $20,000,000 07/18/2018 $20,034,600.00 7/26/2017 $20,034,600.00 1.670016 0.7760% 168
2017000138 TANS $23,000,000 07/18/2018 $23,039,790.00 7/26/2017 $23,039,790.00 1.670016 1.4905% 168
2017000139 TANS $14,000,000 07/18/2018 $14,024,220.00 7/26/2017 $14,024,220.00 1.670014 1.4905% 168
2017000141 TANS $10,000,000 07/18/2018 $10,017,300.00 7/26/2017 $10,017,300.00 1.670014 1.4905% 168
2017000142 TANS $41,000,000 07/18/2018 $41,070,930.00 7/26/2017 $41,070,930.00 1.670016 1.4905% 168
2017000143 TANS $10,000,000 07/18/2018 $10,017,300.00 7/26/2017 $10,017,300.00 1.670016 1,4905% 168
2017000144 TANS $3,000,000 07/18/2018 $3,005,190.00 7/26/2017 $3,005,190.00 1.670014 1.4905% 168
8 Acct 10-151-156 $169,000,000.00 $169,292,370.00 $169,292,370.00 1.4059361/a 168
Totals:
Account 10-151-556 FIXED INCOME
Invest # Type Face Amt Mat Date Market Value MV Date Book Value Rate YTM DTM
2017000238 FHLMC $30,000,000 10/30/2020 $30,000,000.00 11/1/2017 $30,000,000.00 1.5500% 1.5500% 1003
2017000241 FHLMC $15,000,000 11/17/2020 $15,000,000.00 10/25/2017 $15,000,000.00 1,5000% 1.5000% 1021
2017000242 FHLMC $13,000,000 11/17/2020 $13,000,000.00 10/30/2017 $13,000,000.00 1.5000% 1.5000% 1021
2017000243 FHLMC $25,000,000 11/24/2020 $25,000,000.00 11/7/2017 $25,000,000.00 1.5000% 1.5000% 1028
2017000244 FHLMC $25,000,000 11/24/2020 $25,000,000.00 11/1/2017 $25,000,000.00 1,5000% 1.5000% 1028
2017000248 FHLMC $25,000,000 11/27/2020 $25,000,000.00 11/1/2017 $25,000,000.00 1.5000% 1.5000% 1031
2017000256 FHLMC $25,000,000 11/25/2020 $25,000,000.00 11/2/2017 $25,000,000.00 1.6000% 1.6000% 1029
2018000006 FHLMC $30,000,000 01/26/2021 $30,000,000.00 1/1/2018 $30,000,000.00 1.8750% 1.8750% 1091
2018000007 FNMA $25,000,000 01/26/2021 $25,000,000.00 1/10/2018 $25,000,000.00 1.8000% 1.8000% 1091
2018000008 FHLB $12,000,000 01/29/2021 $12,000,000.00 1/17/2018 $17,000,000.00 2,0500% 2.0500% 1094
2015000132 FHLMC $25,000,000 06/22/2018 $25,152,500.00 8/31/2016 $25,077,250.00 1.2500% 1.1433% 142
2015000175 FHLMC $20,000,000 06/29/2018 $20,000,000.00 8/31/2016 $20,000,000.00 1.0500% 1.050014 149
2015000205 FHLMC $25,000,000 07/27/2018 $24,960,000.00 8/31/2016 $25,000,000.00 1.0000% 1.0000% 177
2015000206 FHLMC $25,000,000 10/29/2018 $25,012,500.00 8/31/2016 $25,000,000.00 1.1000% 1.1000% 271
2015000207 FHLMC $15,000,000 10/29/2018 $15,007,500.00 8/31/2016 $15,000,000.00 1.1000% 1.1000% 271
2015000208 FFCB $25,000,000 07/30/2018 $24,980,000.00 8/31/2016 $24,990,500.00 0.8750% 0.8890% 180
2015000212 FHLMC $30,000,000 08/03/2018 $30,009,000.00 8/31/2016 $30,000,000.00 1.0000% 1,0000% 184
2015000213 FNMA $35,000,000 05/03/2019 $35,014,000.00 8/31/2016 $35,000,000.00 1.2600% 1.2600 1/6 457
2015000214 FFCB $30,000,000 08/02/2018 $30,000,000.00 8/31/2016 $30,000,000.00 1.0200% 1.0200% 183
2015000222 FNMA $25,000,000 10/29/2018 $25,000,000.00 8/31/2016 $25,000,000.00 1.1250% 1.1250% 271
2015000223 FHLMC $15,000,000 04/26/2018 $14,997,000.00 8/31/2016 $15,000,000.00 0.9500% 0.9500% 85
2015000226 FNMA $15,000,000 11/16/2018 $14,988,000,00 8/31/2016 $14,985,000.00 1.1600% 1.1940% 289
2015000238 FHLB $20,000,000 12/28/2018 $20,040,000.00 8/31/2016 $20,000,000.00 1.3300% 1.3300% 331
2016000038 FHLB $15,000,000 12/28/2018 $15,033,000.00 8/31/2016 $15,000,000.00 1.2500% 1.2500% 331
2016000055 FHLMC $22,425,000 07/27/2018 $22,425,000.00 8/31/2016 $22,425,000.00 1.0000% 1.0000% 177
file:///ClUsers/Thompsonm007/AppData/Local/Temp/tmp3164.html 2/7/2018

Investments Portfolio Page 2 of 5
2016000082 FNMA $20,000,000 06/13/2019 $20,022,000.00 8/31/2016 $20,000,000.00 1.4000% 1.4000% 498
2016000083 FHLB $20,000,000 05/23/2018 $20,010,000.00 8/31/2016 $19,993,000.00 1.0000% 1.0177% 112
2016000085 FHLB $17,000,000 06/29/2018 $17,001,700.00 8/31/2016 $16,959,030.00 0.8750% 0.9911% 149
2016000086 FHLMC $25,000,000 05/24/2019 $24,895,000.00 8/31/2016 $24,970,000.00 1.3000% 1.3413% 478
2016000102 FNMA $20,000,000 06/28/2019 $20,000,000.00 8/31/2016 $19,984,800.00 1.2000% 1.2259% 513
2016000103 FHLMC $30,000,000 06/27/2018 $29,988,000.00 8/31/2016 $30,000,000.00 0.9100% 0.9100% 147
2016000104 FNMA $30,000,000 07/05/2019 $29,877,000.00 8/31/2016 $30,000,000.00 1.1400% 1.1400°k 520
2016000110 FFCB $25,000,000 07/05/2019 $24,945,000.00 8/31/2016 $25,000,000.00 1.0200% 1.0200% 520
2016000111 FNMA $25,000,000 07/12/2019 $24,910,000.00 8/31/2016 $25,000,000.00 1.0500% 1.0500% 527
2016000114 FFCB $25,000,000 01/13/2020 $24,882,500.00 8/31/2016 $25,000,000.00 1,2400% 1.2400% 712
2016000115 FNMA $25,000,000 07/26/2019 $24,820,000.00 8/31/2016 $25,000,000.00 1.0000% 1.0000% 541
2016000119 FFCB $22,090,000 01/07/2019 $22,021,521.00 8/31/2016 $22,073,432.50 1.0000% 1.0303% 341
2016000121 FHLB $20,000,000 10/11/2019 $19,902,000.00 8/31/2016 $19,978,000.00 1.1250°k 1.1596% 618
2016000130 FFCB $20,000,000 03/22/2018 $19,974,000.00 8/31/2016 $20,003,400.00 0,8000% 0.7E198% 50
2016000131 FFCB $25,000,000 03/22/2018 $24,967,500.00 8/31/2016 $25,000,000.00 0.8000°k 0.8000% 50
2016000134 FHLB $20,000,000 05/18/2018 $19,968,000.00 8/31/2016 $20,000,000.00 0.9000% 0.9000% 107
2016000135 FNMA $20,000,000 07/26/2019 $19,930,000.00 8/31/2016 $20,000,000.00 1,1250% 1,1250% 541
2016000136 FFCB $26,000,000 06/27/2019 $25,950,600.00 8/31/2016 $25,997,400.00 0.9500% 0.9535°k 512
2016000148 FNMA $20,000,000 01/28/2020 $19,930,000.00 8/31/2016 $20,000,000.00 1.3300% 1.3300% 727
2016000149 FHLB $14,435,000 04/26/2019 $14,400,356.00 8/31/2016 $14,435,000.00 1.1000% 1.1000% 450
2016000150 FHLB $5,565,000 04/26/2019 $5,551,644.00 8/31/2016 $5,565,000.00 1.1000% 1.1000% 450
2016000157 FNMA $30,000,000 08/16/2019 $29,934,000.00 8/31/2016 $30,000,000.00 1.2000% 1,2000% 562
2016000158 FNMA $20,000,000 08/23/2019 $19,978,000.00 8/31/2016 $20,000,000,00 1.2500% 1.2500°k 569
2016000164 FHLMC $20,000,000 09/21/2018 $20,000,000.00 9/8/2016 $20,000,000.00 1.0000% 1.0000% 233
2016000166 FNMA $20,000,000 09/15/2020 $20,000,000,00 9/9/2016 $20,000,000.00 1.4500% 1.4500% 958
2016000173 FNMA $25,000,000 10/17/2019 $275,000,00 10/6/2016 $24,946,250.00 1.1000% 1.1732% 624
2016000176 FNMA $30,000,000 10/17/2019 $30,000,000.00 10/6/2016 $30,000,000.00 1.2300% 1.2300% 624
2016000180 FNMA $25,000,000 07/27/2020 $25,000,000.00 10/7/2016 $25,000,000.00 1.4000% 1.4000% 908
2016000191 FNMA $30,000,000 10/27/2020 $30,000,000.00 10/11/2016 $30,000,000.00 1.4050% 1.4050% 1000
2016000194 FFCB $13,073,000 01/28/2019 $13,073,000.00 10/12/2016 $13,073,000.00 1.2700% 1.2700% 362
2016000195 FHLMC $30,000,000 11/02/2020 $30,000,000,00 10/12/2016 $30,000,000.00 1.3650% 1.3650% 1006
2016000196 FHLMC $25,000,000 10/26/2018 $25,000,000.00 10/12/2016 $25,000,000.00 1.0500% 1.0500% 268
2016000198 FHLMC $30,000,000 11/02/2018 $30,000,000,00 10/18/2016 $30,000,000.00 0.9300% 0.9300% 275
2016000200 FNMA $17,965,000 10/28/2019 $17,960,508.75 10/19/2016 $17,960,508.75 1.2500% 1.2585% 635
2016000201 FNMA $18,910,000 09/30/2019 $18,905,272.50 10/19/2016 $18,905,272.50 1.2500% 1.2587% 607
2016000206 FNMA $25,000,000 07/28/2020 $25,000,000.00 10/24/2016 $25,000,000.00 1.3000% 1.3000% 909
2016000209 FNMA $20,000,000 07/28/2020 $20,000,000.00 10/25/2016 $20,000,000.00 1.3500% 1.3500% 909
2016000212 FHLMC $20,000,000 11/27/2019 $20,000,000.00 10/27/2016 $20,000,000.00 1.3000% 1.3000% 665
2016000215 FHLMC $20,000,000 11/10/2020 $20,000,000.00 10/27/2016 $20,000,000,00 1.4000% 1.4000% 1014
2016000233 FHLMC $20,000,000 11/27/2019 $20,000,000.00 11/9/2016 $20,000,000.00 1.3000% 1.3000% 665
2016000237 FFCB $25,000,000 12/05/2018 $25,000,000.00 11/18/2016 $24,975,355.25 1,1000% 1.1497% 308
2016000238 FNMA $25,000,000 11/26/2019 $25,000,000.00 11/22/2016 $25,000,000.00 1.5000% 1.5000% 664
2016000239 FNMA $15,000,000 05/26/2020 $15,000,000.00 11/23/2016 $15,000,000.00 1.6250% 1.6250% 846
2016000241 FHLMC $25,000,000 12/13/2019 $25,000,000.00 11/15/2016 $25,000,000.00 1.5100% 1.5100% 681
2016000243 FNMA $20,000,000 06/29/2020 $20,000,000.00 12/14/2016 $20,000,000.00 1.7500% 1.7500% 880
2016000245 FNMA $25,000,000 01/17/2020 $25,000,000.00 12/22/2016 $25,000,000.00 1.7500% 1.7500% 716
2017000004 FNMA $30,000,000 01/27/2020 $30,000,000.00 1/6/2017 $30,000,000.00 1.7000% 1.7000% 726
file:///C JUsers/Thompsonm007/AppData/L ocal/Temp/tmp3164.html 2/7/2018

Investments Portfolio Page 3 of 5
FHLB $10,000,000 07/30/2020 $10,000,000.00 1/12/2017 $10,000,000.00 1.7500% 1.7500% 911
2017000017 FHLMC $15,000,000 05/25/2018 $14,998,500.00 2/9/2017 $14,998,500.00 1.0000% 1.0078% 114
2017000047 FHLMC $10,000,000 03/27/2020 $170,000.00 3/27/2017 $10,000,000.00 1.7000% 1.7000% 786
2017000048 FHLMC $25,000,000 07/11/2019 $25,000,000.00 3/28/2017 $25,000,000.00 1.5000% 1.5000% 526
2017000059 FHLMC $20,000,000 01/26/2021 $20,000,000.00 4/18/2017 $20,000,000.00 1.7500% 1.7500% 1091
2017000060 FFCB $25,000,000 05/21/2018 $24,999,750.00 4/18/2017 $24,994,500.00 1.1000% 1,1203% 110
2017000061 FHLMC $20,000,000 05/15/2020 $20,000,000.00 4/18/2017 $20,000,000.00 1.7000% 1.7000% 835
2017000067 FHLMC $25,000,000 08/16/2019 $25,000,000.00 4/24/2017 $25,000,000.00 1.5000% 1.5000% 562
2017000070 FHLB $25,000,000 07/26/2019 $24,963,250.00 4/26/2017 $24,963,250.00 1.3750% 1.4417% 541
2017000074 FHLMC $25,000,000 05/11/2018 $24,946,000.00 4/27/2017 $24,946,000.00 1,0000% 1.2078% 100
2017000079 FHLB $30,000,000 02/03/2020 $30,000,000.00 4/28/2017 $30,000,000.00 1.6000% 1.6000% 733
2017000091 FHLMC $30,000,000 08/17/2020 $30,000,000.00 5/3/2017 $30,000,000.00 1.7000% 1.7000% 929
2017000095 FHLMC $25,000,000 05/18/2020 $25,000,000.00 5/5/2017 $25,000,000.00 1.7000% 1.7000% 838
2017000096 FFCB $12,250,000 05/17/2021 $12,250,000.00 5/5/2017 $12,250,000..00 1.9700% 1.9700% 1202
2017000113 FHLMC $20,000,000 12/27/2019 $20,000,000.00 6/28/2017 $20,000,000,00 1.5500% 1.5500% 695
2017000114 FHLB $25,000,000 06/29/2020 $25,000,000,00 6/28/2017 $25,000,000,00 1.6900% 1.6900% 880
2017000122 FHLMC $30,000,000 08/07/2020 $30,000,000.00 7/6/2017 $30,000,000.00 1,8500% 1.8500% 919
2017000123 FHLMC $30,000,000 07/19/2019 $30,000,000.00 7/6/2017 $30,000,000.00 1.5000% 1.5000% 534
2017000149 FHLMC $25,000,000 04/13/2020 $25,023,750.00 8/7/2017 $25,023,750.00 1.8009% 1.7634% 803
2017000150 FHLB $15,000,000 06/26/2020 $14,981,100.00 8/8/2017 $14,981,100.00 1.6250% 1.6702% 877
2017000158 FHLMC $20,000,000 09/29/2020 $19,980,000.00 10/2/2017 $19,983,888.89 1.7500% 1.7848% 972
2017000173 FNMA $20,000,000 09/28/2020 $19,980,000.00 10/17/2017 $19,999,444.44 1.7500% 1.7852% 971
2017000176 FHLB $15,000,000 04/17/2019 $14,977,500.00 10/2/2017 $14,978,750.00 1.5000% 1.6015% 441
2017000211 FHLMC $25,000,000 09/29/2020 $24,920,000.00 10/31/2017 $24,957,777.78 1.7000% 1.8142% 972
2017000212 FFCB $16,000,000 10/26/2020 $15,984,160.00 10/31/2017 $15,988,048.89 1.7500% 1.7845% 999
2017000213 FHLMC $25,000,000 09/01/2020 $25,000,000.00 10/24/2017 $25,000,000.00 1.8500% 1.8500% 944
'-
2017000218 FHLMC $13,893,000 10/25/2019 $13,884,108.48 11/1/2017 $13,888,498,28 1.6250% 1.6580% 632
2017000219 FHLB $25,000,000 01/16/2019 $24,909,250.00 11/1/2017 $24,909,250.00 1.2500% 1.5526% 350
2017000220 FHLB $20,000,000 12/13/2019 $26,291,400.00 11/1/2017 $20,291,400.00 2.3750% 1,6704% 681
2017000229 FFCB $5,500,000 11/06/2019 $5,491,860.00 11/3/2017 $5,491,860.00 1.6000% 1.6755% 644
2017000230 FHLB $20,000,000 11/06/2020 $20,000,000.00 11/1/2017 $20,000,000.00 1.8800% 1.8800% 1010
2017000234 FHLMC $25,000,000 08/14/2020 $25,000,000.00 10/30/2017 $25,000,000.00 1.8300% 1.8300% 926
2017000235 FNMA $20,000,000 11/09/2020 $20,000,000.00 10/30/2017 $20,000,000.00 1.9500% 1.9500% 1013
2017000236 FHLMC $25,000,000 06/09/2020 $25,000,000.00 10/30/2017 $25,000,000.00 1.8000% 1.8000% 860
2017000237 FHLMC $25,000,000 09/28/2020 $25,000,000.00 11/1/2017 $25,000,000.00 1.8400% 1.8400% 971
2917000245 FHLMC $30,000,000 08/25/2020 $30,000,000.00 11/2/2017 $30,000,000.00 1.8750% 1.8750% 937
2017000246 FHLMC $25,000,000 11/27/2020 $25,000,000.00 11/1/2017 $25,000,000.00 1.9500% 1.9500% 1031
2017000247 FHLMC $25,000,000 08/25/2020 $25,000,000.00 11/1/2017 $25,000,000.00 1.8750% 1.8750% 937
2017000249 FHLMC $25,000,000 11/27/2020 $25,000,000,00 12/1/2017 $25,000,000.00 1.8750% 1.8750% 1031
2017000250 FHLMC $25,000,000 11/27/2020 $25,000,000.00 11/1/2017 $25,000,000.00 1.8750% 1.8750% 1031
2017000254 FHLMC $25,000,000 10/30/2020 $25,000,000.00 11/2/2017 $25,000,000.00 1.9000% 1.9000% 1003
2017000255 FHLMC $25,000,000 11/25/2020 $25,000,000.00 11/2/2017 $25,000,000.00 1.9200% 1.9200% 1029
2018000005 FNMA $20,000,000 09/29/2020 $19,740,600.00 1/22/2018 $19,848,266.67 1.7000% 2.2050% 972
2018000011 FHLB $25,000,000 07/30/2020 $25,000,000.00 1/16/2018 $25,000,000.00 2.1400% 2.1400% 911
2017000116 FHDN $45,000,000 06/27/2018 $44,460,037.50 7/3/2017 $44,460,037.50 1.2100% 1.2417% 147
2017000117 FMCDN $45,000,000 05/29/2018 $44,516,200.00 7/5/2017 $44,516,200.00 1.1800% 1.2094% 118
2017000128 FCDN $40,000,000 06/27/2018 $39,507,200.00 7/10/2017 $39,507,200.00 1.2600% 1.2934% 147
file:///C:/Users/Thompsonm007/AppData/Local/Temp/tmp3164.html 2/7/2018

Investments Portfolio Page 4 of 5
FMCDN $40,000,000 05/31/2018 $39,573,400.00 7/10/2017 $39,573,400.00 1.1850% 1.2144% 120
2017000163 FHDN $25,000,000 10/04/2018 $24,666,333.33 10/4/2017 $24,666,333.33 1.3200% 1.3564% 246
2017000189 FMCDN $12,000,000 02/14/2018 $11,959,875.00 10/27/2017 $11,959,875.00 1.1250°/0 1.1445% 14
2017000196 FMCDN $20,000,000 03/30/2018 $19,902,500.00 10/30/2017 $19,902,500.00 1.1700% 1.1921% 58
2017000198 FMCDN $25,000,000 03/15/2018 $24,890,781.25 10/30/2017 $24,890,781.25 1.1650% 1.1864% 43
2017000203 FHDN $30,000,000 05/07/2018 $29,805,987.50 10/31/2017 $29,805,987.50 1,2450% 1.2705% 96
2017000204 FHDN $30,000,000 04/09/2018 $29,842,325.00 10/31/2017 $29,842,325.00 1.1900% 1.2129% 68
2017000205 FMCDN $30,000,000 03/26/2018 $29,859,833.33 10/31/2017 $29,859,833.33 1.1600% 1.1816% 54
2017000206 FHDN $25,000,000 02/12/2018 $24,919,173.61 10/31/2017 $24,919,173.61 1.13004 1.1494% 12
2017000210 FHDN $25,000,000 02/27/2018 $24,904,944.44 10/31/2017 $24,904,944.44 1.1600% 1,1806% 27
2017000214 FHDN $40,000,000 02/28/2018 $39,847,255.56 11/1/2017 $39,847,255.56 1.1650% 1.1857% 28.
2017000215 FMCDN $40,000,000 03/12/2018 $39,831,000.00 11/1/2017 $39,831,000.00 1.1700°/0 1.1913°/o 40
2017000216 FHDN $40,000,000 04/30/2018 $39,752,383.33 11/1/2017 $39,752,383.33 1.2450% 1.2702% 89
2017000217 FCDN $25,000,000 08/03/2018 $24,735,513.89 11/2/2017 $24,735,513.89 1.3900% 1.4244% 184
2017000221 FHDN $30,000,000 02/02/2018 $29,911,123.33 11/2/2017 $29,911,123.33 1.1720% 1.1918% 2
2017000222 FCDN $25,000,000 11/02/2018 $24,623,361.11 11/3/2017 $24,623,361.11 1.4900% 1.5338% 275
2017000226 FHDN $20,000,000 02/02/2018 $19,942,702.22 11/3/2017 $19,942,702.22 1.1720% 1.1917% 2
2017000231 FHDN $20,000,000 04/05/2018 $19,894,044.44 11/6/2017 $19,894,044.44 1.2800% 1.3047% 64
2017000233 FHDN $30,000,000 02/07/2018 $29,907,862.50 11/7/2017 $29,907,862.50 -1.2150°/0 1.2357% 7
2018000004 FHDN $25,000,000 02/09/2018 $24,974,222.22 1/10/2018 $24,974,222.22 1.2800% 1.2991% 9
2016000160 TNote $25,000,000 12/15/2018 $25,225,000.00 8/31/2016 $25,250,976.56 1.2500% 0,8043% 318
2017000006 TNote $25,000,000 06/30/2019 $25,169,921.88 1/10/2017 $25,169,921.88 1.6250% 1.3421% 515
2017000089 TNote $30,000,000 06/30/2020 $30,105,468.75 5/3/2017 $30,105,468.75 1.6250% 1.4995% 881
2017000094 TNote $25,000,000 05/15/2019 $24,777,343.75 5/5/2017 $24,777,343.75 0.8750% 1.3224% 469
143 Acct 10-151- $3,387,106,000.00 $3,346,688,124.67 $3,382,323,254.45 1.385524% 534
556 Totals:
Account 10-151-567 COUNTY SCHOOL BONDS
Invest # Type Face Amt Mat Date Market Value MV Date Book Value Rate YTM DTM
2013000241 SDPB $235,000 07/01/2018 $237,876.40 7/24/2013 $237,876.40 1.9800% 1.7146% 151
2013000289 SDPB $16,775,000 07/01/2018 $16,862,062.25 10/1/2013 $16,862,062.25 1.9750% 1.8576% 151
2014000091 SDPB $3,000,000 07/01/2018 $3,000,000.00 5/1/2014 $3,000,000.00 1.6300% 1.6300% 151
2014000131 SDPB $135,000 07/01/2018 $138,221.10 7/3/2014 $138,221.10 2.2900% 1.6616% 151
2014000132 SDPi3 $370,000 07/01/2019 $375,072,70 7/3/2014 $375,072.70 2.2900% 1.9921% 516
2015000073 SDPB $1,500,000 07/01/2018 $1,500,000.00 5/12/2015 $1,500,000.00 1.2700% 1.2700% 151
2015000074 SDPB $3,000,000 07/01/2019 $3,000,000.00 5/12/2015 $3,000,000.00 1.5700% 1.5700% 516
2016000168 SDPB $2,025,000 07/01/2020 $2,190,888.00 9/1/2016 $2,190,888.00 3.5700% 1.3245% 882
2016000169 SDPB $4,130,000 07/01/2021 $4,532,881.50 9/1/2016 $4,532,881.50 3.5700% 1.4191% 1247
2016000181 SDPB $1,040,000 07/01/2018 $1,040,000.00 10/6/2016 $1,040,000.00 1.0300% 1.0300% 151
2016000182 SDPB $1,030,000 07/01/2019 $1,030,000.00 10/6/2016 $1,030,000.00 1.1300% 1.1300°k 516
2016000183 SDPB $1,650,000 07/01/2020 $1,650,000.00 10/6/2016 $1,650,000.00 1.3000% 1.3000°k 882
2016000184 SDPB $1,355,000 07/01/2021 $1,355,000.00 10/6/2016 $1,355,000.00 1,4200% 1.4200% 1247
2016000185 SDPB $210,000 07/01/2018 $217,028.70 10/6/2016 $217,028.70 3.0000% 1.0434% 151
2016000186 SDPB $215,000 07/01/2019 $225,734.95 10/6/2016 $225,734.95 3.0000% 1.1315% 516
2016000187 SDPB $1,045,000 07/01/2020 $1,166,011.00 10/6/2016 $1,166,011.00 4.5000% 1.2818% 882
2016000188 SDPB $1,095,000 07/01/2021 $1,095,000.00 10/6/2016 $1,095,000.00 1.4200% 1.4200% 1247
2018000013 SCFD $49,000 07/01/2019 $51,674.91 1/30/2018 $51,674.91 6.1400°/0 2.2177% 516
2018000014 SCFD $58,000 07/01/2020 $63,181.72 1/30/2018 $63,181.72 6.1400% 2.2928% 882
file:/1/C:/Users/Thompsonm007/AppData/Local/Temp/tmp3164.html 2/7/2018

Investments Portfolio Page 5 of 5
2018000015 SCFD $62,000 07/01/2021 $69,458.60 1/30/2018 $69,458.60 6.1400% 2.3831% 1247
2018000016 SCFD $65,000 07/01/2022 $74,663.55 1/30/2019 $74,663.55 6.1400% 2.4567% 1612
21 Acct 10-151- $39,044,000.00 $39,874,755.38 $39,874,755.38 1.608020% 473
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 Ft-1DN $50,300,000 02/02/2018 $50,009,517.50 7/27/2017 550,009,517.50 1.1000% 1.1218% 2
1 Acct 32-001-534 $50,300,000.00 $50,009,517.50 $50,009,517.50 1.121756% 2
Totals:
Account 32-535-534 MIHS MCOPA HEALTH PLAN
Invest # Tyne Face Amt Mat Date Market Value MV Date Book Value Rate '(TM DTM
2017000098 FFCB $12,400,000 11/01/2018 $12,391,444.00 5/16/2017 $12,391,444.00 1.2500% 1.2975% 274
2017000104 FF03 $13,300,000 11/26/2018 $13,292,918.00 5/18/2017 $13,292,818.00 1,2200% 1.2561% . 299
2017000240 FMCDN $6,288,000 10/31/2018 $6,199,417.80 11/17/2017 $6,199,417.80 1.4700% 1.5117% 273
3 Acct 32-535-534 $31,988,000.00 $31,883,679.80 $31,883,679.80 1.322390% 284
Totals: •
Account 32-700-534 MITTS DEBT INTEREST & REDEMPTION FUND
Invest # Tyne Face Amt Mat Date Market Value MV Date Book Value Rate YTM DTM
2017000239 FMCDN $19,500,000 06/70/2019 $19,497,064.17 11/16/2017 $19,342,198.96 1.3550% 1.3850% 140
2017000105 "Mote $3,200,000 06/15/2018 $3,198,875,00 5/19/2017 $3,198,875.00 1.1250% 1.1528% 135
2 Acct 32-700-534 $22,700,000.00 $22,695,939.17 $22,541,073.96 1.352295% 139
Totals:
Report Totals: $3,700,138,000.00 $3,660,444,386.52 $3,695,924,651.09 1.384469% 504
file:///ClUsers/Thompsonm007/AppData/Local/Temp/tmp3164.html 2/7/2018

2018 595
1-JAN- PAGE:
3
31-JAN-2018
OFFICE
502 18 1,378 164 36 17 50 194 244 2 38 40 117 207 324 194 802 996 55 93 148 435 3 254 692 1 63 64 25 73 98 15 88 103 604 604 45
12,161 14,276
-
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 5,776.35 351,864.19 19,228.30 4,993,498.05 73,045.74 25,940.11 16,326.12 5,485,678.86 18,074.74 528,785.50 546,860.24 23,685.48 368,057.91 391,743.39 60,266.68 462,763.70 523,030.38 3,178,914.54 2,876,776.30 6,055,690.84 48,852.53 275,679.90 324,532.43 245,997.21 20,453.97 4,589,125.80 4,855,576.98 133.12 62,025.77 62,158.89 9,739.22 178,799.73 188,538.95 8,622.88 94,862.93 103,485.81 558,222.97 558,222.97 14,195.73
COUNTY
WARRANT
OUTSTANDING
MARICOPA
= = m = = = = = = = = = = = m = = ,-- = = = = = = = = = = = = = = = = = = m = .
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
FUND 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
NT District District District District District District District District District District District
OTSTND
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

3
05-FEB-2018 PAGE, Closing Balance 54,013.75 46,787,406-28 282,096,601.97 282,096,601.97 27,955.91- 1,442210.00 306,406.39 1,940,481.65 990,993.16 492,505.03 922,149.57 4,051,686.99 296,161.62 423,745.77 13,061.39- 816,321.39- 1,743,183.29 3,942,605.79 119,695.28- 220,031.04- 125,618.36- 981,565.66- 1,818,764.14- 226,941.51 521,403.35 5,960,956.57- 124,758.65 1,504.83 288,4E4_85 11,932,614.04 627,980.75 1,139,467.54 44,013.32 8,914,56- 50,583004.72 85,073.91- 83,504,297.74 776,295.57 8,225.91 368,980.10 11,178.73 1,618,868.91 2,704,003.34 341,458.86
Disbursements 17,459.64 6,968,260.50 498,039.01 488,039.01 412.20- 54.23 200.32- 2,544,61
To 17,459.64 53,155.62 29,671,574.17 29,671,574.17 193,180,04 200,000.00 19,000.00 49.05 17.72 2,515.09 1,329.28 1,114.08 144,164.00 181,344.30 5,133.64 285,005.78 660.00 718,429.18 3,941,056.17 8.56 82,895.69
Transfer
OFFICE From 5,486.31 147,545,772.52 63,491,297.01 83,491,297.01 241,192.36 1,221,163.92 22,308.97 51,646.40 55,868.48 83,901.72 8,331.30 2,029.45 179,878.36 118,648.23 24,952.39 15,309.07 63,636.99 280,417.27 692,259.65 156,896.70 898,892.86 145,307.35 92,860.47 3,458,969.14 210.35 22,174.85 884,766.36 254,200.49 224,815.00 1,697.30 23,715.76 9,621,378.86 20,086.96 5,826,869.12 222,574.18 18.26 406,896.51 23,456.76 205,568.10 395,465.23 5,053.51
2018
TREASURER'S JAN, of
Month the Income Distribution 541.60 150,765,152.40 48,616,469.87 46,616,469.87 947,655.13 9,073.10 62,950.43 77,764.39 2,381.76 110,538.36 69,954.37 228,06/.88 154.00 78,563.29 7,794.88 44,791.00 3,157.05- 297,617.67 242,659.08 1,907,949.03 15,215.35 1,144,881.61 29,201.10 223,763.19 71.60 10,219,705.73 34,972.25 304,216.00 124,766.25 56,942.49 421,960.58 879,643.39
COUNTY for Report
MARICOPA Treasurer's Opening Balance 58,958.46 40,492,133.29 287,787,893.95 287,787,893.95 20,056.41 1,413,718.79 297,333.29 1,860,840.19 964,875.19 490,174.22 989,036.05 4,025,032.53 232,023.46 425,785.22 61,244.91- 699,012.44- 1,756,667.70 3,879,554.57 54,054.17- 15,595.23 568,828.34 669,832.96- 1,598,-832.25- 129,589.78 614,263.83 4,415,463.33- 124,569.01 1,504.83 295,443.35 11,387,547.24 852,980.14 1,140,519.35 44,979.02 14,801.20 49,266,128.25 67,987,08- 85,307,839.44 594,653.75 6,244.27 651,101.80 24,327.00- 1,402,476.43 2,139,474.10 346,512.37
PER
CONSIGNMENT ENHANCEMENT FUND GAP THE GAP THE CONSERVATION FEES FEES SPECIAL GRANTS PROJECTS ENFORCEMENT SERVICES
Description FUNDS FEES JUDICIAL RETRIEVAL EQUIPMENT ENHANCEMENT TRAINING GRANTS RICO ENHANCEMENT MANAGEMENT GRANTS COURT TRUST FILL COURT GRANTS ATTORNEY FILL GRANTS GRANTS GRANTS RANCH DEVELOPMENT GRANTS PROBATION RESTITUTION RECREATION OPERATIONS GRANTS CAPITAL REVENUE SURCHARGE PHOTO GRANTS RECREATION GRANTS
FUNDS GENERAL WAREHOUSE WAREHOUSE PROBATION DONATIONS COURT DOCUMENT SAFETY VERDE DEFENDER MANAGEMENT PROBATION RICO ATTORNEY JAIL THE OF HOUSING THE OF ATTORNEY COUNTY ATTORNEY SERVICES TRANSPORTATION EXAMINER CROSS SPUR & PROBATION AND TRANSPORTATION DEFENDER TRANSPORTATION SPECIAL COURTS COURT SOUVENIR PLEASANT ENHANCEMENT DISTRICT
FOND_BAL_MTD SUSPENSE TREAS GENERAL COUNTY SHERIFF SHERIFF ADULT SHERIFF JUSTICE COURT OFFICER PALO JUDICIAL PUBLIC WASTE ADULT SHERIFF COUNTY SHERIFF EMERGENCY CLERK 00160 CLERK COUNTY DIVERSION COUNTY HUMAN MEDICAL PARK PLANNING JUVENILE JUVENILE JUVENILE PARKS PUBLIC WEB DEL RECORDER'S JUSTICE TRIAL PARKS LAKE PARKS LIBRARY
ACC /1). Account Number 30-099-000 1 - Total 30-100-000 1 - Total 31-120-000 31-130-000 31-201-000 31-203-000 31-204-000 31-205-000 31-206-000 31-207-000 31-20B-000 31-209-000 31-210-000 31-211-00C 31-212-000 11-213-000 31-214-000 31-215-000 31-216-000 31-217-000 31-218-000 31-219-000 31-220-000 31-221-000 31-222-000 31-223-000 31-224-000 31-225-000 31-226-000 31-227-000 31-228-000 31-229-000 31-230-000 31-222-000 31-233-000 31-234-000 31-235-000 31-235-000 31-227-000 31-238-000 31-239-000 11-240-000 31-241-000 31-242-000
Program

1
05-FEB-2018 PAGE:
BALANCE 2,020,379,970.23 19,228,865.07 2,458,250.04 1,609,655.61 1,221,937.29 1,102,480.26- 20,858,511.22 42,863,431.02- 87,180,901.07 .26,189,310.68 568,794.59- 715,272.60- 575,508.60 629,368.48 733,971.92- 1,280,666.45- 638,136.25 572,611.79- 679,5135.21- 762,856.45- 651,516.77- 78,794.84- 758,277.95- 1,128,180.03- 1,190,785.97 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,883.91 11,573.32 13,529.19 11,274.71 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 2,149,149,742.84
ENDING •
OFFICE 335,379.98- 95,421.04- 6,017.48- 365.16- 193.10- 191.35- 177.68- 137.69- 86.40- 86.19- .00 , .00 33.32- .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 oo .00 .00 .00 -00 _00 .00 .00 .00 .00
ADJUSTMENTS 2,722,153.91- 3,160,243.50-
2018
JAN
TREASURER'S FOR ACTIVITY 80,891.37- 8,706.40 8,542.69 24,059.92 10,307.81 1,483.30 1,167.83 1,048.50 1,485.89 6,506.15 389.36 18.08 6.04 6.16 1,796.06 6.33 10.04 10.46 10.58 10.38 11.20 11.00 5.50 .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 141,919,715.55 4,093,882.49 145,998,306.35
AND
COUNTY LEVY
SECURED BALANCE 2,165,021,839.69 23,658,127.54 2,472,779.71 1,624,379.49 1,230,845.14 1,078,227.24- 20,869,010.38 42,861,769.84- 87,182,206.59 26,190,445.58 567,222.51- 708,766.45- 575,897.96 629,419.88 733,965.88- 1,280,660.29- 639,932.31 572,605.46- 679,575.17- 762,845.99- 651,506.19- 78,784.46- 758,266.75- 1,128,169.03- 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,883.91 11,573.32 13,529.19 11,274.71 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 2,298,308,292.69
MARICOPA BEGINNING
LEVY
LEVY_RPT_MONTB_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 1574 1973 1972 1971 1970 1969 1968 TOTAL
PROGRAM

1
05-FEB-2018 PAGE:
'
BALANCE 197,750.52- 13,315,688.27- 3,061,642.53 874,637.98- 9,260,817.16- 28,450,246.69- 25,511,465.37- 22,886,308.17- 35,071,922.26- 28,750,866.17- 8,107,024.00 14,418,422.22- 17,542,137.97- 6,349,435.71- 950,978.54- 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,485,373.93-
ENDING
OFFICE .00 34.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 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 34.09-
2018 ADJUSTMENTS
JAN
TREASURER'S FOR .00 34.09- 817.90 .00 .00 .00 .00 .00 3.33 .00 .00 .00 .00 .00 434.13 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 1,221.27
ACTIVITY COLLECTIONS
AND
COUNTY LEVY
UNSECURED BALANCE 197,750.52- 13,315,688.27- 3,062,460.43 874,637.98- 9,260,817.16- 28,450,246.69- 25,511,465.37- 22,886,308.17- 35,071,918.93- 28,750,866.17- 8,107,024.00 14,418,422.22- 17,542,137.97- 6,349,435.71- 950,544.41- 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,484,118.57-
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.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