Agenda packet — Finance Committee, September 26, 2022

- 1 -
9/26/2022 3:00:00 PM
www.modestogov.com
AGENDA
City of Modesto

FINANCE COMMITTEE / COUNCIL WORKSHOP
Held Via Teleconference
(To Access Meeting Please See Instructions Below)
Monday. September 26, 2022 at 3:00 PM
*Roll Call: David Wright, Chair
Rosa Escutia-Braaton, Vice-Chair
Jenny Kenoyer, Member
Alternates: Tony Madrigal, Chris Ricci, Sue Zwahlen
* Please Note: In order to respond to COVID-19, and pursuant to AB 361, the City will hold this meeting via teleconference and Committee Members will be calling in. “Wordly” can translate into 25+ different languages! To access written translation during the meeting, please scan the QR Code or click this link https://attend.wordly.ai/join/RJDY-6364.
"Wordly" puede traducir a más de 25 idiomas diferentes! Para acceder a la traducción durante la reunión, por favor escanee el código QR o haga clic en el enlace https://attend.wordly.ai/join/RJDY-6364.

THIS MEETING WILL NOT BE PHYSICALLY OPEN TO THE PUBLIC
In order to minimize the spread of the COVID-19 virus, this meeting will be conducted pursuant to AB 361, which amended the Brown Act’s teleconferencing provisions and will not be physically open to the public. You may observe and participate in the meeting via teleconference as indicated below.

PARTICIPATING IN COMMITTEE MEETINGS IN CONFORMANCE WITH AB 361 The City of Modesto is providing alternatives to observe and participate in Committee meetings.

If you wish to make either a general public comment or to comment on a specific agenda item, you may use one of the following options:
- 1 -
9/26/2022
- 2 -
9/26/2022 3:00:00 PM

SUBMITTING COMMENTS BY E-MAIL
Written comments may be submitted via email to: [email protected] (include Agenda Item Number in the subject line). All comments will be shared with the Committee Members and placed in the record but will not be read aloud during the meeting. Written comments must be received by 1:00 p.m. on the day of the meeting.

VIRTUAL PARTICIPATION BY ZOOM VIDEO

CONFERENCING AND TELEPHONE
Joining the Committee meeting via Zoom
The City of Modesto is now offering the ability to view and participate in Committee meetings via telephonic conferencing via “Zoom” video conferencing computer technology. The meeting may be accessed through the use of Zoom using the following options:
 Enter the following link into an Internet Browser
https://us02web.zoom.us/j/86945970570,
 Enter the following link into an Internet Browser https://zoom.us/ and using the Webinar ID 869 4597 0570
 Passcode 84326
To use Zoom, please visit: https://zoom.us/ and either sign-up for a free Zoom account or continue as a guest. Once you have downloaded the app onto your mobile device, joined from your web browser, or downloaded the Zoom software on your computer you will be ready for the upcoming Committee meeting.

Joining the Committee meeting via Telephone
If you don’t have a smart phone or computer to access the meeting via Zoom, you can participate by phone, by calling 1-877-853-5257 (Toll Free) or 1-888-475-4499 (Toll Free) and enter the Webinar ID 869 4597 0570 Passcode 84326
Providing Public Comment on Zoom and by Telephone
The Committee Chairman will request public comment during the Public Comment periods on the meeting agendas and during each Regular Calendar Item on the Committee Agenda. Once the Chairman has announced the public comment period, please do one of the following.

USING A COMPUTER OR SMART PHONE APP:
 Click on the “Raise Hand” feature in the webinar controls. This will notify City staff that you have raised your hand.
 City staff will unmute your microphone when it is your turn to provide public comment.
 A prompt will appear to confirm you would like to be unmuted and then you will have three minutes to provide public comment.
 Once your public comment has ended, you will be muted again. - 2 -
9/26/2022
- 3 -
9/26/2022 3:00:00 PM
USING A REGULAR PHONE (not using a computer or smart phone APP):
 Dial *9 (star 9), this will notify City staff that you have “raised your hand” for public comment.
 City staff will unmute your microphone when it is your turn to provide public comment.
 You will hear “you are unmuted” and then you will have three minutes to provide public comment.
 Once your public comment has ended, you will be muted again.  If your phone is unmuted, and you are unable to be heard, the host may ask that you Dial *6 to toggle mute on/off in Zoom.

Additional Zoom resources/support
Please visit Zoom’s website support page on helpful tips to prepare for the meeting:
https://support.zoom.us/hc/en-us/categories/201146643
Council has not delegated directive or final approval authority to the Committees. Committee actions are recommendations to the full City Council, not final decisions on an issue.

PUBLIC COMMENTS
Please refer to special public comment instructions above.

Three-minute time limit per speaker
Only interested persons in the audience may present these matters. Under State law, Committee Members may respond to matters being presented under this item only as follows:
a. Briefly respond to statements made or questions raised. b. Ask a question for clarification.
c. Provide a reference to staff or other resources for factual information. d. Request staff to report back at a subsequent meeting. e. Finally, a Committee Member or the Committee itself may take action to direct staff to place a matter of business on a future agenda.

CONSENT ITEMS – ROLL CALL VOTE REQUIRED:

Information concerning the consent items listed below has been forwarded to each Committee Member prior to this meeting for study. Unless some member of the audience or Committee Member has a question concerning an item and asks that it be withdrawn from the consent list, the Committee approves the items at one time. The action taken by the Committee in approving consent items is set forth in the explanation of this individual item.

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

This Agenda is on file at the Modesto-Stanislaus Library Reference Room, 1500 I Street, Modesto, in the City Clerk’s Office, Sixth Floor, 10th Street Place, and is available on the City’s Web site at www.modestogov.com.
- 3 -
9/26/2022
- 4 -
9/26/2022 3:00:00 PM
In accordance with the requirements of Title II of the Americans with Disabilities Act (“ADA”) of 1990, the Fair Employment & Housing Act (“FEHA”), the Rehabilitation Act of 1973 (as amended), Government Code section 11135 and other applicable codes, the City of Modesto (“City”) will not discriminate against individuals on the basis of disability in the City’s services, programs, or activities. For more information, please visit the City of Modesto website at https://www.modestogov.com/865/Americans-with-Disabilities-Act-ADA In compliance with the Americans with Disabilities Act, if you need special assistance to participate in this meeting, please contact the City Clerk (209) 577-5396. Notification 48 hours prior to the meeting will enable the City to make reasonable arrangements to ensure accessibility to this meeting.

CONSENT
An item may be removed from consent and discussed at the request of an audience member or Committee Members.

1. Consider approving the recommended budget adjustments to Fiscal Year 2022-23 Annual Operating and Capital Improvement Program Budgets; and forwarding to Council for approval. (Funding Source: Various Funds)
BUDGET; Steve Christensen, 209-577-5390, [email protected]

2. Consider approving a one-time purchase for five Hayward Gordon pumps from Hayward Gordon Group, Ontario, Canada, for an amount not to exceed of $135,278, and forwarding to Council for approval. (Funding Source: Wastewater Fund) FINANCE DEPARTMENT; Cynthia Kline, 209-577-5412, [email protected]

3. Consider approving the Sole Source Purchase Agreement with Nutrien Ag Solutions, Sacramento, CA, for weed abatement chemical premix known as (Aqumix Proprietary Custom Pre-blend) for a one-year agreement with four one-year extension options, for an annual estimated amount of $70,000, and a total amount not to exceed $350,000 over five-years and forwarding to Council for approval. (Funding Source: Wastewater and Water Fund)
FINANCE DEPARTMENT; Cynthia Kline, 209-577-5412, [email protected]

4. Consider approving the Amendment #1 to the Facility and Fleet Maintenance Agreements between the City of Modesto and the Stanislaus Regional Transit Authority and forwarding to Council for approval. (Funding Source: Local Transportation Funds, State Transit Assistance, Farebox Revenue, & Federal Transit Administration (FTA))
FINANCE DEPARTMENT; DeAnna Christensen, 209-577-5387,
[email protected]
- 4 -
9/26/2022
- 5 -
9/26/2022 3:00:00 PM

5. Consider accepting an informational report on the May and June 2022 grant applications and awards and forwarding to Council for approval. (Funding Source: Not Applicable)
FINANCE DEPARTMENT; Maria Garnica, 209-577-5249,
[email protected]

6. Considering approval of a Sole Source Renewal Agreement with CivicPlus for continued, uninterrupted hosting and maintenance of the City of Modesto’s website (www.modestogov.com) for another four-year term at an amount of $149,350 plus a 10% contingency in the amount of $14,935 for a total amount not to exceed $164,285. (Funding Source: Information Technology Fund)
IT; Scott Conn, 209-577-5229, [email protected]

7. Consider authorizing the submittal of application(s) to the California Department of Resources, Recycling and Recovery for beverage container recycling grants that support recycling education, and encourages reducing and reusing beverage containers in Modesto, and forwarding to Council for approval. (Funding Source: California Department of Resources, Recycling and Recovery)
PUBLIC WORKS; Rosene Salmo, 209-577-5453, [email protected]

WRITTEN COMMUNICATIONS

NEW BUSINESS

8. Consider accepting the Annual Investment Report for Fiscal Year 2021-2022. (Funding Source: Various Funds)
FINANCE DEPARTMENT; Calogero Maniscalco, 209-577-5219,
[email protected]

MATTERS TOO LATE FOR THE AGENDA
These may be presented by members of the City Council and staff upon determination by a majority vote that an emergency exists, as defined by State law, or by a 2/3 vote that (1) there is a need to take immediate action, and (2) that the need for action came to the City’s attention after the agenda was posted.

ADJOURNMENT
Posted pursuant to Government Code Section 54954.2 on the bulletin board at Tenth Street Place on at by
date time signature
- 5 -
9/26/2022

CITY OF MODESTO

COMMITTEE AGENDA REPORT
DATE OF MEETING:

September 26, 2022
Date: September 6, 2022
TO: Finance Committee
David Wright, Chair
Rosa Escutia-Braaton, Vice-Chair
Jenny Kenoyer, Member
FROM: Joseph P. Lopez, City Manager
SUBJECT: Monthly Budget Adjustment Report – September 2022 CONTACT: Steve Christensen, Budget Manager, [email protected] 209-577-5390
DESCRIPTION:

Consider approving the recommended budget adjustments to Fiscal Year 2022-23 Annual Operating and Capital Improvement Program Budgets; and forwarding to Council for approval. (Funding Source: Various Funds)
STRATEGIC PLAN ELEMENT:

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

BACKGROUND:

Each month staff presents a variety of budget adjustments requiring the approval of the City Council. These changes are submitted to the Finance Committee for review prior to submission to Council and include an explanation and justification for each transaction.

This report includes a number of adjustments that have been identified by monitoring department budgets. Due to the number of adjustments, they are included as an attachment to this report (Exhibit A). As in past reports, adjustments are segregated by fund and department as appropriate. The adjustments are reflected in a more summarized version and supporting documentation is available for review upon request.

Also included in this report as an attachment (Exhibit B) is a summary of the budget adjustments approved by the City Manager and/or Budget Manager consistent with the recent change in authority levels that was approved by Council with the passing of the Fiscal Year 2019-20 Operating Budget via Resolution No. 2019-305.
#1..
- 6 -
Finance Committee, September 26, 2022
Monthly Budget Adjustment Report – September 2022

Page 2 of 2 ends

DISCUSSION:

The monthly budget adjustments attached as Exhibit A in this item include adjustments across various departments. These adjustments are explained in further detail within Exhibit A.

FISCAL IMPACT:

The fiscal impact of each item is noted in the attachments to this report. The adjustments are for Fiscal Year 2022-23.

Approved by:

Joseph P. Lopez, City Manager
Attachments:

1. Exhibit A – Budget Adjustments Requiring Council Approval

2. Exhibit B – Staff Approved Budget Adjustments
#1..
- 7 -
Finance Committee, September 26, 2022
Monthly Budget Adjustment Report
FISCAL YEAR 2022-23

COMMUNITY AND ECONOMIC DEVELOPMENT
 A budget adjustment in the amount of $100,000 necessary in the Capital Grants – Streets CIP Projects Fund 3160 for Project 101269 – Pelandale Ave. Rehabilitation. The project was recently approved for an Amendment Modification Summary E-76 by the Department of Transportation (CalTrans) on August 22, 2022 which awarded additional funding. As a result, the projects revenue and expense budget are being increased.

There are no local match funds for the project.
 A budget adjustment in the amount of $2,814,603 necessary in the Capital Grants – Streets CIP Projects Fund 3160 for Project 101271 – Briggsmore/SR-99 Interchange.

The project was recently approved for an Amendment Modification Summary E-76 by the Department of Transportation (CalTrans) on May 24, 2022 and then again on August 11, 2022 which awarded additional funding. As a result, the projects revenue and expense budget are being increased. The project is also funded with Regional Measure L funds.
 A budget adjustment in the amount of $1,200,000 necessary in the Capital Grants – Streets CIP Projects Fund 3160 for Project 101063 – Pelandale Ave. Interchange – Phase 2. The project was recently approved for an Amendment Modification Summary E-76 by the Department of Transportation (CalTrans) on September 8, 2022 which awarded additional funding. As a result, the projects revenue and expense budget are being increased. The project is also funded with State Improvement Program grant funds and local Streets Capital Facility Fee funds.

COMMUNITY AND ECONOMIC DEVELOPMENT – MEASURE L
 A budget adjustment is necessary to allocate higher than anticipated revenues to various Measure L projects. The total amount of the adjustment is $5,917,140. Each project will have an increase in the transfer out from Fund 1410 – Measure L Local Road Tax to the project and an increase to the projects discretionary expense accounts. Below is the adjustment to each project.

Project
Number
Project Name Amount for
Adjustment
Local Streets and Roads Category
101042 Paradise Road ATP III $2,000,000
101157 Tuolumne Blvd. Pavement Rehab $2,502,283
Traffic Management Category
101157 Tuolumne Blvd. Pavement Rehab $1,023,610
101066 New Signal Oakdale/Claratina $110,000
Bike and Pedestrian Category
101042 Paradise Road ATP III $281,247
Total Increase to Projects $5,917,140
Total Transfer Out from Fund 1410 $5,917,140
#1..
- 8 -
Finance Committee, September 26, 2022
Monthly Budget Adjustment Report

Page 2 of 4 ends

INFORMATION TECHNOLOGY
 A budget adjustment in the amount of $65,913 is needed in the Public Educational Government (PEG) Fund 1321 for the City’s portion of the 10th Street Place Closed Captioning Upgrade Project. The project is being equally funded by the City and Stanislaus County and was approved by the 10th Street Place Joint Powers Agency Commission on August 29, 2022 with a total project amount of $131,825. The increase in budget will be covered by the current Fund 1321 reserves.

PUBLIC WORKS
 A budget adjustment in the amount of $1,178,420 is necessary in the Capital Grants – Streets CIP Projects Fund 3160 for Project 101186 – Upgrade Traffic Signals 2019. The project was recently approved for an Amendment Modification Summary E-76 by the Department of Transportation (CalTrans) on August 18, 2022 which awarded additional funding. As a result, the projects revenue and expense budget are being increased.

There are no local match funds for the project.
 A budget adjustment in the amount of $150,000 necessary in the Capital Grants – Streets CIP Projects Fund 3160 for Project 101066 – New Signal Oakdale/Claratina. The project was recently approved for an Amendment Modification Summary E-76 by the Department of Transportation (CalTrans) on August 24, 2022 which awarded additional funding. As a result, the projects revenue and expense budget are being increased. The project is also funded with Local Measure L funds.
 A budget adjustment in the amount of $769,000 is needed in the Surface Transportation Fund (1700) to increase the Upgrade High Voltage FY 20/21 Project (101304) expense budget. Additionally, a transfer out from the Gas Tax Fund (1730) to the project is needed in the amount of $769,000. This project will continue to upgrade the High Voltage Circuits within the City. City Council per resolution 2019-91 recommended the approach to replace 150 high voltage street lights each year at an estimated cost of $1,000,000. This adjustment is accounting for the anticipated replacement expenses for high voltage for fiscal year 2022-2023 which was not included as part of budget adoption. If the additional $231,000 is needed, staff will bring back another request to Council to amend the budget.
 A budget adjustment in the amount of $240,000 is necessary in the Capital Grants – Streets CIP Projects Fund 3160 for Project 100968 – Upgrade Traffic Signals 2017. The project was recently approved for an Amendment Modification Summary E-76 by the Department of Transportation (CalTrans) on September 1, 2022 which awarded additional funding. As a result, the projects revenue and expense budget are being increased. There are no local match funds for the project.  A budget adjustment in the amount of $1,854,073 is necessary in the Compost SB 1383 CIP Fund 4896. Senate Bill (SB) 1383 requires that waste management jurisdictions enact and enforce a series of processes and programs designed to limit organic waste to landfill. Due to collection, sorting, and program changes, the City's Compost Facility becomes a critical part of local waste management, providing a destination for organic waste diverted from land fill and a means for Modesto to meet diversion and #1..
- 9 -
Finance Committee, September 26, 2022
Monthly Budget Adjustment Report

Page 3 of 4 ends

procurement targets set by CalRecycle. The City's Compost Facility is not currently capable of meeting the demands of more organic waste and the requirement of no more than 1% contamination. Equipment upgrades and replacements and facility improvements are needed to comply with SB1383.

Under Resolution 2022-276 City Council approved a $1.70 fee monthly on residential solid waste accounts and $3.08 monthly based on yardage and frequency of service on commercial accounts. This fee accounts for an anticipated $1,211,005 revenue from residential accounts and $643,068 from commercial accounts, for a total of $1,854,073. in FY22/23 the Compost Facility will hire a consultant to provide a feasibility study, which will evaluate the needs for facility, especially in regards to regulations, equipment, general facility improvements, and planning for short-and long-term growth. Following recommendations from the feasibility study, an engineering consultant will be hired to work on the suggested improvements. Based on similar compost capital improvement projects, the anticipated cost is $25 million, with $1.5 million in equipment purchases and consulting allocated this fiscal year. These account for the allocations to Professional Services and Tools and Equipment accounts.
 A budget adjustment in the amount of $1,144,671 is necessary to increase the budget for increased revenue and to budget additional expenses for programs required under SB 1383. Senate Bill (SB) 1383 requires that waste management jurisdictions enact and enforce a series of processes and programs designed to limit organic waste to landfill.

These include:
•Collection and sorting methodology that divert organic waste and recyclable material from landfill
•Inspections and enforcement of waste containers and sorting •Food recovery programs and monitoring
•Outreach and education on SB1383, associated waste management changes, and new programs or requirements
An SB 1383 implementation fee was added to the City of Modesto's solid waste collection rate under Resolution2022 276 for $1.05 monthly on residential accounts and $1.90 monthly based on yardage and frequency of service on commercial accounts. This fee accounts for an anticipated $747,974 revenue from residential accounts and $396,697 from commercial accounts. This total additional revenue, $1,144,671, will fund the above programs and processes.

The accounts on the table will have additional expenses for the programs required under SB 1383:
#1..
- 10 -
Finance Committee, September 26, 2022
Monthly Budget Adjustment Report

Page 4 of 4 ends

Account String Account Name
Adjustment
Amount Justification/Description
4891-56010-51040 Salaries and Wages - Part-time $30,000 2 MW to conduct
inspections
4891-56010-51200 Overtime $7,000
Public Ed/Outreach
programs in evenings
and weekends
4891-56010-52010 Office Supplies $6,500
Increased cost of
recycled office supplies,
increased code
enforcement notices,
install new work stations
for additional employees
and fellows
4891-56010-52160 Personal Protection Equipment $2,000
PPE for new employees
and fellows
4891-56010-52300 Tools and Field Supplies <$5,000 $1,700 Boots and field supplies
for new employees and
fellows
4891-56010-53025 Training Expenses $400
Training for new
employees
4891-56010-53030 Business Expenses $15,000
Mileage expenses for 4
fellows to conduct
ed/outreach programs
4891-56010-53047 Phone Expenses $300
Office phones for new
employees and fellows
4891-56010-53048 Cell Phone Utility Expenses $2,400
Cell phones and/or
mobile hotspots for new
employees and fellows
4891-56010-53170 Laundry and Cleaning $800 Uniforms for 2 MWs 4891-56010-53175 Advertising $85,000
Public Ed/Outreach
campaign for new
containers, collection/sorting, food
recovery, enforcement
programs
4891-56010-53176 Promotion Expense $80,000
Outreach material,
including small kitchen
scrap buckets for
compost
4891-56010-53300 Professional Services $155,000
Forms, brochures, printing for compliance
programs, including bill
inserts, magnets with
collection calendars;
creation of outreach
campaigns, including
#1..
- 11 -
Department Director/Budget Manager/City Manager Approved Budget Adjustments EXHIBIT B For FY2021/22
AT #
Appro
ved by
CM,
BM or
DD Fund Fund Name Cost Ctr/Project Name Account Name
Rev/E
xp/TI/
TO
Acco
unt Current Budget
Increase
(Decrease)
Revised
Budget Description
AT-234 DD 0100 General Fund 04010 - City Attorney's
Office
Budget Only - Salary Adjustment
- Decrease Exp $ (223,818) (31,980) $ $ (255,798)
AT-234 DD 0100 General Fund 04010 - City Attorney's
Office
Budget Only - Benefit
Adjustment - Decrease Exp $ (53,763) (8,849) $ $ (62,612) AT-234 DD 0100 General Fund 04010 - City Attorney's
Office
Budget Only - Discretionary
Adjustment Exp $ 277,581 40,829 $ $ 318,410
AT-240 DD 0100 General Fund CCM - City Council of
Modesto
Budget Only - Salary Adjustment
- Decrease Exp $ - (11,857) $ $ (11,857)
AT-240 DD 0100 General Fund CCM - City Council of
Modesto
Budget Only - Benefit
Adjustment - Decrease Exp $ - (904) $ $ (904)
AT-240 DD 0100 General Fund CAO - City Attorneys Office Professional Services Exp $ - 12,761 $ $ 12,761 AT-242 BM 0100 General Fund 35220 - Parks Operations
Services Admin
Budget Only - Salary Adjustment
- Decrease Exp $ - (8,310) $ $ (8,310)
AT-242 BM 0100 General Fund 35220 - Parks Operations
Services Admin
Budget Only - Benefit
Adjustment - Decrease Exp $ - (5,541) $ $ (5,541)
AT-242 BM 0100 General Fund 35170 - Parks Graffiti
Abatement
Tools and Field Supplies
<$5,000 Exp $ 9,999 7,884 $ $ 17,883
AT-242 BM 0100 General Fund 35220 - Parks Operations
Services Admin Temporary Employee Services Exp $ 20,000 5,967 $ $ 25,967 AT-246 DD 0100 General Fund PRN - Recreation
Operations Professional Services Exp $ 22,449 (21,801) $ $ 648 AT-246 DD 0100 General Fund PRN - Event Services -
John Thurman Water Utility Expenses Exp $ 27,168 21,801 $ $ 48,969 AT-253 CM 0100 General Fund 19320 - MPD Field Ops Budget Only - Salary Adjustment - Decrease Exp $ (684,928) (870,479) $ $ (1,555,407)
AT-253 CM 0100 General Fund 19320 - MPD Field Ops Budget Only - Benefit Adjustment - Decrease Exp $ (366,670) (373,063) $ $ (739,733) AT-253 CM 0100 General Fund 18110 - Fire Admin Overtime Exp $ 2,500,000 1,243,542 $ $ 3,743,542 AT-254 CM 0100 General Fund 18610 - Fire Facilities and Fleet Business Expense Exp $ 315,636 (72,900) $ $ 242,736 AT-254 CM 0100 General Fund 18610 - Fire Facilities and Fleet Cable/Internet Utility Expense Exp $ 53,049 (48,000) $ $ 5,049 AT-254 CM 0100 General Fund 18610 - Fire Facilities and Fleet
Repair and Maintenance -
Equipment Exp $ 53,105 (49,600) $ $ 3,505
AT-254 CM 0100 General Fund 18610 - Fire Facilities and Fleet Vehicles > $5000 Exp $ 57,003 (11,900) $ $ 45,103 AT-254 CM 0100 General Fund 18610 - Fire Facilities and Fleet Fire Equipment > $5,000 Exp $ 57,030 (17,600) $ $ 39,430 AT-254 CM 0100 General Fund 18210 - Fire Suppression Overtime Exp $ 51,200 200,000 $ $ 251,200 AT-255 BM 0100 General Fund FIN - Accounting Budget Only - Salary Adjustment Exp $ (8,418) (910) $ $ (9,328) AT-255 BM 0100 General Fund FIN - Accounting Budget Only - Benefit Exp $ (3,607) (390) $ $ (3,997) AT-255 BM 0100 General Fund FIN - Licensing Budget Only - Salary Adjustment Exp $ (4,533) (490) $ $ (5,023) AT-255 BM 0100 General Fund FIN - Licensing Budget Only - Benefit Exp $ (1,942) (210) $ $ (2,152) AT-255 BM 0100 General Fund FIN - Administration Budget Only - Salary Adjustment Exp $ 18,738 1,400 $ $ 20,138 A budget adjustment is to move funds from the Police Department Appr Unit A (Salary and Benefits) savings to the Fire Department Appr Unit A (Salary and Benefits) to cover Fire Department Overtime overage in Fiscal Year 2021-22 due to the continued response to the COVID-19 pandemic. This budget adjustment will move $1,243,542 from the Police Department to the Fire Department for this purpose.

A budget adjustment is to move funds from the Fire Department Appr Unit C (Discretionary Expense) savings to the Fire Department Appr Unit A (Salary and Benefits) to cover Fire Department Overtime overage in Fiscal Year 2021-22 due to the continued response to the COVID-19 pandemic. This budget adjustment will move $200,000 from various discretionary expense accounts in cost center 18610-Facitilies and Fleet) to the Overtime account in the cost center 18210 - MFD Suppression.

A budget adjustment of $2,000 is necessary to move salary savings from FIN - Accounting and FIN - Licensing to FIN - Administration for underbudgeted salary expenses.

A budget adjustment is necessary to reallocate remaining salary savings in appropriation unit a to appropriation unit c to pay for expenses through June 30, 2022 in the City Attorney's Office operating budget.

A budget adjustment is necessary to reallocate funds from the City Council operating budget to the City Attorney's Operating budget. There are salary savings available in the City Council budget which will be used to pay for invoices through June 30, 2022 related to the redistricting within the City.

A budget adjustment in the amount of $13,851 is needed to move budget from salary savings into Tools and Field Supplies <$5,000 and Temporary Employee Services as these accounts are over budget at end of FY2021-22.

A budget adjustment to move $21,801 from CC 33030 to CC 34150 is necessary to cover the overage caused by increased costs associated with the Water Utility Expenses account for Fiscal Year 21-22.
#1..
- 12 -
Department Director/Budget Manager/City Manager Approved Budget Adjustments EXHIBIT B For FY2021/22
AT #
Appro
ved by
CM,
BM or
DD Fund Fund Name Cost Ctr/Project Name Account Name
Rev/E
xp/TI/
TO
Acco
unt Current Budget
Increase
(Decrease)
Revised
Budget Description
AT-255 BM 0100 General Fund FIN - Administration Budget Only - Benefit Exp $ 5,100 600 $ $ 5,700 AT-261 BM 0100 General Fund PRN - Convention & Visitors Bureau ISF - Mail Services - Inside Exp $ 6 $ (6) $ -
AT-261 BM 0100 General Fund PRN - Administration ISF - Mail Services - Inside Exp $ 87 $ 6 $ 93 Total Changes for Fund 0100 $ 2,120,472 $ - $ 2,120,472 AT-243 CM 1341 Grants - Operation Grants
Reimbursed UOPP 12 CA Recycle - PW Rev $ - 29,016 $ $ 29,016 AT-243 CM 1341 Grants - Operation Grants
Reimbursed UOPP 12 Appr. Unit C - Advertising Exp $ - 8,000 $ $ 8,000 AT-243 CM 1341 Grants - Operation Grants
Reimbursed UOPP 12 Appr. Unit C - Professional Services Exp $ - 8,000 $ $ 8,000 AT-243 CM 1341 Grants - Operation Grants
Reimbursed UOPP 12 Appr. Unit C - Svcs City Forces Exp $ - 13,016 $ $ 13,016 Total Changes for Fund 1341 $ - $ 58,032 $ 58,032
AT-238 BM 3160 Capital Grants - Streets CIP
Projects
Pelandale Ave. Interchange
Phase 2
Land Acquisition LA-STIP-R/W
Support Exp $ 357,200 (6,943) $ $ 350,257
AT-238 BM 3160 Capital Grants - Streets CIP
Projects
Pelandale Ave. Interchange
Phase 2
Consultant Charges CC-STIPUC-R/W Support Exp $ 20,239 6,943 $ $ 27,182 Total Changes for Fund 3160 $ 377,439 $ - $ 377,439
AT-258 BM 4210 Wastewater Fund 74210 - Transfer Out from Fund 4210
Transfer Out to Fund 4241 -
2015 Wastewater Refunding TO $ - 1,452 $ $ 1,452
AT-258 BM 4210 Wastewater Fund 74210 - Transfer Out from Fund 4210
Transfer Out to Fund 4272 -
2020A (Federally Taxable) TO $ - 18,358 $ $ 18,358
AT-258 BM 4210 Wastewater Fund 74210 - Transfer Out from Fund 4210
Transfer Out to Fund 4273 -
2020A (Tax-Exempt)
Wastewater Revenue Refunding
Bonds
TO $ - 2,425 $ $ 2,425
AT-258 BM 4210 Wastewater Fund 74210 - Transfer Out from Fund 4210
Transfer Out to Fund 4240 -
2006 Wastewater Revenue
Bonds
TO $ - 2,459 $ $ 2,459
Total Changes for Fund 4210 $ - $ 24,694 $ 24,694
AT-258 BM 4240 2006 Wastewater Revenue
Bonds
64240 - Transfer Into Fund
4240
Transfer In from Fund 4210 -
Wastewater TI $ - 2,459 $ $ 2,459
A budget adjustment in the amount of $24,694 is needed in the Wastewater Fund (4210) to establish transfers to various Wastewater Debt Service Funds to ensure sufficient working captail in these funds.

AT-259 BM 4240 2006 Wastewater Revenue
Bonds
74240 - Transfer Out from
Fund 4240
Transfer out from Fund 4240 -
2006 Wastewater Revenue
Bonds
TO $ - 341,221 $ $ 341,221
A budget adjustment in the amount of $341,221.45 is needed to transfer the value of Fair Market Investments held in the 2006 Wastewater Revenue Bonds that have since been refunded into Fund 4210 Wastewater Fund as this is the fund it rolls up to in the ACFR.

Total Changes for Fund 4240 $ - $ 343,680 $ 343,680
AT-258 BM 4241 2015 Wastewater Refunding
Private Placement
64241 - Transfer Into Fund
4241
Transfer In from Fund 4210 -
Wastewater TI $ - 1,452 $ $ 1,452
A budget adjustment in the amount of $24,694 is needed in the Wastewater Fund (4210) to establish transfers to various Wastewater Debt Service Funds to ensure sufficient working captail in these funds.

Total Changes for Fund 4241 $ - $ 1,452 $ 1,452
AT-258 BM 4272
2020A (Federally Taxable)
Wastewater Revenue
Refunding Bonds
64272 - Transfer Into Fund
4272
Transfer In from Fund 4210 -
Wastewater TI $ - 18,358 $ $ 18,358
A budget adjustment in the amount of $24,694 is needed in the Wastewater Fund (4210) to establish transfers to various Wastewater Debt Service Funds to ensure sufficient working captail in these funds.

A budget adjustment in the amount of $24,694 is needed in the Wastewater Fund (4210) to establish transfers to various Wastewater Debt Service Funds to ensure sufficient working captail in these funds.

A budget adjustment of $6 is necessary to move ISF - Mail Services budget from CVB to PRN Admin.

A budget adjustment is necessary to re-allocate funds from the STIP funds Right of Way support to the CC-STIP-UC-R/W task which requires some additional utility coordination and follow-up. There is no net change to the consultant agreement with Dokken Engineering for this re-allocation.

The City of Modesto has received a grant from the State of California for the Used Oil Payment Program. This grant will provide funding for advertising, promotional items, events, and staff time.
#1..
- 13 -
Department Director/Budget Manager/City Manager Approved Budget Adjustments EXHIBIT B For FY2021/22
AT #
Appro
ved by
CM,
BM or
DD Fund Fund Name Cost Ctr/Project Name Account Name
Rev/E
xp/TI/
TO
Acco
unt Current Budget
Increase
(Decrease)
Revised
Budget Description
Total Changes for Fund 4272 $ - $ 18,358 $ 18,358
AT-258 BM 4273
2020A (Tax-Exempt)
Wastewater Revenue
Refunding Bonds
64273 - Transfer Into Fund
4273
Transfer In from Fund 4210 -
Wastewater TI $ - 2,425 $ $ 2,425
A budget adjustment in the amount of $24,694 is needed in the Wastewater Fund (4210) to establish transfers to various Wastewater Debt Service Funds to ensure sufficient working captail in these funds.

Total Changes for Fund 4273 $ - $ 2,425 $ 2,425
AT-236 BM 4235 North Valley Recycled Water 12136 - FIN - North Valley Professional Services - Debt Exp $ 271,934 638 $ $ 272,572 A budget adjustment in the amount of $638 is needed in the North Valley Recycled Water Fund (4235) to increase the professional services - debt account associated with the State Water Resources Control Board.

Total Changes for Fund 4235 $ 271,934 $ 638 $ 272,572
AT-239 BM 4605 Golf Kemper Fund PRN - Golf Kemper
Creekside Course
Refunds, Damages and Cost
Recovery Rev $ - 13,613 $ $ 13,613
AT-239 BM 4605 Golf Kemper Fund PRN - Golf Kemper Dryden Course
Cost of Goods Sold - Golf
Merchandise Exp $ 22,100 13,613 $ $ 35,713
Total Changes for Fund 4605 $ 22,100 $ 27,226 $ 49,326
AT-245 DD 4890 Compost Fund PW - Compost Operations Budget Only - Salary Adjustment - Decrease Exp $ - (30,800) $ $ (30,800)
AT-245 DD 4890 Compost Fund PW - Compost Operations Budget Only - Benefit Adjustment - Decrease Exp $ - (13,200) $ $ (13,200)
AT-245 DD 4890 Compost Fund PW - Compost Operations Rental of Equipment Exp $ 20,075 44,000 $ $ 64,075 Total Changes for Fund 4890 $ 20,075 $ - $ 20,075
AT-237 BM 4891 Solid Waste PW-Solid Waste
Management
Budget Only - Salary Adjustment
- Decrease Exp $ (10,150) (10,500) $ $ (20,650)
AT-237 BM 4891 Solid Waste PW-Solid Waste
Management
Budget Only - Benefit
Adjustment - Decrease Exp $ (4,350) (4,500) $ $ (8,850) AT-237 BM 4891 Solid Waste PW-Solid Waste
Management Professional Services Exp $ 46,975 15,000 $ $ 61,975 Total Changes for Fund 4891 $ 32,475 $ - $ 32,475
AT-249 BM 4530 Transportation CTR Fund PW - Transportation Center Professional Services Exp $ 15,055.93 (15,055.93) $ $ - AT-249 BM 4530 Transportation CTR Fund PW - Transportation Center Miscellenaeous Supplies Exp $ (0.01) 0.01 $ $ - Total Changes for Fund 4530 $ 15,056 $ (15,056) $ -
AT-248 BM 4560 Bus Fixed Route - Bus
Purchases
PW - Transit Bus
Purchases Vehicles > $5000 Exp $ 18,007.80 (18,007.80) $ $ - AT-248 BM 4560 Bus Fixed Route - Bus
Purchases
PW - Transit Bus
Purchases
Tools and Field Supplies
<$5,000 Exp $ (0.02) 0.02 $ $ -
Total Changes for Fund 4560 $ 18,008 $ (18,008) $ -
A budget adjustment is necessary to remove budget that was generated from FY20- 21 rollover encumbrances.

A budget adjustment is necessary to remove budget that was generated from FY20- 21 rollover encumbrances.

A budget adjustment of $44,000 is necessary to move salary savings to Rental of Equipment to cover the rental of a tractor from J& S Tractor for 5 months.

A budget adjustment is necessary to increase revenues in the amount of $13,613 for revenues received in the Refunds, Damages, and Cost Recovery account which will also require a increase in the expenditure account 52117 (Cost of Goods Sold - Golf Merchandise) in the same amount. This adjustment is to account for revenue received in the Golf Kemper Fund as well as increasing the expenditure budget to cover additional costs of goods at the Dryden Course for merchandise sold at the clubhouse.

A budget adjustment of $15,000 is necessary to move salary savings within the same cost center in Solid Waste to cover underbudgeted Professional Services expenses. #1..
- 14 -
Department Director/Budget Manager/City Manager Approved Budget Adjustments EXHIBIT B For FY2021/22
AT #
Appro
ved by
CM,
BM or
DD Fund Fund Name Cost Ctr/Project Name Account Name
Rev/E
xp/TI/
TO
Acco
unt Current Budget
Increase
(Decrease)
Revised
Budget Description
AT-233 DD 5230 Information Technology Fund 17410 - IT Administration Budget Only - Salary Adjustment - Decrease Exp $ (27,000) (899) $ $ (27,899)
AT-233 DD 5230 Information Technology Fund 17410 - IT Administration Budget Only - Benefit Adjustment - Decrease Exp $ (7,000) (1,077) $ $ (8,077) AT-233 DD 5230 Information Technology Fund 17410 - IT Administration Professional Services Exp $ 37,160 1,976 $ $ 39,136 Total Changes for Fund 5230 $ 3,160 $ - $ 3,160
AT-244 CM 5340 Property Insurance HR - Property Insurance Insurance Premiums Exp $ 1,034,000 27,062 $ $ 1,061,062 A budget adjustment in the amount of $27,062 is needed in the Property Insurance Fund to increase the budget for Premiums. This budget was estimated 9 months before the start of the fiscal year and was slightly under projected.

Total Changes for Fund 5340 $ 1,034,000 $ 27,062 $ 1,061,062 AT-247 BM 5400 Fleet Management Fund 100451 - Fleet Maintenance Facility
Appr. Unit D - Transfer Out to
Fund 4510 TO $ 266,066 (239,988) $ $ 26,078
AT-247 BM 5400 Fleet Management Fund 100451 - Fleet Maintenance Facility
Appr. Unit D - Transfer Out to
Fund 3140 TO $ - 239,988 $ $ 239,988
Total Changes for Fund 5400 $ 266,066 $ - $ 266,066
AT-232 BM 5520 Employee Benefit Fund Admin 17160 - EBF Admin Salaries and Wages - Part-Time Exp $ 15,000 5,342 $ $ 20,342 A budget adjustment in the amount of $5,342 is needed in the Employee Benefits Fund Admin (5520) to budget additional part-time salaries and wages.

AT-252 DD 5520 EBF Admin 17350 - HR - EBF Admin Professional Services Exp $ 30,000 (2,900) $ $ 27,100 AT-252 DD 5520 EBF Admin 17160 - HR - EBF Admin Professional Services Exp $ 140,500 2,900 $ $ 143,400 Total Changes for Fund 5520 $ 185,500 $ 5,342 $ 190,842 AT-241 BM 5810 10th Street Place Building
Services
PW-City 10th Street Place
JPA Operations Services
Intergov-Local-City of Modesto
Contribution Rev $ 1,146,751 (4,102) $ $ 1,142,649
AT-241 BM 5810 10th Street Place Building
Services
PW-City 10th Street Place
JPA Operations Services Office Space Rental Income Rev $ 28,214 4,102 $ $ 32,316 Total Changes for Fund 5810 $ 1,174,965 $ - $ 1,174,965 AT-260 BM 6700 JPA-Tuolumne River Regional
Park (TRRP)
80300 - TRRP JPA
Operations Rental of Equipment Exp $ 1,000 9,263 $ $ 10,263 AT-260 BM 6700 JPA-Tuolumne River Regional
Park (TRRP)
80300 - TRRP JPA
Operations
Repair and Maintenance
Services Exp $ - 13,962 $ $ 13,962
Total Changes for Fund 6700 $ 1,000 $ 23,225 $ 24,225
A budget adjustment is needed to update the expenditure type for the transfer out for Project 100451. The project was originally budgeted to be a transfer out to Project 101022 which resided in Fund 4510. As of FY 21-22, Fund 4510 was deactivated and the budget for Project 101022 was moved to Project 101337. The new project resides in Fund 3140. This adjustment is moving the transfer out/expenditure side of the project to the correct fund
A budget adjustment in the amount of $2,900 is needed in the EBF Fund to move budget between two cost centers for professional services costs.

A budget adjustment is necessary to reduce the City of Modesto contribution for FY 21- 22 ISF JPA City Allocation budget. The City had two lease agreements during FY 21-

22. The agreement with the Clerk-Recorder was original set to expire on April 30, 2022. The County opted to extend their lease through and this credit accounts for the additional lease revenue the City received in May and June 2022. The attached spreadsheet show the credit due and the new allocation for each fund-cost center.

A budget adjustment is necessary to reallocate remaining salary savings in appropriation unit a to appropriation unit c to pay for expenses through June 30, 2022 in the information technology fund.

A budget adjustment is necessary to increase the budget for the TRRP operating Fund 6700. There were expenses that were unanticipated related to rental of equipment as part of the vegetation work completed and repair and maintenance services related to the air conditioner at American Legion Hall during May and June 2022.
#1..
- 15 -
Department Director/Budget Manager/City Manager Approved Budget Adjustments EXHIBIT B For FY2021/22
AT #
Appro
ved by
CM,
BM or
DD Fund Fund Name Cost Ctr/Project Name Account Name
Rev/E
xp/TI/
TO
Acco
unt Current Budget
Increase
(Decrease)
Revised
Budget Description
AT-241 BM Various Various Various ISF-JPA City Allocation Exp $ 1,146,751 (4,102) $ $ 1,142,649 A budget adjustment is necessary to reduce the City of Modesto contribution for FY 21- 22 ISF JPA City Allocation budget. The City had two lease agreements during FY 21-

Total Changes for Fund Various $ 1,146,751 $ (4,102) $ 1,142,649 #1..
- 16 -
Department Director/Budget Manager/City Manager Approved Budget Adjustments EXHIBIT B For FY2022/23
AT #
Appro
ved by
CM,
BM or
DD Fund Fund Name Cost Ctr/Project Name Account Name
Rev/E
xp/TI/
TO
Acco
unt Current Budget
Increase
(Decrease)
Revised
Budget Description
AT-020 BM 1180 Emergency Shelter Grants 101258 - CARES ESG Funding Direct Grants - 1386 Prev AUC Exp $ 83,289 (83,289) $ $ - AT-020 BM 1180 Emergency Shelter Grants 101258 - CARES ESG Funding
Direct Grants - 1388 STRA SA
Ber AUC Exp $ 291,838 (9,725) $ $ 282,113
AT-020 BM 1180 Emergency Shelter Grants 101258 - CARES ESG Funding
Direct Grants - 1387 RRH DTS
AUC Exp $ 500,000 (100,000) $ $ 400,000
AT-020 BM 1180 Emergency Shelter Grants 101258 - CARES ESG Funding
Direct Grants - 1385 Outreach
CHS AUC Exp $ 40,000 16,893 $ $ 56,893
AT-020 BM 1180 Emergency Shelter Grants 101258 - CARES ESG Funding
Direct Grants - 1388 Shelter
Appr Unit C Exp $ 118,300 19,700 $ $ 138,000
AT-020 BM 1180 Emergency Shelter Grants 101258 - CARES ESG Funding
Direct Grants - 1388 STRA SA
Aces AD AUC Exp $ 28,000 2,537 $ $ 30,537
AT-020 BM 1180 Emergency Shelter Grants 101258 - CARES ESG Funding
Direct Grants - 1388 STR SA
Ber AD AUC Exp $ 10,000 9,275 $ $ 19,275
AT-020 BM 1180 Emergency Shelter Grants 101258 - CARES ESG Funding
Direct Grants - 1388 STR
STANCO AD AUC Exp $ 8,985 11,015 $ $ 20,000
AT-020 BM 1180 Emergency Shelter Grants 101258 - CARES ESG Funding
Direct Grants - 1388 STR
STANCO AUC Exp $ - 133,594 $ $ 133,594
Total Changes for Fund 1180 $ 1,080,412 $ - $ 1,080,412 AT-016 BM 3150 Capital Grants - Parks CIP 101289 - Rebard Pk Playground Renovation Services City Forces - Interfund Exp $ 2,500 (2,000) $ $ 500 AT-016 BM 3150 Capital Grants - Parks CIP 101289 - Rebard Pk Playground Renovation Professional Services Exp $ 85,452 2,000 $ $ 87,452 Total Changes for Fund 3150 $ 87,952 $ - $ 87,952
AT-021 BM 3160 Capital Grants - Streets CIP 100966 - Pelandale from Sisk to Dale Construction Administration Exp $ 266,453 (19) $ $ 266,434 AT-021 BM 3160 Capital Grants - Streets CIP 100966 - Pelandale from Sisk to Dale Eng/Design/Admin Exp $ 347,895 $ 19 $ 347,914 Total Changes for Fund 3160 $ 614,348 $ - $ 614,348
AT-024 CM 3204 Village One Triangle CFD 101433 - Village One Triangle CFD Formation Professional Services Exp $ - 25,000 $ $ 25,000 AT-024 CM 3204 Village One Triangle CFD 101433 - Village One Triangle CFD Formation Legal Services Exp $ - 10,000 $ $ 10,000 AT-024 CM 3204 Village One Triangle CFD 101433 - Village One Triangle CFD Formation Svcs City Forces - Interfund Exp $ - 15,000 $ $ 15,000 Total Changes for Fund 3204 $ - $ 50,000 $ 50,000
AT-023 BM 4100 Water Fund CIP 43030 - Urban Water
Management Professional Services Exp $ 8,222 25,000 $ $ 33,222 A budget adjustment in the amount of $25,000 is needed to budget consultant expenses related to the Urban Water Management plan and water loss audit validations.

Total Changes for Fund 4100 $ 8,222 $ 25,000 $ 33,222
AT-018 BM 4180 Water Fund CIP 100953 - La Loma El Vista To Riverside Contingency Exp $ 400,000 (150,000) $ $ 250,000 AT-018 BM 4180 Water Fund CIP 100953 - La Loma El Vista To Riverside
Engineering/Design/Administrati
on Exp $ 223,000 150,000 $ $ 373,000
Total Changes for Fund 4180 $ 623,000 $ - $ 623,000
A budget adjustment is needed to transfer funds between tasks in the ESG CARES Act funding project to cover contruactual obligations. There is no change to the total amount of the project budget.

A budget adjustment is necessary to move funds between tasks to cover change orders for the project.

A budget adjustment in the amount of $150,000 is needed to move budget from the Contingency Task to the Engineering/Design/Administration task to continue work on this project.

A budget adjustment is necessary to relocation funds from the CA task to the EDA task to cover the overage. There are sufficient funds in CA and once the adjustment is completed the project will be closed.

A budget adjustment in the amount of $50,000 is needed to establish the Village One Triangle CFD Formation project (101433) and appropriate $50,000 of the $64,500 developer deposits received as of 8/23/2022.
#1..
- 17 -
Department Director/Budget Manager/City Manager Approved Budget Adjustments EXHIBIT B For FY2022/23
AT #
Appro
ved by
CM,
BM or
DD Fund Fund Name Cost Ctr/Project Name Account Name
Rev/E
xp/TI/
TO
Acco
unt Current Budget
Increase
(Decrease)
Revised
Budget Description
AT-019 CM 4212 Wastewater PCE
Litigation/Mitigation
100668-WW PCE Mitigation
Site 1 Professional Services Exp $ 1,790,214 125,385 $ $ 1,915,599 A budget adjustment in the amount of $125,385 is needed to budget litigation/mitigation costs associated with PCE Mitigation Site 1 as approved by City Attorney's office in a letter dated 7/22/22. These funds are restricted, cannot be used for any other purpose, and not funded by rate payers of Modesto.

Total Changes for Fund 4212 $ 1,790,214 $ 125,385 $ 1,915,599 AT-013 BM 4310 Airport Operating Fund PW-Airport Services Intergov-State-CA Dept. of Rev $ 10,000 (10,000) $ $ - AT-013 BM 4310 Airport Operating Fund PW-Airport Services Intergov-State-CA Dept. of Transportation-Activity 53009 Rev $ - 10,000 $ $ 10,000 AT-013 BM 4310 Airport Operating Fund PW-Airport Services Repair and Maintenance
Services - Real Property-Activity
53009
Exp $ - 10,000 $ $ 10,000
Total Changes for Fund 4310 $ 10,000 $ 10,000 $ 20,000
AT-015 CM 4330 County Aircraft Tax Fund PW -Transportation Airport Special Fund Operations Professional Services Exp $ 25,000 41,000 $ $ 66,000 A budget adjustment is necessary to increase the County Aircraft Tax Fund 4330 expense budget by $41,000. The increase is related to the Airport painting 3 hangars for Fiscal Year 22-23. The increase will come from the County Aircraft Tax Fund reserves which has a sufficient fund balance.

Total Changes for Fund 4330 $ 25,000 $ 41,000 $ 66,000
AT-017 CM 5400 Fleet Management Fund 101423 - Corp Yard Reconfiguration Lease of Land Rev $ - 50,000 $ $ 50,000 AT-017 CM 5400 Fleet Management Fund 101423 - Corp Yard Reconfiguration Professional Services Exp $ - 50,000 $ $ 50,000 Total Changes for Fund 5400 $ - $ 100,000 $ 100,000
AT-014 BM 6700 JPA - Tuolumne River
Regional Park (TRRP) JPR TRRP Operations Sales of Fixed Asset Rev $ - 25,000 $ $ 25,000 AT-014 BM 6700 JPA - Tuolumne River
Regional Park (TRRP) Transfer Out Fund 6700 Transfer Out to Fund 6710 TO $ - 25,000 $ $ 25,000 Total Changes for Fund 6700 $ - $ 50,000 $ 50,000
AT-014 BM 6710 JPA - TRRP Special Revenue
Fund - CIP
101425 - American Legion
Hall Fire Remediation Transfer In from Fund 6700 TI $ - 25,000 $ $ 25,000 AT-014 BM 6710 JPA - TRRP Special Revenue
Fund - CIP
101425 - American Legion
Hall Fire Remediation Professional Services Exp $ - 20,000 $ $ 20,000 AT-014 BM 6710 JPA - TRRP Special Revenue
Fund - CIP
101425 - American Legion
Hall Fire Remediation Services City Forces - Interfund Exp $ - 5,000 $ $ 5,000 Total Changes for Fund 6710 $ - $ 50,000 $ 50,000
A budget adjustment is necessary to move the CAAP Grant revenue anticipated to be received in FY 22-23 to the appropriate activity code. In addition, the adjustment is establishing the expense budget for the grant revenue.

A budget adjustment is necessary to recognize revenue, establish the transfer from Fund 6700 to Project 101425 and establish the project expense budget in the amount of $25,000.

A budget adjustment is necessary to establish the budget for Project 101423 - Corp Yard Reconfiguration. The expense budget for the project will be funded with monthly revenue received from the lease tied to one of of the parcels recently acquired by the City.
#1..
- 18 -

CITY OF MODESTO

COMMITTEE AGENDA REPORT
DATE OF MEETING:

September 26, 2022
Date: September 1, 2022
TO: Finance Committee
David Wright, Chair
Rosa Escutia-Braaton, Vice-Chair
Jenny Kenoyer, Member
THROUGH: Joseph P. Lopez, City Manager
FROM: DeAnna Christensen, Director of Finance
William Wong, Director of Utilities
SUBJECT: One-Time Purchase for Five Hayward Gordon Pumps CONTACT: Cynthia Kline, Purchasing Manager, [email protected], (209) 577-5412 DESCRIPTION:

Consider approving a one-time purchase for five Hayward Gordon pumps from Hayward Gordon Group, Ontario, Canada, for an amount not to exceed of $135,278, and forwarding to Council for approval. (Funding Source: Wastewater Fund) 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 of Modesto, Utilities Department, Wastewater Treatment currently has a total of six Hayward Gordon pumps for the grit removal process at the Headworks in operation currently. A total of five Hayward Gordon pumps have been in operation since 2014. One of the pumps was installed during the Headworks Capital Improvement Program (CIP) which has been in operation for the past year. The other five pumps have reached their end-of-life operation due to the grit material that they pump from the Grit Vortex basins.

The grit system piping, pump pedestals, control, power supply and flows have all been designed around these pumps. City staff can make system changes but using a direct replacement pump which has proven design, performance, and reliability in this specific application for more than 25 years, is believed to be cost effective and it is not advised to purchase something other than original design. Although, this looks to be an expensive purchase, the life of these specific pumps has an extremely good return on investment. Having the capability of refurbishing the volutes and exterior impeller adjustments, allows our Maintenance teams the ability and confidence in maintaining the system.
#2..
- 19 -
Finance Committee, September 26, 2022
One-Time Purchase for Five Hayward Gordon Pumps

Page 2 of 2 ends

If City staff was to change out the pumps to a different brand it could lead to additional cost, estimated at $60,000 or more. The costs for materials associated with the possibility of needing to reconfigure the piping, control, and power wiring, removing, and replacing pump pedestal, new guards, and alignment. The direct replacement allows City staff to replace the pumps as needed when the failure either happens or when scheduled to replace.

DISCUSSION:

The City of Modesto, Utilities Department, Wastewater Treatment plant is requesting a one-time purchase of five Hayward Gordon Pumps. This purchase would be a direct replacement for pumps currently in operation and that have reached their end-of-life operation.

Modesto Municipal Code Section 8-3.203 generally requires all purchases, which meet or exceed $50,000 for material, equipment, or contractual services, to be formally bid. However, MMC 8-3.204(b) provides that a purchase may be exempted from the City’s formal bidding requirements where the Purchasing Agency’s requirements can be met solely by a single article or process. Additionally, this one-time purchase of five Hayward Gordon Pumps should be exempt from the formal bidding procedure in accordance with Modesto Municipal Code 8-

3.204(b) because Hayward Gordon is the original equipment manufacturer. Therefore, this onetime purchase qualifies for exemption from the formal bidding procedures.

FISCAL IMPACTS:

Funds to cover the costs associated with this purchase will be budgeted in the Wastewater Fund in account 4210-44316-53150.

Approved by:
_________________________________________
DeAnna Christensen, Director of Finance
_________________________________________
William Wong, Director of Utilities
Joseph P. Lopez, City Manager
Attachments:

1. Financial Interest Disclosure

2. Quote

3. Bid Waiver
#2..
- 20 -
#2..
- 21 -
#2..
- 22 -
5 Brigden Gate
Halton Hills, ON L7G 0A3
[email protected]
www.haywardgordon.com
Hayward Gordon ULC
5 Brigden Gate ∙ Halton Hills ∙ ON ∙ CANADA ∙ L7G 0A3
T: 905‐693‐8595
https://haywardgordon.com
nQUOTATION FOR HAYWARD GORDON SOLIDS HANDLING
PUMPS
Date: 4/27/2022 Project Reference: Modesto XR3‐11 Pumps Quotation No.: Q2‐68908‐P2B5 Rev. 0 Equipment Reference:

Customer: MISCO Water Delivery: 18 weeks
5976 West Las Positas Boulevard, Incoterms: DDP jobsite Suite 226 Freight: PREPAID
Pleasanton Terms of Payment:

CA Taxes: Not Included
94588 Price Validity 60 days
Currency: US $
Salesperson: Jesse James
Attention: Sandy Clarke Submitted By: Paul Grodde
PRODUCT:

QTY MODEL UNIT SELL PRICE LOT SELL PRICE
5 HAYWARD GORDON XR3(11) BARE PUMP $23,690.00 $118,450.00 Sales Tax @ 7.875% $9,327.94
Freight – estimate to be billed at actual amount $7,500.00 Total $135,277.94
CONSTRUCTION DETAILS:

Wet End: ASTM A532 Super Ni‐Hard (650BHN) Casing, Impeller and Wearplate Seal: Chesterton 442C Single Cartridge Seal (SC/SC) ‐ Clean Water Flush Required Ports/Flanges: 4" suction x 3" discharge ‐ 125#RF
Motor Details: Provided by others
Drive: Bare Pump‐Drive by others
Guard: Provided by others
Base/Coverplate: Provided by others
Pump Setting: Bare Pump
APPLICATION DETAILS:

Fluid: Grit Impeller Diameter: Solids:

Capacity: 250 GPM Viscosity: NPSHR: Flooded
Head: 41 ft Temperature: Ambient
Pump RPM: 1150 RPM Specific Gravity: 1.00
REMARKS:

As of the date of this quote and due to the COVID‐19 pandemic, the Hayward Gordon Group of companies have taken every precaution to minimize our product delivery schedules to our valued Customers. However due to Federal, State or Provincial mandated restrictions, the Seller may be required to adjust our product delivery lead‐times accordingly.
#2..
- 23 -
5 Brigden Gate
Halton Hills, ON L7G 0A3
[email protected]
www.haywardgordon.com
Hayward Gordon ULC
5 Brigden Gate ∙ Halton Hills ∙ ON ∙ CANADA ∙ L7G 0A3
T: 905‐693‐8595
https://haywardgordon.com
By accepting and issuing a formal purchase order in reference to one of the Hayward Gordon Group of companies 1) Hayward Gordon ULC or 2) Sharpe Mixers, Inc. or 3) Scott Turbon Mixer, Inc. quotes, hereinafter referred to as “Seller”, Seller will confirm a ship date of the order based upon the then current environmental impact on the manufacturing schedule. #2..
- 24 -
5 Brigden Gate
Halton Hills, ON L7G 0A3
[email protected]
www.haywardgordon.com
Hayward Gordon ULC
5 Brigden Gate ∙ Halton Hills ∙ ON ∙ CANADA ∙ L7G 0A3
T: 905‐693‐8595
https://haywardgordon.com
In the event that due to the COVID‐19 pandemic, order fulfilment has to be delayed, Seller will provide notice to you our valued customer. Either Party reserves the right to suspend work on this order, if operations are required to shut down due to the COVID‐19 pandemic, for a period of (2) months or longer, at which point both Seller and Buyer will mutually review and either party may terminate with written notification. Buyer agrees to pay Seller for the value of the “unpaid” work performed by Seller, at the date of the termination.

GENERAL COMMENTS:

1. Price validity is based on receipt of complete approval and release for production no more than eight weeks after drawings have been submitted by Hayward Gordon ULC.

2. Hayward Gordon ULC’s standard Terms and Conditions of Sale apply and are an integral part of this quotation unless specifically noted otherwise in this proposal.

3. All start‐up and instructional services not included unless specifically noted otherwise in this proposal.

4. All starters and control equipment are not within Hayward Gordon ULC’s scope of supply and are to be supplied by others unless specifically noted otherwise in this proposal.

5. This proposal does not include installation, wiring, field painting or any other items except as specifically described above. #2..
- 25 -
5 Brigden Gate
Halton Hills, ON L7G 0A3
[email protected]
www.haywardgordon.com
Hayward Gordon ULC
5 Brigden Gate ∙ Halton Hills ∙ ON ∙ CANADA ∙ L7G 0A3
T: 905‐693‐8595
https://haywardgordon.com

TERMS AND CONDITIONS OF SALE

FORMATION OF AGREEMENT
These Terms and Conditions of Sale apply to the purchase of Products, Services, or both, by Buyer from Hayward Gordon ULC (hereinafter referred to as “Seller”), each as identified in Seller’s quote. These Terms and Conditions, together with Seller’s quote, comprise the entire agreement between the parties (the “Agreement”).

Seller’s agreement to furnish Product or Services is expressly conditioned on Buyer’s agreement to these Terms and Conditions. An order for Products, Services or both, constitutes Buyer’s acceptance of these terms and conditions. Seller rejects any terms, conditions, or warranties in Buyer’s purchase order or other document or communication that are additional to or differ from those set out in this Agreement, unless set out in writing and signed by Seller’s authorized representative.

PRICES
Quotes. Prices in Seller’s quote are valid for 30 days from the date of the quote unless otherwise specified in writing.

Currency. Prices are in the currency specified in Seller’s quote. If no currency is specified, prices to buyers located in Canada are in Canadian dollars and prices to all other buyers are in US dollars.

Taxes excluded. Prices do not include any Taxes related to the Products or Services supplied under this Agreement, which are the responsibility of Buyer, unless Buyer presents a waiver or an exemption certificate acceptable to Seller.

PAYMENT
Terms. Buyer will pay all invoiced amounts in full, without deduction, back charge or set‐off, within 30 days from the date of Seller’s invoice. Payment is not contingent on Buyer receiving payment from Buyer’s customer.

Late Payment. If payment is not made when required, Seller may at its option take one or more of the following actions: (i) treat such failure as a repudiation of all or a portion of the order that has not been fully performed and immediately suspend performance, (ii) continue production and make shipment under reservation of title or a security interest, and demand payment against tender of documents of title; (iii) charge interest at the lesser of

1.5 % per month and the maximum rate permitted under applicable law, from the due date until paid, plus Seller’s reasonable costs of collection; and (iv) Buyer agrees that Seller may enter the premises where any Products for which Buyer has not paid are located, repossess such Products whatever the mode of their attachment to realty or other property, sell the repossessed Products, apply the proceeds to the overdue payment, and recover any deficiency from Buyer.

DELIVERY, RISK, TITLE
Delivery dates. Delivery dates stated in advance of shipment, including in Seller’s quote, are estimates only and are not guaranteed. Seller will not be liable for or penalized as a result of delays in shipment for any cause. Seller reserves the right, upon prior notice to Buyer, to make partial deliveries or partial performance, which may be separately invoiced.

Buyer Delay. If Products cannot be shipped to or received by Buyer when ready because of any cause attributable to Buyer or its other contractors, Seller may store the Products at the sole expense and risk of Buyer; in such case, Seller will invoice Buyer and terms of payment will apply as if delivery had been made on the original delivery date.

Damage/Shortage. Claims for damages or shortages must be made within 5 days after receipt of Products.

CHANGES
Orders accepted by Seller are not subject to change or cancellation by Buyer, except with Seller’s written consent. Where Seller authorizes changes (including changes to specifications, and special packaging, tests or inspections in addition to Seller’s normal procedures and not set out in Seller’s Quote), Seller may charge Buyer reasonable costs of such change.

Seller will make every effort to maintain initial prices throughout the drawing and submittals process. For the avoidance of doubt, in the instance of any change and resubmittal Seller reserves the right to adjust the price in accordance with equity and necessity.

Further, should the Buyer not respond to confirm drawings and submittals within 30 days the initial price quoted may no longer be valid and may be subject to change in accordance with equity and necessity.

INSTALLATION
All Products will be installed by and at the risk and expense of Buyer, unless otherwise specified in Seller’s quote or agreed to in writing.

WARRANTY
#2..
- 26 -
5 Brigden Gate
Halton Hills, ON L7G 0A3
[email protected]
www.haywardgordon.com
Hayward Gordon ULC
5 Brigden Gate ∙ Halton Hills ∙ ON ∙ CANADA ∙ L7G 0A3
T: 905‐693‐8595
https://haywardgordon.com
Warranty. Seller warrants that during the warranty period:
(a) all Products sold by it to Buyer pursuant to the Agreement, when properly stored, installed, used and maintained by Buyer, will in all material respects, conform to the specifications and be free from defects in materials and workmanship under normal usage; and (b) the Services performed by Seller will be performed in a good and workmanlike manner in accordance with any mutually agreed specifications.

Warranty Period. The warranty period for Products is one year from date of shipment.

Warranty Claims/Seller’s Obligations. A claim must be submitted in writing, within 30 days of discovery, within the warranty period, to give rise to Seller’s obligations. Seller’s sole liability and Buyer’s exclusive remedy for a breach of this warranty is limited to repair or replacement by Seller, in the case of the Product warranty, and re‐performance by Seller in the case of the Services warranty. Such repair, replacement or re‐performance will not
extend the warranty period. Seller may require access to complete and accurate records of operation and maintenance during the warranty period, or the return of defective parts, freight prepaid, before a warranty claim is recognized. Third‐party components. Products may contain components from third party manufacturers. Seller will use reasonable commercial efforts to extend to Buyer the benefit of any warranty given by the component manufacturer to Seller where the third party manufacturer permits it to do so.

No other warranties.

All other warranties, representations, terms and conditions (express, implied or statutory) as to quality, condition, description, merchantability, fitness for purpose, compliance with sample, or non‐infringement (except implied warranty of title) are expressly excluded to the fullest extent permitted by law.

LIMITATION OF LIABILITY
Exclusions. Without limiting the foregoing, Seller will have no liability in respect of:
(i) failure to follow Seller’s use restrictions, specifications, recommendations or instructions or any misuse of the Products; (ii) any alteration, modification, repair, or enhancement of the Products by Buyer or any third party without Seller’s prior written consent;(iii) any defect in the Product arising from designs, specifications or materials supplied by Buyer; (iv) any shipping, storage or working conditions different than those advised by Buyer after Seller’s delivery of Products to Buyer; (v) chemical attack or wear; (vi) normal wear and tear; (vii) accident; (viii) fraud, negligence or wilful misconduct of Buyer or any of its affiliates or representatives; (ix) any Product for which the purchase price has not been paid in full in accordance with the Agreement.

Limitation.
(i) In no event will Seller’ liability, in the aggregate, for damages arising out of the use of the Product or Services, or arising under this Agreement, whether in contract, tort (including negligence), or otherwise, to Buyer or any other person exceed the amount paid by Buyer to Seller under the Agreement for the Products or Services to which such claim or damages relates; (ii) Seller will not be liable for loss of profit or revenues, loss of use of equipment or systems, loss or deferral of production, interruption of business or loss of contract, loss of use, increased operating costs, or claims of Buyer’s customers for any of the foregoing, any special, consequential, incidental, indirect, or punitive damages, whether or not foreseeable at the date of Seller starting performance of the Agreement and even if Seller is advised in advance of the possibility of any such loss or damages

INDEMNITY
Each party will indemnify the other party from and against claims brought by a third party, on account of personal injury or damage to the third party's tangible property, to the extent caused by the negligence of the indemnifying party in connection with this Agreement. If the injury or damage is caused by joint or concurrent negligence of Buyer and Seller, the loss or expense will be borne by each party in proportion to its degree of negligence.

For purposes of Seller's indemnity obligation, no part of a Product is considered third party property, and “third party” does not include Buyer or any subsequent owner of the Products, their subsidiaries, parents, affiliates, agents, successors or assigns, including any operation or maintenance contractor, or their insurer.

EXCUSED PERFORMANCE/FORCE MAJEURE
A party will not be liable in respect of the non‐performance of any of its obligations to the extent such performance is prevented by any circumstances beyond its reasonable control including but not limited to, strikes, lock‐outs or labour disputes of any kind (whether relating to its own employees or others), fire, flood, explosion, natural catastrophe, military operations, blockade, sabotage, revolution, riot, civil commotion, war or civil war, acts or threats of terrorism. If such an event occurs, the time for performance will be extended by the amount of time lost by reason of the event plus such additional time as may be needed to overcome the effect of the event.

GOVERNING LAW
#2..
- 27 -
5 Brigden Gate
Halton Hills, ON L7G 0A3
[email protected]
www.haywardgordon.com
Hayward Gordon ULC
5 Brigden Gate ∙ Halton Hills ∙ ON ∙ CANADA ∙ L7G 0A3
T: 905‐693‐8595
https://haywardgordon.com
Unless otherwise agreed to in writing, the laws of the jurisdiction from which Seller ships the Product(s) will govern the interpretation and construction of this Agreement, and the Parties agree to submit to the exclusive jurisdiction of the courts of such jurisdiction.

Waiver. No waiver of any of the provisions of this Agreement will constitute a waiver of any other provision (whether or not similar).

Severability. If any provision of this Agreement is determined to be illegal, invalid or unenforceable, that provision will be severed from this Agreement and the remaining provisions will remain in full force and effect Assignment/Subcontracting. Seller may assign or novate its rights and obligations under this Agreement, in whole or in part, to any of its affiliates.

Seller may subcontract portions of the work to any third party. #2..
- 28 -
#2..
- 29 -
#2..
- 30 -

CITY OF MODESTO

COMMITTEE AGENDA REPORT
DATE OF MEETING:

September 26, 2022
Date: September 1, 2022
TO: Finance Committee
David Wright, Chair
Rosa Escutia-Braaton, Vice Chair
Jenny Kenoyer, Member
THROUGH: Joseph P. Lopez, City Manager
FROM: DeAnna Christensen, Director of Finance
William Wong, Director of Utilities
SUBJECT: Sole Source Purchase Agreement for Weed Abatement Chemical Premix CONTACT: Cynthia Kline, Purchasing Manager, [email protected], (209) 577-5412 DESCRIPTION:

Consider approving the Sole Source Purchase Agreement with Nutrien Ag Solutions, Sacramento, CA, for weed abatement chemical premix known as (Aqumix Proprietary Custom Pre-blend) for a one-year agreement with four (4) one-year extension options, for an annual estimated amount of $70,000, and a total amount not to exceed $350,000 over five-years and forwarding to Council for approval. (Funding Source: Wastewater and Water Fund) 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 of Modesto, Utilities Department has maintained over seven miles of State of California levee adjacent to the 3,000-acre ranch at the Jennings Facility for more than fifty-three (53) years. Every six-months, the levee is inspected by the Department of Water Resources to ensure the levee continues to meet the requirements of the Army Corps of Engineers. The City is required to maintain this portion of the levee system in a bare ground condition to allow thorough inspections, to help with rodent control, maintain a weed free area around the water collection areas and to lessen mosquito habitat.

DISCUSSION:

Over the years the Utilities Department, Wastewater Division has tried different chemicals which allow for safe mixing, application processes and lowering labor costs. With the weed abatement product purchased through Nutrien Ag Solutions, we’ve reduced the number of required treatments and increased the cost effectiveness of a single mixture, which can accomplish both post and pre-emergent weed control in one application.
#3..
- 31 -
Finance Committee, September 26, 2022
Sole Source Purchase Agreement for Weed Abatement Chemical Premix

Page 2 of 2 ends

This mixture of pesticides, which includes broad spectrum weed killers, surfactant, pre and post emergent and a proprietary suspension allowing the use of non-agitated tanks has proven to be the most efficient and cost effective. Nutrien has returnable containers designed for a closed loop system and does not require the applicators to triple rinse and discard the containers into the trash. This reduces the City’s environmental footprint.

Modesto Municipal Code Section 8-3.204 generally requires all purchases, in excess of fifty thousand dollars $50,000 to follow formal bid procedures. However, MMC 8-3.204(b) provides that a purchase may be exempted from the City’s formal bidding requirement where the Purchasing Agency’s requirements can be met solely by a single article or process.

Additionally, the purchase of the weed abatement chemical premix from Nutrien Ag Solutions should be exempt from the formal bidding procedure in accordance with Modesto Municipal Code 8-3.204(b) because Nutrien Ag Solutions is the sole proprietor vendor that is able to provide the weed abatement chemical premix. Therefore, this purchase qualifies for exemption from the formal bidding procedures.

FISCAL IMPACT:

Funds are budgeted amount the accounts listed below:

FUND ACCOUNT
NUMBER

BUDGETED
AMOUNT
Wastewater Fund 4210-44314-53060 $60,000
Water Fund 4100-45050-52190 $10,000
ESTIMATED ANNUAL AMOUNT $70,000
FIVE (5) YEAR TOTAL NOT TO EXCEED $350,000
Approved by: _________________________________________
DeAnna Christensen, Director of Finance
_________________________________________
William Wong, Director of Utilities
Joseph P. Lopez, City Manager
Attachments:

1. Agreement

2. Exhibit B

3. Bid Waiver
#3..
- 32 -
1 ANNUAL PURCHASE AGREEMENT NO. 230253

NUTRIEN AG SOLUTIONS
This agreement, hereinafter called AGREEMENT, made and entered into in the City of Modesto, State of California, this ____ day of _________, 2022, by and between the City of Modesto, a municipal corporation of the State of California, hereinafter called CITY, and Nutrien Ag Solutions, hereinafter called

VENDOR,
W I T N E S E T H:

WHEREAS, the Modesto City Council adopted Resolution No. 2022- authorizing the Award and AGREEMENT for the aqumix proprietary custom pre-blend described herein (the “GOODS”) to VENDOR, attached hereto as Exhibit “A” and made a part hereof, and WHEREAS, the CITY and VENDOR shall enter into an agreement for the purchase and delivery of aqumix proprietary custom pre-blend as described herein, attached hereto as Exhibit “B” and made a part hereof, and

NOW, THEREFORE, the parties hereto mutually agree as follows:

1. TERM OF AGREEMENT: The term of the AGREEMENT shall be for a period of ONE YEAR with FOUR one-year extension options at the sole discretion of City, for a total of up to five years.

Year one: October 1, 2022 Through September 30, 2023
Year two: October 1, 2023 Through September 30, 2024
Year three: October 1, 2024 Through September 30, 2025
Year four: October 1, 2025 Through September 30, 2026
Year five: October 1, 2026 Through September 30, 2027

2. PRICING:

A. Per the aforementioned Council Resolution, the estimated annual amount of the AGREEMENT is $70,000. The total amount paid by CITY to VENDOR over the full term of the AGREEMENT shall not exceed $350,000.

B. Pricing during AGREEMENT Year one shall be as set forth in Exhibit C Pricing, attached hereto and made a part hereof by this reference.
#3..
- 33 -
2 C. Pricing shall remain firm for the first year of the AGREEMENT.

D. Price increases for each subsequent AGREEMENT years two, three, four, and five, shall be negotiated in good faith by the parties, but in no instance may exceed the net percentage increase during the prior 12 month period in the Federal Bureau of Labor Statistics’ Producers Price Index (PPI) Industry Data for Chemical Manufacturer (Series ID PCU325) with acceptable supporting documentation to substantiate the increase by manufacture. Requests for price increases in any renewal year shall be submitted by VENDOR in writing at least 60 days prior to the annual anniversary date of the AGREEMENT.

3. USAGE: Vendor shall provide whatever quantities may be required during the term of this AGREEMENT.

No minimum or maximum quantities are guaranteed or implied by CITY.

4. DELIVERY: Deliveries shall be made within five (5) working days after an order is placed. If the delivery cannot be made within this time frame,Vendor shall immediately notify the CITY by phone with the anticipated delivery date.

DEPARTMENT CONTACT: Nolan Harris, Jennings Plant Maintenance Supervisor, (209) 342-4524, [email protected]
PUCHASING CONTACT: Carol Wattle, Buyer, (209) 577-5406, [email protected]

5. PAYMENT: All invoices shall be paid in full by CITY after completion and acceptance of the GOODS by the CITY, and receipt of a properly prepared invoice submitted by VENDOR via email to [email protected]. As specified by the Purchasing Division, every invoice must reference this AGREEMENT number. . VENDOR will be paid by CITY via the following payment method [TO BE DETERMINED BY IFB RESPONSE IN FINAL AGREEMENT, EITHER “Net 30 terms via CITY’s ePay Program” or “Net 45 Days via manual check”.]

6. AMENDMENTS: No changes to this AGREEMENT shall be effective unless documented by a written amendment to this AGREEMENT and signed by the parties hereto with CITY represented by the Purchasing Division.

7. TERMINATION:

A. In the event either party fails to perform under this AGREEMENT or breaches any condition contained herein, the other party shall notify in writing the breaching party of the non-performance. Within 30 days after receipt of notification, the breaching party shall correct any non-performance to the reasonable satisfaction of the non-breaching party. Failure to correct any non-performance shall allow the non-breaching party to terminate this AGREEMENT for cause.

B. CITY may terminate this AGREEMENT for convenience upon thirty (30) days prior notice to VENDOR by CITY’s authorized employee.

8. INSPECTION: All GOODS are subject to inspection and test by the CITY for compliance with specifications as included herein, within a reasonable time after delivery. In the event GOODS are defective or not in conformity with this AGREEMENT or CITY’s purchase order, the CITY shall have the rights to either reject the GOODS or require correction. Defective articles or services shall be removed from CITY premises and/or corrected by and at the expense of VENDOR; provided that should the VENDOR fail, #3..
- 34 -
3 neglect or refuse to do so, the CITY shall thereupon have the right to purchase in the open market, in lieu thereof, a corresponding quantity of any such items. CITY may deduct from any moneys due or that may there after come due to VENDOR, or send an invoice to the VENDOR which shall be paid within thirty (30) days, the difference between the prices named in the AGREEMENT or purchase order and the actual cost thereof to the CITY. In the event that the VENDOR fails to make prompt delivery as specified for any item, the same conditions as to the rights of the CITY to purchase in the open market and to reimbursement set forth above shall apply, except when delivery is delayed by fire, strike, freight embargo, or Act of God or the government. Cost of inspection or deliveries or offers for delivery, which do not meet specifications, will be borne by the VENDOR. Failure by CITY to inspect and accept or reject shall not relieve the VENDOR from responsibility for compliance with specifications. Final acceptance shall be conclusive except as regards to latent defects, fraud, or such gross mistakes as amount to fraud.

9. RESPONSIBILITY: Unless otherwise specified, the VENDOR shall be responsible for all GOODS until delivered at CITY’s designated delivery point and shall bear all risks as to items rejected or requiring correction after notice of such rejection or correction is given.

10. SHIPMENT: Unless otherwise authorized by CITY’s Purchasing Division, GOODS shall be delivered F.O.B. Destination Freight Prepaid and Included in Price of GOODS. VENDOR may not collect freight or charge shipping expenses otherwise to CITY. Original receipted freight bill must accompany the invoice.

Shipment must be made within the time stated onAGREEMENT, failing which CITY reserves the right to purchase elsewhere and charge VENDOR with any loss incurred, unless delay in making shipment is due to unforeseeable causes beyond the control and without the fault or negligence of VENDOR.

11. CHANGES: This AGREEMENT may at any time, by written order of the CITY, be changed in regard to the GOODS to be furnished, quantities ordered, unit price, discount, delivery point or arrangements, terms or any other matters affecting a valid PO. In the event such change causes an increase or decrease in the cost of performance hereunder, and equitable adjustment will be made for the cost thereof, subject to the approval of the Purchasing Manager, and written notice given therefore.

12. WARRANTY: Notwithstanding any other provisions of the AGREEMENT, VENDOR warranties for the GOODS shall extend for ninety (90) days after delivery thereof to CITY, shall meet or exceed all original manufacturer warranties, and that GOODS shall be of the most suitable grade as specified in this AGREEMENT, VENDOR’s own marketing materials and in the AGREEMENT. Moreover, VENDOR warrants and represents that GOODS shall comply with warranties of merchantability and fitness for a particular purpose. If a defect is discovered in any GOODS covered in this AGREEMENT, VENDOR shall correct at its expense, including transportation/freight, such defects as are reported within one year of final acceptance.

13. INSURANCE: Any AGREEMENT where work, maintenance, or service is performed on CITY property requires appropriate insurance. VENDOR shall ensure proper insurance certificates are on file with the CITY prior to performing onsite work. Contact CITY’s Purchasing Division to verify the type of insurance required.

14. TAX EXEMPTIONS: The CITY is exempt from payment of federal excise tax. All invoices shall be exclusive of such excise tax. Moreover, if the CITY’s purchase is not subject to sales tax, the statement for resale will appear in the body of the purchase order.
#3..
- 35 -
4 15. INDEMNITIES:

A. VENDOR agrees to protect, indemnify and save harmless CITY and its agents, officers, employees, and volunteers from any claim, loss or damage from VENDOR’s, or the GOODs’, infringement of trademarks, patents, copyrights and unfair competition action with to any third party.

B. VENDOR shall hold the CITY and 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 VENDOR, or its agents, officers, employees, or subcontractors relating to or during the performance of its obligations under this AGREEMENT. VENDOR’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 for VENDOR to procure and maintain a policy of insurance.

16. GOVERNING LAW: This AGREEMENT shall be deemed made in, governed by, performed in, and construed and enforced in accordance with the laws of the State of California, U.S.A., without giving effect to its conflicts of law provisions or principles.

17. VENUE: Venue for any dispute or claim arising or related to this AGREEMENT its performance, breach, or interpretation (including issues about its validity or enforceability), shall be exclusively in the Superior Court of Stanislaus County or the United States District Court for the Eastern District of California.

18. ATTORNEYS’ FEES: If a party to this AGREEMENT brings any action, including an action for declaratory relief, to enforce or interpret the provision of this AGREEMENT, the prevailing party shall be entitled to reasonable attorneys’ fees in addition to any other relief to which that party may be entitled. The court may set such fees in the same action or in a separate action brought for that purpose.

19. LIMITATION OF LIABILITY: The CITY shall not be responsible for any damage that may accrue by reason of the death or injury of the person of the VENDOR’s officers, agents, employees, invitees, or licensees, or be set up at any time because of personal injury or damage to property sustained by any other person or persons, which may have been caused or contributed to, approximately or remotely, by reason of or in the course of performance of the AGREEMENT. The VENDOR shall assume full responsibility for the defense of any claims arising under the AGREEMENT and the VENDOR shall save, keep, and bear harmless the CITY, all officers and employees thereof, from all damages, costs, or expenses because of personal injury or property damage based on the performance of this AGREEMENT or asserted against it.

20. NOTICES: Any notice, payment or instrument required or permitted by this AGREEMENT to be given or delivered to either party shall be deemed to have been received when personally delivered, or one calendar week following deposit of the same in any United States Post Office, registered or certified mail, postage prepaid addressed as follows:

CONTRACTOR: Nutrien Ag Solutions
10200 Systems Parkway
Sacramento, CA 95827
Attn: Chris Blodget
CITY: City of Modesto
Purchasing Division
#3..
- 36 -
5 P.O. Box 642
Modesto, CA 95353
Either party may change its address for delivery of notice by delivering written notice of such change of address to the other party.

21. ASSIGNMENT: Neither this AGREEMENT nor any portion hereof shall be subcontracted or assigned without the written consent of the CITY in each and every instance.

22. MISCELLANEOUS: Time is of the essence in each and every provision of this AGREEMENT.

23. ENTIRE AGREEMENT: This AGREEMENT and its exhibits contain the entire understanding between VENDOR and CITY. Additional or new terms contained in this AGREEMENT which vary from VENDOR’s bid are controlling and are deemed accepted by VENDOR by provision of any GOODS or other commencement of performance hereunder. . All previous bids, 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 or exception to any of the terms, conditions, and provisions of this AGREEMENT shall be considered valid unless specifically agreed to in writing by the parties.

24. 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.

IN WITNESS WHEREOF, the CITY OF MODESTO, a municipal corporation, has authorized the execution of this AGREEMENT in duplicate by its Director of Finance and attested by its City Clerk under authority of Resolution No. 2022- adopted by the Council of the City of Modesto on the _____________ day of _____________________, 2022 and Nutrien Ag Solutions has caused this AGREEMENT to be duly executed.
#3..
- 37 -
6 EXHIBIT C
PRICING – EFFECTIVE OCTOBER 1, 2022

ITEM DESCRIPTION UNIT UNIT PRICE
(GALLON)
1 AQUMIX PROPRIETARY CUSTOM PRE-BLEND GAL $155.72
2 PCA RECOMMENDATIONS AND SERVICES, PRODUCT FIELD USE AND

SAFETY TRAINING EA INCLUDED
PRICING TO INCLUDE DELIVERY AND RETURN OF EMPTY DRUMS.

PRICING IS NET TO THE CITY, EXCLUSIVE OF FEDERAL EXCISE TAX, CALIFORNIA STATE, LOCAL, SALES AND USE TAX.

CITY OF MODESTO SALES TAX RATE 7.875%
MINIMUM ORDER: 135 GALLONS/ACRES. (9-15GAL DRUMS)
270 GALLONS (18-DRUMS)
300 GALLONS (20-DRUMS)
VENDOR CONTACT: Chris Blodget, Territory Manager
PHONE: (530) 762-8253
EMAIL: [email protected]
#3..
- 38 -
#3..
- 39 -
#3..
- 40 -
#3..
- 41 -
#3..
- 42 -
#3..
- 43 -
#3..
- 44 -
#3..
- 45 -
#3..
- 46 -
#3..
- 47 -

CITY OF MODESTO

COMMITTEE AGENDA REPORT
DATE OF MEETING:

September 26, 2022
Date: August 31, 2022
TO: Finance Committee
David Wright, Chair
Rosa Escutia-Braaton, Vice Chair
Jenny Kenoyer, Member

THROUGH: Joseph P. Lopez, City Manager
FROM: DeAnna Christensen, Director of Finance
SUBJECT: Amendment #1 with Stanislaus Regional Transit Authority for Facility and Fleet Maintenance
CONTACT: DeAnna Christensen, Director of Finance, [email protected], 209-577-5387
DESCRIPTION:

Consider approving the Amendment #1 to the Facility and Fleet Maintenance Agreements between the City of Modesto and the Stanislaus Regional Transit Authority, and forwarding to Council for approval. (Funding Source: Local Transportation Funds, State Transit Assistance, Farebox Revenue, & Federal Transit Administration (FTA) STRATEGIC PLAN ELEMENT:

This item advances the City of Modesto 2020-2025 Strategic Plan Area: Governance and Service Delivery: “build community trust in City government through responsive, transparent and efficient service delivery”; Goal J: “build a high-performance organization”.

BACKGROUND:

On January 26, 2021, by Resolution 2021-26, Council approved a Joint Powers Agency (JPA) agreement with Stanislaus County to form the Stanislaus Regional Transit Authority.

On April 6, 2021, by Resolution 2021-114, Council approved an amendment to the Joint Powers Agency (JPA) agreement with Stanislaus County to form the Stanislaus Regional Transit Authority.

As part of the transition and implementation process to form the Stanislaus Regional Transit Authority, several agreements were put in place to assign responsibility, provide services and lease facilities between the City and the Authority.
#4..
- 48 -
Finance Committee, September 26, 2022
Amendment #1 with Stanislaus Regional Transit Authority for Facility and Fleet Maintenance

Page 2 of 3 ends

On June 22, 2021, by Resolution 2021-252, Council approved the various agreements with the Stanislaus Regional Transit Authority to transition City transit services to the Stanislaus Regional Transit Authority.

DISCUSSION:

During the transition of operations to the Stanislaus Regional Transit Authority, certain updates to the facility and fleet maintenance agreements were discovered. These are necessary to maintain continued operations of the organization and its services.

These amendments propose the following changes:

Facility Maintenance

1. Grant the City Manager and Executive Director authority to approve minor amendments to the agreement without further approval from the governing board of the City or the Stanislaus Regional Transit Authority.

2. Decrease the hourly labor rate charged to Stanislaus Regional Transit Authority due to over budgeted utilities in FY2021/2022, and increase monthly insurance costs for the Transit Center and Amtrak Station due to an increase to the City’s insurance premium.

3. Discontinue pressure washing services due to Stanislaus Regional Transit Authority procuring a vendor contract for these services, and implement reductions to the monthly rates associated with these services.

Fleet Maintenance

2. Increase the hourly and fixed labor rates charged to Stanislaus Regional Transit Authority to capture increases in labor costs and discretionary expenses.

3. Allow the City of Modesto to recoup costs for expenses not fully captured by the hourly maintenance rate and fixed management and staff support rate, or issue payment to Stanislaus Regional Transit Authority if payments received exceed true costs at fiscal year-end.

FISCAL IMPACT:

There is no impact to the General Fund with these amendments. An analysis of the fiscal impact to each amendment is found below:

Facility Maintenance:

The revenue received from the Stanislaus Regional Transit Authority for facility maintenance services will fully compensate the City for the services, including management and overhead expenses. There will not be additional funds needed from the General fund #4..
- 49 -
Finance Committee, September 26, 2022
Amendment #1 with Stanislaus Regional Transit Authority for Facility and Fleet Maintenance

Page 3 of 3 ends

Fleet Maintenance
The revenue received from the Stanislaus Regional Transit Authority for bus maintenance services will fully compensate the City for the services, including management and overhead expenses. There will not be additional funds needed from the General Fund.

Approved by:

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

1. Amendment #1 to Agreement for Maintenance Services StanRTA and Modesto

2. Amendment #1 to Agreement for Maintenance Services Modesto Transit Center and Amtrak Station
#4..
- 50 -
1 | P a g e
Amendment 1 Agreement for Maintenance Services: Modesto and Authority- v3 AMENDMENT #1

TO AGREEMENT FOR MAINTENANCE SERVICES

BETWEEN

THE CITY OF MODESTO AND
THE STANISLAUS REGIONAL TRANSIT AUTHORITY (StanRTA)
This AMENDMENT #1 (“Amendment”) to that certain Agreement entered into by and between the parties on June 22, 2021, is dated October_____, 2022 for reference purposes and is by and between the Stanislaus Regional Transit Authority, a joint powers authority established under California Code section 6500 et seq., hereinafter referred to as “Authority”, and the City of Modesto, a municipal corporation, hereinafter referred to as “Modesto.” The Effective Date of this Agreement shall be ______________ , 2022.

A. WHEREAS, Authority and Modesto have entered into that certain Agreement for Maintenance Services dated June 22, 2021, and effective as of July 1, 2021 (“Agreement”); and
B. WHEREAS, both parties desire to amend the Agreement to allow for a “true-up” of expenses and revenue at the end of each fiscal year to account for variations in costs and services provided pursuant to the Agreement.

NOW THEREFORE, in consideration of the mutual promises, covenants, terms and conditions contained herein, the parties desire to amend the Agreement and agree as follows:

1. Section 2.2 is hereby amended in full to read as follows:

2.2. Modesto will be reimbursed for hours worked, parts at cost, and a fixed fee for staffing all at the rates specified in the approved Schedule of Fees. The Fees listed in the approved Schedule of Fees shall increase annually on July 1 by an amount not to exceed three percent (3%), to account for increases in labor and material costs. Modesto shall provide notice to Authority of the revised Schedule of Fees at least ninety (90) days prior to the effective date of the Revised Fees. In addition, the Parties mutually agree to meet approximately 60 days before the end of each fiscal year to discuss the Schedule of Fees and mutually agree if other adjustments are necessary. The Modesto City Manager and Authority Chief Executive Officer are authorized to approve any such changes in writing. Modesto will not increase staffing levels or other expenses for the purpose of Authority without the mutual written agreement of the Authority. Modesto shall provide to Authority a statement of Modesto’s actual costs for parts, labor and staffing incurred for the preceding fiscal year and compare such amount to the amounts received from Authority. If on the basis of such statement, the Parties mutually determine the Authority owes an amount that is more than the Authority’s payments for the preceding year, #4..
- 51 -
2 | P a g e
Amendment 1 Agreement for Maintenance Services: Modesto and Authority- v3 Authority shall pay the deficiency to Modesto within thirty (30) days after the Parties mutual agreement of the owed amount. If the Parties mutually determine Authority paid amounts which exceeded Modesto’s actual costs for the preceding fiscal year, Modesto shall refund the overpayment or issue a credit on a future invoice to Authority within thirty (30) days after the Parties mutual agreement of the owed amount.

2. Section 2.3 is hereby amended in part to update invoice delivery information for Authority as follows:

Stanislaus Regional Transit Authority
912 11th Street, Suite 100
Modesto, CA 95354
Email: [email protected]
Attention: Accounts Payable

3. Section 14 is hereby amended in part to update notice information for Authority as follows:

Stanislaus Regional Transit Authority
912 11th Street, Suite 100
Modesto, CA 95354
Email: [email protected]
Attention: Adam Barth, Chief Executive Officer

4. Exhibit “A”, “Scope of Work”, Section IV, Sub-section 2.5 “Other Requirements” is hereby amended in part by adding the following:

2.5.8 Modesto shall provide electronic key card access to the Authority Chief Executive Officer and up to three (3) specified designees with additional designees as agreed upon between the Modesto City Manager and the Authority Chief Executive Officer. Access shall be provided to the bus maintenance area of the Facility during times when maintenance staff are on duty. At the maintenance desk inside the bus maintenance area of the Facility, the Chief Executive Officer or specified designees will notify the City of Modesto counter staff or on-duty City of Modesto supervisor of the Bus Maintenance area. Authority shall indemnify, hold harmless and defend Modesto and its officers, employees, agents, representatives or subcontractors from and against all claims, damages, losses, judgments, liabilities, expenses, and other costs, including litigation costs and attorney’s fees, arising out of or resulting from the gross negligence of the Chief Executive Officer or designees accessing the maintenance areas of the Bus Maintenance Facility, except if caused by the sole negligence or willful misconduct of Modesto.

5. Exhibit “B”, “Schedule of Fees,” of the Agreement is hereby amended in part as #4..
- 52 -
3 | P a g e
Amendment 1 Agreement for Maintenance Services: Modesto and Authority- v3 follows:

Hourly rate for services and repairs: This charge will be documented on work orders by the hour or portion thereof at the rate of $105.13 per hour.

Parts charges: Parts are charged at the cost to the City.

Fixed Fee - Management and Staff Support: This charge is for specified management and support services at the rate of $18,557.67 per month.

The Fees listed in this Schedule of Fees shall increase annually on July 1 by an amount not to exceed three percent (3%), to account for increases in labor and material costs. Modesto shall provide notice to Authority of the revised Schedule of Fees at least ninety (90) days prior to the effective date of the Revised Fees.

In addition, the Parties mutually agree to meet in accordance with Section 2.2 of the Agreement to discuss the Schedule of Fees and if other adjustments are necessary.

6. Section 19 is hereby amended in its entirety as follows:

Section 19. Amendment. This Agreement, including any exhibits hereto, shall not be amended, except in writing signed by the parties. Any amendment or addendum to this Agreement shall expressly refer to this Agreement. The Modesto City Manager and Authority Chief Executive Officer shall have the authority to approve minor amendments to this Agreement without further approval from the governing board of Modesto or Authority. For the purposes of this section, an amendment shall be a minor amendment if it substantially conforms with the material terms of this Agreement. Without limiting the generality of the foregoing, changes to the time for either Party to perform any obligation, changes in reporting obligations, and non-material changes to the scope of work may be made via a minor amendment. Changes to the insurance requirements, indemnification obligations or term of the Agreement shall not be minor amendments. The mutual determination of the Modesto City Manager and Authority Chief Executive Officer regarding whether an amendment qualifies as a minor amendment shall be definitive.

7. Except as modified by this Amendment, the Agreement shall remain unchanged and is in full force and effect.

8. The terms and provisions of this Amendment are incorporated by reference into the Agreement as though set forth in full therein.

9. This Amendment may be executed in any number of counterparts with the same effect as if the parties had all signed the same document, and which together shall constitute one and the same instrument.

10. Each party agrees that this Amendment and any other documents to be delivered #4..
- 53 -
4 | P a g e
Amendment 1 Agreement for Maintenance Services: Modesto and Authority- v3 in connection herewith may be electronically signed, and that any electronic signatures appearing on this Amendment or such other documents are the same as handwritten signatures for the purposes of validity, enforceability, and admissibility.

IN WITNESS WHEREOF, this AMENDMENT #1 has been executed hereto and will become effective as of the Effective Date.

Stanislaus Regional Transit Authority,
a Joint Powers Agency
By: _________________________________
Adam Barth
Chief Executive Officer
Date: ________________________________
City of Modesto, a municipal corporation
By: _________________________________
Joseph Lopez
City Manager
Date: ________________________________
APPROVED AS TO FORM:

By: _________________________________
Monica Streeter
General Counsel
ATTEST:

By: _________________________________
Diane Nayares-Perez
City Clerk
APPROVED AS TO FORM:

By: _________________________________
Jose M. Sanchez
City Attorney
APPROVED AS RISK MANAGEMENT:

By: _________________________________
Joe Rodriguez
Risk Manager
#4..
- 54 -
5 | P a g e
Amendment 1 Agreement for Maintenance Services: Modesto and Authority- v3 #4..
- 55 -
1 | P a g e
Amendment 1: Maintenance Agreement Transit Center & Amtrak Station – v7 AMENDMENT #1

TO THE AGREEMENT FOR MAINTENANCE SERVICES

MODESTO TRANSIT CENTER AND AMTRAK STATION
(1001 9th Street and 1700 Held Drive, Modesto, California) This Amendment #1 (“Amendment”) to that certain Agreement entered into between the parties on June 22, 2021, is dated October ___ 2022 for reference purposes and is by and between the Stanislaus Regional Transit Authority, a joint powers agency, hereinafter referred to as “Authority”, and the City of Modesto, a municipal corporation, hereinafter referred to as “Modesto”. The Effective Date of this Agreement shall be ______________ , 2022.

WHEREAS, Authority and Modesto have entered into that certain Agreement for Maintenance Services of the Modesto Transit Center and Amtrak Station dated June 22, 2021 (the “Agreement”); and
WHEREAS, both parties desire to amend the Scope of Work to the Agreement.

NOW THEREFORE, in consideration of the mutual promises, covenants, terms and conditions contained herein, the parties desire to amend the Agreement and agree as follows:

1. Section 2.1 is hereby amended in part to update invoice delivery information for Authority as follows:

Stanislaus Regional Transit Authority
912 11th Street, Suite 100
Modesto, CA 95354
Email: [email protected]
Attention: Accounts Payable

2. Section 7.3 is hereby amended in part to update the property insurance rates as follows:

For FY 2022-23, the City may invoice Authority for such costs up to $4,076/year for the Transit Center and $3,431/year for the Amtrak Station. The costs listed may increase or decrease annually on July 1 based upon any actual changes to City’s insurance premium.

Said amount shall be mutually agreed upon in writing by the Modesto City Manager and Authority Chief Executive Officer to account for increases or decreases in insurance costs. Modesto shall provide Authority notice of the revised costs at least (90) days prior to the effective date of the revised costs. In addition, the Parties mutually agree to meet approximately 60 days before the end of each fiscal year to discuss these costs and if other adjustments to the Agreement are necessary.
/ / /
/ / /
#4..
- 56 -
2 | P a g e
Amendment 1: Maintenance Agreement Transit Center & Amtrak Station – v7

3. Section 12 is hereby amended in part to update notice information for Authority as follows:

Stanislaus Regional Transit Authority
912 11th Street, Suite 100
Modesto, CA 95354
Email: [email protected]
Attention: Adam Barth, Chief Executive Officer

4. Section 16 is hereby amended in its entirety as follows:

Section 16. Amendment. This Agreement, including any exhibits hereto, shall not be amended, except in writing signed by the parties. Any amendment or addendum to this Agreement shall expressly refer to this Agreement. The Modesto City Manager and Authority Chief Executive Officer shall have the authority to approve minor amendments to this Agreement without further approval from the governing board of the City or Authority. For the purposes of this section, an amendment shall be a minor amendment if it substantially conforms with the material terms of this Agreement. Without limiting the generality of the foregoing, changes to the time for either Party to perform any obligation, changes in reporting obligations, and non-material changes to the scope of work may be made via a minor amendment. Changes to the insurance requirements, indemnification obligations or term of the Agreement shall not be minor amendments.

The mutual determination of the Modesto City Manager and Authority Chief Executive Officer regarding whether an amendment qualifies as a minor amendment shall be definitive.

5. Exhibit “A”, “Scope of Work” attached to the Agreement is replaced in full with the Exhibit “A” attached hereto and incorporated herein.

6. Except as modified by this Amendment, the Agreement shall remain unchanged and is in full force and effect.

7. The terms and provisions of this Amendment are incorporated by reference into the Agreement as though set forth in full therein.

8. This Amendment may be executed in any number of counterparts with the same effect as if the parties had all signed the same document, and which together shall constitute one and the same instrument.
***Signatures contained on next page***
#4..
- 57 -
3 | P a g e
Amendment 1: Maintenance Agreement Transit Center & Amtrak Station – v7 IN WITNESS WHEREOF, this AMENDMENT #1 has been executed hereto as of the day and year written above.

City of Modesto, a municipal corporation
By: _________________________________
Joseph P. Lopez
Its City Manager
Stanislaus Regional Transit Authority, a
joint powers agency
By:________________________________
Adam Barth
Its Chief Executive Officer
ATTEST:

By:__________________________________
Diane Nayares-Perez, City Clerk
APPROVED AS TO FORM:

By: ________________________________
Monica Streeter, General Counsel
APPROVED AS TO FORM:

By:__________________________________
Jose M. Sanchez, City Attorney

APPROVED AS TO RISK
MANAGEMENT:

By:____________________________________
Joe F. Rodriguez, Risk Manager
#4..
- 58 -
4 | P a g e
Amendment 1: Maintenance Agreement Transit Center & Amtrak Station – v7 EXHIBIT “A”

SCOPE OF WORK
Authority shall perform or reimburse Modesto for completion of the tasks identified in this Scope of Work.

I. Sweeping: Modesto shall sweep the Transit Center and Amtrak Station and invoice Authority monthly as set forth in this section.

A. Transit Center

1. Sweep parking lots at the Transportation Center, bus side: (Estimated 3 hours per week from January through September (3hrs *39 wks = 117 hrs), and 19 hours per week from October through December (19 hrs * 13 wks = 247 hrs); total sweeping hrs= 364.)
B. Amtrak Station

1. Sweep parking lots at the Amtrak Station (Estimated 3 hours weekly (156 hrs/yr)).

The sweeping costs are:

Transit Center: $15,003/year or $1,250.25/month, billed to Authority monthly.

Amtrak Station: $6,430/year or $535.84/month, billed to Authority monthly.

The fees listed above shall increase annually on July 1 by an amount mutually agreed by both parties to account for increases to labor costs. Modesto shall provide Authority notice of the revised fees at least ninety (90) days prior to the effective date of the revised fees. In addition, the Parties mutually agree to meet approximately 60 days before the end of each fiscal year to discuss the fees and if other adjustments are necessary.

Modesto will provide monthly reports identifying when and where sweeping services were preformed and the number of hours worked for each location and each date.

II. Custodial Services: As of the Effective Date of this Agreement, Modesto contracts with Kellermeyer Bergensons Services for Custodial Services. Modesto shall invoice Authority monthly for the services performed by Kellermeyer Bergensons Services, consistent with the Tasks set forth in the tables below (Table 1: Amtrak Station; Table 2: Downtown Transit Center).

Costs for such Custodial Services shall be invoiced to Authority as follows. Any additional rate or materials increases not outlined in the schedule of fees below will be mutually agreed by both parties and billed at the actual cost for the service or material. #4..
- 59 -
5 | P a g e
Amendment 1: Maintenance Agreement Transit Center & Amtrak Station – v7 Location June 1, 2021
– May 31,
2022 (per
month
charge)
June 1, 2022
– May 31,
2023 (per
month
charge)
June 1, 2023
– May 31,
2024 (per
month
charge)
June 1, 2024
– May 31,
2025 (per
month
charge)
June 1, 2025
– May31,
2026 (per
month
charge)
Amtrak
Station $2,770.73 $2,907.17 $3,061.95 $3,224.96 $3,396.66 Transit
Center $10,387.51 $10,899.01 $11,479.28 $12,090.43 $12,734.13 Total $13,158.24 $13,806.18 $14,541.23 $15,315.39 $16,130.79 Description Yr 2
Per Hour
Yr 3
Per Hour
Yr 4
Per Hour
Yr 5
Per Hour
Opt Yr
Per Hour
Additional
Services $25.08 $26.31 $27.71 $29.19 $30.74
#4..
- 60 -
6 | P a g e
Amendment 1: Maintenance Agreement Transit Center & Amtrak Station – v7 Table 1: Amtrak Station
III. Additional Services: Performed by Modesto and Billed to Authority at the Hourly Rate of $117.89 through June 30, 2022, and $101.47 effective July 1, 2022 for tasks described below or repairs directed by Authority, with parts or outside services provided at cost with appropriate documentation. The fees listed above shall increase annually on July 1 by an amount mutually agreed by both parties to account for increases to labor costs. Modesto shall provide Authority notice of the revised fees at least ninety (90) days prior to the effective date of the revised fees. In addition, the Parties mutually agree to meet approximately 60 days before the end of each fiscal year to discuss the fees and if other adjustments are necessary.

PM Name PM ID Frequency Description Estimated PM Duration (Hrs.) Estimated Total Duration (Hrs.) Per site Estimated Total Annual Duration (Hrs.)
Fire Sprinkler PM Fire Sprinkler PM Every 3 month(s) 1.75 7.00 14.00 Fire Extinguisher PM FIREEXTPM Every 1 month(s) 1.00 12.00 24.00 Fire Alarm Monitor Operation and Central Station Communications Fire System Electronics Annually

3.00 3.00 6.00 HVAC Annual HVAC - A April of every 1 year(s) 4.75 4.75 9.50 HVAC Quarterly HVAC Q Every 3 month(s) 2.50 7.50 45.00 Water Heater PM WH Every 6 month(s) 1.25 2.50 5.00 Elevator Inspection Elevator_Lift_Inspection Every 1 month(s) 0.50 6.00 6.00 Exterior Paint Preparation PNT_EXTR Every 5 years 60.00 12.00 24.00 Automatic Doors AUTO_DOOR Every 3 month(s) 1.25 5.00 0.00 Manual Doors MAN_DOOR Every 6 month(s) 3.00 6.00 12.00 Roof Gutter Inspection ROOF INSPECTION A Every 6 month(s) 5.25 10.50 21.00 Restricted keyway locksets Restricted keyway locksets Every 6 month(s) 3.00 6.00 12.00 Electronic locksets Electronic locksets Every 6 month(s) 2.50 5.00 10.00 TOTAL ESTIMATED PM HOURS: 87.25 188.50
Annual AED Inspections Transportation Center AED Annual Aug 10 of every 1 year(s) 1.00 1.00 1.00 Monthly AED Inspections Transportation Center AED Monthly Day 15 of every 1 month(s) 0.75 8.25 8.25 Transportation Center Inspection TC INSPECT Monthly 1.50 18.00 18.00 TOTAL ESTIMATED PM HOURS: 27.25 27.25
Amtrak Inspection AMTRAK INSPECT Monthly 2.50 30.00 30.00 TOTAL ESTIMATED PM HOURS: 30.00 30.00
AMTRAK TOTAL ESTIMATED PM HOURS: 117.25 218.50
Transit Center TOTAL ESTIMATED PM HOURS: 114.50 215.75
COMBINED TOTAL ESTIMATED PM HOURS: 144.50 245.75
#4..
- 61 -

CITY OF MODESTO

COMMITTEE AGENDA REPORT
DATE OF MEETING:

September 26, 2022
Date: August 22, 2022
TO: Finance Committee
David Wright, Chair
Rosa Escutia-Braaton, Vice-Chair
Jenny Kenoyer, Member
THROUGH: Joseph P. Lopez, City Manager
FROM: DeAnna Christensen, Director of Finance
SUBJECT: May and June 2022 Grant Application and Awards CONTACT: Maria Garnica, Accounting Manager, [email protected] 209-577-5249
DESCRIPTION:

Consider accepting an informational report on the May and June 2022 grant applications and awards and forwarding to Council for approval. (Funding Source: Not Applicable) 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 Finance Department coordinated with California Consulting to update the Administrative Directive 7.2, “Grant Management.” The revised directive was updated on July 1, 2021 to streamline the grant management process and to establish better controls on local match requirements, including potential future costs which could be required as part of a grant agreement. Additionally, the Finance Department coordinated several training sessions to highlight key changes to the new directive.

This directive has eliminated the requirement to go to Council for the application and acceptance of grant awards if the amount of the grant is less than $1,000,000 and does not require any local match funding. The Director of Finance is authorized to approve grant applications and awards under $25,000 with no local funding requirements. The City Manager has the authority for approving grant applications and awards between $25,000 and under $1,000,000 with no local match funding requirements. Due to the need for quick turnaround on grant application and award acceptance required by the granting agencies, this directive allows for City departments to apply for more grants within the grant application periods and provide quick response to award acceptance deadlines.
#5..
- 62 -
Finance Committee, September 26, 2022
May and June 2022 Grant Application and Awards

Page 2 of 3 ends

The Finance Department will inform Council of all grant activity by preparing a bi-monthly informational report on both grant applications and awards. Finance Department has established internal grant application forms to manage the types of grants being applied for and to ensure local match requirements will be managed within our current budget.

City departments continue to actively pursue new grant applications as part of notifications received from federal, state, and local agencies they have subscribed to, such as Department of Housing, Department of Transportation, State Water Resources Control Board, Department of Justice and professional government associations. City departments have staff assigned to monitor these grant application notices to determine if the City meets the required qualifications to apply for the grant.

DISCUSSION:

During the months of May and June 2022, City Council approved the below grant applications and awards recommended by City staff based on opportunities to receive federal, state and/or local grant funds for the City with required local match or which exceeded $1,000,000 with no local match.

Community and Economic Development Department:
(Grant Award $1,724,157 – Local Match $0) – HomeKey 2.0 Project Application for 112 James Street, from the State of California. Funds from this grant in partnership with Stanislaus County Affordable Housing Corporation (STANCO) and Stanislaus County Behavioral Health and Recovery Services (BHRS) will be used to purchase a seven-unit apartment building known as James Street Apartments that will provide permanent supportive housing for Stanislaus County BHRS clients who are at risk or experiencing homelessness, and is designed to serve those who are homeless or chronically homeless.
(Grant Award $3,409,774 – Local Match $0) – Home Investment Partnerships ProgramAmerican Rescue Plan Grant from Unites States Department of Housing and Urban Development. Funds from this grant are intended to be used primary to benefit qualifying individuals and families who are homeless, at risk of homelessness, or in other vulnerable populations. Activities that can be funded with the grant include the development and support of affordable housing, tenant based rental assistance programs, provisions of supportive services and acquisition and development of noncongregate shelter units. Based on the City’s analysis it has been determined that the grant awarded to the City would best serve the community in the development of permanent housing units.

Finance Department:
(Grant Award $1,332,915 – Local Match $0) California Water and Wastewater Arrearage Payment Program (CWWAPP). CWWAPP grant funds will be used to provide economic relief to residential and commercial customers with outstanding delinquency in their wastewater account, incurred during the COVID-19 relief time period of March 4,2020 to June 15, 2021.

Modesto Fire Department:
(Grant Application $40,000 – Local Match- Department budget $20,000) Cal Fire Rural Fire Capacity Program Grant from the State of California Cal Fire. Funds from this grant will be used for the replacement of wildland firefighting equipment in order to replace #5..
- 63 -
Finance Committee, September 26, 2022
May and June 2022 Grant Application and Awards

Page 3 of 3 ends

aging and outdated wildland equipment that is no longer in service or does not meet current standards.

During the months of May and June 2022, the Director of Finance and City Manager approved the below grant applications recommended by City staff based on opportunities to receive local grant funds for the City with no required local match.

Public Works Department:
(Grant Application $58,000– Local Match $0) CalRecycle Used Oil Payment Program 13 Cycle from State of California Cal Recycle. Funds from this grant will be used to fund the curbside used oil collection, public education non the importance of recycling used oil and filters, staffing to make appointments, answer questions, and oversee the curbside used oil collection program and certified centers in Modesto. (Grant Application $50,000 – Local Match $0) Household Hazardous Waste Discretionary Grant Cycle 39 (HD39). Funds from this grant will be used to fund staff time, public education on household hazardous waste and the costs of the collection events including recycling and disposal of household hazardous waste.

During fiscal year 2021, City Council, City Manager and Director of Finance authorized grant applications for a combined amount totaling $16,745,457 of which $16,016,554 was successfully awarded to fund programs and projects Citywide.

FISCAL IMPACT:

No fiscal impact will result from the acceptance of this informational report on May and June 2022 grant application and awards. A monthly summary by grant application and awards is below:

Grant Applications: $148,000
Grant Applications Local Match, from Department Budget $20,000 Grant Awards: $6,466,846
Approved by:

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

1. May and June 2022 Grant Applications and Award

2. FY 2021 authorized applications status
#5..
- 64 -
May and June 2022 Grant Applications
Grant Application
Grant Title Month Grant Awarding Agency City Department Name/Division Grant
Application
Amount
Grant
Application
Local Match
Amount Local Match Source
Cal Fire Rural Fire Capacity Program Grant MAY-22 State of California - Cal Fire Modesto Fire Department 40,000 20,000 Current Budget CalRecycle Used Oil Payment Program 13 JUN-22 State of California -Cal Recycle Public Works Department 58,000 - N/A Household Hazardous Waste Discretionary Grant Cycle 39 (HD39) JUN-22 State of California -Cal Recycle Public Works Department 50,000 - N/A Total $ 148,000 $ 20,000
May and June 2022 Grant Awards
Grant Awards
Grant Title Month Grant Awarding Agency City Department Name/Division Grant Award
Amount
Grant Award
Local Match
Amount Local Match Source
California Water and Wastewater Arrearage Payment Program (CWWAPP) MAY-22 State of California Finance Department 1,332,915 - N/A HOME-American Rescue Plan Grant MAY-22 U.S. Department of Housing and Urban Development Community & Economic Development Department 3,409,774 - N/A Homekey 2.0 - 112 James Street MAY-22 State of California Community & Economic Development Department 1,724,157 - N/A Total $ 6,466,846 $ -
#5..
- 65 -
Grant Applications Authorized July 2020 to June 2021
Grant Title Month

Grant Awarding Agency City Department Name/Division Grant Application $ Local Match $ Grant Status
Funds
Awarded $
California Department of Transportation for Highway Safety Improvement Program (HSIP) funds Jul-20 Caltrans Division of Local Assistance Community and Economic Development 1,958,330 $ 195,833 Awarded 1,958,330 2020 Edward Byrne Memorial Justice Assistance Grant Jul-20 Bureau of Justice Assistance Modesto Police Department $ 130,530 - Awarded 130,530 2020-2021 BHRS Party Patrol Grant Jul-20 Behavioral Health & Recovery Service of Stanislaus County Modesto Police Department $ 10,000 - Awarded 10,000 Beverage Container Recycling City/County Payment Program FY2020-2021 Oct-20 CalRecycle Public Works Department - Solid Waste $ 54,672 - Awarded 54,672 Urban Forest Management Activities Jan-21 California Department of Forestry and Fire Protection Public Works Department - Forestry $ 739,100 257,675 Awarded 557,420 Cannabis Equity Grant Program Jan-21 Governor's Office of Business and Economic Development Community Development Department $ 75,000 - Awarded 75,000 Office of Traffic Safety Pedestrian and Bicycle Safety Program Jan-21 Office of Traffic Safety Modesto Police Department $ 150,000 - Awarded 100,000 California Department of Health Naloxone Distribution Project Feb-21 California Department of Health Modesto Police Department $ 6,240 - Awarded 6,100 2021-2022 Alcohol Policing Partnership Program Mar-21 California Alcohol Beverage Control Modesto Police Department $ 57,500 - Awarded 55,000 Fiscal Year 2020 Staffing Adequate Fire and Emergency Response (SAFER) Grant Mar-21 Department of Homeland Security (DHS) Modesto Fire Department $ 4,489,734 - Awarded 4,244,402 Fiscal Year 2020 Assistance to Firefighters Grant (AFG) Mar-21 Department of Homeland Security (DHS) Modesto Fire Department $ 45,251 4,525 Not Awarded - Local Waste Tire Amnesty Grant Program TA6 Cycle FY21/22 Mar-21 CalRecycle Public Works Department - Solid Waste $ 25,000 - Not Awarded - Statewide Park Development and Community Revitalization Program Apr-21 California Department of Parks and Recreation Parks, Recreation and Neighborhoods $ 8,500,000 - Awarded 8,500,000 Federal Aviation Administration Grant Apr-21 Federal Aviation Administration (FAA) Public Works - Airport $ 339,100 33,910 Awarded 305,100 Cal Fire Rural Fire Capacity Program Grant FY 2021 May-21 Cal FIRE Modesto Fire Department $ 40,000 20,000 Awarded 20,000 U.S. DOJ Office of Community Oriented Policing Services Law Enforcement Mental Health and Wellness Act May-21 U.S. Department of Justice Modesto Police Department $ 125,000 - Not Awarded - $ 16,745,457 $ 511,943 $ 16,016,554
#5..
- 66 -

CITY OF MODESTO

COMMITTEE AGENDA REPORT
DATE OF MEETING:

September 26, 2022
Date: September 21, 2022
TO: Finance Committee:

David Wright, Chair
Rosa Escutia-Braaton, Vice-Chair
Jenny Kenoyer, Member
THROUGH: Joseph P. Lopez, City Manager
FROM: Scott Conn, Chief Information Officer
SUBJECT: CivicPlus Modesto Website Hosting Renewal
CONTACT: Scott Conn, Chief Information Officer
[email protected], 209.577.5229
DESCRIPTION:

Considering approval of a Sole Source Renewal Agreement with CivicPlus for continued, uninterrupted hosting and maintenance of the City of Modesto’s website (www.modestogov.com) for another four-year term at an amount of $149,350 plus a 10% contingency in the amount of $14,935 for a total amount not to exceed $164,285. (Funding Source: Information Technology Fund)
STRATEGIC PLAN ELEMENT:

This item is consistent with the City’s 2020-2025 Strategic Plan to promote trust and engagement with the community and directly supports the Smart City Strategy adopted in 2021.

BACKGROUND:

The City’s website is available to employees and the public 24-hours per day, 7-days per week, 365-days per year and is utilized as the major information dissemination vehicle for residents and non-residents alike. After a lengthy Request for Proposal (RFP) process accomplished in 2018, the City of Modesto entered into an agreement with CivicPlus to help re-design, host and implement our current website. That agreement is nearing completion and as the City has been satisfied with the hosting services supplied by CivicPlus, desires to renew the agreement for an additional four-year term.

DISCUSSION:

As part of this renewal agreement, CivicPlus has agreed to work with our IT and Community & Media Relations team to continue re-designing our website over time to make it easier to find #6..
- 67 -
Finance Committee, September 26, 2022
CivicPlus Modesto Website Hosting Renewal

Page 2 of 3 ends

topics of greatest interest and to navigate using a single button click to logical places where desired information should be located.

The renewal includes the addition of two new website editing modules, Design Center Pro and CivicOptimize. Design Center Pro will help facilitate the redesign of the existing site and allow staff to directly control and make desired design updates throughout the 4-year term of the agreement. CivicOptimize will allow staff to create and implement new electronic routable and signable forms within the website designed to replace the current paper-based forms which must be downloaded and manually processed by residents and City staff alike.

The contingency of 10%, in the amount of $14,935, is recommended as a safeguard to cover unanticipated website-related costs such as new security requirements, additional update implementation work, training, and consulting.

Modesto Municipal Code Section 8-3.203 generally requires all purchases, which meet or exceed $50,000 for material, equipment, or contractual services to be formally bid. However, Staff believes the renewal of this agreement with CivicPlus should be exempt from the formal bidding process in accordance with Modesto Municipal Code 8-3.204(b) since they are the sole provider of this already implemented and ongoing service. MMC 8-3.204(b) provides that a purchase may be exempted from the City’s formal bidding requirement where the Purchasing Agency’s requirements can be met solely by a single article or process.

The alternative to renewing with CivicPlus involves creation of a new external website Request For Proposal (RFP) to essentially obtain the identical services currently provided by CivicPlus.

Such an effort would engage significant City staff time and negate the approximately $34,500 in price reductions negotiated between the City and CivicPlus for this staff recommended renewal.

FISCAL IMPACT:

Under the renewal agreement, the financial impact for hosting, maintenance, security protection, implementation and training, and ongoing website optimization services will be as follows:

Annual Fee One-time Cost Total Comments
Year 1 $ 33,687 $ 8,101 $ 41,788
One-time charges for implementation and training on Design Center Pro and CivicOptimize
Year 2 $ 34,697 $ 158 $ 34,855 One-time charges for biennial security certification Year 3 $ 35,739 $ - $ 35,739 No one-time charges - regular hosting fees and maintenance Year 4 $ 36,810 $ 158 $ 36,968 One-time charges for biennial security certification 10% Contingency $ 14,093 $ 842 $ 14,935 Safeguard to cover unanticipated costs throughout term Totals = $ 155,026 $ 9,259 $ 164,285
This will not impact the current 2022-23 fiscal year nor subsequent years as this is sourced through the existing Information Technology Internal Service Fund (ISF) balance and will be included in the annual Information Technology ISF allocation. #6..
- 68 -
Finance Committee, September 26, 2022
CivicPlus Modesto Website Hosting Renewal

Page 3 of 3 ends

Approved by:

Scott Conn, Chief Information Officer
Joseph P. Lopez, City Manager
Attachments:

1. CIVICPLUS RENEWAL SOW
#6..
- 69 -
V. PD 06.01.2015-0048

Page 1 of 3 ends

CivicPlus Annual Payments
All Fees and Services are Invoiced October 1 each year:

Year 1 (2022-2023)
Annual Recurring Services (Oct 1, 2022 - Sept 30, 2023) $33,686.79 One-Time Services $8,101.00
Year 1 Total (October 1, 2022 – Sept 30, 2023) $41,787.79 Year 2 (2023-2024)
City of Modesto Annual Service – Engage
Website Hosting
$11,071.91
Media Center Storage Annual Fee $1,228.13
City of Modesto SSL Cert (modestogov.com)
(Every other year Fee)
$158.00
Design Center Pro Annual Service $5,402.35
CivicOptimize Annual Service $16,995.00
Annual Recurring Services (Oct 1, 2023 - Sept 30, 2024) $34,697.39 Biennial Recurring SSL Cert Fee $158.00
Year 2 Total (October 1, 2023 – Sept 30, 2024) $34,855.39 Year 3 (2024-2025)
City of Modesto Annual Service – Engage
Website Hosting
$11,404.08
Media Center Storage Annual Fee $1,264.98
Design Center Pro Annual Service $5,564.42
CivicOptimize Annual Service $17,504.85
Annual Recurring Services (Oct 1, 2024 - Sept 30, 2025) $35,738.31 Year 3 Total (October 1, 2024 – Sept 30, 2025) $35,738.31 Year 4 (2025 – 2026)
City of Modesto Annual Service – Engage $11,746.19
City of Modesto Annual Service – Engage
Website Hosting
$10,749.43
Recurring Website Redesign Available upon
renewal
Included
Media Center Storage Annual Fee $1,192.36
Design Center Pro Module – Implementation
& Training (One-time Fee)
$1,538.00
Design Center Pro Annual Service $5,245.00
CivicOptimize Implementation & Training
(One-time Fee)
$6,563.00
City of Modesto Annual Service –
CivicOptimize
$16,500.00
ATTACHMENT 1
#6..
- 70 -
V. PD 06.01.2015-0048

Page 1 of 3 ends

Website Hosting
Media Center Storage Annual Fee $1,302.92
City of Modesto SSL Cert (modestogov.com)
(Every other year Fee)
$158.00
Design Center Pro Annual Service $5,731.35
CivicOptimize Annual Service $18,030.00
Annual Recurring Services (Oct 1, 2025 - Sept 30, 2026) $36,810.46 Biennial Recurring SSL Cert Fee $158.00
Year 4 Total (October 1, 2025 – Sept 30, 2026) $36,968.46 Grand Total (Oct 1, 2022 – Sept 30, 2026) - $149,349.95 #6..
- 71 -
V. PD 06.01.2015-0048

Page 3 of 3 ends

CivicPlus
302 South 4th St. Suite 500
Manhattan, KS 66502 US
Product: CivicEngage Renewal
Client: Modesto, CA
Bill To
Modesto CA – CivicEngage – Renewal Statement of Work
Annual Renewing Services:

QTY Product Description PRODUCT TYPE Total
1 City of Modesto Annual Service Renewable $10,749.43
1 *Annual Fee Renewal for City of Modesto SSL Cert Renewable $158.00 Annual Recurring Services (Oct 1, 2022 - Sept 30, 2023) $10,749.43 *Line item is charged biennially and NOT subject to 3% uplift on each recurring year Additional Services added:

QTY Product Name DESCRIPTION PRODUCT
TYPE
TOTAL

1.00 Design Center Pro Bundle -
CivicEngage Central
Includes Annual Subscription,
Implementation, and 1 Block of Training
(Up to 2 individuals - 4 Hours)
USD 0.00

1.00 Design Center Pro Annual Fee -
CivicEngage Central
Design Center Pro Annual Fee Renewable USD 5,245.00

1.00 Design Center Pro
Implementation - CivicEngage
Central
Design Center Pro Implementation One-time USD 788.00

1.00 Design Center Pro Training (4h,
virtual) - CivicEngage
Up to 1/2 day virtual instruction with live
instructor. (Pricing per two (2) seats)
One-time USD 750.00
Total Investment - Year 1 USD 6,783.00
Annual Recurring Services – (Subject to Uplift) USD 5,245

1. This Statement of Work ("SOW") shall be subject to the terms and conditions of the CivicPlus Master Services Agreement located at https://www.civicplus.com/master-services-agreement (“MSA”), to which this SOW is hereby attached as the Renewal Statement of Work. By signing this SOW, Client expressly agrees to the terms #6..
- 72 -
V. PD 06.01.2015-0048

Page 4 of 3 ends

and conditions of the MSA throughout the Term of this SOW.

2. This renewal SOW shall remain in effect for an initial term starting October 1, 2022 through September 30, 2023 (“Initial Term”). In the event that neither party gives 60 days’ notice to terminate prior to the end of the Initial Term, or any subsequent Renewal Term, this SOW will automatically renew for an additional 1-year renewal term (“Renewal Term”). The Initial Term and all Renewal Terms are collectively referred to as the “Term”.

3. Annual Recurring Services shall be invoiced on the first day of the Initial Term and every 12 months thereafter.

Annual Recurring Services, including but not limited to hosting, support and maintenance services, shall be subject to a 3% annual increase each Renewal Term. Client will pay all invoices within 30 days of the date of such invoice

4. Client shall be entitled to receive a redesign during the Initial Term. Upon the initiation of an eligible redesign project, Client may begin accumulate eligibility towards a subsequent redesign after another 48 months of continuous service. Redesigns that include additional features not available on the original website may be subject to additional charges. Additional features include, but are not limited to, additional modules and integration of third-party software.

Recurring Redesigns are eligible for the website, subsite, and department headers included in this SOW only. Any subsequently purchased website, subsite, and department header shall not be included in a redesign hereunder.

The year of Client’s last redesign was 2019.

5. Client allows CivicPlus to display a “Government Websites by CivicPlus” insignia, and web link at the bottom of their web pages. Client understands that the pricing and any related discount structure provided under this SOW assumes such perpetual permission.

6. If Client’s use of the Design Center module results in a loss in website or software function or other issue requiring CivicPlus resources to remedy, Client will be charged an hourly fee of $160 for such resources.

Acceptance
By signing below, the parties are agreeing to be bound by the covenants and obligations specified in this SOW and the MSA terms and conditions found at: https://www.civicplus.com/master-servicesagreement.

IN WITNESS WHEREOF, the parties have caused this SOW to be executed by their duly authorized representatives as of the dates below.

Client CivicPlus
By: By:

Name: Name:

Title: Title:

Date: Date:
#6..
- 73 -
V. PD 06.01.2015-0048

Page 1 of 3 ends

CivicPlus
302 South 4th St. Suite 500
Manhattan, KS 66502
US
Client:

Modesto CA - CivicOptimize
Quote #: Q-21809-4
Date: 1/11/2022 4:42 PM
Expires On: 10/31/2022
Product: CivicOptimize
Bill To:

Modesto CA - CivicOptimize
SALESPERSON Phone EMAIL DELIVERY METHOD PAYMENT METHOD
Tiffany Grover x [email protected] Net 30
CivicOptimize - Statement of Work

QTY PRODUCT NAME DESCRIPTION PRODUCT
TYPE
TOTAL

1.00 Productivity Starter Package Productivity Starter Package USD 0.00

1.00 Productivity Starter System
Annual Fee
Productivity Starter System Annual Fee:
50 staff app users; 15,000 app user
submissions / month; Data Manager: 10
enabled forms/ app/ 5 app users
Renewable USD 15,000.00

1.00 Power Automate Integration Power Automate Integration Renewable USD 1,500.00

1.00 Productivity System Set-Up Productivity System Set-Up: Up to five (5) hours form development (Forms
Templates or Custom); App Graphics
(Icon & Banner); up to two (2) hours
training
USD 0.00

5.00 Productivity Custom Form
Development (1h)
Productivity Custom Form Development
(1h)
One-time USD 500.00

1.00 Productivity Custom App Banner Productivity Custom App Banner One-time USD 263.00

1.00 Productivity System Training (2h,
virtual)
Productivity System Training (up to 2h,
virtual)
One-time USD 375.00

1.00 Productivity Custom App Icon Productivity Custom App Icon One-time USD 160.00

1.00 Productivity Standard
Implementation Services
Standard Implementation: The CivicPlus
team will document your process
workflow, and will work with your team
to build, configure, and style your
solution. Up to 32 hours services.

One-time USD 5,265.00
Total Investment - Year 1 USD 23,063.00
Annual Recurring Services - Year 2 USD 16,995.00
#6..
- 74 -
V. PD 06.01.2015-0048

Page 2 of 3 ends

Total Days of Quote:365

1. This Statement of Work ("SOW") shall be subject to the terms and conditions of the CivicPlus Master Services Agreement located at https://www.civicplus.com/master-services-agreement (“MSA”), to which this SOW is hereby attached as the CivicOptimize Statement of Work. By signing this SOW, Client expressly agrees to the terms and conditions of the MSA throughout the Term of this SOW.

2. This SOW shall remain in effect for an initial term starting October 1, 2022 through September 31, 2023 (“Initial Term”). In the event that neither party gives 60 days’ notice to terminate prior to the end of the Initial Term or any subsequent Renewal Term, this SOW will automatically renew for an additional 1-year renewal term (“Renewal Term”).

The Initial Term and all Renewal Terms are collectively referred to as the “Term”.

3. The Total Investment - Year 1 will be invoiced at signing of this SOW. Client will pay all invoices within 30 days of the date of invoice.

4. Annual Recurring Services shall be invoiced on the start date of each Renewal Term. Annual Recurring Services, including but not limited to hosting, support and maintenance services, shall be subject to a 3% annual increase beginning in year 2 of service.

5. Client understands CivicPlus shall have no obligation to provide the Services or maintain Client data, information or other material after this SOW is terminated or if Client’s accounts are past due and unpaid, as set forth in the MSA.

6. Client’s use of the Services is subject to the Acceptable Use Policy set forth at https://www.civicoptimize.civicplus.help/hc/en-us/articles/360046849654-Acceptable-Use-Policy.

7. Client understands and agrees that the Client is solely responsible for the content and type of data stored for its end users and/or constituents. CivicPlus implements industry standard data protection for stored data; however, the Productivity services contracted for herein (the “Services”) are not intended to store personally identifiable information (“PII”), personal health information (“PHI”), payment card industry information (“PCI”) or any other financial data. CivicPlus strongly discourages Client from soliciting and storing PHI within the Services and prohibits Client from soliciting and storing any PCI or any other financial data within the system. CivicPlus cannot monitor and control Client’s actions; therefore, in the event Client solicits and stores any PII, PHI, PCI or other financial data, it is at Client’s sole discretion and risk. Client as the data owner, and not CivicPlus, is solely responsible for the applicable laws and regulations regarding any data breach involving such data, including breach notification and credit monitoring requirements.

8. EXCEPT AS OTHERWISE EXPRESSLY PROVIDED IN THIS AGREEMENT, CIVICPLUS MAKES NO

REPRESENTATION OR EXTENDS ANY WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, TO THE

CLIENT WITH RESPECT TO ANY TECHNOLOGY OR OTHER SUBJECT MATTER OF THIS AGREEMENT AND

HEREBY DISCLAIMS ALL IMPLIED WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT WITH RESPECT TO ANY AND ALL OF THE FOREGOING.

Signature Page to Follow.
#6..
- 75 -
V. PD 06.01.2015-0048

Page 3 of 3 ends

IN WITNESS WHEREOF, the parties have caused this SOW to be executed by their duly authorized representatives as of the dates below.

Client CivicPlus
By: By:

Name: Name:

Title: Title:

Date: Date:
#6..
- 76 -
Contact Information
*all documents must be returned: Master Service Agreement, Statement of Work, and Contact Information Sheet.

Organization URL
Street Address
Address 2
City State Postal Code
CivicPlus provides telephone support for all trained clients from 7am –7pm Central Time, Monday-Friday (excluding holidays).

Emergency Support is provided on a 24/7/365 basis for representatives named by the Client. Client is responsible for ensuring CivicPlus has current updates.

Emergency Contact & Mobile Phone
Emergency Contact & Mobile Phone
Emergency Contact & Mobile Phone
Billing Contact E-Mail
Phone Ext. Fax
Billing Address
Address 2
City State Postal Code
Tax ID # Sales Tax Exempt #
Billing Terms Account Rep
Info Required on Invoice (PO or Job #)
Are you utilizing any external funding for your project (ex. FEMA, CARES): Y [ ] or N [ ] Please list all external sources:

Contract Contact Email
Phone Ext. Fax
Project Contact Email
Phone Ext. Fax
V. PD 06.01.2015-0048

Page 1 of 1 ends

#6..
- 77 -
Pricing Sheet – pricing below is not guaranteed and is
subject to change
CivicEngage
AUDIOEYE – Minimum Pricing
▪ $11,300 Annually
CHATBOT – Minimum Pricing
▪ $12,000 Annually

DESIGN CENTER PRO
▪ $788 Set Up/ $5,245 - $5,245 Annually = $6,033 Year 1 ▪ Design Center Pro Training – 4hr Block - $750

SMS SUBSCRIBERS
▪ Block of 500 subscribers- $945 Annually
IMPLEMENTATION WORK – Minimum Pricing
▪ Block of Time-(4 Hours) - $625
50GB SITE STORAGE with BACKUP and DR – Minimum Pricing
▪ $1200 Annually
PLATINUM SECURITY – Minimum Pricing
▪ $4,800 Annually per domain
ADFS/ DNS/ SSL:
▪ ADFS- $3,000 Set Up/ $1,500 Annually = $4,500 Year 1
▪ DNS- $150 Set Up/ $180 Annually = $330 Year 1
▪ SSL $150 Set Up/ $150 Annually = $300 Year1
o Client Controlled or Wildcard- $158 Set Up
LOGO AND BRANDING – Minimum Pricing
▪ $11,500
PREMIUM DEPARTMENT HEADERS – Minimum Pricing
▪ $4,515 Set Up/ $800 Annually = $5,315 Year 1
Training Not Included
+CivicPlus.com CORPORATE OFFICE
302South4
th Street
Manhattan, KS 66502
V. PD 06.01.2015-0048

Page 11 of 13 ends

888.228.2233 + FAX 7853.587.8951
#6..
- 78 -
+CivicPlus.com CORPORATE OFFICE
302South4
th Street
Manhattan, KS 66502
888.228.2233 + FAX 7853.587.8951
V. PD 06.01.2015-0048

Page 12 of 13 ends

Pricing Sheet – pricing below is not guaranteed and is
subject to change
PREMIUM SUBSITES – Minimum Pricing
▪ $17,400 Set Up/ $7,200 Annually = $24,600 Year 1
Training Not Included
PREMIUM ONE-TIME REDESIGN – Minimum Pricing
▪ $15,475
Training Not Included
TRAINING & CONSULTING – 3 Day Minimum Required for onsite Onsite Training:
▪ $3,750/day plus travel
Travel - $1,500 for first 2 nights + $500 each additional night Virtual Training: (Up to 6 people)
▪ 4-hour blocks- $750
Virtual Consulting: (Up to 6people)
▪ 4-hour blocks- $1,500

VIRTUAL WEBMASTER
▪ Block of 5 hours per month= $6,000 Annually
CivicOptimize
ANNUAL SERVICES – Minimum Pricing
▪ $5,265
ANNUAL ADD ON’S – Minimum Pricing
▪ Productivity External System Connector - $1,500 Annually ▪ Productivity Connector - $1,500 Annually
▪ Custom Domain Name - $1,500 Annually
TRAINING & CONSULTING – 3 Day Minimum Required for onsite Onsite Training:
▪ $3,750/day plus travel
Travel - $1,500 for first 2 nights + $500 each additional night Virtual Training: (Up to 6 people)
▪ 4-hour blocks- $750
Virtual Consulting: (Up to 6people)
▪ 4-hour blocks- $1,500
#6..
- 79 -
+CivicPlus.com CORPORATE OFFICE
302South4
th Street
Manhattan, KS 66502
888.228.2233 + FAX 7853.587.8951
V. PD 06.01.2015-0048

Page 13 of 13 ends

Pricing Sheet – pricing below is not guaranteed and is
subject to change
CONTENT & FORM DEVELOPMENT – Minimum Pricing
▪ Productivity Custom Form Development (per page) - $40 ▪ Productivity Custom Form Development (per hour) - $100 DESIGN DEVELOPMENT – Minimum Pricing
▪ Productivity Custom App Banner - $160
▪ Logo Development - $5,000
▪ Productivity CSS Styling (1 Hour) - $160
▪ Hourly Design Work (per hour) - $160
▪ Productivity Custom App Icon - $160
INTEGRATIONS & CONNECTORS – Minimum Pricing
▪ Productivity Connector Setup (available integrations) - $1,500 ▪ Productivity External System Connector Development (per hour) - $265 ▪ Productivity Custom App Development - $265
▪ Payment Integrations - $265
▪ Database Integration - $265
▪ Technical Implementation - $250
Technical Support – Minimum Pricing
▪ API Technical Support (per hour) - $1,500
Approved Payment Gateway Package – Minimum Pricing
▪ Approved Payment Gateway - $1,500 Annually
▪ Approved Payment Gateway Implementation - $2,500
CP Pay Package – Minimum Pricing
▪ CP Pay – NO FEE
▪ CP Pay Implementation – NO FEE
CUSTOM IDP PACKAGE – Minimum Pricing
▪ Custom IdP Integration Implementation - $1,575
▪ Custom IdP Integration - $1,575 Annually
▪ Secondary set up of Custom IdP - $525
#6..
- 80 -
1 https://calrecycle.ca.gov/BevContainer/Grants/BevContainer/fy2022-24/

CITY OF MODESTO

COMMITTEE AGENDA REPORT
DATE OF MEETING:

September 26, 2022
Date: August 30, 2022
TO: Finance Committee
David Wright, Chair
Rosa Escutia-Braaton, Vice-Chair
Jenny Kenoyer
THROUGH: Joseph P. Lopez, City Manager
FROM: Bill Sandhu, Public Works Director
SUBJECT: Authorize staff to apply for the California Department of Resources, Recycling and Recovery Beverage Container Recycling Competitive Grant CONTACT: Rosene Salmo, Integrated Waste Program Manager, [email protected], (209) 577-5453
DESCRIPTION:

Consider authorizing the submittal of application(s) to the California Department of Resources, Recycling and Recovery for beverage container recycling grants that support recycling education, and encourages reducing and reusing beverage containers in Modesto, and forwarding to Council for approval. (Funding Source: California Department of Resources, Recycling and Recovery)
STRATEGIC PLAN ELEMENT:

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

Governance and Service Delivery, “Build community trust in City government through responsive, transparent and efficient service delivery”; Goal I: “Promote trust and engagement between the community and the City”.

BACKGROUND:

The California Department of Resources, Recycling and Recovery (CalRecycle) Beverage Container Recycling Grant is a competitive grant that offers a minimum of $75,000, up to a maximum of $275,000, to successful applicants1. There is no match requirement for this grant.

The goal of CalRecycle’s beverage container recycling grant is to reach and maintain an 80 percent recycling rate for all California Refund Value beverage containers – aluminum, glass, plastic, and bi-metal. This grant program assists organizations with establishing convenient beverage container recycling and litter abatement projects, which encourage market development and expansion activities for beverage container materials. #7..
- 81 -
Finance Committee, September 26, 2022
Authorize staff to apply for the California Department of Resources, Recycling and Recovery Beverage Container Recycling Competitive Grant

Page 2 of 2 ends

The City of Modesto’s Solid Waste Division uses grant funds to implement many of the waste reduction and recycling programs offered to City residents and businesses. Over the last 10 years, the City of Modesto’s Solid Waste Division has received more than $1.9 million in grant funds for programs to recycle used oil and filters, beverage containers and waste tires, enforce waste tire disposal, as well as install playground surfacing and equipment, and providing assistance to local businesses with recycling efforts.

DISCUSSION:

If approved, the City of Modesto would apply for the beverage container recycling grant offered by CalRecycle, depending on available funding. The grant is a great opportunity to increase the City’s current infrastructure in support of the City/County payment program received annually. If approved, staff proposes to purchase and install water refill stations throughout City buildings, partner with Modesto schools and Modesto junior college on installing water refill stations and purchasing indoor recycling bins. In addition, staff would consider a partnership with the Modesto Children’s Museum to create an interactive recycling exhibit.

On January 1, 2023, the City will be adding a third container to its current solid waste system, and the container will be dedicated to recycling materials only. With this grant funding, the City plans on purchasing indoor recycling containers to distribute to City buildings, schools, parks, stadiums and museums.

FISCAL IMPACT:

Submitting an application does not commit the City to a financial obligation or to accepting the grant, if awarded. There is no match requirement for this grant, thus this item is administrative in nature and has no fiscal impact.

Approved by:

Bill Sandhu, Public Works Director
Joseph P. Lopez, City Manager
#7..
- 82 -

CITY OF MODESTO

COMMITEE AGENDA REPORT
DATE OF MEETING:

September 26, 2022
Date: July 26, 2022
TO: Finance Committee
David Wright, Chair
Rosa Escutia-Braaton, Vice-Chair
Jenny Kenoyer, Member
THROUGH: Joseph P. Lopez, City Manager
FROM: DeAnna Christensen, Director of Finance
SUBJECT: Annual Investment Report – Fiscal Year 2021-2022 CONTACT: Calogero Maniscalco, Senior Financial Analyst
[email protected], (209) 577-5219
DESCRIPTION:

Consider accepting the Annual Investment Report for Fiscal Year 2021-2022. (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. The final of these reports each fiscal year is an annual report. Attached are the June 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 and Annual Investment Reports are to keep the City Council and City Manager informed of the City’s investment portfolio. As shown in Attachment 2, #8..
- 83 -
Finance Committee, September 26, 2022
Annual Investment Report – Fiscal Year 2021-2022

Page 2 of 3 ends

on June 30, 2022 the City had a closing market value of $456,908,745 in its investment portfolio.

Interest rates rose during the year and the fixed income market responded to the Fed's 75 basis point rate hike in June with increased yields. This led to negative total return performance for the final month of the fiscal year. The City’s Portfolio outperformed the benchmark over the past year by 27 basis points even as credit spreads widened, and Treasuries outperformed corporates over the past month. The higher interest rate environment we are now in has resulted in the continuation of a higher portfolio yield at cost and reflects the potential for higher earnings going forward.

U.S. Treasury Yields
Fiscal Year
End
6/30/22
Fiscal Year
End
6/30/21
Change
Year on
Year
3-month 1.63% 0.04% 1.59%
1-year 2.74% 0.07% 2.67%
2-year 2.95% 0.25% 2.70%
3-year 3.01% 0.46% 2.55%
5-year 3.04% 0.89% 2.15%
FISCAL IMPACT:

As mentioned, as of June 30, 2022, the City’s investment portfolio had an approximate market value of $456 million. For the year ending June 30, 2022, the City’s securities portfolio returned -4.33% versus the benchmark return of -4.60% (gross fees). This is a gross outperformance of 27 basis points (0.27%) against the benchmark.

The City’s portfolio is well balanced. The portfolio has sufficient liquidity with 53.92% in maturities under two years and 16.4% in overnight securities. The City’s portfolio remains diversified in U.S. government securities, corporate notes, negotiable CDs, and asset-backed securities. The City’s diversification has led to increased investment earnings vs the benchmark over the prior fiscal year.

In June, the approximate yield of the City’s combined investments was 1.57% (see attachment 3) on a weighted average. For the portfolio of securities alone, the yield to maturity on cost was

1.64%. For comparative purposes, the yields (as of June 30, 2022) of other investments commonly used by public agencies are listed below:

Local Agency Investment Fund: 0.86%
#8..
- 84 -
Finance Committee, September 26, 2022
Annual Investment Report – Fiscal Year 2021-2022

Page 3 of 3 ends

1-Year U.S. Treasury Note: 2.89%
2-Year U.S. Treasury Note: 2.94%

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

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
#8..
- 85 -

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 75,106,115
Federal Agency 32 71,831,320
Federal Home Loan Bank 2 4,242,433
Federal Home Loan Mortgage Co. 9 20,976,760
Federal Nat’l Mortgage Assc. 20 44,342,492
Federal Farm Credit Bank 1 2,269,634
Federal Agency CMO 3 1,795,699
U.S. Treasury 56 201,526,115
Commercial Paper 4 39,834,690
Negotiable CD 3 8,082,323
Corporate Note 18 38,883,714
Asset-Backed 17 7,034,193
Municipal 10 7,219,545
Supranational 2 5,595,032
Total Invested 146 456,908,745
Sector Allocation
June 30, 2022 versus May 31, 2022
Sector June 30, 2022 May 31, 2022 Change in Allocation Permitted by Policy
U.S. Treasury 44.1% 46.5% -2.38% 100%
Federal Agency 15.7% 16.7% -0.95% 100%
Federal Agency CMO 0.4% 0.5% -0.08% 100%
Commercial Paper 8.7% 9.2% -0.47% 25%
Negotiable CD 1.8% 1.9% -0.10% 30%
Corporate Note 8.5% 9.1% -0.55% 30%
Asset-Backed 1.5% 1.7% -0.21% 20%
Municipal 1.6% 1.7% -0.09% 100%
Supranational 1.2% 1.3% -0.07% 30%
CAMP 16.4% 11.5% 4.90% 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 yield curve steepening continued over the month, specifically in 0 to 2 year space as markets were surprised by the 75 basis point (0.75%) hike at the June 15th Fed meeting. Yields beyond 2 years, while they moved higher, flatten as markets priced in expectations for a rate retreat in 2024. Credit sector spreads widened on poor consumer sentiment data and overall uncertainty for the future economic outlook. In the Long-Term Portfolio, we purchased two longer duration Treasury securities with the proceeds from the sale of a two short duration Treasuries. In the Short-Term Portfolio we replaced a commercial paper security that had matured.
#8..
- 86 -

Page 2 ends

PERFORMANCE
The City’s Long-Term Portfolio has consistently outperformed its benchmark since the inception of performance reporting. Interest rates rose during the month, as the fixed income market responded to the Fed's 75 basis point rate hike, resulting in negative total return performance for the month. The City’s Portfolio underperformed the benchmark over the past month as credit spreads widened and Treasuries outperformed corporates. The higher interest rate environment we are now in has resulted in the continuation of a higher portfolio yield at cost over last month. This reflects the potential for higher realized earnings going forward.

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
June 30, 2022
1 Month Trailing
12 Months
Trailing 36
Months
Trailing 60
Months
Since
Inception5
City of Modesto Investment Portfolio1,2,3-0.62% -4.33% 0.37% 1.28% 1.99% Modesto Performance Benchmark4-0.58% -4.60% 0.04% 0.93% 1.72% Average Long-Term Portfolio Yields
June 30, 2022
Past
Month
Past 3
Months
Past
Year
Past 3
Years
Past 5
Years
City of Modesto Investment Portfolio 1.64% 1.60% 1.39% 1.59% 1.95% $119.3
$27.0
$100.1
$78.5
$115.5
$16.5
$-
$30.0
$60.0
$90.0
$120.0
$150.0
$180.0
Under 6
Months
6-12
Months
1-2 Years 2-3 Years 3-4 Years 4-5 Years
millions
Maturity Distribution
June 30, 2022
#8..
- 87 -

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.10%
Fiscal Year-to-Date Income Return

1.31%
Prior 12 Months Income Return

1.31%
#8..
- 88 -

Page 4 ends

Source: Bloomberg, Freddie Mac Commitment Rates as of 6/23/22. National Association of REALTORS, as of May 2022..

Economic Summary
U.S. Housing Starts Decline as Mortgage Rates Rise

5.81%

2.5%

3.0%

3.5%

4.0%

4.5%

5.0%

5.5%

6.0%

6.5%

7.0%
US Mortgage 30-Year Rates

1.55 0.8

1.0 1.2

1.4 1.6

1.8 2.0
2016 2017 2018 2019 2020 2021 2022
Millions
Housing Starts (SAAR)
#8..
- 89 -

Page 5 ends

Source: Bloomberg, as of May 2022.

Economic Summary
May Consumer Spending Report Surprised to the Downside
#8..
- 90 -

Page 6 ends

Source: ICE BofAML 1-5 year Indices via Bloomberg, MarketAxess and PFM as of 4/30/2022. 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 ABS Sector Spreads Widen
-0.10%
-0.05%

0.00%

0.05%

0.10%

0.15%
Jun-21 Sep-21 Dec-21 Mar-22 Jun-22
Federal Agency Yield Spreads

0.30%

0.40%

0.50%

0.60%

0.70%

0.80%

0.90%

1.00%
Jun-21 Sep-21 Dec-21 Mar-22 Jun-22
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%
Jun-21 Sep-21 Dec-21 Mar-22 Jun-22
Asset-Backed Securities AAA Yield Spreads
Agency yield spreads
remained near-zero
#8..
- 91 -

Page 7 ends

Treasury Yields Moved Higher
Source: Bloomberg as of 06/30/2022.

Economic Summary

2.46%

2.74%

2.95% 3.01% 3.01%

3.18%

0.00%

0.25%

0.50%

0.75%

1.00%

1.25%

1.50%

1.75%

2.00%

2.25%

2.50%

2.75%

3.00%

3.25%

3.50%
3M1Y 2Y 3Y 4Y 5Y 10Y 30Y
U.S. Treasury Yield Curve
June 30, 2022
March 31, 2022
December 31, 2021
#8..
- 92 -

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
#8..
- 93 -
For the Month Ending June 30, 2022
Account Statement
Consolidated Summary Statement
CITY OF MODESTO - Combined Portfolio
Investment Allocation
Investment Type Closing Market Value Percent
Asset-Backed Security 7,034,193.28 1.54
Federal Agency Bond / Note 71,831,320.15 15.72
Corporate Note 38,883,713.86 8.51
Certificate of Deposit 8,082,322.56 1.77
Federal Agency Commercial Mortgage-Backed Security 1,795,699.05 0.39 Commercial Paper 39,834,690.00 8.72
Municipal Bond / Note 7,219,544.85 1.58
Supra-National Agency Bond / Note 5,595,032.05 1.22
U.S. Treasury Bond / Note 201,526,114.80 44.11
CAMP Pool 75,106,114.53 16.44
Total $456,908,745.13 100.00%
Portfolio Summary
and Income
Closing
Portfolio Holdings Market Value
Cash Dividends
PFMAM Managed Account 381,364.86 381,802,630.60
CAMP Pool 0.00 75,106,114.53
Total $381,364.86 $456,908,745.13
Maturity Distribution (Fixed Income Holdings)
Portfolio Holdings Closing Market Value Percent
75,106,114.53
14,368,456.88
29,852,280.00

0.00 32,008,400.52
95,074,323.95
78,501,752.46
115,539,508.31
16,457,908.48

0.00 16.44

3.14 6.53

0.00 7.01

20.81 17.18

25.29 3.60

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 $456,908,745.13
674
100.00%
Weighted Average Days to Maturity
Sector Allocation

1.54% ABS

15.72%
Fed Agy Bond /
Note

8.51%
Corporate Note

1.77%
Cert of Deposit

0.39%
Federal Agency
Commercial
Mortgage-Backed
Security

8.72%
Commercial Paper

1.58%
Muni Bond / Note

1.22%
Supra-National
Agency Bond / Note 44.11%
US TSY Bond / Note

16.44%
CAMP Pool
Summary Page 1
#8..
- 94 -
Managed Account Summary Statement For the Month Ending June 30, 2022 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)
$383,792,967.22
(10,775,006.34)
(7,465,300.00)
18,697,020.90

0.00 (2,447,051.18)
$381,802,630.60
386,536.18
(6,715.15)
1,543.83
$381,364.86
Total
394,295,279.19
943,368.42
7,525,561.42
10,775,006.34
326,274.76
(18,703,736.05)
(393,662,347.97)
(984,043.93)
Total Accrual Basis Earnings $515,362.18
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
10,000,000.00
7,525,561.42
326,274.76
775,006.34
(18,703,736.05)

0.03 0.00
Cash Balance
Closing Cash Balance $1,244,572.97
CITY OF MODESTO - COMBINED PORTFOLIO Page 1
#8..
- 95 -
Portfolio Summary and Statistics For the Month Ending June 30, 2022 CITY OF MODESTO - Combined Portfolio
Account Summary
Description Par Value Market Value Percent
U.S. Treasury Bond / Note 213,536,000.00 201,526,114.80 52.79 Supra-National Agency Bond / Note 5,885,000.00 5,595,032.05 1.47 Municipal Bond / Note 7,590,000.00 7,219,544.85 1.89
Federal Agency Commercial
Mortgage-Backed Security
1,802,289.51 1,795,699.05 0.47
Federal Agency Bond / Note 75,065,000.00 71,831,320.15 18.81 Corporate Note 40,100,000.00 38,883,713.86 10.18
Commercial Paper 40,000,000.00 39,834,690.00 10.43
Certificate of Deposit 8,160,000.00 8,082,322.56 2.12
Asset-Backed Security 7,225,671.77 7,034,193.28 1.84
Managed Account Sub-Total 399,363,961.28 381,802,630.60 100.00% Accrued Interest 943,368.42
Total Portfolio 399,363,961.28 382,745,999.02
Unsettled Trades 0.00 0.00
Sector Allocation

1.84% ABS

2.12%
Cert of Deposit

10.43%
Commercial Paper

10.18%
Corporate Note

18.81%
Fed Agy Bond /
Note

0.47%
Federal Agency
Commercial
Mortgage-Backed
Security

1.89%
Muni Bond / Note

1.47%
Supra-National
Agency Bond / Note 52.79%
US TSY Bond / Note
0 - 6 Months 6 - 12 Months 1 - 2 Years 2 - 3 Years 3 - 4 Years 4 - 5 Years Over 5 Years

11.59%

8.38%

24.90%

20.56%

30.26%

4.31%

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

1.64%

2.96%
CITY OF MODESTO - COMBINED PORTFOLIO Page 2
#8..
- 96 -
Managed Account Issuer Summary For the Month Ending June 30, 2022 CITY OF MODESTO - Combined Portfolio
Credit Quality (S&P Ratings)

0.91%
A

3.66%
A+

1.95%
A12.55%
A-1

2.95%
AA

72.29%
AA+

1.45%
AA3.80%
AAA

0.44%
NR
Issuer Summary
Issuer of Holdings Percent
Market Value
ALLY AUTO RECEIVABLES TRUST 8,277.29 0.00
AMAZON.COM INC 4,911,762.78 1.29
BANK OF AMERICA CO 3,968,495.40 1.04
BARCLAYS PLC 2,708,884.89 0.71
BRISTOL-MYERS SQUIBB CO 2,030,798.56 0.53
CALIFORNIA DEPARTMENT OF WATER RESOURCES 93,422.00 0.02 CALIFORNIA STATE UNIVERSITY 567,150.00 0.15
CAPITAL ONE FINANCIAL CORP 52,203.13 0.01
CARMAX AUTO OWNER TRUST 1,746,698.98 0.46
COLLAT COMM PAPER FLEX CO 9,954,240.00 2.61
CREDIT SUISSE GROUP RK 1,813,982.35 0.48
DISCOVER FINANCIAL SERVICES 725,947.46 0.19
FANNIE MAE 45,262,149.12 11.86
FEDERAL FARM CREDIT BANKS 2,269,634.05 0.59
FEDERAL HOME LOAN BANKS 4,242,433.47 1.11
FLORIDA STATE BOARD OF ADMIN FIN CORP 1,687,140.00 0.44 FREDDIE MAC 21,852,802.56 5.72
HONDA AUTO RECEIVABLES 1,384,918.53 0.36
HYUNDAI AUTO RECEIVABLES 937,563.23 0.25
INTER-AMERICAN DEVELOPMENT BANK 3,871,322.91 1.01
INTL BANK OF RECONSTRUCTION AND DEV 1,723,709.14 0.45
JP MORGAN CHASE & CO 3,481,256.21 0.91
LMA AMERICAS LLC 9,982,410.00 2.61
LOS ANGELES COMMUNITY COLLEGE DISTRICT 856,365.00 0.22
MASTERCARD INC 1,696,812.48 0.44
MICROSOFT CORP 2,890,638.00 0.76
MITSUBISHI UFJ FINANCIAL GROUP INC 9,948,610.00 2.61
NEW JERSEY TURNPIKE AUTHORITY 461,120.55 0.12
NISSAN AUTO RECEIVABLES 287,924.67 0.08
NOVARTIS AG 2,208,210.36 0.58
PACCAR FINANCIAL CORP 1,727,959.94 0.45
PFIZER INC 3,432,057.14 0.90
CITY OF MODESTO - COMBINED PORTFOLIO Page 3
#8..
- 97 -
Managed Account Issuer Summary For the Month Ending June 30, 2022 CITY OF MODESTO - Combined Portfolio
Issuer of Holdings Percent
Market Value
SKANDINAVISKA ENSKILDA BANKEN AB 3,559,455.32 0.93
STARBIRD FUNDING CORP 9,949,430.00 2.61
STATE OF CALIFORNIA 2,286,622.80 0.60
STATE OF MARYLAND 589,372.00 0.15
TARGET CORP 337,945.11 0.09
THE BANK OF NEW YORK MELLON CORPORATION 3,118,368.33 0.82 TOYOTA MOTOR CORP 4,125,046.40 1.08
UNITED STATES TREASURY 201,526,114.80 52.79
UNIVERSITY OF CALIFORNIA 678,352.50 0.18
US BANCORP 2,865,431.14 0.75
WAL-MART STORES INC 3,979,592.00 1.04
Total $381,802,630.60 100.00%
CITY OF MODESTO - COMBINED PORTFOLIO Page 4
#8..
- 98 -
Managed Account Detail of Securities Held For the Month Ending June 30, 2022 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 03/15/2020 0.500% 03/15/2023
912828ZD5 4,315,000.00 AA+ Aaa 04/06/22 04/07/22 4,264,433.59 1.77 6,331.79 4,277,001.27 4,246,904.12

US TREASURY N/B NOTES
DTD 05/31/2021 0.125% 05/31/2023
91282CCD1 4,355,000.00 AA+ Aaa 04/06/22 04/07/22 4,261,945.90 2.02 461.08 4,280,823.22 4,246,805.25

US TREASURY NOTES
DTD 06/30/2016 1.375% 06/30/2023
912828S35 5,100,000.00 AA+ Aaa 01/30/19 01/31/19 4,848,386.72 2.56 190.56 5,043,148.83 5,022,703.38

US TREASURY NOTES
DTD 08/01/2016 1.250% 07/31/2023
912828S92 3,155,000.00 AA+ Aaa 02/08/19 02/12/19 2,997,126.76 2.44 16,450.45 3,116,742.37 3,098,308.44

US TREASURY NOTES
DTD 08/01/2016 1.250% 07/31/2023
912828S92 5,625,000.00 AA+ Aaa 04/02/19 04/04/19 5,386,816.41 2.28 29,329.25 5,565,416.39 5,523,925.50

US TREASURY NOTES
DTD 08/31/2016 1.375% 08/31/2023
9128282D1 1,750,000.00 AA+ Aaa 07/01/19 07/03/19 1,723,886.72 1.75 8,042.63 1,742,681.41 1,717,734.38

US TREASURY NOTES
DTD 09/15/2020 0.125% 09/15/2023
91282CAK7 4,395,000.00 AA+ Aaa 04/06/22 04/07/22 4,264,523.44 2.24 1,612.30 4,285,608.06 4,247,355.25

US TREASURY NOTES
DTD 10/01/2018 2.875% 09/30/2023
9128285D8 2,700,000.00 AA+ Aaa 05/01/19 05/02/19 2,769,820.31 2.26 19,512.30 2,719,750.66 2,696,625.00

US TREASURY NOTES
DTD 11/15/2020 0.250% 11/15/2023
91282CAW1 3,910,000.00 AA+ Aaa 04/29/21 04/30/21 3,909,389.06 0.26 1,248.44 3,909,669.87 3,766,429.49

US TREASURY NOTES
DTD 11/15/2013 2.750% 11/15/2023
912828WE6 8,790,000.00 AA+ Aaa 03/06/19 03/08/19 8,878,930.08 2.52 30,872.49 8,816,061.24 8,761,158.25

US TREASURY NOTES
DTD 11/30/2016 2.125% 11/30/2023
912828U57 3,275,000.00 AA+ Aaa 01/07/19 01/09/19 3,216,408.21 2.52 5,894.55 3,258,039.22 3,236,620.93

US TREASURY NOTES
DTD 12/15/2020 0.125% 12/15/2023
91282CBA8 4,430,000.00 AA+ Aaa 04/06/22 04/07/22 4,263,528.91 2.41 242.08 4,286,462.53 4,250,031.25

US TREASURY NOTES
DTD 12/31/2018 2.625% 12/31/2023
9128285U0 270,000.00 AA+ Aaa 01/30/19 01/31/19 270,801.56 2.56 19.26 270,244.71 268,565.63

US TREASURY NOTES
DTD 02/28/2019 2.375% 02/29/2024
9128286G0 457,000.00 AA+ Aaa 08/11/21 08/12/21 480,671.17 0.33 3,627.75 472,458.72 452,572.81 CITY OF MODESTO - COMBINED PORTFOLIO Page 5
#8..
- 99 -
Managed Account Detail of Securities Held For the Month Ending June 30, 2022 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 02/28/2019 2.375% 02/29/2024
9128286G0 1,564,000.00 AA+ Aaa 08/11/21 08/12/21 1,644,582.66 0.35 12,415.31 1,616,625.41 1,548,848.75

US TREASURY NOTES
DTD 03/15/2021 0.250% 03/15/2024
91282CBR1 4,450,000.00 AA+ Aaa 04/06/22 04/07/22 4,262,960.94 2.49 3,264.95 4,285,416.19 4,247,663.84

US TREASURY N/B NOTES
DTD 04/15/2021 0.375% 04/15/2024
91282CBV2 4,890,000.00 AA+ Aaa 04/29/21 04/30/21 4,893,629.30 0.35 3,857.89 4,892,195.71 4,667,657.57

US TREASURY N/B NOTES
DTD 06/15/2021 0.250% 06/15/2024
91282CCG4 4,485,000.00 AA+ Aaa 04/06/22 04/07/22 4,262,852.34 2.59 490.16 4,286,455.53 4,252,340.63

US TREASURY NOTES
DTD 07/31/2017 2.125% 07/31/2024
9128282N9 2,450,000.00 AA+ Aaa 08/01/19 08/06/19 2,489,142.58 1.79 21,716.68 2,466,357.77 2,406,742.31

US TREASURY NOTES
DTD 08/31/2017 1.875% 08/31/2024
9128282U3 1,630,000.00 AA+ Aaa 09/04/19 09/05/19 1,672,214.45 1.34 10,215.18 1,648,350.08 1,591,287.50

US TREASURY N/B NOTES
DTD 09/15/2021 0.375% 09/15/2024
91282CCX7 4,505,000.00 AA+ Aaa 04/06/22 04/07/22 4,264,440.04 2.65 4,957.95 4,287,363.35 4,250,185.94

US TREASURY NOTES
DTD 10/02/2017 2.125% 09/30/2024
9128282Y5 1,850,000.00 AA+ Aaa 10/01/19 10/03/19 1,905,283.20 1.50 9,881.83 1,874,913.81 1,815,312.50

US TREASURY NOTES
DTD 10/31/2017 2.250% 10/31/2024
9128283D0 460,000.00 AA+ Aaa 11/01/19 11/05/19 475,039.84 1.57 1,743.75 467,041.15 452,093.75

US TREASURY NOTES
DTD 11/30/2017 2.125% 11/30/2024
9128283J7 1,215,000.00 AA+ Aaa 12/02/19 12/04/19 1,239,964.45 1.69 2,186.83 1,227,091.94 1,189,560.94

US TREASURY NOTES
DTD 11/30/2017 2.125% 11/30/2024
9128283J7 3,450,000.00 AA+ Aaa 01/03/20 01/07/20 3,529,916.02 1.63 6,209.53 3,489,444.30 3,377,765.63

US TREASURY NOTES
DTD 11/30/2017 2.125% 11/30/2024
9128283J7 4,585,000.00 AA+ Aaa 04/29/21 04/30/21 4,848,816.60 0.50 8,252.38 4,762,824.47 4,489,001.56

US TREASURY N/B 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 1,943.17 4,268,615.91 4,232,473.44

US TREASURY N/B 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 24,795.58 4,266,894.74 4,228,125.00 CITY OF MODESTO - COMBINED PORTFOLIO Page 6
#8..
- 100 -
Managed Account Detail of Securities Held For the Month Ending June 30, 2022 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 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 3,124.22 4,909,455.69 4,588,032.81

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 316.10 4,231,993.32 4,195,631.25

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 3,626.49 4,302,248.83 3,973,134.59

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 3,873.00 4,288,396.17 4,243,197.89

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 691.26 1,080,546.70 1,004,609.32

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 2,859.29 4,488,787.18 4,155,429.46

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 2,110.19 4,924,361.98 4,564,579.94

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 2,918.89 6,809,740.05 6,313,880.03

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 1,349.90 4,152,180.79 3,881,445.10

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 1,472.18 4,279,029.92 4,233,058.36

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 5.09 499,009.71 455,546.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 10.60 1,037,170.53 947,537.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 38.06 3,669,488.90 3,402,935.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 3,754.14 2,363,796.43 2,181,750.00 CITY OF MODESTO - COMBINED PORTFOLIO Page 7
#8..
- 101 -
Managed Account Detail of Securities Held For the Month Ending June 30, 2022 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 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 7,821.13 4,745,381.80 4,545,312.50

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 9,033.41 5,594,428.02 5,249,835.94

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 12,482.53 7,287,473.96 7,254,318.75

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 26,822.69 3,417,394.58 3,147,806.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 7,762.70 4,282,971.85 4,232,756.25

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 10,027.18 5,859,857.72 5,467,500.00

US TREASURY N/B 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 4,675.41 2,479,202.99 2,277,725.00

US TREASURY N/B 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 9,284.84 4,903,443.38 4,523,304.69

US TREASURY N/B 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 892.52 1,398,637.74 1,285,355.54

US TREASURY N/B 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 2,931.66 4,273,831.03 4,222,004.14

US TREASURY N/B 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 3,049.18 4,405,470.58 4,391,250.24

US TREASURY N/B 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 11,631.52 4,278,305.98 4,222,400.00

US TREASURY N/B 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 9,479.64 3,986,136.22 3,936,241.97

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 11,609.51 4,358,603.70 4,344,735.94 CITY OF MODESTO - COMBINED PORTFOLIO Page 8
#8..
- 102 -
Managed Account Detail of Securities Held For the Month Ending June 30, 2022 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
Security Type Sub-Total 213,536,000.00 207,509,599.38 1.85 389,419.45 208,191,044.61 201,526,114.80 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 459.93 1,788,204.03 1,723,709.14

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 5,573.75 4,092,746.63 3,871,322.91 Security Type Sub-Total 5,885,000.00 5,878,121.20 0.46 6,033.68 5,880,950.66 5,595,032.05 Municipal Bond / Note

CA ST TXBL GO BONDS
DTD 10/24/2019 2.400% 10/01/2023
13063DRJ9 2,310,000.00 AA- Aa2 10/16/19 10/24/19 2,356,223.10 1.87 13,860.00 2,324,689.82 2,286,622.80

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 1,317.50 619,909.21 589,372.00

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 685.00 600,000.00 567,150.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 46.67 100,000.00 93,422.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 248.22 220,468.01 204,435.00

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 575.42 510,000.00 473,917.50

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 3,176.45 507,237.34 473,336.50

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 8,145.55 1,295,000.00 1,213,803.50

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 2,979.27 925,000.00 856,365.00

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 2,643.68 505,000.00 461,120.55 CITY OF MODESTO - COMBINED PORTFOLIO Page 9
#8..
- 103 -
Managed Account Detail of Securities Held For the Month Ending June 30, 2022 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
Municipal Bond / Note
Security Type Sub-Total 7,590,000.00 7,640,416.25 1.22 33,677.76 7,607,304.38 7,219,544.85 Federal Agency Commercial Mortgage-Backed Security

FHLMC MULTIFAMILY STRUCTURED P
DTD 12/01/2012 2.307% 08/01/2022
3137AWQH1 828,673.13 AA+ Aaa 09/04/19 09/09/19 840,909.01 1.78 1,593.12 829,031.99 826,591.56

FANNIEMAE-ACES
DTD 04/01/2014 3.346% 03/01/2024
3136AJB54 924,044.53 AA+ Aaa 12/13/19 12/18/19 968,947.31 2.14 2,576.54 941,859.38 919,656.83 FHMS KJ27 A1
DTD 11/01/2019 2.092% 07/01/2024
3137FQ3V3 49,571.85 AA+ Aaa 11/20/19 11/26/19 49,570.66 2.09 86.42 49,571.33 49,450.66 Security Type Sub-Total 1,802,289.51 1,859,426.98 1.97 4,256.08 1,820,462.70 1,795,699.05 Federal Agency Bond / Note

FANNIE MAE NOTES
DTD 05/22/2020 0.250% 05/22/2023
3135G04Q3 2,915,000.00 AA+ Aaa 05/20/20 05/22/20 2,906,225.85 0.35 789.48 2,912,395.80 2,849,759.39

FREDDIE MAC NOTES
DTD 06/11/2018 2.750% 06/19/2023
3137EAEN5 3,615,000.00 AA+ Aaa 01/07/19 01/09/19 3,640,377.30 2.58 3,313.75 3,620,522.93 3,610,564.40

FREDDIE MAC NOTES
DTD 06/11/2018 2.750% 06/19/2023
3137EAEN5 4,170,000.00 AA+ Aaa 11/01/18 11/05/18 4,114,455.60 3.06 3,822.50 4,158,377.49 4,164,883.41

FREDDIE MAC NOTES
DTD 06/26/2020 0.250% 06/26/2023
3137EAES4 3,315,000.00 AA+ Aaa 06/24/20 06/26/20 3,305,320.20 0.35 115.10 3,311,817.60 3,230,235.45

FANNIE MAE NOTES
DTD 07/10/2020 0.250% 07/10/2023
3135G05G4 3,395,000.00 AA+ Aaa 07/08/20 07/10/20 3,387,700.75 0.32 4,031.56 3,392,506.92 3,303,864.62

FREDDIE MAC NOTES
DTD 08/21/2020 0.250% 08/24/2023
3137EAEV7 2,200,000.00 AA+ Aaa 08/19/20 08/21/20 2,197,756.00 0.28 1,940.28 2,199,143.68 2,133,291.60

FANNIE MAE NOTES
DTD 09/14/2018 2.875% 09/12/2023
3135G0U43 3,745,000.00 AA+ Aaa 11/07/18 11/09/18 3,699,610.60 3.15 32,599.70 3,733,755.34 3,741,296.20

FANNIE MAE NOTES
DTD 09/14/2018 2.875% 09/12/2023
3135G0U43 5,665,000.00 AA+ Aaa 12/03/18 12/06/18 5,653,556.70 2.92 49,313.04 5,662,121.10 5,659,397.31 CITY OF MODESTO - COMBINED PORTFOLIO Page 10
#8..
- 104 -
Managed Account Detail of Securities Held For the Month Ending June 30, 2022 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

FEDERAL FARM CREDIT BANK (CALLABLE)
DTD 09/21/2020 0.250% 09/21/2023
3133EMAM4 2,345,000.00 AA+ Aaa 10/07/20 10/09/20 2,341,013.50 0.31 1,628.47 2,343,345.44 2,269,634.05

FANNIE MAE NOTES
DTD 11/25/2020 0.250% 11/27/2023
3135G06H1 900,000.00 AA+ Aaa 01/25/21 01/26/21 901,368.00 0.20 212.50 900,679.37 866,092.50

FREDDIE MAC NOTES
DTD 12/04/2020 0.250% 12/04/2023
3137EAFA2 2,015,000.00 AA+ Aaa 12/02/20 12/04/20 2,013,005.15 0.28 377.81 2,014,050.85 1,937,785.20

FEDERAL HOME LOAN BANKS NOTES
DTD 12/09/2013 3.375% 12/08/2023
3130A0F70 2,025,000.00 AA+ Aaa 01/30/19 01/31/19 2,084,684.63 2.72 4,366.41 2,042,683.09 2,035,072.35

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 27,489.58 3,566,711.33 3,377,629.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 3,706.67 645,113.58 614,638.08

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 2,534.58 2,363,439.26 2,207,361.12

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 569.01 475,412.83 443,252.90

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 2,288.02 1,915,630.45 1,782,343.24

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 3,827.35 3,191,297.79 2,981,458.98

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 4,007.03 3,346,400.03 3,121,433.58

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 38.89 200,444.54 185,184.00

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 209.03 1,078,179.01 995,364.00

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 231.39 1,194,812.57 1,101,844.80 CITY OF MODESTO - COMBINED PORTFOLIO Page 11
#8..
- 105 -
Managed Account Detail of Securities Held For the Month Ending June 30, 2022 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

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 714.58 3,670,487.37 3,402,756.00

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 742.78 3,830,284.93 3,537,014.40

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 3,700.00 2,213,235.72 2,045,563.50

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 590.62 448,358.51 413,599.95

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 721.87 548,890.20 505,511.05

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 3,097.50 2,353,030.39 2,169,101.96

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 132.71 129,889.53 119,312.70

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 3,470.83 3,393,379.32 3,120,486.00

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 1,530.00 2,039,475.06 1,872,479.28

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 1,661.25 2,209,665.63 2,033,108.63 Security Type Sub-Total 75,065,000.00 75,113,776.28 1.13 163,774.29 75,105,537.66 71,831,320.15 Corporate Note

TOYOTA MOTOR CREDIT CORP CORP
NOTES
DTD 09/20/2018 3.450% 09/20/2023
89236TFN0 2,230,000.00 A+ A1 11/13/18 11/15/18 2,210,175.30 3.65 21,584.54 2,225,004.62 2,234,386.41

US BANK NA CINCINNATI CORP NOTES
(CALLAB
DTD 02/04/2019 3.375% 02/05/2024
91159HHV5 2,860,000.00 A+ A2 07/19/19 07/23/19 2,995,535.40 2.27 39,146.25 2,906,067.04 2,865,431.14 CITY OF MODESTO - COMBINED PORTFOLIO Page 12
#8..
- 106 -
Managed Account Detail of Securities Held For the Month Ending June 30, 2022 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

BANK OF AMERICA CORP NOTE
DTD 03/05/2018 3.550% 03/05/2024
06051GHF9 2,010,000.00 A- A2 09/28/20 09/30/20 2,142,318.30 1.57 22,992.17 2,074,785.24 2,005,598.10

PFIZER INC CORP NOTES
DTD 03/11/2019 2.950% 03/15/2024
717081ES8 3,445,000.00 A+ A2 04/02/19 04/04/19 3,486,374.45 2.69 29,923.65 3,458,822.51 3,432,057.14 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 973.88 1,588,557.60 1,511,555.76

JP MORGAN CHASE BANK CORP NOTE
DTD 05/13/2014 3.625% 05/13/2024
46625HJX9 1,320,000.00 A- A2 09/22/20 09/24/20 1,461,028.80 0.65 6,380.00 1,392,480.51 1,321,907.40

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 54,783.33 4,026,186.39 3,979,592.00

JPMORGAN CHASE & CO CORPORATE

NOTES (CAL
DTD 09/16/2020 0.653% 09/16/2024
46647PBS4 1,405,000.00 A- A2 09/09/20 09/16/20 1,405,000.00 0.65 2,675.94 1,405,000.00 1,350,226.08

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 13,122.50 1,825,949.48 1,727,959.94

NOVARTIS CAPITAL CORP
DTD 02/14/2020 1.750% 02/14/2025
66989HAP3 2,290,000.00 AA- A1 05/07/20 05/11/20 2,378,050.50 0.92 15,250.76 2,337,812.09 2,208,210.36

MASTERCARD INC CORPORATE NOTES
DTD 12/03/2019 2.000% 03/03/2025
57636QAN4 1,760,000.00 A+ A1 05/04/20 05/06/20 1,836,225.60 1.08 11,537.78 1,802,222.58 1,696,812.48 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 22,295.00 3,424,939.40 3,400,207.02

JPMORGAN CHASE & CO CORPORATE
NOTES
DTD 06/01/2021 0.824% 06/01/2025
46647PCH7 865,000.00 A- A2 05/24/21 06/01/21 865,000.00 0.82 593.97 865,000.00 809,122.73

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 2,230.00 2,215,314.75 2,030,798.56 CITY OF MODESTO - COMBINED PORTFOLIO Page 13
#8..
- 107 -
Managed Account Detail of Securities Held For the Month Ending June 30, 2022 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

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 11,044.69 3,465,593.47 3,118,368.33

BANK OF AMERICA CORP NOTES
(CALLABLE)
DTD 03/22/2022 3.384% 04/02/2026
06051GKM0 2,025,000.00 A- A2 03/17/22 03/22/22 2,025,000.00 3.38 18,844.65 2,025,000.00 1,962,897.30

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 28,600.00 3,030,425.34 2,890,638.00

TARGET CORP CORPORATE NOTES
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 3,104.02 364,433.46 337,945.11 Security Type Sub-Total 40,100,000.00 40,855,037.55 1.89 305,083.13 40,433,594.48 38,883,713.86 Commercial Paper

LMA AMERICAS LLC COMM PAPER
DTD 04/19/2022 0.000% 08/01/2022
53944RH19 10,000,000.00 A-1 P-1 05/17/22 05/17/22 9,973,611.11 1.25 0.00 9,989,236.11 9,982,410.00

COLLAT CP FLEX CO LLC COMM PAPER
DTD 05/13/2022 0.000% 09/12/2022
19423KJC9 10,000,000.00 A-1 P-1 05/23/22 05/24/22 9,949,741.67 1.64 0.00 9,966,947.22 9,954,240.00

STARBIRD FUNDING CORP COMM PAPER
DTD 05/16/2022 0.000% 09/19/2022
85520MJK0 10,000,000.00 A-1 P-1 05/23/22 05/24/22 9,947,555.56 1.61 0.00 9,964,444.45 9,949,430.00

MUFG BANK LTD/NY COMM PAPER
DTD 12/28/2021 0.000% 09/23/2022
62479MJP9 10,000,000.00 A-1 P-1 06/16/22 06/16/22 9,941,975.00 2.12 0.00 9,950,766.67 9,948,610.00 Security Type Sub-Total 40,000,000.00 39,812,883.34 1.66 0.00 39,871,394.45 39,834,690.00 Certificate of Deposit

SKANDINAV ENSKILDA BANK LT CD
DTD 09/03/2019 1.860% 08/26/2022
83050PDR7 3,560,000.00 A-1 P-1 08/29/19 09/03/19 3,560,000.00 1.85 22,991.67 3,560,000.00 3,559,455.32

BARCLAYS BANK PLC NY CERT DEPOS
DTD 02/03/2022 1.050% 02/01/2023
06742TG34 2,750,000.00 A-1 P-1 02/02/22 02/03/22 2,750,000.00 1.05 11,870.83 2,750,000.00 2,708,884.89 CITY OF MODESTO - COMBINED PORTFOLIO Page 14
#8..
- 108 -
Managed Account Detail of Securities Held For the Month Ending June 30, 2022 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
Certificate of Deposit

CREDIT SUISSE NEW YORK CERT DEPOS
DTD 03/23/2021 0.590% 03/17/2023
22552G3C2 1,850,000.00 A-1 P-1 03/19/21 03/23/21 1,850,000.00 0.59 3,213.86 1,850,000.00 1,813,982.35 Security Type Sub-Total 8,160,000.00 8,160,000.00 1.30 38,076.36 8,160,000.00 8,082,322.56 Asset-Backed Security
HAROT 2019-2 A3
DTD 05/29/2019 2.520% 06/21/2023
43815MAC0 113,607.92 NR Aaa 05/21/19 05/29/19 113,603.68 2.52 79.53 113,606.91 113,677.88 TAOT 2019-A A3
DTD 02/13/2019 2.910% 07/15/2023
89239AAD5 137,776.09 AAA Aaa 02/05/19 02/13/19 137,750.99 2.91 178.19 137,770.19 137,902.93 ALLYA 2019-1 A3
DTD 02/13/2019 2.910% 09/15/2023
02004WAC5 8,277.43 NR Aaa 02/05/19 02/13/19 8,276.43 2.91 10.71 8,277.17 8,277.29 NAROT 2019-A A3
DTD 02/13/2019 2.900% 10/15/2023
65479KAD2 96,139.90 NR Aaa 02/05/19 02/13/19 96,125.34 2.90 123.91 96,135.88 96,208.01 COPAR 2019-1 A3
DTD 05/30/2019 2.510% 11/15/2023
14042WAC4 52,171.39 AAA Aaa 05/21/19 05/30/19 52,160.82 2.51 58.20 52,168.13 52,203.13 NAROT 2019-B A3
DTD 05/28/2019 2.500% 11/15/2023
65479HAC1 191,729.35 NR Aaa 05/21/19 05/28/19 191,686.00 2.51 213.03 191,716.02 191,716.66 CARMX 2019-2 A3
DTD 04/17/2019 2.680% 03/15/2024
14316LAC7 148,882.33 AAA NR 04/09/19 04/17/19 148,867.12 2.68 177.34 148,877.05 148,977.64 HAROT 2020-1 A3
DTD 02/26/2020 1.610% 04/22/2024
43813RAC1 640,053.81 NR Aaa 02/19/20 02/26/20 639,928.35 1.61 286.25 639,999.14 636,482.82 TAOT 2020-A A3
DTD 02/12/2020 1.660% 05/15/2024
89232HAC9 823,930.03 AAA Aaa 02/04/20 02/12/20 823,870.54 1.66 607.88 823,903.85 819,359.20 CARMX 2020-1 A3
DTD 01/22/2020 1.890% 12/16/2024
14315XAC2 478,103.52 AAA NR 01/14/20 01/22/20 478,009.72 1.89 401.61 478,056.41 474,931.97 HAROT 2021-1 A3
DTD 02/24/2021 0.270% 04/21/2025
43813GAC5 650,000.00 NR Aaa 02/17/21 02/24/21 649,988.11 0.27 48.75 649,991.97 634,757.83 HART 2021-A A3
DTD 04/28/2021 0.380% 09/15/2025
44933LAC7 510,000.00 AAA NR 04/20/21 04/28/21 509,946.35 0.38 86.13 509,960.73 493,946.12 CITY OF MODESTO - COMBINED PORTFOLIO Page 15
#8..
- 109 -
Managed Account Detail of Securities Held For the Month Ending June 30, 2022 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-1 A3
DTD 01/27/2021 0.340% 12/15/2025
14316NAC3 385,000.00 AAA NR 01/20/21 01/27/21 384,923.92 0.34 58.18 384,946.11 375,299.93 TAOT 2021-C A3
DTD 09/27/2021 0.430% 01/15/2026
89239BAC5 980,000.00 AAA Aaa 09/21/21 09/27/21 979,921.89 0.43 187.29 979,935.66 933,397.86 CARMX 2021-2 A3
DTD 04/21/2021 0.520% 02/17/2026
14314QAC8 770,000.00 AAA NR 04/13/21 04/21/21 769,834.07 0.52 177.96 769,875.11 747,489.44 HART 2021-C A3
DTD 11/17/2021 0.740% 05/15/2026
44935FAD6 465,000.00 AAA NR 11/09/21 11/17/21 464,896.21 0.75 152.93 464,910.51 443,617.11 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,859.41 725,947.46 Security Type Sub-Total 7,225,671.77 7,224,623.61 1.04 3,047.67 7,224,990.25 7,034,193.28 Managed Account Sub-Total 399,363,961.28 394,053,884.59 1.64 943,368.42 394,295,279.19 381,802,630.60 $399,363,961.28 $394,053,884.59 1.64% $943,368.42 $394,295,279.19 $381,802,630.60 $382,745,999.02
$943,368.42
Total Investments
Accrued Interest
Securities Sub-Total
CITY OF MODESTO - COMBINED PORTFOLIO Page 16
#8..
- 110 -
Managed Account Fair Market Value & Analytics For the Month Ending June 30, 2022 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 912828ZD5 4,315,000.00 CITIGRP 98.42 4,246,904.12 (17,529.47) (30,097.15) DTD 03/15/2020 0.500% 03/15/2023

0.71 2.76
US TREASURY N/B NOTES 91282CCD1 4,355,000.00 WELLS_F 97.52 4,246,805.25 (15,140.65) (34,017.97) DTD 05/31/2021 0.125% 05/31/2023

0.92 2.89
US TREASURY NOTES 912828S35 5,100,000.00 MERRILL 98.48 5,022,703.38 174,316.66 (20,445.45) DTD 06/30/2016 1.375% 06/30/2023

1.00 2.92
US TREASURY NOTES 912828S92 3,155,000.00 RBC 98.20 3,098,308.44 101,181.68 (18,433.93) DTD 08/01/2016 1.250% 07/31/2023

1.08 2.94
US TREASURY NOTES 912828S92 5,625,000.00 NOMURA 98.20 5,523,925.50 137,109.09 (41,490.89) DTD 08/01/2016 1.250% 07/31/2023

1.08 2.94
US TREASURY NOTES 9128282D1 1,750,000.00 RBS 98.16 1,717,734.38 (6,152.34) (24,947.03) DTD 08/31/2016 1.375% 08/31/2023

1.16 2.99
US TREASURY NOTES 91282CAK7 4,395,000.00 NOMURA 96.64 4,247,355.25 (17,168.19) (38,252.81) DTD 09/15/2020 0.125% 09/15/2023

1.21 2.97
US TREASURY NOTES 9128285D8 2,700,000.00 TD 99.88 2,696,625.00 (73,195.31) (23,125.66) DTD 10/01/2018 2.875% 09/30/2023

1.23 2.98
US TREASURY NOTES 91282CAW1 3,910,000.00 MERRILL 96.33 3,766,429.49 (142,959.57) (143,240.38) DTD 11/15/2020 0.250% 11/15/2023

1.37 3.00
US TREASURY NOTES 912828WE6 8,790,000.00 TD 99.67 8,761,158.25 (117,771.83) (54,902.99) DTD 11/15/2013 2.750% 11/15/2023

1.36 2.99
US TREASURY NOTES 912828U57 3,275,000.00 BNP_PARI 98.83 3,236,620.93 20,212.72 (21,418.29) DTD 11/30/2016 2.125% 11/30/2023

1.40 2.97
US TREASURY NOTES 91282CBA8 4,430,000.00 NOMURA 95.94 4,250,031.25 (13,497.66) (36,431.28) DTD 12/15/2020 0.125% 12/15/2023

1.46 2.99
US TREASURY NOTES 9128285U0 270,000.00 MERRILL 99.47 268,565.63 (2,235.93) (1,679.08) DTD 12/31/2018 2.625% 12/31/2023

1.48 2.99
US TREASURY NOTES 9128286G0 457,000.00 WELLS_F 99.03 452,572.81 (28,098.36) (19,885.91) DTD 02/28/2019 2.375% 02/29/2024

1.63 2.97
US TREASURY NOTES 9128286G0 1,564,000.00 WELLS_F 99.03 1,548,848.75 (95,733.91) (67,776.66) DTD 02/28/2019 2.375% 02/29/2024

1.63 2.97
US TREASURY NOTES 91282CBR1 4,450,000.00 RBS 95.45 4,247,663.84 (15,297.10) (37,752.35) DTD 03/15/2021 0.250% 03/15/2024

1.71 3.00
US TREASURY N/B NOTES 91282CBV2 4,890,000.00 BARCLAY 95.45 4,667,657.57 (225,971.73) (224,538.14) DTD 04/15/2021 0.375% 04/15/2024

1.79 3.00
CITY OF MODESTO - COMBINED PORTFOLIO Page 17
#8..
- 111 -
Managed Account Fair Market Value & Analytics For the Month Ending June 30, 2022 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 N/B NOTES 91282CCG4 4,485,000.00 NOMURA 94.81 4,252,340.63 (10,511.71) (34,114.90) DTD 06/15/2021 0.250% 06/15/2024

1.95 3.00
US TREASURY NOTES 9128282N9 2,450,000.00 TD 98.23 2,406,742.31 (82,400.27) (59,615.46) DTD 07/31/2017 2.125% 07/31/2024

2.03 3.00
US TREASURY NOTES 9128282U3 1,630,000.00 MERRILL 97.63 1,591,287.50 (80,926.95) (57,062.58) DTD 08/31/2017 1.875% 08/31/2024

2.12 3.01
US TREASURY N/B NOTES 91282CCX7 4,505,000.00 BARCLAY 94.34 4,250,185.94 (14,254.10) (37,177.41) DTD 09/15/2021 0.375% 09/15/2024

2.20 3.04
US TREASURY NOTES 9128282Y5 1,850,000.00 HSBC 98.13 1,815,312.50 (89,970.70) (59,601.31) DTD 10/02/2017 2.125% 09/30/2024

2.20 2.99
US TREASURY NOTES 9128283D0 460,000.00 MORGAN_S 98.28 452,093.75 (22,946.09) (14,947.40) DTD 10/31/2017 2.250% 10/31/2024

2.28 3.02
US TREASURY NOTES 9128283J7 1,215,000.00 NOMURA 97.91 1,189,560.94 (50,403.51) (37,531.00) DTD 11/30/2017 2.125% 11/30/2024

2.37 3.03
US TREASURY NOTES 9128283J7 3,450,000.00 RBS 97.91 3,377,765.63 (152,150.39) (111,678.67) DTD 11/30/2017 2.125% 11/30/2024

2.37 3.03
US TREASURY NOTES 9128283J7 4,585,000.00 HSBC 97.91 4,489,001.56 (359,815.04) (273,822.91) DTD 11/30/2017 2.125% 11/30/2024

2.37 3.03
US TREASURY N/B NOTES 91282CDN8 4,445,000.00 BNP_PAR 95.22 4,232,473.44 (19,446.87) (36,142.47) DTD 12/15/2021 1.000% 12/15/2024

2.43 3.03
US TREASURY N/B NOTES 91282CDZ1 4,400,000.00 RBS 96.09 4,228,125.00 (26,984.38) (38,769.74) DTD 02/15/2022 1.500% 02/15/2025

2.57 3.06
US TREASURY NOTES 912828ZL7 4,945,000.00 JPM_CHA 92.78 4,588,032.81 (306,744.53) (321,422.88) DTD 04/30/2020 0.375% 04/30/2025

2.82 3.05
US TREASURY NOTES 912828XZ8 4,230,000.00 BARCLAY 99.19 4,195,631.25 (36,516.80) (36,362.07) DTD 07/02/2018 2.750% 06/30/2025

2.90 3.04
US TREASURY NOTES 91282CAJ0 4,340,000.00 WELLS_F 91.55 3,973,134.59 (318,379.47) (329,114.24) DTD 08/31/2020 0.250% 08/31/2025

3.15 3.07
US TREASURY NOTES 91282CAJ0 4,635,000.00 BNP_PAR 91.55 4,243,197.89 (19,734.73) (45,198.28) DTD 08/31/2020 0.250% 08/31/2025

3.15 3.07
US TREASURY NOTES 91282CAM3 1,100,000.00 BNP_PAR 91.33 1,004,609.32 (71,414.12) (75,937.38) DTD 09/30/2020 0.250% 09/30/2025

3.24 3.07
US TREASURY NOTES 91282CAM3 4,550,000.00 HSBC 91.33 4,155,429.46 (318,144.76) (333,357.72) DTD 09/30/2020 0.250% 09/30/2025

3.24 3.07
CITY OF MODESTO - COMBINED PORTFOLIO Page 18
#8..
- 112 -
Managed Account Fair Market Value & Analytics For the Month Ending June 30, 2022 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 91282CAT8 5,010,000.00 HSBC 91.11 4,564,579.94 (329,759.51) (359,782.04) DTD 10/31/2020 0.250% 10/31/2025

3.32 3.08
US TREASURY NOTES 91282CAT8 6,930,000.00 TD 91.11 6,313,880.03 (469,398.88) (495,860.02) DTD 10/31/2020 0.250% 10/31/2025

3.32 3.08
US TREASURY NOTES 91282CAZ4 4,250,000.00 WELLS_F 91.33 3,881,445.10 (251,845.92) (270,735.69) DTD 11/30/2020 0.375% 11/30/2025

3.40 3.07
US TREASURY NOTES 91282CAZ4 4,635,000.00 WELLS_F 91.33 4,233,058.36 (21,726.80) (45,971.56) DTD 11/30/2020 0.375% 11/30/2025

3.40 3.07
US TREASURY NOTES 91282CBC4 500,000.00 HSBC 91.11 455,546.90 (43,066.38) (43,462.81) DTD 12/31/2020 0.375% 12/31/2025

3.48 3.07
US TREASURY NOTES 91282CBC4 1,040,000.00 CITIGRP 91.11 947,537.55 (88,440.58) (89,632.98) DTD 12/31/2020 0.375% 12/31/2025

3.48 3.07
US TREASURY NOTES 91282CBC4 3,735,000.00 JPM_CHA 91.11 3,402,935.35 (243,504.30) (266,553.55) DTD 12/31/2020 0.375% 12/31/2025

3.48 3.07
US TREASURY NOTES 91282CBH3 2,400,000.00 BNP_PAR 90.91 2,181,750.00 (172,125.00) (182,046.43) DTD 01/31/2021 0.375% 01/31/2026

3.56 3.07
US TREASURY NOTES 91282CBH3 5,000,000.00 NOMURA 90.91 4,545,312.50 (174,218.75) (200,069.30) DTD 01/31/2021 0.375% 01/31/2026

3.56 3.07
US TREASURY NOTES 91282CBH3 5,775,000.00 MORGAN_ 90.91 5,249,835.94 (320,332.03) (344,592.08) DTD 01/31/2021 0.375% 01/31/2026

3.56 3.07
US TREASURY NOTES 91282CBH3 7,980,000.00 JPM_CHA 90.91 7,254,318.75 (2,493.75) (33,155.21) DTD 01/31/2021 0.375% 01/31/2026

3.56 3.07
US TREASURY NOTES 9128286F2 3,210,000.00 GOLDMAN 98.06 3,147,806.25 (345,075.00) (269,588.33) DTD 02/28/2019 2.500% 02/28/2026

3.50 3.06
US TREASURY NOTES 91282CBQ3 4,645,000.00 NOMURA 91.13 4,232,756.25 (27,216.80) (50,215.60) DTD 02/28/2021 0.500% 02/28/2026

3.63 3.08
US TREASURY NOTES 91282CBQ3 6,000,000.00 WELLS_F 91.13 5,467,500.00 (370,781.25) (392,357.72) DTD 02/28/2021 0.500% 02/28/2026

3.63 3.08
US TREASURY N/B NOTES 91282CBT7 2,480,000.00 WELLS_F 91.84 2,277,725.00 (201,306.25) (201,477.99) DTD 03/31/2021 0.750% 03/31/2026

3.70 3.07
US TREASURY N/B NOTES 91282CBT7 4,925,000.00 MORGAN_ 91.84 4,523,304.69 (373,415.04) (380,138.69) DTD 03/31/2021 0.750% 03/31/2026

3.70 3.07
US TREASURY N/B NOTES 91282CCF6 1,405,000.00 MERRILL 91.48 1,285,355.54 (111,631.57) (113,282.20) DTD 05/31/2021 0.750% 05/31/2026

3.86 3.07
CITY OF MODESTO - COMBINED PORTFOLIO Page 19
#8..
- 113 -
Managed Account Fair Market Value & Analytics For the Month Ending June 30, 2022 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 N/B NOTES 91282CCF6 4,615,000.00 NOMURA 91.48 4,222,004.14 (31,547.62) (51,826.89) DTD 05/31/2021 0.750% 05/31/2026

3.86 3.07
US TREASURY N/B NOTES 91282CCF6 4,800,000.00 CITIGRP 91.48 4,391,250.24 (7,874.76) (14,220.34) DTD 05/31/2021 0.750% 05/31/2026

3.86 3.07
US TREASURY N/B NOTES 91282CCW9 4,640,000.00 RBC 91.00 4,222,400.00 (35,706.25) (55,905.98) DTD 08/31/2021 0.750% 08/31/2026

4.10 3.07
US TREASURY N/B NOTES 91282CCZ2 4,310,000.00 RBC 91.33 3,936,241.97 (32,156.86) (49,894.25) DTD 09/30/2021 0.875% 09/30/2026

4.17 3.07
US TREASURY NOTES 912828U24 4,545,000.00 RBC 95.59 4,344,735.94 (11,184.96) (13,867.76) DTD 11/15/2016 2.000% 11/15/2026

4.20 3.08
Security Type Sub-Total 213,536,000.00 201,526,114.80 (5,983,484.58) (6,664,929.81) 2.63 3.03 Supra-National Agency Bond / Note
INTL BK RECON & DEVELOP NOTES 459058JM6 1,790,000.00 TD 96.30 1,723,709.14 (62,442.36) (64,494.89) DTD 11/24/2020 0.250% 11/24/2023

1.40 2.97
INTER-AMERICAN DEVEL BK NOTES 4581X0DZ8 4,095,000.00 JPM_CHA 94.54 3,871,322.91 (220,646.79) (221,423.72) DTD 09/23/2021 0.500% 09/23/2024

2.22 3.05
Security Type Sub-Total 5,885,000.00 5,595,032.05 (283,089.15) (285,918.61) 1.97 3.03 Municipal Bond / Note
CA ST TXBL GO BONDS 13063DRJ9 2,310,000.00 MORGAN_S 98.99 2,286,622.80 (69,600.30) (38,067.02) DTD 10/24/2019 2.400% 10/01/2023

1.23 3.23
MD ST TXBL GO BONDS 574193TQ1 620,000.00 JPM_CHA 95.06 589,372.00 (30,454.40) (30,537.21) DTD 08/05/2020 0.510% 08/01/2024

2.07 2.97
CA ST UNIV TXBL REV BONDS 13077DMK5 600,000.00 GOLDMAN 94.53 567,150.00 (32,850.00) (32,850.00) DTD 09/17/2020 0.685% 11/01/2024

2.32 3.13
CA ST DEPT WTR RES WTR SYS TXBL REV 13067WRB0 100,000.00 MORGAN_ 93.42 93,422.00 (6,578.00) (6,578.00) BNDS
DTD 08/06/2020 0.560% 12/01/2024

2.41 3.42
UNIV OF CAL TXBL REV BONDS 91412HGE7 220,000.00 JPM_CHA 04/15/25 92.93 204,435.00 (16,361.40) (16,033.01) DTD 07/16/2020 0.883% 05/15/2025

2.76 3.49
CITY OF MODESTO - COMBINED PORTFOLIO Page 20
#8..
- 114 -
Managed Account Fair Market Value & Analytics For the Month Ending June 30, 2022 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
UNIV OF CAL TXBL REV BONDS 91412HGE7 510,000.00 JPM_CHA 04/15/25 92.93 473,917.50 (36,082.50) (36,082.50) DTD 07/16/2020 0.883% 05/15/2025

2.76 3.49
FL ST BOARD OF ADMIN TXBL REV BONDS 341271AD6 505,000.00 MERRILL 93.73 473,336.50 (35,233.85) (33,900.84) DTD 09/16/2020 1.258% 07/01/2025

2.94 3.47
FL ST BOARD OF ADMIN TXBL REV BONDS 341271AD6 1,295,000.00 MERRILL 93.73 1,213,803.50 (81,196.50) (81,196.50) DTD 09/16/2020 1.258% 07/01/2025

2.94 3.47
LOS ANGELES CCD, CA TXBL GO BONDS 54438CYK2 925,000.00 MERRILL 92.58 856,365.00 (68,635.00) (68,635.00) DTD 11/10/2020 0.773% 08/01/2025

3.04 3.32
NJ TURNPIKE AUTHORITY TXBL REV 646140DP5 505,000.00 CITIGRP 91.31 461,120.55 (43,879.45) (43,879.45) BONDS
DTD 02/04/2021 1.047% 01/01/2026

3.43 3.72
Security Type Sub-Total 7,590,000.00 7,219,544.85 (420,871.40) (387,759.53) 2.30 3.33 Federal Agency Commercial Mortgage-Backed Security
FHLMC MULTIFAMILY STRUCTURED P 3137AWQH1 828,673.13 CANT_FIT 99.75 826,591.56 (14,317.45) (2,440.43) DTD 12/01/2012 2.307% 08/01/2022

0.09 5.24
FANNIEMAE-ACES 3136AJB54 924,044.53 JPM_CHAS 99.53 919,656.83 (49,290.48) (22,202.55) DTD 04/01/2014 3.346% 03/01/2024

1.56 3.64
FHMS KJ27 A1 3137FQ3V3 49,571.85 JPM_CHAS 99.76 49,450.66 (120.00) (120.67) DTD 11/01/2019 2.092% 07/01/2024

1.06 2.22
Security Type Sub-Total 1,802,289.51 1,795,699.05 (63,727.93) (24,763.65) 0.87 4.34 Federal Agency Bond / Note
FANNIE MAE NOTES 3135G04Q3 2,915,000.00 CITIGRP 97.76 2,849,759.39 (56,466.46) (62,636.41) DTD 05/22/2020 0.250% 05/22/2023

0.89 2.80
FREDDIE MAC NOTES 3137EAEN5 3,615,000.00 MORGAN_S 99.88 3,610,564.40 (29,812.90) (9,958.53) DTD 06/11/2018 2.750% 06/19/2023

0.96 2.88
FREDDIE MAC NOTES 3137EAEN5 4,170,000.00 CITIGRP 99.88 4,164,883.41 50,427.81 6,505.92 DTD 06/11/2018 2.750% 06/19/2023

0.96 2.88
FREDDIE MAC NOTES 3137EAES4 3,315,000.00 TD 97.44 3,230,235.45 (75,084.75) (81,582.15) DTD 06/26/2020 0.250% 06/26/2023

0.99 2.89
CITY OF MODESTO - COMBINED PORTFOLIO Page 21
#8..
- 115 -
Managed Account Fair Market Value & Analytics For the Month Ending June 30, 2022 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 3135G05G4 3,395,000.00 CITIGRP 97.32 3,303,864.62 (83,836.13) (88,642.30) DTD 07/10/2020 0.250% 07/10/2023

1.03 2.92
FREDDIE MAC NOTES 3137EAEV7 2,200,000.00 CITIGRP 96.97 2,133,291.60 (64,464.40) (65,852.08) DTD 08/21/2020 0.250% 08/24/2023

1.15 2.95
FANNIE MAE NOTES 3135G0U43 3,745,000.00 JPM_CHAS 99.90 3,741,296.20 41,685.60 7,540.86 DTD 09/14/2018 2.875% 09/12/2023

1.18 2.96
FANNIE MAE NOTES 3135G0U43 5,665,000.00 TD 99.90 5,659,397.31 5,840.61 (2,723.79) DTD 09/14/2018 2.875% 09/12/2023

1.18 2.96
FEDERAL FARM CREDIT BANK (CALLABLE) 3133EMAM4 2,345,000.00 TD 09/21/22 96.79 2,269,634.05 (71,379.45) (73,711.39) DTD 09/21/2020 0.250% 09/21/2023

0.23 2.94
FANNIE MAE NOTES 3135G06H1 900,000.00 MORGAN_ 96.23 866,092.50 (35,275.50) (34,586.87) DTD 11/25/2020 0.250% 11/27/2023

1.41 3.00
FREDDIE MAC NOTES 3137EAFA2 2,015,000.00 CITIGRP 96.17 1,937,785.20 (75,219.95) (76,265.65) DTD 12/04/2020 0.250% 12/04/2023

1.43 3.01
FEDERAL HOME LOAN BANKS NOTES 3130A0F70 2,025,000.00 BARCLAYS 100.50 2,035,072.35 (49,612.28) (7,610.74) DTD 12/09/2013 3.375% 12/08/2023

1.41 3.02
FANNIE MAE NOTES 3135G0X24 3,500,000.00 CITIGRP 96.50 3,377,629.50 (250,505.50) (189,081.83) DTD 01/10/2020 1.625% 01/07/2025

2.46 3.08
FREDDIE MAC NOTES 3137EAEP0 640,000.00 WELLS_FA 96.04 614,638.08 (35,038.72) (30,475.50) DTD 02/14/2020 1.500% 02/12/2025

2.56 3.09
FEDERAL HOME LOAN BANK NOTES 3130AJHU6 2,370,000.00 CITIGRP 93.14 2,207,361.12 (150,883.68) (156,078.14) DTD 04/16/2020 0.500% 04/14/2025

2.77 3.09
FANNIE MAE NOTES 3135G03U5 475,000.00 WELLS_F 93.32 443,252.90 (32,478.60) (32,159.93) DTD 04/24/2020 0.625% 04/22/2025

2.79 3.13
FANNIE MAE NOTES 3135G03U5 1,910,000.00 HSBC 93.32 1,782,343.24 (137,435.96) (133,287.21) DTD 04/24/2020 0.625% 04/22/2025

2.79 3.13
FANNIE MAE NOTES 3135G03U5 3,195,000.00 CITIGRP 93.32 2,981,458.98 (206,959.32) (209,838.81) DTD 04/24/2020 0.625% 04/22/2025

2.79 3.13
FANNIE MAE NOTES 3135G03U5 3,345,000.00 WELLS_F 93.32 3,121,433.58 (226,041.72) (224,966.45) DTD 04/24/2020 0.625% 04/22/2025

2.79 3.13
FANNIE MAE NOTES 3135G04Z3 200,000.00 WELLS_F 92.59 185,184.00 (15,528.00) (15,260.54) DTD 06/19/2020 0.500% 06/17/2025

2.94 3.14
FANNIE MAE NOTES 3135G04Z3 1,075,000.00 NOMURA 92.59 995,364.00 (84,677.75) (82,815.01) DTD 06/19/2020 0.500% 06/17/2025

2.94 3.14
CITY OF MODESTO - COMBINED PORTFOLIO Page 22
#8..
- 116 -
Managed Account Fair Market Value & Analytics For the Month Ending June 30, 2022 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 1,190,000.00 RBS 92.59 1,101,844.80 (95,378.50) (92,967.77) DTD 06/19/2020 0.500% 06/17/2025

2.94 3.14
FANNIE MAE NOTES 3135G04Z3 3,675,000.00 NOMURA 92.59 3,402,756.00 (264,636.75) (267,731.37) DTD 06/19/2020 0.500% 06/17/2025

2.94 3.14
FANNIE MAE NOTES 3135G04Z3 3,820,000.00 RBS 92.59 3,537,014.40 (299,297.00) (293,270.53) DTD 06/19/2020 0.500% 06/17/2025

2.94 3.14
FREDDIE MAC NOTES 3137EAEU9 2,220,000.00 WELLS_F 92.14 2,045,563.50 (163,380.90) (167,672.22) DTD 07/23/2020 0.375% 07/21/2025

3.04 3.09
FANNIE MAE NOTES 3135G05X7 450,000.00 NOMURA 91.91 413,599.95 (33,880.05) (34,758.56) DTD 08/27/2020 0.375% 08/25/2025

3.13 3.09
FANNIE MAE NOTES 3135G05X7 550,000.00 CITIGRP 91.91 505,511.05 (42,778.45) (43,379.15) DTD 08/27/2020 0.375% 08/25/2025

3.13 3.09
FANNIE MAE NOTES 3135G05X7 2,360,000.00 BARCLAY 91.91 2,169,101.96 (179,853.24) (183,928.43) DTD 08/27/2020 0.375% 08/25/2025

3.13 3.09
FREDDIE MAC NOTES 3137EAEX3 130,000.00 WELLS_F 91.78 119,312.70 (10,517.00) (10,576.83) DTD 09/25/2020 0.375% 09/23/2025

3.21 3.07
FREDDIE MAC NOTES 3137EAEX3 3,400,000.00 CITIGRP 91.78 3,120,486.00 (269,280.00) (272,893.32) DTD 09/25/2020 0.375% 09/23/2025

3.21 3.07
FANNIE MAE NOTES 3135G06G3 2,040,000.00 NOMURA 91.79 1,872,479.28 (166,745.52) (166,995.78) DTD 11/12/2020 0.500% 11/07/2025

3.32 3.10
FANNIE MAE NOTES 3135G06G3 2,215,000.00 BARCLAY 91.79 2,033,108.63 (173,961.67) (176,557.00) DTD 11/12/2020 0.500% 11/07/2025

3.32 3.10
Security Type Sub-Total 75,065,000.00 71,831,320.15 (3,282,456.13) (3,274,217.51) 1.99 3.02 Corporate Note
TOYOTA MOTOR CREDIT CORP CORP 89236TFN0 2,230,000.00 JPM_CHAS 100.20 2,234,386.41 24,211.11 9,381.79 NOTES
DTD 09/20/2018 3.450% 09/20/2023

1.20 3.28
US BANK NA CINCINNATI CORP NOTES 91159HHV5 2,860,000.00 GOLDMAN 01/05/24 100.19 2,865,431.14 (130,104.26) (40,635.90) (CALLAB
DTD 02/04/2019 3.375% 02/05/2024

1.47 3.25
BANK OF AMERICA CORP NOTE 06051GHF9 2,010,000.00 MERRILL 99.78 2,005,598.10 (136,720.20) (69,187.14) DTD 03/05/2018 3.550% 03/05/2024

1.63 3.68
CITY OF MODESTO - COMBINED PORTFOLIO Page 23
#8..
- 117 -
Managed Account Fair Market Value & Analytics For the Month Ending June 30, 2022 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
PFIZER INC CORP NOTES 717081ES8 3,445,000.00 BONY 02/15/24 99.62 3,432,057.14 (54,317.31) (26,765.37) DTD 03/11/2019 2.950% 03/15/2024

1.58 3.18
AMAZON.COM INC CORPORATE NOTES 023135BW5 1,590,000.00 JPM_CHA 95.07 1,511,555.76 (76,122.84) (77,001.84) DTD 05/12/2021 0.450% 05/12/2024

1.86 3.19
JP MORGAN CHASE BANK CORP NOTE 46625HJX9 1,320,000.00 JPM_CHA 100.14 1,321,907.40 (139,121.40) (70,573.11) DTD 05/13/2014 3.625% 05/13/2024

1.82 3.54
WALMART INC CORPORATE NOTES 931142EL3 4,000,000.00 CITIGRP 04/15/23 99.49 3,979,592.00 (145,248.00) (46,594.39) DTD 04/23/2019 2.850% 07/08/2024

0.78 3.11
JPMORGAN CHASE & CO CORPORATE 46647PBS4 1,405,000.00 JPM_CHA 09/16/23 96.10 1,350,226.08 (54,773.92) (54,773.92)

NOTES (CAL
DTD 09/16/2020 0.653% 09/16/2024

1.21 2.48
PACCAR FINANCIAL CORP CORPORATE 69371RQ66 1,810,000.00 MITSU 95.47 1,727,959.94 (111,054.36) (97,989.54) NOTES
DTD 02/06/2020 1.800% 02/06/2025

2.53 3.64
NOVARTIS CAPITAL CORP 66989HAP3 2,290,000.00 CITIGRP 01/14/25 96.43 2,208,210.36 (169,840.14) (129,601.73) DTD 02/14/2020 1.750% 02/14/2025

2.48 3.18
MASTERCARD INC CORPORATE NOTES 57636QAN4 1,760,000.00 JSEB 96.41 1,696,812.48 (139,413.12) (105,410.10) DTD 12/03/2019 2.000% 03/03/2025

2.60 3.42
AMAZON.COM INC CORPORATE NOTES 023135CE4 3,430,000.00 JPM_CHA 99.13 3,400,207.02 (24,339.28) (24,732.38) DTD 04/13/2022 3.000% 04/13/2025

2.68 3.33
JPMORGAN CHASE & CO CORPORATE 46647PCH7 865,000.00 JPM_CHA 93.54 809,122.73 (55,877.27) (55,877.27) NOTES
DTD 06/01/2021 0.824% 06/01/2025

2.89 3.16
BRISTOL-MYERS SQUIBB CO CORPORATE 110122DN5 2,230,000.00 MERRILL 10/13/25 91.07 2,030,798.56 (180,090.34) (184,516.19) NOTES
DTD 11/13/2020 0.750% 11/13/2025

3.25 3.59
BANK OF NY MELLON CORP (CALLABLE) 06406RAQ0 3,465,000.00 US_BANC 12/28/25 90.00 3,118,368.33 (347,463.27) (347,225.14) CORPOR
DTD 01/28/2021 0.750% 01/28/2026

3.44 3.76
BANK OF AMERICA CORP NOTES 06051GKM0 2,025,000.00 MERRILL 96.93 1,962,897.30 (62,102.70) (62,102.70) (CALLABLE)
DTD 03/22/2022 3.384% 04/02/2026

3.52 4.27
MICROSOFT CORP (CALLABLE) NOTES 594918BR4 3,000,000.00 TD 05/08/26 96.35 2,890,638.00 (142,512.00) (139,787.34) DTD 08/08/2016 2.400% 08/08/2026

3.67 3.36
CITY OF MODESTO - COMBINED PORTFOLIO Page 24
#8..
- 118 -
Managed Account Fair Market Value & Analytics For the Month Ending June 30, 2022 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
TARGET CORP CORPORATE NOTES 87612EBM7 365,000.00 CITIGRP 92.59 337,945.11 (26,434.39) (26,488.35) DTD 01/24/2022 1.950% 01/15/2027

4.32 3.74
Security Type Sub-Total 40,100,000.00 38,883,713.86 (1,971,323.69) (1,549,880.62) 2.25 3.38 Commercial Paper
LMA AMERICAS LLC COMM PAPER 53944RH19 10,000,000.00 GOLDMAN 99.82 9,982,410.00 8,798.89 (6,826.11) DTD 04/19/2022 0.000% 08/01/2022

0.09 1.98
COLLAT CP FLEX CO LLC COMM PAPER 19423KJC9 10,000,000.00 RBC 99.54 9,954,240.00 4,498.33 (12,707.22) DTD 05/13/2022 0.000% 09/12/2022

0.21 2.24
STARBIRD FUNDING CORP COMM PAPER 85520MJK0 10,000,000.00 CSFB 99.49 9,949,430.00 1,874.44 (15,014.45) DTD 05/16/2022 0.000% 09/19/2022

0.23 2.26
MUFG BANK LTD/NY COMM PAPER 62479MJP9 10,000,000.00 MITSU 99.49 9,948,610.00 6,635.00 (2,156.67) DTD 12/28/2021 0.000% 09/23/2022

0.24 2.19
Security Type Sub-Total 40,000,000.00 39,834,690.00 21,806.66 (36,704.45) 0.19 2.17 Certificate of Deposit
SKANDINAV ENSKILDA BANK LT CD 83050PDR7 3,560,000.00 BARCLAYS 99.98 3,559,455.32 (544.68) (544.68) DTD 09/03/2019 1.860% 08/26/2022

0.16 1.91
BARCLAYS BANK PLC NY CERT DEPOS 06742TG34 2,750,000.00 BARCLAY 98.50 2,708,884.89 (41,115.11) (41,115.11) DTD 02/03/2022 1.050% 02/01/2023

0.61 3.58
CREDIT SUISSE NEW YORK CERT DEPOS 22552G3C2 1,850,000.00 CSFB 98.05 1,813,982.35 (36,017.65) (36,017.65) DTD 03/23/2021 0.590% 03/17/2023

0.73 3.33
Security Type Sub-Total 8,160,000.00 8,082,322.56 (77,677.44) (77,677.44) 0.44 2.79 Asset-Backed Security
HAROT 2019-2 A3 43815MAC0 113,607.92 JPM_CHAS 100.06 113,677.88 74.20 70.97 DTD 05/29/2019 2.520% 06/21/2023

0.13 2.46
TAOT 2019-A A3 89239AAD5 137,776.09 MITSU 100.09 137,902.93 151.94 132.74 DTD 02/13/2019 2.910% 07/15/2023

0.11 2.82
ALLYA 2019-1 A3 02004WAC5 8,277.43 JPM_CHAS 100.00 8,277.29 0.86 0.12 DTD 02/13/2019 2.910% 09/15/2023

0.05 2.91
CITY OF MODESTO - COMBINED PORTFOLIO Page 25
#8..
- 119 -
Managed Account Fair Market Value & Analytics For the Month Ending June 30, 2022 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
NAROT 2019-A A3 65479KAD2 96,139.90 MITSU 100.07 96,208.01 82.67 72.13 DTD 02/13/2019 2.900% 10/15/2023

0.08 2.84
COPAR 2019-1 A3 14042WAC4 52,171.39 JPM_CHAS 100.06 52,203.13 42.31 35.00 DTD 05/30/2019 2.510% 11/15/2023

0.10 2.46
NAROT 2019-B A3 65479HAC1 191,729.35 WELLS_FA 99.99 191,716.66 30.66 0.64 DTD 05/28/2019 2.500% 11/15/2023

0.16 2.50
CARMX 2019-2 A3 14316LAC7 148,882.33 RBC 100.06 148,977.64 110.52 100.59 DTD 04/17/2019 2.680% 03/15/2024

0.20 2.64
HAROT 2020-1 A3 43813RAC1 640,053.81 JPM_CHAS 99.44 636,482.82 (3,445.53) (3,516.32) DTD 02/26/2020 1.610% 04/22/2024

0.45 1.92
TAOT 2020-A A3 89232HAC9 823,930.03 MITSU 99.45 819,359.20 (4,511.34) (4,544.65) DTD 02/12/2020 1.660% 05/15/2024

0.37 1.96
CARMX 2020-1 A3 14315XAC2 478,103.52 MERRILL 99.34 474,931.97 (3,077.75) (3,124.44) DTD 01/22/2020 1.890% 12/16/2024

0.50 2.17
HAROT 2021-1 A3 43813GAC5 650,000.00 JPM_CHA 97.66 634,757.83 (15,230.28) (15,234.14) DTD 02/24/2021 0.270% 04/21/2025

0.79 1.12
HART 2021-A A3 44933LAC7 510,000.00 BARCLAY 96.85 493,946.12 (16,000.23) (16,014.61) DTD 04/28/2021 0.380% 09/15/2025

1.02 1.38
CARMX 2021-1 A3 14316NAC3 385,000.00 MITSU 97.48 375,299.93 (9,623.99) (9,646.18) DTD 01/27/2021 0.340% 12/15/2025

0.75 1.08
TAOT 2021-C A3 89239BAC5 980,000.00 BARCLAY 95.24 933,397.86 (46,524.03) (46,537.80) DTD 09/27/2021 0.430% 01/15/2026

1.47 1.82
CARMX 2021-2 A3 14314QAC8 770,000.00 MERRILL 97.08 747,489.44 (22,344.63) (22,385.67) DTD 04/21/2021 0.520% 02/17/2026

0.94 1.35
HART 2021-C A3 44935FAD6 465,000.00 SMBC 95.40 443,617.11 (21,279.10) (21,293.40) DTD 11/17/2021 0.740% 05/15/2026

1.60 1.97
DCENT 2021-A1 A1 254683CP8 775,000.00 CITIGRP 93.67 725,947.46 (48,886.61) (48,911.95) DTD 09/27/2021 0.580% 09/15/2026

2.16 2.15
Security Type Sub-Total 7,225,671.77 7,034,193.28 (190,430.33) (190,796.97) 0.93 1.81 Managed Account Sub-Total 399,363,961.28 381,802,630.60 (12,251,253.99) (12,492,648.59) 2.12 2.96 CITY OF MODESTO - COMBINED PORTFOLIO Page 26
#8..
- 120 -
Managed Account Fair Market Value & Analytics For the Month Ending June 30, 2022 CITY OF MODESTO - Combined Portfolio
Total Investments $382,745,999.02
$943,368.42
$381,802,630.60
Accrued Interest
Securities Sub-Total $399,363,961.28 ($12,251,253.99) ($12,492,648.59) 2.12 2.96% CITY OF MODESTO - COMBINED PORTFOLIO Page 27
#8..
- 121 -
Managed Account Security Transactions & Interest For the Month Ending June 30, 2022 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
06/08/22 US TREASURY N/B NOTES
DTD 05/31/2021 0.750% 05/31/2026
06/06/22 91282CCF6 4,800,000.00 (4,399,125.00) (786.89) (4,399,911.89) 06/08/22 US TREASURY NOTES
DTD 11/15/2016 2.000% 11/15/2026
06/06/22 912828U24 4,545,000.00 (4,355,920.90) (5,928.26) (4,361,849.16) 06/16/22 MUFG BANK LTD/NY COMM PAPER
DTD 12/28/2021 0.000% 09/23/2022
06/16/22 62479MJP9 10,000,000.00 (9,941,975.00) 0.00 (9,941,975.00) Transaction Type Sub-Total 19,345,000.00 (18,697,020.90) (6,715.15) (18,703,736.05)

INTEREST
06/01/22 CA ST DEPT WTR RES WTR SYS TXBL

REV BNDS
DTD 08/06/2020 0.560% 12/01/2024
06/01/22 13067WRB0 100,000.00 0.00 280.00 280.00
06/01/22 06/01/22 MONEY MARKET FUND MONEY0002 0.00 0.00 271.23 271.23 06/01/22 JPMORGAN CHASE & CO CORPORATE
NOTES
DTD 06/01/2021 0.824% 06/01/2025
06/01/22 46647PCH7 865,000.00 0.00 3,563.80 3,563.80
06/25/22 FANNIEMAE-ACES
DTD 04/01/2014 3.346% 03/01/2024
06/01/22 3136AJB54 959,296.65 0.00 2,853.17 2,853.17
06/25/22 FHLMC MULTIFAMILY STRUCTURED P
DTD 12/01/2012 2.307% 08/01/2022
06/01/22 3137AWQH1 968,457.11 0.00 1,861.86 1,861.86
06/25/22 FHMS KJ27 A1
DTD 11/01/2019 2.092% 07/01/2024
06/01/22 3137FQ3V3 136,109.05 0.00 237.28 237.28
06/04/22 FREDDIE MAC NOTES
DTD 12/04/2020 0.250% 12/04/2023
06/04/22 3137EAFA2 2,015,000.00 0.00 2,518.75 2,518.75
06/08/22 FEDERAL HOME LOAN BANKS NOTES
DTD 12/09/2013 3.375% 12/08/2023
06/08/22 3130A0F70 2,025,000.00 0.00 34,171.88 34,171.88 06/15/22 COPAR 2019-1 A3
DTD 05/30/2019 2.510% 11/15/2023
06/15/22 14042WAC4 76,041.71 0.00 159.05 159.05
06/15/22 CARMX 2020-1 A3
DTD 01/22/2020 1.890% 12/16/2024
06/15/22 14315XAC2 519,525.21 0.00 818.25 818.25
06/15/22 US TREASURY N/B NOTES
DTD 06/15/2021 0.250% 06/15/2024
06/15/22 91282CCG4 4,485,000.00 0.00 5,606.25 5,606.25
06/15/22 HYUNDAI AUTO RECEIVABLES TRUST
DTD 04/10/2019 2.660% 06/15/2023
06/15/22 44932NAD2 8,436.27 0.00 18.70 18.70
CITY OF MODESTO - COMBINED PORTFOLIO Page 28
#8..
- 122 -
Managed Account Security Transactions & Interest For the Month Ending June 30, 2022 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
06/15/22 US TREASURY NOTES
DTD 12/15/2020 0.125% 12/15/2023
06/15/22 91282CBA8 4,430,000.00 0.00 2,768.75 2,768.75
06/15/22 HART 2021-A A3
DTD 04/28/2021 0.380% 09/15/2025
06/15/22 44933LAC7 510,000.00 0.00 161.50 161.50
06/15/22 ALLYA 2019-1 A3
DTD 02/13/2019 2.910% 09/15/2023
06/15/22 02004WAC5 32,460.23 0.00 78.72 78.72
06/15/22 CARMX 2021-1 A3
DTD 01/27/2021 0.340% 12/15/2025
06/15/22 14316NAC3 385,000.00 0.00 109.08 109.08
06/15/22 NAROT 2019-A A3
DTD 02/13/2019 2.900% 10/15/2023
06/15/22 65479KAD2 144,612.95 0.00 349.48 349.48
06/15/22 TAOT 2020-A A3
DTD 02/12/2020 1.660% 05/15/2024
06/15/22 89232HAC9 919,527.30 0.00 1,272.01 1,272.01
06/15/22 CARMX 2021-2 A3
DTD 04/21/2021 0.520% 02/17/2026
06/15/22 14314QAC8 770,000.00 0.00 333.67 333.67
06/15/22 NAROT 2019-B A3
DTD 05/28/2019 2.500% 11/15/2023
06/15/22 65479HAC1 240,291.74 0.00 500.61 500.61
06/15/22 TAOT 2021-C A3
DTD 09/27/2021 0.430% 01/15/2026
06/15/22 89239BAC5 980,000.00 0.00 351.17 351.17
06/15/22 CARMX 2019-2 A3
DTD 04/17/2019 2.680% 03/15/2024
06/15/22 14316LAC7 180,657.85 0.00 403.47 403.47
06/15/22 DCENT 2021-A1 A1
DTD 09/27/2021 0.580% 09/15/2026
06/15/22 254683CP8 775,000.00 0.00 374.58 374.58
06/15/22 HART 2021-C A3
DTD 11/17/2021 0.740% 05/15/2026
06/15/22 44935FAD6 465,000.00 0.00 286.75 286.75
06/15/22 US TREASURY N/B NOTES
DTD 12/15/2021 1.000% 12/15/2024
06/15/22 91282CDN8 4,445,000.00 0.00 22,225.00 22,225.00 06/15/22 TAOT 2019-A A3
DTD 02/13/2019 2.910% 07/15/2023
06/15/22 89239AAD5 195,494.00 0.00 474.07 474.07
06/17/22 FANNIE MAE NOTES
DTD 06/19/2020 0.500% 06/17/2025
06/17/22 3135G04Z3 9,960,000.00 0.00 24,900.00 24,900.00 06/18/22 HAROT 2019-1 A3
DTD 02/27/2019 2.830% 03/20/2023
06/18/22 43814WAC9 20,135.99 0.00 47.49 47.49
06/19/22 FREDDIE MAC NOTES
DTD 06/11/2018 2.750% 06/19/2023
06/19/22 3137EAEN5 7,785,000.00 0.00 107,043.75 107,043.75 CITY OF MODESTO - COMBINED PORTFOLIO Page 29
#8..
- 123 -
Managed Account Security Transactions & Interest For the Month Ending June 30, 2022 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
06/21/22 HAROT 2019-2 A3
DTD 05/29/2019 2.520% 06/21/2023
06/21/22 43815MAC0 160,800.72 0.00 337.68 337.68
06/21/22 HAROT 2021-1 A3
DTD 02/24/2021 0.270% 04/21/2025
06/21/22 43813GAC5 650,000.00 0.00 146.25 146.25
06/21/22 HAROT 2020-1 A3
DTD 02/26/2020 1.610% 04/22/2024
06/21/22 43813RAC1 706,120.84 0.00 947.38 947.38
06/26/22 FREDDIE MAC NOTES
DTD 06/26/2020 0.250% 06/26/2023
06/26/22 3137EAES4 3,315,000.00 0.00 4,143.75 4,143.75
06/30/22 US TREASURY NOTES
DTD 12/31/2020 0.375% 12/31/2025
06/30/22 91282CBC4 5,275,000.00 0.00 9,890.63 9,890.63
06/30/22 US TREASURY NOTES
DTD 07/02/2018 2.750% 06/30/2025
06/30/22 912828XZ8 4,230,000.00 0.00 58,162.50 58,162.50 06/30/22 US TREASURY NOTES
DTD 06/30/2016 1.375% 06/30/2023
06/30/22 912828S35 5,100,000.00 0.00 35,062.50 35,062.50 06/30/22 US TREASURY NOTES
DTD 12/31/2018 2.625% 12/31/2023
06/30/22 9128285U0 270,000.00 0.00 3,543.75 3,543.75
Transaction Type Sub-Total 64,102,967.62 0.00 326,274.76 326,274.76

MATURITY
06/16/22 MUFG BANK LTD/NY COMM PAPER
DTD 11/04/2021 0.000% 06/16/2022
06/16/22 62479MFG3 10,000,000.00 10,000,000.00 0.00 10,000,000.00 18,355.56 0.00 Transaction Type Sub-Total 10,000,000.00 10,000,000.00 0.00 10,000,000.00 18,355.56 0.00

PAYDOWNS
06/25/22 FHLMC MULTIFAMILY STRUCTURED P
DTD 12/01/2012 2.307% 08/01/2022
06/01/22 3137AWQH1 139,783.98 139,783.98 0.00 139,783.98 (2,064.00) 0.00 06/25/22 FHMS KJ27 A1
DTD 11/01/2019 2.092% 07/01/2024
06/01/22 3137FQ3V3 86,537.20 86,537.20 0.00 86,537.20 2.07 0.00 06/25/22 FANNIEMAE-ACES
DTD 04/01/2014 3.346% 03/01/2024
06/01/22 3136AJB54 35,252.12 35,252.12 0.00 35,252.12 (1,713.03) 0.00 06/15/22 NAROT 2019-A A3
DTD 02/13/2019 2.900% 10/15/2023
06/15/22 65479KAD2 48,473.05 48,473.05 0.00 48,473.05 7.34 0.00 CITY OF MODESTO - COMBINED PORTFOLIO Page 30
#8..
- 124 -
Managed Account Security Transactions & Interest For the Month Ending June 30, 2022 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
06/15/22 ALLYA 2019-1 A3
DTD 02/13/2019 2.910% 09/15/2023
06/15/22 02004WAC5 24,182.80 24,182.80 0.00 24,182.80 2.92 0.00 06/15/22 HYUNDAI AUTO RECEIVABLES TRUST
DTD 04/10/2019 2.660% 06/15/2023
06/15/22 44932NAD2 8,436.27 8,436.27 0.00 8,436.27 1.11 0.00 06/15/22 COPAR 2019-1 A3
DTD 05/30/2019 2.510% 11/15/2023
06/15/22 14042WAC4 23,870.32 23,870.32 0.00 23,870.32 4.84 0.00 06/15/22 TAOT 2019-A A3
DTD 02/13/2019 2.910% 07/15/2023
06/15/22 89239AAD5 57,717.91 57,717.91 0.00 57,717.91 10.52 0.00 06/15/22 NAROT 2019-B A3
DTD 05/28/2019 2.500% 11/15/2023
06/15/22 65479HAC1 48,562.39 48,562.39 0.00 48,562.39 10.98 0.00 06/15/22 CARMX 2020-1 A3
DTD 01/22/2020 1.890% 12/16/2024
06/15/22 14315XAC2 41,421.69 41,421.69 0.00 41,421.69 8.13 0.00 06/15/22 CARMX 2019-2 A3
DTD 04/17/2019 2.680% 03/15/2024
06/15/22 14316LAC7 31,775.52 31,775.52 0.00 31,775.52 3.25 0.00 06/15/22 TAOT 2020-A A3
DTD 02/12/2020 1.660% 05/15/2024
06/15/22 89232HAC9 95,597.27 95,597.27 0.00 95,597.27 6.90 0.00 06/18/22 HAROT 2019-1 A3
DTD 02/27/2019 2.830% 03/20/2023
06/18/22 43814WAC9 20,135.99 20,135.99 0.00 20,135.99 0.54 0.00 06/21/22 HAROT 2020-1 A3
DTD 02/26/2020 1.610% 04/22/2024
06/21/22 43813RAC1 66,067.03 66,067.03 0.00 66,067.03 12.95 0.00 06/21/22 HAROT 2019-2 A3
DTD 05/29/2019 2.520% 06/21/2023
06/21/22 43815MAC0 47,192.80 47,192.80 0.00 47,192.80 1.76 0.00 Transaction Type Sub-Total 775,006.34 775,006.34 0.00 775,006.34 (3,703.72) 0.00 SELL
06/08/22 US TREASURY NOTES
DTD 12/15/2019 1.625% 12/15/2022
06/06/22 912828YW4 4,235,000.00 4,234,669.14 33,085.94 4,267,755.08 (5,790.04) (4,446.91) FIFO 06/08/22 US TREASURY NOTES
DTD 06/17/2019 1.750% 06/15/2022
06/06/22 9128286Y1 3,230,000.00 3,230,630.86 27,175.48 3,257,806.34 (7,317.97) (175.54) FIFO Transaction Type Sub-Total 7,465,000.00 7,465,300.00 60,261.42 7,525,561.42 (13,108.01) (4,622.45) Managed Account Sub-Total (456,714.56) 379,821.03 (76,893.53) 1,543.83 (4,622.45) CITY OF MODESTO - COMBINED PORTFOLIO Page 31
#8..
- 125 -
Managed Account Security Transactions & Interest For the Month Ending June 30, 2022 CITY OF MODESTO - Combined Portfolio
Total Security Transactions ($456,714.56) $379,821.03 ($76,893.53) $1,543.83 ($4,622.45) CITY OF MODESTO - COMBINED PORTFOLIO Page 32
#8..
- 126 -
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
6/30/2020 1.74% 84,995,885.29 0.51% 235,131,341.49 2.18% 7/31/2020 1.70% 70,022,491.13 0.37% 236,269,407.98 2.10% 8/31/2020 1.58% 70,040,261.05 0.30% 236,780,335.74 1.96% 9/30/2020 1.53% 70,055,998.31 0.27% 236,959,922.49 1.90% 10/31/2020 1.46% 70,067,223.80 0.19% 238,332,735.73 1.83% 11/30/2020 1.41% 70,075,022.52 0.14% 237,871,749.29 1.79% 12/31/2020 1.33% 85,083,671.36 0.12% 237,485,609.39 1.77% 1/31/2021 1.31% 85,092,301.61 0.12% 238,149,298.87 1.74% 2/28/2021 1.14% 120,099,726.01 0.10% 232,079,913.81 1.68% 3/31/2021 1.08% 137,608,358.86 0.08% 234,986,337.21 1.67% 4/30/2021 1.09% 99,414,400.76 0.06% 273,342,506.45 1.47% 5/31/2021 1.00% 134,419,293.96 0.05% 273,479,692.78 1.46% 6/30/2021 0.97% 134,424,844.05 0.05% 273,831,695.68 1.42% 7/31/2021 1.02% 108,729,978.62 0.05% 273,119,224.63 1.40% 8/31/2021 1.01% 108,734,764.86 0.05% 272,424,046.82 1.39% 9/30/2021 0.97% 108,739,293.68 0.05% 275,543,849.60 1.33% 10/31/2021 0.91% 123,744,124.02 0.05% 274,089,339.67 1.30% 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.57% 75,106,114.53 1.14% 354,423,884.74 1.64% 39,871,394.45 1.66% 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. #8..
- 127 -
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, 2023
Expected Earnings to
June 30, 2023
Main Portfolio
Federal Agency
FNMA 2,915,000 5/22/2023 2.800% 1 9,137 0.64% 18,792
FHLMC 3,615,000 6/19/2023 2.880% 1 90,512 2.60% 93,889
FHLMC 4,170,000 6/19/2023 2.880% 1 123,786 3.06% 127,682 FHLMC 3,315,000 6/26/2023 2.890% 1 11,407 0.38% 12,534
FNMA 3,395,000 7/10/2023 2.920% 1 11,234 0.32% 10,934
FHLMC 2,200,000 8/24/2023 2.950% 1 7,191 0.28% 6,250
FNMA 3,745,000 9/12/2023 2.960% 1 141,719 3.15% 117,830 FNMA 5,665,000 9/12/2023 2.960% 1 198,965 2.92% 165,426 FFCB 2,345,000 9/21/2023 2.940% 1 8,863 0.31% 7,221
FNMA 900,000 11/27/2023 3.000% 1 2,492 0.20% 1,766
FHLMC 2,015,000 12/4/2023 3.010% 1 8,160 0.28% 5,706
FHLB 2,025,000 12/8/2023 3.020% 1 79,444 2.72% 55,128
FNMA 3,500,000 1/7/2025 3.080% 3 75,243 0.85% 29,787
FHLMC 640,000 2/12/2025 3.090% 3 19,904 1.18% 7,583
FHLB 2,370,000 4/14/2025 3.090% 3 39,763 0.60% 14,243
FNMA 3,195,000 4/22/2025 3.130% 3 59,962 0.67% 21,311
FNMA 475,000 4/22/2025 3.130% 3 7,933 0.59% 2,819
FNMA 3,345,000 4/22/2025 3.130% 3 57,398 0.61% 20,399
FNMA 1,910,000 4/22/2025 3.130% 3 27,871 0.52% 9,905
FNMA 3,675,000 6/17/2025 3.140% 3 59,108 0.54% 19,921
FNMA 200,000 6/17/2025 3.140% 3 2,517 0.42% 848
FNMA 1,075,000 6/17/2025 3.140% 3 12,732 0.40% 4,291
FNMA 3,820,000 6/17/2025 3.140% 3 46,264 0.41% 15,592
FNMA 1,190,000 6/17/2025 3.140% 3 12,795 0.36% 4,312
FHLMC 2,220,000 7/21/2025 3.090% 3 32,340 0.48% 10,568
FNMA 2,360,000 8/25/2025 3.090% 3 35,002 0.47% 11,090
FNMA 550,000 8/25/2025 3.090% 3 7,634 0.44% 2,419
FNMA 450,000 8/25/2025 3.090% 3 6,991 0.49% 2,215
FHLMC 3,400,000 9/23/2025 3.070% 3 47,964 0.44% 14,824
FHLMC 130,000 9/23/2025 3.070% 3 1,689 0.40% 522
FNMA 2,215,000 11/7/2025 3.100% 3 42,626 0.57% 12,691
FNMA 2,040,000 11/7/2025 3.100% 3 34,794 0.51% 10,359
Federal Agency CMO
FHLMC 828,673 8/1/2022 5.240% 0 1,296 2.98% 24,662
FNMA 924,045 3/1/2024 3.640% 2 32,987 2.14% 19,738
FHLMC 49,572 7/1/2024 2.220% 2 2,080 2.09% 1,037
U.S. Treasury
U.S. Treasury 4,315,000 3/15/2023 2.760% 1 53,856 2.16% 93,047 U.S. Treasury 4,355,000 5/31/2023 2.890% 1 80,605 2.11% 91,702 U.S. Treasury 5,100,000 6/30/2023 2.920% 1 130,767 2.56% 130,767 U.S. Treasury 3,155,000 7/31/2023 2.940% 1 83,490 2.44% 76,954 U.S. Treasury 5,625,000 7/31/2023 2.940% 1 139,346 2.28% 128,438 U.S. Treasury 1,750,000 8/31/2023 2.990% 1 35,792 1.75% 30,595 U.S. Treasury 4,395,000 9/15/2023 2.970% 1 118,954 2.24% 98,231 U.S. Treasury 2,700,000 9/30/2023 2.980% 1 76,256 2.26% 60,905 U.S. Treasury 8,790,000 11/15/2023 2.990% 1 305,180 2.52% 221,453 U.S. Treasury 3,910,000 11/15/2023 3.000% 1 13,803 0.26% 10,016 U.S. Treasury 3,275,000 11/30/2023 2.970% 1 116,933 2.52% 82,395 U.S. Treasury 4,430,000 12/15/2023 2.990% 1 155,773 2.41% 106,674 U.S. Treasury 270,000 12/31/2023 2.990% 2 10,397 2.56% 6,912 U.S. Treasury 1,564,000 2/29/2024 2.970% 2 9,005 0.35% 5,397 U.S. Treasury 457,000 2/29/2024 2.970% 2 2,552 0.33% 1,529 U.S. Treasury 4,450,000 3/15/2024 3.000% 2 189,082 2.49% 110,601 U.S. Treasury 4,890,000 4/15/2024 3.000% 2 30,692 0.35% 17,103 U.S. Treasury 4,485,000 6/15/2024 3.000% 2 227,997 2.59% 116,228 U.S. Treasury 2,450,000 7/31/2024 3.000% 2 91,476 1.79% 43,817 U.S. Treasury 1,630,000 8/31/2024 3.010% 2 47,325 1.34% 21,783 U.S. Treasury 4,505,000 9/15/2024 3.040% 2 264,446 2.65% 119,459 U.S. Treasury 1,850,000 9/30/2024 2.990% 2 62,629 1.50% 27,776 U.S. Treasury 460,000 10/31/2024 3.020% 2 16,852 1.57% 7,203 U.S. Treasury 1,215,000 11/30/2024 3.030% 2 49,841 1.69% 20,579 U.S. Treasury 3,450,000 11/30/2024 3.030% 2 136,253 1.63% 56,258 U.S. Treasury 4,585,000 11/30/2024 3.030% 2 55,909 0.50% 23,084 U.S. Treasury 4,445,000 12/15/2024 3.030% 2 293,907 2.68% 119,328 U.S. Treasury 4,400,000 2/15/2025 3.060% 3 313,276 2.70% 118,986 U.S. Treasury 4,945,000 4/30/2025 3.050% 3 88,695 0.63% 31,279 U.S. Treasury 4,230,000 6/30/2025 3.040% 3 347,099 2.73% 115,594 U.S. Treasury 4,340,000 8/31/2025 3.070% 3 72,694 0.53% 22,913 U.S. Treasury 4,635,000 8/31/2025 3.070% 3 403,076 2.74% 127,049 U.S. Treasury 4,550,000 9/30/2025 3.070% 3 99,271 0.67% 30,500 U.S. Treasury 1,100,000 9/30/2025 3.070% 3 28,788 0.80% 8,845 U.S. Treasury 5,010,000 10/31/2025 3.080% 3 129,336 0.77% 38,727 U.S. Treasury 6,930,000 10/31/2025 3.080% 3 180,471 0.78% 54,038 U.S. Treasury 4,250,000 11/30/2025 3.070% 3 154,906 1.07% 45,269 U.S. Treasury 4,635,000 11/30/2025 3.070% 3 436,742 2.75% 127,631 U.S. Treasury 1,040,000 12/31/2025 3.070% 4 16,545 0.45% 4,718 U.S. Treasury 500,000 12/31/2025 3.070% 4 7,579 0.43% 2,161 U.S. Treasury 3,735,000 12/31/2025 3.070% 4 116,279 0.89% 33,158 U.S. Treasury 2,400,000 1/31/2026 3.070% 4 69,350 0.80% 19,308 U.S. Treasury 5,775,000 1/31/2026 3.070% 4 263,933 1.27% 73,482 U.S. Treasury 5,000,000 1/31/2026 3.070% 4 332,991 1.85% 92,709 U.S. Treasury 7,980,000 1/31/2026 3.070% 4 845,527 2.95% 235,406 U.S. Treasury 3,210,000 2/28/2026 3.060% 4 82,704 0.70% 22,544 U.S. Treasury 6,000,000 2/28/2026 3.080% 4 254,178 1.15% 69,287 U.S. Treasury 4,645,000 2/28/2026 3.080% 4 469,981 2.76% 128,113 U.S. Treasury 4,925,000 3/31/2026 3.070% 4 160,733 0.87% 42,823 U.S. Treasury 2,480,000 3/31/2026 3.070% 4 70,625 0.76% 18,816 U.S. Treasury 1,405,000 5/31/2026 3.070% 4 47,833 0.87% 12,201 U.S. Treasury 4,615,000 5/31/2026 3.070% 4 499,561 2.76% 127,421 U.S. Treasury 4,800,000 5/31/2026 3.070% 4 563,131 2.99% 143,636 U.S. Treasury 4,640,000 8/31/2026 3.070% 4 532,449 2.75% 127,606 U.S. Treasury 4,310,000 9/30/2026 3.070% 4 507,587 2.77% 119,298 U.S. Treasury 4,545,000 11/15/2026 3.080% 4 599,092 3.01% 136,753 June 30, 2022
Earnings to
Maturity
#8..
- 128 -
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, 2023
Expected Earnings to
June 30, 2023
June 30, 2022
Earnings to
Maturity
Commercial Paper
LMA Americas LLC 10,000,000 8/1/2022 1.980% 0 10,988 2.93% 292,959 Collat Commercial Paper Flex Co 10,000,000 9/12/2022 2.240% 0 33,213 2.80% 280,172 Starbird Funding Corp 10,000,000 9/19/2022 2.260% 0 35,694 2.77% 276,747 Mitsubishi Ufj Financial Group Inc 10,000,000 9/23/2022 2.190% 0 49,424 2.87% 287,103 Negotiable CD
Skandinaviska Enskilda Banken Ab 3,560,000 8/26/2022 1.910% 0 10,312 2.90% 103,310 Barclays PLC 2,750,000 2/1/2023 3.580% 1 17,088 1.89% 51,857 Credit Suisse Group 1,850,000 3/17/2023 3.330% 1 7,721 1.31% 24,210 Corporate Note
Toyota Motor Corp 2,230,000 9/20/2023 3.280% 1 99,709 3.65% 81,418 US Bancorp 2,860,000 2/5/2024 3.250% 2 104,002 2.27% 64,890 Bank Of America Co 2,010,000 3/5/2024 3.680% 2 53,123 1.57% 31,579 Pfizer Inc 3,445,000 3/15/2024 3.180% 2 158,359 2.69% 92,630 Amazon.Com Inc 1,590,000 5/12/2024 3.190% 2 14,828 0.50% 7,936 JPMorgan Chase & Co 1,320,000 5/13/2024 3.540% 2 15,983 0.65% 8,541 Wal-Mart Stores Inc 4,000,000 7/8/2024 3.110% 2 177,055 2.19% 87,449 JPMorgan Chase & Co 1,405,000 9/16/2024 2.480% 2 20,335 0.65% 9,175 Paccar Financial Corp 1,810,000 2/6/2025 3.640% 3 68,358 1.45% 26,209 Novartis Capital Corp 2,290,000 2/14/2025 3.180% 3 55,539 0.92% 21,116 Mastercard Inc 1,760,000 3/3/2025 3.420% 3 50,706 1.08% 18,943 Amazon.Com Inc 3,430,000 4/13/2025 3.330% 3 292,337 3.06% 104,816 JPMorgan Chase & Co 865,000 6/1/2025 3.160% 3 20,836 0.82% 7,128 Bristol-Myers Squibb Co 2,230,000 11/13/2025 3.590% 3 71,510 0.95% 21,186 The Bank Of New York Mellon Corporation 3,465,000 1/28/2026 3.760% 4 92,517 0.75% 25,817 Bank Of America Co 2,025,000 4/2/2026 4.270% 4 257,566 3.38% 68,522 Microsoft Corp 3,000,000 8/8/2026 3.360% 4 263,637 2.14% 64,152 Target Corp 365,000 1/15/2027 3.740% 5 32,969 1.99% 7,249 Asset-Backed Securities
Honda Auto Receivables 113,608 6/21/2023 2.460% 1 2,793 2.54% 2,880 Toyota Motor Corp 137,776 7/15/2023 2.820% 1 4,180 2.91% 4,015 Ally Auto Receivables Trust 8,277 9/15/2023 2.910% 1 292 2.91% 241 Nissan Auto Receivables 96,140 10/15/2023 2.840% 1 3,610 2.90% 2,791 Capital One Prime Auto Receivables 52,171 11/15/2023 2.460% 1 1,808 2.51% 1,312 Nissan Auto Receivables 191,729 11/15/2023 2.500% 1 6,620 2.51% 4,804 Carmax Auto Owner Trust 148,882 3/15/2024 2.640% 2 6,827 2.68% 3,993 Honda Auto Receivables 640,054 4/22/2024 1.920% 2 18,746 1.61% 10,336 Toyota Motor Corp 823,930 5/15/2024 1.960% 2 25,695 1.66% 13,692 Carmax Auto Owner Trust 478,104 12/16/2024 2.170% 2 22,330 1.89% 9,056 Honda Auto Receivables 650,000 4/21/2025 1.120% 3 4,941 0.27% 1,758 Hyundai Auto Receivables 510,000 9/15/2025 1.380% 3 6,268 0.38% 1,950 Carmax Auto Owner Trust 385,000 12/15/2025 1.080% 3 4,588 0.34% 1,325 Toyota Motor Corp 980,000 1/15/2026 1.820% 4 15,016 0.43% 4,232 Carmax Auto Owner Trust 770,000 2/17/2026 1.350% 4 14,693 0.52% 4,038 Hyundai Auto Receivables 465,000 5/15/2026 1.970% 4 13,431 0.75% 3,464 Discover Card Execution Note Trust 775,000 9/15/2026 2.150% 4 19,083 0.58% 4,529 Municipal Securities
California St 2,310,000 10/1/2023 3.230% 1 54,217 1.87% 43,208 Maryland St 620,000 8/1/2024 2.970% 2 6,702 0.52% 3,206 California State University 600,000 11/1/2024 3.130% 2 9,627 0.68% 4,110 State Of California 100,000 12/1/2024 3.420% 2 1,358 0.56% 560 University Of California 510,000 5/15/2025 3.490% 3 12,955 0.88% 4,504 University Of California 220,000 5/15/2025 3.490% 3 5,104 0.81% 1,774 Florida State Board of Administration Finance 1,295,000 7/1/2025 3.470% 3 48,967 1.26% 16,292 Florida State Board of Administration Finance 505,000 7/1/2025 3.470% 3 16,789 1.11% 5,586 Los Angeles Community College District 925,000 8/1/2025 3.320% 3 22,098 0.77% 7,151 New Jersey Turnpike Authority 505,000 1/1/2026 3.720% 4 18,557 1.05% 5,288 Supranational Securities
Intl Bank Of Reconstruction And Dev 1,790,000 11/24/2023 2.970% 1 8,087 0.32% 5,765 Inter-American Development Bank 4,095,000 9/23/2024 3.050% 2 48,053 0.52% 21,494 Overnight Investments 75,106,115 Varies Varies 2.72% 2,041,189 Totals (Main Portfolio) 474,470,076 14,290,598 1.93% 9,142,455 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. #8..
- 129 -
Attachment 5
Issue Name / Type Trustee Bank Investment Total Amount Fair Market Value Difference
1993 Community Center Refinancing U.S. Bank First American Treasury Obligation Fund $1,977,349.51 $1,977,349.51 $0.00 1993 Golf Course Refinancing U.S. Bank First American Treasury Obligation Fund $603,241.38 $603,241.38 $0.00 Instl Res Tre and Agny Cash Adv6541 $72,378.51 $72,378.51 $0.00 Financial Guaranty Insurance Pol $1.00 $1.00 $0.00
CAMP $1,933,566.94 $1,933,566.94 $0.00
Total $2,005,946.45 $2,005,946.45 $0.00
Instl Res Tre and Agny Cash Adv6541 $67,695.90 $67,695.90 $0.00 CAMP $4,801,510.48 $4,801,510.48 $0.00
Total $4,869,206.38 $4,869,206.38 $0.00
2018 Wastewater Refunding Bank of New York Fidelity Inv MM Trsy Only $15.64 $15.64 $0.00 Fairview Village Refunding US Bank First American Government $195,219.22 $195,219.22 $0.00 Blackrock Federal Fund Instl 30 $4,510.47 $4,510.47 $0.00 CAMP $2,738,641.93 $2,738,794.25 $152.32
Total $2,743,152.40 $2,743,304.72 $152.32
PCE Litigation Bank of America Business Interest Maximizer $491,956.53 $491,956.53 $0.00 Water ARRA Grants Bank of the West Business Money Market $36,289.42 $36,289.42 $0.00 Innovative Claim Solutions (Third Party
Administrator - Worker's Compensation) Wells Fargo Bank Business Money Market $178,841.60 $178,841.60 $0.00 George Hills Company - General Liability
Claims Administration Services California Bank & Trust $16,770.29 $16,770.29 $0.00 Kemper Sports Management Inc. BMO Harris Bank Business Money Market $62,132.97 $62,132.97 $0.00 Stanislaus Community Foundation Modesto Commerce Bank Charles Schwab $705,822.36 $705,822.36 $0.00 California Bank of
Commerce $3,161,068.84 $3,161,068.84 $0.00
Columbia Bank $58,818.44 $58,818.44 $0.00
Banner Bank $19,282.55 $19,282.55 $0.00
Village One #2 Refunding Bank of New York
Third-Party Construction Contract
Retention
Cash with Fiscal Agent Investments
As of June 30, 2022
2008 Water Refunding COP Bank of New York
2008 Lease Revenue Bonds Bank of New York
#8..
- 130 -

Finance CommitteeSeptember 26, 2022

Finance Committee
September 26, 2022