Extracted text (via pymupdf_layout)
26006 characters
Charles B. Hoskins, Treasurer 301 West Jefferson St., Rm, 100 Phoenix, Arizona 85003 Phone: (602) 506-8511 Fax: (602) 506-1102 hftp://trcasurer.marieopa.gov Maricopa County Treasurer DATE: December 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 November 2016 Secured property tax collections during the month of November equaled $951,654,358 and increased the 2016 year to date collections to $2,329,251,164 or 50.3% of the adjusted 2016 levy of $4,634,348,533. The chart below reflects the 2016 collected and uncollected levy amount and corresponding percentages for the 2016 property tax year. NOVEMBER 2016 Uncollected Levy $2,305,097,369 49.7% Collected Levy $2,329,251,164 50.3% Collected Levy CI Uncollected Levy The County's General Fund Balance totaled $218,938,985.32 effective November 30, 2016. Warrants outstanding of $108,931.19 will post against the fund balances when presented. The $19,294,366 unencumbered balance, of the County Municipal Line of Credit anti the $15,705,634 Workers Compensation Liability Letter of Credit remain unused. STATE OF ARIZONA ) ss. COUNTY OF MAR1COPA ) This instrument was acknowledged before me this 15th day of December 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 anti consideration therein expressed. Maki My Comthission Expires TAMMY L GONZALES Notary Public - Arizona k Marlcopa County • # My Comm. Expires May 26, 20 Hoskins Treasurer DAYS. YEARS. in in " "Hos treasurer.maricopagov 1.07 1.09 1.09 1.46 0.28 2.41 0.82 0.84 1.26 0.63 1.07 displayed displayed DURATION Charles (WAM) Duration WARR 412 422 422 622 101 920 305 312 478 231 412 YTM 0.75% 0.73% 0.73% 0.96% 0.42% 1.17% 0.75% 0.93% 1.18% 0.82% 0.75% 0.46% 0.65% 1.25% Weighted-Average-Maturity 35-323 Index Index Index N $3,668,425,627 $3,320,897,043 $3,320,897,043 $421,560,315 $1,705,135,135 $979,318,194 $214,883,398 $347,528,584 $119,468,934 $228,059,650 $3,668,425,627 Active SCHOOL DISTRICT 9% Active USG 6% ARS Treasury Treasury Agency TO US US US PURSUANT BENCHMARKS Month Year Year Allocation 0-1 1-3 $3,674,629,850 $3,326,217,113 $3,326,217,113 $423,036,563 $1,703,939,977 $984,142,331 $215,098,242 $348,412,738 $120,353,088 $228,059,650 $3,674,629,850 1-3 Lynch Lynch Treasurer PRINCIPAL Lynch RESTRICTED Merrill Merrill Issuer Merrill Report BofA BofA BofA County INVESTMENTS PAR $3,669,927,000 $3,330,212,000 $3,330,212,000 $423,163,000 $1,707,749,000 $984,300,000 $215,000,000 $339,715,000 $112,215,000 $227,500,000 $3,669,927,000 Amount Active GOVT AGENCY 85% 1 Portfolio Face of ALL Sum Maricopa TOTAL 100.00% 90.74% 90.74% 11.53% 46.53% 26.82% 5.86% 9.26% 3.06% 6.20% 100.00% OF 11/30/2016 % Count 165 118 118 20 49 42 7 47 37 10 165 Count 7 7 2 3 62 55 22 9 9 15 7 7 47 47 49 49 7 8 24 10 165 of as Active Active Disclosures BANK BANK BANK BANK NT NT NT cost. Risk BONDS TANS CREDIT LOAN CREDIT LOAN NOTE DISCOUNT DISCOUNT DISCOUNT amortized NOTES NIB Portfolio INCOME TREASURY SCHOOL SCHOOL MAE FARM HOME MAC MAE FARM HOME MAC DISTRICT DISCOUNT CRD LN MAC are value 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 values fair market applied. 40 FIXED Total Ratings GOVT GOVT USGN US (not SCHOOL GOVT FED FED Total TANS is value GASB Status POOL Grand Status Credit AA+ Aaa NR P-1 Grand and fair amortization Bonds Income School Fixed Straight-line Hoskins Treasurer DAYS. in YEARS. in " "Hos treasureranaricona.gov $0 $0 $0 displayed displayed Charles 35-323 GAIN/(LOSS) ($5,320,070) ($5,320,070) ($5,320,070) ($1,476,247) $1,195,158 ($4,824,137) ($214,844) ($5,320,070) ACCRUAL $16,121,928 $9,720,324 $9,720,324 $2,495,666 $1,458,974 $4,193,225 $1,572,459 $6,401,604 $5,717,121 $684,482 $16,121,928 (WAM) Duration ARS TO UNREALIZED INTEREST Weighted-Average-Maturity PURSUANT $0 $0 $0 043 024 RESTRICTED $3,320,897,043 $3,320,897,043 $3,320,897,043 $421,560,315 $1,705,135,135 $979,318,194 $214,883,398 897 320 AMORTIZATION $3,673,748,024 $3,326,219,440 $3,326,219,440 $423,052,163 $1,703,939,977 $984,152,919 $215,074,382 $347,528,584 $119,468,934 $228,059,650 748 $3 $3,673 INVESTMENTS Treasurer ALL IVIL3 $3,668,425,627 $3,320,897,043 $3,320,897,043 $421,560,315 $1,705,135,135 $979,318,194 $214,883,398 $347,528,584 $119,468,934 $228,059,650 668,425,627 PRINCIPAL $3,674,629,850 $3,326,217,113 $3,326,217,113 $423,036,563 $1,703,939,977 $984,142,331 $215,098,242 $348,412,738 $120,353,088 $228,059,650 $3,674,629,850 Report $3 County Portfolio 11/30/2016 PRINCIPAL $3,674,629,850 $3,326,217,113 $3,328,217,113 $423,036,563 $1,703,939,977 $984,142,331 $215,098,242 $348,412,738 $120,353,083 $228,059,650 674,629,850 PAR $3,669,927,000 $3,330,212,000 $3,330,212,000 $423,163,000 $1,707,749,000 $984,300,000 $215,000,000 $339,715,000 $112,215,000 $227,500,000 $3,669,927,000 2 Maricopa of as $3 Reporting COUNT 165 118 118 20 49 42 7 47 37 10 165 COUNT 165 118 118 20 49 42 7 47 37 10 165 & Active Active Accounting BONDS TANS BONDS TANS Investment INCOME NOTES TREASURY SCHOOL SCHOOL INCOME NOTES TREASURY SCHOOL SCHOOL cost. amortized 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 values are value. Statement Status Portfolio POOL Grand Status POOL Grand fair market is applied. GASB TANS and value fair amortization Sands Income Straight-line School Fixed Hoskins " Treasurer ACCRUAL $16,121,927.87 $9,720,323.95 $9,720,323.95 $2,495,665.65 $1,358,959.40 $132,083.33 $236,979.17 $329,800.00 $102,708.33 $87,746.39 $117,972.22 $128,000.00 $84,391.67 $139,278.29 $1,136,706.25 $155,638.89 $218,391.67 $245,311.11 $126,041.67 $103,888.89 $75,614.58 $86,875.00 $73,944.44 $51,000.00 $1,458,974.31 $477,739.05 $108,097.18 $57,417.32 $32,335.66 $265,795.33 $14,093.56 $481,366.35 $95,210.99 $31,253.41 $266,868.28 $46,902.47 $11,173.25 $9,957.96 $270,890.85 $47,909.57 $20,522.33 $19,791.39 $21,785.45 $7,345.14 DAYS. in YEARS. in "Hos treasurermaricopa.gov INTEREST displayed displayed Charles (WAM) Duration LOSS ($5,320,069.51) ($5,320,069,51) ($1,476,247.12) ($1,093,307.12) ($11,700.00) ($118,250.00) ($109,500.00) ($101,500.00) ($121,495.00) ($171,000.00) ($149,650.00) ($304,460.00) ($5,752.12) ($382,940.00) ($5,200.00) ($3,300.00) $5,400.00 $3,600.00 $7,000.00 ($2,040.00) ($201,000.00) ($157,800.00) ($29,600.00) $1,195,158.31 $419,083.91 $124,283.33 $59,862.22 $33,710.58 $196,250.00 $4,977.78 $394,886.39 $96,154.50 $31,985.56 $222,800.00 $29,366.67 $4,191.67 $10,388.00 $230,893.57 $48,227.78 $13,960.00 $11,011.11 $18,052.22 $8,022.22 Weighted-Average-Maturity GAIN UNREALIZED $3,320,897,043.06 $3,320,897,043.06 $3,320,897,043.06 $421,560,315.38 $240,044,425.38 $29,988,300.00 $24,872,250.00 $29,890,500.00 $24,898,500.00 $21,951,937.50 $24,829,000.00 $44,853,750.00 $25,692,940.00 $13,067,247.88 $181,515,890.00 $19,994,800.00 $29,965,500.00 $20,005,400.00 $15,003,600.00 $20,000,000.00 $16,956,990.00 $19,777,000.00 $19,842,200.00 $19,970,400.00 $1,705,135,134.95 $235,816,040.31 $29,924,400.00 $19,992,973.33 $11,465,914.20 $134,526,975.00 $39,905,777.78 $263,164,059.17 $26,926,894.50 $9,997,732.78 $119,525,250.00 $39,837,555.56 $24,958,358.33 $41,918,268.00 $806,866,351.44 $19,936,700.00 $39,975,826.67 $39,964,733.33 $69,985,055.00 $24,999,355.56 35-328 MARKET Treasurer ARS TO Report PURSUANT PRINCIPAL $3,674,629,850.32 $3,326,217,112.57 $3,326,217,112.57 $423,036,562.50 $241,137,732.50 $30,000,000.00 $24,290,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 $181,898,830.00 $20,000,000.00 $29,968,800.00 $20,000,000.00 $15,000,000.00 $19,293,000.00 $16,959,030.00 $19,978,000.00 $20,000,000.00 $20,000,000.00 $1,703,939,976.64 $235,396,956.41 $29,800,116.67 $19,933,111.11 $11,432,203.63 $134,330,725.00 $39,900,800.00 $262,769,172.78 $26,830,740.00 $9,965,747.22 $119,302,450.00 $39,808,188.89 $24,954,166.67 $41,907,880.00 $806,635,457.87 $19,888,472.22 $39,961,866.67 $39,953,722.22 $69,967,002.78 $24,991,333.33 County 1 Portfolio RESTRICTED Maricopa $3,669,927,000.00 $3,330,212,000.00 $3,330,212,000.00 $423,163,000.00 $241,163,000.00 $30,000,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 $182,000,000.00 $20,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 $1,707,749,000.00 $236,469,000.00 $30,000,000.00 $20,000,000.00 $11,469,000.00 $135,000,000.00 $40,000,000.00 $264,000,000.00 $27,000,000.00 $10,000,000.00 $120,000,000.00 $40,000,000.00 $25,000,000.00 $42,000,000.00 $807,280,000.00 $20,000,000.00 $40,000,000.00 $40,000,000.00 $70,000,000,00 $25,000,000.00 INVESTMENTS PAR ALL COUNT 65 18 18 20 1 1 1 1 1 1 2 1 1 10 1 1 1 1 1 1 1 2 1 49 7 1 1 1 3 1 8 1 1 3 1 1 1 24 1 1 1 2 1 Active 11130/2016 BANK BANK NOTE NT DISCOUNT NT cost. amort&ed of CREDIT 01/1312017 07/3012018 08/02/2018 07/05/2019 01/07/2019 01/13/2020 03/22/2018 05/27/2019 01/28/2019 LOAN 12/19/2016 06/30/2017 12/28/2018 12/28/2018 05/23/2018 06/29/2018 10/11/2019 04/26/2019 05118/2018 DISCOUNT 05/17/2017 01/03/2017 12/29/2016 006/30/2017 05/09/2017 CRD 05/12/2017 12/22/2016 06/29/2017 07/03/2017 03124/2017 04/05/2017 DISCOUNT 06/29/2017 001/18/2017 02/07/2017 12/21/2016 12/08/2016 are value. as Listing INCOME FARM FEDERAL 0.5 FFCB 0.875 FFCB 1.02 FFCB 1.02 FFCB 1 FFCB 1.24 FFCB 0.8 FFCB 0.95 FFCB 1.27 FFCB HOME FEDERAL 0.65 FHLB 0.73 FHLS 1.33 FHLB 1.25 FMB 1 FHLB 0.875 FHLB 1.125 FHLB 1.1 FHLB 0.9 FHLB NOTES 0 FNMDN 0 FNMDN 0 FNMDN FNMDN 0 FNMDN FARM 0 FFCBDN 0 FFCBDN 0 FFCBDN 0 FFCBDN 0 FFCBDN 0 FFCBON LN HOME 0 FHLBDN FHLBDN 0 FHLBDN 0 FHLBON 0 FHLBDN values fair TANS market is applied. Detail Available-for-Sale FIXED BONDS DISCOUNT FANNIE FED FED and value fair amortization Portfolio Status Labels Row POOL Bonds School Income Fixed Straight-line Hoskins " Treasurer ACCRUAL $13,712.15 $9,512.17 $7,318.73 $10,373.08 $11,868.81 $11,144.90 $8,740.29 $5,243.70 $12,591.08 $8,356.22 $5,119.73 $8,696.76 $5,183.88 $8,190.72 $7,139.61 $7,894.47 $5,936.38 $6,514.31 $228,978.06 $68,769.83 $34,310.05 $28,238.33 $25,265.48 $8,409.80 $25,088.74 $13,367.43 $15,051.52 $10,475.88 $4,193,225.00 $1,868,517.36 $149,479.17 $164,843.75 $93,766.67 $253,575.00 $129,888.89 $101,333.33 $137,750.00 $100,625.00 $86,111.11 $77,500,00 $90,144.44 $104,000.00 $62,500.00 $60,416.67 $32,847.22 DAYS. in YEARS. in "Hos treasurer.maricopa.gov INTEREST displayed displayed Charles (WAM) Duration LOSS $17,002.25 $11,285.56 $4,055.56 $8,800.00 $14,055.56 $12,777.78 $9,581.25 $6,275.69 $3,506.25 $10,300.00 $5,073.61 $9,911.11 $1,458.54 $2,452,92 $3,305.56 $2,420.83 $4,055.56 $5,302.22 $150,294.45 $68,042.50 $20,700.00 $15,527.78 $7,476.25 $5,052.78 $16,875.00 $7,033.33 $3,743.75 $5,843.06 ($4,824,136.95) ($3,302,612.70) $125,000.00 ($89,250.00) ($38,550.00) ($141,400.00) ($22,000.00) ($118,200.00) ($219,300.00) ($248,500.00) ($284,750.00) ($162,600.00) ($157,600.00) ($171,300.00) ($49,600.00) ($255,000.00) ($206,750.00) Weighted-Average-Maturity GAIN UNREALIZED $42,285,312.50 $34,998,393.89 $24,989,083.33 $39,996,900.00 $39,988,055.56 $39,988,611.11 $34,999,217.36 $24,999,088.19 $44,968,443.75 $39,997,833.33 $24,999,691.67 $39,990,277.78 $19,965,796.44 $34,974,452.92 $24,953,472.22 $34,972,126.39 $24,979,555.56 $39,958,368.89 $399,288,684.03 $44,989,880.00 $44,878,200.00 $39,890,527.78 $44,875,920.00 $24,980,733.33 $79,937,000.00 $39,953,488.89 $44,874,993.75 $34,907,940.28 $979,318,194.30 $558,367,268.55 $25,013,250.00 $24,910,750.00 $14,946,450.00 $34,858,600.00 $19,978,000.00 $19,866,600.00 $29,780,700.00 $24,751,500.00 $24,715,250.00 $19,837,400.00 $19,842,400.00 $29,828,700.00 $19,950,400.00 $19,745,000.00 $24,739,500.00 35-323 MARKET Treasurer .$ ARS Report TO PURSUANT $42,268,310.25 $34,987,108.33 $24,985,027.78 $39,988,100.00 $39,974,000.00 $39,975,833.33 $34,989,636.11 $24,992,812.50 $44,964,937.50 $39,987,533.33 $24,994,618.06 $39,980,366.67 $19,964,337.90 $34,972,000.00 $24,950,166.67 $34,969,705.56 $24,975,500.00 $39,953,066.67 $399,138,389.58 $44,921,837.50 $44,857,500.00 $39,875,000.00 $44,868,443.75 $24,975,680.56 $79,920,125.00 $39,946,455.56 $44,871,250.00 $34,902,097.22 $984,142,331.25 $561,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,003,000.00 $25,000,000.00 $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 County PRINCIPAL 2 Portfolio RESTRICTED Maricopa $42,300,000.00 $35,000,000.00 $25,000,000.00 $40,000,000.00 $40,000,000.00 $40,000,000.00 $35,000,000.00 $25,000,000.00 $45,000,000.00 $40,000,000.00 $25,000,000.00 $40,000,000.00 $19,980,000.00 $35,000,000.00 $25,000,000.00 $35,000,000.00 $25,000,000.00 $40,000,000.00 5400,000,000.00 $45,000,000.00 $45,000,000.00 $40,000,000.00 $45,000,000.00 $25,000,000.00 $80,000,000.00 $40,000,000.00 $45,000,000.00 $35,000,000.00 $984,300,000.00 $561,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 $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 INVESTMENTS PAR ALL COUNT 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 10 1 1 1 1 1 2 1 1 1 42 24 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Active NT cost. 11/3012016 of 001/19/2017 12/14/2016 01/09/2017 12/06/2016 01/12/2017 01/10/2017 12/07/2016 12/13/2016 01/24/2017 12/15/2016 12/02/2016 01/04/2017 01/25/2017 01/26/2017 04/13/2017 01/30/2017 02/02/2017 02/14/2017 DISCOUNT 12123/2015 05/2312017 05124/2017 05/25/2017 02/06/2017 02/08/2017 03/02/2017 05/26/2017 05/19/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 07/26/2019 07/26/2019 01/28/2020 08/16/2019 08/23/2019 09/15/2020 10/17/2019 amortized are value. as Listing FHLSON 0 F1-11_,BDN 0 FHLBDN 0 FHLBDN 0 FHLBDN 0 FHLBDN 0 FHLBDN 0 FHLBDN 0 FHLBDN 0 FHLBIDN 0 FHLBDN 0 FI-ILBDN 0 FHLBDN 0 FHLBDN 0 FHLBDN 0 FHLBDN 0 EHLSON 0 FHLBDN MAC FREDDIE 0 FREDN 0 FREON 0 FREDN 0 FREDN 0 FREDN 0 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 1 FNMA 1.125 FNMA 1.33 FNMA 1.2 FNMA 1.25 FNMA 1.45 FNMA 1.1 FNMA values fair TANS market is applied. Detail NOTES FANNIE and value fair amortization Portfolio Status Labels Row Bonds School Income Fixed Straight-line Hoskins " Treasurer ACCRUAL $44,075.00 $32,083.33 $38,637.50 $19,961.11 $39,395.83 $27,083.33 $22,500.00 $0.00 $0.00 $2,324,707.64 $154,375.00 $405,597.92 $322,500.00 $245,583.33 $257,888.89 $443,576.39 $162,500.00 $116,025.00 $84,444.44 $38,333.33 $23,333.33 $31,850.00 $21,700.00 $15,555.56 $1,444.44 $1,572,458.99 $1,572,458.99 $431,404.53 $371,409.91 $207,074.18 $184,065.93 $299,692.62 $78,811.81 $6,401,603.92 $5,717,121.50 $1,379,825.25 $32,853.52 $6,415.20 $6,281.55 $3,870.10 $4,353.86 $11,932.81 $790,918.64 $7,663.89 $66,344.83 DAY& in YEARS. in "Hos treasurer.maricopa.gov INTEREST displayed displayed Charles (14/AM) Duration LOSS ($234,600.00) ($143,250.00) ($325,500.00) ($161,685.00) ($84,527.70) ($132,750.00) ($182,600.00) ($500.00) $2,400.00 ($1,521,324.25) ($43,050.00) ($78,074.25) ($142,200.00) ($66,800.00) ($212,000.00) ($19,750.00) $6,750.00 ($115,800.00) ($19,000.00) ($38,800.00) ($58,500.00) ($291,900.00) ($167,400.00) ($138,200.00) ($136,600.00) ($214,843.75) (S214,843.75) ($42,968.75) ($9,570.31) $100,781.25 $49,218.75 ($196,289.06) ($116,015.63) $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 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 $29,765,400.00 $24,856,750.00 $29,674,500.00 $17,798,823.75 $18,820,744.80 $24,867,250.00 $19,817,400.00 $24,999,500,00 $15,002,400.00 $420,950,925.75 $14,956,950,00 $47,346,925.75 $29,857,800.00 $19,933,200.00 $39,788,000.00 $25,057,500.00 $24,976,750.00 $29,884,200.00 $24,981,000.00 $19,961,200.00 $24,941,500.00 $29,708,100.00 $29,832,500.00 $19,861,800.00 $39,863,400.00 $214,883,398.44 $214,883,398.44 $75,020,507.81 $35,021,875.00 $29,953,125.00 $20,021,875.00 $25,054,687.50 $29,811,328.13 35-323 MARKET Treasurer ARS TO Report PURSUANT $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 $422,472,250.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 $215,098,242.19 $215,098,242.19 $75,063,476.56 $35,031,445.31 $29,852,343.75 $19,972,656.25 $25,250,976.56 $29,927,343.75 $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 County PRINCIPAL 3 Portfolio RESTRICTED Maricopa $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 $422,425,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 $215,000,000.00 $215,000,000.00 $75,000,000.00 $35,000,000.00 $30,000,000.00 $20,000,000.00 $25,000,000.00 $30,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 INVESTMENTS PAR ALL COUNT 1 1 1 1 1 1 1 1 18 1 2 1 1 2 1 1 1 1 1 1 1 1 2 7 7 2 1 1 1 1 1 47 37 18 5 1 1 1 1 1 3 1 1 Active 11/30/2016 District School 1.9807/01/2017 07/01/2018 07/01/2017 07/01/2018 07101/2019 District School 07/01/2017 07/01/2017 cost. amortized of 10/17/2019 07/27/2020 10/27/2020 10/28/2019 09/30/2019 07/28/2020 07128/2020 11/26/2019 05/2612020 04/26/2018 07/27/2018 08/03/2018 06/29/2018 10/29/2018 06/22/2018 05/24/2019 06/27/2018 12/28/2017 09/21/2018 10/26/2018 11/02/2020 11/02/2018 11110/2020 11/27/2019 NIB 12/31/2016 06/30/2017 12/31/2017 12/15/2018 06/30/2018 BONDS BONDS Elementary 1.98 2.29 2.29 2.29 High 1 1.46 are value. as Listing 1.23 FNMA 1.4 FNMA 1.405 FNMA 1.25 FNMA 1.25 FNMA 1.3 FNMA 1.35 FNMA 1.5 FNMA 1.625 FNMA MAC FREDDIE 0.95 FHLMC 1 FHLMC 1 FHLMC 1.05 FHLMC 1.1 FHLMC 1.25 FHLMC 1.3 FHLMC 0.91 FHLMC 0.8 FHLMC 1 FHLMC 1.05 FHLMC 1.365 FHLMC 0.93 FHLMC 1.4 FHLMC 1.3 FHLMC TREASURY TREASURY 0.625 0.75 0.75 1112/31/2017 11.25 0.625 SCHOOL IMPROVEMENT Cartwright CartwrighESD CartwrighESD CartwrightESD CartwrightESD CartwrightESD Union Glendale GlendaleUHSD GlendaleUHSD values fair TANS market is applied. Detail US US T T T T -to-Maturity COUNTY and value fair amortization Portfolio Status Labels Row Hold Bonds School Income Fhted Straight-line Hoskins Treasurer ACCRUAL $716,909.91 $214,880.42 $214,880.42 $110,804.85 $110,804.85 $8,405.60 $1,428.27 $1,551.87 $2,860.00 $2,565.47 $221,962.22 $50,765.56 $20,002.50 $49,455.00 $101,739.17 $4,337,296.25 $386,889.25 $4,085.94 $382,803.31 $416,323.64 $212,142.42 $204,181.22 $954,603.70 $954,603.70 $624,641.11 $624,841.11 $884,516.67 $633,903.51 $250,613.06 $967,983.77 $483,333.96 $441,229.69 $694.17 $14,056.88 $28,669.08 $92,294.92 $13,207.97 $79,086.94 $10,043.20 $2,073.20 $840.00 $860.00 $6,270.00 $684,482.42 $684,482.42 DAYS. in YEARS. in " "Hos treasurer.maricopa.gov displayed displayed INTEREST (WAM) Charles 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 $4.00 $0.00 $0.00 $0.00 $0.00 $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 1Neighted-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 $0.00 $0.00 MARKET 35-323 Treasurer ARS TO Report PURSUANT $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 $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,527,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 County PRINCIPAL 4 Portfolio RESTRICTED Maricopa $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 $76,000.00 $3,585,000.00 $8,890,000.00 $4,530,000.00 $4,360,000.00 $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 INVESTMENTS PAR ALL 1 1 1 1 1 4 1 1 1 1 4 1 1 1 1 19 2 1 1 2 1 1 1 1 1 1 2 1 1 5 1 1 1 1 1 2 1 1 4 1 1 1 1 10 10 COUNT Active 07101/2018 District 07/0112017 District District District 07/01/2017 07/01/2018 07/01/2019 07101/2018 District 07/01/2017 District District District 01101/2018 07/01/2017 District cost. 11/30/2016 School 1 School 07/01/2017 School 07/0112018 07101/2019 07101/2020 07/01/2021 School District 01/01/2018 07/01/2017 District 01/01/2018 07/01/2017 School School 06/14/2017 District 01/01/2018 07101/2017 School 01/01/2018 07/01/2017 07/0112017 07/01/2020 07/01/2021 School 3.62 3.62 School 07/01/2021 07/01/2018 07/01/2019 07/01/2020 amortized of 1.975 Unified High 0.93 1.03 1.13 1.3 1.42 Elementary 1.22 1.27 1.57 1.63 School 5.23 5.23 School 2.3 2.3 High 3.33 5.96 School 3.65 3.65 5.65 5.65 3.57 3.57 3.57 Unified Elementary 1.42 3 3 4.5 TANS are value. as Listing GlendaleUHSD Valley ParadiseValieyUSD Union PhoenixUHSD Elementary RiversideESD RiversideESD RiversideESD RiversideESD WashingtonESD WashingtonESD WashingtonESD WashingtonESD BONDS Unified ChandlerUSD ChandlerUSD Unified DysartUSD DysarLUSD Union GlendaleUHSD Elementary KyreneESD Unified PeoriaUSD PeoriaUSD Elementary PhoenixESD PhoenixESD PhoenixESD PhoenixESD PhoenixESD Creek QueenCreekUSD QueenCreekUSD RiversideESD RiversideESD RiversideESD RiversideESD SCHOOL values fair market applied. Paradise Phoenix Riverside Washington REFUNDING Chandler Dysart Glendale Kyrene Peoria Phoenix Queen Riverside TANS is value amortization Detail COUNTY TANS and fair Labels Bonds Income Portfolio Status Row School Fixed Straight-line Hoskins Treasurer ACCRUAL $135,392.13 $135,392.13 $105,304.99 $105,304.99 $105,304.99 $105,304.99 $45,130.71 $45,130.71 $60,174.28 $60,174.28 $37,608.92 $37,608.92 $111,322.42 $111,322.42 $45,130.71 $45,130.71 $3,008.71 $3,008.71 $36,104.57 $36,104.57 $16,121,927.87 DAYS. in YEARS. in " "Hos treasurer.maricopa.gov displayed displayed INTEREST (WAN!) Charles 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 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 $3,320,897,043.06 MARKET 35-323 ,$ Treasurer ARS TO Report $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 $3,674,629,860.32 PURSUANT PRINCIPAL County 5 Portfolio RESTRICTED Maricopa $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 $3,669,927,000_00 INVESTMENTS PAR ALL 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 165 COUNT Active District District 07119/2017 District District District 07/19/2017 District cost. 11130/2016 District 07/19/2017 District 07119/2017 District 07/19/2017 School 07/19/2017 School 1.07 School 07/19/2017 District 07/1912017 School 07/19/2017 School 1.07 School 07/19/2017 amortized of School 1.07 School 1.07 School 1.07 High 1.07 Unified Elementary 1.07 School 1.07 1.07 Unified Elementary 1.07 are value. as Unified ChandlerUSD Unified DeerValleyUSD Unified Union GlendaleUHSD Valley ParadiseValleyUSD PendergastESD Unified Elementary RooseveltESD Mountain SaddleMountainUSD VVashingtonESD values fair market applied. Listing Chandler Valley Gilbert GithertUSD Glendale Paradise Pendergast Peoria PeorlaUSD Roosevelt Saddle Washington TANS is value Detail Deer and fair amortization Labels Total Bonds Income Portfolio Status Row Grand School Fixed Straight-line