HomeMy WebLinkAboutTreasurer's Report 09-2023September 2023
September 2023 Investment Report
RECOMMENDATION:
REPORT IN BRIEF:
Cash and Investments
Checking 5,835,219$
Zoo Credit Card Deposit Account 35,410
Certificates of Deposit 17,915,773
Government Securities 19,262,458
Supranational Securities 2,010,994
Municipal Securities 8,402,201
LAIF 16,121,054
Cash with Fiscal Agents 2,813,153
Cash in Banks at September 30, 2023 72,396,262$
Deposits in Transit 350,664
Timing Differences (1,204,740)
Cash and Investments at September 30, 2023 71,542,186$
Investment Activity
Securities Purchased:
Purchase Date Description Type Cost Maturity Date
07/18/23 HSBC Bank USA
McLean, VA
Certificate of
Deposit
$ 234,924 07/06/28
07/19/23 Northeast Community Bank
White Plains, NY
Certificate of
Deposit
145,600 08/20/25
07/24/23 BankUnited
Miami Lakes, FL
Certificate of
Deposit
237,000 07/23/24
07/26/23 Park State Bank
Duluth, MN
Certificate of
Deposit
249,000 07/26/28
07/31/23 Medallion Bank
Salt Lake City, UT
Certificate of
Deposit
249,000 07/31/28
08/03/23 Federal Home Loan Bank
CUSIP #310AWN63
Government
Security
492,809 06/30/28
08/16/23 New York Trans. Financial Auth
CUSIP #64971XBN7
Government
Security
785,009 08/01/28
Atascadero City Council
Council receive and file the City Treasurer's report for quarter ending September 30, 2023.
Staff Report - City Treasurer
Page 1 of 17
ITEM NUMBER: A-4
DATE: 12/12/23
Securities Purchased (continued):
Purchase Date Description Type Cost Maturity Date
09/07/23 Discover Bank
Greenwood, DE
Certificate of
Deposit
$ 244,000 09/05/28
09/13/23 United Fidelity Bank FBS
Evansville, IN
Certificate of
Deposit
249,000 08/17/28
09/13/23 Optum Bank
Draper, UT
Certificate of
Deposit
244,000 09/13/28
09/21/23 Merrick Bank
South Jordan, UT
Cerificate of
Deposit
249,000 09/21/28
09/26/23 US Treasury Bills
CUSIP #91279FS1
Government
Security
96,366 06/13/24
09/27/23 Legacy Bank & Trust
Mountain Grove, MO
Cerificate of
Deposit
249,000 09/27/28
09/27/23 Enterprise Bank
Omaha, NE
Certificate of
Deposit
223,070 06/05/26
09/27/23 First Financial Bank
Dakota Dunes, SD
Certificate of
Deposit
236,540 06/24/26
09/27/23 FAMCA
CUSIP #31422XPS5
Government
Security
446,595 11/17/26
09/28/23 Morgan Stanley Bank
Salt Lake City, UT
Certificate of
Deposit
243,619 04/06/28
09/29/23 Star Bank
Maple Lake, MN
Cerificate of
Deposit
244,000 09/29/28
09/29/23 American National Bank
Baxter, MN
Certificate of
Deposit
248,000 12/29/25
Securities Matured:
Maturity Date Description Type Original Cost Amount Matured
07/31/23 International Finace Corp
CUSIP #45950KCP3
Supranational
Security
$ 499,425 $ 500,000
07/31/23 Medallion Bank
Salt Lake City, UT
Certificate of
Deposit
245,000 245,000
08/01/23 Discover Bank
Wilmington, DE
Certificate of
Deposit
245,000 245,000
09/26/23 MidSouth Bank
Lafayette, LA
Certificate of
Deposit
245,000 245,000
09/27/23 Int'l Bank for Recon & Devel
CUSIP #459058GL1
Supranational
Security
509,790 500,000
09/27/23 Nicolet National Bank
Green Bay, WI
Certificate of
Deposit
245,000 245,000
09/29/23 Alma Bank
Astoria, NY
Certificate of
Deposit
245,000 245,000
Investment Activity (continued)
Page 2 of 17
ITEM NUMBER: A-4
DATE: 12/12/23
Securities Sold Prior to Maturity:
None
Other Reportable Activities:
None
Page 3 of 17
ITEM NUMBER: A-4
DATE: 12/12/23
CITY OF ATASCADERO
TREASURER'S REPORT
CASH & INVESTMENTS ACTIVITY SUMMARY
for the quarter ending September 30, 2023
CHECKING FISCAL
ACCOUNTS INVESTMENTS AGENT TOTALS
Balance per Banks at
July 1, 2023 $ 6,409,009 $ 71,406,881 $ 2,336,228 80,152,118$
Receipts 7,919,228 189,423 30,780 8,139,431
Recognition of Premiums &
Discounts - 24,647 - 24,647
Disbursements (15,258,324) - (661,606) (15,919,930)
Transfers In 13,275,000 5,366,533 1,107,751 19,749,284
Transfers Out (6,474,284) (13,275,000) - (19,749,284)
Balance per Banks at
September 30, 2023 $ 5,870,629 $ 63,712,484 $ 2,813,153 72,396,266
Deposits in Transit 350,664
Timing Differences (1,204,740)
Adjusted Treasurer's Balance $ 71,542,190
Page 4 of 17
ITEM NUMBER: A-4
DATE: 12/12/23
MATURITY DESCRIPTION PURCHASE INVESTMENT INVESTMENT STATED FACE PREMIUM/COST OF MARKET UNREALIZED
DATE (ISSUER)DATE TYPE RATING % RATE YIELD VALUE (DISCOUNT)INVESTMENT VALUE GAIN / (LOSS)
CITY OF ATASCADERO
INVESTMENT REPORT
September 30, 2023
Funds Managed by City
n/a
Local Agency Invest.
Fund (LAIF)n/a State Investment Fund n/a n/a 3.53%16,121,054$ n/a 16,121,054$ 15,876,473$ (244,581)$
n/a Broker Money Market n/a Money Fund n/a n/a Vary - n/a - - -
10/13/23 Luther Burbank Savings
Santa Rosa, CA
10/14/22 Certificate of Deposit n/a 4.05%4.05%240,000 n/a 240,000 239,858 (142)
11/06/23 Federal Farm Credit Bank
CUSIP #3133EJQ85
11/06/18 Government Security n/a 3.05%3.06%500,000 (4) 499,996 498,795 (1,201)
11/08/23 Morgan Stanley Private Bank
New York, NY
11/08/18 Certificate of Deposit n/a 3.55%3.55%245,000 n/a 245,000 244,463 (537)
12/08/23 Federal Home Loan Bank
CUSIP #3130AAHE1
04/30/20 Government Security n/a 2.50%0.39%640,000 2,556 642,556 636,538 (6,018)
01/30/24 First Premier Bank
Sioux Falls, SD
01/30/19 Certificate of Deposit n/a 2.95%2.95%245,000 n/a 245,000 242,922 (2,078)
02/22/24 Bank of Delight
Delight, AR
02/22/19 Certificate of Deposit n/a 2.85%2.85%245,000 n/a 245,000 242,503 (2,497)
03/08/24 Federal Home Loan Bank
CUSIP #3130AB3H7
03/07/19 Government Security Aaa 2.38%2.58%750,000 (664) 749,336 739,890 (9,446)
03/27/24 First National Bank
East Lansing, MI
03/27/19 Certificate of Deposit n/a 2.75%2.75%245,000 n/a 245,000 241,781 (3,219)
04/26/24 Mainstreet Bank
Fairfax, VA
05/01/19 Certificate of Deposit n/a 2.60%2.60%245,000 n/a 245,000 240,989 (4,011)
05/13/24 Federal Farm Credit Bank
CUSIP #3133EKLB0
05/13/19 Government Security Aaa 2.31%2.32%500,000 (21) 499,979 490,440 (9,539)
05/16/24 Enterprise Bank
Allison Park, PA
05/16/19 Certificate of Deposit n/a 2.60%2.60%245,000 n/a 245,000 240,580 (4,420)
06/01/24 Tulare County Pension Bond
CUSIP #899154AW8
09/28/20 Municipal Security A1 3.56%0.79%120,000 2,195 122,195 118,282 (3,913)
06/13/24 US Treasury Bills
CUSIP #912797FS1
09/26/23 Government Security F-1+
(Aaa equivalent)
0.00%5.25%100,000 (3,579) 96,421 96,291 (130)
06/26/24 Commerce Bank
Geneva, MN
06/26/19 Certificate of Deposit n/a 2.30%2.30%245,000 n/a 245,000 239,140 (5,860)
07/23/24 BankUnited
Miami Lakes, FL
07/24/23 Certificate of Deposit n/a 5.30%5.30%237,000 n/a 237,000 236,280 (720)
07/26/24 Abacus Federal Savings
New York, NY
07/26/19 Certificate of Deposit n/a 2.00%2.00%245,000 n/a 245,000 237,844 (7,156) Page 5 of 17
ITEM NUMBER: A-4
DATE: 12/12/23
MATURITY DESCRIPTION PURCHASE INVESTMENT INVESTMENT STATED FACE PREMIUM/ COST OF MARKET UNREALIZED
DATE (ISSUER) DATE TYPE RATING % RATE YIELD VALUE (DISCOUNT) INVESTMENT VALUE GAIN / (LOSS)
CITY OF ATASCADERO
INVESTMENT REPORT
September 30, 2023
08/01/24 Federal Farm Credit Bank
CUSIP 3133EJM55
07/24/19 Government Security Aaa 3.25% 1.92% 427,000$ 4,663$ 431,663$ 418,738$ (12,925)$
08/19/24 CF Bank
Worthington, OH
08/19/19 Certificate of Deposit n/a 1.85% 1.85% 245,000 n/a 245,000 236,932 (8,068)
08/28/24 Genoa Banking Company
Genoa, OH
08/28/19 Certificate of Deposit n/a 1.80% 1.80% 245,000 n/a 245,000 236,582 (8,418)
08/28/24 Int'l Bank for Recon & Develop
CUSIP #459056HV2
10/18/19 Supranational Security Aaa 1.50% 1.62% 500,000 (533) 499,467 481,765 (17,702)
08/30/24 Preferred Bank
Los Angeles, CA
08/30/19 Certificate of Deposit n/a 1.85% 1.85% 245,000 n/a 245,000 236,638 (8,362)
09/10/24 Peoples Bank
Rock Valley, IA
03/23/20 Certificate of Deposit n/a 1.50% 1.50% 100,000 n/a 100,000 96,154 (3,846)
09/20/24 Bank Deerfield
Deerfield, WI
09/20/19 Certificate of Deposit n/a 1.70% 1.70% 245,000 n/a 245,000 235,749 (9,251)
09/25/24 Grand River Bank
Grandville, MI
03/25/20 Certificate of Deposit n/a 1.00% 1.00% 245,000 n/a 245,000 233,963 (11,037)
10/15/24 Federal National Mortgage Assn
CUSIP #3135G0W66
03/13/20 Government Security Aaa 1.63% 0.81% 500,000 4,228 504,228 480,735 (23,493)
11/08/24 Raymond James Bank
St. Petersburg, FL
11/08/19 Certificate of Deposit n/a 1.80% 1.80% 245,000 n/a 245,000 234,879 (10,121)
11/18/24 Federal Farm Credit Bank
CUSIP #3133ENZ94
11/23/22 Government Security Aaa 4.50% 4.70% 400,000 (905) 399,095 395,952 (3,143)
12/13/24 Federal Home Loan Bank
CUSIP #3130A3GE8
03/13/20 Government Security Aaa 2.75% 0.84% 500,000 11,431 511,431 484,450 (26,981)
01/15/25 Int'l Bank for Recon & Develop
CUSIP #459058HT3
01/16/20 Supranational Security Aaa 1.63% 1.66% 500,000 (249) 499,751 476,265 (23,486)
01/20/25 Live Oak Banking Company
Wilmington, NC
01/24/20 Certificate of Deposit n/a 1.85% 1.85% 245,000 n/a 245,000 233,247 (11,753)
01/24/25 Baycoast Bank
Swansea, MA
01/24/20 Certificate of Deposit n/a 1.70% 1.70% 245,000 n/a 245,000 232,769 (12,231)
02/12/25 Federal Home Loan Mtge Corp
CUSIP #3137EAEP0
03/13/20 Government Security Aaa 1.50% 0.79% 500,000 4,837 504,837 475,260 (29,577)
03/03/25 Federal Farm Credit Bank
CUSIP #3133ELQY3
03/04/20 Government Security Aaa 1.21% 0.88% 500,000 2,305 502,305 471,535 (30,770)
03/26/25 Evergreen Bank Group
Oak Brook, IL
03/26/20 Certificate of Deposit n/a 1.00% 1.00% 245,000 n/a 245,000 228,769 (16,231)
Page 6 of 17
ITEM NUMBER: A-4
DATE: 12/12/23
MATURITY DESCRIPTION PURCHASE INVESTMENT INVESTMENT STATED FACE PREMIUM/ COST OF MARKET UNREALIZED
DATE (ISSUER) DATE TYPE RATING % RATE YIELD VALUE (DISCOUNT) INVESTMENT VALUE GAIN / (LOSS)
CITY OF ATASCADERO
INVESTMENT REPORT
September 30, 2023
03/27/25 Bank of Romney
Romney, WV
03/27/20 Certificate of Deposit n/a 1.15% 1.15% 245,000$ n/a 245,000$ 229,266$ (15,734)$
03/27/25 First Jackson Bank
Stevenson, AL
03/27/20 Certificate of Deposit n/a 1.15% 1.15% 245,000 n/a 245,000 229,266 (15,734)
04/01/25 El Cajon Taxable Pension Obl
CUSIP 282659AX9
01/27/21 Municipal Security Aa 1.18% 0.70% 650,000 4,653 654,653 605,644 (49,009)
04/28/25 First National Bank
McGregor, TX
04/28/20 Certificate of Deposit n/a 1.35% 1.35% 245,000 n/a 245,000 229,175 (15,825)
04/29/25 Flagstar Bank
Troy, MI
03/26/20 Certificate of Deposit n/a 1.15% 1.15% 245,000 n/a 245,000 228,590 (16,410)
05/01/25 Corona California Pension
CUSIP #21969AAD4
04/12/23 Municipal Security AA+ 1.13% 4.50% 450,000 (22,903) 427,097 419,809 (7,288)
05/15/25 Tennessee Valley Authority
CUSIP #880591EW8
11/09/22 Government Security Aaa 0.75% 4.77% 205,000 (12,738) 192,262 190,291 (1,971)
06/30/25 US Treasury Notes
CUSIP #912828XZ8
04/13/22 Government Security Aaa 2.75% 2.61% 500,000 1,128 501,128 480,080 (21,048)
07/01/25 Northern Calif Power Agency
CUSIP #664845FN9
04/13/22 Municipal Security Aa3 2.39% 3.04% 305,000 (3,365) 301,635 288,841 (12,794)
07/01/25 University of California
CUSIP #91412GU94
10/22/20 Municipal Security Aa2 3.06% 0.81% 300,000 11,762 311,762 289,095 (22,667)
08/18/25 Federal National Mortgage Assn
CUSIP #3136G4M75
01/09/22 Government Security Aaa 0.52% 4.70% 280,000 (20,870) 259,130 256,662 (2,468)
08/20/25 Northeast Community Bank
White Plains, NY
07/19/23 Certificate of Deposit n/a 0.45% 4.99% 160,000 (13,086) 146,914 145,600 (1,314)
09/01/25 San Bernardino Successor Agency
Swansea, MA
10/22/20 Municipal Security Aa 4.00% 0.71% 175,000 10,978 185,978 174,584 (11,394)
09/12/25 Federal Home Loan Bank
CUSIP #3130A6C70
10/04/22 Government Security Aaa 2.63% 4.13% 570,000 (15,918) 554,082 543,210 (10,872)
10/01/25 Folsom Cordova School District
CUSIP #34440PCN9
11/10/20 Municipal Security Aa- 3.00% 1.00% 400,000 15,840 415,840 381,968 (33,872)
11/07/25 Federal National Mortgage Assn
CUSIP #3135G06G3
12/14/20 Government Security Aaa 0.50% 0.42% 500,000 838 500,838 454,690 (46,148)
11/15/25 Tulare Sewer Revenue
CUSIP 899124MF5
12/11/20 Municipal Security Aa 1.46% 0.58% 400,000 7,365 407,365 367,040 (40,325)
12/11/25 BMW Bank North America
Salt Lake City, UT
12/11/20 Certificate of Deposit n/a 0.50% 0.50% 245,000 n/a 245,000 219,709 (25,291)
Page 7 of 17
ITEM NUMBER: A-4
DATE: 12/12/23
MATURITY DESCRIPTION PURCHASE INVESTMENT INVESTMENT STATED FACE PREMIUM/ COST OF MARKET UNREALIZED
DATE (ISSUER) DATE TYPE RATING % RATE YIELD VALUE (DISCOUNT) INVESTMENT VALUE GAIN / (LOSS)
CITY OF ATASCADERO
INVESTMENT REPORT
September 30, 2023
12/18/25 Third Federal Savings & Loan
Cleveland, OH
12/18/20 Certificate of Deposit n/a 1.46% 1.46% 245,000$ n/a 245,000$ 219,265$ (25,735)$
12/29/25 American Nat'l Bank
Baxter, MN
09/29/23 Certificate of Deposit n/a 5.00% 5.00% 248,000 n/a 248,000 245,210 (2,790)
01/15/26 First Reliance Bank
Florence, SC
01/15/21 Certificate of Deposit n/a 0.30% 0.30% 245,000 n/a 245,000 217,477 (27,523)
01/22/26 ConnectOne Bank
Englewood Cliffs, NJ
01/22/21 Certificate of Deposit n/a 0.45% 0.45% 245,000 n/a 245,000 218,074 (26,926)
01/22/26 Luana Savings Bank
Luana, IA
01/22/21 Certificate of Deposit n/a 0.40% 0.40% 245,000 n/a 245,000 218,033 (26,967)
02/09/26 First United Bank & Trust
Durant, OK
03/16/23 Certificate of Deposit n/a 4.25% 4.81% 120,000 (1,500) 118,500 116,657 (1,843)
02/11/26 Ind'l & Com'l Bank of China
New York, NY
02/22/21 Certificate of Deposit n/a 0.45% 0.45% 245,000 n/a 245,000 217,751 (27,249)
02/24/26 Eaglebank
Bethesda, MD
03/16/23 Certificate of Deposit n/a 4.25% 4.25% 244,000 n/a 244,000 237,170 (6,830)
03/02/26 Federal Farm Credit Bank
CUSIP #3133EFH91
03/03/21 Government Security Aaa 2.22% 0.75% 876,000 30,818 906,818 821,793 (85,025)
03/27/26 Federal Agriculture Mtge Corp
CUSIP #31422XDX7
03/30/21 Government Security n/a 0.83% 0.87% 500,000 (468) 499,532 453,210 (46,322)
04/23/26 Malaga Bank
Palos Verdes Peninsula, CA
04/23/21 Certificate of Deposit n/a 0.55% 0.55% 245,000 n/a 245,000 216,178 (28,822)
04/24/26 Federal National Mortgage Assn
CUSIP #3135G0K36
04/26/21 Government Security Aaa 2.13% 0.77% 500,000 17,206 517,206 466,360 (50,846)
05/19/26 Eaglemark Savings Bank
Reno, NV
05/19/21 Certificate of Deposit n/a 0.70% 0.70% 245,000 n/a 245,000 216,668 (28,332)
05/31/26 US Treasury Notes
CUSIP #91282CCF6
11/23/22 Government Security Aaa 0.75% 4.15% 500,000 (42,478) 457,522 449,045 (8,477)
06/01/26 Golden St TOB
CUSIP #38122NC59
05/10/23 Municipal Security A 2.16% 4.52% 150,000 (8,812) 141,188 136,182 (5,006)
06/05/26 Enterprise Bank
Omaha, NE
09/27/23 Certificate of Deposit n/a 0.85% 4.99% 249,000 (25,855) 223,145 220,460 (2,685)
06/24/26 First Financial Bank
Dakota Dunes, SD
09/27/23 Certificate of Deposit n/a 3.15% 5.11% 249,000 (12,425) 236,575 234,526 (2,049)
06/30/26 UBS Bank USA
Salt Lake City, UT
05/19/21 Certificate of Deposit n/a 0.90% 0.90% 245,000 n/a 245,000 216,634 (28,366)
Page 8 of 17
ITEM NUMBER: A-4
DATE: 12/12/23
MATURITY DESCRIPTION PURCHASE INVESTMENT INVESTMENT STATED FACE PREMIUM/ COST OF MARKET UNREALIZED
DATE (ISSUER) DATE TYPE RATING % RATE YIELD VALUE (DISCOUNT) INVESTMENT VALUE GAIN / (LOSS)
CITY OF ATASCADERO
INVESTMENT REPORT
September 30, 2023
07/01/26 New York Community Bank
Hicksville, NY
06/29/21 Certificate of Deposit n/a 0.85% 0.85% 245,000$ n/a 245,000$ 216,563$ (28,437)$
07/22/26 Toyota Financial Savings Bank
Henderson, NV
07/22/21 Certificate of Deposit n/a 0.95% 0.95% 245,000 n/a 245,000 216,676 (28,324)
08/01/26 Rancho Adobe Fire Protection
CUSIP #752096AE7
10/14/21 Municipal Security Aa 1.43% 1.25% 260,000 1,297 261,297 233,514 (27,783)
08/13/26 Synchrony Bank
Draper, UT
08/13/21 Certificate of Deposit n/a 0.90% 0.90% 245,000 n/a 245,000 215,855 (29,145)
09/24/26 Federal National Mortgage Assn
CUSIP #3135G0Q22
09/24/21 Government Security Aaa 1.88% 0.80% 500,000 15,877 515,877 459,165 (56,712)
09/29/26 First Bank Richmond
Richmond, IN
09/29/21 Certificate of Deposit n/a 0.55% 0.55% 245,000 n/a 245,000 212,493 (32,507)
10/01/26 California Infrastructure Bonds
CUSIP #13034AL73
10/05/22 Municipal Security AAA 1.04% 4.69% 155,000 (15,709) 139,291 137,394 (1,897)
10/01/26 Manteca Redevelopment Bonds
CUSIP #56453RBA1
10/05/22 Municipal Security AA 2.04% 4.81% 115,000 (8,814) 106,186 103,917 (2,269)
10/31/26 US Treasury Notes
CUSIP #912828YQ7
11/23/22 Government Security Aaa 1.63% 4.07% 250,000 (17,563) 232,437 227,480 (4,957)
11/17/26 Capital One Bank
Glen Allen, VA
11/17/21 Certificate of Deposit n/a 1.10% 1.10% 245,000 n/a 245,000 215,154 (29,846)
11/17/26 Capital One National
McLean, VA
11/17/21 Certificate of Deposit n/a 1.10% 1.10% 245,000 n/a 245,000 215,154 (29,846)
11/17/26 Federal Agricultural Mtge Corp
CUSIP #31422XPS5
09/27/23 Government Security n/a 1.15% 4.86% 500,000 (53,294) 446,706 445,715 (991)
12/21/26 Federal Home Loan Bank
CUSIP #3130AQF65
12/30/21 Government Security Aaa 1.25% 1.26% 500,000 (117) 499,883 446,480 (53,403)
12/28/26 Federal Farm Credit Bank
CUSIP #3133EJ4E6
01/18/22 Government Security Aaa 3.13% 1.58% 200,000 9,726 209,726 189,576 (20,150)
12/31/26 Bank Kremlin
Kremlin, OK
12/31/21 Certificate of Deposit n/a 1.05% 1.05% 245,000 n/a 245,000 213,579 (31,421)
01/15/27 San Joaquin Hills Trans Agency
CUSIP # 798111HF0
01/19/22 Municipal Security A2 2.15% 1.88% 500,000 4,270 504,270 452,710 (51,560)
02/10/27 Federal Agriculture Mtge Corp
CUSIP #31422XTX0
02/17/22 Government Security n/a 1.60% 1.96% 550,000 (6,423) 543,577 495,891 (47,686)
02/17/27 Beal Bank USA
Las Vegas, NV
02/23/22 Certificate of Deposit n/a 1.90% 1.90% 245,000 n/a 245,000 219,108 (25,892)
Page 9 of 17
ITEM NUMBER: A-4
DATE: 12/12/23
MATURITY DESCRIPTION PURCHASE INVESTMENT INVESTMENT STATED FACE PREMIUM/ COST OF MARKET UNREALIZED
DATE (ISSUER) DATE TYPE RATING % RATE YIELD VALUE (DISCOUNT) INVESTMENT VALUE GAIN / (LOSS)
CITY OF ATASCADERO
INVESTMENT REPORT
September 30, 2023
02/23/27 Sallie Mae Bank
Salt Lake City, UT
10/13/22 Certificate of Deposit n/a 2.20% 4.17% 184,000$ (11,417)$ 172,583$ 166,238$ (6,345)$
03/01/27 Sonoma Marin Area Rail Transit
CUSIP #835588BA1
12/07/22 Municipal Security AA 1.73% 4.45% 500,000 (42,700) 457,300 445,450 (11,850)
03/12/27 Federal Home Loan Bank
CUSIP #3130A3DU5
03/17/22 Government Security Aaa 3.00% 2.20% 500,000 13,197 513,197 470,770 (42,427)
03/16/27 American Express Nat'l Bank
Sandy, UT
03/16/22 Certificate of Deposit n/a 2.00% 2.00% 245,000 n/a 245,000 219,491 (25,509)
03/17/27 Beal Bank
Plano, TX
03/23/22 Certificate of Deposit n/a 2.00% 2.00% 245,000 n/a 245,000 218,307 (26,693)
04/14/27 Comenity Capital Bank
Draper, UT
04/14/22 Certificate of Deposit n/a 2.65% 2.65% 245,000 n/a 245,000 223,964 (21,036)
04/30/27 US Treasury Notes
CUSIP # 91282CEN7
01/18/23 Government Security Aaa 2.75% 3.64% 1,000,000 (29,769) 970,231 935,120 (35,111)
05/01/27 LA Unified School District
CUSIP # 544646A77
05/11/22 Municipal Security Aa3 5.72% 3.81% 500,000 31,835 531,835 502,365 (29,470)
05/15/27 US Treasury Notes
CUSIP #912828X88
05/24/22 Government Security Aaa 2.38% 2.87% 500,000 (8,354) 491,646 461,095 (30,551)
06/09/27 Federal Home Loan Bank
CUSIP #3130A5JU4
06/22/22 Government Security Aaa 3.04% 3.43% 200,000 (2,658) 197,342 188,096 (9,246)
06/11/27 Federal Home Loan Bank
CUSIP #3130ASGU7
06/22/22 Government Security Aaa 3.50% 3.41% 200,000 653 200,653 191,162 (9,491)
06/15/27 Federal Farm Credit Bank
CUSIP #3133EHNR0
06/22/22 Government Security Aaa 2.58% 3.43% 480,000 (14,033) 465,967 443,486 (22,481)
07/01/27 Sequoia CA Union High
CUSIP #817409N50
05/10/23 Municipal Security AA1 1.95% 4.20% 350,000 (27,037) 322,963 313,355 (9,608)
07/16/27 Federal Farm Credit Bank
CUSIP #3133EAXT0
07/26/22 Government Security Aaa 2.75% 2.98% 135,000 (1,099) 133,901 125,327 (8,574)
08/01/27 Corona Norco Ca Unif Sch Dist
CUSIP # 219764SB4
08/04/22 Municipal Security AA- 2.30% 3.63% 250,000 (11,824) 238,176 224,723 (13,453)
08/01/27 Escondido CA Unif Sch Dist
CUSIP # 2963871UV7
08/05/22 Municipal Security AA2 1.13% 3.53% 100,000 (8,532) 91,468 86,209 (5,259)
08/01/27 Martinez CA Uni Sch Dist
CUSIP # 573428MN6
08/04/22 Municipal Security AA 1.26% 3.43% 250,000 (19,311) 230,689 216,637 (14,052)
08/01/27 San Marcos CA Uni Sch Dist
CUSIP # 798755GC2
08/05/22 Municipal Security AA 2.31% 3.68% 185,000 (8,974) 176,026 166,994 (9,032)
Page 10 of 17
ITEM NUMBER: A-4
DATE: 12/12/23
MATURITY DESCRIPTION PURCHASE INVESTMENT INVESTMENT STATED FACE PREMIUM/ COST OF MARKET UNREALIZED
DATE (ISSUER) DATE TYPE RATING % RATE YIELD VALUE (DISCOUNT) INVESTMENT VALUE GAIN / (LOSS)
CITY OF ATASCADERO
INVESTMENT REPORT
September 30, 2023
08/01/27 Southwestern Comm College
CUSIP # 845389LS2
08/04/22 Municipal Security AA- 1.53% 3.53% 155,000$ (11,010)$ 143,990$ 135,999$ (7,991)$
08/26/27 Federal Agriculture Mtge Corp
CUSIP #31422XF23
09/02/22 Government Security n/a 3.20% 3.49% 500,000 (5,263) 494,737 470,735 (24,002)
09/15/27 Luminate Bank
Minnetonka, MN
09/15/22 Certificate of Deposit n/a 3.40% 3.40% 245,000 n/a 245,000 228,776 (16,224)
09/15/27 Ponce de Leon Fed Bank
Bronx, NY
09/15/22 Certificate of Deposit n/a 3.50% 3.50% 245,000 n/a 245,000 229,651 (15,349)
09/15/27 University of Pittsburgh
CUSIP # 798755GC2
09/15/22 Municipal Security AA+ 3.18% 3.81% 500,000 (11,503) 488,497 465,750 (22,747)
10/08/27 Federal National Mortgage Assn
CUSIP #3135G05Y5
10/12/22 Government Security Aaa 0.75% 4.12% 1,000,000 (123,836) 876,164 855,130 (21,034)
10/31/27 US Treasury Notes
CUSIP # 91282CAU5
11/09/22 Government Security Aaa 0.50% 4.31% 600,000 (84,888) 515,112 507,540 (7,572)
11/15/27 Tulare CA Sewer Rev
CUSIP #899124MH1
04/12/23 Municipal Security AA 1.93% 4.47% 325,000 (30,816) 294,184 284,069 (10,115)
11/15/27 US Treasury Notes
CUSIP # 9128283F5
12/07/22 Government Security Aaa 2.25% 3.79% 500,000 (29,121) 470,879 454,725 (16,154)
12/15/27 Forbright Bank
Potomac, MD
12/15/22 Certificate of Deposit n/a 4.00% 4.00% 245,000 n/a 245,000 233,358 (11,642)
12/16/27 Community West Bank NA
Goleta, CA
12/16/22 Certificate of Deposit n/a 4.00% 4.00% 245,000 n/a 245,000 233,348 (11,652)
01/12/28 Inter-American Dev Bank
CUSIP # 4581X0EH7
01/19/23 Supranational Security Aaa 4.00% 3.70% 1,000,000 11,776 1,011,776 969,430 (42,346)
02/10/28 First National Bk of Michigan
Kalamazoo, MI
02/10/23 Certificate of Deposit n/a 3.70% 3.70% 249,000 n/a 249,000 233,804 (15,196)
02/15/28 Belmont Bank & Trust
Chicago, IL
02/15/23 Certificate of Deposit n/a 3.75% 3.75% 249,000 n/a 249,000 234,242 (14,758)
02/15/28 US Treasury Notes
CUSIP # 9128283W8
02/01/23 Government Security Aaa 2.75% 3.64% 500,000 (17,936) 482,064 462,420 (19,644)
02/17/28 Vision Bank
St. Louis, MN
02/17/23 Certificate of Deposit n/a 3.75% 3.75% 249,000 n/a 249,000 234,222 (14,778)
03/10/28 Federal Home Loan Bank
CUSIP # 3130ATS57
03/15/23 Government Security Aaa 4.50% 3.90% 600,000 14,610 614,610 596,772 (17,838)
03/17/28 Affinity Bank
Covington, GA
03/17/23 Certificate of Deposit n/a 4.90% 4.90% 245,000 n/a 245,000 241,367 (3,633)
Page 11 of 17
ITEM NUMBER: A-4
DATE: 12/12/23
MATURITY DESCRIPTION PURCHASE INVESTMENT INVESTMENT STATED FACE PREMIUM/ COST OF MARKET UNREALIZED
DATE (ISSUER) DATE TYPE RATING % RATE YIELD VALUE (DISCOUNT) INVESTMENT VALUE GAIN / (LOSS)
CITY OF ATASCADERO
INVESTMENT REPORT
September 30, 2023
03/20/28 Bank Five Nine
Oconomowoc, WI
03/20/23 Certificate of Deposit n/a 4.65% 4.65% 245,000$ n/a 245,000$ 238,922$ (6,078)$
04/01/28 California State Bonds-Taxable
CUSIP #13063DGC6
04/12/23 Municipal Security AA 3.50% 3.98% 150,000 (2,921) 147,079 140,850 (6,229)
04/01/28 California State Bonds-GO
CUSIP #13063DGC6
04/12/23 Municipal Security AA 3.50% 3.98% 525,000 (10,224) 514,776 492,975 (21,801)
04/06/28 Morgan Stanley Bank
Salt Lake City, UT
09/28/23 Certificate of Deposit n/a 4.65% 4.69% 244,000 (380) 243,620 237,927 (5,693)
05/12/28 Central Bank
Little Rock, AR
05/12/23 Certificate of Deposit n/a 3.85% 3.85% 249,000 n/a 249,000 235,952 (13,048)
05/16/28 CIBC Bank
Chicago, IL
05/16/23 Certificate of Deposit n/a 4.35% 4.35% 244,000 n/a 244,000 234,752 (9,248)
05/16/28 Univest Bank & Trust
Souderton, PA
05/16/23 Certificate of Deposit n/a 4.40% 4.40% 249,000 n/a 249,000 240,001 (8,999)
05/30/28 Idaho First Bank
McCall, ID
05/30/23 Certificate of Deposit n/a 4.20% 4.20% 245,000 n/a 245,000 242,080 (2,920)
05/31/28 Customers Bank
Phoenixville, PA
05/31/23 Certificate of Deposit n/a 4.45% 4.45% 244,000 n/a 244,000 241,116 (2,884)
06/09/28 Federal Home Loan Bank
CUSIP #3130AEB25
06/20/23 Government Security AA+ 3.25% 4.03% 170,000 (5,600) 164,400 159,708 (4,692)
06/30/28 Federal Home Loan Bank
CUSIP #3130AWN63
08/03/23 Government Security Aaa 4.00% 4.33% 500,000 (7,015) 492,985 485,400 (7,585)
07/06/28 HSBC Bank USA
McLean, VA
07/18/23 Certificate of Deposit n/a 3.30% 4.57% 249,000 (13,564) 235,436 227,173 (8,263)
07/26/28 Park State Bank
Duluth, MN
07/26/23 Certificate of Deposit n/a 4.45% 4.45% 249,000 n/a 249,000 240,098 (8,902)
07/31/28 Medallion Bank
Salt Lake City, UT
07/31/23 Certificate of Deposit n/a 4.40% 4.40% 249,000 n/a 249,000 239,543 (9,457)
08/01/28 New York City Transitional Fin Auth
CUSIP #64971XBN7
08/16/23 Municipal Security Aa1 4.90% 4.90% 850,000 (63,540) 786,460 774,826 (11,634)
08/17/28 United Fidelity Bank FBS
Evansville, IN
09/13/23 Certificate of Deposit n/a 4.50% 4.50% 249,000 n/a 249,000 240,507 (8,493)
09/05/28 Discover Bank
Greenwood, DE
09/07/23 Certificate of Deposit n/a 4.55% 4.55% 244,000 n/a 244,000 236,148 (7,852)
09/13/28 Optum Bank Inc
Draper, UT
09/13/23 Certificate of Deposit n/a 4.55% 4.55% 244,000 n/a 244,000 236,124 (7,876)
Page 12 of 17
ITEM NUMBER: A-4
DATE: 12/12/23
ITEM NUMBER: A-4
DATE: 12/12/23
City of Atascadero
Investments by Type
September 2023
Investment September 2023
LAIF 16,121,054$
Certificates of Deposit 17,915,773
Government Securities 19,262,458
Supranational Securities 2,010,994
Municipal Securities 8,402,201
Cash with Fiscal Agent 2,813,153
66,525,633$
LAIF
24%
Certificates of
Deposit
27%
Government
Securities
29%
Supranational
Securities
3%
Municipal
Securities
13%Cash with
Fiscal Agent
4%
Page 14 of 17
ITEM NUMBER: A-4
DATE: 12/12/23
City of Atascadero
Investments by Maturity *
September 2023
Investment September 2023
On Demand 16,121,054$
Within One Month 240,000
One Month to One Year 7,063,613
One to Five Years 40,287,813
63,712,480$
* Cash with fiscal agent is not included in the totals for this graph because the amounts are restricted based on
bond covenants, and therefore, the City doesn't retain the option to liquefy these funds at will.
On Demand
25%
Within One Month
1%One Month to One
Year
11%
One to Five Years
63%
Page 15 of 17
ITEM NUMBER: A-4
DATE: 12/12/23
City of Atascadero
Investments by Custodial Agent
September 2023
Custodial Agent September 2023
State of California 16,121,054$
Union Bank 47,591,426
Bank of New York 2,813,153 Other
66,525,633$
State of California
24%
Union Bank
72%
Bank of New York
4%
Page 16 of 17
ITEM NUMBER: A-4
DATE: 12/12/23
City of Atascadero
Investment Yield vs. 2-Year Treasury Yield
For the Quarter Ended September 30, 2023
City Yield
2-Yr
Treasury
Weighted
Portfolio
Yield
September 2021 1.14% 0.86%
December 2021 1.08% 0.99%
March 2022 1.12% 1.49%
June 2022 1.36% 2.05%
September 2022 1.73% 2.45%
December 2022 2.19% 2.63%
March 2023 2.53% 2.93%
June 2023 2.68% 3.17%
September 2023 2.75% 2.58%
0.00%
0.50%
1.00%
1.50%
2.00%
2.50%
3.00%
3.50%
City Yield 2-Yr Treasury Weighted Portfolio Yield
Page 17 of 17
ITEM NUMBER: A-4
DATE: 12/12/23