Extracted text (via pymupdf_layout)
37278 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://treasurer.maricopa.gov DATE: February 7, 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 January 2017 Secured property tax collections during the month of January equaled $87,850,966 and increased the 2016 year to date collections to $2,613,143,181 or 56.42% of the adjusted 2016 levy of $4,631,224,974. The chart below reflects the 2016 collected and uncollected levy amount and corresponding percentages for the 2016 property tax year. JANUARY 2017 Uncollected Levy $2,018,081,793 43.6% Collected Levy $2,613,143,181 56.4% • Collected Levy • Uncollected Levy The County's General Fund Balance totaled $187,768,116.60 effective January 31, 2017. Warrants outstanding of $8,366,053.94 will post against the fund balances when presented. A new fund was added to the outstanding warrants-district by fund report in July 2016 due to the implementation of the new county accounting system, CGI Advantage 3x. The July thru December reports do not reflect the correct amount of the outstanding warrants as the new fund was not included in those calculations. Going forward, starting with the January 2017 report, this fund will be included in the calculation of warrants outstanding in the Treasurer's Collection & Investments Summary submitted to the Board each month. 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. Submitted under oath, Russell K. Pearce Chief Deputy Treasurer STATE OF ARIZONA ) ss. COUNTY OF MARICOPA ) This instrument was acknowledged before me this 7th day of February 2017, by Royce T. Flora, 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. Nota Public My Commission Expires • KAREN D. SMITH Notary Public - Arizona Maricopa County My Comm. Expires Dec 15, 2017 Flora. 1.10 1.14 1.14 1.63 0.25 2.28 0.74 0.76 1.18 0.55 1.10 DAYS. YEARS. T. Treasurer DURATION in in Royce treasurer.maricopa.gov displayed displayed INAN1 426 442 442 626 92 894 275 282 448 201 426 (WAM) Duration Weighted-Average-Maturity IBEM 0.80% 0.79% 0.79% 0.99% 0.46% 1.18% 0.75% 0.93% 1.16% 0.82% 0.80% 0.59% 0.71% 1.30% Index Index Index $3,416,385,936 $3,068,857,353 $3,068,857,353 $426,238,885 $1,424,255,697 $1,003,505,544 $214,857,227 $347,528,584 $119,468,934 $228,059,650 $3,416,385,936 FAIR Treasury Treasury Agency Active SCHOOL DISTRICT 10% Active USGN 6% 35-323 US US US ARS Month Year Year Treasurer TO BENCHMARKS 0-1 1-3 $3,423,303,583 $3,074,890,846 $3,074,890,846 $428,011,918 $1,422,638,354 $1,009,142,331 $215,098,242 $348,412,738 $120,353,088 $228,059,650 $3,423,303,583 1-3 Lynch Lynch Allocation Report PURSUANT Lynch Merrill Merrill Merrill County BofA BofA Issuer 1 Portfolio RESTRICTED BofA $3,418,458,000 $3,078,743,000 $3,078,743,000 $428,163,000 $1,426,280,000 $1,009,300,000 $215,000,000 $339,715,000 $112,215,000 $227,500,000 $3,418,458,000 Active GOVT AGENCY 84% Maricopa INVESTMENTS Amount of Face rn ALL TOTAL 100.00% 90.06% 90.06% 12.53% 41.72% 29.53% 6.29% 9.94% 3.28% 6.66% 100.00% OF 1213012016 .% Count 157 110 110 20 40 43 7 47 37 10 157 Count 7 7 2 1 1 3 63 56 22 10 8 16 7 7 47 47 40 40 6 7 18 9 157 of as Active Active cost. Disclosures BANK BANK BANK BANK NT NT NT amortized BONDS TANS CREDIT LOAN CREDIT LOAN NOTE DISCOUNT DISCOUNT DISCOUNT are value. Risk NOTES N/B values market applied. Portfolio INCOME TREASURY SCHOOL SCHOOL MAE FARM HOME MAC MAE FARM HOME MAC DISTRICT DISCOUNT CRD LN MAC fair is Investment Available-for-Sale BONDS DISCOUNT NOTES AGENCY AGENCY TREASURY AGENCY FARM HOME TANS value amortization FIXED US Hold-to-Maturity COUNTY COUNTY Total Ratings FANNIE FEDERAL FEDERAL FREDDIE FANNIE FEDERAL FEDERAL FREDDIE US rated) SCHOOL FANNIE FED FED FREDDIE Total and fair 40 GOVT GOVT USGN (not GOVT Bonds Income GASS Status POOL Grand Status Credit AA+ Aaa NR P-1 Grand School Fixed Straight-tine Flora T. Treasurer DAYS. in YEARS. in Royce treasurer.maricopa.gov displayed displayed (WAM) Duration 35-323 GAIN/(LOSS) ($6,033,493) ($6,033,493) ($6,033,493) ($1,773,033) $1,617,342 ($5,636,787) ($241,016) $0 $0 $0 ($6,033,493) ,A.qPik:0412) $17,170,200 $10,349,178 $10,349,178 $2,439,951 $1,788,806 $4,916,380 $1,204,041 $6,821,022 $5,980,975 $840,047 $17,170,200 Weighted-Average-Maturity ARS TO UNREALIZED PURSUANT $0 $0 $0 RESTRICTED MARKET $3,068,857,353 $3,068,857,353 $3,068,857,353 $426,238,885 $1,424,255,697 $1,003,505,544 $214,857,227 $3,068,857,353 $3,422,310,684 $3,074,782,100 $3,074,782,100 $428,027,518 $1,422,638,354 $1,009,114,294 $215,001,934 $347,528,584 $119,468,934 $228,059,650 $3,422,310,684 INVESTMENTS Treasurer ALL FAIR $3,416,385,936 $3,068,857,353 $3,068,857,353 $426,238,885 $1,424,255,697 $1,003,505,544 $214,857,227 $347,528,584 $119,468,934 $228,059,650 416,385,936 $3,423,303,683 $3,074,890,846 $3,074,890,846 $428,011,918 $1,422,638,354 $1,009,142,331 $215,098,242 $348,412,738 $120,353,088 $228,059,650 $3,423,303,583 Report $3 County Portfolio 12130/2016 -0[ $3,423,303,583 $3,074,890,846 $3,074,890,846 $428,011,918 $1,422,638,354 $1,009,142,331 $215,098,242 $348,412,738 $120,353,088 $228,059,650 $3,423,303,583 $3,418,458,000 $3,078,743,000 $3,078,743,000 $428,163,000 $1,426,280,000 $1,009,300,000 $215,000,000 $339,715,000 $112,215,000 $227,500,000 $3,418,458,000 2 Maricopa of as IM/47 Reporting COUNT 157 110 110 20 40 43 7 47 37 10 157 157 110 110 20 40 43 7 47 37 10 157 & Active Active Accounting BONDS TANS _ BONDS TANS investment INCOME NOTES TREASURY SCHOOL SCHOOL P-WoliMMINEWIRMIMW INCOME NOTES TREASURY SCHOOL SCHOOL 31 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 cost. amortized Statement Status ±Portiollo POOL Grand Status POOL Grand are value. GASB values fair market is applied. TANS and value fair amortization Bonds School Income Fixed Straight-line Flora T. Royce , Treasurer ACCRUAL $17,170,199.70 $10,349,177.78 $10,349,177.78 $2,439,951.24 $1,564,196.38 $144,583.33 $255,208.33 $355,300.00 $123,958.33 $106,154.72 $143,805.56 $158,000.00 $104,975.00 $153,113.88 $19,097.22 $875,754.86 $127,141.67 $134,477.78 $141,666.67 $120,555.56 $88,010.42 $105,625.00 $92,277.78 $66,000.00 $1,788,806.22 $547,020.97 $125,165.15 $66,934.01 $324,566.45 $30,355.36 $574,451.66 $109,421.61 $347,077.16 $67,594.74 $20,484.29 $29,873.87 $372,625.56 $57,242.60 $31,716.33 $31,666.22 $24,830.10 $13,252.83 $22,042.08 $20,978.63 $25,182.15 DAYS. in displayed YEARS. in displayed treasurer.rnaricopa.gov INTEREST (WAM) Duration LOSS ($6,033,493.02) ($6,033,493.02) ($1,773,032.93) ($1.293,592.93) ($3,300.00) ($131,500.00) ($126,300.00) ($188,250.00) ($140,713.30) ($189,500.00) ($145,150.00) ($318,240.00) (5784.38) ($49,855.25) ($479.440.00) ($12,600.00) ($4,800.00) ($23,700.00) $8,800.00 ($3,740.00) ($231,000.00) ($184,400.00) ($28,000.00) $1,617,342.38 $517,885.28 $139,163.33 $65,864.44 $287,757.50 $25,100.00 $500,203.00 $107,415.00 $299,953.33 $55,116.67 $12,350.00 $25,368.00 $351,763.41 $48,479.44 $28,211.11 $25,174.44 $21,185.25 $12,180.56 $19,601.11 $20,463.33 $20,468.75 Weighted-Average-Maturity GAIN UNREALIZED $3,068,857,352.56 $3,068,857,352.56 $3,068,857,352.56 $426,238,884.82 $264,819,494.82 $29,996,700.00 $24,859,000.00 $29,873,700.00 $24,811,750.00 $21,932,719.20 $24,810,500.00 $44,858,250.00 $25,679,160.00 $13,072,215.62 $24,925,500.00 $161,419,390.00 $29,956,200.00 $19,995,200.00 $14,976,300.00 $20,001,800.00 $16,955,290.00 $19,747,000.00 $19,815,600.00 $19,972,000.00 $1,424,255,696.78 $224,482,638.06 $29,939,280.00 $19,998,975.56 $134,618,482.50 $39,925,900.00 $253,303,628.56 $26,938,155.00 $119,602,403.33 $39,863,305.56 $24,966,516.67 $41,933,248.00 $592,005,387.39 $19,936,951.67 $39,990,07718 $39,978,896.67 $42,289,495.50 $24,997,208.33 $39,993,601.11 $39,996,296.67 $44,985,406.25 35-323 MARKET Treasurer ARS TO Report PURSUANT PRINCIPAL $3,423,303,583.34 $3,074,890,845.59 $3,074,890,845.59 $428,011,917.75 $266,113,08715 $30,000,000.00 $24,990,500.00 $30,000,000.00 $25,000,000.00 $22,073,432.50 $25,000,000.00 $45,003,400.00 $25,997,400.00 $13,073,000.00 $24,975,355.25 $161,898,830.00 $29,968,800.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 $20,000,000.00 $1,422,638,354.40 $223,964,752.78 $29,800,116.67 $19,933,111.11 $134,330,725.00 $39,900,800.00 $252,803,425.56 $26,830,740.00 $119,302,450.00 $39,808,188.89 $24,954,166.67 $41,907,880.00 $591,653,623.98 $19,888,472.22 $39,961,866.67 $39,953,722.22 $42,268,310.25 $24,985,027.78 $39,974,000.00 $39,975,833.33 $44,964,937.50 County Portfolio RESTRICTED Maricopa INVESTMENTS PAR $3,418,458,000.00 $3,078,743,000.00 $3,078,743,000.00 $428,163,000.00 $266,163,000.00 $30,000,000.00 $25,000,000.00 $30,000,000.00 $25,000,000.00 $22,090,000.00 $25,000,000.00 $45,000,000.00 $26,000,000.00 $13,073,000.00 $25,000,000.00 $162,000,000.00 530,000,000.00 $20,000,000.00 $15,000,000.00 $20,000,000.00 $17,000,000.00 $20,000,000.00 $20,000,000.00 $20,000,000.00 $1,426,280,000.00 $225,000,000.00 $30,000,000.00 $20,000,000.00 $135,000,000.00 $40,000,000.00 $254,000,000.00 $27,000,000.00 $120,000,000.00 $40,000,000.00 $25,000,000.00 $42,000,000.00 $592,280,000.00 $20,000,000.00 $40,000,000.00 $40,000,000.00 $42,300,000.00 $25,000,000.00 $40,000,000.00 $40,000,000.00 $45,000,000.00 ALL COUNT 157 110 110 20 11 1 1 1 1 1 1 2 1 1 1 9 1 1 1 1 1 1 2 1 40 6 1 1 3 1 7 1 3 1 1 18 1 1 1 1 1 1 1 1 Active 12130/2016 BANK BANK NOTE NT DISCOUNT NT cost. of CREDIT 01/13/2017 07130/2018 08/02/2018 07/05/2019 01107/2019 01/13/2020 03/22/2018 06127/2019 01/28/2019 12/05/2018 LOAN HOME 06/30/2017 12/28/2018 12/28/2018 05/23/2018 06/29/2018 10/11/2019 04/26/2019 05/18/2018 DISCOUNT 05/17/2017 01/03/2017 06/30/2017 05/09/2017 CRD 05/12/2017 06/29/2017 07/03/2017 03/24/2017 04/05/2017 DISCOUNT 06/29/2017 001/18/2017 02107/2017 001/19/2017 001/09/2017 001/12/2017 01/10/2017 01/24/2017 amortized are value. as Listing INCOME FARM FEDERAL 0.5 FFCB 0.875 FFCB 1.02 FFCB 1.02 FFCB 1 FFCB 1.24 FFCB 0.8 FFCB 0.95 FFCB 1.27 FFCB 1.1 FFCB FEDERAL 013 FHLB 1.33 FHLB 1.25 FHLB 1 FHLB 0.875 FHLB 1.125 FHLB 1,1 FHLB 0.9 FHLB NOTES 0 FNMDN 0 FNMDN 0 FNMDN 0 FNMDN FARM 0 FFCBDN 0 FFCBDN 0 FFCBDN 0 FFCBDN 0 FFCBDN LN HOME 0 FHLBDN FHLBDN 0 FHLBDN EHLBDN FHLBDN FHLBDN 0 FHLBDN 0 FHLBDN values fair market applied. Detail Available-for-Sale FIXED BONDS DISCOUNT FANNIE FED FED TANS and is value fair amortization Portfolio Status Labels Row POOL Bonds School Income Fixed Straight-line Flora T. Royce Treasurer ACCRUAL $18,359.83 $10,943.75 $18,874.26 $16,875.44 $19,172.29 $14,840.94 $22,800.07 $12,081.53 $11,766.49 $294,708.03 $53,371.19 $45,181.33 $43,752.42 $15,618.19 $49,173.91 $26,734.87 $34,683.93 $26,192.20 $4,916,379.51 $2,449,407.99 $167,708.33 $188,281.25 $108,266.67 $290,325.00 $153,222.22 $121,333.33 $166,250.00 $122,500.00 $106,944.49 $96,250.00 $112,311.11 $134,000.00 $83,333.33 $84,583.33 $55,763.89 $74,825.00 $61,250.00 $73,762.50 $38,674.65 $59,093.75 $54,166.67 $45,000.00 $31,250.00 $20,312.50 $2,466,971.53 $166,250.00 DAYS. in displayed YEARS. in displayed treasurer.maricopa.gov INTEREST (WAM) Duration LOSS $17,233.33 $9,053.16 $15,111.25 $17,116.67 $16,129.17 $12,576.39 $21,275.56 $37,415.83 $10,088.06 $247,490.70 $48,000.00 $40,416.67 $35,926.25 $10,913.89 $35,252.78 $18,480.00 $32,465.00 $26,036.11 ($5,636,786.85) ($4,182,680.60) $119,000.00 ($115.000.00) ($54,450.00) ($154,000.00) ($21,400.00) ($142,400.00) ($247,800.00) ($288,000.00) ($317,750.00) ($182,400.00) ($188,800.00) ($195,900.00) ($149,000.00) ($288,200.00) ($274,500.00) ($274,200.00) ($241,000.00) ($426,300.00) ($175,338.40) ($102,492.20) ($268,000.00) ($237,600.00) $37,750.00 $5,100.00 ($1,954,106.25) ($13,650.00) Weighted-Average-Maturity GAIN UNREALIZED $39,997,600.00 $19,973,391.06 $34,987,111.25 $24,967,283.33 $34,985,834.72 $24,988,076.39 $39,974,342.22 $29,997,040.83 $49,966,773.61 $354,464,042.78 $44,905,500.00 $39,915,416.67 $44,904,370.00 $24,986,594.44 $79,955,377.78 $39,964,935.56 $44,903,715.00 $34,928,133.33 $1,003,505,544.40 $557,487,400.65 $25,007,250.00 $24,885,000.00 $14,930,550.00 $34,846,000.00 $19,978,600.00 $19,842,400.00 $29,752,200.00 $24,712,000.00 $24,682,250.00 $19,817,600.00 $19,811,200.00 $29,804,100.00 $19,851,000.00 $19,711,800.00 $24,671,750.00 $29,725,800.00 $24,759,000.00 $29,573,700.00 $17,785,170.35 $18,802,780.30 $24,732,000.00 $19,762,400.00 $25,037,750.00 $15,005,100.00 $446,018,143.75 $14,986,350.00 35-323 MARKET Treasurer § ARS TO Report PURSUANT $39,980,366.67 $19,964,337.90 $34,972,000.00 $24,950,166.67 $34,969,705.56 $24,975,500.00 $39,953,066.67 $29,959,625.00 $49,956,685.56 $354,216,552.08 $44,857,500.00 $39,875,000.00 $44,868,443.75 $24,975,680.56 $79,920,125.00 $39,946,455.56 $44,871,250.00 $34,902,097.22 $1,009,142,331.25 $561,670,081.25 $24,888,250,00 $25,000,000.00 $14,985,000.00 $35,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 $30,000,000.00 $20,000,000.00 $20,000,000.00 $24,946,250.00 $30,000,000.00 $25,000,000.00 $30,000,000.00 $17,960,508.75 $18,905,272.50 $25,000,000.00 $20,000,000.00 $25,000,000.00 $15,000,000.00 $447,472,250.00 $15,000,000.00 County PRINCIPAL 2 Portfolio RESTRICTED Maricopa $40,000,000.00 $19,980,000.00 $35,000,000.00 $25,000,000.00 $35,000,000.00 $25,000,000.00 $40,000,000.00 $30,000,000.00 $50,000,000.00 $355,000,000.00 $45,000,000.00 $40,000,000.00 $45,000,000.00 $25,000,000.00 $80,000,000.00 $40,000,000.00 $45,000,000.00 $35,000,000.00 $1,009,300,000.00 $561,875,000.00 $25,000,000.00 $25,000,000.00 $15,000,000.00 $35,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 $30,000,000.00 $20,000,000.00 $20,000,000.00 $25,000,000.00 $30,000,000.00 $25,000,000.00 $30,000,000.00 $17,965,000.00 $18,910,000.00 $25,000,000.00 $20,000,000.00 $25,000,000.00 $15,000,000.00 $447,425,000.00 $15,000,000.00 INVESTMENTS PAR ALL COUNT 1 1 1 1 1 1 1 1 2 1 1 1 1 2 1 1 43 24 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 19 1 Active 12/30/2016 NT cost. of 01/04/2017 001125/2017 001126/2017 00411312017 01/30/2017 02/02/2017 02/14/2017 03/0712017 02/15/2017 DISCOUNT 05/23/2017 05/24/2017 005/25/2017 002/06/2017 02/08/2017 03102/2017 05126/2017 005119/2017 10/26/2017 10/29/2018 11/16/2018 05/03/2019 06113/2019 06/2812019 07/05/2019 07/1212019 07/26/2019 07/26/2019 01/28/2020 08/16/2019 08/23/2019 09/15/2020 10/17/2019 10117/2019 07/27/2020 10/27/2020 10/28/2019 09/30/2019 07/28/2020 07/28/2020 11/26/2019 05/26/2020 04126/2018 amortized are as Listing 0 FHLBDN FHLBDN FHLBDN FHLBDN 0 FHLBDN 0 FHLBDN 0 FHLBDN 0 FHLBDN 0 FHLBDN MAC 0 FREDN 0 FREDN FREDN FREDN 0 FREDN 0 FREON 0 FREDN FREDN MAE 0,875 FNMA 1.125 FNMA 1.16 FNMA 1.26 FNMA 1.4 FNMA 1.2 FNMA 1.14 FNMA 1.05 FNMA 1 FNMA 1.125 FNMA 1.33 FNMA 1.2 FNMA 1.25 FNMA 1.45 FNMA 1.1 FNMA 1.23 FNMA 1,4 FNMA 1.405 FNMA 1.25 FNMA 1.25 FNMA 1.3 FNMA 1.35 FNMA 1,5 FNMA 1.625 FNMA MAC FREDDIE 0.95 FHLMC values fair value. market applied. Detail FREDDIE NOTES FANNIE TANS and is value amortization Portfolio Status Labels Row Bonds fair income Straight-line School Fixed Mora T. Royce Treasurer ACCRUAL $445,118.75 $347,500.00 $158,083.33 $294,555.56 $313,368.06 $189,583.33 $138,775.00 $101,111.11 $55,000.00 $45,208.33 $65,975.00 $44,950.00 $38,888.89 $44,777.78 $17,826.39 $1,204,040.80 $1,204,040.80 $470,037.77 $260,360.05 $111,888.59 $99,456.52 $169,057.38 $93,240.49 $6,821,021.92 $5,980,975.31 $1,441,344.14 $34,829.98 $6,811.20 $6,669.30 $4,099.10 $4,611.49 $12,638.89 $821,728.32 $8,309.72 $68,899.83 $744,518.77 $222,809.58 $222,809.58 $114,734.10 $114,734.10 $13,659.10 $2,320.93 $2,521.78 $4,647.50 $4,168.88 $233,583.06 DAYS. in displayed YEARS. in displayed treasurer,maricopa.gov INTEREST 0.4/AM) Duration LOSS (3121.056.25) ($64,800.00) ($15,400.00) ($94,800.00) ($34,750.00) $23,000.00 ($70,200.00) ($31,000.00) ($28,800.00) ($13,000.00) ($354,600.00) ($134,700.00) ($210,200.00) ($289,400.00) ($750.00) ($241,015.63) ($241015.63) ($57,617.19) ($8,203.13) $103,125.00 345,312.50 (3215,820.31) (3107.812.50) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $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 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 $47,303,943.75 $29,935,200.00 $19,984,600.00 $39,905,200.00 $25,042,500.00 $24,993,000.00 $29,929,800.00 $24,969,000.00 $19,971,200.00 $24,987,000.00 $29,645,400.00 $29,865,300.00 $19,789,800.00 $39,710,600.00 $24,999,250.00 $214,857,226.56 $214,857,226.56 $75,005,859.38 $35,023,242.19 $29,955,468.75 $20,017,968.75 $25,035,156.25 $29,819,531.25 35-323 MARKET Treasurer ARS TO Report PURSUANT $47,425,000.00 $30,000,000.00 $20,000,000.00 $40,000,000.00 $25,077,250.00 $24,970,000.00 $30,000,000.00 $25,000,000.00 $20,000,000.00 $25,000,000.00 $30,000,000.00 $30,000,000.00 $20,000,000.00 $40,000,000.00 $25,000,000.00 $215,098,242.19 $215,098,242.19 $75,063,476.56 $35,031,445.31 $29,852,343.75 $19,972,656.25 $25,250,976.56 $29,927,343.75 $348,412,737.75 $120,353,087.75 $50,025,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 $5,075,000.00 $1,040,000.00 $1,030,000.00 $1,650,000.00 $1,355,000.00 $9,500,000.00 County PRINCIPAL 3 Portfolio RESTRICTED Maricopa $47,425,000.00 $30,000,000.00 $20,000,000.00 $40,000,000.00 $25,000,000.00 $25,000,000.00 $30,000,000.00 $25,000,000.00 $20,000,000.00 $25,000,000.00 $30,000,000.00 $30,000,000.00 $20,000,000.00 $40,000,000.00 $25,000,000.00 $215,000,000.00 $215,000,000.00 $75,000,000.00 $35,000,000.00 $30,000,000.00 $20,000,000.00 $25,000,000.00 $30,000,000.00 $339,715,000.00 $112,215,000.00 $49,910,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 $5,075,000.00 $1,040,000.00 $1,030,000.00 $1,650,000.00 $1,355,000.00 $9,500,000.00 INVESTMENTS PAR ALL COUNT 2 1 1 2 1 1 1 1 1 1 1 1 1 2 1 7 7 2 1 1 1 1 1 47 37 18 5 1 1 1 1 1 3 1 1 1 1 1 1 4 1 1 1 1 4 Active 12130/2016 District School 07/01/2017 07/01/2018 07/01/2017 07/01/2018 07/01/2019 District School 07/01/2017 07/01/2017 07/01/2018 District School 07/01/2017 District 07101/2017 District School 07/01/2018 07/01/2019 07/01/2020 07/01/2021 District School cost. of 07/27/2018 08/03/2018 06/29/2018 10/29/2018 06/22/2018 0512412019 06127/2018 12/28/2017 09/21/2018 10/26/2018 11102/2020 11/02/2018 11/10/2020 11/27/2019 12/13/2019 N/B 12/31/2016 06/30/2017 12/31/2017 12115/2018 06130/2018 BONDS BONDS Elementary 1.98 1.98 2.29 2.29 2.29 High 1 1.46 1.975 Unified 1 School High 0.93 Elementary 1.03 1.13 1.3 1.42 Elementary amortized are as Listing 1 FHLMC 1 FHLMC 1.05 FFILMC 1.1 FHLMC 1.25 FHLMC 1.3 FHLMC 0.91 FHLMC 0.8 FHLMC 1 FHLMC 1.05 FHLMC 1.365 FHLMC 0.93 FHLMC 1.4 FHLMC 1.3 FHLMC 1.51 FHLMC TREASURY TREASURY 0.625 0.75 10.75 112/31/2017 1.25 0.625 SCHOOL IMPROVEMENT Cartwright CartwrighESD CartwrighESD CartwrightESD CartwrightESD CartwrightESD Union GlendaleUHSD GlendaleUHSD GlendaleUHSD Valley ParadiseValleyUSD Union PhoenixUHSD Riverside RiversideESD RiversideESD RiversideESD RiversideESD Washington values fair value. market applied. Detail US US T T T T T Hold-to-Maturity COUNTY Glendale Paradise Phoenix TANS is value amortization Portfolio Labels and Bonds fair Income Status Row School Fixed Straight-line Flora DAYS. YEARS. T. Treasurer ACCRUAL $52,798.89 $21,590.00 $53,380.00 $105,814,17 $4,539,631.17 $402,840.75 $4,412.81 $398,427.94 $433,362.81 $220,824.92 $212,537.89 $993,620.20 $993,620.20 $651,411.44 $651,411.44 $921,016.67 $660,061.94 $260,954.72 $1,024,329.69 $503,061.88 $459,239.06 $991.67 $20,081.25 $40,955.83 $96,729.42 $14,324.14 $82,405.28 $16,320.20 $3,368.95 $1,365.00 $1,397.50 $10,188.75 $840,046.61 $840,046.61 $166,163.07 $166,163.07 $129,237.94 $129,237.94 $129,237.94 $129,237.94 $55,387.69 $55,387.69 $73,850.25 $73,850.25 $46,156.41 $46,156.41 in displayed in Royce treasurer.maricopa.gov displayed INTEREST (VVAM) 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 $0.00 $0.00 $0,00 $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 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.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 MARKET 35-323 Treasurer .5 ARS Report TO $2,000,000.00 $1,500,000.00 $3,000,000.00 $3,000,000.00 $70,327,666.35 $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,461.00 $6,677,509.30 $6,677,509.30 $13,442,424.00 $9,656,252.00 $3,786,172.00 $16,508,436.00 $5,100,696.50 $4,581,891.00 $102,079.00 $2,190,888.00 $4,532,881.50 $1,627,741.10 $411,636.10 $1,216,105.00 $2,703,774.65 $1,095,000.00 $217,028.70 $225,734.95 $1,166,011.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 County PURSUANT PRINCIPAL 4 Portfolio RESTRICTED Maricopa $2,000,000.00 $1,500,000.00 $3,000,000.00 $3,000,000.00 $62,305,000.00 $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 $12,000,000.00 $8,600,000.00 $3,400,000.00 $14,270,000.00 $4,190,000.00 $3,825,000.00 $100,000.00 $2,025,000.00 $4,130,000.00 $1,470,000.00 $370,000.00 $1,100,000.00 $2,565,000.00 $1,095,000.00 $210,000.00 $215,000.00 $1,045,000.00 $227,500,000.00 $227,500,000.00 $45,000,000.00 $45,000,000.00 $36,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 INVESTMENTS PAR ALL 1 1 1 1 19 2 1 1 2 1 1 1 1 1 1 2 1 1 5 1 1 1 1 1 2 1 1 4 1 1 1 1 10 10 1 1 1 1 1 1 1 1 1 1 1 1 COUNT Active 07/0112017 07101/2018 07101/2019 07/01/2018 District 07/01/2017 District District District 01/01/2018 07/01/2017 District District 07/19/2017 District 07/19/2017 District 07/19/2017 District 07/19/2017 cost. 12130/2016 District 01/01/2018 07/01/2017 District 01/0112018 07/01/2017 School School 06/14/2017 District 01/01/2018 07/01/2017 School 01/0112018 07/01/2017 07/01/2017 07/01/2020 07/01/2021 School 3.62 3.62 School 07/01/2021 307/01/2018 307/01/2019 07/01/2020 District 07/19/2017 School District 07/19/2017 School School 1.07 School 1.22 1.27 1.57 1.63 School 5.23 5.23 School 2.3 High 3.33 5.96 School 3.65 3.65 5.65 5.65 3.57 3.57 3.57 Unified 1.42 4.5 TANS School 1.07 1.07 School 1.07 High 1.07 Unified Elementary 1.07 amortized of as WashingtonESD WashingtonESD VilashingtonESD WashingtonESD BONDS Unified ChandlerUSD ChandlerUSD Unified 2.3 DysartUSD DysartUSD Union GlendaleUHSD Elementary KyreneESD Unified PeoriaUSD PeoriaUSD Elementary PhoenixESD PhoenixESD PhoenixESD PhoenixESD PhoenixESD Creek QueenCreekUSD QueenCreekUSD Elementary RiversideESD RiversideESD RiversideESD RiversideESD SCHOOL Unified ChandlerUSD Unified Valley DeerValleyUSD Unified GilbertUSID Union GlendaleUHSD Valley ParadiseValleyUSD PendergastESD are values value. market applied. Listing REFUNDING Chandler Dysart Glendale Kyrene Peoria Phoenix Queen Riverside Chandler Deer Gilbert Glendale Paradise Pendergast fair TANS is Detail COUNTY TANS and value fair amortization Portfolio Labels Bonds income Status Row School Fixed Straight-fine Flora Treasurer DAYS. YEARS. T. ACCRUAL $136,622.96 $136,622.96 $55,387.69 $55,387.69 $3,692.51 $3,692.51 $44,310.15 $44,310.15 $17,170,199.70 in in Royce treasurer.maricopa.gov displayed displayed INTEREST (WAM) Duration • $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Weighted-Average-Maturity LOSS GAIN UNREALIZED $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3,068,857,352.56 MARKET 35-323 Treasurer ARS 4 TO Report $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,423,303,583.34 PURSUANT PRINCIPAL County 5 Portfolio RESTRICTED Maricopa $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,418,458,000.00 INVESTMENTS PAR ALL COUNT 1 1 1 1 1 1 1 1 157 Active District District 07/19/2017 District 12/30/2016 District 07/19/2017 School 07/19/2017 School 1.07 School 07/1912017 cost. of School 1.07 1.07 Unified Elementary 1.07 amortized as Unified Elementary RooseveltESD Mountain SaddleMountainUSD WashingtonESD values are value. Listing PeoriaUSD Roosevelt Washington fair market applied. Detail Peoria Saddle TANS value is Labels Total and fair amortization Portfolio Status Row Grand Bonds Income Straight-line School Fixed Charles "Hos" Hoskins, Treasurer 301 West Jefferson St., Rm. 100 _Phoenix, Arizona 85003 Maricopa County Phone: (602) 506-8511 Fax: (602) 506-1102 Treasurer littp://treasurer.marieopa.gov November 22, 2016 JPMorgan Chase Bank Chris Peterson 201 N. Central Ave., 21st fl, AZ1-1179 Phoenix, AZ 85004 Re: L/C No CTCS-920941 Dear Ms. Peterson: Maricopa County's Workers' Compensation Liability Form calculates the County's required security deposit with the Industrial Commission of Arizona (ICA) to be $13,526,071. The current Letter of Credit is $15,705,634 and we are requesting it be decreased by $2,179,563 to $13,526,071 which is the amount required by the MA. Sincerely, raffsr1-16s" Hoskin County Treasurer CC: C13.LC.ServicelTeam@chase.com Kimberly Houston David Chan PROGRAM 040 040 020 040 030 040 030 040 035 030 040 030 040 030 040 030 040 030 040 030 962 950 781 768 767 766 714 066 FUND ID: WTR 011 011 009 009 009 008 008 008 007 007 007 006 006 006 006 005 005 005 004 004 004 003 003 003 002 002 002 001 001 001 000 000 000 000 000 000 000 000 000 DISTRICT District District District District District District District District District District District 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 Fund Fund Fund 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 Total Total Total Total Total = = = = = = = - = = = = = = = = = = = = = = = = = = - = = = = = = -. = = = = - NUMBER MARICOPA OUTSTANDING WARRANT 504,166.22 504,166.22 245,354.82 239,863.13 6,091.69 256,764.41 244,434.32 12,330.09 211,663.51 209,795.64 1,867.87 1,015,963.66 941,311.87 1,000.00 73,651.79 464,228.63 356,009.05 108,219.58 6,139,222.74 1,428,914.76 4,710,307.98 451,068.60 341,026.83 110,041.77 381,846.48 378,344.61 3,501.87 2,704,114.93 2,684,443.78 19,671.15 9,038,567.66 148,808.28 118,005.65 93,412.87 8,286,556.62 57,231.03 22,266.29 305,285.52 7,001.40 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: Count: Count: Count: Count: Count: COUNT DISTRICT by TREASURER'S FUND - 631 631 106 92 14 117 89 28 65 62 3 298 148 1 149 209 95 114 1,333 625 708 329 150 179 37 33 4 310 259 51 14,894 47 43 214 981 275 44 12,469 821 OFFICE 31-JAN-2017 PAGE: 31-JAN-2017 617 Program 31-120-000 Total - 1 30-100-000 Total - 1 39-099-000 30-094-000 30-093-000 30-692-000 30-091-000 30-090-000 30-086-000 30-077-000 30-066-000 30-064-000 30-063-000 30-062-000 30-061-000 30-06C-000 30-959-000 30-050-000 30-049-000 30-048-000 30-045-000 30-044-000 30-043-000 30-042-000 30-041-000 3C-036-000 30-035-000 30-034-000 30-033-000 30-028-000 3C-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 GENERAL TREAS SUSPENSE BANK SUSPENSE SUSPENSE TEMP HIM UNIDENTIFIED EXCESS RECORDER CURRENT PRORLEM TRUST TAYLOR UNDISTRIBUTED UNDISTRIBUTED REDEMPTION ELDERLY ELDERLY GPLET GOLF COURSE CIVIL UPPS TAXPAYER IRS INTEREST SUNTAN LITIGATION RESOLUTION CASHIER'S BACK TAX REFUND DEP CLEARING DEP ACCT DEP ACCOUNT DEP ACCT DEP ACCT DEP ACCOUNT DEP ACCOUNT DEP ACCT DEP ACCT DEP ACCT FUND_BAL_YTD 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 PENALTY RESOLUTION INFORMATION AND ASSIGN PENDING HOLDING HOLDING CLEARING REVENUE COUNTRY HIGHLAND DESERT WEST NORTH PENDERGAST ENVIR JUVENILE Description 5.03ND8 COMPANIES TO BE FROM REFUNDING HOLDING NON-DELIVERABLE ACT INTEREST HOLD - CONVERSION HOLDING IMPOUNDS WITHHOLDING HOLDING DEBITS/CREDITS PROCESSING CC RIDGE JO TEMPE VALLEY SCHOOL SERVICES CT APPR OR TRUSTEE INCOME COLLECTIONS INVESTMENT FUND HE RESOLUTIONS MEADOWS CC SC UNKNOWN SATES REFUNDS 2149 IC SERVICE Treasurer's 527,175.50- 50,266,921.68 50,266,921.68 39,422,130.08 278,934.09 8,123,505.45 384,202.32 1,224,333.06- 16,349,516.86 5,460.04 64,146.59 59,673.09 240,197.05 1,143,826.53 287,292.29 8,393,947.96 149,311.27 389,710.61 512,777.07 8,761.10 522,986.61 1,711,212.20 4,793,550.78 79,126.82 142,192.56 69,469.75 127,849.29 181,261.68 108,061.25 69,960.00- Balance Opening Year WARICOPA tO Date Summary COUNTY 341,952,852.49 341,952,852.49 2,751,178,362.32 3,755,772.04 3,647,457.03- 679,751.37 11,010,697.47 19,173.35 167,146.76 1,325.51 11,478,409.95 2,693,680,813.28 15,560,641.48 29,215.00- 6,269.30 498,543.42- 2,028.22 685,615.65 35,901.29- 1,108,250.66- /9,450,085.44 3,932,595.00 1,840,925.66 16,539.06 10,207.39 7,254.84 8,330.37- 17,725.27 466,064.19 Distribution Income for the Month TREASURER' 1,258,495.71 662,578,225.91 662,578,225.91 2,851,477,925.70 124,574,231.83 20,153.64 29,178.07 7,356,820.87 2,716,349,863.15 17,599.64 2,812,206.92 317,805.58 2,147.68 Ending 5 65.00 From JAN, OFFICE Transfer 2017 1,504,557.98 459,144,643.18 459,144,643.18 147,349,631.06 124,635,745.16 00 150. 499.32 22,484,338.15 178,769.30 19,968.70 981.66 .72 29,178.07 105,938.07 2,637.42 1,521.43 3,397.65 4,712.61 2,592.34 To 1,018,074.84 1,018,074.84 47,609,195.01 1,295,628.45 46,052.04- 11,704,216.15 21,653.95 2,651.21 2,651.21- 15,410,702.64 101,300.00 904.00- 19,132,279.96 1,314.23- 351.98 Disbursements 281,113.23- 187,768,116.60 187,768,116.60 38,663,602.77 2,810,591.01 4,476,048.42 430,254.37 544,581.69- 17,635,994.54 2,979.44 199,464.07 91,000.60 240,696.27 4,121,589.08 961,766.02 419,631.49 5,581,741.04 29,215.00- 319,080.57 114,582.61 15,719.31 10,789.32 1,208,602.26 35,960-67- 632,139.61 8,811,250.40 1,919,700.70 161,369.04 81,198.60 138,501.78 177,643.92 128,378.86 396,104.19 Balance Closing PAGE, 02-FEB-2017 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 APP ID: 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,860,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,242,306,983.27 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,353.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 651,506.18- 762,845.98- 679,573.16- 571,408.07- 741,070.41 1,192,788.32 732,235.98-. 636,067.56 589,892.22 678,982.11- 542,867.89- 26,224,503.75 87,282,592.80 42,748,616.25- 20,977,416.86 881,726.68- 1,821,674.84 2,429,229.00 25,983,648.42 2,106,952,773.23 BALANCE SECURED LEVY COUNTY AND 91,478,142.44 .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 131.16- 125.66- 3,433.06 233.90 767.27 64,242.34- 29,177.90 119,157.89- 86,482.72- 265,170.63- 97,957.93 4,030,916.40 87,850,966.38 COLLECTIONS ACTIVITY TREASURER'S FOR JAN 2,339,966.26 .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 43.20- 45.90 37.40- 35.65- 36.55- 67,627.93- 511.19- 145,972.54- 193,353.44- 314,172.05- 239,656.36- 358,460.13- 1,020,013.92- ADJUSTMENTS 2017 OFFICE ENDING 2,148,488,874.57 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- 651,506.18- 762,845.98- 679,575.16- 571,408.07- 741,070.41 1,192,788.32- 732,235.98- 636,155.52 589,971.98 682,452.57- 543,137.44- 26,223,699.93 87,279,307.21 42,778,305.34- 20,950,602.21 988,597.40- 1,772,673.42 2,091,614.71 21,594,271.89 2,018,081,792.93 BALANCE PAGE: 02-FEB-2017 1 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 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 28,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_MONTH_SUM .00 .00 LEVY BEGINNING MARICOPA 405,445,578.40- 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.82- 18,055,558.20- 22,905,048.43- 6,576,315-56- 12,928,887.66- 28,111,508.34- 25,772,503.22- 7,182,166.67- 21,535,273.18- 7,916,062.77- 950,372.21- 6,348,883.72- 17,538,292.93- 14,418,222.26- 8,107,394.13 28,749,996.58- 35,071,247.52- 22,885,138.77- 25,509,876-39- 28,447,703.65- 9,253,999.31- 868,793-94- 3,067,157.42 13,308,266.79- 197,750.52- BALANCE UNSECURED LEVY COUNTY AND 593.34 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 -00 .00 35.51 32.10 34.97 30.84 27.78 26.40 26.67 .00 .00 .00 .00 90.47 288.20 .00 .00 .00 COLLECTIONS ACTIVITY TREASURER'S FOR JAN ADJUSTMENTS 2017 316.58- .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 44.78- 41.68- 45.23- 45.87- 45.02- .00 44.93- 49.01- .00 OFFICE ENDING 405,446,488.32- 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.82- 18,055,558.20- 22,905,048.43- 6,576,315.56- 12,928,887.66- 28,111,508.34- 25,772,503.22- 7,182,166.67- 21,535,273.18- 7,916,098.68- 950,404.31- 6,348,918.69- 17,538,323.77- 14,418,250.04- 8,107,367.73 28,750,023.25- 35,071,292.30- 22,885,180.45- 25,509,921.68- 28,447,749.52- 9,254,134.80- 869,082.14- 3,067,112.49 13,308,315.80- 197,750.52- BALANCE PAGE: 02-FEB-2017 1