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 Redondo Beach
Greg Balls, CFA
Assistant Chief Compliance Officer
702-575-6655
[email protected] June 2023
10655 Park Run Drive, Suite 120 | Las Vegas, NV 89144 | Phone 702.575.6600 | www.FHNMainStreet.com Run Date: 7/10/2023 - 5:50 PM
Amortizing Page 2
Portfolio Summary
City of Redondo Beach 6/30/2023
SECTOR ALLOCATION MATURITY DISTRIBUTION CREDIT QUALITY (MOODY'S)
ACCOUNT SUMMARY MONTH-END PORTFOLIO BOOK YIELD TOP ISSUERS 6/30/23 5/31/23 Issuer % Portfolio
Market Value $110,357,578 $114,442,739 U.S. Treasury 32.9% Book Value $114,529,529 $118,313,058 FHLB 16.6%
Variance -$4,171,951 -$3,870,320 FFCB 16.1%
FHLMC 12.6%
Par Value $115,511,656 $119,316,059 Allspring Money Market Fund 7.8% FNMA 4.4%
Net Asset Value $96.36 $96.73 Toyota 2.6%
New York Life 1.7%
Book Yield 2.67% 2.64% US Bancorp 1.7%
National Securities Clearing 1.7%
Market Yield 4.78% 4.63% LAIF 0.9%
Comenity Capital Bank 0.2%
Years to Maturity 1.91 1.92 Morgan Stanley Private Bank 0.2% Wells Fargo 0.2%
Effective Duration 1.63 1.62 Morgan Stanley Bank 0.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
1.00%
1.25%
1.50%
1.75%
2.00%
2.25%
2.50%
2.75%
3.00%
0.9%
0.9%
7.8%
7.8%
32.9%
49.7%
CD
LAIF
CORP
MMF
TSY
AGY
0% 25% 50% 75% 100%
32.5%
16.7% 19.0%
23.1%
8.7%
0-1Y 1-2Y 2-3Y 3-4Y 4-5Y+
0%
10%
20%
30%
40%
50%
60%
70%
1.8%
1.7%
2.6%
89.5%
4.4%
NR
A3
A2
A1
Aa3
Aa2
Aa1
Aaa
P-1
0% 25% 50% 75% 100%
2 Run Date: 7/10/2023 - 5:50 PM
Amortizing Page 3
Investment Policy Compliance
City of Redondo Beach 6/30/2023
Category Book Value % of Portfolio % Allowed by Policy In Compliance Reserved row US Treasuries 37,713,482.87 32.93% 100% Yes
US Federal Agencies 56,918,780.14 49.70% 100% Yes
Supranational Obligations 0.00 0.00% 15% Yes
LAIF 1,087,813.05 0.95% 65,000,000 Yes
Commercial Paper 0.00 0.00% 25% Yes
Money Market Funds 8,931,842.56 7.80% 15% Yes
Negotiable Certificates of Deposit 991,738.23 0.87% 30% Yes Corporate Obligations 8,885,871.94 7.76% 30% Yes
Total 114,529,528.79 100.00%
Other Metrics Portfolio Metric In Compliance
Weighted Average Maturity 1.91 Less than 2.5 Years Yes
Liquidity 32.52% 25% Under 365 Days Yes
Ratings Yes
3 Run Date: 7/10/2023 - 5:50 PM
Amortizing Page 4
Historical Book Values
City of Redondo Beach 6/30/2023
Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun
Fiscal Year 2019 $89.3 $81.1 $79.7 $78.6 $78.5 $81.2 $87.5 $93.0 $92.8 $92.5 $99.3 $101.4 FY19 Fiscal Year 2020 $94.9 $87.7 $85.2 $82.2 $79.6 $81.1 $87.0 $92.1 $92.5 $86.9 $93.0 $95.5 FY20 Fiscal Year 2021 $91.4 $77.1 $75.4 $72.7 $71.4 $69.7 $76.3 $79.2 $81.5 $79.7 $84.9 $87.1 FY21 Fiscal Year 2022 $87.4 $89.1 $88.6 $82.6 $81.1 $82.8 $92.8 $98.8 $98.1 $96.2 $97.2 $99.8 FY22 Fiscal Year 2023 $108.7 $111.6 $113.9 $110.5 $110.4 $106.5 $101.8 $99.4 $104.8 $101.3 $101.0 $105.6 FY23 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
Jul-22
Nov-22
Mar-23
$40
$50
$60
$70
$80
$90
$100
$110
$120
Millions
4 Run Date: 7/10/2023 - 5:50 PM
Amortizing Page 5
Historical Book Values Per Fiscal Year
City of Redondo Beach 6/30/2023
Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun
Fiscal Year 2019 $89.3 $81.1 $79.7 $78.6 $78.5 $81.2 $87.5 $93.0 $92.8 $92.5 $99.3 $101.4 FY19 Fiscal Year 2020 $94.9 $87.7 $85.2 $82.2 $79.6 $81.1 $87.0 $92.1 $92.5 $86.9 $93.0 $95.5 FY20 Fiscal Year 2021 $91.4 $77.1 $75.4 $72.7 $71.4 $69.7 $76.3 $79.2 $81.5 $79.7 $84.9 $87.1 FY21 Fiscal Year 2022 $87.4 $89.1 $88.6 $82.6 $81.1 $82.8 $92.8 $98.8 $98.1 $96.2 $97.2 $99.8 FY22 Fiscal Year 2023 $108.7 $111.6 $113.9 $110.5 $110.4 $106.5 $101.8 $99.4 $104.8 $101.3 $101.0 $105.6 FY23 Figures in Millions, Average Daily Balance
Chart Title
Jul
Aug
Sep
Oct
Nov
Dec
Jan
Feb
Mar
Apr
May
Jun
$60
$70
$80
$90
$100
$110
$120
Millions
Fiscal Year 2019 Fiscal Year 2020 Fiscal Year 2021 Fiscal Year 2022 Fiscal Year 2023 5 Run Date: 7/10/2023 - 5:50 PM
Amortizing Page 6
Historical Weighted Average Maturity
City of Redondo Beach 6/30/2023 Don
Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun
Fiscal Year 2019 1.76 1.76 1.73 1.83 1.75 1.51 2.04 2.01 1.95 1.77 1.67 1.81 Fiscal Year 2020 1.90 2.12 2.10 2.13 2.17 1.89 2.04 2.03 2.02 2.06 1.74 1.72 Fiscal Year 2021 2.01 1.99 1.97 1.92 2.01 1.68 1.61 1.74 1.69 1.58 1.43 1.64 Fiscal Year 2022 1.59 1.78 2.06 2.04 2.01 1.81 2.07 2.07 2.03 1.97 2.06 1.92 Fiscal Year 2023 1.85 1.96 1.99 1.96 1.90 1.72 1.65 2.05 1.98 2.20 1.92 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 Jul-22 Nov-22 Mar-23
0.00 0.50
1.00 1.50
2.00 2.50
3.00 3.50
Average Years To Maturity
6 Run Date: 7/10/2023 - 5:50 PM
Amortizing Page 7
Next Twelve Months Cash Flow
City of Redondo Beach 6/30/2023
Jul-23 Aug-23 Sep-23 Oct-23 Nov-23 Dec-23 Jan-24 Feb-24 Mar-24 Apr-24 May-24 Jun-24 Maturities $21.0 $0.0 $3.0 $4.0 $4.0 $2.0 $0.0 $0.0 $1.0 $0.0 $0.5 $1.7 1 Par Value in Millions; Assumes Securities Are Held To Maturity $21.0
$0.0
$3.0
$4.0 $4.0
$2.0
$0.0 $0.0
$1.0
$0.0 $0.5
$1.7
Jul-23 Aug-23 Sep-23 Oct-23 Nov-23 Dec-23 Jan-24 Feb-24 Mar-24 Apr-24 May-24 Jun-24 $0
$5
$10
$15
$20
$25
$30
$35
$40
Millions
7 Run Date: 7/10/2023 - 5:50 PM
Amortizing Page 8
Yield At Cost Per 6-Month Maturity Intervals
City of Redondo Beach 6/30/2023
Years Yield At Cost % of Portfolio
0 to .5 3.39% 29.69%
.5 to 1.0 1.76% 2.83%
1.0 to 1.5 2.01% 12.44%
1.5 to 2.0 2.81% 4.27%
2.0 to 2.5 2.33% 18.09%
2.5 to 3.0 0.89% 0.87%
3.0 to 3.5 2.48% 8.25%
3.5 to 4.0 1.93% 14.84%
4.0 to 4.5 3.45% 4.37%
4.5 to 5.0 3.94% 4.35%
5.0+ 0.00% 0.00%
Total 2.67% 100.0%
3.39%
1.76%
2.01%
2.81%
2.33%
0.89%
2.48%
1.93%
3.45%
3.94%
-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%
3.0%
3.5%
4.0%
4.5%
5.0%
Maturity Intervals
Yield At Cost
Bubble Size = Maturity's % of Portfolio
8 Run Date: 7/10/2023 - 5:50 PM
Amortizing Page 9
Historical Sector Allocation
City of Redondo Beach 6/30/2023
Sector Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 Jan-23 Feb-23 Mar-23 Apr-23 May-23 Jun-23 AGY 41.9% 47.5% 48.3% 46.5% 46.6% 40.4% 40.3% 48.2% 48.1% 55.7% 48.1% 49.7% TSY 30.2% 28.2% 29.7% 29.8% 29.8% 23.8% 23.7% 27.8% 27.8% 32.1% 31.9% 32.9% MMF 0.0% 0.0% 0.0% 0.0% 0.0% 4.4% 23.2% 11.2% 11.3% 1.5% 10.8% 7.8% CORP 8.3% 6.0% 6.3% 8.0% 8.0% 7.5% 7.5% 7.5% 7.5% 8.7% 7.5% 7.8% LAIF 18.5% 17.2% 14.5% 14.6% 14.6% 23.1% 4.4% 4.4% 4.4% 1.1% 0.9% 0.9% CD 1.1% 1.1% 1.1% 1.1% 0.9% 0.8% 0.8% 0.8% 0.8% 1.0% 0.8% 0.9% 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-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 Jan-23 Feb-23 Mar-23 Apr-23 May-23 Jun-23 0%
5%
10%
15%
20%
25%
30%
35%
40%
45%
50%
55%
60%
AGY
TSY
MMF
CORP
LAIF
CD
9 Run Date: 7/10/2023 - 5:50 PM
Amortizing Page 10
Issuer Allocation
City of Redondo Beach 6/30/2023
0.2%
0.2%
0.2%
0.2%
0.9%
1.7%
1.7%
1.7%
2.6%
4.4%
7.8%
12.6%
16.1%
16.6%
32.9%
Wells Fargo
Morgan Stanley Bank
Comenity Capital Bank
Morgan Stanley Private Bank
LAIF
National Securities Clearing
US Bancorp
New York Life
Toyota
FNMA
Allspring Money Market Fund
FHLMC
FFCB
FHLB
U.S. Treasury
0% 5% 10% 15% 20% 25% 30% 35%
10 Run Date: 7/10/2023 - 5:50 PM
Amortizing Page 11
Historical Earnings & Book Return Performance
City of Redondo Beach 6/30/2023
Fiscal YTD ($K) Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun FY 2021 $155.722 $295.000 $430.578 $557.769 $687.588 $815.050 $943.405 $1,070.116 $1,198.760 $1,324.600 $1,451.500 $1,574.100 FY 2022 $112.499 $217.986 $382.727 $489.647 $593.726 $696.012 $806.551 $913.900 $1,021.840 $1,124.589 $1,230.356 $1,342.113 FY 2023 $132.884 $272.892 $425.012 $645.396 $798.263 $952.194 $1,226.478 $1,453.296 $1,757.809 $1,966.545 $2,184.041 $2,435.724 Fiscal YTD Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Book Return 1.44% 1.46% 1.51% 1.72% 1.72% 1.71% 1.91% 2.02% 2.18% 2.21% 2.24% 2.29% Fiscal Year-To-Date Earnings
Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun
$0
$500
$1,000
$1,500
$2,000
$2,500
$3,000
Thousands
FY 2021
FY 2022
FY 2023
Fiscal Year-To-Date Book Return
Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun
1.00%
1.25%
1.50%
1.75%
2.00%
2.25%
2.50%
2.75%
3.00%
11 Run Date: 7/10/2023 - 5:50 PM
Amortizing Page 12
Historical Yield At Cost vs Benchmark
City of Redondo Beach 6/30/2023
Month-End Yield At Cost vs Benchmark
Jun-12
Oct-12
Feb-13
Jun-13
Oct-13
Feb-14
Jun-14
Oct-14
Feb-15
Jun-15
Oct-15
Feb-16
Jun-16
Oct-16
Feb-17
Jun-17
Oct-17
Feb-18
Jun-18
Oct-18
Feb-19
Jun-19
Oct-19
Feb-20
Jun-20
Oct-20
Feb-21
Jun-21
Oct-21
Feb-22
Jun-22
Oct-22
Feb-23
Jun-23
0.0%
0.5%
1.0%
1.5%
2.0%
2.5%
3.0%
3.5% Portfolio
Benchmark
Trailing 12 Months: Month End Yield At Cost vs Benchmark 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.0%
0.5%
1.0%
1.5%
2.0%
2.5%
3.0%
Portfolio
Benchmark
Benchmark: Custom Benchmark (see disclosure)
12 Run Date: 7/10/2023 - 5:50 PM
Amortizing Page 13
Total Return Performance
City of Redondo Beach 6/30/2023
*Index: ICE BofA 0-5Yr Treasury Index
**Inception: July 2012
1 Month 3 Month FYTD 1 Year 3 Year 5 Year Inception
Portfolio -0.041% 0.029% 0.740% 0.740% -0.681% 1.380% 1.093% Benchmark -0.459% -0.419% 0.422% 0.422% -1.162% 1.062% 0.829% Variance 0.418% 0.447% 0.318% 0.318% 0.481% 0.319% 0.264% 1 Month 3 Month FYTD 1 Year 3 Year 5 Year Inception**
-1.500%
-1.000%
-0.500%
0.000%
0.500%
1.000%
1.500%
2.000%
Portfolio
Benchmark
13 Run Date: 7/10/2023 - 5:50 PM
Amortizing Page 14
Investment Activity
City of Redondo Beach 6/30/2023
Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 Jan-23 Feb-23 Mar-23 Apr-23 May-23 Jun-23 Positions 40 41 40 40 39 37 37 40 40 40 41 41
Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 Jan-23 Feb-23 Mar-23 Apr-23 May-23 Jun-23 Purchases 0 2 0 1 0 0 0 3 0 0 1 1
Redemptions 0 1 1 1 1 3 0 0 0 0 0 1
Total 0 3 1 2 1 3 0 3 0 0 1 2
Number of Positions at Month End
Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 Jan-23 Feb-23 Mar-23 Apr-23 May-23 Jun-23 20 30
40 50
60 Positions
Purchases and Redemptions* (Excluding MMF/LGIP)
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 2
4 6
8 10
Number of Transactions
Purchases
Redemptions
*Redemptions include maturities, calls, and sells
14 Portfolio Summary
City of Redondo Beach June 30, 2023
Investments Par Value Book Value
% of
Portfolio Maturity YTM
Days to
Market Value
Book
Certificates of Deposit 992,000.00 963,861.92 991,738.23 0.87 363 2.57 Corporate Bonds 9,000,000.00 8,770,250.00 8,885,871.94 7.76 227 2.66 LAIF 1,087,813.05 1,087,813.05 1,087,813.05 0.95 1 3.17 Money Market Funds 8,931,842.56 8,931,842.56 8,931,842.56 7.80 1 4.99 U.S. Agencies 57,500,000.00 54,797,040.00 56,918,780.14 49.70 919 2.65 U.S. Treasuries 38,000,000.00 35,806,770.00 37,713,482.87 32.93 668 2.14 115,511,655.61 110,357,577.53 114,529,528.79 100.00 698 2.67 Investments
Total Earnings June 30 Month Ending Fiscal Year To Date Current Year 251,682.88 2,435,723.58
Average Daily Balance 105,593,217.98 106,293,142.64
Book Rate of Return 2.90% 2.29%
Run Date: 7/10/2023 - 5:51 PM
Amortizing
15 Holdings Report
City of Redondo Beach June 30, 2023
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
61760AZZ5 Morgan Stanley Private Bank 05/09/2024 248,000.00 05/09/2019 248,000.00 97.69 242,268.72 0.22% NR/NR 0.86
2.650% 2.65% 248,000.00 5.44% 954.29 -5,731.28 NR 0.84
20033AW51 Comenity Capital Bank 05/15/2024 248,000.00 05/15/2019 248,000.00 97.72 242,355.52 0.22% NR/NR 0.88
2.750% 2.75% 248,000.00 5.43% 298.96 -5,644.48 NR 0.86
61690UHB9 Morgan Stanley Bank 06/06/2024 248,000.00 06/07/2019 247,422.16 97.51 241,817.36 0.22% NR/NR 0.94
2.700% 2.75% 247,891.77 5.47% 458.63 -6,074.41 NR 0.91
949763L95 Wells Fargo Bank NA 10/17/2024 248,000.00 10/18/2019 247,409.76 95.73 237,420.32 0.22% NR/NR 1.30
2.050% 2.10% 247,846.46 5.48% 195.00 -10,426.14 NR 1.27 990,831.92 963,861.92 0.87% 0.99
Total Certificates of Deposit 992,000.00 2.57% 991,738.23 5.46% 1,906.88 -27,876.31 0.97 Corporate Bonds
90331HNV1 US Bank 07/24/2023 2,000,000.00 01/04/2019 2,003,380.00 99.87 1,997,300.00 1.75% A2/A+ 0.07
3.400% 07/11/2023 3.36% 2,000,049.46 5.35% 29,655.56 -2,749.46 A+ 0.05 89236TDK8 Toyota Motor Credit 10/18/2023 2,000,000.00 01/04/2019 1,901,820.00 98.98 1,979,660.00 1.74% A1/A+ 0.30
2.250% 3.37% 1,993,849.51 5.67% 9,125.00 -14,189.51 A+ 0.28 64952WDT7 New York Life 10/21/2023 2,000,000.00 09/22/2021 2,004,800.00 98.42 1,968,400.00 1.75% Aaa/AA+ 0.31
0.400% 0.28% 2,000,711.35 5.61% 1,555.56 -32,311.35 AAA 0.29 892331AL3 Toyota Motor 03/25/2024 1,000,000.00 03/25/2021 1,000,000.00 96.52 965,230.00 0.87% A1/A+ 0.74
0.681% 02/25/2024 0.68% 1,000,000.00 5.57% 1,816.00 -34,770.00 A+ 0.70 637639AB1 National Securities Clearing 04/23/2025 2,000,000.00 10/06/2022 1,847,300.00 92.98 1,859,660.00 1.65% Aaa/AA+ 1.82
1.500% 4.72% 1,891,261.61 5.62% 5,666.67 -31,601.61 NR 1.73 8,757,300.00 8,770,250.00 7.76% 0.62
Total Corporate Bonds 9,000,000.00 2.66% 8,885,871.94 5.56% 47,818.79 -115,621.93 0.59 LAIF
9819716 LAIF 07/01/2023 1,087,813.05 04/14/2023 1,087,813.05 1.00 1,087,813.05 0.95% NR/NR 0.00
3.170% 3.17% 1,087,813.05 3.17% 0.00 0.00 NR 0.00
1,087,813.05 1,087,813.05 0.95% 0.00
Total LAIF 1,087,813.05 3.17% 1,087,813.05 3.17% 0.00 0.00 0.00 Money Market Funds
Run Date: 7/10/2023 - 5:51 PM
Amortizing
16 Holdings Report
City of Redondo Beach June 30, 2023
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
FUZXX Allspring Money Market Fund 07/01/2023 8,931,842.56 8,931,842.56 100.00 8,931,842.56 7.80% Aaa/AAA 0.00
4.989% 4.99% 8,931,842.56 4.99% 47,467.68 0.00 NR 0.00
8,931,842.56 8,931,842.56 7.80% 0.00
Total Money Market Funds 8,931,842.56 4.99% 8,931,842.56 4.99% 47,467.68 0.00 0.00 U.S. Agencies
3133EJUS6 FFCB 07/17/2023 4,000,000.00 07/30/2018 3,986,000.00 99.91 3,996,200.00 3.49% Aaa/AA+ 0.05
2.875% 2.95% 3,999,866.82 4.83% 52,388.89 -3,666.82 AAA 0.04 3133EJYL7 FFCB 09/05/2023 3,000,000.00 10/19/2018 2,949,870.00 99.56 2,986,920.00 2.62% Aaa/AA+ 0.18
2.800% 3.17% 2,998,144.39 5.19% 27,066.67 -11,224.39 AAA 0.17 3133EJ3Q0 FFCB 12/21/2023 2,000,000.00 01/31/2019 2,014,600.00 98.70 1,973,900.00 1.75% Aaa/AA+ 0.48
2.875% 2.71% 2,001,417.72 5.69% 1,597.22 -27,517.72 AAA 0.46 3133EKNX0 FFCB 06/03/2024 1,500,000.00 06/05/2019 1,511,640.00 97.16 1,457,430.00 1.31% Aaa/AA+ 0.93
2.160% 2.00% 1,502,155.80 5.34% 2,520.00 -44,725.80 AAA 0.89 3133EKWV4 FFCB 07/26/2024 1,000,000.00 08/07/2019 1,010,120.00 96.24 962,440.00 0.88% Aaa/AA+ 1.07
1.850% 1.64% 1,002,183.52 5.50% 7,965.28 -39,743.52 AAA 1.02 3133EKA63 FFCB 08/16/2024 2,000,000.00 08/16/2019 1,995,911.08 96.03 1,920,660.00 1.75% Aaa/AA+ 1.13
1.600% 1.64% 1,999,077.72 5.27% 12,000.00 -78,417.72 AAA 1.08 3130AQZ48 FHLB 08/28/2024 5,000,000.00 08/08/2022 4,872,185.00 96.08 4,803,850.00 4.30% Aaa/AA+ 1.16
2.000% 07/28/2023 3.30% 4,927,801.80 5.52% 34,166.67 -123,951.80 AAA 1.11 3135G0W66 FNMA 10/15/2024 2,000,000.00 02/06/2020 2,013,560.00 95.41 1,908,220.00 1.75% Aaa/AA+ 1.30
1.625% 1.47% 2,003,733.21 5.35% 6,861.11 -95,513.21 AAA 1.24 3130A3GE8 FHLB 12/13/2024 2,000,000.00 01/30/2020 2,113,320.00 96.46 1,929,160.00 1.78% Aaa/AA+ 1.46
2.750% 1.54% 2,033,808.53 5.31% 2,750.00 -104,648.53 AAA 1.39 3135G0X24 FNMA 01/07/2025 3,000,000.00 01/27/2020 3,003,150.00 94.82 2,844,510.00 2.62% Aaa/AA+ 1.53
1.625% 1.60% 3,000,968.01 5.22% 23,562.50 -156,458.01 AAA 1.45 3134GW6C5 FHLMC 10/28/2026 5,000,000.00 02/10/2023 4,401,050.00 88.59 4,429,700.00 3.90% Aaa/AA+ 3.33
0.800% 07/28/2023 4.32% 4,463,720.40 4.53% 7,000.00 -34,020.40 AAA 3.18 3130AQEC3 FHLB 12/30/2026 2,000,000.00 12/30/2021 2,000,000.00 88.62 1,772,400.00 1.75% Aaa/AA+ 3.50
1.370% 09/30/2023 1.37% 2,000,000.00 4.95% 76.11 -227,600.00 AAA 3.31 3130AQLX9 FHLB 01/27/2027 10,000,000.00 01/27/2022 10,000,000.00 91.76 9,175,700.00 8.73% Aaa/AA+ 3.58
1.250% 07/27/2023 1.25% 10,000,000.00 3.73% 53,472.22 -824,300.00 AAA 3.09 3134GXTS3 FHLMC 05/25/2027 5,000,000.00 05/25/2022 5,000,000.00 96.82 4,841,000.00 4.37% Aaa/AA+ 3.90
3.500% 11/25/2023 3.50% 5,000,000.00 4.39% 17,500.00 -159,000.00 AAA 2.14 3134GXR48 FHLMC 08/25/2027 5,000,000.00 08/25/2022 5,000,000.00 97.26 4,863,100.00 4.37% Aaa/AA+ 4.16
3.450% 08/25/2023 3.45% 5,000,000.00 4.17% 60,375.00 -136,900.00 AAA 2.17 Run Date: 7/10/2023 - 5:51 PM
Amortizing
17 Holdings Report
City of Redondo Beach June 30, 2023
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
3133EPAV7 FFCB 02/14/2028 5,000,000.00 02/14/2023 4,984,750.00 98.64 4,931,850.00 4.35% Aaa/AA+ 4.63
3.875% 3.94% 4,985,902.22 4.20% 73,732.64 -54,052.22 AAA 4.09 56,856,156.08 54,797,040.00 49.70% 2.52
Total U.S. Agencies 57,500,000.00 2.65% 56,918,780.14 4.67% 383,034.31 -2,121,740.14 2.02 U.S. Treasuries
912797FY8 U.S. Treasury 07/18/2023 5,000,000.00 06/30/2023 4,987,517.50 99.79 4,989,550.00 4.35% P-1/A-1+ 0.05
0.000% 5.09% 4,987,517.50 4.25% 0.00 2,032.50 F1+ 0.05
91282CAW1 U.S. Treasury 11/15/2023 4,000,000.00 08/30/2021 3,998,125.00 98.16 3,926,400.00 3.49% Aaa/AA+ 0.38
0.250% 0.27% 3,999,679.37 5.25% 1,277.17 -73,279.37 AAA 0.36 912828YV6 U.S. Treasury 11/30/2024 2,000,000.00 08/09/2021 2,069,609.38 94.95 1,898,900.00 1.77% Aaa/AA+ 1.42
1.500% 0.44% 2,029,881.94 5.24% 2,540.98 -130,981.94 AAA 1.36 91282CEY3 U.S. Treasury 07/15/2025 5,000,000.00 05/30/2023 4,872,070.30 96.38 4,818,950.00 4.26% Aaa/AA+ 2.04
3.000% 4.27% 4,877,174.32 4.88% 69,198.90 -58,224.32 AAA 1.91 91282CAB7 U.S. Treasury 07/31/2025 2,000,000.00 08/09/2021 1,974,609.38 91.00 1,819,920.00 1.73% Aaa/AA+ 2.09
0.250% 0.57% 1,986,675.17 4.84% 2,085.64 -166,755.17 AAA 2.02 91282CAJ0 U.S. Treasury 08/31/2025 2,000,000.00 06/28/2021 1,958,437.50 90.73 1,814,540.00 1.73% Aaa/AA+ 2.17
0.250% 0.76% 1,978,387.50 4.80% 1,671.20 -163,847.50 AAA 2.10 91282CFK2 U.S. Treasury 09/15/2025 5,000,000.00 02/10/2023 4,908,007.80 97.30 4,864,850.00 4.30% Aaa/AA+ 2.21
3.500% 4.26% 4,921,593.15 4.80% 51,358.70 -56,743.15 AAA 2.06 91282CAT8 U.S. Treasury 10/31/2025 2,000,000.00 02/03/2021 1,985,156.26 90.25 1,805,000.00 1.74% Aaa/AA+ 2.34
0.250% 0.41% 1,992,676.75 4.71% 842.39 -187,676.75 AAA 2.26 91282CAT8 U.S. Treasury 10/31/2025 2,000,000.00 02/17/2021 1,976,953.14 90.25 1,805,000.00 1.74% Aaa/AA+ 2.34
0.250% 0.50% 1,988,536.97 4.71% 842.39 -183,536.97 AAA 2.26 91282CAZ4 U.S. Treasury 11/30/2025 1,000,000.00 02/23/2021 991,250.00 90.27 902,660.00 0.87% Aaa/AA+ 2.42
0.375% 0.56% 995,557.15 4.68% 317.62 -92,897.15 AAA 2.34 91282CAZ4 U.S. Treasury 11/30/2025 2,000,000.00 06/28/2021 1,962,734.38 90.27 1,805,320.00 1.73% Aaa/AA+ 2.42
0.375% 0.80% 1,979,614.60 4.68% 635.25 -174,294.60 AAA 2.34 91282CCF6 U.S. Treasury 05/31/2026 1,000,000.00 06/28/2021 993,437.50 89.82 898,240.00 0.87% Aaa/AA+ 2.92
0.750% 0.89% 996,109.22 4.51% 635.25 -97,869.22 AAA 2.80 91282CCP4 U.S. Treasury 07/31/2026 2,000,000.00 08/09/2021 1,990,625.00 89.09 1,781,800.00 1.74% Aaa/AA+ 3.09
0.625% 0.72% 1,994,185.13 4.45% 5,214.09 -212,385.13 AAA 2.96 91282CCW9 U.S. Treasury 08/31/2026 3,000,000.00 09/27/2021 2,978,085.93 89.19 2,675,640.00 2.61% Aaa/AA+ 3.17
0.750% 0.90% 2,985,894.12 4.45% 7,520.38 -310,254.12 AAA 3.03 Run Date: 7/10/2023 - 5:51 PM
Amortizing
18 Holdings Report
City of Redondo Beach June 30, 2023
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
37,646,619.07 35,806,770.00 32.93% 1.83
Total U.S. Treasuries 38,000,000.00 2.14% 37,713,482.87 4.74% 144,139.96 -1,906,712.89 1.74 114,270,562.68 110,357,577.53 100.00% 1.91
TOTAL PORTFOLIO 115,511,655.61 2.67% 114,529,528.79 4.78% 624,367.62 -4,171,951.27 1.63 TOTAL MARKET VALUE PLUS ACCRUED INTEREST 110,981,945.15 Run Date: 7/10/2023 - 5:51 PM
Amortizing
19 Maturity Report
City of Redondo Beach June 30, 2023
CUSIP Date
Purchase
Value
Book
Rate
Coupon
Date
Maturity
Par
Remaining
Term Value
Market
Issuer YTM
Days to
Maturity
Book
FUZXX Allspring Money Market Fund 8,931,842.56 4.989% 07/01/2023 8,931,842.56 1 8,931,842.56 4.99% 1 9819716 LAIF 12/22/2022 1,087,813.05 3.170% 07/01/2023 1,087,813.05 1 1,087,813.05 3.17% 1 3133EJUS6 FFCB 07/30/2018 3,999,866.82 2.875% 07/17/2023 4,000,000.00 1,796 3,996,200.00 2.95% 17 912797FY8 U.S. Treasury 06/30/2023 4,987,517.50 0.000% 07/18/2023 5,000,000.00 0 4,989,550.00 5.09% 18 90331HNV1 US Bank 01/04/2019 2,000,049.46 3.400% 07/24/2023 2,000,000.00 1,638 1,997,300.00 3.36% 24 3133EJYL7 FFCB 10/19/2018 2,998,144.39 2.800% 09/05/2023 3,000,000.00 1,715 2,986,920.00 3.17% 67 89236TDK8 Toyota Motor Credit 01/04/2019 1,993,849.51 2.250% 10/18/2023 2,000,000.00 1,638 1,979,660.00 3.37% 110 64952WDT7 New York Life 09/22/2021 2,000,711.35 0.400% 10/21/2023 2,000,000.00 646 1,968,400.00 0.28% 113 91282CAW1 U.S. Treasury 08/30/2021 3,999,679.37 0.250% 11/15/2023 4,000,000.00 669 3,926,400.00 0.27% 138 3133EJ3Q0 FFCB 01/31/2019 2,001,417.72 2.875% 12/21/2023 2,000,000.00 1,611 1,973,900.00 2.71% 174 892331AL3 Toyota Motor 03/25/2021 1,000,000.00 0.681% 03/25/2024 1,000,000.00 827 965,230.00 0.68% 269 61760AZZ5 Morgan Stanley Private Bank 05/09/2019 248,000.00 2.650% 05/09/2024 248,000.00 1,513 242,268.72 2.65% 314 20033AW51 Comenity Capital Bank 05/15/2019 248,000.00 2.750% 05/15/2024 248,000.00 1,507 242,355.52 2.75% 320 3133EKNX0 FFCB 06/05/2019 1,502,155.80 2.160% 06/03/2024 1,500,000.00 1,486 1,457,430.00 2.00% 339 61690UHB9 Morgan Stanley Bank 06/07/2019 247,891.77 2.700% 06/06/2024 248,000.00 1,484 241,817.36 2.75% 342 3133EKWV4 FFCB 08/07/2019 1,002,183.52 1.850% 07/26/2024 1,000,000.00 1,423 962,440.00 1.64% 392 3133EKA63 FFCB 08/16/2019 1,999,077.72 1.600% 08/16/2024 2,000,000.00 1,414 1,920,660.00 1.64% 413 3130AQZ48 FHLB 08/08/2022 4,927,801.80 2.000% 08/28/2024 5,000,000.00 326 4,803,850.00 3.30% 425 3135G0W66 FNMA 02/06/2020 2,003,733.21 1.625% 10/15/2024 2,000,000.00 1,240 1,908,220.00 1.47% 473 949763L95 Wells Fargo Bank NA 10/18/2019 247,846.46 2.050% 10/17/2024 248,000.00 1,351 237,420.32 2.10% 475 912828YV6 U.S. Treasury 08/09/2021 2,029,881.94 1.500% 11/30/2024 2,000,000.00 690 1,898,900.00 0.44% 519 3130A3GE8 FHLB 01/30/2020 2,033,808.53 2.750% 12/13/2024 2,000,000.00 1,247 1,929,160.00 1.54% 532 3135G0X24 FNMA 01/27/2020 3,000,968.01 1.625% 01/07/2025 3,000,000.00 1,250 2,844,510.00 1.60% 557 637639AB1 National Securities Clearing 10/06/2022 1,891,261.61 1.500% 04/23/2025 2,000,000.00 267 1,859,660.00 4.72% 663 91282CEY3 U.S. Treasury 05/30/2023 4,877,174.32 3.000% 07/15/2025 5,000,000.00 31 4,818,950.00 4.27% 746 91282CAB7 U.S. Treasury 08/09/2021 1,986,675.17 0.250% 07/31/2025 2,000,000.00 690 1,819,920.00 0.57% 762 91282CAJ0 U.S. Treasury 06/28/2021 1,978,387.50 0.250% 08/31/2025 2,000,000.00 732 1,814,540.00 0.76% 793 91282CFK2 U.S. Treasury 02/10/2023 4,921,593.15 3.500% 09/15/2025 5,000,000.00 140 4,864,850.00 4.26% 808 91282CAT8 U.S. Treasury 02/03/2021 1,988,536.97 0.250% 10/31/2025 2,000,000.00 877 1,805,000.00 0.50% 854 91282CAT8 U.S. Treasury 02/03/2021 1,992,676.75 0.250% 10/31/2025 2,000,000.00 877 1,805,000.00 0.41% 854 91282CAZ4 U.S. Treasury 02/23/2021 995,557.15 0.375% 11/30/2025 1,000,000.00 857 902,660.00 0.56% 884 91282CAZ4 U.S. Treasury 02/23/2021 1,979,614.60 0.375% 11/30/2025 2,000,000.00 857 1,805,320.00 0.80% 884 91282CCF6 U.S. Treasury 06/28/2021 996,109.22 0.750% 05/31/2026 1,000,000.00 732 898,240.00 0.89% 1,066 91282CCP4 U.S. Treasury 08/09/2021 1,994,185.13 0.625% 07/31/2026 2,000,000.00 690 1,781,800.00 0.72% 1,127 91282CCW9 U.S. Treasury 09/27/2021 2,985,894.12 0.750% 08/31/2026 3,000,000.00 641 2,675,640.00 0.90% 1,158 3134GW6C5 FHLMC 02/10/2023 4,463,720.40 0.800% 10/28/2026 5,000,000.00 140 4,429,700.00 4.32% 1,216 Run Date: 7/10/2023 - 5:51 PM
Amortizing
20 Maturity Report
City of Redondo Beach June 30, 2023
CUSIP Date
Purchase
Value
Book
Rate
Coupon
Date
Maturity
Par
Remaining
Term Value
Market
Issuer YTM
Days to
Maturity
Book
3130AQEC3 FHLB 12/30/2021 2,000,000.00 1.370% 12/30/2026 2,000,000.00 547 1,772,400.00 1.37% 1,279 3130AQLX9 FHLB 01/27/2022 10,000,000.00 1.250% 01/27/2027 10,000,000.00 519 9,175,700.00 1.25% 1,307 3134GXTS3 FHLMC 05/25/2022 5,000,000.00 3.500% 05/25/2027 5,000,000.00 401 4,841,000.00 3.50% 1,425 3134GXR48 FHLMC 08/25/2022 5,000,000.00 3.450% 08/25/2027 5,000,000.00 309 4,863,100.00 3.45% 1,517 3133EPAV7 FFCB 02/14/2023 4,985,902.22 3.875% 02/14/2028 5,000,000.00 136 4,931,850.00 3.94% 1,690 Net Maturities and Averages 114,529,528.79 115,511,655.61 110,357,577.53 2.67% 698 Run Date: 7/10/2023 - 5:51 PM
Amortizing
21 Summary by Issuer
City of Redondo Beach June 30, 2023
Issuer Investments
Number of Par
Value
Book
Value
% of
Portfolio YTM Maturity
Book Days to
U.S. Treasury 14 38,000,000.00 37,713,482.87 32.93 2.14 668 FHLB 4 19,000,000.00 18,961,610.33 16.56 1.83 992
FFCB 7 18,500,000.00 18,488,748.18 16.14 2.94 583
FHLMC 3 15,000,000.00 14,463,720.40 12.63 3.74 1,392
Allspring Money Market Fund 1 8,931,842.56 8,931,842.56 7.80 4.99 1 FNMA 2 5,000,000.00 5,004,701.22 4.37 1.55 523
Toyota 2 3,000,000.00 2,993,849.51 2.61 2.47 163
New York Life 1 2,000,000.00 2,000,711.35 1.75 0.28 113 US Bancorp 1 2,000,000.00 2,000,049.46 1.75 3.36 24
National Securities Clearing 1 2,000,000.00 1,891,261.61 1.65 4.72 663 LAIF 1 1,087,813.05 1,087,813.05 0.95 3.17 1
Comenity Capital Bank 1 248,000.00 248,000.00 0.22 2.75 320 Morgan Stanley Private Bank 1 248,000.00 248,000.00 0.22 2.65 314 Morgan Stanley Bank 1 248,000.00 247,891.77 0.22 2.75 342 Wells Fargo 1 248,000.00 247,846.46 0.22 2.10 475
Total and Average 41 115,511,655.61 114,529,528.79 100.00% 2.67 698 Run Date: 7/10/2023 - 5:51 PM
Amortizing
22 Income Earned Summary
City of Redondo Beach June 30, 2023
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
183,113.71 1,939,967.54
624,367.62 624,367.62
-589,155.37 -357,111.69
218,325.96 2,207,223.47
33,356.92 228,500.11
0.00 0.00
251,682.88 2,435,723.58
Run Date: 7/10/2023 - 5:51 PM
Amortizing
23 Income Earned
City of Redondo Beach June 01, 2023 - June 30, 2023
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
61760AZZ5 Morgan Stanley Private Bank 05/09/2024 248,000.00 248,000.00 248,000.00 414.13 0.00 954.29 540.16 0.00 540.16 20033AW51 Comenity Capital Bank 05/15/2024 248,000.00 248,000.00 248,000.00 317.64 579.23 298.96 560.55 0.00 560.55 61690UHB9 Morgan Stanley Bank 06/06/2024 248,000.00 247,882.28 247,891.77 3,247.10 3,338.83 458.63 550.36 9.49 559.85 949763L95 Wells Fargo Bank NA 10/17/2024 248,000.00 247,836.76 247,846.46 208.93 431.79 195.00 417.86 9.70 427.56 Certificates of Deposit - Sub Total 992,000.00 991,719.04 991,738.23 4,187.80 4,349.85 1,906.88 2,068.93 19.19 2,088.12 Corporate Bonds
90331HNV1 US Bank 07/24/2023 2,000,000.00 2,000,109.23 2,000,049.46 23,988.89 0.00 29,655.56 5,666.67 -59.77 5,606.90 89236TDK8 Toyota Motor Credit 10/18/2023 2,000,000.00 1,992,197.99 1,993,849.51 5,375.00 0.00 9,125.00 3,750.00 1,651.52 5,401.52 64952WDT7 New York Life 10/21/2023 2,000,000.00 2,000,897.20 2,000,711.35 888.89 0.00 1,555.56 666.67 -185.85 480.82 892331AL3 Toyota Motor 03/25/2024 1,000,000.00 1,000,000.00 1,000,000.00 1,248.50 0.00 1,816.00 567.50 0.00 567.50 637639AB1 National Securities Clearing 04/23/2025 2,000,000.00 1,886,432.50 1,891,261.61 3,166.67 0.00 5,666.67 2,500.00 4,829.12 7,329.12 Corporate Bonds - Sub Total 9,000,000.00 8,879,636.92 8,885,871.94 34,667.95 0.00 47,818.79 13,150.84 6,235.02 19,385.86 LAIF
9819716 LAIF 07/01/2023 1,087,813.05 1,087,813.05 1,087,813.05 0.00 0.00 0.00 0.00 0.00 0.00 LAIF - Sub Total 1,087,813.05 1,087,813.05 1,087,813.05 0.00 0.00 0.00 0.00 0.00 0.00 Money Market Funds
FUZXX Allspring Money Market Fund 07/01/2023 8,931,842.56 12,736,246.35 8,931,842.56 26,988.86 26,988.86 47,467.68 47,467.68 0.00 47,467.68 Money Market Funds - Sub Total 8,931,842.56 12,736,246.35 8,931,842.56 26,988.86 26,988.86 47,467.68 47,467.68 0.00 47,467.68 U.S. Agencies
3133EJUS6 FFCB 07/17/2023 4,000,000.00 3,999,631.79 3,999,866.82 42,805.56 0.00 52,388.89 9,583.33 235.03 9,818.36 3133EJYL7 FFCB 09/05/2023 3,000,000.00 2,997,316.50 2,998,144.39 20,066.67 0.00 27,066.67 7,000.00 827.89 7,827.89 3133EJ3Q0 FFCB 12/21/2023 2,000,000.00 2,001,666.44 2,001,417.72 25,555.56 28,750.00 1,597.22 4,791.66 -248.72 4,542.94 3133EKNX0 FFCB 06/03/2024 1,500,000.00 1,502,343.54 1,502,155.80 16,020.00 16,200.00 2,520.00 2,700.00 -187.74 2,512.26 3133EKWV4 FFCB 07/26/2024 1,000,000.00 1,002,347.57 1,002,183.52 6,423.61 0.00 7,965.28 1,541.67 -164.05 1,377.62 3133EKA63 FFCB 08/16/2024 2,000,000.00 1,999,011.84 1,999,077.72 9,333.33 0.00 12,000.00 2,666.67 65.88 2,732.55 3130AQZ48 FHLB 08/28/2024 5,000,000.00 4,922,792.83 4,927,801.80 25,833.33 0.00 34,166.67 8,333.34 5,008.97 13,342.31 3135G0W66 FNMA 10/15/2024 2,000,000.00 2,003,966.04 2,003,733.21 4,152.78 0.00 6,861.11 2,708.33 -232.82 2,475.51 3130A3GE8 FHLB 12/13/2024 2,000,000.00 2,035,747.84 2,033,808.53 25,666.67 27,500.00 2,750.00 4,583.33 -1,939.30 2,644.03 3135G0X24 FNMA 01/07/2025 3,000,000.00 3,001,019.33 3,000,968.01 19,500.00 0.00 23,562.50 4,062.50 -51.32 4,011.18 Run Date: 7/10/2023 - 5:51 PM
Amortizing
24 Income Earned
City of Redondo Beach June 01, 2023 - June 30, 2023
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
3134GW6C5 FHLMC 10/28/2026 5,000,000.00 4,450,738.68 4,463,720.40 3,666.67 0.00 7,000.00 3,333.33 12,981.73 16,315.06 3130AQEC3 FHLB 12/30/2026 2,000,000.00 2,000,000.00 2,000,000.00 11,492.78 13,700.00 76.11 2,283.33 0.00 2,283.33 3130AQLX9 FHLB 01/27/2027 10,000,000.00 10,000,000.00 10,000,000.00 43,055.56 0.00 53,472.22 10,416.66 0.00 10,416.66 3134GXTS3 FHLMC 05/25/2027 5,000,000.00 5,000,000.00 5,000,000.00 2,916.67 0.00 17,500.00 14,583.33 0.00 14,583.33 3134GXR48 FHLMC 08/25/2027 5,000,000.00 5,000,000.00 5,000,000.00 46,000.00 0.00 60,375.00 14,375.00 0.00 14,375.00 3133EPAV7 FFCB 02/14/2028 5,000,000.00 4,985,656.53 4,985,902.22 57,586.81 0.00 73,732.64 16,145.83 245.69 16,391.52 U.S. Agencies - Sub Total 57,500,000.00 56,902,238.92 56,918,780.14 360,076.00 86,150.00 383,034.31 109,108.31 16,541.22 125,649.53 U.S. Treasuries
9128284U1 U.S. Treasury 06/30/2023 0.00 4,999,105.93 0.00 55,110.50 65,625.00 0.00 10,514.50 894.07 11,408.57 912797FY8 U.S. Treasury 07/18/2023 5,000,000.00 0.00 4,987,517.50 0.00 0.00 0.00 0.00 0.00 0.00 91282CAW1 U.S. Treasury 11/15/2023 4,000,000.00 3,999,609.67 3,999,679.37 461.96 0.00 1,277.17 815.21 69.70 884.91 912828YV6 U.S. Treasury 11/30/2024 2,000,000.00 2,031,609.22 2,029,881.94 81.97 0.00 2,540.98 2,459.01 -1,727.28 731.73 91282CEY3 U.S. Treasury 07/15/2025 5,000,000.00 4,872,234.95 4,877,174.32 56,767.96 0.00 69,198.90 12,430.94 4,939.37 17,370.31 91282CAB7 U.S. Treasury 07/31/2025 2,000,000.00 1,986,150.57 1,986,675.17 1,671.27 0.00 2,085.64 414.37 524.60 938.97 91282CAJ0 U.S. Treasury 08/31/2025 2,000,000.00 1,977,569.88 1,978,387.50 1,263.59 0.00 1,671.20 407.61 817.62 1,225.23 91282CFK2 U.S. Treasury 09/15/2025 5,000,000.00 4,918,682.00 4,921,593.15 37,092.39 0.00 51,358.70 14,266.31 2,911.15 17,177.46 91282CAT8 U.S. Treasury 10/31/2025 4,000,000.00 3,980,553.77 3,981,213.71 869.57 0.00 1,684.78 815.21 659.94 1,475.15 91282CAZ4 U.S. Treasury 11/30/2025 3,000,000.00 2,974,329.16 2,975,171.75 30.74 0.00 952.87 922.13 842.59 1,764.72 91282CCF6 U.S. Treasury 05/31/2026 1,000,000.00 995,999.72 996,109.22 20.49 0.00 635.25 614.76 109.50 724.26 91282CCP4 U.S. Treasury 07/31/2026 2,000,000.00 1,994,030.34 1,994,185.13 4,178.18 0.00 5,214.09 1,035.91 154.79 1,190.70 91282CCW9 U.S. Treasury 08/31/2026 3,000,000.00 2,985,528.68 2,985,894.12 5,686.14 0.00 7,520.38 1,834.24 365.44 2,199.68 U.S. Treasuries - Sub Total 38,000,000.00 37,715,403.88 37,713,482.87 163,234.76 65,625.00 144,139.96 46,530.20 10,561.48 57,091.68 Grand Total 115,511,655.61 118,313,058.16 114,529,528.79 589,155.37 183,113.71 624,367.62 218,325.96 33,356.92 251,682.88 Run Date: 7/10/2023 - 5:51 PM
Amortizing
25 Realized Gains and Losses
City of Redondo Beach June 01, 2023 - June 30, 2023
CUSIP Par Value Sale Date Days Held Maturity/Sales Realized Issuer Purchase Date Coupon Rate Maturity Date Term Book Value Proceeds Gain/Loss U.S. Treasuries
9128284U1 06/28/2022 5,000,000.00 06/30/2023 367 5,000,000.00 5,000,000.00 0.00 U.S. Treasury 2.625% 06/30/2023 367
Total U.S. Treasuries 5,000,000.00 5,000,000.00 0.00
Grand Total 5,000,000.00 5,000,000.00 0.00
Run Date: 7/10/2023 - 5:51 PM
Amortizing
26 Transaction Report
City of Redondo Beach June 01, 2023 - June 30, 2023
Transaction Transaction Security Security Maturity
Date Type ID Description Date Purchases Redemptions Interest Deposits Withdrawals 06/01/2023 Interest FUZXX First American Tsy MMF - - 26,988.86 - - 06/05/2023 Interest 3133EKNX0 FFCB 2.16 06/03/24 06/03/2024 - - 16,200.00 - - 06/06/2023 Interest 61690UHB9 MS 2.7 06/06/24 06/06/2024 - - 3,338.83 - - 06/13/2023 Interest 3130A3GE8 FHLB 2 3/4 12/13/24 12/13/2024 - - 27,500.00 - - 06/15/2023 Interest 20033AW51 ADS 2 3/4 05/15/24 05/15/2024 - - 579.23 - - 06/20/2023 Interest 949763L95 WFC 2.05 10/17/24 10/17/2024 - - 431.79 - - 06/21/2023 Interest 3133EJ3Q0 FFCB 2 7/8 12/21/23 12/21/2023 - - 28,750.00 - - 06/22/2023 Withdrawal FUZXX FUZXX - - - - -4,000,000.00 06/30/2023 Interest 3130AQEC3 FHLB 1.37 12/30/26 12/30/2026 - - 13,700.00 - - 06/30/2023 Interest 9128284U1 T 2 5/8 06/30/23 06/30/2023 - - 65,625.00 - - 06/30/2023 Maturity 9128284U1 T 2 5/8 06/30/23 06/30/2023 - 5,000,000.00 - - - 06/30/2023 Purchase 912797FY8 TREASURY BILL 07/18/2023 -4,987,517.50 - - - - Grand Total: -4,987,517.50 5,000,000.00 183,113.71 0.00 -4,000,000.00 Run Date: 7/10/2023 - 5:51 PM
Amortizing
27 Bank of America & LAIF Accounts
Account
General Fund 001
General Fund 002
Parking Authority Fund 003
Housing Authority Fund 004
Redevelopment Agency Fund 005
Public Finance Authority Fund 006
Workmens-Comp Fund 007
Measure-R-Local-Return Fund 008
City of Redondo Beach-FSA Fund 009
Trust Account Fund 011
TOTAL
Checking
9,742,074.97
978.97
2,082,942.46
1,052,373.78
1,489,920.15
1,692,304.90
105,959.23
7,364.40
3,713,755.26
1,087,813.05 1,087,813.05
1,489,920.15
1,692,304.90
105,959.23
1,894,354.58
180,757.65
23,055,846.73
City of Redondo Beach 6/30/2023
Bank of America Accounts & LAIF Accounts
Total
9,742,074.97
7,364.40
LAIF
-
5,247.33
-
6,226.30
2,082,942.46
2,946,728.36
3,894,512.91
28