1. CALL TO ORDER
2. CERTIFICATION OF AGENDA POSTING BY SECRETARY
3. ROLL CALL OF MEMBERS
This Agenda contains a brief general description of each item to be considered. Copies of the Staff reports or other written documentation relating to each item of business referred to on the Agenda are on file in the Office of the City Clerk and are available for public inspection. Any person who has a question concerning any of the agenda items may call the City Manager at (310) 603-0220, ext. 200.
Procedures for Addressing the Council
IN ORDER TO EXPEDITE CITY COUNCIL BUSINESS, WE ASK THAT ALL PERSONS WISHING TO
ADDRESS THE COUNCIL SUBMIT YOUR COMMENTS IN ADVANCE TO
[email protected] OR FILL OUT A FORM PROVIDED AT THE PODIUM, AND TO TURN IT IN TO THE CITY CLERK PRIOR TO THE START OF THE MEETING. FAILURE TO FILL OUT SUCH A
FORM WILL PROHIBIT YOU FROM ADDRESSING THE COUNCIL IN THE ABSENCE OF THE UNANIMOUS CONSENT OF THE COUNCIL.
AGENDA
Lynwood Public Financing Authority
TO BE HELD ON
September 19, 2023
COUNCIL CHAMBERS - 11350 BULLIS ROAD. LYNWOOD, CA 90262 OR WEB CONFERENCE VIA ZOOM - TO PARTICIPATE VIA ZOOM OR BY TELEPHONE: 1-669- 900-9128 OR 1-253-215-8782 MEETING ID: 835 2029 8238
Duly Posted on 9/16/23 By MQ
6:00 PM
Oscar Flores, President
Rita Soto, Vice President
Gabriela Camacho, Member
Juan Munoz-Guevara, Member
Jose Luis Solache, Member
GOVERNMENT CODE SECTION 54954.3
Members of the City Council are also members of Lynwood Public Financing Authority, which is concurrently convening with the City Council this evening and each Council Member is paid an Additional Stipend of $100 for Attending the Lynwood Public Financing Authority Meeting. Further, the Authority is scheduled to meet four (4) timer per year. If additional meetings are required beyond the scheduled four (4) meetings, the City Council will only get paid for the first four(4) meetings.
Lynwood Public Financing Authority 1
4. CONSENT CALENDAR
4.1 TREASURER'S QUARTERLY REPORT
PUBLIC ORAL COMMUNICATIONS
(Regarding Agenda Items Only)
NON-AGENDA PUBLIC ORAL COMMUNICATIONS
THIS PORTION PROVIDES AN OPPORTUNITY FOR THE PUBLIC TO ADDRESS THE
LYNWOOD PUBLIC FINANCING AUTHORITY ON ITEMS WITHIN THE JURISDICTION OF THE LYNWOOD PUBLIC FINANCING AUTHORITY AND NOT LISTED ON THE AGENDA.
IF AN ITEM IS NOT ON THE AGENDA, THERE SHOULD BE NO SUBSTANTIAL
DISCUSSION OF THE ISSUE BY LYNWOOD PUBLIC FINANCING AUTHORITY, BUT
LYNWOOD PUBLIC FINANCING AUTHORITY MAY REFER THE MATTER TO STAFF OR SCHEDULE SUBSTANTIVE DISCUSSION FOR A FUTURE MEETING. (The Ralph M. Brown Act, Government Code Section 54954.2 (a).)
ALL MATTERS LISTED UNDER THE CONSENT CALENDAR WILL BE ACTED UPON BY ONE MOTION AFFIRMING THE ACTION RECOMMENDED ON THE AGENDA. THERE
WILL BE NO SEPARATE DISCUSSION ON THESE ITEMS PRIOR TO VOTING UNLESS
MEMBERS OF THE COUNCIL OR STAFF REQUEST SPECIFIC ITEMS TO BE REMOVED FROM THE CONSENT CALENDAR FOR SEPARATE ACTION.
Comments:
The purpose of this item is to have the Honorable Mayor and the Lynwood City Council review the Treasurer's Quarterly Investment Report as required by State Statutes (CT).
Recommendation:
It is recommended that the City of Lynwood receive and file the attached Quarterly Investment Report. The following information provided in this report highlights the investment activity for the 4th quarter ending June 30, 2023.
ADJOURMENT
THE LYNWOOD PUBLIC FINANCE AUTHORITY MEETINGS WILL BE POSTED AS NEEDED. THE NEXT MEETING WILL BE HELD IN THE COUNCIL CHAMBERS OF CITY HALL ANNEX, 11350 BULLIS ROAD, CITY OF LYNWOOD, CALIFORNIA.
Lynwood Public Financing Authority 2
AGENDA STAFF REPORT
DATE:
September 19, 2023
TO:
Honorable President and Members of the Public Finance Authority APPROVED BY:
Ernie Hernandez, City Manager
PREPARED BY:
Luis Cuellar, City Treasurer
Sheila Harding, Deputy City Treasurer
SUBJECT:
TREASURER'S QUARTERLY REPORT
Agenda Item # 4.1.
Recommendation:
It is recommended that the City of Lynwood receive and file the attached Quarterly Investment Report. The following information provided in this report highlights the investment activity for the 4th quarter ending June 30, 2023.
Background:
Due to the crisis caused by the Orange County investment pool, the State Legislature in 1995 enacted SB564 and SB866. These laws were enacted as State Statutes to impose certain mandates regarding investments with public funds. The statutes have imposed the following mandates:
Annual adoption of an Investment Policy that incorporates changes mandated by the State. 1 .
Quarterly Investment Reports presented to the Legislative Body or Board Members. 2 .
Restriction on the use of certain investment instruments.
The purpose of the Treasurer’s report is to update the City Council and the public of the status of the City’s cash balances, investments and highlight changes from one period to another.
This report includes reconciliation between cash and investment balances, a schedule of all investments, and a report providing information on all investment types, costs, interest rates, maturity dates and current market value.
Lynwood Public Financing Authority Lynwood Public Financing Authority 3 June 2023.pdf
FHN - APRIL 2023.pdf
FHN - MAY 2023.pdf
FHN -JUNE
2023.pdf
Discussion and Analysis:
The market value of securities fluctuates, depending on how interest rates perform. When interest rates decrease, the market value of the securities in the City’s portfolio will likely increase and when the interest rates increase, the market value of the securities will likely decrease. The City’s practice is to buy and hold investments until maturity so changes in the market price do not affect the City’s investment principal.
Short-term excess cash is primarily invested in the Local Agency Investment Fund (LAIF) administered by the State Treasurer. LAIF is a high-quality investment available in terms of safety, liquidity and yield. The City’s cash and investment portfolio is sufficiently liquid to meet expected expenditures for the coming six months.
The majority of property tax revenues are received from the County in December and April and a portion of the revenue received is invested in the Local Agency Investment Fund and can be withdrawn at any time.
The market valuation is provided by FTN Main Street Capital Advisors and all of the investments are in compliance with California Government Code Sections 53600 et seq. and the City’s investment policy.
Fiscal Impact:
The action recommended in this report will not have a fiscal impact on the City.
Coordinated With:
ATTACHMENTS:
Description
Lynwood Public Financing Authority Lynwood Public Financing Authority 4 PAR MARKET BOOK % OF
INVESTMENTS VALUE VALUE VALUE PORTFOLIO
*Money Market Funds 93,328.79$ 93,328.79$ 93,328.79$ 0.25% LAIF 9,710,816.80$ 9,710,816.80$ 9,710,816.80$ 26.27% Corporate Notes 3,500,000.00$ 3,370,127.50$ 3,489,970.23$ 9.44% Commercial Paper 500,000.00$ 499,225.00$ 499,806.17$ 1.35% Federal Agency 10,440,000.00$ 10,037,715.40$ 10,396,230.98$ 28.13% Treasury Coupon Securities 6,630,000.00$ 6,186,375.80$ 6,615,279.05$ 17.90% CD-FDIC 6,157,000.00$ 5,995,122.14$ 6,153,985.50$ 16.65% TOTAL 37,031,145.59$ 35,892,711.43$ 36,959,417.52$ 100.00% *Money Market Fund held at Goldman Sach
Schedule of City Cash & Investments: This schedule provides information on the cash and investments managed by the City.
Interest Credit
Time Deposit/MM/Certificate of Deposit Balance Maturity Date F/Y to Date JP Morgan Chase (Section 108) 126,484.90$ N/A 3,825.20$ JP Morgan Chase - Money Market Account 1,900,171.81$ N/A 5,894.78$ JP Morgan Chase - Parking Enforcement 6,457,307.03$ N/A 31,226.52$ US Bank - City of Lynwood 4,540.38$ N/A 0.10$ TOTAL 8,488,504.12$ 40,946.60$
Corporate Checking Accounts Balance
General Account 45,772,564.15$
US Bank - City HCDA 150,518.11$
US Bank - City Home Program 1,020,153.96$
US Bank - Economic Development 10,696.54$
US Bank - Housing Authority A 79,424.18$
US Bank - Housing Authority B 18,000.09$
US Bank - Lyn Tr. Center Unf Wrkr 2,791.24$
US Bank - City of Lynwood 49,028.48$
US Bank - RORF Successor Agency 7,826,014.85$
US Bank - Low Mod Housing Trst Fnd/Rogel 6,910,066.97$
US Bank - Taxable Tabs Housing Proj. 2,611,325.52$
US Bank - US Dept. of HUD/Section 108 170,048.96$
US Bank - Lynwood Disaster Relief Fund 5,000.00$
US Bank - Settlement Remittance Fund 340,637.36$
US Bank - Housing Authority 6,376.71$
TOTAL 64,972,647.12$
CITY OF LYNWOOD
QUARTERLY REPORT
June 30, 2023
PORTFOLIO SUMMARY
June 2023
5 AVERAGE
MARKET PERCENTAGE (%) DAYS TO
DESCRIPTION VALUE PORTFOLIO MATURITY
INVESTMENTS* 35,892,711.43 100% *
MONEY MARKET/CUSTODY HOLDINGS 8,488,504.12
DEMAND DEPOSIT ACCOUNTS 64,972,647.12
TOTAL AVERAGES 73,461,151.24$
TOTAL INVESTMENTS & AVERAGES 109,353,862.67$
Luis Cuellar/Sheila Harding
Luis Cuellar/Sheila Harding I certify that this report accurately reflects all pooled City Treasurer/Deputy City Treasurer investment policy statements adopted by the City Council on August 15, 1995. A copy of this policy is available at the office of the City Clerk. The Investment Program herein shown provides sufficient cash flow liquidy to meet 3 to 6 months estimated expenditures.
*See Report Prepared by Main Street Capital Advisors
CITY OF LYNWOOD
QUARTERLY REPORT
June 30, 2023
MASTER SUMMARY
June 2023
6 APRIL MAY JUNE
Market Value $36,034,503 $35,980,160 $35,892,711
Book Value $36,855,143 $36,918,580 $36,959,418
Variance -$820,640 -$938,420 -$1,066,706
Par Value $36,939,052 $36,992,817 $37,031,146
Net Asset Value $97.77 $97.46 $97.11
Book Yield 2.74% 2.78% 2.84%
Market Yield 4.05% 4.31% 4.72%
Years to Maturity 1.83 1.79 1.76
Effective Durantion 1.55 1.46 1.46
APRIL MAY JUNE
Total Earnings Per Month 60,662.56 75,237.91 60,976.75
F/Y Earnings to Date $653,599.11 $728,837.03 $789,813.78 Average Daily Balance $36,817,284.86 $36,880,435.58 $36,925,193.72 F/Y Average Daily Balance $35,431,645.24 $35,563,353.46 $35,676,840.15 Book Rate of Return 2.00% 2.40% 2.01%
F/Y Book Rate of Return 2.21% 2.23% 2.21%
APRIL MAY JUNE
CD-FDIC 5,661,000.00 6,157,000.00 6,157,000.00
Commercial Paper 500,000.00 500,000.00 500,000.00
Corporate Bonds 3,500,000.00 3,500,000.00 3,500,000.00
LAIF 9,710,816.80 9,710,816.80 9,710,816.80
Money Market Funds 127,234.79 55,000.40 93,328.79
U.S. Agencies 10,440,000.00 10,440,000.00 10,440,000.00 U.S. Treasuries 7,000,000.00 6,630,000.00 6,630,000.00
TOTAL 36,939,051.59 36,992,817.20 37,031,145.59
HOLDINGS
PORTFOLIO SUMMARY
AT A GLANCE
ACCOUNT SUMMARY
APRIL - JUNE 2023
7 Run Date: 5/4/2023 - 12:59 PM
Amortizing Page 2
Portfolio Summary
City of Lynwood 4/30/2023
SECTOR ALLOCATION MATURITY DISTRIBUTION CREDIT QUALITY (MOODY'S)
ACCOUNT SUMMARY MONTH-END PORTFOLIO BOOK YIELD TOP ISSUERS 4/30/23 3/31/23 Issuer % Portfolio
Market Value $36,034,503 $35,917,091 LAIF 26.3%
Book Value $36,855,143 $36,764,317 FHLB 20.9%
Variance -$820,640 -$847,226 U.S. Treasury 18.9%
FFCB 4.6%
Par Value $36,939,052 $36,851,305 JPMorgan 1.4%
FNMA 1.4%
Net Asset Value $97.77 $97.70 MetLife 1.4%
FHLMC 1.4%
Book Yield 2.74% 2.73% Apple 1.3%
Royal Bank of Canada 1.3%
Market Yield 4.05% 4.01% 3M 1.3%
Exxon Mobil 0.7%
Years to Maturity 1.83 1.90 Toyota 0.7%
US Bancorp 0.7%
Effective Duration 1.55 1.55 New York Life 0.7%
May-22
Jun-22
Jul-22
Aug-22
Sep-22
Oct-22
Nov-22
Dec-22
Jan-23
Feb-23
Mar-23
Apr-23
0.60%
1.10%
1.60%
2.10%
2.60%
3.10%
0.3%
1.3%
9.5%
15.4%
18.9%
26.3%
28.2%
MMF
CP
CORP
CD
TSY
LAIF
AGY
100%75%50%25%0%
41.3%
13.5%
18.2%
11.3%
15.6%
0-1Y 1-2Y 2-3Y 3-4Y 4-5Y+
0%
10%
20%
30%
40%
50%
60%
70%
41.7%
1.4%
4.0%
1.4%
0.7%
49.5%
1.3%
NR
A3
A2
A1
Aa3
Aa2
Aa1
Aaa
P-1
100%75%50%25%0%
2 8
Run Date: 5/4/2023 - 12:59 PM
Amortizing Page 3
Investment Policy Compliance
City of Lynwood 4/30/2023
Category Book Value % of Portfolio Allowed by Policy In ComplianceReserved row US Treasuries 6,977,606.55 18.93% 100% Yes
US Federal Agencies 10,394,613.31 28.20% 100% Yes
Supranational Obligations 0.00 0.00% 30% Yes
LAIF 9,710,816.80 26.35% $75,000,000 Yes
Commercial Paper 495,929.61 1.35% 25% Yes
Money Market Funds 127,234.79 0.35% 20% Yes
Negotiable Certificates of Deposit 5,659,367.58 15.36% 30% Yes Corporate Obligations 3,489,574.05 9.47% 30% Yes
State and Local Governments 0.00 0.00% 100% Yes
Total 36,855,142.68 100.00%
Other Metrics Portfolio Metric In Compliance
Weighted Average Maturity 1.83 Less than 3.0 Years Yes
Liquidity 41.27% 30% Under 365 Days Yes
Ratings Yes
3 9
Run Date: 5/4/2023 - 12:59 PM
Amortizing Page 11
Historical Earnings & Book Return Performance
City of Lynwood 4/30/2023
Fiscal YTD ($K) Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun FY 2021 $35.200 $66.215 $94.922 $120.389 $147.318 $173.870 $199.724 $223.094 $247.869 $271.162 $294.542 $316.873 FY 2022 $18.153 $37.347 $56.010 $82.204 $100.760 $118.668 $142.482 $159.901 $178.121 $203.773 $222.371 $242.161 FY 2023 $22.510 $61.308 $112.501 $198.598 $252.119 $307.834 $413.953 $476.124 $592.937 $653.599 Fiscal YTD Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Book Return 0.97% 1.17% 1.36% 1.75% 1.76% 1.76% 2.02% 2.04% 2.24% 2.21% Fiscal Year-To-Date Earnings
Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun
$0
$100
$200
$300
$400
$500
$600
$700
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
0.00%
0.25%
0.50%
0.75%
1.00%
1.25%
1.50%
1.75%
2.00%
2.25%
2.50%
11 10
Portfolio Summary
City of Lynwood April 30, 2023
Investments Par Value Book Value
% of
Portfolio YTMMaturity
Days to
Market Value
Book
Certificates of Deposit 5,661,000.00 5,659,367.58 15.36 3.12 1,069 5,579,077.34 Commercial Paper 500,000.00 495,929.61 1.35 4.76 64 494,884.50 Corporate Bonds 3,500,000.00 3,489,574.05 9.47 3.22 739 3,400,397.50 LAIF 9,710,816.80 9,710,816.80 26.35 2.87 1 9,710,816.80 Money Market Funds 127,234.79 127,234.79 0.35 4.76 1 127,234.79 U.S. Agencies 10,440,000.00 10,394,613.31 28.20 3.21 939 10,098,132.20 U.S. Treasuries 7,000,000.00 6,977,606.55 18.93 1.12 888 6,623,960.00 36,855,142.68 100.00 668 36,034,503.13 2.74 36,939,051.59 Investments
April 30 Month Ending Fiscal Year To DateTotal Earnings Current Year 60,662.56 653,599.11
Average Daily Balance 36,817,284.86 35,431,645.24
Book Rate of Return 2.00% 2.21%
Run Date: 5/4/2023 - 12:57 PM
Amortizing
15 11
Holdings Report
City of Lynwood April 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
20033AZK5 248,000.00Comenity Capital Bank 06/29/2018
247,427.12 99.66 247,159.89 0.67% NR/NR 0.1606/29/2023 -821.28 NR 0.24 739.92 3.40% 247,981.18 5.38%3.300%
38148PR33 248,000.00Goldman Sachs Bank 07/09/2018 247,432.08 99.63 247,085.39 0.67% NR/NR 0.1807/06/2023 -893.74 NR 0.26 2,578.52 3.35% 247,979.13 5.26%3.300% 949763TF3 248,000.00Wells Fargo Bank NA 08/31/2018 247,429.60 99.30 246,251.69 0.67% NR/NR 0.3308/30/2023 -1,710.17 NR 0.41 717.50 3.35% 247,961.87 5.45%3.300% 29278TLY4 248,000.00EnerBank 09/30/2019 247,523.84 98.61 244,559.66 0.67% NR/NR 0.4109/27/2023 -3,391.35 NR 0.48 54.36 2.05% 247,951.01 5.47%2.000% 17312Q3B3 248,000.00Citibank 02/28/2019 247,427.12 98.06 243,185.54 0.67% NR/NR 0.8302/27/2024 -4,719.34 NR 0.88 1,284.16 3.05% 247,904.89 5.42%3.000% 32100LCB9 248,000.00First Missouri State Bank 09/13/2019 248,000.00 95.75 237,454.99 0.67% NR/NR 1.3809/13/2024 -10,545.01 NR 1.42 615.92 1.85% 248,000.00 5.10%1.850% 27002YFE1 248,000.00EagleBank 08/18/2022 248,000.00 97.88 242,746.12 0.67% NR/NR 2.3008/18/2025 -5,253.88 NR 2.26 291.48 3.30% 248,000.00 4.27%3.300% 05580AXF6 248,000.00BMW Bank 09/25/2020 248,000.00 91.44 226,767.05 0.67% NR/NR 2.4109/25/2025 -21,232.95 NR 2.46 125.70 0.50% 248,000.00 4.29%0.500% 856283S98 248,000.00State Bank of India 04/27/2021 248,000.00 91.53 226,999.75 0.67% NR/NR 2.9904/27/2026 -21,000.25 NR 3.01 27.18 1.00% 248,000.00 4.03%1.000% 02007GUP6 248,000.00Ally Bank 07/07/2022 248,000.00 98.29 243,756.04 0.67% NR/NR 3.1907/07/2026 -4,243.96 NR 3.05 2,594.83 3.35% 248,000.00 3.92%3.350% 89235MLC3 248,000.00Toyota Financial Savings Bank 07/15/2021 248,000.00 91.00 225,681.57 0.67% NR/NR 3.2107/15/2026 -22,318.43 NR 3.22 684.21 0.95% 248,000.00 3.96%0.950% 90348JR93 248,000.00UBS Bank USA 08/11/2021 248,000.00 90.79 225,163.77 0.67% NR/NR 3.2808/11/2026 -22,836.23 NR 3.30 129.10 0.95% 248,000.00 3.95%0.950% 15721UFP9 248,000.00CFBank 03/15/2023 248,000.00 102.79 254,924.21 0.67% NR/NR 3.3809/15/2026 6,924.21 NR 3.15 516.38 4.75% 248,000.00 3.86%4.750% 32117BFR4 248,000.00First National Bank 03/23/2023 248,000.00 103.62 256,968.35 0.67% NR/NR 3.4009/23/2026 8,968.35 NR 3.15 271.78 5.00% 248,000.00 3.86%5.000% 254673L38 248,000.00Discover Bank 07/07/2022 248,000.00 98.75 244,887.84 0.67% NR/NR 4.1907/06/2027 -3,112.16 NR 3.91 2,656.66 3.40% 248,000.00 3.73%3.400% 14042RST9 248,000.00Capital One Bank NA 07/07/2022 248,000.00 98.94 245,369.26 0.67% NR/NR 4.1907/07/2027 -2,630.74 NR 3.91 2,672.28 3.45% 248,000.00 3.72%3.450% 14042TJD0 248,000.00Capital One Bank USA 08/03/2022 248,000.00 99.36 246,406.38 0.67% NR/NR 4.2608/03/2027 -1,593.62 NR 3.97 2,098.49 3.55% 248,000.00 3.71%3.550% 61768ELH4 248,000.00Morgan Stanley Private Bank 08/04/2022 248,000.00 99.16 245,913.84 0.67% NR/NR 4.2708/04/2027 -2,086.16 NR 3.97 2,045.15 3.50% 248,000.00 3.71%3.500% 87164XN93 248,000.00Synchrony Bank 08/05/2022 248,000.00 99.16 245,912.66 0.67% NR/NR 4.2708/05/2027 -2,087.34 NR 3.98 2,021.37 3.50% 248,000.00 3.71%3.500% Run Date: 5/4/2023 - 12:57 PM
Amortizing
16 12
Holdings Report
City of Lynwood April 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
02589ADQ2 205,000.00American Express National Bank 08/12/2022 203,975.00 98.96 202,861.91 0.55% NR/NR 4.2808/10/2027 -1,259.76 NR 4.00 1,550.14 3.56% 204,121.67 3.71%3.450% 32114VCH8 248,000.00First National Bank of Michigan 03/15/2023 248,000.00 104.34 258,762.50 0.67% NR/NR 4.8803/15/2028 10,762.50 NR 4.38 500.08 4.60% 248,000.00 3.62%4.600% 61690U3C2 248,000.00Morgan Stanley Bank 03/16/2023 247,454.40 105.20 260,906.15 0.67% NR/NR 4.8803/16/2028 13,438.31 NR 4.36 1,500.23 4.85% 247,467.84 3.63%4.800% 062119BK7 248,000.00Bank Five Nine 03/20/2023 248,000.00 104.58 259,352.77 0.67% NR/NR 4.8903/20/2028 11,352.77 NR 4.39 347.54 4.65% 248,000.00 3.62%4.650% 5,656,669.16 5,579,077.34 15.36% 2.93
5,659,367.58 3.12% 5,661,000.00 4.24% 26,022.98 -80,290.23 2.78Total Certificates of Deposit Commercial Paper
78015DU32 500,000.00Royal Bank of Canada, NY 10/07/2022 482,813.89 98.98 494,884.50 1.35% P-1/A-1+ 0.1807/03/2023 -1,045.11 F1+ 0.26 0.00 4.76% 495,929.61 5.90%0.000% 482,813.89 494,884.50 1.35% 0.18
495,929.61 4.76% 500,000.00 5.90% 0.00 -1,045.11 0.26Total Commercial Paper Corporate Bonds
90331HNV1 250,000.00US Bank 03/01/2019
253,307.50 99.55 248,865.00 0.68% A2/AA- 0.2307/24/2023 -1,310.51 AA- 0.30 2,290.28 3.08% 250,175.51 5.32%3.400% 06/23/2023 89236TFS9 250,000.00Toyota Motor Credit 02/28/2019 253,545.00 98.79 246,980.00 0.68% A1/A+ 0.6901/08/2024 -3,522.38 A+ 0.74 2,628.82 3.03% 250,502.38 5.15%3.350% 46625HJX9 500,000.00JPMorgan Chase & Co 05/13/2019 515,115.00 98.51 492,550.00 1.37% A1/A- 1.0405/13/2024 -10,582.16 AA- 1.06 8,458.33 2.97% 503,132.16 5.12%3.625% 64952WDL4 250,000.00New York Life 01/22/2020 249,102.50 95.26 238,147.50 0.68% Aaa/AA+ 1.7301/22/2025 -11,542.36 AAA 1.73 1,375.00 2.08% 249,689.86 4.89%2.000% 88579YBH3 500,000.003M 09/07/2022 476,510.00 95.32 476,605.00 1.31% A1/A 1.8002/14/2025 -6,145.79 NR 1.79 2,138.89 4.04% 482,750.79 4.76%2.000% 30231GBH4 250,000.00Exxon Mobil 06/22/2020 272,752.50 97.34 243,355.00 0.70% Aa2/AA- 1.8903/19/2025 -15,695.35 NR 1.84 872.67 0.99% 259,050.35 4.48%2.992% 02/19/2025 59217GFC8 500,000.00MetLife 08/25/2022 499,380.00 97.83 489,170.00 1.36% Aa3/AA- 2.3208/25/2025 -10,350.65 AA- 2.23 3,712.50 4.09% 499,520.65 5.05%4.050% 037833BY5 500,000.00Apple 08/25/2022 496,085.00 97.78 488,880.00 1.35% Aaa/AA+ 2.8202/23/2026 -7,967.46 NR 2.63 3,069.44 3.49% 496,847.46 4.09%3.250% Run Date: 5/4/2023 - 12:57 PM
Amortizing
17 13
Holdings Report
City of Lynwood April 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
Corporate Bonds
808513BW4 250,000.00Charles Schwab 04/12/2022
249,407.50 93.22 233,037.50 0.68% A2/A- 3.9204/01/2027 -16,495.19 A 3.62 687.50 3.35% 249,532.69 5.24%3.300% 023135CF1 250,000.00Amazon 06/09/2022 248,005.00 97.12 242,807.50 0.67% A1/AA 3.9604/13/2027 -5,564.70 AA- 3.62 412.50 3.48% 248,372.20 4.10%3.300% 3,513,210.00 3,400,397.50 9.47% 2.03
3,489,574.05 3.22% 3,500,000.00 4.80% 25,645.93 -89,176.55 1.94Total Corporate Bonds LAIF
9819499 9,710,816.80LAIF 04/14/2023
9,710,816.80 1.00 9,710,816.80 26.35% NR/NR 0.0005/01/2023
0.00 NR 0.00 0.00 2.87% 9,710,816.80 2.87%2.870%
9,710,816.80 9,710,816.80 26.35% 0.00
9,710,816.80 2.87% 9,710,816.80 2.87% 0.00 0.00 0.00Total LAIF Money Market Funds
FGTXX 127,234.79Goldman Sachs Govt MMF 127,234.79 1.00 127,234.79 0.35% Aaa/AAA 0.0005/01/2023
0.00 NR 0.00 465.08 4.76% 127,234.79 4.76%4.760%
127,234.79 127,234.79 0.35% 0.00
127,234.79 4.76% 127,234.79 4.76% 465.08 0.00 0.00Total Money Market Funds U.S. Agencies
3130A0XE5 1,640,000.00FHLB 08/22/2022
1,636,785.60 98.61 1,617,253.20 4.45% Aaa/AA+ 0.8603/08/2024 -20,966.16 AAA 0.90 7,846.94 3.38% 1,638,219.36 4.92%3.250% 3133EKTV8 500,000.00FFCB 07/02/2019 499,900.00 96.76 483,805.00 1.36% Aaa/AA+ 1.1707/01/2024 -16,171.60 AAA 1.20 3,166.67 1.90% 499,976.60 4.78%1.900% 3133ENG20 1,000,000.00FFCB 08/18/2022 998,300.00 98.34 983,410.00 2.71% Aaa/AA+ 1.3008/15/2024 -15,487.49 AAA 1.31 6,966.67 3.39% 998,897.49 4.63%3.300% 3133EK3B0 200,000.00FFCB 10/17/2019 198,370.00 95.87 191,744.00 0.54% Aaa/AA+ 1.4710/16/2024 -7,779.41 AAA 1.48 125.00 1.67% 199,523.41 4.45%1.500% 3130A4CH3 500,000.00FHLB 10/07/2020 541,330.00 96.53 482,630.00 1.40% Aaa/AA+ 1.8703/14/2025 -34,812.97 AAA 1.87 1,550.35 0.49% 517,442.97 4.33%2.375% 3136G4H71 500,000.00FNMA 08/18/2020 500,000.00 92.14 460,710.00 1.36% Aaa/AA+ 2.2908/12/2025 -39,290.00 AAA 2.31 506.94 0.50% 500,000.00 4.14%0.500% 02/18/2022 Run Date: 5/4/2023 - 12:57 PM
Amortizing
18 14
Holdings Report
City of Lynwood April 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
3130ASYR4 2,000,000.00FHLB 08/30/2022
2,000,000.00 98.69 1,973,760.00 5.43% Aaa/AA+ 2.3308/28/2025 -26,240.00 AAA 1.40 14,000.00 4.00% 2,000,000.00 4.60%4.000% 05/28/2023 3137EAEX3 500,000.00FHLMC 10/20/2020 497,505.00 91.59 457,925.00 1.35% Aaa/AA+ 2.4009/23/2025 -40,860.57 AAA 2.41 197.92 0.48% 498,785.57 4.10%0.375% 3130AQEC3 500,000.00FHLB 12/30/2021 500,000.00 90.37 451,860.00 1.36% Aaa/AA+ 3.6712/30/2026 -48,140.00 AAA 3.54 2,302.36 1.37% 500,000.00 4.23%1.370% 06/30/2023 3130AL5A8 500,000.00FHLB 02/09/2023 438,340.00 88.79 443,935.00 1.20% Aaa/AA+ 3.8302/26/2027 2,167.09 AAA 3.74 812.50 4.25% 441,767.91 4.10%0.900% 05/26/2023 3130ARTT8 600,000.00FHLB 05/19/2022 600,000.00 96.89 581,340.00 1.63% Aaa/AA+ 4.0505/19/2027 -18,660.00 AAA 2.31 8,100.00 3.00% 600,000.00 3.84%3.000% 05/19/2023 3130AT2L0 1,000,000.00FHLB 08/30/2022 1,000,000.00 97.32 973,240.00 2.71% Aaa/AA+ 4.3208/25/2027 -26,760.00 AAA 2.54 7,425.00 4.05% 1,000,000.00 4.74%4.050% 08/25/2023 3130AV6P2 1,000,000.00FHLB 03/27/2023 1,000,000.00 99.65 996,520.00 2.71% Aaa/AA+ 4.9103/27/2028 -3,480.00 AAA 0.77 5,713.89 6.05% 1,000,000.00 6.13%6.050% 06/27/2023 10,410,530.60 10,098,132.20 28.20% 2.57
10,394,613.31 3.21% 10,440,000.00 4.68% 58,714.24
-296,481.11 1.73Total U.S. Agencies
U.S. Treasuries
91282CAW1 1,000,000.00U.S. Treasury 07/22/2021
999,960.94 97.50 975,040.00 2.71% Aaa/AA+ 0.5511/15/2023 -24,950.81 AAA 0.60 1,153.31 0.25% 999,990.81 4.98%0.250% 91282CBV2 500,000.00U.S. Treasury 11/22/2021 496,308.59 95.86 479,280.00 1.35% Aaa/AA+ 0.9604/15/2024 -19,239.22 AAA 1.01 81.97 0.69% 498,519.22 4.85%0.375% 912828YV6 1,000,000.00U.S. Treasury 07/22/2021 1,035,742.19 95.69 956,880.00 2.76% Aaa/AA+ 1.5911/30/2024 -60,015.25 AAA 1.60 6,263.74 0.43% 1,016,895.25 4.34%1.500% 912828ZT0 500,000.00U.S. Treasury 06/29/2021 491,542.97 92.46 462,285.00 1.34% Aaa/AA+ 2.0905/31/2025 -33,214.82 AAA 2.10 521.98 0.69% 495,499.82 4.06%0.250% 91282CAZ4 1,000,000.00U.S. Treasury 07/22/2021 989,492.19 91.47 914,730.00 2.70% Aaa/AA+ 2.5911/30/2025 -79,032.64 AAA 2.59 1,565.93 0.62% 993,762.64 3.87%0.375% 91282CBH3 500,000.00U.S. Treasury 02/25/2021 494,433.59 91.06 455,295.00 1.35% Aaa/AA+ 2.7601/31/2026 -41,592.63 AAA 2.75 466.16 0.60% 496,887.63 3.83%0.375% 91282CCF6 1,000,000.00U.S. Treasury 07/22/2021 1,002,382.81 91.28 912,810.00 2.72% Aaa/AA+ 3.0905/31/2026 -88,703.77 AAA 3.05 3,131.87 0.70% 1,001,513.77 3.77%0.750% 91282CCZ2 500,000.00U.S. Treasury 10/19/2021 492,949.22 91.01 455,060.00 1.34% Aaa/AA+ 3.4209/30/2026 -40,066.49 AAA 3.37 370.56 1.17% 495,126.49 3.70%0.875% 91282CGC9 1,000,000.00U.S. Treasury 03/03/2023 978,710.94 101.26 1,012,580.00 2.66% Aaa/AA+ 4.6712/31/2027 33,169.08 AAA 4.24 12,952.35 4.37% 979,410.92 3.58%3.875% Run Date: 5/4/2023 - 12:57 PM
Amortizing
19 15
Holdings Report
City of Lynwood April 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
6,981,523.44 6,623,960.00 18.93% 2.43
6,977,606.55 1.12% 7,000,000.00 4.11% 26,507.87
-353,646.55 2.38Total U.S. Treasuries
36,882,798.68 36,034,503.13 100.00% 1.83
137,356.10
-820,639.55 1.55 4.05% 36,855,142.68 2.74% 36,939,051.59TOTAL PORTFOLIO TOTAL MARKET VALUE PLUS ACCRUED INTEREST 36,171,859.23 Run Date: 5/4/2023 - 12:57 PM
Amortizing
20 16
Maturity Report
City of Lynwood April 30, 2023
CUSIP Date
Purchase
Value
Book
Rate
Coupon
Date
Maturity
Par
Remaining
Term Value
Market
YTMIssuer
Days to
Maturity
Book
FGTXX 4.760% 1Goldman Sachs Govt MMF 127,234.79 05/01/2023 1 4.76% 127,234.79 127,234.79 9819499 2.870% 1LAIF 05/18/2020 9,710,816.80 05/01/2023 1 2.87% 9,710,816.80 9,710,816.80 20033AZK5 3.300% 1,766Comenity Capital Bank 06/29/2018 247,981.18 06/29/2023 60 3.40% 248,000.00 247,159.89 78015DU32 0.000% 205Royal Bank of Canada, NY 10/07/2022 495,929.61 07/03/2023 64 4.76% 500,000.00 494,884.50 38148PR33 3.300% 1,756Goldman Sachs Bank 07/09/2018 247,979.13 07/06/2023 67 3.35% 248,000.00 247,085.39 90331HNV1 3.400% 1,521US Bank 03/01/2019 250,175.51 07/24/2023 85 3.08% 250,000.00 248,865.00 949763TF3 3.300% 1,703Wells Fargo Bank NA 08/31/2018 247,961.87 08/30/2023 122 3.35% 248,000.00 246,251.69 29278TLY4 2.000% 1,308EnerBank 09/30/2019 247,951.01 09/27/2023 150 2.05% 248,000.00 244,559.66 91282CAW1 0.250% 647U.S. Treasury 07/22/2021 999,990.81 11/15/2023 199 0.25% 1,000,000.00 975,040.00 89236TFS9 3.350% 1,522Toyota Motor Credit 02/28/2019 250,502.38 01/08/2024 253 3.03% 250,000.00 246,980.00 17312Q3B3 3.000% 1,522Citibank 02/28/2019 247,904.89 02/27/2024 303 3.05% 248,000.00 243,185.54 3130A0XE5 3.250% 251FHLB 08/22/2022 1,638,219.36 03/08/2024 313 3.38% 1,640,000.00 1,617,253.20 91282CBV2 0.375% 524U.S. Treasury 11/22/2021 498,519.22 04/15/2024 351 0.69% 500,000.00 479,280.00 46625HJX9 3.625% 1,448JPMorgan Chase & Co 05/13/2019 503,132.16 05/13/2024 379 2.97% 500,000.00 492,550.00 3133EKTV8 1.900% 1,398FFCB 07/02/2019 499,976.60 07/01/2024 428 1.90% 500,000.00 483,805.00 3133ENG20 3.300% 255FFCB 08/18/2022 998,897.49 08/15/2024 473 3.39% 1,000,000.00 983,410.00 32100LCB9 1.850% 1,325First Missouri State Bank 09/13/2019 248,000.00 09/13/2024 502 1.85% 248,000.00 237,454.99 3133EK3B0 1.500% 1,291FFCB 10/17/2019 199,523.41 10/16/2024 535 1.67% 200,000.00 191,744.00 912828YV6 1.500% 647U.S. Treasury 07/22/2021 1,016,895.25 11/30/2024 580 0.43% 1,000,000.00 956,880.00 64952WDL4 2.000% 1,194New York Life 01/22/2020 249,689.86 01/22/2025 633 2.08% 250,000.00 238,147.50 88579YBH3 2.000% 2353M 09/07/2022 482,750.79 02/14/2025 656 4.04% 500,000.00 476,605.00 3130A4CH3 2.375% 935FHLB 10/07/2020 517,442.97 03/14/2025 684 0.49% 500,000.00 482,630.00 30231GBH4 2.992% 1,042Exxon Mobil 06/22/2020 259,050.35 03/19/2025 689 0.99% 250,000.00 243,355.00 912828ZT0 0.250% 670U.S. Treasury 06/29/2021 495,499.82 05/31/2025 762 0.69% 500,000.00 462,285.00 3136G4H71 0.500% 985FNMA 08/18/2020 500,000.00 08/12/2025 835 0.50% 500,000.00 460,710.00 27002YFE1 3.300% 255EagleBank 08/18/2022 248,000.00 08/18/2025 841 3.30% 248,000.00 242,746.12 59217GFC8 4.050% 248MetLife 08/25/2022 499,520.65 08/25/2025 848 4.09% 500,000.00 489,170.00 3130ASYR4 4.000% 243FHLB 08/30/2022 2,000,000.00 08/28/2025 851 4.00% 2,000,000.00 1,973,760.00 3137EAEX3 0.375% 922FHLMC 10/20/2020 498,785.57 09/23/2025 877 0.48% 500,000.00 457,925.00 05580AXF6 0.500% 947BMW Bank 09/25/2020 248,000.00 09/25/2025 879 0.50% 248,000.00 226,767.05 91282CAZ4 0.375% 647U.S. Treasury 07/22/2021 993,762.64 11/30/2025 945 0.62% 1,000,000.00 914,730.00 91282CBH3 0.375% 794U.S. Treasury 02/25/2021 496,887.63 01/31/2026 1,007 0.60% 500,000.00 455,295.00 037833BY5 3.250% 248Apple 08/25/2022 496,847.46 02/23/2026 1,030 3.49% 500,000.00 488,880.00 856283S98 1.000% 733State Bank of India 04/27/2021 248,000.00 04/27/2026 1,093 1.00% 248,000.00 226,999.75 91282CCF6 0.750% 647U.S. Treasury 07/22/2021 1,001,513.77 05/31/2026 1,127 0.70% 1,000,000.00 912,810.00 02007GUP6 3.350% 297Ally Bank 07/07/2022 248,000.00 07/07/2026 1,164 3.35% 248,000.00 243,756.04 Run Date: 5/4/2023 - 12:57 PM
Amortizing
21 17
Maturity Report
City of Lynwood April 30, 2023
CUSIP Date
Purchase
Value
Book
Rate
Coupon
Date
Maturity
Par
Remaining
Term Value
Market
YTMIssuer
Days to
Maturity
Book
89235MLC3 0.950% 654Toyota Financial Savings Bank 07/15/2021 248,000.00 07/15/2026 1,172 0.95% 248,000.00 225,681.57 90348JR93 0.950% 627UBS Bank USA 08/11/2021 248,000.00 08/11/2026 1,199 0.95% 248,000.00 225,163.77 15721UFP9 4.750% 46CFBank 03/15/2023 248,000.00 09/15/2026 1,234 4.75% 248,000.00 254,924.21 32117BFR4 5.000% 38First National Bank 03/23/2023 248,000.00 09/23/2026 1,242 5.00% 248,000.00 256,968.35 91282CCZ2 0.875% 558U.S. Treasury 10/19/2021 495,126.49 09/30/2026 1,249 1.17% 500,000.00 455,060.00 3130AQEC3 1.370% 486FHLB 12/30/2021 500,000.00 12/30/2026 1,340 1.37% 500,000.00 451,860.00 3130AL5A8 0.900% 80FHLB 02/09/2023 441,767.91 02/26/2027 1,398 4.25% 500,000.00 443,935.00 808513BW4 3.300% 383Charles Schwab 04/12/2022 249,532.69 04/01/2027 1,432 3.35% 250,000.00 233,037.50 023135CF1 3.300% 325Amazon 06/09/2022 248,372.20 04/13/2027 1,444 3.48% 250,000.00 242,807.50 3130ARTT8 3.000% 346FHLB 05/19/2022 600,000.00 05/19/2027 1,480 3.00% 600,000.00 581,340.00 254673L38 3.400% 297Discover Bank 07/07/2022 248,000.00 07/06/2027 1,528 3.40% 248,000.00 244,887.84 14042RST9 3.450% 297Capital One Bank NA 07/07/2022 248,000.00 07/07/2027 1,529 3.45% 248,000.00 245,369.26 14042TJD0 3.550% 270Capital One Bank USA 08/03/2022 248,000.00 08/03/2027 1,556 3.55% 248,000.00 246,406.38 61768ELH4 3.500% 269Morgan Stanley Private Bank 08/04/2022 248,000.00 08/04/2027 1,557 3.50% 248,000.00 245,913.84 87164XN93 3.500% 268Synchrony Bank 08/05/2022 248,000.00 08/05/2027 1,558 3.50% 248,000.00 245,912.66 02589ADQ2 3.450% 261American Express National Bank 08/12/2022 204,121.67 08/10/2027 1,563 3.56% 205,000.00 202,861.91 3130AT2L0 4.050% 243FHLB 08/30/2022 1,000,000.00 08/25/2027 1,578 4.05% 1,000,000.00 973,240.00 91282CGC9 3.875% 58U.S. Treasury 03/03/2023 979,410.92 12/31/2027 1,706 4.37% 1,000,000.00 1,012,580.00 32114VCH8 4.600% 46First National Bank of Michigan 03/15/2023 248,000.00 03/15/2028 1,781 4.60% 248,000.00 258,762.50 61690U3C2 4.800% 45Morgan Stanley Bank 03/16/2023 247,467.84 03/16/2028 1,782 4.85% 248,000.00 260,906.15 062119BK7 4.650% 41Bank Five Nine 03/20/2023 248,000.00 03/20/2028 1,786 4.65% 248,000.00 259,352.77 3130AV6P2 6.050% 34FHLB 03/27/2023 1,000,000.00 03/27/2028 1,793 6.05% 1,000,000.00 996,520.00 Net Maturities and Averages 36,855,142.68 668 2.74% 36,034,503.13 36,939,051.59 Run Date: 5/4/2023 - 12:57 PM
Amortizing
22 18
Income Earned Summary
City of Lynwood April 30, 2023
Fiscal Year To DateApril 30 Month End
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
87,746.38 547,226.66
137,356.10 137,356.10
-167,518.88 -74,680.06
57,583.60 609,902.70
3,078.96 43,696.41
0.00 0.00
60,662.56
653,599.11
Run Date: 5/4/2023 - 12:57 PM
Amortizing
25 19
Income Earned
City of Lynwood April 01, 2023 - April 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
20033AZK5 06/29/2023 248,000.00Comenity Capital Bank 247,971.76 247,981.18 67.27 0.00 739.92 672.65 9.41 682.06 38148PR33 07/06/2023 248,000.00Goldman Sachs Bank 247,969.78 247,979.13 1,905.86 0.00 2,578.52 672.66 9.35 682.01 949763TF3 08/30/2023 248,000.00Wells Fargo Bank NA 247,952.49 247,961.87 44.84 0.00 717.50 672.66 9.38 682.04 29278TLY4 09/27/2023 248,000.00EnerBank 247,941.21 247,951.01 67.95 421.26 54.36 407.67 9.80 417.47 17312Q3B3 02/27/2024 248,000.00Citibank 247,895.47 247,904.89 672.66 0.00 1,284.16 611.50 9.42 620.92 32100LCB9 09/13/2024 248,000.00First Missouri State Bank 248,000.00 248,000.00 238.83 0.00 615.92 377.09 0.00 377.09 27002YFE1 08/18/2025 248,000.00EagleBank 248,000.00 248,000.00 313.91 695.08 291.48 672.65 0.00 672.65 05580AXF6 09/25/2025 248,000.00BMW Bank 248,000.00 248,000.00 23.78 0.00 125.70 101.92 0.00 101.92 856283S98 04/27/2026 248,000.00State Bank of India 248,000.00 248,000.00 1,059.95 1,236.60 27.18 203.83 0.00 203.83 02007GUP6 07/07/2026 248,000.00Ally Bank 248,000.00 248,000.00 1,911.98 0.00 2,594.83 682.85 0.00 682.85 89235MLC3 07/15/2026 248,000.00Toyota Financial Savings Bank 248,000.00 248,000.00 490.56 0.00 684.21 193.65 0.00 193.65 90348JR93 08/11/2026 248,000.00UBS Bank USA 248,000.00 248,000.00 135.55 200.10 129.10 193.65 0.00 193.65 15721UFP9 09/15/2026 248,000.00CFBank 248,000.00 248,000.00 548.66 1,000.49 516.38 968.21 0.00 968.21 32117BFR4 09/23/2026 248,000.00First National Bank 248,000.00 248,000.00 305.75 1,053.15 271.78 1,019.18 0.00 1,019.18 254673L38 07/06/2027 248,000.00Discover Bank 248,000.00 248,000.00 1,963.62 0.00 2,656.66 693.04 0.00 693.04 14042RST9 07/07/2027 248,000.00Capital One Bank NA 248,000.00 248,000.00 1,969.05 0.00 2,672.28 703.23 0.00 703.23 14042TJD0 08/03/2027 248,000.00Capital One Bank USA 248,000.00 248,000.00 1,374.87 0.00 2,098.49 723.62 0.00 723.62 61768ELH4 08/04/2027 248,000.00Morgan Stanley Private Bank 248,000.00 248,000.00 1,331.73 0.00 2,045.15 713.42 0.00 713.42 87164XN93 08/05/2027 248,000.00Synchrony Bank 248,000.00 248,000.00 1,307.95 0.00 2,021.37 713.42 0.00 713.42 02589ADQ2 08/10/2027 205,000.00American Express National Bank 204,104.81 204,121.67 968.84 0.00 1,550.14 581.30 16.86 598.16 32114VCH8 03/15/2028 248,000.00First National Bank of Michigan 248,000.00 248,000.00 531.33 968.90 500.08 937.65 0.00 937.65 61690U3C2 03/16/2028 248,000.00Morgan Stanley Bank 247,458.88 247,467.84 521.82 0.00 1,500.23 978.41 8.96 987.37 062119BK7 03/20/2028 248,000.00Bank Five Nine 248,000.00 248,000.00 379.13 979.43 347.54 947.84 0.00 947.84 Certificates of Deposit - Sub Total 5,661,000.00 5,659,294.41 5,659,367.58 18,135.89 6,555.01 26,022.98 14,442.10 73.17 14,515.27 Commercial Paper
78015DU32 07/03/2023
500,000.00Royal Bank of Canada, NY 494,055.93 495,929.61 0.00 0.00 0.00 0.00 1,873.67 1,873.67 Commercial Paper - Sub Total 500,000.00 494,055.93 495,929.61 0.00 0.00 0.00 0.00 1,873.67 1,873.67 Corporate Bonds
90331HNV1 07/24/2023
250,000.00US Bank 250,236.10 250,175.51 1,581.94 0.00 2,290.28 708.34 -60.59 647.75 89236TFS9 01/08/2024 250,000.00Toyota Motor Credit 250,563.15 250,502.38 1,930.90 0.00 2,628.82 697.92 -60.77 637.15 46625HJX9 05/13/2024 500,000.00JPMorgan Chase & Co 503,375.68 503,132.16 6,947.92 0.00 8,458.33 1,510.41 -243.52 1,266.89 64952WDL4 01/22/2025 250,000.00New York Life 249,675.40 249,689.86 958.33 0.00 1,375.00 416.67 14.46 431.13 Run Date: 5/4/2023 - 12:58 PM
Amortizing
26 20
Income Earned
City of Lynwood April 01, 2023 - April 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
Corporate Bonds
88579YBH3 02/14/2025 500,000.003M 481,974.04 482,750.79 1,305.56 0.00 2,138.89 833.33 776.75 1,610.08 30231GBH4 03/19/2025 250,000.00Exxon Mobil 259,436.89 259,050.35 249.33 0.00 872.67 623.34 -386.54 236.80 59217GFC8 08/25/2025 500,000.00MetLife 499,504.00 499,520.65 2,025.00 0.00 3,712.50 1,687.50 16.65 1,704.15 037833BY5 02/23/2026 500,000.00Apple 496,757.21 496,847.46 1,715.28 0.00 3,069.44 1,354.16 90.25 1,444.41 808513BW4 04/01/2027 250,000.00Charles Schwab 249,523.09 249,532.69 4,125.00 4,125.00 687.50 687.50 9.60 697.10 023135CF1 04/13/2027 250,000.00Amazon 248,339.03 248,372.20 3,850.00 4,125.00 412.50 687.50 33.17 720.67 Corporate Bonds - Sub Total 3,500,000.00 3,489,384.58 3,489,574.05 24,689.26 8,250.00 25,645.93 9,206.67 189.46 9,396.13 LAIF
9819499 05/01/2023
9,710,816.80LAIF 9,645,805.63 9,710,816.80 65,011.17 65,011.17 0.00 0.00 0.00 0.00 LAIF - Sub Total 9,710,816.80 9,645,805.63 9,710,816.80 65,011.17 65,011.17 0.00 0.00 0.00 0.00 Money Market Funds
FGTXX 05/01/2023
127,234.79Goldman Sachs Govt MMF 104,499.58 127,234.79 5,492.70 5,492.70 465.08 465.08 0.00 465.08 Money Market Funds - Sub Total 127,234.79 104,499.58 127,234.79 5,492.70 5,492.70 465.08 465.08 0.00 465.08 U.S. Agencies
3130A0XE5 03/08/2024
1,640,000.00FHLB 1,638,051.70 1,638,219.36 3,405.28 0.00 7,846.94 4,441.66 167.66 4,609.32 3133EKTV8 07/01/2024 500,000.00FFCB 499,974.99 499,976.60 2,375.00 0.00 3,166.67 791.67 1.61 793.28 3133ENG20 08/15/2024 1,000,000.00FFCB 998,828.73 998,897.49 4,216.67 0.00 6,966.67 2,750.00 68.76 2,818.76 3133EK3B0 10/16/2024 200,000.00FFCB 199,497.14 199,523.41 1,375.00 1,500.00 125.00 250.00 26.28 276.28 3130A4CH3 03/14/2025 500,000.00FHLB 518,193.48 517,442.97 560.76 0.00 1,550.35 989.59 -750.51 239.08 3136G4H71 08/12/2025 500,000.00FNMA 500,000.00 500,000.00 298.61 0.00 506.94 208.33 0.00 208.33 3130ASYR4 08/28/2025 2,000,000.00FHLB 2,000,000.00 2,000,000.00 7,333.33 0.00 14,000.00 6,666.67 0.00 6,666.67 3137EAEX3 09/23/2025 500,000.00FHLMC 498,744.76 498,785.57 41.67 0.00 197.92 156.25 40.81 197.06 3130AQEC3 12/30/2026 500,000.00FHLB 500,000.00 500,000.00 1,731.53 0.00 2,302.36 570.83 0.00 570.83 3130AL5A8 02/26/2027 500,000.00FHLB 440,540.63 441,767.91 437.50 0.00 812.50 375.00 1,227.28 1,602.28 3130ARTT8 05/19/2027 600,000.00FHLB 600,000.00 600,000.00 6,600.00 0.00 8,100.00 1,500.00 0.00 1,500.00 3130AT2L0 08/25/2027 1,000,000.00FHLB 1,000,000.00 1,000,000.00 4,050.00 0.00 7,425.00 3,375.00 0.00 3,375.00 3130AV6P2 03/27/2028 1,000,000.00FHLB 1,000,000.00 1,000,000.00 672.22 0.00 5,713.89 5,041.67 0.00 5,041.67 U.S. Agencies - Sub Total 10,440,000.00 10,393,831.43 10,394,613.31 33,097.57 1,500.00 58,714.24 27,116.67 781.88 27,898.55 U.S. Treasuries
Run Date: 5/4/2023 - 12:58 PM
Amortizing
27 21
Income Earned
City of Lynwood April 01, 2023 - April 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. Treasuries
91282CAW1 11/15/2023 1,000,000.00U.S. Treasury 999,989.43 999,990.81 946.13 0.00 1,153.31 207.18 1.39 208.57 91282CBV2 04/15/2024 500,000.00U.S. Treasury 498,392.65 498,519.22 865.38 937.50 81.97 154.09 126.56 280.65 912828YV6 11/30/2024 1,000,000.00U.S. Treasury 1,017,769.14 1,016,895.25 5,027.47 0.00 6,263.74 1,236.27 -873.89 362.38 912828ZT0 05/31/2025 500,000.00U.S. Treasury 495,322.65 495,499.82 418.96 0.00 521.98 103.02 177.17 280.19 91282CAZ4 11/30/2025 1,000,000.00U.S. Treasury 993,564.63 993,762.64 1,256.87 0.00 1,565.93 309.06 198.01 507.07 91282CBH3 01/31/2026 500,000.00U.S. Treasury 496,794.91 496,887.63 310.77 0.00 466.16 155.39 92.72 248.11 91282CCF6 05/31/2026 1,000,000.00U.S. Treasury 1,001,554.06 1,001,513.77 2,513.74 0.00 3,131.87 618.13 -40.30 577.83 91282CCZ2 09/30/2026 500,000.00U.S. Treasury 495,009.44 495,126.49 11.95 0.00 370.56 358.61 117.06 475.67 91282CGC9 12/31/2027 1,000,000.00U.S. Treasury 979,048.86 979,410.92 9,741.02 0.00 12,952.35 3,211.33 362.06 3,573.39 U.S. Treasuries - Sub Total 7,000,000.00 6,977,445.77 6,977,606.55 21,092.29 937.50 26,507.87 6,353.08 160.78 6,513.86 36,939,051.59Grand Total 36,764,317.34
36,855,142.68 167,518.88 87,746.38 137,356.10 57,583.60 3,078.96 60,662.56 Run Date: 5/4/2023 - 12:58 PM
Amortizing
28 22
Run Date: 6/6/2023 - 5:02 PM
Amortizing Page 2
Portfolio Summary
City of Lynwood 5/31/2023
SECTOR ALLOCATION MATURITY DISTRIBUTION CREDIT QUALITY (MOODY'S)
ACCOUNT SUMMARY MONTH-END PORTFOLIO BOOK YIELD TOP ISSUERS 5/31/23 4/30/23 Issuer % Portfolio
Market Value $35,980,160 $36,034,503 LAIF 26.3%
Book Value $36,918,580 $36,855,143 FHLB 20.9%
Variance -$938,420 -$820,640 U.S. Treasury 17.9%
FFCB 4.6%
Par Value $36,992,817 $36,939,052 JPMorgan 1.4%
FNMA 1.4%
Net Asset Value $97.46 $97.77 MetLife 1.4%
FHLMC 1.4%
Book Yield 2.78% 2.74% Royal Bank of Canada 1.3%
Apple 1.3%
Market Yield 4.31% 4.05% 3M 1.3%
Exxon Mobil 0.7%
Years to Maturity 1.79 1.83 Toyota 0.7%
US Bancorp 0.7%
Effective Duration 1.46 1.55 New York Life 0.7%
Jun-22
Jul-22
Aug-22
Sep-22
Oct-22
Nov-22
Dec-22
Jan-23
Feb-23
Mar-23
Apr-23
May-23
0.60%
1.10%
1.60%
2.10%
2.60%
3.10%
0.1%
1.3%
9.5%
16.7%
17.9%
26.3%
28.2%
MMF
CP
CORP
CD
TSY
LAIF
AGY
100%75%50%25%0%
42.4%
12.1%
18.2%
12.9% 14.4%
0-1Y 1-2Y 2-3Y 3-4Y 4-5Y+
0%
10%
20%
30%
40%
50%
60%
70%
43.0%
1.4%
4.0%
1.4%
0.7%
48.2%
1.3%
NR
A3
A2
A1
Aa3
Aa2
Aa1
Aaa
P-1
100%75%50%25%0%
2 23
Run Date: 6/6/2023 - 5:02 PM
Amortizing Page 3
Investment Policy Compliance
City of Lynwood 5/31/2023
Category Book Value % of Portfolio Allowed by Policy In ComplianceReserved row US Treasuries 6,615,252.23 17.92% 100% Yes
US Federal Agencies 10,395,449.10 28.16% 100% Yes
Supranational Obligations 0.00 0.00% 30% Yes
LAIF 9,710,816.80 26.30% $75,000,000 Yes
Commercial Paper 497,932.50 1.35% 25% Yes
Money Market Funds 55,000.40 0.15% 20% Yes
Negotiable Certificates of Deposit 6,154,348.05 16.67% 30% Yes Corporate Obligations 3,489,780.77 9.45% 30% Yes
State and Local Governments 0.00 0.00% 100% Yes
Total 36,918,579.84 100.00%
Other Metrics Portfolio Metric In Compliance
Weighted Average Maturity 1.79 Less than 3.0 Years Yes
Liquidity 42.37% 30% Under 365 Days Yes
Ratings Yes
3 24
Run Date: 6/6/2023 - 5:02 PM
Amortizing Page 11
Historical Earnings & Book Return Performance
City of Lynwood 5/31/2023
Fiscal YTD ($K) Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun FY 2021 $35.200 $66.215 $94.922 $120.389 $147.318 $173.870 $199.724 $223.094 $247.869 $271.162 $294.542 $316.873 FY 2022 $18.153 $37.347 $56.010 $82.204 $100.760 $118.668 $142.482 $159.901 $178.121 $203.773 $222.371 $242.161 FY 2023 $22.510 $61.308 $112.501 $198.598 $252.119 $307.834 $413.953 $476.124 $592.937 $653.599 $728.837 Fiscal YTD Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Book Return 0.97% 1.17% 1.36% 1.75% 1.76% 1.76% 2.02% 2.04% 2.24% 2.21% 2.23% Fiscal Year-To-Date Earnings
Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun
$0
$100
$200
$300
$400
$500
$600
$700
$800
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
0.00%
0.25%
0.50%
0.75%
1.00%
1.25%
1.50%
1.75%
2.00%
2.25%
2.50%
11 25
Portfolio Summary
City of Lynwood May 31, 2023
Investments Par Value Book Value
% of
Portfolio YTMMaturity
Days to
Market Value
Book
Certificates of Deposit 6,157,000.00 6,154,348.05 16.67 3.23 1,100 6,058,829.36 Commercial Paper 500,000.00 497,932.50 1.35 4.76 33 497,041.00 Corporate Bonds 3,500,000.00 3,489,780.77 9.45 3.22 708 3,387,132.50 LAIF 9,710,816.80 9,710,816.80 26.30 2.99 1 9,710,816.80 Money Market Funds 55,000.40 55,000.40 0.15 5.00 1 55,000.40 U.S. Agencies 10,440,000.00 10,395,449.10 28.16 3.23 908 10,045,581.00 U.S. Treasuries 6,630,000.00 6,615,252.23 17.92 0.95 813 6,225,758.80 36,918,579.84 100.00 652 35,980,159.86 2.78 36,992,817.20 Investments
May 31 Month Ending Fiscal Year To DateTotal Earnings
Current Year 75,237.91 728,837.03
Average Daily Balance 36,880,435.58 35,563,353.46
Book Rate of Return 2.40% 2.23%
Run Date: 6/6/2023 - 5:00 PM
Amortizing
15 26
Holdings Report
City of Lynwood May 31, 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
20033AZK5 248,000.00Comenity Capital Bank 06/29/2018 247,427.12 99.85 247,617.84 0.67% NR/NR 0.0806/29/2023 -373.06 NR 0.08 67.27 3.40% 247,990.90 5.23%3.300%
38148PR33 248,000.00Goldman Sachs Bank 07/09/2018 247,432.08 99.80 247,509.20 0.67% NR/NR 0.1007/06/2023 -479.59 NR 0.10 3,273.60 3.35% 247,988.78 5.23%3.300% 949763TF3 248,000.00Wells Fargo Bank NA 08/31/2018 247,429.60 99.48 246,713.89 0.67% NR/NR 0.2508/30/2023 -1,257.66 NR 0.24 44.84 3.35% 247,971.56 5.42%3.300% 29278TLY4 248,000.00EnerBank 09/30/2019 247,523.84 98.87 245,187.02 0.67% NR/NR 0.3309/27/2023 -2,774.11 NR 0.32 67.95 2.05% 247,961.14 5.58%2.000% 17312Q3B3 248,000.00Citibank 02/28/2019 247,427.12 98.08 243,245.94 0.67% NR/NR 0.7502/27/2024 -4,668.68 NR 0.72 1,916.05 3.05% 247,914.62 5.66%3.000% 32100LCB9 248,000.00First Missouri State Bank 09/13/2019 248,000.00 95.52 236,880.29 0.67% NR/NR 1.2909/13/2024 -11,119.71 NR 1.26 1,005.59 1.85% 248,000.00 5.51%1.850% 27002YFE1 248,000.00EagleBank 08/18/2022 248,000.00 97.37 241,470.21 0.67% NR/NR 2.2208/18/2025 -6,529.79 NR 2.10 313.91 3.30% 248,000.00 4.56%3.300% 05580AXF6 248,000.00BMW Bank 09/25/2020 248,000.00 91.15 226,060.74 0.67% NR/NR 2.3209/25/2025 -21,939.26 NR 2.30 231.01 0.50% 248,000.00 4.57%0.500% 856283S98 248,000.00State Bank of India 04/27/2021 248,000.00 91.08 225,885.75 0.67% NR/NR 2.9104/27/2026 -22,114.25 NR 2.85 237.81 1.00% 248,000.00 4.30%1.000% 02007GUP6 248,000.00Ally Bank 07/07/2022 248,000.00 97.64 242,137.80 0.67% NR/NR 3.1007/07/2026 -5,862.20 NR 2.88 3,300.44 3.35% 248,000.00 4.17%3.350% 89235MLC3 248,000.00Toyota Financial Savings Bank 07/15/2021 248,000.00 90.56 224,600.85 0.67% NR/NR 3.1307/15/2026 -23,399.15 NR 3.06 884.31 0.95% 248,000.00 4.20%0.950% 90348JR93 248,000.00UBS Bank USA 08/11/2021 248,000.00 90.33 224,027.67 0.67% NR/NR 3.2008/11/2026 -23,972.33 NR 3.13 135.55 0.95% 248,000.00 4.20%0.950% 15721UFP9 248,000.00CFBank 03/15/2023 248,000.00 101.96 252,868.79 0.67% NR/NR 3.3009/15/2026 4,868.79 NR 2.98 548.66 4.75% 248,000.00 4.11%4.750% 32117BFR4 248,000.00First National Bank 03/23/2023 248,000.00 102.76 254,843.54 0.67% NR/NR 3.3209/23/2026 6,843.54 NR 2.99 305.75 5.00% 248,000.00 4.10%5.000% 254673L38 248,000.00Discover Bank 07/07/2022 248,000.00 97.94 242,886.55 0.67% NR/NR 4.1007/06/2027 -5,113.45 NR 3.74 3,372.80 3.40% 248,000.00 3.95%3.400% 14042RST9 248,000.00Capital One Bank NA 07/07/2022 248,000.00 98.13 243,354.57 0.67% NR/NR 4.1007/07/2027 -4,645.43 NR 3.74 3,398.96 3.45% 248,000.00 3.95%3.450% 14042TJD0 248,000.00Capital One Bank USA 08/03/2022 248,000.00 98.52 244,325.50 0.67% NR/NR 4.1808/03/2027 -3,674.50 NR 3.80 2,846.22 3.55% 248,000.00 3.94%3.550% 61768ELH4 248,000.00Morgan Stanley Private Bank 08/04/2022 248,000.00 98.32 243,843.53 0.67% NR/NR 4.1808/04/2027 -4,156.47 NR 3.81 2,782.36 3.50% 248,000.00 3.94%3.500% 87164XN93 248,000.00Synchrony Bank 08/05/2022 248,000.00 98.32 243,840.91 0.67% NR/NR 4.1808/05/2027 -4,159.09 NR 3.81 2,758.58 3.50% 248,000.00 3.94%3.500% Run Date: 6/6/2023 - 5:00 PM
Amortizing
16 27
Holdings Report
City of Lynwood May 31, 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
02589ADQ2 205,000.00American Express National Bank 08/12/2022 203,975.00 98.12 201,153.36 0.55% NR/NR 4.2008/10/2027 -2,985.73 NR 3.83 2,150.82 3.56% 204,139.09 3.94%3.450% 32114VCH8 248,000.00First National Bank of Michigan 03/15/2023 248,000.00 103.29 256,154.82 0.67% NR/NR 4.7903/15/2028 8,154.82 NR 4.22 531.33 4.60% 248,000.00 3.84%4.600% 61690U3C2 248,000.00Morgan Stanley Bank 03/16/2023 247,454.40 104.13 258,254.05 0.67% NR/NR 4.8003/16/2028 10,776.95 NR 4.20 2,511.25 4.85% 247,477.10 3.85%4.800% 062119BK7 248,000.00Bank Five Nine 03/20/2023 248,000.00 103.52 256,726.31 0.67% NR/NR 4.8103/20/2028 8,726.31 NR 4.22 379.13 4.65% 248,000.00 3.84%4.650% 12547CBJ6 248,000.00CIBC Bank USA 05/17/2023 247,446.96 102.33 253,776.25 0.67% NR/NR 4.9605/16/2028 6,325.05 NR 4.41 472.90 4.40% 247,451.20 3.83%4.350% 05600XQE3 248,000.00BMO Harris Bank NA 05/17/2023 247,449.44 103.01 255,463.98 0.67% NR/NR 4.9605/16/2028 8,010.32 NR 4.39 489.21 4.55% 247,453.66 3.83%4.500% 6,151,565.56 6,058,829.36 16.67% 3.01
6,154,348.05 3.23% 6,157,000.00 4.39% 34,026.30 -95,518.68 2.76Total Certificates of Deposit Commercial Paper
78015DU32 500,000.00Royal Bank of Canada, NY 10/07/2022 482,813.89 99.41 497,041.00 1.35% P-1/A-1+ 0.0907/03/2023 -891.50 F1+ 0.09 0.00 4.76% 497,932.50 6.58%0.000%
482,813.89 497,041.00 1.35% 0.09
497,932.50 4.76% 500,000.00 6.58% 0.00 -891.50 0.09Total Commercial Paper Corporate Bonds
90331HNV1 250,000.00US Bank 03/01/2019 253,307.50 99.62 249,052.50 0.68% A2/A+ 0.1507/24/2023 -1,058.24 AA- 0.14 2,998.61 3.08% 250,110.74 5.82%3.400% 06/23/2023 89236TFS9 250,000.00Toyota Motor Credit 02/28/2019 253,545.00 98.77 246,912.50 0.68% A1/A+ 0.6101/08/2024 -3,529.11 A+ 0.58 3,326.74 3.03% 250,441.61 5.45%3.350% 46625HJX9 500,000.00JPMorgan Chase & Co 05/13/2019 515,115.00 98.28 491,380.00 1.36% A1/A- 0.9505/13/2024 -11,491.85 AA- 0.91 906.25 2.97% 502,871.85 5.51%3.625% 64952WDL4 250,000.00New York Life 01/22/2020 249,102.50 95.23 238,077.50 0.68% Aaa/AA+ 1.6501/22/2025 -11,627.82 AAA 1.57 1,791.67 2.08% 249,705.32 5.06%2.000% 88579YBH3 500,000.003M 09/07/2022 476,510.00 95.10 475,485.00 1.31% A1/A 1.7102/14/2025 -8,096.11 NR 1.63 2,972.22 4.04% 483,581.11 5.04%2.000% 30231GBH4 250,000.00Exxon Mobil 06/22/2020 272,752.50 96.94 242,337.50 0.70% Aa2/AA- 1.8003/19/2025 -16,299.65 NR 1.68 1,496.00 0.99% 258,637.15 4.79%2.992% 02/19/2025 Run Date: 6/6/2023 - 5:00 PM
Amortizing
17 28
Holdings Report
City of Lynwood May 31, 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
Corporate Bonds
59217GFC8 500,000.00MetLife 08/25/2022 499,380.00 97.03 485,165.00 1.35% Aa3/AA- 2.2408/25/2025 -14,373.44 AA- 2.07 5,400.00 4.09% 499,538.44 5.48%4.050% 037833BY5 500,000.00Apple 08/25/2022 496,085.00 97.24 486,205.00 1.35% Aaa/AA+ 2.7402/23/2026 -10,738.93 NR 2.46 4,423.61 3.49% 496,943.93 4.33%3.250% 808513BW4 250,000.00Charles Schwab 04/12/2022 249,407.50 92.29 230,732.50 0.68% A2/A- 3.8404/01/2027 -18,810.46 A 3.46 1,375.00 3.35% 249,542.96 5.56%3.300% 023135CF1 250,000.00Amazon 06/09/2022 248,005.00 96.71 241,785.00 0.67% A1/AA 3.8704/13/2027 -6,622.66 AA- 3.52 1,100.00 3.48% 248,407.66 4.23%3.300% 3,513,210.00 3,387,132.50 9.45% 1.94
3,489,780.77 3.22% 3,500,000.00 5.12% 25,790.10 -102,648.27 1.79Total Corporate Bonds LAIF
9819499 9,710,816.80LAIF 04/14/2023 9,710,816.80 1.00 9,710,816.80 26.30% NR/NR 0.0006/01/2023
0.00 NR 0.00 0.00 2.99% 9,710,816.80 2.99%2.990%
9,710,816.80 9,710,816.80 26.30% 0.00
9,710,816.80 2.99% 9,710,816.80 2.99% 0.00 0.00 0.00Total LAIF Money Market Funds
FGTXX 55,000.40Goldman Sachs Govt MMF 55,000.40 1.00 55,000.40 0.15% Aaa/AAA 0.0006/01/2023
0.00 NR 0.00 409.73 5.00% 55,000.40 5.00%4.997%
55,000.40 55,000.40 0.15% 0.00
55,000.40 5.00% 55,000.40 5.00% 409.73 0.00 0.00Total Money Market Funds U.S. Agencies
3130A0XE5 1,640,000.00FHLB 08/22/2022 1,636,785.60 98.47 1,614,826.00 4.44% Aaa/AA+ 0.7703/08/2024 -23,572.58 AAA 0.74 12,288.61 3.38% 1,638,398.58 5.31%3.250% 3133EKTV8 500,000.00FFCB 07/02/2019 499,900.00 96.68 483,400.00 1.35% Aaa/AA+ 1.0907/01/2024 -16,578.32 AAA 1.04 3,958.33 1.90% 499,978.32 5.09%1.900% 3133ENG20 1,000,000.00FFCB 08/18/2022 998,300.00 98.10 980,950.00 2.71% Aaa/AA+ 1.2108/15/2024 -18,020.99 AAA 1.15 9,716.67 3.39% 998,970.99 4.94%3.300% 3133EK3B0 200,000.00FFCB 10/17/2019 198,370.00 95.70 191,402.00 0.54% Aaa/AA+ 1.3810/16/2024 -8,149.50 AAA 1.33 375.00 1.67% 199,551.50 4.77%1.500% Run Date: 6/6/2023 - 5:00 PM
Amortizing
18 29
Holdings Report
City of Lynwood May 31, 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
3130A4CH3 500,000.00FHLB 10/07/2020 541,330.00 95.68 478,395.00 1.40% Aaa/AA+ 1.7903/14/2025 -38,245.70 AAA 1.70 2,539.93 0.49% 516,640.70 4.93%2.375% 3136G4H71 500,000.00FNMA 08/18/2020 500,000.00 91.80 459,020.00 1.35% Aaa/AA+ 2.2008/12/2025 -40,980.00 AAA 2.14 715.28 0.50% 500,000.00 4.46%0.500% 02/18/2022 3130ASYR4 2,000,000.00FHLB 08/30/2022 2,000,000.00 97.72 1,954,360.00 5.42% Aaa/AA+ 2.2508/28/2025 -45,640.00 AAA 1.45 20,666.67 4.00% 2,000,000.00 5.08%4.000% 08/28/2023 3137EAEX3 500,000.00FHLMC 10/20/2020 497,505.00 91.28 456,405.00 1.35% Aaa/AA+ 2.3209/23/2025 -42,424.19 AAA 2.24 354.17 0.48% 498,829.19 4.38%0.375% 3130AQEC3 500,000.00FHLB 12/30/2021 500,000.00 89.51 447,565.00 1.35% Aaa/AA+ 3.5912/30/2026 -52,435.00 AAA 3.37 2,873.19 1.37% 500,000.00 4.58%1.370% 06/30/2023 3130AL5A8 500,000.00FHLB 02/09/2023 438,340.00 88.03 440,140.00 1.20% Aaa/AA+ 3.7502/26/2027 -2,939.82 AAA 3.57 1,187.50 4.25% 443,079.82 4.41%0.900% 08/26/2023 3130ARTT8 600,000.00FHLB 05/19/2022 600,000.00 96.35 578,088.00 1.63% Aaa/AA+ 3.9705/19/2027 -21,912.00 AAA 2.22 650.00 3.25% 600,000.00 4.26%3.250% 08/19/2023 3130AT2L0 1,000,000.00FHLB 08/30/2022 1,000,000.00 96.64 966,400.00 2.71% Aaa/AA+ 4.2408/25/2027 -33,600.00 AAA 2.35 10,800.00 4.05% 1,000,000.00 4.94%4.050% 08/25/2023 3130AV6P2 1,000,000.00FHLB 03/27/2023 1,000,000.00 99.46 994,630.00 2.71% Aaa/AA+ 4.8303/27/2028 -5,370.00 AAA 0.57 10,755.56 6.05% 1,000,000.00 6.18%6.050% 06/27/2023 10,410,530.60 10,045,581.00 28.16% 2.49
10,395,449.10 3.23% 10,440,000.00 5.02% 76,880.91 -349,868.10 1.60Total U.S. Agencies U.S. Treasuries
91282CAW1 1,000,000.00U.S. Treasury 07/22/2021 999,960.94 97.72 977,150.00 2.71% Aaa/AA+ 0.4611/15/2023 -22,842.24 AAA 0.45 115.49 0.25% 999,992.24 5.38%0.250% 91282CBV2 500,000.00U.S. Treasury 11/22/2021 496,308.59 95.87 479,355.00 1.35% Aaa/AA+ 0.8804/15/2024 -19,295.00 AAA 0.85 240.78 0.69% 498,650.00 5.27%0.375% 912828YV6 1,000,000.00U.S. Treasury 07/22/2021 1,035,742.19 95.33 953,320.00 2.75% Aaa/AA+ 1.5011/30/2024 -62,672.23 AAA 1.45 40.98 0.43% 1,015,992.23 4.76%1.500% 912828ZT0 500,000.00U.S. Treasury 06/29/2021 491,542.97 92.11 460,530.00 1.34% Aaa/AA+ 2.0005/31/2025 -35,152.90 AAA 1.94 3.42 0.69% 495,682.90 4.42%0.250% 91282CAZ4 1,000,000.00U.S. Treasury 07/22/2021 989,492.19 91.07 910,740.00 2.69% Aaa/AA+ 2.5011/30/2025 -83,227.25 AAA 2.43 10.25 0.62% 993,967.25 4.17%0.375% 91282CBH3 500,000.00U.S. Treasury 02/25/2021 494,433.59 90.66 453,280.00 1.35% Aaa/AA+ 2.6701/31/2026 -43,703.44 AAA 2.59 626.73 0.60% 496,983.44 4.11%0.375% 91282CCF6 1,000,000.00U.S. Treasury 07/22/2021 1,002,382.81 90.80 908,010.00 2.71% Aaa/AA+ 3.0005/31/2026 -93,462.13 AAA 2.89 20.49 0.70% 1,001,472.13 4.04%0.750% Run Date: 6/6/2023 - 5:00 PM
Amortizing
19 30
Holdings Report
City of Lynwood May 31, 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. Treasuries
91282CCZ2 500,000.00U.S. Treasury 10/19/2021 492,949.22 90.45 452,265.00 1.34% Aaa/AA+ 3.3409/30/2026 -42,982.45 AAA 3.20 741.12 1.17% 495,247.45 3.96%0.875% 91282CGC9 630,000.00U.S. Treasury 03/03/2023 616,587.89 100.18 631,108.80 1.67% Aaa/AA+ 4.5912/31/2027 13,844.22 AAA 4.07 10,250.55 4.37% 617,264.58 3.83%3.875% 6,619,400.39 6,225,758.80 17.92% 2.23
6,615,252.23 0.95% 6,630,000.00 4.47% 12,049.81 -389,493.42 2.12Total U.S. Treasuries 36,943,337.64 35,980,159.86 100.00% 1.79
149,156.85 -938,419.97 1.46 4.31% 36,918,579.84 2.78% 36,992,817.20TOTAL PORTFOLIO TOTAL MARKET VALUE PLUS ACCRUED INTEREST 36,129,316.71 Run Date: 6/6/2023 - 5:00 PM
Amortizing
20 31
Maturity Report
City of Lynwood May 31, 2023
CUSIP Date
Purchase
Value
Book
Rate
Coupon
Date
Maturity
Par
Remaining
Term Value
Market
YTMIssuer
Days to
Maturity
Book
FGTXX 4.997% 1Goldman Sachs Govt MMF 55,000.40 06/01/2023 1 5.00% 55,000.40 55,000.40 9819499 2.990% 1LAIF 05/18/2020 9,710,816.80 06/01/2023 1 2.99% 9,710,816.80 9,710,816.80 20033AZK5 3.300% 1,797Comenity Capital Bank 06/29/2018 247,990.90 06/29/2023 29 3.40% 248,000.00 247,617.84 78015DU32 0.000% 236Royal Bank of Canada, NY 10/07/2022 497,932.50 07/03/2023 33 4.76% 500,000.00 497,041.00 38148PR33 3.300% 1,787Goldman Sachs Bank 07/09/2018 247,988.78 07/06/2023 36 3.35% 248,000.00 247,509.20 90331HNV1 3.400% 1,552US Bank 03/01/2019 250,110.74 07/24/2023 54 3.08% 250,000.00 249,052.50 949763TF3 3.300% 1,734Wells Fargo Bank NA 08/31/2018 247,971.56 08/30/2023 91 3.35% 248,000.00 246,713.89 29278TLY4 2.000% 1,339EnerBank 09/30/2019 247,961.14 09/27/2023 119 2.05% 248,000.00 245,187.02 91282CAW1 0.250% 678U.S. Treasury 07/22/2021 999,992.24 11/15/2023 168 0.25% 1,000,000.00 977,150.00 89236TFS9 3.350% 1,553Toyota Motor Credit 02/28/2019 250,441.61 01/08/2024 222 3.03% 250,000.00 246,912.50 17312Q3B3 3.000% 1,553Citibank 02/28/2019 247,914.62 02/27/2024 272 3.05% 248,000.00 243,245.94 3130A0XE5 3.250% 282FHLB 08/22/2022 1,638,398.58 03/08/2024 282 3.38% 1,640,000.00 1,614,826.00 91282CBV2 0.375% 555U.S. Treasury 11/22/2021 498,650.00 04/15/2024 320 0.69% 500,000.00 479,355.00 46625HJX9 3.625% 1,479JPMorgan Chase & Co 05/13/2019 502,871.85 05/13/2024 348 2.97% 500,000.00 491,380.00 3133EKTV8 1.900% 1,429FFCB 07/02/2019 499,978.32 07/01/2024 397 1.90% 500,000.00 483,400.00 3133ENG20 3.300% 286FFCB 08/18/2022 998,970.99 08/15/2024 442 3.39% 1,000,000.00 980,950.00 32100LCB9 1.850% 1,356First Missouri State Bank 09/13/2019 248,000.00 09/13/2024 471 1.85% 248,000.00 236,880.29 3133EK3B0 1.500% 1,322FFCB 10/17/2019 199,551.50 10/16/2024 504 1.67% 200,000.00 191,402.00 912828YV6 1.500% 678U.S. Treasury 07/22/2021 1,015,992.23 11/30/2024 549 0.43% 1,000,000.00 953,320.00 64952WDL4 2.000% 1,225New York Life 01/22/2020 249,705.32 01/22/2025 602 2.08% 250,000.00 238,077.50 88579YBH3 2.000% 2663M 09/07/2022 483,581.11 02/14/2025 625 4.04% 500,000.00 475,485.00 3130A4CH3 2.375% 966FHLB 10/07/2020 516,640.70 03/14/2025 653 0.49% 500,000.00 478,395.00 30231GBH4 2.992% 1,073Exxon Mobil 06/22/2020 258,637.15 03/19/2025 658 0.99% 250,000.00 242,337.50 912828ZT0 0.250% 701U.S. Treasury 06/29/2021 495,682.90 05/31/2025 731 0.69% 500,000.00 460,530.00 3136G4H71 0.500% 1,016FNMA 08/18/2020 500,000.00 08/12/2025 804 0.50% 500,000.00 459,020.00 27002YFE1 3.300% 286EagleBank 08/18/2022 248,000.00 08/18/2025 810 3.30% 248,000.00 241,470.21 59217GFC8 4.050% 279MetLife 08/25/2022 499,538.44 08/25/2025 817 4.09% 500,000.00 485,165.00 3130ASYR4 4.000% 274FHLB 08/30/2022 2,000,000.00 08/28/2025 820 4.00% 2,000,000.00 1,954,360.00 3137EAEX3 0.375% 953FHLMC 10/20/2020 498,829.19 09/23/2025 846 0.48% 500,000.00 456,405.00 05580AXF6 0.500% 978BMW Bank 09/25/2020 248,000.00 09/25/2025 848 0.50% 248,000.00 226,060.74 91282CAZ4 0.375% 678U.S. Treasury 07/22/2021 993,967.25 11/30/2025 914 0.62% 1,000,000.00 910,740.00 91282CBH3 0.375% 825U.S. Treasury 02/25/2021 496,983.44 01/31/2026 976 0.60% 500,000.00 453,280.00 037833BY5 3.250% 279Apple 08/25/2022 496,943.93 02/23/2026 999 3.49% 500,000.00 486,205.00 856283S98 1.000% 764State Bank of India 04/27/2021 248,000.00 04/27/2026 1,062 1.00% 248,000.00 225,885.75 91282CCF6 0.750% 678U.S. Treasury 07/22/2021 1,001,472.13 05/31/2026 1,096 0.70% 1,000,000.00 908,010.00 02007GUP6 3.350% 328Ally Bank 07/07/2022 248,000.00 07/07/2026 1,133 3.35% 248,000.00 242,137.80 Run Date: 6/6/2023 - 5:00 PM
Amortizing
21 32
Maturity Report
City of Lynwood May 31, 2023
CUSIP Date
Purchase
Value
Book
Rate
Coupon
Date
Maturity
Par
Remaining
Term Value
Market
YTMIssuer
Days to
Maturity
Book
89235MLC3 0.950% 685Toyota Financial Savings Bank 07/15/2021 248,000.00 07/15/2026 1,141 0.95% 248,000.00 224,600.85 90348JR93 0.950% 658UBS Bank USA 08/11/2021 248,000.00 08/11/2026 1,168 0.95% 248,000.00 224,027.67 15721UFP9 4.750% 77CFBank 03/15/2023 248,000.00 09/15/2026 1,203 4.75% 248,000.00 252,868.79 32117BFR4 5.000% 69First National Bank 03/23/2023 248,000.00 09/23/2026 1,211 5.00% 248,000.00 254,843.54 91282CCZ2 0.875% 589U.S. Treasury 10/19/2021 495,247.45 09/30/2026 1,218 1.17% 500,000.00 452,265.00 3130AQEC3 1.370% 517FHLB 12/30/2021 500,000.00 12/30/2026 1,309 1.37% 500,000.00 447,565.00 3130AL5A8 0.900% 111FHLB 02/09/2023 443,079.82 02/26/2027 1,367 4.25% 500,000.00 440,140.00 808513BW4 3.300% 414Charles Schwab 04/12/2022 249,542.96 04/01/2027 1,401 3.35% 250,000.00 230,732.50 023135CF1 3.300% 356Amazon 06/09/2022 248,407.66 04/13/2027 1,413 3.48% 250,000.00 241,785.00 3130ARTT8 3.250% 377FHLB 05/19/2022 600,000.00 05/19/2027 1,449 3.25% 600,000.00 578,088.00 254673L38 3.400% 328Discover Bank 07/07/2022 248,000.00 07/06/2027 1,497 3.40% 248,000.00 242,886.55 14042RST9 3.450% 328Capital One Bank NA 07/07/2022 248,000.00 07/07/2027 1,498 3.45% 248,000.00 243,354.57 14042TJD0 3.550% 301Capital One Bank USA 08/03/2022 248,000.00 08/03/2027 1,525 3.55% 248,000.00 244,325.50 61768ELH4 3.500% 300Morgan Stanley Private Bank 08/04/2022 248,000.00 08/04/2027 1,526 3.50% 248,000.00 243,843.53 87164XN93 3.500% 299Synchrony Bank 08/05/2022 248,000.00 08/05/2027 1,527 3.50% 248,000.00 243,840.91 02589ADQ2 3.450% 292American Express National Bank 08/12/2022 204,139.09 08/10/2027 1,532 3.56% 205,000.00 201,153.36 3130AT2L0 4.050% 274FHLB 08/30/2022 1,000,000.00 08/25/2027 1,547 4.05% 1,000,000.00 966,400.00 91282CGC9 3.875% 89U.S. Treasury 03/03/2023 617,264.58 12/31/2027 1,675 4.37% 630,000.00 631,108.80 32114VCH8 4.600% 77First National Bank of Michigan 03/15/2023 248,000.00 03/15/2028 1,750 4.60% 248,000.00 256,154.82 61690U3C2 4.800% 76Morgan Stanley Bank 03/16/2023 247,477.10 03/16/2028 1,751 4.85% 248,000.00 258,254.05 062119BK7 4.650% 72Bank Five Nine 03/20/2023 248,000.00 03/20/2028 1,755 4.65% 248,000.00 256,726.31 3130AV6P2 6.050% 65FHLB 03/27/2023 1,000,000.00 03/27/2028 1,762 6.05% 1,000,000.00 994,630.00 05600XQE3 4.500% 14BMO Harris Bank NA 05/17/2023 247,453.66 05/16/2028 1,812 4.55% 248,000.00 255,463.98 12547CBJ6 4.350% 14CIBC Bank USA 05/17/2023 247,451.20 05/16/2028 1,812 4.40% 248,000.00 253,776.25 Net Maturities and Averages 36,918,579.84 652 2.78% 35,980,159.86 36,992,817.20 Run Date: 6/6/2023 - 5:00 PM
Amortizing
22 33
Income Earned Summary
City of Lynwood May 31, 2023
Fiscal Year To DateMay 31 Month End
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
46,736.23 593,962.89
149,156.85 149,156.85
-137,356.10 -74,680.06
58,536.98 668,439.68
3,228.64 46,925.06
13,472.29 13,472.29
75,237.91
728,837.03
Run Date: 6/6/2023 - 5:00 PM
Amortizing
25 34
Income Earned
City of Lynwood May 01, 2023 - May 31, 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
20033AZK5 06/29/2023 248,000.00Comenity Capital Bank 247,981.18 247,990.90 739.92 1,367.74 67.27 695.09 9.73 704.82 38148PR33 07/06/2023 248,000.00Goldman Sachs Bank 247,979.13 247,988.78 2,578.52 0.00 3,273.60 695.08 9.66 704.74 949763TF3 08/30/2023 248,000.00Wells Fargo Bank NA 247,961.87 247,971.56 717.50 1,367.74 44.84 695.08 9.69 704.77 29278TLY4 09/27/2023 248,000.00EnerBank 247,951.01 247,961.14 54.36 407.67 67.95 421.26 10.12 431.38 17312Q3B3 02/27/2024 248,000.00Citibank 247,904.89 247,914.62 1,284.16 0.00 1,916.05 631.89 9.73 641.62 32100LCB9 09/13/2024 248,000.00First Missouri State Bank 248,000.00 248,000.00 615.92 0.00 1,005.59 389.67 0.00 389.67 27002YFE1 08/18/2025 248,000.00EagleBank 248,000.00 248,000.00 291.48 672.66 313.91 695.09 0.00 695.09 05580AXF6 09/25/2025 248,000.00BMW Bank 248,000.00 248,000.00 125.70 0.00 231.01 105.31 0.00 105.31 856283S98 04/27/2026 248,000.00State Bank of India 248,000.00 248,000.00 27.18 0.00 237.81 210.63 0.00 210.63 02007GUP6 07/07/2026 248,000.00Ally Bank 248,000.00 248,000.00 2,594.83 0.00 3,300.44 705.61 0.00 705.61 89235MLC3 07/15/2026 248,000.00Toyota Financial Savings Bank 248,000.00 248,000.00 684.21 0.00 884.31 200.10 0.00 200.10 90348JR93 08/11/2026 248,000.00UBS Bank USA 248,000.00 248,000.00 129.10 193.64 135.55 200.09 0.00 200.09 15721UFP9 09/15/2026 248,000.00CFBank 248,000.00 248,000.00 516.38 968.22 548.66 1,000.50 0.00 1,000.50 32117BFR4 09/23/2026 248,000.00First National Bank 248,000.00 248,000.00 271.78 1,019.18 305.75 1,053.15 0.00 1,053.15 254673L38 07/06/2027 248,000.00Discover Bank 248,000.00 248,000.00 2,656.66 0.00 3,372.80 716.14 0.00 716.14 14042RST9 07/07/2027 248,000.00Capital One Bank NA 248,000.00 248,000.00 2,672.28 0.00 3,398.96 726.68 0.00 726.68 14042TJD0 08/03/2027 248,000.00Capital One Bank USA 248,000.00 248,000.00 2,098.49 0.00 2,846.22 747.73 0.00 747.73 61768ELH4 08/04/2027 248,000.00Morgan Stanley Private Bank 248,000.00 248,000.00 2,045.15 0.00 2,782.36 737.21 0.00 737.21 87164XN93 08/05/2027 248,000.00Synchrony Bank 248,000.00 248,000.00 2,021.37 0.00 2,758.58 737.21 0.00 737.21 02589ADQ2 08/10/2027 205,000.00American Express National Bank 204,121.67 204,139.09 1,550.14 0.00 2,150.82 600.68 17.42 618.10 32114VCH8 03/15/2028 248,000.00First National Bank of Michigan 248,000.00 248,000.00 500.08 937.64 531.33 968.89 0.00 968.89 61690U3C2 03/16/2028 248,000.00Morgan Stanley Bank 247,467.84 247,477.10 1,500.23 0.00 2,511.25 1,011.02 9.26 1,020.28 062119BK7 03/20/2028 248,000.00Bank Five Nine 248,000.00 248,000.00 347.54 947.84 379.13 979.43 0.00 979.43 05600XQE3 05/16/2028 248,000.00BMO Harris Bank NA 0.00 247,453.66 0.00 -30.58 489.21 458.63 4.22 462.85 12547CBJ6 05/16/2028 248,000.00CIBC Bank USA 0.00 247,451.20 0.00 -29.56 472.90 443.34 4.24 447.58 Certificates of Deposit - Sub Total 6,157,000.00 5,659,367.58 6,154,348.05 26,022.98 7,822.19 34,026.30 15,825.51 84.07 15,909.58 Commercial Paper
78015DU32 07/03/2023 500,000.00Royal Bank of Canada, NY 495,929.61 497,932.50 0.00 0.00 0.00 0.00 2,002.89 2,002.89 Commercial Paper - Sub Total
500,000.00 495,929.61 497,932.50 0.00 0.00 0.00 0.00 2,002.89 2,002.89 Corporate Bonds
90331HNV1 07/24/2023 250,000.00US Bank 250,175.51 250,110.74 2,290.28 0.00 2,998.61 708.33 -64.77 643.56 89236TFS9 01/08/2024 250,000.00Toyota Motor Credit 250,502.38 250,441.61 2,628.82 0.00 3,326.74 697.92 -60.77 637.15 Run Date: 6/6/2023 - 5:01 PM
Amortizing
26 35
Income Earned
City of Lynwood May 01, 2023 - May 31, 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
Corporate Bonds
46625HJX9 05/13/2024 500,000.00JPMorgan Chase & Co 503,132.16 502,871.85 8,458.33 9,062.50 906.25 1,510.42 -260.31 1,250.11 64952WDL4 01/22/2025 250,000.00New York Life 249,689.86 249,705.32 1,375.00 0.00 1,791.67 416.67 15.46 432.13 88579YBH3 02/14/2025 500,000.003M 482,750.79 483,581.11 2,138.89 0.00 2,972.22 833.33 830.32 1,663.65 30231GBH4 03/19/2025 250,000.00Exxon Mobil 259,050.35 258,637.15 872.67 0.00 1,496.00 623.33 -413.20 210.13 59217GFC8 08/25/2025 500,000.00MetLife 499,520.65 499,538.44 3,712.50 0.00 5,400.00 1,687.50 17.80 1,705.30 037833BY5 02/23/2026 500,000.00Apple 496,847.46 496,943.93 3,069.44 0.00 4,423.61 1,354.17 96.47 1,450.64 808513BW4 04/01/2027 250,000.00Charles Schwab 249,532.69 249,542.96 687.50 0.00 1,375.00 687.50 10.27 697.77 023135CF1 04/13/2027 250,000.00Amazon 248,372.20 248,407.66 412.50 0.00 1,100.00 687.50 35.46 722.96 Corporate Bonds - Sub Total 3,500,000.00 3,489,574.05 3,489,780.77 25,645.93 9,062.50 25,790.10 9,206.67 206.72 9,413.39 LAIF
9819499 06/01/2023 9,710,816.80LAIF 9,710,816.80 9,710,816.80 0.00 0.00 0.00 0.00 0.00 0.00 LAIF - Sub Total
9,710,816.80 9,710,816.80 9,710,816.80 0.00 0.00 0.00 0.00 0.00 0.00 Money Market Funds
FGTXX 06/01/2023 55,000.40Goldman Sachs Govt MMF 127,234.79 55,000.40 465.08 465.08 409.73 409.73 0.00 409.73 Money Market Funds - Sub Total
55,000.40 127,234.79 55,000.40 465.08 465.08 409.73 409.73 0.00 409.73 U.S. Agencies
3130A0XE5 03/08/2024 1,640,000.00FHLB 1,638,219.36 1,638,398.58 7,846.94 0.00 12,288.61 4,441.67 179.22 4,620.89 3133EKTV8 07/01/2024 500,000.00FFCB 499,976.60 499,978.32 3,166.67 0.00 3,958.33 791.66 1.72 793.38 3133ENG20 08/15/2024 1,000,000.00FFCB 998,897.49 998,970.99 6,966.67 0.00 9,716.67 2,750.00 73.50 2,823.50 3133EK3B0 10/16/2024 200,000.00FFCB 199,523.41 199,551.50 125.00 0.00 375.00 250.00 28.09 278.09 3130A4CH3 03/14/2025 500,000.00FHLB 517,442.97 516,640.70 1,550.35 0.00 2,539.93 989.58 -802.27 187.31 3136G4H71 08/12/2025 500,000.00FNMA 500,000.00 500,000.00 506.94 0.00 715.28 208.34 0.00 208.34 3130ASYR4 08/28/2025 2,000,000.00FHLB 2,000,000.00 2,000,000.00 14,000.00 0.00 20,666.67 6,666.67 0.00 6,666.67 3137EAEX3 09/23/2025 500,000.00FHLMC 498,785.57 498,829.19 197.92 0.00 354.17 156.25 43.62 199.87 3130AQEC3 12/30/2026 500,000.00FHLB 500,000.00 500,000.00 2,302.36 0.00 2,873.19 570.83 0.00 570.83 3130AL5A8 02/26/2027 500,000.00FHLB 441,767.91 443,079.82 812.50 0.00 1,187.50 375.00 1,311.91 1,686.91 3130ARTT8 05/19/2027 600,000.00FHLB 600,000.00 600,000.00 8,100.00 9,000.00 650.00 1,550.00 0.00 1,550.00 3130AT2L0 08/25/2027 1,000,000.00FHLB 1,000,000.00 1,000,000.00 7,425.00 0.00 10,800.00 3,375.00 0.00 3,375.00 3130AV6P2 03/27/2028 1,000,000.00FHLB 1,000,000.00 1,000,000.00 5,713.89 0.00 10,755.56 5,041.67 0.00 5,041.67 U.S. Agencies - Sub Total
10,440,000.00 10,394,613.31 10,395,449.10 58,714.24 9,000.00 76,880.91 27,166.67 835.80 28,002.47 Run Date: 6/6/2023 - 5:01 PM
Amortizing
27 36
Income Earned
City of Lynwood May 01, 2023 - May 31, 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. Treasuries
91282CAW1 11/15/2023 1,000,000.00U.S. Treasury 999,990.81 999,992.24 1,153.31 1,250.00 115.49 212.18 1.43 213.61 91282CBV2 04/15/2024 500,000.00U.S. Treasury 498,519.22 498,650.00 81.97 0.00 240.78 158.81 130.78 289.59 912828YV6 11/30/2024 1,000,000.00U.S. Treasury 1,016,895.25 1,015,992.23 6,263.74 7,500.00 40.98 1,277.24 -903.02 374.22 912828ZT0 05/31/2025 500,000.00U.S. Treasury 495,499.82 495,682.90 521.98 625.00 3.42 106.44 183.08 289.52 91282CAZ4 11/30/2025 1,000,000.00U.S. Treasury 993,762.64 993,967.25 1,565.93 1,875.00 10.25 319.32 204.61 523.93 91282CBH3 01/31/2026 500,000.00U.S. Treasury 496,887.63 496,983.44 466.16 0.00 626.73 160.57 95.81 256.38 91282CCF6 05/31/2026 1,000,000.00U.S. Treasury 1,001,513.77 1,001,472.13 3,131.87 3,750.00 20.49 638.62 -41.64 596.98 91282CCZ2 09/30/2026 500,000.00U.S. Treasury 495,126.49 495,247.45 370.56 0.00 741.12 370.56 120.96 491.52 91282CGC9 12/31/2027 630,000.00U.S. Treasury 979,410.92 617,264.58 12,952.35 5,386.46 10,250.55 2,684.66 307.15 2,991.81 U.S. Treasuries - Sub Total 6,630,000.00 6,977,606.55 6,615,252.23 26,507.87 20,386.46 12,049.81 5,928.40 99.16 6,027.56 36,992,817.20Grand Total 36,855,142.68 36,918,579.84 137,356.10 46,736.23 149,156.85 58,536.98 3,228.64 61,765.62 Run Date: 6/6/2023 - 5:01 PM
Amortizing
28 37
Run Date: 7/10/2023 - 12:51 PM
Amortizing Page 2
Portfolio Summary
City of Lynwood 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 $35,892,711 $35,980,160 LAIF 26.3%
Book Value $36,959,418 $36,918,580 FHLB 18.1%
Variance -$1,066,706 -$938,420 U.S. Treasury 17.9%
FFCB 4.6%
Par Value $37,031,146 $36,992,817 FHLMC 4.1%
JPMorgan 1.4%
Net Asset Value $97.11 $97.46 FNMA 1.4%
Royal Bank of Canada 1.4%
Book Yield 2.84% 2.78% MetLife 1.4%
Apple 1.3%
Market Yield 4.72% 4.31% 3M 1.3%
Exxon Mobil 0.7%
Years to Maturity 1.76 1.79 Toyota 0.7%
US Bancorp 0.7%
Effective Duration 1.46 1.46 New York Life 0.7%
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.60%
1.10%
1.60%
2.10%
2.60%
3.10%
0.3%
1.4%
9.4%
16.7%
17.9%
26.3%
28.1%
MMF
CP
CORP
CD
TSY
LAIF
AGY
100%75%50%25%0%
41.8%
13.4%
19.6%
10.9%
14.3%
0-1Y 1-2Y 2-3Y 3-4Y 4-5Y+
0%
10%
20%
30%
40%
50%
60%
70%
42.9%
2.7%
2.7%
1.4%
0.7%
48.3%
1.4%
NR
A3
A2
A1
Aa3
Aa2
Aa1
Aaa
P-1
100%75%50%25%0%
2 38
Run Date: 7/10/2023 - 12:51 PM
Amortizing Page 3
Investment Policy Compliance
City of Lynwood 6/30/2023
Category Book Value % of Portfolio Allowed by Policy In ComplianceReserved row US Treasuries 6,615,279.05 17.90% 100% Yes
US Federal Agencies 10,396,230.98 28.13% 100% Yes
Supranational Obligations 0.00 0.00% 30% Yes
LAIF 9,710,816.80 26.27% $75,000,000 Yes
Commercial Paper 499,806.17 1.35% 25% Yes
Money Market Funds 93,328.79 0.25% 20% Yes
Negotiable Certificates of Deposit 6,153,985.50 16.65% 30% Yes Corporate Obligations 3,489,970.23 9.44% 30% Yes
State and Local Governments 0.00 0.00% 100% Yes
Total 36,959,417.52 100.00%
Other Metrics Portfolio Metric In Compliance
Weighted Average Maturity 1.76 Less than 3.0 Years Yes
Liquidity 41.77% 30% Under 365 Days Yes
Ratings Yes
3 39
Run Date: 7/10/2023 - 12:51 PM
Amortizing Page 11
Historical Earnings & Book Return Performance
City of Lynwood 6/30/2023
Fiscal YTD ($K) Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun FY 2021 $35.200 $66.215 $94.922 $120.389 $147.318 $173.870 $199.724 $223.094 $247.869 $271.162 $294.542 $316.873 FY 2022 $18.153 $37.347 $56.010 $82.204 $100.760 $118.668 $142.482 $159.901 $178.121 $203.773 $222.371 $242.161 FY 2023 $22.510 $61.308 $112.501 $198.598 $252.119 $307.834 $413.953 $476.124 $592.937 $653.599 $728.837 $789.814 Fiscal YTD Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Book Return 0.97% 1.17% 1.36% 1.75% 1.76% 1.76% 2.02% 2.04% 2.24% 2.21% 2.23% 2.21% Fiscal Year-To-Date Earnings
Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun
$0
$100
$200
$300
$400
$500
$600
$700
$800
$900
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
0.00%
0.25%
0.50%
0.75%
1.00%
1.25%
1.50%
1.75%
2.00%
2.25%
2.50%
11 40
Portfolio Summary
City of Lynwood June 30, 2023
Investments Par Value Book Value
% of
Portfolio YTMMaturity
Days to
Market Value
Book
Certificates of Deposit 6,157,000.00 6,153,985.50 16.65 3.28 1,129 5,995,122.14 Commercial Paper 500,000.00 499,806.17 1.35 4.76 3 499,225.00 Corporate Bonds 3,500,000.00 3,489,970.23 9.44 3.22 678 3,370,127.50 LAIF 9,710,816.80 9,710,816.80 26.27 3.17 1 9,710,816.80 Money Market Funds 93,328.79 93,328.79 0.25 5.01 1 93,328.79 U.S. Agencies 10,440,000.00 10,396,230.98 28.13 3.22 887 10,037,715.40 U.S. Treasuries 6,630,000.00 6,615,279.05 17.90 0.95 783 6,186,375.80 36,959,417.52 100.00 642 35,892,711.43 2.84 37,031,145.59 Investments
June 30 Month Ending Fiscal Year To DateTotal Earnings
Current Year 60,976.75 789,813.78
Average Daily Balance 36,925,193.72 35,676,840.15
Book Rate of Return 2.01% 2.21%
Run Date: 7/10/2023 - 12:51 PM
Amortizing
15 41
Holdings Report
City of Lynwood 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
38148PR33 248,000.00Goldman Sachs Bank 07/09/2018 247,432.08 99.97 247,918.09 0.67% NR/NR 0.0207/06/2023 -80.04 NR 0.02 3,946.26 3.35% 247,998.13 5.21%3.300% 949763TF3 248,000.00Wells Fargo Bank NA 08/31/2018 247,429.60 99.64 247,119.39 0.67% NR/NR 0.1708/30/2023 -861.54 NR 0.16 22.42 3.35% 247,980.93 5.45%3.300%
29278TLY4 248,000.00EnerBank 09/30/2019 247,523.84 99.16 245,927.65 0.67% NR/NR 0.2409/27/2023 -2,043.29 NR 0.24 54.36 2.05% 247,970.93 5.50%2.000% 17312Q3B3 248,000.00Citibank 02/28/2019 247,427.12 98.45 244,145.40 0.67% NR/NR 0.6602/27/2024 -3,778.63 NR 0.64 2,527.56 3.05% 247,924.03 5.41%3.000% 32100LCB9 248,000.00First Missouri State Bank 09/13/2019 248,000.00 95.29 236,315.38 0.67% NR/NR 1.2109/13/2024 -11,684.62 NR 1.18 1,382.68 1.85% 248,000.00 5.97%1.850% 27002YFE1 248,000.00EagleBank 08/18/2022 248,000.00 96.42 239,129.90 0.67% NR/NR 2.1408/18/2025 -8,870.10 NR 2.02 291.48 3.30% 248,000.00 5.08%3.300% 05580AXF6 248,000.00BMW Bank 09/25/2020 248,000.00 90.42 224,242.97 0.67% NR/NR 2.2409/25/2025 -23,757.03 NR 2.22 332.93 0.50% 248,000.00 5.09%0.500% 856283S98 248,000.00State Bank of India 04/27/2021 248,000.00 90.03 223,284.29 0.67% NR/NR 2.8304/27/2026 -24,715.71 NR 2.77 441.64 1.00% 248,000.00 4.82%1.000% 02007GUP6 248,000.00Ally Bank 07/07/2022 248,000.00 96.33 238,888.77 0.67% NR/NR 3.0207/07/2026 -9,111.23 NR 2.80 3,983.29 3.35% 248,000.00 4.67%3.350% 89235MLC3 248,000.00Toyota Financial Savings Bank 07/15/2021 248,000.00 89.48 221,899.49 0.67% NR/NR 3.0407/15/2026 -26,100.51 NR 2.98 1,077.95 0.95% 248,000.00 4.70%0.950% 90348JR93 248,000.00UBS Bank USA 08/11/2021 248,000.00 89.21 221,231.12 0.67% NR/NR 3.1208/11/2026 -26,768.88 NR 3.05 129.10 0.95% 248,000.00 4.70%0.950% 15721UFP9 248,000.00CFBank 03/15/2023 248,000.00 100.44 249,100.16 0.67% NR/NR 3.2109/15/2026 1,100.16 NR 2.90 516.38 4.75% 248,000.00 4.60%4.750% 32117BFR4 248,000.00First National Bank 03/23/2023 248,000.00 101.21 250,991.78 0.67% NR/NR 3.2409/23/2026 2,991.78 NR 2.91 271.78 5.00% 248,000.00 4.60%5.000% 910286GM9 248,000.00United Fidelity Bank FSB 06/29/2023 247,546.16 100.58 249,443.84 0.67% NR/NR 4.0006/29/2027 1,897.37 NR 3.62 61.83 4.60% 247,546.47 4.39%4.550%
254673L38 248,000.00Discover Bank 07/07/2022 248,000.00 96.41 239,106.79 0.67% NR/NR 4.0207/06/2027 -8,893.21 NR 3.66 4,065.84 3.40% 248,000.00 4.38%3.400% 14042RST9 248,000.00Capital One Bank NA 07/07/2022 248,000.00 96.60 239,559.21 0.67% NR/NR 4.0207/07/2027 -8,440.79 NR 3.66 4,102.19 3.45% 248,000.00 4.38%3.450% 14042TJD0 248,000.00Capital One Bank USA 08/03/2022 248,000.00 96.97 240,475.14 0.67% NR/NR 4.1008/03/2027 -7,524.86 NR 3.72 3,569.84 3.55% 248,000.00 4.37%3.550% 61768ELH4 248,000.00Morgan Stanley Private Bank 08/04/2022 248,000.00 96.78 240,003.66 0.67% NR/NR 4.1008/04/2027 -7,996.34 NR 3.73 3,495.78 3.50% 248,000.00 4.37%3.500% 87164XN93 248,000.00Synchrony Bank 08/05/2022 248,000.00 96.77 239,998.44 0.67% NR/NR 4.1008/05/2027 -8,001.56 NR 3.73 3,472.00 3.50% 248,000.00 4.37%3.500% Run Date: 7/10/2023 - 12:51 PM
Amortizing
16 42
Holdings Report
City of Lynwood 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
02589ADQ2 205,000.00American Express National Bank 08/12/2022 203,975.00 96.57 197,977.26 0.55% NR/NR 4.1208/10/2027 -6,178.68 NR 3.75 2,732.12 3.56% 204,155.95 4.37%3.450% 32114VCH8 248,000.00First National Bank of Michigan 03/15/2023 248,000.00 101.51 251,757.08 0.67% NR/NR 4.7103/15/2028 3,757.08 NR 4.14 500.08 4.60% 248,000.00 4.24%4.600% 61690U3C2 248,000.00Morgan Stanley Bank 03/16/2023 247,454.40 102.35 253,824.60 0.67% NR/NR 4.7203/16/2028 6,338.54 NR 4.12 3,489.67 4.85% 247,486.05 4.24%4.800% 062119BK7 248,000.00Bank Five Nine 03/20/2023 248,000.00 101.74 252,303.73 0.67% NR/NR 4.7303/20/2028 4,303.73 NR 4.14 347.54 4.65% 248,000.00 4.24%4.650% 12547CBJ6 248,000.00CIBC Bank USA 05/17/2023 247,446.96 100.57 249,416.19 0.67% NR/NR 4.8805/16/2028 1,955.91 NR 4.33 1,359.58 4.40% 247,460.29 4.22%4.350% 05600XQE3 248,000.00BMO Harris Bank NA 05/17/2023 247,449.44 101.23 251,061.80 0.67% NR/NR 4.8805/16/2028 3,599.09 NR 4.31 1,406.47 4.55% 247,462.71 4.22%4.500% 6,151,684.60 5,995,122.14 16.65% 3.09
6,153,985.50 3.28% 6,157,000.00 4.71% 43,580.77 -158,863.36 2.83Total Certificates of Deposit Commercial Paper
78015DU32 500,000.00Royal Bank of Canada, NY 10/07/2022 482,813.89 99.85 499,225.00 1.35% P-1/A-1+ 0.0107/03/2023 -581.17 F1+ 0.01 0.00 4.76% 499,806.17 18.89%0.000%
482,813.89 499,225.00 1.35% 0.01
499,806.17 4.76% 500,000.00 18.89% 0.00 -581.17 0.01Total Commercial Paper Corporate Bonds
90331HNV1 250,000.00US Bank 03/01/2019 253,307.50 99.87 249,662.50 0.68% A2/A+ 0.0707/24/2023 -387.65 A+ 0.05 3,706.94 3.08% 250,050.15 5.35%3.400% 07/11/2023 89236TFS9 250,000.00Toyota Motor Credit 02/28/2019 253,545.00 98.83 247,075.00 0.68% A1/A+ 0.5301/08/2024 -3,305.83 A+ 0.49 4,024.65 3.03% 250,380.83 5.65%3.350% 46625HJX9 500,000.00JPMorgan Chase & Co 05/13/2019 515,115.00 98.23 491,145.00 1.36% A1/A- 0.8705/13/2024 -11,483.33 AA- 0.83 2,416.67 2.97% 502,628.33 5.74%3.625% 64952WDL4 250,000.00New York Life 01/22/2020 249,102.50 94.56 236,392.50 0.68% Aaa/AA+ 1.5701/22/2025 -13,327.28 AAA 1.48 2,208.33 2.08% 249,719.78 5.69%2.000% 88579YBH3 500,000.003M 09/07/2022 476,510.00 94.31 471,555.00 1.31% A2/A- 1.6302/14/2025 -12,802.86 NR 1.54 3,805.56 4.04% 484,357.86 5.72%2.000% 30231GBH4 250,000.00Exxon Mobil 06/22/2020 272,752.50 96.33 240,815.00 0.70% Aa2/AA- 1.7203/19/2025 -17,435.61 NR 1.60 2,119.33 0.99% 258,250.61 5.25%2.992% 02/19/2025 Run Date: 7/10/2023 - 12:51 PM
Amortizing
17 43
Holdings Report
City of Lynwood 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
Corporate Bonds
59217GFC8 500,000.00MetLife 08/25/2022 499,380.00 96.33 481,640.00 1.35% Aa3/AA- 2.1608/25/2025 -17,915.09 AA- 1.98 7,087.50 4.09% 499,555.09 5.89%4.050% 037833BY5 500,000.00Apple 08/25/2022 496,085.00 96.28 481,380.00 1.34% Aaa/AA+ 2.6502/23/2026 -15,654.19 NR 2.38 5,777.78 3.49% 497,034.19 4.76%3.250% 808513BW4 250,000.00Charles Schwab 04/12/2022 249,407.50 92.68 231,710.00 0.68% A2/A- 3.7604/01/2027 -17,842.56 A 3.36 2,062.50 3.35% 249,552.56 5.48%3.300% 023135CF1 250,000.00Amazon 06/09/2022 248,005.00 95.50 238,752.50 0.67% A1/AA 3.7904/13/2027 -9,688.33 AA- 3.42 1,787.50 3.48% 248,440.83 4.61%3.300% 3,513,210.00 3,370,127.50 9.44% 1.86
3,489,970.23 3.22% 3,500,000.00 5.45% 34,996.76 -119,842.73 1.70Total Corporate Bonds LAIF
9819499 9,710,816.80LAIF 04/14/2023 9,710,816.80 1.00 9,710,816.80 26.27% NR/NR 0.0007/01/2023
0.00 NR 0.00 0.00 3.17% 9,710,816.80 3.17%3.170%
9,710,816.80 9,710,816.80 26.27% 0.00
9,710,816.80 3.17% 9,710,816.80 3.17% 0.00 0.00 0.00Total LAIF Money Market Funds
FGTXX 93,328.79Goldman Sachs Govt MMF 93,328.79 1.00 93,328.79 0.25% Aaa/AAA 0.0007/01/2023
0.00 NR 0.00 660.20 5.01% 93,328.79 5.01%5.015%
93,328.79 93,328.79 0.25% 0.00
93,328.79 5.01% 93,328.79 5.01% 660.20 0.00 0.00Total Money Market Funds U.S. Agencies
3130A0XE5 1,640,000.00FHLB 08/22/2022 1,636,785.60 98.53 1,615,826.40 4.43% Aaa/AA+ 0.6903/08/2024 -22,739.84 AAA 0.66 16,730.28 3.38% 1,638,566.24 5.45%3.250% 3133EKTV8 500,000.00FFCB 07/02/2019 499,900.00 96.52 482,620.00 1.35% Aaa/AA+ 1.0107/01/2024 -17,359.93 AAA 0.96 4,750.00 1.90% 499,979.93 5.51%1.900% 3133ENG20 1,000,000.00FFCB 08/18/2022 998,300.00 97.75 977,480.00 2.70% Aaa/AA+ 1.1308/15/2024 -21,559.75 AAA 1.07 12,466.67 3.39% 999,039.75 5.39%3.300% 3133EK3B0 200,000.00FFCB 10/17/2019 198,370.00 95.41 190,820.00 0.54% Aaa/AA+ 1.3010/16/2024 -8,757.78 AAA 1.24 625.00 1.67% 199,577.78 5.21%1.500% Run Date: 7/10/2023 - 12:51 PM
Amortizing
18 44
Holdings Report
City of Lynwood 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
3130A4CH3 500,000.00FHLB 10/07/2020 541,330.00 95.54 477,695.00 1.40% Aaa/AA+ 1.7103/14/2025 -38,195.18 AAA 1.62 3,529.51 0.49% 515,890.18 5.14%2.375% 3136G4H71 500,000.00FNMA 08/18/2020 500,000.00 91.22 456,095.00 1.35% Aaa/AA+ 2.1208/12/2025 -43,905.00 AAA 2.06 923.61 0.50% 500,000.00 4.92%0.500% 02/18/2022 3130ASYR4 2,000,000.00FHLB 08/30/2022 2,000,000.00 97.71 1,954,200.00 5.41% Aaa/AA+ 2.1608/28/2025 -45,800.00 AAA 1.59 27,333.33 4.00% 2,000,000.00 5.13%4.000% 08/28/2023 3137EAEX3 500,000.00FHLMC 10/20/2020 497,505.00 90.72 453,580.00 1.35% Aaa/AA+ 2.2409/23/2025 -45,290.00 AAA 2.16 510.42 0.48% 498,870.00 4.81%0.375% 3130AQEC3 500,000.00FHLB 12/30/2021 500,000.00 89.96 449,805.00 1.35% Aaa/AA+ 3.5012/30/2026 -50,195.00 AAA 3.31 19.03 1.37% 500,000.00 4.50%1.370% 09/30/2023 3130AL5A8 500,000.00FHLB 02/09/2023 438,340.00 87.12 435,580.00 1.20% Aaa/AA+ 3.6602/26/2027 -8,727.10 AAA 3.48 1,562.50 4.25% 444,307.10 4.78%0.900% 08/26/2023 3130ARTT8 600,000.00FHLB 05/19/2022 600,000.00 96.35 578,094.00 1.62% Aaa/AA+ 3.8905/19/2027 -21,906.00 AAA 2.42 2,275.00 3.25% 600,000.00 4.28%3.250% 08/19/2023 3130AT2L0 1,000,000.00FHLB 08/30/2022 1,000,000.00 96.62 966,190.00 2.71% Aaa/AA+ 4.1608/25/2027 -33,810.00 AAA 2.56 14,175.00 4.05% 1,000,000.00 4.96%4.050% 08/25/2023 3134GYUE0 1,000,000.00FHLMC 06/30/2023 1,000,000.00 99.97 999,730.00 2.71% Aaa/AA+ 5.0006/28/2028 -270.00 AAA 0.99 166.67 6.00% 1,000,000.00 6.01%6.000% 09/28/2023 10,410,530.60 10,037,715.40 28.13% 2.43
10,396,230.98 3.22% 10,440,000.00 5.17% 85,067.02 -358,515.58 1.65Total U.S. Agencies U.S. Treasuries
91282CAW1 1,000,000.00U.S. Treasury 07/22/2021 999,960.94 98.16 981,560.00 2.71% Aaa/AA+ 0.3811/15/2023 -18,433.63 AAA 0.36 319.29 0.25% 999,993.63 5.26%0.250% 91282CBV2 500,000.00U.S. Treasury 11/22/2021 496,308.59 96.12 480,585.00 1.35% Aaa/AA+ 0.7904/15/2024 -18,191.56 AAA 0.76 394.47 0.69% 498,776.56 5.45%0.375% 912828YV6 1,000,000.00U.S. Treasury 07/22/2021 1,035,742.19 94.93 949,260.00 2.75% Aaa/AA+ 1.4211/30/2024 -65,858.33 AAA 1.36 1,270.49 0.43% 1,015,118.33 5.26%1.500% 912828ZT0 500,000.00U.S. Treasury 06/29/2021 491,542.97 91.50 457,480.00 1.34% Aaa/AA+ 1.9205/31/2025 -38,380.07 AAA 1.86 105.87 0.69% 495,860.07 4.95%0.250% 91282CAZ4 1,000,000.00U.S. Treasury 07/22/2021 989,492.19 90.25 902,500.00 2.69% Aaa/AA+ 2.4211/30/2025 -91,665.26 AAA 2.34 317.62 0.62% 994,165.26 4.69%0.375% 91282CBH3 500,000.00U.S. Treasury 02/25/2021 494,433.59 89.77 448,830.00 1.34% Aaa/AA+ 2.5901/31/2026 -48,246.17 AAA 2.50 782.11 0.60% 497,076.17 4.62%0.375% 91282CCF6 1,000,000.00U.S. Treasury 07/22/2021 1,002,382.81 89.80 897,970.00 2.71% Aaa/AA+ 2.9205/31/2026 -103,461.84 AAA 2.80 635.25 0.70% 1,001,431.84 4.52%0.750% Run Date: 7/10/2023 - 12:51 PM
Amortizing
19 45
Holdings Report
City of Lynwood 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. Treasuries
91282CCZ2 500,000.00U.S. Treasury 10/19/2021 492,949.22 89.45 447,225.00 1.34% Aaa/AA+ 3.2509/30/2026 -48,139.51 AAA 3.11 1,099.73 1.17% 495,364.51 4.39%0.875% 91282CGC9 630,000.00U.S. Treasury 03/03/2023 616,587.89 98.57 620,965.80 1.67% Aaa/AA+ 4.5112/31/2027 3,473.12 AAA 4.05 66.34 4.37% 617,492.68 4.23%3.875% 6,619,400.39 6,186,375.80 17.90% 2.14
6,615,279.05 0.95% 6,630,000.00 4.84% 4,991.17 -428,903.25 2.03Total U.S. Treasuries 36,981,785.07 35,892,711.43 100.00% 1.76
169,295.92 -1,066,706.09 1.46 4.72% 36,959,417.52 2.84% 37,031,145.59TOTAL PORTFOLIO TOTAL MARKET VALUE PLUS ACCRUED INTEREST 36,062,007.35 Run Date: 7/10/2023 - 12:51 PM
Amortizing
20 46
Maturity Report
City of Lynwood June 30, 2023
CUSIP Date
Purchase
Value
Book
Rate
Coupon
Date
Maturity
Par
Remaining
Term Value
Market
YTMIssuer
Days to
Maturity
Book
FGTXX 5.015% 1Goldman Sachs Govt MMF 93,328.79 07/01/2023 1 5.01% 93,328.79 93,328.79 9819499 3.170% 1LAIF 05/18/2020 9,710,816.80 07/01/2023 1 3.17% 9,710,816.80 9,710,816.80 78015DU32 0.000% 266Royal Bank of Canada, NY 10/07/2022 499,806.17 07/03/2023 3 4.76% 500,000.00 499,225.00 38148PR33 3.300% 1,817Goldman Sachs Bank 07/09/2018 247,998.13 07/06/2023 6 3.35% 248,000.00 247,918.09 90331HNV1 3.400% 1,582US Bank 03/01/2019 250,050.15 07/24/2023 24 3.08% 250,000.00 249,662.50 949763TF3 3.300% 1,764Wells Fargo Bank NA 08/31/2018 247,980.93 08/30/2023 61 3.35% 248,000.00 247,119.39 29278TLY4 2.000% 1,369EnerBank 09/30/2019 247,970.93 09/27/2023 89 2.05% 248,000.00 245,927.65 91282CAW1 0.250% 708U.S. Treasury 07/22/2021 999,993.63 11/15/2023 138 0.25% 1,000,000.00 981,560.00 89236TFS9 3.350% 1,583Toyota Motor Credit 02/28/2019 250,380.83 01/08/2024 192 3.03% 250,000.00 247,075.00 17312Q3B3 3.000% 1,583Citibank 02/28/2019 247,924.03 02/27/2024 242 3.05% 248,000.00 244,145.40 3130A0XE5 3.250% 312FHLB 08/22/2022 1,638,566.24 03/08/2024 252 3.38% 1,640,000.00 1,615,826.40 91282CBV2 0.375% 585U.S. Treasury 11/22/2021 498,776.56 04/15/2024 290 0.69% 500,000.00 480,585.00 46625HJX9 3.625% 1,509JPMorgan Chase & Co 05/13/2019 502,628.33 05/13/2024 318 2.97% 500,000.00 491,145.00 3133EKTV8 1.900% 1,459FFCB 07/02/2019 499,979.93 07/01/2024 367 1.90% 500,000.00 482,620.00 3133ENG20 3.300% 316FFCB 08/18/2022 999,039.75 08/15/2024 412 3.39% 1,000,000.00 977,480.00 32100LCB9 1.850% 1,386First Missouri State Bank 09/13/2019 248,000.00 09/13/2024 441 1.85% 248,000.00 236,315.38 3133EK3B0 1.500% 1,352FFCB 10/17/2019 199,577.78 10/16/2024 474 1.67% 200,000.00 190,820.00 912828YV6 1.500% 708U.S. Treasury 07/22/2021 1,015,118.33 11/30/2024 519 0.43% 1,000,000.00 949,260.00 64952WDL4 2.000% 1,255New York Life 01/22/2020 249,719.78 01/22/2025 572 2.08% 250,000.00 236,392.50 88579YBH3 2.000% 2963M 09/07/2022 484,357.86 02/14/2025 595 4.04% 500,000.00 471,555.00 3130A4CH3 2.375% 996FHLB 10/07/2020 515,890.18 03/14/2025 623 0.49% 500,000.00 477,695.00 30231GBH4 2.992% 1,103Exxon Mobil 06/22/2020 258,250.61 03/19/2025 628 0.99% 250,000.00 240,815.00 912828ZT0 0.250% 731U.S. Treasury 06/29/2021 495,860.07 05/31/2025 701 0.69% 500,000.00 457,480.00 3136G4H71 0.500% 1,046FNMA 08/18/2020 500,000.00 08/12/2025 774 0.50% 500,000.00 456,095.00 27002YFE1 3.300% 316EagleBank 08/18/2022 248,000.00 08/18/2025 780 3.30% 248,000.00 239,129.90 59217GFC8 4.050% 309MetLife 08/25/2022 499,555.09 08/25/2025 787 4.09% 500,000.00 481,640.00 3130ASYR4 4.000% 304FHLB 08/30/2022 2,000,000.00 08/28/2025 790 4.00% 2,000,000.00 1,954,200.00 3137EAEX3 0.375% 983FHLMC 10/20/2020 498,870.00 09/23/2025 816 0.48% 500,000.00 453,580.00 05580AXF6 0.500% 1,008BMW Bank 09/25/2020 248,000.00 09/25/2025 818 0.50% 248,000.00 224,242.97 91282CAZ4 0.375% 708U.S. Treasury 07/22/2021 994,165.26 11/30/2025 884 0.62% 1,000,000.00 902,500.00 91282CBH3 0.375% 855U.S. Treasury 02/25/2021 497,076.17 01/31/2026 946 0.60% 500,000.00 448,830.00 037833BY5 3.250% 309Apple 08/25/2022 497,034.19 02/23/2026 969 3.49% 500,000.00 481,380.00 856283S98 1.000% 794State Bank of India 04/27/2021 248,000.00 04/27/2026 1,032 1.00% 248,000.00 223,284.29 91282CCF6 0.750% 708U.S. Treasury 07/22/2021 1,001,431.84 05/31/2026 1,066 0.70% 1,000,000.00 897,970.00 02007GUP6 3.350% 358Ally Bank 07/07/2022 248,000.00 07/07/2026 1,103 3.35% 248,000.00 238,888.77 89235MLC3 0.950% 715Toyota Financial Savings Bank 07/15/2021 248,000.00 07/15/2026 1,111 0.95% 248,000.00 221,899.49 Run Date: 7/10/2023 - 12:51 PM
Amortizing
21 47
Maturity Report
City of Lynwood June 30, 2023
CUSIP Date
Purchase
Value
Book
Rate
Coupon
Date
Maturity
Par
Remaining
Term Value
Market
YTMIssuer
Days to
Maturity
Book
90348JR93 0.950% 688UBS Bank USA 08/11/2021 248,000.00 08/11/2026 1,138 0.95% 248,000.00 221,231.12 15721UFP9 4.750% 107CFBank 03/15/2023 248,000.00 09/15/2026 1,173 4.75% 248,000.00 249,100.16 32117BFR4 5.000% 99First National Bank 03/23/2023 248,000.00 09/23/2026 1,181 5.00% 248,000.00 250,991.78 91282CCZ2 0.875% 619U.S. Treasury 10/19/2021 495,364.51 09/30/2026 1,188 1.17% 500,000.00 447,225.00 3130AQEC3 1.370% 547FHLB 12/30/2021 500,000.00 12/30/2026 1,279 1.37% 500,000.00 449,805.00 3130AL5A8 0.900% 141FHLB 02/09/2023 444,307.10 02/26/2027 1,337 4.25% 500,000.00 435,580.00 808513BW4 3.300% 444Charles Schwab 04/12/2022 249,552.56 04/01/2027 1,371 3.35% 250,000.00 231,710.00 023135CF1 3.300% 386Amazon 06/09/2022 248,440.83 04/13/2027 1,383 3.48% 250,000.00 238,752.50 3130ARTT8 3.250% 407FHLB 05/19/2022 600,000.00 05/19/2027 1,419 3.25% 600,000.00 578,094.00 910286GM9 4.550% 1United Fidelity Bank FSB 06/29/2023 247,546.47 06/29/2027 1,460 4.60% 248,000.00 249,443.84 254673L38 3.400% 358Discover Bank 07/07/2022 248,000.00 07/06/2027 1,467 3.40% 248,000.00 239,106.79 14042RST9 3.450% 358Capital One Bank NA 07/07/2022 248,000.00 07/07/2027 1,468 3.45% 248,000.00 239,559.21 14042TJD0 3.550% 331Capital One Bank USA 08/03/2022 248,000.00 08/03/2027 1,495 3.55% 248,000.00 240,475.14 61768ELH4 3.500% 330Morgan Stanley Private Bank 08/04/2022 248,000.00 08/04/2027 1,496 3.50% 248,000.00 240,003.66 87164XN93 3.500% 329Synchrony Bank 08/05/2022 248,000.00 08/05/2027 1,497 3.50% 248,000.00 239,998.44 02589ADQ2 3.450% 322American Express National Bank 08/12/2022 204,155.95 08/10/2027 1,502 3.56% 205,000.00 197,977.26 3130AT2L0 4.050% 304FHLB 08/30/2022 1,000,000.00 08/25/2027 1,517 4.05% 1,000,000.00 966,190.00 91282CGC9 3.875% 119U.S. Treasury 03/03/2023 617,492.68 12/31/2027 1,645 4.37% 630,000.00 620,965.80 32114VCH8 4.600% 107First National Bank of Michigan 03/15/2023 248,000.00 03/15/2028 1,720 4.60% 248,000.00 251,757.08 61690U3C2 4.800% 106Morgan Stanley Bank 03/16/2023 247,486.05 03/16/2028 1,721 4.85% 248,000.00 253,824.60 062119BK7 4.650% 102Bank Five Nine 03/20/2023 248,000.00 03/20/2028 1,725 4.65% 248,000.00 252,303.73 12547CBJ6 4.350% 44CIBC Bank USA 05/17/2023 247,460.29 05/16/2028 1,782 4.40% 248,000.00 249,416.19 05600XQE3 4.500% 44BMO Harris Bank NA 05/17/2023 247,462.71 05/16/2028 1,782 4.55% 248,000.00 251,061.80 3134GYUE0 6.000% 0FHLMC 06/30/2023 1,000,000.00 06/28/2028 1,825 6.00% 1,000,000.00 999,730.00 Net Maturities and Averages 36,959,417.52 642 2.84% 35,892,711.43 37,031,145.59 Run Date: 7/10/2023 - 12:51 PM
Amortizing
22 48
Income Earned Summary
City of Lynwood June 30, 2023
Fiscal Year To DateJune 30 Month End
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
37,874.55 631,837.44
169,295.92 169,295.92
-149,156.85 -74,680.06
58,013.62 726,453.30
2,963.13 49,888.18
13,472.29 0.00
60,976.75
789,813.78
Run Date: 7/10/2023 - 12:51 PM
Amortizing
25 49
Income Earned
City of Lynwood 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
20033AZK5 06/29/2023 0.00Comenity Capital Bank 247,990.90 0.00 67.27 695.08 0.00 627.81 9.10 636.91 38148PR33 07/06/2023 248,000.00Goldman Sachs Bank 247,988.78 247,998.13 3,273.60 0.00 3,946.26 672.66 9.35 682.01 949763TF3 08/30/2023 248,000.00Wells Fargo Bank NA 247,971.56 247,980.93 44.84 695.08 22.42 672.66 9.38 682.04 29278TLY4 09/27/2023 248,000.00EnerBank 247,961.14 247,970.93 67.95 421.26 54.36 407.67 9.80 417.47 17312Q3B3 02/27/2024 248,000.00Citibank 247,914.62 247,924.03 1,916.05 0.00 2,527.56 611.51 9.42 620.93 32100LCB9 09/13/2024 248,000.00First Missouri State Bank 248,000.00 248,000.00 1,005.59 0.00 1,382.68 377.09 0.00 377.09 27002YFE1 08/18/2025 248,000.00EagleBank 248,000.00 248,000.00 313.91 695.08 291.48 672.65 0.00 672.65 05580AXF6 09/25/2025 248,000.00BMW Bank 248,000.00 248,000.00 231.01 0.00 332.93 101.92 0.00 101.92 856283S98 04/27/2026 248,000.00State Bank of India 248,000.00 248,000.00 237.81 0.00 441.64 203.83 0.00 203.83 02007GUP6 07/07/2026 248,000.00Ally Bank 248,000.00 248,000.00 3,300.44 0.00 3,983.29 682.85 0.00 682.85 89235MLC3 07/15/2026 248,000.00Toyota Financial Savings Bank 248,000.00 248,000.00 884.31 0.00 1,077.95 193.64 0.00 193.64 90348JR93 08/11/2026 248,000.00UBS Bank USA 248,000.00 248,000.00 135.55 200.10 129.10 193.65 0.00 193.65 15721UFP9 09/15/2026 248,000.00CFBank 248,000.00 248,000.00 548.66 1,000.49 516.38 968.21 0.00 968.21 32117BFR4 09/23/2026 248,000.00First National Bank 248,000.00 248,000.00 305.75 1,053.15 271.78 1,019.18 0.00 1,019.18 910286GM9 06/29/2027 248,000.00United Fidelity Bank FSB 0.00 247,546.47 0.00 0.00 61.83 61.83 0.31 62.14 254673L38 07/06/2027 248,000.00Discover Bank 248,000.00 248,000.00 3,372.80 0.00 4,065.84 693.04 0.00 693.04 14042RST9 07/07/2027 248,000.00Capital One Bank NA 248,000.00 248,000.00 3,398.96 0.00 4,102.19 703.23 0.00 703.23 14042TJD0 08/03/2027 248,000.00Capital One Bank USA 248,000.00 248,000.00 2,846.22 0.00 3,569.84 723.62 0.00 723.62 61768ELH4 08/04/2027 248,000.00Morgan Stanley Private Bank 248,000.00 248,000.00 2,782.36 0.00 3,495.78 713.42 0.00 713.42 87164XN93 08/05/2027 248,000.00Synchrony Bank 248,000.00 248,000.00 2,758.58 0.00 3,472.00 713.42 0.00 713.42 02589ADQ2 08/10/2027 205,000.00American Express National Bank 204,139.09 204,155.95 2,150.82 0.00 2,732.12 581.30 16.86 598.16 32114VCH8 03/15/2028 248,000.00First National Bank of Michigan 248,000.00 248,000.00 531.33 968.90 500.08 937.65 0.00 937.65 61690U3C2 03/16/2028 248,000.00Morgan Stanley Bank 247,477.10 247,486.05 2,511.25 0.00 3,489.67 978.42 8.96 987.38 062119BK7 03/20/2028 248,000.00Bank Five Nine 248,000.00 248,000.00 379.13 979.43 347.54 947.84 0.00 947.84 05600XQE3 05/16/2028 248,000.00BMO Harris Bank NA 247,453.66 247,462.71 489.21 0.00 1,406.47 917.26 9.05 926.31 12547CBJ6 05/16/2028 248,000.00CIBC Bank USA 247,451.20 247,460.29 472.90 0.00 1,359.58 886.68 9.09 895.77 Certificates of Deposit - Sub Total 6,157,000.00 6,154,348.05 6,153,985.50 34,026.30 6,708.57 43,580.77 16,263.04 91.29 16,354.33 Commercial Paper
78015DU32 07/03/2023 500,000.00Royal Bank of Canada, NY 497,932.50 499,806.17 0.00 0.00 0.00 0.00 1,873.67 1,873.67 Commercial Paper - Sub Total
500,000.00 497,932.50 499,806.17 0.00 0.00 0.00 0.00 1,873.67 1,873.67 Corporate Bonds
90331HNV1 07/24/2023 250,000.00US Bank 250,110.74 250,050.15 2,998.61 0.00 3,706.94 708.33 -60.59 647.74 Run Date: 7/10/2023 - 12:51 PM
Amortizing
26 50
Income Earned
City of Lynwood 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
Corporate Bonds
89236TFS9 01/08/2024 250,000.00Toyota Motor Credit 250,441.61 250,380.83 3,326.74 0.00 4,024.65 697.91 -60.77 637.14 46625HJX9 05/13/2024 500,000.00JPMorgan Chase & Co 502,871.85 502,628.33 906.25 0.00 2,416.67 1,510.42 -243.52 1,266.90 64952WDL4 01/22/2025 250,000.00New York Life 249,705.32 249,719.78 1,791.67 0.00 2,208.33 416.66 14.46 431.12 88579YBH3 02/14/2025 500,000.003M 483,581.11 484,357.86 2,972.22 0.00 3,805.56 833.34 776.75 1,610.09 30231GBH4 03/19/2025 250,000.00Exxon Mobil 258,637.15 258,250.61 1,496.00 0.00 2,119.33 623.33 -386.54 236.79 59217GFC8 08/25/2025 500,000.00MetLife 499,538.44 499,555.09 5,400.00 0.00 7,087.50 1,687.50 16.65 1,704.15 037833BY5 02/23/2026 500,000.00Apple 496,943.93 497,034.19 4,423.61 0.00 5,777.78 1,354.17 90.25 1,444.42 808513BW4 04/01/2027 250,000.00Charles Schwab 249,542.96 249,552.56 1,375.00 0.00 2,062.50 687.50 9.60 697.10 023135CF1 04/13/2027 250,000.00Amazon 248,407.66 248,440.83 1,100.00 0.00 1,787.50 687.50 33.17 720.67 Corporate Bonds - Sub Total 3,500,000.00 3,489,780.77 3,489,970.23 25,790.10 0.00 34,996.76 9,206.66 189.46 9,396.12 LAIF
9819499 07/01/2023 9,710,816.80LAIF 9,710,816.80 9,710,816.80 0.00 0.00 0.00 0.00 0.00 0.00 LAIF - Sub Total
9,710,816.80 9,710,816.80 9,710,816.80 0.00 0.00 0.00 0.00 0.00 0.00 Money Market Funds
FGTXX 07/01/2023 93,328.79Goldman Sachs Govt MMF 55,000.40 93,328.79 409.73 409.73 660.20 660.20 0.00 660.20 Money Market Funds - Sub Total
93,328.79 55,000.40 93,328.79 409.73 409.73 660.20 660.20 0.00 660.20 U.S. Agencies
3130A0XE5 03/08/2024 1,640,000.00FHLB 1,638,398.58 1,638,566.24 12,288.61 0.00 16,730.28 4,441.67 167.66 4,609.33 3133EKTV8 07/01/2024 500,000.00FFCB 499,978.32 499,979.93 3,958.33 0.00 4,750.00 791.67 1.61 793.28 3133ENG20 08/15/2024 1,000,000.00FFCB 998,970.99 999,039.75 9,716.67 0.00 12,466.67 2,750.00 68.76 2,818.76 3133EK3B0 10/16/2024 200,000.00FFCB 199,551.50 199,577.78 375.00 0.00 625.00 250.00 26.28 276.28 3130A4CH3 03/14/2025 500,000.00FHLB 516,640.70 515,890.18 2,539.93 0.00 3,529.51 989.58 -750.51 239.07 3136G4H71 08/12/2025 500,000.00FNMA 500,000.00 500,000.00 715.28 0.00 923.61 208.33 0.00 208.33 3130ASYR4 08/28/2025 2,000,000.00FHLB 2,000,000.00 2,000,000.00 20,666.67 0.00 27,333.33 6,666.66 0.00 6,666.66 3137EAEX3 09/23/2025 500,000.00FHLMC 498,829.19 498,870.00 354.17 0.00 510.42 156.25 40.81 197.06 3130AQEC3 12/30/2026 500,000.00FHLB 500,000.00 500,000.00 2,873.19 3,425.00 19.03 570.84 0.00 570.84 3130AL5A8 02/26/2027 500,000.00FHLB 443,079.82 444,307.10 1,187.50 0.00 1,562.50 375.00 1,227.28 1,602.28 3130ARTT8 05/19/2027 600,000.00FHLB 600,000.00 600,000.00 650.00 0.00 2,275.00 1,625.00 0.00 1,625.00 3130AT2L0 08/25/2027 1,000,000.00FHLB 1,000,000.00 1,000,000.00 10,800.00 0.00 14,175.00 3,375.00 0.00 3,375.00 3130AV6P2 03/27/2028 0.00FHLB 1,000,000.00 0.00 10,755.56 15,125.00 0.00 4,369.44 0.00 4,369.44 3134GYUE0 06/28/2028 1,000,000.00FHLMC 0.00 1,000,000.00 0.00 0.00 166.67 166.67 0.00 166.67 Run Date: 7/10/2023 - 12:51 PM
Amortizing
27 51
Income Earned
City of Lynwood 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 - Sub Total 10,440,000.00 10,395,449.10 10,396,230.98 76,880.91 18,550.00 85,067.02 26,736.11 781.88 27,517.99 U.S. Treasuries
91282CAW1 11/15/2023 1,000,000.00U.S. Treasury 999,992.24 999,993.63 115.49 0.00 319.29 203.80 1.39 205.19 91282CBV2 04/15/2024 500,000.00U.S. Treasury 498,650.00 498,776.56 240.78 0.00 394.47 153.69 126.56 280.25 912828YV6 11/30/2024 1,000,000.00U.S. Treasury 1,015,992.23 1,015,118.33 40.98 0.00 1,270.49 1,229.51 -873.89 355.62 912828ZT0 05/31/2025 500,000.00U.S. Treasury 495,682.90 495,860.07 3.42 0.00 105.87 102.45 177.17 279.62 91282CAZ4 11/30/2025 1,000,000.00U.S. Treasury 993,967.25 994,165.26 10.25 0.00 317.62 307.37 198.01 505.38 91282CBH3 01/31/2026 500,000.00U.S. Treasury 496,983.44 497,076.17 626.73 0.00 782.11 155.38 92.72 248.10 91282CCF6 05/31/2026 1,000,000.00U.S. Treasury 1,001,472.13 1,001,431.84 20.49 0.00 635.25 614.76 -40.30 574.46 91282CCZ2 09/30/2026 500,000.00U.S. Treasury 495,247.45 495,364.51 741.12 0.00 1,099.73 358.61 117.06 475.67 91282CGC9 12/31/2027 630,000.00U.S. Treasury 617,264.58 617,492.68 10,250.55 12,206.25 66.34 2,022.04 228.10 2,250.14 U.S. Treasuries - Sub Total 6,630,000.00 6,615,252.23 6,615,279.05 12,049.81 12,206.25 4,991.17 5,147.61 26.82 5,174.43 37,031,145.59Grand Total 36,918,579.84 36,959,417.52 149,156.85 37,874.55 169,295.92 58,013.62 2,963.13 60,976.75 Run Date: 7/10/2023 - 12:51 PM
Amortizing
28 52