Loading...
HomeMy WebLinkAboutMonthly Investment ReportCITY OF SEAL BEACH Preliminary Investment Report 5/31/2025 Investments: LAIF City Securities Total Investments: Cash, Deposits. & Accrued Interest: BMO General Account Less outstanding checks Fanners & Merchants Bank (Parking) Cash with Bank of New York Total Cash & Deposits: Total Investments, Cash, and Deposits: In compliance with the California Government Code Section 53646 and Resolution Number 6038; the City Treasurer of Seal Beach hereby certifies that sufficient investment liquidity and anticipated revenue are available to meet the City's budgeted expenditure requirements for the next six months. Investments in this report meet the requirements of the City of Seal Beach's adopted investment policy. Respectfully submitted, Barbara Arenado Director of Finance/City Treasurer Book Value 34,903,300.25 30,345,181.28 65,248,481.53 3,702,444.46 (1,731,678.70) 5,508.46 85,256.35 2,061,530.57 67,310,012.10 NOTED AND APPROVED: Market Value 34,903,300.25 30,648,963.15 65,552,263.40 �- 4440 - Patrick Gallegos Interim City Manager CITY OF SEAL BEACH Preliminary Investments Detail Report 5/3112025 Issuer Settlement Date Maturity Date Interest Rate Book Value Years to Source of Market Market Value Maturity Valuation LAIF CITY: N/A N/A 4.272% 34,903,300.25 34,903,300.25 N/A LAIF Statement Total LAIF., 34,903,300.25 34,903,300.25 US Treasury Notes 04/07/21 12/31/25 0.375% 87,866.02 88,008.39 0.59 Bank of New York US Treasury Notes 05/07/21 12/31/25 0.375% 344,367.19 342,254.85 0.59 Bank of New York US Treasury Notes 02/26/21 01/31/26 0.375% 146,894.53 146,190.30 0.67 Bank of New York US Treasury Notes 05/04/22 01/31/26 0.375% 204,609.38 219,285.45 0.67 Bank of New York US Treasury Notes 07/07/21 01/31/26 0.375% 274,618.75 272,888.56 0.67 Bank of New York US Treasury Notes 02/05/21 01/31/26 2.625% 409,370.31 366,025.46 0.67 Bank of New York US Treasury Notes 01/06/22 01/31/26 0.375% 438,861.72 443,443.91 0.67 Bank of New York US Treasury Notes 02/18/22 01/31/26 0.375% 628,087.30 648,110.33 0.67 Bank of New York US Treasury Notes 03/08/21 02/28/26 0.500% 532,870.31 525,255.30 0.75 Bank of New York US Treasury Notes 12/07/21 02/28/26 0.500% 564,367.19 564,163.10 0.75 Bank of New York US Treasury Notes 06/04/21 05/31/26 0.750% 139,693.75 135,367.96 1.00 Bank of New York US Treasury Notes 06/08/22 05/31/26 0.750% 265,780.47 280,405.06 1.00 Bank of New York US Treasury Notes 04/07/22 09/30/26 0.875% 391,315.43 407,651.50 1.33 Bank of New York US Treasury Notes 07/07/22 02/15/27 2.250% 487,070.31 485,859.50 1.71 Bank of New York US Treasury Notes 08/05/22 04/30/27 0.500% 625,625.00 656,140.80 1.92 Bank of New York US Treasury Notes 01/06/23 04/30/27 2.750% 795,207.03 816,799.51 1.92 Bank of New York US Treasury Notes 08/10/22 06/30/27 0.500% 323,709.38 340,334.03 2.08 Bank of New York US Treasury Notes 09/06/22 08/15/27 2.250% 474,042.97 482,597.50 2.21 Bank of New York US Treasury Notes 11/03/22 09/30/27 4.125% 203,662.70 206,056.98 2.33 Bank of New York US Treasury Notes 12/08/22 10/31/27 4.125% 294,032.81 291,461.31 2.42 Bank of New York US Treasury Notes 06/05/23 12/31/27 3.875% 552,191.41 549,849.85 2.59 Bank of New York US Treasury Notes 02/08/23 01/31/28 0.750% 555,607.03 594,105.63 2.67 Bank of New York US Treasury Notes 05/04/23 03/31/28 3.625% 302,859.38 297,960.90 2.84 Bank of New York US Treasury Notes 05/11/23 03/31/28 1.250% 364,579.10 376,586.82 2.84 Bank of New York US Treasury Notes 05/01/23 04/30/28 3.500% 482,688.67 479,809.05 2.92 Bank of New York US Treasury Notes 05/03/24 04/30/29 4.625% 170,391.80 174,176.90 3.92 Bank of New York US Treasury Notes 06/07/24 05/31/29 4.500% 110,996.88 112,234.43 4.00 Bank of New York US Treasury Notes 06/06/24 05/31/29 4.500% 590,095.90 596,883.11 4.00 Bank of New York US Treasury Notes 07/22/24 06/30/29 4.250% 286,146.68 288,184.02 4.08 Bank of New York US Treasury Notes 07/03/24 06/30/29 4.250% 303,272.46 308,407.46 4.08 Bank of New York US Treasury Notes 08/02/24 07/31/29 4.000% 80,556.25 80,150.00 4.17 Bank of New York US Treasury Notes 09/05/24 08/31/29 3.625% 901,863.28 888,327.90 4.25 Bank of New York US Treasury Notes 10/03/24 09/30/29 3.500% 488,698.44 481,118.75 4.34 Bank of New York US Treasury Notes 11/15/24 10/31/29 4.125% 248,144.53 251,562.50 4.42 Bank of New York US Treasury Notes 11/04/24 10/31/29 4.125% 324,200.20 327,031.25 4.42 Bank of New York US Treasury Notes 12/06/24 11/30/29 4.125% 721,293.75 724,809.60 4.50 Bank of New York Years to Source of Market Issuer Settlement Date Maturity Date Interest Rate Book Value Market Value Maturity Valuation US Treasury Notes 01/07/25 12/31/29 4.375% 453,986.91 462,500.22 4.59 Bank of New York US Treasury Notes 02/05/25 01/31/30 4.250% 408,478.52 414,692.45 4.67 Bank of New York US Treasury Notes 03/05/25 02/28/30 4.000% 390,000.00 390,487.50 4.75 Bank of New York Treasury Bill 05/15/25 06/03/25 0.000% 104,766.03 104,987.61 0.01 Bank of New York Florida ST Board of Admin 09/16/20 07/01/25 1.258% 60,424.20 59,831.94 0.08 Bank of New York Florida ST Board of Admin 09/16/20 07/01/25 1.258% 155,000.00 154,565.85 0.08 Bank of New York NJ Turnpike Authority Txble 02/04/21 01/01/26 1.047% 60,000.00 58,874.16 0.59 Bank of New York FHMS K061 A2 05/24/23 11/01/26 3.347% 187,027.75 190,134.96 1.42 Bank of New York FHMS K065 A2 08/18/23 04/01/27 3.243% 160,284.77 166,723.93 1.84 Bank of New York FHMS K066 A2 08/22/23 06/01/27 3.117% 247,816.41 259,268.85 2.00 Bank of New York FHMS K507 Al 09/28/23 04/01/28 4.800% 248,293.82 255,091.77 2.84 Bank of New York FHMS K506 Al 09/14/23 05/01/28 4.650% 140,403.37 143,642.90 2.92 Bank of New York FHMS KJ46 Al 07/27/23 06/01/28 4.777% 226,598.81 227,723.24 3.01 Bank of New York FHMS K505 A2 07/20/23 06/01/28 4.819% 282,796.64 283,570.28 3.01 Bank of New York FNA 2023-M6 A2 07/31/23 07/01/28 4.190% 267,615.27 270,776.18 3.09 Bank of New York FHMS KJ47 Al 09/28/23 08/01/28 5.272% 148,480.43 151,014.42 3.17 Bank of New York FHMS K506 A2 09/14/23 08/01/28 4.650% 280,784.00 287,458.98 3.17 Bank of New York FHMS K508 A2 10/19/23 08/01/28 4.740% 283,638.56 293,272.94 3.17 Bank of New York FHMS K509 A2 10/31/23 09/01/28 4.850% 212,985.74 223,389.54 3.26 Bank of New York FHMS K507 A2 09/28/23 09/01/28 4.800% 276,653.16 284,178.16 3.26 Bank of New York FHMS K510 A2 11/21/23 10/01/28 5.069% 114,667.54 117,579.45 3.34 Bank of New York FHMS K511 A2 12/07/23 10/01/28 4.860% 164,525.96 167,488.53 3.34 Bank of New York FHMS K512A2 12/21/23 11/01/28 5.000% 151,400.70 153,102.90 3.42 Bank of New York FHMS K513 A2 01/18/24 12/01/28 4.724% 171,698.13 172,141.49 3.51 Bank of New York FHMS K514 A2 02/08/24 12/01/28 4.572% 176,749.83 176,131.90 3.51 Bank of New York FHMS K518 A2 03/28/24 01/01/29 5.400% 209,949.73 211,981.28 3.59 Bank of New York FHMS K517 A2 03/14/24 01/01/29 5.355% 257,496.50 258,427.25 3.59 Bank of New York FHMS K515 A2 02/22/24 01/01/29 5.400% 287,543.20 289,490.04 3.59 Bank of New York FHMS K516 A2 03/07/24 01/01/29 5.477% 288,399.16 289,837.24 3.59 Bank of New York FHMS K520 A2 04/30/24 03/01/29 5.180% 160,649.44 164,266.40 3.75 Bank of New York FHMS K524 A2 07/25/24 05/01/29 4.720% 241,473.84 242,908.32 3.92 Bank of New York FHMS K522 A2 06/13/24 05/01/29 4.803% 299,999.10 304,426.80 3.92 Bank of New York FHMS K529 A2 10/16/24 09/01/29 4.791% 122,398.44 121,841.04 4.26 Bank of New York FHMS K535 A2 02/13/25 11/01/29 4.690% 150,092.70 151,757.25 4.42 Bank of New York FHMS K533 A2 01/16/25 12/01/29 4.230% 170,477.82 173,908.35 4.51 Bank of New York Bristol-Myers Squibb Co 06/21/21 11/13/25 0.750% 99,994.04 99,370.87 0.45 Bank of New York Microsoft Corp 02/25/22 08/08/26 2.400% 353,881.50 343,068.25 1.19 Bank of New York Paccar Financial Corp 08/11/23 08/10/26 5.050% 210,863.10 211,830.78 1.19 Bank of New York Bank of America N/A 10/24/23 08/18/26 5.526% 228,063.40 232,894.55 1.22 Bank of New York Target Corp 01/24/22 01/15/27 1.950% 39,932.00 38,637.48 1.63 Bank of New York Target Corp 01/31/22 01/15/27 1.950% 174,893.25 169,038.98 1.63 Bank of New York Goldman Sachs Bank USA 05/22/25 05/21/27 5.414% 100,629.00 100,680.90 1.97 Bank of New York Goldman Sachs Bank USA 05/22/25 05/21 /27 5.414% 120,754.80 120,817.08 1.97 Bank of New York Yearsto Source of Market Issuer Settlement Date Maturity Date Interest Rate Book Value Market Value Maturity Valuation Home Depot Inc 01/30/23 09/14/27 2.800% 278,303.00 286,237.32 2.29 Bank of New York JP Morgan Chase & Company 08/09/24 05/01/28 3.540% 179,322.35 181,566.40 2.92 Bank of New York Apple Inc 05/18/23 05/10/28 4.000% 425,493.00 425,157.25 2.95 Bank of New York John Deere Capital 07/14/23 07/14/28 4.950% 94,858.45 96,925.65 3.12 Bank of New York John Deere Capital 07/18/23 07/14/28 4.950% 116,116.65 117,331.05 3.12 Bank of New York Citibank NA Corp Notes 05/03/24 09/29/28 5.803% 147,804.30 150,819.57 3.33 Bank of New York Citibank NA Corp Notes 09/29/23 09/29/28 5.803% 270,000.00 280,836.45 3.33 Bank of New York Toyota Motor Credit Corp 01/10/24 01/05/29 4.650% 165,580.80 165,986.21 3.60 Bank of New York Bank of America Corp (Callable) 04/02/25 01/24/29 4.979% 212,326.80 211,997.52 3.65 Bank of New York State Street Corp 08/20/24 02/20/29 4.530% 140,000.00 140,441.56 3.73 Bank of New York Blackrock Funding Inc 03/14/24 03/14/29 4.700% 24,954.75 25,379.60 3.79 Bank of New York Blackrock Funding Inc 04/11/24 03/14/29 4.700% 139,350.40 142,125.76 3.79 Bank of New York Adobe Inc (Callabel) 04/05/24 04/04/29 4.800% 95,125.40 96,920.62 3.85 Bank of New York Adobe Inc (Callabel) 04/04/24 04/04/29 4.800% 114,828.65 117,324.96 3.85 Bank of New York Bank of New York Mellon 05/04/25 04/20/29 4.729% 439,384.80 438,559.60 3.89 Bank of New York Mastercard Inc (Callable) 06/27/24 06/01/29 2.950% 229,662.50 238,234.50 4.01 Bank of New York PepsiCo Inc (Callable) 07/17/24 07/17/29 4.500% 139,783.00 141,298.08 4.13 Bank of New York ELI LILLY & CO 08/14/24 08/14/29 4.200% 49,890.50 49,879.70 4.21 Bank of New York ELI LILLY & CO 08/14/24 08/14/29 4.200% 170,248.20 169,590.98 4.21 Bank of New York CISCO Systems Inc 04/22/25 02/24/30 4.750% 217,713.30 218,409.26 4.74 Bank of New York CISCO Systems Inc 04/30/25 02/24/30 4.750% 230,159.25 228,567.83 4.74 Bank of New York JPMorgan Chase & Co (Callable) 04/28/25 04/22/30 5.581% 268,088.60 268,230.82 4.90 Bank of New York Wallmart Inc (Callable) 04/28/25 04/28/30 4.350% 84,852.95 85,239.45 4.91 Bank of New York Wallmart Inc (Callable) 05/02/25 04/28/30 4.350% 353,132.50 350,985.95 -95.16 Bank of New York Cooperat Rabobank UA/NY Cart Dep 07/20/23 07/17/26 5.080% 280,000.00 283,410.68 1.13 Bank of New York PNC Bank N/A (Callable) 12/08/22 10/25/27 3.100% 245,455.60 252,588.44 2.40 Bank of New York Morgan Stanley Bank NA Bank Notes 05/31/24 05/26/28 5.504% 280,590.80 284,947.60 2.99 Bank of New York HAROT 2023-3 A3 08/22/23 02/18/28 5.410% 167,827.04 168,887.46 2.72 Bank of New York TAOT 2023-C A3 08/15/23 04/17/28 5.160% 54,987.56 55,280.83 2.88 Bank of New York TAOT 2023-D A3 11/14/23 08/15/28 5.540% 54,994.07 55,602.20 3.21 Bank of New York FITAT 2023-1 A3 08/23/23 08/15/28 5.530% 191,328.19 192,679.82 3.21 Bank of New York CHAIT 2023-Al A 09/15/23 09/15/28 5.160% 224,937.63 227,182.28 3.30 Bank of New York AMXCA 2023-3 A 09/19/23 09/15/28 5.230% 229,989.72 232,407.18 3.30 Bank of New York HART 2023-C A3 11/13/23 10/16/28 5.540% 79,989.48 80,916.56 3.38 Bank of New York BACCT 2023-A2 A2 12/14/23 11/15/28 4.980% 99,986.57 100,916.80 3.46 Bank of New York GMCAR 2024-1 A3 01/17/24 12/18/28 4.850% 24,994.97 25,115.30 3.55 Bank of New York CHAIT 2024-Al A 01/31/24 01/16/29 4.600% 249,961.93 251,199.75 3.63 Bank of New York HAROT 2025-1 A3 02/11/25 09/21/29 4.570% 214,993.38 216,445.45 4.31 Bank of New York HART 2025-A A3 03/12/25 10/15/29 4.320% 189,971.97 189,916.59 4.38 Bank of New York TAOT 2025-B A3 04/30/25 11/15/29 4.340% 109,993.70 110,068.09 4.46 Bank of New York GMCAR 2025-2 A3 05/14/25 04/16/30 4.280% 49,992.64 50,041.05 -95.19 Bank of New York Total Securities 30,345,181.28 30,648,963.15