Extracted text (via pymupdf_layout)
36835 characters
Royce T. Flora, Treasurer 301 West Jefferson St., Rm. 100 Phoenix, Arizona 85003 Maricopa County Phone: (602) 506-8511 Fax: (602) 506-1102 Treasurer http://treasureranaricopa.gov DATE: APRIL 11,2017 TO: Denny Barney, Chairman Steve Chucri, Supervisor, District 2 Bill Gates, Supervisor, District 3 Clint Hickman, Supervisor, District 4 Steve Gallardo, Supervisor, District 5 SUBJECT: Treasurer's Collections and Investment Summary for MARCH 2017 Secured property tax collections during the month of March equaled $233,300,956 and increased the 2016 year to date collections to $2,969,808,507 or 64.16% of the adjusted 2016 levy of $4,629,035,457. The chart below reflects the 2016 collected and uncollected levy amount and corresponding percentages for the 2016 property tax year. MARCH 2017 Uncollected Levy $1,659,226,950 36% Collected Levy $2,969,808,507 64% • Collected Levy • Uncollected Levy The County's General Fund Balance totaled $205,949,609.86 effective March 31, 2017. Warrants outstanding of $3,913,491.47 will post against the fund balances when presented. The $21,473,929, unencumbered balance, of the County Municipal Line of Credit and the $13,526,071 Workers Compensation Liability Letter of Credit remain unused. Russell K. Pearce Chief Deputy Treasurer STATE OF ARIZONA ) ss. COUNTY OF MAR1COPA ) This instrument was acknowledged before me this 11th day of April 2017, by Russell K. Pearce, as Chief Deputy 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. ccuu,Lt (Awl _ 7y, ao ( 7 Notary Public My Commission Expires KAREN D. SMITH Notary Public - Arizona Maricopa County My Comm. Expires Dec 15, 2017 Straight-line School Source: Bonds BLOOMB amortization and ERG TANS applied. fair Grand P-1 NR Aaa AA+ Credit Status Grand POOL Status GASB values are Total FED FED GOVT SCHOOL (not US USGN GOVT GOVT Ratings Total FIXED 40 FREDDIE FANNIE rated) FREDDIE FEDERAL FEDERAL FANNIE FREDDIE FEDERAL FEDERAL FANNIE COUNTY COUNTY Hold-to-Maturity US NOTES BONDS Available-for-Sale amortized HOME FARM AGENCY DISTRICT TREASURY MAE AGENCY MAE AGENCY DISCOUNT INCOME Investment cost. MAC LN CRD DISCOUNT MAC HOME FARM MAC HOME FARM SCHOOL SCHOOL TREASURY DISCOUNT DISCOUNT DISCOUNT NIB LOAN CREDIT LOAN CREDIT TANS BONDS NOTES Risk NOTE NT NT NT BANK BANK BANK BANK Disclosures Active Active as 169 7 20 6 7 40 40 47 47 6 6 24 9 10 26 69 75 3 1 1 2 7 7 Count 169 10 37 47 6 55 40 21 122 122 169 Count of % 03/31/2017 100.00% 6.66% 3.28% 9.94% 4.83% 36.29% 36.64% 12.30% 90.06% 90.06% 100.00% oFrittAL Maricopa ALL urr, of Portfolio 1 85% AGENCY. GOVT Active Face Arroun $3,416,372,000 $227,500,000 $112,215,000 $339,715,000 $165,000,000 $1,239,800,000 $1,251,694,000 $420,163,000 $3,076,657,000 $3,076,657,000 $3,416,372,000 INVESTMENTS County BofA BofA BofA Report Issuer Merrill Merrill Merrill RESTRICTED Lynch Lynch Lynch $3,421 PRINCIPAL Treasurer 0-1 1-3 340 $228,059,650 $120,353,088 $348,412,738 $165,204,688 $1,239,640,831 $1,248,070,245 $420,011,918 $3,072,927,682 $3,072,927,682 $3,421,340,419 Allocation 1-3 Year Year Month BENCHMARKS 419 PURSUANT US US US TO 5% USG N Active 10% DISTRI SCHOOL Active Agency Treasury Treasury $3,416,236,251 $228,059,650 5119,468,934 $347,528,584 $164,951,367 $1,234,635,134 $1,250,356,954 $418,764,213 $3,068,707,668 $3,068,707,668 $3,416,236,251 ARS 4 CT Index Index index 35-323 1.38% 0.96% 0.92% 0.94% 0.82% 1.16% 0.93% 0.93% 1.26% 0.59% 1.06% 0.94% 0.94% 0.94% 439 110 357 191 404 842 54 611 466 466 439 Weighted-Average-Maturity DURATION' Duration 1.05 0.30 0.93 0.51 1.08 1.98 0.15 1.41 1.11 1.11 1.05 (WAM) displayed displayed treasurerauaricopa.gov Royce in in Treasurer T. YEARS. DAYS. Flora Straight-line School Source: amortization Bonds and BLOOMBERG applied. TANS fair GASB values are Grand POOL EMT Status Grand POOL Portfolio Status Statement amortized cost. 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 SCHOOL SCHOOL TREASURY INCOME SCHOOL SCHOOL TREASURY INCOME Investment TANS BONDS NOTES TANS BONDS NOTES Accounting .CO. Active COUNT Active & 169 10 37 47 6 55 40 21 122 122 169 NT 169 10 37 47 6 55 40 21 122 122 169 Reporting $3,416,372,000 $227,500,000 $112,215,000 $339,715,000 $165,000,000 $1,239,800,000 $1,251,694,000 $420,163,000 $3,076,657,000 $3,076,657,000 $3,416,372,000 PAR $3,421,340,419 $228,059,650 $120,353,088 $348,412,738 $166,204,688 $1,239,640,831 $1,248,070,245 $420,011,918 $3,072,927,682 $3,072,927,682 $3,421,340,419 PRINCIPAL as of Maricopa 03/31/2017 Portfolio 2 County $3,421,340 $228,059,650 $120,353,088 $348,412,738 $165,204,688 $1,239,640,831 $1,248,070,245 $420,011,918 $3,072,927,682 $3,072,927,682 $3,421,340,419 PRINCIPAL $3,416 236 $228,059,650 $119,468,934 $347,528,584 $164,951,367 $1,234,635,134 $1,250,356,954 $418,764,213 $3,068,707,668 $3,068,707,668 $3,416,236,251 ALL Report ,419 , 251 INVESTMENTS Treasurer $3,420,367,141 $228,059,650 $119,468,934 $347,528,584 $165,123,126 $1,239,612,919 $1,248,070,245 $420,032,268 $3,072,838,558 $3,072,838,558 $3,420,367,141 AMORTIZATION $3,068,707,668 $164,951,367 $1,234,635,134 $1,250,356,954 $418,764,213 $3,068,707,668 $3,068,707,668 $3,068,707,668 MARKET RESTRICTED $0 $0 $0 PURSUANT UNREALIZED TO ARS Weighted-Average-Maturity $15 INTEREST § 35 -323 999 559 $1,311,925 $6,781,332 $8,093,257 $409,546 $3,893,315 $2,557,579 $1,045,863 $7,906,303 $7,906,303 $15,999,559 ACCRUAL ($4,220,014) $0 $0 $0 ($253,320) ($5,005,698) $2,286,709 ($1,247,705) ($4,220,014) ($4,220,014) ($4,220,014) GAIN/(LOSS) Duration (WAM) displayed displayed treasurer.maricopa.gov Royce in YEARS. in DAYS. Treasurer T. Flora Straight-fine School Bonds Source: POOL Row Status Portfolio amortization applied. and TANS fair BLOOMBERG FHLBDN FHLBDN FHLBDN FHLBDN FHLBDN FHLBDN FED HOME FFCBDN FFCBDN FFCBDN FFCBDN FED FARM FNMDN FNMDN FNMDN FNMDN FNMDN FANNIE DISCOUNT FHLB FHLB FHLB FHLB FHLB FHLB 1 FHLB FHLB FHLB FEDERAL FFCB FFCB FFCB FFCB FFCB FFCB FFCB 1 FFCB FFCB FFCB FEDERAL BONDS FIXED INCOME Available-for-Sale Labels Detail Listing values are 0 0 0 0 LN 0 0 CRD 0 0 0 DISCOUNT NOTES 1.75 0.9 1.1 1.125 0.875 05123/2018 1.25 1.33 0.73 HOME 1.8 1.1 1.27 0.95 0.8 1.24 01/07/2019 1.02 1.02 0.875 FARM as of amortized 004/11/2017 04/24/2017 04/06/2017 004/10/2017 04/13/2017 06/29/2017 DISCOUNT 04/05/2017 007/03/2017 006/29/2017 05/12/2017 DISCOUNT 004/19/2017 005/18/2017 05/0912017 06/30/2017 05/17/2017 NOTE 07/30/2020 05/18/2018 04126/2019 10/11/2019 06/29/2018 12/28/2018 12/28/2018 06/30/2017 LOAN 03113/2020 12/05/2018 01/28/2019 06/27/2019 03/22/2018 01/13/2020 07/05/2019 08/02/2018 07/30/2018 CREDIT cost. NT NT BANK BANK 03/31/2017 1 1 1 1 1 1 20 1 1 3 1 6 1 1 1 3 1 7 40 1 1 2 1 1 1 1 1 1 10 1 1 1 1 2 1 1 1 1 1 11 21 122 122 169 COUNT Active ALL $45,000,000.00 $30,000,000.00 $25,000,000.00 $25,000,000.00 $25,000,000.00 $20,000,000.00 $502,694,000.00 $42,000,000.00 $40,000,000.00 $120,000,000.00 $27,000,000.00 $229,000,000.00 $30,000,000.00 $45,000,000.00 $40,000,000.00 $135,000,000.00 $30,000,000.00 $280,000,000.00 $1,251,694,000.00 $10,000,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 $172,000,000.00 $12,000,000.00 $25,000,000.00 $13,073,000.00 $26,000,000.00 $45,000,000.00 $25,000,000.00 $22,090,000.00 $25,000,000.00 $30,000,000.00 $25,000,000.00 $248,163,000.00 $420,163,000.00 $3,076,657,000.00 $3,076,657,000.00 $3,416,372,000.00 PAR INVESTMENTS Maricopa RESTRICTED Portfolio 1 $44,968,800.00 $29,973,820.83 $24,984,416.67 $24,968,281.25 $24,950,166.67 $19,888,472.22 $501,973,212.04 $41,907,880.00 $39,808,188.89 $119,302,450.00 $26,830,740.00 $227,849,258.89 $29,979,600.00 $44,907,875.00 $39,900,800.00 $134,330,725.00 $29,800,116.67 $278,919,116.67 $1,248,070,245.24 $10,000,000.00 $20,000,000.00 $20,000,000.00 $19,978,000.00 $16,959,030.00 $19,993,000.00 $15,000,000.00 $20,000,000.00 $29,968,800.00 $171,898,830.00 $12,000,000.00 $24,975,355.25 $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 $248,113,087.75 $420,011,917.75 $3,072,927,681.74 $3,072,927,681.74 $3,421,340,419.49 PRINCIPAL PURSUANT Report County TO ARS Treasurer $44,990,196.25 $29,985,040.00 $24,997,187.50 $24,996,993.06 $24,993,545.14 $19,964,450.00 $502,272,073.58 $41,995,840.83 $39,927,411.11 $119,792,100.00 $26,978,517.00 $228,693,868.94 $29,988,315.00 $44,959,020.00 $39,972,570.00 $134,761,125.00 $29,970,820.83 $279,651,850.83 $1,250,356,953.91 $10,012,100.00 $20,000,200.00 $19,938,400,00 $19,863,400.00 $16,949,170.00 $20,009,400.00 $14,991,900.00 $20,012,400.00 $29,988,300.00 $171,765,270.00 $12,000,240.00 $24,923,250.00 $13,059,534.81 $25,720,760.00 $44,892,000.00 $24,799,750.00 $21,964,307.90 $24,811,750.00 $29,925,600.00 $24,901,760.00 $246,998,942.71 $418,764,212.71 $3,068,707,667.51 $3,068,707,667.51 $3,068,707,667.51 MARKET 35-323 UNREALIZED GAIN Weighted-Average-Maturity $21,396.25 $11,219.17 $12,770.83 $27,711.81 $43,378.47 $75,977.78 $298,861.54 $87,960.83 $119,222.22 $489,650.00 $147,777.00 $844,610.05 $8,715.00 $51,145.00 $71,770.00 $430,400,00 $170,704.17 $732,734.17 $2,286,708.67 $12,100.00 $200.00 ($61,600.00) ($114,600.00) ($9,860.00) $16,400.00 ($8,100.00) $12,400.00 $19,500.00 ($133,560,00) $240.00 ($52,105.25) ($13,465.19) ($276,640.00) ($111,400.00) ($200,250.00) ($109,124.60) ($188,250.00) ($74,400.00) ($88,750.00) ($1,114,145.04) ($1,247,705.04) ($4,220,014.23) ($4,220,014.23) LOSS Duration (WAM) INTEREST displayed in displayed in $24,400.95 $16,113.78 $13,653.77 $28,498.98 $46,407.47 $85,552,80 $342,584,94 $90,286.46 $130,361.28 $529,710.88 $152,527.09 $902,884.71 $12,504.68 $60,069.17 $79,682.82 $502,838.87 $176,938.01 $832,033.54 $2,557,578.60 $29,166.67 $66,500.00 $94,722.22 $106,250.00 $38,013.89 $71,111.11 $48,437.50 $68,716.67 $54,750.00 $577,668.06 $10,800.00 $88,611.11 $29,054.74 $64,494.44 $9,000.00 $67,166.67 $51,543.33 $60,916.67 $50,150.00 $36,458.33 $468,195.30 $1,045,863.35 $7,906,302.97 $7,906,302.97 $15,999,559.49 ACCRUAL treasurer.maricopa.gov Treasurer Royce T. YEARS. DAYS. Flora Straight-line School Bonds Source: Row Status Portfolio amortization and TANS BLOOMBERG NOTES Labels Detail applied. fair values FNMA 1.5 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.26 FNMA 1.16 FNMA 1.125 FNMA 0.875 FANNIE MAE FREDN FREDN 0 FREDN FREDN 0 FREDN 0 FREDN 0 FREDN 0 FREDDIE MAC FHLBDN 0 FHLBDN FHLBDN FHLBDN 0 FHLBDN FHLBDN FHLBDN FHLBDN 0 FHLBDN FHLBDN FHLBDN 0 FHLBDN FHLBDN Listing as are amortized 11/26/2019 07/2812020 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 08/16/2019 01/28/2020 07/26/2019 07/26/2019 07/12/2019 07/05/2019 0612812019 06/13/2019 05/03/2019 11/1612018 10/2912018 10/26/2017 006/08/2017 06/05/2017 005/19/2017 05/26/2017 05/25/2017 05/24/2017 05/23/2017 DISCOUNT 06/21/2017 006/06/2017 005/30/2017 06/14/2017 005/31/2017 005/1612017 005/10/2017 05/26/2017 004/17/2017 004/20/2017 04/18/2017 004/26/2017 005/23/2017 of cost. NT 03/31/2017 COUNT Active 1 1 1 1 1 1 1 1 28 55 1 1 1 1 1 1 1 7 1 1 1 1 1 1 1 2 1 1 1 1 ALL $25,000,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 $35,000,000.00 $15,000,000.00 $25,000,000.00 $25,000,000.00 $651,875,000.00 $1,239,800,000.00 $10,000,000.00 $20,000,000.00 $35,000,000,00 $45,000,000.00 $45,000,000.00 $40,000,000.00 $45,000,000.00 $240,000,000.00 $20,000,000.00 $40,000,000.00 $20,000,000.00 $25,000,000.00 $15,000,000.00 $25,000,000.00 $35,000,000.00 $50,000,000.00 $15,000,000.00 $23,500,000.00 $19,194,000.00 $20,000,000.00 $25,000,000.00 PAR INVESTMENTS Maricopa RESTRICTED Portfolio 2 PRINCIPAL County $25,000,000.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 $35,000,000.00 $14,985,000.00 $25,000,000.00 $24,888,250.00 $651,670,081.25 $1,239,640,831.25 $9,984,377.78 $19,969,988.89 $34,902,097.22 $44,871,250.00 $44,868,443.75 $39,875,000.00 $44,857,500.00 $239,328,657.64 $19,960,566.67 $39,934,550.00 $19,970,416.67 $24,949,444.44 $14,974,375.00 $24,966,500.00 $34,960,216.67 $49,921,437.50 $14,987,812.50 $23,483,393.33 $19,180,969.41 $19,982,266.67 $24,967,305.56 PURSUANT Report TO ARS Treasurer $24,957,500.00 $19,758,000.00 $24,687,250.00 $18,822,635.80 $17,826,849.15 $29,610,000.00 $24,741,750.00 $29,760,900.00 $24,715,250.00 $19,804,800.00 $19,895,800.00 $29,782,800.00 $19,833,400.00 $19,841,600.00 $24,756,250.00 $24,779,750.00 $29,782,200.00 $19,863,200.00 $19,995,200.00 $34,868,050.00 $14,983,650.00 $24,962,500.00 $24,991,500.00 $647,957,984.95 $1,234,635,133.70 $9,986,755.83 $19,974,443.33 $34,965,318.89 $44,947,780.00 $44,952,287.50 $39,958,420.00 $44,954,155.00 $239,739,160.56 $19,964,785.56 $39,943,943.33 $19,974,333.33 $24,959,895.83 $14,980,657.92 $24,976,648.61 $34,970,561.11 $49,940,188.89 $14,994,956.67 $23,490,247.50 $19,187,541.22 $19,989,137.78 $24,972,763.89 MARKET 35-323 UNREALIZED GAIN Weighted-Average-Maturity ($42,500.00) ($242,000.00) ($312,750.00) ($82,636.70) ($133,659.60) ($390,000.00) ($258,250.00) (8239,100.00) ($231,000.00) ($195,200.00) ($104,200.00) ($217,200.00) ($166,600.00) ($158,400.00) ($243,750.00) ($220,250.00) ($217,800.00) ($121,600.00) ($4,800.00) ($131,950.00) ($1,350.00) ($37,500.00) $103,250.00 ($3,712,096.30) ($5,005,697.55) $2,378.06 $4,454.44 $63,221.67 $76,530.00 $83,843.75 $83,420.00 $96,655.00 $410,502.92 $4,218,89 $9,393.33 $3,916.67 $10,451.39 $6,282.92 $10,148.61 $10,344.45 $18,751.39 $7,144.17 $6,854.17 $6,571.81 $6,871.11 $5,458.33 LOSS Duration (WAM) INTEREST displayed in displayed in $125,000.00 $47,250.00 $56,875.00 $0.00 $95,439.06 $180,308.33 $62,222.22 $168,100.00 $125,277.78 $12,888.89 $26,388.89 $45,000.00 $46,550.00 $40,625.00 $45,138.89 $57,604.17 $81,700.00 $62,000.00 $84,000.00 $181,300.00 $65,250.00 $118,750.00 $94,184.03 $2,202,050.17 $3,893,315.45 $1,461.16 $2,922.13 $73,862.01 $94,235.58 $99,829.46 $96,575.10 $111,189.97 $480,075.41 $3,961.98 $8,632.18 $6,007.73 $9,030.61 $6,665.03 $10,660.13 $14,329.02 $20,147.70 $7,694.91 $9,828.71 $8,157.35 $9,640.50 $13,201.34 ACCRUAL treasurer.maricopa.gov Treasurer Royce T. YEARS. DAYS. Flora Straight-line School Bonds Source: Row Status Portfolio amortization applied. and TANS fair BLOOMBERG Cartwright IMPROVEMENT COUNTY SCHOOL Hold-to-Maturity T 1.625 T 0.625 T 1.25 Ti T0.75 T 0.75 US TREASURY US TREASURY FHLMC FHLMG FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FREDDIE FNMA FNMA FNMA FNMA FNMA Labels Detail Listing values are CartwrightESD CartwrightESD CarlwrighESD CartwrighESD Elementary BONDS 06/30/2019 06/30/2018 12/15/2018 12/31/2017 12/3112017 06/30/2017 1.7 2 1.55 1.53 1.85 1 1 1.625 1.51 1.3 1.4 0.93 1.365 1.05 1 0.8 0.91 1.3 1.25 1.1 1.05 1 1 0.95 MAC 1.875 1.7 1.75 1.75 1.625 as of amortized 2.29 2.29 1.98 1.98 BONDS N/B 03127/2020 09/29/2020 06/28/2019 06/21/2019 08/28/2020 02/24/2020 05/25/2018 01/28/2020 12/13/2019 11/27/2019 11/10/2020 11/02/2018 11/02/2020 10/26/2018 09/21/2018 12/28/2017 06/27/2018 05/24/2019 06/22/2018 10129/2013 06/29/2018 08103/2018 07/27/2018 04/26/2018 08/24/2020 01127/2020 01/17/2020 06/29/2020 05/2612020 03/31/2017 cost. 07/01/2018 07/01/2017 07/01/2018 07/01/2017 School District COUNT Active 1 1 1 1 5 18 37 47 1 1 1 1 1 1 6 6 1 1 1 1 1 1 1 1 2 1 1 1 1 1 1 1 1 1 2 1 1 2 1 27 1 1 1 1 1 ALL $135,000.00 $120,000.00 $235,000.00 $240,000.00 $1,100,000.00 $49,910,000.00 5112,215,000.00 $339,715,000.00 $25,000,000.00 $30,000,000.00 $25,000,000.00 $20,000,000.00 $30,000,000.00 $35,000,000.00 $165,000,000.00 $165,000,000.00 $10,000,000.00 $25,500,000.00 $25,000,000.00 $25,000,000.00 $10,000,000.00 $20,000,000.00 $15,000,000.00 $10,000,000.00 $25,000,000.00 $40,000,000.00 $20,000,000.00 $30,000,000.00 $30,000,000.00 $25,000,000.00 $20,000,000.00 525,000,000.00 530,000,000.00 $25,000,000.00 $25,000,000.00 $40,000,000.00 $20,000,000.00 $30,000,000.00 $47,425,000.00 $15,000,000.00 $587,925,000.00 $15,000,000.00 $30,000,000.00 $25,000,000.00 $20,000,000.00 515,000,000.00 PAR INVESTMENTS Maricopa RESTRICTED Portfolio 3 $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,169,921.88 $29,927,343.75 $25,250,976.56 $19,972,656.25 $29,852,343.75 $35,031,445.31 $165,204,687.50 $165,204,687.50 $10,000,000.00 $25,500,000.00 $25,000,000.00 $25,000,000.00 $10,000,000.00 $20,000,000.00 $14,998,500.00 $10,000,000.00 $25,000,000.00 $40,000,000.00 $20,000,000.00 $30,000,000.00 $30,000,000.00 $25,000,000.00 $20,000,000.00 $25,000,000.00 $30,000,000.00 $24,970,000.00 $25,077,250.00 $40,000,000.00 $20,000,000.00 $30,000,000.00 $47,425,000.00 $15,000,000.00 $587,970,750.00 $15,000,000.00 $30,000,000.00 $25,000,000.00 $20,000,000.00 $15,000,000.00 PRINCIPAL PURSUANT Report County TO ARS 9 Treasurer MARKET 35-323 525,166,015.63 529,817,187.50 625,017,578.13 $20,003,125.00 $29,946,093.75 $35,001,367.19 $164,951,367.19 $164,951,367.19 $10,000,100.00 $25,541,820.00 $25,012,250.00 $25,010,500.00 $9,992,500.00 $20,013,200.00 $14,980,050.00 $10,007,700.00 $24,960,500.00 $39,718,200.00 $19,772,800.00 $29,876,100.00 $29,693,100.00 $24,966,500.00 $19,943,200.00 $24,991,000.00 $29,941,800.00 $24,970,500.00 $25,036,750.00 $39,942,400.00 519,997,000.00 $29,953,500.00 647,363,028.75 $14,992,650.00 $586,677,148.75 $14,995,950.00 $29,997,300.00 $25,011,000.00 $19,987,800.00 $14,945,100.00 $0.00 $0.00 $0.00 50.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 ($3,906.25) ($110,156.25) ($233,398.44) $30,468.75 $93,750.00 ($30,078.13) ($253,320.31) ($253,320.31) $100.00 $41,820.00 $12,250.00 $10,500.00 ($7,500.00) $13,200.00 (518,450.00) $7,700.00 ($39,500.00) ($281,800.00) ($227,200.00) ($123,900.00) ($306,900.00) ($33,500.00) ($56,800.00) ($9,000.00) ($58,200.00) $500.00 ($40,500.00) ($57,600.00) (53,000.00) ($46,500.00) (661,971.25) ($7,350.00) ($1,293,601.25) ($4,050.00) ($2,700.00) $11,000.00 ($12,200.00) ($54,900.00) LOSS Duration (WAM) INTEREST displayed in displayed in $5,392.95 $4,793.73 $7,845.48 $8,012.40 $40,825.24 $1,627,951.46 $6,781,331.88 $8,093,256.52 $101,001.38 $46,616.02 $91,002.75 $49,723.76 $55,939.23 565,262.43 $409,545.56 $409,545.56 $0.00 $2,833.33 $3,229.17 $10,625.00 $16,958.33 $20,555.56 $52,500.00 $27,083.33 5113,250.00 $175,500.00 5109,666,67 $115,475.00 $169,487.50 $111,562.50 $5,555.56 $51,666.67 $71,283.33 $114,652.78 $85,937.50 $185,777.78 $53,666.67 $48,333.33 $84,311.11 $61,354.17 $1,691,265.28 $28,906.25 $90,666.67 $89,930.56 $89,444.44 $81,250.00 ACCRUAL treasurer,maricopa.gov Treasurer Royce T. YEARS. DAYS. Flora Straight-line School Source: Row Status Portfolio Bonds Labels amortization and BLOOMBERG Detail TANS fair Riverside Queen Phoenix Peoria Kyrene Glendale Dysart Chandler REFUNDING Washington Riverside Phoenix Paradise Glendale applied. values RiversideESD RiversideESD RiversideESD QueenCreekUSD QueenCreekUSD Creek PhoenixESD PhoenixESD PhoenixESD PhoenixESD PhoenixESD PeoriaUSD PeoriaUSD Unified KyreneESD Elementary GlendaleUHSD Union DysartUSD DysartUSD Unified ChandlerUSD ChandlerUSD Unified WashingtonESD WashingtonESD WashingtonESD WashingtonESD RiversideESD RiversideESD RiversideESD RiversideESD PhoenixUHSD Union ParadiseValleyUSD Valley GlendaleUHSD GlendaleUHSD GlendaleUHSD Union CartwrightESD Listing as are 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 2.3 School 5.23 5.23 School BONDS Elementary 1.42 1.3 1.13 1.03 Elementary 0.93 High Unified 1.975 1.46 1 High 2.29 of amortized 307/01/2019 307/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 01/01/2018 District 07/01/2017 01/01/2018 District 1.63 1.57 1.27 1.22 School 07/01/2021 07/01/2020 07/01/2019 07/01/2018 School 07/01/2017 School 1 School 07/0112017 School 07/01/2019 03/31/2017 cost. District 07/01/2017 01/01/2018 District District District 07/01/2017 District 07/01/2018 07/01/2019 07/01/2018 07/01/2017 District District 07/01/2017 District 07101/2018 07/01/2017 District District Active 1 1 1 4 1 1 2 1 1 1 1 1 5 1 1 2 1 1 1 1 1 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 COUNT ALL PAR INVESTMENTS $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 $4,530,000.00 $8,890,000.00 $3,585,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 $16,775,000.00 $2,100,000.00 $775,000.00 $19,650,000.00 $370,000.00 Maricopa RESTRICTED Portfolio 4 PRINCIPAL County $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 $4,820,690.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,076,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 PURSUANT Report TO ARS Treasurer § 35-323 MARKET $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $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 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $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 displayed displayed treasureranaricopa.gov Royce in in $3,027.92 $2,957.50 $7,299.39 $35,360.43 $92,470.89 $17,709.84 $110,180.73 $78,225.64 $38,355.19 $1,894.08 $513,867.50 $562,903.22 $1,195,245.63 $292,324.44 $739,408.89 $1,031,733.33 $732,614.79 $732,614.79 $1,111,970.25 $1,111,970.25 $237,886.44 $247,161.83 $485,048.28 $445,822.63 $5,404.33 $451,226.97 $5,153,380.42 $118,175.00 $65,285.83 $26,405.42 $58,966.67 $268,832.92 $9,032.58 $10,069.58 $5,463.86 $5,028.69 $29,594.72 $126,652.83 $126,652.83 $246,861.39 $246,861.39 $828,265.63 $76,650.00 $10,268.75 $915,184.38 $14,780.68 ACCRUAL Treasurer T. YEARS. DAYS. Flora Straight-line School Source: Grand Row Status Portfolio Bonds BLOOMB Total Labels amortization and TANS ERG Saddle Peoria Gilbert Deer TANS COUNTY Detail applied. fair Washington Roosevelt PeoriaUSD Pendergast Paradise Glendale GilbertUSD Valley ChandlerUSD Chandler SCHOOL Riverside Listing values WashingtonESD SaddleMountainUSD Mountain RooseveltESD Unified PendergastESD ParadiseValleyUSD Valley GlendaleUHSD Union Unified DeerValleyUSD Unified ESD as are Elementary Unified 1.07 Elementary School Elementary Unified High 1.07 School Unified 1.07 School TANS 4.5 of amortized 1.07 School 1.07 School 1.0707/19/2017 District 1.07 School 1.07 School 1.0707/19/2017 School 07/19/2017 District 1.07 School 07/19/2017 District 07/01/2020 03/31/2017 cost. 07/19/2017 School 07/19/2017 District 07/1912017 District 07/19/2017 District District 07/19/2017 District District 07/19/2017 District Active 169 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 10 10 1 COUNT ALL PAR INVESTMENTS $3,416,372,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 Maricopa RESTRICTED Portfolio 5 PRINCIPAL County $3,421,340,419.49 $12,029,520.00 $12,029,520.00 $1,002,460.00 $1,002,460.00 $15,036,900.00 $15,036,900.00 537,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 535,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 PURSUANT Report TO ARS Treasurer 35-323 MARKET $3,068,707,667.51 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.0 0 $0.00 UNREALIZED GAIN LOSS 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 Duration (WAM) INTEREST displayed in displayed in $15,999,559.49 $69,200.42 $69,200.42 $5,766.70 $5,766.70 $86,500.53 $86,500.53 $213,367.96 $213,367.96 $72,083.77 $72,083.77 $115,334.03 $115,334.03 $86,500.53 $86,500.53 $201,834.56 $201,834.56 $201,834.56 $201,834.56 $259,501.58 $259,501.58 $1,311,924.64 $1,311,924.64 $22,075.63 ACCRUAL treasurer.maricopa.gov Royce T. YEARS. DAYS. Treasurer Flora PROGRAM 030 040 040 030 040 030 040 030 040 030 040 030 040 030 040 030 040 030 040 030 962 950 781 768 767 3.0.5 714 066 FUND ID: WTR 014 011 011 009 009 009 008 008 008 007 007 007 006 006 006 005 005 005 004 004 004 003 003 003 002 002 002 001 001 001 000 000 000 000 ..300: .0()0; .00.0: 000 000 DISTRICT District District District District District District District District District District District .71.41d. WARRANT OTSTND_WT_FUND Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund •.7.1:m0Tota1 FunaTotal Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total Total .....T2T•40, Total Total = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = •= . ... . = = = NUMBER MARICOPA OUTSTANDING 3:; WARRANT 8,365.41 3,708,450.91 3,708,450.91 79,487.78 72,822.67 6,665.11 657,932.87 646,719.37 11,213.50 87:622.6'2 86,467.32 1,155.30 1,019,185.18 960,651.45 58,533.73 1,264,907.40 1,143,666.46 121,240.94 4,160,419.74 3,523,313.48 627,106.26 925,674.24 833,487.05 92,187.19 227,491.01 225,076.94 2,414.07 1,154,627.67 1,078,216.50 76,411.17 4,489,070.32 10,968.77 39,529.20 221,580.87 -.85713-43 .42.541 2.3 296,811.10 6,688.91 WARRANTS COUNTY AMOUNT - Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: Count: . 1 Count: Count: Count: COUNT DISTRICT by TREASURER'S FUND - 11 68? 687 113 99 14 102 BO 22 37 36 1 400 275 125 276 128 148 2,037 801 1,236 384 213 171 35 32 3 343 176 167 13,784 17 31 482 4478 .V7.7 .37 11,247 615 OFFICE 31-MAR-2017 PACE: 31-MAR-2017 644 Program 31-120-000 Total - 1 30-100-000 Total - 1 30-099-000 30-094-000 30-093-000 30-092-000 30-091-000 30-090-000 30-066-000 30-077-000 30-066-000 30-064-000 30-063-000 30-062-000 30-061-000 30-060-000 30-059-000 30-050-000 30-049-000 00-048-000 30-045-000 30-044-000 30-043-000 30-042-000 30-041-000 30-036-000 30-035-000 30-034-000 30-003-000 30-028-000 30-027-000 30-026-000 Total - 1 30-025-199 30-025-191 30-025-190 30-025-189 30-025-188 30-025-187 30-025-186 30-025-185 30-025-184 Number Account ID: ACC SHERIFF COUNTY '9ENE.IP.L TREAS SUSPENSE BANK SUSPENSE SUSPENSE TEMP HLD UNIDENTIFIED EXCESS RECORDER CURRENT PROBLEM TRUST TAYLOR UNDISTRIBUTED UNDISTRIBUTED REDEMPTION ELDERLY ELDERLY GPLET GOLF CIVIL UPPS TAXPAYER IRS INTEREST SURTAX LITIGATION RESOLUTION CASHIER'S SACK TAX REFUND DES CLEARING DES ACCT DES ACCOUNT DEP ACCT DES ACCT DEP ACCOUNT DES ACCOUNT DEP ACCT DER ACCT DEP ACCT FUND_BAL_MTD WAREHOUSE GENERAL FUNDS SUSPENSE-PREPAYMENTS SERVICE CHARGE MORTGAGE CASHIER'S FD MONEY WIRES PROCEEDS FEE TAX HOLDING CHECK FUND FOR GRAZING TAX HOLDING ASSISTANCE ASSISTANCE HOLDING COURSE PENALTY RESOLUTION INFORMATION AND ASSIGN PENDING HOLDING HOLDING CLEARING REVENUE COUNTRY HIGHLAND DESERT WEST NORTH PENDERGAST ENVIR JUVENILE Description FUNDS COMPANIES TO BE FROM REFUNDING HOLDING NON-DELIVERABLE ACT INTEREST COLLECTIONS HOLD - CONVERSION HOLDING IMPOUNDS WITHHOLDING HOLDING DEBITS/CREDITS PROCESSING MEADOWS DC RIDGE SC TEMPE VALLEY SCHOOL SERVICES CT APPR OR TRUSTEE INCOME INVESTMENT FUND HE RESOLUTIONS SC DC JC UNKNOWN SALES REFUNDS 2149 SERVICE 1 94 , 72 M 351,202.58- 194,723,245.43 3,2 45 - 42,750,636.42 2,823,455.34 5,249,627.03 461,160.69 394,263.16- 17,292,256.51 2,091.92 1,667,687.87 170,915-22- 245,697.48 5,071,760.79 1,124,316.30 1,062,686.92 5,5E11,752.68 1.00 1,550,240.39 405,039.51 383.20 9,662.38 10,563.15 93,590.62 39,951.35- 683,397.87 10,340,246.06 1,162,826.69 129,281.94 69,474.98 132,460.31 187,069.53 134,878.61 470,116.11 Balance Opening Treasurer's ARICOPA 42 Report for COUNTY 55,796,313.72 •55,796,313.72 243,923,723.34 104,424.62 1,097,521.84 2,296,877.34 2.269,337.61 3,204,463.52- 810,500.07 233,690,186.56 3,394,480.04 1,554.00 8,897.25 19,484.58- 5,696.74- 248,459.50 1,231,179.15 1,575,006.29 2,981,171.38 18,405.27 15,532.47 24,425.70 10,036.72 10,294.11 340,704.61- Distribution Income the Month of MAR, TREASURER'S 126,767_7o 85,450,102.81 85,450,102.81 239,619,297.92 79.35 4,003.45 2,040.00 5,882,260.86 233,725,841.47 2,284.36 1,234.00 1,554.42 From 2017 oFFIcE Transfer 226,080.15 40,946,635.51 40,946,635.51 72,994.16 21,928.51 4,807.67 408.22 35,161.59 10,678.19 15,155,16 357.65 231.91 657.75 613.70 501,03 To 66,481.99 66,481 7,663,378.62 143,940.25 148,009.54- 2,309,671.26 3,429.47 4,114,339.26 263.20 1,229,624.72 Disbursements .99 461,890.21- 205,949,609.66 205,949,629.66 39,474,679.40 2,805,798.87 6,343,145.42 609,170.43 1,902,614.18 17,249,851_06 1,337.55- 988,012.02 170,915.22- 246,105.70 1,123,822.98 340,543.34 5,581,752.66 1.00 1,550,240.39 417,271.70 17,325.63 10,563.15 74,106,14 45,247.79- 931,857.37 11,530,407.51 4,143,998.07 156,044.86 85,239.36 158,543.76 157,719.96 145,673.75 129,411.50 Balance Closing PAGE: 04-APR-2017 2 PROGRAM TOTAL 1968 1969 1970 1971 1972 1973 1974 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 YEAR ID: APP 90,867,625,621.32 116,414,184.58 126,692,073.74 138,694,628.82 165,623,012.50 191,805,552.44 224,585,828.94 251,690,646.52 294,189,512.68 332,481,242.68 360,443,065.88 365,594,731.04 382,783,606.36 373,230,675.34 402,942,488.72 451,214,378.40 530,525,148.42 600,944,379.84 721,770,831.08 870,295,854.72 1,049,888,299.56 1,181,440,841.12 1,306,266,536.54 1,445,084,095.32 1,485,482,338.84 1,477,426,592.42 1,476,046,063.04 1,507,769,663.58 1,683,783,514.12 1,631,715,958.46 1,800,100,859.36 1,939,463,904.72 2,108,718,697.02 2,290,234,573.96 2,595,278,869.32 2,792,576,236.72 3,049,037,955.00 3,246,259,075.84 3,489,841,477.20 3,660,387,436.00 4,001,594,678.74 4,288,606,572.70 4,593,263,862.98 4,411,089,394.04 4,138,461,193.04 4,045,298,460.92 4,019,480,209.28 4,243,506,812.16 4,364,407,727.86 4,643,191,878.76 LEVY_RPT_MONTH_SUM LEVY BEGINNING MARICOPA 2,005,447,778.49 331.83 922.38 1,998.26 4,111.30 5,885.92 6,216.48 8,954.20 10,864.89 12,599.20 12,427.08 17,517.30 15,972.66 11,278.23 13,532.33 11,576.64 28,887.27 21,166.00 86,095.02 17,523.14 22,363.14 3,284,780.25- 8,122,159.39 7,952,626.39 2,207,553.16 3,577,213.60 1,190,791.47 1,128,169.02- 758,266.74- 78,784.46- 651,506.18- 762,845.98- 679,575.16- 571,408.07- 741,070.41 1,192,788.32- 732,235.98- 635,402.65 587,993.98 684,724.05- 547,385.47- 26,219,544.46 87,275,904.22 42,801,131.34- 20,940,654.81 1,004,767.50- 1,741,577.34 2,061,305.15 3,609,078.06 1,893,153,048.66 BALANCE SECURED LEVY COUNTY AND 233,070,282.34 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 1,985.98 887.22 7.34 677.66 2,120.42 1,663.49 1,707.74 1,444.97 2,719.58 1,891.06 7,647.68- 3,473.77- 3,162.10 149,660.96- 88,159.02- 233,300,956.21 COLLECTIONS ACTIVITY TREASURER FOR MAR ADJUSTMENTS 2017 S 1,311,229.24- .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 421.86- 395.87- 363.72- 1,017.70- 249.61- 506.05- 561.08- 11,686.45- 11,241.97- 8,464.62- 216,161.79- 435,014.72- 625,142.80- OFFICE ENDING 1,771,066,266.91 331.83 922.38 1,998.26 4,111.30 5,885.92 6,216.48 8,954.20 10,864.89 12,599.20 12,427.08 17,517.30 15,972.66 11,278.23 13,532.33 11,576.64 28,887.27 21,166.00 86,095.02 17,523.14 22,363.14 3,284,780.26- 8,122,159.39 7,952,626.39 2,207,553.16 3,577,213.60 1,190,791.47 1,128,169.02- 758,266.74- 78,784.46- 551,506.18- 752,845.98- 67957.16- 571,408.07- 739,084.43 1,193,675.54- 732,243.32- 634,303.13 585,476.69 685,751.26- 550,110.91- 26,217,849.88 87,272,678.59 42,803,583.48- 20,936,616.04 1,012,535.70- 1,729,950.62 1,994,804.32 3,262,222.36 1,659,226,949.65 BALANCE PAGE: 04-APR-2017 1 PROGRAM TOTAL 1968 1969 1970 1971 1972 1973 1974 1975 1976 1977 1979 1979 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1996 1999 2000 2001 2002 2003 2004 YEAR ID; APP 2,325,116,156.87 4,195,165.19 5,918,654.86 10,386,975.86 12,084,654.91 13,623,786.21 13,177,965.26 15,296,922.12 19,189,042.79 23,204,794.95 26,779,663.13 29,615,308.42 29,722,220.00 30,075,323.04 36,683,300.76 37,836,109.79 73,434,045.21 53,570,953.57 50,507,999.56 76,956,283.43 88,991,362.81 96,811,185.54 113,929,972.43 122,744,902.09 131,582,120.56 140,629,687.78 154,917,045.68 162,209,939.25 113,747,601.86 102,673,892.06 115,134,253.32 122,881,710.56 122,871,629.32 138,497,672.37 19,330,396.80 16,903,615.38 LEVY_RPT_MONTE_SUM .00 .00 LEVY BEGINNING MARICOPA 405,450,605.68- 2,320,992.14- 1,422,511.95- 433,497.42- 1,719,922.67- 2,953,534.09- 5,836,677.39- 5,472,248.17- 2,664,351.52- 2,691,654.20- 5,929,894.62- 6,812,702.12- 6,557,551.22- 17,272,723.62- 18,055,558.20- 22,905,048.43- 6,576,315.56- 12,928,887.66- 28,111,506.34- 25,772,503.22- 7,182,166.67- 21,535,273.18- 7,916,098.68- 950,404.31- 6,346,918.69- 17,538,323.77- 14,418,395.70- 6,107,367.73 28,750,023.25- 35,071,373.61- 22,885,662.62- 25,510,469.15- 28,448,294.77- 9,254,662.88- 870,158.37- 3,066,594.70 13,308,709.20- 197,750.52- BALANCE UNSECURED LEVY COUNTY AND 3,161.49 .00 .00 .00 .00 24.42 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 211.07 92.16 91.01 .00 .00 299.11 .00 .00 .00 .00 .00 158.24 174.15 172.02 349.26 848.20 741.85 .00 COLLECTIONS ACTIVITY TREASURER FOR MAR 2017 S ADJUSTMENTS 860.18- .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 148.95- 281.74- 429.49- .00 OFFICE ENDING 405,454,827.35- 2,320,992.14- 1,422,511.95- 433,497.42- 1,719,922.67- 2,953,558.51- 5,836,677.39- 5,472,248.17- 2,664,351.52- 2,691,654.20- 5,929,894.62- 6,812,702.12- 6,557,551.22- 17,272,723.62- 18,055,556.20- 22,905,048..43- 6,576,315.56- 12,928,987.66- 28,111,508.34- 25,772,503.22- 7,182,377.74- 21,535,365.34- 7,916,189.69- 950,404.31- 6,348,916.69- 17,538,622.88- 14,418,395.70- 9,107,367.73 28,750,023.25- 35,071,373.61- 22,885,662.62- 25,510,627.39- 28,448,468.92- 9,254,834.90- 870,656.58- 3,065,464.76 13,309,880.54- 197,750.52- BALANCE PAGE: 04-APR-2017 1