Extracted text (via pymupdf_layout)
23141 characters
Charles B. Hoskins, Treasurer 301 West Jefferson St., Rm. 100 Phoenix, Arizona 85003 Phone: (602) 506-851.1 Fax: (602) 506-1102 http://trcasurer.maricopa.gov Maricop a County Treasurer DATE: August 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 July 2016 Secured property tax collections during the month of July equaled $15,711,004 and increased the 2015 year to date collections to $4,299,097,355 or 98.9% of the adjusted 2015 levy of $4,347,691,297. The chart below reflects the 2015 collected and uncollected levy amount and corresponding percentages for the 2015 property tax year. JULY 2016 Collected Levy $4,299,097,355 98.9% Uncollected Levy $48,593,942 1.1% [I Collected Levy 1.1 Uncollected Levy The County's General Fund Balance totaled $36,297, 411.98 effective July 31,2016. Warrants outstanding of $645,073.66 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 Mar icopa County Treasurer STATE OF ARIZONA ) ss. COUNTY OF MARICOPA ) This instrument was acknowledged before me this 15th day of August 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. incH c9cQ My Commission Exipires Ag, TAMMY L GONZALES Notary Public - Arizona Maricopa County My Comm. Expires May 28, 20# 8 Hoskins Treasurer 0.60 0,55 0.55 1.24 0.27 0.62 0.83 1.06 1.27 0.96 0.60 DAYS. YEARS. DURATION in in "Hos" treasurer.maricopa.gov displayed displayed WAM 403 404 404 678 101 861 309 391 475 355 403 (WAM) Duration Charles YTM 0.72% 0.70% 0.70% 0.93% 0.41% 1.13% 0.74% 0.92% 1.14% 0.82% 0.72% 0.35% 0.45% 0.86% Weighted-Average-Maturity Index Index Index $3,272,296,711 $2,939,374,305 $2,939,374,305 $478,685,035 $1,532,249,768 $768,136,768 $160,302,734 $332,922,406 $104,862,756 $228,059,650 $3,272,296,711 Agency FAIR Treasury Treasury Active SCHOOL DISTRICT 10% Active USGN 5% US US US Month Year Year BENCHMARKS 0-1 1-3 $3,270,820,976 $2,937,012,862 $2,937,012,862 $478,430,348 $1,531,334,293 $767,328,300 $159,919,922 $333,808,115 $105,748,465 $228,059,650 $3,270,820,976 1-3 Lynch Lynch Allocation Treasurer PRINCIPAL Lynch Merrill Merrill Merrill Report BofA BofA Issuer BofA County Portfolio $3,266,004,000 $2,940,184,000 $2,940,184,000 $478,590,000 $1,534,169,000 $767,425,000 $160,000,000 $325,820,000 $98,320,000 $227,500,000 $3,266,004,000 Active GOVT AGENCY 85% PAR Amount Face of Maricopa Sum TOTAL 100.00% 90.02% 90.02% 14.66% 46.97% 23.50% 4.90% 9.98% 3.01% 6.97% 100,00% 07/29/2016 OF of % Count 144 108 108 22 48 33 36 26 10 144 Count 6 6 1 1 4 54 49 13 11 9 16 5 5 36 36 48 48 8 5 34 1 144 as Active Active cost. Disclosures BANK BANK BANK BANK NT NT NT amortized Risk BONDS TANS CREDIT LOAN CREDIT LOAN NOTE DISCOUNT DISCOUNT DISCOUNT are valves value. NOTES TREASURY SCHOOL SCHOOL FARM HOME MAC FARM HOME MAC N/B DISTRICT DISCOUNT CRD LN MAC fair market is applied. Investment INCOME DISCOUNT AGENCY AGENCY MAE TREASURY AGENCY FARM HOME TANS value amortization Available-for-Sale FIXED BONDS NOTES US Hold-to-Maturity COUNTY COUNTY Ratings FEDERAL FEDERAL FREDDIE FANNIE FEDERAL FEDERAL FREDDIE rated) FANNIE FED FED FREDDIE Total and fair 40 Total GOVT GOVT USGN US (not SCHOOL GOVT Bonds Income GASB Status PhirtfidO POOL Grand Status Credit AA+ Aaa NR P-1 Grand School Fixed Straight-fine Hoskins Treasurer DAYS. in YEARS. in " "Hos treasurer.maricopa.gov LOSS) $2,361,443 $2,361,443 $2,361,443 $254,687 $915,476 $808,468 $382,813 $0 $0 $0 $2,361,443 ACCRUAL $12,002,766 $7,042,027 $7,042,027 $1,703,837 $718,771 $3,819,352 $800,067 $4,960,739 $4,794,462 $166,277 $12,002,766 displayed (VVAM) displayed Charles GAIN/( Duration INTEREST UNREALIZED Weighted-Average-Maturity $0 $0 $0 MARKET $2,939,374,305 $2,939,374,305 $2,939,374,305 $478,685,035 $1,532,249,768 $768,136,768 $160,302,734 $2,939,374,305 AMORTIZATION $3,269,954,339 $2,937,031,934 $2,937,031,934 $478,465,829 $1,531,334,293 $767,335,750 $159,896,062 $332,922,406 $104,862,756 $228,059,650 $3,269,954,339 Treasurer FAIR $3,272,296,711 $2,939,374,305 $2,939,374,305 $478,685,035 $1,532,249,768 $768,136,768 $160,302,734 $332,922,406 $104,862,756 $228,059,650 $3,272,296,711 PRINCIPAL $3,270,820,976 $2,937,012,862 $2,937,012,862 $478,430,348 $1,531,334,293 $767,328,300 $159,919,922 $333,808,115 $105,748,465 $228,059,650 $3,270,820,976 Report County 07/29/2016 2 Portfolio of as PRINCIPAL $3,270,820,976 $2,937,012,862 $2,937,012,862 $478,430,348 $1,531,334,293 $767,328,300 $159,919,922 $333,808,115 $105,748,465 $228,059,650 $3,270,820,976 PAR $3,266,004,000 $2,940,184,000 $2,940,184,000 $478,590,000 $1,534,169,000 $767,425,000 $160,000,000 $325,820,000 $98,320,000 $227,500,000 $3,266,004,000 Maricopa Reporting & COUNT 144 108 108 22 48 33 5 36 26 10 144 COUNT 144 108 108 22 48 33 5 36 26 10 144 Accounting Active Active investment NOTES BONDS TANS NOTES BONDS TANS cost. 31 INCOME TREASURY SCHOOL SCHOOL INCOME TREASURY SCHOOL SCHOOL 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. GASS Status 'Portfolio POOL Grand Status Portfolio POOL Grand fair TANS market is value applied. and fair amortization Bonds Income Straight-line School Fixed Hoskins " "Hos Treasurer treasurer.maricopa.gov ACCRUAL $12,002,766.33 $7,042,026.97 $7,042,026.97 $1,703,836.81 $875,481.25 $123,550.00 $81,666.67 $69,682.50 $163,454.86 $226,950.00 $157,527.78 $17,000.00 $13,499.44 $13,777.78 $7,000.00 $1,372.22 $828,355.56 $111,944.44 $144,783.33 $279,166.67 $156,905.56 $53,020.83 $36,666.67 $25,618.06 $11,250.00 $0.00 $718,770.89 $151,099.34 $23,507.69 $14,647.07 $37,549.55 $22,309.74 $18,081.70 $10,183.05 $24,820.65 $85,007.80 $36,473.86 $10,529.23 $38,004.72 $472,301.16 $38,196.34 $61,000.81 $16,744.38 $21,366.22 $22,598.28 $19,062.20 $20,356.00 $18,571.30 DAYS. in displayed YEARS. in displayed Charles INTEREST (WAM) Duration LOSS ($331,446,671.33) $2,361,443.27 $2,361,443.27 $254,687.50 ($39,032.50) $12,960.00 ($18,600.00) $5,940.00 $1,000.00 $1,500.00 $20,000.00 ($12,500.00) $16,567.50 ($62,500.00) ($3,400.00) ($0.00) $293,720.00 ($16,400.00) $16,500.00 $15,500.00 $101,800.00 $61,500.00 $44,000.00 $58,820.00 $12,000.00 $0.00 $915,475.52 $240,962.85 $21,233.33 $14,851.11 $83,570.00 $28,105.78 $29,758.89 $19,736.24 $43,707.50 $117,749.44 $40,110.00 $17,706.11 $59,933.33 $557,245.73 $37,887.50 $61,772.22 $16,631.94 $21,485.00 $23,868.33 $20,317,36 $25,208.33 $20,610.44 Weighted-Average-Maturity GAIN UNREALIZED MARKET $2,939,374,305.15 $2,939,374,305.15 $2,939,374,305.15 $478,685,035.00 $291,492,485.00 $30,001,500.00 $29,981,400.00 $13,504,185.00 $24,991,500.00 $30,001,500.00 $20,000,000.00 $24,987,500.00 $22,090,000.00 $24,937,500.00 $45,000,000.00 $25,997,400.00 $187,192,550.00 $19,983,600.00 $29,985,300.00 $25,015,500.00 $20,101,800.00 $15,061,500.00 $20,037,000.00 $17,017,850.00 $19,990,000.00 $20,000,000.00 $1,532,249,768.03 $237,842,751.20 $34,987,633.33 $19,989,773.33 $29,883,686.67 $31,980,128.00 $19,962,870.00 $11,451,939.86 $89,586,720.00 $156,216,686.67 $26,870,850.00 $9,983,453.33 $119,362,383.33 $1,093,268,975.16 $44,998,700.00 $79,994,488.89 $24,999,131.94 $29,998,685.00 $29,997,560.00 $24,997,550.00 $24,997,395.83 $23,697,437.11 Treasurer Report PRINCIPAL $3,270,820,976.48 $2,937,012,861.88 $2,937,012,861.88 $478,430,347.50 $291,531,517.50 $29,988,540.00 $30,000,000.00 $13,498,245.00 $24,990,600.00 $30,000,000.00 $19,980,000.00 $25,000,000.00 $22,073,432.50 $25,000,000.00 $45,003,400.00 $25,997,400.00 $186,898,830.00 $20,000,000.00 $29,968,800.00 $25,000,000.00 $20,000,000.00 $15,000,000.00 $19,993,000.00 $16,959,030.00 $19,978,000.00 $20,000,000.00 $1,531,334,292.51 $237,601,788.35 $34,966,400.00 $19,974,922.22 $29,800,116.67 $31,952,022.22 $19,933,111.11 $11,432,203.63 $89,543,012.50 $156,098,937.22 $26,830,740.00 $9,965,747.22 $119,302,450.00 $1,092,711,729.44 $44,960,812.50 $79,932,716,67 $24,982,500.00 $29,977,200.00 $29,973,691.67 $24,977,232.64 $24,972,187.50 $23,676,826.67 County 1 Portfolio Maricopa PAR $3,266,004,000.00 $2,940,184,000.00 $2,940,184,000.00 $478,590,000.00 $291,590,000.00 $30,000,000.00 $30,000,000.00 $13,500,000.00 $25,000,000.00 $30,000,000.00 $20,000,000.00 $25,000,000.00 $22,090,000.00 $25,000,000.00 $45,000,000.00 $26,000,000.00 $187,000,000.00 $20,000,000.00 $30,000,000.00 $25,000,000.00 $20,000,000.00 $16,000,000.00 $20,000,000.00 $17,000,000.00 $20,000,000.00 $20,000,000.00 $1,534,169,000.00 $238,469,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 $90,000,000.00 $157,000,000.00 $27,000,000.00 $10,000,000.00 $120,000,000.00 $1,093,700,000.00 $45,000,000.00 $80,000,000.00 $25,000,000.00 $30,000,000.00 $30,000,000.00 $25,000,000.00 $26,000,000.00 $23,700,000.00 COUNT 144 108 108 22 12 1 1 1 1 1 1 1 1 1 2 1 10 1 1 1 1 1 1 1 1 2 48 8 1 1 1 1 1 1 2 $ 1 1 3 34 1 2 1 1 1 1 1 1 Active 07129/2016 BANK BANK NOTE NT DISCOUNT NT cost. of CREDIT 09106/2016 01113/2017 10103/2016 07/30/2018 08/02/2018 05/04/2018 07/0512019 01/07/2019 01/13/2020 03/22/2018 06/27/2019 LOAN 12/19/2015 06/30/2017 08/24/2018 12/28/2018 12128/2018 05/23/2018 06129/2018 10/11/2019 04/26/2019 DISCOUNT 09/07/2016 09/1912016 05/17/2017 10/06/2016 01/03/2017 12/29/2016 06/30/2017 05/12/2017 12/22/2016 06/29/2017 DISCOUNT 08/02/2016 008/08/2016 08/03/2016 008/04/2016 08/10/2016 08/12/2016 008/23/2016 008/15/2015 amortized as Listing INCOME FARM FEDERAL 0.42 FFCB 0.5 FFCB 0.57 FFCB 0.875 FFCB 1.02 FFCB 1.07 FFCB 1.02 FFCB 1 FFCB 1.24 FFCB 0.8 FFCB 0.95 FFCB HOME FEDERAL 0.65 FHLB 0.73 FHLB 1.2 FHLB 1.33 FHLB 1.25 FHLB 1 FHLB 0,875 FHLI3 1.125 FHLB 1.1 FHLB NOTES 0 FNMDN 0 FNIVIDN 0 FNMDN 0 FNMDN 0 FNMDN 0 FNMON 0 FNMDN CRC FARM 0 FFCBDN 0 FFCBDN 0 FFCBDN LN HOME 0 FHLBDN FHLBDN FHLBDN FHLBDN 0 FHLBDN 0 FHLBDN FHLBDN FHLBDN are values value. market applied. Detail Available-for-Sale FIXED BONDS DISCOUNT FANNIE FED FED fair TANS is value amortization Portfolio Status Labels Row POOL and Bonds fair income School Fixed Straight-line Hoskins "Hos" Treasurer treasurermaricopa.gov ACCRUAL $32,061.47 $24,307.49 $21,517.15 $13,665.42 $10,569.63 $14,035.55 $11,392.85 $10,886.71 $16,486.68 $8,817.25 $7,336.99 $9,333.03 $11,081.95 $8,059.05 $8,189.76 $7,585.21 $12,821.39 $6,307.52 $4,611.55 $8,393.27 $2,331.53 $3,765.19 $848.00 $10,362.58 $10,362.58 $3,819,352.08 $1,210,529.86 $185,329.86 $210,937.50 $122,283.33 $325,850.00 $193,750.00 $76,041.67 $35,777.78 $20,565.67 $22,800.00 $12,395.83 $2,083.33 $1,875.00 $738.89 $2,608,822.22 $106,479.17 $185,888.89 $246,197.22 $221,666.67 $175,000.00 $330,000.00 $100,333.33 $293,750.00 DAYS. in displayed YEARS. in displayed Charles INTEREST (WAM) Duration LOSS 937,100.00 $28,554.17 $24,965.00 $15,296.67 $12,322.22 $15,656.67 $11,833.33 $14,270.83 $23,700.00 $11,366.57 $9,457.64 $19,216.67 $16,984.72 $10,733.33 $6,885.89 $11,244.45 $17,441.67 $7,052.22 $5,293.33 $17,416.67 $3,047.22 $5,522.22 $4,100.00 ($482.50) ($482.50) $808,467.75 $342,350.00 $204,250.00 $0.00 $21,750.00 $42,700,00 $29,550.00 $50,400.00 $0.00 $34,800.00 $60,900.00 ($52,500.00) ($37,500.00) ($12,000.00) $0.00 $466,117.75 $15,600.00 $19,750.00 $49,057.75 $33,000.00 $14,400.00 $37,600.00 ($8,400.00) $13,600.00 Weighted-Average-Matunly GAIN UNREALIZED $39,991,600.00 $34,997,083.33 $29,992,715.00 $29,995,146.67 $24,994,377.78 $34,991,273.33 $29,995.556.67 $24,990,131.94 $39,983,200.00 $29,990,512.50 $24,992,475.00 $19,907,688.89 $34,980,429.17 $39,986,965.67 $39,979,588.89 $39,952,777.78 $69,956,036.11 $39,980,530.00 $29,987,960.00 $64,972,916.67 $24,985,172.22 $39,968,111.11 $19,985,766.67 $44,921,355.00 $44,921,355.00 $768,136,767.75 $305,200,400.00 $25,092,500.00 $25,000,000.00 $15,006,750.00 $35,042,700.00 $15,029,550.00 $30,050,400.00 $20,000,000.00 $20,019,600.00 $30,060,900.00 $24,947,500.00 $24,962,500.00 $19,988,000.00 $20,000,000.00 $462,936,367.75 $15,015,600.00 $25,019,750.00 $47,474,067.75 $30,033,000.00 $20,014,400.00 $40,037,600.00 $9,991,600.00 $20,011,600.00 MARKET Treasurer Report 939,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 $34,953,444.44 $39,976,233.33 $39,972,700.00 $39,971,533.33 $69,938,594.44 $39,973,477.78 $29,982,666.67 $64,955,500.00 $24,982,125.00 $39,962,588.89 $19,981,666.67 $44,921,837.50 $44,921,837.50 $767,328,300.00 $304,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,984,800.00 $30,000,000.00 $25,000,000.00 $25,000,000.00 $20,000,000.00 $20,000,000.00 $462,470,250.00 $15,000,000.00 $25,000,000.00 $47,425,000.00 $30,000,000.00 $20,000,000.00 $40,000,000.00 $10,000,000.00 $19,998,000.00 County PRINCIPAL 2 Portfolio Maricopa $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 $35,000,000.00 $40,000,000.00 $40,000,000.00 $40,000,000.00 $70,000,000.00 $40,000,000.00 $30,000,000.00 $65,000,000.00 $25,000,000.00 $40,000,000.00 $20,000,000.00 $45,000,000.00 $45,000,000.00 $767,425,000.00 $305,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 $30,000,000.00 $25,000,000.00 $25,000,000.00 $20,000,000.00 $20,000,000.00 $462,425,000.00 $15,000,000.00 $25,000,000.00 $47,425,000.00 $30,000,000.00 $20,000,000,00 $40,000,000.00 $10,000,000.00 $20,000,000.00 PAR COUNT 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 1 1 2 1 1 1 1 1 33 13 1 1 1 1 1 1 1 1 1 1 1 1 1 20 1 1 2 1 1 2 1 1 Active 07/29/2016 of 08126/2016 008/18/2016 008/29/2016 08/2412016 08/30/2016 008131/2015 08/17/2015 09/16/2016 09/21/2016 09/12/2016 09/09/2016 06/29/2017 10/03/2016 09/13/2016 09/22/2016 009/29/2016 10/07/2016 009/26/2016 09/15/2016 09/27/2016 10/05/2016 10/19/2016 010/21/2015 NT DISCOUNT 12/23/2016 10/26/2017 10/29/2018 11/16/2018 05/03/2019 09/19/2018 05/16/2019 1.406/13/2019 06/28/2019 07/05/2019 07/12/2019 07/26/2019 07/26/2019 01128/2020 04/26/2018 04/27/2018 07/27/2018 05/03/2018 06/29/2018 10/29/2018 09/28/2018 05/25/2018 cost. amortized as 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 MAC 0 MAE 0.875 1.125 1,16 1.26 1.5 1.25 1.2 1.14 1.05 1 1.125 1.33 MAC 0.95 1 1 1 1.05 1.1 1.2 1.25 are values value, Listing FHLBDN FHLBDN FHLBDN FHLBDN FHLBDN FHLBDN FHLBDN FHLBDN FHLBDN FHLBDN FHLBDN FHLBDN FHLBDN FHLBDN FHLBDN FHLBDN FHLBDN FHLBDN FHLBDN FHLBDN FHLBDN FHLBDN FHLBDN FREDDIE FREDN FANNIE FNMA FNMA FNMA FNMA FNMA FNMA FNMA FNMA FNMA FNMA FNMA FNMA FNMA FREDDIE FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC fair market applied. Detail Labels NOTES TANS and is value fair amortization Portfolio Status Row Bonds Income Straight-line School Fixed Hoskins Treasurer DAYS. in YEARS. in " "Hos treasurer.maricopa.gov ACCRUAL $338,541.67 $110,600.00 $78,333.33 $97,500.00 $96,316.67 $57,604.17 $73,958.33 $53,263.89 $24,266.67 $17,222.22 $800,067.19 $800,067.19 $271,720.47 $281,986.83 $130,425.82 $115,934.07 $4,960,739.37 $4,794,462.33 $1,209,025.05 $48,599.31 $9,570.00 $9,370.63 $5,694.47 $6,406.28 $17,557.94 $674,402.90 $12,809.03 $55,039.57 $605,554.20 $182,899.44 $182,899.44 $94,956.88 $94,956.88 6208,166.53 $42,564.44 $23,124.58 $57,174.17 $85,303.33 $3,585,437,29 $326,474.03 $6,690.04 $319,783.99 $347,599.00 $177,123.00 $170,476.00 $797,237.15 $797,237.15 $516,667.43 $516,667.43 displayed displayed Charles INTEREST (WAM) Duration LOSS $134,250.00 $13,200.00 0,800.00 $39,600.00 $1,800.00 $0.00 $14,750.00 $30,000.00 $47,100.00 $0.00 $382,812.50 $382,812.50 $15,625.00 $30,078.13 $202,734.38 $134,375.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $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 $1 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 MARKET $25,211,500.00 $20,013,200.00 820,010,800.00 $30,039,600.00 $30,001,800.00 $25,000,000.00 $25,014,750.00 $25,000,000.00 $30,047,100.00 $25,000,000.00 $160,302,734.38 $160,302,734.38 $75,079,101.56 $35,061,523.44 $30,055,078.13 $20,107,031.25 Treasurer Report $25,077,250.00 $20,000,000.00 $20,000,000.00 $30,000,000.00 $30,000,000.00 $25,000,000.00 $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,063,476.56 $35,031,445.31 $29,852,343.75 $19,972,656.25 $333,808,114.60 $105,748,464.60 $44,950,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 $16,862,062.25 $9,515,000.00 $9,515,000.00 $5,076,337.50 $5,076,337.50 $9,500,000.00 $2,000,000.00 $1,500,000.00 $3,000,000.00 $3,000,000.00 $60,798,043.20 $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,481.00 $6,677,509.30 $6,677,509.30 County PRINCIPAL 3 Portfolio Maricopa $25,000,000.00 $20,000,000.00 $20,000,000.00 $30,000,000.00 $30,000,000.00 $25,000,000.00 $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 $325,820,000.00 $98,320,000.00 $44,835,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 $16,775,000.00 $9,515,000.00 $9,515,000.00 $5,070,000.00 $5,070,000.00 $9,500,000.00 $2,000,000.00 $1,500,000.00 $3,000,000.00 $3,000,000.00 $53,485,000.40 $3,660,000.00 $75,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 PAR COUNT 1 1 1 5 2 1 36 26 14 5 1 3 4 12 2 1 1 2 1 1 1 Active 07/29/2016 District School 07/01/2017 1.9807/01/2018 07/01/2017 07/01/2018 07/01/2019 District School 07101/2017 07/01/2017 07/01/2018 District School 07/01/2017 1 District School 07/01/2017 District School 07/01/2017 07/01/2018 07/01/2019 07/01/2018 District 01/01/2018 07/01/2017 District 01101/2018 07/01/2017 District School 07/01/2017 District 06/14/2017 cost of 06/22/2018 02126/2019 12108/2017 04129/2019 05/0312019 05/10/2018 11/18/2019 06/24/2019 06/2712018 12/28/2017 N/B 12/31/2016 06/30/2017 12/31/2017 BONDS BONDS Elementary 1.98 2.29 2.29 2.29 High 1 1.46 1.975 Unified High 0,93 Elementary 1.22 1.27 1.57 1.63 BONDS School 5.23 5.23 School 2.3 2.3 High 3.33 School 5.96 amortized as Listing 1.25 FHUVIC 1.3 FHLMC 1 FHLMC 1.3 FFILMC 1,33 FHLMC 1.05 FHLMC 1.5 FHLMC 1.3 FHLMC 0.91 FHLMC 0.8 FHLMC TREASURY TREASURY 0.625 10.75 0.75 12/31/2017 1 SCHOOL IMPROVEMENT CartwrighESID CartwrighESD CartwrightESD CartwrightESD CartwrightESD Union GlendaleUHSD GlendaieUHSD GlendafeUHSD Valley ParadiseValleyUSD Union PhoenixUHSD Washington VVashingtonESD VVashingtonESD WashingtonESD VVashingtonESD Unified ChandlerUSD ChandlerUSD Unified DysartUSD DysartUSD Union GlendaleUHSD Elementary KyreneESD are values value. market Detail US US T T Hold-to-Maturity COUNTY Cartwright Glendale Paradise Phoenix REFUNDING Chandler Dysart Glendale Kyrene fair TANS is applied. Labels and value fair amortization Portfolio Status Row Bonds Income Straight-line School Fixed Hoskins Treasurer DAYS. in YEARS. " "Hos rreasurermaricopa.gov ACCRUAL $737,300.00 $528,398.33 $208,901.67 $772,356.57 $403,764.69 $368,591.88 $87,803.10 $22,100.10 $65,703.00 $166,277.03 $166,277.03 $8,205.58 $8,205.58 $6,382.12 $6,382.12 $6,382.12 $6,382.12 $2,735.19 $2,735.19 $3,646.93 $3,646.93 $2,279.33 $2,279.33 $6,746.81 $6,746.81 $127,528.44 $127,528.44 $182.35 $182.35 $2,188.16 $2,188.15 $12,002,766.33 displayed in displayed Charles INTEREST (WAM) 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 $0.00 $0.00 $0.00 Weighted-Average-Maturity LOSS ($331,446,671.33) 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 $2,939,374,305.15 MARKET Treasurer Report $13,442,424.00 $9,656,252.00 $3,786,172.00 $9,682,587.50 $5,100,696.50 $4,581,891.00 $1,627,741.10 $411,636.10 $1,216,105.00 $228,059,650.00 $228,059,650.00 $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,270,820,976.48 County PRINCIPAL 4 Portfolio Maricopa $12,000,000.00 $8,600,000.00 $3,400,000.00 $8,015,000.00 $4,190,000.00 $3,825,000.00 $1,470,000.00 $370,000.00 $1,100,000.00 $227,500,000.00 $227,500,000.00 $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,266,004,000.00 PAR 2 1 1 2 1 1 2 1 1 10 10 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 144 COUNT Active District District 01/01/2018 07/01/2017 District District District 07/19/2017 District District District 07/19/2017 District 07/19/2017 07/29/2016 District 01101/2018 07/01/2017 School 01/0112018 07/01/2017 School District 07/19/2017 07/19/2017 District 07119/2017 School 07/19/2017 School 1.07 School 0711912017 District 07/19/2017 School 07/19/2017 School 1.07 School cost of School 3.65 3.65 5.65 5.65 Unified 3.62 3.62 TANS School 1.07 School 1.07 School 1.07 High 1.07 Unified Elementary 1.07 School 1.07 Elementary 1.07 Unified Elementary 1.07 amortized as Unified PeoriaUSD PeoriaUSD Elementary PhoenixESD PhoenixESD Creek QueenCreekUSD QueenCreekUSD SCHOOL Unified ChandlerUSD Unified Valley DeerValleyUSD Unified GilbertUSD Union GlendaleUHSD Valley ParadiseValleyUSD PendergastESD Unified PeoriaUSD RocseveltESD Mountain SaddleMountainUSD WashingtonESD are values value. Listing Peoria Phoenix Queen Chandler Deer Gilbert Glendale Paradise Pendergast Peoria Roosevelt Saddle Washington fair market applied. Detail COUNTY TANS TANS is value Labels Total and fair amortization Portfolio Status _Row Grand Bonds Income School Fixed Straight-line