Extracted text (via pymupdf_layout)
64355 characters
Royce T. Flora, Treasurer 301 West Jefferson St., Rm. 100 Phoenix, Arizona 85003 Maricopa County Phone: (602) 506-8511 Fax: (602) 506-1102 Treasurer http://treasurer.marieopa.gov DATE: May 21,2018 TO: Steve Chucri, Chairman Denny Barney, Supervisor, District 1 Bill Gates, Supervisor, District 3 Clint Hickman, Supervisor, District 4 Steve Gallardo, Supervisor, District 5 SUBJECT: Treasurer's Collections and Investment Summary for April 2018 Secured property tax collections during the month of April equaled $962,600,900 and increased the 2018 year to date collections to $4,075,646,438 or 85.37% of the adjusted 2018 levy of $4,773,986,827. The chart below reflects the 2018 collected and uncollected levy amount and corresponding percentages for the 2017 property tax year. APRIL 2018 Collected Levy $4,075,646,438 85% Uncollected Levy $698,340,389 15% • Collected Levy • Uncollected Levy The County's General Fund Balance totaled $331,034,933.38 effective April 30, 2018. Warrants outstanding of $26,244,340.02 will post against the fund balances when presented. The $22,890,673 unencumbered balance, of the County Municipal Line of Credit and the $12,109,327 Workers Compensation Liability Letter of Credit remain unused. Submitted under oath, Russell K. Pearce Maricopa County Treasurer Chief Deputy STATE OF ARIZONA ) ss. COUNTY OF MARICOPA ) This instrument was acknowledged before me this 21th day of May 2018, by Russell K. Pearce Maricopa County 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. --i2 C 47-1-6,6-il 240,--af Notary Public My Commission Expires 0 Notary Public -Arizona Maricopa Counly My Comm. Expires Dec 15, 2021 Maricopa County NIARICOPA COUNTY TREASURER Selected Funds Total Return Sorted by Security Type - Maturity Date July 1, 2017 - April 30, 2018 Yield on Time Weighted Value Investment Income Investment Beginning Time Weighted Ending Maturity Current Total Interest Adjustment Net Investment GUMP Investment 4 Fund Class Invested Value Invented Value Invested Value Date Rate Return Earned In Value Income Security Type: Federal Agency Coupon Securities Subtotal 752,590,522.75 742,096,964.01 725,992,905.78 * 1880 * 6,862,977.09 3,445,574.50 * 10,308,551.59 Security Type: Federal Agency Discounts Subtotal 1,017,049,050.79 916,028,811.10 * 922,748,051.37 * 0.744 * 0.00 5,691,656.08 • 5891856.00 Security Type: Treasury Coupon Securities Subtotal 187,823,590.50 150,440,490.47 198207,558,40 • 1.601 • 1,485,691.93 520,423.59 * 2,006,115.52 Security Type: Treasury Discounts -Amortizing Subtotal 0.00 2,119,731.91 34,963,327.78 1.576 0.00 27,1327.75 27,827.78 Security Type: Federal Agency Cailables Subtotal 1,109,0133,631.07 1,568,144,952.66 * 2,410,167,972.20 2.084 * 20,039,955.63 7,523,0132.68 * 27,562,988.31 Security Type: Private Placement - LT Subtotal 107,924,409.25 50,640,489.55 * 39,915,603.12 * 1.726 * 1,023,596.94 -295,764.46 • 727,842.48 Security Type: Private Placement - ST Subtotal 227,528,138.63 188,765,800.85 180,083,879.14 1.463 2,618,276.45 -318,40805 2,299,867.60 Security Type: Registered Warrants Subtotal 0.00 24,903.90 9.00 2.005 581.80 0,00 581.80 Security Type: Money Market Account Subtotal 105,711.92 20,958,891 08 660,102,803.73 1.676 274,475.79 5.09 274,475.79 - Adjustment and Market Value cannot be calculated due to mles1ng or outdated Market price dale Portfolio INVT Data Updated: —REPORT,: 0512212018 08:35 AP Run Date: 05122/2018 .06:35 GA (PRF_GA) 7.3.0 Report Var. 7.3.6.1 MARICOPA COUNTY TREASURER Selected Funds Total Return Page 2 Sorted by Security Type - Maturity Date Envestment Income Investment Beginning Time Weighted Ending Maturity Current Total Interest Adjustment Net Investment CLI Investment N Fund Class Invested Value Invested Value Invested Value Dale Rate Return Earned in Value Income Total 3,462,005,033.21 3,661,977,950.53 * 4,861,072,251.49 1.603 32,305,505.63 16,594,601.32 • 4E1,900,106.95 Components of Return' Interest 1.059 Amortization: -0.018 Markel Value' 0.562 - Adjustment and Markel Value cannot be calculated due to missing or outdated Market price data. Portfolio INVT Data Updated: —REPORT—: 0512212018 09:35 AP Run Data: 0522/2318 -00 35 GA (PRF_GA) 7.3.0 Ver Tad 1 Maricopa County MARICOPA COUNTY TREASURER Selected Funds Total Return Sorted by Security Type - Maturity Date July 1, 2017 - April 30, 2018 Yield on Time Weighted Value investment Income Investment Beginning Tinie Weighted Ending Maturity Current Total Interest Adjustment Net investment Investment Fund Crass Invested Value Invested Value Invested Value Date Rate Return Earned in Value Income Security Type: Federal Agency Coupon Securities 10002 1090 Fair Value 24,982,350.00 9,614,917.60 0.00 10126/2017 0,975 1.093 69,878.47 17,660.00 87,528.47 3134G9WL/7 10151 1000 Fair Value 24,950,600.00 14,773,322.37 12/20/2017 0.800 1,201 98,333.33 49,500.00 147.833.33 3133EGND3 10212 1000 Fair Value 19,950,600.00 17,325,521.05 0,00 03122/2018 0.809 1.146 116,000.00 49,400.00 165,400.00 3133EGNO3 10215 1099 Fair Value 24,93825090 21,656,901.32 3.00 03,222318 0.800 1.146 145,000.00 61,750.00 206,750.00 3104137600 10086 1000 Fan Value 14,948,25000 14,702,39363 0.00 04125/2018 0.950 1.376 116,770.84 51J50 00 168,620.84 3133EHGD9 10404 1000 Fair Value 24960.75000 24,960,75090 • 24,973,750.00 05121/2018 1.100 1.265 229.166.67 33,750.00 * 262,916.67 3130A136F6 10132 1000 Fair Value 19,940.200.00 19,940,200.00 • 19,953,00000 05123/2018 1.000 1 321 166666.67 52,800.00 • 219,466.67 3134066M0 10057 1000 Fair Value 24993,750,00 24,993,750.90 * 24,993,750.00 06/22/2018 1 250 1.652 280,416.67 83,530.30 343,916.67 3134392X8 10157 1000 Fair Value 29972,200.00 29672,200.00 • 29,895,000.00 08/27/2018 0.910 1.428 227,500.00 127,800.00 * 355.30000 313407133 10073 1000 Fair Value 19,928,800.00 19.928,800.00 • 19,943,000.00 06/29/2018 1.050 1.483 175,000.00 71,200.00 • 246,209.00 3130A8BD4 10134 1000 Fair Value 16,928,940.00 16,928,940.00 • 16,938,936.00 06/29/2019 0.875 1.093 123,958,33 3099300 154,048.33 3134G7302 10081 1000 Fair Value 24,855,250.00 24,855,260.00 • 24,895,250.00 07f2712018 1.000 1106 208.333.34 144,750.00 * 353,083.34 3134G8Y60 10105 1000 Fair Value 22.349.427.75 22,349,427.75 • 22,365,673.75 07/27/2018 1.000 1.410 188,875.09 75,572.25 * 262,447.25 3133EFMF1 10082 1000 Fair Value 24902,750,00 24,902,760.00 • 24,919,500.00 07130/2018 0,875 1.302 182,291.67 87,75030 * 270,041.67 3133EFMV6 10087 1000 Fair Value 29,900,700.00 29,900,700.00 • 29,915,700,00 08/02/2018 1.020 1.423 255,000.00 99,300.00 • 354,309.00 3134075P2 10088 1000 Fair Value 29,885,700.00 29,885,700.00 • 29901,900.00 08103/2018 1.000 1.464 250,000.00 114.390.00 * 364.300.00 313427=3 10079 1000 Fair Value 24,084,500.00 24.894,500,00 • 24,913,250.00 10/29/2018 1.100 1.614 229,16697 105,599.00 • 334,666.67 3134G73C3 10080 1000 Fair Value 14,936,700.00 14,936,700.00 • 14,947,950.00 10/29/2018 1.100 1.614 137.500.00 63.300.00 • 200,800.00 3136G2PF8 10085 1000 Fair Value 24.905.000,02 24,905,000.00 ' 24,901,260.00 10/29/2018 1.125 1.588 234.37590 95,000.00 * 324,375.00 31336111813 10406 534HP Fair Value 12.378.30090 12,378,300.00 • 12,385,864.00 11/01/2018 1.250 1.380 129.166.67 13,144.00 * 142,31067 313520049 10090 1000 Fair Value 14,900,71590 14,900,715.00 • 14,914,380.00 11/16/2018 1.160 1,848 145,000.00 84,285.00 • 229,206.013 3133EHKJ1 10412 534HP Fair Value 13,273,400.00 13,273,400.00 • 13,281,912.00 11/26/2018 1.220 1.399 135,216.66 19,418.00 164,634.66 3133EGM69 10303 1000 Fair Value 24,909,000.00 24,509,000.00 • 24,919,500.00 12/05/2018 1.100 1.424 229,166.67 66,355_25 • 295,521.92 3130A6VT2 10093 1000 Fair Value 20,064,800.00 20.084,80000 * 20,073,600.00 12)28/2018 1.330 0.939 221,866.66 -64,8o-o.00 156,866.66 3130A7KX2 10100 1000 Fair Value 14,986,200.00 14.965.200.00 " 14,984,250.00 12/28/2018 1.250 1.533 156,250.00 34,800.00 • 191950,00 3130A8WE9 10228 1000 Fair Value 14,347,956.95 14.347,956.95 ' 14,361,814.65 04/26/2019 1.100 1.036 132,320.83 87.043 05 • 219,363.88 3130A8WE8 10229 1000 Fair Value 5.531,443.05 5,531,443.05 • 6,636,785.45 04/26/2019 1.10e 1.836 51,012.50 33,556.95 • 84,569.45 3136G2040 10089 ICOO Fair VEIILID 34902,000,00 24,902,000.00 • 34,931,050.00 35/03/2019 1.260 1.601 367,503.00 98,000.00 • 465,500.00 3134G9MU8 10139 1000 Fair Value 24,888,750.00 24,888,750.00 * 24,961,250.00 05/24/2019 1.300 1.698 270,833.33 81,260 00 " 362,083.33 313503085 10145 1000 Fair Value 19,900,800.00 19,800600.00 • 19,568,200.00 06/13/2019 1,400 2008 233,333.33 99,200.00 • 332,633.33 3133EGNZ4 10224 1000 Fair Value 25,621,440.00 25,621,440.00 • 25.655.500.00 06/27/2019 0.950 2.726 206,633.33 375,960.00 • 581,793.33 - Adjustment and Market Value cannot be calculated due to missing or outdated Market price Cala. Portfolio INVT Data Updated- -REPORT--: 05)22)201808:33 AP Run Date: 85/22)2018.08:32 GAIPRF_GAI 7.3.0 Report Var. 7.3.6.1 MARICOPA COUNTY TREASURER Selected Funds Total Return Page 2 Sorted by Security Type - Maturity Date Investment Income Investment Beginning Time Weighted Ending Maturity Current Total Interest Adjustment Net Investment CU SIP Investment Fund Class Invested Value Invested Value Invested Value Dale Rate Return Earned in Value lucerne Security Type: Federal Agency Coupon Securities 3136133TD7 10153 1000 Fair Vale 19,841,400.00 19,841,400.00 * 19,863.600.00 06128/2019 1.200 2.078 200,000.00 143.400.00 * 343,400.00 3135130M26 10219 1000 Fair Value 24,646,500.00 24,646,500.00 * 24,67025990 07/26/2019 1.000 2.737 208,333.33 353,500.00 * 561,833.33 3138G3P33 10222 1000 Fair Value 19,689,00900 19689,000.00 19,716,200.00 0712612019 1.125 3.040 187.500.00 311,000.00 490,590.00 3133E11P9E1 10542 1000 Fait Value 0.00 3,179,497.89 • 5,491,80.00 11/06/2019 1.600 1.615 42,777.78 0.00 42,777.78 3136G3R98 10227 1000 Fair Value 19,705,200.00 19,705,200.00 * 19,742,600.00 0112812020 1.330 3.147 221,655.67 294,800.00 * 516,466.67 3130ADUJ9 10616 1000 Fair Value 0.00 2,420616.84 * 15,997,120.00 0313012020 2.375 2.356 47,500.00 0,00 * 47,50900 3133EJKY4 10651 1000 Fair Value 0.00 986,654.61 19,996.200.00 0411312020 2.375 2.408 19,791.67 0,00 19,79167 3133EHS95 10517 1000 Fair Value 0.00 9,516,884.74 15,084.160.90 1012612020 1.750 1.755 140,000.00 0_S0 * 140,000.00 3134GSDF9 10608 1000 Fair Value 0.00 5,098,684.21 * 25,000,000.00 02/2612021 2.420 2.493 105,875.00 0.00 * 105,875.00 Subtotal 752,590,522.75 742,095,964,01 • 725,902,905.75 * 1.668 • 6,862,977,09 3,445,574.50 * 10,398,551.59 Security Typo: Federal Agency Discounts 31331311142 10226 1000 Fair Value 40.000.000.00 263,157.89 0.00 07103/2017 0.610 0.00 0.00 0.00 3133851116 10368 1000 Fair Value 39,997,760.00 526,286.32 0.00 07105/2617 0,810 0.511 0.00 2,240.00 2240.00 31338511V1 10364 1000 Fair Value 19,997,780.00 394,693.03 0,00 07/07/2017 0.815 0.675 0.00 2,220.00 2.220.00 3133951172 10369 1000 Fair Value 34,640,377.44 1,139,486.10 0.00 07/11/2017 0.800 0.803 0.00 7,622.56 7,622.56 313385JA5 10379 1000 Fair Value 34,991,250.00 1,255.130 78 0.00 07/1212017 0.825 0.830 0.00 8,750.00 8,750.00 3133851E13 10382 1000 Fair Value 39,988,880.00 1.578,508.42 0.00 0711312017 0.820 0.846 0.00 11,120.00 11,120.00 3133851F4 10371 1000 Fair Value 34,956,365.00 1,841,388.68 0.00 07117/2017 0.820 0.888 0.00 13,615.00 13,615.00 313385102 10388 1000 Fair Value 44,951.100.00 2,515,390.46 0.00 07/1812017 0.790 0.902 0.00 18,600.00 18,900.00 31338511-10 10370 1000 Fair Value 29.956.680.00 1,775,527.11 0.00 0711912017 0.830 0.901 0.00 13,320.00 13,320.00 3133851143 10372 1000 Fair Value 1969060900 1,315,131.58 0.00 07121/2017 0.850 0.913 0.00 10,000.00 10,000.00 3133851147 10390 1000 Fair Value 44,973,765.00 3,402,620.38 0.00 0712412017 0,800 0.926 0.00 26,235.00 26,235.09 3133851C10 10375 1000 Fair Value 29,980,830.00 2,485,528.78 0.00 07128/2017 0.855 0.934 0.00 19,170.00 19,170.00 313385188 10387 1000 Fair Value 34,976,550.00 2,991,415.46 5.00 0712712017 0.810 0.941 0.00 23,450.00 25,450,00 313385166 10381 1000 Fair Value 44,969,770.00 3,993,936.81 0.00 0712812017 0.861 0.939 0.00 31.230.00 31,230.00 3133851X5 10377 1000 Far Value 34,970,250.00 3,681,078.95 0.09 08102)2017 0.850 0.970 0,00 29,750.00 29,750.00 313385770 10378 1000 Fair Value 39,963,720.00 4,469,626.58 0.00 0810412017 0.850 0.975 (Too 36,280.00 36,280.00 0133851607 10389 1000 Fair Value 44,954,100.00 5,619,262.50 0.00 08108)2017 0.860 0,981 0.00 45,90000 45,900.00 313599KE2 10383 1000 Fair Value 39,958,000 00 5,126,190.79 0.00 08/09/2017 0 800 0.984 0.00 42,090.00 42,000.00 313385KF2 10301 1000 Fair Value 29,967,609.00 3,943,105.26 0.00 08110/2017 0.860 0.987 0.00 32,400.00 32,400,00 313385KK1 10409 1000 Fair Value 21,174,772.00 3,064.769.63 0.00 08114/2017 0.930 0.988 0.00 25,228.00 25,228,00 3135594.6 10385 1009 Fair Value 24,969,500.00 3.696.143.09 0.00 08115/2017 0.810 -0.946 0.00 -29.125.00 -29,125.00 313385KM7 10384 1000 Fair Value 42,896,441.35 6499908.89 0.00 08/16/2017 0.860 0.991 0.00 53,558.65 53,658.65 313589KN2 10394 1009 Fair Value 24,968,250.00 3,860,222.85 9.00 08)17/2017 0.830 0.989 8.03 31,750.00 31,750.00 313385KS4 10421 1000 Fair Value 29.958,30000 5,025,899.01 0.00 08/21/2017 1.015 0.696 0.00 41,700.00 41,700.00 313589KU6 10395 1009 Fair Value 24,964,000.00 4,352,276.32 0.00 08/23/2017 0.860 0.993 36,000.00 36,000.00 - Adjustment and Market Value cannot Pe calculated due to missing or outdated Market price data. POrlfOlid TFATT Data Updated: -REPORT-: 05/204201808:33 AP Rae Date: 05122/0610- 00 .33 GA (pRF 73111 Report Ver. 7.3.6.1 MAR1COPA COUNTY TREASURER Selected Funds Total Return Pagie 3 Sorted by Security Type Maturity Date 313385KV7 10419 1000 Fair Value 39,941,200.00 7,094,818.42 GOO 08/24/2017 0.885 0.00 58.900,00 56800.00 313385K 78 10420 1000 Fair Value 29,952,390.00 5,714,600.72 0.00 08/28/2017 1.000 0.00 47,610.00 47,610.00 313385LA2 10393 1000 Fair Value 39,935,600.00 7,750,659.21 0.00 08/29/2017 0.998 0.00 64,400.00 64,400.00 312385L80 10426 1000 Fair Wive 0.00 6,666,604.21 0.00 08/30/2017 1.041 0.00 57,798.61 57.798.61 313385LJ3 10434 1005 Fair Value 0.00 1,322,041.98 0.00 09/06/2017 1.041 0.00 11,462.92 11,462.62 313385LJ3 10436 1000 Fair Value 0.00 6,109,488.28 0.00 09/06/2017 1.020 1.036 0.00 52.714,17 52,714.17 313385LKO 10442 1000 Fair Value 0.00 4.679.966.80 0.00 09/07/2017 1.015 1.031 0.00 40,177.08 40,177.00 313385LP9 10430 1000 Fair Value 0.00 7.814,011.40 0.00 09/11/2017 1.010 1.026 0.00 66,772.22 66,772.22 313385L07 10431 1000 Fair Value 0.00 8,930,045.32 0.00 09/12/2017 1.025 1,041 0.00 77,444.44 77,444.44 3133851.R5 10446 1000 Fair Value 0.00 6,437,138.60 0.00 09/13/2017 1,020 1.036 0.00 55,533.34 55,533.34 3133051.53 10460 1000 Fair Value 0.00 3,842,078.96 0.00 09/14/2017 1.005 1.020 0.00 33,500.00 33.500.09 313385LX2 10443 1000 Fair Value 0.00 9,067,372.04 0.00 09/19/2017 1.010 1.026 0.00 77,433.33 77.433,33 313385LY0 10457 1000 Fair Value 0.00 7,225,487.30 0.00 09/20/2017 1.027 1.043 0.00 62,761.11 62,761,11 313385MA1 10458 1000 Fair Value 0.00 4,046,169.88 0.00 09/202017 1.026 1.041 0.00 35,077.78 35,077.78 313385ME3 10464 1000 Fair Value 0.00 4,632,138.85 0.00 09/26/2017 0.494 1.009 0.00 38.951.67 38,931.67 313385MQ8 10437 1000 Fair Value 0.00 8,956,541.54 0.00 10/06/2017 1.045 1.062 0.00 79,245,83 79,245.83 313397MX5 10418 1000 Fair Value 34,895,000.00 11.937.763.16 0.00 10/13/2017 0.895 1.056 0.001 105,000.03 105,000.00 313385N88 10468 1000 Fair Value 0.00 690,523.52 0.00 10/17/2017 0.990 1.004 0.013 5,775.00 5,775.00 313589NH2 10430 1000 Fair Value 0.00 12,052,493.47 0.00 10/23/2017 1.030 1.047 000 105,145.83 105,145.83 313385PEO 10481 1000 Fair Value 0.00 1,331,232.67 0.00 11/13/2017 1.005 1.020 0.00 11,306.25 11,306.25 313385PG5 10407 534HP Fair Value 6,374.336.00 2,872,644.84 0.00 11/15/2017 1.035 1.073 0.00 25,884.00 25,664.00 313385PG5 10408 1000 Fair Value 13,545,464.00 6,104,370.29 0.00 11/15/2017 1.035 1.073 0.00 64,536.00 54,536,00 313385PG5 10545 1000 Fair Value 0.00 219,023.63 0.00 11/15/2017 1.010 1.024 0.00 1,668,50 1,868,50 313385PH3 10552 1000 Fair Value 0.00 920.844.88 0.00 11/16/2017 1.015 1.029 0.00 7,894,44 7,894.44 313589PM9 10471 1000 Fair Value 0.00 2,315,081.54 0.00 11/20/2017 0.990 1.005 0.00 19,387.50 19,387.50 313385PM2 10498 1000 Fair Value 0.00 1,035,573.73 0.00 11/20/2017 1.010 1.025 0.00 8,837.50 8,837.50 313385PM2 10550 1000 Fair Value 000 386,690.16 0.00 11/20/2017 1.010 1.024 0.00 3,299.33 3,299.33 313385PP5 10548 1055 Fair Value 0.00 894,331.23 0.00 11/22/2017 1.020 1.035 0.00 7,706.67 7,706,67 313385PR1 10499 1005 Fair Value 0.90 1,232,687.43 0.00 11/24/2017 1.010 1.025 0.00 10,520,83 10,520.83 313385PR1 10545 1000 Fair Value 0.00 1,775,409.87 0.00 11/24/2017 1.020 1.035 0.00 15,300.00 15,300.00 313385PU4 10544 1009 Fair Value 0.00 1,380,769.00 0.00 11/27/2017 1.005 1.020 0.00 11,725.00 11,725.00 313385PV2 10493 1000 Fair Value 0.00 1,676,023.38 0.00 11/2012017 1.015 1.030 0.00 14,379.17 14,379.17 GBUSD1030 10514 1000 Fair Value 0.00 201.04 0.00 11/30/2017 0.00 0.00 0.00 313385=3 10502 1009 Fair Value 0.09 1,774,512.83 0.00 12/05/2017 1.015 1.030 0.00 /5,225.00 15,225,00 31358901.0 10503 1000 Fair Value 0.99 2,196425.55 0.00 12/1312017 0.990 1.005 0.00 18.150,00 18,150.00 31358901\16 10507 1000 Fair Value 0.00 4,435,294.00 0.00 1211512017 0.990 1.005 000 37,125.00 37,125.00 313385022 10444 1000 Fair- Value 0.00 16,299,998.68 0.00 12/26/2017 1.080 1.100 0.00 149,400.00 149,400.00 - Adjustment and Markel Value cannot Se calculated duets missing or outdated Market price data. Portfolio TINT Data Updated: -REPORT-: 05/2212018 08:33 AP Run Date, 0122/2013 - 08:33 GA iERF GA) 7.3.0 Report Ver. T3R1 MARICOPA COUNTY TREASURER Selected Funds Total Return Page 4 Sorted by Security Type - Maturity Date Investment Income Investment Beginning Time Weighted Ending Maturity Current Total 'Interest Adjustment Net Investment CUSP Investment 6 Fund Class Invested Value Invested Value invested Value Date Rate Return Earned Ira Value lucerne Security Type: Federal Agency Discounts 3133138A8 10447 1000 Fair Value 0.00 13.012.131.99 0.00 12/27/2017 1.100 0.121 0.00 121,458.33 121,458.33 .313385RA6 10529 1000 Fair Value 0.00 4.597.511.99 0.00 12/27/2017 1,082 1.099 0.00 42,077.78 42,077.78 313385064 10491 1000 Fair Value 0.00 4,202,516.96 0.00 12/28/2017 1.070 1,087 0.00 38,044.44 38,044.44 313385002 10432 1000 Fair Value 0,00 8,636,235.09 0.00 12/29/2017 1.152 0.00 82,866.67 82,866.67 3133B5RC2 10441 1000 Fair Value 0.00 19,585,567.97 000 12/29/2017 1.111 0.00 181,212.50 181,212.50 313385002 10465 1000 Fair Value 0.00 6,038,467.69 0.00 12/29/2017 1.045 1.062 0.00 53,411.11 53.411.11 313385002 10466 1000 Fair Value 0.00 7,545,584.61 0,00 12/29/2017 1.045 1.062 0.00 66,763.89 66.763.89 313385004 10492 1000 Fair Value 0.00 5,906,263.16 000 01/05/2018 1,080 1.097 0.00 54,000.00 54.000.00 313385RQ1 10490 1000 Fair Value 0.00 5,053,979.15 0.00 01/10/2018 1.090 1.108 0.00 46,627.78 46.627,78 313385087 10580 1000 Fair Value 0.00 575.517.98 0.00 01/12/2018 1.250 1.268 0.00 6,076.39 6.076,39 01358901/V5 10531 1000 Fair Value 0.00 3.741.410.42 0.00 01/16/2018 1.085 1.103 0.00 34.358.33 34,358.33 3.133850X6 10581 1000 Fair Value 0.00 657733.92 0.00 01/17/2018 1.100 1.116 0.00 6,111.11 6,111.11 313385801 10519 1000 Fair Value 0.00 6,726,141.04 0.00 01/22/2010 1.144 0,00 84,062.50 64,062.50 313385501 10579 1000 Fair Value 0,00 6,726,141.04 0.00 01/22/2018 1.125 1.144 0,00 64,062.60 64,062.50 3133859E19 10509 1000 Fair Value 0.00 5,512,002.63 0.00 01/23/2018 1,110 1,128 0.00 61,800.00 51,800.00 313385509 10512 1000 Fair Value 0.00 6,890,003.29 0.00 01/23/2018 1.110 1.128 0.00 64,750.00 64,750.00 912796NPO 10584 1000 Fair Value 0.00 1,232,928.15 0.00 01/25/2018 1.215 1.232 0.00 12,656,25 12,656.25 313085502 10505 1000 Fair Value 0.00 5,773.623,39 0.00 01/26/2018 1.120 1.139 0.00 54,755,56 54,755,58 313397507 10604 1000 Fair Value 0.00 7,217,294.59 0.00 01/26/2018 1.105 1.123 0.00 67,527.78 67,527.78 313305503 10511 1000 Fair Value 0,00 8,856,710.53 0.00 01/29/2018 1.120 1.139 0.00 84,000.00 84,000.00 313305903 10530 1000 Fair Value 0.00 7,298,903.70 0.00 01/29/2018 1.115 1.134 0.00 68,913.19 68,913.19 313385502 10459 534M0 Fair Value 0.00 31,091443.45 0.00 02/02/2018 1.100 1.122 0.00 290,482.50 290,482.50 313385502 10540 1000 Fair Value 0.00 8,953,65863 0.00 02/02/2018 1.172 1.182 0.00 88.876.67 88,876,87 313085802 10547 1000 Fair Value 0.00 5,772,887.40 0.00 02102/2018 1.172 1.162 0.00 57,297,78 57,297.78 3133855(11 10553 1000 Fair Value 0.00 8,952,682.52 0.00 02/07/2018 1.215 1.236 0,00 92,137.60 92,137.60 3133850307 10585 1000 Fair Value 0.00 2,382,400.36 0.00 02/09/2018 1.280 1.299 0.00 26,777.78 25,777.78 31335899Z7 10525 1000 Fair Value 0.00 8,443,008.40 0.00 02/12/2018 1.130 1.149 0.00 80,826.39 80,826.39 31 33851A4 10595 1000 Fair Value 0.00 986,480.26 0.00 02/13/2018 1.105 1.116 0.00 9,166.67 9,166.67 313097187 10500 1000 Fair Value 0.00 4,209,581_27 0.00 02/14/2018 1.125 1.144 0.00 40.125.00 40,125.00 313385100 10590 1000 Fair Value 0.00 591,917.27 0.00 02/15/2018 1.275 1.288 0.00 6,350.00 6,350.00 3133051-H9 10597 1000 Fair Value 0.00 887,698.36 090 02120/2018 1.260 1.278 0,120 9,450.00 9,490.00 313305109 10532 1000 Fair Value 0.00 9,667,055.80 0.00 02/27/2018 1.160 1.181 0.00 95,055.56 95,055.56 3133051127 10538 1000 Fair Value 0,00 15,467,026.03 0.00 02/28/2018 1.165 1.186 0.00 152,744.44 152,744.44 3133971101 10537 1000 Fair Value 0.00 17,032893.42 0.00 03/12/2018 1.170 1.191 0.00 169600.00 169,000.00 313967(104 10510 1000 Fair Value 0.00 11,053,471.94 0.00 03/15/2018 1.165 1.186 0.00 108,218.75 109,218.75 313385UM6 10605 1000 Fair Value 0.09 1,261,642.11 000 03/20/2018 1.350 1.370 0.00 14,400.00 14,400.00 313397616 10524 1000 Fair Value 090 14,242,354.71 000 03/26/2018 1.160 1.182 0.00 140,166.67 140,166.67 - Adjustment and Market Value cannot be calculated due to missing or outdated Market price dale. Porlfolb RAVI Data Updated: -REPORT--: 05/2212018 08:33 AP Run Date . 0522/2018 - 05:33 GA pp.r- GA) 73.0 Report Var. 7.3.6.1 MARICOPA COUNTY TREASURER Selected Funds Total Return Page 5 Sorted by Security Type • Maturity Date Investment lucerne Investment Beginning Time Weighted Ending Maturity Current Total Interest Adjustment Net investment CU SIP Investment II Fund Class Invested Value Invested Value Invested Value Dale Rate Return Earned In Value Income Security Type: Federal Agency Discounts 313385UT1 10602 1000 Fair Value 0.00 1,675,413.38 0,00 03/26/2018 1.400 1 421 0.00 19,833.33 19,83333 313385UU8 10617 1000 Fair Value 0.00 920,761.99 0.00 03/27/2018 1.420 1A40 0.00 11,044.44 11,044.44 313397UX7 10508 1000 Fair Vatue 0,00 9,820,312.50 0.00 03/3012018 1.192 9.00 97,500.00 97.500,00 313385VC7 10596 1000 Fair Value 0.00 5,004,844.74 0.00 04/04/2018 1.365 1.387 0.00 57,822.92 57,822.92 313385VD5 10551 1000 Fair Value 0.00 9,750,899.41 0.00 04/00/2018 1.280 1.305 0.00 105655,56 105955.56 3133858VD5 10601 1000 Fair Value 0.00 2,166,992.76 0.00 04/0512018 1.530 1.554 0.00 28,050.00 28,000,00 313385VH6 10523 1000 Fair Value 0.00 15,608,321.30 0.00 04/0412018 1.190 1.213 0.00 157,675.00 157,675.00 313385V59 10611 1009 Fair Value 0.00 2,709,959.91 0.00 0411112018 1.550 1.574 0.00 35,520.83 35,520.83 313385VM5 10643 1000 Fair Value 0.00 345,287.28 0.00 04/13/2010 1.600 1 623 0.00 4,66667 4,666.67 313385VM5 10844 1000 Fair Value 0.09 328,88869 0.00 04/1312018 1.500 1.623 0.00 4,444.44 4,444.44 313385V06 10619 1000 Fair Value 0,00 1,706407.64 0.00 04/1612018 1.715 1.741 0.00 24,772.22 24,772.22 313385VTO 10613 1000 Fair Value 0.00 2,495,856.95 0.00 04/19,12018 1.570 1.594 0.00 33,144.44 33,144.44 313385VX1 10612 1090 Fair Value 0.00 3,447.500.59 0.00 0412312018 1.580 1.695 0.00 46,083.33 46,083.33 313385VX1 10626 1000 Fair Value 0.00 2,217,597.04 0.00 04/2312018 1.680 1.705 0.00 31,500.00 31,500.00 313385 WAS 10520 1000 Fair Value 0,00 2,364,394.74 0.00 04/2612010 1.700 1.727 0.90 34,000.00 34,000.00 313385WAG 10621 1000 Fair Value 0.00 2,364,394.74 0.00 04/2612018 1.700 1.727 0.00 34,000.00 34.000,00 313385W08 10635 1000 Fair Value 0.00 1,971,408.99 0.00 04/2712018 1.660 1.685 0.00 27.666.57 27,666.67 31385WE2 10538 1009 Fair Value 0.00 23,406,830.97 0.00 04/3012018 1.245 1.270 0.00 247,616.67 247,616.67 313385VVE2 10657 1009 Fair Value 0.00 1.068,453.54 0.00 0413012018 1.620 1.643 0.00 14,625.00 14,625.00 31338591E2 10669 1000 Fair Value 0.00 591,945.39 0.00 0413012018 1.620 1.643 0.00 8,100.00 8,100.00 313385WG7 10640 1000 Fair Value 0.00 1,092,430.82 13,283,958.72 05/0212018 1.670 0.00 0.00 0.00 313385WH5 10633 1000 Fair Value 0,00 2,709,462.38 24,959,895.83 0510312010 1,650 0.00 -0.01 -0.01 313385WM4 10522 1000 Fair Value 0.00 17,746,328.08 29505,057.51 0510712018 1.245 0.00 0.00 ▪ 0.00 313385WM4 10632 1000 Fair Value 0.00 1,625,370.09 14,973,106.25 05/0712018 1.655 0.00 -0.01 -0.01 313385WP7 10648 1009 Fair Value 0.00 1,476520.56 24.970,569.45 05/0912018 1.630 0.00 0.01 0.01 313385WP7 10655 1000 Fair Value 0.00 1,150,172.47 24,975,173.60 0510912018 1.625 0.00 -001 -0.01 313385VVP7 10656 1090 Fair Value 0.00 460.070.39 9,990,100.00 0510912018 1.820 0.00 0.00 0.00 313385WQ5 10667 1000 Fes- Value 0.00 1,150,474.05 49,963,444.45 0511012018 1.845 0.00 0.01 0.01 313385WV4 10635 1000 Fair Value 0.00 2,856,150.62 29,940,337.50 05/1512018 1.665 0.00 0.00 0.00 313385WVV2 10649 1000 Fair Value 0.00 985,501.64 19,972,833.34 0511612018 1.630 0.00 0.01 0.01 313385X917 10641 1000 Fair Value 0.00 1,641,408.25 19,959,500.00 05121/2018 1.620 0.00 0.00 0.00 313397XK2 10428 1000 Fair Value 0.00 43,930,480.53 44,552.250.00 0512912018 1.180 0.00 0.00 • 0.00 313385M7 10642 1000 Fair Value 0.00 2,051,017.68 24,940.37500 0512912018 1.620 0.00 0.00 0,00 313397X/A8 10440 1000 Fair Value 0,00 38,271.643.42 39,599,200.00 05131/2018 1.185 0.00 0.00 • 0.00 313385XR2 10630 1000 Fair Value 0.00 1.672.307.89 14,952,400.01 06104/2018 1.880 0.00 0.01 0.01 313385XY7 10666 1000 Fair Value 0.00 689,232.89 29,932,400.01 0611112018 1.690 0,00 0.01 0.01 313385YA8 10615 1000 Fair Value 0.00 3,930,595.48 24,893,201.40 06113/2018 1.690 0.00 0.00 • 0.00 - Adjustment and Markel Value cannot be calculated due to missing or outdated Markel price data. Portfolio INVT Data Updated: -REPORT"-: 05/22/2018 05:33 AP Run Date 05=2018 - 08.33 GA (PRF_GA). 7.3.0 Report Ver. 7.3.9.1 MARICOPA COUNTY TREASURER Selected Funds Total Return Page 6 Sorted by Security Type • Maturity Date Investment Income Investment Beginning Time Weighted Ending Maturity Current Total Interest Adjustment Net Investment CU SIP Investment 6 Fund Class Invested Value Invested Value Invested Value Date Rate Return Earned in Value Income Security Type: Federal Agency Discounts 313385YA8 19659 1000 Fair Value 000 853,041.37 19,948,044.44 06,113,12018 1.670 0.00 0.00 0.00 313397Y118 10562 53405 Fair Value 0.00 10.498,232.99 19,342,108.96 06,12012018 1.355 0.00 0.00 * 0.00 313385YH3 10627 1000 Fair Value 0.00 2,293,253.15 19.918.541,66 0612012018 1.725 0.00 0.00 0,00 313385YK6 10807 03405 Fair Value 0.00 657.512.43 2,983,340.00 0612212018 1.689 0.00 0,00 0.00 313385503. 10427 1000 Fair Value 0.00 43,975,057.01 44,492,800.00 0612712018 1210 0.00 0.00 0.00 313313Y05 10439 1000 Fair Value 0.00 38,337,578.95 39.549,000.00 0612712018 1.260 0.00 0.017 • 0.00 3133855041 10650 1000 Fair Value 000 983.56031 19,933,488.88 0612812018 1.640 0.00 -0.01 •0.01 313313A57 10539 1000 Fair Value 0,00 14646,027.96 24,735.513.90 0810312018 1.390 0.00 0.0e * 0.00 313385A55 10603 5340E Fair Value 0.00 14,06:1,069.96 50,299.732,59 0810312018 1.635 0.00 0.00 0,00 313385A55 10604 6340E Fair Value 0.00 6,906,866.57 24,996,278.99 0810312018 1.635 0.00 0,00 0.00 3133385A55 10606 1009 Fair Value 0.00 13.704.100,33 49,595,791.65 0810312018 1.635 0.00 0.00 * 0.00 313389J31 10473 1000 Fair Value 0.00 16,876,964.91 24,666,333.33 1010412018 1320 0,00 0.00 * 0.00 313397M65 10563 534MH Fair Value 000 3,393,637.12 6,199,417.80 1013112018 1.470 0.00 0.00 0.00 313313M88 10541 1000 Fair Value 0,00 14,498,623.81 24,623,361.10 7110212018 1.490 0.00 0.00 • 0.00 3133120.18 10658 1000 Fair Value 0.00 451.289.31 9,799,425,00 03/22/2019 2.130 0.00 0.00 0.00 Subtotal 1,017,849,050.79 918,828,811.10 * 822,748,051.37 0.744 0.00 5,691,856.08 * 5,891,856.08 Security Type: Treasury Coupon Securities 9128218JE8 10092 1000 Fair Value 29,939,850.00 14,969,925.00 0,00 1213112017 0.750 1.115 92,934.79 46,007.50 139,022.29 9128285155 10094 1000 Fair Value 19,984,340.00 11,306,929.21 0,00 1213112017 1.000 1.117 93,478.26 11,753.75 105,232.01 912828XF2 10413 53405 Fa1r Value 3,194,873.60 3,194,873.60 3,106,998.40 06110/2018 1.125 1.277 29,975.68 4,001.40 33,977.08 912828R93 10291 1000 Fair Value 29,808,990.00 16.081,165.66 0.00 06730/2018 0.625 1.000 83,559.78 50,38530 133,944.78 912828N22 10183 1000 Fair Value 24,962,900.00 24,962,900.00 24,982,425.00 12715/2018 1250 2.637 260,205 56 288,076.96 548,282.12 912828R44 10400 1000 Fair Value 24,768.550.00 24,768,550.00 24,794,825.00 0511512019 0.875 0,927 182,351 88 8,793.75 191,145.63 912928WS5 10313 1000 Fair Value 25,111325,00 25,111,325.00 25,128,900.00 06130/2019 1.625 1,895 337,811 81 58,596.89 386,408.69 912828XI-18 10395 1000 Fair Value 30,052,741800 30,052,740.00 30,104,310.00 08730/2020 1,625 1.830 405,374.17 52,728.75 * 458,102.02 Subtotal 187,823,568.60 150,448,408.47 * 108,207,558.40 * 1.601 * 1,485,691.93 820,423.59 2.006,115.52 Security Type: Treasury Discounts -Amortizing 912796L56 10614 1000 Amortized 0.00 1,314,91228 000 03/20/2018 1,500 1.622 0.00 16,666.67 10,866.67 05012796M023 10666 1000 Amortized 0.00 804.819.63 34063,327.78 05/24/2018 1.640 1.666 0.00 11.161 11 11,161.11 Subtotal 0.00 2,119,731.91 34,963,327.78 1.575 0.09 27,827.78 27,827.78 Security Type: Federal Agency Callables 313438..100 10380 1000 Fair Value 24.036.750,00 24,936,760.00 • 24,044,450.00 05/11/2018 1,000 1,048 208,333.34 9,250.00 • 217,683.34 3130A8123 10173 1000 Fair Value 19,917,400.00 19,917,400.00 • 19,932,000.00 05/18/2018 0,000 1.402 160,000.00 82,600.00 • 232,600.00 - Adjustment and Market Value cannot be calculated due to missing or outdated Markel price data, Portfolio INVT Data Updated: -REPORT-: 0512212018 08:33 AP Run 0a1e: 05722/2056 08.35 GA (PRF_GA) 7.3.0 Report Var. 7.3.6.1 MARICOPA COUNTY TREASURER Selected Funds Total Return Page 7 Sorted by Security Type - Maturity Date Investment Beginning Time Weighted Ending Maturity Current Total Interest Adjustment Net Investment CUSIP Investment N Fund MSS Invested Value Invested Value Invested Value Dale Rate Return Earned in Value Income 3134G44Z8 10325 1000 Fair Value 14,955,55900 14,956,950.00 14,966,400.00 0512512018 1.000 1.337 125,000.00 41,550.00 * 166,550.00 3134GAMA9 10220 1000 Fair Value 19,91350900 19,913,600.00 19,918,000.00 0912112018 1 003 1.526 166,666.65 86,400.00 • 253,066.66 3134GASE5 10268 1000 Fair Value 24581900.00 24,881,000.00 2490950090 1012612018 1.050 1.630 210,750.00 119,000.00 • 337,750,00 3134GAUH5 10284 1000 Fair Value 29513,10900 29.813.100.00 29,838,900.00 1110212018 0.930 1.889 232,500.00 1813,900,00 * 415,400.00 3133EGJZ8 10173 1000 Fair Value 219353136.14 21,938,386.14 21,955,617.79 0110712018 1.000 1.758 184.083.34 137,046.35 * 321,129.70 3130AAE46 10534 1030 Fair Value 0,00 14,748,898.03 24,906,250.00 0111612019 1.250 1.265 15538194 0.00 * 155,381.84 313306WX1 10251 1000 Fair Value 13,00972658 13,009,726.68 13,020,038.73 0112612019 1.270 1.861 13335591 63,273.32 • 201,629.23 3130ACJF2 10485 1000 Fair Value 0,120 9,669,601.97 14,997,750.00 0411712019 1.500 1.506 121,250.00 0.00 • 121,250.00 3136031/133 10160 1000 Fair Value 29511,80900 29,511,090.00 29545,60900 07/0512019 1.140 2.730 285,000.00 303200.00 • 673,200.00 3133EGJR7 10161 1000 Fair Value 24,79275900 24,792,750.00 24,820,00900 071050019 1.020 2.033 212,500.00 207,250.00 • 419,750.00 3134013E67 10357 1000 Fair Value 24,941,500.00 24,941,50300 24,903.50900 0711112019 1.500 1.786 312,500.00 58,500.00 • 371,000.00 3135051.50 10182 1000 Fair Value 24,723,550.00 24,723,550.00 24,753,37500 0711212019 1.050 2.405 218,750.00 276.450.00 • 495,200.00 3134GBZH8 10445 1000 Fair Value 0.00 28,223.68421 29,984,400.00 07119/2019 1.500 1.509 352,500.05 0.00 • 352,50900 313069821 10376 1000 Fair Value 24,93575090 24,938,750.00 24,962,750.00 07/2612019 1.375 1.497 286.458.33 24,500.03 " 310,958.33 3135001150 10176 1000 Fair Value 29,770,00000 29,770,500.00 29,003,500.00 08116/2019 1.200 2.135 300,000.03 229,500.00 " 529,500.00 3134GEILWO 10373 1000 Fair Value 24,521,500.00 24,921,500.00 24,945,000.00 08116/2019 1,500 1,884 312,500.00 78,500.00 • 391,000.00 313501:P23 10007 1000 Fair Value 19,872,20090 19,072,200.00 19,893,600.00 08123/2019 1.250 2.031 208,333.33 127,800.00 • 336,133.33 3130AB0139 10346 1000 Fair Value 19863800.00 3,808,882.89 30-0 08/28/2019 1,000 2.638 47,500.00 36,203.00 83,700.00 313500P80 10270 1000 Fair Value 18,73540920 18.736.406.20 18,758,72090 09/30/2019 1.250 2.344 196,979.16 168.866.30 355,845,46 3130A8NRO 10178 1000 Fair Value 19,789,800.00 19,789,800.00 19,814,40900 10/11/2019 1.125 2.279 187,500.00 18320300 ' 375,700.00 31360413R1 10252 1000 Fair Value 24.781.000.00 24,781,000.00 24,810,500.013 10/1712019 1.100 1.911 229.166.66 165,250.00 " 394,416.66 3136G4FM0 10255 1000 Fair Value 23658,806.00 29,658,600.00 29,687,600.00 10/17/2019 1.230 2.627 307,500.00 341,400.00 " 648,900.00 31340131172 10533 1000 Fair Value 0.00 8,220,853.71 13,084,108.48 10/25/2019 1,625 1.639 112,253.51 0.00 112,253.51 3136G4EM1 10264 1000 Fair Value 17,791,997.05 17,791,997.05 17,813,734.70 10/28/2019 1,250 2.400 187,135.41 168,511.70 • 355,647.11 113604JA2 10300 1000 Fair Value 24,910,500.00 24,910,500.00 24.93875900 11/28/2019 1.500 1.938 312,500.00 89,500.00 • 402,008.00 3134GAWF7 10200 1000 Fair Value 19,067,600.00 19.867.600,00 19,890,80090 11/27/2319 1.300 2.110 216,68657 132,400.00 349,066.67 3134GAY00 10239 1000 Fair Value 15,854,000.00 19.854,00000 19,877,400.00 11/27/2019 1.300 2.193 216,666.67 146.000.03 • 382,655.87 3134GAZV9 10305 1000 Fair Value 24,922,750.00 24,922,750.00 24,949,000.00 12/13/2019 1.510 1.888 314,583,33 77,250.00 • 391,833.33 3130A0JR2 10535 1000 Fair Value 0.00 12,014,644.74 20,291,00.00 12/13/2019 2.375 2350 236,180.65 0.00 • 236,180.55 3134GBXG2 10422 1000 Fair Value 15,979,600.00 19,979,600.00 19,995,400.00 12/27/2019 1.550 1.675 268,333.33 20,400.00 278,733.33 3133ECLE3 10188 1000 Fair Value 24,735,750.00 24,735,750.00 24.775.750.00 01/13/2020 1.240 2.637 259,333.33 264,250.00 * 522,583.33 3136G4KM4 10315 1000 Fair Value 25,000,750.00 25.000,75090 25,016,500.00 01/17/2020 1.750 1.747 364,583.33 -750.00 363.833.33 3135GOS53 10317 1000 Fair Value 25939,220.00 29,939,220.00 29,989,320.00 01/27/2020 1.700 1.549 425,000.00 60.780,00 • 485,780,00 3134GAS88 10319 1000 Fair Value 9,985,500.00 886,870.07 0.00 01/28/2020 1.625 3.613 12.187.50 14,500.00 26,687.50 3130.5130129 10365 1000 Fair Value 29,939,100.00 29,939,100.00 26,984,700.00 02/03/2020 1.600 1.848 400,00090 60,900.00 460,900.00 3134GAY24 10352 1000 Fair Value 19,992,800.00 3,551,352.63 0.00 02/24t2020 1.000 1.239 29,444.44 7,200.00 36,644.44 3133EHCC5 10345 1000 Fair Value 11,952,480.00 2,634,263.68 0.00 03/13/2020 1.800 3,643 35,000.00 47,520.00 86,520.00 ' • Ad]ustrnent and Market Value cannot be calculated due In needing or outdated Market price data Portfolio INVT Data Updated: -REPORT-: 05/22/2018 08:33 AP Run Date: 05122/2018 - 08:31 GA [pRF GA) 112 Report Vol. 7.1.0.1 MARICOPA COUNTY TREASURER Selected Funds Total Return Page 8 Sorted by Security Type - Maturity Date Security Type: Federal Agency Calla bles 3130A07I12 10618 1000 Fair Value 0.00 2,763,157.89 ' 20000000.00 03/20/2020 2.375 2,051 54,097.22 0.00 * 54,097.22 313408E84 10356 1000 Fair Value 9,971,30000 9,971,300.00 • 9,987,500.00 03/27/2020 1.700 2.051 141,666.67 28,700.00 • 170,366.67 3130A0125 10625 1000 Fair Value 0.09 2,878,289.41 • 25,000,000.00 03127/2020 2.000 1.970 47,222.22 0.00 • 47,222.22 3133EJJT7 10637 1000 Fair Value 0,00 2,302,631.58 25,000.000,00 04/33/2020 2.430 2.464 47,250.00 0.00 47,250.00 31340E1E15 10462 1000 Fair Value 0.00 21,895,781.25 • 25023,750.00 04/13/2020 1.800 1.003 328,750.00 0.00 * 328,750.00 3133EJKW8 10652 1000 Fair Value 0.00 643,914.47 13,050,00000 04116/2020 2.420 2454 13,158.75 0.00 13,168.76 3133EJMA4 10665 1000 Fair Value 0.00 657,894.74 25,000,000.00 04/23/2020 2.500 2.535 13,888.89 0.00 13,888.89 313406.10 10417 1001.1 Fair Value 10,939,600.00 19,939,600.00 19,973,600.00 0511512020 1.700 2.070 283,333.34 60,400.00 * 343.733.34 3134GBPK2 10401 1000 Fair Value 24,925,250.00 24,925,250.00 • 24,988,000.00 0511812020 1.700 2.066 354,166.67 74,750.00 • 428.918.67 3136G4JBO 10301 1000 Fair Value 14.934.300,00 14,934,300.00 • 14,960,550,00 05126/2020 1.625 2.161 203,125.00 65.700,00 * 268,825.00 3134GBPA4 10433 1000 Fair Value 0.00 4,274,177.63 05/20/2020 1.800 2.142 63,750.00 12,500.00 76,250.00 3133EFIKR3 10684 1000 Fair Value 0.00 257,907.89 9,800,500.00 05/01/2020 1.670 1.728 3.711.11 0.00 3,711.11 3134013Z47 10556 1000 Fair Value 0.00 14,226,973.68 • 25000,000.00 06/09/2020 1.800 1.814 215,000.00 0.00 • 216,000.00 3130ABNQS 10463 1000 Fair Value 0.00 13,059,182.67 • 14681,100.00 06/26/2020 1.625 1.031 177,395.84 0.00 * 177,395.84 313604K04 10307 1000 Fair Value 19.972,200.00 19,972,200.00 • 20000,400.00 96/29/2020 1,750 1.921 291,666.67 27,800.00 • 319,466.67 3130ABPV2 10423 1000 Fair Value 24.972.250.00 24,972,250.00 • 25,002,00000 06/29/2020 1.690 1.826 352653.33 27,750.00 • 379,833,33 3130A0144 10634 1000 Fair Value 1,628,289.47 15,000,000.00 06/29/2020 2.450 2.409 32,666.67 0.09 32,666.67 313604FQ1 10264 1000 Fair Value 24,468,758.00 24,468,750.00 * 24.524,250 07/27/2020 1.400 4.030 291,666.67 531,250.03 * 822,916.67 3130G46179 10276 1000 Fair Value 24,463,750.00 24,463,750.00 * 24.516500.00 07/28/2020 1.300 3.961 270,833.34 536,250.00 807,083.34 3136G4GK3 10277 1050 Fair Value 19,691,200.00 19,691,200.00 * 19,733,200.00 07/28/2020 1.350 3.255 225.000.00 308,800.00 • 533,800.00 3130AAMK1 10318 1000 Fair Value 10,001,200.00 10.001,200,00 • 10,004,000.00 07/30/2020 1.750 1.736 145,833.33 -1,200.00 * 144,633.33 3130ADF31 10590 1000 Fair Value 0.00 7,483,552.63 • 25000,000.00 07/30/2020 2.140 2.170 135,236.11 0.00 • 136,236.11 3134CSHN8 10677 1000 Fair Value 0.00 82,236.64 25,000,000.00 07/30/2020 2.530 2.505 1,756.94 0.00 1,756.94 3134081.115 10678 1000 Fair Value 0.00 82,236.84 26,000,000.00 07/30/2020 2,500 2.535 1,736.11 0.00 1.736.11 3134GB2C9 10461 1000 Fair Value 0.00 26,348,684.21 • 30000,000.00 08/07/2020 1.850 1.855 407,000.00 000 407.900.00 31340E1254 10557 1000 Fair Value 0.00 13,815,789.47 • 25,000,000,06 00/14/2020 1.630 1.844 212,229.17 000 * 212,229.17 3134601715 10397 1000 Fair Value 29,962,200.00 29,962,200.00 * 30,004,200.00 09/17/2020 1.700 1.865 425,000.00 37,800,00 * 462,800.00 3136G4 LSO 10333 1000 Fair Value 14,963,700.00 2,658,025.68 0.00 08/24/2020 1.875 3.5/0 41,406.25 36,300.00 77,705.25 313408218 10567 1000 Fair Value 0.00 15,296,052.63 • 30,000,000.00 08/25/2020 1.875 1.000 240,625.00 0.00 • 240,626.00 31340B2P6 10570 1000 Fair Value 0.00 12,746,710.53 • 25,000,000.00 08/25/2020 1.875 1,899 200,520.63 0.00 * 200,520.83 3134GA5J9 10335 1000 Fair Value 9,991,900.00 1,906,349.34 0.00 08/28/2020 1,850 2.355 29,291.67 8,100.00 37,391.67 3134GBX72 10518 1000 Fair Value 0,00 14,884,868.42 • 25,000,000.00 09/01/2020 1.850 1.665 231,250.00 0.00 * 231.250.00 313903686 10213 1000 Fair Value 13,762,000.00 19,762,000.00 19,80360000 09/15/2020 1.450 2.914 241,666.67 236.000,00 * 479,666.67 313604PK3 10483 1000 Fair Value 0.00 12,816.11842 * 19,980,000.00 09/28/2020 1.750 1.758 187,638.89 0.00 * 187,63689 31340E1282 10559 1000 Fair Value 0.00 13.733,552.63 • 25,000,000.00 09/28/2020 1.840 1.854 212,111.11 0.00 212,111.11 3134081-1P3 10647 1000 Fair Value 0.00 1,809,210.53 26,000,000.00 09/28/2020 2.500 2.535 38,194.44 0.00 38,194.44 3134GBBG6 10353 1000 Fair Value 25,507,650.00 7,551,606.91 0.00 09/29/2020 2,000 1.360 124,666.67 -7,650.00 117,016.67 Adjustment and Markel Value cannot be calculated due le missing or outdated Markel price data Portfolio INVT Data Updated: -REPORT-: 05/2212018 0833 AP Ran We._ 05=015 - 39 33 GA (PRF_GA) 7.3.8 00004 Vol. 2.001 1 MARICOPA COUNTY TREASURER Selected Funds Total Return Page 9 Sorted by Security Type - Maturity Date Investment lucerne Investment Regrowing Time Weighted Ending Maturity Current lbw Mterest Adjustment Net Investment CUSP Investment # Fund Class Invested Value Invested Value Invented Value Date Rate Return Earned In Value Income Security Type: Federal Agency Callabtes 31340E0465 10467 1000 Fair Value 0.00 13.677,631.58 19,800,000.50 09/29/2020 1.750 1.775 202,222.22 0.00 • 202.22222 3134GBH21 10516 1000 Fair Value 0.00 14537,236.84 24,920,900.09 09/29/2020 1.700 1.720 212,500.00 0,00 * 212,500,00 313604PE7 105136 1000 Fair Value 0.90 6,363,746.05 19,740,600.08 09/29/2020 1.700 1.746 92555.55 0.00 * 92,555.55 3130ADX83 10583 1000 Fair Value 0.00 325,657.89 9,000,000.00 10/20/2020 2,00f1 2.028 6,600.00 0.00 5,590.00 3134GSH01 10673 1000 Fair Value 0.00 411,184.21 25.000.000.00 10/26/2020 2.540 2.575 8,819.44 0.00 8,819.44 3134GSHR9 10674 1000 Fair Value 0.00 411.184.21 25,000,000.00 10/26/2020 2.250 2.281 7,812.50 0.00 7,812.50 3136G4FT5 10285 1000 Fair Value 29564000.00 29,364,000.00 29,433,600.00 10/27/2020 1.405 4.037 351,250.00 636.000.00 * 987,250.00 313468203 10558 1000 Fair Value 0.00 16,480,263.16 30,000,00020 10/30/2020 1.650 1.563 214.500.00 0.00 * 214,500.00 3134013205 10574 1000 Fair Value 0.00 12,682,236.84 25,000,000.00 10/30/2020 1.900 1.914 200555,56 0.00 * 200,555.56 3134GATMS 10283 1000 Fair Value 29.589.000.09 29,589,000.00 29,654,400.00 11/02/2020 1.365 3.052 341,250.00 411,000.00 • 752,250.00 3130ACRCO 10543 1000 Fair Value 005 11,5713,947.37 20,000,000.00 11/06/2020 1.880 1.895 182,777.78 0.00 * 182,777.78 313569786 10555 1000 Fair Value 0.00 11,3131,578.95 20,000,000.00 11/09/2020 1.950 1.966 186,333.33 0.00 * 186,333.33 3134GAWJ9 10293 1000 Fair Value 19,684,400.00 16,684,400.00 19,729,000.00 11/10/2020 1.400 3.348 233,333.33 315800.00 * 548,933.33 313408'1'55 10560 1000 Far Value 0.00 8,141,447.37 15.000,000.00 11/17/2020 1.500 1.512 102,500.00 0.00 * 102,500.00 313408Y66 10561 1000 Fair Value 0.00 7,055,921.05 13.000,00000 11/17/2020 1.500 1.512 88,833.33 0.00 * 88,833.33 3134GB3J9 10564 1000 Fair Value 0.00 12,993,421.05 25,000,000.00 11/24/2020 1.500 1.511 163,541.67 0.00 * 163,541 67 313408205 10565 1000 Fair Value 0.00 12.993,421.05 25,000,000.00 11/2412020 1.500 1.511 163,541.87 0.00 * 163.541,67 3134682RO 10573 1000 Fair Value 0.00 12,582,235.84 25,000,000.00 11/25/2020 1.600 1.612 168,888.89 000 • 160.888,99 31340B2V3 10575 1000 Fair Value 000 12,582,236.84 25,000,000.00 11/25/2020 1.920 1.934 202,666.67 0.00 • 202,666.67 3134002H; 10566 1005 Fair Value 0.00 12,746,710.53 25,000,000.00 11/2712020 1.500 1.511 150,418.87 0.00 * 160,416.67 3134082N1 10569 1000 Fair Value 0.00 12,748,710.53 25,000,000.00 11/2712020 1.950 1.964 208,541.67 0.00 * 208,541.67 3134082AD 10571 1000 Fair Value 0.00 12,748,710.53 25,000,000,00 1112712020 1575 1.889 200,520.83 0.00 • 200,520.83 313400270 10572 1000 Fair Value 0.00 12,745.710.53 25,000,000,00 1112712020 1.875 1.889 200,520.83 0.00 ' 200,520.83 313400JJ2 19405 1000 Fair Value 19,340,400.00 19,549400 00 19,980,200.00 01/2612021 1.750 2.115 291,866.67 59,600.00 351,266.67 3134GSCE3 10587 1000 Fall Value 0.00 9,375,000.09 30,000,000.00 01/26/2021 1.875 1.901 148,437.50 0.05 * 148,437,50 313604RF2 10580 1000 Fair Value 0.00 7,812,500.00 25,000,000.00 01/26/2021 1.800 1.825 118.759.00 0.00 * 118,750.00 313080572 10589 1000 Fair Value 0,00 3,631,578.95 12,000,000.00 01/29+2021 2.050 2,070 82,866.67 0.00 • 62,866.67 3130A05A5 10600 1000 Fair Value 0.00 5,131,578.95 20,000000.00 02712/2021 2.300 2.362 100,944.44 * 100,944.44 3131180JR4 10809 1000 Fair Value 0.120 5,016,447.37 25,000,00020 03/01/2021 2.375 2.369 98,958.33 0.00 * 98,958.33 3130AOKE1 10610 1000 Fair Value 0.00 4,687,500.00 26,000,000.00 03105/2021 2.009 1.992 77,777.78 0.00 • 77.777,78 3130AOTH5 10623 1000 Fair Value 0,00 1,776,315.79 15,000,00000 03/26/2021 2.670 2.632 35.937.50 0.00 * 38,937.50 3134GSGN9 10624 1000 Fair Value 0.00 2,960,528.32 25,000,000.00 03/26/2021 2.000 1,971 45511.11 0.00 * 48,611.11 31340SHH1 10631 1000 Fair Value 0.00 2,713,815.79 25000,000.00 03/29/2021 2.250 2.212 50,000.00 0.00 50,000.00 3133EJHZ5 10638 1000 Fair Value 0.00 427.631.513 5.005000.0Q 03/29/2021 2.710 2.748 9,786.11 0.00 9,786.11 3133EJKE8 10645 1000 Fair Value 0.00 1,809,21053 25,000,000.00 04/09/2021 2.600 2.636 39,722 22 0.00 39,722.22 313664RT2 10652 /000 Fair Value 0.00 185,526 32 4,700,000.00 04/19/2021 2.750 2.788 4,308 33 0.00 4.308.33 3133EJMH9 10670 1000 Fair Value 006 411.184,21 25,000,000.00 04/26/2021 2.720 2.758 9,444.44 00 9,444.44 ' - Adjustment and Market Value cannot be calculated due to missing or ouldaled Markel price data. Portfolio INVT Data Updated: -REPORT-: 05/2212018 08:33 AP Run Rate: 05/22/2313- 0531 CA tPRFS4) 7.3.0 Report Var. 7.3.6.1 MARICOPA COUNTY TREASURER Selected Funds Total Return Page 10 Sorted by Security Type - Maturity Date Investment Income Investment Beginning Time Weighted Ending Maturity Current Total Interest Adjustment Net Investment lrwestmont# Fund Class Invested Value Invested Value Invested Value Date Rate Return Earned In Value Income Security Type: Federal Agency Cellables 3133EJMH9 10671 1000 Fair Value 0.00 411.184_21 25,000,000.00 04/26/2021 2.720 2.758 9,444.44 0.00 9,444.44 3136G4SH7 10675 1000 Fair Value 0.00 39,473.63 12,000,000.00 04/30/2021 2 750 2.788 91667 0.00 916.67 3136G4SM8 10676 1000 Fair Value 0,00 82,236.84 25,000,000.00 04/30/2021 2.700 2,738 1,875.00 0.00 1,875.00 3133EHJH7 10402 1000 Fair Value 12,239,46600 12,239,485.00 • 12,253,307.50 05/17/2021 1.570 2.076 201,104.16 10,535.00 • 211,639.16 Subtotal 1,169,083,631.07 1,568,144,452.66 * 2,410,167,972.20 " 2,084 20,039,906.63 7,623,082.68 * 27,562,988.31 Security Type: Private Placement - LT CART201413 10017 1000 Amortized 120,000.00 0.00 0.00 07/01/2017 2,290 0.00 0.00 0.00 GLENUS05 10020 1000 Amortized 14,050,000,00 0.00 0.00 07/01/2017 3.330 0.00 0.00 100 PVUSD 10024 1000 Amortized 9,515,000.00 0.00 0.00 07/01/2017 1.000 0.00 0.00 0.00 PEOREF12 10026 1000 Amortized 3,400,000.00 0.00 0,00 07/01/2017 3.650 0.00 0.00 0.90 PHXLINO1A5 10028 1000 Amortized 5,070,000.00 0.0e 0.00 07/01/2017 0.930 0.00 0.00 0.00 DYSREF13 10029 1600 Amortized 4,390,000.00 0,00 0.00 07/01/2017 2.300 0.00 0.00 0.00 PHXES01 10032 1000 Amortized 3,825,000.00 0.00 0.00 07/01/2017 6.850 0.00 0.00 0.00 CHAND2013 10038 1000 Amortized 3.585.00080 0.00 0.00 07/01/2017 5.230 0,06 0.00 0.00 WASHE006 10040 1000 Amortized 2,000,000.00 0.00 0.00 07/01/2017 1.220 0.00 0.00 0.00 GLENUSD1 10041 1000 Amortized 2,100,090.00 0.00 0.00 07/01/2017 1.460 0.00 0.00 0.00 QCUSD 10043 1000 Amortized 1,100,000.00 0.00 0.00 07/01/2017 3.620 0.00 0.00 0.00 GLENLIHSD1 10047 1000 Amortized 775,000.00 0.00 0.00 07/01/2017 1.000 0.00 0.00 0,00 CARIES ID 10048 1000 Amortized 240,000.00 0.00 0.00 07701/2017 1.980 0.00 0.00 0.03 PHXE016A 10214 1000 Amortized 100.009.00 0.00 0.00 07/01/2017 3.570 0.00 0.00 0.00 PEOREF13 10025 1000 Amortized 8,714,671.51 0,274,55960 0.09 01/01/2018 3.650 0.982 156,950.00 -114,671.61 42,278.49 DYSREF14 10030 1000 Amortized 4,561,444.84 2,760,874.51 109 01/01/2018 2.300 0.098 52,095.00 -31,444.84 20,650.16 PHXESD 10031 1000 Amortized 4,28E1,394.58 2,595,607.25 0.00 01/01/2013 5.650 0.924 118,397.50 -98,254.58 19,972.92 CHAND2013B 10038 1000 Amortized 76,599.01 46,362.56 0.00 01/01/2018 5.230 0.938 1,981.25 -1.599.01 382.24 19CUSD1 10044 1000 Amonlzed 374.553.16 226,703.23 0.00 01/01/2018 3.620 1.135 6,697.00 -4,553,16 2,143.84 CART2014O 10018 1000 Fair Value 136,815.75 136,815.75 136,815.75 07/01/2018 2.290 3-494 2,576.25 1,405.35 • 3,961.60 GLENUSD 10019 1000 Fair Value 16,935,704.50 16,935,704.50 16,935,704.50 07/0112018 1,975 1.435 276,088.54 -73642.25 202,446.29 WASHESDG6 10039 1000 Fair Value 3,020,190.00 3,020,190.00 3,020.190 00 07/01/2018 1.630 0.817 40,750.00 -20,190.00 • 20,560.00 CARTESD1 10049 1000 Fair Value 237,436.95 237.436.95 237,436.95 07/01/2010 1.980 2.183 3,877.50 439.45 • 4,316.95 WASH2015A 10052 1000 Fair Value 1,594,710.00 1,504,710.00 1,504,710.00 07/01/2018 1.270 0.891 15,875.00 -4,710.00 11.185.00 RVR2016BI 10238 1000 Fair Value 1,040,946.40 1,040,946.40 1,040,946.40 07101/2018 1.030 0.920 8,926.67 -946.40 7,980.27 RVR2016R. 10245 1000 Fair Value 214,309.20 214,309.20 214,309.20 07/01/2018 3.000 4.465 5.259.00 2,719.50 * 7,969.50 CART20140 10004 1000 Fair Value 378,894.80 378,894.80 378,894.80 07/0112019 2.290 1.026 7,069.83 -3.822.10 • 3,238.73 WASH20150 10053 1000 Fair Value 3,028,260.00 3,028,260.00 3,028,260.00 07101/2019 1.570 0.436 39.250.00 -28,28060 * 10,590.00 R1/11201681 2 10242 1000 Fair Value 1.031,339.00 1,031,339.00 1,031,339.00 07101/2019 1.130 0.973 5.60517 -1,339.00 * 8,360.17 RVR2016R_2 10248 1000 Fair Value 223,225.90 223,225.90 223,225.30 0710112019 3.900 4.241 5,375.00 2,509.05 * 7,8134.05 • - Adjustment and Markel Value cannot be calculated due lo missing or outdated Market price data. Portfolio INVT Data Updated: -REPORT--: 05/22/201805:33 AP Run Date: 05/22)2018 - 08 33 GA (PRLGA) 70,0 Report Ver. 7.36.1 MARICOPA COUNTY TREASURER Selected Funds Total Return Page 41 Sorted by Security Type - Maturity Date Investment Income Investment Beginning Time Weighted Ending Maturity Currant Tota l Interest Adjustment Net Investment CUSH' Investment It Fund Class Invested Value Invested Value Invested Value Date Rate Return Earned In Value Income Security Type: Private Placement - LT SCFD018A 10591 1000 Amortized 0.00 15,468.48 51,19856 07/01/2019 6.140 2.206 780.51 -476.35 284.16 PHXE01138 10217 1000 Fair Value 2.167,539.75 2,167,539.75 • 2,167,539.75 07/01/2020 3.570 4.630 80,24315 23,34825 83,592.00 liVR2016813 10243 1000 Fair Value 1665,032.50 1,655,03250 • 1,655,032.50 07/0121120 1.300 0,932 17,875.00 -5,032.50 * 12,842,50 RVR2016R.,8 10247 1000 Fair Value 1,146,532.20 1,146.532,20 • 1,146,632.20 07/01/2020 4.500 8,144 39,187.50 19,478 80 50,666.30 SC810018E1 10592 1000 Amortized 000 18912.95 62,640.35 07/01/2020 6.140 2.278 900.19 -541.37 358.82 PH/1E016C 10218 1000 Fair Value 4.479,356.70 4,479,356.70 • 4,479,356.70 07/01/2021 3.570 4.728 122,867.50 53,524 80 * 176,392.30 RVR2016BL4 10244 1000 Fair Value 1,359,674.75 1,359,674.75 • 1,359,674.75 07/01/2621 1.420 1.003 16,034.17 -4674.75 11,359.42 RVR2016i9 4 10248 1000 Fair Value 1,098,777.75 1,098,777.75 1,098.777.75 07/01/21321 1.420 1.003 12,95760 -3,777.75 9,179.75 SOFD6113C 10593 1000 Amortized 000 20,791.88 68,907.23 0770112021 6.149 2.373 982.27 -551.37 410,90 SOH:1018D 10594 1000 Amortized 0.00 22.349.94 74,110.83 07101/2022 6.140 2.450 1,008.84 -552.72 458,12 Subtotal 107,824,409.25 50,640,488,55 39,916,603.12 • 1,726 1,023,596.94 -295,754.46 • 727,842,48 Security Type: Private Placement - ST 2018TANCH 10005 1009 Amortized 45,005,565.92 2,664,803.25 0.00 07/19/2017 1.070 0.834 24,075.00 -5.585.92 18,509.08 20161AN0V 10200 1000 Amortized 35,004,329.05 2,072,624.75 0.00 07/19/2017 1.079 0.834 18,725.00 -4,329.05 14,395.95 2016TANGI 10201 1000 Amortized 35,004,329.05 2,072,624.75 0.00 07/19/2017 1.070 0.834 18725,00 -4.329.05 14,395.95 20181AN12L 10202 1000 Amer//end 15,001,855.31 888,267.75 0.00 07/19/2017 1.070 0.834 8,025.00 -1656.31 6,169.69 2016TANPV 10203 1009 Amortized 20,002,473.74 1.184.357 00 0.90 07/19/2017 1.070 0,834 10,700.00 -2,473.74 8,22626 20161'ANPE 10204 1000 Amer/iced 12,501,546.09 740,223.12 0.00 07/19/2017 1.070 0.834 6,687.50 -1,546.09 5,141.41 2016TANPit 10205 1000 Amortized 37,004,576.42 2,191,060.45 0.00 07/19/2017 1.070 0.834 19,795.00 -4.578.42 15,218.58 20161ANR0 10206 1000 Amortized 15,001,855.31 888,267.75 0.00 07/19/2017 1.070 0.834 8,025.00 -1 3855.31 6,169.69 20161A56A 10207 1000 Amorlized 1,000.123.69 59,217.85 000 07/19/2017 1.070 0.834 535.00 -123.69 411.31 2016174/WA 16209 1000 Amortized 12,001.484.25 710614.29 0.00 07/19/2017 1.070 0.834 6,420.00 -1,484.25 4,935.75 4340009015 10629 1000 Amortized 0.00 19.86 0.00 05/31/2018 3.000 3.022 0.50 0.00 0.50 2017TANCH 10448 1000 Amortized 0.00 44,128,842.63 48,018143.19 07/18/2018 1.670 1.514 621,240.00 -04690.81 556,343.19 2017TANDV 19449 1000 Amortized 0.00 25,341.444.12 20,007,559.66 07/18/2018 1.670 1.650 385,544.29 -37,289.50 348,254.79 2017TANG13 13450 1000 Amortized 0.00 21,145,070.43 23,908,693.61 07/18/2018 1.570 1.514 297,877.50 -31,096.39 268,581.11 2017TANGD 16451 1000 Amortized 0.00 12,870,912.43 14,005,291.76 07/18/201a 1.870 1.514 101,195.00 -18,928.24 162,266.76 2017TANPV 10452 1000 Amortized 0.00 7,433,891.05 0.90 07/1a/2018 1.670 1.243 104,653.33 -27.680.00 76,973.33 2017TANPN 10453 1000 Amortized 0.00 9,193.500.00 10,003,779.83 07/18/2018 1.670 1.514 129,425.00 -13.520.17 115,904.83 2017TANPE 10454 1000 Amortized 0.00 37,693,38641 41,015.497.31 07/18/2018 1.670 1.514 530,642.50 -55,432,69 475,209.81 20171A9R0 10455 1000 Amortized 0.00 9,193,600.88 10.003.779.83 07/18/2018 1.670 1.514 129,425.00 -13,520.17 115,904.83 2017TAN812 10456 1000 Amortized 0.00 2,758,952.66 3,031,133.95 07/18/2018 1.570 1.514 38.82750 -4,056.05 34,771.45 2017TANSC 10578 1000 Amortized 0.00 5,535,102.63 0.00 07/18/2018 1.670 1.173 77,933.33 -23,850.00 54,083.33 Subtotal 227,528,138.83 188,765,800.85 169,063,879.14 1,463 2618,276.45 -318,408.85 2,299,867.60 • - Adjustment and Markel Value cannot be calculated due to missing or outdated Market price data. Portfolio INVT Oats Updated: -REPORT-: 05122/2018 08:33 AP Run Data 05/22/2010- 0823 GA tFRF_OA) 7.3.0 Report Ver. 7.3.0.1 MARICOPA COUNTY TREASURER Selected Funds Total Return Page 12 Sorted by Security Type - Maturity Date Investment Income Investment Beginning Time Weighted Ceding Maturity Current -row Interest Adjustment Net trivestment CUSP tnveslment 6 Fund Class Invested Value Invested Value Invested Value Date Rate Return anted in Value Income Security Type: Registered Warrants GBUSD1000 10469 1000 Amortized 0.00 1,509.43 090 1113012017 2.805 2.805 35.28 0.00 35 26 GBUSD1004 10472 1000 Amortized O.00 375,46 090 11/30/2017 2.805 2.804 8.77 0.00 8.77 GBUS01005 10474 1000 Amortized 0.00 457.69 0.00 1113012017 2.805 2,804 10.69 0.00 10.69 13E111001010 10475 1000 Amortized 0,00 9,510.89 0.00 1113012017 2605 2.805 222.20 0.00 222.20 GBUSD1006 10476 1000 Amortized 0.00 336.35 0.00 1113012017 2.805 2.806 7.86 0.00 7.86 GB04101011 10477 1000 Amortized 000 12.57 090 1113012017 2.805 2.769 0.29 0.00 0.29 GRUSD1012 10478 1000 Amortized 000 4.41924 0.00 1113012017 2.805 2.805 103.24 0.00 102.24 GBUSD1013 10479 1000 Amortized 0.00 886.68 0.00 1113012017 2.805 2.804 20.71 0.00 20.71 GBUSD10113 10480 1000 Amortized 000 3,871.62 0.00 1113012017 2.805 2,805 99.45 0.00 90.46 68501017 10482 1000 Amortized 0,00 569.06 0.00 1113012017 2,805 2.804 13.29 0.00 13.25 60001018 10484 1000 Amortized 0.00 194.12 0.00 11130/2017 2.805 2.808 4.54 0.00 4.54 606601615 10486 1000 Amortized 000 169.51 0.00 1113012017 2.805 2.805 3.98 0.00 3.96 GBUSD1020 10487 1000 Amortized O.00 77.04 0.00 1113012017 2.805 2.805 1.80 0.00 100 1396001023 10488 1000 Amortized 0.00 268_45 0.00 1113012017 2.805 2.804 6.27 0.03 6.27 GBUSD1024 10489 1000 Amortized 0.00 1,884.56 0.00 11/3012017 2.805 2.805 44.03 0.00 44.03 GBUS01025 10434 1000 Amortized 0.00 72.78 0.00 11/3012017 2.805 2.805 1.70 0.00 1.70 1396501020 10455 1000 Amortized 000 40.39 0.00 1113012017 2.805 2.794 0.94 0.00 0.94 GBUSD1027 10496 1000 Amortized 0.00 248.06 0.00 1113012017 2005 . 2.807 5.80 0.00 5.00 Subtotal 0.08 24,903.90 0.08 2.805 581.80 0.00 501.00 Security Type: Money Market Account XXX1518 10006 1000 N/A 102,933.61 102951.73 102,953.71 0,130 0.142 121.60 0.00 121.60 665279873 10424 1000 NIA 2,776.70 18.28 0.01 0.190 0.157 0.03 0,00 0.03 665279073 10425 53400 NIA 1.61 0.02 0.01 0.823 0.00 0.00 0.00 451200670 10654 1000 Amonized 0.120 17,598,684.21 350,000,000.00 1.560 1.582 231,833.33 0.00 231,833.33 0924811700 10661 1009 Amortized 0.00 3,207,236 04 170,000,000.00 1.570 1.592 42,520.83 0.00 42.52983 Subtotal 105,711.92 20,900,891.00 650,102,953.73 1.676 274,475.79 0.00 274,475.79 Total 0,462,905,033.21 3,661,977,950.53 * 4,861,072,251.49 1.603 * 32,305,505.63 16,594,601.32 48900,106.95 CoMpOnenls of Return: Interest: 1.059 Amortization: -0.018 Market Value: 0.662 • - Adjustment and Market Value cannot Se calculated due to missing ar outdated Markel price data. Portfolio INVT Data Updated: -REPORT-: 05/2212018 08:33 AP Ree Rate 05222613 33 GA (PRF GA) 7.3.0 Report Ver 7361 Maricopa County Treasurer Page 5 of 310 AgencyAccount Monthly Closing Balances Main Accounts: 21* only Closing balance as of: 413012018 Agency 2000 Main Account Agency Acct Type Agency Agency Name TAF TAF Description Agency Acct Closing Balance 210100 200 2000 COUNTY 2100 GENERAL FUND 20000 -331,034,933.38 210100 200 2000 COUNTY 2120 SHERIFF SUPPLY 20062 242,751.29 WAREHOUSE 210100 200 2000 COUNTY 2201 ADULT 20064 -1,603,149.09 PROBATION FEES 210100 200 2000 COUNTY 2203 SHERIFF 20065 -267,066.79 DONATIONS 210100 200 2000 COUNTY 2204 JUSTICE COURT 20066 -2,045,003.08 JUDICIAL ENHANCEMENT 210100 200 2000 , COUNTY 2205 COURT 20067 -1,077,277.16 DOCUMENT RETRIEVAL 210100 200 2000 COUNTY 2206 OFFICER SAFETY 20068 -499,607.27 EQUIPMENT FUND 210100 200 2000 COUNTY 2207 PALO VERDE 20069 -1,132,042.66 210100 200 2000 COUNTY 2208 JUDICIAL 20070 -3,999,627.08 ENHANCEMENT 210100 200 2000 COUNTY 2209 PUBLIC 20071 -258,786.87 DEFENDER TRAINING 210100 200 2000 COUNTY 2210 WASTE 20072 -424,975.78 MANAGEMENT 210100 200 2000 COUNTY 2211 ADULT 20073 40,459.16 PROBATION GRANTS 210100 200 2000 COUNTY 2212 SHERIFF RICO 20074 947,672.10 210100 200 2000 COUNTY 2213 COUNTY 20075 -1,592,025.12 ATTORNEY RICO 210100 200 2000 COUNTY 2214 SHERIFF JAIL 20076 -4,004,953.47 ENHANCEMENT 210100 200 2000 COUNTY 2215 EMERGENCY 20077 226,614.26 MANAGEMENT 210100 200 2000 COUNTY 2216 CLERK OF THE 20078 269,311.57 COURT GRANTS 210100 200 2000 COUNTY 2217 CDBG HOUSING 20079 87,429.05 TRUST 210100 200 2000 COUNTY 2218 CLERK OF THE 20080 -109,107.78 COURT FILL THE GAP 210100 200 2000 COUNTY 2219 COUNTY 20081 2,137,914.58 ATTORNEY GRANTS 210100 200 2000 COUNTY 2220 DIVERSION 20082 -104,691.36 210100 200 2000 COUNTY 2221 COUNTY 20083 -256,941.17 ATTORNEY FILL THE GAP 210100 200 2000 COUNTY 2222 HUMAN 20084 5,934,175.24 SERVICES GRANTS 210100 200 2000 COUNTY 2223 TRANSPORTATIO 20085 -83,964.02 N GRANTS PROGRAM ID: APP LEVY_RPT MONTH _SUM 01-MAY-2018 MARICOPA COUNTY TREASURER'S OFFICE PAGE: SECURED LEVY AND ACTIVITY FOR APR 2018 YEAR LEVY SEGINNING BALANCE COLLECTIONS ADJUSTMENTS ENDING BALANCE 2017 4,791,587,056.58 1,661,639,317.80 962,600,899.72 698,029,34- 698,340,388.74 2016 4,643,191,878.76 3,103,617.41 263,442.91- 371,984.08- 2,995,076.24 2015 4,364,407,727.86 2,378,865.83 92,763.17- 88,151.62- 2,383,477.38 2014 4,243,506,812.16 1,558,617.99 53,221.11- 102,598.06- 1,509,241.04 2013 4,019,480,209.28 1,195,805.29 /2,708.59 25,360.87- 1,157,735.83 2012 4,045,298,460.32 1,129,565.19- 3,283.67 66,337.43- 1,199,216.29- 2011 4,138,461,193.04 20,826,085.61 3,749.11- 89,710.76- 20,740,123.96 2010 4,411,089,394.04 42,903,529.75- 1,671.94 122,598.85- 43,027,800.54- 2009 4,592,263,862.98 87,121,701.68 1,295.42 157,824.57- 86,962,581.69 2008 4,288,606,572.70 26,165,937.18 1,081.58 183,960.00- 25,980,895.60 2007 4,001,594,678.74 574,459.58- 253.01- 134,981.55- 709,188.12- 2006 3,660,387,436.00 715,957.94- 5,700.99 90,45/.04- 812,109.97- 2005 3,489,841,477.20 574,946.04 687.85 60,578.25- 513,679.94 2004 3,246,259,075.84 626,475.51 215.55 38,317.05- 587,942.91 2003 3,049,037,955.00 734,897.26- 245.28 7,220.92- 742,363.46- 2002 2,792,576,236.72 1,281,012.12- 368,94 8,650.10- 1,290,031./6- 2001 2,595,278,869.32 637,602.90 340.38 21,552,62- 615,709.90 2000 2,290,234,573.96 572,754.61- .00 .00 572,754.61- 1999 2,108,718,697.02 679,724.78- ,00 .00 679,724.78- 1998 1,939,463,904.72 762,983.09- .00 .00 762,983.09- 1997 1,800,110,859.36 651,645.16- .00 .00 651,645.16- 1996 1,631,715,958.46 79,001.04- .00 .00 79,001.04- 1995 1,683,783,514.12 758,500.65- .00 .00 758,500.65- 1994 1,507,769,663.58 1,128,187.77- .00 .00 1,128,187.77- 1993 1,476,046,063.04 1,190,778.31 .00 .00 1,190,778.31 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,035.32 7,952,619.51 .00 .00 7,552,619.51 1989 1,306,266,536.54 8,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.54 .00 .00 22,355.54 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,279.84 21,166.00 .00 .00 21,166.00 1983 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,481,242.68 12,599.20 .00 .00 12,599.20 1975 294,109,512.68 10,864.89 .00 .00 10,864.89 1974 251,690,646.52 8,954.20 .00 .00 8,354.20 1973 224,585,828.94 6,216.48 .00 .00 6,216.48 1972 191,805,552.44 5,885.92 .00 .00 5,885.92 1971 165,623,012.50 4,111.20 .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 118,414,184.58 331.83 .00 .00 331.83 TOTAL 95,659,212,677.90 1,773,932,435.54 962,215,070.60 2,268,307.11- 809,449,057.83 PROGRAM ID: APP LEVY APT MONTH SUM 01-MAY-2018 MARICOPA COUNTY TREASURER'S OFFICE PAGE: 1 UNSECURED LEVY AND ACTIVITY FOR APR 2018 YEAR LEVY BEGINNING BALANCE COLLECTIONS ADJUSTMENTS ENDING BALANCE 2004 .00 197,750.52- .00 .00 197,750.52- 2003 .00 13,315,942.33- 228.79 25,038.62- 13,341,209.74- 2002 16,903,615.38 3,061,014.91 213.89 24,462.10- 3,036,338.92 2001 19,330,396.80 874,648.63- 903.07 24,023.91- 899,575.61- 2000 138,497,672.37 9,260,994.05- 229.98 22,435.99- 9,282,660.02- 1999 122,871,629.32 28,450,427.46- .00 15,345.60- 28,465,773.06- 1998 122,881,710.56 25,511,465.37- .00 9,316.29- 25,520,781.66- 1997 115,134,253.32 22,886,308.17- .00 7,091.67- 22,893,399.84- 1996 102,673,892.06 35,072,087.08- 78.40 7,145.28- 35,079,310.76- 1995 113,747,601.86 28,750,866.17- .00 5,799.92- 28,756,666.09- 1994 162,209,939.25 8,107,024.00 .00 2,553.01- 8,104,470.99 /993 154,917,045.68 14,418,422.22- .00 423.15- 14,418,845.37- 1992 140,629,687.78 17,542,171.37- .00 429.90- 17,542,601.27- 1991 131,582,120.56 6,349,555.27- .00 388.29- 6,349,943.56- 1990 122,744,902.09 951,026.21- .00 107.20- 951,133.41- 1989 113,929,972.43 7,916,568.30- .00 196.33- 7,916,764.63- 1988 96,811,185.54 21,536,144.42- .00 91.25- 21,536,235.67- 1987 88,991,362.81 7,182,377.74- .00 115.64- 7,182,493.38- 1986 76,956,283.43 25,772,613.27- .00 112.11- 25,772,725.38- 1985 50,507,999.56 28,111,564.10- .00 107.5B- 28,111,671.68- 1984 53,570,953.57 12,928,887.66- .00 55.45- 12,928,943.11- 1983 73,434,045.21 6,576,315.56- .00 46.56- 6,578,362,12- 1982 37,836,109.79 22,905,048.43- .00 .00 22,905,048.43- 1981 36,883,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,826,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- 1963 5,918,654.86 1,422,511.95- .00 .00 1,422,511.95- 1968 4,195,165.19 2,320,992.14- .90 .00 2,320,992.14- TOTAL 2,325,116,156.87 405,486,989.37- 1,654.13 145,285.85- 405,633,929.35-