Staff Report — Simi Valley City Council, August 19, 2024

CITY OF SIMI VALLEY

MEMORANDUM
A
ugust 19, 2024
TO: City Council
F
ROM: Department of Administrative Services
S
UBJECT: APPROVAL OF THE MONTHLY INVESTMENT REPORT FOR THE MONTH ENDED July 31, 2024
The City has contracted with an investment advisory firm, Insight Investment LLC (“Insight”). As part of the City’s agreement with Insight, they p repare the Monthly Investment Report. Data provided by Insight is attached. Information contained in that report is summarized below:
• P
ercentage of the portfolio represented by each investment category o Cash and Cash Equivalents: 50%
o U.S. Treasury: 16%
o U.S. Agencies: 19%
o Corporate Bonds: 15%
• A
listing of individual securities held at the end of the reporting period by authorized investment category, including the type of investment, name of the issuer, security or certificate number. Coupon, discount, or earnings rate; (shown under “Coupon” for each investment listed).
• W
eighted Average Maturity of Advisor Managed Investments: 2.40 years • W
eighted Average Yield on Advisor Managed portfolio: 4.02% The fair market value of a portfolio invested in debt securities changes from month to month and typically moves in the opposite direction of the change in interest rates demanded by the marketplace for the period in question. For example, per the U.S. Department of The Treasury’s website, annualized Treasury Yield Curve Rates for three-year treasury notes decreased from 4.52% on June 28, 2024 to

4.10% on July 31, 2024.

A Fixed Income Market Review through Ju ly 31, 2024, is included to provide the current economic conditions.
• T
he fair market value of all investments as of July 31, 2024, held by the City (excluding investments held by bond trustee): $281,804,380.

The portfolio is in compliance with the City’s Statement of Investment Policy . The City has sufficient liquidity to meet expenditure requirements for at least the next six months.

C arolyn Johnson, Deputy City Treasurer
Administrative Services Director
P
repared by: Eric Sanchez, Staff Accountant
AGENDA ITEM NO.

Consent (2)
City Managed Assets % Return
CAMP 5,686,112$ 2% 5.43%
LAIF 134,846,724$ 48% 4.52%
Total Internally Managed 140,532,836$ 50%
Weighted Average Yield 4.56%
Days
Effective Average Duration - Internal 1
Weighted Average Maturity - Internal 1
Advisor Managed Assets % Return
Treasury Securities 43,847,958$ 16% 3.56%
Instrumentality Securities 54,513,267$ 19% 4.14% Corporate 42,910,319$ 15% 4.33%
Total Externally Managed 141,271,544$ 50%
Weighted Average Yield 4.02%
Years
Effective Average Duration - External 2.16
Weighted Average Maturity - External 2.40
Total Portfolio Assets % Return
CAMP 5,686,112$ 2% 5.43%
LAIF 134,846,724$ 48% 4.52%
Treasury Securities 43,847,958$ 16% 3.56%
Instrumentality Securities 54,513,267$ 19% 4.14% Corporate 42,910,319$ 15% 4.33%
Total Portfolio Assets 281,804,380$
Weighted Average Yield 4.29%
Years
Effective Average Duration - Total 1.08
Weighted Average Maturity - Total 1.20
Portfolio Change
Beginning Balance
Ending Balance
* Note: All data for external assets was provided by the client and is believed to be accurate.

Insight Investment does not manage the external assets and this report is provided for the client's use.

Market values are presented.
281,804,380$
300,634,300$
Monthly Consolidated Portfolio Report
July 31, 2024
City of Simi Valley
CAMP, 2%
LAIF, 48%
Treasury
Securities,
16%
Instrumentality
Securities, 19%
Corporate,
15%
CAMP
2%
LAIF
48%
Treasury
Securities
16%
Instrumentality
Securities
19%
Corporate
15%
2 FOR PROFESSIONAL CLIENTS ONLY

NOT TO BE REPRODUCED WITHOUT PRIOR WRITTEN APPROVAL

PLEASE REFER TO ALL RISK DISCLOSURES AT THE BACK OF THIS DOCUMENT

CITY OF SIMI VALLEY
July 2024
3 Contents
Fixed income market review 3
Activity and performance summary 4
Recap of securities held 6
Maturity distribution of securities held 7
Securities held 8
GASB 40 - Deposit and investment risk disclosure 16
Securities purchased 23
Securities sold and matured 24
Detail of return and interest received 25
Transaction report 30
Additional information 32
4 FIXED INCOME MARKET REVIEW
As of July 31, 2024

CITY OF SIMI VALLEY
Chart 1: Inflation momentum trends closer to the Fed’s target Source: Bureau of Economic Analysis, Macrobond, July 31, 2024 Chart 2: Unemployment remains low but comes close to triggering the “Sahm rule” Source: Macrobond, Bureau of Labor Statistics, Federal Reserve Bank of St Louis, July 31, 2024 Economic Indicators and Monetary Policy
As markets expected, the Fed held the federal funds target rate at 5.25%-5.50%. Chair Powell appeared to begin setting the stage for a potential rate cut in September. The FOMC changed its characterization of job gains from

strong

to having

moderated

. It also noted the
unemployment rate is now

moving up

while remaining

low

. Regarding inflation, the FOMC
removed a phrase stating it is

highly attentive to inflation

, instead noting a softer stance of
being

attentive to risks to both sides of its dual mandate

Headline CPI fell from 3.3% to 3.0% year-on-year (the slowest pace since June 2023). Core CPI fell from 3.4% to 3.3%. Headline PCE fell from 2.6% to 2.5%, while core PCE remained at 2.6%.

Over the last 3-months, and on an annualized basis, CPI and PCE inflation increased by only

1.1% and 1.5% respectively. For core CPI and core PCE, the figures were 2.1% and 2.3%, close to the Fed

s target (Chart 1).

The labor market remained relatively robust. The US economy added 206,000 jobs in June, albeit the prior two months were revised down by 111,000. Private sector hiring slowed to 136,000. The construction sector added 27,000 new workers, while manufacturing lost 8,000 jobs. The service sector hired only 117,000, close to the softest post-pandemic reading.

The unemployment rate increased slightly from 4% to 4.1%, remaining historically low, albeit taking the “Sahm rule” indicator (measured as the 3-month average unemployment rate less its minimum value from the previous 12 months) to 0.43%, close to the 0.5% threshold that has historically coincided with sharply rising unemployment and recessions (Chart 2). Meanwhile, wage growth fell from 4.1% to 3.9%.

The first estimate of Q2 GDP was 2.8%, up from 1.4% in Q1 and above consensus expectations at 2.0%. Consumption rose 2.3% while business equipment investment surged 11.6%. Private final domestic demand, which the Fed uses as a proxy for domestic consumption strength, rose 2.6%, the same pace as in Q1.

Interest Rate Summary
Yields generally fell during the month. At the end of July, the 3-month US Treasury bill yielded

5.29%, the 6-month US Treasury bill yielded 5.09%, the 2-year US Treasury note yielded 4.26%, the 5-year US Treasury note yielded 3.91% and the 10-year US Treasury note yielded 4.03%. -0.5

1.5 3.5

5.5 7.5

9.5 11.5

13.5 1960 1970 1980 1990 2000 2010 2020
%
Recessions Sahm rule triggered
Unemployment rate (3-month average) Sahm rule indicator Sahm rule trigger level
3 5

ACTIVITY AND PERFORMANCE SUMMARY
For the period July 1, 2024 - July 31, 2024

CITY OF SIMI VALLEY
Amortized Cost Basis Activity Summary
141,480,542.80Opening balance
3 29,417.83Income received
329,417.83Total receipts

0.00Total disbursements
(339,500.18)Interportfolio transfers
(339,500.18)Total Interportfolio transfers

0.00Realized gain (loss)

0.00Change in accruals from security movement
(19,711.87)Total amortization expense
1 50,099.79Total OID/MKT accretion income
0 .00Return of capital
Closing balance 1 41,600,848.37
Ending fair value 1 41,271,543.95
(329,304.42)Unrealized gain (loss)
Comparative Rates of Return (%)
* Twelve
month trailing
* Six
month trailing
* One month
Fed Funds 5.32 2.60 0.44
Overnight Repo 5.39 2.64 0.45
Merrill Lynch 3m US Treas Bill 5.30 2.59 0.43
Merrill Lynch 6m US Treas Bill 5.23 2.54 0.42
ML 1 Year US Treasury Note 5.12 2.46 0.41
ML 2 Year US Treasury Note 4.72 2.29 0.37
ML 5 Year US Treasury Note 4.32 2.11 0.35
* rates reflected are cumulative
Summary of Amortized Cost Basis Return for the Period
Total portfolio
Interest earned 353,562.48
Accretion (amortization) 130,387.92
Realized gain (loss) on sales 0.00
Total income on portfolio 483,950.40
Average daily amortized cost 141,563,306.39
Period return (%)
Weighted average final maturity in days 876
YTD return (%)
Detail of Amortized Cost Basis Return
Interest
earned
Realized
gain (loss)
Accretion
(amortization)
Total
income

0.00Cash and Cash Equivalents 227.49 0.00 227.49

0.00Corporate Bonds 141,136.17 18,109.31 159,245.48

0.00Government Agencies 133,796.81 49,235.96 183,032.77

0.00Government Bonds 69,790.89 62,814.33 132,605.22

0.00Short Term Bills and Notes 8,611.12 228.32 8,839.44 Total 353,562.48 130,387.92 0.00 483,950.40

0.34 2.25
4 6

ACTIVITY AND PERFORMANCE SUMMARY
For the period July 1, 2024 - July 31, 2024

CITY OF SIMI VALLEY
Fair Value Basis Activity Summary
139,714,659.19Opening balance
3 29,417.83Income received
329,417.83Total receipts

0.00Total disbursements
(339,500.18)Interportfolio transfers
(339,500.18)Total Interportfolio transfers

0.00Unrealized gain (loss) on security movements

0.00Change in accruals from security movement

0.00Return of capital
Change in fair value for the period 1,566,967.11
Ending fair value 141,271,543.95
Comparative Rates of Return (%)
* Twelve
month trailing
* Six
month trailing
* One month
Fed Funds 5.32 2.60 0.44
Overnight Repo 5.39 2.64 0.45
ICE Bofa 3 Months US T-BILL 5.45 2.65 0.45
ICE Bofa 6m US Treas Bill 5.58 2.66 0.53
ICE Bofa 1 Yr US Treasury Note 5.30 2.28 0.73
ICE BofA US Treasury 1-3 5.35 2.00 1.14
ICE BofA US Treasury 1-5 5.39 1.93 1.48
* rates reflected are cumulative
Detail of Fair Value Basis Return
Interest
earned
Change in
fair value
Total
income
Cash and Cash Equivalents 227.49 0.00 227.49
Corporate Bonds 141,136.17 545,170.33 686,306.50
Government Agencies 133,796.81 555,539.42 689,336.23
Government Bonds 69,790.89 463,271.34 533,062.23
Short Term Bills and Notes 8,611.12 2,986.02 11,597.14
Total 353,562.48 1,566,967.11 1,920,529.59
Summary of Fair Value Basis Return for the Period
Total portfolio
Interest earned 353,562.48
Total income on portfolio 1,920,529.59
Average daily total value * 141,538,193.63
Period return (%) 1.37
Weighted average final maturity in days 876
Change in fair value 1,566,967.11
YTD return (%) 2.52
* Total value equals market value and accrued interest
5 7

RECAP OF SECURITIES HELD
As of July 31, 2024

CITY OF SIMI VALLEY
Weighted
average
final
maturity (days)
Weighted
average
effective
duration (years)
Percent
of
portfolio
Amortized
cost
Historical
cost
Fair value Unrealized
gain (loss)
Corporate Bonds 42,540,016.99 42,756,656.23 42,910,318.67 153,662.44 1,147 30.42 2.67 Government Agencies 51,995,038.78 52,561,110.91 52,514,024.64 (47,086.27) 799 37.19 2.02 Government Bonds 43,290,238.94 44,284,649.02 43,847,957.86 (436,691.16) 734 30.96 1.89 Short Term Bills And Notes 1,997,420.00 1,998,432.21 1,999,242.78 810.57 210 1.43 0.55 Total 139,822,714.71 141,600,848.37 141,271,543.95 (329,304.42) 876 100.00 2.16 Corporate Bonds
Government Agencies
Government Bonds
Short Term Bills and Notes
Portfolio diversification (%)
Corporate Bonds 30.42
Government Agencies 37.19
Government Bonds 30.96
Short Term Bills And Notes 1.43
Portfolio diversification (%)
6 8

MATURITY DISTRIBUTION OF SECURITIES HELD
As of July 31, 2024

CITY OF SIMI VALLEY
Maturity Historic cost Percent
Under 90 days 6,065,553.25 4.34
90 to 179 days 5,593,403.71 4.00
180 days to 1 year 17,170,747.55 12.28
1 to 2 years 29,918,959.51 21.40
2 to 3 years 26,236,232.39 18.76
3 to 4 years 38,034,309.90 27.20
4 to 5 years 16,803,508.40 12.02
Over 5 years 0.00 0.00
139,822,714.71 100.00
Maturity distribution

0.00 10.00

20.00 30.00

40.00 Historical cost (mm)
Un
der 90 d
ays
90 to 179 d
ays 180 days
to 1 yea
r
1 to
2 years
2 to 3
years
3 to 4
years
4 to
5 years
Over 5 years
7 9

SECURITIES HELD
As of July 31, 2024

CITY OF SIMI VALLEY
Amortized cost Fair value Unrealized
gain
(loss)
Coupon Maturity/
Call date
Historical costCusip Total
accrued
interest
%
Port
cost
Par value or
shares
Description
Corporate Bonds
89236TGL3 2 .000 10/07/2024 1,046,770.00 1,002,555.95 (9,086.59) 6,333.33 0.75993,469.361,000,000.00TOYOTA MOTOR CREDIT CORP 2% 07OCT2024 69353REF1 3.300 10/30/2024 992,934.00 904,100.03 (8,797.68) 7,425.00 09/30/2024

0.71895,302.35900,000.00PNC BANK NA 3.3% 30OCT2024 (CALLABLE 30SEP24) 931142DV2 2.650 12/15/2024 1,063,680.00 1,004,279.57 (13,893.07) 3,386.11 10/15/2024

0.76990,386.501,000,000.00WALMART INC 2.65% 15DEC2024 (CALLABLE 15OCT24) 166764BW9 1.554 05/11/2025 1,905,680.00 1,975,527.31 (27,776.73) 6,906.67 04/11/2025

1.361,947,750.582,000,000.00CHEVRON CORP 1.554% 11MAY2025 (CALLABLE 11APR25)
06051GFX2 3.500 04/19/2026 1,533,712.00 1,558,342.87 7,902.25 15,866.67 1.101,566,245.121,600,000.00BANK OF AMERICA CORP 3.5% 19APR2026 037833BZ2 2.450 08/04/2026 949,070.00 973,792.95 (12,824.14) 12,045.83 05/04/2026

0.68960,968.811,000,000.00APPLE INC 2.45% 04AUG2026 (CALLABLE 04MAY26) 02665WDZ1 1.300 09/09/2026 966,482.00 1,026,351.63 152.73 5,640.56 0.691,026,504.361,100,000.00AMERICAN HONDA FINANCE 1.3% 09SEP2026 89236TJV8 1.900 01/13/2027 914,170.00 951,665.89 (12,750.40) 950.00 0.65938,915.491,000,000.00TOYOTA MOTOR CREDIT CORP 1.9% 13JAN2027 17275RBQ4 4.800 02/26/2027 1,001,110.00 1,000,950.97 7,410.78 20,666.67 01/26/2027

0.721,008,361.751,000,000.00CISCO SYSTEMS INC 4.8% 26FEB2027 (CALLABLE 26JAN27)
30231GBJ0 3.294 03/19/2027 962,940.00 973,890.17 3,740.32 12,078.00 01/19/2027

0.69977,630.491,000,000.00EXXON MOBIL CORPORATION 3.294% 19MAR2027 (CALLABLE 19JAN27)
437076CA8 2.500 04/15/2027 932,050.00 951,747.09 (2,000.15) 7,361.11 02/15/2027

0.67949,746.941,000,000.00HOME DEPOT INC 2.5% 15APR2027 (CALLABLE 15FEB27)
437076CN0 2.875 04/15/2027 945,140.00 965,176.76 (5,707.58) 8,465.28 03/15/2027

0.68959,469.181,000,000.00HOME DEPOT INC 2.875% 15APR2027 (CALLABLE 15MAR27)
8 10

SECURITIES HELD
As of July 31, 2024

CITY OF SIMI VALLEY
Amortized cost Fair value Unrealized
gain
(loss)
Coupon Maturity/
Call date
Historical costCusip Total
accrued
interest
%
Port
cost
Par value or
shares
Description
Corporate Bonds
191216CE8 2 .900 05/25/2027 958,640.00 971,557.99 (10,706.48) 5,316.67 0.69960,851.511,000,000.00COCA-COLA CO/THE 2.9% 25MAY2027 22160KAN5 1.375 06/20/2027 887,870.00 918,904.59 1,376.81 1,565.97 04/20/2027

0.63920,281.401,000,000.00COSTCO WHOLESALE CORP 1.375% 20JUN2027 (CALLABLE 20APR27)
037833DB3 2.900 09/12/2027 1,877,540.00 1,919,318.78 (391.22) 22,394.44 06/12/2027

1.341,918,927.562,000,000.00APPLE INC 2.9% 12SEP2027 (CALLABLE 12JUN27) 14913R2G1 1.100 09/14/2027 1,119,352.00 1,175,047.17 2,627.58 5,441.94 0.801,177,674.751,300,000.00CATERPILLAR FINL SERVICE 1.1% 14SEP2027 24422EWK1 4.150 09/15/2027 1,471,035.00 1,480,729.97 6,423.52 23,516.67 1.051,487,153.491,500,000.00JOHN DEERE CAPITAL CORP 4.15% 15SEP2027 89236TKL8 5.450 11/10/2027 1,032,730.00 1,027,925.81 562.76 12,262.50 0.741,028,488.571,000,000.00TOYOTA MOTOR CREDIT CORP 5.45% 10NOV2027 02665WED9 4.700 01/12/2028 1,522,350.00 1,516,483.79 (9,404.61) 3,720.83 1.091,507,079.181,500,000.00AMERICAN HONDA FINANCE 4.7% 12JAN2028 46625HRY8 3.782 02/01/2028 962,400.00 965,987.37 8,944.01 18,910.00 02/01/2027

0.69974,931.381,000,000.00JPMORGAN CHASE & CO 3.782% 01FEB2028 (CALLABLE 01FEB27)
194162AR4 4.600 03/01/2028 1,693,200.00 1,695,125.60 23,789.04 32,583.33 02/01/2028

1.211,718,914.641,700,000.00COLGATE-PALMOLIVE CO 4.6% 01MAR2028 (CALLABLE 01FEB28)
713448FR4 4.450 05/15/2028 2,215,620.00 2,211,884.01 4,564.86 20,667.78 04/15/2028

1.582,216,448.872,200,000.00PEPSICO INC 4.45% 15MAY2028 (CALLABLE 15APR28) 931142EE9 3.700 06/26/2028 1,053,866.00 1,057,014.97 27,097.59 3,956.94 03/26/2028

0.751,084,112.561,100,000.00WALMART INC 3.7% 26JUN2028 (CALLABLE 26MAR28) 91159HJF8 4.548 07/22/2028 988,420.00 989,713.05 348.74 1,137.00 07/22/2027

0.71990,061.791,000,000.00US BANCORP 4.548% 22JUL2028 (CALLABLE 22JUL27) 9 11 SECURITIES HELD
As of July 31, 2024

0.711,001,444.091,000,000.00JPMORGAN CHASE & CO 4.851% 25JUL2028 (CALLABLE 25JUL27)
437076CH3 1.500 09/15/2028 872,610.00 883,081.49 10,575.49 5,666.67 07/15/2028

0.62893,656.981,000,000.00HOME DEPOT INC 1.5% 15SEP2028 (CALLABLE 15JUL28) 17325FBB3 5.803 09/29/2028 2,015,636.99 2,008,049.81 23,242.61 38,348.16 08/29/2028

1.442,031,292.421,950,000.00CITIBANK NA 5.803% 29SEP2028 (CALLABLE 29AUG28) 61747YEV3 6.296 10/18/2028 2,068,860.00 2,061,765.98 24,257.34 36,027.11 10/18/2027

1.482,086,023.322,000,000.00MORGAN STANLEY 6.296% 18OCT2028 (CALLABLE 18OCT27)
06051GLC1 6.204 11/10/2028 1,032,920.00 1,029,585.38 11,620.72 13,959.00 11/10/2027

0.741,041,206.101,000,000.00BANK OF AMERICA CORP 6.204% 10NOV2028 (CALLABLE 10NOV27)
71713UAW2 6.600 12/01/2028 1,069,210.00 1,063,776.16 15,948.42 11,000.00 0.761,079,724.581,000,000.00PHARMACIA LLC 6.6% 01DEC2028 693475BK0 5.354 12/02/2028 1,506,060.00 1,505,225.34 17,596.47 13,161.92 12/02/2027

1.081,522,821.811,500,000.00PNC FINANCIAL SERVICES 5.354% 02DEC2028 (CALLABLE 02DEC27)
17275RBR2 4.850 02/26/2029 2,098,719.00 2,098,779.79 40,354.11 43,852.08 01/26/2029

1.502,139,133.902,100,000.00CISCO SYSTEMS INC 4.85% 26FEB2029 (CALLABLE 26JAN29)
24422EUU1 3.450 03/07/2029 1,881,880.00 1,890,656.51 24,682.33 27,600.00 1.351,915,338.842,000,000.00JOHN DEERE CAPITAL CORP 3.45% 07MAR2029 Total Corporate Bonds 42,540,016.99 42,756,656.23 42,910,318.67 153,662.44 30.42449,022.7443,450,000.00 Government Agencies
3130AGWK7 1 .500 08/15/2024 2,983,827.00 2,999,857.30 (4,315.42) 20,750.00 2.132,995,541.883,000,000.00FEDERAL HOME LOAN BANK 1.5% 15AUG2024 3133EN6N5 4.250 11/20/2024 1,986,980.00 1,994,106.17 (587.13) 16,763.89 1.421,993,519.042,000,000.00FEDERAL FARM CREDIT BANK 4.25% 20NOV2024 10 12

SECURITIES HELD
As of July 31, 2024

CITY OF SIMI VALLEY
Amortized cost Fair value Unrealized
gain
(loss)
Coupon Maturity/
Call date
Historical costCusip Total
accrued
interest
%
Port
cost
Par value or
shares
Description
Government Agencies
3137EAEP0 1 .500 02/12/2025 1,902,980.00 1,961,272.68 1,547.02 14,083.33 1.361,962,819.702,000,000.00FREDDIE MAC 1.5% 12FEB2025 3135G03U5 0.625 04/22/2025 1,868,850.00 1,965,809.65 (27,026.79) 3,437.50 1.341,938,782.862,000,000.00FANNIE MAE 0.625% 22APR2025 3130ASG86 3.375 06/13/2025 760,365.00 753,140.61 (12,728.26) 3,375.00 0.54740,412.35750,000.00FEDERAL HOME LOAN BANK 3.375% 13JUN2025 3135G04Z3 0.500 06/17/2025 1,892,746.00 1,924,445.52 2,140.00 1,222.22 1.351,926,585.522,000,000.00FANNIE MAE 0.5% 17JUN2025 3137EAEU9 0.375 07/21/2025 1,414,485.00 1,439,484.34 (1,925.39) 156.25 1.011,437,558.951,500,000.00FREDDIE MAC 0.375% 21JUL2025 USD 3136G4K85 0.500 08/18/2025 1,409,919.75 1,433,365.29 (533.05) 3,395.83 1.011,432,832.241,500,000.00FANNIE MAE 0.5% 18AUG2025 CALLABLE #0000 3135G05X7 0.375 08/25/2025 918,750.00 972,963.48 (17,497.52) 1,625.00 0.66955,465.961,000,000.00FANNIE MAE 0.375% 25AUG2025 3130ATHT7 4.375 09/12/2025 2,010,640.00 2,004,038.98 (9,569.52) 33,784.72 1.441,994,469.462,000,000.00FEDERAL HOME LOAN BANK 4.375% 12SEP2025 3134A2HG6 0.000 12/11/2025 1,791,774.00 1,882,475.31 362.25 0.00 1.281,882,837.562,000,000.00FREDDIE MAC 0% 11DEC2025 3130B0AL3 4.650 02/23/2026 999,070.00 999,269.75 3,987.71 19,891.67 0.711,003,257.461,000,000.00FEDERAL HOME LOAN BANK 4.65% 23FEB2026 3130ASJ59 3.375 06/12/2026 3,055,800.00 3,026,444.01 (79,533.27) 13,781.25 2.192,946,910.743,000,000.00FEDERAL HOME LOAN BANK 3.375% 12JUN2026 3133EPNG6 4.375 06/23/2026 1,498,620.00 1,499,128.09 2,253.68 6,927.08 1.071,501,381.771,500,000.00FEDERAL FARM CREDIT BANK 4.375% 23JUN2026 11 13

SECURITIES HELD
As of July 31, 2024

CITY OF SIMI VALLEY
Amortized cost Fair value Unrealized
gain
(loss)
Coupon Maturity/
Call date
Historical costCusip Total
accrued
interest
%
Port
cost
Par value or
shares
Description
Government Agencies
3133EPQC2 4 .625 07/17/2026 2,003,140.00 2,002,096.30 8,784.72 3,597.22 1.432,010,881.022,000,000.00FEDERAL FARM CREDIT BANK 4.625% 17JUL2026 3130AWTQ3 4.625 09/11/2026 1,494,300.00 1,496,009.48 13,659.42 26,979.17 1.071,509,668.901,500,000.00FEDERAL HOME LOAN BANK 4.625% 11SEP2026 3135GA4N8 0.770 11/25/2026 2,615,040.00 2,770,562.74 (8,890.00) 4,235.00 11/25/2024

1.872,761,672.743,000,000.00FANNIE MAE 0.77% 25NOV2026 (CALLABLE 25NOV24) 3133EN4X5 3.875 12/23/2026 2,975,850.00 2,985,415.36 (11,718.94) 12,270.83 2.132,973,696.423,000,000.00FEDERAL FARM CREDIT BANK 3.875% 23DEC2026 3130AVBC5 4.500 03/12/2027 1,647,501.90 1,647,810.97 15,489.58 28,668.75 1.181,663,300.551,650,000.00FEDERAL HOME LOAN BANK 4.5% 12MAR2027 3133EKY34 1.750 10/15/2027 1,815,024.00 1,864,865.73 (8,342.31) 10,305.56 1.301,856,523.422,000,000.00FEDERAL FARM CREDIT BANK 1.75% 15OCT2027 3130ATUS4 4.250 12/10/2027 2,030,700.00 2,020,740.93 (14,215.23) 12,041.67 1.452,006,525.702,000,000.00FEDERAL HOME LOAN BANK 4.25% 10DEC2027 3133EN5N6 4.000 01/06/2028 3,014,435.13 3,010,074.43 (21,835.00) 8,333.33 2.162,988,239.433,000,000.00FEDERAL FARM CREDIT BANK 4% 06JAN2028 3130AWMN7 4.375 06/09/2028 2,967,641.00 2,964,066.22 18,663.35 18,642.36 2.122,982,729.572,950,000.00FEDERAL HOME LOAN BANK 4.375% 09JUN2028 3130AWN63 4.000 06/30/2028 1,980,536.00 1,984,433.22 30,791.58 6,666.67 1.422,015,224.802,000,000.00FEDERAL HOME LOAN BANK 4% 30JUN2028 3133EP5J0 4.125 03/12/2029 1,977,664.00 1,979,318.98 35,256.40 31,854.17 1.412,014,575.382,000,000.00FEDERAL FARM CREDIT BANK 4.125% 12MAR2029 12 14

SECURITIES HELD
As of July 31, 2024

CITY OF SIMI VALLEY
Amortized cost Fair value Unrealized
gain
(loss)
Coupon Maturity/
Call date
Historical costCusip Total
accrued
interest
%
Port
cost
Par value or
shares
Description
Government Agencies
3133EP5U5 4 .125 03/20/2029 2,978,400.00 2,979,915.37 38,695.85 45,031.25 2.133,018,611.223,000,000.00FEDERAL FARM CREDIT BANK 4.125% 20MAR2029 Total Government Agencies 51,995,038.78 52,561,110.91 52,514,024.64 (47,086.27) 37.19347,819.7253,350,000.00 Government Bonds
912828YH7 1
.500 09/30/2024 2,034,956.25 2,087,117.96 (718.74) 10,500.00 1.462,086,399.222,100,000.00USA TREASURY 1.5% 30SEP2024 912828YV6 1.500 11/30/2024 1,549,809.71 1,505,068.21 (23,548.67) 3,750.00 1.111,481,519.541,500,000.00USA TREASURY 1.5% 30NOV2024 912828Z52 1.375 01/31/2025 1,544,067.52 1,506,430.15 (33,477.02) 0.00 1.101,472,953.131,500,000.00USA TREASURY 1.375% 31JAN2025 91282CDZ1 1.500 02/15/2025 945,315.85 981,953.32 (804.88) 6,881.87 0.68981,148.441,000,000.00USA TREASURY 1.5% 15FEB2025 91282CGN5 4.625 02/28/2025 993,948.66 997,745.37 (73.50) 19,228.94 0.71997,671.871,000,000.00USA TREASURY 4.625% 28FEB2025 91282CGU9 3.875 03/31/2025 982,776.79 993,531.31 (515.69) 12,916.67 0.70993,015.621,000,000.00USA TREASURY 3.875% 31MAR2025 912828XZ8 2.750 06/30/2025 962,112.73 982,853.19 (790.69) 2,316.58 0.69982,062.501,000,000.00USA TREASURY 2.75% 30JUN2025 912828Y79 2.875 07/31/2025 964,026.79 982,925.59 (808.40) 0.00 0.69982,117.191,000,000.00USA TREASURY 2.875% 31JUL2025 9128284Z0 2.750 08/31/2025 865,022.55 882,686.16 (1,248.66) 10,290.08 0.62881,437.50900,000.00USA TREASURY 2.75% 31AUG2025 91282CAM3 0.250 09/30/2025 1,827,584.83 1,937,807.91 (36,557.91) 1,666.67 1.311,901,250.002,000,000.00USA TREASURY 0.25% 30SEP2025 13 15

SECURITIES HELD
As of July 31, 2024

CITY OF SIMI VALLEY
Amortized cost Fair value Unrealized
gain
(loss)
Coupon Maturity/
Call date
Historical costCusip Total
accrued
interest
%
Port
cost
Par value or
shares
Description
Government Bonds
91282CAT8 0 .250 10/31/2025 1,823,131.70 1,933,309.56 (37,684.56) 1,250.00 1.301,895,625.002,000,000.00USA TREASURY 0.25% 31OCT2025 91282CAZ4 0.375 11/30/2025 1,826,959.83 1,932,149.31 (39,258.69) 1,250.00 1.311,892,890.622,000,000.00USA TREASURY 0.375% 30NOV2025 91282CBH3 0.375 01/31/2026 1,818,756.70 1,923,694.35 (41,663.11) 0.00 1.301,882,031.242,000,000.00USA TREASURY 0.375% 31JAN2026 91282CBT7 0.750 03/31/2026 1,859,928.58 1,936,492.60 (52,898.84) 5,000.00 1.331,883,593.762,000,000.00USA TREASURY 0.75% 31MAR2026 91282CBW0 0.750 04/30/2026 1,857,428.58 1,933,653.85 (54,278.85) 3,750.00 1.331,879,375.002,000,000.00USA TREASURY 0.75% 30APR2026 91282CCF6 0.750 05/31/2026 1,854,694.20 1,930,663.64 (55,819.88) 2,500.00 1.331,874,843.762,000,000.00USA TREASURY 0.75% 31MAY2026 91282CCP4 0.625 07/31/2026 1,840,241.07 1,920,284.33 (58,565.57) 0.00 1.321,861,718.762,000,000.00USA TREASURY 0.625% 31JUL2026 91282CCZ2 0.875 09/30/2026 1,854,381.70 1,924,419.90 (60,826.14) 5,833.33 1.331,863,593.762,000,000.00USA TREASURY 0.875% 30SEP2026 912828YQ7 1.625 10/31/2026 2,912,557.26 2,946,382.92 (16,761.83) 12,593.75 2.082,929,621.093,100,000.00USA TREASURY 1.625% 31OCT2026 91282CEC1 1.875 02/28/2027 1,381,528.46 1,417,087.53 705.44 11,693.27 0.991,417,792.971,500,000.00USA TREASURY 1.875% 28FEB2027 91282CFB2 2.750 07/31/2027 1,421,196.43 1,442,435.02 2,076.70 0.00 1.021,444,511.721,500,000.00USA TREASURY 2.75% 31JUL2027 91282CFH9 3.125 08/31/2027 970,042.41 980,331.05 (7,206.05) 12,992.53 0.69973,125.001,000,000.00USA TREASURY 3.125% 31AUG2027 14 16

SECURITIES HELD
As of July 31, 2024

CITY OF SIMI VALLEY
Amortized cost Fair value Unrealized
gain
(loss)
Coupon Maturity/
Call date
Historical costCusip Total
accrued
interest
%
Port
cost
Par value or
shares
Description
Government Bonds
91282CFZ9 3 .875 11/30/2027 1,486,645.65 1,489,973.94 2,701.85 9,687.50 1.061,492,675.791,500,000.00USA TREASURY 3.875% 30NOV2027 91282CGP0 4.000 02/29/2028 1,496,489.40 1,497,317.84 2,154.82 24,945.65 1.071,499,472.661,500,000.00USA TREASURY 4% 29FEB2028 91282CGT2 3.625 03/31/2028 1,067,257.81 1,070,256.59 15,778.57 13,291.67 0.761,086,035.161,100,000.00USA TREASURY 3.625% 31MAR2028 91282CBZ3 1.250 04/30/2028 1,239,989.07 1,243,420.33 23,524.99 4,375.00 0.891,266,945.321,400,000.00USA TREASURY 1.25% 30APR2028 91282CJA0 4.625 09/30/2028 2,059,459.83 2,052,220.35 (2,689.11) 30,833.33 1.472,049,531.242,000,000.00USA TREASURY 4.625% 30SEP2028 91282CES6 2.750 05/31/2029 1,849,928.58 1,852,436.74 42,563.26 9,166.67 1.321,895,000.002,000,000.00USA TREASURY 2.75% 31MAY2029 Total Government Bonds 43,290,238.94 44,284,649.02 43,847,957.86 (436,691.16) 30.96216,713.5145,600,000.00 Short Term Bills and Notes
3130B06G9 5 .000 02/26/2025 1,997,420.00 1,998,432.21 810.57 43,055.56 1.431,999,242.782,000,000.00FEDERAL HOME LOAN BANK 5% 26FEB2025 #0000 Total Short Term Bills and Notes 1,997,420.00 1,998,432.21 1,999,242.78 810.57 1.4343,055.562,000,000.00 Grand total 139,822,714.71 141,600,848.37 (329,304.42)144,400,000.00 100.001,056,611.53141,271,543.95 15 17
GASB 40 - DEPOSIT AND INVESTMENT RISK DISCLOSURE
As of July 31, 2024

CITY OF SIMI VALLEY
Cusip S&P
rating
Moody
rating
Historical
cost
% Portfolio
hist cost
Market
value
% Portfolio
mkt value
Effective
dur (yrs)
Description Coupon Maturity
date
Call date Par value or
shares
United States Treasury Note/Bond
912828YH7 USA TREASURY 1.5% 1.500 09/30/2024 A A+ Aaa 2,100,000.00 2,034,956.25 1.46 2,086,399.22 1.48 0.17 912828YV6 USA TREASURY 1.5% 1.500 11/30/2024 A A+ Aaa 1,500,000.00 1,549,809.71 1.11 1,481,519.54 1.05 0.33 912828Z52 USA TREASURY 1.375% 1.375 01/31/2025 A A+ Aaa 1,500,000.00 1,544,067.52 1.10 1,472,953.13 1.04 0.49 91282CDZ1 USA TREASURY 1.5% 1.500 02/15/2025 A A+ Aaa 1,000,000.00 945,315.85 0.68 981,148.44 0.69 0.54 91282CGN5 USA TREASURY 4.625% 4.625 02/28/2025 A A+ Aaa 1,000,000.00 993,948.66 0.71 997,671.87 0.71 0.56 91282CGU9 USA TREASURY 3.875% 3.875 03/31/2025 A A+ Aaa 1,000,000.00 982,776.79 0.70 993,015.62 0.70 0.64 912828XZ8 USA TREASURY 2.75% 2.750 06/30/2025 A A+ Aaa 1,000,000.00 962,112.73 0.69 982,062.50 0.70 0.89 912828Y79 USA TREASURY 2.875% 2.875 07/31/2025 A A+ Aaa 1,000,000.00 964,026.79 0.69 982,117.19 0.70 0.99 9128284Z0 USA TREASURY 2.75% 2.750 08/31/2025 A A+ Aaa 900,000.00 865,022.55 0.62 881,437.50 0.62 1.04 91282CAM3 USA TREASURY 0.25% 0.250 09/30/2025 A A+ Aaa 2,000,000.00 1,827,584.83 1.31 1,901,250.00 1.35 1.14 91282CAT8 USA TREASURY 0.25% 0.250 10/31/2025 A A+ Aaa 2,000,000.00 1,823,131.70 1.30 1,895,625.00 1.34 1.22 91282CAZ4 USA TREASURY 0.375% 0.375 11/30/2025 A A+ Aaa 2,000,000.00 1,826,959.83 1.31 1,892,890.62 1.34 1.30 91282CBH3 USA TREASURY 0.375% 0.375 01/31/2026 A A+ Aaa 2,000,000.00 1,818,756.70 1.30 1,882,031.24 1.33 1.46 91282CBT7 USA TREASURY 0.75% 0.750 03/31/2026 A A+ Aaa 2,000,000.00 1,859,928.58 1.33 1,883,593.76 1.33 1.61 91282CBW0 USA TREASURY 0.75% 0.750 04/30/2026 A A+ Aaa 2,000,000.00 1,857,428.58 1.33 1,879,375.00 1.33 1.69 91282CCF6 USA TREASURY 0.75% 0.750 05/31/2026 A A+ Aaa 2,000,000.00 1,854,694.20 1.33 1,874,843.76 1.33 1.77 91282CCP4 USA TREASURY 0.625% 0.625 07/31/2026 A A+ Aaa 2,000,000.00 1,840,241.07 1.32 1,861,718.76 1.32 1.94 91282CCZ2 USA TREASURY 0.875% 0.875 09/30/2026 A A+ Aaa 2,000,000.00 1,854,381.70 1.33 1,863,593.76 1.32 2.09 912828YQ7 USA TREASURY 1.625% 1.625 10/31/2026 A A+ Aaa 3,100,000.00 2,912,557.26 2.08 2,929,621.09 2.07 2.16 91282CEC1 USA TREASURY 1.875% 1.875 02/28/2027 A A+ Aaa 1,500,000.00 1,381,528.46 0.99 1,417,792.97 1.00 2.45 91282CFB2 USA TREASURY 2.75% 2.750 07/31/2027 A A+ Aaa 1,500,000.00 1,421,196.43 1.02 1,444,511.72 1.02 2.83 91282CFH9 USA TREASURY 3.125% 3.125 08/31/2027 A A+ Aaa 1,000,000.00 970,042.41 0.69 973,125.00 0.69 2.85 91282CFZ9 USA TREASURY 3.875% 3.875 11/30/2027 A A+ Aaa 1,500,000.00 1,486,645.65 1.06 1,492,675.79 1.06 3.06 91282CGP0 USA TREASURY 4% 4 .000 02/29/2028 AA+ Aaa 1,500,000.00 1,496,489.40 1.07 1,499,472.66 1.06 3.24 91282CGT2 USA TREASURY 3.625% 3.625 03/31/2028 A A+ Aaa 1,100,000.00 1,067,257.81 0.76 1,086,035.16 0.77 3.34 16 18
GASB 40 - DEPOSIT AND INVESTMENT RISK DISCLOSURE
As of July 31, 2024

CITY OF SIMI VALLEY
Cusip S&P
rating
Moody
rating
Historical
cost
% Portfolio
hist cost
Market
value
% Portfolio
mkt value
Effective
dur (yrs)
Description Coupon Maturity
date
Call date Par value or
shares
United States Treasury Note/Bond
91282CBZ3 USA TREASURY 1.25% 1.250 04/30/2028 A A+ Aaa 1,400,000.00 1,239,989.07 0.89 1,266,945.32 0.90 3.57 91282CJA0 USA TREASURY 4.625% 4.625 09/30/2028 A A+ Aaa 2,000,000.00 2,059,459.83 1.47 2,049,531.24 1.45 3.70 91282CES6 USA TREASURY 2.75% 2.750 05/31/2029 A A+ Aaa 2,000,000.00 1,849,928.58 1.32 1,895,000.00 1.34 4.42 Issuer total 45,600,000.00 43,290,238.94 30.96 43,847,957.86 31.04 1.89 Federal Home Loan Banks
3130AGWK7 FEDERAL HOME LOAN 1.500 08/15/2024 A
A+ Aaa 3,000,000.00 2,983,827.00 2.13 2,995,541.88 2.12 0.04 3130B06G9 FEDERAL HOME LOAN 5.000 02/26/2025 A A+ Aaa 2,000,000.00 1,997,420.00 1.43 1,999,242.78 1.42 0.55 3130ASG86 FEDERAL HOME LOAN 3.375 06/13/2025 A A+ Aaa 750,000.00 760,365.00 0.54 740,412.35 0.52 0.84 3130ATHT7 FEDERAL HOME LOAN 4.375 09/12/2025 A A+ Aaa 2,000,000.00 2,010,640.00 1.44 1,994,469.46 1.41 1.06 3130B0AL3 FEDERAL HOME LOAN 4.650 02/23/2026 A A+ Aaa 1,000,000.00 999,070.00 0.71 1,003,257.46 0.71 1.46 3130ASJ59 FEDERAL HOME LOAN 3.375 06/12/2026 A A+ Aaa 3,000,000.00 3,055,800.00 2.19 2,946,910.74 2.09 1.77 3130AWTQ3 FEDERAL HOME LOAN 4.625 09/11/2026 A A+ Aaa 1,500,000.00 1,494,300.00 1.07 1,509,668.90 1.07 1.95 3130AVBC5 FEDERAL HOME LOAN 4.500 03/12/2027 A A+ Aaa 1,650,000.00 1,647,501.90 1.18 1,663,300.55 1.18 2.39 3130ATUS4 FEDERAL HOME LOAN 4.250 12/10/2027 A A+ Aaa 2,000,000.00 2,030,700.00 1.45 2,006,525.70 1.42 3.07 3130AWMN FEDERAL HOME LOAN 4.375 06/09/2028 A A+ Aaa 2,950,000.00 2,967,641.00 2.12 2,982,729.57 2.11 3.48 3130AWN63 FEDERAL HOME LOAN 4.000 06/30/2028 A A+ Aaa 2,000,000.00 1,980,536.00 1.42 2,015,224.80 1.43 3.56 Issuer total 21,850,000.00 21,927,800.90 15.68 21,857,284.19 15.47 1.88 Federal Farm Credit Banks Funding Corp
3133EN6N5 FEDERAL FARM CREDIT 4.250 11/20/2024 A
A+ Aaa 2,000,000.00 1,986,980.00 1.42 1,993,519.04 1.41 0.30 3133EPNG6 FEDERAL FARM CREDIT 4.375 06/23/2026 A A+ Aaa 1,500,000.00 1,498,620.00 1.07 1,501,381.77 1.06 1.79 3133EPQC2 FEDERAL FARM CREDIT 4.625 07/17/2026 A A+ Aaa 2,000,000.00 2,003,140.00 1.43 2,010,881.02 1.42 1.85 3133EN4X5 FEDERAL FARM CREDIT 3.875 12/23/2026 A A+ Aaa 3,000,000.00 2,975,850.00 2.13 2,973,696.42 2.10 2.25 3133EKY34 FEDERAL FARM CREDIT 1.750 10/15/2027 A A+ Aaa 2,000,000.00 1,815,024.00 1.30 1,856,523.42 1.31 3.04 3133EN5N6 FEDERAL FARM CREDIT 4.000 01/06/2028 A A+ Aaa 3,000,000.00 3,014,435.13 2.16 2,988,239.43 2.12 3.15 17 19
GASB 40 - DEPOSIT AND INVESTMENT RISK DISCLOSURE
As of July 31, 2024

CITY OF SIMI VALLEY
Cusip S&P
rating
Moody
rating
Historical
cost
% Portfolio
hist cost
Market
value
% Portfolio
mkt value
Effective
dur (yrs)
Description Coupon Maturity
date
Call date Par value or
shares
Federal Farm Credit Banks Funding Corp
3133EP5J0 FEDERAL FARM CREDIT 4.125 03/12/2029 A A+ Aaa 2,000,000.00 1,977,664.00 1.41 2,014,575.38 1.43 4.09 3133EP5U5 FEDERAL FARM CREDIT 4.125 03/20/2029 A A+ Aaa 3,000,000.00 2,978,400.00 2.13 3,018,611.22 2.14 4.10 Issuer total 18,500,000.00 18,250,113.13 13.05 18,357,427.70 12.99 2.68 Federal National Mortgage Association
3135G03U5 FANNIE MAE 0.625% 0.625 04/22/2025 A
A+ Aaa 2,000,000.00 1,868,850.00 1.34 1,938,782.86 1.37 0.71 3135G04Z3 FANNIE MAE 0.5% 0 .500 06/17/2025 AA+ Aaa 2,000,000.00 1,892,746.00 1.35 1,926,585.52 1.36 0.86 3136G4K85 FANNIE MAE 0.5% 0 .500 08/18/2025 AA+ Aaa 1,500,000.00 1,409,919.75 1.01 1,432,832.24 1.01 1.02 3135G05X7 FANNIE MAE 0.375% 0.375 08/25/2025 A A+ Aaa 1,000,000.00 918,750.00 0.66 955,465.96 0.68 1.04 3135GA4N8 FANNIE MAE 0.77% 0 .770 11/25/2026 11/25/2024 AA+ Aaa 3,000,000.00 2,615,040.00 1.87 2,761,672.74 1.95 2.24 Issuer total 9,500,000.00 8,705,305.75 6.23 9,015,339.32 6.38 1.29 Federal Home Loan Mortgage Corp
3137EAEP0 FREDDIE MAC 1.5% 1
.500 02/12/2025 AA+ Aaa 2,000,000.00 1,902,980.00 1.36 1,962,819.70 1.39 0.52 3137EAEU9 FREDDIE MAC 0.375% 0.375 07/21/2025 A A+ Aaa 1,500,000.00 1,414,485.00 1.01 1,437,558.95 1.02 0.95 3134A2HG6 FREDDIE MAC 0% 0 .000 12/11/2025 AA+ Aaa 2,000,000.00 1,791,774.00 1.28 1,882,837.56 1.33 1.33 Issuer total 5,500,000.00 5,109,239.00 3.65 5,283,216.21 3.74 0.92 John Deere Capital Corp
24422EWK1 JOHN DEERE CAPITAL 4.150 09/15/2027 A
A1 1,500,000.00 1,471,035.00 1.05 1,487,153.49 1.05 2.84 24422EUU1 JOHN DEERE CAPITAL 3.450 03/07/2029 A A1 2,000,000.00 1,881,880.00 1.35 1,915,338.84 1.36 4.11 Issuer total 3,500,000.00 3,352,915.00 2.40 3,402,492.33 2.41 3.55 Cisco Systems Inc
17275RBQ4 CISCO SYSTEMS INC 4.8% 4.800 02/26/2027 01/26/2027 AA- A1 1,000,000.00 1,001,110.00 0.72 1,008,361.75 0.71 2.30 17275RBR2 CISCO SYSTEMS INC 4.850 02/26/2029 01/26/2029 AA- A1 2,100,000.00 2,098,719.00 1.50 2,139,133.90 1.51 3.94 I
ssuer total 3,100,000.00 3,099,829.00 2.22 3,147,495.65 2.23 3.41 18 20
GASB 40 - DEPOSIT AND INVESTMENT RISK DISCLOSURE
As of July 31, 2024

CITY OF SIMI VALLEY
Cusip S&P
rating
Moody
rating
Historical
cost
% Portfolio
hist cost
Market
value
% Portfolio
mkt value
Effective
dur (yrs)
Description Coupon Maturity
date
Call date Par value or
shares
Toyota Motor Credit Corp
89236TGL3 TOYOTA MOTOR CREDIT 2.000 10/07/2024 A + A1 1,000,000.00 1,046,770.00 0.75 993,469.36 0.70 0.18 89236TJV8 TOYOTA MOTOR CREDIT 1.900 01/13/2027 A + A1 1,000,000.00 914,170.00 0.65 938,915.49 0.66 2.34 89236TKL8 TOYOTA MOTOR CREDIT 5.450 11/10/2027 A + A1 1,000,000.00 1,032,730.00 0.74 1,028,488.57 0.73 2.94 Issuer total 3,000,000.00 2,993,670.00 2.14 2,960,873.42 2.10 1.79 Apple Inc
037833BZ2 APPLE INC 2.45% 2
.450 08/04/2026 05/04/2026 AA+ Aaa 1,000,000.00 949,070.00 0.68 960,968.81 0.68 1.86 037833DB3 APPLE INC 2.9% 2 .900 09/12/2027 06/12/2027 AA+ Aaa 2,000,000.00 1,877,540.00 1.34 1,918,927.56 1.36 2.82 Issuer total 3,000,000.00 2,826,610.00 2.02 2,879,896.37 2.04 2.50 Home Depot Inc/The
437076CN0 HOME DEPOT INC 2.875% 2.875 04/15/2027 03/15/2027 A A2 1,000,000.00 945,140.00 0.68 959,469.18 0.68 2.51 437076CA8 HOME DEPOT INC 2.5% 2.500 04/15/2027 02/15/2027 A A2 1,000,000.00 932,050.00 0.67 949,746.94 0.67 2.51 437076CH3 HOME DEPOT INC 1.5% 1.500 09/15/2028 07/15/2028 A A2 1,000,000.00 872,610.00 0.62 893,656.98 0.63 3.86 I
ssuer total 3,000,000.00 2,749,800.00 1.97 2,802,873.10 1.98 2.94 Bank of America Corp
06051GFX2 BANK OF AMERICA CORP 3.500 04/19/2026 A
- A1 1,600,000.00 1,533,712.00 1.10 1,566,245.12 1.11 1.62 06051GLC1 BANK OF AMERICA CORP 6.204 11/10/2028 11/10/2027 A- A1 1,000,000.00 1,032,920.00 0.74 1,041,206.10 0.74 2.90 I
ssuer total 2,600,000.00 2,566,632.00 1.84 2,607,451.22 1.85 2.14 American Honda Finance Corp
02665WDZ1 AMERICAN HONDA 1
.300 09/09/2026 A- A3 1,100,000.00 966,482.00 0.69 1,026,504.36 0.73 2.02 02665WED9 AMERICAN HONDA 4 .700 01/12/2028 A- A3 1,500,000.00 1,522,350.00 1.09 1,507,079.18 1.07 3.13 Issuer total 2,600,000.00 2,488,832.00 1.78 2,533,583.54 1.79 2.70 19 21
GASB 40 - DEPOSIT AND INVESTMENT RISK DISCLOSURE
As of July 31, 2024

CITY OF SIMI VALLEY
Cusip S&P
rating
Moody
rating
Historical
cost
% Portfolio
hist cost
Market
value
% Portfolio
mkt value
Effective
dur (yrs)
Description Coupon Maturity
date
Call date Par value or
shares
PepsiCo Inc
713448FR4 PEPSICO INC 4.45% 4 .450 05/15/2028 04/15/2028 A+ A1 2,200,000.00 2,215,620.00 1.58 2,216,448.87 1.57 3.37 Issuer total 2,200,000.00 2,215,620.00 1.58 2,216,448.87 1.57 3.37 Morgan Stanley
61747YEV3 MORGAN STANLEY 6
.296 10/18/2028 10/18/2027 A- A1 2,000,000.00 2,068,860.00 1.48 2,086,023.32 1.48 2.84 Issuer total 2,000,000.00 2,068,860.00 1.48 2,086,023.32 1.48 2.84 Walmart Inc
931142DV2 WALMART INC 2.65% 2.650 12/15/2024 10/15/2024 AA Aa2 1,000,000.00 1,063,680.00 0.76 990,386.50 0.70 0.37 931142EE9 WALMART INC 3.7% 3.700 06/26/2028 03/26/2028 AA Aa2 1,100,000.00 1,053,866.00 0.75 1,084,112.56 0.77 3.46 I
ssuer total 2,100,000.00 2,117,546.00 1.51 2,074,499.06 1.47 1.91 Citibank NA
17325FBB3 CITIBANK NA 5.803% 5.803 09/29/2028 08/29/2028 A+ Aa3 1,950,000.00 2,015,636.99 1.44 2,031,292.42 1.44 3.55 I
ssuer total 1,950,000.00 2,015,636.99 1.44 2,031,292.42 1.44 3.55 JPMorgan Chase & Co
46625HRY8 JPMORGAN CHASE & CO 3.782 02/01/2028 02/01/2027 A- A1 1,000,000.00 962,400.00 0.69 974,931.38 0.69 2.35 46647PDG8 JPMORGAN CHASE & CO 4.851 07/25/2028 07/25/2027 A- A1 1,000,000.00 997,360.00 0.71 1,001,444.09 0.71 2.73 I
ssuer total 2,000,000.00 1,959,760.00 1.40 1,976,375.47 1.40 2.54 Chevron Corp
166764BW9 CHEVRON CORP 1.554% 1.554 05/11/2025 04/11/2025 AA- Aa2 2,000,000.00 1,905,680.00 1.36 1,947,750.58 1.38 0.76 I
ssuer total 2,000,000.00 1,905,680.00 1.36 1,947,750.58 1.38 0.76 Colgate-Palmolive Co
194162AR4 COLGATE-PALMOLIVE CO 4.600 03/01/2028 02/01/2028 A+ Aa3 1,700,000.00 1,693,200.00 1.21 1,718,914.64 1.22 3.16 I
ssuer total 1,700,000.00 1,693,200.00 1.21 1,718,914.64 1.22 3.16 20 22
GASB 40 - DEPOSIT AND INVESTMENT RISK DISCLOSURE
As of July 31, 2024

CITY OF SIMI VALLEY
Cusip S&P
rating
Moody
rating
Historical
cost
% Portfolio
hist cost
Market
value
% Portfolio
mkt value
Effective
dur (yrs)
Description Coupon Maturity
date
Call date Par value or
shares
PNC Financial Services Group Inc/The
693475BK0 PNC FINANCIAL 5 .354 12/02/2028 12/02/2027 A- A3 1,500,000.00 1,506,060.00 1.08 1,522,821.81 1.08 2.99 Issuer total 1,500,000.00 1,506,060.00 1.08 1,522,821.81 1.08 2.99 Caterpillar Financial Services Corp
14913R2G1 CATERPILLAR FINL 1
.100 09/14/2027 A A2 1,300,000.00 1,119,352.00 0.80 1,177,674.75 0.83 2.98 Issuer total 1,300,000.00 1,119,352.00 0.80 1,177,674.75 0.83 2.98 Pharmacia LLC
71713UAW2 PHARMACIA LLC 6.6% 6.600 12/01/2028 A
A2 1,000,000.00 1,069,210.00 0.76 1,079,724.58 0.76 3.72 Issuer total 1,000,000.00 1,069,210.00 0.76 1,079,724.58 0.76 3.72 US Bancorp
91159HJF8 US BANCORP 4.548% 4.548 07/22/2028 07/22/2027 A A3 1,000,000.00 988,420.00 0.71 990,061.79 0.70 2.73 I
ssuer total 1,000,000.00 988,420.00 0.71 990,061.79 0.70 2.73 Exxon Mobil Corp
30231GBJ0 EXXON MOBIL 3
.294 03/19/2027 01/19/2027 AA- Aa2 1,000,000.00 962,940.00 0.69 977,630.49 0.69 2.39 Issuer total 1,000,000.00 962,940.00 0.69 977,630.49 0.69 2.39 Coca-Cola Co/The
191216CE8 COCA-COLA CO/THE 2.9% 2.900 05/25/2027 A + A1 1,000,000.00 958,640.00 0.69 960,851.51 0.68 2.64 Issuer total 1,000,000.00 958,640.00 0.69 960,851.51 0.68 2.64 Costco Wholesale Corp
22160KAN5 COSTCO WHOLESALE 1.375 06/20/2027 04/20/2027 A+ Aa3 1,000,000.00 887,870.00 0.63 920,281.40 0.65 2.74 I
ssuer total 1,000,000.00 887,870.00 0.63 920,281.40 0.65 2.74 21 23
GASB 40 - DEPOSIT AND INVESTMENT RISK DISCLOSURE
As of July 31, 2024

CITY OF SIMI VALLEY
Cusip S&P
rating
Moody
rating
Historical
cost
% Portfolio
hist cost
Market
value
% Portfolio
mkt value
Effective
dur (yrs)
Description Coupon Maturity
date
Call date Par value or
shares
PNC Bank NA
69353REF1 PNC BANK NA 3.3% 3 .300 10/30/2024 09/30/2024 A A2 900,000.00 992,934.00 0.71 895,302.35 0.63 0.25 Issuer total 900,000.00 992,934.00 0.71 895,302.35 0.63 0.25 Grand total 144,400,000.00 139,822,714.71 100.00 141,271,543.95 100.00 2.16 22 24

SECURITIES PURCHASED
For the period July 1, 2024 - July 31, 2024

CITY OF SIMI VALLEY
Par value or
shares
Unit cost Accrued
interest
Trade date
Settle date
Coupon Maturity/
Call date
Principal
cost
Cusip Description / Broker
Government Bonds
91282CBZ3 1.25007/01/2024 04/30/2028 1,400,000.00 88.57 (1,239,989.07) (2,995.92) 07/02/2024
USA TREASURY 1.25% 30APR2028

BANK OF MONTREAL
91282CES6 2.75007/01/2024 05/31/2029 2,000,000.00 92.50 (1,849,928.58) (4,808.74) 07/02/2024
USA TREASURY 2.75% 31MAY2029
J.P. MORGAN SECURITIES LLC
3,400,000.00 (3,089,917.65) (7,804.66)Total Government Bonds Grand totalGrand total 3 ,400,000.00 (3,089,917.65) (7,804.66) 23 25

SECURITIES SOLD AND MATURED
For the period July 1, 2024 - July 31, 2024

CITY OF SIMI VALLEY
Historical cost Amortized cost
at sale or
maturity
Fair value at
sale or
maturity
Realized
gain
(loss)
PriceCouponTrade date
Settle date
Maturity/
Call date
Par value or
shares
Cusip Accrued
interest
sold
Description / Broker
Government Bonds
9128286Z8 1.75007/01/2024 (3,100,000.00) 3,010,764.29 3,100,000.00 0.00 3,100,000.00 0.00 0.00 07/01/2024
US TREASURY N/B 1.75% 06-30-2024
(3,100,000.00) 0.003,010,764.29 3,100,000.00 3,100,000.00 0.00Total (Government Bonds) Grand totalGrand total (3,100,000.00) 0.003,010,764.29 3,100,000.00 3,100,000.00 0.00 24 26

DETAIL OF RETURN AND INTEREST RECEIVED
For the period July 1, 2024 - July 31, 2024

CITY OF SIMI VALLEY
Description Interest earnedAccretion
(amortization)
Realized gain
(loss)
Change in fair
value
Interest receivedCusip
Cash
Cash and Cash Equivalents 22 7.490.00 0.00 227.490.00
Total Cash 227.490.00 0.00 227.490.00
Corporate Bonds
AMERICAN HONDA FINANCE 1.3% 09SEP2026 1, 231.392,911.01 12,882.40 0.000.0002665WDZ1 AMERICAN HONDA FINANCE 4.7% 12JAN2028 6,070.83(398.16) 21,651.71 35,250.000.0002665WED9 APPLE INC 2.45% 04AUG2026 (CALLABLE 04MAY26) 2,109.721,085.93 11,029.28 0.000.00037833BZ2 APPLE INC 2.9% 12SEP2027 (CALLABLE 12JUN27) 4,994.442,157.25 30,043.40 0.000.00037833DB3 BANK OF AMERICA CORP 3.5% 19APR2026 4,822.232,018.92 15,504.67 0.000.0006051GFX2 BANK OF AMERICA CORP 6.204% 10NOV2028 (CALLABLE 10NOV27) 5,342.33(752.17) 11,377.98 0.000.0006051GLC1 CATERPILLAR FINL SERVICE 1.1% 14SEP2027 1,231.383,335.04 18,986.19 0.000.0014913R2G1 CHEVRON CORP 1.554% 11MAY2025 (CALLABLE 11APR25) 2,676.342,612.74 11,596.24 0.000.00166764BW9 CISCO SYSTEMS INC 4.8% 26FEB2027 (CALLABLE 26JAN27) 4,133.34(30.75) 11,065.95 0.000.0017275RBQ4 CISCO SYSTEMS INC 4.85% 26FEB2029 (CALLABLE 26JAN29) 8,770.4122.24 39,504.38 0.000.0017275RBR2 CITIBANK NA 5.803% 29SEP2028 (CALLABLE 29AUG28) 9,744.21(1,185.50) 27,945.49 0.000.0017325FBB3 COCA-COLA CO/THE 2.9% 25MAY2027 2,497.23840.65 12,394.12 0.000.00191216CE8 COLGATE-PALMOLIVE CO 4.6% 01MAR2028 (CALLABLE 01FEB28) 6,733.89113.27 21,774.53 0.000.00194162AR4 COSTCO WHOLESALE CORP 1.375% 20JUN2027 (CALLABLE 20APR27) 1,184.032,339.29 11,951.43 0.000.0022160KAN5 EXXON MOBIL CORPORATION 3.294% 19MAR2027 (CALLABLE 19JAN27) 2,836.50825.39 11,266.96 0.000.0030231GBJ0 HOME DEPOT INC 1.5% 15SEP2028 (CALLABLE 15JUL28) 1,291.672,361.99 16,429.17 0.000.00437076CH3 HOME DEPOT INC 2.5% 15APR2027 (CALLABLE 15FEB27) 2,152.781,484.71 13,317.55 0.000.00437076CA8 25 27

DETAIL OF RETURN AND INTEREST RECEIVED
For the period July 1, 2024 - July 31, 2024

CITY OF SIMI VALLEY
Description Interest earnedAccretion
(amortization)
Realized gain
(loss)
Change in fair
value
Interest receivedCusip
Corporate Bonds
HOME DEPOT INC 2.875% 15APR2027 (CALLABLE 15MAR27) 2, 475.701,071.49 12,942.37 0.000.00437076CN0 JOHN DEERE CAPITAL CORP 3.45% 07MAR2029 5,941.671,979.66 30,528.68 0.000.0024422EUU1 JOHN DEERE CAPITAL CORP 4.15% 15SEP2027 5,360.42513.87 20,023.75 0.000.0024422EWK1 JPMORGAN CHASE & CO 3.782% 01FEB2028 (CALLABLE 01FEB27) 3,256.72809.18 11,575.14 0.000.0046625HRY8 JPMORGAN CHASE & CO 4.851% 25JUL2028 (CALLABLE 25JUL27) 4,177.2548.89 11,688.86 24,255.000.0046647PDG8 MORGAN STANLEY 6.296% 18OCT2028 (CALLABLE 18OCT27) 10,843.11(1,600.15) 22,513.28 0.000.0061747YEV3 PEPSICO INC 4.45% 15MAY2028 (CALLABLE 15APR28) 8,430.28(257.96) 30,901.09 0.000.00713448FR4 PHARMACIA LLC 6.6% 01DEC2028 5,683.33(1,225.68) 19,609.85 0.000.0071713UAW2 PNC BANK NA 3.3% 30OCT2024 (CALLABLE 30SEP24) 2,475.00(2,050.01) 2,247.06 0.000.0069353REF1 PNC FINANCIAL SERVICES 5.354% 02DEC2028 (CALLABLE 02DEC27) 6,915.59(130.41) 21,704.28 0.000.00693475BK0 TOYOTA MOTOR CREDIT CORP 1.9% 13JAN2027 1,636.111,642.16 13,974.00 9,500.000.0089236TJV8 TOYOTA MOTOR CREDIT CORP 2% 07OCT2024 1,722.22(1,144.45) 3,224.44 0.000.0089236TGL3 TOYOTA MOTOR CREDIT CORP 5.45% 10NOV2027 4,693.06(709.98) 13,774.98 0.000.0089236TKL8 US BANCORP 4.548% 22JUL2028 (CALLABLE 22JUL27) 3,916.33215.51 12,521.89 22,740.000.0091159HJF8 WALMART INC 2.65% 15DEC2024 (CALLABLE 15OCT24) 2,281.94(1,711.83) 2,011.87 0.000.00931142DV2 WALMART INC 3.7% 26JUN2028 (CALLABLE 26MAR28) 3,504.72917.17 17,207.34 0.000.00931142EE9 Total Corporate Bonds 141,136.1718,109.31 545,170.33 91,745.000.00 Government Agencies
FANNIE MAE 0.375% 25AUG2025 32 2.922,106.74 7,362.78 0.000.003135G05X7 FANNIE MAE 0.5% 17JUN2025 861.117,150.27 13,305.52 0.000.003135G04Z3 26 28

DETAIL OF RETURN AND INTEREST RECEIVED
For the period July 1, 2024 - July 31, 2024

CITY OF SIMI VALLEY
Description Interest earnedAccretion
(amortization)
Realized gain
(loss)
Change in fair
value
Interest receivedCusip
Government Agencies
FANNIE MAE 0.5% 18AUG2025 CALLABLE #0000 64 5.835,288.46 8,871.33 0.000.003136G4K85 FANNIE MAE 0.625% 22APR2025 1,076.393,914.92 10,266.44 0.000.003135G03U5 FANNIE MAE 0.77% 25NOV2026 (CALLABLE 25NOV24) 1,989.178,243.25 36,851.01 0.000.003135GA4N8 FEDERAL FARM CREDIT BANK 1.75% 15OCT2027 3,013.893,509.98 31,602.82 0.000.003133EKY34 FEDERAL FARM CREDIT BANK 3.875% 23DEC2026 10,010.41507.00 30,838.80 0.000.003133EN4X5 FEDERAL FARM CREDIT BANK 4% 06JAN2028 10,333.33(244.53) 42,132.72 60,000.000.003133EN5N6 FEDERAL FARM CREDIT BANK 4.125% 12MAR2029 7,104.17373.30 35,254.22 0.000.003133EP5J0 FEDERAL FARM CREDIT BANK 4.125% 20MAR2029 10,656.25360.80 53,013.39 0.000.003133EP5U5 FEDERAL FARM CREDIT BANK 4.25% 20NOV2024 7,319.451,607.40 3,735.66 0.000.003133EN6N5 FEDERAL FARM CREDIT BANK 4.375% 23JUN2026 5,651.0438.30 11,967.27 0.000.003133EPNG6 FEDERAL FARM CREDIT BANK 4.625% 17JUL2026 7,965.28(88.95) 17,215.14 46,250.000.003133EPQC2 FEDERAL HOME LOAN BANK 1.5% 15AUG2024 3,875.00285.41 10,271.88 0.000.003130AGWK7 FEDERAL HOME LOAN BANK 3.375% 12JUN2026 8,718.75(1,180.53) 24,139.38 0.000.003130ASJ59 FEDERAL HOME LOAN BANK 3.375% 13JUN2025 2,179.69(301.01) 3,142.93 0.000.003130ASG86 FEDERAL HOME LOAN BANK 4% 30JUN2028 6,666.67331.21 71,110.68 40,000.000.003130AWN63 FEDERAL HOME LOAN BANK 4.25% 10DEC2027 7,319.45(514.23) 24,293.40 0.000.003130ATUS4 FEDERAL HOME LOAN BANK 4.375% 09JUN2028 11,113.71(303.80) 45,057.32 0.000.003130AWMN7 FEDERAL HOME LOAN BANK 4.375% 12SEP2025 7,534.72(301.42) 5,918.58 0.000.003130ATHT7 FEDERAL HOME LOAN BANK 4.5% 12MAR2027 6,393.7569.72 16,519.93 0.000.003130AVBC5 FEDERAL HOME LOAN BANK 4.625% 11SEP2026 5,973.96157.32 12,942.50 0.000.003130AWTQ3 27 29

DETAIL OF RETURN AND INTEREST RECEIVED
For the period July 1, 2024 - July 31, 2024

CITY OF SIMI VALLEY
Description Interest earnedAccretion
(amortization)
Realized gain
(loss)
Change in fair
value
Interest receivedCusip
Government Agencies
FEDERAL HOME LOAN BANK 4.65% 23FEB2026 4, 004.1738.91 6,200.11 0.000.003130B0AL3 FREDDIE MAC 0% 11DEC2025 0.006,964.03 16,249.88 0.000.003134A2HG6 FREDDIE MAC 0.375% 21JUL2025 USD 484.375,172.27 8,438.79 2,812.500.003137EAEU9 FREDDIE MAC 1.5% 12FEB2025 2,583.336,051.14 8,836.94 0.000.003137EAEP0 Total Government Agencies 133,796.8149,235.96 555,539.42 149,062.500.00 Government Bonds
US TREASURY N/B 1.75% 06-30-2024 0. 000.00 0.00 27,125.000.009128286Z8 USA TREASURY 0.25% 30SEP2025 423.504,525.72 15,468.76 0.000.0091282CAM3 USA TREASURY 0.25% 31OCT2025 421.204,523.86 16,015.62 0.000.0091282CAT8 USA TREASURY 0.375% 30NOV2025 635.254,319.04 16,562.50 0.000.0091282CAZ4 USA TREASURY 0.375% 31JAN2026 638.744,308.70 18,046.86 3,750.000.0091282CBH3 USA TREASURY 0.625% 31JUL2026 1,064.563,385.18 21,875.00 6,250.000.0091282CCP4 USA TREASURY 0.75% 30APR2026 1,263.593,223.71 19,218.76 0.000.0091282CBW0 USA TREASURY 0.75% 31MAR2026 1,270.493,238.04 18,437.52 0.000.0091282CBT7 USA TREASURY 0.75% 31MAY2026 1,270.493,212.90 20,078.14 0.000.0091282CCF6 USA TREASURY 0.875% 30SEP2026 1,482.242,962.05 22,890.64 0.000.0091282CCZ2 USA TREASURY 1.25% 30APR2028 1,379.083,431.26 26,956.25 0.000.0091282CBZ3 USA TREASURY 1.375% 31JAN2025 1,756.52(1,083.34) 6,556.64 10,312.500.00912828Z52 USA TREASURY 1.5% 15FEB2025 1,277.472,811.29 4,537.11 0.000.0091282CDZ1 USA TREASURY 1.5% 30NOV2024 1,905.74(1,287.82) 5,044.92 0.000.00912828YV6 28 30

DETAIL OF RETURN AND INTEREST RECEIVED
For the period July 1, 2024 - July 31, 2024

CITY OF SIMI VALLEY
Description Interest earnedAccretion
(amortization)
Realized gain
(loss)
Change in fair
value
Interest receivedCusip
Government Bonds
USA TREASURY 1.5% 30SEP2024 2, 668.036,546.61 6,907.02 0.000.00912828YH7 USA TREASURY 1.625% 31OCT2026 4,243.555,793.35 34,632.80 0.000.00912828YQ7 USA TREASURY 1.875% 28FEB2027 2,369.222,728.55 18,457.04 0.000.0091282CEC1 USA TREASURY 2.75% 30JUN2025 2,316.581,591.47 4,940.10 13,750.000.00912828XZ8 USA TREASURY 2.75% 31AUG2025 2,084.921,355.37 4,746.10 0.000.009128284Z0 USA TREASURY 2.75% 31JUL2027 3,513.051,629.70 20,214.84 20,625.000.0091282CFB2 USA TREASURY 2.75% 31MAY2029 4,357.932,508.16 45,071.42 0.000.0091282CES6 USA TREASURY 2.875% 31JUL2025 2,448.491,450.16 5,164.07 14,375.000.00912828Y79 USA TREASURY 3.125% 31AUG2027 2,632.48541.51 13,750.00 0.000.0091282CFH9 USA TREASURY 3.625% 31MAR2028 3,377.39688.61 16,972.66 0.000.0091282CGT2 USA TREASURY 3.875% 30NOV2027 4,923.16255.39 21,210.95 0.000.0091282CFZ9 USA TREASURY 3.875% 31MAR2025 3,282.11825.22 2,830.07 0.000.0091282CGU9 USA TREASURY 4% 29FEB2028 5,054.3563.57 22,324.23 0.000.0091282CGP0 USA TREASURY 4.625% 28FEB2025 3,896.06329.69 1,783.20 0.000.0091282CGN5 USA TREASURY 4.625% 30SEP2028 7,834.70(1,063.62) 32,578.12 0.000.0091282CJA0 Total Government Bonds 69,790.8962,814.33 463,271.34 96,187.500.00 Short Term Bills and Notes
FEDERAL HOME LOAN BANK 5% 26FEB2025 #0000 8, 611.12228.32 2,986.02 0.000.003130B06G9 Total Short Term Bills and Notes 8,611.12228.32 2,986.02 0.000.00 Grand total 353,562.48130,387.92 1,566,967.11 337,222.490.00 29 31

TRANSACTION REPORT
For the period July 1, 2024 - July 31, 2024

CITY OF SIMI VALLEY
Maturity Par value or
shares
Interest Transaction totalPrincipalTransactionCusip Sec type DescriptionTrade date Settle date
Realized
gain(loss)
40,000.0006/30/2024
06/30/2024
Income3130AWN63 Government Agencies FEDERAL HOME LOAN BANK 4% 06/30/2028 2,000,000.00 0.00 40,000.000.00 27,125.0006/30/2024
06/30/2024
Income9128286Z8 Government Bonds US TREASURY N/B 1.75% 06/30/2024 3,100,000.00 0.00 27,125.000.00 13,750.0006/30/2024
06/30/2024
Income912828XZ8 Government Bonds USA TREASURY 2.75% 06/30/2025 1,000,000.00 0.00 13,750.000.00

0.0007/01/2024
07/01/2024
Capital Change9128286Z8 Government Bonds US TREASURY N/B 1.75% 06/30/2024 (3,100,000.00) 3,100,000.00 3,100,000.000.00 (2,995.92)07/01/2024
07/02/2024
Bought91282CBZ3 Government Bonds USA TREASURY 1.25% 04/30/2028 1,400,000.00 (1,239,989.07) (1,242,984.99)0.00 (4,808.74)07/01/2024
07/02/2024
Bought91282CES6 Government Bonds USA TREASURY 2.75% 05/31/2029 2,000,000.00 (1,849,928.58) (1,854,737.32)0.00 60,000.0007/06/2024
07/06/2024
Income3133EN5N6 Government Agencies FEDERAL FARM CREDIT BANK 01/06/2028 3,000,000.00 0.00 60,000.000.00 35,250.0007/12/2024
07/12/2024
Income02665WED9 Corporate Bonds AMERICAN HONDA FINANCE 01/12/2028 1,500,000.00 0.00 35,250.000.00 9,500.0007/13/2024
07/15/2024
Income89236TJV8 Corporate Bonds TOYOTA MOTOR CREDIT CORP 01/13/2027 1,000,000.00 0.00 9,500.000.00 46,250.0007/17/2024
07/17/2024
Income3133EPQC2 Government Agencies FEDERAL FARM CREDIT BANK 07/17/2026 2,000,000.00 0.00 46,250.000.00 2,812.5007/21/2024
07/21/2024
Income3137EAEU9 Government Agencies FREDDIE MAC 0.375% 07/21/2025 1,500,000.00 0.00 2,812.500.00 22,740.0007/22/2024
07/22/2024
Income91159HJF8 Corporate Bonds US BANCORP 4.548% 07/22/2028 1,000,000.00 0.00 22,740.000.00 24,255.0007/25/2024
07/25/2024
Income46647PDG8 Corporate Bonds JPMORGAN CHASE & CO 07/25/2028 1,000,000.00 0.00 24,255.000.00 14,375.0007/31/2024
07/31/2024
Income912828Y79 Government Bonds USA TREASURY 2.875% 07/31/2025 1,000,000.00 0.00 14,375.000.00 10,312.5007/31/2024
07/31/2024
Income912828Z52 Government Bonds USA TREASURY 1.375% 01/31/2025 1,500,000.00 0.00 10,312.500.00 3,750.0007/31/2024
07/31/2024
Income91282CBH3 Government Bonds USA TREASURY 0.375% 01/31/2026 2,000,000.00 0.00 3,750.000.00 6,250.0007/31/2024
07/31/2024
Income91282CCP4 Government Bonds USA TREASURY 0.625% 07/31/2026 2,000,000.00 0.00 6,250.000.00 30 32

TRANSACTION REPORT
For the period July 1, 2024 - July 31, 2024

CITY OF SIMI VALLEY
Maturity Par value or
shares
Interest Transaction totalPrincipalTransactionCusip Sec type DescriptionTrade date Settle date
Realized
gain(loss)
20,625.0007/31/2024
07/31/2024
Income91282CFB2 Government Bonds USA TREASURY 2.75% 07/31/2027 1,500,000.00 0.00 20,625.000.00 227.49Income Cash and Cash Equivalents Cash 227.490.00 0.000.0007/31/2024 31 33

ADDITIONAL INFORMATION
As of July 31, 2024

CITY OF SIMI VALLEY
The performance results shown, whether net or gross of investment management fees, reflect the reinvestment of dividends and/or income and other earnings. Any gross of fees performance does not include fees and charges and these can have a material detrimental effect on the performance of an investment. The performance shown is for the stated time period(s) only.

Any target performance aims are not a guarantee, may not be achieved and a capital loss may occur. Funds which have a higher performance aim generally take more risk to achieve this and so have a greater potential for the returns to be significantly different than expected. Investments are subject to risks, including loss of principal. There can be no guarantee that any investment strategy will meet the liability funding needs of a particular client.

Performance information for certain accounts may reflect performance achieved while the account was managed at a prior firm. In addition, the performance and customized benchmark information for these periods are based on Information from 3rd parties that Insight believes to be accurate, but Insight has not independently verified such information and no representation is made regarding its accuracy or completeness.

The quoted benchmarks do not reflect deductions for fees, expenses or taxes. These benchmarks are unmanaged and cannot be purchased directly by investors. Benchmark performance is shown for illustrative purposes only and does not predict or depict the performance of any investment. There may be material factors relevant to any such comparison such as differences in volatility, and regulatory and legal restrictions between the indices shown and the strategy.

Any currency conversions performed for this presentation, use FX rates as per WM Reuters 4pm spot rates, unless noted otherwise.

Funds and portfolios with an ESG objective follow a sustainable or ESG related investment approach, which may cause them to perform differently than funds that are not required to integrate sustainable investment criteria when selecting securities. Funds and portfolios with no ESG objective are not required to integrate sustainable investment criteria when selecting securities so any ESG approach shown is only indicative and there is no guarantee that the specific approach will be applied across the whole portfolio. . This document must not be used for the purpose of an offer or solicitation in any jurisdiction or in any circumstances in which such offer or solicitation is unlawful or otherwise not permitted. This document is intended only for the parties to whom it was delivered or its authorised agents and should not be copied or passed to any other person. Please contact the Client Services Team if there has been any change in your financial circumstances or risk tolerance since the previous valuation that could affect the investment objective of your portfolio. Insight obtains market data and prices from an independent pricing source for all of our currency positions on a daily basis. For trading activity the Clearing broker will be reflected. In certain cases the Clearing broker will differ from the Executing broker.

Some information contained in this client report comes from external sources which Insight believes to be reliable. A list of sources is available on request. All statistics represent month end figures unless otherwise noted. It should not be assumed that any of the security transactions or holdings referenced herein have been or will prove to be profitable or that future investment decisions will be profitable or will equal or exceed the past investment performance of the securities listed. Tax treatment depends on the individual circumstances of each investor and may be subject to change in the future. Insight does not provide tax or legal advice to its clients and all investors are strongly urged to seek professional advice regarding any potential strategy or investment. Material in this publication is for general information only and is not advice, investment advice, or the recommendation of any purchase or sale of any security.

Insight Investment is the corporate brand for certain companies operated by Insight Investment Management Limited (IIML). Insight includes, among others, Insight Investment Management (Global) Limited (IIMG), Insight Investment International Limited (IIIL) and Insight North America LLC (INA), each of which provides asset management services. This group of companies may be referred to as 'Insight' or 'Insight Investment'.

Please compare the information provided in this statement to the information provided in the statement received from your Custodian. This report is not intended to replace your custodial statement which is your official record for all pertinent account information. Please notify us promptly if you do not receive from your custodian on at least a quarterly basis account statements that contain the amount of funds and each security in the account at the end of the period and all transactions in the account during that period.

Investment advisory services in North America are provided through two different investment advisers registered with the Securities and Exchange Commission (SEC), using the brand Insight Investment: Insight North America LLC (INA) and Insight Investment International Limited (IIIL). The North American investment advisers are associated with other global investment managers that also (individually and collectively) use the corporate brand Insight Investment and may be referred to as 'Insight' or 'Insight Investment'. INA is registered with the CFTC as a Commodity Trading Advisor and a Commodity Pool Operator and are members of the NFA.

Information about the indices shown here is provided to allow for comparison of the performance of the strategy to that of certain well-known and widely recognized indices. There is no representation that such index is an appropriate benchmark for such comparison. You cannot invest directly in an index and the indices represented do not take into account trading commissions and/or other brokerage or custodial costs. The volatility of the indices may be materially different from that of the strategy. In addition, the strategy’s holdings may differ substantially from the securities that comprise the indices shown.

The ICE BofA 3 Month US T-Bill index is an unmanaged market index of U.S. Treasury securities maturing in 90 days that assumes reinvestment of all income.

The ICE BofA 6 Month US T-Bill index measures the performance of Treasury bills with time to maturity of less than 6 months. 32 34

ADDITIONAL INFORMATION
As of July 31, 2024

CITY OF SIMI VALLEY
The ICE BofA 1-Year US Treasury Index is a one-security index comprised of the most recently issued 1-year US Treasury note. The index is rebalanced monthly. In order to qualify for inclusion, a 1-year note must be auctioned on or before the third business day before the last business day of the month.

The ICE BofA 3-Year US Treasury Index is a one-security index comprised of the most recently issued 3-year US Treasury note. The index is rebalanced monthly. In order to qualify for inclusion, a 3-year note must be auctioned on or before the third business day before the last business day of the month.

The ICE BofA 5-Year US Treasury Index is a one-security index comprised of the most recently issued 5-year US Treasury note. The index is rebalanced monthly. In order to qualify for inclusion, a 5-year note must be auctioned on or before the third business day before the last business day of the month.

The ICE BofA 1-3 US Year Treasury Index is an unmanaged index that tracks the performance of the direct sovereign debt of the U.S. Government having a maturity of at least one year and less than three years.

The ICE BofA 1-5 US Year Treasury Index is an unmanaged index that tracks the performance of the direct sovereign debt of the U.S. Government having a maturity of at least one year and less than five years. © 2024 Insight Investment. All rights reserved.
33 35

Simi Valley City CouncilAugust 19, 2024

Simi Valley City Council
August 19, 2024