Extracted text (via pymupdf_layout)
31089 characters
Royce T. Flora, Treasurer 301 West Jefferson St., Rm, 100 Phoenix, Arizona S5003 Maricopa County Phone: (602) 506-S511 Fax (602) 506-1102 Treasurer http://treasurer.maricopa.gov DATE: September 11,2019 TO Bill Gates, Chairman Denny Barney, Supervisor, District 1 Steve Chucri, Supervisor, District 2 Clint Hickman, Supervisor, District 4 Steve Gallardo, Supervisor, District 5 SUB, ECT: Treasurer's Collections and Investment Summary for August 2019 Secured property tax collections during the. month of August equaled $6,096,883 and increased the 2018 year to date collections to $4,973,595,140 or 99.18% of the adjusted 2018 levy of $5,014,937,917. The. chart below reflects the 2018 collected and uncollected levy amount and corresponding percentages for the 2018 property tax year. AUGUST 2019 Collected Levy $4,973,595,140 99% ncollected Levy $41,342,776 1% Co[lected Levy Urrokfected Levy The County's General Fund Balance. totaled $60,601,089,18 effective August 31, 2019. Warrants outstanding of $4,210,017.04 will post against the fund balances when presented. The $2,890,673 unencumbered balance, of the County Municipal Line of Credit and the $12,937,811 Workers Compensation Liability Letter of Credit remain unused. Russell K. Pearce Chief Deputy Treasurer STATE OF ARIZONA ) ss. COUNTY OF MARICOPA ) This instrument was acknowledged before me this 12th day of September 2019, 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. /..; cO ,,,1 J Nota mission Expires KAREN 0 SMITH Wee iy Pulgt - Arimca ricoN Cal* My Cara. Es Dec 15,2021 Maricopa County MARICOPA COUNTY TREASURER Total Earnings Sorted by Security Type - Issuer August 1, 2019 - August 31, 2019 Adjusted interest Ea mings Ending Beginning Average Current Annualized Interest Amortization/ Realized Adjusted Interest CLISIP Investment I Fund Issuer Par Value Book Value Book Value Rile Yield Earned Accretion Gainnoss Earnings Security Type: Commercial Paper Disc. -Amortizing 865521284 10864 1000 SLIM MET 20,000,000 00 19,785,216 66 19,608,594.45 2030 2.692 0.00 45294.44 0.00 45,294.44 69233HX25 10360 1000 TOYCC 20,000,000 00 19,912,166 67 19.934.833.33 2.550 2.594 0.00 43916.66 0.00 43,918.66 Subtotal 40,000,000.00 39,697,383.35 31,743427.79 2.643 0.00 89,211.10 0.00 89,211.10 Security Type: Federal Agency Coupon Securities 037833001 10875 1000 APPL 20,000.00000 19609,657_69 19,812,696 33 2.300 2.617 33,333.34 5,71028 0.00 44,043.82 037833001 10945 1000 APPL 20.00000000 20050,144.91 20,049,430.63 2.100 1.977 35,000.00 -1,341.97 0.00 33658.03 06406FAB9 10906 5341(0 8,576600.00 8,479,914.26 8,482,341.91 3.050 2.687 14,650.67 4,561.03 000 19,211.70 1441600%0 10929 1000 CL 20,000,000.00 19,833,47013 15934,367.71 2.290 2.314 37,500.00 1,685.71 0.00 39,185.71 125720AE5 10922 1000 CME 5,000,000.00 5,051,622.94 5,057,001.49 3.000 2 551 12,503.00 -154332 0.00 10,056.68 16676413105 10931 1000 CVX 10,000,000.00 10,018,958.33 10,018,736.56 2 566 2.464 21,363.94 -418.68 0.00 20,966.68 3133880.185 10517 1000 FFCB 16,000,000.09 15,993,442.93 15,993,678 26 1.750 1.750 23333.33 44204 0.00 23,775.37 3133EHP9,3 10542 1000 FFCB 5,500,000.00 5,498,925.97 5,499,106 50 1.600 1.643 7,33333 339.17 0.00 7,672.50 313.3EJ-KY4 50651 1000 FFCB 20,000,000.00 19,998,664.44 19,908,749.60 2.375 2_340 39.683,33 158.99 0.00 39,742.32 313.3.E.WW5 10702 1000 FFCB 25,000,000.00 24,993627.78 24.998.1U 66 2.550 2.512 53,125.00 203.33 0.00 53333.33 3133E.N.M5 10703 1000 FFCI3 25.000,000.60 24.998.027.78 24998138 66 2.550 2,512 53,125.00 208.33 0.00 53,333.33 3133E1790 10769 MOO FFC43 25000.000.00 24931,59375 24982,225 81 2.950 2.953 61,458.34 1,187.50 0.00 62,645.84 3133E50Y6 10905 SUMO FFCB 25645,00060 25613,836.98 25,814,647.41 2.375 2.402 51,151.66 1,52262 0.00 52.674.18 3130ADLIU9 10616 1000 FHLB 16,000,000.00 15,999,06223 15,949,124.78 2.375 2.339 31,666.67 117.72 0,00 31,784.39 313010002 10.365 1000 FHLB 0.60 24,668,364.03 9,626,842.10 2.420 2.683 20,166.67 4,768.63 129,847.29 151,782.59 31336340.3 10002 9000 FHLB 20,900,000.00 20,194,618.49 20,192379.53 2.125 1.820 3.5,499.65 -4,206.45 0.00 31,21021 313379069 10964 1000 FHLB 20,000,000.00 20,148,390.54 20,145,037.85 2.125 1.817 35.416,67 -4,320.25 0.00 31,090.42 313405009 10608 1000 FFILMIC 0.00 25.000.000.00 25181.200,32 2,420 2.454 42,013 89 0.00 0.00 42,013.89 313603R98 10227 1000 FNMA 20.000.00060 20,000.00060 20,000,000.00 1.330 1.305 22,166.66 0.00 0.00 22,166.65 3135COV34 10361 1000 FNMA 25,000000.00 24,97921667 24,979,421.02 2.500 2.473 52,063.34 383.93 0.00 52,467.27 onowcrs 10927 1000 15,000,000.00 15603,637.13 15,503,564.18 3.550 2.648 44,375.00 9530.99 0.00 3.4.844.01 911759%15'6 10893 1000 FILID 4,000,000.00 4,000,000.00 4,000,000.00 2.618 2.569 8.72667 0_00 0.00 8,726.67 45420,1Y8 10928 1000 IBM 90600,000.00 9,963,412.69 9,963,751.78 3.000 3.029 25600 00 636.67 0.09 25,638.67 454200.5Y8 10930 1000 IBM 10,000.000.00 9,960.844.44 9.951,021.86 3,000 2,988 25,000.00 33334 0.00 25,333.34 POrtIONO INVT AP 091110.019' 10 28 7E 6118.F_TE] 7.3.6 ReW 1.351 MARICOPA COUNTY TREASURER Total Earnings Page 2 August 1, 2019 • August 31,2019 Adjusted Interest Earnings Endtng Beginning Average Current Annualized Interest Amortization/ Realized Adjusted interest CUSP Investment C Fund Issuer Par Value Book Value Book Value Rale Yield Earned Accretion 021M/toss Earnings Security Type: Federal Agency Coupon Securities 159200JY8 10438 1000 151.1 15,000,000.00 16073,595.97 15,072,914.32 3.000 2.829 37,500.00 -1,280.68 000 38219.32 4590511023 10381 1000 IBRO 11,000,000.0) 10,919,815.89 10,922,667.47 2.000 2.554 18.333 33 5,357.51 0.170 23,690 84 57629.71000 10925 1000 MASSMU 20,000,000.00 19,923,938.46 19/25.187.98 2.500 2.601 41,666 67 2,347.58 0310 44,014.25 60687Y1'P43 10359 1000 1.1121.1NY 15,000,000.00 15.489,533.79 15.483.493 03 3 549 2 510 44,362_60 -11,34932 0.00 33.013.18 88579Y886 10919 1000 1.11.21.2 10,000.000.00 10,703259 28 10,260,714.78 3 250 2.553 27,033.33 -4,836.91 0.00 22,246 42 85579YA219 10346 1000 1,11%11,1 20000,000.00 20,062,234.15 20,061,472.08 2.250 2.117 37,500.00 -1.431,78 0.00 36,068.24 53491513X1 10806 1000 1.,15FT 25,000000.00 25,377,149.00 25,373,443.02 2.875 2.455 59,89584 -6,962.75 0.00 52,933.09 84255,641,26 10894 1000 MUFG 10,000,000.00 10,341,686.35 10,338,379.82 3.750 2.855 31,250_00 -6,178.45 0.00 25,071.55 63743HER9 10911 1000 INRUC 14,003000.00 14,079,839.55 14,077,738.61 2.000 2500 33,840.58 -3,947.23 0.00 29,893.35 6374311E01 10924 1000 NRUC 6,000,000.00 5,937,369.15 5,938,258.90 2.300 2.612 11,00020 1,671.65 0.00 13,171.65 6937 £RP8.3 10926 1000 PCAR 20,000,000.00 19,930,010 00 19.990.10.63 2.650 2.619 44,166.67 300.00 0.00 44,466.67 717081DX8 10907 534120 PliZER 7,194,000.00 7.119,668.77 7.121,464.67 1.950 2.490 11,690.26 3,388.49 0.00 15.058.75 71817261J2 10958 1000 PSI 5,000.000.00 4.414.605 93 4,945,266 34 2.125 2.399 8,854.16 1,222.82 0.00 10.076.93 8225621360 10908 534120 RDSALN 0.539.000.00 8,429,724 61 8,432,455.15 1.875 2.5/9 13,342.18 5,13030 coo 18,472.48 606513AT2 10591 1000 SCHW 25000,000 00 25,994,25420 25,093,054.71 2.650 2.465 55,208.33 -2254,90 0.00 62,953.43 885621(8111 10961 1000 8.13/.1%1IT 100003000.00 9,391,670.00 9,991,744.62 2.606 2.684 22,466.67 140.00 0,00 22506.67 8656212AEO 10966 1000 SULWIT 17,156000.00 0.00 13027,948.30 2.058 0.117 930.67 35584 0.00 1,376.71 892331AB5 16398 1000 TOYCC 17,000,000.00 17,187,799.16 17,103,569.65 3.163 2.545 45,092.55 -7,946_36 0.170 37,146.14 39236TFX8 10904 1000 TOYCC 15,000,000.00 14291,503.75 14,991,643.47 2.650 2.622 33,12500 262.50 0.00 33,367.50 892361FN0 117920 1000 TOYCC 10,000,040.00 10,291,20326 10,26,8,169.51 3.450 2_619 28,750.00 -5,868.91 0.00 22,881.09 9113128C9 10944 1000 UPS 17,430,000.00 17,500,159.05 17,459.054_21 2.850 2.156 34,133.75 -2,014.60 0.00 32,039.15 911591-91V5 10399 1000 US-13?:K 12,000,000.00 12,251,743.32 12,249,268 09 3.375 2.797 33,760.00 -4,650.43 0.00 29,09957 9128281150 10785 534L6P USTR 000 24,965,749.57 24,177,995.77 1.000 2.612 20,380.43 33,250.43 0.00 53630_86 961214DA8 10910 1000 WESTP 14,449,000.00 14,246,229.71 14,250,616.95 2.000 2.671 24,031.67 8242.69 0,00 32324.36 9612141359 10923 1000 WESTP 7,588,000.00 7,555,053.91 7,555,478.16 2.750 2.834 17,339.17 797.08 0.00 18,5136.25 9493315P13 10876 1000 WFBC 9,414,000.00 9,452,279.03 9,451,420.56 3.325 3.049 26034 63 -1,612138 0.00 24,471.75 95000U206 10903 1000 wrac 10000,000.00 10,262,592 28 10,259292.77 3.750 3_026 01,280,00 -4,883.92 0.00 26368.08 9500051206 10921 1000 WFDC 20,000,000.00 20.596.077.32 20.500.770.57 3.760 2.939 62,600.00 -11,097.53 0.00 51,402.47 94983i5V5 10932 1000 1AFBC 20,000.000.00 20.000.000 00 20,000,030 00 2.900 2.845 48,333.33 0.00 0.00 48,333.33 Subtotal 757,696,000,00 816.616,612.81 811,547,133.61 2.624 1,695021.34 .16011.09 129,647,29 1,803,847.54 Security Type: Federal Agency Discounts 313312KA7 10771 1000 FCDN 0.00 24,992,833.33 3,225,459.68 2.550 2.618 0.00 7,166.67 0,00 7,166 67 313310688 10780 1000 FCDN 0.00 19,971,22222 12044,40681 2.590 2.628 0.00 28,777.76 0.00 23,777.78 313317K55 10781 1000 FCDN 0.00 9,993,418.67 1,612,672.04 2.580 2.619 0.00 3.083,33 0.00 3,583.33 3133125512 10/82 1000 50081 09000,000.00 19,932,763.89 19,956,166.67 2.630 2.872 0.00 45294.44 0.00 4529414 34333412133 10658 5345P FHON 50,000,000.00 49,815,133.89 49.866.916.67 2.433 2.480 0.00 104,194.44 0.00 104,194.44 P01110110 INVT AP Rsn Data OW11/2019- 1523 Tr (r-RF TE) 7.36 Reccat SV. 7.3 BA MARICOPA COUNTY TREASURER Total Earnings Page 3 August 1, 2059 - August 31, 2019 Adjusted Interest Earnings Ending BegInntng Average Current Annualized Interest Amortization/ Rea itzed Adjusted Interest CUS1P investment Fund Issuer Par Value Book Value Book Value Rate Yield Famed ACCfetIon Gaintkoss Earnings Security Type: Federal Agency Discounts 313396..1E7 10554 534BP FMCDN 20,000,000.00 19.923.366 67 19,944,877.78 2.420 2.460 0.00 41,677.77 0.00 41,677.77 Subtotal 90,000,000.00 144,631,761.67 107,502,491.64 2.527 0.00 230,6%4.43 239,694.43 Security Type: Treasury Coupon Securities 46625145X9 14943 1000 JPAIIIB 10000,000 00 10,476,055.06 10,471,695.08 3620 2.502 30,703.55 -8.447.46 0.00 22,256.09 912828E62 10783 5341iP 1311R 17,186,000.00 17,932,93535 17,942,30861 1.500 2.677 22.726.87 18.059_94 0.00 40,786.81 9128263H1 10787 534BP USTR 25,000,000.00 24,917,907.07 24,928,762.34 1.750 2.744 37.056.01 21,032.07 0.00 58,088.08 9128262X7 10859 534BP USTR 50,060,000.00 49,907,602.16 49,932,241.59 1.375 2.455 58.230_88 47,738.59 0.00 105,989.77 912828XU9 10952 534610 USTR 75,000,000.00 74,704,316.74 74,719,147_25 1.500 1.954 95,28669 28,734.11 0.00 124,021.00 Subtotal 177,936,000.00 177,938,865.38 177,914,152.86 2.323 244,004.20 107,117.55 0.00 351,121.75 Security Type: Treasury Discounts -Amortizing 91279301,13 107E6 53494 USIR 25,000,000.00 24,822,375.100 24,851,37500 2.610 2.662 0.00 66,187.50 0.00 58,18720 9128281.373 10634 6341-iP USTR 13,158,000.00 13.097,989.96 13,105,049_97 1.207 1.229 0.00 13,678.76 0.00 13.678.76 9128281E3 10151 53408 LISTR 10.000.000.00 9.981,217.05 9,933,426_81 0.497 0.505 0.00 4,281.41 0.00 4,281.41 Subtotal 48,158,00000 47,901,682.01 47,939,851.78 1.821 0.00 74,147.67 0.00 74,147.67 Security Type: Federal Agency Callables 313101-1.1117 10402 1000 FFCB 12,250,00000 12,250,000.00 12,250,000.00 1.970 1.933 20,110.42 co 0.03 20,110.42 3133E18003 10684 1000 FFCB 10,000,000.00 9,921,042_22 9,925,244.81 1.670 2.588 13.916.67 7,695.77 0.00 21.612.44 3133E,M.34 10739 1000 FFC..8 10,000,000.00 10,000,000.00 10,000,000.09 2.082 2.045 17,351.09 0.00 0.00 17,351.09 3133EMS4 10740 1000 FFC13 15.000.000.00 15,000,000.00 15,000.000.09 2(182 2_043 26,026 62 000 0.00 26,026.62 3132.8W11..15 10934 1000 FFCB 0.00 25,000,000.00 10.935.483 87 2690 2.727 39,229.57 0.00 0.00 39,229.17 3133ERWa 10963 Iwo FFCB 35,000.000.00 35.000,000.00 58.080.00000 2.200 2.159 64,108.07 0.00 0.00 64,166.67 31330(268 10968 woo FFCB 30.000.030.00 000 18,387,016.77 2 230 2.142 33,450.00 0.00 0.00 33.450 00 3133E1<C-38 10970 1000 FFCB 30,1900,000.00 0.00 11,612.903_23 2.270 2.110 20,808.33 0.00 0.00 20,808.33 315394061 10971 1000 FFCB 25,000,000.00 0.00 9,677,41935 2.100 1.952 16,041.67 0.00 0.00 16,041.67 3133E1(202 10973 1000 FFCB 30,000,000.00 0.00 9,677,419.35 2.190 1.998 16,425 00 0.00 0.00 16,425.00 3133EKE23 10974 1000 FFCB 25,000.000.00 0.00 7,258,064.52 2.020 2 001 12,333_33 0.00 0.00 12,333.33 3133E10358 10976 tow FFCB 30,000,000.00 0.09 2,903.225.131 2.060 2291 5.650,06 0.00 0.00 5,650 00 3133E1(059 10180 1000 FFCB 15,930,000.00 0.00 2,577,419 35 2,030 1.647 3,60436 0.00 0.00 3,604.38 31304.5NRO 10178 1300 FHLB 20.000.000 00 19,998,683.76 19,998,934.01 1.125 1.137 18,750.00 564.10 0.00 19,314,10 3 I 30.443. 11K1 10318 1000 FHLB 10000,000 00 10,000,000L06 10,000,000.00 1.750 1.717 14,58333 0.00 000 14,683 33 31307.8009 10385 1900 FHLB 30,000,000.00 30,000,000130 30,000,000.00 1.600 1.570 40,000.00 0.00 0_00 40,000.00 3130A6PV2 10423 ctao FHLB 25,000,000.00 25.000.000.00 25,000,000.00 1.690 1.658 35,208.34 0.00 0.00 35,208.34 3130613245 10463 1000 FHLB 15,000,000.00 14.994,076.68 14,994,367.69 1.625 1.638 20,312 50 546.77 000 20,65927 3130A0A2 10535 1000 FH LB 20,000,000_00 20,950,545.07 20,044,43675 2.375 1.650 39.583-34 -11,487.61 0.00 28,015.83 P04101-0 INYT AP 12, 0.2.z: 0.W110019- 1629 TE (PR.F_TE} 7.3 6 Re-part VET, 7_3 6_1 MARICOPA COUNTY TREASURER Total Earnings Page 4 August 1, 2019 • August 31, 2019 Adjusted interest Earnings Ending Beginning Average Current Annualized Interest Amortizationf Realized Adjusted Interest CUS4P Investment I Fund issuer Par Value Book Valve Book Value Rate Yield Earned Accretion GainVLoss Eamlngs Security Type: Federal Agency Callables 3130ACRCO 10543 1000 FRLB 20000,000.00 20,000,000.00 20,000,000.00 1.880 1.845 31,333 33 0.00 0.00 31,333.33 3130ADF31 10590 1000 FHLB 25,000,000.00 25,000,000.00 25,000500.00 2 140 3.100 44,58333 0.00 0.00 44,583.33 3130ADFAS 10600 F141_13 0.00 20,000,000.00 7.096.774.19 2 300 2332 14,055.56 0.00 0.00 14.055.56 3130ADJR4 10609 1000 FHLD 25000000.00 25,003,000.00 25.000.000 00 2 375 2 330 49,479.17 0.00 0.00 49.479.17 3130ADKE1 10610 1000 FHLB 25,000900.00 25.000.000.00 25900000.00 2209 2 203 48,875.00 0.00 0.00 46,875 09 3130ACTU8 10705 1000 FHLB 20,000,000.00 19,771666.30 19,779,310.44 1.900 2.742 31666.67 14.390.78 0.00 46,057.45 3130ACYL2 10706 1000 FHLB 20,000,000.00 19803,00599 19614,039.98 2.100 2.754 35.000.00 11,33828 0.00 46,338.28 3130AF5N13 10777 1000 FHLB 25,000,000.00 25,000,000.00 25600,900.00 3.150 3.091 65.62500 0.00 0.00 65,625.00 3130AFF134 10811. 1000 FF1LB 20,000,00090 20,000,000.00 20,000,000.00 3.150 3091 52500.00 0.00 52,500.00 3130AFZ59 10878 1000 FFILB 20,000,000.00 25,000,000.00 20,000.000.00 3.550 2.453 41,666.67 0.00 9.00 41,666.67 3130AFZ67 15886 1000 FOILS 25,000,000.00 25,000.000.00 25930000 00 2 650 2.600 55,203.34 0.00 0.00 55,208 34 3130AFZ67 10887 1000 FELE; 25.000.000.00 24913602 53 24,993968.41 2,650 2.615 55208.34 312.50 0.00 65,520.84 3130AGLY9 10941 53413P FHLE3 50.000.000 00 35000900 00 35,000,00050 2.500 2.208 159,375.00 0.00 000 169,376 00 3130AGV243 10969 1000 FHLB 10,000,000.03 0.00 6,129,032_26 2.160 3.094 10,900.00 0.00 0.00 10,900.00 3130AGXY6 10977 1000 FOILS 25,000,000.00 0.00 2,410,354.88 2.150 2.180 4,479.17 13.00 0.00 4,479.17 3130AGXY6 10978 1000 RILE 25,000,000.00 0.00 2419,354.84 2.150 2.180 4,479.17 0.00 0.00 4,479.17 3134GAW.19 10293 1000 HILMC 20,000,000.00 25,000,000.00 20,000,000.00 1.400 1.574 23,333.33 0.00 0.00 23,333.33 3134 GAWF7 10298 1000 FHLMC 20,000,000.00 20,000,000.00 20,000.000.00 1.300 1276 21,666.67 0.00 0.00 21,666.67 3134 GAY00 10299 1000 FHLMC 20,000,000 09 20,000.090.00 20,05505009 1.300 1,276 21,666.66 0.00 0.00 21.66886 3134GAZV9 10335 1000 FHLMIC 25,000.000.00 25,000,000 00 25,000,00000 1.510 1.482 31,458.34 0.00 0.00 31,458 34 3134G8034 10356 1000 FHLMC 10.000.000.00 10,000,000 00 10,000,000.00 1.700 1.669 14,166.67 0.00 0.00 14,166 67 3134G8LWO 10373 1000 FHLMC 0.00 25000,00000 12,096774.19 1.590 1.521 15,625.00 0.00 0.00 15,625.00 01344102475 10397 1000 FHLMIC 20,000,000.00 30,000,000.00 30,000,1300.00 1.700 1.668 42,500.00 0.00 0.00 42,500.00 3134Gi3PK2 10401 1000 FHLMC 25,000,000.00 25,000,000.00 25,000,000.00 1.700 1.668 35.416.66 0.00 0.00 35,416.66 31340 BJ.12 10405 1000 FFILMC 20,000,000.00 20,000,000.00 20,000,000.00 1.750 1.717 29,166 67 0.00 0.00 29,568.67 313408.110 10417 1000 FHLMC 20,1300,00050 20,000,000.00 20.00000090 1.700 1.658 28,333.33 0.00 0.00 28,333.33 3134GBXG2 10422 1000 FHLMC 20,000,000.00 20.000,000.00 20.000.000 00 1.550 1.521 25,833.34 0.00 0.00 25,833.34 3134GBZC9 10491 1000 FR= 30,000,000.00 30900000_09 30,000,000.00 1.850 1.815 4625090 9.00 0.00 46.250.00 313408E75 10482 1000 FHLMC 25,000,000 00 25,006,202.07 25605,809 08 1.800 1.731 37,500.00 -738.34 0.00 36,761.66 31340M:55 19487 1000 FHLIVC 20,000,000.00 19,922,304.83 19,925.272.81 1.750 2.553 29,166.67 5,576_21 0.00 34,742 88 313-4GBH21 10516 1000 FHLMC 25,000,000.00 24,968,091.60 24,078,310.51 1.700 1.778 35,416.66 2.290.03 090 37,706.74 3134GBX72 10518 1000 FHLMC 25,000,000.00 25,000,000.00 25,000,040.00 1.850 1.815 38641.67 0.00 0.00 38,641.67 3134081-11.2 10533 1000 FHLMC 13,893,00050 13,891,952.47 13,892,151.60 1.625 1.626 18,813.43 374.12 0.00 19,187.55 313408564 10557 1000 FHUAC 25,000,000.00 25,000,000.00 25090 WO 00 830 1.796 3.8,129.07 0.00 0.00 38,125.00 313408203 10558 1000 FHLMC 30,000.000.00 3000060090 30009000 00 2 000 1.962 50,000.00 0.00 0.00 50,000.00 31340 020.2 10559 1000 FHI_MC 25.000.000 00 25000900 00 25000,000.00 1.840 1.805 38333.33 0.00 0.90 3833383 31340BY55 10.550 1003 FHLMC 00 16900,000.00 8,709,677.42 2 250 3.281 16,875.00 0.00 0.00 16,875_00 Portfolio INVT AP 0e'aL 0371177015 - 1529 TE 1PRF_TE) 7.36 Repxt Ver. 7.38 1 -o CO patIrOV 1 56.1614, 1 S6UILtir3 I.r.• .18 :53 z.2 ei C) 4 Saitui tlialui u pup cg 44 > 0 .8 9`q 1;igi§i .28 :Z.' 2 -§§§§§§§§§ t 8 4 88888E888888888 10,1 00000000000000000 000000000000000300 2 -11n§EEEMWPW1 ggaa gvz,64 s§gMHggvv,-.46,-48828 .28888888888888t iS jE 000000000000000000000000MODOR 660000nocl000noc00000nocoo86' §§MMMIMM§MMU 2 -gtgg§gM§M§gggEggggn, "Pr. 28 kkkMkKVWKKkSekS 0 88 03 §§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§E§§§ 8888888888888888888888888888888888888 00M§§§§§;§§§§§§§§ 88828812888888888888288888888888888888 MMMEMM§§§HMMMA§§M.§$ !or. 8889.1g1184.7.1885-4'888888E,"885-',888888888888 8888g88 P 8888888888888888888288888888888888888 3 ""M"""M"gFW 8488 r...,0303 03 OPPP5'PP it 4 T.P 'a. ", 88888888 8 !0 4 88t2:8828885:88888888 00"00000000000000:=1 0 Min'in"MMW_CM WAn§gss88gugg8 P z. PP 2 ggggnM MEMU Mgg2gE 00 4 88b22888 P Fo1 0 P 88 • KNEI 61-0V11057 - 6Z9L MARICOPA COUNTY TREASURER Total Earnings Page 6 August 1,2019. August 35 2019 Adjusted Interest Earnings Ending Beginning Average Current Annualized Interest Amortization, Realized Adjusted Interest CUS1P Investment I Fund Issuer Par Value Book Value Book Value Rate 'field Earned Accretion GainVLoss Earnings Sectulty Type: Federal Agency Callables 313604.3,62 10300 1000 FNMA 25000,000_00 25,000,000.00 25,000,1300.00 1.000 1.472 31,250.00 000 0_00 31,200.00 313504-IBA 10301 1000 FNMA 15,000,000 00 15,000x0.00 15,000,000.00 1_625 1.594 20,31260 000 0.00 20,312.60 3136G4KD4 10307 1000 FNMA 20,000,00000 20,000,000.00 25000,000.00 1.750 1.717 29,16687 0_00 0.00 29,166_67 3136G4KM4 10315 1000 FNMA 25000,000.00 25,000,000.00 25,000,000.00 1.750 1.717 36458 33 0.00 0.00 36,458.33 313560553 10317 1000 FNMA 30,000,000.00 30,000,000.00 30000.00000 1,700 1,658 42,500.00 0.00 0.00 42,500.00 3136G4P43 10483 1000 FNMA 20.000.000 00 19,992.132 03 19,997433 35 1.750 1.751 29,166.67 566.03 0.00 79.732_70 3135601-86 10555 1000 FNMA 20009000 00 20,000000.00 20,000,010.00 1.850 1.913 32,500.00 0.00 0.00 32,600.08 313568807 10536 1000 FNM.A 20000000 00 19,887,754.45 19,892,042_27 1.700 2.164 28,333.34 8.05590 0_00 35.30824 3136G4TE3 10763 1000 FNMA 0.00 25000,000.00 15,322,52565 2.900 2.940 38,263.89 0_00 0.00 38.263.89 45905U6R0 10858 1000 IBRO 25,000,000.00 25000,000.00 25,000,000 00 2.770 2_718 57,708 33 0_00 0.00 67,708.33 45905U226 10935 1000 1BRO 35,000,00085 35.000,00000 35,000,00085 2_48-0 2.453 72,333 33 0.00 0.00 72,333.33 459051.16009 10960 1000 I BRO 25,000,000.00 25,000.00000 25.000.000.00 2.308 2.257 47,916 66 0.00 0.00 47,916.66 45666FAE4 10972 1009 ICE 20,000,000.00 000 7,175,973 81 2.350 -31.180 -188,000.00 .2032.61 0.130 -390,032_61 90331021._32 10989 1000 USSIZK 8,300000 00 6346,14293 8,345,554.44 2.650 2.625 19,712.50 -1,105.66 0.130 18,608.84 Subtotal 2,292,298,000.00 2,178,581,938.17 2,202,030,784.42 1.904 3,632,464.65 38,257.41 -8,904.26 3,561,817.60 Security Type: Private Placement - LT MESD1R 10953 1000 MESO 330,000.00 330,000_00 330,000.00 2.130 2.090 565.75 0.00 0.00 585.75 7,IESD2R 10954 1000 MESO 335,000.00 335,000.00 335,000.00 2.130 2.090 594.83 0_00 0.00 594.6.3 MESD3R 10955 1000 1.11180 345,000.00 345.000,00 345,000.00 2.130 2.050 61737 0_00 0.00 612_37 MESD4R 10956 1000 M [SO 350,000.00 350,000.00 350,000.00 2.130 2.050 621_25 0.00 0.00 621_25 1,105056 10957 1000 MESD 355,000.00 355,000.00 355,000.00 2.130 2.063 630.13 0.00 0.00 830.13 PHX.E01643 10217 1000 P1-10530 2,025,00000 2.085.222.66 2063.27540 3.570 1.351 6024.37 -3,656.61 0.00 2,367.76 PHXE016C 102113 1000 PHOESO 4.130.000.00 4.291.527.16 4,237,789.15 3.570 1.445 12,286.75 .7pn.s2 0.00 5263.83 RVR2018431_3 10243 1000 RIVES° 1.650.000.00 1,65000000 1,550,000.00 1.300 1.276 1,787.60 ciao 0.00 1,787.50 RV19201681_4 10244 1000 RiVESD 1,355,000.00 1,255,000.05 1,355,000.00 1.420 1.393 1,603_41 0.00 000 1.603.41 RVR2016R 3 10247 1000 RNESD 1,045,000.00 1,074,823.47 1,073,380.40 4.500 1.325 3,918.75 -2,711.22 0.00 1.207.53 RVR2016R 4 10248 1000 R1VESD 1,095,000.00 1,095000.00 1,094,00.00 1.420 1.393 1,295.75 000 0.00 1,295.75 561100109 10592 1000 $CFD 68000.00 59,96322 59,66.923 6.140 2.327 296.77 -178.47 0.00 118.30 SC-FD018C 10593 1000 Selo 62,000.00 66,150.69 66,033.95 6.140 2.414 317,24 -181.77 0.00 135.47 561100180 10594 1000 SCFD 65000.00 71,377.80 71.260.54 6_140 2.464 332.58 -18223 0.00 150.38 Subtotal 13,200,000.00 13,444,094.75 13,456,678.72 1.487 30,907.25 -13,933.21 0.00 16,974.04 Secuilty Type: Money Market Account 0924811718 10661 1000 BLIC1,11,1 0.00 40,000,000 00 14,193 548 39 0.03 0.00 0.00 0.00 052490700 10737 1003 BL(1,11,1 0.00 145000,000.00 168648,387.10 tato 0.00 0.00 000 0924341551 10825 1000 BLKIVIM 25,000,000.00 25,000,000.00 25,000,000 00 0.00 0.00 0.00 0.09 Portfolio LI,IVT AP De%-: VS11/2019 - 1529 TO IPR,F_TE) 7.3 8 Recc9 Wr. 736.1 MAR1COPA COUNTY TREASURER Total Earnings Page 7 August 1, 2019 - August 31, 2019 Adjusted interest Earnings Ending Beginning Average Current Annualized Interest Amortization/ Realized Adjusted Interest CUS4P Investment I Fund Issuer Par Value Book Value Book Value Rate Yield Ea rned Accretion Gaini/Loss Earnings Security Type: Money Market Account 38I41W273 10680 1000 GSM kt 245,000.00000 315400,000 00 320,806,451.61 0.00 0.00 0.00 0.00 48 I 2C0670 10654 moo JVPMM 95,000,00000 80,000,000.00 104,838,709.68 0.00 0.00 0.00 0.00 4812A0375 108/9 1000 JMN.9/.9 aro 0.00 0.00 0.00 0.00 0.00 0.00 XXX1518 10006 1000 1PM 374,878,352.50 359.878.34150 393.5E18,069.92 0.00 0.00 0.00 0.00 665279873 10424 1000 NTMM 0.01 0.01 0.01 000 000 000 0.00 865275673 10425 suos I.STM1,1 -25,718,42 -25.718.42 -25,71842 0.00 0.03 0.00 Subtotal 739,852,074.09 1,004,852,674.0 4,026,949,448.28 0.00 0.00 0.00 0.00 Total 4,169,990,67449 4,426763,818.26 4,427,843,977,04 1,631 5,602,39744 609,483.86 120,943.03 6,132,824.33 Portfolio INVT AP Run Date- 09/1112019 - 1629 TO (PRF_TE) 7.36 Recort Ver. 7.3.01 Maricopa County MARICOPA COUNTY TREASURER Selected Funds Total Earnings Sorted by Security Type - Issuer August 1,2019 - August 31, 2019 Adjusted Interest Earnings Ending Beginning Average Current Annualized Interest Arnortizationt Realized Adjusted Interest CLISIP Investment C Fund Issuer Par Value Book Value Boot/Value Rule Yield Earned Accretion OaIntn-oss Earnings Security Type: Commercial Paper Disc. -Amortizing Subtotal 40,000,000.00 39,697,383.35 39,743,427.79 2.643 0.00 89,211.10 0.00 89,211.10 Security Type: Federal Agency Coupon Securities Subtotal 767,646,00000 818,615,51281 811,547,133.61 2.624 1,695,021,34 -16,01109 129,847.29 1,808,857.84 Security Type: Federal Agency Discounts Subtotal 10,030,000.00 144,631,766.67 107,602,419.64 2.627 0.00 230,694.43 0.00 230,694.43 Security Type: Treasury Coupon Securities Subtotal 177,988,000.00 177,938,866.38 177,994,152.86 2.323 244,004.20 107,117.65 0,00 351,121.75 Security Type: Treasury Discounts -Amortizing Subtotal 48,158,000.00 47,901,682.01 47,939,851.78 1.821 0.00 74,14747 0.00 74,147.67 Security Type: Federal Agency Caltables Subtotal 2,292,298,000.00 2,178,681,938.17 2,202,030,784.42 1.904 3,532,464.65 38,257.41 -8,904.26 3,661,817.8A Security Type: Private Placement - LT Subtotal 13,200,000.00 13,444,094.78 13,435,678.72 1.487 30,901.25 .13,933.21 0.00 16,974.04 Security Type: Money Markel Account Subtotal 739,852,674.01 1,004,852674.09 1,028,949,448.28 0.00 0.00 0.00 0.00 Total 4,159,190,674.09 4,425,763,818.28 4,427,143,977.09 1431 5,602,397.44 509,483.86 120,943.03 6,132,824.33 PortroE0 I NVT Data Updated: 'REPORT-: 0911112019 16:26 AP Run Dame: 66/110019 - 1625 TE(Pfir TE)73 R-*Xt Vet 7.3 61 PROGRAM ID: APP LEVY_RPT MONTH_SUM 03-SEP-2019 MARICOPA COUNTY TREASURER'S OFFICE PAGE: 1 SECURED LEVY AND ACTIVITY FOR AUG 2019 YEAR LEVY BEGINNING BALANCE COLLECTIONS ADJUSTMENTS ENDING BALANCE 2019 5,268,316,083.92 5,268,316,083,92 22,192,959.21 .00 5,246,123,124.71 2018 5,032,079,420.54 47,832,179.21 6,096,883.25 392,519.46- 41,342,776.50 2017 4,791,587,056.58 1,919,354.77 5,282.41 106,751.80- 1,807,320.56 2016 4,643,191,878.76 1,793,135.86 14,881.64 24,228.22- 1,754,026.00 2015 4,364,407,727.86 1,580,563.31 1,971.05 .00 1,578,592.26 2014 4,243,506,812.16 1,228,423.81 11,674.28 .00 1,216,749.53 2013 4,019,480,209.28 697,657.92 667.63 2,059.44- 894,930.85 2012 4,045,298,460.92 1,388,602.59- 1,263.72 2,220.92- 1,392,087.23- 2011 4,138,461,193.04 20,600,980.06 1,080.72 1,878.70- 20,598,020.64 2010 4,411,089,394.04 43,166,927.07- 954.72 2,393.08- 43,170,274.87- 2009 4,593,263,862.98 86,907,210.29 929.12 158.48- 86,906,122.69 2008 4,288,606,572.70 25,935,170.92 818.84 155.30- 25,934,196.78 2007 4,001,594,678.74 744,851.24- 921.34 155.38- 745,927.96- 2006 3,660,387,436,00 826,313.88- 1,160.80 176.80- 827,651.48- 2005 3,489,841,477.20 504,373.13 1,209.08 191.00- 502,973.05 2004 3,246,259,075.84 577,419.68 129.00 198.52- 577,092.16 2003 3,049,037,955.00 746,064.57- .00 .00 746,064.57- 2002 2,792,576,236.72 1,352,546.32- .00 .00 1,352,546.32- 2001 2,595,278,669.32 608,355.63 .00 .00 6013,355.63 2000 2,290,234,573.96 572,765.13- .00 ,00 572,765.13- 1999 2,106,718,697.02 679,735.76- .00 .00 679,735.76- 1998 1,939,463,904.72 762,994.27- .00 .00 762,994.27- 1997 1,800,100,659.36 651,656.34- .00 .00 651,656.34- 1996 1,631,715,958.46 79,012.26- .00 .00 79,012.26- 1995 1,683,783,514.12 758,511.53- .00 .00 758,511.53- 1994 1,507,769,663.58 1,128,198.21- .00 .00 1,128,198,21- 1993 1,476,046,063.04 1,190,767.79 .00 .00 1,190,767.79 1992 1,477,426,592.42 3,577,206.37 .00 .00 3,577,206.37 1991 1,485,482,338.84 2,207,545.99 .00 .00 2,207,545.99 1990 1,445,084,095.32 7,952,619.51 .00 .00 7,952,619.51 1989 1,306,266,536.54 6,122,152.43 ,00 .00 8,122,152.43 1988 1,181,440,841.12 3,264,787.16- .00 .00 3,284,787.16- 1987 1,049,888,299.56 22,355.94 .00 .00 22,355.94 1986 870,295,854.72 17,516.20 .00 .00 17,516.20 1985 721,770,831.08 86,095 .02 .00 .00 86,095.02 1984 600,944,379.84 21,166 .00 .00 .00 21,166.00 1583 530,525,148.42 28,883 .91 .00 .00 28,883,91 1982 451,214,378.40 11,573 .32 .00 .00 11,573.32 1981 402,942,488.72 13,529 .19 .00 .00 13,529.19 1980 373,230,675.34 11,274 .71 .00 .00 11,274.71 1979 382,783,606.36 15,972 .66 .00 .00 15,972.66 1978 365,594,731.04 17,517 .30 .00 .00 17,517.30 1977 360,443,065.88 12,427 .08 .00 .00 12,427.08 1976 332,461,242.68 12,599 .20 .00 .00 12,599,20 1975 294,189,512.68 10,864 .89 .00 .00 10,864.89 1974 251,690,646.52 8,954 .20 .00 .00 8,954.20 1973 224,585,826.94 6,216 .48 .00 .00 6,216.48 1972 191,805,552.44 5,885 .92 .00 .00 5,665.92 1971 165,623,012.50 4,111 .30 .00 .00 4,111.30 1970 138,694,628.82 1,998 .26 .00 .00 1,998.26 1969 126,692,073.74 922 .38 .00 .00 922.38 1968 116,414,184.58 331 .83 .00 .00 331.83 TOTAL 105,959,608,182.36 5,425,918,430.06 28,332,786.81 533,087.10- 5,397,052,556.15 PROGRAM ID: APP LEVY RPT MONTH SUM 03-SEP-2019 MARICOPA COUNTY TREASURER'S OFFICE PAGE: 1 UNSECURED LEVY AND ACTIVITY FOR AUG 2019 YEAR LEVY BEGINNING BALANCE COLLECTIONS ADJUSTMENTS ENDING BALANCE 2004 .00 197,750.52- .00 .00 197,750.52- 2003 .00 13,346,202.33- 115.55 224.21- 13,346,542.09- 2002 16,903,615.38 3,032,785.56 37.74 207.30- 3,032,540.52 2001 19,330,396.80 902,701.34- .00 .00 902,701.34- 2000 138,497,672.37 9,288,372.86- .00 .00 9,2138,372.86- 1999 122,871,629.32 28,468,134.14- .00 .00 28,468,134.14- 1998 122,881,710.56 25,522,877.08- .00 .00 25,522,877.08- 1997 115,134,253.32 22,894,507.41- .00 .00 22,894,507,41- 1996 102,673,892.06 35,081,073.19- .00 .00 35,081,073.19- 1995 113,747,601.86 28,757,855.67- .00 .00 28,757,855.67- 1994 162,209,939.25 8,100,170.22 .00 .00 8,100,170.22 1993 154,917,045.68 14,420,077.72- 62.22 .00 14,420,139.94- 1992 140,629,687.78 17,544,618.47- 57.50 .00 17,544,675.97- 1991 131,582,120.56 6,351,270.15- 60.17 .00 6,351,330.32- 1990 122,744,902.09 952,312.12- 54.59 .00 952,366.71- 1989 113,929,972.43 7,922,449.32- 62.37 .00 7,922,511.69- 1988 96,811,185.54 21,536,303.73- .00 .00 21,536,303.73- 1987 88,991,362.81 7,183,559.49- 79.87 .00 7,183,639.36- 1986 76,956,283.43 25,772,739.66- .00 .00 25,772,739.66- 1985 50,507,999.56 28,111,683.91- .00 .00 28,111,683.91- 1984 53,570,953.57 12,929,042.70- .00 .00 12,929,042.70- 1983 73,434,045.21 6,576,459.72- .00 .00 6,576,459.72- 1982 37,836,109.79 22,905,048.43- .0D .00 22,905,048.43- 1981 36,683,300.76 18,055,558.20- .00 .00 18,055,558.20- 1980 30,075,323.04 17,272,723.82- .00 .00 17,272,723.82- 1979 29,722,220.00 6,557,551.22- .00 .00 6,557,551.22- 1978 28,615,308.42 6,812,702.12- .00 .00 6,812,702.12- 1977 26,779,663.13 5,929,894.62- .00 .00 5,929,894.62- 1976 23,204,794.95 2,691,654.20- .00 .00 2,691,654.20- 1975 19,189,042.79 2,664,351.52- .00 .00 2,664,351.52- 1974 15,296,922.12 5,472,248.17- .00 .00 5,472,248.17- 1973 13,177,965.26 5,836,677.39- .00 .00 5,836,677.39- 1972 13,623,786.21 2,953,558.51- .00 .00 2,953,558.51- 1971 12,084,654.91 1,719,922.67- .00 .00 1,719,922.67- 1970 10,386,975.86 433,497.42- .00 .00 433,497.42- 1969 5,918,654.86 1,422,511.95- .00 .00 1,422,511.95- 1968 4,195,165.19 2,320,992.14- .00 .00 2,320,992.14- TOTAL 2,325,116,156.87 405,675,928.13- 530.01 431.51- 405,676,889.65-