Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
R2023-202 2023-08-28
DocuSign Envelope ID: DEFD4B1E-42E0-48FE-BEC1-847B01E25087 RESOLUTION NO. R2023-202 A Resolution of the City Council of the City of Pearland, Texas, accepting the City's Investment Report for the quarter ending June 2023. BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF PEARLAND, TEXAS: Section 1. That the City Council hereby accepts the Quarterly Investment Report attached hereto as Exhibit "A" for the quarter ending June 2023. PASSED, APPROVED and ADOPTED this the 28th day of August, A.D., 2023. DocuSigned by: pze.. D4881A61✓J3r4r2... J. KEVIN COLE MAYOR ATTEST: DocuSigned by: s lull p8CC22631rrF416 FRANCES AGUILAR, TRMC, MMC CITY SECRETARY APPROVED AS TO FORM: DocuSigned by: E13CA888BB1F1B6. DARRIN M. COKER CITY ATTORNEY City of Pearland Quarterly Investment Report March 31, 2023 to June 30, 2023 This report is prepared for the City of Pearland in accordance with Chapter 2256 of the Public Funds Investment Act (PFIA). Section2256.023 (a) of the PFIA states that "Not less than quarterly, the investment officer shall prepare and submit to the governing body of the entity a written report of the investment transactions for all funds covered by this chapter for the preceding reporting period." This report is signed by the Investment Officer and includes the disclosures required in the PFIA. Month Market Value 4/30/2023 5/31/2023 6/30/2023 316,273,303.26 312,367,911 35 293,487,578.16 Total) Average 307,376,264.26 Amy Bu.kert, Chief Financial Officer 4D7'1 Johan Rodriguez, Treasury Manager Book Value Unrealized Gain/Loss 316,463,967.70 312,573,212.96 293,687,892.93 307,575,024.53 • • - 190,664.44 - 205,301.61 -200,314.77 -198,760.27 YTM @ Cost Treasury 1 Year Date Kendra Mu 7- 51-tots Date 4.61 4.89 5.01 4.68 4.91 5.24 Interest Earnea Days To Maturity 1,266,327.47 1,374,195.54 1,322,776.23 4.83 4.94 3,963,299.24 epu Firtce Director 14 13 12 13 1 City of Pearland Distribution by Security Type - Book Value Report Group: Pearland Begin Date: 3/31/2023, End Date: 6/30/2023 Security Type Allocation Security Type Book Value 3/31/2023 % of Portfolio 3/31/2023 Book Value 6/30/2023 % of Portfolio 6/30/2023 Cash Certificate Of Deposit FFCB Bond FHLB Bond Local Government Investment Pool 166,429,175.35 1,226,000.00 3,000,000.00 7,249,996.58 147,153,155.95 51.20 0.38 0.92 2.23 45.27 143,697,818.94 1,226,000.00 3,000,000.00 6,250,000.00 139,514,073.99 48.93 0.42 1.02 2.13 47.50 Total / Average 325,058,327.88 Portfolio Holdings as of 3/31/2023 d 51.2%-Cash 0,38%-Certificate Of... • 0,92%-FFCB Bond • 2.23%-FHLB Bond • 45.27%-Local Governor,., 100.00 293,687,892.93 100.00 Portfolio Holdings as of 6/30/2023 4 8.9 3 %-Cash 0,42%-Certificate Of... 1 1,02%-FFCB Bond 1 2,13%-FHLB Bond • 47.5%-Local Governme,., Prepared by Jonathan Rodriguez 2 City of Pearland Distribution by Maturity Range - Book Value Report Group: Pearland Begin Date: 3/31/2023, End Date: 6/30/2023 Maturity Range Allocation Book Value % of Portfolio Book Value % of Portfolio Maturity Range 3/31/2023 3/31/2023 6/30/2023 6/30/2023 0-1 Month 313,582,331.30 96.47 283,211,892.93 96.43 1-3 Months 999,996.58 0.31 1,485,000.00 0.51 3-6 Months 1,485,000.00 0.46 1,000,000.00 0.34 6-9 Months 1,000,000.00 0.31 2,250,000.00 0.77 9-12 Months 2,250,000.00 0.69 1,741,000.00 0.59 1-2 Years 4,741,000.00 1.46 3,000,000.00 1.02 2-3 Years 1,000,000.00 0.31 1,000,000.00 0.34 Total / Average 325,058,327.88 100.00 293,687,892.93 100.00 Portfolio Holdings 350,000 300,000 250,000 c 0200,000 O H 150,000 - C 100,000 - 50,000 00 le3I31J2023 6/30/2023 0-1 M 1-3 M 3-6 M 6-9 M 9-12 M 1-2 Y 2-3 Y Prepared by Jonathan Rodriguez 3 City of Pearland Total Rate of Return - Book Value by Month Report Group: Pearland Begin Date: 7/31/2022, End Date: 6/30/2023 Beginning BV + Interest Earned Realized Investment Average Capital Annualized Treasury 1 Month Accrued Interest During Period-BV Gain/Loss-BV Income-BV Base-BV TRR-BV TRR-BV Year 7/31/2022 298,450,345.32 8/31/2022 380,446,775.29 9/30/2022 342,810,459.17 10/31/2022 324,916,050.67 11/30/2022 318,873,374.17 12/31/2022 312,428,833.71 1/31/2023 348,692,412.42 2/28/2023 356,361,554.82 3/31/2023 333,152,967.43 4/30/2023 325,100,909.13 5/31/2023 316,534,047.69 6/30/2023 312,650,214.38 326,303.12 573,244.90 616, 700.11 768,245.57 880,037.95 1, 043, 378.12 1,215,167.99 1,227,668.17 1,216,037.76 1,266,327.47 1,374,195.54 1, 322, 776.23 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 326,303.12 573,244.90 616,700.11 768,245.57 880,037.95 1,043,378.12 1,215,167.99 1,227,668.17 1,216,037.76 1,266,327.47 1,374,195.54 1,322,776.23 310,103, 903.55 359,070,174.30 331,702,260.61 321,143, 522.56 314,911,678.64 331,679,173.11 352,145, 983.56 344,045,844.48 328,015,665.02 319,813,960.46 313,527,552.66 301,809,314.66 0.11 0.16 0.19 0.24 0.28 0.31 0.35 0.36 0.37 0.40 0.44 0.44 1.27 1.93 2.25 2.91 3.41 3.84 4.22 4.37 4.54 4.86 5.39 5.39 3.02 3.28 3.89 4.43 4.73 4.68 4.69 4.93 4.68 4.68 4.91 5.24 Total/Average 298,450,345.32 11,830,082.93 0.00 11,830,082.93 323,123,642.20 3.66 3.66 4.43 Annualized TRR-BV 6.00 5,00 4.00 3.00 2.00 1.00 0.00 d I I 07/2022 08/2022 09/2022 10/2022 11/2022 12/2022 01/2023 02/2023 03/2023 04/2023 05/2023 06/2023 • Portfolio • Treasury 1 Year Prepared by Jonathan Rodriguez 4 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 6/30/2023 Description CUSIP Face Amount I Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Cash Wells Fargo Cash WF3025 Wells Fargo Cash WF9871 Wells Fargo Cash 2,771.11 8/12/2020 0.00 2,771.11 2,771.11 100.00 0.00 2,771.11 0% 0.00 None None 0 7/21/2010 767,817.66 100.00 767,817.66 0.26% None 767,817.66 1.01 767,817.66 1.01 0.00 None 0 10/15/2020 WF1376 60,127.55 1.01 Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP 60,127.55 100.00 60,127.55 0.02% None 60,127.55 1.01 0.00 None 0 5/31/2006 9,762,714.03 100.00 9,762,714.03 3.32% None 9,762,714.03 4.96 9,762,714.03 4.96 0.00 None 0 5/31/2006 1,671,410.92 100.00 1,671,410.92 0.57% None 1,671,410.92 4.96 1,671,410.92 4.96 0.00 None 0 Wells Fargo Sweep Cash WFSWEEP 5/31/2006 1,321.36 100.00 1,321.36 0% None 1,321.36 4.96 1,321.36 4.96 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 12,164,102.16 100.00 12,164,102.16 4.14% None WFSWEEP 12,164,102.16 4.96 12,164,102.16 4.96 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 2,549,843.61 100.00 2,549,843.61 0.87% None WFSWEEP 2,549,843.61 4.96 2,549,843.61 4.96 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 204,844.52 100.00 204,844.52 0.07% None WFSWEEP 204,844.52 4.96 204,844.52 4.96 0.00 None 0 Wells Fargo Sweep Cash WFSWEEP 5/31/2006 633,630.41 100.00 633,630.41 0.22% None 633,630.41 4.96 633,630.41 4.96 0.00 None 0 Wells Fargo Sweep Cash WFSWEEP 5/31/2006 229,257.55 100.00 229,257.55 0.08% None 229,257.55 4.96 229,257.55 4.96 0.00 None 0 Wells Fargo Sweep Cash WFSWEEP 5/31/2006 180,747.86 100.00 180,747.86 0.06% None 180,747.86 4.96 180,747.86 4.96 0.00 None 0 Prepared by Jonathan Rodriguez 5 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 6/30/2023 Description Face Amount / CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Settlement Date Cost Value Market Price Market Value % Portfolio Unre. Gain/Loss Credit Rating Credit Rating Days To Call/Maturity Duration To Maturity Wells Fargo Sweep Cash WFSWEEP 6,472,731.01 5/31/2006 4.96 6,472,731.01 6,472,731.01 100.00 4.96 6,472,731.01 2.2% 0.00 Wells Fargo Sweep Cash WFSWEEP 5/31/2006 60,507.27 100.00 60,507.27 60,507.27 4.96 60,507.27 4.96 Wells Fargo Sweep Cash WFSWEEP 1,544,005.03 None None 1 0 0.02% None 0.00 None 1 0 5/31/2006 1,544,005.03 100.00 1,544,005.03 0.53% None 4.96 1,544,005.03 4.96 0.00 None Wells Fargo Sweep Cash 1 0 5/31/2006 69,932.24 100.00 69,932 24 0.02% None WFSWEEP 69,932.24 4.96 69,932.24 4.96 0.00 None 1 0 Wells Fargo Sweep Cash 5/31/2006 65,377.86 100.00 65,377.86 0.02% None WFSWEEP 65,377.86 4.96 65,377.86 4.96 0.00 None 1 0 Wells Fargo Sweep Cash 5/31/2006 -362,762.63 100.00 -362,762.63 -0.12% None WFSWEEP -362,762.63 4.96-362,762.63 4.96 0.00 None 1 0 Wells Fargo Sweep Cash 5/31/2006 1,078,329.39 100.00 1,078,329.39 0.37% None 1 WFSWEEP 1,078,329.39 4.96 1,078,329.39 4.96 0.00 None 0 Wells Fargo Sweep Cash WFSWEEP 10,430,687.51 5/31/2006 10,430,687.51 100.00 10,430,687.51 3.55% None 4.96 10,430,687.51 4.96 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 5/31/2006 240,321.95 100.00 240,321.95 0.08% None 240,321.95 4.96 240,321.95 4.96 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 5/31/2006 336,779.62 100.00 336,779.62 0.11% None 336,779.62 4.96 336,779.62 4.96 0.00 None 1 0 Wells Fargo Sweep Cash 5/31/2006 1,672,622.03 100.00 1,672,622.03 0.57% None WFSWEEP 1,672,622.03 4.96 1,672,622.03 4.96 0.00 None 1 0 Wells Fargo Sweep Cash 6/30/2006 15,642.60 100.00 15,642.60 0.01% None 1 WFSWEEP 15,642.60 4.96 15,642.60 4.96 0.00 None 0 Prepared by Jonathan Rodriguez 6 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 6/30/2023 Description CUSIP Face Amount / Shares Settlement Date Cost Value Market Price Market Value % Portfolio YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Credit Rating Days To Call/Maturity Duration To Maturity Wells Fargo Sweep Cash WFSWEEP 531,119.09 10/31/2006 4.96 531,119.09 531,119.09 100.00 4.96 531,119.09 0 18% 0.00 None None 1 0 Wells Fargo Sweep Cash WFSWEEP 100.00 5,864.13 5,864.13 4.96 5,864.13 4.96 0.00 None 12/1/2006 5,864.13 Wells Fargo Sweep Cash WFSWEEP 9/1/2007 143,843.64 100.00 143,843.64 4.96 143,843.64 4.96 Wells Fargo Sweep Cash WFSWEEP 0% None 1 0 143,843.64 0.05% None 0.00 None 1 0 12/31/2007 327,142.57 100.00 327,142.57 0.11% None 327,142.57 4.96 327,142.57 4.96 0.00 None 1 0 Wells Fargo Sweep Cash 10/30/2008 6,455,392.35 100.00 6,455,392.35 2.2% None WFSWEEP 6,455,392.35 4.96 6,455,392.35 4.96 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 9/15/2009 -3,024.58 100.00 -3,024.58 0% None -3,024.58 4.96-3,024.58 4.96 0.00 None 1 0 Wells Fargo Sweep Cash 9/15/2010 2,804,567.04 100.00 2,804,567.04 0.95% None 1 WFSWEEP 2,804,567.04 4.96 2,804,567.04 4.96 0.00 None 0 Wells Fargo Sweep Cash 4/15/2012 155,082.62 100.00 155,082.62 0.05% None WFSWEEP 155,082.62 4.96 155,082.62 4.96 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 2/1/2013 26,188.84 100.00 26,188.84 0.01% None 26,188.84 4.96 26,188.84 4.96 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 11/15/2015 -31,988.90 100.00 -31,988.90 -0.01% None -31,988.90 4.96-31,988.90 4.96 0.00 None 1 0 Wells Fargo Sweep Cash 10/15/2018 3,889,204.73 100.00 3,889,204.73 1.32% None WFSWEEP 3,889,204.73 4.96 3,889,204.73 4.96 0.00 None 1 0 Wells Fargo Sweep Cash 12/15/2018 90,748.54 100.00 90,748.54 0.03% None 1 WFSWEEP 90,748.54 4.96 90,748.54 4.96 0.00 None 0 Prepared by Jonathan Rodriguez 7 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 6/30/2023 Description Face Amount I Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash WFSWEEP -8,436,562.92 10/15/2019 -8,436,562.92 4.96-8,436,562.92 100.00 4.96 -8,436,562.92 -2.87% 0.00 Wells Fargo Sweep Cash WFSWEEP 10/15/2019 963,638.32 100.00 963,638.32 963,638.32 4.96 963,638.32 4.96 None None 1 0 0.33% None 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 10/15/2019 -8,156.41 100.00 -8,156.41 0% None -8,156.41 4.96-8,156.41 4.96 Wells Fargo Sweep Cash WFSWEEP 0.00 None 1 0 10/15/2019 971,807.42 100.00 971,807.42 0.33% None 971,807.42 4.96 971,807.42 4.96 0.00 None 1 0 Wells Fargo Sweep Cash 10/15/2019 1,059,333.34 100.00 1,059,333.34 0.36% None WFSWEEP 1,059,333.34 4.96 1,059,333.34 4.96 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 10/15/2019 513,601.76 100.00 513,601.76 0.17% None 513,601.76 4.96 513,601.76 4.96 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 10/15/2019 411,388.23 100.00 411,388.23 0.14% None 1 411,388.23 4.96 411,388.23 4.96 0.00 None 0 Wells Fargo Sweep Cash WFSWEEP 4,009,368.34 10/15/2019 4,009,368.34 100.00 4,009,368.34 1.37% None 4.96 4,009,368.34 4.96 0.00 None 1 0 Wells Fargo Sweep Cash 12/15/2019 1,045,110.03 100.00 1,045,110.03 0.36% None WFSWEEP 1,045,110.03 4.96 1,045,110.03 4.96 0.00 None 1 0 Wells Fargo Sweep Cash 1/15/2020 2,824,260.99 100.00 2,824,260.99 0.96% None WFSWEEP 2,824,260.99 4.96 2,824,260.99 4.96 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 1/15/2020 2,325.66 100.00 2,325.66 0% None 2,325.66 4.96 2,325.66 4.96 0.00 None 1 0 Wells Fargo Sweep Cash 1/15/2020 610,754.66 100.00 610,754.66 0.21% None 1 WFSWEEP 610,754.66 4.96 610,754.66 4.96 0.00 None 0 Prepared by Jonathan Rodriguez 8 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 6/30/2023 Description CUSIP Face Amount / Shares Settlement Date Cost Value Market Price Market Value YTM @ Cost Book Value YTM @ Market Accrued Interest % Portfolio Unre. Gain/Loss Credit Rating Credit Rating Days To Call/Maturity Duration To Maturity Wells Fargo Sweep Cash WFSWEEP -13,421,707.86 2/15/2020 -13,421,707.86 4.96-13,421,707.86 100.00 4.96 -13,421,707.86 -4.57% 0.00 Wells Fargo Sweep Cash WFSWEEP -1,869,336.23 5/15/2020 -1,869,336.23 4.96-1,869,336.23 100.00 -1,869,336.23 4.96 None None 1 0 -0.64% None 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 1,097,523.25 8/15/2020 1,097,523.25 100.00 1,097,523.25 0.37% None 4.96 1,097,523.25 4.96 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 9/15/2020 -68,402.30 100.00 -68,402.30 -0.02% None -68,402.30 4.96-68,402.30 4.96 0.00 None 1 0 Wells Fargo Sweep Cash 10/1/2020 -15,443,453.60 100.00 -15,443,453.60 -5.26% None WFSWEEP -15,443,453.60 4.96-15,443,453.60 4.96 0.00 None 1 0 Wells Fargo Sweep Cash 10/1/2020 1,059,224.37 100.00 1,059,224.37 0.36% None WFSWEEP 1,059,224.37 4.96 1,059,224.37 4.96 0.00 None 1 0 Wells Fargo Sweep Cash 10/1/2020 3,136,168.46 100.00 3,136,168.46 1.07% None 1 WFSWEEP 3,136,168.46 4.96 3,136,168.46 4.96 0.00 None 0 Wells Fargo Sweep Cash WFSWEEP 1,160,498.97 10/1/2020 1,160,498.97 100.00 1,160,498.97 0.4% None 4.96 1,160,498.97 4.96 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 10/1/2020 642,317.67 100.00 642,317.67 0.22% None 642,317.67 4.96 642,317.67 4.96 0.00 None 1 0 Wells Fargo Sweep Cash 10/15/2020 35,817,348.32 100.00 35,817,348.32 12.2% None WFSWEEP 35,817,348.32 4.96 35,817,348.32 4.96 0.00 None 1 0 Wells Fargo Sweep Cash 11/15/2020 -281,658.90 100.00 -281,658.90 -0.1% None WFSWEEP -281,658.90 4.96-281,658.90 4.96 0.00 None 1 0 Wells Fargo Sweep Cash 11/15/2020 -77,182.55 100.00 -77,182.55 -0.03% None 1 WFSWEEP -77,182.55 4.96-77,182.55 4.96 0.00 None 0 Prepared by Jonathan Rodriguez 9 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 6/30/2023 Description Face Amount I Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash WFSWEEP 5,745,765.97 5/15/2021 4.96 5,745,765.97 5,745,765.97 100.00 4.96 5,745,765.97 1.96% 0.00 Wells Fargo Sweep Cash WFSWEEP -143,005.63 10/15/2021 -143,005.63 4.96-143,005.63 100.00 -143,005.63 4.96 None None 1 0 -0.05% None 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP -1,587,958.65 Wells Fargo Sweep Cash WFSWEEP 10/15/2021 -1,587,958.65 100.00 -1,587,958.65 -0.54% None 4.96-1,587,958.65 4.96 0.00 None 1 0 10/15/2021 -10,365.00 100.00 -10,365.00 0% None -10,365.00 4.96-10,365.00 4.96 0.00 None 1 0 Wells Fargo Sweep Cash 10/15/2021 -393,038.93 100.00 -393,038.93 -0.13% None WFSWEEP -393,038.93 4.96-393,038.93 4.96 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 12/15/2021 51.91 100.00 51.91 0% None 51.91 4.96 51.91 4.96 0.00 None Wells Fargo Sweep Cash WFSWEEP 1 0 6/1/2022 222,728.49 100.00 222,728.49 0.08% None 1 222,728.49 4.96 222,728.49 4.96 0.00 None 0 Wells Fargo Sweep Cash 10/15/2022 -10,204.47 100.00 -10,204.47 0% None WFSWEEP -10,204.47 4.96-10,204.47 4.96 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 10/15/2022 912,332.75 100.00 912,332.75 0.31% None 912,332.75 4.96 912,332.75 4.96 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 10/15/2022 359,392.93 100.00 359,392.93 0.12% None 359,392.93 4.96 359,392.93 4.96 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 10/15/2022 -19,260.72 100.00 -19,260.72 -0.01% None -19,260.72 4.96-19,260.72 4.96 0.00 None 1 0 Wells Fargo Sweep Cash 10/15/2022 -53,493.06 100.00 -53,493.06 -0.02% None 1 WFSWEEP -53,493.06 4.96-53,493.06 4.96 0.00 None 0 Prepared by Jonathan Rodriguez 10 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 6/30/2023 Description Face Amount / CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP Wells Fargo TWDB Cash WF5875 Wells Fargo TWDB Cash -98,893.69 10/15/2022 4.96 -98,893.69 -98,893.69 100.00 4.96 -98,893.69 -0.03% 0.00 3/15/2023 104,771.64 104,771.64 4.96 100.00 104,771.64 104,771.64 4.96 None None 1 0 0.04% None 0.00 None 1 0 9/15/2017 957,254.65 100.00 957,254.65 0.33% None 957,254.65 4.96 957,254.65 4.96 0.00 None 1 0 5/15/2018 1,001,429.13 100.00 1,001,429.13 0.34% None WF6624 1,001,429.13 4.96 1,001,429.13 4.96 0.00 None 1 0 Wells Fargo TWDB Cash 6/16/2020 12,692,900.85 100.00 12,692,900.85 4.32% None WF6100 12,692,900.85 4.91 12,692,900.85 4.91 0.00 None 1 0 Wells Fargo TWDB Cash 4/1/2021 1,791,266.39 100.00 1,791,266.39 0.61% None WF3100 1,791,266.39 4.91 1,791,266.39 4.91 0.00 None 1 0 Wells Fargo TWDB Cash 4/1/2021 33,322,131.18 100.00 33,322,131.18 11.35% None 1 WF3100 33,322,131.18 4.91 33,322,131.18 4.91 0.00 None 0 Wells Fargo TWDB Cash WF2847 6,280,779.44 8/6/2019 6,280,779.44 100.00 6,280,779.44 2.14% None 4.96 6,280,779.44 4.96 0.00 None 1 0 Wells Fargo TWDB Cash WF4102 11/1/2016 158,347.89 100.00 158,347.89 0.05% None 158,347.89 4.96 158,347.89 4.96 0.00 None 1 0 Wells Fargo TWDB Cash WF5883 Sub Total Cash 2,499,774.16 143,697,818.94 3/15/2017 2,499,774.16 4.96 2,499,774.16 100.00 2,499,774.16 0.85% None 4.96 0.00 None 1 0 4.92 143,697,818.94 143,697,818.94 4.92 143,697,818.94 48.94% 0.00 1 0 AMERICAN EXPR NATL BK 2.85 5/13/2024 02589ACN0 Prepared by Jonathan Rodriguez 248,000.00 5/11/2022 2.85 248,000.00 248,000.00 97.82 5.44 242,605.69 968.22 0.08% -5,394.31 None None 318 0.86 11 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 6/30/2023 Description Face Amount / CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity BARCLAYS BANK DELAWARE 2.85 5/20/2024 06740KQH3 248,000.00 5/18/2022 2.85 248,000.00 248,000.00 97.77 5.45 242,469.54 832.67 0.08% -5,530.46 None None 325 0.88 DISCOVER BANK 2.8 5/20/2024 254673D78 5/18/2022 245,000.00 97.73 239,430.72 0.08% None 245,000.00 2.80 245,000.00 5.45 808.16 -5,569.28 None 325 0.88 JP MORGAN CHASE BANK NA 09/22/23-23 3.75 9/2 46593LPF0 9/23/2022 245,000.00 99.63 244,097.29 0.08% None 84 245,000.00 3.75 245,000.00 5.33 2,491.95 -902.71 None 0.23 MORGAN STANLEY BANK NA 3.7 9/22/2023 61690US35 Sub Total Certificate Of Deposit 240,000.00 9/22/2022 240,000.00 99.60 239,033.68 0.08% None 3.70 240,000.00 5.32 6,836.38 -966.32 None 84 0.23 1,226,000.00 3.19 1, 226, 000.00 1,226,000.00 5.40 1, 207, 636.92 11,937.38 0.4% -18,363.08 228 0.62 FFCB 1.94 9/3/2024-22 3133ENQC7 2,000,000.00 3/11/2022 1.94 2,000,000.00 2,000,000.00 95.93 5.56 1,918,641.94 12,610.00 0.68% Moodys-Aaa -81,358.06 S&P -AA+ 431 1.16 FFCB 3.25 6/17/2024 3133ENYX2 Sub Total FFCB Bond 1,000,000.00 6/17/2022 1,000,000.00 3.25 1,000,000.00 97.97 979,656.95 0.34% None 5.44 1,173.61 -20,343.05 None 3,000,000.00 2.38 3,000,000.00 3,000,000.00 2,898,298.89 1.02% 5.52 13,783.61 -101,701.11 353 0.96 405 1.09 FHLB Bond 1 1 FHLB 1.65 12/28/2023-22 3/28/2022 1,000,000.00 98.10 981,017.02 0.34% Moodys-Aaa 3130ARA27 1,000,000.00 1.65 1,000,000.00 5.60 4,216.67 -18,982.98 S&P -AA+ 28 0.49 FHLB 2.5 2/13/2024 3130AFW94 1,250,000.00 5/11/2022 1,250,000.00 98.25 1,228,113.39 0.43% Moodys-Aaa 2.50 1,250,000.00 5.41 11,892.36 -21,886.61 S&P -AA+ 228 0.61 FHLB 3.5 08/28/23-22 3.5 8/28/2023-22 8/30/2022 1,000,000.00 3130ASVY2 1,000,000.00 3.50 1,000,000.00 99.68 996,801.84 0.34% None 59 5.37 11,666.67 -3,198.16 None 0.16 Prepared by Jonathan Rodriguez 12 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 6/30/2023 Description CUSIP Face Amount I Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity FHLB 4.0 09/16/24-22 4 9/16/2024-22 3130ASZG7 1,000,000.00 9/16/2022 4.00 1,000,000.00 1,000,000.00 98.14 5.60 981,443.09 11,555.56 0.34% -18,556.91 None None 78 1.18 FHLB 4.125 09/29/23-22 4.125 9/29/2023-22 3130ATE78 FHLB 4.375 09/29/25-23 4.375 9/29/2025-23 3130ATE29 Sub Total FHLB Bond 9/29/2022 1, 000, 000.00 1,000,000.00 4.13 1,000,000.00 99.61 996,106.46 0.34% None 5.66 10,427.08 -3,893.54 None 91 0.25 9/29/2022 1,000,000.00 1,000,000.00 4.38 1,000,000.00 98.63 986,267.62 0.34% None 91 5.03 11,059.03 -13,732.38 None 2.14 6,250,000.00 6,250,000.00 3.32 6,250,000.00 5.44 6,169, 749.42 60,817.37 2.13% -80,250.58 101 0.8 Local Government Investment Pool LOGIC LGIP 6028909005 LOGIC LGIP 6028909004 LOGIC LGIP 6028909002 24,356,235.55 7/26/2022 24,356,235.55 100.00 24,356,235.55 8.29% None 5.26 24,356,235.55 5.26 0.00 None 0 3,437,359.69 7/26/2022 3,437,359.69 100.00 3,437,359.69 1.17% None 5.26 3,437,359.69 5.26 0.00 None 0 12,232,064.77 7/26/2022 12,232,064.77 100.00 12,232,064.77 4.16% None 1 5.26 12,232,064.77 5.26 0.00 None 0 LOGIC LGIP 6028909003 7,027,801.41 7/26/2022 7,027,801.41 100.00 7,027,801.41 2.39% None 5.26 7,027,801.41 5.26 0.00 None 0 Texas Class LGIP 12/20/2016 65,484.36 100.00 65,484.36 0.02% None 1 TX-01-0615-0001 65,484.36 5.27 65,484.36 5.27 0.00 None 0 Texas Class LGIP 12/20/2016 64.21 100.00 64.21 0% None TX-01-0615-0001 64.21 5.27 64.21 5.27 0.00 None Texas Class LGIP TX-01-0615-0001 12,545,061.19 0 12/20/2016 12, 545, 061.19 5.27 12,545,061.19 100.00 12,545,061.19 4.27% None 1 5.27 0.00 None 0 Texas Class LGIP TX-01-0615-0001 2,099,796.41 12/20/2016 2,099,796.41 100.00 2,099,796.41 0.71% None 1 5.27 2,099,796.41 5.27 0.00 None 0 Prepared by Jonathan Rodriguez 13 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 6/30/2023 Description Face Amount / CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Settlement Date Cost Value Market Price Market Value % Portfolio Unre. Gain/Loss Credit Rating Credit Rating Days To Call/Maturity Duration To Maturity Texas Class LGIP TX-01-0615-0001 90,851.70 1/15/2017 5.27 90,851.70 90,851.70 100.00 5.27 90, 851.70 0.03% 0.00 None None 1 0 Texas Class LGIP TX-01-0615-0001 2,679,520.88 1/15/2017 2,679,520.88 5.27 2,679,520.88 100.00 2,679,520.88 5.27 0.91% None 0.00 None 1 0 Texas Class LGIP TX-01-0615-0001 2,629,188.89 1/15/2017 2,629,188.89 100.00 2,629,188.89 0.9% None 5.27 2,629,188.89 5.27 0.00 None 1 0 Texas Class LGIP TX-01-0615-0001 5,371,923.58 5/15/2017 5,371,923.58 5.27 5,371,923.58 100.00 5,371,923.58 1.83% None 5.27 0.00 None 1 0 Texas Class LGIP TX-01-0615-0001 5/15/2017 299,265.90 100.00 299,265.90 0.1% None 299,265.90 5.27 299,265.90 5.27 0.00 None Texas Class LGIP TX-01-0615-0001 19,523,488.01 1 0 5/15/2017 19,523,488.01 100.00 19,523,488.01 6.65% None 5.27 19,523,488.01 5.27 0.00 None Texas Class LGIP TX-01-0615-0001 3,706,781.46 1 0 6/15/2020 3,706,781.46 100.00 3,706,781.46 1.26% None 1 5.27 3,706,781.46 5.27 0.00 None 0 Texas Class LGIP 12/15/2020 65,243.81 100.00 65,243.81 0.02% None TX-01-0615-0001 65,243.81 5.27 65,243.81 5.27 0.00 None 1 0 Texas Class LGIP TX-01-0615-0001 2,609,445.22 1/15/2022 2,609,445.22 100.00 2,609,445.22 0.89% None 5.27 2,609,445.22 5.27 0.00 None 1 0 Texas Class LGIP TX-01-0615-0001 3,131,334.24 1/15/2022 3,131,334.24 100.00 3,131,334.24 1.07% None 5.27 3,131,334.24 5.27 0.00 None 1 0 Texas Class LGIP TX-01-0615-0001 1/15/2022 2,144.82 100.00 2,144.82 0% None 2,144.82 5.27 2,144.82 5.27 0.00 None 1 0 Texas Class LGIP 1/15/2022 10,437,367.04 100.00 10,437,367.04 3.55% None 1 TX-01-0615-0001 10,437,367.04 5.27 10,437,367.04 5.27 0.00 None 0 Prepared by Jonathan Rodriguez 14 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 6/30/2023 Description CUSIP Face Amount I Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Texas Class LGIP TX-01-0615-0013 2,615,401.50 8/15/2021 5.27 2,615,401.50 2,615,401.50 100.00 5.27 2,615,401.50 0.89% 0.00 None None 1 0 Texas Class LGIP TX-01-0615-0014 3,504,617.10 8/15/2021 3,504,617.10 5.27 3,504,617.10 100.00 3,504,617.10 5.27 1.19% None 0.00 None 1 0 Texas Class LGIP TX-01-0615-0009 Texas Class LGIP TX-01-0615-0007 8/11/2020 2,877,300.84 100.00 2,877,300.84 0.98% None 2,877,300.84 5.27 2,877,300.84 5.27 0.00 None 1 0 9/19/2019 1,430,016.13 100.00 1,430,016.13 0.49% None 1,430,016.13 5.27 1,430,016.13 5.27 0.00 None Texas Class LGIP TX-01-0615-0007 1 0 9/19/2019 3,456.98 100.00 3,456.98 0% None 3,456.98 5.27 3,456.98 5.27 0.00 None 1 0 Texas Class LGIP TX-01-0615-0007 9/19/2019 594,321.31 100.00 594,321.31 0.2% None 594,321.31 5.27 594,321.31 5.27 0.00 None Texas Class LGIP TX-01-0615-0011 1,968,792.64 1 0 8/11/2020 1,968,792.64 100.00 1,968,792.64 0.67% None 1 5.27 1,968,792.64 5.27 0.00 None 0 Texas Class LGIP TX-01-0615-0005 Texas Class LGIP TX-01-0615-0004 2,762,304.67 9/15/2018 2,762,304.67 100.00 2,762,304.67 0.94% None 5.27 2,762,304.67 5.27 0.00 None 1 0 9/15/2018 7,405.82 100.00 7,405.82 0% None 7,405.82 5.27 7,405.82 5.27 0.00 None 1 0 Texas Class LGIP TX-01-0615-0015 Texas Class LGIP TX-01-0615-0006 1,065,551.43 8/15/2021 1,065,551.43 100.00 1,065,551.43 0.36% None 5.27 1,065,551.43 5.27 0.00 None 1 0 9/15/2018 247,253.43 100.00 247,253.43 0.08% None 247,253 43 5.27 247,253.43 5.27 0.00 None 1 0 Texas Class LGIP 8/11/2020 TX-01-0615-0010 480,900.86 100.00 480,900.86 0.16% None 1 480,900.86 5.27 480,900.86 5.27 0.00 None 0 Prepared by Jonathan Rodriguez 15 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 6/30/2023 Description CUSIP Face Amount I Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity TexSTAR LGIP 02000-20190 1,468,911.45 9/19/2019 5.08 1,468,911.45 1,468,911.45 100.00 5.08 1,468,911.45 0.5% 0.00 TexSTAR LGIP 02000-20191 9/27/2019 510,922.39 100.00 510,922.39 510,922.39 5.08 510,922.39 5.08 None None 1 0 0.17% None 0.00 None 1 0 TexSTAR LGIP 02000-20191 TexSTAR LGIP 02000-11110 9/27/2019 530,174.75 100.00 530,174.75 0.18% None 530,174.75 5.08 530,174.75 5.08 0.00 None 1 0 8/26/2016 1,731,338.85 100.00 1,731,338.85 0.59% S&P -AAA 1,731,338.85 5.08 1,731,338.85 5.08 0.00 None TexSTAR LGIP 02000-11110 1,222,292.60 1 0 8/26/2016 1,222,292.60 100.00 1,222,292.60 0.42% S&P -AAA 1 5.08 1,222,292.60 5.08 0.00 None 0 TexSTAR LGIP 02000-20192 4,182,688.10 9/27/2019 4,182,688.10 100.00 4,182,688.10 1.42% None 5.08 4,182,688.10 5.08 0.00 None Sub Total Local Government Investment Pool 139,514,073.99 5.25 139,514,073.99 139,514,073.99 5.25 139,514,073.99 1 0 47.46% 1 0.00 0 TOTAL PORTFOLIO 293,687,892.93 5.01 293,687,892.93 293,687,892.93 5.10 293,487,578.16 86,538.36 100.00% -200,314.77 8 0.03 Prepared by Jonathan Rodriguez 16 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 6/30/2023 Description CUSIP Face Amount I Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity CO: General Fund AMERICAN EXPR NATL BK 2.85 5/13/2024 02589ACN0 BARCLAYS BANK DELAWARE 2.85 5/20/2024 06740KQH3 248,000.00 2.85 248,000.00 5.45 832.67 -5,530.46 None 0.88 248,000 00 5/11/2022 248,000.00 2.85 248,000.00 97.82 5.44 242,605.69 968.22 0.08% -5,394.31 None None 318 0.86 DISCOVER BANK 2.8 5/20/2024 254673D78 5/18/2022 248,000.00 97.77 242,469.54 0.08% None 325 5/18/2022 245,000.00 97.73 239,430.72 0.08% None 325 245,000.00 2.80 245,000.00 5.45 808.16 -5,569.28 None 0.88 FFCB 1.94 9/3/2024-22 3133ENQC7 2,000,000.00 3/11/2022 2,000,000.00 1.94 2,000,000.00 95.93 1,918,641.94 0.68% Moodys-Aaa 5.56 12,610.00 -81,358.06 S&P -AA+ 431 1.16 FFCB 3.25 6/17/2024 3133ENYX2 1,000,000.00 6/17/2022 1,000,000.00 3.25 1,000,000.00 97.97 979,656.95 0.34% None 353 5.44 1,173.61 -20,343.05 None 0.96 FHLB 1.65 12/28/2023-22 3/28/2022 1,000,000.00 98.10 981,017.02 0.34% Moodys-Aaa 3130ARA27 1,000,000.00 1.65 1,000,000.00 5.60 4,216.67 -18,982.98 S&P -AA+ 28 0.49 FHLB 2.5 2/13/2024 3130AFW94 1,250,000.00 5/11/2022 1,250,000.00 98.25 1,228,113.39 0.43% Moodys-Aaa 2.50 1,250,000.00 5.41 11,892.36 -21,886.61 S&P -AA+ 228 0.61 FHLB 3.5 08/28/23-22 3.5 8/28/2023-22 8/30/2022 1,000,000.00 3130ASVY2 1,000,000.00 3.50 1,000,000.00 99.68 996,801.84 0.34% None 5.37 11,666.67 -3,198.16 None 59 0.16 FHLB 4.0 09/16/24-22 4 9/16/2024-22 9/16/2022 1,000,000.00 3130ASZG7 1,000,000.00 4.00 1,000,000.00 98.14 981,443.09 0.34% None 5.60 11,555.56 -18,556.91 None 78 1.18 FHLB 4.125 09/29/23-22 4.125 9/29/2023-22 3130ATE78 FHLB 4.375 09/29/25-23 4.375 9/29/2025-23 3130ATE29 9/29/2022 1,000,000.00 1,000,000.00 4.13 1,000,000.00 99.61 996,106.46 0.34% None 5.66 10,427.08 -3,893.54 None 9/29/2022 1,000,000.00 1,000,000.00 4.38 1,000,000.00 91 0.25 98.63 986,267.62 0.34% None 5.03 11,059.03 -13,732.38 None 91 2.14 JP MORGAN CHASE BANK NA 09/22/23-23 3.75 9/2 46593LPF0 9/23/2022 245,000.00 99.63 244,097.29 0.08% None 84 245,000.00 3.75 245,000.00 5.33 2,491.95 -902.71 None 0.23 17 Prepared by Jonathan Rodriguez City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 6/30/2023 Description Face Amount I Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity MORGAN STANLEY BANK NA 3.7 9/22/2023 61690US35 240,000.00 9/22/2022 3.70 240,000.00 240,000.00 99.60 5.32 239,033.68 6,836.38 0.08% -966.32 None None 84 0.23 Texas Class LGIP TX-01-0615-0001 19,523,488.01 5/15/2017 19,523,488.01 100.00 19,523,488.01 6.65% None 5.27 19,523,488.01 5.27 0.00 None 0 Wells Fargo Sweep Cash WFSWEEP Sub Total 100: General Fund 10,430,687.51 5/31/2006 10,430,687.51 100.00 10,430,687.51 3.55% None 4.96 10,430,687.51 4.96 40,430,175.52 4.61 40,430,175.52 40,430,175.52 5.24 1 0.00 None 0 40,229,860.75 86,538.36 13.75% -200,314.77 53 0.22 200: Debt Services Texas Class LGIP 1/15/2017 90,851.70 100.00 90,851.70 0.03 % None 1 TX-01-0615-0001 90,851.70 5.27 90,851.70 5.27 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 9,762,714.03 100.00 9,762,714 03 3.32% None 1 WFSWEEP 9,762,714.03 4.96 9,762,714.03 4.96 0.00 None 0 9,853,565.73 9,853,565.73 3.35% 1 Sub Total 200: Debt Services 9,853,565.73 4.96 9,853,565.73 4.96 0.00 0 305: Hotel/Motel Occupancy Texas Class LGIP TX-01-0615-0001 Wells Fargo Sweep Cash WFSWEEP 5,371,923.58 5/15/2017 5,371,923.58 5.27 5,371,923.58 100.00 5,371,923.58 1.83% None 5.27 0.00 None 1 0 Sub Total 305: Hotel/Motel Occupancy 5/31/2006 1,671,410.92 100.00 1,671,410.92 0.57% None 1 1,671,410.92 4.96 1,671,410.92 4.96 0.00 None 0 7,043,334.50 7,043,334.50 2.4% 1 7,043,334.50 5.19 7,043,334.50 5.19 0.00 0 310: Municipal Court Security Wells Fargo Sweep Cash 5/31/2006 60,507.27 100.00 60,507.27 0.02% None 1 WFSWEEP Sub Total 310: Municipal Court Security Prepared by Jonathan Rodriguez 60,507.27 4.96 60,507.27 4.96 0.00 None 0 60,507.27 60,507.27 0.02% 1 60,507.27 4.96 60,507.27 4.96 0.00 0 18 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 6/30/2023 Description CUSIP Face Amount / Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity 315: City Wide Donation Wells Fargo Sweep Cash WFSWEEP Sub Total 315: City Wide Donation 229,257.55 5/31/2006 229,257.55 4.96 229,257.55 229,257.55 4.96 229,257.55 100.00 4.96 229,257.55 4.96 229,257.55 0.08% 0.00 229,257.55 0.08% 0.00 None None 0 1 0 320: Court Technology Wells Fargo Sweep Cash 5/31/2006 1,321.36 100.00 1,321.36 0% None WFSWEEP 1,321.36 4.96 1,321.36 4.96 0.00 None Sub Total 320: Court Technology 1,321.36 4.96 1,321.36 1,321.36 4.96 1,321.36 0% 1 0 1 0.00 0 325: Street Assessment Wells Fargo Sweep Cash 12/15/2021 51.91 100.00 51.91 0% None WFSWEEP Sub Total 325: Street Assessment 51.91 4.96 51.91 4.96 51.91 4.96 0.00 None 1 0 51.91 51.91 0% 1 51.91 4.96 0.00 0 330: Park Donations Wells Fargo Sweep Cash WFSWEEP Sub Total 330: Park Donations 5/31/2006 69,932.24 100.00 69,932.24 0.02% None 69,932.24 4.96 69,932.24 4.96 0.00 None 1 0 69,932.24 69,932.24 0.02% 1 69,932.24 4.96 69,932.24 4.96 0.00 0 331: Tree Trust Fund NEN Wells Fargo Sweep Cash WFSWEEP Sub Total 331: Tree Trust Fund 5/31/2006 1,544,005.03 100.00 1,544,005.03 0.53% None 1 1,544,005.03 4.96 1,544,005.03 4.96 0.00 None 0 1,544,005.03 1,544,005.03 0.53% 1 1,544,005.03 4.96 1,544,005.03 4.96 0.00 0 332: Parks Financl Asstance Donations Wells Fargo Sweep Cash 10/15/2019 -8,156.41 100.00 -8,156.41 0% None WFSWEEP -8,156.41 4.96-8,156.41 4.96 0.00 None Prepared by Jonathan Rodriguez 1 0 19 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 6/30/2023 Description CUSIP Face Amount / Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Sub Total 332: Parks Financl Asstance Donations -8,156.41 4.96 -8,156.41 -8,156.41 4.96 -8,156.41 0% 0.00 1 0 335: Police State Seizure Wells Fargo Sweep Cash WFSWEEP Sub Total 335: Police State Seizure 5/31/2006 180,747.86 100.00 180,747.86 0.06% None 180,747.86 4.96 180,747.86 4.96 0.00 None 180,747.86 180,747.86 4.96 180,747.86 4.96 180,747.86 0.06% 0.00 1 0 1 0 336: Federal Police Fund Wells Fargo Sweep Cash WFSWEEP Sub Total 336: Federal Police Fund 5/31/2006 240,321.95 4.96 240,321.95 4.96 240,321.95 100.00 240,321.95 0.08% None 240,321.95 4.96 0.00 None 1 0 240,321.95 240,321.95 0.08% 1 240,321.95 4.96 0.00 0 337: Community Safety Fund Wells Fargo Sweep Cash 6/1/2022 222,728.49 100.00 222,728.49 0.08% None WFSWEEP Sub Total 337: Community Safety Fund 222,728.49 4.96 222,728.49 4.96 222,728.49 4.96 0.00 None 222,728.49 222,728.49 222,728.49 4.96 1 0 0.08% 1 0.00 0 340: Park & Rec Development Wells Fargo Sweep Cash WFSWEEP Sub Total 340: Park & Rec Development 5/31/2006 633,630.41 100.00 633,630.41 0.22% None 633,630.41 4.96 633,630.41 4.96 0.00 None 633,630.41 4.96 633,630.41 633,630.41 633,630.41 4.96 1 0 0.22% 1 0.00 0 345: Sidewalk Fund Wells Fargo Sweep Cash 5/31/2006 65,377.86 100.00 65,377.86 0.02% None WFSWEEP 65,377.86 4.96 65,377.86 4.96 0.00 None Sub Total 345: Sidewalk Fund 65,377.86 4.96 65,377.86 65,377.86 65,377.86 4.96 1 0 0.02% 1 0.00 0 346: Drainage Maintenance Fund Prepared by Jonathan Rodriguez 20 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 6/30/2023 Description CUSIP Face Amount / Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash WFSWEEP Sub Total 346: Drainage Maintenance Fund 359,392.93 10/15/2022 4.96 359,392.93 4.96 359,392.93 359,392.93 100.00 4.96 359,392.93 359,392.93 4.96 359,392.93 359,392.93 0.12% 0.00 0.12% 0.00 None None 1 0 1 0 350: Grant Fund Wells Fargo Sweep Cash WFSWEEP Sub Total 350: Grant Fund 5/31/2006 -362,762.63 4.96 -362,762.63 4.96 -362,762.63 -362,762.63 -362,762.63 -362,762.63 100.00 -362,762.63 -0.12% None 4.96 0.00 None 4.96 1 0 -362,762.63 -0.12% 1 0.00 0 351: CDBG Fund Wells Fargo Sweep Cash 11/15/2015 -31,988.90 100.00 -31,988.90 -0.01% None WFSWEEP Sub Total 351: CDBG Fund -31,988.90 4.96 -31,988.90 4.96 -31,988.90 4.96 0.00 None -31,988.90 -31,988.90 -31,988.90 4.96 1 0 0.00 0 352: CDBG - Disaster Recovery Fund Wells Fargo Sweep Cash 11/15/2020 WFSWEEP Sub Total 352: CDBG - Disaster Recovery Fund -281,658.90 4.96 -281,658.90 4.96 -281,658.90 -281,658.90 -281,658.90 -281,658.90 100.00 -281,658.90 -0.1% None 4.96 4.96 -281,658.90 0.00 None 1 0 -0.1% 0.00 0 353: Disaster Recovery Fund Wells Fargo Sweep Cash 9/15/2020 -68,402.30 100.00 -68,402.30 -0.02% None WFSWEEP -68,402.30 4.96-68,402.30 4.96 0.00 None Sub Total 353: Disaster Recovery Fund -68,402.30 4.96 -68,402.30 -68,402.30 -68,402.30 4.96 1 0 -0.02% 1 0.00 0 354: Hazard Mitigation Fund Wells Fargo Sweep Cash 11/15/2020 -77,182.55 100.00 -77,182.55 -0.03% None WFSWEEP -77,182.55 4.96-77,182.55 4.96 0.00 None Prepared by Jonathan Rodriguez 1 0 21 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 6/30/2023 Description CUSIP Face Amount / Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Sub Total 354: Hazard Mitigation Fund -77,182.55 4.96 -77,182.55 -77,182.55 4.96 -77,182.55 -0.03% 0.00 1 0 355: Coronavirus Relief Fund Wells Fargo Sweep Cash WFSWEEP Sub Total 355: Coronavirus Relief Fund -1,869,336.23 5/15/2020 -1,869,336.23 100.00 -1,869,336.23 -0.64% None 4.96-1,869,336.23 4.96 0.00 None -1,869,336.23 4.96 -1,869,336.23 -1,869,336.23 4.96 -1,869,336.23-0.64°/ 0.00 1 0 0 356: ARPA Fund Wells Fargo Sweep Cash 5/15/2021 5,745,765.97 100.00 5,745,765.97 1.96% None WFSWEEP 5,745,765.97 4.96 5,745,765.97 4.96 Sub Total 356: ARPA Fund 5,745,765.97 4.96 5,745,765.97 5,745,765.97 4.96 0.00 None 1 0 5,745,765.97 1.96% 0.00 1 0 357: Opi-oid Settlement Wells Fargo Sweep Cash WFSWEEP Sub Total 357: Opi-oid Settlement 3/15/2023 104, 771.64 100.00 104, 771.64 104,771.64 4.96 104,771.64 4.96 104,771.64 4.96 104,771.64 104,771.64 104,771.64 4.96 0.04% 0.00 0.04% 0.00 None None 1 0 1 0 360: Traffic Impact Improvement Wells Fargo Sweep Cash 5/31/2006 336,779.62 100.00 336,779.62 0.11% None WFSWEEP 336,779.62 4.96 336,779.62 4.96 0.00 None Sub Total 360: Traffic Impact Improvement 336,779.62 4.96 336,779.62 336,779.62 4.96 336,779.62 0.11% 1 0 1 0.00 0 365: Court Juvenile Mgmt Wells Fargo Sweep Cash WFSWEEP Sub Total 365: Court Juvenile Mgmt 9/15/2009 -3,024.58 100.00 -3,024.58 0% None -3,024.58 4.96-3,024.58 4.96 0.00 None -3,024.58 4.96 1 0 -3,024.58 -3,024.58 0% 1 -3,024.58 4.96 0.00 0 366: Municipal Jury Fund Prepared by Jonathan Rodriguez 22 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 6/30/2023 Description CUSIP Face Amount / Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash WFSWEEP Sub Total 366: Municipal Jury Fund 2,325.66 1/15/2020 4.96 2,325.66 4.96 2,325.66 2,325.66 2,325.66 100.00 4.96 2,325.66 4.96 2,325.66 2,325.66 0% 0.00 0% 0.00 None None 1 0 1 0 370: Municipal Channel Texas Class LGIP TX-01-0615-0001 Wells Fargo Sweep Cash WFSWEEP Sub Total 370: Municipal Channel 5/15/2017 299,265.90 100.00 299,265.90 299,265.90 5.27 299,265.90 5.27 4/15/2012 155, 082.62 100.00 155, 082.62 155,082.62 4.96 155,082.62 4.96 454,348.52 5.16 0.1% None 1 0.00 None 0 0.05% None 1 0.00 None 0 454,348.52 454,348.52 0.15% 1 454,348.52 5.16 0.00 0 380: Regional Detention Wells Fargo Sweep Cash 5/31/2006 204,844.52 100.00 204,844.52 0.07% None WFSWEEP Sub Total 380: Regional Detention 500: Capital Projects 204,844.52 4.96 204,844.52 4.96 0.00 None 1 0 204,844.52 204,844.52 0.07% 1 204,844.52 4.96 204,844.52 4.96 0.00 0 Texas Class LGIP 1/15/2017 2,679,520.88 100.00 2,679,520.88 0.91% None 1 TX-01-0615-0001 2,679,520.88 5.27 2,679,520.88 5.27 0.00 None 0 Wells Fargo Cash 8/12/2020 2,771.11 100.00 2,771.11 0% None 1 WF3025 2,771.11 0.00 2,771.11 0.00 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 6,472,731.01 100.00 6,472,731.01 2.2% None 1 WFSWEEP 6,472,731.01 4.96 6,472,731.01 4.96 0.00 None 0 9,155,023.00 9,155,023.00 3.11% 1 Sub Total 500: Capital Projects 9,155,023.00 5.05 9,155,023.00 5.05 0.00 0 501: Certificates of Obligation Prepared by Jonathan Rodriguez 23 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 6/30/2023 Description Face Amount / CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Texas Class LGIP TX-01-0615-0001 2,099,796.41 Texas Class LGIP TX-01-0615-0007 12/20/2016 5.27 2,099,796.41 2,099,796.41 100.00 5.27 2,099,796.41 0.71% 0.00 None None 1 0 9/19/2019 594,321.31 5.27 594,321.31 100.00 594,321.31 5.27 Texas Class LGIP TX-01-0615-0006 594,321.31 0.2% None 0.00 None 1 0 9/15/2018 247,253.43 100.00 247,253.43 0.08% None 247,253.43 5.27 247,253.43 5.27 0.00 None 1 0 TexSTAR LGIP 9/27/2019 530,174.75 100.00 530,174.75 0.18% None 02000-20191 530,174.75 5.08 530,174.75 5.08 0.00 None TexSTAR LGIP 02000-11110 1,222,292.60 1 0 8/26/2016 1,222,292.60 100.00 1,222,292.60 0.42% S&P -AAA 1 5.08 1,222,292.60 5.08 0.00 None 0 TexSTAR LGIP 02000-20192 Wells Fargo Sweep Cash WFSWEEP 4,182,688.10 9/27/2019 4,182,688.10 100.00 4,182,688.10 1.42% None 5.08 4,182,688.10 5.08 0.00 None Sub Total 501: Certificates of Obligation 1,672,622.03 10,549,148.63 1 0 5/31/2006 1,672,622.03 100.00 1,672,622.03 0.57% None 4.96 1,672,622.03 5.11 4.96 0.00 None 1 0 10,549,148.63 10, 549,148.63 5.11 10,549,148.63 3.58% 0.00 1 0 503: Certificates of Obligation 2006 Wells Fargo Sweep Cash WFSWEEP Sub Total 503: Certificates of Obligation 2006 Texas Class LGIP TX-01-0615-0001 Texas Class LGIP TX-01-0615-0005 15,642.60 6/30/2006 15,642.60 100.00 15,642.60 0.01% None 4.96 15,642.60 15,642.60 12,545,061.19 4.96 15, 642.60 15,642.60 4.96 0.00 None 0 4.96 15,642.60 0.01% 0.00 12,545,061.19 100.00 12,545,061.19 4.27% None 5.27 12,545,061.19 5.27 0.00 None 1 0 0 2,762,304.67 9/15/2018 2,762,304.67 5.27 2,762,304.67 100.00 2,762,304.67 5.27 0.94% 0.00 None None 1 0 Prepared by Jonathan Rodriguez 24 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 6/30/2023 Description CUSIP Face Amount / Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity TexSTAR LGIP 02000-20190 TexSTAR LGIP 02000-20191 TexSTAR LGIP 02000-11110 Wells Fargo Sweep Cash 1,468,911.45 510,922.39 1,731,338.85 9/19/2019 5.08 9/27/2019 5.08 1,468,911.45 1,468,911.45 510,922.39 510,922.39 100.00 5.08 1,468,911.45 100.00 510,922.39 5.08 8/26/2016 1, 731, 338.85 100.00 1, 731, 338.85 5.08 1, 731, 338.85 5.08 10/30/2008 6,455,392.35 100.00 6,455,392.35 WFSWEEP 6,455,392.35 4.96 6,455,392.35 4.96 Sub Total 506: General Obligation 25,473,930.90 25,473,930.90 25,473,930.90 5.16 25,473,930.90 5.16 0.5% 0.00 0.17% 0.00 0.59% 0.00 2.2% 0.00 8.67% None None None None S&P -AAA None None None 1 0 1 0 1 0 1 0 1 0.00 0 507: General Obligation Series 2020 Wells Fargo Sweep Cash 10/15/2019 -8,436,562.92 WFSWEEP -8,436,562.92 4.96-8,436,562.92 Sub Total 507: General Obligation Series 2020 -8,436,562.92 4.96 -8,436,562.92 -8,436,562.92 100.00 -8,436,562.92 -2.87% None 1 4.96 4.96 0.00 None 0 -8,436,562.92 -2.87% 1 0.00 0 508: Certificates of Oblg Series 2020 Texas Class LGIP 8/11/2020 2,877,300.84 100.00 2,877,300.84 0.98% None 1 TX-01-0615-0009 2,877,300.84 5.27 2,877,300.84 5.27 0.00 None 0 Wells Fargo Sweep Cash 10/15/2019 411,388.23 100.00 411,388.23 0.14% None 1 WFSWEEP 411,388.23 4.96 411,388.23 4.96 0.00 None 0 3,288,689.07 3,288,689.07 1.12% 1 Sub Total 508: Certificates of Oblg Series 3,288,689.07 5.23 3,288,689.07 5.23 0.00 0 2020 509: General Obligation Series 2021 Texas Class LGIP TX-01-0615-0015 Prepared by Jonathan Rodriguez 1, 065, 551.43 8/15/2021 1,065,551.43 5.27 1, 065, 551.43 100.00 1,065,551.43 0.36% None 5.27 0.00 None 1 0 25 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 6/30/2023 Description CUSIP Face Amount / Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash WFSWEEP Sub Total 509: General Obligation Series 2021 963,638.32 10/15/2019 4.96 2,029,189.75 5.12 963,638.32 963,638.32 2,029,189.75 2,029,189.75 100.00 4.96 5.12 963,638 32 2,029,189.75 0.33% 0.00 0.69% 0.00 None None 1 0 1 0 511: PEDC Capital Projects Wells Fargo Sweep Cash WFSWEEP Sub Total 511: PEDC Capital Projects 12/15/2018 90,748.54 4.96 90,748.54 4.96 90,748.54 100.00 90,748.54 0.03% None 90,748.54 4.96 0.00 None 1 0 90,748.54 90,748.54 0.03% 1 90,748.54 4.96 0.00 0 512: Certificates of Oblg Series 2021 Wells Fargo Sweep Cash 2/15/2020 -13,421,707.86 100.00 -13,421,707.86 -4.57% None WFSWEEP -13,421,707.86 4.96-13,421,707.86 4.96 0.00 None Sub Total 512: Certificates of Oblg Series 2021 -13,421,707.86 4.96 -13,421,707.86 -13,421,707.86 4.96 -13,421,707.86 1 0 -4.57% 1 0.00 0 513: General Obligation Series 2022 LOGIC LGIP 7/26/2022 12,232,064.77 100.00 12,232,064.77 4.16% None 1 6028909002 12,232,064.77 5.26 12,232,064.77 5.26 0.00 None 0 Wells Fargo Sweep Cash 10/1/2020 1,059,224.37 100.00 1,059,224.37 0.36% None 1 WFSWEEP 1,059,224.37 4.96 1,059,224.37 4.96 0.00 None 0 13,291,289.14 13,291,289.14 4.52% 1 Sub Total 513: General Obligation Series 13,291,289.14 5.23 13,291,289.14 5.23 0.00 0 2022 514: Infrastructure Reinvestment Fund Wells Fargo Sweep Cash WFSWEEP Sub Total 514: Infrastructure Reinvestment Fund 12/15/2019 1,045,110.03 1,045,110.03 4.96 1,045,110.03 1,045,110.03 1,045,110.03 4.96 1,045,110.03 100.00 1,045,110.03 0.36% None 1 4.96 0.00 None 0 4.96 1,045,110.03 0.36% 1 0.00 0 515: Certificates of Oblig 2020 TIRZ Prepared by Jonathan Rodriguez 26 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 6/30/2023 Description Face Amount / CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Texas Class LGIP TX-01-0615-0010 Wells Fargo Sweep Cash WFSWEEP Sub Total 515: Certificates of Oblig 2020 TIRZ 480,900.86 8/11/2020 5.27 480,900.86 480,900.86 100.00 5.27 480,900 86 0.16% 0.00 1,097,523.25 8/15/2020 1,097,523.25 4.96 1,097,523.25 100.00 1,097,523.25 4.96 0.37% 0.00 None None 1 0 None None 1 0 1,578,424.11 5.05 1,578,424.11 1,578,424.11 5.05 1,578,424.11 0.53% 0.00 1 0 516: Certificates of Oblig 2021 TIRZ Texas Class LGIP TX-01-0615-0013 Wells Fargo Sweep Cash WFSWEEP Sub Total 516: Certificates of Oblig 2021 TIRZ 8/15/2021 2,615,401.50 100.00 2,615,401.50 0.89% None 1 2,615,401.50 5.27 2,615,401.50 5.27 0.00 None 0 10/1/2020 642,317.67 642,317.67 4.96 642,317.67 3,257,719.17 5.21 100.00 642,317.67 0.22% None 4.96 3,257,719.17 3,257,719.17 5.21 3,257,719.17 0.00 None 1 0 0.00 1 0 517: Certificates of Obligation 2022 LOGIC LGIP 6028909003 Wells Fargo Sweep Cash WFSWEEP 7,027,801.41 7/26/2022 7,027,801.41 100.00 7,027,801.41 2.39% None 5.26 7,027,801.41 5.26 0.00 None 0 1,160,498.97 10/1/2020 1,160,498.97 4.96 1,160,498.97 Sub Total 517: Certificates of Obligation 2022 8,188, 300.38 5.21 8,188, 300.38 8,188, 300.38 100.00 1,160,498.97 4.96 0.4% 0.00 None None 1 0 5.21 8,188,300.38 2.79% 0.00 1 0 518: Certificates of Oblig 2022 TIRZ LOGIC LGIP 6028909004 Wells Fargo Sweep Cash WFSWEEP Prepared by Jonathan Rodriguez 3,437,359.69 7/26/2022 3,437,359.69 100.00 3,437,359.69 1.17% None 5.26 3,437,359.69 5.26 0.00 None 0 3,136,168.46 10/1/2020 3,136,168.46 4.96 3,136,168.46 100.00 3,136,168.46 4.96 1.07% None 0.00 None 1 0 27 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 6/30/2023 Description CUSIP Face Amount I Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Sub Total 518: Certificates of Oblig 2022 TIRZ 6,573,528.15 5.11 6,573,528.15 6,573,528.15 5.11 6,573,528.15 2.24% 0.00 1 0 519: General Obligation Series 2023 Wells Fargo Sweep Cash WFSWEEP Sub Total 519: General Obligation Series 2023 520: Certificates of Oblg Series 2023 Wells Fargo Sweep Cash WFSWEEP Sub Total 520: Certificates of Oblg Series 2023 10/15/2021 -143,005.63 -143,005.63 4.96-143,005.63 -143,005.63 100.00 -143,005.63 -0.05% None 4.96 0.00 None 0 -143,005.63 4.96-143,005.63 4.96 -143,005.63 -0.05% 0.00 1 0 -1,587,958.65 -1,587,958.65 10/15/2021 -1,587,958.65 100.00 -1,587,958.65 -0.54% None 4.96-1,587,958.65 4.96 0.00 None 1 0 -1,587,958.65 4.96-1,587,958.65 4.96 -1,587,958.65 -0.54% 1 0.00 0 521: Drainage CIP Fund Wells Fargo Sweep Cash 10/15/2022 -19,260.72 100.00 -19,260.72 -0.01% None 1 WFSWEEP -19,260.72 4.96-19,260.72 4.96 0.00 None 0 Sub Total 521: Drainage CIP Fund -19,260.72 4.96 -19,260.72 -19,260.72 -0.01% 1 -19,260.72 4.96 0.00 0 524: TIRZ CO Series 2023 1 Wells Fargo Sweep Cash 10/15/2022 -10,204.47 100.00 -10,204.47 0% None WFSWEEP -10,204.47 4.96-10,204.47 4.96 0.00 None 1 0 -10,204.47 -10,204.47 0% 1 Sub Total 524: TIRZ CO Series 2023 -10,204.47 4.96-10,204.47 4.96 0.00 0 550: W/S Impact Fee Texas Class LGIP 12/20/2016 64.21 100.00 64.21 0% None 1 TX-01-0615-0001 64.21 5.27 64.21 5.27 0.00 None 0 Texas Class LGIP 9/19/2019 1,430,016.13 100.00 1,430,016.13 0.49% None 1 TX-01-0615-0007 1,430,016.13 5.27 1,430,016.13 5.27 0.00 None 0 Prepared by Jonathan Rodriguez 28 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 6/30/2023 Description CUSIP Face Amount I Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash WFSWEEP Wells Fargo TWDB Cash WF6624 Wells Fargo TWDB Cash WF3100 2,549,843.61 5/31/2006 4.96 2,549,843.61 2,549,843.61 100.00 4.96 2,549,843.61 0.87% 0.00 None None 1 0 5/15/2018 1,001,429.13 1,001,429.13 4.96 1,001,429.13 100.00 1,001,429.13 4.96 0.34% 0.00 None None 1 0 4/1/2021 1,791,266.39 100.00 1,791,266.39 0.61% None 1,791,266.39 4.91 1,791,266.39 4.91 0.00 None 1 0 Wells Fargo TWDB Cash 8/6/2019 6,280,779.44 100.00 6,280,779.44 2.14% None WF2847 6,280,779.44 4.96 6,280,779.44 4.96 0.00 None 1 0 Wells Fargo TWDB Cash 11/1/2016 158,347.89 100.00 158,347.89 WF4102 158,347.89 4.96 158,347.89 4.96 Wells Fargo TWDB Cash 3/15/2017 2,499,774.16 100.00 2,499,774 16 WF5883 2,499,774.16 4.96 2,499,774.16 4.96 15, 711, 520.96 15, 711, 520.96 Sub Total 550: W/S Impact Fee 15,711,520.96 4.98 15,711,520.96 4.98 0.05% 0.00 None None 1 0 0.85% 0.00 None None 1 0 5.35% 0.00 1 0 551: Water Impact Fee Fund Texas Class LGIP TX-01-0615-0001 Wells Fargo Sweep Cash WFSWEEP Sub Total 551: Water Impact Fee Fund 3,131, 334.24 610,754.66 1/15/2022 3,131,334.24 100.00 3,131,334.24 1.07% None 5.27 3,131,334.24 5.27 0.00 None 1 0 1/15/2020 610,754.66 100.00 610,754.66 0.21% None 4.96 610,754.66 4.96 0.00 None 1 0 3,742,088.90 5.22 3,742,088.90 3,742,088.90 5.22 3,742,088.90 1.28% 0.00 1 0 Texas Class LGIP TX-01-0615-0001 Wells Fargo Sweep Cash WFSWEEP Prepared by Jonathan Rodriguez 2,609,445.22 2,824,260 99 1/15/2022 2,609,445.22 100.00 2,609,445.22 5.27 2,609,445.22 5.27 0.89% 0.00 1/15/2020 2,824,260.99 4.96 2,824,260.99 100.00 2,824,260.99 4.96 0.96% 0.00 None None None None 0 1 0 29 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 6/30/2023 Description CUSIP Face Amount I Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Sub Total 552: Waste Water Impact Fee Fund 5,433,706.21 5.11 5,433,706.21 5,433,706.21 5.11 5,433,706.21 1.85% 0.00 1 0 565: Revenue Bonds 1999 & 2003 Texas Class LGIP TX-01-0615-0001 Texas Class LGIP 2,629,188.89 1/15/2017 2,629,188.89 100.00 2,629,188.89 0.9% None 5.27 2,629,188.89 5.27 0.00 None 1 0 9/19/2019 3,456.98 100.00 3,456.98 0% None TX-01-0615-0007 3,456.98 5.27 3,456.98 5.27 1 0.00 None 0 Texas Class LGIP 9/15/2018 7,405.82 100.00 7,405.82 0% None TX-01-0615-0004 7,405.82 5.27 7,405.82 5.27 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP Wells Fargo TWDB Cash WF5875 Sub Total 565: Revenue Bonds 1999 & 2003 1,078,329.39 5/31/2006 1,078,329.39 100.00 1,078,329.39 0.37% None 1 4.96 1,078,329.39 4.96 0.00 None 0 957,254.65 9/15/2017 957,254.65 100.00 957,254.65 0.33% None 4.96 4,675,635.73 5.13 957,254.65 4.96 0.00 None 1 0 4,675,635.73 4,675,635.73 5.13 4,675,635.73 1.6% 0.00 1 0 Texas Class LGIP TX-01-0615-0011 Wells Fargo Sweep Cash WFSWEEP Sub Total 566: Revenue Bonds Series 2020 1,968,792.64 8/11/2020 1,968,792.64 100.00 1,968,792.64 0.67% None 5.27 1,968,792.64 5.27 0.00 None 0 513,601.76 10/15/2019 513,601.76 4.96 513,601.76 2,482,394.40 5.20 2,482,394.40 2,482,394.40 100.00 4.96 5.20 513,601.76 2,482,394.40 0.17% 0.00 None None 1 0 0.84% 0.00 1 0 567: Water Drinking Bonds Series 2020 Texas Class LGIP TX-01-0615-0001 Prepared by Jonathan Rodriguez 1/15/2022 2,144.82 5.27 2,144.82 100.00 2,144.82 5.27 2,144.82 0% None 1 0.00 None 0 30 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 6/30/2023 Description CUSIP Face Amount / Shares Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash WFSWEEP 4,009,368.34 10/15/2019 4.96 4,009,368.34 4,009,368.34 100.00 4.96 4,009,368.34 1.37% 0.00 None None 1 0 Wells Fargo TWDB Cash WF6100 Sub Total 567: Water Drinking Bonds Series 2020 12,692,900.85 6/16/2020 12,692,900.85 4.91 12,692,900.85 100.00 12,692,900.85 4.91 4.32% 0.00 None None 1 0 16,704,414.01 Texas Class LGIP TX-01-0615-0014 3,504,617 10 Wells Fargo Sweep Cash WFSWEEP Sub Total 568: Revenue Bonds Series 2021 1,059,333.34 4.92 16,704,414.01 16,704,414.01 4.92 16,704,414.01 5.69% 0.00 8/15/2021 3,504,617.10 100.00 3,504,617.10 1.19% None 5.27 3,504,617.10 5.27 0.00 None 10/15/2019 1,059,333.34 4.96 1,059,333.34 1 0 0 100.00 1,059,333.34 4.96 0.36% None 0.00 None 1 0 4,563,950.44 5.20 4,563,950.44 4,563,950.44 5.20 4,563,950.44 1.55% 0.00 1 0 569: Revenue Bonds Series 2022 LOGIC LGIP 6028909005 24,356,235.55 7/26/2022 24,356,235.55 100.00 24,356,235.55 8.29% None 5.26 24,356,235.55 5.26 0.00 None 1 0 Wells Fargo Sweep Cash 10/15/2019 971,807.42 100.00 971,807.42 0.33% None WFSWEEP Sub Total 569: Revenue Bonds Series 2022 971,807.42 4.96 25,328,042.97 5.24 971,807.42 4.96 0.00 None 25,328,042.97 25,328,042.97 5.24 25,328,042.97 1 0 8.62% 1 0.00 0 570: W/S Pay As You Go Texas Class LGIP TX-01-0615-0001 Wells Fargo Sweep Cash WFSWEEP Prepared by Jonathan Rodriguez 3,706,781.46 6/15/2020 3,706,781.46 100.00 3,706,781.46 5.27 3,706,781.46 5.27 12/31/2007 327,142.57 100.00 327,142.57 327,142.57 4.96 327,142.57 4.96 1.26% None 1 0.00 None 0 0.11% None 1 0.00 None 0 31 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 6/30/2023 Description CUSIP Face Amount / Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Sub Total 570: W/S Pay As You Go 4,033,924.03 5.24 4,033,924.03 4,033,924.03 5.24 4,033,924.03 1.37% 0.00 1 0 571: TWDB Revenue Bonds Series 2021 Wells Fargo Sweep Cash WFSWEEP Wells Fargo TWDB Cash WF3100 Sub Total 571: TWDB Revenue Bonds Series 2021 10/1/2020 -15,443,453.60 100.00 -15,443,453.60 -15,443,453.60 4.96-15,443,453.60 4.96 4/1/2021 33,322,131.18 100.00 33,322,131.18 33, 322,131.18 4.91 33, 322,131.18 4.91 17,878,677.58 17,878,677.58 17,878,677.58 4.86 17,878,677.58 4.86 -5.26% 0.00 11.35% 0.00 6.09% 0.00 None None None None 1 0 0 1 0 574: Revenue Bonds Series 2023 Wells Fargo Sweep Cash 10/15/2021 -393,038.93 WFSWEEP Sub Total 574: Revenue Bonds Series 2023 -393,038.93 4.96 -393,038.93 -393,038.93 -393,038.93 4.96-393,038.93 100.00 -393,038.93 -0.13% None 4.96 4.96 -393,038.93 0.00 None 1 0 0.00 0 575: MUD 4 Capital Programs Wells Fargo Sweep Cash 2/1/2013 26,188.84 100.00 26,188.84 0.01% None WFSWEEP 26,188.84 4.96 26,188.84 4.96 0.00 None Sub Total 575: MUD 4 Capital Programs 26,188.84 26,188.84 26,188.84 4.96 26,188.84 4.96 1 0 0.01 % 1 0.00 0 576: Revenue Bonds Series 2024 Wells Fargo Sweep Cash 10/15/2021 -10,365.00 100.00 -10,365.00 0% None WFSWEEP -10,365.00 4.96-10,365.00 4.96 0.00 None Sub Total 576: Revenue Bonds Series 2024 -10,365.00 4.96 1 0 -10,365.00 -10,365.00 0% 1 -10,365.00 4.96 0.00 0 600: Water & Sewer Texas Class LGIP 12/20/2016 65,484.36 100.00 65,484.36 0.02% None TX-01-0615-0001 65,484.36 5.27 65,484.36 5.27 0.00 None Prepared by Jonathan Rodriguez 1 0 32 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 6/30/2023 Description CUSIP Face Amount / Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash WFSWEEP Sub Total 600: Water & Sewer 12,164,102.16 12,229,586.52 5/31/2006 4.96 4.96 12,164,102.16 12,164,102.16 12,229,586.52 12,229,586.52 100.00 4.96 4.96 12,164,102.16 12,229,586.52 4.14% 0.00 4.16% 0.00 None None 1 0 1 0 601: Water & Sewer Debt Fund Texas Class LGIP TX-01-0615-0001 12/15/2020 65,243.81 100.00 65,243.81 65,243.81 5.27 65,243.81 5.27 Wells Fargo Sweep Cash 10/15/2020 35,817,348.32 100.00 35,817,348.32 WFSWEEP 35,817,348.32 4.96 35,817,348.32 4.96 35,882,592.13 35,882,592.13 Sub Total 601: Water & Sewer Debt Fund 35,882,592.13 4.96 35,882,592.13 4.96 0.02% None 1 0.00 None 0 12.2% None 1 0.00 None 0 12.22% 0.00 1 0 610: Solidwaste Wells Fargo Sweep Cash 12/1/2006 5,864.13 100.00 5,864.13 0% None WFSWEEP Sub Total 610: Solidwaste 5,864.13 4.96 5,864.13 4.96 5,864.13 4.96 0.00 None 1 0 5,864.13 5,864.13 0% 1 5,864.13 4.96 0.00 0 700: Risk Management Fund Wells Fargo Cash 10/15/2020 60,127.55 100.00 60,127.55 W F 1376 60,127.55 1.01 60,127.55 1.01 Wells Fargo Sweep Cash 10/31/2006 531,119.09 100.00 531,119.09 WFSWEEP Sub Total 700: Risk Management Fund 531,119.09 4.96 531,119.09 4.96 591,246.64 4.56 0.02% 0.00 0.18% 0.00 None None None None 1 0 1 0 591,246.64 591,246.64 0.2% 1 591,246.64 4.56 0.00 0 701: Employee Benefit Fund Wells Fargo Sweep Cash WFSWEEP Sub Total 701: Employee Benefit Fund Prepared by Jonathan Rodriguez 9/1/2007 143,843.64 100.00 143,843.64 0.05% None 143,843.64 4.96 143,843.64 4.96 0.00 None 1 0 143,843.64 143,843.64 0.05% 1 143,843.64 4.96 143,843.64 4.96 0.00 0 33 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 6/30/2023 Description Face Amount / CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity 702: Health Claims Fund Wells Fargo Cash WF9871 767,817.66 7/21/2010 767,817.66 1.01 767,817.66 100.00 1.01 767,817.66 0.26% 0.00 None None 0 Wells Fargo Sweep Cash WFSWEEP 2,804,567.04 9/15/2010 2,804,567.04 100.00 2,804,567.04 0.95% None 4.96 2,804,567.04 4.96 0.00 None 1 0 3,572,384.70 3,572,384.70 Sub Total 702: Health Claims Fund 3,572,384.70 4.11 3,572,384.70 4.11 703: Motor Pool Fund Texas Class LGIP 1/15/2022 10,437,367.04 100.00 10,437,367.04 TX-01-0615-0001 10,437,367.04 5.27 10,437,367.04 5.27 1.21% 0.00 1 0 3.55% None 1 0.00 None 0 Wells Fargo Sweep Cash 10/15/2018 3,889,204.73 100.00 3,889,204.73 1.32% None WFSWEEP 3,889,204.73 4.96 3,889,204.73 4.96 0.00 None Sub Total 703: Motor Pool Fund 704: Facilities Fund Wells Fargo Sweep Cash WFSWEEP 1 0 14,326,571.77 5.18 14,326,571.77 14,326,571.77 5.18 14,326,571.77 4.87% 1 0.00 0 10/15/2022 912,332.75 100.00 912,332.75 0.31% None 912,332.75 4.96 912,332.75 4.96 0.00 None 1 0 912,332.75 912,332.75 0.31% 1 Sub Total 704: Facilities Fund 912,332.75 4.96 912,332.75 4.96 0.00 0 705: Information Technology Fund Wells Fargo Sweep Cash 10/15/2022 -98,893.69 100.00 -98,893.69 -0.03% None 1 WFSWEEP -98,893.69 4.96-98,893.69 4.96 0.00 None 0 Sub Total 705: Information Technology Fund 800: Long Term Debt -98,893.69 -98,893.69 -0.03% 1 -98,893.69 4.96-98,893.69 4.96 0.00 0 Wells Fargo Sweep Cash 10/15/2022 -53,493.06 100.00 -53,493.06 -0.02% None WFSWEEP -53,493.06 4.96-53,493.06 4.96 0.00 None Prepared by Jonathan Rodriguez 1 0 34 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 6/30/2023 Description CUSIP Face Amount / Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Sub Total 800: Long Term Debt -53,493.06 4.96 -53,493.06 -53,493.06 4.96 -53,493.06 -0.02% 0.00 1 0 TOTAL PORTFOLIO 293,687,892.93 5.01 293,687,892.93 293,687,892.93 5.10 293,487,578.16 86,538.36 100.00% -200,314.77 8 0.03 Prepared by Jonathan Rodriguez 35 City of Pearland Treasury Yield Curve Treasury 3/31/2023 4/30/2023 5/31 /2023 6/30/2023 1 Month 3 Month 6 Month 1 Year 2 Year 3 Year 5 Year 10 Year 4.49 4.86 4.99 4.68 4.30 4.09 3.82 3.66 4.17 5.07 4.99 4.68 4.02 3.76 3.54 3.46 5.49 5.31 5.27 4.91 4.13 3.82 3.59 3.57 5.20 5.42 5.42 5.24 4.64 4.27 3.95 3.75 6.00 5.00 4,00 3,00 2.00 1.00 0.00 1 Month 3 Month 6 Month 1 Year 2 Year 3 Year 5 Year 10 Year • 3/31/2023 ▪ 4/30/2023 • 5/31/2023 • 6/30/2023 Note 1 Note 2 Prepared by Jonathan Rodriguez Center Footer 36 Bank Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Pledged Collateral Reconciliation Report June 30, 2023 Account Ending 3395 2841 5455 7843 1790 9871 4094 4102 5883 5875 6624 2847 3025 1376 Account Name Credit Card Account Sweep Account False Alarm Reduction Program Alvin ISD EMS Payments Health Claims Escrow W&S Revenue Bonds, Series 2016B Escrow W&S Revenue Bonds, Series 2016C Texas Permanent W&S System Revenue 2017B Texas Permanent W&S System Revenue 2017A Escrow W&S Revenue Bonds, Series 2018A Escrow W&S Revenue Bonds, Series 2019A Massey Oaks Easement Cost Escrow Workers Compensation Claims Total of Bank Balances Pledged Collateral for City FDIC Insurance Amount 14,292.00 * 289,900.09 16,022,911.67 767,817.66 2,771.11 60,127.55 $ 17,157,820.08 24,995,312.72 500, 000.00 Over (Under) Collateralized $ Total % Collateralized Bank Account Ending Account Name Wells Fargo 4258 Development Authority Total of Bank Balances Pledged Collateral for DAP FDIC Insurance 25,495,312.72 8,337,492.64 148.6% Amount 912,709.21 $ 912,709.21 712,100.35 250,000.00 Over (Under) Collateralized $ Total % Collateralized Total % Collateralized Status 962,100.35 49, 391.14 105.4% 146.4% Collateralized * Accounts are sweeping to a higher yielding money market fund which does not require collateral.