City of San Ramon
FINANCE COMMITTEE
AGENDA
Sridhar Verose, Chair Sabina Zafar, Vice Chair
San Ramon City Hall
Large Conference Room
7000 Bollinger Canyon Road
Regular Meeting
4:00 PM
July 25, 2022
AGENDA QUESTIONS: PLEASE CALL THE ADMINISTRATIVE SERVICES DIRECTOR AT (925) 973-2576 Documents received after publication of this Agenda and considered by the Finance Committee in its deliberation will be available for inspection in the Administrative Services Department located at 7000 Bollinger Canyon Road, San Ramon during normal business hours and in the red binder at the Finance Committee meeting.
1. CALL TO ORDER
2. PUBLIC COMMENT
3. APPROVAL OF MINUTES
3.1 Finance Committee - Regular Meeting - May 9, 2022 4:00 PM
4. UNFINISHED BUSINESS
5. NEW BUSINESS
5.1 City of San Ramon Quarterly Investment Report (Period Ending June 30, 2022)
6. COMMITTEE MEMBER COMMENTS
7. ADJOURNMENT
I hereby certify that the attached Finance Committee Meeting Agenda was posted 72 hours before the noted meeting.
Dated: July 20, 2022
MINUTES OF THE
CITY OF SAN RAMON FINANCE COMMITTEE
May 9, 2022
1. CALL TO ORDER
The meeting was called to order at 4:01 PM.
Attendee Name Title Status Arrived
Sridhar Verose Chair Present
Sabina Zafar Vice Chair Present
Sean Anderson, Program Manager
Robin Bartlett, Engineering Services Division Manager
Maria Fierner, Public Works Director
Joe Gorton, City Manager
Adolfo Navarro, Office Specialist
Kelly Sessions, Administrative Services Director
Steven Spedowfski, Deputy City Manager
2. PUBLIC COMMENT
3. APPROVAL OF MINUTES
3.1 Finance Committee - Regular Meeting - Apr 25, 2022 4:00 PM RESULT: ACCEPTED [UNANIMOUS]
AYES: Verose, Zafar
4. UNFINISHED BUSINESS
5. NEW BUSINESS
5.1 Review of Reserve Study and Preliminary FY 2022/23 Operating and Capital Budgets for Landscaping & Lighting District No. 1984-1
Staff Report by Sean Anderson, Program Manager
Public Comment was received by Elena de Barrio Verose.
The Finance Committee accepted the report and recommended forwarding to City Council for approval.
RESULT: APPROVED [UNANIMOUS]
AYES: Verose, Zafar
3.1 Packet Pg. 2
Minutes Acceptance: Minutes of May 9, 2022 4:00 PM (APPROVAL OF MINUTES) 2 Finance Committee Meeting – May 9, 2022
5.2 Update of the Preserve Landscaping and Lighting Assessment District Staff Report by Robin Bartlett, Engineering Division Manager Public Comment was received from Elena de Barrio Verose.
The Finance Committee accepted the report and recommended forwarding to City Council for approval.
RESULT: APPROVED [UNANIMOUS]
AYES: Verose, Zafar
6. COMMITTEE MEMBER COMMENTS
7. ADJOURNMENT
The next Finance Committee Meeting is scheduled for June 13, 2022.
3.1 Packet Pg. 3
Minutes Acceptance: Minutes of May 9, 2022 4:00 PM (APPROVAL OF MINUTES)
FINANCE COMMITTEE STAFF REPORT
DATE: July 25, 2022
TO: Finance Committee/City Manager
FROM: Kelly Sessions, Administrative Services Director
By: Miaoxia Joe, Administraive Analyst
SUBJECT: City of San Ramon Quarterly Investment Report (Period Ending June 30, 2022)
RECOMMENDED ACTION
Staff recommends that the Finance Committee review and accept the Quarterly Investment Report for the Period Ending June 30, 2022.
BACKGROUND/DISCUSSION
State law requires that City Council review the City Investment Report at least quarterly. A copy of the FHN Financial-Main Street Advisors Investment Report for the period ending June 30, 2022, the Investments Held by Trustees, and the Summary of Cash and Investments are attached for your review.
The June 30, 2022 Investment Report was prepared by FHN Financial-Main Street Advisors, the City’s investment manager. The Investment Report is maintained on a daily basis to track investment yield, maturities, call dates, and market values. The Investments Held by Trustees and the Summary of Cash and Investments were prepared by staff.
The City’s investments are carried at fair value, as required by generally accepted accounting principles. In accordance with GASB Statement No. 31, Accounting and Financial Reporting for Certain Investments and for External Pools, the City adjusts the carrying value of its investments to reflect their fair value at each fiscal year end, and it includes the effects of these adjustments in income for that fiscal year.
FISCAL ANALYSIS
The balance of the City’s demand deposit accounts held with JP Morgan Chase Bank, as of June 30, 2022 totaled $10.7 million. This account is used for daily City operations.
Total funds managed by FHN Financial-Main Street Advisors, as of June 30, 2022 totaled $77.5 million at book value. The portfolio consists of $35.4 million in federal agency securities, $24.0
5.1 Packet Pg. 4
million in treasury securities, $3.1 million in supranationals, $6.5 million in corporate notes, $3.7 million in FDIC insured CD’s, $1.0 million in municipal bonds, and $3.8 million in commercial paper. The weighted average yield to maturity on investments is 1.36% and the weighted average days to maturity is 697 days, which is 40 days shorter than last quarter. Interest rates are 14 basis points higher than the previous quarter.
The overall objective in managing the City’s investment portfolio is to generate favorable longterm results relative to the City’s benchmark, the ICE BofAML 30-month average (MMA) custom benchmark, while maintaining safety of principal and appropriate liquidity. To accomplish these objectives, FHN Financial-Main Street Advisors is directed to maintain a strategy designed to keep the portfolio’s results in line with the established benchmark, while actively managing the portfolio’s duration relative to the benchmark, sector allocation and yield curve placement to enhance performance.
The balance of the City’s Fidelity U.S. Government Money Market account held with US Bank, as of June 30, 2022 totals $2.0 million and makes up 2.4% of the portfolio. The current rate is
1.20%. This account is available on a daily basis for immediate cash flow requirements.
The City of San Ramon has $2.6 million invested with the State Treasurer’s Office (Local Agency Investment Fund). The current interest rate is 0.86% and makes up 3.2% of the portfolio.
This account is available on a daily basis for immediate cash flow requirements.
The “Investments Held by Trustees” report was prepared by staff and is required supplementary information in the quarterly report to the City Council. Funds held with the trustee total $5.3 million. The 2019 Certificates of Participation (COP) investments managed by FHN FinancialMain Street Advisors total $3.6 million and are available for designated capital projects. The remaining $1.7 million of investments managed by the trustee pertain to City pension obligation bonds and are not available for general City purposes.
This Investment portfolio is in conformity with the City of San Ramon’s adopted “Investment Policy.” The Treasurer’s cash management program provides sufficient liquidity to meet estimated future expenditures for a period of six months. FHN Financial-Main Street Advisors provides market values for securities under their management; market prices of securities held by trust are obtained from the trustees’ monthly account statements.
FISCAL IMPACT
There is no immediate fiscal impact.
STEPS FOLLOWING APPROVAL
None
ATTACHMENT
A: Summary of Cash and Investments at June 30 2022
B: Investment Portfolio Information for City of San Ramon for the Month Ending June 30, 2022
5.1 Packet Pg. 5
C: Investments Held by Trustees at June 30, 2022
D: Investment Terminology
5.1 Packet Pg. 6
Demand deposits held with JP Morgan Chase Bank $ 10,719,048 Investment Portfolio:
Investments held with US Bank (FHN Financial - Main Street Advisors) 77,451,306 Fidelity US Government Money Market Funds held with US Bank 1,973,048 Investments held with Local Agency Investment Fund (LAIF) 2,600,799 Total Investment Portfolio 82,025,153
Investments held with Trustee 5,280,006
Total Cash and Investments $ 98,024,207
This investment portfolio is in conformity with the City of San Ramon's adopted investment policy. The Treasurer's cash management program provides sufficient liquidity to meet estimated future expenditures for a period of six months.
Prepared and approved by:
Miaoxia (Michelle) Joe, Finance Analyst
Approved by:
Kelly Sessions, Administrative Services Director
Summary of Cash and Investments
For the Period June 30, 2022
5.1.a
Packet Pg. 7
Attachment: A: Summary of Cash and Investments at June 30 2022 (3703 : Quarterly Investment Report) Client Management Team
Rick Phillips
President & Chief Investment Officer
702-575-6666
[email protected]
Tonya Dazzio Monthly Investment Report
Chief Operating & Compliance Officer
702-575-6592
[email protected] City of San Ramon
Greg Balls, CFA
Assistant Chief Investment Officer
702-575-6655
[email protected] June 2022
10655 Park Run Drive, Suite 120 | Las Vegas, NV 89144 | Phone 702.575.6600 | www.FHNMainStreet.com
5.1.b
Packet Pg. 8
Attachment: B: Investment Portfolio Information for City of San Ramon for the Month Ending June 30, Run Date: 7/8/2022 - 10:03 AM
Amortizing Page 2
Portfolio Summary
City of San Ramon 6/30/2022
SECTOR ALLOCATION MATURITY DISTRIBUTION CREDIT QUALITY (MOODY'S)
ACCOUNT SUMMARY MONTH-END PORTFOLIO BOOK YIELD TOP ISSUERS 6/30/22 5/31/22 Issuer % Portfolio
Market Value $79,479,454 $79,832,411 U.S. Treasury 29.2% Book Value $82,025,153 $81,942,347 FFCB 17.5%
Variance -$2,545,699 -$2,109,936 FHLB 9.8%
FNMA 8.6%
Par Value $82,040,847 $81,803,297 FHLMC 4.9%
LAIF 3.2%
Net Asset Value $96.90 $97.43 IBRD 2.5%
TVA 2.4%
Book Yield 1.36% 1.23% Fidelity Govt MMF 2.4%
Toronto Dominion Bank 1.5%
Market Yield 2.67% 2.16% Toyota 1.5%
ING US Funding 1.5%
Years to Maturity 1.91 1.86 IFC 1.3%
Bank of New York Mellon 1.3%
Effective Duration 1.83 1.79 Johnson & Johnson 1.2% Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21 Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22
1.05%
1.10%
1.15%
1.20%
1.25%
1.30%
1.35%
1.40%
1.2%
2.4%
3.2%
3.8%
4.5%
4.6%
8.0%
29.2%
43.1%
MUNI
MMF
LAIF
SUPRA
CD
CP
CORP
TSY
AGY
0% 25% 50% 75% 100%
34.5%
15.3%
23.2%
18.2%
8.8%
0-1Y 1-2Y 2-3Y 3-4Y 4-5Y+
0%
10%
20%
30%
40%
50%
60%
8.9%
0.6%
1.3%
2.4%
79.8%
7.0%
NR
A3
A2
A1
Aa3
Aa2
Aa1
Aaa
P-1
0% 25% 50% 75% 100%
2 5.1.b
Packet Pg. 9
Attachment: B: Investment Portfolio Information for City of San Ramon for the Month Ending June 30, Investment Policy Compliance
6/30/2022
Category Book Value % of Portfolio % Allowed by Policy In Compliance Reserved row
US Treasuries 23,948,591.35 29.20% 100% Yes
US Federal Agencies 35,377,219.47 43.13% 100% Yes
Supranational Obligations 3,118,624.92 3.80% 30% Yes
LAIF 2,600,798.52 3.17% 15% Yes
Commercial Paper 3,742,788.45 4.56% 25% Yes
Money Market Funds 1,973,048.27 2.41% 20% Yes
Negotiable Certificates of Deposit 3,718,805.41 4.53% 30% Yes Corporate Obligations 6,540,375.59 7.97% 30% Yes
State and Local Governments 1,004,901.04 1.23% 3% Yes
Total 82,025,153.03 100.00%
Other Metrics Portfolio Metric In Compliance
Weighted Average Maturity 1.91 Less than 2.5 Years Yes
Liquidity 34.54% 30% Under 365 Days Yes
Ratings Yes
City of San Ramon
Run Date: 7/13/2022 - 6:59 AM
Amortizing Page 1
3 5.1.b
Packet Pg. 10
Attachment: B: Investment Portfolio Information for City of San Ramon for the Month Ending June 30, Run Date: 7/8/2022 - 10:03 AM
Amortizing Page 4
Historical Book Values
City of San Ramon 6/30/2022
Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun
Fiscal Year 2018 $77.4 $77.5 $75.9 $74.6 $73.7 $73.4 $79.7 $81.5 $80.6 $78.3 $78.4 $78.5 FY18 Fiscal Year 2019 $78.5 $80.7 $78.4 $74.4 $69.7 $67.3 $74.7 $80.7 $79.8 $79.5 $84.6 $84.8 FY19 Fiscal Year 2020 $83.8 $82.9 $83.1 $74.8 $70.8 $70.8 $77.9 $82.0 $78.4 $78.8 $86.0 $87.0 FY20 Fiscal Year 2021 $85.5 $84.8 $85.7 $81.6 $76.1 $73.2 $75.4 $77.3 $77.4 $83.6 $85.3 $85.2 FY21 Fiscal Year 2022 $84.7 $80.5 $80.6 $78.6 $74.7 $71.3 $70.6 $80.3 $81.7 $81.8 $81.9 $82.0 FY22 Average Daily BalanceJul-09
Nov-09
Mar-10
Jul-10
Nov-10
Mar-11
Jul-11
Nov-11
Mar-12
Jul-12
Nov-12
Mar-13
Jul-13
Nov-13
Mar-14
Jul-14
Nov-14
Mar-15
Jul-15
Nov-15
Mar-16
Jul-16
Nov-16
Mar-17
Jul-17
Nov-17
Mar-18
Jul-18
Nov-18
Mar-19
Jul-19
Nov-19
Mar-20
Jul-20
Nov-20
Mar-21
Jul-21
Nov-21
Mar-22
$50
$60
$70
$80
$90
Millions
4 5.1.b
Packet Pg. 11
Attachment: B: Investment Portfolio Information for City of San Ramon for the Month Ending June 30, Run Date: 7/8/2022 - 10:03 AM
Amortizing Page 5
Historical Book Values Per Fiscal Year
City of San Ramon 6/30/2022
Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun
Fiscal Year 2018 $77.4 $77.5 $75.9 $74.6 $73.7 $73.4 $79.7 $81.5 $80.6 $78.3 $78.4 $78.5 FY18 Fiscal Year 2019 $78.5 $80.7 $78.4 $74.4 $69.7 $67.3 $74.7 $80.7 $79.8 $79.5 $84.6 $84.8 FY19 Fiscal Year 2020 $83.8 $82.9 $83.1 $74.8 $70.8 $70.8 $77.9 $82.0 $78.4 $78.8 $86.0 $87.0 FY20 Fiscal Year 2021 $85.5 $84.8 $85.7 $81.6 $76.1 $73.2 $75.4 $77.3 $77.4 $83.6 $85.3 $85.2 FY21 Fiscal Year 2022 $84.7 $80.5 $80.6 $78.6 $74.7 $71.3 $70.6 $80.3 $81.7 $81.8 $81.9 $82.0 FY22 Figures in Millions, Average Daily Balance
Chart Title
Jul
Aug
Sep
Oct
Nov
Dec
Jan
Feb
Mar
Apr
May
Jun
$65
$70
$75
$80
$85
$90
Millions
Fiscal Year 2018 Fiscal Year 2019 Fiscal Year 2020 Fiscal Year 2021 Fiscal Year 2022 5 5.1.b
Packet Pg. 12
Attachment: B: Investment Portfolio Information for City of San Ramon for the Month Ending June 30, Run Date: 7/8/2022 - 10:03 AM
Amortizing Page 6
Historical Weighted Average Maturity
City of San Ramon 6/30/2022 Don
Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun
Fiscal Year 2018 1.35 1.32 1.35 1.51 1.72 1.70 1.73 1.65 1.66 1.57 1.50 1.48 Fiscal Year 2019 1.44 1.52 1.60 1.76 1.79 1.70 1.69 1.67 1.65 1.50 1.55 1.63 Fiscal Year 2020 1.59 1.58 1.64 1.83 1.88 1.89 1.60 1.70 1.78 1.71 1.87 1.82 Fiscal Year 2021 1.93 1.76 1.72 1.88 1.87 1.88 1.83 1.91 1.96 1.90 1.83 1.76 Fiscal Year 2022 1.98 2.04 1.86 1.98 2.01 2.01 1.93 1.96 2.02 1.94 1.86 1.91 Jul-09 Nov-09 Mar-10 Jul-10 Nov-10 Mar-11 Jul-11 Nov-11 Mar-12 Jul-12 Nov-12 Mar-13 Jul-13 Nov-13 Mar-14 Jul-14 Nov-14 Mar-15 Jul-15 Nov-15 Mar-16 Jul-16 Nov-16 Mar-17 Jul-17 Nov-17 Mar-18 Jul-18 Nov-18 Mar-19 Jul-19 Nov-19 Mar-20 Jul-20 Nov-20 Mar-21 Jul-21 Nov-21 Mar-22
0.00 0.50
1.00 1.50
2.00 2.50
Average Years To Maturity
6 5.1.b
Packet Pg. 13
Attachment: B: Investment Portfolio Information for City of San Ramon for the Month Ending June 30, Run Date: 7/8/2022 - 10:03 AM
Amortizing Page 7
Next Twelve Months Cash Flow
City of San Ramon 6/30/2022
Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 Jan-23 Feb-23 Mar-23 Apr-23 May-23 Jun-23 Maturities $9.1 $1.5 $2.5 $4.0 $3.2 $3.3 $1.2 $0.0 $1.0 $0.2 $0.0 $2.2 1 Par Value in Millions; Assumes Securities Are Held To Maturity $9.1
$1.5
$2.5
$4.0
$3.2 $3.3
$1.2
$0.0
$1.0
$0.2
$0.0
$2.2
Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 Jan-23 Feb-23 Mar-23 Apr-23 May-23 Jun-23 $0
$1
$2
$3
$4
$5
$6
$7
$8
$9
$10
Millions
7 5.1.b
Packet Pg. 14
Attachment: B: Investment Portfolio Information for City of San Ramon for the Month Ending June 30, Run Date: 7/8/2022 - 10:03 AM
Amortizing Page 8
Yield At Cost Per 6-Month Maturity Intervals
City of San Ramon 6/30/2022
Years Yield At Cost % of Portfolio
0 to .5 1.35% 28.75%
.5 to 1.0 1.31% 5.79%
1.0 to 1.5 2.06% 10.69%
1.5 to 2.0 1.25% 4.56%
2.0 to 2.5 1.19% 14.11%
2.5 to 3.0 1.33% 9.14%
3.0 to 3.5 0.79% 13.45%
3.5 to 4.0 1.79% 4.75%
4.0 to 4.5 1.54% 7.54%
4.5 to 5.0 2.08% 1.22%
5.0+ 0.00% 0.00%
Total 1.36% 100.0%
1.35%
1.31%
2.06%
1.25% 1.19%
1.33%
0.79%
1.79%
1.54%
2.08%
-0.5 0.0 0.5 1.0 1.5 2.0 2.5 3.0 3.5 4.0 4.5 5.0 5.5
0.0%
0.5%
1.0%
1.5%
2.0%
2.5%
Maturity Intervals
Yield At Cost
Bubble Size = Maturity's % of Portfolio
8 5.1.b
Packet Pg. 15
Attachment: B: Investment Portfolio Information for City of San Ramon for the Month Ending June 30, Run Date: 7/8/2022 - 10:03 AM
Amortizing Page 9
Historical Sector Allocation
City of San Ramon 6/30/2022
Sector Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21 Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 AGY 55.8% 53.3% 48.2% 47.4% 48.3% 48.7% 48.7% 45.8% 45.8% 45.7% 43.2% 43.1% TSY 12.6% 16.3% 15.0% 18.4% 17.8% 18.5% 18.5% 23.3% 23.3% 23.3% 25.7% 29.2% CORP 7.4% 7.4% 7.4% 7.8% 8.2% 8.5% 8.5% 7.3% 7.9% 7.9% 7.9% 8.0% CP 1.6% 0.0% 0.0% 1.6% 3.4% 3.5% 3.5% 4.6% 4.6% 4.6% 4.6% 4.6% CD 5.9% 5.8% 5.8% 6.1% 6.4% 6.7% 6.3% 5.5% 5.5% 5.5% 4.8% 4.5% Supra 3.9% 3.9% 3.9% 4.1% 4.3% 4.4% 4.4% 3.8% 3.8% 3.8% 3.8% 3.8% LAIF 9.4% 9.4% 9.4% 9.9% 9.0% 6.5% 6.5% 5.6% 5.6% 5.6% 5.6% 3.2% MMF 2.2% 2.6% 8.9% 3.3% 1.3% 1.6% 2.0% 2.8% 2.2% 2.3% 3.1% 2.4% Muni 1.3% 1.3% 1.2% 1.3% 1.4% 1.4% 1.4% 1.2% 1.2% 1.2% 1.2% 1.2% Total 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21 Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 0%
5%
10%
15%
20%
25%
30%
35%
40%
45%
50%
55%
60%
AGY
TSY
CORP
CP
CD
Supra
LAIF
MMF
Muni
9 5.1.b
Packet Pg. 16
Attachment: B: Investment Portfolio Information for City of San Ramon for the Month Ending June 30, Run Date: 7/8/2022 - 10:03 AM
Amortizing Page 10
Issuer Allocation
City of San Ramon 6/30/2022
0.3%
0.3%
0.3%
0.3%
0.3%
0.3%
0.3%
0.3%
0.3%
0.3%
0.3%
0.3%
0.3%
0.3%
0.3%
0.6%
1.2%
1.2%
1.2%
1.2%
1.2%
1.2%
1.3%
1.3%
1.5%
1.5%
1.5%
2.4%
2.4%
2.5%
3.2%
4.9%
8.6%
9.8%
17.5%
29.2%
UBS Bank USA
TIAA FSB
Morgan Stanley Private Bank
EnerBank
Comenity Capital Bank
Citigroup
Capital One Bank NA
Morgan Stanley Bank
Synchrony Bank
Sallie Mae Bank
Discover Bank
Axos Bank
American Express National Bank
Goldman Sachs Bank
First Missouri State Bank
Home Depot
Microsoft
Chevron
New York Life
National Securities Clearing
State of California
Johnson & Johnson
Bank of New York Mellon
IFC
ING US Funding
Toyota
Toronto Dominion Bank
Fidelity Govt MMF
TVA
IBRD
LAIF
FHLMC
FNMA
FHLB
FFCB
U.S. Treasury
0% 5% 10% 15% 20% 25% 30% 35%
10 5.1.b
Packet Pg. 17
Attachment: B: Investment Portfolio Information for City of San Ramon for the Month Ending June 30, Run Date: 7/8/2022 - 10:03 AM
Amortizing Page 12
Historical Earnings & Book Return Performance
City of San Ramon 6/30/2022
Fiscal YTD ($K) Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun FY 2020 $154.500 $308.552 $459.790 $608.289 $744.438 $874.390 $1,016.248 $1,158.700 $1,295.754 $1,427.478 $1,554.200 $1,676.780 FY 2021 $121.850 $238.660 $351.123 $453.598 $547.800 $641.347 $734.415 $823.342 $911.769 $1,003.637 $1,096.200 $1,187.000 FY 2022 $89.499 $177.452 $260.506 $341.752 $413.503 $484.482 $558.270 $632.320 $713.196 $786.938 $879.582 $966.358 Fiscal YTD Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Book Return 1.24% 1.26% 1.26% 1.25% 1.24% 1.23% 1.23% 1.22% 1.22% 1.20% 1.22% 1.22% Fiscal Year-To-Date Earnings
Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun
$0
$200
$400
$600
$800
$1,000
$1,200
$1,400
$1,600
$1,800
Thousands
FY 2020
FY 2021
FY 2022
Fiscal Year-To-Date Book Return
Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun
1.00%
1.05%
1.10%
1.15%
1.20%
1.25%
1.30%
1.35%
1.40%
1.45%
1.50%
11 5.1.b
Packet Pg. 18
Attachment: B: Investment Portfolio Information for City of San Ramon for the Month Ending June 30, Run Date: 7/8/2022 - 10:03 AM
Amortizing Page 13
Historical Yield At Cost vs Benchmark
City of San Ramon 6/30/2022
Month-End Yield At Cost vs Benchmark
Jul-09
Nov-09
Mar-10
Jul-10
Nov-10
Mar-11
Jul-11
Nov-11
Mar-12
Jul-12
Nov-12
Mar-13
Jul-13
Nov-13
Mar-14
Jul-14
Nov-14
Mar-15
Jul-15
Nov-15
Mar-16
Jul-16
Nov-16
Mar-17
Jul-17
Nov-17
Mar-18
Jul-18
Nov-18
Mar-19
Jul-19
Nov-19
Mar-20
Jul-20
Nov-20
Mar-21
Jul-21
Nov-21
Mar-22
0.0%
0.5%
1.0%
1.5%
2.0%
2.5%
3.0% Portfolio
Benchmark
Trailing 12 Months: Month End Yield At Cost vs Benchmark Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21 Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22
0.0%
0.2%
0.4%
0.6%
0.8%
1.0%
1.2%
1.4%
1.6%
Portfolio
Benchmark
Benchmark: Custom Benchmark (see disclosure)
12 5.1.b
Packet Pg. 19
Attachment: B: Investment Portfolio Information for City of San Ramon for the Month Ending June 30, Run Date: 7/8/2022 - 10:03 AM
Amortizing Page 15
Investment Activity
City of San Ramon 6/30/2022
Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21 Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 Positions 71 70 66 67 66 65 64 70 70 70 68 69
Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21 Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 Purchases 2 3 0 3 1 0 0 6 2 0 0 4
Redemptions 2 3 4 2 2 1 1 0 2 0 2 3
Total 4 6 4 5 3 1 1 6 4 0 2 7
Number of Positions at Month End
Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21 Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 50 55
60 65
70 75
Positions
Purchases and Redemptions* (Excluding MMF/LGIP)
Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21 Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 0 2
4 6
8 10
Number of Transactions
Purchases
Redemptions
*Redemptions include maturities, calls, and sells
13 5.1.b
Packet Pg. 20
Attachment: B: Investment Portfolio Information for City of San Ramon for the Month Ending June 30, Portfolio Summary
City of San Ramon June 30, 2022
Investments Par Value Book Value
% of
Portfolio Maturity YTM
Days to
Market Value
Book
Certificates of Deposit 3,720,000.00 3,683,603.52 3,718,805.41 4.53 448 2.45 Commercial Paper 3,750,000.00 3,740,912.50 3,742,788.45 4.56 42 0.88 Corporate Bonds 6,579,000.00 6,376,634.35 6,540,375.59 7.97 672 2.27 LAIF 2,600,798.52 2,600,798.52 2,600,798.52 3.17 1 0.86 Money Market Funds 1,973,048.27 1,973,048.27 1,973,048.27 2.41 1 1.20 Municipal Securities 1,000,000.00 990,110.00 1,004,901.04 1.23 458 1.84 Supranational Securities 3,095,000.00 2,886,146.15 3,118,624.92 3.80 1,085 0.46 U.S. Agencies 35,323,000.00 34,361,750.43 35,377,219.47 43.13 639 1.39 U.S. Treasuries 24,000,000.00 22,866,450.00 23,948,591.35 29.20 1,025 1.15 82,040,846.79 79,479,453.74 82,025,153.03 100.00 697 1.36 Investments
Total Earnings June 30 Month Ending Fiscal Year To Date Current Year 85,741.89 966,358.00
Average Daily Balance 81,986,779.91 79,051,953.12
Book Rate of Return 1.27% 1.22%
Run Date: 7/8/2022 - 10:03 AM
Amortizing
14 5.1.b
Packet Pg. 21
Attachment: B: Investment Portfolio Information for City of San Ramon for the Month Ending June 30, Holdings Report
City of San Ramon June 30, 2022
Call Date
Maturity Date
Par Value
Settle Date
Book Value
Original Value
Mkt YTM
Mkt Price
Gain/Loss
% of Port
Fitch
Moody/S&P
Eff. Dur.
WAM
Accrued Int.
Market Value
CUSIP Coupon Rate
Issuer
Book Yield
Remaining
Certificates of Deposit
02587DV47 American Express National Bank 08/08/2022 248,000.00 08/09/2017 247,417.20 100.07 248,161.20 0.30% NR/NR 0.11
2.350% 2.40% 247,987.55 1.73% 2,283.30 173.65 NR 0.10
38148PMR5 Goldman Sachs Bank 08/16/2022 248,000.00 08/17/2017 247,417.20 100.08 248,186.00 0.30% NR/NR 0.13
2.350% 2.40% 247,984.99 1.76% 2,155.56 201.01 NR 0.13
254673BZ8 Discover Bank 09/07/2022 248,000.00 09/08/2017 247,417.20 100.10 248,255.44 0.30% NR/NR 0.19
2.350% 2.40% 247,977.97 1.79% 1,852.19 277.47 NR 0.18
14042RJZ5 Capital One Bank NA 11/08/2022 248,000.00 11/09/2017 247,417.20 100.17 248,414.16 0.30% NR/NR 0.36
2.400% 2.45% 247,958.17 1.92% 880.57 455.99 NR 0.35
61747MF63 Morgan Stanley Bank 01/11/2023 248,000.00 01/12/2018 247,417.20 100.27 248,659.68 0.30% NR/NR 0.53
2.650% 2.70% 247,937.73 2.15% 3,078.94 721.95 NR 0.52
87165E2L0 Synchrony Bank 04/24/2023 248,000.00 04/27/2020 247,635.44 98.83 245,098.40 0.30% NR/NR 0.82
1.100% 1.15% 247,900.51 2.56% 508.23 -2,802.11 NR 0.81
17312QN96 Citibank 06/28/2023 248,000.00 06/29/2018 247,432.08 100.44 249,081.28 0.30% NR/NR 0.99
3.300% 3.35% 247,887.04 2.85% 67.27 1,194.24 NR 0.97
29278TLY4 EnerBank 09/27/2023 248,000.00 09/30/2019 247,523.84 98.82 245,068.64 0.30% NR/NR 1.24
2.000% 2.05% 247,851.73 2.97% 54.36 -2,783.09 NR 1.21
90348JEV8 UBS Bank USA 10/24/2023 248,000.00 10/25/2018 247,429.60 100.58 249,428.48 0.30% NR/NR 1.32
3.450% 3.50% 247,849.66 3.00% 164.09 1,578.82 NR 1.27
61760ARS0 Morgan Stanley Private Bank 11/08/2023 248,000.00 11/09/2018 247,434.56 100.61 249,500.40 0.30% NR/NR 1.36
3.550% 3.60% 247,846.32 3.09% 1,302.51 1,654.08 NR 1.31 20033AP91 Comenity Capital Bank 02/15/2024 248,000.00 02/19/2019 247,427.12 99.94 247,846.24 0.30% NR/NR 1.63
3.100% 3.15% 247,812.92 3.14% 337.01 33.32 NR 1.56
87270LBU6 TIAA FSB 02/22/2024 248,000.00 02/25/2019 247,427.12 99.76 247,412.24 0.30% NR/NR 1.65
3.000% 3.05% 247,810.82 3.15% 2,629.48 -398.58 NR 1.58
05465DAK4 Axos Bank 03/26/2024 248,000.00 03/26/2020 248,000.00 97.41 241,564.40 0.30% NR/NR 1.74
1.650% 1.65% 248,000.00 3.19% 56.05 -6,435.60 NR 1.70
32100LCB9 First Missouri State Bank 09/13/2024 248,000.00 09/13/2019 248,000.00 96.89 240,292.16 0.30% NR/NR 2.21
1.850% 1.85% 248,000.00 3.32% 1,382.68 -7,707.84 NR 2.14 795451AK9 Sallie Mae Bank 08/11/2026 248,000.00 08/11/2021 248,000.00 91.39 226,634.80 0.30% NR/NR 4.12
1.100% 1.10% 248,000.00 3.36% 1,046.36 -21,365.20 NR 3.99 3,713,395.76 3,683,603.52 4.53% 1.23
Total Certificates of Deposit 3,720,000.00 2.45% 3,718,805.41 2.66% 17,798.60 -35,201.89 1.19 Commercial Paper
89116FG87 Toronto Dominion Holdings USA 07/08/2022 1,250,000.00 10/13/2021 1,248,511.11 99.97 1,249,625.00 1.52% P-1/A-1+ 0.02
0.000% 0.16% 1,249,955.05 1.37% 0.00 -330.05 F1+ 0.02
Run Date: 7/8/2022 - 10:04 AM
Amortizing
15 5.1.b
Packet Pg. 22
Attachment: B: Investment Portfolio Information for City of San Ramon for the Month Ending June 30, Holdings Report
City of San Ramon June 30, 2022
Call Date
Maturity Date
Par Value
Settle Date
Book Value
Original Value
Mkt YTM
Mkt Price
Gain/Loss
% of Port
Fitch
Moody/S&P
Eff. Dur.
WAM
Accrued Int.
Market Value
CUSIP Coupon Rate
Issuer
Book Yield
Remaining
Commercial Paper
89233HGV0 Toyota Motor Credit 07/29/2022 1,250,000.00 11/01/2021 1,247,562.50 99.87 1,248,337.50 1.52% P-1/A-1+ 0.08
0.000% 0.26% 1,249,736.24 1.68% 0.00 -1,398.74 F1 0.08
45685RJU2 ING US Funding LLC 09/28/2022 1,250,000.00 06/28/2022 1,242,940.28 99.44 1,242,950.00 1.52% P-1/A-1 0.25
0.000% 2.22% 1,243,097.16 2.30% 0.00 -147.16 NR 0.25
3,739,013.89 3,740,912.50 4.56% 0.12
Total Commercial Paper 3,750,000.00 0.88% 3,742,788.45 1.78% 0.00 -1,875.95 0.12 Corporate Bonds
166764AB6 Chevron 12/05/2022 1,000,000.00 12/31/2018 967,380.00 99.83 998,340.00 1.21% Aa2/AA- 0.43
2.355% 09/05/2022 3.25% 996,426.78 2.74% 1,700.83 1,913.22 NR 0.38 478160BT0 Johnson & Johnson 03/01/2023 1,000,000.00 03/13/2020 1,024,970.00 99.48 994,780.00 1.23% Aaa/AAA 0.67
2.050% 01/01/2023 1.19% 1,005,634.62 2.84% 6,833.33 -10,854.62 NR 0.60 594918BQ6 Microsoft 08/08/2023 1,000,000.00 05/01/2019 976,240.00 99.01 990,140.00 1.21% Aaa/AAA 1.11
2.000% 06/08/2023 2.59% 993,847.44 2.91% 7,944.44 -3,707.44 AAA 1.04 06406RAL1 Bank of New York Mellon 10/24/2024 1,079,000.00 06/28/2022 1,044,137.51 96.77 1,044,094.35 1.27% A1/A 2.32
2.100% 3.56% 1,044,220.91 3.57% 4,217.09 -126.56 AA- 2.22 64952WDL4 New York Life 01/22/2025 1,000,000.00 01/22/2020 996,410.00 95.65 956,520.00 1.22% Aaa/AA+ 2.57
2.000% 2.08% 998,161.12 3.80% 8,833.33 -41,641.12 AAA 2.43 437076CM2 Home Depot 04/15/2025 500,000.00 03/28/2022 499,125.00 98.12 490,580.00 0.61% A2/A 2.79
2.700% 2.76% 499,198.38 3.41% 3,487.50 -8,618.38 A 2.62 637639AE5 National Securities Clearing 12/07/2025 1,000,000.00 01/07/2021 1,004,130.00 90.22 902,180.00 1.22% Aaa/AA+ 3.44
0.750% 11/07/2025 0.66% 1,002,886.33 3.81% 500.00 -100,706.33 NR 3.33 6,512,392.51 6,376,634.35 7.97% 1.84
Total Corporate Bonds 6,579,000.00 2.27% 6,540,375.59 3.29% 33,516.52 -163,741.23 1.74 LAIF
9807828 LAIF 07/01/2022 2,600,798.52 04/15/2022 2,600,798.52 1.00 2,600,798.52 3.17% NR/NR 0.00
0.860% 0.86% 2,600,798.52 0.86% 0.00 0.00 NR 0.00
2,600,798.52 2,600,798.52 3.17% 0.00
Total LAIF 2,600,798.52 0.86% 2,600,798.52 0.86% 0.00 0.00 0.00 Money Market Funds
Run Date: 7/8/2022 - 10:04 AM
Amortizing
16 5.1.b
Packet Pg. 23
Attachment: B: Investment Portfolio Information for City of San Ramon for the Month Ending June 30, Holdings Report
City of San Ramon June 30, 2022
Call Date
Maturity Date
Par Value
Settle Date
Book Value
Original Value
Mkt YTM
Mkt Price
Gain/Loss
% of Port
Fitch
Moody/S&P
Eff. Dur.
WAM
Accrued Int.
Market Value
CUSIP Coupon Rate
Issuer
Book Yield
Remaining
Money Market Funds
FIGXX Fidelity Govt MMF 07/01/2022 1,973,048.27 1,973,048.27 0.00 1,973,048.27 2.41% Aaa/AAA 0.00
1.200% 1.20% 1,973,048.27 1.20% 2,791.05 0.00 NR 0.00
1,973,048.27 1,973,048.27 2.41% 0.00
Total Money Market Funds 1,973,048.27 1.20% 1,973,048.27 1.20% 2,791.05 0.00 0.00 Municipal Securities
13063DDG0 State of California 10/01/2023 1,000,000.00 11/27/2019 1,015,040.00 99.01 990,110.00 1.23% Aa2/AA- 1.25
2.250% 1.84% 1,004,901.04 3.06% 5,625.00 -14,791.04 AA 1.20 1,015,040.00 990,110.00 1.23% 1.25
Total Municipal Securities 1,000,000.00 1.84% 1,004,901.04 3.06% 5,625.00 -14,791.04 1.20 Supranational Securities
45950KCR9 IFC 10/16/2024 1,060,000.00 01/21/2021 1,100,216.40 96.24 1,020,112.20 1.32% Aaa/AAA 2.30
1.375% 0.35% 1,084,697.95 3.09% 3,036.46 -64,585.75 AAA 2.22 459058JL8 IBRD 10/28/2025 2,035,000.00 02/04/2021 2,033,473.75 91.70 1,866,033.95 2.48% Aaa/AAA 3.33
0.500% 0.52% 2,033,926.97 3.15% 1,780.62 -167,893.02 AAA 3.24 3,133,690.15 2,886,146.15 3.80% 2.97
Total Supranational Securities 3,095,000.00 0.46% 3,118,624.92 3.13% 4,817.08 -232,478.77 2.89 U.S. Agencies
3130AJY52 FHLB 08/12/2022 1,000,000.00 08/14/2020 998,070.00 99.84 998,390.00 1.22% Aaa/AA+ 0.12
0.125% 0.22% 999,887.10 1.51% 482.64 -1,497.10 AAA 0.11 3133EJZH5 FFCB 09/13/2022 1,000,000.00 09/28/2018 992,720.00 100.20 1,002,030.00 1.22% Aaa/AA+ 0.21
2.800% 3.00% 999,627.06 1.78% 8,400.00 2,402.94 AAA 0.20 3135G0T78 FNMA 10/05/2022 1,000,000.00 10/06/2017 999,340.00 99.95 999,530.00 1.22% Aaa/AA+ 0.27
2.000% 2.01% 999,965.15 2.17% 4,777.78 -435.15 AAA 0.26 3135G0T78 FNMA 10/05/2022 1,000,000.00 10/16/2017 1,001,530.00 99.95 999,530.00 1.22% Aaa/AA+ 0.27
2.000% 1.97% 1,000,081.25 2.17% 4,777.78 -551.25 AAA 0.26 3133EKHN9 FFCB 10/18/2022 1,000,000.00 05/03/2019 999,099.00 100.08 1,000,750.00 1.22% Aaa/AA+ 0.30
2.330% 2.36% 999,921.84 2.07% 4,724.72 828.16 AAA 0.30
3133EHM91 FFCB 11/01/2022 1,000,000.00 11/30/2017 996,270.00 100.05 1,000,540.00 1.22% Aaa/AA+ 0.34
2.080% 2.16% 999,745.16 1.91% 3,466.67 794.84 AAA 0.33
Run Date: 7/8/2022 - 10:04 AM
Amortizing
17 5.1.b
Packet Pg. 24
Attachment: B: Investment Portfolio Information for City of San Ramon for the Month Ending June 30, Holdings Report
City of San Ramon June 30, 2022
Call Date
Maturity Date
Par Value
Settle Date
Book Value
Original Value
Mkt YTM
Mkt Price
Gain/Loss
% of Port
Fitch
Moody/S&P
Eff. Dur.
WAM
Accrued Int.
Market Value
CUSIP Coupon Rate
Issuer
Book Yield
Remaining
U.S. Agencies
3133ELZF4 FFCB 11/14/2022 2,000,000.00 05/14/2020 1,999,000.00 99.21 1,984,100.00 2.44% Aaa/AA+ 0.38
0.270% 0.29% 1,999,851.11 2.42% 705.00 -15,751.11 AAA 0.37 3130A3KM5 FHLB 12/09/2022 1,000,000.00 12/22/2017 1,008,070.00 100.09 1,000,860.00 1.22% Aaa/AA+ 0.44
2.500% 2.33% 1,000,718.04 2.30% 1,527.78 141.96 AAA 0.44 3133EFUJ4 FFCB 12/29/2022 1,275,000.00 05/01/2020 1,334,899.50 99.96 1,274,426.25 1.57% Aaa/AA+ 0.50
2.150% 0.37% 1,286,192.08 2.24% 152.29 -11,765.83 AAA 0.49 3135G0T94 FNMA 01/19/2023 1,000,000.00 01/23/2018 994,220.00 99.94 999,410.00 1.22% Aaa/AA+ 0.56
2.375% 2.50% 999,359.57 2.48% 10,687.50 50.43 AAA 0.54
3134GVQ68 FHLMC 06/16/2023 2,000,000.00 06/16/2020 2,000,000.00 97.66 1,953,140.00 2.44% Aaa/AA+ 0.96
0.375% 06/16/2022 0.38% 2,000,000.00 2.86% 312.50 -46,860.00 AAA 0.94 313383YJ4 FHLB 09/08/2023 1,000,000.00 10/23/2018 1,009,790.00 100.48 1,004,830.00 1.22% Aaa/AA+ 1.19
3.375% 3.16% 1,002,387.53 2.96% 10,593.75 2,442.47 AAA 1.15 3136G0X97 FNMA 10/30/2023 2,000,000.00 10/09/2019 2,055,480.00 98.88 1,977,620.00 2.46% Aaa/AA+ 1.33
2.125% 1.42% 2,018,227.52 2.99% 7,201.39 -40,607.52 AAA 1.30 3133EKKU9 FFCB 11/08/2023 1,000,000.00 06/04/2019 1,013,870.00 99.22 992,220.00 1.22% Aaa/AA+ 1.36
2.300% 1.97% 1,004,246.27 2.89% 3,386.11 -12,026.27 AAA 1.32 3133EJWW5 FFCB 12/14/2023 1,005,000.00 12/31/2018 1,013,462.10 100.10 1,006,035.15 1.23% Aaa/AA+ 1.46
2.950% 2.77% 1,007,485.50 2.88% 1,400.02 -1,450.35 AAA 1.41 3133EKQU3 FFCB 06/13/2024 1,000,000.00 06/20/2019 998,320.00 98.24 982,380.00 1.22% Aaa/AA+ 1.96
1.950% 1.99% 999,341.31 2.88% 975.00 -16,961.31 AAA 1.90 3133EKA63 FFCB 08/16/2024 2,000,000.00 08/16/2019 1,993,680.00 97.29 1,945,780.00 2.43% Aaa/AA+ 2.13
1.600% 1.67% 1,997,310.49 2.92% 12,000.00 -51,530.49 AAA 2.06 3133EKP75 FFCB 09/17/2024 2,000,000.00 09/17/2019 1,997,420.00 97.14 1,942,780.00 2.44% Aaa/AA+ 2.22
1.600% 1.63% 1,998,857.63 2.94% 9,244.44 -56,077.63 AAA 2.14 3133EK4Y9 FFCB 11/01/2024 1,043,000.00 05/07/2020 1,090,612.96 97.02 1,011,929.03 1.30% Aaa/AA+ 2.34
1.650% 0.62% 1,067,809.48 2.98% 2,868.25 -55,880.45 AAA 2.26 3130AQXY4 FHLB 02/28/2025 2,000,000.00 02/28/2022 2,000,000.00 97.52 1,950,460.00 2.44% Aaa/AA+ 2.67
2.000% 07/28/2022 2.00% 2,000,000.00 2.97% 13,666.67 -49,540.00 AAA 2.33 880591EW8 TVA 05/15/2025 2,000,000.00 05/11/2020 2,002,840.00 93.53 1,870,660.00 2.44% Aaa/AA+ 2.88
0.750% 0.72% 2,001,629.38 3.12% 1,916.67 -130,969.38 AAA 2.80 3137EAEX3 FHLMC 09/23/2025 2,000,000.00 10/06/2020 1,991,000.00 91.73 1,834,580.00 2.43% Aaa/AA+ 3.24
0.375% 0.47% 1,994,142.70 3.08% 2,041.67 -159,562.70 AAA 3.17 3135G06G3 FNMA 11/07/2025 2,000,000.00 01/20/2021 2,000,620.00 91.81 1,836,200.00 2.44% Aaa/AA+ 3.36
0.500% 0.49% 2,000,433.32 3.09% 1,500.00 -164,233.32 AAA 3.28 3130AL7M0 FHLB 02/24/2026 2,000,000.00 02/24/2021 2,000,000.00 92.09 1,841,740.00 2.44% Aaa/AA+ 3.66
0.625% 08/24/2022 0.63% 2,000,000.00 2.93% 4,409.72 -158,260.00 AAA 3.55 3130AQW66 FHLB 02/25/2027 1,000,000.00 02/25/2022 1,000,000.00 95.18 951,830.00 1.22% Aaa/AA+ 4.66
2.080% 08/25/2022 2.08% 1,000,000.00 3.20% 7,280.00 -48,170.00 AAA 3.84 Run Date: 7/8/2022 - 10:04 AM
Amortizing
18 5.1.b
Packet Pg. 25
Attachment: B: Investment Portfolio Information for City of San Ramon for the Month Ending June 30, Holdings Report
City of San Ramon June 30, 2022
Call Date
Maturity Date
Par Value
Settle Date
Book Value
Original Value
Mkt YTM
Mkt Price
Gain/Loss
% of Port
Fitch
Moody/S&P
Eff. Dur.
WAM
Accrued Int.
Market Value
CUSIP Coupon Rate
Issuer
Book Yield
Remaining
35,490,313.56 34,361,750.43 43.13% 1.75
Total U.S. Agencies 35,323,000.00 1.39% 35,377,219.47 2.71% 118,498.35 -1,015,469.06 1.67 U.S. Treasuries
912796S59 U.S. Treasury 07/28/2022 2,000,000.00 02/08/2022 1,995,136.12 99.92 1,998,380.00 2.44% P-1/A-1+ 0.08
0.000% 0.52% 1,999,198.89 1.06% 0.00 -818.89 F1+ 0.08
912796YF0 U.S. Treasury 10/25/2022 1,000,000.00 06/29/2022 993,239.58 99.36 993,550.00 1.21% NR/NR 0.32
0.000% 2.11% 993,297.86 2.03% 0.00 252.14 NR 0.00
91282CAW1 U.S. Treasury 11/15/2023 1,000,000.00 10/29/2021 993,750.00 96.37 963,670.00 1.21% Aaa/AA+ 1.38
0.250% 0.56% 995,791.50 2.97% 319.29 -32,121.50 AAA 1.35 91282CCC3 U.S. Treasury 05/15/2024 2,000,000.00 08/17/2021 1,993,671.88 95.04 1,900,860.00 2.43% Aaa/AA+ 1.88
0.250% 0.37% 1,995,673.89 2.99% 638.59 -94,813.89 AAA 1.84 912828YM6 U.S. Treasury 10/31/2024 2,000,000.00 04/06/2021 2,067,656.26 96.61 1,932,260.00 2.49% Aaa/AA+ 2.34
1.500% 0.54% 2,044,308.62 3.01% 5,054.35 -112,048.62 AAA 2.27 912828G38 U.S. Treasury 11/15/2024 2,000,000.00 07/23/2021 2,118,750.00 98.31 1,966,100.00 2.54% Aaa/AA+ 2.38
2.250% 0.44% 2,085,213.67 2.99% 5,747.28 -119,113.67 AAA 2.29 912828ZF0 U.S. Treasury 03/31/2025 2,000,000.00 07/23/2021 1,998,359.38 93.33 1,866,560.00 2.44% Aaa/AA+ 2.75
0.500% 0.52% 1,998,775.92 3.05% 2,513.66 -132,215.92 AAA 2.69 91282CAT8 U.S. Treasury 10/31/2025 2,000,000.00 04/06/2021 1,946,875.00 91.13 1,822,500.00 2.39% Aaa/AA+ 3.34
0.250% 0.84% 1,961,198.70 3.07% 842.39 -138,698.70 AAA 3.28 912828M56 U.S. Treasury 11/15/2025 2,000,000.00 02/07/2022 2,041,015.62 97.40 1,947,960.00 2.48% Aaa/AA+ 3.38
2.250% 1.69% 2,036,756.19 3.07% 5,747.28 -88,796.19 AAA 3.22 912828R36 U.S. Treasury 05/15/2026 2,000,000.00 06/07/2022 1,897,500.00 94.77 1,895,400.00 2.32% Aaa/AA+ 3.88
1.625% 3.01% 1,899,139.43 3.07% 4,150.82 -3,739.43 AAA 3.71 91282CCW9 U.S. Treasury 08/31/2026 1,000,000.00 08/31/2021 997,798.42 91.02 910,230.00 1.22% Aaa/AA+ 4.17
0.750% 0.80% 998,163.74 3.06% 2,506.79 -87,933.74 AAA 4.04 91282CCZ2 U.S. Treasury 09/30/2026 1,000,000.00 10/13/2021 990,351.56 91.33 913,280.00 1.21% Aaa/AA+ 4.25
0.875% 1.08% 991,735.23 3.07% 2,199.45 -78,455.23 AAA 4.11 91282CDG3 U.S. Treasury 10/31/2026 2,000,000.00 02/07/2022 1,941,093.76 92.18 1,843,520.00 2.37% Aaa/AA+ 4.34
1.125% 1.78% 1,945,971.34 3.07% 3,790.76 -102,451.34 AAA 4.17 912828U24 U.S. Treasury 11/15/2026 2,000,000.00 03/14/2022 2,003,593.76 95.61 1,912,180.00 2.44% Aaa/AA+ 4.38
2.000% 1.96% 2,003,366.38 3.08% 5,108.70 -91,186.38 AAA 4.14 23,978,791.34 22,866,450.00 29.20% 2.81
Total U.S. Treasuries 24,000,000.00 1.15% 23,948,591.35 2.83% 38,619.36 -1,082,141.36 2.69 Run Date: 7/8/2022 - 10:04 AM
Amortizing
19 5.1.b
Packet Pg. 26
Attachment: B: Investment Portfolio Information for City of San Ramon for the Month Ending June 30, Holdings Report
City of San Ramon June 30, 2022
Call Date
Maturity Date
Par Value
Settle Date
Book Value
Original Value
Mkt YTM
Mkt Price
Gain/Loss
% of Port
Fitch
Moody/S&P
Eff. Dur.
WAM
Accrued Int.
Market Value
CUSIP Coupon Rate
Issuer
Book Yield
Remaining
82,156,484.00 79,479,453.74 100.00% 1.91
TOTAL PORTFOLIO 82,040,846.79 1.36% 82,025,153.03 2.67% 221,665.96 -2,545,699.30 1.83 TOTAL MARKET VALUE PLUS ACCRUED INTEREST 79,701,119.70
Run Date: 7/8/2022 - 10:04 AM
Amortizing
20 5.1.b
Packet Pg. 27
Attachment: B: Investment Portfolio Information for City of San Ramon for the Month Ending June 30, Maturity Report
City of San Ramon June 30, 2022
CUSIP Date
Purchase
Value
Book
Rate
Coupon
Date
Maturity
Par
Remaining
Term Value
Market
Issuer YTM
Days to
Maturity
Book
FIGXX Fidelity Govt MMF 1,973,048.27 1.200% 07/01/2022 1,973,048.27 1 1,973,048.27 1.20% 1 9807828 LAIF 06/16/2021 2,600,798.52 0.860% 07/01/2022 2,600,798.52 1 2,600,798.52 0.86% 1 89116FG87 Toronto Dominion Holdings USA 10/13/2021 1,249,955.05 0.000% 07/08/2022 1,250,000.00 260 1,249,625.00 0.16% 8 912796S59 U.S. Treasury 02/08/2022 1,999,198.89 0.000% 07/28/2022 2,000,000.00 142 1,998,380.00 0.52% 28 89233HGV0 Toyota Motor Credit 11/01/2021 1,249,736.24 0.000% 07/29/2022 1,250,000.00 241 1,248,337.50 0.26% 29 02587DV47 American Express National Bank 08/09/2017 247,987.55 2.350% 08/08/2022 248,000.00 1,786 248,161.20 2.40% 39 3130AJY52 FHLB 08/14/2020 999,887.10 0.125% 08/12/2022 1,000,000.00 685 998,390.00 0.22% 43 38148PMR5 Goldman Sachs Bank 08/17/2017 247,984.99 2.350% 08/16/2022 248,000.00 1,778 248,186.00 2.40% 47 254673BZ8 Discover Bank 09/08/2017 247,977.97 2.350% 09/07/2022 248,000.00 1,756 248,255.44 2.40% 69 3133EJZH5 FFCB 09/28/2018 999,627.06 2.800% 09/13/2022 1,000,000.00 1,371 1,002,030.00 3.00% 75 45685RJU2 ING US Funding LLC 06/28/2022 1,243,097.16 0.000% 09/28/2022 1,250,000.00 2 1,242,950.00 2.22% 90 3135G0T78 FNMA 10/06/2017 1,000,081.25 2.000% 10/05/2022 1,000,000.00 1,728 999,530.00 1.97% 97 3135G0T78 FNMA 10/06/2017 999,965.15 2.000% 10/05/2022 1,000,000.00 1,728 999,530.00 2.01% 97 3133EKHN9 FFCB 05/03/2019 999,921.84 2.330% 10/18/2022 1,000,000.00 1,154 1,000,750.00 2.36% 110 912796YF0 U.S. Treasury 06/29/2022 993,297.86 0.000% 10/25/2022 1,000,000.00 1 993,550.00 2.11% 117 3133EHM91 FFCB 11/30/2017 999,745.16 2.080% 11/01/2022 1,000,000.00 1,673 1,000,540.00 2.16% 124 14042RJZ5 Capital One Bank NA 11/09/2017 247,958.17 2.400% 11/08/2022 248,000.00 1,694 248,414.16 2.45% 131 3133ELZF4 FFCB 05/14/2020 1,999,851.11 0.270% 11/14/2022 2,000,000.00 777 1,984,100.00 0.29% 137 166764AB6 Chevron 12/31/2018 996,426.78 2.355% 12/05/2022 1,000,000.00 1,277 998,340.00 3.25% 158 3130A3KM5 FHLB 12/22/2017 1,000,718.04 2.500% 12/09/2022 1,000,000.00 1,651 1,000,860.00 2.33% 162 3133EFUJ4 FFCB 05/01/2020 1,286,192.08 2.150% 12/29/2022 1,275,000.00 790 1,274,426.25 0.37% 182 61747MF63 Morgan Stanley Bank 01/12/2018 247,937.73 2.650% 01/11/2023 248,000.00 1,630 248,659.68 2.70% 195 3135G0T94 FNMA 01/23/2018 999,359.57 2.375% 01/19/2023 1,000,000.00 1,619 999,410.00 2.50% 203 478160BT0 Johnson & Johnson 03/13/2020 1,005,634.62 2.050% 03/01/2023 1,000,000.00 839 994,780.00 1.19% 244 87165E2L0 Synchrony Bank 04/27/2020 247,900.51 1.100% 04/24/2023 248,000.00 794 245,098.40 1.15% 298 3134GVQ68 FHLMC 06/16/2020 2,000,000.00 0.375% 06/16/2023 2,000,000.00 744 1,953,140.00 0.38% 351 17312QN96 Citibank 06/29/2018 247,887.04 3.300% 06/28/2023 248,000.00 1,462 249,081.28 3.35% 363 594918BQ6 Microsoft 05/01/2019 993,847.44 2.000% 08/08/2023 1,000,000.00 1,156 990,140.00 2.59% 404 313383YJ4 FHLB 10/23/2018 1,002,387.53 3.375% 09/08/2023 1,000,000.00 1,346 1,004,830.00 3.16% 435 29278TLY4 EnerBank 09/30/2019 247,851.73 2.000% 09/27/2023 248,000.00 1,004 245,068.64 2.05% 454 13063DDG0 State of California 11/27/2019 1,004,901.04 2.250% 10/01/2023 1,000,000.00 946 990,110.00 1.84% 458 90348JEV8 UBS Bank USA 10/25/2018 247,849.66 3.450% 10/24/2023 248,000.00 1,344 249,428.48 3.50% 481 3136G0X97 FNMA 10/09/2019 2,018,227.52 2.125% 10/30/2023 2,000,000.00 995 1,977,620.00 1.42% 487 61760ARS0 Morgan Stanley Private Bank 11/09/2018 247,846.32 3.550% 11/08/2023 248,000.00 1,329 249,500.40 3.60% 496 3133EKKU9 FFCB 06/04/2019 1,004,246.27 2.300% 11/08/2023 1,000,000.00 1,122 992,220.00 1.97% 496 91282CAW1 U.S. Treasury 10/29/2021 995,791.50 0.250% 11/15/2023 1,000,000.00 244 963,670.00 0.56% 503 Run Date: 7/8/2022 - 10:04 AM
Amortizing
21 5.1.b
Packet Pg. 28
Attachment: B: Investment Portfolio Information for City of San Ramon for the Month Ending June 30, Maturity Report
City of San Ramon June 30, 2022
CUSIP Date
Purchase
Value
Book
Rate
Coupon
Date
Maturity
Par
Remaining
Term Value
Market
Issuer YTM
Days to
Maturity
Book
3133EJWW5 FFCB 12/31/2018 1,007,485.50 2.950% 12/14/2023 1,005,000.00 1,277 1,006,035.15 2.77% 532 20033AP91 Comenity Capital Bank 02/19/2019 247,812.92 3.100% 02/15/2024 248,000.00 1,227 247,846.24 3.15% 595 87270LBU6 TIAA FSB 02/25/2019 247,810.82 3.000% 02/22/2024 248,000.00 1,221 247,412.24 3.05% 602 05465DAK4 Axos Bank 03/26/2020 248,000.00 1.650% 03/26/2024 248,000.00 826 241,564.40 1.65% 635 91282CCC3 U.S. Treasury 08/17/2021 1,995,673.89 0.250% 05/15/2024 2,000,000.00 317 1,900,860.00 0.37% 685 3133EKQU3 FFCB 06/20/2019 999,341.31 1.950% 06/13/2024 1,000,000.00 1,106 982,380.00 1.99% 714 3133EKA63 FFCB 08/16/2019 1,997,310.49 1.600% 08/16/2024 2,000,000.00 1,049 1,945,780.00 1.67% 778 32100LCB9 First Missouri State Bank 09/13/2019 248,000.00 1.850% 09/13/2024 248,000.00 1,021 240,292.16 1.85% 806 3133EKP75 FFCB 09/17/2019 1,998,857.63 1.600% 09/17/2024 2,000,000.00 1,017 1,942,780.00 1.63% 810 45950KCR9 IFC 01/21/2021 1,084,697.95 1.375% 10/16/2024 1,060,000.00 525 1,020,112.20 0.35% 839 06406RAL1 Bank of New York Mellon 06/28/2022 1,044,220.91 2.100% 10/24/2024 1,079,000.00 2 1,044,094.35 3.56% 847 912828YM6 U.S. Treasury 04/06/2021 2,044,308.62 1.500% 10/31/2024 2,000,000.00 450 1,932,260.00 0.54% 854 3133EK4Y9 FFCB 05/07/2020 1,067,809.48 1.650% 11/01/2024 1,043,000.00 784 1,011,929.03 0.62% 855 912828G38 U.S. Treasury 07/23/2021 2,085,213.67 2.250% 11/15/2024 2,000,000.00 342 1,966,100.00 0.44% 869 64952WDL4 New York Life 01/22/2020 998,161.12 2.000% 01/22/2025 1,000,000.00 890 956,520.00 2.08% 937 3130AQXY4 FHLB 02/28/2022 2,000,000.00 2.000% 02/28/2025 2,000,000.00 122 1,950,460.00 2.00% 974 912828ZF0 U.S. Treasury 07/23/2021 1,998,775.92 0.500% 03/31/2025 2,000,000.00 342 1,866,560.00 0.52% 1,005 437076CM2 Home Depot 03/28/2022 499,198.38 2.700% 04/15/2025 500,000.00 94 490,580.00 2.76% 1,020 880591EW8 TVA 05/11/2020 2,001,629.38 0.750% 05/15/2025 2,000,000.00 780 1,870,660.00 0.72% 1,050 3137EAEX3 FHLMC 10/06/2020 1,994,142.70 0.375% 09/23/2025 2,000,000.00 632 1,834,580.00 0.47% 1,181 459058JL8 IBRD 02/04/2021 2,033,926.97 0.500% 10/28/2025 2,035,000.00 511 1,866,033.95 0.52% 1,216 91282CAT8 U.S. Treasury 04/06/2021 1,961,198.70 0.250% 10/31/2025 2,000,000.00 450 1,822,500.00 0.84% 1,219 3135G06G3 FNMA 01/20/2021 2,000,433.32 0.500% 11/07/2025 2,000,000.00 526 1,836,200.00 0.49% 1,226 912828M56 U.S. Treasury 02/07/2022 2,036,756.19 2.250% 11/15/2025 2,000,000.00 143 1,947,960.00 1.69% 1,234 637639AE5 National Securities Clearing 01/07/2021 1,002,886.33 0.750% 12/07/2025 1,000,000.00 539 902,180.00 0.66% 1,256 3130AL7M0 FHLB 02/24/2021 2,000,000.00 0.625% 02/24/2026 2,000,000.00 491 1,841,740.00 0.63% 1,335 912828R36 U.S. Treasury 06/07/2022 1,899,139.43 1.625% 05/15/2026 2,000,000.00 23 1,895,400.00 3.01% 1,415 795451AK9 Sallie Mae Bank 08/11/2021 248,000.00 1.100% 08/11/2026 248,000.00 323 226,634.80 1.10% 1,503 91282CCW9 U.S. Treasury 08/31/2021 998,163.74 0.750% 08/31/2026 1,000,000.00 303 910,230.00 0.80% 1,523 91282CCZ2 U.S. Treasury 10/13/2021 991,735.23 0.875% 09/30/2026 1,000,000.00 260 913,280.00 1.08% 1,553 91282CDG3 U.S. Treasury 02/07/2022 1,945,971.34 1.125% 10/31/2026 2,000,000.00 143 1,843,520.00 1.78% 1,584 912828U24 U.S. Treasury 03/14/2022 2,003,366.38 2.000% 11/15/2026 2,000,000.00 108 1,912,180.00 1.96% 1,599 3130AQW66 FHLB 02/25/2022 1,000,000.00 2.080% 02/25/2027 1,000,000.00 125 951,830.00 2.08% 1,701 Net Maturities and Averages 82,025,153.03 82,040,846.79 79,479,453.74 1.36% 697 Run Date: 7/8/2022 - 10:04 AM
Amortizing
22 5.1.b
Packet Pg. 29
Attachment: B: Investment Portfolio Information for City of San Ramon for the Month Ending June 30, Summary by Issuer
City of San Ramon June 30, 2022
Issuer Investments
Number of Par
Value
Book
Value
% of
Portfolio YTM Maturity
Book Days to
U.S. Treasury 14 24,000,000.00 23,948,591.35 29.20 1.15 1,025 FFCB 11 14,323,000.00 14,360,387.93 17.51 1.57 463
FHLB 6 8,000,000.00 8,002,992.67 9.76 1.63 870
FNMA 5 7,000,000.00 7,018,066.79 8.56 1.47 546
FHLMC 2 4,000,000.00 3,994,142.70 4.87 0.42 765
LAIF 1 2,600,798.52 2,600,798.52 3.17 0.86 1
IBRD 1 2,035,000.00 2,033,926.97 2.48 0.52 1,216
TVA 1 2,000,000.00 2,001,629.38 2.44 0.72 1,050
Fidelity Govt MMF 1 1,973,048.27 1,973,048.27 2.41 1.20 1 Toronto Dominion Bank 1 1,250,000.00 1,249,955.05 1.52 0.16 8 Toyota 1 1,250,000.00 1,249,736.24 1.52 0.26 29
ING US Funding 1 1,250,000.00 1,243,097.16 1.52 2.22 90 IFC 1 1,060,000.00 1,084,697.95 1.32 0.35 839
Bank of New York Mellon 1 1,079,000.00 1,044,220.91 1.27 3.56 847 Johnson & Johnson 1 1,000,000.00 1,005,634.62 1.23 1.19 244 State of California 1 1,000,000.00 1,004,901.04 1.23 1.84 458 National Securities Clearing 1 1,000,000.00 1,002,886.33 1.22 0.66 1,256 New York Life 1 1,000,000.00 998,161.12 1.22 2.08 937
Chevron 1 1,000,000.00 996,426.78 1.21 3.25 158
Microsoft 1 1,000,000.00 993,847.44 1.21 2.59 404
Home Depot 1 500,000.00 499,198.38 0.61 2.76 1,020
Sallie Mae Bank 1 248,000.00 248,000.00 0.30 1.10 1,503 Discover Bank 1 248,000.00 247,977.97 0.30 2.40 69
American Express National Bank 1 248,000.00 247,987.55 0.30 2.40 39 Axos Bank 1 248,000.00 248,000.00 0.30 1.65 635
Goldman Sachs Bank 1 248,000.00 247,984.99 0.30 2.40 47 First Missouri State Bank 1 248,000.00 248,000.00 0.30 1.85 806 Capital One Bank NA 1 248,000.00 247,958.17 0.30 2.45 131 Citigroup 1 248,000.00 247,887.04 0.30 3.35 363
Morgan Stanley Bank 1 248,000.00 247,937.73 0.30 2.70 195 Synchrony Bank 1 248,000.00 247,900.51 0.30 1.15 298
TIAA FSB 1 248,000.00 247,810.82 0.30 3.05 602
UBS Bank USA 1 248,000.00 247,849.66 0.30 3.50 481
Morgan Stanley Private Bank 1 248,000.00 247,846.32 0.30 3.60 496 Comenity Capital Bank 1 248,000.00 247,812.92 0.30 3.15 595 EnerBank 1 248,000.00 247,851.73 0.30 2.05 454
Run Date: 7/8/2022 - 10:04 AM
Amortizing
23 5.1.b
Packet Pg. 30
Attachment: B: Investment Portfolio Information for City of San Ramon for the Month Ending June 30, Summary by Issuer
City of San Ramon June 30, 2022
Issuer Investments
Number of Par
Value
Book
Value
% of
Portfolio YTM Maturity
Book Days to
Total and Average 69 82,040,846.79 82,025,153.03 100.00% 1.36 697 Run Date: 7/8/2022 - 10:04 AM
Amortizing
24 5.1.b
Packet Pg. 31
Attachment: B: Investment Portfolio Information for City of San Ramon for the Month Ending June 30, Income Earned Summary
City of San Ramon June 30, 2022
June 30 Month End Fiscal Year To Date
Interest
Interest Received/Purchased
Plus Accrued Interest at End of Period
Less Accrued Interest at Beginning of Period
Interest Earned During Period
Total Adjustments for Amortization/Accretion
Total Capital Gains or Losses
Total Earnings During Period
86,367.60 1,046,831.04
221,665.96 221,665.96
-218,729.79 -237,134.27
89,303.77 1,031,362.73
-3,561.88 -70,097.79
0.00 5,093.06
85,741.89 966,358.00
Run Date: 7/8/2022 - 10:04 AM
Amortizing
25 5.1.b
Packet Pg. 32
Attachment: B: Investment Portfolio Information for City of San Ramon for the Month Ending June 30, Income Earned
City of San Ramon June 01, 2022 - June 30, 2022
CUSIP Value
Ending Par
Date
Maturity
Book Value
Beginning
Value
Ending Book
Accrued
Beginning
/Purchased
Int.Received
Accrued
Ending
Issuer Earned
Interest Amortization/
Accretion Earned
Net Income
Certificates of Deposit
33847E2J5 Flagstar Bank 06/13/2022 0.00 248,000.00 0.00 2,904.66 3,108.49 0.00 203.83 0.00 203.83 02587DV47 American Express National Bank 08/08/2022 248,000.00 247,977.97 247,987.55 1,804.28 0.00 2,283.30 479.02 9.58 488.60 38148PMR5 Goldman Sachs Bank 08/16/2022 248,000.00 247,975.41 247,984.99 1,676.55 0.00 2,155.56 479.01 9.58 488.59 254673BZ8 Discover Bank 09/07/2022 248,000.00 247,968.39 247,977.97 1,373.17 0.00 1,852.19 479.02 9.58 488.60 14042RJZ5 Capital One Bank NA 11/08/2022 248,000.00 247,948.59 247,958.17 391.36 0.00 880.57 489.21 9.58 498.79 61747MF63 Morgan Stanley Bank 01/11/2023 248,000.00 247,928.15 247,937.73 2,538.77 0.00 3,078.94 540.17 9.58 549.75 87165E2L0 Synchrony Bank 04/24/2023 248,000.00 247,890.50 247,900.51 284.01 0.00 508.23 224.22 10.02 234.24 17312QN96 Citibank 06/28/2023 248,000.00 247,877.70 247,887.04 3,475.40 4,080.79 67.27 672.66 9.34 682.00 29278TLY4 EnerBank 09/27/2023 248,000.00 247,841.93 247,851.73 67.95 421.26 54.36 407.67 9.80 417.47 90348JEV8 UBS Bank USA 10/24/2023 248,000.00 247,840.29 247,849.66 187.53 726.67 164.09 703.23 9.38 712.61 61760ARS0 Morgan Stanley Private Bank 11/08/2023 248,000.00 247,837.03 247,846.32 578.89 0.00 1,302.51 723.62 9.29 732.91 20033AP91 Comenity Capital Bank 02/15/2024 248,000.00 247,803.49 247,812.92 358.07 652.95 337.01 631.89 9.43 641.32 87270LBU6 TIAA FSB 02/22/2024 248,000.00 247,801.39 247,810.82 2,017.97 0.00 2,629.48 611.51 9.43 620.94 05465DAK4 Axos Bank 03/26/2024 248,000.00 248,000.00 248,000.00 67.27 347.54 56.05 336.32 0.00 336.32 32100LCB9 First Missouri State Bank 09/13/2024 248,000.00 248,000.00 248,000.00 1,005.59 0.00 1,382.68 377.09 0.00 377.09 795451AK9 Sallie Mae Bank 08/11/2026 248,000.00 248,000.00 248,000.00 822.14 0.00 1,046.36 224.22 0.00 224.22 Certificates of Deposit - Sub Total 3,720,000.00 3,966,690.82 3,718,805.41 19,553.61 9,337.70 17,798.60 7,582.69 114.58 7,697.27 Commercial Paper
78015DFQ8 Royal Bank of Canada, NY 06/24/2022 0.00 1,249,600.69 0.00 0.00 0.00 0.00 0.00 399.31 399.31 89116FG87 Toronto Dominion Holdings USA 07/08/2022 1,250,000.00 1,249,792.12 1,249,955.05 0.00 0.00 0.00 0.00 162.94 162.94 89233HGV0 Toyota Motor Credit 07/29/2022 1,250,000.00 1,249,472.48 1,249,736.24 0.00 0.00 0.00 0.00 263.76 263.76 45685RJU2 ING US Funding LLC 09/28/2022 1,250,000.00 0.00 1,243,097.16 0.00 0.00 0.00 0.00 156.88 156.88 Commercial Paper - Sub Total 3,750,000.00 3,748,865.29 3,742,788.45 0.00 0.00 0.00 0.00 982.88 982.88 Corporate Bonds
59217GDB2 MetLife 06/17/2022 0.00 999,980.00 0.00 10,933.33 12,000.00 0.00 1,066.67 20.00 1,086.67 166764AB6 Chevron 12/05/2022 1,000,000.00 995,735.19 996,426.78 11,513.33 11,775.00 1,700.83 1,962.50 691.59 2,654.09 478160BT0 Johnson & Johnson 03/01/2023 1,000,000.00 1,006,312.64 1,005,634.62 5,125.00 0.00 6,833.33 1,708.33 -678.02 1,030.31 594918BQ6 Microsoft 08/08/2023 1,000,000.00 993,399.14 993,847.44 6,277.78 0.00 7,944.44 1,666.66 448.30 2,114.96 06406RAL1 Bank of New York Mellon 10/24/2024 1,079,000.00 0.00 1,044,220.91 0.00 -4,028.27 4,217.09 188.82 83.40 272.22 64952WDL4 New York Life 01/22/2025 1,000,000.00 998,103.28 998,161.12 7,166.67 0.00 8,833.33 1,666.66 57.84 1,724.50 437076CM2 Home Depot 04/15/2025 500,000.00 499,175.25 499,198.38 2,362.50 0.00 3,487.50 1,125.00 23.13 1,148.13 637639AE5 National Securities Clearing 12/07/2025 1,000,000.00 1,002,954.00 1,002,886.33 3,625.00 3,750.00 500.00 625.00 -67.67 557.33 Run Date: 7/8/2022 - 10:04 AM
Amortizing
26 5.1.b
Packet Pg. 33
Attachment: B: Investment Portfolio Information for City of San Ramon for the Month Ending June 30, Income Earned
City of San Ramon June 01, 2022 - June 30, 2022
CUSIP Value
Ending Par
Date
Maturity
Book Value
Beginning
Value
Ending Book
Accrued
Beginning
/Purchased
Int.Received
Accrued
Ending
Issuer Earned
Interest Amortization/
Accretion Earned
Net Income
Corporate Bonds - Sub Total 6,579,000.00 6,495,659.51 6,540,375.59 47,003.61 23,496.73 33,516.52 10,009.64 578.57 10,588.21 LAIF
9807828 LAIF 07/01/2022 2,600,798.52 4,600,798.52 2,600,798.52 0.00 0.00 0.00 0.00 0.00 0.00 LAIF - Sub Total 2,600,798.52 4,600,798.52 2,600,798.52 0.00 0.00 0.00 0.00 0.00 0.00 Money Market Funds
FIGXX Fidelity Govt MMF 07/01/2022 1,973,048.27 2,566,498.04 1,973,048.27 1,034.42 1,034.42 2,791.05 2,791.05 0.00 2,791.05 Money Market Funds - Sub Total 1,973,048.27 2,566,498.04 1,973,048.27 1,034.42 1,034.42 2,791.05 2,791.05 0.00 2,791.05 Municipal Securities
13063DDG0 State of California 10/01/2023 1,000,000.00 1,005,216.18 1,004,901.04 3,750.00 0.00 5,625.00 1,875.00 -315.14 1,559.86 Municipal Securities - Sub Total 1,000,000.00 1,005,216.18 1,004,901.04 3,750.00 0.00 5,625.00 1,875.00 -315.14 1,559.86 Supranational Securities
45950KCR9 IFC 10/16/2024 1,060,000.00 1,085,594.97 1,084,697.95 1,821.88 0.00 3,036.46 1,214.58 -897.02 317.56 459058JL8 IBRD 10/28/2025 2,035,000.00 2,033,900.99 2,033,926.97 932.71 0.00 1,780.62 847.91 25.97 873.88 Supranational Securities - Sub Total 3,095,000.00 3,119,495.97 3,118,624.92 2,754.59 0.00 4,817.08 2,062.49 -871.05 1,191.44 U.S. Agencies
3130AJY52 FHLB 08/12/2022 1,000,000.00 999,809.15 999,887.10 378.47 0.00 482.64 104.17 77.95 182.12 3133EJZH5 FFCB 09/13/2022 1,000,000.00 999,478.91 999,627.06 6,066.67 0.00 8,400.00 2,333.33 148.15 2,481.48 3135G0T78 FNMA 10/05/2022 2,000,000.00 2,000,060.56 2,000,046.39 6,222.22 0.00 9,555.56 3,333.34 -14.16 3,319.18 3133EKHN9 FFCB 10/18/2022 1,000,000.00 999,900.85 999,921.84 2,783.06 0.00 4,724.72 1,941.66 20.99 1,962.65 3133EHM91 FFCB 11/01/2022 1,000,000.00 999,681.97 999,745.16 1,733.33 0.00 3,466.67 1,733.34 63.18 1,796.52 3133ELZF4 FFCB 11/14/2022 2,000,000.00 1,999,818.89 1,999,851.11 255.00 0.00 705.00 450.00 32.22 482.22 3130A3KM5 FHLB 12/09/2022 1,000,000.00 1,000,849.00 1,000,718.04 11,944.44 12,500.00 1,527.78 2,083.34 -130.96 1,952.38 3133EFUJ4 FFCB 12/29/2022 1,275,000.00 1,288,005.32 1,286,192.08 11,574.17 13,706.25 152.29 2,284.37 -1,813.24 471.13 3135G0T94 FNMA 01/19/2023 1,000,000.00 999,266.24 999,359.57 8,708.33 0.00 10,687.50 1,979.17 93.33 2,072.50 3134GVQ68 FHLMC 06/16/2023 2,000,000.00 2,000,000.00 2,000,000.00 3,437.50 3,750.00 312.50 625.00 0.00 625.00 313383YJ4 FHLB 09/08/2023 1,000,000.00 1,002,549.30 1,002,387.53 7,781.25 0.00 10,593.75 2,812.50 -161.77 2,650.73 3136G0X97 FNMA 10/30/2023 2,000,000.00 2,019,328.76 2,018,227.52 3,659.72 0.00 7,201.39 3,541.67 -1,101.25 2,440.42 3133EKKU9 FFCB 11/08/2023 1,000,000.00 1,004,498.61 1,004,246.27 1,469.44 0.00 3,386.11 1,916.67 -252.34 1,664.33 3133EJWW5 FFCB 12/14/2023 1,005,000.00 1,007,627.80 1,007,485.50 13,753.15 14,823.75 1,400.02 2,470.62 -142.30 2,328.32 Run Date: 7/8/2022 - 10:04 AM
Amortizing
27 5.1.b
Packet Pg. 34
Attachment: B: Investment Portfolio Information for City of San Ramon for the Month Ending June 30, Income Earned
City of San Ramon June 01, 2022 - June 30, 2022
CUSIP Value
Ending Par
Date
Maturity
Book Value
Beginning
Value
Ending Book
Accrued
Beginning
/Purchased
Int.Received
Accrued
Ending
Issuer Earned
Interest Amortization/
Accretion Earned
Net Income
U.S. Agencies
3133EKQU3 FFCB 06/13/2024 1,000,000.00 999,314.13 999,341.31 9,100.00 9,750.00 975.00 1,625.00 27.17 1,652.17 3133EKA63 FFCB 08/16/2024 2,000,000.00 1,997,208.67 1,997,310.49 9,333.33 0.00 12,000.00 2,666.67 101.82 2,768.49 3133EKP75 FFCB 09/17/2024 2,000,000.00 1,998,816.07 1,998,857.63 6,577.78 0.00 9,244.44 2,666.66 41.57 2,708.23 3133EK4Y9 FFCB 11/01/2024 1,043,000.00 1,068,664.98 1,067,809.48 1,434.12 0.00 2,868.25 1,434.13 -855.50 578.63 3130AQXY4 FHLB 02/28/2025 2,000,000.00 2,000,000.00 2,000,000.00 10,333.33 0.00 13,666.67 3,333.34 0.00 3,333.34 880591EW8 TVA 05/15/2025 2,000,000.00 2,001,675.03 2,001,629.38 666.67 0.00 1,916.67 1,250.00 -45.65 1,204.35 3137EAEX3 FHLMC 09/23/2025 2,000,000.00 1,993,996.64 1,994,142.70 1,416.67 0.00 2,041.67 625.00 146.05 771.05 3135G06G3 FNMA 11/07/2025 2,000,000.00 2,000,443.73 2,000,433.32 666.67 0.00 1,500.00 833.33 -10.41 822.92 3130AL7M0 FHLB 02/24/2026 2,000,000.00 2,000,000.00 2,000,000.00 3,368.06 0.00 4,409.72 1,041.66 0.00 1,041.66 3130AQW66 FHLB 02/25/2027 1,000,000.00 1,000,000.00 1,000,000.00 5,546.67 0.00 7,280.00 1,733.33 0.00 1,733.33 U.S. Agencies - Sub Total 35,323,000.00 35,380,994.61 35,377,219.47 128,210.05 54,530.00 118,498.35 44,818.30 -3,775.14 41,043.16 U.S. Treasuries
912796S59 U.S. Treasury 07/28/2022 2,000,000.00 1,998,369.17 1,999,198.89 0.00 0.00 0.00 0.00 829.72 829.72 912796YF0 U.S. Treasury 10/25/2022 1,000,000.00 0.00 993,297.86 0.00 0.00 0.00 0.00 58.28 58.28 91282CAW1 U.S. Treasury 11/15/2023 1,000,000.00 995,540.50 995,791.50 115.49 0.00 319.29 203.80 251.00 454.80 91282CCC3 U.S. Treasury 05/15/2024 2,000,000.00 1,995,484.43 1,995,673.89 230.98 0.00 638.59 407.61 189.46 597.07 912828YM6 U.S. Treasury 10/31/2024 2,000,000.00 2,045,865.13 2,044,308.62 2,608.70 0.00 5,054.35 2,445.65 -1,556.51 889.14 912828G38 U.S. Treasury 11/15/2024 2,000,000.00 2,088,155.45 2,085,213.67 2,078.80 0.00 5,747.28 3,668.48 -2,941.78 726.70 912828ZF0 U.S. Treasury 03/31/2025 2,000,000.00 1,998,739.38 1,998,775.92 1,693.99 0.00 2,513.66 819.67 36.54 856.21 91282CAT8 U.S. Treasury 10/31/2025 2,000,000.00 1,960,243.78 1,961,198.70 434.78 0.00 842.39 407.61 954.91 1,362.52 912828M56 U.S. Treasury 11/15/2025 2,000,000.00 2,037,649.78 2,036,756.19 2,078.80 0.00 5,747.28 3,668.48 -893.59 2,774.89 912828R36 U.S. Treasury 05/15/2026 2,000,000.00 0.00 1,899,139.43 0.00 -2,031.25 4,150.82 2,119.57 1,639.43 3,759.00 91282CCW9 U.S. Treasury 08/31/2026 1,000,000.00 998,127.57 998,163.74 1,895.38 0.00 2,506.79 611.41 36.17 647.58 91282CCZ2 U.S. Treasury 09/30/2026 1,000,000.00 991,575.58 991,735.23 1,482.24 0.00 2,199.45 717.21 159.65 876.86 91282CDG3 U.S. Treasury 10/31/2026 2,000,000.00 1,944,948.07 1,945,971.34 1,956.52 0.00 3,790.76 1,834.24 1,023.27 2,857.51 912828U24 U.S. Treasury 11/15/2026 2,000,000.00 2,003,429.54 2,003,366.38 1,847.83 0.00 5,108.70 3,260.87 -63.16 3,197.71 U.S. Treasuries - Sub Total 24,000,000.00 21,058,128.36 23,948,591.35 16,423.51 -2,031.25 38,619.36 20,164.60 -276.59 19,888.01 Grand Total 82,040,846.79 81,942,347.31 82,025,153.03 218,729.79 86,367.60 221,665.96 89,303.77 -3,561.88 85,741.89 Run Date: 7/8/2022 - 10:04 AM
Amortizing
28 5.1.b
Packet Pg. 35
Attachment: B: Investment Portfolio Information for City of San Ramon for the Month Ending June 30, Realized Gains and Losses
City of San Ramon June 01, 2022 - June 30, 2022
CUSIP Par Value Sale Date Days Held Maturity/Sales Realized Issuer Purchase Date Coupon Rate Maturity Date Term Book Value Proceeds Gain/Loss Certificates of Deposit
33847E2J5 06/12/2019 248,000.00 06/13/2022 1,097 248,000.00 248,000.00 0.00 Flagstar Bank 2.500% 06/13/2022 1,097
Total Certificates of Deposit 248,000.00 248,000.00 0.00 Commercial Paper
78015DFQ8 02/09/2022 1,250,000.00 06/24/2022 135 1,250,000.00 1,250,000.00 0.00 Royal Bank of Canada, NY 0.000% 06/24/2022 135
Total Commercial Paper 1,250,000.00 1,250,000.00 0.00
Corporate Bonds
59217GDB2 06/17/2019 1,000,000.00 06/17/2022 1,096 1,000,000.00 1,000,000.00 0.00 MetLife 2.400% 06/17/2022 1,096
Total Corporate Bonds 1,000,000.00 1,000,000.00 0.00
Grand Total 2,498,000.00 2,498,000.00 0.00
Run Date: 7/8/2022 - 10:04 AM
Amortizing
29 5.1.b
Packet Pg. 36
Attachment: B: Investment Portfolio Information for City of San Ramon for the Month Ending June 30, Transaction Report
City of San Ramon June 01, 2022 - June 30, 2022
Transaction Transaction Security Security Maturity
Date Type ID Description Date Purchases Redemptions Interest Deposits Withdrawals 06/01/2022 Interest FIGXX Fidelity Govt MMF - - 1,034.42 - - 06/06/2022 Interest 166764AB6 CVX 2.355 12/05/22 12/05/2022 - - 11,775.00 - - 06/07/2022 Deposit FIGXX FIGXX - - - 2,000,000.00 -
06/07/2022 Withdrawal LAIF Withdrawal - - - - -2,000,000.00 06/07/2022 Interest 637639AE5 NSCCLF 0 3/4 12/07/25 12/07/2025 - - 3,750.00 - - 06/07/2022 Purchase 912828R36 T 1 5/8 05/15/26 05/15/2026 -1,897,500.00 - -2,031.25 - - 06/09/2022 Interest 3130A3KM5 FHLB 2 1/2 12/09/22 12/09/2022 - - 12,500.00 - - 06/13/2022 Interest 3133EKQU3 FFCB 1.95 06/13/24 06/13/2024 - - 9,750.00 - - 06/13/2022 Interest 33847E2J5 FBC 2 1/2 06/13/22 06/13/2022 - - 16.98 - - 06/13/2022 Maturity 33847E2J5 FBC 2 1/2 06/13/22 06/13/2022 - 248,000.00 - - - 06/13/2022 Interest 33847E2J5 FBC 2 1/2 06/13/22 06/13/2022 - - 3,091.51 - - 06/14/2022 Interest 3133EJWW5 FFCB 2.95 12/14/23 12/14/2023 - - 14,823.75 - - 06/15/2022 Interest 20033AP91 ADS 3.1 02/15/24 02/15/2024 - - 652.95 - - 06/16/2022 Interest 3134GVQ68 FHLMC 0 3/8 06/16/23 06/16/2023 - - 3,750.00 - - 06/17/2022 Interest 59217GDB2 MET 2.4 06/17/22 06/17/2022 - - 12,000.00 - - 06/17/2022 Maturity 59217GDB2 MET 2.4 06/17/22 06/17/2022 - 1,000,000.00 - - - 06/24/2022 Interest 90348JEV8 UBS 3.45 10/24/23 10/24/2023 - - 726.67 - - 06/24/2022 Maturity 78015DFQ8 ROYAL BK CAN NY 06/24/2022 - 1,250,000.00 - - - 06/27/2022 Interest 05465DAK4 BOFI 1.65 03/26/24 03/26/2024 - - 347.54 - - 06/27/2022 Interest 29278TLY4 CMS 2 09/27/23 09/27/2023 - - 421.26 - - 06/28/2022 Interest 17312QN96 C 3.3 06/28/23 06/28/2023 - - 4,080.79 - - 06/28/2022 Purchase 06406RAL1 BK 2.1 10/24/24 10/24/2024 -1,044,137.51 - -4,028.27 - - 06/28/2022 Purchase 45685RJU2 ING (US) FUNDING 09/28/2022 -1,242,940.28 - - - - 06/29/2022 Purchase 912796YF0 CASH MGMT BILL 10/25/2022 -993,239.58 - - - - 06/29/2022 Interest 3133EFUJ4 FFCB 2.15 12/29/22 12/29/2022 - - 13,706.25 - - Grand Total: -5,177,817.37 2,498,000.00 86,367.60 2,000,000.00 -2,000,000.00 Run Date: 7/8/2022 - 10:04 AM
Amortizing
30 5.1.b
Packet Pg. 37
Attachment: B: Investment Portfolio Information for City of San Ramon for the Month Ending June 30, Disclosure
Discolure
Custom Benchmark: 24 Month Moving Average of the ICE BofA 0-3Yr Treasury Index Note: The portfolio is not managed on a total return basis, nor is it managed to a specific index; rather, the portfolio is managed to ensure liquidity with the majority of the portfolio needed to fund debt and pension payments. Performance of the portfolio can differ greatly from the index depending on interest rate movements, and cash flow needs of the portfolio.
This report represents the opinions of FHN Financial Main Street Advisors, LLC and should not be considered predictive of any future market performance. Opinions are subject to change without notice. Forecasts, estimates, and certain information contained herein are based upon proprietary research and should not be considered investment advice or a recommendation of any particular security, investment strategy, or investment product.
Although this information has been obtained from sources which we believe to be reliable, we do not guarantee its accuracy, and it may be incomplete or condensed. This is for informational purposes only and is not intended as an offer or solicitation with respect to the purchase or sale of any security. All herein listed securities are subject to availability and change in price. Past performance is not indicative of future results, and changes in any assumptions may have a material effect on projected results.
Ratings on all securities are subject to change.
FHN Financial Capital Markets, FHN Financial Portfolio Advisors, and FHN Financial Municipal Advisors are divisions of First Horizon Bank. FHN Financial Securities Corp., FHN Financial Main Street Advisors, LLC, and FHN Financial Capital Assets Corp. are wholly owned subsidiaries of First Horizon Bank. FHN Financial Securities Corp. is a member of FINRA and SIPC — http://www.sipc.org/.
FHN Financial Municipal Advisors is a registered municipal advisor. FHN Financial Portfolio Advisors is a portfolio manager operating under the trust powers of First Horizon Bank. FHN Financial Main Street Advisors, LLC is a registered investment advisor. None of the other FHN entities, including FHN Financial Capital Markets, FHN Financial Securities Corp., or FHN Financial Capital Assets Corp. are acting as your advisor, and none owe a fiduciary duty under the securities laws to you, any municipal entity, or any obligated person with respect to, among other things, the information and material contained in this communication. Instead, these FHN entities are acting for their own interests. You should discuss any information or material contained in this communication with any and all internal or external advisors and experts that you deem appropriate before acting on this information or material.
FHN Financial, through First Horizon Bank or its affiliates, offers investment products and services. Investment products are not FDIC insured, have no bank guarantee, and may lose value.
Source: ICE Data Indices, LLC ("ICE"), is used with permission. ICE, ITS AFFILIATES AND THEIR RESPECTIVE THIRD PARTY SUPPLIERS DISCLAIM ANY AND ALL WARRANTIES AND
REPRESENTATIONS, EXPRESS AND/OR IMPLIED, INCLUDING ANY WARRANTIES OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE OR USE, INCLUDING THE INDICES, INDEX DATA AND ANY DATA INCLUDED IN, RELATED TO, OR DERIVED THEREFROM. NEITHER ICE DATA, ITS AFFILIATES OR THEIR RESPECTIVE THIRD PARTY PROVIDERS SHALL NOT BE
SUBJECT TO ANY DAMAGES OR LIABILITY WITH RESPECT TO THE QUALITY, ADEQUACY, ACCURACY, TIMELINESS OR COMPLETENESS OF THE INDICES OR THE INDEX DATA OR ANY COMPONENT THEREOF, AND THE INDICES AND INDEX DATA AND ALL COMPONENTS THEREOF ARE PROVIDED ON AN "AS IS" BASIS AND SUBSCRIBER'S USE IS AT SUBSCRIBER'S OWN RISK. ICE DATA, ITS AFFILIATES AND THEIR RESPECTIVE THIRD PARTY DO NOT SPONSOR, ENDORSE, OR RECOMMEND FHN FINANCIAL MAIN STREET ADVISORS, LLC, OR ANY OF ITS PRODUCTS OR SERVICES.
Run Date: 7/8/2022 - 10:04 AM
Amortizing
31 5.1.b
Packet Pg. 38
Attachment: B: Investment Portfolio Information for City of San Ramon for the Month Ending June 30, City of San Ramon
Investment Report - Supplementary InformationInvestments Held by Trustees at June 30, 2022 Maturity
Description CUSIP Rate Date Cost Market Issue
AMBAC Assurance 1.00 yg 1.00 06(A) TA
Wells Fargo Money Market 0.74 0.74 2010 POB
Wells Fargo Money Market 1.00 - 2010 POB
Wells Fargo Money Market 1,420,000.00 1,420,000.00 2010 POB Wells Fargo Money Market 256,919.25 256,919.25 2010 POB Wells Fargo Money Market 16,809.17 16,809.17 2010 POB
Wells Fargo Money Market 2.86 2.86 2010 POB
Dreyfus Govt Cash Mgmt X9USDYRUT 1.25% n/a 3,586,252.90 3,586,252.90 2019 COP Dreyfus Govt Cash Mgmt X9USDYRUT 0.00% n/a 19.00 19.00 2019 COP $ 5,280,004.92 5,280,005.92 $
5.1.c
Packet Pg. 39
Attachment: C: Investments Held by Trustees at June 30, 2022 (3703 : Quarterly Investment Report)
INVESTMENT TERMINOLOGY
Basis Points – A standard measure for interest rates that represents one one-hundredth of one percent.
Book Value – The price paid for the investments.
Fair Value – The price agreed upon by buyers and sellers in the market in which the investments are traded.
Weighted Average Days to Maturity – The average length of time until the investments in the portfolio will mature.
Weighted Average Yield to Maturity – The average return anticipated on the investments if held to maturity.
5.1.d
Packet Pg. 40
Attachment: D: Investment Terminology (3703 : Quarterly Investment Report)