2020 JUNE- MONTHLY REPORT.PDF

Royce T. Flora, Treasurer
301 West Jefferson St., Rm. 100

Phoenix, Arizona 85003
‘ Phone: (602) 506-8511
Maricopa County Fax: (602) 506-1102
Treasurer http://treasurer.maricopa.gov

DATE: Juby 13, 2020

TO: Clint Hickman, Chairman
Jaek Sellers, Supervisor, District |
Steve Chucri, Supervisor, District 2
Bill Gates, Supervisor, District 3
Steve Gallardo, Supervisor, District 5

SUBJECT: Treasurer's Collections and Investment Summary for June 2020

Secured property tax collections during the month of June equaled $74,970,003, and increased
the 2019 vear to date collections te $5,085,384,074 or 97% of the adjusted 2019 levy of
$5,252,889,746 The chart below reflects the 2019 collected and uncollected levy amount and
corresponding percentages for the 2019 praperty tax year,

June
2020

Collected Levy,
§5,085,384,074 ,
87%

Uncollected Levy,
$167,505,671 ,
3%

HCollectedlevy @Uncollected Levy

The County's General Fund Balance totaled $117,674,665.32 effective June 30, 2020. Warrants
outstanding of $10,147,346.93 will post against the fund balances when presented.

The $26,447,512. unencumbered balance, of the County Municipal Line of Credit and the
582,488. Workers Compensation Liability Letter of Credit remain unused.

Submitted under oath,

Russell KT Pearce
Chief Deputy Treasurer

STATE OF ARIZONA ) ss.
COUNTY OF MARICOPA — }

‘This instrument was acknowledged before me this 13th day of June 2020, by Russell K.
Pearce, as Chief Deputy Treasurer of Maricopa County, State of Arizona, known to me to
be the person whose name is subscribed to the foregoing instrument and who acknowledged
to me that they executed the same for and on behalf of the State of Arizona for the purpose
and consideration therein expressed.

LAvut AD uke Ora 1S, 22!

Notary Public My Commission Expires

KAREN D SMITH
Notary Public ~ Arizona

Maricopa County
My Comm. Expires Ore 15, 2021

PROGRAM ID: APP LEVY _RPT_MONTH_SUM

MARICOPA COUNTY TREASURER'!

YEAR LEVY
2019 5,268,316, 083.92
2018 5,032,079, 420.54
2017 4,791,587, 056.58
2016 4,643, 191, 878.76
2015 4, 364,407, 727.86
2014 = 4,243, 506,812.16
2013 4,019,480, 209.28
2012 4,045,298, 460.92
2011 4,138,461,193.04
2010 4, 411,089,394.04
2009 4,593,263, 862.98
2008 4,288,606,572.70
2007 4, 001,594, 678.74
2006 3,660, 387,436.00
2005 = 3, 489, 841,477.20
2004 3,246,259,075.84
2003 3,049,037, 955.00
2002 «= -2, 792, 576,236.72
2001 2, 595, 278, 869.32
2000 2,290,234,573.96
1999 2,108,718, 697.02
1998 1,939,463, 904.72
1997 1,800,100, 859.36
1996 1,631,715, 958.46
1995 1,683, 783,514.12
1994 1,507,769, 663.58
1993 1,476,046, 063.04
1992 1,477,426 , 592.42
1991 1, 485, 482,338.84
1990 = 1,445, 084, 095.32
1989 1,306, 266,536.54
1988 1,181, 440,841.12
1987 = 1, 049, 888, 299.56
1986 870,295, 854.72
1985 721,770,831.08
1984 600, 944,379.84
1983 530,525, 148.42
1982 451, 214,378.40
1981 402, 942,488.72
1980 373, 230,675.34
1979 382,783, 606.36
1978 365,594,731.04
1977 360,443, 065.88
1976 332,481, 242.68
1975 294,189,512.68
1974 251,690, 646.52
1973 224,585,828.94
1972 191,805,552.44
1971 165, 623,012.50
1970 138,694, 628.82
1969 126,692, 073.74
1968 116,414,184.58

TOTAL 105,959,608, 182.36

S OFFICE

SECURED LEVY AND ACTIVITY FOR JUN 2020

BEGINNING BALANCE

242,981, 798.53
2,038, 627.16
1,267,914.76
1,522,975.16
1,500, 459.82
1, 069,893.71

778,521.29
1,513, 200.33-
20,526, 604.01
43,254,713 .43-
86, 833,090.32
25,886, 766.24
782,043 .49-
857,909. 66-
480,394.05
557,900.89
1,102, 461.12-
1,666, 558.01-
342,895.31
573,629 .53-
680,620.36-
163,899 .73-
652,562.86-
82,273 .28-
761,851.11-
1,131, 451.59-
1,187,757. 93
3,574, 325.77
2,207,521.85
7,952,619.51
8,122, 152.43
3,284, 787,16-
22,355.94
17,516.20
86,095.02
21,166.00
28,883.91
11,573.32
13,529.19
11,274.71
15,972.66
17,517.30
12,427.08
12,599.20
10,864.89
8,954.20
6,216.48
5,885.92
4,111.30
1,998.26
922.38
331.83

352,034, 452.87

COLLECTIONS

ADJUSTMENTS

ENDING BALANCE

74,970, 003.00
451,800.78-
37,693.47
22,348.46
3,544.69
565.20
265.34
170.48
82.26
499.49
78.58
122,91
26,10
+00
00
+00
00
00
-00
00
+00
-00
00
.00
00
+00
-00
00
+00
.00
00
+00
-00
00
+00
00
+90
00
+00
-00
-00
-00
-00
~00
00
-00
00
-00
00
+00
-00
00

74,583,599.20

506,124.24-
550,425.12-
49,894.44
4,795.60
00
+00
00
+00
00
- 00
00
-90
00
+00
00
+00
+00
00
+00
00
00
+00
00
00
-00
00
+90
00
-00
«90
00
-00
00
00
-00
00
+00
-00
.00
+00
00
+00
00
.00
00
-90
00
- 90
00
-00
.00
00

1,001, 859.32-

167,505, 671.29
1,940, 002,82
1, 280,115.73
1, 505,422.30
1,496,915.13
1, 069,328.51

778,255.95
1,513,370.81-
20,526,521.75
43,255, 212.92-
86,833,011.74
25,886, 643.33
782, 069.59-
857,909. 66-
480,394.05
557,900.89
1,102,461,12-
1,666,558. 01-
342,895.31
573, 629.53-~
680,620.36-
763,899.73-
652,562 .86-
82,273.28-
761,851.11-
1,131,451 .59-
1,187, 757.93
3,574,325.77
2,207,521 .85
7, 952,619.51
8,122,152.43
3,284,.787.16-
22,355.94
17,516.20
86,095.02
21,166.00
28,883.91
11,573.32
13,529.19
11,274.71
15,972.66
17,517.30
12,427.08
12,599.20
10,864.89
8,954.20
6,216.48
5,885.92
4,411.30
1,998.26
922.38
331.83

276,448,994.35

01-JUL-2020
PAGE: 1

PROGRAM ID; APP LEVY RPT_MONTH_SUM

MARICOPA COUNTY TREASURER

YEAR

LEVY

2004 -00
2003 .00
2002 16, 903,615.38
2001 18,330,396.80
2060 138,497,672.37
1999 122,871,629 .32
1998 122,881,710.56
1997 115,134,253.32
1996 102,673,892.06
i995 113,747,601.86
1994 162,209,939.25
1993 154,917, 045.68
1992 140, 629,687.78
1991 131,582,120.56
1990 122, 744,902.09
1989 113,929,972.43
1988 96,811,185.54
1987 88,991,362.81
1986 76,956,283 .43
1985 50,507,999.56
1984 53,570,953 .57
1983 73,434,045.21
1982 37,836,109.79
1982 36,683,300.76
1980 30,075,323.04
1979 29,722,220.00
1978 28,615,308.42
1977 26,779,663.13
1976 23,204,794.95
1975 19,189,042,79
1974 15,296,922.12
1973 13,177,965.26
1972 13,623,786.21
1971 12,084,654.91
1370 10,386,975.86
1969 5,918, 654.86
1968 4,195,165.19
TOTAL 2,325,116,156.87

'S$ OFFICE

UNSECURED LEVY AND ACTIVITY FOR JUN 2020

BEGINNING BALANCE

197,750.52
13,355,878. 70-
3,025,724 42

908, 015.20-
9,599,840.97-
28,717,268 .10-
25,613,913 .68-
22,991, 084.77-
35,349,453 .05-
28,930, 383.63-
7,647, 588.77
14,738,205 .59-
17,960, 825.13-
6,674, 284.60-
1,269,288 .95-
8,385, 792.84-
21,988,363 .31-
7,484,835 .49-
25,986,693 .31-
28,240,893 .00-
12, 980,240.92-
6,629,772.26-
22,961,357 .32-
18,070,978 .29-
17,273,398. 23-
6,566, 057.11-
6,816, 484.82-
5,944,729. 86-
2,710,083 .28-
2,676,843 .29-
5,483,374.18-
5,844,853 .65-
2,956,945.73-
1,720,760. 88-

434,685.68-
1,422,511. 95-
2,320,992,14-

410,533,527.24-

COLLECTIONS

ADJUSTMENTS

ENDING BALANCE

-00
180.97
175.31

00

90

00

00

90

00

-90

00

.00

-00

00

.00

00

00

.00

00

00

+00

00

+00

-00

60

60

+00

00

-90
+00
.00
00
-00
00
00

366.28

-00
-00
00
+00
233.10-
-00
00
+00
-00
00
-00
00
.00
80
00
.60
00
+00
.00
00
-00
00
00
-90
00
.00
00
+00
00
.00
+00
00
+00
00
+00
00
+00

233,10-

197, 750.52-
13,356, 069.67-
3,025,549.11

908, 015.20-
2,600,074.07-
28,717, 268.10-
25,613, 913.68-
22,991, 084.77-
35,349, 453.05-
28,930, 383.63-
7,647, 588.77
14,738, 205.59-
17, 960,825.13 -
6,674, 284,.60-
1,269,288.95-
8,385,792.84-
21,988, 363.31-
7,484, 835.49-
25,986,693 .31-~
28,240, 893.00-
12,980, 240.92-
6, 629,772.26
22,961,357.32-
18,070, 978.29-
17,273, 398.23-
6,566, 057.11-
6,816,484 .82-
5,944,729 .86-
2,710, 083 .28-
2,676, 843.29-
5,483, 374.18-
5,844,853 .65-
2,956,945. 73-
1,720, 760.88-

434,685. 68-
1,422,511.95~
2,320,992,14-

410,534,126,62-

01-JUL-2020
PAGE:

a

Maricopa County
MARICOPA COUNTY TREASURER Selected Funds

Interest Earnings
Sorted by Fund - Issuer
June 1, 2020 - June 30, 2020
Yield on Beginning Book Value

Adjusted interest Eamings

Security Ending Beginaing Ending Maturity CurrentAnnualized Interest Amortization’ Adjusted Interest
cusIP Investment # Fund —_Type Pac Value Book Value Book Value Date Rate——Yiel Eamed Accretion Earnings
Fund: Treasurer's Pool

‘Subtotal 4,847,136,110.45 §,841,038,775.64 4,838,586,503.47 1.256 6,502,912.99 50218241 6,000,800.88
Fund: MHS Bond Proceeds
‘Subtotal 69,857,000.00 405,140,670.10 $9,870,236.85 1.587 74,839.43 42,566.78 417,208.19
Fund: MIKS Debt Service
Subtotal “28,718.42 42,566,371.46 25,148.42 4.549 14,344.26 13,910.12 28,254.38
Fund: HIHS Health Plan Sale
Subtotal 0.00 32,088,662.04 0.00 1.647 10,201.64 10,337.99 24,239.63
Fund: MIHS Maintenance & Ops
Subtotal 50,154,000.00 99,984,542.16 50,003,851.40 1.993 105,178.94 19,008.26 124,488.20
Total 4,937,121,392.03 _6,120,799,021.35 4,956,434,573.31 4.272 6,707,977.26 416,287.98 6,291,689.28
Poitfofio INVT
Dala Updated: ~REPORT~: 07/14/2020 15:20 AP
Run Data: 071472020 15.20 VE(PRF_IE)7 20

Report Ver. 7.36.4

Maricopa County
MARICOPA COUNTY TREASURER

interest Earnings
Sorted by Fund - Issuer
dune 1, 2020 - June 30, 2020
Yield on Beginning Book Value

Adjusted interest Eamings

Security Ending Beginning Ending Maturity CurrentAnnwalized laterest = Amortization Adjusted Interest
cusiP Investment # Fund Type Par Value Book Vatue Book Value Date Rate Yield Eamed Accretion Eamings
Fund: Treasurer's Pool
226330 11092 4000 MCS 30,000,000.00 20,000,000.00 20,000,000.00 01/20/2023 2260 2.281 $6,260.00 0.00 $6,280.00
22633ACE47 11135 4000 Mes 20,000,000.00 20,000,000.00 20,000,000.00 oavier2023 1.700 1.724 28,333.33, 0.00 28,333.33
22533AC98 41179 1900 MCE 20,000,000.00* 0.00 20,000,000.00 06/42/2024 1.180 1.198 12,465.58 0.00 12,455.56
037833001 10876 1000 FAG 20,000,000.00 19,866,760.32 19,872,470.69 05/11/2022 2.300 2.697 28,333.33 $710.27 44,053.60
0976390¢1 10945 1000 FAC 20,000,000.00 20,096,725.22 20,035,385.25 001272022 2.100 2.044 35,000.00 +1,341.97 33,658.03
037833074 41183, 1000 Mes 18,618,000.00 0.00 18,764,884.98 05/11/2025 1.126 1.026 7,319.63 ~4,119.07 6,200.48
O25816BR9 {1010 1000 MC 12,000,000.00 42,962,715.73 12,355,867.73 1070/2024 3.000 2.278 30,000.00 6,848.00 23,152.00
og24eu7 ia 10661 1000 RRP 0.00 0.00 . 0.00 0.00 0.00 0.00
co248u700 10737 1900 RRP 0.00 240,000,000,00 0.00 12/31/2020 0.00 0.00 0.00
092480551 10825 1000 RRP 0.00 0.00 0.00 062072022 0.09 0.00 0.00
09248874 11081 4000 RRP 50,000,000.00 59,000,000.00 0,000,000.00 12/31/2020 0.00 0.00 0.00
064159UKO 176 1000 vRt 20,000,000.00 0.00 20,000,000.00 oarog72023 0.780 0.791 9,533.33 0.00 9,633.33
i18106Kce 41162 1000 Mc2 160,000.60 180,180.91 160,000.00 07/01/2020 1.900 0.621 237.50 -180.91 76.59
118106KO4 11163 1000 Mc2 515,000.00 521,991.42 521,453.62 07/01/2021 1.800.647 816.42 -837.80 277.62
1448108KE2 11184 1000 Me2 1,715,000.00 1,758,916.93 1,757,160.30 07/01/2022 1.900 0.663 2,715.42 ~1,756.68 988.74
118106KF9 11165 1000 Mc2 1,430,000.00 1,481,797.61 1,480,397.87 0701/2023 1.900 0.710 2,284.16 ~1,399.94 864.22
118106KG7 11168 1000 mez 3,420,000.00 3,260,145.19 93,287,285.08 0700172024 1.900 0.776 4,240.00 2,860.11 2,979.89
118106KHS 11167 1000 Mc2 3,275,000.00 3,435,249.54 3,492,335.52 01/01/2025 1.900 0.805 5,185.42 -2.913.62 “2271.80
1491302T5 11021 1000 Mes 7,000,000.00 7.131.280.00 7,124,950.00 02/26/2022 2.950 1.861 47,208.33, 6,300.00 10,908.33,
149130983 11084 tooo Mes 25,000,000.00 25,157,616.96 25,184,666.00 1108/2024 2.150 2023 4AT8.E8 41,830.79
17286CHO 11032 1000 MCS 80,000,000.00 0,000,000.00 §0,000,000.00 1108/2024 2.300 2.932 95,833.24 95,893.34
17326FAS7 11072 1000 NCS 30,000,000.00 31,679,993.38 31,644,578.90 01/29/2024 3.650 2.029 94,250.00 52,835.62
173277281 11093 1000 Mes 30,000,000.00 30,000,000.00 30,000,000.00 0173072025 2.280 -2.281 $8.250.00 56,260.00
17327 1F68 14108 1000 CS 26,000,c00.00 25,000,000.00 25,000,000.00 08/28/2023 2.000 2.028 44,866.87 41,666.67
18416QEL0 10929 1000 FAG 20,000,000.00 19,950,327.62 19,952,013.33 11/16/2022 2.260 © 2.390 37,500.00 39,485.71
12572QAE5 40922 1000 FAG 5,000,000.00 5,042,389.77 §,040,848.45 09/15/2022 3.000 2.644 42,500.00 10,956.68
1687648K5 10931 1000 FAC 10,000,000.00 10,014,791.87 10,014,975.00 0816/2023 2.668 2.547 25,983.33 20,966.86
24422EVC0 11070 1090 HCE 5,000,000.00 §,007,687.78 017092025 2.050 2044 8,541.68 8,400.00
24422EVCO 11073 1000 BCS $,000,000.00 4,999,004.86 01/09/2025 2.050 2.078 8,541.66 8544.75
24a199BE4 11928 tooo MCs 2,000,000.60 2,042,523.92 oav0g/2022 «2.600 «1.490 4533.33 2,503.03

Portfotie INVT
AP
Run O2ta: 07/14/2020. 15:50 JE (PRF_)7.20

Report Ver. 7.3.6.1

MARICOPA COUNTY TREASURER
interest Eamings Page 2
Juno 4, 2020 - June 30, 2020

Adjusted Interest Earnings

Security Ending Beginning Ending Maturity CurrentAnnuallzed Interest. Amortization Adjusted tnterest
cusip Investment# Fund Type Par Value Book Value Book Value Date Rate Yield Eamed Accretion Earnings
Fund: Treasurer's Pool
24422EUTA 11130 1000 NCB 2,000,000.00 2,088,286.41 2,085,66.08 0401/2022 2950 1.940 4916.67 -2,649.33, 2,207.4
2d422EUG2 WF 1000 MCs 25,000,000.00 0.00 25,073,870.53 06/07/2023 1.000 0.938 14,164.68 1,379.47 42,785.19
24422ERTB 11478 1000 MCs 8,000,000.00 0.00 8,493,716.13 0172772023 2800 4.434 20,866.66 9,967.52 20,499.15
‘254887FK7 11016 1000 MCs 25,000,000.00 24,797,312.98 24,201,289.84 02/30/2024 1.750 1.984 36,458.33, 3,976.86 40,435.19
SISEHISS 10557 1000 FAG 46,000,000.00 18,997,863.44 15,908,305.49 10/26/2020 1.750 1.808 23,333.24 442.05 23,776.39
SSBB WS 10739 1000 Met 10,000,000.00 10,000,000.00 10,000,000.00 oaae2021 «2.082 2.411 17,354.08 0.00 17,351.08
SSE 10740 1000 Mot 16,000,000.00 18,000,000.00 18,000,000.00 osreev2021 2.082 2.111 28,026.62 0.00 26,026.62
S193EIT90 10789 1000 Fac 25,000,000.00 24,999,488.75 24,994,856.25 111672020 2.950 3.080 61,458.33, 1,187.60 62,645.83,
SISSEKWZ5 10963 4000 Mc1 35,000,000.00 35,000,000.00 35,000,000.00 07/242028 2200-2231 64,168.67 0.00 64,166.67
‘SI1Q3EKCS1 10971 4000 Mt 28,000,000.00 25,000,000.00 25,000,000.00 08/20/2024 2.100 2.129 43,750.00 0.00 43,750.00
SISSEKHES 10976 4000 MCt 30,000,000.00 20,000,000.00 30,000,000.00 o@/2672022 2260 2291 $6,500.00 0.00 $6,500.00
3133EKHA1 10881 4000 HCA 25,000,000.00 25,000,000.00 25,000,000.00 oga2024 2000-2028 41,658.87 0.00 41,666.67
S133EKHA1 10982 4000 MCT 25,000,000.00 25,000,000.00 25,000,000.¢0 091032024 2000 2.028 41,666.87 0.00 41,068.87
3133EKHE6 foes 4000 TRe 20,000,000.00 20,000,000.00 20,000,000.00 03/02/2022 1.850 1.876 30,633.34 0.00 30,833.24
3193EK2R6 10989 1000 FAC 25,000,000.00 25,000,000.00 25,000,000.00 10162021 2100 2.128 43,750.00 0.00 43,750.00
MasEKSMS 11024 1000 Met 25,000,600.00 25,000,000.00 25,000,000.00 110672024 2000 2.028 44,668.67 0.00 41,666.67
S133ELFPS 11053 1000 FAC 15,000,000.00 18,000,000.00 16,000,000.00 12/23/2021 1.830 (1.855 22,875.00 0.00 22,876.00
3133ELRO9 a7 1000 NCA 25,000,000.00 25,000,000.00 25,000,000.00 o3/092022 1200 1.217 25,000.00 0.00 25,000.00
3133ELRZ9 11128 1000 Mei 25,000,000.00 25,000,000.00 26,000,000.00 03102023 1.240 «1.267 25,833.33 0.00 25,833.33
3133ELRUO 41126 1000 MoI 9.00 9,800,000.00 0.00 cer11/2023 1400 1.419 3attdt 0.00 381i
S1S9EL TMG 11133 1000 Mer 0.00 25,000,000.60 0.00 121672021 0.830 (0.842 8,645.83 0.00 8,645.83
SISSELSXS 14134 1000 MCI 20,000,000.00 20,000,000.00 20,000,000.00 o9fte72022 1.000 1.014 16,666.66 0.00 16,656.68
A133ELUKS. 11142 1000 MCI 25,000,000.00 25,000,000.00 28,000,000.00 03/26/2025 1.200 1.247 25,000.00 0.00 25,000.00
a1a3€LU70 1186 1000 Net 30,000,000.00 0.00 29,992,525.11 06/17/2025 0.830 1.828 8,991.66 28.417 9,016.77
S120acTus 10705 1000 NCI 20,009,000.00 19,918,874.09 19,929,964.87 11/27/2020 1.900 2.814 31,666.66 14,390.78 48,057.44
34388463 10862 4000 FAC 20,000,000.00 20, 152,553.98 70,148,347.53 0692023 2.125 1.884 35,416.68 4,206.45 3421021
313379069 10964 4000 FAG 20,000,000.00 20,108,127.99 20,100,801.74 06/10/2022 2.325 1.881 35,416.67 4,328.26 31,080.42
S1Q0AHGKS 11020 1900 Met 19,090,000.00 10,000,000.00 10,600,000.00 1104/2024 2.000 2.028 18,666.67 0.00 16,666.67
S130AHS45 11060 4000 uct 0.00 9,244,745.86 0.00 127262023 1.800 1.953 12,204.86 160.59 12,365.45
3130AHSG9 11064 4000 Mot 0.00 20,662,789.64 0.00 ver02022 1.730 1.7968 28,819.88 666.38 20,486.24
SI20AHWES 11077 4000 Met 25,000,000.00 28,000,000.00 25,000,000.00 0172112026 2.000 2.028 41,866.68 0.00 41,666.66,
3130AHVO1 11080 1000 Met 19,600,000.00 19,492,763.33 19,492,899.33 01/21/2025 1.930 1.966 31,262.50 130.00 34,492.60
31Q0AHVO1 11081 1000 Net 8,000,000.00 7,997.031.11 7,997,084.44 0172/2026 1.930 1.966 42,866.68 53.33 12,919.63
3130AIC49 itt 1000 wet 22,000,000.00 22,000,000.00 22,000,000.00 02/28/2022 1.670 1.693 30,618.67 0.00 20,616.67
3134GVEX2 ante 1000 NCI 0.00 §,000,000.00 0.00 oaH2025 «1.700 1.724 708.94 0.00 708.34
31346VEZ7 1113 1000 NCI 0.00 30,000,000.60 0.00 o3ns2025 1.500 2.839 9,333.33, 0.00 9,333.33
31S4GVFLT 11144 1000 MCI 25,000,000.00 25,000,000.00 26,000,000.00 0304/2022 1.240 1.257 25,833.33 0.00 28,833.83

Portfolio INVT.
AP
Run Date: 07/14/2020 15:10 1 (PRF_1E)720

Report Ver. 7.36.4

MARICOPA COUNTY TREASURER
Interest Eamings
June 4, 2020 - June 30, 2020

Page3

Adjusted Interest Earnings

Security Ending Beginning Ending Maturity CurrentAnnualized Interest Amortization’ Adjusted Interest
cus favestment# — Fund Type Par Value Book Value Book Value Dato Rate Yield Eamed Accretion Eamings
Fund: Treasurer's Pool
S124GVEYO 41121 4000 Mc1 0.00 25,000,000.00 0.00 oaio2025 1.800 2.788 17,187.50 0.00 17,187.50
3134GVFR4 1122 1000 Met 0.00 20,000,000.00 0.00 oa102025 1.425 1.141 5,625.00 0.00 5,625.00
314GVEI2 itt24 1000 Met 0.00 25,000,000.00 0.00 04/11/2028 1.280 2.433 16,666.67 0.00 16,686.67
3130AIF79 11143 1000 ct 20,000,000.00 20,000,000.00 20,000,000.00 0372672025 1200 1217 20,000.00 0.00 20,000.00
3130AJ025 11380 1000 Not 25,000,000.00 0.00 25,000,000.00 08/30/2025 0.600 0.811 555.56 0.00 555.56
3134GBNTS: 10387 1000 Mes 30,000,000.00 30,000,000.00 30,000,000.00 08/17/2020 1.700 1,724 42,500.00 0.00 42,600.00
S14GBNZ 40405 1000 MCt 20,000,000.00 20,000,000.00 20,000,000.00 of/2672021 1.780 1.774 29,166.66 0.00 29,166.66
B1HEBIE 10564 1000 uct 28,000,000.00 25,000,000.00 25,000,000.00 1172472020 2.000 2.028 41,688.67 0.00 41,666.87
31S4GB2A9 10571 i¢00 Not 25,000,000.00 25,000,000.00 25,000,000.00 14/27/2020 1.875 1.801 39,062.50 0.00 99,062.50 +
3124GBZ70 10872 jo90 NEI 25,000,000.00 25,000,000.00 25,000,000.00 11/27/2020 1.875 1.001 39,062.50 0.00 39,082.50
s1HGTSGe 10242 1000 MCI 0.00 20,000,000.00 0.00 caiev2024 = 2.520 2.555 25,200.00 0.00 25,200.00
Bt24GTRIO 10885 1000 Met 30,000,000.60 30,000,000.00 0,000,000.00 07/20/2024 2.260 2.281 $8,250.00 0.00 56,250.00
SIS4GTSYS 40991 1000 Mc1 aco 25,000,000.00 0.00 0913/2024 2160 2.180 21,000.00 0.09 21,000.00
S124GTSD1 jose2 1009 Mect 0.00 20,000,000.00 0.00 owts2024 «2.460 2.100 16,800.00 0.00 16,800.00
314GT7HO joes 1000 Met 0.00 20,000,000.00 0.00 5/16/2024 2210 2.241 18,416.67 0.00 18,416.67
S134GULI7 11003 1000 Met 20,000,000.00 20,000,000.00 20,000,000.00 07/20/2024 2.000 2.028 33,333.34 0.00 33,433.34
3134GUMB3 st0te 1000 uct 20,000,000.00 -20,000,000.00 20,000,000.00 117042024 2.080 2.078 24,166.67 0.00 34,166.87
a1g4eue2s 11087 1000 Fac 30,000,000.00 30,000,000.00 30,000,000.00 017062026 2.050 2.078 $4,250.00 0.00 51,260.00
31S4GUWES, 11071 1000 wet 50,000,000.00 50,000,000.00 §0,000,000.00 011972025 2.020 2.048 84,166.65 0.00 25,168.68
3134GUYS3 11075 1090 wet '25,000,000.00 24,990,760.00 24,990,916.67 01/16/2025 1.950 1.986 40,625.00 166.87 40,791.67
S124GLW48 11076 4000 MCI 30,000,000.60 30,000,000.60 30,000,000.00 01/1072025 2.020 2.048 50,500.00 0.00 50,500.00
B124GUXE2 11078 4000 MCI 25,000,000.00 28,000,000.00 25,000,000.00 01/21/2028 2.000 2.028 41,686.66 0.00 41,666.66
a124GU4K9 11079 1000 Met 25,000,000.00 25,000,000.00 25,000,000.00 01/21/2025 2.000 2028 41,866.66 0.00 41,666.66
S14GU3N8 11082 1000 Mct 28,000,000.00 74,288 083.93 24,986,393.93 0172172025 1.980 1.970 40,208.33 250.00 40,458.33
B14GUY87 \1089 1000 act 25,000,000.00 28,000,000.00 25,000,000.00 01/24/2025 2.000 2.028 41,666.67 0.00 41,686.67
s14GU3D0 s110t 1000 er) 30,000,000.00 20,990,583.33 29,031,833.33 0117/2025 1.750 1.828 43,760.00 1,250.00 48,000.00
‘3134GVAPS 11108 1090 Mes 30,000,000.00 30,000,000.00 20,000,000.00 02/25/2025 2.125 2.185 83,128.00 0.00 $3,126.00
3194GVBE7 11107 1000 HCA 25,000,000.00 25,000,000.00 25,000,000.00 02/28/2026 2280 2.281 48,875.00 0.00 48,875.00
3134GVEUS 11109 1000 NCH 0.00 30,000,000.09 0.00 oaa2025 «1.780 2.690 4,780.00 0.00 4,780.00
3126G4PK 10483 4000 wet '20,000,000.00 19,997,792.45 19,908,258.49 cer2e2020 1.760 1.809 29,168.67 566.04 29,792.71
atsscove4 10861 4000 FAC 26,000,000.00 24,983,085.95 24,983,439.88 020572024 2609 2.655 52,083.33 383.93 $2,467.26
313SG0X67 11088 1000 MCI 28,000,000.60 25,000,000.00 25,000,000.00 0124/2025 2.000 2.028 41,686.67 0.00 41,665.67
313560255 11118 1000 MCT 20,000,000.00 20,000,000,00 20,000,000.00 camerzoz2 1.200 1278 21,000.00 0.09 21,000.00
3698S08K3 11180 1000 MCs 18,802,000.00 0.00 17,444,862.33 0401/2025 3.260 (0.974 27,105.82 118,263.91 8,850.91
S8t4iGW2 11033 1000 Mes 8.278,000.00 8,398,116.45 8,394,904.99 072472023 2005 2.442 20,039.65 3,180.48 16,859.19
381S0ADT9 11087 1000 MCs 28,000,000.00 25,000,000.60 25,000,000.00 01/24/2022 2.050 «2.078 42,708.24 0.00 42,708.24
‘3B 150AE27 11144 1000 Mes 20,000,000.00 20,000,000.00 20,000,000.00 02/26/2025 2.000 2.028 33,333.34 0.00 93,333.94

Portfolio INVT.
AP
Re Daa: 07/18/2020 - 15.10 1 (PRFJE)720

Report Ver. 7.36.1

MARIGOPA COUNTY TREASURER
Interest Eamings Page d
June 1, 2020 - June 30, 2020

Adjusted fnterest Eamings

Security Ending Beginning Ending Matucity CurrentAnnualized Interest’ Amortization! Adjusted Interest
cusip lovestment # = Fund Type Par Value Book Value Book Value Date Rate Yield Eamed Accretion Eamings
Fund: Treasurer's Pool
‘3B180ADZ5 11145 4000 MCS 20,000,000.00 20,000,000.00 20,000,000.00 097262023 1.750 1.774 28,168.68 0.00 29,106.66
3814407273 10880 000 RRP §57,000,000.00 857,000,000.00 $57,000,000.00 0.00 9.00 0.00
3814258500 11023 4000 RRP 0.00 325,000,000.00 0.00 1174/2022 0.00 0.00 0.00
437076BUS 11139 1000 MCs 40,000,000.00 9,842,871.26 9,850.260.75 04/01/2022 1490 -2.368, 14,916.67 7,388.60 19,305.17
Oze8SWCTS 10927 4000 FAC. 1,000,000.00 15.413,327-23 15,403,790.25 01/12/2024 3.550 2760 44,376.00 9,590.98 34,844.02
026650063 11083 1000 MCS $,470,000.00 5,478,045.46 S,A77,817.54 OS/10/2023 2.050 2.025 9344.58 -227.92 9,116.68
43851687 11007 1000 FAC. 9,190,000.00 9,228,582.79 9,227,132.31 8082022 2.000 1.828, 15,316.68 1,460.48 13,886.18
427866801 034 1000 MCS 12,395,000.00 12,383,954.68 42,984,16126 1111672024 2050 2.401 24,174.79 206.58 21,281.37
911759MN5, s08e3 1000 FAC 4,000,000.00 4,000,000.00 4,000,000.00 08/01/2023 2.618 = 2.654 8,726.67 0.00 8,726.67
A5818WCP9 10395 1000 FAC 25,000,000.00 25,000,000.00 25,000,000.00 Gevi2022 2385 24ta 49,687.50 0.00 49,687.50
45920078 40928 1000 FAC. 10,000,000.00 9,969,779.56 9,970,416.22 05/18/2024 3.000 3.128 25,000.00 828.68 25,626.66
$59200J78 10930 1000 FAC 10,009,000.00 9,984,177.78 9.984,511.11 Os/18/2024 3.000 3.087 25,000.00 333.33 25,333.33
4592008 10986 1000 FAC 18,000,000.00 18,060,789.24 15,059,508.57 05/16/2024 3.000 2.926 37,500.00 ~1,280.67 36.219.33
459200KI02 11059 1000 Mes 10,000,000.00 10,028,305.81 10,025,822.85 ON192021 2305 2029 19,205.25 -2,482.96 16,722.29
45920078 11090 1000 FAG 13, 130,000.00 13,625,651.87 13,615,209.77 05/18/2024 3.000 1,999 32,825.00 ~40,442.40 22,382.90
459200HP9 14438 1000 MCS 3,000,¢00.00 3,143,692.95 9,139,785.77 0801/2023 3.376 = 1.804 8,497.50 377718 4,660.32
AS932HAMS 11140 1000 C5 17,525,000.00 17,893,547.88 17,873,095.01 1172072021 3.600 2.160 92,284.63 20,512.87 34771.68
45905U6RO 10888 1000 NCI 25,000,000.00 25,000,000.00 25,000,000.00 03/26/2024 2.770 2.808 $7,708.23 0.00 87,708.33
489050226 10938 1000 HCI 35,000,000.00 35,000,000.60 $5,000,000.00 05/28/2024 2.480 2514 72,338.24 0.00 72,338.34
ASSOSUEW9 10960 1000 Eco] 25,000,000.00 25,000,000.00 25,000,000.00 07/1572024 2300 2.332 47,916.67 9.00 47,916.67
459058GH0 11014 1000 uct 30,000,000.00 30,352,518.33 30,326,849.62 077242021 2750 1,727 68,750.00 -25,688.81 43,081.19
459058H09 11035 4000 MoI 20,000,000.00 20,000,000.00 20,000,000.00 11/18/2024 2160 2.190 36,000.00 0.00 26,000.00
ASS05U4U5 11037 1000 HCA 25,000,000.00 28,000,000.00 26,000,000.00 11/18/2022 1.810 1.885 37,708.33 0.00 37,708.33
459058HV8 11091 1000 MCI $0,000,000.00 80,000,000.00 60,000,000.60 0172872025 2050 «2078 85,416.68 0.09 85,416.66
ASEGOF AES 10972 1000 MCt 20,000,000.00 20,187,486.96 20,161,389.13 091672022 2350 1.995 39,166.68 6,097.83, 33,068.83
481200370 10654 1009 RRP 235,000,000.00 235,000,000.00 235,000,000.00 0.00 0.00 0.00
481240375 10679 1000 RRP 135,000,000.00 135,000,000.00 135,060,000.00 0.00 0.00 0.00
484242785 11120 1000 RRP 0.00 0.00 0.09 0.00 0.00 0.00
O15 18, 10008 1000 RR2 200,899,110.44 525,861,492.95 200,899,110.44 0.087 37,817.49 0.00 97,617.49
46628HK9 joe43 1000 TRO 10,000,000.00 10,292,052.98 10,084,768.03 OS/19/2024 3.626 «2.824 29,713.12 8,174.95 21,598.47
48130USU0 1054 > 4000 MCs 0.00 26,000,000.00 0.00 oavze2023 2.100 1.742 26,250.00 0.00 26,250.00
48130USU0 11055 1009 MCS 0.090 28,000,000.00 0.00 08/24/2023 2.100 1.742 26,260.00 0.09 26,250.00
481286679 11063 1000 Mes 25,000,000.00 28,000,000.00 25,000,000.00 09/30/2024 2260 2.269 46,616.02 0.00 $8,616.02
481286 M49 10975 1000 MCs 25,000,000.00 25,000,000.00 25,000,000.00 1127/2024 2.300 2.332 47,918.67 0.00 47,916.87
48130UTI4 11096 1000 NCS 25,000,000.00 25.000,000.00 25,000,000.00 01/31/2023 2.000 2.028 41,666.67 0.00 44,686.67
4G626HRLG 11102 1000 NCS 8,825,000.00 8,992,234.93 8,987,532.91 05/18/2028 2.700 2.050 19,856.26 4,702.02 18,184.23
48128GU40 11187 1000 Mes 28,000,000.00 0.00 25,000,000.00 06/24/2026 1.050 1.597 8,760.00 0.00 8,780.00

Portfolio INVT
AP
Run Data: O7142020 - 15.10 TE(PRF_IE)7.20

Repert Ver. 7.36.1

MARICOPA COUNTY TREASURER
interest Earnings
June 4, 2020 - June 30, 2020

Page &

Adjusted taterest Eamings

Security Enging Beginning Ending Maturity GurrentAnnualized Interest Amortization’ Adjusted Interest
cusiP investment# Fund Type Par Value Book Value Book Value Date Rate Yietd Eamed Accretion Eamings
Fund: Treasurer's Pool x -
48430UUQS 11488 1000 MCS. 28,000,000.00 0.00 25,000,000.00 06/2472025 1.000 1.014 5,855.85 0.00 5,555.55
195216012 40987 1000 FAG 15,000,000.00 15,000,600.00 15,000,000.00 0206/2024 «1.750 1.774 21,875.00 0.00 21,875.00
110122873 11116- 1000 MCS 10,000,000,00 10,209,039.87 10,298,889.24 05/16/2022 2600 1,005 21,658.67 13,160.63 8,516.04
§67320GT7 14191 1000 MC2 700,000.00 704,777.50 704,410.00 0701/2021 1.000 0.373 583.33, -367.50 215.83
$673206T9 11193 1000 MC2 400,000.00 402,845.35 402,768.45 07/01/2023 1.000 9.774 333.33 -76.90 256.43,
£67320G10 14194 1000 MC2 400,000.00 402,861.39 402,602.99 0701/2024 1.000 0.830 333.33 58.40 274.93
$87320611 14195 1000 end 360,000.00 392,512.31 362,471.12'07/01/2025 1.000 0.864 201.68 A119 250.47
$87320GT8 i192 1000 MCZ 4,100,000.00 1,107,739.69 1,107,430.10 0701/2022 1.000 0.667 916.67 -409.69 607,08,
576294000 10925 1600 FAC 20,000,000.00 19,997,414 25 19,949,784.82 04/19/2022 2500 © 2685 41,665.68 2,347.87 44,014.23
MESDIR 10953 1000 MC2 330,000.00 330,000.00 330,000.00 07/01/2020 2.130 2.160 885.75 0.00 585.75
MESDAR 10954 1000 mez 335,000.60 335,000.00 335,000.00 07/01/2021 2.130 2.160 504,62 0.00 594.62
MESD3R 10985 1000 MG2 345,000.00 348,000.00 345,000.00 0701/2022 2.130 2.160 81237 0.00 61237
MESOAR, 10986 1000 Mc2 350,000.60 380,000.00 380,000.00 0701/2023 2.130 2.180 621.25 0.00 621.25
MESDSR: 10957 1000 Mc2 355,000.00 355,000.00 355,000.00 0701/2024 2.130 2.180 630.12 0.00 630.12
S66897W2 11182 1000 Mc2 4,780,000.00 4,765,846.69 4,764,627.74 07/01/2021 0.950 (0.649 3,760.42 “1,218.98 2,541.44
SESEITIAND 11183 1000 MC2 2,125,000,00 2,128,076.61 2,124,673.65 077012022 0.980 (0.720 1,662.29 ~403.08 4,279.23
SEBEITWXE 11184 1000 Mc2 13,000,000.00 13,067,128.11 13,065,313.83 0701/2023 0.950 0.789 10,291.87 ~4,814.28 8,477.39
SEBBSYWYE 19185 1000 Mca 10,125,000.00 10, 169,501.91 10,168,593.71 07/01/2024 9.950 (0.850 8,015.62 903.20 7,107.42
S9166RBHO 11003 4000 FAC 12,180,000.00 12,782,993.91 42,769,322.33 o4/1072024 3.600 2.168 38,450.00 13,871.58 22,778.42
BOS87YAPAS, 10959 1000 FAG 18,000,000.00 15,376,040.64 15,264,691.32 03/06/2023 3.549 2612 44,262.50 714,349.32 33,013.18
SOSB7YAVI 11004 1000 FAG 20,000,000.00 20,172,472.12 20,167,872.86 07/16/2023 2.721 2.458 45,350.00 -4,599.26 40,780.74
S06B7YAH2 11062 1000 MCS 8,575,000.00 6.687,743.62 6,663,908.12 02/28/2022 2983 2.143 16,179.98 -4,437.50 11,742.48
60687YAS8 11473 1000 MCS 8,205,000,00 0,00 685,125.98 O8142024 3.922 2.168 18,928.01 8227.42 40,700.69
e8S79YEBS 10919 1000 FAC 10,000,000.00 10,214,920.14 10,210,083.23 02/14/2024 3.250 2.650 27,083.34 4,836.91 22,246.43
B8578YAXS 10848 1000 FAG 20,000,000.00 20,047,916.48 20,046,484.71 OW18/2023 2.250 2.189 37,500.00 “1436.77 36,068.23
88579YBEO 41028 1900 vRi 16,387,000.00 16,393,955.24 46,399,601.02 02/14/2024 2475 2.497 33,788.18 184.22 93,043.96
5e4918BX1 10896 1000 FAC 25,000,000,00 26,307,521.49 25,300,588.74 0206/2024 2876 2.545 $9,895.83 6962.75 52,933.08
GAZ55AW26 10894 1000 FAC 10,000,000.00 10,279,883.84 10,273,705.39 03/10/2024 3.750 2.567 34,250.00 6178.45 25,071.55
606822807 11132 1000 MCS. 5,000,000.00 4,961,979.63 4,963,434.49 07/25/2022 1.630 2.022 6,791.67 1,454.86 8,245.63
644062406 11088 1000 MCS 25,000,000.00 26,090,002.43 26,083,469.85 02/24/2023 3350 1.975 69,791.68 -27,43268 42,389.03
63743HERS i011 1000 Fac 14,003,000.00 14,040,367.18 14,036,419,04 03/16/2025 2900 2.690 33,840.58 3,947.24 20,893.34
63743HEQI 10924 1000 FAG 6,000,000.00 $,954,085.57 $955,757.21 09/15/2022 2309 «2.692 11,890.00 1,671.54 13,171.84
665279873 10424 1000 RRP 0.01 0.01 0.01 0.00 0.00 0.00
GaIE9XBCR 14189 1000 MCS. 6,000,000.00 0.00 5,463,065.97 05/16/2026 2.900 5.101 6,186.67 -1,884.03 4,582.64
6971RPSS 19926 19000 FAC 20,000,000.00 19,993,010.00 19,993,310.00 05/10/2022 2.650 2.706 44,166.68 300.00 44,466.65
69371ROSS 11104 {000 MCS §,009,000.00 $020,093.29 5,019,735.65 0206/2025 1.800 4734 7,800.00 357.74 714226
TA7081EX7 11164 1000 MCS 40,000,000.00 10,000,000.00 10,000,000,00 08/28/2025 0.800 0.811 8,668.68 0.00 6,666.66

Portfolio INVT
AP
Rin Date: O7/1472020- 15:10 IE(PRE_1)720

Report Vet, 7.3.6.1

MARICOPA COUNTY TREASURER
y Interest Earmlags Pages
June 4, 2020 - June 30, 2020

Adjusted Interest Earnings

Security Ending Beginning Ending Maturity CurrentAnnualized Interest Amortization! Adjusted {aterest
cusiP Investment# Fund Type Par Valua Book Value Book Valua Data Rata_—_‘Yield Eamed Accretion Earnings
Fund: Treasurer's Pooi
PHXEOISB 10217 1000 Mca 2,025,000.00 2,028,656.61 2,025,000.00 07/0472020 3.870 1.420 6,024.37 3,656.61 2367.78
PHXEOISC 10218 1000 M2 4,130,000.00 4,221,297.98 4,214,276.04 07012021 3.870 1.517 12,288.78 -7,022.92 $,263.83
67505084 11168 1000 Mca 1,200,000.00 4,202,197.48 1,202,028.43 0710112021 0.790 (0.628 790.00 -169.03 620.97
§875050T2 11169 1000 Me2 8,550,000.00 8,57 1,630.64 6,570,765.41 07/01/2022 0.780 (0.638 4,312.09 885.23 3,448.06
$87505QU9 11470 1000 M2 19,090,000.00 10,033,479.35 10,032,574.51 07/01/2023 0.780 0.689 6,583.33 2204.84 $,678.49
$8 7505QV7 11978 1000 Mca 13,850,000.00 13,877,362.05 13,676,803.64 07/01/2024 0.790 (0.780 8,986.25 ~$58.41 8,427.84
74817282 10258 1000 FAC 5,000,000.00 4,956,834.24 4,958,057.07 05/10/2023 2425-2473 8,854.17 1,222.83 40,077.00
748172CH0 11074 1000 Mes 10,518,000.00 10,841,198.70 10,824,320.17 0510/2024 2875 2.056 28,199.37 6,876.83 18,322.84
Tat720N7 11449, 1000 Mes 25,000,000.00 24,976 260.60 24,976,761.27 05012025 1.500 1.642 31,250.00 400.67 34,650.67
Ti8t720NT 11472 1000 MCS 6,108,000.00 0.00 6239,179.93 0501/2025 1.600 1.158 7,360.50 “2,035.85 §,944.95
7497 IRDES 11004 1000 FAG 20,000,000.00 20,335,953.44 20,329,193.82 07/22/0024 2626 «2213 43,750.00 6,759.62 36,990.28
78014RCMO 11448 1000 MCS 20,000,000.00 20,000,000.00 20,000,000.00 09/27/2025 1.600 1.624 25,000.00 0.00 25,000.00
T8014ROXE 41157 1000 MOS 25,000,000.00 25,000,000.00 25,000,000.00 0622/2023 1.150 1.168 23,958.93 0.00 23,958.33
e2zasocca {1068 1000 MCS 10,000,000.00 9,948.076.56 9,949,052.57 1110772024 2.000 2.468 16,666.66 976.01 17,6426?
822582CA8 41065 1000 145 25,000,000.00 25,069,108.28 25,087,462.85 1119/2023 2805 «= 2260 48,013.42 “1,645.43 48,387.89
822582AX0 11129 1000 MCS 1,488,000.00 1,830,292.76 08/12/2023 3.400 1.742 4,431.00 -4,937.36 2,193.64
822882824 11131 1000 HCE 6,894,000.00 6,951.214.96 11142023 3.001.816 19,232.40 8,841.96 10,390.54
RVRQ016(_3 10243 tooo ac2 1,650,900.00 1,850,000,00 0701/2020 1.200 1.318 4,787.60 .ca 4,787.50
RYR201681_4 10244 1000 ec2 1,385,000.00 1,355,000.00 1,365,000.00 07/01/2021 1.420 1.440 4,603.42 0.00 1,603.42
RVR2016R_3 10247 1000 uc2 1,045,000.00 1,047,.711.22 4,045,000.00 0770172020 4.500 1.402 3,918.75 “20122 1,207.83
RVR2016R_4 40248 joo0 Mc2 1,095,000.00 1,035,009.00 §,095,000.00 o7m01/2021 1.420 1.440 4,298.75 0.00 1,285.76
78014ROVS 41174 toca vRI 25,000,000.00 0.00 25,000,000.00 0608/2022 1.000. 1.003 15,800.48 0.00 18,800.48
SCFDO18B 10592 1000 Mace 88,000.00 $8,178.47 58,000.00 0700172020 6.140 2.474 296.77 “178.47 118.30
SCFDO18G 10593 1000 Mcz 62,000.00 64,363.00 64,181.23 07/01/2021 6.140 2.861 317.23 9184.97 135.46
SCFDOI8D 10504 4000 Nc2 65,000.00 69,555.44 69,373.20 07/01/2022 6.140 2.630 332.58 18221 180.37
808513AT2 10891 1000 FAC 28,000,000.00 26,071,708 88 25,069,450.98 01/25/2023 2650 2.670 55,208.33 “2,254.90 52,953.43
86562 BMI 10861 4000 Fac 10,009,000.00 9,893,070.00 9,993,210.00 07/16/2024 2696 2.782 22,466.67 440.00 22,608.87
SB562MAEO 10966 4000 FAC 17, 18,000.00 17,151,383.18 17,155,847.98 07/4202) 2.058 2.122 29,425.97 404.80 29,920.77
B6S62MAT? 11008 1000 FAG 14,010,000.00 14,057,992.86 14,056,891.01 i0/1872022 2000 1.879 23,380.00 1,640.95 21,709.05,
‘86562hAT7 114040 1000 FAC $498,000.60 §,516,692.98 §,518,044.08 10/18/2022 2000 1.855 9,168.33 -748.90 8,409.43
S8562MBTE 11063 1000 Mics 14,072,000.00 14,161,253.00 11,159,632.19 09/27/2024 2448-2275 2B “1,720.81 20,866.07
Be582MAWO 11110 1000 MCs $,000,000.00 $,037,922.24 $,036,719.73 01/17/2023 1.810 1.531 7,841.87 -1,20261 6,339.08
85620AW0 11145, 1000 Mics 1,848,000.00 1,852, 189.49 1,851,964.15 01/17/2023 1.810 1.704 2,784.39 $185.34 2,589.05
BESE2MAXB 11484 1000 NCS 25,000,000.00 25,061,622.02 25,931,126.69 011772023 3.102 1,689 64,825.00 20,495.42 94,129.68
892331ABS 10898 1000 FAC 17,000,090.60 17,108,338.48 17,100,389.12 07/20/2021 9.483 2642 45,092.60 7,948.36 37,146.14
‘SO288TFXE 10204 1000 FAC 16,000,000.00 14,994,128.76 14,994,391.25 0412/2022 2.650 2.708 33,125.00 262.60 33,387.50
89236TFNO 10920 to00 FAC 10,000,000.00 10,282,604.24 10,226,735.34 0972072023 3.460 2.721 28,780.00 -5,858.90 22,881.10

Porifofia INVT
AP
Run Osta: 07/14/2020 - 18:10 - SE {PRF_IE)720

Report Ver. 7361

MARICOPA COUNTY TREASURER
Interest Earnings Page?
June 1, 2020 - June 30, 2020

Adjusted Interest Earnings

; Security Ending Beginning Ending Maturity GurrentAnnualized Interest Amortizatlon’ Adjusted taterest
cust Tavestment # Fund Type Par Value Book Value Book Value Date Rate_—_Yield Earned Accretion Earnings
Fund: Treasurer's Pool
89228TOM1 11000 1000 FAG 20,000,000.00 20,000,000.00 20,000,000.00 07/31/2024 1.875 1.901 31,260.00 0.00 34,260.00
89236TOP? 14017 1000 MCS 12,000,000.00 42,195,764.05 12128,741.77 O1182022 2600 1.803 26,000.00 -7,022.28 18,977.72
89288TOPT 11058 4900 MCB 8,000,000.00 8,094,855.70 8,089.049.97 01/11/2022 2600 1,868 17,933.33 4,906.33 12,427.00
89206TGO2 11039 1900 MCS 25,000,000.00 25,000,000.00 25,000,000.00 112172024 2.128 2.168 - 44,270.84 0.00 44,270.84
a9226TFRI 11127 1000 MCS 2,500,000.00 2,500,498.96 2,500.426.90 01/08/2021 1.320 1.205 2,750.00 $7.06 2682.04
so2ceTEWt 11148 1000 MCB 18,000,000.00 16,288,517.24 16,268,466.27 04/14/2025 3.400 1.827 42,500.00 -22,054.07 20,448.93
89236TOKE 11180 1000 MCS 8,161,000.00 8,458,877.10 8,451,584.20 10/18/2023 2250 1.145 18,301.87 342.90 7,958.97
89236THC2 14188 4000 MCS 28,000,000.00 0.09 28,000,000.00 08/17/2025 1.000 1.014 9,722.22 0.00 9,722.22
OSTBAAXS toess 1000 FAC §,000,000.00 §,128,340.39 8,128,689.00 08/05/2024 2600 1,935 10,833.34 -2,680.49 8,152.85
SO4764AXS 11144 1900 FAC 18,000,000.00 48,207,817.16 16,203,114.38 0595/2024 2.600 2.248 32,500.00 4402.77 28,097.23
91924PCNO 11026 1000 MCS 5,000,000.00 5,153.478.58 5,147,451.93 07/18/2022 3.360 1.873 13,988.33 6,026.65 7,931.68
911312869 10944 4000 FAC 17,430,000.00 47,479,.223.09 17,477,128.48 OSNG/2022 2350-2200 34,133.75 -2,094.60 32,039.15
SOS31HNLS2 108s 1000 Met 8,300,000.00 8,335,086.32 8,333,980.66 01/24/2023 2850 2716 19,712.60 ~1,108.68 18,608.84
9t1SSHHVE 10809 1000 FAC 12,000,000.00 42,208,230.01 12,200,688.58 0208/2024 3.375 2.901 33,760.00 4650.43 20,099.57
‘90331HPF4 14126 1000 MCS 20,000,000.00 20.410.617.11 20,397,484.37 0100972023 «1.950 1.184 32,800.00 “43,192.74 19,967.26
S67031SE0 11181 1000 Mea 2,326,000.00 0.00 2,344,847.47 O7N12021 1.800 0.658 1,997.50 095.53 245.97
$87031SF7 41182 1000 Mc2 1,875,000.00 0.00 1,600,913.43 07/01/2022 1.500 0.676 1,812.60 -719.82 592.68
se1214DAB 10910 * 1000 FAC 14,449,000.00 14,928,656.66 14,336,809.35 08172021 2.000 2.745 24,081.66 8,242.69 32,324.35
sat214Ds9 j0923, 1000 FAC 7,888,000.00 7,983,024.74 7,563,821.82 011172023 2.750 2.928 47,989.17 797.08 18,186.25
61214068 i103 1000 MCS 20,000,000.00 20,285,081.63 20,241,887.76 O111/2022 2.800 2.011 46,666.66 713,193.87 3347279
961214086 11082 1000 ier) 20,000,000.00 20,141,639.67 20,132,069.42 Ga/t9/2021 2.753 2.193 AS87717 9,870.25 36,308.92
2498855P8 10876 1000 FAG 9,414,000.00 9,496,180.22 9,434,597.34 07/28/2021 3.325 3.155 26,084.63 -1,642.88 24,474.75
esonqu2cs jo 1000 FAC 10,006,000.00 40,213,763.08 10,208,869.12 o12ar2024 «3.780 3.141 31,250.00 4983.93, 26,366.07
ee000U2C8 40921 1000 FAC 20,000,000.00 20,485,702.00 20,474,604.47 0124/2024 3.760 3.083, 62,500.00 -14,097.53 81,402.47
950000288 11022 1000 NCS 10,000,000.00 40,110,446.93 10,106,149.39 07/22/2022 2.625 2.115 21,876.00 4297.64 17,577.46
95001DSE6 11028 1000 NCS 30,000,000.00 39,000,000.00 30,000,000.00 117062024 2.300 2.332 87,500.00 0.00 87,500.00
9497488A0 11029 tooo MCs 24,648,000.00 24,668,202.53 24,667,164.16 07/28/2021 2.100 2.048 43,130.60 71,848.38 41,482.52
S5001DSR7 it0a7 1000 MCS 20,000,000.00 20,000,000.00 20,000,000.00 01/17/2026 2.260 2.281 37,800.00 0.00 37,500.00
95001D509 11088 1000 NCS 20,000,000.00 20,000,000.00 20,000,000.00 01/17/2023 2.000 2.028 33,393.33 0.00 33,333.33
s8001D509 11099 1000 MCS. 28,000,000.00 28,000,000.00 25,000,000.00 o1/i7/2023 2.000 2.028 44,666.67 0.00 41,666.67
95001DSR7 11100 4090 MCS 30,000,000.00 $0,000,000.00 30,000,000.00 01/17/2025 2.250 -2.28t 58,250.00 0.00 $6,250.00
SEOHOSVS 11108 1000 Fe) 28,000,000.00 25,000,000.00 25,000,000.00 0228/2023 1.900 1.928 39,583.24 0.00 39,563.34
eeoo1D8¥2 11136 1000 MCS 18,000,000,00 16,000,000.00 16,000,000.00 04/7/2025 1.780 1.774 24,878.00 0.00 21,875.00
esosiDsy2 14437 jo00 MC5 20,000,000.00 20,000,000.00 20,000,000.00 09/17/2026 1.760 1.774 20,166.67 0.00 29,188.67
S500106F2 14447 1000 MCS 25,000,000.00 25,000,000.00 25,000,000.00 040272025 2.780 2.788 87,291.67 0.00 87,201.67
S5001D7E4 1186 4000 MCS 28,000,000.00 25,000,000.00 28,000,000.00 5/15/2023 1.600 1.524 31,250.00 9.00 31,250.00
asoo1D 7M 11158 1000 MCs 20,000,000.00 20,000,000.00 20,000,000,00 11/22/2022 4.200 1.318 21,666.87 0.00 21,666.67
Portfotio INVT
AP
Run Data: 07/12/2020 - 15:10 HE (PRF_1E)7.20

Resort Ver. 7.3.6.1

MARICOPA COUNTY TREASURER
Interest Earnings
June 4, 2020 - June 30, 2020

Page 8

Adjusted interest Eamings

‘Security Ending BegInaing Ending Maturity CurrentAnnualized laterest Amortization! Adjusted taterest
cusp Investment? Fund Type Par Value Book Value Book Value Date Rate__Yield Eamed Accretion Eamings
Fund: Treasurers Pool
S5001D7L8 11169 1000 MCs 20,000,000.00 20,000,000.00 20,000,000.00 05/22/2025 1.700 1.724 28,933.33 0.00 28,933.33
esncqu2ce +1178 1000 FAC 10,785,000.00 0.00 11,642,994.23 017242024 3.760 -8.605 -£6,171.88 $18,086.00 “74,227.88
98001DAC4 41184 1000 MCS 26,000,000.00 0.00 28,000,000.00 1217/2023 1260 1287 12,152.78 0.00 12,152.78

Subtotal 4,817,136,110.45 §,841,038,778.64 4,836,586,503.47 1.286 6,502,912.99 $02,142.44 6,000,800.88,
Fund; MIHS Bond Proceeds
3133862R7 11044 S34BP- AFD 35,357,000.00 35,283,399.61 35,327,535.84 0772172020 1.600 1.524 0.00 44,196.23 44,196.23
313396YHO 11043 Ss4BP AFD 0.00 35,288,162.12 0.00 oa/19/2020 1.842 0.00 26,897.88 26,837.88
912628NT3 41044 S¢BP TRO 24,600,000.00 34,671,168.37 34,£42,701.02 08/16/2020 2.625 1.625 74,639.43 28,487.38 46,172.08
Subtotal 69,857,000.00 108,140,670.10 69,870,236.86 1.887 74,639.43 42,568.76 147,208.19
Fund; MIHS Debt Service
313384YHS 11095 séDS AFD 0.00 17,592,985.35 0.00 oaie72020 1.650 1.573 0.00 13,644.65 18,644.65
665279873 10425 SDS RRP -28,718.42 -25,718.42 -28,718.42 0.00 0.00 90.00
912828XU9 11047 suDS TRG 9.00 24,999,734.53 0.00 car1Er2020 1.500 1.524 14,344.28 285.47 14,609.73
Subtotat “25,718.42 42,566,371.48 “25,748.42 1.849 14,344.26 43,910.42 28,264.38
Fund; MIHS Health Plan Sate
M1a384YHS it0e4 Sa4HP AFD 0.00 19,068,883.77 0.00 osi19/2020 £550 1.573 0.99 10,136.23 $0,126.23
912826XU9 11048 534HP- TRE 0.00 18,999,798.24 0.00 08182020 1.500 1.524 10,901.64 201.76 14,103.40
Subtotal 0.00 32,068,852.04 0.00 1.647 10,901.64 10,337.99 21,239.63
Fund: MIMS Malntenance & Ops
08406F ABI 10906 SUMO | FAC 8,876,000.00 8,525,624.58 8,530,085.61 0503/2021 2050 2.742 14,650.67 4,561.03 49,211.70
3192EKG YE 10805 54MO FAC 25,845,000.00 26,820,06321 25,820,586.83 04/18/2021 2375 = 2.484 $1151.55 1,822.62 52,674.18
aiaseayes 1149 S34MO_ AFD 0.00 24,999,898.73 0.00 06/18/2020 0.003 0.009 0.00 101.27 101.27
717081DX8 10907 S84M0 FAC. 7,184,000.00 7,183,353.62 7,186,722.10 0B0a2021 1.950 2.661 44,690.26 3,368.48 15,058.73
822882850 10908 5S4MO FAC 8,899,000.00 $481,027.56 8,486,157.86 O5/1072021 1.875 2.650 49,042.19 5,130.30 18,472.49
912828XU8 10952 534MO TRO 0.00 26,995,874.44 0.00 06/18/2020 1.500 1.947 14,244.27 4,325.58 18,669.63
Subtotal §0,184,000.00 99,084,842.14 80,003,851.40 1.993 105,178.94 19,009.28 124,488.20
Totat 4,937,121,392.03 6,120,799,021.35 4,956,434,573.31 4.272 $,707,977.28 416,287.98 8,291,689.28
Portfolio INVT
AP
Run Dats: 074472020 15:10 IE (PRE_1€)7.20

Report Ver. 73.6.4