Extracted text (via pymupdf_layout)
22145 characters
Charles B. Hoskins, Treasurer 301 West Jefferson St., Rm. 100 Phoenix, Arizona 85003 Phone: (602) 506-8511 Fax: (602) 506-1102 http://trcasurer.maricopa.gov Maricopa County Treasurer DATE: October 15, 2016 TO: Clint Hickman, Chairman Denny Barney, Supervisor, District 1 Steve Chucri, Supervisor, District 2 Andrew Kunasek, Supervisor, District 3 Steve Gallardo, Supervisor, District 5 SUBJECT: Treasurer's Collections and Investment Summary for September 2016 Secured property tax collections during the month of September equaled $257,383,135 and increased the 2016 year to date collections to $284,235,273 or 6.1% of the adjusted 2016 levy of $4,643,191,660. The chart below reflects the 2016 collected and uncollected levy amount and corresponding percentages for the 2016 property tax year. SEPTEMBER 2016 Uncollected Levy $4,358,956,386 93.9% Collected Levy $284,235,273 6.1% • Collected Levy m Uncollected Levy The County's General Fund Balance totaled $89,065,962.04 effective September 30, 2016. Warrants outstanding of $170,495.24 will post against the fund balances when presented. The $19,294,366 unencumbered balance, of the County Municipal Line of Credit and the $15,705,634 Workers Compensation Liability Letter of Credit remain unused. haiTes Hoskins, Maricopa County Treasurer STATE OF ARIZONA ) ss. COUNTY OF MARICOPA ) This instrument was acknowledged before me this 15th day of October 2016, by Charles Hoskins, as 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. My Commission Expires TAMMY L GONZALES Notary Public - Arizona Maricopa County My Comm. Expires May 28, 2018 Straight-line Fixed School Grand P-1 NR Aaa AA+ Credit Status Grand POOL Status GASB Income Bonds Total FED FED GOVT SCHOOL (not US USGN GOVT GOVT Ratings Total FIXED 40 amortization fair and FREDDIE FANNIE rated) FREDDIE FEDERAL FEDERAL FANNIE FREDDIE FEDERAL FEDERAL FANNIE COUNTY COUNTY Hold-to-Maturity US NOTES BONDS Available-for-Sale value is TANS MAC HOME FARM AGENCY DISTRICT TREASURY MAC MAE AGENCY MAC MAE AGENCY TREASURY DISCOUNT INCOME Portfolio Investment applied. market fair LN CRD DISCOUNT HOME FARM HOME FARM SCHOOL SCHOOL value. values are DISCOUNT DISCOUNT DISCOUNT NOTE N/B LOAN CREDIT LOAN CREDIT TANS BONDS NOTES Risk amortized NT NT NT BANK BANK BANK BANK Disclosures cost. Active Active as 128 1 18 6 7 32 32 39 39 6 6 9 10 14 45 51 3 1 1 1 6 6 Count 128 10 29 39 6 30 32 21 89 89 128 Count of % OF 09/30/2016 100.00% 8.54% 3.92% 12.46% 6.94% 26.93% 37.02% 16.65% 87.54% 87.54% 100.00% TOTAL turn ALL of Face Maricopa 81% AGENCY GOVT Active Arrounl PAR INVESTMENTS $2,664,359,000 $227,500,000 $104,575,000 $332,075,000 $185,000,000 $717,425,000 $986,269,000 $443,590,000 $2,332,284,000 $2,332,284,000 $2,664,359,000 Portfolio BofA BofA RESTRICTED County Issuer BofA Merrill Merrill Report Merrill Lynch PRINCIPAL PURSUANT Allocation Lynch Lynch 1-3 $2,670,j3 $228,059,650 $112,574,313 $340,633,963 $185,170,898 $717,330,300 $983,640,557 $443,441,808 $2,329,583,563 $2,329,583,563 $2,670,217,526 Treasurer 1-3 0-1 Month BENCHMARKS ,526 TO Year Year ARS US US US 6 7% USGN Active 12% DISTRICT SCHOOL Active Agency Treasury Treasury $2 FAIR 35-323 670,458,016 $228,059,650 $111,690,159 $339,749,809 $185,312,109 $717,413,373 $984,699,755 $443,282,970 $2,330,708,207 $2,330,708,207 $2,670,458,016 Index Index Index Weighted-Average-Maturity 0.93% 0.48% 0.32% 0.78% 0.82% 1.15% 0.93% 0.75% 1.10% 0.44% 0.95% 0.76% 0.76% 0.78% YTIVI Duration (WW1) 442 292 482 352 321 117 652 454 454 442 WAIN Charles displayed displayed treasurermaricopa.gov "Hos in in DURATION " YEARS. DAYS. 0.46 0.00 1.28 0.40 0.32 0.57 0.22 0.89 0.46 0.46 0.46 Treasurer Hoskins Straight-line Fixed School Income Bonds amortization fair value TANS and GASB applied. is market fair values Grand POOL Status Grand POOL Porffolio Status Statement value. are Total COUNTY COUNTY Hold-to-Maturity US NOTES DISCOUNT BONDS FIXED Available-for-Sale Total COUNTY COUNTY Hold-to-Maturity US NOTES DISCOUNT BONDS FIXED Available-for-Sale 31 amortized cost. SCHOOL SCHOOL TREASURY INCOME SCHOOL SCHOOL TREASURY INCOME Investment TANS BONDS NOTES TANS BONDS NOTES Accounting COUNT Active COUNT Active & 128 10 29 39 6 30 32 21 89 89 128 128 29 39 6 30 32 21 89 89 128 Reporting $2 as of Maricopa 664 359 $227,500,000 $104,575,000 $332,075,000 $185,000,000 $717,425,000 $986,269,000 $443,590,000 $2,332,284,000 $2,332,284,000 $2,664,359,000 PAR $2,670,217,526 $228,059,650 $112,574,313 $340,633,963 $185,170,898 $717,330,300 $983,640,557 $443,441,808 $2,329,583,563 $2,329,583,563 $2,670,217,526 PRINCIPAL 09/30/2016 Portfolio 2 000 County $2,670,217,526 $228,059,650 $112,574,313 $340,633,963 $185,170,898 $717,330,300 $983,640,557 $443,441,808 $2,329,583,563 $2,329,583,563 $2,670,217,526 PRINCIPAL $2,670,458,016 $228,059,650 $111,690,159 $339,749,809 $185,312,109 $717,413,373 $984,699,755 $443,282,970 $2,330,708,207 $2,330,708,207 $2,670,458,016 ICHW ALL Report Treasurer INVESTMENTS $2 669,340,984 $228,059,650 $111,690,159 $339,749,809 $185,147,039 $717,337,750 $983,640,557 $443,465,829 $2,329,591,175 $2,329,591,175 $2,669,340,984 AMORTIZATION $2,330,708,207 $185,312,109 $717,413,373 $984,699,755 $443,282,970 $2,330,708,207 $2,330,708,207 $2,330,708,207 MARKET RESTRICTED $0 $0 $0 PURSUANT Weighted-Average-Maturity INTEREST UNREALIZED TO ARS $13 -323 35 Duration (WAM) 916 057 $492,962 $5,194,026 $5,686,988 $1,247,797 $4,130,467 $902,804 $1,948,001 $8,229,069 $8,229,069 $13,916,057 ACCRUAL $1,124,644 $0 $0 $0 $141,211 $83,073 $1,059,198 ($158,838) $1,124,644 $1,124,644 $1,124,644 GAIN/(_05S) Charles displayed displayed treasurer.maricopa.gov "Hos " in YEARS. in DAYS. Treasurer Hoskins Straight-line Fixed Income Schoo/ Bonds POOL Row Labels Status Portfolio amortization fair value is and TANS Fair FHLBDN FHLBDN FHLBDN FHLBDN FHLBDN FED HOME FFCBDN FFCBDN FFCBDN FFCBDN FED FARM FNMDN FNMDN FNMDN FNMDN FNMDN FANNIE DISCOUNT FHLB FHLB FHLB FHLB FHLB 1 FHLB FHLB FHLB FHLB FEDERAL FFCB FFCB FFCB FFCB 1 FFCB FFCB FFCB FFCB FFCB FFCB FEDERAL BONDS FIXED INCOME Available-for-Sale Detail Listing applied. market value. values 0 0 0 0 0 LN 0 0 0 0 CRD 0 0 0 0 0 DISCOUNT NOTES 0.9 1.1 1.125 0.875 05/23/2018 1.25 1.33 0.73 0.65 HOME 0.95 0.8 1.24 01/0712019 1.02 1.07 1.02 0.875 0.57 0.5 FARM as of are 10/19/2016 10/05/2016 10/07/2016 10/03/2016 06/29/2017 DISCOUNT 07/03/2017 06/29/2017 12/22/2016 05/12/2017 DISCOUNT 06/30/2017 12/29/2016 01/03/2017 10/06/2016 05/17/2017 NOTE 05/18/2018 04/26/2019 10/11/2019 06/29/2018 12/28/2018 12/28/2018 06/30/2017 12/19/2016 LOAN 0612712019 03/22/2018 01/13/2020 07105/2019 05/04/2018 08/02/2018 07/30/2018 10/03/2016 01113/2017 CREDIT 09130/2016 amortized cost. NT NT BANK BANK 1 1 2 1 1 18 1 3 1 1 6 3 1 1 1 1 7 32 1 2 1 1 1 1 1 1 1 10 1 2 1 1 1 1 1 1 1 1 11 21 89 89 128 COUNT Active ALL $40,000,000.00 $25,000,000.00 $70,000,000.00 $35,000,000.00 $20,000,000.00 $515,800,000.00 $40,000,000.00 $120,000,000.00 $10,000,000.00 $27,000,000.00 $197,000,000.00 $135,000,000.00 $11,469,000.00 $20,000,000.00 $32,000,000.00 $30,000,000.00 $228,469,000.00 $986,269,000.00 $20,000,000.00 $20,000,000.00 $20,000,000.00 $17,000,000.00 $20,000,000.00 $15,000,000.00 $20,000,000.00 $30,000,000.00 $20,000,000.00 $182,000,000.00 $26,000,000.00 $45,000,000.00 $25,000,000.00 $22,090,000.00 $25,000,000.00 $20,000,000,00 $30,000,000.00 $25,000,000.00 $13,500,000.00 $30,000,000.00 $261,590,000.00 $443,590,000.00 $2,332,284,000.00 $2,332,284,000.00 $2,664,359,000.00 PAR INVESTMENTS Maricopa RESTRICTED Portfolio 1 $39,962,588.89 $24,982,125.00 $69,938,594.44 $34,963,444.44 $19,888,472.22 $515,363,414.85 $39,808,188.89 $119,302,450.00 $9,965,747.22 $26,830,740.00 $195,907,126.11 $134,330,725.00 $11,432,203.63 $19,933,111.11 $31,952,022.22 $29,800,116.67 $227,448,178.63 $983,640,557.10 $20,000,000.00 $20,000,000.00 $19,978,000.00 $16,959,030.00 $19,993,000.00 $15,000,000.00 $20,000,000.00 $29,968,800.00 $20,000,000.00 $181,898,830.00 $25,997,400.00 $45,003,400.00 $25,000,000.00 $22,073,432.50 $25,000,000.00 $19,980,000.00 $30,000,000.00 $24,990,500.00 $13,498,245.00 $30,000,000.00 $261,542,977.50 $443,441,807.50 $2,329,583,563.03 $2,329,583,563.03 $2,670,217,526.13 PRINCIPAL PURSUANT Report County TO ARS Treasurer Er MARKET 35-323 $39,996,640.00 $24,999,750.00 $69,999,805.56 $35,000,000.00 $19,965,402.78 $515,722,095.88 $39,813,322.22 $119,439,083.33 $9,992,442.22 $26,908,534.50 $196,153,382.28 $134,497,260.00 $11,459,136.98 $19,980,102,22 $31,999,360.00 $29,912,865.00 $227,848,724.20 $984,699,754.86 $20,000,000.00 $19,964,000.00 $19,990,000.00 $16,995,750.00 $20,044,800.00 $15,030,450.00 $20,042,400.00 $29,985,300.00 $20,014,200.00 $182,066,900.00 $25,876,500.00 $44,995,500.00 $24,978,750.00 $21,957,460.00 $25,000,000.00 $19,987,800.00 $29,958,000.00 $24,947,750.00 $13,503,510.00 $30,010,800.00 $261,216,070.00 $443,282,970.00 $2,330,708,206.98 $2,330,708,206.98 $2,330,708,206.98 UNREALIZED GAIN Weighted-Average-Maturity $34,051.11 $17,625.00 $61,211.11 $36,555.56 $76,930.56 $358,681.02 $5,133.33 $136,633.33 $26,695.00 $77,794.50 $246,256.17 $166,535.00 $26,933.35 $46,991.11 $47,337.78 $112,748.33 $400,545.57 $1,059,197.76 $0.00 ($36,000.00) $12,000.00 $36,720.00 $51,800.00 $30,450.00 $42,400.00 $16,500.00 $14,200.00 $168,070.00 ($120,900.00) ($7,900.00) ($21,250.00) ($115,972.50) $0.00 $7,800.00 ($42,000.00) ($42,750.00) $5,265.00 $10,800.00 (S326,907.50) ($158,837.50) $1,124,643.95 $1,124,643.95 LOSS Duration (WAIVI) INTEREST Charles displayed in YEARS. displayed in DAYS. $30,121.52 $17,020.15 $57,517.72 $36,016.33 $28,932.40 $280,386.94 $4,828.20 $164,443.46 $21,058.45 $66,316.11 $256,646.22 $146,294.04 $21,438.01 $38,066.73 $46,542.73 $73,392.29 $325,733.80 $902,804.20 $21,000.00 $37,277.78 $49,375.00 $50,822,92 $70,555,56 $94,791.67 $200,977.78 $181,891.67 $133,972.22 $840,664.58 $43,225.00 $68,000.00 $66,305.56 $50,929.72 $60,208.33 $193,788.89 $278,800.00 $200,520,83 $38,475.00 $107,083.33 $1,107,336.67 $1,948,001.25 $8,229,068.78 $8,229,088.78 $13,916,056.68 ACCRUAL treasurer.maricopa.gov Treasurer "Hos " Hoskins Straight-line Fixed School Row Status Portfolio amortization Income fair Bonds and NOTES Labels Detail applied. value is market TANS fair values FHLMC 0.8 FHLMC 0.91 FHLMC 1.3 FHLMC 1.05 FHLMC 1.3 FHLMC 1.25 FHLMC 1.1 FHLMC 1.05 FHLMC 1 FHLMC 1 FHLMC 1 FHLMC 0.95 FREDDIE MAC FNMA 1.45 FNMA 1.25 FNMA 1.2 FNMA 1.33 FNMA 1.125 FNMA 1 FNMA 1.05 FNMA 1.14 FNMA 1.2 FNMA 1.4 FNMA 1.25 FNMA 1.26 FNMA 1.16 FNMA 1.125 FNMA 0.875 FANNIE MAE FREDN 0 FREDDIE MAC FHLBDN 0 FHLBDN 0 FHLBDN 0 FHLBDN 0 FHLBDN 0 FHLBDN 0 FHLBDN 0 0 FHLBDN FHLBDN 0 FHLEDN 0 FHLBDN FHLEDN 0 Listing as value. are 12/28/2017 06/27/2018 05/24/2019 05/10/2018 04/29/2019 06/22/2018 10/29/2018 06/29/2018 08/03/2018 07/27/2418 04/27/2018 04/26/2018 09/15/2020 08/23/2019 08/15/2019 01/28/2020 07/26/2019 07/26/2019 07/12/2019 07/05/2019 06/28/2019 06/13/2019 05/16/2019 05/03/2019 11/16/2018 10129/2018 10/26/2017 12/23/2015 DISCOUNT 11/22/2016 11/09/2016 11/08/2016 10120/2016 10/13/2016 11/10/2016 10/12/2015 10/24/2015 10/04/2016 10/17/2016 010/11/2016 10/21/2016 of amortized NT 09/30/2016 cost. COUNT Active 1 1 1 1 1 1 2 1 1 2 1 1 15 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 15 30 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ALL $25,000,000.00 $30,000,000.00 $25,000,000.00 $25,000,000.00 $30,000,000.00 $25,000,000.00 $40,000,000.00 $20,000,000.00 $30,000,000.00 $47,425,000.00 $25,000,000.00 $15,000,000.00 $357,425,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 $25,000,000.00 $30,000,000.00 $20,000,000.00 $20,000,000.00 $30,000,000.00 $35,000,000.00 $15,000,000.00 $25,000,000.00 $25,000,000.00 $360,000,000.00 $717,425,000.00 $45,000,000.00 $45,000,000.00 $30,000,000.00 $25,000,000,00 $28,000,000.00 $25,000,000.00 $27,800,000.00 $20,000,000.00 $30,000,000.00 $25,000,000.00 $30,000,000.00 $30,000,000.00 $35,000,000.00 $20,000,000.00 PAR INVESTMENTS Maricopa RESTRICTED Portfolio 2 PRINCIPAL PURSUANT County $25,000,000.00 $30,000,000.00 $24,970,000.00 $25,000,000.00 $30,000,000.00 $25,077,250.00 $40,000,000.00 $20,000,000.00 $30,000,000,00 $47,425,000.00 $25,000,000.00 $15,000,000.00 $357,472,250.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 $25,000,000.00 $30,000,000.00 $19,984,800.00 $20,000,000.00 $30,000,000.00 $35,000,000.00 $14,985,000.00 $25,000,000.00 $24,888,250.00 $359,858,050.00 $717,330,300.00 $44,921,837.50 $44,921,837.50 $29,987,291.67 $24,990,302.08 $27,986,000.00 $24,991,937.50 $27,789,922.50 $19,986,700.00 $29,988,400.00 $24,983,125.00 $29,984,250.00 $29,980,683.33 $34,977,911.11 $19,981,666.67 TO Report ARS .$ Treasurer MARKET 35-323 $24,993,250.00 $30,021,300.00 $25,019,000.00 $25,000,000.00 $30,012,000.00 $25,091,750.00 $39,999,200.00 $20,002,000.00 $29,998,800.00 $47,434,422.75 $24,997,750.00 $14,998,500.00 $357,567,972.75 $20,008,600.00 $20,007,000.00 $29,980,500.00 $19,970,000.00 $19,988,000.00 $24,925,000.00 $24,930,000.00 $30,045,600.00 $19,998,000.00 $20,000,000.00 $30,018,300.00 $35,025,550.00 $14,984,850.00 $24,946,000.00 $25,018,000.00 $359,845,400.00 $717,413,372.75 $44,975,552.50 $44,975,552.50 $29,989,305.00 $24,993,697.92 $27,993,255.11 $24,997,688.89 $27,798,874.10 $19,994,767.78 $29,999,583.33 $24,997,296.53 $30,000,000.00 $29,998,300.00 $34,999,611.11 $19,998,117.78 UNREALIZED GAIN Weighted-Average-Maturity ($6,750.00) $21,300.00 $49,000.00 $0.00 $12,000.00 $14,500.00 ($800.00) $2,000.00 ($1,200.00) $9,422.75 ($2,250.00) ($1 ,500.00) $95,722.75 $8,600.00 $7,000.00 (S19,500.00) ($30,000.00) ($12,000.00) ($75,000.00) ($70,000.00) $45,600.00 $13,200.00 $0.00 $18,300.00 $25,550.00 ($150.00) ($54,000.00) $129,750.00 ($12,650.00) $83,072.75 $53,715.00 $53,715.00 $2,013.33 $3,395.83 $7,255.11 $5,751.39 $8,951.60 $8,067.78 $11,183.33 $14,171.53 $15,750.00 $17,616.67 $21,700.00 $16,451.11 LOSS Duration (WAN!) INTEREST Charles displayed displayed treasurer.maricopa.gov "Hos " in YEARS. in DAYS. $51,111.11 $70,525.00 $108,333.33 $102,083.33 $163,583.33 $391,493.06 $404,555.56 $210,583.33 $272,500.00 $326,556.25 $231,250.00 $130,625.00 $2,468,199.31 $12,083.33 $20,833.33 $44,000.00 $45,811.11 $40,000.00 $44,444.44 $56,875.00 $80,750.00 $61,333.33 $83,222.22 $139,583.33 $400,575.00 $151,766.67 $258,593.75 $222,395.83 $1,662,267.36 $4,130,466.67 $40,037.23 $40,037.23 $1,695.16 $1,811.64 $4,984.17 $4,385.80 $7,288.30 $6,231.23 $8,848.41 $12,081.07 $15,003.70 $15,255.58 $18,989.78 $14,204.00 ACCRUAL Treasurer Hoskins Straight-line Fixed School Row Status Portfolio Income fair Bonds and COUNTY Hold-to-Maturity US US Labels Detail amortization value is TANS fair Phoenix PeoriaUSD PeoriaUSD Peoria KyreneESD Kyrene Glendale DysartUSD DysartUSD Dysart Chandler REFUNDING Washington Phoenix Paradise Glendale Cartwright IMPROVEMENT SCHOOL T 1.25 Ti T 0.75 T 0.75 70.625 TREASURY FHLIVIC Listing applied. market values Elementary Unified Elementary ClendaleUHSD Union Unified ChandlerUSD ChandlerUSD Unified BONDS WashingtonESD VVashingtonESD WashingtonESD WashingtonESD PhoenixUHSD Union ParadiseValleyUSD Valley GlendaleUHSD GlendaleUHSD GlendaleUHSD Union CartwrightESD CartwrightESD CartwrightESD CartwiighESD CartwrighESD 12/15/2018 12/31/2017 12/31/2017 06/30/2017 TREASURY 1 as value. are 3.65 3.65 School 5.96 3.33 High 2,3 2.3 School 5.23 5.23 School 1.63 1.57 1.27 1.22 Elementary 0.93 High Unified 1.975 1.46 1 High 2.29 2.29 2.29 1.98 1.98 Elementary BONDS BONDS 12/31/2016 NIB 09/21/2018 of amortized School 07/01/2017 01/01/2018 District 06/14/2017 School 07/01/2017 School 07/01/2017 01/01/2018 District 07/01/2017 01/01/2018 District School 07/01/2017 School 1 School 07/01/2017 07/01/2017 School 07/01/2019 07/01/2018 07/01/2017 0710112018 07/01/2017 School 09/30/2016 cost. District District District 07/01/2018 07/01/2019 07/01/2018 07/01/2017 District 07/01/2017 District 07/01/2018 District District District Active 5 1 1 2 1 1 1 1 1 1 2 1 1 2 15 1 1 1 1 4 1 1 1 1 1 1 1 3 '1 1 1 1 1 5 14 29 39 1 1 1 1 2 6 6 1 COUNT ALL PAR INVESTMENTS $14,270,000.00 $3,400,000.00 $8,600,000.00 $12,000,000.00 $5,390,000.00 $5,390,000.00 $14,060,000.00 $14,060,000.00 $4,360,000.00 $4,530,000.00 $8,890,000.00 $3,585,000.00 $75,000.00 $3,660,000.00 $59,740,000.00 $3,000,000.00 $3,000,000.00 $1,500,000.00 $2,000,000.00 $9,500,000.00 $5,070,000.00 $5,070,000.00 $9,515,000.00 $9,515,000.00 $16,775,000.00 $2,100,000.00 $775,000.00 $19,650,000.00 $370,000.00 $135,000.00 $120,000.00 $235,000.00 $240,000.00 $1,100,000.00 $44,835,000.00 $104,575,000.00 $332,075,000.00 $25,000,000.00 $20,000,000.00 $30,000,000.00 $35,000,000.00 $75,000,000.00 $185,000,000.00 $185,000,000.00 $20,000,000.00 Maricopa RESTRICTED Portfolio 3 PRINCIPAL County $16,508,435.00 $3,786,172.00 $9,656,252.00 $13,442,424.00 $6,677,509.30 $6,577,509.30 $15,597,461.00 $15,597,451.00 $4,526,483.20 $4,520,690.10 $9,447,173.30 $4,233,347.25 $89,799.75 $4,323,147.00 $67,623,891.70 $3,000,000.00 $3,000,000.00 $1,500,000.00 $2,000,000.00 $9,500,000.00 $5,075,337.50 $5,075,337.50 $9,515,000.00 $9,515,000.00 $15,562,062.25 $2,100,000.00 $777,162.25 $19,739,224.50 $375,072.70 $138,221.10 $123,655.40 $237,876.40 $245,032.80 $1,119,859.40 $44,950,421.40 $112,574,313.10 $340,633,963.10 $25,250,976.56 $19,972,656.25 $29,852,343.75 $35,031,445.31 $75,063,476.56 $165,170,898.44 $185,170,898.44 $20,000,000.00 PURSUANT Report TO ARS Treasurer -323 35 MARKET $25,183,593.75 $20,052,343.75 $29,989,453.13 $35,036,914.06 $75,049,804.59 $185,312,109.38 $185,312,109.38 $20,000,000.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 UNREALIZED GAIN Weighted-Average-Maturity $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 ($57,382.81) $79,687.50 $137,109.38 $5,468.75 ($13,671.88) $141,210.94 $141,210.94 $0.00 LOSS Duration (WAM) Charles displayed displayed INTEREST treasurer.maricopa.gov "Hos " in YEARS. in DAYS. $855,291.94 $229,929.72 $581,586.94 $811,516.67 $571,100.44 $571,100.44 $876,570.70 $876,570.70 $187,467.89 $194,777.42 $382,245.31 $351,554.06 $3,432.19 $354,986.25 $3,935,137.22 $93,589.17 $41,605.00 $15,827.50 $46,698.89 $198,720.56 $102,946.35 $102,946.35 $199,022.08 $199,022.08 $661,692.20 $61,234.83 $6,372.22 $729,299.26 $10,520.64 $3,838.51 $3,412.10 $5,506.05 $5,623.20 $28,900.50 $1,258,888.85 $5,194,026.07 $5,686,987.90 $247,609.29 $150,549.45 $159,368.13 $327,419.52 $352,850.27 $1,247,796.67 $1,247,796.67 $5,000.00 ACCRUAL Treasurer Hoskins Straight-line Fixed School Grand Row Status Portfolio Income Bonds Total Labels amortization fair value and TANS Saddle Roosevelt Peoria Paradise Glendale Gilbert Deer Chandler TANS COUNTY Queen Detail applied. market is fair VVashingtonESD Washington Mountain RoaseveltESD PeoriaUSD Unified PendergastESD Pendergast ParadiseValleyUSD Valley GlendaleUHSD Union GiIbertUSD Unified DeerValleyUSD Valley ChandlerUSD SCHOOL QueenCreekUSD QueenCreekUSD Creek PhoenixESD PhoenixESD PhoenixESD PhoenixESD PhoenixESD Listing value. values are Elementary SaddleMountainUSD Elementary 1.07 School Elementary Unified High 1.07 School Unified 1.07 Unified TANS Unified 3.57 3.57 3.57 5.65 5.65 as of amortized 1.07 1.07 Unified 1.07 School 07/19/2017 District 1.07 1.07 School 1.07 School 07/19/2017 District 1.07 School School 3.62 3.62 School 07/01/2021 07/01/2020 07/01/2017 07/0112017 0110112018 09/30/2016 cost. 07/19/2017 School School 07/19/2017 07/19/2017 School 07/19/2017 District 07/19/2017 District 07/19/2017 District 07/01/2017 01/0112018 District District 07/19/2017 District District District 07/19/2017 District Active 128 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 10 10 1 1 2 1 1 1 1 1 COUNT ALL PAR INVESTMENTS $2,664,359,000.00 $12,000,000.00 $12,000,000.00 $1,000,000.00 $1,000,000.00 $15,000,000.00 $15,000,004.00 $37,000,000.00 $37,000,000.00 $12,500,000.00 $12,500,000.00 $20,000,000.00 $20,000,000.00 $15,000,000.00 $15,000,000.00 $35,000,000.00 $35,000,000.00 $35,000,000.00 $35,000,000.00 $45,000,000.00 $45,000,000.00 $227,500,000.00 $227,500,000.00 $1,100,000.00 $370,000.00 $1,470,000.00 $4,130,000.00 $2,025,000.00 $100,000.00 $3,825,000.00 $4,190,000.00 Maricopa RESTRICTED Portfolio 4 PRINCIPAL County $2,670,217,526.13 $12,029,520.00 $12,029,520.00 $1,002,460.00 $1,002,460.00 $15,036,900.00 $15,036,900.00 $37,091,020.00 $37,091,020.00 $12,530,750.00 $12,530,750.00 $20,049,200.00 $20,049,200.00 $15,036,900.00 $15,036,900.00 $35,086,100.00 $35,085,100.00 $35,086,100.00 $35,086,100.00 $45,110,700.00 $45,110,700.00 $228,059,650.00 $228,059,650.00 $1,216,105.00 $411,636.10 $1,627,741.10 $4,532,881.50 $2,190,888.00 $102,079.00 $4,581,891.00 $5,100,696.50 PURSUANT Report TO ARS Treasurer 35-323 MARKET $2,330,708,206.98 $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 UNREALIZED GAIN Weighted-Average-Maturity LOSS $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 Duration (WAM) Charles displayed displayed INTEREST treasurer.maricopa.gov "Hos in in $13,916,056.68 $19,419.88 $19,419.88 $1,618.32 $1,618.32 $149,068.10 $149,068.10 $59,877.97 $59,877.97 $20,229.04 $20,229.04 $32,366.47 $32,366.47 $24,274.85 $24,274.85 $56,641.32 $56,641.32 $56,641.32 556,641.32 $72,824.55 $72,824.55 $492,961.82 $492,961.82 $72,450.28 $10,975.64 $83,425.92 $4,095.58 $2,008.13 $99.17 $405,210.94 $443,878.13 ACCRUAL Treasurer " Hoskins YEARS. DAYS.