CITY OF MANHATTAN BEACH
Portfolio Management
November 1, 2024 through November 30, 2024
Portfolio Summary
% of
Portfolio
Book
ValueInvestments
Market
Value
Par
Value
Days to
Maturity
Term
YTM
360 Equiv.
YTM
365 Equiv.
LAIF 24,825,568.26 122.39 4.416124,825,568.2624,825,568.26 4.477 Medium Term Notes 21,099,477.26 1,65619.03 4.0071,10521,215,500.0022,000,000.00 4.062 Federal Agency Issues - Coupon 19,839,792.95 1,56017.89 3.55090019,800,670.0020,000,000.00 3.599 Treasury Securities - Coupon 45,127,299.65 1,60940.69 2.38275144,413,570.0046,000,000.00 2.415 110,892,138.12 100.00%
Investments
110,255,308.26112,825,568.26 1,249 677 3.356 3.402
Cash
(not included in yield calculations)
Passbook/Checking 2,656,591.42 1 0.00012,656,591.422,656,591.42 0.000 113,548,729.54Total Cash and Investments 112,911,899.68115,482,159.68 1,249 677 3.356 3.402 Current Year
November 30
271,800.21
Fiscal Year To Date
1,365,584.35
Total Earnings Month Ending
__________________________________________________ ____________________
CITY OF MANHATTAN BEACH,
Portfolio CITY
CP
Reporting period 11/01/2024-11/30/2024
Run Date: 01/10/2025 - 11:20 PM (PRF_PM1) 7.3.11
Report Ver. 7.3.11
YTM
365
Par Value Book Value
Maturity
Date
Stated
RateMarket Value
November 30, 2024
Portfolio Details - Investments
Issuer
Portfolio Management
CITY OF MANHATTAN BEACH
Days to
Maturity
S&PCUSIP Investment #
Purchase
Date
LAIF
4.477Local Agency Invest. Fund3000 24,825,568.26 24,825,568.26 4.47724,825,568.26SYS3000 1 24,825,568.2624,825,568.2624,825,568.26Subtotal and Average 4.477 1 Medium Term Notes
4.905APPLE INCMTN0112 1,000,000.00 943,931.65 09/12/20272.90010/25/2022 964,260.00 AA+037833DB3 1,015
4.171APPLE INCMTN0121 1,000,000.00 992,446.00 05/10/20284.00006/12/2023 994,030.00 AA+037833ET3 1,256
1.963AMAZON.COM LLCMTN0111 1,000,000.00 981,907.34 05/12/20261.00002/24/2022 953,840.00 AA023135BX3 527
4.282AMAZON.COM LLCMTN0116 1,000,000.00 966,354.70 08/22/20273.15002/09/2023 970,620.00 AA023135BC9 994
4.342AMAZON.COM LLCMTN0129 1,000,000.00 962,290.00 04/13/20293.45007/12/2024 968,260.00023135CG9 1,594
4.410BANK OF NY MELLOMTN0118 1,000,000.00 967,997.71 01/29/20283.40004/14/2023 968,920.00 A06406RAF4 1,154
4.690COLGATE-PALM COMTN0123 2,000,000.00 1,992,460.00 03/01/20284.60007/10/2023 2,038,700.00 AA-194162AR4 1,186
3.743COSTCO COMPANIESMTN0117 1,000,000.00 931,869.54 06/20/20271.37504/14/2023 929,550.00 A+22160KAN5 931
3.765COSTCO COMPANIESMTN0119 1,000,000.00 931,086.17 06/20/20271.37504/18/2023 929,550.00 A+22160KAN5 931
4.593Johnson & JohnsonMTN0113 1,000,000.00 896,074.87 09/01/20270.95010/25/2022 918,130.00 AAA478160CP7 1,004
3.880Johnson & JohnsonMTN0114 1,000,000.00 911,850.46 09/01/20270.95012/22/2022 918,130.00 AAA478160CP7 1,004
4.374COCA-COLA COMTN0124 1,000,000.00 882,607.15 03/15/20281.00007/10/2023 903,060.00 A+191216DD9 1,200
3.556COCA-COLA COMTN0126 1,000,000.00 896,438.27 03/15/20281.00002/05/2024 903,060.00 A+191216DD9 1,200
4.163MICROSOFT CORPMTN0115 1,000,000.00 978,929.29 02/06/20273.30012/22/2022 980,870.00 AAA594918BY9 797
0.950MERCK & CO INCMTN0110 1,000,000.00 991,420.00 02/24/20260.75010/05/2021 956,910.00 A+58933YAY1 450
4.210MERCK & CO INCMTN0120 1,000,000.00 992,917.00 05/17/20284.05006/12/2023 994,050.00 A+58933YBH7 1,263
5.044PepsicoMTN0125 1,000,000.00 980,093.27 05/15/20284.45011/02/2023 1,006,780.00 A+713448FR4 1,261
4.493TOYOTA MOTOR CREDITMTN0127 1,000,000.00 1,008,418.76 01/05/20294.65002/05/2024 1,004,530.0089236TLL7 1,496
4.650TOYOTA MOTOR CREDITMTN0130 1,000,000.00 1,000,000.00 01/05/20294.65007/12/2024 1,004,530.0089236TLL7 1,496
4.183WALMART INCMTN0122 1,000,000.00 937,273.08 09/17/20261.05006/12/2023 944,300.00 AA931142ER0 655
4.349WALMART INCMTN0128 1,000,000.00 953,112.00 07/08/20293.25007/12/2024 963,420.00931142EN9 1,680 21,099,477.2621,215,500.0022,000,000.00Subtotal and Average 4.062 1,105 Federal Agency Issues - Coupon
3.850FARMER MACFAC0304 1,000,000.00 1,000,000.00 02/14/20283.85002/14/2023 989,690.0031422XW99 1,170
1.870FED FARM CR BKFAC0294 1,000,000.00 997,642.00 08/22/20251.80002/24/2022 981,580.00 AA+3133ENPX2 264
2.747FED FARM CR BKFAC0296 2,000,000.00 2,021,594.07 03/22/20273.15004/11/2022 1,954,720.00 AA+3133EJDV8 841
4.550FED FARM CR BKFAC0303 1,000,000.00 998,356.00 07/27/20264.50010/27/2022 1,003,510.003133ENV72 603
4.860FED FARM CR BKFAC0309 1,000,000.00 1,000,600.00 11/01/20284.87511/02/2023 1,024,980.00 AA+3133EPA47 1,431
4.527FED FARM CR BKFAC0311 2,000,000.00 2,023,573.04 04/30/20294.75005/08/2024 2,046,520.003133ERDH1 1,611
1.871Federal Home Loan BankFAC0293 1,000,000.00 995,852.00 09/12/20251.75002/24/2022 979,960.00 AA+3130A8ZQ9 285
4.343Federal Home Loan BankFAC0302 1,000,000.00 934,623.29 06/12/20260.87510/24/2022 949,920.003130AN4T4 558 Portfolio CITY
CP
Run Date: 01/10/2025 - 11:20 PM (PRF_PM2) 7.3.11
Report Ver. 7.3.11
YTM
365
Par Value Book Value
Maturity
Date
Stated
RateMarket Value
November 30, 2024
Portfolio Details - Investments
Issuer
Portfolio Management
CITY OF MANHATTAN BEACH
Days to
MaturityS&PCUSIP Investment #
Purchase
Date
Federal Agency Issues - Coupon
4.048Federal Home Loan BankFAC0306 1,000,000.00 975,013.99 03/12/20273.00006/12/2023 974,590.00 AA+3130A3DU5 831
4.483Federal Home Loan BankFAC0307 1,000,000.00 984,533.05 06/09/20284.00007/10/2023 994,330.00 AA+3130AWC24 1,286
4.861Federal Home Loan BankFAC0308 1,000,000.00 995,280.00 09/08/20284.75011/02/2023 1,020,040.00 AA+3130AXEL8 1,377
4.514Federal Home Loan BankFAC0310 2,000,000.00 2,013,840.13 03/09/20294.62505/09/2024 2,031,020.003130B13J4 1,559
2.722Federal Home Loan MortgageFAC0298 2,000,000.00 1,943,414.62 09/23/20250.37505/13/2022 1,936,360.00 AA+3137EAEX3 296
3.597Fannie MaeFAC0305 1,000,000.00 915,277.45 10/08/20270.75004/14/2023 911,120.003135G05Y5 1,041
1.763Tennessee Valley AuthorityFAC0295 1,000,000.00 990,779.81 05/15/20250.75002/24/2022 982,980.00 AA+880591EW8 165
2.894Tennessee Valley AuthorityFAC0299 1,000,000.00 1,049,413.50 11/01/20256.75005/13/2022 1,019,350.00 AA+880591CJ9 335 19,839,792.9519,800,670.0020,000,000.00Subtotal and Average 3.599 900 Treasury Securities - Coupon
0.561US TREASURYUST0036 1,000,000.00 996,637.25 06/30/20250.25005/28/2021 976,580.00912828ZW3 211
0.591US TREASURYUST0039 1,000,000.00 996,542.18 06/30/20250.25008/11/2021 976,580.00912828ZW3 211
1.058US TREASURYUST0047 1,000,000.00 992,734.35 05/31/20250.25012/08/2021 979,700.00912828ZT0 181
1.001US TREASURYUST0051 1,000,000.00 1,003,906.25 02/28/20251.12512/09/2021 991,920.00912828ZC7 89
2.665US TREASURYUST0054 2,000,000.00 1,942,665.19 01/31/20271.50004/08/2022 1,890,160.00912828Z78 791
3.287US TREASURYUST0057 1,000,000.00 962,656.44 08/15/20261.50006/17/2022 955,630.009128282A7 622
3.285US TREASURYUST0059 1,000,000.00 975,290.12 05/15/20272.37509/01/2022 958,980.00912828X88 895
3.295US TREASURYUST0060 1,000,000.00 975,011.88 05/15/20272.37509/01/2022 958,980.00912828X88 895
3.241US TREASURYUST0062 1,000,000.00 922,684.54 06/30/20270.50009/01/2022 911,840.00912828ZV5 941
4.180US TREASURYUST0064 1,000,000.00 940,644.20 10/31/20261.62510/25/2022 953,440.00912828YQ7 699
3.747US TREASURYUST0066 1,000,000.00 954,216.88 08/15/20272.25002/09/2023 952,580.009128282R0 987
0.576US TREASURYUST0037 2,000,000.00 1,992,499.32 07/31/20250.25005/28/2021 1,946,020.0091282CAB7 242
0.620US TREASURYUST0038 1,000,000.00 995,505.14 08/31/20250.25005/28/2021 969,530.0091282CAJ0 273
0.601US TREASURYUST0040 1,000,000.00 996,228.70 07/31/20250.25008/11/2021 973,010.0091282CAB7 242
0.586US TREASURYUST0041 1,000,000.00 995,729.88 08/31/20250.25008/11/2021 969,530.0091282CAJ0 273
0.658US TREASURYUST0042 1,000,000.00 995,884.44 11/30/20250.37508/09/2021 961,350.0091282CAZ4 364
0.681US TREASURYUST0043 1,000,000.00 995,194.98 07/31/20250.25010/05/2021 973,010.0091282CAB7 242
0.707US TREASURYUST0044 2,000,000.00 1,986,800.82 10/31/20250.25010/05/2021 1,926,580.0091282CAT8 334
0.907US TREASURYUST0045 1,000,000.00 992,500.00 08/31/20260.75010/05/2021 942,030.0091282CCW9 638
0.892US TREASURYUST0046 1,000,000.00 994,414.00 07/31/20260.62510/05/2021 942,460.0091282CCP4 607
1.191US TREASURYUST0048 1,000,000.00 991,815.34 05/31/20260.75012/09/2021 949,410.0091282CCF6 546
1.176US TREASURYUST0049 1,000,000.00 993,675.72 06/30/20260.87512/09/2021 948,830.0091282CCJ8 576
1.210US TREASURYUST0050 1,000,000.00 992,487.39 09/30/20260.87512/09/2021 941,720.0091282CCZ2 668
1.678US TREASURYUST0052 2,000,000.00 1,961,979.95 09/30/20250.25002/24/2022 1,933,040.0091282CAM3 303
2.581US TREASURYUST0053 1,000,000.00 965,661.46 10/31/20261.12504/08/2022 943,870.0091282CDG3 699 Portfolio CITY
CP
Run Date: 01/10/2025 - 11:20 PM (PRF_PM2) 7.3.11
YTM
365
Par Value Book Value
Maturity
Date
Stated
RateMarket Value
November 30, 2024
Portfolio Details - Investments
Issuer
Portfolio Management
CITY OF MANHATTAN BEACH
Days to
Maturity
S&PCUSIP Investment #
Purchase
Date
Treasury Securities - Coupon
2.750US TREASURYUST0055 1,000,000.00 996,500.00 04/15/20252.62505/16/2022 993,550.0091282CEH0 135
3.187US TREASURYUST0056 1,000,000.00 946,618.08 07/31/20260.62506/17/2022 942,460.0091282CCP4 607
3.302US TREASURYUST0058 1,000,000.00 947,668.91 09/30/20260.87506/17/2022 941,720.0091282CCZ2 668
3.300US TREASURYUST0061 1,000,000.00 997,755.04 06/30/20273.25009/01/2022 978,710.0091282CEW7 941
3.309US TREASURYUST0063 1,000,000.00 984,738.49 07/31/20272.75009/01/2022 965,120.0091282CFB2 972
3.787US TREASURYUST0065 1,000,000.00 969,708.53 07/31/20272.75012/22/2022 965,120.0091282CFB2 972
3.804US TREASURYUST0067 2,000,000.00 1,982,503.95 01/31/20283.50002/09/2023 1,963,200.0091282CGH8 1,156
4.816US TREASURYUST0068 1,000,000.00 985,413.83 08/31/20284.37511/01/2023 1,008,440.0091282CHX2 1,369
3.750US TREASURYUST0069 2,000,000.00 2,020,691.46 01/31/20294.00002/02/2024 1,991,100.0091282CJW2 1,522
4.430US TREASURYUST0070 1,000,000.00 992,220.00 02/28/20294.25005/08/2024 1,005,230.0091282CKD2 1,550
4.474US TREASURYUST0071 1,000,000.00 987,053.69 03/31/20294.12505/08/2024 1,000,390.0091282CKG5 1,581
4.421US TREASURYUST0072 1,000,000.00 1,009,000.00 04/30/20294.62505/08/2024 1,020,660.0091282CKP5 1,611
4.123US TREASURYUST0073 1,000,000.00 940,330.00 05/31/20292.75007/12/2024 944,690.0091282CES6 1,642
4.147US TREASURYUST0074 1,000,000.00 961,700.00 06/30/20293.25007/12/2024 964,490.0091282CEV9 1,672
4.062US TREASURYUST0075 1,000,000.00 892,031.25 10/31/20281.37507/12/2024 901,910.0091282CDF5 1,430 45,127,299.6544,413,570.0046,000,000.00Subtotal and Average 2.415 751 Total and Average 112,825,568.26 3.402 677110,255,308.26 110,892,138.12 Portfolio CITY
CP
Run Date: 01/10/2025 - 11:20 PM (PRF_PM2) 7.3.11
YTM
365
Par Value Book Value
Stated
RateMarket Value
November 30, 2024
Portfolio Details - Cash
Issuer
Portfolio Management
CITY OF MANHATTAN BEACH
Days to
Maturity
S&PCUSIP Investment #
Purchase
Date
Money Market Fund
0.000UNION BANK39901 2,656,591.42 2,656,591.422,656,591.42SYS39903-39902 1 Subtotal and Average
Total Cash and Investments 115,482,159.68 3.402 677
1 112,911,899.68 113,548,729.54
Portfolio CITY
CP
Run Date: 01/10/2025 - 11:20 PM (PRF_PM2) 7.3.11
City of Manhattan Beach
Investment Portfolio Summary
As of November 30, 202
4 PORTFOLIO PROFILE Nov 30, 2024 Oct 31, 2024 Sep 30, 2024 Aug 31, 2024 Jul 31, 2024 Total Book Value (Excluding Trust Funds) $110,892,138 $113,575,230 $116,590,715 $116,588,909 $127,590,866 Increase/(Decrease) from Prior Period (2,683,091) (3,015,485) 1,806 (11,001,958) (5,935,682) Percentage Change (2.4%) (2.6%) 0.0% (8.6%) (4.4%)
Average Yield to Maturity (365 Days) 3.402% 3.426% 3.343% 3.273% 3.258% Increase/(Decrease) from Prior Period (0.024%) 0.083% 0.070% 0.014% 0.021%
PORTFOLIO ALLOCATIONS
By Security Value (Par) Percent Par YTM Time Horizon Percent LAIF* $24,825,568 22.00% 4.477% Next 12 months 42%
Medium Term Notes 22,000,000 19.5% 4.062% Months 13-24 13% Federal Agencies 20,000,000 17.7% 3.599% Months 25-36 18% U.S. Treasuries 46,000,000 40.8% 2.415% Months 37-48 14% Total $112,825,568 100.0% 3.400% Months 49-60 13%
*LAIF YTM as of November 30, 2024 BAD Total 100.0%
RECENT ACTIVITY
Security Date of Activity Maturity Date Purchase (Par) Maturing/Call YTM WMT - 3.25% Coupon 7/12/2024 7/8/2029 1,000,000 4.349%
AMZN - 3.45% Coupon 7/12/2024 4/13/2029 1,000,000 4.342% TOYOTA - 4.65% Coupon 7/12/2024 1/5/2029 1,000,000 4.650% T - 4.11% Coupon 7/12/2024 5/31/2029 1,000,000 4.123%
T - 4.11% Coupon 7/12/2024 6/30/2029 1,000,000 4.147%
T - 4.14% Coupon 7/12/2024 10/31/2028 1,000,000 4.062%
Total Purchases $6,000,00 0 4.279%
Matured: BK - 2.1% Coupon 10/24/2024 10/24/2024 1,000,000 1.850% Matured: FNMA - 1.625% Coupon 10/15/2024 10/15/2024 2,000,000 1.700% Matured: FNMA - 1.625% Coupon 10/15/2024 10/15/2024 2,000,000 1.500% Matured: FFCB - 0.875% Coupon 11/18/2024 11/18/2024 1,000,000 3.250% Total Maturing/Calls $6,000,000 1.917%
City of Manhattan Beach
Investment Portfolio Summary
As of November 30, 202
4 3‐Month 6 ‐Month 2 ‐Year 5 ‐Year 10 ‐Year
September 2024 4.92% 4.55% 3.62% 3.50% 3.72%
October 2024 4.72% 4.44% 3.97% 3.91% 4.10%
November 2024 4.62% 4.43% 4.26% 4.23% 4.36%
Portfolio 3.402% 3.402% 3.402% 3.402% 3.402%
LAIF 4 477% 4 477% 4 477% 4 477% 4 477%
Portfolio, 3.402%
LAIF, 4.477%
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
December 2024 through November 2029
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 Dec 24 Dec 25 Dec 26 Dec 27 Dec 28
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 Jan 29 1/5/29 4.49% TOYOT A nc $1.0M 1/31/28 3.80% T nc $2.0M 1/31/29 3.75% T nc $2.0M
1/5/29 4.65% TOYOT A nc $1.0M
Feb 25 2/28/25 1.0% 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% FAMC A nc $1.0M Feb 29 2/28/29 4.43% 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 Mar 29 3/31/29 4.47% T nc $1.0M 3/12/27 4.05% FHLB nc $1.0M 3/15/28 4.37% KO nc $1.0M 3/9/29 4.51% FHLB nc $2.0M 3/15/28 3.56% KO nc $1.0M
Apr 25 4/15/25 2.8% T nc $1.0M Apr 26 Apr 27 Apr 28 Apr 29 4/13/29 4.34% AMZN nc $1.0M 4/30/29 4.42% T nc $1.0M
4/30/29 4.53% FFCB nc $2.0M
May 25 5/15/25 1.8% 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/10/28 4.17% AAPL nc $1.0M May 29 5/31/29 4.12% T nc $1.0M 5/31/25 1.1% T nc $1.0M 5/12/26 1.96% AMZN nc $1.0M 5/15/27 3.29% T nc $1.0M 5/17/28 4.21% MRK nc $1.0M 5/15/28 5.04% PEP nc $1.0M
Jun 25 6/30/25 0.6% 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 Jun 29 6/30/29 4.15% T nc $1.0M 6/30/25 0.6% 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 25 7/31/25 0.6% 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 Jul 29 7/8/29 4.35% WMT nc $1.0M 7/31/25 0.6% 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.7% T nc $1.0M 7/27/26 4.55% FFCB nc $1.0M
Aug 25 8/31/25 0.6% 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 Aug 29 8/31/25 0.6% T nc $1.0M 8/15/26 3.29% T nc $1.0M 8/22/27 4.28% AMZN nc $1.0M 8/22/25 1.9% FFCB nc $1.0M
Sep 25 9/12/25 1.9% 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.86% FHLB nc $1.0M Sep 29 9/23/25 2.7% 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.7% T nc $2.0M 9/17/26 4.18% WMT nc $1.0M 9/1/27 3.88% JNJ nc $1.0M Oct 25 10/31/25 0.7% 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/31/28 4.06% T nc $1.0M Oct 29 10/31/26 4.18% T nc $1.0M
Nov 25 11/30/25 0.7% T nc $1.0M Nov 26 Nov 27 Nov 28 11/1/28 4.86% FFCB nc $1.0M Nov 29 11/1/25 2.9% TVA nc $1.0M
Total By Year (excl LAIF) $22.0m $15.0m $20.0m $16.0m $15.0m Average YTM 1.3% 2.5% 3.7% 4.4% 4.4%
% of Total Securities (excl LAIF) 25% 17% 23% 18% 17%
% of Total Investments (incl LAIF) 42% 13% 18% 14% 13%
Total Securities 78%
$88.0M
LAIF 22% $24.8M
Total Investments 100% $112.8M
Shaded rows indicate months with significant cash inflows.
City of Manhattan Beach
Investment Policy Compliance Chart
As of November 30, 202
4 Instrument % of Total Limit Compliant? Limit Compliant? Limit Compliant? Local Agency Investment Fund (LAIF) $24,825,568 22.0% $75,000,000 Yes Treasury Securities
US Treasury $46,000,000 40.8% 5 Years Yes
Total U.S. Treasuries (40) TRUE $46,000,000 40.8%
Medium Term (Corporate) Notes
Coca-Cola 2,000,000 1.8% 5.0% Yes 5 Years Yes
Amazon 3,000,000 2.7% 5.0% Yes 5 Years Yes
Costco 2,000,000 1.8% 5.0% Yes 5 Years Yes
Walmart 2,000,000 1.8% 5.0% Yes 5 Years Yes
Colgate-Palmolive 2,000,000 1.8% 5.0% Yes 5 Years Yes
Pepsi Cola 1,000,000 0.9% 5.0% Yes 5 Years Yes
Total Consumer Goods Sector $12,000,000 10.0% 10.0% Yes Bank of NY 1,000,000 0.9% 5.0% Yes 5 Years Yes
Toyota Motor Credit Corp 2,000,000 1.8% 5.0% Yes 5 Years Yes Total Financial Sector $3,000,000 2.7% 10.0% Yes
Johnson & Johnson 2,000,000 1.8% 5.0% Yes 5 Years Yes
Merck 2,000,000 1.8% 5.0% Yes 5 Years Yes
Total Pharmaceuticals Sector $4,000,000 3.5% 10.0% Yes
Apple Inc 2,000,000 1.8% 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.7% 10.0% Yes
Total Medium Term Notes (21) TRUE $22,000,000 19.5% 20.0% Yes Federal Agencies
Federal Home Loan Bank (FHLB) $7,000,000 6.2% 33.3% Yes 5 Years Yes Federal Farm Credit (FFCB) 7,000,000 6.2% 33.3% Yes 5 Years Yes Fannie Mae (FNMA) 1,000,000 0.9% 33.3% Yes 5 Years Yes
Freddie Mac (FHLMC) 2,000,000 1.8% 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.8% 33.3% Yes 5 Years Yes Total Federal Agencies (16) TRUE $20,000,000 17.7% 60.0% Yes Total Portfolio $112,825,568 100.0%
Dollar Compliance Percentage Compliance Term Compliance Temporary Suspension
Investments Cash Balances by Fund
LAIF $24,825,568.26 General Fund $21,176,562.40
Treasury Securities 45,127,299.65 Street Lighting & Landscape Fund (149,913.65) Government Agency Issues 19,839,792.95 Gas Tax Fund 4,952,169.88 Medium Term Notes 21,099,477.26 Asset Forfeiture Fund 268,540.18 Subtotal Investments $110,892,138.12 Police Safety Grants Fund 572,830.26 Grants Fund -
Prop. A Fund 837,976.19
Prop. C Fund 1,318,758.83
Demand Deposit/Petty Cash AB 2766 Air Quality Fund 300,237.53 Cash in Bank $2,656,591.42 Measure R Fund 2,189,679.68
Petty Cash 2,317.07 Measure M Fund 1,255,080.79
$2,658,908.49 Measure W Fund 1,884,224.00
Capital Improvements Fund 12,537,456.14
Subtotal City Cash & Investments $113,551,046.61 Fire Station #2 Construction Fund 455,549.37 UUAD Construction Fund 1,494,831.15
Water Fund 10,270,989.87
Bond Funds Held in Trust Stormwater Fund 4,448,516.45
Police Fire Refunding $1,866.01 Sewer Fund 18,360,482.49 Fire Station 2 COPs 312.51 Parking Fund 5,932,774.53
Marine Ave Park Refunding 0.14 County Parking Lots Fund 285,021.33 Metlox & Water/Wastewater Refunding 281.86 State Pier and Parking Lot Fund 1,310,478.60 Utility Assessment Districts 1,149,813.91 Insurance Reserve Fund 17,216,173.66 Pension Obligation Bonds 2,437.33 Information Technology Fund 1,305,665.27 Subtotal Bonds Held in Trust $1,154,711.76 Fleet Management Fund 3,588,370.08 Building Maintenance & Operations Fund 78,845.07
Special Assessment Redemption Fund 570,247.66
Investment Trust Funds Special Assessment UAD 12 & 14 Fund 457,251.84 PARS Pension Rate Stabilization Trust 3,786,387.78 Special Assessment UAD 19-4 Fund 180,899.00 Pension Trust Fund (29,425.51)
Special Deposits Fund 1,635,485.28
Section 115 Trust Fund 3,786,387.78
Total Treasurer's Balance $118,492,146.15 Total All Funds $118,492,146.15
CITY OF MANHATTAN BEACH
TREASURER'S REPORT
November 30, 2024
Subtotal Demand Deposit
1. Street Lighting & Landscape Fund will be reimbursed by General Fund subsidy transfer at end of fiscal year.
2. Pension Trust Fund will be reimbursed by California Employers' Retiree Benefit Trust (CERBT) at end of fiscal year.
November 4.477
October 4.518
September 4.575
August 4.579
July 4.516
June 4.480
(2)LAIF Apportionment Rate : 4.71
(2) LAIF Earnings Ratio : 0.00012912073474208
(1)* LAIF Administrative Cost : 0.26
(1) LAIF Fair Value Factor : 1.002061084
(1)PMIA Daily : 4.58
(1)PMIA Quarter to Date : 4.56
(1)PMIA Average Life : 231
Treasuries
55.96%
Agencies
24.20%
Certificates of
Deposit/Bank Notes
8.96%
Time
Deposits
3.51%
Commercial
Paper
6.63%
Corporate
Bonds
0.61%
Loans
0.13%
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.
Source:
(1) State of California, Office of the Treasurer
(2) State of California, Office of the Controller
PMIA Average Monthly
Effective Yields(1)
PMIA/LAIF Performance Report
as of 12/18/24
Daily rates are now available here. View PMIA Daily Rates Quarterly Performance
Quarter Ended 09/30/24
Chart does not include $1,290,000.00 in mortgages, which equates to 0.001%. Percentages may not total 100% due to rounding.
Pooled Money Investment Account
Monthly Portfolio Composition (1)
11/30/24
$146.8 billion