NOV MONTHLY REP 2018.PDF

Maricopa County — Formal (2019-01-09)

View PDF Item 30 Meeting page

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