Loading...
FY 2020-2021 Quarter 4 (Apr-Jun 2021) Treasurer ReporteCai Otiadai GEM of the DESERT — — City of La Quinta Portfolio Management Portfolio Summary April 30, 2021 City of La Quinta Investments Par Market Book % of Days to YTM Value Value Value Portfolio Term Maturity 365 Equiv. Bank Accounts 13,266,643.14 13,266,643 14 13,266,64314 8.20 1 0.000 Local Agency Investment Fund -City 55,429,948 66 55,766,295 86 55,429,948 66 34.27 1 0 339 Local Agency Invstmnt Fund -Housing 10,580,686 54 10,662,970 55 10,580,686 54 6.54 1 1 0 339 Money Market Accounts - CAMP 854,097 00 854,097.00 854,097 00 0.53 1 1 0 060 Federal Agency Coupon Securities 21,050,000.00 21,220,756.00 20,989,531 86 12 98 1,628 1.242 1 099 Treasury Coupon Securities 12,500,000.00 12,541,175 00 12,375,155 31 7.65 1,669 565 1 335 Certificate of Deposits 32,241,000.00 33,327,053 71 32,241,000 00 19.93 1,605 885 2 085 Corporate Notes 2,900,000 00 2,947,139 00 2,838,560 00 1.76 1,504 697 2 354 Money Market with Fiscal Agent 1,422 08 1,422 08 1,422 08 0.00 1 1 0.000 CERBT - OP EB Trust 1,934,231.01 1,934, 231 01 1,934,231 01 1 20 1 1 0 000 PARS Pension Trust 11,227,866.79 11,227,866 79 11,227,866 79 6 94 1 1 0 000 Investments Total Earnings Current Year Average Daily Balance Effective Rate of Return 161, 985, 895.22 163, 749, 650.14 April 30 Month Ending 108,609.87 157,037,173.30 0.84% Fiscal Year To Date 1,308,622.80 158,796,433.85 0.99% 161,739,142.39 100.00% 686 394 0.840 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 Claudia Martinez, Interim Finance Director Reporting period 04/0112021-04/3012021 Run Date: 09/10/2021 - 10:04 ctigiog4 Portfolio CITY CP PM (PRF_PM1) 7 3 0 Report Ver 7 3 6 1 City of La Quinta Portfolio Management Portfolio Details - Investments April 30, 2021 Page 1 Average Purchase Stated Days to YTM Maturity CUSIP Investment # Issuer Balance Date Par Value Market Value Book Value Rate Term Maturity 365 Date Bank Accounts SYS1293 1293 Bank of New York 09/01/2020 3,254,568.53 3,254,568.53 3,254,568.53 1 1 0.000 059731851 1228 Bank of the West 08/20/2019 9,456,806.96 9,456,806.96 9,456,806.96 1 1 0.000 SYS1059 1059 City Petty Cash 07/01/2016 3,300.00 3,300.00 3,300.00 1 1 0.000 SYS1318 1318 Dune Palms Mobile Estates 03/09/2021 217,583.21 217,583.21 217,583.21 1 1 0.000 SYS1062 1062 La Quinta Palms Realty 07/01/2016 334,384.44 334,384.44 334,384.44 1 1 0.000 SYS1183 1183 Stifel, Nicolaus & Company 03/18/2019 0.00 0.00 0.00 1 1 0.000 Subtotal and Average 8,336,870.04 13,266,643.14 13,266,643.14 13,266,643.14 1 1 0.000 Local Agency Investment Fund -City 98-33-434 1055 Local Agency Inv Fund 55,429,948.66 55,766,295.86 55,429,948.66 0.339 1 1 0.339 Subtotal and Average 55,932,381.59 55,429,948.66 55,766,295.86 55,429,948.66 1 1 0.339 Local Agency Invstmnt Fund -Housing 25-33-005 1113 Local Agency Inv Fund Subtotal and Average 10,575,298.67 10,580,686.54 10,580,686.54 10,662,970.55 10,580,686.54 0.339 1 1 0.339 10,662,970.55 10,580,686.54 1 1 0.339 Money Market/Mutual Funds X9USDDTP3 1294 Dreyfus 09/24/2020 0.00 0.00 0.00 1 1 0.000 Subtotal and Average 0.00 0.00 0.00 0.00 0 0 0.000 Money Market Accounts - CAMP SYS1153 1153 California Asset Management Pr Subtotal and Average 854,059.58 09/26/2018 854,097.00 854,097.00 854, 097.00 0.060 1 1 0.060 854,097.00 854,097.00 854,097.00 1 1 0.060 Federal Agency Coupon Securities 3133EHWM1 1105 Federal Farm Credit Bank 11/09/2017 1,000,000.00 1,005,530.00 992,200.00 1.700 1,392 123 1.913 09/01/2021 3133EJYL7 1158 Federal Farm Credit Bank 10/15/2018 250,000.00 264,945.00 247,275.00 2.800 1,786 857 3.041 09/05/2023 3133EKQP4 1198 Federal Farm Credit Bank 06/20/2019 500,000.00 513,900.00 499,500.00 1.875 1,271 590 1.905 12/12/2022 3133EKWV4 1212 Federal Farm Credit Bank 08/02/2019 500,000.00 523,120.00 499,500.00 1.850 1,820 1,182 1.871 07/26/2024 3133EKZK5 1223 Federal Farm Credit Bank 09/12/2019 500,000.00 515,675.00 499,400.00 1.600 1,432 835 1.632 08/14/2023 3133EKP75 1224 Federal Farm Credit Bank 09/17/2019 500,000.00 518,850.00 498,750.00 1.600 1,827 1,235 1.652 09/17/2024 3133EK4X1 1234 Federal Farm Credit Bank 11/01/2019 1,000,000.00 1,032,970.00 996,900.00 1.600 1,461 914 1.680 11/01/2023 3133ELEA8 1242 Federal Farm Credit Bank 12/17/2019 1,000,000.00 1,042,280.00 998,600.00 1.700 1,736 1,235 1.731 09/17/2024 3133ELNE0 1246 Federal Farm Credit Bank 02/14/2020 1,000,000.00 1,030,360.00 999,000.00 1.430 1,461 1,019 1.456 02/14/2024 3133EGWJO 1247 Federal Farm Credit Bank 02/05/2020 1,000,000.00 1,017,750.00 999,217.36 1.400 967 516 1.430 09/29/2022 Run Date: 09/10/2021 - 10:04 Portfolio CITY CP PM (PRF_PM2) 7.3.0 Report Ver. 7.3.6.1 CUSIP Investment # Issuer City of La Quinta Portfolio Management Portfolio Details - Investments April 30, 2021 Average Purchase Balance Date Par Value Page 2 Stated Days to YTM Maturity Market Value Book Value Rate Term Maturity 365 Date Federal Agency Coupon Securities 3133ELH23 1280 Federal Farm Credit Bank 06/09/2020 500,000.00 496,355.00 499,850.00 0.500 1,826 1,500 0.506 06/09/2025 3133ELH80 1282 Federal Farm Credit Bank 06/10/2020 500,000.00 501,650.00 500,000.00 0.680 1,826 1,501 0.680 06/10/2025 3130AFW94 1177 Federal Home Loan Bank 03/01/2019 500,000.00 531,370.00 498,550.00 2.500 1,810 1,018 2.563 02/13/2024 3130AJKW8 1281 Federal Home Loan Bank 06/03/2020 500,000.00 496,355.00 499,850.00 0.500 1,836 1,504 0.506 06/13/2025 3130AJRP6 1283 Federal Home Loan Bank 06/30/2020 300,000.00 296,829.00 300,000.00 0.680 1,826 1,521 0.680 06/30/2025 3130AKFA9 1298 Federal Home Loan Bank 12/07/2020 500,000.00 490,770.00 497,400.00 0.375 1,831 1,686 0.480 12/12/2025 3130AKMZ6 1302 Federal Home Loan Bank 01/14/2021 500,000.00 491,400.00 500,000.00 0.510 1,826 1,719 0.510 01/14/2026 3130AKN28 1304 Federal Home Loan Bank 01/29/2021 500,000.00 493,110.00 500,000.00 0.550 1,826 1,734 0.550 01/29/2026 3130ALV92 1312 Federal Home Loan Bank 03/30/2021 500,000.00 499,395.00 500,000.00 0.500 1,826 1,794 0.938 03/30/2026 3134GVYG7 1279 Federal Home Loan Mtg Corp 05/27/2020 1,000,000.00 997,380.00 1,000,000.00 0.625 1,826 1,487 0.625 05/27/2025 3137EAEU9 1297 Federal Home Loan Mtg Corp 12/07/2020 1,000,000.00 986,700.00 997,300.00 0.375 1,687 1,542 0.434 07/21/2025 3134GXGZ1 1301 Federal Home Loan Mtg Corp 12/30/2020 500,000.00 493,407.00 500,000.00 0.550 1,826 1,704 0.550 12/30/2025 3137EAEX3 1307 Federal Home Loan Mtg Corp 02/23/2021 500,000.00 492,045.00 495,999.50 0.375 1,673 1,606 0.552 09/23/2025 3137EAEX3 1310 Federal Home Loan Mtg Corp 03/30/2021 1,000,000.00 984,090.00 983,940.00 0.375 1,638 1,606 0.740 09/23/2025 3135G0V75 1206 Federal National Mtg Assn 07/15/2019 500,000.00 521,980.00 495,950.00 1.750 1,814 1,158 1.922 07/02/2024 3135G0W33 1233 Federal National Mtg Assn 10/29/2019 1,000,000.00 1,016,760.00 992,100.00 1.375 1,043 493 1.659 09/06/2022 3135G05S8 1288 Federal National Mtg Assn 08/14/2020 500,000.00 495,465.00 500,000.00 0.500 1,826 1,566 0.500 08/14/2025 3136G4N74 1289 Federal National Mtg Assn 08/21/2020 1,000,000.00 991,790.00 1,000,000.00 0.560 1,826 1,573 0.560 08/21/2025 3136G4M75 1290 Federal National Mtg Assn 08/28/2020 500,000.00 495,180.00 499,750.00 0.520 1,816 1,570 0.530 08/18/2025 3135G06E8 1291 Federal National Mtg Assn 11/18/2020 500,000.00 497,235.00 499,250.00 0.420 1,461 1,297 0.458 11/18/2024 3135GA2Z3 1292 Federal National Mtg Assn 11/17/2020 500,000.00 493,750.00 499,250.00 0.560 1,826 1,661 0.590 11/17/2025 3135GA7D7 1299 Federal National Mtg Assn 12/23/2020 500,000.00 493,980.00 500,000.00 0.600 1,826 1,697 0.600 12/23/2025 3135GAAW1 1300 Federal National Mtg Assn 12/30/2020 500,000.00 498,380.00 500,000.00 0.400 1,461 1,339 0.400 12/30/2024 Subtotal and Average 21,655,198.53 21,050,000.00 21,220,756.00 20,989,531.86 1,628 1,242 1.099 Treasury Coupon Securities 912828S27 1045 U.S. Treasury 07/18/2016 5,000,000.00 5,008,600.00 5,000,000.00 1.125 1,808 60 1.125 06/30/2021 912828T67 1070 U.S. Treasury 03/27/2017 2,000,000.00 2,011,880.00 1,942,800.00 1.250 1,679 183 1.903 10/31/2021 9128282W9 1178 U.S. Treasury 03/01/2019 500,000.00 512,405.00 489,687.50 1.875 1,309 517 2.480 09/30/2022 912828SV3 1192 U.S. Treasury 05/31/2019 500,000.00 508,635.00 496,650.00 1.750 1,080 379 1.984 05/15/2022 912828R77 1193 U.S. Treasury 05/31/2019 500,000.00 500,515.00 493,610.00 1.375 731 30 2.030 05/31/2021 912828T26 1217 U.S. Treasury 08/21/2019 500,000.00 513,730.00 499,300.00 1.375 1,501 882 1.410 09/30/2023 912828YV6 1241 U.S. Treasury 12/16/2019 1,000,000.00 1,035,510.00 989,687.50 1.500 1,811 1,309 1.718 11/30/2024 91282CBC4 1303 U.S. Treasury 01/07/2021 500,000.00 490,565.00 498,632.81 0.375 1,819 1,705 0.431 12/31/2025 91282CBH3 1309 U.S. Treasury 02/23/2021 500,000.00 489,885.00 495,100.00 0.375 1,803 1,736 0.577 01/31/2026 91282CAT8 1311 U.S. Treasury 03/30/2021 1,000,000.00 978,240.00 977,500.00 0.250 1,676 1,644 0.750 10/31/2025 Run Date: 09/10/2021 - 10:04 Portfolio CITY CP PM (PRF_PM2) 7.3.0 City of La Quinta Portfolio Management Portfolio Details - Investments April 30, 2021 Page 3 Average Purchase Stated Days to YTM Maturity CUSIP Investment # Issuer Balance _ Date Par Value Market Value Book Value Rate Term Maturity 365 Date Treasury Coupon Securities 91282CAZ4 1315 U.S. Treasury 04/22/2021 500,000.00 491,210.00 492,187.50 0.375 1,683 1,674 0.720 11/30/2025 Subtotal and Average 12,030,624.06 12,500,000.00 12,541,175.00 12,375,155.31 1,669 565 1.335 Certificate of Deposits 336460CX6 1222 First State Bk DeQueen 08/30/2019 248,000.00 258,287.09 248,000.00 1.800 1,827 1,217 1.802 08/30/2024 32027BAL1 1273 First Freedom Bank 04/29/2020 249,000.00 253,916.39 249,000.00 1.200 1,826 1,459 1.201 04/29/2025 33766LAJ7 1216 FirsTierBank 08/23/2019 249,000.00 260,692.49 249,000.00 1.950 1,827 1,210 1.952 08/23/2024 32056GDJ6 1278 1st Internet Bank 05/11/2020 248,000.00 250,738.62 248,000.00 1.000 1,827 1,472 0.985 05/12/2025 32112UDR9 1274 First Natl Bk McGregor 04/28/2020 248,000.00 254,379.16 248,000.00 1.350 1,826 1,458 1.351 04/28/2025 32110YLK9 1147 First National Bank of America 07/20/2018 245,000.00 260,595.44 245,000.00 3.150 1,826 810 3.152 07/20/2023 32117BCX4 1179 First National Bank 03/05/2019 248,000.00 260,716.50 248,000.00 2.800 1,522 734 2.802 05/05/2023 334342CD2 1221 First Natl Bk of Syracuse 08/30/2019 249,000.00 259,745.72 249,000.00 1.850 1,827 1,217 1.852 08/30/2024 32114VBT3 1250 First National Bank Michigan 02/14/2020 248,000.00 257,282.79 248,000.00 1.650 1,827 1,385 1.652 02/14/2025 33625CCP2 1209 First Security Bank of WA 07/30/2019 248,000.00 259,821.95 248,000.00 2.000 1,827 1,186 2.002 07/30/2024 33640VDD7 1231 First Service Bank 11/15/2019 248,000.00 257,266.63 248,000.00 1.700 1,643 1,110 1.701 05/15/2024 33646CKP8 1168 First Source Bank 12/17/2018 245,000.00 249,044.76 245,000.00 3.150 1,066 200 3.153 11/17/2021 88413QBY3 1112 Third Federal Savings and Loan 01/30/2018 245,000.00 249,238.04 245,000.00 2.500 1,462 275 2.502 01/31/2022 00257TBD7 1207 Abacus Federal Savings 07/26/2019 248,000.00 259,544.06 248,000.00 1.950 1,827 1,182 1.952 07/26/2024 00435JBH5 1256 Access Bank 03/13/2020 248,000.00 256,785.40 248,000.00 1.600 1,826 1,412 1.601 03/13/2025 01748DBE5 1143 Allegiance Bank 06/13/2018 245,000.00 252,827.99 245,000.00 3.100 1,461 408 3.102 06/13/2022 01859BAA3 1095 Alliance Credit Union 10/13/2017 245,000.00 252,095.51 245,000.00 2.250 1,826 530 2.251 10/13/2022 020080BX4 1267 Alma Bank 03/30/2020 248,000.00 254,937.00 248,000.00 1.400 1,824 1,427 1.399 03/28/2025 03065AAL7 1200 America's Credit Union 06/28/2019 248,000.00 253,886.83 248,000.00 2.300 1,096 423 2.302 06/28/2022 029728BC5 1255 American State 02/21/2020 248,000.00 256,855.52 248,000.00 1.600 1,827 1,392 1.602 02/21/2025 02587CFU9 1096 American Express Fed Savings B 08/29/2017 240,000.00 246,847.17 240,000.00 2.400 1,826 485 2.402 08/29/2022 02616AAH2 1285 American First CU 06/26/2020 248,000.00 248,280.97 248,000.00 0.350 1,095 786 0.350 06/26/2023 02772JBD1 1205 American National Bank 07/19/2019 248,000.00 257,373.47 248,000.00 2.000 1,461 809 2.001 07/19/2023 034577AH9 1119 Aneca Federal Credit Union 03/22/2018 245,000.00 256,805.21 245,000.00 2.800 1,826 690 2.802 03/22/2023 05465DAE8 1258 Axos Bank 03/26/2020 248,000.00 257,349.59 248,000.00 1.650 1,826 1,425 1.651 03/26/2025 06740KLJ4 1097 Barclays Bank 10/25/2017 240,000.00 247,288.07 240,000.00 2.300 1,826 542 2.291 10/25/2022 066851WJ1 1172 Bar Harbor Bank and Trust 12/31/2018 248,000.00 267,684.53 248,000.00 3.350 1,824 972 3.352 12/29/2023 08016PDQ9 1270 Belmont Bank and Trust 04/16/2020 248,000.00 253,824.35 248,000.00 1.250 1,461 1,081 1.251 04/16/2024 07833EAD9 1264 Bellco Credit Union 03/31/2020 248,000.00 250,387.47 248,000.00 1.300 729 333 1.300 03/30/2022 080515CD9 1102 Belmont Savings Bank 11/21/2017 245,000.00 247,676.03 245,000.00 2.100 1,462 205 2.101 11/22/2021 064520BG3 1287 Bank Princeton 06/30/2020 248,000.00 246,686.88 248,000.00 0.500 1,644 1,339 0.500 12/30/2024 05580AGK4 1067 BMW Bank 02/24/2017 240,000.00 243,953.79 240,000.00 2.200 1,826 299 2.201 02/24/2022 Run Date: 09/10/2021 - 10:04 Portfolio CITY CP PM (PRF_PM2) 7.3.0 CUSIP City of La Quinta Portfolio Management Portfolio Details - Investments April 30, 2021 Page 4 Average Purchase Stated Days to YTM Maturity Investment # Issuer Balance Date Par Value Market Value Book Value Rate Term Maturity 365 Date Certificate of Deposits 06652CHB0 1227 BankWest Inc 09/27/2019 248,000.00 257,671.41 248,000.00 1.700 1,827 1,245 1.702 09/27/2024 12738RFX7 1259 Cadence Bank, NA 03/31/2020 245,000.00 247,090.79 245,000.00 1.200 730 334 1.200 03/31/2022 14042RGD7 1082 Capital One Natl Assn FDIC4297 06/07/2017 240,000.00 240,541.82 240,000.00 2.250 1,461 37 2.252 06/07/2021 14042TDD6 1271 Capital One USA FDIC33954 04/08/2020 245,000.00 253,616.98 245,000.00 1.600 1,826 1,438 1.601 04/08/2025 14622LAA0 1316 Carter FCU 04/27/2021 248,000.00 245,743.90 248,000.00 0.750 1,826 1,822 0.750 04/27/2026 15118RRH2 1220 Celtic Bank 08/30/2019 248,000.00 258,702.56 248,000.00 1.850 1,827 1,217 1.852 08/30/2024 156634AK3 1184 Century Next Bank 05/29/2019 248,000.00 263,535.04 248,000.00 2.500 1,827 1,124 2.503 05/29/2024 169894AS1 1284 Chippewa Valley Bk 06/24/2020 248,000.00 246,509.64 248,000.00 0.600 1,826 1,515 0.600 06/24/2025 17286TAG0 1252 Citadel FCU 02/27/2020 248,000.00 257,368.76 248,000.00 1.650 1,827 1,398 1.652 02/27/2025 12556LBA3 1219 CIT Bank NA 08/23/2019 245,000.00 250,274.66 245,000.00 1.900 1,096 479 1.902 08/23/2022 17312QJ26 1123 Citibank NA 04/11/2018 245,000.00 257,628.35 245,000.00 2.900 1,826 710 2.902 04/11/2023 2027506M2 1268 Commonwealth Business Bk 03/31/2020 248,000.00 253,090.23 248,000.00 1.250 1,826 1,430 1.251 03/31/2025 15523RBJ4 1085 Central State Bank 07/14/2017 240,000.00 240,864.84 240,000.00 1.850 1,461 74 1.851 07/14/2021 20143PDV9 1162 Commercial Bank 11/15/2018 248,000.00 267,223.14 248,000.00 3.400 1,826 928 3.402 11/15/2023 20416TAQ5 1202 Communitywide FCU 06/28/2019 248,000.00 261,810.17 248,000.00 2.250 1,827 1,154 2.253 06/28/2024 20726ABA5 1189 Congressional Bank 04/30/2019 248,000.00 259,095.65 248,000.00 2.500 1,459 727 2.502 04/28/2023 22766ACB9 1106 CrossFirst Bank 11/20/2017 245,000.00 252,387.69 245,000.00 2.200 1,824 566 2.201 11/18/2022 176688CP2 1199 Citizens State Bank 06/21/2019 248,000.00 262,903.73 248,000.00 2.400 1,827 1,147 2.403 06/21/2024 2546722U1 1066 Discover Bank Greenwood DE CF 02/01/2017 240,000.00 243,743.06 240,000.00 2.250 1,826 276 2.251 02/01/2022 29278TAY6 1125 EnerBank USA 04/30/2018 240,000.00 252,915.28 240,000.00 2.950 1,824 727 2.952 04/28/2023 29367QCP1 1107 Enterprise Bank, NA 11/28/2017 245,000.00 252,321.83 245,000.00 2.150 1,826 576 2.151 11/28/2022 299547AQ2 1196 Evansville Teachers Credit FCU 06/12/2019 248,000.00 264,344.42 248,000.00 2.600 1,827 1,138 2.603 06/12/2024 87270LDL4 1306 TIAA FKA EverBank 02/12/2021 245,000.00 240,385.36 245,000.00 0.500 1,826 1,748 0.500 02/12/2026 30960QAG2 1126 Farmers Insurance Group FCU 04/30/2018 240,000.00 246,152.50 240,000.00 2.800 1,460 363 2.802 04/29/2022 31617CAV5 1317 Fidelity Homestead 04/30/2021 248,000.00 244,894.40 248,000.00 0.700 1,826 1,825 0.711 04/30/2026 33847E3A3 1276 Flagstar 04/30/2020 248,000.00 253,187.54 248,000.00 1.250 1,826 1,460 1.251 04/30/2025 35637RDC8 1248 Freedom Financial 02/14/2020 248,000.00 256,340.38 248,000.00 1.550 1,827 1,385 1.552 02/14/2025 369674AV8 1150 General Electric Credit Union 08/15/2018 240,000.00 242,123.38 240,000.00 3.100 1,097 107 3.100 08/16/2021 38148PJK4 1078 Goldman Sachs 04/26/2017 240,000.00 245,137.69 240,000.00 2.400 1,826 360 2.401 04/26/2022 39573LBC1 1313 Greenstate FCU 04/16/2021 249,000.00 249,195.77 249,000.00 0.950 1,826 1,811 0.951 04/16/2026 46256YAZ2 1186 Iowa State Bank 05/23/2019 245,000.00 259,495.07 245,000.00 2.400 1,827 1,118 2.403 05/23/2024 474067AQ8 1154 Jefferson Financial CU 10/19/2018 245,000.00 263,229.57 245,000.00 3.350 1,826 901 3.352 10/19/2023 48128HXU7 1185 JP Morgan Chase 05/16/2019 245,000.00 265,795.34 245,000.00 3.250 1,827 1,111 3.254 05/16/2024 50116CBE8 1101 Kansas State Bank 11/17/2017 245,000.00 249,721.28 245,000.00 2.100 1,642 381 2.099 05/17/2022 49228XAK6 1239 Kern FCU 12/30/2019 248,000.00 254,775.32 248,000.00 1.900 1,096 608 1.902 12/30/2022 499724AB8 1110 Knoxville TVA Credit Union 12/29/2017 245,000.00 253,746.14 245,000.00 2.400 1,826 607 2.401 12/29/2022 Run Date: 09/10/2021 - 10:04 Portfolio CITY CP PM (PRF PM2) 7.3.0 CUSIP City of La Quinta Portfolio Management Portfolio Details - Investments April 30, 2021 Page 5 Average Purchase Stated Days to YTM Maturity Investment # Issuer Balance Date Par Value Market Value Book Value Rate Term Maturity 365 Date Certificate of Deposits 524661CB9 1197 Legacy Bank 06/19/2019 248,000.00 262,877.97 248,000.00 2.400 1,827 1,145 2.403 06/19/2024 538036GV0 1238 Live Oak Bank 11/27/2019 248,000.00 258,142.65 248,000.00 1.800 1,644 1,123 1.802 05/28/2024 51210SQU4 1208 Lakeside Bank 07/30/2019 248,000.00 258,904.50 248,000.00 2.000 1,644 1,003 2.003 01/29/2024 51507LCC6 1305 Landmark Community Bank 01/22/2021 248,000.00 243,595.37 248,000.00 0.500 1,826 1,727 0.500 01/22/2026 549104JN8 1225 Luana Savings Bank 09/18/2019 245,000.00 247,975.03 245,000.00 1.600 912 321 1.599 03/18/2022 560507AK1 1171 Maine Savings FCU 12/28/2018 248,000.00 254,443.62 248,000.00 3.300 1,158 303 3.306 02/28/2022 56065GAG3 1188 Main Street Bank 04/26/2019 248,000.00 263,960.46 248,000.00 2.600 1,827 1,091 2.603 04/26/2024 57116ARV2 1155 Marlin Business Bank 10/17/2018 248,000.00 266,117.82 248,000.00 3.300 1,826 899 3.302 10/17/2023 58404DCX7 1169 Medallion Bank 12/07/2018 248,000.00 260,560.80 248,000.00 3.400 1,461 585 3.402 12/07/2022 61690UNX4 1237 Morgan Stanley Bank 11/20/2019 245,000.00 256,770.10 245,000.00 1.950 1,827 1,299 1.952 11/20/2024 619165JD6 1173 Morton Community 03/20/2019 248,000.00 261,148.08 248,000.00 2.750 1,553 780 2.753 06/20/2023 59013J4K2 1163 Merrick Bank 10/30/2018 248,000.00 259,142.31 248,000.00 3.250 1,459 545 3.252 10/28/2022 61760A3B3 1236 Morgan Stanley Private Bk, NA 11/20/2019 245,000.00 256,333.19 245,000.00 1.900 1,827 1,299 1.902 11/20/2024 62384RAC0 1099 Mountain America Federal CU 11/08/2017 245,000.00 252,635.88 245,000.00 2.300 1,826 556 2.301 11/08/2022 625925AR3 1160 Municipal Trust and Savings 10/17/2018 245,000.00 262,289.03 245,000.00 3.200 1,826 899 3.202 10/17/2023 654062JZ2 1266 Nicolet Natl Bank 03/31/2020 248,000.00 254,547.35 248,000.00 1.400 1,826 1,430 1.401 03/31/2025 64017AAQ7 1167 Neighbors FCU 12/21/2018 245,000.00 249,791.92 245,000.00 3.200 1,096 234 3.203 12/21/2021 635573AL2 1170 National Cooperative Bank, N.A 12/21/2018 245,000.00 264,596.63 245,000.00 3.400 1,826 964 3.402 12/21/2023 67054NAN3 1164 Numerica Credit Union 11/28/2018 248,000.00 268,459.24 248,000.00 3.550 1,826 941 3.552 11/28/2023 666613GV0 1127 Northpointe Bank 04/26/2018 240,000.00 243,005.62 240,000.00 2.700 1,279 178 2.703 10/26/2021 66704MEQ0 1263 Northstar Bank 03/31/2020 248,000.00 252,178.59 248,000.00 1.150 1,095 699 1.150 03/31/2023 66736ABP3 1181 Northwest Bank 02/13/2019 248,000.00 265,579.41 248,000.00 2.950 1,826 1,018 2.951 02/13/2024 06426KAN8 1151 Bank of New England 07/31/2018 249,000.00 265,437.39 249,000.00 3.250 1,826 821 3.252 07/31/2023 649447TC3 1226 New York Community Bank 09/27/2019 245,000.00 246,672.77 245,000.00 1.800 731 149 1.802 09/27/2021 677721CN0 1089 The Ohio Valley Bank 07/19/2017 240,000.00 242,971.84 240,000.00 1.900 1,645 263 1.903 01/19/2022 69506YRH4 1269 Pacific Western Bank 04/16/2020 245,000.00 251,113.35 245,000.00 1.300 1,461 1,081 1.301 04/16/2024 69324MAD7 1149 PCSB Bank 06/08/2018 245,000.00 252,463.06 245,000.00 3.000 1,461 403 3.002 06/08/2022 710571DS6 1210 People's Bank 07/31/2019 248,000.00 259,657.39 248,000.00 2.000 1,827 1,187 2.002 07/31/2024 725404AB3 1194 Pittsfield Cooperative Bank 06/07/2019 245,000.00 256,463.55 245,000.00 2.500 1,461 767 2.502 06/07/2023 72651LCL6 1195 Plains Commerce Bank 06/07/2019 245,000.00 260,676.42 245,000.00 2.550 1,827 1,133 2.553 06/07/2024 740367HP5 1213 Preferred Bank 08/16/2019 249,000.00 261,038.05 249,000.00 2.000 1,827 1,203 2.002 08/16/2024 74267GVG9 1032 PrivateBank & Trust 05/26/2016 240,000.00 240,240.79 240,000.00 1.500 1,826 25 1.501 05/26/2021 75472RAD3 1218 Raymond James Bank 08/23/2019 244,000.00 253,228.20 244,000.00 1.950 1,461 844 1.951 08/23/2023 74934YAH4 1144 RCB Bank 06/20/2018 245,000.00 260,107.96 245,000.00 3.150 1,826 780 3.152 06/20/2023 75701LAB3 1166 Red Rocks Credit Union 12/07/2018 248,000.00 260,359.44 248,000.00 3.350 1,461 585 3.352 12/07/2022 761402BY1 1203 Revere Bank 06/28/2019 247,000.00 261,131.70 247,000.00 2.300 1,827 1,154 2.303 06/28/2024 Run Date: 09/10/2021 - 10:04 Portfolio CITY CP PM (PRF_PM2) 7.3.0 CUSIP Investment # Issuer Average Balance City of La Quinta Portfolio Management Portfolio Details - Investments April 30, 2021 Page 6 Purchase Stated Days to YTM Maturity Date Par Value Market Value Book Value Rate Term Maturity 365 Date Certificate of Deposits 77579ADF0 1251 795450A70 1083 804375DL4 1235 81768PAF3 1254 79772FAC0 1240 06424KBC3 1261 849430BF9 1257 84223QAN7 1286 85916VDC6 1201 87164XQV1 1080 87164DRD4 1253 882213AB7 1260 472382AQ3 1272 89235MKY6 1314 89269CBX9 1148 89579NCD3 1262 87266AAA1 1187 90348JEJ5 1161 90983WBT7 1249 910160AH3 1214 91435LAG2 1134 92535LCD4 1180 949763XY7 1174 954444BS3 1265 949495AT2 1244 938828BH2 1215 95960NKD8 1277 Rol!stone B&T Sallie Mae Bank Salt Lake City Sauk Valley B&T Co Servisfirst Bank San Francisco FCU Bank of Santa Clarita Spring Bank Southern Bancorp Bk Sterling Bank Synchrony Bank Retail Synovus Bank Texas Bank Financial The Jefferson Bank Toyota Financial Savings Bank Traditions Bank Triad Bank TNB Bank UBS Bank USA United Community United Credit Union University of Iowa Comm. CU Verus Bank of Commerce Wells Fargo West Michigan Cmnty Bk Wells Fargo Natl Bank West Washington Federal Western State Bank Subtotal and Average 31,841,500.00 02/12/2020 245,000.00 253,391.27 245,000.00 1.650 1,461 1,017 1.651 02/12/2024 06/21/2017 240,000.00 245,737.93 240,000.00 2.350 1,826 416 2.351 06/21/2022 11/07/2019 248,000.00 257,619.47 248,000.00 1.700 1,827 1,286 1.702 11/07/2024 02/21/2020 248,000.00 253,998.99 248,000.00 1.600 1,096 661 1.601 02/21/2023 12/30/2019 248,000.00 254,566.08 248,000.00 1.850 1,096 608 1.852 12/30/2022 03/31/2020 248,000.00 249,887.38 248,000.00 1.100 730 334 1.100 03/31/2022 03/20/2020 248,000.00 255,863.49 248,000.00 1.500 1,826 1,419 1.501 03/20/2025 06/26/2020 248,000.00 247,279.19 248,000.00 0.500 1,582 1,273 0.500 10/25/2024 06/28/2019 245,000.00 251,165.15 245,000.00 2.150 1,158 485 2.153 08/29/2022 06/02/2017 240,000.00 245,609.36 240,000.00 2.400 1,826 397 2.401 06/02/2022 03/09/2020 245,000.00 248,626.89 245,000.00 1.600 822 404 1.602 06/09/2022 03/31/2020 245,000.00 249,687.36 245,000.00 1.100 1,458 1,062 1.101 03/28/2024 04/15/2020 248,000.00 253,819.00 248,000.00 1.250 1,461 1,080 1.251 04/15/2024 04/22/2021 245,000.00 244,589.82 245,000.00 0.900 1,826 1,817 0.900 04/22/2026 06/08/2018 245,000.00 253,587.87 245,000.00 3.000 1,522 464 3.002 08/08/2022 03/30/2020 248,000.00 254,067.51 248,000.00 1.350 1,278 881 1.352 09/29/2023 05/22/2019 248,000.00 251,134.27 248,000.00 2.400 915 205 2.407 11/22/2021 10/17/2018 245,000.00 263,203.47 245,000.00 3.350 1,826 899 3.352 10/17/2023 02/07/2020 248,000.00 257,236.51 248,000.00 1.650 1,827 1,378 1.652 02/07/2025 08/22/2019 248,000.00 250,924.23 248,000.00 2.000 853 235 2.003 12/22/2021 05/14/2018 240,000.00 253,711.15 240,000.00 3.050 1,827 744 3.052 05/15/2023 02/28/2019 248,000.00 259,117.99 248,000.00 2.700 1,461 668 2.700 02/28/2023 02/27/2019 248,000.00 266,173.03 248,000.00 3.000 1,826 1,032 3.001 02/27/2024 03/31/2020 248,000.00 252,178.59 248,000.00 1.150 1,095 699 1.150 03/31/2023 01/29/2020 248,000.00 255,119.35 248,000.00 1.900 1,097 639 1.900 01/30/2023 08/23/2019 248,000.00 260,058.78 248,000.00 2.000 1,827 1,210 2.002 08/23/2024 05/13/2020 245,000.00 247,702.99 245,000.00 1.000 1,826 1,473 1.001 05/13/2025 32,241,000.00 33,327,053.71 32,241,000.00 1,605 885 2.085 Corporate Notes 037833CC2 19416QEA4 45950VPS9 594918BQ6 742718DY2 931142DU4 Run Date: 09/10/2021 - 10:04 1079 Apple Inc 1175 Colgate-Palmolive 1308 International Finance Corp. 1157 Microsoft Corporation 1159 Proctor and Gamble 1190 Wal-Mart Stores, Inc 06/12/2017 03/04/2019 02/26/2021 10/15/2018 10/15/2018 04/16/2019 500,000.00 500,000.00 500,000.00 400,000.00 500,000.00 500,000.00 501,190.00 514,055.00 493,275.00 414,664.00 507,960.00 515,995.00 493,050.00 1.550 1,514 95 485,250.00 1.950 1,430 641 497,300.00 0.500 1,826 1,762 378,360.00 2.000 1,758 829 487,950.00 2.300 1,210 281 496,650.00 2.350 1,339 593 1.900 08/04/2021 2.751 02/01/2023 0.610 02/26/2026 3.222 08/08/2023 3.071 02/06/2022 2.799 12/15/2022 Portfolio CITY CP PM (PRF_PM2) 7.3.0 CUSIP City of La Quinta Portfolio Management Portfolio Details - Investments April 30, 2021 Average Purchase Stated Days to YTM Investment # Issuer Balance Date Par Value Market Value Book Value Rate Term Maturity 365 Subtotal and Average 2,838,560.00 2,900,000.00 2,947,139.00 2,838,560.00 1,504 697 2.354 Page 7 Maturity Date Money Market with Fiscal Agent SYS1058 1058 US Bank 07/01/2016 1,422.08 1,422.08 1,422.08 1 1 0.000 Subtotal and Average 70.34 1,422.08 1,422.08 1,422.08 1 1 0.000 CERBT - OPEB Trust SYS1114 1114 CaIPERS CERBT Plan Subtotal and Average 1,934,231.01 07/01/2020 1,934,231.01 1,934,231.01 1,934,231.01 1 1 0.000 1,934,231.01 1,934,231.01 1,934,231.01 1 1 0.000 PARS Pension Trust SYS1230 1230 Pblc Agncy Rtrmnt Sery Subtotal and Average 11,038,379.49 07/01/2020 11,227, 866.79 11,227,866.79 11,227,866.79 1 1 0.000 11,227,866.79 11,227,866.79 11,227,866.79 1 1 0.000 Total and Average 157,037,173.30 Run Date: 09/10/2021 - 10:04 161,985,895.22 163,749,650.14 161,739,142.39 686 394 0.840 Portfolio CITY CP PM (PRF PM2) 7.3.0 GEM of the DESERT - City of La Quinta Total Earnings Sorted by Fund - Fund April 1, 2021 - April 30, 2021 City of La Quinta Adjusted Interest Earnings Ending Beginning Ending Current Annualized Interest Amortization/ Realized Adjusted Interest CUSIP Investment # Fund Issuer Par Value Book Value Book Value Rate Yield Earned Accretion Gainl/Loss Earnings Fund: General Fund 74267GVG9 1032 101 PRVTBA 240,000.00 240,000.00 240,000.00 1.500 1.500 295.89 0.00 0.00 295.89 912828S27 1045 101 USTR 5,000,000.00 5,000,000.00 5,000,000.00 1.125 1.134 4,661.61 0.00 0.00 4,661.61 98-33-434 1055 101 LAIF 55,429,948.66 57,363,733.52 55,429,948.66 0.339 0.320 15,074.60 0.00 0.00 15,074.60 SYS1059 1059 101 CITYPC 3,300.00 3,300.00 3,300.00 0.00 0.00 0.00 0.00 2546722U1 1066 101 DISCOV 240,000.00 240,000.00 240,000.00 2.250 2.250 443.83 0.00 0.00 443.83 05580AGK4 1067 101 BMW 240,000.00 240,000.00 240,000.00 2.200 2.200 433.97 0.00 0.00 433.97 912828T67 1070 101 USTR 2,000,000.00 1,942,800.00 1,942,800.00 1.250 1.297 2,070.69 0.00 0.00 2,070.69 02587DP85 1077 101 AMEX 0.00 240,000.00 0.00 2.250 2.250 266.30 0.00 0.00 266.30 38148PJK4 1078 101 GLDMAN 240,000.00 240,000.00 240,000.00 2.400 2.400 473.42 0.00 0.00 473.42 037833CC2 1079 101 APPL 500,000.00 493,050.00 493,050.00 1.550 1.594 645.84 0.00 0.00 645.84 87164XQV1 1080 101 SYNCHR 240,000.00 240,000.00 240,000.00 2.400 2.400 473.42 0.00 0.00 473.42 14042RGD7 1082 101 CAP1NA 240,000.00 240,000.00 240,000.00 2.250 2.250 443.83 0.00 0.00 443.83 795450A70 1083 101 SALMAE 240,000.00 240,000.00 240,000.00 2.350 2.350 463.56 0.00 0.00 463.56 15523RBJ4 1085 101 CNTRL 240,000.00 240,000.00 240,000.00 1.850 1.850 364.93 0.00 0.00 364.93 677721CN0 1089 101 OHVAL 240,000.00 240,000.00 240,000.00 1.900 1.900 374.79 0.00 0.00 374.79 01859BAA3 1095 101 ALLIAN 245,000.00 245,000.00 245,000.00 2.250 2.250 453.08 0.00 0.00 453.08 02587CFU9 1096 101 AMFSB 240,000.00 240,000.00 240,000.00 2.400 2.400 473.42 0.00 0.00 473.42 06740KLJ4 1097 101 BARCLY 240,000.00 240,000.00 240,000.00 2.300 2.300 453.70 0.00 0.00 453.70 62384RAC0 1099 101 MTNAMR 245,000.00 245,000.00 245,000.00 2.300 2.300 463.15 0.00 0.00 463.15 50116CBE8 1101 101 KANSAS 245,000.00 245,000.00 245,000.00 2.100 2.100 422.88 0.00 0.00 422.88 080515CD9 1102 101 BELMNT 245,000.00 245,000.00 245,000.00 2.100 2.100 422.87 0.00 0.00 422.87 3133EHWM1 1105 101 FFCB 1,000,000.00 992,200.00 992,200.00 1.700 1.737 1,416.66 0.00 0.00 1,416.66 22766ACB9 1106 101 CRS1ST 245,000.00 245,000.00 245,000.00 2.200 2.200 443.01 0.00 0.00 443.01 29367QCP1 1107 101 ENTRPR 245,000.00 245,000.00 245,000.00 2.150 2.150 432.95 0.00 0.00 432.95 499724AB8 1110 101 KNOX 245,000.00 245,000.00 245,000.00 2.400 2.400 483.29 0.00 0.00 483.29 88413QBY3 1112 101 3RD 245,000.00 245,000.00 245,000.00 2.500 2.500 503.42 0.00 0.00 503.42 SYS1114 1114 101 CALPRS 1,934,231.01 1,934,231.01 1,934,231.01 0.00 0.00 0.00 0.00 034577AH9 1119 101 ANECA 245,000.00 245,000.00 245,000.00 2.800 2.800 563.83 0.00 0.00 563.83 17312QJ26 1123 101 CITINA 245,000.00 245,000.00 245,000.00 2.900 2.900 583.97 0.00 0.00 583.97 29278TAY6 1125 101 ENER 240,000.00 240,000.00 240,000.00 2.950 2.950 581.92 0.00 0.00 581.92 Run Date: 09/10/2021 - 18:21 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 City of La Quinta Total Earnings April 1, 2021 -April 30, 2021 Page 2 Adjusted Interest Earnings Ending Beginning Ending Current Annualized Interest Amortization/ Realized Adjusted Interest CUSIP Investment # Fund Issuer Par Value Book Value Book Value Rate Yield Earned Accretion Gainl/Loss Earnings Fund: General Fund 30960QAG2 1126 101 FARMIG 240,000.00 240,000.00 240,000.00 2.800 2.800 552.33 666613GV0 1127 101 NORPNT 240,000.00 240,000.00 240,000.00 2.700 2.700 532.60 89214PBL2 1128 101 TOWNE 0.00 240,000.00 0.00 2.800 2.800 533.92 91435LAG2 1134 101 UOFICU 240,000.00 240,000.00 240,000.00 3.050 3.050 601.64 01748DBE5 1143 101 ALLGNC 245,000.00 245,000.00 245,000.00 3.100 3.100 624.25 74934YAH4 1144 101 RCB 245,000.00 245,000.00 245,000.00 3.150 3.150 634.32 32110YLK9 1147 101 1STNBA 245,000.00 245,000.00 245,000.00 3.150 3.150 634.32 89269CBX9 1148 101 TRAD 245,000.00 245,000.00 245,000.00 3.000 3.000 604.11 69324MAD7 1149 101 PCSB 245,000.00 245,000.00 245,000.00 3.000 3.000 604.11 369674AV8 1150 101 GECRUN 240,000.00 240,000.00 240,000.00 3.100 3.100 611.51 06426KAN8 1151 101 NWENGL 249,000.00 249,000.00 249,000.00 3.250 3.250 665.14 SYS1153 1153 101 CAMP 854,097.00 854,058.29 854,097.00 0.060 0.055 38.71 474067AQ8 1154 101 JEFF 245,000.00 245,000.00 245,000.00 3.350 3.350 674.59 57116ARV2 1155 101 MARBUS 248,000.00 248,000.00 248,000.00 3.300 3.300 672.66 59491813Q6 1157 101 MCRSFT 400,000.00 378,360.00 378,360.00 2.000 2.144 666.66 3133EJYL7 1158 101 FFCB 250,000.00 247,275.00 247,275.00 2.800 2.870 583.33 742718DY2 1159 101 P&G 500,000.00 487,950.00 487,950.00 2.300 2.390 958.34 625925AR3 1160 101 MUNTRS 245,000.00 245,000.00 245,000.00 3.200 3.200 644.38 90348JEJ5 1161 101 UBS 245,000.00 245,000.00 245,000.00 3.350 3.350 674.59 20143PDV9 1162 101 COMMBK 248,000.00 248,000.00 248,000.00 3.400 3.400 693.04 59013J4K2 1163 101 MRRCK 248,000.00 248,000.00 248,000.00 3.250 3.250 662.47 67054NAN3 1164 101 NMRCA 248,000.00 248,000.00 248,000.00 3.550 3.550 723.62 75701LAB3 1166 101 REDRCK 248,000.00 248,000.00 248,000.00 3.350 3.350 682.85 64017AAQ7 1167 101 NEIGH 245,000.00 245,000.00 245,000.00 3.200 3.200 644.39 33646CKP8 1168 101 1STSRC 245,000.00 245,000.00 245,000.00 3.150 3.150 634.32 58404DCX7 1169 101 MEDBA 248,000.00 248,000.00 248,000.00 3.400 3.400 693.04 635573AL2 1170 101 NLCOOP 245,000.00 245,000.00 245,000.00 3.400 3.400 684.66 560507AK1 1171 101 MAINE 248,000.00 248,000.00 248,000.00 3.300 3.300 672.65 066851WJ1 1172 101 BARHAR 248,000.00 248,000.00 248,000.00 3.350 3.350 682.85 619165JD6 1173 101 MORTN 248,000.00 248,000.00 248,000.00 2.750 2.750 560.55 949763XY7 1174 101 WELLS 248,000.00 248,000.00 248,000.00 3.000 3.000 611.51 19416QEA4 1175 101 COLGTE 500,000.00 485,250.00 485,250.00 1.950 2.037 812.50 3130AFW94 1177 101 FHLB 500,000.00 498,550.00 498,550.00 2.500 2.542 1,041.66 9128282W9 1178 101 USTR 500,000.00 489,687.50 489,687.50 1.875 1.909 768.45 32117BCX4 1179 101 1STNBK 248,000.00 248,000.00 248,000.00 2.800 2.800 570.74 92535LCD4 1180 101 VERUS 248,000.00 248,000.00 248,000.00 2.700 2.700 550.35 66736ABP3 1181 101 NRTHWS 248,000.00 248,000.00 248,000.00 2.950 2.950 601.32 Run Date: 09/10/2021 - 18:21 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 552.33 532.60 533.92 601.64 624.25 634.32 634.32 604.11 604.11 611.51 665.14 38.71 674.59 672.66 666.66 583.33 958.34 644.38 674.59 693.04 662.47 723.62 682.85 644.39 634.32 693.04 684.66 672.65 682.85 560.55 611.51 812.50 1,041.66 768.45 570.74 550.35 601.32 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 City of La Quinta Total Earnings April 1, 2021 -April 30, 2021 Page 3 Adjusted Interest Earnings Ending Beginning Ending Current Annualized Interest Amortization/ Realized Adjusted Interest CUSIP Investment # Fund Issuer Par Value Book Value Book Value Rate Yield Earned Accretion Gainl/Loss Earnings Fund: General Fund 156634AK3 1184 101 CENTNX 248,000.00 248,000.00 248,000.00 2.500 2.500 509.60 0.00 0.00 509.60 48128HXU7 1185 101 JPMORG 245,000.00 245,000.00 245,000.00 3.250 3.250 654.45 0.00 0.00 654.45 46256YAZ2 1186 101 IOWAST 245,000.00 245,000.00 245,000.00 2.400 2.400 483.29 0.00 0.00 483.29 87266AAA1 1187 101 TSCOLA 248,000.00 248,000.00 248,000.00 2.400 2.400 489.21 0.00 0.00 489.21 56065GAG3 1188 101 MAINST 248,000.00 248,000.00 248,000.00 2.600 2.600 529.97 0.00 0.00 529.97 20726ABA5 1189 101 CONGRS 248,000.00 248,000.00 248,000.00 2.500 2.500 509.59 0.00 0.00 509.59 931142DU4 1190 101 WALMRT 500,000.00 496,650.00 496,650.00 2.350 2.399 979.17 0.00 0.00 979.17 912828SV3 1192 101 USTR 500,000.00 496,650.00 496,650.00 1.750 1.776 725.14 0.00 0.00 725.14 912828R77 1193 101 USTR 500,000.00 493,610.00 493,610.00 1.375 1.397 566.62 0.00 0.00 566.62 725404AB3 1194 101 PITTS 245,000.00 245,000.00 245,000.00 2.500 2.500 503.43 0.00 0.00 503.43 72651LCL6 1195 101 PLAINS 245,000.00 245,000.00 245,000.00 2.550 2.550 513.49 0.00 0.00 513.49 299547AQ2 1196 101 EVNSCU 248,000.00 248,000.00 248,000.00 2.600 2.600 529.97 0.00 0.00 529.97 524661CB9 1197 101 LEGCY 248,000.00 248,000.00 248,000.00 2.400 2.400 489.21 0.00 0.00 489.21 3133EKQP4 1198 101 FFCB 500,000.00 499,500.00 499,500.00 1.875 1.903 781.25 0.00 0.00 781.25 176688CP2 1199 101 CTZNST 248,000.00 248,000.00 248,000.00 2.400 2.400 489.20 0.00 0.00 489.20 03065AAL7 1200 101 AMERCU 248,000.00 248,000.00 248,000.00 2.300 2.300 468.82 0.00 0.00 468.82 85916VDC6 1201 101 STRLNG 245,000.00 245,000.00 245,000.00 2.150 2.150 432.94 0.00 0.00 432.94 20416TAQ5 1202 101 COMMW 248,000.00 248,000.00 248,000.00 2.250 2.250 458.63 0.00 0.00 458.63 761402BY1 1203 101 REVER 247,000.00 247,000.00 247,000.00 2.300 2.300 466.94 0.00 0.00 466.94 02772JBD1 1205 101 AMRNTL 248,000.00 248,000.00 248,000.00 2.000 2.000 407.67 0.00 0.00 407.67 3135G0V75 1206 101 FNMA 500,000.00 495,950.00 495,950.00 1.750 1.789 729.17 0.00 0.00 729.17 00257TBD7 1207 101 ABACUS 248,000.00 248,000.00 248,000.00 1.950 1.950 397.48 0.00 0.00 397.48 51210SQU4 1208 101 LKSIDE 248,000.00 248,000.00 248,000.00 2.000 2.000 407.67 0.00 0.00 407.67 33625CCP2 1209 101 1STSEC 248,000.00 248,000.00 248,000.00 2.000 2.000 407.67 0.00 0.00 407.67 710571DS6 1210 101 PEOPLE 248,000.00 248,000.00 248,000.00 2.000 2.000 407.67 0.00 0.00 407.67 3133EKWV4 1212 101 FFCB 500,000.00 499,500.00 499,500.00 1.850 1.878 770.83 0.00 0.00 770.83 740367HP5 1213 101 PREFRD 249,000.00 249,000.00 249,000.00 2.000 2.000 409.32 0.00 0.00 409.32 910160AH3 1214 101 UNTDCU 248,000.00 248,000.00 248,000.00 2.000 2.000 407.67 0.00 0.00 407.67 938828BH2 1215 101 WSHFED 248,000.00 248,000.00 248,000.00 2.000 2.000 407.67 0.00 0.00 407.67 33766LAJ7 1216 101 1STIER 249,000.00 249,000.00 249,000.00 1.950 1.950 399.08 0.00 0.00 399.08 912828T26 1217 101 USTR 500,000.00 499,300.00 499,300.00 1.375 1.373 563.53 0.00 0.00 563.53 75472RAD3 1218 101 RAYJAM 244,000.00 244,000.00 244,000.00 1.950 1.950 391.07 0.00 0.00 391.07 12556LBA3 1219 101 CITBNK 245,000.00 245,000.00 245,000.00 1.900 1.900 382.60 0.00 0.00 382.60 15118RRH2 1220 101 CELTIC 248,000.00 248,000.00 248,000.00 1.850 1.850 377.10 0.00 0.00 377.10 334342CD2 1221 101 1STNBS 249,000.00 249,000.00 249,000.00 1.850 1.850 378.62 0.00 0.00 378.62 336460CX6 1222 101 1STDQN 248,000.00 248,000.00 248,000.00 1.800 1.800 366.90 0.00 0.00 366.90 3133EKZK5 1223 101 FFCB 500,000.00 499,400.00 499,400.00 1.600 1.624 666.67 0.00 0.00 666.67 Run Date: 09/10/2021 - 18:21 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 City of La Quinta Total Earnings April 1, 2021 -April 30, 2021 Page 4 Adjusted Interest Earnings Ending Beginning Ending Current Annualized Interest Amortization/ Realized Adjusted Interest CUSIP Investment # Fund Issuer Par Value Book Value Book Value Rate Yield Earned Accretion Gainl/Loss Earnings Fund: General Fund 3133EKP75 1224 101 FFCB 500,000.00 498,750.00 498,750.00 1.600 1.626 666.67 0.00 0.00 666.67 549104JN8 1225 101 LUANA 245,000.00 245,000.00 245,000.00 1.600 1.600 322.19 0.00 0.00 322.19 649447TC3 1226 101 NYCMBK 245,000.00 245,000.00 245,000.00 1.800 1.800 362.47 0.00 0.00 362.47 06652CHB0 1227 101 BNKWST 248,000.00 248,000.00 248,000.00 1.700 1.700 346.52 0.00 0.00 346.52 059731851 1228 101 BOTW 9,456,806.96 2,153,669.02 9,456,806.96 0.01 0.00 0.00 0.01 SYS1230 1230 101 PARS 11,227,866.79 11,031,845.44 11,227,866.79 0.00 0.00 0.00 0.00 33640VDD7 1231 101 1STSER 248,000.00 248,000.00 248,000.00 1.700 1.700 346.52 0.00 0.00 346.52 3135G0W33 1233 101 FNMA 1,000,000.00 992,100.00 992,100.00 1.375 1.405 1,145.83 0.00 0.00 1,145.83 3133EK4X1 1234 101 FFCB 1,000,000.00 996,900.00 996,900.00 1.600 1.627 1,333.33 0.00 0.00 1,333.33 804375DL4 1235 101 SAUKVL 248,000.00 248,000.00 248,000.00 1.700 1.700 346.52 0.00 0.00 346.52 61760A3B3 1236 101 MSPRIV 245,000.00 245,000.00 245,000.00 1.900 1.900 382.60 0.00 0.00 382.60 61690UNX4 1237 101 MORGST 245,000.00 245,000.00 245,000.00 1.950 1.950 392.67 0.00 0.00 392.67 538036GV0 1238 101 LIVEOK 248,000.00 248,000.00 248,000.00 1.800 1.800 366.90 0.00 0.00 366.90 49228XAK6 1239 101 KERNCU 248,000.00 248,000.00 248,000.00 1.900 1.900 387.29 0.00 0.00 387.29 79772FAC0 1240 101 SF FCU 248,000.00 248,000.00 248,000.00 1.850 1.850 377.10 0.00 0.00 377.10 912828YV6 1241 101 USTR 1,000,000.00 989,687.50 989,687.50 1.500 1.520 1,236.27 0.00 0.00 1,236.27 3133ELEA8 1242 101 FFCB 1,000,000.00 998,600.00 998,600.00 1.700 1.726 1,416.67 0.00 0.00 1,416.67 949495AT2 1244 101 WFNBW 248,000.00 248,000.00 248,000.00 1.900 1.900 387.29 0.00 0.00 387.29 3133ELNE0 1246 101 FFCB 1,000,000.00 999,000.00 999,000.00 1.430 1.451 1,191.67 0.00 0.00 1,191.67 3133EGWJ0 1247 101 FFCB 1,000,000.00 999,217.36 999,217.36 1.400 1.421 1,166.66 0.00 0.00 1,166.66 35637RDC8 1248 101 FRDMFI 248,000.00 248,000.00 248,000.00 1.550 1.550 315.95 0.00 0.00 315.95 90983WBT7 1249 101 UNTDCM 248,000.00 248,000.00 248,000.00 1.650 1.650 336.33 0.00 0.00 336.33 32114VBT3 1250 101 1STNMI 248,000.00 248,000.00 248,000.00 1.650 1.650 336.33 0.00 0.00 336.33 77579ADF0 1251 101 RLLSTN 245,000.00 245,000.00 245,000.00 1.650 1.650 332.26 0.00 0.00 332.26 17286TAG0 1252 101 CITADL 248,000.00 248,000.00 248,000.00 1.650 1.650 336.33 0.00 0.00 336.33 87164DRD4 1253 101 SYNOVS 245,000.00 245,000.00 245,000.00 1.600 1.600 322.20 0.00 0.00 322.20 81768PAF3 1254 101 SERVIS 248,000.00 248,000.00 248,000.00 1.600 1.600 326.14 0.00 0.00 326.14 029728BC5 1255 101 AMERST 248,000.00 248,000.00 248,000.00 1.600 1.600 326.14 0.00 0.00 326.14 00435JBH5 1256 101 ACCSS 248,000.00 248,000.00 248,000.00 1.600 1.600 326.14 0.00 0.00 326.14 849430BF9 1257 101 SPRING 248,000.00 248,000.00 248,000.00 1.500 1.500 305.76 0.00 0.00 305.76 05465DAE8 1258 101 AXOS 248,000.00 248,000.00 248,000.00 1.650 1.650 336.33 0.00 0.00 336.33 12738RFX7 1259 101 CADNCE 245,000.00 245,000.00 245,000.00 1.200 1.200 241.64 0.00 0.00 241.64 882213AB7 1260 101 TEXAS 245,000.00 245,000.00 245,000.00 1.100 1.100 221.51 0.00 0.00 221.51 06424KBC3 1261 101 SNTCLR 248,000.00 248,000.00 248,000.00 1.100 1.100 224.22 0.00 0.00 224.22 89579NCD3 1262 101 TRIAD 248,000.00 248,000.00 248,000.00 1.350 1.350 275.18 0.00 0.00 275.18 66704MEQ0 1263 101 NRTHSR 248,000.00 248,000.00 248,000.00 1.150 1.150 234.41 0.00 0.00 234.41 07833EAD9 1264 101 BELLCO 248,000.00 248,000.00 248,000.00 1.300 1.300 264.99 0.00 0.00 264.99 Portfolio CITY CP Run Date: 09/10/2021 - 18:21 TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 City of La Quinta Total Earnings April 1, 2021 -April 30, 2021 Page 5 Adjusted Interest Earnings Ending Beginning Ending Current Annualized Interest Amortization/ Realized Adjusted Interest CUSIP Investment # Fund Issuer Par Value Book Value Book Value Rate Yield Earned Accretion Gainl/Loss Earnings Fund: General Fund 954444BS3 1265 101 WESTMI 248,000.00 248,000.00 248,000.00 1.150 1.150 234.41 0.00 0.00 234.41 654062JZ2 1266 101 NCOLET 248,000.00 248,000.00 248,000.00 1.400 1.400 285.37 0.00 0.00 285.37 020080BX4 1267 101 ALMABK 248,000.00 248,000.00 248,000.00 1.400 1.400 285.37 0.00 0.00 285.37 2027506M2 1268 101 CMWBUS 248,000.00 248,000.00 248,000.00 1.250 1.250 254.79 0.00 0.00 254.79 69506YRH4 1269 101 PACWST 245,000.00 245,000.00 245,000.00 1.300 1.300 261.78 0.00 0.00 261.78 08016PDQ9 1270 101 BELB&T 248,000.00 248,000.00 248,000.00 1.250 1.250 254.79 0.00 0.00 254.79 14042TDD6 1271 101 CAPONE 245,000.00 245,000.00 245,000.00 1.600 1.600 322.19 0.00 0.00 322.19 472382AQ3 1272 101 THEJEF 248,000.00 248,000.00 248,000.00 1.250 1.250 254.80 0.00 0.00 254.80 32027BAL1 1273 101 1STFDM 249,000.00 249,000.00 249,000.00 1.200 1.200 245.60 0.00 0.00 245.60 32112UDR9 1274 101 1STMCG 248,000.00 248,000.00 248,000.00 1.350 1.350 275.18 0.00 0.00 275.18 3134GVLC0 1275 101 FHLMC 0.00 998,500.00 0.00 0.700 3.452 388.89 0.00 1,500.00 1,888.89 33847E3A3 1276 101 FLGSTR 248,000.00 248,000.00 248,000.00 1.250 1.250 254.79 0.00 0.00 254.79 95960NKD8 1277 101 WSTRNS 245,000.00 245,000.00 245,000.00 1.000 1.000 201.37 0.00 0.00 201.37 32056GDJ6 1278 101 1STINT 248,000.00 248,000.00 248,000.00 1.000 1.000 203.84 0.00 0.00 203.84 3134GVYG7 1279 101 FHLMC 1,000,000.00 1,000,000.00 1,000,000.00 0.625 0.634 520.83 0.00 0.00 520.83 3133ELH23 1280 101 FFCB 500,000.00 499,850.00 499,850.00 0.500 0.507 208.33 0.00 0.00 208.33 3130AJKW8 1281 101 FHLB 500,000.00 499,850.00 499,850.00 0.500 0.507 208.33 0.00 0.00 208.33 3133ELH80 1282 101 FFCB 500,000.00 500,000.00 500,000.00 0.680 0.689 283.34 0.00 0.00 283.34 3130AJRP6 1283 101 FHLB 300,000.00 300,000.00 300,000.00 0.680 0.689 170.00 0.00 0.00 170.00 169894AS1 1284 101 CHIPVA 248,000.00 248,000.00 248,000.00 0.600 0.600 122.30 0.00 0.00 122.30 02616AAH2 1285 101 AMR1ST 248,000.00 248,000.00 248,000.00 0.350 0.350 71.34 0.00 0.00 71.34 84223QAN7 1286 101 STHRNB 248,000.00 248,000.00 248,000.00 0.500 0.500 101.92 0.00 0.00 101.92 064520BG3 1287 101 BKPRNC 248,000.00 248,000.00 248,000.00 0.500 0.500 101.92 0.00 0.00 101.92 3135G05S8 1288 101 FNMA 500,000.00 500,000.00 500,000.00 0.500 0.507 208.33 0.00 0.00 208.33 3136G4N74 1289 101 FNMA 1,000,000.00 1,000,000.00 1,000,000.00 0.560 0.568 466.67 0.00 0.00 466.67 3136G4M75 1290 101 FNMA 500,000.00 499,750.00 499,750.00 0.520 0.527 216.66 0.00 0.00 216.66 3135G06E8 1291 101 FNMA 500,000.00 499,250.00 499,250.00 0.420 0.426 175.00 0.00 0.00 175.00 3135GA2Z3 1292 101 FNMA 500,000.00 499,250.00 499,250.00 0.560 0.569 233.34 0.00 0.00 233.34 SYS1293 1293 101 BNY 3,254,568.53 3,257,492.64 3,254,568.53 0.01 0.00 0.00 0.01 3137EAEU9 1297 101 FHLMC 1,000,000.00 997,300.00 997,300.00 0.375 0.381 312.50 0.00 0.00 312.50 3130AKFA9 1298 101 FHLB 500,000.00 497,400.00 497,400.00 0.375 0.382 156.25 0.00 0.00 156.25 3135GA7D7 1299 101 FNMA 500,000.00 500,000.00 500,000.00 0.600 0.608 250.00 0.00 0.00 250.00 3135GAAW1 1300 101 FNMA 500,000.00 500,000.00 500,000.00 0.400 0.406 166.66 0.00 0.00 166.66 3134GXGZ1 1301 101 FHLMC 500,000.00 500,000.00 500,000.00 0.550 0.558 229.17 0.00 0.00 229.17 3130AKMZ6 1302 101 FHLB 500,000.00 500,000.00 500,000.00 0.510 0.517 212.50 0.00 0.00 212.50 91282CBC4 1303 101 USTR 500,000.00 498,632.81 498,632.81 0.375 0.379 155.39 0.00 0.00 155.39 3130AKN28 1304 101 FHLB 500,000.00 500,000.00 500,000.00 0.550 0.558 229.17 0.00 0.00 229.17 Run Date: 09/10/2021 - 18:21 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 City of La Quinta Total Earnings April 1, 2021 -April 30, 2021 Page 6 Adjusted Interest Earnings Ending Beginning Ending Current Annualized Interest Amortization/ Realized Adjusted Interest CUSIP Investment # Fund Issuer Par Value Book Value Book Value Rate Yield Earned Accretion Gainl/Loss Earnings Fund: General Fund 51507LCC6 1305 101 LNDMRK 248,000.00 248,000.00 248,000.00 0.500 0.500 101.92 0.00 0.00 101.92 87270LDL4 1306 101 EVRBA 245,000.00 245,000.00 245,000.00 0.500 0.500 100.68 0.00 0.00 100.68 3137EAEX3 1307 101 FHLMC 500,000.00 495,999.50 495,999.50 0.375 0.383 156.25 0.00 0.00 156.25 45950VPS9 1308 101 IFC 500,000.00 497,300.00 497,300.00 0.500 0.507 207.18 0.00 0.00 207.18 91282CBH3 1309 101 USTR 500,000.00 495,100.00 495,100.00 0.375 0.382 155.39 0.00 0.00 155.39 3137EAEX3 1310 101 FHLMC 1,000,000.00 983,940.00 983,940.00 0.375 0.386 312.50 0.00 0.00 312.50 91282CAT8 1311 101 USTR 1,000,000.00 977,500.00 977,500.00 0.250 0.258 207.07 0.00 0.00 207.07 3130ALV92 1312 101 FHLB 500,000.00 500,000.00 500,000.00 0.500 0.507 208.34 0.00 0.00 208.34 39573LBC1 1313 101 GRNST 249,000.00 0.00 249,000.00 0.950 0.950 90.73 0.00 0.00 90.73 89235MKY6 1314 101 TOYFSB 245,000.00 0.00 245,000.00 0.900 0.900 54.37 0.00 0.00 54.37 91282CAZ4 1315 101 USTR 500,000.00 0.00 492,187.50 0.375 0.382 46.36 0.00 0.00 46.36 14622LAA0 1316 101 CARTER 248,000.00 0.00 248,000.00 0.750 0.750 15.29 0.00 0.00 15.29 31617CAV5 1317 101 FIDHMS 248,000.00 0.00 248,000.00 0.700 0.00 0.00 0.00 0.00 SYS1318 1318 101 DPME 217,583.21 130,583.11 217,583.21 0.00 0.00 0.00 0.00 Subtotal 151,069,402.16 145,169,472.70 150,822,649.33 0.887 104,262.87 0.00 1,500.00 105,762.87 Fund: Fiscal Agent SYS1058 1058 231 USBANK 1,422.08 23.73 1,422.08 0.513 0.01 0.00 0.00 0.01 Subtotal 1,422.08 23.73 1,422.08 0.513 0.01 0.00 0.00 0.01 Fund: Housing Authority : WSA and LQ SYS1062 1062 241 LQPR 334,384.44 328,273.80 334,384.44 0.00 0.00 0.00 0.00 Subtotal 334,384.44 328,273.80 334,384.44 0.00 0.00 0.00 0.00 Fund: SA Low/Mod Bond Fund 25-33-005 1113 249 LAIF 10,580,686.54 10,569,141.10 10,580,686.54 0.339 0.328 2,846.99 0.00 0.00 2,846.99 Subtotal 10,580,686.54 10,569,141.10 10,580,686.54 0.328 2,846.99 0.00 0.00 2,846.99 Run Date: 09/10/2021 - 18:21 Total 161,985,895.22 156,066,911.33 161,739,142.39 0.847 107,109.87 0.00 1,500.00 108,609.87 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 adiflai GEM of the DESERT — City of La Quinta Portfolio Management Portfolio Summary May 31, 2021 City of La Quinta Investments Par Market Book % City of La Quinta Portfolio Management Portfolio Details - Investments May 31, 2021 Page 1 Average Purchase Stated Days to YTM Maturity CUSIP Investment # Issuer Balance Date Par Value Market Value Book Value Rate Term Maturity 365 Date Bank Accounts SYS1293 1293 Bank of New York 09/01/2020 3,056,596.78 3,056,596.78 3,056,596.78 1 1 0.000 059731851 1228 Bank of the West 08/20/2019 11,490,355.05 11,490,355.05 11,490,355.05 1 1 0.000 SYS1059 1059 City Petty Cash 07/01/2016 3,300.00 3,300.00 3,300.00 1 1 0.000 SYS1318 1318 Dune Palms Mobile Estates 03/09/2021 241,247.93 241,247.93 241,247.93 1 1 0.000 SYS1062 1062 La Quinta Palms Realty 07/01/2016 326,355.81 326,355.81 326,355.81 1 1 0.000 SYS1183 1183 Stifel, Nicolaus & Company 03/18/2019 0.00 0.00 0.00 1 1 0.000 Subtotal and Average 13,268,789.78 15,117,855.57 15,117,855.57 15,117,855.57 1 1 0.000 Local Agency Investment Fund -City 98-33-434 1055 Local Agency Inv Fund 58,929,948.66 59,266,295.86 58,929,948.66 0.315 1 1 0.315 Subtotal and Average 56,333,174.47 58,929,948.66 59,266,295.86 58,929,948.66 1 1 0.315 Local Agency Invstmnt Fund -Housing 25-33-005 1113 Local Agency Inv Fund Subtotal and Average 10,580,686.54 10,580,686.54 10,580,686.54 10,662,970.55 10,580,686.54 0.315 1 1 0.315 10,662,970.55 10,580,686.54 1 1 0.315 Money Market/Mutual Funds X9USDDTP3 1294 Dreyfus 09/24/2020 0.00 0.00 0.00 1 1 0.000 Subtotal and Average 0.00 0.00 0.00 0.00 0 0 0.000 Money Market Accounts - CAMP SYS1153 1153 California Asset Management Pr Subtotal and Average 854,098.26 09/26/2018 854,136.10 854,136.10 854,136.10 0.050 1 1 0.050 854,136.10 854,136.10 854,136.10 1 1 0.050 Federal Agency Coupon Securities 3133EHWM1 1105 Federal Farm Credit Bank 11/09/2017 1,000,000.00 1,004,050.00 992,200.00 1.700 1,392 92 1.913 09/01/2021 3133EJYL7 1158 Federal Farm Credit Bank 10/15/2018 250,000.00 264,447.50 247,275.00 2.800 1,786 826 3.041 09/05/2023 3133EKQP4 1198 Federal Farm Credit Bank 06/20/2019 500,000.00 513,395.00 499,500.00 1.875 1,271 559 1.905 12/12/2022 3133EKWV4 1212 Federal Farm Credit Bank 08/02/2019 500,000.00 522,785.00 499,500.00 1.850 1,820 1,151 1.871 07/26/2024 3133EKZK5 1223 Federal Farm Credit Bank 09/12/2019 500,000.00 515,090.00 499,400.00 1.600 1,432 804 1.632 08/14/2023 3133EKP75 1224 Federal Farm Credit Bank 09/17/2019 500,000.00 519,625.00 498,750.00 1.600 1,827 1,204 1.652 09/17/2024 3133EK4X1 1234 Federal Farm Credit Bank 11/01/2019 1,000,000.00 1,032,180.00 996,900.00 1.600 1,461 883 1.680 11/01/2023 3133ELEA8 1242 Federal Farm Credit Bank 12/17/2019 1,000,000.00 1,043,410.00 998,600.00 1.700 1,736 1,204 1.731 09/17/2024 3133ELNE0 1246 Federal Farm Credit Bank 02/14/2020 1,000,000.00 1,029,940.00 999,000.00 1.430 1,461 988 1.456 02/14/2024 3133EGWJO 1247 Federal Farm Credit Bank 02/05/2020 1,000,000.00 1,017,120.00 999,217.36 1.400 967 485 1.430 09/29/2022 Run Date: 09/10/2021 - 10:31 Portfolio CITY CP PM (PRF_PM2) 7.3.0 Report Ver. 7.3.6.1 CUSIP Investment # Issuer City of La Quinta Portfolio Management Portfolio Details - Investments May 31, 2021 Average Purchase Balance Date Par Value Page 2 Stated Days to YTM Maturity Market Value Book Value Rate Term Maturity 365 Date Federal Agency Coupon Securities 3133ELH23 1280 Federal Farm Credit Bank 06/09/2020 500,000.00 498,010.00 499,850.00 0.500 1,826 1,469 0.506 06/09/2025 3133ELH80 1282 Federal Farm Credit Bank 06/10/2020 500,000.00 499,160.00 500,000.00 0.680 1,826 1,470 0.680 06/10/2025 3130AFW94 1177 Federal Home Loan Bank 03/01/2019 500,000.00 531,105.00 498,550.00 2.500 1,810 987 2.563 02/13/2024 3130AJKW8 1281 Federal Home Loan Bank 06/03/2020 500,000.00 498,010.00 499,850.00 0.500 1,836 1,473 0.506 06/13/2025 3130AJRP6 1283 Federal Home Loan Bank 06/30/2020 300,000.00 297,759.00 300,000.00 0.680 1,826 1,490 0.680 06/30/2025 3130AKFA9 1298 Federal Home Loan Bank 12/07/2020 500,000.00 492,630.00 497,400.00 0.375 1,831 1,655 0.480 12/12/2025 3130AKMZ6 1302 Federal Home Loan Bank 01/14/2021 500,000.00 493,180.00 500,000.00 0.510 1,826 1,688 0.510 01/14/2026 3130AKN28 1304 Federal Home Loan Bank 01/29/2021 500,000.00 494,880.00 500,000.00 0.550 1,826 1,703 0.550 01/29/2026 3130ALV92 1312 Federal Home Loan Bank 03/30/2021 500,000.00 499,750.00 500,000.00 0.500 1,826 1,763 0.938 03/30/2026 3134GVYG7 1279 Federal Home Loan Mtg Corp 05/27/2020 1,000,000.00 1,000,110.00 1,000,000.00 0.625 1,826 1,456 0.625 05/27/2025 3137EAEU9 1297 Federal Home Loan Mtg Corp 12/07/2020 1,000,000.00 990,070.00 997,300.00 0.375 1,687 1,511 0.434 07/21/2025 3134GXGZ1 1301 Federal Home Loan Mtg Corp 12/30/2020 500,000.00 494,829.00 500,000.00 0.550 1,826 1,673 0.550 12/30/2025 3137EAEX3 1307 Federal Home Loan Mtg Corp 02/23/2021 500,000.00 494,240.00 495,999.50 0.375 1,673 1,575 0.552 09/23/2025 3137EAEX3 1310 Federal Home Loan Mtg Corp 03/30/2021 1,000,000.00 988,480.00 983,940.00 0.375 1,638 1,575 0.740 09/23/2025 3135G0V75 1206 Federal National Mtg Assn 07/15/2019 500,000.00 521,500.00 495,950.00 1.750 1,814 1,127 1.922 07/02/2024 3135G0W33 1233 Federal National Mtg Assn 10/29/2019 1,000,000.00 1,015,890.00 992,100.00 1.375 1,043 462 1.659 09/06/2022 3135G05S8 1288 Federal National Mtg Assn 08/14/2020 500,000.00 496,150.00 500,000.00 0.500 1,826 1,535 0.500 08/14/2025 3136G4N74 1289 Federal National Mtg Assn 08/21/2020 1,000,000.00 995,100.00 1,000,000.00 0.560 1,826 1,542 0.560 08/21/2025 3136G4M75 1290 Federal National Mtg Assn 08/28/2020 500,000.00 496,665.00 499,750.00 0.520 1,816 1,539 0.530 08/18/2025 3135G06E8 1291 Federal National Mtg Assn 11/18/2020 500,000.00 499,205.00 499,250.00 0.420 1,461 1,266 0.458 11/18/2024 3135GA2Z3 1292 Federal National Mtg Assn 11/17/2020 500,000.00 495,485.00 499,250.00 0.560 1,826 1,630 0.590 11/17/2025 3135GA7D7 1299 Federal National Mtg Assn 12/23/2020 500,000.00 495,775.00 500,000.00 0.600 1,826 1,666 0.600 12/23/2025 3135GAAW1 1300 Federal National Mtg Assn 12/30/2020 500,000.00 499,490.00 500,000.00 0.400 1,461 1,308 0.400 12/30/2024 Subtotal and Average 20,989,531.86 21,050,000.00 21,249,515.50 20,989,531.86 1,628 1,211 1.099 Treasury Coupon Securities 912828S27 1045 U.S. Treasury 07/18/2016 5,000,000.00 5,004,400.00 5,000,000.00 1.125 1,808 29 1.125 06/30/2021 912828T67 1070 U.S. Treasury 03/27/2017 2,000,000.00 2,010,000.00 1,942,800.00 1.250 1,679 152 1.903 10/31/2021 9128282W9 1178 U.S. Treasury 03/01/2019 500,000.00 511,760.00 489,687.50 1.875 1,309 486 2.480 09/30/2022 912828SV3 1192 U.S. Treasury 05/31/2019 500,000.00 508,010.00 496,650.00 1.750 1,080 348 1.984 05/15/2022 912828T26 1217 U.S. Treasury 08/21/2019 500,000.00 513,750.00 499,300.00 1.375 1,501 851 1.410 09/30/2023 912828YV6 1241 U.S. Treasury 12/16/2019 1,000,000.00 1,036,950.00 989,687.50 1.500 1,811 1,278 1.718 11/30/2024 91282CBC4 1303 U.S. Treasury 01/07/2021 500,000.00 492,500.00 498,632.81 0.375 1,819 1,674 0.431 12/31/2025 91282CBH3 1309 U.S. Treasury 02/23/2021 500,000.00 491,780.00 495,100.00 0.375 1,803 1,705 0.577 01/31/2026 91282CAT8 1311 U.S. Treasury 03/30/2021 1,000,000.00 981,760.00 977,500.00 0.250 1,676 1,613 0.750 10/31/2025 91282CAZ4 1315 U.S. Treasury 04/22/2021 500,000.00 493,030.00 492,187.50 0.375 1,683 1,643 0.720 11/30/2025 Run Date: 09/10/2021 - 10:31 Portfolio CITY CP PM (PRF_PM2) 7.3.0 CUSIP Investment # Issuer City of La Quinta Portfolio Management Portfolio Details - Investments May 31, 2021 Average Purchase Balance Date Par Value Page 3 Stated Days to YTM Maturity Market Value Book Value Rate Term Maturity 365 Date Treasury Coupon Securities 91282CBQ3 91282CBT7 1319 1320 U.S. Treasury U.S. Treasury Subtotal and Average 12,487,450.47 05/28/2021 500,000.00 494,260.00 494,165.00 0.500 1,737 1,733 0.750 02/28/2026 05/28/2021 500,000.00 499,650.00 499,525.00 0.750 1,768 1,764 0.770 03/31/2026 13,000,000.00 13,037,850.00 12,875,235.31 1,711 648 1.264 Certificate of Deposits 336460CX6 1222 First State Bk DeQueen 08/30/2019 248,000.00 258,517.46 248,000.00 1.800 1,827 1,186 1.802 08/30/2024 32027BAL1 1273 First Freedom Bank 04/29/2020 249,000.00 254,228.07 249,000.00 1.200 1,826 1,428 1.201 04/29/2025 33766LAJ7 1216 FirsTierBank 08/23/2019 249,000.00 261,039.51 249,000.00 1.950 1,827 1,179 1.952 08/23/2024 32056GDJ6 1278 1st Internet Bank 05/11/2020 248,000.00 251,487.51 248,000.00 1.000 1,827 1,441 0.985 05/12/2025 32112UDR9 1274 First Natl Bk McGregor 04/28/2020 248,000.00 254,859.70 248,000.00 1.350 1,826 1,427 1.351 04/28/2025 32110YLK9 1147 First National Bank of America 07/20/2018 245,000.00 260,437.24 245,000.00 3.150 1,826 779 3.152 07/20/2023 32117BCX4 1179 First National Bank 03/05/2019 248,000.00 260,487.59 248,000.00 2.800 1,522 703 2.802 05/05/2023 334342CD2 1221 First Natl Bk of Syracuse 08/30/2019 249,000.00 259,967.90 249,000.00 1.850 1,827 1,186 1.852 08/30/2024 32114VBT3 1250 First National Bank Michigan 02/14/2020 248,000.00 257,842.18 248,000.00 1.650 1,827 1,354 1.652 02/14/2025 33625CCP2 1209 First Security Bank of WA 07/30/2019 248,000.00 259,983.46 248,000.00 2.000 1,827 1,155 2.002 07/30/2024 33640VDD7 1231 First Service Bank 11/15/2019 248,000.00 257,555.92 248,000.00 1.700 1,643 1,079 1.701 05/15/2024 33646CKP8 1168 First Source Bank 12/17/2018 245,000.00 248,553.26 245,000.00 3.150 1,066 169 3.153 11/17/2021 88413QBY3 1112 Third Federal Savings and Loan 01/30/2018 245,000.00 248,911.08 245,000.00 2.500 1,462 244 2.502 01/31/2022 00257TBD7 1207 Abacus Federal Savings 07/26/2019 248,000.00 259,871.29 248,000.00 1.950 1,827 1,151 1.952 07/26/2024 00435JBH5 1256 Access Bank 03/13/2020 248,000.00 257,381.37 248,000.00 1.600 1,826 1,381 1.601 03/13/2025 01748DBE5 1143 Allegiance Bank 06/13/2018 245,000.00 252,380.46 245,000.00 3.100 1,461 377 3.102 06/13/2022 01859BAA3 1095 Alliance Credit Union 10/13/2017 245,000.00 251,857.61 245,000.00 2.250 1,826 499 2.251 10/13/2022 020080BX4 1267 Alma Bank 03/30/2020 248,000.00 255,382.41 248,000.00 1.400 1,824 1,396 1.399 03/28/2025 03065AAL7 1200 America's Credit Union 06/28/2019 248,000.00 253,595.16 248,000.00 2.300 1,096 392 2.302 06/28/2022 029728BC5 1255 American State 02/21/2020 248,000.00 257,427.49 248,000.00 1.600 1,827 1,361 1.602 02/21/2025 02587CFU9 1096 American Express Fed Savings B 08/29/2017 240,000.00 246,574.44 240,000.00 2.400 1,826 454 2.402 08/29/2022 02616AAH2 1285 American First CU 06/26/2020 248,000.00 248,636.30 248,000.00 0.350 1,095 755 0.350 06/26/2023 02772JBD1 1205 American National Bank 07/19/2019 248,000.00 257,428.28 248,000.00 2.000 1,461 778 2.001 07/19/2023 034577AH9 1119 Aneca Federal Credit Union 03/22/2018 245,000.00 256,550.38 245,000.00 2.800 1,826 659 2.802 03/22/2023 05465DAE8 1258 Axos Bank 03/26/2020 248,000.00 257,944.22 248,000.00 1.650 1,826 1,394 1.651 03/26/2025 06740KLJ4 1097 Barclays Bank 10/25/2017 240,000.00 247,048.98 240,000.00 2.300 1,826 511 2.291 10/25/2022 066851WJ1 1172 Bar Harbor Bank and Trust 12/31/2018 248,000.00 267,363.54 248,000.00 3.350 1,824 941 3.352 12/29/2023 08016PDQ9 1270 Belmont Bank and Trust 04/16/2020 248,000.00 254,178.57 248,000.00 1.250 1,461 1,050 1.251 04/16/2024 07833EAD9 1264 Bellco Credit Union 03/31/2020 248,000.00 250,263.72 248,000.00 1.300 729 302 1.300 03/30/2022 080515CD9 1102 Belmont Savings Bank 11/21/2017 245,000.00 247,385.53 245,000.00 2.100 1,462 174 2.101 11/22/2021 064520BG3 1287 Bank Princeton 06/30/2020 248,000.00 247,231.14 248,000.00 0.500 1,644 1,308 0.500 12/30/2024 Run Date: 09/10/2021 - 10:31 Portfolio CITY CP PM (PRF_PM2) 7.3.0 CUSIP City of La Quinta Portfolio Management Portfolio Details - Investments May 31, 2021 Page 4 Average Purchase Stated Days to YTM Maturity Investment # Issuer Balance Date Par Value Market Value Book Value Rate Term Maturity 365 Date Certificate of Deposits 05580AGK4 1067 BMW Bank 02/24/2017 240,000.00 243,682.32 240,000.00 2.200 1,826 268 2.201 02/24/2022 06652CHB0 1227 BankWest Inc 09/27/2019 248,000.00 258,092.42 248,000.00 1.700 1,827 1,214 1.702 09/27/2024 12738RFX7 1259 Cadence Bank, NA 03/31/2020 245,000.00 247,033.74 245,000.00 1.200 730 303 1.200 03/31/2022 14042RGD7 1082 Capital One Natl Assn FDIC4297 06/07/2017 240,000.00 240,147.30 240,000.00 2.250 1,461 6 2.252 06/07/2021 14042TDD6 1271 Capital One USA FDIC33954 04/08/2020 245,000.00 254,233.49 245,000.00 1.600 1,826 1,407 1.601 04/08/2025 14622LAA0 1316 Carter FCU 04/27/2021 248,000.00 246,825.92 248,000.00 0.750 1,826 1,791 0.750 04/27/2026 15118RRH2 1220 Celtic Bank 08/30/2019 248,000.00 258,923.86 248,000.00 1.850 1,827 1,186 1.852 08/30/2024 156634AK3 1184 Century Next Bank 05/29/2019 248,000.00 263,406.67 248,000.00 2.500 1,827 1,093 2.503 05/29/2024 169894AS1 1284 Chippewa Valley Bk 06/24/2020 248,000.00 247,342.95 248,000.00 0.600 1,826 1,484 0.600 06/24/2025 17286TAG0 1252 Citadel FCU 02/27/2020 248,000.00 257,935.38 248,000.00 1.650 1,827 1,367 1.652 02/27/2025 12556LBA3 1219 CIT Bank NA 08/23/2019 245,000.00 250,079.59 245,000.00 1.900 1,096 448 1.902 08/23/2022 17312QJ26 1123 Citibank NA 04/11/2018 245,000.00 257,366.44 245,000.00 2.900 1,826 679 2.902 04/11/2023 2027506M2 1268 Commonwealth Business Bk 03/31/2020 248,000.00 253,772.95 248,000.00 1.250 1,826 1,399 1.251 03/31/2025 15523RBJ4 1085 Central State Bank 07/14/2017 240,000.00 240,567.11 240,000.00 1.850 1,461 43 1.851 07/14/2021 20143PDV9 1162 Commercial Bank 11/15/2018 248,000.00 267,096.12 248,000.00 3.400 1,826 897 3.402 11/15/2023 20416TAQ5 1202 Communitywide FCU 06/28/2019 248,000.00 261,897.99 248,000.00 2.250 1,827 1,123 2.253 06/28/2024 20726ABA5 1189 Congressional Bank 04/30/2019 248,000.00 258,920.94 248,000.00 2.500 1,459 696 2.502 04/28/2023 22766ACB9 1106 CrossFirst Bank 11/20/2017 245,000.00 252,176.02 245,000.00 2.200 1,824 535 2.201 11/18/2022 176688CP2 1199 Citizens State Bank 06/21/2019 248,000.00 263,119.39 248,000.00 2.400 1,827 1,116 2.403 06/21/2024 2546722U1 1066 Discover Bank Greenwood DE CF 02/01/2017 240,000.00 243,454.03 240,000.00 2.250 1,826 245 2.251 02/01/2022 29278TAY6 1125 EnerBank USA 04/30/2018 240,000.00 252,663.76 240,000.00 2.950 1,824 696 2.952 04/28/2023 29367QCP1 1107 Enterprise Bank, NA 11/28/2017 245,000.00 252,130.04 245,000.00 2.150 1,826 545 2.151 11/28/2022 299547AQ2 1196 Evansville Teachers Credit FCU 06/12/2019 248,000.00 264,519.08 248,000.00 2.600 1,827 1,107 2.603 06/12/2024 87270LDL4 1306 TIAA FKA EverBank 02/12/2021 245,000.00 241,444.93 245,000.00 0.500 1,826 1,717 0.500 02/12/2026 30960QAG2 1126 Farmers Insurance Group FCU 04/30/2018 240,000.00 245,709.27 240,000.00 2.800 1,460 332 2.802 04/29/2022 31617CAV5 1317 Fidelity Homestead 04/30/2021 248,000.00 245,783.37 248,000.00 0.700 1,826 1,794 0.711 04/30/2026 33847E3A3 1276 Flagstar 04/30/2020 248,000.00 253,689.23 248,000.00 1.250 1,826 1,429 1.251 04/30/2025 35637RDC8 1248 Freedom Financial 02/14/2020 248,000.00 256,917.16 248,000.00 1.550 1,827 1,354 1.552 02/14/2025 369674AV8 1150 General Electric Credit Union 08/15/2018 240,000.00 241,610.46 240,000.00 3.100 1,097 76 3.100 08/16/2021 38148PJK4 1078 Goldman Sachs 04/26/2017 240,000.00 244,870.02 240,000.00 2.400 1,826 329 2.401 04/26/2022 39573LBC1 1313 Greenstate FCU 04/16/2021 249,000.00 250,244.18 249,000.00 0.950 1,826 1,780 0.951 04/16/2026 46256YAZ2 1186 Iowa State Bank 05/23/2019 245,000.00 259,661.17 245,000.00 2.400 1,827 1,087 2.403 05/23/2024 474067AQ8 1154 Jefferson Financial CU 10/19/2018 245,000.00 263,092.34 245,000.00 3.350 1,826 870 3.352 10/19/2023 48128HXU7 1185 JP Morgan Chase 05/16/2019 245,000.00 265,803.95 245,000.00 3.250 1,827 1,080 3.254 05/16/2024 50116CBE8 1101 Kansas State Bank 11/17/2017 245,000.00 249,511.76 245,000.00 2.100 1,642 350 2.099 05/17/2022 49228XAK6 1239 Kern FCU 12/30/2019 248,000.00 254,650.78 248,000.00 1.900 1,096 577 1.902 12/30/2022 Run Date: 09/10/2021 - 10:31 Portfolio CITY CP PM (PRF PM2) 7.3.0 CUSIP City of La Quinta Portfolio Management Portfolio Details - Investments May 31, 2021 Page 5 Average Purchase Stated Days to YTM Maturity Investment # Issuer Balance Date Par Value Market Value Book Value Rate Term Maturity 365 Date Certificate of Deposits 499724AB8 1110 Knoxville TVA Credit Union 12/29/2017 245,000.00 253,528.73 245,000.00 2.400 1,826 576 2.401 12/29/2022 524661CB9 1197 Legacy Bank 06/19/2019 248,000.00 263,092.57 248,000.00 2.400 1,827 1,114 2.403 06/19/2024 538036GV0 1238 Live Oak Bank 11/27/2019 248,000.00 258,297.52 248,000.00 1.800 1,644 1,092 1.802 05/28/2024 51210SQU4 1208 Lakeside Bank 07/30/2019 248,000.00 258,848.19 248,000.00 2.000 1,644 972 2.003 01/29/2024 51507LCC6 1305 Landmark Community Bank 01/22/2021 248,000.00 244,644.60 248,000.00 0.500 1,826 1,696 0.500 01/22/2026 549104JN8 1225 Luana Savings Bank 09/18/2019 245,000.00 247,837.56 245,000.00 1.600 912 290 1.599 03/18/2022 560507AK1 1171 Maine Savings FCU 12/28/2018 248,000.00 253,927.61 248,000.00 3.300 1,158 272 3.306 02/28/2022 56065GAG3 1188 Main Street Bank 04/26/2019 248,000.00 264,073.04 248,000.00 2.600 1,827 1,060 2.603 04/26/2024 57116ARV2 1155 Marlin Business Bank 10/17/2018 248,000.00 265,984.77 248,000.00 3.300 1,826 868 3.302 10/17/2023 58404DCX7 1169 Medallion Bank 12/07/2018 248,000.00 260,131.10 248,000.00 3.400 1,461 554 3.402 12/07/2022 61690UNX4 1237 Morgan Stanley Bank 11/20/2019 245,000.00 257,196.94 245,000.00 1.950 1,827 1,268 1.952 11/20/2024 619165JD6 1173 Morton Community 03/20/2019 248,000.00 261,050.04 248,000.00 2.750 1,553 749 2.753 06/20/2023 59013J4K2 1163 Merrick Bank 10/30/2018 248,000.00 258,721.40 248,000.00 3.250 1,459 514 3.252 10/28/2022 61760A3B3 1236 Morgan Stanley Private Bk, NA 11/20/2019 245,000.00 256,768.67 245,000.00 1.900 1,827 1,268 1.902 11/20/2024 62384RAC0 1099 Mountain America Federal CU 11/08/2017 245,000.00 252,402.46 245,000.00 2.300 1,826 525 2.301 11/08/2022 625925AR3 1160 Municipal Trust and Savings 10/17/2018 245,000.00 262,175.96 245,000.00 3.200 1,826 868 3.202 10/17/2023 654062JZ2 1266 Nicolet Natl Bank 03/31/2020 248,000.00 255,204.26 248,000.00 1.400 1,826 1,399 1.401 03/31/2025 64017AAQ7 1167 Neighbors FCU 12/21/2018 245,000.00 249,307.34 245,000.00 3.200 1,096 203 3.203 12/21/2021 635573AL2 1170 National Cooperative Bank, N.A 12/21/2018 245,000.00 264,489.59 245,000.00 3.400 1,826 933 3.402 12/21/2023 67054NAN3 1164 Numerica Credit Union 11/28/2018 248,000.00 268,200.11 248,000.00 3.550 1,826 910 3.552 11/28/2023 666613GV0 1127 Northpointe Bank 04/26/2018 240,000.00 242,606.54 240,000.00 2.700 1,279 147 2.703 10/26/2021 66704MEQ0 1263 Northstar Bank 03/31/2020 248,000.00 252,249.44 248,000.00 1.150 1,095 668 1.150 03/31/2023 66736ABP3 1181 Northwest Bank 02/13/2019 248,000.00 265,584.58 248,000.00 2.950 1,826 987 2.951 02/13/2024 06426KAN8 1151 Bank of New England 07/31/2018 249,000.00 265,269.88 249,000.00 3.250 1,826 790 3.252 07/31/2023 649447TC3 1226 New York Community Bank 09/27/2019 245,000.00 246,410.74 245,000.00 1.800 731 118 1.802 09/27/2021 677721CN0 1089 The Ohio Valley Bank 07/19/2017 240,000.00 242,747.05 240,000.00 1.900 1,645 232 1.903 01/19/2022 69506YRH4 1269 Pacific Western Bank 04/16/2020 245,000.00 251,454.66 245,000.00 1.300 1,461 1,050 1.301 04/16/2024 69324MAD7 1149 PCSB Bank 06/08/2018 245,000.00 252,032.20 245,000.00 3.000 1,461 372 3.002 06/08/2022 710571DS6 1210 People's Bank 07/31/2019 248,000.00 259,993.72 248,000.00 2.000 1,827 1,156 2.002 07/31/2024 725404AB3 1194 Pittsfield Cooperative Bank 06/07/2019 245,000.00 256,408.60 245,000.00 2.500 1,461 736 2.502 06/07/2023 72651LCL6 1195 Plains Commerce Bank 06/07/2019 245,000.00 260,858.08 245,000.00 2.550 1,827 1,102 2.553 06/07/2024 740367HP5 1213 Preferred Bank 08/16/2019 249,000.00 261,372.34 249,000.00 2.000 1,827 1,172 2.002 08/16/2024 75472RAD3 1218 Raymond James Bank 08/23/2019 244,000.00 253,312.87 244,000.00 1.950 1,461 813 1.951 08/23/2023 74934YAH4 1144 RCB Bank 06/20/2018 245,000.00 259,936.93 245,000.00 3.150 1,826 749 3.152 06/20/2023 75701LAB3 1166 Red Rocks Credit Union 12/07/2018 248,000.00 259,939.27 248,000.00 3.350 1,461 554 3.352 12/07/2022 761402BY1 1203 Revere Bank 06/28/2019 247,000.00 261,211.94 247,000.00 2.300 1,827 1,123 2.303 06/28/2024 Run Date: 09/10/2021 - 10:31 Portfolio CITY CP PM (PRF_PM2) 7.3.0 CUSIP Investment # Issuer Average Balance City of La Quinta Portfolio Management Portfolio Details - Investments May 31, 2021 Page 6 Purchase Stated Days to YTM Maturity Date Par Value Market Value Book Value Rate Term Maturity 365 Date Certificate of Deposits 77579ADF0 1251 795450A70 1083 804375DL4 1235 81768PAF3 1254 79772FAC0 1240 06424KBC3 1261 849430BF9 1257 84223QAN7 1286 85916VDC6 1201 87164XQV1 1080 87164DRD4 1253 882213AB7 1260 472382AQ3 1272 89235MKY6 1314 89269CBX9 1148 89579NCD3 1262 87266AAA1 1187 90348JEJ5 1161 90983WBT7 1249 910160AH3 1214 91435LAG2 1134 92535LCD4 1180 949763XY7 1174 954444BS3 1265 949495AT2 1244 938828BH2 1215 95960NKD8 1277 Rol!stone B&T Sallie Mae Bank Salt Lake City Sauk Valley B&T Co Servisfirst Bank San Francisco FCU Bank of Santa Clarita Spring Bank Southern Bancorp Bk Sterling Bank Synchrony Bank Retail Synovus Bank Texas Bank Financial The Jefferson Bank Toyota Financial Savings Bank Traditions Bank Triad Bank TNB Bank UBS Bank USA United Community United Credit Union University of Iowa Comm. CU Verus Bank of Commerce Wells Fargo West Michigan Cmnty Bk Wells Fargo Natl Bank West Washington Federal Western State Bank Subtotal and Average 32,194,548.39 02/12/2020 245,000.00 253,633.25 245,000.00 1.650 1,461 986 1.651 02/12/2024 06/21/2017 240,000.00 245,440.25 240,000.00 2.350 1,826 385 2.351 06/21/2022 11/07/2019 248,000.00 258,086.90 248,000.00 1.700 1,827 1,255 1.702 11/07/2024 02/21/2020 248,000.00 253,948.80 248,000.00 1.600 1,096 630 1.601 02/21/2023 12/30/2019 248,000.00 254,451.06 248,000.00 1.850 1,096 577 1.852 12/30/2022 03/31/2020 248,000.00 249,848.57 248,000.00 1.100 730 303 1.100 03/31/2022 03/20/2020 248,000.00 256,480.68 248,000.00 1.500 1,826 1,388 1.501 03/20/2025 06/26/2020 248,000.00 247,948.95 248,000.00 0.500 1,582 1,242 0.500 10/25/2024 06/28/2019 245,000.00 250,933.90 245,000.00 2.150 1,158 454 2.153 08/29/2022 06/02/2017 240,000.00 245,298.13 240,000.00 2.400 1,826 366 2.401 06/02/2022 03/09/2020 245,000.00 248,462.06 245,000.00 1.600 822 373 1.602 06/09/2022 03/31/2020 245,000.00 249,939.50 245,000.00 1.100 1,458 1,031 1.101 03/28/2024 04/15/2020 248,000.00 254,172.74 248,000.00 1.250 1,461 1,049 1.251 04/15/2024 04/22/2021 245,000.00 245,630.17 245,000.00 0.900 1,826 1,786 0.900 04/22/2026 06/08/2018 245,000.00 253,180.41 245,000.00 3.000 1,522 433 3.002 08/08/2022 03/30/2020 248,000.00 254,089.26 248,000.00 1.350 1,278 850 1.352 09/29/2023 05/22/2019 248,000.00 250,782.47 248,000.00 2.400 915 174 2.407 11/22/2021 10/17/2018 245,000.00 263,062.84 245,000.00 3.350 1,826 868 3.352 10/17/2023 02/07/2020 248,000.00 257,792.01 248,000.00 1.650 1,827 1,347 1.652 02/07/2025 08/22/2019 248,000.00 250,663.93 248,000.00 2.000 853 204 2.003 12/22/2021 05/14/2018 240,000.00 253,447.45 240,000.00 3.050 1,827 713 3.052 05/15/2023 02/28/2019 248,000.00 258,870.09 248,000.00 2.700 1,461 637 2.700 02/28/2023 02/27/2019 248,000.00 266,176.15 248,000.00 3.000 1,826 1,001 3.001 02/27/2024 03/31/2020 248,000.00 252,249.44 248,000.00 1.150 1,095 668 1.150 03/31/2023 01/29/2020 248,000.00 255,013.48 248,000.00 1.900 1,097 608 1.900 01/30/2023 08/23/2019 248,000.00 260,395.45 248,000.00 2.000 1,827 1,179 2.002 08/23/2024 05/13/2020 245,000.00 248,442.82 245,000.00 1.000 1,826 1,442 1.001 05/13/2025 32,001,000.00 33,096,459.96 32,001,000.00 1,604 860 2.089 Corporate Notes 037833CC2 19416QEA4 45950VPS9 594918BQ6 742718DY2 931142DU4 Run Date: 09/10/2021 - 10:31 1079 Apple Inc 1175 Colgate-Palmolive 1308 International Finance Corp. 1157 Microsoft Corporation 1159 Proctor and Gamble 1190 Wal-Mart Stores, Inc 06/12/2017 03/04/2019 02/26/2021 10/15/2018 10/15/2018 04/16/2019 500,000.00 500,000.00 500,000.00 400,000.00 500,000.00 500,000.00 500,585.00 514,355.00 495,145.00 414,532.00 507,440.00 515,360.00 493,050.00 1.550 1,514 64 485,250.00 1.950 1,430 610 497,300.00 0.500 1,826 1,731 378,360.00 2.000 1,758 798 487,950.00 2.300 1,210 250 496,650.00 2.350 1,339 562 1.900 08/04/2021 2.751 02/01/2023 0.610 02/26/2026 3.222 08/08/2023 3.071 02/06/2022 2.799 12/15/2022 Portfolio CITY CP PM (PRF_PM2) 7.3.0 CUSIP City of La Quinta Portfolio Management Portfolio Details - Investments May 31, 2021 Page 7 Average Purchase Stated Days to YTM Maturity Investment # Issuer Balance Date Par Value Market Value Book Value Rate Term Maturity 365 Date Subtotal and Average 2,838,560.00 2,900,000.00 2,947,417.00 2,838,560.00 1,504 666 2.354 Money Market with Fiscal Agent SYS1058 1058 US Bank 07/01/2016 1,422.15 1,422.15 1,422.15 1 1 0.000 Subtotal and Average 1,422.08 1,422.15 1,422.15 1,422.15 1 1 0.000 CERBT - OPEB Trust SYS1114 1114 CaIPERS CERBT Plan Subtotal and Average 1,934,231.01 07/01/2020 1,934,231.01 1,934,231.01 1,934,231.01 1,934,231.01 1,934,231.01 1,934,231.01 1 1 0.000 1 1 0.000 PARS Pension Trust SYS1230 1230 Pblc Agncy Rtrmnt Sery Subtotal and Average 11,229,455.06 07/01/2020 11, 277,103.22 11,277,103.22 11,277,103.22 11,277,103.22 11,277,103.22 11,277,103.22 1 1 0.000 1 1 0.000 Total and Average 162,711,947.92 Run Date: 09/10/2021 - 10:31 167,646,383.25 169,445,256.92 167,399,710.42 668 378 0.805 Portfolio CITY CP PM (PRF PM2) 7.3.0 GEM of the DESERT - City of La Quinta Total Earnings Sorted by Fund - Fund May 1, 2021 - May 31, 2021 City of La Quinta Adjusted Interest Earnings Ending Beginning Ending Current Annualized Interest Amortization/ Realized Adjusted Interest CUSIP Investment # Fund Issuer Par Value Book Value Book Value Rate Yield Earned Accretion Gainl/Loss Earnings Fund: General Fund 74267GVG9 1032 101 PRVTBA 0.00 240,000.00 0.00 1.500 1.500 246.58 0.00 0.00 246.58 912828S27 1045 101 USTR 5,000,000.00 5,000,000.00 5,000,000.00 1.125 1.134 4,816.98 0.00 0.00 4,816.98 98-33-434 1055 101 LAIF 58,929,948.66 55,429,948.66 58,929,948.66 0.315 0.333 15,688.70 0.00 0.00 15,688.70 SYS1059 1059 101 CITYPC 3,300.00 3,300.00 3,300.00 0.00 0.00 0.00 0.00 2546722U1 1066 101 DISCOV 240,000.00 240,000.00 240,000.00 2.250 2.250 458.63 0.00 0.00 458.63 05580AGK4 1067 101 BMW 240,000.00 240,000.00 240,000.00 2.200 2.200 448.44 0.00 0.00 448.44 912828T67 1070 101 USTR 2,000,000.00 1,942,800.00 1,942,800.00 1.250 1.276 2,105.98 0.00 0.00 2,105.98 38148PJK4 1078 101 GLDMAN 240,000.00 240,000.00 240,000.00 2.400 2.400 489.21 0.00 0.00 489.21 037833CC2 1079 101 APPL 500,000.00 493,050.00 493,050.00 1.550 1.542 645.83 0.00 0.00 645.83 87164XQV1 1080 101 SYNCHR 240,000.00 240,000.00 240,000.00 2.400 2.400 489.21 0.00 0.00 489.21 14042RGD7 1082 101 CAP1NA 240,000.00 240,000.00 240,000.00 2.250 2.250 458.63 0.00 0.00 458.63 795450A70 1083 101 SALMAE 240,000.00 240,000.00 240,000.00 2.350 2.350 479.01 0.00 0.00 479.01 15523RBJ4 1085 101 CNTRL 240,000.00 240,000.00 240,000.00 1.850 1.850 377.10 0.00 0.00 377.10 677721CN0 1089 101 OHVAL 240,000.00 240,000.00 240,000.00 1.900 1.900 387.29 0.00 0.00 387.29 01859BAA3 1095 101 ALLIAN 245,000.00 245,000.00 245,000.00 2.250 2.250 468.18 0.00 0.00 468.18 02587CFU9 1096 101 AMFSB 240,000.00 240,000.00 240,000.00 2.400 2.400 489.21 0.00 0.00 489.21 06740KLJ4 1097 101 BARCLY 240,000.00 240,000.00 240,000.00 2.300 2.300 468.82 0.00 0.00 468.82 62384RAC0 1099 101 MTNAMR 245,000.00 245,000.00 245,000.00 2.300 2.300 478.59 0.00 0.00 478.59 50116CBE8 1101 101 KANSAS 245,000.00 245,000.00 245,000.00 2.100 2.100 436.97 0.00 0.00 436.97 080515CD9 1102 101 BELMNT 245,000.00 245,000.00 245,000.00 2.100 2.100 436.98 0.00 0.00 436.98 3133EHWM1 1105 101 FFCB 1,000,000.00 992,200.00 992,200.00 1.700 1.681 1,416.67 0.00 0.00 1,416.67 22766ACB9 1106 101 CRS1ST 245,000.00 245,000.00 245,000.00 2.200 2.200 457.78 0.00 0.00 457.78 29367QCP1 1107 101 ENTRPR 245,000.00 245,000.00 245,000.00 2.150 2.150 447.38 0.00 0.00 447.38 499724AB8 1110 101 KNOX 245,000.00 245,000.00 245,000.00 2.400 2.400 499.40 0.00 0.00 499.40 88413QBY3 1112 101 3RD 245,000.00 245,000.00 245,000.00 2.500 2.500 520.21 0.00 0.00 520.21 SYS1114 1114 101 CALPRS 1,934,231.01 1,934,231.01 1,934,231.01 0.00 0.00 0.00 0.00 034577AH9 1119 101 ANECA 245,000.00 245,000.00 245,000.00 2.800 2.800 582.63 0.00 0.00 582.63 17312QJ26 1123 101 CITINA 245,000.00 245,000.00 245,000.00 2.900 2.900 603.44 0.00 0.00 603.44 29278TAY6 1125 101 ENER 240,000.00 240,000.00 240,000.00 2.950 2.950 601.32 0.00 0.00 601.32 30960QAG2 1126 101 FARMIG 240,000.00 240,000.00 240,000.00 2.800 2.800 570.74 0.00 0.00 570.74 Run Date: 09/10/2021 - 20:21 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 City of La Quinta Total Earnings May 1, 2021 - May 31, 2021 Page 2 Adjusted Interest Earnings Ending Beginning Ending Current Annualized Interest Amortization/ Realized Adjusted Interest CUSIP Investment # Fund Issuer Par Value Book Value Book Value Rate Yield Earned Accretion Gainl/Loss Earnings Fund: General Fund 666613GV0 1127 101 NORPNT 240,000.00 240,000.00 240,000.00 2.700 2.700 550.36 91435LAG2 1134 101 UOFICU 240,000.00 240,000.00 240,000.00 3.050 3.050 621.70 01748DBE5 1143 101 ALLGNC 245,000.00 245,000.00 245,000.00 3.100 3.100 645.05 74934YAH4 1144 101 RCB 245,000.00 245,000.00 245,000.00 3.150 3.150 655.46 32110YLK9 1147 101 1STNBA 245,000.00 245,000.00 245,000.00 3.150 3.150 655.46 89269CBX9 1148 101 TRAD 245,000.00 245,000.00 245,000.00 3.000 3.000 624.25 69324MAD7 1149 101 PCSB 245,000.00 245,000.00 245,000.00 3.000 3.000 624.25 369674AV8 1150 101 GECRUN 240,000.00 240,000.00 240,000.00 3.100 3.100 631.89 06426KAN8 1151 101 NWENGL 249,000.00 249,000.00 249,000.00 3.250 3.250 687.31 SYS1153 1153 101 CAMP 854,136.10 854,097.00 854,136.10 0.050 0.054 39.10 474067AQ8 1154 101 JEFF 245,000.00 245,000.00 245,000.00 3.350 3.350 697.07 57116ARV2 1155 101 MARBUS 248,000.00 248,000.00 248,000.00 3.300 3.300 695.08 59491813Q6 1157 101 MCRSFT 400,000.00 378,360.00 378,360.00 2.000 2.075 666.67 3133EJYL7 1158 101 FFCB 250,000.00 247,275.00 247,275.00 2.800 2.778 583.33 742718DY2 1159 101 P&G 500,000.00 487,950.00 487,950.00 2.300 2.312 958.33 625925AR3 1160 101 MUNTRS 245,000.00 245,000.00 245,000.00 3.200 3.200 665.86 90348JEJ5 1161 101 UBS 245,000.00 245,000.00 245,000.00 3.350 3.350 697.08 20143PDV9 1162 101 COMMBK 248,000.00 248,000.00 248,000.00 3.400 3.400 716.14 59013J4K2 1163 101 MRRCK 248,000.00 248,000.00 248,000.00 3.250 3.250 684.55 67054NAN3 1164 101 NMRCA 248,000.00 248,000.00 248,000.00 3.550 3.550 747.74 75701LAB3 1166 101 REDRCK 248,000.00 248,000.00 248,000.00 3.350 3.350 705.61 64017AAQ7 1167 101 NEIGH 245,000.00 245,000.00 245,000.00 3.200 3.200 665.86 33646CKP8 1168 101 1STSRC 245,000.00 245,000.00 245,000.00 3.150 3.150 655.46 58404DCX7 1169 101 MEDBA 248,000.00 248,000.00 248,000.00 3.400 3.400 716.14 635573AL2 1170 101 NLCOOP 245,000.00 245,000.00 245,000.00 3.400 3.400 707.48 560507AK1 1171 101 MAINE 248,000.00 248,000.00 248,000.00 3.300 3.300 695.09 066851WJ1 1172 101 BARHAR 248,000.00 248,000.00 248,000.00 3.350 3.350 705.61 619165JD6 1173 101 MORTN 248,000.00 248,000.00 248,000.00 2.750 2.750 579.23 949763XY7 1174 101 WELLS 248,000.00 248,000.00 248,000.00 3.000 3.000 631.89 19416QEA4 1175 101 COLGTE 500,000.00 485,250.00 485,250.00 1.950 1.971 812.50 3130AFW94 1177 101 FHLB 500,000.00 498,550.00 498,550.00 2.500 2.460 1,041.67 9128282W9 1178 101 USTR 500,000.00 489,687.50 489,687.50 1.875 1.909 794.05 32117BCX4 1179 101 1STNBK 248,000.00 248,000.00 248,000.00 2.800 2.800 589.76 92535LCD4 1180 101 VERUS 248,000.00 248,000.00 248,000.00 2.700 2.700 568.71 66736ABP3 1181 101 NRTHWS 248,000.00 248,000.00 248,000.00 2.950 2.950 621.36 156634AK3 1184 101 CENTNX 248,000.00 248,000.00 248,000.00 2.500 2.500 526.57 48128HXU7 1185 101 JPMORG 245,000.00 245,000.00 245,000.00 3.250 3.250 676.27 Run Date: 09/10/2021 - 20:21 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 550.36 621.70 645.05 655.46 655.46 624.25 624.25 631.89 687.31 39.10 697.07 695.08 666.67 583.33 958.33 665.86 697.08 716.14 684.55 747.74 705.61 665.86 655.46 716.14 707.48 695.09 705.61 579.23 631.89 812.50 1,041.67 794.05 589.76 568.71 621.36 526.57 676.27 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 City of La Quinta Total Earnings May 1, 2021 - May 31, 2021 Page 3 Adjusted Interest Earnings Ending Beginning Ending Current Annualized Interest Amortization/ Realized Adjusted Interest CUSIP Investment # Fund Issuer Par Value Book Value Book Value Rate Yield Earned Accretion Gainl/Loss Earnings Fund: General Fund 46256YAZ2 1186 101 IOWAST 245,000.00 245,000.00 245,000.00 2.400 2.400 499.40 0.00 0.00 499.40 87266AAA1 1187 101 TSCOLA 248,000.00 248,000.00 248,000.00 2.400 2.400 505.51 0.00 0.00 505.51 56065GAG3 1188 101 MAINST 248,000.00 248,000.00 248,000.00 2.600 2.600 547.64 0.00 0.00 547.64 20726ABA5 1189 101 CONGRS 248,000.00 248,000.00 248,000.00 2.500 2.500 526.58 0.00 0.00 526.58 931142DU4 1190 101 WALMRT 500,000.00 496,650.00 496,650.00 2.350 2.321 979.17 0.00 0.00 979.17 912828SV3 1192 101 USTR 500,000.00 496,650.00 496,650.00 1.750 1.761 742.61 0.00 0.00 742.61 912828R77 1193 101 USTR 0.00 493,610.00 0.00 1.375 17.147 566.62 0.00 6,390.00 6,956.62 725404AB3 1194 101 PITTS 245,000.00 245,000.00 245,000.00 2.500 2.500 520.21 0.00 0.00 520.21 72651LCL6 1195 101 PLAINS 245,000.00 245,000.00 245,000.00 2.550 2.550 530.61 0.00 0.00 530.61 299547AQ2 1196 101 EVNSCU 248,000.00 248,000.00 248,000.00 2.600 2.600 547.64 0.00 0.00 547.64 524661CB9 1197 101 LEGCY 248,000.00 248,000.00 248,000.00 2.400 2.400 505.51 0.00 0.00 505.51 3133EKQP4 1198 101 FFCB 500,000.00 499,500.00 499,500.00 1.875 1.842 781.25 0.00 0.00 781.25 176688CP2 1199 101 CTZNST 248,000.00 248,000.00 248,000.00 2.400 2.400 505.52 0.00 0.00 505.52 03065AAL7 1200 101 AMERCU 248,000.00 248,000.00 248,000.00 2.300 2.300 484.45 0.00 0.00 484.45 85916VDC6 1201 101 STRLNG 245,000.00 245,000.00 245,000.00 2.150 2.150 447.38 0.00 0.00 447.38 20416TAQ5 1202 101 COMMW 248,000.00 248,000.00 248,000.00 2.250 2.250 473.92 0.00 0.00 473.92 761402BY1 1203 101 REVER 247,000.00 247,000.00 247,000.00 2.300 2.300 482.49 0.00 0.00 482.49 02772JBD1 1205 101 AMRNTL 248,000.00 248,000.00 248,000.00 2.000 2.000 421.26 0.00 0.00 421.26 3135G0V75 1206 101 FNMA 500,000.00 495,950.00 495,950.00 1.750 1.731 729.17 0.00 0.00 729.17 00257TBD7 1207 101 ABACUS 248,000.00 248,000.00 248,000.00 1.950 1.950 410.73 0.00 0.00 410.73 51210SQU4 1208 101 LKSIDE 248,000.00 248,000.00 248,000.00 2.000 2.000 421.26 0.00 0.00 421.26 33625CCP2 1209 101 1STSEC 248,000.00 248,000.00 248,000.00 2.000 2.000 421.26 0.00 0.00 421.26 710571DS6 1210 101 PEOPLE 248,000.00 248,000.00 248,000.00 2.000 2.000 421.26 0.00 0.00 421.26 3133EKWV4 1212 101 FFCB 500,000.00 499,500.00 499,500.00 1.850 1.817 770.84 0.00 0.00 770.84 740367HP5 1213 101 PREFRD 249,000.00 249,000.00 249,000.00 2.000 2.000 422.96 0.00 0.00 422.96 910160AH3 1214 101 UNTDCU 248,000.00 248,000.00 248,000.00 2.000 2.000 421.26 0.00 0.00 421.26 938828BH2 1215 101 WSHFED 248,000.00 248,000.00 248,000.00 2.000 2.000 421.26 0.00 0.00 421.26 33766LAJ7 1216 101 1STIER 249,000.00 249,000.00 249,000.00 1.950 1.950 412.38 0.00 0.00 412.38 912828T26 1217 101 USTR 500,000.00 499,300.00 499,300.00 1.375 1.373 582.31 0.00 0.00 582.31 75472RAD3 1218 101 RAYJAM 244,000.00 244,000.00 244,000.00 1.950 1.950 404.10 0.00 0.00 404.10 12556LBA3 1219 101 CITBNK 245,000.00 245,000.00 245,000.00 1.900 1.900 395.36 0.00 0.00 395.36 15118RRH2 1220 101 CELTIC 248,000.00 248,000.00 248,000.00 1.850 1.850 389.67 0.00 0.00 389.67 334342CD2 1221 101 1STNBS 249,000.00 249,000.00 249,000.00 1.850 1.850 391.24 0.00 0.00 391.24 336460CX6 1222 101 1STDQN 248,000.00 248,000.00 248,000.00 1.800 1.800 379.13 0.00 0.00 379.13 3133EKZK5 1223 101 FFCB 500,000.00 499,400.00 499,400.00 1.600 1.572 666.67 0.00 0.00 666.67 3133EKP75 1224 101 FFCB 500,000.00 498,750.00 498,750.00 1.600 1.574 666.66 0.00 0.00 666.66 549104JN8 1225 101 LUANA 245,000.00 245,000.00 245,000.00 1.600 1.600 332.93 0.00 0.00 332.93 Run Date: 09/10/2021 - 20:21 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 City of La Quinta Total Earnings May 1, 2021 - May 31, 2021 Page 4 Adjusted Interest Earnings Ending Beginning Ending Current Annualized Interest Amortization/ Realized Adjusted Interest CUSIP Investment # Fund Issuer Par Value Book Value Book Value Rate Yield Earned Accretion Gainl/Loss Earnings Fund: General Fund 649447TC3 1226 101 NYCMBK 245,000.00 245,000.00 245,000.00 1.800 1.800 374.54 0.00 0.00 374.54 06652CHB0 1227 101 BNKWST 248,000.00 248,000.00 248,000.00 1.700 1.700 358.07 0.00 0.00 358.07 059731851 1228 101 BOTW 11,490,355.05 9,456,806.96 11,490,355.05 0.01 0.00 0.00 0.01 SYS1230 1230 101 PARS 11,277,103.22 11,227,866.79 11,277,103.22 0.00 0.00 0.00 0.00 33640VDD7 1231 101 1STSER 248,000.00 248,000.00 248,000.00 1.700 1.700 358.07 0.00 0.00 358.07 3135G0W33 1233 101 FNMA 1,000,000.00 992,100.00 992,100.00 1.375 1.360 1,145.84 0.00 0.00 1,145.84 3133EK4X1 1234 101 FFCB 1,000,000.00 996,900.00 996,900.00 1.600 1.575 1,333.33 0.00 0.00 1,333.33 804375DL4 1235 101 SAUKVL 248,000.00 248,000.00 248,000.00 1.700 1.700 358.07 0.00 0.00 358.07 61760A3B3 1236 101 MSPRIV 245,000.00 245,000.00 245,000.00 1.900 1.900 395.36 0.00 0.00 395.36 61690UNX4 1237 101 MORGST 245,000.00 245,000.00 245,000.00 1.950 1.950 405.76 0.00 0.00 405.76 538036GV0 1238 101 LIVEOK 248,000.00 248,000.00 248,000.00 1.800 1.800 379.13 0.00 0.00 379.13 49228XAK6 1239 101 KERNCU 248,000.00 248,000.00 248,000.00 1.900 1.900 400.20 0.00 0.00 400.20 79772FAC0 1240 101 SF FCU 248,000.00 248,000.00 248,000.00 1.850 1.850 389.67 0.00 0.00 389.67 912828YV6 1241 101 USTR 1,000,000.00 989,687.50 989,687.50 1.500 1.520 1,277.24 0.00 0.00 1,277.24 3133ELEA8 1242 101 FFCB 1,000,000.00 998,600.00 998,600.00 1.700 1.670 1,416.66 0.00 0.00 1,416.66 949495AT2 1244 101 WFNBW 248,000.00 248,000.00 248,000.00 1.900 1.900 400.20 0.00 0.00 400.20 3133ELNE0 1246 101 FFCB 1,000,000.00 999,000.00 999,000.00 1.430 1.404 1,191.67 0.00 0.00 1,191.67 3133EGWJ0 1247 101 FFCB 1,000,000.00 999,217.36 999,217.36 1.400 1.375 1,166.67 0.00 0.00 1,166.67 35637RDC8 1248 101 FRDMFI 248,000.00 248,000.00 248,000.00 1.550 1.550 326.48 0.00 0.00 326.48 90983WBT7 1249 101 UNTDCM 248,000.00 248,000.00 248,000.00 1.650 1.650 347.54 0.00 0.00 347.54 32114VBT3 1250 101 1STNMI 248,000.00 248,000.00 248,000.00 1.650 1.650 347.54 0.00 0.00 347.54 77579ADF0 1251 101 RLLSTN 245,000.00 245,000.00 245,000.00 1.650 1.650 343.33 0.00 0.00 343.33 17286TAG0 1252 101 CITADL 248,000.00 248,000.00 248,000.00 1.650 1.650 347.54 0.00 0.00 347.54 87164DRD4 1253 101 SYNOVS 245,000.00 245,000.00 245,000.00 1.600 1.600 332.93 0.00 0.00 332.93 81768PAF3 1254 101 SERVIS 248,000.00 248,000.00 248,000.00 1.600 1.600 337.01 0.00 0.00 337.01 029728BC5 1255 101 AMERST 248,000.00 248,000.00 248,000.00 1.600 1.600 337.01 0.00 0.00 337.01 00435JBH5 1256 101 ACCSS 248,000.00 248,000.00 248,000.00 1.600 1.600 337.01 0.00 0.00 337.01 849430BF9 1257 101 SPRING 248,000.00 248,000.00 248,000.00 1.500 1.500 315.94 0.00 0.00 315.94 05465DAE8 1258 101 AXOS 248,000.00 248,000.00 248,000.00 1.650 1.650 347.54 0.00 0.00 347.54 12738RFX7 1259 101 CADNCE 245,000.00 245,000.00 245,000.00 1.200 1.200 249.70 0.00 0.00 249.70 882213AB7 1260 101 TEXAS 245,000.00 245,000.00 245,000.00 1.100 1.100 228.89 0.00 0.00 228.89 06424KBC3 1261 101 SNTCLR 248,000.00 248,000.00 248,000.00 1.100 1.100 231.69 0.00 0.00 231.69 89579NCD3 1262 101 TRIAD 248,000.00 248,000.00 248,000.00 1.350 1.350 284.35 0.00 0.00 284.35 66704MEQ0 1263 101 NRTHSR 248,000.00 248,000.00 248,000.00 1.150 1.150 242.22 0.00 0.00 242.22 07833EAD9 1264 101 BELLCO 248,000.00 248,000.00 248,000.00 1.300 1.300 273.82 0.00 0.00 273.82 954444BS3 1265 101 WESTMI 248,000.00 248,000.00 248,000.00 1.150 1.150 242.22 0.00 0.00 242.22 654062JZ2 1266 101 NCOLET 248,000.00 248,000.00 248,000.00 1.400 1.400 294.88 0.00 0.00 294.88 Run Date: 09/10/2021 - 20:21 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 City of La Quinta Total Earnings May 1, 2021 - May 31, 2021 Page 5 Adjusted Interest Earnings Ending Beginning Ending Current Annualized Interest Amortization/ Realized Adjusted Interest CUSIP Investment # Fund Issuer Par Value Book Value Book Value Rate Yield Earned Accretion Gainl/Loss Earnings Fund: General Fund 020080BX4 1267 101 ALMABK 248,000.00 248,000.00 248,000.00 1.400 1.400 294.88 0.00 0.00 294.88 2027506M2 1268 101 CMWBUS 248,000.00 248,000.00 248,000.00 1.250 1.250 263.29 0.00 0.00 263.29 69506YRH4 1269 101 PACWST 245,000.00 245,000.00 245,000.00 1.300 1.300 270.51 0.00 0.00 270.51 08016PDQ9 1270 101 BELB&T 248,000.00 248,000.00 248,000.00 1.250 1.250 263.29 0.00 0.00 263.29 14042TDD6 1271 101 CAPONE 245,000.00 245,000.00 245,000.00 1.600 1.600 332.94 0.00 0.00 332.94 472382AQ3 1272 101 THEJEF 248,000.00 248,000.00 248,000.00 1.250 1.250 263.28 0.00 0.00 263.28 32027BAL1 1273 101 1STFDM 249,000.00 249,000.00 249,000.00 1.200 1.200 253.77 0.00 0.00 253.77 32112UDR9 1274 101 1STMCG 248,000.00 248,000.00 248,000.00 1.350 1.350 284.35 0.00 0.00 284.35 33847E3A3 1276 101 FLGSTR 248,000.00 248,000.00 248,000.00 1.250 1.250 263.29 0.00 0.00 263.29 95960NKD8 1277 101 WSTRNS 245,000.00 245,000.00 245,000.00 1.000 1.000 208.08 0.00 0.00 208.08 32056GDJ6 1278 101 1STINT 248,000.00 248,000.00 248,000.00 1.000 1.000 210.63 0.00 0.00 210.63 3134GVYG7 1279 101 FHLMC 1,000,000.00 1,000,000.00 1,000,000.00 0.625 0.613 520.83 0.00 0.00 520.83 3133ELH23 1280 101 FFCB 500,000.00 499,850.00 499,850.00 0.500 0.491 208.33 0.00 0.00 208.33 3130AJKW8 1281 101 FHLB 500,000.00 499,850.00 499,850.00 0.500 0.491 208.34 0.00 0.00 208.34 3133ELH80 1282 101 FFCB 500,000.00 500,000.00 500,000.00 0.680 0.667 283.33 0.00 0.00 283.33 3130AJRP6 1283 101 FHLB 300,000.00 300,000.00 300,000.00 0.680 0.667 170.00 0.00 0.00 170.00 169894AS1 1284 101 CHIPVA 248,000.00 248,000.00 248,000.00 0.600 0.600 126.38 0.00 0.00 126.38 02616AAH2 1285 101 AMR1ST 248,000.00 248,000.00 248,000.00 0.350 0.350 73.72 0.00 0.00 73.72 84223QAN7 1286 101 STHRNB 248,000.00 248,000.00 248,000.00 0.500 0.500 105.32 0.00 0.00 105.32 064520BG3 1287 101 BKPRNC 248,000.00 248,000.00 248,000.00 0.500 0.500 105.32 0.00 0.00 105.32 3135G05S8 1288 101 FNMA 500,000.00 500,000.00 500,000.00 0.500 0.491 208.34 0.00 0.00 208.34 3136G4N74 1289 101 FNMA 1,000,000.00 1,000,000.00 1,000,000.00 0.560 0.549 466.67 0.00 0.00 466.67 3136G4M75 1290 101 FNMA 500,000.00 499,750.00 499,750.00 0.520 0.510 216.67 0.00 0.00 216.67 3135G06E8 1291 101 FNMA 500,000.00 499,250.00 499,250.00 0.420 0.413 175.00 0.00 0.00 175.00 3135GA2Z3 1292 101 FNMA 500,000.00 499,250.00 499,250.00 0.560 0.550 233.33 0.00 0.00 233.33 SYS1293 1293 101 BNY 3,056,596.78 3,254,568.53 3,056,596.78 0.01 0.00 0.00 0.01 3137EAEU9 1297 101 FHLMC 1,000,000.00 997,300.00 997,300.00 0.375 0.369 312.50 0.00 0.00 312.50 3130AKFA9 1298 101 FHLB 500,000.00 497,400.00 497,400.00 0.375 0.370 156.25 0.00 0.00 156.25 3135GA7D7 1299 101 FNMA 500,000.00 500,000.00 500,000.00 0.600 0.589 250.00 0.00 0.00 250.00 3135GAAW1 1300 101 FNMA 500,000.00 500,000.00 500,000.00 0.400 0.392 166.67 0.00 0.00 166.67 3134GXGZ1 1301 101 FHLMC 500,000.00 500,000.00 500,000.00 0.550 0.540 229.16 0.00 0.00 229.16 3130AKMZ6 1302 101 FHLB 500,000.00 500,000.00 500,000.00 0.510 0.500 212.50 0.00 0.00 212.50 91282CBC4 1303 101 USTR 500,000.00 498,632.81 498,632.81 0.375 0.379 160.56 0.00 0.00 160.56 3130AKN28 1304 101 FHLB 500,000.00 500,000.00 500,000.00 0.550 0.540 229.16 0.00 0.00 229.16 51507LCC6 1305 101 LNDMRK 248,000.00 248,000.00 248,000.00 0.500 0.500 105.32 0.00 0.00 105.32 87270LDL4 1306 101 EVRBA 245,000.00 245,000.00 245,000.00 0.500 0.500 104.04 0.00 0.00 104.04 3137EAEX3 1307 101 FHLMC 500,000.00 495,999.50 495,999.50 0.375 0.371 156.25 0.00 0.00 156.25 Run Date: 09/10/2021 - 20:21 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 City of La Quinta Total Earnings May 1, 2021 - May 31, 2021 Page 6 Adjusted Interest Earnings Ending Beginning Ending Current Annualized Interest Amortization/ Realized Adjusted Interest CUSIP Investment # Fund Issuer Par Value Book Value Book Value Rate Yield Earned Accretion Gainl/Loss Earnings Fund: General Fund 45950VPS9 1308 101 IFC 500,000.00 497,300.00 497,300.00 0.500 0.507 214.09 0.00 0.00 214.09 91282CBH3 1309 101 USTR 500,000.00 495,100.00 495,100.00 0.375 0.382 160.57 0.00 0.00 160.57 3137EAEX3 1310 101 FHLMC 1,000,000.00 983,940.00 983,940.00 0.375 0.374 312.50 0.00 0.00 312.50 91282CAT8 1311 101 USTR 1,000,000.00 977,500.00 977,500.00 0.250 0.254 210.60 0.00 0.00 210.60 3130ALV92 1312 101 FHLB 500,000.00 500,000.00 500,000.00 0.500 0.491 208.33 0.00 0.00 208.33 39573LBC1 1313 101 GRNST 249,000.00 249,000.00 249,000.00 0.950 0.950 200.91 0.00 0.00 200.91 89235MKY6 1314 101 TOYFSB 245,000.00 245,000.00 245,000.00 0.900 0.900 187.27 0.00 0.00 187.27 91282CAZ4 1315 101 USTR 500,000.00 492,187.50 492,187.50 0.375 0.382 159.65 0.00 0.00 159.65 14622LAA0 1316 101 CARTER 248,000.00 248,000.00 248,000.00 0.750 0.750 157.97 0.00 0.00 157.97 31617CAV5 1317 101 FIDHMS 248,000.00 248,000.00 248,000.00 0.700 0.700 147.44 0.00 0.00 147.44 SYS1318 1318 101 DPME 241,247.93 217,583.21 241,247.93 0.00 0.00 0.00 0.00 91282CBQ3 1319 101 USTR 500,000.00 0.00 494,165.00 0.500 0.502 27.17 0.00 0.00 27.17 91282CBT7 1320 101 USTR 500,000.00 0.00 499,525.00 0.750 0.749 40.99 0.00 0.00 40.99 Subtotal 156,737,918.75 150,822,649.33 156,491,245.92 0.881 106,476.00 0.00 6,390.00 112,866.00 Fund: Fiscal Agent SYS1058 1058 231 USBANK 1,422.15 1,422.08 1,422.15 0.058 0.07 0.00 0.00 0.07 Subtotal 1,422.15 1,422.08 1,422.15 0.058 0.07 0.00 0.00 0.07 Fund: Housing Authority : WSA and LQ SYS1062 1062 241 LQPR 326,355.81 334,384.44 326,355.81 0.00 0.00 0.00 0.00 Subtotal 326,355.81 334,384.44 326,355.81 0.00 0.00 0.00 0.00 Fund: SA Low/Mod Bond Fund 25-33-005 1113 249 LAIF 10,580,686.54 10,580,686.54 10,580,686.54 0.315 0.328 2,943.40 0.00 0.00 2,943.40 Subtotal 10,580,686.54 10,580,686.54 10,580,686.54 0.328 2,943.40 0.00 0.00 2,943.40 Total Run Date: 09/10/2021 - 20:21 167,646,383.25 161,739,142.39 167,399,710.42 0.843 109,419.47 0.00 6,390.00 115,809.47 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 alidal GEM of rhe DESERT - - City of La Quinta Portfolio Management Portfolio Summary June 30, 2021 City of La Quinta Investments Par Market Book % of Days to YTM Value Value Value Portfolio Term Maturity 365 Equiv. Bank Accounts 15,661,58820 15,661,588.20 15,661,58820 838 1 1 0000 Local Agency Investment Fund -City 66,929,948 66 67,266,295.86 66,929,948 66 35 81 1 0 262 Local Agency Invstmnt Fund -Housing 10,580,686 54 10,662,970.55 10,580,686 54 5.66 1 0 262 Money Market Accounts - CAMP 13,854,440 98 13,854,440 98 13,854,440 98 7 41 1 0 050 Federal Agency Coupon Securities 22,050,000 00 22,183,649 50 21,982,951 86 11 76 1,637 1 209 1 089 Treasury Coupon Securities 10,000,000 00 10,000,895 00 9,867,840 31 5 28 1,680 1.166 1 246 Certificate of Deposits 31,761,000 00 32,746,450 56 31,761,000 00 16 99 1,605 837 2 088 Corporate Notes 2,900,000 00 2,940,984 00 2,838,560 00 1 52 1,504 636 2 354 Money Market with Fiscal Agent 1,422 16 1,422 16 1,422 16 0 00 1 1 0 000 CERBT - OPEB Trust 2,050,951 37 2,050,951 37 2,050,951 37 1.10 1 1 0.000 PARS Pension Trust 11,381,92240 11,381,92240 11,381,92240 609 1 1 0 000 Investments Total Earnings Current Year Average Daily Balance Effective Rate of Return 187,171,960.31 188, 751, 570.58 June 30 Month Ending 109,113.19 178,303,057.79 0.74% Fiscal Year To Date 1,533,545 58 160,732,268.52 0.95% 186,911,312.48 100.00% 577 356 0.697 Fiscal Year Ending 1,533,545 58 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. Claudia Martinez, Interim Finance Director Reporting period 06/01/2021-06/30/2021 Run Date: 09/10/2021 - 20:07 Portfolio CITY CP PM (PRF_PM1) 7 3 0 Report Ver 7 3 6 1 City of La Quinta Portfolio Management Portfolio Details - Investments June 30, 2021 Page 1 Average Purchase Stated Days to YTM Maturity CUSIP Investment # Issuer Balance Date Par Value Market Value Book Value Rate Term Maturity 365 Date Bank Accounts SYS1293 1293 Bank of New York 09/01/2020 5,000,000.00 5,000,000.00 5,000,000.00 1 1 0.000 059731851 1228 Bank of the West 08/20/2019 10,056,644.58 10,056,644.58 10,056,644.58 1 1 0.000 SYS1059 1059 City Petty Cash 07/01/2016 3,300.00 3,300.00 3,300.00 1 1 0.000 SYS1318 1318 Dune Palms Mobile Estates 03/09/2021 265,784.81 265,784.81 265,784.81 1 1 0.000 SYS1062 1062 La Quinta Palms Realty 07/01/2016 335,858.81 335,858.81 335,858.81 1 1 0.000 SYS1183 1183 Stifel, Nicolaus & Company 03/18/2019 0.00 0.00 0.00 1 1 0.000 Subtotal and Average 13,413,897.79 15,661,588.20 15,661,588.20 15,661,588.20 1 1 0.000 Local Agency Investment Fund -City 98-33-434 1055 Local Agency Inv Fund 66,929,948.66 67,266,295.86 66,929,948.66 0.262 1 1 0.262 Subtotal and Average 63,463,281.99 66,929,948.66 67,266,295.86 66,929,948.66 1 1 0.262 Local Agency Invstmnt Fund -Housing 25-33-005 1113 Local Agency Inv Fund Subtotal and Average 10,580,686.54 10,580,686.54 10,580,686.54 10,662,970.55 10,580,686.54 0.262 1 1 0.262 10,662,970.55 10,580,686.54 1 1 0.262 Money Market/Mutual Funds X9USDDTP3 1294 Dreyfus 09/24/2020 0.00 0.00 0.00 1 1 0.000 Subtotal and Average 0.00 0.00 0.00 0.00 0 0 0.000 Money Market Accounts - CAMP SYS1153 1153 California Asset Management Pr 09/26/2018 13,854,440.98 13,854,440.98 13,854,440.98 0.050 1 1 0.050 Subtotal and Average 7,354,146.26 13,854,440.98 13,854,440.98 13,854,440.98 1 1 0.050 Federal Agency Coupon Securities 3133EHWM1 1105 Federal Farm Credit Bank 11/09/2017 1,000,000.00 1,002,750.00 992,200.00 1.700 1,392 62 1.913 09/01/2021 3133EJYL7 1158 Federal Farm Credit Bank 10/15/2018 250,000.00 263,475.00 247,275.00 2.800 1,786 796 3.041 09/05/2023 3133EKQP4 1198 Federal Farm Credit Bank 06/20/2019 500,000.00 512,465.00 499,500.00 1.875 1,271 529 1.905 12/12/2022 3133EKWV4 1212 Federal Farm Credit Bank 08/02/2019 500,000.00 520,800.00 499,500.00 1.850 1,820 1,121 1.871 07/26/2024 3133EKZK5 1223 Federal Farm Credit Bank 09/12/2019 500,000.00 513,685.00 499,400.00 1.600 1,432 774 1.632 08/14/2023 3133EKP75 1224 Federal Farm Credit Bank 09/17/2019 500,000.00 517,320.00 498,750.00 1.600 1,827 1,174 1.652 09/17/2024 3133EK4X1 1234 Federal Farm Credit Bank 11/01/2019 1,000,000.00 1,029,200.00 996,900.00 1.600 1,461 853 1.680 11/01/2023 3133ELEA8 1242 Federal Farm Credit Bank 12/17/2019 1,000,000.00 1,037,740.00 998,600.00 1.700 1,736 1,174 1.731 09/17/2024 3133ELNE0 1246 Federal Farm Credit Bank 02/14/2020 1,000,000.00 1,026,940.00 999,000.00 1.430 1,461 958 1.456 02/14/2024 3133EGWJO 1247 Federal Farm Credit Bank 02/05/2020 1,000,000.00 1,015,800.00 999,217.36 1.400 967 455 1.430 09/29/2022 Run Date: 09/10/2021 - 20:07 Portfolio CITY CP PM (PRF_PM2) 7.3.0 Report Ver. 7.3.6.1 CUSIP Investment # Issuer City of La Quinta Portfolio Management Portfolio Details - Investments June 30, 2021 Page 2 Average Purchase Stated Days to YTM Maturity Balance Date Par Value Market Value Book Value Rate Term Maturity 365 Date Federal Agency Coupon Securities 3133ELH23 1280 Federal Farm Credit Bank 06/09/2020 500,000.00 496,780.00 499,850.00 0.500 1,826 1,439 0.506 06/09/2025 3133ELH80 1282 Federal Farm Credit Bank 06/10/2020 500,000.00 498,965.00 500,000.00 0.680 1,826 1,440 0.680 06/10/2025 3130AFW94 1177 Federal Home Loan Bank 03/01/2019 500,000.00 528,180.00 498,550.00 2.500 1,810 957 2.563 02/13/2024 3130AJKW8 1281 Federal Home Loan Bank 06/03/2020 500,000.00 496,200.00 499,850.00 0.500 1,836 1,443 0.506 06/13/2025 3130AJRP6 1283 Federal Home Loan Bank 06/30/2020 300,000.00 297,165.00 300,000.00 0.680 1,826 1,460 0.680 06/30/2025 3130AKFA9 1298 Federal Home Loan Bank 12/07/2020 500,000.00 491,465.00 497,400.00 0.375 1,831 1,625 0.480 12/12/2025 3130AKMZ6 1302 Federal Home Loan Bank 01/14/2021 500,000.00 492,095.00 500,000.00 0.510 1,826 1,658 0.510 01/14/2026 3130AKN28 1304 Federal Home Loan Bank 01/29/2021 500,000.00 493,750.00 500,000.00 0.550 1,826 1,673 0.550 01/29/2026 3130ALV92 1312 Federal Home Loan Bank 03/30/2021 500,000.00 499,570.00 500,000.00 0.500 1,826 1,733 0.938 03/30/2026 3130AMFS6 1324 Federal Home Loan Bank 06/17/2021 1,000,000.00 994,800.00 993,420.00 0.750 1,821 1,807 0.885 06/12/2026 3134GVYG7 1279 Federal Home Loan Mtg Corp 05/27/2020 1,000,000.00 996,450.00 1,000,000.00 0.625 1,826 1,426 0.625 05/27/2025 3137EAEU9 1297 Federal Home Loan Mtg Corp 12/07/2020 1,000,000.00 986,300.00 997,300.00 0.375 1,687 1,481 0.434 07/21/2025 3134GXGZ1 1301 Federal Home Loan Mtg Corp 12/30/2020 500,000.00 493,074.50 500,000.00 0.550 1,826 1,643 0.550 12/30/2025 3137EAEX3 1307 Federal Home Loan Mtg Corp 02/23/2021 500,000.00 492,370.00 495,999.50 0.375 1,673 1,545 0.552 09/23/2025 3137EAEX3 1310 Federal Home Loan Mtg Corp 03/30/2021 1,000,000.00 984,740.00 983,940.00 0.375 1,638 1,545 0.740 09/23/2025 3135G0V75 1206 Federal National Mtg Assn 07/15/2019 500,000.00 519,860.00 495,950.00 1.750 1,814 1,097 1.922 07/02/2024 3135G0W33 1233 Federal National Mtg Assn 10/29/2019 1,000,000.00 1,014,380.00 992,100.00 1.375 1,043 432 1.659 09/06/2022 3135G05S8 1288 Federal National Mtg Assn 08/14/2020 500,000.00 495,120.00 500,000.00 0.500 1,826 1,505 0.500 08/14/2025 3136G4N74 1289 Federal National Mtg Assn 08/21/2020 1,000,000.00 992,970.00 1,000,000.00 0.560 1,826 1,512 0.560 08/21/2025 3136G4M75 1290 Federal National Mtg Assn 08/28/2020 500,000.00 495,625.00 499,750.00 0.520 1,816 1,509 0.530 08/18/2025 3135G06E8 1291 Federal National Mtg Assn 11/18/2020 500,000.00 497,370.00 499,250.00 0.420 1,461 1,236 0.458 11/18/2024 3135GA2Z3 1292 Federal National Mtg Assn 11/17/2020 500,000.00 494,430.00 499,250.00 0.560 1,826 1,600 0.590 11/17/2025 3135GA7D7 1299 Federal National Mtg Assn 12/23/2020 500,000.00 494,690.00 500,000.00 0.600 1,826 1,636 0.600 12/23/2025 3135GAAW1 1300 Federal National Mtg Assn 12/30/2020 500,000.00 497,125.00 500,000.00 0.400 1,461 1,278 0.400 12/30/2024 Subtotal and Average 21,453,127.86 22,050,000.00 22,183,649.50 21,982,951.86 1,637 1,209 1.089 Treasury Coupon Securities 912828T67 1070 U.S. Treasury 03/27/2017 2,000,000.00 2,007,920.00 1,942,800.00 1.250 1,679 122 1.903 10/31/2021 9128282W9 1178 U.S. Treasury 03/01/2019 500,000.00 510,800.00 489,687.50 1.875 1,309 456 2.480 09/30/2022 912828SV3 1192 U.S. Treasury 05/31/2019 500,000.00 507,225.00 496,650.00 1.750 1,080 318 1.984 05/15/2022 912828T26 1217 U.S. Treasury 08/21/2019 500,000.00 512,050.00 499,300.00 1.375 1,501 821 1.410 09/30/2023 912828YV6 1241 U.S. Treasury 12/16/2019 1,000,000.00 1,031,950.00 989,687.50 1.500 1,811 1,248 1.718 11/30/2024 91282CBC4 1303 U.S. Treasury 01/07/2021 500,000.00 490,725.00 498,632.81 0.375 1,819 1,644 0.431 12/31/2025 91282CBH3 1309 U.S. Treasury 02/23/2021 500,000.00 490,175.00 495,100.00 0.375 1,803 1,675 0.577 01/31/2026 91282CAT8 1311 U.S. Treasury 03/30/2021 1,000,000.00 978,090.00 977,500.00 0.250 1,676 1,583 0.750 10/31/2025 91282CAZ4 1315 U.S. Treasury 04/22/2021 500,000.00 491,190.00 492,187.50 0.375 1,683 1,613 0.720 11/30/2025 Run Date: 09/10/2021 - 20:07 Portfolio CITY CP PM (PRF_PM2) 7.3.0 CUSIP Investment # Issuer City of La Quinta Portfolio Management Portfolio Details - Investments June 30, 2021 Page 3 Average Purchase Stated Days to YTM Maturity Balance Date Par Value Market Value Book Value Rate Term Maturity 365 Date Treasury Coupon Securities 91282CBQ3 1319 U.S. Treasury 05/28/2021 500,000.00 492,635.00 494,165.00 0.500 1,737 1,703 0.750 02/28/2026 91282CBT7 1320 U.S. Treasury 05/28/2021 500,000.00 497,990.00 499,525.00 0.750 1,768 1,734 0.770 03/31/2026 91282CCF6 1321 U.S. Treasury 06/01/2021 1,000,000.00 994,770.00 997,060.00 0.750 1,825 1,795 0.810 05/31/2026 91282CBT7 1322 U.S. Treasury 06/17/2021 500,000.00 497,990.00 498,450.00 0.750 1,748 1,734 0.816 03/31/2026 91282CCF6 1323 U.S. Treasury 06/17/2021 500,000.00 497,385.00 497,095.00 0.750 1,809 1,795 0.870 05/31/2026 Subtotal and Average 14,170,216.31 10,000,000.00 10,000,895.00 9,867,840.31 1,680 1,166 1.246 Certificate of Deposits 336460CX6 1222 First State Bk DeQueen 08/30/2019 248,000.00 257,478.57 248,000.00 1.800 1,827 1,156 1.802 08/30/2024 32027BAL1 1273 First Freedom Bank 04/29/2020 249,000.00 253,540.41 249,000.00 1.200 1,826 1,398 1.201 04/29/2025 33766LAJ7 1216 FirsTierBank 08/23/2019 249,000.00 259,786.17 249,000.00 1.950 1,827 1,149 1.952 08/23/2024 32056GDJ6 1278 1st Internet Bank 05/11/2020 248,000.00 250,472.64 248,000.00 1.000 1,827 1,411 0.985 05/12/2025 32112UDR9 1274 First Natl Bk McGregor 04/28/2020 248,000.00 253,943.03 248,000.00 1.350 1,826 1,397 1.351 04/28/2025 32110YLK9 1147 First National Bank of America 07/20/2018 245,000.00 259,363.34 245,000.00 3.150 1,826 749 3.152 07/20/2023 32117BCX4 1179 First National Bank 03/05/2019 248,000.00 259,512.12 248,000.00 2.800 1,522 673 2.802 05/05/2023 334342CD2 1221 First Natl Bk of Syracuse 08/30/2019 249,000.00 258,913.00 249,000.00 1.850 1,827 1,156 1.852 08/30/2024 32114VBT3 1250 First National Bank Michigan 02/14/2020 248,000.00 256,668.15 248,000.00 1.650 1,827 1,324 1.652 02/14/2025 33625CCP2 1209 First Security Bank of WA 07/30/2019 248,000.00 258,904.96 248,000.00 2.000 1,827 1,125 2.002 07/30/2024 33640VDD7 1231 First Service Bank 11/15/2019 248,000.00 256,439.84 248,000.00 1.700 1,643 1,049 1.701 05/15/2024 33646CKP8 1168 First Source Bank 12/17/2018 245,000.00 247,885.13 245,000.00 3.150 1,066 139 3.153 11/17/2021 88413QBY3 1112 Third Federal Savings and Loan 01/30/2018 245,000.00 248,410.28 245,000.00 2.500 1,462 214 2.502 01/31/2022 00257TBD7 1207 Abacus Federal Savings 07/26/2019 248,000.00 258,624.56 248,000.00 1.950 1,827 1,121 1.952 07/26/2024 00435JBH5 1256 Access Bank 03/13/2020 248,000.00 256,214.65 248,000.00 1.600 1,826 1,351 1.601 03/13/2025 01748DBE5 1143 Allegiance Bank 06/13/2018 245,000.00 251,799.90 245,000.00 3.100 1,461 347 3.102 06/13/2022 01859BAA3 1095 Alliance Credit Union 10/13/2017 245,000.00 251,330.26 245,000.00 2.250 1,826 469 2.251 10/13/2022 020080BX4 1267 Alma Bank 03/30/2020 248,000.00 254,446.74 248,000.00 1.400 1,824 1,366 1.399 03/28/2025 03065AAL7 1200 America's Credit Union 06/28/2019 248,000.00 253,185.03 248,000.00 2.300 1,096 362 2.302 06/28/2022 029728BC5 1255 American State 02/21/2020 248,000.00 256,260.49 248,000.00 1.600 1,827 1,331 1.602 02/21/2025 02587CFU9 1096 American Express Fed Savings B 08/29/2017 240,000.00 246,069.75 240,000.00 2.400 1,826 424 2.402 08/29/2022 02616AAH2 1285 American First CU 06/26/2020 248,000.00 248,149.53 248,000.00 0.350 1,095 725 0.350 06/26/2023 02772JBD1 1205 American National Bank 07/19/2019 248,000.00 256,607.05 248,000.00 2.000 1,461 748 2.001 07/19/2023 034577AH9 1119 Aneca Federal Credit Union 03/22/2018 245,000.00 255,681.83 245,000.00 2.800 1,826 629 2.802 03/22/2023 05465DAE8 1258 Axos Bank 03/26/2020 248,000.00 256,756.39 248,000.00 1.650 1,826 1,364 1.651 03/26/2025 06740KLJ4 1097 Barclays Bank 10/25/2017 240,000.00 246,519.42 240,000.00 2.300 1,826 481 2.291 10/25/2022 066851WJ1 1172 Bar Harbor Bank and Trust 12/31/2018 248,000.00 266,274.95 248,000.00 3.350 1,824 911 3.352 12/29/2023 08016PDQ9 1270 Belmont Bank and Trust 04/16/2020 248,000.00 253,208.59 248,000.00 1.250 1,461 1,020 1.251 04/16/2024 Run Date: 09/10/2021 - 20:07 Portfolio CITY CP PM (PRF_PM2) 7.3.0 CUSIP City of La Quinta Portfolio Management Portfolio Details - Investments June 30, 2021 Page 4 Average Purchase Stated Days to YTM Maturity Investment # Issuer Balance Date Par Value Market Value Book Value Rate Term Maturity 365 Date Certificate of Deposits 07833EAD9 1264 BelIco Credit Union 03/31/2020 248,000.00 250,104.75 248,000.00 1.300 729 272 1.300 03/30/2022 080515CD9 1102 Belmont Savings Bank 11/21/2017 245,000.00 246,953.30 245,000.00 2.100 1,462 144 2.101 11/22/2021 064520BG3 1287 Bank Princeton 06/30/2020 248,000.00 246,511.57 248,000.00 0.500 1,644 1,278 0.500 12/30/2024 05580AGK4 1067 BMW Bank 02/24/2017 240,000.00 243,258.40 240,000.00 2.200 1,826 238 2.201 02/24/2022 06652CHB0 1227 BankWest Inc 09/27/2019 248,000.00 256,897.56 248,000.00 1.700 1,827 1,184 1.702 09/27/2024 12738RFX7 1259 Cadence Bank, NA 03/31/2020 245,000.00 246,858.39 245,000.00 1.200 730 273 1.200 03/31/2022 14042TDD6 1271 Capital One USA FDIC33954 04/08/2020 245,000.00 253,086.42 245,000.00 1.600 1,826 1,377 1.601 04/08/2025 14622LAA0 1316 Carter FCU 04/27/2021 248,000.00 246,183.96 248,000.00 0.750 1,826 1,761 0.750 04/27/2026 15118RRH2 1220 Celtic Bank 08/30/2019 248,000.00 257,873.19 248,000.00 1.850 1,827 1,156 1.852 08/30/2024 156634AK3 1184 Century Next Bank 05/29/2019 248,000.00 262,368.90 248,000.00 2.500 1,827 1,063 2.503 05/29/2024 169894AS1 1284 Chippewa Valley Bk 06/24/2020 248,000.00 246,421.13 248,000.00 0.600 1,826 1,454 0.600 06/24/2025 17286TAG0 1252 Citadel FCU 02/27/2020 248,000.00 256,752.14 248,000.00 1.650 1,827 1,337 1.652 02/27/2025 12556LBA3 1219 CIT Bank NA 08/23/2019 245,000.00 249,686.21 245,000.00 1.900 1,096 418 1.902 08/23/2022 17312QJ26 1123 Citibank NA 04/11/2018 245,000.00 256,433.60 245,000.00 2.900 1,826 649 2.902 04/11/2023 2027506M2 1268 Commonwealth Business Bk 03/31/2020 248,000.00 252,725.87 248,000.00 1.250 1,826 1,369 1.251 03/31/2025 15523RBJ4 1085 Central State Bank 07/14/2017 240,000.00 240,166.12 240,000.00 1.850 1,461 13 1.851 07/14/2021 20143PDV9 1162 Commercial Bank 11/15/2018 248,000.00 265,818.54 248,000.00 3.400 1,826 867 3.402 11/15/2023 20416TAQ5 1202 Communitywide FCU 06/28/2019 248,000.00 260,748.56 248,000.00 2.250 1,827 1,093 2.253 06/28/2024 20726ABA5 1189 Congressional Bank 04/30/2019 248,000.00 258,051.36 248,000.00 2.500 1,459 666 2.502 04/28/2023 22766ACB9 1106 CrossFirst Bank 11/20/2017 245,000.00 251,622.35 245,000.00 2.200 1,824 505 2.201 11/18/2022 176688CP2 1199 Citizens State Bank 06/21/2019 248,000.00 261,781.44 248,000.00 2.400 1,827 1,086 2.403 06/21/2024 2546722U1 1066 Discover Bank Greenwood DE CF 02/01/2017 240,000.00 243,016.96 240,000.00 2.250 1,826 215 2.251 02/01/2022 29278TAY6 1125 EnerBank USA 04/30/2018 240,000.00 251,722.20 240,000.00 2.950 1,824 666 2.952 04/28/2023 29367QCP1 1107 Enterprise Bank, NA 11/28/2017 245,000.00 251,577.76 245,000.00 2.150 1,826 515 2.151 11/28/2022 299547AQ2 1196 Evansville Teachers Credit FCU 06/12/2019 248,000.00 263,141.13 248,000.00 2.600 1,827 1,077 2.603 06/12/2024 87270LDL4 1306 TIAA FKA EverBank 02/12/2021 245,000.00 240,787.75 245,000.00 0.500 1,826 1,687 0.500 02/12/2026 30960QAG2 1126 Farmers Insurance Group FCU 04/30/2018 240,000.00 245,287.99 240,000.00 2.800 1,460 302 2.802 04/29/2022 31617CAV5 1317 Fidelity Homestead 04/30/2021 248,000.00 245,420.93 248,000.00 0.700 1,826 1,764 0.711 04/30/2026 33847E3A3 1276 Flagstar 04/30/2020 248,000.00 252,819.36 248,000.00 1.250 1,826 1,399 1.251 04/30/2025 35637RDC8 1248 Freedom Financial 02/14/2020 248,000.00 255,767.09 248,000.00 1.550 1,827 1,324 1.552 02/14/2025 369674AV8 1150 General Electric Credit Union 08/15/2018 240,000.00 240,949.32 240,000.00 3.100 1,097 46 3.100 08/16/2021 38148PJK4 1078 Goldman Sachs 04/26/2017 240,000.00 244,434.32 240,000.00 2.400 1,826 299 2.401 04/26/2022 39573LBC1 1313 Greenstate FCU 04/16/2021 249,000.00 249,556.66 249,000.00 0.950 1,826 1,750 0.951 04/16/2026 46256YAZ2 1186 Iowa State Bank 05/23/2019 245,000.00 258,385.79 245,000.00 2.400 1,827 1,057 2.403 05/23/2024 474067AQ8 1154 Jefferson Financial CU 10/19/2018 245,000.00 261,870.58 245,000.00 3.350 1,826 840 3.352 10/19/2023 48128HXU7 1185 JP Morgan Chase 05/16/2019 245,000.00 264,336.56 245,000.00 3.250 1,827 1,050 3.254 05/16/2024 Run Date: 09/10/2021 - 20:07 Portfolio CITY CP PM (PRF PM2) 7.3.0 CUSIP City of La Quinta Portfolio Management Portfolio Details - Investments June 30, 2021 Page 5 Average Purchase Stated Days to YTM Maturity Investment # Issuer Balance Date Par Value Market Value Book Value Rate Term Maturity 365 Date Certificate of Deposits 50116CBE8 1101 Kansas State Bank 11/17/2017 245,000.00 249,142.24 245,000.00 2.100 1,642 320 2.099 05/17/2022 49228XAK6 1239 Kern FCU 12/30/2019 248,000.00 254,079.05 248,000.00 1.900 1,096 547 1.902 12/30/2022 499724AB8 1110 Knoxville TVA Credit Union 12/29/2017 245,000.00 252,874.30 245,000.00 2.400 1,826 546 2.401 12/29/2022 524661CB9 1197 Legacy Bank 06/19/2019 248,000.00 261,756.29 248,000.00 2.400 1,827 1,084 2.403 06/19/2024 538036GV0 1238 Live Oak Bank 11/27/2019 248,000.00 257,270.04 248,000.00 1.800 1,644 1,062 1.802 05/28/2024 51210SQU4 1208 Lakeside Bank 07/30/2019 248,000.00 258,041.10 248,000.00 2.000 1,644 942 2.003 01/29/2024 51507LCC6 1305 Landmark Community Bank 01/22/2021 248,000.00 243,937.34 248,000.00 0.500 1,826 1,666 0.500 01/22/2026 549104JN8 1225 Luana Savings Bank 09/18/2019 245,000.00 247,542.52 245,000.00 1.600 912 260 1.599 03/18/2022 560507AK1 1171 Maine Savings FCU 12/28/2018 248,000.00 253,265.02 248,000.00 3.300 1,158 242 3.306 02/28/2022 56065GAG3 1188 Main Street Bank 04/26/2019 248,000.00 262,776.66 248,000.00 2.600 1,827 1,030 2.603 04/26/2024 57116ARV2 1155 Marlin Business Bank 10/17/2018 248,000.00 264,763.99 248,000.00 3.300 1,826 838 3.302 10/17/2023 58404DCX7 1169 Medallion Bank 12/07/2018 248,000.00 259,259.65 248,000.00 3.400 1,461 524 3.402 12/07/2022 61690UNX4 1237 Morgan Stanley Bank 11/20/2019 245,000.00 255,949.53 245,000.00 1.950 1,827 1,238 1.952 11/20/2024 619165JD6 1173 Morton Community 03/20/2019 248,000.00 260,012.67 248,000.00 2.750 1,553 719 2.753 06/20/2023 59013J4K2 1163 Merrick Bank 10/30/2018 248,000.00 257,950.91 248,000.00 3.250 1,459 484 3.252 10/28/2022 61760A3B3 1236 Morgan Stanley Private Bk, NA 11/20/2019 245,000.00 255,533.18 245,000.00 1.900 1,827 1,238 1.902 11/20/2024 62384RAC0 1099 Mountain America Federal CU 11/08/2017 245,000.00 251,828.60 245,000.00 2.300 1,826 495 2.301 11/08/2022 625925AR3 1160 Municipal Trust and Savings 10/17/2018 245,000.00 260,992.87 245,000.00 3.200 1,826 838 3.202 10/17/2023 654062JZ2 1266 Nicolet Natl Bank 03/31/2020 248,000.00 254,121.30 248,000.00 1.400 1,826 1,369 1.401 03/31/2025 64017AAQ7 1167 Neighbors FCU 12/21/2018 245,000.00 248,632.98 245,000.00 3.200 1,096 173 3.203 12/21/2021 635573AL2 1170 National Cooperative Bank, N.A 12/21/2018 245,000.00 263,185.81 245,000.00 3.400 1,826 903 3.402 12/21/2023 67054NAN3 1164 Numerica Credit Union 11/28/2018 248,000.00 266,989.83 248,000.00 3.550 1,826 880 3.552 11/28/2023 666613GV0 1127 Northpointe Bank 04/26/2018 240,000.00 242,044.91 240,000.00 2.700 1,279 117 2.703 10/26/2021 66704MEQ0 1263 Northstar Bank 03/31/2020 248,000.00 251,673.77 248,000.00 1.150 1,095 638 1.150 03/31/2023 66736ABP3 1181 Northwest Bank 02/13/2019 248,000.00 264,295.62 248,000.00 2.950 1,826 957 2.951 02/13/2024 06426KAN8 1151 Bank of New England 07/31/2018 249,000.00 264,119.27 249,000.00 3.250 1,826 760 3.252 07/31/2023 649447TC3 1226 New York Community Bank 09/27/2019 245,000.00 246,035.25 245,000.00 1.800 731 88 1.802 09/27/2021 677721CN0 1089 The Ohio Valley Bank 07/19/2017 240,000.00 242,380.78 240,000.00 1.900 1,645 202 1.903 01/19/2022 69506YRH4 1269 Pacific Western Bank 04/16/2020 245,000.00 250,483.98 245,000.00 1.300 1,461 1,020 1.301 04/16/2024 69324MAD7 1149 PCSB Bank 06/08/2018 245,000.00 251,472.50 245,000.00 3.000 1,461 342 3.002 06/08/2022 710571DS6 1210 People's Bank 07/31/2019 248,000.00 258,773.00 248,000.00 2.000 1,827 1,126 2.002 07/31/2024 725404AB3 1194 Pittsfield Cooperative Bank 06/07/2019 245,000.00 255,447.48 245,000.00 2.500 1,461 706 2.502 06/07/2023 72651LCL6 1195 Plains Commerce Bank 06/07/2019 245,000.00 259,509.97 245,000.00 2.550 1,827 1,072 2.553 06/07/2024 740367HP5 1213 Preferred Bank 08/16/2019 249,000.00 260,112.68 249,000.00 2.000 1,827 1,142 2.002 08/16/2024 75472RAD3 1218 Raymond James Bank 08/23/2019 244,000.00 252,483.35 244,000.00 1.950 1,461 783 1.951 08/23/2023 74934YAH4 1144 RCB Bank 06/20/2018 245,000.00 258,820.83 245,000.00 3.150 1,826 719 3.152 06/20/2023 Run Date: 09/10/2021 - 20:07 Portfolio CITY CP PM (PRF PM2) 7.3.0 CUSIP City of La Quinta Portfolio Management Portfolio Details - Investments June 30, 2021 Page 6 Average Purchase Stated Days to YTM Maturity Investment # Issuer Balance Date Par Value Market Value Book Value Rate Term Maturity 365 Date Certificate of Deposits 75701LAB3 1166 Red Rocks Credit Union 12/07/2018 248,000.00 259,079.20 248,000.00 3.350 1,461 524 3.352 12/07/2022 761402BY1 1203 Revere Bank 06/28/2019 247,000.00 260,054.37 247,000.00 2.300 1,827 1,093 2.303 06/28/2024 77579ADF0 1251 Rollstone B&T 02/12/2020 245,000.00 252,660.76 245,000.00 1.650 1,461 956 1.651 02/12/2024 795450A70 1083 Sallie Mae Bank Salt Lake City 06/21/2017 240,000.00 245,037.18 240,000.00 2.350 1,826 355 2.351 06/21/2022 804375DL4 1235 Sauk Valley B&T Co 11/07/2019 248,000.00 256,895.80 248,000.00 1.700 1,827 1,225 1.702 11/07/2024 81768PAF3 1254 Servisfirst Bank 02/21/2020 248,000.00 253,397.38 248,000.00 1.600 1,096 600 1.601 02/21/2023 79772FAC0 1240 San Francisco FCU 12/30/2019 248,000.00 253,890.73 248,000.00 1.850 1,096 547 1.852 12/30/2022 06424KBC3 1261 Bank of Santa Clarita 03/31/2020 248,000.00 249,693.58 248,000.00 1.100 730 273 1.100 03/31/2022 849430BF9 1257 Spring Bank 03/20/2020 248,000.00 255,333.05 248,000.00 1.500 1,826 1,358 1.501 03/20/2025 84223QAN7 1286 Southern Bancorp Bk 06/26/2020 248,000.00 247,032.66 248,000.00 0.500 1,582 1,212 0.500 10/25/2024 85916VDC6 1201 Sterling Bank 06/28/2019 245,000.00 250,474.70 245,000.00 2.150 1,158 424 2.153 08/29/2022 87164XQV1 1080 Synchrony Bank Retail 06/02/2017 240,000.00 244,880.62 240,000.00 2.400 1,826 336 2.401 06/02/2022 87164DRD4 1253 Synovus Bank 03/09/2020 245,000.00 248,215.97 245,000.00 1.600 822 343 1.602 06/09/2022 882213AB7 1260 Texas Bank Financial 03/31/2020 245,000.00 249,166.75 245,000.00 1.100 1,458 1,001 1.101 03/28/2024 472382AQ3 1272 The Jefferson Bank 04/15/2020 248,000.00 253,203.52 248,000.00 1.250 1,461 1,019 1.251 04/15/2024 89235MKY6 1314 Toyota Financial Savings Bank 04/22/2021 245,000.00 244,963.78 245,000.00 0.900 1,826 1,756 0.900 04/22/2026 89269CBX9 1148 Traditions Bank 06/08/2018 245,000.00 252,541.19 245,000.00 3.000 1,522 403 3.002 08/08/2022 89579NCD3 1262 Triad Bank 03/30/2020 248,000.00 253,541.27 248,000.00 1.350 1,278 820 1.352 09/29/2023 87266AAA1 1187 TNB Bank 05/22/2019 248,000.00 250,276.80 248,000.00 2.400 915 144 2.407 11/22/2021 90348JEJ5 1161 UBS Bank USA 10/17/2018 245,000.00 261,845.36 245,000.00 3.350 1,826 838 3.352 10/17/2023 90983WBT7 1249 United Community 02/07/2020 248,000.00 256,622.94 248,000.00 1.650 1,827 1,317 1.652 02/07/2025 910160AH3 1214 United Credit Union 08/22/2019 248,000.00 250,253.55 248,000.00 2.000 853 174 2.003 12/22/2021 91435LAG2 1134 University of Iowa Comm. CU 05/14/2018 240,000.00 252,442.02 240,000.00 3.050 1,827 683 3.052 05/15/2023 92535LCD4 1180 Verus Bank of Commerce 02/28/2019 248,000.00 258,055.44 248,000.00 2.700 1,461 607 2.700 02/28/2023 949763XY7 1174 Wells Fargo 02/27/2019 248,000.00 264,864.93 248,000.00 3.000 1,826 971 3.001 02/27/2024 954444BS3 1265 West Michigan Cmnty Bk 03/31/2020 248,000.00 251,673.77 248,000.00 1.150 1,095 638 1.150 03/31/2023 949495AT2 1244 Wells Fargo Natl Bank West 01/29/2020 248,000.00 254,393.92 248,000.00 1.900 1,097 578 1.900 01/30/2023 938828BH2 1215 Washington Federal 08/23/2019 248,000.00 259,135.22 248,000.00 2.000 1,827 1,149 2.002 08/23/2024 95960NKD8 1277 Western State Bank 05/13/2020 245,000.00 247,439.89 245,000.00 1.000 1,826 1,412 1.001 05/13/2025 Subtotal and Average 31,809,000.00 31,761,000.00 32,746,450.56 31,761,000.00 1,605 837 2.088 Corporate Notes 037833CC2 1079 Apple Inc 06/12/2017 500,000.00 500,040.00 493,050.00 1.550 1,514 34 1.900 08/04/2021 19416QEA4 1175 Colgate-Palmolive 03/04/2019 500,000.00 513,570.00 485,250.00 1.950 1,430 580 2.751 02/01/2023 45950VPS9 1308 International Finance Corp. 02/26/2021 500,000.00 493,505.00 497,300.00 0.500 1,826 1,701 0.610 02/26/2026 59491813Q6 1157 Microsoft Corporation 10/15/2018 400,000.00 412,944.00 378,360.00 2.000 1,758 768 3.222 08/08/2023 Portfolio CITY CP Run Date: 09/10/2021 - 20:07 PM (PRF_PM2) 7.3.0 CUSIP Corporate Notes 742718DY2 931142DU4 Investment # Issuer City of La Quinta Portfolio Management Portfolio Details - Investments June 30, 2021 Page 7 Average Purchase Stated Days to YTM Maturity Balance Date Par Value Market Value Book Value Rate Term Maturity 365 Date 1159 1190 Proctor and Gamble Wal-Mart Stores, Inc Subtotal and Average 2,838,560.00 10/15/2018 500,000.00 506,385.00 487,950.00 2.300 1,210 220 3.071 02/06/2022 04/16/2019 500,000.00 514,540.00 496,650.00 2.350 1,339 532 2.799 12/15/2022 2,900,000.00 2,940,984.00 2,838,560.00 1,504 636 2.354 Money Market with Fiscal Agent SYS1058 1058 US Bank Subtotal and Average 07/01/2016 1,422.16 1,422.16 1,422.16 1 1 0.000 1,422.15 1,422.16 1,422.16 1,422.16 1 1 0.000 CERBT - OPEB Trust SYS1114 1114 CaIPERS CERBT Plan Subtotal and Average 1,938,121.69 07/01/2020 2,050,951.37 2,050,951.37 2,050,951.37 1 1 0.000 2,050,951.37 2,050,951.37 2,050,951.37 1 1 0.000 PARS Pension Trust SYS1230 1230 Pblc Agncy Rtrmnt Sery 07/01/2020 11,381,922.40 11,381,922.40 11,381,922.40 1 1 0.000 Subtotal and Average 11,280,597.19 11,381,922.40 11,381,922.40 11,381,922.40 1 1 0.000 Total and Average 178,303,057.79 Run Date: 09/10/2021 - 20:07 187,171,960.31 188,751,570.58 186,911,312.48 577 356 0.697 Portfolio CITY CP PM (PRF PM2) 7.3.0 GEM of the DESERT - City of La Quinta Total Earnings Sorted by Fund - Fund June 1, 2021 - June 30, 2021 City of La Quinta Adjusted Interest Earnings Ending Beginning Ending Current Annualized Interest Amortization/ Realized Adjusted Interest CUSIP Investment # Fund Issuer Par Value Book Value Book Value Rate Yield Earned Accretion Gainl/Loss Earnings Fund: General Fund 912828S27 1045 101 USTR 0.00 5,000,000.00 0.00 1.125 1.134 4,506.22 0.00 0.00 4,506.22 98-33-434 1055 101 LAIF 66,929,948.66 58,929,948.66 66,929,948.66 0.262 0.353 17,104.29 0.00 0.00 17,104.29 4159282482 1057 101 WELLS 0.00 0.00 0.00 0.01 0.00 0.00 0.01 SYS1059 1059 101 CITYPC 3,300.00 3,300.00 3,300.00 0.00 0.00 0.00 0.00 2546722U1 1066 101 DISCOV 240,000.00 240,000.00 240,000.00 2.250 2.250 443.84 0.00 0.00 443.84 05580AGK4 1067 101 BMW 240,000.00 240,000.00 240,000.00 2.200 2.200 433.97 0.00 0.00 433.97 912828T67 1070 101 USTR 2,000,000.00 1,942,800.00 1,942,800.00 1.250 1.276 2,038.05 0.00 0.00 2,038.05 38148PJK4 1078 101 GLDMAN 240,000.00 240,000.00 240,000.00 2.400 2.400 473.42 0.00 0.00 473.42 037833CC2 1079 101 APPL 500,000.00 493,050.00 493,050.00 1.550 1.594 645.83 0.00 0.00 645.83 87164XQV1 1080 101 SYNCHR 240,000.00 240,000.00 240,000.00 2.400 2.400 473.42 0.00 0.00 473.42 14042RGD7 1082 101 CAP1NA 0.00 240,000.00 0.00 2.250 2.250 88.77 0.00 0.00 88.77 795450A70 1083 101 SALMAE 240,000.00 240,000.00 240,000.00 2.350 2.350 463.56 0.00 0.00 463.56 15523RBJ4 1085 101 CNTRL 240,000.00 240,000.00 240,000.00 1.850 1.850 364.93 0.00 0.00 364.93 677721CN0 1089 101 OHVAL 240,000.00 240,000.00 240,000.00 1.900 1.900 374.79 0.00 0.00 374.79 01859BAA3 1095 101 ALLIAN 245,000.00 245,000.00 245,000.00 2.250 2.250 453.09 0.00 0.00 453.09 02587CFU9 1096 101 AMFSB 240,000.00 240,000.00 240,000.00 2.400 2.400 473.42 0.00 0.00 473.42 06740KLJ4 1097 101 BARCLY 240,000.00 240,000.00 240,000.00 2.300 2.300 453.70 0.00 0.00 453.70 62384RAC0 1099 101 MTNAMR 245,000.00 245,000.00 245,000.00 2.300 2.300 463.15 0.00 0.00 463.15 50116CBE8 1101 101 KANSAS 245,000.00 245,000.00 245,000.00 2.100 2.100 422.88 0.00 0.00 422.88 080515CD9 1102 101 BELMNT 245,000.00 245,000.00 245,000.00 2.100 2.100 422.87 0.00 0.00 422.87 3133EHWM1 1105 101 FFCB 1,000,000.00 992,200.00 992,200.00 1.700 1.737 1,416.67 0.00 0.00 1,416.67 22766ACB9 1106 101 CRS1ST 245,000.00 245,000.00 245,000.00 2.200 2.200 443.01 0.00 0.00 443.01 29367QCP1 1107 101 ENTRPR 245,000.00 245,000.00 245,000.00 2.150 2.150 432.95 0.00 0.00 432.95 499724AB8 1110 101 KNOX 245,000.00 245,000.00 245,000.00 2.400 2.400 483.29 0.00 0.00 483.29 88413QBY3 1112 101 3RD 245,000.00 245,000.00 245,000.00 2.500 2.500 503.43 0.00 0.00 503.43 SYS1114 1114 101 CALPRS 2,050,951.37 1,934,231.01 2,050,951.37 0.00 0.00 0.00 0.00 034577AH9 1119 101 ANECA 245,000.00 245,000.00 245,000.00 2.800 2.800 563.84 0.00 0.00 563.84 17312QJ26 1123 101 CITINA 245,000.00 245,000.00 245,000.00 2.900 2.900 583.97 0.00 0.00 583.97 29278TAY6 1125 101 ENER 240,000.00 240,000.00 240,000.00 2.950 2.950 581.92 0.00 0.00 581.92 30960QAG2 1126 101 FARMIG 240,000.00 240,000.00 240,000.00 2.800 2.800 552.33 0.00 0.00 552.33 Run Date: 09/10/2021 - 20:23 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 City of La Quinta Total Earnings June 1, 2021 - June 30, 2021 Page 2 Adjusted Interest Earnings Ending Beginning Ending Current Annualized Interest Amortization/ Realized Adjusted Interest CUSIP Investment # Fund Issuer Par Value Book Value Book Value Rate Yield Earned Accretion Gainl/Loss Earnings Fund: General Fund 666613GV0 1127 101 NORPNT 240,000.00 240,000.00 240,000.00 2.700 2.700 532.60 0.00 0.00 532.60 91435LAG2 1134 101 UOFICU 240,000.00 240,000.00 240,000.00 3.050 3.050 601.64 0.00 0.00 601.64 01748DBE5 1143 101 ALLGNC 245,000.00 245,000.00 245,000.00 3.100 3.100 624.25 0.00 0.00 624.25 74934YAH4 1144 101 RCB 245,000.00 245,000.00 245,000.00 3.150 3.150 634.32 0.00 0.00 634.32 32110YLK9 1147 101 1STNBA 245,000.00 245,000.00 245,000.00 3.150 3.150 634.32 0.00 0.00 634.32 89269CBX9 1148 101 TRAD 245,000.00 245,000.00 245,000.00 3.000 3.000 604.11 0.00 0.00 604.11 69324MAD7 1149 101 PCSB 245,000.00 245,000.00 245,000.00 3.000 3.000 604.11 0.00 0.00 604.11 369674AV8 1150 101 GECRUN 240,000.00 240,000.00 240,000.00 3.100 3.100 611.51 0.00 0.00 611.51 06426KAN8 1151 101 NWENGL 249,000.00 249,000.00 249,000.00 3.250 3.250 665.14 0.00 0.00 665.14 SYS1153 1153 101 CAMP 13,854,440.98 854,136.10 13,854,440.98 0.050 0.434 304.88 0.00 0.00 304.88 474067AQ8 1154 101 JEFF 245,000.00 245,000.00 245,000.00 3.350 3.350 674.59 0.00 0.00 674.59 57116ARV2 1155 101 MARBUS 248,000.00 248,000.00 248,000.00 3.300 3.300 672.66 0.00 0.00 672.66 59491813Q6 1157 101 MCRSFT 400,000.00 378,360.00 378,360.00 2.000 2.144 666.67 0.00 0.00 666.67 3133EJYL7 1158 101 FFCB 250,000.00 247,275.00 247,275.00 2.800 2.870 583.34 0.00 0.00 583.34 742718DY2 1159 101 P&G 500,000.00 487,950.00 487,950.00 2.300 2.390 958.33 0.00 0.00 958.33 625925AR3 1160 101 MUNTRS 245,000.00 245,000.00 245,000.00 3.200 3.200 644.38 0.00 0.00 644.38 90348JEJ5 1161 101 UBS 245,000.00 245,000.00 245,000.00 3.350 3.350 674.59 0.00 0.00 674.59 20143PDV9 1162 101 COMMBK 248,000.00 248,000.00 248,000.00 3.400 3.400 693.04 0.00 0.00 693.04 59013J4K2 1163 101 MRRCK 248,000.00 248,000.00 248,000.00 3.250 3.250 662.47 0.00 0.00 662.47 67054NAN3 1164 101 NMRCA 248,000.00 248,000.00 248,000.00 3.550 3.550 723.62 0.00 0.00 723.62 75701LAB3 1166 101 REDRCK 248,000.00 248,000.00 248,000.00 3.350 3.350 682.85 0.00 0.00 682.85 64017AAQ7 1167 101 NEIGH 245,000.00 245,000.00 245,000.00 3.200 3.200 644.38 0.00 0.00 644.38 33646CKP8 1168 101 1STSRC 245,000.00 245,000.00 245,000.00 3.150 3.150 634.31 0.00 0.00 634.31 58404DCX7 1169 101 MEDBA 248,000.00 248,000.00 248,000.00 3.400 3.400 693.04 0.00 0.00 693.04 635573AL2 1170 101 NLCOOP 245,000.00 245,000.00 245,000.00 3.400 3.400 684.66 0.00 0.00 684.66 560507AK1 1171 101 MAINE 248,000.00 248,000.00 248,000.00 3.300 3.300 672.65 0.00 0.00 672.65 066851WJ1 1172 101 BARHAR 248,000.00 248,000.00 248,000.00 3.350 3.350 682.85 0.00 0.00 682.85 619165JD6 1173 101 MORTN 248,000.00 248,000.00 248,000.00 2.750 2.750 560.55 0.00 0.00 560.55 949763XY7 1174 101 WELLS 248,000.00 248,000.00 248,000.00 3.000 3.000 611.51 0.00 0.00 611.51 19416QEA4 1175 101 COLGTE 500,000.00 485,250.00 485,250.00 1.950 2.037 812.50 0.00 0.00 812.50 3130AFW94 1177 101 FHLB 500,000.00 498,550.00 498,550.00 2.500 2.542 1,041.67 0.00 0.00 1,041.67 9128282W9 1178 101 USTR 500,000.00 489,687.50 489,687.50 1.875 1.909 768.45 0.00 0.00 768.45 32117BCX4 1179 101 1STNBK 248,000.00 248,000.00 248,000.00 2.800 2.800 570.74 0.00 0.00 570.74 92535LCD4 1180 101 VERUS 248,000.00 248,000.00 248,000.00 2.700 2.700 550.35 0.00 0.00 550.35 66736ABP3 1181 101 NRTHWS 248,000.00 248,000.00 248,000.00 2.950 2.950 601.32 0.00 0.00 601.32 156634AK3 1184 101 CENTNX 248,000.00 248,000.00 248,000.00 2.500 2.500 509.60 0.00 0.00 509.60 48128HXU7 1185 101 JPMORG 245,000.00 245,000.00 245,000.00 3.250 3.250 654.45 0.00 0.00 654.45 Run Date: 09/10/2021 - 20:23 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 City of La Quinta Total Earnings June 1, 2021 - June 30, 2021 Page 3 Adjusted Interest Earnings Ending Beginning Ending Current Annualized Interest Amortization/ Realized Adjusted Interest CUSIP Investment # Fund Issuer Par Value Book Value Book Value Rate Yield Earned Accretion Gainl/Loss Earnings Fund: General Fund 46256YAZ2 1186 101 IOWAST 245,000.00 245,000.00 245,000.00 2.400 2.400 483.28 0.00 0.00 483.28 87266AAA1 1187 101 TSCOLA 248,000.00 248,000.00 248,000.00 2.400 2.400 489.21 0.00 0.00 489.21 56065GAG3 1188 101 MAINST 248,000.00 248,000.00 248,000.00 2.600 2.600 529.97 0.00 0.00 529.97 20726ABA5 1189 101 CONGRS 248,000.00 248,000.00 248,000.00 2.500 2.500 509.59 0.00 0.00 509.59 931142DU4 1190 101 WALMRT 500,000.00 496,650.00 496,650.00 2.350 2.399 979.16 0.00 0.00 979.16 912828SV3 1192 101 USTR 500,000.00 496,650.00 496,650.00 1.750 1.747 713.32 0.00 0.00 713.32 725404AB3 1194 101 PITTS 245,000.00 245,000.00 245,000.00 2.500 2.500 503.42 0.00 0.00 503.42 72651LCL6 1195 101 PLAINS 245,000.00 245,000.00 245,000.00 2.550 2.550 513.49 0.00 0.00 513.49 299547AQ2 1196 101 EVNSCU 248,000.00 248,000.00 248,000.00 2.600 2.600 529.97 0.00 0.00 529.97 524661CB9 1197 101 LEGCY 248,000.00 248,000.00 248,000.00 2.400 2.400 489.21 0.00 0.00 489.21 3133EKQP4 1198 101 FFCB 500,000.00 499,500.00 499,500.00 1.875 1.903 781.25 0.00 0.00 781.25 176688CP2 1199 101 CTZNST 248,000.00 248,000.00 248,000.00 2.400 2.400 489.20 0.00 0.00 489.20 03065AAL7 1200 101 AMERCU 248,000.00 248,000.00 248,000.00 2.300 2.300 468.82 0.00 0.00 468.82 85916VDC6 1201 101 STRLNG 245,000.00 245,000.00 245,000.00 2.150 2.150 432.94 0.00 0.00 432.94 20416TAQ5 1202 101 COMMW 248,000.00 248,000.00 248,000.00 2.250 2.250 458.63 0.00 0.00 458.63 761402BY1 1203 101 REVER 247,000.00 247,000.00 247,000.00 2.300 2.300 466.93 0.00 0.00 466.93 02772JBD1 1205 101 AMRNTL 248,000.00 248,000.00 248,000.00 2.000 2.000 407.67 0.00 0.00 407.67 3135G0V75 1206 101 FNMA 500,000.00 495,950.00 495,950.00 1.750 1.789 729.16 0.00 0.00 729.16 00257TBD7 1207 101 ABACUS 248,000.00 248,000.00 248,000.00 1.950 1.950 397.48 0.00 0.00 397.48 51210SQU4 1208 101 LKSIDE 248,000.00 248,000.00 248,000.00 2.000 2.000 407.67 0.00 0.00 407.67 33625CCP2 1209 101 1STSEC 248,000.00 248,000.00 248,000.00 2.000 2.000 407.67 0.00 0.00 407.67 710571DS6 1210 101 PEOPLE 248,000.00 248,000.00 248,000.00 2.000 2.000 407.67 0.00 0.00 407.67 3133EKWV4 1212 101 FFCB 500,000.00 499,500.00 499,500.00 1.850 1.878 770.83 0.00 0.00 770.83 740367HP5 1213 101 PREFRD 249,000.00 249,000.00 249,000.00 2.000 2.000 409.32 0.00 0.00 409.32 910160AH3 1214 101 UNTDCU 248,000.00 248,000.00 248,000.00 2.000 2.000 407.67 0.00 0.00 407.67 938828BH2 1215 101 WSHFED 248,000.00 248,000.00 248,000.00 2.000 2.000 407.67 0.00 0.00 407.67 33766LAJ7 1216 101 1STIER 249,000.00 249,000.00 249,000.00 1.950 1.950 399.08 0.00 0.00 399.08 912828T26 1217 101 USTR 500,000.00 499,300.00 499,300.00 1.375 1.373 563.52 0.00 0.00 563.52 75472RAD3 1218 101 RAYJAM 244,000.00 244,000.00 244,000.00 1.950 1.950 391.07 0.00 0.00 391.07 12556LBA3 1219 101 CITBNK 245,000.00 245,000.00 245,000.00 1.900 1.900 382.60 0.00 0.00 382.60 15118RRH2 1220 101 CELTIC 248,000.00 248,000.00 248,000.00 1.850 1.850 377.10 0.00 0.00 377.10 334342CD2 1221 101 1STNBS 249,000.00 249,000.00 249,000.00 1.850 1.850 378.62 0.00 0.00 378.62 336460CX6 1222 101 1STDQN 248,000.00 248,000.00 248,000.00 1.800 1.800 366.90 0.00 0.00 366.90 3133EKZK5 1223 101 FFCB 500,000.00 499,400.00 499,400.00 1.600 1.624 666.66 0.00 0.00 666.66 3133EKP75 1224 101 FFCB 500,000.00 498,750.00 498,750.00 1.600 1.626 666.67 0.00 0.00 666.67 549104JN8 1225 101 LUANA 245,000.00 245,000.00 245,000.00 1.600 1.600 322.19 0.00 0.00 322.19 649447TC3 1226 101 NYCMBK 245,000.00 245,000.00 245,000.00 1.800 1.800 362.47 0.00 0.00 362.47 Run Date: 09/10/2021 - 20:23 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 City of La Quinta Total Earnings June 1, 2021 - June 30, 2021 Page 4 Adjusted Interest Earnings Ending Beginning Ending Current Annualized Interest Amortization/ Realized Adjusted Interest CUSIP Investment # Fund Issuer Par Value Book Value Book Value Rate Yield Earned Accretion Gainl/Loss Earnings Fund: General Fund 06652CHB0 1227 101 BNKWST 248,000.00 248,000.00 248,000.00 1.700 1.700 346.52 0.00 0.00 346.52 059731851 1228 101 BOTW 10,056,644.58 11,490,355.05 10,056,644.58 0.01 0.00 0.00 0.01 SYS1230 1230 101 PARS 11,381,922.40 11,277,103.22 11,381,922.40 0.00 0.00 0.00 0.00 33640VDD7 1231 101 1STSER 248,000.00 248,000.00 248,000.00 1.700 1.700 346.52 0.00 0.00 346.52 3135G0W33 1233 101 FNMA 1,000,000.00 992,100.00 992,100.00 1.375 1.405 1,145.83 0.00 0.00 1,145.83 3133EK4X1 1234 101 FFCB 1,000,000.00 996,900.00 996,900.00 1.600 1.627 1,333.34 0.00 0.00 1,333.34 804375DL4 1235 101 SAUKVL 248,000.00 248,000.00 248,000.00 1.700 1.700 346.52 0.00 0.00 346.52 61760A3B3 1236 101 MSPRIV 245,000.00 245,000.00 245,000.00 1.900 1.900 382.60 0.00 0.00 382.60 61690UNX4 1237 101 MORGST 245,000.00 245,000.00 245,000.00 1.950 1.950 392.67 0.00 0.00 392.67 538036GV0 1238 101 LIVEOK 248,000.00 248,000.00 248,000.00 1.800 1.800 366.90 0.00 0.00 366.90 49228XAK6 1239 101 KERNCU 248,000.00 248,000.00 248,000.00 1.900 1.900 387.29 0.00 0.00 387.29 79772FAC0 1240 101 SF FCU 248,000.00 248,000.00 248,000.00 1.850 1.850 377.10 0.00 0.00 377.10 912828YV6 1241 101 USTR 1,000,000.00 989,687.50 989,687.50 1.500 1.511 1,229.51 0.00 0.00 1,229.51 3133ELEA8 1242 101 FFCB 1,000,000.00 998,600.00 998,600.00 1.700 1.726 1,416.67 0.00 0.00 1,416.67 949495AT2 1244 101 WFNBW 248,000.00 248,000.00 248,000.00 1.900 1.900 387.29 0.00 0.00 387.29 3133ELNE0 1246 101 FFCB 1,000,000.00 999,000.00 999,000.00 1.430 1.451 1,191.66 0.00 0.00 1,191.66 3133EGWJ0 1247 101 FFCB 1,000,000.00 999,217.36 999,217.36 1.400 1.421 1,166.67 0.00 0.00 1,166.67 35637RDC8 1248 101 FRDMFI 248,000.00 248,000.00 248,000.00 1.550 1.550 315.95 0.00 0.00 315.95 90983WBT7 1249 101 UNTDCM 248,000.00 248,000.00 248,000.00 1.650 1.650 336.33 0.00 0.00 336.33 32114VBT3 1250 101 1STNMI 248,000.00 248,000.00 248,000.00 1.650 1.650 336.33 0.00 0.00 336.33 77579ADF0 1251 101 RLLSTN 245,000.00 245,000.00 245,000.00 1.650 1.650 332.26 0.00 0.00 332.26 17286TAG0 1252 101 CITADL 248,000.00 248,000.00 248,000.00 1.650 1.650 336.33 0.00 0.00 336.33 87164DRD4 1253 101 SYNOVS 245,000.00 245,000.00 245,000.00 1.600 1.600 322.19 0.00 0.00 322.19 81768PAF3 1254 101 SERVIS 248,000.00 248,000.00 248,000.00 1.600 1.600 326.14 0.00 0.00 326.14 029728BC5 1255 101 AMERST 248,000.00 248,000.00 248,000.00 1.600 1.600 326.14 0.00 0.00 326.14 00435JBH5 1256 101 ACCSS 248,000.00 248,000.00 248,000.00 1.600 1.600 326.14 0.00 0.00 326.14 849430BF9 1257 101 SPRING 248,000.00 248,000.00 248,000.00 1.500 1.500 305.76 0.00 0.00 305.76 05465DAE8 1258 101 AXOS 248,000.00 248,000.00 248,000.00 1.650 1.650 336.33 0.00 0.00 336.33 12738RFX7 1259 101 CADNCE 245,000.00 245,000.00 245,000.00 1.200 1.200 241.65 0.00 0.00 241.65 882213AB7 1260 101 TEXAS 245,000.00 245,000.00 245,000.00 1.100 1.100 221.51 0.00 0.00 221.51 06424KBC3 1261 101 SNTCLR 248,000.00 248,000.00 248,000.00 1.100 1.100 224.22 0.00 0.00 224.22 89579NCD3 1262 101 TRIAD 248,000.00 248,000.00 248,000.00 1.350 1.350 275.18 0.00 0.00 275.18 66704MEQ0 1263 101 NRTHSR 248,000.00 248,000.00 248,000.00 1.150 1.150 234.41 0.00 0.00 234.41 07833EAD9 1264 101 BELLCO 248,000.00 248,000.00 248,000.00 1.300 1.300 264.99 0.00 0.00 264.99 954444BS3 1265 101 WESTMI 248,000.00 248,000.00 248,000.00 1.150 1.150 234.41 0.00 0.00 234.41 654062JZ2 1266 101 NCOLET 248,000.00 248,000.00 248,000.00 1.400 1.400 285.37 0.00 0.00 285.37 020080BX4 1267 101 ALMABK 248,000.00 248,000.00 248,000.00 1.400 1.400 285.37 0.00 0.00 285.37 Run Date: 09/10/2021 - 20:23 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 City of La Quinta Total Earnings June 1, 2021 - June 30, 2021 Page 5 Adjusted Interest Earnings Ending Beginning Ending Current Annualized Interest Amortization/ Realized Adjusted Interest CUSIP Investment # Fund Issuer Par Value Book Value Book Value Rate Yield Earned Accretion Gainl/Loss Earnings Fund: General Fund 2027506M2 1268 101 CMWBUS 248,000.00 248,000.00 248,000.00 1.250 1.250 254.79 0.00 0.00 254.79 69506YRH4 1269 101 PACWST 245,000.00 245,000.00 245,000.00 1.300 1.300 261.78 0.00 0.00 261.78 08016PDQ9 1270 101 BELB&T 248,000.00 248,000.00 248,000.00 1.250 1.250 254.79 0.00 0.00 254.79 14042TDD6 1271 101 CAPONE 245,000.00 245,000.00 245,000.00 1.600 1.600 322.19 0.00 0.00 322.19 472382AQ3 1272 101 THEJEF 248,000.00 248,000.00 248,000.00 1.250 1.250 254.80 0.00 0.00 254.80 32027BAL1 1273 101 1STFDM 249,000.00 249,000.00 249,000.00 1.200 1.200 245.60 0.00 0.00 245.60 32112UDR9 1274 101 1STMCG 248,000.00 248,000.00 248,000.00 1.350 1.350 275.18 0.00 0.00 275.18 33847E3A3 1276 101 FLGSTR 248,000.00 248,000.00 248,000.00 1.250 1.250 254.80 0.00 0.00 254.80 95960NKD8 1277 101 WSTRNS 245,000.00 245,000.00 245,000.00 1.000 1.000 201.37 0.00 0.00 201.37 32056GDJ6 1278 101 1STINT 248,000.00 248,000.00 248,000.00 1.000 1.000 203.84 0.00 0.00 203.84 3134GVYG7 1279 101 FHLMC 1,000,000.00 1,000,000.00 1,000,000.00 0.625 0.634 520.84 0.00 0.00 520.84 3133ELH23 1280 101 FFCB 500,000.00 499,850.00 499,850.00 0.500 0.507 208.34 0.00 0.00 208.34 3130AJKW8 1281 101 FHLB 500,000.00 499,850.00 499,850.00 0.500 0.507 208.33 0.00 0.00 208.33 3133ELH80 1282 101 FFCB 500,000.00 500,000.00 500,000.00 0.680 0.689 283.33 0.00 0.00 283.33 3130AJRP6 1283 101 FHLB 300,000.00 300,000.00 300,000.00 0.680 0.689 170.00 0.00 0.00 170.00 169894AS1 1284 101 CHIPVA 248,000.00 248,000.00 248,000.00 0.600 0.600 122.30 0.00 0.00 122.30 02616AAH2 1285 101 AMR1ST 248,000.00 248,000.00 248,000.00 0.350 0.350 71.34 0.00 0.00 71.34 84223QAN7 1286 101 STHRNB 248,000.00 248,000.00 248,000.00 0.500 0.500 101.92 0.00 0.00 101.92 064520BG3 1287 101 BKPRNC 248,000.00 248,000.00 248,000.00 0.500 0.500 101.92 0.00 0.00 101.92 3135G05S8 1288 101 FNMA 500,000.00 500,000.00 500,000.00 0.500 0.507 208.33 0.00 0.00 208.33 3136G4N74 1289 101 FNMA 1,000,000.00 1,000,000.00 1,000,000.00 0.560 0.568 466.66 0.00 0.00 466.66 3136G4M75 1290 101 FNMA 500,000.00 499,750.00 499,750.00 0.520 0.527 216.67 0.00 0.00 216.67 3135G06E8 1291 101 FNMA 500,000.00 499,250.00 499,250.00 0.420 0.426 175.00 0.00 0.00 175.00 3135GA2Z3 1292 101 FNMA 500,000.00 499,250.00 499,250.00 0.560 0.569 233.33 0.00 0.00 233.33 SYS1293 1293 101 BNY 5,000,000.00 3,056,596.78 5,000,000.00 0.01 0.00 0.00 0.01 3137EAEU9 1297 101 FHLMC 1,000,000.00 997,300.00 997,300.00 0.375 0.381 312.50 0.00 0.00 312.50 3130AKFA9 1298 101 FHLB 500,000.00 497,400.00 497,400.00 0.375 0.382 156.25 0.00 0.00 156.25 3135GA7D7 1299 101 FNMA 500,000.00 500,000.00 500,000.00 0.600 0.608 250.00 0.00 0.00 250.00 3135GAAW1 1300 101 FNMA 500,000.00 500,000.00 500,000.00 0.400 0.406 166.67 0.00 0.00 166.67 3134GXGZ1 1301 101 FHLMC 500,000.00 500,000.00 500,000.00 0.550 0.558 229.17 0.00 0.00 229.17 3130AKMZ6 1302 101 FHLB 500,000.00 500,000.00 500,000.00 0.510 0.517 212.50 0.00 0.00 212.50 91282CBC4 1303 101 USTR 500,000.00 498,632.81 498,632.81 0.375 0.379 155.31 0.00 0.00 155.31 3130AKN28 1304 101 FHLB 500,000.00 500,000.00 500,000.00 0.550 0.558 229.17 0.00 0.00 229.17 51507LCC6 1305 101 LNDMRK 248,000.00 248,000.00 248,000.00 0.500 0.500 101.92 0.00 0.00 101.92 87270LDL4 1306 101 EVRBA 245,000.00 245,000.00 245,000.00 0.500 0.500 100.69 0.00 0.00 100.69 3137EAEX3 1307 101 FHLMC 500,000.00 495,999.50 495,999.50 0.375 0.383 156.25 0.00 0.00 156.25 45950VPS9 1308 101 IFC 500,000.00 497,300.00 497,300.00 0.500 0.507 207.18 0.00 0.00 207.18 Run Date: 09/10/2021 - 20:23 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 City of La Quinta Total Earnings June 1, 2021 - June 30, 2021 Page 6 Adjusted Interest Earnings Ending Beginning Ending Current Annualized Interest Amortization/ Realized Adjusted Interest CUSIP Investment # Fund Issuer Par Value Book Value Book Value Rate Yield Earned Accretion Gainl/Loss Earnings Fund: General Fund 91282CBH3 1309 101 USTR 500,000.00 495,100.00 495,100.00 0.375 0.382 155.38 0.00 0.00 155.38 3137EAEX3 1310 101 FHLMC 1,000,000.00 983,940.00 983,940.00 0.375 0.386 312.50 0.00 0.00 312.50 91282CAT8 1311 101 USTR 1,000,000.00 977,500.00 977,500.00 0.250 0.254 203.81 0.00 0.00 203.81 3130ALV92 1312 101 FHLB 500,000.00 500,000.00 500,000.00 0.500 0.507 208.33 0.00 0.00 208.33 39573LBC1 1313 101 GRNST 249,000.00 249,000.00 249,000.00 0.950 0.950 194.42 0.00 0.00 194.42 89235MKY6 1314 101 TOYFSB 245,000.00 245,000.00 245,000.00 0.900 0.900 181.24 0.00 0.00 181.24 91282CAZ4 1315 101 USTR 500,000.00 492,187.50 492,187.50 0.375 0.380 153.69 0.00 0.00 153.69 14622LAA0 1316 101 CARTER 248,000.00 248,000.00 248,000.00 0.750 0.750 152.88 0.00 0.00 152.88 31617CAV5 1317 101 FIDHMS 248,000.00 248,000.00 248,000.00 0.700 0.700 142.68 0.00 0.00 142.68 SYS1318 1318 101 DPME 265,784.81 241,247.93 265,784.81 0.00 0.00 0.00 0.00 91282CBQ3 1319 101 USTR 500,000.00 494,165.00 494,165.00 0.500 0.502 203.81 0.00 0.00 203.81 91282CBT7 1320 101 USTR 500,000.00 499,525.00 499,525.00 0.750 0.749 307.37 0.00 0.00 307.37 91282CCF6 1321 101 USTR 1,000,000.00 0.00 997,060.00 0.750 0.750 614.76 0.00 0.00 614.76 91282CBT7 1322 101 USTR 500,000.00 0.00 498,450.00 0.750 0.750 143.44 0.00 0.00 143.44 91282CCF6 1323 101 USTR 500,000.00 0.00 497,095.00 0.750 0.752 143.44 0.00 0.00 143.44 3130AMFS6 1324 101 FHLB 1,000,000.00 0.00 993,420.00 0.750 0.765 291.67 0.00 0.00 291.67 Subtotal 176,253,992.80 156,491,245.92 175,993,344.97 0.818 106,264.75 0.00 0.00 106,264.75 Fund: Fiscal Agent SYS1058 1058 231 USBANK 1,422.16 1,422.15 1,422.16 0.009 0.01 0.00 0.00 0.01 Subtotal 1,422.16 1,422.15 1,422.16 0.009 0.01 0.00 0.00 0.01 Fund: Housing Authority : WSA and LQ SYS1062 1062 241 LQPR 335,858.81 326,355.81 335,858.81 0.00 0.00 0.00 0.00 Subtotal 335,858.81 326,355.81 335,858.81 0.00 0.00 0.00 0.00 Fund: SA Low/Mod Bond Fund 25-33-005 1113 249 LAIF 10,580,686.54 10,580,686.54 10,580,686.54 0.262 0.328 2,848.44 0.00 0.00 2,848.44 Subtotal 10,580,686.54 10,580,686.54 10,580,686.54 0.328 2,848.44 0.00 0.00 2,848.44 Total Run Date: 09/10/2021 - 20:23 187,171,960.31 167,399,710.42 186,911,312.48 0.786 109,113.20 0.00 0.00 109,113.20 Portfolio CITY CP TE (PRF_TE) 7.3.6 Report Ver. 7.3.6.1 tai Qdifr�, GEM of the DESERT — City of La Quinta Purchases Report Sorted by Security Type - Fund April 1, 2021 - June 30, 2021 City of La Quinta Sec. Original Purchase Principal Accrued Interest Rate at Maturity Ending CUSIP Investment # Fund Type Issuer Par Value Date Payment Periods Purchased at Purchase PurchaseDate YTM Book Value Federal Agency Coupon Securities 3130AMFS6 1324 101 FAC FHLB 1,000,000.00 06/17/2021 12/12 - 06/12 993,420.00 Received 0.750 06/12/2026 0.885 993,420.00 Subtotal 1,000,000.00 993,420.00 0.00 993,420.00 Treasury Coupon Securities 91282CAZ4 1315 101 TRC USTR 91282CBQ3 1319 101 TRC USTR 91282CBT7 1320 101 TRC USTR 91282CCF6 1321 101 TRC USTR 91282CBT7 1322 101 TRC USTR 91282CCF6 1323 101 TRC USTR Subtotal 500,000.00 04/22/2021 05/31 - 11/30 500,000.00 05/28/2021 08/31 - 02/28 500,000.00 05/28/2021 09/30 - 03/31 1,000,000.00 06/01/2021 11/30 - 05/31 500,000.00 06/17/2021 09/30 - 03/31 500,000.00 06/17/2021 11/30 - 05/31 3,500,000.00 492,187.50 494,165.00 499,525.00 997,060.00 498,450.00 497,095.00 Received 0.375 11/30/2025 0.720 Received 0.500 02/28/2026 0.750 Received 0.750 03/31/2026 0.770 Received 0.750 05/31/2026 0.810 Received 0.750 03/31/2026 0.816 Received 0.750 05/31/2026 0.870 3,478,482.50 492,187.50 494,165.00 499,525.00 997,060.00 498,450.00 497,095.00 0.00 3,478,482.50 Certificate of Deposits 39573LBC1 1313 101 MC1 GRNST 89235MKY6 1314 101 MC1 TOYFSB 14622LAA0 1316 101 MC1 CARTER 31617CAV5 1317 101 MC1 FIDHMS Subtotal 249,000.00 04/16/2021 05/01 - Monthly 245,000.00 04/22/2021 10/22 - 04/22 248,000.00 04/27/2021 05/27 - Monthly 248,000.00 04/30/2021 05/31 - Monthly 249,000.00 245, 000.00 248,000.00 248,000.00 0.950 04/16/2026 0.951 0.900 04/22/2026 0.900 0.750 04/27/2026 0.750 0.700 04/30/2026 0.711 249,000.00 245, 000.00 248,000.00 248,000.00 990,000.00 990,000.00 0.00 990,000.00 Total Purchases 5,490,000.00 Received = Accrued Interest at Purchase was received by report ending date. Run Date: 08/10/2021 - 11:25 5,461,902.50 0.00 5,461,902.50 Portfolio CITY CP PU (PRF_PU) 7.1.1 Report Ver. 7.3.6.1 �r W GEM of the DESERT — 0(414 City of La Quinta Maturity Report Sorted by Maturity Date Amounts due during April 1, 2021 - June 30, 2021 City of La Quinta Sec. Maturity Purchase Rate Book Value Maturity Net CUSIP Investment # Fund Type Issuer Par Value Date Date at Maturity at Maturity Interest Proceeds Income 02587DP85 1077 101 MC1 AMEX 240,000.00 04/19/2021 04/19/2017 2.250 240,000.00 2,692.60 242,692.60 2,692.60 89214PBL2 1128 101 MC1 TOWNE 240,000.00 04/30/2021 04/30/2018 2.800 240,000.00 3,350.79 243,350.79 3,350.79 74267GVG9 1032 101 MC1 PRVTBA 240,000.00 05/26/2021 05/26/2016 1.500 240,000.00 1,785.21 241,785.21 1,785.21 912828R77 1193 101 TRC USTR 500,000.00 05/31/2021 05/31/2019 1.375 493,610.00 3,437.50 503,437.50 9,827.50 14042RGD7 1082 101 MC1 CAP1NA 240,000.00 06/07/2021 06/07/2017 2.250 240,000.00 2,692.60 242,692.60 2,692.60 912828S27 1045 101 TRC USTR 5,000,000.00 06/30/2021 07/18/2016 1.125 5,000,000.00 28,125.00 5,028,125.00 28,125.00 Run Date: 08/10/2021 - 11:26 Total Maturities 6,460,000.00 6,453,610.00 42,083.70 6,502,083.70 48,473.70 Portfolio CITY CP MA (PRF_MA) 7.1.1 Report Ver. 7.3.6.1 oCaaloha' GEM of the DESERT — CUSIP Issuer Purchase Redem. Date Investment # Fund Sec. Type Date Matur. Date City of La Quinta Sales/Call Report Sorted by Maturity Date - Fund April 1, 2021 - June 30, 2021 Par Rate at Value Redem. Book Value at Redem. Redemption Redemption Total Principal Interest Amount City of La Quinta Net Income 04/21/2025 3134GVLCO 1275 101 FHLMC 04/28/2020 04/21/2021 1,000,000.00 0.700 998,500.00 1,000,000.00 3,500.00 1,003,500.00 FAC 04/21/2025 Call 5,000.00 Subtotal 1,000,000.00 998,500.00 1,000,000.00 3,500.00 1,003,500.00 5,000.00 Total Sales Run Date: 08/10/2021 - 11:27 1,000,000.00 998,500.00 1,000,000.00 3,500.00 1,003,500.00 5,000.00 Portfolio CITY CP SA (PRF_SA) 7.1.1 Report Ver. 7.3.6.1 US Treasury Rates https://www.treasury.gov/resou rce-center/data-chart-center/interest-rates/Pages/TextView.aspx?data=yieldYear&year=2020 Effective Rate of 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 Return City Portfolio (month) 4/30/2021 0.01 0.02 0.01 0.03 0.05 0.16 0.35 0.86 1.32 1.65 2.19 2.3 0.84 5/28/2021 0.01 0.01 0.01 0.03 0.05 0.14 0.3 0.79 1.24 1.58 2.18 2.26 0.84 6/30/2021 0.05 0.05 0.05 0.06 0.07 0.25 0.46 0.87 1.21 1.45 2 2.06 0.84 3.25 3.00 2.75 2.50 2.25 2.00 1.75 1.50 1.25 1.00 0.75 0.50 0.25 0.00 Treasury Rate Comparison -1-2-Yr Treasur,f ..5 -Yr Tr easur,r 10 -Yr Treasur,r