Extracted text (via pymupdf_layout)
36214 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: March 9, 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 February 2017 Secured property tax collections during the month of February equaled $123,364,370 and increased the 2016 year to date collections to $2,736,507,551 or 59.1% of the adjusted 2016 levy of $4,629,660,600. The chart below reflects the 2016 collected and uncollected levy amount and corresponding percentages for the 2016 property tax year. FEBRUARY 2017 Uncollected Levy $1,893,153,049 40.9% Collected Levy $2,736,507,551 59.1% • Collected Levy • Uncollected Levy The County's General Fund Balance totaled $194,723,245.43 effective February 28, 2017. Warrants outstanding of $3,378,742.03 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. Submitted under oath Russell K. Pearce Chief Deputy Treasurer STATE OF ARIZONA ) ss. COUNTY OF MARICOPA ) This instrument was acknowledged before me this 9th day of March 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. katt cik6d Notary Public MI Commission Expires KAREN D. SMITH r.. Notary Public - Arizona Maricopa County My Comm. Expires Dec 15, 2017 Straight-line School Source: Bonds Grand P-1 NR Aaa AA+ Credit Status Grand POOL Status GASB amortization and BLOOMBERG Total FED FED FANNIE GOVT SCHOOL (not US USGN FANNIE GOVT FANNIE GOVT Ratings Total COUNTY COUNTY US FIXED 40 TANS FREDDIE rated) FREDDIE FEDERAL FEDERAL FREDDIE FEDERAL FEDERAL Hold-to-Maturity NOTES BONDS Available-for-Sale applied. fair MAC HOME FARM AGENCY DISTRICT TREASURY MAC MAE AGENCY MAC MAE AGENCY TREASURY DISCOUNT INCOME Portfolio Investment values LN CRD DISCOUNT HOME FARM HOME FARM SCHOOL SCHOOL are DISCOUNT DISCOUNT DISCOUNT N/B LOAN CREDIT LOAN CREDIT TANS BONDS NOTES Risk amortized NOTE BANK BANK NT NT NT BANK BANK Disclosures cost Active Active as 160 6 16 7 7 36 36 47 47 6 6 20 9 9 26 64 70 3 1 1 2 7 7 Count 160 10 37 47 6 51 36 20 113 113 160 Count of % OF 02128/2017 100.00% 6.89% 3.40% 10.29% 5.00% 34.97% 37.38% 12.36% 89.71% 89.71% 100.00% TOTAL l urn ALL 85% AGENCY GOVT Active of lace Amourt $3,301,178,000 $227,500,000 $112,215,000 $339,715,000 $165,000,000 $1,154,300,000 $1,234,000,000 $408,163,000 $2,961,463,000 $2,961,463,000 $3,301,178,000 INVESTMENTS Maricopa BofA BofA BofA Merrill Merrill Portfolio Issuer Merrill RESTRICTED County Lynch Lynch Lynch 1-3 $3,306,349,814 $228,059,650 $120,353,088 $348,412,738 $165,204,688 $1,154,140,831 $1,230,579,639 $408,011,918 $2,957,937,076 $2,957,937,076 $3,306,349,814 ;LiREX! Report Allocation 1-3 Year 0-1 Year Month BENCHMARKS PURSUANT US US US TO Treasurer 5% USGN Active 10% DISTRICT SCHOOL Active Agency Treasury Treasury $3,302,474,706 $228,059,650 $119,468,934 $347,528,584 $165,003,906 $1,150,252,644 $1,232,845,286 $406,844,285 $2,954,946,122 $2,954,946,122 $3,302,474,706 ill ARS 5 Index Index Index 35-323 1.31% 0.70% 0.55% 0.90% 0.82% 1.16% 0.93% 0.93% 1.23% 0.53% 1.04% 0.89% 0.89% 0.90% Weighted-Average-Maturity Duration 449 141 388 222 435 863 67 628 475 475 449 WAM (WAM) displayed displayed DURATION treasurer.maricopa.gov Royce in in 1.08 0.39 1.02 0.60 1.17 1.99 0.18 1.59 1.14 1.14 1.08 . Treasurer T. YEARS. DAYS. Flora Straight-line School Source: amortization Bonds and BLOOMBERG applied. TANS fair values GASB are amortized Grand POOL portfolio Status Grand POOL eortfolio Status Statement 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 COUNT Active COUNT Active & 160 10 37 47 6 51 36 20 113 113 160 160 10 37 47 6 51 36 20 113 113 160 Reporting Maricopa as of $3,301,178,000 $227,500,000 $112,215,000 $339,715,000 $165,000,000 $1,154,300,000 $1,234,000,000 $408,163,000 $2,961,463,000 $2,961,463,000 $3,301,178,000 PAR $3,306,349,814 $228,059,650 $120,353,088 $348,412,738 $165,204,688 $1,154,140,831 $1,230,579,639 $408,011,918 $2,957,937,076 $2,957,937,076 $3,306,349,814 PRINCIPAL 02/28/201 Portfolio 2 County $3,306,349,814 $228,059,650 $120,353,088 $348,412,738 $165,204,688 $1,154,140,831 $1,230,579,639 $408,011,918 $2,957,937,076 $2,957,937,076 $3,306,349,814 PRINCIPAL $3,302 474 $228,059,650 $119,468,934 $347,528,584 $165,003,906 $1,150,252,644 $1,232,845,286 $406,844,285 $2,954,946,122 $2,954,946,122 $3,302,474,706 ALL Report Treasurer 706 INVESTMENTS $3,305,376,535 $228,059,650 $119,468,934 $347,528,584 $165,123,126 $1,154,112,919 $1,230,579,639 $408,032,268 $2,957,847,952 $2,957,847,952 $3,305,376,535 AMORTIZATION $2,954,946,122 $165,003,906 $1,150,252,644 $1,232,845,286 $406,844,285 $2,954,946,122 $2,954,946,122 $2,954,946,122 MARKET RESTRICTED $0 $0 $0 PURSUANT INTEREST UNREALIZED TO ARS Weighted-Average-Maturity $13,904,701 $1,151,175 $6,491,093 $7,642,268 $273,211 $2,936,868 $2,218,748 $833,605 $6,262,433 $6,262,433 $13,904,701 ($2,990,954) ($200,781) ($3,888,187) $2,265,647 ($1,167,633) ($2,990,954) ($2,990,954) ($2,990,954) GAIN/(LOSS) -323 § 35 Duration $0 $0 $0 (WAM) displayed displayed treasurer.maricopa.gov Royce in YEARS. in DAYS. Treasurer T. Flora Straight-line 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 FFCBDN FED FARM FNMDN FNMDN FNMDN FNMDN FNMDN FANNIE DISCOUNT FHLB FHLB FHLB FHLB FHLB FHLB FHLB FHLB FHLB FEDERAL FFCB FFCB FFCB FFCB FFCB FFCB 1 FFCB FFCB FFCB FEDERAL BONDS FIXED INCOME Available-for-Sale Labels Detail Listing values are 0 LN 0 0 0 0 CRD 0 DISCOUNT NOTES 1.75 0.9 1.1 1.125 0.875 1 05/23/2018 1.25 1.33 0.73 HOME 1.1 1.27 0.95 0.8 1.24 01/07/2019 1.02 1.02 0.875 FARM as of amortized 003/13/2017 003/09/2017 004/10/2017 003/07/2017 004/1312017 06/29/2017 DISCOUNT 04/05/2017 03/24/2017 07/03/2017 06/29/2017 005/12/2017 DISCOUNT 003/20/2017 005/18/2017 05/09/2017 006/30/2017 005/17/2017 NOTE 07130/2020 05/18/2018 04/26/2019 10/11/2019 06/29/2018 12/28/2018 12/28/2018 06/30/2017 LOAN 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 02128/2017 cost. NT NT BANK BANK 1 1 1 1 1 1 16 1 1 1 3 1 7 1 1 1 3 1 7 36 1 1 2 1 1 1 1 1 1 10 1 1 1 2 1 1 1 1 1 10 20 113 113 160 COUNT Active ALL $30,000,000.00 $30,000,000.00 $25,000,000.00 $30,000,000.00 $25,000,000.00 $20,000,000.00 $445,000,000.00 $42,000,000.00 $25,000,000.00 $40,000,000.00 $120,000,000.00 $27,000,000.00 $254,000,000.00 $35,000,000.00 $45,000,000.00 $40,000,000.00 $135,000,000.00 $30,000,000.00 $285,000,000.00 $1,234,000,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 $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 $236,163,000.00 $408,163,000.00 $2,961,463,000.00 $2,961,463,000.00 $3,301,178,000.00 PAR INVESTMENTS Maricopa RESTRICTED Portfolio 1 $29,982,325.00 $29,980,933.33 $24,968,281.25 $29,959,625.00 $24,950,166.67 $19,888,472.22 $444,533,771.53 $41,907,880.00 $24,954,166.67 $39,808,188.89 $119,302,450.00 $26,830,740.00 $252,803,425.56 $34,982,179.17 $44,907,875.00 $39,900,800.00 $134,330,725.00 $29,800,116.67 $283,921,695.83 $1,230,579,639.44 $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 $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 5236,113,087.75 $408,011,917.75 $2,957,937,075.94 $2,957,937,075.94 $3,306,349,813.69 PRINCIPAL PURSUANT Report County TO ARS Treasurer $29,995,092.50 $29,997,375.00 $24,987,187.50 $29,997,958.33 $24,984,600.00 $19,962,557.22 $444,789,649.72 $41,978,370.00 $24,992,366.67 $39,918,750.00 $119,766,470.00 $26,971,913.25 $253,627,869.92 $34,991,075.00 $44,954,970.00 $39,963,444.44 5134,784,975.00 $29,970,620.00 $284,665,084.44 $1,232,845,286.44 $9,995,000.00 $20,009,400.00 $19,950,200.00 $19,870,600.00 $16,969,400.00 $20,006,000.00 $14,973,150.00 $19,989,400.00 $29,983,800.00 $171,746,950.00 $24,925,750.00 $13,070,254.67 $25,685,660.00 $44,887,500.00 $24,832,750.00 $22,033,670.50 $24,797,750.00 $29,974,500.00 $24,889,500.00 $235,097,335.17 $406,844,285.17 $2,954,946,122.26 $2,954,946,122.26 $2,954,946,122.26 MARKET 35-323 UNREALIZED GAIN Weighted-Average-Maturity $12,767.50 $16,441.67 $18,906.25 $38,333.33 $34,433.33 $74,085.00 $255,878.19 $70,490.00 $38,200.00 $110,561.11 $464,020.00 $141,173.25 $824,444.36 $8,895.83 $47,095.00 $62,644.44 $454,250.00 $170,503.33 $743,388.61 $2,265,647.00 ($5,000.00) $9,400.00 ($49,800.00) ($107,400.00) $10,370.00 $13,000.00 ($26,850.00) ($10,600.00) $15,000.00 ($151,880.00) ($49,605.25) ($2,745.33) ($311,740.00) ($115,900.00) ($167,250.00) ($39,762.00) ($202,250.00) ($25,500.00) ($101,000.00) ($1,015,752.58) ($1,167,632.58) ($2,990,953.68) ($2,990,953.68) LOSS Duration (WAM) INTEREST displayed in displayed in $12,380.97 $15,387.11 $17,025.37 $37,970.53 $36,347.11 $75,908.67 $247,778.67 $69,705.69 $39,106.38 $108,979.27 $467,495.00 $137,842.81 $823,129.14 $8,807.02 $38,416.33 $62,878.96 $442,108.70 $159,301.10 $711,512.11 $2,218,748.34 $13,611.11 $50,000.00 $74,555.56 $85,625.00 $24,378.47 $52,777.78 $31,250.00 $44,333.33 $35,283.33 $411,814.58 $63,402.78 $13,835.59 $41,852.78 $156,000.00 $38,750.00 $31,294.17 $37,541.67 $22,100.00 $17,013.89 $421,790.87 $833,605.45 $6,262,433.09 $6,262,433.09 $13,904,700.76 ACCRUAL treasurer.maricopa.gov Treasurer Royce T. YEARS. DAYS. Flora Straight-line School Bonds Source: Row Status Portfolio amortization and TANS BLOOMB ERG NOTES Labels Detail applied. fair values FNMA 1.7 FNMA 1.75 FNMA 1.75 FNMA 1.625 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 0 FREDN 0 FREON FREDN FREDN FREDN FREDDIE MAC FHLBDN 0 FHLBDN FHLBDN 0 FHLBDN 0 FHLBDN 0 FHLBDN 0 FHLBDN 0 FHLBDN 0 FHLBDN FHLBDN Listing as are amortized 01/27/2020 01/17/2020 06/29/2020 05/26/2020 11/26/2019 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 08/16/2019 01/28/2020 07/26/2019 07/26/2019 07/12/2019 07/05/2019 06/28/2019 06/13/2019 05/03/2019 11/16/2018 10/2912018 10/26/2017 05/19/2017 05/26/2017 003/02/2017 005/25/2017 005/24/2017 005/23/2017 DISCOUNT 05/23/2017 004/11/2017 04/24/2017 04/06/2017 03/30/2017 03/29/2017 03/28/2017 03/15/2017 003/16/2017 003/22/2017 of cost. NT 02/28/2017 COUNT Active 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 28 51 1 1 1 1 1 1 6 1 1 1 1 1 1 1 1 1 1 ALL $30,000,000.00 $25,000,000.00 $20,000,000.00 $15,000,000.00 $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,154,300,000.00 $35,000,000.00 $45,000,000.00 $40,000,000.00 $45,000,000.00 $40,000,000.00 $45,000,000.00 $250,000,000.00 $25,000,000.00 $45,000,000.00 $30,000,000.00 $25,000,000.00 $30,000,000.00 $10,000,000.00 $30,000,000.00 $25,000,000.00 $35,000,000.00 $30,000,000.00 PAR INVESTMENTS Maricopa RESTRICTED Portfolio 2 PRINCIPAL County $30,000,000.00 $25,000,000.00 $20,000,000.00 $15,000,000.00 $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,154,140,831.25 $34,902,097.22 $44,871,250.00 $39,946,455.56 $44,868,443.75 $39,875,000.00 $44,857,500.00 $249,320,746.53 $24,967,305.56 $44,968,800.00 $29,973,820.83 $24,984,416.67 $29,984,583.33 $9,993,933.33 $29,982,150.00 $24,988,090.28 $34,981,897.22 $29,978,970.83 PURSUANT Report TO ARS Treasurer MARKET 35-323 $29,980,500.00 $25,020,250.00 $20,024,800.00 $14,976,450.00 $25,008,500.00 $19,775,400.00 $24,725,750.00 $18,850,244.40 $17,853,617.00 $29,637,300.00 $24,779,000.00 $29,809,200.00 $24,750,000.00 $19,810,200.00 $19,962,800.00 $29,884,200.00 $19,863,600.00 $19,876,800.00 $24,746,500.00 $24,768,750.00 $29,837,400.00 $19,945,200.00 $20,003,000.00 $34,935,250.00 $15,001,800.00 $24,985,250.00 $25,019,750,00 $648,829,261.40 $1,150,252,644.40 $34,962,822.22 $44,947,908.75 $39,998,977.78 $44,948,507.50 $39,954,761.11 $44,949,705.00 $249,762,682.36 $24,968,441.67 344,977,110.00 $29,977,541.67 $24,987,512.50 $29,987,750.00 $9,996,052.78 $29,988,846.67 $24,996,041.67 $34,994,088.89 $29,991,493.33 UNREALIZED GAIN Weighted-Average-Maturity ($19,500.00) $20,250.00 $24,800.00 ($23,550.00) $8,500.00 ($224,600.00) ($274,250.00) ($55,028.10) ($106,891.75) ($362,700.00) ($221,000.00) ($190,800.00) ($196,250.00) ($189,800.00) ($37,200.00) ($115,800.00) ($136,400.00) ($123,200.00) ($253,500.00) ($231,250.00) ($162,600.00) ($39,600.00) $3,000.00 ($64,750.00) $16,800.00 ($14,750.00) $131,500.00 ($2,840,819.85) ($3,888,186.85) $60,725.00 $76,658.75 $52,522.22 $80,063.75 $79,761.11 $92,205.00 $441,935.83 $1,138.11 $8,310.00 $3,720.83 $3,095.83 $3,166.67 $2,119.44 $6,696.67 $7,951.39 $12,191.67 $12,522.50 LOSS Duration (WAM) INTEREST displayed in displayed in $43,916.67 $49,826.39 $57,361.11 $59,583.33 $91,666.67 $22,500.00 $27,083.33 $97,176.39 $74,854.17 $141,670.83 $30,138.89 $134,275.00 5100,069.44 $131,305.56 $3,472.22 $12,000.00 $22,166.67 $20,000.00 $22,222.22 $33,541.67 $50,350.00 $40,000.00 $58,333.33 $140,875.00 $49,300.00 $92,968.75 $74,131.94 $1,683,914.58 $2,936,868.06 $57,622.84 $73,948.75 $53,469.73 $80,726.29 $79,067.33 $91,493.46 $436,328.42 $1,508.73 $3,956.91 $2,613.05 $2,515.17 $4,195.79 $1,905.01 $6,036.23 $6,903.36 $11,368.00 $11,756.68 ACCRUAL treaSurer.maricopa.gov Treasurer Royce T. YEARS. DAYS. Flora Straight-line School Bonds Source: Row Status Portfolio amortization applied. and TANS fair BLOOMBERG Phoenix Paradise Glendale Cartwright IMPROVEMENT COUNTY SCHOOL Hold-to-Maturity T 1.625 T 0.625 T 1.25 Ti T 0.75 T 0.75 US TREASURY US TREASURY FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FFILIVIC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FHLMC FREDDIE FNMA Labels Detail Listing values are Union High ParadiseValleyUSD Valley GlendaleUHSD GlendaleUHSD GlendaleUHSD Union CartwrightESD CartwrightESD CartwrightESD CarlwrighESD CartwrighESD Elementary BONDS 06/30/2019 06/30/2018 12/15/2018 12/31/2017 12/31/2017 06/30/2017 N/B 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 as of amortized School 1 Unified 1.975 1.46 1 High School 2.29 2.29 2.29 1.98 1.98 BONDS 08/2812020 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/2018 06/29/2018 08/03/2018 07/27/2018 04126/2018 08/24/2020 02/28/2017 cost. District 07/01/2017 School 07/01/2018 07/01/2017 07/01/2017 District 07/01/2019 07/01/2018 07/01/2017 07/01/2018 07/01/2017 School District District COUNT Active 1 1 1 1 1 1 3 1 1 1 1 1 5 18 37 47 1 1 1 1 1 1 6 6 1 1 1 1 1 2 1 1 1 1 1 1 1 1 1 2 1 1 2 1 23 1 ALL $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 $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 $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 $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 $25,000,000.00 $30,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 $502,425,000.00 $15,000,000.00 PAR INVESTMENTS Maricopa RESTRICTED Portfolio 3 $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,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 $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 $502,470,750.00 $15,000,000.00 PRINCIPAL PURSUANT Report County TO ARS Treasurer 4 35-323 $25,146,484.38 $29,824,218.75 $25,013,671.88 $20,025,000.00 $29,975,390.63 $35,019,140.63 $165,003,906.25 $165,003,906.25 $9,992,000.00 $19,985,400.00 $14,994,750.00 $10,012,800.00 $24,984,000.00 $39,808,800.00 $19,749,800.00 $29,895,000.00 $29,718,000.00 $24,947,250.00 $19,975,200.00 $24,995,250.00 $29,962,500.00 $24,959,750.00 $25,090,250.00 $39,988,000.00 $20,009,200.00 $29,982,600.00 $47,365,033.00 $15,007,800.00 $501,423,383.00 $14,997,750.00 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 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 ($23.437.50) ($103,125.00) ($237,304.69) $52,343.75 $123,046.88 ($12,304.69) ($200,781.25) ($200,781.25) ($8,000.00) ($14,600.00) (53.750.00) $12,800.00 (816,000.00) ($191,200.00) ($250,200.00) ($105,000.00) ($282,000.00) ($52,750.00) ($24,800.00) ($4,750.00) ($37,500.00) ($10,250.00) $13,000.00 ($12,000.00) $9,200.00 ($17,400.00) ($59,967.00) $7,800.00 ($1,047,367.00) ($2,250.00) LOSS Duration (WAM) INTEREST displayed in displayed in $122,330.65 $238,139.31 $238,139.31 $797,895.89 $73,839.50 $9,558.33 $881,293.72 $14,003.99 $5,109.56 $4,541.83 $7,418.95 $7,576.80 $38,651.13 $1,560,280.67 $6,491,092.68 $7,642,267.66 $66,212.02 $30,559.39 $64,388.74 $32,596.69 $36,671.27 $42,783.15 $273,211.25 $273,211.25 $0.00 $2,222.22 $38,750.00 $12,638.89 $78,645.83 $128,555.56 $84,000.00 $89,900.00 $131,950.00 $87,500.00 $87,222.22 $33,333.33 $46,258.33 $84,861.11 $57,291.67 $145,444.44 $34,416.67 $20,833.33 $40,838.19 $48,291.67 $1,252,953.47 $3,125.00 ACCRUAL treasurer.maricopa.gov Treasurer Royce T. YEARS. DAYS. Flora Straight-line School Source: Row Status Portfolio Bonds Labels amortization and BLOOMBERG TANS COUNTY Detail TANS Gilbert Deer Chandler Riverside Queen Phoenix Peoria Kyrene Glendale Dysart Chandler REFUNDING Washington Riverside applied. fair values Unified DeerValleyUSD Valley ChandlerUSD SCHOOL RiversideESD RiversideESD RiversideESD RiversideESD QueenCreekUSD QueenCreekUSD Creek PhoenixESD PhoenixESD PhoenixESD PhoenixESD PhoenixESD PeoriaUSD PeoriaUSD Unified KyreneESD GlendaleUHSD Union DysartUSD DysartUSD Unified ChandlerUSD ChandlerUSD Unified WashingtonESD WashingtonESD WashingtonESD WashingtonESD RiversideESD RiversideESD RiversideESD RiversideESD PhoenixUHSD Listing are School Unified 1.07 Unified 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 Elementary High 2.3 2.3 School 5.23 5.23 School BONDS Elementary 1.42 1.3 1.13 1.03 Elementary 0.93 as of amortized District 1.07 School 07/19/2017 School 07/01/2020 07/01/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 3.33 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/0112018 School 07/01/2017 02/28/2017 cost. 07/19/2017 District District 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 Active 1 1 1 1 1 10 10 1 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 COUNT ALL PAR INVESTMENTS $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 $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 Maricopa RESTRICTED Portfolio 4 PRINCIPAL County $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 $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 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 treasurer.maricopa.gov Royce M in $177,103.84 $177,103.84 $177,103.84 $227,704.94 $227,704.94 $1,151,174.98 $1,151,174.98 $17,765.00 $2,436.67 $2,380.00 $5,874.07 $28,455.73 $88,820.72 $16,482.06 $105,302.78 $64,710.22 $31,728.38 $1,566.83 $494,057.19 $541,202.51 $1,133,265.13 $280,948.61 $710,634.72 $991,583.33 $703,167.42 $703,167.42 $1,069,052.10 $1,069,052.10 $228,694.11 $237,611.08 $466,305.19 $428,635.55 $5,044.77 $433,680.32 $4,930,812.01 $113,692.50 $60,968.33 $24,659.17 $56,730.00 $256,050.00 $7,268.82 $8,103.33 $4,396.96 $4,046.76 $23,815.87 $122,330.65 ACCRUAL Treasurer T. YEARS. DAYS. Flora Straight-line School Source: Grand Row Status Portfolio Bonds Total Labels amortization and BLOOMBERG Detail TANS Washington Saddle Roosevelt Peoria Pendergast Paradise Glendale applied. fair values WashingtonESD SaddleMountainUSD Mountain RooseveltESD PeoriaUSD Unified PendergastESD ParadiseValleyUSD Valley GlendaleUHSD Union GilbertUSD Listing as are Elementary Unified 1.07 Elementary 1.07 School Elementary Unified 1.07 High 1.07 of amortized 1.07 School 1.07 School 07/19/2017 District 1.07 School 1.07 School School 07/19/2017 02/28/2017 cost. 07119/2017 School 07/19/2017 07/19/2017 07/19/2017 District District 07/19/2017 District District District 07/19/2017 District Active 160 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 COUNT ALL PAR INVESTMENTS $3,301,178,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 Maricopa RESTRICTED Portfolio 5 PRINCIPAL County $3,306,349,813.69 $12,029,520.00 $12,029,520.00 $1,002,460.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 PURSUANT Report TO ARS Treasurer 4 35-323 MARKET $2,954,946,122.26 $0.00 $0.00 $0.00 $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 Duration (WAM) INTEREST displayed displayed $13,904,700.76 treasurer.maricopa.gov Royce in in $60,721.32 $60,721.32 $5,060.11 $5,060.11 $75,901.65 $75,901.65 $187,224.06 $187,224.06 $63,251.37 $63,251.37 $101,202.20 $101,202.20 $75,901.65 $75,901.65 $177,103.84 ACCRUAL Treasurer T. YEARS. DAYS. Flora 541 28-FEB-2017 PAGE: 28-FED-2017 I271 OFFICE 722 9,225 42 233 1,275 246 34 36 68 257 325 8 40 48 534 143 677 569 591 1,160 105 82 187 184 3 191 378 3 54 57 30 91 121 19 97 116 594 594 11,813 - FUND TREASURER'S by DISTRICT 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: - WARRANTS AMOUNT 6,363.38 208,154.71 24,288.88 53,823.46 3,300,629.69 91,049.74 23,624.92 61,118.92 3,769,053.70 23,626.17 3,365,856.10 3,389,482.27 4,476.02 44,488.02 48,964.04 269,453.31 266,441.31 535,894.62 5,046,835.57 1,208,080.18 6,254,915.75 96,768.13 213,254.21 310,022.34 92,409.83 23,632.61 397,775.31 513,817.75 592.04 108,340.58 108,932.62 14,083.80 433,289.97 447,373.77 8,424.01 212,635.52 221,059.53 1,256,693.58 1,256,693.58 COUNTY WARRANT OUTSTANDING MARICOPA = = = = = = = = = = = = = = = = = = = = = - = . = = = = = = = = = . = . = = = NUMBER 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 WARRANT Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund District Fund Fund District Fund Fund District Fund Fund District Fund Fund District Fund Fund Fund District Fund Fund District Fund Fund District Fund Fund District Fund District OTSTND_WT_FUND District DISTRICT 000 000 000 000 000 000 000 000 000 001 001 001 002 002 002 003 003 003 004 004 004 005 005 005 006 006 006 006 007 007 007 008 008 008 009 009 009 011 011 WTR ID: FUND 066 714 766 767 768 781 950 962 030 040 030 040 030 040 030 040 030 040 030 035 040 030 040 030 040 030 040 040 PROGRAM 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-086-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 30-046-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-032-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 GENERAL TR.EAS SUSPENSE BANK SUSPENSE SUSPENSE TEMP BLD UNIDENTIFIED EXCESS RECORDER CURRENT PROBLEM TRUST TAYLOR UNDISTRIBUTED UNDISTRIBUTED REDEMPTION ELDERLY ELDERLY GPLET GOLF CIVIL UPFS TAXPAYER IRS INTEREST 5UBTAX L/TIGAT/ON RESOLUTION CASHIER'S BACK TAX REFUND CE? CLEARING CE? ACCT CE? ACCOUNT CE? ACCT CE? ACCT CE? ACCOUNT DEP ACCOUNT DEP ACCT DEP 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 HOLD - CONVERSION HOLDING IMPOUNDS WITHHOLDING HOLDING DEBITS/CREDITS PROCESSING JO RIDGE IC TEMPE VALLEY SCHOOL SERVICES CT APP?. OR TRUSTEE INCOME COLLECTIONS INVESTMENT FUND HE RESOLUTIONS MEADOWS IC IC IC UNKNOWN SALES REFUNDS 2149 SERVICE 281,113.23- 187,768,116.60 187,768,116.60 38,663,002.77 2,810,591.01 4,476,048.42 430,294.37 544,591.69- 17,635,994.54 2,979.44 199,464.07 91,000.60 240,696.37 4,121,589.08 961,766.02 419,631.49 5,581,741.04 29,215.00- 319,080.57 314,582.61 15,719.31 10,789.32 1,208,602.26 35,900.67- 632,139.6: 8,831,250.40 1,919,700.70 151,369.04 61,196.60 138,501.78 177,643.92 128,378.86 396,104.19 Balance Craning Treasurer's MARICOPA Report COUNTY 51,146,535.52 51,146,535.52 152,739,987.95 12,863.83 773.578.61 150,318.53 854,778.30 1,787.44 1,488,223.83 261,919.82- 8,445.64 950,171.71 143,931,851.97 2,568,054.01 11.64 29,216.00 90,160.90 383.20 4,004.98- 237.04- 1,115,011.64- 4,118.74- 51,258.26 3,214,176.33 1,494,647.57 756,874.01- 22,539.71- 11,911.39- 5,436.30- 8,851.73 6,065.08 74,011.92 Distribution Income for the Month of TREASURER FEB, 220,912.05 66,762,595.40 66,762,595.40 143,852,527.20 39.99 1,480.00 3,444.53 143,832,764.25 5,008.85 2,051.95 7,737.63 524.17 From 2017 S OFFICE Transfer 150,822.70 22,584,611.94 22,584,611.94 1,315,841.37 20,443.76 63,462.56 1,221,159.82 296.00 10.87 468.36 14,672.26 452.61 187.77 394.83 573.88 434.67 To 13,423.22 13,423.23 6,315,666.47 20,403.27 30,876.52- 1,197,036.33 2,674.96 1,919,989.73 3,206,438.70 Disbursements 351,202.58- 194,723,245.43 194,723,245.43 42,750,638.42 2,823,455.34 5,249,627.03 461,160.89 394,263.16- 17,292,256.51 2,091.92 1,687,687.87 170.919.22- 245,697.48 5,071,760.79 1,124,316.30 1,062,686.92 5,581,752.68 1.00 1,550,240.39 405,039.51 383.20 9,662.38 10,563.15 93,590.62 39,551.05- 683,397.87 10,340,246.06 1,162,826.69 139,281.94 69,474.98 133,460.31 187,069.53 134,878.61 470,116.11 Balance Closing PAGE: 03-MAR-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,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 SECURED LEVY COUNTY AND 140,446,087.93 .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 497.58 1,551.56 1,923.56 3,865.51 3,648.37 2,627.03 21,426.24 8,252.88 12,965.61 93,566.44- 241,597.70- 17,360,123.55 123,364,370.18 COLLECTIONS ACTIVITY TREASURER'S FOR FEB 2,595,008.15- .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 255.29- 426.44- 347.92- 382.52- 507.10- 775.96- 1,399.76- 1,694.52- 3,204.49- 124,662.52- 271,907.26- 625,070.28- 1,564,374.09- ADJUSTMENTS 2017 OFFICE ENDING 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.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- 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 PAGE: 03-MAR-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,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 UNSECURED LEVY COUNTY AND 3,468.59 .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 145.66 .00 .00 81.31 482.17 547.47 382.22 303.28 872.84 309.82 343.82 .00 COLLECTIONS ACTIVITY TREASURER'S FOR FEB ADJUSTMENTS 2017 848.77- .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 163.03- 224.80- 203.39- 207.97- 49.58- .00 OFFICE ENDING 405,450,805.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.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,395.70- 8,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 PAGE: 03-MAR-2017 1