HomeMy Public PortalAbout2024-05-07 - LPFA1.CALL TO ORDER
2.CERTIFICATION OF AGENDA POSTING BY SECRETARY
3.ROLL CALL OF MEMBERS
4.GOVERNMENT CODE SECTION 54954.3
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
CITYCLERK@LYNWOODCA.GOV 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
May 7, 2024
COUNCIL CHAMBERS - 11350 BULLIS ROAD. LYNWOOD, CA 90262
Duly Posted on 5/4/2024 By MQ
6:00 PM
Jose Luis Solache, President
Rita Soto, Vice President
Gabriela Camacho, Member
Oscar Flores, Member
Juan Munoz-Guevara, Member
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
5.CONSENT CALENDAR
5.1 TREASURER'S QUARTERLY INVESTMENT 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 City Council for 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 3rd quarter ending March 31, 2024.
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:May 7, 2024
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 INVESTMENT REPORT
Agenda Item # 5.1.
Recommendation:
It is recommended that City Council for 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 3rd quarter ending March 31, 2024.
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:
1. Annual adoption of an Investment Policy that incorporates changes mandated by the
State.
2. Quarterly Investment Reports presented to the Legislative Body or Board Members.
3. 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.
Discussion and Analysis:
Lynwood Public Financing Authority Lynwood Public Financing Authority 3
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 pooled Local Agency Investment Fund
(LAIF) administered by the State Treasurer. LAIF is a high-quality investment available in
terms of safety, liquidity and yield. All funds invested in LAIF are essentially available overnight
and provide the City with liquidity for City operations. Liquidity is important to the City and it is
critical that funds are available when needed in order to meet the day to day operations, large
CIP and debt services.
The funds held in the City's LAIF account has an investable balance of $9,974,535. The
interest earned for the 3rd quarter were $99,208. This fiscal year, LAIF has earned a total of
$263,708 in interest. The balance in the account may vary throughout the year depending on
cash flow. Several factors have significant impact on cash flow. Property tax revenue is
received primarily in December, January, April and May while dept payments typically falls in
February, May, August and November. In addition large payments on capital projects can
happen throughout the year.
The City utilizes a variety of investment vehicles, including direct and indirect investments.
Direct investments are primary fixed income securities issued by the U.S. Treasury, several
U.S. Government Agencies, such as Federal National Mortgage Association (FNMA) and the
Federal Home Loan Mortgage Corporation (FHLMC), and Certificates of Deposit. Indirect
investments include money market funds and pooled investment managed by other agencies,
including California Local Agency Investment Fund (LAIF), California Asset Management
Program (CAMP) and the San Diego Investment Pool. Indirect investment balances are
generally available to the City on a next day basis and are classified as "liquid" meaning to pay
current demands. Money invested in indirect securities can only be accessed via maturity of
the security or selling the maturity prior to maturity. The City has overnight liquidity including
cash in the bank of $41.9 million as of March 31, 2024.
There are three petty cash funds totaling $3,300; City Manager's Office $2,000, Finance
Department $1,000 and City Treasurer's Office $300. There are two change funds totaling
$640.00; Water Billing $600 and Recreation $40.
The total received from Urban Farming for the quarter is $23,100.
The market valuation is provided by Meeder Public Fund and all of the investments are in
compliance with California Government Code Sections 53600 et seq. and the City’s
Investment Policy. The funds vested by Meeder has earned a total of $524,927 in interest this
fiscal year.
The public's monies are extremely safe and well-diversified and follow the City's adopted
investment policy and the overall direction of the City Council. The City's cash and investment
portfolio is sufficiently liquid to meet expected expenditures for the coming six months.
Fiscal Impact:
Lynwood Public Financing Authority Lynwood Public Financing Authority
4
3rd Quarter Summary - March 2024.pdf
Meeder 3rd Quarter Report - March 2024.pdf
Meeder Monthly - February 2024.pdf
Meeder Monthly - January 2024.pdf
There is no direct fiscal impact associated with this report.
Coordinated With:
Meeder Public Funds.
ATTACHMENTS:
Description
Lynwood Public Financing Authority Lynwood Public Financing Authority 5
AVERAGE
MARKET PERCENTAGE (%)DAYS TO
DESCRIPTION VALUE PORTFOLIO MATURITY
INVESTMENTS*37,213,046.55$ 100%*
MONEY MARKET/CUSTODY HOLDINGS 9,131,128.03$
DEMAND DEPOSIT ACCOUNTS 57,645,880.34$
TOTAL AVERAGES 66,777,008.37$
TOTAL INVESTMENTS & AVERAGES*103,990,054.92$
*This report balance is understated by $896.54. The interest
paid out on 3/29/24 but did not swept until 4/1/2024 since
the stock market was closed for Good Friday.
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
March 31, 2024
MASTER SUMMARY
March 2024
6
PAR MARKET BOOK % OF
INVESTMENTS VALUE VALUE VALUE PORTFOLIO
*Money Market Funds 2,121,451.84$ 2,121,451.84$ 2,121,451.84$ 5.61%
LAIF 9,974,525.05$ 9,974,525.05$ 9,974,525.05$ 26.36%
Corporate Notes 3,500,000.00$ 3,431,926.97$ 3,488,397.74$ 9.22%
Commercial Paper -$ -$ -$ 0.00%
Federal Agency 10,800,000.00$ 10,587,362.74$ 10,760,831.80$ 28.44%
Treasury Coupon Securities 6,130,000.00$ 5,803,591.42$ 6,080,274.30$ 16.07%
CD-FDIC 5,413,000.00$ 5,294,188.53$ 5,410,095.18$ 14.30%
TOTAL 37,938,976.89$ 37,213,046.55$ 37,835,575.91$ 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)128,478.31$ N/A 1,993.41$
JP Morgan Chase - Money Market Account 1,930,118.83$ N/A 29,947.02$
JP Morgan Chase - Parking Enforcement 7,067,988.86$ N/A 69,172.91$
US Bank - City of Lynwood 4,542.03$ N/A 1.04$
TOTAL 9,131,128.03$ 101,114.38$
Corporate Checking Accounts Balance
General Account 41,908,402.70$
US Bank - City HCDA 150,518.11$
US Bank - City Home Program 1,020,153.96$
US Bank - Economic Development 13,616.17$
US Bank - Housing Authority A 82,821.59$
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 6,459,638.85$
US Bank - Low Mod Housing Trst Fnd/Rogel 4,807,520.60$
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 57,645,880.34$
CITY OF LYNWOOD
QUARTERLY REPORT
March 31, 2024
PORTFOLIO SUMMARY
March 2024
7
Schedule of City Cash & Investments: This schedule provides information on the cash and investments
managed by the City.
Quarterly Interest Credit
Money Market/Custody Holdings Balance Interest F/Y to Date
JP Morgan Chase - Section 108 MMA 128,478.31$ 670.27$ 1,993.41$
JP Morgan Chase - Money Market Account 1,930,118.83$ 10,069.44$ 29,947.02$
JP Morgan Chase - Parking Enforcement 7,067,988.86$ 36,388.27$ 69,172.91$
US Bank - City of Lynwood 4,542.03$ 0.54$ 1.04$
Total 9,131,128.03$ 47,128.52$ 101,114.38$
Demand Deposits
General Account 41,908,402.70$
US Bank - Economic Development 13,616.17$
US Bank - Housing Authority A 82,821.59$
US Bank - Housing Authority B 18,000.09$
US Bank - City HCDA 150,518.11$
US Bank - City Home Program 1,020,153.96$
US Bank - Taxable Tabs 2,611,325.52$
US Bank - Lyn Tr. Center Unf Wrkr 2,791.24$
US Bank - Money Market Account 49,028.48$
US Bank - US Dept. of HUD/Section 108 170,048.96$
US Bank - RORF Successor Agency 6,459,638.85$
US Bank - Low Mod Housing Trst Fnd/Rogel 4,807,520.60$
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 57,645,880.34$
Money Market Fund - A Money Market fund is a type of mutual fund that invest in short term debt
securities of agenies of the U.S. Government, banks, corporations and U.S. Treasury Bills.
Some advantages of a money market fund over savings and CDs are high liquidity, low risk, and competive yields.
The City currently has a total of five MMA accounts within the City's investment portfolio.
Certificate of Deposit - A Certificate of Deposit or CD, is a time deposit. They are similar to savings
accounts in that they are insured and relatively risk-free. They are different from savings accounts in that
they usually are for a fixed term and a fixed interest rae. CDs are inteded to be held until maturity, at which
time, the money may be withdrawn together with the accrued interest. The City currently has one CD
within the City's investment portfolio
Demand Deposits - Also known as "cash in the bank", this is the balance of the City's checking account with
US Bank, from which virtually all obligations are paid.
CITY OF LYNWOOD
QUARTERLY INVESTMENT REPORT
March 31, 2024
8
Quarter Ending Interest
Issuer Investment Balance Interest Rate
State of California LAIF 9,974,525.05$ 106,575.32 31-Mar-24 4.30%
Local Agency Investment Fund (LAIF):
The Local Agency Investment Fund is managed by the State Treasurer's Office Investment Division through the Pooled Money
Investment Account (PIMA). The LAIF allows cities, counties and special districts to place money in a major portfolio and to use
the expertise of their Investment Division staff, with no additional cost to taxpayers. Participating agencies can withdraw their
funds from the LAIF at any time. The State Treasurer invests money safely and prudently while minimizing the service costs
and maximizing the service costs and maximizing the investment yields. These investments help manage cash flow and
enhance financial security. The interest earned from the LAIF is distribued quarterly. (See Chart Below)
MONEY POOLED INVESTMENT ACCOUNT
(chart dollars in millions)
CITY OF LYNWOOD
QUARTERLY REPORT
March 31, 2024
LAIF Daily Yield 3.98% - Quarter to Date 3.80% - Average Days to Maturity 232
Total $156.5 Billion
MONTHLY PORTFOLIO COMPOSITION
0.00%
10.00%
20.00%
30.00%
40.00%
50.00%
60.00%
70.00%
Agencies Certificate of
Deposits
Time Deposits Commercial
Paper
Corporate
Bonds
Loans Treasuries
Chart Title
March 2024
9
JANUARY FEBRUARY MARCH
Market Value $37,075,332 $37,151,349 $37,213,047
Book Value $37,633,978 $37,768,036 $37,835,576
Variance ($558,646)($616,687)($622,529)
Par Value $37,704,734 $37,873,367 $37,938,977
Net Asset Value $98.52 $98.37 $98.35
Book Yield 3.28%3.32%3.44%
Market Yield 4.48%4.66%4.73%
Years to Maturity 1.62 1.62 1.56
Effective Duration 1.37 1.36 1.36
JANUARY FEBRUARY MARCH
Total Earnings Per Month 85,637.62$ $68,641 70,145.68$
F/Y Earnings to Date 649,849.77$ 718,491.08$ 788,636.75$
Average Daily Balance 37,586,468.68$ 37,674,187.73$ 37,812,969.10$
F/Y Average Daily Balance 37,315,996.30$ 37,360,770.23$ 37,411,014.55$
Book Rate of Return 2.68%2.29%2.18%
F/Y Book Rate of Return 2.96%2.88%2.80%
JANUARY FEBRUARY MARCH
CD-FDIC 5,535,739.68$ 5,337,920.40$ 5,294,188.53$
Commercial Paper -$ -$ -$
Corporate Bonds 3,444,175.00$ 3,425,250.00$ 3,431,926.97$
LAIF 9,974,525.05$ 9,974,525.05$ 9,974,525.05$
Money Market Funds 499,208.83$ 415,841.57$ 2,121,451.84$
U.S. Agencies 12,271,023.20$ 12,209,722.00$ 10,587,362.74$
U.S. Treasuries 5,350,660.60$ 5,788,090.10$ 5,803,591.42$
TOTAL 37,075,332.36$ 37,151,349.12$ 37,213,046.55$
Market Value - refers to the current price of an asset
Book Value - the original cost of an asset minus accumulated depreciation.
Variance - measure of volatility
Par Value - stated value or face value of a financial instrument.
Net Asset Value - measures the value of a fund's assets, minus its liabilities.
Years to Maturity (YTM) - an estimate of the total rate of return anticipated to be earned by an
investor who buys a bond at a given market price.
Effective Duration - is a duration calculation for bonds that have embedded options. This
measure of duration takes into account the fact that expected cash flows will fluctuate
as interest rates change.
Book Rate of Return - a measure of profitability to be compared to the required return
MARKET VALUE
INVESTMENTS SUMMARY
PORTFOLIO SUMMARY
AT A GLANCE
ACCOUNT SUMMARY
JAN - MARCH 2024
10
2024
Jan - Mar Apr - June July - Sept Oct - Dec
Investments Managed by Main Street $37,213,046.55 $35,892,711.43 36,098,465.71 $36,817,582.81
Demand Deposits/MM//Custody $66,777,008.37 $73,461,151.24 56,101,725.54 $56,945,678.09
Per Treasurer's Reports 103,990,054.92 $109,353,862.67 92,200,191.25 $93,763,260.90
Accounts
Balances per Statement Beginning Credits Debits Ending
US Bank - General Account*32,131,315.39$ 12,898,557.20$ 4,459,592.86$ 40,570,279.73$
*Local Agency Investment Fund 9,875,316.10$ 99,208.95$ -$ 9,974,525.05$
US Bank - RORF - Successor Agency 5,993,945.85$ 569,177.00$ 103,484.00$ 6,459,638.85$
US Bank - Low Mod Housing Trust 4,814,995.60$ -$ 2,237.50$ 4,812,758.10$
TOTAL REVENUE & EXPENDITURE 13,566,943.15$ 4,565,314.36$
Accounts
Balances per Statement Beginning Credits Debits Ending
US Bank - General Account*40,570,279.73$ 9,356,050.88$ 7,206,782.70$ 42,719,547.91$
*Local Agency Investment Fund 9,974,525.05$ -$ -$ 9,974,525.05$
US Bank - RORF - Successor Agency 6,459,638.85$ -$ 6,459,638.85$
US Bank - Low Mod Housing Trust 4,812,758.10$ -$ 1,650.00$ 4,811,108.10$
TOTAL REVENUE & EXPENDITURE 9,356,050.88$ 7,208,432.70$
Accounts
Balances per Statement Beginning Credits Debits Ending
US Bank - General Account 42,719,547.91$ 5,163,572.33$ 5,974,717.54$ 41,908,402.70$
*Local Agency Investment Fund 9,974,525.05$ -$ -$ 9,974,525.05$
US Bank - RORF - Successor Agency 6,459,638.85$ -$ 6,459,638.85$
US Bank - Low Mod Housing Trust 4,811,108.10$ -$ 3,587.50$ 4,807,520.60$
TOTAL REVENUE & EXPENDITURE 5,163,572.33$ 5,978,305.04
QUARTERLY TOTAL OF DEBITS/CREDITS 28,086,566.36$ 17,752,052.10$
*Most Active Accounts
*Funds transferred from LAIF account to the general account to cover expenditures
2023
Jan-24
Feb-24
Mar-24
CITY OF LYNWOOD
QUARTERLY REPORT
March 31, 2024
MONTHLY BALANCES PER STATEMENT
DEMAND DEPOSIT ACCOUNTS - MOST ACTIVE
BALANCES PER QUARTER
11
Run Date: 4/8/2024 - 3:24 PM
Amortizing Page 2
Portfolio Summary
City of Lynwood 3/31/2024
SECTOR ALLOCATION MATURITY DISTRIBUTION CREDIT QUALITY (MOODY'S)
ACCOUNT SUMMARY MONTH-END PORTFOLIO BOOK YIELD TOP ISSUERS
3/31/24 2/29/24 Issuer % Portfolio
Market Value $37,213,047 $37,151,349 LAIF 26.4%
Book Value $37,835,576 $37,768,036 U.S. Treasury 16.1%
Variance -$622,529 -$616,687 FHLB 16.0%
FFCB 7.1%
Par Value $37,938,977 $37,873,367 Goldman Sachs Govt MMF 5.6%
FHLMC 4.0%
Net Asset Value $98.35 $98.37 JPMorgan 1.3%
FNMA 1.3%
Book Yield 3.44%3.32%MetLife 1.3%
Apple 1.3%
Market Yield 4.73%4.66%Unilever Capital Corp 1.3%
3M 1.3%
Years to Maturity 1.56 1.62 Exxon Mobil 0.7%
New York Life 0.7%
Effective Duration 1.36 1.36 Charles Schwab 0.7%
Ap
r
-
2
3
M
a
y
-
2
3
Ju
n
-
2
3
Ju
l
-
2
3
Au
g
-
2
3
Se
p
-
2
3
Oc
t
-
2
3
No
v
-
2
3
De
c
-
2
3
Jan
-
2
4
Fe
b
-
2
4
M
a
r
-
2
4
2.40%
2.60%
2.80%
3.00%
3.20%
3.40%
3.60%
5.6%
9.2%
14.3%
16.1%
26.4%
28.4%
MMF
CORP
CD
TSY
LAIF
AGY
100%75%50%25%0%
46.4%
17.1%
13.1%13.6%
9.8%
0-1Y 1-2Y 2-3Y 3-4Y 4-5Y+
0%
10%
20%
30%
40%
50%
60%
70%
40.7%
1.3%
0.7%
3.3%
1.3%
0.7%
52.1%
NR
A3
A2
A1
Aa3
Aa2
Aa1
Aaa
P-1
100%75%50%25%0%
212
Portfolio Summary
City of Lynwood March 31, 2024
Investments Par Value Book Value
% of
Portfolio YTMMaturity
Days to
Market Value
Book
Certificates of Deposit 5,413,000.00 5,410,095.18 14.30 3.42 1,080 5,294,188.53
Corporate Bonds 3,500,000.00 3,488,397.74 9.22 3.51 659 3,431,926.97
LAIF 9,974,525.05 9,974,525.05 26.36 4.25 1 9,974,525.05
Money Market Funds 2,121,451.84 2,121,451.84 5.61 5.20 1 2,121,451.84
U.S. Agencies 10,800,000.00 10,760,831.80 28.44 3.52 840 10,587,362.74
U.S. Treasuries 6,130,000.00 6,080,274.30 16.07 1.31 712 5,803,591.42
37,835,575.90 100.00 569 37,213,046.55 3.44 37,938,976.89
Investments
March 31 Month Ending Fiscal Year To DateTotal Earnings
Current Year 70,145.68 788,636.75
Average Daily Balance 37,812,969.10 37,411,014.55
Book Rate of Return 2.18% 2.80%
Run Date: 4/8/2024 - 3:25 PM
Amortizing 1513
Holdings Report
City of Lynwood March 31, 2024
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
32100LCB9 248,000.00First Missouri State Bank 09/13/2019 248,000.00 98.36 243,942.99 0.66% NR/NR 0.4509/13/2024
-4,057.01 NR 0.53 238.83 1.85% 248,000.00 5.56%1.850%
27002YFE1 248,000.00EagleBank 08/18/2022 248,000.00 97.72 242,351.08 0.66% NR/NR 1.3808/18/2025
-5,648.92 NR 1.42 313.91 3.30% 248,000.00 5.01%3.300%
05580AXF6 248,000.00BMW Bank 09/25/2020 248,000.00 93.63 232,213.85 0.66% NR/NR 1.4909/25/2025
-15,786.15 NR 1.56 23.78 0.50% 248,000.00 5.01%0.500%
856283S98 248,000.00State Bank of India 04/27/2021 248,000.00 92.47 229,318.56 0.66% NR/NR 2.0704/27/2026
-18,681.44 NR 2.13 1,066.74 1.00% 248,000.00 4.86%1.000%
02007GUP6 248,000.00Ally Bank 07/07/2022 248,000.00 96.88 240,257.33 0.66% NR/NR 2.2707/07/2026
-7,742.67 NR 2.24 1,934.74 3.35% 248,000.00 4.82%3.350%
89235MLC3 248,000.00Toyota Financial Savings Bank 07/15/2021 248,000.00 91.72 227,476.97 0.66% NR/NR 2.2907/15/2026
-20,523.03 NR 2.34 497.02 0.95% 248,000.00 4.81%0.950%
90348JR93 248,000.00UBS Bank USA 08/11/2021 248,000.00 91.45 226,804.86 0.66% NR/NR 2.3608/11/2026
-21,195.14 NR 2.42 135.55 0.95% 248,000.00 4.79%0.950%
15721UFP9 248,000.00CFBank 03/15/2023 248,000.00 100.13 248,321.38 0.66% NR/NR 2.4609/15/2026
321.38 NR 2.32 548.66 4.75% 248,000.00 4.69%4.750%
32117BFR4 248,000.00First National Bank 03/23/2023 248,000.00 100.74 249,825.06 0.66% NR/NR 2.4809/23/2026
1,825.06 NR 2.33 305.75 5.00% 248,000.00 4.68%5.000%
910286GM9 248,000.00United Fidelity Bank FSB 06/29/2023 247,546.16 100.10 248,244.96 0.65% NR/NR 3.2506/29/2027
613.07 NR 3.04 92.75 4.60% 247,631.90 4.52%4.550%
254673L38 248,000.00Discover Bank 07/07/2022 248,000.00 96.52 239,357.81 0.66% NR/NR 3.2707/06/2027
-8,642.19 NR 3.13 1,986.72 3.40% 248,000.00 4.56%3.400%
14042RST9 248,000.00Capital One Bank NA 07/07/2022 248,000.00 96.67 239,730.81 0.66% NR/NR 3.2707/07/2027
-8,269.19 NR 3.13 1,992.49 3.45% 248,000.00 4.56%3.450%
14042TJD0 248,000.00Capital One Bank USA 08/03/2022 248,000.00 97.04 240,647.92 0.66% NR/NR 3.3408/03/2027
-7,352.08 NR 3.19 1,398.99 3.55% 248,000.00 4.51%3.550%
61768ELH4 248,000.00Morgan Stanley Private Bank 08/04/2022 248,000.00 96.82 240,106.76 0.66% NR/NR 3.3508/04/2027
-7,893.24 NR 3.20 1,355.51 3.50% 248,000.00 4.53%3.500%
87164XN93 248,000.00Synchrony Bank 08/05/2022 248,000.00 96.81 240,082.43 0.66% NR/NR 3.3508/05/2027
-7,917.57 NR 3.20 1,331.73 3.50% 248,000.00 4.51%3.500%
02589ADQ2 205,000.00American Express National Bank 08/12/2022 203,975.00 96.65 198,138.72 0.54% NR/NR 3.3608/10/2027
-6,171.77 NR 3.22 988.21 3.56% 204,310.49 4.51%3.450%
32114VCH8 248,000.00First National Bank of Michigan 03/15/2023 248,000.00 100.99 250,464.84 0.66% NR/NR 3.9603/15/2028
2,464.84 NR 3.58 531.33 4.60% 248,000.00 4.33%4.600%
61690U3C2 248,000.00Morgan Stanley Bank 03/16/2023 247,454.40 101.68 252,156.06 0.65% NR/NR 3.9603/16/2028
4,587.88 NR 3.56 521.82 4.85% 247,568.18 4.33%4.800%
062119BK7 248,000.00Bank Five Nine 03/20/2023 248,000.00 101.18 250,938.77 0.66% NR/NR 3.9703/20/2028
2,938.77 NR 3.59 379.13 4.65% 248,000.00 4.32%4.650%
Run Date: 4/8/2024 - 3:25 PM
Amortizing 1614
Holdings Report
City of Lynwood March 31, 2024
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
12547CBJ6 248,000.00CIBC Bank USA 05/17/2023 247,446.96 100.09 248,213.10 0.65% NR/NR 4.1305/16/2028
669.53 NR 3.77 4,049.19 4.40% 247,543.58 4.33%4.350%
05600XQE3 248,000.00BMO Harris Bank NA 05/17/2023 247,449.44 100.65 249,617.88 0.65% NR/NR 4.1305/16/2028
2,072.25 NR 3.75 4,188.82 4.55% 247,545.62 4.32%4.500%
949764HK3 248,000.00Wells Fargo Bank NA 11/07/2023 247,451.92 103.22 255,976.39 0.65% NR/NR 4.6111/07/2028
8,480.97 NR 4.07 857.81 5.10% 247,495.42 4.28%5.050%
5,409,323.88 5,294,188.53 14.30% 2.96
5,410,095.18 3.42% 5,413,000.00 4.63% 24,739.48 -115,906.65 2.80Total Certificates of Deposit
Corporate Bonds
46625HJX9 500,000.00JPMorgan Chase & Co 05/13/2019 515,115.00 99.76 498,785.00 1.32% A1/A- 0.1205/13/2024
-1,567.68 AA- 0.19 6,947.92 2.97% 500,352.68 5.51%3.625%
64952WDL4 250,000.00New York Life 01/22/2020 249,102.50 97.32 243,302.50 0.66% Aaa/AA+ 0.8101/22/2025
-6,552.40 AAA 0.86 958.33 2.08% 249,854.90 5.43%2.000%
88579YBH3 500,000.003M 09/07/2022 476,510.00 96.93 484,650.00 1.30% A3/BBB+ 0.8802/14/2025
-6,966.45 A- 0.92 1,305.56 4.04% 491,616.45 5.67%2.000%
30231GBH4 250,000.00Exxon Mobil 06/22/2020 272,752.50 97.94 244,850.00 0.67% Aa2/AA- 0.9703/19/2025
-9,788.47 NR 0.99 249.33 0.99% 254,638.47 5.20%2.992%02/19/2025
59217GFC8 500,000.00MetLife 08/25/2022 499,380.00 98.34 491,700.00 1.32% Aa3/AA- 1.4008/25/2025
-8,010.67 AA- 1.41 2,025.00 4.09% 499,710.67 5.29%4.050%
037833BY5 500,000.00Apple 08/25/2022 496,085.00 97.20 485,996.97 1.32% Aaa/AA+ 1.9002/23/2026
-11,880.59 NR 1.83 1,715.28 3.49% 497,877.56 4.85%3.250%
808513BW4 250,000.00Charles Schwab 04/12/2022 249,407.50 95.16 237,900.00 0.66% A2/A- 3.0004/01/2027
-11,742.31 A 2.78 4,125.00 3.35% 249,642.31 5.06%3.300%
023135CF1 250,000.00Amazon 06/09/2022 248,005.00 95.88 239,692.50 0.66% A1/AA 3.0404/13/2027
-9,058.34 AA- 2.85 3,850.00 3.48% 248,750.84 4.78%3.300%
904764BS5 500,000.00Unilever Capital Corp 09/22/2023 495,475.00 101.01 505,050.00 1.31% A1/A+ 4.4409/08/2028
9,096.15 A 3.88 1,557.29 5.08% 495,953.85 4.62%4.875%
3,501,832.50 3,431,926.97 9.22% 1.80
3,488,397.74 3.51% 3,500,000.00 5.17% 22,733.71 -56,470.76 1.71Total Corporate Bonds
LAIF
9819499 9,974,525.05LAIF 01/12/2024 9,974,525.05 1.00 9,974,525.05 26.36% NR/NR 0.0004/01/2024
0.00 NR 0.00 0.00 4.25% 9,974,525.05 4.25%4.250%
Run Date: 4/8/2024 - 3:25 PM
Amortizing 1715
Holdings Report
City of Lynwood March 31, 2024
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
9,974,525.05 9,974,525.05 26.36% 0.00
9,974,525.05 4.25% 9,974,525.05 4.25% 0.00 0.00 0.00Total LAIF
Money Market Funds
FGTXX 2,121,451.84Goldman Sachs Govt MMF 2,121,451.84 1.00 2,121,451.84 5.61% Aaa/AAA 0.0004/01/2024
0.00 NR 0.00 7,641.12 5.20% 2,121,451.84 5.20%5.204%
2,121,451.84 2,121,451.84 5.61% 0.00
2,121,451.84 5.20% 2,121,451.84 5.20% 7,641.12 0.00 0.00Total Money Market Funds
U.S. Agencies
3133EKTV8 500,000.00FFCB 07/02/2019 499,900.00 99.16 495,795.00 1.32% Aaa/AA+ 0.2507/01/2024
-4,200.00 AA+ 0.32 2,375.00 1.90% 499,995.00 5.23%1.900%
3133ENG20 1,000,000.00FFCB 08/18/2022 998,300.00 99.19 991,890.00 2.64% Aaa/AA+ 0.3808/15/2024
-7,792.29 AA+ 0.44 4,216.67 3.39% 999,682.29 5.46%3.300%
3133EK3B0 200,000.00FFCB 10/17/2019 198,370.00 98.02 196,042.00 0.53% Aaa/AA+ 0.5510/16/2024
-3,781.32 AA+ 0.61 1,375.00 1.67% 199,823.32 5.25%1.500%
3130A4CH3 500,000.00FHLB 10/07/2020 541,330.00 97.45 487,260.00 1.34% Aaa/AA+ 0.9503/14/2025
-21,616.76 AA+ 0.99 560.76 0.49% 508,876.76 5.15%2.375%
3136G4H71 500,000.00FNMA 08/18/2020 500,000.00 94.15 470,737.74 1.32% Aaa/AA+ 1.3708/12/2025
-29,262.26 AA+ 1.42 298.61 0.50% 500,000.00 4.99%0.500%02/18/2022
3130ASYR4 2,000,000.00FHLB 08/30/2022 2,000,000.00 98.70 1,974,080.00 5.29% Aaa/AA+ 1.4108/28/2025
-25,920.00 AA+ 1.29 7,333.33 4.00% 2,000,000.00 4.96%4.000%05/28/2024
3137EAEX3 500,000.00FHLMC 10/20/2020 497,505.00 93.66 468,295.00 1.32% Aaa/AA+ 1.4809/23/2025
-30,956.36 AA+ 1.52 41.67 0.48% 499,251.36 4.87%0.375%
3130AXU63 1,000,000.00FHLB 11/17/2023 998,230.00 100.33 1,003,280.00 2.64% Aaa/AA+ 2.6311/17/2026
4,830.39 AA+ 2.49 17,215.28 4.69% 998,449.61 4.49%4.625%
3130AQEC3 500,000.00FHLB 12/30/2021 500,000.00 91.22 456,095.00 1.32% Aaa/AA+ 2.7512/30/2026
-43,905.00 AA+ 2.70 1,731.53 1.37% 500,000.00 4.82%1.370%06/30/2024
3130AL5A8 500,000.00FHLB 02/09/2023 438,340.00 90.14 450,680.00 1.20% Aaa/AA+ 2.9102/26/2027
-5,095.77 AA+ 2.88 437.50 4.25% 455,775.77 4.57%0.900%05/26/2024
3130ARTT8 600,000.00FHLB 05/19/2022 600,000.00 98.14 588,858.00 1.59% Aaa/AA+ 3.1305/19/2027
-11,142.00 AA+ 1.90 7,700.00 3.50% 600,000.00 4.14%3.500%05/19/2024
3130AT2L0 1,000,000.00FHLB 08/30/2022 1,000,000.00 97.70 977,000.00 2.64% Aaa/AA+ 3.4008/25/2027
-23,000.00 AA+ 2.32 4,050.00 4.05% 1,000,000.00 4.79%4.050%05/25/2024
3134GYUE0 1,000,000.00FHLMC 06/30/2023 1,000,000.00 99.81 998,060.00 2.64% Aaa/AA+ 4.2506/28/2028
-1,940.00 AA+ 0.61 15,500.00 6.00% 1,000,000.00 6.05%6.000%04/28/2024
Run Date: 4/8/2024 - 3:25 PM
Amortizing 1816
Holdings Report
City of Lynwood March 31, 2024
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
3133EPZN8 1,000,000.00FFCB 10/24/2023 998,880.00 102.93 1,029,290.00 2.64% Aaa/AA+ 4.5710/24/2028
30,312.31 AA+ 4.02 21,805.56 5.03% 998,977.69 4.29%5.000%
10,770,855.00 10,587,362.74 28.44% 2.30
10,760,831.80 3.52% 10,800,000.00 4.94% 84,640.91 -173,469.06 1.72Total U.S. Agencies
U.S. Treasuries
91282CBV2 500,000.00U.S. Treasury 11/22/2021 496,308.59 99.79 498,964.85 1.32% Aaa/AA+ 0.0404/15/2024
-971.87 AA+ 0.12 865.78 0.69% 499,936.72 5.43%0.375%
912828YV6 1,000,000.00U.S. Treasury 07/22/2021 1,035,742.19 97.57 975,703.13 2.66% Aaa/AA+ 0.6711/30/2024
-31,404.53 AA+ 0.73 5,040.98 0.43% 1,007,107.66 5.25%1.500%
912828ZT0 500,000.00U.S. Treasury 06/29/2021 491,542.97 94.69 473,437.50 1.31% Aaa/AA+ 1.1705/31/2025
-24,046.65 AA+ 1.22 420.08 0.69% 497,484.15 4.99%0.250%
91282CAZ4 1,000,000.00U.S. Treasury 07/22/2021 989,492.19 93.03 930,273.44 2.63% Aaa/AA+ 1.6711/30/2025
-65,706.93 AA+ 1.70 1,260.25 0.62% 995,980.37 4.78%0.375%
91282CBH3 500,000.00U.S. Treasury 02/25/2021 494,433.59 92.45 462,265.63 1.32% Aaa/AA+ 1.8401/31/2026
-35,660.49 AA+ 1.87 314.22 0.60% 497,926.12 4.72%0.375%
91282CCF6 1,000,000.00U.S. Treasury 07/22/2021 1,002,382.81 92.11 921,093.75 2.65% Aaa/AA+ 2.1705/31/2026
-79,968.71 AA+ 2.17 2,520.49 0.70% 1,001,062.46 4.62%0.750%
91282CCZ2 500,000.00U.S. Treasury 10/19/2021 492,949.22 91.49 457,460.94 1.31% Aaa/AA+ 2.5009/30/2026
-38,976.60 AA+ 2.48 11.95 1.17% 496,437.54 4.51%0.875%
91282CGC9 630,000.00U.S. Treasury 03/03/2023 616,587.89 98.39 619,860.94 1.64% Aaa/AA+ 3.7512/31/2027
277.37 AA+ 3.49 6,170.19 4.37% 619,583.57 4.34%3.875%
9128286B1 500,000.00U.S. Treasury 02/21/2024 463,984.38 92.91 464,531.25 1.23% Aaa/AA+ 4.8802/15/2029
-224.47 AA+ 4.55 1,658.65 4.24% 464,755.72 4.25%2.625%
6,083,423.83 5,803,591.42 16.07% 1.95
6,080,274.30 1.31% 6,130,000.00 4.79% 18,262.59 -276,682.88 1.92Total U.S. Treasuries
37,861,412.10 37,213,046.55 100.00% 1.56
158,017.81 -622,529.35 1.36 4.73% 37,835,575.90 3.44% 37,938,976.89TOTAL PORTFOLIO
TOTAL MARKET VALUE PLUS ACCRUED INTEREST 37,371,064.36
Run Date: 4/8/2024 - 3:25 PM
Amortizing 1917
Maturity Report
City of Lynwood March 31, 2024
CUSIP Date
Purchase
Value
Book
Rate
Coupon
Date
Maturity
Par
Remaining
Term Value
Market
YTMIssuer
Days to
Maturity
Book
FGTXX 5.204% 1Goldman Sachs Govt MMF 2,121,451.84 04/01/2024 1 5.20% 2,121,451.84 2,121,451.84
9819499 4.250% 1LAIF05/18/2020 9,974,525.05 04/01/2024 1 4.25% 9,974,525.05 9,974,525.05
91282CBV2 0.375% 860U.S. Treasury 11/22/2021 499,936.72 04/15/2024 15 0.69% 500,000.00 498,964.85
46625HJX9 3.625% 1,784JPMorgan Chase & Co 05/13/2019 500,352.68 05/13/2024 43 2.97% 500,000.00 498,785.00
3133EKTV8 1.900% 1,734FFCB07/02/2019 499,995.00 07/01/2024 92 1.90% 500,000.00 495,795.00
3133ENG20 3.300% 591FFCB08/18/2022 999,682.29 08/15/2024 137 3.39% 1,000,000.00 991,890.00
32100LCB9 1.850% 1,661First Missouri State Bank 09/13/2019 248,000.00 09/13/2024 166 1.85% 248,000.00 243,942.99
3133EK3B0 1.500% 1,627FFCB10/17/2019 199,823.32 10/16/2024 199 1.67% 200,000.00 196,042.00
912828YV6 1.500% 983U.S. Treasury 07/22/2021 1,007,107.66 11/30/2024 244 0.43% 1,000,000.00 975,703.13
64952WDL4 2.000% 1,530New York Life 01/22/2020 249,854.90 01/22/2025 297 2.08% 250,000.00 243,302.50
88579YBH3 2.000% 5713M09/07/2022 491,616.45 02/14/2025 320 4.04% 500,000.00 484,650.00
3130A4CH3 2.375% 1,271FHLB10/07/2020 508,876.76 03/14/2025 348 0.49% 500,000.00 487,260.00
30231GBH4 2.992% 1,378Exxon Mobil 06/22/2020 254,638.47 03/19/2025 353 0.99% 250,000.00 244,850.00
912828ZT0 0.250% 1,006U.S. Treasury 06/29/2021 497,484.15 05/31/2025 426 0.69% 500,000.00 473,437.50
3136G4H71 0.500% 1,321FNMA08/18/2020 500,000.00 08/12/2025 499 0.50% 500,000.00 470,737.74
27002YFE1 3.300% 591EagleBank08/18/2022 248,000.00 08/18/2025 505 3.30% 248,000.00 242,351.08
59217GFC8 4.050% 584MetLife08/25/2022 499,710.67 08/25/2025 512 4.09% 500,000.00 491,700.00
3130ASYR4 4.000% 579FHLB08/30/2022 2,000,000.00 08/28/2025 515 4.00% 2,000,000.00 1,974,080.00
3137EAEX3 0.375% 1,258FHLMC10/20/2020 499,251.36 09/23/2025 541 0.48% 500,000.00 468,295.00
05580AXF6 0.500% 1,283BMW Bank 09/25/2020 248,000.00 09/25/2025 543 0.50% 248,000.00 232,213.85
91282CAZ4 0.375% 983U.S. Treasury 07/22/2021 995,980.37 11/30/2025 609 0.62% 1,000,000.00 930,273.44
91282CBH3 0.375% 1,130U.S. Treasury 02/25/2021 497,926.12 01/31/2026 671 0.60% 500,000.00 462,265.63
037833BY5 3.250% 584Apple08/25/2022 497,877.56 02/23/2026 694 3.49% 500,000.00 485,996.97
856283S98 1.000% 1,069State Bank of India 04/27/2021 248,000.00 04/27/2026 757 1.00% 248,000.00 229,318.56
91282CCF6 0.750% 983U.S. Treasury 07/22/2021 1,001,062.46 05/31/2026 791 0.70% 1,000,000.00 921,093.75
02007GUP6 3.350% 633Ally Bank 07/07/2022 248,000.00 07/07/2026 828 3.35% 248,000.00 240,257.33
89235MLC3 0.950% 990Toyota Financial Savings Bank 07/15/2021 248,000.00 07/15/2026 836 0.95% 248,000.00 227,476.97
90348JR93 0.950% 963UBS Bank USA 08/11/2021 248,000.00 08/11/2026 863 0.95% 248,000.00 226,804.86
15721UFP9 4.750% 382CFBank03/15/2023 248,000.00 09/15/2026 898 4.75% 248,000.00 248,321.38
32117BFR4 5.000% 374First National Bank 03/23/2023 248,000.00 09/23/2026 906 5.00% 248,000.00 249,825.06
91282CCZ2 0.875% 894U.S. Treasury 10/19/2021 496,437.54 09/30/2026 913 1.17% 500,000.00 457,460.94
3130AXU63 4.625% 135FHLB11/17/2023 998,449.61 11/17/2026 961 4.69% 1,000,000.00 1,003,280.00
3130AQEC3 1.370% 822FHLB12/30/2021 500,000.00 12/30/2026 1,004 1.37% 500,000.00 456,095.00
3130AL5A8 0.900% 416FHLB02/09/2023 455,775.77 02/26/2027 1,062 4.25% 500,000.00 450,680.00
808513BW4 3.300% 719Charles Schwab 04/12/2022 249,642.31 04/01/2027 1,096 3.35% 250,000.00 237,900.00
023135CF1 3.300% 661Amazon06/09/2022 248,750.84 04/13/2027 1,108 3.48% 250,000.00 239,692.50
Run Date: 4/8/2024 - 3:25 PM
Amortizing 2018
Maturity Report
City of Lynwood March 31, 2024
CUSIP Date
Purchase
Value
Book
Rate
Coupon
Date
Maturity
Par
Remaining
Term Value
Market
YTMIssuer
Days to
Maturity
Book
3130ARTT8 3.500% 682FHLB05/19/2022 600,000.00 05/19/2027 1,144 3.50% 600,000.00 588,858.00
910286GM9 4.550% 276United Fidelity Bank FSB 06/29/2023 247,631.90 06/29/2027 1,185 4.60% 248,000.00 248,244.96
254673L38 3.400% 633Discover Bank 07/07/2022 248,000.00 07/06/2027 1,192 3.40% 248,000.00 239,357.81
14042RST9 3.450% 633Capital One Bank NA 07/07/2022 248,000.00 07/07/2027 1,193 3.45% 248,000.00 239,730.81
14042TJD0 3.550% 606Capital One Bank USA 08/03/2022 248,000.00 08/03/2027 1,220 3.55% 248,000.00 240,647.92
61768ELH4 3.500% 605Morgan Stanley Private Bank 08/04/2022 248,000.00 08/04/2027 1,221 3.50% 248,000.00 240,106.76
87164XN93 3.500% 604Synchrony Bank 08/05/2022 248,000.00 08/05/2027 1,222 3.50% 248,000.00 240,082.43
02589ADQ2 3.450% 597American Express National Bank 08/12/2022 204,310.49 08/10/2027 1,227 3.56% 205,000.00 198,138.72
3130AT2L0 4.050% 579FHLB08/30/2022 1,000,000.00 08/25/2027 1,242 4.05% 1,000,000.00 977,000.00
91282CGC9 3.875% 394U.S. Treasury 03/03/2023 619,583.57 12/31/2027 1,370 4.37% 630,000.00 619,860.94
32114VCH8 4.600% 382First National Bank of Michigan 03/15/2023 248,000.00 03/15/2028 1,445 4.60% 248,000.00 250,464.84
61690U3C2 4.800% 381Morgan Stanley Bank 03/16/2023 247,568.18 03/16/2028 1,446 4.85% 248,000.00 252,156.06
062119BK7 4.650% 377Bank Five Nine 03/20/2023 248,000.00 03/20/2028 1,450 4.65% 248,000.00 250,938.77
12547CBJ6 4.350% 319CIBC Bank USA 05/17/2023 247,543.58 05/16/2028 1,507 4.40% 248,000.00 248,213.10
05600XQE3 4.500% 319BMO Harris Bank NA 05/17/2023 247,545.62 05/16/2028 1,507 4.55% 248,000.00 249,617.88
3134GYUE0 6.000% 275FHLMC06/30/2023 1,000,000.00 06/28/2028 1,550 6.00% 1,000,000.00 998,060.00
904764BS5 4.875% 191Unilever Capital Corp 09/22/2023 495,953.85 09/08/2028 1,622 5.08% 500,000.00 505,050.00
3133EPZN8 5.000% 159FFCB10/24/2023 998,977.69 10/24/2028 1,668 5.03% 1,000,000.00 1,029,290.00
949764HK3 5.050% 145Wells Fargo Bank NA 11/07/2023 247,495.42 11/07/2028 1,682 5.10% 248,000.00 255,976.39
9128286B1 2.625% 39U.S. Treasury 02/21/2024 464,755.72 02/15/2029 1,782 4.24% 500,000.00 464,531.25
Net Maturities and Averages 37,835,575.90 569 3.44% 37,213,046.55 37,938,976.89
Run Date: 4/8/2024 - 3:25 PM
Amortizing 2119
Income Earned Summary
City of Lynwood March 31, 2024
Fiscal Year To DateMarch 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
65,610.27 852,306.98
158,017.81 158,017.81
-155,412.35 -245,539.44
68,215.73 764,785.35
1,929.95 23,851.40
0.00 0.00
70,145.68 788,636.75
Run Date: 4/8/2024 - 3:25 PM
Amortizing 2420
Income Earned
City of Lynwood March 01, 2024 - March 31, 2024
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
32100LCB9 09/13/2024 248,000.00First Missouri State Bank 248,000.00 248,000.00 2,136.88 2,287.71 238.83 389.66 0.00 389.66
27002YFE1 08/18/2025 248,000.00EagleBank 248,000.00 248,000.00 269.06 650.24 313.91 695.09 0.00 695.09
05580AXF6 09/25/2025 248,000.00BMW Bank 248,000.00 248,000.00 536.77 618.30 23.78 105.31 0.00 105.31
856283S98 04/27/2026 248,000.00State Bank of India 248,000.00 248,000.00 856.11 0.00 1,066.74 210.63 0.00 210.63
02007GUP6 07/07/2026 248,000.00Ally Bank 248,000.00 248,000.00 1,229.13 0.00 1,934.74 705.61 0.00 705.61
89235MLC3 07/15/2026 248,000.00Toyota Financial Savings Bank 248,000.00 248,000.00 296.92 0.00 497.02 200.10 0.00 200.10
90348JR93 08/11/2026 248,000.00UBS Bank USA 248,000.00 248,000.00 122.64 187.19 135.55 200.10 0.00 200.10
15721UFP9 09/15/2026 248,000.00CFBank 248,000.00 248,000.00 484.11 935.95 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 237.81 985.21 305.75 1,053.15 0.00 1,053.15
910286GM9 06/29/2027 248,000.00United Fidelity Bank FSB 247,622.27 247,631.90 30.92 0.00 92.75 61.83 9.63 71.46
254673L38 07/06/2027 248,000.00Discover Bank 248,000.00 248,000.00 1,270.58 0.00 1,986.72 716.14 0.00 716.14
14042RST9 07/07/2027 248,000.00Capital One Bank NA 248,000.00 248,000.00 1,265.82 0.00 1,992.49 726.67 0.00 726.67
14042TJD0 08/03/2027 248,000.00Capital One Bank USA 248,000.00 248,000.00 651.25 0.00 1,398.99 747.74 0.00 747.74
61768ELH4 08/04/2027 248,000.00Morgan Stanley Private Bank 248,000.00 248,000.00 618.30 0.00 1,355.51 737.21 0.00 737.21
87164XN93 08/05/2027 248,000.00Synchrony Bank 248,000.00 248,000.00 594.52 0.00 1,331.73 737.21 0.00 737.21
02589ADQ2 08/10/2027 205,000.00American Express National Bank 204,293.06 204,310.49 387.53 0.00 988.21 600.68 17.42 618.10
32114VCH8 03/15/2028 248,000.00First National Bank of Michigan 248,000.00 248,000.00 468.82 906.39 531.33 968.90 0.00 968.90
61690U3C2 03/16/2028 248,000.00Morgan Stanley Bank 247,558.92 247,568.18 5,446.49 5,935.69 521.82 1,011.02 9.26 1,020.28
062119BK7 03/20/2028 248,000.00Bank Five Nine 248,000.00 248,000.00 315.95 916.24 379.13 979.42 0.00 979.42
05600XQE3 05/16/2028 248,000.00BMO Harris Bank NA 247,536.28 247,545.62 3,240.99 0.00 4,188.82 947.83 9.35 957.18
12547CBJ6 05/16/2028 248,000.00CIBC Bank USA 247,534.19 247,543.58 3,132.95 0.00 4,049.19 916.24 9.39 925.63
949764HK3 11/07/2028 248,000.00Wells Fargo Bank NA 247,486.12 247,495.42 789.18 995.06 857.81 1,063.69 9.30 1,072.99
Certificates of Deposit - Sub Total 5,413,000.00 5,410,030.83 5,410,095.18 24,382.73 14,417.98 24,739.48 14,774.73 64.34 14,839.07
Corporate Bonds
46625HJX9 05/13/2024 500,000.00JPMorgan Chase & Co 500,621.39 500,352.68 5,437.50 0.00 6,947.92 1,510.42 -268.71 1,241.71
64952WDL4 01/22/2025 250,000.00New York Life 249,838.95 249,854.90 541.67 0.00 958.33 416.66 15.96 432.62
88579YBH3 02/14/2025 500,000.003M 490,759.35 491,616.45 472.22 0.00 1,305.56 833.34 857.10 1,690.44
30231GBH4 03/19/2025 250,000.00Exxon Mobil 255,065.00 254,638.47 3,366.00 3,740.00 249.33 623.33 -426.53 196.80
59217GFC8 08/25/2025 500,000.00MetLife 499,692.30 499,710.67 337.50 0.00 2,025.00 1,687.50 18.37 1,705.87
037833BY5 02/23/2026 500,000.00Apple 497,777.97 497,877.56 361.11 0.00 1,715.28 1,354.17 99.59 1,453.76
808513BW4 04/01/2027 250,000.00Charles Schwab 249,631.72 249,642.31 3,437.50 0.00 4,125.00 687.50 10.60 698.10
023135CF1 04/13/2027 250,000.00Amazon 248,714.23 248,750.84 3,162.50 0.00 3,850.00 687.50 36.61 724.11
904764BS5 09/08/2028 500,000.00Unilever Capital Corp 495,872.77 495,953.85 11,713.54 12,187.50 1,557.29 2,031.25 81.08 2,112.33
Run Date: 4/8/2024 - 3:26 PM
Amortizing 2521
Income Earned
City of Lynwood March 01, 2024 - March 31, 2024
CUSIP Value
Ending Par
Date
Maturity
Book Value
Beginning
Value
Ending Book
Accrued
Beginning
/Purchased
Int.Received
Accrued
Ending
Issuer Earned
Interest Amortization/
Accretion Earned
Net Income
Corporate Bonds - Sub Total 3,500,000.00 3,487,973.68 3,488,397.74 28,829.54 15,927.50 22,733.71 9,831.67 424.06 10,255.73
LAIF
9819499 04/01/2024 9,974,525.05LAIF 9,974,525.05 9,974,525.05 0.00 0.00 0.00 0.00 0.00 0.00
LAIF - Sub Total 9,974,525.05 9,974,525.05 9,974,525.05 0.00 0.00 0.00 0.00 0.00 0.00
Money Market Funds
FGTXX 04/01/2024 2,121,451.84Goldman Sachs Govt MMF 415,841.57 2,121,451.84 1,739.79 1,739.79 7,641.12 7,641.12 0.00 7,641.12
Money Market Funds - Sub Total 2,121,451.84 415,841.57 2,121,451.84 1,739.79 1,739.79 7,641.12 7,641.12 0.00 7,641.12
U.S. Agencies
3130A0XE5 03/08/2024 0.00FHLB 1,639,947.97 0.00 25,613.61 26,650.00 0.00 1,036.39 52.03 1,088.42
3133EKTV8 07/01/2024 500,000.00FFCB 499,993.22 499,995.00 1,583.33 0.00 2,375.00 791.67 1.78 793.45
3133ENG20 08/15/2024 1,000,000.00FFCB 999,606.42 999,682.29 1,466.67 0.00 4,216.67 2,750.00 75.87 2,825.87
3133EK3B0 10/16/2024 200,000.00FFCB 199,794.32 199,823.32 1,125.00 0.00 1,375.00 250.00 28.99 278.99
3130A4CH3 03/14/2025 500,000.00FHLB 509,704.92 508,876.76 5,508.68 5,937.50 560.76 989.58 -828.15 161.43
3136G4H71 08/12/2025 500,000.00FNMA 500,000.00 500,000.00 90.28 0.00 298.61 208.33 0.00 208.33
3130ASYR4 08/28/2025 2,000,000.00FHLB 2,000,000.00 2,000,000.00 666.67 0.00 7,333.33 6,666.66 0.00 6,666.66
3137EAEX3 09/23/2025 500,000.00FHLMC 499,206.33 499,251.36 822.92 937.50 41.67 156.25 45.03 201.28
3130AXU63 11/17/2026 1,000,000.00FHLB 998,397.17 998,449.61 13,361.11 0.00 17,215.28 3,854.17 52.44 3,906.61
3130AQEC3 12/30/2026 500,000.00FHLB 500,000.00 500,000.00 1,160.69 0.00 1,731.53 570.84 0.00 570.84
3130AL5A8 02/26/2027 500,000.00FHLB 454,421.54 455,775.77 62.50 0.00 437.50 375.00 1,354.23 1,729.23
3130ARTT8 05/19/2027 600,000.00FHLB 600,000.00 600,000.00 5,950.00 0.00 7,700.00 1,750.00 0.00 1,750.00
3130AT2L0 08/25/2027 1,000,000.00FHLB 1,000,000.00 1,000,000.00 675.00 0.00 4,050.00 3,375.00 0.00 3,375.00
3134GYUE0 06/28/2028 1,000,000.00FHLMC 1,000,000.00 1,000,000.00 10,500.00 0.00 15,500.00 5,000.00 0.00 5,000.00
3133EPZN8 10/24/2028 1,000,000.00FFCB 998,957.78 998,977.69 17,638.89 0.00 21,805.56 4,166.67 19.91 4,186.58
U.S. Agencies - Sub Total 10,800,000.00 12,400,029.65 10,760,831.80 86,225.35 33,525.00 84,640.91 31,940.56 802.14 32,742.70
U.S. Treasuries
91282CBV2 04/15/2024 500,000.00U.S. Treasury 499,805.94 499,936.72 706.97 0.00 865.78 158.81 130.78 289.59
912828YV6 11/30/2024 1,000,000.00U.S. Treasury 1,008,010.68 1,007,107.66 3,770.49 0.00 5,040.98 1,270.49 -903.02 367.47
912828ZT0 05/31/2025 500,000.00U.S. Treasury 497,301.07 497,484.15 314.21 0.00 420.08 105.87 183.08 288.95
91282CAZ4 11/30/2025 1,000,000.00U.S. Treasury 995,775.75 995,980.37 942.62 0.00 1,260.25 317.63 204.61 522.24
91282CBH3 01/31/2026 500,000.00U.S. Treasury 497,830.31 497,926.12 154.53 0.00 314.22 159.69 95.81 255.50
91282CCF6 05/31/2026 1,000,000.00U.S. Treasury 1,001,104.10 1,001,062.46 1,885.25 0.00 2,520.49 635.24 -41.64 593.60
Run Date: 4/8/2024 - 3:26 PM
Amortizing 2622
Income Earned
City of Lynwood March 01, 2024 - March 31, 2024
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
91282CCZ2 09/30/2026 500,000.00U.S. Treasury 496,316.58 496,437.54 1,828.89 0.00 11.95 -1,816.94 120.96 -1,695.98
91282CGC9 12/31/2027 630,000.00U.S. Treasury 619,347.87 619,583.57 4,091.11 0.00 6,170.19 2,079.08 235.70 2,314.78
9128286B1 02/15/2029 500,000.00U.S. Treasury 464,142.60 464,755.72 540.87 0.00 1,658.65 1,117.78 613.12 1,730.90
U.S. Treasuries - Sub Total 6,130,000.00 6,079,634.90 6,080,274.30 14,234.94 0.00 18,262.59 4,027.65 639.40 4,667.05
37,938,976.89Grand Total 37,768,035.69 37,835,575.90 155,412.35 65,610.27 158,017.81 68,215.73 1,929.95 70,145.68
Run Date: 4/8/2024 - 3:26 PM
Amortizing 2723
Realized Gains and Losses
City of Lynwood March 01, 2024 - March 31, 2024
Par Value Sale Date Days Held Maturity/Sales RealizedCUSIP
Coupon Rate Maturity Date Book Value Proceeds Gain/LossPurchase Date TermIssuer
U.S. Agencies
3130A0XE5 1,640,000.0008/22/2022 03/08/2024 564 1,640,000.00 0.00 1,640,000.00
03/08/2024 564FHLB 3.250%
Total U.S. Agencies 0.00 1,640,000.00 1,640,000.00
Grand Total 0.00 1,640,000.00 1,640,000.00
Run Date: 4/8/2024 - 3:26 PM
Amortizing 2824
Transaction Report
City of Lynwood March 01, 2024 - March 31, 2024
Transaction Transaction Security Security Maturity
Date Type ID Description Date Purchases Redemptions Interest Deposits Withdrawals
03/04/2024 Interest FGTXX GSGF - - 1,739.79 - -
03/07/2024 Interest 949764HK3 WFC 5.05 11/07/28 11/07/2028 - - 995.06 - -
03/08/2024 Interest 904764BS5 UNANA 4 7/8 09/08/28 09/08/2028 - - 12,187.50 - -
03/08/2024 Maturity 3130A0XE5 FHLB 3 1/4 03/08/24 03/08/2024 - 1,640,000.00 - - -
03/08/2024 Interest 3130A0XE5 FHLB 3 1/4 03/08/24 03/08/2024 - - 26,650.00 - -
03/11/2024 Interest 90348JR93 UBS 0.95 08/11/26 08/11/2026 - - 187.19 - -
03/13/2024 Interest 32100LCB9 FMOSTB 1.85 09/13/24 09/13/2024 - - 2,287.71 - -
03/14/2024 Interest 3130A4CH3 FHLB 2 3/8 03/14/25 03/14/2025 - - 5,937.50 - -
03/15/2024 Interest 32114VCH8 FNBMIC 4.6 03/15/28 03/15/2028 - - 906.39 - -
03/15/2024 Interest 15721UFP9 CFBK 4 3/4 09/15/26 09/15/2026 - - 935.95 - -
03/18/2024 Interest 61690U3C2 MS 4.8 03/16/28 03/16/2028 - - 5,935.69 - -
03/18/2024 Interest 27002YFE1 EGBN 3.3 08/18/25 08/18/2025 - - 650.24 - -
03/19/2024 Interest 30231GBH4 XOM 2.992 03/19/25 03/19/2025 - - 3,740.00 - -
03/20/2024 Interest 062119BK7 FBFCEN 4.65 03/20/28 03/20/2028 - - 916.24 - -
03/25/2024 Interest 32117BFR4 FNLC 5 09/23/26 09/23/2026 - - 985.21 - -
03/25/2024 Interest 05580AXF6 BMW 0 1/2 09/25/25 09/25/2025 - - 618.30 - -
03/25/2024 Interest 3137EAEX3 FHLMC 0 3/8 09/23/25 09/23/2025 - - 937.50 - -
Grand Total: 0.00 1,640,000.00 65,610.27 0.00 0.00
Run Date: 4/8/2024 - 3:26 PM
Amortizing 2925
# / 01,1 2 ,/0 3
3
4(!(
! %
1+1
%567 3736 7)368 69 # %6 :86 7)5# 6 ;83 69 <77#9=%>
378)6 %839 7)6?25)# !767 7 :77@ 9 5#67! %%85%
1+1 10 1 A !
" '
:" '
'.
! ' !
"#!$% &
) 3 '
'!
!( )*
:" 9
++,
&),- +)( , $+
" 9 !
.$,/0 & 12 .$-( !!
9
344$& !$5),
'6 7$8 )*
5 .
# 2 , 126 5
!
+
!
"
&
"
,
%
+
91
(
'$
-
:
1
" &
5
!!
9;#
:
7
.7
7
7
7 7 7<
';
#
2
26
Run Date: 3/6/2024 - 5:42 PM
Amortizing Page 3
Investment Policy Compliance
City of Lynwood 2/29/2024
Category Book Value % of Portfolio Allowed by Policy In ComplianceReserved row
US Treasuries 6,079,634.90 16.10%100%Yes
US Federal Agencies 12,400,029.65 32.83%100%Yes
Supranational Obligations 0.00 0.00%30%Yes
LAIF 9,974,525.05 26.41%$75,000,000 Yes
Commercial Paper 0.00 0.00%25%Yes
Money Market Funds 415,841.57 1.10%20%Yes
Negotiable Certificates of Deposit 5,410,030.83 14.32%30%Yes
Corporate Obligations 3,487,973.68 9.24%30%Yes
State and Local Governments 0.00 0.00%100%Yes
Total 37,768,035.69 100.00%
Other Metrics Portfolio Metric In Compliance
Weighted Average Maturity 1.62 Less than 3.0 Years Yes
Liquidity 44.29%30% Under 365 Days Yes
Ratings Yes
327
Portfolio Summary
City of Lynwood February 29, 2024
Investments Par Value Book Value
% of
Portfolio YTMMaturity
Days to
Market Value
Book
Certificates of Deposit 5,413,000.00 5,410,030.83 14.32 3.42 1,111 5,337,920.40
Corporate Bonds 3,500,000.00 3,487,973.68 9.24 3.51 690 3,425,250.00
LAIF 9,974,525.05 9,974,525.05 26.41 4.12 1 9,974,525.05
Money Market Funds 415,841.57 415,841.57 1.10 5.21 1 415,841.57
U.S. Agencies 12,440,000.00 12,400,029.65 32.83 3.50 757 12,209,722.00
U.S. Treasuries 6,130,000.00 6,079,634.90 16.10 1.31 743 5,788,090.10
37,768,035.69 100.00 591 37,151,349.12 3.32 37,873,366.62
Investments
February 29 Month Ending Fiscal Year To DateTotal Earnings
Current Year 68,641.30 718,491.08
Average Daily Balance 37,674,187.73 37,360,770.23
Book Rate of Return 2.29% 2.88%
Run Date: 3/6/2024 - 5:43 PM
Amortizing 1528
Run Date: 2/7/2024 - 1:44 PM
Amortizing Page 2
Portfolio Summary
City of Lynwood 1/31/2024
SECTOR ALLOCATION MATURITY DISTRIBUTION CREDIT QUALITY (MOODY'S)
ACCOUNT SUMMARY MONTH-END PORTFOLIO BOOK YIELD TOP ISSUERS
1/31/24 12/31/23 Issuer % Portfolio
Market Value $37,075,332 $36,817,583 LAIF 26.5%
Book Value $37,633,978 $37,483,789 FHLB 20.5%
Variance -$558,645 -$666,206 U.S. Treasury 14.9%
FFCB 7.2%
Par Value $37,704,734 $37,555,904 FHLMC 4.0%
JPMorgan 1.3%
Net Asset Value $98.52 $98.22 FNMA 1.3%
MetLife 1.3%
Book Yield 3.28%3.24%Goldman Sachs Govt MMF 1.3%
Apple 1.3%
Market Yield 4.48%4.51%Unilever Capital Corp 1.3%
3M 1.3%
Years to Maturity 1.62 1.69 Exxon Mobil 0.7%
New York Life 0.7%
Effective Duration 1.37 1.38 Charles Schwab 0.7%
Fe
b
-
2
3
M
a
r
-
2
3
Ap
r
-
2
3
M
a
y
-
2
3
Ju
n
-
2
3
Ju
l
-
2
3
Au
g
-
2
3
Se
p
-
2
3
Oc
t
-
2
3
No
v
-
2
3
De
c
-
2
3
Jan
-
2
4
1.60%
1.80%
2.00%
2.20%
2.40%
2.60%
2.80%
3.00%
3.20%
3.40%
1.3%
9.3%
14.9%
15.0%
26.5%
32.9%
MMF
CORP
TSY
CD
LAIF
AGY
100%75%50%25%0%
44.0%
17.9%
14.6%12.9%10.6%
0-1Y 1-2Y 2-3Y 3-4Y 4-5Y+
0%
10%
20%
30%
40%
50%
60%
70%
41.5%
1.3%
0.7%
3.3%
1.3%
0.7%
51.2%
NR
A3
A2
A1
Aa3
Aa2
Aa1
Aaa
P-1
100%75%50%25%0%
229
Run Date: 2/7/2024 - 1:44 PM
Amortizing Page 3
Investment Policy Compliance
City of Lynwood 1/31/2024
Category Book Value % of Portfolio % Allowed by Policy In ComplianceReserved row
US Treasuries 5,615,467.71 14.92%100%Yes
US Federal Agencies 12,399,211.43 32.95%100%Yes
Supranational Obligations 0.00 0.00%30%Yes
LAIF 9,974,525.05 26.50%75,000,000 Yes
Commercial Paper 0.00 0.00%25%Yes
Money Market Funds 499,208.83 1.33%20%Yes
Negotiable Certificates of Deposit 5,657,962.16 15.03%30%Yes
Corporate Obligations 3,487,602.63 9.27%30%Yes
State and Local Governments 0.00 0.00%100%Yes
Total 37,633,977.81 100.00%
Other Metrics Portfolio Metric In Compliance
Weighted Average Maturity 1.62 Less than 3.0 Years Yes
Liquidity 44.02%30% Under 365 Days Yes
Ratings Yes
330
Portfolio Summary
City of Lynwood January 31, 2024
Investments Par Value Book Value
% of
Portfolio YTMMaturity
Days to
Market Value
Book
Certificates of Deposit 5,661,000.00 5,657,962.16 15.03 3.41 1,092 5,535,739.68
Corporate Bonds 3,500,000.00 3,487,602.63 9.27 3.51 719 3,444,175.00
LAIF 9,974,525.05 9,974,525.05 26.50 4.01 1 9,974,525.05
Money Market Funds 499,208.83 499,208.83 1.33 5.21 1 499,208.83
U.S. Agencies 12,440,000.00 12,399,211.43 32.95 3.50 786 12,271,023.20
U.S. Treasuries 5,630,000.00 5,615,467.71 14.92 1.07 683 5,350,660.60
37,633,977.81 100.00 592 37,075,332.36 3.28 37,704,733.88
Investments
January 31 Month Ending Fiscal Year To DateTotal Earnings
Current Year 85,637.62 649,849.77
Average Daily Balance 37,586,468.68 37,315,996.30
Book Rate of Return 2.68% 2.96%
Run Date: 2/7/2024 - 1:47 PM
Amortizing 1531