Cities Index.
Staff Report

Simi Valley City Council
January 23, 2023

Document
Staff Report
Meeting
January 23, 2023
Body
Simi Valley City Council
Original file
1.4 MB
Text extracted from the city's file for reading and search. Open the original on simivalley.granicus.com. That file is the official record.

CITY OF SIMI VALLEY

MEMORANDUM
J
anuary 23, 2023
TO: City Council
F
ROM: Department of Administrative Services
S
UBJECT: APPROVAL OF THE MONTHLY INVESTMENT REPORT FOR THE MONTH ENDED DECEMBER 31, 2022
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: 61%
o U.S. Treasury: 11%
o U.S. Agencies: 16%
o Corporate Bonds: 12%
• A
listing of individual securities held at the end of the reporting period by authorized investment category. Includes 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: 1.92 years • W
eighted Average Yield on Advisor Managed portfolio: 1.89% 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 increased from 4.13% on November 30, 2022 to 4.22% on December 30, 2022.

A Fixed Income Market Review through December 31, 2022 is included to provide the current economic conditions.
• T
he fair market value of all investments as of December 31, 2022 held by the City (excluding investments held by bond trustee): $229,500,296.

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 (4)
City Managed Assets % Return
CAMP 5,229,366$ 2% 4.30%
LAIF 135,073,967$ 59% 2.17%
Total Internally Managed 140,303,333$ 61%
Weighted Average Yield 2.25%
Days
Effective Average Duration - Internal 1
Weighted Average Maturity - Internal 1
Advisor Managed Assets % Return
Treasury Securities 25,723,691$ 11% 2.24%
Instrumentality Securities 35,402,272$ 16% 1.87% Corporate 28,070,999$ 12% 1.61%
Total Externally Managed 89,196,962$ 39%
Weighted Average Yield 1.89%
Years
Effective Average Duration - External 1.74
Weighted Average Maturity - External 1.92
Total Portfolio Assets % Return
CAMP 5,229,366$ 2% 4.30%
LAIF 135,073,967$ 59% 2.17%
Treasury Securities 25,723,691$ 11% 2.24%
Instrumentality Securities 35,402,272$ 16% 1.87% Corporate 28,070,999$ 12% 1.61%
Total Portfolio Assets 229,500,296$
Weighted Average Yield 2.11%
Years
Effective Average Duration - Total 0.68
Weighted Average Maturity - Total 0.75
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.
229,500,296$
216,605,440$
Monthly Consolidated Portfolio Report
December 31, 2022
City of Simi Valley
CAMP, 2%
LAIF, 59%
Treasury
Securities,
11%
Instrumentality Securities, 16%
Corporate,
12%
CAMP
2%
LAIF
59%
Treasury
Securities
11%
Instrumentality
Securities
16%
Corporate
12%
2 FIXED INCOME MARKET REVIEW
As of December 31, 2022

CITY OF SIMI VALLEY
Chart 1: The Fed adjusted its dot plot again, but to a lower extent again Source: Federal Reserve, December 31, 2022
Chart 2: Wage growth remained strong
Source: Bloomberg, December 31, 2022
Economic Indicators and Monetary Policy
The Federal Reserve, as expected, announced a “downshift” in its policy tightening. It raised the upper bound of its policy rate by 50bp, from 4% to 4.5%, following four consecutive 75bp hikes. The Fed was, however, clear that it still has more hiking to do in 2023. Fed Chair Powell stated that rates are still “not sufficiently restrictive”. The Fed once again raised its “dot plot” projections, albeit to a lesser extent than they have at each quarterly meeting this year (see Chart 1). The Fed's most notable (and most anticipated) change was to its 2023 year-end forecast, now at 5.13%, up from 4.65%. Only two of the 19 voting members projected a lower rate (at 4.88%).

For the second month in a row, inflation came in lower than expected. Headline CPI was 0.1% month-on-month and core CPI was 0.2%, taking the year-on-year figures to 7.1% (the lowest since last December) and 6% (the lowest since July), respectively. Most areas of the report offered good news, outside of the stubborn rental and food components. For the second month in a row, core goods prices were in deflation, this time at -0.4% month-on-month. Used car prices were the second largest negative contributor and leading indicators, such as the Manheim Used Car Index, fell -14.2% last month, its largest decrease ever.

The labor market remained tight. US economy added 263,000 new jobs in November, above consensus for 200,000. Job growth was broad-based. The service sector remained strong with leisure and hospitality up 88,000. Wage growth surged higher, up 0.6%, or 5.1% year-on- year, raising further inflation concerns (Chart 2). The unemployment rate stayed at 3.7%. The participation rate fell from 62.2% to 62.1%. The ratio of jobs to unemployed people remained at ~1.7.

The housing market also continued to struggle. Existing home sales have fallen 40% from the peak in late 2020. Building permits fell by 11.2% month-on-month in November and housing starts fell 0.5% month-on-month.

Interest Rate Summary
Yields rose toward the belly of the curve. At the end of December, the 3-month US Treasury bill yielded 4.41%, the 6-month US Treasury bill yielded 4.77%, the 2-year US Treasury note yielded 4.43%, the 5-year US Treasury note yielded 4.01% and the 10-year US Treasury note yielded 3.88%.
/uni0033
3 ACTIVITY AND PERFORMANCE SUMMARY
For the period December 1, 2022 - December 31, 2022

CITY OF SIMI VALLEY
Amortized Cost Basis Activity Summary
87,370,810.53Opening balanceOpening balanceOpening balanceOpening balance 79,448.51Income received
79,448.51Total receiptsTotal receiptsTotal receiptsTotal receipts

0.00Total disbursementsTotal disbursementsTotal disbursementsTotal disbursements 4,798,833.90Interportfolio transfers
4,798,833.90Total Interportfolio transfersTotal Interportfolio transfersTotal Interportfolio transfersTotal Interportfolio transfers

0.00Realized gain (loss)

0.00Change in accruals from security movement
(50,335.83)Total amortization expenseTotal amortization expenseTotal amortization expenseTotal amortization expense 50,153.25Total OID/MKT accretion incomeTotal OID/MKT accretion incomeTotal OID/MKT accretion incomeTotal OID/MKT accretion income

0.00Return of capital
Closing balanceClosing balanceClosing balanceClosing balance 92,248,910.36 Ending fair valueEnding fair valueEnding fair valueEnding fair value 89,196,962.39 (3,051,947.97)Unrealized gain (loss)
Comparative Rates of Return (%)
* Twelve
month trailing
* Six
month trailing
* One month
Fed Funds 1.68 1.46 0.34
Overnight Repo 1.64 1.44 0.34
Merrill Lynch 3m US Treas Bill1.95 1.62 0.35
Merrill Lynch 6m US Treas Bill2.30 1.80 0.37
ML 1 Year US Treasury Note 2.79 2.00 0.39
ML 2 Year US Treasury Note 2.98 1.94 0.36
ML 5 Year US Treasury Note 2.86 1.66 0.31
* rates reflected are cumulative
Summary of Amortized Cost Basis Return for the Period
Total portfolio
Interest earned 141,470.66
Accretion (amortization) (182.58)
Realized gain (loss) on sales 0.00
Total income on portfolio 141,288.08
Average daily amortized cost 88,944,008.72
Period return (%)
Weighted average final maturity in days 699
YTD return (%)
Detail of Amortized Cost Basis Return
Interest
earned
Realized
gain (loss)
Accretion
(amortization)
Total
income

0.00Cash and Cash Equivalents10.90 0.00 10.90

0.00Corporate Bonds 64,107.89 (27,171.35) 36,936.54

0.00Government Agencies57,003.63 (2,523.92) 54,479.71

0.00Government Bonds 20,348.24 29,512.69 49,860.93
Total 141,470.66 (182.58) 0.00 141,288.08

0.16 1.45
/uni0034
4 ACTIVITY AND PERFORMANCE SUMMARY
For the period December 1, 2022 - December 31, 2022

CITY OF SIMI VALLEY
Fair Value Basis Activity Summary
84,321,152.86Opening balanceOpening balanceOpening balanceOpening balance 79,448.51Income received
79,448.51Total receiptsTotal receiptsTotal receiptsTotal receipts

0.00Total disbursementsTotal disbursementsTotal disbursementsTotal disbursements 4,798,833.90Interportfolio transfers
4,798,833.90Total Interportfolio transfersTotal Interportfolio transfersTotal Interportfolio transfersTotal 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 (2,472.88)
Ending fair valueEnding fair valueEnding fair valueEnding fair value 89,196,962.39 Comparative Rates of Return (%)
* Twelve
month trailing
* Six
month trailing
* One month
Fed Funds 1.68 1.46 0.34
Overnight Repo 1.64 1.44 0.34
ICE Bofa 3 Months US T-BILL 1.46 1.31 0.36
ICE Bofa 6m US Treas Bill 1.34 1.35 0.43
ICE Bofa 1 Yr US Treasury Note(1.02) 0.25 0.39
ICE BofA US Treasury 1-3 (3.65) (0.84) 0.20
ICE BofA US Treasury 1-5 (5.25) (1.35) 0.06
* rates reflected are cumulative
Detail of Fair Value Basis Return
Interest
earned
Change in
fair value
Total
income
Cash and Cash Equivalents10.90 0.00 10.90
Corporate Bonds 64,107.89 (35,839.50) 28,268.39
Government Agencies 57,003.63 45,030.12 102,033.75
Government Bonds 20,348.24 (11,663.50) 8,684.74
Total 141,470.66 (2,472.88) 138,997.78
Summary of Fair Value Basis Return for the Period
Total portfolio
Interest earned 141,470.66
Total income on portfolio 138,997.78
Average daily total value * 86,455,578.24
Period return (%) 0.17
Weighted average final maturity in days 699
Change in fair value (2,472.88)
YTD return (%) (2.93)
* Total value equals market value and accrued interest
/uni0035
5 RECAP OF SECURITIES HELD
As of December 31, 2022

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 29,792,759.00 29,013,398.66 28,070,999.41 (942,399.25) 641 31.98 1.43 Government Agencies 36,679,393.20 36,440,815.64 35,402,271.56 (1,038,544.08) 571 39.38 1.47 Government Bonds 26,677,430.86 26,794,696.06 25,723,691.42 (1,071,004.64) 941 28.64 2.47 Total 93,149,583.06 92,248,910.36 89,196,962.39 (3,051,947.97) 699 100.00 1.74 Corporate Bonds
Government Agencies
Government Bonds
Portfolio diversification (%)
Corporate Bonds 31.98
Government Agencies 39.38
Government Bonds 28.64
Portfolio diversification (%)
6 MATURITY DISTRIBUTION OF SECURITIES HELD
As of December 31, 2022

CITY OF SIMI VALLEY
Maturity Historic cost Percent
Under 90 days 4,002,897.50 4.30
90 to 179 days 5,584,468.38 6.00
180 days to 1 year 11,469,630.95 12.31
1 to 2 years 35,757,322.11 38.39
2 to 3 years 14,486,028.88 15.55
3 to 4 years 16,056,782.83 17.24
4 to 5 years 5,792,452.41 6.22
Over 5 years 0.00 0.00
93,149,583.06 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
/uni0037
7 SECURITIES HELD
As of December 31, 2022

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
88579YAX9 2 .250 03/15/2023 1,009,680.00 1,000,366.67 (5,908.56) 6,625.00 02/15/2023

1.08994,458.111,000,000.003M COMPANY 2.25% 15MAR2023 (CALLABLE 15FEB23) 02665WDH1 1.950 05/10/2023 1,513,980.00 1,502,800.53 (20,325.34) 4,143.75 1.631,482,475.191,500,000.00AMERICAN HONDA FINANCE 1.95% 10MAY2023 89236THU2 0.450 01/11/2024 998,680.00 999,409.26 (42,534.33) 2,125.00 1.07956,874.931,000,000.00TOYOTA MOTOR CREDIT CORP 0.45% 11JAN2024 17325FAS7 3.650 01/23/2024 2,152,740.00 2,059,708.99 (87,375.83) 32,038.89 12/23/2023

2.311,972,333.162,000,000.00CITIBANK NA 3.65% 23JAN2024 (CALLABLE 23DEC23) 693475AV7 3.500 01/23/2024 1,610,865.00 1,544,828.57 (66,648.81) 23,041.67 12/24/2023

1.731,478,179.761,500,000.00PNC FINANCIAL SERVICES 3.5% 23JAN2024 (CALLABLE 23DEC23)
46625HJT8 3.875 02/01/2024 1,013,422.00 966,698.99 (28,773.77) 15,338.54 1.09937,925.22950,000.00JPMORGAN CHASE & CO 3.875% 01FEB2024 91159HHV5 3.375 02/05/2024 1,086,930.00 1,028,456.91 (46,032.35) 13,687.50 01/05/2024

1.17982,424.561,000,000.00US BANCORP 3.375% 05FEB2024 (CALLABLE 05JAN24) 17275RAN2 3.625 03/04/2024 963,333.00 917,949.99 (32,274.77) 10,603.13 1.03885,675.22900,000.00CISCO SYSTEMS INC 3.625% 04MAR2024 06051GHF9 3.550 03/05/2024 1,784,363.00 1,706,753.68 (12,810.56) 19,446.11 03/05/2023

1.921,693,943.121,700,000.00BANK OF AMERICA CORP 3.55% 05MAR2024 (CALLABLE 05MAR23)
931142DP5 3.300 04/22/2024 1,079,400.00 1,029,736.08 (49,772.35) 6,325.00 01/22/2024

1.16979,963.731,000,000.00WALMART INC 3.3% 22APR2024 (CALLABLE 22JAN24) 46647PAP1 3.559 04/23/2024 1,074,370.00 1,008,362.00 (14,865.08) 6,722.56 04/23/2023

1.15993,496.921,000,000.00JPMORGAN CHASE & CO 3.559% 23APR2024 (CALLABLE 23APR23)
459200JY8 3.000 05/15/2024 2,141,560.00 2,061,846.60 (116,073.16) 7,666.67 2.301,945,773.442,000,000.00IBM CORP 3% 15MAY2024 /uni0038
8 SECURITIES HELD
As of December 31, 2022

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
46647PBQ8 1 .514 06/01/2024 1,023,520.00 1,003,794.36 (19,982.71) 1,261.67 06/01/2023

1.10983,811.651,000,000.00JPMORGAN CHASE & CO 1.514% 01JUN2024 (CALLABLE 01JUN23)
95000U2R3 1.654 06/02/2024 1,018,650.00 1,002,715.33 (18,760.05) 1,332.39 06/02/2023

1.09983,955.281,000,000.00WELLS FARGO & COMPANY 1.654% 02JUN2024 (CALLABLE 02JUN23)
06051GHL6 3.864 07/23/2024 1,604,940.00 1,526,931.50 (40,509.99) 25,438.00 07/23/2023

1.721,486,421.511,500,000.00BANK OF AMERICA CORP 3.864% 23JUL2024 (CALLABLE 23JUL23)
89236TGL3 2.000 10/07/2024 1,046,770.00 1,024,300.56 (72,148.21) 4,666.67 1.12952,152.351,000,000.00TOYOTA MOTOR CREDIT CORP 2% 07OCT2024 69353REF1 3.300 10/30/2024 992,934.00 943,050.31 (66,973.39) 4,950.00 09/30/2024

1.07876,076.92900,000.00PNC BANK NA 3.3% 30OCT2024 (CALLABLE 30SEP24) 931142DV2 2.650 12/15/2024 1,063,680.00 1,036,804.30 (75,138.75) 1,177.78 10/15/2024

1.14961,665.551,000,000.00WALMART INC 2.65% 15DEC2024 (CALLABLE 15OCT24) 166764BW9 1.554 05/11/2025 1,905,680.00 1,925,885.21 (63,639.15) 4,316.67 04/11/2025

2.051,862,246.062,000,000.00CHEVRON CORP 1.554% 11MAY2025 (CALLABLE 11APR25)
037833BZ2 2.450 08/04/2026 949,070.00 953,160.33 (24,605.20) 10,004.17 05/04/2026

1.02928,555.131,000,000.00APPLE INC 2.45% 04AUG2026 (CALLABLE 04MAY26) 02665WDZ1 1.300 09/09/2026 966,482.00 971,042.57 851.79 4,448.89 1.04971,894.361,100,000.00AMERICAN HONDA FINANCE 1.3% 09SEP2026 89236TJV8 1.900 01/13/2027 914,170.00 920,464.93 (26,927.11) 8,866.67 0.98893,537.821,000,000.00TOYOTA MOTOR CREDIT CORP 1.9% 13JAN2027 037833DB3 2.900 09/12/2027 1,877,540.00 1,878,330.99 (11,171.57) 17,561.11 06/12/2027

2.021,867,159.422,000,000.00APPLE INC 2.9% 12SEP2027 (CALLABLE 12JUN27) Total Corporate Bonds 29,792,759.00 29,013,398.66 28,070,999.41 (942,399.25) 31.98231,787.8429,050,000.00 /uni0039
9 SECURITIES HELD
As of December 31, 2022

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
3133EKKT2 2 .250 02/08/2023 2,993,217.50 2,951,266.20 (7,486.84) 26,365.63 3.212,943,779.362,950,000.00FEDERAL FARM CREDIT BANK 2.25% 08FEB2023 3137EAEN5 2.750 06/19/2023 2,072,754.00 2,009,907.68 (26,784.32) 1,833.33 2.231,983,123.362,000,000.00FREDDIE MAC 2.75% 19JUN2023 3133EKZK5 1.600 08/14/2023 3,006,447.00 3,001,007.06 (58,485.77) 18,266.67 3.232,942,521.293,000,000.00FEDERAL FARM CREDIT BANK 1.6% 14AUG2023 3137EAEW5 0.250 09/08/2023 1,500,690.00 1,500,204.69 (45,338.50) 1,177.08 1.611,454,866.191,500,000.00FREDDIE MAC 0.25% 08SEP2023 3135G0U43 2.875 09/12/2023 2,977,768.50 2,888,056.96 (54,944.09) 24,982.95 3.202,833,112.872,870,000.00FANNIE MAE 2.875% 12SEP2023 3133EMCQ3 0.280 10/13/2023 1,998,000.00 1,999,475.93 (71,844.97) 1,213.33 2.141,927,630.962,000,000.00FEDERAL FARM CREDIT BANK 0.28% 13OCT2023 (CALLABLE 11JAN23)
3135G0V34 2.500 02/05/2024 3,003,669.20 2,926,401.89 (95,128.58) 29,402.78 3.222,831,273.312,900,000.00FANNIE MAE 2.5% 05FEB2024 3133ELNJ9 1.550 02/28/2024 1,003,930.00 1,000,000.00 (39,014.48) 5,295.83 1.08960,985.521,000,000.00FEDERAL FARM CREDIT BANK 1.55% 28FEB2024 (CALLABLE 11JAN23)
3130ALSG0 0.250 03/08/2024 1,497,735.00 1,499,045.85 (76,006.39) 1,177.08 1.611,423,039.461,500,000.00FEDERAL HOME LOAN BANK 0.25% 08MAR2024 3133EMBE1 0.300 03/28/2024 2,996,250.00 2,998,641.88 (163,039.39) 2,325.00 3.222,835,602.493,000,000.00FEDERAL FARM CREDIT BANK 0.3% 28MAR2024 (CALLABLE 11JAN23)
3130AGWK7 1.500 08/15/2024 2,983,827.00 2,994,434.59 (143,385.88) 17,000.00 3.202,851,048.713,000,000.00FEDERAL HOME LOAN BANK 1.5% 15AUG2024 3135G03U5 0.625 04/22/2025 1,868,850.00 1,891,426.07 (52,527.33) 2,395.83 2.011,838,898.742,000,000.00FANNIE MAE 0.625% 22APR2025 /uni0031/uni0030
10 SECURITIES HELD
As of December 31, 2022

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
3130ASG86 3 .375 06/13/2025 760,365.00 758,859.92 (28,364.53) 1,265.63 0.82730,495.39750,000.00FEDERAL HOME LOAN BANK 3.375% 13JUN2025 3135G05X7 0.375 08/25/2025 918,750.00 932,935.39 (30,253.23) 1,312.50 0.99902,682.161,000,000.00FANNIE MAE 0.375% 25AUG2025 3130ATHT7 4.375 09/12/2025 2,010,640.00 2,009,765.89 (5,185.01) 22,604.17 2.162,004,580.882,000,000.00FEDERAL HOME LOAN BANK 4.375% 12SEP2025 3130ASJ59 3.375 06/12/2026 3,055,800.00 3,048,874.19 (125,360.54) 5,343.75 3.282,923,513.653,000,000.00FEDERAL HOME LOAN BANK 3.375% 12JUN2026 3130ATUS4 4.250 12/10/2027 2,030,700.00 2,030,511.45 (15,394.23) 13,458.33 2.182,015,117.222,000,000.00FEDERAL HOME LOAN BANK 4.25% 10DEC2027 Total Government Agencies 36,679,393.20 36,440,815.64 35,402,271.56 (1,038,544.08) 39.38175,419.8936,470,000.00 Government Bonds
912828R69 1
.625 05/31/2023 1,997,734.38 1,999,739.05 (23,254.67) 2,767.86 2.141,976,484.382,000,000.00USA TREASURY 1.625% 31MAY2023 91282CDM0 0.500 11/30/2023 1,986,725.45 1,993,565.02 (69,346.26) 851.65 2.131,924,218.762,000,000.00USA TREASURY 0.5% 30NOV2023 912828V23 2.250 12/31/2023 2,065,944.20 2,031,299.91 (80,206.15) 22,500.00 2.221,951,093.762,000,000.00USA TREASURY 2.25% 31DEC2023 912828YV6 1.500 11/30/2024 1,549,809.71 1,529,079.90 (108,884.58) 1,916.21 1.661,420,195.321,500,000.00USA TREASURY 1.5% 30NOV2024 912828Z52 1.375 01/31/2025 1,544,067.52 1,526,629.22 (116,101.88) 8,575.07 1.661,410,527.341,500,000.00USA TREASURY 1.375% 31JAN2025 91282CAM3 0.250 09/30/2025 1,827,584.83 1,853,425.21 (55,847.09) 1,263.74 1.961,797,578.122,000,000.00USA TREASURY 0.25% 30SEP2025 /uni0031/uni0031
11 SECURITIES HELD
As of December 31, 2022

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,848,961.48 (58,805.24) 842.54 1.961,790,156.242,000,000.00USA TREASURY 0.25% 31OCT2025 91282CAZ4 0.375 11/30/2025 1,826,959.83 1,851,620.14 (60,917.02) 638.74 1.961,790,703.122,000,000.00USA TREASURY 0.375% 30NOV2025 91282CBH3 0.375 01/31/2026 1,818,756.70 1,843,357.98 (62,186.10) 3,118.21 1.951,781,171.882,000,000.00USA TREASURY 0.375% 31JAN2026 91282CBT7 0.750 03/31/2026 1,859,928.58 1,876,118.79 (81,431.29) 3,791.21 2.001,794,687.502,000,000.00USA TREASURY 0.75% 31MAR2026 91282CBW0 0.750 04/30/2026 1,857,428.58 1,873,547.16 (83,547.16) 2,527.62 1.991,790,000.002,000,000.00USA TREASURY 0.75% 30APR2026 91282CCF6 0.750 05/31/2026 1,854,694.20 1,870,758.68 (84,899.30) 1,277.47 1.991,785,859.382,000,000.00USA TREASURY 0.75% 31MAY2026 91282CCP4 0.625 07/31/2026 1,840,241.07 1,857,167.00 (87,792.00) 5,197.01 1.981,769,375.002,000,000.00USA TREASURY 0.625% 31JUL2026 91282CCZ2 0.875 09/30/2026 1,854,381.70 1,869,191.96 (90,910.72) 4,423.08 1.991,778,281.242,000,000.00USA TREASURY 0.875% 30SEP2026 91282CFH9 3.125 08/31/2027 970,042.41 970,234.56 (6,875.18) 10,531.77 1.04963,359.381,000,000.00USA TREASURY 3.125% 31AUG2027 Total Government Bonds 26,677,430.86 26,794,696.06 25,723,691.42 (1,071,004.64) 28.6470,222.1828,000,000.00 Grand total 93,149,583.06 92,248,910.36 (3,051,947.97)93,520,000.00 100.00477,429.9189,196,962.39 /uni0031/uni0032
12 GASB 40 - DEPOSIT AND INVESTMENT RISK DISCLOSURE
As of December 31, 2022

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
912828R69 US A TREASURY 1.625% 1.625 05/31/2023 AA+ Aaa 2,000,000.00 1,997,734.38 2.14 1,976,484.38 2.22 0.41 91282CDM0 USA TREASURY 0.5% 0.500 11/30/2023 AA+ Aaa 2,000,000.00 1,986,725.45 2.13 1,924,218.76 2.16 0.89 912828V23 USA TREASURY 2.25% 2.250 12/31/2023 AA+ Aaa 2,000,000.00 2,065,944.20 2.22 1,951,093.76 2.19 0.97 912828YV6 USA TREASURY 1.5% 1.500 11/30/2024 AA+ Aaa 1,500,000.00 1,549,809.71 1.66 1,420,195.32 1.59 1.85 912828Z52 USA TREASURY 1.375% 1.375 01/31/2025 AA+ Aaa 1,500,000.00 1,544,067.52 1.66 1,410,527.34 1.58 2.00 91282CAM3 USA TREASURY 0.25% 0.250 09/30/2025 AA+ Aaa 2,000,000.00 1,827,584.83 1.96 1,797,578.12 2.02 2.67 91282CAT8 USA TREASURY 0.25% 0.250 10/31/2025 AA+ Aaa 2,000,000.00 1,823,131.70 1.96 1,790,156.24 2.01 2.75 91282CAZ4 USA TREASURY 0.375% 0.375 11/30/2025 AA+ Aaa 2,000,000.00 1,826,959.83 1.96 1,790,703.12 2.01 2.83 91282CBH3 USA TREASURY 0.375% 0.375 01/31/2026 AA+ Aaa 2,000,000.00 1,818,756.70 1.95 1,781,171.88 2.00 2.99 91282CBT7 USA TREASURY 0.75% 0.750 03/31/2026 AA+ Aaa 2,000,000.00 1,859,928.58 2.00 1,794,687.50 2.01 3.12 91282CBW0 USA TREASURY 0.75% 0.750 04/30/2026 AA+ Aaa 2,000,000.00 1,857,428.58 1.99 1,790,000.00 2.01 3.20 91282CCF6 USA TREASURY 0.75% 0.750 05/31/2026 AA+ Aaa 2,000,000.00 1,854,694.20 1.99 1,785,859.38 2.00 3.29 91282CCP4 USA TREASURY 0.625% 0.625 07/31/2026 AA+ Aaa 2,000,000.00 1,840,241.07 1.98 1,769,375.00 1.98 3.44 91282CCZ2 USA TREASURY 0.875% 0.875 09/30/2026 AA+ Aaa 2,000,000.00 1,854,381.70 1.99 1,778,281.24 1.99 3.59 91282CFH9 USA TREASURY 3.125% 3.125 08/31/2027 AA+ Aaa 1,000,000.00 970,042.41 1.04 963,359.38 1.08 4.22 Issuer total 28,000,000.00 26,677,430.86 28.64 25,723,691.42 28.84 2.47 Federal Home Loan Banks
3130ALSG0 FE
DERAL HOME LOAN 0.250 03/08/2024 AA+ Aaa 1,500,000.00 1,497,735.00 1.61 1,423,039.46 1.60 1.16 3130AGWK7 FEDERAL HOME LOAN 1.500 08/15/2024 AA+ Aaa 3,000,000.00 2,983,827.00 3.20 2,851,048.71 3.20 1.56 3130ASG86 FEDERAL HOME LOAN 3.375 06/13/2025 AA+ Aaa 750,000.00 760,365.00 0.82 730,495.39 0.82 2.31 3130ATHT7 FEDERAL HOME LOAN 4.375 09/12/2025 AA+ Aaa 2,000,000.00 2,010,640.00 2.16 2,004,580.88 2.25 2.49 3130ASJ59 FEDERAL HOME LOAN 3.375 06/12/2026 AA+ Aaa 3,000,000.00 3,055,800.00 3.28 2,923,513.65 3.28 3.20 3130ATUS4FEDERAL HOME LOAN 4.250 12/10/2027 AA+ Aaa 2,000,000.00 2,030,700.00 2.18 2,015,117.22 2.26 4.37 Issuer total 12,250,000.00 12,339,067.00 13.25 11,947,795.31 13.39 2.58 /uni0031/uni0033
13 GASB 40 - DEPOSIT AND INVESTMENT RISK DISCLOSURE
As of December 31, 2022

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
3133EKKT2 FE DERAL FARM CREDIT 2.250 02/08/2023 AA+ Aaa 2,950,000.00 2,993,217.50 3.21 2,943,779.36 3.30 0.11 3133EKZK5 FEDERAL FARM CREDIT 1.600 08/14/2023 AA+ Aaa 3,000,000.00 3,006,447.00 3.23 2,942,521.29 3.30 0.60 3133EMCQ3 FEDERAL FARM CREDIT 0.280 10/13/2023 AA+ Aaa 2,000,000.00 1,998,000.00 2.14 1,927,630.96 2.16 0.77 3133ELNJ9 FEDERAL FARM CREDIT 1.550 02/28/2024 AA+ Aaa 1,000,000.00 1,003,930.00 1.08 960,985.52 1.08 1.12 3133EMBE1 FEDERAL FARM CREDIT 0.300 03/28/2024 AA+ Aaa 3,000,000.00 2,996,250.00 3.22 2,835,602.49 3.18 1.20 Issuer total 11,950,000.00 11,997,844.50 12.88 11,610,519.62 13.02 0.70 Federal National Mortgage Association
3135G0U43 FA
NNIE MAE 2.875% 2.875 09/12/2023 AA+ Aaa 2,870,000.00 2,977,768.50 3.20 2,833,112.87 3.18 0.68 3135G0V34 FANNIE MAE 2.5% 2.500 02/05/2024 AA+ Aaa 2,900,000.00 3,003,669.20 3.22 2,831,273.31 3.17 1.05 3135G03U5 FANNIE MAE 0.625% 0.625 04/22/2025 AA+ Aaa 2,000,000.00 1,868,850.00 2.01 1,838,898.74 2.06 2.23 3135G05X7 FANNIE MAE 0.375% 0.375 08/25/2025 AA+ Aaa 1,000,000.00 918,750.00 0.99 902,682.16 1.01 2.57 Issuer total 8,770,000.00 8,769,037.70 9.41 8,405,967.08 9.42 1.34 Federal Home Loan Mortgage Corp
3137EAEN5 FR EDDIE MAC 2.75% 2.750 06/19/2023 AA+ Aaa 2,000,000.00 2,072,754.00 2.23 1,983,123.36 2.22 0.46 3137EAEW5 FREDDIE MAC 0.25% 0.250 09/08/2023 AA+ Aaa 1,500,000.00 1,500,690.00 1.61 1,454,866.19 1.63 0.67 Issuer total 3,500,000.00 3,573,444.00 3.84 3,437,989.55 3.85 0.55 Bank of America Corp
06051GHF9 BA NK OF AMERICA CORP 3.550 03/05/2024 03/05/2023 A- A2 1,700,000.00 1,784,363.00 1.92 1,693,943.12 1.90 0.18 06051GHL6 BANK OF AMERICA CORP 3.864 07/23/2024 07/23/2023 A- A2 1,500,000.00 1,604,940.00 1.72 1,486,421.51 1.67 0.54 Issuer total 3,200,000.00 3,389,303.00 3.64 3,180,364.63 3.57 0.35 JPMorgan Chase & Co
46625HJT8 JP
MORGAN CHASE & CO 3.875 02/01/2024 A- A1 950,000.00 1,013,422.00 1.09 937,925.22 1.05 1.03 46647PAP1 JPMORGAN CHASE & CO 3.559 04/23/2024 04/23/2023 A- A1 1,000,000.00 1,074,370.00 1.15 993,496.92 1.11 0.31 /uni0031/uni0034
14 GASB 40 - DEPOSIT AND INVESTMENT RISK DISCLOSURE
As of December 31, 2022

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
JPMorgan Chase & Co
46647PBQ8 JP MORGAN CHASE & CO 1.514 06/01/2024 06/01/2023 A- A1 1,000,000.00 1,023,520.00 1.10 983,811.65 1.10 0.41 Issuer total 2,950,000.00 3,111,312.00 3.34 2,915,233.79 3.27 0.58 Toyota Motor Credit Corp
89236THU2 TO
YOTA MOTOR CREDIT 0.450 01/11/2024 A+ A1 1,000,000.00 998,680.00 1.07 956,874.93 1.07 1.00 89236TGL3 TOYOTA MOTOR CREDIT 2.000 10/07/2024 A+ A1 1,000,000.00 1,046,770.00 1.12 952,152.35 1.07 1.69 89236TJV8 TOYOTA MOTOR CREDIT 1.900 01/13/2027 A+ A1 1,000,000.00 914,170.00 0.98 893,537.82 1.00 3.75 Issuer total 3,000,000.00 2,959,620.00 3.18 2,802,565.10 3.14 2.09 Apple Inc
037833BZ2 AP
PLE INC 2.45% 2.450 08/04/2026 05/04/2026 AA+ Aaa 1,000,000.00 949,070.00 1.02 928,555.13 1.04 3.26 037833DB3 APPLE INC 2.9% 2.900 09/12/2027 06/12/2027 AA+ Aaa 2,000,000.00 1,877,540.00 2.02 1,867,159.42 2.09 4.19 Issuer total 3,000,000.00 2,826,610.00 3.03 2,795,714.55 3.13 3.88 American Honda Finance Corp
02665WDH1 AM
ERICAN HONDA 1.950 05/10/2023 A- A3 1,500,000.00 1,513,980.00 1.63 1,482,475.19 1.66 0.35 02665WDZ1AMERICAN HONDA 1.300 09/09/2026 A- A3 1,100,000.00 966,482.00 1.04 971,894.36 1.09 3.49 Issuer total 2,600,000.00 2,480,462.00 2.66 2,454,369.55 2.75 1.57 Citibank NA
17325FAS7 CI TIBANK NA 3.65% 3.650 01/23/2024 12/23/2023 A+ Aa3 2,000,000.00 2,152,740.00 2.31 1,972,333.16 2.21 0.99 Issuer total 2,000,000.00 2,152,740.00 2.31 1,972,333.16 2.21 0.99 International Business Machines Corp
459200JY8 IB
M CORP 3% 3.000 05/15/2024 A- A3 2,000,000.00 2,141,560.00 2.30 1,945,773.44 2.18 1.31 Issuer total 2,000,000.00 2,141,560.00 2.30 1,945,773.44 2.18 1.31 /uni0031/uni0035
15 GASB 40 - DEPOSIT AND INVESTMENT RISK DISCLOSURE
As of December 31, 2022

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
Walmart Inc
931142DP5 WA LMART INC 3.3% 3.300 04/22/2024 01/22/2024 AA Aa2 1,000,000.00 1,079,400.00 1.16 979,963.73 1.10 1.20 931142DV2 WALMART INC 2.65% 2.650 12/15/2024 10/15/2024 AA Aa2 1,000,000.00 1,063,680.00 1.14 961,665.55 1.08 1.82 Issuer total 2,000,000.00 2,143,080.00 2.30 1,941,629.28 2.18 1.51 Chevron Corp
166764BW9CH
EVRON CORP 1.554% 1.554 05/11/2025 04/11/2025 AA- Aa2 2,000,000.00 1,905,680.00 2.05 1,862,246.06 2.09 2.25 Issuer total 2,000,000.00 1,905,680.00 2.05 1,862,246.06 2.09 2.25 PNC Financial Services Group Inc/The
693475AV7 PN
C FINANCIAL 3.500 01/23/2024 12/24/2023 A- A3 1,500,000.00 1,610,865.00 1.73 1,478,179.76 1.66 1.00 Issuer total 1,500,000.00 1,610,865.00 1.73 1,478,179.76 1.66 1.00 3M Co
88579YAX9 3M
COMPANY 2.25% 2.250 03/15/2023 02/15/2023 A+ A1 1,000,000.00 1,009,680.00 1.08 994,458.11 1.11 0.20 Issuer total 1,000,000.00 1,009,680.00 1.08 994,458.11 1.11 0.20 Wells Fargo & Co
95000U2R3 WE
LLS FARGO & 1.654 06/02/2024 06/02/2023 BBB+ A1 1,000,000.00 1,018,650.00 1.09 983,955.28 1.10 0.41 Issuer total 1,000,000.00 1,018,650.00 1.09 983,955.28 1.10 0.41 US Bancorp
91159HHV5 US
BANCORP 3.375% 3.375 02/05/2024 01/05/2024 A+ A2 1,000,000.00 1,086,930.00 1.17 982,424.56 1.10 1.03 Issuer total 1,000,000.00 1,086,930.00 1.17 982,424.56 1.10 1.03 Cisco Systems Inc
17275RAN2 CI
SCO SYSTEMS INC 3.625 03/04/2024 AA- A1 900,000.00 963,333.00 1.03 885,675.22 0.99 1.12 Issuer total 900,000.00 963,333.00 1.03 885,675.22 0.99 1.12 /uni0031/uni0036
16 GASB 40 - DEPOSIT AND INVESTMENT RISK DISCLOSURE
As of December 31, 2022

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 PN C BANK NA 3.3% 3.300 10/30/2024 09/30/2024 A A2 900,000.00 992,934.00 1.07 876,076.92 0.98 1.71 Issuer total 900,000.00 992,934.00 1.07 876,076.92 0.98 1.71 Grand total 93,520,000.00 93,149,583.06 100.00 89,196,962.39 100.00 1.74 /uni0031/uni0037
17 SECURITIES PURCHASED
For the period December 1, 2022 - December 31, 2022

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
Corporate Bonds
037833DB3 2 .90012/20/2022 09/12/2027 2,000,000.00 93.88 (1,877,540.00) (16,111.11) 06/12/202712/22/2022
APPLE INC 2.9% 12SEP2027 (CALLABLE

TORONTO DOMINION BANK, THE
2,000,000.00 (1,877,540.00) (16,111.11)Total Corporate Bonds Government Agencies
3130ATUS4 4 .25012/20/2022 12/10/2027 2,000,000.00 101.54 (2,030,700.00) (11,333.33) 12/22/2022
FEDERAL HOME LOAN BANK 4.25%
JEFFERIES LLC.
2,000,000.00 (2,030,700.00) (11,333.33)Total Government Agencies Government Bonds
91282CFH9 3 .12512/20/2022 08/31/2027 1,000,000.00 97.00 (970,042.41) (9,754.83) 12/22/2022
USA TREASURY 3.125% 31AUG2027
GOLDMAN, SACHS AND CO.
1,000,000.00 (970,042.41) (9,754.83)Total Government Bonds Grand totalGrand total 5 ,000,000.00 (4,878,282.41) (37,199.27) /uni0031/uni0038
18 DETAIL OF RETURN AND INTEREST RECEIVED
For the period December 1, 2022 - December 31, 2022

CITY OF SIMI VALLEY
Description Interest earnedAccretion
(amortization)
Realized gain
(loss)
Change in fair
value
Interest receivedCusip
Cash
Cash and Cash Equivalents 10 .900.00 0.00 10.900.00
Total Cash 10.900.00 0.00 10.900.00
Corporate Bonds
3M COMPANY 2.25% 15MAR2023 (CALLABLE 15FEB23) 1, 937.50(244.44) 1,214.15 0.000.0088579YAX9 AMERICAN HONDA FINANCE 1.3% 09SEP2026 1,231.392,911.00 (3,862.79) 0.000.0002665WDZ1 AMERICAN HONDA FINANCE 1.95% 10MAY2023 2,518.75(646.29) 382.05 0.000.0002665WDH1 APPLE INC 2.45% 04AUG2026 (CALLABLE 04MAY26) 2,109.731,085.93 (8,668.51) 0.000.00037833BZ2 APPLE INC 2.9% 12SEP2027 (CALLABLE 12JUN27) 1,450.00790.99 (10,380.58) 0.000.00037833DB3 BANK OF AMERICA CORP 3.55% 05MAR2024 (CALLABLE 05MAR23) 5,196.80(3,117.09) 2,454.61 0.000.0006051GHF9 BANK OF AMERICA CORP 3.864% 23JUL2024 (CALLABLE 23JUL23) 4,991.00(3,980.03) 1,926.74 0.000.0006051GHL6 CHEVRON CORP 1.554% 11MAY2025 (CALLABLE 11APR25) 2,676.342,612.74 (7,327.66) 0.000.00166764BW9 CISCO SYSTEMS INC 3.625% 04MAR2024 2,809.38(1,270.05) (4,490.52) 0.000.0017275RAN2 CITIBANK NA 3.65% 23JAN2024 (CALLABLE 23DEC23) 6,286.11(5,074.42) (109.80) 0.000.0017325FAS7 IBM CORP 3% 15MAY2024 5,166.67(3,748.28) (4,353.30) 0.000.00459200JY8 JPMORGAN CHASE & CO 1.514% 01JUN2024 (CALLABLE 01JUN23) 1,303.73(753.85) 2,614.64 7,570.000.0046647PBQ8 JPMORGAN CHASE & CO 3.559% 23APR2024 (CALLABLE 23APR23) 3,064.70(2,220.00) 467.73 0.000.0046647PAP1 JPMORGAN CHASE & CO 3.875% 01FEB2024 3,169.96(1,281.25) (3,223.93) 0.000.0046625HJT8 PNC BANK NA 3.3% 30OCT2024 (CALLABLE 30SEP24) 2,475.00(2,050.01) 1,281.56 0.000.0069353REF1 PNC FINANCIAL SERVICES 3.5% 23JAN2024 (CALLABLE 23DEC23) 4,520.84(3,809.80) 1,265.60 0.000.00693475AV7 TOYOTA MOTOR CREDIT CORP 0.45% 11JAN2024 387.5047.76 3,928.80 0.000.0089236THU2 /uni0031/uni0039
19 DETAIL OF RETURN AND INTEREST RECEIVED
For the period December 1, 2022 - December 31, 2022

CITY OF SIMI VALLEY
Description Interest earnedAccretion
(amortization)
Realized gain
(loss)
Change in fair
value
Interest receivedCusip
Corporate Bonds
TOYOTA MOTOR CREDIT CORP 1.9% 13JAN2027 1, 636.111,642.16 (4,502.38) 0.000.0089236TJV8 TOYOTA MOTOR CREDIT CORP 2% 07OCT2024 1,722.23(1,144.46) 236.99 0.000.0089236TGL3 US BANCORP 3.375% 05FEB2024 (CALLABLE 05JAN24) 2,906.25(2,338.92) (1,625.23) 0.000.0091159HHV5 WALMART INC 2.65% 15DEC2024 (CALLABLE 15OCT24) 2,281.95(1,711.83) (1,662.69) 13,250.000.00931142DV2 WALMART INC 3.3% 22APR2024 (CALLABLE 22JAN24) 2,841.67(2,335.29) (3,439.34) 0.000.00931142DP5 WELLS FARGO & COMPANY 1.654% 02JUN2024 (CALLABLE 02JUN23) 1,424.28(535.92) 2,034.36 8,270.000.0095000U2R3 Total Corporate Bonds 64,107.89(27,171.35) (35,839.50) 29,090.000.00 Government Agencies
FANNIE MAE 0.375% 25AUG2025 32 2.922,106.74 (38.92) 0.000.003135G05X7 FANNIE MAE 0.625% 22APR2025 1,076.393,914.93 7,243.30 0.000.003135G03U5 FANNIE MAE 2.5% 05FEB2024 6,243.06(2,005.21) 3,293.04 0.000.003135G0V34 FANNIE MAE 2.875% 12SEP2023 7,105.24(2,149.63) 5,870.45 0.000.003135G0U43 FEDERAL FARM CREDIT BANK 0.28% 13OCT2023 (CALLABLE 11JAN23) 482.2255.56 9,790.22 0.000.003133EMCQ3 FEDERAL FARM CREDIT BANK 0.3% 28MAR2024 (CALLABLE 11JAN23) 775.0090.95 7,691.25 0.000.003133EMBE1 FEDERAL FARM CREDIT BANK 1.55% 28FEB2024 (CALLABLE 11JAN23) 1,334.720.00 2,189.10 0.000.003133ELNJ9 FEDERAL FARM CREDIT BANK 1.6% 14AUG2023 4,133.34(134.88) 10,703.58 0.000.003133EKZK5 FEDERAL FARM CREDIT BANK 2.25% 08FEB2023 5,715.63(999.64) 4,927.38 0.000.003133EKKT2 FEDERAL HOME LOAN BANK 0.25% 08MAR2024 322.9166.88 4,939.74 0.000.003130ALSG0 FEDERAL HOME LOAN BANK 1.5% 15AUG2024 3,875.00285.41 1,209.21 0.000.003130AGWK7 FEDERAL HOME LOAN BANK 3.375% 12JUN2026 8,718.75(1,180.53) (5,130.18) 47,531.250.003130ASJ59 /uni0032/uni0030
20 DETAIL OF RETURN AND INTEREST RECEIVED
For the period December 1, 2022 - December 31, 2022

CITY OF SIMI VALLEY
Description Interest earnedAccretion
(amortization)
Realized gain
(loss)
Change in fair
value
Interest receivedCusip
Government Agencies
FEDERAL HOME LOAN BANK 3.375% 13JUN2025 2, 179.70(301.01) (503.19) 12,515.630.003130ASG86 FEDERAL HOME LOAN BANK 4.25% 10DEC2027 2,125.00(188.55) (15,582.78) 0.000.003130ATUS4 FEDERAL HOME LOAN BANK 4.375% 12SEP2025 7,534.73(301.42) (3,662.24) 0.000.003130ATHT7 FREDDIE MAC 0.25% 08SEP2023 322.91(24.76) 6,740.34 0.000.003137EAEW5 FREDDIE MAC 2.75% 19JUN2023 4,736.11(1,758.76) 5,349.82 27,500.000.003137EAEN5 Total Government Agencies 57,003.63(2,523.92) 45,030.12 87,546.880.00 Government Bonds
USA TREASURY 0.25% 30SEP2025 42 5.834,525.72 (1,875.00) 0.000.0091282CAM3 USA TREASURY 0.25% 31OCT2025 428.174,523.86 (2,343.76) 0.000.0091282CAT8 USA TREASURY 0.375% 30NOV2025 638.744,319.03 (2,031.26) 0.000.0091282CAZ4 USA TREASURY 0.375% 31JAN2026 631.804,308.70 (2,187.50) 0.000.0091282CBH3 USA TREASURY 0.5% 30NOV2023 851.65597.26 6,796.88 0.000.0091282CDM0 USA TREASURY 0.625% 31JUL2026 1,052.993,385.19 (2,421.88) 0.000.0091282CCP4 USA TREASURY 0.75% 30APR2026 1,284.533,223.72 (2,656.24) 0.000.0091282CBW0 USA TREASURY 0.75% 31MAR2026 1,277.473,238.04 (3,828.12) 0.000.0091282CBT7 USA TREASURY 0.75% 31MAY2026 1,277.473,212.90 (1,953.12) 0.000.0091282CCF6 USA TREASURY 0.875% 30SEP2026 1,490.392,962.05 (3,359.38) 0.000.0091282CCZ2 USA TREASURY 1.375% 31JAN2025 1,737.43(1,083.34) (58.59) 0.000.00912828Z52 USA TREASURY 1.5% 30NOV2024 1,916.21(1,287.82) 1,875.00 0.000.00912828YV6 USA TREASURY 1.625% 31MAY2023 2,767.8653.58 5,312.50 0.000.00912828R69 /uni0032/uni0031
21 DETAIL OF RETURN AND INTEREST RECEIVED
For the period December 1, 2022 - December 31, 2022

CITY OF SIMI VALLEY
Description Interest earnedAccretion
(amortization)
Realized gain
(loss)
Change in fair
value
Interest receivedCusip
Government Bonds
USA TREASURY 2.25% 31DEC2023 3, 790.76(2,658.35) 3,750.00 0.000.00912828V23 USA TREASURY 3.125% 31AUG2027 776.94192.15 (6,683.03) 0.000.0091282CFH9 Total Government Bonds 20,348.2429,512.69 (11,663.50) 0.000.00 Grand total 141,470.66(182.58) (2,472.88) 116,647.780.00 /uni0032/uni0032
22 TRANSACTION REPORT
For the period December 1, 2022 - December 31, 2022

CITY OF SIMI VALLEY
Maturity Par value or
shares
Interest Transaction totalPrincipalTransactionCusip Sec type DescriptionTrade date Settle date
Realized
gain(loss)
7,570.0012/01/2022
12/01/2022
Income46647PBQ8 Corporate Bonds JPMORGAN CHASE & CO 06/01/2024 1,000,000.00 0.00 7,570.000.00 8,270.0012/02/2022
12/02/2022
Income95000U2R3 Corporate Bonds WELLS FARGO & COMPANY 06/02/2024 1,000,000.00 0.00 8,270.000.00 47,531.2512/12/2022
12/12/2022
Income3130ASJ59 Government Agencies FEDERAL HOME LOAN BANK 06/12/2026 3,000,000.00 0.00 47,531.250.00 12,515.6312/13/2022
12/13/2022
Income3130ASG86 Government Agencies FEDERAL HOME LOAN BANK 06/13/2025 750,000.00 0.00 12,515.630.00 13,250.0012/15/2022
12/15/2022
Income931142DV2 Corporate Bonds WALMART INC 2.65% 12/15/2024 1,000,000.00 0.00 13,250.000.00 27,500.0012/19/2022
12/19/2022
Income3137EAEN5 Government Agencies FREDDIE MAC 2.75%06/19/2023 2,000,000.00 0.00 27,500.000.00 (16,111.11)12/20/2022
12/22/2022
Bought037833DB3 Corporate Bonds APPLE INC 2.9% 12SEP2027 09/12/2027 2,000,000.00 (1,877,540.00) (1,893,651.11)0.00 (11,333.33)12/20/2022
12/22/2022
Bought3130ATUS4 Government Agencies FEDERAL HOME LOAN BANK 12/10/2027 2,000,000.00 (2,030,700.00) (2,042,033.33)0.00 (9,754.83)12/20/2022
12/22/2022
Bought91282CFH9 Government Bonds USA TREASURY 3.125% 08/31/2027 1,000,000.00 (970,042.41) (979,797.24)0.00

10.90Income Cash and Cash Equivalents Cash 10.900.00 0.000.0012/31/2022 /uni0032/uni0033
23 ADDITIONAL INFORMATION
As of December 31, 2022

CITY OF SIMI VALLEY
Past performance is not a guide to future performance. The value of investments and any income from them will fluctuate and is not guaranteed (this may partly be due to exchange rate changes) and investors may not get back the amount invested. Transactions in foreign securities may be executed and settled in local markets. Performance comparisons will be affected by changes in interest rates. Investment returns fluctuate due to changes in market conditions. Investment involves risk, including the possible loss of principal. No assurance can be given that the performance objectives of a given strategy will be achieved. The information contained herein is for your reference only and is being provided in response to your specific request and has been obtained from sources believed to be reliable; however, no representation is made regarding its accuracy or completeness. 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 should not be duplicated, amended, or forwarded to a third party without consent from Insight. This is a marketing document intended for professional clients only and should not be made available to or relied upon by retail clients Investment advisory services in North America are provided through two different SEC-registered investment advisers using the brand Insight Investment: Insight North America LLC (INA) and Insight Investment International Limited (IIIL). The North American investment advisers are associated with a broader group of global investment managers that also (individually and collectively) use the corporate brand Insight Investment and may be referred to as Insight, Insight Group or Insight Investment.

INA is an investment adviser registered with the Securities and Exchange Commission (SEC), under the Investment Advisers Act of 1940, as amended. Registration with the SEC does not imply a certain level of skill or training.

You may request, without charge, additional information about Insight. Moreover, specific information relating to Insights strategies, including investment advisory fees, may be obtained from INA's Form ADV Part 2A, which is available without charge upon request.

Where indicated, performance numbers used in the analysis are gross returns. The performance reflects the reinvestment of all dividends and income. INA charges management fees on all portfolios managed and these fees will reduce the returns on the portfolios. For example, assume that $30 million is invested in an account with INA, and this account achieves a 5.0% annual return compounded monthly, gross of fees, for a period of five years.

At the end of five years that account would have grown to $38,500,760 before the deduction of management fees. Assuming management fees of 0.25% per year are deducted monthly from the account, the value at the end of the five year period would be $38,022,447. Actual fees for new accounts are dependent on size and subject to negotiation. INA's investment advisory fees are discussed in Part 2A of its Form ADV.

Unless otherwise stated, the source of information is Insight. Any forecasts or opinions are Insight’s own at the date of this document (or as otherwise specified) and may change. 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 makes no implied or expressed recommendations concerning the manner in which an account should or would be handled, as appropriate investment strategies depend upon specific investment guidelines and objectives and should not be construed to be an assurance that any particular security in a strategy will remain in any fund, account, or strategy, or that a previously held security will not be repurchased. 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.

Please compare the information provided in this statement to the information provided in the statement received from your Custodian.

For trading activity the Clearing broker will be reflected. In certain cases the Clearing broker will differ from the Executing broker.

In calculating ratings distributions and weighted average portfolio quality, Insight assigns U.S Treasury and U.S agency securities a quality rating based on the methodology used within the respective benchmark index. When Moody’s, S&P and Fitch rate a security, Bank of America and Merrill Lynch indexes assign a simple weighted average statistic while Barclays indexes assign the median statistic. Insight assigns all other securities the lower of Moody’s and S&P ratings.

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.

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. /uni0032/uni0034
24 ADDITIONAL INFORMATION
As of December 31, 2022

CITY OF SIMI VALLEY
Insight does not provide tax or legal advice to its clients and all investors are strongly urged to consult their tax and legal advisors regarding any potential strategy or investment.

Insight is a group of wholly owned subsidiaries of The Bank of New York Mellon Corporation. BNY Mellon is the corporate brand of The Bank of New York Mellon Corporation and may also be used as a generic term to reference the Corporation as a whole or its various subsidiaries generally. Products and services may be provided under various brand names and in various countries by subsidiaries, affiliates and joint ventures of The Bank of New York Mellon Corporation where authorized and regulated as required within each jurisdiction. Unless you are notified to the contrary, the products and services mentioned are not insured by the FDIC (or by any governmental entity) and are not guaranteed by or obligations of The Bank of New York Mellon Corporation or any of its affiliates. The Bank of New York Corporation assumes no responsibility for the accuracy or completeness of the above data and disclaims all expressed or implied warranties in connection therewith. © 2022 Insight Investment. All rights reserved.
/uni0032/uni0035
25

← All documents from this meeting