MONTHLY REPORT NOVEMBER 2020.PDF
Extracted text (via tesseract_tsv)
54665 characters
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: December 14, 2020
TO: Clint Hickman, Chairman
Jack Sellers, Supervisor, District f
Steve Chucri, Supervisor, District 2
Bill Gates Supervisor, District 3
Steve Gallardo, Supervisor, District 5
SUBJECT: Treasurer's Collections and Investment Summary for November 2020
Secured property tax collections during the month of November equaled $656,058,597 and
increased the 2026 year to date collections to $2,725,812,1 11 or 50% of the adjusted 2026 levy of
$5,500,044,138. The chart below reflects the 2020 collected and uncollected levy amount and
corresponding percentages for the 2026 property tax year.
November
2020
Uncoltected Levy
$2,774,232,027
50%
Collected Levy
$2,725,842,111
50%
@Collected Levy Uncollected Levy
The County’s General Fund Balance totaled $334,906,989,89 effective Nevember 30, 2020.
Warrants outstanding of $6,748,907.58 will post against the fund balances when presented.
The $17,130,436 unencumbered balance, of the County Municipal Line of Credit and the
$17,869,570 Workers Compensation Liability Letter of Credit remain unused.
Rissell K. Pearce
Chief Deputy Treasurer
COUNTY OF MARICOPA — )
This instrument was acknowledged before me this 14th day of December 2020, by Russell Kk.
Pearee, 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.
Ay anus Q Chairk, Qoe. iS oval
Notary Publie My Commission Expires
KAREN D SMITH
Notary Pub’c - Arizona
Maricopa County
My Comm. Expres Dec 15, 2021
Page 22 of 1060
Maricopa County Treasurer
Object Code Summary
November FY 2021
COUNTY
200-2000-2100-20000
TAF: GENERAL FUND
AGENCY ACCOUNT: GENERAL
Object Object Description MTD Transactions YTD Balances
Beginning Balance (270,874,345.62) (117,674,665.32)
3111 REAL PROPERTY TAXES - CURRENT YEAR (78,274,921.39) (327,543,409.69)
3112 REAL PROPERTY TAXES - 1ST PRECEEDING YEAR (285,797.00) (5,083,279.21)
3123 PERSONAL PROPERTY TAXES - 2ND PRECEEDING YEAR AND EARLIER (410.87)
3150 GOVERNMENT PROPERTY LEASE EXCISE TAX - TAX (222,658.70) (226,052.03)
3151 IN LIEU TAX - SRP (5,359,788.31) _(6,359,788.31)
3201 FEES - WHITE TANK (87,668.86) (293,015.36)
3202 FEES - ENCANTO (40,842.19) (242,111.98)
3203 FEES - SAN MARCOS (33,837.76) (163,028.92)
3204 FEES - EAST MESA (32,963.60) (154,987.72)
3205 FEES - DOWNTOWN (43,057.90) (240,772.13)
3206 FEES - ARCADIA BILTMORE (24,280.35) (415,303.05)
3207 FEES - IRONWOOD (16,762.60) (73,846.46)
3208 FEES - MANISTEE (40,656.58) (189,202.84)
3209 FEES - MARYVALE (30,125.56) (144,794.66)
3210 FEES - NORTH MESA (46,626.44) (241,574.78)
3211 FEES - DREAMY DRAW (27,432.47) (125,766.78)
3212 FEES - MOON VALLEY (32,920.18) (161,613.68)
3213 FEES - ARROWHEAD (36,858.48) (185,446.97)
3214 FEES - MCDOWELL MOUNTAIN (17,660.75) (87,332.28)
3215 FEES - SAN TAN (42,830.99) (207,744.90)
3216 FEES -SOUTH MOUNTAIN (30,800.05) (162,954.09)
3217 FEES - UNIVERSITY LAKES (37,117.98) (176,966.82)
3218 FEES - AGUA FRIA (32,785.04) (164,742.80)
3219 FEES - WEST MESA (45,762.62) (235,365.47)
3220 FEES - WEST MCDOWELL (38,396.55) (219,874.65)
3221 FEES - HASSAYAMPA (37,657.00) (165,364.82)
3222 FEES - NORTH VALLEY (37,259.09) (479,866.20)
3223 FEES - KYRENE (45,335.47) (228,647.40)
3224 FEES - DESERT RIDGE (53,880.21) (237,616.48)
3225 FEES - HIGHLAND (24,411.27) (107,673.22)
3226 FEES - COUNTRY MEADOWS (48,944.38) (234,446.65)
3301 INVESTMENT EARNINGS ON INVESTMENT POOL DEPOSITS (1,102,425.66)
3500 DEPOSITS FROM AGENCIES - NON-SCHOOL ENTITIES (75,927,629.67) (321,952,944.21)
3599 MISCELLANEOUS DEPOSITS (30,735.90)
3711 DELINQUENT INTEREST (631,569.99) (4,631,986.84)
3712 ADVERTISING FEE COLLECTED 2,580.90 6,446.74
YTO based on a July-June fiscal year. Positive transaction ts rep Debits or exp Hegative t tie {s rep Credits or revenues.
Page 23 of 1060
Maricopa County Treasurer
Object Code Summary
November FY 2021
|
(1,079.40) (9,076.41)
3717 DOCUMENT FEES
(43,073.38) (315,016.37)
3721 CIVIL PENALTY
5 1 4 1 3 8 1788 636 176 33 59.175949 (449,542.13)
5 1 4 1 3 9 2073 631 173 34 95.667557 (423,739.60)
4 1 4 1 4 0 243 691 2004 59 -1
5 1 4 1 4 1 243 725 68 25 96.659370 3723
5 1 4 1 4 2 490 720 77 26 96.383934 MISC
5 1 4 1 4 3 579 718 78 26 96.790207 FEES
5 1 4 1 4 4 1824 696 141 33 95.556839 (9,005.00)
5 1 4 1 4 5 2091 691 156 34 92.920998 (88,357.55)
4 1 4 1 5 0 243 753 2004 57 -1
5 1 4 1 5 1 243 772 132 38 66.902786 3724
5 1 4 1 5 2 491 780 100 26 95.826889 STATE
5 1 4 1 5 3 603 778 84 26 95.826889 DEED
5 1 4 1 5 4 699 777 59 26 96.367920 FEE
5 1 4 1 5 5 2134 753 113 32 90.703888 (250.00)
4 1 4 1 6 0 244 813 2005 57 -1
5 1 4 1 6 1 244 846 69 24 94.019501 3725
5 1 4 1 6 2 492 840 132 26 92.762947 SHERIFF
5 1 4 1 6 3 636 838 60 25 96.345337 FEE
5 1 4 1 6 4 1854 817 113 32 96.342323 (134.40)
5 1 4 1 6 5 2136 813 113 32 96.808685 (456.80)
4 1 4 1 7 0 246 862 2004 70 -1
5 1 4 1 7 1 246 906 68 26 96.738136 3729
5 1 4 1 7 2 493 900 127 26 96.831482 EXCESS
5 1 4 1 7 3 631 897 175 32 96.579758 PROCEEDS
5 1 4 1 7 4 817 895 80 25 96.831543 FEES
5 1 4 1 7 5 1854 862 114 53 96.787811 (888.00)
5 1 4 1 7 6 2112 873 138 32 94.816376 (8,993.00)
4 1 4 1 8 0 246 933 2006 59 -1
5 1 4 1 8 1 246 966 69 26 96.564529 3730
5 1 4 1 8 2 495 960 183 26 96.130943 UNCLAIMED
5 1 4 1 8 3 690 955 171 28 96.842148 PROPERTY
5 1 4 1 8 4 2016 933 236 33 0.000000 (176,820.26)
4 1 4 1 9 0 247 993 2006 66 -1
5 1 4 1 9 1 247 1026 65 26 68.337479 4801
5 1 4 1 9 2 495 1021 86 25 96.249954 BANK
5 1 4 1 9 3 591 1020 80 39 96.636658 FEES
5 1 4 1 9 4 1851 997 120 31 94.541176 7,577.33
5 1 4 1 9 5 2116 993 137 29 92.698067 47,183.65
4 1 4 1 10 0 249 1043 2004 69 -1
5 1 4 1 10 1 249 1087 68 25 96.653015 4803
5 1 4 1 10 2 496 1081 98 26 96.387840 STALE
5 1 4 1 10 3 606 1080 104 24 42.466412 DATED
5 1 4 1 10 4 721 1077 130 26 96.600426 CHECKS
5 1 4 1 10 5 1795 1043 176 53 95.435944 (745,095.59)
5 1 4 1 10 6 2080 1053 173 33 88.332993 (954,054.13)
2 1 5 0 0 0 250 1113 2005 104 -1
3 1 5 1 0 0 250 1113 2005 104 -1
4 1 5 1 1 0 250 1113 2005 63 -1
5 1 5 1 1 1 250 1147 68 25 87.052269 8100
5 1 5 1 1 2 496 1140 133 27 96.042824 AGENCY
5 1 5 1 1 3 637 1121 170 55 96.199379 TRANSFER
5 1 5 1 1 4 1650 1152 3 2 0.000000 .
5 1 5 1 1 5 1773 1118 201 31 88.688240 98,564,954.83
5 1 5 1 1 6 2040 1113 215 30 91.108932 455,358,602.96
4 1 5 1 2 0 945 1173 1310 44 -1
5 1 5 1 2 1 945 1194 2 3 17.280855 ,
5 1 5 1 2 2 1468 1186 95 31 96.819267 Ending
5 1 5 1 2 3 1576 1185 112 24 83.260506 Balance
5 1 5 1 2 4 1735 1179 239 33 74.546165 (334,906,989.89)
5 1 5 1 2 5 2022 1176 128 32 6.917000 (334,906,
5 1 5 1 2 6 2157 1169 98 44 6.917000 989.89)
2 1 6 0 0 0 2518 26 24 1017 -1
3 1 6 1 0 0 2518 26 24 1017 -1
4 1 6 1 1 0 2518 26 24 1017 -1
5 1 6 1 1 1 2518 26 24 1017 95.000000
3722 PP ASMT PENALTY ARS 42-15055
1
01-DEC-2020 PAGE:
BALANCE 29,917,439.81 1,844,893.19 1,493,783.75 1,426,312.24 1,409,402.53 1,058,340.86 768,690.79 1,517,117.51- 20,521,430.62 43,258,637.36- 86,829,335.56 25,872,265.70 784,896.54- 861,158.74- 469,109.17 556,068.03 1,102,461.12- 1,666,558.01- 342,895.31 866,117.61- 680,620.36- 763,899.73- 652,562.86- 82,273.28- 761,851.11- 1,131,451.59- 1,187,757.93 3,574,325.77 2,207,521.85 7,952,619.51 8,122,152.43 3,284,787.16- 22,355.94 17,516.20 86,095.02 21,166.00 28,883.91 11,573.32 13,529.19 11,274.71 15,972.66 17,517.30 12,427.08 12,599.20 10,864.89 8,954.20 6,216.48 5,885.92 4,111.30 1,998.26 922.38 331.83
2,774,232,026.63
ENDING
FICE 508,727.68- 82,441.18- 540.92- 1,881.72- 1,405.13- 1,649.36- 486.40- 1,228.84- 903.74- 1,079.96- 12,938.54- 644.76- 703.22- 00 .00 90 - 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 90 00 00 00 .00
OF 2020 ADJUSTMENTS 2,276,396.89- 307,887.26
NOV
TREASURER'S FOR ACTIVITY 142,372.87- .82- 8,193.07 5,364.08 745.06 717.28 675.68 713.08 619.81 354.98 180.90 $20.00 319.02 374.58 00 .00 00 00 00 00 00 00 00 .00 00 .00 00 -00 .00 00 00 00 00 00 00 00 -00 00 .00 00 00 00 00 00 -00 00 -00 .00 00 00 00
COLLECTIONS 656,058,596.91 2,647,619.13 78,062
AND
COUNTY LEVY
SECURED BALANCE 33,073,786.62 1,784,961.50 1,107,833.67 1,435,046.23 1,416,648.33 1,060,491.05 771,057.43 1,515,955.43- 20,523,372.54 43,257,113.81- 86,830,770.50 25,885,385.14 ,331.78- 860,136.50- 469,483.75 556,068.03 1,102,461.12- 1,666,558.01- 342,895.31 866,117.61- 680,620.36- 763,899.73- 86- 652,562. 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 1L,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
3,432,567,020.43 783
MARICOPA BEGINNING
LEVY_RPT_MONTH_SUM LEVY 5,509,210,795.20 5,268,316,083.92 5,032,079,420.54 4,791,587,056.58 4,643,191,878.76 4,364,407,727.86 4,243,506,812.16 4,019,480,209.28 4,045,298,460.92 4,138,461,193.04 4,411,089,394.04 4,593,263,862.98 4,288,606,572.70 4,001,594,678.74 3,660,387,436.00 3,489,841,477.20 3,246,259,075.84 3,049,037,955.00 2,792,576,236.72 2,595,278,869.32 2,290,234,573.96 2,108,718,697.02 1,939,463,904.72 1,800,100,859.36 958.46 1,683,783,514.12 1,507,769,663.58 1,476,046,063.04-: ,592.42 1,485,482,338.84 1,445,084,095.32 1,306,266,536.54 1,181,440,841.12 1,049,888,299.56 870,295,854.72 721,770,831.08 944,379.84 530,525,148.42 451,214,378.40 402,942,488.72 373,230,675.34 382,783,606.36 365,594,731.04 360,443,065.88 332,481,242.68 294,189,512.68 251,690,646.52 224,585,828.94 191,805,552.44 165,623,012.50 82 138,694,628. 126,692,073.74 116,414,184.58
1,631,715, 1,477,426 600,
APP 2003 2002 2001 2000 1999 1998 1997 1996 1995 1994 1993 1992 1991 1990 1989 1988 1987 1986 1985 1984 1983 1982 1981 1980 1379 1978 1977 1976 1975 1974 1973 1972 1972 1970 1969 1968
ID:
PROGRAM
2,912,682,174.49
2,583,141.08-
658,504,957.89
.46
3,573,770,273
111,468,818,977.56
TOTAL
1
01-DEC-2020 PAGE:
BALANCE 197,750.52- 13,356,195.33- 3,025,486.22 908,054.38- 9,600,127.73- 28,717,298.70- 25,613,966.52- 22,991,125.84- 35,349,496.01- 28,930,837.94- 7,647,548.41 14,738,205.59- 825.13- 17,960, 6,674,520,32- 1,269,365.39- 8,387,264.09- 21,988,363.31- 7,485,743.99- 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- 82- 6,816,484. 86- 5,944,729. 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,537,762.06-
cz ENDING
OFFI 2020 ADJUSTMENTS
URER'S NOV FOR
TREAS ACTIVITY AND COLLECTIONS
COUNTY LEVY
UNSECURED BALANCE 197,750.52- 13,356,195.33- 3,025,486.22 908,054.38- 9,600,127.73- 28,717,298.70- 25,613,966.52- 22,991,125.84- 325,349,496.01- 28,930,837.94- 7,647,548.41 14,738,205.59- 17,960,825.13- 6,674,520.32- 1,269,365.39- 8,387,264.09- 21,988,363.31- 7,485,743.99- 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,537,762.06-
MARICOPA BEGINNING
LEVY_RPT_MONTH_SUM LEVY .00 .00 16,903,615.38 19,330,396.80 138,497,672.37 122,871,629.32 122,881,710.56 115,134,253.32 102,673,892.06 113,747,601.86 162,209,939.25 154,917,045.68 140,629,687.78 131,582,120.56 122,744,902.09 113,929,972.43 96,811,185.54 88,991,362.81 76,956,283.43 50,507,999.56 53,570,953.57 73,434,045.21 37,836,109.79 36,683,300.76 30,075,323.04 29,722,220.00 28,615,308.42 26,779,663.13 23,204,794.95 19,189,042.79 15,296,922.12 13,177,965.26 13,623,786.21 12,084,654.91 10,386,975.86 5,918,654.86 4,195,165.19 2,325,116,156.87
APP ID: YEAR 2004 2003 2002 2001 2000 1999 1998 1997 1996 1995 1994 1993 1992 1991 1990 1989 1988 1987 1986 1985 1984 1983 1982 1981 1980 1979 1978 1977 1976 1975 1974 1973 1972 1971 1970 1969 1968 TOTAL
PROGRAM
County Interest Eamings 19,666.67 25,000,00 20,833.33 11,166.67 3,666.67 12,579.72 44,043.61 33,658.03 12,241.06 9.75 10.46 10.06 49,71 23,152.00 3,250.00 2,708.33 9,166.67 8,516.03 13,000.00 277.61 958.73 864.22 2,079.89 2,271.79 1,855.42 10,908.34 41,830.80 6,344.19 23,192,79 95,833.33 INVT AP 7.3.14 7.3.11 Vor,
Portfolio (PRF_TE) Report
Maricopa Adjusted TE
0.00 0,00 0.00 0.00 9.00 0.00 0.00 0,00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0,00 0.00 0.00 0.00 0,00 0,00
Eamings Realized Gainl/Loss
Interest
Adjusted Accretion 0.00 0.00 0.00 0.00 0.00 ~5,601.61 5,710.27 -1,341.97 2,398.01 -38.23 -37,.52 -31.52 -132.61 -6,848.00 0.00 0.00 0.00 -13,150.63 0.00 -537.80 -1,756.68 -1,399.94 -2,860,11 -2,913.62 -977.91 -6,300.00 ~2,960.87 -1,155.81 712,223.88 0,00
Amortization!
Interest Earned 19,666.67 25,000.00 20,833.33 11,166.67 3,666.67 18,181.33 38,333.34 35,000.00 14,639.07 47.98 47,98 41.58 482.32 30,000.00 3,250.00 2,708.33 9,166.67 21,666.66 13,000.00 815.41 2,715.41 2,264.16 4,940.00 5,185.41 2,833.33 17,208.34 44,791.67 7,500.00 35,416.67 95,833.33
Funds
2020 Annualized Yield 1.196 1.014 1.014 0.679 0.446 0.555 2.693 2.044 0,946 0.651 0.682 0.740 0,819 2.285 0.989 0.989 0.558 4.012 0.791 0.650 0.666 0.713 0.780 0,808 0.563 1.869 2.024 0.385 0,563, 2.332
Selected
30,
Issuer Current Rate 1.180 1.000 1.000 0.670 0.440 0.800 2.300 2.100 41.125 3.290 3.290 3.290 3.290 3.000 0.650 0.650 0.550 2.600 0.780 1,900 1.900 1,900 1.800 1.900 0.850 2,950 2.150 0.450 0.850 2.300
TREASURER Earnings Fund - November Ending Value 20,000,000.00 30,000,000.00 25,000,000.00 20,000,000.00 25,000,000.00 27,574,860.21 19,901,021.95 20,028,673,40 15,742,894.29 78,113.27 79,985.23 70,808.73 316,257.29 12,321,627.73 30,000,000.00 25,000,000.00 20,000,000.00 10,230,136.08 20,000,000.00 518,764.61 1,748,376.91 4,473,397.99 3,242,984.55 3,417,787.41 4,006,877.97 7,093,450.00 25,139,851.74 20,038,642.49 50,085,974.63 50,000,000.00
- Book
by 2020
Total 1,
COUNTY Sorted Value 9.00 0.00 0,00 0.00 0.00 0.00 0.00 $19,302.41
November Beginning Book 20,000,000,00 30,000,000.00 25,000,000,00 20,000,000.00 580,461.82 19,895,311.68 20,030,015,37 15,745,292.30 12,328,475.73 20,000,000.00 10,243,286.71 20,000,000.00 1,750,133.59 1,474,797.93 3,245,844.66 3,420,681.03 4,007,855.88 7,099,750.00 25,142,812.61 20,039,798.30 §0,098,198.51 §0,000,000.00
27
MARICOPA
Ending Value 20,000,000.00 30,000,000.00 25,000,000.00 20,000,000.00 25,000,000.00 272,000.00 20,000,000.00 20,000,000.00 45,615,000,00 75,000.00 75,000.00 65,000.00 285,000.00 42,000,000,00 30,000,000.00 25,000,000.00 20,000,000.00 40,000,000,00 20,000,000,00 515,000.00 1,715,000.00 1,430,000.00 3,120,000.00 3,275,000.00 4,000,000.00 7,000,000.00 25,000,000.00 20,000,000.00 50,000,000.00 50,000,000,00
Par 27
Issuer ACAFP ACAFP ACAFP ACAFP ACAFP AMAZ APPL APPL APPL ARESD ARESD ARESD ARESD AXP BAC BAG BKMON BMY BN BUCHSD BUCHSD BUCHSD BUCHSD BUCHSD BUCHSD CAT CAT CAT CHNUSD CITI 10:00
SymPro Fund 4000 4000 4000 4000 4000 1000 1000 1000 1006 1000 1000 1000 1000 4000 1000 1000 1000 1000 1000 1000 4000 1000 4000 41000 1000 1000 1000 1000 1006 4000 12/09/2020
nt#
Investme Pool 11179 210016 210054 210070 210094 210002 $ 1087 5 1094 83 141 44 2101 21011 21011 210117 10 110 ie) 2101 ie} 2101 55 2100 46 141 11176 63 411 4 1116 11165 41166 14167 210004 11021 11084 0059 21 210005 32 4110 ~REPORT~: 10:00 -
= ahe asurer's Updated: 12/09/2020
rues Tre: 22533AC96 22533ACG0 22533ACK1 22533ACP0 22533ACS4 023135B08 037833CQ1 037833DC1 037833DT4 1 567269BF §67269BG9 567269BH7 567269BJ3 025816BR9 O6048WK41 06048WK41 06367W5J8 110122BY3 064159UKO 118106KD4 1118106KE2 06KFS 118106KG7 418106KHS 2021TANBU 14913Q2T5 14913Q383 14913R2F3 2021TANCU 17298CHJO Data Date:
CUSIP Fund: 1181 Run
2 Page Interest Eamings 52,835.51 56,250.00 41,666.67 27,500.00 42,500,00 11,458.33 9,027.78 39,185.71 10,956.69 20,986.68 4,107.94 8,400.00 8,541,76 2,503.03 2,267.32 18,764.13 4,615.39
Adjusted
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0,00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Earnings Realized Gainl/Loss
Interest
Adjusted Accretion -38,414.49 0.00 0.00 0.00 0.00 0.00 0.00 4,685.71 -1,543.31 416.66 100.44 141.67 0.08 -1,830.30 -2,649.34 -2,069.20 -14,054.28 7,334.32
5 1 12 6 12 2 1288 528 22 51 92.635353 0.00
5 1 12 6 12 3 1282 260 26 121 92.529655 13,915.68
4 1 12 6 13 0 1324 259 37 683 -1
5 1 12 6 13 1 1336 835 25 107 96.020447 3,976.86
5 1 12 6 13 2 1330 526 22 52 96.075981 0.00
5 1 12 6 13 3 1324 259 26 124 81.938133 40,435.19
4 1 12 6 14 0 1365 258 33 629 -1
5 1 12 6 14 1 1377 835 21 52 94.111595 0.00
5 1 12 6 14 2 1371 525 21 53 94.369850 0.00
5 1 12 6 14 3 1365 258 24 122 88.253174 47,351.08
3 1 12 7 0 0 1407 256 116 661 -1
4 1 12 7 1 0 1407 258 33 629 -1
5 1 12 7 1 1 1419 834 21 53 96.484642 0.00
5 1 12 7 1 2 1413 525 21 51 96.385399 0.00
5 1 12 7 1 3 1407 258 26 122 93.893578 26,026.63
4 1 12 7 2 0 1449 256 33 661 -1
5 1 12 7 2 1 1461 832 21 85 81.088806 593,75
5 1 12 7 2 2 1455 523 21 52 93.917465 0.00
5 1 12 7 2 3 1449 256 24 124 88.514740 31,322.92
4 1 12 7 3 0 1491 256 32 628 -1
5 1 12 7 3 1 1503 832 20 52 95.050507 0.00
5 1 12 7 3 2 1495 523 22 52 96.012123 0.00
5 1 12 7 3 3 1491 256 24 122 80.612877 56,500.00
3 1 12 8 0 0 1531 255 34 629 -1
4 1 12 8 1 0 1531 255 34 629 -1
5 1 12 8 1 1 1543 831 22 53 96.668213 0.00
5 1 12 8 1 2 1537 522 22 51 95.709251 0.00
5 1 12 8 1 3 1531 255 26 123 96.487335 43,750.00
3 1 12 9 0 0 1573 253 34 629 -1
4 1 12 9 1 0 1573 253 34 629 -1
5 1 12 9 1 1 1585 831 22 51 96.757347 0.00
5 1 12 9 1 2 1579 520 22 53 94.666580 0.00
5 1 12 9 1 3 1573 253 25 107 92.259026 5,555.56
3 1 12 10 0 0 1615 253 34 629 -1
4 1 12 10 1 0 1615 253 34 629 -1
5 1 12 10 1 1 1627 829 22 53 95.593086 0.00
5 1 12 10 1 2 1621 520 22 52 90.057159 0.00
5 1 12 10 1 3 1615 253 26 122 95.071487 22,875.00
3 1 12 11 0 0 1657 252 34 629 -1
4 1 12 11 1 0 1657 252 34 629 -1
5 1 12 11 1 1 1670 828 21 53 96.457718 0.00
5 1 12 11 1 2 1663 519 22 51 95.848701 0.00
5 1 12 11 1 3 1657 252 26 123 94.883560 25,000.00
3 1 12 12 0 0 1699 252 34 627 -1
4 1 12 12 1 0 1699 252 34 627 -1
5 1 12 12 1 1 1711 828 22 51 94.711693 0.00
5 1 12 12 1 2 1705 519 20 51 94.506607 0.00
5 1 12 12 1 3 1699 252 25 122 94.880814 25,833.33
3 1 12 13 0 0 1740 250 33 629 -1
4 1 12 13 1 0 1740 250 33 629 -1
5 1 12 13 1 1 1752 826 21 53 95.808975 0.00
5 1 12 13 1 2 1746 517 21 52 96.885597 0.00
5 1 12 13 1 3 1740 250 26 122 82.343048 25,000.00
3 1 12 14 0 0 1782 249 35 629 -1
4 1 12 14 1 0 1782 249 35 629 -1
5 1 12 14 1 1 1795 825 22 53 93.277313 0.00
5 1 12 14 1 2 1788 516 21 53 96.412003 0.00
5 1 12 14 1 3 1782 249 26 122 85.070732 41,041.67
3 1 12 15 0 0 1824 247 119 661 -1
4 1 12 15 1 0 1824 249 35 627 -1
5 1 12 15 1 1 1836 825 23 51 95.031258 0.00
5 1 12 15 1 2 1830 516 21 51 96.572227 0.00
5 1 12 15 1 3 1824 249 26 107 96.671516 9,791.67
4 1 12 15 2 0 1866 247 35 661 -1
5 1 12 15 2 1 1878 823 23 85 69.187508 313.80
5 1 12 15 2 2 1872 514 21 52 96.719337 0.00
5 1 12 15 2 3 1866 247 26 122 89.655815 13,022.24
4 1 12 15 3 0 1908 247 35 628 -1
5 1 12 15 3 1 1921 823 22 52 86.277016 0.00
5 1 12 15 3 2 1914 514 21 52 93.372345 0.00
5 1 12 15 3 3 1908 247 26 107 95.362495 6,000.00
3 1 12 16 0 0 1950 246 33 628 -1
4 1 12 16 1 0 1950 246 33 628 -1
5 1 12 16 1 1 1962 822 21 52 94.601105 0.00
5 1 12 16 1 2 1955 513 22 51 80.535233 9.00
5 1 12 16 1 3 1950 246 26 107 95.622169 8,958.33
3 1 12 17 0 0 1992 243 116 660 -1
4 1 12 17 1 0 1992 246 33 627 -1
5 1 12 17 1 1 2004 820 21 53 94.545006 0.00
5 1 12 17 1 2 1998 511 20 53 93.332527 0.00
5 1 12 17 1 3 1992 246 24 105 94.992897 8,250.00
4 1 12 17 2 0 2033 244 34 659 -1
5 1 12 17 2 1 2046 820 21 83 95.928635 127.86
5 1 12 17 2 2 2039 511 21 52 94.400955 0.00
5 1 12 17 2 3 2033 244 25 107 92.765106 5,336.19
4 1 12 17 3 0 2074 243 34 629 -1
5 1 12 17 3 1 2086 819 22 53 95.588829 0.00
5 1 12 17 3 2 2080 510 22 51 93.364861 0.00
5 1 12 17 3 3 2074 243 25 108 95.501259 7,638.89
2 1 13 0 0 0 2218 243 29 197 -1
3 1 13 1 0 0 2218 243 29 197 -1
4 1 13 1 1 0 2218 243 29 197 -1
5 1 13 1 1 1 2221 325 26 115 93.269272 Portfolio
5 1 13 1 1 2 2218 243 26 71 86.787628 INVT
2 1 14 0 0 0 2263 244 103 217 -1
3 1 14 1 0 0 2263 244 103 217 -1
4 1 14 1 1 0 2263 244 25 41 -1
5 1 14 1 1 1 2263 244 25 41 95.339294 AP
4 1 14 1 2 0 2309 246 25 215 -1
5 1 14 1 2 1 2312 432 18 29 91.922119 TE
5 1 14 1 2 2 2309 318 25 105 88.571808 (PRF_TE)
5 1 14 1 2 3 2309 246 18 63 79.789246 7.3.11
4 1 14 1 3 0 2340 244 26 191 -1
5 1 14 1 3 1 2343 364 23 71 91.860130 Roport
5 1 14 1 3 2 2342 316 18 42 85.944473 Ver.
5 1 14 1 3 3 2340 244 20 62 13.494587 7.3.11
2 1 15 0 0 0 2512 34 26 971 -1
3 1 15 1 0 0 2512 34 26 971 -1
4 1 15 1 1 0 2512 34 26 971 -1
5 1 15 1 1 1 2512 34 26 971 95.000000
Amortization/
Interest Earned $1,250.00 56,250.00 41,666.67 27,500.00 12,500.00 11,458.33 9,027.78 37,500.00 12,500.00 21,383.34 4,007.50 8,541.67 8,541.67 4,333.33 4,916.66 20,833,33 18,666.67 21,250.00 36,458.33 17,351.08 26,026.63 30,729.17 56,500.00 43,750.00 5,555.56 22,875.00 25,000.00 25,833.33 25,000.00 11,041.67 9,791.67 12,708.34 6,000.00 8,958.33 8,250,00 §,208.33 7,638,89
Funds ; Yield 2.042 2.281 2.028 4.415 1.014 0.558 4.014 2,389 2.648 2.548 0.715 2.041 2.078 4.496 1.349 0.911 0.670 0.563 1.982 2.114 2.111 3.049 2.281 2.123 2.028 1.855 4.217 1.257 4.217 0.537 0.477 0.634 0.365 0.436 0.446 0.312 0.446
Annualized
Selected 2020 30, Rate 3.650 2.250 2.000 1.100 1.000 0.550 1.000 2.250 3.000 2.566 0.687 2.050 2.050 2.600 2.950 4.000 2,800 0.850 4.750 2.082 2.082 2.950 2.260 2.100 2.000 1.830 1.200 1,240 4.200 0.530 0.470 0.610 0.360 0,430 0.440 0.300 0.440
Current
TREASURER Earnings November Ending Value 31,449,506.48 30,000,000.00 25,000,000.00 30,000,000.00 45,000,000.00 25,000,000.00 25,000,000.00 49,960,441.90 §,033,129.87 10,012,291.67 6,994,338.25 §,006,979.44 4,998,995.33 2,033,372.43 2,042,389.39 25,063,317.60 8,363,459.74 30,051,584.78 24,821,174.11 40,000,000.00 15,000,000.00 0.00 30,000,000.00 25,000,000.00 0.00 15,000,000.00 25,000,000.00 25,000,000.00 25,000,000.00 25,000,000.00 25,000,000,00 24,982,170.76 20,000,000,00 25,000,000.00 25,000,000.00 24,993,877.86 25,000,000.00
- Book
Tota! 2020
COUNTY 1,
November Value 0.00 856.86 0.00 0.00 0,00
MARICOPA Beginning Book 31,487,920.97 30,000,000.00 25,000,000.00 30,000,000.00 15,000,000.00 25,000,000,00 19,958,756,19 5,034,673.18 10,012,708.33 6,994,237.81 §,007,121.11 4,999,995.24 2,035,202.73 2,045,038.73 25,065,386.80 8,377,511.02 30,058,919.10 24,817,197.25 10,000,000.00 45,000,000.00 24,999,406.25 30,000,000,00 25,000,000.00 25,000,000.00 45,000,000,00 25,000,000.00 25,000,000.00 25,000,000.00 25,000,000.00 25,000,000,00 24,981 20,000,000.00 25,000,000.00
0,00 0.00
Ending Value 30,000,000.00 30,000,000.00 25,000,000.00 30,000,000.00 15,000,000,00 25,000,000.00 25,000,000,00 20,000,000.00 5,000,000,00 10,000,000.00 7,000,000.00 5,000,000.00 §,000,000.00 2,000,000.00 2,000,000.00 25,000,000.00 8,000,000.00 30,000,000,00 25,000,000.00 10,000,000.00 45,000,000.00 30,000,000.00 25,000,000.00 15,000,000.00 25,000,000.00 25,000,000.00 25,000,000.00 25,000,000.00 25,000,000.00 25,000,000.00 20,000,000.00 25,000,000.00 25,000,000.00 25,000,000.00 25,000,000.00
Par
Issuer CITI citi cim! CITI ciTl cit CITI Cl CME CVX CVX DE DE DE DE DE DE DEERUS DIS FFCB FFCB FFCB FFCB FFCB FFCB FFCB FFCB FFCB FFCB FFCB FFCB FFCB FFCB FFCB FFCB FFCB FFCB 10:00
Fund 1000 1000 1000 4000 1000 1000 4000 4000 1000 1000 1000 1000 1000 1000 4000 1000 1000 4000 1000 4000 1000 1000 4000 1000 1000 4000 1000 1000 1000 1000 1000 1000 1000 1000 4000 1000 1000 12/09/2020
Investment# Pool 41072 11093" 11106 210023 210038 210069 210091 10929 10922 40931 210017 11070 41073 11128 11130 41177 11178 210006 11016 10739 10740 10789 10976 10999 14024 11053 41117 44123 11142 210013 210022 210039 210058 210067 210082 210084 210085 ~REPORT~: 10:00 -
Treasurer's Updated: 12/09/2020
17325FAS7 17327T2B1 17327TF68 47298CJZ2 17298CK64 17328WSD1 17298CKS6 19416QELO 12572QAES 466764BK5 166756AE6 24422EVC0 24422EVCO 244199BE4 24422EUTS 24422EUG2 24422ERTS 2021TANDV 254687FK7 EJWU4 WS4 EU 3133EJT9O 3133EKH58 3133EK2R6 3133EK5M4 3133ELFP4 3133ELRQS3 3133ELRZ9 3133ELUK8 3133EL3P7 3133EL4J0 3133EL4W1 3133EL6H2 3133EMCYS 3133EMFP2 3133EMBE1 3133EMFP2 Data Date: Run
cusiP Fund: 3133 S133
3 Page Interest Earnings 6,319.44 4,243.06 39,916.45 31,210.22 31,090.41 1,666.67 30,616.66 25,833.34 20,000.00 16,666.87 8,746.67 3,958.33 7,708.33 2,083.33 29,166.67 31,944.44 33,854.17 33,854.17 12,800.00 11,955.33 10,833.33 4,135.00 7,291.66 4,986.00 5,500.00 7,812.50 6,250.00 15,000.00 3,262.50 6,250.00 8,333.33 5,500.01 6,594.40 2,604.17 4,741.67 1,777.78 1,244.44 INVT AP 7.3.11 7,3.11
Adjusted Portfolio (PRF_TE) Ver, Report
TE
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0,00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0,00 0,00 0.00 0,00 0.00 0,00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0,00 0.00 0.00
Earnings Reatized GainliLoss
Interest
Adjusted Accretion 6.00 0.00 12,472.01 4,206.45 4,326.26 0.00 0.00 0.00 0.00 0.00 127.67 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0,00 605.33 0.00 0,00 0.00 0,00 0.00 0.00 0.00 0.00 137,50 0.00 0,00 166.67 ~353.04 0.00 0.00 0,00 0,00
Amortization/
Interest Earned 6,319.44 4,243.06 27,444.44 35,416.67 35,416.67 1,666.67 30,616.66 25,833.34 20,000.00 16,666.67 8,619.00 3,958.33 7,708.33 2,083.33 29,166.67 31,944.44 33,854.17 33,854.17 12,500.00 41,350.00 10,833.33 4,435.00 7,291.66 4,986.00 5,500.00 7,812.50 6,250.00 15,000.00 3,125.00 6,250.00 8,333.33 5,333.34 6,944.44 2,604.17 1,741.87 4,777.78 1,244.44
Funds Annualized Yield 0.615 ‘0.477 2.804 1,886 1,883 2.028 4.693 4.257 1.217 0.811 0.700 0.193 0.375 0.253 1.774 2.028 1.9041 1.904 0.608 0.642 0.527 0,304 0.355 0,304 0,335 0.380 0.304 0,730 0.265 0.304 0.406 0.335 0.385 0.253 0,223 0.324 0.324
2020
Selected 30, Current Rate 0.350 0.470 4.900 2.125 2.125 2.000 4.670 1.240 1,200 0,800 0.680 6,190 0.370 0.250 1.750 2.000 1.875 1.875 0.600 0.600 0,520 0,300 0.350 0,300 0.330 0.375 0.300 0.720 0.250 0.300 0.400 0.320 0.400 0.250 0.220 0.320 0,320
TREASURER Earnings November Ending Value 0.00 0,00 0,00 0.00 0.00
- Book 25,000,000,00 25,000,000,00 20,127,315.27 20,079,170.46 22,000,000.00 25,000,000.00 20,000,000.00 25,000,000,00 15,202,982.29 25,000,000.00 25,000,000.00 25,000,000,00 20,000,000.00 25,000,000,00 22,665,738.13 25,000,000,00 16,540,000.00 25,000,000.00 19,944,000.00 20,000,000,00 25,006,000,.00 25,000,000,00 25,000,000,00 14,995,430.42 25,000,000.00 25,000,000.00 19,993,2114.11 25,013,796.96 25,000,000.00 19,000,000,00 25,000,000.00 20,000,000,00
Total 2020
COUNTY 1,
November Beginning Vaiue 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
MARICOPA Book 19,987,527.99 20,131,521.72 20,083,496.72 10,000,000.00 22,000,000,00 25,000,000.00 20,000,000.00 25,000,000.00 15,202,854.62 25,000,000.00 25,000,000.00 20,000,000,00 25,000,000,00 25,000,000.00 25,000,000.00 25,000,000.00 22,665,132.80 25,000,000,00 16,540,000.00 25,000,000,00 19,944,000,00 20,000,000.00 25,000,000.00 25,000,000.00 25,000,000.00 14,995,292.92 25,000,000,00 25,000,000.00 19,993,044.44
Ending Value 0.00 0.00 0.00 0.00 0.00
Par 25,000,000.00 25,000,000.00 20,000,000.00 20,000,000.00 22,000,000.00 25,000,000.00 20,000,000.00 25,000,000.00 15,210,000,00 25,000,000.00 25,000,000,00 25,000,000.00 20,000,000.00 25,000,000.00 22,700,000.00 25,000,000.00 16,540,000.00 25,000,000.00 19,944,000.00 20,000,000.00 25,000,000.00 25,000,000.00 25,000,000.00 45,000,000.00 25,000,000.00 25,000,000.00 20,000,000.00 25,000,000.00 25,000,000.00 49,000,000.00 25,000,000.00 20,000,000.00
Issuer FFCB FFCB FHLB FRLB FHLB FHLB FHLB FHLB FHLB FHLB FHLB FHLB FHLB FHLB FHLMC FHLMG FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC 10:00
Fund 1000 1000 1000 1000 1000 1000 4000 1000 4000 4000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 12/09/2020
Investment# Pool 210089 210090 10705 10962 10964 11020 14144 11144 11143 11190 210001 210040 210041 210095 10405 10564 10571 10572 210014 210021 210033 210042 210044 210047 210048 210049 210050 210056 210087 210064 210071 210072 210083 210087 210088 210098 210103 ~REPORT™~: 10:00 -
Treasurer's 12/09/2020
Updated:
CUSIP Fund: 3133EMGF3 3133EMGR7 3130ACTUB 313383463 313379Q69 3130AHGK3 3130AJC49 3134GVFL7 3130AJF79 3130AJQZ5 3130AJRP6 3124GWK39 3130AK3R5 3130AKG26 3134GBU2 3134GB39 3134GB2A9 3134GBZ70 3134GVWND4 3134GWPT7 3134GWMN3 3134GWJ49 3134GWL61 3134GWL95 3134GWL46 3134GWK54 3134GWK70 3134GWD86 3137EAEWS 34134GWY42 3134GWZRO 3134GWZT6 3134GWPJ9 3134GXBE3 3134GW7D2 3134GXBV5 3134GXCAO Date:
Data Run
4 Page Interest Earnings 2,527.78 52,467.25 21,000.00 11,458.33 412,916.67 10,416.67 10,833.33 13,020.84 14,583.34 13,750.00 5,166.67 12,500.00 6,458.33 3,645.83 4,555.56 13,975.11 7,885.54 16,859.20 33,333.33 12,500.00 2,916.67 3,141.11 3,417.96 19,305.17 34,844.01 9,119.69 3,760.61 7,846.14 7,781.55 13,866.19 21,381.38 8,726.67 49,687.50 25,636.67 25,333.34 36,219.33 22,382.90 INVT AP 7.3.11 7.3.11
Adjusted Portfolio (PRF_TE) Vor. Roport
TE
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0,00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Earnings Realized Gainl/Loss
Interest
Adjusted Acerction 0.00 383.92 0.00 0.00 416.67 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 -28,821.97 4156.12 -3,180.46 0.00 0.00 9.00 0.00 ~332,04 7,388.50 -9,530.99 -224.89 -406.06 -2,153.89 551.78 -1,450.48 206.59 0.00 0.00 636.67 333.34 ~1,280.67 10,442.10
Amortization/
Interest Eamed 2,527.78 52,083.33 21,000.00 11,458.33 12,500.00 10,416.67 10,833.33 13,020.84 14,583.34 13,750.00 5,186.67 12,500.00 6,458.33 3,645.83 1,555.56 42,797.08 12,041.66 20,039.66 33,333.33 12,500.00 2,916.67 3,111.11 3,750.00 11,916.67 44,375.00 9,344.58 4,166.67 10,000.00 8,333.33 15,316.67 21,174.79 8,726.67 49,687.50 25,000.00 25,000.00 37,500.00 32,825.00
Funds Annualized Yield 0.659 2.555 4.278 0.558 0.629 0.507 0.527 0.634 0.710 0,669 0.406 0.608 0.314 0,380 0.355 0.981 0.563 2.447 2.028 0.608 0,608 0.811 0.415 2.377 2.759 2.026 0.914 0.943 0.944 1.830 2.100 2.654 2.418 3.128 3.087 2.927 2.006
2020
Selected 30, Current Rate 0.350 2.500 1.260 0,550 0.600 0.500 0.520 0.625 0.700 0.660 0.400 0.600 0,310 0.375 0.350 3.250 0.850 2.905 2.000 0.600 0.600 0.800 0.450 1.430 3.550 2.050 1.000 1.200 1.000 2.000 2.050 2.618 2.385 3,000 3.000 3,000 3.000
TREASURER Earnings November - Ending Value Book 20,000,000.00 24,985,359.52 20,000,000.00 25,000,000.00 24,976,416.67 25,000,000.00 25,000,000.00 25,000,000.00 25,000,000.00 25,000,000.00 15,500,000.00 25,000,000.00 25,000,000.00 25,000,000.00 20,000,000.00 17,300,742.47 17,029,231.37 8,379,032.68 20,000,000.00 25,000,000.00 25,000,000.00 20,000,000.00 10,018,748.94 9,887,941.09 141.30 §,476,671.67 §,023,267.18 10,118,966.59 10,031,617.15 9,219,734.86 12,385,194.18 4,000,000.00 25,000,000,00 9,973,599.56 9,986,177.78 15,053,105.21 13,562,999.25
Total 2020 15,356,
COUNTY 1,
November Beginning Value 0.00 0.00 0.00 0.00 0.00 168.93
MARICOPA Book 24,984,975.60 20,000,000.00 25,000,000.00 24,976,000.00 25,000,000.00 25,000,000.00 25,000,000.00 25,000,000.00 25,000,000.00 15,800,000.00 25,000,000.00 25,000,000,.00 17,329,564.44 17,033,387.49 8,382,213.14 20,000,000.00 25,000,000.00 10,019,080,98 9,880,552.59 15,365,672.29 5,476,896.56 5,023,673.24 10,121,120.48 9,221,185.34 12,384,987.59 4,000,000.00 25,000,000,00 9,972,962.89 9,985,844.44 15,054,385.88 13,573,441.35
10,032,
Ending Value Par 20,000,000,00 25,000,000.00 20,000,000.00 25,000,000,00 25,000,000.00 25,000,000.00 25,000,000,00 25,000,000,00 25,000,000,00 25,000,000.00 15,500,000.00 25,000,000.00 25,000,000.00 25,000,000.00 20,000,000.00 15,802,000.00 17,000,000.00 8,278,000.00 20,000,000,00 25,000,000,00 25,000,000.00 20,000,000.00 40,000,000.00 40,000,000,00 45,000,000.00 5,470,000.00 5,000,000.00 19,000,000.00 10,000,000.00 9,190,000.00 12,395,000,00 4,000,000.00 25,000,000.00 10,000,000.00 10,000,000.00 15,000,000.00 13,130,000.00
Issuer FHLMC FNMA FNMA FNMA FNMA FNMA FNMA FNMA FNMA FNMA FNMA FNMA FNMA FNMA FNMA GD GLNHSD GOLD GOLD GOLD GOLD GOLD GOOGL HD HNDA HNDA HNDA HNDA HNDA HON HSY HUD IADB IBM |8M IBM IBM 10:00
Fund 1000 1000 1000 1000 1000 1000 1006 1000 1006 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 4000 1000 1000 1000 1000 1000 1000 4000 1000 1000 1000 4000 4000 1000 1000 4000 1000 4000 12/09/2020
Investment# Pool 210104 10861 11118 210019 210020 210024 210025 210029 210030 210031 210032 210034 210073 210092 210097 11180 210007 11033 11144 210076 210105 210106 210018 11139 10927 11083 210045 210063 210065 11007 11034 10893 10995 10928 10930 10936 11090 ~REPORT~: 10:00 -
Treasurer's 12/09/2020
Updated:
cusip Fund: 3134GXDT8 3135G0V34 3135G0Z55 3136G4H63 313664048 3136G4H71 3136G4M75 3136G4X57 313664846 313664861 313664255 3136G4HE9 3136G46V0 3135GA4S7 3135GA5B3 369550BK3 2021TANGU 38141GWM2 38150AE27 38150AED3 38150AEF8 38150AEH4 02079KAHO 437076BU5 O2665WCTE O2665WDG3 O2665WDNS O2665WDL2 O2665WDN8 438516BV7 427866BC1 911759MWS5S 45818WCP9 A459200JY8 459200JY8 459200J/Y8 459200JY8 Dato:
Data Run
5 Page Interest Earnings 4,660.32 32,062.13 16,756.63 57,708.33 72,333.33 43,081.19 13,200.00 7,561.67 $5,416.67 33,068.84 7,885.54 6,147.10 21,538.15 46,875.00 47,916.66 15,154.24 21,875.00 20,833.33 20,000.00 16,666.66 12,500.00 6,498.80 21,875.00 215.84 256.42 274.94 250.48 607.07 44,014.25 594.63 612.38 621.25 630.13 2,541.44 1,279.23 8,477.40 7,107.43 INVT AP 7.3.14 7.3.14
Adjusted Portfolio (PRF_TE) Ver. Report
TE
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0,00 0.00 0.00 0.00 0.00 0,00 0.00 0,00 0.00 0,00 0,00 0.00 0,00 0.00 0,00 0.00 0.00 0.00 0.00 0.00
Earnings Realized Gaini/Loss
Interest
Adjusted Accretion -3,777.18 -20,512.87 -2,448.62 0.00 0.00 -25,668,81 0.00 0.00 0.00 -6,097.83 4,156.12 0.00 -8,174.96 0.00 0.00 ~4,702,04 0.00 0,00 0.00 0.00 0.00 -19,501.20 0.00 -367.50 -76.94 -58.39 41.19 -309.59 2,347.58 0.00 0.00 0.00 0.00 -1,218.98 403,06 1,814.27 -908.20
Amortization/
Interest Earned 8,437.50 §2,575.00 19,205.25 57,708.33 72,333.33 68,750.00 43,200.00 541.67 85,416.87 39,156.67 12,041.66 6,147.10 29,713.11 46,875.00 47,916.66 19,856.25 21,875.00 20,833.33 20,000.00 16,666.66 12,500.00 26,000.00 21,875.00 583.34 333.33 333.33 291.67 916.66 41,666.67 §94.63 612.38 621.25 630.13 3,760.42 1,682.29 40,291.67 8,015.63
7
Funds lized Yield 1.815 2.193 2,036 2.808 2.514 4.734 1.417 0.648 2.078 1.998 0.563 0.050 2.532 2.281 2.332 2.056 4,065 4.014 0.841 0.811 0.760 0.869 1.774 0.374 0.775 0,831 0.865 0.668 2.683 2.160 2.160 2.160 2.160 0.650 0.730 0.790 0.851
2020 A
Selected 30, Current Rate 3.375 3.600 2.305 2,770 2.480 2.750 2.160 1,810 2.050 2.350 0.850 3.625 2,250 2.300 2.700 1.050 1.000 0.800 0.800 0.750 3.900 1,750 1.000 1.000 1.000 1.000 1.000 2.500 2.130 2.130 2.130 2.130 0,950 0.950 0.950 0,950
TREASURER Earnings November - Ending Value 3,120,858,85 17,769,786.90 10,013,304.15 25,000,000.00 35,000,000,00 30,198,505.47 0,00 6,00 §0,000,000,00 20,130,900.00 17,029,231.37 151,032,941.23 10,343,075.74 25,000,000.00 25,000,000.00 8,964,022.85 25,000,000.00 25,000,000.00 30,000,000.00 25,000,000.00 20,000,000.00 9,081,666.75 15,000,000.00 702,572.50 402,383.94 402,511.02 352,265.19 1,105,882.16 19,961,499.72 335,000.00 345,000.00 350,000.00 355,000.00 4,758,532.83 2,132,658.23 13,056,242.47 10,164,052,70
Book
Total 2020
COUNTY 1,
MARICOPA November Beginning Vatue Book 3,124,647.03 17,790,299.77 10,015,752.77 25,000,000.00 35,000,000.00 ,174.28 20,000,000.00 25,000,000,00 §0,000,000.00 20,136,997.83 17,033,387.49 154,032,941.23 40,351,250.70 25,000,000.00 25,000,000.00 8,968,724.86 25,000,000.00 25,000,000.00 30,000,000.00 25,000,000.00 20,000,000.00 9,101,167.95 15,000,000.00 702,940,00 402,460.85 402,569.41 352,306.38 1,106,191.75 19,959,152.14 335,000.00 345,000.00 350,000.00 355,000.00 4,759,751.81 2,133,061.29 13,058,056.74 10,164,960.90
30,224
Ending Value 3,000,000.00 17,525,000.00 10,000,000.00 25,000,000.00 35,000,000.00 30,000,000.00 0.00 0.00 §0,000,000.00 20,000,000.00 17,000,000.00 151,032,941.23 10,000,000.00 25,000,000.00 25,000,000.00 8,825,000.00 25,000,000.00 25,000,000,00 30,000,000.00 25,000,000,00 20,000,000.00 8,000,000.00 18,000,000.00 700,000.00 400,000.00 400,000.00 350,000.00 41,100,000.00 20,000,000.00 335,000.00 345,000.00 350,000.00 355,000.00 4,750,000,00 2,125,000.00 43,000,000.00 10,125,000.00
Par
Issuer {BM IBM IBM (BRD IBRD IBRD IBRD IBRD IBRD ICE ISUSD JPM JPMIG JPMIG JPMIG JPMIG JPMIG JPMIG JPMIG JPMIG JPMIG JPMIG KO LITESD LITESD LITESD LITESD LITESD MASSMU MESD MESD MESD MESD MESSD4 MESSD4 MESSD4 MESSD4 10:00
Fund 1000 1000 1000 4000 1000 4000 4000 4000 4000 4000 4000 1000 1000 4000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 4000 1000 1000 1000 1000 1000 1000 1000 1000 1000 12/09/2020
Investment# Pool 11138 11140 11059 10888 10935 11014 11038 11037 11091 10972 210008 10006 10943, 11063 10975 11102 11187 11188 210027 210028 210037 210046 10987 11191 11193 11194 11195 11192 10925 10954 10955 10956 10957 11152 11183 11154 11155 ~REPORT™~: 10:00 -
Treasurer's 12/09/2020
WX8 Updated:
CUSIP Fund: 459200HPS 44932HAMS 459200KD2 45905U6RO0 45905U2Z6 459058GHO 459058HO9 4§905U4U5 459058HV8 45866FAE4 2021TANIE XXX1518 46625HJX9 48128GG73 48128GM43 46625HRL6 48128GU40 48130UUQ6 48128GV56 48128GV56 48128GV98 46625HMN7 191216CL2 567320GT?7 567320GT9 §67320G610 567320611 567320GT8 57629WCDO MESD2R MESD3R MESD4R MESD5R 566897WV2 S66897WWO 566897 S6689YWY6 Date:
Data Run
6 Page Interest Earnings 22,778.42 33,013.19 40,750.74 11,742.48 14,138.43 6,587.84 22,246.42 36,068.24 33,643.97 52,933.09 25,071.55 8,246.53 42,359.09 29,893.35 13,171.64 0.00 4,163.16 6,604.55 10,567.76 44,466.67 7,142.26 3,404.07 1,160.59 4,638.57 6,957.84 6,666.67 1,855.82 5,263.83 620.97 3,446.85 5,678.49 8,427.84 40,076.99 48,322.85 31,650.67 5,373.27 6,849.39 INVT AP 7.3.11 7.3.11
Adjusted Portfolio (PRF_TE) Ver. Report
TE
0.00 0.00 0.00 0.00 0.00 0.00 0,00 0,00 0.00 6.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0,00 0.00 0.00 0.00 0.00 0.00 0,00 0.00 0.00 0.00 0.00 0.00 0,00 0.00 0.00 0.00 0,00
Earnings Realized Gaini/Loss
Interest
Adjusted Amortization/ Accretion -13,671.58 14,349.34 -~4,599.26 4,437.50 -9,141.58 487.16 4,836.91 -1,431.76 154,22 6,962.75 6,178.45 1,454.86 -27,432.58 -3,947.23 1,671.64 0.00 -7,920.17 14,228.79 -31,223.91 300.00 -357.74 434.85 94.15 2,444.77 -3,667.16 0.00 -370.81 -7,022.92 169.03 -865.23 -904.85 -558,41 4,222.83 6,876.53 400,67 2,261.73 12,194.99
Interest Eamed 36,450.00 44,362.50 45,350.00 16,179.98 20,280.01 7,075.00 27,083.33 37,500.00 33,798.19 59,895.84 31,250,00 6,791.67 69,791.67 33,840.58 14,500.00 0.00 12,083.33 20,833.34 41,791.67 44,166.67 7,500.00 3,838.92 1,069.44 7,083.34 10,625.00 6,666.67 2,226.33 12,286.75 790.00 4,312.08 6,583.34 8,986.25 8,854.16 25,199.38 31,280.00 7,635.00 19,044.38
Funds Annualized Yield 2.180 2.622 2.461 2.150 2,044 0,800 2.656 2.190 2.497 2.548 2.976 2.019 1.986 2.594 2.688 0.933 0.747 0.694 2.706 4.732 0.314 0.385 0.563 0.563 0.811 0.677 1.530 0.629 0.639 0.689 0.750 2.470 2,063 1.542 1.049 0.403
2020
Selected 30, Current Rate 3.600 3,549 2.721 2.953 3.922 0.849 3.250 2.250 2.475 2.875 3.750 1.630 3.350 2.900 2.300 2.900 2,500 2.950 2.650 1,800 0.350 0,350 0.850 0.850 0.800 0.580 3.570 0.790 0.790 0.790 0,790 2.125 2.875 1,500 1,500 1,125
—
TREASURER Earnings November - Ending Value Book 12,700,964.46 4§,307,944.75 20,144,876,.58 §,641,118.65 6,619,418.10 10,022,036,.07 10,185,893.67 20,039,325.88 16,393,014.54 25,265,744,99 10,242,813.13 4,970,854.28 25,926,306,93 14,016,683,76 §,964,115,42 0.01 5,423,465.11 10,739,898.92 18,482,095.29 18,994,810.00 5,017,946.83 13,176,060.17 $,991,961.90 10,017,194.93 15,025,792.39 10,000,000.00 §,556,666.29 4,179,160.44 1,201,183.25 6,566,439.28 10,028,050.27 13,674,011.59 4,984,171.20 10,799,937.54 24,978,764,61 ,871.31 20,667,654.66
Total 2020 6,227
COUNTY 1,
November Beginning Value 168.73 0.01 0.00 0.00 ,304,51
MARICOPA Book 12,714,636.04 15,319,294.06 20,149,475.84 §,645,556.15 6,628,559.68 10,022,523,.23 40,190,735.58 20,040,757.64 25,272,707.74 10,248,991.58 4,969,389,.42 25,953,739.51 14,020,630.89 5,962,443.78 5,431,385.28 10,754,125.71 18,513,319.20 19,994,510.00 5,018,304,57 13,176,495,02 410,019,639.70 15,029,459.55 40,000,000.00 4,186,183.36 1,201,352.28 40,028,955.12 13,674,570,00 4,962,948,37 10,806,814,07 24,978,363.94 6,230,133.04 20,879,849.65
16,393, 6,567
Ending Value 42,450,000.00 15,000,000.00 20,000,000.00 6,575,000.00 §,205,000.00 10,000,000.00 10,000,000.00 20,000,000.00 16,387,000.00 25,000,000.00 10,000,000.00 5,000,000,.00 25,000,000.00 14,003,000.00 6,000,000.00 0,01 §,000,000,00 10,000,000.00 17,000,000.00 20,000,000.00 5,000,000.00 13,162,000,00 10,000,000.00 410,000,000,00 15,000,000,00 410,000,000,00 §,536,000.00 4,130,000.00 1,200,000.00 6,550,000,00 10,000,000,00 13,650,000,00 §,000,000.00 10,518,000.00 25,000,000.00 6,108,000.00 20,314,000,00
Par
Issuer MET MIZUNY MIZUNY MIZUNY MIZUNY MIZUNY MMM MMM MMM MSFT MUFG MUFG NESNVX NRUG NRUC NTMM ORCL ORCL ORCL PCAR PCAR PCAR PCAR PENUSD PEORSD PFIZER PFIZER PHOESD PHOHSD PHOHSD PHOHSD PHOHSD PM PM PM PM PM 10:00
Fund 4000 1000 1000 1000 1000 1000 1000 1006 1000 1000 1000 1000 1000 1000 1006 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 12/09/2020
investment# Pool 11003 10959 11004 11062 11173 210043 10919 10946 11025 10896 10894 11132 11068 109114 10924 10424 11189 210074 210075 10926 11104 210066 210096 210009 210010 41461 210086 10218 11168 411169 411170 411171 10958 11074 11149 11172 210060 ~REPORT~: 10:00 -
Treasurer's 12/09/2020
CUSIP Fund: 5$156RBHO 60687YAP43 60687YAV1 YAH2 60687 60687YAS8 60687YBJ7 88579YBB6 88579YAXS B8579YBE0 594918BX1 064255AW2 806822AQ7 641062AD6 63743HERS 63743HEQ1 865279873 68389XBC8 68389XBT1 68389XBS3 69371RP83 1RQ66 6937 69371RQS0 69371RQ90 TANPE TANPU 717081EX7 717081EQ2 PHXE016C 567505QS4 567505QT2 567505QU9 567505QV7 718172BU2 718172CHO 718472CN7 718472CN7 718172CQ0 Updated: Date:
2021 2021 Data Run
7 Page Interest Eamings 2,923.32 36,990.37 25,000,00 23,958.33 10,416.67 17,642.68 46,367.69 2,193.64 10,390.54 1,603.41 41,295.75 20,833.33 1,855.42 135.48 180,37 52,953.43 6,957.84 22,606.67 29,920.77 21,709.05 8,409.45 20,866.07 6,339.06 2,589.05 34,129.59 14,153.45 37,146.14 33,387.50 22,881.10 31,250.00 18,977.72 12,427.00 44,270.83 2,682.95 20,448.93 7,958.98 20,833.33 INVT AP 7.3.11 7.3.11
djusted ‘+ Portfolio (PRF_TE) Report Ver,
TE
0.00 0.00 0.00 0.00 0.00 0.00 0,00 0,00 0.00 0.00 0.00 0.00 0.00 0,00 0.00 0.00 0.00 9.00 0.00 0.00 0,00 0,00 0.00 0.00 0.00 0.00 0.00 0.00 0,00 0.00 0.00 0.00 0.00 0,00 0.00 0.00 0.00
Earnings Realized Gainl/Loss
.
Interest
Adjusted Amortization/ Accretion -15,539.18 -6,759.63 0,00 0.00 0.00 976,04 -1,645.43 +1,937.36 -8,841.96 0,00 0.00 0.00 -977.91 -181.76 -182.22 2,254.90 -3,667.16 140.00 494.80 -1,640.95 -748.89 -1,720.81 1,202.61 -195.33 ~30,495.41 ~9,184.89 ~7,946.36 262.50 ~5,868.90 0.00 -7,022.28 4,906.33 0.00 -67.06 -22,051,07 342.90 0.00
-7
interest Earned 18,462.50 43,750.00 25,000.00 23,958.33 10,416.67 16,666.67 48,013.12 4,131.00 19,232.50 1,603.44 1,295.75 20,833.33 2,833.33 317.24 332.59 58,208.33 10,625.00 22,466.67 29,425.97 23,350.00 9,158.34 22,586.88 7,544.67 2,784.38 64,625.00 23,338.34 45,092.50 33,125.00 28,750.00 31,250.00 26,000.00 17,333.33 44,270.83 2,750.01 42,500.00 45,301.88 20,833.33
Funds Annualized Yield 0.401 2.217 41.521 4,166 0.634 2.157 2.251 1.753 4.828 1.440 1.440 4.014 0.563 2,598 2.665 2.571 0.563 2.752 2.122 1.880 1.856 2.276 1.533 1.702 1.609 0,882 2,648 2.709 2.728 1.901 1.908 1.873 2.155 1.306 1.538 1.150 1.014
2020
Selected 30, Current Rate 2.625 2.625 1.500 1.150 0.625 2.000 2.305 3.400 3.500 1,420 1.420 1.000 9.850 6.140 6.140 2.650 0.850 2.696 2,058 2.000 2.000 2.448 1.840 1.810 3.102 1.474 3.183 2,650 3.450 1.875 2.600 2.600 2.125 1.320 3.400 2.250 1.000
TREASURER Earnings November - Ending Value Book 147.65 20,295,395.68 20,000,000.00 25,000,000.00 20,000,000.00 9,953,932.59 25,059,071.13 1,520,705.95 6,907,005.19 1,355,000.00 1,095,000,00 25,000,000.00 4,006,877.97 63,272.39 68,462.11 176.47 15,025,792.39 9,993,910.00 17,154,321.98 14,047,523.06 5,512,124.72 11,150,928.11 5,030,706.67 1,850,987.49 25,778,649.54 19,507,312.12 17,060,657.28 14,995,703.75 10,197,390,82 20,000,000,.00 12,093,630.38 8,065,417.72 25,000,000,00 2,500,084.93 16,156,210,.94 8,414,819.68 25,000,000.00
Total 2020 8,862, 25,058,
COUNTY 1,
MARICOPA November Beginning Value Book 8,877,686.83 20,302,185.34 20,000,000.00 25,000,000.00 20,000,000,00 9,952,956.58 25,060,716.56 4,522,643.34 6,915,847.15 1,355,000.00 4,095,000.00 25,000,000.00 4,007,855.88 63,454.15 68,844.33 25,060,431.37 15,029,459.55 9,993,770.00 17,153,827.18 14,049,164,01 5,512,873.61 11,152,648,92 5,031,909.28 1,851,182,82 25,809,144.95 19,516,497.01 47,068,603.64 14,995,441.25 10,203,259.72 20,000,000.00 12,100,652.66 8,070,324.05 25,000,000.00 2,500,151.89 16,178,262.01 162.58 25,000,000.00
8,422,
Ending Par Value 8,440,000.00 20,000,000.00 20,000,000,00 25,000,000.00 20,000,000.00 10,000,000.00 25,000,000,00 1,458,000.00 6,594,000.00 1,355,000.00 1,095,000.00 25,000,000.00 4,000,000.00 62,000.00 65,000.00 25,000,000.00 45,000,000,00 10,000,000.00 17,158,000.00 14,010,000,00 5,495,000,00 14,072,000.00 §,000,000.00 1,846,000.00 25,000,000.00 19,000,000.00 17,000,000.00 15,000,000.00 40,000,000,00 20,000,000.00 42,000,000.00 8,000,000.00 25,000,000,00 2,500,000.00 15,000,000.00 8,161,000.00 25,000,000,.00
Issuer PM RABOBK RBC RBC RBC RDSALN RDSALN RDOSALN RDSALN RIVESD RIVESD RY SADUSD SCFD SCFD SCHW SCUSD SUMMIT SUMMIT SUMMIT SUMMIT SUMMIT SUMMIT SUMMIT SUMMIT SUMMIT TOYCC TOYCS TOYCC TOYCC TOYCC TOYCC TOYCC TOYCC TOYCC TOYCC TOYCC 10:00
Fund 1000 1000 1000 4000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 41000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 4000 1000 4000 4000 1000 +000 1000 1000 1000 4000 4000 12/09/2020
#
Investment Pool 210073 11001 11146 11157 210062 11038 11065 11129 11134 10244 10248 11174 210011 10593 10594 10891 210012 10961 10866 11006 11040 11069 11140 11115 11154 210026 10898 10904 10920 11000 11017 11018 11039 41127 11148 11160 41185 ~REPORT™~: 10:00 -
Treasurer's 12/09/2020
CUSIP Fund: 718172AV1 74977RDFS 78014RCMO 78014RCX6 78014RO0C1 822582CC4 822582CA8 822582AX0 822582BZ4 RVR2016Bi_4 RVR2016R_4 78014RCYS 2021TANSM SCFDO18C SCFDO018D 808513AT2 2021TANSU 86562MBM1 86562MAE0 86562MAT7 86562MAT7 86562MBT6 86562MAWO 86562MAWO 86562MAX8 86562MCAG6 892331AB5 89236TFX8 89236TFNO 89236TGM1 89236TDP7 89238TDP7 89236TGQ2 89236TFR1 89236TEW1 89236TDK8 89236THC2 Updated: Date:
Data Run
Page & Interest Earnings 40,333.33 12,916.67 10,833.34 6,800.00 18,428.50 8,152.84 28,097.23 7,931.69 32,039.15 18,606.84 29,099.57 19,367.26 1,268.96 889,02 32,324.36 18,186.25 33,472.80 36,306,93 26,366.08 $1,402.46 17,877.46 9,583.33 41,482.12 37,500.00 56,250.00 21,875.00 29,166,66 57,291.67 31,250.00 21,666.67 28,333.33 13,640,941 26,041.67 23,958.33 8,333.33 §,002,427.23 INVT AP 7.3.11 7.3.11
Adjusted * Portfotio (PRF_TE} Vor. Report
TE
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0,00 0,00 0.00 0.00 0.00 0,00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Eamings Realized Gainl/Loss ee
Interest
°
Adjusted Amortization/ Accretion 0.00 0.00 0.00 0.00 2,571.50 +2,680.49 4,402.77 6,026.65 -2,094.60 +1,105.66 ~4,650.43 -13,132,74 1,637.29 -1,079.73 8,242.69 797.08 -13,183.87 -9,570.24 -4,883.92 -11,097,54 4,297.54 0.00 -1,648.38 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 -20,062.22 6,00 0.00 0,00 681,635.37
Interest Earned 10,333.33 12,916.67 10,833.34 6,800.00 21,000.00 10,833.33 32,500.00 13,958.34 34,133.75 19,712.50 33,750.00 32,500.00 2,906.25 1,968.75 24,081.67 17,389.17 46,666.67 45,877.17 31,250.00 62,500.00 21,875.00 9,583.33 43,130.50 37,500.00 56,250.00 21,875.00 29,166.66 57,291.67 314,250.00 21,666.67 28,333.33 33,703.13 26,041.67 23,958.33 8,333.33 5,684,062.60
Funds Annualized Yield 0.629 0.629 0.659 0.811 0.708 1.940 2.281 1.884 2.231 2.718 2.906 4.158 0,660 0.677 2.737 2.924 2,017 2.198 3.148 3,061 2.120 2.332 2.047 2.281 2.281 1.774 1.774 2.788 1,521 1.318 1.724 1.435 4.267 1.166 0.406 1.345
2020
Selected 30, Current Rate 0.620 0.620 0.650 0.800 0.800 2.600 2.600 3,350 2.350 2.850 3.375 1,950 1.500 1.500 2,000 2.750 2.800 2.753 3.750 3.750 2.625 2.300 2.100 2.250 2.250 1.750 1.750 2.750 1.500 1,300 1.700 3.750 1.250 1.150 0.400
TREASURER Earnings November - Ending Value Book 20,000,000.00 25,000,000.00 20,000,000.00 10,200,000.00 31,650,432.78 5,110,257.46 15,181,100,54 5,117,318.70 17,466,655,49 8,328,452.35 12,177,336.43 ,820.65 461.03 1,595,514.80 14,378,112,82 807.23 20,175,918.37 20,083,261.16 10,184,449.51 20,419,116.80 10,084,661.66 0.00 24,658,912.27 20,000,000.00 30,000,000,00 15,000,000.00 20,000,000.00 25,000,000.00 25,000,000.00 20,000,000.00 20,000,000.00 11,542,683,14 25,000,000.00 25,000,000.00 25,000,000.00 4,673,378,735.34
Total 2020 20,331 2,336, 7,567
COUNTY 1,
November Beginning Value ,986.86
MARICOPA Book 20,000,000.00 25,000,000.00 20,000,000.00 10,200,000.00 31,653,004,28 5,112,937,95 15,185,503.31 §,123,345.35 17,468,750.09 8,329,558.01 20,344,953.39 2,338,098.32 1,596,594,53 14,369,870.13 7,567,010.15 20,189,112.24 20,092,831.40 10,189,333.43 20,430,214.34 10,088,959.20 30,000,000,00 24,660,560.65 20,000,000.00 30,000,000.00 15,000,000.00 20,000,000.00 25,000,000.00 25,000,000.00 20,000,000.00 20,000,000.00 11,562,745,36 25,000,000.00 25,000,000.00 25,000,000.00 4,408,958,158.76
12,181
Ending Value Par 20,000,000.00 25,000,000.00 20,000,000.00 19,200,000.00 34,500,000.00 5,000,000,00 15,000,000,00 $,000,000.00 17,430,000.00 8,300,000.00 12,000,000.00 20,000,000,.00 2,325,000.00 1,575,000.00 14,449,000.00 7,588,000.00 20,000,000.00 20,000,000.00 40,000,000.00 20,000,000.00 10,000,000.00 0.00 24,646,000.00 20,000,000.00 30,000,000.00 15,000,000.00 20,000,000.00 25,000,000.00 25,000,000.00 26,000,000.00 20,000,000.00 10,785,000,00 25,000,000.00 25,000,000,00 25,000,000.00 401.09
Issuer TOYCC TOYCC TOYCC TOYCS TOYCC UNANA UNANA UNC UPS USBNK USBNK USBNK WASHSD WASHSD WESTP WESTP WESTP WESTP WFBC WFBC WFBC WFBC. WFBC WFBC WFBC WFBC WFBC WFBC WPFBC WEBC. WEBC WFBC WFBC WFBC WFBC Subtotal 10:00
Fund 4000 1000 1000 1000 1000 4000 1000 1000 1000 1000 1006 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 4000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 4000 1000 12/09/2020
#
Investment Poo! 210051 210052 210061 210068 210078 10988 11141 11036 10944 10889 10899 11126 111814 11182 10910 10923 41030 11052 10903 10921 11022 41028 11029 11097 11100 11136 11137 11147 11156 11158 11159 14175 11184 210003 210077 ~REPORT~: 10:00 -
Treasurer's 12/09/2020
Updated:
CUSIP Fund: 89236THH1 89236THH1 89236THQ1 89236THP3 89236THP3S 904764AX5 904764AX5 91324PCNO 9113128C9 90331HNL32 9T159HHVS5 90331HPF4 567031SE0 567031SF7 961214DA8 961214DS9 961214DG5 961214DB6 95000U2C6 95000U2C6 95000U2B8 95001DS5E6 949746SA0 95001D5R7 95001D5R7 95001D5Y2 95001D5Y2 95001D6F2 95001D7E4 95001D7M6 95001D7L8 95000U2C6 95001DAC4 95001DAWO0 95001DB858 Date:
Data Run
9 Page interest Earnings 729,17 1,750.00 2,479.17 482.65 583.33 1,065.98 0.00 0.00 19,211.70 52,674.19 15,058.74 18,472.49 105,417.12 5,111,389.50 INVT AP 7.3.11 7.3.11
Adjusted Portfolio (PRF_TE} Report Ver.
TE
0.00 0.00 0.00 0,00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Earnings Realized Gaint/Loss
interest
Adjusted Amortization/ Accretion 729.17 1,750.00 2,479.17 482.65 $83.33 1,065.98 0.00 0.00 4,561.03 1,522.62 3,368.49 5,130.30 14,582.44 463,507.78
Interest Earned 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 14,650.67 $1,151.57 11,690.25 13,342.19 90,834.68
5,774,897.28
Funds Annualized Yield 0.076 0.183 ° 0.129 0.076 0,061 0.067 2.734 2.480 2.555 2.642 2.562 1.347
2020
Selected 30, Current Rate 0.075 0,180 0.075 0.060 2,050 2.375 1.950 1.875
TREASURER Earnings November Ending Value 67 ,934,20 +25,718.42 “25,718.42
- Book 49,982,291 49,949,000.00 99,931,291.67 49,983,500.00 83,065,434.20 8,552,890.77 25,838,198.95 7,173,564.53 8,511,809.38 50,076,463.63 4,906,426,206.42
Total 2020 33,081
COUNTY 1,
November Beginning Value 0,00 0,00 0.00 0.00 0,00 0,00
MARICOPA Book -25,718,42 25,718.42 8,548,329.74 25,836,676.33 7,170,196,04 8,506,679.08 50,061,881.19 4,458,994,321.53
Ending Value 0.25 0.13 +25,718.42 0.00 10.41
Par 50,000,000.00 50,000,000.00° 33,096,000.00 50,000,000.00 8,576,000,00 25,845,000.00 7,194,000,00 8,539,000.00 4,884,140,222.82
Issuer USTR XON Subtotail FHDN USTR Subtotal NTMM Subtotat BONYM FFCB PFIZER RDSALN Subtotal Total 10:00
Fund 534BP S34BP 534DE $34DE 534DS Ops 534MO 534MO $34MO 534MO 12/09/2020
&
Investment# Proceeds Service
210099 210100 Depository 210101 210102 10425 Maintenance 10906 10905 10907 10908 ~REPORT~: 10:00
Bond Debt -
MIHS MIHS MIHS MIHS Updated: 12/09/2020
CUSIP Fund: 9127962Y4 30229ATP4 Fund: 313385HF6 8127963HO Fund: 665279873 Fund: O6406FAB9 3133EKGY6 717081DX8 822582BS0 Date:
Data Run
County Interest Earnings $,002,427.23 2,479.17 1,065.98 0.00 105,417.12 5,111,389.50 INVT AP 7.3.11 7.3.11
Maricopa Adjusted Portfolio (PRF_TE) Report Ver.
TE
0.00 0.00 0.00 0.00 0.00
Earnings Realized Gainl/Loss
Interest
Adjusted Amortization/ Accretion -681,635.37 2,479.17 1,065,398 0.00 14,582.44 -663,507.78
interest Earned 5,684,062.60 0.00 0.00 0.00 90,834.68 .28 5,774,897
Funds
Selected 2020 Annualized Yield 1.345 0.129 0,067 2.562 1.347
30,
Issuer Current Rate
- November
TREASURER Earnings Fund - Ending Book Value 4,673,378,735.34 99,931,291.67 83,065,434.20 -25,718.42 50,076,463.63 4,906,426,206.42
Total by 2020
COUNTY Sorted 1,
Beginning Value 0.00 0.00 +25,718.42
November Book 4,408,958,158.76 §0,061,881.19 4,458,994,321.53
MARICOPA
Ending Value 401.09 0.25 0.13 0.00 10.41
Par 4,884,140,222.82
Issuer Subtotal Subtotal Subtotal Subtotal! Subtotal Totai 09:58
«SymPro Fund Ops 12/09/2020
&
Investment# Pool Proceeds Service
Bond Depository Debt Maintenance ~REPORT~: 09:58 -
aR SHH Treasurer's MIHS MIHS MIHS MIHS Updated: 12/09/2020
+=, USIP Fund: und: und: Fund: Fund: Data Date:
Run