Loading...
HomeMy WebLinkAboutAgenda Report - March 6, 2019 C-04TM CITY OF LODI COUNCIL COMMUNICATION AGENDA ITEM C-4 AGENDA TITLE: Accept Quarterly Investment Report as Required by the City of Lodi Investment Policy MEETING DATE: March 6, 2019 PREPARED BY: Deputy City Manager RECOMMENDED ACTION: Accept 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 report in accordance with Section 53646. The attached Treasurer's Report for the quarter ending December 31, 2018, 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/Archive.aspx?AMID=42 FISCAL IMPACT: Not applicable. FUNDING AVAILABLE: As per attached report. VV►�d�I�r.,r Andrew Keys Treasurer APPROVED: Stephen Sc auer, 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 BBVA Compass Total Local Bank Certificates of Deposit CITY OF LODI SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED DECEMBER 31, 2018 Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio Negotiable Certificates of Deposit MORGAN STANLEY BANK NA MORGAN STANLEY PRIVATE BANK WEX BANK INTEREST BEARING PACIFIC CITY BANK INTEREST MARQUIS BANK INTEREST BEARING BRIDGEWATER BANK BLOOMINGTON MINNESOTA BELMONTSAVINGS BANK INTEREST TIAA FSB INTEREST BEARING ALLY BANK INTEREST BANKING BERKSHIRE BANK PITTSFIELD NEBRASKALAND NATIONAL BANK MB FINANCIAL BANK NA MERRICK BANK DISCOVER BANK THIRD FEDERAL SAVINGS & LOAN CLEVELAND BMW BANK NORTH AMERICA ENERBANK USA BMO HARRIS BANK NATIONAL ASSN HORIZON BANK NATION ASSN CAPITAL ONE BANK USA NA CAPITAL ONE NA GOLDMAN SACHS BANK USA WELLS FARGO BANK NA JP MORGAN CHASE BANK NA AMERICAN EXPRESS BANK FSB SYNCHRONY BANK SALLIE MAE BANK/SALT LAKE CITY, UTAH STATE BANK OF INDIA BANK UNITED NA MEDALLION BANK UTAH STIFEL BANK AND TRUST CITIBANK NA INDUSTRIAL & COM BK CHNA COMENITY CAPITAL BANK ANCHOR D BANK UBS BANK ** BARCLAYS BANK/DELAWARE ** HSBC BANK ** BANK OF BARODA ** COMMUNITY FINLSVCS BANK ** Total Negotiable Certificates of Deposit Agency Securities FEDERAL HOME LOAN BANK FEDERAL FARM CREDIT BANK SYSTEM FEDERAL HOME LOAN BANK Due on Demand 3,779,132 Due on Demand 24,364 Due on Demand 15,638,966 Due on Demand 9,170,962 Due on Demand 60,043 3,779,132 24,364 15,638,966 9,170,962 60,043 28,673,467 28,673,467 3.60% 0.02% 14.90% 8.74% 0.06% 27.33% Interest Rate Maturity. Date Par Value Cost Market Value % of Portfolio Due on Demand 9,801,066 9,801,065 9.34% 9,801,066 9,801,066 9.34% Interest Rate Maturity Date Par Value Cost 1.00% 11/7/2019 2,020,278 2,020,278 2.50% 3/13/2021 249,995 249,995 2,270,273 2,270,273 Market Value 2,020,278 249,995 2,270,273 % of Portfolio 1.93% 0.24% 2.16% Interest Rate Maturity Date Par Value Cost 1.80% 11/22/2019 1.75% 11/22/2019 1.75% 11/22/2019 1.70% 11/25/2019 1.70% 11/29/2019 2.20% 8/17/2020 1.95% 11/23/2020 1.95% 11/23/2020 2.05% 11/24/2020 1.85% 11/24/2020 1.85% 11/27/2020 2.00% 11/17/2021 2.10% 11/17/2021 2.15% 11/22/2021 2.10% 11/24/2021 2.20% 11/29/2021 2.55% 1/18/2022 2.80% 4/13/2022 2.85% 5/4/2022 2.40% 11/22/2022 2.40% 11/22/2022 2.40% 11/22/2022 2.40% 11/22/2022 2.30% 11/30/2022 2.50% 12/5/2022 2.60% 1/19/2023 2.65% 1/24/2023 2.70% 2/16/2023 2.90% 3/29/2023 2.90% 4/10/2023 2.95% 5/15/2023 3.25% 6/6/2023 3.30% 6/30/2023 3.30% 7/16/2023 3.20% 9/21/2023 3.35% 10/5/2023 3.35% 10/10/2023 3.50% 10/31/2023 3.55% 11/30/2023 3.55% 12/14/2023 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 10,000,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 246,699 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 9,996,699 Market Value 248,067 247,957 247,957 247,810 247,766 247,074 245,049 245,076 245,523 244,607 244,542 241,810 242,497 242,835 242,473 243,115 245,127 246,310 246,509 240,733 240,733 240,733 238,692 239,736 239,322 241,960 242,388 242,673 244,265 244,212 244,438 247,375 247,755 247,675 246,285 247,797 247,777 249,362 249,752 249,751 9,795,515 % of Portfolio 0.24% 0.24% 0.24% 0.24% 0.24% 0.24% 0.23% 0.23% 0.23% 0.23% 0.23% 0.23% 0.23% 0.23% 0.23% 0.23% 0.23% 0.23% 0.23% 0.23% 0.23% 0.2396 0.23% 0.23% 0.23% 0.23% 0.23% 0.23% 0.23% 0.23% 0.23% 0.24% 0.24% 0.24% 0.23% 0.24% 0.24% 0.24% 0.24% 0.24% 9.34% Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio 1.38% 3/18/2019 500,000 496,996 498,867 0.48% 1.45% 6/3/2019 500,000 496,507 497,769 0.47% 0.88% 8/5/2019 500,000 491,629 494,884 0.47% CITY OF LODI SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED DECEMBER 31, 2018 TYPE OF INVESTMENT AK ncy Semdrit6ls Isontlnued] FEDERAL FARM CREDIT BANK SYSTEM FEDERAL FARM CREDIT BANK SYSTEM FEDERAL NATIONAL MORTGAGE ASSOCIATION TENNESSEE VALLEY AUTHORITY FEDERAL FARM CREDIT BANK SYSTEM FEDERAL FARM CREDIT BANK SYSTEM FEDERAL FARM CREDIT BANK SYSTEM FEDERAL FARM CREDIT BANK SYSTEM FEDERAL NATIONAL MORTGAGE ASSOCIATION FEDERAL NATIONAL MORTGAGE ASSOCIATION FEDERAL HOME LOAN BANK FEDERAL HOME LOAN MORTGAGE CORPORATION FEDERAL AGRICULTURE MORTGAGE CORPORATION FEDERAL HOME LOAN BANK FEDERAL NATIONAL MORTGAGE ASSOCIATION FEDERAL NATIONAL MORTGAGE ASSOCIATION FEDERAL HOME LOAN BANK FEDERAL HOME LOAN MORTGAGE CORPORATION STEP FEDERAL NATIONAL MORTGAGE ASSOCIATION FEDERAL NATIONAL MORTGAGE ASSOCIATION FEDERAL NATIONAL MORTGAGE ASSOCIATION FEDERAL NATIONAL MORTGAGE ASSOCIATION FEDERAL HOME LOAN BANK FEDERAL NATIONAL MORTGAGE ASSOCIATION FEDERAL HOME LOAN MORTGAGE CORPORATION FEDERAL HOME LOAN BANK FEDERAL HOME LOAN BANK FEDERAL HOME LOAN BANK FEDERAL FARM CREDIT BANK SYSTEM FEDERAL FARM CREDIT BANK SYSTEM FEDERAL NATIONAL MORTGAGE ASSOCIATION FEDERAL HOME LOAN BANK FEDERAL NATIONAL MORTGAGE ASSOCIATION FEDERAL HOME LOAN MORTGAGE CORPORATION FEDERAL NATIONAL MORTGAGE ASSOCIATION FEDERAL HOME LOAN MORTGAGE CORPORATION STEP FEDERAL HOME LOAN MORTGAGE CORPORATION FEDERAL FARM CREDIT BANK SYSTEM FEDERAL FARM CREDIT BANK SYSTEM FEDERAL HOME LOAN BANK FEDERAL HOME LOAN MORTGAGE CORPORATION FEDERAL AGRICULTURE MORTGAGE CORPORATION FEDERAL FARM CREDIT BANK SYSTEM FEDERAL HOME LOAN MORTGAGE CORPORATION FEDERAL HOME LOAN BANK ** FEDERAL HOME LOAN MORTGAGE CORPORATION ** Total Agency Securities LIS.Ireasury Notes UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY ** UNITED STATES TREASURY ** UNITED STATES TREASURY ** UNITED STATES TREASURY ** UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio 1.50% 12/30/2019 2.05% 1/30/2020 1.50% 2/28/2020 2.25% 3/15/2020 2.50% 4/27/2020 2.55% 5/15/2020 1.55% 7/27/2020 2.84% 9/17/2020 1.50% 10/22/2020 1.70% 11/13/2020 5.25% 12/11/2020 2.15% 1/26/2021 2.35% 2/22/2021 2.38% 3/12/2021 1.75% 4/9/2021 1.25% 5/6/2021 1.50% 6/30/2021 1.02% 7/27/2021 2.30% 7/30/2021 1.25% 8/17/2021 2.00% 9/28/2021 1.38% 10/7/2021 2.63% 12/10/2021 2.00% 1/5/2022 2.00% 2/28/2022 2.63% 3/11/2022 1.65% 4/19/2022 2.62% 5/27/2022 1.88% 6/1/2022 1.75% 7/5/2022 2.00% 8/26/2022 3.13% 9/9/2022 2.25% 10/27/2022 2.45% 12/29/2022 2.38% 1/19/2023 2.00% 1/30/2023 2.70% 2/23/2023 2.65% 3/8/2023 2.70% 4/11/2023 2.85% 5/8/2023 2.50% 6/28/2023 2.90% 7/24/2023 3.24% 8/14/2023 3.00% 9/26/2023 3.50% 11/21/2023 3.60% 11/28/2023 500,000 495,085 494,116 0.47% 250,000 247,902 248,760 0.24% 500,000 494,585 494,309 0.47% 250,000 248,441 249,151 0.24% 250,000 249,526 249,861 0.24% 250,000 249,734 250,036 0.24% 500,000 492,355 492,097 0.47% 250,000 251,200 250,975 0.24% 205,000 199,527 200,908 0.19% 250,000 244,468 245,417 0.23% 250,000 266,094 262,527 0.25% 500,000 498,625 496,105 0.47% 250,000 247,195 249,485 0.24% 250,000 247,737 248,983 0.24% 250,000 242,978 245,215 0.23% 250,000 240,040 242,757 0.23% 250,000 242,625 243,795 0.23% 250,000 246,750 247,231 0.24% 250,000 249,125 248,347 0.24% 250,000 238,514 242,094 0.23% 250,000 244,105 246,703 0.24% 250,000 238,923 242,484 0.23% 250,000 248,755 250,678 0.24% 250,000 243,235 246,301 0.23% 230,000 221,548 226,041 0.22% 250,000 248,853 250,282 0.24% 500,000 481,125 484,908 0.46% 250,000 249,465 250,200 0.24% 250,000 242,059 243,673 0.23% 250,000 238,208 242,396 0.23% 250,000 242,734 245,019 0.23% 250,000 254,254 254,064 0.24% 250,000 246,063 246,518 0.23% 500,000 494,125 496,653 0.47% 250,000 246,300 248,129 0.24% 250,000 249,375 249,719 0.24% 250,000 248,000 249,403 0.24% 250,000 249,325 249,577 0.24% 250,000 249,500 249,811 0.24% 250,000 250,174 251,905 0.24% 250,000 249,750 250,104 0.24% 250,000 249,160 252,696 0.24% 250,000 250,000 250,445 0.24% 250,000 250,000 250,202 0.24% 350,000 360,000 351,260 0.33% 250,000 250,000 250,180 0.24% 14,535,000 14,372,667 14,423,032 13.75% Interest Rate Maturity Date Par Value Cost 0.75% 2/15/2019 500,000 1.63% 4/30/2019 500,000 1.25% 5/31/2019 500,000 1.38% 7/31/2019 500,000 1.75% 9/30/2019 500,000 1.38% 4/30/2020 500,000 1.63% 6/30/2020 500,000 2.63% 7/31/2020 250,000 2.63% 8/31/2020 250,000 2.63% 11/15/2020 250,000 2.38% 12/31/2020 250,000 1.38% 1/31/2021 250,000 1.13% 2/28/2021 250,000 1.25% 3/31/2021 250,000 2 Market Value % of Portfolio 494,071 499,030 0.48% 497,934 498,594 0.48% 495,276 497,441 0.47% 495,315 496,582 0.47% 497,480 496,797 0.47% 491,523 492,305 0.47% 493,607 493,242 0.47% 249,029 250,303 0.24% 248,942 250,332 0.24% 248,868 250,459 0.24% 247,420 249,443 0.24% 241,844 244,268 0.23% 239,815 242,783 0.23% 240,368 243,359 0.23% TYPE OF INVESTMENT US Treasury Notes (continued) UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY UNITED STATES TREASURY Total US Treasury Notes CITY OF LODI SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED DECEMBER 31, 2018 Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio Corporate Securities TOYOTA MOTOR CREDIT CORPORATION PEPSICO INC GENERAL ELECTRIC CO MERCK & COMPANY INC CHEVRON CORP NEVADA POWER COMPANY IBM CORP CITIBANK NA ** CISCO SYSTEMS INC TARGET CORPORATION AUTOMATIC DATA PROCESSING BANK OF AMERICA CORP COCA-COLA COMPANY WELLS FARGO & COMPANY WELLS FARGO BANK NA MICROSOFT CORP CISCO SYSTEMS INC EXXON MOBIL CORPORATION BERKSHIRE HATHAWAY INC PNC BANK NA COSTCO WHOLESALE CORP ALPHABET INC TOTAL CAPITAL INTERNATIONAL SA AMERICAN HONDA FINANCE WELLS FARGO BANK NA ** APPLE INC MIZUHO FINANCIAL CORPORATION BOEING COMPANY PFIZER INC TOYOTA MOTOR CREDIT CORP PACIFICORP JOHNSON & JOHNSON TD AMERITRADE HOLDING COMPANY ORACLE CORP UNITED PARCEL SERVICE 1.38% 4/30/2021 250,000 240,904 243,828 0.23% 1.38% 5/31/2021 250,000 240,547 243,574 0.23% 1.13% 6/30/2021 250,000 238,335 241,963 0.23% 1.13% 7/31/2021 250,000 237,921 241,553 0.23% 2.00% 8/31/2021 250,000 244,513 246,895 0.24% 1.13% 9/30/2021 250,000 237,186 241,123 0.23% 2.00% 10/31/2021 250,000 244,134 246,787 0.24% 2.00% 12/31/2021 400,000 394,512 394,531 0.38% 1.50% 1/31/2022 250,000 240,139 242,861 0.23% 1.88% 2/28/2022 250,000 243,370 245,459 0.23% 1.88% 3/31/2022 250,000 243,143 245,313 0.23% 1.75% 5/31/2022 250,000 242,223 244,063 0.23% 1.75% 6/30/2022 250,000 242,065 243,945 0.23% 1.88% 7/31/2022 250,000 243,028 244,814 0.23% 1.63% 8/31/2022 250,000 240,313 242,500 0.23% 1.88% 9/30/2022 250,000 242,668 244,561 0.23% 2.00% 10/31/2022 250,000 243,745 245,566 0.23% 2.00% 11/30/2022 250,000 243,603 245,449 0.23% 2.13% 12/31/2022 250,000 244,688 246,475 0.23% 1.50% 2/28/2023 250,000 237,063 240,186 0.23% 1.50% 3/31/2023 250,000 236,790 239,980 0.23% 1.63% 4/30/2023 250,000 238,225 241,064 0.23% 1.63% 5/31/2023 250,000 236,525 240,850 0.23% 2.63% 6/30/2023 250,000 247,329 251,299 0.24% 1.25% 7/31/2023 250,000 231,621 236,436 0.23% 11,650,000 11,356,077 11,446,013 10.91%. Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio 2.10% 1/17/2019 500,000 501,165 499,763 0.48% 1.35% 10/4/2019 500,000 494,006 494,023 0.47% 2.20% 1/9/2020 500,000 499,181 492,719 0.47% 1.85% 2/10/2020 300,000 296,400 297,314 0.28% 1.96% 3/3/2020 500,000 498,091 494,980 0.47% 2.75% 4/15/2020 250,000 249,765 249,434 0.24% 1.63% 5/15/2020 500,000 494,010 490,124 0.47% 2.10% 6/12/2020 750,000 737,700 737,585 0.70% 2.45% 6/15/2020 250,000 248,618 248,673 0.24% 3.88% 7/15/2020 250,000 256,310 253,753 0.24% 2.25% 9/15/2020 300,000 297,516 298,356 0.28% 2.63% 10/19/2020 500,000 503,172 494,759 0.47% 2.45% 11/1/2020 250,000 248,290 248,411 0.24% 2.55% 12/7/2020 200,000 199,591 197,182 0.19% 2.60% 1/15/2021 250,000 246,540 246,895 0.24% 4.00% 2/8/2021 100,000 104,600 102,760 0.10% 2.20% 2/28/2021 150,000 147,659 148,012 0.14% 2.22% 3/1/2021 150,000 147,915 147,840 0.14% 2.20% 3/15/2021 100,000 99,297 98,688 0.09% 2.15% 4/29/2021 500,000 495,965 488,035 0.47% 2.15% 5/18/2021 100,000 99,008 98,337 0.09% 3.63% 5/19/2021 100,000 104,000 102,010 0.10% 2.75% 6/19/2021 250,000 248,075 248,180 0.24% 1.65% 7/12/2021 250,000 239,433 240,844 0.23% 3.33% 7/23/2021 750,000 748,343 749,269 0.71% 1.55% 8/4/2021 500,000 485,396 484,797 0.46% 2.27% 9/13/2021 250,000 240,903 242,061 0.23% 2.35% 10/30/2021 250,000 245,363 246,177 0.23% 2.20% 12/15/2021 200,000 198,284 196,611 0.19% 2.60% 1/11/2022 250,000 246,665 246,021 0.23% 2.95% 2/1/2022 250,000 249,816 247,352 0.24% 2.25% 3/3/2022 250,000 245,167 243,867 0.23% 2.95% 4/1/2022 250,000 247,243 247,318 0.24% 2.50% 5/15/2022 100,000 99,204 97,853 0.09% 2.35% 5/16/2022 100,000 98,749 97,566 0.09% 3 TYPE OF INVESTMENT Corporate Securities (continued) DEERE & COMPANY 3M COMPANY TOYOTA MOTOR CREDIT CORPORATION PROCTER & GAMBLE COMPANY MERCK & CO INC JPMORGAN CHASE & CO GENERAL ELECTRIC CO MICROSOFT CORP AUSTRALIA & NEW ZEALAND BANKING GROUP NY VISA INC JPMORGAN CHASE & CO BANK OF NEW YORK MELLON CORP WELLS FARGO & COMPANY UNITED HEALTH GROUP INC EXXON MOBIL CORPORATION WALMART INC APPLE INC SOUTHERN CALIFORNIA EDISON CHEVRON CORPORATION ORACLE CORP IBM CORP ** SHELL INTERNATIONAL FIN GILEAD SCIENCES INC TOYOTA MOTOR CREDIT CORP ** COCA-COLA CO ** NATIONAL RURAL UTIL COOP ** ALABAMA POWER CO ** Total Corporate Securities CITY OF LODI SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED DECEMBER 31, 2018 Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio Municipal Securitjee OREGON ST DEPT OF ADMINISTRATIVE SERVICES CALIFORNIA STATE TAXABLE -VARIOUS UNIVERSITY OF CALIFORNIA CA REVENUES UTAH ST BUILD AMERICA SANTA MONICA CA COMMUNITY COLLEGE DISTRICT CAMPBELL CA UNION HIGH SCHOOL DISTRICT LOS ANGELES CA MUNICIPAL IMPT CORPL SAN RAMON CA REDEVELOPMENT AGENCY CONNECTICUT GENERAL OBLIGATION POMONA CA REVENUE WATER FACILITIES PROJECT ALAMEDA COUNTY CA JOINT POWERS AUTHORITY LANCASTER CA REDEVELOPMENT AGENCY CONNECTICUT ST GENERAL OBLIGATION OAKLEY CA REDEVELOPMENT AGENCY SCOTTS VALLEY CA REDEVELOPMENT AGENCY SANTA FE SPRINGS CA COMMUNITY DEVELOPMENT PALM DESERT CA REDEVELOPMENT AGENCY TEXAS ST PUBLIC FINANCE AUTHORITY CALIFORNIA STATE HIGH SPEED RAIL UNIVERSITY OF CALIFORNIA UNIVERSITY OF CALIFORNIA CA REVENUES BURBANK-GLENDALE-PASADENA AIPORT AUTHORITY LA MIRADA CA REDEVELOPMENT YUBA LEVEE FINANCING AUTHORITY SAN DIEGO CA REDEVELOPMENT AGENCY ROSEVILLE FINANCE AUTHORITY - ELECTRIC SYSTEM STATE OF MARYLAND CALIFORNIA EDUCATIONAL FACILITIES AUTHORITY CALIFORNIA STATE DEPT OF WATER RESOURCES TULARE COUNTY CA PENSION OBLIGATION ADELANTO PUBLIC UTILITIES ARKANSAS ST AMENDMENT 82 OCEANSIDE CA PENSION OBLIGATION 2.60% 6/8/2022 100,000 99,153 97,871 0.09% 2.00% 6/26/2022 150,000 144,485 144,996 0.14% 2.80% 7/13/2022 250,000 246,950 246,704 0.24% 2.15% 8/11/2022 250,000 243,146 242,835 0.23% 2.40% 9/15/2022 100,000 98,701 97,738 0.09% 3.25% 9/23/2022 100,000 101,377 99,206 0.09% 2.70% 10/9/2022 250,000 242,535 231,982 0.22% 2.65% 11/3/2022 250,000 247,580 247,931 0.24% 2.63% 11/9/2022 250,000 243,450 242,779 0.23% 2.80% 12/14/2022 250,000 247,518 246,864 0.24% 2.97% 1/15/2023 150,000 147,503 146,247 0.14% 2.95% 1/29/2023 100,000 100,069 98,426 0.09% 3.45% 2/13/2023 150,000 152,147 146,853 0.14% 2.75% 2/15/2023 100,000 99,143 97,849 0.09% 2.73% 3/1/2023 250,000 247,040 245,846 0.23% 2.55% 4/11/2023 250,000 244,525 243,733 0.23% 2.40% 5/3/2023 250,000 240,887 241,733 0.23% 3.40% 6/1/2023 254,000 252,849 252,543 0.24% 3.19% 6/24/2023 250,000 249,295 249,608 0.24% 3.63% 7/15/2023 250,000 253,415 253,384 0.24% 3.38% 8/1/2023 500,000 492,500 494,539 0.47% 3.40% 8/12/2023 250,000 252,275 252,107 0.24% 2.50% 9/1/2023 260,000 249,886 250,820 0.24% 2.25% 10/18/2023 250,000 235,228 236,709 0.23% 3.20% 11/1/2023 238,000 235,651 238,740 0.23% 3.40% 11/15/2023 300,000 297,885 303,122 0.29% 3.55% 12/1/2023 250,000 249,873 252,459 0.24% Interest Rate 1.60% 2.25% 1.80% 3.19% 1.63% 1.50% 2.34% 2.75% 2.29% 2.01% 2.60% 2.39% 2.50% 2.85% 2.25% 1.63% 2.25% 3.53% 2.63% 3.24% 1.79% 4.13% 2.91% 2.86% 2.25% 2.41% 2.65% 2.46% 2.00% 3.20% 3.50% 2.84% 3.84% 16,652,000 16, 476, 501 16,421,194 15.65% Maturity Date Par Value Cost 4/1/2019 5/1/2019 7/1/2019 7/1/2019 8/1/2019 8/1/2019 11/1/2019 2/1/2020 3/15/2020 5/1/2020 6/1/2020 8/1/2020 8/1/2020 9/1/2020 9/1/2020 9/1/2020 10/1/2020 10/1/2020 4/1/2021 5/15/2021 5/15/2021 7/1/2021 8/15/2021 9/1/2021 9/1/2021 2/1/2022 3/15/2022 4/1/2022 5/1/2022 6/1/2022 7/1/2022 7/1/2022 8/15/2022 4 250,000 245,000 100,000 100,000 230,000 155,000 260,000 105,000 500,000 150,000 550,000 235,000 265,000 145,000 150,000 235,000 250,000 350,000 500,000 150,000 250,000 90,000 250,000 250,000 250,000 250,000 300,000 250,000 300,000 250,000 240,000 100,000 200,000 Market Value % of Portfolio 248,723 249,385 0.24% 245,348 244,581 0.23% 99,503 99,556 0.09% 100,917 100,284 0.10% 228,316 228,569 0.22% 153,402 153,769 0.15% 259,093 258,838 0.25% 104,941 104,723 0.10% 493,235 493,560 0.47% 148,584 148,068 0.14% 550,506 547,278 0.52% 236,203 232,551 0.22% 262,448 262,080 0.25% 147,120 144,537 0.14% 150,111 148,220 0.14% 228,133 229,290 0.22% 247,823 247,448 0.24% 358,351 355,576 0.34% 501,060 497,670 0.47% 152,684 152,001 0.14% 244,733 244,913 0.23% 94,323 92,034 0.09% 253,195 249,300 0.24% 252,980 249,958 0.24% 246,163 247,025 0.24% 246,915 247,295 0.24% 300,480 297,534 0.28% 246,270 244,835 0.23% 291,678 291,378 0.28% 250,245 252,048 0.24% 246,936 244,474 0.23% 100,499 100,299 0.10% 209,604 206,838 0.20% TYPE OF INVESTMENT lylunicioal Securities (continued) SAN BERNARDINO COUNTY REDEVELOPMENT VISTA CA REDEVELOPMENT SAN LEANDRO CA REDEVELOPMENT AGENCY SAN FRANCISCO CITY & COUNTY CA CALIFORNIA DEPARTMENT OF WATER RESOURCES CALIFORNIA HOUSING FINANCE AGENCY *** CARSON CA REDEVELOPMENT GEORGIA ST GENERAL OBLIGATION FRESNO FING-B REF ** OHIO ST THIRD FRONTIER RESEARCH RIVERSIDE CA PENSION OBLIGATION SAN DIEGO TOBACCO SETTLEMENT CALIFORNIA VARIOUS PURPOSE RANCHO WATER ** CENTRAL CONTRA COSTA SANITATION DISTRICT CALIFORNIA STATE MUNI TAX ** Total Municipal Securities INVESTMENTS SUBTOTAL NOT INCLUDING CASH & EQUIVALENTS TOTAL ALL INVESTMENTS INCLUDING CASH & EQUIVALENTS CITY OF LODI SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED DECEMBER 31, 2018 Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio * End of month bank balances are reflected on this report. ** Investments purchased during this reporting period. *** Additional investment of $243,770 purchased 12/4/18 3.25% 9/1/2022 160,000 161,840 159,570 0.15% 3.00% 9/1/2022 120,000 120,960 121,254 0.12% 3.21% 9/1/2022 260,000 260,887 263,700 0.25% 2.40% 11/1/2022 445,000 437,052 436,336 0.42% 2.52% 12/1/2022 275,000 272,212 74,516 0.07% 2.88% 2/1/2023 200,000 443,770 444,740 0.42% 3.00% 2/1/2023 80,000 81,000 79,161 0.08% 2.23% 2/1/2023 310,000 299,559 303,744 0.29% 3.18% 4/1/2023 285,000 282,230 282,529 0.27% 2.11% 5/1/2023 250,000 240,273 242,093 0.23% 2.63% 6/1/2023 250,000 243,888 245,900 0.23% 3.44% 6/1/2023 500,000 500,745 501,010 0.48% 3.50% 8/1/2023 305,000 310,481 310,316 0.30% 2.10% 8/1/2023 110,000 104,150 106,123 0.10% 3.12% 9/1/2023 415,000 417,283 421,814 0.40% 2.25% 10/1/2023 250,000 239,738 243,338 0.23% 12,120,000 12,316,585 12,102,053 11.53% 67,227,273 66,788,804 66,458,079 63.33% 105, 263, 337 104,932,612 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 adopter by the City Council on March 7, 2018. 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. Andres, Tr/Dir r of Finance .Fe 6A,„( asp X01 Review Date 5 L,CCGin usan Bjork, Budget Manag Review Date IRS Section 115 Retirement Benefit Trust Funds Market Value Public Agency Retirement Services - Pension Stabilization Fund Balanced Strategy Mutual Fund $ 10,685,927 Total Pension Stabilization Fund $ 10,685,927 CarPERS - California Employer's Retiree Benefit Trust ICERBT) CERBT Strategy 2 $ Total CERBT $ Total Section 115 Retirement Benefit Trust Funds 1,089,953 1,089,953 $ 11,775,880 Restricted Cash Accounts Market Value PCE/TCE Central Plume Remediation Fund Farmers & Merchants Bank Money Market $ Total PCE/TCE Central Plume Account $ 2,187,478 2,187,478 Total Restriction Cash Accounts $ 2,187,478