Extracted text (via pymupdf_layout)
34021 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: March 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 February 2018 Secured property tax collections during the month of February equaled $14,676,484 and increased the 2018 year to date collections to $2,770,266,584 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. FEBRUARY 2018 Uncollected Levy $2,005,703,486 Mb 42% Collected Levy $2,770,266,584 58% U Collected Levy • Uncollected Levy The County's General Fund Balance totaled $274,843,148.17 effective February 28, 2018. Warrants outstanding of $5,482,221.43 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. Sultnnyed under oath, 4`,--- fklisti K. Pearce Chief Deputy Treasurer STATE OF ARIZONA ) ss. COUNTY OF MARICOPA ) This instrument was acknowledged before me this 7th day of March 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. ite Notary Public My Commission Expires KAREN 0 SMITH 1. Nolary Maricopa Public County —Arizona My ComnOes Dec 15, 74,4 Investments Portfolio Page 1 of 5 Maricopa County Treasurer Investments Portfolio Report 02/28/2018 - 179 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% 140 2017000137 TANS $20,000,000 07/18/2010 $20,034,600.00 7/26/2017 $20,034,500.00 1.6700% 0.7760°,6 140 2017000138 TANS $23,000,000 07/18/2018 $23,039,790.00 7/26/2017 $23,039,790.00 1, 6700% 1.4905% 140 20170001.39 TANS $14,000,000 07/18/2018 $14,024,220.00 7/26/2017 $14,024,220.00 1.6700°k 1.4905% 140 2017000141 TANS $10,000,000 07/18/2018 $10,017,300.00 7/26/2017 $10,017,300.00 1.6700% 1.4905% 140 2017000142 TANS $41,000,000 07/18/2018 $41,070,930.00 7/26/2017 $41,070,930.00 1,6700% 1.4905% 140 2017000143 TANS $10,000,000 07/18/2018 $10,017,300.00 7/26/2017 $10,017,300.00 1.6700% 1.4905% 140 2017000144 TANS $3,000,000 07/18/2018 $3,005,190.00 7/26/2017 $3,005,190.00 1.6700% 1,4905°/a 140 8 Acct 10-151-156 $169,000,000.00 $169,292,370.00 $169,292,370.00 1.405936% 140 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°/a 1.5500% 975 2017000241 FHLMC $15,000,000 11/17/2020 $15,000,000.00 10/25/2017 $15,000,000.00 1.5000% 1.5000% 993 2017000242 FHLMC $13,000,000 11/17/2020 $13,000,000.00 10/30/2017 $13,000,000.00 1.5000% 1.5000% 993 2017000243 FHLMC $25,000,000 11/24/2020 $25,000,000.00 11/7/2017 $25,000,000.00 1.5000% 1.5000% 1000 2017000244 FHLMC $25,000,000 11/24/2020 $25,000,000.00 11/1/2017 $25,000,000.00 1.5000% 1.5000% 1000 2017000248 FHLMC $25,000,000 11/27/2020 $25,000,000.00 11/1/2017 $25,000,000.00 1.5000% 1,5000% 1003 2017000256 FHLMC $25,000,000 11/25/2020 $25,000,000.00 11/2/2017 $25,000,000.00 1.6000% 1,6000% 1001 2018000006 FHLMC $30,000,000 01/26/2021 $30,000,000.00 1/1/2018 $30,000,000.00 1.8750% 1.8750% 1063 2018000007 FNMA $25,000,000 01/26/2021 $25,000,000.00 1/10/2018 $25,000,000.00 1.8000% 1.8000% 1063 2018000008 FHLB $12,000,000 01/29/2021 $12,000,000.00 1/17/2018 $12,000,000.00 2.0500% 2.0500% 1066 2015000132 FHLMC $25,000,000 06/22/2018 $25,152,500.00 8/31/2016 $25,077,250.00 1.2500% 1.1433% 114 2015000175 FHLMC $20,000,000 06/29/2018 $20,000,000.00 8/31/2016 $20,000,000.00 1.0500% 1.0500% 121 2015000205 FHLMC $25,000,000 07/27/2018 $24,960,000.00 8/31/2016 $25,000,000.00 1.0000% 1.0000% 149 2015000206 FHLMC $25,000,000 10/29/2018 $25,012,500.00 8/31/2016 $25,000,000,00 1.1000% 1.1000% 243 2015000207 FHLMC $15,000,000 10/29/2018 $15,007,500.00 8/31/2016 $15,000,000.00 1.1000% 1.1000% 243 2015000208 FFCB $25,000,000 07/30/2018 $24,980,000.00 8/31/2016 $24,990,500.00 0.8750% 0.8890% 152 2015000212 FHLMC $30,000,000 08/03/2018 $30,009,000.00 8/31/2016 $30,000,000.00 1.0000% 1.0000% 156 2015000213 FNMA $35,000,000 05/03/2019 $35,014,000.00 8/31/2016 $35,000,000.00 1.2600% 1.2600% 429 2015000214 FFCI3 $30,000,000 08/02/2018 $30,000,000.00 8/31/2016 $30,000,000.00 1.0200% 1.0200% 155 2015000222 FNMA $25,000,000 10/29/2018 $25,000,000.00 8/31/2016 $25,000,000.00 1.1250% 1.1250% 243 2015000223 FHLMC $15,000,000 04/26/2018 $14,997,000.00 8/31/2016 $15,000,000.00 0.9500% 0.9500% 57 2015000226 FNMA $15,000,000 11/16/2018 $14,988,000.00 8/31/2016 $14,985,000.00 1.1600% 1.1940% 261 2015000238 FHLB $20,000,000 12/28/2018 $20,040,000.00 8/31/2016 $20,000,000.00 1.3300% 1.3300% 303 2016000038 FHLB $15,000,000 12/28/2018 $15,033,000.00 8/31/2016 $15,000,000.00 1.2500% 1.2500% 303 2016000055 FHLMC $22,425,000 07/27/2018 $22,425,000.00 8/31/2016 $22,425,000.00 1,0000% 1.0000% 149 file:///ClUsers/Thompsonm007/AppData/Local/Temp/tmpC162.html 3/2/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% 470 2016000083 FHLB $20,000,000 05/23/2018 $20,010,000.00 8/31/2016 $19,993,000.00 1.0000% 1.0177% 84 2016000085 FHLB $17,000,000 06/29/2018 $17,001,700.00 8/31/2016 $16,959,030.00 0.8750% 0.9911% 121 2016000086 FHLMC $25,000,000 05/24/2019 $24,895,000.00 8/31/2016 $24,970,000.00 1.3000% 1.3413% 450 2016000102 FNMA $20,000,000 06/28/2019 $20,000,000.00 8/31/2016 $19,984,800.00 1.2000°k 1.2259% 485 2016000103 FHLMC $30,000,000 06/27/2018 $29,988,000.00 8/31/2016 $30,000,000.00 0.9100% 0:9100% 119 2016000104 FNMA $30,000,000 07/05/2019 $29,877,000,00 8/31/2016 $30,000,000.00 1.1400% 1.1400% 492 2016000110 FFCB $25,000,000 07/05/2019 $24,945,000.00 8/31/2016 $25,000,000.00 1.0200% 1.0200% 492 2016000111 FNMA $25,000,000 07/12/2019 $24,910,000.00 8/31/2016 $25,000,000.00 1.0500% 1.0500% 499 2016000114 FFCB $25,000,000 01/13/2020 $24,882,500.00 8/31/2016 $25,000,000,00 1.2400% 1.2400% 684 2016000115 FNMA $25,000,000 07/26/2019 $24,820,000.00 8/31/2016 $25,000,000.00 1.0000% 1.0000% 513 2016000119 FFCB $22,090,000 01/07/2019 $22,021,521.00 8/31/2016 $22,073,432.50 1.0000°k 1.0303% 313 2016000121 FHLB $20,000,000 10/11/2019 $19,902,000.00 8/31/2016 $19,978,000.00 1.1250% 1.1596% 590 2016000130 FFCB $20,000,000 03/22/2018 $19,974,000.00 8/31/2016 $20,003,400.00 0.8000% 0.7898% 22 2016000131 FFCB $25,000,000 03/22/2018 $24,967,500.00 8/31/2016 $25,000,000.00 0.8000°k 0.8000% 22 2016000134 FHLB $20,000,000 05/18/2018 $19,968,000.00 8/31/2016 $20,000,000.00 0.9000% 0.9000% 79 2016000135 FNMA $20,000,000 07/26/2019 $19,930,000.00 8/31/2016 $20,000,000.00 1.1250% 1.1250% 513 2016000136 FFCB $26,000,000 06/27/2019 $25,950,600.00 8/31/2016 $25,997,400.00 0.9500% 0.9535% 484 2016000148 FNMA $20,000,000 01/28/2020 $19,930,000.00 8/31/2016 $20,000,000.00 1.3300% 1.3300% 699 2016000149 FHLB $14,435,000 04/26/2019 $14,400,356.00 8/31/2016 $14,435,000.00 1.1000% 1.1000% 422 2016000150 FHLB $5,565,000 04/26/2019 $5,551,644.00 8/31/2016 $5,565,000,00 1.1000°/0 1.1000% 422 2016000157 FNMA $30,000,000 08/16/2019 $29,934,000.00 8/31/2016 $30,000,000.00 1.2000% 1.2000% 534 2016000158 FNMA $20,000,000 08/23/2019 $19,978,000.00 8/31/2016 $20,000,000.00 1.2500% 1.2500% 541 2016000164 FHLMC $20,000,000 09/21/2018 $20,000,000.00 9/8/2016 $20,000,000.00 1.0000% 1.0000% 205 2016000166 FNMA $20,000,000 09/15/2020 $20,000,000.00 9/9/2016 $20,000,000.00 1.4500% 1.4500% 930 2016000173 FNMA $25,000,000 10/17/2019 $275,000.00 10/6/2016 $24,946,250.00 1.1000% 1.1732% 596 2016000176 FNMA $30,000,000 10/17/2019 $30,000,000.00 10/6/2016 $30,000,000.00 1.2300% 1.2300% 596 2016000180 FNMA $25,000,000 07/27/2020 $25,000,000.00 10/7/2016 $25,000,000.00 1.4000% 1.4000% 880 2016000191 FNMA $30,000,000 10/27/2020 $30,000,000.00 10/11/2016 $30,000,000.00 1.4050% 1.4050% 972 2016000194 FFCB $13,073,000 01/28/2019 $13,073,000.00 10/12/2016 $13,073,000.00 1.2700% 1.2700% 334 2016000195 FHLMC $30,000,000 11/02/2020 $30,000,000.00 10/12/2016 $30,000,000.00 1.3650% 1.3650% 978 2016000196 FHLMC $25,000,000 10/26/2018 $25,000,000.00 10/12/2016 $25,000,000.00 1.0500% 1.0500% 240 2016000198 FHLMC $30,000,000 11/02/2018 $30,000,000,00 10/18/2016 $30,000,000.00 0.9300% 0.9300% 247 2016000200 FNMA $17,965,000 10/28/2019 $17,960,508.75 10/19/2016 $17,960,508,75 1.2500% 1.2585% 607 2016000201 FNMA $18,910,000 09/30/2019 $18,905,272.50 10/19/2016 $18,905,272.50 1.2500% 1.2587% 579 2016000206 FNMA $25,000,000 07/28/2020 $25,000,000.00 10/24/2016 $25,000,000.00 1.3000% 1.3000% 881 2016000209 FNMA $20,000,000 07/28/2020 $20,000,000.00 10/25/2016 $20,000,000.00 1.3500% 1.3500% 881 2016000212 FHLMC $20,000,000 11/27/2019 $20,000,000.00 10/27/2016 $20,000,000.00 1.3000% 1.3000% 637 2016000215 FHLMC $20,000,000 11/10/2020 $20,000,000.00 10/27/2016 $20,000,000.00 1.4000% 1.4000% 986 2016000233 FHLMC $20,000,000 11/27/2019 $20,000,000.00 11/9/2016 $20,000,000.00 1.3000% 1.3000% 637 2616000237 FFCB $25,000,000 12/05/2018 $25,000,000.00 11/18/2016 $24,975,355.25 1.1000% 1.1497% 280 2016000238 FNMA $25,000,000 11/26/2019 $25,000,000.00 11/22/2016 $25,000,000.00 1,5000% 1.5000% 636 2016000239 FNMA $15,000,000 05/26/2020 $15,000,000.00 11/23/2016 $15,000,000.00 1.6250% 1.6250% 818 2016000241 FHLMC $25,000,000 12/13/2019 $25,000,000.00 11/15/2016 $25,000,000.00 1.5100% 1.5100% 653 2016000243 FNMA $20,000,000 06/29/2020 $20,000,000.00 12/14/2016 $20,000,000.00 1.7500% 1.7500% 852 2016000245 FNMA $25,000,000 01/17/2020 $25,000,000.00 12/22/2016 $25,000,000.00 1.7500% 1.7500% 688 2017000004 FNMA $30,000,000 01/27/2020 $30,000,000.00 1/6/2017 $30,000,000.00 1.7000% 1.7000% 698 file:///ClUsers/Thompsonm007/AppData/Local/Temp/tmpC162.html 3/2/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% 883 2017000017 FHLMC $15,000,000 05/25/2018 $14,998,500.00 2/9/2017 $14,998,500.00 1.0000% 1.0078% 86 2017000047 FHLMC $10,000,000 03/27/2020 $170,000.00 3/27/2017 $10,000,000.00 1.7000% 1.7000°/o 758 2017000048 FHLMC $25,000,000 07/11/2019 $25,000,000.00 3/28/2017 $25,000,000.00 1.5000% 1.5000% 498 2017000059 FHLMC $20,000,000 01/26/2021 $20,000,000.00 4/18/2017 $20,000,000.00 1.7500°k 1.7500% 1063 2017000060 FFCB $25,000,000 05/21/2018 $24,999,750.00 4/18/2017 $24,994,500.00 1.1000% 1.1203% 82 2017000061 FHLMC $20,000,000 05/15/2020 $20,000,000.00 4/18/2017 $20,000,000.00 1.7000°/o 1.7000% 807 2017000067 FHLMC $25,000,000 08/16/2019 $25,000,000.00 4/24/2017 $25,000,000.00 1.5000% 1.5000% 534 2017000070 FHLB $25,000,000 07/26/2019 $24,963,250.00 4/26/2017 $24,963,250.00 1.3750% 1.4417% 513 2017000074 FHLMC $25,000,000 05/11/2018 $24,946,000.00 4/27/2017 $24,946,000.00 1.0000% 1.2078% 72 2017000079 FHLB $30,000,000 02/03/2020 $30,000,000.00 4/28/2017 $30,000,000.00 1.6000% 1.6000% 705 2017000091 FHLMC $30,000,000 08/17/2020 $30,000,000.00 5/3/2017. $30,000,000.00 1.7000% 1.7000% 901 2017000095 FHLMC $25,000,000 05/18/2020 $25,000,000.00 5/5/2017 $25,000,000.00 1.7000% 1.7000% 810 2017000096 FFCB $12,250,000 05/17/2021 $12,250,000.00 5/5/2017 $12,250,000.00 1.9700% 1.9700% 1174 2017000113 FHLMC $20,000,000 12/27/2019 $20,000,000.00 6/28/2017 $20,000,000.00 1.5500% 1.5500% 667 2017000114 FHLB $25,000,000 06/29/2020 $25,000,000.00 6/28/2017 $25,000,000.00 1.6900% 1.6900% 852 2017000122 FHLMC $30,000,000 08/07/2020 $30,000,000,00 7/6/2017 $30,000,000.00 1.8500% 1.8500% 891 2017000123 FHLMC $30,000,000 07/19/2019 $30,000,000.00 7/6/2017 $30,000,000.00 1.5000% 1,5000% 506 2017000149 FHLMC $25,000,000 04/13/2020 $25,023,750.00 8/7/2017 $25,023,750.00 1.8000% 1.7634% 775 2017000150 FHLB $15,000,000 06/26/2020 $14,981,100.00 8/8/2017 $14,981,100.00 1.6250% 1.6702% 849 2017000158 FHLMC $20,000,000 09/29/2020 $19,980,000.00 10/2/2017 $19,983,888.89 1.7500% 1.7848% 944 2017000173 FNMA $20,000,000 09/28/2020 $19,980,000.00 10/17/2017 $19,999,444.44 1.7500% 1.7852% 943 2017000176 FHLB $15,000,000 04/17/2019 $14,977,500.00 10/2/2017 $14,978,750.00 1,5000% 1.6015% 413 2017000211 FHLMC $25,000,000 09/29/2020 $24,920,000.00 10/31/2017 $24,957,777.78 1.7000% 1.8142% 944 2017000212 FFCB $16,000;000 10/26/2020 $15,984,160.00 10/31/2017 $15,988,048.89 1.7500% 1.7845% 971 2017000213 FHLMC $25,000,000 09/01/2020 $25,000,000.00 10/24/2017 $25,000,000.00 1.8500% 1.8500% 916 2017000218 FHLMC $13,893,000 10/25/2019 $13,884,108.48 11/1/2017 $13,888,498.28 1.6250% 1,6580% 604 2017000219 FHLB $25,000,000 01/16/2019 $24,909,250.00 11/1/2017 $24,909,250.00 1.2500% 1.5526% 322 2017000220 FHLB $20,000,000 12/13/2019 $20,291,400.00 11/1/2017 $20,291,400.00 2.3750% 1.6704% 653 2017000229 FFCB $5,500,000 11/06/2019 $5,491,860.00 11/3/2017 $5,491,860.00 1.6000% 1.6755% 616 2017000230 FHLB $20,000,000 11/06/2020 $20,000,000.00 11/1/2017 $20,000,000,00 1.8800% 1.8800% 982 2017000234 FHLMC $25,000,000 08/14/2020 $25,000,000.00 10/30/2017 $25,000,000.00 1.8300% 1.8300% 898 2017000235 FNMA $20,000,000 11/09/2020 $20,000,000.00 10/30/2017 $20,000,000.00 1.9500% 1.9500% 985 2017000236 FHLMC $25,000,000 06/09/2020 $25,000,000.00 10/30/2017 $25,000,000.00 1.8000% 1.8000% 832 2017000237 FHLMC $25,000,000 09/28/2020 $25,000,000.00 11/1/2017 $25,000,000.00 1.8400% 1.8400% 943 2017000245 FHLMC $30,000,000 08/25/2020 $30,000,000.00 11/2/2017 $30,000,000.00 1.8750% 1.8750% 909 2017000246 FHLMC $25,000,000 11/27/2020 $25,000,000.00 11/1/2017 $25,000,000.00 1.9500% 1.9500% 1003 2017000247 FHLMC $25,000,000 08/25/2020 $25,000,000.00 11/1/2017 $25,000,000.00 1,8750% 1.8750% 909 2017000249 FHLMC $25,000,000 11/27/2020 $25,000,000.00 12/1/2017 $25,000,000.00 1.8750% 1.8750% 1003 2017000250 FHLMC $25,000,000 11/27/2020 $25,000,000.00 11/1/2017 $25,000,000.00 1.8750% 1.8750% 1003 2017000254 FHLMC $25,000,000 10/30/2020 $25,000,000.00 11/2/2017 $25,000,000.00 1.9000% 1.9000% 975 2017000255 FHLMC $25,000,000 11/25/2020 $25,000,000.00 11/2/2017 $25,000,000.00 1.9200% 1.9200°k 1001 2018000005 FNMA $20,000,000 09/29/2020 $19,740,600.00 1/22/2018 $19,848,266.67 1.7000% 2.2050% 944 2018000011 FHLB $25,000,000 07/30/2020 $25,000,000.00 1/16/2018 $25,000,000.00 2.1400% 2.1400% 883 2018000022 FHLB $20,000,000 02/12/2021 $20,000,000.00 1/17/2018 $20,000,000.00 2.3000% 2.3000% 1080 2018000028 FHLMC $25,000,000 02/26/2021 $25,000,000.00 1/31/2018 $25,000,000.00 2.4200% 2.4200°k 1094 2017000116 FHDN $45,000,000 06/27/2018 $44,460,037.50 7/3/2017 $44,460,037.50 1.2100% 1.2417% 119 file:///ClUsers/Thompsonm007/AppData/Local/Temp/tmpC1 62.html 3/2/20 1 8 Investments Portfolio Page 4 of 5 FMCDN $45,000,000 05/29/2018 $44,516,200.00 7/5/2017 $44,516,200.00 1.1800% 1.209416 90 2017000128 FCDN $40,000,000 06/27/2018 $39,507,200.00 7/10/2017 $39,507,200.00 1.2600% 1.2934% 119 2017000129 FMCDN $40,000,000 05/31/2018 $39,573,400.00 7/10/2017 $39,573,400.00 1.185016 1.2144% 92 2017000163 FHDN $25,000,000 10/04/2018 $24,666,333.33 10/4/2017 $24,666,333.33 1.320016 1.356416 218 2017000196 FMCDN $20,000,000 03/30/2018 $19,902,500.00 10/30/2017 $19,902,500.00 1.170096 1.192116 30 2017000198 FMCDN $25,000,000 03/15/2018 $24,890,781.25 10/30/2017 $24,890,781.25 1.165016 1.1864% 15 2017000203 FHDN $30,000,000 05/07/2018 $29,805,987.50 10/31/2017 $29,805,987.50 1.2450°k 1.2705% 68 2017000204 FHDN $30,000,000 04/09/2018 $29,842,325.00 10/31/2017 $29,842,325.00 1.190096 1.212916 40 2017000205 FMCDN $30,000,000 03/26/2018 $29,859,833.33 10/31/2017 $29,859,833.33 1.160096 1.1816% 26 2017000215 FMCDN $40,000,000 03/12/2018 $39,831,000.00 11/1/2017 $39,831,000.00 1.170016 1.1913% 12 2017000216 FHDN $40,000,000 04/30/2018 $39,752,383.33 11/1/2017 $39,752,383.33 1.2450°k 1.2702% 61 2017000217 FCDN $25,000,000 08/03/2018 $24,735,513.89 11/2/2017 $24,735,513.89 1.3900°k 1.4244°k 156 2017000222 FCDN $25,000,000 11/02/2018 $24,623,361.11 11/3/2017 $24,623,361.11 1.490016 1.5338°k 247 2017000231 FHDN $20,000,000 04/05/2018 $19,894,044.44 11/6/2017 $19,894,044.44 1.280096 1.3047% 36 2018000017 FHDN $25,000,000 04/04/2018 $24,942,177.08 2/1/2018 $24,942,177.08 1.3650°4 1.387216 35 2018000023 FHDN $12,000,000 03/20/2018 $11,985,600.00 2/15/2018 $11,985,600.00 1.3500% 1.370496 20 2018000024 FHDN $15,000,000 04/05/2018 $14,971,950.00 2/20/2018 $14,971,950.00 1.530016 1.5542% 36 2018000025 FHDN $15,000,000 03/26/2018 $14,980,166.67 2/20/2018 $14,980,166.67 1.400096 1.4213% 26 2016000160 TNote $25,000,000 12/15/2018 $25,225,000.00 8/31/2016 $25,250,976.56 1.2500% 0.804314 290 2017000006 TNote $25,000,000 06/30/2019 $25,169,921.88 1/10/2017 $25,169,921.88 1.6250°k 1.3421% 487 2017000089 TNote $30,000,000 06/30/2020 $30,105,468.75 5/3/2017 $30,105,468.75 1.6250% 1.4995% 853 2017000094 TNote $25,000,000 05/15/2019 $24,777,343.75 5/5/2017 $24,777,343.75 0.875096 1.322416 441 141 Acct 10-151- $3,292,106,000.00 $3,252,200,859.54 $3,287,835,989.32 1.411445 0/0 537 556 Totals: Account 10-151-567 COUNTY SCHOOL BONDS Invest # Type Face Amt Mat Date Market Value MV Date Book Value Rate V1144 DTM 2013000241 SDPB $235,000 07/01/2018 $237,876.40 7/24/2013 $237,876.40 1.9800% 1.7146% 123 2013000289 SDPB $16,775,000 07/01/2018 $16,862,062.25 10/1/2013 $16,862,062.25 1.9750% 1.8576% 123 2014000091 SDPB $3,000,000 07/01/2018 $3,000,000.00 5/1/2014 $3,000,000.00 1.6300% 1.6300% 123 2014000131 SDPB $135,000 07/01/2018 $138,221.10 7/3/2014 $138,221.10 2.290096 1.6616% 123 2014000132 SDPB $370,000 07/01/2019 $375,072.70 7/3/2014 $375,072.70 2.290096 1.9921% 488 2015000073 SDPB $1,500,000 07/01/2018 $1,500,000.00 5/12/2015 $1,500,000.00 1.2700% 1.2700% 123 2015000074 SDPB $3,000,000 07/01/2019 $3,000,000.00 5/12/2015 $3,000,000.00 1.5700% 1.5700% 488 2016000168 SDPB $2,025,000 07/01/2020 $2,190,888.00 9/1/2016 $2,190,888.00 3.570096 1.3245% 854 2016000169 SDPB $4,130,000 07/01/2021 $4,532,881.50 9/1/2016 $4,532,881.50 3.5700% 1.4191% 1219 2016000181 SDPB $1,040,000 07/01/2018 $1,040,000.00 10/6/2016 $1,040,000.00 1.0300°6 1.0300% 123 2016000182 SDPB $1,030,000 07/01/2019 $1,030,000.00 10/6/2016 $1,030,000.00 1.1300% 1.1300% 488 2016000183 SDPB $1,650,000 07/01/2020 $1,650,000.00 10/6/2016 $1,650,000.00 1.300096 1.3000% 854 2016000184 SDPB $1,355,000 07/01/2021 $1,355,000.00 10/6/2016 $1,355,000.00 1.4200% 1.4200% 1219 2016000185 SDPB $210,000 07/01/2018 $217,028.70 10/6/2016 $217,028.70 3.0000% 1.0434% 123 2016000186 SDPB $215,000 07/01/2019 $225,734.95 10/6/2016 $225,734.95 3.0000% 1.1315% 488 2016000187 SDPB $1,045,000 07/01/2020 $1,166,011.00 10/6/2016 $1,166,011.00 4.500016 1.2818% 854 2016000188 SDPB $1,095,000 07/01/2021 $1,095,000.00 10/6/2016 $1,095,000.00 1.420016 1.4200% 1219 2018000013 SCFD $49,000 07/01/2019 $51,674.91 1/30/2018 $51,674.91 6.140096 2.2177% 488 2018000014 SCFD $58,000 07/01/2020 $63,181.72 1/30/2018 $63,181.72 6.1400% 2.2928% 854 2018000015 SCFD $62,000 07/01/2021 $69,458.60 1/30/2018 $69,458.60 6.1400°6 2.3831% 1219 2018000016 SCFD $65,000 07/01/2022 $74,663.55 1/30/2018 $74,663.55 6.140096 2.4567% 1584 file:///C:/"Users/Thompsonm007/AppData/Local/Temp/tmpC162.html 3/2/2018 Investments Portfolio Page 5 of 5 21 Acct 10-151- $39,044,000.00 $39,874,755.38 $39,874,755.38 1.608020% 445 567 Totals: Account 32-001-534 MIHS MAIN DEPOSITORY Invest # Type Face Amt Mat Date Market Value MV Date Book Value Rate YTM DTM 2018000019 H4DN $50,712,000 08/03/2018 $50,299,732.57 2/5/2018 $50,299,732.57 1,6350% 1.6713% 156 2018000020 FHDN $25,200,000 08/03/2018 $24,996,279.00 2/5/2018 $24,996,279.00 1.6350% 1.6712% 156 2018000026 FHDN $50,000,000 08/03/2018 $49,595,791.67 2/5/2018 $49,595,791.67 1.6350% 1.6712% 156 3 Acct 32-001-534 $125,912,000.00 $124,891,803.24 $124,891,803.24 1.671250% 156 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,391,444.00 1.2500% 1.2975% 246 2017000104 FFCB $13,300,000 11/26/2018 $13,292,818.00 5/18/2017 $13,292,818.00 1.2200% 1.2561% 271 2017000240 FMCDN $6,288,000 10/31/2018 $6,199,417.80 11/17/2017 $6,199,417.80 1.4700% 1.5117°A3 245 3 Acct 32-535-534 $31,988,000.00 $31,883,679.80 $31,883,679.80 1.322390% - 256 Totals: Account 32-700-534 MIHS DEBT INTEREST & REDEMPTION FUND Invest # Type Face Amt Mat Date Market Value MV Date Book Value Rate VIM DTM 2017000239 FMCDN $19,500,000 06/20/2018 $19,497,064,17 11/16/2017 $19,342,198.96 1.3550% 1.3850% 112 2018000027 FHDN $3,000,000 06/22/2018 $2,983,340.00 2/23/2018 $2,983,340.00 1.6800% 1.7128% 114 2017000105 TNote $3,200,000 06/15/2018 $3,198,875.00 5/19/2017 $3,198,875.00 1.1250% 1.1528% 107 3 Acct 32-700-534 $25,700,000.00 $25,679,279.17 $25,524,413.96 1.394383% 112 Totals: Report Totals: $3,683,750,000.00 $3,643,822,747.13 $3,679,303,011.70 1.421263% 499 file :1//C :/Users/Thompsonm007/AppData/Local/Temp/tmpC162.html 3/2/2018 Investments Portfolio Summary Page 1 of I Maricopa County Treasurer Investments Portfolio Summary Report 02/28/2018 - 179 Investments Issue Type Count Par Value Market Value Book Value YTM DTM FCDN 3 $90,000,000.00 $88,866,075.00 $88,866,075.00 1,396576% 165 FFCB 16 $320,613,000.00 $320,204,153.00 $320,521,758.64 1.125090% 348 FHDN 14 $385,912,000.00 $383,176,148,09 $383,176,148.09 1.431712% 102 FHLB 20 $374,000,000.00 $374,029,200.00 $374,053,780.00 1.530848% 579 FHLMC 54 $1,274,318,000.00 $1,264,368,858,48 $1,274,270,664,95 1.522614% 689 FMCDN $225,788,000.00 $224,270,196.55 $224,115,331.34 1.222887% 61 FNMA 30 $696,875,000.00 $671,264,381.25 $696,629,542.36 1.394694% 670 SCFD 4 $234,000.00 $258,978.78 $258,978.78 2.346510% 1077 SDPB 17 $38,810,000.00 $39,615,776.60 $39,615,776.60 1.603567% 441 TANS 8 $169,000,000.00 $169,292,370.00 $169,292,370.00 1.405936% 140 TNote $108,200,000.00 $108,476,609.38 $108,502,585.94 1,251340% 521 Report 179 $3,683,750,000.00 $3,643,822,747.13 83,679,303,011.70 1.421263% 499 Totals: file:///ClUsers/Thompsonm007/AppData/Local/Temp/tmp219E.html 3/2/2018 1 02-MAR-2018 PAGE: BALANCE 1,883,487,027.60 3,307,881.68 2,405,599.74 1,580,934.58 1,204,250.54 1,126,447.08- 20,826,007.75 42,903,045.85- 87,122,254.41 26,167,114.39 570,666.52- 715,728.60- 575,188.59 628,442.27 734,341.40- 1,2131,012.12- 637,806.83 572,754.61- 679,724.78- 762,983.09- 651,645.16- 79,001.04- 758,500.65- 1,128,187.77- 1,190,778.31 3,577,206.37 2,207,545.99 7,952,619.51 8,122,152.43 3,284,787.16- 22,355.94 17,516.20 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 321.83 1,996,054,170.95 ENDING - • • OFFICE 668,169.35- 655,322.11- 352,839.25- 371,933.77- 10,216.21- 12,384.94- 20,344.98- 33,922.61- 41,247.68- 19,718.50- 1,453.51- 318.08- 164.81- 166.29- 172.18- 164.49- 168.66- 142.82- 139.57- 126.64- 128.39- 206.20- 222.70- 7.74- 7.66- 7.23- 7.17- 6.88- 6.96- 6.90- 7.20- 6.94- .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 2,189,738.42- S 2018 ADJUSTMENTS FEB TREASURER' FOR ACTIVITY 300,188.95- 343,212.74- 7,470.54 11,581.88 12,158.49 5,692.22 17,398.98 2,477.79 418.42 147.92 155.20 759.92 197.30 181.18 160.76 .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 136,224,773.28 15,265,661.28 150,905,833.47 AND COUNTY LEVY SECURED 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 723,971.92- 1,280,666.45- 638,136.25 572,611.79- 679,585.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 MARICOPA BEGINNING LEVY LEVY_RPT_MONTB_SUM 4,791,587,056.58 4,643,191,878.76 4,364,407,727.86 4,242,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,226.72 2,595,278,869.32 2,290,234,573.96 2,108,716,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 1958 TOTAL PROGRAM 02-MAR-2018 PAGE: BALANCE 197,750.52- 13,315,688.27- 3,061,068.35 874,637.98- 9,260,994.05- 28,450,427.46- 25,511,465.37- 22,886,308.17- 35,072,029.84- 28,750,866.17- 8,107_024.00 14,418,422.22- 17,542,137.97- 8,349,522.56- 951,016.29- 7,916,568.30- 21,538,144.42- 7,182,377.74- 25,772,612.27- 28,111,584.10- 12,928,887.66- 6,578,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,486,537.95- ENDING OFFICE .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 2018 ADJUSTMENTS FEB TREASURER'S FOR ACTIVITY .00 .00 574.18 .00 176.89 ' 180.77 .00 .00 107.58 .00 .00 .00 .00 86.85 37.75 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 1,164.02 COLLECTIONS AND COUNTY LEVY UNSECURED 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,888,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- 8,812,702.12- 5,929,894.62- 2,891,654.20- 2,664,351.52- 5,472,248.17- 5,836,677.39- 2,953,588.51- 1,719,922.87- 433,497.42- 1,422,511.95- 2,320,992.14- 405,485,373.93- MARICOTIA 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 112,747,601.88 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,282.81 76,956,283.43 50,507,999.56 53,570,953.57 73,434,045.21 37,838,109.79 36,683,300.76 20,075,323.04 29,722,220.00 28,815,308.42 26,779,663.13 23,204,794.95 19,189,042.79 15,296,922.12 13,177,985.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 TOTAt PROGRAM 3 02-MAR-2018 PAGEE Closing 2alance 176,204.60 46,160,029.48 274,843,148.17 274,943,148.17 403,448.31- 1,370,092.15 313,517.82 1,969,215.82 1,022,009.94 496,388.28 1,087,617.66 3,943,191.54 284,918.31 413,965.96 223,180 - 45- 815,498.60- 1,714,009.35 4,016,889.93 52,327.31- 13,775.22- 105,199.63 292,431.21 1,160,691.54- 168,426.02 522,095.69 6,191,851.23- 931.19 124, 1,506.91 279,105.14 12,040,252.29 582,415,38 1,161,849.21 43,267.94 8,917.90- 46594,198.02 57,115.94- 88,949,431.35 717,832.54 8,237.29 749,098.29 13,526.23 1,535,826.54 2,616,990.66 337,184.04 Disbursements 19,386.53 7,306,496.61 2,106.69 2,106.69 35.5],- 98.77 3.11- 1,969.72 To 20,575.03 122,370.96 27,306,664.76 27,306,864.76 109,056.30 2,542.27 423.82 2,683.09 1,392.82 749.25 46,448.59 5,605.38 380.61 633.12 200.30 482.65 2,404.32 5,470.69 225.05 1,230,101.01 143,061.82 256.35 1,347.56 23,221.46 172.54 2.00 391.45 217,827.89 868.61 1,526.74 61.02 180,862.73 8,025,252.40 915.79 11.38 577.59 2,061.11 52,314.04 471.56 Transfer OFFICE From 97.65 159,730,336.62 95,917,080.60 95,917,080.80 564,540.70 990,385.73 1.00 43,777,82 57,325.50 66,718.75 220,964.63 12,763.92 10,412.93 215,958.36 16,304.39 31,978.36 30,265.42 117,877.74 165.08 491,403.09 174,499.34 625,573.54 167,855.00 101,907.23 3,063,019.76 19,399.76 1,075,467.20 226,536.34 224,815.00 932.00 3.34 14,291,663.15 14,522.93 2,946,717.98 374,630.82 105,721.87 39,953.97 246,744.06 420,389.35 4,746.38 'S 2018 FOB, TREASURER of Month the Income Distribution 121,100.00 166,487,083.47 61,358,868.93 61,358,868.93 917,725.61 6,688.61 69,928.10 86,949.44 3,034.00 175,738.25 116,863.80 1,140.00 5,639.00 16,654.53 100,875.87 185,446.71 206,420.90 722,996.03 118,395.20 1,140,584.32 109,083.16 111,252,00 2,808,867.75 9,628.80 965,376.33 180,102.36 245,669.93 125.60 10,111,910.91 45,481.00 1,364,899.19 315,252.00 565,262.07 42,301.47 161,640.58 303,032.36 for COUNTY Report mARICOPA Treasurer's Opening Balance 54,013.75 46,787,408.28 282,096,601.97 282,056,601.97 27,955.91- 1,440,210.00 306,106.39 1,940,481.65 990,993.18 492,605.03 932,149.57 4,051,686.99 296,161.62 423,745.77 13,061.39- 816,331.39- 1,743,183.39 3,942,808.79 119,896.26- 220,031.04- 126,618.36- 801,565.66- 1,816,764.14- 226,941.51 521,403.36 5,960,956.87- 134,755.05 1,504.83 288,484.85 11,932,514.04 627,980.75 1,139,467,54 44,013.32 8,914.56- 50,583,084.72 86,070.91- 63,004,597.74 776,295.57 8,225.91 168,9180.10 11,178.73 1,618,868.91 2,704,003.34 341,458.86 FEE cOusIGNMENT ENHANCEMENT FUND GAP THE GAP THE CONSERVATION FEES FEES SPECIAL GRANTS PROJECTS ENFORCEMENT SERVICES Description FUNDS PEES JUDICIAL RETRIEVAL EQUIPMENT TRAINING GRANTS RICO ENHANCEMENT MANAGEMENT GRANTS COURT TRUST FILL COURT GRANTS ATTORNEY PILL GRANTS GRANTS GRANTS RANCH DEVELOPMENT GRANTS RESTITUTION RECREATION OPERATIONS GRANTS CAPITAL REVENUE SURCHARGE PHOTO GRANTS RECREATION GRANTS FUNDS GENERAL WAREHOUSE WAREHOUSE PRORATION DONATIONS COURT DOCUMENT SAFETY VERDE ENHANCEMENT DEFENDER MANAGEMENT PRORATION RICO ATTORNEY JAIL THE OF HOUSING THE OF ATTORNEY COUNTY ATTORNEY SERVICES TRANSPORTATION EXAMINER CROSS SPUR & PRORATION PRORATION AND TRANSPORTATION DEFENDER TRANSPORTATION SPECIAL COURTS COURT SOUVENIR PLEASANT ENHANCEMENT DISTRICT FUND_BAL_MTD SUSPENSE TREAS GENERAL COUNTY SHERIFF SHERIFF ADULT SHERIFF JUSTICE COURT OFFICER PALO JUDICIAL PUBLIC WASTE ADULT SHERIFF COUNTY SHERIFF EMERGENCY CLERK CDEG CLERK COUNTY DIVERSION COUNTY HUMAN MEDICAL PARK PLANNING JUVENILE JUVENILE JUVENILE PARKS PUBLIC WEB DEL RECORDER'S JUSTICE TRIAL PARKS LAKE PARRS LIBRARY ACC IDE 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-2.04-000 3.1-205-000 31-206-000 31-207-000 31-208-000 31-209-000 31-210-000 31-211-000 31-212-000 31-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-232-000 31-233-000 31-234-000 31-235-000 31-236-000 31-237-000 31-238-000 31-239-009 31-240-000 31-241-000 31-242-000 Program 659 28-FEB-2018 PAGE: 28-FEB-2018 OFFICE S 434 30 1,559 141 33 29 156 153 309 1 57 58 442 222 664 163 892 1,055 123 100 223 445 7 236 688 1 63 64 21 68 89 20 98 118 807 807 40 12,448 14,674 - FUND TREASURER' 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: - COUNTY WARRANTS AMOUNT 4,852.88 358,308.27 38,130.18 5,444,091.25 57,492.71 102,401.59 81,018.39 6,086,295.27 58,146.14 784,398.60 842,544.74 659.59 176,463.85 177,123.44 215,257.82 1,771,333.54 1,986,591.36 5,384,799.44 3,245,151.73 8,629,951.17 100,611.62 446,017.46 546,629.08 249,953.99 21,767.60 4,598,130.46 4,869,852.05 652.29 W,820.39 400,472.68 10,641.19 244,945.61 255,586.80 12,345.55 212,794.03 225,139.58 2,106,240.18 2,106,240.18 14,305.96 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 District District District District District District District District District District District OTSTND_WT_FUND 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