Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
R2022-174 2022-08-08
DocuSign Envelope ID: FEA01432-5010-4036-9BD6-F0D8CB197300 RESOLUTION NO. R2022-174 A Resolution of the City Council of the City of Pearland, Texas, accepting the City's Investment Report for the quarter ending June 2022. 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 2022. PASSED, APPROVED and ADOPTED this the 8th day of August, A.D., 2022. ATTEST: rDocuSigned by: Frs Q tar CC22JJ1 F415 FRANCS AGUILAR, TRMC, MMC CITY SECRETARY APPROVED AS TO FORM: DocuSigned by: DD F4GOKER CITY ATTORNEY DocuSigned by: MAYOR City of Pearland Quarterly Investment Report March 31, 2022 to June 30, 2022 This report is prepared for the City of Pearland in accordance with Chapter 2256 of the Public Funds Investm states that "Not less than quarterly, the investment officer shall prepare and submit to the governing body of transactions for all funds covered by this chapter for the preceding reporting period." This report is signed by disclosures required in the PFIA. e M nt Act (PFIA). Section2256.023 (a) of the PFIA the entity a written report of the investment the Investment Officer and includes the onth Market Value Book Value Unrealized Gain/Loss YTM @ Cost Treasury 1 Year 4/30/2022 5/31/2022 6/30/2022 328,521,173.90 309,175,279.97 298,340,126.74 Total/ Average 312,012,193.54 328,564,738.30 309,205,113.20 298,423,511.41 -43,564.40 -29,833.23 -83,384.67 Interest Earned Days To Maturity 0.28 1.88 73,499.71 0.55 2.06 119,691.33 0.90 2.65 187,156.76 312,064,454.30 -52,260.77 0.57 8 14 16 2.20 380,347.80 13 Shamaira Jagrup(jre inancial Off- r 4` sury Manager f\`L(/. Date 11 9/21 Date Li Kristen Woolley, Deputy Director of " an ce 07/18/2022 Date 1 City of Pearland Distribution by Security Type - Book Value Report Group: Pearland Begin Date: 3/31/2022, End Date: 6/30/2022 Security Type Allocation Security Type Book Value 3/31/2022 % of Portfolio 3/31/2022 Book Value 6/30/2022 % of Portfolio 6/30/2022 Cash FFCB Bond FHLB Bond Local Government Investment Pool Certificate Of Deposit 165,495,886.76 2,000,000.00 1,000,000.00 167,136,876.41 0.00 49.31 0.60 0.30 49.80 0.00 146,480,047.58 3,000,000.00 3,249,974.00 144,952,489.83 741,000.00 49.08 1.01 1.09 48.57 0.25 Total / Average 335,632,763.17 Portfolio Holdings as of 3/31/2022 • 49.3 1 %-Cash 0,6%-FFCB Bond • 0,3%-FHLB Bond • 49.8%-Local Governme,., • 0%-Certificate OfDe,,, 100.00 298,423,511.41 100.00 Portfolio Holdings as of 6/30/2022 • 49.08%-Cash 1,01%-FFCB Bond • 1,09%-FHLB Bond • 48.57%-Local Governor,., • 0,25%-Certificate Of... Prepared by Shamaira Jagrup 2 City of Pearland Distribution by Maturity Range - Book Value Report Group: Pearland Begin Date: 3/31/2022, End Date: 6/30/2022 Maturity Range Allocation Book Value % of Portfolio Book Value % of Portfolio Maturity Range 3/31/2022 3/31/2022 6/30/2022 6/30/2022 0-1 Month 332,632,763.17 99.11 291,432,537.41 97.66 9-12 Months 0.00 0.00 999,974.00 0.34 1-2 Years 1,000,000.00 0.30 3,991,000.00 1.34 2-3 Years 2,000,000.00 0.60 2,000,000.00 0.67 Total / Average 335,632,763.17 100.00 298,423,511.41 100.00 Portfolio Holdings 350,000 300,000 izi 250,000 0 200,000 7 O H 150,000 C • 3/31/2022 • 6/30/2022 100,000 50,000 00 1 I 0-1 M 9-12 M 1-2 Y 2-3 Y Prepared by Shamaira Jagrup 3 City of Pearland Total Rate of Return - Book Value by Month Report Group: Pearland Begin Date: 7/31/2021, End Date: 6/30/2022 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/2021 369,122,644.53 8/31/2021 356,916,958.27 9/30/2021 384, 593,117.40 10/31/2021 357,085,589.39 11/30/2021 359,439,755.90 12/31/2021 353,393,841.37 1/31/2022 357,966,092.32 2/28/2022 387,162,706.65 3/31/2022 346,160,440.89 4/30/2022 335,635,056.23 5/31/2022 328,571,486.08 6/30/2022 309,220,363.92 15, 364.51 14,137.64 9,439.59 5,934.13 5,786.70 8,193.20 11,272.10 17, 890.76 44, 300.10 73,499.71 119,691.33 187,156.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 15,364.51 14,137.64 9,439.59 5,934.13 5,786.70 8,193.20 11,272.10 17,890.76 44,300.10 73,499.71 119,691.33 187,156.76 362,390,986.93 372,013,319.34 368,257,170.01 358,373,329.73 356,205,335.41 355,896,711.75 373,970,957.41 366,652,628.39 340,105, 624.80 331,826,325.91 318,028,875.38 303,261,286.34 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.01 0.02 0.04 0.06 0.05 0.05 0.03 0.02 0.02 0.03 0.04 0.06 0.16 0.27 0.45 0.74 0.08 0.07 0.08 0.11 0.18 0.30 0.55 1.00 1.34 1.88 2.06 2.65 Total/Average 369,122,644.53 512,666.53 0.00 512,666.53 350,495,884.04 0.15 0.15 0.86 Annualized TRR-BV 3,00 2,50 2.00 1.50 1.00 0.50 0.00 07/2021 08/2021 09/2021 10/2021 11/2021 12/2021 01/2022 02/2022 03/2022 04/2022 05/2022 06/2022 • Portfolio • Treasury 1 Year Prepared by Shamaira Jagrup 4 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 6/30/2022 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 A Wells Fargo Cash WF3025 36,367.50 8/12/2020 0.00 36,367.50 36,367.50 100.00 0.00 36,367.50 0.01% 0.00 None None 1 0 Wells Fargo Cash WF9871 7/21/2010 775,097.85 100.00 775,097.85 0.26% None 775,097.85 0.23 775,097.85 0.23 0.00 None 1 0 Wells Fargo Cash WF1376 Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP 46,111.91 1,953,772.12 910,631.27 10/15/2020 46,111.91 100.00 46,111.91 0.02% None 0.23 46,111.91 0.23 0.00 None 1 0 5/31/2006 1,953,772.12 100.00 1,953,772.12 0.65% None 1.20 1,953,772.12 1.20 0.00 None 1 0 5/31/2006 910,631.27 100.00 1.20 910,631.27 1.20 910,631.27 0.31% None 1 0.00 None 0 Wells Fargo Sweep Cash WFSWEEP 5/31/2006 -7,733.32 100.00 -7,733.32 0% None -7,733.32 1.20-7,733.32 1.20 0.00 None 1 0 Wells Fargo Sweep Cash 5/31/2006 3,115,776.18 100.00 3,115,776.18 1.04% None 1 WFSWEEP 3,115,776.18 1.20 3,115,776.18 1.20 0.00 None 0 Wells Fargo Sweep Cash WFSWEEP 5/31/2006 932,238.96 100.00 932,238.96 0.31% None 932,238.96 1.20 932,238.96 1.20 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP 5/31/2006 194,769.11 100.00 194,769.11 0.07% None 1 194,769.11 1.20 194,769.11 1.20 0.00 None 0 5/31/2006 1,108,893.58 100.00 1,108,893.58 0.37% None 1 1,108,893.58 1.20 1,108,893.58 1.20 0.00 None 0 Wells Fargo Sweep Cash WFSWEEP 5/31/2006 204,888.67 100.00 204,888.67 0.07% None 204,888.67 1.20 204,888.67 1.20 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 5/31/2006 181,555.72 1.20 181,555.72 100.00 181,555.72 1.20 181,555.72 0.06% None 1 0.00 None 0 Prepared by Shamaira Jagrup 5 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 6/30/2022 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,941,677.05 5/31/2006 1.20 1,941,677.05 1,941,677.05 100.00 1.20 1,941,677.05 0 65% 0.00 Wells Fargo Sweep Cash WFSWEEP 5/31/2006 59,869.38 100.00 59,869.38 59,869.38 1.20 59,869.38 1.20 None None 1 0 0.02% None 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 1,308,751.97 5/31/2006 1,308,751.97 100.00 1,308,751.97 0.44% None 1.20 1,308,751.97 1.20 0.00 None Wells Fargo Sweep Cash 1 0 5/31/2006 26,423.27 100.00 26,423.27 0.01% None WFSWEEP 26,423.27 1.20 26,423.27 1.20 0.00 None 1 0 Wells Fargo Sweep Cash 5/31/2006 64,071.27 100.00 64,071.27 0.02% None WFSWEEP 64,071.27 1.20 64,071.27 1.20 0.00 None 1 0 Wells Fargo Sweep Cash 5/31/2006 -266,766.97 100.00 -266,766.97 -0.09% None WFSWEEP -266,766.97 1.20-266,766.97 1.20 0.00 None 1 0 Wells Fargo Sweep Cash 5/31/2006 1,189,915.69 100.00 1,189,915.69 0.4% None 1 WFSWEEP 1,189,915.69 1.20 1,189,915.69 1.20 0.00 None 0 Wells Fargo Sweep Cash WFSWEEP 10,036,011.83 5/31/2006 10,036,011.83 100.00 10,036,011.83 3.36% None 1.20 10,036,011.83 1.20 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 5/31/2006 120,580.12 1.20 120,580.12 100.00 120,580.12 0.04% None 120,580.12 1.20 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 5/31/2006 330,048.98 100.00 330,048.98 0.11% None 330,048.98 1.20 330,048.98 1.20 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 5/31/2006 534,499.00 100.00 534,499.00 0.18% None 534,499.00 1.20 534,499.00 1.20 0.00 None 1 0 Wells Fargo Sweep Cash 6/30/2006 36,627.19 100.00 36,627.19 0.01% None 1 WFSWEEP 36,627.19 1.20 36,627.19 1.20 0.00 None 0 Prepared by Shamaira Jagrup 6 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 6/30/2022 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 1,258,073.86 10/31/2006 1.20 1,258,073.86 1,258,073.86 100.00 1.20 1,258,073.86 0.42% 0.00 None None 1 0 Wells Fargo Sweep Cash WFSWEEP 12/1/2006 854,206.95 100.00 854,206.95 854,206.95 1.20 854,206.95 1.20 0.29% None 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 9/1/2007 63,141.00 100.00 63,141.00 0.02% None 63,141.00 1.20 63,141.00 1.20 0.00 None 1 0 Wells Fargo Sweep Cash 12/31/2007 2,057,373.67 100.00 2,057,373.67 0.69% None WFSWEEP 2,057,373.67 1.20 2,057,373.67 1.20 0.00 None 1 0 Wells Fargo Sweep Cash 10/30/2008 2,757,825.07 100.00 2,757,825.07 0.92% None WFSWEEP 2,757,825.07 1.20 2,757,825.07 1.20 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 9/15/2009 3,257.30 100.00 3,257.30 0% None 3,257.30 1.20 3,257.30 1.20 0.00 None 1 0 Wells Fargo Sweep Cash 9/15/2010 2,404,304.52 100.00 2,404,304.52 0.81% None 1 WFSWEEP 2,404,304.52 1.20 2,404,304.52 1.20 0.00 None 0 Wells Fargo Sweep Cash 4/15/2012 WFSWEEP 29,660.37 1.20 29,660.37 100.00 29,660.37 0.01% None 29,660.37 1.20 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 2/1/2013 25,665.43 100.00 25,665.43 0.01% None 25,665.43 1.20 25,665.43 1.20 0.00 None 1 0 Wells Fargo Sweep Cash 11/15/2015 -503,592.32 100.00 -503,592.32 -0.17% None WFSWEEP -503,592.32 1.20-503,592.32 1.20 0.00 None 1 0 Wells Fargo Sweep Cash 10/15/2018 2,765,933.54 100.00 2,765,933.54 0.93% None WFSWEEP 2,765,933.54 1.20 2,765,933.54 1.20 0.00 None 1 0 Wells Fargo Sweep Cash 12/15/2018 -95,113.36 100.00 -95,113.36 -0.03% None 1 WFSWEEP -95,113.36 1.20-95,113.36 1.20 0.00 None 0 Prepared by Shamaira Jagrup 7 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 6/30/2022 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 730,299.18 10/15/2019 1.20 730,299.18 730,299.18 100.00 1.20 730,299.18 0.24% 0.00 None None 1 0 Wells Fargo Sweep Cash WFSWEEP 1,214,252.26 10/15/2019 1,214,252.26 1.20 1,214,252.26 100.00 1,214,252.26 1.20 Wells Fargo Sweep Cash WFSWEEP 0.41% None 0.00 None 1 0 10/15/2019 -7,756.41 100.00 -7,756.41 0% None -7,756.41 1.20 Wells Fargo Sweep Cash -7,756.41 1.20 0.00 None 1 0 10/15/2019 -14,953,710.41 100.00 -14,953,710.41 WFSWEEP -14,953,710.41 1.20-14,953,710.41 1.20 -5.01% 0.00 None None 1 0 Wells Fargo Sweep Cash 10/15/2019 1,389,345.15 100.00 1,389,345.15 0.47% None WFSWEEP 1,389,345.15 1.20 1,389,345.15 1.20 0.00 None 1 0 Wells Fargo Sweep Cash 10/15/2019 1,595,985.49 100.00 1,595,985.49 0.53% None WFSWEEP 1,595,985.49 1.20 1,595,985.49 1.20 0.00 None 1 0 Wells Fargo Sweep Cash 10/15/2019 1,242,982.61 100.00 1,242,982.61 0.42% None 1 WFSWEEP 1,242,982.61 1.20 1,242,982.61 1.20 0.00 None 0 Wells Fargo Sweep Cash WFSWEEP -11,864,592.92 10/15/2019 -11,864,592.92 100.00 -11,864,592.92 -3.98% None 1.20-11,864,592.92 1.20 0.00 None 1 0 Wells Fargo Sweep Cash 12/15/2019 1,660,856.12 100.00 1,660,856.12 0.56% None WFSWEEP 1,660,856.12 1.20 1,660,856.12 1.20 0.00 None 1 0 Wells Fargo Sweep Cash 1/15/2020 1,494,573.57 100.00 1,494,573.57 0.5% None WFSWEEP 1,494,573.57 1.20 1,494,573.57 1.20 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 1/15/2020 1,558.34 1.20 1,558.34 100.00 1,558.34 0% None 1,558.34 1.20 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP Prepared by Shamaira Jagrup 1,913,114.56 1/15/2020 1,913,114.56 100.00 1,913,114.56 0.64% None 1 1.20 1,913,114.56 1.20 0.00 None 0 8 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 6/30/2022 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 -12,175,884.07 2/15/2020 1.20 -12,175,884.07 -12,175,884.07 100.00 1.20 -12,175,884.07 -4.08% 0.00 Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash -3,240,161.51 5/15/2020 1.20 -3,240,161.51 -3,240,161.51 100.00 -3,240,161.51 1.20 8/15/2020 633,262.38 100.00 633,262.38 633,262.38 1.20 633,262.38 1.20 9/15/2020 -457,460.61 100.00 -457,460.61 WFSWEEP -457,460.61 1.20-457,460.61 1.20 None None 1 0 -1.09% None 0.00 None 1 0 0.21% None 0.00 None 1 0 -0.15% 0.00 None None 1 0 Wells Fargo Sweep Cash 10/1/2020 -29,501,543.74 100.00 -29,501,543.74 -9.89% None WFSWEEP -29,501,543.74 1.20-29,501,543.74 1.20 0.00 None 1 0 Wells Fargo Sweep Cash 10/1/2020 -1,803,415.91 100.00 -1,803,415.91 -0.6% None WFSWEEP -1,803,415.91 1.20-1,803,415.91 1.20 0.00 None 1 0 Wells Fargo Sweep Cash 10/1/2020 -3,801,470.80 100.00 -3,801,470.80 -1.27% None 1 WFSWEEP -3,801,470.80 1.20-3,801,470.80 1.20 0.00 None 0 Wells Fargo Sweep Cash WFSWEEP -183,309.51 10/1/2020 -183,309.51 100.00 -183,309.51 -0.06% None 1.20-183,309.51 1.20 0.00 None 1 0 Wells Fargo Sweep Cash 10/1/2020 1,271,190.51 100.00 1,271,190.51 0.43% None WFSWEEP 1,271,190.51 1.20 1,271,190.51 1.20 0.00 None 1 0 Wells Fargo Sweep Cash 10/15/2020 22,266,552.27 100.00 22,266,552.27 7.46% None WFSWEEP 22,266,552.27 1.20 22,266,552.27 1.20 0.00 None 1 0 Wells Fargo Sweep Cash 11/15/2020 -251,759.23 100.00 -251,759.23 -0.08% None WFSWEEP -251,759.23 1.20-251,759.23 1.20 0.00 None 1 0 Wells Fargo Sweep Cash 11/15/2020 -56,839.52 100.00 -56,839.52 -0.02% None 1 WFSWEEP -56,839.52 1.20-56,839.52 1.20 0.00 None 0 Prepared by Shamaira Jagrup 9 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 6/30/2022 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 7,073,287.54 5/15/2021 1.20 7,073,287.54 7,073,287.54 100.00 1.20 7,073,287.54 2.37% 0.00 None None 1 0 Wells Fargo Sweep Cash WFSWEEP 10/15/2021 -14,988.78 100.00 -14,988.78 -14,988.78 1.20-14,988.78 1.20 -0.01% None 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 10/15/2021 -13,898.25 100.00 -13,898.25 0% None -13,898.25 1.20-13,898.25 1.20 Wells Fargo Sweep Cash WFSWEEP 0.00 None 1 0 10/15/2021 -7,773.75 100.00 -7,773.75 0% None -7,773.75 1.20-7,773.75 1.20 0.00 None Wells Fargo Sweep Cash WFSWEEP 1 0 10/15/2021 -29,598.75 100.00 -29,598.75 -0.01% None -29,598.75 1.20-29,598.75 1.20 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 12/15/2021 50.87 100.00 50.87 0% None 50.87 1.20 50.87 1.20 0.00 None Wells Fargo Sweep Cash WFSWEEP 1 0 6/1/2022 -15,324.24 100.00 -15,324.24 -0.01% None 1 -15,324.24 1.20-15,324.24 1.20 0.00 None 0 Wells Fargo TWDB Cash 9/15/2017 WF5875 923,628.32 1.20 923,628.32 100.00 923,628.32 0.31% None 923,628.32 1.20 0.00 None 1 0 Wells Fargo TWDB Cash WF4094 11/1/2016 81,903.75 1.20 81,903.75 100.00 81,903.75 0.03% None 81,903.75 1.20 0.00 None 1 0 Wells Fargo TWDB Cash WF6624 Wells Fargo TWDB Cash WF6100 Wells Fargo TWDB Cash WF3100 Prepared by Shamaira Jagrup 5/15/2018 966,251.02 1.20 966,251.02 100.00 966,251.02 0.32% None 966,251.02 1.20 0.00 None 1 0 6/16/2020 60,840,400.73 100.00 60,840,400.73 20.39% None 1 60,840,400 73 0.54 60,840,400.73 0.54 0.00 None 0 4/1/2021 3,760,562.65 100.00 3,760,562.65 1.26% None 1 3,760,562.65 0.54 3,760,562.65 0.54 0.00 None 0 10 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 6/30/2022 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 TWDB Cash WF3100 69,966,487.10 4/1/2021 69,966,487.10 0.54 69,966,487.10 100.00 0.54 69,966,487.10 23.45% 0.00 Wells Fargo TWDB Cash WF2847 Wells Fargo TWDB Cash WF4102 Wells Fargo TWDB Cash 6,060,115.79 8/6/2019 6,060,115.79 1.20 6,060,115.79 100.00 6,060,115.79 1.20 None None 1 0 2.03% None 0.00 None 1 0 11/1/2016 906,099.07 100.00 906,099.07 0.3% None 906,099.07 1.20 906,099.07 1.20 0.00 None 1 0 3/15/2017 2,411,962.35 100.00 2,411,962.35 0.81% None WF5883 2,411,962.35 1.20 2,411,962.35 1.20 0.00 None Sub Total Cash 146,480,047.58 0.58 146,480,047.58 146,480,047.58 0.58 1 0 146,480,047.58 49.1% 1 0.00 0 Certificate Of Deposit AMERICAN EXPR NATL BK 2.85 5/13/2024 5/11/2022 248,000.00 99.29 246,232.45 0.08% None 683 02589ACN0 248,000.00 2.85 248,000.00 3.16 968.22-1,767.55 None 1.83 BARCLAYS BANK DELAWARE 2.85 5/18/2022 248,000.00 99.27 246,177.79 0.08% None 690 5/20/2024 06740KQH3 248,000.00 2.85 248,000.00 3.17 832.67 -1,822.21 None 1.85 DISCOVER BANK 2.8 5/20/2024 5/18/2022 245,000.00 99.17 242,976.30 0.08% None 690 254673D78 245,000.00 2.80 245,000.00 3.16 808.16 -2,023.70 None 1.85 Sub Total Certificate Of Deposit 741,000.00 741,000.00 735,386.54 2.83 741,000.00 0.24% 688 3.17 2,609.05 -5,613.46 1.84 FFCB Bond FFCB 1.94 9/3/2024-22 3133ENQC7 FFCB 3.25 6/17/2024 3133ENYX2 2,000,000.00 1,000,000.00 Sub Total FFCB Bond 3/11/2022 2,000,000.00 97.57 1,951,319.66 0.67% Moodys-Aaa 1.94 2,000,000.00 3.11 11,747.78 -48,680.34 S&P -AA+ 2.13 6/17/2022 1,000,000.00 100.46 1,004,623.58 3.25 1,000,000.00 3.01 1,173.61 3,000,000.00 2.38 0.34% 4,623.58 None None 718 1.92 3,000,000.00 3,000,000.00 2,955,943.24 1.01% 240 3.07 12,921.39 -44,056.76 2.06 FHLB Bond 11 Prepared by Shamaira Jagrup City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 6/30/2022 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 FHLB 1.65 12/28/2023-22 3130ARA27 1,000,000.00 3/28/2022 1.65 1,000,000.00 1,000,000.00 98.12 2.95 981,190.03 4,216.67 FHLB 2.125 5/12/2023 3130AS3T4 FHLB 2.5 2/13/2024 3130AFW94 Sub Total FHLB Bond 5/12/2022 999,970.00 99.34 993,424.56 0.34% Moodys-Aaa -18,809.97 S&P -AA+ 28 1.48 0.34% None 1,000,000.00 2.13 999,974.00 2.90 2,833.33 -6,549.44 None 316 0.86 5/11/2022 1,250,000.00 99.33 1,241,644.96 0.42% Moodys-Aaa 1,250,000.00 2.50 1,250,000.00 2.93 4,253.47 -8,355.04 S&P -AA+ 593 1.59 3,249,970.00 3,216,259.55 1.1% 3,250,000.00 2.12 3,249,974.00 2.92 11,303.47 -33,714.45 334 1.33 Local Government Investment Pool Texas Class LGIP TX-01-0615-0001 Texas Class LGIP TX-01-0615-0001 Texas Class LGIP TX-01-0615-0001 Texas Class LGIP TX-01-0615-0001 1,457,498.46 12/20/2016 1,457,498.46 100.00 1,457,498.46 0.49% None 1.16 1,457,498.46 1.16 0.00 None 1 0 12/20/2016 61.54 100.00 61.54 0% None 61.54 1.16 61.54 1.16 0.00 None 1 0 12/20/2016 12,048,111.93 100.00 12,048,111.93 4.04% None 1 12,048,111.93 1.16 12,048,111.93 1.16 0.00 None 0 12/20/2016 3,515,151.82 100.00 3,515,151.82 1.18% None 1 3,515,151.82 1.16 3,515,151.82 1.16 0.00 None 0 Texas Class LGIP TX-01-0615-0001 7,676,118.41 1/15/2017 7,676,118.41 100.00 7,676,118.41 2.57% None 1 1.16 7,676,118.41 1.16 0.00 None 0 Texas Class LGIP TX-01-0615-0001 2,573,376.66 1/15/2017 2,573,376.66 100.00 2,573,376.66 0.86% None 1.16 2,573,376.66 1.16 0.00 None 1 0 Texas Class LGIP TX-01-0615-0001 5,522,108.37 1/15/2017 5,522,108.37 100.00 5,522,108.37 1.85% None 1 1.16 5,522,108.37 1.16 0.00 None 0 Texas Class LGIP TX-01-0615-0001 Prepared by Shamaira Jagrup 5,159,124.84 5/15/2017 5,159,124.84 100.00 5,159,124.84 1.73% None 1 1.16 5,159,124.84 1.16 0.00 None 0 12 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 6/30/2022 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 Texas Class LGIP TX-01-0615-0001 387,411.04 Texas Class LGIP TX-01-0615-0001 5/15/2017 1.16 387,411.04 387,411.04 100.00 1.16 387,411.04 0.13% 0.00 None None 1 0 31,225,530.83 5/15/2017 31,225,530.83 1.16 31,225,530.83 100.00 31,225,530.83 1.16 10.46% None 0.00 None 1 0 Texas Class LGIP TX-01-0615-0001 7,031,055.97 6/15/2020 7,031,055.97 100.00 7,031,055.97 2.36% None 1.16 7,031,055.97 1.16 0.00 None Texas Class LGIP TX-01-0615-0001 15,040,683.56 1 0 12/15/2020 15,040,683.56 100.00 15,040,683.56 5.04% None 1.16 15,040,683.56 1.16 0.00 None Texas Class LGIP TX-01-0615-0001 2,506,076.89 1 0 1/15/2022 2,506,076.89 100.00 2,506,076.89 0.84% None 1.16 2,506,076.89 1.16 0.00 None 1 0 Texas Class LGIP TX-01-0615-0001 3,007,292.27 1/15/2022 3,007,292.27 100.00 3,007,292.27 1.01% None 1.16 3,007,292.27 1.16 0.00 None 1 0 Texas Class LGIP 1/15/2022 2,059.86 100.00 2,059.86 0% None 1 TX-01-0615-0001 2,059.86 1.16 2,059.86 1.16 0.00 None 0 Texas Class LGIP TX-01-0615-0001 10,023,910.18 1/15/2022 10,023,910.18 100.00 10,023,910.18 3.36% None 1.16 10,023,910.18 1.16 0.00 None 1 0 Texas Class LGIP TX-01-0615-0008 1,205,481.60 8/11/2020 1,205,481.60 100.00 1,205,481.60 0.4% None 1.16 1,205,481.60 1.16 0.00 None 1 0 Texas Class LGIP TX-01-0615-0013 Texas Class LGIP TX-01-0615-0014 5,489,244.15 8/15/2021 5,489,244.15 100.00 5,489,244.15 1.84% None 1.16 5,489,244.15 1.16 0.00 None 1 0 5,353,252.74 8/15/2021 5,353,252.74 100.00 5,353,252.74 1.79% None 1.16 5,353,252.74 1.16 0.00 None 1 0 Texas Class LGIP TX-01-0615-0009 2,765,424.83 8/11/2020 2,765,424.83 100.00 2,765,424.83 0.93% None 1 1.16 2,765,424.83 1.16 0.00 None 0 Prepared by Shamaira Jagrup 13 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 6/30/2022 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-0007 5,820,304.52 9/19/2019 1.16 5,820,304.52 5,820,304.52 100.00 1.16 5,820,304.52 1.95% 0.00 None None 1 0 Texas Class LGIP TX-01-0615-0007 9/19/2019 3,309.51 100.00 3,309.51 3,309.51 1.16 3,309.51 1.16 0% None 0.00 None 1 0 Texas Class LGIP TX-01-0615-0007 Texas Class LGIP TX-01-0615-0011 568,966.50 1,892,241.56 9/19/2019 568,966.50 100.00 568,966.50 0.19% None 1.16 568,966.50 1.16 0.00 None 1 0 8/11/2020 1,892,241.56 100.00 1,892,241.56 0.63% None 1.16 1,892,241.56 1.16 0.00 None 1 0 Texas Class LGIP TX-01-0615-0005 2,654,900.03 Texas Class LGIP TX-01-0615-0004 9/15/2018 2,654,900.03 100.00 2,654,900.03 0.89% None 1.16 2,654,900.03 1.16 0.00 None 1 0 9/15/2018 7,117.89 1.16 Texas Class LGIP TX-01-0615-0015 1,024,120.49 7,117.89 100.00 7,117.89 0% None 7,117.89 1.16 0.00 None 1 0 8/15/2021 1,024,120.49 100.00 1,024,120.49 0.34% None 1 1.16 1,024,120.49 1.16 0.00 None 0 Texas Class LGIP 9/15/2018 237,639.70 100.00 237,639.70 0.08% None TX-01-0615-0006 237,639.70 1.16 237,639.70 1.16 0.00 None 1 0 Texas Class LGIP TX-01-0615-0010 TexSTAR LGIP 02000-20190 1,456,934.76 8/11/2020 1,456,934.76 100.00 1,456,934.76 0.49% None 1.16 1,456,934.76 1.16 0.00 None 1 0 1,415,865.97 9/19/2019 1,415,865.97 100.00 1,415,865.97 0.47% None 0.99 1,415,865.97 0.99 0.00 None 1 0 TexSTAR LGIP 02000-20191 9/27/2019 492,471.90 100.00 492,471.90 0.17% None 492,471.90 0.99 492,471.90 0.99 0.00 None 1 0 TexSTAR LGIP 02000-20191 Prepared by Shamaira Jagrup 9/27/2019 511,029.03 100.00 511,029.03 0.17% None 1 511,029.03 0.99 511,029.03 0.99 0.00 None 0 14 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 6/30/2022 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 TexSTAR LGIP 02000-11110 TexSTAR LGIP 02000-11110 TexSTAR LGIP 02000-20192 Sub Total Local Government Investment Pool 1, 668, 816.54 1,178,153.04 4,031,642.44 144,952,489.83 8/26/2016 0.99 1, 668, 816.54 1, 668, 816.54 100.00 0.99 1,668,816.54 8/26/2016 1,178,153.04 100.00 1,178,153.04 0.99 1,178,153.04 0.99 9/27/2019 4,031,642.44 100.00 4,031,642.44 0.99 4,031,642.44 0.99 144,952,489.83 144,952,489.83 1.15 144,952,489.83 1.15 0.56% 0.00 0.39% 0.00 1.35% 0.00 48.56% S&P -AAA None S&P -AAA None None None 1 0 1 0 1 0 0.00 0 TOTAL PORTFOLIO 298,423,537.41 0.90 298,423,507.41 298,423,511.41 0.91 298,340,126.74 26,833.91 100.00% 9 -83,384.67 0.04 Prepared by Shamaira Jagrup 15 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 6/30/2022 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 3.17 832.67 -1,822.21 None 1.85 248,000 00 5/11/2022 248,000.00 2.85 248,000.00 99.29 3.16 246,232.45 968.22 0.08% -1,767.55 None None 683 1.83 DISCOVER BANK 2.8 5/20/2024 254673D78 5/18/2022 248,000.00 99.27 246,177.79 0.08% None 690 5/18/2022 245,000.00 99.17 242,976.30 0.08% None 690 245,000.00 2.80 245,000.00 3.16 808.16 -2,023.70 None 1.85 FFCB 1.94 9/3/2024-22 3133ENQC7 2,000,000.00 3/11/2022 2,000,000.00 97.57 1,951,319.66 0.67% Moodys-Aaa 1.94 2,000,000.00 3.11 11,747.78 -48,680.34 S&P -AA+ 2.13 FFCB 3.25 6/17/2024 3133ENYX2 1,000,000.00 6/17/2022 1,000,000.00 100.46 1,004,623.58 3.25 1,000,000.00 3.01 1,173.61 0.34% None 718 4,623.58 None 1.92 FHLB 1.65 12/28/2023-22 3/28/2022 1,000,000.00 98.12 981,190.03 0.34% Moodys-Aaa 3130ARA27 1,000,000.00 1.65 1,000,000.00 2.95 4,216.67 -18,809.97 S&P -AA+ 28 1.48 FHLB 2.125 5/12/2023 5/12/2022 999,970.00 99.34 993,424.56 0.34% None 3130AS3T4 1,000,000.00 2.13 999,974.00 2.90 2,833.33 -6,549.44 None 316 0.86 FHLB 2.5 2/13/2024 3130AFW94 1,250,000.00 5/11/2022 1,250,000.00 99.33 1,241,644.96 0.42% Moodys-Aaa 593 2.50 1,250,000.00 2.93 4,253.47 -8,355.04 S&P -AA+ 1.59 Texas Class LGIP TX-01-0615-0001 31,225,530.83 5/15/2017 31,225,530.83 100.00 31,225,530.83 10.46% None 1.16 31,225,530.83 1.16 0.00 None 0 Wells Fargo Sweep Cash WFSWEEP Sub Total 100: General Fund 5/31/2006 10,036,011.83 100.00 10,036,011.83 3.36% None 1 10,036,011.83 1.20 10,036,011.83 1.20 0.00 None 0 48, 252, 512.66 48,169,131.99 16.17% 49 48,252,542.66 1.33 48,252,516.66 1.44 26,833.91 -83,384.67 0.25 200: Debt Services Texas Class LGIP TX-01-0615-0001 Prepared by Shamaira Jagrup 7,676,118.41 1/15/2017 7,676,118.41 1.16 7,676,118.41 100.00 7,676,118.41 2.57% None 1 1.16 0.00 None 0 16 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 6/30/2022 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 200: Debt Services 1, 953, 772.12 9,629,890.53 5/31/2006 1.20 1.17 1, 953, 772.12 1, 953, 772.12 9,629,890.53 9,629,890.53 100.00 1.20 1.17 1, 953, 772.12 9,629,890.53 0.65% 0.00 3.22% 0.00 None None 1 0 1 0 305: Hotel/Motel Occupancy Texas Class LGIP TX-01-0615-0001 Wells Fargo Sweep Cash WFSWEEP Sub Total 305: Hotel/Motel Occupancy 5/15/2017 5,159,124.84 100.00 5,159,124.84 5,159,124.84 1.16 5,159,124.84 1.16 5/31/2006 910,631.27 100.00 910,631.27 910,631.27 1.20 910,631.27 1.20 6,069,756.11 6,069,756.11 6,069,756.11 1.16 6,069,756.11 1.16 1.73% None 1 0.00 None 0 0.31% None 1 0.00 None 0 2.04% 0.00 1 0 310: Municipal Court Security Wells Fargo Sweep Cash WFSWEEP Sub Total 310: Municipal Court Security 5/31/2006 59,869.38 1.20 59,869.38 1.20 59,869.38 100.00 59,869.38 0.02% None 59,869.38 1.20 0.00 None 59,869.38 59,869.38 59,869.38 1.20 1 0 0.02% 1 0.00 0 315: City Wide Donation Wells Fargo Sweep Cash WFSWEEP Sub Total 315: City Wide Donation 5/31/2006 204,888.67 1.20 204,888.67 1.20 204,888.67 100.00 204,888.67 0.07% None 204,888.67 1.20 0.00 None 204,888.67 204,888.67 204,888.67 1.20 1 0 0.07% 1 0.00 0 320: Court Technology Wells Fargo Sweep Cash WFSWEEP Sub Total 320: Court Technology 5/31/2006 -7,733.32 1.20 -7,733.32 1.20 -7,733.32 100.00 -7,733.32 0% None -7,733.32 1.20 0.00 None 1 0 -7,733.32 -7,733.32 0% 1 -7,733.32 1.20 0.00 0 325: Street Assessment Prepared by Shamaira Jagrup 17 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 6/30/2022 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 325: Street Assessment 50.87 12/15/2021 1.20 50.87 1.20 50.87 50.87 50.87 100.00 1.20 50.87 1.20 50.87 50.87 0% 0.00 0% 0.00 None None 1 0 1 0 330: Park Donations Wells Fargo Sweep Cash WFSWEEP Sub Total 330: Park Donations 5/31/2006 26,423.27 100.00 26,423.27 0.01% None 1 26,423.27 1.20 26,423.27 1.20 0.00 None 0 26,423.27 1.20 26,423.27 26,423.27 1.20 26,423.27 0.01% 0.00 1 0 331: Tree Trust Fund Wells Fargo Sweep Cash WFSWEEP Sub Total 331: Tree Trust Fund 1, 308, 751.97 5/31/2006 1,308,751.97 100.00 1,308,751.97 0.44% None 1.20 1,308,751.97 1.20 0.00 None 1, 308, 751.97 1.20 1,308,751.97 1, 308, 751.97 1.20 1,308,751.97 1 0 0.44% 1 0.00 0 332: Parks Financl Asstance Donations Wells Fargo Sweep Cash 10/15/2019 -7,756.41 100.00 -7,756.41 0% None WFSWEEP -7,756.41 1.20-7,756.41 1.20 0.00 None Sub Total 332: Parks Financl Asstance Donations -7,756.41 1.20 1 0 -7,756.41 -7,756.41 0% 1 -7,756.41 1.20 0.00 0 335: Police State Seizure Wells Fargo Sweep Cash 5/31/2006 181,555.72 100.00 181,555.72 0.06% None WFSWEEP 181,555.72 1.20 181,555.72 1.20 0.00 None Sub Total 335: Police State Seizure 181,555.72 1.20 1 0 181,555.72 181,555.72 0.06% 1 181,555.72 1.20 0.00 0 336: Federal Police Fund Wells Fargo Sweep Cash 5/31/2006 120,580.12 100.00 120,580.12 0.04% None WFSWEEP 120,580.12 1.20 120,580.12 1.20 0.00 None Prepared by Shamaira Jagrup 1 0 18 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 6/30/2022 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 336: Federal Police Fund 120,580.12 1.20 120,580.12 120,580.12 1.20 120,580.12 0.04% 0.00 1 0 337: Community Safety Fund Wells Fargo Sweep Cash WFSWEEP Sub Total 337: Community Safety Fund 6/1/2022 -15,324.24 100.00 -15,324.24 -0.01% None -15,324.24 1.20 -15,324.24 1.20 -15,324.24 1.20 -15,324.24 -15,324.24 1.20 0.00 None -15,324.24 -0.01% 0.00 1 0 0 340: Park & Rec Development Wells Fargo Sweep Cash 5/31/2006 1,108,893.58 100.00 1,108,893.58 0.37% None 1 WFSWEEP 1,108,893.58 1.20 1,108,893.58 1.20 0.00 None 0 Sub Total 340: Park & Rec Development 1,108, 893.58 1.20 1,108,893.58 1,108, 893.58 1.20 1,108,893.58 0.37% 1 0.00 0 345: Sidewalk Fund Wells Fargo Sweep Cash 5/31/2006 64,071.27 100.00 64,071.27 0.02% None WFSWEEP Sub Total 345: Sidewalk Fund 64,071.27 1.20 64,071.27 1.20 64,071.27 1.20 0.00 None 64,071.27 64,071.27 64,071.27 1.20 1 0 0.02% 1 0.00 0 350: Grant Fund Wells Fargo Sweep Cash 5/31/2006 -266,766.97 WFSWEEP -266,766.97 1.20-266,766.97 Sub Total 350: Grant Fund -266,766.97 1.20 -266,766.97 -266,766.97 100.00 -266,766.97 -0.09% None 1.20 1.20 -266,766.97 0.00 None 1 0 -0.09% 1 0.00 0 351: CDBG Fund Wells Fargo Sweep Cash 11/15/2015 -503,592.32 100.00 -503,592.32 -0.17% None WFSWEEP-503,592.32 1.20-503,592.32 1.20 0.00 None Sub Total 351: CDBG Fund -503,592.32 1.20 -503,592.32 -503,592.32 1.20 -503,592.32 1 0 0.00 0 352: CDBG - Disaster Recovery Fund Prepared by Shamaira Jagrup 19 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 6/30/2022 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 Sub Total 352: CDBG - Disaster Recovery Fund -251,759.23 11/15/2020 1.20 -251,759.23 -251,759.23 100.00 1.20 -251,759.23 -0.08% 0.00 None None 1 0 -251,759.23 1.20 -251,759.23 -251,759.23 1.20 -251,759.23 -0.08% 0.00 1 0 353: Disaster Recovery Fund IL Wells Fargo Sweep Cash WFSWEEP Sub Total 353: Disaster Recovery Fund 9/15/2020 -457,460.61 -457,460.61 1.20-457,460.61 100.00 -457,460.61 -0.15% None 1.20 0.00 None -457,460.61 -457,460.61 1.20-457,460.61 1.20 -457,460.61 -0.15% 0.00 0 1 0 354: Hazard Mitigation Fund Wells Fargo Sweep Cash WFSWEEP Sub Total 354: Hazard Mitigation Fund -56,839.52 -56,839.52 11/15/2020 -56,839.52 100.00 -56,839.52 -0.02% None 1.20-56,839.52 1.20 1.20 0.00 None 1 0 -56,839.52 -56,839.52 1.20 -56,839.52 -0.02% 0.00 1 0 355: Coronavirus Relief Fund Wells Fargo Sweep Cash WFSWEEP -3,240,161.51 5/15/2020 1.20 -3,240,161.51 -3,240,161.51 100.00 1.20 -3,240,161.51 Sub Total 355: Coronavirus Relief Fund -3,240,161.51 1.20 -3,240,161.51 -3,240,161.51 1.20 -3,240,161.51 -1.09% 0.00 None None -1.09% 0.00 1 0 1 0 356: ARPA Fund Wells Fargo Sweep Cash WFSWEEP Sub Total 356: ARPA Fund 5/15/2021 7,073,287.54 7,073,287.54 1.20 7,073,287.54 100.00 7,073,287.54 2.37% None 1.20 0.00 None 1 0 7,073,287.54 7,073,287.54 1.20 7,073,287.54 1.20 7,073,287.54 2.37% 1 0.00 0 360: Traffic Impact Improvement Wells Fargo Sweep Cash WFSWEEP Prepared by Shamaira Jagrup 5/31/2006 330,048.98 100.00 330,048.98 0.11% None 330,048.98 1.20 330,048.98 1.20 0.00 None 1 0 20 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 6/30/2022 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 360: Traffic Impact Improvement 330,048.98 1.20 330,048.98 330,048.98 1.20 330, 048.98 0.11% 0.00 1 0 365: Court Juvenile Mgmt Wells Fargo Sweep Cash WFSWEEP Sub Total 365: Court Juvenile Mgmt 9/15/2009 3,257.30 100.00 3,257.30 3,257.30 1.20 3,257.30 1.20 3,257.30 1.20 3,257.30 3,257.30 1.20 0% None 0.00 None 3,257.30 0% 0.00 0 0 366: Municipal Jury Fund Wells Fargo Sweep Cash WFSWEEP Sub Total 366: Municipal Jury Fund 1/15/2020 1,558.34 100.00 1,558.34 0% None 1 1,558.34 1.20 1,558.34 1.20 0.00 None 0 1,558.34 1.20 1,558.34 1,558.34 0% 1 1,558.34 1.20 0.00 0 370: Municipal Channel Texas Class LGIP 5/15/2017 TX-01-0615-0001 387,411.04 1.16 Wells Fargo Sweep Cash 4/15/2012 WFSWEEP 29,660.37 1.20 Sub Total 370: Municipal Channel 417, 071.41 1.16 387,411.04 387,411.04 29,660.37 29,660.37 100.00 387,411.04 1.16 100.00 29,660.37 1.20 417,071.41 417,071.41 417,071.41 1.16 0.13% 0.00 0.01% 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 194,769.11 100.00 194,769.11 0.07% None WFSWEEP 194,769.11 1.20 194,769.11 1.20 0.00 None Sub Total 380: Regional Detention 194,769.11 1.20 1 0 194,769.11 194,769.11 0.07% 1 194,769.11 1.20 0.00 0 500: Capital Projects Texas Class LGIP TX-01-0615-0001 Prepared by Shamaira Jagrup 2,573,376.66 1/15/2017 2,573,376.66 100.00 2,573,376.66 0.86% None 1.16 2,573,376.66 1.16 0.00 None 1 0 21 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 6/30/2022 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 Cash WF3025 Wells Fargo Sweep Cash WFSWEEP Sub Total 500: Capital Projects 36,367.50 8/12/2020 0.00 36,367.50 36,367.50 100.00 0.00 36,367.50 0.01% 0.00 None None 1 0 1,941,677.05 5/31/2006 1, 941, 677.05 1.20 1,941,677.05 100.00 1,941,677.05 1.20 0.65% 0.00 None None 1 0 4,551,421.21 1.17 4,551,421.21 4,551,421.21 1.17 4,551,421.21 1.52% 0.00 1 0 501: Certificates of Obligation Texas Class LGIP TX-01-0615-0001 3,515,151.82 12/20/2016 3,515,151.82 100.00 3,515,151.82 1.18% None 1 1.16 3,515,151.82 1.16 0.00 None 0 Texas Class LGIP 9/19/2019 568,966.50 100.00 568,966.50 0.19% None TX-01-0615-0007 568,966.50 1.16 568,966.50 1.16 0.00 None 1 0 Texas Class LGIP 9/15/2018 237,639.70 100.00 237,639.70 0.08% None TX-01-0615-0006 237,639.70 1.16 237,639.70 1.16 0.00 None 1 0 TexSTAR LGIP 9/27/2019 511,029.03 100.00 511,029.03 0.17% None 1 02000-20191 511,029.03 0.99 511,029.03 0.99 0.00 None 0 TexSTAR LGIP 8/26/2016 1,178,153.04 100.00 1,178,153.04 0.39% S&P -AAA 1 02000-11110 1,178,153.04 0.99 1,178,153.04 0.99 0.00 None 0 TexSTAR LGIP 02000-20192 Wells Fargo Sweep Cash WFSWEEP 4,031,642.44 9/27/2019 4,031,642.44 100.00 4,031,642.44 1.35% None 1 0.99 4,031,642.44 0.99 0.00 None 0 5/31/2006 534,499.00 100.00 534,499.00 0.18% None 534,499.00 1.20 534,499.00 1.20 0.00 None Sub Total 501: Certificates of Obligation 10,577,081.53 1.07 10,577,081.53 10,577,081.53 1.07 10,577,081.53 1 0 3.54% 1 0.00 0 503: Certificates of Obligation 2006 Wells Fargo Sweep Cash 6/30/2006 36,627.19 100.00 36,627.19 0.01% None WFSWEEP Prepared by Shamaira Jagrup 36,627.19 1.20 36,627.19 1.20 0.00 None 1 0 22 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 6/30/2022 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 503: Certificates of Obligation 2006 36,627.19 1.20 36,627.19 36,627.19 1.20 36,627.19 0.01 % 0.00 1 0 506: General Obligation Texas Class LGIP TX-01-0615-0001 Texas Class LGIP TX-01-0615-0005 12,048,111.93 12/20/2016 12,048,111.93 100.00 12,048,111.93 4.04% None 1.16 12,048,111.93 1.16 0.00 None 2,654,900.03 9/15/2018 2,654,900.03 100.00 2,654,900.03 0.89% None 1.16 2,654,900.03 1.16 TexSTAR LGIP 02000-20190 1,415,865.97 0 1 0.00 None 0 9/19/2019 1,415,865.97 100.00 1,415,865.97 0.47% None 0.99 1,415,865.97 0.99 0.00 None TexSTAR LGIP 02000-20191 1 0 9/27/2019 492,471.90 100.00 492,471.90 0.17% None 1 492,471.90 0.99 492,471.90 0.99 TexSTAR LGIP 02000-11110 1,668,816.54 0.00 None 0 8/26/2016 1,668,816.54 100.00 1,668,816.54 0.56% S&P -AAA 0.99 1,668,816.54 0.99 0.00 None 1 0 Wells Fargo Sweep Cash 10/30/2008 2,757,825.07 100.00 2,757,825.07 0.92% None WFSWEEP 2,757,825.07 1.20 2,757,825.07 1.20 0.00 None Sub Total 506: General Obligation 1 0 21,037,991.44 1.13 21,037,991.44 21,037,991.44 1.13 21,037,991.44 7.05% 1 0.00 0 507: General Obligation Series 2020 1 Texas Class LGIP 8/11/2020 1,205,481.60 100.00 1,205,481.60 0.4% None 1 TX-01-0615-0008 1,205,481.60 1.16 1,205,481.60 1.16 0.00 None 0 Wells Fargo Sweep Cash 10/15/2019 730,299.18 100.00 730,299.18 0.24% None 1 WFSWEEP 730,299.18 1.20 730,299.18 1.20 0.00 None 0 1,935,780.78 1,935,780.78 0.64% 1 Sub Total 507: General Obligation Series 1,935,780.78 1.17 1,935,780.78 1.17 0.00 0 2020 508: Certificates of Oblg Series 2020 Prepared by Shamaira Jagrup 23 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 6/30/2022 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 Texas Class LGIP TX-01-0615-0009 Wells Fargo Sweep Cash WFSWEEP Sub Total 508: Certificates of Oblg Series 2020 2,765,424.83 1, 242, 982.61 4,008,407.44 8/11/2020 1.16 2,765,424.83 2,765,424.83 100.00 1.16 2,765,424.83 10/15/2019 1,242,982.61 100.00 1,242,982.61 1.20 1, 242, 982.61 1.20 4,008,407.44 4,008,407.44 1.17 4,008,407.44 1.17 0.93% 0.00 0.42% 0.00 1.35% 0.00 None None None None 1 0 1 0 1 0 509: General Obligation Series 2021 Texas Class LGIP 8/15/2021 1,024,120.49 100.00 TX-01-0615-0015 1, 024,120.49 1.16 1,024,120.49 1.16 Wells Fargo Sweep Cash 10/15/2019 1,214,252.26 100.00 WFSWEEP 1,214,252.26 1.20 1,214,252.26 1.20 2,238,372.75 Sub Total 509: General Obligation Series 2,238,372.75 1.18 2,238,372.75 1.18 2021 1, 024,120.49 1,214,252.26 2,238,372.75 0.34% None 1 0.00 None 0 0.41% None 1 0.00 None 0 0.75% 0.00 0 511: PEDC Capital Projects Wells Fargo Sweep Cash 12/15/2018 -95,113.36 100.00 -95,113.36 -0.03% None 1 WFSWEEP -95,113.36 1.20-95,113.36 1.20 0.00 None 0 Sub Total 511: PEDC Capital Projects -95,113.36 1.20 -95,113.36 -95,113.36 -0.03% 1 -95,113.36 1.20 0.00 0 512: Certificates of Oblg Series 2021 Wells Fargo Sweep Cash 2/15/2020 -12,175,884.07 100.00 -12,175,884.07 -4.08% None 1 WFSWEEP -12,175,884.07 1.20-12,175,884.07 1.20 0.00 None 0 Sub Total 512: Certificates of Oblg Series 2021 -12,175,884.07 1.20 -12,175,884.07 -12,175,884.07 1.20 -12,175,884.07 -4.08% 1 0.00 0 513: General Obligation Series 2022 Wells Fargo Sweep Cash 10/1/2020 -1,803,415.91 100.00 -1,803,415.91 -0.6% None WFSWEEP -1,803,415.91 1.20-1,803,415.91 1.20 0.00 None Prepared by Shamaira Jagrup 1 0 24 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 6/30/2022 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 513: General Obligation Series 2022 -1,803,415.91 1.20 -1,803,415.91 -1,803,415.91 1.20 -1,803,415.91 -0.6% 0.00 1 0 514: Infrastructure Reinvestment Fund Wells Fargo Sweep Cash WFSWEEP Sub Total 514: Infrastructure Reinvestment Fund 12/15/2019 1,660,856.12 100.00 1,660,856.12 1,660,856.12 1.20 1,660,856.12 1.20 1,660,856.12 1,660,856.12 1,660,856.12 1.20 1,660,856.12 1.20 0.56% 0.00 0.56% 0.00 None None 1 0 1 0 515: Certificates of Oblig 2020 TIRZ Texas Class LGIP 8/11/2020 1,456,934.76 100.00 1,456,934.76 0.49% None 1 TX-01-0615-0010 1,456,934.76 1.16 1,456,934.76 1.16 0.00 None 0 Wells Fargo Sweep Cash 8/15/2020 633,262.38 100.00 633,262.38 0.21% None 1 WFSWEEP 633,262.38 1.20 633,262.38 1.20 0.00 None 0 2,090,197.14 2,090,197.14 0.7% 1 Sub Total 515: Certificates of Oblig 2020 2,090,197.14 1.17 2,090,197.14 1.17 0.00 0 TIRZ 516: Certificates of Oblig 2021 TIRZ Texas Class LGIP 8/15/2021 5,489,244.15 100.00 5,489,244.15 1.84% None 1 TX-01-0615-0013 5,489,244.15 1.16 5,489,244.15 1.16 0.00 None 0 Wells Fargo Sweep Cash 10/1/2020 1,271,190.51 100.00 1,271,190.51 0.43% None 1 WFSWEEP 1,271,190.51 1.20 1,271,190.51 1.20 0.00 None 0 6,760,434.66 6,760,434.66 2.27% 1 Sub Total 516: Certificates of Oblig 2021 6,760,434.66 1.17 6,760,434.66 1.17 0.00 0 TIRZ 517: Certificates of Obligation 2022 Wells Fargo Sweep Cash 10/1/2020 -183,309.51 100.00 -183,309.51 -0.06% None 1 WFSWEEP -183,309.51 1.20-183,309.51 1.20 0.00 None 0 Sub Total 517: Certificates of Obligation 2022 Prepared by Shamaira Jagrup -183,309.51 1.20 -183,309.51 -183,309.51 1.20 -183,309.51 -0.06% 1 0.00 0 25 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 6/30/2022 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 518: Certificates of Oblig 2022 TIRZ Wells Fargo Sweep Cash WFSWEEP -3,801,470.80 Sub Total 518: Certificates of Oblig 2022 TIRZ -3,801,470.80 10/1/2020 1.20 1.20 -3,801,470.80 -3,801,470.80 100.00 1.20 -3,801,470.80 -1.27% 0.00 None None 0 -3,801,470.80 -3,801,470.80 1.20 -3,801,470.80 -1.27% 0.00 1 0 519: General Obligation Series 2023 Wells Fargo Sweep Cash WFSWEEP Sub Total 519: General Obligation Series 2023 10/15/2021 -14,988.78 1.20 -14,988.78 100.00 -14,988.78 -0.01% None -14,988.78 1.20 0.00 None 1 0 -14,988.78 -14,988.78 1.20-14,988.78 1.20 -14,988.78 -0.01% 0.00 1 0 520: Certificates of Oblg Series 2023 Wells Fargo Sweep Cash WFSWEEP Sub Total 520: Certificates of Oblg Series 2023 Texas Class LGIP TX-01-0615-0001 Texas Class LGIP TX-01-0615-0007 -13,898.25 -13,898.25 61.54 10/15/2021 -13,898.25 100.00 -13,898.25 0% None 1.20-13,898.25 1.20 1.20 0.00 None 1 0 -13,898.25 -13,898.25 1.20 -13,898.25 0% 0.00 12/20/2016 61.54 100.00 61.54 0% None 1.16 61.54 1.16 0.00 None 1 0 0 5,820,304.52 9/19/2019 5,820,304.52 1.16 5,820,304.52 100.00 5,820,304.52 1.16 1.95% None 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 5/31/2006 932,238.96 100.00 932,238.96 0.31% None 932,238.96 1.20 932,238.96 1.20 0.00 None 1 0 Wells Fargo TWDB Cash 11/1/2016 81,903.75 100.00 81,903.75 0.03% None WF4094 81,903.75 1.20 81,903.75 1.20 0.00 None Wells Fargo TWDB Cash WF6624 Prepared by Shamaira Jagrup 1 0 5/15/2018 966,251.02 100.00 966,251.02 0.32% None 966,251.02 1.20 966,251.02 1.20 0.00 None 1 0 26 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 6/30/2022 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 TWDB Cash WF3100 3,760,562.65 4/1/2021 0.54 3,760,562.65 3,760,562.65 100.00 0.54 3,760,562.65 1.26% 0.00 Wells Fargo TWDB Cash WF2847 Wells Fargo TWDB Cash WF4102 Wells Fargo TWDB Cash 6,060,115.79 8/6/2019 6,060,115.79 1.20 6,060,115.79 100.00 6,060,115.79 1.20 None None 1 0 2.03% None 0.00 None 1 0 11/1/2016 906,099.07 100.00 906,099.07 0.3% None 906,099.07 1.20 906,099.07 1.20 0.00 None 1 0 3/15/2017 2,411,962.35 100.00 2,411,962.35 0.81% None WF5883 2,411,962.35 1.20 2,411,962.35 1.20 0.00 None Sub Total 550: W/S Impact Fee 1 0 20,939,499.65 1.07 20,939,499.65 20,939,499.65 1.07 20,939,499.65 7.01% 1 0.00 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,007,292.27 1/15/2022 3,007,292.27 100.00 3,007,292.27 1.01% None 1.16 3,007,292.27 1.16 0.00 None 1 0 1/15/2020 1,913,114.56 100.00 1,913,114.56 0.64% None 1 1,913,114.56 1.20 1,913,114.56 1.20 0.00 None 0 4,920,406.83 4,920,406.83 1.65% 1 4,920,406.83 1.17 4,920,406.83 1.17 0.00 0 552: Waste Water Impact Fee Fund Texas Class LGIP TX-01-0615-0001 2,506,076.89 1/15/2022 2,506,076.89 100.00 2,506,076.89 0.84% None 1.16 2,506,076.89 1.16 0.00 None 1 0 Wells Fargo Sweep Cash 1/15/2020 1,494,573.57 100.00 1,494,573.57 0.5% None WFSWEEP 1,494,573.57 1.20 1,494,573.57 1.20 0.00 None Sub Total 552: Waste Water Impact Fee Fund 1 0 4,000,650.46 1.17 4,000,650.46 4,000,650.46 1.17 4,000,650.46 1.34% 1 0.00 0 565: Revenue Bonds 1999 & 2003 Texas Class LGIP TX-01-0615-0001 Prepared by Shamaira Jagrup 5,522,108.37 1/15/2017 5,522,108.37 100.00 5,522,108.37 1.85% None 1.16 5,522,108.37 1.16 0.00 None 1 0 27 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 6/30/2022 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-0007 3,309.51 9/19/2019 1.16 3,309.51 3,309.51 100.00 1.16 3,309.51 0% 0.00 None None 1 0 Texas Class LGIP TX-01-0615-0004 Wells Fargo Sweep Cash WFSWEEP Wells Fargo TWDB Cash WF5875 Sub Total 565: Revenue Bonds 1999 & 2003 9/15/2018 7,117.89 7,117.89 1.16 100.00 7,117.89 7,117.89 1.16 0% None 0.00 None 1 0 1,189,915.69 5/31/2006 1,189,915.69 100.00 1,189,915.69 0.4% None 1.20 1,189,915.69 1.20 0.00 None 1 0 9/15/2017 923,628.32 100.00 923,628.32 0.31% None 923,628.32 1.20 923,628.32 1.20 0.00 None 7,646,079.78 1.17 7,646,079.78 7,646,079.78 1 0 1.17 7,646,079.78 2.56% 1 0.00 0 566: Revenue Bonds Series 2020 Texas Class LGIP TX-01-0615-0011 1,892,241.56 8/11/2020 1,892,241.56 100.00 1,892,241.56 0.63% None 1.16 1,892,241.56 1.16 0.00 None 1 0 Wells Fargo Sweep Cash 10/15/2019 1,595,985.49 100.00 1,595,985.49 0.53% None WFSWEEP 1,595,985.49 1.20 1,595,985.49 1.20 0.00 None Sub Total 566: Revenue Bonds Series 2020 1 0 3,488,227.05 1.18 3,488,227.05 3,488,227.05 1.18 3,488,227.05 0.00 0 567: Water Drinking Bonds Series 2020 Texas Class LGIP 1/15/2022 2,059.86 100.00 2,059.86 0% None TX-01-0615-0001 2,059.86 1.16 2,059.86 1.16 0.00 None 1 0 Wells Fargo Sweep Cash 10/15/2019 -11,864,592.92 100.00 -11,864,592.92 -3.98% None WFSWEEP -11,864,592.92 1.20-11,864,592.92 1.20 0.00 None Wells Fargo TWDB Cash WF6100 Sub Total 567: Water Drinking Bonds Series 2020 Prepared by Shamaira Jagrup 1 0 60,840,400.73 6/16/2020 60,840,400.73 100.00 60,840,400.73 20.39% None 0.54 60,840,400.73 0.54 0.00 None 1 0 48,977,867.67 0.38 48,977,867.67 48,977,867.67 0.38 48,977,867.67 0.00 0 28 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 6/30/2022 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 568: Revenue Bonds Series 2021 Texas Class LGIP TX-01-0615-0014 Wells Fargo Sweep Cash WFSWEEP Sub Total 568: Revenue Bonds Series 2021 5,353,252.74 8/15/2021 5,353,252.74 1.16 5,353,252.74 100.00 1.16 5,353,252.74 1.79% 0.00 None None 0 1,389,345.15 10/15/2019 1,389,345.15 100.00 1,389,345.15 0.47% None 1.20 1,389,345.15 1.20 0.00 None 1 0 6,742,597.89 1.17 6,742,597.89 6,742,597.89 1.17 6,742,597.89 2.26% 0.00 1 0 569: Revenue Bonds Series 2022 Wells Fargo Sweep Cash WFSWEEP Sub Total 569: Revenue Bonds Series 2022 570: W/S Pay As You Go Texas Class LGIP TX-01-0615-0001 -14,953,710.41 -14,953,710.41 7,031,055.97 10/15/2019 -14,953,710.41 100.00 -14,953,710.41 1.20-14,953,710.41 1.20 1.20 -5.01% 0.00 None None 1 0 -14,953,710.41 -14,953,710.41 1.20 -14,953,710.41 -5.01% 0.00 6/15/2020 7,031,055.97 100.00 7,031,055.97 2.36% None 1.16 7,031,055.97 1.16 0.00 None 1 0 0 Wells Fargo Sweep Cash WFSWEEP Sub Total 570: W/S Pay As You Go 2,057,373.67 12/31/2007 2,057,373.67 1.20 2,057,373.67 100.00 2,057,373.67 1.20 0.69% None 0.00 None 1 0 9,088,429.64 1.17 9,088,429.64 9,088,429.64 1.17 9,088,429.64 3.05% 0.00 1 0 571: TWDB Revenue Bonds Series 2021 Wells Fargo Sweep Cash WFSWEEP Wells Fargo TWDB Cash -29,501,543.74 10/1/2020 -29,501,543.74 100.00 -29,501,543.74 -9.89% None 1.20-29,501,543.74 1.20 0.00 None 1 0 4/1/2021 69,966,487.10 100.00 69,966,487.10 23.45% None WF3100 69,966,487.10 0.54 69,966,487.10 0.54 0.00 None Sub Total 571: TWDB Revenue Bonds Series 2021 1 0 40,464,943.36 40,464,943.36 0.05 40,464,943.36 0.05 40,464,943.36 13.56% 1 0.00 0 574: Revenue Bonds Series 2023 Prepared by Shamaira Jagrup 29 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 6/30/2022 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 574: Revenue Bonds Series 2023 -29,598.75 -29,598.75 10/15/2021 1.20 1.20 -29,598.75 -29,598.75 100.00 1.20 -29,598.75 -0.01% 0.00 None None 1 0 -29,598.75 -29,598.75 1.20 -29,598.75 -0.01% 0.00 1 0 Wells Fargo Sweep Cash WFSWEEP Sub Total 575: MUD 4 Capital Programs 576: Revenue Bonds Series 2024 25,665.43 2/1/2013 1.20 25,665.43 25,665.43 100.00 1.20 25,665.43 0.01% 0.00 None None 1 0 25,665.43 25,665.43 1.20 25,665.43 1.20 25,665.43 0.01% 0.00 1 0 Wells Fargo Sweep Cash WFSWEEP Sub Total 576: Revenue Bonds Series 2024 Texas Class LGIP TX-01-0615-0001 Wells Fargo Sweep Cash WFSWEEP Sub Total 600: Water & Sewer 601: Water & Sewer Debt Fund Texas Class LGIP TX-01-0615-0001 Wells Fargo Sweep Cash WFSWEEP Prepared by Shamaira Jagrup -7,773.75 -7,773.75 1,457,498.46 10/15/2021 -7,773.75 100.00 -7,773.75 0% None 1.20-7,773.75 1.20 1.20 0.00 None -7,773.75 -7,773.75 1.20 -7,773.75 0% 0.00 1 0 1 0 12/20/2016 1,457,498.46 100.00 1,457,498.46 0.49% None 1.16 1,457,498.46 1.16 0.00 None 0 3,115,776.18 5/31/2006 3,115,776.18 1.20 3,115,776.18 100.00 3,115,776.18 1.20 1.04% 0.00 None None 1 0 4,573,274.64 15,040,683.56 1.19 4,573,274.64 4,573,274.64 1.19 4,573,274.64 1.53% 0.00 12/15/2020 15,040,683.56 100.00 15,040,683.56 5.04% None 1.16 15,040,683.56 1.16 0.00 None 1 0 0 22,266,552.27 10/15/2020 22,266,552.27 1.20 22,266,552.27 100.00 22,266,552.27 1.20 7.46% 0.00 None None 1 0 30 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 6/30/2022 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 601: Water & Sewer Debt Fund 37,307,235.83 1.18 37,307,235.83 37,307,235.83 1.18 37,307,235.83 12.5% 0.00 1 0 610: Solidwaste Wells Fargo Sweep Cash WFSWEEP Sub Total 610: Solidwaste 12/1/2006 854,206.95 100.00 854,206.95 0.29% None 854,206.95 1.20 854,206.95 1.20 0.00 None 854,206.95 1.20 854,206.95 854,206.95 1.20 854,206.95 0.29% 0.00 1 0 0 700: Risk Management Fund Wells Fargo Cash W F 1376 Wells Fargo Sweep Cash WFSWEEP 10/15/2020 46,111.91 100.00 46,111.91 0.02% None 1 46,111.91 0.23 46,111.91 0.23 0.00 None 0 1,258,073.86 Sub Total 700: Risk Management Fund 1,304,185.77 10/31/2006 1,258,073.86 100.00 1,258,073.86 0.42% None 1 1.20 1,258,073.86 1.20 0.00 None 0 1,304,185.77 1,304,185.77 0.44% 1 1.16 1,304,185.77 1.16 0.00 0 701: Employee Benefit Fund Wells Fargo Sweep Cash 9/1/2007 63,141.00 100.00 63,141.00 0.02% None WFSWEEP 63,141.00 1.20 63,141.00 1.20 0.00 None Sub Total 701: Employee Benefit Fund 63,141.00 1.20 63,141.00 63,141.00 63,141.00 1.20 1 0 0.02% 1 0.00 0 702: Health Claims Fund Wells Fargo Cash 7/21/2010 775,097.85 100.00 775,097.85 0.26% None 1 WF9871 775,097.85 0.23 775,097.85 0.23 0.00 None 0 Wells Fargo Sweep Cash 9/15/2010 2,404,304.52 100.00 2,404,304.52 0.81 % None 1 WFSWEEP 2,404,304.52 1.20 2,404,304.52 1.20 0.00 None 0 3,179,402.37 3,179,402.37 1.07% 1 Sub Total 702: Health Claims Fund 3,179,402.37 0.96 3,179,402.37 0.96 0.00 0 703: Motor Pool Fund Prepared by Shamaira Jagrup 31 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 6/30/2022 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 Wells Fargo Sweep Cash WFSWEEP Sub Total 703: Motor Pool Fund 10,023,910.18 2,765,933.54 12,789,843.72 1/15/2022 1.16 10/15/2018 1.20 10,023,910.18 10,023,910.18 2,765,933.54 2,765,933.54 100.00 1.16 10,023,910.18 100.00 2,765,933.54 1.20 12,789,843.72 12,789,843.72 1.17 12,789,843.72 1.17 3.36% 0.00 0.93% 0.00 4.29% 0.00 None None None None 1 0 1 0 1 0 TOTAL PORTFOLIO 298,423,537.41 0.90 298,423,507.41 298,423,511.41 0.91 298,340,126.74 26,833.91 100.00% -83,384.67 9 0.04 Prepared by Shamaira Jagrup 32 City of Pearland Treasury Yield Curve Treasury 3/31/2022 4/30/2022 5/31 /2022 6/30/2022 1 Month 3 Month 6 Month 1 Year 2 Year 3 Year 5 Year 10 Year 0.18 0.45 0.86 1.34 1.91 2.09 2.11 2.13 0.30 0.76 1.25 1.88 2.53 2.72 2.77 2.74 0.58 0.99 1.49 2.06 2.62 2.79 2.87 2.90 1.06 1.54 2.17 2.65 3.00 3.15 3.19 3.14 3,50 3.00 2.50 2.00 1.50 1.00 0.50 0.00 1 Month 3 Month 6 Month 1 Year 2 Year 3 Year 5 Year 10 Year • 3/31/2022 ▪ 4/30/2022 • 5/31/2022 • 6/30/2022 Note 1 Note 2 Prepared by Shamaira Jagrup Center Footer 33 Pledged Collateral Reconciliation Report June 30, 2022 Bank Account Ending Account Name Amount Wells Fargo 3395 Credit Card Account - Wells Fargo 2841 Sweep Account 16,114.00 * Wells Fargo 5455 False Alarm Reduction Program 287,902.12 Wells Fargo 7843 Alvin ISD 14,061,909.42 Wells Fargo 1790 EMS Payments - Wells Fargo 9871 Health Claims 775,097.85 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 2017E - * 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 36,367.50 Wells Fargo 1376 Workers Compensation Claims 46,111.91 Total of Bank Balances $ 15,223,502.80 Pledged Collateral for City FDIC Insurance 25,295,319.14 500,000.00 $ 25,795,319.14 Over (Under) Collateralized $ 10,571,816.34 Total % Collateralized 169.4% Bank Account Ending Account Name Amount Wells Fargo 4258 Development Authority 1,002,497.25 Total of Bank Balances Pledged Collateral for DAP FDIC Insurance $ 1,002,497.25 833,672.54 250,000.00 $ 1,083,672.54 Over (Under) Collateralized $ 81,175.29 Total % Collateralized 108.1% Total % Collateralized 165.7% Status Collateralized * Accounts are sweeping to a higher yielding money market fund which does not require collateral.