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