Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
R2023-114 2023-05-22
DocuSign Envelope ID: 3FF3662B-C14F-4118-9A5C-C91449555705 RESOLUTION NO. R2023-114 A Resolution of the City Council of the City of Pearland, Texas, accepting the City's Investment Report for the quarter ending March 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 March 2023. PASSED, APPROVED and ADOPTED this the 22nd day of May, A.D., 2023. ATTEST: �DocuSigned by: FralA.a-s a lull p0CC22531EEF416 FRANCES AGUILAR, TRMC, MMC CITY SECRETARY APPROVED AS TO FORM: DocuSigned by: F4B0.. DARRIN M. COKER CITY ATTORNEY DocuSigned by: pze.. D4381AG15 3E4E2... J. KEVIN COLE MAYOR YYY ,YY-{,,,,, y. _o reµ= r' r+N ,l. ,rlllllil ,,^,,* City of Pearland Quarterly Investment Report December 31, 2022 to March 31, 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 Book Value Unreauzed Gain/Loss YTM @ Cost Treasury 1 Year Interest Earned Days To Maturity 1/31/2023 356,037,013.99 356,247,506.98 2/28/2023 332,787,435.23 333,046,233.77 3/31/2023 324,866,407.64 325,058,327.88 -210,492.99 4.15 4.69 1,215,167.99 15 -258,798.54 4.37 4.93 1,227,668.17 15 -191,920.24 4.51 4.68 1,216,037.76 14 Total / Average 337,896,952.29 338,117,356.21 -220,403.92 4.34 4.77 3,656,873.92 15 Amy Buc -rt Johnson, Chief 3fij(�fficer Date Kendra Murphy, Deputy Finance Dir -2ut3 �r�, natha n Rodriguez, Treasury anager Date ' fk.2C 3 Da e 1 City of Pearland Distribution by Security Type - Book Value Report Group: Pearland Begin Date: 12/31/2022, End Date: 3/31/2023 Security Type Allocation Security Type Book Value 12/31/2022 % of Portfolio 12/31/2022 Book Value 3/31/2023 % of Portfolio 3/31/2023 Cash Certificate Of Deposit FFCB Bond FHLB Bond Local Government Investment Pool 184,716,765.46 1,226,000.00 3,000,000.00 7,249,989.08 152,413,952.73 52.99 0.35 0.86 2.08 43.72 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 Total / Average 348,606,707.27 Portfolio Holdings as of 12/31/2022 • 52.99%-Cash 0,35%-Certificate Of... • 0,86%-FFCB Bond • 2.08%-FHLB Bond • 43.72%-Local Governor,., 100.00 325,058,327.88 100.00 Portfolio Holdings as of 3/31/2023 51.2%-Cash 0,38%-Certificate Of... 1 0,92%-FFCB Bond • 2.23%-FHLB Bond • 45.27%-Local Governor,., Prepared by Jonathan Rodriguez 2 City of Pearland Distribution by Maturity Range - Book Value Report Group: Pearland Begin Date: 12/31/2022, End Date: 3/31/2023 Maturity Range Allocation Book Value % of Portfolio Book Value % of Portfolio Maturity Range 12/31/2022 12/31/2022 3/31/2023 3/31/2023 0-1 Month 337,130,718.19 96.71 313,582,331.30 96.47 1-3 Months 0.00 0.00 999,996.58 0.31 3-6 Months 999,989.08 0.29 1,485,000.00 0.46 6-9 Months 1,485,000.00 0.43 1,000,000.00 0.31 9-12 Months 2,000,000.00 0.57 2,250,000.00 0.69 1-2 Years 5,991,000.00 1.72 4,741,000.00 1.46 2-3 Years 1,000,000.00 0.29 1,000,000.00 0.31 Total / Average 348,606,707.27 100.00 325,058,327.88 100.00 Portfolio Holdings 350,000 300,000 250,000 c +e 200,000 izi O H 150,000 C 12/31/2022 3/31/2023 — 100,000 50,000 00 1 I 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: 4/30/2022, End Date: 3/31/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 4/30/2022 335,635,056.23 5/31/2022 328,571,486.08 6/30/2022 309,220,363.92 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 73,499.71 119,691.33 187,156.76 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 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 73,499.71 119,691.33 187,156.76 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 331,826,325.91 318,028,875.38 303,261,286.34 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 0.02 0.04 0.06 0.11 0.16 0.19 0.24 0.28 0.31 0.35 0.36 0.37 0.27 0.45 0.74 1.27 1.93 2.25 2.91 3.41 3.84 4.22 4.37 4.54 1.88 2.06 2.65 3.02 3.28 3.89 4.43 4.73 4.68 4.69 4.93 4.68 Total/Average 335,635,056.23 8,247,131.49 0.00 8,247,131.49 326,541,574.01 2.53 2.53 3.74 Annualized TRR-BV 5,00 4,00 3.00 2.00 1.00 0.00 04/2022 05/2022 06/2022 07/2022 08/2022 09/2022 10/2022 11/2022 12/2022 01/2023 02/2023 03/2023 • Portfolio • Treasury 1 Year Prepared by Jonathan Rodriguez 4 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 3/31 /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 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 Wells Fargo Cash WF9871 7/21/2010 381,142.91 100.00 381,142.91 0.12% None 381,142.91 0.84 381,142.91 0.84 0.00 None 1 0 Wells Fargo Cash WF1376 10/15/2020 40,541.35 100.00 40,541.35 0.01% None 40,541.35 0.83 40,541.35 0.83 0.00 None 1 0 Wells Fargo Sweep Cash 5/31/2006 15,365,193.33 100.00 15,365,193.33 4.73% None WFSWEEP 15,365,193.33 4.65 15,365,193.33 4.65 0.00 None 1 0 Wells Fargo Sweep Cash 5/31/2006 1,415,085.32 100.00 1,415,085.32 0.44% None 1 WFSWEEP 1,415,085.32 4.65 1,415,085.32 4.65 0.00 None 0 Wells Fargo Sweep Cash WFSWEEP 5/31/2006 5,631.92 100.00 5,631.92 0% None 5,631.92 4.65 5,631.92 4.65 0.00 None 1 0 Wells Fargo Sweep Cash 5/31/2006 12,567,443.70 100.00 12,567,443.70 3.87% None 1 WFSWEEP 12,567,443.70 4.65 12,567,443.70 4.65 0.00 None 0 Wells Fargo Sweep Cash WFSWEEP 5/31/2006 14,375.19 100.00 14,375 19 0% None 14,375.19 4.65 14,375.19 4.65 0.00 None Wells Fargo Sweep Cash WFSWEEP 1 0 5/31/2006 203,080.60 100.00 203,080.60 0.06% None 1 203,080.60 4.65 203,080.60 4.65 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 WFSWEEP 735,992.38 100.00 735,992.38 0.23% None 1 735,992.38 4.65 735,992.38 4.65 0.00 None 0 Wells Fargo Sweep Cash WFSWEEP 5/31/2006 355,754.05 100.00 355,754.05 0.11% None 355,754.05 4.65 355,754.05 4.65 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 5/31/2006 177,471.10 4.65 177,471.10 100.00 177,471.10 4.65 177,471.10 0.05% None 1 0.00 None 0 Prepared by Jonathan Rodriguez 5 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 3/31 /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 3,026,674.11 5/31/2006 4.65 3,026,674.11 3,026,674.11 100.00 4.65 3,026,674.11 0 93% 0.00 Wells Fargo Sweep Cash WFSWEEP 5/31/2006 59,023.60 100.00 59,023.60 59,023.60 4.65 59,023.60 4.65 0.02% 0.00 None None 1 0 None None 1 0 Wells Fargo Sweep Cash WFSWEEP 1,525,918.04 5/31/2006 1,525,918.04 100.00 1,525,918.04 0.47% None 4.65 1,525,918.04 4.65 Wells Fargo Sweep Cash WFSWEEP 0.00 None 1 0 5/31/2006 84,590.45 100.00 84,590.45 0.03% None 84,590.45 4.65 84,590.45 4.65 0.00 None Wells Fargo Sweep Cash WFSWEEP 1 0 5/31/2006 64,814.89 100.00 64,814.89 0.02% None 64,814.89 4.65 64,814.89 4.65 0.00 None 1 0 Wells Fargo Sweep Cash 5/31/2006 -700,466.78 100.00 -700,466.78 -0.22% None WFSWEEP -700,466.78 4.65-700,466.78 4.65 0.00 None 1 0 Wells Fargo Sweep Cash 5/31/2006 1,158,034.10 100.00 1,158,034.10 0.36% None 1 WFSWEEP 1,158,034.10 4.65 1,158,034.10 4.65 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 22,779,189.94 WFSWEEP 22,779,189.94 4.65 22,779,189.94 100.00 22,779,189.94 7.01% None 4.65 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 5/31/2006 238,252.54 100.00 238,252.54 0.07% None 238,252.54 4.65 238,252.54 4.65 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 5/31/2006 333,879.61 100.00 333,879.61 0.1% None 333,879.61 4.65 333,879.61 4.65 0.00 None 1 0 Wells Fargo Sweep Cash 5/31/2006 2,247,769.69 100.00 2,247,769.69 0.69% None WFSWEEP 2,247,769.69 4.65 2,247,769.69 4.65 0.00 None 1 0 Wells Fargo Sweep Cash 6/30/2006 22,350.00 100.00 22,350.00 0.01% None 1 WFSWEEP 22,350.00 4.65 22,350.00 4.65 0.00 None 0 Prepared by Jonathan Rodriguez 6 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 3/31 /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 1,651,747.11 10/31/2006 4.65 1,651,747.11 1,651,747.11 100.00 4.65 1,651,747.11 0.51% 0.00 None None 1 0 Wells Fargo Sweep Cash WFSWEEP 12/1/2006 27,301.15 100.00 27,301.15 27,301.15 4.65 27,301.15 4.65 0.01% 0.00 None None 1 0 Wells Fargo Sweep Cash WFSWEEP 9/1/2007 -27,411.36 100.00 -27,411.36 -0.01% None -27,411.36 4.65 Wells Fargo Sweep Cash -27,411.36 4.65 0.00 None 1 0 12/31/2007 1,039,970.14 100.00 1,039,970.14 0.32% None WFSWEEP 1,039,970.14 4.65 1,039,970.14 4.65 0.00 None 1 0 Wells Fargo Sweep Cash 10/30/2008 7,334,779.37 100.00 7,334,779.37 2.26% None WFSWEEP 7,334,779.37 4.65 7,334,779.37 4.65 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 9/15/2009 273.78 100.00 273.78 0% None 273.78 4.65 273.78 4.65 0.00 None 1 0 Wells Fargo Sweep Cash 9/15/2010 2,602,998.33 100.00 2,602,998.33 0.8% None 1 WFSWEEP 2,602,998.33 4.65 2,602,998.33 4.65 0.00 None 0 Wells Fargo Sweep Cash 4/15/2012 148,625.73 100.00 148,625.73 0.05% None WFSWEEP 148,625.73 4.65 148,625.73 4.65 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 2/1/2013 25,963.32 100.00 25,963.32 0.01% None 25,963.32 4.65 25,963.32 4.65 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 11/15/2015 13,689.63 100.00 13,689.63 0% None 13,689.63 4.65 13,689.63 4.65 0.00 None 1 0 Wells Fargo Sweep Cash 10/15/2018 4,325,599.38 100.00 4,325,599.38 1.33% None WFSWEEP 4,325,599.38 4.65 4,325,599.38 4.65 0.00 None Wells Fargo Sweep Cash WFSWEEP 1 0 -366,618.99 12/15/2018 -366,618.99 4.65-366,618.99 100.00 -366,618.99 -0.11% None 1 4.65 Prepared by Jonathan Rodriguez 0.00 None 0 7 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 3/31/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 -7,634,231.50 10/15/2019 -7,634,231.50 4.65-7,634,231.50 100.00 4.65 -7,634,231.50 -2.35% 0.00 Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP 1,194, 703.93 10/15/2019 1,194,703.93 4.65 1,194,703.93 100.00 1,194,703.93 4.65 0.37% 0.00 None None 1 0 None None 1 0 10/15/2019 -8,156.41 100.00 -8,156.41 0% None -8,156.41 4.65-8,156.41 4.65 Wells Fargo Sweep Cash WFSWEEP 0.00 None 1 0 10/15/2019 531,887.94 100.00 531,887.94 0.16% None 531,887.94 4.65 531,887.94 4.65 0.00 None 1 0 Wells Fargo Sweep Cash 10/15/2019 1,146,009.31 100.00 1,146,009.31 0.35% None WFSWEEP 1,146,009.31 4.65 1,146,009.31 4.65 0.00 None 1 0 Wells Fargo Sweep Cash 10/15/2019 1,333,862.71 100.00 1,333,862.71 0.41% None WFSWEEP 1,333,862.71 4.65 1,333,862.71 4.65 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 10/15/2019 863,132.96 100.00 863,132.96 0.27% None 1 863,132.96 4.65 863,132.96 4.65 0.00 None 0 Wells Fargo Sweep Cash WFSWEEP -9,589,356.80 10/15/2019 -9,589,356.80 100.00 -9,589,356.80 -2.95% None 4.65-9,589,356.80 4.65 0.00 None 1 0 Wells Fargo Sweep Cash 12/15/2019 1,362,944.69 100.00 1,362,944.69 0.42% None WFSWEEP 1,362,944.69 4.65 1,362,944.69 4.65 0.00 None 1 0 Wells Fargo Sweep Cash 1/15/2020 2,508,993.23 100.00 2,508,993.23 0.77% None WFSWEEP 2,508,993.23 4.65 2,508,993.23 4.65 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP 1/15/2020 2,150.19 100.00 2,150.19 0% None 2,150.19 4.65 2,150.19 4.65 0.00 None 1,202,826.92 Prepared by Jonathan Rodriguez 1 0 1/15/2020 1,202,826.92 100.00 1,202,826.92 0.37% None 1 4.65 1,202,826.92 4.65 0.00 None 0 8 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 3/31/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 -13,266,087.11 2/15/2020 -13,266,087.11 4.65-13,266,087.11 100.00 4.65 -13,266,087.11 -4.08% 0.00 Wells Fargo Sweep Cash WFSWEEP -2,326,277.99 5/15/2020 -2,326,277.99 4.65-2,326,277.99 100.00 -2,326,277.99 4.65 -0.72% 0.00 None None 1 0 None None 1 0 Wells Fargo Sweep Cash WFSWEEP 1,202,085.52 Wells Fargo Sweep Cash WFSWEEP 8/15/2020 1,202,085.52 100.00 1,202,085.52 0.37% None 4.65 1,202,085.52 4.65 0.00 None 1 0 9/15/2020 -307,286.07 100.00 -307,286.07 -0.09% None -307,286.07 4.65-307,286.07 4.65 0.00 None 1 0 Wells Fargo Sweep Cash 10/1/2020 -49,213,048.82 100.00-49,213,048.82-15.14% None WFSWEEP -49,213,048.82 4.65-49,213,048.82 4.65 0.00 None 1 0 Wells Fargo Sweep Cash 10/1/2020 2,605,876.09 100.00 2,605,876.09 0.8% None WFSWEEP 2,605,876.09 4.65 2,605,876.09 4.65 0.00 None 1 0 Wells Fargo Sweep Cash 10/1/2020 3,168,391.26 100.00 3,168,391.26 0.97% None 1 WFSWEEP 3,168,391.26 4.65 3,168,391.26 4.65 0.00 None 0 Wells Fargo Sweep Cash WFSWEEP 1,182,951.65 10/1/2020 1,182,951.65 100.00 1,182,951.65 0.36% None 4.65 1,182,951.65 4.65 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 10/1/2020 744,718.77 100.00 744,718.77 0.23% None 744,718.77 4.65 744,718.77 4.65 0.00 None 1 0 Wells Fargo Sweep Cash 10/15/2020 28,246,511.18 100.00 28,246,511.18 8.69% None WFSWEEP 28,246,511.18 4.65 28,246,511.18 4.65 0.00 None 1 0 Wells Fargo Sweep Cash 11/15/2020 -280,481.09 100.00 -280,481.09 -0.09% None WFSWEEP -280,481.09 4.65-280,481.09 4.65 0.00 None 1 0 Wells Fargo Sweep Cash 11/15/2020 -59,124.74 100.00 -59,124.74 -0.02% None 1 WFSWEEP -59,124.74 4.65-59,124.74 4.65 0.00 None 0 Prepared by Jonathan Rodriguez 9 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 3/31/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,751,654.86 5/15/2021 4.65 5,751,654.86 5,751,654.86 100.00 4.65 5,751,654.86 1 .77% 0.00 Wells Fargo Sweep Cash WFSWEEP 10/15/2021 -83,703.02 100.00 -83,703.02 -83,703.02 4.65-83,703.02 4.65 -0.03% 0.00 None None 1 0 None None 1 0 Wells Fargo Sweep Cash WFSWEEP 10/15/2021 -122,197.50 100.00 -122,197.50 -0.04% None -122,197.50 4.65 Wells Fargo Sweep Cash WFSWEEP -122,197.50 4.65 0.00 None 1 0 10/15/2021 -10,365.00 100.00 -10,365.00 0% None -10,365.00 4.65-10,365.00 4.65 0.00 None 1 0 Wells Fargo Sweep Cash 10/15/2021 -190,487.52 100.00 -190,487.52 -0.06% None WFSWEEP -190,487.52 4.65-190,487.52 4.65 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 12/15/2021 51.47 100.00 51.47 0% None 51.47 4.65 51.47 4.65 0.00 None Wells Fargo Sweep Cash WFSWEEP 1 0 6/1/2022 220,810.57 100.00 220,810.57 0.07% None 1 220,810.57 4.65 220,810.57 4.65 0.00 None 0 Wells Fargo Sweep Cash 10/15/2022 WFSWEEP -6,802.98 4.65 -6,802.98 100.00 -6,802.98 0% None -6,802.98 4.65 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 10/15/2022 721,580.13 100.00 721,580.13 0.22% None 721,580.13 4.65 721,580.13 4.65 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 10/15/2022 456,280.75 100.00 456,280.75 0.14% None 456,280.75 4.65 456,280.75 4.65 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 10/15/2022 -12,840.48 100.00 -12,840.48 0% None -12,840.48 4.65-12,840.48 4.65 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.65-53,493.06 4.65 0.00 None 0 Prepared by Jonathan Rodriguez 10 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 3/31/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 173,815.85 10/15/2022 4.65 173,815.85 173,815.85 100.00 4.65 173,815.85 Wells Fargo Sweep Cash WFSWEEP Wells Fargo TWDB Cash WF5875 Wells Fargo TWDB Cash WF4094 3/15/2023 104,771.64 104,771.64 4.65 945,799.37 100.00 104,771.64 104,771.64 4.65 0 05% 0.00 None None 1 0 0.03% None 0.00 None 1 0 9/15/2017 945,799.37 4.65 945,799.37 100.00 945,799.37 0.29% None 4.65 0.00 None 1 0 11/1/2016 58,565.67 100.00 58,565.67 0.02% None 58,565.67 4.65 58,565.67 4.65 0.00 None Wells Fargo TWDB Cash WF6624 1 0 5/15/2018 989,445.22 100.00 989,445.22 0.3% None 989,445.22 4.65 989,445.22 4.65 0.00 None 1 0 Wells Fargo TWDB Cash 6/16/2020 30,075,944.46 100.00 30,075,944.46 9.25% None WF6100 30,075,944.46 4.16 30,075,944.46 4.16 0.00 None 1 0 Wells Fargo TWDB Cash 4/1/2021 3,829,767.23 100.00 3,829,767.23 1.18% None 1 WF3100 3,829,767.23 4.16 3,829,767.23 4.16 0.00 None 0 Wells Fargo TWDB Cash 4/1/2021 71,254,235.11 WF3100 71,254,235.11 4.16 71,254,235.11 100.00 71,254,235.11 21.92% None 4.16 0.00 None 1 0 Wells Fargo TWDB Cash 8/6/2019 6,205,603.20 100.00 6,205,603.20 1.91% None WF2847 6,205,603.20 4.65 6,205,603.20 4.65 0.00 None 1 0 Wells Fargo TWDB Cash WF4102 11/1/2016 156,452.97 100.00 156,452.97 0.05% None 156,452.97 4.65 156,452.97 4.65 0.00 None 1 0 Wells Fargo TWDB Cash 3/15/2017 2,469,859.85 100.00 2,469,859.85 0.76% None WF5883 2,469,859 85 4.65 2,469,859.85 4.65 0.00 None Sub Total Cash 166,429,175.35 4.33 166,429,175.35 166,429,175.35 4.33 166,429,175.35 1 0 0.00 0 Certificate Of Deposit Prepared by Jonathan Rodriguez 11 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 3/31/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 AMERICAN EXPR NAIL BK 2.85 5/13/2024 02589ACN0 248,000.00 5/11/2022 2.85 248,000.00 248,000.00 97.59 5.09 242,020.33 2,711.01 0.08% -5,979.67 None None 409 1.1 BARCLAYS BANK DELAWARE 2.85 5/20/2024 06740KQH3 5/18/2022 248,000.00 97.55 241,926.74 0.08% None 248,000.00 2.85 248,000.00 5.09 2,575.46 -6,073.26 None 416 1.12 DISCOVER BANK 2.8 5/20/2024 254673D78 5/18/2022 245,000.00 97.50 238,866.45 0.08% None 416 245,000.00 2.80 245,000.00 5.09 2,499.67 -6,133.55 None 1.12 JP MORGAN CHASE BANK NA 09/22/23-23 3.75 9/2 46593LPF0 9/23/2022 245,000.00 99.39 243,510.34 0.08% None 175 245,000.00 3.75 245,000.00 5.06 201.37 -1,489.66 None 0.48 MORGAN STANLEY BANK NA 3.7 9/22/2022 240,000.00 99.32 238,376.78 0.07% None 175 9/22/2023 61690US35 240,000.00 3.70 240,000.00 5.05 4,622.47 -1,623.22 None 0.48 Sub Total Certificate Of Deposit 1, 226, 000.00 3.19 1,226,000.00 1,226,000.00 1,204,700.64 0.39% 319 5.07 12,609.98 -21,299.36 0.86 FFCB Bond FFCB 1.94 9/3/2024-22 3/11/2022 2,000,000.00 96.23 1,924,518.24 0.62% Moodys-Aaa 522 3133ENQC7 2.000,000.00 1.94 2,000,000.00 4.71 3,017.78 -75,481.76 S&P -AA+ 1.41 FFCB 3.25 6/17/2024 6/17/2022 1,000,000.00 98.41 984,076.07 0.31% None 444 3133ENYX2 1,000,000.00 3.25 1,000,000.00 4.61 9,388.89 -15,923.93 None 1.19 3,000,000.00 2,908,594.31 0.93% 496 Sub Total FFCB Bond 3,000,000.00 2.38 3,000,000.00 4.68 12,406.67 -91,405.69 1.34 FHLB Bond FHLB 1.6512/28/2023-22 3/28/2022 1,000,000.00 97.64 976,443.38 0.31% Moodys-Aaa 28 3130ARA27 1,000,000.00 1.65 1,000,000.00 4.93 137.50 -23,556.62 S&P -AA+ 0.74 FHLB 2.125 5/12/2023 5/12/2022 999,970.00 99.71 997,079.88 0.31% None 42 3130AS3T4 1,000,000.00 2.13 999,996.58 4.66 8,204.86 -2,916.70 None 0.11 Prepared by Jonathan Rodriguez 12 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 3/31 /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 FHLB 2.5 2/13/2024 3130AFW94 1,250,000.00 5/11/2022 2.50 1,250,000.00 1,250,000.00 98.05 4.82 1,225,685.13 4,166.67 0.38% Moodys-Aaa -24,314.87 S&P -AA+ 319 0.86 FHLB 3.5 08/28/23-22 3.5 8/28/2023-22 3130ASVY2 FHLB 4.0 09/16/24-22 4 9/16/2024-22 3130ASZG7 FHLB 4.125 09/29/23-22 4.125 9/29/2023-22 3130ATE78 1,000,000.00 8/30/2022 1, 000, 000.00 3.50 1,000,000.00 99.34 993,382.74 0.31% None 5.11 2,916.67 -6,617.26 None 58 0.42 9/16/2022 1,000,000.00 1,000,000.00 4.00 1,000,000.00 98.85 988,450.81 0.31% None 77 4.83 1,666.67 -11,549.19 None 1.43 9/29/2022 1,000,000.00 1,000,000.00 4.13 1,000,000.00 99.68 996,781.07 0.31% None 4.79 229.17 -3,218.93 None 182 0.49 FHLB 4.375 09/29/25-23 4.375 9/29/2025-23 9/29/2022 1,000,000.00 3130ATE29 1,000,000.00 4.38 1,000,000.00 99.30 992,958.38 0.31% None 4.68 243.06 -7,041.62 None 182 2.39 Sub Total FHLB Bond 7,250,000.00 3.16 7,249,970.00 7,249,996.58 7,170,781.39 2.24% 133 4.83 17,564.60 -79,215.19 0.92 Local Government Investment Pool LOGIC LGIP 6028909005 LOGIC LGIP 6028909004 LOGIC LGIP 6028909002 28,511,429.50 3,393,631.07 7/26/2022 28,511,429.50 4.82 28,511,429.50 100.00 28,511,429.50 8.77% None 1 4.82 0.00 None 0 7/26/2022 3,393,631.07 100.00 3,393,631.07 1.04% None 4.82 3,393,631.07 4.82 0.00 None 1 0 14,051,583.55 7/26/2022 14,051,583.55 100.00 14,051,583.55 4.32% None 1 4.82 14,051,583.55 4.82 0.00 None 0 LOGIC LGIP 6028909003 8,424,257.29 7/26/2022 8,424,257.29 100.00 8,424,257.29 2.59% None 4.82 8,424,257.29 4.82 0.00 None 1 0 Texas Class LGIP TX-01-0615-0001 12/20/2016 64,641.89 100.00 64,641.89 0.02% None 1 64,641.89 4.86 64,641.89 4.86 0.00 None 0 Texas Class LGIP 12/20/2016 63.31 100.00 63.31 0% None 1 TX-01-0615-0001 63.31 4.86 63.31 4.86 0.00 None 0 Prepared by Jonathan Rodriguez 13 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 3/31/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 Texas Class LGIP TX-01-0615-0001 12,383,666.61 12/20/2016 4.86 12,383,666.61 12,383,666.61 100.00 4.86 12,383,666.61 3.81 % 0.00 Texas Class LGIP TX-01-0615-0001 2,072,782.13 12/20/2016 4.86 2,072,782.13 2,072,782.13 100.00 2,072,782.13 4.86 Texas Class LGIP TX-01-0615-0001 89,682.87 Texas Class LGIP TX-01-0615-0001 2,645,048.34 0.64% 0.00 None None 1 0 None None 1 0 1/15/2017 89,682.87 100.00 89,682.87 0.03% None 4.86 89,682.87 4.86 1/15/2017 2,645,048.34 100.00 2,645,048.34 4.86 2,645,048.34 4.86 Texas Class LGIP TX-01-0615-0001 2,595,363.88 0.00 None 1 0 0.81 0.00 None None 1 0 1/15/2017 2,595,363.88 100.00 2,595,363.88 0.8% None 4.86 2,595,363.88 4.86 0.00 None 1 0 Texas Class LGIP TX-01-0615-0001 5,302,812.78 Texas Class LGIP TX-01-0615-0001 Texas Class LGIP TX-01-0615-0001 5/15/2017 5,302,812.78 100.00 5,302,812.78 1.63% None 4.86 5,302,812.78 4.86 0.00 None 1 0 5/15/2017 295,415.78 100.00 295,415.78 0.09% None 1 295,415.78 4.86 295,415.78 4.86 19,272,314.71 0.00 None 0 5/15/2017 19,272,314.71 100.00 19,272,314.71 5.93% None 4.86 19,272,314.71 4.86 0.00 None 1 0 Texas Class LGIP TX-01-0615-0001 3,659,093.01 6/15/2020 3,659,093.01 100.00 3,659,093.01 1.13% None 4.86 3,659,093.01 4.86 0.00 None 1 0 Texas Class LGIP TX-01-0615-0001 12/15/2020 64,404.43 100.00 64,404.43 0.02% None 64,404.43 4.86 64,404.43 4.86 0.00 None 1 0 Texas Class LGIP TX-01-0615-0001 2,575,874.21 1/15/2022 2,575,874.21 100.00 2,575,874.21 0.79% None 4.86 2,575,874.21 4.86 0.00 None 1 0 Texas Class LGIP 1/15/2022 3,091,049.03 100.00 3,091,049.03 0.95% None 1 TX-01-0615-0001 3,091,049.03 4.86 3,091,049.03 4.86 0.00 None 0 Prepared by Jonathan Rodriguez 14 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 3/31 /2023 Description CUSIP Face Amount / Shares Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Days To Call/Maturity Duration To Maturity Texas Class LGIP TX-01-0615-0001 2,117.23 1/15/2022 4.86 2,117.23 2,117.23 100.00 4.86 2,117.23 0% 0.00 Texas Class LGIP TX-01-0615-0001 10,303,088.34 1/15/2022 10 , 303, 088.34 4.86 10,303,088.34 100.00 10,303,088.34 4.86 3.17% 0.00 None None 1 0 None None 1 0 Texas Class LGIP TX-01-0615-0013 2,581,920.46 8/15/2021 2,581,920.46 100.00 2,581,920.46 0.79% None 4.86 2,581,920.46 4.86 0.00 None 1 0 Texas Class LGIP TX-01-0615-0014 3,459,752.75 8/15/2021 3,459,752.75 100.00 3,459,752.75 1.06% None 4.86 3,459,752.75 4.86 0.00 None 1 0 Texas Class LGIP TX-01-0615-0009 2,840,467.03 8/11/2020 2,840,467.03 100.00 2,840,467.03 0.87% None 4.86 2,840,467.03 4.86 0.00 None 1 0 Texas Class LGIP TX-01-0615-0007 2,908,067.44 9/19/2019 2,908,067.44 100.00 2,908,067.44 0.89% None 4.86 2,908,067.44 4.86 0.00 None 1 0 Texas Class LGIP 9/19/2019 3,403.92 100.00 3,403.92 0% None 1 TX-01-0615-0007 3,403.92 4.86 3,403.92 4.86 0.00 None 0 Texas Class LGIP 9/19/2019 TX-01-0615-0007 585,199.33 4.86 585,199.33 100.00 585,199.33 0.18% None 585,199.33 4.86 0.00 None 1 0 Texas Class LGIP TX-01-0615-0011 1,943,589.15 8/11/2020 1,943,589.15 100.00 1,943,589.15 0.6% None 4.86 1,943,589.15 4.86 0.00 None 1 0 Texas Class LGIP TX-01-0615-0005 2,726,942.98 9/15/2018 2,726,942.98 100.00 2,726,942.98 0.84% None 4.86 2,726,942.98 4.86 0.00 None 1 0 Texas Class LGIP TX-01-0615-0004 9/15/2018 7,311.01 100.00 7,311.01 0% None 7,311.01 4.86 7,311.01 4.86 0.00 None 1 0 Texas Class LGIP 8/15/2021 1,051,910.80 100.00 1,051,910.80 0.32% None 1 TX-01-0615-0015 1,051,910.80 4.86 1,051,910.80 4.86 0.00 None 0 Prepared by Jonathan Rodriguez 15 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 3/31 /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-0006 244,088.21 9/15/2018 4.86 244,088.21 244,088.21 100.00 4.86 244,088.21 0 08% 0.00 None None 1 0 Texas Class LGIP TX-01-0615-0010 TexSTAR LGIP 02000-20190 8/11/2020 474,744.59 100.00 474,744.59 474,744.59 4.86 474,744.59 4.86 0.15% None 0.00 None 1 0 9/19/2019 1,450,807.28 100.00 1,450,807.28 0.45% None 1,450,807.28 4.61 1,450,807.28 4.61 0.00 None 1 0 TexSTAR LGIP 9/27/2019 504,625.33 100.00 504,625.33 0.16% None 02000-20191 504,625.33 4.61 504,625.33 4.61 0.00 None 1 0 TexSTAR LGIP 9/27/2019 523,640.42 100.00 523,640.42 0.16% None 02000-20191 523,640.42 4.61 523,640.42 4.61 0.00 None 1 0 TexSTAR LGIP 02000-11110 1,710,000.30 8/26/2016 1, 710, 000.30 100.00 1, 710, 000.30 0.53% S&P -MA 4.61 1,710,000.30 4.61 0.00 None TexSTAR LGIP 02000-11110 TexSTAR LGIP 02000-20192 Sub Total Local Government Investment Pool 1,207,227.98 8/26/2016 1,207,227.98 100.00 1,207,227.98 0.37% S&P -AAA 4.61 1,207,227.98 4.61 0.00 None 4,131,137.01 147,153,155.95 9/27/2019 4,131,137.01 100.00 4,131,137.01 1.27% None 4.61 4,131,137.01 4.61 0.00 None 4.83 147,153,155.95 147,153,155.95 4.83 147,153,155.95 1 0 1 0 1 0 45.26% 1 0.00 0 TOTAL PORTFOLIO 325,058,331.30 4.51 325,058,301.30 325,058,327.88 4.57 324,866,407.64 42, 581.25 100.00% -191,920.24 10 0.04 Prepared by Jonathan Rodriguez 16 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 3/31 /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.09 2,575.46 -6,073.26 None 1.12 248,000 00 5/11/2022 248,000.00 2.85 248,000.00 97.59 5.09 242,020.33 2,711.01 0.08% -5,979.67 None None 409 1.1 DISCOVER BANK 2.8 5/20/2024 254673D78 5/18/2022 248,000.00 97.55 241,926.74 0.08% None 416 5/18/2022 245,000.00 97.50 238,866.45 0.08% None 416 245,000.00 2.80 245,000.00 5.09 2,499.67 -6,133.55 None 1.12 FFCB 1.94 9/3/2024-22 3133ENQC7 2,000,000.00 3/11/2022 2,000,000.00 96.23 1,924,518.24 0.62% Moodys-Aaa 1.94 2,000,000.00 4.71 3,017.78 -75,481.76 S&P -AA+ 522 1.41 FFCB 3.25 6/17/2024 3133ENYX2 1,000,000.00 6/17/2022 1,000,000.00 3.25 1,000,000.00 98.41 984,076.07 0.31% None 444 4.61 9,388.89 -15,923.93 None 1.19 FHLB 1.6512/28/2023-22 3/28/2022 1,000,000.00 97.64 976,443.38 0.31% Moodys-Aaa 3130ARA27 1,000,000.00 1.65 1,000,000.00 4.93 137.50 -23,556.62 S&P -AA+ 28 0.74 FHLB 2.125 5/12/2023 5/12/2022 999,970.00 99.71 997,079.88 0.31% None 3130AS3T4 1,000,000.00 2.13 999,996.58 4.66 8,204.86 -2,916.70 None 42 0.11 FHLB 2.5 2/13/2024 3130AFW94 1,250,000.00 5/11/2022 1,250,000.00 98.05 1,225,685.13 0.38% Moodys-Aaa 319 2.50 1,250,000.00 4.82 4,166.67 -24,314.87 S&P -AA+ 0.86 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.34 993,382.74 0.31% None 5.11 2,916.67 -6,617.26 None FHLB 4.0 09/16/24-22 4 9/16/2024-22 3130ASZG7 FHLB 4.125 09/29/23-22 4.125 9/29/2023-22 3130ATE78 9/16/2022 1,000,000.00 1,000,000.00 4.00 1,000,000.00 58 0.42 98.85 988,450.81 0.31% None 4.83 1,666.67-11,549.19 None 9/29/2022 1,000,000.00 1,000,000.00 4.13 1,000,000.00 77 1.43 99.68 996,781.07 0.31 % None 4.79 229.17 -3,218.93 None 182 0.49 FHLB 4.375 09/29/25-23 4.375 9/29/2025-23 9/29/2022 1,000,000.00 3130ATE29 1,000,000.00 4.38 1,000,000.00 99.30 992,958.38 0.31% None 4.68 243.06 -7,041.62 None 182 2.39 17 Prepared by Jonathan Rodriguez City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 3/31/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 JP MORGAN CHASE BANK NA 09/22/23-23 3.75 9/2 46593LPF0 245,000.00 9/23/2022 3.75 245,000.00 245,000.00 99.39 5.06 243, 510.34 201.37 0.08% -1,489.66 None None 175 0.48 MORGAN STANLEY BANK NA 3.7 9/22/2023 61690US35 240,000.00 3.70 240,000.00 5.05 4,622.47 -1,623.22 None 0.48 9/22/2022 240,000.00 99.32 238,376.78 0.07% None 175 Texas Class LGIP TX-01-0615-0001 19,272,314.71 5/15/2017 19,272,314.71 100.00 19,272,314.71 5.93% None 4.86 19,272,314.71 4.86 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP Sub Total 100: General Fund 22, 779,189.94 5/31/2006 22,779,189.94 100.00 22,779,189.94 7.01% None 4.65 22,779,189.94 4.65 0.00 None 1 0 53,527,504.65 4.36 53,527,474.65 53,527,501.23 4.76 53,335,580.99 42,581.25 16.5% -191,920.24 54 0.22 Texas Class LGIP TX-01-0615-0001 Wells Fargo Sweep Cash WFSWEEP Sub Total 200: Debt Services 89,682.87 15,365,193.33 15,454,876.20 5,302,812.78 305: Hotel/Motel Occupancy Texas Class LGIP TX-01-0615-0001 Wells Fargo Sweep Cash WFSWEEP 1/15/2017 4.86 89,682.87 89,682.87 100.00 4.86 89,682.87 0.03% 0.00 None None 1 0 5/31/2006 15,365,193.33 4.65 15,365,193.33 100.00 15,365,193.33 4.65 4.73% 0.00 None None 1 0 4.65 15,454,876.20 15,454,876.20 4.65 15,454,876.20 5/15/2017 5,302,812.78 100.00 5,302,812.78 4.86 5,302,812.78 4.86 4.76% 0.00 1.63% 0.00 None None 1 0 0 1,415,085.32 5/31/2006 1,415,085.32 4.65 1,415,085.32 100.00 1,415,085.32 4.65 0.44% 0.00 None None 1 0 6,717,898.10 Sub Total 305: Hotel/Motel Occupancy 6,717,898.10 4.81 6,717,898.10 310: Municipal Court Security 4.81 6,717,898.10 2.07% 0.00 1 0 Prepared by Jonathan Rodriguez 18 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 3/31/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 Sub Total 310: Municipal Court Security 59,023.60 5/31/2006 4.65 59,023.60 59,023.60 100.00 4.65 59,023.60 0.02% 0.00 None None 1 0 59,023.60 4.65 59,023.60 59,023.60 4.65 59,023.60 0.02% 0.00 1 0 315: City Wide Donation Wells Fargo Sweep Cash WFSWEEP Sub Total 315: City Wide Donation 320: Court Technology 355,754.05 5/31/2006 4.65 355,754.05 355,754.05 100.00 4.65 355,754.05 355,754.05 4.65 355,754.05 4.65 355,754.05 355,754.05 0.11% 0.00 0.11% 0.00 None None 0 1 0 Wells Fargo Sweep Cash WFSWEEP Sub Total 320: Court Technology 325: Street Assessment 5/31/2006 5,631.92 100.00 5,631.92 0% None 5,631.92 4.65 5,631.92 4.65 0.00 None 1 0 5,631.92 5,631.92 4.65 5,631.92 4.65 5,631.92 0% 1 0.00 0 Wells Fargo Sweep Cash WFSWEEP Sub Total 325: Street Assessment 330: Park Donations Wells Fargo Sweep Cash WFSWEEP Sub Total 330: Park Donations 12/15/2021 51.47 100.00 51.47 0% None 51.47 4.65 51.47 4.65 0.00 None 1 0 51.47 51.47 0% 51.47 4.65 51.47 4.65 84,590.45 84,590.45 0.00 5/31/2006 84,590.45 100.00 84,590.45 0.03% None 4.65 84,590.45 4.65 4.65 0.00 None 1 0 1 0 84,590.45 84,590.45 4.65 84,590.45 0.03% 0.00 1 0 331: Tree Trust Fund Wells Fargo Sweep Cash WFSWEEP 1,525,918.04 5/31/2006 4.65 1,525,918.04 1,525,918.04 100.00 4.65 1,525,918.04 0.47% 0.00 None None 1 0 Prepared by Jonathan Rodriguez 19 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 3/31/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 331: Tree Trust Fund 1,525,918.04 4.65 1,525,918.04 1,525,918.04 4.65 1,525,918.04 0.47% 0.00 1 0 332: Parks Financl Asstance Donations Wells Fargo Sweep Cash WFSWEEP Sub Total 332: Parks Financl Asstance Donations 10/15/2019 -8,156.41 100.00 -8,156.41 -8,156.41 4.65 -8,156.41 4.65 -8,156.41 4.65 -8,156.41 -8,156.41 4.65 0% 0.00 -8,156.41 0% 0.00 None None 1 0 0 335: Police State Seizure Wells Fargo Sweep Cash WFSWEEP Sub Total 335: Police State Seizure 5/31/2006 177,471.10 4.65 177,471.10 4.65 177,471.10 100.00 177,471.10 0.05% None 177,471.10 4.65 0.00 None 1 0 177,471.10 177,471.10 0.05% 1 177,471.10 4.65 0.00 0 336: Federal Police Fund Wells Fargo Sweep Cash 5/31/2006 238,252.54 100.00 238,252.54 0.07% None WFSWEEP Sub Total 336: Federal Police Fund 238,252.54 4.65 238,252.54 4.65 238,252.54 4.65 0.00 None 238,252.54 238,252.54 238,252.54 4.65 1 0 0.07% 1 0.00 0 337: Community Safety Fund Wells Fargo Sweep Cash 6/1/2022 220,810.57 100.00 220,810.57 0.07% None WFSWEEP 220,810.57 4.65 220,810.57 4.65 0.00 None Sub Total 337: Community Safety Fund 220,810.57 4.65 220,810.57 220,810.57 220,810.57 4.65 1 0 0.07% 1 0.00 0 340: Park & Rec Development Wells Fargo Sweep Cash 5/31/2006 735,992.38 100.00 735,992.38 0.23% None WFSWEEP 735,992.38 4.65 735,992.38 4.65 0.00 None Sub Total 340: Park & Rec Development 735,992.38 4.65 735,992.38 735,992.38 735,992.38 4.65 1 0 0.23% 1 0.00 0 345: Sidewalk Fund Prepared by Jonathan Rodriguez 20 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 3/31/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 345: Sidewalk Fund 64,814.89 5/31/2006 4.65 64,814.89 4.65 64,814.89 64,814.89 100.00 4.65 64,814.89 64,814.89 4.65 64,814.89 64,814.89 0.02% 0.00 0.02% 0.00 None None 1 0 1 0 346: Drainage Maintenance Fund Wells Fargo Sweep Cash WFSWEEP Sub Total 346: Drainage Maintenance Fund 10/15/2022 456,280.75 100.00 456,280.75 0.14% None 1 456,280.75 4.65 456,280.75 4.65 0.00 None 0 456,280.75 4.65 456,280.75 456,280.75 4.65 456,280.75 0.14% 0.00 1 0 350: Grant Fund Wells Fargo Sweep Cash 5/31/2006 -700,466.78 WFSWEEP Sub Total 350: Grant Fund -700,466.78 4.65 -700,466.78 4.65 -700,466.78 -700,466.78 -700,466.78 100.00 -700,466.78 -0.22% None 4.65 4.65 -700,466.78 0.00 None 1 0 -0.22% 1 0.00 0 351: CDBG Fund Wells Fargo Sweep Cash WFSWEEP Sub Total 351: CDBG Fund 11/15/2015 13,689.63 100.00 13,689.63 0% None 13,689.63 4.65 13,689.63 4.65 0.00 None 13,689.63 4.65 1 0 13,689.63 13,689.63 0% 1 13,689.63 4.65 0.00 0 352: CDBG - Disaster Recovery Fund Wells Fargo Sweep Cash 11/15/2020 -280,481.09 100.00 -280,481.09 -0.09% None WFSWEEP -280,481.09 4.65-280,481.09 4.65 0.00 None Sub Total 352: CDBG - Disaster Recovery Fund -280,481.09 4.65 -280,481.09 -280,481.09 4.65 -280,481.09 1 0 -0.09% 1 0.00 0 353: Disaster Recovery Fund Wells Fargo Sweep Cash 9/15/2020 -307,286.07 WFSWEEP -307,286.07 4.65-307,286.07 Prepared by Jonathan Rodriguez 100.00 -307,286.07 -0.09% None 4.65 0.00 None 1 0 21 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 3/31/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 353: Disaster Recovery Fund -307,286.07 4.65 -307,286.07 -307,286.07 4.65 -307,286.07 -0.09% 0.00 1 0 354: Hazard Mitigation Fund Wells Fargo Sweep Cash WFSWEEP Sub Total 354: Hazard Mitigation Fund 11/15/2020 -59,124.74 4.65 -59,124.74 4.65 -59,124.74 100.00-59,124.74-0.02% None -59,124.74 4.65 0.00 None -59,124.74 -59,124.74 4.65 -59,124.74 -0.02% 0.00 1 0 0 355: Coronavirus Relief Fund Wells Fargo Sweep Cash WFSWEEP -2,326,277.99 Sub Total 355: Coronavirus Relief Fund -2,326,277.99 5/15/2020 -2,326,277.99 4.65-2,326,277.99 4.65 -2,326,277.99 -2,326,277.99 100.00 -2,326,277.99 -0.72% None 4.65 0.00 None 4.65 -2,326,277.99 1 0 -0.72% 0.00 1 0 356: ARPA Fund Wells Fargo Sweep Cash WFSWEEP Sub Total 356: ARPA Fund 5,751,654.86 5/15/2021 4.65 5, 751, 654.86 4.65 5,751,654.86 5,751,654.86 5,751,654.86 5,751,654.86 100.00 4.65 4.65 5,751,654.86 5, 751, 654.86 1.77% 0.00 1.77% 0.00 None None 0 1 0 357: Opi-oid Settlement Wells Fargo Sweep Cash WFSWEEP Sub Total 357: Opi-oid Settlement 3/15/2023 104,771.64 4.65 104,771.64 4.65 104,771.64 100.00 104,771.64 0.03% None 104,771.64 4.65 0.00 None 104,771.64 104,771.64 4.65 104,771.64 0.03% 1 0 1 0.00 0 360: Traffic Impact Improvement Wells Fargo Sweep Cash 5/31/2006 333,879.61 100.00 333,879.61 0.1% None WFSWEEP Sub Total 360: Traffic Impact Improvement 333,879.61 4.65 333,879.61 4.65 333,879.61 4.65 0.00 None 333,879.61 333,879.61 333,879.61 4.65 1 0 0.1% 1 0.00 0 365: Court Juvenile Mgmt Prepared by Jonathan Rodriguez 22 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 3/31/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 365: Court Juvenile Mgmt 273.78 9/15/2009 4.65 273.78 4.65 273.78 273.78 273.78 100.00 4.65 273.78 4.65 273.78 273.78 0% 0.00 0% 0.00 None None 1 0 1 0 366: Municipal Jury Fund Wells Fargo Sweep Cash WFSWEEP Sub Total 366: Municipal Jury Fund 1/15/2020 2,150.19 4.65 2,150.19 4.65 2,150.19 100.00 2,150.19 0% None 1 2,150.19 4.65 0.00 None 0 2,150.19 2,150.19 4.65 2,150.19 0% 0.00 1 0 370: Municipal Channel Texas Class LGIP TX-01-0615-0001 295,415.78 Wells Fargo Sweep Cash WFSWEEP 148,625.73 Sub Total 370: Municipal Channel 5/15/2017 295,415.78 100.00 295,415.78 4.86 295,415.78 4.86 4/15/2012 148, 625.73 100.00 148, 625.73 4.65 148,625.73 4.65 444,041.51 4.79 444,041.51 444,041.51 444,041.51 4.79 0.09% 0.00 0.05% 0.00 None None None None 1 0 1 0 0.14% 1 0.00 0 380: Regional Detention Wells Fargo Sweep Cash 5/31/2006 203,080.60 100.00 203,080.60 0.06% None WFSWEEP 203,080.60 4.65 203,080.60 4.65 0.00 None Sub Total 380: Regional Detention 203,080.60 4.65 203,080.60 203,080.60 203,080.60 4.65 1 0 0.06% 1 0.00 0 500: Capital Projects Texas Class LGIP TX-01-0615-0001 Wells Fargo Cash WF3025 Prepared by Jonathan Rodriguez 2,645,048.34 1/15/2017 2,645,048.34 4.86 2,645,048.34 100.00 2,645,048.34 0.81% None 1 4.86 0.00 None 0 8/12/2020 2,771.11 100.00 2,771.11 0% None 2,771.11 0.00 2,771.11 0.00 0.00 None 1 0 23 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 3/31/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 Sub Total 500: Capital Projects 3,026,674.11 501: Certificates of Obligation Texas Class LGIP TX-01-0615-0001 Texas Class LGIP TX-01-0615-0007 5,674,493.56 2,072,782.13 5/31/2006 4.65 3,026,674.11 3,026,674.11 100.00 4.65 3,026,674.11 0.93% 0.00 None None 1 0 4.74 5,674,493.56 5,674,493.56 4.74 5,674,493.56 1.74% 0.00 1 0 12/20/2016 2,072,782.13 100.00 2,072,782.13 4.86 2,072,782.13 4.86 0.64% 0.00 None None 0 585,199.33 9/19/2019 585,199.33 4.86 585,199.33 100.00 4.86 585,199.33 0.18% None 0.00 None 1 0 Texas Class LGIP TX-01-0615-0006 9/15/2018 244,088.21 100.00 244,088.21 0.08% None 244,088.21 4.86 244,088.21 4.86 0.00 None 1 0 TexSTAR LGIP 9/27/2019 523,640.42 100.00 523,640.42 0.16% None 1 02000-20191 523,640.42 4.61 523,640.42 4.61 0.00 None 0 TexSTAR LGIP 02000-11110 1,207,227.98 8/26/2016 1,207,227.98 100.00 1,207,227.98 0.37% S&P -AAA 1 4.61 1,207,227.98 4.61 0.00 None 0 TexSTAR LGIP 02000-20192 4,131,137.01 9/27/2019 4,131,137.01 100.00 4,131,137.01 1.27% None 1 4.61 4,131,137.01 4.61 0.00 None 0 Wells Fargo Sweep Cash WFSWEEP 2,247,769.69 Sub Total 501: Certificates of Obligation 11,011,844.77 5/31/2006 2,247,769.69 100.00 2,247,769.69 0.69% None 1 4.65 2,247,769.69 4.65 0.00 None 0 11,011,844.77 11,011,844.77 3.39% 1 4.68 11,011,844.77 4.68 0.00 0 503: Certificates of Obligation 2006 Wells Fargo Sweep Cash 6/30/2006 22,350.00 100.00 22,350.00 0.01% None 1 WFSWEEP Sub Total 503: Certificates of Obligation 2006 22,350.00 4.65 22,350.00 4.65 0.00 None 0 22,350.00 22,350.00 0.01% 1 22,350.00 4.65 22,350.00 4.65 0.00 0 506: General Obligation 24 Prepared by Jonathan Rodriguez City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 3/31/2023 Description CUSIP Face Amount I Settlement Date Cost Value Market Price Market Value °A, 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-0001 12,383,666.61 12/20/2016 4.86 12,383,666.61 12,383,666.61 100.00 4.86 12,383,666.61 3.81 % 0.00 Texas Class LGIP TX-01-0615-0005 2,726,942.98 9/15/2018 2,726,942.98 4.86 2,726,942.98 100.00 2,726,942.98 4.86 0.84% 0.00 None None 1 0 None None 1 0 TexSTAR LGIP 02000-20190 1,450,807.28 9/19/2019 1,450,807.28 100.00 1,450,807.28 0.45% None 4.61 1,450,807.28 4.61 0.00 None 1 0 TexSTAR LGIP 9/27/2019 504,625.33 100.00 504,625.33 0.16% None 02000-20191 504,625.33 4.61 504,625.33 4.61 0.00 None 1 0 TexSTAR LGIP 02000-11110 1,710,000.30 8/26/2016 1,710,000.30 100.00 1,710,000.30 0.53% S&P -AAA 1 4.61 1,710,000.30 4.61 0.00 None 0 Wells Fargo Sweep Cash 10/30/2008 7,334,779.37 100.00 7,334,779.37 2.26% None 1 WFSWEEP 7,334,779.37 4.65 7,334,779.37 4.65 0.00 None 0 26,110,821.87 26,110,821.87 8.05% 1 Sub Total 506: General Obligation 26,110,821.87 4.76 26,110,821.87 4.76 0.00 0 507: General Obligation Series 2020 Wells Fargo Sweep Cash WFSWEEP Sub Total 507: General Obligation Series 2020 -7. 634, 231.50 -7,634,231.50 10/15/2019 -7,634,231.50 100.00 -7,634,231.50 -2.35% None 4.65-7,634,231.50 4.65 0.00 None 4.65 -7,634,231.50 -7,634,231.50 1 0 4.65 -7,634,231.50 -2.35% 1 0.00 0 508: Certificates of Oblg Series 2020 • Texas Class LGIP TX-01-0615-0009 Wells Fargo Sweep Cash WFSWEEP 2,840,467.03 8/11/2020 2,840,467.03 100.00 2,840,467.03 0.87% None 4.86 2,840,467.03 4.86 0.00 None 1 0 10/15/2019 863,132.96 100.00 863,132.96 0.27% None 863,132.96 4.65 863,132.96 4.65 0.00 None Sub Total 508: Certificates of Oblg Series 2020 Prepared by Jonathan Rodriguez 3,703,599.99 4.81 1 0 3,703,599.99 3,703,599.99 4.81 3,703,599.99 0.00 0 25 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 3/31/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 509: General Obligation Series 2021 Texas Class LGIP TX-01-0615-0015 Wells Fargo Sweep Cash WFSWEEP Sub Total 509: General Obligation Series 2021 1,051,910.80 8/15/2021 1,051,910.80 4.86 1,051,910.80 100.00 4.86 1,051,910.80 0.32% 0.00 None None 0 1,194,703.93 10/15/2019 1,194,703.93 100.00 1,194,703.93 0.37% None 4.65 1,194,703.93 4.65 0.00 None 1 0 2,246,614.73 4.75 2,246,614.73 2,246,614.73 4.75 2,246,614.73 0.69% 0.00 1 0 511: PEDC Capital Projects Wells Fargo Sweep Cash WFSWEEP Sub Total 511: PEDC Capital Projects 512: Certificates of Oblg Series 2021 Wells Fargo Sweep Cash WFSWEEP Sub Total 512: Certificates of Oblg Series 2021 -366,618.99 -366,618.99 -13,266,087.11 -13,266,087.11 12/15/2018 -366,618.99 4.65-366,618.99 4.65 100.00 -366,618.99 -0.11% None 4.65 0.00 None 1 0 -366,618.99 -366,618.99 4.65 -366,618.99 -0.11% 0.00 2/15/2020 -13,266,087.11 100.00 -13,266,087.11 -4.08% None 4.65-13,266,087.11 4.65 -13,266,087.11 -13,266,087.11 4.65 4.65 -13,266,087.11 0.00 -4.08% 0.00 None 1 0 0 1 0 513: General Obligation Series 2022 LOGIC LGIP 6028909002 Wells Fargo Sweep Cash WFSWEEP Sub Total 513: General Obligation Series 2022 14,051,583.55 7/26/2022 4.82 14,051,583.55 14,051,583.55 100.00 14,051,583.55 4.82 2,605,876.09 16,657,459.64 4.32% 0.00 None None 10/1/2020 2,605,876.09 100.00 2,605,876.09 0.8% None 4.65 2,605,876.09 4.65 0.00 None 1 0 1 0 4.79 16,657,459.64 16,657,459.64 4.79 16,657,459.64 5.12% 1 0.00 0 514: Infrastructure Reinvestment Fund 1 Wells Fargo Sweep Cash WFSWEEP Prepared by Jonathan Rodriguez 1,362,944.69 12/15/2019 1,362,944.69 100.00 1,362,944.69 0.42% None 4.65 1,362,944 69 4.65 0.00 None 1 0 26 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 3/31/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 514: Infrastructure Reinvestment Fund 1,362,944.69 4.65 1,362,944.69 1,362,944.69 4.65 1,362,944.69 0.42% 0.00 1 0 515: Certificates of Oblig 2020 TIRZ Texas Class LGIP TX-01-0615-0010 Wells Fargo Sweep Cash WFSWEEP Sub Total 515: Certificates of Oblig 2020 TIRZ 8/11/2020 474,744.59 100.00 474,744.59 4.86 474,744.59 4.86 8/15/2020 1,202,085.52 100.00 1,202,085.52 4.65 1,202,085.52 4.65 1,676,830.11 1,676,830.11 4.71 1,676,830.11 4.71 474,744.59 1, 202, 085.52 1, 676, 830.11 0.15% 0.00 0.37% 0.00 0.52% 0.00 None None None None 1 0 1 0 0 516: Certificates of Oblig 2021 TIRZ Texas Class LGIP 8/15/2021 2,581,920.46 100.00 2,581,920.46 0.79% None 1 TX-01-0615-0013 2,581,920.46 4.86 2,581,920.46 4.86 0.00 None 0 Wells Fargo Sweep Cash 10/1/2020 744,718.77 100.00 744,718.77 0.23% None 1 WFSWEEP 744,718.77 4.65 744,718.77 4.65 0.00 None 0 3,326,639.23 3,326,639.23 1.02% 1 Sub Total 516: Certificates of Oblig 2021 3,326,639.23 4.81 3,326,639.23 4.81 0.00 0 TIRZ 517: Certificates of Obligation 2022 al LOGIC LGIP 7/26/2022 8,424,257.29 100.00 8,424,257.29 2.59% None 1 6028909003 8,424,257.29 4.82 8,424,257.29 4.82 0.00 None 0 Wells Fargo Sweep Cash 10/1/2020 1,182,951.65 100.00 1,182,951.65 0.36% None 1 WFSWEEP 1,182,951.65 4.65 1,182,951.65 4.65 0.00 None 0 9,607,208.94 9,607,208.94 2.95% 1 Sub Total 517: Certificates of Obligation 9,607,208.94 4.80 9,607,208.94 4.80 0.00 0 2022 518: Certificates of Oblig 2022 TIRZ LOGIC LGIP 6028909004 Prepared by Jonathan Rodriguez 3,393,631.07 7/26/2022 3,393,631.07 4.82 3,393,631.07 100.00 3,393,631.07 1.04% None 4.82 0.00 None 1 0 27 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 3/31/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 518: Certificates of Oblig 2022 TIRZ 3,168, 391.26 10/1/2020 4.65 6,562,022.33 4.73 3,168, 391.26 3,168, 391.26 6,562,022.33 6,562,022.33 100.00 4.65 4.73 3,168, 391.26 6,562,022.33 0.97% 0.00 2.01% 0.00 None None 1 0 1 0 519: General Obligation Series 2023 Wells Fargo Sweep Cash WFSWEEP Sub Total 519: General Obligation Series 2023 10/15/2021 -83,703.02 4.65 -83,703.02 4.65 -83,703.02 100.00 -83,703.02 -0.03% None -83,703.02 4.65 0.00 None -83,703.02 -83,703.02 4.65 1 0 -83,703.02-0.03% 1 0.00 0 520: Certificates of Oblg Series 2023 Wells Fargo Sweep Cash 10/15/2021 -122,197.50 WFSWEEP Sub Total 520: Certificates of Oblg Series 2023 -122,197.50 4.65 -122,197.50 4.65 -122,197.50 -122,197.50 -122,197.50 100.00 -122,197.50 -0.04% None 4.65 0.00 None 4.65 -122,197.50 1 0 -0.04% 1 0.00 0 521: Drainage CIP Fund Wells Fargo Sweep Cash WFSWEEP Sub Total 521: Drainage CIP Fund 10/15/2022 -12,840.48 100.00 -12,840.48 0% None -12,840.48 4.65-12,840.48 4.65 0.00 None -12,840.48 4.65 1 0 -12,840.48 -12,840.48 0% 1 -12,840.48 4.65 0.00 0 524: TIRZ CO Series 2023 Wells Fargo Sweep Cash 10/15/2022 -6,802.98 100.00 -6,802.98 0% None WFSWEEP -6,802.98 4.65-6,802.98 4.65 0.00 None Sub Total 524: TIRZ CO Series 2023 1 0 -6,802.98 -6,802.98 0% 1 -6,802.98 4.65-6,802.98 4.65 0.00 0 550: W/S Impact Fee Texas Class LGIP 12/20/2016 63.31 100.00 63.31 0% None TX-01-0615-0001 63.31 4.86 63.31 4.86 0.00 None Prepared by Jonathan Rodriguez 1 0 28 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 3/31/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-0007 2,908,067.44 9/19/2019 4.86 2,908,067.44 2,908,067.44 100.00 4.86 2,908,067.44 0 89% 0.00 None None 1 0 Wells Fargo Sweep Cash WFSWEEP 5/31/2006 14,375.19 100.00 14,375.19 14,375.19 4.65 14,375.19 4.65 0% None 0.00 None 1 0 Wells Fargo TWDB Cash WF4094 Wells Fargo TWDB Cash WF6624 11/1/2016 58,565.67 100.00 58,565.67 0.02% None 58,565.67 4.65 58,565.67 4.65 0.00 None 1 0 5/15/2018 989,445.22 100.00 989,445.22 0.3% None 989,445.22 4.65 989,445.22 4.65 0.00 None 1 0 Wells Fargo TWDB Cash 4/1/2021 3,829,767.23 100.00 3,829,767.23 1.18% None WF3100 3,829,767.23 4.16 3,829,767.23 4.16 0.00 None 1 0 Wells Fargo TWDB Cash WF2847 6,205,603.20 Wells Fargo TWDB Cash WF4102 Wells Fargo TWDB Cash WF5883 Sub Total 550: W/S Impact Fee 8/6/2019 6,205,603.20 100.00 6,205,603.20 1.91% None 4.65 6,205,603.20 4.65 0.00 None 1 0 11/1/2016 156,452.97 100.00 156,452.97 0.05% None 156,452.97 4.65 156,452.97 4.65 0.00 None 1 0 2,469,859.85 3/15/2017 2,469,859.85 4.65 2,469,859.85 100.00 2,469,859.85 0.76% None 4.65 0.00 None 1 0 16,632,200.08 4.57 16,632,200.08 16,632,200.08 4.57 16,632,200.08 5.11% 0.00 Texas Class LGIP 1/15/2022 3,091,049.03 100.00 3,091,049.03 0.95% None TX-01-0615-0001 3,091,049.03 4.86 3,091,049.03 4.86 0.00 None Wells Fargo Sweep Cash WFSWEEP Sub Total 551: Water Impact Fee Fund 1 0 0 1,202,826.92 1/15/2020 1,202,826.92 4.65 1,202,826.92 4,293,875.95 4.80 100.00 1,202,826.92 4.65 4,293,875.95 4,293,875.95 4.80 0.37% None 0.00 None 1 0 4,293,875.95 1.32% 0.00 1 0 552: Waste Water Impact Fee Fund Prepared by Jonathan Rodriguez 29 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 3/31 /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 Texas Class LGIP TX-01-0615-0001 Wells Fargo Sweep Cash WFSWEEP Sub Total 552: Waste Water Impact Fee Fund Texas Class LGIP TX-01-0615-0001 Texas Class LGIP TX-01-0615-0007 Texas Class LGIP TX-01-0615-0004 2,575,874.21 1/15/2022 4.86 2,575,874.21 2,575,874.21 100.00 4.86 2,575,874.21 0.79% 0.00 None None 1 0 2,508,993.23 5,084,867.44 1/15/2020 2,508,993.23 4.65 2,508,993.23 100.00 2,508,993.23 4.65 0.77% 0.00 None None 1 0 4.75 5,084,867.44 5,084,867.44 2,595,363.88 1/15/2017 2,595,363.88 4.86 2,595,363.88 5,084,867.44 4.75 1.56% 0.00 100.00 2,595,363.88 0.8% None 4.86 3,403.92 9/19/2019 3,403.92 4.86 3,403.92 100.00 4.86 3,403.92 0.00 None 1 0 0 0% None 0.00 None 1 0 9/15/2018 7,311.01 100.00 7,311.01 0% None 7,311.01 4.86 7,311.01 4.86 0.00 None 1 0 Wells Fargo Sweep Cash 5/31/2006 1,158,034.10 100.00 1,158,034.10 0.36% None WFSWEEP 1,158,034.10 4.65 1,158,034.10 4.65 0.00 None 1 0 Wells Fargo TWDB Cash WF5875 Sub Total 565: Revenue Bonds 1999 & 2003 9/15/2017 945,799.37 100.00 945,799.37 0.29% None 1 945,799.37 4.65 945,799.37 4.65 4,709,912.28 4.76 4,709,912.28 4,709,912.28 4.76 4,709,912.28 0.00 None 0 1.45°/ 1 0.00 0 566: Revenue Bonds Series 2020 Texas Class LGIP TX-01-0615-0011 1,943,589.15 8/11/2020 1,943,589.15 100.00 1,943,589.15 0.6% None 4.86 1,943,589.15 4.86 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 1,333,862.71 Sub Total 566: Revenue Bonds Series 2020 Prepared by Jonathan Rodriguez 10/15/2019 1,333,862.71 100.00 1,333,862.71 0.41% None 4.65 1,333,862.71 4.65 0.00 None 1 0 3,277,451.86 3,277,451.86 4.77 3,277,451.86 4.77 3,277,451.86 0.00 0 30 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 3/31 /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 567: Water Drinking Bonds Series 2020 Texas Class LGIP TX-01-0615-0001 Wells Fargo Sweep Cash WFSWEEP 2,117.23 1/15/2022 4.86 2,117.23 2,117.23 100.00 4.86 2,117.23 0% 0.00 None None 0 -9,589,356.80 10/15/2019 -9,589,356.80 100.00 -9,589,356.80 -2.95% None 4.65-9,589,356.80 4.65 0.00 None 1 0 Wells Fargo TWDB Cash WF6100 Sub Total 567: Water Drinking Bonds Series 2020 30,075,944.46 20,488,704.89 6/16/2020 30,075,944.46 100.00 30,075,944.46 9.25% None 4.16 30,075,944.46 4.16 0.00 None 1 0 20,488,704.89 3.93 20,488,704.89 3.93 20,488,704.89 6.3% 0.00 1 0 Texas Class LGIP TX-01-0615-0014 Wells Fargo Sweep Cash WFSWEEP Sub Total 568: Revenue Bonds Series 2021 3,459,752.75 8/15/2021 3,459,752.75 100.00 3,459,752.75 1.06% None 4.86 3,459,752.75 4.86 0.00 None 0 1,146,009.31 10/15/2019 1,146, 009.31 4.65 1,146,009.31 100.00 1,146,009.31 4.65 4,605,762.06 4.81 4,605,762.06 4,605,762.06 4.81 4,605,762.06 0.35% 0.00 None None 1 0 1.41% 0.00 1 0 569: Revenue Bonds Series 2022 LOGIC LGIP 6028909005 28,511,429.50 7/26/2022 28,511,429.50 4.82 28,511,429.50 100.00 28,511,429.50 8.77% None 1 4.82 0.00 None 0 Wells Fargo Sweep Cash 10/15/2019 531,887.94 100.00 531,887.94 0.16% None WFSWEEP 531,887.94 4.65 531,887.94 4.65 0.00 None Sub Total 569: Revenue Bonds Series 2022 29,043,317.44 4.81 1 0 29,043,317.44 29, 043, 317.44 4.81 29,043,317.44 8.93% 1 0.00 0 570: W/S Pay As You Go Texas Class LGIP TX-01-0615-0001 Prepared by Jonathan Rodriguez 3,659,093.01 6/15/2020 3,659,093.01 100.00 3,659,093.01 1.13% None 4.86 3,659,093.01 4.86 0.00 None 1 0 31 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 3/31/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 1,039,970.14 12/31/2007 4.65 1,039,970.14 1,039,970.14 100.00 4.65 1,039,970.14 0.32% 0.00 None None 1 0 4,699,063.15 4,699,063.15 Sub Total 570: W/S Pay As You Go 4,699,063.15 4.81 4,699,063.15 4.81 571: TWDB Revenue Bonds Series 2021 Wells Fargo Sweep Cash 10/1/2020 -49,213,048.82 100.00 -49,213,048.82 WFSWEEP -49,213,048.82 4.65-49,213,048.82 4.65 Wells Fargo TWDB Cash WF3100 Sub Total 571: TWDB Revenue Bonds Series 2021 1.45% 0.00 -15.14% 0.00 None None 1 0 1 0 71,254,235.11 4/1/2021 71,254,235.11 100.00 71,254,235.11 4.16 71,254,235.11 4.16 21.92% None 0.00 None 1 0 22, 041,186.29 22,041,186.29 3.07 22,041,186.29 3.07 22,041,186.29 6.78% 0.00 1 0 574: Revenue Bonds Series 2023 Wells Fargo Sweep Cash WFSWEEP Sub Total 574: Revenue Bonds Series 2023 -190,487.52 -190,487.52 10/15/2021 -190,487.52 4.65 -190,487.52 100.00 -190,487.52 -0.06% None 4.65 0.00 None 0 4.65 -190,487.52 -190,487.52 4.65 -190,487.52 -0.06% 0.00 1 0 Wells Fargo Sweep Cash WFSWEEP Sub Total 575: MUD 4 Capital Programs 576: Revenue Bonds Series 2024 Wells Fargo Sweep Cash WFSWEEP Sub Total 576: Revenue Bonds Series 2024 25,963.32 25,963.32 -10,365.00 2/1/2013 4.65 4.65 25,963.32 100.00 25,963.32 4.65 25,963.32 0.01% None 0.00 None 0 25,963.32 25,963.32 4.65 25,963.32 0.01% 0.00 10/15/2021 -10,365.00 100.00 -10,365.00 0% None 4.65 -10,365.00 -10,365.00 -10,365.00 4.65-10,365.00 4.65 4.65 -10,365.00 0.00 0% 0.00 None 1 0 0 1 0 600: Water & Sewer Prepared by Jonathan Rodriguez 32 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 3/31 /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-0001 64,641.89 12/20/2016 4.86 64,641.89 64,641.89 100.00 4.86 64,641.89 0 02% 0.00 Wells Fargo Sweep Cash WFSWEEP Sub Total 600: Water & Sewer 12,567,443.70 5/31/2006 12, 567,443.70 4.65 12,567,443.70 100.00 12,567,443.70 4.65 3.87% 0.00 None None 1 0 None None 1 0 12,632,085.59 4.65 12,632,085.59 12,632,085.59 3.89% 1 12,632,085.59 4.65 0.00 0 601: Water & Sewer Debt Fund Texas Class LGIP TX-01-0615-0001 Wells Fargo Sweep Cash WFSWEEP Sub Total 601: Water & Sewer Debt Fund Wells Fargo Sweep Cash WFSWEEP Sub Total 610: Solidwaste 12/15/2020 64,404.43 100.00 64,404.43 0.02% None 1 64,404.43 4.86 64,404.43 4.86 0.00 None 0 10/15/2020 28,246,511.18 28,246,511.18 4.65 28,246,511.18 28,310,915.61 27,301.15 100.00 28,246,511.18 8.69% None 4.65 0.00 None 1 0 4.65 12/1/2006 4.65 28,310,915.61 28,310,915.61 27,301.15 27,301.15 27,301.15 4.65 27,301.15 27, 301.15 28,310,915.61 4.65 100.00 27,301.15 4.65 27, 301.15 4.65 8.71% 0.00 0.01% 0.00 None None 1 0 0 0.01% 0.00 1 0 Wells Fargo Cash WF1376 Wells Fargo Sweep Cash WFSWEEP 40,541.35 1,651,747.11 Sub Total 700: Risk Management Fund 1,692,288.46 10/15/2020 0.83 40,541.35 40,541.35 100.00 40,541 35 0.83 10/31/2006 1,651,747.11 100.00 1, 651, 747.11 4.65 1,651,747.11 4.65 1, 692, 288.46 1,692,288.46 4.55 1,692,288.46 4.55 0.01% 0.00 None None 0 0.51% None 0.00 None 1 0 0.52% 0.00 1 0 701: Employee Benefit Fund Prepared by Jonathan Rodriguez 33 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 3/31/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 Sub Total 701: Employee Benefit Fund Wells Fargo Cash WF9871 Wells Fargo Sweep Cash WFSWEEP Sub Total 702: Health Claims Fund -27,411.36 9/1/2007 4.65 -27,411.36 -27,411.36 100.00 4.65 -27,411.36 -0.01% 0.00 None None 1 0 -27,411.36 4.65 -27,411.36 -27,411.36 4.65 -27,411.36 -0.01% 0.00 7/21/2010 381,142.91 100.00 381,142.91 0.12% None 381,142.91 0.84 381,142.91 0.84 0.00 None 2,602,998.33 2,984,141.24 9/15/2010 2,602,998.33 4.65 2,602,998.33 100.00 2,602,998.33 4.65 0.8% 0.00 None None 1 0 0 1 0 4.16 2,984,141.24 2,984,141.24 4.16 2,984,141.24 0.92% 0.00 1 0 Texas Class LGIP TX-01-0615-0001 10,303,088.34 1/15/2022 10,303,088.34 100.00 10,303,088.34 3.17% None 4.86 10,303,088.34 4.86 0.00 None 0 Wells Fargo Sweep Cash WFSWEEP Sub Total 703: Motor Pool Fund 4,325,599.38 10/15/2018 4,325,599.38 4.65 4,325,599.38 14,628,687.72 4.80 100.00 4,325,599.38 4.65 14,628,687.72 14,628,687.72 4.80 1.33% 0.00 None None 1 0 14,628,687.72 4.5% 0.00 1 0 704: Facilities Fund Wells Fargo Sweep Cash WFSWEEP 10/15/2022 721,580.13 100.00 721,580.13 0.22% None 721,580.13 4.65 721,580.13 4.65 0.00 None 721,580.13 1 0 721,580.13 0.22% 1 Sub Total 704: Facilities Fund 721,580.13 4.65 721,580.13 4.65 0.00 0 705: Information Technology Fund _ Wells Fargo Sweep Cash 10/15/2022 173,815.85 100.00 173,815.85 0.05% None 1 WFSWEEP 173,815.85 4.65 173,815.85 4.65 0.00 None 0 Prepared by Jonathan Rodriguez 34 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 3/31/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 705: Information Technology Fund 173,815.85 4.65 173,815.85 173,815.85 4.65 173,815.85 0.05% 0.00 1 0 800: Long Term Debt Wells Fargo Sweep Cash WFSWEEP Sub Total 800: Long Term Debt 10/15/2022 -53,493.06 100.00 -53,493.06 -0.02% None -53,493.06 4.65-53,493.06 4.65 0.00 None -53,493.06 4.65 -53,493.06 -53,493.06 4.65 -53,493.06 -0.02% 0.00 1 0 1 0 TOTAL PORTFOLIO 325,058,331.30 4.51 325,058,301.30 325,058,327.88 4.57 324,866,407.64 42,581.25 100.00% -191,920.24 10 0.04 Prepared by Jonathan Rodriguez 35 City of Pearland Treasury Yield Curve Treasury 12/31/2022 1/31/2023 2/28/2023 3/31 /2023 1 Month 3 Month 6 Month 1 Year 2 Year 3 Year 5 Year 10 Year 3.90 4.36 4.71 4.68 4.29 4.05 3.76 3.62 4.52 4.69 4.80 4.69 4.21 3.91 3.64 3.53 4.64 4.79 4.97 4.93 4.53 4.23 3.94 3.75 4.49 4.86 4.99 4.68 4.30 4.09 3.82 3.66 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 • 12/31/2022 ▪ 1/31/2023 • 2/28/2023 • 3/31/2023 Note 1 Note 2 Prepared by Jonathan Rodriguez Center Footer 36 Pledged Collateral Reconciliation Report March 31, 2023 Bank Account Ending Account Name Amount Wells Fargo 3395 Credit Card Account Wells Fargo 2841 Sweep Account 49,541.00 * Wells Fargo 5455 False Alarm Reduction Program 289,199.15 Wells Fargo 7843 Alvin ISD 11,436,540.70 Wells Fargo 1790 EMS Payments Wells Fargo 9871 Health Claims 381,142.91 Wells Fargo 4094 Escrow W&S Revenue Bonds, Series 2016B - * Wells Fargo 4102 Escrow W&S Revenue Bonds, Series 2016C - * Wells Fargo 5883 Texas Permanent W&S System Revenue 2017B * Wells Fargo 5875 Texas Permanent W&S System Revenue 2017A - * Wells Fargo 6624 Escrow W&S Revenue Bonds, Series 2018A * Wells Fargo 2847 Escrow W&S Revenue Bonds, Series 2019A - * Wells Fargo 3025 Massey Oaks Easement Cost Escrow 2,771.11 Wells Fargo 1376 Workers Compensation Claims 40,541.35 Total of Bank Balances $ 12,199,736.22 Pledged Collateral for City FDIC Insurance 15,469,778.66 500,000.00 $ 15,969,778.66 Over (Under) Collateralized $ 3,770,042.44 Total % Collateralized 130.9% Bank Account Ending Account Name Amount Wells Fargo 4258 Development Authority 911,999.23 Total of Bank Balances Pledged Collateral for DAP FDIC Insurance $ 911,999.23 729,519.82 250,000.00 $ 979,519.82 Over (Under) Collateralized $ 67,520.59 Total % Collateralized 107.4% Total % Collateralized 129.3% Status Collateralized * Accounts are sweeping to a higher yielding money market fund which does not require collateral.