Extracted text (via ocr_local)
40743 characters
Royce T, Flora, Treasurer 301 West Jefferson St. Rm. 100 Phoenix, Arizona 85003 Phone: (602) 506-8511 Maricopa County Fax: (602) 806-1102 Treasurer http://treasurer.maricopa.gov DATE: August 11, 2020 TO: Clint Hickman, Chairman Jack Sellers, Supervisor, District I Steve Chucri, Supervisor, District 2 Bill Gates, Supervisor, District 3 Steve Gallardo, Supervisor, District § SUBJECT: ‘Treasurer's Collections and Investment Summary for July 2020 Secured property tax collections during the month of July equaled $109,092,845.30 and inereased the 2019 year to date collections to $5,194,476,920 or 99% of the adjusted 2019 levy of $5,252,314,009 The chart below reflects the 2019 celleeted and uncollected levy amount and corresponding percentages for the 2019 property tax year. July 2020 Collected Levy, $5,194,476,920 99% Uncollected Levy, $57,837,089 , 1% Collected Levy @Uncollected Levy The County’s General Fund Balance totaled $80,085,093.31 effective July 31, 2020. Warrants outstanding of $8,278,604.43 will post against the fund balances when presented. The $20,447,512. unencumbered balance, of the County Municipal Line of Credit and the $14,552,488. Workers Compensation Liability Letter of Credit remain unused, Submitted under oath, Russell k. Pearce Chief Deputy Treasurer STATE OF ARIZONA J 8s. COUNTY OF MARICOPA |} This instrument was acknowledged before me this 12th day of August 2020, 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 te the foregoing instrument and who acknowledged te me that they executed the same for and on behalf of the State of Arizona for the purpose and consideration therein expressed, Phtenh Gurl Cte. /S, 20a / Notary Public My Commission Expires KAREN D SMITH Notary Pub - Arizona Maricopa Courity My Conn, Expres Dac 15, 2021 PROGRAM ID: APP LEVY _RPT MONTH SUM MARICOPA COUNTY TREASURER YEAR LEVY 2019 5,268,316, 083.92 2018 5,032,079,420.54 2017 4,791,587, 056.58 2016 4,643,191,878.76 2015 4,364,407, 727.86 2014 4, 243,506,812 .16 2013 4,019,480, 209,28 2012 4,045, 298,460.92 2012 4,138, 461,193.04 2010 = 4,411, 089,394.04 2009 «= 4, 593, 263, 862.98 2008 4,288,606,572.70 2007 «= 4,001,594, 678.74 2006 3,660,387, 436.00 2005 3,489, 841,477.20 2004 3,246, 259,075.84 2003 3,049,037,955.00 2002 2,792,576, 236.72 2001 2,595,278, 869.32 2000 «= -2, 290, 234,573 .96 1999 2,108,718, 697.02 1998 1,939,463,904.72 1997 1, 800,100, 859.36 1996 1,631,715, 958.46 1995 1,683, 783,514.12 1994 1,507,769, 663.58 1993 1,476,046, 063.04 1992 1,477,426 592.42 1991 1,485, 482,338.84 1990 1,445,084, 095.32 1989 1,306, 266,536.54 1988 1,181,440, 841.12 1987 1,049, 888,299.56 1986 870,295, 854.72 1985 721,770, 831.08 1984 600,944,379.84 1983 530,525,148 42 1982 451,214,378 .40 1981 402,942, 488.72 1980 373,230,675.34 1979 382,783, 606.36 1978 365,594, 731.04 1977 360,443 ,065.88 1976 332,481, 242.68 1975 294,189,512.68 1974 251,690, 646.52 1973 224, 585,828.94 1972 191, 805,552.44 1971 165, 623,012.50 1970 138, 694,628.82 1969 126, 692,073.74 1968 116,414,184.58 TOTAL 105,959, 608,182.36 'S$ OFFICE SECURED LEVY AND ACTIVITY FOR JUL 2020 BEGINNING BALANCE 167,505,671.29 1, 940,002.82 1, 280,115.73 1,505, 422.30 1,496, 915.13 1,069,328.51 778,255.95 1,513,370.81- 20,526,521.75 43,255,212.92- 86,833, 011.74 25,886, 643.33 782,069 .59- 857,909 .66- 480,394.05 557,900.89 1,102,461 .12- 1,666, 558.01- 342,895.31 573,629.53- 680,620.36- 163 ,899.73- 652, 562.86- 82,273 .28- 761,851.11- 1,131, 451.59- 1,187, 757.93 3,574,325.77 2,207,521.85 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 41,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 276,448,994,35 COLLECTIONS ADJUSTMENTS ENDING BALANCE 109, 092,845.30 13,589,341.78- 2,172, 722.58~- 1,729, 044.88- 1,269,566.12- 1,330.65 590.41 433.63 426.79 394.90 350.14 309.94 171.72 1,141.76 785.38 1,737.94 +00 00 +00 .00 00 00 00 00 00 00 00 +00 00 00 00 00 +00 00 +00 200 00 +00 .00 +00 00 00 00 00 00 00 00 00 00 00 00 .00 90,339,843 .20 575,737 .20- 13,571,541.44- 2,127,547 .34- 1,774,383 .28- 1,275,815 .42- 00 00 00 00 +00 -00 +00 +00 00 +00 00 00 00 00 00 00 00 00 -00 00 -00 -00 00 +00 200 +00 +00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 -00 +00 -00 +00 +00 00 19,325, 024.68- 57, 837,088.79 1, 957,803.16 1, 325,290.97 1, 460,083.90 1,490, 665.83 1, 067,997.86 977, 665.54 1,513,804.44- 20,526,094.96 43,255, 607.82- 86, 832,661.60 25, 886,333.39 782,241.31- 859,051.42- 479,608.67 556,162.95 1,102,461.12- 1,666,558.01- 342,895.31 573, 629,53- 680, 620.36- 763,899.73- 652,562.86- 82,273.28- 761,851.11- 1,131, 451.59- 1,187,757.93 3,574,325.77 2,207,521.85 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 331.83 166, 784,126.47 03-AUG-2020 PAGE: 1 PROGRAM ID: APP LEVY_RPT_MONTH_SUM YEAR LEVY 2004 +00 2003 .00 2002 16,903,615.38 2003 19,330,396.80 2000 138,497,672.37 1999 122,871,629.32 1998 222,881, 710.56 1997 115,134, 253.32 1996 102,673,892,06 1995 113, 747,601.86 1994 162,209,939.25 1993 154,917,045.68 1992 140, 629,687.78 1991 131,582,120,56 1990 122, 744,902.09 1989 113,929,972.43 1988 96,811,185.54 1987 88,991,362.81 1986 76,956,283 .43 1985 50,507, 999.56 1984 53,570,953 .57 1983 73,434,045.21 1982 37,836,109,79 1981 36,683,300.76 1980 30,075,323.04 1979 29,722,220.00 1978 28,615,308.42 1977 26,779,663.13 1976 23,204,794.95 1975 19,189,042.79 1974 15,296,922,12 1973 13,177, 965.26 1972 13,623,786.21 1871 12,084,654.91 1370 10,386,975 .86 1969 5, 918,654.86 1968 4,195,165.19 TOTAL 2,325,116,156.87 MARICOPA COUNTY TREASURER' S OFFICE UNSECURED LEVY AND ACTIVITY FOR JUL 2020 BEGINNING BALANCE 197,750.52- 13,356,069 .67- 3,025,549.11 908,015 .20- 9,600,074,07- 28,717,268 .10- 25,613,913.68- 22,991, 084.77- 35,349,453 .05- 28,930,383 .63- 7, 647,588.77 14,738,205 .59- 17,960,825 .13- 6,674, 284.60- 1,269,288.95- 8,385,792.84- 21, 988,363.31- 7,484,835 .49- 25,986,693 .31- 28,240,893.00- 12,980,240,92- 6,629,772 .26- 22,961,357 .32- 18,070,978 .29- 17,273,398 .23- 6,566,057.11- 6,816, 484.82- 5,944, 729.86- 2,710,083 .28- 2,676,843 .29- 5,483,374.18- 5,844,853 .65- 2,956, 945.73- 1,720,760. 88- 434,685 .68- 1,422,511. 95- 2,320,992.14- 410,534,126 .62- COLLECTIONS ADJUSTMENTS ENDING BALANCE «900 18.67 20.90 00 17,16 15,88 11.96 +60 11.77 +00 00 90 -90 00 00 .00 00 00 00 +00 00 +00 00 00 90 00 00 90 00 00 00 -00 -00 60 +00 96.34 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 197, 750.52- 13,356, 088.34- 3,025,528.21 908,015. 20- 9,600,091. 23- 28,717, 283.98- 25,613, 925.64- 22,991, 084.77- 35,349,453 .05- 28,930,395.40- 7, 647,588.77 14,738, 205.59- 17,960,825.13- 6,674, 284.60- 1,269, 288.95~ 8,385, 792.84- 21,988, 363.31- 7,484,835 .49- 25,986, 693.31- 28,240, 893.00- 12,980, 240,92- 6,629,772 .26- 22,961, 357.32- 18,070,978 .29- 17,273 ,398.23- 6,566,057.11- 6,816, 484. 82- 5,944, 729.86- 2,710, 083.28- 2,676, 843 .29- 5,483 ,374.18- 5,844,853 .65~ 2,956,945. 73- 1,720, 760.88- 434,685. 68-~ 1,422,511. 95- 2,320,992.14-~ 410,534,222.96- 03-AUG-2020 PAGE: 1 Maricopa County MARICOPA COUNTY TREASURER Selected Funds Total Earnings Sorted by Fund - Issuer July 1, 2020 - July 31, 2020 Adjusted Interest Earnings Ending Beginning Average Current Annualized interest Amortization/ Realized Adjusted Interest CUSIP Investment# Fund Issuer Par Value Book Value Book Value Rate Yield Eamed Accretion Gaint/Loss Eamings Fund: Treasurer's Pool 22533ABW6 11092 1000 ACAFP 0.00 30,000,000.00 28,064,516.13 2.250 2.281 54,375.00 0.00 9.00 54,375.00 22533ACS47 11135 14000 ACAFP 20,000,000.00 20,000,000.00 20,000,000,00 1,700 1.668 28,333.34 0.00 0.00 28,333.34 22533AC96 11179 1000 ACAFP 20,000,000.00 20,000,000,00 20,000,000.00 1.180 1.158 19,666.66 0.00 0.00 19,666.66 023135BQ8 210002 1000 AMAZ 27,272,000.00 0.00 16,915,375.30 0.800 0.652, 12,726.94 -3,360.96 0.00 9,365.98 037833CQ1 10875 1000 APPL 20,000,000.00 19,872,470.59 19,875,509,.93 2.300 2.609 38,333.33 5,710.27 0.00 44,043.60 037833DC1 10945 1000 APPL 20,000,000,00 20,035,383.25 20,034,668.97 2,100 1.978 35,000.00 -1,341.97 0.00 33,658.03 037833DT4 11183 1000 APPL 15,615,000.00 15,754 884.38 15,753,608.01 1,125 0.915 14,639.06 -2,398.02 0.00 12,241.04 025816BR9 11010 1000 AXP 12,000,000.00 12,385,867.73 12,352,230.19 3.000 2.207 30,000.00 -6,848.00 0.00 23,152.00 09248718 10661 1000 BLKMM 200,000,000.00 0.00 193,548,387.10 0,00 0.00 0.00 0.00 09248U700 10737 1000 BLKMM 200,000,000.00 9.00 193,548,387.10 0.00 0.00 0.00 0.00 09248U551 10825 1000 BLKMM 0.00 0.00 0,00 9.00 0,00 0,00 0.00 09248874 11061 1000 BLKMM $0,000,000.00 50,000,000.00 $0,000,000,00 0.00 0.00 9.00 0.00 064159UKO 11176 1000 BN 20,000,000.00 20,000,000.00 20,000,000.00 0.780 0.791 13,433.34 0.00 0.00 13,433,34 118106KC6 11162 1900 BUCHSD 0,00 150,000.00 90.00 1,900 0.00 0.00 0.00 0.00 118106KD4 11163 1000 BUCHSD $15,000.00 521,453.62 521,187.37 1.900 0.627 815.41 -537.80 9.00 277.64 1118106KE2 11164 1000 BUCHSD 1,715,000,00 1,757,160.30 1,756,225.30 1.900 0.643 2.715.441 1,756.68 0.00 958,73 118106KF9 11165 1000 BUCHSD 1,430,000,00 1,480,397.67 1,479,652.54 1.900 0.688 2,264.17 +1,399.93 0.00 864.24 118106KG7 11186 1000 BUCHSD 3,120,000.00 3,257,285,08 3,255,762.77 1.900 0,752 4,940.00 72,860.10 0.00 2,079,90 118106KHS 11167 1000 BUCHSD 3,275,000,00 3,432,335.52 3,430,784.72 1.900 0.780 5,185.44 -2,913.62 9.00 2,271.79 2021TANBU 210004 1000 BUCHSD 4,000,000.00 0.00 258,765.88 0,850 0.563 188.89 65,19 0.00 123.70 14913Q2TS 11021 1000 CAT 7,000,000.00 7,124,950.00 7,121,596.77 2.950 1.803 17,208.33 -6,300.00 0,00 10,908.33 14913Q3B3 11084 1000 CAT 25,000,000.00 25,154,656.09 25,153,080.14 2.150 4,958 44,791.67 -2,960,87 9.00 41,830.80 2021TANCU 210005 1000 CHNUSD §0,000,000.00 0.00 3,234,573.47 0,850 0.563 2,361.11 ~814.93 9.00 1,546.18 17288CHJO 11032 1000 CITI $0,000,000.00 $0,000,000,00 50,000,000.00 2.300 2,257 95,833.33 0,00 0.00 95,833.33 17325FAS7 11072 1000 cITl 30,000,000,00 31,641 ,578.90 31,621,132.48 3,650 1.967 91,250.00 ~38,414.49 0.00 52,835.51 17327T2B1 11093 1000 CITl 30,000,000.00 30,000,000,00 30,000,000.00 2.250 2.208 56,250.00 0.00 0.00 $6,250.00 17327TF68 11106 1000 CITI 25,000,000.00 25,000,000.00 25,000,000,00 2.000 1.962 41,666.66 0.00 0,00 41,666.66 19416QELO 10929 1000 cL 20,000,000.00 19,952,013.33 19,952,910,57 2.250" 2.312 37,500.00 1,685.72 0,00 39,185.72 12572QAES 10922 1000 CME §,000,000.00 §,040,846.45 5,040,025.01 3.000 2.560 12,500.00 -1,543.31 0.00 10,956.69 166764BK5 10931 1000 CVX 10,000,000.00 10,014,375,00 10,014,153.23 2.566 2.465 21,383.33 ~416,67 0.00 20,966.66 Portfolio INVT Data Updated: ~REPORT~: 08/13/2020 12:23 AP. Run Date; 08/13/2020 - 12:24 TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 MARICOPA COUNTY TREASURER Selected Funds Total Earnings Page 2 July 1, 2020 - July 31, 2020 Adjusted Interest Earnings Ending Beginning Average Current Annualized Interest Amortization! Realized Adjusted Interest cUSsIP Investment# Fund — Issuer Par Value Book Value Book Value Rate Yield Eamed Accretion Gainl/Loss Eamings Fund: Treasurer's Pool 24422EVCO 11070 1000 DE 5,000,000.00 5,007,687.78 5,007,612.37 2.030 1.975 8,541.67 141.67 0.00 8,400.00 24422EVCO 41073 1000 DE §,000,000.00 4,999,994.86 4,999,994.91 2.050 2.011 8,541.67 0.10 0,00 8,541.77 244199BE4 11128 1000 DE 2,000,000,00 2,042,523.92 2,041 ,549.73 2.600 1.444 4,333.34 -1,830.30 0.00 2,503.04 24422EUT4 11130 1000 DE 2,000,000.00 2,055,636.08. 2,054,225.94 2.950 1.300 4,916.67 2,649.34 0.00 2,267.33 24422EUG2 41177 1000 DE 25,000,000.00 25,073,870.53 25,072,766.96 1.000 0.911 21,527.78 -2,138.17 0,00 19,389.61 24422ERTS 41178 1000 DE 8,000,000.00 8,433,716.13 8,426,237.22 2,800 0.645 18,666.67 ~14,051.28 0.00 4,615.39 2021TANDV 210006 1000 DEERUS 30,000,000.00 0,00 1,940,744.08 0,850 0,563 1,416.67 488.96 9.00 927.71 254687FK7 41016, 1000 DIS 25,000,000.00 24,801,289,.84 24,803,402.27 1.750 1.919 36,458.34 3,976.85 90.00 40,435.19 3133EHJ95 10517 1000 FFCB 16,000,000.00 15,998,305.49 18,998,540.77 1.750 1,750 23,333.33 442,04 0.00 23,775.37 3133BJWJ4 10739 1000 FFCB 10,000,000,00 10,000,000.00 10,000,000.00 2.082 2.043, 17,351.08 0.00 0.00 17,351.08 S133EJWI4 10740 1000 FFCB 15,000,000.00 15,000,000.00 1§,000,000.00 2.082 2.043 26,026.63 0.00 0.00 26,026.63 3133EJTS90 10789 1000 FFCB 25,000,000.00 24,994,656.25 24,995,288.31 2.950 2,954 61,458.33 1,187.50 0,00 $2,645.83 3133EKWZS 40963 1000 FFCB 0.00 35,000,000.00 30,483,870,97 2.200 1.900 49,194.44 0.00 0.00 49,194.44 3133EKC61 10971 1000 FFCB 25,000,000.00 25,000,000,00 25,000,000.00 2,100 2,060 43,750.00 0.00 0,00 43,750.00 3133EKHS8 10976 1000 FFCB 30,000,000.00 30,000,000.00 30,000,000.00 2.260 2,294 58,383.34 0.00 0.00 58,383.34 3133EKH41 10981 1000 FFCB 25,000,000.00 25,000,000.00 25,000,000.00 2.000 1.962 41,666.67 0,00 9,00 41,666.67 3133EKH41 10982 1000 FFCB 25,000,000,00 25,000,000.00 25,000,000.00 2.000 1,962 41,666.67 0,00 0,00 41,666.67 3133EKH66 10983 1000 FFCB 20,000,000.00 20,000,000,00 20,000,000.00 1,850 1,815 30,833.33 0.00 0,00 30,833.33 3133EK2R6 10999 1000 FFCB 25,000,000,00 25,000,000.00 25,000,000.00 2.100 2.129 45,208.33 0,00 9.00 45,208.33 3133EKSM4 11024 1000 FFCB 25,000,000.00 25,000,000.00 25,000,000,00 2.000 1,962 41,666.66 9.00 0.00 41,666.66 S133ELFP4 41053 1000 FFCB 15,000,000.00 18,000,000.00 15,000,000.00 1.830 1.796 22,875.00 0.00 0.00 22,875.00 3133ELRQQ 11117 1000 FFCB 25,000,000,00 25,000,000.00 25,000,000.00 1.200 4,177 25,000.00 0.00 0.00 25,000.00 3133ELRZ9 11123 1000 FFCB 25,000,000.00 25,000,000.00 25,000,000.00 1,240 1.217 25,833.34 0.00 0.00 25,833.34 3133ELSX3 11134 1000 FFCB 20,000,000.00 20,000,000,00 20,000,000.00 1.000 0,981 16,666.67 0.00 0,00 16,666.67 3133ELUKS 11142 1000 FFCB 25,000,000.00 25,000,000.00 25,000,000.00 1.200 1.177 25,000.00 0.00 0.00 25,000.00 3133ELJ70 11186 1000 FFCB 30,000,000.00 29,992,525.11 29,992,591.94 0.830 0.820 20,750.00 125.56 9.00 20,875.56 3130ACTUS 10705 1000 FHLB 20,000,000.00 19,929,964,87 19,937,609.01 1.900 2.720 31,666.67 14,390.78 0.00 46,057.45 313383463 10962 1000 FHLB 20,000,000.00 20,148,347.53 20,146,108.61 2.125 1.824 35,416.67 4,206.45 0.00 34,210.22 313379069 10964 1000 FHLB 20,000,000.00 20,100,801.74 20,098,499.05 2.125 4.821 35,416.66 4,326.26 9.00 31,090.40 3130AHGK3 11020 1000 FHLB 10,000,000.00 10,000,000.00 10,000,000.00 2,000 1.962 16,666.66 0.00 0.00 16,666.66 3130AHWBS 11077 1000 FHLB 0.00 25,000,000.00 21,774,193,55 2.000 0.904 16,666.67 9.00 0.00 16,666.67 34130AHV91 11080 1000 FHLB 9.00 19,492,893.33 16,877,730.22 1,930 1.456 20,908.33. 86.67 7,020.00 28,015.00 3130AHV91 11081 41000 FHLB 0.00 7,997 084.44 6,965,222.65 1.930 1.456 8,577.78 35.56 2,880.00 11,493.34 3130AJC49 11111 1000 FHLB. 22,000,000.00 22,000,000.00 22,000,000.00 1.670 1.639 30,616.67 0.00 9,00 30,616.67 3134GVFL7 11114 1000 FHLB 25,000,000.00 25,000,000.00 25,000,000.00 1.240 4.257 26,694.45 0.00 0,00 26,694.45 3130AJF79 11143 1000 FHLB 20,000,000.00 20,000,000.00 20,000,000.00 1.200 1.177 20,000.00 0.00 0.00 20,000.00 3130AJQZ5 11190 1000 FHLB. 25,000,000.00 25,000,000.00 25,000,000.00 0.800 0.785 16,666.66 0,00 0.00 16,656.66 Portfolio INVT Data Updated: ~REPORT~: 08/13/2020 42:23 AP. Run Date: 08/13/2020 - 12:24 TE (PRF_TE) 7.3.6 Report Ver, 7.3.6.1 MARICOPA COUNTY TREASURER Selected Funds Total Earnings Page 3 July 1, 2020 - July 34, 2020 Adjusted Interest Earnings Ending Beginning Average Current Annualized Interest Amortization’ Realized Adjusted Interest cusiP Investment# Fund Issuer Par Value Book Value Book Value Rate Yield Earned Accretion Gainl/Loss Earnings Fund: Treasurer's Pool 3120AJRPS 210001 1000 FHLS. 15,210,000.00 9.00 9,317,622,74 0.680 0.845, 6,607.90 76.60 0.00 6,684.50 3134GBNTS 10397 1000 FHLMC. 30,000,000.00 30,000,000.00 30,000,000.00 1,700 1.668 42,500.00 0.00 0.00 42,500.00 3134GBJJ2 10405 1000 FHLMG 20,000,000.00 20,000,000.00 20,000,000.00 1,750 1.717 29,186.67 0,00 0.00 29,166.67 3134GB3J9 10564 1000 FHLMC 25,000,000.00 25,000,000.00 25,000,000.00 2,000 1.962 41,666.67 9.00 0.00 41,666.67 3134GB2A9 10571 1000 FHLMG 25,000,000.00 25,000,000,00 25,000,000.00 4,875 1.840 39,062.50 0.00 0.00 39,062.50 3134GBZ70 10572 1000 FHLMC. 25,000,000.00 25,000,000.00 25,000,000.00 1.875 1.840 39,062.50 9.00 0.00 39,062.50 3134GTR39 10965 1000 FHLMG 0.00 30,000,000,00 28,064,516.13 2.250 2.281 $4,375.00 0.00 0.00 54,375.00 3134GULJ7 11009 1000 FHLMG 0.00 20,000,000,00 18,709,677.42 2,000 2.028 32,222.22 0.00 0.00 32,222.22 3134GUMB3. 11019 1000 FHLMC 20,000,000.00 20,000,000.00 20,000,000.00 2.050 2.011 34,166.66 0,00 9.00 34,166.68 3134GUQ29 11067 1000 FHLMC. 9.00 30,000,000.00 4,838,709,68 2.050 2.078 8,541.67 9.00 9.00 8,541.67 3134GUWES 11074 1000 FHLMC 0.00 50,000,000.00 19,354,838.71 2.020 2.048 33,666.67 0.00 9,00 33,666.67 3134GUY53 11075 1000 FHLMC 0.00 24,990,916.67 12,092,400.54 1.950 1.986 20,312.50 83.33 9,000.00 29,395.83 3134GUW48 11076 1000 FHLMG 0.00 30,000,000.00 8,709,877.42 2.020 1.365 10,100.00 9.00 0.00 10,100.00 3134GUX62 11078 1000 FHLMG 9.00 25,000,000.00 21,774,193,55 2,000 1.502 27,777.78 9.00 0.00 27,777.78 3134GU4M9 11079 1000 FHLMC 9.00 25,000,000.00 21,774,193.55 2.000 1.502 27,777.78 0.00 9.00 27,777.78 3134GU3WS 11082 1000 FHLMC. 9.00 24,986,333.33 21,762,384.41 4.930 1.459 26,805.56 166,67 13,500.00 40,472.23 3134GUY87 11089 1000 FHLMG 9.00 25,000,000.00 21,774,193,55 2.000 1.727 31,944.44 0.00 0.00 31,944.44 3134GU3D0 141404 1000 FHLMC. 0.00 29,931 ,833.33 15,448,870.97 1.750 1.829 23,333.33 666.67 $7,500.00 91,500.00 3134GVAP3 11105 1000 FHLMC 30,000,000.00 30,000,000.00 30,000,000.00 2.125 2,085, 53,125.00 0.00 0,00 $3,125.00 3134GVBE7 11107 1000 FHLMC 25,000,000.00 25,000,000.00 25,000,000.00 2,250 2.208 46,875.00 9,00 0.00 46,875.00 3136G4PK3 10483 1000 FNMA 20,000,000.00 19,998,358.49 19,998,659.77 1.750 1,751 29,166.66 566.04 0,00 28,732.70 3135G0V34 10861 4000 FNMA 25,000,000.00 24,983,439.88 24,983,644.23 2.500 2.473 52,083.33 383,93 0,00 52,467.26 3135G0XS7 11088 1000 FNMA 0.00 25,000,000.00 21,774,193,55 2,000 1.727 31,944,44 0.00 0.00 31,944.44 3135G0Z5S 11118 1000 FNMA 20,000,000.00 20,000,000.00 20,000,000.00 1.260 1,236 21,000.00 0.00 0.00 21,000.00 3695508K3 11180 1000 GD 15,802,000,00 17 444,852.33 17,429,511.60 3.250 0.944 42,797.08 ~28,821.98 0.00 13,975.10 2021TANGU 210007 1000 GLNHSD 17,000,000.00 0.00 1,099,754.98 0.850 0.563 802,78 -277.07 0.00 §25.74 38141GWM2 11033 1000 GOLD 8,278,000,00 8,394,934.99 8,393,242.16 2.905 2.365 20,039.66 -3,180.46 0.00 16,859.20 38150ADT9 41087 1000 GOLD 0.00 25,000,000.00 21,774,193.55 2.050 1.694 31,319.44 0.00 0.00 31,319.44 38150AE27 41144 1000 GOLD 20,000,000.00 20,000,000.00 20,000,000.00 2.000 1,962 33,333.33 0,00 0,00 33,333.33. 381S0ADZ5. 11145 1000 GOLD 20,000,000.00 20,000,000,00 20,000,000.90 1.750 L717 29,186.67 0.00 0.00 29,166.67 38141W273 10680 1000 GSMM 807,000,000,00 557,000,000.00 798,935,483.87 0.00 9.00 9.00 0.00 38142S5B500 11023 1000 GSMM 0.00 9.00 0.00 0.00 0.00 9.00 0.00 437076BUS 411139 1000 HD 10,000,000.00 9,850,259.75 9,854,200.28 1.430 2.384 12,313.89 7,634.78 0.00 19,948.67 O2665WCTE 10927 1000 HNDA 15,000,000.00 18,403,796.25 15,398,723.30 3.550 2.664 44,375.00 -9,530.99 0.00 34,844.01 02665WDG3 11083 1000 HNDA 5,470,000.00 5,477,817.54 3,477,696.23 2.050 1.960 9,344,593 -227.92 0.00 9,116.67 438516BV7 11007 1000 HON 9,190,000.00 9,227,132.31 9,226,358,72 2.000 1.829 18,827.23 1,498.83 0.00 14,328.40 427866BC1 11034 1000 HSY 12,395,000.00 12,384,161.26 12,384,270,99 2,050 2.033 21,174.79 206.58 0.00 21,381.37 Portfolio INVT AP Data Updated: ~REPORT~: 08/13/2020 12:23 Run Dato: 08/13/2020 - 12:24 TE (PRF_TE) 7.3.6 Report Vor. 7.3.6.1 MARICOPA COUNTY TREASURER Selected Funds Total Earnings Page 4 July 1, 2020 - July 31, 2020 Adjusted Interest Earnings Ending Beginning Average Current Annualized Interest Amortization! Realized Adjusted Interest cusIP Investment# Fund — Issuer Par Value Book Value Book Value Rate Yield Earned Accretion Gaini/Loss Earnings Fund: Treasurer's Poot 911759MWS 10893 41000 HUD 4,000,000.00 4,000,000.00 4,000,000.00 2.618 2.569 8,726.66 0.00 0.00 8,726.66 45818WCP9 10995 1000 IADB 25,000,000.00 25,000,000.00 25,000,000.00 2.385 2.340 49,687.50 0,00 0,00 49,687.50 459200J8 10928 41000 IBM 10,000,000.00 9,970,416.22 9,970,755.09 3.000 3.027 25,000.00 636.67 0.00 25,636.67 459200JY8 10930 1000 IBM 10,000,000.00 9,984,514.11 9,984,688.53 3,000 2.987 25,000.00 333.33 0.00 25,333.33 459200JY8 10936 1000 IBM 45,000,000.00 15,059,508.57 15,058,826.92 3.000 2.832 37,500.00 1,280.67 0.00 36,219.33 459200KID2 11059 1000 (BM 10,000,000.00 10,025,822.85 10,024,501.27 2.305, 1.964 19,205.24 +2,482.97 9.00 16,722.27 459200JY8 11090 1000 IBM 13,130,000.00 13,615,209.77 13,609,651.88 3.000. 1.936 32,825.00 =10,442.14 0.00 22,382.89 459200HPS 11138 1000 «IBM 3,000,000.00 3,139,755.77 3,137,745.33 3,375 1.749 8,437.50 3,777.19 0,00 4,660,341 44932HAMS 11140 1000 IBM 17,525,000.00 17,873,035.07 17,862,116.87 3.600 2.094 52,284.53 -20,512.87 0.00 31,771.66 45905U6RO 10888 1000 = IBRD 25,000,000.00 25,000,000.00 25,000,000.00 2.770 2.718 57,708.34 0.00 0.00 87,708.34 45905U2Z6 10935 1000 IBRD 35,000,000.00 35,000,000.00 35,000,000.00 2,480 2.433 72,333.33 0.00 0,00 72,333.33 4590SU6WS 10960 1000 IBRD 0.00 25,000,000.00 11,290,322.58 2,300 2.332 22,361.11 0.00 0.00 22,361.11 459058GHO 11014 1000 = IBRD 30,000,000.00 30,326,849,52 30,313,214.69 2.750 4.673 68,750.00 -25,668,.81 0.00 43,081.19 459058HQ9 11035 1000 IBRD 20,000,000.00 20,000,000.00 20,000,000.00 2.160 2.119 36,000.00 0.00 0.00 36,000.00 4590SU4US 11037 1000 IBRD 25,000,000.00 25,000,000.00 25,000,000.00 1,810 4.776 37,708.33 0.00 0.00 37,708.33 459058HV8 12091 41000 IBRD 50,000,000.00 50,000,000,00 50,000,000.00 2.050 2.011 85,416.67 0,00 9.00 85,416.67 45866FAE4 10972 1000 ICE 20,000,000.00 20,161,389.13 20,158,143,51 2.350 1.932 39,166.67 6,097.83 90.00 33,068.84 2021TANIE 210008 1000 ISUSD 17,000,000.00 0.00 1,099,754.98 0.850 0.563 802,78 -277.07 0.00 525.71 4812C0670 10654 1000 = JMPMM. 0,00 235,000,000.00 121,290,322.58 0.00 0,00 9.00 0.00 4812A0375 10679 1000 = JMPMM 0,00 135,000,000.00 69,677,413.35 0,00 0.00 0.00 0,00 4812A2785 11120 1000 JMPMM 0.00 9,00 0.00 0.00 0.00 0.00 9.00 XXX1518 10006 1000 = JPM 50,899,110.44 200,899,110.44 128,318,465,28 0.230 25,066.05 0.00 0.00 25,066.05 46625HJXE 10943 1000 = JPMIG 10,000,000.00 10,384,768.03 10,380,408.05 3,625 2.524 30,703.55 8,447.46 0,00 22,256.09 48128GG73 11063 1000 JPMIG 25,000,000.00 25,000,000.00 25,000,000.00 2.250 2.195 46,616.03 9.00 0.00 46,616.03 48128GM49 10975 1000 «= JPMIG 25,000,000.00 25,000,000.00 25,000,000.00 2.300 2.287 47,916.67 9.00 0.00 47,916.67 48130UTJ4 11096 1000 JPMIG 0,00 25,000,000.00 24,193,548.39 2.000 1.960 40,277.78 0.00 0.00 40,277.78 46625HRL6 14102 1000 = JPMIG 8,825,000.00 8,987,532.91 8,985,030.23 2.700 1.986 19,856.25 4,702.01 0.00 15,154.24 48128GU40 11187 1000 JPMIG. 25,000,000.00 25,000,000.00 25,000,000.00 1.050 1.030 21,875.00 0.00 0,00 21,875.00 48130UUQ6 11188 1000 = JPMIG 25,000,000.00 25,000,000.00 25,000,000.00 1,000 0.981 20,833.34 0.00 0.00 20,833.34 191216CL2 10987 1000 = KO 15,000,000.00 15,000,000.00 15,000,000.00 1.750 4.717 21,875.00 0.00 0.00 21,875.00 110122BY3 11116 1000 = KO 10,000,000.00 10,295,889.24 10,288,889.71 2.600 0.975 21,666.67 -13,150.63 0.00 8,516.04 567320GT7 11191 1000 = LITESD 700,000.00 704,410.00 704,214.40 1.000 0.361 583.33, -367.50 0,00 215.83 567320GT9 11193 1000 LITESD 400,000.00 402,768.45 402,727.52 4.000 0.750 333.34 -76.90 0.00 256.44 567320610 11194 1000 = LITESD 400,000.00 402,802.99 402,771.91 1,000 0.804 333.34 -58,39 0,00 274.95 567320611 11195 41000 LITESD 350,000.00 352,471.12 352,449.20 1.000 0.837 291.67 “41.18 0,00 250.49 §67320GTB 11192 41000 LITESD 1,100,000.00 1,107,430.10 4,107,265,32 1.000 0.646 916,67 -309.58 9.00 607.09 §7629WCDO 10925 1000 MASSMU 20,000,000.00 19,949,761.82 19,951 ,011.34 2.500 2,598 41,666.67 2,347.58 9.00 44,014.25 Portfotio INVT AP Data Updated: ~REPORT~: 08/13/2020 12:23 Run Date; 08/13/2020 - 12:24 TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 MARICOPA COUNTY TREASURER Selected Funds Total Earnings Page 5 July 1, 2020 - July 31, 2020 Adjusted Interest Earnings Ending Beginning Average Current Annualized Interest Amortization/ Realized Adjusted Interest cuUsIP Investment# Fund Issuer Par Vaiue Book Value Book Value Rate Yield Earned Accretion Gainl/Loss Earnings Fund: Treasurer’s Pool MESD1R 10953 1000 += MESD 0.00 330,000.00 0.00 2.130 0.00 0,90 0.00 0.00 MESD2R 10954 1000 = MESD 235,000.00 335,000.00 335,000.00 2.130 2.090 594.63 0.00 0.00 594.63 MESDS3R 10985 1000 = MESD 345,000.00 345,000,00 345,000.00 2.130 2.090 612.38 0.00 9.00 612.38 MESD4R 10956 1000 MESD 350,000.00 350,000.00 350,000.00 2.130 2.090 621.25 0,00 0.00 621.25 MESDSR 10987 1000 MESD 355,000.00 355,000.00 355,000.00 2.130 2.090 630,13 0.90 0.00 630.13 sess97WwW2 11152 1000 += MESSD4 4,750,000.00 4,764,627.71 4,783,978.90 0.950 (0.628 3,760.41 “1,218.98 0,00 2,541.43, 566897 WW0 11153 1000 MESSD4 2,125,000.00 2,134,673.55 2,134,459.01 0.950 0.706 1,682.29 ~403.07 0.00 1,279.22 Se6897WXE 11184 1000» MESSD4 13,000,000.00 13,065,313.83, 18,064,348.17 0.950 0.764 10,291.66 -1,814.27 0.00 8,477.39 S6689YWY6 41155 1000 MESSD4 10,125,000.00 10,168,593.71 40,188,110.31 0.950 0,823 8,015.63 -908.20 0.00 7,107.43 59156RBHO 11003 1000 MET 42,150,000.00 12,769,322.33 12,762,045,53 3.600 2.102 36,450.00 -13,671,57 9.00 22,778.43 60687YAP43 10959 1000 = MIZUNY 15,000,000.00 15,364,691.32 15,358,650.56 3.549 2.531 44,362.50 -11,349.34 0.00 33,013.19 60687YAV1 11004 1000 MIZUNY 20,000,000.00 20,167,872.86 20,165,424.87 2.721 2.379 45,350.00 4,599.25 0,00 40,750.75 60687YAH2 11062 1000 MIZUNY 6,575,060.00 6,663,306.12 6,660,944.23 2.953 2.076 16,179.98 4,437.43 0.00 41,742.49 eoss7YAse = 11173 1000 = MIZUNY 6,208,000.00 6,665,125.98 6,680,260.30 3.922 1.969 20,280.01 -9,141.57 0,00 11,138.44 88579YBBS 10919 1000 MMM 10,000,000.00 10,210,083.23 10,207,508.74 3.250 2,566 27,083.33 4,836.92 0.00 22,246.44 88579YAXO 10946 1000 MMM 20,000,000.00 20,046,484.71 20,045,722.64 2.250 2.419 37,500.00 ~1,431.76 0.00 36,068.24 88573YBEO = 11025 1000 =~ MMM 16,387,000.00 16,393,801.02 16,393,718.77 2.475 2.497 34,924.80 ~159.35 0,00 34,765.45 594918BX1 10896 1000 MSFT 25,000,000.00 25,300,558.74 25,296,852.76 2.875 2.464 59,895.83 -6,962.75 0.00 52,933.08 64255AW26 10894 4000 MUFG 10,000,000.00 10,273,705.39 10,270,416.86 3.750 2.874 31,250.00 6,178.45 0.00 25,071.55 606822AQ7 11132 1000 MUFG §,000,000.00 4,963,434.49 4,964,210,42 1.630 2.021 7,018.05 1,503.36 0.00 8,521.41 641062AD6 11068 1000 NESNVX 25,000,000.00 26,063,469.85 26,048,368.64 3.350 4.915 69,791.67 27,432.58 9.00 42,359.09 63743HERS 10911 1000 NRUC 14,003,000.00 14,036,419.94 14,034,318.99 2.900 2.508 33,840.59 3,947.23 9.00 28,893.36 63743HEQ1 10924 4000 NRUC 6,000,000.00 §,955,757.21 5,956,646.96 2,300 2.604 11,500.00 1,671.65 0.00 13,171.65 665279873 10424 4000 NTMM 0.01 0.01 0.01 0.00 0,00 0.00 0,00 68389XBC38 11189 4000 ORCL §,000,000.00 5,463,065.97 5,458,850.39 2.900 0.898 12,083.33 -7,920.17 0.00 4,163.16 $9371RP83 10926 1000 PCAR 20,000,000.00 19,993,310,00 19,993,469.68 2.650 2.619 44,166.67 300.00 9.00 44,466.67 6937 1RQ66 19104 4000 PCAR 5,000,000.00 §,019,735.55 §,019,545.14 1,800 1.675 7,500.00 =357,74 0.00 7,142.26 2021TANPE 210003 4000 PENUSD 10,000,000.00 0.00 646,914.69 0.850 0.563 472,22 -162.99 0.00 309.23 2021TANPU 210010 1000 PEORSD 45,000,000.00 9.00 970,372.04 0.850 0.563 708.33 244.48 0.00 463.85 717081 EX7 11161 14000 PFIZER 10,006,000.00 10,000,000.00 10,000,000.00 9.800 0.785. 6,666.67 0.00 0.00 6,666.67 PHXE016B 10217 4000 PHOESD 0.00 2,025,000.00 0.00 3.570 0.00 0.00 0,00 9,00 PHXEO16C 10218 1000 PHOESD 4,130,000.00 4,214,275,04 4,210,537.03 3.570 1,472 12,286,758 -7,022.92 0,00 5,263.83 567505QS¢ 11168 1000 PHOHSD 1,200,000.00 1,202,028.43 1,201,938.46 0.790 0.608 790.00 -169,04 0.00 620.96 §67505QT2 11169 1000 PHOHSD 6,550,000.00 6,570,765.41 6,570,304.89 0,790 0.618. 4,312.08 ~865,22 0.00 3,446.86 567505QU9 11170 1000 PHOHSD 10,000,000.00 10,032,574.51 10,032,092.89 0.790 0.666. 6,583.33 ~904,85 0.00 5,678.48 567505QV7 41171 1000 PHORSD 13,650,000.00 13,676,803,64 13,676,506.42 0,790 0.726 8,986.25 -558.41 0.00 8,427.84 718172BU2 10958 1000 PM §,000,000.00 4,958,057.07 4,958,707.92 2.125 2.393 8,854.17 1,222.82 0.00 10,076.99 Portfolio INVT AP Data Updated: ~REPORT~: 08/13/2020 12:23 Run Dato: 08/13/2020 - 12:24 TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.4 MARICOPA COUNTY TREASURER Selected Funds Total Earnings Page 6 July 4, 2020 - July 31, 2020 Adjusted Interest Earnings Ending Beginning Average Current Annualized Interest Amortization’ Realized Adjusted Interest CUSIP Investment# Fund Issuer Par Value Book Value Book Value Rate Yield Earned Accretion Gainl/Loss Earnings Fund: Treasurer's Pool 718172CHO 41074 1000 PM 10,518,000.00 10,834,320.17 10,830,660,08 2.875 1.992 25,199.38 ~6,876.53 0.00 18,322.85 718172CN7 11149 1000 «PM 28,000,000.00 26,976,761.27 24,976,974.53 1,500 1,492 31,250.00 400,67 0.00 31,680.67 7181720N7 411172 1000 PM 6,108,000.00 6,239,179,93 6,237,976.11 1,500 1,014 7,635.00 ~2,261,72 9.00 5,373.28 74977RDFS 11001 1000 RABOBK 20,000,000.00 20,329,193,82 20,325,595.95 2.625 2.143 43,750.00 6,759.63 0.00 36,990.27 78014RCMO 11146 1000 RBC 20,000,000.00 20,000,000.00 20,000,000.00 1,500 1.472 25,000.00 0.00 0.00 25,000.00 78014ROX6 41187 1000 RBC 25,000,000.00 25,000,000.00 25,000,000.00 1.150 4.128 23,958.34 0.00 0.00 23,958.34 822852CC4 11038 1000 ROSALN 10,000,000.00 9,949,052.57 9,949,572.05 2.000 2.088 16,666.67 976.00 0.00 17,642.67 822582CA8 411065 1000 RDSALN 25,008,000.00 25,067 ,462.85 25,066,585.28 2.305 2.281 49,613.56 ~1,700,29 0.00 47,913.27 822582AX0 411129 1000 RDSALN 1,458,000,00 1,530,392.76 4,529,361.58 3.400 1,689 4,131.00 1,937.36 9.00 2,193.64 822582BZ4 41131 1000 RDSALN 6,594,000.00 6,951,214.96 6,946,508.76 3.500 4.761 19,232.50 +8,841.95 0.00 10,390.55 RVR2016B1_3 10243 1000 RIVESD 0.00 1,650,000.00 9.00 1.300 0,00 9,00 0.00 0.00 RVR2016BI_4 10244 1000 RIVESD 1,355,000.00 1,355,000.00 41,355,000.00 1.420 1,393 1,603.42 0,00 0.00 1,603.42 RVR2016R_3 10247 1000 RIVESD 0.00 1,045,000.00 0.00 4.500 0.00 0.00 0.00 9.00 RVR2016R_4 10248 1000 RIVESD 1,095,000.00 1,095,000.00 4,095,000.00 1.420 1,393 1,295.75 0,00 0.00 1,295.75 78014RCY4 11174 1000 RY 25,000,000.00 25,000,000.00 25,000,000.00 1,000 4.003 21,296.29 0.00 0,00 21,296.29 2021TANSM 210011 1000 SADUSD 4,000,000,00 0.00 258,765.88 0,850 0.563 188.89 65.19 0.00 123.70 SCFDO18B 10592 1000 SCFD 0,00 58,000.00 0.00 6.140 0.00 9.00 0,00 0.00 SCFDO18C 10593 1000 SCFD 62,000.00 64,181.23 64,084.48 6.140 2.489 317,23 -181.77 0.00 135.46 SCFDO18D 10594 1000 SCFD 65,000.00 69,373.20 69,276.21 6.140 2.556 332,59 =182.22 0.00 150,37 808513AT2 10891 1000 SCHW 25,000,000.00 25,069,450.98 25,068,250.79 2.650 2.487 55,208.34 -2,254.90 0.00 52,953.44 2021TANSU 210012 1000 SCUSD 15,000,000.00 0.00 970,372.04 0.850 0.563 708.33 7244.48 9.00 463.85 86562MBM1 10961 1000 SUMMIT 10,000,000.00 9,993,210.00 9,993,284,.52 2.696 2.664 22,466.66 140.00 0.00 22,606.66 86562MAEO 10966 1000 SUMMIT 17,158,000.00 17,181 847.98 17,152,111.34 2.058 2.054 29,425.97 494.80 0.00 29,920.77 86562MAT7 11006 1000 SUMMIT 14,016,000.00 14,055,891.91 14,055,016.74 2.000 1.879 24,128.33 ~1,695.65 0.00 22,432.68 86562MAT7 11040 1000 SUMMIT 5,495,000.00 5,515,944,08 $,515,544.67 2.000 1.885 9,463.61 ~773.86 9,00 8,689.75 86562MBT6 11069 1000 SUMMIT 41,072,000.00 41,159,532.19 11,158,616,27 2.448 2.202 22,586.88 1,720.82 0,00 20,866.06 86562MAWO 11110 1000 SUMMIT 5,000,000.00 §,036,719.73 5,036,079.63 1.810 1.482 7,541.66 -1,202.61 0,00 6,339.05 86562MAWO 14118 1000 SUMMIT 1,846,000.00 1,851,964.15 1,851 ,860,19 1.810 1.646 2,784.38 +195.33. 0.00 2,589.05 B6562MAX8 419151 1000 SUMMIT 25,000,000.00 25,931,126.60 25,914,895.17 3.102 1.581 64,625.00 -30,495.44 0.00 34,129.59 892331ABS 10898 1000 TOYCC 17,000,000.00 17,100,389.12 17,096,159.60 3.183 2.558 45,092.50 -7,946.37 0.00 37,146.13 89236TFXS 10904 1000 TOYCC 15,000,000.00 14,994,391.25 14,994,530.97 2.650 2.622 33,125.00 262.50 0.00 33,387.50 89236TFNO 10920 1000 TOYCC 10,000,000.00 10,226,735.34 10,223,611.57 3.450 2.635 28,780.00 -5,868.91 0.00 22,881.09 89236TGM1 14000 1000 TOYCG 20,000,000.00 20,000,000,00 20,000,000.00 1.875 1,840 31,250.00 0,00 0.00 31,250.00 89236TDP7 41017 1000 TOYCS 42,000,000.00 12,128,741.77 12,125,011.66 2.600 1,843 26,000.00 -7,022.28 0.00 18,977.72 89236TDP7 11018 1000 TOYCS 8,000,000.00 8,089,949,37 8,087,343.21 2.600 1,809 17,333.34 4,306.33 0,00 12,427.01 89236TGQ2 11039 1090 TOYCG 25,000,000.00 25,000,000.00 25,000,000.00 2,125 2.085 44,270.83 0.00 0.00 44,270.83 89236TFR1 11127 1000 TOYCS 2,500,000.00 2,500,426.90 2,500,391.14 1.320 1.306 2,841.67 69,28 0.00 2,772.39 Portfolio INVT AP Data Updated: ~REPORT™~: 08/13/2020 12:23 Run Dato; 08/13/2020 - 12:24 TE (PRF_TE) 7.3.6 Roport Ver. 7.3.6.1 MARICOPA COUNTY TREASURER Selected Funds Total Earnings July 1, 2020 - July 31, 2020 Adjusted Interest Earnings Page 7 Ending Beginning Average Current Annualized interest Amortization/ Realized Adjusted Interest cusIP Investment# Fund Issuer Par Value Book Vatue Book Value Rate Yield Earned Accretion Gaint/Loss Earnings Fund: Treasurer's Pool 89236TEW1 11148 1000 TOYCC 15,000,000.00 16,266,466.27 16,254,729,.42 3.400 1.481 42,500.00 -22,051.06 0.00 20,448.94 89236TDKS 11160 1000 TOYS 8,161,000.00 8,451,534.20 8,447,625.88 2.250 1,103 18,301.88 7,342.91 9.00 7,958.97 89236THC2 11185 1000 TOYCG 25,000,000.00 25,000,000.00 25,000,000.00 1,000 0,981 20,833.34 9.00 0.00 20,833.34 904764AXS 10988 1000 UNANA 5,000,000.00 $,123,659.90 5,122,233.19 2,600 1,874 10,833.33 ~2,680.48 0.00 8,152.85 904764AX5 11144 1000 UNANA 15,000,000.00 1§,203,114.38 15,200,770.97 2.600 2.176 32,500.00 4,402.77 0,00 28,097.23 91324PCNO 11036 1000 UNC 5,000,000.00 §,147,451,93 5,144,244.20 3.350 1.815 13,958.33, -6,026.64 0.00 7,931.69 911312BC3 10944 1000 UPS 17,430,000.00 17,477,128.49 17,476,013.62 2.350 2,159 34,133.75 2,094.60 0.00 32,039.15 90331HNL32 10889 1000 USBNK 8,300,000.00 8,333,980.66 8,333,392.16 2.850 2.629 19,712.50 -1,105.66 0.00 18,606.84 91159HHVS 10899 1000 USBNK 12,000,000.00 12,200,588,58 12,198,113.35 3.375 2.809 33,750.00 -4,650,43 9.00 29,099.57 90331HPF4 11126 1000 USBENK 20,000,000.00 20,397 484.37 20,390,494.36 1.950 1.418 32,500.00 713,132.75 9.00 49,367.25 567021SE0 11187 1000 WASHSD 2,325,000.00 2,344,647 .47 2,343,776.01 1,500 0.637 2,906.25 ~1,637.29 0.00 1,268.96 567031SF7 11182 1000 WASHSD 1,575,000.00 1,600,913,43 1,600,338.74 1.500 0.654 1,988.75 ~1,079.72 0.00 889.03 961214DA8 10910 1000 WESTP 14,449,000.00 14,336,899,35 14,341,286.59 2.000 2.654 24,081.67 8,242.70 0.00 32,324.37 961214DS9 10923 1000 WESTP 7,588,000.00 7,563,821.82 7,564,246,07 2.750 2.831 17,389.16 797.08 0.00 18,186.24 961214DG5 11030 1000 WESTP 20,000,000.00 20,241 ,887.76 20,234,865,21 2.800 1.948 46,666.67 ~13,193.88 0.00 33,472.79 961214DB6 11052 1000 WESTP 20,000,000,00 20,132,069.42 20,126,965.29 2.753 2.195 47 406.41 ~$,889.25 9.00 37,517.16 94988 J5P8 10876 1000 WFEC 0.00 9,434,537.34 8,216,548.14 3.325 2.572 19,128.72 ~1,182.78 -19,354,56 -1,408.62 95000U2C6 10903 1000 WFEC 40,000,000.00 10,208,869.12 10,206,269.62 3.750 3.042 31,250.00 4,883.92 0.00 26,366.08 95000U2C6 10921 1000 WFBC 20,000,000.00 20,474,604.47 20,468,697.71 3.750 2.957 62,500.00 -11,097.54 9.00 51,402.46 95000U2B8 11022 1000 WFBC 40,000,000.00 10,106,149.39 10,103,861.98 2.625 2.048 21,875.00 4,297.55 9.00 17,877.45 95001DSES 11028 1000 WFEC 30,000,000,00 30,000,000.00 30,000,000.00 2.300 2.257 87,500.00 0.00 0.00 87,500.00 949746SA0 11029 1000 WFBC. 24,646,000.00 24,667,154.15 24,666,276.79 2.100 1.980 43,130.50 -1,648.37 0.00 41,482.13 95001D5SR7 11097 1000 WFBC 20,000,000.00 20,000,000.00 20,000,000.00 2.250 2,208 37,500.00 0.00 0.00 37,500.00 95001D5Q9 11098 1000 WFBC. 0.00 20,000,000.00 10,322,580,65 2.000 2,028 47,777.78 0.00 0.00 17,777.78 95001D5Q9 171099 1000 WFBC, 0.06 25,000,000.00 12,903,225.81 2,000 2.028 22,222.22 9.00 0.00 22,222.22 95001D5R7 11160 1000 WFBC. 30,000,000.00 30,000,000.00 30,000,000.00 2.250 2,208 56,250.00 0.00 0.00 56,250.00 9500IDSWE 11108 1000 WFBC. 25,000,000.00 25,000,000.00 25,000,000.00 1,900 1.926 40,902.77 0.00 0.00 40,902.77 95001DSY2 11136 1000 WFBC. 15,000,000,00 45,000,000.00 15,000,000.00 1.750 W717 21,875.00 0.00 0.00 21,875.00 95001D5Y2 11137 1000 WFBC. 20,000,000,00 20,000,000.00 20,000,000.00 1.750 717 29,166.67 0,00 9,00 29,166.67 95001D6F2 11147 1000 WFBC 25,000,000.00 25,000,000,00 25,000,000.00 2,750 2.698 57,291.66 0.00 0.00 57,291.66 95001D7E4 11156 1000 WFBC. 25,000,000.00 25,000,000.00 25,000,000.00 1,500 4472 31,250.00 0,00 0.00 31,250.00 95001D7M6 11158 41000 WFBC 20,000,000.00 20,000,000.00 20,000,000.00 1,300 4.276 21,666.66 0.00 0.00 21,666.66 95001D7L8 11159 1000 WFBC. 20,000,000.00 20,000,000.00 20,000,000.00 1.700 1.668 28,333.34 0.00 0.00 28,333.34 95000U2C6 11175 1000 WFBC. 10,785,000,00 11,642,994.23 11,632,315.96 3.750 1.381 33,703.13 ~20,062.22 0,00 13,640.91 95001DAC4 11184 1000 WFBC 25,000,000.00 25,000,000.00 25,000,000.00 1.250 1.226 26,041.66 0.00 9.00 26,041.66 95001DAWO 210003 1000 WFBC 25,000,000.00 0,00 12,096,774.19 1,150 1.088 14,180.56 0.00 0.00 14,180.56 Subtotal 4,584,446,110.45 4,836,586,503.47 5,079,658,583.85 1.316 6,128,334.77 -530,601.86 80,845.44 5,678,278.35 Portfolio INVT AP Data Updated: ~REPORT~: 08/13/2020 12:23 Run Dato: 08/13/2020 - 12:24 TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 MARICOPA COUNTY TREASURER Selected Funds Total Earnings July 1, 2020 - July 31, 2020 Adjusted Interest Earnings Page 8 Ending Beginning Average Current Annualized Interest Amortization! Adjusted Interest cusiP Investment# Fund Issuer Par Value Book Value Book Value Rate Yield Earned Accretion Gainl/Loss Earnings Fund: MIHS Bond Proceeds 313396ZR7 11041 S34BP FHLMC 0.00 35,327 ,535.84 22,801,938.40 1,500 1,521 0.00 29,464.16 0.00 29,464.16 912828NT3 11044 534BP USTR 34,500,000,00 34,542,701 .02 34,527,518.43 2.625 1,627 77,127.40 29,416.26 0.00 47,711.14 Subtotal 34,500,000.00 69,870,236.86 §7,329,456.84 1.585, 77,127.40 47.90 0.00 77,175.30 Fund: MIHS Debt Service 665279873 10425 5340S NTMM -25,718.42 725,718.42 ~25,718.42 0,00 0.00 0,00 0.00 Subtotat -25,718.A2 25,718.42 -25,718.42 0.00 0.00 0.00 0.00 Fund: MIHS Maintenance & Ops O6406FA89 40906 534MO BONYM 8,576,000,00 8,530,085.61 8,532,513.26 2.050 2.651 14,650.66 4,561.03 0.00 19,211.69 3133EKGY6 1090S 534MO FFCB 25,845,000.00 25,820,585.83 25,831,396.26 2,378 2,401 51,151.56 1,522.63 0.00 $2,674,193 717081DX8 40907 534MOQ PFIZER 7,194,000.00 7,156,722.10 7,158,515.01 1,950 2477 11,690.25 3,368.49 0,00 15,058.74 822582880 10908 534MO RDSALN 8,529,000.00 8,486,157.86 8,488,888.50 1.875 2.562 13,342.19 5,130.30 0,00 18,472.49 Subtotal 50,154,000.00 $0,003,551.40 50,011,313.03 2.482 90,834.66 14,582.45 0.00 105,417.11 Total 4,669,074,392.03 4,956,434,573.31 §,186,973,635,29 1.330 6,296,296.83 ~515,971.51 80,545.44 5,860,870.76 Portfolio INVT AP Data Updated: ~REPORT~: 08/13/2020 12:23 Run Date: 08/13/2020 - 12:24 TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 Maricopa County MARICOPA COUNTY TREASURER Selected Funds Total Earnings Sorted by Fund - Issuer July 1, 2020 - July 31, 2020 Adjusted Interest Earnings Ending Beginning Average Current Annualized Interest Amortization/ Realized Adjusted Interest CUSIP Investment# Fund Issuer Par Value Book Value Book Value Rate Yield Earned Accretion Gaint/Loss Earmings Fund: Treasurer's Pool Subtotal 4,584,446,110.45 4,836,586,503.47 §,079,658,583,35 4.316 6,128,334.77 530,601.86 80,545.44 5,878,278.35. Fund: MIHS Bond Proceeds Subtotal 34,500,000.00 69,870,236.86 $7,329,456.84 1.585 77,127.40 47.90 0.00 77,178.30 Fund: MIHS Debt Service Subtotal -25,718.42 -25,718.42 25,718.42 0,00 0.00 0.00 0.00 Fund: MIHS Maintenance & Ops Subtotal 50,154,000.00 50,003,551.40 $0,011,313.03 2.482 90,834.66 14,582.45 0.00 105,417.11 Total 4,669,074,392.03 4,956,434,573.31 §,186,973,635,.29 1.330 6,296,296.83 515,971.51 80,545.44 5,860,870.76 Portfotio INVT AP Data Updated: ~REPORT~: 08/13/2020 12:22 Run Date: 08/13/2020 - 12:22 TE (PRF_TE) 7.3.6 Roport Ver, 7.3.6.1