NOVEMBER REPORT.PDF

Maricopa County — Formal (2017-01-11)

View PDF Item 25 Meeting page

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