Extracted text (via pymupdf_layout)
28181 characters
Royce T. Flora, Treasurer 301 West Jefferson St., Rm. 100 Phoenix, Arizona 85003 Maricopa County Phone: (602) 506-8511 Fax: (602) 506-1102 Treasurer http://treasurer.maricopa.gov DATE: October 09, 2017 TO: Denny Barney, Chairman Steve Chucri, Supervisor, District 2 Bill Gates, Supervisor, District 3 Clint Hickman, Supervisor, District 4 Steve Gallardo, Supervisor, District 5 SUBJECT: Treasurer's Collections and Investment Summary for September 2017 Secured property tax collections during the month of September equaled $346,459,901 and increased the 2017 year to date collections to $368,866,009 or 8% of the adjusted 2017 levy of $4,792,256,663. The chart below reflects the 2017 collected and uncollected levy amount and corresponding percentages for the 2017 property tax year. SEPTEMBER Uncollected Levy 2017 $4,423,390,654 92% Collected Levy $368,866,009 8% • Collected Levy • Uncollected Levy The County's General Fund Balance totaled $131,808,494.19 effective September 30, 2017. Warrants outstanding of $4,633,795.25 will post against the fund balances when presented. The $21,473,929 unencumbered balance, of the County Municipal Line of Credit and the $13,526,071 Workers Compensation Liability Letter of Credit remain unused. Submitted under oath, Royce T. Flora Maricopa County Treasurer STATE OF ARIZONA ) ss. COUNTY OF MARICOPA ) This instrument was acknowledged before me this 9th day of October 2017, by Russell K. Pearce, as Chief Deputy Treasurer of Maricopa County, State of Arizona, known to me to be the person whose name is subscribed to the foregoing instrument and who acknowledged to me that they executed the same for and on behalf of the State of Arizona for the purpose and consideration therein expressed. POiLa 01 7 Notary Public My Commission Expires KAREN D. SMITH Notary Public - Arizona Maricopa County My Comm. Expires Dec 15, 2017 Investments Portfolio Page 1 of 4 Maricopa County Treasurer Investments Portfolio Report 09/30/2017 - 142 Investments Account 10-151-156 COUNTY SCHOOL TANS Invest # Type Face Amt Mat Date Market Value MV Date Book Value Rate YTM DTM 2017000136 TANS $48,000,000 07/18/2018 $48,083,040.00 7/26/2017 $48,083,040.00 1.6700% 1.4905% 291 2017000137 TANS $35,000,000 07/18/2018 $35,060,550.00 7/26/2017 $35,060,550.00 1.6700% 1.4905% 291 2017000138 TANS $23,000,000 07/18/2018 $23,039,790.00 7/26/2017 $23,039,790.00 1.6700% 1.4905% 291 2017000139 TANS $14,000,000 07/18/2018 $14,024,220.00 7/26/2017 $14,024,220.00 1.6700% 1.4905% 291 2017000140 TANS $16,000,000 07/18/2018 $16,027,680.00 7/26/2017 $16,027,680.00 1.6700% 1.4905% 291 2017000141 TANS $10,000,000 07/18/2018 $10,017,300.00 7/26/2017 $10,017,300.00 1.6700% 1.4905% 291 2017000142 TANS $41,000,000 07/18/2018 $41,070,930.00 7/26/2017 $41,070,930.00 1.6700% 1.4905% 291 2017000143 TANS $10,000,000 07/18/2018 $10,017,300.00 7/26/2017 $10,017,300.00 1.6700°k 1.4905% 291 2017000144 TANS $3,000,000 07/18/2018 $3,005,190.00 7/26/2017 $3,005,190.00 1.6700% 1.4905% 291 2017000154 TANS $15,000,000 07/18/2018 $15,023,850.00 8/24/2017 $15,023,850.00 1.6700% 1.4910% 291 10 Acct 10-151- $215,000,000.00 $215,369,850.00 $215,369,850.00 1.490523% 291 156 Totals: Account 10-151-556 FIXED INCOME Invest # Type Face Amt Mat Date Market Value MV Date Book Value Rate VIM DTM 2014000206 FNMA $25,000,000 10/26/2017 $25,042,500.00 8/31/2016 $24,888,250.00 0.8750% 1.0299% 26 2015000132 FHLMC $25,000,000 06/22/2018 $25,152,500.00 8/31/2016 $25,077,250.00 1.250016 1.1433% 265 2015000175 FHLMC $20,000,000 06/29/2018 $20,000,000.00 8/31/2016 $20,000,000.00 1.0500% 1.0500% 272 2015000205 FHLMC $25,000,000 07/27/2018 $24,960,000.00 8/31/2016 $25,000,000.00 1.0000% 1.0000% 300 2015000206 FHLMC $25,000,000 10/29/2018 $25,012,500.00 8/31/2016 $25,000,000.00 1,1000°k 1.1000% 394 2015000207 FHLMC $15,000,000 10/29/2018 $15,007,500.00 8/31/2016 $15,000,000.00 1.1000°k 1.1000% 394 2015000208 FFCB $25,000,000 07/30/2018 $24,980,000.00 8/31/2016 $24,990,500.00 0.8750% 0.8890% 303 2015000212 FHLMC $30,000,000 08/03/2018 $30,009,000.00 8/31/2016 $30,000,000.00 1,0000% 1.0000% 307 2015000213 FNMA $35,000,000 05/03/2019 $35,014,000.00 8/31/2016 $35,000,000.00 1.2600% 1.2600% 580 2015000214 FFCB $30,000,000 08/02/2018 $30,000,000.00 8/31/2016 $30,000,000.00 1.0200°k 1.0200% 306 2015000222 FNMA $25,000,000 10/29/2018 $25,000,000.00 8/31/2016 $25,000,000.00 1.1250% 1.1250% 394 2015000223 FHLMC $15,000,000 04/26/2018 $14,997,000.00 8/31/2016 $15,000,000.00 0.9500% 0.9500% 208 2015000226 FNMA $15,000,000 11/16/2018 $14,988,000.00 8/31/2016 $14,985,000.00 1.1600% 1.1940% 412 2015000238 FHLB $20,000,000 12/28/2018 $20,040,000.00 8/31/2016 $20,000,000.00 1.3300°k 1.3300% 454 2016000038 FHLB $15,000,000 12/28/2018 $15,033,000.00 8/31/2016 $15,000,000.00 1.250016 1.2500% 454 2016000055 FHLMC $22,425,000 07/27/2018 $22,425,000.00 8/31/2016 $22,425,000.00 1.0000% 1.0000% 300 2016000082 FNMA $20,000,000 06/13/2019 $20,022,000.00 8/31/2016 $20,000,000.00 1.4000% 1.4000% 621 2016000083 FHLB $20,000,000 05/23/2018' $20,010,000.00 8/31/2016 $19,993,000.00 1.000016 1.0177% 235 2016000085 FHLB $17,000,000 06/29/2018 $17,001,700.00 8/31/2016 $16,959,030.00 0.8750% 0.991116 272 2016000086 FHLMC $25,000,000 05/24/2019 $24,895,000.00 8/31/2016 $24,970,000.00 1.3000% 1.3413% 601 2016000098 FHLMC $25,000,000 12/28/2017 $24,990,000.00 8/31/2016 $25,000,000.00 0.800016 0.8000% 89 2016000102 FNMA $20,000,000 06/28/2019 $20,000,000.00 8/31/2016 $19,984,800.00 1.2000% 1.2259% 636 2016000103 FH1MC $30,000,000 06/27/2018 $29,988,000.00 8/31/2016 $30,000,000.00 0.9100% 0.9100% 270 file:///C JUsers/Thompsonm007/App Data/Local/Temp/tmp162E.htm I 10/10/2017 Investments Portfolio Page 2 of 4 2016000104 FNMA $30,000,000 07/05/2019 $29,877,000.00 8/31/2016 $30,000,000.00 1.1400% 1.1400% 643 2016000110 FFCB $25,000,000 07/05/2019 $24,945,000.00 8/31/2016 $25,000,000.00 1.0200% 1.0200% 643 2016000111 FNMA $25,000,000 07/12/2019 $24,910,000.00 8/31/2016 $25,000,000.00 1.0500% 1.0500% 650 2016000114 FFCB $25,000,000 01/13/2020 $24,882,500.00 8/31/2016 $25,000,000.00 1.2400% 1.2400°k 835 2016000115 FNMA $25,000,000 07/26/2019 $24,820,000.00 8/31/2016 $25,000,000.00 1.0000% 1.0000% 664 2016000119 FFCB $22,090,000 01/07/2019 $22,021,521.00 8/31/2016 $22,073,432.50 1.0000% 1,0303% 464 2016000121 FHLB $20,000,000 10/11/2019 $19,902,000.00 8/31/2016 $19,978,000.00 1.1250% 1.1596% 741 2016000130 FFCB $20,000,000 03/22/2018 $19,974,000.00 8/31/2016 $20,003,400.00 0.8000% 0.7898% • 173 2016000131 FFCB $25,000,000 03/22/2018 $24,967,500.00 8/31/2016 $25,000,000.00 0.8000% 0.8000% 173 2016000134 FHLB $20,000,000 05/18/2018 $19,968,000.00 8/31/2016 $20,000,000.00 0.9000% 0.9000% 230 201.6000135 FNMA $20,000,000 07/26/2019 $19,930,000.00 8/31/2016 $20,000,000.00 1.1250% 1.1250% 664 2016000136 FFCB $26,000,000 06/27/2019 $25,950,600.00 8/31/2016 $25,997,400.00 0.9500% 0.9535% 635 2016000148 FNMA $20,000,000 01/28/2020 $19,930,000.00 8/31/2016 $20,000,000.00 1.3300% 1.3300% 850 2016000149 FHLB $14,435,000 04/26/2019 $14,400,356.00 8/31/2016 $14,435,000.00 1.1000% 1.1000°k 573 2016000150 FHLB $5,565,000 04/26/2019 $5,551,644.00 8/31/2016 $5,565,000.00 1,1000% 1.1000°/o 573 2016000157 FNMA $30,000,000 08/16/2019 $29,934,000.00 8/31/2016 $30,000,000.00 1.2000% 1.2000% 685 2016000158 FNMA $20,000,000 08/23/2019 $19,978,000.00 8/31/2016 $20,000,000.00 1.2500% 1.2500% 692 2016000164 FHLMC $20,000,000 09/21/2018 $20,000,000.00 9/8/2016 $20,000,000.00 1.0000% 1.0000% 356 2016000166 FNMA $20,000,000 09/15/2020 $20,000,000.00 9/9/2016 $20,000,000.00 1.4500% 1.4500% 1081 2016000173 FNMA $25,000,000 10/17/2019 $275,000.00 10/6/2016 $24,946,250.00 1.1000% 1.1732% 747 2016000176 FNMA $30,000,000 10/17/2019 $30,000,000.00 10/6/2016 $30,000,000.00 1.2300% 1.2300°k 747 • 2016000180 FNMA $25,000,000 07/27/2020 $25,000,000.00 10/7/2016 $25,000,000.00 1.4000% 1.4000% 1031 2016000191 FNMA $30,000,000 10/27/2020 $30,000,000.00 10/11/2016 $30,000,000.00 1,4050% 1.4050% 1123 2016000194 FFCB $13,073,000 01/28/2019 $13,073,000,00 10/12/2016 $13,073,000.00 1.2700% 1.2700°/a 485 2016000195 FHLMC $30,000,000 11/02/2020 $30,000,000.00 10/12/2016 $30,000,000.00 1.3650% 1.3650% 1129 2016000196 FHLMC $25,000,000 10/26/2018 $25,000,000.00 10/12/2016 $25,000,000.00 1.0500% 1.0500°k 391 2016000198 FHLMC $30,000,000 11/02/2018 $30,000,000.00 10/18/2016 $30,000,000.00 0,9300% 0.9300% 398 2016000200 FNMA $17,965,000 10/28/2019 $17,960,508.75 10/19/2016 $17,960,508.75 1.2500% 1.2585% 758 2016000201 FNMA $18,910,000 09/30/2019 $18,905,272.50 10/19/2016 $18,905,272.50 1.2500% 1.2587% 730 2016000206 FNMA $25,000,000 07/28/2020 $25,000,000.00 10/24/2016 $25,000,000.00 1.3000% 1.3000% 1032 2016000209 FNMA $20,000,000 07/28/2020 $20,000,000.00 10/25/2016 $20,000,000.00 1.3500% 1.3500% 1032 2016000212 FHLMC $20,000,000 11/27/2019 $20,000,000.00 10/27/2016 $20,000,000.00 1.3000°k 1.3000% 788 2016000215 FHLMC $20,000,000 11/10/2020 $20,000,000.00 10/27/2016 $20,000,000.00 1.4000% 1.4000% 1137 2016000233 FHLMC $20,000,000 11/27/2019 $20,000,000.00 11/9/2016 $20,000,000.00 1.3000% 1.3000% 788 2016000237 FFCB $25,000,000 12/05/2018 $25,000,000.00 11/18/2016 $24,975,355.25 1.1000% 1.1497% 431 2016000238 FNMA $25,000,000 11/26/2019 $25,000,000,00 11/22/2016 $25,000,000.00 1 . 5000°/o 1.5000% 787 2016000239 FNMA $15,000,000 05/26/2020 $15,000,000.00 11/23/2016 $15,000,000.00 1.6250% 1.6250% 969 2016000241 FHLMC $25,000,000 12/13/2019 $25,000,000.00 11/15/2016 $25,000,000.00 1.5100% 1.5100% 804 2016000243 FNMA $20,000,000 06/29/2020 $20,000,000.00 12/14/2016 $20,000,000.00 1.7500% 1.7500% 1003 2016000245 FNMA $25,000,000 01/17/2020 $25,000,000.00 12/22/2016 $25,000,000.00 1.7500% 1.7500% 839 2017000004 FNMA $30,000,000 01/27/2020 $30,000,000.00 1/6/2017 $30,000,000.00 1.7000% 1.7000% 849 2017000007 FHLB $10,000,000 07/30/2020 $10,000,000.00 1/12/2017 $10,000,000.00 1 . 7500°/o 1.7500% 1034 2017000017 FHLMC $15,000,000 05/25/2018 $14,998,500.00 2/9/2017 $14,998,500.00 1.0000% 1.0078% 237 2017000047 FHLMC $10,000,000 03/27/2020 $170,000.00 3/27/2017 $10,000,000.00 1.7000% 1.7000% 909 2017000048 FH LMC $25,000,000 07/11/2019 $25,000,000.00 3/28/2017 $25,000,000.00 1.5000% 1.5000% 649 2017000059 FHLMC $20,000,000 01/26/2021 $20,000,000.00 4/18/2017 $20,000,000.00 1.7500% 1.7500% 1214 2017000060 FFCB $25,000,000 05/21/2018 $24,999,750.00 4/18/2017 $24,994,500.00 1.1000% 1.1203% 233 file:///C:/Users/Thompsonm007/AppData/Local/Temp/tmp162E.html 10/10/2017 Investments Portfolio Page 3 of 4 FHLMC $20,000,000 05/15/2020 $20,000,000.00 4/18/2017 $20,000,000.00 1.7000% 1.7000% 958 2017000067 FHLMC $25,000,000 08/16/2019 $25,000,000.00 4/24/2017 $25,000,000.00 1.5000% 1.5000% 685 2017000070 FHLB $25,000,000 07/26/2619 $24,963,250.00 4/26/2017 $24,963,250.00 1.3750% 1.4417% 664 2017000074 FHLMC $.2?5,000,000 05/11/2018 $24,946,000.00 4/27/2017 $24,946,000.00 1.0000% 1.2078% 223 2017000079 FHLB $30,000,000 02/03/2020 $30,000,000.00 4/28/2017 $30,000,000.00 1.6000% 1.6000% 856 2017000091 FHLMC $30,000,000 08/17/2020 $30,000,000.00 5/3/2017 $30,000,000.00 1.7000 0/0 1.7000% 1052 2017000095 FHLMC $25,000,000 05/18/2020 $25,000,000.00 5/5/2017 $25,000,000.00 1.7000% 1.7000% 961 2017000096 FFC8 $12,250,000 05/17/2021 $12,250,000.00 5/5/2017 $12,250,000.00 1.9700% 1.9700% 1325 2017000113 FHLMC $20,000,000 12/27/2019 $20,000,000.00 6/28/2017 $20,000,000.00 1.5500% 1.5500% 818 2017000114 FHLB $25,000,000 06/29/2020 $25,000,000.00 6/28/2017 $25,000,000.00 1.6900% 1.6900% 1003 2017000122 FHLMC $30,000,000 08/07/2020 $30,000,000.00 7/6/2017 $30,000,000.00 1.8500% 1.8500% 1042 2017000123 FHLMC $30,000,000 07/19/2019 $30,000,000.00 7/6/2017 $30,000,000.00 1.5000% 1.5000°/0 657 2017000149 FHLMC $25,000,000 04/13/2020 $25,023,750.00 8/7/2017 $25,167,500.00 1.8000% 1.7634% 926 2017000150 FHLB $15,000,000 06/26/2020 $14,981,100.00 8/8/2017 $15,010,214.58 1.6250% 1.6702% 1000 2017000100 FHDN $13,600,000 11/15/2017 $13,528,838.00 5/16/2017 $13,528,838.00 1.0350% 1.0549% 46 2017000109 FMCDN $35,000,000 10/13/2017 $34,869,406.25 5/31/2017 $34,869,406.25 0,9950% 1.0126% 13 2017000116 FHDN $45,000,000 06/27/2018 $44,460,037.50 7/3/2017 $44,460,037.50 1.2100% 1.2417% 270 2017000117 FMCDN $45,000,000 05/29/2018 $44,516,200.00 7/5/2017 $44,516,200.00 1.1800% 1.2094% 241 2017000120 FHDN $15,000,000 12/29/2017 $14,917,133.33 7/6/2017 $14,917,133.33 1.1300% 1.1521% 90 2017000126 FNDN $35,000,000 10/23/2017 $34,894,854.17 7/7/2017 $34,894,854.17 1.0300% 1.0475% 23 2017000127 FHDN $30,000,000 10/06/2017 $29,920,754.17 7/7/2017 $29,920,754.17 1.0450% 1.0623% 6 2017000128 FCDN $40,000,000 06/27/2018 $39,507,200.00 7/10/2017 $39,507,200.00 1.2600% 1.2934% 270 2017000129 FMCDN $40,000,000 05/31/2018 $39,573,400.00 7/10/2017 $39,573,400.00 1.1850% 1.2144% 243 2017000130 FHDN $35,000,000 12/29/2017 $34,818,787.50 7/10/2017 $34,818,787.50 1.0900% 1.1109% 90 2017000133 FHDN $30,000,000 12/26/2017 $29,850,600.00 7/12/2017 $29,850,600.00 1.0800% 1.1005% 87 2017000135 FCDN $25,000,000 12/27/2017 $24,878,541.67 7/21/2017 $24,878,541.67 1.10000/0 1.1207% 88 2017000155 FHDN $20,000,000 12/29/2017 $19,946,588.89 9/27/2017 $19,946,588.89 1.0450% 1.0624% 90 2017000156 FHDN $25,000,000 12/29/2017 $24,933,236.11 9/27/2017 $24,933,236.11 1.0450% 1.0624% 90 2015000235 Mote $30,000,000 12/31/2017 $30,003,000.00 8/31/2016 $29,852,343.75 0.7500% 0.9872% 92 2015000241 TNote $20,000,000 12/31/2017 $20,066,000.00 8/31/2016 $19,972,656.25 1.0000% 1.0684% 92 2016000160 TNote $25,000,000 12/15/2018 $25,225,000.00 8/31/2016 $25,250,976.56 1,2500% 0.8043% 441 2016000230 TNote $30,000,000 06/30/2018 $29,927,343.75 11/7/2016 $29,927,343.75 0.6250% 0.7738% 273 2017000006 TNote $25,000,000 06/30/2019 $25,169,921.88 1/10/2017 $25,169,921.88 1.6250% 1.3421°/0 638 2017000089 TNote $30,000,000 06/30/2020 $30,105,468.75 5/3/2017 $30,105,468.75 1.6250% 1.4995% 1004 2017000094 TNote $25,000,000 05/15/201.9 $24,777,343.75 5/5/2017 $24,777,343.75 0.8750% 1.3224% 592 105 Acct 10-151- 82,513,313,000.00 $2,474,945,607.97 $2,510,187,045.86 1.238520% 538 556 Totals: Account 10-151-567 COUNTY SCHOOL BONDS Invest # Type Face Amt Mat Date Market Value MV Date Book Value Rate YTM DTM 2013000162 SDPB $75,000 01/01/2018 $89,799.75 5/15/2013 $89,799.75 5.2300% 0.8615% 93 2013000167 SDPB $4,190,000 01/01/2018 $5,100,696,50 5/15/2013 $5,100,696.50 5.6500% 0.8424% 93 2013000175 SDPB $4,530,000 01/01/2018 $4,820,690.10 5/17/2013 $4,820,690.10 2.3000% 0.8768% 93 2013000187 SDPB $8,600,000 01/01/2018 $9,656,252.00 5/23/2013 $9,656,252.00 3.6500% 0.9123% 93 2013000206 SDPB $370,000 01/01/2018 $411,636.10 6/5/2013 $411,636.10 3.6200% 1.0747% 93 2013000241 SDPB $235,000 07/01/2018 $237,876.40 7/24/2013 $237,876.40 1.9800% 1.7146% 274 2013000289 SDPB $16,775,000 07/01/2018 $16,862,062.25 10/1/2013 $16,862,062.25 1.9750% 1.8576% 274 2014000091 SDPB $3,000,000 07/01/2018 $3,000,000.00 5/1/2014 $3,000,000.00 1.6300% 1.6300% 274. file:///ClUsers/Thompsonm007/AppData/Local/Temp/tmp162E.html 10/10/2017 Investments Portfolio Page 4 of 4 2014000131 SDPB $135,000 07/01/2018 $138,221.10 7/3/2014 $138,221.10 2.2900% 1.6616% 274 2014000132 SDPB $370,000 07/01/2019 $375,072.70 7/3/2014 $375,072.70 2.2900% 1.9921% 639 2015000073 SDPB $1,500,000 07/01/2018 $1,500,000,00 5/12/2015 $1,500,000.00 1.2700% 1.2700% 274 2015000074 SDPB $3,000,000 07/01/2019 $3,000,000.00 5/12/2015 $3,000,000.00 1.5700% 1.5700% 639 2016000168 SDPB $2,025,000 07/01/2020 $2,190,888.00 9/1/2016 $2,190,888.00 3.5700% 1.3245% 1005 2016000169 SDPB $4,130,000 07/01/2021 $4,532,881.50 9/1/2016 $4,532,881.50 3.5700% 1.4191% 1370 2016000181 SDPB $1,040,000 07/01/2018 $1,040,000.00 10/6/2016 $1,040,000.00 1.0300 0/0 1.0300% 274 2016000182 SDPB $1,030,000 07/01/2019 $1,030,000.00 10/6/2016 $1,030,000.00 1.1300% 1.1300% 639 2016000183 SDPB $1,650,000 07/01/2020 $1,650,000.00 10/6/2016 $1,650,000.00 1.3000% 1.3000% 1005 2016000184 SDPB $1,355,000 07/01/2021 $1,355,000.00 10/6/2016 $1,355,000.00 1.4200% 1.4200% 1370 2016000185 SDPB $210,000 07/01/2018 $217,028.70 10/6/2016 $217,028.70 3.0000% 1.0434% 274 2016000186 SDPB $215,000 07/01/2019 $225,734.95 10/6/2016 $225,734.95 3,0000% 1.1315°/0 639 2016000187 SDPB $1,045,000 07/01/2020 $1,166,011.00 10/6/2016 $1,166,011.00 4.5000% 1.2818% 1005 2016000188 SDPB $1,095,000 07/01/2021 $1,095,000.00 10/6/2016 $1,095,000.00 1.4200% 1.4200% 1370 22 Acct 10-151- $56,575,000.00 $59,694,851.05 $59,694,851.05 1.37948806 435 567 Totals: Account 32-001-534 MIES MAIN DEPOSITORY Invest # Tyne Face Amt Mat Date Market Value MV Date Book Value Rate YTM DTM 2017000147 FHDN $50,300,000 02/02/2018 $50,009,517.50 7/27/2017 $50,009,517.50 1.1000% 1.1218% 125 1 Acct 32-001-534 $50,300,000.00 $50,009,517.50 $50,009,517.50 1.121756% 125 Totals: Account 32-535-534 MIHS MCOPA HEALTH PLAN Invest # Type Face Amt Mat Date Market Value MV Date Book Value Rate YTM DTM 2017000098 FFCB $12,400,000 11/01/2018 $12,391,444.00 5/16/2017 $12,398,332.89 1.2500% 1.2975% 397 2017000104 FFCB $13,300,000 11/26/2018 $13,292,818.00 5/18/2017 $13,292,818.00 1.2200% 1.2561% 422 2017000099 FHDN $6,400,000 11/15/2017 $6,366,512.00 5/16/2017 $6,366,512.00 1.0350% 1.0549% 46 3 Acct 32-535-534 $32,100,000.00 $32,050,774.00 $32,057,662.89 1.231972% 337 Totals: Account 32-700-534 MIHS DEBT INTEREST & REDEMPTION FUND Invest # Type Face Amt Mat Date Market Value MV Date Book Value Rate YTM DTM 2017000105 TNote $3,200,000 06/15/2018 $3,198,875.00 5/19/2017 $3,198,875.00 1.1250% 1.1528% 258 1 Acct 32-700-534 $3,200,000.00 $3,198,875.00 $3,198,875.00 1.152830% 258 Totals: Report Totals: $2,870,488,000.00 $2,835,269,475.52 $2,870,517,802.30 1.2579590/0 508 file:///ClUsers/Thompsonm007/AppData/Local/Temp/tmp162E.html 10/10/2017 653 29-SEP-2017 PAGE: 30-SEP-2017 OFFICE 592 32 1,441 522 15 18 158 143 301 4 35 39 96 184 280 836 804 1,640 122 101 223 139 223 370 3 75 78 28 79 107 6 139 145 821 821 266 S - 11,740 14,360 FUND by TREASURER DISTRICT COUNT Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: - WARRANTS AMOUNT 7,213.79 339,021.61 38,048.57 4,595,746.68 269,243.49 18,568.02 13,271.21 5,281,113.37 93,996.05 823,170.02 907,166.07 2,675.13 79,191.55 81,866.68 66,640.38 485,333.41 551,973.79 3,213,618.63 3,370,877.17 6,584,495.80 95,798.24 558,019.19 653,817.43 68,781.95 344,308.53 709,457.68 1,122,548.16 3,267.38 123,745.42 127,012.80 15,032.95 141,127.15 156,160.10 2,958.35 212,047.28 215,005.63 3,229,386.04 3,229,386.04 247,533.07 COUNTY WARRANT OUTSTANDING MARICOPA = - = = = - = - = = = = = = = = = = = = = = = = -- - = = = = = = = - = = = = = NUMBER Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total WARRANT Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund OTSTND_WT_FUND District District District District District District District District District District District DISTRICT 000 000 000 000 000 000 000 000 001 001 001 002 002 002 003 003 003 004 004 004 005 005 005 006 006 006 006 007 007 007 008 008 008 009 009 009 011 011 014 WTR ID: FUND 066 714 766 768 781 945 950 030 040 030 040 030 040 030 040 030 040 030 035 040 030 040 030 040 030 040 040 030 PROGRAM 2 03-OCT-2017 PAGE: Closing Balance 91,214.57 111,373.11 170,801,96 123,393.78 73,261.70 131,620.79 2,510,951.83 14,424,309.85 891,767.07 37,469.91- 3,747.35 11,296.56 22,155.04 398.55 309,599.86 1,550,240.39 1.00 5,561,752.68 130,147.66 66,752.63- 247,138.42 235,551.01 99,222.10 5,958.83 22,306,431.40 455,970.85 749,950.84 1,389,446.88 2,397,484.72 36,263,708.67 131,808,494.19 131,808,494.19 196,578.60- Disbursements 5,388,568.53 1,327,135.74 1,484.61 962,272.26 27,460.73- 39,557.20 7,691,557.91 2,999.96 2,999.96 TO 416.14 486.17 458.22 255.70 356.21 17,066.23 .99 1,466.82 12,429.23 1,241,972.25 509.55 300.00 4,070.06 54,412.68 1,315,161.58 96,114,343.00 96,114,348.00 190,343.14 Transfer OFFICE From 49,047.15 1.39 733.41 138.70 347,956,089.50 7,306,257.02 1,350.00 2,335.03 1,029,410.36 356,345,362.56 91,100,617.65 91,100,617.65 297,904.61 2017 TREASURER'S SEP, of Month the Income Distribution 380,598.73- 18,760.12- 16,373.02- 14,496.26- 8,711.87- 30,032.01- 617,217.88- 83,890.52- 5,437,615.58 167,649.88 5,497.33.- 504,497.54- 10,024.95- 398.55 2,142.00 1,297,608.14 347,729,176.55 1,419,210.85 88,701.52 3,092.88 1,369,212.24 457,729.24 640,872.61 694,833.93- 357,407,756.11 47,698,777.46 47,698,777.45 COUNTY for Report ARICORA Treasurer's Opening Balance 471,783.30 129,722.09 186,688.81 137,431.81 81,717.87 161,299.59 3,123,169.49 14,491,133.94 723,917.19 31,971.40- 508,244.89 10,563.15 32,179.99 295,028.63 1,550,240.39 1.00 5,581,752.68 159,813.96 1,101,842.03- 5,887,046.17 246,628.97 235,551.01 10,220.58 4,250.56 21,900,841.42 1,756.39- 722,190.11 737,839.04 4,106,873.33 41,577,711.15 79,098,986.34 79,098,986.34 89,017.33- M SERVICE 2149 REFUNDS SALES UNKNOWN SCHOOL CC VALLEY CC JO CC MEADOWS PROCESSING RESOLUTIONS HOLDING HS FUND INVESTMENT HOLD COLLECTIONS INCOME NON-DELIVERABLE TRUSTEE OR APPR BE COMPANIES DeSCriptiOD CT JuvaILE SERVICES PENDERGAST NORTH TEMPE WEST DESERT RIDGE CC HIGHLAND COUNTRY REVENUE HOLDING DEBITS/CREDITS HOLDING PENDING ASSIGN WITHHOLDING INFORMATION IMPOUNDS HOLDING CONVERSION - ASSISTANCE ASSISTANCE HOLDING TAX INTEREST ACT FOR HOLDING HOLDING REFUNDING FROM WIRES TO MONEY CASHIER'S MORTGAGE CHARGE PONDS WAREHOUSE ACCT ENVIR AC= ACCT ACCOUNT ACCOUNT ACCT ACCT ACCOUNT ACCT CLEARING CLEARING REFUND TAX CASHIER'S RESOLUTION LITIGATION AND SURTAX INTEREST TAXPAYER RESOLUTION PENALTY COURSE HOLDING ELDERLY ELDERLY REDEMPTION UNDISTRIBUTED UNDISTRIBUTED GRAZING TAYLOR FUND TRUST CHECK PROBLEM TAX CURRENT FEE RECORDER PROCEEDS EXCESS UNIDENTIFIED FD RLD SUSPENSE SUSPENSE SERVICE SUSPENSE-PREPAYMENTS SUSPENSE maps GENERAL GENERAL COUNTY SHERIFF FUND_EAL_MTD DEP DES DES DEP DEP DEP DEP DEp DEP DES BACK IRS UPPS CIVIL GOLF GPLET TEMP BANK TRESS ACC ID: Account NuMber 30-025-184 30-025-185 30-025-136 30-025-187 30-025-188 30-025-189 30-025-190 30-025-191 30-025-199 1 - Total 30-026-000 30-027-000 30-028-000 30-033-000 30-034-000 30-035-000 30-026-000 30-041-000 30-042-000 30-043-000 30-044-000 30-045-000 30-048-000 30-049-000 30-050-000 30-059-000 30-060-000 30-061-000 30-062-000 30-063-000 30-064-000 30-066-000 30-077-000 30-086-000 20-090-000 30-091-000 30-092-000 30-093-000 30-094-000 30-099-000 1 - Total 30-100-000 1 - Total 00 0-0 12 31- Program 1 03-OCT-2017 PAGE: BALANCE 4,423,390,654.03 35,514,363.85 3,514,737.10 1,762,694.62 1,260,896.37 1,061,586.41- 20,885,710.11 42,843,440.07- 87,191,419.53 26,193,803.23 563,773.53- 705,551.71- 577,196.39 631,066.16 733,659.05- 1,279,965.51- 641,280.31 572,605.45- 679,575.16- 762,845.98- 651,506.18- 78,784.46- 758,266.74- 1,128,169.02- 1,190,791.47 3,577,213.60 2,207,553.16 7,952,626.39 8,122,159.39 3,284,780.26- 22,363.14 17,523.14 86,095.02 21,166.00 28,887.27 11,576.64 13,532.33 11,278.23 15,972.66 17,517.30 12,427.08 12,599.20 10,864.89 8,954.20 6,216.48 5,885.92 4,111.30 1,998.26 922.38 331.83 4,569,819,879.45 ENDING OFFICE 270,627.43- 94,001.12- 210.03- 192.37- 186.73- 68.91- 65.02- 59.77- 374.94- 431.98- 33.26- 31.26- .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 ADJUSTMENTS 669,606.06 3,395,935.00- 3,092,611.76- 2017 SEP TREASURER'S FOR ACTIVITY 940,828.95- 64,267.59- 5,708.13 1,913.51 2,759.93 4,422.32 4,716.92 4,953.38 132.68 4,652.24 94.70 27.56 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 COLLECTIONS 346,459,901.26 1,969,125.80 247,453,311.89 AND COUNTY LEVY SECURED BALANCE 4,769,180,949.23 40,879,424.65 2,844,535.58 1,792,428.15 1,266,814.53 1,059,480.53- 20,888,656.77 42,838,948.84- 87,196,201.47 26,198,816.38 563,265.91- 700,467.49- 577,324.35 631,124.98 733,659.05- 1,279,965.51- 641,280.31 572,605.45- 679,575.16- 762,845.98- 651,506.18- 78,784.46- 758,266.74- 1,128,169.02- 1,190,791.47 3,577,213.60 2,207,553.16 7,952,626.39 8,122,159.39 3,284,780.26- 22,363.14 17,523.14 86,095.02 21,166.00 28,887.27 11,576.64 13,532.33 11,278.23 15,972.66 17,517.30 12,427.08 12,599.20 10,864.89 8,954.20 6,216.48 5,885.92 4,111.30 1,998.26 922.38 331.83 4,920,365,803.10 MARICOPA BEGINNING LEVY LEVY_RPT_MONTH_SUM 4,791,587,056.58 4,643,191,878.76 4,364,407,727.86 4,243,506,812.16 4,019,480,209.28 4,045,298,460.92 4,138,461,193.04 4,411,089,394.04 4,593,263,862.98 4,288,606,572.70 4,001,594,678.74 3,660,387,436.00 3,489,841,477.20 3,246,259,075.84 3,049,037,955.00 2,792,576,236.72 2,595,278,869.32 2,290,234,573.96 2,108,718,697.02 1,939,463,904.72 1,800,100,859.36 1,631,715,958.46 1,683,783,514.12 1,507,769,663.58 1,476,046,063.04 1,477,426,592.42 1,485,482,338.84 1,445,084,095.32 1,306,266,536.54 1,181,440,841.12 1,049,888,299.56 870,295,854.72 721,770,831.08 600,944,379.84 530,525,148.42 451,214,378.40 402,942,488.72 373,230,675.34 382,783,606.36 365,594,731.04 360,443,065.88 332,481,242.68 294,189,512.68 251,690,646.52 224,585,828.94 191,805,552.44 165,623,012.50 138,694,628.82 126,692,073.74 116,414,184.58 95,659,212,677.90 APP ID: YEAR 2017 2016 2015 2014 2013 2012 2011 2010 2009 2008 2007 2006 2005 2004 2003 2002 2001 2000 1999 1998 1997 1996 1995 1994 1993 1992 1991 1990 1989 1988 1987 1986 1985 1984 1983 1982 1981 1980 1979 1978 1977 1976 1975 1974 1973 1972 1971 1970 1969 1968 TOTAL PROGRAM 1 03-OCT-2017 PAGE: BALANCE 197,750.52- 13,314,700.48- 3,063,385.19 873,719.66- 9,260,219.88- 28,449,736.93- 25,511,216.65- 22,886,230.37- 35,071,800.42- 28,750,866.17- 8,107,024.00 14,418,422.22- 17,542,008.94- 6,349,435.71- 950,427.40- 7,916,568.30- 21,536,144.42- 7,182,377.74- 25,772,613.27- 28,111,564.10- 12,928,887.66- 6,576,315.56- 22,905,048.43- 18,055,558.20- 17,272,723.82- 6,557,551.22- 6,812,702.12- 5,929,894.62- 2,691,654.20- 2,664,351.52- 5,472,248.17- 5,836,677.39- 2,953,558.51- 1,719,922.67- 433,497.42- 1,422,511.95- 2,320,992.14- 405,479,489.59- ENDING OFFICE .00 32.55- 27.68- 30.36- 24.21- 22.35- .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 137.15- 2017 ADJUSTMENTS SEP TREASURER'S FOR ACTIVITY .00 17.51 28.28 24.56 37.16 22.34- .00 .00 3.39 3.22 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 91.78 COLLECTIONS AND COUNTY LEVY UNSECURED BALANCE 197,750.52- 13,314,650.42- 3,063,441.15 873,664.74- 9,260,158.51- 28,449,736.92- 25,511,216.65- 22,886,230.37- 35,071,797.03- 28,750,862_95- 8,107,024.00 14,418,422.22- 17,542,008.94- 6,349,435.71- 950,427.40- 7,916,568.30- 21,536,144.42- 7,182,377.74- 25,772,613.27- 28,111,564.10- 12,928,887.66- 6,576,315.56- 22,905,048.43- 18,055,558.20- 17,272,723.82- 6,557,551.22- 6,812,702.12- 5,929,894.62- 2,691,654.20- 2,664,351.52- 5,472,248.17- 5,836,677.39- 2,953,558.51- 1,719,922.67- 433,497.42- 1,422,511.95- 2,320,992.14- 405,479,260.66- MARICOPA BEGINNING LEVY .00 .00 LEVY_RPT_MONTH_SUM 16,903,615.38 19,330,396.80 138,497,672.37 122,871,629.32 122,881,710.56 115,134,253.32 102,673,892.06 113,747,601.86 162,209,939.25 154,917,045.68 140,629,687.78 131,582,120.56 122,744,902.09 113,929,972.43 96,811,185.34 88,991,362.81 76,956,283.43 50,507,999.56 53,570,953.57 73,434,045.21 37,836,109.79 36,683,300.76 30,075,323.04 29,722,220.00 28,615,308.42 26,779,663.13 23,204,794.95 19,189,042.79 15,296,922.12 13,177,965.26 13,623,786.21 12,084,654.91 10,386,975.86 5,918,654.86 4,195,165.19 2,325,116,156.87 APP ID: YEAR 2004 2003 2002 2001 2000 1999 1998 1997 1996 1995 1994 1993 1992 1991 1990 1989 1988 1987 1986 1985 1984 1983 1982 1981 1980 1979 1978 1977 1976 1975 1974 1973 1972 1971 1970 1969 1968 TOTAL PROGRAM