City of Manhattan Beach
Finance Department
Investment Portfolio
December 2023
As Finance Director for the City of Manhattan Beach, I hereby certify that these investments are in compliance with the City’s investment policy (unless otherwise noted). Sufficient liquidity has been maintained to meet budget expenditure requirements for the current six month period.
CITY OF MANHATTAN BEACH
Portfolio Management
December 1, 2023 through December 31, 2023
Portfolio Summary
% of
Portfolio
Book
ValueInvestments
Market
Value
Par
Value
Days to
MaturityTerm
YTM
360 Equiv.
YTM
365 Equiv.
LAIF 21,653,799.67 119.03 3.875121,653,799.6721,653,799.67 3.929 Medium Term Notes 20,166,680.45 1,65917.73 3.5331,11320,057,180.0021,000,000.00 3.582 Federal Agency Issues - Coupon 30,773,845.81 1,44827.05 2.55965330,304,120.0031,000,000.00 2.594 Treasury Securities - Coupon 41,167,743.34 1,58836.19 2.00584239,667,220.0042,000,000.00 2.033 113,762,069.27 100.00%
Investments
111,682,319.67115,653,799.67 1,261 679 2.782 2.820
Cash
(not included in yield calculations)
Passbook/Checking 5,927,431.97 1 0.00015,927,431.975,927,431.97 0.000 119,689,501.24Total Cash and Investments 117,609,751.64121,581,231.64 1,261 679 2.782 2.820 Current Year
December 31
211,932.24
Fiscal Year To Date
1,397,777.60
Total Earnings Month Ending
__________________________________________________ ____________________ STEVE S. CHARELIAN, FINANCE DIRECTOR
Portfolio CITY
CP
Reporting period 12/01/2023-12/31/2023
Run Date: 02/05/2024 - 18:39 PM (PRF_PM1) 7.3.11
Report Ver. 7.3.11
YTM
365
Par Value Book Value
Maturity
Date
Stated
RateMarket Value
December 31, 2023
Portfolio Details - Investments
Issuer
Portfolio Management
CITY OF MANHATTAN BEACH
Days to
MaturityS&PCUSIP Investment #
Purchase
Date
LAIF
3.929Local Agency Invest. Fund3000 21,653,799.67 21,653,799.67 3.92907/01/2018 21,653,799.67SYS3000 1 21,653,799.6721,653,799.6721,653,799.67Subtotal and Average 3.929 1 Medium Term Notes
4.905APPLE INCMTN0112 1,000,000.00 935,170.97 09/12/20272.90010/25/2022 957,540.00 AA+037833DB3 1,350
4.171APPLE INCMTN0121 1,000,000.00 992,446.00 05/10/20284.00006/12/2023 997,670.00 AA+037833ET3 1,591
1.963AMAZON.COM LLCMTN0111 1,000,000.00 977,061.09 05/12/20261.00002/24/2022 923,760.00 AA023135BX3 862
4.282AMAZON.COM LLCMTN0116 1,000,000.00 961,004.74 08/22/20273.15002/09/2023 959,770.00 AA023135BC9 1,329
1.850BANK OF NY MELLOMTN0109 1,000,000.00 1,011,205.00 10/24/20242.10002/10/2020 973,370.00 A06406RAL1 297
4.410BANK OF NY MELLOMTN0118 1,000,000.00 963,528.81 01/29/20283.40004/14/2023 951,260.00 A06406RAF4 1,489
4.690COLGATE-PALM COMTN0123 2,000,000.00 1,992,460.00 03/01/20284.60007/10/2023 2,049,600.00 AA-194162AR4 1,521
3.743COSTCO COMPANIESMTN0117 1,000,000.00 920,408.34 06/20/20271.37504/14/2023 907,330.00 A+22160KAN5 1,266
3.765COSTCO COMPANIESMTN0119 1,000,000.00 919,493.19 06/20/20271.37504/18/2023 907,330.00 A+22160KAN5 1,266
1.977Walt DisneyMTN0107 2,000,000.00 1,997,086.66 08/30/20241.75012/12/2019 1,953,140.00 A-254687FK7 242
4.593Johnson & JohnsonMTN0113 1,000,000.00 879,680.02 09/01/20270.95010/25/2022 892,290.00 AAA478160CP7 1,339
3.880Johnson & JohnsonMTN0114 1,000,000.00 897,944.31 09/01/20270.95012/22/2022 892,290.00 AAA478160CP7 1,339
1.890COCA-COLA COMTN0108 1,000,000.00 993,679.00 09/06/20241.75012/12/2019 977,480.00 A+191216CL2 249
4.374COCA-COLA COMTN0124 1,000,000.00 866,778.90 03/15/20281.00007/10/2023 881,620.00 A+191216DD9 1,535
4.163MICROSOFT CORPMTN0115 1,000,000.00 974,877.23 02/06/20273.30012/22/2022 973,930.00 AAA594918BY9 1,132
0.950MERCK & CO INCMTN0110 1,000,000.00 991,420.00 02/24/20260.75010/05/2021 926,960.00 A+58933YAY1 785
4.210MERCK & CO INCMTN0120 1,000,000.00 992,917.00 05/17/20284.05006/12/2023 995,610.00 A+58933YBH7 1,598
5.044PepsicoMTN0125 1,000,000.00 977,524.66 05/15/20284.45011/02/2023 1,017,420.00713448FR4 1,596
4.183WALMART INCMTN0122 1,000,000.00 921,994.53 09/17/20261.05006/12/2023 918,810.00 AA931142ER0 990 20,166,680.4520,057,180.0021,000,000.00Subtotal and Average 3.582 1,113 Federal Agency Issues - Coupon
3.850FARMER MACFAC0304 1,000,000.00 1,000,000.00 02/14/20283.85002/14/2023 993,320.0031422XW99 1,505
1.870FED FARM CR BKFAC0294 1,000,000.00 997,642.00 08/22/20251.80002/24/2022 957,890.00 AA+3133ENPX2 599
2.747FED FARM CR BKFAC0296 2,000,000.00 2,025,552.25 03/22/20273.15004/11/2022 1,945,060.00 AA+3133EJDV8 1,176
2.625FED FARM CR BKFAC0297 2,000,000.00 2,000,000.00 05/16/20242.62505/16/2022 1,980,060.00 AA+3133ENWP1 136
3.250FED FARM CR BKFAC0301 1,000,000.00 979,554.54 11/18/20240.87506/17/2022 965,530.003133ENEJ5 322
4.550FED FARM CR BKFAC0303 1,000,000.00 998,356.00 07/27/20264.50010/27/2022 1,009,480.003133ENV72 938
4.920FED FARM CR BKFAC0309 1,000,000.00 1,000,580.04 11/01/20284.87511/02/2023 1,043,760.003133EPA47 1,766
1.771Federal Home Loan BankFAC0285 2,000,000.00 2,015,648.49 09/13/20242.87512/11/2019 1,971,920.003130A2UW4 256
1.470Federal Home Loan BankFAC0289 1,000,000.00 1,001,306.00 08/15/20241.50002/07/2020 978,490.00 AA+3130AGWK7 227
0.312Federal Home Loan BankFAC0291 1,000,000.00 1,012,086.41 06/14/20242.87502/04/2021 989,290.00 AA+3130A1XJ2 165 Portfolio CITY
CP
Run Date: 02/05/2024 - 18:39 PM (PRF_PM2) 7.3.11
Report Ver. 7.3.11
YTM
365
Par Value Book Value
Maturity
Date
Stated
RateMarket Value
December 31, 2023
Portfolio Details - Investments
Issuer
Portfolio Management
CITY OF MANHATTAN BEACH
Days to
MaturityS&PCUSIP Investment #
Purchase
Date
Federal Agency Issues - Coupon
1.871Federal Home Loan BankFAC0293 1,000,000.00 995,852.00 09/12/20251.75002/24/2022 956,620.00 AA+3130A8ZQ9 620
3.230Federal Home Loan BankFAC0300 1,000,000.00 990,620.00 06/28/20242.75006/17/2022 988,180.003130ASDS5 179
4.343Federal Home Loan BankFAC0302 1,000,000.00 917,860.03 06/12/20260.87510/24/2022 923,930.003130AN4T4 893
4.048Federal Home Loan BankFAC0306 1,000,000.00 970,093.32 03/12/20273.00006/12/2023 967,230.00 AA+3130A3DU5 1,166
4.483Federal Home Loan BankFAC0307 1,000,000.00 982,571.07 06/09/20284.00007/10/2023 1,003,500.00 AA+3130AWC24 1,621
4.916Federal Home Loan BankFAC0308 1,000,000.00 995,442.24 09/08/20284.75011/02/2023 1,035,140.003130AXEL8 1,712
2.722Federal Home Loan MortgageFAC0298 2,000,000.00 1,920,422.82 09/23/20250.37505/13/2022 1,866,660.00 AA+3137EAEX3 631
1.700Fannie MaeFAC0286 2,000,000.00 1,993,020.00 10/15/20241.62512/11/2019 1,949,040.00 AA+3135G0W66 288
1.500Fannie MaeFAC0287 2,000,000.00 2,011,260.00 10/15/20241.62502/07/2020 1,949,040.00 AA+3135G0W66 288
1.526Fannie MaeFAC0288 2,000,000.00 2,002,534.24 07/02/20241.75002/07/2020 1,966,640.00 AA+3135G0V75 183
0.259Fannie MaeFAC0290 1,000,000.00 1,007,696.46 07/02/20241.75002/04/2021 983,320.00 AA+3135G0V75 183
3.597Fannie MaeFAC0305 1,000,000.00 902,331.73 10/08/20270.75004/14/2023 887,800.003135G05Y5 1,376
1.763Tennessee Valley AuthorityFAC0295 1,000,000.00 985,511.13 05/15/20250.75002/24/2022 948,490.00 AA+880591EW8 500
2.894Tennessee Valley AuthorityFAC0299 1,000,000.00 1,067,905.04 11/01/20256.75005/13/2022 1,043,730.00 AA+880591CJ9 670 30,773,845.8130,304,120.0031,000,000.00Subtotal and Average 2.594 653 Treasury Securities - Coupon
2.234US TREASURYUST0033 1,000,000.00 995,039.06 02/29/20242.12505/13/2019 994,870.00912828W48 59
2.240US TREASURYUST0034 1,000,000.00 994,687.50 03/31/20242.12505/13/2019 992,030.00912828W71 90
1.493US TREASURYUST0035 2,000,000.00 2,005,451.48 08/31/20241.87502/07/2020 1,959,060.009128282U3 243
0.561US TREASURYUST0036 1,000,000.00 994,955.86 06/30/20250.25005/28/2021 939,260.00912828ZW3 546
0.591US TREASURYUST0039 1,000,000.00 994,813.27 06/30/20250.25008/11/2021 939,260.00912828ZW3 546
1.058US TREASURYUST0047 1,000,000.00 988,771.27 05/31/20250.25012/08/2021 941,760.00912828ZT0 516
1.001US TREASURYUST0051 1,000,000.00 1,003,906.25 02/28/20251.12512/09/2021 960,510.00912828ZC7 424
2.665US TREASURYUST0054 2,000,000.00 1,931,568.13 01/31/20271.50004/08/2022 1,856,480.00912828Z78 1,126
3.287US TREASURYUST0057 1,000,000.00 953,869.72 08/15/20261.50006/17/2022 935,940.009128282A7 957
3.285US TREASURYUST0059 1,000,000.00 970,992.75 05/15/20272.37509/01/2022 949,810.00912828X88 1,230
3.295US TREASURYUST0060 1,000,000.00 970,666.12 05/15/20272.37509/01/2022 949,810.00912828X88 1,230
3.241US TREASURYUST0062 1,000,000.00 909,798.63 06/30/20270.50009/01/2022 888,280.00912828ZV5 1,276
4.180US TREASURYUST0064 1,000,000.00 927,925.10 10/31/20261.62510/25/2022 936,210.00912828YQ7 1,034
3.747US TREASURYUST0066 1,000,000.00 946,891.58 08/15/20272.25002/09/2023 943,130.009128282R0 1,322
0.576US TREASURYUST0037 2,000,000.00 1,989,046.34 07/31/20250.25005/28/2021 1,873,040.0091282CAB7 577
0.620US TREASURYUST0038 1,000,000.00 993,583.36 08/31/20250.25005/28/2021 933,560.0091282CAJ0 608
0.601US TREASURYUST0040 1,000,000.00 994,488.10 07/31/20250.25008/11/2021 936,520.0091282CAB7 577
0.586US TREASURYUST0041 1,000,000.00 993,899.83 08/31/20250.25008/11/2021 933,560.0091282CAJ0 608
0.658US TREASURYUST0042 1,000,000.00 994,431.89 11/30/20250.37508/09/2021 928,630.0091282CAZ4 699 Portfolio CITY
CP
Run Date: 02/05/2024 - 18:39 PM (PRF_PM2) 7.3.11
YTM
365
Par Value Book Value
Maturity
Date
Stated
RateMarket Value
December 31, 2023
Portfolio Details - Investments
Issuer
Portfolio Management
CITY OF MANHATTAN BEACH
Days to
MaturityS&PCUSIP Investment #
Purchase
Date
Treasury Securities - Coupon
0.681US TREASURYUST0043 1,000,000.00 992,977.28 07/31/20250.25010/05/2021 936,520.0091282CAB7 577
0.707US TREASURYUST0044 2,000,000.00 1,981,851.13 10/31/20250.25010/05/2021 1,857,740.0091282CAT8 669
0.907US TREASURYUST0045 1,000,000.00 992,500.00 08/31/20260.75010/05/2021 916,800.0091282CCW9 973
0.892US TREASURYUST0046 1,000,000.00 993,073.36 07/31/20260.62510/05/2021 915,980.0091282CCP4 942
1.191US TREASURYUST0048 1,000,000.00 989,680.21 05/31/20260.75012/09/2021 923,090.0091282CCF6 881
1.176US TREASURYUST0049 1,000,000.00 992,094.65 06/30/20260.87512/09/2021 924,730.0091282CCJ8 911
1.210US TREASURYUST0050 1,000,000.00 990,817.92 09/30/20260.87512/09/2021 918,480.0091282CCZ2 1,003
1.678US TREASURYUST0052 2,000,000.00 1,946,771.93 09/30/20250.25002/24/2022 1,862,500.0091282CAM3 638
2.581US TREASURYUST0053 1,000,000.00 958,303.20 10/31/20261.12504/08/2022 922,770.0091282CDG3 1,034
2.750US TREASURYUST0055 1,000,000.00 996,500.00 04/15/20252.62505/16/2022 975,510.0091282CEH0 470
3.187US TREASURYUST0056 1,000,000.00 933,806.42 07/31/20260.62506/17/2022 915,980.0091282CCP4 942
3.302US TREASURYUST0058 1,000,000.00 936,039.78 09/30/20260.87506/17/2022 918,480.0091282CCZ2 1,003
3.300US TREASURYUST0061 1,000,000.00 997,755.04 06/30/20273.25009/01/2022 977,230.0091282CEW7 1,276
3.309US TREASURYUST0063 1,000,000.00 982,263.65 07/31/20272.75009/01/2022 959,920.0091282CFB2 1,307
3.787US TREASURYUST0065 1,000,000.00 964,796.40 07/31/20272.75012/22/2022 959,920.0091282CFB2 1,307
3.804US TREASURYUST0067 2,000,000.00 1,980,062.64 01/31/20283.50002/09/2023 1,968,440.0091282CGH8 1,491
4.816US TREASURYUST0068 1,000,000.00 983,663.49 08/31/20284.37511/01/2023 1,021,410.0091282CHX2 1,704 41,167,743.3439,667,220.0042,000,000.00Subtotal and Average 2.033 842 Total and Average 115,653,799.67 2.820 679111,682,319.67 113,762,069.27 Portfolio CITY
CP
Run Date: 02/05/2024 - 18:39 PM (PRF_PM2) 7.3.11
YTM
365
Par Value Book Value
Stated
RateMarket Value
December 31, 2023
Portfolio Details - Cash
Issuer
Portfolio Management
CITY OF MANHATTAN BEACH
Days to
MaturityS&PCUSIP Investment #
Purchase
Date
Money Market Fund
0.000UNION BANK39901 5,927,431.97 5,927,431.9707/01/2018 5,927,431.97SYS39903-39902 1 Subtotal and Average
Total Cash and Investments 121,581,231.64 2.820 679
1 117,609,751.64 119,689,501.24
Portfolio CITY
CP
Run Date: 02/05/2024 - 18:39 PM (PRF_PM2) 7.3.11
City of Manhattan Beach
Investment Portfolio Summary
As of December 31, 202
3 PORTFOLIO PROFILE Dec 31, 2023 Nov 30, 2023 Oct 31, 2023 Sep 30, 2023 Aug 31, 2023 Total Book Value (Excluding Trust Funds) $113,762,069 $115,482,035 $114,526,378 $122,202,752 $126,206,553 Increase/(Decrease) from Prior Period (1,719,966) 955,657 (7,676,374) (4,003,801) (3,006,221) Percentage Change (1.5%) 0.8% (6.3%) (3.2%) (2.3%)
Average Yield to Maturity (365 Days) 2.820% 2.819% 2.734% 2.755% 2.719% Increase/(Decrease) from Prior Period 0.002% 0.085% (0.021%) 0.035% 0.049%
PORTFOLIO ALLOCATIONS
By Security Value (Par) Percent Par YTM Time Horizon Percent LAIF* $21,653,800 18.72% 3.929% Next 12 months 39%
Medium Term Notes 21,000,000 18.2% 3.582% Months 13-24 19% Federal Agencies 31,000,000 26.8% 2.594% Months 25-36 13% U.S. Treasuries 42,000,000 36.3% 2.033% Months 37-48 17% Total $115,653,800 100.0% 2.820% Months 49-60 12%
*LAIF YTM as of December 31, 2023 BAD Total 100.0%
RECENT ACTIVITY
Security Date of Activity Maturity Date Purchase (Par) Maturing/Call YTM
FHLB - 4% Coupon 7/10/2023 6/9/2028 1,000,000 4.483%
CL -
4.6% Coupon 7/10/2023 3/1/2028 2,000,000 4.690%
KO
- 1% Coupon 7/10/2023 3/15/2028 1,000,000 4.374%
PEP -
4.45% Coupon 7/11/2023 5/15/2028 1,000,000 5.030%
F
HLB - 4.75% Coupon 7/12/2023 9/8/2028 1,000,000 4.860%
F
FCB - 4.875% Coupon 7/13/2023 11/1/2028 1,000,000 4.861% T
- 4.375% Coupon 4.770%
Total Purchases $7,000,000 4.713%
Matured: FNMA - 2.875% Coupon 9/12/2023 9/12/2023 1,000,000 0.499% Matur
ed: TMC - 3.460964% Coupon 9/20/2023 9/20/2023 1,000,000 3.461% Matur
ed: TMC - 2.25% Coupon 10/18/2023 10/18/2023 1,000,000 2.634% Total M
aturing/Calls $3,000,000 2.198%
City of Manhattan Beach
Investment Portfolio Summary
As of December 31, 202
3 3‐Month 6 ‐Month 2 ‐Year 5 ‐Year 10 ‐Year
October 2023 5.60% 5.57% 5.07% 4.77% 4.80%
November 2023 5.45% 5.38% 4.73% 4.31% 4.50%
December 2023 5.40% 5.26% 4.23% 3.84% 4.02%
Portfolio 2.820% 2.820% 2.820% 2.820% 2.820%
LAIF 3 929% 3 929% 3 929% 3 929% 3 929%
Portfolio, 2.820%
LAIF, 3.929%
0.00%
1.00%
2.00%
3.00%
4.00%
5.00%
6.00%
US Treasuries Yield Curve
www.treas.gov
Monthly yields are interpolated by the Treasury from the daily yield curve.
CITY OF MANHATTAN BEACH HELD TO MATURITY
Portfolio Maturity Structure Rolling 60 Months
January 2024 through December 2028
Mth Mat. YTM Inv Call Amt Mth Mat. YTM Inv Call Amt Mth Mat. YTM Inv Call Amt Mth Mat. YTM Inv Call Amt Mth Mat. YTM Inv Call Amt Jan 24 Jan 25 Jan 26 Jan 27 1/31/27 2.67% T nc $2.0M Jan 28 1/29/28 4.41% BK nc $1.0M 1/31/28 3.80% T nc $2.0M
Feb 24 2/29/24 2.2% T nc $1.0M Feb 25 2/28/25 1.00% T nc $1.0M Feb 26 2/24/26 0.95% MRK MW: 10 $1.0M Feb 27 2/6/27 4.16% MSFT nc $1.0M Feb 28 2/14/28 3.85% FAMCA nc $1.0M Mar 24 3/31/24 2.2% T nc $1.0M Mar 25 Mar 26 Mar 27 3/22/27 2.75% FFCB nc $2.0M Mar 28 3/1/28 4.69% CL nc $2.0M 3/12/27 4.05% FHLB nc $1.0M 3/15/28 4.37% KO nc $1.0M
Apr 24 Apr 25 4/15/25 2.75% T nc $1.0M Apr 26 Apr 27 Apr 28 May 24 5/16/24 2.6% FFCB nc $2.0M May 25 5/15/25 1.76% TVA nc $1.0M May 26 5/31/26 1.19% T nc $1.0M May 27 5/15/27 3.28% T nc $1.0M May 28 5/17/28 4.21% MRK nc $1.0M 5/31/25 1.06% T nc $1.0M 5/12/26 1.96% AMZN nc $1.0M 5/15/27 3.29% T nc $1.0M 5/10/28 4.17% AAPL nc $1.0M 5/15/28 5.03% PEP nc $1.0M
Jun 24 6/14/24 0.3% FHLB nc $1.0M Jun 25 6/30/25 0.56% T nc $1.0M Jun 26 6/30/26 1.18% T nc $1.0M Jun 27 6/20/27 3.74% COST nc $1.0M Jun 28 6/9/28 4.48% FHLB nc $1.0M 6/28/24 3.2% FHLB nc $1.0M 6/30/25 0.59% T nc $1.0M 6/12/26 4.34% FHLB nc $1.0M 6/30/27 3.24% T nc $1.0M 6/30/27 3.30% T nc $1.0M
6/20/27 3.76% COST nc $1.0M
Jul 24 7/2/24 1.5% FNMA nc $2.0M Jul 25 7/31/25 0.58% T nc $2.0M Jul 26 7/31/26 0.89% T nc $1.0M Jul 27 7/31/27 3.31% T nc $1.0M Jul 28 7/2/24 0.3% FNMA nc $1.0M 7/31/25 0.60% T nc $1.0M 7/31/26 3.19% T nc $1.0M 7/31/27 3.79% T nc $1.0M 7/31/25 0.68% T nc $1.0M 7/27/26 4.55% FFCB nc $1.0M
Aug 24 8/15/24 1.5% FHLB nc $1.0M Aug 25 8/31/25 0.62% T nc $1.0M Aug 26 8/31/26 0.91% T nc $1.0M Aug 27 8/15/27 3.75% T nc $1.0M Aug 28 8/31/28 4.82% T nc $1.0M 8/30/24 2.0% DIS 7/30/24 $2.0M 8/31/25 0.59% T nc $1.0M 8/15/26 3.29% T nc $1.0M 8/22/27 4.28% AMZN nc $1.0M 8/31/24 1.5% T nc $2.0M 8/22/25 1.87% FFCB nc $1.0M
Sep 24 9/6/24 1.9% KO 9/6/24 $1.0M Sep 25 9/12/25 1.87% FHLB nc $1.0M Sep 26 9/30/26 1.21% T nc $1.0M Sep 27 9/12/27 4.91% AAPL nc $1.0M Sep 28 9/8/28 4.92% FHLB nc $1.0M 9/13/24 1.8% FHLB nc $2.0M 9/23/25 2.72% FHLM C nc $2.0M 9/30/26 3.30% T nc $1.0M 9/1/27 4.59% JNJ nc $1.0M 9/30/25 1.68% T nc $2.0M 9/17/26 4.18% WMT nc $1.0M 9/1/27 3.88% JNJ nc $1.0M Oct 24 10/15/24 1.7% FNMA nc $2.0M Oct 25 10/31/25 0.71% T nc $2.0M Oct 26 10/31/26 2.58% T nc $1.0M Oct 27 10/8/27 3.60% FNMA nc $1.0M Oct 28 10/15/24 1.5% FNMA nc $2.0M 10/31/26 4.18% T nc $1.0M
10/24/24 1.9% BK 9/6/24 $1.0M
Nov 24 11/18/24 3.3% FFCB nc $1.0M Nov 25 11/30/25 0.66% T nc $1.0M Nov 26 Nov 27 Nov 28 11/1/28 4.92% FFCB nc $1.0M 11/1/25 2.89% TVA nc $1.0M
Dec 24 Dec 25 Dec 26 Dec 27 Dec 28
Total By Year (excl LAIF) $23.0m $22.0m $15.0m $20.0m $14.0m % of Total Securities (excl LAIF) 24% 23% 16% 21% 15%
% of Total Investments (incl LAIF) 39% 19% 13% 17% 12%
Total Securities 81% $94.0M
LAIF 19% $21.7M
Total Investments 100%
$115.7M
Shaded rows indicate months with significant cash inflows.
City of Manhattan Beach
Investment Policy Compliance Chart
As of December 31, 202
3 Instrument % of Total Limit Compliant? Limit Compliant? Limit Compliant? Local Agency Investment Fund (LAIF) $21,653,800 18.7% $75,000,000 Yes Treasury Securities
US Treasury $42,000,000 36.3% 5 Years Yes
Total U.S. Treasuries (36) TRUE $42,000,000 36.3%
Medium Term (Corporate) Notes
Coca-Cola 2,000,000 1.7% 5.0% Yes 5 Years Yes
Amazon 2,000,000 1.7% 5.0% Yes 5 Years Yes
Costco 2,000,000 1.7% 5.0% Yes 5 Years Yes
Walmart 1,000,000 0.9% 5.0% Yes 5 Years Yes
Colgate-Palmolive 2,000,000 1.7% 5.0% Yes 5 Years Yes
Pepsi Cola 1,000,000 0.9% 5.0% Yes 5 Years Yes
Total Consumer Goods Sector $10,000,000 8.6% 10.0% Yes
Bank of NY 2,000,000 1.7% 5.0% Yes 5 Years Yes
Total Financial Sector $2,000,000 1.7% 10.0% Yes
Johnson & Johnson 2,000,000 1.7% 5.0% Yes 5 Years Yes
Merck 2,000,000 1.7% 5.0% Yes 5 Years Yes
Total Pharmaceuticals Sector $4,000,000 3.5% 10.0% Yes
Apple Inc 2,000,000 1.7% 5.0% Yes 5 Years Yes
Microsoft Corp 1,000,000 0.9% 5.0% Yes 5 Years Yes
Total Technology Sector $3,000,000 2.6% 10.0% Yes
Walt Disney Co 2,000,000 1.7% 5.0% Yes 5 Years Yes
Total Communication Services Sector $2,000,000
Total Medium Term Notes (19) TRUE $21,000,000 18.2% 20.0% Yes Federal Agencies
Federal Home Loan Bank (FHLB) $10,000,000 8.6% 33.3% Yes 5 Years Yes Federal Farm Credit (FFCB) 8,000,000 6.9% 33.3% Yes 5 Years Yes Fannie Mae (FNMA) 8,000,000 6.9% 33.3% Yes 5 Years Yes
Freddie Mac (FHLMC) 2,000,000 1.7% 33.3% Yes 5 Years Yes Frarmer Mac (FAMCA) 1,000,000 0.9% 33.3% Yes 5 Years Yes Tennessee Valley Authority (TVA) 2,000,000 1.7% 33.3% Yes 5 Years Yes Total Federal Agencies (24) TRUE $31,000,000 26.8% 60.0% Yes Total Portfolio $115,653,800 100.0%
Dollar Compliance Percentage Compliance Term Compliance Temporary Suspension
Investments Book Value
LAIF $21,653,799.67
Treasury Securities 41,167,743.34
Federal Agency Issues-Coupon 30,773,845.81
Medium Term Notes 20,166,680.45
Subtotal Investments $113,762,069.27
Demand Deposit/Petty Cash
Cash in Bank $5,927,431.97
Petty Cash 2,280.41
$5,929,712.38
Subtotal City Cash & Investments $119,691,781.65
Bond Funds Held in Trust
Police Fire Refunding $674,231.50
Fire Station 2 COPs 271,375.59
Marine Ave Park Refunding 413,450.00
Metlox & Water/Wastewater Refunding 773,376.63
Utility Assessment Districts 1,169,043.83
Pension Obligation Bonds 4,496,538.70
Subtotal Bonds Held in Trust $7,798,016.25
Investment Trust Funds
PARS Pension Rate Stabilization Trust 3,490,546.80
Treasurer's Balance $130,980,344.70
CITY OF MANHATTAN BEACH
TREASURER'S REPORT
December 31, 2023
Subtotal Demand Deposit
December 3.929
November 3.843
October 3.670
September 3.534
August 3.434
July 3.305**
PMIA Average Life(1): 230
LAIF Fair Value Factor(1): 0.993543131
PMIA Daily(1): 3.96
PMIA Quarter to Date(1): 3.81
LAIF Apportionment Rate(2): 4.00
LAIF Earnings Ratio(2): 0.00010932476863589
LAIF Administrative Cost(1)*: 0.29
Treasuries
61.22%
Agencies
21.44%
Certificates of
Deposit/Bank Notes
7.72%
Time
Deposits
3.34%
Commercial
Paper
5.71%
Corporate
Bonds
0.36%
Loans
0.21%
Notes: The apportionment rate includes interest earned on the CalPERS Supplemental Pension Payment pursuant to Government Code 20825 (c)(1) and interest earned on the Wildfire Fund loan pursuant to Public Utility Code 3288 (a). *The percentage of administrative cost equals the total administrative cost divided by the quarterly interest earnings. The law provides that administrative costs are not to exceed 5% of quarterly EARNINGS of the fund. However, if the 13-week Daily Treasury Bill Rate on the last day of the fiscal year is below 1%, then administrative costs shall not exceed 8% of quarterly EARNINGS of the fund for the subsequent fiscal year. ** Revised
Source:
(1) State of California, Office of the Treasurer
(2) State of Calfiornia, Office of the Controller
PMIA Average Monthly
Effective Yields(1)
PMIA/LAIF Performance Report
as of 1/17/24
Daily rates are now available here. View PMIA Daily Rates Quarterly Performance
Quarter Ended 12/31/23
Chart does not include $2,164,000.00 in mortgages, which equatesto 0.001%. Percentages may not total 100% due to rounding.
Pooled Money Investment Account
Monthly Portfolio Composition (1)
12/31/23
$158.0 billion