Loading...
HomeMy WebLinkAboutMonthly Investment ReportCITY OF SEAL BEACH Preliminary Investment Report 11/30/2024 Investments: LAW City Securities Total Investments: Cash, Deposits, & Accrued Interest: BMO General Account Less outstanding checks Farmers & 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 22,851,022.58 29,817,947.53 52,668,970.11 3,741,765.63 (3,876,219.87) 1,839.84 144,796.80 12,182.40 52,681,152.51 NOTED AND APPROVED: Patrick Gallegos Interim City Manager Market Value 22,851,022.58 29,832,851.47 52,683,874.05 CITY OF SEAL BEACH Preliminary Investments Detail Report 11/30/2024 Issuer Settlement Date Maturity Date Interest Rate Book Value Market Value Years to Maturity Source of Market Valuation LAIF CITY: N/A N/A 4.477% 22,851,022.58 22,851,022.58 N/A LAIF Statement Total LAIF 22,851,022.58 22,851,022.58 US Treasury Notes 09/09/21 09/30/25 0.250% 358,869.14 352,778.34 0.83 Bank of New York US Treasury Notes 03/01/22 10/31/25 0.250% 200,041.41 202,290.69 0.92 Bank of New York US Treasury Notes 10/06/21 12/31/25 0.250% 425,790.23 419,030.72 1.08 Bank of New York US Treasury Notes 11/08/21 11/30/25 0.375% 706,365.23 696,980.20 1.00 Bank of New York US Treasury Notes 01/12/21 12/31/25 0.375% 139,146.88 134,175.72 1.08 Bank of New York US Treasury Notes 04/07/21 12/31/25 0.375% 322,175.39 316,271.34 1.08 Bank of New York US Treasury Notes 05/07/21 12/31/25 0.375% 344,367.19 335,439.30 1.08 Bank of New York US Treasury Notes 02/26/21 01/31/26 0.375% 146,894.53 143,296.95 1.17 Bank of New York US Treasury Notes 05/04/22 01/31/26 0.375% 204,609.38 214,945.43 1.17 Bank of New York US Treasury Notes 07/07/21 01/31/26 0.375% 274,618.75 267,487.64 1.17 Bank of New York US Treasury Notes 02/05/21 01/31/26 2.625% 409,370.31 362,947.06 1.17 Bank of New York US Treasury Notes 01/06/22 01/31/26 0.375% 438,861.72 434,667.42 1.17 Bank of New York US Treasury Notes 02/18/22 01/31/26 0.375% 628,087.30 635,283.15 1.17 Bank of New York US Treasury Notes 03/08/21 02/28/26 0.500% 532,870.31 515,320.38 1.25 Bank of New York US Treasury Notes 12/07/21 02/28/26 0.500% 564,367.19 553,492.26 1.25 Bank of New York US Treasury Notes 06/04/21 05/31/26 0.750% 139,693.75 132,917.96 1.50 Bank of New York US Treasury Notes 06/08/22 05/31/26 0.750% 265,780.47 275,330.06 1.50 Bank of New York US Treasury Notes 04/07/22 09/30/26 0.875% 391,315.43 400,230.57 1.83 Bank of New York US Treasury Notes 07/07/22 02/15/27 2.250% 487,070.31 480,039.00 2.21 Bank of New York US Treasury Notes 08/05/22 04/30/27 0.500% 625,625.00 641,921.70 2.41 Bank of New York US Treasury Notes 01/06/23 04/30/27 2.750% 795,207.03 808,547.20 2.41 Bank of New York US Treasury Notes 08/10/22 06/30/27 0.500% 323,709.38 332,820.14 2.58 Bank of New York US Treasury Notes 09/06/22 08/15/27 2.250% 474,042.97 476,289.00 2.71 Bank of New York US Treasury Notes 11/03/22 09/30/27 4.125% 203,662.70 205,023.99 2.83 Bank of New York US Treasury Notes 12/08/22 10/31/27 4.125% 294,032.81 290,113.39 2.92 Bank of New York US Treasury Notes 01/06/23 10/31/27 0.500% 685,539.26 725,726.02 2.92 Bank of New York US Treasury Notes 06/05/23 12/31/27 3.875% 552,191.41 546,240.20 3.08 Bank of New York US Treasury Notes 02/08/23 01/31/28 0.750% 555,607.03 580,903.13 3.17 Bank of New York US Treasury Notes 05/04/23 03/31/28 3.625% 302,859.38 295,394.40 3.33 Bank of New York US Treasury Notes 05/11/23 03/31/28 1.250% 364,579.10 369,008.87 3.33 Bank of New York US Treasury Notes 05/01/23 04/30/28 3.500% 482,688.67 475,470.72 3.42 Bank of New York US Treasury N/B Notes 05/03/24 04/30/29 4.625% 170,391.80 173,512.88 4.42 Bank of New York US Treasury N/B Notes 06/07/24 05/31/29 4.500% 110,996.88 111,800.37 4.50 Bank of New York US Treasury NB Notes 06/06/24 05/31/29 4.500% 590,095.90 594,574.70 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 NIB Notes 07/22/24 06/30/29 4.250% 286,146.68 286,680.93 4.58 Bank of New York US Treasury NIB Notes 07/03/24 06/30/29 4.250% 303,272.46 306,798.89 4.58 Bank of New York US Treasury NIB 08/02/24 07/31/29 4.000% 80,556.25 79,662.48 4.67 Bank of New York US Treasury NIB 09/05/24 08/31/29 3.625% 901,863.28 882,070.20 4.75 Bank of New York US Treasury NIB 10/03/24 09/30/29 3.500% 488,698.44 477,329.09 4.84 Bank of New York US Treasury NIB 11/15/24 10/31/29 4.125% 248,144.53 250,371.00 4.92 Bank of New York US Treasury NIB 11/04/24 10/31/29 4.125% 324,200.20 325,482.30 4.92 Bank of New York UNIV OF CAL TXBL REV Bonds 07/16/20 05/15/25 0.883% 100,362.00 98,411.40 0.45 Bank of New York FL ST Board of Admin TXBL Rev Bonds 09/16/20 07/01/25 1.258% 60,424.20 58,836.66 0.58 Bank of New York FL ST Board of Admin TXBL Rev Bonds 09/16/20 07/01/25 1.258% 155,000.00 151,994.71 0.58 Bank of New York NJ Turnpike Authority Txble Rev Bonds 02/04/21 01/01/26 1.047% 60,000.00 57,889.80 1.09 Bank of New York FHMS K043 A2 03/25/20 12/01/24 3.062% 57,706.61 54,801.56 0.00 Bank of New York FHMS K061 A2 05/24/23 11/01/26 3.347% 189,398.98 190,962.72 1.92 Bank of New York FHMS K065 A2 08/18/23 04/01/27 3.243% 160,284.77 165,298.48 2.33 Bank of New York FHMS K066 A2 08/22/23 06/O1/27 3.117% 247,816.41 256,590.49 2.50 Bank of New York FHMS K507 Al 09/28/23 04/01/28 4.800% 254,822.96 260,084.04 3.34 Bank of New York FHMS K506 Al 09/14/23 05/01/28 4.650% 141,178.20 143,709.25 3.42 Bank of New York FHMS KJ46 Al 07/27/23 06/01/28 4.777% 227,811.95 227,869.38 3.50 Bank of New York FHMS K505 A2 07/20/23 06/01/28 4.819% 282,796.64 282,378.88 3.50 Bank of New York FNA 2023-M6 A2 07/31/23 07/01/28 4.190% 267,713.76 268,660.96 3.59 Bank of New York FHMS KJ47 Al 09/28/23 08/01/28 5.272% 150,905.61 152,961.57 3.67 Bank of New York FHMS K506 A2 09/14/23 08/01/28 4.650% 280,784.00 285,736.44 3.67 Bank of New York FHMS K508 A2 10/19/23 08/01/28 4.740% 283,638.56 291,918.64 3.67 Bank of New York FHMS K509 A2 10/31/23 09/01/28 4.850% 212,985.74 221,963.28 3.76 Bank of New York FHMS K507 A2 09/28/23 09/01/28 4.800% 276,653.16 282,071.72 3.76 Bank of New York FHMS K510 A2 11/21/23 10/01/28 5.069% 114,667.54 116,902.33 3.84 Bank of New York FHMS K511 A2 12/07/23 10/O1/28 4.860% 164,525.96 166,804.11 3.84 Bank of New York FHMS K512 A2 12/21/23 11/01/28 5.000% 151,400.70 152,542.05 3.92 Bank of New York FHMS K513 A2 01/18/24 12/01/28 4.724% 171,698.13 170,892.67 4.01 Bank of New York FHMS K514 A2 02/08/24 12/01/28 4.572% 176,749.83 175,142.28 4.01 Bank of New York FHMS K518 A2 03/28/24 01/01/29 5.400% 209,949.73 211,862.58 4.09 Bank of New York FHMS K517 A2 03/14/24 01/01/29 5.355% 257,496.50 257,611.25 4.09 Bank of New York FHMS K515 A2 02/22/24 01/O1129 5.400% 287,543.20 287,992.88 4.09 Bank of New York FHMS K516 A2 03/07/24 01/01/29 5.477% 288,399.16 288,886.36 4.09 Bank of New York FHMS K520 A2 04/30/24 03/01/29 5.180% 160,649.44 163,785.28 4.25 Bank of New York FHMS K524 A2 07/25/24 05/01/29 4.720% 241,473.84 241,799.04 4.42 Bank of New York FHMS K522 A2 06/13/24 05/01/29 4.803% 299,999.10 302,639.40 4.42 Bank of New York FHMS K529 A2 10/16/24 09/01/29 4.791% 122,398.44 121,319.28 4.76 Bank of New York Freddie Mac Notes 09/25/20 09/23/25 0.375% 403,780.95 392,112.50 0.81 Bank of New York Fannie Mae Notes 11/12/20 11/07/25 0.500% 259,069.20 250,807.18 0.94 Bank of New York Fannie Mae Notes 11/24/20 11/07/25 0.500% 319,878.40 308,685.76 0.94 Bank of New York Goldman Sachs Group Corp 02/17/21 05/22/25 3.750% 61,444.90 54,746.95 0.47 Bank of New York Years to Source of Market Issuer Settlement Date Maturity Date Interest Rate Book Value Market Value Maturity Valuation Bristol-Myers Squibb Co Corp 06/21/21 11/13/25 0.750% 99,994.04 97,503.78 0.95 Bank of New York Bank of America Corp Notes 03/22/22 04/02/26 3.384% 210,000.00 208,918.08 1.34 Bank of New York JPMorgan Chase & Cc (Callable) 04/26/22 04/26/26 4.080% 265,000.00 264,063.76 1.40 Bank of New York Microsoft Corp Notes 02/25/22 08/08/26 2.400% 353,881.50 338,852.85 1.69 Bank of New York Paccar Financial Corp 08/11/23 08/10/26 5.050% 210,863.10 212,058.63 1.69 Bank of New York Bank of America Corp Notes 10/24/23 08/18/26 5.526% 228,063.40 233,703.23 1.72 Bank of New York Target Corp Corporate Notes 01/24/22 01/15/27 1.950% 39,932.00 38,093.44 2.13 Bank of New York Target Corp 01/31/22 01/15/27 1.950% 174,893.25 166,658.80 2.13 Bank of New York Home Depot Inc 01/30/23 09/14/27 2.800% 278,303.00 283,404.73 2.79 Bank of New York JP Morgan & Company 08/09/24 05/01/28 3.540% 179,322.35 179,987.98 3.42 Bank of New York Apple Inc Corp Notes Callabe 05/18/23 05/10/28 4.000% 425,493.00 422,463.18 3.44 Bank of New York John Deere Capital Corp Notes 07/14/23 07/14/28 4.950% 94,858.45 96,662.22 3.62 Bank of New York John Deere Capital Corp Notes 07/18/23 07/14/28 4.950% 116,116.65 117,012.16 3.62 Bank of New York Citibank NA Corp Notes 05/03/24 09/29/28 5.803% 147,804.30 151,009.96 3.83 Bank of New York Citibank NA Corp Notes 09/29/23 09/29/28 5.803% 270,000.00 281,190.96 3.83 Bank of New York Toyota Motor Credit Corp 01/10/24 01/05/29 4.650% 165,580.80 165,747.12 4.10 Bank of New York State Street Corp 08/20/24 02/20/29 4.530% 140,000.00 139,538.70 4.23 Bank of New York Blackrock Funding Inc Corporate Notes 03/14/24 03/14/29 4.700% 24,954.75 25,275.13 4.29 Bank of New York Blackrock Funding Inc Corporate 04/11/24 03/14/29 4.700% 139,350.40 141,540.70 4.29 Bank of New York Adobe Inc Corp Notes 04/05/24 04/04/29 4.800% 95,125.40 96,451.03 4.35 Bank of New York Adobe Inc Corp Notes 04/04/24 04/04/29 4.800% 114,828.65 116,756.51 4.35 Bank of New York Mastercard Inc Corp Notes 06/27/24 06/01/29 2.950% 229,662.50 235,154.75 4.50 Bank of New York PepsiCo Incmcorp Notes 07/17/24 07/17/29 4.500% 139,783.00 140,994.70 4.63 Bank of New York ELI LILLY & CO 08/14/24 08/14/29 4,200% 49,890.50 49,556.90 4.71 Bank of New York ELI LILLY & CO 08/14/24 08/14/29 4.200% 170,248.20 168,493.46 4.71 Bank of New York Cooperat Rabobank UA/NY Can Dep 07/20/23 07/17/26 5.080% 280,000.00 284,922.68 1.63 Bank of New York PNC Bank Corp Notes (Callable) 12/08/22 10/25/27 3.100% 246,455.60 249,897.44 2.90 Bank of New York Morgan Stanley Bank NA Bank Notes 05/31/24 05/26/28 5.504% 280,590.80 284,850.44 3.49 Bank of New York Hart 2021-C A3 11/17/21 05/15/26 0.740% 7,344.52 7,302.00 1.45 Bank of New York HAROT 2023-3 A3 08/22/23 02/18/28 5.400% 179,962.88 181,836.54 3.22 Bank of New York TAOT 2023-C A3 08/15/23 04/17/28 5.160% 54,987.56 55,411.51 3.38 Bank of New York TAOT 2023-D A3 11/14/23 08/15/28 5.540% 54,994.07 55,862.62 3.71 Bank of New York FITAT 2023-1 A3 08/23/23 08/15/28 5.530% 194,987.91 197,157.29 3.71 Bank of New York CHAT 2023-Al A 09/15/23 09/15/28 5.160% 224,937.63 227,790.23 3.79 Bank of New York AMXCA 2023-3 A 09/19/23 09/15/28 5.230% 229,989.72 232,987.93 3.79 Bank of New York HART 2023-C A3 11/13/23 10/16/28 5.540% 79,989.48 81,246.48 3.88 Bank of New York BACCT 2023-A2 A2 12/14/23 11/15/28 4.980% 99,986.57 100,973.50 3.96 Bank of New York GMCAR 2024-1 A3 01/17/24 12/18/28 4.850% 24,994.97 25,147.38 4.05 Bank of New York CHAIT 2024-A1 A 01/31/24 01/16/29 4.600% 249,961.93 251,035.00 4.13 Bank of New York Total Securities 29,817,947.53 29,832,861.47