The URL can be used to link to this page

2021 10 06 FAC Special MeetingSPECIAL MEETING Page 1 of 1 OCTOBER 6, 2021 FINANCIAL ADVISORY COMMISSION AGENDA NOTICE SPECIAL MEETING OF THE LA QUINTA FINANCIAL ADVISORY COMMISSION TO THE MEMBERS OF THE LA QUINTA FINANCIAL ADVISORY COMMISSION AND TO THE COMMISSION SECRETARY: NOTICE IS HEREBY GIVEN that a Special Meeting of the La Quinta Financial Advisory Commission is hereby called to be held on Wednesday, October 6, 2021, starting at 4:00 p.m.; at La Quinta City Hall located at 78495 Calle Tampico, La Quinta, CA 92253 for the following purpose: CONSENT CALENDAR 1. Receive and File the Fourth Quarter Fiscal Year 2020/21 Treasury Reports for April, May, and June 2021 BUSINESS SESSION 1. Appoint two Financial Advisory Commissioners to Audit and Formulate the Annual Measure G Compliance Report for Fiscal Year 2020/21 DEPARTMENTAL REPORTS 1. Finance Department Current and Future Initiatives Dated: October 4, 2021 /s/ George Batavick George Batavick, Chairperson Attest: Jessica Delgado, Management Assistant DECLARATION OF POSTING I, Jessica Delgado, Management Assistant, do hereby declare that the foregoing notice for the La Quinta Financial Advisory Commission Special Meeting of October 6, 2021, was posted on the outside entry to the Council Chamber at 78495 Calle Tampico, and on the bulletin boards at 51321 Avenida Bermudas and 78630 Highway 111 on October 4, 2021. Dated: October 4, 2021 Jessica Delgado, Management Assistant SPECIAL MEETING Page 1 of 4 OCTOBER 6, 2021 FINANCIAL ADVISORY COMMISSION AGENDA SPECIAL MEETING FINANCIAL ADVISORY COMMISSION AGENDA CITY HALL COUNCIL CHAMBERS 78495 Calle Tampico, La Quinta WEDNESDAY, OCTOBER 6, 2021 AT 4:00 P.M. ****************************** SPECIAL NOTICE Teleconferencing and Telephonic Accessibility in Effect Pursuant to Executive Orders N-60-20 and N-08-21 executed by the Governor of California, and subsequently Assembly Bill 361 (AB 361, 2021), enacted in response to the state of emergency relating to novel coronavirus disease 2019 (COVID-19) and enabling teleconferencing accommodations by suspending or waiving specified provisions in the Ralph M. Brown Act (Government Code § 54950 et seq.), members of the public, the Financial Advisory Commission, the City Manager, City Attorney, City Staff, and City Consultants may participate in this special meeting by teleconference. Members of the public wanting to listen to this meeting may do so by tuning- in live via https://laquinta.12milesout.com/video/live . Written public comments – can be provided in-person during the meeting or emailed to the Commission Secretary at JDelgado@LaQuintaCA.gov preferably by 12:00 p.m. on the day of the meeting, and will be distributed to the Commission, incorporated into the agenda packet and public record of the meeting, and will not be read during the meeting unless, upon the request of the Chair, a brief summary of any public comment is asked to be read, to the extent staff can accommodate such request. Financial Advisory Commission agendas and staff reports are now available on the City’s web page: www.laquintaca.gov SPECIAL MEETING Page 2 of 4 OCTOBER 6, 2021 FINANCIAL ADVISORY COMMISSION AGENDA If emailed, the email “subject line” must clearly state “Written Comments” and list the following: 1) Full Name 4) Public Comment or Agenda Item Number 2) City of Residence 5) Subject 3) Phone Number 6) Written Comments *** TELECONFERENCE PROCEDURES *** Verbal public comments via Teleconference – members of the public may attend and participate in the meeting by teleconference via Zoom and use the “raise your hand” feature when public comments are prompted by the Chair; the City will facilitate the ability for a member of the public to be audible to the Commission and general public and allow him/her/they to speak on the item(s) requested. Please note – members of the public must unmute themselves when prompted upon being recognized by the Chair, in order to become audible to the Commission and the public. Only one person at a time may speak by teleconference and only after being recognized by the Chair. ZOOM LINK: https://us06web.zoom.us/j/89839984651 Meeting ID: 898 3998 4651 Or join by phone: (253) 215 – 8782 It would be appreciated that any email communications for public comments related to the items on the agenda, or for general public comment, are provided to the Commission Secretary at the email address listed above prior to the commencement of the meeting. If that is not possible, and to accommodate public comments on items that may be added to the agenda after its initial posting or items that are on the agenda, every effort will be made to attempt to review emails received by the Commission Secretary during the course of the meeting. The Financial Advisory Commission’s Chair will endeavor to take a brief pause before action is taken on any agenda item to allow the Commission Secretary to review emails and share any public comments received during the meeting. All emails received by the Commission Secretary, at the email address above, until the adjournment of the meeting, will be included within the public record relating to the meeting. ****************************** SPECIAL MEETING Page 3 of 4 OCTOBER 6, 2021 FINANCIAL ADVISORY COMMISSION AGENDA CALL TO ORDER Roll Call: Commissioners: Anderson, Campbell, Dorsey, Mills, Way, and Chairperson Batavick PLEDGE OF ALLEGIANCE PUBLIC COMMENT At this time members of the public may address the Financial Advisory Commission on any matter not listed on the agenda by providing written public comments either in-person or via email as indicated above; or provide verbal public comments either in-person or via teleconference by joining the meeting virtually at https://us06web.zoom.us/j/89839984651 and use the “raise your hand” feature when prompted by the Chair. Members of the public attending the meeting in-person are requested to complete a “Request to Speak” form and submit it to the Commission Secretary. Please limit your comments to three minutes (approximately 350 words). The Commission values your comments; however, in accordance with State law, no action shall be taken on any item not appearing on the agenda unless it is an emergency item authorized by the Brown Act [Government Code Section 54954.2(b)]. CONFIRMATION OF AGENDA ANNOUNCEMENTS, PRESENTATIONS AND WRITTEN COMMUNICATIONS – None CONSENT CALENDAR NOTE: Consent Calendar items are routine in nature and can be approved by one motion. 1. Receive and File the Fourth Quarter Fiscal Year 2020/21 Treasury Reports for April, May, and June 2021 STUDY SESSION – None BUSINESS SESSION 1. Appoint two Financial Advisory Commissioners to Audit and Formulate the Annual Measure G Compliance Report for Fiscal Year 2020/21 DEPARTMENTAL REPORTS 1. Finance Department Current and Future Initiatives COMMISSIONERS’ ITEMS SPECIAL MEETING Page 4 of 4 OCTOBER 6, 2021 FINANCIAL ADVISORY COMMISSION AGENDA ADJOURNMENT The next regular quarterly meeting of the La Quinta Financial Advisory Commission will be held on November 10, 2021, commencing at 4:00 p.m. at the La Quinta City Hall Council Chambers, 78495 Calle Tampico, La Quinta, CA 92253. DECLARATION OF POSTING I, Jessica Delgado, Management Assistant/Commission Secretary, of the City of La Quinta, do hereby declare that the foregoing Agenda for the Commission meeting was posted on the City’s website, near the entrance to the Council Chamber at 78495 Calle Tampico, and the bulletin boards at 78-630 Highway 111, and 51321 Avenida Bermudas, on October 4, 2021. DATED: October 4, 2021 Jessica Delgado, Management Assistant/Commission Secretary City of La Quinta, California Public Notices The La Quinta City Hall Council Chambers is handicapped accessible. If special equipment is needed for the hearing impaired, please contact the Commission Secretary at (760) 777-7150, twenty-four (24) hours in advance of the meeting and accommodations will be made. If special electronic equipment is needed to make presentations to the Commission, arrangements should be made in advance by contacting the Commission Secretary at (760) 777-7150. A one (1) week notice is required. If background material is to be presented to the Commission during a Commission meeting, please be advised that eight (8) copies of all documents, exhibits, etc., must be supplied to the Commission Secretary for distribution. It is requested that this takes place prior to the beginning of the meeting. Any Writings or documents provided to a majority of the Commission regarding any item(s) on the agenda will be made available for public inspection at the Concierge desk at City Hall located at 78495 Calle Tampico, La Quinta, California, 92253, during normal business hours. City of La Quinta FINANCIAL ADVISORY COMMISSION MEETING: September 21, 2021 STAFF REPORT AGENDA TITLE: RECEIVE AND FILE FOURTH QUARTER FISCAL YEAR 2020/21 TREASURY REPORTS FOR APRIL, MAY, AND JUNE 2021 RECOMMENDATION Receive and file the fourth quarter fiscal year 2020/21 Treasury Reports for April, May, and June 2021. BACKGROUND/ANALYSIS Commentary and Summary of Significant Activity The total book value of the portfolio increased $28.6 million, from $158.3 million at the end of March to $186.9 million at the end of June. An increase of $13.5 million was due to the Redevelopment Property Tax Trust Fund (RPTTF) pass-through apportionment payment which funds debt service obligations that are paid in August. The remainder of the increase reflects operational activity throughout the quarter. The portfolio is within policy limits for investment types and total allocation by type (see chart below), and is also within policy guidelines for investment ratings. Investment Type April May June Max Allowed Bank Accounts 8.20%9.03%8.38%100% Local Agency Investment Fund (LAIF) City 34.27%35.20%35.81%(1) Local Agency Investment Fund (LAIF) Housing 6.54%6.32%5.66%(1)(2) Money Market Pool Accounts-CAMP 0.53%0.51%7.41%20% Federal Agency Coupons 12.98%12.54%11.76%100% Treasury Coupons 7.65%7.69%5.28%100% Certificates of Deposit (CD's)19.93%19.12%16.99%30% Corporate Notes 1.76%1.70%1.52%30% Money Market with Fiscal Agent 0.00%0.00%0.00%(2) CERBT- OPEB Trust 1.20%1.16%1.10%(3) PARS Pension Trust 6.94%6.74%6.09%(3) Total 100% 100% 100% (3) OPEB and pension trusts are fiduciary accounts and not subject to City Investment Policy (2) Funds held by fiscal agent and the LAIF Housing funds are governed by bond indentures and not subject to City Investment Policy Portfolio Allocations CONSENT CALENDAR ITEM NO. 1 The markets continue to react to the political climate, economic news, and ongoing concerns around the worldwide Coronavirus pandemic; staff continually works to stay abreast of market conditions. The fiscal year annual effective rate of return is 0.95% as of June, a 6 basis point (bps) decrease since March (Q3) and an 87 bps decrease since June 2020. Throughout the quarter, four CDs and two treasuries matured, one agency bond was called, and one agency bond, six treasuries, and four CDs were purchased. Maturities and purchases are listed in detail in the attached reports. Year-End Summary In 2020, when the effects of the pandemic became obvious, the Fed reacted by lowering the target federal funds rate, to a range of 0.00 to 0.25%, where it is projected to remain for the foreseeable future. This rate has an impact on funds held in pooled money market accounts such as the California Asset Management Program (CAMP) and the Local Agency Investment Fund (LAIF), and as a result yields have dropped significantly. For example, the LAIF monthly effective yield, which was 1.787% in March 2020, decreased to 0.540% by December 2020 and was down to 0.262% by June 2021. The City maintains a large balance in LAIF for liquidity purposes and therefore the overall rate of return for our portfolio will continue to be impacted by these very low yields. Staff will continue to invest in allowable asset classes in an effort to offset the low pooled money account rates with higher rates typically seen with longer maturity terms, with the understanding that we are generally constrained by current law to a 5-year time horizon. The below chart summarizes the portfolio’s average daily balance, total earnings, and effective rate of return for the each of the past five years: Total Earnings Average Days to Maturity Effective Rate of Return YTD April 108,610$ 394 0.99% May 115,809$ 378 0.98% June 109,113$ 356 0.95% Quarter 4 333,533$ 376 0.97% 2016-17 2017-18 2018-19 2019-20 2020-21 Average Daily Balance $125,445,981 $131,713,765 $141,628,303 $152,994,488 $160,732,266 Total Earnings $963,022 $1,730,509 $2,894,323 $2,798,779 $1,533,546 Effective Rate of Return 0.77%1.31%2.04%1.82%0.95% Other Notes Money market funds with the fiscal agent are bond proceeds subject to bond indentures, not the City’s investment policy. Successor Agency (SA) funds cannot be invested long-term; therefore, SA funds are only invested in LAIF. Looking Ahead The Treasurer follows a “buy and hold” Investment Policy unless it is fiscally advantageous to actively trade outside of maturity dates. In the short term, the Treasurer will invest in CAMP and LAIF as needed. Longer term investments may include Government Sponsored Enterprise (agencies) securities, U.S. Treasuries, Corporate Notes, and Negotiable Certificates of Deposits. All investments recognize both immediate and long-term cash flow needs, and there is sufficient liquidity in the portfolio to meet expenditure requirements for the next six months. ALTERNATIVES - None Prepared by: Rosemary Hallick, Financial Services Analyst Approved by: Claudia Martinez, Interim Finance Director/City Treasurer Attachment: 1. Treasurer’s Report for April 1, 2021 to June 30, 2021 ATTACHMENT 1ATTACHMENT 1 Days to Maturity Page 1 Par Value Book Value Maturity Date Stated RateMarket Value April 30, 2021 Portfolio Details - Investments Average BalanceIssuer Portfolio Management City of La Quinta YTM 365TermCUSIPInvestment # Purchase Date Bank Accounts 1Bank of New York1293 3,254,568.53 3,254,568.5309/01/2020 3,254,568.53 1SYS1293 0.000 1Bank of the West1228 9,456,806.96 9,456,806.9608/20/2019 9,456,806.96 1059731851 0.000 1City Petty Cash1059 3,300.00 3,300.0007/01/2016 3,300.00 1SYS1059 0.000 1Dune Palms Mobile Estates1318 217,583.21 217,583.2103/09/2021 217,583.21 1SYS1318 0.000 1La Quinta Palms Realty1062 334,384.44 334,384.4407/01/2016 334,384.44 1SYS1062 0.000 1Stifel, Nicolaus & Company1183 0.00 0.0003/18/2019 0.00 1SYS1183 0.000 13,266,643.14 113,266,643.1413,266,643.148,336,870.04Subtotal and Average 1 0.000 Local Agency Investment Fund-City 1Local Agency Inv Fund1055 55,429,948.66 55,429,948.66 0.33955,766,295.86 198-33-434 0.339 55,429,948.66 155,766,295.8655,429,948.6655,932,381.59Subtotal and Average 1 0.339 Local Agency Invstmnt Fund-Housing 1Local Agency Inv Fund1113 10,580,686.54 10,580,686.54 0.33910,662,970.55 125-33-005 0.339 10,580,686.54 110,662,970.5510,580,686.5410,575,298.67Subtotal and Average 1 0.339 Money Market/Mutual Funds 1Dreyfus12940.00 0.0009/24/2020 0.00 1X9USDDTP3 0.000 0.00 00.000.000.00Subtotal and Average 0 0.000 Money Market Accounts - CAMP 1California Asset Management Pr1153 854,097.00 854,097.00 0.06009/26/2018 854,097.00 1SYS1153 0.060 854,097.00 1854,097.00854,097.00854,059.58Subtotal and Average 1 0.060 Federal Agency Coupon Securities 123Federal Farm Credit Bank1105 1,000,000.00 992,200.00 09/01/20211.70011/09/2017 1,005,530.00 1,3923133EHWM1 1.913 857Federal Farm Credit Bank1158 250,000.00 247,275.00 09/05/20232.80010/15/2018 264,945.00 1,7863133EJYL7 3.041 590Federal Farm Credit Bank1198 500,000.00 499,500.00 12/12/20221.87506/20/2019 513,900.00 1,2713133EKQP4 1.905 1,182Federal Farm Credit Bank1212 500,000.00 499,500.00 07/26/20241.85008/02/2019 523,120.00 1,8203133EKWV4 1.871 835Federal Farm Credit Bank1223 500,000.00 499,400.00 08/14/20231.60009/12/2019 515,675.00 1,4323133EKZK5 1.632 1,235Federal Farm Credit Bank1224 500,000.00 498,750.00 09/17/20241.60009/17/2019 518,850.00 1,8273133EKP75 1.652 914Federal Farm Credit Bank1234 1,000,000.00 996,900.00 11/01/20231.60011/01/2019 1,032,970.00 1,4613133EK4X1 1.680 1,235Federal Farm Credit Bank1242 1,000,000.00 998,600.00 09/17/20241.70012/17/2019 1,042,280.00 1,7363133ELEA8 1.731 1,019Federal Farm Credit Bank1246 1,000,000.00 999,000.00 02/14/20241.43002/14/2020 1,030,360.00 1,4613133ELNE0 1.456 516Federal Farm Credit Bank1247 1,000,000.00 999,217.36 09/29/20221.40002/05/2020 1,017,750.00 9673133EGWJ0 1.430 Portfolio CITY CP Run Date: 09/10/2021 - 10:04 PM (PRF_PM2) 7.3.0 Report Ver. 7.3.6.1 Days to Maturity Page 2 Par Value Book Value Maturity Date Stated RateMarket Value April 30, 2021 Portfolio Details - Investments Average BalanceIssuer Portfolio Management City of La Quinta YTM 365TermCUSIPInvestment # Purchase Date Federal Agency Coupon Securities 1,500Federal Farm Credit Bank1280 500,000.00 499,850.00 06/09/20250.50006/09/2020 496,355.00 1,8263133ELH23 0.506 1,501Federal Farm Credit Bank1282 500,000.00 500,000.00 06/10/20250.68006/10/2020 501,650.00 1,8263133ELH80 0.680 1,018Federal Home Loan Bank1177 500,000.00 498,550.00 02/13/20242.50003/01/2019 531,370.00 1,8103130AFW94 2.563 1,504Federal Home Loan Bank1281 500,000.00 499,850.00 06/13/20250.50006/03/2020 496,355.00 1,8363130AJKW8 0.506 1,521Federal Home Loan Bank1283 300,000.00 300,000.00 06/30/20250.68006/30/2020 296,829.00 1,8263130AJRP6 0.680 1,686Federal Home Loan Bank1298 500,000.00 497,400.00 12/12/20250.37512/07/2020 490,770.00 1,8313130AKFA9 0.480 1,719Federal Home Loan Bank1302 500,000.00 500,000.00 01/14/20260.51001/14/2021 491,400.00 1,8263130AKMZ6 0.510 1,734Federal Home Loan Bank1304 500,000.00 500,000.00 01/29/20260.55001/29/2021 493,110.00 1,8263130AKN28 0.550 1,794Federal Home Loan Bank1312 500,000.00 500,000.00 03/30/20260.50003/30/2021 499,395.00 1,8263130ALV92 0.938 1,487Federal Home Loan Mtg Corp1279 1,000,000.00 1,000,000.00 05/27/20250.62505/27/2020 997,380.00 1,8263134GVYG7 0.625 1,542Federal Home Loan Mtg Corp1297 1,000,000.00 997,300.00 07/21/20250.37512/07/2020 986,700.00 1,6873137EAEU9 0.434 1,704Federal Home Loan Mtg Corp1301 500,000.00 500,000.00 12/30/20250.55012/30/2020 493,407.00 1,8263134GXGZ1 0.550 1,606Federal Home Loan Mtg Corp1307 500,000.00 495,999.50 09/23/20250.37502/23/2021 492,045.00 1,6733137EAEX3 0.552 1,606Federal Home Loan Mtg Corp1310 1,000,000.00 983,940.00 09/23/20250.37503/30/2021 984,090.00 1,6383137EAEX3 0.740 1,158Federal National Mtg Assn1206 500,000.00 495,950.00 07/02/20241.75007/15/2019 521,980.00 1,8143135G0V75 1.922 493Federal National Mtg Assn1233 1,000,000.00 992,100.00 09/06/20221.37510/29/2019 1,016,760.00 1,0433135G0W33 1.659 1,566Federal National Mtg Assn1288 500,000.00 500,000.00 08/14/20250.50008/14/2020 495,465.00 1,8263135G05S8 0.500 1,573Federal National Mtg Assn1289 1,000,000.00 1,000,000.00 08/21/20250.56008/21/2020 991,790.00 1,8263136G4N74 0.560 1,570Federal National Mtg Assn1290 500,000.00 499,750.00 08/18/20250.52008/28/2020 495,180.00 1,8163136G4M75 0.530 1,297Federal National Mtg Assn1291 500,000.00 499,250.00 11/18/20240.42011/18/2020 497,235.00 1,4613135G06E8 0.458 1,661Federal National Mtg Assn1292 500,000.00 499,250.00 11/17/20250.56011/17/2020 493,750.00 1,8263135GA2Z3 0.590 1,697Federal National Mtg Assn1299 500,000.00 500,000.00 12/23/20250.60012/23/2020 493,980.00 1,8263135GA7D7 0.600 1,339Federal National Mtg Assn1300 500,000.00 500,000.00 12/30/20240.40012/30/2020 498,380.00 1,4613135GAAW1 0.400 20,989,531.86 1,62821,220,756.0021,050,000.0021,655,198.53Subtotal and Average 1,242 1.099 Treasury Coupon Securities 60U.S. Treasury1045 5,000,000.00 5,000,000.00 06/30/20211.12507/18/2016 5,008,600.00 1,808912828S27 1.125 183U.S. Treasury1070 2,000,000.00 1,942,800.00 10/31/20211.25003/27/2017 2,011,880.00 1,679912828T67 1.903 517U.S. Treasury1178 500,000.00 489,687.50 09/30/20221.87503/01/2019 512,405.00 1,3099128282W9 2.480 379U.S. Treasury1192 500,000.00 496,650.00 05/15/20221.75005/31/2019 508,635.00 1,080912828SV3 1.984 30U.S. Treasury1193 500,000.00 493,610.00 05/31/20211.37505/31/2019 500,515.00 731912828R77 2.030 882U.S. Treasury1217 500,000.00 499,300.00 09/30/20231.37508/21/2019 513,730.00 1,501912828T26 1.410 1,309U.S. Treasury1241 1,000,000.00 989,687.50 11/30/20241.50012/16/2019 1,035,510.00 1,811912828YV6 1.718 1,705U.S. Treasury1303 500,000.00 498,632.81 12/31/20250.37501/07/2021 490,565.00 1,81991282CBC4 0.431 1,736U.S. Treasury1309 500,000.00 495,100.00 01/31/20260.37502/23/2021 489,885.00 1,80391282CBH3 0.577 1,644U.S. Treasury1311 1,000,000.00 977,500.00 10/31/20250.25003/30/2021 978,240.00 1,67691282CAT8 0.750 Portfolio CITY CP Run Date: 09/10/2021 - 10:04 PM (PRF_PM2) 7.3.0 Days to Maturity Page 3 Par Value Book Value Maturity Date Stated RateMarket Value April 30, 2021 Portfolio Details - Investments Average BalanceIssuer Portfolio Management City of La Quinta YTM 365TermCUSIPInvestment # Purchase Date Treasury Coupon Securities 1,674U.S. Treasury1315 500,000.00 492,187.50 11/30/20250.37504/22/2021 491,210.00 1,68391282CAZ4 0.720 12,375,155.31 1,66912,541,175.0012,500,000.0012,030,624.06Subtotal and Average 565 1.335 Certificate of Deposits 1,217First State Bk DeQueen1222 248,000.00 248,000.00 08/30/20241.80008/30/2019 258,287.09 1,827336460CX6 1.802 1,459First Freedom Bank1273 249,000.00 249,000.00 04/29/20251.20004/29/2020 253,916.39 1,82632027BAL1 1.201 1,210FirsTier Bank1216 249,000.00 249,000.00 08/23/20241.95008/23/2019 260,692.49 1,82733766LAJ7 1.952 1,4721st Internet Bank1278 248,000.00 248,000.00 05/12/20251.00005/11/2020 250,738.62 1,82732056GDJ6 0.985 1,458First Natl Bk McGregor1274 248,000.00 248,000.00 04/28/20251.35004/28/2020 254,379.16 1,82632112UDR9 1.351 810First National Bank of America1147 245,000.00 245,000.00 07/20/20233.15007/20/2018 260,595.44 1,82632110YLK9 3.152 734First National Bank1179 248,000.00 248,000.00 05/05/20232.80003/05/2019 260,716.50 1,52232117BCX4 2.802 1,217First Natl Bk of Syracuse1221 249,000.00 249,000.00 08/30/20241.85008/30/2019 259,745.72 1,827334342CD2 1.852 1,385First National Bank Michigan1250 248,000.00 248,000.00 02/14/20251.65002/14/2020 257,282.79 1,82732114VBT3 1.652 1,186First Security Bank of WA1209 248,000.00 248,000.00 07/30/20242.00007/30/2019 259,821.95 1,82733625CCP2 2.002 1,110First Service Bank1231 248,000.00 248,000.00 05/15/20241.70011/15/2019 257,266.63 1,64333640VDD7 1.701 200First Source Bank1168 245,000.00 245,000.00 11/17/20213.15012/17/2018 249,044.76 1,06633646CKP8 3.153 275Third Federal Savings and Loan1112 245,000.00 245,000.00 01/31/20222.50001/30/2018 249,238.04 1,46288413QBY3 2.502 1,182Abacus Federal Savings1207 248,000.00 248,000.00 07/26/20241.95007/26/2019 259,544.06 1,82700257TBD7 1.952 1,412Access Bank1256 248,000.00 248,000.00 03/13/20251.60003/13/2020 256,785.40 1,82600435JBH5 1.601 408Allegiance Bank1143 245,000.00 245,000.00 06/13/20223.10006/13/2018 252,827.99 1,46101748DBE5 3.102 530Alliance Credit Union1095 245,000.00 245,000.00 10/13/20222.25010/13/2017 252,095.51 1,82601859BAA3 2.251 1,427Alma Bank1267 248,000.00 248,000.00 03/28/20251.40003/30/2020 254,937.00 1,824020080BX4 1.399 423America's Credit Union1200 248,000.00 248,000.00 06/28/20222.30006/28/2019 253,886.83 1,09603065AAL7 2.302 1,392American State1255 248,000.00 248,000.00 02/21/20251.60002/21/2020 256,855.52 1,827029728BC5 1.602 485American Express Fed Savings B1096 240,000.00 240,000.00 08/29/20222.40008/29/2017 246,847.17 1,82602587CFU9 2.402 786American First CU1285 248,000.00 248,000.00 06/26/20230.35006/26/2020 248,280.97 1,09502616AAH2 0.350 809American National Bank1205 248,000.00 248,000.00 07/19/20232.00007/19/2019 257,373.47 1,46102772JBD1 2.001 690Aneca Federal Credit Union1119 245,000.00 245,000.00 03/22/20232.80003/22/2018 256,805.21 1,826034577AH9 2.802 1,425Axos Bank1258 248,000.00 248,000.00 03/26/20251.65003/26/2020 257,349.59 1,82605465DAE8 1.651 542Barclays Bank1097 240,000.00 240,000.00 10/25/20222.30010/25/2017 247,288.07 1,82606740KLJ4 2.291 972Bar Harbor Bank and Trust1172 248,000.00 248,000.00 12/29/20233.35012/31/2018 267,684.53 1,824066851WJ1 3.352 1,081Belmont Bank and Trust1270 248,000.00 248,000.00 04/16/20241.25004/16/2020 253,824.35 1,46108016PDQ9 1.251 333Bellco Credit Union1264 248,000.00 248,000.00 03/30/20221.30003/31/2020 250,387.47 72907833EAD9 1.300 205Belmont Savings Bank1102 245,000.00 245,000.00 11/22/20212.10011/21/2017 247,676.03 1,462080515CD9 2.101 1,339Bank Princeton1287 248,000.00 248,000.00 12/30/20240.50006/30/2020 246,686.88 1,644064520BG3 0.500 299BMW Bank1067 240,000.00 240,000.00 02/24/20222.20002/24/2017 243,953.79 1,82605580AGK4 2.201 Portfolio CITY CP Run Date: 09/10/2021 - 10:04 PM (PRF_PM2) 7.3.0 Days to Maturity Page 4 Par Value Book Value Maturity Date Stated RateMarket Value April 30, 2021 Portfolio Details - Investments Average BalanceIssuer Portfolio Management City of La Quinta YTM 365TermCUSIPInvestment # Purchase Date Certificate of Deposits 1,245BankWest Inc1227 248,000.00 248,000.00 09/27/20241.70009/27/2019 257,671.41 1,82706652CHB0 1.702 334Cadence Bank, NA1259 245,000.00 245,000.00 03/31/20221.20003/31/2020 247,090.79 73012738RFX7 1.200 37Capital One Natl Assn FDIC42971082 240,000.00 240,000.00 06/07/20212.25006/07/2017 240,541.82 1,46114042RGD7 2.252 1,438Capital One USA FDIC339541271 245,000.00 245,000.00 04/08/20251.60004/08/2020 253,616.98 1,82614042TDD6 1.601 1,822Carter FCU1316 248,000.00 248,000.00 04/27/20260.75004/27/2021 245,743.90 1,82614622LAA0 0.750 1,217Celtic Bank1220 248,000.00 248,000.00 08/30/20241.85008/30/2019 258,702.56 1,82715118RRH2 1.852 1,124Century Next Bank1184 248,000.00 248,000.00 05/29/20242.50005/29/2019 263,535.04 1,827156634AK3 2.503 1,515Chippewa Valley Bk1284 248,000.00 248,000.00 06/24/20250.60006/24/2020 246,509.64 1,826169894AS1 0.600 1,398Citadel FCU1252 248,000.00 248,000.00 02/27/20251.65002/27/2020 257,368.76 1,82717286TAG0 1.652 479CIT Bank NA1219 245,000.00 245,000.00 08/23/20221.90008/23/2019 250,274.66 1,09612556LBA3 1.902 710Citibank NA1123 245,000.00 245,000.00 04/11/20232.90004/11/2018 257,628.35 1,82617312QJ26 2.902 1,430Commonwealth Business Bk1268 248,000.00 248,000.00 03/31/20251.25003/31/2020 253,090.23 1,8262027506M2 1.251 74Central State Bank1085 240,000.00 240,000.00 07/14/20211.85007/14/2017 240,864.84 1,46115523RBJ4 1.851 928Commercial Bank1162 248,000.00 248,000.00 11/15/20233.40011/15/2018 267,223.14 1,82620143PDV9 3.402 1,154Communitywide FCU1202 248,000.00 248,000.00 06/28/20242.25006/28/2019 261,810.17 1,82720416TAQ5 2.253 727Congressional Bank1189 248,000.00 248,000.00 04/28/20232.50004/30/2019 259,095.65 1,45920726ABA5 2.502 566CrossFirst Bank1106 245,000.00 245,000.00 11/18/20222.20011/20/2017 252,387.69 1,82422766ACB9 2.201 1,147Citizens State Bank1199 248,000.00 248,000.00 06/21/20242.40006/21/2019 262,903.73 1,827176688CP2 2.403 276Discover Bank Greenwood DE CF1066 240,000.00 240,000.00 02/01/20222.25002/01/2017 243,743.06 1,8262546722U1 2.251 727EnerBank USA1125 240,000.00 240,000.00 04/28/20232.95004/30/2018 252,915.28 1,82429278TAY6 2.952 576Enterprise Bank, NA1107 245,000.00 245,000.00 11/28/20222.15011/28/2017 252,321.83 1,82629367QCP1 2.151 1,138Evansville Teachers Credit FCU1196 248,000.00 248,000.00 06/12/20242.60006/12/2019 264,344.42 1,827299547AQ2 2.603 1,748TIAA FKA EverBank1306 245,000.00 245,000.00 02/12/20260.50002/12/2021 240,385.36 1,82687270LDL4 0.500 363Farmers Insurance Group FCU1126 240,000.00 240,000.00 04/29/20222.80004/30/2018 246,152.50 1,46030960QAG2 2.802 1,825Fidelity Homestead1317 248,000.00 248,000.00 04/30/20260.70004/30/2021 244,894.40 1,82631617CAV5 0.711 1,460Flagstar1276248,000.00 248,000.00 04/30/20251.25004/30/2020 253,187.54 1,82633847E3A3 1.251 1,385Freedom Financial1248 248,000.00 248,000.00 02/14/20251.55002/14/2020 256,340.38 1,82735637RDC8 1.552 107General Electric Credit Union1150 240,000.00 240,000.00 08/16/20213.10008/15/2018 242,123.38 1,097369674AV8 3.100 360Goldman Sachs1078 240,000.00 240,000.00 04/26/20222.40004/26/2017 245,137.69 1,82638148PJK4 2.401 1,811Greenstate FCU1313 249,000.00 249,000.00 04/16/20260.95004/16/2021 249,195.77 1,82639573LBC1 0.951 1,118Iowa State Bank1186 245,000.00 245,000.00 05/23/20242.40005/23/2019 259,495.07 1,82746256YAZ2 2.403 901Jefferson Financial CU1154 245,000.00 245,000.00 10/19/20233.35010/19/2018 263,229.57 1,826474067AQ8 3.352 1,111JP Morgan Chase1185 245,000.00 245,000.00 05/16/20243.25005/16/2019 265,795.34 1,82748128HXU7 3.254 381Kansas State Bank1101 245,000.00 245,000.00 05/17/20222.10011/17/2017 249,721.28 1,64250116CBE8 2.099 608Kern FCU1239 248,000.00 248,000.00 12/30/20221.90012/30/2019 254,775.32 1,09649228XAK6 1.902 607Knoxville TVA Credit Union1110 245,000.00 245,000.00 12/29/20222.40012/29/2017 253,746.14 1,826499724AB8 2.401 Portfolio CITY CP Run Date: 09/10/2021 - 10:04 PM (PRF_PM2) 7.3.0 Days to Maturity Page 5 Par Value Book Value Maturity Date Stated RateMarket Value April 30, 2021 Portfolio Details - Investments Average BalanceIssuer Portfolio Management City of La Quinta YTM 365TermCUSIPInvestment # Purchase Date Certificate of Deposits 1,145Legacy Bank1197 248,000.00 248,000.00 06/19/20242.40006/19/2019 262,877.97 1,827524661CB9 2.403 1,123Live Oak Bank1238 248,000.00 248,000.00 05/28/20241.80011/27/2019 258,142.65 1,644538036GV0 1.802 1,003Lakeside Bank1208 248,000.00 248,000.00 01/29/20242.00007/30/2019 258,904.50 1,64451210SQU4 2.003 1,727Landmark Community Bank1305 248,000.00 248,000.00 01/22/20260.50001/22/2021 243,595.37 1,82651507LCC6 0.500 321Luana Savings Bank1225 245,000.00 245,000.00 03/18/20221.60009/18/2019 247,975.03 912549104JN8 1.599 303Maine Savings FCU1171 248,000.00 248,000.00 02/28/20223.30012/28/2018 254,443.62 1,158560507AK1 3.306 1,091Main Street Bank1188 248,000.00 248,000.00 04/26/20242.60004/26/2019 263,960.46 1,82756065GAG3 2.603 899Marlin Business Bank1155 248,000.00 248,000.00 10/17/20233.30010/17/2018 266,117.82 1,82657116ARV2 3.302 585Medallion Bank1169 248,000.00 248,000.00 12/07/20223.40012/07/2018 260,560.80 1,46158404DCX7 3.402 1,299Morgan Stanley Bank1237 245,000.00 245,000.00 11/20/20241.95011/20/2019 256,770.10 1,82761690UNX4 1.952 780Morton Community1173 248,000.00 248,000.00 06/20/20232.75003/20/2019 261,148.08 1,553619165JD6 2.753 545Merrick Bank1163 248,000.00 248,000.00 10/28/20223.25010/30/2018 259,142.31 1,45959013J4K2 3.252 1,299Morgan Stanley Private Bk, NA1236 245,000.00 245,000.00 11/20/20241.90011/20/2019 256,333.19 1,82761760A3B3 1.902 556Mountain America Federal CU1099 245,000.00 245,000.00 11/08/20222.30011/08/2017 252,635.88 1,82662384RAC0 2.301 899Municipal Trust and Savings1160 245,000.00 245,000.00 10/17/20233.20010/17/2018 262,289.03 1,826625925AR3 3.202 1,430Nicolet Natl Bank1266 248,000.00 248,000.00 03/31/20251.40003/31/2020 254,547.35 1,826654062JZ2 1.401 234Neighbors FCU1167 245,000.00 245,000.00 12/21/20213.20012/21/2018 249,791.92 1,09664017AAQ7 3.203 964National Cooperative Bank, N.A1170 245,000.00 245,000.00 12/21/20233.40012/21/2018 264,596.63 1,826635573AL2 3.402 941Numerica Credit Union1164 248,000.00 248,000.00 11/28/20233.55011/28/2018 268,459.24 1,82667054NAN3 3.552 178Northpointe Bank1127 240,000.00 240,000.00 10/26/20212.70004/26/2018 243,005.62 1,279666613GV0 2.703 699Northstar Bank1263 248,000.00 248,000.00 03/31/20231.15003/31/2020 252,178.59 1,09566704MEQ0 1.150 1,018Northwest Bank1181 248,000.00 248,000.00 02/13/20242.95002/13/2019 265,579.41 1,82666736ABP3 2.951 821Bank of New England1151 249,000.00 249,000.00 07/31/20233.25007/31/2018 265,437.39 1,82606426KAN8 3.252 149New York Community Bank1226 245,000.00 245,000.00 09/27/20211.80009/27/2019 246,672.77 731649447TC3 1.802 263The Ohio Valley Bank1089 240,000.00 240,000.00 01/19/20221.90007/19/2017 242,971.84 1,645677721CN0 1.903 1,081Pacific Western Bank1269 245,000.00 245,000.00 04/16/20241.30004/16/2020 251,113.35 1,46169506YRH4 1.301 403PCSB Bank1149 245,000.00 245,000.00 06/08/20223.00006/08/2018 252,463.06 1,46169324MAD7 3.002 1,187People's Bank1210 248,000.00 248,000.00 07/31/20242.00007/31/2019 259,657.39 1,827710571DS6 2.002 767Pittsfield Cooperative Bank1194 245,000.00 245,000.00 06/07/20232.50006/07/2019 256,463.55 1,461725404AB3 2.502 1,133Plains Commerce Bank1195 245,000.00 245,000.00 06/07/20242.55006/07/2019 260,676.42 1,82772651LCL6 2.553 1,203Preferred Bank1213 249,000.00 249,000.00 08/16/20242.00008/16/2019 261,038.05 1,827740367HP5 2.002 25PrivateBank & Trust1032 240,000.00 240,000.00 05/26/20211.50005/26/2016 240,240.79 1,82674267GVG9 1.501 844Raymond James Bank1218 244,000.00 244,000.00 08/23/20231.95008/23/2019 253,228.20 1,46175472RAD3 1.951 780RCB Bank1144 245,000.00 245,000.00 06/20/20233.15006/20/2018 260,107.96 1,82674934YAH4 3.152 585Red Rocks Credit Union1166 248,000.00 248,000.00 12/07/20223.35012/07/2018 260,359.44 1,46175701LAB3 3.352 1,154Revere Bank1203 247,000.00 247,000.00 06/28/20242.30006/28/2019 261,131.70 1,827761402BY1 2.303 Portfolio CITY CP Run Date: 09/10/2021 - 10:04 PM (PRF_PM2) 7.3.0 Days to Maturity Page 6 Par Value Book Value Maturity Date Stated RateMarket Value April 30, 2021 Portfolio Details - Investments Average BalanceIssuer Portfolio Management City of La Quinta YTM 365TermCUSIPInvestment # Purchase Date Certificate of Deposits 1,017Rollstone B&T1251 245,000.00 245,000.00 02/12/20241.65002/12/2020 253,391.27 1,46177579ADF0 1.651 416Sallie Mae Bank Salt Lake CIty1083 240,000.00 240,000.00 06/21/20222.35006/21/2017 245,737.93 1,826795450A70 2.351 1,286Sauk Valley B&T Co1235 248,000.00 248,000.00 11/07/20241.70011/07/2019 257,619.47 1,827804375DL4 1.702 661Servisfirst Bank1254 248,000.00 248,000.00 02/21/20231.60002/21/2020 253,998.99 1,09681768PAF3 1.601 608San Francisco FCU1240 248,000.00 248,000.00 12/30/20221.85012/30/2019 254,566.08 1,09679772FAC0 1.852 334Bank of Santa Clarita1261 248,000.00 248,000.00 03/31/20221.10003/31/2020 249,887.38 73006424KBC3 1.100 1,419Spring Bank1257 248,000.00 248,000.00 03/20/20251.50003/20/2020 255,863.49 1,826849430BF9 1.501 1,273Southern Bancorp Bk1286 248,000.00 248,000.00 10/25/20240.50006/26/2020 247,279.19 1,58284223QAN7 0.500 485Sterling Bank1201 245,000.00 245,000.00 08/29/20222.15006/28/2019 251,165.15 1,15885916VDC6 2.153 397Synchrony Bank Retail1080 240,000.00 240,000.00 06/02/20222.40006/02/2017 245,609.36 1,82687164XQV1 2.401 404Synovus Bank1253 245,000.00 245,000.00 06/09/20221.60003/09/2020 248,626.89 82287164DRD4 1.602 1,062Texas Bank Financial1260 245,000.00 245,000.00 03/28/20241.10003/31/2020 249,687.36 1,458882213AB7 1.101 1,080The Jefferson Bank1272 248,000.00 248,000.00 04/15/20241.25004/15/2020 253,819.00 1,461472382AQ3 1.251 1,817Toyota Financial Savings Bank1314 245,000.00 245,000.00 04/22/20260.90004/22/2021 244,589.82 1,82689235MKY6 0.900 464Traditions Bank1148 245,000.00 245,000.00 08/08/20223.00006/08/2018 253,587.87 1,52289269CBX9 3.002 881Triad Bank1262 248,000.00 248,000.00 09/29/20231.35003/30/2020 254,067.51 1,27889579NCD3 1.352 205TNB Bank1187 248,000.00 248,000.00 11/22/20212.40005/22/2019 251,134.27 91587266AAA1 2.407 899UBS Bank USA1161 245,000.00 245,000.00 10/17/20233.35010/17/2018 263,203.47 1,82690348JEJ5 3.352 1,378United Community1249 248,000.00 248,000.00 02/07/20251.65002/07/2020 257,236.51 1,82790983WBT7 1.652 235United Credit Union1214 248,000.00 248,000.00 12/22/20212.00008/22/2019 250,924.23 853910160AH3 2.003 744University of Iowa Comm. CU1134 240,000.00 240,000.00 05/15/20233.05005/14/2018 253,711.15 1,82791435LAG2 3.052 668Verus Bank of Commerce1180 248,000.00 248,000.00 02/28/20232.70002/28/2019 259,117.99 1,46192535LCD4 2.700 1,032Wells Fargo1174 248,000.00 248,000.00 02/27/20243.00002/27/2019 266,173.03 1,826949763XY7 3.001 699West Michigan Cmnty Bk1265 248,000.00 248,000.00 03/31/20231.15003/31/2020 252,178.59 1,095954444BS3 1.150 639Wells Fargo Natl Bank West1244 248,000.00 248,000.00 01/30/20231.90001/29/2020 255,119.35 1,097949495AT2 1.900 1,210Washington Federal1215 248,000.00 248,000.00 08/23/20242.00008/23/2019 260,058.78 1,827938828BH2 2.002 1,473Western State Bank1277 245,000.00 245,000.00 05/13/20251.00005/13/2020 247,702.99 1,82695960NKD8 1.001 32,241,000.00 1,60533,327,053.7132,241,000.0031,841,500.00Subtotal and Average 885 2.085 Corporate Notes 95Apple Inc1079 500,000.00 493,050.00 08/04/20211.55006/12/2017 501,190.00 1,514037833CC2 1.900 641Colgate-Palmolive1175 500,000.00 485,250.00 02/01/20231.95003/04/2019 514,055.00 1,43019416QEA4 2.751 1,762International Finance Corp.1308 500,000.00 497,300.00 02/26/20260.50002/26/2021 493,275.00 1,82645950VPS9 0.610 829Microsoft Corporation1157 400,000.00 378,360.00 08/08/20232.00010/15/2018 414,664.00 1,758594918BQ6 3.222 281Proctor and Gamble1159 500,000.00 487,950.00 02/06/20222.30010/15/2018 507,960.00 1,210742718DY2 3.071 593Wal-Mart Stores, Inc1190 500,000.00 496,650.00 12/15/20222.35004/16/2019 515,995.00 1,339931142DU4 2.799 Portfolio CITY CP Run Date: 09/10/2021 - 10:04 PM (PRF_PM2) 7.3.0 Days to Maturity Page 7 Par Value Book Value Maturity Date Stated RateMarket Value April 30, 2021 Portfolio Details - Investments Average BalanceIssuer Portfolio Management City of La Quinta YTM 365TermCUSIPInvestment # Purchase Date 2,838,560.00 1,5042,947,139.002,900,000.002,838,560.00Subtotal and Average 697 2.354 Money Market with Fiscal Agent 1US Bank1058 1,422.08 1,422.0807/01/2016 1,422.08 1SYS1058 0.000 1,422.08 11,422.081,422.0870.34Subtotal and Average 1 0.000 CERBT - OPEB Trust 1CalPERS CERBT Plan1114 1,934,231.01 1,934,231.0107/01/2020 1,934,231.01 1SYS1114 0.000 1,934,231.01 11,934,231.011,934,231.011,934,231.01Subtotal and Average 1 0.000 PARS Pension Trust 1Pblc Agncy Rtrmnt Serv1230 11,227,866.79 11,227,866.7907/01/2020 11,227,866.79 1SYS1230 0.000 11,227,866.79 111,227,866.7911,227,866.7911,038,379.49Subtotal and Average 1 0.000 686157,037,173.30 161,985,895.22 394 0.840163,749,650.14 161,739,142.39Total and Average Portfolio CITY CP Run Date: 09/10/2021 - 10:04 PM (PRF_PM2) 7.3.0 City of La Quinta Total Earnings City of La Quinta - Sorted by Fund - Fund April 1, 2021 - April 30, 2021 Current Rate Ending Par Value Ending Fund Book Value Beginning Book Value Adjusted Interest Earnings Accretion Amortization/ Earnings Adjusted InterestAnnualized YieldCUSIPInvestment # Interest EarnedIssuer Realized Gainl/Loss Fund: General Fund 240,000.001032240,000.00 1.500PRVTBA 295.89 0.00 295.891.500101240,000.0074267GVG9 0.00 5,000,000.0010455,000,000.00 1.125USTR 4,661.61 0.00 4,661.611.1341015,000,000.00912828S27 0.00 55,429,948.66105555,429,948.66 0.339LAIF 15,074.60 0.00 15,074.600.32010157,363,733.5298-33-434 0.00 3,300.0010593,300.00CITYPC 0.00 0.00 0.001013,300.00SYS1059 0.00 240,000.001066240,000.00 2.250DISCOV 443.83 0.00 443.832.250101240,000.002546722U1 0.00 240,000.001067240,000.00 2.200BMW 433.97 0.00 433.972.200101240,000.0005580AGK4 0.00 1,942,800.0010702,000,000.00 1.250USTR 2,070.69 0.00 2,070.691.2971011,942,800.00912828T67 0.00 0.0010770.00 2.250AMEX 266.30 0.00 266.302.250101240,000.0002587DP85 0.00 240,000.001078240,000.00 2.400GLDMAN 473.42 0.00 473.422.400101240,000.0038148PJK4 0.00 493,050.001079500,000.00 1.550APPL 645.84 0.00 645.841.594101493,050.00037833CC2 0.00 240,000.001080240,000.00 2.400SYNCHR 473.42 0.00 473.422.400101240,000.0087164XQV1 0.00 240,000.001082240,000.00 2.250CAP1NA 443.83 0.00 443.832.250101240,000.0014042RGD7 0.00 240,000.001083240,000.00 2.350SALMAE 463.56 0.00 463.562.350101240,000.00795450A70 0.00 240,000.001085240,000.00 1.850CNTRL 364.93 0.00 364.931.850101240,000.0015523RBJ4 0.00 240,000.001089240,000.00 1.900OHVAL 374.79 0.00 374.791.900101240,000.00677721CN0 0.00 245,000.001095245,000.00 2.250ALLIAN 453.08 0.00 453.082.250101245,000.0001859BAA3 0.00 240,000.001096240,000.00 2.400AMFSB 473.42 0.00 473.422.400101240,000.0002587CFU9 0.00 240,000.001097240,000.00 2.300BARCLY 453.70 0.00 453.702.300101240,000.0006740KLJ4 0.00 245,000.001099245,000.00 2.300MTNAMR 463.15 0.00 463.152.300101245,000.0062384RAC0 0.00 245,000.001101245,000.00 2.100KANSAS 422.88 0.00 422.882.100101245,000.0050116CBE8 0.00 245,000.001102245,000.00 2.100BELMNT 422.87 0.00 422.872.100101245,000.00080515CD9 0.00 992,200.0011051,000,000.00 1.700FFCB 1,416.66 0.00 1,416.661.737101992,200.003133EHWM1 0.00 245,000.001106245,000.00 2.200CRS1ST 443.01 0.00 443.012.200101245,000.0022766ACB9 0.00 245,000.001107245,000.00 2.150ENTRPR 432.95 0.00 432.952.150101245,000.0029367QCP1 0.00 245,000.001110245,000.00 2.400KNOX 483.29 0.00 483.292.400101245,000.00499724AB8 0.00 245,000.001112245,000.00 2.5003RD 503.42 0.00 503.422.500101245,000.0088413QBY3 0.00 1,934,231.0111141,934,231.01CALPRS 0.00 0.00 0.001011,934,231.01SYS1114 0.00 245,000.001119245,000.00 2.800ANECA 563.83 0.00 563.832.800101245,000.00034577AH9 0.00 245,000.001123245,000.00 2.900CITINA 583.97 0.00 583.972.900101245,000.0017312QJ26 0.00 240,000.001125240,000.00 2.950ENER 581.92 0.00 581.922.950101240,000.0029278TAY6 0.00 Portfolio CITY CP Run Date: 09/10/2021 - 18:21 TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 Current Rate Ending Par Value Ending Fund Page 2 Book Value Beginning Book Value Adjusted Interest Earnings Accretion Amortization/ Earnings Adjusted Interest April 1, 2021 - April 30, 2021 Total Earnings City of La Quinta Annualized YieldCUSIPInvestment # Interest EarnedIssuer Realized Gainl/Loss Fund: General Fund 240,000.001126240,000.00 2.800FARMIG 552.33 0.00 552.332.800101240,000.0030960QAG2 0.00 240,000.001127240,000.00 2.700NORPNT 532.60 0.00 532.602.700101240,000.00666613GV0 0.00 0.0011280.00 2.800TOWNE 533.92 0.00 533.922.800101240,000.0089214PBL2 0.00 240,000.001134240,000.00 3.050UOFICU 601.64 0.00 601.643.050101240,000.0091435LAG2 0.00 245,000.001143245,000.00 3.100ALLGNC 624.25 0.00 624.253.100101245,000.0001748DBE5 0.00 245,000.001144245,000.00 3.150RCB 634.32 0.00 634.323.150101245,000.0074934YAH4 0.00 245,000.001147245,000.00 3.1501STNBA 634.32 0.00 634.323.150101245,000.0032110YLK9 0.00 245,000.001148245,000.00 3.000TRAD 604.11 0.00 604.113.000101245,000.0089269CBX9 0.00 245,000.001149245,000.00 3.000PCSB 604.11 0.00 604.113.000101245,000.0069324MAD7 0.00 240,000.001150240,000.00 3.100GECRUN 611.51 0.00 611.513.100101240,000.00369674AV8 0.00 249,000.001151249,000.00 3.250NWENGL 665.14 0.00 665.143.250101249,000.0006426KAN8 0.00 854,097.001153854,097.00 0.060CAMP 38.71 0.00 38.710.055101854,058.29SYS1153 0.00 245,000.001154245,000.00 3.350JEFF 674.59 0.00 674.593.350101245,000.00474067AQ8 0.00 248,000.001155248,000.00 3.300MARBUS 672.66 0.00 672.663.300101248,000.0057116ARV2 0.00 378,360.001157400,000.00 2.000MCRSFT 666.66 0.00 666.662.144101378,360.00594918BQ6 0.00 247,275.001158250,000.00 2.800FFCB 583.33 0.00 583.332.870101247,275.003133EJYL7 0.00 487,950.001159500,000.00 2.300P&G 958.34 0.00 958.342.390101487,950.00742718DY2 0.00 245,000.001160245,000.00 3.200MUNTRS 644.38 0.00 644.383.200101245,000.00625925AR3 0.00 245,000.001161245,000.00 3.350UBS 674.59 0.00 674.593.350101245,000.0090348JEJ5 0.00 248,000.001162248,000.00 3.400COMMBK 693.04 0.00 693.043.400101248,000.0020143PDV9 0.00 248,000.001163248,000.00 3.250MRRCK 662.47 0.00 662.473.250101248,000.0059013J4K2 0.00 248,000.001164248,000.00 3.550NMRCA 723.62 0.00 723.623.550101248,000.0067054NAN3 0.00 248,000.001166248,000.00 3.350REDRCK 682.85 0.00 682.853.350101248,000.0075701LAB3 0.00 245,000.001167245,000.00 3.200NEIGH 644.39 0.00 644.393.200101245,000.0064017AAQ7 0.00 245,000.001168245,000.00 3.1501STSRC 634.32 0.00 634.323.150101245,000.0033646CKP8 0.00 248,000.001169248,000.00 3.400MEDBA 693.04 0.00 693.043.400101248,000.0058404DCX7 0.00 245,000.001170245,000.00 3.400NLCOOP 684.66 0.00 684.663.400101245,000.00635573AL2 0.00 248,000.001171248,000.00 3.300MAINE 672.65 0.00 672.653.300101248,000.00560507AK1 0.00 248,000.001172248,000.00 3.350BARHAR 682.85 0.00 682.853.350101248,000.00066851WJ1 0.00 248,000.001173248,000.00 2.750MORTN 560.55 0.00 560.552.750101248,000.00619165JD6 0.00 248,000.001174248,000.00 3.000WELLS 611.51 0.00 611.513.000101248,000.00949763XY7 0.00 485,250.001175500,000.00 1.950COLGTE 812.50 0.00 812.502.037101485,250.0019416QEA4 0.00 498,550.001177500,000.00 2.500FHLB 1,041.66 0.00 1,041.662.542101498,550.003130AFW94 0.00 489,687.501178500,000.00 1.875USTR 768.45 0.00 768.451.909101489,687.509128282W9 0.00 248,000.001179248,000.00 2.8001STNBK 570.74 0.00 570.742.800101248,000.0032117BCX4 0.00 248,000.001180248,000.00 2.700VERUS 550.35 0.00 550.352.700101248,000.0092535LCD4 0.00 248,000.001181248,000.00 2.950NRTHWS 601.32 0.00 601.322.950101248,000.0066736ABP3 0.00 Portfolio CITY CP Run Date: 09/10/2021 - 18:21 TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 Current Rate Ending Par Value Ending Fund Page 3 Book Value Beginning Book Value Adjusted Interest Earnings Accretion Amortization/ Earnings Adjusted Interest April 1, 2021 - April 30, 2021 Total Earnings City of La Quinta Annualized YieldCUSIPInvestment # Interest EarnedIssuer Realized Gainl/Loss Fund: General Fund 248,000.001184248,000.00 2.500CENTNX 509.60 0.00 509.602.500101248,000.00156634AK3 0.00 245,000.001185245,000.00 3.250JPMORG 654.45 0.00 654.453.250101245,000.0048128HXU7 0.00 245,000.001186245,000.00 2.400IOWAST 483.29 0.00 483.292.400101245,000.0046256YAZ2 0.00 248,000.001187248,000.00 2.400TSCOLA 489.21 0.00 489.212.400101248,000.0087266AAA1 0.00 248,000.001188248,000.00 2.600MAINST 529.97 0.00 529.972.600101248,000.0056065GAG3 0.00 248,000.001189248,000.00 2.500CONGRS 509.59 0.00 509.592.500101248,000.0020726ABA5 0.00 496,650.001190500,000.00 2.350WALMRT 979.17 0.00 979.172.399101496,650.00931142DU4 0.00 496,650.001192500,000.00 1.750USTR 725.14 0.00 725.141.776101496,650.00912828SV3 0.00 493,610.001193500,000.00 1.375USTR 566.62 0.00 566.621.397101493,610.00912828R77 0.00 245,000.001194245,000.00 2.500PITTS 503.43 0.00 503.432.500101245,000.00725404AB3 0.00 245,000.001195245,000.00 2.550PLAINS 513.49 0.00 513.492.550101245,000.0072651LCL6 0.00 248,000.001196248,000.00 2.600EVNSCU 529.97 0.00 529.972.600101248,000.00299547AQ2 0.00 248,000.001197248,000.00 2.400LEGCY 489.21 0.00 489.212.400101248,000.00524661CB9 0.00 499,500.001198500,000.00 1.875FFCB 781.25 0.00 781.251.903101499,500.003133EKQP4 0.00 248,000.001199248,000.00 2.400CTZNST 489.20 0.00 489.202.400101248,000.00176688CP2 0.00 248,000.001200248,000.00 2.300AMERCU 468.82 0.00 468.822.300101248,000.0003065AAL7 0.00 245,000.001201245,000.00 2.150STRLNG 432.94 0.00 432.942.150101245,000.0085916VDC6 0.00 248,000.001202248,000.00 2.250COMMW 458.63 0.00 458.632.250101248,000.0020416TAQ5 0.00 247,000.001203247,000.00 2.300REVER 466.94 0.00 466.942.300101247,000.00761402BY1 0.00 248,000.001205248,000.00 2.000AMRNTL 407.67 0.00 407.672.000101248,000.0002772JBD1 0.00 495,950.001206500,000.00 1.750FNMA 729.17 0.00 729.171.789101495,950.003135G0V75 0.00 248,000.001207248,000.00 1.950ABACUS 397.48 0.00 397.481.950101248,000.0000257TBD7 0.00 248,000.001208248,000.00 2.000LKSIDE 407.67 0.00 407.672.000101248,000.0051210SQU4 0.00 248,000.001209248,000.00 2.0001STSEC 407.67 0.00 407.672.000101248,000.0033625CCP2 0.00 248,000.001210248,000.00 2.000PEOPLE 407.67 0.00 407.672.000101248,000.00710571DS6 0.00 499,500.001212500,000.00 1.850FFCB 770.83 0.00 770.831.878101499,500.003133EKWV4 0.00 249,000.001213249,000.00 2.000PREFRD 409.32 0.00 409.322.000101249,000.00740367HP5 0.00 248,000.001214248,000.00 2.000UNTDCU 407.67 0.00 407.672.000101248,000.00910160AH3 0.00 248,000.001215248,000.00 2.000WSHFED 407.67 0.00 407.672.000101248,000.00938828BH2 0.00 249,000.001216249,000.00 1.9501STIER 399.08 0.00 399.081.950101249,000.0033766LAJ7 0.00 499,300.001217500,000.00 1.375USTR 563.53 0.00 563.531.373101499,300.00912828T26 0.00 244,000.001218244,000.00 1.950RAYJAM 391.07 0.00 391.071.950101244,000.0075472RAD3 0.00 245,000.001219245,000.00 1.900CITBNK 382.60 0.00 382.601.900101245,000.0012556LBA3 0.00 248,000.001220248,000.00 1.850CELTIC 377.10 0.00 377.101.850101248,000.0015118RRH2 0.00 249,000.001221249,000.00 1.8501STNBS 378.62 0.00 378.621.850101249,000.00334342CD2 0.00 248,000.001222248,000.00 1.8001STDQN 366.90 0.00 366.901.800101248,000.00336460CX6 0.00 499,400.001223500,000.00 1.600FFCB 666.67 0.00 666.671.624101499,400.003133EKZK5 0.00 Portfolio CITY CP Run Date: 09/10/2021 - 18:21 TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 Current Rate Ending Par Value Ending Fund Page 4 Book Value Beginning Book Value Adjusted Interest Earnings Accretion Amortization/ Earnings Adjusted Interest April 1, 2021 - April 30, 2021 Total Earnings City of La Quinta Annualized YieldCUSIPInvestment # Interest EarnedIssuer Realized Gainl/Loss Fund: General Fund 498,750.001224500,000.00 1.600FFCB 666.67 0.00 666.671.626101498,750.003133EKP75 0.00 245,000.001225245,000.00 1.600LUANA 322.19 0.00 322.191.600101245,000.00549104JN8 0.00 245,000.001226245,000.00 1.800NYCMBK 362.47 0.00 362.471.800101245,000.00649447TC3 0.00 248,000.001227248,000.00 1.700BNKWST 346.52 0.00 346.521.700101248,000.0006652CHB0 0.00 9,456,806.9612289,456,806.96BOTW 0.01 0.00 0.011012,153,669.02059731851 0.00 11,227,866.79123011,227,866.79PARS 0.00 0.00 0.0010111,031,845.44SYS1230 0.00 248,000.001231248,000.00 1.7001STSER 346.52 0.00 346.521.700101248,000.0033640VDD7 0.00 992,100.0012331,000,000.00 1.375FNMA 1,145.83 0.00 1,145.831.405101992,100.003135G0W33 0.00 996,900.0012341,000,000.00 1.600FFCB 1,333.33 0.00 1,333.331.627101996,900.003133EK4X1 0.00 248,000.001235248,000.00 1.700SAUKVL 346.52 0.00 346.521.700101248,000.00804375DL4 0.00 245,000.001236245,000.00 1.900MSPRIV 382.60 0.00 382.601.900101245,000.0061760A3B3 0.00 245,000.001237245,000.00 1.950MORGST 392.67 0.00 392.671.950101245,000.0061690UNX4 0.00 248,000.001238248,000.00 1.800LIVEOK 366.90 0.00 366.901.800101248,000.00538036GV0 0.00 248,000.001239248,000.00 1.900KERNCU 387.29 0.00 387.291.900101248,000.0049228XAK6 0.00 248,000.001240248,000.00 1.850SF FCU 377.10 0.00 377.101.850101248,000.0079772FAC0 0.00 989,687.5012411,000,000.00 1.500USTR 1,236.27 0.00 1,236.271.520101989,687.50912828YV6 0.00 998,600.0012421,000,000.00 1.700FFCB 1,416.67 0.00 1,416.671.726101998,600.003133ELEA8 0.00 248,000.001244248,000.00 1.900WFNBW 387.29 0.00 387.291.900101248,000.00949495AT2 0.00 999,000.0012461,000,000.00 1.430FFCB 1,191.67 0.00 1,191.671.451101999,000.003133ELNE0 0.00 999,217.3612471,000,000.00 1.400FFCB 1,166.66 0.00 1,166.661.421101999,217.363133EGWJ0 0.00 248,000.001248248,000.00 1.550FRDMFI 315.95 0.00 315.951.550101248,000.0035637RDC8 0.00 248,000.001249248,000.00 1.650UNTDCM 336.33 0.00 336.331.650101248,000.0090983WBT7 0.00 248,000.001250248,000.00 1.6501STNMI 336.33 0.00 336.331.650101248,000.0032114VBT3 0.00 245,000.001251245,000.00 1.650RLLSTN 332.26 0.00 332.261.650101245,000.0077579ADF0 0.00 248,000.001252248,000.00 1.650CITADL 336.33 0.00 336.331.650101248,000.0017286TAG0 0.00 245,000.001253245,000.00 1.600SYNOVS 322.20 0.00 322.201.600101245,000.0087164DRD4 0.00 248,000.001254248,000.00 1.600SERVIS 326.14 0.00 326.141.600101248,000.0081768PAF3 0.00 248,000.001255248,000.00 1.600AMERST 326.14 0.00 326.141.600101248,000.00029728BC5 0.00 248,000.001256248,000.00 1.600ACCSS 326.14 0.00 326.141.600101248,000.0000435JBH5 0.00 248,000.001257248,000.00 1.500SPRING 305.76 0.00 305.761.500101248,000.00849430BF9 0.00 248,000.001258248,000.00 1.650AXOS 336.33 0.00 336.331.650101248,000.0005465DAE8 0.00 245,000.001259245,000.00 1.200CADNCE 241.64 0.00 241.641.200101245,000.0012738RFX7 0.00 245,000.001260245,000.00 1.100TEXAS 221.51 0.00 221.511.100101245,000.00882213AB7 0.00 248,000.001261248,000.00 1.100SNTCLR 224.22 0.00 224.221.100101248,000.0006424KBC3 0.00 248,000.001262248,000.00 1.350TRIAD 275.18 0.00 275.181.350101248,000.0089579NCD3 0.00 248,000.001263248,000.00 1.150NRTHSR 234.41 0.00 234.411.150101248,000.0066704MEQ0 0.00 248,000.001264248,000.00 1.300BELLCO 264.99 0.00 264.991.300101248,000.0007833EAD9 0.00 Portfolio CITY CP Run Date: 09/10/2021 - 18:21 TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 Current Rate Ending Par Value Ending Fund Page 5 Book Value Beginning Book Value Adjusted Interest Earnings Accretion Amortization/ Earnings Adjusted Interest April 1, 2021 - April 30, 2021 Total Earnings City of La Quinta Annualized YieldCUSIPInvestment # Interest EarnedIssuer Realized Gainl/Loss Fund: General Fund 248,000.001265248,000.00 1.150WESTMI 234.41 0.00 234.411.150101248,000.00954444BS3 0.00 248,000.001266248,000.00 1.400NCOLET 285.37 0.00 285.371.400101248,000.00654062JZ2 0.00 248,000.001267248,000.00 1.400ALMABK 285.37 0.00 285.371.400101248,000.00020080BX4 0.00 248,000.001268248,000.00 1.250CMWBUS 254.79 0.00 254.791.250101248,000.002027506M2 0.00 245,000.001269245,000.00 1.300PACWST 261.78 0.00 261.781.300101245,000.0069506YRH4 0.00 248,000.001270248,000.00 1.250BELB&T 254.79 0.00 254.791.250101248,000.0008016PDQ9 0.00 245,000.001271245,000.00 1.600CAPONE 322.19 0.00 322.191.600101245,000.0014042TDD6 0.00 248,000.001272248,000.00 1.250THEJEF 254.80 0.00 254.801.250101248,000.00472382AQ3 0.00 249,000.001273249,000.00 1.2001STFDM 245.60 0.00 245.601.200101249,000.0032027BAL1 0.00 248,000.001274248,000.00 1.3501STMCG 275.18 0.00 275.181.350101248,000.0032112UDR9 0.00 0.0012750.00 0.700FHLMC 388.89 0.00 1,888.893.452101998,500.003134GVLC0 1,500.00 248,000.001276248,000.00 1.250FLGSTR 254.79 0.00 254.791.250101248,000.0033847E3A3 0.00 245,000.001277245,000.00 1.000WSTRNS 201.37 0.00 201.371.000101245,000.0095960NKD8 0.00 248,000.001278248,000.00 1.0001STINT 203.84 0.00 203.841.000101248,000.0032056GDJ6 0.00 1,000,000.0012791,000,000.00 0.625FHLMC 520.83 0.00 520.830.6341011,000,000.003134GVYG7 0.00 499,850.001280500,000.00 0.500FFCB 208.33 0.00 208.330.507101499,850.003133ELH23 0.00 499,850.001281500,000.00 0.500FHLB 208.33 0.00 208.330.507101499,850.003130AJKW8 0.00 500,000.001282500,000.00 0.680FFCB 283.34 0.00 283.340.689101500,000.003133ELH80 0.00 300,000.001283300,000.00 0.680FHLB 170.00 0.00 170.000.689101300,000.003130AJRP6 0.00 248,000.001284248,000.00 0.600CHIPVA 122.30 0.00 122.300.600101248,000.00169894AS1 0.00 248,000.001285248,000.00 0.350AMR1ST 71.34 0.00 71.340.350101248,000.0002616AAH2 0.00 248,000.001286248,000.00 0.500STHRNB 101.92 0.00 101.920.500101248,000.0084223QAN7 0.00 248,000.001287248,000.00 0.500BKPRNC 101.92 0.00 101.920.500101248,000.00064520BG3 0.00 500,000.001288500,000.00 0.500FNMA 208.33 0.00 208.330.507101500,000.003135G05S8 0.00 1,000,000.0012891,000,000.00 0.560FNMA 466.67 0.00 466.670.5681011,000,000.003136G4N74 0.00 499,750.001290500,000.00 0.520FNMA 216.66 0.00 216.660.527101499,750.003136G4M75 0.00 499,250.001291500,000.00 0.420FNMA 175.00 0.00 175.000.426101499,250.003135G06E8 0.00 499,250.001292500,000.00 0.560FNMA 233.34 0.00 233.340.569101499,250.003135GA2Z3 0.00 3,254,568.5312933,254,568.53BNY 0.01 0.00 0.011013,257,492.64SYS1293 0.00 997,300.0012971,000,000.00 0.375FHLMC 312.50 0.00 312.500.381101997,300.003137EAEU9 0.00 497,400.001298500,000.00 0.375FHLB 156.25 0.00 156.250.382101497,400.003130AKFA9 0.00 500,000.001299500,000.00 0.600FNMA 250.00 0.00 250.000.608101500,000.003135GA7D7 0.00 500,000.001300500,000.00 0.400FNMA 166.66 0.00 166.660.406101500,000.003135GAAW1 0.00 500,000.001301500,000.00 0.550FHLMC 229.17 0.00 229.170.558101500,000.003134GXGZ1 0.00 500,000.001302500,000.00 0.510FHLB 212.50 0.00 212.500.517101500,000.003130AKMZ6 0.00 498,632.811303500,000.00 0.375USTR 155.39 0.00 155.390.379101498,632.8191282CBC4 0.00 500,000.001304500,000.00 0.550FHLB 229.17 0.00 229.170.558101500,000.003130AKN28 0.00 Portfolio CITY CP Run Date: 09/10/2021 - 18:21 TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 Current Rate Ending Par Value Ending Fund Page 6 Book Value Beginning Book Value Adjusted Interest Earnings Accretion Amortization/ Earnings Adjusted Interest April 1, 2021 - April 30, 2021 Total Earnings City of La Quinta Annualized YieldCUSIPInvestment # Interest EarnedIssuer Realized Gainl/Loss Fund: General Fund 248,000.001305248,000.00 0.500LNDMRK 101.92 0.00 101.920.500101248,000.0051507LCC6 0.00 245,000.001306245,000.00 0.500EVRBA 100.68 0.00 100.680.500101245,000.0087270LDL4 0.00 495,999.501307500,000.00 0.375FHLMC 156.25 0.00 156.250.383101495,999.503137EAEX3 0.00 497,300.001308500,000.00 0.500IFC 207.18 0.00 207.180.507101497,300.0045950VPS9 0.00 495,100.001309500,000.00 0.375USTR 155.39 0.00 155.390.382101495,100.0091282CBH3 0.00 983,940.0013101,000,000.00 0.375FHLMC 312.50 0.00 312.500.386101983,940.003137EAEX3 0.00 977,500.0013111,000,000.00 0.250USTR 207.07 0.00 207.070.258101977,500.0091282CAT8 0.00 500,000.001312500,000.00 0.500FHLB 208.34 0.00 208.340.507101500,000.003130ALV92 0.00 249,000.001313249,000.00 0.950GRNST 90.73 0.00 90.730.9501010.0039573LBC1 0.00 245,000.001314245,000.00 0.900TOYFSB 54.37 0.00 54.370.9001010.0089235MKY6 0.00 492,187.501315500,000.00 0.375USTR 46.36 0.00 46.360.3821010.0091282CAZ4 0.00 248,000.001316248,000.00 0.750CARTER 15.29 0.00 15.290.7501010.0014622LAA0 0.00 248,000.001317248,000.00 0.700FIDHMS 0.00 0.00 0.001010.0031617CAV5 0.00 217,583.211318217,583.21DPME 0.00 0.00 0.00101130,583.11SYS1318 0.00 151,069,402.16Subtotal 150,822,649.33 0.887 105,762.870.00104,262.87145,169,472.70 1,500.00 Fund: Fiscal Agent 1,422.0810581,422.08USBANK 0.01 0.00 0.010.51323123.73SYS1058 0.00 1,422.08Subtotal 1,422.08 0.513 0.010.000.0123.73 0.00 Fund: Housing Authority : WSA and LQ 334,384.441062334,384.44LQPR 0.00 0.00 0.00241328,273.80SYS1062 0.00 334,384.44Subtotal 334,384.44 0.000.000.00328,273.80 0.00 Fund: SA Low/Mod Bond Fund 10,580,686.54111310,580,686.54 0.339LAIF 2,846.99 0.00 2,846.990.32824910,569,141.1025-33-005 0.00 10,580,686.54Subtotal 10,580,686.54 0.328 2,846.990.002,846.9910,569,141.10 0.00 161,985,895.22Total 161,739,142.39 0.847 108,609.870.00107,109.87156,066,911.33 1,500.00 Portfolio CITY CP Run Date: 09/10/2021 - 18:21 TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 Days to Maturity Page 1 Par Value Book Value Maturity Date Stated RateMarket Value May 31, 2021 Portfolio Details - Investments Average BalanceIssuer Portfolio Management City of La Quinta YTM 365TermCUSIPInvestment # Purchase Date Bank Accounts 1Bank of New York1293 3,056,596.78 3,056,596.7809/01/2020 3,056,596.78 1SYS1293 0.000 1Bank of the West1228 11,490,355.05 11,490,355.0508/20/2019 11,490,355.05 1059731851 0.000 1City Petty Cash1059 3,300.00 3,300.0007/01/2016 3,300.00 1SYS1059 0.000 1Dune Palms Mobile Estates1318 241,247.93 241,247.9303/09/2021 241,247.93 1SYS1318 0.000 1La Quinta Palms Realty1062 326,355.81 326,355.8107/01/2016 326,355.81 1SYS1062 0.000 1Stifel, Nicolaus & Company1183 0.00 0.0003/18/2019 0.00 1SYS1183 0.000 15,117,855.57 115,117,855.5715,117,855.5713,268,789.78Subtotal and Average 1 0.000 Local Agency Investment Fund-City 1Local Agency Inv Fund1055 58,929,948.66 58,929,948.66 0.31559,266,295.86 198-33-434 0.315 58,929,948.66 159,266,295.8658,929,948.6656,333,174.47Subtotal and Average 1 0.315 Local Agency Invstmnt Fund-Housing 1Local Agency Inv Fund1113 10,580,686.54 10,580,686.54 0.31510,662,970.55 125-33-005 0.315 10,580,686.54 110,662,970.5510,580,686.5410,580,686.54Subtotal and Average 1 0.315 Money Market/Mutual Funds 1Dreyfus12940.00 0.0009/24/2020 0.00 1X9USDDTP3 0.000 0.00 00.000.000.00Subtotal and Average 0 0.000 Money Market Accounts - CAMP 1California Asset Management Pr1153 854,136.10 854,136.10 0.05009/26/2018 854,136.10 1SYS1153 0.050 854,136.10 1854,136.10854,136.10854,098.26Subtotal and Average 1 0.050 Federal Agency Coupon Securities 92Federal Farm Credit Bank1105 1,000,000.00 992,200.00 09/01/20211.70011/09/2017 1,004,050.00 1,3923133EHWM1 1.913 826Federal Farm Credit Bank1158 250,000.00 247,275.00 09/05/20232.80010/15/2018 264,447.50 1,7863133EJYL7 3.041 559Federal Farm Credit Bank1198 500,000.00 499,500.00 12/12/20221.87506/20/2019 513,395.00 1,2713133EKQP4 1.905 1,151Federal Farm Credit Bank1212 500,000.00 499,500.00 07/26/20241.85008/02/2019 522,785.00 1,8203133EKWV4 1.871 804Federal Farm Credit Bank1223 500,000.00 499,400.00 08/14/20231.60009/12/2019 515,090.00 1,4323133EKZK5 1.632 1,204Federal Farm Credit Bank1224 500,000.00 498,750.00 09/17/20241.60009/17/2019 519,625.00 1,8273133EKP75 1.652 883Federal Farm Credit Bank1234 1,000,000.00 996,900.00 11/01/20231.60011/01/2019 1,032,180.00 1,4613133EK4X1 1.680 1,204Federal Farm Credit Bank1242 1,000,000.00 998,600.00 09/17/20241.70012/17/2019 1,043,410.00 1,7363133ELEA8 1.731 988Federal Farm Credit Bank1246 1,000,000.00 999,000.00 02/14/20241.43002/14/2020 1,029,940.00 1,4613133ELNE0 1.456 485Federal Farm Credit Bank1247 1,000,000.00 999,217.36 09/29/20221.40002/05/2020 1,017,120.00 9673133EGWJ0 1.430 Portfolio CITY CP Run Date: 09/10/2021 - 10:31 PM (PRF_PM2) 7.3.0 Report Ver. 7.3.6.1 Days to Maturity Page 2 Par Value Book Value Maturity Date Stated RateMarket Value May 31, 2021 Portfolio Details - Investments Average BalanceIssuer Portfolio Management City of La Quinta YTM 365TermCUSIPInvestment # Purchase Date Federal Agency Coupon Securities 1,469Federal Farm Credit Bank1280 500,000.00 499,850.00 06/09/20250.50006/09/2020 498,010.00 1,8263133ELH23 0.506 1,470Federal Farm Credit Bank1282 500,000.00 500,000.00 06/10/20250.68006/10/2020 499,160.00 1,8263133ELH80 0.680 987Federal Home Loan Bank1177 500,000.00 498,550.00 02/13/20242.50003/01/2019 531,105.00 1,8103130AFW94 2.563 1,473Federal Home Loan Bank1281 500,000.00 499,850.00 06/13/20250.50006/03/2020 498,010.00 1,8363130AJKW8 0.506 1,490Federal Home Loan Bank1283 300,000.00 300,000.00 06/30/20250.68006/30/2020 297,759.00 1,8263130AJRP6 0.680 1,655Federal Home Loan Bank1298 500,000.00 497,400.00 12/12/20250.37512/07/2020 492,630.00 1,8313130AKFA9 0.480 1,688Federal Home Loan Bank1302 500,000.00 500,000.00 01/14/20260.51001/14/2021 493,180.00 1,8263130AKMZ6 0.510 1,703Federal Home Loan Bank1304 500,000.00 500,000.00 01/29/20260.55001/29/2021 494,880.00 1,8263130AKN28 0.550 1,763Federal Home Loan Bank1312 500,000.00 500,000.00 03/30/20260.50003/30/2021 499,750.00 1,8263130ALV92 0.938 1,456Federal Home Loan Mtg Corp1279 1,000,000.00 1,000,000.00 05/27/20250.62505/27/2020 1,000,110.00 1,8263134GVYG7 0.625 1,511Federal Home Loan Mtg Corp1297 1,000,000.00 997,300.00 07/21/20250.37512/07/2020 990,070.00 1,6873137EAEU9 0.434 1,673Federal Home Loan Mtg Corp1301 500,000.00 500,000.00 12/30/20250.55012/30/2020 494,829.00 1,8263134GXGZ1 0.550 1,575Federal Home Loan Mtg Corp1307 500,000.00 495,999.50 09/23/20250.37502/23/2021 494,240.00 1,6733137EAEX3 0.552 1,575Federal Home Loan Mtg Corp1310 1,000,000.00 983,940.00 09/23/20250.37503/30/2021 988,480.00 1,6383137EAEX3 0.740 1,127Federal National Mtg Assn1206 500,000.00 495,950.00 07/02/20241.75007/15/2019 521,500.00 1,8143135G0V75 1.922 462Federal National Mtg Assn1233 1,000,000.00 992,100.00 09/06/20221.37510/29/2019 1,015,890.00 1,0433135G0W33 1.659 1,535Federal National Mtg Assn1288 500,000.00 500,000.00 08/14/20250.50008/14/2020 496,150.00 1,8263135G05S8 0.500 1,542Federal National Mtg Assn1289 1,000,000.00 1,000,000.00 08/21/20250.56008/21/2020 995,100.00 1,8263136G4N74 0.560 1,539Federal National Mtg Assn1290 500,000.00 499,750.00 08/18/20250.52008/28/2020 496,665.00 1,8163136G4M75 0.530 1,266Federal National Mtg Assn1291 500,000.00 499,250.00 11/18/20240.42011/18/2020 499,205.00 1,4613135G06E8 0.458 1,630Federal National Mtg Assn1292 500,000.00 499,250.00 11/17/20250.56011/17/2020 495,485.00 1,8263135GA2Z3 0.590 1,666Federal National Mtg Assn1299 500,000.00 500,000.00 12/23/20250.60012/23/2020 495,775.00 1,8263135GA7D7 0.600 1,308Federal National Mtg Assn1300 500,000.00 500,000.00 12/30/20240.40012/30/2020 499,490.00 1,4613135GAAW1 0.400 20,989,531.86 1,62821,249,515.5021,050,000.0020,989,531.86Subtotal and Average 1,211 1.099 Treasury Coupon Securities 29U.S. Treasury1045 5,000,000.00 5,000,000.00 06/30/20211.12507/18/2016 5,004,400.00 1,808912828S27 1.125 152U.S. Treasury1070 2,000,000.00 1,942,800.00 10/31/20211.25003/27/2017 2,010,000.00 1,679912828T67 1.903 486U.S. Treasury1178 500,000.00 489,687.50 09/30/20221.87503/01/2019 511,760.00 1,3099128282W9 2.480 348U.S. Treasury1192 500,000.00 496,650.00 05/15/20221.75005/31/2019 508,010.00 1,080912828SV3 1.984 851U.S. Treasury1217 500,000.00 499,300.00 09/30/20231.37508/21/2019 513,750.00 1,501912828T26 1.410 1,278U.S. Treasury1241 1,000,000.00 989,687.50 11/30/20241.50012/16/2019 1,036,950.00 1,811912828YV6 1.718 1,674U.S. Treasury1303 500,000.00 498,632.81 12/31/20250.37501/07/2021 492,500.00 1,81991282CBC4 0.431 1,705U.S. Treasury1309 500,000.00 495,100.00 01/31/20260.37502/23/2021 491,780.00 1,80391282CBH3 0.577 1,613U.S. Treasury1311 1,000,000.00 977,500.00 10/31/20250.25003/30/2021 981,760.00 1,67691282CAT8 0.750 1,643U.S. Treasury1315 500,000.00 492,187.50 11/30/20250.37504/22/2021 493,030.00 1,68391282CAZ4 0.720 Portfolio CITY CP Run Date: 09/10/2021 - 10:31 PM (PRF_PM2) 7.3.0 Days to Maturity Page 3 Par Value Book Value Maturity Date Stated RateMarket Value May 31, 2021 Portfolio Details - Investments Average BalanceIssuer Portfolio Management City of La Quinta YTM 365TermCUSIPInvestment # Purchase Date Treasury Coupon Securities 1,733U.S. Treasury1319 500,000.00 494,165.00 02/28/20260.50005/28/2021 494,260.00 1,73791282CBQ3 0.750 1,764U.S. Treasury1320 500,000.00 499,525.00 03/31/20260.75005/28/2021 499,650.00 1,76891282CBT7 0.770 12,875,235.31 1,71113,037,850.0013,000,000.0012,487,450.47Subtotal and Average 648 1.264 Certificate of Deposits 1,186First State Bk DeQueen1222 248,000.00 248,000.00 08/30/20241.80008/30/2019 258,517.46 1,827336460CX6 1.802 1,428First Freedom Bank1273 249,000.00 249,000.00 04/29/20251.20004/29/2020 254,228.07 1,82632027BAL1 1.201 1,179FirsTier Bank1216 249,000.00 249,000.00 08/23/20241.95008/23/2019 261,039.51 1,82733766LAJ7 1.952 1,4411st Internet Bank1278 248,000.00 248,000.00 05/12/20251.00005/11/2020 251,487.51 1,82732056GDJ6 0.985 1,427First Natl Bk McGregor1274 248,000.00 248,000.00 04/28/20251.35004/28/2020 254,859.70 1,82632112UDR9 1.351 779First National Bank of America1147 245,000.00 245,000.00 07/20/20233.15007/20/2018 260,437.24 1,82632110YLK9 3.152 703First National Bank1179 248,000.00 248,000.00 05/05/20232.80003/05/2019 260,487.59 1,52232117BCX4 2.802 1,186First Natl Bk of Syracuse1221 249,000.00 249,000.00 08/30/20241.85008/30/2019 259,967.90 1,827334342CD2 1.852 1,354First National Bank Michigan1250 248,000.00 248,000.00 02/14/20251.65002/14/2020 257,842.18 1,82732114VBT3 1.652 1,155First Security Bank of WA1209 248,000.00 248,000.00 07/30/20242.00007/30/2019 259,983.46 1,82733625CCP2 2.002 1,079First Service Bank1231 248,000.00 248,000.00 05/15/20241.70011/15/2019 257,555.92 1,64333640VDD7 1.701 169First Source Bank1168 245,000.00 245,000.00 11/17/20213.15012/17/2018 248,553.26 1,06633646CKP8 3.153 244Third Federal Savings and Loan1112 245,000.00 245,000.00 01/31/20222.50001/30/2018 248,911.08 1,46288413QBY3 2.502 1,151Abacus Federal Savings1207 248,000.00 248,000.00 07/26/20241.95007/26/2019 259,871.29 1,82700257TBD7 1.952 1,381Access Bank1256 248,000.00 248,000.00 03/13/20251.60003/13/2020 257,381.37 1,82600435JBH5 1.601 377Allegiance Bank1143 245,000.00 245,000.00 06/13/20223.10006/13/2018 252,380.46 1,46101748DBE5 3.102 499Alliance Credit Union1095 245,000.00 245,000.00 10/13/20222.25010/13/2017 251,857.61 1,82601859BAA3 2.251 1,396Alma Bank1267 248,000.00 248,000.00 03/28/20251.40003/30/2020 255,382.41 1,824020080BX4 1.399 392America's Credit Union1200 248,000.00 248,000.00 06/28/20222.30006/28/2019 253,595.16 1,09603065AAL7 2.302 1,361American State1255 248,000.00 248,000.00 02/21/20251.60002/21/2020 257,427.49 1,827029728BC5 1.602 454American Express Fed Savings B1096 240,000.00 240,000.00 08/29/20222.40008/29/2017 246,574.44 1,82602587CFU9 2.402 755American First CU1285 248,000.00 248,000.00 06/26/20230.35006/26/2020 248,636.30 1,09502616AAH2 0.350 778American National Bank1205 248,000.00 248,000.00 07/19/20232.00007/19/2019 257,428.28 1,46102772JBD1 2.001 659Aneca Federal Credit Union1119 245,000.00 245,000.00 03/22/20232.80003/22/2018 256,550.38 1,826034577AH9 2.802 1,394Axos Bank1258 248,000.00 248,000.00 03/26/20251.65003/26/2020 257,944.22 1,82605465DAE8 1.651 511Barclays Bank1097 240,000.00 240,000.00 10/25/20222.30010/25/2017 247,048.98 1,82606740KLJ4 2.291 941Bar Harbor Bank and Trust1172 248,000.00 248,000.00 12/29/20233.35012/31/2018 267,363.54 1,824066851WJ1 3.352 1,050Belmont Bank and Trust1270 248,000.00 248,000.00 04/16/20241.25004/16/2020 254,178.57 1,46108016PDQ9 1.251 302Bellco Credit Union1264 248,000.00 248,000.00 03/30/20221.30003/31/2020 250,263.72 72907833EAD9 1.300 174Belmont Savings Bank1102 245,000.00 245,000.00 11/22/20212.10011/21/2017 247,385.53 1,462080515CD9 2.101 1,308Bank Princeton1287 248,000.00 248,000.00 12/30/20240.50006/30/2020 247,231.14 1,644064520BG3 0.500 Portfolio CITY CP Run Date: 09/10/2021 - 10:31 PM (PRF_PM2) 7.3.0 Days to Maturity Page 4 Par Value Book Value Maturity Date Stated RateMarket Value May 31, 2021 Portfolio Details - Investments Average BalanceIssuer Portfolio Management City of La Quinta YTM 365TermCUSIPInvestment # Purchase Date Certificate of Deposits 268BMW Bank1067 240,000.00 240,000.00 02/24/20222.20002/24/2017 243,682.32 1,82605580AGK4 2.201 1,214BankWest Inc1227 248,000.00 248,000.00 09/27/20241.70009/27/2019 258,092.42 1,82706652CHB0 1.702 303Cadence Bank, NA1259 245,000.00 245,000.00 03/31/20221.20003/31/2020 247,033.74 73012738RFX7 1.200 6Capital One Natl Assn FDIC42971082 240,000.00 240,000.00 06/07/20212.25006/07/2017 240,147.30 1,46114042RGD7 2.252 1,407Capital One USA FDIC339541271 245,000.00 245,000.00 04/08/20251.60004/08/2020 254,233.49 1,82614042TDD6 1.601 1,791Carter FCU1316 248,000.00 248,000.00 04/27/20260.75004/27/2021 246,825.92 1,82614622LAA0 0.750 1,186Celtic Bank1220 248,000.00 248,000.00 08/30/20241.85008/30/2019 258,923.86 1,82715118RRH2 1.852 1,093Century Next Bank1184 248,000.00 248,000.00 05/29/20242.50005/29/2019 263,406.67 1,827156634AK3 2.503 1,484Chippewa Valley Bk1284 248,000.00 248,000.00 06/24/20250.60006/24/2020 247,342.95 1,826169894AS1 0.600 1,367Citadel FCU1252 248,000.00 248,000.00 02/27/20251.65002/27/2020 257,935.38 1,82717286TAG0 1.652 448CIT Bank NA1219 245,000.00 245,000.00 08/23/20221.90008/23/2019 250,079.59 1,09612556LBA3 1.902 679Citibank NA1123 245,000.00 245,000.00 04/11/20232.90004/11/2018 257,366.44 1,82617312QJ26 2.902 1,399Commonwealth Business Bk1268 248,000.00 248,000.00 03/31/20251.25003/31/2020 253,772.95 1,8262027506M2 1.251 43Central State Bank1085 240,000.00 240,000.00 07/14/20211.85007/14/2017 240,567.11 1,46115523RBJ4 1.851 897Commercial Bank1162 248,000.00 248,000.00 11/15/20233.40011/15/2018 267,096.12 1,82620143PDV9 3.402 1,123Communitywide FCU1202 248,000.00 248,000.00 06/28/20242.25006/28/2019 261,897.99 1,82720416TAQ5 2.253 696Congressional Bank1189 248,000.00 248,000.00 04/28/20232.50004/30/2019 258,920.94 1,45920726ABA5 2.502 535CrossFirst Bank1106 245,000.00 245,000.00 11/18/20222.20011/20/2017 252,176.02 1,82422766ACB9 2.201 1,116Citizens State Bank1199 248,000.00 248,000.00 06/21/20242.40006/21/2019 263,119.39 1,827176688CP2 2.403 245Discover Bank Greenwood DE CF1066 240,000.00 240,000.00 02/01/20222.25002/01/2017 243,454.03 1,8262546722U1 2.251 696EnerBank USA1125 240,000.00 240,000.00 04/28/20232.95004/30/2018 252,663.76 1,82429278TAY6 2.952 545Enterprise Bank, NA1107 245,000.00 245,000.00 11/28/20222.15011/28/2017 252,130.04 1,82629367QCP1 2.151 1,107Evansville Teachers Credit FCU1196 248,000.00 248,000.00 06/12/20242.60006/12/2019 264,519.08 1,827299547AQ2 2.603 1,717TIAA FKA EverBank1306 245,000.00 245,000.00 02/12/20260.50002/12/2021 241,444.93 1,82687270LDL4 0.500 332Farmers Insurance Group FCU1126 240,000.00 240,000.00 04/29/20222.80004/30/2018 245,709.27 1,46030960QAG2 2.802 1,794Fidelity Homestead1317 248,000.00 248,000.00 04/30/20260.70004/30/2021 245,783.37 1,82631617CAV5 0.711 1,429Flagstar1276248,000.00 248,000.00 04/30/20251.25004/30/2020 253,689.23 1,82633847E3A3 1.251 1,354Freedom Financial1248 248,000.00 248,000.00 02/14/20251.55002/14/2020 256,917.16 1,82735637RDC8 1.552 76General Electric Credit Union1150 240,000.00 240,000.00 08/16/20213.10008/15/2018 241,610.46 1,097369674AV8 3.100 329Goldman Sachs1078 240,000.00 240,000.00 04/26/20222.40004/26/2017 244,870.02 1,82638148PJK4 2.401 1,780Greenstate FCU1313 249,000.00 249,000.00 04/16/20260.95004/16/2021 250,244.18 1,82639573LBC1 0.951 1,087Iowa State Bank1186 245,000.00 245,000.00 05/23/20242.40005/23/2019 259,661.17 1,82746256YAZ2 2.403 870Jefferson Financial CU1154 245,000.00 245,000.00 10/19/20233.35010/19/2018 263,092.34 1,826474067AQ8 3.352 1,080JP Morgan Chase1185 245,000.00 245,000.00 05/16/20243.25005/16/2019 265,803.95 1,82748128HXU7 3.254 350Kansas State Bank1101 245,000.00 245,000.00 05/17/20222.10011/17/2017 249,511.76 1,64250116CBE8 2.099 577Kern FCU1239 248,000.00 248,000.00 12/30/20221.90012/30/2019 254,650.78 1,09649228XAK6 1.902 Portfolio CITY CP Run Date: 09/10/2021 - 10:31 PM (PRF_PM2) 7.3.0 Days to Maturity Page 5 Par Value Book Value Maturity Date Stated RateMarket Value May 31, 2021 Portfolio Details - Investments Average BalanceIssuer Portfolio Management City of La Quinta YTM 365TermCUSIPInvestment # Purchase Date Certificate of Deposits 576Knoxville TVA Credit Union1110 245,000.00 245,000.00 12/29/20222.40012/29/2017 253,528.73 1,826499724AB8 2.401 1,114Legacy Bank1197 248,000.00 248,000.00 06/19/20242.40006/19/2019 263,092.57 1,827524661CB9 2.403 1,092Live Oak Bank1238 248,000.00 248,000.00 05/28/20241.80011/27/2019 258,297.52 1,644538036GV0 1.802 972Lakeside Bank1208 248,000.00 248,000.00 01/29/20242.00007/30/2019 258,848.19 1,64451210SQU4 2.003 1,696Landmark Community Bank1305 248,000.00 248,000.00 01/22/20260.50001/22/2021 244,644.60 1,82651507LCC6 0.500 290Luana Savings Bank1225 245,000.00 245,000.00 03/18/20221.60009/18/2019 247,837.56 912549104JN8 1.599 272Maine Savings FCU1171 248,000.00 248,000.00 02/28/20223.30012/28/2018 253,927.61 1,158560507AK1 3.306 1,060Main Street Bank1188 248,000.00 248,000.00 04/26/20242.60004/26/2019 264,073.04 1,82756065GAG3 2.603 868Marlin Business Bank1155 248,000.00 248,000.00 10/17/20233.30010/17/2018 265,984.77 1,82657116ARV2 3.302 554Medallion Bank1169 248,000.00 248,000.00 12/07/20223.40012/07/2018 260,131.10 1,46158404DCX7 3.402 1,268Morgan Stanley Bank1237 245,000.00 245,000.00 11/20/20241.95011/20/2019 257,196.94 1,82761690UNX4 1.952 749Morton Community1173 248,000.00 248,000.00 06/20/20232.75003/20/2019 261,050.04 1,553619165JD6 2.753 514Merrick Bank1163 248,000.00 248,000.00 10/28/20223.25010/30/2018 258,721.40 1,45959013J4K2 3.252 1,268Morgan Stanley Private Bk, NA1236 245,000.00 245,000.00 11/20/20241.90011/20/2019 256,768.67 1,82761760A3B3 1.902 525Mountain America Federal CU1099 245,000.00 245,000.00 11/08/20222.30011/08/2017 252,402.46 1,82662384RAC0 2.301 868Municipal Trust and Savings1160 245,000.00 245,000.00 10/17/20233.20010/17/2018 262,175.96 1,826625925AR3 3.202 1,399Nicolet Natl Bank1266 248,000.00 248,000.00 03/31/20251.40003/31/2020 255,204.26 1,826654062JZ2 1.401 203Neighbors FCU1167 245,000.00 245,000.00 12/21/20213.20012/21/2018 249,307.34 1,09664017AAQ7 3.203 933National Cooperative Bank, N.A1170 245,000.00 245,000.00 12/21/20233.40012/21/2018 264,489.59 1,826635573AL2 3.402 910Numerica Credit Union1164 248,000.00 248,000.00 11/28/20233.55011/28/2018 268,200.11 1,82667054NAN3 3.552 147Northpointe Bank1127 240,000.00 240,000.00 10/26/20212.70004/26/2018 242,606.54 1,279666613GV0 2.703 668Northstar Bank1263 248,000.00 248,000.00 03/31/20231.15003/31/2020 252,249.44 1,09566704MEQ0 1.150 987Northwest Bank1181 248,000.00 248,000.00 02/13/20242.95002/13/2019 265,584.58 1,82666736ABP3 2.951 790Bank of New England1151 249,000.00 249,000.00 07/31/20233.25007/31/2018 265,269.88 1,82606426KAN8 3.252 118New York Community Bank1226 245,000.00 245,000.00 09/27/20211.80009/27/2019 246,410.74 731649447TC3 1.802 232The Ohio Valley Bank1089 240,000.00 240,000.00 01/19/20221.90007/19/2017 242,747.05 1,645677721CN0 1.903 1,050Pacific Western Bank1269 245,000.00 245,000.00 04/16/20241.30004/16/2020 251,454.66 1,46169506YRH4 1.301 372PCSB Bank1149 245,000.00 245,000.00 06/08/20223.00006/08/2018 252,032.20 1,46169324MAD7 3.002 1,156People's Bank1210 248,000.00 248,000.00 07/31/20242.00007/31/2019 259,993.72 1,827710571DS6 2.002 736Pittsfield Cooperative Bank1194 245,000.00 245,000.00 06/07/20232.50006/07/2019 256,408.60 1,461725404AB3 2.502 1,102Plains Commerce Bank1195 245,000.00 245,000.00 06/07/20242.55006/07/2019 260,858.08 1,82772651LCL6 2.553 1,172Preferred Bank1213 249,000.00 249,000.00 08/16/20242.00008/16/2019 261,372.34 1,827740367HP5 2.002 813Raymond James Bank1218 244,000.00 244,000.00 08/23/20231.95008/23/2019 253,312.87 1,46175472RAD3 1.951 749RCB Bank1144 245,000.00 245,000.00 06/20/20233.15006/20/2018 259,936.93 1,82674934YAH4 3.152 554Red Rocks Credit Union1166 248,000.00 248,000.00 12/07/20223.35012/07/2018 259,939.27 1,46175701LAB3 3.352 1,123Revere Bank1203 247,000.00 247,000.00 06/28/20242.30006/28/2019 261,211.94 1,827761402BY1 2.303 Portfolio CITY CP Run Date: 09/10/2021 - 10:31 PM (PRF_PM2) 7.3.0 Days to Maturity Page 6 Par Value Book Value Maturity Date Stated RateMarket Value May 31, 2021 Portfolio Details - Investments Average BalanceIssuer Portfolio Management City of La Quinta YTM 365TermCUSIPInvestment # Purchase Date Certificate of Deposits 986Rollstone B&T1251 245,000.00 245,000.00 02/12/20241.65002/12/2020 253,633.25 1,46177579ADF0 1.651 385Sallie Mae Bank Salt Lake CIty1083 240,000.00 240,000.00 06/21/20222.35006/21/2017 245,440.25 1,826795450A70 2.351 1,255Sauk Valley B&T Co1235 248,000.00 248,000.00 11/07/20241.70011/07/2019 258,086.90 1,827804375DL4 1.702 630Servisfirst Bank1254 248,000.00 248,000.00 02/21/20231.60002/21/2020 253,948.80 1,09681768PAF3 1.601 577San Francisco FCU1240 248,000.00 248,000.00 12/30/20221.85012/30/2019 254,451.06 1,09679772FAC0 1.852 303Bank of Santa Clarita1261 248,000.00 248,000.00 03/31/20221.10003/31/2020 249,848.57 73006424KBC3 1.100 1,388Spring Bank1257 248,000.00 248,000.00 03/20/20251.50003/20/2020 256,480.68 1,826849430BF9 1.501 1,242Southern Bancorp Bk1286 248,000.00 248,000.00 10/25/20240.50006/26/2020 247,948.95 1,58284223QAN7 0.500 454Sterling Bank1201 245,000.00 245,000.00 08/29/20222.15006/28/2019 250,933.90 1,15885916VDC6 2.153 366Synchrony Bank Retail1080 240,000.00 240,000.00 06/02/20222.40006/02/2017 245,298.13 1,82687164XQV1 2.401 373Synovus Bank1253 245,000.00 245,000.00 06/09/20221.60003/09/2020 248,462.06 82287164DRD4 1.602 1,031Texas Bank Financial1260 245,000.00 245,000.00 03/28/20241.10003/31/2020 249,939.50 1,458882213AB7 1.101 1,049The Jefferson Bank1272 248,000.00 248,000.00 04/15/20241.25004/15/2020 254,172.74 1,461472382AQ3 1.251 1,786Toyota Financial Savings Bank1314 245,000.00 245,000.00 04/22/20260.90004/22/2021 245,630.17 1,82689235MKY6 0.900 433Traditions Bank1148 245,000.00 245,000.00 08/08/20223.00006/08/2018 253,180.41 1,52289269CBX9 3.002 850Triad Bank1262 248,000.00 248,000.00 09/29/20231.35003/30/2020 254,089.26 1,27889579NCD3 1.352 174TNB Bank1187 248,000.00 248,000.00 11/22/20212.40005/22/2019 250,782.47 91587266AAA1 2.407 868UBS Bank USA1161 245,000.00 245,000.00 10/17/20233.35010/17/2018 263,062.84 1,82690348JEJ5 3.352 1,347United Community1249 248,000.00 248,000.00 02/07/20251.65002/07/2020 257,792.01 1,82790983WBT7 1.652 204United Credit Union1214 248,000.00 248,000.00 12/22/20212.00008/22/2019 250,663.93 853910160AH3 2.003 713University of Iowa Comm. CU1134 240,000.00 240,000.00 05/15/20233.05005/14/2018 253,447.45 1,82791435LAG2 3.052 637Verus Bank of Commerce1180 248,000.00 248,000.00 02/28/20232.70002/28/2019 258,870.09 1,46192535LCD4 2.700 1,001Wells Fargo1174 248,000.00 248,000.00 02/27/20243.00002/27/2019 266,176.15 1,826949763XY7 3.001 668West Michigan Cmnty Bk1265 248,000.00 248,000.00 03/31/20231.15003/31/2020 252,249.44 1,095954444BS3 1.150 608Wells Fargo Natl Bank West1244 248,000.00 248,000.00 01/30/20231.90001/29/2020 255,013.48 1,097949495AT2 1.900 1,179Washington Federal1215 248,000.00 248,000.00 08/23/20242.00008/23/2019 260,395.45 1,827938828BH2 2.002 1,442Western State Bank1277 245,000.00 245,000.00 05/13/20251.00005/13/2020 248,442.82 1,82695960NKD8 1.001 32,001,000.00 1,60433,096,459.9632,001,000.0032,194,548.39Subtotal and Average 860 2.089 Corporate Notes 64Apple Inc1079 500,000.00 493,050.00 08/04/20211.55006/12/2017 500,585.00 1,514037833CC2 1.900 610Colgate-Palmolive1175 500,000.00 485,250.00 02/01/20231.95003/04/2019 514,355.00 1,43019416QEA4 2.751 1,731International Finance Corp.1308 500,000.00 497,300.00 02/26/20260.50002/26/2021 495,145.00 1,82645950VPS9 0.610 798Microsoft Corporation1157 400,000.00 378,360.00 08/08/20232.00010/15/2018 414,532.00 1,758594918BQ6 3.222 250Proctor and Gamble1159 500,000.00 487,950.00 02/06/20222.30010/15/2018 507,440.00 1,210742718DY2 3.071 562Wal-Mart Stores, Inc1190 500,000.00 496,650.00 12/15/20222.35004/16/2019 515,360.00 1,339931142DU4 2.799 Portfolio CITY CP Run Date: 09/10/2021 - 10:31 PM (PRF_PM2) 7.3.0 Days to Maturity Page 7 Par Value Book Value Maturity Date Stated RateMarket Value May 31, 2021 Portfolio Details - Investments Average BalanceIssuer Portfolio Management City of La Quinta YTM 365TermCUSIPInvestment # Purchase Date 2,838,560.00 1,5042,947,417.002,900,000.002,838,560.00Subtotal and Average 666 2.354 Money Market with Fiscal Agent 1US Bank1058 1,422.15 1,422.1507/01/2016 1,422.15 1SYS1058 0.000 1,422.15 11,422.151,422.151,422.08Subtotal and Average 1 0.000 CERBT - OPEB Trust 1CalPERS CERBT Plan1114 1,934,231.01 1,934,231.0107/01/2020 1,934,231.01 1SYS1114 0.000 1,934,231.01 11,934,231.011,934,231.011,934,231.01Subtotal and Average 1 0.000 PARS Pension Trust 1Pblc Agncy Rtrmnt Serv1230 11,277,103.22 11,277,103.2207/01/2020 11,277,103.22 1SYS1230 0.000 11,277,103.22 111,277,103.2211,277,103.2211,229,455.06Subtotal and Average 1 0.000 668162,711,947.92 167,646,383.25 378 0.805169,445,256.92 167,399,710.42Total and Average Portfolio CITY CP Run Date: 09/10/2021 - 10:31 PM (PRF_PM2) 7.3.0 City of La Quinta Total Earnings City of La Quinta - Sorted by Fund - Fund May 1, 2021 - May 31, 2021 Current Rate Ending Par Value Ending Fund Book Value Beginning Book Value Adjusted Interest Earnings Accretion Amortization/ Earnings Adjusted InterestAnnualized YieldCUSIPInvestment # Interest EarnedIssuer Realized Gainl/Loss Fund: General Fund 0.0010320.00 1.500PRVTBA 246.58 0.00 246.581.500101240,000.0074267GVG9 0.00 5,000,000.0010455,000,000.00 1.125USTR 4,816.98 0.00 4,816.981.1341015,000,000.00912828S27 0.00 58,929,948.66105558,929,948.66 0.315LAIF 15,688.70 0.00 15,688.700.33310155,429,948.6698-33-434 0.00 3,300.0010593,300.00CITYPC 0.00 0.00 0.001013,300.00SYS1059 0.00 240,000.001066240,000.00 2.250DISCOV 458.63 0.00 458.632.250101240,000.002546722U1 0.00 240,000.001067240,000.00 2.200BMW 448.44 0.00 448.442.200101240,000.0005580AGK4 0.00 1,942,800.0010702,000,000.00 1.250USTR 2,105.98 0.00 2,105.981.2761011,942,800.00912828T67 0.00 240,000.001078240,000.00 2.400GLDMAN 489.21 0.00 489.212.400101240,000.0038148PJK4 0.00 493,050.001079500,000.00 1.550APPL 645.83 0.00 645.831.542101493,050.00037833CC2 0.00 240,000.001080240,000.00 2.400SYNCHR 489.21 0.00 489.212.400101240,000.0087164XQV1 0.00 240,000.001082240,000.00 2.250CAP1NA 458.63 0.00 458.632.250101240,000.0014042RGD7 0.00 240,000.001083240,000.00 2.350SALMAE 479.01 0.00 479.012.350101240,000.00795450A70 0.00 240,000.001085240,000.00 1.850CNTRL 377.10 0.00 377.101.850101240,000.0015523RBJ4 0.00 240,000.001089240,000.00 1.900OHVAL 387.29 0.00 387.291.900101240,000.00677721CN0 0.00 245,000.001095245,000.00 2.250ALLIAN 468.18 0.00 468.182.250101245,000.0001859BAA3 0.00 240,000.001096240,000.00 2.400AMFSB 489.21 0.00 489.212.400101240,000.0002587CFU9 0.00 240,000.001097240,000.00 2.300BARCLY 468.82 0.00 468.822.300101240,000.0006740KLJ4 0.00 245,000.001099245,000.00 2.300MTNAMR 478.59 0.00 478.592.300101245,000.0062384RAC0 0.00 245,000.001101245,000.00 2.100KANSAS 436.97 0.00 436.972.100101245,000.0050116CBE8 0.00 245,000.001102245,000.00 2.100BELMNT 436.98 0.00 436.982.100101245,000.00080515CD9 0.00 992,200.0011051,000,000.00 1.700FFCB 1,416.67 0.00 1,416.671.681101992,200.003133EHWM1 0.00 245,000.001106245,000.00 2.200CRS1ST 457.78 0.00 457.782.200101245,000.0022766ACB9 0.00 245,000.001107245,000.00 2.150ENTRPR 447.38 0.00 447.382.150101245,000.0029367QCP1 0.00 245,000.001110245,000.00 2.400KNOX 499.40 0.00 499.402.400101245,000.00499724AB8 0.00 245,000.001112245,000.00 2.5003RD 520.21 0.00 520.212.500101245,000.0088413QBY3 0.00 1,934,231.0111141,934,231.01CALPRS 0.00 0.00 0.001011,934,231.01SYS1114 0.00 245,000.001119245,000.00 2.800ANECA 582.63 0.00 582.632.800101245,000.00034577AH9 0.00 245,000.001123245,000.00 2.900CITINA 603.44 0.00 603.442.900101245,000.0017312QJ26 0.00 240,000.001125240,000.00 2.950ENER 601.32 0.00 601.322.950101240,000.0029278TAY6 0.00 240,000.001126240,000.00 2.800FARMIG 570.74 0.00 570.742.800101240,000.0030960QAG2 0.00 Portfolio CITY CP Run Date: 09/10/2021 - 20:21 TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 Current Rate Ending Par Value Ending Fund Page 2 Book Value Beginning Book Value Adjusted Interest Earnings Accretion Amortization/ Earnings Adjusted Interest May 1, 2021 - May 31, 2021 Total Earnings City of La Quinta Annualized YieldCUSIPInvestment # Interest EarnedIssuer Realized Gainl/Loss Fund: General Fund 240,000.001127240,000.00 2.700NORPNT 550.36 0.00 550.362.700101240,000.00666613GV0 0.00 240,000.001134240,000.00 3.050UOFICU 621.70 0.00 621.703.050101240,000.0091435LAG2 0.00 245,000.001143245,000.00 3.100ALLGNC 645.05 0.00 645.053.100101245,000.0001748DBE5 0.00 245,000.001144245,000.00 3.150RCB 655.46 0.00 655.463.150101245,000.0074934YAH4 0.00 245,000.001147245,000.00 3.1501STNBA 655.46 0.00 655.463.150101245,000.0032110YLK9 0.00 245,000.001148245,000.00 3.000TRAD 624.25 0.00 624.253.000101245,000.0089269CBX9 0.00 245,000.001149245,000.00 3.000PCSB 624.25 0.00 624.253.000101245,000.0069324MAD7 0.00 240,000.001150240,000.00 3.100GECRUN 631.89 0.00 631.893.100101240,000.00369674AV8 0.00 249,000.001151249,000.00 3.250NWENGL 687.31 0.00 687.313.250101249,000.0006426KAN8 0.00 854,136.101153854,136.10 0.050CAMP 39.10 0.00 39.100.054101854,097.00SYS1153 0.00 245,000.001154245,000.00 3.350JEFF 697.07 0.00 697.073.350101245,000.00474067AQ8 0.00 248,000.001155248,000.00 3.300MARBUS 695.08 0.00 695.083.300101248,000.0057116ARV2 0.00 378,360.001157400,000.00 2.000MCRSFT 666.67 0.00 666.672.075101378,360.00594918BQ6 0.00 247,275.001158250,000.00 2.800FFCB 583.33 0.00 583.332.778101247,275.003133EJYL7 0.00 487,950.001159500,000.00 2.300P&G 958.33 0.00 958.332.312101487,950.00742718DY2 0.00 245,000.001160245,000.00 3.200MUNTRS 665.86 0.00 665.863.200101245,000.00625925AR3 0.00 245,000.001161245,000.00 3.350UBS 697.08 0.00 697.083.350101245,000.0090348JEJ5 0.00 248,000.001162248,000.00 3.400COMMBK 716.14 0.00 716.143.400101248,000.0020143PDV9 0.00 248,000.001163248,000.00 3.250MRRCK 684.55 0.00 684.553.250101248,000.0059013J4K2 0.00 248,000.001164248,000.00 3.550NMRCA 747.74 0.00 747.743.550101248,000.0067054NAN3 0.00 248,000.001166248,000.00 3.350REDRCK 705.61 0.00 705.613.350101248,000.0075701LAB3 0.00 245,000.001167245,000.00 3.200NEIGH 665.86 0.00 665.863.200101245,000.0064017AAQ7 0.00 245,000.001168245,000.00 3.1501STSRC 655.46 0.00 655.463.150101245,000.0033646CKP8 0.00 248,000.001169248,000.00 3.400MEDBA 716.14 0.00 716.143.400101248,000.0058404DCX7 0.00 245,000.001170245,000.00 3.400NLCOOP 707.48 0.00 707.483.400101245,000.00635573AL2 0.00 248,000.001171248,000.00 3.300MAINE 695.09 0.00 695.093.300101248,000.00560507AK1 0.00 248,000.001172248,000.00 3.350BARHAR 705.61 0.00 705.613.350101248,000.00066851WJ1 0.00 248,000.001173248,000.00 2.750MORTN 579.23 0.00 579.232.750101248,000.00619165JD6 0.00 248,000.001174248,000.00 3.000WELLS 631.89 0.00 631.893.000101248,000.00949763XY7 0.00 485,250.001175500,000.00 1.950COLGTE 812.50 0.00 812.501.971101485,250.0019416QEA4 0.00 498,550.001177500,000.00 2.500FHLB 1,041.67 0.00 1,041.672.460101498,550.003130AFW94 0.00 489,687.501178500,000.00 1.875USTR 794.05 0.00 794.051.909101489,687.509128282W9 0.00 248,000.001179248,000.00 2.8001STNBK 589.76 0.00 589.762.800101248,000.0032117BCX4 0.00 248,000.001180248,000.00 2.700VERUS 568.71 0.00 568.712.700101248,000.0092535LCD4 0.00 248,000.001181248,000.00 2.950NRTHWS 621.36 0.00 621.362.950101248,000.0066736ABP3 0.00 248,000.001184248,000.00 2.500CENTNX 526.57 0.00 526.572.500101248,000.00156634AK3 0.00 245,000.001185245,000.00 3.250JPMORG 676.27 0.00 676.273.250101245,000.0048128HXU7 0.00 Portfolio CITY CP Run Date: 09/10/2021 - 20:21 TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 Current Rate Ending Par Value Ending Fund Page 3 Book Value Beginning Book Value Adjusted Interest Earnings Accretion Amortization/ Earnings Adjusted Interest May 1, 2021 - May 31, 2021 Total Earnings City of La Quinta Annualized YieldCUSIPInvestment # Interest EarnedIssuer Realized Gainl/Loss Fund: General Fund 245,000.001186245,000.00 2.400IOWAST 499.40 0.00 499.402.400101245,000.0046256YAZ2 0.00 248,000.001187248,000.00 2.400TSCOLA 505.51 0.00 505.512.400101248,000.0087266AAA1 0.00 248,000.001188248,000.00 2.600MAINST 547.64 0.00 547.642.600101248,000.0056065GAG3 0.00 248,000.001189248,000.00 2.500CONGRS 526.58 0.00 526.582.500101248,000.0020726ABA5 0.00 496,650.001190500,000.00 2.350WALMRT 979.17 0.00 979.172.321101496,650.00931142DU4 0.00 496,650.001192500,000.00 1.750USTR 742.61 0.00 742.611.761101496,650.00912828SV3 0.00 0.0011930.00 1.375USTR 566.62 0.00 6,956.6217.147101493,610.00912828R77 6,390.00 245,000.001194245,000.00 2.500PITTS 520.21 0.00 520.212.500101245,000.00725404AB3 0.00 245,000.001195245,000.00 2.550PLAINS 530.61 0.00 530.612.550101245,000.0072651LCL6 0.00 248,000.001196248,000.00 2.600EVNSCU 547.64 0.00 547.642.600101248,000.00299547AQ2 0.00 248,000.001197248,000.00 2.400LEGCY 505.51 0.00 505.512.400101248,000.00524661CB9 0.00 499,500.001198500,000.00 1.875FFCB 781.25 0.00 781.251.842101499,500.003133EKQP4 0.00 248,000.001199248,000.00 2.400CTZNST 505.52 0.00 505.522.400101248,000.00176688CP2 0.00 248,000.001200248,000.00 2.300AMERCU 484.45 0.00 484.452.300101248,000.0003065AAL7 0.00 245,000.001201245,000.00 2.150STRLNG 447.38 0.00 447.382.150101245,000.0085916VDC6 0.00 248,000.001202248,000.00 2.250COMMW 473.92 0.00 473.922.250101248,000.0020416TAQ5 0.00 247,000.001203247,000.00 2.300REVER 482.49 0.00 482.492.300101247,000.00761402BY1 0.00 248,000.001205248,000.00 2.000AMRNTL 421.26 0.00 421.262.000101248,000.0002772JBD1 0.00 495,950.001206500,000.00 1.750FNMA 729.17 0.00 729.171.731101495,950.003135G0V75 0.00 248,000.001207248,000.00 1.950ABACUS 410.73 0.00 410.731.950101248,000.0000257TBD7 0.00 248,000.001208248,000.00 2.000LKSIDE 421.26 0.00 421.262.000101248,000.0051210SQU4 0.00 248,000.001209248,000.00 2.0001STSEC 421.26 0.00 421.262.000101248,000.0033625CCP2 0.00 248,000.001210248,000.00 2.000PEOPLE 421.26 0.00 421.262.000101248,000.00710571DS6 0.00 499,500.001212500,000.00 1.850FFCB 770.84 0.00 770.841.817101499,500.003133EKWV4 0.00 249,000.001213249,000.00 2.000PREFRD 422.96 0.00 422.962.000101249,000.00740367HP5 0.00 248,000.001214248,000.00 2.000UNTDCU 421.26 0.00 421.262.000101248,000.00910160AH3 0.00 248,000.001215248,000.00 2.000WSHFED 421.26 0.00 421.262.000101248,000.00938828BH2 0.00 249,000.001216249,000.00 1.9501STIER 412.38 0.00 412.381.950101249,000.0033766LAJ7 0.00 499,300.001217500,000.00 1.375USTR 582.31 0.00 582.311.373101499,300.00912828T26 0.00 244,000.001218244,000.00 1.950RAYJAM 404.10 0.00 404.101.950101244,000.0075472RAD3 0.00 245,000.001219245,000.00 1.900CITBNK 395.36 0.00 395.361.900101245,000.0012556LBA3 0.00 248,000.001220248,000.00 1.850CELTIC 389.67 0.00 389.671.850101248,000.0015118RRH2 0.00 249,000.001221249,000.00 1.8501STNBS 391.24 0.00 391.241.850101249,000.00334342CD2 0.00 248,000.001222248,000.00 1.8001STDQN 379.13 0.00 379.131.800101248,000.00336460CX6 0.00 499,400.001223500,000.00 1.600FFCB 666.67 0.00 666.671.572101499,400.003133EKZK5 0.00 498,750.001224500,000.00 1.600FFCB 666.66 0.00 666.661.574101498,750.003133EKP75 0.00 245,000.001225245,000.00 1.600LUANA 332.93 0.00 332.931.600101245,000.00549104JN8 0.00 Portfolio CITY CP Run Date: 09/10/2021 - 20:21 TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 Current Rate Ending Par Value Ending Fund Page 4 Book Value Beginning Book Value Adjusted Interest Earnings Accretion Amortization/ Earnings Adjusted Interest May 1, 2021 - May 31, 2021 Total Earnings City of La Quinta Annualized YieldCUSIPInvestment # Interest EarnedIssuer Realized Gainl/Loss Fund: General Fund 245,000.001226245,000.00 1.800NYCMBK 374.54 0.00 374.541.800101245,000.00649447TC3 0.00 248,000.001227248,000.00 1.700BNKWST 358.07 0.00 358.071.700101248,000.0006652CHB0 0.00 11,490,355.05122811,490,355.05BOTW 0.01 0.00 0.011019,456,806.96059731851 0.00 11,277,103.22123011,277,103.22PARS 0.00 0.00 0.0010111,227,866.79SYS1230 0.00 248,000.001231248,000.00 1.7001STSER 358.07 0.00 358.071.700101248,000.0033640VDD7 0.00 992,100.0012331,000,000.00 1.375FNMA 1,145.84 0.00 1,145.841.360101992,100.003135G0W33 0.00 996,900.0012341,000,000.00 1.600FFCB 1,333.33 0.00 1,333.331.575101996,900.003133EK4X1 0.00 248,000.001235248,000.00 1.700SAUKVL 358.07 0.00 358.071.700101248,000.00804375DL4 0.00 245,000.001236245,000.00 1.900MSPRIV 395.36 0.00 395.361.900101245,000.0061760A3B3 0.00 245,000.001237245,000.00 1.950MORGST 405.76 0.00 405.761.950101245,000.0061690UNX4 0.00 248,000.001238248,000.00 1.800LIVEOK 379.13 0.00 379.131.800101248,000.00538036GV0 0.00 248,000.001239248,000.00 1.900KERNCU 400.20 0.00 400.201.900101248,000.0049228XAK6 0.00 248,000.001240248,000.00 1.850SF FCU 389.67 0.00 389.671.850101248,000.0079772FAC0 0.00 989,687.5012411,000,000.00 1.500USTR 1,277.24 0.00 1,277.241.520101989,687.50912828YV6 0.00 998,600.0012421,000,000.00 1.700FFCB 1,416.66 0.00 1,416.661.670101998,600.003133ELEA8 0.00 248,000.001244248,000.00 1.900WFNBW 400.20 0.00 400.201.900101248,000.00949495AT2 0.00 999,000.0012461,000,000.00 1.430FFCB 1,191.67 0.00 1,191.671.404101999,000.003133ELNE0 0.00 999,217.3612471,000,000.00 1.400FFCB 1,166.67 0.00 1,166.671.375101999,217.363133EGWJ0 0.00 248,000.001248248,000.00 1.550FRDMFI 326.48 0.00 326.481.550101248,000.0035637RDC8 0.00 248,000.001249248,000.00 1.650UNTDCM 347.54 0.00 347.541.650101248,000.0090983WBT7 0.00 248,000.001250248,000.00 1.6501STNMI 347.54 0.00 347.541.650101248,000.0032114VBT3 0.00 245,000.001251245,000.00 1.650RLLSTN 343.33 0.00 343.331.650101245,000.0077579ADF0 0.00 248,000.001252248,000.00 1.650CITADL 347.54 0.00 347.541.650101248,000.0017286TAG0 0.00 245,000.001253245,000.00 1.600SYNOVS 332.93 0.00 332.931.600101245,000.0087164DRD4 0.00 248,000.001254248,000.00 1.600SERVIS 337.01 0.00 337.011.600101248,000.0081768PAF3 0.00 248,000.001255248,000.00 1.600AMERST 337.01 0.00 337.011.600101248,000.00029728BC5 0.00 248,000.001256248,000.00 1.600ACCSS 337.01 0.00 337.011.600101248,000.0000435JBH5 0.00 248,000.001257248,000.00 1.500SPRING 315.94 0.00 315.941.500101248,000.00849430BF9 0.00 248,000.001258248,000.00 1.650AXOS 347.54 0.00 347.541.650101248,000.0005465DAE8 0.00 245,000.001259245,000.00 1.200CADNCE 249.70 0.00 249.701.200101245,000.0012738RFX7 0.00 245,000.001260245,000.00 1.100TEXAS 228.89 0.00 228.891.100101245,000.00882213AB7 0.00 248,000.001261248,000.00 1.100SNTCLR 231.69 0.00 231.691.100101248,000.0006424KBC3 0.00 248,000.001262248,000.00 1.350TRIAD 284.35 0.00 284.351.350101248,000.0089579NCD3 0.00 248,000.001263248,000.00 1.150NRTHSR 242.22 0.00 242.221.150101248,000.0066704MEQ0 0.00 248,000.001264248,000.00 1.300BELLCO 273.82 0.00 273.821.300101248,000.0007833EAD9 0.00 248,000.001265248,000.00 1.150WESTMI 242.22 0.00 242.221.150101248,000.00954444BS3 0.00 248,000.001266248,000.00 1.400NCOLET 294.88 0.00 294.881.400101248,000.00654062JZ2 0.00 Portfolio CITY CP Run Date: 09/10/2021 - 20:21 TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 Current Rate Ending Par Value Ending Fund Page 5 Book Value Beginning Book Value Adjusted Interest Earnings Accretion Amortization/ Earnings Adjusted Interest May 1, 2021 - May 31, 2021 Total Earnings City of La Quinta Annualized YieldCUSIPInvestment # Interest EarnedIssuer Realized Gainl/Loss Fund: General Fund 248,000.001267248,000.00 1.400ALMABK 294.88 0.00 294.881.400101248,000.00020080BX4 0.00 248,000.001268248,000.00 1.250CMWBUS 263.29 0.00 263.291.250101248,000.002027506M2 0.00 245,000.001269245,000.00 1.300PACWST 270.51 0.00 270.511.300101245,000.0069506YRH4 0.00 248,000.001270248,000.00 1.250BELB&T 263.29 0.00 263.291.250101248,000.0008016PDQ9 0.00 245,000.001271245,000.00 1.600CAPONE 332.94 0.00 332.941.600101245,000.0014042TDD6 0.00 248,000.001272248,000.00 1.250THEJEF 263.28 0.00 263.281.250101248,000.00472382AQ3 0.00 249,000.001273249,000.00 1.2001STFDM 253.77 0.00 253.771.200101249,000.0032027BAL1 0.00 248,000.001274248,000.00 1.3501STMCG 284.35 0.00 284.351.350101248,000.0032112UDR9 0.00 248,000.001276248,000.00 1.250FLGSTR 263.29 0.00 263.291.250101248,000.0033847E3A3 0.00 245,000.001277245,000.00 1.000WSTRNS 208.08 0.00 208.081.000101245,000.0095960NKD8 0.00 248,000.001278248,000.00 1.0001STINT 210.63 0.00 210.631.000101248,000.0032056GDJ6 0.00 1,000,000.0012791,000,000.00 0.625FHLMC 520.83 0.00 520.830.6131011,000,000.003134GVYG7 0.00 499,850.001280500,000.00 0.500FFCB 208.33 0.00 208.330.491101499,850.003133ELH23 0.00 499,850.001281500,000.00 0.500FHLB 208.34 0.00 208.340.491101499,850.003130AJKW8 0.00 500,000.001282500,000.00 0.680FFCB 283.33 0.00 283.330.667101500,000.003133ELH80 0.00 300,000.001283300,000.00 0.680FHLB 170.00 0.00 170.000.667101300,000.003130AJRP6 0.00 248,000.001284248,000.00 0.600CHIPVA 126.38 0.00 126.380.600101248,000.00169894AS1 0.00 248,000.001285248,000.00 0.350AMR1ST 73.72 0.00 73.720.350101248,000.0002616AAH2 0.00 248,000.001286248,000.00 0.500STHRNB 105.32 0.00 105.320.500101248,000.0084223QAN7 0.00 248,000.001287248,000.00 0.500BKPRNC 105.32 0.00 105.320.500101248,000.00064520BG3 0.00 500,000.001288500,000.00 0.500FNMA 208.34 0.00 208.340.491101500,000.003135G05S8 0.00 1,000,000.0012891,000,000.00 0.560FNMA 466.67 0.00 466.670.5491011,000,000.003136G4N74 0.00 499,750.001290500,000.00 0.520FNMA 216.67 0.00 216.670.510101499,750.003136G4M75 0.00 499,250.001291500,000.00 0.420FNMA 175.00 0.00 175.000.413101499,250.003135G06E8 0.00 499,250.001292500,000.00 0.560FNMA 233.33 0.00 233.330.550101499,250.003135GA2Z3 0.00 3,056,596.7812933,056,596.78BNY 0.01 0.00 0.011013,254,568.53SYS1293 0.00 997,300.0012971,000,000.00 0.375FHLMC 312.50 0.00 312.500.369101997,300.003137EAEU9 0.00 497,400.001298500,000.00 0.375FHLB 156.25 0.00 156.250.370101497,400.003130AKFA9 0.00 500,000.001299500,000.00 0.600FNMA 250.00 0.00 250.000.589101500,000.003135GA7D7 0.00 500,000.001300500,000.00 0.400FNMA 166.67 0.00 166.670.392101500,000.003135GAAW1 0.00 500,000.001301500,000.00 0.550FHLMC 229.16 0.00 229.160.540101500,000.003134GXGZ1 0.00 500,000.001302500,000.00 0.510FHLB 212.50 0.00 212.500.500101500,000.003130AKMZ6 0.00 498,632.811303500,000.00 0.375USTR 160.56 0.00 160.560.379101498,632.8191282CBC4 0.00 500,000.001304500,000.00 0.550FHLB 229.16 0.00 229.160.540101500,000.003130AKN28 0.00 248,000.001305248,000.00 0.500LNDMRK 105.32 0.00 105.320.500101248,000.0051507LCC6 0.00 245,000.001306245,000.00 0.500EVRBA 104.04 0.00 104.040.500101245,000.0087270LDL4 0.00 495,999.501307500,000.00 0.375FHLMC 156.25 0.00 156.250.371101495,999.503137EAEX3 0.00 Portfolio CITY CP Run Date: 09/10/2021 - 20:21 TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 Current Rate Ending Par Value Ending Fund Page 6 Book Value Beginning Book Value Adjusted Interest Earnings Accretion Amortization/ Earnings Adjusted Interest May 1, 2021 - May 31, 2021 Total Earnings City of La Quinta Annualized YieldCUSIPInvestment # Interest EarnedIssuer Realized Gainl/Loss Fund: General Fund 497,300.001308500,000.00 0.500IFC 214.09 0.00 214.090.507101497,300.0045950VPS9 0.00 495,100.001309500,000.00 0.375USTR 160.57 0.00 160.570.382101495,100.0091282CBH3 0.00 983,940.0013101,000,000.00 0.375FHLMC 312.50 0.00 312.500.374101983,940.003137EAEX3 0.00 977,500.0013111,000,000.00 0.250USTR 210.60 0.00 210.600.254101977,500.0091282CAT8 0.00 500,000.001312500,000.00 0.500FHLB 208.33 0.00 208.330.491101500,000.003130ALV92 0.00 249,000.001313249,000.00 0.950GRNST 200.91 0.00 200.910.950101249,000.0039573LBC1 0.00 245,000.001314245,000.00 0.900TOYFSB 187.27 0.00 187.270.900101245,000.0089235MKY6 0.00 492,187.501315500,000.00 0.375USTR 159.65 0.00 159.650.382101492,187.5091282CAZ4 0.00 248,000.001316248,000.00 0.750CARTER 157.97 0.00 157.970.750101248,000.0014622LAA0 0.00 248,000.001317248,000.00 0.700FIDHMS 147.44 0.00 147.440.700101248,000.0031617CAV5 0.00 241,247.931318241,247.93DPME 0.00 0.00 0.00101217,583.21SYS1318 0.00 494,165.001319500,000.00 0.500USTR 27.17 0.00 27.170.5021010.0091282CBQ3 0.00 499,525.001320500,000.00 0.750USTR 40.99 0.00 40.990.7491010.0091282CBT7 0.00 156,737,918.75Subtotal 156,491,245.92 0.881 112,866.000.00106,476.00150,822,649.33 6,390.00 Fund: Fiscal Agent 1,422.1510581,422.15USBANK 0.07 0.00 0.070.0582311,422.08SYS1058 0.00 1,422.15Subtotal 1,422.15 0.058 0.070.000.071,422.08 0.00 Fund: Housing Authority : WSA and LQ 326,355.811062326,355.81LQPR 0.00 0.00 0.00241334,384.44SYS1062 0.00 326,355.81Subtotal 326,355.81 0.000.000.00334,384.44 0.00 Fund: SA Low/Mod Bond Fund 10,580,686.54111310,580,686.54 0.315LAIF 2,943.40 0.00 2,943.400.32824910,580,686.5425-33-005 0.00 10,580,686.54Subtotal 10,580,686.54 0.328 2,943.400.002,943.4010,580,686.54 0.00 167,646,383.25Total 167,399,710.42 0.843 115,809.470.00109,419.47161,739,142.39 6,390.00 Portfolio CITY CP Run Date: 09/10/2021 - 20:21 TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 Days to Maturity Page 1 Par Value Book Value Maturity Date Stated RateMarket Value June 30, 2021 Portfolio Details - Investments Average BalanceIssuer Portfolio Management City of La Quinta YTM 365TermCUSIPInvestment # Purchase Date Bank Accounts 1Bank of New York1293 5,000,000.00 5,000,000.0009/01/2020 5,000,000.00 1SYS1293 0.000 1Bank of the West1228 10,056,644.58 10,056,644.5808/20/2019 10,056,644.58 1059731851 0.000 1City Petty Cash1059 3,300.00 3,300.0007/01/2016 3,300.00 1SYS1059 0.000 1Dune Palms Mobile Estates1318 265,784.81 265,784.8103/09/2021 265,784.81 1SYS1318 0.000 1La Quinta Palms Realty1062 335,858.81 335,858.8107/01/2016 335,858.81 1SYS1062 0.000 1Stifel, Nicolaus & Company1183 0.00 0.0003/18/2019 0.00 1SYS1183 0.000 15,661,588.20 115,661,588.2015,661,588.2013,413,897.79Subtotal and Average 1 0.000 Local Agency Investment Fund-City 1Local Agency Inv Fund1055 66,929,948.66 66,929,948.66 0.26267,266,295.86 198-33-434 0.262 66,929,948.66 167,266,295.8666,929,948.6663,463,281.99Subtotal and Average 1 0.262 Local Agency Invstmnt Fund-Housing 1Local Agency Inv Fund1113 10,580,686.54 10,580,686.54 0.26210,662,970.55 125-33-005 0.262 10,580,686.54 110,662,970.5510,580,686.5410,580,686.54Subtotal and Average 1 0.262 Money Market/Mutual Funds 1Dreyfus12940.00 0.0009/24/2020 0.00 1X9USDDTP3 0.000 0.00 00.000.000.00Subtotal and Average 0 0.000 Money Market Accounts - CAMP 1California Asset Management Pr1153 13,854,440.98 13,854,440.98 0.05009/26/2018 13,854,440.98 1SYS1153 0.050 13,854,440.98 113,854,440.9813,854,440.987,354,146.26Subtotal and Average 1 0.050 Federal Agency Coupon Securities 62Federal Farm Credit Bank1105 1,000,000.00 992,200.00 09/01/20211.70011/09/2017 1,002,750.00 1,3923133EHWM1 1.913 796Federal Farm Credit Bank1158 250,000.00 247,275.00 09/05/20232.80010/15/2018 263,475.00 1,7863133EJYL7 3.041 529Federal Farm Credit Bank1198 500,000.00 499,500.00 12/12/20221.87506/20/2019 512,465.00 1,2713133EKQP4 1.905 1,121Federal Farm Credit Bank1212 500,000.00 499,500.00 07/26/20241.85008/02/2019 520,800.00 1,8203133EKWV4 1.871 774Federal Farm Credit Bank1223 500,000.00 499,400.00 08/14/20231.60009/12/2019 513,685.00 1,4323133EKZK5 1.632 1,174Federal Farm Credit Bank1224 500,000.00 498,750.00 09/17/20241.60009/17/2019 517,320.00 1,8273133EKP75 1.652 853Federal Farm Credit Bank1234 1,000,000.00 996,900.00 11/01/20231.60011/01/2019 1,029,200.00 1,4613133EK4X1 1.680 1,174Federal Farm Credit Bank1242 1,000,000.00 998,600.00 09/17/20241.70012/17/2019 1,037,740.00 1,7363133ELEA8 1.731 958Federal Farm Credit Bank1246 1,000,000.00 999,000.00 02/14/20241.43002/14/2020 1,026,940.00 1,4613133ELNE0 1.456 455Federal Farm Credit Bank1247 1,000,000.00 999,217.36 09/29/20221.40002/05/2020 1,015,800.00 9673133EGWJ0 1.430 Portfolio CITY CP Run Date: 09/10/2021 - 20:07 PM (PRF_PM2) 7.3.0 Report Ver. 7.3.6.1 Days to Maturity Page 2 Par Value Book Value Maturity Date Stated RateMarket Value June 30, 2021 Portfolio Details - Investments Average BalanceIssuer Portfolio Management City of La Quinta YTM 365TermCUSIPInvestment # Purchase Date Federal Agency Coupon Securities 1,439Federal Farm Credit Bank1280 500,000.00 499,850.00 06/09/20250.50006/09/2020 496,780.00 1,8263133ELH23 0.506 1,440Federal Farm Credit Bank1282 500,000.00 500,000.00 06/10/20250.68006/10/2020 498,965.00 1,8263133ELH80 0.680 957Federal Home Loan Bank1177 500,000.00 498,550.00 02/13/20242.50003/01/2019 528,180.00 1,8103130AFW94 2.563 1,443Federal Home Loan Bank1281 500,000.00 499,850.00 06/13/20250.50006/03/2020 496,200.00 1,8363130AJKW8 0.506 1,460Federal Home Loan Bank1283 300,000.00 300,000.00 06/30/20250.68006/30/2020 297,165.00 1,8263130AJRP6 0.680 1,625Federal Home Loan Bank1298 500,000.00 497,400.00 12/12/20250.37512/07/2020 491,465.00 1,8313130AKFA9 0.480 1,658Federal Home Loan Bank1302 500,000.00 500,000.00 01/14/20260.51001/14/2021 492,095.00 1,8263130AKMZ6 0.510 1,673Federal Home Loan Bank1304 500,000.00 500,000.00 01/29/20260.55001/29/2021 493,750.00 1,8263130AKN28 0.550 1,733Federal Home Loan Bank1312 500,000.00 500,000.00 03/30/20260.50003/30/2021 499,570.00 1,8263130ALV92 0.938 1,807Federal Home Loan Bank1324 1,000,000.00 993,420.00 06/12/20260.75006/17/2021 994,800.00 1,8213130AMFS6 0.885 1,426Federal Home Loan Mtg Corp1279 1,000,000.00 1,000,000.00 05/27/20250.62505/27/2020 996,450.00 1,8263134GVYG7 0.625 1,481Federal Home Loan Mtg Corp1297 1,000,000.00 997,300.00 07/21/20250.37512/07/2020 986,300.00 1,6873137EAEU9 0.434 1,643Federal Home Loan Mtg Corp1301 500,000.00 500,000.00 12/30/20250.55012/30/2020 493,074.50 1,8263134GXGZ1 0.550 1,545Federal Home Loan Mtg Corp1307 500,000.00 495,999.50 09/23/20250.37502/23/2021 492,370.00 1,6733137EAEX3 0.552 1,545Federal Home Loan Mtg Corp1310 1,000,000.00 983,940.00 09/23/20250.37503/30/2021 984,740.00 1,6383137EAEX3 0.740 1,097Federal National Mtg Assn1206 500,000.00 495,950.00 07/02/20241.75007/15/2019 519,860.00 1,8143135G0V75 1.922 432Federal National Mtg Assn1233 1,000,000.00 992,100.00 09/06/20221.37510/29/2019 1,014,380.00 1,0433135G0W33 1.659 1,505Federal National Mtg Assn1288 500,000.00 500,000.00 08/14/20250.50008/14/2020 495,120.00 1,8263135G05S8 0.500 1,512Federal National Mtg Assn1289 1,000,000.00 1,000,000.00 08/21/20250.56008/21/2020 992,970.00 1,8263136G4N74 0.560 1,509Federal National Mtg Assn1290 500,000.00 499,750.00 08/18/20250.52008/28/2020 495,625.00 1,8163136G4M75 0.530 1,236Federal National Mtg Assn1291 500,000.00 499,250.00 11/18/20240.42011/18/2020 497,370.00 1,4613135G06E8 0.458 1,600Federal National Mtg Assn1292 500,000.00 499,250.00 11/17/20250.56011/17/2020 494,430.00 1,8263135GA2Z3 0.590 1,636Federal National Mtg Assn1299 500,000.00 500,000.00 12/23/20250.60012/23/2020 494,690.00 1,8263135GA7D7 0.600 1,278Federal National Mtg Assn1300 500,000.00 500,000.00 12/30/20240.40012/30/2020 497,125.00 1,4613135GAAW1 0.400 21,982,951.86 1,63722,183,649.5022,050,000.0021,453,127.86Subtotal and Average 1,209 1.089 Treasury Coupon Securities 122U.S. Treasury1070 2,000,000.00 1,942,800.00 10/31/20211.25003/27/2017 2,007,920.00 1,679912828T67 1.903 456U.S. Treasury1178 500,000.00 489,687.50 09/30/20221.87503/01/2019 510,800.00 1,3099128282W9 2.480 318U.S. Treasury1192 500,000.00 496,650.00 05/15/20221.75005/31/2019 507,225.00 1,080912828SV3 1.984 821U.S. Treasury1217 500,000.00 499,300.00 09/30/20231.37508/21/2019 512,050.00 1,501912828T26 1.410 1,248U.S. Treasury1241 1,000,000.00 989,687.50 11/30/20241.50012/16/2019 1,031,950.00 1,811912828YV6 1.718 1,644U.S. Treasury1303 500,000.00 498,632.81 12/31/20250.37501/07/2021 490,725.00 1,81991282CBC4 0.431 1,675U.S. Treasury1309 500,000.00 495,100.00 01/31/20260.37502/23/2021 490,175.00 1,80391282CBH3 0.577 1,583U.S. Treasury1311 1,000,000.00 977,500.00 10/31/20250.25003/30/2021 978,090.00 1,67691282CAT8 0.750 1,613U.S. Treasury1315 500,000.00 492,187.50 11/30/20250.37504/22/2021 491,190.00 1,68391282CAZ4 0.720 Portfolio CITY CP Run Date: 09/10/2021 - 20:07 PM (PRF_PM2) 7.3.0 Days to Maturity Page 3 Par Value Book Value Maturity Date Stated RateMarket Value June 30, 2021 Portfolio Details - Investments Average BalanceIssuer Portfolio Management City of La Quinta YTM 365TermCUSIPInvestment # Purchase Date Treasury Coupon Securities 1,703U.S. Treasury1319 500,000.00 494,165.00 02/28/20260.50005/28/2021 492,635.00 1,73791282CBQ3 0.750 1,734U.S. Treasury1320 500,000.00 499,525.00 03/31/20260.75005/28/2021 497,990.00 1,76891282CBT7 0.770 1,795U.S. Treasury1321 1,000,000.00 997,060.00 05/31/20260.75006/01/2021 994,770.00 1,82591282CCF6 0.810 1,734U.S. Treasury1322 500,000.00 498,450.00 03/31/20260.75006/17/2021 497,990.00 1,74891282CBT7 0.816 1,795U.S. Treasury1323 500,000.00 497,095.00 05/31/20260.75006/17/2021 497,385.00 1,80991282CCF6 0.870 9,867,840.31 1,68010,000,895.0010,000,000.0014,170,216.31Subtotal and Average 1,166 1.246 Certificate of Deposits 1,156First State Bk DeQueen1222 248,000.00 248,000.00 08/30/20241.80008/30/2019 257,478.57 1,827336460CX6 1.802 1,398First Freedom Bank1273 249,000.00 249,000.00 04/29/20251.20004/29/2020 253,540.41 1,82632027BAL1 1.201 1,149FirsTier Bank1216 249,000.00 249,000.00 08/23/20241.95008/23/2019 259,786.17 1,82733766LAJ7 1.952 1,4111st Internet Bank1278 248,000.00 248,000.00 05/12/20251.00005/11/2020 250,472.64 1,82732056GDJ6 0.985 1,397First Natl Bk McGregor1274 248,000.00 248,000.00 04/28/20251.35004/28/2020 253,943.03 1,82632112UDR9 1.351 749First National Bank of America1147 245,000.00 245,000.00 07/20/20233.15007/20/2018 259,363.34 1,82632110YLK9 3.152 673First National Bank1179 248,000.00 248,000.00 05/05/20232.80003/05/2019 259,512.12 1,52232117BCX4 2.802 1,156First Natl Bk of Syracuse1221 249,000.00 249,000.00 08/30/20241.85008/30/2019 258,913.00 1,827334342CD2 1.852 1,324First National Bank Michigan1250 248,000.00 248,000.00 02/14/20251.65002/14/2020 256,668.15 1,82732114VBT3 1.652 1,125First Security Bank of WA1209 248,000.00 248,000.00 07/30/20242.00007/30/2019 258,904.96 1,82733625CCP2 2.002 1,049First Service Bank1231 248,000.00 248,000.00 05/15/20241.70011/15/2019 256,439.84 1,64333640VDD7 1.701 139First Source Bank1168 245,000.00 245,000.00 11/17/20213.15012/17/2018 247,885.13 1,06633646CKP8 3.153 214Third Federal Savings and Loan1112 245,000.00 245,000.00 01/31/20222.50001/30/2018 248,410.28 1,46288413QBY3 2.502 1,121Abacus Federal Savings1207 248,000.00 248,000.00 07/26/20241.95007/26/2019 258,624.56 1,82700257TBD7 1.952 1,351Access Bank1256 248,000.00 248,000.00 03/13/20251.60003/13/2020 256,214.65 1,82600435JBH5 1.601 347Allegiance Bank1143 245,000.00 245,000.00 06/13/20223.10006/13/2018 251,799.90 1,46101748DBE5 3.102 469Alliance Credit Union1095 245,000.00 245,000.00 10/13/20222.25010/13/2017 251,330.26 1,82601859BAA3 2.251 1,366Alma Bank1267 248,000.00 248,000.00 03/28/20251.40003/30/2020 254,446.74 1,824020080BX4 1.399 362America's Credit Union1200 248,000.00 248,000.00 06/28/20222.30006/28/2019 253,185.03 1,09603065AAL7 2.302 1,331American State1255 248,000.00 248,000.00 02/21/20251.60002/21/2020 256,260.49 1,827029728BC5 1.602 424American Express Fed Savings B1096 240,000.00 240,000.00 08/29/20222.40008/29/2017 246,069.75 1,82602587CFU9 2.402 725American First CU1285 248,000.00 248,000.00 06/26/20230.35006/26/2020 248,149.53 1,09502616AAH2 0.350 748American National Bank1205 248,000.00 248,000.00 07/19/20232.00007/19/2019 256,607.05 1,46102772JBD1 2.001 629Aneca Federal Credit Union1119 245,000.00 245,000.00 03/22/20232.80003/22/2018 255,681.83 1,826034577AH9 2.802 1,364Axos Bank1258 248,000.00 248,000.00 03/26/20251.65003/26/2020 256,756.39 1,82605465DAE8 1.651 481Barclays Bank1097 240,000.00 240,000.00 10/25/20222.30010/25/2017 246,519.42 1,82606740KLJ4 2.291 911Bar Harbor Bank and Trust1172 248,000.00 248,000.00 12/29/20233.35012/31/2018 266,274.95 1,824066851WJ1 3.352 1,020Belmont Bank and Trust1270 248,000.00 248,000.00 04/16/20241.25004/16/2020 253,208.59 1,46108016PDQ9 1.251 Portfolio CITY CP Run Date: 09/10/2021 - 20:07 PM (PRF_PM2) 7.3.0 Days to Maturity Page 4 Par Value Book Value Maturity Date Stated RateMarket Value June 30, 2021 Portfolio Details - Investments Average BalanceIssuer Portfolio Management City of La Quinta YTM 365TermCUSIPInvestment # Purchase Date Certificate of Deposits 272Bellco Credit Union1264 248,000.00 248,000.00 03/30/20221.30003/31/2020 250,104.75 72907833EAD9 1.300 144Belmont Savings Bank1102 245,000.00 245,000.00 11/22/20212.10011/21/2017 246,953.30 1,462080515CD9 2.101 1,278Bank Princeton1287 248,000.00 248,000.00 12/30/20240.50006/30/2020 246,511.57 1,644064520BG3 0.500 238BMW Bank1067 240,000.00 240,000.00 02/24/20222.20002/24/2017 243,258.40 1,82605580AGK4 2.201 1,184BankWest Inc1227 248,000.00 248,000.00 09/27/20241.70009/27/2019 256,897.56 1,82706652CHB0 1.702 273Cadence Bank, NA1259 245,000.00 245,000.00 03/31/20221.20003/31/2020 246,858.39 73012738RFX7 1.200 1,377Capital One USA FDIC339541271 245,000.00 245,000.00 04/08/20251.60004/08/2020 253,086.42 1,82614042TDD6 1.601 1,761Carter FCU1316 248,000.00 248,000.00 04/27/20260.75004/27/2021 246,183.96 1,82614622LAA0 0.750 1,156Celtic Bank1220 248,000.00 248,000.00 08/30/20241.85008/30/2019 257,873.19 1,82715118RRH2 1.852 1,063Century Next Bank1184 248,000.00 248,000.00 05/29/20242.50005/29/2019 262,368.90 1,827156634AK3 2.503 1,454Chippewa Valley Bk1284 248,000.00 248,000.00 06/24/20250.60006/24/2020 246,421.13 1,826169894AS1 0.600 1,337Citadel FCU1252 248,000.00 248,000.00 02/27/20251.65002/27/2020 256,752.14 1,82717286TAG0 1.652 418CIT Bank NA1219 245,000.00 245,000.00 08/23/20221.90008/23/2019 249,686.21 1,09612556LBA3 1.902 649Citibank NA1123 245,000.00 245,000.00 04/11/20232.90004/11/2018 256,433.60 1,82617312QJ26 2.902 1,369Commonwealth Business Bk1268 248,000.00 248,000.00 03/31/20251.25003/31/2020 252,725.87 1,8262027506M2 1.251 13Central State Bank1085 240,000.00 240,000.00 07/14/20211.85007/14/2017 240,166.12 1,46115523RBJ4 1.851 867Commercial Bank1162 248,000.00 248,000.00 11/15/20233.40011/15/2018 265,818.54 1,82620143PDV9 3.402 1,093Communitywide FCU1202 248,000.00 248,000.00 06/28/20242.25006/28/2019 260,748.56 1,82720416TAQ5 2.253 666Congressional Bank1189 248,000.00 248,000.00 04/28/20232.50004/30/2019 258,051.36 1,45920726ABA5 2.502 505CrossFirst Bank1106 245,000.00 245,000.00 11/18/20222.20011/20/2017 251,622.35 1,82422766ACB9 2.201 1,086Citizens State Bank1199 248,000.00 248,000.00 06/21/20242.40006/21/2019 261,781.44 1,827176688CP2 2.403 215Discover Bank Greenwood DE CF1066 240,000.00 240,000.00 02/01/20222.25002/01/2017 243,016.96 1,8262546722U1 2.251 666EnerBank USA1125 240,000.00 240,000.00 04/28/20232.95004/30/2018 251,722.20 1,82429278TAY6 2.952 515Enterprise Bank, NA1107 245,000.00 245,000.00 11/28/20222.15011/28/2017 251,577.76 1,82629367QCP1 2.151 1,077Evansville Teachers Credit FCU1196 248,000.00 248,000.00 06/12/20242.60006/12/2019 263,141.13 1,827299547AQ2 2.603 1,687TIAA FKA EverBank1306 245,000.00 245,000.00 02/12/20260.50002/12/2021 240,787.75 1,82687270LDL4 0.500 302Farmers Insurance Group FCU1126 240,000.00 240,000.00 04/29/20222.80004/30/2018 245,287.99 1,46030960QAG2 2.802 1,764Fidelity Homestead1317 248,000.00 248,000.00 04/30/20260.70004/30/2021 245,420.93 1,82631617CAV5 0.711 1,399Flagstar1276248,000.00 248,000.00 04/30/20251.25004/30/2020 252,819.36 1,82633847E3A3 1.251 1,324Freedom Financial1248 248,000.00 248,000.00 02/14/20251.55002/14/2020 255,767.09 1,82735637RDC8 1.552 46General Electric Credit Union1150 240,000.00 240,000.00 08/16/20213.10008/15/2018 240,949.32 1,097369674AV8 3.100 299Goldman Sachs1078 240,000.00 240,000.00 04/26/20222.40004/26/2017 244,434.32 1,82638148PJK4 2.401 1,750Greenstate FCU1313 249,000.00 249,000.00 04/16/20260.95004/16/2021 249,556.66 1,82639573LBC1 0.951 1,057Iowa State Bank1186 245,000.00 245,000.00 05/23/20242.40005/23/2019 258,385.79 1,82746256YAZ2 2.403 840Jefferson Financial CU1154 245,000.00 245,000.00 10/19/20233.35010/19/2018 261,870.58 1,826474067AQ8 3.352 1,050JP Morgan Chase1185 245,000.00 245,000.00 05/16/20243.25005/16/2019 264,336.56 1,82748128HXU7 3.254 Portfolio CITY CP Run Date: 09/10/2021 - 20:07 PM (PRF_PM2) 7.3.0 Days to Maturity Page 5 Par Value Book Value Maturity Date Stated RateMarket Value June 30, 2021 Portfolio Details - Investments Average BalanceIssuer Portfolio Management City of La Quinta YTM 365TermCUSIPInvestment # Purchase Date Certificate of Deposits 320Kansas State Bank1101 245,000.00 245,000.00 05/17/20222.10011/17/2017 249,142.24 1,64250116CBE8 2.099 547Kern FCU1239 248,000.00 248,000.00 12/30/20221.90012/30/2019 254,079.05 1,09649228XAK6 1.902 546Knoxville TVA Credit Union1110 245,000.00 245,000.00 12/29/20222.40012/29/2017 252,874.30 1,826499724AB8 2.401 1,084Legacy Bank1197 248,000.00 248,000.00 06/19/20242.40006/19/2019 261,756.29 1,827524661CB9 2.403 1,062Live Oak Bank1238 248,000.00 248,000.00 05/28/20241.80011/27/2019 257,270.04 1,644538036GV0 1.802 942Lakeside Bank1208 248,000.00 248,000.00 01/29/20242.00007/30/2019 258,041.10 1,64451210SQU4 2.003 1,666Landmark Community Bank1305 248,000.00 248,000.00 01/22/20260.50001/22/2021 243,937.34 1,82651507LCC6 0.500 260Luana Savings Bank1225 245,000.00 245,000.00 03/18/20221.60009/18/2019 247,542.52 912549104JN8 1.599 242Maine Savings FCU1171 248,000.00 248,000.00 02/28/20223.30012/28/2018 253,265.02 1,158560507AK1 3.306 1,030Main Street Bank1188 248,000.00 248,000.00 04/26/20242.60004/26/2019 262,776.66 1,82756065GAG3 2.603 838Marlin Business Bank1155 248,000.00 248,000.00 10/17/20233.30010/17/2018 264,763.99 1,82657116ARV2 3.302 524Medallion Bank1169 248,000.00 248,000.00 12/07/20223.40012/07/2018 259,259.65 1,46158404DCX7 3.402 1,238Morgan Stanley Bank1237 245,000.00 245,000.00 11/20/20241.95011/20/2019 255,949.53 1,82761690UNX4 1.952 719Morton Community1173 248,000.00 248,000.00 06/20/20232.75003/20/2019 260,012.67 1,553619165JD6 2.753 484Merrick Bank1163 248,000.00 248,000.00 10/28/20223.25010/30/2018 257,950.91 1,45959013J4K2 3.252 1,238Morgan Stanley Private Bk, NA1236 245,000.00 245,000.00 11/20/20241.90011/20/2019 255,533.18 1,82761760A3B3 1.902 495Mountain America Federal CU1099 245,000.00 245,000.00 11/08/20222.30011/08/2017 251,828.60 1,82662384RAC0 2.301 838Municipal Trust and Savings1160 245,000.00 245,000.00 10/17/20233.20010/17/2018 260,992.87 1,826625925AR3 3.202 1,369Nicolet Natl Bank1266 248,000.00 248,000.00 03/31/20251.40003/31/2020 254,121.30 1,826654062JZ2 1.401 173Neighbors FCU1167 245,000.00 245,000.00 12/21/20213.20012/21/2018 248,632.98 1,09664017AAQ7 3.203 903National Cooperative Bank, N.A1170 245,000.00 245,000.00 12/21/20233.40012/21/2018 263,185.81 1,826635573AL2 3.402 880Numerica Credit Union1164 248,000.00 248,000.00 11/28/20233.55011/28/2018 266,989.83 1,82667054NAN3 3.552 117Northpointe Bank1127 240,000.00 240,000.00 10/26/20212.70004/26/2018 242,044.91 1,279666613GV0 2.703 638Northstar Bank1263 248,000.00 248,000.00 03/31/20231.15003/31/2020 251,673.77 1,09566704MEQ0 1.150 957Northwest Bank1181 248,000.00 248,000.00 02/13/20242.95002/13/2019 264,295.62 1,82666736ABP3 2.951 760Bank of New England1151 249,000.00 249,000.00 07/31/20233.25007/31/2018 264,119.27 1,82606426KAN8 3.252 88New York Community Bank1226 245,000.00 245,000.00 09/27/20211.80009/27/2019 246,035.25 731649447TC3 1.802 202The Ohio Valley Bank1089 240,000.00 240,000.00 01/19/20221.90007/19/2017 242,380.78 1,645677721CN0 1.903 1,020Pacific Western Bank1269 245,000.00 245,000.00 04/16/20241.30004/16/2020 250,483.98 1,46169506YRH4 1.301 342PCSB Bank1149 245,000.00 245,000.00 06/08/20223.00006/08/2018 251,472.50 1,46169324MAD7 3.002 1,126People's Bank1210 248,000.00 248,000.00 07/31/20242.00007/31/2019 258,773.00 1,827710571DS6 2.002 706Pittsfield Cooperative Bank1194 245,000.00 245,000.00 06/07/20232.50006/07/2019 255,447.48 1,461725404AB3 2.502 1,072Plains Commerce Bank1195 245,000.00 245,000.00 06/07/20242.55006/07/2019 259,509.97 1,82772651LCL6 2.553 1,142Preferred Bank1213 249,000.00 249,000.00 08/16/20242.00008/16/2019 260,112.68 1,827740367HP5 2.002 783Raymond James Bank1218 244,000.00 244,000.00 08/23/20231.95008/23/2019 252,483.35 1,46175472RAD3 1.951 719RCB Bank1144 245,000.00 245,000.00 06/20/20233.15006/20/2018 258,820.83 1,82674934YAH4 3.152 Portfolio CITY CP Run Date: 09/10/2021 - 20:07 PM (PRF_PM2) 7.3.0 Days to Maturity Page 6 Par Value Book Value Maturity Date Stated RateMarket Value June 30, 2021 Portfolio Details - Investments Average BalanceIssuer Portfolio Management City of La Quinta YTM 365TermCUSIPInvestment # Purchase Date Certificate of Deposits 524Red Rocks Credit Union1166 248,000.00 248,000.00 12/07/20223.35012/07/2018 259,079.20 1,46175701LAB3 3.352 1,093Revere Bank1203 247,000.00 247,000.00 06/28/20242.30006/28/2019 260,054.37 1,827761402BY1 2.303 956Rollstone B&T1251 245,000.00 245,000.00 02/12/20241.65002/12/2020 252,660.76 1,46177579ADF0 1.651 355Sallie Mae Bank Salt Lake CIty1083 240,000.00 240,000.00 06/21/20222.35006/21/2017 245,037.18 1,826795450A70 2.351 1,225Sauk Valley B&T Co1235 248,000.00 248,000.00 11/07/20241.70011/07/2019 256,895.80 1,827804375DL4 1.702 600Servisfirst Bank1254 248,000.00 248,000.00 02/21/20231.60002/21/2020 253,397.38 1,09681768PAF3 1.601 547San Francisco FCU1240 248,000.00 248,000.00 12/30/20221.85012/30/2019 253,890.73 1,09679772FAC0 1.852 273Bank of Santa Clarita1261 248,000.00 248,000.00 03/31/20221.10003/31/2020 249,693.58 73006424KBC3 1.100 1,358Spring Bank1257 248,000.00 248,000.00 03/20/20251.50003/20/2020 255,333.05 1,826849430BF9 1.501 1,212Southern Bancorp Bk1286 248,000.00 248,000.00 10/25/20240.50006/26/2020 247,032.66 1,58284223QAN7 0.500 424Sterling Bank1201 245,000.00 245,000.00 08/29/20222.15006/28/2019 250,474.70 1,15885916VDC6 2.153 336Synchrony Bank Retail1080 240,000.00 240,000.00 06/02/20222.40006/02/2017 244,880.62 1,82687164XQV1 2.401 343Synovus Bank1253 245,000.00 245,000.00 06/09/20221.60003/09/2020 248,215.97 82287164DRD4 1.602 1,001Texas Bank Financial1260 245,000.00 245,000.00 03/28/20241.10003/31/2020 249,166.75 1,458882213AB7 1.101 1,019The Jefferson Bank1272 248,000.00 248,000.00 04/15/20241.25004/15/2020 253,203.52 1,461472382AQ3 1.251 1,756Toyota Financial Savings Bank1314 245,000.00 245,000.00 04/22/20260.90004/22/2021 244,963.78 1,82689235MKY6 0.900 403Traditions Bank1148 245,000.00 245,000.00 08/08/20223.00006/08/2018 252,541.19 1,52289269CBX9 3.002 820Triad Bank1262 248,000.00 248,000.00 09/29/20231.35003/30/2020 253,541.27 1,27889579NCD3 1.352 144TNB Bank1187 248,000.00 248,000.00 11/22/20212.40005/22/2019 250,276.80 91587266AAA1 2.407 838UBS Bank USA1161 245,000.00 245,000.00 10/17/20233.35010/17/2018 261,845.36 1,82690348JEJ5 3.352 1,317United Community1249 248,000.00 248,000.00 02/07/20251.65002/07/2020 256,622.94 1,82790983WBT7 1.652 174United Credit Union1214 248,000.00 248,000.00 12/22/20212.00008/22/2019 250,253.55 853910160AH3 2.003 683University of Iowa Comm. CU1134 240,000.00 240,000.00 05/15/20233.05005/14/2018 252,442.02 1,82791435LAG2 3.052 607Verus Bank of Commerce1180 248,000.00 248,000.00 02/28/20232.70002/28/2019 258,055.44 1,46192535LCD4 2.700 971Wells Fargo1174 248,000.00 248,000.00 02/27/20243.00002/27/2019 264,864.93 1,826949763XY7 3.001 638West Michigan Cmnty Bk1265 248,000.00 248,000.00 03/31/20231.15003/31/2020 251,673.77 1,095954444BS3 1.150 578Wells Fargo Natl Bank West1244 248,000.00 248,000.00 01/30/20231.90001/29/2020 254,393.92 1,097949495AT2 1.900 1,149Washington Federal1215 248,000.00 248,000.00 08/23/20242.00008/23/2019 259,135.22 1,827938828BH2 2.002 1,412Western State Bank1277 245,000.00 245,000.00 05/13/20251.00005/13/2020 247,439.89 1,82695960NKD8 1.001 31,761,000.00 1,60532,746,450.5631,761,000.0031,809,000.00Subtotal and Average 837 2.088 Corporate Notes 34Apple Inc1079 500,000.00 493,050.00 08/04/20211.55006/12/2017 500,040.00 1,514037833CC2 1.900 580Colgate-Palmolive1175 500,000.00 485,250.00 02/01/20231.95003/04/2019 513,570.00 1,43019416QEA4 2.751 1,701International Finance Corp.1308 500,000.00 497,300.00 02/26/20260.50002/26/2021 493,505.00 1,82645950VPS9 0.610 768Microsoft Corporation1157 400,000.00 378,360.00 08/08/20232.00010/15/2018 412,944.00 1,758594918BQ6 3.222 Portfolio CITY CP Run Date: 09/10/2021 - 20:07 PM (PRF_PM2) 7.3.0 Days to Maturity Page 7 Par Value Book Value Maturity Date Stated RateMarket Value June 30, 2021 Portfolio Details - Investments Average BalanceIssuer Portfolio Management City of La Quinta YTM 365TermCUSIPInvestment # Purchase Date Corporate Notes 220Proctor and Gamble1159 500,000.00 487,950.00 02/06/20222.30010/15/2018 506,385.00 1,210742718DY2 3.071 532Wal-Mart Stores, Inc1190 500,000.00 496,650.00 12/15/20222.35004/16/2019 514,540.00 1,339931142DU4 2.799 2,838,560.00 1,5042,940,984.002,900,000.002,838,560.00Subtotal and Average 636 2.354 Money Market with Fiscal Agent 1US Bank1058 1,422.16 1,422.1607/01/2016 1,422.16 1SYS1058 0.000 1,422.16 11,422.161,422.161,422.15Subtotal and Average 1 0.000 CERBT - OPEB Trust 1CalPERS CERBT Plan1114 2,050,951.37 2,050,951.3707/01/2020 2,050,951.37 1SYS1114 0.000 2,050,951.37 12,050,951.372,050,951.371,938,121.69Subtotal and Average 1 0.000 PARS Pension Trust 1Pblc Agncy Rtrmnt Serv1230 11,381,922.40 11,381,922.4007/01/2020 11,381,922.40 1SYS1230 0.000 11,381,922.40 111,381,922.4011,381,922.4011,280,597.19Subtotal and Average 1 0.000 577178,303,057.79 187,171,960.31 356 0.697188,751,570.58 186,911,312.48Total and Average Portfolio CITY CP Run Date: 09/10/2021 - 20:07 PM (PRF_PM2) 7.3.0 City of La Quinta Total Earnings City of La Quinta - Sorted by Fund - Fund June 1, 2021 - June 30, 2021 Current Rate Ending Par Value Ending Fund Book Value Beginning Book Value Adjusted Interest Earnings Accretion Amortization/ Earnings Adjusted InterestAnnualized YieldCUSIPInvestment # Interest EarnedIssuer Realized Gainl/Loss Fund: General Fund 0.0010450.00 1.125USTR 4,506.22 0.00 4,506.221.1341015,000,000.00912828S27 0.00 66,929,948.66105566,929,948.66 0.262LAIF 17,104.29 0.00 17,104.290.35310158,929,948.6698-33-434 0.00 0.0010570.00WELLS 0.01 0.00 0.011010.004159282482 0.00 3,300.0010593,300.00CITYPC 0.00 0.00 0.001013,300.00SYS1059 0.00 240,000.001066240,000.00 2.250DISCOV 443.84 0.00 443.842.250101240,000.002546722U1 0.00 240,000.001067240,000.00 2.200BMW 433.97 0.00 433.972.200101240,000.0005580AGK4 0.00 1,942,800.0010702,000,000.00 1.250USTR 2,038.05 0.00 2,038.051.2761011,942,800.00912828T67 0.00 240,000.001078240,000.00 2.400GLDMAN 473.42 0.00 473.422.400101240,000.0038148PJK4 0.00 493,050.001079500,000.00 1.550APPL 645.83 0.00 645.831.594101493,050.00037833CC2 0.00 240,000.001080240,000.00 2.400SYNCHR 473.42 0.00 473.422.400101240,000.0087164XQV1 0.00 0.0010820.00 2.250CAP1NA 88.77 0.00 88.772.250101240,000.0014042RGD7 0.00 240,000.001083240,000.00 2.350SALMAE 463.56 0.00 463.562.350101240,000.00795450A70 0.00 240,000.001085240,000.00 1.850CNTRL 364.93 0.00 364.931.850101240,000.0015523RBJ4 0.00 240,000.001089240,000.00 1.900OHVAL 374.79 0.00 374.791.900101240,000.00677721CN0 0.00 245,000.001095245,000.00 2.250ALLIAN 453.09 0.00 453.092.250101245,000.0001859BAA3 0.00 240,000.001096240,000.00 2.400AMFSB 473.42 0.00 473.422.400101240,000.0002587CFU9 0.00 240,000.001097240,000.00 2.300BARCLY 453.70 0.00 453.702.300101240,000.0006740KLJ4 0.00 245,000.001099245,000.00 2.300MTNAMR 463.15 0.00 463.152.300101245,000.0062384RAC0 0.00 245,000.001101245,000.00 2.100KANSAS 422.88 0.00 422.882.100101245,000.0050116CBE8 0.00 245,000.001102245,000.00 2.100BELMNT 422.87 0.00 422.872.100101245,000.00080515CD9 0.00 992,200.0011051,000,000.00 1.700FFCB 1,416.67 0.00 1,416.671.737101992,200.003133EHWM1 0.00 245,000.001106245,000.00 2.200CRS1ST 443.01 0.00 443.012.200101245,000.0022766ACB9 0.00 245,000.001107245,000.00 2.150ENTRPR 432.95 0.00 432.952.150101245,000.0029367QCP1 0.00 245,000.001110245,000.00 2.400KNOX 483.29 0.00 483.292.400101245,000.00499724AB8 0.00 245,000.001112245,000.00 2.5003RD 503.43 0.00 503.432.500101245,000.0088413QBY3 0.00 2,050,951.3711142,050,951.37CALPRS 0.00 0.00 0.001011,934,231.01SYS1114 0.00 245,000.001119245,000.00 2.800ANECA 563.84 0.00 563.842.800101245,000.00034577AH9 0.00 245,000.001123245,000.00 2.900CITINA 583.97 0.00 583.972.900101245,000.0017312QJ26 0.00 240,000.001125240,000.00 2.950ENER 581.92 0.00 581.922.950101240,000.0029278TAY6 0.00 240,000.001126240,000.00 2.800FARMIG 552.33 0.00 552.332.800101240,000.0030960QAG2 0.00 Portfolio CITY CP Run Date: 09/10/2021 - 20:23 TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 Current Rate Ending Par Value Ending Fund Page 2 Book Value Beginning Book Value Adjusted Interest Earnings Accretion Amortization/ Earnings Adjusted Interest June 1, 2021 - June 30, 2021 Total Earnings City of La Quinta Annualized YieldCUSIPInvestment # Interest EarnedIssuer Realized Gainl/Loss Fund: General Fund 240,000.001127240,000.00 2.700NORPNT 532.60 0.00 532.602.700101240,000.00666613GV0 0.00 240,000.001134240,000.00 3.050UOFICU 601.64 0.00 601.643.050101240,000.0091435LAG2 0.00 245,000.001143245,000.00 3.100ALLGNC 624.25 0.00 624.253.100101245,000.0001748DBE5 0.00 245,000.001144245,000.00 3.150RCB 634.32 0.00 634.323.150101245,000.0074934YAH4 0.00 245,000.001147245,000.00 3.1501STNBA 634.32 0.00 634.323.150101245,000.0032110YLK9 0.00 245,000.001148245,000.00 3.000TRAD 604.11 0.00 604.113.000101245,000.0089269CBX9 0.00 245,000.001149245,000.00 3.000PCSB 604.11 0.00 604.113.000101245,000.0069324MAD7 0.00 240,000.001150240,000.00 3.100GECRUN 611.51 0.00 611.513.100101240,000.00369674AV8 0.00 249,000.001151249,000.00 3.250NWENGL 665.14 0.00 665.143.250101249,000.0006426KAN8 0.00 13,854,440.98115313,854,440.98 0.050CAMP 304.88 0.00 304.880.434101854,136.10SYS1153 0.00 245,000.001154245,000.00 3.350JEFF 674.59 0.00 674.593.350101245,000.00474067AQ8 0.00 248,000.001155248,000.00 3.300MARBUS 672.66 0.00 672.663.300101248,000.0057116ARV2 0.00 378,360.001157400,000.00 2.000MCRSFT 666.67 0.00 666.672.144101378,360.00594918BQ6 0.00 247,275.001158250,000.00 2.800FFCB 583.34 0.00 583.342.870101247,275.003133EJYL7 0.00 487,950.001159500,000.00 2.300P&G 958.33 0.00 958.332.390101487,950.00742718DY2 0.00 245,000.001160245,000.00 3.200MUNTRS 644.38 0.00 644.383.200101245,000.00625925AR3 0.00 245,000.001161245,000.00 3.350UBS 674.59 0.00 674.593.350101245,000.0090348JEJ5 0.00 248,000.001162248,000.00 3.400COMMBK 693.04 0.00 693.043.400101248,000.0020143PDV9 0.00 248,000.001163248,000.00 3.250MRRCK 662.47 0.00 662.473.250101248,000.0059013J4K2 0.00 248,000.001164248,000.00 3.550NMRCA 723.62 0.00 723.623.550101248,000.0067054NAN3 0.00 248,000.001166248,000.00 3.350REDRCK 682.85 0.00 682.853.350101248,000.0075701LAB3 0.00 245,000.001167245,000.00 3.200NEIGH 644.38 0.00 644.383.200101245,000.0064017AAQ7 0.00 245,000.001168245,000.00 3.1501STSRC 634.31 0.00 634.313.150101245,000.0033646CKP8 0.00 248,000.001169248,000.00 3.400MEDBA 693.04 0.00 693.043.400101248,000.0058404DCX7 0.00 245,000.001170245,000.00 3.400NLCOOP 684.66 0.00 684.663.400101245,000.00635573AL2 0.00 248,000.001171248,000.00 3.300MAINE 672.65 0.00 672.653.300101248,000.00560507AK1 0.00 248,000.001172248,000.00 3.350BARHAR 682.85 0.00 682.853.350101248,000.00066851WJ1 0.00 248,000.001173248,000.00 2.750MORTN 560.55 0.00 560.552.750101248,000.00619165JD6 0.00 248,000.001174248,000.00 3.000WELLS 611.51 0.00 611.513.000101248,000.00949763XY7 0.00 485,250.001175500,000.00 1.950COLGTE 812.50 0.00 812.502.037101485,250.0019416QEA4 0.00 498,550.001177500,000.00 2.500FHLB 1,041.67 0.00 1,041.672.542101498,550.003130AFW94 0.00 489,687.501178500,000.00 1.875USTR 768.45 0.00 768.451.909101489,687.509128282W9 0.00 248,000.001179248,000.00 2.8001STNBK 570.74 0.00 570.742.800101248,000.0032117BCX4 0.00 248,000.001180248,000.00 2.700VERUS 550.35 0.00 550.352.700101248,000.0092535LCD4 0.00 248,000.001181248,000.00 2.950NRTHWS 601.32 0.00 601.322.950101248,000.0066736ABP3 0.00 248,000.001184248,000.00 2.500CENTNX 509.60 0.00 509.602.500101248,000.00156634AK3 0.00 245,000.001185245,000.00 3.250JPMORG 654.45 0.00 654.453.250101245,000.0048128HXU7 0.00 Portfolio CITY CP Run Date: 09/10/2021 - 20:23 TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 Current Rate Ending Par Value Ending Fund Page 3 Book Value Beginning Book Value Adjusted Interest Earnings Accretion Amortization/ Earnings Adjusted Interest June 1, 2021 - June 30, 2021 Total Earnings City of La Quinta Annualized YieldCUSIPInvestment # Interest EarnedIssuer Realized Gainl/Loss Fund: General Fund 245,000.001186245,000.00 2.400IOWAST 483.28 0.00 483.282.400101245,000.0046256YAZ2 0.00 248,000.001187248,000.00 2.400TSCOLA 489.21 0.00 489.212.400101248,000.0087266AAA1 0.00 248,000.001188248,000.00 2.600MAINST 529.97 0.00 529.972.600101248,000.0056065GAG3 0.00 248,000.001189248,000.00 2.500CONGRS 509.59 0.00 509.592.500101248,000.0020726ABA5 0.00 496,650.001190500,000.00 2.350WALMRT 979.16 0.00 979.162.399101496,650.00931142DU4 0.00 496,650.001192500,000.00 1.750USTR 713.32 0.00 713.321.747101496,650.00912828SV3 0.00 245,000.001194245,000.00 2.500PITTS 503.42 0.00 503.422.500101245,000.00725404AB3 0.00 245,000.001195245,000.00 2.550PLAINS 513.49 0.00 513.492.550101245,000.0072651LCL6 0.00 248,000.001196248,000.00 2.600EVNSCU 529.97 0.00 529.972.600101248,000.00299547AQ2 0.00 248,000.001197248,000.00 2.400LEGCY 489.21 0.00 489.212.400101248,000.00524661CB9 0.00 499,500.001198500,000.00 1.875FFCB 781.25 0.00 781.251.903101499,500.003133EKQP4 0.00 248,000.001199248,000.00 2.400CTZNST 489.20 0.00 489.202.400101248,000.00176688CP2 0.00 248,000.001200248,000.00 2.300AMERCU 468.82 0.00 468.822.300101248,000.0003065AAL7 0.00 245,000.001201245,000.00 2.150STRLNG 432.94 0.00 432.942.150101245,000.0085916VDC6 0.00 248,000.001202248,000.00 2.250COMMW 458.63 0.00 458.632.250101248,000.0020416TAQ5 0.00 247,000.001203247,000.00 2.300REVER 466.93 0.00 466.932.300101247,000.00761402BY1 0.00 248,000.001205248,000.00 2.000AMRNTL 407.67 0.00 407.672.000101248,000.0002772JBD1 0.00 495,950.001206500,000.00 1.750FNMA 729.16 0.00 729.161.789101495,950.003135G0V75 0.00 248,000.001207248,000.00 1.950ABACUS 397.48 0.00 397.481.950101248,000.0000257TBD7 0.00 248,000.001208248,000.00 2.000LKSIDE 407.67 0.00 407.672.000101248,000.0051210SQU4 0.00 248,000.001209248,000.00 2.0001STSEC 407.67 0.00 407.672.000101248,000.0033625CCP2 0.00 248,000.001210248,000.00 2.000PEOPLE 407.67 0.00 407.672.000101248,000.00710571DS6 0.00 499,500.001212500,000.00 1.850FFCB 770.83 0.00 770.831.878101499,500.003133EKWV4 0.00 249,000.001213249,000.00 2.000PREFRD 409.32 0.00 409.322.000101249,000.00740367HP5 0.00 248,000.001214248,000.00 2.000UNTDCU 407.67 0.00 407.672.000101248,000.00910160AH3 0.00 248,000.001215248,000.00 2.000WSHFED 407.67 0.00 407.672.000101248,000.00938828BH2 0.00 249,000.001216249,000.00 1.9501STIER 399.08 0.00 399.081.950101249,000.0033766LAJ7 0.00 499,300.001217500,000.00 1.375USTR 563.52 0.00 563.521.373101499,300.00912828T26 0.00 244,000.001218244,000.00 1.950RAYJAM 391.07 0.00 391.071.950101244,000.0075472RAD3 0.00 245,000.001219245,000.00 1.900CITBNK 382.60 0.00 382.601.900101245,000.0012556LBA3 0.00 248,000.001220248,000.00 1.850CELTIC 377.10 0.00 377.101.850101248,000.0015118RRH2 0.00 249,000.001221249,000.00 1.8501STNBS 378.62 0.00 378.621.850101249,000.00334342CD2 0.00 248,000.001222248,000.00 1.8001STDQN 366.90 0.00 366.901.800101248,000.00336460CX6 0.00 499,400.001223500,000.00 1.600FFCB 666.66 0.00 666.661.624101499,400.003133EKZK5 0.00 498,750.001224500,000.00 1.600FFCB 666.67 0.00 666.671.626101498,750.003133EKP75 0.00 245,000.001225245,000.00 1.600LUANA 322.19 0.00 322.191.600101245,000.00549104JN8 0.00 245,000.001226245,000.00 1.800NYCMBK 362.47 0.00 362.471.800101245,000.00649447TC3 0.00 Portfolio CITY CP Run Date: 09/10/2021 - 20:23 TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 Current Rate Ending Par Value Ending Fund Page 4 Book Value Beginning Book Value Adjusted Interest Earnings Accretion Amortization/ Earnings Adjusted Interest June 1, 2021 - June 30, 2021 Total Earnings City of La Quinta Annualized YieldCUSIPInvestment # Interest EarnedIssuer Realized Gainl/Loss Fund: General Fund 248,000.001227248,000.00 1.700BNKWST 346.52 0.00 346.521.700101248,000.0006652CHB0 0.00 10,056,644.58122810,056,644.58BOTW 0.01 0.00 0.0110111,490,355.05059731851 0.00 11,381,922.40123011,381,922.40PARS 0.00 0.00 0.0010111,277,103.22SYS1230 0.00 248,000.001231248,000.00 1.7001STSER 346.52 0.00 346.521.700101248,000.0033640VDD7 0.00 992,100.0012331,000,000.00 1.375FNMA 1,145.83 0.00 1,145.831.405101992,100.003135G0W33 0.00 996,900.0012341,000,000.00 1.600FFCB 1,333.34 0.00 1,333.341.627101996,900.003133EK4X1 0.00 248,000.001235248,000.00 1.700SAUKVL 346.52 0.00 346.521.700101248,000.00804375DL4 0.00 245,000.001236245,000.00 1.900MSPRIV 382.60 0.00 382.601.900101245,000.0061760A3B3 0.00 245,000.001237245,000.00 1.950MORGST 392.67 0.00 392.671.950101245,000.0061690UNX4 0.00 248,000.001238248,000.00 1.800LIVEOK 366.90 0.00 366.901.800101248,000.00538036GV0 0.00 248,000.001239248,000.00 1.900KERNCU 387.29 0.00 387.291.900101248,000.0049228XAK6 0.00 248,000.001240248,000.00 1.850SF FCU 377.10 0.00 377.101.850101248,000.0079772FAC0 0.00 989,687.5012411,000,000.00 1.500USTR 1,229.51 0.00 1,229.511.511101989,687.50912828YV6 0.00 998,600.0012421,000,000.00 1.700FFCB 1,416.67 0.00 1,416.671.726101998,600.003133ELEA8 0.00 248,000.001244248,000.00 1.900WFNBW 387.29 0.00 387.291.900101248,000.00949495AT2 0.00 999,000.0012461,000,000.00 1.430FFCB 1,191.66 0.00 1,191.661.451101999,000.003133ELNE0 0.00 999,217.3612471,000,000.00 1.400FFCB 1,166.67 0.00 1,166.671.421101999,217.363133EGWJ0 0.00 248,000.001248248,000.00 1.550FRDMFI 315.95 0.00 315.951.550101248,000.0035637RDC8 0.00 248,000.001249248,000.00 1.650UNTDCM 336.33 0.00 336.331.650101248,000.0090983WBT7 0.00 248,000.001250248,000.00 1.6501STNMI 336.33 0.00 336.331.650101248,000.0032114VBT3 0.00 245,000.001251245,000.00 1.650RLLSTN 332.26 0.00 332.261.650101245,000.0077579ADF0 0.00 248,000.001252248,000.00 1.650CITADL 336.33 0.00 336.331.650101248,000.0017286TAG0 0.00 245,000.001253245,000.00 1.600SYNOVS 322.19 0.00 322.191.600101245,000.0087164DRD4 0.00 248,000.001254248,000.00 1.600SERVIS 326.14 0.00 326.141.600101248,000.0081768PAF3 0.00 248,000.001255248,000.00 1.600AMERST 326.14 0.00 326.141.600101248,000.00029728BC5 0.00 248,000.001256248,000.00 1.600ACCSS 326.14 0.00 326.141.600101248,000.0000435JBH5 0.00 248,000.001257248,000.00 1.500SPRING 305.76 0.00 305.761.500101248,000.00849430BF9 0.00 248,000.001258248,000.00 1.650AXOS 336.33 0.00 336.331.650101248,000.0005465DAE8 0.00 245,000.001259245,000.00 1.200CADNCE 241.65 0.00 241.651.200101245,000.0012738RFX7 0.00 245,000.001260245,000.00 1.100TEXAS 221.51 0.00 221.511.100101245,000.00882213AB7 0.00 248,000.001261248,000.00 1.100SNTCLR 224.22 0.00 224.221.100101248,000.0006424KBC3 0.00 248,000.001262248,000.00 1.350TRIAD 275.18 0.00 275.181.350101248,000.0089579NCD3 0.00 248,000.001263248,000.00 1.150NRTHSR 234.41 0.00 234.411.150101248,000.0066704MEQ0 0.00 248,000.001264248,000.00 1.300BELLCO 264.99 0.00 264.991.300101248,000.0007833EAD9 0.00 248,000.001265248,000.00 1.150WESTMI 234.41 0.00 234.411.150101248,000.00954444BS3 0.00 248,000.001266248,000.00 1.400NCOLET 285.37 0.00 285.371.400101248,000.00654062JZ2 0.00 248,000.001267248,000.00 1.400ALMABK 285.37 0.00 285.371.400101248,000.00020080BX4 0.00 Portfolio CITY CP Run Date: 09/10/2021 - 20:23 TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 Current Rate Ending Par Value Ending Fund Page 5 Book Value Beginning Book Value Adjusted Interest Earnings Accretion Amortization/ Earnings Adjusted Interest June 1, 2021 - June 30, 2021 Total Earnings City of La Quinta Annualized YieldCUSIPInvestment # Interest EarnedIssuer Realized Gainl/Loss Fund: General Fund 248,000.001268248,000.00 1.250CMWBUS 254.79 0.00 254.791.250101248,000.002027506M2 0.00 245,000.001269245,000.00 1.300PACWST 261.78 0.00 261.781.300101245,000.0069506YRH4 0.00 248,000.001270248,000.00 1.250BELB&T 254.79 0.00 254.791.250101248,000.0008016PDQ9 0.00 245,000.001271245,000.00 1.600CAPONE 322.19 0.00 322.191.600101245,000.0014042TDD6 0.00 248,000.001272248,000.00 1.250THEJEF 254.80 0.00 254.801.250101248,000.00472382AQ3 0.00 249,000.001273249,000.00 1.2001STFDM 245.60 0.00 245.601.200101249,000.0032027BAL1 0.00 248,000.001274248,000.00 1.3501STMCG 275.18 0.00 275.181.350101248,000.0032112UDR9 0.00 248,000.001276248,000.00 1.250FLGSTR 254.80 0.00 254.801.250101248,000.0033847E3A3 0.00 245,000.001277245,000.00 1.000WSTRNS 201.37 0.00 201.371.000101245,000.0095960NKD8 0.00 248,000.001278248,000.00 1.0001STINT 203.84 0.00 203.841.000101248,000.0032056GDJ6 0.00 1,000,000.0012791,000,000.00 0.625FHLMC 520.84 0.00 520.840.6341011,000,000.003134GVYG7 0.00 499,850.001280500,000.00 0.500FFCB 208.34 0.00 208.340.507101499,850.003133ELH23 0.00 499,850.001281500,000.00 0.500FHLB 208.33 0.00 208.330.507101499,850.003130AJKW8 0.00 500,000.001282500,000.00 0.680FFCB 283.33 0.00 283.330.689101500,000.003133ELH80 0.00 300,000.001283300,000.00 0.680FHLB 170.00 0.00 170.000.689101300,000.003130AJRP6 0.00 248,000.001284248,000.00 0.600CHIPVA 122.30 0.00 122.300.600101248,000.00169894AS1 0.00 248,000.001285248,000.00 0.350AMR1ST 71.34 0.00 71.340.350101248,000.0002616AAH2 0.00 248,000.001286248,000.00 0.500STHRNB 101.92 0.00 101.920.500101248,000.0084223QAN7 0.00 248,000.001287248,000.00 0.500BKPRNC 101.92 0.00 101.920.500101248,000.00064520BG3 0.00 500,000.001288500,000.00 0.500FNMA 208.33 0.00 208.330.507101500,000.003135G05S8 0.00 1,000,000.0012891,000,000.00 0.560FNMA 466.66 0.00 466.660.5681011,000,000.003136G4N74 0.00 499,750.001290500,000.00 0.520FNMA 216.67 0.00 216.670.527101499,750.003136G4M75 0.00 499,250.001291500,000.00 0.420FNMA 175.00 0.00 175.000.426101499,250.003135G06E8 0.00 499,250.001292500,000.00 0.560FNMA 233.33 0.00 233.330.569101499,250.003135GA2Z3 0.00 5,000,000.0012935,000,000.00BNY 0.01 0.00 0.011013,056,596.78SYS1293 0.00 997,300.0012971,000,000.00 0.375FHLMC 312.50 0.00 312.500.381101997,300.003137EAEU9 0.00 497,400.001298500,000.00 0.375FHLB 156.25 0.00 156.250.382101497,400.003130AKFA9 0.00 500,000.001299500,000.00 0.600FNMA 250.00 0.00 250.000.608101500,000.003135GA7D7 0.00 500,000.001300500,000.00 0.400FNMA 166.67 0.00 166.670.406101500,000.003135GAAW1 0.00 500,000.001301500,000.00 0.550FHLMC 229.17 0.00 229.170.558101500,000.003134GXGZ1 0.00 500,000.001302500,000.00 0.510FHLB 212.50 0.00 212.500.517101500,000.003130AKMZ6 0.00 498,632.811303500,000.00 0.375USTR 155.31 0.00 155.310.379101498,632.8191282CBC4 0.00 500,000.001304500,000.00 0.550FHLB 229.17 0.00 229.170.558101500,000.003130AKN28 0.00 248,000.001305248,000.00 0.500LNDMRK 101.92 0.00 101.920.500101248,000.0051507LCC6 0.00 245,000.001306245,000.00 0.500EVRBA 100.69 0.00 100.690.500101245,000.0087270LDL4 0.00 495,999.501307500,000.00 0.375FHLMC 156.25 0.00 156.250.383101495,999.503137EAEX3 0.00 497,300.001308500,000.00 0.500IFC 207.18 0.00 207.180.507101497,300.0045950VPS9 0.00 Portfolio CITY CP Run Date: 09/10/2021 - 20:23 TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 Current Rate Ending Par Value Ending Fund Page 6 Book Value Beginning Book Value Adjusted Interest Earnings Accretion Amortization/ Earnings Adjusted Interest June 1, 2021 - June 30, 2021 Total Earnings City of La Quinta Annualized YieldCUSIPInvestment # Interest EarnedIssuer Realized Gainl/Loss Fund: General Fund 495,100.001309500,000.00 0.375USTR 155.38 0.00 155.380.382101495,100.0091282CBH3 0.00 983,940.0013101,000,000.00 0.375FHLMC 312.50 0.00 312.500.386101983,940.003137EAEX3 0.00 977,500.0013111,000,000.00 0.250USTR 203.81 0.00 203.810.254101977,500.0091282CAT8 0.00 500,000.001312500,000.00 0.500FHLB 208.33 0.00 208.330.507101500,000.003130ALV92 0.00 249,000.001313249,000.00 0.950GRNST 194.42 0.00 194.420.950101249,000.0039573LBC1 0.00 245,000.001314245,000.00 0.900TOYFSB 181.24 0.00 181.240.900101245,000.0089235MKY6 0.00 492,187.501315500,000.00 0.375USTR 153.69 0.00 153.690.380101492,187.5091282CAZ4 0.00 248,000.001316248,000.00 0.750CARTER 152.88 0.00 152.880.750101248,000.0014622LAA0 0.00 248,000.001317248,000.00 0.700FIDHMS 142.68 0.00 142.680.700101248,000.0031617CAV5 0.00 265,784.811318265,784.81DPME 0.00 0.00 0.00101241,247.93SYS1318 0.00 494,165.001319500,000.00 0.500USTR 203.81 0.00 203.810.502101494,165.0091282CBQ3 0.00 499,525.001320500,000.00 0.750USTR 307.37 0.00 307.370.749101499,525.0091282CBT7 0.00 997,060.0013211,000,000.00 0.750USTR 614.76 0.00 614.760.7501010.0091282CCF6 0.00 498,450.001322500,000.00 0.750USTR 143.44 0.00 143.440.7501010.0091282CBT7 0.00 497,095.001323500,000.00 0.750USTR 143.44 0.00 143.440.7521010.0091282CCF6 0.00 993,420.0013241,000,000.00 0.750FHLB 291.67 0.00 291.670.7651010.003130AMFS6 0.00 176,253,992.80Subtotal 175,993,344.97 0.818 106,264.750.00106,264.75156,491,245.92 0.00 Fund: Fiscal Agent 1,422.1610581,422.16USBANK 0.01 0.00 0.010.0092311,422.15SYS1058 0.00 1,422.16Subtotal 1,422.16 0.009 0.010.000.011,422.15 0.00 Fund: Housing Authority : WSA and LQ 335,858.811062335,858.81LQPR 0.00 0.00 0.00241326,355.81SYS1062 0.00 335,858.81Subtotal 335,858.81 0.000.000.00326,355.81 0.00 Fund: SA Low/Mod Bond Fund 10,580,686.54111310,580,686.54 0.262LAIF 2,848.44 0.00 2,848.440.32824910,580,686.5425-33-005 0.00 10,580,686.54Subtotal 10,580,686.54 0.328 2,848.440.002,848.4410,580,686.54 0.00 187,171,960.31Total 186,911,312.48 0.786 109,113.200.00109,113.20167,399,710.42 0.00 Portfolio CITY CP Run Date: 09/10/2021 - 20:23 TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 City of La Quinta -City of La Quinta Purchases Report Sorted by Security Type - Fund April 1, 2021 - June 30, 2021 Original Par Value Ending Book Value Sec. TypeFund Maturity YTM Accrued Interest at PurchasePayment Periods DateCUSIPInvestment #Issuer Purchase Date Principal Purchased Rate at Purchase Federal Agency Coupon Securities 1,000,000.00 0.750 06/12/2026 993,420.00993,420.00 Received06/17/2021 0.88512/12 - 06/12FHLB13243130AMFS6FAC101 Subtotal 993,420.00993,420.00 0.001,000,000.00 Treasury Coupon Securities 500,000.00 0.375 11/30/2025 492,187.50492,187.50 Received04/22/2021 0.72005/31 - 11/30USTR131591282CAZ4TRC101 500,000.00 0.500 02/28/2026 494,165.00494,165.00 Received05/28/2021 0.75008/31 - 02/28USTR131991282CBQ3TRC101 500,000.00 0.750 03/31/2026 499,525.00499,525.00 Received05/28/2021 0.77009/30 - 03/31USTR132091282CBT7TRC101 1,000,000.00 0.750 05/31/2026 997,060.00997,060.00 Received06/01/2021 0.81011/30 - 05/31USTR132191282CCF6TRC101 500,000.00 0.750 03/31/2026 498,450.00498,450.00 Received06/17/2021 0.81609/30 - 03/31USTR132291282CBT7TRC101 500,000.00 0.750 05/31/2026 497,095.00497,095.00 Received06/17/2021 0.87011/30 - 05/31USTR132391282CCF6TRC101 Subtotal 3,478,482.503,478,482.50 0.003,500,000.00 Certificate of Deposits 249,000.00 0.950 04/16/2026 249,000.00249,000.0004/16/2021 0.95105/01 - MonthlyGRNST131339573LBC1MC1101 245,000.00 0.900 04/22/2026 245,000.00245,000.0004/22/2021 0.90010/22 - 04/22TOYFSB131489235MKY6MC1101 248,000.00 0.750 04/27/2026 248,000.00248,000.0004/27/2021 0.75005/27 - MonthlyCARTER131614622LAA0MC1101 248,000.00 0.700 04/30/2026 248,000.00248,000.0004/30/2021 0.71105/31 - MonthlyFIDHMS131731617CAV5MC1101 Subtotal 990,000.00990,000.00 0.00990,000.00 5,461,902.50Total Purchases 5,490,000.00 0.00 5,461,902.50 Received = Accrued Interest at Purchase was received by report ending date. Portfolio CITY CP Run Date: 08/10/2021 - 11:25 PU (PRF_PU) 7.1.1 Report Ver. 7.3.6.1 City of La Quinta -City of La Quinta Maturity Report Sorted by Maturity Date Amounts due during April 1, 2021 - June 30, 2021 Rate at MaturityPar Value Sec. TypeFund Maturity Date Maturity ProceedsInterest Income Net CUSIP Investment #Issuer Purchase Date Book Value at Maturity 240,000.00 2.250 242,692.602,692.6004/19/2017AMEX107702587DP85MC110104/19/2021 2,692.60240,000.00 240,000.00 2.800 243,350.793,350.7904/30/2018TOWNE112889214PBL2MC110104/30/2021 3,350.79240,000.00 240,000.00 1.500 241,785.211,785.2105/26/2016PRVTBA103274267GVG9MC110105/26/2021 1,785.21240,000.00 500,000.00 1.375 503,437.503,437.5005/31/2019USTR1193912828R77TRC10105/31/2021 9,827.50493,610.00 240,000.00 2.250 242,692.602,692.6006/07/2017CAP1NA108214042RGD7MC110106/07/2021 2,692.60240,000.00 5,000,000.00 1.125 5,028,125.0028,125.0007/18/2016USTR1045912828S27TRC10106/30/2021 28,125.005,000,000.00 6,502,083.70Total Maturities 6,460,000.00 42,083.706,453,610.00 48,473.70 Portfolio CITY CP Run Date: 08/10/2021 - 11:26 MA (PRF_MA) 7.1.1 Report Ver. 7.3.6.1 City of La Quinta -City of La Quinta Sales/Call Report Sorted by Maturity Date - Fund April 1, 2021 - June 30, 2021 Redem. Date Redemption Principal Redemption Interest Book Value at Redem. Total Amount Net IncomeFundMatur. Date Rate at Redem. Par ValueSec. TypeCUSIPInvestment # Issuer Purchase Date 04/21/2025 1,000,000.00 998,500.00 1,000,000.00 3,500.0012753134GVLC004/21/2021 1,003,500.00 5,000.00101FHLMC FAC 04/21/2025 04/28/2020 0.700 Call Subtotal 998,500.00 1,000,000.00 3,500.001,000,000.00 1,003,500.00 5,000.00 1,000,000.00Total Sales 1,000,000.00 3,500.00998,500.00 1,003,500.00 5,000.00 Portfolio CITY CP Run Date: 08/10/2021 - 11:27 SA (PRF_SA) 7.1.1 Report Ver. 7.3.6.1 US Treasury Rates https://www.treasury.gov/resource-center/data-chart-center/interest-rates/Pages/TextView.aspx?data=yieldYear&year=2020 City of La Quinta FINANCIAL ADVISORY COMMISSION MEETING: October 6, 2021 STAFF REPORT AGENDA TITLE: APPOINT TWO FINANCIAL ADVISORY COMMISSIONERS TO AUDIT AND FORMULATE THE ANNUAL MEASURE G SALES TAX OVERSIGHT COMPLIANCE REPORT FOR FISCAL YEAR 2020/21 RECOMMENDATION Appoint two Financial Advisory Commissioners to audit and formulate the annual Measure G Compliance Report for Fiscal Year 2020/21. EXECUTIVE SUMMARY • Measure G, the one percent (1%) Transactions and Use Tax measure was approved by voters at the November 8, 2016 General Election and subsequently adopted by resolution on December 20, 2016 with an effective date of April 1, 2017. Additional funds are subject to citizen oversight. • Staff recommends the Financial Advisory Commission (FAC) appoint two Commissioners to serve on the sub-committee to verify revenue and expenses associated with Measure G funds. • The sub-committee shall prepare a report and present their findings to the FAC on November 10, 2021, and to City Council on December 7, 2021. BACKGROUND/ANALYSIS The Measure was approved on November 8, 2016 and adopted by resolution on December 20, 2016 with an effective date of April 1, 2017. Additional funds generated by the Measure are subject to citizen oversight. Starting in June 2017, Measure G funds have been received monthly. City staff recommends appointing two Commissioners on the sub-committee. Staff and the sub-committee shall present a report to FAC on November 10, 2021 for discussion and confirmation prior to City Council review and approval on December 7, 2021. Staff anticipates up to two, two-hour virtual meetings during the next month. BUSINESS SESSION ITEM NO. 1 The review will include the following: 1. A review of revenue received during fiscal year 2020/21 2. A review of approved use of funds for capital projects, reserves, and contract services 3. A review of proposed future uses 4. A review of current funds available for appropriation 5. A review of the proposed FY 2020/21 financial statement balance and disclosure ALTERNATIVES The subcommittee may be comprised of up to three commissioners. Prepared by: Claudia Martinez, Interim Finance Director/City Treasurer City of La Quinta FINANCIAL ADVISORY COMMISSION MEETING DEPARTMENT REPORT TO: Financial Advisory Commissioners FROM: Claudia Martinez, Interim Finance Director DATE: October 6, 2021 SUBJECT: FINANCE DEPARTMENT CURRENT AND FUTURE INITIATIVES In addition to items presented as staff reports, the Finance Department would like to provide updates on the following matters. AUDIT & FINANCIAL REPORTING • Completed the FY 2018/19 AB 2766 Air Quality and Improvement Fund audit with no findings • In Process: Annual Street and Road Improvement Audit to be filed with the State Controller’s Office and the Annual Measure A Local Streets and Roads Audit to be filed with the Riverside County Transportation Commission • Citywide Comprehensive fiscal year 2020/21 audit will take place from October 11th through October 22nd o Year-end entry and audit prep work is well underway and is continuing this week COMMITTEE UPDATES • Annual Measure G Sales Tax Oversight Compliance Report for FY 2020/21 o Appointing Commissioners this meeting • 10 Year Financial Projections (Commissioners Batavick, Way) o Coordinate meeting timeline • Reserve Policy Update (Spring of 2022) o Coordination with the City Clerk’s office PERSONNEL UPDATES The Finance Director recruitment has been published and is scheduled to close on October 11th, 2021. The Finance Department is running smoothly and efficiently, the entire team has been working together and will continue doing so. DEPARTMENTAL REPORT ITEM NO. 1 POWER POINTS FINANCIAL ADVISORY COMMISSION SPECIAL MEETING OCTOBER 6, 2021 Financial Advisory CommissionSpecial MeetingOctober 6, 2021