Loading...
HomeMy WebLinkAboutR2021-260 2021-11-22uocuign tnvelope lu 441.A41uu-tutu-4-ity-H411-uyyuAZ0=4o(_, RESOLUTION NO. R2021-260 A Resolution of the City Council of the City of Pearland, Texas, accepting the City's Investment Report for the quarter ending September 2021 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 September 2021 PASSED, APPROVED, AND ADOPTED this 22nd day of November, A.D , 2021 0.---DocuSigned by: )--ktVI tittE MAYOR ATTEST DocuSigned by: CRYTA?LuN4-ROAN, TRMC, CMC CITY SECRETARY APPROVED AS TO FORM DocuSigned by: DA'In4OKER CITY ATTORNEY City of Pearland Quarterly Investment Report June 30, 2021 to September 3002021 This report is prepared for the City of Pearland in accordance with Chapter 2256 of the Public Funds Investment Act (PFIA). Section2256. D23 (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 ail 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 Unrealized GainfLoss YTM Cost Treasury 1 Year Interest Earned Days To Maturity 7131/2021 356,905,624.05 356 905,255.14 8/31/2021 384,579,507.48 384,579,507.48 9/30/2021 357,085,589.39 357,095,589.39 368.91 0.00 0.00 0.05 0.05 0.02 0.08 0,07 0,08 115,384.51 14,137.64 9,43@.59 Total/ Average 366,190,244.31 366,190,117.34 122.97 0.04 0.08 38,941.74 1 /(( ArnJ. n , C of Financial Officer Date Kristen Woolley, Deputy rector of Finance r � � �v Sharnaira Jagru , Treasury Manager to (25I7-1 Date i0--25 -21 Date 1 City of Pearland Distribution by Security Type - Book Value Report Group: Pearland Begin Date: 6/3412021, End Dale: 919012021 Security Type Allocation Security Type Book Value 6/30/2021 % of Portfolio 6/30/2021 gook Value 9/30/2021 of Portfolio a/3022021 Cash1 Certificate Of Deposit Compound CD FHLMC Bond Local Government Investment Pool 247,016,241.25 744,000.00 4,119,375.72 999,726.52 116,215,970.02 66.92 0.20 1.12 0.27 31.49 225,978,257.93 0.00 0.00 0.00 131,147,331.46 63.N 0.00 0,00 0,00 36.72 Total [Average 369,095,313.54 Portfolio Holdings as of 6/3012021 • 66,9296 -Cash • 0,2% -Certificate V.,. • 1,1296 -Compound CD • 0,27%-FHLMC Bond • 3L4996-LocalGowernm.,, 100.00 357,085,589.39 100.00 Portfolio Holdings as of 9I3U12021 • 63,2896 -Cash • 096-Certif cats Of De.,. • 0% -Compound CD i D%-FHLMC Band Prepared by Shamaira Jagrup City of Pearland Distribution by Maturity Range - Book Value Report Group: Pearland Begin Date: 6/3012021, End Dale: 919012021 Maturity Range Allocation Maturity Range Book Value 613012021 % of Portfolio 6/30/2021 Book Value 9/30/20,21 % of Portfolio 92ot2021 0-1 Month 1-3 Months 363,976,211.30 5,119,102.24 08.61 1.39 357,086,589, 39 0.00 100.00 0.00 Total 1 Average 369,095,313.54 100.04 357, 085, 589.39 100,00 Portfolio Holdings In Thousands 400,000 - 350,000 300,000 - 250,000 200,000 - 150,000 100,400 - 50,400 00 C1-1 M 1-3 M • 6/30/2021 • 9/3012021 Prepared by Shamaira Jagrup 3 City of Pearland Total Rate of Return - Book Value by Month Report Group: Pearland Begin Date: 10131/2020, End Dale: 913012021 Beginning BV + Interest Earned Realized Investment Average Capital Annualized Treasury 1 Month Accrued Interest During Period -BV GalnILoss-BV Income -BV Base -BV TRR-BV TRR-BV Year 10131/2020 329.724.785.22 11130/2020 323.300.638.16 12131/2020 325.242.610.26 1131/2021 354.183.811.95 2128/2021 362.975.157.74 3131/2021 338.523.097.33 4/30/2021 330.346.766.63 5/31/2021 389.110.603.85 6/30/2021 378.280.668.46 7/31/2021 369.122.644.63 8/31/2021 356.916.96.8.27 9/30/2021 384.593.117.40 37.747.89 33.443.71 34.121.36 33.754.76 28.911.79 28.500.34 23.963.82 26.013/2 20.198.31 15.364.51 14.137.64 9,439.59 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 37.747.B9 33.443.71 34.121.36 33.750.76 28.911.79 28.600.34 23,96 3.82 26.013.72 20.198.31 15.364.51 14.137.64 9.439.59 326.299, 8 38.78 324.125,079.70 341.591.9+04.28 359,041.729.20 350.717,609.93 333.205.811.94 395.993.2 37.15 383.145,447.05 373.641, 222.72 362.390.986.93 372.013.319.34 368.257.170.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.00 0.00 0.00 0.14 0.12 0.12 0.11 0.10 0.10 0.07 0.08 0.06 0.05 0.05 0.03 0.13 0.12 0.10 0.10 0.07 0.08 0.06 0.06 0.07 0.08 0.07 0.08 TotaUAverage 329,724,785.22 305, 593.44 0.00 305, 593.44 357,437,368.77 0.09 0.09 0.08 Annualized TRR-BV Prepared by Bharnaira Jagrup 4 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date. 9130)2021 Description Face Amount f CUSIP Shares YTM @ Cost Sock Value YTM rd Market Settlement Date Cost Value Market Price Market Value Accrued Interest % Portfolio Univ. Gain/Loss Credit Rating Credit Rating Days To CalIJMaturity Duration To Maturity Cash Wells Fargo Cash WF3025 Wells Fargo Gash WF9671 Wells Fargo Cash WF1376 Wells Fargo Sweep Cash WFSYdEEP 274,860.14 698.694.52 59.251,58 1,439,675.72 8/1212020 274,860.14 0.40 274,860.14 100.00 0.00 274,860.14 0.08% 0.04 None None 1 0 7/21)2010 698,694.52 100.04 698,694.52 0.15 698,694.52 0.15 4.2% 0.00 Nona None 1 0 10/1512020 59.251.58 100.00 59.251.56 0.16 59.251.56 0.16 0.02% None 1 0.00 None 0 5/31)2000 1,439,675.72 100.00 1,439,675.72 0.4% None 1 0.01 1,439,675.72 0.01 0,00 Nona 0 Wells Fargo Sweep Cash WFSWEEP 2,359,042.17 5/3112006 2,359,042.17 0.01 2,359,042.17 100.40 2,359,042.17 0.01 0.66% None 0.90 1 None 0 Wells Fargo Sweep Cash WFSWEEP 9.311.41 513112006 9,311.41 0.01 9.311.41 Wells Fargo Sweep Cash WFSWEEP 10,104,926.81 5131)2008 14,184,926.51 0.01 10,104,925.81 100.00 9.311.41 0.01 144.00 10,184,926, 81 0.01 0% None 1 0.00 None 0 2.85% None 1 0.00 None 0 Wells Fargo Sweep Cash WFSWEEP 1,000.01 513112006 0.01 1,000.01 1,000.01 10030 1,000.01 0.01 0% None 1 0.00 None 4 Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WF5WEER 3,418,079.34 1,002.211,95 5/3112006 3,418,079.34 0.01 3,418,079.34 100.00 3,418,079.34 0.t)1 0.96% 0.00 Nona None 1 0 5/31)2006 1,002,211.95 0.01 1,002,211.95 100.00 1,002,211.95 0.28% None 1 0.01 0.00 None 0 Wells Flo 5we0p Cosh WFSWEEP 5131)2006 171.212.40 100.00 171.212.40 0.05% Norte 171,212.40 0.01 171,212.40 0.01 0.00 Nona 1 0 Wells Fargo Sweep Cash WFSWEEP 5/31)2006 103,153.92 0.01 103,153.92 100.00 103,153.92 0.01 103,153.92 0.03% Nome None 1 0 Prepared by Shamaira Jagrup 5 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date. 913O12021 Description Face Amount GUStP Shares YTM O1 Cost Book Value YTM Market Settlement Date Cost Value Market Prise Market Value Accrued Interest % Portfolio Credit Rating Days To CaIIJMaturity Uwe. Dahl/oat. Credit Rating Duration To Maturity Wells teary❑ Sweep Cash WFSWEEP -0.02 5/3112006 0.01 -0.42 -0.02 0.01 -0.02 0.00 None None 1 0 Wells Fargo Sweep Cash WFSWEEP 2.435.344.56 5131./2006 2,435,344.56 6.01 2,435.344.56 100.00 2,435,344.56 0.01 0.68% 0.00 None None 1 0 Wells Fargo Sweep Cash WFSWEEP 5/3112066 48,975.21 100.00 48.975.21 48.975.21 0.01 49,075.21 0.01 0.01% None 0.00 None 1 D Wells Fargo Sweep Cash WFSWEEP 5/3112006 465.204.76 100.00 465.204.75 0.13% None 1 465,204.76 0.01 485,204.76 0.01 0.00 None 0 Wells Fargo Sweep Cash WFSWEEP 3,430,030.50 513112006 3,430,030.60 0.01 3,430,030.50 Wells Fargo Sweep Cash WFSWEEP -483,867.65 513112006 -483,867 65 0.01 -483,867.65 Wells Fargo Sweep Cash WFSWEEP 46,634.72 5/3112006 46.634.72 0.01 46.634.72 Wells Fargo Sweep Cash WFSWEEP 5/3112006 56.976.62 56.976.82 0.01 106.06 3,430,030.50 0.01 100.06 •483.867.65 0.01 100.00 46.634.72 0.01 100.00 56.975.62 56.976.62 0.01 0.96% 0.00 None None 1 0 -0.14% None 1 0.46 None 0 0.01% None 1 0.06 None 0 0.02% None 1 0.40 None 0 Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP Walls Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP •365.552.64 617.992.95 5.946.700.90 166.993.67 5131/2066 365,552.64 100.00 -365.552.84 0.01 -365.552.64 0.01 -0.1% None 1 0.00 None 0 5131/2008 017.992.95 100.00 617,992.95 0.01 817,092.95 0.03 4.17% None 1 0.00 None 0 5131/2OO6 5,946.700-90 100.00 5,940,700.90 0.01 5.046.700.94 D.O1 1.67% None 1 0.00 None 0 5/3112006 166.993.87 100.40 166,993.87 0.05% None 1 0.01 166.993.87 0.01 0.00 None Prepared by She maira Jagrup 6 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date. 9130)2021 Description Face Amount? GUStP Shares YTM O1 Cost Book Value YTM Market Settlement Date Cost Value Market Price Market Value Accrued Interest % Portfolio Credit Rating Days To CaIIJMaturity Uwe. Gairt'Lnss Credit Rating Duration To Maturity Wells teary❑ Sweep Cash WFSWEEP 39.274.82 6/3012006 0.01 39.274.62 39.274.82 '00.1k) 39,274.82 0.01% 0.00 None. None 1 0 Wells Fargo Sweep Cash WFSWEEP 1,100.570.72 10/31)2006 1,100.570.72 6.01 1,100.570.72 100.00 1.100.570.72 0.01 0.31% 0.00 None None 1 0 Wells Fargo Sweep Cash WFSWEEP 12/112/106 321,844.10 100.00 321,844.10 321.944.10 0.01 321.844,10 0.01 0.09% None 0.00 None 1 a Wells Fargo Sweep Cash WFSWEEP 198,300.06 9/1/2007 196,300.06 100.00 196.300,06 0.05% None 1 0.01 198,300.06 0.01 0.00 None 0 Wells Fargo Sweep Cash WFSWEEP 3.438.151.90 12/3112007 3,438,151.90 0.01 3.438.151.90 100.00 3,438,151.94 0.96% None 0.01 a.0D None 1 0 Wells Fargo Sweep Cash WFSWEEP 4,364,193.20 10/30/2006 4,364,193.20 0.01 4,364,193.20 Wells Fargo Sweep Cash WFSWEEP 4.23149 911512009 4,237.49 0.01 4.237.49 Wells Fargo Sweep Cash WFSWEEP 2,923,903.79 9115)2010 2,923,943.79 0.01 2,923.903.79 100.00 4,364,193.20 0.01 100.00 4,237.49 0.01 100.00 2,923,903.70 0.01 1.22% None 1 0O0 None 0 0% None 1 0.00 None 0 6.82% None 1 0,00 None 0 Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP 463.424.30 25.659.29 -281.099.7B 3,644,677.86 4/15)2012 463,424.30 100.00 463.424.30 9.13% 0.01 483.424.30 0.01 0.44 Norse 1 None 0 2/112013 25,659.29 100.00 25,659.29 0.01% None 1 0.01 25,859.29 0.01 0.00 None 0 11115/2015 -281,099.78 100.04 -281,099.78 0.01 -281.099.78 D.01 -0.08% None 1 0.110 None 0 10/1512016 3.844.677.86 100.00 3,644.677.86 0. D1 3,644,677.86 0.01 1.02% None 1 0.00 None 0 Prepared by Shamaira Jagrup 7 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date. 913012021 Description Face Amount GUStP Shares YTM O1 Cost Book Value YTMrd.. Market Settlement Date Cost Value Market Prise Market Value Accrued Interest % Portfolio Credit Rating Days To CaIIJMaturity Uhre. Gael/oat Credit Rating Duration To Maturity Wells teary❑ Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP 1,069,478.80 34.09 865.561.19 10/1512019 0.01 1.069.476.80 1,069,475.80 0.41 1,089,478.60 0.3 k 0.00 one None 1 0 10/15)2019 0.01 34.09 100.00 34.09 0.01 34.09 0% None 0.00 None 1 0 10/1512019 855:561.19 100.00 865,561.19 0.01 865.581.19 0.01 0.24% None 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 10115/2019 775,106.12 0.01 775,108.12 100.00 775,146.12 0.01 775,145.12 0.22% None 1 0.00 None 0 Wells Fargo Sweep Cash WFSWEEP 906.606.00 10/15/2019 906,600.00 0.01 906.608.00 Wells Fargo Sweep Cash WFSWEEP -13,314.914.76 10/15+2019 -13,314,914.76 0.01 -13,314.914.76 Wells Fargo Sweep Cash WFSYI/EEP 2,319,772.29 1011512019 2,319,772.29 0.01 2,319,772.29 Wells Fargo Sweep Cash WFSWEEP -10,239.814.92 10/1512019 -10,239,814.92 0.01 -10,239,814.92 100.00 906,606.44 0.01 100.06 •13,314.914.78 0.01 104.00 2,319,772:29 0.01 100.00 -10,239.814.92 6.41 0.25% 0.00 None None 1 0 -3,72% Nona 1 0.00 None 0 0.65% None 1 0.66 None 0 •2.87% 0.00 None 1 None 0 Wells Fargo Sweep Cash WFSWEEP 1.428.385.10 12/15)2019 1,428,385.10 0.01 1,428,385.10 100.00 1,428,365.10 0.01 0.4% None 0.40 1 None 0 Wetle Fargo Sweep Cash WFSWEEP Walls Fargo Sweep Cash WFSWEEP 3,055,585.15 3,734,319.43 111512020 3,055,665.15 0.01 3,056,685.15 100.00 3,056,685.15 0.86% None 1 0.01 0.46 None 0 1115+2020 3,734,310.43 100.00 3,134,319.43 1.05% None 1 0.01 3.734.319.43 0.01 0.00 None 0 Wells Fargo Sweep Cash WFSWEEP 1/15)2020 951.22 100.00 951.22 0.01 951.22 0.01 95122 0% None 1 0.00 None 0 Prepared by Sha'Taira Jagrup 8 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date. 9.130/2021 Description GUStP Settlement Date Cost Value Market Prise Market Value Face Amount 1 Shares YTM 01 Cost Book Value YTM . Market Accrued Interest % Portfolio Credit Rating Days To CaIIJMaturity Mine. Gail-lLass Credit Rating Duration To Maturity Wells teary❑ Sweep Cash WFSWEEP -11,413.680.42 2/15)2020 0.01 -11.413.680.42 -11,413,680.42 100.00 0.01 -11,413.880.42 •3.2% 0.00 None None 1 0 Wells Fargo Sweep Cash WFSWEEP .2,971-069.96 5/1512020 -2,971.069.96 0-01 •2,971-069.96 100.06 -2,971.069.96 0.01 - 0.83% None 0-00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 525.199.23 8/15/2020 0.01 525,199.23 525,190.23 100.00 0.01 525,199.23 0.15% None 0.00 None 1 a Wells Fargo Sweep Cash WFSWEEP -448,150-35 0/15/2020 -448,150.35 0.01 -448,150-35 100.00 448.150.35 -0.13% None 1 0-01 0.00 None 0 Wells Fargo Sweep Cash WFSWEEP -37.171.00 10/112020 -37,171-00 0.01 -37.171.00 100-06 -37.171.00 0.01 -0.01% 0.00 None None 1 0 Wells Fargo Sweep Cash WFSWEEP -3,750,707.45 101112020 -3,750.707.45 0.01 -3,750,707.45 Wells Fargo Sweep Cash WFSYI(EEP 565.070.39 10+1/2020 565,470.39 0.01 565.070.39 Wells Fargo Sweep Cash WFSWEEP -2,640,555.91 10+112020 -2,640.555.91 0.01 -2,640,555.91 100.00 .3.750,707.45 0.41 100.44 565.070.39 0.01 100.00 -2.840.555.91 0.01 - 1.05% None 1 0.00 None 0 0.16% None 1 0.06 None 0 -0.74% None 1 0.00 None 0 Wells Fargo Sweep Cash WFSWEEP .2,371.597.89 1011/2020 -2,371.597.89 0.01 -2,371,597.89 100.{10 -2,371.597.89 0.01 - 0.66% None 1 0.00 None 0 Wells Fargo Sweep Cash WFSWEEP 13,529,586.09 10(15/2020 13,529,588.09 0.01 13,529,588.00 100.00 13,529,586.09 3.79% None 1 0.01 0.00 None 0 Walls Fargo Sweep Cash WFSWEEP 11(15/2020 -40,971-79 104-00 -40,871.79 -0.01% None -40.671.79 0.01 -40,871.79 0.01 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 11/1512020 -58.444.77 100.00 -56,4-04-77 -58,-044.77 0.01 -58,444.77 0.01 -0112% None 1 0.00 None 0 Prepared by Shamaira Jagrup 9 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 9/30/2021 Description Face Amount GLIStP Shares VIM Cost Book Value VW a Market Settlement ❑ate Cost Value Market Price Market Value Accrued Interest % Portfolio Credit Rating Days To Cal Maturity Unra. Gael/oat Credit Rating Duration To Maturity Wells teary❑ Sweep Cash WFSWEEP 3,944,485.80 511512021 4.01 3.944.485.50 3,944,485.50 0.01 3,944,485.50 0.00 None None 1 Wells Fargo TWDB Cash WF5875 9/1512017 922.293.82 922.293.82 6.01 100.00 922.293.82 922.293.82 0.01 0.263 0.50 None None Wells Fargo TWDB Cash W Fd094 81.785.43 11/1128/8 81.755.43 0.01 81.785,43 100.00 0.01 81.785.43 0.02% None 0.00 None 1 0 MI'S Fargo TWCJH Cash WF662d 2,831,598.98 5/1512018 2,631,598.98 100.00 2,531,598.93 0.74% None 1 0.01 2,631,598.96 0.01 0.00 None 0 Wells Fargo TWDB Cash WF6100 105.503.295.04 6/1612020 105,503,295_04 0.01 105.503.295.04 100.00 195,503,295.04 0.01 29.55% 4.00 None None 0 Walls Fargo TWOS Cash WF3100 Wells Fargo TWDU Cash WF3100 3,759,845.44 69,952,397.33 41112021 3,759,805.44 0.01 3,759,805.44 411)2021 69,952,397.53 0.01 69,952,397.33 Walls Fargo TWOS Cash WF2847 6,051,359.74 81612019 6,051,359.74 4.01 6,051,359.74 100.00 3,759,805.44 0.01 100.04 69.952.397.35 0.01 100.00 6.051.359.74 0.01 1.05% None 0.40 None a 19.59% None 0.00 NOne 0 1.69% None 0.00 None 0 Wells Fargo TWDB Cash WF4102 Wells Fargo TWDB Cash WF5683 Sub Total Cash 904.789.55 2,403,477.41 225.978.257.93 1111/2016 904,789.88 100.00 904.789.88 0.01 904.789.55 0.01 0.25% None 0.00 None a 3/1512017 2,408,477.41 0.01 2,408,477.41 100.04 2,408.477.41 0.01 0.67% None 0.00 None 0 0.01 225,979,257 93 225.978.257.93 DAM 295,978,267.33 63.27% 0.40 0 Local Government Investment Pool Texas Class LGIP TX -01-4615-0001 5,452,475.14 12/2012016 5,462.476 14 0.04 5,452.475.1.1 144,00 5.452.47514 1.53% None 1 4.04 4.00 None 0 Prepared by $hamaira Jagrup 10 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date. 9100/2021 Description Face Amount I CUSIP Shares VIM Cost Book Value Settlement Date Cost Value Market Price YTM r Market Market Value Accrued Interest % Portfolio Credit Rating Days To Cal liMaturity Uwe. Gainftess Credit Rating Duration To Maturity Teas Class LGIP TX -01.06155-0001 61.51 12/20)2016 0.04 61.51 61.51 0.04 61.51 0% 0.00 None None 1 0 Texas Class LGIP TX•01-6615-0001 Texas Class LGIP TS( -01-0615-0001 12/20)2016 6,627.11 6,627.11 0.04 100.00 6.627.11 6,627.11 0.04 0% NOW 0.00 None 1 0 2.020.196.31 12/2012016 2,020,196.31 0.04 2.020.186.31 100.00 2,020.196.31 0.04 0.57% None 0.00 None 1 a TexaS Class LGIP TX -01-0615-0001 3,651.715.88 1/15)2017 3,651,715-B8 100.00 3,651,715.55 1.02% None 1 0.04 3,651,715 -BB 0.04 0.00 Nona 0 Texas Class LGIP TX•01-0615-0001 1/15/2017 567,452.5B 0.04 567,452.58 100.00 567,452.56 0.04 567.452.56 0.16% None 0.00 None 1 0 Texas Class LGIP TX -01.0615-0001 5,006,544.16 1/15)2017 5,006.544.16 0.04 5,006,544.16 100.00 5,006,544.18 1,4% None 1 0.04 0.00 None 0 Texas Class LGIP TX -01-0610-0001 4,146,025.96 5/15/2017 4,146.025.98 0.04 4,146,028.06 100.00 4,146.026.95 1.16% D.D4 None 1 0.00 Nerve 0 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 -014615-0001 386,416.84 31,137.092.75 6,011.690.25 5.005.020.81 5015/2017 386,416.84 100.00 398,416.84 0.11% None 1 0.04 386,416.84 0.04 0.00 None 0 5/15/2017 31,137,092.75 0.04 31.137.092.75 100.00 31,137.092.75 0.04 8,72% Nona 1 0.00 None 0 6/15/2020 6.011.680.28 0.04 6,011,680.28 100.99 6,011,690.28 1.68% None 1 0.04 4.06 None 0 12)15/2020 5005.020-61 1DD.D0 5,005,020.61 1.4% None 1 0.04 5,005,020.61 0.04 0.00 None 0 Texas Class LGIP TX -01.0615-0008 8,693.014.54 9/11/2020 8.693.014.54 0.04 8,693,014.54 100.00 0.04 8.693,014.54 2.43% None 1 0.00 None 0 Prepared by Shamaira Jagrup 11 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date. 910012021 Description Face Amount I CUSIP Shares YTM rii1 Cost Book Value YTM Market Settlement Date Cost Value Market Price Market Value Accrued Interest % Portfolio Credit Rating Days To Cal liMaturity Uwe. GainfLnss Credit Rating Duration To Maturity Texas Class LGIP TX -01.0615.0012 8,551,387.83 8/15)2021 0.04 8.551.387.83 8,551,387.83 00.00 0.04 8,551,387.83 2.39% 0.00 None None 1 0 Texas Class LGIP TX.01-0615.0013 11,473,293.26 8/1512021 11,473,293.26 0.04 11,473,293.26 100.00 11.473.29326 0.04 3.21% 0.00 None None 1 0 Texas Class LGIP TS( -01-0615-0014 7.336.875AS 8/15)2.021 7,336,878.99 0.04 7.336.978.69 100.00 7,336,676.69 0.04 2.06% None 0.00 None 1 0 Texas Class LGIP TX -01-0615-0009 1,754,462.63 61l112020 1,756.462-63 100.00 1,759.482-53 0.49% None 1 0.04 1,758,482.65 0.04 0.00 None 0 Texas Class LGIP TX•01 -0615-0007 9/1912019 802169.83 0.04 802,169.83 100.00 802,169.65 802,169.83 0.04 0.22% 0.00 None Nona 1 0 Texas Class LGIP TX -01.0615-0007 9/19/2019 567,389.52 100.00 567.369.52 567.389.52 0.04 567.399.52 0.04 3,16% None 1 0.40 None 0 Texas Class LGIP TX -01-0615-0007 9/19)2019 3,300.34 100.00 3.300, 0% None 1 3,300.34 0.04 3,300.34 x.04 0.00 None 0 Texas Class LGIP TX -01-0615.0011 Texas Class LGIP TX -01-0615.0005 2,887,279.49 2.648.035.87 8011)2020 2,887,279.49 0.04 2,887,279.49 100.00 2,867,279.49 0.04 0.81% None 0.00 1 None 0 9/1512010 2,648,035.67 0.04 2.648.035.67 100.00 2,648.035.87 0.04 0.74% None 1 0.40 None 0 Texas Class LGIP TX -01-0615-0004 9/15)2018 7.099.60 100.00 7,099.60 7.099.90 0.44 7.099.50 0.04 0% None 1 0.00 None 0 Texas Class LGIP TX -01-0615-0015 9.016.055.09 9/16)2021 9,016,056.09 100.00 8,016.058.09 2.52% None 1 0.04 9.016.056.09 0.04 0.90 None 0 Texas Class LGIP TX -01.0615-0006 237.02525 9/1512018 237,025.25 0.04 237,025.25 100.00 237,02525 0.07% None 0.04 0.00 None 1 0 Prepared by $hamaira Jagrup 12 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 9}30/2021 Description CUSIP Face Amount Shares Settlement Date VIM Cost Cost Value Market Price Book Value YTM (a Market Market Value Accrued Interest % Portfolio Credit Rating Days To Cal Maturity Uwe. Gakn1LOss Credit Rating Duration To Maturity Texas Class LGIP TX -01.0615-0010 4.452.058.66 8)11)2020 0.04 4,452,958.66 4,452,956.66 100.09 0.04 4,452,958.66 1.25% 0.04 None None TexSTAR LGIP 02000.20190 1,413,376.02 9119/2019 1,413,376.02 0.01 1,413,376.02 100.0D 1,413,376.92 0.(11 0.4% 0110 None None TexSTAR LGIP 02004-20191 912712419 510,131.26 100.00 510,131.26 510.131.26 0.01 510.131,26 0.01 0.14 % None 0.00 None 0 TexSTAR LGIP 02000-20191 9/2712019 491,808.71 491,606.71 0.01 144.00 491,609.71 491,606.71 0.01 0.14% None 0.00 None 0 TexSTAR LGIP 02000-11110 1,665,864.19 8/26)2016 1, 665, 884.19 0.01 1,665,884.19 TexSTAR LGIP 02000-11110 1,176,062.87 8.26.2016 1,176,082.07 0.01 1,176,002.07 TexSTAR LGIP 42000-20192 4.024,55B.46 9/27)2019 4,024,556.16 0.01 4,024,558.46 Sub Total Local Government Investment Pool 131,107,331.46 0.04 131,107,331.46 131.107.331.46 100.00 1,665,884.19 0.01 100.00 1.176.082.67 0.01 144.40 4,024,550.46 4.01 131,107,331.46 0.04 6.47% S&P -AAA 1 0.00 None 0 0.33% S&P -AAA 1 0.40 None 0 1.13% None 1 0.00 None 0 96,7% 1 0.06 0 TOTAL PORTFOLIO 357,0$5,589.39 0.112 357.085.59.39 357.085.539.39 0.02 357,085,569.39 190.00% 1 Prepared by Shamaira Jagrup 13 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9130/20211 Description Face Amount I CUSIP Shares VIM . Cost Book Value YTM Market Settlement Date Cost Value Market Price Market Value Accrued Interest % Portfolio Credit Rating Days To CatllMaturity Unre. Gain!Loss Credit Rating Duration To Maturity 100: General Fund Texas Class LGIP TX -01.0615-0001 31,137,092.75 5/1512017 31,137,092.75 0.04 31.187.092.75 100.00 0.04 31,137,092.75 8.72% 0.06 None None 1 Wells Fargo Sweep Cash WFSWEEP -365,552.64 5{31)2006 -365,552.84 0.01 -365.552.94 100.00 -365.552.84 0.01 -0.1% 0.00 Nona None a Sub Total 100: General Fund 30,771,539.94 30.771.539.81 0.04 34,771,539.91 30.771.538.91 8,62% 0,04 0.00 1 0 200: Debt Services Texas Class LGIP TX -01.0615.0001 3,651,715.88 1/15/2017 3,651,715.86 0.04 3,651,715.36 100.40 3,651,715.88 1,02% Nona 0.64 0.00 None 1 a Wells Fargo Sweep Cash WFSWEE' Sub Total 200: Debt Services 2,359,042.17 6,010,758.45 5/31/2006 2,359,042.17 0.01 2,359,042.17 100.00 2,359,042.17 0.66% None 0.01 0.00 None 1 0 0.03 6,010,766.05 6,010,756.05 0.03 6,010,758.06 1.60% 1 0.00 0 305: Hotel/Motti Occupancy Texas Class LGIP TX -01-061-0001 4,146.028.9$ 5115/2017 4.146.026.96 0.04 4,146,025.95 100.00 4.146,025.96 1.16% None 0.04 0.00 None 0 Walla Fargo Sweep Cash WFSWEEP 1,439,675.72 5x3112806 1,439,675.72 0.01 1,439,875.72 100.00 1,439,675.72 0.4% None 0.01 0,)0 Nona 1 a Sub Total 305: Hold/Motel Occupancy 314: Municipal Court Security Walls Fargo Sweep Cash WFSWEEP Sub Total 310: Municipal Court Security 5,585,702.70 48.975.21 48.975.21 0.04 5,585,702.70 5,585,702.70 0-84 5,585,702.70 1.56% 1 O.80 0 5/3112006 48,975.21 100.00 48,975.21 0.01 48.975.21 0.01 0.01% None Nono 1 l 48,975.21 48,975.21 0.01 48,975-21 0.01 0.01% 0.06 a 315: City Wide Donation Prepared by Shamaira Jagrup 14 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9/30{2021 Description CUSIP Face Amount l Shares Settlement Date Cost Value YTM g Cost Book Value Market Price YTM ! Market Market Value Accrued Interest % Portfolio Credit Rating Days To CalllMaturity Uwe. Gain./Loss Credit Rating Duration To Maturity Wells Fargo Swear) Cash WFSWEEP 171,212.40 5/31)2006 0.01 171,212.40 171,21240 r00.0a 0.01 171,212.40 0.05% 0.00 ` or 1 n Sub Total 313: City Wide Donation 171,212.40 0.01 171,212.40 171,212.0 0.01 171,212.40 0.05% 0.00 1 0 320: Court Technology Wells Fargo Sweep Cash WFSWEEP 5/3112006 9,311.41 9.311.41 0.01 100.00 9,311.41 9,311.41 0.01 0% %orF 0.00 1 Nol:e o Sub Total 320; Court Technology 9,311.41 0,311.41 0.01 0,311.41 0.01 9,311.41 0% 1 0.00 0 330: Park DanalFons Wells Fargo Sweep Cash WFSWEEP 50'3112006 56,976.62 56.976.82 0.01 100.00 56,978.62 56,976.82 0.01 0.02% None 1 0.00 Nona a Sub Total 330: Park Donations 56,976.52 0.01 56.976.87 56,976.62 56,976.02 D.01 0.02% 1 0.00 0 331: Tree Trust Fund Wells Fargo Sweep Cash WFSWEEP 5f3112006 0 06 465.204.76 0.01 465,204.76 100.00 465,204.76 0.01 465,204.76 0.13% None 0.00 None 1 0 Sub Total 331: Tree Trust Fund 465,204.76 0.01 465.204.76 465,204.76 465,204.76 0.01 0.13% 1 0.00 0 332: Parks Financl Asstance Donations Wells Fargo Sweep Cash 10'15i2019 WFSWEEP 34.09 0.01 34.09 100.00 34.09 0.01 34.09 0% Nene 1 0.90 None 0 Sub Total 332: Parks Financl Asstance Donations 34.09 0.01 34.09 34.09 34.09 0.01 0% 1 0.00 0 335: Police State Seizure Wells Fargo Sweep Gash WFSWEEP 103,153.92 5.'3112006 103.T53.92' 0.01 103,153.92 100.00 103.153.92 0.03% None 1 0.01 0.00 Nang 0 Prepared by Shamaira Jagrup 15 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland L)..c: -,. i::ica• Description Face Amount CUSIP Shares VIM O1. Cost Book Value YTM:! Market Settlement Date Cost Value Market Price Market Value Accrued Interest % Portfolio Credit Rating Days To CalllMaturity Unre. Gain/Leas Creditfiat)n¢ Duration 7o Maturity Sub Total 335: Policu State Seizure 103,153.92 0.01 103,153.92 103.153,92 0.01 103,153.92 0,66 1 d 336: Federal Police Fund Wells Fargo Sweep Cash WFSWEEP 6/3112406 166,993.57 ?00.00 166.993.57 166.993.67 0.01 166.993.87 0.01 Q.05% None 0.00 None 0 Sub Total 336: Federal Police Fund 166.903.57 0.01 106,003.67 166.003.87 0.01 166.993-87 0.05% 0.00 1 0 340: Park & Rec Development W alla Fargo S'e'eep C:ash WFSWEEP 5+s 1 r2oDrs 1,002.211-95 0.01 1,002,211.95 1,002,211.95 t00.DD 0.01 1,002,211.05 0.28% None 1 0.00 None 0 Sub Total 346: Paris 8 Rac Development 1,002,211.95 0.01 1,002,211.95 1,002,211.95 0.01 1.002.211.95 0.28% 1 0.00 0 345: Sidewalk Fund Walla Fargo Se'eep Crash WFSWEEP 5.'3112005 46.634.72 0.01 46,534.72 100.00 46,634.72 D-01 46.634.72 0.01% None 1 0.00 None 0 Sub Total 345: Sidewalk Fund 46,634.72 0.01 46,634.72 46,634.72 46,634.72 0.01 0.01% 1 0.00 0 350: Grant Fund W ens Fargo Sweep Cash 5/3112000 -483.857.65 WFSWEEP -483.687.65 0.01 -483.867-35 1[]0.00 -483.867.65 -0.14% None 1 0.01 O.OD None 0 Sub Totaf 350: Grant Fund -483.867.65 -483.867.65 0.01 -483,867.65 6.01 •483-867.65 0.90 0 351: CDBG Fund Wells Fargo Sweep Cash WFSWEEP 11/15/2015 - 281,099.78 0.01 - 281,099.78 - 281.099.78 100.00-28103am 0.01 -0.08% None 1 0.00 Nona 0 Sub Totai 351: CDBG Fund - 281.099.76 0.01 -281,099.76 - 281.099.76 0.01 •281-099.78 -0.08% 0.90 1 0 352: CDBG - Disaster Recovery Fund Prepared by Shamaira Jagrup 16 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9/3042021 Description CUSIP Face Amount Shares Settlement Date Cost Value YTM . Cost Bo-ok V.jlue Market Price YTM Market Market Value Accrued Interest % Portfolio Credit Rating Days To Cal Maturity Univ. GainfLoss Credit Rating Duration To Maturity Wells Fargo Sweap Cash WFSWEEP 40,671.79 11 ,11512020 0.01 - 40,671.79 -40,671.79 T00.00 0.01 -40,671.79 . 0.01% 0,00 Or Sub Total 352- CDSi - Disaster Recovery Fund -40.071.79 0.01 - 40,071.79 -40,071.79 0.01 -00,071.79 - 0.017 0.00 0 353: Disaster Recovery Fund W ells Fargo Sweep Cash W FSVIEEP -448.150.35 9.'15/2020 -448.150.35 0.01 445,150.35 100.00 448.150.35 0.01 - 0.18% Nana 1 0.00 None 4 Sub Total 353: Disaster Recovery Fund -440,150.35 0.01 -440,150-35 -440,150.35 0.01 -440.1$0.35 4.13% 1 0.110 0 354: Hazard Mitigation Fund s -argo Sweep Cash 11.152024 -58.444 77 100.00 -58.444.77 -0.02% None 1 '".'F 5'NFFP - 58.444.77 0.01 - 58.444 77 0 01 0.00 None 0 Sub Total 354: Hazard Mitigation Fund - 50,444.77 0.01 - 58,444.77 -58,4+4.77 •58,444.77 0.01 - 0.02% 0.00 0 555: Coronavirus Relief Fund miff Wells Fargo Sweep Cash WFSWEEP -2,911.069.95 5/15/202D -2,971-069.96 0.1)1 -2,971,069,95 100.06 -2,971-069.96 401 -0.53% None 0.00 Nape 0 Sub Total 355: Curonavirus Relief Fund .2,971.069.96 0.01 -2,971,069.96 -2,971.069.96 0.01 -2,971,069.96 0.00 0 358: ARPA Fund W eirs Fargo Sweep Cash WFSWEEP Sub Total 355: ARPA Fund 3.x}•1.1 135 50 3.944-465.50 5/15/2021 3,944,485.50 0.01 3,944,455,50 100 40 3,944,485.50 1.1% None 0.01 0.00 Norte 1 0 0.01 9,044,405.90 3,944-485.50 0.01 3,944,405.50 0.00 0 360: Traffic Impact Improvement W ells Fargo Sheep Cash 5r3tr2446 617.992 95 100 44 617.992 95 0.17% None 1 W FSWEEP 6179925 0.01 617.992.95 0.01 0.00 None 0 Prepared by Shamaira Jagrup 17 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9130/2021 Description CUSIP Face Amount Shares Settlement Date VIM Cost Cost Value Book Value Market Price YTM a Market Market Value Accrued Interest % Portfolio Credit Rating Days To Cal Maturity Urine. Gain/Less Credit Rating Duration To Maturity Sub Total 360: Traffic Impact Improvement 017,992.96 0.01 617,992.95 817,992.95 0.91 617,992.85 U.17°I 6.66 0 ;65: Court Juvenile Mgmt Wells Far Sweep Cash WFSWEEP 4.237.49 9/15/2009 0.01 4,231.40 4,237.49 100.00 D.01 4,237.49 0% 0.06 Norse None 0 Sub Total 365: Court Juvenile Mgrnt 4,237.49 0.01 4,237.44 4,237.49 0.01 4,237.49 0% 0.00 0 368: Municipal Jury Fund Wells Fargo Sweep Cash W FSWEEP 951.22 111.5.202D D 01 951.22 951.22 100.00 0.01 951.22 0% 0.10 None None 0 Sub Total 366: Municipal Jury Fund 951.22 0.01 95132 951.22 9.01 951.22 0% 0.00 0 370: Municipal Channel Texas Clas-s LGIF TX -01-0615-0001 306.418.84 5/1512017 0.04 388,416.8.4 306.416.84 100-00 0.04 355.415.64 0.11% 0.00 None Nona 0 Wells Fargo Sweep Cash W FSWEEP 463.424.30 4/15)2012 0.01 463.424.30 463,424.30 100.00 0.01 463,424.30 0.13% 4.00 NOne None a Sub Total 370: Municipal Channel 849,841.14 0.03 849,041.14 849,841.14 0.83 849,841.14 0.24% 0.00 1 0 380: Regional Detention Wells Fargo Sweep Cash WFSWEEP 1.000.01 5/31,2006 0.01 1,000.01 1.000.01 100.00 0.01 1,000.01 0% 0.00 None None 0 Sub Total 360: Regional Detention 1,080.01 0.01 1,080.01 1,000.01 0.01 1,000.91 0% 0.801 1 0 500: Capital Projects Texas Glass LGIP 7X•01/0615-0001 567,452.5E 1/15.'2017 0.04 567,452.56 567,452.56 100.00 0.04 567.452.56 0.16% 0.00 NOM. None a Prepared by Shamaira Jagrup 18 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 913072021 Description Face Amount? GUStP Shares YTM' Cost Settlement Date Coat Value Market Price Book Value Y1M tie; Market Market Value Accrued Interest % Portfolio Credit Rating Urine. Gain'Loss Credit Rating Days To Cal Maturity Duration To Maturity Wells i-argo Cash WF3025 274,860.14 8/12)2020 0.00 274,860.14 274,860.14 100.00 0.90 274,860.14 0.08% 0.00 None None 1 ii Wells Fargo Sweep Cash WFSWEEP 5uh Total 500: Capital Projects 2,435.344.56 3,277,85718 5{3172006 2,435,344.56 0.01 2,435,344.56 100.00 2,435,344.56 0.01 4.68% 0.00 Nona None 0 0.02 3,277,657.26 3,277,857.28 3,277,657.25 0.92% 0.02 0.00 0 501: Certificates of Obligation Texas Class LGIP TX -01-O615-0001 12/20.02016 6.627.11 0.04 6.627.11 100.00 6.627.11 0.04 6.627.11 0% Nona 1 0.90 None 0 Texas Class LGIP TX -01-O615-0007 567.389.52 911920113 567.360.52 0.44 567.389-52 104.00 567,389.52 0.16% None 1 0.04 0.00 NOW 0 Texp5 CIBss I -GIP TX -0141515-0005 237,02525 901522015 0.04 237,425-25 100.00 237.025-25 0.07% None 1 237,026.26 0.04 0.00 NO114 0 TexSTAR LGIP 02000.20191 9/2772019 510,13126 100.00 510,13126 0.14% Nene 1 510,131.26 0.01 510,131.26 0.01 0.00 None 0 TexSTAR LGIP 02000-11110 1,176,082.87 8/2602016 1,176,082.87 100.44 1.176.082.67 0.32% .S$P-AAA 1 0.01 1,176,082.87 0.01 0.00 None 0 TexSTAR LGIP 02000-20192 4,024,558-46 912712019 4,024.55846 100.00 4,024,558.46 1.13% None 1 0.01 4,024,558.46 0.01 0.40 NOrwe 0 Wells Fargo Sweep Cash WFSWEEP 5,946,700.90 5/31120O6 5,945,700.90 0.01 5,946,700.90 100.00 5,946,700.90 1.67% 0.01 0.00 NOW 1 None 0 Sub Total' 501: Certificates of Obligation 12,468,515.37 0111 12,468,515.37 12,468,615.37 12,468,515.37 3.5% 1 0.01 0.09 503: Certificates of Obligation 2006 4h'allu Cargo S•n't:Lp Cast' VVcS',WWEEP 613012006 39.274.82 4.01 39,274.82 100.00 39,274.82 0.01 39,274.82 0.01% 0.00 None 1 None 0 Prepared by Shamake Jageup 19 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Data: 9130/2021 Description Face Amount GUSIP Shares VIM Cost Boo*. Value YTM O Market Settlement Date Cost Value Market Price Market Value Accrued Interest % Portfolio Credit Rating Days To Cal Maturity Univ. Gain/Lost. Credit Rating Duration To Maturity Sub Total 503: Certificates of Obligation 2006 39,274.82 0.01 39,274.82 39,274.82 0.01 39,274.82 0.01% 0.00 1 d 506: General Obligation Texas Glass LGIP TX.01.6615.0001 2,020,196.31 1212012016 2,020,196.31 0.04 2,020,196.31 100.00 2.020.196.31 0.57% NOng 0.04 0.00 None 1 Texas Class LGIP TX -01-1615-0005 TexSTAR LGIP 02000-20190 2,648,035.67 1,413,275.02 9115120/8 2,648,035.67 0.04 2,648,035.67 100.00 2,648,035.67 0.44 0.74% None 0.60 None Li 911912019 1,413,376.02 100.00 1,413,378.02 0.4% None 1 0.01 1,413,378.02 0.01 0.00 None it TaxSTAR LGIP 02000-20191 491.606.71 9/2712019 491,606.71 0.01 491.606.71 100.00 491,606.71 0.01 0.14% None 1 0.00 None a Tax5TAR LGIP 02000-11110 1,665,884.19 8,26,2016 1,665,884.19 0.01 1,665,684.19 Wells Fargo Sweep Gash WFSWEEP 4,364,193.20 10+30,2046 4,364,193.20 0.01 4,364,193.20 Sub Total 566: General Obligation 12,603,294.30 0.02 12,803,294.34 100.00 1,665,884.19 0.01 100.04 4,364.193,20 041 12.503.204.30 12,603,284.34 0.02 0.47% S&P -AAA 1 0.80 None 0 1.22% 0.00 None None 1 0 3.5e4 1 0.00 507: General Obligation Series 2020 Texas Class LGIP TX -01-0615-0006 Wells Fargo Swoop Cash WFSWEEP a.t393.014.54 1,069,478.80 8,112024 0.04 8,693,414.54 8,683,014.54 '00 IX) 8,693.014 54 2.43% None 0.04 0.00 None 1 0 10/15.02019 1.069.478.80 0.01 1,069,476.80 100.00 0.01 Sub Total 547; General Obligation Series 2020 9,762,493.34 0.04 9,762,483.34 9,762,493.34 0.04 1,069,475.5d 9,782,493.34 4.3% None 1 0.00 Nona a 2.73% 1 0.90 0 508' Certificates of ()big Series 2020 Prepared by Shamaira Jagnip 20 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9/30/2021 Description Face Amount CUSIP Shares VIM •,u7 Cost Book Value YTM :U Market Settlement Date Cost Value Market Price Market Value Accrued Interest % Portfolio Credit Rating Days To CatllMaturity Uwe. Delft/Loss Credit Rating Duration To Maturity Texas Class LGIP TX -01.0615-0009 1,758,482.63 8/11)2020 0.04 1,758,482.63 1,758,482.63 100.00 0.04 1,758,482.63 O.d9 K 0.00 None Nose 1 Wells Fargo Sweep Cash WFSWEEF 2,310,772.29 10/15)2019 2,310,772.29 0.01 2,319,772.29 100.00 2.319.772.29 0.01 8.85% 0.00 Noss None Sub Total 509- Certificates otObig Series 2020 4,078,254.92 6.112 4,078,254.92 4,078,254.92 6.02 4,070,254.92 1.14% 6.60 1 0 509; General Obligation Series 2021 Texas Class LGIP TX -01-6615-0015 W sIls Fargo Sweep Oath W FSWEEP g,016,056.D9 865,561.19 8/1512021 9,018,058.09 0.04 9,018,058.09 104.00 D.D4 10/1512019 895,561.19 0.01 865,561.19 100.00 0.01 Sub Total 509: General Obligation Series 2021 9,881,617.26 0.04 9,881,617.28 9,881,817.28 0.04 0.016.050.09 865,561.19 9,881.617.28 2.52% None 1 0.00 None 0 0.24% None 1 0.00 Nose 0 2.765E 1 0.00 0 512: Certificates of 0618 Series 2021 Texas Class LGIP TX -01-0615-0012 8,551,387.83 8/15/2021 8,551.387, 63 0.04 8,551,387.63 Wells Fargo Sweep Cash W FSWEEP -11,413.880.42 2.'15/2020 -11,413,68042 0.01 -11,413.880.42 100,00 8.551.387.63 0.04 100_00 -11,413,650.42 0.01 2.39% 0.40 -3.2% 0.00 None None None N0n9 1 0 1 0 Sub Total 512: Certificates of Obig Series 2021 -2,802,292.59 .2,862,292.59 -0.09 .2,862.292.59 -0.09 -2,862,292.59 0.00 0 513: General Obligation Series 2022 Wells Fargo Sweep Cash WFSWEEF 10/1.'2020 -37,171.00 -37.171.00 0.01 100.06 -37.171.00 -37,171.00 0.01 -0.01% Nose 1 0.00 Nose 0 Sub Tetei 513: General Obligation Series 2022 -37,171.816 4.01 -37.171.00 -37.171.00 -37,171.00 4.01 0.60 0 514; Infrastructure Reinvestment Fund Prepared by Sharnaira Jagrup 21 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9130/2021 Description Face Amount? CUM,. Shares VIM ,u7 Cost Bo-oValue VIM O Market Settlement Date Cost Value Market Price Market Value Accrued Interest % Portfolio Credit Rating Days To CaillMaturfty Unra. Gain/Loss Credit Rating Duration To Maturity 'rVelis i-argo Sweep Cash WFSWEEP 1,428,385.10 1 2/1 512 01 9 0.01 1.428.385.10 1,428,385.10 100.00 0.01 1.428.385_tfl 0.00 1 Sub Total 51k Infrastructure Reinvestment Fund 1,428,305.10 0.01 1,428,385.10 1,428,365.10 0.01 1,428,365.10 0.4% 0.00 1 0 515: Certificates of Oblig 2020 TERP Texas Class LGIP Tx -01-1615-0010 4,452,956.66 8/1112020 4,452,956.66 0.04 4,452,956.66 100.00 4,452,958.66 1.25% None 0.04 0.00 Norte 1 Wells Fargo Sweep Cash WFSWEEP 0/15/2020 525,199-23 100.00 525,199.23 0.15% Norte 1 525,190.23 0.01 525,199.23 0.01 0.00 None 0 Sub Total 515: Certificates of Oblig 2020 TIRZ 4,978,157.69 0.04 4,978,157.89 4,978,157.60 0.04 4,970,157.64 1.4% 1 0.00 0 516: Certificates of Oblig 2021 TIR2 Texas Class LGIP TX•01.0615.0013 11.473.293.26 8/1512021 11,473_293.26 0.04 11,473,293.26 Welts Fargo Sweep Gash WFSWEEF 565,070.39 10/112020 0.01 565.070 39 565,070.39 Sub Total 516: Certificates of Oblig 2021 TI RZ 12,030,363.05 0.04 12,038,303_05 12,038,363.65 100.00 11,473,293.26 0.04 100,00 565.070.39 0.01 12,038,363-05 0.04 3.21% None 1 0 00 None 0 0.16% None 1 0.06 None 0 3,37% 0.00 0 517: Certificates of Obligation 2022 Wells Faro Sweep Cash WFSWEEP -2,540,555.91 10i112020 -2.640.555.91 0.01 -2,640.555.91 100.00 -2,640,555.91 -0.74% None 1 0.01 0.00 None 0 Sub Total 517: Certificates of Obligation 2022 -2.540.555.91 .2,640.555.91 0.01 -2.640,555.91 0.01 -2,040,555.91 0.00 0 510 Certificates of Oblig 2022 TERI, Wells Fargo Sweep Cash WFSWEEF -2,371,597,39 10/1/2020 .2,371,597.49 0.01 -2,371,597.69 100.00 .2,371.597.69 -5.60% None 1 0.01 0.00 None 0 Prepared by Shamaira Jagrup 22 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 913012021 Description Face Amount CUStP Shares YTM @ Cost Settlement Date Coat VaIue Market Price Market Value Bo-ok Value YTM r�-il Market Accrued Interest % Portfolio Credit Rating Days To Cal Maturity Univ. Galn!Loss Credit Rating Duration To Maturity Sub Total 516: CerlMews of Obiig 2022 TIRL •2,371.597.88 0.01 -2,971,597.89 -2,371,507.09 0.01 -2.371,597.69 -0.55°1 0.00 1 d 550: VATS Impact Fee Texas Class LG1P TX•01r0615.000i 12,2012016 61.51 0.04 61.51 100.00 61.51 0.04 6T.51 0% None 0.04 None 1 0 Texas Class LGIF TX -01-1615-0007 Wells Fargo Sweep Cash WFSWEEP Walls Fargo TWD9 Cash WF4094 Wells Fargo TWDB Cash WF6624 Wells Fargo TWDB Cash WF310O W9IIs Fargo TWrR Cash WF2647 802.169.83 10,104,920.81 81,765.43 911912019 802.169.83 100.00 802.169,83 0.22% None 0.04 802,169.83 0.44 1 0.00 None 0 5/311200e 10,184,92$.81 100.00 10,184,926.61 2.85% None 1 0.01 10,184,926.81 4.01 0.00 None 0 111112016 81,785.43 100.00 81,765.43 0.02% None 1 0.01 81.765.43 0.04 0.00 None 0 2,631,596.98 5/15/2016 2.631.598.98 0.01 2,631,596.98 100.00 2.631,598.96 0.01 0.74% None 1 0.00 None 0 3,759,605.44 41112021 3,759,805.44 0.01 3,759,805.44 100.00 3,759.805,44 0.41 1.05% 0.00 None None 1 0 6,051,359.74 81812019 6,051.359.74 0.01 6,051,359.74 100.00 6.051.369.7.4 0.01 1.69% 0.00 None None 1 d Wells Fargo TWDB Cash WF4102 Wells Fargo TWDB Cash WF5883 Sub Total 550: W,S impact Fee 904,789.86 2,408.477,41 28,824,975.03 11/112016 904.789.86 100.00 904.789.88 0.25% None 1 0-01 904,789.88 0.01 0.00 None 0 311 5)2 017 2,408.477.41 0.01 2,408,477.41 100.00 2,408,477.41 0.67% Nona 1 0.01 0.00 None 0 0.01 26,024,975.03 25,824,975.03 0.01 26,624,975.43 T.48% 0.110 1 0 551: Water impact Fee Fund Wells Fargo Sweep Cash WFSWEER 3,734,319.43 1/15/2020 3,734,319.43 0.01 3,734,319.43 100.00 3,734.319.43 1.05% None 1 0.01 0.00 None 0 Prepared by Shemaira Jagrup 23 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9/30!2021 Description Face Amount CUSIP Shares VIM 7! Cost Book Value YIN ` Market Settlement Date Cost Value Market Price Market Value Accrued Interest % Portfolio Credit Rating Days To CatllMaturity Univ. GainfLoss Credit Rating Duration To Maturity Sub Total 551: Water Impact Fee Fund 3,734,310.43 0.01 9,734,319.43 3,734,319.43 0.01 3,734,319.43 1.95' 0.66 1 d 552: Waste Water Impact Fee Fund Wells Fargo Sweep Gash WFSWEEP 3,056,885.15 111512020 3,056,885.15 100.00 3.055.665.15 0.86% ',ore 0.01 3,056.665.15 0.01 0.06 \oi'r l Sub Total 552: Waste Water Impact Fee Fund 3,036,665.15 0.01 9,056,605.16 3.050.005.15 0.01 3,056,605.15 0.869E 0.00 0 555: Shadow Greek Impact Walls Fargo Sweep Cash WFSWEEP 6/31/2006 -0.02 • 0.02 0111 100.00 -0.02 • 0.02 0.01 0% None 0.00 None Sub Total 555: Shadow Creek Impact - 0.02 0,01 -0.02 -0.02 - 0.02 O.Ut 0% 1 0,00 4 565: Revenue Bonds 1999 & 2003 Texas Glass LGIP TX•01-0615.0001 Texas Class LGIF TK-01-0615-0047 Texas Class LGIP TX -01-0615-0004 5.006.544.16 3.340.34 7,099.60 1/1512017 5.006.544.16 100.00 5,006,544.16 1,4% Nona 1 0.14 5,006,544.16 0.04 0-40 None 0 9.1912019 3,300.34 0.04 3.344.34 100.06 3,300.34 0% None 1 0.44 0.00 None 0 9/15/2016 7,099.60 100.00 0.44 7,099.50 0.14 1.099.59 0% None 1 0.00 Norse 0 Wells Fargo Sweep Cash WFSWEEP 3.430.030.50 513112006 3,430,030.50 0.01 3.430.030.50 100.00 3,430,030.50 0.01 0.96% None 0.00 1 None 0 Wells Fargo TINDB Cash WF58T5 Sub Total 585: Revenue Bonds 1999 8 2003 922.293.62 9,369,260.42 9'1512017 922,293.62 100.00 0.01 922.293.62 0.01 922,293.62 0.26% Nona 1 0.00 None 0 0.03 9,369,208.42 9,369,260.42 0.13 9,369,268.42 2.62% 0.00 1 0 566: Revenue Bonds Series 2020 prepared by Shamaira Jagrup 24 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9130/2021 Description Face Amount CUSIP Shares. VIM •,u7 Cost Book Value YTM :U Market Settlement Date Cost Value Market Price Market Value Accrued Interest % Portfolio Credit Rating Days To CatUMaturity Univ. Gainless Credit Rating Duration To Maturity Texas Class LGIP TX -01.0615.0011 2,887,279.49 8/1112020 0.04 2.887.279.49 2,887,279.49 100.00 0.04 2,887,279-49 0.81% 0.40 �,orF None 1 Wells Fargo Sweep Cash WFSWEEP 10/15)2019 906.608.00 906.608.00 D-01 100.00 906.606.00 906,608.00 0.01 0.25% 0.00 None None Sub Total 885: Revenue Bonds Series 2020 3,795,867.49 DIM 3,793,007.49 3,793,087.49 0.04 3,793,807.49 1.06% 0.110 1 0 567; Water Drinking Bonds Series 2020 Wells Farm S•n'ej:. C 9.1- WFSWEE Wells Fargo T'nr'ue WF6100 -13,314,914.76 10.'15/2019 -13,314.914.75 0,01 -13,314,914.76 100-40 -13,314,914.76 0.01 -3.73% None 1 0.00 None 0 105,503,295.04 6/1612020 105,503,295-04 0.01 105,503.295304 100.00 105,503,295.04 0.01 29.55% 0 09 None 1 Nona fl Svb Total 56T; Water Prinking Bonds Series 2020 92,188,380.28 6.01 92,188,380.26 92.188.300.20 92,188,380.28 0.01 25.82% 1 0.00 568: Revenue Bonds Series 2021 Texas Class LGIP TX -01-0615-0014 7,336,875.89 8+152021 0.04 7,336.876 69 7,336,876.89 100.00 7,336,876.69 2.06% None 0.04 0.00 None 0 Wells Fargo Sweep Cash WFSWEEP 775.108.12 10.15/2019 775,108-12 100.00 775.106.12 0.22% None 0.01 775,106.12 0.01 0.00 Nona 0 Sub Total 568: Revenue Bonds Series 2021 8,111,903.01 8,111,983.01 0.04 8,111,983.01 0.04 8,111,983.01 2.27% 0.00 0 569: Revenue Bonds Series 2022 Wells Fargo Sweep Cash WFSWEEP 10,239-814.92 10/15/2019 -10,239.814.92 0.01 -10,239.814.92 100.00 •10,239.814.92 -2,87% Nona 0.01 0.00 None 0 Sub Total 589- Ixevenue Bonds Series 2022 -10,239.814.92 0.01 -10,239,814.92 -10,239,814.92 0.01 -10,239,814.92 -2.87% 0.90 1 0 570; MS Pay As You Go Prepared by Shamaira Jagrup 25 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9130/2021 Description Face Amount I CUSIP Shares VIM ,u7 Cost Book Value VIM 4 Market Settlement Date Cost Value Market Price Market Value Accrued Interest % Portfolio Credit Rating Days To CatllMaturity Univ. Gain/Loss Credit Rating Duration To Maturity Texas Class LGIP TX -01.06155-0001 6,011,690.28 6/1512020 0.04 6.011.690.26 6,011,690.26 100.00 0.04 6.011,69020 1.68 K 0.00 None 1 Wells Fargo Sweep Cash WFSWEEP 3.438.151.90 12/'31)2007 3,438,151.90 6.01 3,438,151.90 100.00 3.438.151.90 0.91 0.96% 0.00 None None Sub Total 570: W+S Pay As You Go 9,448,042.18 0,449,042.10 6.0S 9,449,842.18 0.03 9,448,042.15 2.64% 1 0 571: TWDB Revenue Bonds Series Z021 Wells Fargo Sweep Cash WFSWEEP -3,750.707.45 10+1/2020 .3,750.707.45 0.01 -3,750,707.45 100.00 .3,750.707.45 -1.05% Nona 0.01 0.00 None a Wells Fargo TWDB Cash WF310e 69,952,397,33 4/1/2021 09, 952, 397.33 0 01 69,952,397.33 100.00 69,952,397.33 19.59% None 0.01 0.00 None 1 0 Sub Total 571: TWDB Revenue Bonds Series 2021 66,201,689.80 0.01 86,201,889.80 66,201,669.85 0.01 86,201,889.80 10.54% 1 0.00 0 575: MUD 4 Capital Programs Wells Fargo Sweep Cash WFS'NEEP 2/112013 25.659.29 0.01 25,659.29 100.00 25.659.29 0.01 25,659.29 0.01% None 0.00 None 0 Sub Total 575, MUD 4 Capital Programs 25,65929 0.91 25,659.29 25,65929 25,659.29 4.01 0.01% 1 0.0d 0 600: Water & Sewer Texas Class LGIP TX -01-061`x0001 5.452.475.14 1212012016 5,452,475.14 0.94 5.452.475.14 100.00 5,452,475.14 0.04 1.53% None 1 0.00 None 0 Wells Fargo Sweep Cash WFSWEEP Sub Total 500: Water & Sewer 3.418.479 34 8.870.554.40 5/31/2006 3,418,079.34 0.01 3,418,079.34 100.00 3,418,079.34 0.96% Nona 1 0.01 0.00 None 0 8.870.554.48 0.02 9,870,554.48 D.D3 8,870,554.48 2.49% 0.00 1 0 601: Water & Sewer Debt Fund prepared by Shamaira Jagrup 26 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9/30!2021 Description Face Amount 1 CUSIP Shares VIM ,c! Cosi Book Value VIM :U[ Market Settlement Date Cost Value Market Price Market Value Accrued Interest % Portfolio Credit Rating Days To Ceti/Maturity Urine. Gain/Loss Credit Rating Duration To Maturity Tgxas Class LGIP TX -01.46155-0001 5,005,020.61 12/1512020 0.04 5.005.020.61 5,005,020.61 100.00 0.04 5,005,020.51 1.4`.k 0.40 ,ore None 1 Wells Fargo Sweep Cash W FSWEEP 13.529.586.09 10/1512020 13,529,586.09 0.01 13,529.586.09 100.00 13.529.586.09 0.01 3.79% 0.00 None None Sub Total 601: Water $ .sewer Debt Fund 18,534,606.7D 1.112 19,534,606.70 18,534,1106.70 18,534,806.70 5.19% 0.02 DAM 1 0 610: Solt waste Wells Fargo Sweep Cash W FSWEEP 12+1/2006 321,844.10 32', 644 1D 0.01 100.00 321,844.10 321.844.10 0.01 0.09% None 0.00 None u Sub Total 610: Solidwaste 321,941.11) 11.111 321.844.14 321,844.10 0.01 321.844.14 0,0936 1 aim a 700: Risk Management Fund Wells Fargo Cash WF1376 59.251.56 10115/2020 59,251.56 0.15 59.251.56 100.00 59.251.56 0.02% None 0.16 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 1,100,570.72 14/31/2008 1,100.570.12 0.41 1,100,570.72 100.1)0 1,100,570.72 0.31 % None D.01 0.00 None 1 0 Sub Total 700: Risk Management Fund 1,159,822.26 1,159,822.26 0,112 1,159,822.26 0.02 1,159,$22.28 0.33% 1 0.00 0 7131: Employee Benefit Fund Wells Fargo Sweep Gash W FSWEEP 198,300.06 9+1/2047 196.344.46 0.01 106,300.08 144.44 196.300.05 0.05% None 1 0.01 0.00 None 0 Sub Total 701: Empleye9 Benefit Fund 196.300.06 0.01 196,300.06 196,300.06 196.300.06 0.01 0.05% 1 0.00 0 702; Health Claims Fund W ells Fargo Cash WF9&71 7+21 /2010 609,$94.52 0.16 698,694.62 140.44 898,694.52 0.16 698.694.52 0.2% None 1 0.00 None 0 Prepared by Shemaira Jagrup 27 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9130/2021 Description Face. Arno out ' CUSIP Shares YTM :14! Cost Book Value YTM::il Market Accrued Interest Unrc. GainiLoss Credit Rating Duration To Maturity Settlement Date Cast VaIue Market Price Market Value % Portfolio Credit Rating Days To CallYMaturity ti4ells Fargo Swriap Cash WFSWEEP 2,923,903.79 9/1512010 0.01 2,923,903.79 2,923,903.79 100.00 0.01 2,923,903.79 0.82% 0.00 Nona" None. 1 0 Sub Total 702: Hcalth Claims Fund 3,622,598.31 0.04 3,022,596.31 3,622,508.31 0.04 3,022,506.31 1.02% 0.00 1 0 703: Motor Pool Fund WeIIa C=argo Swaap Cash WFSWEEP Sub Total 703; Motor Pool Fund 3,644,677.8E 3,644,677.56 10/1512016 3,644,677.66 0.01 3,644,677.8.E 100.08 3,544,677.66 1.02% None 0.01 0.00 Nona 0 0.01 3,644,677.06 3.644,677. $6 0.01 3.644.677.66 1.02% 0.00 0 TOTAL PORTFOLIO 357,085,589.38 0.02 357,005,509.39 357,085,589.39 0.02 357,005.56939 100.00% 1 0.00 Prepared by Shamaira Jagrup 28 City of Pearland Treasury Yield Curve -Treasury 6/3012021 7/31/2021 813112021 913012021 1 Month 3 Month 6 Month 1 Year 2 Year 3 Year 5 Year 10 Year 0-03 0.04 0-05 0-07 0-20 0.39 0-84 1-52 0.05 0.05 0-05 0-08 0.22 0.41 0.77 1-32 0.04 0.05 0.06 0.07 0.22 0.42 0.77 1,28 0-05 0.04 0-05 0-06 0.24 0.47 0.86 1.37 Note 1 Note 2 Prepared by Shamaira Jagrup 29 Pledged Collateral Reconciliation Report September 30, 2021 Bank Account Ending Account Name Wells Fargo 3395 Credit Card Account Wells Fargo 2841 Sweep Account Wells Fargo 5455 False Alarm Reduction Program Wells Fargo. 7843 Alvin ISD Wells Fargo 1790 EMS Payments Wells Fargo 9871 Health Claims Wells Fargo 4094 Escrow W&S Revenue Bonds, Series 2016E 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 86.24 Escrow W&S Revenue Bands, Series 201 BA Wells Fargo 2847 Escrow W&S Revenue Bonds, Series 2019A Wells Fargo 3025 Massey Oaks Easement Cost Escrow Wells Fargo 1378 Workers Compensation Claims Total of Bank Balances Pledged Collateral for City FDIC Insurance Amount 20,698.00 • 287,381.31 7,059,217.$5 598,694-52 274,860.14 5D,251_56 $ 8,4fl0,103.08 7,233,251,02 2,000, 000, 00 9,233,251.02 Over (Linder) Collateralized $ B33,147.94 Total % Collateralized 109,9% Bank Account Ending Account Name Wells Fargo 4258 Development Authority Total of Rank Balances Pledged Collateral for DAP FDIC Insurance Amount 11,883,787.84 S 11,883,787.84 12,458,261.39 250,000.00 $ 12,708,261.39 Over (Under) Collateralized $ 624,473.55 Total °f Collateralized 106.9°% Total : n Collateralized Status 108,2% Collateralized * Accounts are sweeping to a higher yielding money market fund which does not require collateral.