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