Extracted text (via pymupdf)
45845 characters
Royce T. Flora, Treasurer 301 West Jefferson St., Rrn. 100 Phoenix, Arizona 85003 Phone: (602) 506-8511 Fax: (602) 506-1102 http://treasurer.maricopa.gov Maricopa County Treasurer CoRected Levy, $4622143,O61, 88% Unctlected Levy, $632452,034 • 12% DATE: . May 12, 2020 TO: Clint Hickman, Chairman Jack Sellers, Supervisor, District 1 Steve Chueri, Supervisor, District 2 Bill Gates, Supervisor, District 3 Steve Gallard°, Supervisor, District 5 SUBJECT: Treasurer's Collections and Investment Summary for April 2020 Secured property tax collections during the month of April equaled $1,170,381,924 and increased the 2019 year to date collections to 54,622,143,061 or 88% of the adjusted 2019 levy of 55,254,295,095 The chart below reflects the 2019 collected and uncollected levy amount and corresponding percentages for the 2019 property tax year. April 2020 Colfected Levy •Lincollected Levy The County's General Fund Balance totaled $335,375,708.58 effective April 30, 2020. Warrants outstanding of $3,714,987.45 will post against the fund balances when presented. AS52142j KAREN D SW111 tidaly Public - Arimia MariavaCooty My Carol Elpies Dec 15, 2021 0 The S20,4.47,512, unencumbered balance, of the County Municipal Line of Credit and the S1.4,552,488. Workers Compensation Liability Letter of Credit remain unused. Russellk. Pearce. Chief Deputy Treasurer STATE 0 • ARIZONA ) ss. COUNTY 0.F MAR ICOPA ) This instrument was acknowledged before me. this 12th day of May 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 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. Notary Public My Commission Expires Mancopa County MAR1COPA COUNTY TREASURER Selected Funds Total Earnings Sorted by Fund - Purchase Date April 1, 2020 - April 30, 2020 Adjusted Interest Earnings CUSIP Investment # Fund Issuer Ending Par Value Beginning Book Value Average Current Annualized Book Value Rate Yield Interest Earned Amortization/ Accretion Realized Adjusted Interest Gainnoss Earnings loco low 1000 lax low l000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Fund: Treasurers Pool XXX.1518 10006 PHXE01613 10217 PHXE016C 10218 665279873 10424 RVR2016131_3 10243 RVR2016B1_4 10244 RVR2016R_3 10247 RVR2016R_4 10248 3136G4FO1 10264 3136G4FT5 10265 3136G4GD9 10276 3136G4GK3 10277 3134GAWJ 9 10293 3134GBJJ2 10405 3134GBNT5 10397 3136G4PK3 10483 3133EHJ95 10517 3134GB3J9 10564 3134GB2A9 10571 3134GBZ70 10572 SCFD018B 10592 SCFD0186 10593 SCFD018D 10594 3133EJKY4 10651 481260670 10654 09248U718 10661 4812A0375 ' 10679 38141W273 10680 3133EJNW5 10702 3133EJNW5 10703 J PM PHOESD FHOESD NTMM RIVESD RIVESD RIVESD RIVESD FNMA FNMA FNMA FNMA FHLMC FHLMC FHLMC FNMA FFCB FHLMC FHLMC FHLMC SCFD SCFD SCFD FFCB JM PM M BLKMM JMPMM GSMM FFCB FFCB 525,790,011.66 2,025.000.00 4,130,000.00 0,01 1,650,000.00 1,355,000.00 1,045,000.00 1,095,000.00 0.00 0.00 0.00 0.00 20,000,000.00 20,000,000.00 30,000,000.00 20,000,000.00 16,000,000.00 25,000,000.00 25,000,000.00 25,000,000.00 58,000.00 62,000.00 65,000.00 0.00 235,000,000.00 0.00 35,000,000.00 427,000,000,00 25,000,000.00 25,000,000.00 37,755,120.76 2,035,969.82 4,235,343.80 0.01 1,650,000.00 1,355,000.00 1,053,133.67 1,095,000.00 25,000,000.00 30,000,000.00 25,000,000.00 20,000o00o0 20,000,000.00 20,000,000.00 30,000,000.00 19,996,660.38 15,996,979.35 25,000,000.00 25,000,000.00 25,000,000.00 58,535.42 64,726.54 69,919.85 19,999,936.40 0.00 0.00 0.00 257,000,000,00 24,999,694.44 24,999,694.44 212,989,617,12 0.199 2,034,080.57 3.570 1.416 4,231,715.29 3.570 1.513 0.01 1,650,000.00 1.300 1.318 1,355,000.00 1.420 1.440 1,051,732.88 4.500 1,397 1,095,000.00 1.420 1.440 21,666,666.67 1.400 1.419 26,000,000.00 1.405 1.425 22,500,000.00 1.300 1.318 18,000,000.00 1,350 1.369 20,000,000.00 1.400 1.419 20,000,000.00 1.750 1.774 30,000,000,00 1.700 1,724 19,996,952.83 1,750 1.809 15,997,207.74 1.750 1.808 25,000,000.00 2.000 2.028 25,000,000.00 1.875 1.901 25,000,000.00 1.875 1.901 58,443.21 6.140 2.463 64,632.63 6.140 2.550 69,825.70 6.140 2.620 7,999,988.34 2.375 2.418 72,166,666.67 0.00 4,666,666.67 220,166,666.67 24,999,802.08 2.550 2,596 24,999,802.08 2.550 2.596 34,890.90 6,024.37 12,286.75 0.00 1,787.50 1,603.42 3,918.75 1,295.75 25,277.78 30,441.67 24,375.00 20,250.00 23,333.33 29,166.67 42,500.00 29,166.66 23,333,33 41,666.67 39,062.50 39,062.50 296.76 317.23 332.59 15,833.33 0.00 0.00 0.00 0.00 53,125.00 53,125.00 0.00 -3,656.61 -7,022.92 0.00 0.00 0.00 -2,711.22 0.00 0.00 0.00 0,00 0,00 0.00 0.00 0.00 566.04 442.05 0.00 0.00 0.00 -178.47 -181.77 -182.22 63,60 0.00 0.00 0.00 0.00 208.34 208.34 34,890.90 2,367.76 5,263.83 0.00 1,787.50 1,603.42 1,207.53 1,295.75 25,277.78 30,441.67 24,375.00 20,250.00 23,333.33 29,166,67 42,500.00 29,732.70 23,775.38 41,666.67 39,062.50 39,062.50 118.29 135,46 150,37 15,896.93 0.00 0.00 0.00 0.00 53,333.34 53,333.34 Portfolio INVT Data Updated: -REPORT-: 0511212020 09:56 AP Run Data: 05(12/2020 - 09:56 TE (P1RF_TE) 7.3.5 Report Var. 7.3,6,1 MAR1COPA COUNTY TREASURER Selected Funds Total Earnings Page 2 April 1, 2020- April 30, 2020 Adjusted Interest Earnings CUSIP Investment # Fund Issuer Ending Par Valuo Beginning Book Value Average Current Annualized Book Value Rate Yield Interest Earned Amortization/ Accretion Realized Adjusted Interest GainI/Loss Earnings 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 0.00 0.00 0.00 0.00 0,00 0,00 0.00 0.00 0.00 0.00 0.00 0.00 0.04 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0,00 0.00 0.00 0.00 0.00 0,00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Fund: Treasurers Pool 3130ACTU 8 10705 09248U700 10737 3133EJWJ4 10739 3133EJWJ4 10740 3133 EJT90 10789 09248U551 10825 3135GOV34 10861 037833CQ1 10875 94968J5P8 10876 45905U6R0 10E188 90331 HNL32 10889 808513AT2 10891 911759MW5 10893 64255AVV26 10894 5949185X1 10896 3134GS6L4 10897 892331AB5 10898 91159HHV5 10899 3134GS6NO 10901 3134GS6M2 10902 95000U2C6 10903 89236TFX8 10904 961214DA8 10910 63743HER9 10911 88579YBB6 10919 89236TFNO 10920 95000U2C6 10921 12572QAE5 10922 961214DS9 10923 63743H EQ1 10924 57629WCDO 10925 69371RP83 10926 02665WCT6 10927 459200JY8 10928 1941 6QELO 10929 459200JY8 10930 166764BK5 10931 FHLB BLKMM FFCB FFCB FFCB BLKMM FNMA APPL VVFBC I BRD USBNK SCHW HUD MUFG MST rHuvic TOYCC USBNK FHLMC FFILMC VVFBC TOYCC VVESTP N RUC IVIMM TOYCC WFBC CME VVESTP NRUC MASSMU PCAR 1-IN DA IBM CL IBM CVX 20,000,000.00 240,000,000,00 10,000,000.00 15,000,000.00 25,000,000.00 350,000,000,00 25,000,000.00 20,000,000.00 9,414,000.00 25,000,000.00 8,300,000.00 25,000,000.00 4,000,000,00 10,000,000.00 25,000,000.00 0.00 17,000,900,00 12,000,000.00 0.00 0,00 10,000,000.00 15,000,000.00 14,449,000.00 14,003,000.00 10,000,000.00 10,000,000.00 20,000,009.00 5,000,000.00 7,5813,000.00 6,000,000.00 20,000,000.00 20,000,000.00 15,000,000.00 10,000,000.00 20,000,000.00 10,000,000.00 10,000,000.00 19,886,792.54 60,000,000.00 10,000,000.00 15,000,000.00 24,991,093.75 100,000,000.00 24,982,288.10 19,855,339.77 9,439,375.98 25,000,000.00 6,337,297.64 25,076,215.69 4,000,000.00 10,292,240.74 25,321,446.99 25,000,000,00 17,124,228.22 12,214,539.87 25,000,000.00 25,000,000.00 10,223,520.89 14,993,603,75 14,312,171.27 14,048,261.66 10,224,593.96 10,244,342.05 20,507,897.06 5,045,476.40 7,561,450.57 5,950,742.29 19,942,719.09 19,992,410.00 15,432,389.21 9,968,506.22 19,946,956.19 9,983,511.11 10,015,625.00 19,894,227.77 1.909 2.817 92,000,000.00 10,000,000.00 2.082 2,111 15,000,000,00 2,082 2.111 24,991,707.29 2.950 3.050 276,666,666.67 24,982,486.46 2.500 2.555 19,858,290.08 2.300 2.698 9,438,542.66 3.325 3.155 25,000,000.00 2.770 2.808 8,336,726.38 2.850 1715 25,075,050.65 2.650 2,569 4,000,000.00 2,618 2.654 10,289,048.54 3.750 2.965 25,317,849.57 2.875 2.544 1,666,666.67 2.880 2.920 17,120,122.60 3.183 2.640 12,212,137.15 3.375 2.899 6,666,666,67 2,900 2.940 6,666,666.67 2.900 2.940 10,220,997.53 3.750 3.139 14,993,739.38 2.650 2.709 14,316,429.99 2.000 2.747 14,046,22225 1900 2,589 10,222,094,89 3.250 2.648 10,241,309.78 3.450 2.718 20,502,163.34 3.750 3.050 5,044,679.02 3.000 2.643 7,561,842.40 2,750 2.926 5,951,605.97 2.300 2.693 19,943,932.00 2.500 2.685 19,992,565.00 2.650 2.706 15,427,464.87 3.550 2,748 9,968,835.17 3.000 3.129 19,947,827.14 1250 2.390 9,983,683.33 3.000 3.087 10,015,409.72 2.566 2.547 31,666.67 0.00 17,351.08 26,026.62 61,458.33 0,00 52,083.35 38,333.33 26,084.63 57,708.34 19,712.50 55,208.34 8,726.66 31,250.00 59,895.83 4,000.00 45,092.50 33,750.90 16,111.11 16,111.11 31,250.00 33,125.00 24,081.67 33,840.59 27,083.33 28,750.00 62,500.00 12,500.00 17,389.16 11,500.00 41,666.67 44,166.67 44,375.00 25,000.00 37,500.00 25,000.00 21,383.33 14,390.78 0.00 0.00 0.00 1,187.50 0,00 383.92 5,710.27 -1,612.88 0.00 -1,105,66 -2,254.91 0.00 -6,178.45 -6,962.75 0.00 -7,946.57 -4,650.43 0.00 0.00 -4,883.92 262.50 8,242.69 -3,947.24 -4,836.91 -5,868.90 -11,097.5$ -1,543.31 797.09 1,671,64 2,347.58 300,00 -9,530.99 636.67 1,685.71 333.33 -416.67 46,057.45 0.00 17,351.08 26,026.62 62,645.8$ 0.00 52,467.25 44,043,60 24,471.75 57,708.34 18,606.84 52,953,43 8,726.66 25,071.55 52,933.08 4,000.00 37,146.13 29,099.57 16,111.11 16,111.11 26,36608 33,387.50 32,324.36 29,893.35 22,246.42 22,881.10 51,402.47 10,956.69 18,186.25 13,171.64 44,014.25 44,466.67 34,844,01 25,636.67 39,185.71 25,333.33 20,966.66 Portfolio INVT Data Updated: -REPORT--: 05/12/2020 09:56 AP Rur 'Date: 05112/2020 - 09:56 TO (PRF_TE) 7.3.6 Report Var. 7.3,6,1 MARICOPA COUNTY TREASURER Selected Funds Total Earnings Page 3 April 1, 2020- April 30, 2020 Adjusted Interest Earnings Cusp Investment # Fund Issuer Ending Par Value Beginning Book Value Average Current Annualized Book Value Rate Yield Interest Earned Amortization/ Accretion Realized Gainl/Loss Adjusted Interest Earnings 1000 1000 1000 1900 1000 1000 1009 1000 1000 1000 1000 1090 1900 1000 1000 1000 1000 1000 1000 1000 1090 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1900 1000 1000 1000 0,00 0.00 0.00 0.00 0,00 0.90 0,00 0.00 0.00 0.90 0.00 0,00 0,00 0.00 0.00 0.00 0.00 0.00 0.00 0,00 0,00 0.00 0.00 0,00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0,90 0.00 0.00 0.09 Fund: Treasurer's Pool 94988J5V5 10932 45905U2Z6 10935 459200JY8 10936 3134GTSG9 10942 46625HJX9 10943 911312BC9 10944 037833DC1 10945 88579YAX9 10946 MESD1R 10953 MESD2R 10954 MESD3R 10955 ME$D4R 10956 MESD5R 10957 718172BU2 10958 60687YAP43 10959 45905U6W9 10960 86562MBM1 10961 3133834G3 10962 3133EKVVZ5 10963 313379069 10964 3134GTR39 10965 86562MAEO 10966 3133EKG61 10971 45866FAE4 10972 3133EKH58 10976 481280079 11063 3133EKH41 10981 3133EKH41 10982 3133EKH66 10983 191216CL2 10967 904764AX5 10988 3134GT5Y5 10991 3134GT501 10992 3134GT7H0 10994 45818WCP9 10995 3134GUFD7 10996 3134GUHB9 10997 VVFBC IBRD IBM FHLMC JPMIG UPS APPL MMM MESD MESE) MUD MESD MESD PM MIZUNY IBRD SUMMIT FHLB FFCB FHLB FHLMC SUMMIT FFCB ICE FFCB JPMIG FFCI$ FFCB FFCB KO UNANA FHLMC FHLMC FHLMC !APB FHLMC FHLMC 29,000,000.00 35,000,000.00 15,000,000.00 20,000,000.00 10,000,000.00 17,430,000.00 20,000,000.00 20,000,000.90 330,090.00 335,900.00 345,000.00 350,000.00 355,000.00 5,090,000.00 15,000,000.00 25,000,000.00 10,000,000.00 20,000,000.00 35,900,000.00 20,000,000.00 30,000,000.00 17,158,000.00 25,000,000.00 20,000,000.00 30,000,000.00 25,000,000.00 25,000,000,00 25,000,000.00 20,000,000.00 15,000,000.00 5,090,000.00 25,000,000.00 20,000,000.00 20,000,090.00 25,000,000,00 0.00 0.00 20,000,000.00 35,000,000.00 15,063,350.59 20,000,000.00 10,409,565.40 17,483,412.29 20,039,409.15 20,050,780.01 330,000.00 335,000.00 345,000.00 350,000,00 355,000.00 4,954,388.59 15,398,739.27 25,000,000.00 9,992,790.00 20,160,966.88 35,000,000,00 20,113,780.50 39,000,000.00 17,150,363.58 25,000,000,00 20,179,682.61 30,090,000.00 25,000,000.00 25,000,000.00 25,000,009.00 20,009,000.00 15,000,000.00 5,131,701.37 25,000,000.00 20,000,000.00 20,000,000.00 25,000,000.00 30,000,000.00 25,000,000.00 20,000,000.00 35,000,000,00 15,962,688.91 20,000,000,00 10,405,341.67 17,482,330,08 20,038,715,80 20,050,040.27 330,000.00 335,000.00 345,000.00 350,000,00 355,000.00 4,955,020.38 15,392,875.46 25,000,000.00 9,992,862.33 20,158,793.55 35,000,000.00 20,111,545.27 30,000,000.00 17,150,619.23 25,040,000.00 20,176,532.07 30,000,000.00 25,000,000.00 25,000,000.00 25,090,000.00 20,000,000.00 15,000,000.00 5,139,316.45 25,000,000.00 20,000,000.00 20,000,000.00 25,000,000.00 0.00 7,500,000.00 2.900 2.940 2.480 2.514 3,009 2.926 2.520 2.555 3.625 2,518 2.350 2.230 2.100 2.044 2.250 2.189 2.130 2,160 2.130 2.160 2.130 2.160 2.130 2.160 2.130 2.160 2.125 2.474 3.549 2.609 2,300 2.332 2.696 2.752 2.125 1.884 2.200 2.231 2.125 1.8:81 2.250 2.281 2.058 2.123 2.100 2.129 2,350 1.994 2.260 2.291 2.250 2.269 2.000 2.028 2.000 2.028 1,850 1.876 1.750 1.774 2.600 1.933 2.160 2.190 2.160 2.190 2.210 2.241 2.385 2,418 2.150 2.010 2.938 48,333.34 72,333.33 37,500.00 42,000.00 29,713.11 34,133.75 35,000.00 37,500.00 585.75 594.62 612.37 621,25 630.12 8,854.17 44,362.50 47,916.67 22,466,66 35,416.67 64,166.66 35,416.66 56,250,00 29,425.97 43,750.90 39,166.67 56,500.00 46,616.02 41,666.67 41,666.67 30,833.33 21,875.00 19,833.33 45,000.00 36,000.00 36,833.33 49,687.50 0,00 12,562.50 0.00 0.00 -1,280,67 0.00 -8,174.96 -2,094.60 -1,341.97 -1,431.76 0.90 0.00 0.00 0.00 0.00 1,222.82 -11,349.32 0.00 140.90 -4,206.45 0.00 -4,326.25 0.00 494.80 0.00 -6,097,83 0.00 0.00 0.00 0.00 0.00 0.00 -2,680.49 0.00 0.00 0.00 0.00 0.09 0.00 48,333.34 72,333.33 36,219.33 42,009.00 21,538.15 32,039.15 33,658.03 36,068.24 585.75 594.62 612.37 621.25 630.12 10,076.99 33,013.18 47,916.67 22,606.66 31,210.22 64,166.66 31,090.41 56,250.00 29,920.77 43,75400 33,068.84 56,500.00 46,616.02 41,666.67 41,666.67 30,833.33 21,875.00 8,152.84 45,000.00 36,000.00 36,633.33 49,687,50 0.00 12,562.50 Portfolio INVT Data Updated: -REPORT-: 05/12/2020 09:56 AP Run Data: 0571=020 - 09:56 TE (PRF_TE) 7.36 RqportVer, 7,3,6,1 2.000 2.100 1.875 2.200 3.600 2.625 2.721 2.125 2.000 2.000 2.060 2.000 3.000 2.100 2.100 2.100 2.750 2.130 1.750 2.600 2.600 2,050 2.000 2.950 2.625 2.475 2.250 2.300 2.100 2.800 2.125 2,300 2.905 2.000 2,050 2.000 2,028 2.129 1.901 2.231 2.165 2.212 2.457 2.155 1.879 1.828 2.089 2.028 2.277 2.129 2.129 2.129 1.725 2.160 1.984 1.901 1.866 2.078 2.028 1.859 2.114 2.497 2.053 2.332 2.046 2.009 2.155 2.332 2.441 2.028 2,101 2.158 MARICOPA COUNTY TREASURER Selected Funds Total Earnings Page 4 April 1, 2020 - April 30, 2020 Adjusted Interest Earnings CUSIP Investment* Fund Issuer Ending Par Value Beginning Book Value Average Current Annualized Book Value Rate Yield Interest Earned Amortization/ Accretion Realized GainI/Loss Adjusted Interest Earnings 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 0,00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0,00 0.00 0.00 0,00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0,00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Fund: Treasurers Pool 3134GUHTO 10998 3133EK2R6 10999 89236TGM1 11000 3134GUFK1 11002 59156RBHO 11003 74977RDF8 11001 60687YAV1 11004 3130AHEY5 11005 86562MAT7 11006 43851618V7 11007 3130AHCA9 11008 3134GUL..17 11409 025816BR9 11010 48130USH9 11011 48130USH9 11012 48130USH9 11013 4590580 HO 11014 3130AHH89 11015 254687FK7 11016 89236TDP7 11017 89236TDP7 11014 3134GU M B3 11019 3130AHGK3 11020 14913Q2T5 11021 95000U268 11022 3814256500 11023 88579YBE0 1102$ 459058HLO 11027 95001D556 11028 949746SA0 11029 961214DG5 11030 3134GUNZ9 11031 17298CHJO 11032 313141GWM2 11033 3133EK5M4 11024 427866BC1 11034 822852CC4 11038 FHLMC FFCB TOYCC FHLMC MET RABOBK MIZUNY FHLB SUMMIT HON FH LB FHLMC AXP JPM IG JPMIG SPMIG IBRD FHLB CIS TOYCO TOYCC FHLMC FHLB CAT WFBC GSM M MMM IBRD WFBC WFBC WESTP FHLMC CITI GOLD FFCB HSY RDSALN 0.00 25,000,000.00 20,000,000.00 0.00 12,150,000.00 20,000,000.00 20,000,000.00 0.00 14,010,000.00 9,190,000.00 0.00 20,000,000.00 12,000,000.00 25,000,000.00 20,000,000.00 20,000,000.00 30,000,000.00 20,000,000.00 25,000,000.00 12,000,000.00 8,000,000.00 20,000,000,00 10,000,000.00 7,000,000.00 10,000,000.00 175,000,000.00 16,387,000.00 30,000,000.00 30,000,000.00 24,646,000.00 20,000,000.00 25,000,000.00 50,000,000.00 8,278,000.00 25,000,000.00 12,395,000,00 10,000,000.00 25,000,000.00 25,000,000.00 20,000,000.00 22,400,000.00 12,810,337.06 20,349,472.70 20,181,670.63 20,000,000.00 14,060,869,46 9,231,532.10 25,000,000.00 20,000,000.00 12,376,411.73 25,000,000.00 20,000,000.00 20,000,000.00 30,403,855.95 20,000,000.00 24,789,359.27 12,149,808.61 8,104,668.35 20,000,000.00 10,000,000,00 7,143,850.00 10,119,042.02 0.00 16,394,268.82 30,000,000.00 30,000,000.00 24,672,099.28 20,281,469.39 25,000,000.00 50,000,000.00 8,404,476.38 25,000,000.00 12,383,541.51 9,946,124.55 11,666,666.67 25,000,000.00 20,000,000.00 11,200,000.00 12,803,273.41 20,345,980.22 20,179,294.35 18,000,000.00 14,060,021.63 9,230,782,68 23,333,333.33 20,000,000.00 12,372,873.60 25,000,000.00 20,000,000.00 20,000,000.00 30,390,593,73 20,000,000.00 24,791,413.98 12,146,180.43 8,102,133,42 20,000,000.00 10,000,000.00 7,140,595,00 10,116,821,63 36,666,666,67 16,394,189.14 30,000,000.00 30,000,000.00 24,671,247.62 20,274,652.55 25,000,000.00 50,000,000.00 8,402,833,14 25,000,000.00 12,383,648.25 9,946,628.82 19,444.44 43,750.00 31,250.00 20,533.33 36,450.00 43,750.00 45,350.00 31,875.00 23,350.00 15,316.67 40,055.56 33,333.33 30,000.00 43,750.00 35,000.00 35,000.00 68,750.00 35,500.00 36,458.34 26,000.00 17,333.34 34,166.66 16,666.66 17,204.33 21,875.00 0.00 33,798.18 50,625.00 57,500.00 43,130.50 46,666.67 44,270.83 95,833.33 20,034.66 41,666.66 21,174.80 16,666.67 0.00 0.00 0.00 0.00 -13,671,58 -6,759.63 -4,599.25 0.00 -1,640.95 -1,450.48 0.00 0.00 -6,848.00 0.00 0.00 0.00 -25,668.81 0,00 3,976.86 -7,022.28 -4,906.32 0,00 0.00 -6,300.00 -4,297.54 0.00 -154.22 0.00 0.00 -1,648.38 -13,193.88 0.00 0.00 -3,180.46 0,00 206.58 976.01 19,444.44 43,750.00 31,250.00 20,533.33 22,778.42 36,990,37 40,750.75 31,875.00 21,709.05 13,866.19 40,055.56 33,333.33 23,152.00 43,750,00 35,000.00 35,000.00 43,081.19 35,500.00 40,435.20 18,977.72 12,427.02 34,166.66 16,666.66 10,908.33 17,577.46 0.00 33,643.96 50,625.00 57,500.00 41,482.12 33,472.79 44,270,83 95,833,33 16,859.20 41,666.66 21,381.38 17,642.68 Portfolio 1NVT Data Updated: -REFORM, : 05112/2020 09:55 AP Run Date: 05/12/2320 - 09:56 TE (PRF_TE) 7.33 Report Ver. 7.3.6.1 2.160 3.350 1.810 2.125 2.000 2.300 1.770 1.770 2.753 1.830 2,100 2.190 1.630 1.830 1.830 2.305 1.900 2.953 1.730 2,305 2.050 3.350 2,448 2.050 2.020 2,020 3.650 2.050 2.875 1.950 2.250 2.000 2,000 2.250 1.750 2.700 2.190 1.869 'Lass 2.155 1.854 2.332 1.839 1.839 2.192 1.855 2,129 2.129 1.874 1.874 1,868 2.028 1.954 2.141 1.796 2.250 2.078 1.972 2.274 2.041 2.048 2.048 2.025 2.078 2.054 1,986 2.281 2.028 2.028 2.281 1.829 2.049 MARICOPA COUNTY TREASURER Selected Funds Total Earnings Page 5 April 1, 2020 April 30, 2020 Adjusted Interest Earnings CUS1P Investrnent# Fund Issuer Ending Par Value Beginning Book Value Average Current Annualized Book Value Rate Yield Interest Amortization/ Earned Accretion Realized Adjusted Interest Gainl/Loss Earnings 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 Fund: Treasurer's Pool 459058HQ9 11035 91324PCNO 11036 45905U4U5 11037 89236TGQ2 11039 86562MAT7 11040 4 8128GM49 10975 3133E0E1 11050 3133 EL DE1 11051 9612140136 11052 3133ELFP4 11053 48130USUO 11054 48130USUO 11055 3133ELEU4 11056 3133ELEU4 11057 3133ELEU4 11058 459200K1 D2 11059 3130AHS46 11060 09248U874 11061 60687YAH2 11062 3130AHSG9 11064 822582CA8 11065 3134GU029 11067 641062AD6 11068 86562MBT6 11069 24422EVCO 11070 3134GUW48 11076 3134GUW63 11071 17325FAS7 11072 24422EVCO 11073 718172CH 0 11074 3134GUY53 11075 950011D5R7 11097 95001D5Q9 11098 95001D5Q9 11099 95001 D5R7 11100 3134GU3D0 11101 46625H RL6 11102 I BRD UN C IBRD TOYCC SUMMIT JPMIG FFCB FFCB WESTP FFCB JPMIG JPMIG FFC B FFCB FFCB IBM FHLB BLKMM MIZUNY FHLB RDSALN FHLMC NESNVX SUMMIT DE FH LMC FHLMC CITI OE PM FHLMC WFBC WFBC VVF BC WF BC FHLMC JPMIG 20,000,000.00 5,000,000.00 25,000,000.00 25,000,000.00 5,495,000.00 25,000,000.00 0.00 0.00 20,000,000.00 15,000,000,00 25,000,000.00 25,000,000.00 0.00 0.00 0.00 10,000,000.00 9,250,000.00 50,000,000.00 6,575,000.00 20,680,000.00 25,000,000.00 30,000,000.00 25,000,000.00 11,072,000,00 5,000,000.00 39,000,000.00 50,000,000,00 30,000,000.00 5,000,000.00 10,518,000.00 25,000,000.00 20,000,000.00 20,000,000.00 25,000,000,00 30,000,000.00 30,000,000.00 8,825,000.00 20,000,000.00 5,165,531.87 25,000,000.00 25,000,000,00 5,518,215,73 25,000,000.00 25,121, 524.43 12,784,508.59 20,161,099.17 15,000,000,00 25,000,000.00 25,000,000.00 13,892,997,00 10,744,584.01 8,891,847.39 10,033,271.74 9,241,360.24 0,00 6,676,618.60 20,661,410.98 25,072,454.00 30,000,000.00 26,145,767.60 11,164,694.64 5,008,112,78 30,000,000.00 50,000,000.00 31,756,822,34 4,999,994.58 10,654,949.75 24,990,416.67 20,000,000.00 20,000,000.00 25,000,0130.00 30,000,000.00 29,928,083.33 9,001,638.95 20,000,000.00 5,162,418.10 25,000,000.00 25,000,000.00 5,517, 828.80 25,000,000.00 15,910,484.54 8,096,949.96 20,156,154.55 15,000,000.00 25,000,000.00 25,000,000.00 3,704,807,06 2,865,228.48 2,371,168.45 10,031,988,88 9,241,459.81 13,333,333.33 6,674,325.90 20,661,767.13 25,071,603.86 30,000,000.00 26,131,594.10 11,163,805.55 5,008,039.58 30,000,000.00 50,000,000.00 31,736,974,86 4,999,994.63 10,851,396.88 24,990,502.78 20,000,000.00 20,000,000.00 25,000,000.00 30,000,000.00 29,928,729.17 8,999,209.58 36,000.00 13,958.33 37,708.33 44,270,83 9,158.3.4 47,916.67 23,494.29 11,956.40 45,877.17 22,875.00 43,750.00 43,750,00 5,652.66 4,371.67 3,619.34 19,205.24 14,645.84 0.00 16,179.98 29,813.67 48,013.12 51,250.00 69,791.67 22,586.88 8,541.67 50,500.00 84,166.67 91,250,00 8,541.67 25,199.37 40,625.00 37,500.00 33,333.34 41,666.66 56,250.00 43,750.00 19,856.25 0.00 -6,026.65 0,00 0.00 -748.90 0.00 557.19 263,56 -9,570.24 0.00 0.00 0.00 52.40 40.53 61.01 -2,482.96 192.71 0.00 -4,437.49 689.33 -1,645.44 0.00 -27,432.58 -1,720.82 -141.67 0.00 0.00 -38,414.48 0.09 -6,876.53 166.66 0,00 0.00 0.00 0.00 1,250.00 -4,702.01 0.00 0,00 0.00 0.00 0.00 0,00 27,918.38 14,207.85 0.00 0.00 0,00 0.00 6,950.60 5,375.46 8,091.60 0.00 0.00 0.00 0,00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0,00 0.00 0.00 0.00 0.00 36,000.00 7,931.68 37,708.33 44,270.83 8,409.44 47,916.67 51,969.86 26,447.81 36,306.93 22,875.00 43,750.00 43,750.00 12,655.66 9,787.66 11,771.95 16,722.28 14,838.55 0.00 11,742.49 30,503.00 46,367.68 51,250.00 42,359.09 20,866.06 8,400.00 50,500,00 84,166.67 52,835.52 8,541.76 18,322.84 40,791.66 37,500.00 33,333.34 41,666,66 56,250,00 45,000,00 15,154.24 Portfolio INVT Data Updated: -REPORT-: 05/12/2020 09:56 AP Run Mb: 05/1212020- 0956 TE (PRF_TE) 7.3.6 Report Ver. 7.35.1 2,000 2000 . 2.000 1.930 1.930 1.930 2.050 2.150 2.050 2.000 2.000 3.000 2.050 2.250 2.250 2.000 1.720 1.800 3.000 2.000 3.000 1.900 2.850 1,810 1,670 1,700 2.800 1,810 1.240 2.600 1,200 1.260 2.750 1.125 1,240 2.400 2.028 2.028 2.028 1.966 1,966 1,970 2,025 2.023 2.078 2.028 2.028 1.996 2.078 2.281 2.281 2.028 1.765 1.731 3.042 2.028 3,042 1.926 2.890 1.530 1.693 1.724 2.839 1.700 1.257 1.003 1.217 1.278 2.7138 1.141 1.257 2.433 MARICOPA COUNTY TREASURER Selected Funds Total Earnings Page 6 April 1, 2020 - April 30, 2020 Adjusted Interest Earnings Ending Beginning Average Current Annualized Interest Amortization/ Realized Adjusted Interest CUSH:. Investment # Fund issuer Par Value Book Value Book Value Rate Yield Earned Accretion GainI/Loss Earnings 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1090 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0,00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.09 0.00 0.00 0.00 0,00 0,00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Fund: Treasurer's Pool 3130AHWB5 11077 3134GUX62 11078 3134G114M9 11079 3130AHV91 11080 3130AHV91 11081 3134GLI3W8 11082 02665VVDG3 11083 1491303W 11084 381504079 11087 3135G0X57 11088 3134GUYI37 11089 459200JY8 11090 459058HV8 11091 22533ABW6 11092 17327T2B1 11093 4813OUTJ4 11096 3133ELLY8 11103 69371RQ66 11104 3134GVAP3 11105 17327TF68 11106 3134GVBE7 11107 9500ID5W6 11108 3134GVEU8 11109 86562MAWO 11110 3130AJC49 11111 3134GVEX2 11112 3134GVEZ7 11113 86562MAWO 11115 3134GVFL7 11114 110122BY3 11116 3133ELRQ9 11117 3135GOZ55 11118 481242785 11120 3134GVEY0 11121 3134GVFR4 11122 3133ELRZ9 11123 3134GVFJ2 11124 FHLB FHLMC FHLMC FHLB FHLB FFILMC HNDA CAT GOLD FNMA FHLMC IBM !BIRD ACAFP CITI JPMIG FFCB PCAR FHLMC CITI FHLMC WFBC FHLMC SUMMIT FHLB FM LB FHLB SUMMIT FH LB KO FFCB FNMA JMPMM FHLB FM LB FFCB F1-I LB 25,000,000.00 25,000,000.00 25,000,000.00 19,500,000.00 8,000,000.00 25,000,000.00 5,470,000.00 25,000,000.00 25,000,000.00 25,000,000.00 25,000,000.00 13,130,000.00 50,000,000.00 30,000,000.00 30,000,000.00 25,000,000.00 20,827,000.00 5,000,000.00 30,000,000.00 25,000,000.00 25,000,000.00 25,000,000,00 30,000,000.00 5,000,000.00 22,000,000.00 5,000,000.00 30,000,000.00 1,846,000.00 25,000,000.00 10,000,000.00 25,000,000.00 20,000,000.00 150,000,000.00 25,000,000.00 20,000,000.00 25,000,000.00 25,000,000.00 25,000,000.00 25,000,000.00 25,000,000.00 19,492,503.33 7,996,924.44 24,985,583.33 5,478,501.29 25,163,538.70 25,000,000.00 25,000,000.00 25,000,000.00 13,646,536.08 50,000,000.00 30,000,000.00 30,000,000.00 25,000,000.00 20,814,221.33 5,020,808.78 30,000,000.00 25,000,000.00 25,000,000.00 25,000,000.00 30,000,000.00 5,040,327.56 22,000,000.00 5,000,000.00 30,000,000.00 1,852,550.15 25,000,009.00 10,335,341.14 25,000,000.00 20,000,000.00 75,000,000.00 25,000,000.00 20,000,000.00 25,000,000.00 25,000,000.00 25,000,000,00 25,000,000.00 25,000,000.00 19,492,570.50 7,996,952.00 24,985,712.50 5,478,383.53 25,162,008.91 25,000,000.00 25,000,400.00 25,000,000.00 13,641,141.00 50,000,000.00 30,000,000.00 30,000,000.00 25,000,000.00 20,814.399.13 5,020,623,95 30,000,000.00 25,000,000.00 25,000,000.00 25,000,000.00 30,000,000.00 5,039,706,21 22,000,000.00 5,000,000.00 30,000,000,00 1,852,449.23 25,000,000.00 10,328,546.65 25,000,000,00 20,000,000,00 95,000,000.00 25,000,000.00 20,000,000.00 25,000,400.00 25,000,000.00 41,666.67 41,666,67 41,656.67 31,362.50 12,866.67 40,208.34 9,344.59 44,791.67 42,708.33 41,666.66 41,666.66 32,825.00 85,416.67 56,250.00 56,250.00 41,666.67 29,852.03 7,500,00 75,000.00 41,666.66 62,500.00 39,583.33 71,250.00 7,541.66 30,616.67 7,083.33 70,000.00 2,784.38 25,833,33 21,666.67 25,000.00 21,000.00 0.00 57,291.66 18,750.00 25,833.34 50,000.00 0.00 0.00 0.40 130.00 53.34 250.00 -227.92 -2,960.87 0.00 0.00 0.00 -10,442.10 0.00 0.00 0.00 0.00 344.13 -357.74 0,00 0.00 0.00 0,00 0.00 -1,202.61 0,00 0.00 0.00 -195.33 0.00 -13,150.63 0.00 0.00 0,00 0.00 0.00 0.00 0.00 41,666.67 41,666.67 41,666.67 31,492.50 12,920.01 40,458.34 9,116.67 41,830.80 42,708.33 41,666.66 41,666.66 22,382.90 85,416,67 56,250.00 56,250,00 41,666.67 30,196.16 7,142.26 75,000.00 41,666.66 62,500.00 39,583.33 71,250.00 6,339.05 30,616.67 7,083,33 70,000.00 2,589.05 25,1333.33 8,516.04 25,000.00 21,000,00 0.00 57,291.66 18,750.00 25,833.34 50,000.00 Portfolio INVT Data Updated: -REPORT-: 05112/2020 09:56 AP Run Date: 05712)2020 - 09:56 TE (PRF JE) 7,a6 Report Ver. 7,3.6.1 MARICOPA COUNTY TREASURER Selected Funds Total Earnings Page 7 April 1, 2020- April 30, 2020 Adjusted Interest Earnings CUSIP Investment # Fund Issuer Ending Par Value Beginning Book Value Average Current Annualized Book Value Rate Yield Interest Amortization/ Earned Accretion Realized Adjusted Interest GalnI/Loss Earnings 1.400 1.950 1.320 2.600 3.400 2.950 3.500 1.630 0.830 1.000 1.750 1.750 3.375 1.430 1,700 3.600 2.600 1.200 1,200 2.000 1.750 1.500 2.750 0.00 0.00 0.00 0,00 0,00 0,00 0,00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 62,543.89 Fund: Treasurer's Pool 31 33 ELRUO 11125 1000 FFCB 90331HPF4 11126 1900 USBNK 89236TFR1 11127 1000 TOYCC 2441995E4 11128 1000 DE 822582AX0 11129 1000 RDSALN 24422EUT4 11130 1000 DE 822582BZ4 11131 1000 R DSALN 606822,407 11132 1000 M UFG 3133ELTM6 11133 1000 FFCB 3133ELSX3 11134 1000 FFCB 95001 05Y2 11136 1000 WFBC 95001 D5Y2 11137 1000 VVF BC 459200HP9 11138 1000 IBM 437076BU5 11139 1000 HD 22533AC 547 11135 1000 ACAFP 44932HAM5 11140 1000 IBM 904764)20(5 11141 1000 U NANA 3133ELU K8 11142 1000 FFCB 3130AJF79 11143 1000 FH LB 38150AE27 11144 1000 GOLD 38150ADZ5 11145 1000 GOLD 78014RCM0 11146 1000 R5C 95001D6F2 11147 1000 VVF BC Subtotal 9,800,000.00 20,000,000.00 2,500,000.00 2,000,000.00 1,458,000.00 2,000,000.00 6,594,000.00 5,000,000.00 25,000,000.00 20,000,000.00 15,000,000,00 20,000,000.00 3,000,000.00 10,000,000.00 20,000,000,00 17,525,000,00 15,000,000.00 25,000,000.00 20,000,000,00 20,000,000.00 20,000,000,00 20,000,000.00 25,000,000.00 5,848,453,011.67 9,800,000.00 20,436,882.60 2,500,630.30 2,048,014.81 1,536,204.84 2,063,584.09 6,977,740.83 4,959,021.41 25,000,000,00 20,000,000.00 15,000,000.00 20,000,000.00 3,151,087,31 9,827,847,97 20,000,000.00 17,934,573.61 15,216,322.69 25,000,000.00 20,000,000.00 20,000,000.00 20,000,000.00 20,000,000.00 0.00 9,800,000.00 20,430,097.35 2,500,595,66 2,047,069.16 1,535,203.87 2,062,215.26 6,973,172.48 4,959,773.09 25,000,000.00 20,000,000.00 15,000,000.00 20,000,000.00 3,149,135.77 9,831,665.36 20,000,000.00 17,923,975.30 15,214,047.92 25,000,000.00 20,000,000.00 20,000,000.00 20,000,000.00 20,000,000.00 24,166,666.67 1.419 11,433.34 1.153 32,500.00 1.305 2,750.00 1.488 4,333,34 1.738 4,131,00 1.338 4,916.67 1.813 19,232.50 2.023 6,791.66 0.842 17,291.67 1.014 16,666.67 1.774 21,875.00 1.774 29,166.67 1.801 8,437.50 2,389 11,916.66 1.724 28,333.34 2.157 52,284.53 2.247 32,500.90 1.217 25,000.00 1,217 20,000.00 2.028 33,333.33 1.774 29,166.67 1.521 25,000.00 2.788 55,381.94 1.708 7,196,764.22 0.00 -13,132.75 -67.05 -1,830.30 -1,937.36 -2,649.34 -8,841.96 1,454.86 0.00 0.00 0.00 0.00 -3,777.18 7,388.50 0.00 -20,512.86 -4,402.77 0.00 0.00 0,00 0.00 0.00 0.00 -361,615.32 11,433.34 19,367.25 2,682.95 2,503.04 2,193.64 2,267.33 10,390.64 8,246.52 17,291,67 16,666.67 21,875.00 29,166.67 4,660.32 19,305,16 28.333,34 31,771.67 28,097.23 25,000.00 20,000.00 33,333.33 29,166.67 25,000.00 55,381.94 6,897,692.79 4,592,422,169.92 4,913,282,513.97 0,00 0.00 0,00 0.00 0.00 Fund: MIHS Bond Proceeds 313396ZR7 11041 534BP 313384W8 11042 53413P 313396YHO 11043 534BP 912828NT3 11044 53416P 63763PEL9 11049 534BP FH LMC FHLMC FHLMC USTR NSCCRP 35,357,000,00 0.00 35,313,000.00 34,500,000.00 35,309,000.00 35,193,473.93 35,199,994.79 35,195,211.53 34,629,051,97 35,224,895.92 35,216,308.65 22,302,998,44 35,218,321.92 34,614,343.84 35,251,500.27 0.00 0,00 0.00 74,639.42 0.00 44,196,23 29,005.21 44,729.80 -28,467.35 51,492.30 44,196.23 29,005.21 44,729.80 46,172.07 51,492.30 1.500 1.527 1.582 1.545 2.625 1.623 1.750 1,777 Subtotal 140,479,000.00 175,442,628.14 162,603,473.13 1.613 74,639.42 140,956.19 0.00 215,595.61 Fund: MIHS Debt Service 665279873 10425 534DS NTMM -25,718.42 -25,718.42 -25,718,42 0.00 0.00 0.00 0.00 912828XU9 11047 53405 USTR 25,000,000.00 24,998,577.82 24,998,871.74 1.500 1.524 30,737.70 568.87 0.00 31,306.57 313384YH6 11095 53405 FI-11)N1 17,606,000.00 17,546,115.15 17,557,864.71 1.550 1.576 0.00 22,741.08 0.00 22,741.08 Portfolio INVT Data Updated: -REPORT-: 0511212020 09:56 AP Run DO): 0511212020- 09:56 TE (PRF_TE) 7.3.6 Report Var. 7.3.6.1 1VIARICOPA COUNTY TREASURER Selected Funds Total Earnings Page 8 April 1, 2020 - April 30, 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 Subtotal 42,580,281.58 42,518,974.55 42,531,018.03 1.546 30,737.70 23,309.95 0.00 54,047.65 Fund: MIHS Health Plan Sale 912828XU9 11048 534H P USTR 19,000,000.00 18,998,919.14 18,999,142.52 1,500 1.524 23,360.66 432.35 0.00 23,793.01 313384YH6 11094 534HP FHDN 13,079,000.00 13,034,513.23 13,043,241.65 1.550 1.576 0.00 16,893.71 0.00 16,893,71 Subtotal 32,079,000.00 32,033,432.37 32,042,334.17 1.545 23,360.66 17,326.06 0.00 40,686.72 Fund: MIHS Maintenance & Ops 3133EKGY6 06406FAB9 7170810X8 822582BSC 912828XU 9 313384YG8 10905 10906 10907 10908 10952 11119 534M0 534M0 534M0 534M0 534M0 534M0 FFO B BONYM PFIZER RDSALN USTR FHL,B Subtotal 25,845,000.00 8,576,000.00 7,194,000.00 6,539,000.00 25,000,000.00 25,000,000.00 100,154,000.00 25,826,017.96 8,516,402.52 7,146,616.65 8,470,766.95 24,976,827.33 24.999,535.37 99,936,166.78 25,826,804.65 8,518,759.05 7,148,357.03 8,473,417.61 24,981,616.35 24,999,827,70 99,948,582.39 2.375 2.050 1.950 1.875 1.500 0.009 2,481 2.744 2.563 2.652 1.948 0.009 1.772 51,151,56 14,650.66 11,690.25 13,342.18 30,737.71 0.00 121,572.36 1,522,63 4,561.03 3,368.48 5,130.30 9,269.07 178.70 24,030.21 0.00 0,00 0.00 0.00 0.00 0.00 0.00 52,674.15 19,211.69 15,058.73 18,472.48 40,006.78 178.70 145,602.57 Total 6,163,745,293.25 4,942,353,371.76 5,250,407,971.68 1.704 7,447,074.36 -155,992.91 62,543.89 7,353,625.34 Portfolio INVT Data Updated: —REPORT--: 05/12/2020 09:56 AP RLP1 0015 05/12/2020 - 09•56 TO (PRF_TE) 7.3.6 Report 'for, 7,3.6,1 Maricopa County MARICOPA COUNTY TREASURER Selected Funds Total Earnings Sorted by Fund - Purchase Date April 1, 2020 - April 30, 2020 Adjusted Interest Earnings CUSIP Investment* Fund Issuer Ending Par Value Beginning Book Value Average Current Ann ualized Book Value Rate Yield Interest Earned Amortization/ Accretion Realized Adjusted Interest GainI/Loss Earnings Fund: Treasurer's Pool Fund: MIHS Bond Proceeds Fund: MIHS Debt Service 5,848,453,011.67 4,592,422,169.92 4,913,282,513.97 140,479,000.00 175,442,628.14 1,708 7,196,764.22 74,639.42 Subtotal Subtotal 162,603,473.13 1.613 -361,615.32 62,543.89 6,897,692.79 140,956.19 0.00 215,595.61 Subtotal Fund: MIHS Health Plan Sale Subtotal Fund: MIMS Maintenance & Ops Subtotal 42,580,281.68 32,079,000.00 100,154,000.00 42,518,974.55 32,033,432.37 99,936466.78 42,531,018.03 32,042,384.17 99,948,582.39 1.545 30,737.70 1.546 23,360.66 1.772 121,572.36 17,326.06 0.00 40,686.72 24,030,21 0.00 145,602.57 23,309,95 0.00 54,047.65 Total 6,163,745,293.25 4,942,353,371.76 5,250,437,971.68 1.704 7,447,074.36 -155,992.91 62,543.89 7,353,625.34 Portfolio INVT Data Updated: -REPORT-: 05112/2020 09:53 AP Run Date: 05/12/2020 - 09:53 TE (PRF 7E) 7.3.6 Report Ver. 7.3.6.1 01-8AY-2020 PAGE: 1 PROGRAM ID: APP LEVY_RPT_MONTH_SUM MARICOPA COUNTY TREASURER' S OFFICE SECURED LEVY AND ACTIVITY FOR APR 2020 YEAR LEVY BEGINNING BALANCE COLLECTIONS ADJUSTMENTS ENDING BALANCE 2019 2018 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 1986 1987 1986 1965 1984 1983 1982 1981 1980 1979 1978 1977 1976 1975 1974 1973 1972 1971 1970 1969 1968 5,268,316,083.92 5,032,079,420.54 4,791,587,056.56 4,643,191,878.76 4,364,407,727.66 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,631.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 1,802,732,132.02 2,131,149.43 1,261,822.93 1,529,657.24 1,504,030.89 1,070,265.77 778,728.37 1,513,314.72- 20,527,906.73 43,253,570.23- 86,834,090.76 25,886,694.89 782,033.29- 857,909.66- 480,394.05 559,192.11 1,002,669.10- 1,587,790.83- 342,979.95 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 1,170,381,923.88 168,244,21- 24,71'7.60- 2,887.14- 2,217.24 513.62 345.94 90.14 193.96 259.32 152.50 113.11 10.20 .00 .00 1,291.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 .00 .00 .00 .00 .00 .00 .00 .00 .00 198,174.25- 182,467.52- 24,704.62- 4,702.44- .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 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 632,152,033.89 2,116,926.12 1,281,835.91 1,527,841.94 1,501,813.65 1,069,752.15 778,382,43 1,513,404.86- 20,527,712.77 43,253,829.55- 86,833,938.26 25,886,581.78 782,043.49- 857,909.66- 480,394.05 557,900.89 1,002,669.10- 1,587,790.83- 342,979.95 573,629.53- 680,620.36- 763,699.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 TOTAL 105,959,608,182.36 1,912,065,254.97 1,170,191,262.18 410,048.83- 741,483,943.96 PROGRAM ID: APP LEVY_RPT_MONTH_SUM 01-MAY-2020 MARICOPA COUNTY TREASURER'S OFFICE PAGE: 1 UNSECURED LEVY AND ACTIVITY FOR APR 2020 YEAR LEVY BEGINNING BALANCE COLLECTIONS ADJUSTMENTS ENDING BALANCE 2004 2003 2002 2001 2000 1999 1998 1997 1996 1995 1994 1953 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 .00 .00 16,903,615.38 19,330,396.80 138,497,672.37 122,871,629.32 122,881,710.56 115,134,253.32 102,673,892.06 113,747,601.86 162,209,939.25 154,917,045.68 140,629,687.78 131,582,120.56 122,744,902.09 113,929,972.43 96,811,185.54 88,991,362.81 76,956,283.43 50,507,999.56 53,570,953.57 73,434,045.21 37,836,109.79 36,683,300.76 30,075,323.04 29,722,220.00 28,615,308.42 26,779,663.13 23,204,794.95 19,169,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 197,750.52- 13,355,878.70- 3,025,724.42 908,015.20- 9,599,640.97- 28,717,268.10- 25,613,913.68- 22,991,084-77- 35,349,453.05- 26,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- .00 .00 197,750.52- .00 .00 13,355,878.70- .00 .00 3,025,724.42 .00 .00 908,015.20- .00 .00 9,599,840.97- .00 .00 28,717,268.10- .00 .00 25,613,913.68- .00 .00 22,991,084.77- .00 .00 35,349,453.05- .00 .00 28,930,383.63- .00 .00 7,647,588.77 .00 .00 14,738,205.59- .00 .00 17,960,825.13- .00 .00 6,674,284.60- .00 .00 1,269,288.95- .00 .00 8,385,792.84- .00 .00 21,988,363.31- .00 .00 7,484,835.49- .00 .00 25,986,693.31- .00 .00 28,240,893.00- .00 .00 12,980,240.92- .00 .00 6,629,772.26- .00 .00 22,961,357.32- .00 .00 18,070,978.29- .00 .00 17,273,398.23- .00 .00 6,566,057.11- .00 .00 6,816,484.82- .00 .00 5,944,729.86- .00 .00 2,710,083.28- .00 .00 2,676,843.29- .30 .00 5,483,374.18- .00 .00 5,844,853.65- .00 .00 2,956,945.73- .00 .00 1,720,760.88- .00 .00 434,685.68- .00 .00 1,422,511.95- .00 .00 2,320,992.14- TOTAL 2,325,116,156.87 410,533,527.24- .00 .00 410,533,527.24-