TREASURERS COLLECTIONS AND INVESTMENT SUMMARY.PDF
Extracted text (via pymupdf_layout)
38738 characters
Royce T. Flora, Treasurer 301 West Jefferson St., Rm. 100 Phoenix, Arizona 85003 Maricopa County Phone: (602) 506-8511 Fax: (602) 506-1102 Treasurer http://treasurer.maricopa.gov DATE: May 05, 2017 TO: Denny Barney, Chairman Steve Chucri, Supervisor, District 2 Bill Gates, Supervisor, District 3 Clint Hickman, Supervisor, District 4 Steve Gallardo, Supervisor, District 5 SUBJECT: Treasurer's Collections and Investment Summary for April 2017 Secured property tax collections during the month of April equaled $13,880,138 and increased the 2016 year to date collections to $2,983,688,645 or 64.46% of the adjusted 2016 levy of $4,629,035,457. The chart below reflects the 2016 collected and uncollected levy amount and corresponding percentages for the 2016 property tax year. APRIL 2017 Uncollected Levy $1,645,346,812 36% Collected Levy $2,983,688,645 64% The County's General Fund Balance totaled $280,021,412.56 effective April 31, 2017. Warrants outstanding of $4,120,765.92 will post against the fund balances when presented. The $21,473,929, unencumbered balance, of the County Municipal Line of Credit and the $13,526,071 Workers Compensation Liability Letter of Credit remain unused. Slit!pitted under oath, Russell K. Pearce Chief Deputy Treasurer STATE OF ARIZONA ) ss. COUNTY OF MARICOPA ) This instrument was acknowledged before me this 5th day of May 2017, 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. 6_„)—el-f,x4-e/L j 00/7 Notary Public My Commission Expires •glab.earergeltamkg KAREN D, SMITH ) Notary Public - Arizona Maricopa County My Comm. Expires Dec 15, 2017 657 28-APR-2017 PAGE; t ao OFFICE 30-APR-2017 I 1 Li 684 35 105 1,327 517 47 22 166 116 282 37 44 143 204 347 1,206 810 2,016 148 137 285 121 1 273 395 1 56 57 19 95 114 12 136 148 634 634 12,082 14,819 - FUND TREASURER'S by DISTRICT COUNT Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: - WARRANTS AMOUNT 6,772.91 303,752.69 26,322.15 21,124.79 4,073,3113.98 246,916.31 66,585.40 13,649.40 4,758,442.63 82,304.94 834,990.94 917,295.88 4,751.03 86,994.60 91,745.63 79,865,08 664,764.63 744,629.71 3,533,756.82 2,633,074.90 6,166,831.72 114,956.43 452,298.35 567,254.78 58,800.11 600.00 3,190,899.59 3,250,299.70 22.89 147,235.63 147,258.52 9,307.16 331,497.35 340,804.51 5,154.45 237,997.76 243,152.21 1,227,333.58 1,227,333.58 COUNTY WARRANT OUTSTANDING MARICOPA = = = = = - = = - = = = = = = = = = - = = = = = = = = = = = = = = = = = - = = NUMBER Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total WARRANT Fund Fund Fund Fund Fund Fund Fund Fund District Fund Fund District Fund Fund District Fund Fund District Fund Fund District Fund Fund District Fund Fund Fund District Fund Fund District Fund Fund District Fund Fund District Fund District OTSTND_WT_FUND DISTRICT 000 000 000 000 000 000 000 000 000 001 001 001 002 002 002 003 003 003 004 004 004 DOS 005 DOS 006 006 006 006 007 007 007 008 008 008 009 009 009 011 011 WTR ID: FUND 066 714 766 767 768 781 950 962 030 040 030 040 030 040 030 040 030 040 030 035 040 030 040 030 040 030 040 040 PROGRAM ' 2 02-MAY-2017 PAGE: Closing Balance 258,317.80 123,743.70 172,072.60 126,166.49 80,240.72 142,581.06 1,445,150.04 10,706,434.75 794,220.67 50,119.45- 840,334.26 10,563.15 18,055.62 379,725.50 1,550,240.39 1..010 5,561,752.68 226,536.44 816,141.35 1,504,558..05 246,105.70 235,551.31 4,420,475.50 2,458.45 17,796,558.65 744,316.97- 579062.47 7,420,287.06 2,834,356.09 44,462,240.94 280,021,412.56 260,021,412.56 454,754.72- Disbursements 251.98 1,314.23- 31,254,046.70 504.00- 383.20 148,800.00 24,336,186.01 2,651.21- 2,691.21 20,652.88 16,186,329.22 194,651.14- 1,425,117.84 73,246,561.71 1,097,980.06 1,097,980.06 To 4,039.93' 6,609.84 5,090.13 2,185.64 3,902.60 153,402.14 53,319.21 469.06 10.67 4,429.04 31,200.69 1,409,923,12 22,974,649,99 907.54 812,940.46 6,671.31 150.00 406,470.23' 16,157.17 124,719,697.11 150,437,002.02 560,035,551.94 660,035,951.94 2,056,408.41 2017 Transfer OFFICE S APR, From 2,671.65 366,022.37 18,045.61 155.29 3,285,95 66.00 2,812,209.92 32,067.51 4,211,388,922.54 13,239,081.73 3,444.53 406,470.23 29,236.33 24,963.64 812,940.46 47,796.70 124,620,517.90 4,353,807,233.91 918,859,959.94 916,559,559.34 2,023,987.63 Ending TREASURER' Month the for Income Distribution 326,277.80 11,642,52 15,498.92- 6,752.93- 8,685.30 3,514.10- 1,366,375.20 5,760,539..45 31,632,069.07 952,264.93- 50,432.24- 317,347.65 1,791.19 496,367.34- 183.20 107,690.00 1.00 11.64 24,307,517,67 4,168,083,936.16 14,743,639.76 8,445.64 290,594.31- 4,381,545.14 27,852.29 15,658,184.65 986,486,22 671,586.64- 3,931,360.63 4,281,657,004.36 485,676,478.94 489,676,478.94 COUNTY Summary Date to MARIOOPA Year Opening Balance 69,960.00- 108,061.25 181,261.68 127,849.29 69,469.78 142,192.56 79,126.82 4,793,550.78 1,711,212.20 522,986.61 8,761.10 512,777.07 389,710,61 140,311.27 8,353,947.96 287,292.29 1,143,626.53 240,197.05 89,675.09 64,146.59 5,460.04 18,349,516.86 1,224,313.06- 384,202.33 8,123,505.45 278,934.09 39,422,120,08 50,266,921.66 50,266,921.66 527,175.50- Treasurer's , SERVICE 2149 REFUNDS SALES UNKNOWN SCHOOL CC VALLEY SO JO CC MEADOWS PROCESSING RESOLUTIONS HOLDING MB FUND INVESTMENT HOLD COLLECTIONS INCOME NON-DELIVERABLE • TRUSTEE OR APPR BE COMPANIES Description CT JUVENILE SERVICES PENDERGAST NORTH TEMPE WEST RIDGE DESERT dC HIGHLAND COUNTRY REVENUE HOLDING DEBITS/CREDITS HOLDING PENDING ASSIGN WITHHOLDING INFORMATION IMPOUNDS HOLDING CONVERSION - ASSISTANCE ASSISTANCE HOLDING TAX INTEREST ACT FOR HOLDING HOLDING REFUNDING FROM WIRES TO MONEY CASHIER'S MORTGAGE CHARGE FUNDS WAREHOUSE ...ETD ACCT ENVIR ACCT ACCT ACCOUNT ACCOUNT ACCT ACCT ACCOUNT ACCT CLEARING CLEARING REFUND TAX CASHIER'S RESOLUTION LITIGATION AND SUBTAX INTEREST TAXPAYER RESOLUTION PENALTY COURSE HOLDING ELDERLY ELDERLY REDEMPTION UNDISTRIBUTED UNDISTRIBUTED GRAZING TAYLOR FUND TRUST CHECK PROBLEM TAX CURRENT FEE RECORDER PROCEEDS EXCESS UNIDENTIFIED FD HLD SUSPENSE SUSPENSE SERVICE SUSPENSE-PREPAYMENTS SUSPENSE FUNDS TREAS GENERAL GENERAL COUNTY SHERIFF ?UM:LEAN DEP DES DEP DEP DES DES DES DEP DEP DES SACK IRS UPPS CIVIL GOLF GPLET TEMP SANK ACC ID: AccOunt Number 30-025-164 30-025-1E15 30-025-196 30-025-167 30-025-189 30-025-189 30-025-190 30-025-191 30-025-199 1 - Total 30-026-000 30-027-000 30-028-000 30-033-000 30-034-000 30-035-000 30-036.-000 30-041-000 30-042-000 30-043-000 30-044-000 30-045-000 30-049-003 30-049-000 30-050-000 30-059-000 30-060-000 30-061-000 30-062-000 30-063-000 30-064-000 30-066-000 30-077-000 3D-066-000 30-090-,000 30-091-000 30-092-000 30-093-000 10-094-000 30-099-000 1 - Total 30-100-000 1 - Total 31-120-000 Program 1 02-MAY-2017 PAGE: BALANCE 197,750.52- 13,311,242.59- 3,064,671.12 871,442.01- 9,255,337.65- 28,448,884.13- 25,511,026.71- 22,886,052.74- 35,071,571.00- 28,750,037.92- 8,107,359.56 14,418,410.69- 17,539,729.90- 6,348,944.84- 950,427.40- 7,916,214.08- 21,526,144.42- 7,182,377.74- 25,772,503.22- 28,111,508.34- 12,928,887.66- 6,576,315.56- 22,905,048.43- 18,055,558.20- 17,272,723.82- 6,557,551.22- 6,812,702.12- 5,929,894.62- 2,691,654.20- 2,664,351.52- 5,472,248.17- 5,826,677.39- 2,953,558.51- 1,719,922.67- 433,497.42- 1,422,511.95- 2,220,992.14- 405,461,780.82- ENDING OFFICE .00 275.88- 188.03- 188.74- 172.30- 167.72- 173.79- 159.41- 167.67- .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 1,493.54- S 2017 ADJUSTMENTS APR TREASURER FOR ACTIVITY .00 1,186.17 605.61 596.69 330.45 247.49 225.53 230.71 29.72 14.67 8.17 14.99 1,117.02 26.15 23.09 24.39 779.08 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 5,459.93 COLLECTIONS AND COUNTY LEVY UNSECURED BALANCE 197,750.52- 13,309,880.54- 3,065,464.76 870,656.58- 9,254,1234.90- 28,448,468.92- 25,510,627.39- 22,885,662.62- 25,071,373.61- 28,750,023.25- 8,107,367.72 14,418,395.70- 17,538,622.88- 6,348,918.69- 950,404.31- 7,916,189.69- 21,535,365.34- 7,182,277.74- 25,772,503.22- 28,111,508.34- 12,928,887.66- 6,576,315.56- 22,905,048.43- 18,055,558.20- 17,272,723.82- 6,557,551.22- 6,812,702.12- 5,929,894.62- 2,691,654.20- 2,664,351.52- 5,472,248.17- 5,836,677.39- 2,953,558.51- 1,719,922.67- 433,497.42- 1,422,511.95- 2,220,992.14- 405,454,827.35- MARICOPA. BEGINNING LEVY .00 .00 LEVY_RPT_MONTH_SUM 16,903,615.38 19,230,296.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 112,929,972.42 96,811,185.54 88,991,262.81 76,956,283.43 50,507,999.56 52,570,953.57 73,434,045.21 37,836,109.79 36,682,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,622,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 1 02-MAY-2017 PAGE: BALANCE 535,326,599.46 3,165,784.78 1,975,806.10 1,714,593.57 1,019,137,30- 20,926,802.98 42,815,232.64- 87,264,123.97 26,212,628.95 554,640.88- 688,162.90- 584,037.28 633,380.45 732,243.32- 1,193,945.51- 738,556.49 571,408.07- 679,575.16- 762,845.98- 651,506.18- 78,784.46- 758,266.74- 1,128,169.02- 1,190,791.47 3,577,213.60 2,207,553.16 7,952,626.39 8,122,159.39 3,284,780.26- 22,363.14 17,523.14 86,095.02 21,166.00 28,887.27 11,576.64 13,532.33 11,278.23 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 646,984,181.89 ENDING OFFICE 182,202.95- 7,156.10- 7,223.05- 8,766.65- 7,514.90- 4,346.07- 1,940.01- 545.70- 607.91- 146.78- .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 7,241,398.79- . ADJUSTMENTS 3,033,506.85- 2,508,448.34- 1,478,883.48- 2017 APR TREASURER'S FOR ACTIVITY 166,845.90- 554.50- 2,480.01 2,883.51 1,039.72 874.85 2,589.96 865.94 831.50 775.90 .00 269.97 527.94 .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 1,120,866,843.34 2,412,010.76- 1,459,885.26- 1,116,840,686.23 AND COUNTY LEVY SECURED BALANCE 1,659,226,949.65 3,262,222.36 1,994,804.32 1,729,950.62 1,012,535.70- 20,936,615.04 42,1303,583.48- 87,272,678.59 26,217,849.88 550,110.91- 686,751.26- 585,476.69 634,303.13 732,243.32- 1,193,675.54- 739,084.43 571,408.07- 679,575.16- 762,845.98- 651,506.18- 713,784.46- 758,266.74- 1,128,169.02- 1,190,791.47 3,577,212.60 2,207,553.16 7,952,626.39 8,122,159.29 3,284,780.26- 22,363.14 17,523.14 86,093.02 21,166.00 28,887.27 11,576.64 13,532.33 11,278.23 15,972.66 17,517.30 12,427.08 12,599.20 10,864.89 8,954.20 6,216.48. 5,885.92 4,111.30 1,998.26 922.38 331.83 1,771,066,266.91 MARICOPA BEGINNING LEVY LEVY_RPT_MONTH_SUM 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,224,573.96 2,108,718,697.02 1,939,463,904.72 1,800,100,859.36 1,631,715,958.46 1,683,783,514.12 1,507,769,663.58 1,476,046,063.04 1,477,426,592.42 1,485,482,338.84 1,445,084,095.32 1,306,266,536.54 1,181,440,841.12 1,049,888,299.56 870,295,854.72 721,770,831.08 600,944,379.84 530,525,148.42 451,214,378.40 402,942,488.72 373,230,675.34 382,783,606.36 365,594,731.04 360,443,065.88 332,481,242.68 294,189,512.68 251,690,646.52 224,585,828.94 191,805,552.44 165,623,012.50 138,694,626.82 126,692,073.74 116,414,184.58 90,867,625,621.32 APP ID: YEAR 2016 2015 2014 2013 2012 2011 2010 2009 2008 2007 2006 2005 2004 2003 2002 2001 2000 1999 1998 1997 1996 1995 1994 1993 1992 1991 1990 1989 1988 1987 1986 1985 1984 1982 1982 1951 1980 1979 1978 1977 1976 1975 1974 1973 1972 1971 1970 1969 1968 TOTAL PROGRAM Flora DAYS. YEARS. T. Treasurer 0.79 0.82 0.82 1,39 0.15 1.47 1.01 0.43 0.86 0.22 0.79 in in Royce treasurer.maricopa.gov DuRA-ndr) displayed displayed WAM 388 409 409 585 54 814 376 163 329 82 388 (WAM) Duration Weighted-Average-Maturity 0.96% 0.97% 0.97% 1.09% 0.70% 1.27% 0.93% 0.93% 1.16% 0.82% 0.96% 0.87% 1.00% 1.39% 35-323 Index Index Index ARS 112(1;3 $4,004,335,116 $3,656,806:532 $3,656,806,532 $468,981,055 $1,716,100,536 $1,306,772,793 $164,962,148 $347,528,584 $119,468,934 $228,059,650 $4,004,335,116 Agency Active SCHOOL DISTRICT 9% Active USGN 4% Treasury Treasury TO US US US Treasurer PURSUANT BENCHMARKS Month Year Year Allocation Report $4,006,576,487 $3,658,163,749 $3,658,163,749 $469,969,668 :713,402,562 $1,309:586,831 $165,204,688 $348,412,738 $120,353,088 $228,059,650 006,576,487 1-3 0-1 1-3 Lynch PRINCIPAL Lynch Lynch County RESTRICTED $1 $4, Merrill Merrill Issuer 1 Portfolio Merrill BofA :000 BofA BofA INVESTMENTS PAR $4,002,823,000 $3:663,108,000 $3,663,108,000 $470,163,000 $1,718,145 $1,309,800,000 $165,000,000 $339,715,000 $112,215,000 $227,500,000 $4,002,823,000 Amoun Active GOVT AGENCY 87% Maricopa Face af um ALL TOTAL 100.00% 91.51% 91.51% 11.75% 42.92% 32.72% 4.12% 8.49% 2.80% 5.68% 100.00% OF 04128/2017 % Count 187 140 140 23 53 58 6 47 37 10 187 Count 7 7 2 1 1 3 80 74 26 11 10 27 6 6 47 47 53 53 8 5 33 7 187 of as Active Active cost. Disclosures BANK BANK BANK BANK NT NT NT amortized BONDS TANS CREDIT LOAN CREDIT LOAN NOTE DISCOUNT DISCOUNT DISCOUNT are Risk NOTES N/B values Portfolio INCOME TREASURY SCHOOL SCHOOL MAE FARM HOME MAC MAE FARM HOME MAC DISTRICT DISCOUNT CRD LN MAC fair applied. Investment Available-for-Sale BONDS DISCOUNT NOTES US Hold-to-Maturity COUNTY COUNTY AGENCY FANNIE FEDERAL FEDERAL FREDDIE AGENCY FANNIE FEDERAL FEDERAL FREDDIE TREASURY rated) AGENCY FANNIE FARM HOME FREDDIE TANS amortization 40 FIXED Total Ratings GOVT GOVT USGN US (not SCHOOL GOVT FED FED Total BLOOMBERG and GASB Status POOL Grand Status Credit AA+ Aaa NR P-1 Grand Bonds Straight-line Source.' School Flora T. Treasurer DAYS. in YEARS. in Royce treasurer.maricopa.gov displayed displayed 35-323 GAIN/(LOSS) ($1,357,216) ($1,357,216) ($1,357,216) ($988,612) $2,697,974 ($2,814,039) ($252,539) $0 $0 $0 ($1,367,216) ACCRUAL $17,318,064 $8,842,146 $8,842,146 $1,160,107 $2,894,137 $4,255,215 $532,686 $8,475,918 $7,018,800 $1,457,118 $17,318,064 (WAM) Duration & ARS INTEREST Weighted-Average-Maturity TO UNREALIZED PURSUANT $0 $0 $0 RESTRICTED $3,666,806,532 $3,656,806,532 $3,656,806,532 $468,981,055 $1,716,100,536 $1,306,772,793 $164,952,148 $3,656,806,532 AMORTIZATION $4,005,603,208 $3,658,074,625 $3,658,074,625 $469,990,018 61,713,402,562 $1,309,558,919 $165,123,126 $347,528,584 $119,468,934 $228,059,650 $4,005,603,208 Treasurer INVESTMENTS ALL $4,004,335,116 $3,656,806,532 $3,656,806,532 $468,981,055 $1,716,100,536 $1,306,772,793 $164,952,148 $347,528,584 $119,468,934 $228,059,650 $4,004,335,116 PRINCIPAL $4,006,576,487 $3,658,163,749 $3,658,163,749 $469,969,668 $1,713,402,562 $1,309,586,831 $165,204,688 $348,412,738 $120,353,088 $228,059,650 $4,006,576,487 Report County Portfolio 04/28/2017 PRINCIPAL $4,006,576,487 $3,658,163,749 $3,658,163,749 $469,969,668 $1,713,402,562 $1,309,586,831 $165,204,688 $348,412,738 $120,353,088 $228,059,650 $4,006,576,487 PAR $4,002,823,000 $3,663,108,000 $3,663,108,000 $470,163,000 $1,718,145,000 $1,309,800,000 $165,000,000 $339,715,000 $112,215,000 $227,500,000 $4,002,823,000 2 Maricopa of as Reporting COUNT 187 140 140 23 53 58 6 47 37 10 187 COUNT 187 140 140 23 53 58 6 47 37 10 187 & Active Active Accounting BONDS TANS BONDS TANS investment INCOME NOTES TREASURY SCHOOL SCHOOL INCOME NOTES TREASURY SCHOOL SCHOOL cost. 31 Available-for-Sale FIXED BONDS DISCOUNT NOTES US Hold-to-Maturity COUNTY COUNTY Total Available-for-Sale FIXED BONDS DISCOUNT NOTES US Hold-to-Maturity COUNTY COUNTY Total amortized Statement Status Portfolio POOL Grand Status Portfolio POOL Grand are values applied. GASB fair TANS BLOOMBERG and amortization Source: Bonds School Straight-line Flora T. Treasurer ACCRUAL $17,318,063.91 $8,842,145.72 $8,842,145.72 $1,160,107.19 $667,250.94 $53,472.22 $73,100.00 $80,041.67 $68,110.83 $90,416.67 $36,000.00 $83,019.44 $41,506.78 $109,236.11 $27,000.00 $5,347.22 $492,856.25 $71,783.33 $88,666.67 $62,500.00 $86,111.11 $49,170.14 $10,625.00 $1,222.22 $80,000.00 $42,777.78 $0.00 $2,894,137.02 $944,248.89 $192,868.12 $557,691.92 $94,860.50 $79,626.58 $19,201.78 $0.00 $901,370.25 $165,790.32 $585,905.87 $149,674.06 $467,059/7 $94,263.63 $23,762.42 $49,963.42 $32,565.94 DAYS. in YEARS. in Royce treasurer.maricopa.gov INTEREST displayed displayed (WAM) Duration LOSS ($1,357,216.39) ($1,357,216.39) ($988,612.44) ($926,402.44) ($82,250.00) ($38,100.00) ($123,750.00) ($115,309.80) ($149,750.00) ($111,400.00) ($239,980.00) ($31,767.39) ($31.855.25) $5,760.00 ($8,000.00) (S62,210.00) $21,900.00 $20,600.00 ($1.050.00) $17,600.00 ($4,760.00) ($86,400.00) ($86,000.00) ($1,400.00) $17,800.00 $39,500.00 $2,697,973.81 $869,992.22 $188,610.00 $494,450.00 $90,827.78 $74,450.00 $21,311.11 $343.33 $832,657.28 $161,689.50 $535,110.00 $135,857.78 $457,356.95 $84,454.44 $19,743.06 $49,162.50 $31,313.33 Weighted-Average-Maturity GAIN UNREALIZED $3,656,806,532.49 $3,656,806,532.49 $3,656,806,532.49 $468,981,055.31 $272,181,185.31 $24,908,250.00 $29,961,900.00 $24,876,250.00 $21,958,122.70 $24,850,250.00 $44,892,000.00 $25,757,420.00 $13,041,232.61 $24,943,500.00 $12,005,760.00 $24,986,500.00 $196,799,870.00 $29,990,700.00 $20,020,600.00 $14,998,950.00 $20,010,600.00 $16,954,270.00 $19,891,600.00 $19,914,000.00 $19,998,600.00 $10,017,800.00 $25,002,750.00 $1,716,100,536.20 $329,659,575.56 $29,988,726.67 $134,825,175.00 $39,991,627.78 $44,982,325.00 $39,962,933.33 $39,908,78718 $186,774,036.17 $26,992,429.50 $119,837,560.00 $39,944,046.67 $959,800,299.47 $19,972,926.67 $24,987,048.61 $49,970,600.00 $34,991,530.00 35-323 MARKET Treasurer ARS TO Report PURSUANT PRINCIPAL $4,006,576,486.64 $3,658,163,748.89 $3,658,163,748.89 $469,969,667.75 $273,107,587.75 $24,990,500.00 $30,000,000.00 $25,000,000.00 $22,073,432.50 $25,000,000.00 $45,003,400.00 $25,997,400.00 $13,073,000.00 $24,975,355.25 $12,000,000.00 $24,994,500.00 $196,862,080.00 $29,968,800.00 $20,000,000.00 $15,000,000.00 $19,993,000.00 $16,959,030.00 $19,978,000.00 $20,000,000.00 $20,000,000.00 $10,000,000.00 $24,963,250.00 $1,713,402,562.39 $328,789,583.33 $29,800,116.67 $134,330,725.00 $39,900,800.00 $44,907,875.00 $39,941,622.22 $39,908,444.44 $185,941,378.89 $26,830,740.00 $119,302,450.00 $39,808,188.89 $959,342,942.53 $19,888,472.22 $24,967,305.56 $49,921,437.50 $34,960,216.67 County Portfolio RESTRICTED Maricopa $4,002,823,000.00 $3,663,108,000.00 $3,663,108,000.00 $470,163,000.00 $273,163,000.00 $25,000,000.00 $30,000,000.00 $25,000,000.00 $22,090,000.00 $25,000,000.00 $45,000,000.00 $26,000,000.00 $13,073,000.00 $25,000,000.00 $12,000,000.00 $25,000,000.00 $197,000,000.00 $30,000,000.00 $20,000,000.00 $15,000,000.00 $20,000,000.00 $17,000,000.00 $20,000,000.00 $20,000,000.00 $20,000,000.00 $10,000,000.00 $25,000,000.00 $1,718,145,000.00 $330,000,000.00 $30,000,000.00 $135,000,000.00 $40,000,000.00 $45,000,000.00 $40,000,000.00 $40,000,000.00 $187,000,000.00 $27,000,000.00 $120,000,000.00 $40,000,000.00 $961,145,000.00 $20,000,000.00 $25,000,000.00 $50,000,000.00 $35,000,000.00 INVESTMENTS PAR ALL COUNT 187 140 140 23 12 1 1 1 1 1 2 1 1 1 1 1 11 1 1 1 1 1 1 2 1 1 1 53 1 3 1 1 1 1 5 1 3 1 33 1 1 2 1 Active 04/28/2017 BANK BANK NOTE NT DISCOUNT NT cost. amortized of CREDIT 07/30/2018 08/02/2018 07/05/2019 01/0712019 01/13/2020 03/22/2018 06/27/2019 01/28/2019 12/05/2018 03/13/2020 05/21/2018 LOAN 06/30/2017 12/28/2018 12/28/2018 05/23/2018 06/29/2018 10/11/2019 04126/2019 05/18/2018 0713012020 07/26/2019 DISCOUNT 05/17/2017 06/30/2017 05/09/2017 005/18/2017 06/15/2017 08/09/2017 CRD 05/12/2017 06/29/2017 07/03/2017 DISCOUNT 06/29/2017 05/23/2017 05/26/2017 05/10/2017 are as Listing INCOME FARM FEDERAL 0.875 FFCB 1.02 FFCB 1.02 FFCB 1 FFCB 1.24 FFCB 0.8 FFCB 0.95 FFCB 1.27 FFCB 1.1 FFCB 1.8 FFCB 1.1 FFCB HOME FEDERAL 0.73 FHLB 1.33 FHLB 1.25 FHLB 1 FHLB 0.875 FHLB 1.125 FHLB 1.1 FHLB 0.9 FHLB 1.75 FHLB 1.375 FHLB NOTES FANNIE 0 FNMDN 0 FNMON 0 FNMDN FNMDN 0 FNMDN 0 FNMDN FARM 0 FFCBDN 0 FFCBDN 0 FFCBDN LN HOME 0 FHLBDN 0 FHLBDN 0 FHLBDN 0 FHLBDN values fair TANS applied. Detail Available-for-Sale FIXED BONDS DISCOUNT FED FED BLOOMBERG and amortization Portfolio Status Labels Row POOL Source: Bonds School Straight-line Flora T. Treasurer ACCRUAL $24,873.63 $15,551.74 $24,834.18 $17,222.15 $32,802.28 $16,288.14 $18,886.12 $8,004.33 $13,032.77 $22,371.58 $9,660.30 $10,553.83 $9,901.29 $6,010.64 $8,226.75 $7,038.83 $5,621.85 $6,479.35 $1,919.11 $2,339.46 $1,679.62 $1,431.98 $959.81 $814.64 $0.00 $0.00 $0.00 $581,458.11 $128,980.36 $112,388.57 $117,083.94 $112,559.17 $88,529.64 $14,610.65 $7,305.78 $4,255,215.28 $2,091,227.08 $1,215.28 $139,843.75 $78,300.00 $214,375.00 $105,000.00 $80,000.00 $107,350.00 $77,291.67 DAYS. in YEARS. in Royce treasurer.maricopa.gov INTEREST displayed displayed (WAM) Duration LOSS $24,287.50 $15,092.50 $26,076.39 $16,054.44 $34,206.67 $15,943.33 $19,468.75 $7,650.51 $12,472.22 $23,686.11 $9,391.69 $11,326.50 $9,405.83 $5,772.92 $11,500.00 $9,351.11 $4,850.00 $6,222,22 $1,795.56 $2,600.69 $719.44 $786.67 $3,340.00 $1,093.75 $113.75 ($0.00) (8524.94) $537,967.36 $119,875.00 $103,304.44 $107,121.25 $102,920.00 $82,794.44 $14,621.11 $7,331.11 ($2,814,038.70) ($2,267,088.95) $116,250.00 ($47,750.00) $14,700.00 ($50,050.00) ($25,800.00) ($34,600.00) ($141,000.00) ($146.250.00) Weighted-Average-Maturity GAIN UNREALIZED $24,990,787.50 $14,989,467.50 $24,975,520.83 $19,986,471.11 $39,968,756.67 $19,976,510.00 $34,956,250.00 $14,526,914.23 $24,971,833.33 $46,956,583.75 $19,968,188.89 $26,974,366.50 $29,961,305.83 $24,971,328.47 $39,942,200.00 $34,593,444.80 $29,942,600.00 $34,936,066.67 $19,960,240.00 $34,953,445.14 $34,919,733.33 $29,936,661.67 $39,909,840.00 $34,940,135.42 $44,902,175.00 $39,930,755.56 $42,836,612.00 $239,866,625.00 $44,977,375.00 $39,978,304.44 $44,975,565.00 $44,974,170.00 $34,984,891.67 $19,984,610.00 $9,991,708.89 $1,306,772,792.55 $649,402,992.30 $25,004,500.00 $24,952,250.00 $14,999,700.00 $34,949,950.00 $19,974,200.00 $19,950,200.00 $29,859,000.00 $24,853,750.00 35-323 MARKET Treasurer 4 ARS Report TO PURSUANT $24,966,500.00 $14,974,375.00 $24,949,444.44 $19,970,416.67 $39,934,550.00 $19,960,566.67 $34,936,781.25 $14,519,263.72 $24,959,361.11 $46,932,897.64 $19,958,797.20 $26,963,040.00 $29,951,900.00 $24,965,555.56 $39,930,700.00 $34,584,093.69 $29,937,750.00 $34,929,844.44 $19,958,444.44 $34,950,844.45 $34,919,013.89 $29,935,875.00 $39,906,500.00 $34,939,041.67 $44,902,061.25 $39,930,755.56 $42,837,136.94 $239,328,657.64 $44,857,500.00 $39,875,000.00 $44,868,443.75 $44,871,250.00 $34,902,097.22 $19,969,988.89 $9,984,377.78 $1,309,586,831.25 $651,670,081.25 $24,888,250.00 $25,000,000.00 $14,985,000.00 $35,000,000.00 $20,000,000.00 $19,984,800.00 $30,000,000.00 $25,000,000.00 County PRINCIPAL 2 Portfolio RESTRICTED Maricopa $25,000,000.00 $15,000,000.00 $25,000,000.00 $20,000,000.00 $40,000,000.00 $20,000,000.00 $35,000,000.00 $14,547,000.00 $25,000,000.00 $47,000,000.00 $20,000,000.00 $27,000,000.00 $30,000,000.00 $25,000,000.00 $40,000,000.00 $34,648,000.00 $30,000,000.00 $35,000,000.00 $20,000,000.00 $35,000,000.00 $35,000,000.00 $30,000,000.00 $40,000,000.00 $35,000,000.00 $45,000,000.00 $40,000,000.00 $42,950,000.00 $240,000,000.00 $45,000,000.00 $40,000,000.00 $45,000,000.00 $45,000,000.00 $35,000,000.00 $20,000,000.00 $10,000,000.00 $1,309,800,000.00 $651,875,000.00 $25,000,000.00 $25,000,000.00 $15,000,000.00 $35,000,000.00 $20,000,000.00 $20,000,000.00 $30,000,000.00 $25,000,000.00 INVESTMENTS PAR ALL COUNT 1 1 1 1 1 1 1 1 1 2 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 7 1 1 1 1 1 1 1 58 28 1 1 1 1 1 1 1 1 Active NT cost. 04/28/2017 of 0511612017 0513112017 0611412017 05/30/2017 06/06/2017 0612112017 06/27/2017 06/3012017 06/19/2017 06/12/2017 07/07/2017 06/13/2017 06/26/2017 006/20/2017 07/05/2017 007/11/2017 07/19/2017 07/17/2017 07/21/2017 06/28/2017 08/02/2017 07/26/2017 08/04/2017 07/12/2017 07/28/2017 007/13/2017 008/16/2017 DISCOUNT 005/23/2017 05/24/2017 05/25/2017 005/26/2017 05/19/2017 06/05/2017 06/08/2017 10/26/2017 10/29/2018 11/16/2018 05/03/2019 06/13/2019 06/28/2019 07/05/2019 07/12/2019 amortized are as Listing 0 FHLBDN 0 FHLBDN 0 FHLBDN 0 FHLBDN 0 FHLBDN 0 FHLBDN 0 FHLBDN 0 FHLBDN 0 FHLBDN 0 FHLBDN 0 FHLBDN 0 FHLBDN 0 FHLBDN FHLBDN 0 FHLBDN FHLBDN 0 FHLBDN 0 FHLBDN 0 FHLBDN 0 FHLBDN 0 FHLBDN 0 FHLBDN 0 FHLBDN 0 FHLBDN 0 FHLBDN FHLBDN FHLBDN MAC FREDDIE FREDN 0 FREDN 0 FREDN FREDN 0 FREDN 0 FREDN 0 FREDN MAE 0.875 FNMA 1.125 FNMA 1.16 FNMA 1.26 FNMA 1.4 FNMA 1.2 FNMA 1.14 FNMA 1.05 FNMA values fair TANS applied. Detail NOTES FANNIE BLOOMBERG and amortization Portfolio Status Labels Row Source: School Bonds Straight-line Flora T. Treasurer ACCRUAL $63,888.89 $57,500.00 $66,500.00 $72,000.00 $45,138.89 $34,638.89 $8,402.78 $11,275.00 $88,472.22 $1,170.83 $0.00 $18,384.72 $81,250.00 $67,500.00 $154,166.67 $100,208.33 $115,694.44 $122,743.06 $128,916.67 $50,000.00 $2,163,988.19 $791.67 $119,879.86 $70,833.33 $69,416.67 $218,777.78 $109,375.00 $139,027.78 $91,758.33 $66,666.67 $20,555.56 $1,458.33 $200,200.00 $136,400.00 $130,666.67 $215,222.22 $141,562.50 $39,722.22 $63,750.00 $35,555.56 $30,833.33 $39,312.50 $32,291.67 $41,083.33 $13,222.22 DAYS. in YEARS. in Royce treasurer.maricopa.gov INTEREST displayed displayed (WAM) Duration LOSS ($207.750.00) ($107,000.00) ($102,400.00) ($162,900.00) ($67,400.00) ($120,800.00) ($133,750.00) ($156,900.00) ($173,750.00) ($286,500.00) ($80,303.55) ($36,685.40) ($233,500.00) ($169,600.00) $11,250.00 ($13.500.00) $26,000.00 $23,750.00 $26,400.00 $12,750.00 ($546.949.75) $8,100.00 ($44,684.75) ($1.500.00) $11,200.00 $11,600.00 ($25,500.00) $35,750.00 ($38,100.00) ($4,500.00) ($51,800.00) $500.00 ($244,500.00) ($123,000.00) ($185,400.00) ($126,600.00) $11,500.00 $17,700.00 ($21,300.00) $10,000.00 $13,100.00 $27,000.00 $26,750.00 $78,285.00 $11,600.00 Weighted-Average-Maturity GAIN UNREALIZED $24,792,250.00 $19,893,000.00 $19,897,600.00 $29,837,100.00 $19,932,600.00 $19,879,200.00 $24,812,500.00 $29,843,100.00 $24,826,250.00 $29,713,500.00 $17,880,205.20 $18,868,587.10 $24,766,500.00 $19,830,400.00 $25,011,250.00 $14,986,500.00 $20,026,000.00 $25,023,750.00 $30,026,400.00 $15,012,750.00 $657,369,800.25 $15,008,100.00 $47,380,315.25 $29,998,500.00 $20,011,200.00 $40,011,600.00 $25,051,750.00 $25,005,750.00 $29,961,900.00 $24,995,500.00 $19,948,200.00 $25,000,500.00 $29,755,500.00 $29,877,000.00 $19,814,600.00 $39,873,400.00 $25,011,500.00 $10,017,700.00 $14,977,200.00 $20,010,000.00 $10,013,100.00 $25,027,000.00 $25,026,750.00 $25,578,285.00 $10,011,600.00 35-323 MARKET Treasurer § ARS Report TO PURSUANT $25,000,000.00 $20,000,000.00 $20,000,000.00 $30,000,000.00 $20,000,000.00 $20,000,000.00 $24,946,250.00 $30,000,000.00 $25,000,000.00 $30,000,000.00 $17,960,508.75 $18,905,272.50 $25,000,000.00 $20,000,000.00 $25,000,000.00 $15,000,000.00 $20,000,000.00 $25,000,000.00 $30,000,000.00 $15,000,000.00 $657,916,750.00 $15,000,000.00 $47,425,000.00 $30,000,000.00 $20,000,000.00 $40,000,000.00 $25,077,250.00 $24,970,000.00 $30,000,000.00 $25,000,000.00 $20,000,000.00 $25,000,000.00 $30,000,000.00 $30,000,000.00 $20,000,000.00 $40,000,000.00 $25,000,000.00 $10,000,000.00 $14,998,500.00 $20,000,000.00 $10,000,000.00 $25,000,000.00 $25,000,000.00 $25,500,000.00 $10,000,000.00 County PRINCIPAL 3 Portfolio RESTRICTED Maricopa $25,000,000.00 $20,000,000.00 $20,000,000.00 $30,000,000.00 $20,000,000.00 $20,000,000.00 $25,000,000.00 $30,000,000.00 $25,000,000.00 $30,000,000.00 $17,965,000.00 $18,910,000.00 $25,000,000.00 $20,000,000.00 $25,000,000.00 $15,000,000.00 $20,000,000.00 $25,000,000.00 $30,000,000.00 $15,000,000.00 $657,925,000.00 $15,000,000.00 $47,425,000.00 $30,000,000.00 $20,000,000.00 $40,000,000.00 $25,000,000.00 $25,000,000.00 $30,000,000.00 $25,000,000.00 $20,000,000.00 $25,000,000.00 $30,000,000.00 $30,000,000.00 $20,000,000.00 $40,000,000.00 $25,000,000.00 $10,000,000.00 $15,000,000.00 $20,000,000.00 $10,000,000.00 $25,000,000.00 $25,000,000.00 $25,500,000.00 $10,000,000.00 INVESTMENTS PAR ALL COUNT 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 30 1 2 1 1 2 1 1 1 1 1 1 1 1 1 2 1 1 1 1 1 1 1 1 1 Active cost. 04/28/2017 of 07/2612019 07/2612019 01/28/2020 08/16/2019 08/23/2019 09/15/2020 10/17/2019 10/17/2019 07/27/2020 10/27/2020 10/28/2019 09/30/2019 07128/2020 07/28/2020 11/26/2019 05126/2020 06/29/2020 01/17/2020 01/27/2020 08/24/2020 04/26/2018 07/27/2018 08/03/2018 06/29/2018 10/29/2018 06/22/2018 05/24/2019 0612712018 12/28/2017 09/21/2018 10/26/2018 11/02/2020 11/02/2018 11/10/2020 11/27/2019 12/13/2019 01/28/2020 05/25/2018 02/24/2020 08/2812020 06/2112019 06/28/2019 09/29/2020 03/27/2020 amortized are as 1 1.125 1.33 1.2 1.25 1.45 1.1 1.23 1.4 1.405 1.25 1.25 1.3 1.35 1.5 1.625 1.75 1.75 1.7 1.875 MAC 0.95 1 1 1.05 1.1 1.25 1.3 0.91 0.8 1 1.05 1.365 0.93 1.4 1.3 1.51 1.625 1 1 1.85 1.53 1.55 2 1.7 values fair applied. Listing FNMA FNMA FNMA FNMA FNMA FNMA FNMA FNMA FNMA FNMA FNMA FNMA FNMA FNMA FNMA FNMA FNMA FNMA FNMA FNMA FREDDIE FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC TANS amortization Detail Labels BLOOMBERG and Bonds Portfolio Status Row Source: School Straight-line Flora T. Treasurer ACCRUAL $17,708.33 $1,944.44 $115,972.22 $532,686.24 $532,686.24 $85,566.30 $73,342.54 $65,193.37 $115,041.21 $61,118.78 $132,424.03 $8,475,918.19 $7,018,800.31 $1,683,318.46 $42,604.05 $8,368.80 $8,194.45 $4,999.83 $5,624.81 $15,416.15 $942,913.09 $10,850.00 $78,949.50 $853,113.59 $253,997.64 $253,997.64 $130,189.15 $130,189.15 $34,322.87 $5,832.09 $6,336.79 $11,678.33 $10,475.66 $279,291.67 $60,796.67 $27,834.17 $68,818.33 $121,842.50 $5,335,481.84 $465,583.32 $5,698.52 $459,884.80 $500,383.53 $254,976.08 $245,407.44 DAYS. in YEARS. in Royce treasurer.maricopa.gov INTEREST displayed displayed (WAM) Duration $37,500.00 $8,600.00 $10,750.00 ($252,539.06) ($252,539.06) (S30.078.13) $93,750.00 $22,656.25 ($239,257.81) (3105,468.75) $5,859.38 $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 Weighted-Average-Maturity LOSS GAIN UNREALIZED $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 $25,037,500.00 $20,008,600.00 $24,956,750.00 $164,952,148.44 $164,952,148.44 $35,001,367.19 $29,946,093.75 $19,995,312.50 $25,011,718.75 $29,821,875.00 $25,175,781.25 35-323 MARKET Treasurer 4 ARS Report TO PURSUANT $25,000,000.00 $20,000,000.00 $24,946,000.00 $165,204,687.50 $165,204,687.50 $35,031,445.31 $29,852,343.75 $19,972,656.25 $25,250,976.56 $29,927,343.75 $25,169,921.88 $348,412,737.75 $120,353,087.75 $50,025,421.40 $1,119,859.40 $245,032.80 $237,876.40 $123,656.40 $138,221.10 $375,072.70 $19,739,224.50 $777,162.25 $2,100,000.00 $16,862,062.25 $9,515,000.00 $9,515,000.00 $5,076,337.50 $5,076,337.50 $5,075,000.00 $1,040,000.00 $1,030,000.00 $1,650,000.00 $1,355,000.00 $9,500,000.00 $2,000,000.00 $1,500,000.00 $3,000,000.00 $3,000,000.00 $70,327,666.35 $4,323,147.00 $89,799.75 $4,233,347.25 $9,447,173.30 $4,820,690.10 $4,626,483.20 County PRINCIPAL 4 Portfolio RESTRICTED Maricopa $25,000,000.00 $20,000,000.00 $25,000,000.00 $165,000,000.00 $165,000,000.00 $35,000,000.00 $30,000,000.00 $20,000,000.00 $25,000,000.00 $30,000,000.00 $25,000,000.00 $339,715,000.00 $112,215,000.00 $49,910,000.00 $1,100,000.00 $240,000.00 $235,000.00 $120,000.00 $135,000.00 $370,000.00 $19,650,000.00 $775,000.00 $2,100,000.00 $16,775,000.00 $9,515,000.00 $9,515,000.00 $5,070,000.00 $5,070,000.00 $5,075,000.00 $1,040,000.00 $1,030,000.00 $1,650,000.00 $1,355,000.00 $9,500,000.00 $2,000,000.00 $1,500,000.00 $3,000,000.00 $3,000,000.00 $62,305,000.00 $3,660,000.00 $75,000.00 $3,585,000.00 $8,890,000.00 $4,530,000.00 $4,360,000.00 INVESTMENTS PAR ALL COUNT 1 1 1 6 6 1 1 1 1 1 1 47 37 18 5 1 1 1 1 1 3 1 1 1 1 1 1 1 4 1 1 1 1 4 1 1 1 1 19 2 1 1 2 1 1 Active 04/28/2017 District School 07/01/2017 07/01/2018 0710112017 07/01/2018 07/01/2019 District 07/01/2017 07/01/2017 07/01/2018 District School 07/01/2017 District 07/01/2017 District School 07/01/2018 07/01/2019 07/01/2020 07/01/2021 District School 07/01/2017 07/01/2018 07/01/2019 07/01/2018 District 01/01/2018 07/01/2017 District cost. amortized of 07/11/2019 01/26/2021 05/11/2018 N/B 0613012018 06/30/2019 BONDS BONDS Elementary 1.98 1.98 2.29 2.29 2.29 School High 1 1.46 1.975 Unified 1 School High 0.93 Elementary 1.03 1.13 1.3 1.42 Elementary 1.22 1.27 1.57 1.63 School 5.23 5.23 School 01/01/2018 2.3 07/01/2017 2.3 are as Listing 1.5 FHLMC 1.75 FHLMC 1 FHLMC TREASURY TREASURY 06/30/2017 0.75 12/31/2017 0.75 112/31/2017 12/15/2018 1.25 0.625 1.625 SCHOOL CartwrighESD CartwrighESD CartwrightESD CartwrightESD CartwrightESD Union GlendaleUHSD GlendaleUHSD GlendaleUHSD Valley ParadiseValleyUSD Union PhoenixUHSD RiversideESD RiversideESD RiversideESD RiversideESD WashingtonESD WashingtonESD VVashingtonESD WashingtonESD BONDS Unified ChandlerUSD ChandlerUSD Unified DysartUSD DysartUSD values fair applied. Detail US T T T T T T Hold-to-Maturity IMPROVEMENT Cartwright Glendale Paradise Phoenix Riverside Washington REFUNDING Chandler Dysart BLOOMBERG TANS and amortization Labels US COUNTY Bonds Portfolio Status Row Source: School Straight-line Flora T. Treasurer ACCRUAL $1,147,085.10 $1,147,085.10 $756,708.09 $756,708.09 $1,064,583.33 $762,951.39 $301,631.94 $1,245,956.96 $580,658.35 $530,075.94 $2,161.83 $43,777.13 $89,283.72 $114,171.78 $18,714.39 $95,457.39 $41,009.73 $8,465.57 $3,430.00 $3,511.67 $25,602,50 $1,457,117.88 $1,457,117.88 $288,221.12 $288,221.12 $224,171.98 $224,171.98 $224,171.98 $224,171.98 $96,073.71 $96,073.71 $128,098.28 $128,098.28 $80,061.42 $80,061.42 $236,981.81 $236,981.81 $96,073.71 $96,073.71 $6,404.91 $6,404.91 $76,858.97 $76,858.97 $17,318,063.91 DAYS. in YEARS. in Royce treasurer.rnaricopa.gov displayed displayed INTEREST (WAM) Duration $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 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 LOSS Weighted-Average-Maturity GAIN UNREALIZED $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 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3,656,806,532.45 MARKET 35-323 4 Treasurer ARS TO Report $15,597,461.00 $15,597,461.00 $6,677,509.30 $6,677,509.30 $13,442,424.00 $9,656,252.00 $3,786,172.00 $16,508,436.00 $5,100,696.50 $4,581,891.00 $102,079.00 $2,190,888.00 $4,532,881,50 $1,627,741.10 $411,636.10 $1,216,105.00 $2,703,774.65 $1,095,000.00 $217,028.70 $225,734.95 $1,166,011.00 $228,059,650.00 $228,059,650.00 $45,110,700.00 $45,110,700.00 $35,086,100.00 $35,086,100.00 $35,086,100.00 $35,086,100.00 $15,036,900.00 $15,036,900.00 $20,049,200.00 $20,049,200.00 $12,530,750.00 $12,530,750.00 $37,091,020.00 $37,091,020.00 $15,036,900.00 $15,036,900.00 $1,002,460.00 $1,002,460.00 $12,029,520.00 $12,029,520.00 $4,006,576,486.64 PURSUANT PRINCIPAL 5 County Portfolio RESTRICTED Maricopa $14,060,000.00 $14,060,000.00 $5,390,000.00 $5,390,000.00 $12,000,000.00 $8,600,000.00 $3,400,000.00 $14,270,000,00 $4,190,000.00 $3,825,000.00 $100,000.00 $2,025,000.00 $4,130,000.00 $1,470,000.00 $370,000.00 $1,100,000.00 $2,565,000.00 $1,095,000.00 $210,000.00 $215,000.00 $1,045,000.00 $227,500,000.00 $227,500,000.00 $45,000,000.00 $45,000,000.00 $35,000,000.00 $35,000,000.00 $35,000,000.00 $35,000,000.00 $15,000,000.00 $15,000,000.00 $20,000,000.00 $20,000,000.00 $12,500,000.00 $12,500,000.00 $37,000,000.00 $37,000,000.00 $15,000,000.00 $15,000,000.00 $1,000,000.00 $1,000,000.00 $12,000,000.00 $12,000,000.00 $4,002,823,000.00 INVESTMENTS PAR ALL 1 1 1 1 2 1 1 5 1 1 1 1 1 2 1 1 4 1 1 1 1 10 10 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 187 COUNT Active District District District District 01/01/2018 07/01/2017 District District 07/19/2017 District 07/19/2017 District 07/19/2017 District 07/19/2017 District District 07/1912017 District 07/19/2017 cost. 04/28/2017 School 07/01/2017 06/14/2017 District 01/01/2018 07/01/2017 School 01101/2018 07/01/2017 07/01/2017 07101/2020 07101/2021 School 3.62 3.62 School 07/01/2021 07/01/2018 07/01/2019 07/01/2020 District 07/19/2017 School District 07/19/2017 School School 1.07 School District 07/1912017 School 07/19/2017 School 1.07 School amortized of High 3.33 School 5.96 School 3.65 3.65 5.65 5.65 3.57 3.57 3.57 Unified 1,42 3 3 4.5 TANS School 1.07 1.07 School 1.07 High 1.07 Unified Elementary 1.07 School 1.07 Elementary 1.07 Unified Elementary 1.07 are as Union GlendaleUHSD Elementary KyreneESD Unified PeoriaUSD PeoriaUSD Elementary PhoenixESD PhoenixESD PhoenixESD PhoenixESD PhoenixESD Creek QueenCreekUSD QueenCreekUSD Elementary RiversideESD RiversideESD RiversideESD RiversideESD SCHOOL Unified ChandlerUSD Unified Valley DeerValleyUSD Unified GilbertUSD Union GlendaleUNSD Valley ParadiseValleyUSD PendergastESD Unified PeoriaUSD RooseveltESD Mountain SaddleMountainUSD WashingtonESD values fair applied. Listing Glendale Kyrene Peoria Phoenix Queen Riverside Chandler Deer Gilbert Glendale Paradise Pendergast Peoria Roosevelt Saddle Washington TANS amortization Detail COUNTY TANS BLOOMBERG and Labels Total Bonds Portfolio Status Row Grand Source: School Straight-line