The URL can be used to link to this page

2020 09 30 FAC Special Meeting FINANCIAL ADVISORY COMMISSION MINUTES 1 AUGUST 5, 2020 REGULAR QUARTERLY MEETING FINANCIAL ADVISORY COMMISSION MINUTES WEDNESDAY, August 5, 2020 CALL TO ORDER A regular quarterly meeting of the Financial Advisory Commission (Commission) was called to order at 4:00 p.m. by Chairperson Mills. This meeting was held by teleconference pursuant to Executive orders N-25- 20, N-29-20, N-33-20, and N-35-20, executed by the Governor of California 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 of the Ralph M. Brown Act (Government Code § 54950 et seq.). PRESENT: Commissioners Batavick, Hoffner, Hunter, Rosen, Twohey and Chairperson Mills ABSENT: None VACANCY: One STAFF PRESENT: Finance Director Romero, Financial Services Analyst Hallick, Management Assistant Delgado, Design and Development Director Castro, Planning Manger Flores, Building Official Ortega, Public Works Director/City Engineer McKinney, and Management Analyst Mignogna PLEDGE OF ALLEGIANCE Commissioner Twohey led the audience in the Pledge of Allegiance. PUBLIC COMMENT ON MATTERS NOT ON THE AGENDA – None CONFIRMATION OF AGENDA Finance Director Romero requested adding the following verbal updates under the Departmental Reports section of the Agenda: • LifeStream Annual Coachella Valley Nine Cities Blood Drive Challenge • Finance Account Technician recruitment • Bank of New York Mellon Trust Company custody account CONSENT CALENDAR ITEM NO. 1 FINANCIAL ADVISORY COMMISSION MINUTES 2 AUGUST 5, 2020 REGULAR QUARTERLY MEETING • Fiscal year 2019/20 audit preparations • Federal Emergency Management Agency contract services with Vanir Chairperson Mills requested an update from staff on the Avenue 48 Art and Music Line regional project spearheaded by the Coachella Valley Association of Governments (CVAG). The Commission concurred. ANNOUNCEMENTS, PRESENTATIONS, AND WRITTEN COMMUNICATIONS 1. CAPITAL IMPROVEMENT PROGRAM AND DEVELOPMENT UPDATES Highway 111 Corridor Area Plan (Plan) Design and Development Director Castro and Planning Manger Flores gave a brief update on the status for the Plan including the components asked for in the request for proposal (RFP) for form-based code planning and engineering services for the Plan. Planning Manager Flores said a total of three proposals were received, two firms were invited for interviews, and staff anticipates bringing this item for Council review and consideration in September 2020. Chairperson Mills shared his experience being on the interview panel for the RFP Plan. SilverRock Development (Development) Building Official Ortega gave an update on the Development including the status on the plan checks for the several projects pending, including the Pendry hotel, Pendry residences, Montage hotels, Montage residences and bungalows, shared facilities, water and pool structures. The Commission requested an update on the grand opening for the Development currently scheduled for Fall of 2021 and the status for the transition of the golf course operations from the City to the developer. Staff said they’re anticipating an update from the developer on the grand opening to Council in a future meeting this Fall. Staff noted the transition of the golf course operations was originally intended to be done as early as June 2020; however, due to the COVID-19 pandemic, it was delayed and the City’s contract with Landmark Golf Management was extended until to June of 2021 to ensure continuity of operations. Finance Director Romero said that the City would continue to monitor operations for golf course and anticipated operation cost would be added to the 10-year projections after audit season at the end of October 2020. FINANCIAL ADVISORY COMMISSION MINUTES 3 AUGUST 5, 2020 REGULAR QUARTERLY MEETING The Commission asked about the median landscape at the entrance of SilverRock (SRR at the roundabout on Jefferson Street and Avenue 52. Public works Director/City Engineer McKinney said that the landscape for the roundabout in front of SRR is not part of the Development, but may be started as a median landscape project for next year. SilverRock Event Site (Site) Public works Director/City Engineer McKinney said completion of the Site project is anticipated for September 2020 and gave an update on the outstanding Site plan components pending completion. Avenue 48 Art and Music Line Project (Project) Public Works Director/City Engineer McKinney said that the City has held several meetings with CVAG regarding the Project’s design; and noted CVAG was close to finalizing the plan to submit for grant funding needed to construct the Project. CONSENT CALENDAR ITEMS 1. APPROVE SPECIAL MEETING MINUTES DATED JUNE 3, 2020 2. APPROVE SPECIAL MEETING MINUTES DATED JUNE 9,2020 3. RECEIVE AND FILE REVENUE AND EXPENDITURE REPORT DATED MAY 31, 2020 Motion – A motion was made and seconded by Commissioners Twohey/Rosen to approve the Consent Calendar, as submitted. Motion passed: ayes 6, noes 0, vacancy 1. BUSINESS SESSION 1. APPOINT A FINANCIAL ADVISORY COMMISSIONER CHAIRPERSON AND VICE-CHAIRPERSON TO SERVE FOR FISCAL YEAR 2020/21 Finance Director Romero presented the staff report, which is on file in the Finance Department. Finance Director Romero provided the Commission with an overview of the roles and responsibilities of a Chairperson and Vice-Chairperson. The Commission nominated to reelect Commissioners Mills and Twohey to continue in their roles as Chairperson and Vice-Chairperson, respectively, for fiscal year 2020/21; and Commissioners Mills and Twohey expressed their willingness to continue to serve in these capacities. FINANCIAL ADVISORY COMMISSION MINUTES 4 AUGUST 5, 2020 REGULAR QUARTERLY MEETING Motion – A motion was made and seconded by Commissioners Rosen/Batavick to appoint Commissioners Mills and Twohey to serve as Chairperson and Vice- Chairperson, respectively, for fiscal year 2020/21. Motion passed: ayes 6, noes 0, vacancy 1. STUDY SESSION – None DEPARTMENTAL REPORTS Staff provided a verbal update on all departmental report items. 1. LA QUINTA COVID-19 SMALL BUSINESS EMERGENCY ECONOMIC RELIEF PROGRAM (Program) – VERBAL UPDATE The Commission and staff discussed the Program guidelines; the City’s community outreach efforts; and the $10,000 cap for one-time rent/mortgage and utilities reimbursement for certain businesses with a physical storefront. The Commission recommended expanding the Programs’ eligibility guidelines by either extending the application deadline, increasing the cap amount if available funding remains, or if an additional allocation is approved for the Program. 2. LIFESTREAM ANNUAL COACHELLA VALLEY NINE CITIES BLOOD DRIVE CHALLENGE Finance Director Romero said that the nine cities blood drive is going on through the end of August and encouraged anyone who can donate to do so. She mentioned successful blood donations would be tested for COVID-19 anti- bodies. 3. FINANCE ACCOUNT TECHNICIAN RECRUITMENT Finance Director Romero noted the following: • 75 applications received – Human Resources performed the initial screening; • 35 qualified applicants received a supplemental exercise; • 10 applicants would be interviewed on Tuesday, August 11, 2020; • Second interviews to follow for at least top two candidates; • Reference checks; selection and a formal offer are anticipated by the end of August 2020. FINANCIAL ADVISORY COMMISSION MINUTES 5 AUGUST 5, 2020 REGULAR QUARTERLY MEETING 4. BANK OF NEW YORK (BNY) MELLON TRUST COMPANY CUSTODY ACCOUNT Finance Director Romero announced that Council approved a custody account agreement with BNY Mellon Trust Company at a regular meeting on Tuesday, August 4, 2020. 5. FISCAL YEAR 2019/20 AUDIT PREPARATIONS Finance Director Romero said that the City is preparing for a fiscal year end audit for fiscal year 2019/20. She mentioned the final comprehensive audit is scheduled for the week of October 12th and would be done virtually. 6. FEDERAL EMERGENCY MANAGEMENT AGENCY (FEMA) CONTRACT SERVICES WITH VANIR Finance Director Romero announced the FEMA contract was officially executed with Vanir Construction Management, Inc. on Monday, August 3, 2020 and a kickoff meeting is scheduled with the City’s Finance Department and Vanir staff the week of August 17, 2020. COMMISSIONERS’ ITEMS 2. SUB-COMMITTEE REVIEW OF POLICE SERVICES – VERBAL UPDATE Commissioners Batavick and Rosen shared their experience and involvement in the sub-committee tasked to review and evaluate police service levels and associated costs; to date the sub-committee has held four virtual meetings to review and discuss the City’s annual study for police services prepared by Matrix Consulting Group, the different components for police expenses and patrol service levels, and the components for possible contract negotiations with other cities. ADJOURNMENT There being no further business, it was moved and seconded by Commissioners Twohey/Hunter to adjourn this meeting at 5:34 p.m. Motion passed: ayes 6, noes 0, vacancy 1. Respectfully submitted, Jessica Delgado, Management Assistant City of La Quinta, California City of La Quinta FINANCIAL ADVISORY COMMISSION MEETING: September 30, 2020 STAFF REPORT AGENDA TITLE: RECEIVE AND FILE FOURTH QUARTER 2019/20 TREASURY REPORTS FOR APRIL, MAY, AND JUNE 2020 WITH FISCAL YEAR-END SUMMARY RECOMMENDATION Receive and file the fourth quarter fiscal year 2019/20 Treasury Reports for April, May, and June 2020 with fiscal year-end summary. BACKGROUND/ANALYSIS Commentary and Summary of Significant Activity The total book value of the portfolio increased $19.74 million, from $150.25 million at the end of March to $169.99 million at the end of June. An increase of $13.31 million was due to a 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 revenue, expenditure, and investment activities during 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 14.54%2.46%5.03%100% Local Agency Investment Fund (LAIF) City 25.06%36.61%40.27%(1) Local Agency Investment Fund (LAIF) Housing 10.91%11.26%9.85%(1)(2) Money Market Pool Accounts-CAMP 3.16%1.92%1.68%20% Federal Agency Coupons 7.63%8.21%8.24%100% Treasury Coupons 7.10%7.33%6.41%100% Certificates of Deposit (CD's)21.94%22.80%20.10%30% Corporate Notes 2.18%1.57%1.38%30% Money Market with Fiscal Agent 0.00%0.00%0.00%(2) CERBT- OPEB Trust 1.01%1.04%1.01%(3) PARS Pension Trust 6.48%6.81%6.03%(3) Total 100% 100% 100% (3) OPEB and pension trusts are fiduciary accounts and not subject to City Investment Policy (1) LAIF is subject to maximum dollar amount not a percentage of the portfolio (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. 2 The market continued to react to the political climate, economic news, and ongoing concerns around the worldwide Coronavirus pandemic and staff worked with the City’s brokers to stay abreast of market conditions. The fiscal year annual effective rate of return is 1.82% as of June, an 11 basis point (bps) decrease since March (Q3) and a 22 bps decrease from the 2.04% in June 2019. Throughout the quarter, five CDs, one agency bond, and one treasury matured, and one CD, two corporate bonds, and one agency bond were called or sold for a total PAR value of $5,971,000. This money was used to purchase 19 new investments, which are listed in detail in the attached reports. Year-End Summary As reported in Q3, we faced interest rate pressures at the start of the fiscal year with the Federal Reserve cutting interest rates three times by October 2019. When the effects of the pandemic became obvious, the Fed reacted by lowering the target federal funds rate again, to a range of 0.00 to 0.25%. 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 daily yields have dropped quickly. For example, the LAIF monthly effective yield decreased 121 basis points from June 2019 to June 2020, and has continued to drop throughout the summer. This quarter, we continued to see the market effects of the global pandemic caused by the novel Coronavirus. This has added significant pressure on bond yields, with the 5-year and 10-year treasury rates continuing to test never- before-seen lows. As investments mature, we will be subject to reinvesting at these low rates for the foreseeable future. The fiscal year annual effective rate of return is 1.82% as of June and will continue to decline in the coming quarters as a result of the current rate environment. Going forward, we anticipate the drop will affect new investments, as well as holdings in government pools (CAMP/LAIF). This could negatively impact the effective rate of return by as much as 60 bps in fiscal 2020-21. Total Earnings Average Days to Maturity Effective Rate of Return YTD April 196,609$ 377 1.90% May 207,985$ 389 1.86% June 186,911$ 358 1.82% Quarter 4 591,504$ 375 1.86% The below chart summarizes the portfolio’s average daily balance, total earnings, and effective rate of return for the each of the past four years: 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: Karla Romero, Finance Director/City Treasurer Attachment: 1. Treasurer’s Report for April 1, 2020 to June 30, 2020 2016-17 2017-18 2018-19 2019-20 Average Daily Balance 125,445,981$ 131,713,765$ 141,628,303$ $152,994,488 Total Earnings 963,022$ 1,730,509$ 2,894,323$ $2,798,779 Effective Rate of Return 0.77%1.31%2.04%1.82% ---GEM of the DESERT --- Par Investments Value BankA=unts 22 ,311 ,057 .26 Local Agency Investment Fund-City 38,463 ,5 12 .61 Local Agency lnvstmnt Fund-Housing 16 ,748 ,919 .97 Money Market A=unts -CAMP 4 ,847 ,649 .76 Federal Agency Coupon Securities 11 ,750 ,000 .00 Treasury Coupon Securities 11 ,000 ,000 .00 Certificate of Deposits 33,665 ,000 .00 Corporate Notes 3,400 ,000 .00 Money Market with Fiscal Agent 5 ,360 .86 CERBT -OPEB Trust 1,543 ,284 .27 PARS Pens ion Trust 9 ,941 ,225 .99 153,676,010. 72 Investments Total Earnings April 30 Month Ending Current Year 196,608.57 Average Daily Balance 152,516,471.69 City of La Quinta Portfolio Management Portfolio Summary April 30, 2020 Market Book Value Value 22 ,311 ,057 .26 22 ,311 ,057 .26 38 ,561 ,949 .84 38,463 ,512 .61 16 ,776 ,931.45 16 ,748 ,919 .97 4 ,847 ,649 .76 4 ,847 ,649 .76 12 , 110 ,612 .50 11 ,703 ,992 .36 11 ,206 ,035 .00 10 ,897 ,535 .00 34 ,905 ,337 .14 33 ,665 ,000 .00 3,499 ,340 .00 3 ,341 ,010 .00 5 ,360 .86 5,360 .86 1,543 ,284 .27 1,543 ,284 .27 9 ,941 ,225 .99 9,941 ,225 .99 155, 708, 784.07 153,468,548.08 Fiscal Year To Date 2 ,403,883 .25 151,688,892.69 Effective Rate of Return 1.57% 1 .90% % of Portfolio 14 .54 25 .06 10 .91 3.16 7 .63 7 .10 21 .94 2 .18 0 .00 1.01 6.48 100.00% Term 1,422 1,588 1,533 1,375 588 City of La Quinta Days to YTM Maturity 1 1,095 603 1,054 880 377 365 Equiv. 0 .000 1.648 1.648 0 .980 1.709 1.557 2 .218 2 .497 0.000 0.000 0.000 1.406 I certify that this report accurately reflects all pooled investments and is in compliance with the California Government Code and the City Investment Policy . As Treasurer of the City of La Quinta , I hereby certify that sufficient investme nt liquidity and anticipated revenues are available to meet the City's expenditure requirements for the next six months . The City of La Quinta used the monthly account statements issued y our financial institutions to determine the fair market value of investments at month end . Karla Romero , Finance Director Reporting period 04/01/2020-04/30/2020 Run Date : 09/0812020 -13:56 Portfolio CITY CP PM (PRF _PM1 ) 7.3.0 Report Ver. 7.3.6.1 ATTACHMENT 1 City of La Quinta Portfolio Management April 30, 2020 City of La Quinta - Portfolio Summary % of Portfolio Book ValueInvestmentsMarket Value Par Value Days to MaturityTerm YTM 365 Equiv. Bank Accounts 22,311,057.26 114.54 0.000122,311,057.2622,311,057.26 Local Agency Investment Fund-City 38,463,512.61 125.06 1.648138,561,949.8438,463,512.61 Local Agency Invstmnt Fund-Housing 16,748,919.97 110.91 1.648116,776,931.4516,748,919.97 Money Market Accounts - CAMP 4,847,649.76 13.16 0.98014,847,649.764,847,649.76 Federal Agency Coupon Securities 11,703,992.36 1,4227.63 1.7091,09512,110,612.5011,750,000.00 Treasury Coupon Securities 10,897,535.00 1,5887.10 1.55760311,206,035.0011,000,000.00 Certificate of Deposits 33,665,000.00 1,53321.94 2.2181,05434,905,337.1433,665,000.00 Corporate Notes 3,341,010.00 1,3752.18 2.4978803,499,340.003,400,000.00 Money Market with Fiscal Agent 5,360.86 10.00 0.00015,360.865,360.86 CERBT - OPEB Trust 1,543,284.27 11.01 0.00011,543,284.271,543,284.27 PARS Pension Trust 9,941,225.99 16.48 0.00019,941,225.999,941,225.99 153,468,548.08 100.00%Investments 155,708,784.07153,676,010.72 588 377 1.406 Current Year April 30 196,608.57 Fiscal Year To Date 2,403,883.25 Average Daily Balance Effective Rate of Return 152,516,471.69 151,688,892.69 1.90%1.57% Total Earnings Month Ending I certify that this report accurately reflects all pooled investments and is in compliance with the California Government Code and the City Investment Policy. As Treasurer of the City of La Quinta, I hereby certify that sufficient investment liquidity and anticipated revenues are available to meet the City's expenditure requirements for the next six months. The City of La Quinta used the monthly account statements issued by our financial institutions to determine the fair market value of investments at month end. __________________________________________________ ____________________ Karla Romero, Finance Director Portfolio CITY CP Reporting period 04/01/2020-04/30/2020 Run Date: 09/08/2020 - 13:56 PM (PRF_PM1) 7.3.0 Report Ver. 7.3.6.1 Days to Maturity Page 1 Par Value Book Value Maturity Date Stated RateMarket Value April 30, 2020 Portfolio Details - Investments Average BalanceIssuer Portfolio Management City of La Quinta YTM 365TermCUSIPInvestment # Purchase Date Bank Accounts 1Bank of the West1228 19,588,385.02 19,588,385.0208/20/2019 19,588,385.02 1059731851 0.000 1City Petty Cash1059 3,300.00 3,300.0007/01/2016 3,300.00 1SYS1059 0.000 1La Quinta Palms Realty1062 205,687.49 205,687.4907/01/2016 205,687.49 1SYS1062 0.000 1Stifel, Nicolaus & Company1183 1,760,299.25 1,760,299.2503/18/2019 1,760,299.25 1SYS1183 0.000 1Wells Fargo1057 753,385.50 753,385.5007/01/2016 753,385.50 14159282482 0.000 22,311,057.26 122,311,057.2622,311,057.268,133,655.14Subtotal and Average 1 0.000 Local Agency Investment Fund-City 1Local Agency Inv Fund1055 38,463,512.61 38,463,512.61 1.64838,561,949.84 198-33-434 1.648 38,463,512.61 138,561,949.8438,463,512.6136,783,174.59Subtotal and Average 1 1.648 Local Agency Invstmnt Fund-Housing 1Local Agency Inv Fund1113 16,748,919.97 16,748,919.97 1.64816,776,931.45 125-33-005 1.648 16,748,919.97 116,776,931.4516,748,919.9716,709,779.64Subtotal and Average 1 1.648 Money Market Accounts - CAMP 1California Asset Management Pr1153 4,847,649.76 4,847,649.76 0.98009/26/2018 4,847,649.76 1SYS1153 0.980 4,847,649.76 14,847,649.764,847,649.7619,332,552.21Subtotal and Average 1 0.980 Federal Agency Coupon Securities 488Federal Farm Credit Bank1105 1,000,000.00 992,200.00 09/01/20211.70011/09/2017 1,018,910.00 1,3923133EHWM1 1.913 7Federal Farm Credit Bank1142 500,000.00 491,750.00 05/08/20201.55005/31/2018 500,185.00 7083133EHJA2 2.427 1,222Federal Farm Credit Bank1158 250,000.00 247,275.00 09/05/20232.80010/15/2018 269,192.50 1,7863133EJYL7 3.041 955Federal Farm Credit Bank1198 500,000.00 499,500.00 12/12/20221.87506/20/2019 519,150.00 1,2713133EKQP4 1.905 1,547Federal Farm Credit Bank1212 500,000.00 499,500.00 07/26/20241.85008/02/2019 525,880.00 1,8203133EKWV4 1.871 1,200Federal Farm Credit Bank1223 500,000.00 499,400.00 08/14/20231.60009/12/2019 518,325.00 1,4323133EKZK5 1.632 1,600Federal Farm Credit Bank1224 500,000.00 498,750.00 09/17/20241.60009/17/2019 520,875.00 1,8273133EKP75 1.652 1,279Federal Farm Credit Bank1234 1,000,000.00 996,900.00 11/01/20231.60011/01/2019 1,037,910.00 1,4613133EK4X1 1.680 1,600Federal Farm Credit Bank1242 1,000,000.00 998,600.00 09/17/20241.70012/17/2019 1,046,060.00 1,7363133ELEA8 1.731 1,384Federal Farm Credit Bank1246 1,000,000.00 999,000.00 02/14/20241.43002/14/2020 1,035,770.00 1,4613133ELNE0 1.456 881Federal Farm Credit Bank1247 1,000,000.00 999,217.36 09/29/20221.40002/05/2020 1,024,380.00 9673133EGWJ0 1.430 133Federal Home Loan Bank1104 1,000,000.00 996,800.00 09/11/20201.62511/09/2017 1,005,190.00 1,0373130A66T9 1.741 1,383Federal Home Loan Bank1177 500,000.00 498,550.00 02/13/20242.50003/01/2019 538,135.00 1,8103130AFW94 2.563 1,816Federal Home Loan Mtg Corp1275 1,000,000.00 998,500.00 04/21/20250.70004/28/2020 998,990.00 1,8193134GVLC0 0.731 1,523Federal National Mtg Assn1206 500,000.00 495,950.00 07/02/20241.75007/15/2019 525,790.00 1,8143135G0V75 1.922 858Federal National Mtg Assn1233 1,000,000.00 992,100.00 09/06/20221.37510/29/2019 1,025,870.00 1,0433135G0W33 1.659 Portfolio CITY CP Run Date: 09/08/2020 - 13:56 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, 2020 Portfolio Details - Investments Average BalanceIssuer Portfolio Management City of La Quinta YTM 365TermCUSIPInvestment # Purchase Date 11,703,992.36 1,42212,110,612.5011,750,000.0013,047,467.36Subtotal and Average 1,095 1.709 Treasury Coupon Securities 425U.S. Treasury1045 5,000,000.00 5,000,000.00 06/30/20211.12507/18/2016 5,055,850.00 1,808912828S27 1.125 548U.S. Treasury1070 2,000,000.00 1,942,800.00 10/31/20211.25003/27/2017 2,031,960.00 1,679912828T67 1.903 106U.S. Treasury1117 1,000,000.00 985,800.00 08/15/20201.50001/22/2018 1,004,140.00 9369128282Q2 2.071 882U.S. Treasury1178 500,000.00 489,687.50 09/30/20221.87503/01/2019 519,885.00 1,3099128282W9 2.480 744U.S. Treasury1192 500,000.00 496,650.00 05/15/20221.75005/31/2019 515,725.00 1,080912828SV3 1.984 395U.S. Treasury1193 500,000.00 493,610.00 05/31/20211.37505/31/2019 506,525.00 731912828R77 2.030 1,247U.S. Treasury1217 500,000.00 499,300.00 09/30/20231.37508/21/2019 518,710.00 1,501912828T26 1.410 1,674U.S. Treasury1241 1,000,000.00 989,687.50 11/30/20241.50012/16/2019 1,053,240.00 1,811912828YV6 1.718 10,897,535.00 1,58811,206,035.0011,000,000.0011,369,510.00Subtotal and Average 603 1.557 Certificate of Deposits 1,582First State Bk DeQueen1222 248,000.00 248,000.00 08/30/20241.80008/30/2019 257,848.08 1,827336460CX6 1.802 1,824First Freedom Bank1273 249,000.00 249,000.00 04/29/20251.20004/29/2020 251,432.73 1,82632027BAL1 1.201 1,575FirsTier Bank1216 249,000.00 249,000.00 08/23/20241.95008/23/2019 260,458.98 1,82733766LAJ7 1.952 1,823Firrst Natl Bk McGregor1274 248,000.00 248,000.00 04/28/20251.35004/28/2020 252,240.80 1,82632112UDR9 1.351 1,175First National Bank of America1147 245,000.00 245,000.00 07/20/20233.15007/20/2018 263,308.85 1,82632110YLK9 3.152 1,099First National Bank1179 248,000.00 248,000.00 05/05/20232.80003/05/2019 262,765.92 1,52232117BCX4 2.802 1,582First Natl Bk of Syracuse1221 249,000.00 249,000.00 08/30/20241.85008/30/2019 259,415.67 1,827334342CD2 1.852 1,750First National Bank Michigan1250 248,000.00 248,000.00 02/14/20251.65002/14/2020 256,025.28 1,82732114VBT3 1.652 1,551First Security Bank of WA1209 248,000.00 248,000.00 07/30/20242.00007/30/2019 259,904.00 1,82733625CCP2 2.002 1,475First Service Bank1231 248,000.00 248,000.00 05/15/20241.70011/15/2019 256,791.60 1,64333640VDD7 1.701 565First Source Bank1168 245,000.00 245,000.00 11/17/20213.15012/17/2018 254,635.85 1,06633646CKP8 3.153 171First Tech Federal Credit Unio1124 245,000.00 245,000.00 10/19/20202.70004/18/2018 247,699.90 91533715LBJ8 2.623 640Third Federal Savings and Loan1112 245,000.00 245,000.00 01/31/20222.50001/30/2018 252,891.45 1,46288413QBY3 2.502 1,547Abacus Federal Savings1207 248,000.00 248,000.00 07/26/20241.95007/26/2019 259,380.72 1,82700257TBD7 1.952 1,777Access Bank1256 248,000.00 248,000.00 03/13/20251.60003/13/2020 255,382.96 1,82600435JBH5 1.601 773Allegiance Bank1143 245,000.00 245,000.00 06/13/20223.10006/13/2018 257,299.00 1,46101748DBE5 3.102 895Alliance Credit Union1095 245,000.00 245,000.00 10/13/20222.25010/13/2017 253,971.90 1,82601859BAA3 2.251 311Ally Bank Midvale1176 245,000.00 245,000.00 03/08/20212.50003/07/2019 249,517.80 73202007GHX4 2.016 1,792Alma Bank1267 248,000.00 248,000.00 03/28/20251.40003/30/2020 252,967.44 1,824020080BX4 1.399 788America's Credit Union1200 248,000.00 248,000.00 06/28/20222.30006/28/2019 248,786.16 1,09603065AAL7 2.302 1,757American State1255 248,000.00 248,000.00 02/21/20251.60002/21/2020 255,427.60 1,827029728BC5 1.602 353Amex Centurion1077 240,000.00 240,000.00 04/19/20212.25004/19/2017 244,159.20 1,46102587DP85 2.252 850American Express Fed Savings B1096 240,000.00 240,000.00 08/29/20222.40008/29/2017 248,436.00 1,82602587CFU9 2.402 Portfolio CITY CP Run Date: 09/08/2020 - 13:56 PM (PRF_PM2) 7.3.0 Days to Maturity Page 3 Par Value Book Value Maturity Date Stated RateMarket Value April 30, 2020 Portfolio Details - Investments Average BalanceIssuer Portfolio Management City of La Quinta YTM 365TermCUSIPInvestment # Purchase Date Certificate of Deposits 1,174American National Bank1205 248,000.00 248,000.00 07/19/20232.00007/19/2019 257,456.24 1,46102772JBD1 2.001 1,055Aneca Federal Credit Union1119 245,000.00 245,000.00 03/22/20232.80003/22/2018 259,109.55 1,826034577AH9 2.802 1,790Axos Bank1258 248,000.00 248,000.00 03/26/20251.65003/26/2020 255,945.92 1,82605465DAE8 1.651 907Barclays Bank1097 240,000.00 240,000.00 10/25/20222.30010/25/2017 249,182.40 1,82606740KLJ4 2.291 1,337Bar Harbor Bank and Trust1172 248,000.00 248,000.00 12/29/20233.35012/31/2018 270,843.28 1,824066851WJ1 3.352 1,446Belmont Bank and Trust1270 248,000.00 248,000.00 04/16/20241.25004/16/2020 252,349.92 1,46108016PDQ9 1.251 698Bellco Credit Union1264 248,000.00 248,000.00 03/30/20221.30003/31/2020 250,909.04 72907833EAD9 1.300 570Belmont Savings Bank1102 245,000.00 245,000.00 11/22/20212.10011/21/2017 250,659.50 1,462080515CD9 2.101 664BMW Bank1067 240,000.00 240,000.00 02/24/20222.20002/24/2017 246,662.40 1,82605580AGK4 2.201 258Bankers Bank1086 240,000.00 240,000.00 01/14/20211.80007/14/2017 242,599.20 1,28006610RAP4 1.804 1,610BankWest Inc1227 248,000.00 248,000.00 09/27/20241.70009/27/2019 256,769.28 1,82706652CHB0 1.702 699Cadence Bank, NA1259 245,000.00 245,000.00 03/31/20221.20003/31/2020 247,423.05 73012738RFX7 1.200 402Capital One Natl Assn FDIC42971082 240,000.00 240,000.00 06/07/20212.25006/07/2017 244,569.60 1,46114042RGD7 2.252 1,803Capital One USA FDIC339541271 245,000.00 245,000.00 04/08/20251.60004/08/2020 252,222.60 1,82614042TDD6 1.601 297Comenity Capital Bank1009 240,000.00 240,000.00 02/22/20211.70002/22/2016 242,680.80 1,82720033APG5 1.702 1,582Celtic Bank1220 248,000.00 248,000.00 08/30/20241.85008/30/2019 258,373.84 1,82715118RRH2 1.852 1,476Century Next Bank1184 248,000.00 248,000.00 05/16/20242.50005/29/2019 264,757.36 1,814156634AK3 2.503 1,763Citadel FCU1252 248,000.00 248,000.00 02/27/20251.65002/27/2020 255,998.00 1,82717286TAG0 1.652 844CIT Bank NA1219 245,000.00 245,000.00 08/23/20221.90008/23/2019 251,570.90 1,09612556LBA3 1.902 1,075Citibank NA1123 245,000.00 245,000.00 04/11/20232.90004/11/2018 260,035.65 1,82617312QJ26 2.902 1,795Commonwealth Business Bk1268 248,000.00 248,000.00 03/31/20251.25003/31/2020 251,171.92 1,8262027506M2 1.251 439Central State Bank1085 240,000.00 240,000.00 07/14/20211.85007/14/2017 243,775.20 1,46115523RBJ4 1.851 1,293Commercial Bank1162 248,000.00 248,000.00 11/15/20233.40011/15/2018 270,508.48 1,82620143PDV9 3.402 1,519Communitywide FCU1202 248,000.00 248,000.00 06/28/20242.25006/28/2019 262,379.04 1,82720416TAQ5 2.253 1,092Congressional Bank1189 248,000.00 248,000.00 04/28/20232.50004/30/2019 260,486.80 1,45920726ABA5 2.502 931CrossFirst Bank1106 245,000.00 245,000.00 11/18/20222.20011/20/2017 253,944.95 1,82422766ACB9 2.201 1,512Citizens State Bank1199 248,000.00 248,000.00 06/21/20242.40006/21/2019 263,862.08 1,827176688CP2 2.403 641Discover Bank Greenwood DE CF1066 240,000.00 240,000.00 02/01/20222.25002/01/2017 246,693.60 1,8262546722U1 2.251 264Eagle Bank1146 245,000.00 245,000.00 01/20/20212.85007/20/2018 249,583.95 91527002YDV5 2.858 1,092EnerBank USA1125 240,000.00 240,000.00 04/28/20232.95004/30/2018 255,280.80 1,82429278TAY6 2.952 941Enterprise Bank, NA1107 245,000.00 245,000.00 11/28/20222.15011/28/2017 253,702.40 1,82629367QCP1 2.151 1,503Evansville Teachers Credit FCU1196 248,000.00 248,000.00 06/12/20242.60006/12/2019 265,826.24 1,827299547AQ2 2.603 35EverBank1017248,000.00 248,000.00 06/05/20201.70006/05/2015 248,334.80 1,82729976DXX3 1.702 262Farm Bureau Bank1165 248,000.00 248,000.00 01/18/20213.00012/17/2018 252,868.24 763307660LC2 2.898 728Farmers Insurance Group FCU1126 240,000.00 240,000.00 04/29/20222.80004/30/2018 250,010.40 1,46030960QAG2 2.802 1,825Flagstar1276248,000.00 248,000.00 04/30/20251.25004/30/2020 251,020.64 1,82633847E3A3 1.251 Portfolio CITY CP Run Date: 09/08/2020 - 13:56 PM (PRF_PM2) 7.3.0 Days to Maturity Page 4 Par Value Book Value Maturity Date Stated RateMarket Value April 30, 2020 Portfolio Details - Investments Average BalanceIssuer Portfolio Management City of La Quinta YTM 365TermCUSIPInvestment # Purchase Date Certificate of Deposits 1,750Freedom Financial1248 248,000.00 248,000.00 02/14/20251.55002/14/2020 254,864.64 1,82735637RDC8 1.552 235Freedom Credit Union1111 245,000.00 245,000.00 12/22/20202.05012/22/2017 247,788.10 1,09635638BAA9 2.052 472General Electric Credit Union1150 240,000.00 240,000.00 08/16/20213.10008/15/2018 247,862.40 1,097369674AV8 3.100 725Goldman Sachs1078 240,000.00 240,000.00 04/26/20222.40004/26/2017 248,088.00 1,82638148PJK4 2.401 73First Bank of Highland1094 240,000.00 240,000.00 07/13/20201.75007/13/2017 240,688.80 1,096319141GT8 1.752 1,483Iowa State Bank1186 245,000.00 245,000.00 05/23/20242.40005/23/2019 260,515.85 1,82746256YAZ2 2.403 1,266Jefferson Financial CU1154 245,000.00 245,000.00 10/19/20233.35010/19/2018 266,386.05 1,826474067AQ8 3.352 11Jefferson Bank & Trust1100 245,000.00 245,000.00 05/12/20201.75011/09/2017 245,115.15 915472376AC6 1.735 1,476JP Morgan Chase1185 245,000.00 245,000.00 05/16/20243.25005/16/2019 235,126.50 1,82748128HXU7 3.254 746Kansas State Bank1101 245,000.00 245,000.00 05/17/20222.10011/17/2017 251,945.75 1,64250116CBE8 2.099 973Kern FCU1239 248,000.00 248,000.00 12/30/20221.90012/30/2019 255,415.20 1,09649228XAK6 1.902 972Knoxville TVA Credit Union1110 245,000.00 245,000.00 12/29/20222.40012/29/2017 255,549.70 1,826499724AB8 2.401 1,510Legacy Bank1197 248,000.00 248,000.00 06/19/20242.40006/19/2019 263,854.64 1,827524661CB9 2.403 1,488Live Oak Bank1238 248,000.00 248,000.00 05/28/20241.80011/27/2019 257,791.04 1,644538036GV0 1.802 1,368Lakeside Bank1208 248,000.00 248,000.00 01/29/20242.00007/30/2019 258,983.92 1,64451210SQU4 2.003 686Luana Savings Bank1225 245,000.00 245,000.00 03/18/20221.60009/18/2019 249,245.85 912549104JN8 1.599 668Maine Savings FCU1171 248,000.00 248,000.00 02/28/20223.30012/28/2018 259,861.84 1,158560507AK1 3.306 1,456Main Street Bank1188 248,000.00 248,000.00 04/26/20242.60004/26/2019 265,518.72 1,82756065GAG3 2.603 1,264Marlin Business Bank1155 248,000.00 248,000.00 10/17/20233.30010/17/2018 269,174.24 1,82657116ARV2 3.302 950Medallion Bank1169 248,000.00 248,000.00 12/07/20223.40012/07/2018 264,864.00 1,46158404DCX7 3.402 67Mercantile Bank of Michigan1087 240,000.00 240,000.00 07/07/20201.75007/07/2017 240,633.60 1,09658740XZL7 1.752 42Bank Midwest1002 248,000.00 248,000.00 06/12/20201.65006/12/2015 248,376.96 1,827063615AVO 1.652 1,664Morgan Stanley Bank1237 245,000.00 245,000.00 11/20/20241.95011/20/2019 256,328.80 1,82761690UNX4 1.952 1,145Morton Community1173 248,000.00 248,000.00 06/20/20232.75003/20/2019 262,986.64 1,553619165JD6 2.753 910Merrick Bank1163 248,000.00 248,000.00 10/28/20223.25010/30/2018 263,336.32 1,45959013J4K2 3.252 1,664Morgan Stanley Private Bk, NA1236 245,000.00 245,000.00 11/20/20241.90011/20/2019 255,782.45 1,82761760A3B3 1.902 921Mountain America Federal CU1099 245,000.00 245,000.00 11/08/20222.30011/08/2017 254,469.25 1,82662384RAC0 2.301 1,264Municipal Trust and Savings1160 245,000.00 245,000.00 10/17/20233.20010/17/2018 265,082.65 1,826625925AR3 3.202 1,795Nicolet Natl Bank1266 248,000.00 248,000.00 03/31/20251.40003/31/2020 252,957.52 1,826654062JZ2 1.401 599Neighbors FCU1167 245,000.00 245,000.00 12/21/20213.20012/21/2018 255,287.55 1,09664017AAQ7 3.203 276Infinty FCU1211 248,000.00 248,000.00 02/01/20212.10007/31/2019 251,419.92 55145667EDY1 2.110 1,329National Cooperative Bank, N.A1170 245,000.00 245,000.00 12/21/20233.40012/21/2018 267,834.00 1,826635573AL2 3.402 1,306Numerica Credit Union1164 248,000.00 248,000.00 11/28/20233.55011/28/2018 272,046.08 1,82667054NAN3 3.552 543Northpointe Bank1127 240,000.00 240,000.00 10/26/20212.70004/26/2018 247,476.00 1,279666613GV0 2.703 1,064Northstar Bank1263 248,000.00 248,000.00 03/31/20231.15003/31/2020 250,564.32 1,09566704MEQ0 1.150 1,383Northwest Bank1181 248,000.00 248,000.00 02/13/20242.95002/13/2019 267,877.20 1,82666736ABP3 2.951 Portfolio CITY CP Run Date: 09/08/2020 - 13:56 PM (PRF_PM2) 7.3.0 Days to Maturity Page 5 Par Value Book Value Maturity Date Stated RateMarket Value April 30, 2020 Portfolio Details - Investments Average BalanceIssuer Portfolio Management City of La Quinta YTM 365TermCUSIPInvestment # Purchase Date Certificate of Deposits 1,186Bank of New England1151 249,000.00 249,000.00 07/31/20233.25007/31/2018 268,581.36 1,82606426KAN8 3.252 514New York Community Bank1226 245,000.00 245,000.00 09/27/20211.80009/27/2019 249,201.75 731649447TC3 1.802 628The Ohio Valley Bank1089 240,000.00 240,000.00 01/19/20221.90007/19/2017 245,150.40 1,645677721CN0 1.903 1,446Pacific Western Bank1269 245,000.00 245,000.00 04/16/20241.30004/16/2020 249,777.50 1,46169506YRH4 1.301 768PCSB Bank1149 245,000.00 245,000.00 06/08/20223.00006/08/2018 256,718.35 1,46169324MAD7 3.002 1,552People's Bank1210 248,000.00 248,000.00 07/31/20242.00007/31/2019 259,906.48 1,827710571DS6 2.002 1,132Pittsfield Cooperative Bank1194 245,000.00 245,000.00 06/07/20232.50006/07/2019 257,749.80 1,461725404AB3 2.502 1,498Plains Commerce Bank1195 245,000.00 245,000.00 06/07/20242.55006/07/2019 262,069.15 1,82772651LCL6 2.553 1,568Preferred Bank1213 249,000.00 249,000.00 08/16/20242.00008/16/2019 260,974.41 1,827740367HP5 2.002 390PrivateBank & Trust1032 240,000.00 240,000.00 05/26/20211.50005/26/2016 242,784.00 1,82674267GVG9 1.501 1,209Raymond James Bank1218 244,000.00 244,000.00 08/23/20231.95008/23/2019 253,171.96 1,46175472RAD3 1.951 1,145RCB Bank1144 245,000.00 245,000.00 06/20/20233.15006/20/2018 262,840.90 1,82674934YAH4 3.152 950Red Rocks Credit Union1166 248,000.00 248,000.00 12/07/20223.35012/07/2018 264,544.08 1,46175701LAB3 3.352 1,519Revere Bank1203 247,000.00 247,000.00 06/28/20242.30006/28/2019 261,805.18 1,827761402BY1 2.303 206First Bank Richmond1081 245,000.00 245,000.00 11/23/20201.80006/21/2017 247,080.05 1,251319267GC8 1.802 1,382Rollstone B&T1251 245,000.00 245,000.00 02/12/20241.65002/12/2020 252,756.70 1,46177579ADF0 1.651 781Sallie Mae Bank Salt Lake CIty1083 240,000.00 240,000.00 06/21/20222.35006/21/2017 248,340.00 1,826795450A70 2.351 1,651Sauk Valley B&T Co1235 248,000.00 248,000.00 11/07/20241.70011/07/2019 256,734.56 1,827804375DL4 1.702 1,026Servisfirst Bank1254 248,000.00 248,000.00 02/21/20231.60002/21/2020 253,637.04 1,09681768PAF3 1.601 973San Francisco FCU1240 248,000.00 248,000.00 12/30/20221.85012/30/2019 248,322.40 1,09679772FAC0 1.852 699Bank of Santa Clarita1261 248,000.00 248,000.00 03/31/20221.10003/31/2020 249,969.12 73006424KBC3 1.100 1,784Spring Bank1257 248,000.00 248,000.00 03/20/20251.50003/20/2020 254,182.64 1,826849430BF9 1.501 850Sterling Bank1201 245,000.00 245,000.00 08/29/20222.15006/28/2019 253,026.20 1,15885916VDC6 2.153 762Synchrony Bank Retail1080 240,000.00 240,000.00 06/02/20222.40006/02/2017 248,409.60 1,82687164XQV1 2.401 769Synovus Bank1253 245,000.00 245,000.00 06/09/20221.60003/09/2020 249,579.05 82287164DRD4 1.602 1,427Texas Bank Financial1260 245,000.00 245,000.00 03/28/20241.10003/31/2020 242,212.14 1,458882213AB7 1.101 1,445The Jefferson Bank1272 248,000.00 248,000.00 04/15/20241.25004/15/2020 252,347.44 1,461472382AQ3 1.251 364Towne Bank1128 240,000.00 240,000.00 04/30/20212.80004/30/2018 245,544.00 1,09689214PBL2 2.803 829Traditions Bank1148 245,000.00 245,000.00 08/08/20223.00006/08/2018 257,544.00 1,52289269CBX9 3.002 1,246Triad Bank1262 248,000.00 248,000.00 09/29/20231.35003/30/2020 252,595.44 1,27889579NCD3 1.352 570TNB Bank1187 248,000.00 248,000.00 11/22/20212.40005/22/2019 254,884.48 91587266AAA1 2.407 1,264UBS Bank USA1161 245,000.00 245,000.00 10/17/20233.35010/17/2018 266,337.05 1,82690348JEJ5 3.352 319Unity Bank1120 245,000.00 245,000.00 03/16/20212.55003/16/2018 249,655.00 1,09691330ABN6 2.552 1,743United Community1249 248,000.00 248,000.00 02/07/20251.65002/07/2020 256,037.68 1,82790983WBT7 1.652 600United Credit Union1214 248,000.00 248,000.00 12/22/20212.00008/22/2019 253,560.16 853910160AH3 2.003 1,109University of Iowa Comm. CU1134 240,000.00 240,000.00 05/15/20233.05005/14/2018 256,221.60 1,82791435LAG2 3.052 Portfolio CITY CP Run Date: 09/08/2020 - 13:56 PM (PRF_PM2) 7.3.0 Days to Maturity Page 6 Par Value Book Value Maturity Date Stated RateMarket Value April 30, 2020 Portfolio Details - Investments Average BalanceIssuer Portfolio Management City of La Quinta YTM 365TermCUSIPInvestment # Purchase Date Certificate of Deposits 1,033Verus Bank of Commerce1180 248,000.00 248,000.00 02/28/20232.70002/28/2019 261,290.32 1,46192535LCD4 2.700 1,397Wells Fargo1174 248,000.00 248,000.00 02/27/20243.00002/27/2019 266,533.04 1,826949763XY7 3.001 1,064West Michigan Cmnty Bk1265 248,000.00 248,000.00 03/31/20231.15003/31/2020 250,564.32 1,095954444BS3 1.150 45Wex Bank1145 245,000.00 245,000.00 06/15/20202.75006/13/2018 245,749.70 73392937CHG6 2.754 1,004Wells Fargo Natl Bank West1244 248,000.00 248,000.00 01/30/20231.90001/29/2020 255,593.76 1,097949495AT2 1.900 1,575Washington Federal1215 248,000.00 248,000.00 08/23/20242.00008/23/2019 259,938.72 1,827938828BH2 2.002 33,665,000.00 1,53334,905,337.1433,665,000.0032,718,000.00Subtotal and Average 1,054 2.218 Corporate Notes 460Apple Inc1079 500,000.00 493,050.00 08/04/20211.55006/12/2017 504,690.00 1,514037833CC2 1.900 1,006Colgate-Palmolive1175 500,000.00 485,250.00 02/01/20231.95003/04/2019 525,265.00 1,43019416QEA4 2.751 1,194Microsoft Corporation1157 400,000.00 378,360.00 08/08/20232.00010/15/2018 417,300.00 1,758594918BQ6 3.222 646Proctor and Gamble1159 500,000.00 487,950.00 02/06/20222.30010/15/2018 515,010.00 1,210742718DY2 3.071 342Toyota Motor Credit Corp1204 500,000.00 499,750.00 04/08/20211.90006/24/2019 503,105.00 65489236TCZ6 1.928 1,620Toyota Motor Credit Corp1232 500,000.00 500,000.00 10/07/20242.00010/23/2019 511,805.00 1,81189236TGL3 2.000 958Wal-Mart Stores, Inc1190 500,000.00 496,650.00 12/15/20222.35004/16/2019 522,165.00 1,339931142DU4 2.799 3,341,010.00 1,3753,499,340.003,400,000.003,341,010.00Subtotal and Average 880 2.497 Money Market with Fiscal Agent 1US Bank1058 5,360.86 5,360.8607/01/2016 5,360.86 1SYS1058 0.000 5,360.86 15,360.865,360.865,275.83Subtotal and Average 1 0.000 CERBT - OPEB Trust 1CalPERS CERBT Plan1114 1,543,284.27 1,543,284.2707/01/2019 1,543,284.27 1SYS1114 0.000 1,543,284.27 11,543,284.271,543,284.271,543,284.27Subtotal and Average 1 0.000 PARS Pension Trust 1Pblc Agncy Rtrmnt Serv1230 9,941,225.99 9,941,225.9908/01/2019 9,941,225.99 1SYS1230 0.000 9,941,225.99 19,941,225.999,941,225.999,532,762.65Subtotal and Average 1 0.000 588152,516,471.69 153,676,010.72 377 1.406155,708,784.07 153,468,548.08Total and Average Portfolio CITY CP Run Date: 09/08/2020 - 13:56 PM (PRF_PM2) 7.3.0 City of La Quinta Total Earnings City of La Quinta - Sorted by Fund - Fund April 1, 2020 - April 30, 2020 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 248,000.001002248,000.00 1.650MIDWES 336.33 0.00 336.331.650101248,000.00063615AVO 0.00 0.0010060.00 1.900CAPONE 63.77 0.00 125.023.725101245,000.00140420RX0 61.25 240,000.001009240,000.00 1.700CCBA 335.34 0.00 335.341.700101240,000.0020033APG5 0.00 248,000.001017248,000.00 1.700EVRBA 346.53 0.00 346.531.700101248,000.0029976DXX3 0.00 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,635.99 0.00 4,635.991.1281015,000,000.00912828S27 0.00 0.0010530.00 1.350FHLB 2,531.25 0.00 11,281.256.1221012,491,250.003130A7QZ1 8,750.00 38,463,512.61105538,463,512.61 1.648LAIF 44,280.69 0.00 44,280.691.57110134,291,359.4198-33-434 0.00 753,385.501057753,385.50WELLS 0.01 0.00 0.011012,873,417.204159282482 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.98 0.00 433.982.200101240,000.0005580AGK4 0.00 1,942,800.0010702,000,000.00 1.250USTR 2,059.69 0.00 2,059.691.2901011,942,800.00912828T67 0.00 0.0010760.00 1.600STRNS 220.93 0.00 220.931.600101240,000.00857894TC3 0.00 240,000.001077240,000.00 2.250AMEX 443.83 0.00 443.832.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 245,000.001081245,000.00 1.800RICHMN 362.47 0.00 362.471.800101245,000.00319267GC8 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.001086240,000.00 1.800BNKRS 355.07 0.00 355.071.800101240,000.0006610RAP4 0.00 240,000.001087240,000.00 1.750MERCTL 345.21 0.00 345.211.750101240,000.0058740XZL7 0.00 240,000.001089240,000.00 1.900OHVAL 374.79 0.00 374.791.900101240,000.00677721CN0 0.00 240,000.001094240,000.00 1.750HIGHLD 345.21 0.00 345.211.750101240,000.00319141GT8 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 Portfolio CITY CP Run Date: 09/08/2020 - 14:00 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, 2020 - April 30, 2020 Total Earnings City of La Quinta Annualized YieldCUSIPInvestment # Interest EarnedIssuer Realized Gainl/Loss Fund: General Fund 245,000.001100245,000.00 1.750JFFRSN 352.40 0.00 352.401.750101245,000.00472376AC6 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 996,800.0011041,000,000.00 1.625FHLB 1,354.16 0.00 1,354.161.653101996,800.003130A66T9 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.001111245,000.00 2.050FREECU 412.81 0.00 412.812.050101245,000.0035638BAA9 0.00 245,000.001112245,000.00 2.5003RD 503.43 0.00 503.432.500101245,000.0088413QBY3 0.00 1,543,284.2711141,543,284.27CALPRS 0.00 0.00 0.001011,543,284.27SYS1114 0.00 985,800.0011171,000,000.00 1.500USTR 1,236.27 0.00 1,236.271.526101985,800.009128282Q2 0.00 245,000.001119245,000.00 2.800ANECA 563.83 0.00 563.832.800101245,000.00034577AH9 0.00 245,000.001120245,000.00 2.550UNITY 513.49 0.00 513.492.550101245,000.0091330ABN6 0.00 245,000.001123245,000.00 2.900CITINA 583.97 0.00 583.972.900101245,000.0017312QJ26 0.00 245,000.001124245,000.00 2.7001STTCH 543.70 0.00 543.702.700101245,000.0033715LBJ8 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 240,000.001127240,000.00 2.700NORPNT 532.60 0.00 532.602.700101240,000.00666613GV0 0.00 240,000.001128240,000.00 2.800TOWNE 552.33 0.00 552.332.800101240,000.0089214PBL2 0.00 240,000.001134240,000.00 3.050UOFICU 601.64 0.00 601.643.050101240,000.0091435LAG2 0.00 0.0011380.00 1.125USTR 448.15 0.00 12,198.1531.445101488,250.00912828VA5 11,750.00 491,750.001142500,000.00 1.550FFCB 645.84 0.00 645.841.598101491,750.003133EHJA2 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.001145245,000.00 2.750WEX 553.77 0.00 553.772.750101245,000.0092937CHG6 0.00 245,000.001146245,000.00 2.850EAGLE 573.90 0.00 573.902.850101245,000.0027002YDV5 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 4,847,649.7611534,847,649.76 0.980CAMP 15,618.16 0.00 15,618.160.95810119,832,031.60SYS1153 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 Portfolio CITY CP Run Date: 09/08/2020 - 14:00 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, 2020 - April 30, 2020 Total Earnings City of La Quinta Annualized YieldCUSIPInvestment # Interest EarnedIssuer Realized Gainl/Loss Fund: General Fund 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.001165248,000.00 3.000FARMBU 611.51 0.00 611.513.000101248,000.00307660LC2 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.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.65 0.00 684.653.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 245,000.001176245,000.00 2.500ALLY 503.42 0.00 503.422.500101245,000.0002007GHX4 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 1,760,299.2511831,760,299.25STIFEL 6.83 0.00 6.830.0081011,000,000.00SYS1183 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.46 0.00 654.463.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 721.15 0.00 721.151.767101496,650.00912828SV3 0.00 493,610.001193500,000.00 1.375USTR 563.53 0.00 563.531.389101493,610.00912828R77 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 Portfolio CITY CP Run Date: 09/08/2020 - 14:00 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, 2020 - April 30, 2020 Total Earnings City of La Quinta Annualized YieldCUSIPInvestment # Interest EarnedIssuer Realized Gainl/Loss Fund: General Fund 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 499,750.001204500,000.00 1.900TOYOTA 791.66 0.00 791.661.927101499,750.0089236TCZ6 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 248,000.001211248,000.00 2.100NFNITY 428.05 0.00 428.052.100101248,000.0045667EDY1 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 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 19,588,385.02122819,588,385.02BOTW 0.01 0.00 0.011013,970,011.71059731851 0.00 9,941,225.9912309,941,225.99PARS 0.00 0.00 0.001019,518,905.38SYS1230 0.00 248,000.001231248,000.00 1.7001STSER 346.52 0.00 346.521.700101248,000.0033640VDD7 0.00 500,000.001232500,000.00 2.000TOYOTA 833.34 0.00 833.342.028101500,000.0089236TGL3 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 Portfolio CITY CP Run Date: 09/08/2020 - 14:00 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, 2020 - April 30, 2020 Total Earnings City of La Quinta Annualized YieldCUSIPInvestment # Interest EarnedIssuer Realized Gainl/Loss Fund: General Fund 245,000.001236245,000.00 1.900MSPRIV 382.61 0.00 382.611.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.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.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 248,000.001268248,000.00 1.250CMWBUS 254.80 0.00 254.801.250101248,000.002027506M2 0.00 245,000.001269245,000.00 1.300PACWST 130.89 0.00 130.891.3001010.0069506YRH4 0.00 248,000.001270248,000.00 1.250BELB&T 118.90 0.00 118.901.2501010.0008016PDQ9 0.00 245,000.001271245,000.00 1.600CAPONE 247.01 0.00 247.011.6001010.0014042TDD6 0.00 248,000.001272248,000.00 1.250THEJEF 127.40 0.00 127.401.2501010.00472382AQ3 0.00 249,000.001273249,000.00 1.2001STFDM 8.19 0.00 8.191.2011010.0032027BAL1 0.00 248,000.001274248,000.00 1.3501STMCG 18.35 0.00 18.351.3501010.0032112UDR9 0.00 Portfolio CITY CP Run Date: 09/08/2020 - 14:00 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, 2020 - April 30, 2020 Total Earnings City of La Quinta Annualized YieldCUSIPInvestment # Interest EarnedIssuer Realized Gainl/Loss Fund: General Fund 998,500.0012751,000,000.00 0.700FHLMC 58.33 0.00 58.330.7111010.003134GVLC0 0.00 248,000.001276248,000.00 1.250FLGSTR 8.49 0.00 8.491.2501010.0033847E3A3 0.00 136,716,042.40Subtotal 136,508,579.76 1.607 176,404.880.00155,843.63133,374,846.93 20,561.25 Fund: Fiscal Agent 5,360.8610585,360.86USBANK 87.96 0.00 87.9620.2962315,272.90SYS1058 0.00 5,360.86Subtotal 5,360.86 20.296 87.960.0087.965,272.90 0.00 Fund: Housing Authority : WSA and LQ 205,687.491062205,687.49LQPR 0.00 0.00 0.00241200,838.76SYS1062 0.00 205,687.49Subtotal 205,687.49 0.000.000.00200,838.76 0.00 Fund: SA Low/Mod Bond Fund 16,748,919.97111316,748,919.97 1.648LAIF 20,115.73 0.00 20,115.731.46924916,665,047.6825-33-005 0.00 16,748,919.97Subtotal 16,748,919.97 1.469 20,115.730.0020,115.7316,665,047.68 0.00 153,676,010.72Total 153,468,548.08 1.591 196,608.570.00176,047.32150,246,006.27 20,561.25 Portfolio CITY CP Run Date: 09/08/2020 - 14:00 TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 ---GEM of the DESERT --- Investments Par Value Bank Accounts 3 ,652 ,780 .90 Local Agency Investment Fund-City 54 ,463 ,5 12 .61 Local Agency lnvstmnt Fund-Housing 16 ,748 ,919.97 Money Market Accounts -CAMP 2 ,849 ,513.77 Federal Agency Coupon Securities 12 ,250,000.00 Treasury Coupon Securities 11 ,000,000.00 Certificate of Deposits 33,913,000.00 Corporate Notes 2,400,000.00 Money Market with Fiscal Agent 5 ,360.88 CERBT -OPEB Trust 1,543 ,284 .27 PARS Pension Trust 10,131 ,937.46 148,958,309.86 Investments Total Earnings May 31 Month Ending Current Year 207 ,984 .79 Average Daily Balance 163, 704,887.02 Effective Rate of Return 1.50% City of La .Quinta Portfolio Management Portfolio Summary May 31, 2020 Market Book Value Value 3 ,652 ,780.90 3 ,652,780 .90 54 ,561 ,949 .84 54,463,512 .61 16 ,776 ,931.45 16 ,748,919 .97 2 ,849 ,513.77 2,849 ,513 .77 12 ,638 ,062 .50 12,212 ,242 .36 11 ,197,350 .00 10,897 ,535 .00 35 ,383 ,987 .83 33 ,913 ,000 .00 2 ,489 ,676 .00 2 ,341 ,260 .00 5 ,360.88 5 ,360.88 1,543 ,284.27 1,543 ,284.27 10,131 ,937.46 10 ,131 ,937.46 151,230,834.90 148,759,347.22 Fiscal Year To Date 2,611 ,868 .04 152, 797 ,511.21 1.86% % of Portfolio 2.46 36.61 11 .26 1.92 8 .21 7 .33 22 .80 1.57 0 .00 1.04 6 .81 100.00% Term 1,484 1,588 1,542 1.436 1 613 Days to Maturity 1 1,170 572 1,042 805 1 389 City of La Quinta YTM 366 Equiv. 0 .000 1.363 1.363 0 .670 1.59 1 1.557 2 .203 2 .725 0 .000 0 .000 0 .000 1.455 I certify that this report accurately reflects all pooled investments and is in compliance with the California Government Code and the City Investment Policy . As Treasurer of the City of La Quinta , I hereby certify that sufficient investment liquidity and antici pated revenues are available to meet the City's expenditure requirements for the next six months . The City of La Quinta used the monthly account •t•t•~"" ;z;;;i""ji.;;"' to d•t•~ioo the'''' m•~J,;o;;t~rn, •t mooth ""' Karla Romero , Finance Director Reporting period 05/01/2020-05/31/2020 Run Date : 09/0812020 -13 :57 Portfolio CITY CP PM (PRF _PM1 ) 7.3.0 Report Ver. 7.3.6.1 City of La Quinta Portfolio Management May 31, 2020 City of La Quinta - Portfolio Summary % of Portfolio Book ValueInvestmentsMarket Value Par Value Days to MaturityTerm YTM 365 Equiv. Bank Accounts 3,652,780.90 12.46 0.00013,652,780.903,652,780.90 Local Agency Investment Fund-City 54,463,512.61 136.61 1.363154,561,949.8454,463,512.61 Local Agency Invstmnt Fund-Housing 16,748,919.97 111.26 1.363116,776,931.4516,748,919.97 Money Market Accounts - CAMP 2,849,513.77 11.92 0.67012,849,513.772,849,513.77 Federal Agency Coupon Securities 12,212,242.36 1,4848.21 1.5911,17012,638,062.5012,250,000.00 Treasury Coupon Securities 10,897,535.00 1,5887.33 1.55757211,197,350.0011,000,000.00 Certificate of Deposits 33,913,000.00 1,54222.80 2.2031,04235,383,987.8333,913,000.00 Corporate Notes 2,341,260.00 1,4361.57 2.7258052,489,676.002,400,000.00 Money Market with Fiscal Agent 5,360.88 10.00 0.00015,360.885,360.88 CERBT - OPEB Trust 1,543,284.27 11.04 0.00011,543,284.271,543,284.27 PARS Pension Trust 10,131,937.46 16.81 0.000110,131,937.4610,131,937.46 148,759,347.22 100.00%Investments 151,230,834.90148,958,309.86 613 389 1.455 Current Year May 31 207,984.79 Fiscal Year To Date 2,611,868.04 Average Daily Balance Effective Rate of Return 163,704,887.02 152,797,511.21 1.86%1.50% Total Earnings Month Ending I certify that this report accurately reflects all pooled investments and is in compliance with the California Government Code and the City Investment Policy. As Treasurer of the City of La Quinta, I hereby certify that sufficient investment liquidity and anticipated revenues are available to meet the City's expenditure requirements for the next six months. The City of La Quinta used the monthly account statements issued by our financial institutions to determine the fair market value of investments at month end. __________________________________________________ ____________________ Karla Romero, Finance Director Portfolio CITY CP Reporting period 05/01/2020-05/31/2020 Run Date: 09/08/2020 - 13:57 PM (PRF_PM1) 7.3.0 Report Ver. 7.3.6.1 Days to Maturity Page 1 Par Value Book Value Maturity Date Stated RateMarket Value May 31, 2020 Portfolio Details - Investments Average BalanceIssuer Portfolio Management City of La Quinta YTM 365TermCUSIPInvestment # Purchase Date Bank Accounts 1Bank of the West1228 810,612.43 810,612.4308/20/2019 810,612.43 1059731851 0.000 1City Petty Cash1059 3,300.00 3,300.0007/01/2016 3,300.00 1SYS1059 0.000 1La Quinta Palms Realty1062 221,722.48 221,722.4807/01/2016 221,722.48 1SYS1062 0.000 1Stifel, Nicolaus & Company1183 2,028,916.15 2,028,916.1503/18/2019 2,028,916.15 1SYS1183 0.000 1Wells Fargo1057 588,229.84 588,229.8407/01/2016 588,229.84 14159282482 0.000 3,652,780.90 13,652,780.903,652,780.9021,963,313.12Subtotal and Average 1 0.000 Local Agency Investment Fund-City 1Local Agency Inv Fund1055 54,463,512.61 54,463,512.61 1.36354,561,949.84 198-33-434 1.363 54,463,512.61 154,561,949.8454,463,512.6150,850,609.38Subtotal and Average 1 1.363 Local Agency Invstmnt Fund-Housing 1Local Agency Inv Fund1113 16,748,919.97 16,748,919.97 1.36316,776,931.45 125-33-005 1.363 16,748,919.97 116,776,931.4516,748,919.9716,748,919.97Subtotal and Average 1 1.363 Money Market Accounts - CAMP 1California Asset Management Pr1153 2,849,513.77 2,849,513.77 0.67009/26/2018 2,849,513.77 1SYS1153 0.670 2,849,513.77 12,849,513.772,849,513.773,234,806.66Subtotal and Average 1 0.670 Federal Agency Coupon Securities 457Federal Farm Credit Bank1105 1,000,000.00 992,200.00 09/01/20211.70011/09/2017 1,018,670.00 1,3923133EHWM1 1.913 1,191Federal Farm Credit Bank1158 250,000.00 247,275.00 09/05/20232.80010/15/2018 270,122.50 1,7863133EJYL7 3.041 924Federal Farm Credit Bank1198 500,000.00 499,500.00 12/12/20221.87506/20/2019 520,170.00 1,2713133EKQP4 1.905 1,516Federal Farm Credit Bank1212 500,000.00 499,500.00 07/26/20241.85008/02/2019 528,655.00 1,8203133EKWV4 1.871 1,169Federal Farm Credit Bank1223 500,000.00 499,400.00 08/14/20231.60009/12/2019 520,575.00 1,4323133EKZK5 1.632 1,569Federal Farm Credit Bank1224 500,000.00 498,750.00 09/17/20241.60009/17/2019 523,820.00 1,8273133EKP75 1.652 1,248Federal Farm Credit Bank1234 1,000,000.00 996,900.00 11/01/20231.60011/01/2019 1,042,730.00 1,4613133EK4X1 1.680 1,569Federal Farm Credit Bank1242 1,000,000.00 998,600.00 09/17/20241.70012/17/2019 1,051,920.00 1,7363133ELEA8 1.731 1,353Federal Farm Credit Bank1246 1,000,000.00 999,000.00 02/14/20241.43002/14/2020 1,038,050.00 1,4613133ELNE0 1.456 850Federal Farm Credit Bank1247 1,000,000.00 999,217.36 09/29/20221.40002/05/2020 1,026,570.00 9673133EGWJ0 1.430 102Federal Home Loan Bank1104 1,000,000.00 996,800.00 09/11/20201.62511/09/2017 1,004,150.00 1,0373130A66T9 1.741 1,352Federal Home Loan Bank1177 500,000.00 498,550.00 02/13/20242.50003/01/2019 538,860.00 1,8103130AFW94 2.563 1,785Federal Home Loan Mtg Corp1275 1,000,000.00 998,500.00 04/21/20250.70004/28/2020 1,000,130.00 1,8193134GVLC0 0.731 1,821Federal Home Loan Mtg Corp1279 1,000,000.00 1,000,000.00 05/27/20250.62505/27/2020 999,630.00 1,8263134GVYG7 0.625 1,492Federal National Mtg Assn1206 500,000.00 495,950.00 07/02/20241.75007/15/2019 527,810.00 1,8143135G0V75 1.922 827Federal National Mtg Assn1233 1,000,000.00 992,100.00 09/06/20221.37510/29/2019 1,026,200.00 1,0433135G0W33 1.659 Portfolio CITY CP Run Date: 09/08/2020 - 13:57 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, 2020 Portfolio Details - Investments Average BalanceIssuer Portfolio Management City of La Quinta YTM 365TermCUSIPInvestment # Purchase Date 12,212,242.36 1,48412,638,062.5012,250,000.0011,484,573.01Subtotal and Average 1,170 1.591 Treasury Coupon Securities 394U.S. Treasury1045 5,000,000.00 5,000,000.00 06/30/20211.12507/18/2016 5,049,400.00 1,808912828S27 1.125 517U.S. Treasury1070 2,000,000.00 1,942,800.00 10/31/20211.25003/27/2017 2,030,000.00 1,679912828T67 1.903 75U.S. Treasury1117 1,000,000.00 985,800.00 08/15/20201.50001/22/2018 1,002,820.00 9369128282Q2 2.071 851U.S. Treasury1178 500,000.00 489,687.50 09/30/20221.87503/01/2019 519,725.00 1,3099128282W9 2.480 713U.S. Treasury1192 500,000.00 496,650.00 05/15/20221.75005/31/2019 515,390.00 1,080912828SV3 1.984 364U.S. Treasury1193 500,000.00 493,610.00 05/31/20211.37505/31/2019 505,820.00 731912828R77 2.030 1,216U.S. Treasury1217 500,000.00 499,300.00 09/30/20231.37508/21/2019 519,355.00 1,501912828T26 1.410 1,643U.S. Treasury1241 1,000,000.00 989,687.50 11/30/20241.50012/16/2019 1,054,840.00 1,811912828YV6 1.718 10,897,535.00 1,58811,197,350.0011,000,000.0010,897,535.00Subtotal and Average 572 1.557 Certificate of Deposits 1,551First State Bk DeQueen1222 248,000.00 248,000.00 08/30/20241.80008/30/2019 259,988.32 1,827336460CX6 1.802 1,793First Freedom Bank1273 249,000.00 249,000.00 04/29/20251.20004/29/2020 251,856.03 1,82632027BAL1 1.201 1,544FirsTier Bank1216 249,000.00 249,000.00 08/23/20241.95008/23/2019 262,640.22 1,82733766LAJ7 1.952 1,8061st Internet Bank1278 248,000.00 248,000.00 05/12/20251.00005/11/2020 248,262.88 1,82732056GDJ6 0.985 1,792Firrst Natl Bk McGregor1274 248,000.00 248,000.00 04/28/20251.35004/28/2020 252,645.04 1,82632112UDR9 1.351 1,144First National Bank of America1147 245,000.00 245,000.00 07/20/20233.15007/20/2018 265,903.40 1,82632110YLK9 3.152 1,068First National Bank1179 248,000.00 248,000.00 05/05/20232.80003/05/2019 265,451.76 1,52232117BCX4 2.802 1,551First Natl Bk of Syracuse1221 249,000.00 249,000.00 08/30/20241.85008/30/2019 261,559.56 1,827334342CD2 1.852 1,719First National Bank Michigan1250 248,000.00 248,000.00 02/14/20251.65002/14/2020 256,990.00 1,82732114VBT3 1.652 1,520First Security Bank of WA1209 248,000.00 248,000.00 07/30/20242.00007/30/2019 262,210.40 1,82733625CCP2 2.002 1,444First Service Bank1231 248,000.00 248,000.00 05/15/20241.70011/15/2019 259,447.68 1,64333640VDD7 1.701 534First Source Bank1168 245,000.00 245,000.00 11/17/20213.15012/17/2018 255,640.35 1,06633646CKP8 3.153 140First Tech Federal Credit Unio1124 245,000.00 245,000.00 10/19/20202.70004/18/2018 247,472.05 91533715LBJ8 2.623 609Third Federal Savings and Loan1112 245,000.00 245,000.00 01/31/20222.50001/30/2018 254,341.85 1,46288413QBY3 2.502 1,516Abacus Federal Savings1207 248,000.00 248,000.00 07/26/20241.95007/26/2019 261,726.80 1,82700257TBD7 1.952 1,746Access Bank1256 248,000.00 248,000.00 03/13/20251.60003/13/2020 256,134.40 1,82600435JBH5 1.601 742Allegiance Bank1143 245,000.00 245,000.00 06/13/20223.10006/13/2018 259,239.40 1,46101748DBE5 3.102 864Alliance Credit Union1095 245,000.00 245,000.00 10/13/20222.25010/13/2017 256,331.25 1,82601859BAA3 2.251 280Ally Bank Midvale1176 245,000.00 245,000.00 03/08/20212.50003/07/2019 249,503.10 73202007GHX4 2.016 1,761Alma Bank1267 248,000.00 248,000.00 03/28/20251.40003/30/2020 253,622.16 1,824020080BX4 1.399 757America's Credit Union1200 248,000.00 248,000.00 06/28/20222.30006/28/2019 251,234.16 1,09603065AAL7 2.302 1,726American State1255 248,000.00 248,000.00 02/21/20251.60002/21/2020 256,345.20 1,827029728BC5 1.602 322Amex Centurion1077 240,000.00 240,000.00 04/19/20212.25004/19/2017 244,485.60 1,46102587DP85 2.252 Portfolio CITY CP Run Date: 09/08/2020 - 13:57 PM (PRF_PM2) 7.3.0 Days to Maturity Page 3 Par Value Book Value Maturity Date Stated RateMarket Value May 31, 2020 Portfolio Details - Investments Average BalanceIssuer Portfolio Management City of La Quinta YTM 365TermCUSIPInvestment # Purchase Date Certificate of Deposits 819American Express Fed Savings B1096 240,000.00 240,000.00 08/29/20222.40008/29/2017 250,658.40 1,82602587CFU9 2.402 1,143American National Bank1205 248,000.00 248,000.00 07/19/20232.00007/19/2019 260,243.76 1,46102772JBD1 2.001 1,024Aneca Federal Credit Union1119 245,000.00 245,000.00 03/22/20232.80003/22/2018 261,699.20 1,826034577AH9 2.802 1,759Axos Bank1258 248,000.00 248,000.00 03/26/20251.65003/26/2020 256,578.32 1,82605465DAE8 1.651 876Barclays Bank1097 240,000.00 240,000.00 10/25/20222.30010/25/2017 251,510.40 1,82606740KLJ4 2.291 1,306Bar Harbor Bank and Trust1172 248,000.00 248,000.00 12/29/20233.35012/31/2018 273,348.08 1,824066851WJ1 3.352 1,415Belmont Bank and Trust1270 248,000.00 248,000.00 04/16/20241.25004/16/2020 255,025.84 1,46108016PDQ9 1.251 667Bellco Credit Union1264 248,000.00 248,000.00 03/30/20221.30003/31/2020 252,865.76 72907833EAD9 1.300 539Belmont Savings Bank1102 245,000.00 245,000.00 11/22/20212.10011/21/2017 251,872.25 1,462080515CD9 2.101 633BMW Bank1067 240,000.00 240,000.00 02/24/20222.20002/24/2017 248,246.40 1,82605580AGK4 2.201 227Bankers Bank1086 240,000.00 240,000.00 01/14/20211.80007/14/2017 242,503.20 1,28006610RAP4 1.804 1,579BankWest Inc1227 248,000.00 248,000.00 09/27/20241.70009/27/2019 258,748.32 1,82706652CHB0 1.702 668Cadence Bank, NA1259 245,000.00 245,000.00 03/31/20221.20003/31/2020 249,392.85 73012738RFX7 1.200 371Capital One Natl Assn FDIC42971082 240,000.00 240,000.00 06/07/20212.25006/07/2017 245,090.40 1,46114042RGD7 2.252 1,772Capital One USA FDIC339541271 245,000.00 245,000.00 04/08/20251.60004/08/2020 252,744.45 1,82614042TDD6 1.601 266Comenity Capital Bank1009 240,000.00 240,000.00 02/22/20211.70002/22/2016 242,731.20 1,82720033APG5 1.702 1,551Celtic Bank1220 248,000.00 248,000.00 08/30/20241.85008/30/2019 260,509.12 1,82715118RRH2 1.852 1,445Century Next Bank1184 248,000.00 248,000.00 05/16/20242.50005/29/2019 267,366.32 1,814156634AK3 2.503 1,732Citadel FCU1252 248,000.00 248,000.00 02/27/20251.65002/27/2020 256,858.56 1,82717286TAG0 1.652 813CIT Bank NA1219 245,000.00 245,000.00 08/23/20221.90008/23/2019 253,873.90 1,09612556LBA3 1.902 1,044Citibank NA1123 245,000.00 245,000.00 04/11/20232.90004/11/2018 262,644.90 1,82617312QJ26 2.902 1,764Commonwealth Business Bk1268 248,000.00 248,000.00 03/31/20251.25003/31/2020 251,829.12 1,8262027506M2 1.251 408Central State Bank1085 240,000.00 240,000.00 07/14/20211.85007/14/2017 244,504.80 1,46115523RBJ4 1.851 1,262Commercial Bank1162 248,000.00 248,000.00 11/15/20233.40011/15/2018 273,055.44 1,82620143PDV9 3.402 1,488Communitywide FCU1202 248,000.00 248,000.00 06/28/20242.25006/28/2019 264,849.12 1,82720416TAQ5 2.253 1,061Congressional Bank1189 248,000.00 248,000.00 04/28/20232.50004/30/2019 263,202.40 1,45920726ABA5 2.502 900CrossFirst Bank1106 245,000.00 245,000.00 11/18/20222.20011/20/2017 256,385.15 1,82422766ACB9 2.201 1,481Citizens State Bank1199 248,000.00 248,000.00 06/21/20242.40006/21/2019 266,354.48 1,827176688CP2 2.403 610Discover Bank Greenwood DE CF1066 240,000.00 240,000.00 02/01/20222.25002/01/2017 248,162.40 1,8262546722U1 2.251 233Eagle Bank1146 245,000.00 245,000.00 01/20/20212.85007/20/2018 249,277.70 91527002YDV5 2.858 1,061EnerBank USA1125 240,000.00 240,000.00 04/28/20232.95004/30/2018 257,844.00 1,82429278TAY6 2.952 910Enterprise Bank, NA1107 245,000.00 245,000.00 11/28/20222.15011/28/2017 256,167.10 1,82629367QCP1 2.151 1,472Evansville Teachers Credit FCU1196 248,000.00 248,000.00 06/12/20242.60006/12/2019 268,343.44 1,827299547AQ2 2.603 4EverBank1017248,000.00 248,000.00 06/05/20201.70006/05/2015 248,076.88 1,82729976DXX3 1.702 231Farm Bureau Bank1165 248,000.00 248,000.00 01/18/20213.00012/17/2018 252,530.96 763307660LC2 2.898 697Farmers Insurance Group FCU1126 240,000.00 240,000.00 04/29/20222.80004/30/2018 251,798.40 1,46030960QAG2 2.802 Portfolio CITY CP Run Date: 09/08/2020 - 13:57 PM (PRF_PM2) 7.3.0 Days to Maturity Page 4 Par Value Book Value Maturity Date Stated RateMarket Value May 31, 2020 Portfolio Details - Investments Average BalanceIssuer Portfolio Management City of La Quinta YTM 365TermCUSIPInvestment # Purchase Date Certificate of Deposits 1,794Flagstar1276248,000.00 248,000.00 04/30/20251.25004/30/2020 251,422.40 1,82633847E3A3 1.251 1,719Freedom Financial1248 248,000.00 248,000.00 02/14/20251.55002/14/2020 255,844.24 1,82735637RDC8 1.552 204Freedom Credit Union1111 245,000.00 245,000.00 12/22/20202.05012/22/2017 247,660.70 1,09635638BAA9 2.052 441General Electric Credit Union1150 240,000.00 240,000.00 08/16/20213.10008/15/2018 248,488.80 1,097369674AV8 3.100 694Goldman Sachs1078 240,000.00 240,000.00 04/26/20222.40004/26/2017 249,943.20 1,82638148PJK4 2.401 42First Bank of Highland1094 240,000.00 240,000.00 07/13/20201.75007/13/2017 240,489.60 1,096319141GT8 1.752 1,452Iowa State Bank1186 245,000.00 245,000.00 05/23/20242.40005/23/2019 263,125.10 1,82746256YAZ2 2.403 1,235Jefferson Financial CU1154 245,000.00 245,000.00 10/19/20233.35010/19/2018 268,924.25 1,826474067AQ8 3.352 1,445JP Morgan Chase1185 245,000.00 245,000.00 05/16/20243.25005/16/2019 235,420.50 1,82748128HXU7 3.254 715Kansas State Bank1101 245,000.00 245,000.00 05/17/20222.10011/17/2017 253,971.90 1,64250116CBE8 2.099 942Kern FCU1239 248,000.00 248,000.00 12/30/20221.90012/30/2019 258,001.84 1,09649228XAK6 1.902 941Knoxville TVA Credit Union1110 245,000.00 245,000.00 12/29/20222.40012/29/2017 258,038.90 1,826499724AB8 2.401 1,479Legacy Bank1197 248,000.00 248,000.00 06/19/20242.40006/19/2019 266,356.96 1,827524661CB9 2.403 1,457Live Oak Bank1238 248,000.00 248,000.00 05/28/20241.80011/27/2019 260,486.80 1,644538036GV0 1.802 1,337Lakeside Bank1208 248,000.00 248,000.00 01/29/20242.00007/30/2019 261,654.88 1,64451210SQU4 2.003 655Luana Savings Bank1225 245,000.00 245,000.00 03/18/20221.60009/18/2019 251,080.90 912549104JN8 1.599 637Maine Savings FCU1171 248,000.00 248,000.00 02/28/20223.30012/28/2018 261,327.52 1,158560507AK1 3.306 1,425Main Street Bank1188 248,000.00 248,000.00 04/26/20242.60004/26/2019 268,003.68 1,82756065GAG3 2.603 1,233Marlin Business Bank1155 248,000.00 248,000.00 10/17/20233.30010/17/2018 271,750.96 1,82657116ARV2 3.302 919Medallion Bank1169 248,000.00 248,000.00 12/07/20223.40012/07/2018 267,185.28 1,46158404DCX7 3.402 36Mercantile Bank of Michigan1087 240,000.00 240,000.00 07/07/20201.75007/07/2017 240,424.80 1,09658740XZL7 1.752 11Bank Midwest1002 248,000.00 248,000.00 06/12/20201.65006/12/2015 248,148.80 1,827063615AVO 1.652 1,633Morgan Stanley Bank1237 245,000.00 245,000.00 11/20/20241.95011/20/2019 257,904.15 1,82761690UNX4 1.952 1,114Morton Community1173 248,000.00 248,000.00 06/20/20232.75003/20/2019 265,667.52 1,553619165JD6 2.753 879Merrick Bank1163 248,000.00 248,000.00 10/28/20223.25010/30/2018 265,580.72 1,45959013J4K2 3.252 1,633Morgan Stanley Private Bk, NA1236 245,000.00 245,000.00 11/20/20241.90011/20/2019 257,365.15 1,82761760A3B3 1.902 890Mountain America Federal CU1099 245,000.00 245,000.00 11/08/20222.30011/08/2017 256,870.25 1,82662384RAC0 2.301 1,233Municipal Trust and Savings1160 245,000.00 245,000.00 10/17/20233.20010/17/2018 267,640.45 1,826625925AR3 3.202 1,764Nicolet Natl Bank1266 248,000.00 248,000.00 03/31/20251.40003/31/2020 253,587.44 1,826654062JZ2 1.401 568Neighbors FCU1167 245,000.00 245,000.00 12/21/20213.20012/21/2018 256,426.80 1,09664017AAQ7 3.203 245Infinty FCU1211 248,000.00 248,000.00 02/01/20212.10007/31/2019 251,276.08 55145667EDY1 2.110 1,298National Cooperative Bank, N.A1170 245,000.00 245,000.00 12/21/20233.40012/21/2018 270,320.75 1,826635573AL2 3.402 1,275Numerica Credit Union1164 248,000.00 248,000.00 11/28/20233.55011/28/2018 274,563.28 1,82667054NAN3 3.552 512Northpointe Bank1127 240,000.00 240,000.00 10/26/20212.70004/26/2018 248,448.00 1,279666613GV0 2.703 1,033Northstar Bank1263 248,000.00 248,000.00 03/31/20231.15003/31/2020 253,436.16 1,09566704MEQ0 1.150 1,352Northwest Bank1181 248,000.00 248,000.00 02/13/20242.95002/13/2019 270,404.32 1,82666736ABP3 2.951 Portfolio CITY CP Run Date: 09/08/2020 - 13:57 PM (PRF_PM2) 7.3.0 Days to Maturity Page 5 Par Value Book Value Maturity Date Stated RateMarket Value May 31, 2020 Portfolio Details - Investments Average BalanceIssuer Portfolio Management City of La Quinta YTM 365TermCUSIPInvestment # Purchase Date Certificate of Deposits 1,155Bank of New England1151 249,000.00 249,000.00 07/31/20233.25007/31/2018 271,183.41 1,82606426KAN8 3.252 483New York Community Bank1226 245,000.00 245,000.00 09/27/20211.80009/27/2019 250,238.10 731649447TC3 1.802 597The Ohio Valley Bank1089 240,000.00 240,000.00 01/19/20221.90007/19/2017 246,624.00 1,645677721CN0 1.903 1,415Pacific Western Bank1269 245,000.00 245,000.00 04/16/20241.30004/16/2020 252,413.70 1,46169506YRH4 1.301 737PCSB Bank1149 245,000.00 245,000.00 06/08/20223.00006/08/2018 258,663.65 1,46169324MAD7 3.002 1,521People's Bank1210 248,000.00 248,000.00 07/31/20242.00007/31/2019 262,205.44 1,827710571DS6 2.002 1,101Pittsfield Cooperative Bank1194 245,000.00 245,000.00 06/07/20232.50006/07/2019 260,430.10 1,461725404AB3 2.502 1,467Plains Commerce Bank1195 245,000.00 245,000.00 06/07/20242.55006/07/2019 264,585.30 1,82772651LCL6 2.553 1,537Preferred Bank1213 249,000.00 249,000.00 08/16/20242.00008/16/2019 263,193.00 1,827740367HP5 2.002 359PrivateBank & Trust1032 240,000.00 240,000.00 05/26/20211.50005/26/2016 243,427.20 1,82674267GVG9 1.501 1,178Raymond James Bank1218 244,000.00 244,000.00 08/23/20231.95008/23/2019 255,914.52 1,46175472RAD3 1.951 1,114RCB Bank1144 245,000.00 245,000.00 06/20/20233.15006/20/2018 265,435.45 1,82674934YAH4 3.152 919Red Rocks Credit Union1166 248,000.00 248,000.00 12/07/20223.35012/07/2018 266,875.28 1,46175701LAB3 3.352 1,488Revere Bank1203 247,000.00 247,000.00 06/28/20242.30006/28/2019 264,255.42 1,827761402BY1 2.303 175First Bank Richmond1081 245,000.00 245,000.00 11/23/20201.80006/21/2017 247,026.15 1,251319267GC8 1.802 1,351Rollstone B&T1251 245,000.00 245,000.00 02/12/20241.65002/12/2020 255,422.30 1,46177579ADF0 1.651 750Sallie Mae Bank Salt Lake CIty1083 240,000.00 240,000.00 06/21/20222.35006/21/2017 250,377.60 1,826795450A70 2.351 1,620Sauk Valley B&T Co1235 248,000.00 248,000.00 11/07/20241.70011/07/2019 258,433.36 1,827804375DL4 1.702 995Servisfirst Bank1254 248,000.00 248,000.00 02/21/20231.60002/21/2020 256,374.96 1,09681768PAF3 1.601 942San Francisco FCU1240 248,000.00 248,000.00 12/30/20221.85012/30/2019 248,311.73 1,09679772FAC0 1.852 668Bank of Santa Clarita1261 248,000.00 248,000.00 03/31/20221.10003/31/2020 251,968.00 73006424KBC3 1.100 1,753Spring Bank1257 248,000.00 248,000.00 03/20/20251.50003/20/2020 254,891.92 1,826849430BF9 1.501 819Sterling Bank1201 245,000.00 245,000.00 08/29/20222.15006/28/2019 255,299.80 1,15885916VDC6 2.153 731Synchrony Bank Retail1080 240,000.00 240,000.00 06/02/20222.40006/02/2017 250,394.40 1,82687164XQV1 2.401 738Synovus Bank1253 245,000.00 245,000.00 06/09/20221.60003/09/2020 251,766.90 82287164DRD4 1.602 1,396Texas Bank Financial1260 245,000.00 245,000.00 03/28/20241.10003/31/2020 242,285.64 1,458882213AB7 1.101 1,414The Jefferson Bank1272 248,000.00 248,000.00 04/15/20241.25004/15/2020 255,025.84 1,461472382AQ3 1.251 333Towne Bank1128 240,000.00 240,000.00 04/30/20212.80004/30/2018 245,853.60 1,09689214PBL2 2.803 798Traditions Bank1148 245,000.00 245,000.00 08/08/20223.00006/08/2018 259,636.30 1,52289269CBX9 3.002 1,215Triad Bank1262 248,000.00 248,000.00 09/29/20231.35003/30/2020 255,447.44 1,27889579NCD3 1.352 539TNB Bank1187 248,000.00 248,000.00 11/22/20212.40005/22/2019 256,057.52 91587266AAA1 2.407 1,233UBS Bank USA1161 245,000.00 245,000.00 10/17/20233.35010/17/2018 268,875.25 1,82690348JEJ5 3.352 288Unity Bank1120 245,000.00 245,000.00 03/16/20212.55003/16/2018 249,691.75 1,09691330ABN6 2.552 1,712United Community1249 248,000.00 248,000.00 02/07/20251.65002/07/2020 257,056.96 1,82790983WBT7 1.652 569United Credit Union1214 248,000.00 248,000.00 12/22/20212.00008/22/2019 254,939.04 853910160AH3 2.003 1,078University of Iowa Comm. CU1134 240,000.00 240,000.00 05/15/20233.05005/14/2018 258,782.40 1,82791435LAG2 3.052 Portfolio CITY CP Run Date: 09/08/2020 - 13:57 PM (PRF_PM2) 7.3.0 Days to Maturity Page 6 Par Value Book Value Maturity Date Stated RateMarket Value May 31, 2020 Portfolio Details - Investments Average BalanceIssuer Portfolio Management City of La Quinta YTM 365TermCUSIPInvestment # Purchase Date Certificate of Deposits 1,002Verus Bank of Commerce1180 248,000.00 248,000.00 02/28/20232.70002/28/2019 263,876.96 1,46192535LCD4 2.700 1,366Wells Fargo1174 248,000.00 248,000.00 02/27/20243.00002/27/2019 269,246.16 1,826949763XY7 3.001 1,033West Michigan Cmnty Bk1265 248,000.00 248,000.00 03/31/20231.15003/31/2020 253,436.16 1,095954444BS3 1.150 14Wex Bank1145 245,000.00 245,000.00 06/15/20202.75006/13/2018 245,306.25 73392937CHG6 2.754 973Wells Fargo Natl Bank West1244 248,000.00 248,000.00 01/30/20231.90001/29/2020 258,242.40 1,097949495AT2 1.900 1,544Washington Federal1215 248,000.00 248,000.00 08/23/20242.00008/23/2019 262,103.76 1,827938828BH2 2.002 1,807Western State Bank1277 245,000.00 245,000.00 05/13/20251.00005/13/2020 245,245.00 1,82695960NKD8 1.001 33,913,000.00 1,54235,383,987.8333,913,000.0033,817,096.77Subtotal and Average 1,042 2.203 Corporate Notes 429Apple Inc1079 500,000.00 493,050.00 08/04/20211.55006/12/2017 506,380.00 1,514037833CC2 1.900 975Colgate-Palmolive1175 500,000.00 485,250.00 02/01/20231.95003/04/2019 520,075.00 1,43019416QEA4 2.751 1,163Microsoft Corporation1157 400,000.00 378,360.00 08/08/20232.00010/15/2018 419,596.00 1,758594918BQ6 3.222 615Proctor and Gamble1159 500,000.00 487,950.00 02/06/20222.30010/15/2018 519,585.00 1,210742718DY2 3.071 927Wal-Mart Stores, Inc1190 500,000.00 496,650.00 12/15/20222.35004/16/2019 524,040.00 1,339931142DU4 2.799 2,341,260.00 1,4362,489,676.002,400,000.003,212,010.00Subtotal and Average 805 2.725 Money Market with Fiscal Agent 1US Bank1058 5,360.88 5,360.8807/01/2016 5,360.88 1SYS1058 0.000 5,360.88 15,360.885,360.885,360.86Subtotal and Average 1 0.000 CERBT - OPEB Trust 1CalPERS CERBT Plan1114 1,543,284.27 1,543,284.2707/01/2019 1,543,284.27 1SYS1114 0.000 1,543,284.27 11,543,284.271,543,284.271,543,284.27Subtotal and Average 1 0.000 PARS Pension Trust 1Pblc Agncy Rtrmnt Serv1230 10,131,937.46 10,131,937.4608/01/2019 10,131,937.46 1SYS1230 0.000 10,131,937.46 110,131,937.4610,131,937.469,947,377.97Subtotal and Average 1 0.000 613163,704,887.02 148,958,309.86 389 1.455151,230,834.90 148,759,347.22Total and Average Portfolio CITY CP Run Date: 09/08/2020 - 13:57 PM (PRF_PM2) 7.3.0 City of La Quinta Total Earnings City of La Quinta - Sorted by Fund - Fund May 1, 2020 - May 31, 2020 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 248,000.001002248,000.00 1.650MIDWES 347.54 0.00 347.541.650101248,000.00063615AVO 0.00 240,000.001009240,000.00 1.700CCBA 346.52 0.00 346.521.700101240,000.0020033APG5 0.00 248,000.001017248,000.00 1.700EVRBA 358.07 0.00 358.071.700101248,000.0029976DXX3 0.00 240,000.001032240,000.00 1.500PRVTBA 305.76 0.00 305.761.500101240,000.0074267GVG9 0.00 5,000,000.0010455,000,000.00 1.125USTR 4,790.52 0.00 4,790.521.1281015,000,000.00912828S27 0.00 54,463,512.61105554,463,512.61 1.363LAIF 63,256.01 0.00 63,256.011.93610138,463,512.6198-33-434 0.00 588,229.841057588,229.84WELLS 0.01 0.00 0.01101753,385.504159282482 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.001077240,000.00 2.250AMEX 458.64 0.00 458.642.250101240,000.0002587DP85 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 245,000.001081245,000.00 1.800RICHMN 374.55 0.00 374.551.800101245,000.00319267GC8 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.02 0.00 479.022.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.001086240,000.00 1.800BNKRS 366.90 0.00 366.901.800101240,000.0006610RAP4 0.00 240,000.001087240,000.00 1.750MERCTL 356.71 0.00 356.711.750101240,000.0058740XZL7 0.00 240,000.001089240,000.00 1.900OHVAL 387.29 0.00 387.291.900101240,000.00677721CN0 0.00 240,000.001094240,000.00 1.750HIGHLD 356.71 0.00 356.711.750101240,000.00319141GT8 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 0.0011000.00 1.750JFFRSN 129.21 0.00 129.211.750101245,000.00472376AC6 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 Portfolio CITY CP Run Date: 09/08/2020 - 14:01 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, 2020 - May 31, 2020 Total Earnings City of La Quinta Annualized YieldCUSIPInvestment # Interest EarnedIssuer Realized Gainl/Loss Fund: General Fund 996,800.0011041,000,000.00 1.625FHLB 1,354.17 0.00 1,354.171.600101996,800.003130A66T9 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.001111245,000.00 2.050FREECU 426.56 0.00 426.562.050101245,000.0035638BAA9 0.00 245,000.001112245,000.00 2.5003RD 520.20 0.00 520.202.500101245,000.0088413QBY3 0.00 1,543,284.2711141,543,284.27CALPRS 0.00 0.00 0.001011,543,284.27SYS1114 0.00 985,800.0011171,000,000.00 1.500USTR 1,277.47 0.00 1,277.471.526101985,800.009128282Q2 0.00 245,000.001119245,000.00 2.800ANECA 582.63 0.00 582.632.800101245,000.00034577AH9 0.00 245,000.001120245,000.00 2.550UNITY 530.61 0.00 530.612.550101245,000.0091330ABN6 0.00 245,000.001123245,000.00 2.900CITINA 603.44 0.00 603.442.900101245,000.0017312QJ26 0.00 245,000.001124245,000.00 2.7001STTCH 561.82 0.00 561.822.700101245,000.0033715LBJ8 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 240,000.001127240,000.00 2.700NORPNT 550.36 0.00 550.362.700101240,000.00666613GV0 0.00 240,000.001128240,000.00 2.800TOWNE 570.74 0.00 570.742.800101240,000.0089214PBL2 0.00 240,000.001134240,000.00 3.050UOFICU 621.70 0.00 621.703.050101240,000.0091435LAG2 0.00 0.0011420.00 1.550FFCB 150.69 0.00 8,400.6989.077101491,750.003133EHJA2 8,250.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.001145245,000.00 2.750WEX 572.22 0.00 572.222.750101245,000.0092937CHG6 0.00 245,000.001146245,000.00 2.850EAGLE 593.03 0.00 593.032.850101245,000.0027002YDV5 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 2,849,513.7711532,849,513.77 0.670CAMP 1,864.01 0.00 1,864.010.4531014,847,649.76SYS1153 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 Portfolio CITY CP Run Date: 09/08/2020 - 14:01 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, 2020 - May 31, 2020 Total Earnings City of La Quinta Annualized YieldCUSIPInvestment # Interest EarnedIssuer Realized Gainl/Loss Fund: General Fund 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.001165248,000.00 3.000FARMBU 631.89 0.00 631.893.000101248,000.00307660LC2 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 245,000.001176245,000.00 2.500ALLY 520.21 0.00 520.212.500101245,000.0002007GHX4 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 2,028,916.1511832,028,916.15STIFEL 16.72 0.00 16.720.0111011,760,299.25SYS1183 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 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 740.75 0.00 740.751.756101496,650.00912828SV3 0.00 493,610.001193500,000.00 1.375USTR 582.30 0.00 582.301.389101493,610.00912828R77 0.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 Portfolio CITY CP Run Date: 09/08/2020 - 14:01 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, 2020 - May 31, 2020 Total Earnings City of La Quinta Annualized YieldCUSIPInvestment # Interest EarnedIssuer Realized Gainl/Loss Fund: General Fund 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 0.0012040.00 1.900TOYOTA 712.50 0.00 3,212.508.690101499,750.0089236TCZ6 2,500.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 248,000.001211248,000.00 2.100NFNITY 442.32 0.00 442.322.100101248,000.0045667EDY1 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 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 810,612.431228810,612.43BOTW 0.01 0.00 0.0110119,588,385.02059731851 0.00 10,131,937.46123010,131,937.46PARS 0.00 0.00 0.001019,941,225.99SYS1230 0.00 248,000.001231248,000.00 1.7001STSER 358.07 0.00 358.071.700101248,000.0033640VDD7 0.00 0.0012320.00 2.000TOYOTA 750.00 0.00 15,750.0042.583101500,000.0089236TGL3 15,000.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.35 0.00 395.351.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 Portfolio CITY CP Run Date: 09/08/2020 - 14:01 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, 2020 - May 31, 2020 Total Earnings City of La Quinta Annualized YieldCUSIPInvestment # Interest EarnedIssuer Realized Gainl/Loss Fund: General Fund 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,270.49 0.00 1,270.491.511101989,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.34 0.00 343.341.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 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 998,500.0012751,000,000.00 0.700FHLMC 583.34 0.00 583.340.688101998,500.003134GVLC0 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 127.53 0.00 127.531.0001010.0095960NKD8 0.00 248,000.001278248,000.00 1.0001STINT 135.89 0.00 135.891.0001010.0032056GDJ6 0.00 Portfolio CITY CP Run Date: 09/08/2020 - 14:01 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, 2020 - May 31, 2020 Total Earnings City of La Quinta Annualized YieldCUSIPInvestment # Interest EarnedIssuer Realized Gainl/Loss Fund: General Fund 1,000,000.0012791,000,000.00 0.625FHLMC 69.44 0.00 69.440.5071010.003134GVYG7 0.00 131,982,306.53Subtotal 131,783,343.89 1.617 187,149.820.00161,399.82136,508,579.76 25,750.00 Fund: Fiscal Agent 5,360.8810585,360.88USBANK 0.02 0.00 0.020.0042315,360.86SYS1058 0.00 5,360.88Subtotal 5,360.88 0.004 0.020.000.025,360.86 0.00 Fund: Housing Authority : WSA and LQ 221,722.481062221,722.48LQPR 0.00 0.00 0.00241205,687.49SYS1062 0.00 221,722.48Subtotal 221,722.48 0.000.000.00205,687.49 0.00 Fund: SA Low/Mod Bond Fund 16,748,919.97111316,748,919.97 1.363LAIF 20,834.95 0.00 20,834.951.46524916,748,919.9725-33-005 0.00 16,748,919.97Subtotal 16,748,919.97 1.465 20,834.950.0020,834.9516,748,919.97 0.00 148,958,309.86Total 148,759,347.22 1.598 207,984.790.00182,234.79153,468,548.08 25,750.00 Portfolio CITY CP Run Date: 09/08/2020 - 14:01 TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 ---GEM of the DESERT --- Investments Bank Accounts Local Agency Investment Fund-City Local Agency lnvstmnt Fund-Housing Money Market Accounts -CAMP Federal Agency Coupon Securities Treasury Coupon Securities Certificate of Deposits Corporate Notes Money Market with Fiscal Agent CERBT -OPEB Trust PARS Pension Trust Investments Total Earnings Current Year Par Value 8 ,547 ,319 .86 68 ,463 ,512 .61 16 ,748,919 .97 2 ,850 ,711 .99 14,050 ,000 .00 11 ,000 ,000 .00 34 , 164,000.00 2,400 ,000 .00 5 ,360 .90 1,7 14 ,840 .82 10,249 ,737 .64 170, 194,403 . 79 June 30 Month Ending 186,911 .03 City of La Quinta Portfolio Management Portfolio Summary June 30, 2020 Market Value 8 ,547 ,319 .86 68 ,561 ,949 .84 16,776,931.45 2 ,850 ,711 .99 14,438,776.00 11 ,191,010.00 35 ,725,057 .14 2 ,487 ,469.00 5 ,360 .90 1,71 4 ,840 .82 10,249,737 .64 172,549 ,164.64 Book Value 8 ,547 ,319 .86 68 ,463 ,512 .61 16 ,748 ,919 .97 2 ,850 ,7 11 .99 14 ,011 ,942 .36 10,897 ,535 .00 34 , 164 ,000 .00 2 ,341 ,260 .00 5,360 .90 1,714 ,840 .82 10,249, 737 .64 169,995,141.15 % of Portfolio Tenm 5 .03 40 .27 9.85 1.68 8.24 1,528 6.4 1 1,588 20.10 1,543 1.38 1,436 0 .00 1.01 6 .03 100.00% 558 Fiscal Year To Date 2 ,798,779 .07 Fiscal Year Ending 2 ,798 ,779 .07 Average Daily Balance 155,200,632.44 152,994,488.36 Effective Rate of Return 1.47% 1.82% Days to Maturity 1 1 1,226 542 1,049 775 358 City of La Quinta YTM 365 Equiv. 0.000 1.217 1.217 0.510 1.462 1.557 2 .157 2 .725 0 .000 0 .000 0 .000 1 .310 I certify that this report accurately reflects all pooled investments and is in compliance with the California Government Code and the City Investment Policy. As Treasurer of the City of La Quinta , I hereby certify that sufficient investment liquidity and anticipated revenues are available to meet the City's expenditure requirements for the next six months . The City of La Quinta used the monthly account statements issued by our financial institutions to determine the fair market value of investments at month end . ""'' Rom~frr CJJ9J;cw . Reporting period 06/01/2020-06/30/2020 Run Date : 09/0812020 . 13:58 Portfolio CITY GP PM (PRF _PM1) 7.3.0 Report Ver. 7.3.6.1 City of La Quinta Portfolio Management June 30, 2020 City of La Quinta - Portfolio Summary % of Portfolio Book ValueInvestmentsMarket Value Par Value Days to MaturityTerm YTM 365 Equiv. Bank Accounts 8,547,319.86 15.03 0.00018,547,319.868,547,319.86 Local Agency Investment Fund-City 68,463,512.61 140.27 1.217168,561,949.8468,463,512.61 Local Agency Invstmnt Fund-Housing 16,748,919.97 19.85 1.217116,776,931.4516,748,919.97 Money Market Accounts - CAMP 2,850,711.99 11.68 0.51012,850,711.992,850,711.99 Federal Agency Coupon Securities 14,011,942.36 1,5288.24 1.4621,22614,438,776.0014,050,000.00 Treasury Coupon Securities 10,897,535.00 1,5886.41 1.55754211,191,010.0011,000,000.00 Certificate of Deposits 34,164,000.00 1,54320.10 2.1571,04935,725,057.1434,164,000.00 Corporate Notes 2,341,260.00 1,4361.38 2.7257752,487,469.002,400,000.00 Money Market with Fiscal Agent 5,360.90 10.00 0.00015,360.905,360.90 CERBT - OPEB Trust 1,714,840.82 11.01 0.00011,714,840.821,714,840.82 PARS Pension Trust 10,249,737.64 16.03 0.000110,249,737.6410,249,737.64 169,995,141.15 100.00%Investments 172,549,164.64170,194,403.79 558 358 1.310 Current Year June 30 186,911.03 Fiscal Year To Date 2,798,779.07 2,798,779.07 Fiscal Year Ending Average Daily Balance Effective Rate of Return 155,200,632.44 152,994,488.36 1.82%1.47% Total Earnings Month Ending I certify that this report accurately reflects all pooled investments and is in compliance with the California Government Code and the City Investment Policy. As Treasurer of the City of La Quinta, I hereby certify that sufficient investment liquidity and anticipated revenues are available to meet the City's expenditure requirements for the next six months. The City of La Quinta used the monthly account statements issued by our financial institutions to determine the fair market value of investments at month end. __________________________________________________ ____________________ Karla Romero, Finance Director Portfolio CITY CP Reporting period 06/01/2020-06/30/2020 Run Date: 09/08/2020 - 13:58 PM (PRF_PM1) 7.3.0 Report Ver. 7.3.6.1 Days to Maturity Page 1 Par Value Book Value Maturity Date Stated RateMarket Value June 30, 2020 Portfolio Details - Investments Average BalanceIssuer Portfolio Management City of La Quinta YTM 365TermCUSIPInvestment # Purchase Date Bank Accounts 1Bank of the West1228 8,084,992.74 8,084,992.7408/20/2019 8,084,992.74 1059731851 0.000 1City Petty Cash1059 3,300.00 3,300.0007/01/2016 3,300.00 1SYS1059 0.000 1La Quinta Palms Realty1062 219,214.99 219,214.9907/01/2016 219,214.99 1SYS1062 0.000 1Stifel, Nicolaus & Company1183 0.00 0.0003/18/2019 0.00 1SYS1183 0.000 1Wells Fargo1057 239,812.13 239,812.1307/01/2016 239,812.13 14159282482 0.000 8,547,319.86 18,547,319.868,547,319.863,044,897.62Subtotal and Average 1 0.000 Local Agency Investment Fund-City 1Local Agency Inv Fund1055 68,463,512.61 68,463,512.61 1.21768,561,949.84 198-33-434 1.217 68,463,512.61 168,561,949.8468,463,512.6160,696,845.94Subtotal and Average 1 1.217 Local Agency Invstmnt Fund-Housing 1Local Agency Inv Fund1113 16,748,919.97 16,748,919.97 1.21716,776,931.45 125-33-005 1.217 16,748,919.97 116,776,931.4516,748,919.9716,748,919.97Subtotal and Average 1 1.217 Money Market Accounts - CAMP 1California Asset Management Pr1153 2,850,711.99 2,850,711.99 0.51009/26/2018 2,850,711.99 1SYS1153 0.510 2,850,711.99 12,850,711.992,850,711.992,849,553.71Subtotal and Average 1 0.510 Federal Agency Coupon Securities 427Federal Farm Credit Bank1105 1,000,000.00 992,200.00 09/01/20211.70011/09/2017 1,017,610.00 1,3923133EHWM1 1.913 1,161Federal Farm Credit Bank1158 250,000.00 247,275.00 09/05/20232.80010/15/2018 269,570.00 1,7863133EJYL7 3.041 894Federal Farm Credit Bank1198 500,000.00 499,500.00 12/12/20221.87506/20/2019 519,430.00 1,2713133EKQP4 1.905 1,486Federal Farm Credit Bank1212 500,000.00 499,500.00 07/26/20241.85008/02/2019 529,490.00 1,8203133EKWV4 1.871 1,139Federal Farm Credit Bank1223 500,000.00 499,400.00 08/14/20231.60009/12/2019 519,865.00 1,4323133EKZK5 1.632 1,539Federal Farm Credit Bank1224 500,000.00 498,750.00 09/17/20241.60009/17/2019 524,935.00 1,8273133EKP75 1.652 1,218Federal Farm Credit Bank1234 1,000,000.00 996,900.00 11/01/20231.60011/01/2019 1,042,060.00 1,4613133EK4X1 1.680 1,539Federal Farm Credit Bank1242 1,000,000.00 998,600.00 09/17/20241.70012/17/2019 1,054,040.00 1,7363133ELEA8 1.731 1,323Federal Farm Credit Bank1246 1,000,000.00 999,000.00 02/14/20241.43002/14/2020 1,039,300.00 1,4613133ELNE0 1.456 820Federal Farm Credit Bank1247 1,000,000.00 999,217.36 09/29/20221.40002/05/2020 1,025,270.00 9673133EGWJ0 1.430 1,804Federal Farm Credit Bank1280 500,000.00 499,850.00 06/09/20250.50006/09/2020 500,735.00 1,8263133ELH23 0.506 1,805Federal Farm Credit Bank1282 500,000.00 500,000.00 06/10/20250.68006/10/2020 500,095.00 1,8263133ELH80 0.680 72Federal Home Loan Bank1104 1,000,000.00 996,800.00 09/11/20201.62511/09/2017 1,002,770.00 1,0373130A66T9 1.741 1,322Federal Home Loan Bank1177 500,000.00 498,550.00 02/13/20242.50003/01/2019 539,820.00 1,8103130AFW94 2.563 1,808Federal Home Loan Bank1281 500,000.00 499,850.00 06/13/20250.50006/03/2020 500,225.00 1,8363130AJKW8 0.506 1,825Federal Home Loan Bank1283 300,000.00 300,000.00 06/30/20250.68006/30/2020 299,691.00 1,8263130AJRP6 0.680 Portfolio CITY CP Run Date: 09/08/2020 - 13:58 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, 2020 Portfolio Details - Investments Average BalanceIssuer Portfolio Management City of La Quinta YTM 365TermCUSIPInvestment # Purchase Date Federal Agency Coupon Securities 1,755Federal Home Loan Mtg Corp1275 1,000,000.00 998,500.00 04/21/20250.70004/28/2020 1,000,300.00 1,8193134GVLC0 0.731 1,791Federal Home Loan Mtg Corp1279 1,000,000.00 1,000,000.00 05/27/20250.62505/27/2020 1,000,860.00 1,8263134GVYG7 0.625 1,462Federal National Mtg Assn1206 500,000.00 495,950.00 07/02/20241.75007/15/2019 527,870.00 1,8143135G0V75 1.922 797Federal National Mtg Assn1233 1,000,000.00 992,100.00 09/06/20221.37510/29/2019 1,024,840.00 1,0433135G0W33 1.659 14,011,942.36 1,52814,438,776.0014,050,000.0013,405,325.69Subtotal and Average 1,226 1.462 Treasury Coupon Securities 364U.S. Treasury1045 5,000,000.00 5,000,000.00 06/30/20211.12507/18/2016 5,047,050.00 1,808912828S27 1.125 487U.S. Treasury1070 2,000,000.00 1,942,800.00 10/31/20211.25003/27/2017 2,028,680.00 1,679912828T67 1.903 45U.S. Treasury1117 1,000,000.00 985,800.00 08/15/20201.50001/22/2018 1,001,630.00 9369128282Q2 2.071 821U.S. Treasury1178 500,000.00 489,687.50 09/30/20221.87503/01/2019 519,140.00 1,3099128282W9 2.480 683U.S. Treasury1192 500,000.00 496,650.00 05/15/20221.75005/31/2019 514,765.00 1,080912828SV3 1.984 334U.S. Treasury1193 500,000.00 493,610.00 05/31/20211.37505/31/2019 505,470.00 731912828R77 2.030 1,186U.S. Treasury1217 500,000.00 499,300.00 09/30/20231.37508/21/2019 519,315.00 1,501912828T26 1.410 1,613U.S. Treasury1241 1,000,000.00 989,687.50 11/30/20241.50012/16/2019 1,054,960.00 1,811912828YV6 1.718 10,897,535.00 1,58811,191,010.0011,000,000.0010,897,535.00Subtotal and Average 542 1.557 Certificate of Deposits 1,521First State Bk DeQueen1222 248,000.00 248,000.00 08/30/20241.80008/30/2019 261,352.32 1,827336460CX6 1.802 1,763First Freedom Bank1273 249,000.00 249,000.00 04/29/20251.20004/29/2020 255,593.52 1,82632027BAL1 1.201 1,514FirsTier Bank1216 249,000.00 249,000.00 08/23/20241.95008/23/2019 263,912.61 1,82733766LAJ7 1.952 1,7761st Internet Bank1278 248,000.00 248,000.00 05/12/20251.00005/11/2020 252,144.08 1,82732056GDJ6 0.985 1,762Firrst Natl Bk McGregor1274 248,000.00 248,000.00 04/28/20251.35004/28/2020 256,337.76 1,82632112UDR9 1.351 1,114First National Bank of America1147 245,000.00 245,000.00 07/20/20233.15007/20/2018 265,976.90 1,82632110YLK9 3.152 1,038First National Bank1179 248,000.00 248,000.00 05/05/20232.80003/05/2019 265,511.28 1,52232117BCX4 2.802 1,521First Natl Bk of Syracuse1221 249,000.00 249,000.00 08/30/20241.85008/30/2019 262,919.10 1,827334342CD2 1.852 1,689First National Bank Michigan1250 248,000.00 248,000.00 02/14/20251.65002/14/2020 259,896.56 1,82732114VBT3 1.652 1,490First Security Bank of WA1209 248,000.00 248,000.00 07/30/20242.00007/30/2019 263,279.28 1,82733625CCP2 2.002 1,414First Service Bank1231 248,000.00 248,000.00 05/15/20241.70011/15/2019 259,990.80 1,64333640VDD7 1.701 504First Source Bank1168 245,000.00 245,000.00 11/17/20213.15012/17/2018 255,145.45 1,06633646CKP8 3.153 110First Tech Federal Credit Unio1124 245,000.00 245,000.00 10/19/20202.70004/18/2018 246,911.00 91533715LBJ8 2.623 579Third Federal Savings and Loan1112 245,000.00 245,000.00 01/31/20222.50001/30/2018 253,949.85 1,46288413QBY3 2.502 1,486Abacus Federal Savings1207 248,000.00 248,000.00 07/26/20241.95007/26/2019 262,763.44 1,82700257TBD7 1.952 1,716Access Bank1256 248,000.00 248,000.00 03/13/20251.60003/13/2020 259,328.64 1,82600435JBH5 1.601 712Allegiance Bank1143 245,000.00 245,000.00 06/13/20223.10006/13/2018 258,842.50 1,46101748DBE5 3.102 834Alliance Credit Union1095 245,000.00 245,000.00 10/13/20222.25010/13/2017 256,211.20 1,82601859BAA3 2.251 Portfolio CITY CP Run Date: 09/08/2020 - 13:58 PM (PRF_PM2) 7.3.0 Days to Maturity Page 3 Par Value Book Value Maturity Date Stated RateMarket Value June 30, 2020 Portfolio Details - Investments Average BalanceIssuer Portfolio Management City of La Quinta YTM 365TermCUSIPInvestment # Purchase Date Certificate of Deposits 250Ally Bank Midvale1176 245,000.00 245,000.00 03/08/20212.50003/07/2019 249,025.35 73202007GHX4 2.016 1,731Alma Bank1267 248,000.00 248,000.00 03/28/20251.40003/30/2020 256,994.96 1,824020080BX4 1.399 727America's Credit Union1200 248,000.00 248,000.00 06/28/20222.30006/28/2019 258,296.96 1,09603065AAL7 2.302 1,696American State1255 248,000.00 248,000.00 02/21/20251.60002/21/2020 259,328.64 1,827029728BC5 1.602 292Amex Centurion1077 240,000.00 240,000.00 04/19/20212.25004/19/2017 244,089.60 1,46102587DP85 2.252 789American Express Fed Savings B1096 240,000.00 240,000.00 08/29/20222.40008/29/2017 250,490.40 1,82602587CFU9 2.402 1,090American First CU1285 248,000.00 248,000.00 06/26/20230.35006/26/2020 248,186.00 1,09502616AAH2 0.350 1,113American National Bank1205 248,000.00 248,000.00 07/19/20232.00007/19/2019 260,556.24 1,46102772JBD1 2.001 994Aneca Federal Credit Union1119 245,000.00 245,000.00 03/22/20232.80003/22/2018 261,691.85 1,826034577AH9 2.802 1,729Axos Bank1258 248,000.00 248,000.00 03/26/20251.65003/26/2020 259,899.04 1,82605465DAE8 1.651 846Barclays Bank1097 240,000.00 240,000.00 10/25/20222.30010/25/2017 251,400.00 1,82606740KLJ4 2.291 1,276Bar Harbor Bank and Trust1172 248,000.00 248,000.00 12/29/20233.35012/31/2018 273,496.88 1,824066851WJ1 3.352 1,385Belmont Bank and Trust1270 248,000.00 248,000.00 04/16/20241.25004/16/2020 255,643.36 1,46108016PDQ9 1.251 637Bellco Credit Union1264 248,000.00 248,000.00 03/30/20221.30003/31/2020 252,756.64 72907833EAD9 1.300 509Belmont Savings Bank1102 245,000.00 245,000.00 11/22/20212.10011/21/2017 251,543.95 1,462080515CD9 2.101 1,643Bank Princeton1287 248,000.00 248,000.00 12/30/20240.50006/30/2020 247,233.68 1,644064520BG3 0.500 603BMW Bank1067 240,000.00 240,000.00 02/24/20222.20002/24/2017 247,934.40 1,82605580AGK4 2.201 197Bankers Bank1086 240,000.00 240,000.00 01/14/20211.80007/14/2017 242,162.40 1,28006610RAP4 1.804 1,549BankWest Inc1227 248,000.00 248,000.00 09/27/20241.70009/27/2019 260,357.84 1,82706652CHB0 1.702 638Cadence Bank, NA1259 245,000.00 245,000.00 03/31/20221.20003/31/2020 249,302.20 73012738RFX7 1.200 341Capital One Natl Assn FDIC42971082 240,000.00 240,000.00 06/07/20212.25006/07/2017 244,744.80 1,46114042RGD7 2.252 1,742Capital One USA FDIC339541271 245,000.00 245,000.00 04/08/20251.60004/08/2020 256,164.65 1,82614042TDD6 1.601 236Comenity Capital Bank1009 240,000.00 240,000.00 02/22/20211.70002/22/2016 242,426.40 1,82720033APG5 1.702 1,521Celtic Bank1220 248,000.00 248,000.00 08/30/20241.85008/30/2019 261,863.20 1,82715118RRH2 1.852 1,415Century Next Bank1184 248,000.00 248,000.00 05/16/20242.50005/29/2019 267,755.68 1,814156634AK3 2.503 1,819Chippewa Valley Bk1284 248,000.00 248,000.00 06/24/20250.60006/24/2020 248,885.36 1,826169894AS1 0.600 1,702Citadel FCU1252 248,000.00 248,000.00 02/27/20251.65002/27/2020 259,896.56 1,82717286TAG0 1.652 783CIT Bank NA1219 245,000.00 245,000.00 08/23/20221.90008/23/2019 253,766.10 1,09612556LBA3 1.902 1,014Citibank NA1123 245,000.00 245,000.00 04/11/20232.90004/11/2018 262,649.80 1,82617312QJ26 2.902 1,734Commonwealth Business Bk1268 248,000.00 248,000.00 03/31/20251.25003/31/2020 255,251.52 1,8262027506M2 1.251 378Central State Bank1085 240,000.00 240,000.00 07/14/20211.85007/14/2017 244,202.40 1,46115523RBJ4 1.851 1,232Commercial Bank1162 248,000.00 248,000.00 11/15/20233.40011/15/2018 273,147.20 1,82620143PDV9 3.402 1,458Communitywide FCU1202 248,000.00 248,000.00 06/28/20242.25006/28/2019 265,603.04 1,82720416TAQ5 2.253 1,031Congressional Bank1189 248,000.00 248,000.00 04/28/20232.50004/30/2019 263,328.88 1,45920726ABA5 2.502 870CrossFirst Bank1106 245,000.00 245,000.00 11/18/20222.20011/20/2017 256,321.45 1,82422766ACB9 2.201 1,451Citizens State Bank1199 248,000.00 248,000.00 06/21/20242.40006/21/2019 266,999.28 1,827176688CP2 2.403 Portfolio CITY CP Run Date: 09/08/2020 - 13:58 PM (PRF_PM2) 7.3.0 Days to Maturity Page 4 Par Value Book Value Maturity Date Stated RateMarket Value June 30, 2020 Portfolio Details - Investments Average BalanceIssuer Portfolio Management City of La Quinta YTM 365TermCUSIPInvestment # Purchase Date Certificate of Deposits 580Discover Bank Greenwood DE CF1066 240,000.00 240,000.00 02/01/20222.25002/01/2017 247,831.20 1,8262546722U1 2.251 203Eagle Bank1146 245,000.00 245,000.00 01/20/20212.85007/20/2018 248,704.40 91527002YDV5 2.858 1,031EnerBank USA1125 240,000.00 240,000.00 04/28/20232.95004/30/2018 257,877.60 1,82429278TAY6 2.952 880Enterprise Bank, NA1107 245,000.00 245,000.00 11/28/20222.15011/28/2017 256,125.45 1,82629367QCP1 2.151 1,442Evansville Teachers Credit FCU1196 248,000.00 248,000.00 06/12/20242.60006/12/2019 268,856.80 1,827299547AQ2 2.603 201Farm Bureau Bank1165 248,000.00 248,000.00 01/18/20213.00012/17/2018 251,915.92 763307660LC2 2.898 667Farmers Insurance Group FCU1126 240,000.00 240,000.00 04/29/20222.80004/30/2018 251,395.20 1,46030960QAG2 2.802 1,764Flagstar1276248,000.00 248,000.00 04/30/20251.25004/30/2020 255,152.32 1,82633847E3A3 1.251 1,689Freedom Financial1248 248,000.00 248,000.00 02/14/20251.55002/14/2020 258,765.68 1,82735637RDC8 1.552 174Freedom Credit Union1111 245,000.00 245,000.00 12/22/20202.05012/22/2017 247,290.75 1,09635638BAA9 2.052 411General Electric Credit Union1150 240,000.00 240,000.00 08/16/20213.10008/15/2018 247,929.60 1,097369674AV8 3.100 664Goldman Sachs1078 240,000.00 240,000.00 04/26/20222.40004/26/2017 249,607.20 1,82638148PJK4 2.401 12First Bank of Highland1094 240,000.00 240,000.00 07/13/20201.75007/13/2017 240,141.60 1,096319141GT8 1.752 1,422Iowa State Bank1186 245,000.00 245,000.00 05/23/20242.40005/23/2019 263,531.80 1,82746256YAZ2 2.403 1,205Jefferson Financial CU1154 245,000.00 245,000.00 10/19/20233.35010/19/2018 269,017.35 1,826474067AQ8 3.352 1,415JP Morgan Chase1185 245,000.00 245,000.00 05/16/20243.25005/16/2019 238,287.00 1,82748128HXU7 3.254 685Kansas State Bank1101 245,000.00 245,000.00 05/17/20222.10011/17/2017 253,702.40 1,64250116CBE8 2.099 912Kern FCU1239 248,000.00 248,000.00 12/30/20221.90012/30/2019 258,068.80 1,09649228XAK6 1.902 911Knoxville TVA Credit Union1110 245,000.00 245,000.00 12/29/20222.40012/29/2017 257,987.45 1,826499724AB8 2.401 1,449Legacy Bank1197 248,000.00 248,000.00 06/19/20242.40006/19/2019 266,981.92 1,827524661CB9 2.403 1,427Live Oak Bank1238 248,000.00 248,000.00 05/28/20241.80011/27/2019 261,015.04 1,644538036GV0 1.802 1,307Lakeside Bank1208 248,000.00 248,000.00 01/29/20242.00007/30/2019 262,076.48 1,64451210SQU4 2.003 625Luana Savings Bank1225 245,000.00 245,000.00 03/18/20221.60009/18/2019 250,899.60 912549104JN8 1.599 607Maine Savings FCU1171 248,000.00 248,000.00 02/28/20223.30012/28/2018 260,764.56 1,158560507AK1 3.306 1,395Main Street Bank1188 248,000.00 248,000.00 04/26/20242.60004/26/2019 268,353.36 1,82756065GAG3 2.603 1,203Marlin Business Bank1155 248,000.00 248,000.00 10/17/20233.30010/17/2018 271,847.68 1,82657116ARV2 3.302 889Medallion Bank1169 248,000.00 248,000.00 12/07/20223.40012/07/2018 266,890.16 1,46158404DCX7 3.402 6Mercantile Bank of Michigan1087 240,000.00 240,000.00 07/07/20201.75007/07/2017 240,076.80 1,09658740XZL7 1.752 1,603Morgan Stanley Bank1237 245,000.00 245,000.00 11/20/20241.95011/20/2019 259,935.20 1,82761690UNX4 1.952 1,084Morton Community1173 248,000.00 248,000.00 06/20/20232.75003/20/2019 265,801.44 1,553619165JD6 2.753 849Merrick Bank1163 248,000.00 248,000.00 10/28/20223.25010/30/2018 265,283.12 1,45959013J4K2 3.252 1,603Morgan Stanley Private Bk, NA1236 245,000.00 245,000.00 11/20/20241.90011/20/2019 259,403.55 1,82761760A3B3 1.902 860Mountain America Federal CU1099 245,000.00 245,000.00 11/08/20222.30011/08/2017 256,769.80 1,82662384RAC0 2.301 1,203Municipal Trust and Savings1160 245,000.00 245,000.00 10/17/20233.20010/17/2018 267,758.05 1,826625925AR3 3.202 1,734Nicolet Natl Bank1266 248,000.00 248,000.00 03/31/20251.40003/31/2020 256,992.48 1,826654062JZ2 1.401 538Neighbors FCU1167 245,000.00 245,000.00 12/21/20213.20012/21/2018 255,931.90 1,09664017AAQ7 3.203 Portfolio CITY CP Run Date: 09/08/2020 - 13:58 PM (PRF_PM2) 7.3.0 Days to Maturity Page 5 Par Value Book Value Maturity Date Stated RateMarket Value June 30, 2020 Portfolio Details - Investments Average BalanceIssuer Portfolio Management City of La Quinta YTM 365TermCUSIPInvestment # Purchase Date Certificate of Deposits 215Infinty FCU1211 248,000.00 248,000.00 02/01/20212.10007/31/2019 250,864.40 55145667EDY1 2.110 1,268National Cooperative Bank, N.A1170 245,000.00 245,000.00 12/21/20233.40012/21/2018 270,499.60 1,826635573AL2 3.402 1,245Numerica Credit Union1164 248,000.00 248,000.00 11/28/20233.55011/28/2018 274,635.20 1,82667054NAN3 3.552 482Northpointe Bank1127 240,000.00 240,000.00 10/26/20212.70004/26/2018 247,992.00 1,279666613GV0 2.703 1,003Northstar Bank1263 248,000.00 248,000.00 03/31/20231.15003/31/2020 253,790.80 1,09566704MEQ0 1.150 1,322Northwest Bank1181 248,000.00 248,000.00 02/13/20242.95002/13/2019 270,642.40 1,82666736ABP3 2.951 1,125Bank of New England1151 249,000.00 249,000.00 07/31/20233.25007/31/2018 271,263.09 1,82606426KAN8 3.252 453New York Community Bank1226 245,000.00 245,000.00 09/27/20211.80009/27/2019 249,961.25 731649447TC3 1.802 567The Ohio Valley Bank1089 240,000.00 240,000.00 01/19/20221.90007/19/2017 246,360.00 1,645677721CN0 1.903 1,385Pacific Western Bank1269 245,000.00 245,000.00 04/16/20241.30004/16/2020 253,016.40 1,46169506YRH4 1.301 707PCSB Bank1149 245,000.00 245,000.00 06/08/20223.00006/08/2018 258,220.20 1,46169324MAD7 3.002 1,491People's Bank1210 248,000.00 248,000.00 07/31/20242.00007/31/2019 263,281.76 1,827710571DS6 2.002 1,071Pittsfield Cooperative Bank1194 245,000.00 245,000.00 06/07/20232.50006/07/2019 260,648.15 1,461725404AB3 2.502 1,437Plains Commerce Bank1195 245,000.00 245,000.00 06/07/20242.55006/07/2019 265,094.90 1,82772651LCL6 2.553 1,507Preferred Bank1213 249,000.00 249,000.00 08/16/20242.00008/16/2019 264,395.67 1,827740367HP5 2.002 329PrivateBank & Trust1032 240,000.00 240,000.00 05/26/20211.50005/26/2016 243,177.60 1,82674267GVG9 1.501 1,148Raymond James Bank1218 244,000.00 244,000.00 08/23/20231.95008/23/2019 256,253.68 1,46175472RAD3 1.951 1,084RCB Bank1144 245,000.00 245,000.00 06/20/20233.15006/20/2018 265,484.45 1,82674934YAH4 3.152 889Red Rocks Credit Union1166 248,000.00 248,000.00 12/07/20223.35012/07/2018 266,587.60 1,46175701LAB3 3.352 1,458Revere Bank1203 247,000.00 247,000.00 06/28/20242.30006/28/2019 265,033.47 1,827761402BY1 2.303 145First Bank Richmond1081 245,000.00 245,000.00 11/23/20201.80006/21/2017 246,663.55 1,251319267GC8 1.802 1,321Rollstone B&T1251 245,000.00 245,000.00 02/12/20241.65002/12/2020 255,919.65 1,46177579ADF0 1.651 720Sallie Mae Bank Salt Lake CIty1083 240,000.00 240,000.00 06/21/20222.35006/21/2017 250,147.20 1,826795450A70 2.351 1,590Sauk Valley B&T Co1235 248,000.00 248,000.00 11/07/20241.70011/07/2019 260,404.96 1,827804375DL4 1.702 965Servisfirst Bank1254 248,000.00 248,000.00 02/21/20231.60002/21/2020 256,573.36 1,09681768PAF3 1.601 912San Francisco FCU1240 248,000.00 248,000.00 12/30/20221.85012/30/2019 248,302.31 1,09679772FAC0 1.852 638Bank of Santa Clarita1261 248,000.00 248,000.00 03/31/20221.10003/31/2020 251,901.04 73006424KBC3 1.100 1,723Spring Bank1257 248,000.00 248,000.00 03/20/20251.50003/20/2020 258,170.48 1,826849430BF9 1.501 1,577Southern Bancorp Bk1286 248,000.00 248,000.00 10/25/20240.50006/26/2020 247,690.00 1,58284223QAN7 0.500 789Sterling Bank1201 245,000.00 245,000.00 08/29/20222.15006/28/2019 255,187.10 1,15885916VDC6 2.153 701Synchrony Bank Retail1080 240,000.00 240,000.00 06/02/20222.40006/02/2017 250,120.80 1,82687164XQV1 2.401 708Synovus Bank1253 245,000.00 245,000.00 06/09/20221.60003/09/2020 251,629.70 82287164DRD4 1.602 1,366Texas Bank Financial1260 245,000.00 245,000.00 03/28/20241.10003/31/2020 251,164.20 1,458882213AB7 1.101 1,384The Jefferson Bank1272 248,000.00 248,000.00 04/15/20241.25004/15/2020 255,640.88 1,461472382AQ3 1.251 303Towne Bank1128 240,000.00 240,000.00 04/30/20212.80004/30/2018 245,342.40 1,09689214PBL2 2.803 768Traditions Bank1148 245,000.00 245,000.00 08/08/20223.00006/08/2018 259,276.15 1,52289269CBX9 3.002 Portfolio CITY CP Run Date: 09/08/2020 - 13:58 PM (PRF_PM2) 7.3.0 Days to Maturity Page 6 Par Value Book Value Maturity Date Stated RateMarket Value June 30, 2020 Portfolio Details - Investments Average BalanceIssuer Portfolio Management City of La Quinta YTM 365TermCUSIPInvestment # Purchase Date Certificate of Deposits 1,185Triad Bank1262 248,000.00 248,000.00 09/29/20231.35003/30/2020 255,940.96 1,27889579NCD3 1.352 509TNB Bank1187 248,000.00 248,000.00 11/22/20212.40005/22/2019 255,660.72 91587266AAA1 2.407 1,203UBS Bank USA1161 245,000.00 245,000.00 10/17/20233.35010/17/2018 268,961.00 1,82690348JEJ5 3.352 258Unity Bank1120 245,000.00 245,000.00 03/16/20212.55003/16/2018 249,209.10 1,09691330ABN6 2.552 1,682United Community1249 248,000.00 248,000.00 02/07/20251.65002/07/2020 259,896.56 1,82790983WBT7 1.652 539United Credit Union1214 248,000.00 248,000.00 12/22/20212.00008/22/2019 254,636.48 853910160AH3 2.003 1,048University of Iowa Comm. CU1134 240,000.00 240,000.00 05/15/20233.05005/14/2018 258,806.40 1,82791435LAG2 3.052 972Verus Bank of Commerce1180 248,000.00 248,000.00 02/28/20232.70002/28/2019 263,852.16 1,46192535LCD4 2.700 1,336Wells Fargo1174 248,000.00 248,000.00 02/27/20243.00002/27/2019 269,727.28 1,826949763XY7 3.001 1,003West Michigan Cmnty Bk1265 248,000.00 248,000.00 03/31/20231.15003/31/2020 253,790.80 1,095954444BS3 1.150 943Wells Fargo Natl Bank West1244 248,000.00 248,000.00 01/30/20231.90001/29/2020 258,354.00 1,097949495AT2 1.900 1,514Washington Federal1215 248,000.00 248,000.00 08/23/20242.00008/23/2019 263,361.12 1,827938828BH2 2.002 1,777Western State Bank1277 245,000.00 245,000.00 05/13/20251.00005/13/2020 249,091.50 1,82695960NKD8 1.001 34,164,000.00 1,54335,725,057.1434,164,000.0033,526,066.67Subtotal and Average 1,049 2.157 Corporate Notes 399Apple Inc1079 500,000.00 493,050.00 08/04/20211.55006/12/2017 507,340.00 1,514037833CC2 1.900 945Colgate-Palmolive1175 500,000.00 485,250.00 02/01/20231.95003/04/2019 521,315.00 1,43019416QEA4 2.751 1,133Microsoft Corporation1157 400,000.00 378,360.00 08/08/20232.00010/15/2018 418,664.00 1,758594918BQ6 3.222 585Proctor and Gamble1159 500,000.00 487,950.00 02/06/20222.30010/15/2018 516,185.00 1,210742718DY2 3.071 897Wal-Mart Stores, Inc1190 500,000.00 496,650.00 12/15/20222.35004/16/2019 523,965.00 1,339931142DU4 2.799 2,341,260.00 1,4362,487,469.002,400,000.002,341,260.00Subtotal and Average 775 2.725 Money Market with Fiscal Agent 1US Bank1058 5,360.90 5,360.9007/01/2016 5,360.90 1SYS1058 0.000 5,360.90 15,360.905,360.905,360.88Subtotal and Average 1 0.000 CERBT - OPEB Trust 1CalPERS CERBT Plan1114 1,714,840.82 1,714,840.8207/01/2019 1,714,840.82 1SYS1114 0.000 1,714,840.82 11,714,840.821,714,840.821,549,002.82Subtotal and Average 1 0.000 PARS Pension Trust 1Pblc Agncy Rtrmnt Serv1230 10,249,737.64 10,249,737.6408/01/2019 10,249,737.64 1SYS1230 0.000 10,249,737.64 110,249,737.6410,249,737.6410,135,864.13Subtotal and Average 1 0.000 Portfolio CITY CP Run Date: 09/08/2020 - 13:58 PM (PRF_PM2) 7.3.0 Days to Maturity Page 7 Par Value Book Value Stated RateMarket Value June 30, 2020 Portfolio Details - Investments Average BalanceIssuer Portfolio Management City of La Quinta YTM 365TermCUSIPInvestment # Purchase Date 558155,200,632.44 170,194,403.79 358 1.310172,549,164.64 169,995,141.15Total and Average Portfolio CITY CP Run Date: 09/08/2020 - 13:58 PM (PRF_PM2) 7.3.0 City of La Quinta Total Earnings City of La Quinta - Sorted by Fund - Fund June 1, 2020 - June 30, 2020 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.0010020.00 1.650MIDWES 123.32 0.00 123.321.650101248,000.00063615AVO 0.00 240,000.001009240,000.00 1.700CCBA 335.34 0.00 335.341.700101240,000.0020033APG5 0.00 0.0010170.00 1.700EVRBA 46.20 0.00 46.201.700101248,000.0029976DXX3 0.00 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,634.31 0.00 4,634.311.1281015,000,000.00912828S27 0.00 68,463,512.61105568,463,512.61 1.217LAIF 73,068.68 0.00 73,068.681.63210154,463,512.6198-33-434 0.00 239,812.131057239,812.13WELLS 0.01 0.00 0.01101588,229.844159282482 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,038.05 0.00 2,038.051.2761011,942,800.00912828T67 0.00 240,000.001077240,000.00 2.250AMEX 443.83 0.00 443.832.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.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 245,000.001081245,000.00 1.800RICHMN 362.46 0.00 362.461.800101245,000.00319267GC8 0.00 240,000.001082240,000.00 2.250CAP1NA 443.84 0.00 443.842.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.001086240,000.00 1.800BNKRS 355.07 0.00 355.071.800101240,000.0006610RAP4 0.00 240,000.001087240,000.00 1.750MERCTL 345.21 0.00 345.211.750101240,000.0058740XZL7 0.00 240,000.001089240,000.00 1.900OHVAL 374.79 0.00 374.791.900101240,000.00677721CN0 0.00 240,000.001094240,000.00 1.750HIGHLD 345.21 0.00 345.211.750101240,000.00319141GT8 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 996,800.0011041,000,000.00 1.625FHLB 1,354.17 0.00 1,354.171.653101996,800.003130A66T9 0.00 Portfolio CITY CP Run Date: 09/08/2020 - 14:02 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, 2020 - June 30, 2020 Total Earnings City of La Quinta Annualized YieldCUSIPInvestment # Interest EarnedIssuer Realized Gainl/Loss Fund: General Fund 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.001111245,000.00 2.050FREECU 412.81 0.00 412.812.050101245,000.0035638BAA9 0.00 245,000.001112245,000.00 2.5003RD 503.43 0.00 503.432.500101245,000.0088413QBY3 0.00 1,714,840.8211141,714,840.82CALPRS 0.00 0.00 0.001011,543,284.27SYS1114 0.00 985,800.0011171,000,000.00 1.500USTR 1,236.26 0.00 1,236.261.526101985,800.009128282Q2 0.00 245,000.001119245,000.00 2.800ANECA 563.84 0.00 563.842.800101245,000.00034577AH9 0.00 245,000.001120245,000.00 2.550UNITY 513.49 0.00 513.492.550101245,000.0091330ABN6 0.00 245,000.001123245,000.00 2.900CITINA 583.97 0.00 583.972.900101245,000.0017312QJ26 0.00 245,000.001124245,000.00 2.7001STTCH 543.70 0.00 543.702.700101245,000.0033715LBJ8 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 240,000.001127240,000.00 2.700NORPNT 532.60 0.00 532.602.700101240,000.00666613GV0 0.00 240,000.001128240,000.00 2.800TOWNE 552.33 0.00 552.332.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 0.0011450.00 2.750WEX 258.43 0.00 258.432.750101245,000.0092937CHG6 0.00 245,000.001146245,000.00 2.850EAGLE 573.90 0.00 573.902.850101245,000.0027002YDV5 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 2,850,711.9911532,850,711.99 0.510CAMP 1,198.22 0.00 1,198.220.5121012,849,513.77SYS1153 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 Portfolio CITY CP Run Date: 09/08/2020 - 14:02 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, 2020 - June 30, 2020 Total Earnings City of La Quinta Annualized YieldCUSIPInvestment # Interest EarnedIssuer Realized Gainl/Loss Fund: General Fund 248,000.001165248,000.00 3.000FARMBU 611.51 0.00 611.513.000101248,000.00307660LC2 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 245,000.001176245,000.00 2.500ALLY 503.42 0.00 503.422.500101245,000.0002007GHX4 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 0.0011830.00STIFEL 10.80 0.00 10.800.0061012,028,916.15SYS1183 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 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 493,610.001193500,000.00 1.375USTR 563.53 0.00 563.531.389101493,610.00912828R77 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 Portfolio CITY CP Run Date: 09/08/2020 - 14:02 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, 2020 - June 30, 2020 Total Earnings City of La Quinta Annualized YieldCUSIPInvestment # Interest EarnedIssuer Realized Gainl/Loss Fund: General Fund 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 248,000.001211248,000.00 2.100NFNITY 428.05 0.00 428.052.100101248,000.0045667EDY1 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 248,000.001227248,000.00 1.700BNKWST 346.52 0.00 346.521.700101248,000.0006652CHB0 0.00 8,084,992.7412288,084,992.74BOTW 0.01 0.00 0.01101810,612.43059731851 0.00 10,249,737.64123010,249,737.64PARS 0.00 0.00 0.0010110,131,937.46SYS1230 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 Portfolio CITY CP Run Date: 09/08/2020 - 14:02 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, 2020 - June 30, 2020 Total Earnings City of La Quinta Annualized YieldCUSIPInvestment # Interest EarnedIssuer Realized Gainl/Loss Fund: General Fund 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.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 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 998,500.0012751,000,000.00 0.700FHLMC 583.33 0.00 583.330.711101998,500.003134GVLC0 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 152.78 0.00 152.780.5071010.003133ELH23 0.00 499,850.001281500,000.00 0.500FHLB 194.45 0.00 194.450.5071010.003130AJKW8 0.00 500,000.001282500,000.00 0.680FFCB 198.33 0.00 198.330.6891010.003133ELH80 0.00 Portfolio CITY CP Run Date: 09/08/2020 - 14:02 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, 2020 - June 30, 2020 Total Earnings City of La Quinta Annualized YieldCUSIPInvestment # Interest EarnedIssuer Realized Gainl/Loss Fund: General Fund 300,000.001283300,000.00 0.680FHLB 5.67 0.00 5.670.6901010.003130AJRP6 0.00 248,000.001284248,000.00 0.600CHIPVA 24.46 0.00 24.460.6001010.00169894AS1 0.00 248,000.001285248,000.00 0.350AMR1ST 9.51 0.00 9.510.3501010.0002616AAH2 0.00 248,000.001286248,000.00 0.500STHRNB 13.59 0.00 13.590.5001010.0084223QAN7 0.00 248,000.001287248,000.00 0.500BKPRNC 0.00 0.00 0.001010.00064520BG3 0.00 153,220,907.93Subtotal 153,021,645.29 1.530 166,748.160.00166,748.16131,783,343.89 0.00 Fund: Fiscal Agent 5,360.9010585,360.90USBANK 0.02 0.00 0.020.0052315,360.88SYS1058 0.00 5,360.90Subtotal 5,360.90 0.005 0.020.000.025,360.88 0.00 Fund: Housing Authority : WSA and LQ 219,214.991062219,214.99LQPR 0.00 0.00 0.00241221,722.48SYS1062 0.00 219,214.99Subtotal 219,214.99 0.000.000.00221,722.48 0.00 Fund: SA Low/Mod Bond Fund 16,748,919.97111316,748,919.97 1.217LAIF 20,162.85 0.00 20,162.851.46524916,748,919.9725-33-005 0.00 16,748,919.97Subtotal 16,748,919.97 1.465 20,162.850.0020,162.8516,748,919.97 0.00 170,194,403.79Total 169,995,141.15 1.520 186,911.030.00186,911.03148,759,347.22 0.00 Portfolio CITY CP Run Date: 09/08/2020 - 14:02 TE (PRF_TE) 7.3.6 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, 2020 - June 30, 2020 Rate at MaturityPar Value Sec. TypeFund Maturity Date Maturity ProceedsInterest Income Net CUSIP Investment #Issuer Purchase Date Book Value at Maturity 240,000.00 1.600 240,326.14326.1404/21/2017STRNS1076857894TC3MC110104/21/2020 326.14240,000.00 500,000.00 1.125 502,812.502,812.5005/31/2018USTR1138912828VA5TRC10104/30/2020 14,562.50488,250.00 500,000.00 1.550 503,875.003,875.0005/31/2018FFCB11423133EHJA2FAC10105/08/2020 12,125.00491,750.00 245,000.00 1.750 245,035.2435.2411/09/2017JFFRSN1100472376AC6MC110105/12/2020 35.24245,000.00 248,000.00 1.700 250,113.782,113.7806/05/2015EVRBA101729976DXX3MC110106/05/2020 2,113.78248,000.00 248,000.00 1.650 248,347.54347.5406/12/2015MIDWES1002063615AVOMC110106/12/2020 347.54248,000.00 245,000.00 2.750 245,036.9236.9206/13/2018WEX114592937CHG6MC110106/15/2020 36.92245,000.00 2,235,547.12Total Maturities 2,226,000.00 9,547.122,206,000.00 29,547.12 Portfolio CITY CP Run Date: 09/08/2020 - 14:04 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, 2020 - June 30, 2020 Redem. Date Redemption Principal Redemption Interest Book Value at Redem. Total Amount Net IncomeFundMatur. Date Rate at Redem. Par ValueSec. TypeCUSIPInvestment # Issuer Purchase Date 06/10/2020 245,000.00 245,000.00 245,061.25 1,504.901006140420RX004/06/2020 246,566.15 1,566.15101CAPONE MC1 06/10/2020 06/10/2015 1.900 Sale Subtotal 245,000.00 245,061.25 1,504.90245,000.00 246,566.15 1,566.15 04/08/2021 500,000.00 499,750.00 502,250.00 1,319.44120489236TCZ605/28/2020 503,569.44 3,819.44101TOYOTA MC2 04/08/2021 06/24/2019 1.900 Sale Subtotal 499,750.00 502,250.00 1,319.44500,000.00 503,569.44 3,819.44 04/28/2021 2,500,000.00 2,491,250.00 2,500,000.00 16,875.0010533130A7QZ104/28/2020 2,516,875.00 25,625.00101FHLB FAC 04/28/2021 04/28/2016 1.350 Call Subtotal 2,491,250.00 2,500,000.00 16,875.002,500,000.00 2,516,875.00 25,625.00 10/07/2024 500,000.00 500,000.00 515,000.00 1,416.67123289236TGL305/28/2020 516,416.67 16,416.67101TOYOTA MC2 10/07/2024 10/23/2019 2.000 Sale Subtotal 500,000.00 515,000.00 1,416.67500,000.00 516,416.67 16,416.67 3,762,311.25Total Sales 3,745,000.00 21,116.013,736,000.00 3,783,427.26 47,427.26 Portfolio CITY CP Run Date: 09/08/2020 - 14:06 SA (PRF_SA) 7.1.1 Report Ver. 7.3.6.1 City of La Quinta -City of La Quinta Purchases Report Sorted by Fund - Fund April 1, 2020 - June 30, 2020 Original Par Value Ending Book Value Sec. TypeFund Maturity YTM Accrued Interest at PurchasePayment Periods DateCUSIPInvestment #Issuer Purchase Date Principal Purchased Rate at Purchase General Fund 245,000.00 1.600 04/08/2025 245,000.00245,000.0004/08/2020 1.60110/08 - 04/08CAPONE127114042TDD6MC1101 248,000.00 1.250 04/15/2024 248,000.00248,000.0004/15/2020 1.25105/15 - MonthlyTHEJEF1272472382AQ3MC1101 248,000.00 1.250 04/16/2024 248,000.00248,000.0004/16/2020 1.25105/16 - MonthlyBELB&T127008016PDQ9MC1101 245,000.00 1.300 04/16/2024 245,000.00245,000.0004/16/2020 1.30110/16 - 04/16PACWST126969506YRH4MC1101 248,000.00 1.350 04/28/2025 248,000.00248,000.0004/28/2020 1.35105/28 - Monthly1STMCG127432112UDR9MC1101 1,000,000.00 0.700 04/21/2025 998,500.00998,500.00 Received04/28/2020 0.73110/21 - 04/21FHLMC12753134GVLC0FAC101 249,000.00 1.200 04/29/2025 249,000.00249,000.0004/29/2020 1.20105/29 - Monthly1STFDM127332027BAL1MC1101 248,000.00 1.250 04/30/2025 248,000.00248,000.0004/30/2020 1.25110/30 - 04/30FLGSTR127633847E3A3MC1101 248,000.00 1.000 05/12/2025 248,000.00248,000.0005/11/2020 0.98506/11 - Monthly1STINT127832056GDJ6MC1101 245,000.00 1.000 05/13/2025 245,000.00245,000.0005/13/2020 1.00111/13 - 05/13WSTRNS127795960NKD8MC1101 1,000,000.00 0.625 05/27/2025 1,000,000.001,000,000.0005/27/2020 0.62511/27 - 05/27FHLMC12793134GVYG7FAC101 500,000.00 0.500 06/13/2025 499,850.00499,850.00 Received06/03/2020 0.50612/13 - 06/13FHLB12813130AJKW8FAC101 500,000.00 0.500 06/09/2025 499,850.00499,850.0006/09/2020 0.50612/09 - 06/09FFCB12803133ELH23FAC101 500,000.00 0.680 06/10/2025 500,000.00500,000.0006/10/2020 0.68012/10 - 06/10FFCB12823133ELH80FAC101 248,000.00 0.600 06/24/2025 248,000.00248,000.0006/24/2020 0.60007/24 - MonthlyCHIPVA1284169894AS1MC1101 248,000.00 0.350 06/26/2023 248,000.00248,000.0006/26/2020 0.35007/26 - MonthlyAMR1ST128502616AAH2MC1101 248,000.00 0.500 10/25/2024 248,000.00248,000.0006/26/2020 0.50007/26 - MonthlySTHRNB128684223QAN7MC1101 248,000.00 0.500 12/30/2024 248,000.00248,000.0006/30/2020 0.50007/30 - MonthlyBKPRNC1287064520BG3MC1101 300,000.00 0.680 06/30/2025 300,000.00300,000.0006/30/2020 0.68012/30 - 06/30FHLB12833130AJRP6FAC101 Subtotal 7,014,200.007,014,200.00 0.007,016,000.00 7,014,200.00Total Purchases 7,016,000.00 0.00 7,014,200.00 Received = Accrued Interest at Purchase was received by report ending date. Portfolio CITY CP Run Date: 09/08/2020 - 14:03 PU (PRF_PU) 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 Date 1 mo 2 mo 3 mo 6 mo 1 yr 2 yr 3 yr 5 yr 7 yr 10 yr 20 yr 30 yr 4/30/2020 0.1 0.1 0.09 0.11 0.16 0.2 0.24 0.36 0.53 0.64 1.05 1.28 5/29/2020 0.13 0.14 0.14 0.18 0.17 0.16 0.19 0.3 0.5 0.65 1.18 1.41 6/30/2020 0.13 0.14 0.16 0.18 0.16 0.16 0.18 0.29 0.49 0.66 1.18 1.41 Date 1 mo 2 mo 3 mo 6 mo 1 yr 2 yr 3 yr 5 yr 7 yr 10 yr 20 yr 30 yr Effective Rate of Return City Portfolio (month) 7/31/2018 1.94 2.03 2.21 2.44 2.67 2.77 2.85 2.92 2.96 3.03 3.08 1.73 8/31/2018 1.95 2.11 2.28 2.46 2.62 2.70 2.74 2.81 2.86 2.95 3.02 1.78 9/28/2018 2.12 2.19 2.36 2.59 2.81 2.88 2.94 3.01 3.05 3.13 3.19 1.75 10/31/2018 2.2 2.34 2.49 2.69 2.87 2.93 2.98 3.07 3.15 3.3 3.39 2.01 11/30/2018 2.31 2.37 2.52 2.70 2.80 2.83 2.84 2.92 3.01 3.19 3.3 2.07 12/31/2018 2.44 2.45 2.56 2.63 2.48 2.46 2.51 2.59 2.69 2.87 3.02 2.03 1/31/2019 2.42 2.43 2.41 2.46 2.55 2.45 2.43 2.43 2.51 2.63 2.83 2.99 2.11 2/28/2019 2.44 2.47 2.45 2.50 2.54 2.52 2.50 2.52 2.63 2.73 2.94 3.09 2.18 3/29/2019 2.43 2.44 2.40 2.44 2.40 2.27 2.21 2.23 2.31 2.41 2.63 2.81 2.15 4/30/2019 2.43 2.44 2.43 2.46 2.39 2.27 2.24 2.28 2.39 2.51 2.75 2.93 2.18 5/31/2019 2.35 2.38 2.35 2.35 2.21 1.95 1.90 1.93 2.03 2.14 2.39 2.58 2.19 6/28/2019 2.18 2.15 2.12 2.09 1.92 1.75 1.71 1.76 1.87 2.00 2.31 2.52 2.27 7/31/2019 2.01 2.07 2.08 2.10 2.00 1.89 1.84 1.84 1.92 2.02 2.31 2.53 2.21 8/30/2019 2.10 2.04 1.99 1.89 1.76 1.50 1.42 1.39 1.45 1.50 1.78 1.96 2.15 9/30/2019 1.91 1.87 1.88 1.83 1.75 1.63 1.56 1.55 1.62 1.68 1.94 2.12 1.92 10/31/2019 1.59 1.59 1.54 1.57 1.53 1.52 1.52 1.51 1.6 1.69 2 2.17 1.92 11/29/2019 1.62 1.6 1.59 1.63 1.6 1.61 1.61 1.62 1.73 1.78 2.07 2.21 1.88 12/31/2019 1.48 1.51 1.55 1.6 1.59 1.58 1.62 1.69 1.83 1.92 2.25 2.39 2.00 1/31/2020 1.56 1.57 1.55 1.54 1.45 1.33 1.3 1.32 1.42 1.51 1.83 1.99 1.70 2/28/2020 1.45 1.37 1.27 1.11 0.97 0.86 0.85 0.89 1.03 1.13 1.46 1.65 1.77 3/31/2020 0.05 0.12 0.11 0.15 0.17 0.23 0.29 0.37 0.55 0.7 1.15 1.35 1.81 4/30/2020 0.1 0.1 0.09 0.11 0.16 0.2 0.24 0.36 0.53 0.64 1.05 1.28 1.57 5/29/2020 0.13 0.14 0.14 0.18 0.17 0.16 0.19 0.3 0.5 0.65 1.18 1.41 1.50 6/30/2020 0.13 0.14 0.16 0.18 0.16 0.16 0.18 0.29 0.49 0.66 1.18 1.41 1.47