Extracted text (via pymupdf_layout)
24512 characters
Charles B. Hoskins, Treasurer 301 West Jefferson St., Rm. 100 Phoenix, Arizona 85003 Phone: (602) 506-8511 Fax: (602) 506-1102 http://trcasurer.maricopa.gov Maricopa County Treasurer DATE: November 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 October 2016 Secured property tax collections during the month of October equaled $1,093,361,533 and increased the 2016 year to date collections to $1,377,596,806 or 29.7% of the adjusted 2016 levy of $4,637,294,773. The chart below reflects the 2016 collected and uncollected levy amount and corresponding percentages for the 2016 property tax year. OCTOBER 2016 Uncollected Levy $3,259,697,967 70.3% Collected Levy $1,377,596,806 29.7% • Collected Levy • Uncollected Levy The County's General Fund Balance totaled $129,509,141.79 effective October 31, 2016. Warrants outstanding of $153,122.81 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, ha es Hos '(4/ (ins, 14)74 Marieopa County Treasurer STATE OF ARIZONA ) ss. COUNTY OF MARICOPA ) This instrument was acknowledged before me this 15th day of November 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. 06q Notary Public My Comm ssion Expires TAMMY L GONZALES Notary Public - Arizona Maricopa County My Comm Expires May 28, 2018 Straight-line Fixed School Income Bonds Grand P-1 NR Aaa AM Credit Status Grand POOL Status GASS amortization fair value and Total FREDDIE FED FED FANNIE GOVT SCHOOL (not US USGN FREDDIE FEDERAL FEDERAL FANNIE GOVT FREDDIE FEDERAL FEDERAL FANNIE GOVT Ratings Total COUNTY COUNTY Hold-to-Maturity US FIXED 40 is TANS HOME FARM AGENCY rated) TREASURY AGENCY AGENCY NOTES DISCOUNT BONDS Available-for-Sale Investment applied. market fair MAC LN CRD DISCOUNT DISTRICT MAC HOME FARM MAE MAC HOME FARM MAE SCHOOL SCHOOL TREASURY INCOME value. values are DISCOUNT DISCOUNT DISCOUNT N/B LOAN CREDIT LOAN CREDIT TANS NOTES Risk NOTE BONDS amortized I BA!' B/ BA!' B) Disclosures cost. Active Active 154 7 24 7 6 44 44 47 47 6 6 11 9 21 50 56 3 1 1 2 7 7 Count 154 10 37 47 6 37 44 20 107 107 154 as of 10/31/2016 100.00% 6.81% 3.36% 10.17% 5.54% 26.32% 45.31% 12.67% 89.83% 89.83% 100.00% ALL Isurr e Maricopa 84% AGENCY GOVT Active Face Amour $3,340,947,000 $227,500,000 $112,215,000 $339,715,000 $185,000,000 $879,300,000 $1,513,769,000 $423,163,000 $3,001,232,000 $3,001,232,000 $3,340,947,000 INVESTMENTS BolA BofA BofA Portfolio Merrill Merrill County Issuer Merrill RESTRICTED Lynch Lynch Lynch Report 0-1 1-3 $3,346,297,819 $228,059,650 $120,353,088 $348,412,738 $185,170,898 $879,142,331 $1,510,535,289 $423,036,563 $2,997,885,081 $2,997,885,081 $3,346,297,819 Allocation 1-3 Year Year Month BENCHMARKS PURSUANT Treasurer US US US Agency Treasury Treasury TO ARS 6% USGN Active 10% DISTRICT SCHOOL Active $3,346,635,375 $228,059,650 $119,468,934 $347,528,584 $185,393,945 $879,165,928 $1,511,630,889 $422,916,030 $2,999,106,792 $2,999,106,792 $3,346,635,375 Index Index Index 35-323 Weighted-Average-Maturity 0.98% 0.51% 0.32% 0.74% 0.82% 1.16% 0.93% 0.75% 1.14% 0.40% 0.96% 0.72% 0.72% 0.74% Duration (WAM) 421 261 508 342 290 897 113 652 430 430 421 Charles displayed displayed treasurermaricona.gov "Hos " in in 0.84 0.71 1.34 0.92 0.77 1.44 0.30 1.46 0.83 0.83 0.84 Treasurer Hoskins YEARS. DAYS. Straight-line Fixed School amortization Income fair Bonds and 1,1115 GASB value is TANS fair Grand POOL :74,010= Status Grand POOL Status Statement applied. market value. values Total COUNTY COUNTY Hold-to-Maturity US NOTES DISCOUNT BONDS FIXED Available-for-Sale Total COUNTY COUNTY Hold-to-Maturity US NOTES DISCOUNT BONDS FIXED Available-for-Sale 31 are amortized SCHOOL SCHOOL TREASURY INCOME SCHOOL SCHOOL TREASURY INCOME Investment cost. TANS BONDS NOTES TANS BONDS NOTES Accounting & Active Active Reporting 154 10 37 47 6 37 44 20 107 107 154 COUNT 154 10 37 47 6 37 44 20 107 107 154 COUNT as of Maricopa 2 $3,340,947,000 $227,500,000 $112,215,000 $339,715,000 $185,000,000 $879,300,000 $1,513,769,000 $423,163,000 $3,001,232,000 $3,001,232,000 $3,340,947,000 PAR $3,346,297,819 $228,059,650 $120,353,088 $348,412,738 $185,170,898 $879,142,331 $1,510,535,289 $423,036,563 $2,997,885,081 $2,997,885,081 $3,346,297,819 PRINCIPAL 10/31/2016 Portfolio County Report $3,346,297,819 $228,059,650 $120,353,088 $348,412,738 $185,170,898 $879,142,331 $1,510,535,289 $423,036,563 $2,997,885,081 $2,997,885,081 $3,346,297,819 PRINCIPAL $3,346,635,375 $228,059,650 $119,468,934 $347,528,584 $185,393,945 $879,165,928 $1,511,630,889 $422,916,030 $2,999,106,792 $2,999,106,792 $3,346,635,375 FAIR ALL Treasurer INVESTMENTS $3,345,410,993 $228,059,650 $119,468,934 $347,528,584 $185,147,039 $879,147,919 $1,510,535,289 $423,052,163 $2,997,882,409 $2,997,882,409 $3,345,410,993 AMORTIZATION $2,999,106,792 $185,393,945 $879,165,928 $1,511,630,889 $422,916,030 $2,999,106,792 $2,999,106,792 $2,999,106,792 RESTRICTED $0 $0 $0 PURSUANT Weighted-Average-Maturity UNREALIZED TO Duration INTEREST ARS § Charles displayed (WAM) displayed $14,244,489 $528,918 $5,462,063 $5,990,981 $1,372,737 $3,737,723 $971,620 $2,171,428 $8,253,508 $8,253,508 $14,244,489 ACCRUAL $1,221,710 $0 $0 $0 $223,047 $23,597 $1,095,599 ($120,533) $1,221,710 $1,221,710 $1,221,710 GAINi(LOSS) 35-323 treasurer.maricopa.gov "Hos " in YEARS. in DAYS. Treasurer Hoskins Straight-fine Fixed Income School Bonds POOL Row Status Portfolio amortization fair value is and TANS BONDS FIXED Available-for-Sale Labels Detail applied. market value. fair values are FHLBDN FFILBDN FFILSDN FHLBDN FHLBDN FHLBDN FHLBDN FHLBDN FHLBDN FHLBDN FHLBDN FED HOME FFCBDN FFCBDN FFCBDN FFCBDN FFCBDN FED FARM FNMDN 0 FNMDN 0 FNMDN 0 FNMDN 0 FANNIE DISCOUNT NOTES FHLB 0.9 PILE 1.1 FHLB 1.125 FHLB 0.875 FHLI3 1 FHLB 1.25 FHLB 1.33 FHLB 0.73 FHLB 0.65 FEDERAL FFCB 1.27 FFCB 0.95 FFCB 0.8 FFCB 1.24 FFCB 1 FFCB 1.02 FFCB 1.02 FFCB 0.875 FFCB 0.5 FEDERAL INCOME Listing as amortized 011/17/2016 0 02/07/2017 011/16/2016 0 11/28/2016 0 01/18/2017 011/15/2016 0 11/22/2016 0 11/09/2016 0 11/08/2016 0 11/10/2016 0 06/29/2017 LN DISCOUNT 0 03/24/2017 0 07/03/2017 0 06/29/2017 0 12122/2016 0 05/12/2017 CRD 06/30/2017 12/29/2016 01/03/2017 05/17/2017 DISCOUNT 05/1812018 04/26/2019 10/11/2019 06129/2018 05/23/2018 12/28/2018 12/28/2018 06/30/2017 12119/2016 HOME LOAN 01/28/2019 06/27/2019 03/22/2018 01/13/2020 0110712019 0710512019 08/0212018 0713012018 01/13/2017 FARM CREDIT of cost. NT DISCOUNT NT NOTE BANK BANK 10131/2016 1 1 1 1 1 1 1 1 1 1 1 24 1 1 1 1 7 3 1 1 a 44 1 2 1 1 1 1 1 1 1 10 1 1 2 1 1 1 1 1 1 10 20 107 107 154 COUNT Active ALL $35,000,000.00 $40,000,000.00 $35,000,000.00 $35,000,000.00 $40,000,000.00 540,000,000.00 $30,000,000.00 $25,000,000.00 $28,000,000.00 $20,000,000.00 $20,000,000.00 $810,300,000.00 $25,000,000.00 $40,000,000.00 $120,000,000.00 $10,000,000.00 $27,000,000.00 $729,000,000.00 $135,000,000.00 $11,469,000.00 $20,000,000.00 $30,000,000.00 $196,469,000.00 $1,513,769,000.00 $20,000,000.00 $20,000,000.00 $20,000,000.00 $17,000,000.00 $20,000,000.00 $15,000,000.00 $20,000,000.00 $30,000,000.00 $20,000,000.00 $182,000,000.00 $13,073,000.00 $26,000,000.00 $48,000,000.00 $25,000,000.00 $22,090,000.00 $25,000,000.00 $30,000,000.00 $25,000,000.00 $30,000,000.00 $241,163,000.00 $423,163,000.00 $3,001,232,000.00 $3,001,232,000.00 $3,340,947,000.00 PAR INVESTMENTS Maricopa RESTRICTED Portfolio $34,990,375.00 $39,953,722.22 $84,989,500.00 $34,986,097.22 $39,961,866.67 $39,987,777.78 $29,987,291.67 $24,990,302.08 $27,986,000.00 $19,986,700.00 519,888,472.22 $809,778,629.00 $24,954,166.67 $39,808,188.89 $119,302,450.00 $9,965,747.22 $26,830,740.00 $220,861,292.78 $134,330,725.00 $11,432,203.63 $19,933,111.11 $29,800,116.67 $195,496,156.41 $1,510,535,289.29 $20,000,000,00 $20,000,000.00 $19,978,000.00 516,959,030.00 $19,993,000.00 $15,000,000.00 $20,000,000.00 $29,968,800.00 $20,000,000.00 $181,898,830.00 $13,073,000.00 $25,997,400.00 $45,003,400.00 $25,000,000.00 $22,073,432.50 $25,000,000.00 $30,000,000.00 $24,990,500.00 $30,000,000.00 $241,137,732.50 $423,036,562.50 $2,997,885,081.48 $2,997,885,081.48 $3,346,297,619.23 PRINCIPAL PURSUANT TO Report County ARS Fr Treasurer $34,996,827.64 $39,955,666.67 $34,997,106.67 $34,994,540.00 $39,972,166.67 $39,998,350.00 $29,996,370.00 $24,999,121.53 $27,999,573.78 $19,999,560.00 $19,942,198.33 $809,950,056.46 $24,955,958.33 $39,843,885.56 $119,542,590.00 $9,996,106.67 $26,927,707.50 $221,266,248.06 $134,547,502.50 $11,463,883.55 $19,989,533.33 $29,920,945.00 5195,921,864.39 51,511,630,888.62 $19,987,600.00 $19,978,600.00 $19,930,400.00 517,015,640.00 520,010,800,00 $15,018,150.00 $20,024,000.00 $30,008,700.00 $19,991,400.00 5181,965,290.00 $13,074,568.76 $25,925,380.00 544,985,600.00 $24,995,750.00 $22,046,040.90 $24,990,250.00 $29,965,800.00 $24,980,250.00 $29,987,100.00 $240,950,739.66 $422 916,029.66 52,999,106,791.64 $2,999,106,791.64 $2,999,106,791.64 MARKET 35-323 UNREALIZED GAIN $6,452.64 $1,944.44 $7,606.67 $8,442.78 $10,300.00 $10,572.22 $9,078.33 $8,819.45 $13,573.78 $12,860.00 $53,726.11 $171,427.46 $1,791.67 $35,696.67 $240,140.00 $30,359.44 $96,967.50 $404,955.28 $216,777.50 $31,679.93 $56,422.22 $120,828.33 $425,707.98 $1,095,599.33 ($12,400.00) ($21,400.00) ($47,600.00) $56,610.00 $17,800.00 $18,150.00 $24,000.00 $39,900,00 ($8,600.00) $66,460.00 $1,568.76 ($72,020.00) ($17,800.00) ($4,250.00) (527,391.60) ($9,750.00) ($34,200.00) ($10,250.00) ($12,900.00) ($186,992.84) ($120,532.84) $1,221,710.16 $1,221,710.16 LOSS Weighted-Average-Maturity Duration (WAM) INTEREST Charles displayed displayed $5,165.94 $7,916.56 $6,406.91 $6,526.19 $9,328.33 $7,768.58 $8,263.91 $8,051.72 $12,341.74 $11,750.31 $38,576.54 $146,200.56 $1,862.21 $26,210.20 5226,659.35 $26,239.50 $81,000.39 $361,971.65 $207,024.20 $26,976.16 $47,900.64 $91,029.20 $372,930.20 $971,620.46 $36,500.00 $56,222.22 $68,750.00 $63,631.94 $87,777.78 $110,937.50 $223,883.33 $200,141.67 5145,166.67 $993,011,11 $125,903.88 $64,494.44 $99,000.00 $93,000.00 $69,951.67 $82,166.67 $305,150.00 $218,750.00 $120,000.00 $1,178,416.56 $2,171,427.77 $8,253,508.07 $8,253,508,07 $14,244,489.12 ACCRUAL treasurer.maricopa.gov "Hos" in YEARS. in DAYS. Treasurer Hoskins Straight-line Fixed Income School Bonds Row Status Portfolio amortization fair value is and TANS NOTES Labels Detail applied. market value. fair values are FHLMC 1 FHLMC 1 FHLMC 0.95 FREDDIE MAC FNMA 1.35 FNMA 1.3 FNMA 1.25 FNMA 1.25 FNMA 1.405 FNMA 1.4 FNMA 1.23 FNMA 1.1 FNMA 1.45 FNMA 1.25 FNMA 1.2 FNMA 1.33 FNMA 1.125 FNMA 1 FNMA 1.05 FNMA 1.14 FNMA 1.2 FNMA 1.4 FNMA 1.25 FNMA 1.26 FNMA 1.16 FNMA 1.125 FNMA 0.875 FANNIE MAE FREDN 0 FREDN 0 FREON 0 FREDN 0 FREDN 0 FREDN 0 FREDN 0 FREDDIE MAC FHLBDN 0 FHLBDN 0 FHLBDN 0 FHLI9DN FHLBDN 0 FHLBDN 0 FHLBDN 0 FHLBDN 0 FHLBDN 0 FHLBDN 0 FHLBDN 0 FHLBDN 0 Listing as amortized 08/03/2018 07/27/2018 04/26/2018 07/28/2020 07/28/2020 09/30/2019 10/28/2019 10/27/2020 07/27/2020 10/17/2019 10/17/2019 09/15/2020 08/23/2019 0811612019 01/28/2020 07126/2019 07/26/2019 07/12/2019 07/05/2019 06/28/2019 06/13/2019 05/16/2019 05/03/2019 11/16/2018 10/29/2018 10/26/2017 03/0212017 02/08/2017 02/06/2017 05/25/2017 05/24/2017 05123/2017 12/23/2016 DISCOUNT 01/24/2017 12/13/2016 12/07/2016 001/10/2017 01/12/2017 12/0612016 01/09/2017 12/14/2016 01/19/2017 12/08/2016 12/21/2016 11/29/2016 of 1013112016 cost. NT COUNT Active 1 2 1 14 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 23 37 1 1 1 1 1 1 1 7 1 1 1 1 1 1 1 1 1 1 2 1 ALL $30,000,000.00 $47,425,000.00 $15,000,000.00 $327,425,000.00 $20,000,000.00 $25,000,000.00 $18,910,000.00 $17,965,000.00 $30,000,000.00 $25,000,000.00 $30,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 $25,000,000.00 $30,000,000.00 $20,000,000.00 $20,000,000.00 $30,000,000.00 $35,000,000.00 $15,000,000.00 $25,000,000.00 $25,000,000.00 $551,875,000.00 $879,300,000.00 $40,000,000.00 $45,000,000.00 $25,000,000.00 $45,000,000.00 $40,000,000.00 $45,000,000.00 $45,000,000.00 $285,000,000.00 $45,000,000.00 $25,000,000.00 $35,000,000.00 $40,000,000.00 $40,000,000.00 $40,000,000.00 $25,000,000.00 $35,000,000.00 $42,300,000.00 $25,000,000.00 $70,000,000.00 $40,000,000.00 PAR INVESTMENTS Maricopa RESTRICTED Portfolio 2 $30,000,000.00 $47,425,000.00 $15,000,000.00 $327,472,250.00 $20,000,000.00 $25,000,000.00 $18,905,272.50 $17,960,508.75 $30,000,000.00 $25,000,000.00 $30,000,000.00 $24,946,250.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 $25,000,000.00 $30,000,000.00 $19,984,800.00 $20,000,000.00 $30,000,000.00 $35,000,000.00 $14,985,000.00 $25,000,000.00 $24,888,250.00 $551,670,081.25 $379,142,331.25 $39,946,455.56 $44,954,293.75 $24,975,680.56 $44,868,443.75 $39,875,000.00 $44,857,500.00 $44,921,837.50 $284,399,211.11 $44,964,937,50 $24,992,612.50 $34,989,636.11 $39,975,833.33 $39,974,000.00 $39,988,100.00 $24,985,027.78 $34,987,108.33 $42,268,310.25 $24,991,333.33 $69,967,002.78 $39,985,422.22 PRINCIPAL PURSUANT Report County TO ARS Treasurer MARKET 35-323 $29,944,200.00 $47,440,952.00 $14,986,650.00 $327,426,102.00 $19,995,000.00 $25,006,500.00 $18,892,413.70 $17,943,262.35 $30,022,800.00 $25,009,750.00 $30,021,600.00 $24,972,500.00 $20,000,000.00 $20,011,600.00 $29,931,300.00 $20,008,000.00 $20,001,000.00 $24,943,250.00 $24,951,250.00 $30,013,800.00 $19,998,800.00 $19,990,000.00 $30,006,300.00 $35,011,550.00 $14,981,400.00 $24,972,000.00 $25,055,750.00 $551,739,826.05 $879,165,928.05 $39,947,948.89 $44,956,800.00 $24,977,087.50 $44,869,962.50 $39,884,983.33 $44,871,250.00 $44,984,687.50 $284,492,719,72 $44,966,790.00 $24,992,687.50 $34,991,979.17 $39,975,358.89 $39,974,623.33 $39,991,253.33 $24,984,415.67 $34,989,577.78 $42,270,352.40 $24,993,625.00 $69,974,411.11 $39,993,500.00 UNREALIZED GAIN ($55,800.00) $15,952.00 ($13,350.00) ($46,148.00) ($5,000.00) $6,500.00 ($12,858.80) ($17,246.40) $22,800.00 $9,750.00 $21,600.00 $26,250.00 $0.00 $11,600.00 ($68,700.00) $8,000.00 $1,000.00 ($56,750.00) ($48,750.00) $13,800.00 $14,000.00 ($10,000.00) $6,300.00 $11,550.00 ($3,600.00) ($28,000.00) $167,500.00 $69,744.80 $23,596.80 $1,493.33 $2,50625 $1,406.94 $1,518.75 $9,983.33 $13,750.00 $62,850.00 $93,508.61 $1,852.50 ($125.00) $2,343.06 ($474.44) $623.33 $3,153.33 ($611.11) $2,469.44 $2,042.15 $2,291.67 $7,408.33 $7,077.78 LOSS Weighted-Average-Maturity Duration (WAM) INTEREST Charles displayed in displayed $298,333.33 $367,394.44 $142,895.83 $2,125,018.06 $0.00 $0.00 $19,697.92 $1,871.35 $4,683.33 $3,888.89 $14,350.00 $10,694.44 $37,055.56 $41,656.67 $75,000.00 $68,716.67 $59,375.00 $65,972.22 $79,479.17 $110,200.00 $82,000.00 $107,333.33 $171,875.00 $218,050.00 $166,750.00 $142,187.50 $131,857.64 $1,612,704.69 $3,737,722.74 $0.00 $1,354.82 $1,201.40 $6,778.54 $11,295.33 $15,248.91 $54,639.05 $90,518.05 $0.00 $476.70 $1,028.27 $1,311.16 $1,695.54 $1,728.85 $1,384.62 $1,799.60 $2,594.19 $1,836.28 $4,960.14 $5,288.46 ACCRUAL treasureranarieopa.gov "Hos" YEARS. in DAYS. Treasurer Hoskins Straight-line Fixed School income Bonds Row Status Portfolio amortization fair value is and TANS COUNTY Hold-to-Maturity US US Labels Detail applied. market value. fair values DysartUSD Dysart Unified ChandlerUSD ChandlerUSD Chandler REFUNDING WashingtonESD WashingtonESD WashingtonESD WashingtonESD Washington RiversideESD RiversideESD RiversideESD RiversideESD Riverside PhoenixUHSD Phoenix Union Paradise GlendaleUHSD GlendaleUHSD GlendaleUHSD Glendale CartwrightESD CartwrightESD CartwrightESD CartwrighESD CartwrighESD Cartwright IMPROVEMENT SCHOOL T 1.25 Ti 12/31/2017 T0.75 T0.75 T 0.525 TREASURY TREASURY FHLMC FHLMC 1 FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC Listing are amortized 2.3 School 5.23 5.23 Unified School BONDS Elementary 1.42 1.3 1.13 1.03 Elementary 0.93 High ParadiseValleyUSD Valley Unified 1.975 1.46 1 Union High 2.29 2.29 2.29 1.98 1.98 Elementary BONDS BONDS 12/15/2018 12/31/2017 06/30/2017 12/31/2016 N/B 1.05 10/26/2018 09/21/2018 3.812/28/2017 0.91 06/27/2018 1.3 05/24/2019 1.05 05/10/2018 1.25 06/2212018 1.1 10/29/2018 1.05 06/2912018 as of cost 01/01/2018 District 07/01/2017 01/01/2018 District 1.63 07/01/2018 1.57 07/01/2019 1.27 07/01/2018 1.22 07/01/2017 School 07/01/2021 07/01/2020 07/01/2019 07/01/2018 School 07/01/2017 School District 1 07/01/2017 School 07/01/2018 07/01/2017 07/01/2017 School 07/01/2019 07/01/2018 07/01/2017 07/01/2018 07/01/2017 School 10/31/2016 District District District District District Active 1 2 1 1 2 19 1 1 1 1 4 1 1 1 1 4 1 1 1 1 1 1 1 3 1 1 1 1 1 5 18 37 47 1 1 1 1 2 6 1 1 1 1 1 1 1 2 1 COUNT ALL PAR INVESTMENTS $4,530,000.00 $8,890,000.00 $3,685,000.00 $75,000.00 $3,660,000.00 $62,305,000.00 $3,000,000.00 $3,000,000.00 $1,500,000.00 $2,000,000.00 $9,500,000.00 $1,355,000.00 $1,650,000.00 $1,030,000.00 $1,040,000.00 $5,075,000.00 $5,070,000.00 $5,070,000.00 $9,515,000.00 $9,515,000.00 $15,775,000.00 $2,100,000.00 $775,000.00 $19,650,000.00 $370,000.00 $135,000.00 $120,000.00 $235,000.00 $240,000.00 $1,100,000.00 $49,910,000.00 $112,215,000.00 $339,715,000.00 $25,000,000.00 $20,000,000.00 $30,000,000.00 $35,000,000.00 $75,000,000.00 $185,000,000.00 $185,000,000.00 $25,000,000.00 $20,000,000.00 $25,000,000.00 $30,000,000.00 $25,000,000.00 $25,000,000.00 $25,000,000.00 $40,000,000.00 $20,000,000.00 Maricopa RESTRICTED Portfolio 3 PRINCIPAL PURSUANT County $4,820,890.10 $9,447,173.30 $4,233,347.25 $89,799.75 $4,323,147.00 $70,327,666.35 $3,000,000.00 $3,000,000.00 $1,500,000.00 $2,000,000.00 $9,500,000.00 $1,355,000.00 $1,650,000.00 $1,030,000.00 $1,040,000.00 $5,075,000.00 $5,075,337.50 $5,076,337.50 $9,515,000.00 $9,515,000.00 $16,862,062.25 $2,100,000.00 $777,162.25 $19,739,224.50 $375,072.70 $138,221.10 $123,656.40 $237,876.40 $245,032.80 $1,119,859.40 $50,025,421.40 $120,353,087.75 $348,412,737.75 $25,250,976.56 $19,972,656.25 $29,852,343.75 $35,031,445.31 $75,063,478.58 $185,170,898.44 $185,170,898.44 $25,000,000.00 $20,000,000.00 $25,000,000.00 $30,003,000.00 $24,970,000.00 $25,000,000.00 $25,077,250.00 $40,000,000.00 $20,000,000.00 Report TO ARS Treasurer 4 MARKET 35-323 $25,216,796.88 $20,089,531.25 $30,019,921.88 $35,043,760.00 $75,043,945.31 $185,393,945.31 $185,393,945.31 $24,999,750.00 $20,003,000.00 $25,000,000.00 $29,982,600.00 $24,987,500.00 $25,001,250.00 $25,171,000.00 $39,929,600.00 $19,979,600.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 UNREALIZED GAIN 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 ($34,179.69) $96,875.00 $167,578.13 $12,304.69 ($19,531.25) $223,046.88 $223,046.88 ($250.00) $3,000.00 $0.00 ($17,400.00) $17,500.00 $1,250.00 $93,750.00 ($70,400.00) ($20,400.00) LOSS Duration (WAM) INTEREST Charles displayed displayed $203,749.33 $399,852.44 $367,699.51 $3,769.96 $371,469.47 $4,141,705.83 $97,800.00 $45,680.83 $18,467.92 $48,800.00 $210,728.75 $1,015.50 $1,132.08 $514.28 $565.36 $3,327.22 $107,005.58 $107,006.58 $207,215.56 $207,215.56 $690,221.35 $63,875.00 $7,039.58 $761,135.94 $11,250.26 $4,104.83 $3,648.73 $5,906.73 $6,032.40 $30,942.94 $1,320,356.98 $5,462,062.81 $5,990,981.05 $274,077.87 $167,582.42 $188,530.22 $349,775.29 $392,771.29 $1,372,737.09 $1,372,737.09 $2,187.60 $22,222.22 $68,333.33 $94,033.33 $135,416.67 $124,687.50 $418,402.78 $222,444.44 $228,666.67 ACCRUAL treasurer.maricopa.gov "Hos " in YEARS. in DAYS. Treasurer Hoskins Straight-line Fixed School Income Bonds Grand Row Status Portfolio amortization fair value and Total Labels is TANS TANS COUNTY Detail applied. market fair Washington Saddle Roosevelt Peoria Pendergast Paradise Glendale Gilbert Deer Chandler Riverside Queen Phoenix Peoria Kyrene Glendale Listing value. values are VVashingtonESD Mountain RooseveltESD PeoriaUSD Unified PendergastESD ParadiseValleyUSD Valley GlendaleUHSD Union GilbertUSD Unified DeerValIeyUSD Valley ChandIerUSD Unified SCHOOL RiversideESD RiversideESD RiversideESD RiversideESD QueenCreekUSD QueenCreekUSD Creek PhoenixESD PhoenixESD PhoenixESD PhoenixESD PhoenixESD PeoriaUSD PeoriaUSD Unified KyreneESD Elementary GlendaleUHSD Union DysartUSD as amortized Elementary SaddleMountainUSD 1.07 Elementary School Elementary Unified High 1.07 School Unified 1.07 School TANS 4.5 3 3 1.42 Elementary Unified 3.57 3.57 3.57 5.65 5.65 Elementary 3.65 3,65 School 5.96 3.33 High 2.3 of cost. 1.07 School 1.07 Unified School 1.0737/19/2017 District 1.0707/19/2017 School 1.07 School 1.07 School 07119/2017 District 1,07 School 07/19/2017 District 07/01/2020 07101/2019 07/01/2018 07/01/2021 School 3.62 3.62 School 07/01/2021 07/01/2020 07/01/2017 07/01/2017 01/01/2018 School 07/01/2017 01/01/2018 District 06/14/2017 School School 07/01/2017 10/31/2016 07/19/2017 School 07/19/2017 District 07/19/2017 District 07/19/2017 District District 07/01/2017 01/0112018 District District District 07/01/2017 District District 07/19/2017 District District 07/19/2017 District Active 154 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 10 10 1 1 1 4 1 1 2 1 1 1 1 1 5 1 1 2 1 1 1 1 1 COUNT ALL PAR INVESTMENTS $3,340,947,000.00 $12,000,000.00 $12,000,000.00 $1,000,000.00 $1,000,000.00 $15,000,000.00 $15,000,000.00 $37,000,000.00 $37,000,000.00 $12,500,000.00 $12,500,000.00 $20,000,000.00 $20,000,000.00 $15,000,000.00 $15,000,000.00 $35,000,000.00 $35,000,000.00 $35,000,000.00 $35,000,000.00 $45,000,000.00 $45,000,000.00 $227,500,000.00 $227,500,000.00 $1,045,000.00 $215,000.00 $210,000.00 $1,095,000.00 $2,565,000.00 $1,100,000.00 $370,000.00 $1,470,000.00 $4,130,000.00 $2,025,000.00 $100,000.00 $3,825,000.00 $4,190,000.00 $14,270,000.00 $3,400,000.00 $8,600,000,00 $12,000,000.00 $5,390,000.00 $5,390,000.00 $14,060,000.00 $14,060,000.00 $4,360,000.00 Maricopa RESTRICTED Portfolio 4 County $3,346,297,819.23 $12,029,520.00 $12,029,520.00 $1,002,480.00 $1,002,460.00 $15,036,900.00 $15,036,900.00 $37,091,020.00 $37,091,020.00 $12,530,750.00 $12,530,750.00 $20,049,200.00 $20,049,200.00 $15,036,900.00 $15,036,900.00 $35,086,100.00 $35,086,100.00 $35,086,100.00 $35,086,100.00 $45,110,700.00 $45,110,700.00 $228,059,650.00 $228,059,650.00 $1,166,011.00 $225,734.95 $217,028.70 $1,095,000.00 $2,703,774.65 $1,216,105.00 $411,636.10 $1,627,741.10 $4,532,881.50 $2,190,888.00 $102,079.00 $4,581,891.00 $5,100,696.50 $16,508,436.00 $3,786,172.00 $9,656,252.00 $13,442,424,00 $6,677,509.30 $6,677,509.30 $15,597,461.00 $15,597,461.00 $4,626,483.20 PRINCIPAL PURSUANT Report TO ARS Treasurer ,5 MARKET 35-323 $2,999,106,791.64 $0.00 $0.00 $0.00 $0.00 $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 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 UNREALIZED GAIN LOSS Weighted-Average-Maturity $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 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 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0,00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Duration (WAM) INTEREST Charles displayed displayed $14,244,489.12 $27,898.98 $27,898.98 $2,324.92 $2,324.92 $34,873.73 $34,873.73 $86,021.87 $86,021.87 $29,061.44 $29,061.44 $46,498.31 $46,498.31 $34,873.73 $34,873,73 $81,372.04 $81,372.04 $81,372.04 $81,372.04 $104,621.19 $104,621.19 $528,918.23 $528,918.23 $2,481.88 $340.42 $332.50 $820.64 $3,975.43 $75,879.22 $12,129.01 $88,008.23 $16,791.89 $8,233.31 $406.58 $423,820.63 $464,263.64 $913,516.05 $240,616.11 $608,617.22 $849,233.33 $598,763.12 $598,763.12 $916,887.75 $916,887.75 $196,103.11 ACCRUAL treasurer.maricopa.gov "Hos " in in Treasurer Hoskins YEARS. DAYS.