SIRE MONTHLY REPORT FOR JULY.PDF
Extracted text (via pymupdf_layout)
33446 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: August 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 July 2017 Secured property tax collections during the month of July equaled $96,085,917 and increased the 2016 year to date collections to $4,573,474,542 or 99% of the adjusted 2016 levy of $4,620,915,501. The chart below reflects the 2016 collected and uncollected levy amount and corresponding percentages for the 2016 property tax year. JULY Collected Levy 2017 $4,573,474,542 99% Uncollected Levy $47,440,959 1% • Collected Levy • Uncollected Levy The County's General Fund Balance totaled $139,944,927.10 effective July 30, 2017. Warrants outstanding of $5,454,797.07 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, Russell K. Pearce Chief Deputy Treasurer STATE OF ARIZONA ) ss. COUNTY OF MARICOPA ) This instrument was acknowledged before me this 9th day of August 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. a-6 I 5, r.YOl Notary Public My Commission Expires KAREN D. SMITH Notary Public - Arizona Maricopa County My Comm. Expires Dec 15, 2017 file:///C:/Users/orteze/AppData/Local/Mierosoft/Windows/Temporary °/020Intemet%20Files/Content.... Maricopa County Treasurer Investments Portfolio Summary Report 07/31/2017 - 168 Investments Issue Type Count Par Value Market Value Book Value YTM DTM FCDN 2 $65,000,000.00 $64,385,741.67 $64,385,741.67 1.227007% 261 FFCB 15 $311,113,000.00 $310,728,133.00 $311,048,738.64 1.107482% 539 FHDN 29 $913,550,000.00 $910,714,236.16 $910,714,236.15 1.012367% 66 FHLB 13 $242,000,000.00 $241,869,950.00 $241,893,280.00 1.320407% 671 FHLMC 34 $772,925,000.00 $763,038,500.00 $772,950,500.00 1.306336% 687 FMCDN 3 $120,000,000.00 $118,959,006.25 $118,959,006.25 1.153666% 236 FNDN 5 $150,000,000.00 $149,616,881.95 $149,616,881.95 0.884705% 31 FNMA 28 $651,875,000.00 $626,586,281.25 $651,670,081,25 1.322329% 815 SDPB 22 $56,575,000.00 $59,694,851.05 $59,694,851.05 1.379488% 496 TANS 9 $200,000,000.00 $200,346,000.00 $200,346,000,00 1.490490% 352 TNote 8 $188,200,000.00 $188,472,953.13 $188,254,929.69 1.113674% 515 Report 168 $3,671,238,000.00 $3,634,412,534.46 $3,669,534,246.65 1.197762% 463 Totals: file :1/IC :/Users/orteze/AppData/LocallMicrosoft/Windows/Temporary%2Olntemet%2OFiles/Content... Marieopa County Treasurer Investments Portfolio Report 07/31/2017 - 168 Investments Account 10-151456 COUNTY SCHOOL TANS Invest # Type Cusip Face Amt Mat Date Market Value MV Date Book Value Rate YTM DTM 2017000136 TANS 2017TANCH $48,000,000 07/18/2018 $48,083,040.00 7/26/2017 $48,083,040.00 1.6700% 1.4905% 352 2017000137 TANS 2017TANDV $35,000,000 07/18/2018 $35,060,550.00 7/26/2017 $35,060,550.00 1.6700910 1.4905% 352 2017000138 TANS 2017TANGB $23,000,000 07/18/2018 $23,039,790.00 7/26/2017 $23,039,790.00 1.6700% 1.4905% 352 2017000139 TANS 2017TANGD $14,000,000 07/18/2018 $14,024,220.00 7/26/2017 $14,024,220.00 1.6700% 1.4905% 352 2017000140 TANS 2017TANPV $16,000,000 07/18/2018 $16,027,680.00 7/26/2017 $16,027,680.00 1.6700% 1.4905% 352 2017000141 TANS 2017TANPN $10,000,000 07/18/2018 $10,017,300.00 7/26/2017 $10,017,300.00 1.6700% 1.4905% 352 2017000142 TANS 2017TANPE $41,000,000 07/18/2018 $41,070,930.00 7/26/2017 $41,070,930.00 1.6700% 1.4905% 352 2017000143 TANS 2017TANRO $10,000,000 07/18/2018 $10,017,300.00 7/26/2017 $10,017,300.00 1.6700% 1.4905% 352 2017000144 TANS 2017TANSD $3,000,000 07/18/2018 $3,005,190.00 7/26/2017 $3,005,190.00 1.6700% 1.4905% 352 9 Acct 10-151-156 Totals: $200,000,000.00 $200,346,000.00 $200,346,000.00 1.490490% 352 Account 10-151-556 FIXED INCOME Invest # Type Cusip Face Amt Mat Date Market Value MV Date Book Value Rate VIM DTM 2017000011 FHLMC 3134GAY24 $20,000,000 02/24/2020 $20,000,000.00 1/24/7017 $20,000,000.00 1,0000% 1.0000% 938 2014000206 FNMA 3135GGPQ0 $25,000,000 10/26/2017 $25,042,500,00 8/31/2016 $24,888,250.00 0.8750% 1,0299% 87 2015000132 FHLMC 31344366M0 $25,000,000 06/22/2018 $25,152,500.00 8/31/2016 $25,077,250.00 1.2500% 1.1433% 326 2015000175 FHLMC 3134G7L33 $20,000,000 06/29/2018 $20,000,000.00 8/31/2016 $20,000,000.00 1.0500% 1,0500% 333 2015000205 FHLMC 3134G73Q2 $25,000,000 07/27/2018 $24,960,000.00 8/31/2016 $25,000,000.00 1.0000% 1.0000% 361 2015000206 FHLMC 3134G73C3 $25,000,000 10/29/2018 $25,012,500.00 8/31/2016 $25,000,000.00 1.1000% 1.1000% 455 2015000207 FHLMC 3134G73C3 $15,000,000 10/29/2018 $15,007,500.00 8/31/2016 $15,000,000.00 1.1000% 1.1000% 455 2015000208 FFCB 3133EFMF1 $25,000,000 07/30/2018 $24,980,000.00 8/31/2016 $24,990,500.00 0.8750% 0.8890% 364 2015000212 FHLMC 3134G75P2 $30,000,000 08/03/2018 $30,009,000.00 8/31/2016 $30,000,000.00 1.0000% 1.0000% 368 2015000213 FNMA 3136G2S40 $35,000,000 05/03/2019 $35,014,000.00 8/31/2016 $35,000,000.00 1.2600% 1.2600% 641 2015000214 FFCB 3133EFMV6 $30,000,000 08/02/2018 $30,000,000.00 8/31/2016 $30,000,000.00 1.0200% 1.0200% 367 2015000222 FNMA 3136G2PF8 $25,000,000 10/29/2018 $25,000,000.00 8/31/2016 $25,000,000.00 1.1250D/a 1.1250% 455 2015000223 FHLMC 3134G76Q9 $15,000,000 04/26/2018 $14,997,000.00 8/31/2016 $15,000,000.00 0.9500% 0.9500% 269 2015000226 FNMA 3135G0G49 $15,000,000 11/16/2018 $14,988,000.00 8/31/2016 $14,985,000.00 1.1600% 1.1940% 473 2015000238 FHLB 3130A6UT2 $20,000,000 12/28/2018 $20,040,000.00 8/31/2016 $20,000,000.00 1.3300% 1.3300% 515 2016000038 FHLB 3130A7KX7 $15,000,000 12/28/2018 $15,033,000.00 8/31/2016 $15,000,000.00 1.2500% 1.2500% 515 2016000055 FHLMC 3134G8Y60 $22,425,000 07/27/2018 $22,425,000.00 8/31/2016 $22,425,000.00 1.0000% 1.0000% 361 2016000082 FNMA 3135G0K85 $20,000,000 06/13/2019 $20,022,000.00 8/31/2016 $20,000,000.00 1.4000% 1.4000% 682 2016000083 FHLB 3130A86F5 $20,000,000 05/23/2018 $20,010,000.00 8/31/2016 $19,993,000.00 1.0000% 1.0177% 296 2016000085 FHLB 3130A81304 $17,000,000 06/29/2018 $17,001,700.00 8/31/2016 $16,959,030.00 0.8750% 0.9911% 333 2016000086 FHLMC 3134G9MU8 $25,000,000 05/24/2019 $24,895,000.00 8/31/2016 $24,970,000.00 1.3000% 1•3413% 662 2016000098 FHLMC 3134G9WU7 $25,000,000 12/28/2017 $24,990,000.00 8/31/2016 $25,000,000.00 0.8000% 0.8000% 150 2016000102 FNMA 3136G3TD7 $20,000,000 06/28/2019 $20,000,000.00 8/31/2016 $19,984,800.00 1.2000% 1.2259% 697 2016000103 FHLMC 3134G9ZX8 $30,000,000 06/27/2018 $29,988,000.00 8/31/2016 $30,000,000.00 0.9100% 0.9100% 331 2016000104 FNMA 3136G3VR3 $30,000,000 07/05/2019 $29,877,000.00 8/31/2016 $30,000,000,00 1.1400% 1.1400% 704 2016000110 FFCB 3133EG3R7 $25,000,000 07/05/2019 $24,945,000.00 8/31/2016 $25,000,000.00 1.0200% 1.0200% 704 2016000111 FNMA 3135G0150 $25,000,000 07/12/2019 $24,910,000.00 8/31/2016 $25,000,000.00 1.0500% 1.0500% 711 2016000114 FFCB 3133EG1E3 $25,000,000 01/13/2020 $24,882,500.00 8/31/2016 $25,000,000.00 1.2400% 1.2400% 896 2016000115 FNMA 3135G0M26 $25,000,000 07/26/2019 $24,820,000.00 8/31/2016 $25,000,000.00 1.0000% 1.0000% 725 2016000119 FFCB 3133EG3Z9 $22,090,000 01/07/2019 $22,021,521.00 8/31/2016 $22,073,432.50 1.0000% 1.0303% 525 2016000121 FHLB 3130A8NRO $20,000,000 10/11/2019 $19,902,000.00 8/31/2016 $19,978,000.00 1.1250% 1.1596% 802 2016000130 FFCB 3133EGND3 $20,000,000 03/22/2018 $19,974,000,00 8/31/2016 $20,003,400.00 0.8000% 0.7898% 234 2016000131 FFCB 3133EGND3 $25,000,000 03/22/2018 $24,967,500,00 8/31/2016 $25,000,000.00 0.8000% 0.8000% 234 2016000134 FHLB 3130A8T29 $20,000,000 05/18/2018 $19,968,000.00 8/31/2016 $20,000,000.00 0.9000% 0.9000% 291 2016000135 FNMA 3136G3P33 $20,000,000 07/26/2019 $19,930,000.00 8/31/2016 $20,000,000:00 1.1250% 1.1250% 725 2016000136 FFCB 3133EGNZ4 $26,000,000 06/27/2019 $25,950,600.00 8/31/2016 $25,997,400.00 0.9500% 0.9535% 696 2016000148 FNMA 3136G3R98 $20,000,000 01/28/2020 $19,930,000.00 8/31/2016 $20,000,000.00 1.3300% 1.3300% 911 2016000149 FHLB 3130A8WE9 $14,435,000 04/26/2019 $14,400,356.00 8/31/2016 $14,435,000.00 1.1000% 1.1000% 634 2016000150 FHLB 3130A8WE9 $5,565,000 04/26/2019 $5,551,644.00 8/31/2016 $5,565,000.00 1.1000% 1.1000% 634 2016000157 FNMA 3135G0N58 $30,000,000 08/16/2019 $29,934,000.00 8/31/2016 $30,000,000.00 1.2000% 1.2000% 746 file :1//C :/ljsers/orteze/AppData/LocallMicrosoftlWindows/Temporary%2Olnterflet%2OFileS/COflteflt.... 2016000158 FNMA 3135G0P23 $20,000,000 08/23/2019 $19,978,000.00 8/31/2016 $20,000,000.00 1.2500% 1.2500% 753 2016000164 FHLMC 3134GAMA9 $20,000,000 09/21/2018 $20,000,000.00 9/8/2016 $20,000,000.00 1.0000% 1.0000% 417 2016000166 FNMA 3136G36 B6 $20,000,000 09/15/2020 $20,000,000.00 9/9/2016 $20,000,000.00 1.4500% 1.4500% 1142 2016000173 FNMA 3136G4DR1 $25,000,000 10/17/2019 $275,000.00 10/6/2016 $24,946,250.00 1.1000% 1.1732% 808 2016000176 FNMA 3136G4FM0 $30,000,000 10/17/2019 $30,000,000.00 10/6/2016 $30,000,000.00 1.2300% 1.2300% 808 2016000180 FNMA 3136G4FQ1 $25,000,000 07/27/2020 $25,000,000.00 10/7/2016 $25,000,000.00 1.4000% 1.4000% 1092 2016000191 FNMA 3136G4ET5 $30,000,000 10/27/2020 $30,000,000.00 10/11/2016 $30,000,000.00 1.4050% 1.4050% 1184 2016000194 FFCB 3133EFWX1 $13,073,000 01/28/2019 $13,073,000.00 10/12/2016 $13,073,000.00 1.2700% 1.2700% 546 2016000195 FHLMC 3134GATM6 $30,000,000 11/02/2020 $30,000,000.00 10/12/2016 $30,000,000.00 1.3650% 1.3650% 1190 2016000196 FHLMC 3134GASE5 $25,000,000 10/26/2018 $25,000,000.00 10/12/2016 $25,000,000.00 1.0500% 1.0500% 452 2016000198 FHLMC 3134GAU H5 $30,000,000 11/02/2018 $30,000,000.00 10/18/2016 $30,000,000.00 0.9300% 0.9300% 459 2016000200 FNMA 3136G4EM1 $17,965,000 10/28/2019 $17,960,508.75 10/19/2016 $17,960,508.75 1.2500% 1.2585% 819 2016000201 FNMA 3135GOP80 $18,910,000 09/30/2019 $18,905,272.50 10/19/2016 $18,905,272.50 1.2500% 1.2587% 791 2016000206 FNMA 3136G4GD9 $25,000,000 07/28/2020 $25,000,000.00 10/24/2016 $25,000,000.00 1.3000 0/n 1.3000% 1093 2016000209 FNMA 3136G4GK3 $20,000,000 07/29/2020 $20,000,000.00 10/25/2016 $20,000,000.00 1.3500% 1.3500% 1093 2016000212 FHLMC 3134GAWF7 $20,000,000 11/27/2019 $20,000,000.00 10/27/2016 $20,000,000.00 1.3000% 1.3000% 849 2016000215 EH LMC 3134GAWJ9 $20,000,000 11/10/2020 $20,000,000.00 10/27/2016 $20,000,000.00 1.4000% 1.4000% 1198 2016000233 FHLMC 3134GAYDO $20,000,000 11/27/2019 $20,000,000.00 11/9/2016 $20,000,000.00 1.3000% 1.3000% 849 2016000237 FFCB 3133EGM69 $25,000,000 12/05/2018 $25,000,000.00 11/18/2016 $24,975,355.25 1.1000% 1.1497% 492 2016000238 FNMA 3136G41A2 $25,000,000 11/26/2019 $25,000,000.00 11/22/2016 $25,000,000.00 1.5000% 1.5000% 848 2016000239 FNMA 3136G4J90 $15,000,000 05/26/2020 $15,000,000.00 11/23/2016 $15,000,000,00 1.6250% 1.6250% 1030 2016000241 FHLMC 3134GAZV9 $25,000,000 12/13/2019 $25,000,000.00 11/15/2016 $25,000,000.00 1.5100% 1.5100% 865 2016000243 FNMA 3136G4KD4 $20,000,000 06/29/2020 $20,000,000.00 12/14/2016 $20,000,000.00 1.7500% 1.7500% 1064 2016000245 FNMA 3136G4KM4 $25,000,000 G1/17/2020 $25,000,000.00 12/22/2016 $25,000,000.00 1.7500% 1.7500% 900 2017000004 FNMA 3135G0553 $30,000,000 01/27/2020 $30,000,000.00 1/6/2017 $30,000,000.00 1.7000% 1.7000% 910 2017000007 FH LB 3130AAM K1 $10,000,000 07/30/2020 $10,000,000.00 1/12/2017 $10,000,000.00 1.7500% 1.7500% 1095 2017000017 FHLMC 3134124428 $15,000,000 05/25/2018 $14,998,500.00 2/9/2017 $14,998,500.00 1.0000% 1.0078% 298 2017000020 FHLMC 3134GA5J9 $10,000,000 08/28/2020 $10,000,000.00 2/14/2017 $10,000,000.00 1.8500% 1.8500% 1124 2017000021 FNMA 3136G4LSO $15,000,000 08/24/2020 $15,000,000.00 2/14/2017 $15,000,000.00 1.8750% 1.8750% 1120 2017000031 FH LMC 3134GBBG6 $25,500,000 09/29/2020 $25,500,000.00 3/2/2017 $25,500,000.00 2.0000% 2.0000% 1156 2017000034 FFCB 3133EHCC5 $12,000,000 03/13/2020 $12,000,000.00 3/6/2017 $12,000,000.00 1.8000% 1.8000% 956 2017000047 FHLMC 3134GBEB4 $10,000,000 03/77/2020 $170,000.00 3/27/2017 $10,000,000.00 1,7000% 1.7000% 970 2017000048 FHLMC 3134128EE7 $25,000,000 07/11/2019 $25,000,000.00 3/28/2017 $25,000,000.00 1.5000% 1.5000% 710 2017000059 FHLMC 3134128112 $20,000,000 01/26/2021 $20,000,000.00 4/18/2017 $20,000,000.00 1.7500% 1.7500% 1275 2017000060 FFCB 3133EHGD9 $25,000,000 05/21/2018 $24,999,750.00 4/18/2017 $24,994,500.00 1.1000% 1.1203% 294 2017000061 FHLMC 3134GBJK9 $20,000,000 05/15/2020 $20,000,000.00 4/18/2017 $20,000,000.00 1.7000% 1.7000% 1019 2017000067 FHLMC 3134GBLWO $25,000,000 08/16/2019 $25,000,000.00 4/24/2017 $25,000,000.00 1.5000% 1.5000% 746 2017000070 FH LB 3130ABB21 $25,000,000 07/26/2019 $24,963,250.00 4/26/2017 $24,963,250.00 1.3750% 1.4417% 725 2017000074 FHLMC 3134G9] DO $25,000,000 05/11/2018 $24,946,000.00 4/27/2017 $24,946,000.00 1.0000% 1.2078% 284 2017000079 FH LB 3130ABCG9 $30,000,000 02/03/2020 $30,000,000.00 4/28/2017 $30,000,000,00 1.6000% 1.6000% 917 2017000090 FH LB 3130ABDB9 $20,000,000 08/28/2019 $20,000,000.00 5/3/2017 $20,000,000.00 1.5000% 1.5000% 758 2017000091 FHLMC 3134GBNT5 $30,000,000 08/17/2020 $30,000,000.00 5/3/2017 $30,000,000.00 1.7000% 1.7000% 1113 2017000095 FHLMC 3134GBPK2 $25,000,000 05/18/2020 $25,000,000.00 5/5/2017 $25,000,000.00 1.7000% 1.7000% 1022 2017000096 FECB 3133EHJH7 $12,250,000 05/17/2021 $12,250,000.00 5/5/2017 $12,250,000.00 1.9700% 1.9700% 1386 2017000113 FHLMC 3134GBXG2 $20,000,000 12/27/2019 $20,000,000.00 6/28/2017 $20,000,000.00 1.5500% 1.5500% 879 2017000114 EH LB 3130ABPV2 $25,000,000 06/29/2020 $25,000,000.00 6/28/2017 $25,000,000,00 1.6900% 1.6900% 1064 2017000121 FHLMC 3134GBPA4 $25,000,000 05/28/2020 $24,987,500.00 7/6/2017 $25,033,750.00 1.8000% 1.8180% 1032 2017000123 FHLMC 3134GBZH8 $30,000,000 07/19/2019 $30,000,000.00 7/6/2017 $30,000,000.00 1.5000% 1.5000% 718 2017000071 EH DN 3133851)45 $35,000,000 08/02/2017 $34,919,013.89 4/26/2017 $34,919,013.89 0.8500% 0.8638% 2 2017000072 EH DN 313385JZO $40,000,000 08/04/2017 $39,906,500.00 4/27/2017 $39,906,500.00 0.8500% 0.8638% 4 2017000077 EN DN 313589KE2 $40,000,000 08/09/2017 $39,908,444.44 4/28/2017 $39,908,444.44 0.8000% 0.8130% 9 2017000078 FH DN 313385KM7 $42,950,000 08/16/2017 $42,837,136.94 4/28/2017 $42,837,136.94 0.8600% 0.8742% 16 2017000080 EN DN 313589KL6 $25,000,000 08/15/2017 $24,940,375.00 5/1/2017 $24,940,375.00 0.8100% 0.8232% 15 2017000083 FHDN 313385KD7 $45,000,000 08/08/2017 $44,894,650.00 5/1/2017 $44,894,650,00 0.8600% 0.8740% 8 2017000085 FHDN 313385KE2 $30,000,000 08/10/2017 $29,928,333.33 5/2/2017 $29,928,333.33 0.8600% 0.8740% 10 2017000087 FYI DN 313385LA2 $40,000,000 08/29/2017 $39,884,300.00 5/3/2017 $39,884,300.00 0.8900% 0.9050% 29 2017000088 EN DN 313589KN2 $25,000,000 08/17/2017 $24,938,902.78 5/3/2017 $24,938,902.78 0.8300% 0,8436% 17 2017000092 EN DN 313589KU6 $25,000,000 08/23/2017 $24,934,305.56 5/4/2017 $24,934,305.56 0.8600% 0.8742% 23 2017000100 EH DN 313385PG5 $13,600,000 11/15/2017 $13,528,838.00 5/16/2017 $13,528,838.00 1.0350% 1.0549% 107 2017000101 FHDN 313385KK1 $21,200,000 08/14/2017 $21,151,805.33 5/18/2017 $21,151,805.33 0.9300% 0.9451% 14 2017000109 FMCDN 313397MX6 $35,000,000 10/13/7017 $34,969,406.25 5/31/2017 $34,869,406.25 0.9950% 1.0126% 74 2017000110 FHDN 313385KV7 $40,000,000 08/24/2017 $39,908,533.33 6/1/2017 $39,908,533.33 0.9800% 0.9959% 24 2017000111 MON 3133851(28 $30,000,000 08/28/2017 $29,928,133.33 6/1/2017 $29,928,133.33 0.9800% 0.9960% 28 2017000112 EN ON 313385KS4 $30,000,000 08/21/2017 $29,954,325.00 6/28/2017 $29,954,325.00 1.0150% 1.0307% 21 2017000115 FHDN 31338 5L80 $35,000,000 08/30/2017 $34,942,201.39 6/29/2017 $34,942,201.39 1.0250% 1.0410% 30 2017000116 Fl-ION 313385YQ3 $45,000,000 06/27/2018 $44,460,037.50 7/3/2017 $44,460,037.50 1.2100% 1.2417% 331 2017000117 FMCDN 313397XK2 $45,000,000 05/29/2018 $44,516,200.00 7/5/2017 $44,516,200.00 1.1800% 1.20940/n 302 file:MC:/Users/orteze/AppData/Local/Microsoft/Windows/Temporary%20Internet%20Files/Content.... 2017000118 FHON 313385LP9 $35,000,000 09/11/2017 $34,933,227.78 7/5/2017 $34,933,227.78 1.0100% 1.0260% 42 2017000119 PH ON 313385LQ7 $40,000,000 09/12/2017 $39,922,555.56 7/6/2017 $39,922,555.56 1.0250% 1.0413% 43 2017000120 FHDN 313385K2 $15,000,000 12/29/2017 $14,917,133.33 7/6/2017 $14,917,133.33 1.1300% 1.1521 0/n 151 2017000124 FHDN 313385L33 $6,600,000 09/06/2017 $6,588,537.08 7/7/2017 $6,588,537,08 1.0250% 1.0410% 37 2017000125 FHDN 313385L13 $30,500,000 09/06/2017 $30,447,285.83 7/7/2017 $30,447,285.83 1.0200% 1.0360% 37 2017000126 FNDN 313589NH2 $35,000,000 10/23/2017 $34,894,854.17 7/7/2017 $34,894,854.17 1.0300% 1.0475% 84 2017000127 FHDN 313385MQ6 $30,000,000 10/06/2017 $29,920,754.17 7/7/2017 $29,920,754.17 1.0450% 1.0623% 67 2017000128 FCDN 313313YQ5 $40,000,000 06/27/2018 $39,507,200.00 7/10/2017 $39,507,200.00 1.2600% 1.2934% 331 2017000129 FMCDN 313397XM8 $40,000,000 05/31/2018 $39,573,400.00 7/10/2017 $39,573,400.00 1.1850% 1.2144% 304 2017000130 FHDN 313385RC2 $35,000,000 12/29/2017 $34,818,787.50 7/10/2017 $34,818,787.50 1.0900% 1.1109% 151 2017000131 FHDN 313385LKO $25,000,000 09/07/2017 $24,959,822.92 7/11/2017 $24,959,822.92 1.0150% 1.0308')/0 38 2017000132 FE-ION 313385LX2 $40,000,000 09/19/2017 $39,922,566.67 7/12/2017 $39,922,566.67 1.0100% 1.0260% 50 2017000133 Fl-ION 313385QZ2 $30,000,000 12/26/2017 $29,850,600.00 7/12/2017 $29,850,500.00 1.0800% 1.1005Dk 148 2017000134 FHDN 313385LR5 $35,000,000 09/13/2017 $34,944,466.57 7/18/2017 $34,944,466.66 1.0200% 1.0358% 44 2017000135 FCDN 313313RA8 $25,000,000 12/27/2017 $24,878,541.57 7/21/2017 $24,878,541.67 1.1000% 1.1207% 149 2017000145 FHDN 313385LY0 $40,000,000 09/20/2017 $39,937,238.89 7/26/2017 $39,937,238.99 1.0270% 1.0429% 51 2017000146 Fl-ION 313385MA1 $22,000,000 09/22/2017 $21,964,922.22 7/27/2017 $21,964,922.22 1.0250% 1.0409% 53 2017000148 FHDN 313385LS3 $25,000,000 09/14/2017 $24,966,500.00 7/28/2017 $24,966,500.00 1.0050% 1.0203% 45 " 2015000235 TNote 91282811E8 $30,000,000 12/31/2017 $30,003,000.00 8/31/2016 $29,852,343.75 0.7500% 0.9872% 153 2015000241 TNote 912828N55 $20,000,000 12/31/2017 $20,066,000.00 8/31/2016 $19,972,656.25 1.0000% 1.0684% 153 2016000160 TNote 912828N22 $25,000,000 12/15/2018 $25,225,000.00 8/31/2016 $25,250,976.56 1.2500% 0.8043% 502 2016000230 TNote 912878R93 $30,000,000 06/30/2018 $29,927,343.75 11/7/2016 $29,927,343.75 0.6250% 0.7739% 334 2017000006 TNote 912828WS5 $25,000,000 06/30/2019 $25,169,921.88 1/10/2017 $25,169,921.88 1.6250% 1.3421% 699 2017000089 TNote 912828XH8 $30,000,000 06/30/2020 $30,105,468.75 5/3/2017 $30,105,468.75 1.6250% 1.4995% 1065 2017000094 TNote 912828R44 $25,000,000 05/15/2019 $24,777,343.75 5/5/2017 $24,777,343.75 0.8750% 1.3224% 653 132 Acct 10-151-556 Totals: $3,329,063,000.00 $3,289,112,516.91 $3,324,227,340.21 1.177949% 474 Account 10-151-567 COUNTY SCHOOL BONDS Invest # Type Ct.g Face Amt Mat Date Market Value MV Date Book Value Rate VIM DIM 2013000162 SOPS CHAND2013 $75,000 01/01/2018 $89,799.75 5/15/2013 $89,799.75 5.2300% 0.8615% 154 2013000167 SOPS PHXESD $4,190,000 01/01/2018 $5,100,696.50 5/15/2013 $5,100,696.50 5.6500% 0.8424% 154 2013000175 SOPS DYSREF13 $4,530,000 01/01/2018 $4,820,690.10 5/17/2013 $4,820,690.10 2.3000% 0.8768% 154 2013000187 SDPS PEOREF13 $8,600,000 01/01/2018 $9,656,252.00 5/23/2013 $9,656,252.00 3.6500% 0.9123% 154 2013000206 SDPS QCUSD $370,000 01/01/2018 $411,636.10 5/5/2013 $411,636.10 3.6200% 1.0747% 154 2013000241 SOPS CARTESD $235,000 07/01/2018 $237,876.40 7/24/2013 $237,876.40 1.9800% 1.7146% 335 2013000289 SOPS GLENUSD $16,775,000 07/01/2018 $16,862,062.25 10/1/2013 $16,862,062.25 1.9750% 1.8576% 335 2014000091 SDP13 WASHESDO6 $3,000,000 07/01/2018 $3,000,000.00 5/1/2014 $3,000,000.00 1.6300% 1,6300°/0 335 2014000131 SDPS CART2014C $135,000 07/01/2018 $138,221.10 7/3/2014 $138,221.10 2.2900% 1.6616% 335 2014000132 SOPS CART2014D $370,000 07/01/2019 $375,072.70 7/3/2014 $375,072.70 2.2900% 1.9921% 700 2015000073 SOPS WASH2015A $1,500,000 07/01/2018 $1,500,000.00 5/12/2015 $1,500,000.00 1.2700% 1.2700% 335 2015000074 SDPS W45H201513 $3,000,000 07/01/2019 $3,000,000.00 5/12/2015 $3,000,000.00 1.5700 0/n 1.5700% 700 2016000168 SDPS PHXE016B $2,025,000 07/01/2020 $2,190,889.00 9/1/2016 $2,190,888.00 3.5700% 1.3245% 1066 2016000169 SOPS PHXE016C $4,130,000 07/01/2021 $4,532,881.50 9/1/2016 $4,532,881.50 3.5700% 1.4191% 1431 2016000181 SOPS R.9R2015S1 $1,040,000 07/01/2018 $1,040,000.00 10/6/2016 $1,040,000.00 1.0300% 1.0300% 335 2016000182 SOPS RVR2016B1 $1,030,000 07/01/2019 $1,030,000.00 10/6/2016 $1,030,000.00 1.1300% 1.1300% 700 2016000183 SOPS RVR2016131 $1,650,000 07/01/2020 $1,650,000.00 10/6/2016 $1,650,000.00 1.3000% 1.3000% 1066 2016000184 SOPS RVR2016131 $1,355,000 07/01/2021 $1,355,000.00 10/6/2016 $1,355,000.00 1.4200% 1.4200% 1431 2016000185 SOPS RVR2016R $210,000 07/01/2018 $217,028.70 10/6/2016 $217,028.70 3.0000% 1.0434% 335 2016000186 SOPS RVR2016R $215,000 07/01/2019 $225,734.95 10/6/2016 $225,734.95 3.0000% 1.1315% 700 2016000187 SOPS I1VR2016R $1,045,000 07/01/2020 $1,166,011.00 10/6/2016 $1,166,011.00 4.5000% 1.2818% 1066 2016000188 SOPS RVR2016R $1,095,000 07/01/2021 $1,095,000.00 10/6/2016 $1,095,000.00 1.4200% 1.4200% 1431 22 Acct 10-151-567 Totals: $56,575,000.00 $59,694,851.05 $59,694,851.05 1.379488% 496 Account 32-001-534 1VIIHS MAIN DEPOSITORY Invest # Type Cush, Face Amt Mat Date Market Value MV Date Book Value Rate YTM ATM 2017000147 FHDN 313385SP2 $50,300,000 02/02/2018 $50,009,517.50 7/27/2017 $50,009,517.50 1.1000% 1.1218% 186 1 Acct 32-001-534 Totals: $50,300,000.00 $50,009,517.50 $50,009,517.50 1.121756% 186 Account 32-535-534 MIHS MCOPA HEALTH PLAN Invest # Type Cusip Face Amt Mat Date Market Value MV Date Book Value Rate YIT4 TM 2017000098 FFCB 3133EHHF3 $12,400,000 11/01/2018 $12,391,444.00 5/16/2017 $12,398,332.89 1.2500% 1.2975% 458 2017000104 FFCS 3133EHK31 $13,300,000 11/26/2018 $13,292,818.00 5/18/2017 $13,292,818.00 1.2200% 1.2561% 483 2017000099 FHDN 313385PG5 $6,400,000 11/15/2017 $6,366,512.00 5/16/2017 $6,366,512.00 1.0350% 1.0549% 107 3 Acct 32-535-534 Totals: $32,100,000.00 $32,050,774.00 $32,057,662.89 1.231972% 398 file :1//C :/Users/orteze/AppDatalLocallMicrosoftlWindowslTemporary%2Olnterflet%2OFileS/Coflteflt. Account 32-700-534 MIHS DEBT INTEREST & REDEMPTION FUND priest * Type Cusp Face Amt Mat Date Market Value MV Date Book Value Rate YTM DTM 2017000105 Mote 912828XF2 $3,200,000 06/15/2018 $3,198,875.00 5/19/2017 $3,198,875.00 1.1250% 1.1528% 319 1 Acct 32-700-534 Totals: $3,200,000.00 $3,198,875.00 $3,198,875.00 1.152830 0/0 319 Report Totals: $3,671,238,000.00 $3,634,412,534.46 $3,669,534,246.65 1.197762% 463 PROGRAM 030 040 040 030 040 030 040 040 035 030 040 030 040 030 040 030 040 030 040 030 962 930 945 781 768 766 714 066 FUND ID: WTR 014 011 011 009 009 009 008 008 008 007 007 006 006 006 006 005 005 005 004 004 004 003 003 003 002 002 002 001 001 001 000 000 000 000 000 000 COO 000 000 DISTRICT District District District District District District District District District District District WARRANT OTSTND_WT_FUND Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = - = = = = - = • NUMBER MAR ICOPA OUTSTANDING WARRANT 8,412.04 1,819,211.99 1,819,211.99 601,124.73 598,953.16 2,171.57 392,909.97 352,389.18 40,520.79 152,647.74 152,647.74 1,345,739.45 1,031,739.24 247,122.07 66,878.14 294,933.77 206,958.26 87,975.51 4,838,316.60 1,400,053.06 3,438,263.54 325,818.15 238,039.34 87,778.81 63,582.07 53,199.58 10,382.49 790,982.99 777,127.20 13,855.79 6,097,789.87 85,277.89 94,345.69 84,966.38 84,709.28 5,401,185.20 53,611.87 286,661.04 7,032.52 WARRANTS COUNTY AMOUNT - Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: COUNT DISTRICT by TREASURER'S FUND - 13 671 671 BO 77 3 148 92 56 77 77 315 199 6 110 180 141 39 1,080 644 436 251 108 143 44 32 12 281 245 36 13,024 24 33 45 196 1,373 50 10,579 724 OFFICE 31-JUL-2017 PAGE: 31-JUL-2017 616 31-120-000 Total - 1 30-100-000 Total - 1 30-099-000 30-094-000 30-093-000 30- 09 2-0 30-092-000 30-090-000 30-086-000 30-077-000 30-066-003 30-064-000 30-063-000 30-062-000 30-061-000 30-060-000 20-009-000 30-050-000 30-049-000 30-048-000 30-045-000 30-044-000 30-043-000 30-042-000 30-041-000 30-036-000 30-035-000 30-034-000 50-033-000 20-028-000 30-027-000 30-026-000 Total - 1 30-025-199 30-025-191 30-025-193 30-025-189 30-025-188 30-025-187 30-025-186 30-025-185 30-025-184 Number Account Program ID: ACC 00 SHERIFF COUNTY GENERAL TREES SUSPENSE BANK SUSPENSE SUSPENSE TEMP HOD UNIDENTIFIED EXCESS RECORDER CURRENT PROBLEM TRUST TAYLOR UNDISTRIBUTED UNDISTRIBUTED REDEMPTION ELDERLY ELDERLY GPLET GOLF COURSE CIVIL UPPS TAXPAYER IRS INTEREST SURTAX LITIGATION RESOLUTION CASHIER'S BACK TAX REFUND nRR CLEARING DEP ACCT DES ACCOUNT DES ACCT DES ACCT DES ACCOUNT DES ACCOUNT DES ACCT CEP ACCT DES ACCT FUNDRAL MTD WAREHOUSE GENERAL FUNDS SUSPENSE-PREPAYMENTS SERVICE CHARGE MORTGAGE CASHIER'S FD MONEY WIRES PROCEEDS FEE TAX HOLDING CHECK FOND FOR GRAZING TAX HOLDING ASSISTANCE ASSISTANCE HOLDING PENALTY RESOLUTION INFORMATION AND ASSIGN SENDING HOLDING HOLDING CLEARING REVENUE COUNTRY HIGHLAND DESERT WEST NORTH PENDERGA,ST ZNVIR JUVENILE Description FUNDS COMPANIES TO BE FROM REFUNDING HOLDING NON-DELIVERABLE ACT INTEREST COLLECTIONS HOLD - CONVERSION HOLDING IMPOUNDS WITHHOLDING HOLDING DEBITS/CREDITS PROCESSING IC RIDGE IC TENSE VALLEY SCHOOL SERVICES CT APPR OR TRUSTEE INCOME INVESTMENT FUND HE RESOLUTIONS MEADOWS IC JO ac UNKNOWN SALES REFUNDS 2149 SERVICE 208,968.73- 60,465,225.69 60,465,225.69 43,804,504.29 3,112,417.78 8,524,515.57 677,012.78 3,620.96 20,287,442.12 4,216.25 90,938.00 235,551.01 246,629.57 99,091.95- 1,244,409.73 5,581,732.68 1.00 1,550,240.39 292,544.73 149,082.97 10,563.15 1,029,288.10 752,370.15 9,448,502.10 4,020,496.49 174,094.22 79,202.71 144,895.78 175,754.72 131,911.04 60,024.96 Balance Opening Treasurer's MARICOPA Report COUNTY 51,651,872.15 51,651,873.15 105,995,542.15 240,646.93 296,444.88- 1,585.38- 1,900,357.16 2,358.00 68,137.22 3,409,528.05 90,116,422.19 1,746,464.00 1,064.00 842.35 1,065,621.22 553,293.20- 8,906.01- 256,888.24 8,043,602.25 2,011,607.00 1,441,171.00. 34,068.26- 5,630.29- 23,170.09- 4,025.85- 15,114.24- 246,356.64 Distribution Income for the Month of SUL, TREASURER'S 110,987.21 182,641,627.39 182,641,627.35 91,610,370.53 285.94 940.00 91,495,335,92 2,888.87 .33 110,919.47 From 2017 OFFICE Transfer 194,620.97 212,483,703.67 212,483,703.67 2,074,391.09 698,257.39 .40 1,375,927.30 206.00 17,005.38 315.76 146.54 451.67 603.42 533.25 To 2,014,248.02 2,014,248.02 12,287,528.00 719,070.58 17,357.28- 781,562.12 1,084.69 2,870,495.10 7,932,682.79 Disbursements 125,334.97- 119,944,927.10 139,944,927.10 47,977,535.00 3,433,165.58 8,128,071.09 694,380.06 1,635.58 21,510,337.16 5,489.56 159,075.22 235,551.01 246,628.87 3,409,529.04 91,078.38- 117,489.76 5,581,752.68 1.00 1,550,240.39 293,814.73 842.35 1,213,704.19 10,563.15 475,994.90 8,906,34- 1,009,258.39 11,477,114.48 2,579,325.49 140,341.72 73,718.96 122,177,36 172,332.29 117,330.05 306,381.80 Balance Closing PAGE: 02 -AUG-2017 2 PROGRAM TOTAL 1968 1969 1970 1971 1972 1973 1974 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 YEAR ID: APP 90,867,625,621.32 116,414,184.58 126,632,073.74 138,694,628.82 165,623,012.50 191,805,552.44 224,585,828.94 251,690,646.52 294,189,512.68 322,481,242.68 360,443,065.88 365,594,731.04 382,783,606.36 373,230,675.34 402,942,488.72 451,214,378.40 530,525,148.42 600,944,379.84 721,770,831.08 870,295,854.72 1,049,888,299.56 1,181,440,841.12 1,306,266,536.54 1,445,084,095.32 1,485,482,338.84 1,477,426,592.42 1,476,046,063.04 1,507,769,663.58 1,683,783,514.12 1,631,715,958.46 1,800,100,859.36 1,939,463,904.72 2,108,718,697.02 2,290,234,573.96 2,595,278,869.32 2,792,576,236.72 3,049,037,955.00 3,246,259,075.84 3,489,841,477.20 3,660,387,436.00 4,001,594,678.74 4,288,606,572.70 4,593,263,862.98 4,411,089,394.04 4,138,461,193.04 4,045,298,460.92 4,019,480,209.28 4,243,506,812.16 4,364,407,727.86 4,643,191,878.76 LEVY_RPT_MONTH_SUM LEVY BEGINNING MARICOPA 255,294,646.34 331.83 922.38 1,998.26 4,111.30 5,885.92 6,216.48 8,954.20 10,864.89 12,599.20 12,427.08 17,517.30 15,972.66 11,278.23 13,532.33 11,576.64 28,887.27 21,166.00 86,095.02 17,523.14 22,363.14 3,284,780.26- 8,122,159.39 7,952,626.39 2,207,553.16 3,577,213.60 1,190,791.47 1,128,169.02- 758,266.74- 78,784.46- 651,506.18- 762,045.98- 679,575.16- 572,605.45- 641,398.17 1,279,922.17- 733,570.41- 632,624.44 582,360.63 696,140.40- 558,014.80- 26,202,997.26 137,212,737.28 42,823,423.27- 20,900,791.79 1,046,963.87- 1,295,197.73 1,838,450.14 2,995,975.45 144,686,114.34 BALANCE SECURED LEVY COUNTY AND 90,514,552.03 .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 43.34 3.18 340,001.76- 348,364.76- 349,532.99- 362,027.14- 370,060.34- 357,566.73- 342,673.70- 424,102.65- 444,380.12- 682,171.49- 534,895.50- 1,015,633.92- 26,085,316.61 COLLECTIONS ACTIVITY TREASURER FOR JUL 2017 S 6,757,635.11- .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 341,373.20- 352,878.52- 351,819.14- 364,497.20- 370,765.76- 369,194.84- 353,035.02- 428,070.44- 451,497.30- 702,922.38, - 473,105.46- 1,039,237.39- 1,159,238.46- ADJUSTMENTS OFFICE 20,8, ENDING 158,022,459.20 331.83 922.38 1,998.26 4,111.30 5,885.92 6,216.48 8,954.20 10,864.89 12,599.20 12,427.08 17,517.30 15,972.66 11,278.23 13,532.33 11,576.64 28,887.27 21,166.00 86,095.02 17,523.14 22,3E3.14 3,284,780.26- 8,122,159.39 7,952,626.39 2,207,553.16 3,577,213.60 1,190,791.47 1,128,169.02- 758,266.74- 78,784.46- 651,506.18- 762,845.98- 679,575.16- 572,605.45- 641,398.17 1,279,965.51- 733,573.59- 631,253.00 577,846.87 698,426.55- 560,484.86- 26,202,291.84 87,201,109.17 42,833,784.59- 96,824.00 1,054,081.05- 1,274,446.84 1,900,240.18 2,972,371.98 47,440,959.27 BALANCE PAGE: 02-AUG-2017 1 PROGRAM TOTAL 1968 1969 1970 1971 1972 1973 1974 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 YEAR ID: APP 2,325,116,156.87 4,195,165.19 5,918,654.86 10,386,975.86 12,084,654.91 13,623,786.21 13,177,965.26 15,296,922.12 19,189,042.79 23,204,794.95 26,779,663.13 28,615,308.42 29,722,220.00 30,075,323.04 36,683,300.76 37,836,109.79 73,434,045.21 53,570,353.57 50,507,999.56 76,956,283.43 88,991,362.81 96,811,185.54 113,929,972.43 122,744,902.09 131,582,120.56 140,629,687.78 154,917,045.68 162,209,929.25 113,747,601.86 102,673,892.06 115,124,253.32 122,881,710.56 122,871,629.32 138,497,672.37 19,330,336.80 16,902,615.38 LEVY_RPT_MONTH_SUM .00 .00 LEVY BEGINNING MARICOPA 405,473,551.93- 2,320,992.14- 1,422,511.95- 433,497.42- 1,719,922.67- 2,953,558.51- 5,836,677.39- 5,472,248.17- 2,664,351.52- 2,691,654.20- 5,929,894_62- 6,812,702.12- 6,557,551.22- 17,272,723.82- 18,055,558.20- 22,905,048.43- 6,576,315.56- 12,928,887.66- 28,111,564.10- 25,772,613.27- 7,1E2,377.74- 21,536,144.42- 7,916,568.30- 950,427.40- 6,349,400.55- 17,542,008.94- 14,418,422.13- 8,107,024.00 28,750,179.12- 35,071,771.14- 22,886,206.59- 25,511,194.05- 28,449,294.15- 9,259,309.48- 872,945.15- 2,064,147.03 13,312,450.31- 197,750.52- BALANCE UNSECURED LEVY COUNTY AND 2,611.68 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 35.16 .00 .00 .00 683.83 .00 .00 .00 .00 81.26 77.37 95.87 1,638.19 -00 COLLECTIONS ACTIVITY TREASURER FOR JUL 2017 S ADJUSTMENTS .00 .00 .00 .00 .00 .00 .00 .00 .00 -30 .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 OFFICE ENDING 405,476,163.61- 2,220,992.14- 1,422,511.95- 423,497.42- 1,719,922.67- 2,953,558.51- 5,836,677.39- 5,472,248.17- 2,664,351.52- 2,691,654.20- 5,929,894.62- 6,812,702.12- 6,557,551.22- 17,272,722.82- 18,055,558.20- 22,905,048.43- 6,576,315.56- 12,928,887.66- 28,111,564.10- 25,772,613.27- 7,182,377.74- 21,536,144_42- 7,916,568.30- 950,427.40- 6,349,435.71- 17,542,008.94- 14,418,422.13- 8,107,024.00 28,750,862.95- 35,071,771.14- 22,886,206.59- 25,511,194.05- 28,449,294.15- 9,259,290-74- 873,022.52- 3,064,051.16 12,214,088.50- 197,750.52- BALANCE PAGE: 02-AUG-2017 1