Extracted text (via pymupdf_layout)
25391 characters
Royce T. Flora, Treasurer 301 West Jefferson St,, Rni, 100 Phoenix, Arizona 85003 Maricopa County Phone: (602) 506-8511 Fax: (602) 506-1102 Treasurer http://treasurer.111 a rieopa,gov DATE: December 18, 2018 TO Steve Chucti, Chairman Denny Barney, Supervisor, District 1 Bill Gates, Supervisor, District 3 Clint Hickman, Supervisor, District 4 Steve Gallardo, Supervisor, District 5 SUBJECT: Treasurer's Collections and Jnvestnicnt Summary for November 2018 Secured property tax collections during the month of November equaled S522,388,327 and increased the 2018 year to date collections to 82,518,101,665 or 50.16% of the. adjusted 2018 levy of S5,021,325,402. The chart below reflects the. 2018 collected and uncollected levy amount and corresponding percentages for the 2018 property tax year. November 2018 Uncollected Levy $2,502,623,737 50% Collected Levy. $2,518,701,665 50% 11Collected Levy 11 UncoHected Levy The County's General Fund Balance totaled S232,506„998.99 effective November 30, 2018.. Warrants outstanding of $4,824,459.59 wilt post against the. fund balances when presented, The S2,890,673 unencumbered balance, of the County Municipal Line of Credit and the S12,937,811 Workers Compensation Liability Letter of Credit remain unused. Segbipted under oath, Russell K. Pearce Chief Deputy Treasurer STATE OF ARIZONA ss. COUNTY OF MARI(::OPA ) This instrument was acknowledged before me this 13th day of December 2018, 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, ,ad)tee. Notary Public My Commission Expires woriswaNakritrakdiktiimehrilois&ramisafa 4 KAREN D SMITH 1 4 liotaty Pub5c -Maas 1 Marko& Cosurity I My CArri Expkts Dec 15, 21321 1 oftaraiwormmicinfoomweerninimmapwarli Maiicope County MARICOPA COUNTY TREASURER Selected Funds Total Earnings Sorted by Fund - Investment Class November 1, 2018 - November 30, 2018 Adjusted Interest Earnings Ending Beginning Ending Current Annualized Interest Amortization, Realized Adjus1ed Interest CUSIP Investment 8 Fund 1551M" Par Value Book Value Book Value Rate Yield Earned Accretion GainVLoss Earnings Fund: Treasurer's Pool N,X,X1518 10006 1000 JAM 102953.71 102,953.71 1102.953.71 0.130 0.132 11.16 0.00 0.00 19.16 665279873 10424 IWO NTMM 0_U1 0.01 0.01 0.190 0.00 0.00 0.00 0.00 SCF0018A 10591 100 0050 49,000.00 50,25632 50.009_26 6.140 2268 250.71 -157.04 0.00 93.67 SC-FD01881 10592 1000 50112 66,00000 61,56950 61,391.02 6.140 2 338 206.77 -178.48 0.00 11029 SOFD0180 10593 IGGO 5010 62000.00 67,816.62 67,634.85 6.140 2.430 317,24 -181.77 0.00 135.47 SCFD0180 10594 1000 6.CFP 65,000.00 73,017.53 72,835.31 6.140 2.503 33202 -182.22 0.00 161038 48120[070 10654 WOO 144.000.000.00 164.000,000.03 144,000,000.00 1.560 1.582 200,850.00 0.00 0.00 200.850.00 0924813718 10661 1000 275,000000 00 305.000.00000 275,000,000 00 1.760 2.068 565,533.33 0.00 0.00 505,533.33 481240375 10679 1000 „WPM 000 000 0.09 1.530 0.00 0.00 0.00 0.00 3814181273 10080 WOO GSM 331,000,000.00 33500000000 331,000,000.00 2060 2.099 731,185.56 0.00 0.00 731,185.66 092481J700 10737 1000 13.1.K.MM 10,000,000.00 310,000,000.00 10,000000 00 1.810 1.835 340.631.94 0.00 0.00 340,631.94 2018TANBU 19751 1000 BUCHSLI 4,000,000.00 4,004,206.43 4,003,55929 2.480 2_315 8256.67 -547.14 0.00 7,619.53 2018TANCH 10752 1000 CHNUSD 50,00000034 50,052,580.36 80.044,491.07 2.480 2315 103,333 33 -8.035_29 0.00 95,244.04 2018TANOV 10753 1009 DEERUS 20,000,000.00 20,021,032.14 20,017,796.43 2.480 2315 41,333 33 -3.235.71 0.00 36,097.62 2018TANGB 10754 1000 GILBSO 22,000,009.00 22,023,135.36 22,019,576.07 2.4E0 2 315 45,466 67 -3.559_29 0.00 41,967.30 2018TA1.410 10755 WOO GLETHSO 14,000,000.00 14,014,722.50 14,012,457.50 2.480 2.315 28,933.33 -2,265130 0.00 29.668,33 2018TANPN 10756 1000 PEWS° 12.000,000.00 12,012,619.29 12,010,677_86 2_480 2.315 24,500.00 -1,941.43 0.03 22,858 57 20113TANPE 10757 1000 PEORSD 15.000000.00 15.015.774.11 15,013,347.32 2.480 2.315 31,000.00 -2,420.79 0.00 28,573_21 2018TANRO 10756 1000 ROSESD 7,000,000 00 7,007.361_25 7,006,228.75 2.480 2 315 14,4E6.67 -1,132.50 0.00 13,334.17 2018121150 10759 1000 SADUSD 3,000000.00 3,003,154.82 3.002.669.46 7480 2.315 6,200.00 -4as.sa 0.00 5,714.94 2018TAriPV 10760 1000 PARV3D 10,000,000.00 10,002,835.71 10,000.339.50 2330 2052 19,416.67 -2,546.21 0.00 16,870.46 2018TANDV1 10762 1000 000505 15,000,000.00 15,004,328.57 15000,50924 2330 2.052 29,125.00 -3,819.33 0.00 25,305.67 313312043 10774 WOO FCDN 20,000,000.00 19,624,333.33 19,667,200.00 2.560 2.845 0.00 42,66867 0.00 42,666.87 CART20140 10004 IWO CRTE60 370,000.00 370,677.11 370,592_47 2290 2.040 706.08 -8464 0.00 621.44 3135G0P23 10007 1000 FNMA 20.000,000.00 20,000,000.00 20,000,000.00 1.250 1.267 20,833.33 0.00 0.00 23.333.33 WASH20153 10053 MOO 9288850 3,000,000.00 3,000,000.00 3,000,000.00 1.570 1.592 3,625.00 0.00 0.00 3,925.00 313602840 19089 1000 FNMA 35,000,00034 35,000,000.00 35.000.000.00 1.260 1.278 36,750.00 0.00 0.00 36,760.00 313500349 10090 1000 FNMA 0.00 14,999,791.67 000 1,160 1.210 7,250.00 203.33 0.00 7,458.31 3130A6UT2 10093 1000 FFIL13 20,000,009.00 20,000,009.00 20,000,000.00 1.330 1.348 22,18.667 000 0.00 22.166.87 3130A71QC2 10100 1000 FFILB 15.000000.00 15,000,000.00 15,090,000.00 1_250 1_267 15,523.00 0.00 0.00 15,829.03 POrtr0E0 INVT Dale Updated: -'REPORT'-: 12/1812018 07:10 AP RunDee 12182011-0710 TE (PRF_TE) 7.36 R.Fa91* 7.3 6 C. Zo" Adjusted Interest Earnings 0 Investment * Fund 0 tg ▪ CI 8 ▪ , E 4 § o-3'42gP2 221-L 888 MR 3:2 .3, NC'C0 Eii§U- AA82 .. F.3g3:2 t00000000000 ' 23g33" :2 8 gz77: :2 282220,g3 ERi MEEE§§§§M t S704 $ 2 .7, 7 -ssz,095.**.mm C g.gglIgMgg.ME. „„, E RI NooMCN 3"""fsIE`Al3=' H§ 000000 MI 31:',3:2 ggS 3',-,ZA8,T28`4St2 s 888828828a88 22 ,,z Li ")--- --- &',2 §§§§§§ - ------ 228222 6 n- ZEMEM -- gl.ZZUMUME.U.R4RUMM§§§§§§M 4. ;72'gg-'3'z 6666666666666666666666666666666666666 8888888838388888888888888888888888888 ,7.„2-s--L1 a" 3.R.VilgAgAg R§g.SP.P.Vg§2882§3§§8,9-88822§§8§§§'4228 - ,1.§..MM§MM§§RkUM§.§.EMM '.2 'no.'no'n-oocodN, :2 5. E- m?..55.* 'z 8888883888888888888886 1"2 E i1V42':::2 66666666g66,1g6666666666 ,13' 8888 0 - .E 222- „cr.gp. 5 , • r, §§§§§§§§§§§§§§§§§ 88 HVg§6'ng§H§U§F,-§ 3888 8 UMWiRMRM m E IT. 88 00000 .;;gg,7;ggg2 :4: gggAggggggg &'33334.`:=g3g8 LI. Sg 82A41; 8 ,'s !.11;2 § 882 01.0- 22. 88 c4 22 MARICOPA COUNTY TREASURER Selected Funds Total Earnings Page 3 November 1, 2018 - November 30, 2018 Adjusted intems Earnings Ending Beg Inning Ending Current Annualized Interest Amortization! Realized Adjusted Interest Investment a Fund Issuer Par Value Book Value Book Value Rate Yield Earned Accretion Gainlitoss Earnings Fund: Treasurer's Pool 3130AMTK1 10318 10:10 FHLB 10,000000.00 10000,000.00 10,000,000.00 1.750 1.774 14,583.33 0.00 0.00 14,563.33 313.406E84 10356 1000 FFILJAC 10,000,000.00 10,000000.00 10,000,000.00 1.700 1.724 14,136.67 0.00 0.00 14,166.67 3134081770 10373 1000 HAIM 25.000.000.00 25,000000.00 25,000,000.00 1.501 1.521 31,250.00 0.00 0.00 31,250.60 3130AB321 10376 1000 FHLB 25,000,000.00 24,937,947.09 24,969,311.57 1.375 t461 23,645.84 1.364.48 0.00 30.910 32 3130ABCG9 10385 1000 FHLB 30,000,000.00 30,000,000.00 30,000,000.00 1.600 1.622 40.000.00 0_00 0.00 40000 00 3134 GBUT5 10397 1000 FHLMC 30.000.000_00 30.000.000.03 30.000.000.00 1.700 1.724 42500_00 1100 0.00 42,500.00 3134GBPK2 10.401 WOO 25.000.00003 29.000.000.09 2500000300 1.700 1.724 35.416.65 0_00 0.0.3 35,416.66 31336141117 10402 1000 FFCB 12.250.00000 12.250.000.09 12,25020020 1.970 1997 . 20,110.42 0.00 0.00 20,110.42 3134GB1.12 16405 1000 FBI/JO 20.000.00000 20000.000_09 20.000.00005 1.750 1.774 29,166_67 0.00 0.00 29,166.67 3134MM% 10417 1000 FHLKIC 20.000s000o 20000000_00 20000009_00 1.700 1.724 23333_33 0.00 0.00 28,333.33 3134GBXG2 1c422 1000 FHLMC 20,000,000.00 20000060_00 20000000_00 1.550 1.572 25,833_34 0.00 0.00 25,833.34 3130ASPV2 16423 1000 FHLB 25,000,00000 25,900,00100 25,000,000.00 1.690 1.713 35,208.34 0.00 0.00 35208.34 31340861- 48 10445 IWO F111..0.10 30,000003.00 30.000,030.00 30,000,010.00 1.500 1.521 37,600.00 0.00 0.00 37,500.00 31341)0600 10461 1000 FHLMC 30,000000.00 30.000,000.00 30,000,030.00 1.850 1.878 46,250.00 0.00 0.00 46,250.09 3134GBET5 10462 1000 FHL.MC 25,000,000.00 25,012,847.15 25,012,108.81 1.800 1.788 37.50000 -738.34 0.00 36.781.66 3130 9564Q5 10463 1000 FKB 15.000.00400 14.989.155.74 14,969,702_51 1.625 1.691 20,312_50 546_77 0.00 20359_27 313466%5 10467 1000 FHLMC 20,000.000_00 19872,118_96 19,877,695.17 1.750 2.127 29,166.67 5,576.21 0.00 34,742.88 3136G4P63 10483 1000 F 14 VA 20,000,000.00 19,487,037.74 19,987,603.77 1.750 1.810 21,166.67 666.93 0.00 29,732.70 3130A0IF2 10485 1000 FHLB 15000,000.00 14,519,303.33 14,999,433.33 1.500 1.531 18,750.00 125.00 0.00 18,875.00 31340N-121 10516 1000 FFILMC 25,000,000.00 24,947,430.92 24,949,770.99 1.700 1.839 35,416.66 2,290.07 0.00 37,706.73 3133611755 10517 1000 FFCB 16,000,009.00 15,989,464.56 15,939,906.60 1.750 1.809 23.33320 44204 0.00 23.775.37 313409X72 10518 1000 16414,10 25.000.000.00 25,000,00000 25.000.000.00 1.050 1.878 38,54167 0_00 0.00 38641.67 3134GSFIT2 10533 1000 FHLMC 13,84300000 13,888,585.42 13888059_53 1.625 1.681 18,813.44 374.11 0.00 19,187.55 3139M546 10534 1000 FMB 25,000,000.00 24,984,317.40 24,990,590.44 1.250 1.574 26,041.67 6,273.04 0.00 32,314.71 3130A111132 10535 1000 FFiLB 20,000,000.00 20,153202.72 20,142,44520 2.315 1.696 3.9,583.34 .11,487.52 0.00 28,095.82 313,3EHP96 10542 1000 FFCB 5,500,000.00 5,495,873.47 5,493,212.64 1.600 1.699 7,333.33 339.17 0.00 7,672.50 3139ACRCO 10543 1040 FHLB 20,000,000.00 20,000,000.00 20,000,000.00 1.880 1.906 31.333.33 0.00 0.00 31,333.33 313500186 10555 1000 FNMA 21.000.00020 20,000,000.09 20.0007000.00 1.950 1.977 32.500.00 000 0.02 32.500.09 3134013254 10557 1000 FHLMC 26,000.000_00 25000.000.00 25000.000.00 1.830 1.8.55 18,125_00 0_00 0.00 38,125.00 3134013203 10558 1000 FHLMC 30,000,000_00 30,000000_00 30020000_00 1.750 1.774 43,750_00 0.00 0.00 43,750.00 3134062142 10559 tow FHLFAC 25,000,000.00 25,000,00000 25,000,000.00 1.640 1.866 38,333.33 0.00 0.00 38333.33 313.400555 14550 loop FHLMC 15,000,000.00 15,000,000.00 15,000,000.00 2.000 1.893 23,333.34 0.00 0.00 23,333.34 313406555 10561 loop FHLAIC 13,000,000.00 13,000,000.00 13,000,000.00 2.000 1.893 20,222 22 0.09 0.00 20,22222 3134063.N 10564 1000 FHLMC 25,000,000.00 25,000,000.00 25,000,000.00 2.000 2.028 41668.66 0.09 0.00 41,666.66 313408205 10565 1000 FHLMIC 25,000,000.00 25,000,000.00 25,000,000.00 2.000 1.833 37,673.61 0.09 0.00 37,673.61 313408368 10566 1000 FHL_MG 25,000,000.00 25,000.000.09 25,009,000.09 2.030 1.808 37,152.78 0.09 0.00 37,152.78 313408216 10567 iaao 1411170 30.000.000.00 30.000.000.09 30,000,000.00 1.875 1.901 46,875.00 0.09 0.00 46,875.00 Portfolio INVT Data Updated: -REPORT-: 1211812018 07:10 AP R., D2:2: 12/1&2318- 07:10 TE ofir_zrq 7.36 Rewl WI. 7.3 6.1 MARICOPA COU Adju sted In terest Earning s c) a Investmen t g Fund 0-I,g 7; 2 2 = g CD •0 TeN u- (N co 555 "---- -0101 ani co 0) V; f5fff5=i?, 55 CJ Milliq 00q0000,0_. A88AXA322RA §§§§§§§§§§§§§§ 888888882828 $$$$8.8.8.$8.8$ 21888HH§§§ 82228'48.8. 82885288828 . 04010401010101010101 .4.annnnnF2282822:2 e4N 666666666066660 599T, Q— '2'3.222:1- 040iN gctgggSIggr032.17.7g2gMS 2g8gggIgg8f5824,7,8285 2 8. 0)0 cO g §§ n'9999 8888 8.$8 § oir460joiNcON §§ 0)0D glAw §§ ,T_ELT_EEEEEIEEIEEEEEEEItLItEhtitEE±±tEE #2888 8 2"8- 2888228888888888g888888888888887288288 O66addoodO66d666OOOOOOO6666666666666Q 8883888888888888888888888888888882282 0) 0 8 .§_§.§.§.RM§§§.§§§g§§§§§§§§§U§Mil§§§§ '41 gHH§H§gWiR§g§WW§WVORIE 88. 0) qffirrir-91-4MUM N 2.73 0) cl §§§§§ c) 888 Rig==igggg'.'ig5f1Mg'5'clgg'""e6c1gggg "" 0) ,ggg2g-igg No10,i 0d00o0000 0) 0) hhMilfi § 2$$$$$$88$$ k 01 0 88888 2 8228,2888.-7 040.ie4cmoJoi.— 2;2N2 2 9822C33932388f 7-ggggfg 88:2 010)070) - ERV§A§ §§§§§§EME§ 888 8 * cO c40404 6666666 8 $$$ ig8888 rjr.ic ;CP'W=8 0) 888 0466 2282 0) 02 i : 2 , GN • ,T; g. 121' t12. o lUatUiseA 4 pUN S1 115 10 07 m on 47", 0 CO na g 2 00 2 2 .e,kgg CO 0 § 2 P 2 CA 888888 cr, .2 828288 00=000 0 '3 0 8822rZ;,',Z ga'ggg na .s P 2 CO g ri @ 8 §§§§§§§EEE§§ 888888888882g fIrI .4 '8888888888888 000 t 28828828888888 Ai 7.1 CP g N. '222882=382 5 cTo C.) gEg8g2g 000000 tgSg 04.400 ,,,2222,92222288288§8888 9999P 00 rs) §§ 4, 1,3 § 8 0 1.0 8 8 999 .tn282 4, .888222=:=L § 9p 8 CO r,3. =: n co -384.0,2888228,7,2T1'612222. 88 TA 01 90 r• :00_ 8828888888888888888828888888888828888 n.) !,3 orp 8 2 C., § 1s3 57? 2 2 28222888282888828828888888888V 2 la co. E § iv 882888882882828822882288225882;2 ggg8888822 8 4, 300 888 ra § ,3 c0 CO 88 zn' "3 co Fo' r. 00000000000000 g 222222 §§§§§§§§§§§§§§§§§§§§§ 2 rs "3 as 8 CCCn 888882888888888822888888 G3 00 ro § "3 <0 R 8 CO F-11'd)WF)Pligg to. § "3 i0 F4 41 `.:1 Po !..7 "3 3 41 28titit8228!•2 O N 1•3 • S000p!So0p0ppl000-, 8 88 f../ c § N3 -ko — 7,1 ca 2.1 000 r...) § "3 I,'; fss '114Erg 288888888888 •40 (.4 g 1'3 9 F-1 § 4,4 o 21 ST^. "3 1? 'a a' 0 § 41 0 - g 2,.'?,;'.'880',',3 0 K.', 2 C.1 -9 § 14 to 00000 :282 C) g § 88 -81tirig W. N) !`3 ?,"3 §§ CS 2o Is) § '0! 8 MARICOPA COUNTY TREASURER Soltcltd Funds Total Earnings Page 6 November 1, 2618 - November 30, 208 Adjusted Interest Earnings Ending Beginning Ending Current Annualized Interest Arnortiza lien) Realtzed Adjusted Interest CUSIP investment C Fund Issuer Par Value Book Value Book Value Rate Yield Earned Accretion 011001.680 Earnings Fund: Treasurer's Pool 3134 082109 10772 1000 FHLMC 25.000.000.00 25.000,000.00 25.000.000_00 3.000 3.042 62,500.00 0.00 0.00 62,55080 3134052110 10773 1000 FFILNIC 2000000000 20,000,000 00 25,000,000_00 3.110 3.153 51,833.33 0.00 0.00 51,833.33 313312JE1 10775 1000 FCDN 2000000000 19,634,486 89 19,677,155.55 2.550 2.644 0.00 42,666.66 0.00 42,666.66 31308.7 506 10776 1000 FMB 25.000.000.00 25.000.000.00 25.000,000.00 3.000 3.642 62,600.00 0.00 0.00 62,500.00 3130AF5;13 10777 1000 FF1LB 25.000.000.00 25.000.000.00 25.000.000.00 3.150 3.194 65,625_00 0.00 0.00 65,625.00 3134GSYX'7 10776 1000 FHL.1.1.0 25000,000.00 25.000,000.00 25,000,000.00 3.090 0.133 64.375.00 0.00 0.00 64.37580 3134GSZQ1 10779 1600 20.000.000.00 20.000,000.00 20.000,000.00 3.070 3.113 51.166.66 0.00 0.00 51,180.68 3133121068 10760 1000 fCDN 20,000.000.00 19.578.405.56 19.621.57223 2.590 2.083 0.00 43,168 67 0.00 43,166.67 31331210135 10781 1000 FCDN 10,000,000 00 084 9,822266_67 2,550 2.660 0.03 21,50080 0.00 21,500.00 3133121.02 10782 1000 FCDN 20,000,000 00 0.00 19,577,738_89 2.630 2.730 0.00 42.37222 0.00 42,372.22 313.0AF526 10784 1000 FHLB 25000000.00 0.00 25,000,000.00 3 205 3200 51,190.97 0.00 0.00 51,190.97 912796Rt13 10766 1000 LISTR 25,000,000.00 0.00 24,381,937.50 2.610 2.717 0.00 29.000.00 0.00 29,000.03 9123263H1 10787 1000 USTR 25,000,000.00 0.00 24,753.042_76 1.760 2765 19,132_25 10.85528 0.00 29,987.51 3134GSZY4 10788 1000 FHIJIC 20,000,000.00 0.00 20,000.000.00 3.125 3.163 19,097 22 0.00 0.00 19,097.22 3133E1790 10709 1000 FFCB 25.000.000.00 0.00 24.972.093.75 2.630 3.052 30.729.17 593.75 0.00 31.322_92 3134GSZW3 10790 1000 FHSJJC 25,000,000 00 0.00 25.000.000.00 3.260 3.305 11,319.44 0.00 0.00 11,319.44 313408221 10791 1000 FHLP.IC 25,000,000.00 9.00 28.00000080 3 280 3.025 11,388.69 0.00 0.00 11,388.89 3134GS2V0 10792 1000 FHO,SC 25,000,000.00 0.00 25,000,000.00 3 250 3 295 11,284.72 0.00 0.00 11,284.72 313408A70 10793 1000 FHI.J.1C 25.000.000.00 0.00 25.000.000.00 3.000 3.042 6250.00 0.00 0.00 8250.00 3130AFFB8 10794 1000 FHL13 25.000.000.00 0.00 25000.000.00 3.000 3.042 8250.00 0.00 0.00 6,250.00 3134GVAC5 15.300 1000 F1-11.11C 20,000,000.00 0.00 19.938.684.24 2.900 3.067 1,611.11 6424 0.00 1,675.35 3133651.107 10802 1000 FEDN 24,200,000.00 0.00 24,159,182.50 2 250 2 285 0.00 1,51200 0.00 1,51250 Subtotal 4,538.101,953.72 4,586,534,86365 4,535,333,135.19 2.050 7,825,550.89 301,263.20 0.00 8,126,814.09 Fund: MINS Bond Proceeds 912$281140 10785 53403' USTR 25.005800.00 13.00 24.697,421.06 1.000 2,661 11,049.72 17.73-3.56 0.00 28,783_28 313384CHO 10795 53403' FHDN 30,000.000.00 0.00 29.830.150.00 2.570 2.417 0_00 5.925_00 0.00 5.925,00 313384075 10796 33403, FFIDN 20,000,000.00 0.00 19,922668 67 2 320 2.382 0_00 3,866_67 0.00 3666.67 313364727 10797 53403' HAM 30,000,00080 0.00 29,644,750.00 2.450 2.514 0.00 6,125.00 0.00 6,125.00 31008.2188 10793 5348.2 FHLB 35,000,000.00 0.00 38.000,0610.00 3.000 3.042 8,750.00 0.00 0.00 8,750.00 31008.2 F68 10799 53453' FHLB 21675,000.00 0.00 21,875,000.00 3.000 3.042 5,468.75 0.00 0.00 5,468.75 313354575 10301 53457 FHIX1 25.000.000.00 0.00 24,902,916.67 2.330 2.372 0.00 1.618.06 0.00 1,618.06 313385680 10303 53403' FHON 55.000.000 00 0,00 54,934.37222 2_120 2.151 0.00 6.477.78 0.00 6.477,78 Subtotal 241,875,000.00 0.00 240,837,276.62 2,606 24,268.47 41,746.07 0.09 67,014.64 Porlfol:o 1NVT Data Updated: -REPORT--: 12118/2018 07:10 AP Data 12116.20t8 - 07.10 w(PftS_IE) 7.36 Repxt 'AL 7.36.1 MARICOPA COUNTY TREASURER Selected Funds Total Earnings Page 7 November 1, 2018 - November 30,2018 Adjusted interest Earnings Ending Beginning Ending Current Annualized Interest Amortization" Reartzed Adjusted Interest CU SIP Investment 8 fund Issuer Pa r Value Book Value Book Value Rain Yield Eamed Actretion Oeinaoss Earnings Fond: 1,1111S Depository 313364A16 10727 5340E F1-113.4 25,000,000.00 24,884,895_83 24929,166 67 2.125 2.164 0,00 44,270_84 0_00 44.270_84 9127961:P8 10742 53400 USIR 76.726,000.69 76,309,985.21 76,447,132 94 2.145 2.187 0.00 137,147.73 0_00 137,147.73 Subtotal 101,726,00000 101,194,881.04 101,376,299.61 2.181 0.00 181,418.57 0.00 181,418.57 Fund: MIMS Debt Service 665275873 10.426 53406 41n1 1,1 0.01 0.01 0.01 0.623 0.00 0.00 0.00 0.00 313355722 10728 53413S FHD1,1 2,000.000,00 1.995.126.67 1,998.526.67 2.040 2.073 0.00 3.400_00 0.00 3,400.00 Subtotal 2,000,000,91 1,095,129.63 1,005,025.63 2.073 0.00 3,400.00 0.00 3,490.00 Fund: ME HS Health Plan Sate 3433001F3 10406 534HP FECH 0,00 12,400,000.00 01701 1.250 0.00 0.00 0.00 0.00 3133EKKJI 10412 534HP FFC13 0.00 13,299.667.90 0,00 9.220 1.273 11,26806 332.50 0.00 11,600 56 912828F62 10783 534HP USTR 17,968,000.00 0.00 17,791,41838 1.500 2.727 21,613.01 16894.78 0.00 38,507.79 Subtotal 17,938,00.00 26,614,667.60 17,791,418.76 2.126 37,881.07 17,227.28 0.90 50,10E1.35 Total 4,902,688,033.73 4,715,424,638.87 4,897,336,656.86 2.101 7,883,700.43 8.4505512 0,00 8428,755,65 PorlfotIo I NVT Data Updated: -REPORT-7 12/18/2018 07:10 AP Rin Da a 12)132618 - 07.10 TE (PRF_TE) 7.36 Rero-1 Var. 7.3 6.1 Mericopa County MARICOPA COUNTY TREASURER Selected Funds Total Earnings Sorted by Fund - Investment Class November 1, 2018 - November 30, 2018 Adjusted titter-est Earnings Ending Beginning Ending Current Annualized Interest Amortization/ ReaUzed Adjusted Interest CUSIP Investment ft Fund Issuer Par Value Book Value Book Value Rate Yield Earned Accretion GainVLoss Earnings Fund: Treasurer's Pool Subtotal 4,539,101,953.72 4,534,534,863.65 4,635,333,135.19 2.495 7,825,650.89 341,263.20 0.00 5,126614.09 Fund: MINS Bond Proceeds Subtotal 241,575,000.00 0.00 240,837,276.52 2.646 23,268.47 41,746.07 0.00 67,014,6.4 Fund: MINS Depository Subtotal 101,725,000.00 101,194,881.04 101,376,29961 2.181 0.00 181,418.67 0.00 181,41867 Fund: MINS Debt Service Subtotal 2,000,000.01 1,995,126.95 1,998,626.68 2.073 0.00 3,400.00 0.00 3.400.00 Fund: WEIS Health Plan Sale Subtotal 17,986,000.00 25,699,667.50 17,791,418.76 2.126 376.81.07 17,227.28 0.00 60.10635 Total 4,902,688,953.73 4,716,424,638.87 4,897,336,656.86 2.101 7,883,700.43 545,055.12 0.00 8,428.765.65 PodfaSo INVT Data Updated: —REPORT—: 12/10/2018 07:08 AP Run D-3:9 121162018 - 07.03 TE (PRF_TE) 7.3 Regort Ve, 7.30.1 2,640,539,470.39 2,507,334.84- 525,249,117.41 3,168,295,922.64 100,691,292,098.44 TOTAL 331.83 .00 .00 331.83 .58 116,414,184 1968 922.38 .00 .00 922.38 .74 126,692,073 1969 1,998.26 .00 .00 1,998.26 .82 138,694,628 1970 4,111.30 .00 .00 4,111.30 .50 165,623,012 1971 5,885.92 .00 .00 5,885.92 .44 191,805,552 1972 6,216.48 .00 .00 6,216.48 .94 224,585,828 1973 8,954.20 .00 .00 8,954.20 .52 251,690,646 1974 10,864.89 .00 .00 10,864.89 .68 294,189,512 1975 12,599.20 .00 .00 12,599.20 .68 332,481,242 1976 12,427.08 .00 .00 12,427.08 .88 360,443,065 1977 17,517.30 .00 .00 17,517.30 .04 365,594,731 1978 15,972.66 .00 .00 15,972.66 .36 382,783,606 1979 11,274.71 .00 .00 11,274.71 .34 373,230,675 1980 13,529.19 .00 .00 13,529.19 .72 402,942,488 1981 11,573,32 .00 .00 11,573.32 .40 451,214,378 1982 28,883.91 .00 .00 28,883.91 .42 530,525,148 1983 21,166.00 .00 .00 21,166.00 .84 600,944,379 1984 86,095.02 .00 .00 86,095.02 .08 721,770,831 1985 17,516.20 .00 .00 17,516.20 .72 870,295,854 1986 22,359.94 .00 .00 22,355.94 .56 1,049,888,299 1987 3,284,787.15- .00 .00 3,284,787.16- .12 1,181,440,841 1988 8,122,152.43 .00 .00 8,122,152.43 .54 1,306,266,536 1989 7,952,619.51 .00 .00 7,952,619.51 .32 1,445,084,095 1990 2,207,545.99 .00 .00 2,207,545.99 .84 1,485,482,338 1991 3,577,206.37 .00 .00 3,577,206.37 .42 1,477,426,592 1992 1,190,778.31 .00 .00 1,190,778.31 .04 1,476,046,063 1993 1,128,187.77- .00 .00 1,128,187.77- .58 1,507,769,663 1994 758,500.65- .00 .00 758,500.65- .12 1,683,783,514 1995 79,001.04- .00 .00 79,001.04- .46 1,631,715,958 1996 651,645.16- .00 .00 651,645.16- .36 1,800,100,859 1997 762,983.09- .00 .00 762,983.09- .72 1,939,463,904 1998 679,724.78- .00 .00 679,724.78- .02 2,108,718,697 1999 572,754.61- .00 .00 572,754.61- .96 2,290,234,573 2000 615,431.95 .00 .00 615,431.95 .32 2,595,278,869 2001 1,291,547.44- .00 .00 1,291,547.44- .72 2,792,576,236 2002 743,279.36- .00 .00 743,279.36- .00 3,049,037,955 2003 585,095.24 48.90- .00 585,144,14 .B4 3,246,259,075 2004 511,075.54 97.66- 28.52 511,201.72 .20 3,489,841,477 2005 816,721.95- 88.04- 346.42 816,287.49- .00 3,660,387,436 2006 732,567.76- 789.82- 20,025.88 711,752.06- .74 4,001,594,678 2007 25,952,661.24 935.42- 17,731.28 25,971,327.94 .70 4,288,606,572 2008 86,928,783.34 1,028.04- 6,485.91 86,936,297.29 .98 4,593,263,862 2009 43,080,577.41- 1,640.02- 8,159.36 43,070,778.03- .04 4,411,089,394 2010 20,705,082.70 1,299.48- 7,745.65 20,714,127.83 .04 4,138,461,193 2011 1,338,845.01- 1,547.90- 4,647.16 1,332,649.95- .92 4,045,298,460 2012 1,039,713.93 1,698.10- 9,388.76 1,050,800.79 .28 4,019,480,209 2013 1,342,081.06 2,384.88- 2,483.12 1,346,949.06 .16 4,243,506,812 2014 2,082,333.21 94,915.28- 60,277.07- 2,116,971.42 .86 4,364,407,727 2015 2,449,619.15 127,69:3.21- 92,728.65- 2,484,588,71 .76 4,643,191,878 2016 28,264,481.07 179,122.27- 2,936,753.60 31,380,356.94 .58 4,791,587,056 2017 2,502,623,736.75 2,094,040.82- 522,388,327.47 3,027,106,105.04 .54 5,032,079,420 2018 BALANCE ENDING ADJuSTmENTS COLLECTIONS BALANCE BEGINNING LEVY YEAR 2018 NOV FOR ACTIVITY AND LEVY SECURED 1 PAGE: OFFICE TREASURER'S COUNTY MARICOPA 03-DEC-2018 LEVY_RPT_MONTH_SUM APP ID: PROGRAM 405,643,181.97- 52.88- 149.41 405,642,979.68- 2,325,116,156.87 TOTAL 2,320,992.14- .00 .00 2,320,992.14- 4,195,165.19 1968 1,422,511.95- .00 .00 1,422,511.95- 5,918,654.86 1969 433,497.42- .00 .00 433,497.42- 10,386,975.86 1970 1,719,922.67- .00 .00 1,719,922.67- 12,084,654.91 1971 2.953,558,51- .00 .00 2,953,558.51- 13,623,786,21 1972 5,836,677.39- .00 .00 5,836,677.39- 13,177,965.26 1973 5,472,248.17- .00 .00 5,472,248.17- 15,296,922.12 1974 2,664,351,52- .00 .00 2,664,351.52- 19,189,042,79 1975 2,691,654.20- .00 .00 2,691,654.20- 23,204,794.95 1976 5,929,894.62- .00 .00 5,929,894.62- 26,779,663.13 1977 6,812,702.12- .00 .00 6,812,702.12- 28,615,308.42 1978 6,557,551.22- .00 .00 6,557,551.22- 29,722,220.00 1979 17,272,723.82- .00 .00 17,272,723.82- 30,075,323.04 1980 18,055,558.20- .00 .00 18,055,558.20- 36,683,300.76 1981 22,905,048.43- .00 .00 22,905,048.43- 37,836,109.79 1982 6,576,362.12- .00 .00 6,576,362.12- 73,434,045,21 1983 12,928,943.11- .00 .00 12,928,943.11- 53,570,953.57 1984 28,111,671.68- .00 .00 28,111,671.68- 50,507,999.56 1985 25,772,725.38- .00 .00 25,772,725.38- 76,956,283.43 1986 7,183,543.56- .00 .00 7,183,543.56- 88,991,362.81 1987 21,536,288.24- .00 52.57 21,536,235.67- 96,811,185.54 1988 7,916,764.63- .00 .00 7,916,764.63- 113,929,972.43 1989 951,248,94- .00 .00 951,248.94- 122,744,902.09 1990 6,350,364.25- .00 .00 6,350,364.25- 131,582,124.56 1991 17,543,242.15- .00 .00 17,543,242.15- 140,629,687.78 1992 14,418,901.57- .00 .00 14,418,901.57- 154,917,045.68 1993 8,102,962.21 .00 .00 8,102,962.21 162,209,939.25 1994 28,756,728.91- .00 .00 28,756,728.91- 113,747,601.86 1995 35,079,799.08- .00 .00 35,079,799.08- 102,673,892.06 1996 - 22,893,459.13 .00 .00 22,893,459.13- 115,134,253.32 /997 25,521,471.87- .00 .00 25,521,471.87- 122,881,710.56 1998 28,466,644.24- .00 96.84 28,466,547.40- 122,871,629.32 1999 9,284,773,33- .00 .00 9,284,773.33- 138,497,672.37 2000 900,285.49- .00 .00 900,285.49- 19,330,396.80 2001 3,035,662.97 .00 .00 3,035,662.97 16,903,615.38 2002 13,341,946.57- 52.88- .00 13,341,893.69- .00 2003 197,750.52- .00 .00 197,750.52- .00 2004 BALANCE ENDING ADJUSTMENTS COLLECTIONS BALANCE BEGINNING LEVY YEAR 2018 NOV FOR ACTIVITY AND LEVY UNSECURED 1 PAGE: OFFICE TREASURER'S COUNTY MARICOPA 03-DEC-2018 MONTH_SUM RPT LEVY APP ID: PROGRAM