Loading...
HomeMy WebLinkAboutAgenda Report - November 17, 2021 C-03AGENDAITEM (1003 CITY OF LODI COUNCIL COMMUNICATION TM AGENDA TITLE: Accept the Quarterly Investment Report as Required by the City of Lodi Investment Policy MEETING DATE: November 17, 2021 PREPARED BY: Deputy City Manager RECOMMENDED ACTION: Accept the quarterly investment report as required by the City of Lodi Investment Policy. BACKGROUND INFORMATION: Government Code Section 53646 prescribes suggested investment reporting requirements for California public agencies. The City Council adopted Resolution 2018-33 on March 7, 2018, requiring the Treasurer to submit a quarterly investment reporting in accordance with Section 53646. The attached Treasurer's Report for the quarter ending September 30, 2021 is in compliance with the State's reporting recommendations and the City of Lodi's Investment Policy and Internal Control Guidelines. The investment report, investment policy and historical investment reports can be accessed on the City website by following this link: http://www.lodi.gov/196/Finance FISCAL IMPACT: Not applicable. FUNDING AVAILABLE: As per attached report. Attachment PPR Q x Andrew Keys Treasurer Stephen Schwabauer, City Manager TYPE OF INVESTMENT Cash and Equivalents Farmers & Merchants Bank Main Farmers & Merchants Bank Payroll Local Agency Investment Fund Farmer's & Merchants Bank Money Market Wells Fargo Bank Money Market * Total Demand Deposit Accounts Bond Mutual Fund CAL TRUST Medium Term Fund Total Bond Mutual Funds Local Bank Certificates of Deposit Farmers & Merchants Bank Total Local Bank Certificates of Deposit Negotiable Certificates of Deposit MB FINANCIAL BANK NA MERRICK BANK DISCOVER BANK THIRD FEDERAL SAVINGS & LOAN CLEVELAND BMW BANK NORTH AMERICA ENERBANK USA HORIZON BANK NATION ASSN CITI BANK CAPITAL ONE BANK USA NA CAPITAL ONE NA GOLDMAN SACHS BANK USA WELLS FARGO BANK NA AMERICAN EXPRESS BANK FSB SYNCHRONY BANK SALLIE MAE BANK/SALT LAKE CITY, UTAH STATE BANK OF INDIA MEDALLION BANK UTAH STIFEL BANK AND TRUST CITIBANK NA INDUSTRIAL & COM BK CHNA COMENITY CAPITAL BANK UBS BANK BARCLAYS BANK/DELAWARE BANK OF BARODA MCHENRY SAVINGS BK IL MORGAN STANLEY BANK MORGAN STANLEY PRIVATE BANK Total Negotiable Certificates of Deposit Agency Securities FEDERAL NATIONAL MORTGAGE ASSOCIATION FEDERAL HOME LOAN BANK FEDERAL NATIONAL MORTGAGE ASSOCIATION FEDERAL HOME LOAN BANK FEDERAL HOME LOAN BANK FEDERAL FARM CREDIT BANK SYSTEM FEDERAL NATIONAL MORTGAGE ASSOCIATION FEDERAL HOME LOAN BANK FEDERAL NATIONAL MORTGAGE ASSOCIATION FEDERAL FARM CREDIT BANK SYSTEM FEDERAL FARM CREDIT BANK SYSTEM FEDERAL HOME LOAN BANK FEDERAL AGRICULTURE MORTGAGE CORPORATION FEDERAL HOME LOAN BANK ** FREDDIE MAC FEDERAL HOME LOAN BANK FEDERAL HOME LOAN BANK FEDERAL HOME LOAN BANK CITY OF LODI SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED SEPTEMBER 30, 2021 Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio Due on Demand 3,666,615 3,666,615 2.36% Due on Demand 50,527 50,527 0.03% Due on Demand 54,317,344 54,317,344 34.92% Due on Demand 10,423,990 10,423,990 6.70% Due on Demand 2,737,370 2,737,370 1.76% 71,195,845 71,195,845 45.77% Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio Due on Demand 10,526,455 10,526,455 6.77% 10,526,455 10,526,455 6.77% Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio 1.00% 11/7/2021 2,000,000 2,000,000 2,000,000 1.29% 2,000,000 2,000,000 2,000,000 1.29% Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio 2.00% 11/17/2021 250,000 250,000 250,620 0.16% 2.10% 11/17/2021 250,000 250,000 250,653 0.16% 2.15% 11/22/2021 250,000 250,000 250,754 0.16% 2.10% 11/24/2021 250,000 250,000 250,763 0.16% 2.20% 11/29/2021 250,000 250,000 250,875 0.16% 2.55% 1/18/2022 250,000 250,000 251,837 0.16% 2.85% 5/4/2022 250,000 250,000 254,103 0.16% 1.95% 8/23/2022 250,000 250,000 254,203 0.16% 2.40% 11/22/2022 250,000 250,000 256,462 0.16% 2.40% 11/22/2022 250,000 250,000 256,462 0.16% 2.40% 11/22/2022 250,000 250,000 256,462 0.16% 2.40% 11/22/2022 250,000 250,000 256,448 0.16% 2.50% 12/5/2022 250,000 246,700 256,851 0.17% 2.60% 1/19/2023 250,000 250,000 257,885 0.17% 2.65% 1/24/2023 250,000 250,000 258,122 0.17% 2.70% 2/16/2023 250,000 250,000 258,629 0.17% 2.90% 4/10/2023 250,000 250,000 260,126 0.17% 2.95% 5/15/2023 250,000 250,000 260,876 0.17% 3.25% 6/6/2023 250,000 250,000 262,470 0.17% 3.30% 6/30/2023 250,000 250,000 263,113 0.17% 3.30% 7/16/2023 250,000 250,000 263,372 0.17% 3.35% 10/5/2023 250,000 250,000 264,956 0.17% 3.35% 10/10/2023 250,000 250,000 265,027 0.17% 3.55% 11/30/2023 250,000 250,000 266,926 0.17% 2.80% 3/14/2024 250,000 250,000 264,070 0.17% 1.95% 11/29/2024 250,000 250,000 260,038 0.17% 1.90% 11/29/2024 250,000 250,000 259,647 0.17% 6,750,000 6,746,700 6,961,749 4.48% Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio 1.38% 10/7/2021 250,000 238,925 250,056 0.16% 2.63% 12/10/2021 250,000 248,750 251,195 0.16% 2.00% 1/5/2022 250,000 243,225 251,221 0.16% 2.63% 3/11/2022 250,000 248,850 252,868 0.16% 2.62% 5/27/2022 250,000 249,475 254,183 0.16% 1.88% 6/1/2022 250,000 242,050 253,017 0.16% 2.00% 8/26/2022 250,000 242,725 254,341 0.16% 3.13% 9/9/2022 250,000 254,250 257,110 0.17% 2.38% 1/19/2023 250,000 246,300 257,066 0.17% 2.65% 3/8/2023 250,000 249,325 258,793 0.17% 2.70% 4/11/2023 250,000 249,500 259,460 0.17% 2.85% 5/8/2023 250,000 250,175 260,588 0.17% 2.90% 7/24/2023 250,000 249,150 261,945 0.17% 2.75% 12/13/2024 500,000 500,000 534,360 0.34% 0.60% 10/27/2025 500,000 497,750 494,518 0.32% 0.90% 12/26/2025 500,000 499,900 499,099 0.32% 0.85% 3/30/2026 400,000 399,840 398,511 0.26% 1.00% 4/15/2026 500,000 500,000 505,029 0.32% CITY OF LODI SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED SEPTEMBER 30, 2021 TYPE OF INVESTMENT Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio Agency Securities Cont'd FEDERAL HOME LOAN BANK 1.20% 4/28/2026 500,000 500,000 500,070 0.32% FEDERAL HOME LOAN BANK 1.00% 5/26/2026 500,000 500,000 498,844 0.32% FEDERAL HOME LOAN BANK ** 1.88% 9/11/2026 400,000 400,000 416,933 0.27% Total Agency Securities 7,050,000 7,010,190 7,169,205 4.61% US Treasury Notes Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio UNITED STATES TREASURY 2.00% 10/31/2021 250,000 244,125 250,396 0.16% UNITED STATES TREASURY 2.00% 12/31/2021 400,000 394,520 401,930 0.26% UNITED STATES TREASURY 1.50% 1/31/2022 250,000 240,150 251,203 0.16% UNITED STATES TREASURY 1.88% 2/28/2022 250,000 243,375 251,875 0.16% UNITED STATES TREASURY 1.88% 3/31/2022 250,000 243,150 252,246 0.16% UNITED STATES TREASURY 1.75% 5/31/2022 250,000 242,225 252,793 0.16% UNITED STATES TREASURY 1.75% 6/30/2022 250,000 242,075 253,105 0.16% UNITED STATES TREASURY 1.88% 7/31/2022 250,000 243,025 253,711 0.16% UNITED STATES TREASURY 1.63% 8/31/2022 250,000 240,325 253,496 0.16% UNITED STATES TREASURY 1.88% 9/30/2022 250,000 242,675 254,404 0.16% UNITED STATES TREASURY 2.00% 10/31/2022 250,000 243,750 255,098 0.16% UNITED STATES TREASURY 2.00% 11/30/2022 250,000 243,600 255,449 0.16% UNITED STATES TREASURY 2.13% 12/31/2022 250,000 244,700 256,221 0.16% UNITED STATES TREASURY 1.50% 2/28/2023 250,000 237,075 254,688 0.16% UNITED STATES TREASURY 1.50% 3/31/2023 250,000 236,800 254,902 0.16% UNITED STATES TREASURY 1.63% 4/30/2023 250,000 238,225 255,576 0.16% UNITED STATES TREASURY 1.63% 5/31/2023 250,000 236,525 255,811 0.16% UNITED STATES TREASURY 2.63% 6/30/2023 250,000 247,375 260,391 0.17% UNITED STATES TREASURY 1.25% 7/31/2023 250,000 231,625 254,570 0.16% UNITED STATES TREASURY ** 0.38% 11/30/2025 350,000 350,000 343,205 0.22% UNITED STATES TREASURY** 0.38% 1/31/2026 350,000 350,000 342,357 0.22% UNITED STATES TREASURY 0.75% 3/31/2026 500,000 498,300 496,289 0.32% UNITED STATES TREASURY 0.75% 5/31/2026 500,000 499,500 495,606 0.32% Total US Treasury Notes 6,600,000 6,433,120 6,655,322 4.28% Corporate Securities Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio BOEING COMPANY 2.35% 10/30/2021 250,000 245,375 250,348 0.16% PFIZER INC 2.20% 12/15/2021 200,000 198,280 200,806 0.13% TOYOTA MOTOR CREDIT CORP 2.60% 1/11/2022 250,000 246,650 251,618 0.16% PACIFICORP 2.95% 2/1/2022 250,000 249,825 250,514 0.16% JOHNSON&JOHNSON 2.25% 3/3/2022 250,000 245,175 251,727 0.16% WELLS FARGO & COMPANY 3.50% 3/8/2022 400,000 413,080 405,589 0.26% TD AMERITRADE HOLDING COMPANY 2.95% 4/1/2022 250,000 247,250 252,233 0.16% ORACLE CORP 2.50% 5/15/2022 100,000 99,200 101,003 0.06% UNITED PARCEL SERVICE 2.35% 5/16/2022 100,000 98,750 101,150 0.07% DEERE & COMPANY 2.60% 6/8/2022 100,000 99,150 101,046 0.06% 3M COMPANY 2.00% 6/26/2022 150,000 144,480 151,988 0.10% TOYOTA MOTOR CREDIT CORPORATION 2.80% 7/13/2022 250,000 246,950 255,018 0.16% PROCTER & GAMBLE COMPANY 2.15% 8/11/2022 250,000 243,150 254,296 0.16% MERCK & CO INC 2.40% 9/15/2022 100,000 98,700 101,565 0.07% JPMORGAN CHASE & CO 3.25% 9/23/2022 100,000 101,380 102,940 0.07% GENERAL ELECTRIC CO 2.70% 10/9/2022 250,000 242,525 255,878 0.16% MICROSOFT CORP 2.65% 11/3/2022 250,000 247,575 255,445 0.16% AUSTRALIA & NEW ZEALAND BANKING GROUP NY 2.63% 11/9/2022 250,000 243,450 256,489 0.16% VISA INC 2.80% 12/14/2022 250,000 247,525 256,553 0.16% JPMORGAN CHASE & CO 2.97% 1/15/2023 150,000 147,510 151,101 0.10% BANK OF NEW YORK MELLON CORP 2.95% 1/29/2023 100,000 100,070 103,282 0.07% WELLS FARGO NATIONAL BANK WEST 1.90% 1/30/2023 250,000 250,000 255,694 0.16% WELLS FARGO & COMPANY 3.45% 2/13/2023 150,000 152,145 156,101 0.10% UNITED HEALTH GROUP INC 2.75% 2/15/2023 100,000 99,140 102,702 0.07% EXXON MOBIL CORPORATION 2.73% 3/1/2023 250,000 247,050 257,550 0.17% WALMART INC 2.55% 4/11/2023 250,000 244,525 257,251 0.17% APPLE INC 2.40% 5/3/2023 250,000 240,875 258,078 0.17% SOUTHERN CALIFORNIA EDISON 3.40% 6/1/2023 254,000 252,857 265,070 0.17% CHEVRON CORPORATION 3.19% 6/24/2023 250,000 249,300 260,580 0.17% NEW YORK UNIVERSITY 2.72% 7/1/2023 230,000 234,899 236,668 0.15% ORACLE CORP 3.63% 7/15/2023 250,000 253,425 264,224 0.17% IBM CORP 3.38% 8/1/2023 500,000 492,500 527,061 0.34% CITY OF LODI SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED SEPTEMBER 30, 2021 TYPE OF INVESTMENT Interest Rate MaturityDate Par Value Cost Market Value % of Portfolio Corporate Securities Cont'd SHELL INTERNATIONAL FIN 3.40% 8/12/2023 250,000 252,275 264,099 0.17% GILEAD SCIENCES INC 2.50% 9/1/2023 260,000 249,886 269,426 0.17% PROV ST JOSEPH HEALTH OBL 4.38% 10/1/2023 315,000 340,704 337,235 0.22% PRES & FELLOWS OF HARVAR 2.60% 10/1/2023 300,000 306,750 309,746 0.20% TOYOTA MOTOR CREDIT CORP 2.25% 10/18/2023 250,000 235,225 259,159 0.17% NATIONAL RURAL UTIL COOP 3.40% 11/15/2023 300,000 297,900 316,565 0.20% ALABAMA POWER CO 3.55% 12/1/2023 250,000 249,875 266,189 0.17% TOYOTA MOTOR CREDIT CORP 3.35% 1/8/2024 400,000 399,280 425,082 0.27% JOHN DEERE CAPITAL CORP 3.45% 1/10/2024 250,000 250,450 266,759 0.17% BP CAP MARKETS AMERICA 3.79% 2/6/2024 500,000 529,500 535,118 0.34% 3M COMPANY 3.25% 2/14/2024 300,000 314,610 318,419 0.20% BOEING CO 2.80% 3/1/2024 250,000 248,500 260,097 0.17% DETROIT EDISON CO 3.65% 3/15/2024 300,000 318,180 319,614 0.21% BANK OF AMERICA CORP 4.00% 4/1/2024 250,000 261,725 270,808 0.17% CATERILLAR FINANCIAL SERVICE 3.30% 6/9/2024 500,000 527,550 536,339 0.34% AMERICAN HONDA FINANCE ** 0.55% 7/12/2024 400,000 400,000 397,649 0.26% WALT DISNEY COMPANY 1.75% 8/30/2024 500,000 499,300 515,424 0.33% WELLS FARGO & COMPANY 3.30% 9/9/2024 500,000 264,825 807,062 0.52% AMERICAN HONDA FINANCE 2.15% 9/10/2024 500,000 499,550 520,018 0.33% SHELL INTERNATIONAL FIN 2.00% 11/7/2024 500,000 497,650 519,516 0.33% CATERILLAR FINANCIAL SERVICE 3.25% 12/1/2024 500,000 528,700 540,705 0.35% TOYOTA MOTOR CREDIT CORP 1.80% 2/13/2025 300,000 299,940 308,042 0.20% WESTPAC BANKING CORP 2.35% 2/19/2025 500,000 514,250 523,093 0.34% APPLE INC 0.55% 8/20/2025 500,000 492,150 492,252 0.32% JOHNSON & JOHNSON ** 0.55% 9/1/2025 950,000 950,000 938,065 0.60% NATIONAL RURAL UTIL COOP 1.00% 9/15/2025 500,000 499,250 495,603 0.32% TOYOTA MOTOR CREDIT CORP 0.80% 10/16/2025 500,000 493,650 493,358 0.32% TOYOTA MOTOR CREDIT CORP 0.80% 1/9/2026 500,000 498,800 493,129 0.32% APPLE INC 0.70% 2/8/2026 500,000 492,000 494,245 0.32% PUBLIC STORAGE 0.88% 2/15/2026 300,000 297,720 296,224 0.19% MERCK & CO INC 0.75% 2/24/2026 400,000 398,640 394,608 0.25% JP MORGAN CHASE BANK 1.00% 3/26/2026 250,000 250,000 251,106 0.16% BMO HARRIS BANK NA 1.00% 4/13/2026 250,000 250,000 250,633 0.16% AMAZON.COM INC 1.00% 5/12/2026 500,000 498,800 499,458 0.32% CHARLES SCHWAB CORP 1.15% 5/13/2026 500,000 499,500 500,672 0.32% BANK OF AMERICA CORP 1.25% 5/28/2026 500,000 500,000 488,137 0.31% BANK OF AMERICA CORP ** 1.20% 6/25/2026 500,000 500,000 496,913 0.32% TOYOTA FINANCIAL SGS BK ** 0.95% 7/29/2026 250,000 250,000 249,958 0.16% BANK OF AMERICA CORP ** 1.15% 9/10/2026 250,000 250,000 248,210 0.16% Total Corporate Securities 22,509,000 22,329,901 23,320,302 14.99% Municipal Securities Interest Rate MaturityDate Par Value Cost Market Value % of Portfolio ROSEVILLE FINANCE AUTHORITY - ELECTRIC SYSTEM 2.41% 2/1/2022 250,000 246,925 251,706 0.16% POMONA REDEV AGY-REF 3.55% 2/1/2022 275,000 282,123 277,561 0.18% CA ST-TXBL 6.65% 3/1/2022 640,000 349,440 328,445 0.21% STATE OF MARYLAND 2.65% 3/15/2022 300,000 300,480 303,347 0.19% CALIFORNIA EDUCATIONAL FACILITIES AUTHORITY 2.46% 4/1/2022 250,000 246,275 252,318 0.16% CALIFORNIA ST-A-TXBL 2.37% 4/1/2022 500,000 496,950 505,357 0.32% SACRAMENTO CA PUBLIC 3.79% 4/1/2022 175,000 182,000 177,725 0.11% CALIFORNIA STATE DEPT OF WATER RESOURCES 2.00% 5/1/2022 300,000 291,690 303,224 0.19% UNIV OF CALIFORNIA -BC 2.61% 5/15/2022 250,000 250,000 253,797 0.16% FAIRFIELD-REF-TXBL 3.25% 6/1/2022 150,000 154,560 152,763 0.10% TULARE COUNTY CA PENSION OBLIGATION 3.20% 6/1/2022 250,000 250,250 254,972 0.16% ARKANSAS ST AMENDMENT 82 2.84% 7/1/2022 100,000 100,500 101,908 0.07% ADELANTO PUBLIC UTILITIES 3.50% 7/1/2022 240,000 246,936 245,253 0.16% ORANGE COUNTY CA WATER DIST 1.83% 8/15/2022 125,000 124,925 126,651 0.08% OCEANSIDE CA PENSION OBLIGATION 3.84% 8/15/2022 200,000 209,600 205,914 0.13% VISTA CA REDEVELOPMENT 3.00% 9/1/2022 120,000 120,960 122,605 0.08% SAN BERNARDINO COUNTY REDEVELOPMENT 3.25% 9/1/2022 160,000 161,840 163,585 0.11% SAN LEANDRO CA REDEVELOPMENT AGENCY 3.21% 9/1/2022 260,000 260,884 266,354 0.17% SAN FRANCISCO CITY & COUNTY CA 2.40% 11/1/2022 445,000 437,035 455,373 0.29% CALIFORNIA DEPARTMENT OF WATER RESOURCES 2.52% 12/1/2022 75,000 74,243 77,046 0.05% CARSON CA REDEVELOPMENT 3.00% 2/1/2023 80,000 81,000 82,619 0.05% CALIFORNIA HOUSING FINANCE AGENCY 2.88% 2/1/2023 200,000 200,000 462,415 0.30% CITY OF LODI SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED SEPTEMBER 30, 2021 TYPE OF INVESTMENT Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio Municipal Securities Cont'd GEORGIA ST GENERAL OBLIGATION 2.23% 2/1/2023 310,000 299,553 318,333 0.20% FRESNO FING-B REF 3.18% 4/1/2023 285,000 282,236 295,690 0.19% OHIO ST THIRD FRONTIER RESEARCH 2.11% 5/1/2023 250,000 240,275 256,878 0.17% RIVERSIDE CA PENSION OBLIGATION 2.63% 6/1/2023 250,000 243,900 258,232 0.17% SAN DIEGO TOBACCO SETTLEMENT 3.44% 6/1/2023 500,000 500,750 522,881 0.34% INDUSTRY-REF-TXBL 3.00% 7/1/2023 500,000 502,450 500,914 0.32% SOLANO COMMUNITY COLLEGE DT 2.06% 8/1/2023 145,000 145,000 149,562 0.10% CALIFORNIA VARIOUS PURPOSE 3.50% 8/1/2023 305,000 310,490 321,939 0.21% VISTA REDEV AGENCY-TXBL 3.00% 9/1/2023 290,000 300,643 301,356 0.19% CENTRAL CONTRA COSTA SANITATION DISTRICT 3.12% 9/1/2023 415,000 417,283 436,235 0.28% CALIFORNIA STATE MUNI TAX 2.25% 10/1/2023 250,000 239,750 259,243 0.17% OAKLAND PENSION-TXBL 4.35% 12/15/2023 400,000 440,880 431,816 0.28% RIVERSIDE CA UNIFIED SCHOOL DIST 1.98% 2/1/2024 400,000 400,000 413,324 0.27% CALIFORNIA ST-TXBL-B ** 3.00% 4/1/2024 200,000 200,000 212,427 0.14% CORTE MADERA-TXBL-REF 2.75% 5/1/2024 150,000 150,300 156,975 0.10% TULARE COUNTY BRD ED-TXBL 2.31% 5/1/2024 235,000 236,528 243,192 0.16% CHAFFEY COMMUNITY COLLEGE DT 1.72% 6/1/2024 480,000 477,168 495,283 0.32% RIVERSIDE CO PUB FIN 1.92% 7/1/2024 300,000 300,000 308,259 0.20% LOMPOC VALLEY MED-TXBL 2.07% 7/1/2024 110,000 110,869 113,486 0.07% SAN FRANCISCO CITY 3.76% 8/1/2024 250,000 270,675 270,985 0.17% TAMALPAIS UN HSD-TXBL 2.02% 8/1/2024 150,000 151,770 155,957 0.10% TENNESSEE-C-REF-TXBL 1.97% 8/1/2024 170,000 171,751 176,733 0.11% CONTRA COSTA CA COMNTY 1.77% 8/1/2024 250,000 250,000 258,629 0.17% MINNESOTA ST-C-TXBL 3.00% 8/1/2024 215,000 227,857 229,550 0.15% SOLANO COMMUNITY COLLEGE DT 2.16% 8/1/2024 300,000 300,000 312,779 0.20% SAN FRANCISCO REDEV-C 3.13% 8/1/2024 500,000 524,000 528,784 0.34% MT SAN ANTONIO CCD 1.94% 8/1/2024 400,000 404,080 415,436 0.27% MD ST -B ** 0.46% 8/1/2024 300,000 300,000 298,899 0.19% ORANGE COUNTY CA WATER DIST 1.94% 8/15/2024 200,000 200,080 206,648 0.13% W SACRAMENTO AREA 2.07% 9/1/2024 150,000 150,000 155,073 0.10% ESCONDIDO JT POWERS 2.19% 9/1/2024 380,000 383,192 394,294 0.25% CARMICHAEL WATER DIST 2.17% 11/1/2024 1,295,000 1,304,065 1,351,173 0.87% INDIO PUB FIN-B-TXBL 3.35% 11/1/2024 180,000 190,350 190,061 0.12% VENTURA COUNTY CA PUBLIC 1.22% 11/1/2024 100,000 100,000 100,845 0.06% SEMITROPIC IMP DIST-A 2.36% 12/1/2024 140,000 141,694 146,566 0.09% CON EDISON CO OF NY INC 3.30% 12/1/2024 310,000 330,646 331,523 0.21% SAN RAMON REDEV AGY 4.00% 2/1/2025 140,000 155,834 152,713 0.10% CALIFORNIA-TXBL 3.38% 4/1/2025 315,000 340,200 343,965 0.22% SAN DIEGO CNTY CA REG ** 2.09% 4/1/2025 350,000 350,000 366,020 0.24% MONTEREY PK TXBL 0.89% 6/1/2025 400,000 399,800 396,365 0.25% ANAHEIM PUBLIC FIN 0.94% 7/1/2025 250,000 249,400 247,738 0.16% UNIV CA-AX-TXBL 3.06% 7/1/2025 650,000 707,265 699,295 0.45% FOOTHILL DE ANZA-B 0.91% 8/1/2025 500,000 504,600 501,542 0.32% SANTA ROSA ELEM SD 1.01% 8/1/2025 500,000 500,000 499,235 0.32% W CONTRA COSTA SD -B 0.94% 8/1/2025 505,000 505,000 505,646 0.33% CASTRO VLY UN IF SCH 1.20% 8/1/2025 500,000 503,100 501,233 0.32% OAK GROVE SD -REF 0.87% 8/1/2025 240,000 240,000 238,233 0.15% BELMONT-REDWOOD-A- ** 0.88% 8/1/2025 205,000 205,000 204,424 0.13% BELMONT-REDWOOD-B-REF ** 0.88% 8/1/2025 200,000 200,000 199,513 0.13% SAN BERNARDINO CCD ** 0.84% 8/1/2025 275,000 275,000 274,722 0.18% RIO ESD CMNTY FACS DT 1.12% 9/1/2025 380,000 380,000 378,211 0.24% MACMWLTH -E-TXBL-REF 0.70% 11/1/2025 220,000 218,306 218,178 0.14% CALIFORNIA STUNIV-B** 0.86% 11/1/2025 100,000 100,000 99,520 0.06% BAY AREA CA TOLL AUTH 2.43% 4/1/2026 230,000 133,663 243,059 0.16% WISCONSIN ST GEN FUND 3.05% 5/1/2026 300,000 329,010 325,622 0.21% SAN FRANCISCO CA CITY ** 1.10% 6/15/2026 370,000 370,000 366,449 0.24% RED BLUFF-TXBL ** 1.46% 7/15/2026 350,000 350,000 354,078 0.23% SOCIETE GENERALE ** 1.35% 7/30/2026 500,000 500,000 500,000 0.32% BELMONT-REDWOOD-B-REF ** 1.10% 8/1/2026 205,000 205,000 204,160 0.13% SAN BERNARDINO CCD ** 1.10% 8/1/2026 230,000 230,000 229,681 0.15% Total Municipal Securities 24,325,000 24,218,026 24,940,501 16.03% CITY OF LODI SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED SEPTEMBER 30, 2021 TYPE OF INVESTMENT Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio . Supranational Securities Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio INTERAMER DEV ** 0.39% 4/16/2024 500,000 500,000 498,147 0.32% INTERAMER DEV 0.80% 6/17/2026 500,000 496,750 497,835 0.32% INT BK RECON&D 0.65% 2/24/2026 500,000 493,900 490,597 0.32% INTL FIN CORP 2.13% 4/7/2026 396,000 418,730 416,311 0.27% INTL BK RECON & DEVELOP ** 0.88% 7/15/2026 500,000 500,000 496,373 0.32% INTL FIN CORP ** 0.82% 9/15/2026 400,000 400,000 396,449 0.25%. Total Supranational Securities 2,796,000 2,809,380 2,795,712 1.80% INVESTMENTS SUBTOTAL NOT INCLUDING CASH & EQUIVALENTS 72,030,000 71,547,317 73,842,791 47.47% TOTAL ALL INVESTMENTS INCLUDING CASH & EQUIVALENTS * End of month bank balances are reflected on this report. ** Investments purchased during this reporting period. 153,269,618 15 5, 565, 092 100.00 CERTIFICATION I certify this report accurately reflects all city pooled investments and is in conformity with state law and the investment policy statement adopted by the City Council on June 2, 2021. The investment program herein shown provides sufficient cash liquidity to meet the next six months estimated expenditures, A copy of this report is available in the City Clerk's Office or online at http://www.lodi.gov/finance/revenue.html. oftx,CL� � Andrew Keys, Treasurer/Director of Finance Susan Bjork, Budget Manager November 4, 2021 Review Date 11/04/2021 Review Date IRS Section 115 Retirement Benefit Trust Funds Public Agency Retirement Services - Pension Stabilization Fund Balanced Strategy Mutual Fund Total Pension Stabilization Fund CalPERS - California Employer's Retiree Benefit Trust (CERBT) CERBT Strategy 2 Total CERBT Total Section 115 Retirement Benefit Trust Funds Restricted Cash Accounts PCE/TCE Central Plume Remediation Fund Farmers & Merchants Bank Money Market Total PCE/TCE Central Plume Account Total Restriction Cash Accounts Market Value $ 20,334,434 $ 20,334,434 $ 2,393,493 $ 2,393,493 $ 22,727,927 Market Value $ 887,638 $ 887,638 $ 887,638