Cities Index.
Agenda packet

Modesto City Council
January 9, 2024

Document
Agenda packet
Meeting
January 9, 2024
Body
Modesto City Council
Pages
8
Original file
18.8 MB
Text extracted from the city's file for reading and search. Open the original on agenda2.modestogov.com. That file is the official record.

25.45 40.18

23.50 73.40
145.19
158.84
183.62

22.25 21.00

30.25 21.00

40.65 40.65

23.50 23.50

40.65 23.50

23.50 25.45

22.25 21.00

21.00 31.75

21.50 31.00

21.00 34.75

30.25 25.25

21.00 23.50

8.70 TOTAL FOR CHECK: 225.83
258230
258679
258491
258687
258625
258475
258776
258604
258682
258683
258685
258684
258688
258689
258690
258691
258692
258694
258693
258697
258703
258704
258705
258706
258707
258708
258709
258711
258710
258713
258712
258714
258826
Attachment 5, Vendor ePayables
#6..
- 316 -
Bank: BMO Main BMO
Branch
Branch: BMO E-Payables
(Main)
Account:

CHECK
NUMBER
VENDOR

NAME SITE INVOICE NUMBER

INVOICE
DATE

PAYMENT
AMOUNT
** CITY OF MODESTO **
REPORT ID: COMAPCHKREG.rdf PAYMENT CHECK REGISTER
09-NOV-23 Page: 15
PO
NUMBER
815765 ARAMARK UNIFORM

SERVICE
5040198232
5040197531
5040198231
5040191401
5040194823
5040194825
5040194824
5040201718
5040201717
5040200929
5040201716
5040198222
5040197521
5040200928
5040194078
5040201707
5040200911
5040193495
5040194811
5040194810
5040198210
5040198211
5040194813
5040198209
5040197529
5040198212
5040203254
5040194814
5040198213
5040203256
5040194812
5040203233
5040203249
5040203226
19-SEP-23
18-SEP-23
19-SEP-23
05-SEP-23
12-SEP-23
12-SEP-23
12-SEP-23
26-SEP-23
26-SEP-23
25-SEP-23
26-SEP-23
19-SEP-23
18-SEP-23
25-SEP-23
11-SEP-23
26-SEP-23
25-SEP-23
08-SEP-23
12-SEP-23
12-SEP-23
19-SEP-23
19-SEP-23
12-SEP-23
19-SEP-23
18-SEP-23
19-SEP-23
28-SEP-23
12-SEP-23
19-SEP-23
28-SEP-23
12-SEP-23
28-SEP-23
28-SEP-23
28-SEP-23

34.75 51.95

78.04 96.69

96.69 151.09

62.18 8.70

34.75 51.95

79.12 96.69

25.74 73.40

25.74 96.69

25.74 55.82

25.26 12.87

25.26 37.99

71.76 12.87
103.77

71.76 21.00
140.28
140.28

31.75 37.99

21.00 30.25

22.25 258828
258827
258829
258790
258791
258766
258939
259101
259099
259108
259102
259142
259207
259211
259208
259299
259209
259477
258993
258994
258996
259026
259010
258995
259011
259023
259271
259158
259048
259272
259012
259273
259275
259274
Attachment 5, Vendor ePayables
#6..
- 317 -
Bank: BMO Main BMO
Branch
Branch: BMO E-Payables
(Main)
Account:

CHECK
NUMBER
VENDOR

NAME SITE INVOICE NUMBER

INVOICE
DATE

PAYMENT
AMOUNT
** CITY OF MODESTO **
REPORT ID: COMAPCHKREG.rdf PAYMENT CHECK REGISTER
09-NOV-23 Page: 16
PO
NUMBER
815765
815766

ARAMARK UNIFORM

SERVICE

AT&T MOBILITY
5040203255
5040203252
5040203253
5040203231
5040203237
5040196371
5040203250
5040198214
5040194815
5040198216
5040194836
5040203707
5040198217
5040201702
5040194818
5040198235
5040194834
5040170780
5040191402
5040187971
5040194831
5040197530
5040104369
5040101950
5040106822
5040109082
5040187966
5040097077
5040184538
5040191399
5040111581
5040116593
287274763432X09
28-SEP-23
28-SEP-23
28-SEP-23
28-SEP-23
28-SEP-23
14-SEP-23
28-SEP-23
19-SEP-23
12-SEP-23
19-SEP-23
12-SEP-23
29-SEP-23
19-SEP-23
26-SEP-23
12-SEP-23
19-SEP-23
12-SEP-23
25-JUL-23
05-SEP-23
29-AUG-23
12-SEP-23
18-SEP-23
21-FEB-23
14-FEB-23
28-FEB-23
01-JUN-23
29-AUG-23
31-JAN-23
22-AUG-23
05-SEP-23
01-JUN-23
28-MAR-23
14-SEP-23

21.00 25.25

34.75 21.00

31.00 25.45

23.50 26.76

26.76 18.15
368.80

55.82 33.91

33.91 33.91
365.58

8.70 141.45

62.18 155.24

33.97 73.40

42.69 43.05

42.69 42.69

49.18 42.69

40.30 61.30

42.69 42.69
13,699.30
TOTAL FOR CHECK: 5,321.56
259277
259278
259276
259280
259279
259281
259284
259417
259415
259332
259457
259475
259480
259479
259481
259558
258451
258210
258388
258040
258481
258649
258407
258408
258409
258411
258412
258410
258414
258448
258413
258415
N/A
Attachment 5, Vendor ePayables
#6..
- 318 -
Bank: BMO Main BMO
Branch
Branch: BMO E-Payables
(Main)
Account:

CHECK
NUMBER
VENDOR

NAME SITE INVOICE NUMBER

INVOICE
DATE

PAYMENT
AMOUNT
** CITY OF MODESTO **
REPORT ID: COMAPCHKREG.rdf PAYMENT CHECK REGISTER
09-NOV-23 Page: 17
PO
NUMBER
815766
815767
815768
815769
815770
815771
815772
815773

AT&T MOBILITY

B I C SECURITY

SYSTEMS

BARNES WELDING
SUPPLY

BONANDER TRUCK &

TRAILER

BRADY IFS (FKA

CENTRAL SANITARY

SUPPLY)

BSK ANALYTICAL

LABORATORIES

CLARK PEST

CONTROL

CURTIS BLUE LINE
(FKA L N CURTIS AND
SO
222023
207163
207932
63250203
184826
8298612
8312916
8316773
8308981
8312313
8314489
8314654
8253433
8283506
8314655
0103521
0103485
33926966
INV719952
INV744142
INV725033
INV734784
01-SEP-23
01-SEP-23
14-SEP-23
22-AUG-23
11-SEP-23
15-SEP-23
18-SEP-23
14-SEP-23
15-SEP-23
09-SEP-23
18-SEP-23
21-AUG-23
01-SEP-23
18-SEP-23
31-AUG-23
31-AUG-23
01-AUG-23
30-JUN-23
07-SEP-23
11-JUL-23
10-AUG-23

86.30 36.00
191.30
2,431.69
1,669.40
-93.59

77.61 83.15
325.67
186.41

22.04 307.05

31.96 39.81
2,174.94
2,392.00
1,000.00
1,689.74
740.23
138.27
352.76
TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:
13,699.30
122.30
191.30
2,431.69
2,649.51
4,566.94
1,000.00
2,921.00
257839
257845
258546
257989
257055
257055
257055
257423
256823
253990
257423
258472
258472
256430
238714
256649
258426
258326
258686
258805
258806
Attachment 5, Vendor ePayables
#6..
- 319 -
Bank: BMO Main BMO
Branch
Branch: BMO E-Payables
(Main)
Account:

CHECK
NUMBER
VENDOR

NAME SITE INVOICE NUMBER

INVOICE
DATE

PAYMENT
AMOUNT
** CITY OF MODESTO **
REPORT ID: COMAPCHKREG.rdf PAYMENT CHECK REGISTER
09-NOV-23 Page: 18
PO
NUMBER
815774
815775
815776
815777
815778
815779
DITTOS

FIRST CHOICE

INDUSTRIAL SUPPLY

COMPANY

FLORY INDUSTRIES
INC

HARD DRIVE

GRAPHICS

HARTLEY AND

ASSOCIATES

HERC RENTALS
199211
199296
095717-01
095976
095975
461603
466930
465609
37957
1783A249
1782A250
1784A250
1776A250
1785A250
1779A250
1783A246
33934883-002
33956528-001
33941502-001
33949434-001
33835384-001
33765552-002
33728598-003
33852239-001
33519983-005
33601349-005
33519491-006
22-AUG-23
07-SEP-23
24-AUG-23
11-SEP-23
11-SEP-23
08-AUG-23
08-AUG-23
08-AUG-23
15-SEP-23
16-AUG-23
16-SEP-23
16-SEP-23
16-SEP-23
16-SEP-23
16-SEP-23
16-MAY-23
22-AUG-23
23-AUG-23
22-AUG-23
23-AUG-23
29-JUL-23
31-JUL-23
25-JUL-23
25-JUL-23
16-AUG-23
24-AUG-23
16-AUG-23
3,441.73
410.02
116.50
853.58
232.99
125.24
788.41
233.01

43.54 6.26
127.76
316.49
1,235.33
432.78

15.64 3.41
2,134.96
1,397.47
1,279.38
265.46
3,182.20
3,230.42
2,218.86
115.18
1,370.05
4,058.59
3,290.75
TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:
3,851.75
1,203.07
1,146.66

43.54 2,137.67
258246
258248
256301
257141
257025
258206
258208
258207
258364
257053
259138
259218
259220
259052
259051
259528
258066
258069
258067
258068
258074
258075
258080
258079
258077
258161
258081
Attachment 5, Vendor ePayables
#6..
- 320 -
Bank: BMO Main BMO
Branch
Branch: BMO E-Payables
(Main)
Account:

CHECK
NUMBER
VENDOR

NAME SITE INVOICE NUMBER

INVOICE
DATE

PAYMENT
AMOUNT
** CITY OF MODESTO **
REPORT ID: COMAPCHKREG.rdf PAYMENT CHECK REGISTER
09-NOV-23 Page: 19
PO
NUMBER
815779
815780
815781
815782
815783

HERC RENTALS

HERITAGE FORD INC

HUGHSON FARM
SUPPLY

IMAGE UNIFORMS

INTERSTATE TRUCK
CENTER
33739619-003
33736616-003
33743563-003
33601349-004
33743563-002
5235724
63174752
5235839
5236050
63188941
63151902
H471706
H471704
143782
02P460658
02P460653
02P466313
02P463321
02P461695
02P462910
02P467069
02P463784
02P465514
02P465494
02P464626
02P463324
02P463332
02P462387
20-AUG-23
20-AUG-23
21-AUG-23
25-JUL-23
22-JUL-23
31-AUG-23
25-AUG-23
05-SEP-23
08-SEP-23
22-SEP-23
12-JUL-23
20-SEP-23
20-SEP-23
18-AUG-23
11-AUG-23
11-AUG-23
08-SEP-23
24-AUG-23
22-AUG-23
23-AUG-23
13-SEP-23
28-AUG-23
05-SEP-23
05-SEP-23
31-AUG-23
24-AUG-23
28-AUG-23
23-AUG-23
2,572.72
2,833.33
4,716.74
4,058.59
4,716.74

32.05 250.00

21.25 80.32
175.00
1,449.99

25.42 54.07
369.47
-241.00
-275.23
258.13
210.49
438.68
1,557.95
777.61
1,555.21
2,949.45
1,756.63
1,756.63
888.16
758.60

95.44 TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:
41,441.44
2,008.61

79.49 369.47
258087
258086
258164
258162
258310
257880
257894
258332
258332
259315
259315
258473
258473
258129
239063
248849
257901
258183
258184
258180
258191
258244
258188
258190
258182
258186
258185
258181
Attachment 5, Vendor ePayables
#6..
- 321 -
Bank: BMO Main BMO
Branch
Branch: BMO E-Payables
(Main)
Account:

CHECK
NUMBER
VENDOR

NAME SITE INVOICE NUMBER

INVOICE
DATE

PAYMENT
AMOUNT
** CITY OF MODESTO **
REPORT ID: COMAPCHKREG.rdf PAYMENT CHECK REGISTER
09-NOV-23 Page: 20
PO
NUMBER
815783
815784
815785
815786
815787
815788
815789
815790
815791

INTERSTATE TRUCK
CENTER

JORGENSEN AND CO

MCCOY TRUCK TIRE

SERVICE CTR

MODESTO STEEL

PACE SUPPLY

CORPORATION

PACIFIC MOBILE

STRUCTURES INC

SAFE-T-LITE OF

MODESTO INC

VERIZON

WESTURF NURSERY
02P464086
02P465872
02P465484
6084134
6086523
10139716
414883
415960
413776
58930298
58884230-1
58935253
327760
393397
393367
393103
393050
393484
9945542831
914758
902297
29-AUG-23
07-SEP-23
07-SEP-23
15-AUG-23
29-AUG-23
16-MAY-23
07-SEP-23
13-SEP-23
30-AUG-23
25-SEP-23
29-SEP-23
27-SEP-23
01-OCT-23
21-SEP-23
20-SEP-23
05-SEP-23
31-AUG-23
27-SEP-23
28-SEP-23
11-JUL-23
09-MAY-23
1,544.29
376.79
272.72

25.87 672.06
4,979.27
1,969.80
1,515.44
1,969.80
720.27

99.61 578.80
586.84
120.22

47.45 1,417.97
325.72
413.55
16,598.07
137.91

3.76 TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:
14,680.55
697.93
4,979.27
5,455.04
1,398.68
586.84
2,324.91
16,598.07
141.67
258083
258053
258054
258373
258298
258945
258295
258734
258931
257838
256834
258198
240962
258539
258535
258034
258033
258512
N/A
259400
254167
Attachment 5, Vendor ePayables
#6..
- 322 -
Bank: BMO Main BMO
Branch
Branch: BMO E-Payables
(Main)
Account:

CHECK
NUMBER
VENDOR

NAME SITE INVOICE NUMBER

INVOICE
DATE

PAYMENT
AMOUNT
** CITY OF MODESTO **
REPORT ID: COMAPCHKREG.rdf PAYMENT CHECK REGISTER
09-NOV-23 Page: 21
PO
NUMBER
815792 ALPHA ANALYTICAL

LABORATORIES
3094662-
CVR_MODDW
3094663-
CVR_MODDW
3094665-
CVR_MODDW
3094684-
CVR_MODDW
3094685-
CVR_MODDW
3094686-
CVR_MODDW
3094687-
CVR_MODDW
3094708-
CVR_MODDW
3094743-
CVR_MODDW
3094889-
CVR_MODDW
3095222-
CVR_MODDW
3095245-
CVR_MODDW
3095281-
CVR_MODDW
3095282-
CVR_MODDW
3095287-
CVR_MODDW
3095298-
CVR_MODDW
3095309-
CVR_MODDW
3095329-
CVR_MODDW
3095485-
CVR_MODDW
3095530-
CVR_MODDW
3095539-
CVR_MODDW
19-SEP-23
19-SEP-23
19-SEP-23
19-SEP-23
19-SEP-23
19-SEP-23
19-SEP-23
19-SEP-23
19-SEP-23
20-SEP-23
22-SEP-23
22-SEP-23
22-SEP-23
22-SEP-23
22-SEP-23
22-SEP-23
22-SEP-23
22-SEP-23
25-SEP-23
25-SEP-23
25-SEP-23

56.00 42.00

56.00 28.00

42.00 42.00

84.00 286.00

20.00 306.00
290.00
194.00
140.00

84.00 210.00

84.00 480.00
960.00
192.00

40.00 80.00
259244
259244
259244
259244
259244
259244
259244
259245
259245
259245
259245
259245
259245
259245
259245
259245
259257
259257
259257
259257
259257
Attachment 5, Vendor ePayables
#6..
- 323 -
Bank: BMO Main BMO
Branch
Branch: BMO E-Payables
(Main)
Account:

CHECK
NUMBER
VENDOR

NAME SITE INVOICE NUMBER

INVOICE
DATE

PAYMENT
AMOUNT
** CITY OF MODESTO **
REPORT ID: COMAPCHKREG.rdf PAYMENT CHECK REGISTER
09-NOV-23 Page: 22
PO
NUMBER
815792 ALPHA ANALYTICAL

LABORATORIES
3095540-
CVR_MODDW
3095566-
CVR_MODDW
3095567-
CVR_MODDW
3095679-
CVR_MODDW
3095680-
CVR_MODDW
3095681-
CVR_MODDW
3095690-
CVR_MODDW
3095691-
CVR_MODDW
3095693-
CVR_MODDW
3095694-
CVR_MODDW
3095695-
CVR_MODDW
3095696-
CVR_MODDW
3095829-
CVR_MODDW
3096155-
CVR_MODDW
3095985-
CVR_MODDW
3095986-
CVR_MODDW
3095987-
CVR_MODDW
3095988-
CVR_MODDW
3095990-
CVR_MODDW
3095995-
CVR_MODDW
3103187-
CVR_MODDW
25-SEP-23
25-SEP-23
25-SEP-23
26-SEP-23
26-SEP-23
26-SEP-23
26-SEP-23
26-SEP-23
26-SEP-23
26-SEP-23
26-SEP-23
26-SEP-23
26-SEP-23
28-SEP-23
27-SEP-23
27-SEP-23
27-SEP-23
27-SEP-23
27-SEP-23
27-SEP-23
04-OCT-23

80.00 1,045.00
290.00
158.00
168.00
126.00

28.00 28.00

70.00 42.00

46.00 84.00
100.00
275.00

28.00 14.00

84.00 70.00
138.00

56.00 440.00
259257
259257
259257
259246
259246
259246
259246
259246
259246
259246
259246
259246
259527
259527
259527
259527
259527
259527
259527
259527
259546
Attachment 5, Vendor ePayables
#6..
- 324 -
Bank: BMO Main BMO
Branch
Branch: BMO E-Payables
(Main)
Account:

CHECK
NUMBER
VENDOR

NAME SITE INVOICE NUMBER

INVOICE
DATE

PAYMENT
AMOUNT
** CITY OF MODESTO **
REPORT ID: COMAPCHKREG.rdf PAYMENT CHECK REGISTER
09-NOV-23 Page: 23
PO
NUMBER
815792 ALPHA ANALYTICAL

LABORATORIES
3103093-
CVR_MODDW
3103119-
CVR_MODDW
3103151-
CVR_MODDW
3103181-
CVR_MODDW
3103186-
CVR_MODDW
3103086-
CVR_MODDW
3092727-
CVR_MODWW
3092853-
CVR_MODWW
3085784-
CVR_MODWW
3086462-
CVR_MODWW
3086002-
CVR_MODWW
3086507-
CVR_MODWW
3086003-
CVR_MODWW
3096298-
CVR_MODDW
3102852-
CVR_MODDW
3102886-
CVR_MODDW
3102941-
CVR_MODDW
3102945-
CVR_MODDW
3102959-
CVR_MODDW
3092702-
CVR_MODWW
3103344-
CVR_MODDW
03-OCT-23
03-OCT-23
03-OCT-23
04-OCT-23
04-OCT-23
03-OCT-23
05-SEP-23
06-SEP-23
23-AUG-23
28-AUG-23
24-AUG-23
28-AUG-23
24-AUG-23
29-SEP-23
02-OCT-23
03-OCT-23
03-OCT-23
03-OCT-23
03-OCT-23
05-SEP-23
04-OCT-23
286.00
540.00

60.00 80.00
825.00

20.00 3,815.00
162.00
4,486.00
9,615.00
4,491.00
20,032.00
4,486.00

20.00 255.00
220.00
1,650.00
1,080.00

14.00 3,334.00

20.00 259546
259546
259546
259546
259546
259546
258778
258777
258783
258784
258782
258876
258786
259707
259707
259707
259707
259707
259707
258787
259548
Attachment 5, Vendor ePayables
#6..
- 325 -
Bank: BMO Main BMO
Branch
Branch: BMO E-Payables
(Main)
Account:

CHECK
NUMBER
VENDOR

NAME SITE INVOICE NUMBER

INVOICE
DATE

PAYMENT
AMOUNT
** CITY OF MODESTO **
REPORT ID: COMAPCHKREG.rdf PAYMENT CHECK REGISTER
09-NOV-23 Page: 24
PO
NUMBER
815792 ALPHA ANALYTICAL

LABORATORIES
3103273-
CVR_MODDW
3103274-
CVR_MODDW
3103277-
CVR_MODDW
3103345-
CVR_MODDW
3103374-
CVR_MODDW
3103375-
CVR_MODDW
3103539-
CVR_MODDW
3103541-
CVR_MODDW
3102960-
CVR_MODDW
3102962-
CVR_MODDW
3102963-
CVR_MODDW
3102964-
CVR_MODDW
3102975-
CVR_MODDW
3102976-
CVR_MODDW
3102978-
CVR_MODDW
3086463-
CVR_MODWW
3094460-
CVR_MODDW
3094461-
CVR_MODDW
3094463-
CVR_MODDW
3094464-
CVR_MODDW
3094466-
CVR_MODDW
04-OCT-23
04-OCT-23
04-OCT-23
04-OCT-23
05-OCT-23
05-OCT-23
05-OCT-23
05-OCT-23
03-OCT-23
03-OCT-23
03-OCT-23
03-OCT-23
03-OCT-23
03-OCT-23
03-OCT-23
28-SEP-23
19-SEP-23
19-SEP-23
19-SEP-23
19-SEP-23
19-SEP-23
126.00

98.00 14.00
170.00

60.00 120.00

80.00 248.00
182.00
182.00
112.00

50.00 42.00

42.00 84.00
9,615.00

40.00 140.00
120.00

60.00 60.00
259548
259548
259548
259548
259548
259548
259548
259548
259547
259547
259547
259547
259547
259547
259547
258785
259243
259243
259243
259243
259243
Attachment 5, Vendor ePayables
#6..
- 326 -
Bank: BMO Main BMO
Branch
Branch: BMO E-Payables
(Main)
Account:

CHECK
NUMBER
VENDOR

NAME SITE INVOICE NUMBER

INVOICE
DATE

PAYMENT
AMOUNT
** CITY OF MODESTO **
REPORT ID: COMAPCHKREG.rdf PAYMENT CHECK REGISTER
09-NOV-23 Page: 25
PO
NUMBER
815792 ALPHA ANALYTICAL

LABORATORIES
3094520-
CVR_MODDW
3094522-
CVR_MODDW
3094574-
CVR_MODDW
3094462-
CVR_MODDW
3094600-
CVR_MODDW
3094610-
CVR_MODDW
3094662-
CVR_MODDW
3094663-
CVR_MODDW
3094665-
CVR_MODDW
3094684-
CVR_MODDW
3094685-
CVR_MODDW
3094686-
CVR_MODDW
3094687-
CVR_MODDW
3094708-
CVR_MODDW
3094743-
CVR_MODDW
3094889-
CVR_MODDW
3095222-
CVR_MODDW
3095245-
CVR_MODDW
3095281-
CVR_MODDW
3095282-
CVR_MODDW
3095287-
CVR_MODDW
19-SEP-23
19-SEP-23
19-SEP-23
19-SEP-23
19-SEP-23
19-SEP-23
19-SEP-23
19-SEP-23
19-SEP-23
19-SEP-23
19-SEP-23
19-SEP-23
19-SEP-23
19-SEP-23
19-SEP-23
20-SEP-23
22-SEP-23
22-SEP-23
22-SEP-23
22-SEP-23
22-SEP-23

60.00 45.00
700.00

40.00 60.00

40.00 -56.00
-42.00
-56.00
-28.00
-42.00
-42.00
-84.00
-286.00
-20.00
-306.00
-290.00
-194.00
-140.00
-84.00
-210.00
259243
259243
259243
259243
259244
259244
259244
259244
259244
259244
259244
259244
259244
259245
259245
259245
259245
259245
259245
259245
259245
Attachment 5, Vendor ePayables
#6..
- 327 -
Bank: BMO Main BMO
Branch
Branch: BMO E-Payables
(Main)
Account:

CHECK
NUMBER
VENDOR

NAME SITE INVOICE NUMBER

INVOICE
DATE

PAYMENT
AMOUNT
** CITY OF MODESTO **
REPORT ID: COMAPCHKREG.rdf PAYMENT CHECK REGISTER
09-NOV-23 Page: 26
PO
NUMBER
815792 ALPHA ANALYTICAL

LABORATORIES
3095298-
CVR_MODDW
3095309-
CVR_MODDW
3095329-
CVR_MODDW
3095485-
CVR_MODDW
3095530-
CVR_MODDW
3095539-
CVR_MODDW
3095540-
CVR_MODDW
3095566-
CVR_MODDW
3095567-
CVR_MODDW
3095679-
CVR_MODDW
3095680-
CVR_MODDW
3095681-
CVR_MODDW
3095690-
CVR_MODDW
3095691-
CVR_MODDW
3095693-
CVR_MODDW
3095694-
CVR_MODDW
3095695-
CVR_MODDW
3095696-
CVR_MODDW
3095829-
CVR_MODDW
3096155-
CVR_MODDW
3095985-
CVR_MODDW
22-SEP-23
22-SEP-23
22-SEP-23
25-SEP-23
25-SEP-23
25-SEP-23
25-SEP-23
25-SEP-23
25-SEP-23
26-SEP-23
26-SEP-23
26-SEP-23
26-SEP-23
26-SEP-23
26-SEP-23
26-SEP-23
26-SEP-23
26-SEP-23
26-SEP-23
28-SEP-23
27-SEP-23
-84.00
-480.00
-960.00
-192.00
-40.00
-80.00
-80.00
-1,045.00
-290.00
-158.00
-168.00
-126.00
-28.00
-28.00
-70.00
-42.00
-46.00
-84.00
-100.00
-275.00
-28.00
259245
259257
259257
259257
259257
259257
259257
259257
259257
259246
259246
259246
259246
259246
259246
259246
259246
259246
259527
259527
259527
Attachment 5, Vendor ePayables
#6..
- 328 -
Bank: BMO Main BMO
Branch
Branch: BMO E-Payables
(Main)
Account:

CHECK
NUMBER
VENDOR

NAME SITE INVOICE NUMBER

INVOICE
DATE

PAYMENT
AMOUNT
** CITY OF MODESTO **
REPORT ID: COMAPCHKREG.rdf PAYMENT CHECK REGISTER
09-NOV-23 Page: 27
PO
NUMBER
815792 ALPHA ANALYTICAL

LABORATORIES
3095986-
CVR_MODDW
3095987-
CVR_MODDW
3095988-
CVR_MODDW
3095990-
CVR_MODDW
3095995-
CVR_MODDW
3103187-
CVR_MODDW
3103093-
CVR_MODDW
3103119-
CVR_MODDW
3103151-
CVR_MODDW
3103181-
CVR_MODDW
3103186-
CVR_MODDW
3103086-
CVR_MODDW
3092727-
CVR_MODWW
3092853-
CVR_MODWW
3085784-
CVR_MODWW
3086462-
CVR_MODWW
3086002-
CVR_MODWW
3086507-
CVR_MODWW
3086003-
CVR_MODWW
3096298-
CVR_MODDW
3102852-
CVR_MODDW
27-SEP-23
27-SEP-23
27-SEP-23
27-SEP-23
27-SEP-23
04-OCT-23
03-OCT-23
03-OCT-23
03-OCT-23
04-OCT-23
04-OCT-23
03-OCT-23
05-SEP-23
06-SEP-23
23-AUG-23
28-AUG-23
24-AUG-23
28-AUG-23
24-AUG-23
29-SEP-23
02-OCT-23
-14.00
-84.00
-70.00
-138.00
-56.00
-440.00
-286.00
-540.00
-60.00
-80.00
-825.00
-20.00
-3,815.00
-162.00
-4,486.00
-9,615.00
-4,491.00
-20,032.00
-4,486.00
-20.00
-255.00
259527
259527
259527
259527
259527
259546
259546
259546
259546
259546
259546
259546
258778
258777
258783
258784
258782
258876
258786
259707
259707
Attachment 5, Vendor ePayables
#6..
- 329 -
Bank: BMO Main BMO
Branch
Branch: BMO E-Payables
(Main)
Account:

CHECK
NUMBER
VENDOR

NAME SITE INVOICE NUMBER

INVOICE
DATE

PAYMENT
AMOUNT
** CITY OF MODESTO **
REPORT ID: COMAPCHKREG.rdf PAYMENT CHECK REGISTER
09-NOV-23 Page: 28
PO
NUMBER
815792 ALPHA ANALYTICAL

LABORATORIES
3102886-
CVR_MODDW
3102941-
CVR_MODDW
3102945-
CVR_MODDW
3102959-
CVR_MODDW
3092702-
CVR_MODWW
3103344-
CVR_MODDW
3103273-
CVR_MODDW
3103274-
CVR_MODDW
3103277-
CVR_MODDW
3103345-
CVR_MODDW
3103374-
CVR_MODDW
3103375-
CVR_MODDW
3103539-
CVR_MODDW
3103541-
CVR_MODDW
3102960-
CVR_MODDW
3102962-
CVR_MODDW
3102963-
CVR_MODDW
3102964-
CVR_MODDW
3102975-
CVR_MODDW
3102976-
CVR_MODDW
3102978-
CVR_MODDW
03-OCT-23
03-OCT-23
03-OCT-23
03-OCT-23
05-SEP-23
04-OCT-23
04-OCT-23
04-OCT-23
04-OCT-23
04-OCT-23
05-OCT-23
05-OCT-23
05-OCT-23
05-OCT-23
03-OCT-23
03-OCT-23
03-OCT-23
03-OCT-23
03-OCT-23
03-OCT-23
03-OCT-23
-220.00
-1,650.00
-1,080.00
-14.00
-3,334.00
-20.00
-126.00
-98.00
-14.00
-170.00
-60.00
-120.00
-80.00
-248.00
-182.00
-182.00
-112.00
-50.00
-42.00
-42.00
-84.00
259707
259707
259707
259707
258787
259548
259548
259548
259548
259548
259548
259548
259548
259548
259547
259547
259547
259547
259547
259547
259547
Attachment 5, Vendor ePayables
#6..
- 330 -
Bank: BMO Main BMO
Branch
Branch: BMO E-Payables
(Main)
Account:

CHECK
NUMBER
VENDOR

NAME SITE INVOICE NUMBER

INVOICE
DATE

PAYMENT
AMOUNT
** CITY OF MODESTO **
REPORT ID: COMAPCHKREG.rdf PAYMENT CHECK REGISTER
09-NOV-23 Page: 29
PO
NUMBER
815792
815793
815794

ALPHA ANALYTICAL

LABORATORIES

AMERICAN LUMBER
CO

ANIXTER
3086463-
CVR_MODWW
3094460-
CVR_MODDW
3094461-
CVR_MODDW
3094463-
CVR_MODDW
3094464-
CVR_MODDW
3094466-
CVR_MODDW
3094520-
CVR_MODDW
3094522-
CVR_MODDW
3094574-
CVR_MODDW
3094462-
CVR_MODDW
3094600-
CVR_MODDW
3094610-
CVR_MODDW
7224
7493
7420
6958
7209
7388
6515
7023
22K502320
22K501848
22K502638
28-SEP-23
19-SEP-23
19-SEP-23
19-SEP-23
19-SEP-23
19-SEP-23
19-SEP-23
19-SEP-23
19-SEP-23
19-SEP-23
19-SEP-23
19-SEP-23
20-SEP-23
28-SEP-23
26-SEP-23
13-SEP-23
20-SEP-23
25-SEP-23
29-AUG-23
14-SEP-23
11-SEP-23
09-AUG-23
13-SEP-23
-9,615.00
-40.00
-140.00
-120.00
-60.00
-60.00
-60.00
-45.00
-700.00
-40.00
-60.00
-40.00

7.91 761.95

95.58 37.18

68.19 150.89

58.80 51.21
2,401.79
881.72
1,020.41
TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:

0.00 1,231.71
4,303.92
258785
259243
259243
259243
259243
259243
259243
259243
259243
259243
259244
259244
258602
259215
259114
259137
258938
258933
259413
259412
259008
259007
259006
Attachment 5, Vendor ePayables
#6..
- 331 -
Bank: BMO Main BMO
Branch
Branch: BMO E-Payables
(Main)
Account:

CHECK
NUMBER
VENDOR

NAME SITE INVOICE NUMBER

INVOICE
DATE

PAYMENT
AMOUNT
** CITY OF MODESTO **
REPORT ID: COMAPCHKREG.rdf PAYMENT CHECK REGISTER
09-NOV-23 Page: 30
PO
NUMBER
815794
815795
815796
815797
815798

ANIXTER

ARAMARK UNIFORM

SERVICE

ARC DOCUMENT

SOLUTIONS LLC

B I C SECURITY

SYSTEMS

BARNES WELDING
SUPPLY
5040201694
5040139521
5040201696
5040200927
5040201697
5040201698
5040204319
5040197150
5040200319
5040198223
5040201708
5040201709
5040184549
5040201695
5040201706
5040198221
5040184546
5040181095
5040174095
5040174094
5040177649
5040181094
5040177650
5040170781
5040201720
12238251
208633
63253098
26-SEP-23
23-MAY-23
26-SEP-23
25-SEP-23
26-SEP-23
26-SEP-23
02-OCT-23
15-SEP-23
22-SEP-23
19-SEP-23
26-SEP-23
26-SEP-23
22-AUG-23
26-SEP-23
26-SEP-23
19-SEP-23
22-AUG-23
15-AUG-23
01-AUG-23
01-AUG-23
08-AUG-23
15-AUG-23
08-AUG-23
25-JUL-23
26-SEP-23
22-SEP-23
01-OCT-23
20-SEP-23

12.87 48.18

37.99 103.77

71.76 140.28

51.95 55.82

55.82 62.18

62.18 162.91

33.97 25.26

78.62 78.91

48.18 48.18

48.18 14.61

14.61 14.61

48.18 14.61
365.58

97.99 666.67
192.35
TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:
1,699.21

97.99 666.67
192.35
259663
259694
259712
259711
259713
259738
259768
259783
259813
259307
259632
259633
259890
259662
259555
259554
259422
259421
259419
259424
259425
259426
259420
259423
259557
259098
259372
259037
Attachment 5, Vendor ePayables
#6..
- 332 -
Bank: BMO Main BMO
Branch
Branch: BMO E-Payables
(Main)
Account:

CHECK
NUMBER
VENDOR

NAME SITE INVOICE NUMBER

INVOICE
DATE

PAYMENT
AMOUNT
** CITY OF MODESTO **
REPORT ID: COMAPCHKREG.rdf PAYMENT CHECK REGISTER
09-NOV-23 Page: 31
PO
NUMBER
815798
815799
815800
815801
815802
815803

BARNES WELDING
SUPPLY

BONANDER TRUCK &

TRAILER

BRADY IFS (FKA

CENTRAL SANITARY

SUPPLY)

CHOICE LIGHTING

SUPPLY CORP

CLARK PEST

CONTROL
DITTOS
1623412
13041PJ
8318885
8153863
8308554
8309050
8325432
8320981
8331831
8139639
8135881
8333089
8335243
8295362
8346681
8348807
8350419
8354362
347683
34102587
199947
199890
200112
200204
200000
199452
200006
15-SEP-23
21-SEP-23
19-SEP-23
06-JUL-23
14-SEP-23
14-SEP-23
21-SEP-23
20-SEP-23
25-SEP-23
28-JUN-23
27-JUN-23
25-SEP-23
26-SEP-23
08-SEP-23
17-OCT-23
02-OCT-23
02-OCT-23
04-OCT-23
12-SEP-23
07-SEP-23
20-SEP-23
13-SEP-23
20-SEP-23
22-SEP-23
19-SEP-23
31-AUG-23
20-SEP-23
1,834.90
16,975.83

84.25 43.51
-43.51

36.14 262.22
525.52

19.53 168.80
185.86
466.87

39.90 43.29
302.52
179.50
236.22

18.22 326.41
200.00
272.13

21.78 54.43

98.58 144.80
232.99
765.94
TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:
18,810.73
2,568.84
326.41
200.00
258596
257191
256430
250249
250249
258837
257816
258897
259104
258987
258987
258166
256823
259478
258527
258474
258669
254708
258553
258975
258418
258720
258891
259263
258200
258929
258934
Attachment 5, Vendor ePayables
#6..
- 333 -
Bank: BMO Main BMO
Branch
Branch: BMO E-Payables
(Main)
Account:

CHECK
NUMBER
VENDOR

NAME SITE INVOICE NUMBER

INVOICE
DATE

PAYMENT
AMOUNT
** CITY OF MODESTO **
REPORT ID: COMAPCHKREG.rdf PAYMENT CHECK REGISTER
09-NOV-23 Page: 32
PO
NUMBER
815803
815804
815805
815806
815807
815808
815809
815810
DITTOS

DOUBLE TREE BY

HILTON MODESTO

FIRST CHOICE

INDUSTRIAL SUPPLY

COMPANY

GOLDEN STATE

EMERGENCY VEHICLE

SERVICE

GREEN RUBBER

KENNEDY AG LLP

HARTLEY AND

ASSOCIATES

HERC RENTALS

HERITAGE FORD INC
80221-1
096059
C1041330
C1041332
M-500148
M-499885
M-499587
M-494094
M-499886
M-500952
M-494586
M-496554
M-500136
M-500545
M-500016
1785A245
33835384-002
6318572
5234622
5234236
63173211
63125491
63175192
5236459
14-SEP-23
12-SEP-23
22-SEP-23
22-SEP-23
18-SEP-23
12-SEP-23
05-SEP-23
03-MAY-23
12-SEP-23
05-OCT-23
15-MAY-23
29-JUN-23
18-SEP-23
27-SEP-23
14-SEP-23
16-APR-23
28-AUG-23
18-SEP-23
04-AUG-23
26-JUL-23
22-AUG-23
18-MAY-23
25-AUG-23
18-SEP-23
148.77
263.75
406.46
130.55
336.66
1,041.82
100.13
989.08
919.66
161.16

39.22 125.84
216.36
271.58
675.55
556.80
3,182.20
185.00
106.25
-206.59

87.50 1,989.02
350.00
371.17
TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:
1,590.65
148.77
263.75
537.01
4,877.06
556.80
3,182.20
N/A
258089
258802
258802
258862
258746
259177
258877
259030
259775
258752
258752
259212
259463
259036
259755
258747
259226
259178
250997
258403
258393
258393
258796
Attachment 5, Vendor ePayables
#6..
- 334 -
Bank: BMO Main BMO
Branch
Branch: BMO E-Payables
(Main)
Account:

CHECK
NUMBER
VENDOR

NAME SITE INVOICE NUMBER

INVOICE
DATE

PAYMENT
AMOUNT
** CITY OF MODESTO **
REPORT ID: COMAPCHKREG.rdf PAYMENT CHECK REGISTER
09-NOV-23 Page: 33
PO
NUMBER
815810
815811
815812
815813
815814
815815
815816

HERITAGE FORD INC

IMAGE UNIFORMS

INTERSTATE TRUCK
CENTER

JORGENSEN AND CO

KELLY-MOORE PAINT

COMPANY INC

MODESTO STEEL

PACE SUPPLY

CORPORATION
6316770-1
5235361
5235388
5236551
5236158
5236049
5235415
5235812
5234831
5232757
143750
143749
02P465879
2P464717
2P461861
2P467631
608482
6093151
6087299
6089621
6093158
304-00000875336
415510
58946272
10-AUG-23
23-AUG-23
23-AUG-23
20-SEP-23
12-SEP-23
08-SEP-23
24-AUG-23
01-SEP-23
10-AUG-23
16-JUN-23
09-AUG-23
09-AUG-23
08-SEP-23
31-AUG-23
17-AUG-23
19-SEP-23
29-AUG-23
04-OCT-23
31-AUG-23
18-SEP-23
04-OCT-23
07-SEP-23
07-SEP-23
02-OCT-23
175.00
207.84
-169.66
134.18
224.12
225.37
257.92

50.17 262.93
-435.50
563.46
506.79
150.57
257.26
519.48
104.83
649.02
-649.02
303.76
255.00
655.43

52.75 54.48

45.95 TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:
3,814.72
1,070.25
1,032.14
1,214.19

52.75 54.48

45.95 259154
259179
259179
258908
258908
258908
259178
259178
259178
250997
259105
259106
258425
259055
259047
259065
259100
259100
259309
259210
259110
258550
258932
258618
Attachment 5, Vendor ePayables
#6..
- 335 -
Bank: BMO Main BMO
Branch
Branch: BMO E-Payables
(Main)
Account:

CHECK
NUMBER
VENDOR

NAME SITE INVOICE NUMBER

INVOICE
DATE

PAYMENT
AMOUNT
** CITY OF MODESTO **
REPORT ID: COMAPCHKREG.rdf PAYMENT CHECK REGISTER
09-NOV-23 Page: 34
PO
NUMBER
815817
815818
815819
815820
815821
815822

PACIFIC GAS AND

ELECTRIC

PACIFIC STORAGE

COMPANY

PAPE MACHINERY

SAFE-T-LITE OF

MODESTO INC

WESTURF NURSERY

ALPHA ANALYTICAL

LABORATORIES
449700321-2-
SEP-23
5177219
2214013
2214035
5177095
5177096
2214021
2214033
2214023
2214029
5177216
5177213
5177214
5177215
2214020
2214027
5173228
14734988
393392
393666
393350
926288
3103374-
CVR_MODDW
3103375-
CVR_MODDW
3103539-
21-SEP-23
29-SEP-23
30-SEP-23
30-SEP-23
29-SEP-23
29-SEP-23
30-SEP-23
30-SEP-23
30-SEP-23
30-SEP-23
29-SEP-23
29-SEP-23
29-SEP-23
29-SEP-23
30-SEP-23
30-SEP-23
31-AUG-23
29-AUG-23
21-SEP-23
03-OCT-23
19-SEP-23
10-OCT-23
05-OCT-23
05-OCT-23
05-OCT-23
12,595.03

72.00 226.95

48.00 172.34

63.42 9.60
153.72

55.60 47.60

72.00 470.00
204.00
108.00

1.60 203.00

72.00 769.79
173.62
294.83
410.18
129.53

60.00 120.00

80.00 TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:
12,595.03
1,979.83
769.79
878.63
129.53
N/A
259822
259454
259754
259753
259752
259616
259514
259474
259468
259453
259472
259472
259472
259466
259456
259823
259173
258940
258892
259141
259810
259548
259548
259548
Attachment 5, Vendor ePayables
#6..
- 336 -
Bank: BMO Main BMO
Branch
Branch: BMO E-Payables
(Main)
Account:

CHECK
NUMBER
VENDOR

NAME SITE INVOICE NUMBER

INVOICE
DATE

PAYMENT
AMOUNT
** CITY OF MODESTO **
REPORT ID: COMAPCHKREG.rdf PAYMENT CHECK REGISTER
09-NOV-23 Page: 35
PO
NUMBER
815822 ALPHA ANALYTICAL

LABORATORIES
CVR_MODDW
3103541-
CVR_MODDW
3102960-
CVR_MODDW
3102962-
CVR_MODDW
3102963-
CVR_MODDW
3102964-
CVR_MODDW
3102975-
CVR_MODDW
3102976-
CVR_MODDW
3102978-
CVR_MODDW
3086463-
CVR_MODWW
3094460-
CVR_MODDW
3094461-
CVR_MODDW
3094463-
CVR_MODDW
3094464-
CVR_MODDW
3094466-
CVR_MODDW
3094520-
CVR_MODDW
3094522-
CVR_MODDW
3094574-
CVR_MODDW
3094462-
CVR_MODDW
3094600-
CVR_MODDW
3094610-
CVR_MODDW
05-OCT-23
03-OCT-23
03-OCT-23
03-OCT-23
03-OCT-23
03-OCT-23
03-OCT-23
03-OCT-23
28-SEP-23
19-SEP-23
19-SEP-23
19-SEP-23
19-SEP-23
19-SEP-23
19-SEP-23
19-SEP-23
19-SEP-23
19-SEP-23
19-SEP-23
19-SEP-23
248.00
182.00
182.00
112.00

50.00 42.00

42.00 84.00
9,615.00

40.00 140.00
120.00

60.00 60.00

60.00 45.00
700.00

40.00 60.00

40.00 259548
259547
259547
259547
259547
259547
259547
259547
258785
259243
259243
259243
259243
259243
259243
259243
259243
259243
259244
259244
Attachment 5, Vendor ePayables
#6..
- 337 -
Bank: BMO Main BMO
Branch
Branch: BMO E-Payables
(Main)
Account:

CHECK
NUMBER
VENDOR

NAME SITE INVOICE NUMBER

INVOICE
DATE

PAYMENT
AMOUNT
** CITY OF MODESTO **
REPORT ID: COMAPCHKREG.rdf PAYMENT CHECK REGISTER
09-NOV-23 Page: 36
PO
NUMBER
815822 ALPHA ANALYTICAL

LABORATORIES
3094662-
CVR_MODDW
3094663-
CVR_MODDW
3094665-
CVR_MODDW
3094684-
CVR_MODDW
3094685-
CVR_MODDW
3094686-
CVR_MODDW
3094687-
CVR_MODDW
3094708-
CVR_MODDW
3094743-
CVR_MODDW
3094889-
CVR_MODDW
3095222-
CVR_MODDW
3095245-
CVR_MODDW
3095281-
CVR_MODDW
3095282-
CVR_MODDW
3095287-
CVR_MODDW
3095298-
CVR_MODDW
3095309-
CVR_MODDW
3095329-
CVR_MODDW
3095485-
CVR_MODDW
3095530-
CVR_MODDW
3095539-
CVR_MODDW
19-SEP-23
19-SEP-23
19-SEP-23
19-SEP-23
19-SEP-23
19-SEP-23
19-SEP-23
19-SEP-23
19-SEP-23
20-SEP-23
22-SEP-23
22-SEP-23
22-SEP-23
22-SEP-23
22-SEP-23
22-SEP-23
22-SEP-23
22-SEP-23
25-SEP-23
25-SEP-23
25-SEP-23

56.00 42.00

56.00 28.00

42.00 42.00

84.00 286.00

20.00 306.00
290.00
194.00
140.00

84.00 210.00

84.00 480.00
960.00
192.00

40.00 80.00
259244
259244
259244
259244
259244
259244
259244
259245
259245
259245
259245
259245
259245
259245
259245
259245
259257
259257
259257
259257
259257
Attachment 5, Vendor ePayables
#6..
- 338 -
Bank: BMO Main BMO
Branch
Branch: BMO E-Payables
(Main)
Account:

CHECK
NUMBER
VENDOR

NAME SITE INVOICE NUMBER

INVOICE
DATE

PAYMENT
AMOUNT
** CITY OF MODESTO **
REPORT ID: COMAPCHKREG.rdf PAYMENT CHECK REGISTER
09-NOV-23 Page: 37
PO
NUMBER
815822 ALPHA ANALYTICAL

LABORATORIES
3095540-
CVR_MODDW
3095566-
CVR_MODDW
3095567-
CVR_MODDW
3095679-
CVR_MODDW
3095680-
CVR_MODDW
3095681-
CVR_MODDW
3095690-
CVR_MODDW
3095691-
CVR_MODDW
3095693-
CVR_MODDW
3095694-
CVR_MODDW
3095695-
CVR_MODDW
3095696-
CVR_MODDW
3095829-
CVR_MODDW
3096155-
CVR_MODDW
3095985-
CVR_MODDW
3095986-
CVR_MODDW
3095987-
CVR_MODDW
3095988-
CVR_MODDW
3095990-
CVR_MODDW
3095995-
CVR_MODDW
3103187-
CVR_MODDW
25-SEP-23
25-SEP-23
25-SEP-23
26-SEP-23
26-SEP-23
26-SEP-23
26-SEP-23
26-SEP-23
26-SEP-23
26-SEP-23
26-SEP-23
26-SEP-23
26-SEP-23
28-SEP-23
27-SEP-23
27-SEP-23
27-SEP-23
27-SEP-23
27-SEP-23
27-SEP-23
04-OCT-23

80.00 1,045.00
290.00
158.00
168.00
126.00

28.00 28.00

70.00 42.00

46.00 84.00
100.00
275.00

28.00 14.00

84.00 70.00
138.00

56.00 440.00
259257
259257
259257
259246
259246
259246
259246
259246
259246
259246
259246
259246
259527
259527
259527
259527
259527
259527
259527
259527
259546
Attachment 5, Vendor ePayables
#6..
- 339 -
Bank: BMO Main BMO
Branch
Branch: BMO E-Payables
(Main)
Account:

CHECK
NUMBER
VENDOR

NAME SITE INVOICE NUMBER

INVOICE
DATE

PAYMENT
AMOUNT
** CITY OF MODESTO **
REPORT ID: COMAPCHKREG.rdf PAYMENT CHECK REGISTER
09-NOV-23 Page: 38
PO
NUMBER
815822 ALPHA ANALYTICAL

LABORATORIES
3103093-
CVR_MODDW
3103119-
CVR_MODDW
3103151-
CVR_MODDW
3103181-
CVR_MODDW
3103186-
CVR_MODDW
3103086-
CVR_MODDW
3103845-
CVR_MODDW
3103846-
CVR_MODDW
3103653-
CVR_MODDW
3103904-
CVR_MODDW
3103815-
CVR_MODDW
3103838-
CVR_MODDW
3103847-
CVR_MODDW
3103842-
CVR_MODDW
3103843-
CVR_MODDW
3103829-
CVR_MODDW
3103844-
CVR_MODDW
3092727-
CVR_MODWW
3092853-
CVR_MODWW
3085784-
CVR_MODWW
3086002-
CVR_MODWW
03-OCT-23
03-OCT-23
03-OCT-23
04-OCT-23
04-OCT-23
03-OCT-23
09-OCT-23
09-OCT-23
06-OCT-23
09-OCT-23
09-OCT-23
09-OCT-23
09-OCT-23
09-OCT-23
09-OCT-23
09-OCT-23
09-OCT-23
05-SEP-23
06-SEP-23
23-AUG-23
24-AUG-23
286.00
540.00

60.00 80.00
825.00

20.00 98.00
210.00
100.00

98.00 255.00

14.00 28.00

28.00 42.00
930.00

84.00 3,815.00
162.00
4,486.00
4,491.00
259546
259546
259546
259546
259546
259546
259956
259956
259956
259956
259955
259955
259955
259955
259955
259955
259955
258778
258777
258783
258782
Attachment 5, Vendor ePayables
#6..
- 340 -
Bank: BMO Main BMO
Branch
Branch: BMO E-Payables
(Main)
Account:

CHECK
NUMBER
VENDOR

NAME SITE INVOICE NUMBER

INVOICE
DATE

PAYMENT
AMOUNT
** CITY OF MODESTO **
REPORT ID: COMAPCHKREG.rdf PAYMENT CHECK REGISTER
09-NOV-23 Page: 39
PO
NUMBER
815822
815823
815824
815825

ALPHA ANALYTICAL

LABORATORIES

AMERICAN CHILLER
CO

AMERICAN LUMBER
CO

ARAMARK UNIFORM

SERVICE
3086003-
CVR_MODWW
3096298-
CVR_MODDW
3102852-
CVR_MODDW
3102886-
CVR_MODDW
3102941-
CVR_MODDW
3102945-
CVR_MODDW
3102959-
CVR_MODDW
3092702-
CVR_MODWW
3103344-
CVR_MODDW
3103273-
CVR_MODDW
3103274-
CVR_MODDW
3103277-
CVR_MODDW
3103345-
CVR_MODDW
69955
7511
7481
7967
7925
7865
6912
5040194820
24-AUG-23
29-SEP-23
02-OCT-23
03-OCT-23
03-OCT-23
03-OCT-23
03-OCT-23
05-SEP-23
04-OCT-23
04-OCT-23
04-OCT-23
04-OCT-23
04-OCT-23
05-SEP-23
28-SEP-23
28-SEP-23
12-OCT-23
11-OCT-23
10-OCT-23
12-SEP-23
12-SEP-23
4,486.00

20.00 255.00
220.00
1,650.00
1,080.00

14.00 3,334.00

20.00 126.00

98.00 14.00
170.00
4,668.00
446.72
521.05
110.86
235.95
196.64

15.23 40.18
TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:
47,407.00
4,668.00
1,526.45
258786
259707
259707
259707
259707
259707
259707
258787
259548
259548
259548
259548
259548
259968
259624
259313
260098
260011
260010
259923
259773
Attachment 5, Vendor ePayables
#6..
- 341 -
Bank: BMO Main BMO
Branch
Branch: BMO E-Payables
(Main)
Account:

CHECK
NUMBER
VENDOR

NAME SITE INVOICE NUMBER

INVOICE
DATE

PAYMENT
AMOUNT
** CITY OF MODESTO **
REPORT ID: COMAPCHKREG.rdf PAYMENT CHECK REGISTER
09-NOV-23 Page: 40
PO
NUMBER
815825 ARAMARK UNIFORM

SERVICE
5040194821
5040194819
5040198218
5040198220
5040203228
5040206524
5040209868
5040209864
5040209885
5040209881
5040209887
5040209886
5040209857
5040209884
5040209883
5040209880
5040209882
5040209862
5040208352
5040207656
5040189504
5040208351
5040208350
5040208369
5040174092
5040184545
5040177648
5040181093
5040184544
5040198228
5040201713
5040205096
5040205089
5040201700
12-SEP-23
12-SEP-23
19-SEP-23
19-SEP-23
28-SEP-23
05-OCT-23
12-OCT-23
12-OCT-23
12-OCT-23
12-OCT-23
12-OCT-23
12-OCT-23
12-OCT-23
12-OCT-23
12-OCT-23
12-OCT-23
12-OCT-23
12-OCT-23
10-OCT-23
09-OCT-23
31-AUG-23
10-OCT-23
10-OCT-23
10-OCT-23
01-AUG-23
22-AUG-23
08-AUG-23
15-AUG-23
22-AUG-23
19-SEP-23
26-SEP-23
03-OCT-23
03-OCT-23
26-SEP-23

43.00 117.32
119.19

43.00 25.45

25.45 31.00

21.00 21.00

23.50 31.75

21.00 22.25

34.75 25.25

30.25 21.50

21.00 141.16
103.77

21.00 74.22

31.90 33.97
140.05

14.61 141.31
142.03
140.27

26.81 26.81

94.75 169.63
167.45
259853
259788
259791
259854
260260
260258
260267
260270
260269
260268
260273
260271
260272
260274
260275
260276
260277
260278
260318
260324
260285
260326
260325
260370
259926
259929
259927
259928
259930
259948
259947
259921
260008
260034
Attachment 5, Vendor ePayables
#6..
- 342 -
Bank: BMO Main BMO
Branch
Branch: BMO E-Payables
(Main)
Account:

CHECK
NUMBER
VENDOR

NAME SITE INVOICE NUMBER

INVOICE
DATE

PAYMENT
AMOUNT
** CITY OF MODESTO **
REPORT ID: COMAPCHKREG.rdf PAYMENT CHECK REGISTER
09-NOV-23 Page: 41
PO
NUMBER
815825 ARAMARK UNIFORM

SERVICE
5040114073
5040143022
5040201699
5040205088
5040205091
5040206533
5040206545
5040206544
5040206547
5040206548
5040206529
5040206527
5040206546
5040206542
5040206543
5040206541
5040206522
5040199778
5040205087
5040204309
5040205104
5040181102
5040136077
5040208348
5040205083
5040208349
5040208371
5040205106
5040205105
5040207658
5040208372
5040205107
5040208370
5040205086
21-MAR-23
30-MAY-23
26-SEP-23
03-OCT-23
03-OCT-23
05-OCT-23
05-OCT-23
05-OCT-23
05-OCT-23
05-OCT-23
05-OCT-23
05-OCT-23
05-OCT-23
05-OCT-23
05-OCT-23
05-OCT-23
05-OCT-23
21-SEP-23
03-OCT-23
02-OCT-23
03-OCT-23
15-AUG-23
16-MAY-23
10-OCT-23
03-OCT-23
10-OCT-23
10-OCT-23
03-OCT-23
03-OCT-23
09-OCT-23
10-OCT-23
03-OCT-23
10-OCT-23
03-OCT-23

9.24 37.19

26.76 26.76

33.91 31.00

34.75 25.25

21.00 31.75

21.00 21.00

21.00 23.50

21.50 30.25

22.25 25.45
143.24

25.74 33.97

15.70 15.70

12.87 12.87

25.26 34.75

34.75 79.12

51.95 8.70

8.70 79.68

74.22 259950
259949
260035
260005
260050
259980
259981
259982
259983
259984
259985
259987
259986
259988
259989
259995
259996
260002
260089
260097
260036
259784
259784
260381
260382
260393
260462
260464
260465
260467
260463
260466
260468
260126
Attachment 5, Vendor ePayables
#6..
- 343 -
Bank: BMO Main BMO
Branch
Branch: BMO E-Payables
(Main)
Account:

CHECK
NUMBER
VENDOR

NAME SITE INVOICE NUMBER

INVOICE
DATE

PAYMENT
AMOUNT
** CITY OF MODESTO **
REPORT ID: COMAPCHKREG.rdf PAYMENT CHECK REGISTER
09-NOV-23 Page: 42
PO
NUMBER
815825
815826
815827
815828
815829
815830
815831

ARAMARK UNIFORM

SERVICE

AT&T MOBILITY

AT&T MOBILITY

AT&T MOBILITY

B I C SECURITY

SYSTEMS

BARNES WELDING
SUPPLY

BRADY IFS (FKA

CENTRAL SANITARY

SUPPLY)
5040204317
5040205085
5040205084
5040198219
991831673X08222
023
991831673X07222
023
991831673X09222
023
208619
208145
208929
91630055
91630058
91630056
63253070
8344380
8347536
8347551
8350405
8360096
8315146
6834183
8361585
8361588
02-OCT-23
03-OCT-23
03-OCT-23
19-SEP-23
14-AUG-23
17-OCT-23
14-SEP-23
01-OCT-23
01-OCT-23
01-OCT-23
30-SEP-23
30-SEP-23
30-SEP-23
20-SEP-23
29-SEP-23
29-SEP-23
29-SEP-23
02-OCT-23
05-OCT-23
18-SEP-23
27-SEP-23
06-OCT-23
06-OCT-23
103.77

37.99 25.26

37.16 4,019.23
3,964.77
4,211.88

46.00 86.30

36.00 165.81

41.88 24.18
437.04
1,557.79
-113.98
110.79
-139.65
224.86

3.98 563.49

24.61 81.63
TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:
3,512.54
4,019.23
3,964.77
4,211.88
168.30
668.91
260127
260128
260140
259774
N/A
N/A
N/A
259431
259814
259826
260037
259725
259724
259459
258474
258474
258474
258474
257192
260081
259148
258669
249382
Attachment 5, Vendor ePayables
#6..
- 344 -
Bank: BMO Main BMO
Branch
Branch: BMO E-Payables
(Main)
Account:

CHECK
NUMBER
VENDOR

NAME SITE INVOICE NUMBER

INVOICE
DATE

PAYMENT
AMOUNT
** CITY OF MODESTO **
REPORT ID: COMAPCHKREG.rdf PAYMENT CHECK REGISTER
09-NOV-23 Page: 43
PO
NUMBER
815831
815832
815833
815834
815835
815836
815837

BRADY IFS (FKA

CENTRAL SANITARY

SUPPLY)

BSK ANALYTICAL

LABORATORIES

CAPITAL RUBBER

CHOICE LIGHTING

SUPPLY CORP

CLARK PEST

CONTROL

CURTIS BLUE LINE
(FKA L N CURTIS AND
SO
DITTOS
8334978
6822135
103874
161547
347915
348235
347975
348028
347927
348021
347913
138
133
137
742839
INV714608
753541
751413
751835
200391
200519
200369
199974
199722
200215
26-SEP-23
22-SEP-23
30-SEP-23
27-SEP-23
25-SEP-23
09-OCT-23
27-SEP-23
28-SEP-23
25-SEP-23
28-SEP-23
25-SEP-23
23-SEP-23
01-JUL-23
01-SEP-23
31-AUG-23
14-JUN-23
06-OCT-23
29-SEP-23
29-SEP-23
29-SEP-23
06-OCT-23
28-SEP-23
27-SEP-23
14-SEP-23
28-SEP-23

36.15 312.02
870.00
302.13

14.10 67.39
1,001.00

12.85 261.14

44.48 87.05
545.00
545.00
1,595.00
317.52
3,902.08
1,553.19
615.29
760.50

32.42 54.43
865.56
175.07
108.85
315.85
TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:
2,661.69
870.00
302.13
1,488.01
2,685.00
7,148.58
260082
259147
238714
258334
260001
260099
259360
259611
259362
259362
259362
259944
259945
259943
256362
260004
260257
259976
259977
260218
260152
259486
259888
259617
259781
Attachment 5, Vendor ePayables
#6..
- 345 -
Bank: BMO Main BMO
Branch
Branch: BMO E-Payables
(Main)
Account:

CHECK
NUMBER
VENDOR

NAME SITE INVOICE NUMBER

INVOICE
DATE

PAYMENT
AMOUNT
** CITY OF MODESTO **
REPORT ID: COMAPCHKREG.rdf PAYMENT CHECK REGISTER
09-NOV-23 Page: 44
PO
NUMBER
815837
815838
815839
815840
815841
815842
815843
815844
815845
815846
DITTOS

FEDERAL SIGNAL

CORPORATION

FIRST CHOICE

INDUSTRIAL SUPPLY

COMPANY

FLORY INDUSTRIES
INC

GOLDEN STATE

EMERGENCY VEHICLE

SERVICE

GREEN RUBBER

KENNEDY AG LLP

HARD DRIVE

GRAPHICS

HARTLEY AND

ASSOCIATES

HERC RENTALS

IDN-WILCO
199052
8241327
95975-01
096262
473982
C1040968
C1040990
C1040997
C1040955
C1040998
M-500784
M-500241
M-496798
37906
37996
1778A250
34028882-001
10195397-00
10195398-00
31-AUG-23
08-FEB-23
05-OCT-23
21-SEP-23
04-OCT-23
31-AUG-23
01-SEP-23
02-SEP-23
30-AUG-23
02-SEP-23
03-OCT-23
20-SEP-23
06-JUL-23
30-MAR-23
13-OCT-23
16-SEP-23
13-SEP-23
27-JUN-23
28-JUN-23
647.66
9,924.50
116.50

54.22 498.62
832.82
2,367.09
615.46

41.19 92.29

81.01 83.08

74.42 478.96
217.70

31.26 81.66
550.37
115.00
TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:
2,199.84
9,924.50
170.72
498.62
3,948.85
238.51
696.66

31.26 81.66
665.37
258842
240877
257025
257923
259931
259182
259187
259187
259187
259187
260006
260106
260291
256689
259902
259551
257521
259674
259675
Attachment 5, Vendor ePayables
#6..
- 346 -
Bank: BMO Main BMO
Branch
Branch: BMO E-Payables
(Main)
Account:

CHECK
NUMBER
VENDOR

NAME SITE INVOICE NUMBER

INVOICE
DATE

PAYMENT
AMOUNT
** CITY OF MODESTO **
REPORT ID: COMAPCHKREG.rdf PAYMENT CHECK REGISTER
09-NOV-23 Page: 45
PO
NUMBER
815847
815848
815849
815850
815851
815852

INTERSTATE TRUCK
CENTER

JORGENSEN AND CO

KELLY-MOORE PAINT

COMPANY INC

MCCOY TRUCK TIRE

SERVICE CTR

MID CAL MOVING &

STORAGE CO

MODESTO STEEL
02P470004.02
02P470007
02P467801
02P464810
02P425330
02P453786
02P435668
02P464401
02P463453
02P464397
02P465021
02P464900
02P465813
02P464807
02P464885
02P447767
02P469566
02P465788
6093526
304-00000877483
304-00000876409
304-00000877600
10143208
12511
416112
416612
416630
28-SEP-23
28-SEP-23
18-SEP-23
05-SEP-23
01-FEB-23
06-JUL-23
28-MAR-23
30-AUG-23
25-AUG-23
30-AUG-23
01-SEP-23
01-SEP-23
07-SEP-23
31-AUG-23
23-OCT-23
02-JUN-23
26-SEP-23
08-SEP-23
06-OCT-23
02-OCT-23
19-SEP-23
03-OCT-23
18-JUL-23
01-OCT-23
14-SEP-23
20-SEP-23
20-SEP-23
2,787.91
3,023.07
234.56
1,230.85
-698.06
-203.39
-66.57
-203.39
-215.88
-203.39
-266.73
-201.52
-241.00
3,000.10
-533.44
161.12
111.02

82.31 138.27

16.18 19.79

48.97 2,824.31

60.00 71.09
199.12
959.94
TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:
7,797.57
138.27

84.94 2,824.31

60.00 259194
259193
259200
259200
242513
246734
243531
253741
255299
255308
258083
258244
258182
259198
259198
248436
259129
259200
260049
259635
259613
259778
260250
259434
258960
259973
259715
Attachment 5, Vendor ePayables
#6..
- 347 -
Bank: BMO Main BMO
Branch
Branch: BMO E-Payables
(Main)
Account:

CHECK
NUMBER
VENDOR

NAME SITE INVOICE NUMBER

INVOICE
DATE

PAYMENT
AMOUNT
** CITY OF MODESTO **
REPORT ID: COMAPCHKREG.rdf PAYMENT CHECK REGISTER
09-NOV-23 Page: 46
PO
NUMBER
815852
815853
815854
815855
815856
815857
815858
815859

MODESTO STEEL

NEC CORPORATION

OF AMERICA

PACE SUPPLY

CORPORATION

PACIFIC BOLT

COMPANY INC

PACIFIC STORAGE

COMPANY

SAFE-T-LITE OF

MODESTO INC

SITEONE LANDSCAPE
SUPPLY

WESTURF NURSERY
93087768
58946606
58977558
58948567
M87173
2214034
2214019
2214031
2214017
5169082
2214025
393855
393826
393822
393714
393697
133985843-001
134032580-001
133894637-001
133841080-001
135465770-001
133989920-001
922347
904185
05-SEP-23
11-OCT-23
12-OCT-23
11-OCT-23
03-OCT-23
30-SEP-23
30-SEP-23
30-SEP-23
30-SEP-23
31-JUL-23
30-SEP-23
11-OCT-23
10-OCT-23
10-OCT-23
04-OCT-23
03-OCT-23
29-AUG-23
30-AUG-23
26-AUG-23
24-AUG-23
11-OCT-23
29-AUG-23
12-SEP-23
01-AUG-23
6,798.00
173.24
858.44
176.01

25.30 171.80

99.77 80.16
122.43

36.00 50.00
928.75

92.91 673.56
231.19

85.64 76.28
-76.28
-76.28
-76.28

20.38 152.56

4.79 149.38
TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:

TOTAL FOR CHECK:
1,230.15
6,798.00
1,207.69

25.30 560.16
2,012.05

20.38 256883
258644
258985
258721
260046
259889
260158
259772
259843
260262
260380
259096
259606
260012
260009
259910
258954
258954
258942
258942
259936
258942
259660
259559
Attachment 5, Vendor ePayables
#6..
- 348 -
Bank: BMO Main BMO
Branch
Branch: BMO E-Payables
(Main)
Account:

CHECK
NUMBER
VENDOR

NAME SITE INVOICE NUMBER

INVOICE
DATE

PAYMENT
AMOUNT
** CITY OF MODESTO **
REPORT ID: COMAPCHKREG.rdf PAYMENT CHECK REGISTER
09-NOV-23 Page: 47
PO
NUMBER
Total: 1135 420,059.54
815859 WESTURF NURSERY 923538 22-SEP-23 151.07
TOTAL FOR CHECK: 305.24
260406
Attachment 5, Vendor ePayables
#6..
- 349 -
1/1/1900 Attachment 6 - Vendor Wire - October 2023
1/1/1900 1,000.00
DATE Vendor Amount
10/2/2023 MissionSquare ICMA 457 (PPE 9/25/23) 220,027.20 10/2/2023 MissionSquare ICMA RHS (PPE 9/25/23) 36,675.00 10/2/2023 MissionSquare ICMA IRA (PPE 9/25/23) 5,065.33 10/12/2023 ExpertPay (PPE 10/9/23) 6,629.42
10/13/2023 MissionSquare ICMA IRA (PPE 10/9/23) 5,065.33 10/13/2023 MissionSquare ICMA RHS (PPE 10/9/23) 34,375.00 10/13/2023 MissionSquare ICMA 457 (PPE 10/9/23) 219,925.37 10/13/2023 MissionSquare ICMA 401 (PPE 10/9/23) 13,297.76 10/13/2023 Federal Payroll Taxes & Medicare (PPE 10/9/23) 583,156.63 10/13/2023 State Federal Taxes (PPE 10/9/23) 190,599.29 10/13/2023 State Disability Insurance (PPE 10/9/23) 21,824.70 10/16/2023 Charles Schwab (PPE 10/9/23) 32,537.50
10/16/2023 Optum Bank (PPE 10/9/23) 14,599.00
10/17/2023 CalPers (PPE 10/9/23) 1,067,088.34
10/26/2023 Optum Bank (PPE 10/23/23) 15,517.03
10/26/2023 Charles Schwab (PPE 10/23/23) 32,537.50
10/26/2023 MissionSquare ICMA RHS (PPE 10/23/23) 35,575.00 10/26/2023 MissionSquare ICMA 401 (PPE 10/23/23) 13,308.86 10/26/2023 MissionSquare ICMA IRA (PPE 10/23/23) 5,015.33 10/26/2023 MissionSquare ICMA 457 (PPE 10/23/23) 239,809.14 10/26/2023 ExpertPay (PPE 10/23/23) 6,540.40
10/27/2023 Federal Payroll Taxes & Medicare (PPE 10/23/23) 609,384.67 10/27/2023 State Payroll Taxes (PPE 10/23/23) 199,410.59 10/27/2023 State Disability Insurance (PPE 10/23/23) 22,243.17 3,630,207.56
#6..
- 350 -
11/9/23, 10:19 AM comprodapp122.modesto.prv:8000/OA_CGI/FNDWRR.exe?temp_id=1967102769 comprodapp122.modesto.prv:8000/OA_CGI/FNDWRR.exe?temp_id=1967102769 1/5 CoM PRIMARY Report Date: 09-NOV-2023 10:19
Void Payment Register Page: 1
Include Zero Amount Payments: No Period From: 01-OCT-23 To: 31-OCT-23 Display Payee Address: Yes Date: Void Date
Bank: BMO Branch: BMO Main Branch Account: BMO Main Account AP Checks Bank Account Currency: USD Payment Currency: USD ( US Dollar ) Payment Number Date Payee Name Site Address Payment Amount Void Date --------------- --------- --------------------------- --------------- --------------------------------- ----------------- --------- Payment Document: CoM AP BoTW Check
584649 08-SEP-23 NEARMAP US INC MAIN 10897 SOUTH RIVER FRONT PARKWAY 28,840.00 22-OCT-23 SUITE 150
SOUTH JORDAN, UT 84095
United States
584728 15-SEP-23 Mertz, Jacob (Jake) OFFICE 1,080.85 05-OCT-23 584803 15-SEP-23 CENTER FOR CRIMINAL JUSTICE MAIN 6300 EAST SIDE UNIVERSITY DRIVE 375.00 26-OCT-23 LONG BEACH, CA 90815
United States
584968 22-SEP-23 Weaver, Ashley N OFFICE 562.00 06-OCT-23 585232 22-SEP-23 VERIZON MAIN3 P O BOX 15062 37.67 05-OCT-23 ALBANY, NY 12212
United States
585278 29-SEP-23 CoM PRN MODESTO 1010 10th STREET 838.00 05-OCT-23 MODESTO, CA 95354
United States
585361 29-SEP-23 CENTRAL VALLEY UMPIRE ASSOC MAIN3 1718 SYLVAN WAY APT. 1103 1,400.00 26-OCT-23 LODI, CA 95242
United States
585404 29-SEP-23 HICKS JENNIFER L MAIN 2413 COUNTS COURT 669.23 13-OCT-23 MODESTO, CA 95355
United States
585836 06-OCT-23 BERTOLOTTI MODESTO DISPOSAL MAIN P O BOX 157 18,044.51 26-OCT-23 CERES, CA 95307
United States
585861 06-OCT-23 CENTRAL VALLEY UMPIRE ASSOC MAIN3 1718 SYLVAN WAY APT. 1103 1,330.00 26-OCT-23 LODI, CA 95242
United States
585888 06-OCT-23 GILTON SOLID WASTE MAIN 755 S YOSEMITE AVE 249,959.68 26-OCT-23 OAKDALE, CA 95361
United States
586328 13-OCT-23 WATER RESOURCES CTRL BRD MAIN PO BOX 1888 230.00 19-OCT-23

ST OF CA
SACRAMENTO, CA 95812
Attachment 7, Voided Checks
#6..
- 351 -
11/9/23, 10:19 AM comprodapp122.modesto.prv:8000/OA_CGI/FNDWRR.exe?temp_id=1967102769 comprodapp122.modesto.prv:8000/OA_CGI/FNDWRR.exe?temp_id=1967102769 2/5 United States
-----------------
Payment Document Subtotal 303,366.94
-----------------
Bank Account Subtotal 303,366.94
CoM PRIMARY Report Date: 09-NOV-2023 10:19
Void Payment Register Page: 2
Include Zero Amount Payments: No Period From: 01-OCT-23 To: 31-OCT-23 Display Payee Address: Yes Date: Void Date
Bank: BMO Branch: BMO Main Branch Account: BoTW Main Acount AP Checks Bank Account Currency: USD Payment Currency: USD ( US Dollar ) Payment Number Date Payee Name Site Address Payment Amount Void Date --------------- --------- --------------------------- --------------- --------------------------------- ----------------- --------- Payment Document: CoM AP BoTW Check
574739 03-FEB-23 Payne, Felton R Jr OFFICE 0.02 26-OCT-23 574750 03-FEB-23 CoM Misc MODESTO 1010, 10th Street 75.54 26-OCT-23 Modesto, CA 95354
United States
574880 03-FEB-23 MODESTO POLICE ATHLETIC LEA MAIN 600 10TH STREET 196.00 26-OCT-23 MODESTO, CA 95354
United States
575002 10-FEB-23 COM HDL MODESTO 1010 10TH STREET 100.00 26-OCT-23 MODESTO, CA 95354
United States
575013 10-FEB-23 COM HDL MODESTO 1010 10TH STREET 100.00 26-OCT-23 MODESTO, CA 95354
United States
575030 10-FEB-23 COM HDL MODESTO 1010 10TH STREET 100.00 26-OCT-23 MODESTO, CA 95354
United States
575032 10-FEB-23 COM HDL MODESTO 1010 10TH STREET 100.00 26-OCT-23 MODESTO, CA 95354
United States
575052 10-FEB-23 COM HDL MODESTO 1010 10TH STREET 100.00 26-OCT-23 MODESTO, CA 95354
United States
575234 17-FEB-23 CoM Misc MODESTO 1010, 10th Street 1.00 26-OCT-23 Modesto, CA 95354
United States
575255 17-FEB-23 CoM Misc MODESTO 1010, 10th Street 57.00 26-OCT-23 Modesto, CA 95354
Attachment 7, Voided Checks
#6..
- 352 -
11/9/23, 10:19 AM comprodapp122.modesto.prv:8000/OA_CGI/FNDWRR.exe?temp_id=1967102769 comprodapp122.modesto.prv:8000/OA_CGI/FNDWRR.exe?temp_id=1967102769 3/5 United States
575280 17-FEB-23 CoM Utilities MODESTO 1010, 10th Street 35.94 26-OCT-23 Modesto, CA 95354
United States
575424 17-FEB-23 MODESTO POLICE ATHLETIC LEA MAIN 600 10TH STREET 196.00 26-OCT-23 MODESTO, CA 95354
United States
575444 17-FEB-23 OPERATING ENGINEERS FEDERAL MAIN CREDIT UNION 250.00 26-OCT-23 PO BOX 5073
LIVERMORE, CA 94551
United States
575642 24-FEB-23 Heimeyer, Logan Kyle OFFICE 193.05 26-OCT-23 575648 24-FEB-23 Miller, Alexandria Lauren ( OFFICE 0.70 26-OCT-23 575649 24-FEB-23 Payne, Felton R Jr OFFICE 0.02 26-OCT-23 575655 24-FEB-23 CoM Misc MODESTO 1010, 10th Street 200.00 26-OCT-23 Modesto, CA 95354
United States
575659 24-FEB-23 CoM Misc MODESTO 1010, 10th Street 221.00 26-OCT-23 Modesto, CA 95354
United States
CoM PRIMARY Report Date: 09-NOV-2023 10:19
Void Payment Register Page: 3
Include Zero Amount Payments: No Period From: 01-OCT-23 To: 31-OCT-23 Display Payee Address: Yes Date: Void Date
Bank: BMO Branch: BMO Main Branch Account: BoTW Main Acount AP Checks Bank Account Currency: USD Payment Currency: USD ( US Dollar ) Payment Number Date Payee Name Site Address Payment Amount Void Date --------------- --------- --------------------------- --------------- --------------------------------- ----------------- --------- Payment Document: CoM AP BoTW Check
575660 24-FEB-23 CoM Misc MODESTO 1010, 10th Street 180.00 26-OCT-23 Modesto, CA 95354
United States
575698 24-FEB-23 BRYAN AND RITA GRIMES MAIN 4112 AZROCK COURT 316.33 26-OCT-23 ANTIOCH, CA 94531
United States
577451 07-APR-23 COM HDL MODESTO 1010 10TH STREET 100.00 05-OCT-23 MODESTO, CA 95354
United States
579930 26-MAY-23 RED WAVE SECURITY MAIN 3582 W HOLLAND AVE STE 101 240.00 05-OCT-23 FRESNO, CA 93722
United States
582008 21-JUL-23 COM HDL MODESTO 1010 10TH STREET 100.00 16-OCT-23 MODESTO, CA 95354
Attachment 7, Voided Checks
#6..
- 353 -
11/9/23, 10:19 AM comprodapp122.modesto.prv:8000/OA_CGI/FNDWRR.exe?temp_id=1967102769 comprodapp122.modesto.prv:8000/OA_CGI/FNDWRR.exe?temp_id=1967102769 4/5 United States
582629 04-AUG-23 ALL SEASON LAWN LANDSCAPING MAIN 31062 STATE HIGHWAY 120 6,534.54 26-OCT-23 ESCALON, CA 95354
United States
582795 04-AUG-23 MODESTO SISTER CITIES INTL MAIN PO BOX 580253 35,000.00 19-OCT-23 MODESTO, CA 95358
United States
583440 18-AUG-23 COM REBATE Modesto 1010 10th STREET 2,744.00 26-OCT-23 MODESTO, CA 95354
United States
583946 25-AUG-23 ENTERPRISE VEHICLE EXCHANGE MAIN ATTN: ACCOUNTS RECEIVABLE 855.37 19-OCT-23 4623-B MCHENRY AVENUE
MODESTO, CA 95356
United States
584005 25-AUG-23 OFFICE DEPOT INC MAIN 6600 NORTH MILITARY TRAIL 280.89 19-OCT-23 BOCA RATON, FL 33496
United States
584019 25-AUG-23 STANISLAUS COUNTY COMMUNITY MAIN PO BOX 770 6,120.00 05-OCT-23 MODESTO, CA 95353-0770
United States
584072 01-SEP-23 CoM Misc MODESTO 1010, 10th Street 710.00 16-OCT-23 Modesto, CA 95354
United States
-----------------
Payment Document Subtotal 55,107.40
-----------------
Bank Account Subtotal 55,107.40
CoM PRIMARY Report Date: 09-NOV-2023 10:19
Void Payment Register Page: 4
Include Zero Amount Payments: No Period From: 01-OCT-23 To: 31-OCT-23 Display Payee Address: Yes Date: Void Date
Bank: BMO Branch: BMO Main Branch Account: BMO E-Payables (Main) AP Bank Account Currency: USD Payment Currency: USD ( US Dollar ) Payment Number Date Payee Name Site Address Payment Amount Void Date --------------- --------- --------------------------- --------------- --------------------------------- ----------------- --------- Payment Document: Epayable
815695 20-SEP-23 ADVANCED CHEMICAL TRANSPORT E-PAY 1968 E-PAY 1968 1,413.50 05-OCT-23 SAN JOSE, CA 95133
United States
815792 18-OCT-23 ALPHA ANALYTICAL LABORATORI E-PAY 3772 E-PAY 3772 75,167.00 24-OCT-23 UKIAH, CA 95482
Attachment 7, Voided Checks
#6..
- 354 -
11/9/23, 10:19 AM comprodapp122.modesto.prv:8000/OA_CGI/FNDWRR.exe?temp_id=1967102769 comprodapp122.modesto.prv:8000/OA_CGI/FNDWRR.exe?temp_id=1967102769 5/5 United States
-----------------
Payment Document Subtotal 76,580.50
-----------------
Bank Account Subtotal 76,580.50
-----------------
Report Count: 44 Report Total 435,054.84
*** End of Report ***
Attachment 7, Voided Checks
#6..
- 355 -

CITY OF MODESTO

COUNCIL AGENDA REPORT
DATE OF MEETING:

January 9, 2024
Date: December 13, 2023
TO: Mayor and City Council
THROUGH: Joseph P. Lopez, City Manager
FROM: DeAnna Christensen, Director of Finance
SUBJECT: Monthly Investment Report – October 2023
CONTACT: Calogero Maniscalco, Senior Financial Analyst
[email protected], 209-577-5219
DESCRIPTION:

Consider accepting the Monthly Investment Report for October 2023. (Funding Source: Various Funds)
STRATEGIC PLAN ELEMENT:

This item supports the City of Modesto 2020-2025 Strategic Plan focus of Governance and Service Delivery under Goal H: Achieve Financial Sustainability.

BACKGROUND:

The City’s Finance Department submits a monthly investment report to Council and the City Manager. Attached are the August investment reports (see attachment list below) generated by Public Financial Management, the City’s investment advisor. Investments in the portfolio (attachment 4) are for the City of Modesto, Modesto Public Financing Authority, Community Facilities Districts, Tuolumne River Regional Park, Successor Agency to the Redevelopment Agency, and the Modesto-Ceres Fire Protection Agency Joint Powers Authority.

DISCUSSION:

It is the function of the Finance Department to deposit and invest funds in accordance with sound treasury management and to safeguard the principal and maintain the liquidity needs of the City. The purpose of the Monthly Investment Report is to keep the City Council and City Manager informed of the City’s investment portfolio. As shown in Attachment 2, on October 31, 2023 the City had a closing market value of $465,353,427 in its investment portfolio. #7..
- 356 -
City Council, January 9, 2024
Monthly Investment Report – October 2023

Page 2 of 2 ends

FISCAL IMPACT:

In October, the approximate yield of the City’s combined investments was 3.40% (see attachment 3) on a weighted average. For the portfolio of securities alone, the yield to maturity on cost was 2.89%. For comparative purposes, the yields (as of October 31, 2023) of other investments commonly used by public agencies are listed below:

Local Agency Investment Fund: 3.67%
1-Year U.S. Treasury Note: 5.47%
2-Year U.S. Treasury Note: 5.10%

The Portfolio maintains sufficient liquidity to meet the City's projected expenditure requirements for at least the next six months.

COMMITTEE RECOMMENDATION:

This item has not gone before a committee.

CEQA/NEPA REQUIREMENTS:

N/A
RECOMMENDED COUNCIL ACTION:

Staff Recommendations:

Motion accepting the Monthly Investment Report for October 2023.

Approved by:

DeAnna Christensen, Director of Finance
Joseph P. Lopez, City Manager
Attachments:

1. Monthly Investment Report

2. Account Statement

3. Combined Yields

4. Portfolio Holdings and Earnings Projections

5. Cash with Fiscal Agent
#7..
- 357 -

Page 1 ends

PORTFOLIO HOLDINGS
Attachment 1
Percentages may not total to 100% due to rounding.

Investment Type No. of Investments Amount Invested
CAMP 1 48,862,493
Federal Agency 20 35,975,676
Federal Home Loan Bank 1 2,213,030
Federal Home Loan Mortgage Co. 4 5,882,597
Federal Nat’l Mortgage Assc. 15 27,880,049
Federal Agency CMO 15 42,723,719
U.S. Treasury 54 212,151,186
Commercial Paper 2 20,965,788
Negotiable CD 2 6,783,597
Corporate Note 28 67,985,450
Asset-Backed 15 19,269,919
Municipal 9 4,938,109
Supranational 2 5,697,490
Total Invested 148 465,353,427
Sector Allocation
October 31, 2023 versus September 30, 2023
Sector October 31, 2023 September 30, 2023 Change in Allocation Permitted by Policy
U.S. Treasury 45.6% 46.3% -0.74% 100%
Federal Agency 7.7% 7.7% 0.01% 100%
Federal Agency CMO 9.2% 7.9% 1.33% 100%
Commercial Paper 4.5% 4.5% 0.01% 25%
Negotiable CD 1.5% 1.5% 0.00% 30%
Corporate Note 14.6% 14.7% -0.08% 30%
Asset-Backed 4.1% 4.2% -0.06% 20%
Municipal 1.1% 1.6% -0.50% 100%
Supranational 1.2% 1.2% 0.00% 30%
CAMP 10.5% 10.5% 0.03% 100%
* Total invested includes only the bolded numbers
* * Amount invested are market values excluding accrued interest Additional, detailed information regarding security types and investment activity may be found in Attachment 2 accompanying this memo. Moreover, the addendum data will confirm continued compliance with the investment policy as well as with California Government Code.

RECENT ACTIVITY & CORPORATE EXPOSURE
The Federal Reserve (Fed) held the benchmark overnight target rate unchanged at its current range of

5.25% to 5.50% at the conclusion of its meeting on November 1 skipping a rate hike for two consecutive meetings. Fed Chair Jerome Powell characterized policy risks as “getting more balanced.” The market’s response was to price out any further rate hikes and pull forward the first potential rate cut in 2024. The advance estimate of U.S. real gross domestic product(GDP) showed economic growth increased at an annual rate of 4.9% in the third quarter, firmly beating surveys and more than doubling the 2.1% rise in the second quarter. In the Long-Term portfolio we utilized the proceeds of maturing securities and sells to purchase three Treasury bills, with their short maturities targeted to later purchases, and two agency CMBS while we sold four Treasury notes. In the Short-Term Portfolio we purchased Treasury note replacing one that matured.
#7..
- 358 -

Page 2 ends

PERFORMANCE
U.S. Treasury yields finished higher across the curve in October. The 30-year bond led the way, increasing 39 basis points (bps) over the month to finish at 5.09%, while the 5-year increased 24 bps ending the month at 4.85%. Despite higher yields across the Treasury curve the long-term portfolio achieved positive returns over the month. With spreads widening across most sectors, we saw modest underperformance versus the benchmark while the long-term portfolio continues to outperform since inception. Given good fundamentals and a positive economic outlook, we still hold positive views across most spread sectors.

1. Performance is calculated on trade-date basis, gross (i.e., before fees) in accordance the CFA Institute's Global Investment Performance Standards (GIPS).

2. Performance numbers for periods greater than 1 year are presented on an annualized basis unless otherwise noted.

3. The performance calculation excludes any funds not invested in the 1-5 year strategy.

4. Performance benchmark through December 31, 2018 was the ICE BofAML 1-3 Year U.S. Treasury Index, and is now the ICE BofAML 1-5 Year U.S. Treasury Index, sourced from Bloomberg.

5. Inception date is 3/31/04.

Percentages may not add due to rounding.

Long-Term Portfolio Total Return
October 31, 2023
1 Month Trailing
12 Months
Trailing 36
Months
Trailing 60
Months
Since
Inception5
City of Modesto Investment Portfolio1,2,3 0.06% 2.58% -1.33% 1.19% 1.91% Modesto Performance Benchmark40.10% 2.43% -1.68% 0.87% 1.62% Average Portfolio Yields
October 31, 2023
Past
Month
Past 3
Months
Past
Year
Past 3
Years
Past 5
Years
City of Modesto Investment Portfolio 2.89% 2.73% 2.14% 1.79% 1.98% City of Modesto Short-Term Portfolio 5.63% 5.54% 4.98% - - $91.0
$25.0
$78.7
$109.0
$53.2
$108.4
$-
$30.0
$60.0
$90.0
$120.0
$150.0
Under 6
Months
6-12
Months
1-2 Years 2-3 Years 3-4 Years 4-5 Years
Millions
Maturity Distribution
October 31, 2023
#7..
- 359 -

Page 3 ends

INVESTMENT POLICY
The City’s investment policy embraces the following standards: the prudent investor rule, requiring the safety of principal, through prudent and safe investments; sufficient liquidity to meet expected and unforeseen cash flows; generation of an above-market, risk-adjusted rate of return (meaning, returnsexpectations taking safety and liquidity into account). No investments longer than five years are permitted.

Some investments have maturity limits of 270 days or less. The table below details the City’s permitted investments.

Investment Type
Maximum
Maturity
Maximum Specified
% of Portfolio
Maximum
% per
Issuer
Minimum Quality
Requirements
Local Agency Bonds 5 Years None None None
Treasury Obligations 5 Years None None None
State Obligations 5 Years None None A rating
CA Local Agency Obligations 5 Years None None A rating
Federal Agencies 5 Years None None None
Supranationals 5 Years 30 percent 5 percent AA
Banker’s Acceptances 180 days 40 percent 5 percent Federal Reserve eligible Commercial Paper 270 days 25 percent 5 percent A1/P1 rating Negotiable Certificates of Deposit 5 Years 30 percent 5 percent A rating Certificates of Deposit 1 Year 20 percent 5 percent FDIC insured or collateralized Repurchase Agreements 90 days None 5 percent None
Reverse Repurchase Agreements 92 days 20 percent of
combined base value 5 percent None
Medium Term Notes 5 Years 30 percent 5 percent A rating Money Market Mutual Funds N/A 20 percent 10 percent Multiple Mortgage and Asset-backed Securities 5 Years 20 percent 5 percent AA Rating CAMP N/A None None N/A
LAIF N/A N/A None N/A
The City is not required to include a list of investments held by our bond trustees; however, staff believes the City Council should be kept informed of these investments. These investments are identified on Attachment A.

LONG TERM PORTFLIO INCOME RETURN
Monthly Income Return

0.19%
Fiscal Year-to-Date Income Return

0.67%
Prior 12 Months Income Return

1.63%
#7..
- 360 -

Page 4 ends

0%
5%
10%
15%
20%
25%
30%
35%
2020 2021 2022 2023
Personal Savings as % of Disposable Income
Source: Bloomberg, as of September 2023.

Economic Summary
Consumers are Saving Less and Spending More

0.6% 0.6%

0.3%

1.6%

0.4% 0.4%

0.2%

0.4%

0.8%

0.4%

0.7%
-0.1% -0.1%
-0.5%

0.0%

0.5%

1.0%

1.5%

2.0%
Sep-22 Oct-22 Nov-22Dec-22 Jan-23 Feb-23 Mar-23 Apr-23 May-23 Jun-23 Jul-23 Aug-23Sep-23 Personal Spending
% Change from Previous Month
Sep ‘23

3.4%
#7..
- 361 -

Page 5 ends

Source: Bloomberg, as of October 2023. Data is seasonally adjusted.

Economic Summary
Unemployment Rate Up ½ Percent and Job Growth Decelerating 557 781 614 569 364 904 414 254 364 370 568 352 350 324 290 239 472 248 217 217281 105 236 227297 150 0 200
400
600
800
1,000
1,200
Sep-21
Dec-21
Mar-22
Jun-22
Sep-22
Dec-22
Mar-23
Jun-23
Sep-23
Thousands
Monthly Change In
Nonfarm Payrolls
2021:

7.2 million
2022:

4.8 million
2023:

2.5 million new jobs
April 20

14.7%
Oct 23

3.9%
0%
2%
4%
6%
8%
10%
12%
14%
16%
2019 2020 2021 2022
Unemployment Rate
#7..
- 362 -

Page 6 ends

Source: ICE BofAML 1-5 year Indices via Bloomberg, MarketAxess and PFMAM as of 10/31/2023. Spreads on ABS are option-adjusted spreads of 0-5 year indices based on weighted average life; spreads on agencies are relative to comparable maturity Treasuries.

Economic Summary
Corporate and Asset-Backed Spreads Widen While Agency
Spreads Tighten

0.00%

0.05%

0.10%

0.15%

0.20%

0.25%

0.30%

0.35%
Oct-22 Jan-23 Apr-23 Jul-23 Oct-23
Federal Agency Yield Spreads

0.50%

0.60%

0.70%

0.80%

0.90%

1.00%

1.10%

1.20%
Oct-22 Jan-23 Apr-23 Jul-23 Oct-23
Corporate Notes A-AAA Yield Spreads

0.20%

0.30%

0.40%

0.50%

0.60%

0.70%

0.80%

0.90%

1.00%

1.10%

1.20%
Oct-22 Jan-23 Apr-23 Jul-23 Oct-23
Asset-Backed Securities AAA Yield Spreads
#7..
- 363 -

Page 7 ends

Medium and Longer-Term Treasury Yields Continue on
Their Path Higher
Source: Bloomberg as of 10/31/2023.

Economic Summary

5.57%

5.45%

4.93% 4.93%

5.09%

1.00%

1.50%

2.00%

2.50%

3.00%

3.50%

4.00%

4.50%

5.00%

5.50%

6.00%
3M1Y 2Y 3Y 4Y 5Y 10Y 30Y
U.S. Treasury Yield Curve
October 31, 2023
September 30, 2023
June 30, 2023
#7..
- 364 -

Page 8 ends

This material is based on information obtained from sources generally believed to be reliable and available to the public, however, PFM Asset Management LLC cannot guarantee its accuracy, completeness or suitability. This material is for general information purposes only and is not intended to provide specific advice or a specific recommendation. All statements as to what will or may happen under certain circumstances are based on assumptions, some but not all of which are noted in the presentation. Assumptions may or may not be proven correct as actual events occur, and results may depend on events outside of your or our control. Changes in assumptions may have a material effect on results. Past performance does not necessarily reflect and is not a guaranty of future results. The information contained in this presentation is not an offer to purchase or sell any securities.

Investment advisory services are provided by PFM Asset Management LLC (“PFMAM”), an investment adviser registered with the U.S. Securities and Exchange Commission and a subsidiary of U.S. Bancorp Asset Management, Inc. (“USBAM”). USBAM is a subsidiary of U.S. Bank National Association (“U.S. Bank”). U.S. Bank is a separate entity and subsidiary of U.S. Bancorp. U.S. Bank is not responsible for and does not guarantee the products, services or performance of PFMAM. The information contained is not an offer to purchase or sell any securities. Additional applicable regulatory information is available upon request.

For more information regarding PFMAM’s services or entities, please visit www.pfmam.com.

Disclosures
#7..
- 365 -
For the Month Ending October 31, 2023
Account Statement
Consolidated Summary Statement
CITY OF MODESTO - Combined Portfolio
Investment Allocation
Investment Type Closing Market Value Percent
Asset-Backed Security 19,269,919.40 4.14
Federal Agency Bond / Note 35,975,675.86 7.73
Corporate Note 62,405,340.86 13.41
Bank Note 5,580,109.47 1.20
Certificate of Deposit 6,783,596.50 1.46
Federal Agency Commercial Mortgage-Backed Security 42,723,718.87 9.18 Commercial Paper 20,965,788.28 4.51
Municipal Bond / Note 4,938,108.95 1.06
Supra-National Agency Bond / Note 5,697,490.05 1.22
U.S. Treasury Bill 2,344,655.05 0.50
U.S. Treasury Bond / Note 209,806,530.69 45.09
CAMP Pool 48,862,493.00 10.50
Total $465,353,426.98 100.00%
Portfolio Summary
and Income
Closing
Portfolio Holdings Market Value
Cash Dividends
PFMAM Managed Account 930,374.83 416,490,933.98
CAMP Pool 0.00 48,862,493.00
Total $930,374.83 $465,353,426.98
Maturity Distribution (Fixed Income Holdings)
Portfolio Holdings Closing Market Value Percent
63,443,631.40

0.00 0.00
27,600,043.80
25,034,673.39
78,718,357.09
109,023,283.75
53,181,151.70
108,352,285.85

0.00 13.63

0.00 0.00

5.93 5.38

16.92 23.43

11.43 23.28

0.00 Under 30 days
31 to 60 days
61 to 90 days
91 to 180 days
181 days to 1 year
1 to 2 years
2 to 3 years
3 to 4 years
4 to 5 years
Over 5 years
Total $465,353,426.98
848
100.00%
Weighted Average Days to Maturity
Sector Allocation

4.14% ABS

7.73%
Fed Agy Bond /
Note

13.41%
Corporate Note

1.20%
Bank Note

1.46%
Cert of Deposit

9.18%
Federal Agency
Commercial
Mortgage-Backed
Security

4.51%
Commercial Paper

1.06%
Muni Bond / Note

1.22%
Supra-National
Agency Bond / Note

0.50%
US TSY Bill

45.09%
US TSY Bond / Note

10.50%
CAMP Pool
Summary Page 1
#7..
- 366 -
Managed Account Summary Statement For the Month Ending October 31, 2023 CITY OF MODESTO - Combined Portfolio
Total Cash Basis Earnings
Plus Net Realized Gains/Losses
Less Purchased Interest Related to Interest/Coupons
Interest/Dividends/Coupons Received
Earnings Reconciliation (Cash Basis) - Managed Account
Less Beginning Accrued Interest
Less Beginning Amortized Value of Securities
Less Cost of New Purchases
Plus Coupons/Dividends Received
Plus Proceeds of Maturities/Calls/Principal Payments
Plus Proceeds from Sales
Ending Accrued Interest
Ending Amortized Value of Securities
Earnings Reconciliation (Accrual Basis)
$415,773,123.21
(18,592,618.03)
(5,233,440.23)
24,867,005.95

0.00 (323,136.92)
$416,490,933.98
978,106.79
(131,335.49)
83,603.53
$930,374.83
Total
435,148,752.88
1,581,137.15
5,294,936.29
18,626,894.28
882,334.48
(24,998,341.44)
(433,824,262.98)
(1,669,144.69)
Total Accrual Basis Earnings $1,042,305.97
Closing Market Value
Change in Current Value
Unsettled Trades
Principal Acquisitions
Principal Dispositions
Maturities/Calls
Opening Market Value
Transaction Summary - Managed Account
_________________
_________________
_______________________________________________ _______________________________________________ Reconciling Transactions Net Cash Contribution
Security Purchases
Principal Payments
Coupon/Interest/Dividend Income
Sale Proceeds
Maturities/Calls
Cash Transactions Summary - Managed Account
18,422,276.25
5,294,936.29
882,334.48
204,618.03
(24,998,341.44)

0.00 0.00
Cash Balance
Closing Cash Balance $56,122.53
CITY OF MODESTO - COMBINED PORTFOLIO Page 1
#7..
- 367 -
Portfolio Summary and Statistics For the Month Ending October 31, 2023 CITY OF MODESTO - Combined Portfolio
Account Summary
Description Par Value Market Value Percent
U.S. Treasury Bond / Note 227,730,000.00 209,806,530.69 50.37 U.S. Treasury Bill 2,345,000.00 2,344,655.05 0.56
Supra-National Agency Bond / Note 5,885,000.00 5,697,490.05 1.37 Municipal Bond / Note 5,280,000.00 4,938,108.95 1.19
Federal Agency Commercial
Mortgage-Backed Security
44,548,859.31 42,723,718.87 10.26
Federal Agency Bond / Note 38,760,000.00 35,975,675.86 8.64 Corporate Note 65,175,000.00 62,405,340.86 14.98
Commercial Paper 21,387,000.00 20,965,788.28 5.03
Certificate of Deposit 6,855,000.00 6,783,596.50 1.63
Bank Note 5,635,000.00 5,580,109.47 1.34
Asset-Backed Security 19,490,705.38 19,269,919.40 4.63
Managed Account Sub-Total 443,091,564.69 416,490,933.98 100.00% Accrued Interest 1,581,137.15
Total Portfolio 443,091,564.69 418,072,071.13
Unsettled Trades 0.00 0.00
Sector Allocation

4.63% ABS

1.34%
Bank Note

1.63%
Cert of Deposit

5.03%
Commercial Paper

14.98%
Corporate Note

8.64%
Fed Agy Bond /
Note

10.26%
Federal Agency
Commercial
Mortgage-Backed
Security

1.19%
Muni Bond / Note

1.37%
Supra-National
Agency Bond / Note

0.56%
US TSY Bill

50.37%
US TSY Bond / Note
CITY OF MODESTO - COMBINED PORTFOLIO Page 2
#7..
- 368 -
Portfolio Summary and Statistics For the Month Ending October 31, 2023 CITY OF MODESTO - Combined Portfolio
0 - 6 Months 6 - 12 Months 1 - 2 Years 2 - 3 Years 3 - 4 Years 4 - 5 Years Over 5 Years

10.12%

6.01%

18.90%

26.18%

12.77%

26.02%

0.00%
Maturity Distribution Characteristics
Yield to Maturity at Cost
Yield to Maturity at Market
Weighted Average Days to Maturity 948

3.17%

5.24%
CITY OF MODESTO - COMBINED PORTFOLIO Page 3
#7..
- 369 -
Managed Account Issuer Summary For the Month Ending October 31, 2023 CITY OF MODESTO - Combined Portfolio
Credit Quality (S&P Ratings)

3.70%
A

8.02%
A+

1.31%
A2.53%
A-1

3.07%
A-1+

2.95%
AA

70.66%
AA+

0.25%
AA6.91%
AAA

0.60%
NR
Issuer Summary
Issuer of Holdings Percent
Market Value
AMAZON.COM INC 4,861,554.17 1.17
AMERICAN EXPRESS CO 3,061,818.27 0.74
APPLE INC 4,948,054.80 1.19
BANK OF AMERICA CO 5,649,468.53 1.36
Bank of America Corp 1,453,499.60 0.35
BRISTOL-MYERS SQUIBB CO 2,033,628.43 0.49
CALIFORNIA DEPARTMENT OF WATER RESOURCES 94,745.00 0.02 CALIFORNIA STATE UNIVERSITY 571,890.00 0.14
CARMAX AUTO OWNER TRUST 488,287.69 0.12
CHASE ISSURANCE 2,991,524.42 0.72
CITIGROUP INC 5,581,290.35 1.34
DEERE & COMPANY 2,488,725.86 0.60
DISCOVER FINANCIAL SERVICES 739,090.14 0.18
FANNIE MAE 31,576,444.63 7.57
FEDERAL HOME LOAN BANKS 2,213,030.16 0.53
FIFTH THIRD AUTO TRUST 2,414,075.13 0.58
FLORIDA STATE BOARD OF ADMIN FIN CORP 1,678,698.00 0.40 FREDDIE MAC 44,909,919.94 10.77
HOME DEPOT INC 3,283,276.95 0.79
HONDA AUTO RECEIVABLES 2,356,971.86 0.57
HYUNDAI AUTO RECEIVABLES 551,020.67 0.13
INTER-AMERICAN DEVELOPMENT BANK 3,913,169.72 0.94
INTL BANK OF RECONSTRUCTION AND DEV 1,784,320.33 0.43
JP MORGAN CHASE & CO 3,521,055.64 0.85
KUBOTA CREDIT OWNER TRUST 877,447.71 0.21
LMA AMERICAS LLC 10,537,481.90 2.53
LOS ANGELES COMMUNITY COLLEGE DISTRICT 854,154.25 0.21
MASTERCARD INC 4,067,469.92 0.98
MICROSOFT CORP 5,622,468.00 1.35
NEW JERSEY TURNPIKE AUTHORITY 462,064.90 0.11
PACCAR FINANCIAL CORP 2,837,456.27 0.68
PFIZER INC 3,410,467.32 0.82
CITY OF MODESTO - COMBINED PORTFOLIO Page 4
#7..
- 370 -
Managed Account Issuer Summary For the Month Ending October 31, 2023 CITY OF MODESTO - Combined Portfolio
Issuer of Holdings Percent
Market Value
RABOBANK NEDERLAND 3,428,596.50 0.82
STATE OF MARYLAND 597,481.60 0.14
TARGET CORP 328,739.08 0.08
THE BANK OF NEW YORK MELLON CORPORATION 3,106,521.50 0.75 THUNDER BAY FUNDING LLC 10,428,306.38 2.50
TORONTO-DOMINION BANK 3,355,000.00 0.81
TOYOTA MOTOR CORP 4,086,879.29 0.98
UNITED STATES TREASURY 212,151,185.74 50.93
UNIVERSITY OF CALIFORNIA 679,075.20 0.16
US BANCORP 2,839,081.96 0.68
USAA AUTO OWNER TRUST 2,999,347.02 0.72
WAL-MART STORES INC 5,076,039.68 1.22
WELLS FARGO & COMPANY 5,580,109.47 1.34
Total $416,490,933.98 100.00%
CITY OF MODESTO - COMBINED PORTFOLIO Page 5
#7..
- 371 -
Managed Account Detail of Securities Held For the Month Ending October 31, 2023 CITY OF MODESTO - Combined Portfolio
Dated Date/Coupon/Maturity CUSIP Rating Rating Date Date Cost at Cost Interest Cost Value Security Type/Description S&P Moody's Trade Settle Original YTM Accrued Amortized Market Par
U.S. Treasury Bond / Note

US TREASURY NOTES
DTD 11/30/2016 2.125% 11/30/2023
912828U57 10,480,000.00 AA+ Aaa 07/28/23 07/31/23 10,365,784.38 5.43 93,704.37 10,452,850.39 10,452,163.02

US TREASURY NOTES
DTD 05/15/2014 2.500% 05/15/2024
912828WJ5 10,565,000.00 AA+ Aaa 10/16/23 10/16/23 10,385,890.23 5.50 122,014.27 10,399,407.95 10,396,620.31

US TREASURY NOTES
DTD 11/30/2017 2.125% 11/30/2024
9128283J7 2,255,000.00 AA+ Aaa 04/29/21 04/30/21 2,384,750.59 0.50 20,162.53 2,294,123.27 2,177,132.14

US TREASURY NOTES
DTD 12/15/2021 1.000% 12/15/2024
91282CDN8 4,445,000.00 AA+ Aaa 04/06/22 04/07/22 4,251,920.31 2.68 16,881.28 4,364,468.29 4,233,862.50

US TREASURY NOTES
DTD 02/15/2022 1.500% 02/15/2025
91282CDZ1 2,300,000.00 AA+ Aaa 07/13/23 07/17/23 2,183,203.13 4.88 7,312.50 2,204,787.35 2,191,109.26

US TREASURY NOTES
DTD 02/15/2022 1.500% 02/15/2025
91282CDZ1 4,400,000.00 AA+ Aaa 04/06/22 04/07/22 4,255,109.38 2.70 13,989.13 4,334,556.58 4,191,687.28

US TREASURY NOTES
DTD 04/30/2020 0.375% 04/30/2025
912828ZL7 4,945,000.00 AA+ Aaa 04/29/21 04/30/21 4,894,777.34 0.63 50.94 4,926,230.96 4,601,940.63

US TREASURY NOTES
DTD 07/02/2018 2.750% 06/30/2025
912828XZ8 4,230,000.00 AA+ Aaa 04/06/22 04/07/22 4,232,148.05 2.73 39,196.47 4,231,104.97 4,067,409.38

US TREASURY NOTES
DTD 08/31/2020 0.250% 08/31/2025
91282CAJ0 4,340,000.00 AA+ Aaa 08/02/21 08/06/21 4,291,514.06 0.53 1,848.08 4,318,171.54 3,973,812.50

US TREASURY NOTES
DTD 08/31/2020 0.250% 08/31/2025
91282CAJ0 4,635,000.00 AA+ Aaa 04/06/22 04/07/22 4,262,932.62 2.74 1,973.69 4,434,586.89 4,243,921.88

US TREASURY NOTES
DTD 09/30/2020 0.250% 09/30/2025
91282CAM3 1,100,000.00 AA+ Aaa 09/27/21 09/28/21 1,076,023.44 0.80 240.44 1,088,544.35 1,004,093.75

US TREASURY NOTES
DTD 09/30/2020 0.250% 09/30/2025
91282CAM3 4,550,000.00 AA+ Aaa 09/07/21 09/09/21 4,473,574.22 0.67 994.53 4,513,953.02 4,153,296.88

US TREASURY NOTES
DTD 10/31/2020 0.250% 10/31/2025
91282CAT8 5,010,000.00 AA+ Aaa 04/29/21 04/30/21 4,894,339.45 0.77 34.41 4,958,673.43 4,555,186.19

US TREASURY NOTES
DTD 10/31/2020 0.250% 10/31/2025
91282CAT8 6,930,000.00 AA+ Aaa 10/04/21 10/06/21 6,783,278.91 0.78 47.60 6,857,923.02 6,300,886.28 CITY OF MODESTO - COMBINED PORTFOLIO Page 6
#7..
- 372 -
Managed Account Detail of Securities Held For the Month Ending October 31, 2023 CITY OF MODESTO - Combined Portfolio
Dated Date/Coupon/Maturity CUSIP Rating Rating Date Date Cost at Cost Interest Cost Value Security Type/Description S&P Moody's Trade Settle Original YTM Accrued Amortized Market Par
U.S. Treasury Bond / Note

US TREASURY NOTES
DTD 11/30/2020 0.375% 11/30/2025
91282CAZ4 4,250,000.00 AA+ Aaa 11/01/21 11/02/21 4,133,291.02 1.07 6,705.94 4,190,430.61 3,860,859.38

US TREASURY NOTES
DTD 11/30/2020 0.375% 11/30/2025
91282CAZ4 4,635,000.00 AA+ Aaa 04/06/22 04/07/22 4,254,785.16 2.75 7,313.42 4,418,223.35 4,210,607.81

US TREASURY NOTES
DTD 12/31/2020 0.375% 12/31/2025
91282CBC4 500,000.00 AA+ Aaa 02/02/21 02/04/21 498,613.28 0.43 631.79 499,387.55 453,046.90

US TREASURY NOTES
DTD 12/31/2020 0.375% 12/31/2025
91282CBC4 1,040,000.00 AA+ Aaa 01/07/21 01/08/21 1,035,978.13 0.45 1,314.13 1,038,250.11 942,337.55

US TREASURY NOTES
DTD 12/31/2020 0.375% 12/31/2025
91282CBC4 3,735,000.00 AA+ Aaa 04/05/21 04/07/21 3,646,439.65 0.89 4,719.50 3,694,484.54 3,384,260.35

US TREASURY NOTES
DTD 01/31/2021 0.375% 01/31/2026
91282CBH3 2,400,000.00 AA+ Aaa 07/02/21 07/07/21 2,353,875.00 0.80 2,274.46 2,377,282.95 2,165,625.12

US TREASURY NOTES
DTD 01/31/2021 0.375% 01/31/2026
91282CBH3 5,000,000.00 AA+ Aaa 02/17/22 02/18/22 4,719,531.25 1.85 4,738.45 4,840,231.94 4,511,719.00

US TREASURY NOTES
DTD 01/31/2021 0.375% 01/31/2026
91282CBH3 5,775,000.00 AA+ Aaa 01/04/22 01/06/22 5,570,167.97 1.27 5,472.91 5,661,694.53 5,211,035.45

US TREASURY NOTES
DTD 01/31/2021 0.375% 01/31/2026
91282CBH3 7,980,000.00 AA+ Aaa 05/03/22 05/04/22 7,256,812.50 2.95 7,562.57 7,545,453.12 7,200,703.52

US TREASURY NOTES
DTD 02/28/2019 2.500% 02/28/2026
9128286F2 3,210,000.00 AA+ Aaa 03/01/21 03/01/21 3,492,881.25 0.70 13,668.96 3,341,752.91 3,035,456.25

US TREASURY NOTES
DTD 02/28/2021 0.500% 02/28/2026
91282CBQ3 4,645,000.00 AA+ Aaa 04/06/22 04/07/22 4,259,973.05 2.76 3,955.91 4,415,012.01 4,189,934.92

US TREASURY NOTES
DTD 02/28/2021 0.500% 02/28/2026
91282CBQ3 6,000,000.00 AA+ Aaa 12/03/21 12/07/21 5,838,281.25 1.15 5,109.89 5,910,970.90 5,412,187.20

US TREASURY NOTES
DTD 03/31/2021 0.750% 03/31/2026
91282CBT7 2,480,000.00 AA+ Aaa 09/07/21 09/09/21 2,479,031.25 0.76 1,626.23 2,479,487.10 2,246,337.38

US TREASURY NOTES
DTD 03/31/2021 0.750% 03/31/2026
91282CBT7 4,925,000.00 AA+ Aaa 04/29/21 04/30/21 4,896,719.73 0.87 3,229.51 4,911,127.55 4,460,972.41 CITY OF MODESTO - COMBINED PORTFOLIO Page 7
#7..
- 373 -
Managed Account Detail of Securities Held For the Month Ending October 31, 2023 CITY OF MODESTO - Combined Portfolio
Dated Date/Coupon/Maturity CUSIP Rating Rating Date Date Cost at Cost Interest Cost Value Security Type/Description S&P Moody's Trade Settle Original YTM Accrued Amortized Market Par
U.S. Treasury Bond / Note

US TREASURY NOTES
DTD 05/31/2021 0.750% 05/31/2026
91282CCF6 1,405,000.00 AA+ Aaa 06/23/21 06/25/21 1,396,987.11 0.87 4,433.81 1,400,808.92 1,263,402.41

US TREASURY NOTES
DTD 05/31/2021 0.750% 05/31/2026
91282CCF6 4,615,000.00 AA+ Aaa 04/06/22 04/07/22 4,253,551.76 2.76 14,563.73 4,390,257.93 4,149,894.77

US TREASURY NOTES
DTD 05/31/2021 0.750% 05/31/2026
91282CCF6 4,800,000.00 AA+ Aaa 06/06/22 06/08/22 4,399,125.00 2.99 15,147.54 4,540,107.19 4,316,250.24

US TREASURY NOTES
DTD 08/31/2021 0.750% 08/31/2026
91282CCW9 4,640,000.00 AA+ Aaa 04/06/22 04/07/22 4,258,106.25 2.75 5,927.47 4,394,276.21 4,133,950.00

US TREASURY NOTES
DTD 09/30/2021 0.875% 09/30/2026
91282CCZ2 4,310,000.00 AA+ Aaa 04/05/22 04/07/22 3,968,398.83 2.77 3,297.27 4,087,969.67 3,848,021.88

US TREASURY NOTES
DTD 11/15/2016 2.000% 11/15/2026
912828U24 4,545,000.00 AA+ Aaa 06/06/22 06/08/22 4,355,920.90 3.01 41,991.85 4,415,525.72 4,176,428.68

US TREASURY NOTES
DTD 02/15/2017 2.250% 02/15/2027
912828V98 9,220,000.00 AA+ Aaa 07/05/22 07/07/22 8,981,576.56 2.85 43,970.38 9,049,818.90 8,491,043.75

US TREASURY NOTES
DTD 03/31/2022 2.500% 03/31/2027
91282CEF4 910,000.00 AA+ Aaa 11/29/22 11/30/22 854,973.44 4.03 1,989.07 866,660.50 842,887.50

US TREASURY NOTES
DTD 04/30/2020 0.500% 04/30/2027
912828ZN3 6,480,000.00 AA+ Aaa 08/03/22 08/05/22 5,791,500.00 2.92 89.01 5,971,887.80 5,576,850.00

US TREASURY NOTES
DTD 06/30/2020 0.500% 06/30/2027
912828ZV5 5,545,000.00 AA+ Aaa 08/09/22 08/10/22 4,920,754.30 2.99 9,342.12 5,077,427.73 4,739,242.19

US TREASURY NOTES
DTD 08/15/2017 2.250% 08/15/2027
9128282R0 1,200,000.00 AA+ Aaa 08/29/22 08/31/22 1,142,625.00 3.30 5,722.83 1,156,160.43 1,091,250.00

US TREASURY NOTES
DTD 08/15/2017 2.250% 08/15/2027
9128282R0 2,985,000.00 AA+ Aaa 09/01/22 09/06/22 2,830,036.52 3.40 14,235.53 2,866,200.39 2,714,484.38

US TREASURY NOTES
DTD 09/30/2022 4.125% 09/30/2027
91282CFM8 5,380,000.00 AA+ Aaa 11/01/22 11/03/22 5,344,903.91 4.27 19,403.28 5,352,013.22 5,237,093.75

US TREASURY NOTES
DTD 10/31/2022 4.125% 10/31/2027
91282CFU0 2,715,000.00 AA+ Aaa 12/06/22 12/08/22 2,752,755.47 3.81 307.68 2,745,829.41 2,641,185.94 CITY OF MODESTO - COMBINED PORTFOLIO Page 8
#7..
- 374 -
Managed Account Detail of Securities Held For the Month Ending October 31, 2023 CITY OF MODESTO - Combined Portfolio
Dated Date/Coupon/Maturity CUSIP Rating Rating Date Date Cost at Cost Interest Cost Value Security Type/Description S&P Moody's Trade Settle Original YTM Accrued Amortized Market Par
U.S. Treasury Bond / Note

US TREASURY NOTES
DTD 10/31/2022 4.125% 10/31/2027
91282CFU0 3,160,000.00 AA+ Aaa 12/13/22 12/14/22 3,229,495.31 3.63 358.10 3,216,937.80 3,074,087.50

US TREASURY NOTES
DTD 10/31/2020 0.500% 10/31/2027
91282CAU5 8,775,000.00 AA+ Aaa 01/04/23 01/06/23 7,472,803.71 3.91 120.54 7,694,154.87 7,394,308.16

US TREASURY NOTES
DTD 12/31/2022 3.875% 12/31/2027
91282CGC9 4,250,000.00 AA+ Aaa 06/01/23 06/05/23 4,266,933.59 3.78 55,492.53 4,265,422.75 4,093,281.25

US TREASURY NOTES
DTD 01/31/2023 3.500% 01/31/2028
91282CGH8 2,220,000.00 AA+ Aaa 05/16/23 05/18/23 2,218,265.63 3.52 19,636.14 2,218,434.12 2,105,184.26

US TREASURY NOTES
DTD 01/31/2021 0.750% 01/31/2028
91282CBJ9 3,450,000.00 AA+ Aaa 01/31/23 01/31/23 2,994,761.72 3.66 6,539.06 3,063,072.39 2,910,398.61

US TREASURY NOTES
DTD 02/28/2023 4.000% 02/29/2028
91282CGP0 2,825,000.00 AA+ Aaa 03/03/23 03/07/23 2,793,660.16 4.25 19,247.25 2,797,775.67 2,731,863.14

US TREASURY NOTES
DTD 02/28/2023 4.000% 02/29/2028
91282CGP0 2,970,000.00 AA+ Aaa 03/03/23 03/06/23 2,931,134.77 4.29 20,235.17 2,936,257.04 2,872,082.66

US TREASURY NOTES
DTD 03/31/2021 1.250% 03/31/2028
91282CBS9 2,555,000.00 AA+ Aaa 05/08/23 05/09/23 2,299,400.20 3.49 2,792.35 2,324,559.91 2,191,311.59

US TREASURY NOTES
DTD 03/31/2023 3.625% 03/31/2028
91282CGT2 2,675,000.00 AA+ Aaa 05/01/23 05/02/23 2,672,178.71 3.65 8,478.14 2,672,466.34 2,545,847.79

US TREASURY NOTES
DTD 04/30/2023 3.500% 04/30/2028
91282CHA2 2,810,000.00 AA+ Aaa 05/01/23 05/01/23 2,796,937.89 3.60 270.19 2,798,254.12 2,658,962.50

US TREASURY NOTES
DTD 04/30/2023 3.500% 04/30/2028
91282CHA2 6,530,000.00 AA+ Aaa 05/03/23 05/04/23 6,559,844.14 3.40 627.89 6,556,881.01 6,179,012.50 Security Type Sub-Total 227,730,000.00 218,658,257.48 2.76 700,992.84 221,562,331.22 209,806,530.69 U.S. Treasury Bill

US TREASURY BILL
DTD 11/03/2022 0.000% 11/02/2023
912796YT0 2,345,000.00 A-1+ P-1 10/02/23 10/02/23 2,334,351.19 5.30 0.00 2,344,656.49 2,344,655.05 Security Type Sub-Total 2,345,000.00 2,334,351.19 5.30 0.00 2,344,656.49 2,344,655.05 CITY OF MODESTO - COMBINED PORTFOLIO Page 9
#7..
- 375 -
Managed Account Detail of Securities Held For the Month Ending October 31, 2023 CITY OF MODESTO - Combined Portfolio
Dated Date/Coupon/Maturity CUSIP Rating Rating Date Date Cost at Cost Interest Cost Value Security Type/Description S&P Moody's Trade Settle Original YTM Accrued Amortized Market Par
Supra-National Agency Bond / Note

INTL BK RECON & DEVELOP NOTES
DTD 11/24/2020 0.250% 11/24/2023
459058JM6 1,790,000.00 AAA Aaa 11/17/20 11/24/20 1,786,151.50 0.32 1,951.60 1,789,919.16 1,784,320.33

INTER-AMERICAN DEVEL BK NOTES
DTD 09/23/2021 0.500% 09/23/2024
4581X0DZ8 4,095,000.00 AAA Aaa 09/15/21 09/23/21 4,091,969.70 0.52 2,161.25 4,094,095.89 3,913,169.72 Security Type Sub-Total 5,885,000.00 5,878,121.20 0.46 4,112.85 5,884,015.05 5,697,490.05 Municipal Bond / Note

MD ST TXBL GO BONDS
DTD 08/05/2020 0.510% 08/01/2024
574193TQ1 620,000.00 AAA Aaa 07/23/20 08/05/20 619,826.40 0.52 790.50 619,967.35 597,481.60

CA ST UNIV TXBL REV BONDS
DTD 09/17/2020 0.685% 11/01/2024
13077DMK5 600,000.00 AA- Aa2 08/27/20 09/17/20 600,000.00 0.69 2,055.00 600,000.00 571,890.00

CA ST DEPT WTR RES WTR SYS TXBL REV
BNDS
DTD 08/06/2020 0.560% 12/01/2024
13067WRB0 100,000.00 AAA Aa1 07/30/20 08/06/20 100,000.00 0.56 233.33 100,000.00 94,745.00

UNIV OF CAL TXBL REV BONDS
DTD 07/16/2020 0.883% 05/15/2025
91412HGE7 220,000.00 AA Aa2 07/14/20 07/16/20 220,796.40 0.81 895.76 220,243.88 204,652.80

UNIV OF CAL TXBL REV BONDS
DTD 07/16/2020 0.883% 05/15/2025
91412HGE7 510,000.00 AA Aa2 07/10/20 07/16/20 510,000.00 0.88 2,076.52 510,000.00 474,422.40

FL ST BOARD OF ADMIN TXBL REV BONDS
DTD 09/16/2020 1.258% 07/01/2025
341271AD6 505,000.00 AA Aa3 09/03/20 09/16/20 508,570.35 1.11 2,117.63 506,241.15 470,968.05

FL ST BOARD OF ADMIN TXBL REV BONDS
DTD 09/16/2020 1.258% 07/01/2025
341271AD6 1,295,000.00 AA Aa3 09/03/20 09/16/20 1,295,000.00 1.26 5,430.37 1,295,000.00 1,207,729.95

LOS ANGELES CCD, CA TXBL GO BONDS
DTD 11/10/2020 0.773% 08/01/2025
54438CYK2 925,000.00 AA+ Aaa 10/30/20 11/10/20 925,000.00 0.77 1,787.56 925,000.00 854,154.25

NJ TURNPIKE AUTHORITY TXBL REV BONDS
DTD 02/04/2021 1.047% 01/01/2026
646140DP5 505,000.00 AA- A1 01/22/21 02/04/21 505,000.00 1.05 1,762.45 505,000.00 462,064.90 Security Type Sub-Total 5,280,000.00 5,284,193.15 0.92 17,149.12 5,281,452.38 4,938,108.95 Federal Agency Commercial Mortgage-Backed Security
CITY OF MODESTO - COMBINED PORTFOLIO Page 10
#7..
- 376 -
Managed Account Detail of Securities Held For the Month Ending October 31, 2023 CITY OF MODESTO - Combined Portfolio
Dated Date/Coupon/Maturity CUSIP Rating Rating Date Date Cost at Cost Interest Cost Value Security Type/Description S&P Moody's Trade Settle Original YTM Accrued Amortized Market Par
Federal Agency Commercial Mortgage-Backed Security

FANNIEMAE-ACES
DTD 04/01/2014 3.346% 03/01/2024
3136AJB54 388,506.14 AA+ Aaa 12/13/19 12/18/19 407,385.10 2.14 1,083.28 389,994.32 384,706.24 FHMS K061 A2
DTD 01/30/2017 3.347% 11/01/2026
3137BTUM1 2,475,000.00 AA+ Aaa 05/19/23 05/24/23 2,398,816.41 4.31 6,903.19 2,408,574.21 2,338,649.33 FHMS K064 A2
DTD 05/15/2017 3.224% 03/01/2027
3137BXQY1 4,000,000.00 AA+ Aaa 08/16/23 08/18/23 3,773,125.00 4.98 10,746.67 3,786,305.19 3,743,456.96

FHLMC MULTIFAMILY STRUCTURED P
DTD 07/01/2017 3.243% 04/01/2027
3137F1G44 2,275,000.00 AA+ Aaa 08/16/23 08/18/23 2,144,987.30 4.97 6,148.19 2,152,363.21 2,123,749.29

FHLMC MULTIFAMILY STRUCTURED P
DTD 08/01/2017 3.117% 06/01/2027
3137F2LJ3 3,530,000.00 AA+ Aaa 08/17/23 08/22/23 3,301,101.56 5.01 9,169.18 3,312,886.76 3,274,970.28 FHMS K507 A1
DTD 09/01/2023 4.800% 04/01/2028
3137HAMR4 3,679,313.21 AA+ Aaa 09/20/23 09/28/23 3,621,573.75 5.19 14,717.25 3,622,618.48 3,578,726.34 FHMS K506 A1
DTD 09/01/2023 4.650% 05/01/2028
3137HAMG8 1,898,364.86 AA+ Aaa 09/07/23 09/14/23 1,869,974.81 5.01 7,356.16 1,870,688.45 1,828,826.12 FHMS KJ46 A1
DTD 07/01/2023 4.777% 06/01/2028
3137HAD45 2,810,600.81 AA+ Aaa 07/19/23 07/27/23 2,810,530.54 4.78 11,188.53 2,810,534.39 2,746,668.38 FHMS K505 A2
DTD 07/01/2023 4.819% 06/01/2028
3137HACX2 3,500,000.00 AA+ Aaa 07/13/23 07/20/23 3,534,958.00 4.59 14,055.42 3,532,913.21 3,401,559.25 FNA 2023-M6 A2
DTD 07/01/2023 4.190% 07/01/2028
3136BQDE6 3,500,000.00 AA+ Aaa 07/18/23 07/31/23 3,440,664.06 4.58 12,220.83 3,443,734.87 3,311,689.19 FHMS KJ47 A1
DTD 09/01/2023 5.272% 08/01/2028
3137HAMN3 2,152,074.29 AA+ Aaa 09/19/23 09/28/23 2,152,063.53 5.27 9,454.78 2,152,063.71 2,133,517.64 FHMS K506 A2
DTD 09/01/2023 4.650% 08/01/2028
3137HAMH6 3,800,000.00 AA+ Aaa 09/07/23 09/14/23 3,743,786.60 4.99 14,725.00 3,745,119.25 3,651,142.14 FHMS K508 A2
DTD 10/01/2023 4.740% 08/01/2028
3137HAQ74 3,850,000.00 AA+ Aaa 10/11/23 10/19/23 3,765,546.40 5.26 15,207.50 3,766,089.49 3,720,729.32 FHMS K509 A2
DTD 10/01/2023 4.850% 09/01/2028
3137HAST4 2,890,000.00 AA+ AAA 10/25/23 10/31/23 2,797,858.13 5.60 11,680.42 2,797,902.73 2,797,858.13 CITY OF MODESTO - COMBINED PORTFOLIO Page 11
#7..
- 377 -
Managed Account Detail of Securities Held For the Month Ending October 31, 2023 CITY OF MODESTO - Combined Portfolio
Dated Date/Coupon/Maturity CUSIP Rating Rating Date Date Cost at Cost Interest Cost Value Security Type/Description S&P Moody's Trade Settle Original YTM Accrued Amortized Market Par
Federal Agency Commercial Mortgage-Backed Security
FHMS K507 A2
DTD 09/01/2023 4.800% 09/01/2028
3137HAMS2 3,800,000.00 AA+ Aaa 09/20/23 09/28/23 3,754,578.60 5.07 15,200.00 3,755,324.69 3,687,470.26 Security Type Sub-Total 44,548,859.31 43,516,949.79 4.95 159,856.40 43,547,112.96 42,723,718.87 Federal Agency Bond / Note

FANNIE MAE NOTES
DTD 01/10/2020 1.625% 01/07/2025
3135G0X24 3,500,000.00 AA+ Aaa 03/04/20 03/05/20 3,628,135.00 0.85 18,010.42 3,531,363.74 3,351,302.50

FREDDIE MAC NOTES
DTD 02/14/2020 1.500% 02/12/2025
3137EAEP0 640,000.00 AA+ Aaa 02/27/20 02/28/20 649,676.80 1.18 2,106.67 642,506.03 609,977.60

FEDERAL HOME LOAN BANK NOTES
DTD 04/16/2020 0.500% 04/14/2025
3130AJHU6 2,370,000.00 AA+ Aaa 04/15/20 04/16/20 2,358,244.80 0.60 559.58 2,366,584.29 2,213,030.16

FANNIE MAE NOTES
DTD 04/24/2020 0.625% 04/22/2025
3135G03U5 475,000.00 AA+ Aaa 04/29/20 04/30/20 475,731.50 0.59 74.22 475,216.47 443,845.70

FANNIE MAE NOTES
DTD 04/24/2020 0.625% 04/22/2025
3135G03U5 1,910,000.00 AA+ Aaa 06/03/20 06/05/20 1,919,779.20 0.52 298.44 1,912,952.42 1,784,726.92

FANNIE MAE NOTES
DTD 04/24/2020 0.625% 04/22/2025
3135G03U5 3,195,000.00 AA+ Aaa 04/22/20 04/24/20 3,188,418.30 0.67 499.22 3,193,058.69 2,985,446.34

FANNIE MAE NOTES
DTD 04/24/2020 0.625% 04/22/2025
3135G03U5 3,345,000.00 AA+ Aaa 05/01/20 05/04/20 3,347,475.30 0.61 522.66 3,345,734.13 3,125,608.14

FANNIE MAE NOTES
DTD 06/19/2020 0.500% 06/17/2025
3135G04Z3 200,000.00 AA+ Aaa 09/17/20 09/18/20 200,712.00 0.42 372.22 200,244.04 185,282.80

FANNIE MAE NOTES
DTD 06/19/2020 0.500% 06/17/2025
3135G04Z3 1,075,000.00 AA+ Aaa 10/01/20 10/05/20 1,080,041.75 0.40 2,000.69 1,076,745.22 995,895.05

FANNIE MAE NOTES
DTD 06/19/2020 0.500% 06/17/2025
3135G04Z3 1,190,000.00 AA+ Aaa 01/04/21 01/05/21 1,197,223.30 0.36 2,214.72 1,192,642.02 1,102,432.66

FANNIE MAE NOTES
DTD 06/19/2020 0.500% 06/17/2025
3135G04Z3 3,675,000.00 AA+ Aaa 06/17/20 06/19/20 3,667,392.75 0.54 6,839.58 3,672,522.64 3,404,571.45

FANNIE MAE NOTES
DTD 06/19/2020 0.500% 06/17/2025
3135G04Z3 3,820,000.00 AA+ Aaa 10/02/20 10/05/20 3,836,311.40 0.41 7,109.45 3,825,646.25 3,538,901.48 CITY OF MODESTO - COMBINED PORTFOLIO Page 12
#7..
- 378 -
Managed Account Detail of Securities Held For the Month Ending October 31, 2023 CITY OF MODESTO - Combined Portfolio
Dated Date/Coupon/Maturity CUSIP Rating Rating Date Date Cost at Cost Interest Cost Value Security Type/Description S&P Moody's Trade Settle Original YTM Accrued Amortized Market Par
Federal Agency Bond / Note

FREDDIE MAC NOTES
DTD 07/23/2020 0.375% 07/21/2025
3137EAEU9 2,220,000.00 AA+ Aaa 07/21/20 07/23/20 2,208,944.40 0.48 2,312.50 2,216,193.58 2,044,779.84

FANNIE MAE NOTES
DTD 08/27/2020 0.375% 08/25/2025
3135G05X7 450,000.00 AA+ Aaa 10/22/20 10/23/20 447,480.00 0.49 309.37 449,054.47 412,697.70

FANNIE MAE NOTES
DTD 08/27/2020 0.375% 08/25/2025
3135G05X7 550,000.00 AA+ Aaa 10/15/20 10/16/20 548,289.50 0.44 378.12 549,360.73 504,408.30

FANNIE MAE NOTES
DTD 08/27/2020 0.375% 08/25/2025
3135G05X7 2,360,000.00 AA+ Aaa 08/25/20 08/27/20 2,348,955.20 0.47 1,622.50 2,355,985.36 2,164,370.16

FREDDIE MAC NOTES
DTD 09/25/2020 0.375% 09/23/2025
3137EAEX3 130,000.00 AA+ Aaa 09/29/20 09/30/20 129,829.70 0.40 51.46 129,935.21 118,872.26

FREDDIE MAC NOTES
DTD 09/25/2020 0.375% 09/23/2025
3137EAEX3 3,400,000.00 AA+ Aaa 09/23/20 09/25/20 3,389,766.00 0.44 1,345.83 3,396,117.36 3,108,966.80

FANNIE MAE NOTES
DTD 11/12/2020 0.500% 11/07/2025
3135G06G3 2,040,000.00 AA+ Aaa 11/19/20 11/24/20 2,039,224.80 0.51 4,930.00 2,039,684.18 1,860,480.00

FANNIE MAE NOTES
DTD 11/12/2020 0.500% 11/07/2025
3135G06G3 2,215,000.00 AA+ Aaa 11/09/20 11/12/20 2,207,070.30 0.57 5,352.92 2,211,790.67 2,020,080.00 Security Type Sub-Total 38,760,000.00 38,868,702.00 0.56 56,910.57 38,783,337.50 35,975,675.86 Corporate Note

US BANK NA CINCINNATI CORP NOTES
(CALLAB
DTD 02/04/2019 3.375% 02/05/2024
91159HHV5 2,860,000.00 A A3 07/19/19 07/23/19 2,995,535.40 2.27 23,058.75 2,865,414.75 2,839,081.96

PFIZER INC CORP NOTES
DTD 03/11/2019 2.950% 03/15/2024
717081ES8 3,445,000.00 A+ A1 04/02/19 04/04/19 3,486,374.45 2.69 12,985.74 3,447,466.64 3,410,467.32 AMAZON.COM INC CORPORATE NOTES
DTD 05/12/2021 0.450% 05/12/2024
023135BW5 1,590,000.00 AA A1 05/10/21 05/12/21 1,587,678.60 0.50 3,358.88 1,589,591.21 1,546,942.80

JP MORGAN CHASE BANK CORP NOTE
DTD 05/13/2014 3.625% 05/13/2024
46625HJX9 1,320,000.00 A- A1 09/22/20 09/24/20 1,461,028.80 0.65 22,330.00 1,340,617.62 1,303,470.96 CITY OF MODESTO - COMBINED PORTFOLIO Page 13
#7..
- 379 -
Managed Account Detail of Securities Held For the Month Ending October 31, 2023 CITY OF MODESTO - Combined Portfolio
Dated Date/Coupon/Maturity CUSIP Rating Rating Date Date Cost at Cost Interest Cost Value Security Type/Description S&P Moody's Trade Settle Original YTM Accrued Amortized Market Par
Corporate Note

WALMART INC CORPORATE NOTES
DTD 04/23/2019 2.850% 07/08/2024
931142EL3 4,000,000.00 AA Aa2 07/10/19 07/12/19 4,124,840.00 2.19 35,783.33 4,015,317.79 3,921,988.00

PACCAR FINANCIAL CORP CORPORATE
NOTES
DTD 02/06/2020 1.800% 02/06/2025
69371RQ66 1,810,000.00 A+ A1 05/11/20 05/13/20 1,839,014.30 1.45 7,692.50 1,817,765.10 1,728,531.90

MASTERCARD INC CORP NOTES (CALLABLE)
DTD 12/03/2019 2.000% 03/03/2025
57636QAN4 1,760,000.00 A+ Aa3 05/04/20 05/06/20 1,836,225.60 1.08 5,671.11 1,780,221.32 1,682,315.36 AMAZON.COM INC CORPORATE NOTES
DTD 04/13/2022 3.000% 04/13/2025
023135CE4 3,430,000.00 AA A1 04/11/22 04/13/22 3,424,546.30 3.06 5,145.00 3,427,367.69 3,314,611.37

JPMORGAN CHASE & CO (CALLABLE) CORP
NOTE
DTD 06/01/2021 0.824% 06/01/2025
46647PCH7 865,000.00 A- A1 05/24/21 06/01/21 865,000.00 0.82 2,969.83 865,000.00 835,654.88

BRISTOL-MYERS SQUIBB CO CORPORATE
NOTES
DTD 11/13/2020 0.750% 11/13/2025
110122DN5 2,230,000.00 A+ A2 06/23/21 06/25/21 2,210,888.90 0.95 7,805.00 2,221,136.36 2,033,628.43

BANK OF NY MELLON CORP (CALLABLE)
CORPOR
DTD 01/28/2021 0.750% 01/28/2026
06406RAQ0 3,465,000.00 A A1 02/02/21 02/04/21 3,465,831.60 0.75 6,713.44 3,465,366.50 3,106,521.50

BANK OF AMERICA CORP NOTES
(CALLABLE)
DTD 03/22/2022 3.384% 04/02/2026
06051GKM0 2,025,000.00 A- A1 03/17/22 03/22/22 2,025,000.00 3.38 5,520.15 2,025,000.00 1,941,896.03

MICROSOFT CORP (CALLABLE) NOTES
DTD 08/08/2016 2.400% 08/08/2026
594918BR4 3,000,000.00 AAA Aaa 02/23/22 02/25/22 3,033,150.00 2.14 16,600.00 3,019,872.70 2,788,593.00

BANK OF AMERICA NA CORPORATE NOTES
DTD 08/18/2023 5.526% 08/18/2026
06428CAA2 3,750,000.00 A+ Aa1 08/15/23 08/18/23 3,749,700.00 5.53 42,020.63 3,749,720.53 3,707,572.50

MASTERCARD INC CORP NOTES (CALLABLE)
DTD 11/21/2016 2.950% 11/21/2026
57636QAG9 2,560,000.00 A+ Aa3 12/20/22 12/22/22 2,434,099.20 4.33 33,564.44 2,461,744.55 2,385,154.56

TARGET CORP CORP NOTES (CALLABLE)
DTD 01/24/2022 1.950% 01/15/2027
87612EBM7 365,000.00 A A2 01/19/22 01/24/22 364,379.50 1.99 2,095.71 364,600.11 328,739.08 CITY OF MODESTO - COMBINED PORTFOLIO Page 14
#7..
- 380 -
Managed Account Detail of Securities Held For the Month Ending October 31, 2023 CITY OF MODESTO - Combined Portfolio
Dated Date/Coupon/Maturity CUSIP Rating Rating Date Date Cost at Cost Interest Cost Value Security Type/Description S&P Moody's Trade Settle Original YTM Accrued Amortized Market Par
Corporate Note

MICROSOFT CORP CORP NOTES (CALLABLE)
DTD 02/06/2017 3.300% 02/06/2027
594918BY9 3,000,000.00 AAA Aaa 12/14/22 12/16/22 2,914,170.00 4.06 23,375.00 2,932,323.07 2,833,875.00

HOME DEPOT INC CORP NOTES (CALLABLE)
DTD 09/14/2017 2.800% 09/14/2027
437076BT8 3,610,000.00 A A2 01/26/23 01/30/23 3,405,674.00 4.16 13,196.56 3,438,961.71 3,283,276.95

JPMORGAN CHASE CORP NOTES (CALLABLE)
DTD 02/24/2022 2.947% 02/24/2028
46647PCW4 1,535,000.00 A- A1 09/14/23 09/18/23 1,403,557.95 5.13 8,419.01 1,407,127.98 1,381,929.80

WALMART INC CORPORATE NOTES
(CALLABLE)
DTD 04/18/2023 3.900% 04/15/2028
931142FB4 1,220,000.00 AA Aa2 05/16/23 05/18/23 1,217,279.40 3.95 2,114.67 1,217,532.66 1,154,051.68

APPLE INC CORP NOTES CALLABLE
DTD 05/10/2023 4.000% 05/10/2028
037833ET3 5,200,000.00 AA+ Aaa 05/16/23 05/18/23 5,216,380.00 3.93 98,800.00 5,214,850.96 4,948,054.80

JOHN DEERE CAPITAL CORP CORPORATE
NOTES
DTD 07/14/2023 4.950% 07/14/2028
24422EXB0 495,000.00 A A2 07/13/23 07/14/23 501,732.00 4.64 7,282.69 501,326.68 482,160.20

JOHN DEERE CAPITAL CORP CORPORATE
NOTES
DTD 07/14/2023 4.950% 07/14/2028
24422EXB0 895,000.00 A A2 07/14/23 07/18/23 903,690.45 4.73 13,167.69 903,185.14 871,784.59

JOHN DEERE CAPITAL CORP CORPORATE
NOTES
DTD 07/14/2023 4.950% 07/14/2028
24422EXB0 1,165,000.00 A A2 07/11/23 07/14/23 1,163,264.15 4.98 17,140.06 1,163,368.66 1,134,781.07

PACCAR FINANCIAL CORP CORPORATE
NOTES
DTD 08/10/2023 4.950% 08/10/2028
69371RS64 1,130,000.00 A+ A1 08/17/23 08/21/23 1,122,914.90 5.09 12,585.38 1,123,195.81 1,108,924.37

TOYOTA MOTOR CREDIT CORP CORPORATE
NOTES
DTD 09/11/2023 5.250% 09/11/2028
89236TLB9 2,800,000.00 A+ A1 09/06/23 09/11/23 2,795,128.00 5.29 20,416.67 2,795,247.92 2,750,042.40

CITIBANK NA CORP NOTES (CALLABLE)
DTD 09/29/2023 5.803% 09/29/2028
17325FBB3 5,650,000.00 A+ Aa3 09/26/23 09/29/23 5,650,000.00 5.80 29,143.96 5,650,000.00 5,581,290.35 Security Type Sub-Total 65,175,000.00 65,197,083.50 3.37 478,956.20 64,803,323.46 62,405,340.86 CITY OF MODESTO - COMBINED PORTFOLIO Page 15
#7..
- 381 -
Managed Account Detail of Securities Held For the Month Ending October 31, 2023 CITY OF MODESTO - Combined Portfolio
Dated Date/Coupon/Maturity CUSIP Rating Rating Date Date Cost at Cost Interest Cost Value Security Type/Description S&P Moody's Trade Settle Original YTM Accrued Amortized Market Par
Commercial Paper

THUNDER BAY FUNDING LLC COMM PAPER
DTD 08/02/2023 0.000% 02/27/2024
88602TBT9 10,630,000.00 A-1+ P-1 08/04/23 08/04/23 10,287,714.00 5.79 0.00 10,434,880.44 10,428,306.38

LMA AMERICAS LLC COMM PAPER
DTD 09/07/2023 0.000% 03/08/2024
53944QC81 10,757,000.00 A-1 P-1 09/07/23 09/07/23 10,449,690.44 5.79 0.00 10,542,051.24 10,537,481.90 Security Type Sub-Total 21,387,000.00 20,737,404.44 5.79 0.00 20,976,931.68 20,965,788.28 Certificate of Deposit

TORONTO DOMINION BANK NY CERT
DEPOS
DTD 10/31/2022 5.470% 10/25/2024
89115B6F2 3,355,000.00 A A1 10/27/22 10/31/22 3,355,000.00 5.44 3,568.42 3,355,000.00 3,355,000.00

COOPERAT RABOBANK UA/NY CERT DEPOS
DTD 07/20/2023 5.080% 07/17/2026
21684LGS5 3,500,000.00 A+ Aa2 07/17/23 07/20/23 3,500,000.00 5.08 49,882.78 3,500,000.00 3,428,596.50 Security Type Sub-Total 6,855,000.00 6,855,000.00 5.26 53,451.20 6,855,000.00 6,783,596.50 Bank Note

WELLS FARGO BANK NA BANK NOTES
(CALLABLE
DTD 08/09/2023 5.450% 08/07/2026
94988J6D4 5,635,000.00 A+ Aa2 08/15/23 08/17/23 5,621,645.05 5.54 69,952.26 5,622,579.65 5,580,109.47 Security Type Sub-Total 5,635,000.00 5,621,645.05 5.54 69,952.26 5,622,579.65 5,580,109.47 Asset-Backed Security
HAROT 2021-1 A3
DTD 02/24/2021 0.270% 04/21/2025
43813GAC5 155,689.14 NR Aaa 02/17/21 02/24/21 155,686.28 0.27 11.68 155,688.13 153,286.86 HART 2021-A A3
DTD 04/28/2021 0.380% 09/15/2025
44933LAC7 195,649.29 AAA NR 04/20/21 04/28/21 195,628.71 0.38 33.04 195,640.50 192,012.21 CARMX 2021-1 A3
DTD 01/27/2021 0.340% 12/15/2025
14316NAC3 130,538.05 AAA NR 01/20/21 01/27/21 130,512.25 0.34 19.73 130,526.84 127,697.41 TAOT 2021-C A3
DTD 09/27/2021 0.430% 01/15/2026
89239BAC5 676,652.10 AAA Aaa 09/21/21 09/27/21 676,598.16 0.43 129.32 676,624.43 654,680.12 CITY OF MODESTO - COMBINED PORTFOLIO Page 16
#7..
- 382 -
Managed Account Detail of Securities Held For the Month Ending October 31, 2023 CITY OF MODESTO - Combined Portfolio
Dated Date/Coupon/Maturity CUSIP Rating Rating Date Date Cost at Cost Interest Cost Value Security Type/Description S&P Moody's Trade Settle Original YTM Accrued Amortized Market Par
Asset-Backed Security
CARMX 2021-2 A3
DTD 04/21/2021 0.520% 02/17/2026
14314QAC8 370,626.28 AAA NR 04/13/21 04/21/21 370,546.41 0.52 85.66 370,588.27 360,590.28 HART 2021-C A3
DTD 11/17/2021 0.740% 05/15/2026
44935FAD6 371,550.52 AAA NR 11/09/21 11/17/21 371,467.59 0.75 122.20 371,503.69 359,008.46 DCENT 2021-A1 A1
DTD 09/27/2021 0.580% 09/15/2026
254683CP8 775,000.00 AAA Aaa 09/20/21 09/27/21 774,834.07 0.58 199.78 774,904.05 739,090.14 KCOT 2023-2A A3
DTD 07/26/2023 5.280% 01/18/2028
500945AC4 890,000.00 NR Aaa 07/18/23 07/26/23 889,775.19 5.29 2,088.53 889,788.65 877,447.71 BAAT 2023-1A A3
DTD 07/31/2023 5.530% 02/15/2028
06428AAC2 1,465,000.00 NR Aaa 07/25/23 07/31/23 1,464,944.48 5.53 3,600.64 1,464,947.59 1,453,499.60 HAROT 2023-3 A3
DTD 08/22/2023 5.410% 02/18/2028
43815QAC1 2,220,000.00 AAA NR 08/15/23 08/22/23 2,219,542.24 5.42 4,337.02 2,219,562.05 2,203,685.00 TAOT 2023-C A3
DTD 08/15/2023 5.160% 04/17/2028
89231FAD2 690,000.00 AAA NR 08/08/23 08/15/23 689,843.92 5.17 1,582.40 689,851.05 682,156.77 USAOT 2023-A A3
DTD 09/15/2023 5.580% 05/15/2028
90291VAC4 3,015,000.00 AAA Aaa 09/07/23 09/15/23 3,014,472.38 5.58 7,477.20 3,014,485.19 2,999,347.02 FITAT 2023-1 A3
DTD 08/23/2023 5.530% 08/15/2028
31680EAD3 2,425,000.00 AAA Aaa 08/15/23 08/23/23 2,424,849.65 5.53 5,960.11 2,424,855.44 2,414,075.13 CHAIT 2023-A1 A
DTD 09/15/2023 5.160% 09/15/2028
161571HT4 3,020,000.00 AAA NR 09/07/23 09/15/23 3,019,162.86 5.17 6,925.87 3,019,181.86 2,991,524.42 AMXCA 2023-3 A
DTD 09/19/2023 5.230% 09/15/2028
02582JKD1 3,090,000.00 AAA NR 09/12/23 09/19/23 3,089,861.88 5.23 7,182.53 3,089,864.75 3,061,818.27 Security Type Sub-Total 19,490,705.38 19,487,726.07 4.72 39,755.71 19,488,012.49 19,269,919.40 Managed Account Sub-Total 443,091,564.69 432,439,433.87 3.17 1,581,137.15 435,148,752.88 416,490,933.98 CITY OF MODESTO - COMBINED PORTFOLIO Page 17
#7..
- 383 -
Managed Account Detail of Securities Held For the Month Ending October 31, 2023 CITY OF MODESTO - Combined Portfolio
$443,091,564.69 $432,439,433.87 3.17% $1,581,137.15 $435,148,752.88 $416,490,933.98 $418,072,071.13
$1,581,137.15
Total Investments
Accrued Interest
Securities Sub-Total
CITY OF MODESTO - COMBINED PORTFOLIO Page 18
#7..
- 384 -
Managed Account Fair Market Value & Analytics For the Month Ending October 31, 2023 CITY OF MODESTO - Combined Portfolio
Dated Date/Coupon/Maturity CUSIP Par Broker Date Price Value On Cost Amort Cost at Mkt Security Type/Description Next Call Market Market Unreal G/L Unreal G/L Effective YTM Duration
U.S. Treasury Bond / Note
US TREASURY NOTES 912828U57 10,480,000.00 RBS 99.73 10,452,163.02 86,378.64 (687.37) DTD 11/30/2016 2.125% 11/30/2023

0.08 5.33
US TREASURY NOTES 912828WJ5 10,565,000.00 RBS 98.41 10,396,620.31 10,730.08 (2,787.64) DTD 05/15/2014 2.500% 05/15/2024

0.53 5.53
US TREASURY NOTES 9128283J7 2,255,000.00 HSBC 96.55 2,177,132.14 (207,618.45) (116,991.13) DTD 11/30/2017 2.125% 11/30/2024

1.07 5.45
US TREASURY NOTES 91282CDN8 4,445,000.00 BNP_PAR 95.25 4,233,862.50 (18,057.81) (130,605.79) DTD 12/15/2021 1.000% 12/15/2024

1.12 5.42
US TREASURY NOTES 91282CDZ1 2,300,000.00 BNP_PAR 95.27 2,191,109.26 7,906.13 (13,678.09) DTD 02/15/2022 1.500% 02/15/2025

1.28 5.34
US TREASURY NOTES 91282CDZ1 4,400,000.00 RBS 95.27 4,191,687.28 (63,422.10) (142,869.30) DTD 02/15/2022 1.500% 02/15/2025

1.28 5.34
US TREASURY NOTES 912828ZL7 4,945,000.00 JPM_CHA 93.06 4,601,940.63 (292,836.71) (324,290.33) DTD 04/30/2020 0.375% 04/30/2025

1.50 5.24
US TREASURY NOTES 912828XZ8 4,230,000.00 BARCLAY 96.16 4,067,409.38 (164,738.67) (163,695.59) DTD 07/02/2018 2.750% 06/30/2025

1.62 5.19
US TREASURY NOTES 91282CAJ0 4,340,000.00 WELLS_F 91.56 3,973,812.50 (317,701.56) (344,359.04) DTD 08/31/2020 0.250% 08/31/2025

1.83 5.13
US TREASURY NOTES 91282CAJ0 4,635,000.00 BNP_PAR 91.56 4,243,921.88 (19,010.74) (190,665.01) DTD 08/31/2020 0.250% 08/31/2025

1.83 5.13
US TREASURY NOTES 91282CAM3 1,100,000.00 BNP_PAR 91.28 1,004,093.75 (71,929.69) (84,450.60) DTD 09/30/2020 0.250% 09/30/2025

1.91 5.08
US TREASURY NOTES 91282CAM3 4,550,000.00 HSBC 91.28 4,153,296.88 (320,277.34) (360,656.14) DTD 09/30/2020 0.250% 09/30/2025

1.91 5.08
US TREASURY NOTES 91282CAT8 5,010,000.00 HSBC 90.92 4,555,186.19 (339,153.26) (403,487.24) DTD 10/31/2020 0.250% 10/31/2025

2.00 5.08
US TREASURY NOTES 91282CAT8 6,930,000.00 TD 90.92 6,300,886.28 (482,392.63) (557,036.74) DTD 10/31/2020 0.250% 10/31/2025

2.00 5.08
US TREASURY NOTES 91282CAZ4 4,250,000.00 WELLS_F 90.84 3,860,859.38 (272,431.64) (329,571.23) DTD 11/30/2020 0.375% 11/30/2025

2.07 5.06
US TREASURY NOTES 91282CAZ4 4,635,000.00 WELLS_F 90.84 4,210,607.81 (44,177.35) (207,615.54) DTD 11/30/2020 0.375% 11/30/2025

2.07 5.06
US TREASURY NOTES 91282CBC4 500,000.00 HSBC 90.61 453,046.90 (45,566.38) (46,340.65) DTD 12/31/2020 0.375% 12/31/2025

2.16 5.00
CITY OF MODESTO - COMBINED PORTFOLIO Page 19
#7..
- 385 -
Managed Account Fair Market Value & Analytics For the Month Ending October 31, 2023 CITY OF MODESTO - Combined Portfolio
Dated Date/Coupon/Maturity CUSIP Par Broker Date Price Value On Cost Amort Cost at Mkt Security Type/Description Next Call Market Market Unreal G/L Unreal G/L Effective YTM Duration
U.S. Treasury Bond / Note
US TREASURY NOTES 91282CBC4 1,040,000.00 CITIGRP 90.61 942,337.55 (93,640.58) (95,912.56) DTD 12/31/2020 0.375% 12/31/2025

2.16 5.00
US TREASURY NOTES 91282CBC4 3,735,000.00 JPM_CHA 90.61 3,384,260.35 (262,179.30) (310,224.19) DTD 12/31/2020 0.375% 12/31/2025

2.16 5.00
US TREASURY NOTES 91282CBH3 2,400,000.00 BNP_PAR 90.23 2,165,625.12 (188,249.88) (211,657.83) DTD 01/31/2021 0.375% 01/31/2026

2.24 5.02
US TREASURY NOTES 91282CBH3 5,000,000.00 NOMURA 90.23 4,511,719.00 (207,812.25) (328,512.94) DTD 01/31/2021 0.375% 01/31/2026

2.24 5.02
US TREASURY NOTES 91282CBH3 5,775,000.00 MORGAN_ 90.23 5,211,035.45 (359,132.52) (450,659.08) DTD 01/31/2021 0.375% 01/31/2026

2.24 5.02
US TREASURY NOTES 91282CBH3 7,980,000.00 JPM_CHA 90.23 7,200,703.52 (56,108.98) (344,749.60) DTD 01/31/2021 0.375% 01/31/2026

2.24 5.02
US TREASURY NOTES 9128286F2 3,210,000.00 GOLDMAN 94.56 3,035,456.25 (457,425.00) (306,296.66) DTD 02/28/2019 2.500% 02/28/2026

2.27 5.00
US TREASURY NOTES 91282CBQ3 4,645,000.00 NOMURA 90.20 4,189,934.92 (70,038.13) (225,077.09) DTD 02/28/2021 0.500% 02/28/2026

2.32 5.00
US TREASURY NOTES 91282CBQ3 6,000,000.00 WELLS_F 90.20 5,412,187.20 (426,094.05) (498,783.70) DTD 02/28/2021 0.500% 02/28/2026

2.32 5.00
US TREASURY NOTES 91282CBT7 2,480,000.00 WELLS_F 90.58 2,246,337.38 (232,693.87) (233,149.72) DTD 03/31/2021 0.750% 03/31/2026

2.40 4.94
US TREASURY NOTES 91282CBT7 4,925,000.00 MORGAN_ 90.58 4,460,972.41 (435,747.32) (450,155.14) DTD 03/31/2021 0.750% 03/31/2026

2.40 4.94
US TREASURY NOTES 91282CCF6 1,405,000.00 MERRILL 89.92 1,263,402.41 (133,584.70) (137,406.51) DTD 05/31/2021 0.750% 05/31/2026

2.55 4.96
US TREASURY NOTES 91282CCF6 4,615,000.00 NOMURA 89.92 4,149,894.77 (103,656.99) (240,363.16) DTD 05/31/2021 0.750% 05/31/2026

2.55 4.96
US TREASURY NOTES 91282CCF6 4,800,000.00 CITIGRP 89.92 4,316,250.24 (82,874.76) (223,856.95) DTD 05/31/2021 0.750% 05/31/2026

2.55 4.96
US TREASURY NOTES 91282CCW9 4,640,000.00 RBC 89.09 4,133,950.00 (124,156.25) (260,326.21) DTD 08/31/2021 0.750% 08/31/2026

2.80 4.92
US TREASURY NOTES 91282CCZ2 4,310,000.00 RBC 89.28 3,848,021.88 (120,376.95) (239,947.79) DTD 09/30/2021 0.875% 09/30/2026

2.88 4.86
US TREASURY NOTES 912828U24 4,545,000.00 RBC 91.89 4,176,428.68 (179,492.22) (239,097.04) DTD 11/15/2016 2.000% 11/15/2026

2.93 4.90
CITY OF MODESTO - COMBINED PORTFOLIO Page 20
#7..
- 386 -
Managed Account Fair Market Value & Analytics For the Month Ending October 31, 2023 CITY OF MODESTO - Combined Portfolio
Dated Date/Coupon/Maturity CUSIP Par Broker Date Price Value On Cost Amort Cost at Mkt Security Type/Description Next Call Market Market Unreal G/L Unreal G/L Effective YTM Duration
U.S. Treasury Bond / Note
US TREASURY NOTES 912828V98 9,220,000.00 JPM_CHA 92.09 8,491,043.75 (490,532.81) (558,775.15) DTD 02/15/2017 2.250% 02/15/2027

3.17 4.88
US TREASURY NOTES 91282CEF4 910,000.00 BARCLAY 92.63 842,887.50 (12,085.94) (23,773.00) DTD 03/31/2022 2.500% 03/31/2027

3.28 4.87
US TREASURY NOTES 912828ZN3 6,480,000.00 NOMURA 86.06 5,576,850.00 (214,650.00) (395,037.80) DTD 04/30/2020 0.500% 04/30/2027

3.47 4.88
US TREASURY NOTES 912828ZV5 5,545,000.00 WELLS_F 85.47 4,739,242.19 (181,512.11) (338,185.54) DTD 06/30/2020 0.500% 06/30/2027

3.63 4.88
US TREASURY NOTES 9128282R0 1,200,000.00 BNP_PAR 90.94 1,091,250.00 (51,375.00) (64,910.43) DTD 08/15/2017 2.250% 08/15/2027

3.63 4.90
US TREASURY NOTES 9128282R0 2,985,000.00 HSBC 90.94 2,714,484.38 (115,552.14) (151,716.01) DTD 08/15/2017 2.250% 08/15/2027

3.63 4.90
US TREASURY NOTES 91282CFM8 5,380,000.00 MERRILL 97.34 5,237,093.75 (107,810.16) (114,919.47) DTD 09/30/2022 4.125% 09/30/2027

3.64 4.88
US TREASURY NOTES 91282CFU0 2,715,000.00 NOMURA 97.28 2,641,185.94 (111,569.53) (104,643.47) DTD 10/31/2022 4.125% 10/31/2027

3.72 4.88
US TREASURY NOTES 91282CFU0 3,160,000.00 JPM_CHA 97.28 3,074,087.50 (155,407.81) (142,850.30) DTD 10/31/2022 4.125% 10/31/2027

3.72 4.88
US TREASURY NOTES 91282CAU5 8,775,000.00 WELLS_F 84.27 7,394,308.16 (78,495.55) (299,846.71) DTD 10/31/2020 0.500% 10/31/2027

3.96 4.88
US TREASURY NOTES 91282CGC9 4,250,000.00 NOMURA 96.31 4,093,281.25 (173,652.34) (172,141.50) DTD 12/31/2022 3.875% 12/31/2027

3.83 4.86
US TREASURY NOTES 91282CGH8 2,220,000.00 BNP_PAR 94.83 2,105,184.26 (113,081.37) (113,249.86) DTD 01/31/2023 3.500% 01/31/2028

3.94 4.86
US TREASURY NOTES 91282CBJ9 3,450,000.00 HSBC 84.36 2,910,398.61 (84,363.11) (152,673.78) DTD 01/31/2021 0.750% 01/31/2028

4.18 4.87
US TREASURY NOTES 91282CGP0 2,825,000.00 TD 96.70 2,731,863.14 (61,797.02) (65,912.53) DTD 02/28/2023 4.000% 02/29/2028

3.99 4.85
US TREASURY NOTES 91282CGP0 2,970,000.00 JPM_CHA 96.70 2,872,082.66 (59,052.11) (64,174.38) DTD 02/28/2023 4.000% 02/29/2028

3.99 4.85
US TREASURY NOTES 91282CBS9 2,555,000.00 BNP_PAR 85.77 2,191,311.59 (108,088.61) (133,248.32) DTD 03/31/2021 1.250% 03/31/2028

4.29 4.87
US TREASURY NOTES 91282CGT2 2,675,000.00 RBS 95.17 2,545,847.79 (126,330.92) (126,618.55) DTD 03/31/2023 3.625% 03/31/2028

4.10 4.85
CITY OF MODESTO - COMBINED PORTFOLIO Page 21
#7..
- 387 -
Managed Account Fair Market Value & Analytics For the Month Ending October 31, 2023 CITY OF MODESTO - Combined Portfolio
Dated Date/Coupon/Maturity CUSIP Par Broker Date Price Value On Cost Amort Cost at Mkt Security Type/Description Next Call Market Market Unreal G/L Unreal G/L Effective YTM Duration
U.S. Treasury Bond / Note
US TREASURY NOTES 91282CHA2 2,810,000.00 BARCLAY 94.63 2,658,962.50 (137,975.39) (139,291.62) DTD 04/30/2023 3.500% 04/30/2028

4.19 4.84
US TREASURY NOTES 91282CHA2 6,530,000.00 GOLDMAN 94.63 6,179,012.50 (380,831.64) (377,868.51) DTD 04/30/2023 3.500% 04/30/2028

4.19 4.84
Security Type Sub-Total 227,730,000.00 209,806,530.69 (8,851,726.79) (11,755,800.53) 2.49 5.04 U.S. Treasury Bill
US TREASURY BILL 912796YT0 2,345,000.00 MORGAN_ 99.99 2,344,655.05 10,303.86 (1.44) DTD 11/03/2022 0.000% 11/02/2023

0.01 2.65
Security Type Sub-Total 2,345,000.00 2,344,655.05 10,303.86 (1.44) 0.01 2.65 Supra-National Agency Bond / Note
INTL BK RECON & DEVELOP NOTES 459058JM6 1,790,000.00 TD 99.68 1,784,320.33 (1,831.17) (5,598.83) DTD 11/24/2020 0.250% 11/24/2023

0.07 5.02
INTER-AMERICAN DEVEL BK NOTES 4581X0DZ8 4,095,000.00 JPM_CHA 95.56 3,913,169.72 (178,799.98) (180,926.17) DTD 09/23/2021 0.500% 09/23/2024

0.90 5.64
Security Type Sub-Total 5,885,000.00 5,697,490.05 (180,631.15) (186,525.00) 0.64 5.45 Municipal Bond / Note
MD ST TXBL GO BONDS 574193TQ1 620,000.00 JPM_CHA 96.37 597,481.60 (22,344.80) (22,485.75) DTD 08/05/2020 0.510% 08/01/2024

0.75 5.50
CA ST UNIV TXBL REV BONDS 13077DMK5 600,000.00 GOLDMAN 95.32 571,890.00 (28,110.00) (28,110.00) DTD 09/17/2020 0.685% 11/01/2024

1.00 5.55
CA ST DEPT WTR RES WTR SYS TXBL REV 13067WRB0 100,000.00 MORGAN_ 94.75 94,745.00 (5,255.00) (5,255.00) BNDS
DTD 08/06/2020 0.560% 12/01/2024

1.08 5.61
UNIV OF CAL TXBL REV BONDS 91412HGE7 220,000.00 JPM_CHA 04/15/25 93.02 204,652.80 (16,143.60) (15,591.08) DTD 07/16/2020 0.883% 05/15/2025

1.45 5.67
UNIV OF CAL TXBL REV BONDS 91412HGE7 510,000.00 JPM_CHA 04/15/25 93.02 474,422.40 (35,577.60) (35,577.60) DTD 07/16/2020 0.883% 05/15/2025

1.45 5.67
CITY OF MODESTO - COMBINED PORTFOLIO Page 22
#7..
- 388 -
Managed Account Fair Market Value & Analytics For the Month Ending October 31, 2023 CITY OF MODESTO - Combined Portfolio
Dated Date/Coupon/Maturity CUSIP Par Broker Date Price Value On Cost Amort Cost at Mkt Security Type/Description Next Call Market Market Unreal G/L Unreal G/L Effective YTM Duration
Municipal Bond / Note
FL ST BOARD OF ADMIN TXBL REV BONDS 341271AD6 505,000.00 MERRILL 93.26 470,968.05 (37,602.30) (35,273.10) DTD 09/16/2020 1.258% 07/01/2025

1.65 5.54
FL ST BOARD OF ADMIN TXBL REV BONDS 341271AD6 1,295,000.00 MERRILL 93.26 1,207,729.95 (87,270.05) (87,270.05) DTD 09/16/2020 1.258% 07/01/2025

1.65 5.54
LOS ANGELES CCD, CA TXBL GO BONDS 54438CYK2 925,000.00 MERRILL 92.34 854,154.25 (70,845.75) (70,845.75) DTD 11/10/2020 0.773% 08/01/2025

1.74 5.41
NJ TURNPIKE AUTHORITY TXBL REV 646140DP5 505,000.00 CITIGRP 91.50 462,064.90 (42,935.10) (42,935.10) BONDS
DTD 02/04/2021 1.047% 01/01/2026

2.14 5.24
Security Type Sub-Total 5,280,000.00 4,938,108.95 (346,084.20) (343,343.43) 1.49 5.50 Federal Agency Commercial Mortgage-Backed Security
FANNIEMAE-ACES 3136AJB54 388,506.14 JPM_CHAS 99.02 384,706.24 (22,678.86) (5,288.08) DTD 04/01/2014 3.346% 03/01/2024

0.34 6.29
FHMS K061 A2 3137BTUM1 2,475,000.00 CITIGRP 94.49 2,338,649.33 (60,167.08) (69,924.88) DTD 01/30/2017 3.347% 11/01/2026

2.68 5.34
FHMS K064 A2 3137BXQY1 4,000,000.00 MORGAN_ 93.59 3,743,456.96 (29,668.04) (42,848.23) DTD 05/15/2017 3.224% 03/01/2027

2.99 5.33
FHLMC MULTIFAMILY STRUCTURED P 3137F1G44 2,275,000.00 CITIGRP 93.35 2,123,749.29 (21,238.01) (28,613.92) DTD 07/01/2017 3.243% 04/01/2027

3.13 5.38
FHLMC MULTIFAMILY STRUCTURED P 3137F2LJ3 3,530,000.00 CANT_FI 92.78 3,274,970.28 (26,131.28) (37,916.48) DTD 08/01/2017 3.117% 06/01/2027

3.23 5.33
FHMS K507 A1 3137HAMR4 3,679,313.21 MERRILL 97.27 3,578,726.34 (42,847.41) (43,892.14) DTD 09/01/2023 4.800% 04/01/2028

3.44 5.50
FHMS K506 A1 3137HAMG8 1,898,364.86 WELLS_F 96.34 1,828,826.12 (41,148.69) (41,862.33) DTD 09/01/2023 4.650% 05/01/2028

3.70 5.57
FHMS KJ46 A1 3137HAD45 2,810,600.81 JPM_CHA 97.73 2,746,668.38 (63,862.16) (63,866.01) DTD 07/01/2023 4.777% 06/01/2028

3.22 5.34
FHMS K505 A2 3137HACX2 3,500,000.00 JPM_CHA 97.19 3,401,559.25 (133,398.75) (131,353.96) DTD 07/01/2023 4.819% 06/01/2028

3.98 5.51
FNA 2023-M6 A2 3136BQDE6 3,500,000.00 JPM_CHA 94.62 3,311,689.19 (128,974.87) (132,045.68) DTD 07/01/2023 4.190% 07/01/2028

4.14 5.50
CITY OF MODESTO - COMBINED PORTFOLIO Page 23
#7..
- 389 -
Managed Account Fair Market Value & Analytics For the Month Ending October 31, 2023 CITY OF MODESTO - Combined Portfolio
Dated Date/Coupon/Maturity CUSIP Par Broker Date Price Value On Cost Amort Cost at Mkt Security Type/Description Next Call Market Market Unreal G/L Unreal G/L Effective YTM Duration
Federal Agency Commercial Mortgage-Backed Security
FHMS KJ47 A1 3137HAMN3 2,152,074.29 JPM_CHA 99.14 2,133,517.64 (18,545.89) (18,546.07) DTD 09/01/2023 5.272% 08/01/2028

3.42 5.48
FHMS K506 A2 3137HAMH6 3,800,000.00 WELLS_F 96.08 3,651,142.14 (92,644.46) (93,977.11) DTD 09/01/2023 4.650% 08/01/2028

4.11 5.59
FHMS K508 A2 3137HAQ74 3,850,000.00 BMO 96.64 3,720,729.32 (44,817.08) (45,360.17) DTD 10/01/2023 4.740% 08/01/2028

4.13 5.55
FHMS K509 A2 3137HAST4 2,890,000.00 MORGAN_ 96.81 2,797,858.13 0.00 (44.60) DTD 10/01/2023 4.850% 09/01/2028

4.36 5.60
FHMS K507 A2 3137HAMS2 3,800,000.00 MERRILL 97.04 3,687,470.26 (67,108.34) (67,854.43) DTD 09/01/2023 4.800% 09/01/2028

4.16 5.50
Security Type Sub-Total 44,548,859.31 42,723,718.87 (793,230.92) (823,394.09) 3.63 5.48 Federal Agency Bond / Note
FANNIE MAE NOTES 3135G0X24 3,500,000.00 CITIGRP 95.75 3,351,302.50 (276,832.50) (180,061.24) DTD 01/10/2020 1.625% 01/07/2025

1.17 5.37
FREDDIE MAC NOTES 3137EAEP0 640,000.00 WELLS_FA 95.31 609,977.60 (39,699.20) (32,528.43) DTD 02/14/2020 1.500% 02/12/2025

1.27 5.33
FEDERAL HOME LOAN BANK NOTES 3130AJHU6 2,370,000.00 CITIGRP 93.38 2,213,030.16 (145,214.64) (153,554.13) DTD 04/16/2020 0.500% 04/14/2025

1.45 5.29
FANNIE MAE NOTES 3135G03U5 475,000.00 WELLS_F 93.44 443,845.70 (31,885.80) (31,370.77) DTD 04/24/2020 0.625% 04/22/2025

1.47 5.30
FANNIE MAE NOTES 3135G03U5 1,910,000.00 HSBC 93.44 1,784,726.92 (135,052.28) (128,225.50) DTD 04/24/2020 0.625% 04/22/2025

1.47 5.30
FANNIE MAE NOTES 3135G03U5 3,195,000.00 CITIGRP 93.44 2,985,446.34 (202,971.96) (207,612.35) DTD 04/24/2020 0.625% 04/22/2025

1.47 5.30
FANNIE MAE NOTES 3135G03U5 3,345,000.00 WELLS_F 93.44 3,125,608.14 (221,867.16) (220,125.99) DTD 04/24/2020 0.625% 04/22/2025

1.47 5.30
FANNIE MAE NOTES 3135G04Z3 200,000.00 WELLS_F 92.64 185,282.80 (15,429.20) (14,961.24) DTD 06/19/2020 0.500% 06/17/2025

1.62 5.27
FANNIE MAE NOTES 3135G04Z3 1,075,000.00 NOMURA 92.64 995,895.05 (84,146.70) (80,850.17) DTD 06/19/2020 0.500% 06/17/2025

1.62 5.27
FANNIE MAE NOTES 3135G04Z3 1,190,000.00 RBS 92.64 1,102,432.66 (94,790.64) (90,209.36) DTD 06/19/2020 0.500% 06/17/2025

1.62 5.27
CITY OF MODESTO - COMBINED PORTFOLIO Page 24
#7..
- 390 -
Managed Account Fair Market Value & Analytics For the Month Ending October 31, 2023 CITY OF MODESTO - Combined Portfolio
Dated Date/Coupon/Maturity CUSIP Par Broker Date Price Value On Cost Amort Cost at Mkt Security Type/Description Next Call Market Market Unreal G/L Unreal G/L Effective YTM Duration
Federal Agency Bond / Note
FANNIE MAE NOTES 3135G04Z3 3,675,000.00 NOMURA 92.64 3,404,571.45 (262,821.30) (267,951.19) DTD 06/19/2020 0.500% 06/17/2025

1.62 5.27
FANNIE MAE NOTES 3135G04Z3 3,820,000.00 RBS 92.64 3,538,901.48 (297,409.92) (286,744.77) DTD 06/19/2020 0.500% 06/17/2025

1.62 5.27
FREDDIE MAC NOTES 3137EAEU9 2,220,000.00 WELLS_F 92.11 2,044,779.84 (164,164.56) (171,413.74) DTD 07/23/2020 0.375% 07/21/2025

1.72 5.22
FANNIE MAE NOTES 3135G05X7 450,000.00 NOMURA 91.71 412,697.70 (34,782.30) (36,356.77) DTD 08/27/2020 0.375% 08/25/2025

1.81 5.21
FANNIE MAE NOTES 3135G05X7 550,000.00 CITIGRP 91.71 504,408.30 (43,881.20) (44,952.43) DTD 08/27/2020 0.375% 08/25/2025

1.81 5.21
FANNIE MAE NOTES 3135G05X7 2,360,000.00 BARCLAY 91.71 2,164,370.16 (184,585.04) (191,615.20) DTD 08/27/2020 0.375% 08/25/2025

1.81 5.21
FREDDIE MAC NOTES 3137EAEX3 130,000.00 WELLS_F 91.44 118,872.26 (10,957.44) (11,062.95) DTD 09/25/2020 0.375% 09/23/2025

1.89 5.17
FREDDIE MAC NOTES 3137EAEX3 3,400,000.00 CITIGRP 91.44 3,108,966.80 (280,799.20) (287,150.56) DTD 09/25/2020 0.375% 09/23/2025

1.89 5.17
FANNIE MAE NOTES 3135G06G3 2,040,000.00 NOMURA 91.20 1,860,480.00 (178,744.80) (179,204.18) DTD 11/12/2020 0.500% 11/07/2025

2.01 5.14
FANNIE MAE NOTES 3135G06G3 2,215,000.00 BARCLAY 91.20 2,020,080.00 (186,990.30) (191,710.67) DTD 11/12/2020 0.500% 11/07/2025

2.01 5.14
Security Type Sub-Total 38,760,000.00 35,975,675.86 (2,893,026.14) (2,807,661.64) 1.62 5.26 Corporate Note
US BANK NA CINCINNATI CORP NOTES 91159HHV5 2,860,000.00 GOLDMAN 01/05/24 99.27 2,839,081.96 (156,453.44) (26,332.79) (CALLAB
DTD 02/04/2019 3.375% 02/05/2024

0.18 6.14
PFIZER INC CORP NOTES 717081ES8 3,445,000.00 BONY 02/15/24 99.00 3,410,467.32 (75,907.13) (36,999.32) DTD 03/11/2019 2.950% 03/15/2024

0.30 5.66
AMAZON.COM INC CORPORATE NOTES 023135BW5 1,590,000.00 JPM_CHA 97.29 1,546,942.80 (40,735.80) (42,648.41) DTD 05/12/2021 0.450% 05/12/2024

0.53 5.68
JP MORGAN CHASE BANK CORP NOTE 46625HJX9 1,320,000.00 JPM_CHA 98.75 1,303,470.96 (157,557.84) (37,146.66) DTD 05/13/2014 3.625% 05/13/2024

0.53 6.03
CITY OF MODESTO - COMBINED PORTFOLIO Page 25
#7..
- 391 -
Managed Account Fair Market Value & Analytics For the Month Ending October 31, 2023 CITY OF MODESTO - Combined Portfolio
Dated Date/Coupon/Maturity CUSIP Par Broker Date Price Value On Cost Amort Cost at Mkt Security Type/Description Next Call Market Market Unreal G/L Unreal G/L Effective YTM Duration
Corporate Note
WALMART INC CORPORATE NOTES 931142EL3 4,000,000.00 CITIGRP 06/08/24 98.05 3,921,988.00 (202,852.00) (93,329.79) DTD 04/23/2019 2.850% 07/08/2024

0.60 5.77
PACCAR FINANCIAL CORP CORPORATE 69371RQ66 1,810,000.00 MITSU 95.50 1,728,531.90 (110,482.40) (89,233.20) NOTES
DTD 02/06/2020 1.800% 02/06/2025

1.25 5.53
MASTERCARD INC CORP NOTES 57636QAN4 1,760,000.00 JSEB 02/03/25 95.59 1,682,315.36 (153,910.24) (97,905.96) (CALLABLE)
DTD 12/03/2019 2.000% 03/03/2025

1.24 5.45
AMAZON.COM INC CORPORATE NOTES 023135CE4 3,430,000.00 JPM_CHA 96.64 3,314,611.37 (109,934.93) (112,756.32) DTD 04/13/2022 3.000% 04/13/2025

1.43 5.44
JPMORGAN CHASE & CO (CALLABLE) CORP 46647PCH7 865,000.00 JPM_CHA 06/01/24 96.61 835,654.88 (29,345.12) (29,345.12) NOTE
DTD 06/01/2021 0.824% 06/01/2025

0.58 3.03
BRISTOL-MYERS SQUIBB CO CORPORATE 110122DN5 2,230,000.00 MERRILL 10/13/25 91.19 2,033,628.43 (177,260.47) (187,507.93) NOTES
DTD 11/13/2020 0.750% 11/13/2025

1.93 5.37
BANK OF NY MELLON CORP (CALLABLE) 06406RAQ0 3,465,000.00 US_BANC 12/28/25 89.65 3,106,521.50 (359,310.10) (358,845.00) CORPOR
DTD 01/28/2021 0.750% 01/28/2026

2.14 5.73
BANK OF AMERICA CORP NOTES 06051GKM0 2,025,000.00 MERRILL 04/02/25 95.90 1,941,896.03 (83,103.97) (83,103.97) (CALLABLE)
DTD 03/22/2022 3.384% 04/02/2026

1.40 5.21
MICROSOFT CORP (CALLABLE) NOTES 594918BR4 3,000,000.00 TD 05/08/26 92.95 2,788,593.00 (244,557.00) (231,279.70) DTD 08/08/2016 2.400% 08/08/2026

2.45 5.16
BANK OF AMERICA NA CORPORATE NOTES 06428CAA2 3,750,000.00 MERRILL 98.87 3,707,572.50 (42,127.50) (42,148.03) DTD 08/18/2023 5.526% 08/18/2026

2.60 5.97
MASTERCARD INC CORP NOTES 57636QAG9 2,560,000.00 CSFB 08/21/26 93.17 2,385,154.56 (48,944.64) (76,589.99) (CALLABLE)
DTD 11/21/2016 2.950% 11/21/2026

2.67 5.40
TARGET CORP CORP NOTES (CALLABLE) 87612EBM7 365,000.00 CITIGRP 12/15/26 90.07 328,739.08 (35,640.42) (35,861.03) DTD 01/24/2022 1.950% 01/15/2027

3.02 5.36
MICROSOFT CORP CORP NOTES 594918BY9 3,000,000.00 GOLDMAN 11/06/26 94.46 2,833,875.00 (80,295.00) (98,448.07) (CALLABLE)
DTD 02/06/2017 3.300% 02/06/2027

2.87 5.16
CITY OF MODESTO - COMBINED PORTFOLIO Page 26
#7..
- 392 -
Managed Account Fair Market Value & Analytics For the Month Ending October 31, 2023 CITY OF MODESTO - Combined Portfolio
Dated Date/Coupon/Maturity CUSIP Par Broker Date Price Value On Cost Amort Cost at Mkt Security Type/Description Next Call Market Market Unreal G/L Unreal G/L Effective YTM Duration
Corporate Note
HOME DEPOT INC CORP NOTES 437076BT8 3,610,000.00 TD 06/14/27 90.95 3,283,276.95 (122,397.05) (155,684.76) (CALLABLE)
DTD 09/14/2017 2.800% 09/14/2027

3.45 5.42
JPMORGAN CHASE CORP NOTES 46647PCW4 1,535,000.00 MERRILL 02/24/27 90.03 1,381,929.80 (21,628.15) (25,198.18) (CALLABLE)
DTD 02/24/2022 2.947% 02/24/2028

3.16 5.58
WALMART INC CORPORATE NOTES 931142FB4 1,220,000.00 BARCLAY 03/15/28 94.59 1,154,051.68 (63,227.72) (63,480.98) (CALLABLE)
DTD 04/18/2023 3.900% 04/15/2028

4.05 5.28
APPLE INC CORP NOTES CALLABLE 037833ET3 5,200,000.00 HSBC 04/10/28 95.15 4,948,054.80 (268,325.20) (266,796.16) DTD 05/10/2023 4.000% 05/10/2028

4.02 5.21
JOHN DEERE CAPITAL CORP CORPORATE 24422EXB0 495,000.00 SIEBERT 97.41 482,160.20 (19,571.80) (19,166.48) NOTES
DTD 07/14/2023 4.950% 07/14/2028

4.19 5.58
JOHN DEERE CAPITAL CORP CORPORATE 24422EXB0 895,000.00 TD 97.41 871,784.59 (31,905.86) (31,400.55) NOTES
DTD 07/14/2023 4.950% 07/14/2028

4.19 5.58
JOHN DEERE CAPITAL CORP CORPORATE 24422EXB0 1,165,000.00 CITIGRP 97.41 1,134,781.07 (28,483.08) (28,587.59) NOTES
DTD 07/14/2023 4.950% 07/14/2028

4.19 5.58
PACCAR FINANCIAL CORP CORPORATE 69371RS64 1,130,000.00 TD 98.13 1,108,924.37 (13,990.53) (14,271.44) NOTES
DTD 08/10/2023 4.950% 08/10/2028

4.26 5.40
TOYOTA MOTOR CREDIT CORP 89236TLB9 2,800,000.00 MERRILL 98.22 2,750,042.40 (45,085.60) (45,205.52)

CORPORATE NOTES
DTD 09/11/2023 5.250% 09/11/2028

4.32 5.68
CITIBANK NA CORP NOTES (CALLABLE) 17325FBB3 5,650,000.00 CITIGRP 08/29/28 98.78 5,581,290.35 (68,709.65) (68,709.65) DTD 09/29/2023 5.803% 09/29/2028

4.25 6.09
Security Type Sub-Total 65,175,000.00 62,405,340.86 (2,791,742.64) (2,397,982.60) 2.42 5.56 Commercial Paper
THUNDER BAY FUNDING LLC COMM PAPER 88602TBT9 10,630,000.00 GOLDMAN 98.10 10,428,306.38 140,592.38 (6,574.06) DTD 08/02/2023 0.000% 02/27/2024

0.34 5.85
CITY OF MODESTO - COMBINED PORTFOLIO Page 27
#7..
- 393 -
Managed Account Fair Market Value & Analytics For the Month Ending October 31, 2023 CITY OF MODESTO - Combined Portfolio
Dated Date/Coupon/Maturity CUSIP Par Broker Date Price Value On Cost Amort Cost at Mkt Security Type/Description Next Call Market Market Unreal G/L Unreal G/L Effective YTM Duration
Commercial Paper
LMA AMERICAS LLC COMM PAPER 53944QC81 10,757,000.00 JPM_CHA 97.96 10,537,481.90 87,791.46 (4,569.34) DTD 09/07/2023 0.000% 03/08/2024

0.37 5.81
Security Type Sub-Total 21,387,000.00 20,965,788.28 228,383.84 (11,143.40) 0.36 5.83 Certificate of Deposit
TORONTO DOMINION BANK NY CERT 89115B6F2 3,355,000.00 TD 100.00 3,355,000.00 0.00 0.00 DEPOS
DTD 10/31/2022 5.470% 10/25/2024

1.00 5.37
COOPERAT RABOBANK UA/NY CERT DEPOS 21684LGS5 3,500,000.00 RABOBAN 97.96 3,428,596.50 (71,403.50) (71,403.50) DTD 07/20/2023 5.080% 07/17/2026

2.53 5.90
Security Type Sub-Total 6,855,000.00 6,783,596.50 (71,403.50) (71,403.50) 1.77 5.64 Bank Note
WELLS FARGO BANK NA BANK NOTES 94988J6D4 5,635,000.00 WELLS_F 07/07/26 99.03 5,580,109.47 (41,535.58) (42,470.18) (CALLABLE
DTD 08/09/2023 5.450% 08/07/2026

2.58 5.83
Security Type Sub-Total 5,635,000.00 5,580,109.47 (41,535.58) (42,470.18) 2.58 5.83 Asset-Backed Security
HAROT 2021-1 A3 43813GAC5 155,689.14 JPM_CHA 98.46 153,286.86 (2,399.42) (2,401.27) DTD 02/24/2021 0.270% 04/21/2025

0.29 1.33
HART 2021-A A3 44933LAC7 195,649.29 BARCLAY 98.14 192,012.21 (3,616.50) (3,628.29) DTD 04/28/2021 0.380% 09/15/2025

0.32 1.38
CARMX 2021-1 A3 14316NAC3 130,538.05 MITSU 97.82 127,697.41 (2,814.84) (2,829.43) DTD 01/27/2021 0.340% 12/15/2025

0.38 1.38
TAOT 2021-C A3 89239BAC5 676,652.10 BARCLAY 96.75 654,680.12 (21,918.04) (21,944.31) DTD 09/27/2021 0.430% 01/15/2026

0.51 1.93
CARMX 2021-2 A3 14314QAC8 370,626.28 MERRILL 97.29 360,590.28 (9,956.13) (9,997.99) DTD 04/21/2021 0.520% 02/17/2026

0.43 1.72
HART 2021-C A3 44935FAD6 371,550.52 SMBC 96.62 359,008.46 (12,459.13) (12,495.23) DTD 11/17/2021 0.740% 05/15/2026

0.59 2.11
CITY OF MODESTO - COMBINED PORTFOLIO Page 28
#7..
- 394 -
Managed Account Fair Market Value & Analytics For the Month Ending October 31, 2023 CITY OF MODESTO - Combined Portfolio
Dated Date/Coupon/Maturity CUSIP Par Broker Date Price Value On Cost Amort Cost at Mkt Security Type/Description Next Call Market Market Unreal G/L Unreal G/L Effective YTM Duration
Asset-Backed Security
DCENT 2021-A1 A1 254683CP8 775,000.00 CITIGRP 95.37 739,090.14 (35,743.93) (35,813.91) DTD 09/27/2021 0.580% 09/15/2026

0.85 2.25
KCOT 2023-2A A3 500945AC4 890,000.00 JPM_CHA 98.59 877,447.71 (12,327.48) (12,340.94) DTD 07/26/2023 5.280% 01/18/2028

2.30 5.66
BAAT 2023-1A A3 06428AAC2 1,465,000.00 MERRILL 99.22 1,453,499.60 (11,444.88) (11,447.99) DTD 07/31/2023 5.530% 02/15/2028

1.97 5.74
HAROT 2023-3 A3 43815QAC1 2,220,000.00 MERRILL 99.27 2,203,685.00 (15,857.24) (15,877.05) DTD 08/22/2023 5.410% 02/18/2028

2.01 5.60
TAOT 2023-C A3 89231FAD2 690,000.00 BNP_PAR 98.86 682,156.77 (7,687.15) (7,694.28) DTD 08/15/2023 5.160% 04/17/2028

2.04 5.45
USAOT 2023-A A3 90291VAC4 3,015,000.00 JPM_CHA 99.48 2,999,347.02 (15,125.36) (15,138.17) DTD 09/15/2023 5.580% 05/15/2028

1.89 5.71
FITAT 2023-1 A3 31680EAD3 2,425,000.00 JPM_CHA 99.55 2,414,075.13 (10,774.52) (10,780.31) DTD 08/23/2023 5.530% 08/15/2028

2.06 5.64
CHAIT 2023-A1 A 161571HT4 3,020,000.00 JPM_CHA 99.06 2,991,524.42 (27,638.44) (27,657.44) DTD 09/15/2023 5.160% 09/15/2028

2.60 5.38
AMXCA 2023-3 A 02582JKD1 3,090,000.00 CITIGRP 99.09 3,061,818.27 (28,043.61) (28,046.48) DTD 09/19/2023 5.230% 09/15/2028

2.59 5.44
Security Type Sub-Total 19,490,705.38 19,269,919.40 (217,806.67) (218,093.09) 2.00 5.08 Managed Account Sub-Total 443,091,564.69 416,490,933.98 (15,948,499.89) (18,657,818.90) 2.33 5.24 Total Investments $418,072,071.13
$1,581,137.15
$416,490,933.98
Accrued Interest
Securities Sub-Total $443,091,564.69 ($15,948,499.89) ($18,657,818.90) 2.33 5.24% CITY OF MODESTO - COMBINED PORTFOLIO Page 29
#7..
- 395 -
Managed Account Security Transactions & Interest For the Month Ending October 31, 2023 CITY OF MODESTO - Combined Portfolio
Transaction Type
Trade Settle Security Description CUSIP Par Proceeds
Principal Accrued
Interest Total Cost
Realized G/L Realized G/L Sale
Amort Cost Method
BUY
10/02/23 US TREASURY BILL
DTD 11/03/2022 0.000% 11/02/2023
10/02/23 912796YT0 2,345,000.00 (2,334,351.19) 0.00 (2,334,351.19) 10/19/23 FHMS K508 A2
DTD 10/01/2023 4.740% 08/01/2028
10/11/23 3137HAQ74 3,850,000.00 (3,765,546.40) (9,124.50) (3,774,670.90) 10/13/23 US TREASURY BILL
DTD 04/20/2023 0.000% 10/19/2023
10/12/23 912797FB8 3,800,000.00 (3,796,655.68) 0.00 (3,796,655.68) 10/16/23 US TREASURY NOTES
DTD 05/15/2014 2.500% 05/15/2024
10/16/23 912828WJ5 10,565,000.00 (10,385,890.23) (110,530.57) (10,496,420.80) 10/31/23 FHMS K509 A2
DTD 10/01/2023 4.850% 09/01/2028
10/25/23 3137HAST4 2,890,000.00 (2,797,858.13) (11,680.42) (2,809,538.55) 10/26/23 US TREASURY BILL
DTD 07/05/2023 0.000% 10/31/2023
10/26/23 912797HD2 1,788,000.00 (1,786,704.32) 0.00 (1,786,704.32) Transaction Type Sub-Total 25,238,000.00 (24,867,005.95) (131,335.49) (24,998,341.44)

INTEREST
10/25/23 FHMS K506 A2
DTD 09/01/2023 4.650% 08/01/2028
10/01/23 3137HAMH6 3,800,000.00 0.00 14,725.00 14,725.00 10/25/23 FHMS K507 A2
DTD 09/01/2023 4.800% 09/01/2028
10/01/23 3137HAMS2 3,800,000.00 0.00 15,200.00 15,200.00 10/25/23 FHMS K061 A2
DTD 01/30/2017 3.347% 11/01/2026
10/01/23 3137BTUM1 2,475,000.00 0.00 6,903.19 6,903.19
10/25/23 FHLMC MULTIFAMILY STRUCTURED P
DTD 08/01/2017 3.117% 06/01/2027
10/01/23 3137F2LJ3 3,530,000.00 0.00 9,169.18 9,169.18
10/25/23 FHMS K507 A1
DTD 09/01/2023 4.800% 04/01/2028
10/01/23 3137HAMR4 3,690,000.00 0.00 14,760.00 14,760.00 10/25/23 FANNIEMAE-ACES
DTD 04/01/2014 3.346% 03/01/2024
10/01/23 3136AJB54 389,491.99 0.00 1,086.03 1,086.03
10/25/23 FHMS KJ47 A1
DTD 09/01/2023 5.272% 08/01/2028
10/01/23 3137HAMN3 2,155,000.00 0.00 9,467.63 9,467.63
10/25/23 FHMS K506 A1
DTD 09/01/2023 4.650% 05/01/2028
10/01/23 3137HAMG8 1,900,000.00 0.00 7,362.50 7,362.50
10/25/23 FHMS K505 A2
DTD 07/01/2023 4.819% 06/01/2028
10/01/23 3137HACX2 3,500,000.00 0.00 14,055.42 14,055.42 CITY OF MODESTO - COMBINED PORTFOLIO Page 30
#7..
- 396 -
Managed Account Security Transactions & Interest For the Month Ending October 31, 2023 CITY OF MODESTO - Combined Portfolio
Transaction Type
Trade Settle Security Description CUSIP Par Proceeds
Principal Accrued
Interest Total Cost
Realized G/L Realized G/L Sale
Amort Cost Method

INTEREST
10/25/23 FNA 2023-M6 A2
DTD 07/01/2023 4.190% 07/01/2028
10/01/23 3136BQDE6 3,500,000.00 0.00 12,220.83 12,220.83 10/25/23 FHMS KJ46 A1
DTD 07/01/2023 4.777% 06/01/2028
10/01/23 3137HAD45 2,812,278.36 0.00 11,195.21 11,195.21 10/25/23 FHLMC MULTIFAMILY STRUCTURED P
DTD 07/01/2017 3.243% 04/01/2027
10/01/23 3137F1G44 2,275,000.00 0.00 6,148.19 6,148.19
10/25/23 FHMS K064 A2
DTD 05/15/2017 3.224% 03/01/2027
10/01/23 3137BXQY1 4,000,000.00 0.00 10,746.67 10,746.67 10/02/23 10/02/23 MONEY MARKET FUND MONEY0002 0.00 0.00 1,688.24 1,688.24 10/02/23 BANK OF AMERICA CORP NOTES
(CALLABLE)
DTD 03/22/2022 3.384% 04/02/2026
10/02/23 06051GKM0 2,025,000.00 0.00 34,263.00 34,263.00 10/13/23 AMAZON.COM INC CORPORATE NOTES
DTD 04/13/2022 3.000% 04/13/2025
10/13/23 023135CE4 3,430,000.00 0.00 51,450.00 51,450.00 10/14/23 FEDERAL HOME LOAN BANK NOTES
DTD 04/16/2020 0.500% 04/14/2025
10/14/23 3130AJHU6 2,370,000.00 0.00 5,925.00 5,925.00
10/15/23 USAOT 2023-A A3
DTD 09/15/2023 5.580% 05/15/2028
10/15/23 90291VAC4 3,015,000.00 0.00 14,019.75 14,019.75 10/15/23 CHAIT 2023-A1 A
DTD 09/15/2023 5.160% 09/15/2028
10/15/23 161571HT4 3,020,000.00 0.00 12,986.00 12,986.00 10/15/23 CARMX 2020-1 A3
DTD 01/22/2020 1.890% 12/16/2024
10/15/23 14315XAC2 10,218.14 0.00 16.09 16.09
10/15/23 KCOT 2023-2A A3
DTD 07/26/2023 5.280% 01/18/2028
10/15/23 500945AC4 890,000.00 0.00 3,916.00 3,916.00
10/15/23 TAOT 2023-C A3
DTD 08/15/2023 5.160% 04/17/2028
10/15/23 89231FAD2 690,000.00 0.00 2,967.00 2,967.00
10/15/23 CARMX 2021-2 A3
DTD 04/21/2021 0.520% 02/17/2026
10/15/23 14314QAC8 403,440.64 0.00 174.82 174.82
10/15/23 WALMART INC CORPORATE NOTES
(CALLABLE)
DTD 04/18/2023 3.900% 04/15/2028
10/15/23 931142FB4 1,220,000.00 0.00 23,393.50 23,393.50 10/15/23 AMXCA 2023-3 A
DTD 09/19/2023 5.230% 09/15/2028
10/15/23 02582JKD1 3,090,000.00 0.00 11,671.62 11,671.62 CITY OF MODESTO - COMBINED PORTFOLIO Page 31
#7..
- 397 -
Managed Account Security Transactions & Interest For the Month Ending October 31, 2023 CITY OF MODESTO - Combined Portfolio
Transaction Type
Trade Settle Security Description CUSIP Par Proceeds
Principal Accrued
Interest Total Cost
Realized G/L Realized G/L Sale
Amort Cost Method

INTEREST
10/15/23 CARMX 2021-1 A3
DTD 01/27/2021 0.340% 12/15/2025
10/15/23 14316NAC3 144,591.20 0.00 40.97 40.97
10/15/23 HART 2021-C A3
DTD 11/17/2021 0.740% 05/15/2026
10/15/23 44935FAD6 398,443.30 0.00 245.71 245.71
10/15/23 BAAT 2023-1A A3
DTD 07/31/2023 5.530% 02/15/2028
10/15/23 06428AAC2 1,465,000.00 0.00 6,751.21 6,751.21
10/15/23 TAOT 2021-C A3
DTD 09/27/2021 0.430% 01/15/2026
10/15/23 89239BAC5 728,243.61 0.00 260.95 260.95
10/15/23 FITAT 2023-1 A3
DTD 08/23/2023 5.530% 08/15/2028
10/15/23 31680EAD3 2,425,000.00 0.00 11,175.21 11,175.21 10/15/23 HART 2021-A A3
DTD 04/28/2021 0.380% 09/15/2025
10/15/23 44933LAC7 221,567.41 0.00 70.16 70.16
10/15/23 DCENT 2021-A1 A1
DTD 09/27/2021 0.580% 09/15/2026
10/15/23 254683CP8 775,000.00 0.00 374.58 374.58
10/18/23 HAROT 2023-3 A3
DTD 08/22/2023 5.410% 02/18/2028
10/18/23 43815QAC1 2,220,000.00 0.00 10,008.50 10,008.50 10/21/23 HAROT 2021-1 A3
DTD 02/24/2021 0.270% 04/21/2025
10/21/23 43813GAC5 180,908.07 0.00 40.70 40.70
10/22/23 FANNIE MAE NOTES
DTD 04/24/2020 0.625% 04/22/2025
10/22/23 3135G03U5 8,925,000.00 0.00 27,890.63 27,890.63 10/25/23 TORONTO DOMINION BANK NY CERT
DEPOS
DTD 10/31/2022 5.470% 10/25/2024
10/25/23 89115B6F2 3,355,000.00 0.00 183,008.73 183,008.73 10/31/23 US TREASURY NOTES
DTD 10/31/2022 4.125% 10/31/2027
10/31/23 91282CFU0 5,875,000.00 0.00 121,171.88 121,171.88 10/31/23 US TREASURY NOTES
DTD 04/30/2023 3.500% 04/30/2028
10/31/23 91282CHA2 9,340,000.00 0.00 163,450.00 163,450.00 10/31/23 US TREASURY NOTES
DTD 04/30/2020 0.375% 04/30/2025
10/31/23 912828ZL7 4,945,000.00 0.00 9,271.88 9,271.88
10/31/23 US TREASURY NOTES
DTD 10/31/2020 0.250% 10/31/2025
10/31/23 91282CAT8 11,940,000.00 0.00 14,925.00 14,925.00 10/31/23 US TREASURY NOTES
DTD 10/31/2020 0.500% 10/31/2027
10/31/23 91282CAU5 8,775,000.00 0.00 21,937.50 21,937.50 CITY OF MODESTO - COMBINED PORTFOLIO Page 32
#7..
- 398 -
Managed Account Security Transactions & Interest For the Month Ending October 31, 2023 CITY OF MODESTO - Combined Portfolio
Transaction Type
Trade Settle Security Description CUSIP Par Proceeds
Principal Accrued
Interest Total Cost
Realized G/L Realized G/L Sale
Amort Cost Method

INTEREST
10/31/23 US TREASURY NOTES
DTD 04/30/2020 0.500% 04/30/2027
10/31/23 912828ZN3 6,480,000.00 0.00 16,200.00 16,200.00 Transaction Type Sub-Total 126,184,182.72 0.00 882,334.48 882,334.48

MATURITY
10/01/23 CA ST TXBL GO BONDS
DTD 10/24/2019 2.400% 10/01/2023
10/01/23 13063DRJ9 2,310,000.00 2,310,000.00 27,720.00 2,337,720.00 (46,223.10) 0.00 10/15/23 US TREASURY NOTES
DTD 10/15/2020 0.125% 10/15/2023
10/15/23 91282CAP6 10,490,000.00 10,490,000.00 6,556.25 10,496,556.25 217,175.78 0.00 10/19/23 US TREASURY BILL
DTD 04/20/2023 0.000% 10/19/2023
10/19/23 912797FB8 3,800,000.00 3,800,000.00 0.00 3,800,000.00 3,344.32 0.00 10/31/23 US TREASURY BILL
DTD 07/05/2023 0.000% 10/31/2023
10/31/23 912797HD2 1,788,000.00 1,788,000.00 0.00 1,788,000.00 1,295.68 0.00 Transaction Type Sub-Total 18,388,000.00 18,388,000.00 34,276.25 18,422,276.25 175,592.68 0.00

PAYDOWNS
10/25/23 FHMS K506 A1
DTD 09/01/2023 4.650% 05/01/2028
10/01/23 3137HAMG8 1,635.14 1,635.14 0.00 1,635.14 24.45 0.00 10/25/23 FHMS KJ46 A1
DTD 07/01/2023 4.777% 06/01/2028
10/01/23 3137HAD45 1,677.55 1,677.55 0.00 1,677.55 0.04 0.00 10/25/23 FHMS K507 A1
DTD 09/01/2023 4.800% 04/01/2028
10/01/23 3137HAMR4 10,686.79 10,686.79 0.00 10,686.79 167.71 0.00 10/25/23 FANNIEMAE-ACES
DTD 04/01/2014 3.346% 03/01/2024
10/01/23 3136AJB54 985.85 985.85 0.00 985.85 (47.91) 0.00 10/25/23 FHMS KJ47 A1
DTD 09/01/2023 5.272% 08/01/2028
10/01/23 3137HAMN3 2,925.71 2,925.71 0.00 2,925.71 0.01 0.00 10/15/23 CARMX 2020-1 A3
DTD 01/22/2020 1.890% 12/16/2024
10/15/23 14315XAC2 10,218.14 10,218.14 0.00 10,218.14 2.00 0.00 10/15/23 TAOT 2021-C A3
DTD 09/27/2021 0.430% 01/15/2026
10/15/23 89239BAC5 51,591.51 51,591.51 0.00 51,591.51 4.11 0.00 10/15/23 HART 2021-A A3
DTD 04/28/2021 0.380% 09/15/2025
10/15/23 44933LAC7 25,918.12 25,918.12 0.00 25,918.12 2.73 0.00 CITY OF MODESTO - COMBINED PORTFOLIO Page 33
#7..
- 399 -
Managed Account Security Transactions & Interest For the Month Ending October 31, 2023 CITY OF MODESTO - Combined Portfolio
Transaction Type
Trade Settle Security Description CUSIP Par Proceeds
Principal Accrued
Interest Total Cost
Realized G/L Realized G/L Sale
Amort Cost Method

PAYDOWNS
10/15/23 HART 2021-C A3
DTD 11/17/2021 0.740% 05/15/2026
10/15/23 44935FAD6 26,892.78 26,892.78 0.00 26,892.78 6.00 0.00 10/15/23 CARMX 2021-2 A3
DTD 04/21/2021 0.520% 02/17/2026
10/15/23 14314QAC8 32,814.36 32,814.36 0.00 32,814.36 7.07 0.00 10/15/23 CARMX 2021-1 A3
DTD 01/27/2021 0.340% 12/15/2025
10/15/23 14316NAC3 14,053.15 14,053.15 0.00 14,053.15 2.78 0.00 10/21/23 HAROT 2021-1 A3
DTD 02/24/2021 0.270% 04/21/2025
10/21/23 43813GAC5 25,218.93 25,218.93 0.00 25,218.93 0.46 0.00 Transaction Type Sub-Total 204,618.03 204,618.03 0.00 204,618.03 169.45 0.00 SELL
10/13/23 US TREASURY NOTES
DTD 06/30/2023 4.000% 06/30/2028
10/11/23 91282CHK0 3,555,000.00 3,465,430.66 40,573.37 3,506,004.03 (32,772.66) (35,742.22) FIFO 10/26/23 US TREASURY NOTES
DTD 06/30/2023 4.000% 06/30/2028
10/25/23 91282CHK0 545,000.00 524,413.48 6,990.22 531,403.70 (11,879.29) (12,396.84) FIFO 10/26/23 US TREASURY NOTES
DTD 04/30/2023 3.500% 04/30/2028
10/25/23 91282CHA2 510,000.00 480,993.75 8,682.47 489,676.22 (26,635.55) (26,866.65) FIFO 10/26/23 US TREASURY NOTES
DTD 08/31/2023 4.375% 08/31/2028
10/25/23 91282CHX2 780,000.00 762,602.34 5,250.00 767,852.34 (20,871.10) (20,764.63) FIFO Transaction Type Sub-Total 5,390,000.00 5,233,440.23 61,496.06 5,294,936.29 (92,158.60) (95,770.34) Managed Account Sub-Total (1,040,947.69) 846,771.30 (194,176.39) 83,603.53 (95,770.34) Total Security Transactions ($1,040,947.69) $846,771.30 ($194,176.39) $83,603.53 ($95,770.34) CITY OF MODESTO - COMBINED PORTFOLIO Page 34
#7..
- 400 -
Attachment 3
City of Modesto Combined Yields
Month
Ending
Combined
Yield
CAMP
Balance
CAMP Monthly
Distribution Yields
Long Term
Amortized Cost
Balance
Long Term
Portfolio Yield
Short Term
Amortized Cost
Balance
Short Term
Portfolio Yield
11/30/2021 0.90% 123,749,269.51 0.05% 275,079,950.15 1.28% 12/31/2021 0.91% 123,754,558.86 0.05% 274,968,424.92 1.29% 1/31/2022 0.92% 123,759,932.29 0.05% 276,103,753.02 1.31% 2/28/2022 0.92% 106,765,158.19 0.06% 276,530,404.21 1.31% 39,948,433.34 0.53% 3/31/2022 0.98% 106,788,084.24 0.25% 277,035,730.56 1.33% 39,948,380.00 0.53% 4/30/2022 1.39% 30,016,017.61 0.50% 353,203,903.46 1.56% 39,984,016.67 0.53% 5/31/2022 1.47% 50,044,305.28 0.82% 353,781,386.85 1.59% 39,880,961.12 1.26% 6/30/2022 1.56% 75,106,114.53 1.14% 354,423,884.74 1.64% 39,871,394.45 1.66% 7/31/2022 1.66% 46,186,072.35 1.64% 354,553,148.20 1.66% 39,928,141.66 1.66% 8/31/2022 1.79% 46,276,184.59 2.30% 356,564,454.56 1.69% 39,858,625.00 2.14% 9/30/2022 1.95% 46,375,593.86 2.61% 356,228,719.05 1.71% 39,880,797.64 3.34% 10/31/2022 2.03% 46,499,174.80 3.14% 357,511,536.00 1.74% 39,981,172.30 3.34% 11/30/2022 2.18% 46,648,406.54 3.90% 357,994,150.30 1.78% 40,170,337.16 3.76% 12/31/2022 2.29% 46,818,929.81 4.30% 357,777,379.76 1.84% 40,298,306.29 3.93% 1/31/2023 2.48% 46,999,023.63 4.53% 358,294,563.63 1.95% 40,452,260.96 4.84% 2/28/2023 2.51% 47,169,689.38 4.73% 358,174,068.29 1.94% 40,550,744.43 4.97% 3/31/2023 2.57% 47,361,889.08 4.80% 359,784,568.86 2.01% 40,708,200.79 4.97% 4/30/2023 2.58% 47,555,527.53 4.97% 357,043,234.53 1.99% 40,860,577.92 4.97% 5/31/2023 2.71% 47,763,982.55 5.16% 360,186,419.97 2.10% 41,114,697.00 5.21% 6/30/2023 2.75% 47,969,832.62 5.24% 360,251,679.25 2.14% 41,289,235.20 5.21% 7/31/2023 2.94% 48,186,346.94 5.31% 360,659,807.46 2.35% 41,419,189.81 5.28% 8/31/2023 3.14% 48,412,208.12 5.52% 392,278,686.76 2.60% 41,598,139.19 5.44% 9/30/2023 3.36% 48,632,969.13 5.55% 392,056,693.34 2.85% 41,767,569.64 5.55% 10/31/2023 3.40% 48,862,493.00 5.56% 393,319,562.86 2.89% 41,829,190.02 5.63% Notes:

1. Long and Short Term Portfolio AC Balance is the amortized cost value of the separately managed portfolios.

2. Long and Short Term Portfolio Yields are the separately managed portfolios yield at costs. #7..
- 401 -
Attachment 4
City of Modesto - Portfolio Holdings and Earnings Projections Issuer Par Maturity Date Current Yield
Years to
Maturity
Expected Earnings
Rate to June 30, 2024
Expected Earnings
to June 30, 2024
Main Portfolio
Federal Agency
FNMA 3,500,000 1/7/2025 5.370% 1 35,418 0.85% 19,831
FHLMC 640,000 2/12/2025 5.330% 1 9,765 1.18% 5,049
FHLB 2,370,000 4/14/2025 5.290% 1 20,720 0.60% 9,482
FNMA 3,195,000 4/22/2025 5.300% 1 31,470 0.67% 14,188
FNMA 475,000 4/22/2025 5.300% 1 4,163 0.59% 1,877
FNMA 3,345,000 4/22/2025 5.300% 1 30,124 0.61% 13,581
FNMA 1,910,000 4/22/2025 5.300% 1 14,628 0.52% 6,595
FNMA 3,675,000 6/17/2025 5.270% 2 32,474 0.54% 13,262
FNMA 200,000 6/17/2025 5.270% 2 1,383 0.42% 565
FNMA 1,075,000 6/17/2025 5.270% 2 6,995 0.40% 2,857
FNMA 3,820,000 6/17/2025 5.270% 2 25,417 0.41% 10,380
FNMA 1,190,000 6/17/2025 5.270% 2 7,029 0.36% 2,871
FHLMC 2,220,000 7/21/2025 5.220% 2 18,211 0.48% 7,035
FNMA 2,360,000 8/25/2025 5.210% 2 20,175 0.47% 7,383
FNMA 550,000 8/25/2025 5.210% 2 4,400 0.44% 1,610
FNMA 450,000 8/25/2025 5.210% 2 4,030 0.49% 1,475
FHLMC 3,400,000 9/23/2025 5.170% 2 28,145 0.44% 9,869
FHLMC 130,000 9/23/2025 5.170% 2 991 0.40% 348
FNMA 2,215,000 11/7/2025 5.140% 2 25,659 0.57% 8,449
FNMA 2,040,000 11/7/2025 5.140% 2 20,944 0.51% 6,896
Federal Agency CMBS
FNMA 388,506 3/1/2024 6.290% 0 2,774 3.46% 8,949
FHLMC 2,475,000 11/1/2026 5.340% 3 320,781 4.31% 71,057 FHLMC 4,000,000 3/1/2027 5.330% 3 663,719 4.98% 132,526 FHLMC 2,275,000 4/1/2027 5.380% 3 386,711 4.97% 75,297
FHLMC 3,530,000 6/1/2027 5.330% 4 633,698 5.01% 117,638 FHLMC 3,679,313 4/1/2028 5.500% 4 844,582 5.19% 127,158 FHLMC 1,898,365 5/1/2028 5.570% 5 428,596 5.01% 63,351
FHLMC 3,500,000 6/1/2028 5.510% 5 737,141 4.59% 106,940 FHLMC 2,810,601 6/1/2028 5.340% 5 616,208 4.78% 89,396
FNMA 3,500,000 7/1/2028 5.500% 5 748,063 4.58% 106,615
FHLMC 3,800,000 8/1/2028 5.590% 5 902,252 4.99% 126,295 FHLMC 2,152,074 8/1/2028 5.480% 5 539,634 5.27% 75,536
FHLMC 3,850,000 8/1/2028 5.550% 5 963,087 5.26% 134,810 FHLMC 3,800,000 9/1/2028 5.500% 5 933,569 5.07% 128,386 FHLMC 2,890,000 9/1/2028 5.600% 5 784,068 5.60% 107,826 U.S. Treasury
U.S. Treasury 2,345,000 11/2/2023 2.650% 0 681 4.87% 76,106 U.S. Treasury 10,480,000 11/30/2023 5.330% 0 46,811 4.93% 343,771 U.S. Treasury 10,565,000 5/15/2024 5.530% 1 313,503 5.36% 376,758 U.S. Treasury 2,255,000 11/30/2024 5.450% 1 12,318 0.50% 7,559 U.S. Treasury 4,445,000 12/15/2024 5.420% 1 134,367 2.68% 79,443 U.S. Treasury 4,400,000 2/15/2025 5.340% 1 154,193 2.70% 79,216 U.S. Treasury 2,300,000 2/15/2025 5.340% 1 145,374 4.88% 74,684 U.S. Treasury 4,945,000 4/30/2025 5.240% 1 46,875 0.63% 20,824 U.S. Treasury 4,230,000 6/30/2025 5.190% 2 192,551 2.73% 76,957 U.S. Treasury 4,340,000 8/31/2025 5.130% 2 42,060 0.53% 15,254 U.S. Treasury 4,635,000 8/31/2025 5.130% 2 233,213 2.74% 84,583 U.S. Treasury 4,550,000 9/30/2025 5.080% 2 58,493 0.67% 20,305 U.S. Treasury 1,100,000 9/30/2025 5.080% 2 16,963 0.80% 5,889 U.S. Treasury 5,010,000 10/31/2025 5.080% 2 77,559 0.77% 25,782 U.S. Treasury 6,930,000 10/31/2025 5.080% 2 108,223 0.78% 35,976 U.S. Treasury 4,250,000 11/30/2025 5.060% 2 94,382 1.07% 30,138 U.S. Treasury 4,635,000 11/30/2025 5.060% 2 266,102 2.75% 84,971 U.S. Treasury 3,735,000 12/31/2025 5.000% 2 71,948 0.89% 22,075 U.S. Treasury 500,000 12/31/2025 5.000% 2 4,689 0.43% 1,439 U.S. Treasury 1,040,000 12/31/2025 5.000% 2 10,237 0.45% 3,141 U.S. Treasury 2,400,000 1/31/2026 5.020% 2 43,535 0.80% 12,854 U.S. Treasury 5,775,000 1/31/2026 5.020% 2 165,688 1.27% 48,921 U.S. Treasury 5,000,000 1/31/2026 5.020% 2 209,040 1.85% 61,721 U.S. Treasury 7,980,000 1/31/2026 5.020% 2 530,792 2.95% 156,722 U.S. Treasury 6,000,000 2/28/2026 5.000% 2 161,543 1.15% 46,128 U.S. Treasury 4,645,000 2/28/2026 5.000% 2 298,696 2.76% 85,292 U.S. Treasury 3,210,000 2/28/2026 5.000% 2 52,562 0.70% 15,009 U.S. Treasury 2,480,000 3/31/2026 4.940% 2 45,468 0.76% 12,527 U.S. Treasury 4,925,000 3/31/2026 4.940% 2 103,479 0.87% 28,510 U.S. Treasury 1,405,000 5/31/2026 4.960% 3 31,521 0.87% 8,123 U.S. Treasury 4,615,000 5/31/2026 4.960% 3 329,200 2.76% 84,831 U.S. Treasury 4,800,000 5/31/2026 4.960% 3 371,092 2.99% 95,626 U.S. Treasury 4,640,000 8/31/2026 4.920% 3 361,841 2.75% 84,954 U.S. Treasury 4,310,000 9/30/2026 4.860% 3 348,088 2.77% 79,423 U.S. Treasury 4,545,000 11/15/2026 4.900% 3 416,255 3.01% 91,044 U.S. Treasury 9,220,000 2/15/2027 4.880% 3 866,845 2.85% 175,098 U.S. Treasury 910,000 3/31/2027 4.870% 3 125,433 4.03% 24,443 U.S. Treasury 6,480,000 4/30/2027 4.880% 3 661,554 2.92% 125,887 U.S. Treasury 5,545,000 6/30/2027 4.880% 4 608,276 2.99% 110,472 U.S. Treasury 1,200,000 8/15/2027 4.900% 4 150,315 3.30% 26,392 U.S. Treasury 2,985,000 8/15/2027 4.900% 4 384,855 3.40% 67,572 U.S. Treasury 5,380,000 9/30/2027 4.880% 4 900,662 4.27% 153,050 U.S. Treasury 8,775,000 10/31/2027 4.880% 4 1,373,767 3.91% 228,491 U.S. Treasury 2,715,000 10/31/2027 4.880% 4 414,069 3.81% 68,870 U.S. Treasury 3,160,000 10/31/2027 4.880% 4 458,930 3.63% 76,331 U.S. Treasury 4,250,000 12/31/2027 4.860% 4 669,660 3.78% 106,917 U.S. Treasury 2,220,000 1/31/2028 4.860% 4 332,232 3.52% 51,985 U.S. Treasury 3,450,000 1/31/2028 4.870% 4 537,556 3.66% 84,112 U.S. Treasury 2,825,000 2/29/2028 4.850% 4 520,295 4.25% 79,919 U.S. Treasury 2,970,000 2/29/2028 4.850% 4 552,796 4.29% 84,911 U.S. Treasury 2,555,000 3/31/2028 4.870% 4 394,227 3.49% 59,391 U.S. Treasury 2,675,000 3/31/2028 4.850% 4 431,255 3.65% 64,969 U.S. Treasury 2,810,000 4/30/2028 4.840% 5 455,669 3.60% 67,394 U.S. Treasury 6,530,000 4/30/2028 4.840% 5 999,266 3.40% 147,792 Commercial Paper
Thunder Bay Funding LLC 10,630,000 2/27/2024 5.850% 0 200,535 5.28% 373,755 LMA Americas LLC 10,757,000 3/8/2024 5.810% 0 219,944 5.32% 380,900 Negotiable CD
Toronto-Dominion Bank 3,355,000 10/25/2024 5.370% 1 180,018 5.44% 121,512 Rabobank Nederland 3,500,000 7/17/2026 5.900% 3 482,270 5.08% 118,375 10/31/2023
Earnings to
Maturity
#7..
- 402 -
Attachment 4
City of Modesto - Portfolio Holdings and Earnings Projections Issuer Par Maturity Date Current Yield
Years to
Maturity
Expected Earnings
Rate to June 30, 2024
Expected Earnings
to June 30, 2024
10/31/2023
Earnings to
Maturity
Corporate Note
US Bancorp 2,860,000 2/5/2024 6.140% 0 17,245 3.80% 72,292 Pfizer Inc 3,445,000 3/15/2024 5.660% 0 34,514 3.61% 82,854 Amazon.Com Inc 1,590,000 5/12/2024 5.680% 1 4,218 1.36% 14,361 JPMorgan Chase & Co 1,320,000 5/13/2024 6.030% 1 4,563 1.46% 12,811 Wal-Mart Stores Inc 4,000,000 7/8/2024 5.770% 1 60,136 2.19% 58,220 Paccar Financial Corp 1,810,000 2/6/2025 5.530% 1 33,317 1.45% 17,449 Mastercard Inc 1,760,000 3/3/2025 5.450% 1 25,379 1.08% 12,612 Amazon.Com Inc 3,430,000 4/13/2025 5.440% 1 152,199 3.06% 69,782 JPMorgan Chase & Co 865,000 6/1/2025 3.030% 2 11,307 0.82% 4,745 Bristol-Myers Squibb Co 2,230,000 11/13/2025 5.370% 2 43,184 0.95% 14,105 The Bank Of New York Mellon Corporation 3,465,000 1/28/2026 5.730% 2 58,000 0.75% 17,188 Bank Of America Co 2,025,000 4/2/2026 5.210% 2 165,954 3.38% 45,618 Wells Fargo & Company 5,635,000 8/7/2026 5.830% 3 864,247 5.54% 207,727 Microsoft Corp 3,000,000 8/8/2026 5.160% 3 177,867 2.14% 42,709 Bank Of America Co 3,750,000 8/18/2026 5.970% 3 580,538 5.53% 138,034 Mastercard Inc 2,560,000 11/21/2026 5.400% 3 339,138 4.33% 73,779 Target Corp 365,000 1/15/2027 5.360% 3 23,277 1.99% 4,826 Microsoft Corp 3,000,000 2/6/2027 5.160% 3 398,141 4.06% 81,029 Home Depot Inc 3,610,000 9/14/2027 5.420% 4 581,493 4.16% 99,931 JPMorgan Chase & Co 1,535,000 2/24/2028 5.580% 4 340,257 5.13% 52,430 Wal-Mart Stores Inc 1,220,000 4/15/2028 5.280% 4 214,935 3.95% 32,082 Apple Inc 5,200,000 5/10/2028 5.210% 5 925,387 3.93% 136,037 Deere & Company 895,000 7/14/2028 5.580% 5 199,219 4.73% 28,178 Deere & Company 495,000 7/14/2028 5.580% 5 108,155 4.64% 15,298 Deere & Company 1,165,000 7/14/2028 5.580% 5 273,299 4.98% 38,656 Paccar Financial Corp 1,130,000 8/10/2028 5.400% 5 275,194 5.09% 38,322 Toyota Motor Corp 2,800,000 9/11/2028 5.680% 5 721,129 5.29% 98,613 Citigroup Inc 5,650,000 9/29/2028 6.090% 5 1,612,399 5.80% 218,280 Asset-Backed Securities
Honda Auto Receivables 155,689 4/21/2025 1.330% 1 621 0.27% 280 Hyundai Auto Receivables 195,649 9/15/2025 1.380% 2 1,404 0.38% 498 Carmax Auto Owner Trust 130,538 12/15/2025 1.380% 2 955 0.34% 299 Toyota Motor Corp 676,652 1/15/2026 1.930% 2 6,461 0.43% 1,946 Carmax Auto Owner Trust 370,626 2/17/2026 1.720% 2 4,473 0.52% 1,294 Hyundai Auto Receivables 371,551 5/15/2026 2.110% 3 7,031 0.75% 1,843 Discover Card Execution Note Trust 775,000 9/15/2026 2.250% 3 13,028 0.58% 3,015 Kubota Credit Owners Trust 890,000 1/18/2028 5.660% 4 198,505 5.29% 31,322 Bank of America Auto Trust 1,465,000 2/15/2028 5.740% 4 348,093 5.53% 53,946 Honda Auto Receivables 2,220,000 2/18/2028 5.600% 4 517,430 5.42% 80,035 Toyota Motor Corp 690,000 4/17/2028 5.450% 4 159,167 5.17% 23,729 USAA Owners Trust 3,015,000 5/15/2028 5.710% 5 764,795 5.58% 112,090 Fifth Third Auto Trust 2,425,000 8/15/2028 5.640% 5 643,129 5.53% 89,303 American Express Co 3,090,000 9/15/2028 5.440% 5 788,707 5.23% 107,611 Chase Issurance 3,020,000 9/15/2028 5.380% 5 761,304 5.17% 103,872 Municipal Securities
Maryland St 620,000 8/1/2024 5.500% 1 2,416 0.52% 2,134 California State University 600,000 11/1/2024 5.550% 1 4,132 0.68% 2,736 State Of California 100,000 12/1/2024 5.610% 1 609 0.56% 373 University Of California 510,000 5/15/2025 5.670% 2 6,934 0.88% 2,998 University Of California 220,000 5/15/2025 5.670% 2 2,732 0.81% 1,181 Florida State Board of Administration Finance 1,295,000 7/1/2025 5.540% 2 27,184 1.26% 10,847 Florida State Board of Administration Finance 505,000 7/1/2025 5.540% 2 9,321 1.11% 3,719 Los Angeles Community College District 925,000 8/1/2025 5.410% 2 12,538 0.77% 4,761 New Jersey Turnpike Authority 505,000 1/1/2026 5.240% 2 11,488 1.05% 3,520 Supranational Securities
Intl Bank Of Reconstruction And Dev 1,790,000 11/24/2023 5.020% 0 379 4.87% 58,093 Inter-American Development Bank 4,095,000 9/23/2024 5.640% 1 19,316 0.52% 14,310 Overnight Investments 48,862,493 Varies Varies 5.20% 1,690,157 Totals (Main Portfolio) 491,954,058 39,823,640 3.34% 10,924,356 Notes:

1. Earnings projections are based on stated par value, future market expectations and current investment positions.

2. Earnings on overnight investments are based on the investment balances and the Fed Funds Futures rates.

3. Callable securities priced above par are considered to be called on their next call date. #7..
- 403 -
Attachment 5
Issue Name / Type Trustee Bank Investment Total Amount
1993 Community Center Refinancing U.S. Bank First American Treasury Obligation Fund $1,726,284.84 1993 Golf Course Refinancing U.S. Bank First American Treasury Obligation Fund $514,695.79 Instl Res Tre and Agny Cash Adv6541 $50,043.07
Financial Guaranty Insurance Pol $1.00
CAMP $2,040,756.07
Total $2,090,800.14
Instl Res Tre and Agny Cash Adv6541 $183,083.81
CAMP $5,048,597.27
Total $5,231,681.08
2015 Wastewater Refunding Bank of New York Cash $898,267.15 2018 Wastewater Refunding Bank of New York Fidelity Inv MM Trsy Only $277,703.00 2020 Wastewater Refunding Bank of New York Cash $6,596,243.06 Fairview Village Refunding US Bank First American Treasury Obligation Fund $198,931.33 Blackrock Federal Fund Instl 30 $4,436.58
CAMP $2,890,461.72
Total $2,894,898.30
Other Post Employment Benefits Section 115
Trust PARS HighMark Plus Moderate $1,400,864.86
Pension Section 115 Trust PARS HighMark Plus Moderately Conservative $2,499,796.02 Athens Administrators (New Third Party
Administrator - Worker's Compensation) Wells Fargo Bank $430,248.41 George Hills Company - General Liability Claims
Administration Services California Bank & Trust $46,778.95 Kemper Sports Management Inc. BMO Harris Bank Business Money Market $53,414.21 Stanislaus Community Foundation Modesto Commerce Bank Charles Schwab $692,179.44 Third-Party Construction Contract Retention California Bank of Commerce $2,244,414.26
Umpqua Bank $700,301.63
Village One #2 Refunding Bank of New York
Cash with Fiscal Agent Investments
As of October 31, 2023
2008 Water Refunding COP Bank of New York
2008 Lease Revenue Bonds Bank of New York
#7..
- 404 -

CITY OF MODESTO

COUNCIL AGENDA REPORT
DATE OF MEETING:

January 9, 2024
Date: December 18, 2023
TO: Mayor and City Council
THROUGH: Joseph P. Lopez, City Manager
FROM: William Wong, Director of Utilities
SUBJECT: Engineering Services Agreement with NorthStar Engineering Group Bystrum Area Phase 1 – Strengthen and Replace Water Mains Project CONTACT: David A. Felix, Associate Engineer, [email protected], 209-577-5488 DESCRIPTION:

Consider approving an Engineering Services Agreement with NorthStar Engineering Group, of Modesto, CA, for the Bystrum Area Phase 1 – Strengthen and Replace Water Mains Project, in an amount not to exceed $366,432. (Funding Source: Water Fund) STRATEGIC PLAN ELEMENT:

The recommended action supports the 2020-2025 City of Modesto Strategic Plan Initiatives, Goal D: Provide safe, efficient, and reliable infrastructure through proactive community investment, maintenance, and sustainability efforts.

BACKGROUND:

The Bystrum Area Phase 1 - Strengthen and Replace (S&R) Water Mains Project is located within a Stanislaus County pocket area bounded by Herndon Road to the West, Woodworth Avenue to the North, Richland Avenue to the East, and Nadine Avenue to the South. This area has deficient water mains that are undersized, lack pressure, and are prone to leaks. This project will replace and upgrade water mains, associated water valves, services, and fire hydrants to increase service reliability, flows, and pressures.

DISCUSSION:

To increase efficiencies, staff is requesting the use of a consultant to provide Engineering Services for the Bystrum Area Phase 1 - S&R Water Mains Project.

On April 12, 2022, by Resolution No. 2022-191, Council approved a prequalified list of local consultants for Civil Engineering Services, for various Capital Improvement Program Projects.

In accordance with Administrative Directive 3.1, Selection Procedures for Professional Consultants Who Provide Architectural and Engineering Services for Capital Projects, a #8..
- 405 -
City Council, January 9, 2024
Engineering Services Agreement with NorthStar Engineering Group Bystrum Area Phase 1 – Strengthen and Replace Water Mains Project

Page 2 of 3 ends

Request for Proposal (RFP) was sent to four (4) pre-qualified local consultants for Civil Engineering Services for various Capital Improvement Program Projects.

On October 17, 2023, staff received and distributed four (4) proposals to a selection committee consisting of Utilities Engineering staff. The selection committee evaluated the proposals and determined NorthStar Engineering Group (NorthStar) to be the most qualified and responsive.

NorthStar’s sealed cost proposal was opened, reviewed, and negotiated after the selection ranking had been finalized.

The scope of services to be provided under this Agreement include:
 Construction Documents
 Project Management
 Permitting
 Environmental Clearance
 Bid Period Services
 Engineering Services During Construction
In accordance with Modesto Municipal Code 8-3.204(a), “Exceptions to Formal Bidding Requirements,” Agreements for Professional Servies are exempt from the bidding requirements of Modesto Municipal Code 8-3.203 if competitive quotations or proposals have been sought informally from at least three (3) qualified entities. The approval of an Engineering Services Agreement with NorthStar Engineering Group for the Bystrum Area Phase 1 – Strengthen and Replace Water Mains Project conforms to Modesto Municipal Code 8-3.204, subsection (a) as they are providing professional services and at least three informal proposals were obtained.

FISCAL IMPACT:

Expenses associated with this effort will be housed in the following Capital Improvement Project:
101286 – Bystrum Water Main
ANTICIPATED PROJECT EXPENDITURES:

Construction $2,715,000
Construction Contingency (10%) $271,500
Construction Administration – City Staff (10%) $271,500 Engineering Services Agreement – NorthStar $333,120
Additional Services, if Needed (10%) $33,312
City Construction Forces $50,000
Engineering/Design/Administration – City Staff $108,600 TOTAL: $3,783,032

COMMITTEE RECOMMENDATION
This item was considered by the Finance Committee at the December 18, 2023 meeting, where it was recommended that it be forwarded to Council.
#8..
- 406 -
City Council, January 9, 2024
Engineering Services Agreement with NorthStar Engineering Group Bystrum Area Phase 1 – Strengthen and Replace Water Mains Project

Page 3 of 3 ends

CEQA/NEPA REQUIREMENTS:

City staff will be responsible for preparing the necessary documentation for the Project to gain environmental clearance.

RECOMMENDED COUNCIL ACTION:

Staff Recommendations:

Resolution approving an Engineering Services Agreement with NorthStar Engineering Group, of Modesto, CA, for the Bystrum Area Phase 1 - Strengthen and Replace Water Mains Project in the amount of $333,120, plus $33,312 in additional services, if needed, for a total amount not to exceed $366,432 and authorizing the City Manager, or his designee, to execute the Agreement.

Approved by:

William Wong, Director of Utilities
Joseph P. Lopez, City Manager
Attachments:

1. Resolution

2. NorthStar Engineering Group – Agreement & Exhibits
#8..
- 407 -
XXX 1 2024-XXX

MODESTO CITY COUNCIL
RESOLUTION NO. 2024-XXX

RESOLUTION APPROVING AN ENGINEERING SERVICES AGREEMENT

WITH NORTHSTAR ENGINEERING GROUP, OF MODESTO, CA, FOR THE BYSTRUM AREA PHASE 1 - STRENGTHEN AND REPLACE WATER MAINS PROJECT IN THE AMOUNT OF $333,120, PLUS $33,312 IN ADDITIONAL SERVICES, IF NEEDED, FOR A TOTAL AMOUNT NOT TO EXCEED $366,432

AND AUTHORIZING THE CITY MANAGER, OR HIS DESIGNEE, TO

EXECUTE THE AGREEMENT
WHEREAS, the Bystrum Area has deficient water mains that are undersized, lack pressure, and are prone to leaks, and
WHEREAS, the Bystrum Area Phase 1 - Strengthen and Replace Water Mains Project will replace and upgrade water mains, associated water valves, services, and fire hydrants to increase service reliability, flows, and pressures, and WHEREAS, in accordance with Administrative Directive 3.1, Selection Procedures for Professional Consultants Who Provide Architectural and Engineering Services for Capital Projects, a Request for Proposal (RFP) was sent to four (4) prequalified local consultants for Civil Engineering Services for various Capital Improvement Program Projects, and
WHEREAS, staff received and distributed four (4) proposals to a selection committee consisting of Utilities Engineering staff, and WHEREAS, the selection committee evaluated the proposals and determined NorthStar Engineering Group to be the most qualified and responsive, and WHEREAS, in accordance with Modesto Municipal Code 8-3.204(a) agreements for professional services are exempt from formal bidding as long as competitive #8..
- 408 -
XXX 2 2024-XXX
quotations or proposals have been sought informally from at least three qualified entities, and
WHEREAS, staff proceeded with the RFP process pursuant to Administrative Directive 3.1 that complied with the requirements of Modesto Municipal Code 8-3.204(a), and
WHEREAS, staff recommends approval of an Engineering Services Agreement with NorthStar Engineering Group for the Bystrum Area Phase 1 - Strengthen and Replace Water Mains Project.

NOW, THEREFORE BE IT RESOLVED, by the Council of the City of Modesto that it hereby approves an Agreement with NorthStar Engineering Group, in the amount of $333,120, plus $33,312 in additional services (if needed), for a total amount not to exceed $366,432 for the Bystrum Area Phase 1 - Strengthen and Replace Water Mains Project.

BE IT FURTHER RESOLVED, that the City Manager, or his designee, is hereby authorized to execute the agreement in a form approved by the City Attorney. #8..
- 409 -
XXX 3 2024-XXX
The foregoing resolution was introduced at a regular meeting of the Council of the City of Modesto held on the 9th day of January, 2024, by Councilmember XXX who moved its adoption, which motion being duly seconded by Councilmember XXX, was upon roll call carried and the resolution adopted by the following vote:

AYES: Councilmembers:

NOES: Councilmembers:

ABSENT: Councilmembers:

ATTEST: _____________________________

DIANE NAYARES-PEREZ, CMC,
City Clerk
(SEAL)
APPROVED AS TO FORM:

BY: ________________________________
JOSE M. SANCHEZ, City Attorney
#8..
- 410 -
-1-

ENGINEERING SERVICES AGREEMENT
BYSTRUM AREA PHASE 1 - STRENGTH & REPLACE WATER MAINS PROJECT THIS AGREEMENT, made and entered into in the City of Modesto, State of California, this __ day of , 2024, (“Effective Date”) by and between the CITY OF MODESTO, a municipal corporation of the State of California, hereinafter referred to as "City", and NORTHSTAR ENGINEERING GROUP, INC., a California corporation, hereinafter referred to as "Consultant".

This Agreement is made with regard to the following recitals:

A. The City has determined that Engineering Services are necessary for the Bystrun Area Phase 1 - Strengthen & Replace Water Mains Project.

B. Consultant represents that it is qualified, willing and able to provide the services to prepare said document(s).

NOW, THEREFORE, in consideration of this agreement, and the mutual promises, covenants, and stipulations hereinafter contained, the parties agree as follows:

1. SCOPE OF SERVICES.

Consultant shall undertake and complete the preparation of the scope of work as set forth and described in the documents attached hereto and referred to as Exhibit "A" or "project". The Consultant shall perform the services as described in Exhibit "A" in a manner compatible with the standards of its profession, and shall produce a fully complete project that is acceptable to City.

2. TERM OF AGREEMENT.

This Agreement is effective as of the date first written above and will continue in effect until City's acceptance of and payment for all services authorized by City and #8..
- 411 -
-2-
performed by Consultant, unless terminated earlier in accordance with the provisions of the termination clause in this Agreement.

Consultant shall undertake and complete the preparation of the scope of work as set forth and described in the documents commonly referred to as “project” attached hereto as Exhibit "A" and made a part hereof. City hereby gives Consultant notice to proceed with the preparation of the project in the manner described in Exhibit "A", as of the Effective Date of this agreement. Consultant shall diligently proceed with the preparation of the project and agrees to complete said preparation within the time period set forth in Exhibit "A".

3. COMPENSATION.

Consultant agrees to accept a sum not to exceed THREE HUNDRED THIRTY-THREE THOUSAND ONE HUNDRED TWENTY AND 00/100 DOLLARS ($333,120) (maximum compensation) as full remuneration for performing all services and furnishing all staffing and materials for Modesto in accordance with Exhibit "A" attached hereto and for performance by Consultant of all of its duties and obligations under this Agreement, except that additional services may be compensated as described below.

The Compensation shall be paid pursuant in the manner and at the times set forth below:

City shall pay Consultant on a time and materials basis for Consultant’s actual costs for all work called for in Exhibit “A” to this Agreement. All work to be performed under this Agreement shall be billed at the hourly rates set forth in Exhibit “B” attached hereto, Consultant shall submit monthly invoices to City which include detailed tasks, hours worked, and billable rates for all work completed, and detailed receipts for any out-of-pocket costs paid by Consultant in connection with work performed on this project. #8..
- 412 -
-3-
Additional services may be authorized by the City Manager in an amount up to, but not to exceed TEN PERCENT (10%) of the agreed maximum compensation, or THIRTY-THREE THOUSAND THREE HUNDRED TWELVE AND 00/100 DOLLARS ($33,312). In the event that additional services are deemed necessary, the Consultant shall provide a written request to the City Manager indicating the reason for additional work, scope and cost of such work. The City Manager shall provide a written response to the request, either approving or denying the additional expenditure. If additional services are requested and approved, they will be billed at the hourly rates set forth in Exhibit “B” and may not exceed the amount requested and approved in writing by the City Manager. In that event, the new total compensation shall not exceed THREE HUNDRED SIXTY-SIX THOUSAND FOUR HUNDRED THIRTY-TWO AND 00/100 DOLLARS ($366,432). If additional services in excess of this amount are deemed necessary by City Staff, an amendment to this Agreement will be required and must be approved by the City Council prior to commencing the work, as provided in Paragraph 9 of this agreement.

4. OBLIGATIONS OF CONSULTANT.

Throughout the term of this Agreement, Consultant shall possess, or secure all licenses, permits, qualifications and approvals legally required to conduct business.

Consultant warrants that it has all of the necessary professional capabilities and experience, as well as all tools, instrumentalities, facilities and other resources necessary to provide the City with the services contemplated by this Agreement. Consultant further warrants that it will follow the best current, generally accepted and professional practices to make findings, render opinions, prepare factual presentations, and provide professional advice and recommendations regarding this project.
#8..
- 413 -
-4-

5. PERFORMANCE BY KEY EMPLOYEE.

Consultant has represented to City that Corey Walker, will be the person primarily responsible for the performance of the services referred to in this Agreement. City has entered into this Agreement in reliance on that representation by Consultant. Consultant therefore agrees that ten percent (10%) or more of the time to be devoted to the project that is the subject of this Agreement will be that of the above-named person.

6. OWNERSHIP OF DOCUMENTS/TITLE TO DATA.

Ownership of Documents
All reports, drawings, designs, graphics, working papers and other incidental work or materials furnished hereunder shall become and remain the property of the City, and may be used by City as it may require without any additional cost to City. No reports shall be used by the Consultant for purposes other than this contract without the express prior written consent of City.

Title to Data
If, as a part of the agreement, Consultant is required to produce data such as, but not limited to, drawings, plans, specifications, calculations, models, flow diagrams, visual aids and other related materials, the originals of all such data generated under this agreement will be delivered to City upon the completion or termination of services under the contract.

All materials, documents, data or information obtained from the City data files or any City medium furnished to Consultant in the performance of this Agreement will at all times remain the property of the City. Such data or information may not be used or copied for direct or indirect use by Consultant after termination of this Agreement without written consent of the City.
#8..
- 414 -
-5-

7. NEWS AND INFORMATION RELEASE.

Consultant agrees that it will not issue any news releases in connection with either the award of this Agreement, or any subsequent amendment of or efforts under this Agreement, without first obtaining review and approval of said news releases from City through the City Manager.

8. INTEREST OF CONTRACTOR.

Consultant warrants that it presently has no interest and shall not acquire any interest, direct or indirect, which would conflict in any manner or degree with the performance of services required to be performed under this Agreement. Consultant warrants that, in performance of this Agreement, Consultant shall not employ any person having any such interest. Consultant agrees to file a Statement of Economic Interests with the City Clerk at the start and end of this contract if so required at the option of City.

9. AMENDMENTS.

Both parties to this Agreement understand that it may become desirable or necessary during the execution of this Agreement, for City or Consultant to modify the scope of services provided for under this Agreement. Any material extension or change in the scope of work shall be discussed with City and the change and cost shall be memorialized in a written amendment to the original contract prior to the performance of the additional work.

Until a change order is so executed, City will not be responsible to pay any charges Consultant may incur in performing such additional services, and Consultant shall not be required to perform any such additional services. #8..
- 415 -
-6-

10. INDEPENDENT CONTRACTOR.

All acts of Consultant, its agents, officers, and employees and all others acting on behalf of Consultant relating to the performance of this Agreement, shall be performed as independent contractors and not as agents, officers, or employees of City. Consultant, by virtue of this Agreement, has no authority to bind or incur any obligation on behalf of City.

Consultant has no authority or responsibility to exercise any rights or power vested in the City.

No agent, officer, or employee of the City is to be considered an employee of Consultant. It is understood by both Consultant and City that this Agreement shall not under any circumstances be construed or considered to create an employer-employee relationship or a joint venture.

Consultant, its agents, officers and employees are and, at all times during the terms of this Agreement, shall represent and conduct themselves as independent contractors and not as employees of City.

Consultant shall determine the method, details and means of performing the work and services to be provided by Consultant under this Agreement. Consultant shall be responsible to City only for the requirements and results specified in this Agreement, and, except as expressly provided in this Agreement, shall not be subjected to City's control with respect to the physical action or activities of the Consultant in fulfillment of this Agreement. Consultant has control over the manner and means of performing the services under this Agreement.

Consultant is permitted to provide services to others during the same period service is provided to City under this Agreement. If necessary, Consultant has the responsibility for employing other persons or firms to assist Consultant in fulfilling the terms and obligations under this Agreement.
#8..
- 416 -
-7-
If in the performance of this Agreement any third persons are employed by Consultant, such persons shall be entirely and exclusively under the direction, supervision, and control of Consultant. All terms of employment including hours, wages, working conditions, discipline, hiring, and discharging or any other term of employment or requirement of law shall be determined by the Consultant.

It is understood and agreed that as an independent contractor and not an employee of City neither the Consultant or Consultant's assigned personnel shall have any entitlement as a City employee, right to act on behalf of the City in any capacity whatsoever as an agent, or to bind the City to any obligation whatsoever.

It is further understood and agreed that Consultant must issue W-2 forms or other forms as required by law for income and employment tax purposes for all of Consultant's personnel.

As an independent contractor, Consultant hereby indemnifies and holds City harmless from any and all claims that may be made against City based upon any contention by any third party that an employer-employee relationship exists by reason of this Agreement.

11. ASSIGNMENT.

Neither this Agreement nor any portion thereof shall be subcontracted or assigned without the express prior written consent of the City in each and every instance.

12. PATENT/COPYRIGHT MATERIALS.

Unless otherwise expressly provided in the contract, Consultant shall be solely responsible for obtaining the right to use any patented or copyrighted materials in the performance of this Agreement. Consultant shall furnish a warranty of such right to use to City at the request of City.
#8..
- 417 -
-8-

13. NOTICES.

Notice required by this Agreement shall be given in writing and shall be deemed given and effective upon receipt provided that such are delivered in accordance with the provisions of this Section. Notices shall be delivered either by: (a) personal delivery (including delivery by an overnight courier service which obtains confirmation of receipt); or (b) by facsimile, provided that such transmission is followed by delivery by an overnight courier service which obtains confirmation of receipt; or (c) postage prepaid, return receipt requested, certified mail; or (d) by electronic transmission subject to reasonable proof that the notice was both transmitted and received. Each such notice shall be sent to the parties at the address respectively set forth below or to such other address as a party may designate by written notice given in accordance with the provisions of this Section:

FOR CONSULTANT: Name: NorthStar Engineering Group
Address: 620 12th Street
Modesto, CA 95354
Attention: Anthony Cannella
Phone: (209) 524-3525
Email: [email protected]
FOR CITY: Name: City of Modesto
Address: 1010 10th Street
4th Floor, Suite 4600
Modesto, CA 95354
Attention: David Felix
Phone: (209) 577-5488
Email: [email protected]

14. INSURANCE REQUIREMENTS.

The Consultant shall provide at its own expense and maintain at all times the following insurance with insurance companies licensed in the State of California and shall provide evidence of such insurance to the City as may be required by the Risk Manager of the #8..
- 418 -
-9-
City. The policies or certificates thereof shall provide that, thirty (30) days prior to cancellation or material change in the policy, notices of same shall be given to the Risk Manager of the City by certified mail, return receipt requested, for all of the following stated insurance policies.

In the event the certificates of insurance required hereunder do not provide for notice of cancellation to the certificate holder and/or additional insureds, the Consultant shall provide, and shall require its subcontractors to provide, as an express condition precedent to payment hereunder, an endorsement from their insurers providing that the additional insureds identified herein shall be provided 30 days notice of the cancellation on the policies of insurance required hereunder (10 days notice if the policies are cancelled for non-payment of premium). In addition, the named insured on all such policies shall provide to the additional insureds identified herein any notices of cancellation of said insurance policies within 5 business days of receipt of such notice. The Consultant shall, as a further express condition precedent to payment for work performed, affirm under penalty of perjury that the required insurance on the project remains in place and said insurance has not been cancelled.
(a) Worker's Compensation - in compliance with the statutes of the State of California, plus employer's liability with a minimum limit of liability of $1,000,000. (b) General Liability insurance with a minimum limit of liability per occurrence of $1,000,000 for bodily injury and property damage. If Commercial General Liability Insurance or other form with a general aggregate limit is used, either the general aggregate limit shall apply separately to this project/location or the general aggregate limit shall be twice the required occurrence limit. This insurance shall indicate on the certificate of insurance the following coverages and indicate the policy aggregate limit applying to: premises #8..
- 419 -
-10-
and operations; broad form contractual; independent consultants and subcontractors; products and completed operations as applicable.
(c) Automobile Liability insurance with a minimum limit of liability per occurrence of $1,000,000 for bodily injury and property damage. This insurance shall cover any automobile for bodily injury and property damage.
(d) Professional Liability insurance with a minimum limit of $1,000,000 per claim and policy aggregate. If coverage is on a claims made basis it shall be maintained for at least three (3) years following completion of the work.

If at any time any of said policies shall be unsatisfactory to the City, as to form or substance, or if a company issuing such policy shall be unsatisfactory to the City, the Consultant shall promptly obtain a new policy, submit the same to the Risk Manager for approval and submit a certificate thereof as hereinabove provided. Upon failure of the Consultant to furnish, deliver or maintain such insurance and certificates as above provided, this Agreement, at the election of the City, may be forthwith declared suspended or terminated.

Failure of the Consultant to obtain and/or maintain any required insurance shall not relieve the Consultant from any liability under this Agreement, nor shall the insurance requirements be construed to conflict with or otherwise limit the obligations of the Consultant concerning indemnification. The City, its agents, officers, employees, and volunteers shall be named as an additional insured on all insurance policies required herein, except Workers' Compensation and Professional Liability. The Workers' Compensation insurer shall agree to waive all rights of subrogation against the City, its agents, officers, employees, and volunteers for losses arising from work performed by Consultant for the City. The Consultant's insurance policy(ies) shall include a provision that the coverage is primary as respects the City; shall include no special #8..
- 420 -
-11-
limitations to coverage provided to additional insured; and, shall be placed with insurer(s) with acceptable Best's rating of A:VII or with approval of the Risk Manager. The Consultant must deliver certificates evidencing existence of the insurance listed above to the City prior to the time the contract is signed.

CONSULTANT shall provide CITY with separate endorsements evidencing proof of the CITY’s additional insured status as to both the general liability and automobile liability insurance policies. In addition, CONSULTANT shall provide CITY with a Workers Compensation subrogation waiver by way of a separate endorsement. All endorsements referenced above must include the applicable policy number.

For any claims related to this project, the CONSULTANT’S insurance coverage shall be primary insurance as respects the Entity, its officers, officials, employees, and volunteers. Any insurance or self-insurance maintained by the Entity, its officers, officials, employees, or volunteers shall be excess of the CONSULTANT’S insurance and shall not contribute with it.

15. TERMINATION OF AGREEMENT.

Termination by City for Default of Consultant
Should Consultant default in the performance of this Agreement or materially breach any of its provisions, at its option, City may terminate this Agreement by giving written notification to Consultant. The termination date shall be the effective date of the notice. For the purposes of this section, material breach of this Agreement shall include, but not be limited to, any of the following: failure to perform required services or duties, willful destruction of City's property by Consultant, dishonesty or theft. #8..
- 421 -
-12-
Termination by City for Convenience
The City may also terminate the Consultant's performance under the Agreement, either in whole or in part, at its own discretion, or when conditions encountered during the Work make it impossible or impracticable to proceed, or when the City is prevented from proceeding with the Agreement by act of God, by law, or by official action of a public authority, or upon a determination by the City that such termination is in the best interest and convenience of the City, or whenever the City is prohibited from completing the Work for any reason. The City shall provide no less than ten (10) calendar days written notice of its intent to terminate the Agreement for convenience, and shall endeavor to provide the Consultant with consultation with the City prior to termination.

Post-Termination Procedure
Upon receipt of a written notice of termination pursuant to either of the foregoing paragraphs, the Consultant shall:
a. Cease its work as directed in the notice of termination as of the termination date and see to it that its employees, subconsultants and agents are notified of such termination and act as specified in the notice of termination;
b. Terminate all orders and Subcontractors except as necessary to complete any portion of the Work that is not terminated; c. If directed in writing by the City to do so, assign all right, title and interest in subcontracts and materials in progress to City, in which case the City will have the right at its discretion to settle, or pay any or all claims arising out of the termination of such #8..
- 422 -
-13-
subconsultants, but in no event shall recovery by any Consultant or subconsultant include lost profits for portions of the Work not completed or undertaken, including materials not delivered; d. Deliver or otherwise make available to the City all data, drawings, specifications, reports, estimates, summaries and such other information and material as may have been accumulated by the Consultant in performing the Work whether completed or in process; e. Settle outstanding liabilities and claims, subject to the approval of City;
f. Complete performance of such part of the Work as has not been terminated;
g. Take such other actions as may be necessary, or as may be directed by the City for the protection and preservation of the Work and/or property related to the Work;
h. If City so requests, and at City's cost, Consultant shall provide sufficient oral or written status reports to make City reasonably aware of the status of Consultant's work on the project. i. The Consultant understands and agrees that City may, in City's sole discretion, refuse to pay Consultant for that portion of Consultant's services which were performed by Consultant on the project prior to the termination date and which remain
unacceptable and/or not useful to City as of the termination date. #8..
- 423 -
-14-
City will pay Consultant an amount based on the percentage of satisfactory work completed in accordance with the notice of termination. The final payment to the Consultant after termination for convenience shall be limited to amounts due and owing under the Agreement at time of termination, including the following:
a. The cost of settling and paying valid claims arising out of the termination of the Work such as subconsultant agreements or contracts for materials;
b. The Agreement price allocable to the portion of the Work properly performed or goods supplied to the work site by the Consultant as of the date of termination, as determined in accordance with the notice of termination, reduced by any sums previously paid to the Consultant.

Authorization to Terminate Agreement
Termination of the Agreement may be invoked by the City Manager, or his/her designee, subject to the right of the Consultant to appeal the City Manager, or his/her designee’s, decision to the City Council. The Consultant shall appeal by notifying the City Clerk in writing within ten (10) calendar days of receipt of written notification from City of termination of the Agreement. In the event that termination of this Agreement is upheld by the City Council, any cessation of payment of delay claims, extended claims, Eichleay claims, or any other claims for delay shall be retroactive to the date of termination selected by the City Manager, or his/her designee.
#8..
- 424 -
-15-

16. CERTIFIED PAYROLL REQUIREMENT.

For consultants performing field work on public works contracts on which prevailing wages are required: The Consultant shall comply with the provisions of Section 1776 of the California Labor Code, regarding payroll records, and shall require its subconsultants and subcontractors to comply with that section as may be required by law.

17. INDEMNITY.

The Consultant shall hold the City, its agents, officers, employees, and volunteers, harmless from and save, defend and indemnify them against any and all claims, losses, liabilities, judgments or damages from every cause, including but not limited to injury to person or property or wrongful death, including reasonable costs and expenses of defense of any judicial or administrative action, arising directly or indirectly out of any negligent or intentional act or omission of Consultant, or its agents, officers, employees, or volunteers relating to or during the performance of its obligations under this Agreement.

Consultant's obligation to defend, indemnify, and hold the City, its agents, officers, and employees harmless under the provisions of this paragraph is not limited to or restricted by any requirement in this Agreement for Consultant to procure and maintain a policy of insurance.

18. DISPUTE RESOLUTION.

All claims, controversies, or disputes arising out of, or relating to the formation of this Agreement, or the breach, termination execution, enforcement, interpretation, or validity of this Agreement, including the determination of the scope or applicability of this contract provision shall be determined by binding arbitration in Modesto, California by one arbitrator, except as otherwise specified in this Agreement. The American Arbitration #8..
- 425 -
-16-
Association shall administer the arbitration under its Arbitration Rules then in effect, subject to the modifications of those rules contained in this paragraph. This agreement to arbitrate shall be specifically enforceable under the prevailing law of any court having jurisdiction, and the award rendered by the arbitrator may be entered in any court having jurisdiction. The appropriate venue for any arbitration or court proceeding relating to or arising out of this provision shall be in Stanislaus County, California.

This paragraph is not intended to and does not waive the claim filing requirements found in California Government Code section 900 et seq. In the event that a timely and legally sufficient, arbitrable claim is filed by Consultant with City, and the claim is rejected in whole or in part by City, this paragraph shall result in the conclusive, final, and binding resolution of all the issues presented in the claim by Consultant so long as any issues presented by the claim are arbitrable. Claims rejected by City or by operation of law, shall be submitted by Consultant to arbitration pursuant to the Arbitration Rules of the American Arbitration Association within ninety (90) days after mailing of the written rejection by City to Consultant.

Otherwise, the claim or claims shall be deemed waived in their entirety.

The “fast track’ rules of the American Arbitration Association shall apply to any claim or counterclaim less than ONE HUNDRED FIFTY THOUSAND AND 00/100 ($150,000.00) DOLLARS. In arbitration not proceeding under the “fast track” rules, the arbitrator shall have the power to order that depositions be taken and other discovery be made.

Both City and Consultant shall have the right, upon written notice, to take no more than three (3) depositions of the other as a matter of right in an arbitration proceeding under the “fast track” rules.
#8..
- 426 -
-17-
Whether or not City and Consultant may be engaged in interstate commerce, any controversy or dispute mentioned above shall be determined by, and the parties shall be bound by, the substantive law of the State of California, and not the Federal Arbitration Act at 9 USC Section 1 et seq.

The arbitrator may grant any remedy or relief deemed by the arbitrator just and equitable under the circumstances, whether or not such relief could be awarded in a court of law. The arbitrator shall be empowered to award monetary sanctions against a party for failure of cooperation in the arbitration. The arbitrator shall, in written award, allocate all the costs of the arbitration, including the fees of the arbitrator and the reasonable attorney fees of the prevailing party, against the party who did not prevail. The prevailing party shall be the party in whose favor the majority of the central issues in the case are resolved.

Notwithstanding anything in this provision to the contrary, the arbitrator shall have no power to award punitive damages or other damages not measured by the party’s actual damages (excluding litigation costs and fees) against any party. This limitation of the arbitrator’s powers under this Agreement shall not operate as an exclusion of the issue of punitive damages from this Agreement to Arbitrate sufficient to vest jurisdiction in a court with respect to that issue.

Consultant shall include in all subcontracts a specification whereby the subcontractor consents to being joined in an arbitration between City and Consultant involving the work of the subcontractor to be joined. Consultant’s failure to do so shall be a breach of this Agreement.
#8..
- 427 -
-18-
The parties hereby waive any rights provided by Title 9.2 of the California Code of Civil Procedure, Section 1296. The arbitrator’s award shall be deemed final, conclusive and binding to the fullest extent allowed by California law.

19. ENTIRE AGREEMENT.

This Agreement and its exhibits contain the entire understanding between Consultant and City. Additional or new terms contained in this Agreement which vary from Consultant's proposal are controlling and are deemed accepted by Consultant by shipment of any article or other commencement of performance hereunder. All previous proposals, offers and communications relative to this Agreement, whether oral or written, are hereby superseded except to the extent that they have been incorporated into this Agreement. No future waiver of or exception to any of the terms, conditions, and provisions of this Agreement shall be considered valid unless specifically agreed to in writing by all the parties.

20. PARTIAL INVALIDITY.

If any provision in this Agreement is held by a court of competent jurisdiction to be invalid, void, or unenforceable, the remaining provisions shall nevertheless continue in full force without being impaired or invalidated in any way.

21. WAIVER.

The waiver by any party to this Agreement of a breach of any provision hereof shall be in writing and shall not operate or be construed as a waiver of any other or subsequent breach hereof unless specifically stated in writing. #8..
- 428 -
-19-

22. AUDIT.

The City's duly authorized representative shall have access at all reasonable times to all reports, contract records, contract documents, contract files, and personnel necessary to audit and verify Consultant's charges to City under this Agreement.

Consultant agrees to retain reports, records, documents, and files related to charges under this Agreement for a period of four (4) years following the date of final payment for Consultant services. City's representative shall have the right to reproduce any of the aforesaid documents.

23. GOVERNING LAW.

This Agreement shall be governed according to the laws of the State of California.

24. HEADINGS NOT CONTROLLING.

Headings used in the Agreement are for reference purposes only and shall not be considered in construing this Agreement.

25. COMPLIANCE WITH LAWS.

Consultant shall insure compliance with all safety and hourly requirements for employees, in accordance with federal, state, and county safety and health regulations and laws. Consultant shall fully comply with all applicable federal, state, and local laws, ordinances, regulations and permits.

26. CITY BUSINESS LICENSE.

Consultant will have a City of Modesto business license. #8..
- 429 -
-20-
IN WITNESS WHEREOF, the City of Modesto, a municipal corporation, has authorized the execution of this Agreement by its City Manager and attestation by its City Clerk under authority of Resolution No. 2024- __ , adopted by the Council of the City of Modesto on the ___ day of ___ , 2024, and NorthStar Engineering Group has caused this agreement to be duly executed as of the Effective Date. #8..
- 430 -
620 12th Street Modesto, CA 95354
P: (209) 524-3525 F: (209) 524-3526
PROPOSAL – 23-623 – REVISION 1
BYSTRUM AREA – PHASE 1

STRENGTHEN AND REPLACE

WATER MAINS PROJECT

CERES, CA
NOVEMBER 14, 2023
TASK 1 - PROJECT MANAGEMENT, MEETINGS, COORDINATION, PROCESSING, AND PERMITTING A. Attend project kick-off with City Staff to discuss the project intent, scope, approach, project limits, schedule, budget, regulatory items, project requirements, plan processing, entitlements, environmental requirements, and record any feedback that would require adjustments.

B. Attend bi-weekly meetings as outlined in the RFP for the submittal documents. Assume 4 meetings will be held inperson and all other meetings will be virtual with Consultants and City Staff.

C. Coordinate with City and County Staff during review and approval process.

D. Attend meetings for coordination during the design and Improvement Plan process, as necessary.

E. Prepare for meetings, prepare Agendas, record meeting minutes for all meetings, and distribute to meeting attendees.

F. Maintain a decision log of all decisions made in meetings, on phone calls and/or in written communication.

G. Prepare a bar chart project schedule itemizing all activities and subtasks to successfully meet project milestones.

Provide monthly updates of the project schedule to the City Project Manager.

H. Provide a brief narrative update on each invoice describing work completed during the invoice period.

I. Provide blueprints, copies and reproducibles as requested.

J. Any charges associated with US Postal Service or other overnight delivery charges.

K. Review applicable Agency Guidelines, Requirements, Design Standards, Utility Master Plans, Record Improvement Plans, Final Maps, and other supporting documentation. Identify existing utilities to be impacted by the project.

L. Perform high level quality control and project oversite throughout the development of the design, plans, and overall project.

M. Prepare Civil submittal packages for submission. Revise Improvement Plans in accordance with the Agency review comments. This Task estimates 4 submittal reviews prior to approval. Additionally, an AutoCAD version 2020 compatible drawing file and Microsoft Word Specifications will be provided with the final submittal.

TASK 2 - TOPOGRAPHIC SURVEYING
A. RECORD RESEARCH
a. Research existing Stanislaus County Records for Record Maps including Parcel Maps, Subdivision Maps, Record of Surveys, and Corner Records in the vicinity of the project.

B. RIGHT-OF-WAY AND CONTROL FIELD SURVEY
a. Horizontal datum will be based on the City of Modesto’s GPS Network per Record of Survey recorded in Book 22 of Surveys at page 51, Stanislaus County Records and be based on grid measuements.

EXHIBIT A
#8..
- 431 -
Bystrum Area – Phase 1 Strengthen and Replace Water Mains Project Scope of Work

Page 2 ends

b. Vertical datum will be on the City of Modesto’s Vertical Control Network (NAVD88 Datum). c. The Survey will be performed by either GPS RTK Methods or using conventional methods to maintain a 0.1 foot horizontal and vertical accuracy.

C. LAND NET SURVEY
a. Download the current Stanislaus County GIS Assessor Parcel Map as the Land Net Base Map for the existing street alignments.
b. Locate the existing Monuments of record as shown on the recorded maps per Stanislaus County Records to establish the basis for the insertion of the Stanislaus County GIS assessor parcel map into the Topographic drawing.

D. TOPOGRAPHIC SURVEY
a. Perform a Topographic Field Survey for the proposed water main alignments along each of the roadways within the limits as shown as the Project Area and described in the Request for Proposal. The Topographic Survey will be performed utilizing GPS RTK Methods or using conventional methods as to maintain 0.1 foot horizontal and vertical accuracies. The Topographic Survey will locate all visible surface features and utilities on 200-foot grid sections including lip of gutter, flowline, top of curb, back of sidewalk, edge of pavement, crown, center of intersection grade, any grade breaks, high points, low points, and angle points. The Topographic Survey will include existing features including but not limited to utility poles, vaults, backflow preventers, meter boxes, trees, fences, catch basins, rockwells, water valves, manholes, centerline monuments, and signal poles. b. Invert elevations for storm manholes, storm inlets, and sewer manholes, including pipe size, direction of flow, and pipe material will not be measured.
c. Prepare a Topographic Drawing to include all features located during the Topographic Field Survey including contours prepared at 1-foot intervals. Prepare the Topographic Drawing in AutoCAD Civil 3D 2020 compatible format at a scale as requested by Client.

E. POTHOLE SURVEY
a. Perform a Field Survey to as-built the pothole locations for approximately 50 potholes. Survey will be performed after the Pothole Consultant has backfilled and repaired pothole locations and has provided the reference.
b. Compile the Pothole Subconsultant’s notes with the Field Survey data and prepare a Pothole Drawing and Table to include all the pothole locations, utility information, PNEZD, depths to top and bottom, size, and material type.

TASK 3 - CIVIL ENGINEERING CONSTRUCTION DOCUMENTS AND SPECIFCATIONS A. Prepare and provide a Basis of Design Report with 10% Preliminary Design Documents. Supporting documentation as appropriate will be provided to support the proposed water system layout, existing utility information collected, survey data, agency coordination, and project approach to completing the design.

B. Prepare an off-site base plan for the project site which includes water improvements for approximately 10,000 lineal feet of water mains replacement in the Bystrum Area of City of Ceres, located between Herdon Road and Richland Avenue and between Nadine Avenue and Woodworth Avenue which includes approximately 164 water laterals connections. Protection of existing water mains at fill points with temporary double check detector assemblies, temporary blow-offs to discharge water to storm drain or sewer system during acceptance testing process, trench patch, trench repair, abandonment of the existing water main, installation of 164 new water service laterals while reEXHIBIT A #8..
- 432 -
Bystrum Area – Phase 1 Strengthen and Replace Water Mains Project Scope of Work

Page 3 ends

establishing connections to customers water meters, and installation of new fire hydrants. If off-site improvements extend beyond the limits described in this project, additional fees will be required. Any modifications to the approved off-site public base plan will require additional fees.

C. Identify demolition requirements and prepare a Demolition Plan with notes, call-outs, and specifications.

D. Design and replace the existing water main in street sections described above. All existing services and devices such as fire hydrants, meters, etc. will need to be relocated and connected to the new water main. The off-site water system will include water valves, fire hydrants, and water service piping from the new public water main in the existing street.

E. Coordinate with the Dry Utility Service Providers and show (for reference only) the location of existing dry utilities.

F. Prepare 35%, 70%, 90%, and 100% Off-Site Public Improvement Plans per City of Modesto Standards that will include a Cover Sheet, Notes-Specification Sheet, Construction Detail Sheet(s), Topography Plan(s), Demolition Plan(s), Dimension Plan(s), Water Plan(s), and Erosion Control Plan(s). Submit an electronic copy and 24”x36” set of plans on the City of Modesto Sheet Border, 8.5”x11” Specifications (70%, 90%, and 100% only), and Probable Cost Estimate (35%, 70%, 90%, and 100%), of the Off-Site Public Improvement Plans to the City of Modesto for review and comment. Make requested City of Modesto corrections to the Off-Site Public Improvement Plans. At each submittal stage the previous round of submittal comments will be addressed with a Comment Response Letter.

G. Prepare a Schematic 8.5”x11” Exhibit for each property where an existing water service is to be relocated. Each exhibit will include the property address, an aerial background, existing gas meter location, existing hose bib location, existing water meter location, proposed water meter location, and proposed schematic water service lateral routing.

H. Provide Project Specifications for the 70%, 90%, and 100% submittal packages in Microsoft Word. Project Specifications will be related to the Civil Engineering improvements and provided to the City of Modesto to include in the overall project documents. The Project Specifications will include an 8.5”x11” water service installation summary table identifying the plan sheet number for reference, property address, boring length, trenching length, and whether the property has a water softener. The City of Modesto will provide the front end boiler plate specification templates for the Civil Engineer to utilize and modify for the project.

I. Prepare an Engineer’s Estimate and Bid Quantity for bidding purposes for the 35%, 70%, 90%, and 100% submittal packages only. One Engineer’s Estimates and one Bid Quantity Sheet will be provided for the project at the 35%, 70%, 90%, and 100% phase of the project.

TASK 4 - BIDDING ASSISTANCE, CONSTRUCTION ADMINISTRATION AND RECORD DRAWINGS A. Attend one pre-construction/field project kick-off meeting.

B. Provide supplemental instructions and clarifications to bidders, as necessary.

C. Produce addendums to modify the bid documents (plans and specifications), as required.

D. Respond to Contractor’s Requests for Information (RFI) during the bidding process and throughout the course of construction. (Assumes 30 RFIs)
E. Produce addendums to modify the construction documents (plans and specifications), as required to address unforeseen conditions that arise during construction.

F. Review and process submittals and shop drawings from Contractor (assumes 60 Contractors Submittals).

G. Assist in determining and processing Request for Information and Change Orders.

EXHIBIT A
#8..
- 433 -
Bystrum Area – Phase 1 Strengthen and Replace Water Mains Project Scope of Work

Page 4 ends

H. Perform periodic field visits at the major construction stages of the project to answer construction questions.

I. Perform one site visit after completion of construction and prepare one ‘punchlist’ to identify visible deficiencies related to the Civil Drawings. Perform one follow up visit after deficiencies are addressed. Record Drawing preparation and review of Contractor field revision documents (total of two site visits).

EXCLUSIONS:

1. Any task not listed in the above Scope of Work.

2. Title Reports and Supplemental Documentation (to be provided by City).

3. Agency Fees, Map Checking Fees, Recording Fees, Filing Fees, Applications, and Permits.

4. This Scope of Work excludes any time required to identify, discuss, present, or represent any occupational discrepancies, boundary disputes, gaps, overlaps, or title discrepancies. Client will be advised should our survey find conflicts with title or occupation evidence. Services shall be billed on a Time and Materials basis shown on our current Rate Schedule at the time the services are rendered.

5. Topographic Survey of individual lots, Record of Survey, Lot Line Adjustment, Certificate of Compliance, Corner Records, Acquisitions, Parcel Map, Final Map, Easements, Plats, Legal Descriptions, Special Mapping Services not specifically identified in this scope, ALTA/NSPS Survey or Easement Abandonment, Construction Staking, etc.

6. LAFCO, CFD, SIA, Specific Plan, General Plan, EIR and CEQA Amendment, Assessment Districts, Annexations, Reimbursement Agreements, Sound Studies, and Archeological Mitigation Program.

7. Any coordination or processing with State or Federal Agencies.

8. Arborist Report, Landscaping, and Irrigation Plans.

9. Any applicable RWQCB Application and/or Annual Fees, Annual Compliance Report, NOI Submittal Fees.

10. Public Agency Engineering or Analysis not specifically listed in the above Scope of Work.

11. Dry Utility Design (lighting, electrical, undergrounding overhead lines, gas, CATV, joint trench, etc.).

12. Traffic Control Plan, Traffic Engineering, Additional Lanes, Signage, Striping, and Traffic Signal Design.

13. Decorative Wall, Gate, Fencing, and Structural Retaining Wall Design and Specifications.

14. SWPPP, Monitoring and Inspections (QSD/QSP/BMP and others), Annual Reports, Notice of Termination (NOT), REAP, Lab Fees, Testing, etc.

15. ISR, Air Board Permitting, and Dust Control Plans.

16. Geotechnical Engineering (Structural Sections), Dewatering Design, Blasting Recommendations/Design, Trenching/Excavation analysis relating to the site, Hydrologic Engineering, Environmental Engineering.

17. Any work related to Plans or Specifications for a pump station not specifically identified above.

18. Hydraulic Water Modeling Calculations to determine pipe size. Water Profile Plan Views. Fire Flow Test, Fire Sprinkler Design/Well, Tank, and Booster Pump Design, Calculations, Plans, and Specifications.

19. Sewer System Design, Calculations, Plans, Septic System, Grease Traps, Sewer Lift Stations, etc.

20. Storm Drainage System Design, Calculations, Plans, Retention System, Lift Stations, etc. Project assumes existing storm water conveyance system already exists and no improvements will be required.

21. Storm Water Quality Analysis, Design, Calculations and Report. Hydromodification, Volume Reduction and Treatment.

22. Cathodic Protection Design.

23. Processing and plan preparation not specifically identified in the above Scope of Work.

24. Contractor Change Order Reviews, Negotiations, Construction Inspection, Management, and Observation Reports.

25. Road rehabilitation outside the limits of trench work, Grading and Drainage Plans, Curb Returns, Accessible Ramps, Striping, Signage, Temporary Traffic Control, Detour Plans, etc.

26. Project Advertisement of Plans and Specifications for construction bids, Review of Construction Bids, Project awarding and Staff Reports to City Council.

EXHIBIT A
#8..
- 434 -
Subconsultant
ITEM TASK ACTIVITY Mozingo
$215.00 $185.00 $165.00 $135.00 $185.00 $275.00 50 Potholes TASK 1 - Management, Meetings, Coordination, Processing A-M Project Management, Meetings, Coordination, Processing and Permitting 8 280 24 312 $57,480.00 Sub-Total 312 $57,480.00
TASK 2 - Topographic and Property Boundary Survey
A Record Research 1 1 4 6 $1,140.00
B Right-of-Way and Control Field Survey 1 1 2 10 14 $3,520.00 C Land Net Survey 1 1 6 8 16 $3,710.00
D Topographic Survey 1 4 24 6 24 59 $11,905.00
E Pothole Survey 1 4 8 6 12 31 $82,500.00 $88,945.00
Sub-Total 126 $109,220.00
TASK 3 - Civil Engineering Construction Documents and Specs.

A-I Civil Engineering Construction Documents, Estimates, and Specifications 16 160 240 480 896 $137,440.00 Sub-Total 896 $137,440.00
TASK 4 - Bidding Assit., Construction Admin., Record Drawings A-I Bidding Assistance, Construction Administration and Record Drawings 8 100 40 16 164 $28,980.00 Sub-Total 164 $28,980.00
TOTAL 37 551 304 528 24 54 1498 $333,120.00
Bystrum Area - Phase 1

PRIMARY SCOPE TASKS
14-Nov-23
Estimated Level of Effort and Cost
Total Hours Total Cost
Strength and Repalce Water Mains Project
Civil Designer Project Manager or
Civil Engineer
Principal In Charge
/ Director CAD Drafter Land Surveyor 2-Person Survey Crew

EXHIBIT B
#8..
- 435 -

CITY OF MODESTO

COUNCIL AGENDA REPORT
DATE OF MEETING:

January 9, 2024
Date: January 2, 2024
TO: Mayor and City Council
FROM: Christina Alger, Director of Human Resources and
Jose M. Sanchez, City Attorney
SUBJECT: Second Amendment to Employment Agreement for City Clerk CONTACT: Christina Alger, Director of Human Resources
[email protected], 209-571-5126
DESCRIPTION:

Consider approving a Second Amendment to the City Clerk Employment Agreement with Diane Nayares-Perez, adjusting the compensation as a result of a positive performance evaluation. (Funding Source: General Fund)
STRATEGIC PLAN ELEMENT:

The recommended action supports the City of Modesto’s 2020-2025 Strategic Plan Initiative:

Service and Delivery Goal J: Building a High-Performing Organization by Attracting and Retaining High Performance Employees.

BACKGROUND:

On August 30, 2021, Council directed staff to request quotes for an executive recruitment to fill the position of City Clerk. An extensive search brought forth five candidates for Council interviews. On April 5, 2022, Council appointed Ms. Nayares-Perez effective April 26, 2022, to the position of City Clerk by Resolution No. 2022-180.

Diane Nayares-Perez came to the City with many years of City Clerk’s Office experience. She began as a legal secretary for a local law firm and the Department of Justice before becoming a Deputy Clerk of the Board for Stanislaus County. She joined the City of Modesto as the Assistant City Clerk for seven years before becoming the City Clerk for the City of Ceres. She cumulatively brings over 30 years of experience to our City Clerk’s Office. She holds her Certified Municipal Clerk certification and is currently working toward her Master Municipal Clerk certification.

DISCUSSION:

Ms. Nayares-Perez has been serving as the City Clerk for just under two years. During this time, she and Council established goals and expectations, and met on her progress during her tenure. Most recently a full performance evaluation was conducted. #9..
- 436 -
City Council, January 9, 2024
Second Amendment to Employment Agreement for City Clerk

Page 2 of 2 ends

Annual performance evaluations are an important way for the City Council and the Charter Officers to ensure effective communications about expectations and performance. Pursuant to the City Clerk’s Employment Agreement, consideration shall be given on an annual basis to increase compensation following an annual performance evaluation.

Council met in closed session on December 5, 2023, to conduct the performance evaluation.

The Mayor publicly reported out that the Council had conducted the evaluation and unanimously agreed that Ms. Nayares-Perez is doing an excellent job.

Given the positive evaluation, the Council provided direction to bring forward an amendment to the City Clerk’s compensation for consideration at the January 9, 2024 Council meeting. The attached Second Amendment to the City Clerk Employment Agreement provides for a merit adjustment based on the results. This will result in a 4.1% increase in Mr. Nayares-Perez’s base salary, from $147,451.20 to $153,545.60 and being effective December 5, 2023, to coincide with the delivery of the evaluation.

There are no other changes to the Employment Agreement.

FISCAL IMPACT:

The fiscal impact for the increase in compensation of $6,094 in base salary and will be funded by existing budget for FY 23-24 within cost center 0100-05010 – General Fund.

COMMITTEE RECOMMENDATION:

This item was not taken to a committee.

RECOMMENDED COUNCIL ACTION:

Staff Recommendations:

Resolution approving a Second Amendment to the Employment Agreement with Diane Nayares-Perez, to increase base salary to $153,545.60.

Approved by:

Christina Alger, Director of Human Resources
Jose M. Sanchez, City Attorney
Attachments:

1. Resolution

2. Second Amendment to Employment Agreement with Diane NayaresPerez #9..
- 437 -
1 MODESTO CITY COUNCIL
RESOLUTION NO. 2024 -

RESOLUTION APPROVING A SECOND AMENDMENT TO THE

EMPLOYMENT AGREEMENT WITH DIANE NAYARES-PEREZ, TO
INCREASE BASE SALARY TO $153,545.60
WHEREAS, on April 5, 2022, by Resolution No. 2022-180, City Council appointed Nayares-Perez to the role of City Clerk and entered into an Employment Agreement with Ms. Nayares-Perez; and
WHEREAS, in 2023, the City engaged in labor negotiations with all represented and unrepresented employees, except for the Modesto City Firefighters Association.

Through labor negotiations, the City Council agreed to implement the results of a Citywide labor market study that analyzed all City positions, cost of living increases for the term of the successor Memorandums of Understanding, and certain benefit changes; and WHEREAS, the City Council also adopted Resolution No. 2023-287 and Resolution No. 2023-288, extending the salary market adjustments resulting from the City staff market study, cost of living increases, and benefits the City Council offered to the Modesto Confidential and Management Association to the City’s unrepresented employees, including Charter Officers. Ms. Nayares-Perez serves as City Clerk, which is a Charter Officer position; and
WHEREAS, pursuant to Section 4(b) of the Employment Agreement and labor negotiations, the City Council amended the Employment Agreement in order to adjust Ms. Nayares-Perez’s compensation and benefits consistent with the compensation and benefits offered to employees in the Modesto Confidential and Management Association; and
#9..
- 438 -
2 WHEREAS, pursuant to Section 11 of the Employment Agreement, on December 5, 2023, the City Council conducted Ms. Nayares-Perez’s performance evaluation. As a result of a positive evaluation, the City Council wishes to amend the Employment Agreement by providing Ms. Nayares-Perez a merit increase of four and one-tenth percent (4.1%) effective December 5, 2023.

NOW, THEREFORE, BE IT RESOLVED by the Council of the City of Modesto that it hereby approves a Second Amendment to the Employment Agreement for Diane Nayares-Perez to increase the base salary to $153,454.60.

The foregoing resolution was adopted at a regular meeting of the Council of the City of Modesto held on the 9th day of January 2024, by Councilmember ?, who moved its adoption, which motion being duly seconded by Councilmember ?, was upon roll call carried and the resolution adopted by the following vote:

AYES: Councilmembers: ?
NOES: Councilmembers: ?
ABSENT: Councilmembers: ?
ATTEST: _____________________________
DANA SANCHEZ, Assistant City Clerk
(SEAL)
APPROVED AS TO FORM:

BY: ________________________________
JOSE M. SANCHEZ, City Attorney
#9..
- 439 -
-1-

SECOND AMENDMENT TO EMPLOYMENT AGREEMENT

WITH DIANE NAYARES-PEREZ
This Second Amendment to Employment Agreement (“Second Amendment”) is made and entered into this __ day of January 2024, by and between the CITY OF MODESTO (“CITY”) and Diane Nayares-Perez- (“EMPLOYEE”).

RECITALS
WHEREAS, on April 5, 2022, by Resolution No. 2022-180, City Council appointed Nayares-Perez to the role of City Clerk and entered into an Employment Agreement with EMPLOYEE (“Employment Agreement”); and
WHEREAS, in 2023, the City engaged in labor negotiations with all represented and unrepresented employees, except for the Modesto City Firefighters Association. Through labor negotiations, the City Council agreed to implement the results of a City-wide labor market study that analyzed all City positions, cost of living increases for the term of the successor Memorandums of Understanding, and certain benefit changes; and WHEREAS, the City Council also adopted Resolution No. 2023-287 and Resolution No. 2023-288, extending the salary market adjustments resulting from the City staff market study, cost of living increases, and benefits the City Council offered to the Modesto Confidential and Management Association to the City’s unrepresented employees, including Charter Officers.

EMPLOYEE serves as City Clerk, which is a Charter Officer position; and WHEREAS, pursuant to Section 4(b) of the Employment Agreement and labor negotiations, the City Council amended the Employment Agreement in order to adjust EMPLOYEE’s compensation and benefits consistent with the compensation and benefits offered to employees in the Modesto Confidential and Management Association; and #9..
- 440 -
-2-
WHEREAS, pursuant to Section 11 of the Employment Agreement, on December 5, 2023, the City Council conducted EMPLOYEE’s performance evaluation. As a result of a positive evaluation, the City Council wishes to amend the Employment Agreement by providing EMPLOYEE a merit increase of four and one-tenth percent (4.1%) effective December 5, 2023.

AGREEMENT

1. Section 4(a) of the Employment Agreement, “Salary,” first paragraph, is amended to add a four and one-tenth percent (4.1%) merit increase. No changes are being made to the second and third paragraphs, which reflect previously approved salary adjustments under adopted Resolution No. 2023-287 and Resolution No. 2023-288. Section 4(a) of the Employment Agreement is amended to read as follows:
“SECTION 3: Salary
a. Effective December 5, 2023, CITY agrees to pay EMPLOYEE an annual base salary of One Hundred Fifty-Three Thousand Five Hundred Forty-Five Dollars and Sixty Cents ($153,545.60), payable in installments at the same time that the other employees of CITY are paid. This annual base salary reflects a four and onetenth percent (4.1%) merit increase.

Effective June 18, 2024, CITY agrees to increase EMPLOYEE’s annual base salary as follows: an additional three percent (3%) cost of living increase, and a longevity adjustment in the amount of two and one-half percent (2.5%), payable in installments at the same time that the other employees of CITY are paid.

Effective July 1, 2025, CITY agrees to increase EMPLOYEE’s annual base salary as follows: an additional three percent (3%) cost of living increase and a step increase in the amount of four percent (4%) payable in installments at the same #9..
- 441 -
-3-
time that the other employees of CITY are paid. The Step increase is subject to EMPLOYEE being at the top step of her position’s range on June 30, 2024, and a positive evaluation by the City Council, pursuant to the Employment Agreement.

In addition, effective June 30, 2026, CITY agrees to increase EMPLOYEE’s annual base salary as follows: an additional three percent (3%) cost of living increase payable in installments at the same time that the other employees of CITY are paid.”

2. Except as amended by this Second Amendment, all terms and conditions of the Employment Agreement shall remain in full force and effect.

IN WITNESS WHEREOF, the City of Modesto, a municipal corporation, has authorized the execution of this Second Amendment to the Employment Agreement in duplicate by its Mayor and attestation by its Deputy City Clerk under the authority of Resolution No. 2024-____, adopted by the Council of the City of Modesto on the ___ of January 2024, and EMPLOYEE has caused this Second Amendment to the Employment Agreement to be duly executed.

CITY OF MODESTO,
a municipal corporation

EMPLOYEE
By: Sue Zwahlen, Mayor By: Diane Nayares-Perez
ATTEST:

By: Dana Sanchez, Assistant City Clerk
(SEAL)
#9..
- 442 -
-4-
APPROVED AS TO FORM:

By: Jose M. Sanchez, City Attorney
5568119.2
#9..
- 443 -
- 1 -
1/9/2024 4:00:00 PM

OFFICE OF THE CITY CLERK

NOTICE OF SPECIAL MEETING
Please take notice that a special Closed Session meeting of the Council of the City of Modesto has been called pursuant to Section 2-1.02 of the Modesto Municipal Code to be convened on
Tuesday, January 09, 2024 at 4:00 PM
and after the regularly scheduled meeting in the Tenth Street Place, Chambers Conference Room, Basement Level, 1010 Tenth Street, Modesto, California.

Any and all of the following agenda items are subject to action being taken by the Modesto City Council.

The business to be considered at said City Council meeting shall consist of a Closed Session concerning the following:

CLOSED SESSION
CONFERENCE WITH LEGAL COUNSEL – EXISTING LITIGATION
Two Case (Pursuant to Section 54956.9(d)(1) of the Government Code) Name of Case: Oscar Nelson Ocana Duarte v. City of Modesto, et al.

Superior Court of California, County of Stanislaus
Case No.: CV-21-002436
Silvina Martinez v. City of Modesto
Superior Court of California, County of Stanislaus
Case No.: CV-19-006820

CONFERENCE WITH LEGAL COUNSEL - EXISTING LITIGATION
Two Cases (Pursuant to Section 54956.9(a) of the Government Code) Name of case(s): Matthew Ponce v. City of Modesto
California Workers Compensation Appeals Board
Nos. ADJ16177617, ADJ8125320 & ADJ7075154
Billy Bush v. City of Modesto
California Workers Compensation Appeals Board
Nos. Unassigned
#10..
- 444 -
- 2 -
1/9/2024 4:00:00 PM

BY ORDER OF THE CHAIR
/S
Diane Nayares-Perez, City Clerk
Posted pursuant to Government Code Section 54956 on the bulletin board at Tenth Street Place on at by
date time signature
#10..
- 445 -

← All documents from this meeting