JUNE 2016.PDF

Maricopa County — Formal (2016-10-05)

View PDF Item 20 Meeting page

Extracted text (via pymupdf_layout) 24320 characters
Charles B. Hoskins, Treasurer
301 West Jefferson St., Rm. 100
Phoenix, Arizona 85003
Phone: (602) 506-8511
Fax: (602) 506-1102
http://treasurer.maricopa.gov
Maricopa County
Treasurer
DATE: July 21, 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 June 2016
Secured property tax collections during the month of June equaled $83,960,664 and
increased the 2015 year to date collections to $4,283,386,351 or 98.5% of the adjusted 2015
levy of $4,348,413,293. The chart below reflects the 2015 collected and uncollected levy
amount and corresponding percentages for the 2015 property tax year.
JUNE
2016
Collected Levy
$4,283,386,351
98.5%
Uncollected Levy
$65,026,942 1.5%
&Collected Levy •Uncollected Levy
The County's General Fund Balance totaled $50,266,921 effective June 30, 2016. Warrants
outstanding of $12,245,707 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.
Submitted under oath,
Charles Hoskins,
Maricopa County Treasurer
STATE OF ARIZONA ) ss.
COUNTY OF MARICOPA )
This instrument was acknowledged before me this 15th day of July 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.
,
Notary Public My Commission Expires
-
KAREN D. SMITH
Notary Public - Arizona
. • k Maricopa County
My Comm. Expires Dec 15, 2017

Hoskins Treasurer DAYS. YEARS.
" 0.39 0.40 0.40 0.56 0.18 0.59 0.91 0.38 0.96 0.04 0.39 in in
"Hos Creasurer.maricopa.gov DURATION' displayed displayed
Charles WANI 342 369 369 547 67 835 338 145 363 15 342 (WAM) Duration
Weighted-Average-Maturity
MIL 0.70% 0.69% 0.69% 0.93% 0.37% 1.14% 0.74% 0.74% 1.02% 0.57% 0.70% 0.35% 0.41% 0.79%
473 Index Index Index
$3,068,561,473 $2,691,481,968 $2,691,481,968 $382,686,995 $1,385,177,928 $763,211,576 $160,405,469 $377,079,505 $146,040,135 6231,039,370 561 Active SCHOOL DISTRICT 12% Active USGN 5%
FAIR $3,068 Treasury Treasury Agency
US US US
BENCHMARKS Month Year Year Allocation
Treasurer $3,067,210,309 $2,688,715,780 $2,688,715,780 $382,143,115 $1,384,324,443 $762,328,300 $159,919,922 $378,494,529 $147,455,159 $231,039,370 $3,067,210,309 1-3 0-1 1-3 Lynch
PRINCIPAL Lynch Lynch
Report Merrill Merrill Issuer
Merrill
County 000 BofA BofA BofA Amount 1
Portfolio $3,057,703,000 $2,690,853,000 $2,690,853,000 $382,259,000 $1,386,169,000 $762,425,000 $160,000,000 $366,850,000 $136,350,000 $230,500,000 703 Face
PAR $3,057 of Active GOVT AGENCY 83%
Sum
Maricopa
TOTAL 100.00% 88.00% 88.00% 12.50% 45.33% 24.93% 6.23% 12.00% 4.46% 7.54% 100.00%
06/30/2016 OF
%
of Count 153 103 103 19 46 33 5 50 39 11 153 Count 7 7 1 2 4 50 45 8 8 8 21 6 5 50 50 46 46 3 34 153
as Active Active
Disclosures BANK BANK NT NT cost.
BANK BANK amortized
Risk BONDS TANS CREDIT LOAN CREDIT LOAN NOTE DISCOUNT DISCOUNT
NOTES NIB are value.
INCOME TREASURY SCHOOL SCHOOL FARM HOME MAC MAE FARM HOME MAC DISTRICT DISCOUNT CRD LN values market applied.
Investment Available-for-Sale BONDS DISCOUNT NOTES US Hold-to-Maturity COUNTY COUNTY AGENCY FEDERAL FEDERAL FREDDIE AGENCY FANNIE FEDERAL FEDERAL FREDDIE TREASURY rated) AGENCY FANNIE FARM HOME fair TANS is
40 FIXED Total Ratings GOVT GOVT USGN US (not SCHOOL GOVT FED FED Total and value fair amortization
GASB Status 'Portfolio POOL Grand Status Credit AA+ Aaa NR P-1 Grand Bonds Income
School Fixed Straight-line

Hoskins Treasurer DAYS in YEARS. in
" "Hos treasurermaricopa.gov GAINgLOSS). $2,766,188 $2,766,188 $2,766,188 $543,880 $853,485 $883,276 $485,547 $0 $0 $0 766,188 ACCRUAL $15,623,847 $7,641,664 $7,641,664 $2,266,978 $622,164 $4,044,574 $707,948 $7,982,183 $6,726,867 $1,255,316 623,847 displayed (WAM) displayed Duration
Charles $2 $15
INTEREST
UNREALIZED Weighted-Average-Maturity
$0 $0 $0
MARKET $2,691,481,968 $2,691,481,968 $2,691,481,968 $382,686,995 $1,385,177,928 $763,211,576 $160,405,469 $2,691,481,968 AMORTIZATION $3,065,814,357 $2,688,734,852 $2,688,734,852 $382,178,597 $1,384,324,443 $762,335,750 $159,896,062 $377,079,505 $146,040,135 $231,039,370 $3,065,814,357
Treasurer $3,068,561,473 $2,691,481,968 $2,691,481,968 $382,686,995 $1,385,177,928 $763,211,576 $160,405,469 $377,079,505 $146,040,135 $231,039,370 $3,068,561,473 PRINCIPAL $3,067,210,309 $2,688,715,780 $2,688,715,780 $382,143,115 $1,384,324,443 $762,328,300 $159,919,922 $378,494,529 $147,455,159 $231,039,370 $3,067,210,309
Report
County Portfolio 06/30/2016 of PRINCIPAL $3,067,210,309 $2,688,715,780 $2,688,715,780 $382,143,115 $1,384,324,443 $762,328,300 $159,919,922 $378,494,529 $147,455,159 $231,039,370 309 210 067 PAR $3,057,703,000 $2,690,853,000 $2,690,853,000 $382,259,000 $1,386,169,000 $762,425,000 $160,000,000 $366,850,000 $136,350,000 $230,500,000 $3,057,703,000 2
as $3
Maricopa Reporting COUNT 153 103 103 19 46 33 5 50 39 11 153 COUNT 153 103 103 19 46 33 5 50 39 11 153
& Active Active
Accounting
Investment BONDS TANS BONDS TANS
31 INCOME NOTES TREASURY SCHOOL SCHOOL INCOME NOTES TREASURY SCHOOL SCHOOL cost. amortized
Statement 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 are values value.
GASI3 Status Portfolio POOL Grand Status Portfolio POOL Grand fair TANS market is applied.
and value fair amortization
Bonds Income Straight-line
School Fixed

Hoskins Treasurer DAYS. in YEARS. in
" "Hos treasurer.maricopa.gov ACCRUAL $15,523,846.95 $7,641,663.63 $7,641,663.53 $2,266,977,85 $1,267,838.55 $113,400.00 $144,583.33 $63,483.75 $80,465.00 $145,833.33 $200,034.24 $202,300.00 $140,288.89 $177,450.00 $999,139.31 $101,472.22 $127,141.67 $144,375.00 $88,106.67 $255,000.00 $134,477.78 $86,458.33 $47,916.67 $20,555.56 $13,635.42 $622,163.80 $176,983.92 $93,696.30 $12,858.04 $15,760.77 $8,579.00 $21,050.50 $11,154.87 $8,882.24 $5,002.20 $28,419.39 $22,736.95 $5,682.44 $0.00 $416,760.49 $26,115.99 $29,670.38 $23,550.01 $18,068.57 $19,932.78 $26,023.88 $16,921.53 $39,361.49 $13,528.38 displayed displayed
Charles INTEREST (WAM) Duration
Weighted-Averege-Maturity
($375,728,340.67) $2,766,188.33 $2,766,188.33 $543,880.38 $97,100.38 ($7,740.00) ($18,600.00) $5,940.00 $1,155.00 $120,250.00 ($34,354.62) $3,000.00 $22,200.00 $5,250,00 $446,780.00 ($4,600.00) $88,200.00 ($15,750.00) $1,920.00 $41,750.00 $125,400.00 $4,300.00 $51,500.00 $39,000.00 5105,060.00 $853,485.07 $281,380.54 $92,195.83 $12,444.44 $15,017.92 $9,957.78 $81,915.83 $22,018.67 $30,631,67 $17,198.40 $56,046.83 $41,991.00 $10,870.83 $3,185.00 $515,057.70 $27,888.89 $29,254.17 $26,437.64 $18,322.50 $20,771.53 $28,008.75 $17,361.94 $42,063.33 $13,539.17
(LOSS)
GAIN
UNREALIZED
52,691,481,968.13 $2,691,481,968.13 $2,691,481,968.13 $382,685,995.38 $198,308,135.38 $29,980,800.00 $29,981,400.00 $13,504,185.00 $16,501,155,00 $25,110,750.00 $15,724,645.38 $30,003,000.00 $20,002,200.00 $17,500,000.00 $184,378,860.00 $19,995,400.00 $30,057,000.00 $14,995,500.00 $12,001,920.00 $25,041,750.00 $20,125,400.00 $10,004,300.00 $15,061,500.00 $20,032,000.00 $17,064,090.00 $1,385,177,928.00 $233,231,099.44 $59,999,666.67 $24,995,916.67 $34,981,417.92 $19,984,880.00 $29,882,032.50 $31,974,040.89 $19,963,742.78 $11,449,402.03 $71,650,817.39 $26,872,731.00 $9,976,618.06 $34,831,468.33 $1,080,295,011.17 $39,994,888.89 $49,999,670.83 $34,995,914.72 $34,998,868.33 $34,992,650.00 $44,988,821.25 $34,997,625.83 $79,974,780.00 $29,998,605.83
MARKET
Treasurer
Report $3,067,210,308.80 $2,688,715,779.80 $2,688,715,779.80 $382,143,115.00 $198,211,035.00 $29,988,540.00 $30,000,000.00 $13,498,245.00 $16,500,000.00 $24,990,500.00 $15,759,000.00 $30,000,000.00 $19,980,000.00 $17,494,750.00 $183,932,080.00 $20,000,000.00 $29,968,800.00 $15,011,250.00 $12,000,000.00 $25,000,000.00 $20,000,000.00 $10,000,000.00 $15,000,000.00 $19,993,000.00 $16,959,030.00 $1,384,324,442.93 $232,949,718.90 $59,907,470.83 $24,983,472.22 $34,966,400.00 $19,974,922.22 $29,800,116.67 $31,952,022.22 $19,933,111.11 $11,432,203.63 $71,594,770.56 $29,830,740.00 $9,965,747.22 $34,798,283.33 $1,079,779,953.47 $39,967,000.00 $49,970,416,67 $34,969,477.08 $34,980,545.83 $34,971,878.47 $44,960,812.50 $34,980,263.89 $79,932,716.67 $29,985,055.67
County PRINCIPAL
Portfolio
Maricopa $3,057,703,000.00 $2,690,853,000.00 $2,690,853,000.00 $382,259,000.00 $198,259,000.00 $30,000,000.00 $30,000,000.00 $13,500,000.00 $16,500,000.00 $25,000,000.00 $15,759,000.00 $30,000,000.00 $20,000,000.00 $17,500,000.00 $184,000,000.00 $20,000,000.00 $30,000,000.00 $15,000,000.00 $12,000,000.00 $25,000,000.00 $20,000,000.00 $10,000,000.00 $15,000,000.00 $20,000,000.00 $17,000,000.00 $1,386,169,000.00 $233,469,000.00 $60,000,000.00 $25,000,000.00 $35,000,000.00 $20,000,000.00 $30,000,000.00 $32,000,000.00 $20,000,000.00 $11,469,000.00 $72,003,000.00 $27,000,000.00 $10,000,000.00 $35,000,000.00 $1,080,700,000.00 $40,000,000.00 $50,000,000.00 $35,000,000.00 $35,000,000.00 $35,000,000.00 $45,000,000.00 $35,000,000.00 $80,000,000.00 $30,000,000.00
PAR
COUNT 153 '103 103 19 9 1 1 1 1 1 1 1 1 1 10 1 1 1 1 1 1 1 1 1 46 9 2 1 1 1 1 1 1 1 3 1 1 1 34 1 1 1 1 1 1 1 2 1
Active
BANK BANK NT NT
06/30/2016 of CREDIT 09106/2016 01/13/2017 10/03/2016 06/01/2017 07/33/2018 01/02/2018 08/02/2018 05/04/2018 05/18/2018 LOAN 12119/2016 06/30/2017 01/29/2018 05/04/2018 08124/2018 12/28/2015 01/15/2019 12/28/2018 05123/2018 06/29/2018 NOTE 07/01/2016 07/20/2016 09/07/2016 09/19/2013 05/17/2017 10/06/2016 01/03/2017 12/29/2016 DISCOUNT 305/12/2017 12/22/2016 006/29/2017 DISCOUNT 07/20/2016 07/01/2016 07/22/2016 07/06/2016 07/27/2016 008/02/2016 007/11/2016 008/08/2015 007/07/2016 cost. amortized
as Listing FARM FEDERAL. 0.42 FFCB 0.5 FFCB 0.57 FFCB 0.84 FFCB 0.875 FFCB 1.02 FFCB 1.02 FFCB 1.07 FFCB 1.17 FFCB HOME 0.65 FHLB 0.73 FHLB 1.05 F/-/LB 1,12 FHLB 1.2 FHLB 1.33 FHL2 1.45 FHLB 1.25 FHLB 1 FHLB 0.875 FHLB NOTES DISCOUNT 0 FNMDN 0 FNMDN 0 FNMDN 0 FNMDN 0 FNMDN FNMDN 0 0 FNMDN 0 FNMDN CRD FARM FFCBDN 0 FFCBDN FFCBDN LN HOME 0 FHLBDN 0 FHLBON 0 FHLBDN 0 FHLBDN 0 FHLBDN FHLBDN FHLBDN FHLBDN FHLBDN are values value.
Detail Available-for-Sale INCOME BONDS FEDERAL DISCOUNT FANNIE FED FED fair market is applied.
Portfolio Labels POOL FIXED TANS and value fair amortization
Status Row Bonds Income Straight-line
School Fixed

Hoskins Treasurer DAYS. in YEARS. in
" "Hos treasurer.maricopa.gov ACCRUAL $13,291.46 $17,094.67 $10,469,01 $10,597.71 $10,437.05 $18,240.15 $12,514.50 $12,515.97 $10,557.53 $11,132.19 $10,022.61 $17,303.02 $13,118.33 $10,940.93 $6,044.76 $3,603.28 $4,569.71 $3,526.36 $2,791.47 $3,205.74 $826.62 $473.35 $311.10 $4,044,573.61 $990,595.14 $167,708.33 $188,281.25 $108,266.67 $290,325.00 $175,625.00 $45,833.33 $13,222.22 $1,333.33 $3,053,978.47 $95,000.00 $178,472.22 $168,750.00 $342,993.75 $197,500.00 $158,083.33 $294,555.56 $90,666.67 $160,666.57 $273,611,11 $313,368.06 $189,222,22 $199,375.00 $89,555.56 $62,222.22 $66,083.33 $63,175.00 $36,458.33 displayed displayed
Charles INTEREST (WAM) Duration
Weighted-Average-Maturity
$13,336.67 $17,256.67 $10,854.17 $10,133.33 $12,416.25 $23,347.22 $17,900.00 $16,434.17 $14,525.69 $18,437.50 $15,905.33 $27,260.00 $19,655.39 $17,450.00 $8,691.67 $7,354.17 $9,313.89 $6,546.67 $6,751.39 $14,032.22 $2,354.17 $1,944.45 $507.78 $883,276.00 $460,000.00 $224,500.00 ($13,750.00) $35,400.00 $34,650.00 $39,600.00 $50,400.00 $54,400.00 $34,800.00 $423,276.00 $9,600.00 ($113,750.00) $18,000.00 $71,876.00 $21,300,00 $29,000.00 $34,000.00 ($6.900.00) ($120,000.00) $24,000.00 $197,750.00 $4,000.00 $4,200.00 $24,600.00 $12,400.00 $0.00 $33,300.00 $0.00
(LOSS)
GAIN
UNREALIZED
$29,997,470.00 $39,996,173.33 524,997,000.00 $24,992,633.33 $26,996,812.50 $49,993,861.11 $29,995,100.00 $29,990,125.83 $24,991,758.33 $24,990,625.00 $23,692,732.00 $39,981,760.00 $34,988,185.56 $29,955,200.00 $29,988,541.67 $24,989,409.72 $34,984,930.56 $29,990,280.00 $24,982,612.50 $39,973,532.22 $29,981,500.00 $24,984,961.81 $19,888,980.00 $763,211,576.00 $185,318,050.00 $25,112,750.00 $24,986,250.00 $15,020,400,00 $35,034,650.00 $15,039,600.00 $30,050,400.00 $20,054,400.00 $20,019,600.00 $577,893,526.00 $15,009,600.00 $24,981,250.00 $25,018,000.30 $57,496,576.00 $30,021,300.00 $20,029,000.00 $40,034,000.00 $9,993,100.00 $19,880,000.00 $20,022,000.00 $25,275,000.00 $20,004,000.00 $30,004,200.00 $20,024,600.00 $20,012,400.00 $30,000,000.00 $30,033,300.00 $25,000,000.00
MARKET
Treasurer
Report $29,984,133.33 $39,078,916.67 $24,986,145.83 $24,982,500.00 $26,984,396.25 $49,970,513.89 $29,977,200.00 $29,973,691.67 $24,977,232.64 $24,972,187.50 $23,676,826.67 $39,954,500.00 $34,968,529.17 $29,967,750.00 $29,979,850.00 $24,982,055.56 $34,975,616.67 $29,983,733.33 $24,975,861.11 $39,959,500.00 $29,979,145.83 $24,983,017.36 $19,888,472.22 $762,328,300.00 $184,858,050.00 $24,888,250.00 $25,000,000.00 $14,985,000.00 $35,000,000.00 $15,000,000.00 $30,000,000.00 $20,000,000.00 $19,954,800.00 $577,470,250.00 $15,000,000.00 $25,000,000.00 $25,000,000.00 $57,425,000.00 $30,000,000.00 $20,000,000.00 $40,000,000.00 $10,000,000.00 $20,000,000,00 $19,998,000.00 $25,077,250.00 $20,000,000,00 $30,000,000,00 $20,000,000.00 $20,000,000.00 $30,000,000.00 $30,000,000.00 $25,000,000.00
County PRINCIPAL 2
Portfolio
Maricopa $30,000,000.00 $40,000,000.00 $25,000,000.00 $25,000,000.00 $27,000,000.00 $50,000,000.00 $30,000,000.00 $30,000,000.00 $25,000,000.00 $25,000,000.00 $23,700,000.00 $40,000,000.00 $35,000,000.00 $30,000,000.00 $30,000,000.00 $25,000,000.00 $35,000,000.00 $30,000,000.00 $25,000,000.00 $40,000,000,00 $30,000,000.00 $25,000,000.00 $20,000,000,00 $762,425,000.00 $185,000,000.00 $25,000,000.00 $25,000,000.00 $15,000,000.00 $35,000,000.00 $15,000,000.00 $30,000,000.00 $20,000,000.00 $20,000,000.00 $577,425,000.00 $15,000,000,00 $25,000,000.00 $25,000,000.00 $67,425,000.00 $30,000,000.00 $20,000,000.00 $40,000,000.00 $10,000,000.00 $20,000,000.00 $20,000,000.00 $25,000,000.00 $20,000,000.00 $30,000,000.00 $20,000,000.00 $20,000,000.00 $30,000,000.00 $30,000,000.00 $25,000,000.00
PAR
COUNT 1 1 1 1 1 2 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 33 1 1 1 1 1 1 1 1 25 1 1 3 1 1 2 1 1 1 1 1 1 1 1 1 1 1
Active
06/30/2016 07/12/2016 007/14/2018 07/18/2016 008/03/2016 007/25/2016 007/2612016 08/04/2016 08/10/2016 08/12/2016 08/23/2016 08/15/2016 08/26/2016 08/18/2016 08129/2016 08124/2016 08/30/2016 08/31/2016 08/17/2016 09/16/2016 09121/2016 09/12/2016 09/09/2016 06/29/2017 10/26/2017 10/29/2018 11/16/2018 05/03/2019 09/19/2018 05/16/2019 06/13/2019 06/28/2019 04/26/2018 04/13/2018 04/27/2015 07/27/2015 08/03/2018 06/29/2018 10/29/2018 09/28/2018 10/29/2018 05/25/2018 06/22/2018 04/08/2019 07/06/2018 02/26/2019 12)08/2017 04/29/2019 05/03/2019 05/10/2018 cost. amortized
of as LEN 0 0 0 0 0 0 0 0 0 0 LEON 0 LOON 0 0 0 0 0 0 MAE 0.875 1.125 1.16 1.26 1.5 1.25 1.4 1.2 MAC 0.95 1 1 1 1 1.05 1.1 1.2 1.2 1.25 1.25 1.3 1.375 1.3 1 1.3 1.33 1.05 are value
Listing FHLBDN FHLBDN FHLBDN FH FHLBDN FHLBDN FHLBDN FHLBDN FHLBDN FHLBDN FHLBDN FHLBDN FHLBDN FHLBDN FHLBDN FH FIH FHLBDN FHLSDN FHLBDN FHLBDN FHLBDN FHLBDN FANNIE FNMA FNMA FNMA FNMA FNMA FNMA FNMA FNMA FREDDIE Fl-3LMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLAC values market applied.
Detail NOTES fair TANS is value
Portfolio Status Labels Row and Bonds fair Income amortization
School Fixed Straight-fine

Hoskins Treasurer DAYS. in YEARS. in
" "Hos treasurer.maricopa.gov ACCRUAL $43,750.00 $27,083.33 $2,275.00 $1,111.11 $707,948.37 $707,948.37 $234,375.00 $261,073.37 $112,500.00 $100,000.00 $7,982,183.33 $6,726,865.84 $1,273,452.89 560,510.14 $8,804.40 $9,187.20 $8,995.80 $5,017.01 $5,473.10 $6,157.24 $16,875.39 $680,251,05 $14,405.85 $21,225,00 512,184.72 $53,569.83 $578,865.54 $175,234.58 $175,234.58 $157,235.10 $66,076.50 $91,158.60 $3,288.97 $3,288.97 $196,933.06 $40,598.89 521,590.00 $53,380.00 $81,364.17 $5,453,413,94 $545,194.81 $6,374.05 $234,140.56 $304,580.19 $481,137.75 $150,009.95 $168,729.92 $152,397.89 $1,495,003.50 $735,482.30 $759,521.20 $949,709.44 displayed displayed
Charles INTEREST (WAM) Duration
Weighted-Average-Maturity
$31,750.00 $30,000.00 $29,400.00 ($6.250.00) $485,546.88 $485,546.88 $27,343.75 $60,155.25 $237,890.62 $160,155.25 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0,00 $0.00 $0.00 $0.00 $0.00 50.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0,00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $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)
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.30 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$25,031,750.00 $25,000,000.00 $30,029,400.00 $24,993,750.00 $160,405,468.75 $150,406,468.75 $75,090,820.31 $35,091,601.56 $30,090,234.38 $20,132,812.50
MARKET
Treasurer
Report $25,000,000.00 $24,970,000.00 $30,000,000.00 $25,000,000.00 $159,919,921.88 $159,919,921.88 $75,053,476,56 $35,031,445.31 $29,852,343.75 $19,972,656.25 $378,494,529.00 $147,455,159.00 $51,314,647.25 $1,469,575.00 $236,435.40 $245,032.80 $237,876.40 $113,260,20 $123,656.40 $138,221.10 $375,072.70 $21,951,928.00 $850,000.30 $1,362,703.50 $777,162.25 $2,100,000.00 $16,862,052.25 $9,515,000.00 $9,515,000.00 $8,776,217.25 $3,699,879.75 $5,076,337.50 $101,927.00 $101,927,00 $9,500,000.00 $2,000,000.00 $1,500,000.00 $3,000,000.00 $3,000,000.00 $96,140,511.75 $7,472,773.20 $89,799.75 $3,149,626,20 $4,233,347.25 $13,701,987.45 $4,254,814.15 $4,820,690.10 $4,626,483.20 $30,450,881.40 $14,853,420.40 $15,597,461.00 $12,740,226.10
County PRINCIPAL 3
Portfolio
Maricopa $25,000,000.00 $25,000,000.00 $30,000,000.00 $25,000,000.00 $160,000,000.00 $160,000,000.00 $75,000,000.00 $35,000,000.00 $30,000,000.00 $20,000,000.00 $366,850,000.00 $136,350,000.00 $51,150,000.00 $1,440,000.00 $230,000.00 $240,000.00 $235,000.00 $110,000.00 $120,000.00 $135,000.00 $370,000.00 $21,850,000.00 $850,000.00 $1,350,000.00 $775,000.00 $2,100,000.00 $16,775,000.00 $9,515,000.00 $9,515,000.00 $8,745,000.00 $3,675,000.00 $5,070,000.00 $100,000.00 $100,000.00 $9,500,000.00 $2,000,000.00 $1,500,000.00 $3,000,000.00 $3,000,000.00 $85,200,000.00 $6,415,000.00 $75,000.00 $2,755,000.00 $3,585,000.00 $12,935,000,00 84,045,000.00 $4,530,000.00 $4,350,000.00 $27,575,000.00 $13,615,000.00 $14,060,000.00 $10,430,000.00
PAR
COUNT 1 1 5 5 2 1 1 1 SO 39 20 7 1 1 1 1 1 1 1 5 1 1 1 1 1 1 1 2 1 1 1 4 1 1 1 1 19 3 1 1 1 3 1 1 1 2 1 1 2
Active
District School 0710112015 07/01/2017 07101/2018 07/01/2016 07/01/2017 07/01/2018 07/01/2019 District 07101/2016 07/01/2018 07/01/2017 07/01/2017 07/01/2018 District School 07/01/2017 District 07/01/2016 07/01/2017 District School 07/01/2016 District School 07/01/2017 07/01/2018 07/01/2019 07/01/2018 District 01/01/2018 07/01/2016 07/01/2017 District 07/01/2016 District 07/01/2018 07/01/2017 District
06/30/2016 11/1812019 05/24/2019 06/27/2018 12/28/2017 N/B 12/31/2016 BONDS BONDS 1.98 1.98 1.98 2.29 2.29 2.29 2.29 School High 0.97 1 1 1.46 1.975 Unified 1 School High 0.93 0.93 1.67 Elementary 1.22 1.27 1.57 1.63 School 5.23 5.23 5.23 School 2.29 01/01/2018 2.3 07/01/2017 2.3 School High 3,33 3.33 School cost. amortized
as of 1.5 1.3 0.91 0.8 TREASURY 0.625 05/30/2017 12131/2017 12131/2017 SCHOOL Elementary CartwrighESD CartwrighESD CartwrighESD CarlwrightESD htESD CartwrightESD CanwrightESD Union GlendaleUHSD GlendaleUHSO GlendaleUHSE) GlendaleUHSD GlendaleUHS1) Valley ParadiseValleyUSD Union PhoenixUHSD PhoenixUHSD Elementary RiversideESD VVashingtonESD WashingtonESD WashingtonESD WashingtonESD BONDS Unified ChandierUSD ChandIerUSD ChandierUSD Unified DysartUSD DysartUSD DysartUSD Union GlendaleUHSD GlendareUHSD Elementary are value.
Listing FHLMC FHLroc FHLMC FHLMC TREASURY US T 0.75 T 0.75 T 1 T IMPROVEMENT Cartwright Cartwrig Glendale Paradise Phoenix Riverside Washington REFUNDING Chandler Dysart Glendale Kyrene values fair market applied.
Detail Labels US Hold-to-Maturity COUNTY TANS is value amortization
Portfolio Status Row end Bonds fair Income
School Fixed Straight-line

Hoskins Treasurer YE CA in YEARS.
in
"Hos" treasureranaricopa.gov ACCRUAL $490,789.44 $458,920,00 $894,250.63 $192,233.96 $503,111.94 $198,904,72 $993,920.00 $384,894.38 $263,042.81 $351,182.81 $89,197.81 $21,021.14 $5,681.39 $52,495.28 $1,255316.49 $1,255,316.49 $245,072.63 $245,072.63 $163,381.76 $163,381.76 $54,460.59 $54,460.59 $163,381.76 $163,361.76 $70,798.76 $70,798.76 $32,676.35 $32,676.35 $163,381.76 $163,381.76 $68,075.73 $68,075.73 $217,842.34 $217,842.34 $10,892.12 $10,892.12 $65,352.70 $65,352.70 $15,623,846.96 displayed displayed
Charles INTEREST (1NAM) Duration
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 $0.00
($375,728,340.67)
(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 60.00 $0.00 $0.00 $0.00 $0,00 $0.00 $0,00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$2,691,481,968.13
MARKET
Treasurer
Report $6,677,509.30 $6,062,716.80 $17,041,914.95 $3,599,490.95 $9,656,252.00 $3,786,172.00 $12,996,160.55 $5,100,696.50 $3,313,573,05 $4,581,891.00 $1,736,568.10 $411,636.10 $108,827.00 $1,216,105.00 $231,039,370.00 $231,039,370.00 $45,105,300.00 $45,105,300.00 $30,070,200.00 $30,070,200.00 $10,023,400.00 $10,023,400.00 $30,070,200.00 $30,070,200.00 $13,030,420.00 $13,030,420.00 $6,014,040.00 $6,014,040.00 $30,070,200,00 $30,070,200.00 $12,529,250.00 $12,529,250.00 $40,093,600.00 $40,093,600.00 $2,004,680.00 $2,004,680.00 $12,028,080.00 $12,028,080.00 $3,067,210,308.80
County PRINCIPAL 4
Portfolio
Maricopa $5,390,000.00 $5,040,000.00 $15,295,000.00 $3,295,000.00 $8,600,000.00 $3,400,000.00 $10,880,000.00 $4,190,000.00 $2,865,000.00 $3,825,000.00 $1,570,000.00 $370,000.00 $100,000.00 $1,100,000.00 $230,500,000.00 $230,500,000.00 $45,000,000.00 $45,000,000.00 $30,000,000.00 $30,000,000.00 $10,000,000.00 $10,000,000.00 $30,000,000.00 $30,000,000.00 $13,000,000.00 $13,000,000.00 $6,000,000.00 $6,000,000.00 $30,000,000.00 $30,000,000.00 $12,500,000.00 $12,500,000.00 $40,000,000.00 $40,000,000.00 $2,000,000.00 $2,000,000.00 $12,000,000.00 $12,000,000.00 3703,000.00
PAR $3,057
1 1 3 1 1 1 3 1 1 1 1 1 11 11 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 153
COUNT
Active
District 07/15/2016 District District 07/15/2016 District
District 01/01/2018 07/01/2018 07/01/2017 District 01/01/2018 07/01/2016 07/01/2017 District 07/15/2016 District 07/15/2016 District 07/15/2016 School School 07/15/2016 School 0.81 School 07/15/2016
06/30/2016 06/14/2017 07/01/2016 District 07/01/2016 01/01/2018 07/01/2017 School School 3.62 3.62 3.62 School District 07/15/2016 District 07/15/2016 School District 07115/2018 0.81 0.61 District 07/15/2016 0.81 cost.
of 5.96 5,98 School 3.64 3,65 3.65 5.65 5.65 5.65 Unified TANS School 0.81 Unified 0.81 School 0.81 School 0.81 High 0.81 School 0.81 Unified Elementary School 0.81 Unified Elementary amortized
as KyreneESD KyreneESD Unified PeoriaUSD PeorlaUSD PeoriaUSD Elementary PhoenixESD PhoenixESD PhoenixESD Creek QueenCreekUSD QueenCreekUSD QueenCreekUSD SCHOOL Unified ChandlerUSD Valley DeerValleyUSD Unified DysartUSD Unified GiibertUSD Union GlendaleUHSD Unified HigleyUSD Valley ParadiseValleyUSD PendergastESD Unified PeoriaUSD Mountain SaddleMountainUSD WashingtonESD are value.
Listing Peoria Phoenix Queen Chandler Deer Dysart Gilbert Glendale Higley Paradise Pendergast Peoria Saddle Washington values fair market applied.
Detail COUNTY TANS TANS is value
Labels Total and fair amortization
Portfolio Status Row Grand Bonds Income
School Fixed Straight-line