The URL can be used to link to this page

Home My WebLink AboutAgenda Report - September 21, 2022 C-03CITY OF Vol o z CALIFORNIA AGENDA ITEM Con 43 COUNCIL COMMUNICATION AGENDA TITLE: Accept the Quarterly Investment Report as Required by the City of Lodi Investment Policy MEETING DATE: September 21, 2022 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 2021-164 on June 2, 2021 approving FY 21/22 Investment Policy. The attached Treasurer's Report for the quarter ending June 30, 2022 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.,qov/196/Finance . FISCAL IMPACT: FUNDING AVAILABLE Not applicable. As per attached report. Andrew Keys Deputy City Manager/Internal Services Director APPROVED: :- (Aug 24, 202212:44 PDT) Stephen Schwabauer, City Manager CITY OF LODI SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED JUNE 30, 2022 TYPE OF INVESTMENT Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio Cash and Equivalents FEDERAL NATIONAL MORTGAGE ASSOCIATION 2.00% 8/26/2022 250,000 242,725 250,142 Farmers & Merchants Bank Main * FEDERAL HOME LOAN Due on Demand 3.13% 3,977,761 3,977,761 2.19% Farmers & Merchants Bank Payroll * 0.14% Due on Demand 2.38% 94,705 94,705 0.05% Local Agency Investment Fund 0.14% Due on Demand 2.65% 59,426,241 59,426,241 32.72% Farmer's & Merchants Bank Money Market * 0.14% Due on Demand BANK SYSTEM 13,639,780 13,639,780 7.51% Wells Fargo Bank Money Market * 249,843 Due on Demand FEDERAL HOME LOAN 1,035,155 1,035,155 0.57% Total Demand Deposit Accounts 250,175 249,920 0.14% 78,173,643 78,173,643 43.04% Bond Mutual Fund Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio CAL TRUST Medium Term Fund 500,000 Due on Demand 485,526 10,154,702 10,154,702 5.59% Total Bond Mutual Funds 5/2/2024 350,000 349,825 10,154,702 10,154,702 5.59% Local Bank Certificates of Deposit Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio Farmers & Merchants Bank 0.20% 11/7/2023 2,000,000 2,000,000 2,000,000 1.10% Total Local Bank Certificates of Deposit FEDERAL HOME LOAN MORTGAGE CO ** 2,000,000 2,000,000 2,000,000 1.10% Negotiable Certificates of Deposit Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio CITI BANK 1.95% 8/23/2022 250,000 250,000 250,059 0.14% CAPITAL ONE BANK USA NA 2.40% 11/22/2022 250,000 250,000 250,418 0.14% CAPITAL ONE NA 2.40% 11/22/2022 250,000 250,000 250,418 0.14% WELLS FARGO BANK NA 2.40% 11/22/2022 250,000 250,000 250,415 0.14% GOLDMAN SACHS BANK USA 2.40% 11/22/2022 250,000 250,000 250,418 0.14% AMERICAN EXPRESS BANK FSB 2.50% 12/5/2022 250,000 246,700 250,520 0.14% SYNCHRONY BANK 2.60% 1/19/2023 250,000 250,000 250,583 0.14% SALLIE MAE BANK/SALT LAKE CITY, UTAH 2.65% 1/24/2023 250,000 250,000 250,642 0.14% STATE BANK OF INDIA 2.70% 2/16/2023 250,000 250,000 250,661 0.14% MEDALLION BANK UTAH 2.90% 4/10/2023 250,000 250,000 250,805 0.14% STIFEL BANK AND TRUST 2.95% 5/15/2023 250,000 250,000 250,656 0.14% CITIBANK NA 3.25% 6/6/2023 250,000 250,000 251,149 0.14% INDUSTRIAL & COM BK CHNA 3.30% 6/30/2023 250,000 250,000 251,074 0.14% COMENITY CAPITAL BANK 3.30% 7/16/2023 250,000 250,000 251,068 0.14% UBS BANK 3.35% 10/5/2023 250,000 250,000 251,144 0.14% BARCLAYS BANK/DELAWARE 3.35% 10/10/2023 250,000 250,000 251,127 0.14% BANK OF BARODA 3.55% 11/30/2023 250,000 250,000 251,734 0.14% MCHENRY SAVINGS BK IL 2.80% 3/14/2024 250,000 250,000 248,459 0.14% MORGAN STANLEY BANK 1.95% 11/29/2024 250,000 250,000 241,966 0.13% MORGAN STANLEY PRIVATE BANK 1.90% 11/29/2024 250,000 250,000 241,678 0.13% BMW BANK NORTH AMERICA 0.90% 12/10/2024 250,000 250,000 235,722 0.13% FIRST NATL BK OF AMERICA 1.25% 12/30/2026 250,000 250,000 227,596 0.13% TEXAS EXCHANGE BANK SSB 1.25% 12/30/2026 250,000 250,000 228,124 0.13% BANK HAPOALIM BM NY 1.50% 1/7/2027 250,000 250,000 230,251 0.13% AMERICAN EXPRESS NATIONAL BANK ** 3.40% 6/29/2027 250,000 250,000 249,432 0.14% Total Negotiable Certificates of Deposit 6,250,000 6,246,700 6,166,120 3.40% Agency Securities Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio FEDERAL NATIONAL MORTGAGE ASSOCIATION 2.00% 8/26/2022 250,000 242,725 250,142 0.14% FEDERAL HOME LOAN BANK 3.13% 9/9/2022 250,000 254,250 250,624 0.14% FEDERAL NATIONAL MORTGAGE ASSOCIATION 2.38% 1/19/2023 250,000 246,300 249,855 0.14% FEDERAL FARM CREDIT BANK SYSTEM 2.65% 3/8/2023 250,000 249,325 250,308 0.14% FEDERAL FARM CREDIT BANK SYSTEM 2.70% 4/11/2023 250,000 249,500 249,843 0.14% FEDERAL HOME LOAN BANK 2.85% 5/8/2023 250,000 250,175 249,920 0.14% FEDERAL AGRICULTURE MORTGAGE CORPORATION 2.90% 7/24/2023 250,000 249,150 249,775 0.14% FEDERAL FARM CREDIT BANK SYSTEM 0.90% 1/18/2024 500,000 499,250 485,526 0.27% FAMCA ** 2.65% 5/2/2024 350,000 349,825 347,729 0.19% FEDERAL NATIONAL MORTGAGE ASSOCIATION 1.63% 10/15/2024 500,000 508,800 484,980 0.27% FEDERAL HOME LOAN BANK 2.75% 12/13/2024 500,000 537,050 496,916 0.27% FEDERAL HOME LOAN MORTGAGE CO ** 3.00% 12/23/2024 400,000 399,800 398,197 0.22% FEDERAL HOME LOAN BANK 1.25% 1/28/2025 500,000 500,000 476,476 0.26% FEDERAL HOME LOAN MORTGAGE CO ** 3.15% 3/27/2025 400,000 400,000 398,757 0.22% FEDERAL HOME LOAN MORTGAGE CO 0.57% 9/24/2025 500,000 487,850 460,472 0.25% FREDDIE MAC 0.60% 10/27/2025 500,000 497,750 459,690 0.25% FAMCA 0.49% 12/18/2025 300,000 279,360 273,843 0.15% FEDERAL HOME LOAN BANK 0.90% 12/26/2025 500,000 499,900 465,080 0.26% FEDERAL HOME LOAN BANK 0.55% 1/20/2026 500,000 464,700 456,772 0.25% FEDERAL HOME LOAN BANK 0.85% 3/30/2026 400,000 399,840 370,400 0.20% FEDERAL HOME LOAN BANK 1.20% 4/28/2026 500,000 500,000 468,836 0.26% FEDERAL HOME LOAN BANK 1.00% 5/26/2026 500,000 500,000 464,809 0.26% FEDERAL HOME LOAN BANK 1.88% 9/11/2026 400,000 417,280 379,791 0.21% FAMCA 1.05% 10/5/2026 500,000 500,000 459,707 0.25% FEDERAL HOME LOAN MORTGAGE CO 0.80% 10/27/2026 500,000 489,350 452,710 0.25% FEDERAL HOME LOAN BANK 2.03% 2/25/2027 500,000 500,000 478,249 0.26% FEDERAL HOME LOAN BANK ** 3.50% 4/26/2027 500,000 500,000 497,800 0.27% FEDERAL HOME LOAN BANK ** 2.20% 4/27/2027 500,000 500,000 498,630 0.27% CITY OF LODI SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED JUNE 30, 2022 TYPE OF INVESTMENT Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio Agency Securities Cont'd 2.80% 7/13/2022 250,000 246,950 250,024 0.14% FEDERAL FARM CREDIT BANK SYSTEM ** 3.45% 6/1/2027 500,000 500,000 495,129 0.27% FIRST CAPITAL BK SC ** 3.50% 6/30/2027 250,000 250,000 250,561 0.14% Total Agency Securities 3.25% 9/23/2022 12,250,000 12,222,180 11,771,524 6.48% US Treasury Notes Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio UNITED STATES TREASURY 1.88% 7/31/2022 250,000 243,025 250,150 0.14% UNITED STATES TREASURY 1.63% 8/31/2022 250,000 240,325 250,020 0.14% UNITED STATES TREASURY 1.88% 9/30/2022 250,000 242,675 250,037 0.14% UNITED STATES TREASURY 2.00% 10/31/2022 250,000 243,750 249,890 0.14% UNITED STATES TREASURY 2.00% 11/30/2022 250,000 243,600 249,629 0.14% UNITED STATES TREASURY 2.13% 12/31/2022 250,000 244,700 249,512 0.14% UNITED STATES TREASURY 1.50% 2/28/2023 250,000 237,075 248,008 0.14% UNITED STATES TREASURY 1.50% 3/31/2023 250,000 236,800 247,578 0.14% UNITED STATES TREASURY 1.63% 4/30/2023 250,000 238,225 247,451 0.14% UNITED STATES TREASURY 1.63% 5/31/2023 250,000 236,525 247,119 0.14% UNITED STATES TREASURY 2.63% 6/30/2023 250,000 247,375 249,307 0.14% UNITED STATES TREASURY 1.25% 7/31/2023 250,000 231,625 245,596 0.14% UNITED STATES TREASURY 0.25% 6/15/2024 250,000 245,450 237,275 0.13% UNITED STATES TREASURY 0.38% 9/15/2024 250,000 245,350 236,172 0.13% UNITED STATES TREASURY 1.00% 12/15/2024 250,000 248,925 238,291 0.13% UNITED STATES TREASURY 0.50% 3/31/2025 250,000 244,475 233,564 0.13% UNITED STATES TREASURY 0.25% 6/30/2025 250,000 241,475 230,430 0.13% UNITED STATES TREASURY 0.25% 9/30/2025 250,000 240,475 228,662 0.13% UNITED STATES TREASURY 0.38% 11/30/2025 350,000 345,065 320,045 0.18% UNITED STATES TREASURY 0.38% 12/31/2025 250,000 240,575 228,115 0.13% UNITED STATES TREASURY 0.38% 1/31/2026 350,000 344,435 318,637 0.18% UNITED STATES TREASURY 0.75% 3/31/2026 750,000 741,675 689,736 0.38% UNITED STATES TREASURY 0.75% 5/31/2026 500,000 499,500 458,066 0.25% UNITED STATES TREASURY 0.88% 6/30/2026 250,000 244,025 229,814 0.13% UNITED STATES TREASURY 0.88% 9/30/2026 250,000 243,425 228,652 0.13% UNITED STATES TREASURY 1.25% 12/31/2026 250,000 247,500 231,416 0.13% Total US Treasury Notes 4.00% 4/1/2024 7,450,000 7,258,050 7,093,173 3.91% Corporate Securities Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio TOYOTA MOTOR CREDIT CORPORATION 2.80% 7/13/2022 250,000 246,950 250,024 0.14% PROCTER & GAMBLE COMPANY 2.15% 8/11/2022 250,000 243,150 250,032 0.14% MERCK & CO INC 2.40% 9/15/2022 100,000 98,700 100,029 0.06% 1PMORGAN CHASE & CO 3.25% 9/23/2022 100,000 101,380 100,154 0.06% GENERAL ELECTRIC CO 2.70% 10/9/2022 250,000 242,525 250,010 0.14% MICROSOFT CORP 2.65% 11/3/2022 250,000 247,575 250,209 0.14% AUSTRALIA & NEW ZEALAND BANKING GROUP NY 2.63% 11/9/2022 250,000 243,450 249,929 0.14% VISA INC 2.80% 12/14/2022 250,000 247,525 250,219 0.14% BANK OF NEW YORK MELLON CORP 2.95% 1/29/2023 100,000 100,070 99,900 0.06% WELLS FARGO NATIONAL BANK WEST 1.90% 1/30/2023 250,000 250,000 249,547 0.14% WELLS FARGO & COMPANY 3.45% 2/13/2023 150,000 152,145 150,151 0.08% UNITED HEALTH GROUP INC 2.75% 2/15/2023 100,000 99,140 99,660 0.05% EXXON MOBIL CORPORATION 2.73% 3/1/2023 250,000 247,050 249,983 0.14% WALMART INC 2.55% 4/11/2023 250,000 244,525 250,012 0.14% APPLE INC 2.40% 5/3/2023 250,000 240,875 248,826 0.14% SOUTHERN CALIFORNIA EDISON 3.40% 6/1/2023 254,000 252,857 252,734 0.14% NEW YORK UNIVERSITY 2.72% 7/1/2023 230,000 234,899 227,289 0.13% ORACLE CORP 3.63% 7/15/2023 250,000 253,425 249,272 0.14% IBM CORP 3.38% 8/1/2023 500,000 492,500 501,087 0.28% GILEAD SCIENCES INC 2.50% 9/1/2023 260,000 249,886 257,413 0.14% PROV ST JOSEPH HEALTH DEL 4.38% 10/1/2023 315,000 340,704 318,000 0.18% PRIES & FELLOWS OF HARVAR 2.60% 10/1/2023 300,000 306,750 298,233 0.16% TOYOTA MOTOR CREDIT CORP 2.25% 10/18/2023 250,000 235,225 246,822 0.14% NATIONAL RURAL UTIL COOP 3.40% 11/15/2023 300,000 297,900 299,772 0.17% ALABAMA POWER CO 3.55% 12/1/2023 250,000 249,875 251,263 0.14% TOYOTA MOTOR CREDIT CORP 3.35% 1/8/2024 400,000 399,280 400,661 0.22% JOHN DEERE CAPITAL CORP 3.45% 1/10/2024 250,000 250,450 250,933 0.14% BP CAP MARKETS AMERICA 3.79% 2/6/2024 500,000 529,500 502,370 0.28% 3M COMPANY 3.25% 2/14/2024 300,000 314,610 299,675 0.17% BOEING CO 2.80% 3/1/2024 250,000 248,500 245,074 0.13% DETROIT EDISON CO 3.65% 3/15/2024 300,000 318,180 302,024 0.17% BANK OF AMERICA CORP 4.00% 4/1/2024 250,000 261,725 252,180 0.14% HORMEL FOODS CORP 0.65% 6/3/2024 500,000 495,100 477,487 0.26% CATERILLAR FINANCIAL SERVICE 3.30% 6/9/2024 500,000 527,550 500,080 0.28% AMERICAN HONDA FINANCE 0.55% 7/12/2024 400,000 399,080 375,943 0.21% WALT DISNEY COMPANY 1.75% 8/30/2024 500,000 499,300 482,297 0.27% WELLS FARGO & COMPANY 3.30% 9/9/2024 750,000 788,725 740,619 0.41% AMERICAN HONDA FINANCE 2.15% 9/10/2024 500,000 499,550 483,943 0.27% CITY OF LODI SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED JUNE 30, 2022 TYPE OF INVESTMENT Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio Corporate Securities Cont'd 2.84% 7/1/2022 100,000 100,500 100,000 0.06% SHELL INTERNATIONAL FIN 2.00% 11/7/2024 500,000 497,650 485,858 0.27% CATERILLAR FINANCIAL SERVICE 3.25% 12/1/2024 500,000 528,700 497,572 0.27% TOYOTA MOTOR CREDIT CORP 1.80% 2/13/2025 300,000 299,940 286,251 0.16% WESTPAC BANKING CORP 2.35% 2/19/2025 500,000 514,250 482,776 0.27% FLORIDA POWER & LIGHT CO 2.85% 4/1/2025 500,000 499,400 491,307 0.27% AMAZON.COM INC 0.80% 6/3/2025 500,000 497,950 465,970 0.26% APPLE INC 0.55% 8/20/2025 500,000 492,150 458,161 0.25% JOHNSON&JOHNSON 0.55% 9/1/2025 950,000 944,185 876,291 0.48% NATIONAL RURAL UTIL COOP 1.00% 9/15/2025 500,000 499,250 460,732 0.25% TOYOTA MOTOR CREDIT CORP 0.80% 10/16/2025 500,000 493,650 455,254 0.25% TOYOTA MOTOR CREDIT CORP 0.80% 1/9/2026 500,000 498,800 452,058 0.25% APPLE INC 0.70% 2/8/2026 500,000 492,000 455,746 0.25% PUBLIC STORAGE 0.88% 2/15/2026 300,000 297,720 268,446 0.15% MERCK & CO INC 0.75% 2/24/2026 400,000 398,640 362,854 0.20% BMW US CAPITAL LLC 2.80% 4/11/2026 500,000 495,900 478,712 0.26% BMC, HARRIS BANK NA 1.00% 4/13/2026 250,000 250,000 229,135 0.13% AMAZON.COM INC 1.00% 5/12/2026 500,000 498,800 455,109 0.25% CHARLES SCHWAB CORP 1.15% 5/13/2026 500,000 499,500 451,607 0.25% BANK OF AMERICA CORP 1.25% 5/28/2026 500,000 500,000 435,027 0.24% BANK OF AMERICA CORP 1.20% 6/25/2026 500,000 499,300 433,828 0.24% MASS INSTITUTE OF TECH 3.31% 7/1/2026 500,000 532,750 491,011 0.27% TOYOTA FINANCIAL SGS BK 0.95% 7/29/2026 250,000 250,000 227,254 0.13% BANK OF AMERICA CORP 1.15% 9/10/2026 250,000 248,200 228,839 0.13% TEXAS INSTRUMENTS INC 1.13% 9/15/2026 400,000 392,400 363,781 0.20% JPMORGAN CHASE & CO 2.95% 10/1/2026 500,000 534,550 476,336 0.26% PROCTER & GAMBLE CO/THE 1.90% 2/1/2027 350,000 347,270 329,423 0.18% IBM CORP ** 2.20% 2/9/2027 500,000 475,200 463,526 0.26% PROGRESSIVE CORP 2.50% 3/15/2027 500,000 488,800 473,295 0.26% BEAL BANK - PLANO TX 2.00% 3/3/2027 250,000 250,000 234,793 0.13% NIKE INC 2.75% 3/27/2027 500,000 498,700 481,864 0.27% CHEVRON CORP ** 2.00% 5/11/2027 500,000 469,150 460,297 0.25% AMAZON.COM INC ** 1.20% 6/3/2027 500,000 450,650 446,238 0.25% Total Corporate Securities 5.87% 6/1/2024 26,059,000 26,086,086 24,923,205 13.72% Municipal Securities Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio ARKANSAS ST AMENDMENT 82 2.84% 7/1/2022 100,000 100,500 100,000 0.06% ADELANTO PUBLIC UTILITIES 3.50% 7/1/2022 240,000 246,936 240,000 0.13% ORANGE COUNTY CA WATER DIST 1.83% 8/15/2022 125,000 124,925 124,990 0.07% OCEANSIDE CA PENSION OBLIGATION 3.84% 8/15/2022 200,000 209,600 200,399 0.11% VISTA CA REDEVELOPMENT 3.00% 9/1/2022 120,000 120,960 120,145 0.07% SAN BERNARDINO COUNTY REDEVELOPMENT 3.25% 9/1/2022 160,000 161,840 160,254 0.09% SAN LEANDRO CA REDEVELOPMENT AGENCY 3.21% 9/1/2022 260,000 260,884 260,434 0.14% TX PUB FIN AUTH-A-REF 3.08% 10/1/2022 300,000 300,000 298,970 0.16% SAN FRANCISCO CITY & COUNTY CA 2.40% 11/1/2022 445,000 437,035 445,096 0.25% CALIFORNIA DEPARTMENT OF WATER RESOURCES 2.52% 12/1/2022 75,000 74,243 74,984 0.04% CARSON CA REDEVELOPMENT 3.00% 2/1/2023 80,000 81,000 79,980 0.04% CALIFORNIA HOUSING FINANCE AGENCY 2.88% 2/1/2023 450,000 443,775 448,835 0.25% GEORGIA ST GENERAL OBLIGATION 2.23% 2/1/2023 310,000 299,553 308,909 0.17% FRESNO FING-B REF 3.18% 4/1/2023 285,000 282,236 284,838 0.16% OHIO ST THIRD FRONTIER RESEARCH 2.11% 5/1/2023 250,000 240,275 248,075 0.14% RIVERSIDE CA PENSION OBLIGATION 2.63% 6/1/2023 250,000 243,900 248,619 0.14% SAN DIEGO TOBACCO SETTLEMENT 3.44% 6/1/2023 500,000 500,750 501,042 0.28% INDUSTRY-REF-TXBL 3.00% 7/1/2023 500,000 502,450 500,105 0.28% SOLANO COMMUNITY COLLEGE DT 2.06% 8/1/2023 145,000 145,000 143,301 0.08% CALIFORNIA VARIOUS PURPOSE 3.50% 8/1/2023 305,000 310,490 306,131 0.17% VISTA REDEV AGENCY-TXBL 3.00% 9/1/2023 290,000 300,643 288,514 0.16% CENTRAL CONTRA COSTA SANITATION DISTRICT 3.12% 9/1/2023 415,000 417,283 416,097 0.23% CALIFORNIA STATE MUNI TAX 2.25% 10/1/2023 250,000 239,750 247,526 0.14% TX PUB FIN AUTH-A-REF 5.08% 10/1/2023 300,000 300,000 291,227 0.16% NATIONAL SECS CLEARING 4.00% 12/7/2023 500,000 498,850 478,552 0.26% OAKLAND PENSION-TXBL 4.35% 12/15/2023 400,000 440,880 405,008 0.22% RIVERSIDE CA UNIFIED SCHOOL DIST 1.98% 2/1/2024 400,000 400,000 392,200 0.22% NATIONAL RURAL UTIL COOP 3.50% 2/8/2024 300,000 297,090 285,746 0.16% CALIFORNIA ST-TXBL-B 3.00% 4/1/2024 200,000 213,180 199,209 0.11% CORTE MADERA-TXBL-REF 2.75% 5/1/2024 150,000 150,300 148,138 0.08% TULARE COUNTY BRD ED-TXBL 2.31% 5/1/2024 235,000 236,528 230,845 0.13% UNIV OF CALIFORNIA -BF 0.83% 5/15/2024 120,000 120,216 114,515 0.06% CHAFFEY COMMUNITY COLLEGE DT 1.72% 6/1/2024 480,000 477,168 466,866 0.26% ORANGE-TXBL-REF 5.87% 6/1/2024 400,000 394,320 378,995 0.21% RIVERSIDE CO PUB FIN 1.92% 7/1/2024 300,000 300,000 289,430 0.16% LOMPOC VALLEY MED-TXBL 2.07% 7/1/2024 110,000 110,869 107,144 0.06% ANAHEIM PUBLIC FIN 0.63% 7/1/2024 250,000 245,500 236,918 0.13% CITY OF LODI SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED JUNE 30, 2022 TYPE OF INVESTMENT Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio Municipal Securities Cont'd SAN FRANCISCO CITY 3.76% 8/1/2024 250,000 270,675 252,594 0.14% TAMALPAIS UN HSD-TXBL 2.02% 8/1/2024 150,000 151,770 145,930 0.08% TENNESSEE-C-REF-TXBL 1.97% 8/1/2024 170,000 171,751 165,833 0.09% CONTRA COSTA CA COMNTY 1.77% 8/1/2024 250,000 250,000 240,056 0.13% MINNESOTA ST-C-TXBL 3.00% 8/1/2024 215,000 227,857 213,854 0.12% SOLANO COMMUNITY COLLEGE DT 2.16% 8/1/2024 300,000 300,000 292,365 0.16% SAN FRANCISCO REDEV-C 3.13% 8/1/2024 500,000 524,000 492,472 0.27% MT SAN ANTONIO CCD 1.94% 8/1/2024 400,000 404,080 388,115 0.21% MD ST -B 0.46% 8/1/2024 300,000 300,000 283,775 0.16% SANTA CLARA CO-B-TXBL ** 2.00% 8/1/2024 475,000 467,543 463,865 0.26% ORANGE COUNTY CA WATER DIST 1.94% 8/15/2024 200,000 200,080 194,395 0.11% W SACRAMENTO AREA 2.07% 9/1/2024 150,000 150,000 146,207 0.08% ESCONDIDO JT POWERS 2.19% 9/1/2024 380,000 383,192 371,036 0.20% HAWAII ST -GB 0.80% 10/1/2024 125,000 124,938 118,176 0.07% CARMICHAEL WATER DIST 2.17% 11/1/2024 1,295,000 1,304,065 1,263,685 0.70% INDIO PUB FIN-B-TXBL 3.35% 11/1/2024 180,000 190,350 177,554 0.10% VENTURA COUNTY CA PUBLIC 1.22% 11/1/2024 100,000 100,000 95,098 0.05% SEMITROPIC IMP DIST-A 2.36% 12/1/2024 140,000 141,694 136,770 0.08% CON EDISON CO OF NY INC 3.30% 12/1/2024 310,000 330,646 307,084 0.17% CARSON -TXBL-REV 1.88% 1/15/2025 505,000 516,817 483,659 0.27% SAN RAMON REDEV AGY 4.00% 2/1/2025 140,000 155,834 141,034 0.08% CALIFORNIA-TXBL 3.38% 4/1/2025 315,000 340,200 314,793 0.17% STANISLAUS CONSOL FIR 1.25% 4/1/2025 235,000 236,998 221,307 0.12% SAN DIEGO CNTY CA REG 2.09% 4/1/2025 350,000 366,485 338,061 0.19% YALE UNIVERSITY 0.87% 4/15/2025 1,075,000 1,068,318 1,010,271 0.56% MONTEREY PK TXBL 0.89% 6/1/2025 400,000 399,800 370,026 0.20% GOLDEN ST TOBACCO -B 1.40% 6/1/2025 300,000 300,000 279,261 0.15% LAKE PORT -R EV-TXBL 1.18% 6/1/2025 155,000 155,233 144,978 0.08% ANAHEIM PUBLIC FIN 0.94% 7/1/2025 250,000 249,400 232,042 0.13% UNIV CA-AX-TXBL 3.06% 7/1/2025 1,150,000 1,242,765 1,139,470 0.63% SAN RAMON-TXBL 1.20% 7/1/2025 500,000 497,250 461,091 0.25% FOOTHILL DE ANZA-B 0.91% 8/1/2025 500,000 504,600 464,122 0.26% SANTA ROSA ELEM SO 1.01% 8/1/2025 500,000 500,000 465,103 0.26% W CONTRA COSTA SD -B 0.94% 8/1/2025 505,000 505,000 467,833 0.26% CASTRO VLY UNIF SCH 1.20% 8/1/2025 500,000 503,100 467,820 0.26% OAK GROVE SD -REF 0.87% 8/1/2025 240,000 240,000 221,183 0.12% BELMONT-REDWOOD-A- 0.88% 8/1/2025 205,000 205,000 189,728 0.10% BELMONT-REDWOOD-B-REF 0.88% 8/1/2025 200,000 200,000 185,100 0.10% SAN BERNARDINO CCD 0.84% 8/1/2025 275,000 275,000 254,338 0.14% BELLFLOWER-TXBL 1.32% 8/1/2025 500,000 500,000 468,222 0.26% KLAMATH & TRINITY -13 1.83% 8/1/2025 250,000 250,000 237,119 0.13% SUTTER HEALTH 1.32% 8/15/2025 750,000 743,175 693,003 0.38% RIO ESD CMNTY FACS DT 1.12% 9/1/2025 380,000 380,000 348,782 0.19% MACMWLTH -E-TXBL-REF 0.70% 11/1/2025 220,000 218,306 201,716 0.11% CALIFORNIA STUNIV-B 0.86% 11/1/2025 100,000 100,000 91,558 0.05% STHRN KERN UNIF SD -B 1.08% 11/1/2025 370,000 370,000 340,510 0.19% VENTURA CNTY CA PUBLI 1.32% 11/1/2025 500,000 496,250 467,187 0.26% SACRAMENTO CNTY CA -B 1.04% 12/1/2025 485,000 471,275 448,381 0.25% BAY AREA CA TOLL AUTH 2.43% 4/1/2026 230,000 245,834 220,227 0.12% CALIFORNIA ST-TXBL-B 2.65% 4/1/2026 500,000 526,650 485,549 0.27% WISCONSIN ST GEN FUND 3.05% 5/1/2026 300,000 329,010 294,911 0.16% SAN FRANCISCO CA CITY 1.10% 6/15/2026 370,000 372,923 334,486 0.18% RED BLUFF-TXBL 1.46% 7/15/2026 350,000 356,965 315,563 0.17% SOCIETE GENERALE 1.35% 7/30/2026 500,000 500,000 500,000 0.28% BELMONT-REDWOOD-B-REF 1.10% 8/1/2026 205,000 205,000 186,022 0.10% SAN BERNARDINO CCD 1.10% 8/1/2026 230,000 230,000 209,052 0.12% BELLFLOWER-TXBL 1.60% 8/1/2026 465,000 463,512 430,849 0.24% KLAMATH & TRINITY -B 2.08% 8/1/2026 130,000 130,000 122,109 0.07% SAN FRANCISCO CO-TXBL 1.76% 9/1/2026 295,000 298,540 269,921 0.15% RIVERSIDE UNIF SD FIN 1.65% 9/1/2026 750,000 741,825 696,863 0.38% CALIFORNIA ST-TXBL 2.38% 10/1/2026 515,000 534,364 492,508 0.27% TEXAS ST-REF-TXBL 3.42% 10/1/2026 990,000 1,093,653 992,965 0.55% CA STUNIV-D 1.14% 11/1/2026 375,000 369,563 337,022 0.19% OREGON ST -H -REF 1.19% 11/1/2026 115,000 112,309 105,082 0.06% CA ST DEPT OF WTR RES 1.05% 12/1/2026 500,000 485,500 450,270 0.25% NEW YORK ST 2.36% 2/15/2027 800,000 809,900 759,358 0.42% RIVERSIDE CO-TXBL-REV 2.96% 2/15/2027 205,000 206,046 195,840 0.11% SAN JOSE -C -REF -REV 1.73% 3/1/2027 195,000 189,345 176,338 0.10% BAY AREA CA TOLL AUTH ** 1.43% 4/1/2027 520,000 478,088 468,585 0.26% SAN DIEGO CO REGL-A ** 1.40% 4/1/2027 425,000 388,365 384,358 0.21% PORT OF OAKLAND CA ** 1.67% 5/1/2027 250,000 227,350 225,764 0.12% Total Municipal Securities 37,160,000 37,507,112 35,622,239 19.61% TYPE CF INVESTMENT Supra F-atio 0 a I Secur t'e INTERAMER DEV INTERAMER DEV INTL FIN CORP INT 3K RECON&D INT 3K RECON&D INTERAMER DEV INTL FIN CORP INTERAMER DEV INTL BK RECON & DEVELOP INTL FIN CORP INTL FIN CORP INTERAMER DEV Total Supranational Securities INVESTMENTS SUBTOTAL NOT INCLUDING CASH & EQUIVALENTS TOTAL ALL INVESTMENTS INCLUDING CASH & EQUIVALENTS ' End cf month bank balances are reflected on this report. " Investments purchased during this reporting period. CITY OF LODI SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED JUNE 30, 2022 Date Par Value Cost Market Value % of Portfolio Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio 2.625 1/16/2024 300,000 309,510 298,167 0.16% 0.39% 4/16/2024 500,000 499,900 476,799 0.26% 0.60% 2/28/2025 500,000 496,250 473,848 0.26% 2.05% 3/17/2025 750,000 740,400 732,386 0.40% 0,65% 2/24/2026 500,000 493,900 457,850 0.25% 0.82% 2/27/2026 500,000 501,500 458,181 0.25% 2.13% 4/7/2026 396,000 418,730 381,752 0.21% 0.80% 6/17/2026 500,000 496,750 460,439 0.25% 0.88% 7/15/2026 500,000 500,900 457,916 0.25% 0.82% 9/15/2026 400,000 396,720 351,289 0.19% 0.75% 10/8/2026 250,000 246,000 225,945 0.12% 1.50% 1/13/2027 1,000,000 995,900 931,963 0.51% 6,096,000 6,096,460 5,706,536 3.14% 97,265,000 97,416,588 93,282,796 51.36% 185,744,933 181,611,141 100.00% CERTIF CATION 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 -ity Council on June 2, 2021. The investment program herein shown provides sufficient cash liquidity to meet the next six months estima-ed expenditures. A copy of this report is available in the City Clerk's Office or online at http://www.lodi.gov/finance/revenue,htmi. Qxw�hj , 0 Andrew Keys, TreasurerlDi rector of Finance Susan Bjork, Budget Manager Aug 24, 2022 Review Date Aug 24, 2022 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,037,023 $ 20,037,023 $ 2,094,744 $ 2,094,744 $ 22,131,767 Market Value $ 492,663 $ 492,663 $ 492,663