Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
R2020-228 2020-11-09
RESOLUTION NO. R2020-228 A Resolution of the City Council of the City of Pearland, Texas, accepting the City's Investment Report for the quarter ending September 2020. 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 2020. PASSED, APPROVED, AND ADOPTED this 9th day of November, A.D., 2020. ,zz:=30.77? TOM REID MAYOR AT d44444ttet44 444 QEAR1NO AL . R AN, TRMC, CMC ;°•O6: 44'',4„ x CITY SECRETARY i APPROVED AS TO FORM: A $\ ,J 1 / y 4 4'4tut4U4N444J ,S3 DARRIN M. COKER CITY ATTORNEY City of Pearland - Quarterly Investment Report litibnitbil June 30, 2020 to September 30, 2020 This report is prepared for the City of Pearland in accordance with Chapter 2256 of the Public Funds Investment Act (PFIA). Section2256.023 (a) of the PFIA states that "Not less than quarterly, the investment officer shall prepare and submit to the governing body of the entity a written report of the investment transactions for all funds covered by this chapter for the preceding reporting period." This report is signed by the Investment Officer and includes the disclosures required in the PFIA. Month Market Value Book Value Unrealized Gain/Loss YTM @ Cost Treasury 1 Year Interest Earned Days To Maturity 7/31/2020 309,090,029.90 309,014,753.99 75,275.91 0.30 0.15 50,853.50 17 8/31/2020 336,685,821.85 336,619,017.03 66,804.82 0.22 0.13 98,354.57 13 9/30/2020 329,722,567.21 329,665,723.33 56,843.88 0.16 0.13 48,687.21 12 Total/Average 325,166,139.65 325,099,831.45 66,308.20 0.23 0.14 197,895.28 14 Digitally signed by John Mccarter John Mccarter EN:cn-JohnMccarte`o-Gaof Pearland,o"-Finance, Digitally signed by Rhonda Daugherty Date:2jmccarter@pearlandt:.gov,c=US 1 0/20/2020 Rhonda Daugherty Date:�o2o.,0.20,4:04:06-05'00' Date: 2020.10.19 13:21:04-05'00' John McCarter, Interim Director of Finance Date Rhonda Daugherty, Assistant Director of Finance Date Digitally signed by Shamaira Shamaira Jagrup Jagrup Date:2020.10.16 12:27:57-05'00' 10/16/2020 Shamaira Jagrup, Treasury Manager Date • Note: This report reflects entries through Period 12 and does not include any year-end entries. ,�,' "''t. City of Pearland diiik IfflAbitiiii Distribution by Security Type - Book Value Report Group: Pearland Begin Date:6/30/2020, End Date:9/30/2020 Security Type Allocation Book Value %of Portfolio Book Value %of Portfolio Security Type 6/30/2020 6/30/2020 9/30/2020 9/30/2020 Cash 192,830,808.05 60.39 222,726,246.54 67.56 Certificate Of Deposit 5,704,000.00 1.79 4,464,000.00 1.35 Compound CD 20,275,803.76 6.35 8,118,282.83 2.46 FAMC Bond 1,000,000.00 0.31 1,000,000.00 0.30 FHLMC Bond 997,382.43 0.31 997,968.45 0.30 FNMA Bond 1,002,999.11 0.31 1,001,482.71 0.30 Local Government Investment Pool 97,485,771.37 30.53 91,357,742.80 27.71 Total/Average 319,296,764.72 100.00 329,665,723.33 100.00 Portfolio Holdings as of 6/30/2020 Portfolio Holdings as of 9/30/2020 el _ 1 • 60.39%-Cash 67.56%-Cash 6 Il 1.79%-Certificate Of.,. • 1.35%-Certificate Of... j • 6.35%-Compound CD • 2.46%-Compound CD • 0.31%-FAMC Bond • 0.3%-FAMC Bond • 0.31%-FHLMC Bond 0.3%-FHLMC Bond 0.31%-FNMA Bond 0.3%-FNMA Bond • 30.53%-Local Governm... i,1\ 410 • 27.71%-Local Governm,.. Prepared by Shamaira Jagrup 2 ,,, City of Pearland Bill Distribution by Maturity Range - Book Value 0,, ,''' Report Group: Pearland Begin Date:6/30/2020,End Date:9/30/2020 Maturity Range Allocation Book Value %of Portfolio Book Value %of Portfolio Maturity Range 6/30/2020 6/30/2020 9/30/2020 9/30/2020 0-1 Month 292,584,217.48 91.63 314,331,989.34 95.35 1-3 Months 10,673,613.46 3.34 2,249,482.71 0.68 3-6 Months 1,496,000.00 0.47 2,277,570.71 0.69 6-9 Months 3,270,637.17 1.02 3,021,570.71 0.92 9-12 Months 4,995,638.06 1.56 7,785,109.86 2.36 1-2 Years 6,276,658.55 1.97 0.00 0.00 Total/Average 319,296,764.72 100.00 329,665,723.33 100.00 Portfolio Holdings 350,000 300,000 250,000 c 43 200,000 !o : • 6/30/2020 o F 150,000 I IR 9/30/2020j c �' 100,000 50,000 00 0-1 M 1-3 M 3-6 M 6-9 M 9-12 M 1-2 Y Prepared by Shamaira Jagrup 3 '',• I' City of Pearland e liggiatiii Total Rate of Return - Book Value by Month 03, ,.`, Report Group: Pearland Begin Date: 10/31/2019, End Date:9/30/2020 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 10/31/2019 231,853,468.53 376,327.12 0.00 376,327.12 237,221,420.08 0.16 1.92 1.61 11/30/2019 229,649,559.76 328,809.89 4,500.12 333,310.01 228,812,115.02 0.15 1.76 1.57 12/31/2019 228,220,514.83 419,707.34 0.00 419,707.34 246,753,579.54 0.17 2.06 1.55 1/31/2020 263,407,020.72 293,973.37 0.00 293,973.37 269,246,435.45 0.11 1.32 1.53 2/29/2020 274,598,735.67 351,220.18 0.00 351,220.18 262,286,149.87 0.13 1.62 1.41 3/31/2020 249,222,464.34 228,240.21 0.00 228,240.21 242,677,293.99 0.09 1.13 0.33 4/30/2020 241,252,953.38 113,004.70 0.00 113,004.70 234,884,571.80 0.05 0.58 0.19 5/31/2020 229,507,887.25 98,497.70 0.00 98,497.70 220,924,543.66 0.04 0.54 0.16 6/30/2020 217,011,477.71 75,199.58 0.00 75,199.58 268,423,806.19 0.03 0.34 0.18 7/31/2020 319,406,511.29 50,853.50 0.00 50,853.50 313,168,390.32 0.02 0.20 0.15 8/31/2020 309,052,464.29 98,354.57 0.00 98,354.57 328,643,970.49 0.03 0.36 0.13 9/30/2020 336,679,139.01 48,687.21 0.00 48,687.21 331,051,108.58 0.01 0.18 0.13 Total/Average 231,853,468.53 2,482,875.37 4,500.12 2,487,375.49 264,185,893.30 0.94 0.94 0.75 i Annualized TRR-BV 2.50 - 2.00 1.50 I 7-_, ._. ,, •Portfolio 1.00 i Treasury 1 Year; 0.50 0.00 ■ I El 0. Ell NM00 10/2019 11/2019 12/2019 01/2020 02/2020 03/2020 04/2020 05/2020 06/2020 07/2020 08/2020 09/2020 Prepared by Shamaira Jagrup 4 .. '+°f, City of Pearland a Portfolio Holdings by Security Type ``t Report Group: Pearland Date:9/30/2020 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount I CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Cash Wells Fargo Cash 8/12/2020 1,000,000.00 100.00 1,000,000.00 0.3% None 1 WF3025 1,000,000.00 0.00 1,000,000.00 0.00 0.00 None 0 Wells Fargo Cash 7/21/2010 392,469.45 100.00 392,469.45 0.12% None 1 WF9871 392,469.45 0.16 392,469.45 0.16 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 990,434.21 100.00 990,434.21 0.3% None 1 WFSWEEP 990,434.21 • 0.01 990,434.21 0.01 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 1,166,338.30 100.00 1,166,338.30 0.35% None 1 WFSWEEP 1,166,338.30 0.01 1,166,338.30 0.01 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 57,834.87 100.00 57,834.87 0.02% None 1 WFSWEEP 57,834.87 0.01 57,834.87 0.01 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 8,384.02 100.00 8,384.02 0% None 1 WFSWEEP 8,384.02 0.01 8,384.02 0.01 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 18,408,553.89 100.00 18,408,553.89 5.58% None 1 WFSWEEP 18,408,553.89 0.01 18,408,553.89 0.01 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 997,275.61 100.00 997,275.61 0.3% None 1 WFSWEEP 997,275.61 0.01 997,275.61 0.01 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 3,743,127.28 100.00 3,743,127.28 1.14% None 1 WFSWEEP 3,743,127.28 0.01 3,743,127.28 0.01 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 142,762.01 100.00 142,762.01 0.04% None 1 WFSWEEP 142,762.01 0.01 142,762.01 0.01 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 89,250.90 100.00 89,250.90 0.03% None 1 WFSWEEP 89,250.90 0.01 89,250.90 0.01 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 16,873.98 100.00 16,873.98 0.01% None 1 WFSWEEP 16,873.98 0.01 16,873.98 0.01 0.00 None 0 Prepared by Shamaira Jagrup 5 #' "4<r City of Pearland ._ o MONA Portfolio Holdings by Security Type ,`' ,.'` Report Group: Pearland Date:9/30/2020 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash 5/31/2006 1,585,846.67 100.00 1,585,846.67 0.48% None 1 WFSWEEP 1,585,846.67 0.01 1,585,846.67 0.01 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 38,372.89 100.00 38,372.89 0.01% None 1 WFSWEEP 38,372.89 0.01 38,372.89 0.01 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 480,023.70 100.00 480,023.70 0.15% None 1 WFSWEEP 480,023.70 0.01 480,023.70 0.01 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 46,630.05 100.00 46,630.05 0.01% None 1 WFSWEEP 46,630.05 0.01 46,630.05 0.01 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 -55,057.88 100.00 -55,057.88 -0.02% None 1 WFSWEEP -55,057.88 0.01 -55,057.88 0.01 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 4,971,235.07 100.00 4,971,235.07 1.51% None 1 WFSWEEP 4,971,235.07 0.01 4,971,235.07 0.01 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 6,108,891.59 100.00 6,108,891.59 1.85% None 1 WFSWEEP 6,108,891.59 0.01 6,108,891.59 0.01 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 166,802.89 100.00 166,802.89 0.05% None 1 WFSWEEP 166,802.89 0.01 166,802.89 0.01 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 617,930.96 100.00 617,930.96 0.19% None 1 WFSWEEP 617,930.96 0.01 617,930.96 0.01 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 3,544,911.99 100.00 3,544,911.99 1.08% None 1 WFSWEEP 3,544,911.99 0.01 3,544,911.99 0.01 0.00 None 0 'Wells Fargo Sweep Cash 6/30/2006 47,158.23 100.00 47,158.23 0.01% None 1 WFSWEEP 47,158.23 0.01 47,158.23 0.01 0.00 None 0 Wells Fargo Sweep Cash 10/31/2006 597,527.27 100.00 597,527.27 0.18% None 1 WFSWEEP 597,527.27 0.01 597,527.27 0.01 0.00 None 0 Prepared by Shamaira Jagrup 6 d r e, ,"tip City of Pearland { Portfolio Holdings by Security Type `'t ,•'' Report Group: Pearland Date:9/30/2020 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash 12/1/2006 207,876.53 100.00 207,876.53 0.06% None 1 WFSWEEP 207,876.53 0.01 207,876.53 0.01 0.00 None 0 Wells Fargo Sweep Cash 9/1/2007 -118,207.27 100.00 -118,207.27 -0.04% None 1 WFSWEEP -118,207.27 0.01 -118,207.27 0.01 0.00 None 0 Wells Fargo Sweep Cash 12/31/2007 3,706,638.34 100.00 3,706,638.34 1.12% None 1 WFSWEEP 3,706,638.34 0.01 3,706,638.34 0.01 0.00 None 0 Wells Fargo Sweep Cash 10/30/2008 4,075,419.74 100.00 4,075,419.74 1.24% None 1 WFSWEEP 4,075,419.74 0.01 4,075,419.74 0.01 0.00 None 0 Wells Fargo Sweep Cash 9/15/2009 24,512.76 100.00 24,512.76 0.01% None 1 WFSWEEP 24,512.76 0.01 24,512.76 0.01 0.00 None 0 Wells Fargo Sweep Cash 9/15/2010 3,648,447.05 100.00 3,648,447.05 1.11% None 1 WFSWEEP 3,648,447.05 0.01 3,648,447.05 0.01 0.00 None 0 Wells Fargo Sweep Cash 4/15/2012 312,933.85 100.00 312,933.85 0.09% None 1 WFSWEEP 312,933.85 0.01 312,933.85 0.01 0.00 None 0 Wells Fargo Sweep Cash 2/1/2013 25,656.69 100.00 25,656.69 0.01% None 1 WFSWEEP 25,656.69 0.01 25,656.69 0.01 0.00 None 0 Wells Fargo Sweep Cash 11/15/2015 24,727.41 100.00 24,727.41 0.01% None 1 WFSWEEP 24,727.41 0.01 24,727.41 0.01 0.00 None 0 Wells Fargo Sweep Cash 10/15/2018 2,504,716.82 100.00 2,504,716.82 0.76% None 1 WFSWEEP 2,504,716.82 0.01 2,504,716.82 0.01 0.00 None 0 Wells Fargo Sweep Cash 12/15/2018 455,506.47 100.00 455,506.47 0.14% None 1 WFSWEEP 455,506.47 0.01 455,506.47 0.01 0.00 None 0 Wells Fargo Sweep Cash 10/15/2019 -23,144.00 100.00 -23,144.00 -0.01% None 1 WFSWEEP -23,144.00 0.01 -23,144.00 0.01 0.00 None 0 Prepared by Shamaira Jagrup 7 �� ` "'•r• City of Pearland Portfolio Holdings by Security Type #ir k•'' Report Group: Pearland Date:9/30/2020 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash 10/15/2019 2,461,865.40 100.00 2,461,865.40 0.75% None 1 WFSWEEP 2,461,865.40 0.01 2,461,865.40 0.01 0.00 None 0 Wells Fargo Sweep Cash 10/15/2019 3,465,159.86 100.00 3,465,159.86 1.05% None 1 WFSWEEP 3,465,159.86 0.01 3,465,159.86 0.01 0.00 None 0 Wells Fargo Sweep Cash . 10/15/2019 -13,396.00 100.00 -13,396.00 0% None 1 WFSWEEP -13,396.00 0.01 -13,396.00 0.01 0.00 None 0 Wells Fargo Sweep Cash 10/15/2019 34.09 100.00 34.09 0% None 1 WFSWEEP 34.09 0.01 34.09 0.01 0.00 None 0 Wells Fargo Sweep Cash 10/15/2019 -8,609.00 100.00 -8,609.00 0% None 1 WFSWEEP -8,609.00 0.01 -8,609.00 0.01 0.00 None 0 Wells Fargo Sweep Cash 10/15/2019 2,973,154.19 100.00 2,973,154.19 0.9% None 1 WFSWEEP 2,973,154.19 0.01 2,973,154.19 0.01 0.00 None 0 Wells Fargo Sweep Cash 10/15/2019 -199,387.00 100.00 -199,387.00 -0.06% None 1 WFSWEEP -199,387.00 0.01 -199,387.00 0.01 0.00 None 0 Wells Fargo Sweep Cash 12/15/2019 1,050,559.35 100.00 1,050,559.35 0.32% None 1 WFSWEEP 1,050,559.35 0.01 1,050,559.35 0.01 0.00 None 0 Wells Fargo Sweep Cash 1/15/2020 1,620,805.73 100.00 1,620,805.73 0.49% None 1 WFSWEEP 1,620,805.73 0.01 1,620,805.73 0.01 0.00 None 0 Wells Fargo Sweep Cash 1/15/2020 267.28 100.00 267.28 0% None 1 WFSWEEP 267.28 0.01 267.28 0.01 0.00 None 0 Wells Fargo Sweep Cash 1/15/2020 1,329,661.57 100.00 1,329,661.57 0.4% None 1 WFSWEEP 1,329,661.57 0.01 1,329,661.57 0.01 0.00 None 0 Wells Fargo Sweep Cash 2/15/2020 -99.99 100.00 -99.99 0% None 1 WFSWEEP -99.99 0.01 -99.99 0.01 0.00 None 0 Prepared by Shamaira Jagrup 8 444, City of Pearland e. ffiNdle Portfolio Holdings by Security Type ..'s Report Group: Pearland Date:9/30/2020 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash 5/15/2020 290,460.21 100.00 290,460.21 0.09% None 1 WFSWEEP 290,460.21 0.01 290,460.21 0.01 0.00 None 0 Wells Fargo Sweep Cash 8/15/2020 1,981,819.28 100.00 1,981,819.28 0.6% None 1 WFSWEEP 1,981,819.28 0.01 1,981,819.28 0.01 0.00 None 0 Wells Fargo Sweep Cash 9/15/2020 -404.43 100.00 -404.43 0% None 1 • WFSWEEP -404.43 0.01 -404.43 0.01 0.00 None 0 Wells Fargo TWDB Cash 9/15/2017 922,197.97 100.00 922,197.97 0.28% None 1 WF5875 922,197.97 0.01 922,197.97 0.01 0.00 None 0 Wells Fargo TWDB Cash 11/1/2016 81,776.96 100.00 81,776.96 0.02% None 1 WF4094 81,776.96 0.01 81,776.96 0.01 0.00 None 0 Wells Fargo TWDB Cash 5/15/2018 8,756,471.53 100.00 8,756,471.53 2.66% None 1 WF6624 8,756,471.53 0.01 8,756,471.53 0.01 0.00 None 0 Wells Fargo TWDB Cash 6/16/2020 105,493,510.11 100.00 105,493,510.11 32% None 1 WF6100 105,493,510.11 0.02 105,493,510.11 0.02 0.00 None 0 Wells Fargo TWDB Cash 8/6/2019 20,765,821.79 100.00 20,765,821.79 6.3% None 1 WF2847 20,765,821.79 0.01 20,765,821.79 0.01 0.00 None 0 Wells Fargo TWDB Cash 11/1/2016 904,695.84 100.00 904,695.84 0.27% None 1 WF4102 904,695.84 0.01 904,695.84 0.01 0.00 None 0 Wells Fargo TWDB Cash 3/15/2017 10,841,219.46 100.00 10,841,219.46 3.29% None 1 WF5883 10,841,219.46 0.01 10,841,219.46 0.01 0.00 None 0 222,726,246.54 222,726,246.54 67.55% 1 Sub Total Cash 222,726,246.54 0.01 222,726,246.54 0.01 0.00 0 Certificate Of Deposit 1st Security Bank of Wash 1.1 1/22/2021 7/22/2016 248,000.00 100.32 248,801.99 0.08% None 114 33625CAZ2 248,000.00 1.10 248,000.00 0.06 59.79 801.99 None 0.31 Prepared by Shamaira Jagrup 9 p, . 4 44 4'i City of Pearland y Portfolio Holdings by Security Type ''' Report Group: Pearland Date:9/30/2020 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Alma Bank 1.35 12/24/2020 6/24/2016 248,000.00 100.30 248,748.25 0.08% None 85 020080BB2 248,000.00 1.35 248,000.00 0.06 55.04 748.25 None 0.23 American Eagle Bank IL 1.35 7/12/2021 7/11/2016 248,000.00 101.11 250,759.22 0.08% None 285 02554BCM1 248,000.00 1.35 248,000.00 -0.07 174.28 2,759.22 None 0.78 Bank of New England NH 1.4 6/30/2021 6/30/2016 248,000.00 101.14 250,830.07 0.08% None 273 063847AL1 248,000.00 1.40 248,000.00 -0.12 0.00 2,830.07 None 0.75 Border State Bank 1.4 6/30/2021 6/30/2016 248,000.00 100.99 250,455.84 0.08% None 273 099703EF3 248,000.00 1.40 248,000.00 0.08 0.00 2,455.84 None 0.75 Business Bank of St Louis MO 1.8 6/23/2021 6/23/2017 248,000.00 101.26 251,117.79 0.08% None 266 12325EHU9 248,000.00 1.80 248,000.00 0.08 85.61 3,117.79 None 0.73 Community Bank Pasadena 1.5 6/30/2021 6/30/2016 248,000.00 101.14 250,828.89 0.08% None 273 203507BG2 248,000.00 1.50 248,000.00 -0.02 0.00 2,828.89 None 0.75 Community Bankers'Bank 1.4 6/30/2021 6/30/2016 248,000.00 101.14 250,830.07 0.08% None 273 20361LBR4 248,000.00 1.40 248,000.00 -0.12 0.00 2,830.07 None 0.75 First National Bank of America 1.25 7/15/2016 248 000.00 100.93 250,311.29 0.08% None 288 7/15/2021 32110YHM0 248,000.00 1.25 248,000.00 0.07 653.97 2,311.29 None 0.79 GNB Bank 1.5 6/30/2021 6/30/2016 248,000.00 101.14 250,828.89 0.08% None 273 36198JCC6 248,000.00 1.50 248,000.00 -0.02 0.00 2,828.89 None 0.75 Gulf Coast Bank&Trust 1.3 7/15/2021-17 7/15/2016 248,000.00 100.06 248,150.54 0.08% None 15 402194EX8 248,000.00 1.30 248,000.00 1.22 132.49 150.54 None 0.79 Lincoln 1st Bank 1.4 6/30/2021 6/30/2016 248,000.00 101.14 250,830.07 0.08% None 273 53362LAB0 248,000.00 1.40 248,000.00 -0.12 275.86 2,830.07 None 0.75 Marine Bank Springfield IL 1.8 6/29/2021 6/29/2017 248,000.00 101.32 251,280.51 0.08% None 272 56817TAB7 248,000.00 1.80 248,000.00 0.03 12.23 3,280.51 None 0.74 Prepared by Shamaira Jagrup 10 "4, City of Pearland ill@_ Portfolio Holdings by Security Type #'' ,•'i. Report Group: Pearland Date:9/30/2020 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Morgan Stanley Bank NA 2.8 4/5/2021 4/5/2018 248,000.00 101.40 251,477.08 0.08% None 187 61747MS69 248,000.00 2.80 248,000.00 0.06 3,386.39 3,477.08 None 0.51 Portage County Bank 1.4 6/24/2021 6/24/2016 248,000.00 101.12 250,768.11 0.08% None 267 73565NBQ5 248,000.00 1.40 248,000.00 -0.12 57.07 2,768.11 None 0.73 Unity Bank 1.65 10/30/2020 10/30/2015 248,000.00 100.18 248,454.25 0.08% None 30 91330ABC0 248,000.00 1.65 248,000.00 -0.55 0.00 454.25 None 0.08 Vision Bank of Iowa 1.3 7/12/2021 7/11/2016 248,000.00 101.12 250,780.22 0.08% None 285 92834CBW1 248,000.00 1.30 248,000.00 -0.13 715.46 2,780.22 None 0.78 Wells Fargo Bank 1.75 6/17/2021 6/20/2016 248,000.00 101.09 250,692.16 0.08% None 260 9497485W3 248,000.00 1.75 248,000.00 0.23 154.58 2,692.16 None 0.71 4,464,000.00 4,505,945.24 1.44% 222 Sub Total Certificate Of Deposit 4,464,000.00 1.53 4,464,000.00 0.03 5,762.77 41,945.24 0.65 Compound CD Third Coast Bank 2 3/2/2021 10/2/2019 2,029,570.71 100.00 2,029,570.71 0.62% None 153 CD38577 2,029,570.71 2.00 2,029,570.71 2.00 10,008.84 0.00 None 0.42 Third Coast Bank 2 6/2/2021 10/2/2019 2,029,570.71 100.00 2,029,570.71 0.62% None 245 CD38585 2,029,570.71 2.00 2,029,570.71 2.00 10,008.84 0.00 None 0.67 Third Coast Bank 2 9/2/2021 10/2/2019 4,059,141.41 100.00 4,059,141.41 1.23% None 337 CD38593 4,059,141.41 2.00 4,059,141.41 2.00 20,017.69 0.00 None 0.91 8,118,282.83 8,118,282.83 2.47% 268 Sub Total Compound CD 8,118,282.83 2.00 8,118,282.83 2.00 40,035.37 0.00 0.73 FAMC Bond FAMC 1.82 11/9/2020 11/9/2017 1,000,000.00 100.18 1,001,833.62 0.3% Moodys-Aaa 40 3132X0ZC8 1,000,000.00 1.82 1,000,000.00 0.13 7,128.33. 1,833.62 S&P-AA+ 0.11 1,000,000.00 1,001,833.62 0.3% 40 Sub Total FAMC Bond 1,000,000.00 1.82 1,000,000.00 0.13 7,128.33 1,833.62 0.11 FHLMC Bond Prepared by Shamaira Jagrup 11 4, . City of Pearland PEAR AND Portfolio Holdings by Security Type Report Group: Pearland Date:9/30/2020 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity FHLMC 1.125 8/12/2021 9/22/2016 988,540.00 100.85 1,008,467.64 0.3% Moodys-Aaa 316 3137EAEC9 1,000,000.00 1.37 997,968.45 0.15 1,343.75 10,499.19 S&P-AA+ 0.86 988,540.00 1,008,467.64 0.3% 316 Sub Total FHLMC Bond 1,000,000.00 1.37 997,968.45 0.15 1,343.75 10,499.19 0.86 FNMA Bond FNMA 1.875 12/28/2020 9/22/2016 1,025,880.00 100.40 1,004,048.54 0.3% Moodys-Aaa 89 3135G0H55 1,000,000.00 1.25 1,001,482.71 0.22 4,791.67 2,565.83 S&P-AA+ 0.24 1,025,880.00 1,004,048.54 0.3% 89 . Sub Total FNMA Bond 1,000,000.00 1.25 1,001,482.71 0.22 4,791.67 2,565.83 0.24 Local Government Investment Pool Texas Class LGIP 12/20/2016 581,212.90 100.00 581,212.90 0.18% None 1 TX-01-0615-0001 581,212.90 0.25 581,212.90 0.25 0.00 None. 0 Texas Class LGIP 12/20/2016 10,941,772.05 100.00 10,941,772.05 3.32% None 1 TX-01-0615-0001 10,941,772.05 0.25 10,941,772.05 0.25 0.00 None 0 Texas Class LGIP 12/20/2016 1,517,397.19 100.00 1,517,397.19 0.46% None 1 TX-01-0615-0001 1,517,397.19 0.25 1,517,397.19 0.25 0.00 None 0 Texas Class LGIP 12/20/2016 6,039.09 100.00 6,039.09 0% None 1 TX-01-0615-0001 6,039.09 0.25 6,039.09 0.25 0.00 None 0 Texas Class LGIP 1/15/2017 3,871.12 100.00 3,871.12 0% None 1 TX-01-0615-0001 3,871.12 0.25 3,871.12 0.25 0.00 None 0 Texas Class LGIP 1/15/2017 1,066,528.76 100.00 1,066,528.76 0.32% None 1 TX-01-0615-0001 1,066,528.76 0.25 1,066,528.76 0.25 0.00 None 0 Texas Class LGIP 1/15/2017 5,144,008.67 100.00 5,144,008.67 1.56% None 1 • TX-01-0615-0001 5,144,008.67 0.25 5,144,008.67 0.25 0.00 None 0 Texas Class LGIP 5/15/2017 15,116,271.28 100.00 15,116,271.28 4.59% None 1 TX-01-0615-0001 15,116,271.28 0.25 15,116,271.28 0.25 0.00 None 0 Prepared by Shamaira Jagrup 12 i0 4, City of Pearland t d iiiiaBilditii Portfolio Holdings by Security Type "'" ,o' Report Group: Pearland Date:9/30/2020 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Texas Class LGIP 5/15/2017 685,818.70 100.00 685,818.70 0.21% None 1 TX-01-0615-0001 685,818.70 0.25 685,818.70 0.25 0.00 None 0 Texas Class LGIP 5/15/2017 4,142,069.31 100.00 4,142,069.31 1.26% None 1 TX-01-0615-0001 4,142,069.31 0.25 4,142,069.31 0.25 0.00 None 0 Texas Class LGIP 6/15/2020 4,006,213.11 100.00 4,006,213.11 1.22% None 1 TX-01-0615-0001 4,006,213.11 0.25 4,006,213.11 0.25 0.00 None 0 Texas Class LGIP 8/11/2020 10,782,823.70 100.00 10,782,823.70 3.27% None 1 TX-01-0615-0008 10,782,823.70 0.25 10,782,823.70 0.25 0.00 None 0 Texas Class LGIP 8/11/2020 4,256,077.46 100.00 4,256,077.46 1.29% None 1 TX-01-0615-0009 4,256,077.46 0.25 4,256,077.46 0.25 0.00 None 0 Texas Class LGIP 8/11/2020 1,435,723.36 100.00 1,435,723.36 0.44% None 1 TX-01-0615-0009 1,435,723.36 0.25 1,435,723.36 0.25 0.00 None 0 Texas Class LGIP 9/19/2019 3,297.07 100.00 3,297.07 0% None 1 TX-01-0615-0007 3,297.07 0.25 3,297.07 0.25 0.00 None 0 Texas Class LGIP 9/19/2019 801,374.37 100.00 801,374.37 0.24% None 1 TX-01-0615-0007 801,374.37 0.25 801,374.37 0.25 0.00 None 0 Texas Class LGIP 9/19/2019 566,826.88 100.00 566,826.88 0.17% None 1 TX-01-0615-0007 566,826.88 0.25 566,826.88 0.25 0.00 None 0 Texas Class LGIP 8/11/2020 3,883,615.86 100.00 3,883,615.86 1.18% None 1 TX-01-0615-0011 3,883,615.86 0.25 3,883,615.86 0.25 0.00 None 0 Texas Class LGIP 9/15/2018 2,645,409.85 100.00 2,645,409.85 0.8% None 1 TX-01-0615-0005 2,645,409.85 0.25 2,645,409.85 0.25 0.00 None 0 Texas Class LGIP 9/15/2018 7,018.45 100.00 7,018.45 0% None 1 TX-01-0615-0004 7,018.45 0.25 7,018.45 0.25 0.00 None 0 Prepared by Shamaira Jagrup 13 "', City of Pearland Portfolio Holdings by Security Type ',I. '.` Report Group: Pearland Date:9/30/2020 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Texas Class LGIP 9/15/2018 1,306,121.71 100.00 1,306,121.71 0.4% None 1 TX-01-0615-0004 1,306,121.71 0.25 1,306,121.71 0.25 0.00 None 0 Texas Class LGIP 9/15/2018 236,790.24 100.00 236,790.24 0.07% None 1 TX-01-0615-0006 236,790.24 0.25 236,790.24 0.25 0.00 None 0 Texas Class LGIP 8/11/2020 9,444,544.50 100.00 9,444,544.50 2.86% None 1 TX-01-0615-0010 9,444,544.50 0.25 9,444,544.50 0.25 0.00 None 0 TexSTAR LGIP 9/19/2019 1,412,844.58 100.00 1,412,844.58 0.43% None 1 02000-20190 1,412,844.58 0.13 1,412,844.58 0.13 0.00 None 0 TexSTAR LGIP 9/27/2019 491,421.47 100.00 491,421.47 0.15% None 1 02000-20191 491,421.47 0.13 491,421.47 0.13 0.00 None 0 TexSTAR LGIP 9/27/2019 509,939.06 100.00 509,939.06 0.15% None 1 02000-20191 509,939.06 0.13 509,939.06 0.13 0.00 None 0 TexSTAR LGIP 8/26/2016 1,665,255.62 100.00 1,665,255.62 0.51% S&P-AAA 1 02000-11110 1,665,255.62 0.13 1,665,255.62 0.13 0.00 None 0 TexSTAR LGIP 8/26/2016 1,175,639.11 100.00 1,175,639.11 0.36% S&P-AAA 1 02000-11110 1,175,639.11 0.13 1,175,639.11 0.13 0.00 None 0 TexSTAR LGIP 9/27/2019 7,521,817.33 100.00 7,521,817.33 2.28% None 1 02000-20192 7,521,817.33 0.13 7,521,817.33 0.13 0.00 None 0 91,357,742.80 91,357,742.80 27.72% 1 Sub Total Local Government Investment 91,357,742.80 0.23 91,357,742.80 0.23 0.00 0 Pool 329,680,692.17 329,722,567.21 100.00% 12 TOTAL PORTFOLIO 329,666,272.17 0.16 329,665,723.33 0.12 59,061.89 56,843.88 0.03 Prepared by Shamaira Jagrup 14 46' "'% City of Pearland 1 Portfolio Holdings by Portfolio Name ,`' Report Group: Pearland Date:9/30/2020 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity 100:General Fund '� Alma Bank 1.35 12/24/2020 6/24/2016 248,000.00 100.30 248,748.25 0.08% None 85 020080BB2 248,000.00 1.35 248,000.00 0.06 55.04 748.25 None 0.23 American Eagle Bank IL 1.35 7/12/2021 7/11/2016 248,000.00 101.11 250,759.22 0.08% None 285 02554BCM1 248,000.00 1.35 248,000.00 -0.07 174.28 2,759.22 None 0.78 Community Bank Pasadena 1.5 6/30/2021 6/30/2016 248,000.00 101.14 250,828.89 0.08% None 273 203507BG2 248,000.00 1.50 248,000.00 -0.02 0.00 2,828.89 None 0.75 Community Bankers'Bank 1.4 6/30/2021 6/30/2016 248,000.00 101.14 250,830.07 0.08% None 273 20361LBR4 248,000.00 1.40 248,000.00 -0.12 0.00 2,830.07 None 0.75 Morgan Stanley Bank NA 2.8 4/5/2021 4/5/2018 248,000.00 101.40 251,477.08 0.08% None 187 61747MS69 248,000.00 2.80 248,000.00 0.06 3,386.39 3,477.08 None 0.51 Texas Class LGIP 5/15/2017 15,116,271.28 100.00 15,116,271.28 4.59% None 1 TX-01-0615-0001 15,116,271.28 0.25 15,116,271.28 0.25 0.00 None 0 Unity Bank 1.65 10/30/2020 10/30/2015 248,000.00 100.18 248,454.25 0.08% None 30 91330ABC0 248,000.00 1.65 248,000.00 -0.55 0.00 454.25 None 0.08 Vision Bank of Iowa 1.3 7/12/2021 . 7/11/2016 248,000.00 101.12 250,780.22 0.08% None 285 92834CBW1 248,000.00 1.30 248,000.00 -0.13 715.46 2,780.22 None 0.78 Wells Fargo Bank 1.75 6/17/2021 6/20/2016 248,000.00 101.09 250,692.16 0.08% None 260 9497485W3 248,000.00 1.75 248,000.00 0.23 154.58 2,692.16 None 0.71 Wells Fargo Sweep Cash 5/31/2006 4,971,235.07 100.00 4,971,235.07 1.51% None 1 WFSWEEP 4,971,235.07 0.01 4,971,235.07 0.01 0.00 None 0 22,071,506.35 22,090,076.49 6.74% 20 Sub Total 100:General Fund 22,071,506.35 0.32 22,071,506.35 0.17 4,485.75 18,570.14 0.05 200:Debt Services Texas Class LGIP 1/15/2017 5,144,008.67 100.00 5,144,008.67 1.56% None 1 TX-01-0615-0001 5,144,008.67 0.25 5,144,008.67 0.25 0.00 None 0 Prepared by Shamaira Jagrup 15 era h`t,,tl City of Pearland MOMS Portfolio Holdings by Portfolio Name "•'% Report Group: Pearland Date:9/30/2020 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash 5/31/2006 1,166,338.30 100.00 1,166,338.30 0.35% None 1 WFSWEEP 1,166,338.30 0.01 1,166,338.30 0.01 0.00 None 0 6,310,346.97 6,310,346.97 1.91% 1 Sub Total 200:Debt Services 6,310,346.97 0.21 6,310,346.97 0.21 0.00 0 305: Hotel/Motel Occupancy Bank of New England NH 1.4 6/30/2021 6/30/2016 248,000.00 101.14 250,830.07 0.08% None 273 063847AL1 248,000.00 1.40 248,000.00 -0.12 0.00 2,830.07 None 0.75 Texas Class LGIP 5/15/2017 4,142,069.31 100.00 4,142,069.31 1.26% None 1 TX-01-0615-0001 4,142,069.31 0.25 4,142,069.31 0.25 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 990,434.21 100.00 990,434.21 0.3% None 1 WFSWEEP 990,434.21 0.01 990,434.21 0.01 0.00 None 0 5,380,503.52 5,383,333.59 1.64% 14 Sub Total 305:Hotel/Motel Occupancy 5,380,503.52 0.26 5,380,503.52 0.19 0.00 2,830.07 0.03 310: Municipal Court Security Wells Fargo Sweep Cash 5/31/2006 38,372.89 100.00 38,372.89 0.01% None 1 WFSWEEP 38,372.89 0.01 38,372.89 0.01 0.00 None 0 38,372.89 38,372.89 0.01% 1 Sub Total 310:Municipal Court Security 38,372.89 0.01 38,372.89 0.01 0.00 0 315:City Wide Donation Wells Fargo Sweep Cash 5/31/2006 142,762.01 100.00 142,762.01 0.04% None 1 WFSWEEP 142,762.01 0.01 142,762.01 0.01 0.00 None 0 142,762.01 142,762.01 0.04% 1 Sub Total 315:City Wide Donation 142,762.01 0.01 142,762.01 0.01 0.00 0 320:Court Technology Wells Fargo Sweep Cash 5/31/2006 8,384.02 100.00 8,384.02 0% None 1 WFSWEEP 8,384.02 0.01 8,384.02 0.01 0.00 None 0 8,384.02 8;384.02 0% 1 Sub Total 320:Court Technology 8,384.02 0.01 8,384.02 0.01 0.00 0 Prepared by Shamaira Jagrup 16 City of Pearland OHM* Portfolio Holdings by Portfolio Name "'" Report Group: Pearland Date:9/30/2020 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity 330:Park Donations Wells Fargo Sweep Cash 5/31/2006 57,834.87 100.00 57,834.87 0.02% None 1 WFSWEEP 57,834.87 0.01 57,834.87 0.01 0.00 None 0 57,834.87 57,834.87 0.02% 1 Sub Total 330:Park Donations 57,834.87 0.01 57,834.87 0.01 0.00 0 331:Tree Trust Fund Wells Fargo Sweep Cash 5/31/2006 480,023.70 100.00 480,023.70 0.15% None 1 WFSWEEP 480,023.70 0.01 480,023.70 0.01 0.00 None 0 480,023.70 480,023.70 0.15% 1 Sub Total 331:Tree Trust Fund 480,023.70 0.01 480,023.70 0.01 0.00 0 332:Parks Financi Asstance Donations Wells Fargo Sweep Cash 10/15/2019 34.09 100.00 34.09 0% None 1 WFSWEEP 34.09 0.01 34.09 0.01 0.00 None 0 34.09 34.09 0% 1 Sub Total 332:Parks Financi Asstance 34.09 0.01 34.09 0.01 0.00 0 Donations 335:Police State Seizure Wells Fargo Sweep Cash 5/31/2006 89,250.90 100.00 89,250.90 0.03% None 1 WFSWEEP 89,250.90 0.01 89,250.90 0.01 0.00 None 0 89,250.90 89,250.90 0.03% 1 Sub Total 335:Police State Seizure 89,250.90 0.01 89,250.90 0.01 0.00 0 336:Federal Police Fund Wells Fargo Sweep Cash 5/31/2006 166,802.89 100.00 166,802.89 0.05% None 1 WFSWEEP 166,802.89 0.01 166,802.89 0.01 0.00 None 0 166,802.89 166,802.89 0.05% 1 Sub Total 336:Federal Police Fund 166,802.89 0.01 166,802.89 0.01 0.00 0 340:Park&Rec Development Border State Bank 1.4 6/30/2021 6/30/2016 248,000.00 100.99 250,455.84 0.08% None 273 099703EF3 248,000.00 1.40 248,000.00 0.08 0.00 2,455.84 None 0.75 Prepared by Shamaira Jagrup 17 City of Pearland f;EAI LAND Portfolio Holdings by Portfolio Name Report Group: Pearland Date:9/30/2020 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount I CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash 5/31/2006 997,275.61 100.00 997,275.61 0.3% None 1 WFSWEEP 997,275.61 0.01 997,275.61 0.01 0.00 None 0 1,245,275.61 1,247,731.45 0.38% 55 Sub Total 340:Park&Rec Development 1,245,275.61 0.29 1,245,275.61 0.02 0.00 2,455.84 0.15 345:Sidewalk Fund Wells Fargo Sweep Cash 5/31/2006 46,630.05 100.00 46,630.05 0.01% None 1 WFSWEEP 46,630.05 0.01 46,630.05 0.01 0.00 None 0 46,630.05 46,630.05 0.01% 1 Sub Total 345:Sidewalk Fund 46,630.05 0.01 46,630.05 0.01 0.00 0 350:Grant Fund Wells Fargo Sweep Cash 5/31/2006 -55,057.88 100.00 -55,057.88 -0.02% None 1 WFSWEEP -55,057.88 0.01 -55,057.88 0.01 0.00 None 0 -55,057.88 -55,057.88 -0.02% 1 Sub Total 350:Grant Fund -55,057.88 0.01 -55,057.88 0.01 0.00 0 351:CDBG Fund Wells Fargo Sweep Cash 11/15/2015 24,727.41 100.00 24,727.41 0.01% None 1 WFSWEEP 24,727.41 0.01 24,727.41 0.01 0.00 None 0 24,727.41 24,727.41 0.01% 1 Sub Total 351:CDBG Fund 24,727.41 0.01 24,727.41 0.01 0.00 0 353:Disaster Recovery Fund Wells Fargo Sweep Cash 9/15/2020 -404.43 100.00 -404.43 0% None 1 WFSWEEP -404.43 0.01 -404.43 0.01 0.00 None 0 -404.43 -404.43 0% 1 Sub Total 353:Disaster Recovery Fund -404.43 0.01 -404.43 0.01 0.00 0 355:Coronavirus Relief Fund Wells Fargo Sweep Cash 5/15/2020 290,460.21 100.00 290,460.21 0.09% None 1 WFSWEEP 290,460.21 0.01 290,460.21 0.01 0.00 None 0 Prepared by Shamaira Jagrup 18 City of Pearland iiiitakaill Portfolio Holdings by Portfolio Name ''' Report Group: Pearland Date:9/30/2020 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount I CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity 290,460.21 290,460.21 0.09% 1 Sub Total 355:Coronavirus Relief Fund 290,460.21 0.01 290,460.21 0.01 0.00 0 360:Traffic Impact Improvement Wells Fargo Sweep Cash 5/31/2006 617,930.96 100.00 617,930.96 0.19% None 1 WFSWEEP 617,930.96 0.01 617,930.96 0.01 0.00 None 0 617,930.96 617,930.96 0.19% 1 Sub Total 360:Traffic Impact Improvement 617,930.96 0.01 617,930.96 0.01 0.00 0 365:Court Juvenile Mgmt Wells Fargo Sweep Cash 9/15/2009 24,512.76 100.00 24,512.76 0.01% None 1 WFSWEEP 24,512.76 0.01 24,512.76 0.01 0.00 None 0 24,512.76 24,512.76 0.01% 1 Sub Total 365:Court Juvenile Mgmt 24,512.76 0.01 24,512.76 0.01 0.00 0 366: Municipal Jury Fund Wells Fargo Sweep Cash 1/15/2020 267.28 100.00 267.28 0% None 1 WFSWEEP 267.28 0.01 267.28 0.01 0.00 None 0 267.28 267.28 0% 1 Sub Total 366:Municipal Jury Fund 267.28 0.01 267.28 0.01 0.00 0 370:Municipal Channel Texas Class LGIP 5/15/2017 685,818.70 100.00 685,818.70 0.21% None 1 TX-01-0615-0001 685,818.70 0.25 685,818.70 0.25 0.00 None 0 Wells Fargo Sweep Cash 4/15/2012 312,933.85 100.00 312,933.85 0.09% None 1 WFSWEEP 312,933.85 0.01 312,933.85 0.01 0.00 None 0 998,752.55 998,752.55 0.3% 1 Sub Total 370:Municipal Channel 998,752.55 0.18 998,752.55 0.18 0.00 0 500:Capital Projects Texas Class LGIP 1/15/2017 1,066,528.76 100.00 1,066,528.76 0.32% None 1 TX-01-0615-0001 1,066,528.76 0.25 1,066,528.76 0.25 0.00 None 0 Prepared by Shamaira Jagrup 19 tl' ` "'• City of Pearland r {�k tl . . , Portfolio Holdings by Portfolio Name 'sr Report Group: Pearland Date:9/30/2020 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Wells Fargo Cash 8/12/2020 1,000,000.00 100.00 1,000,000.00 0.3% None 1 WF3025 1,000,000.00 0.00 1,000,000.00 0.00 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 1,585,846.67 100.00 1,585,846.67 0.48% None 1 WFSWEEP 1,585,846.67 0.01 1,585,846.67 0.01 0.00 None 0 3,652,375.43 3,652,375.43 1.1% 1 Sub Total 500:Capital Projects 3,652,375.43 0.08 3,652,375.43 0.08 0.00 0 501:Certificates of Obligation 1st Security Bank of Wash 1.1 1/22/2021 7/22/2016 248,000.00 100.32 248,801.99 0.08% None 114 33625CAZ2 248,000.00 1.10 248,000.00 0.06 59.79 801.99 None 0.31 FHLMC 1.125 8/12/2021 9/22/2016 988,540.00 100.85 1,008,467.64 0.3% Moodys-Aaa 316 3137EAEC9 1,000,000.00 1.37 997,968.45 0.15 1,343.75 10,499.19 S&P-AA+ 0.86 FNMA 1.875 12/28/2020 9/22/2016 1,025,880.00 100.40 1,004,048.54 0.3% Moodys-Aaa 89 3135G0H55 1,000,000.00 1.25 1,001,482.71 0.22 4,791.67 2,565.83 S&P-AA+ 0.24 Gulf Coast Bank&Trust 1.3 7/15/2021-17 7/15/2016 248,000.00 100.06 248,150.54 0.08% None 15 402194EX8 248,000.00 1.30 248,000.00 1.22 132.49 150.54 None 0.79 Texas Class LGIP 12/20/2016 6,039.09 100.00 6,039.09 0% None 1 TX-01-0615-0001 6,039.09 0.25 6,039.09 0.25 0.00 None 0 Texas Class LGIP 8/11/2020 1,435,723.36 100.00 1,435,723.36 0.44% None 1 TX-01-0615-0009 1,435,723.36 0.25 1,435,723.36 0.25 0.00 None 0 Texas Class LGIP 9/19/2019 566,826.88 100.00 566,826.88 0.17% None 1 TX-01-0615-0007 566,826.88 0.25 566,826.88 0.25 0.00 None 0 Texas Class LGIP 9/15/2018 236,790.24 100.00 236,790.24 0.07% None 1 TX-01-0615-0006 236,790.24 0.25 236,790.24 0.25 0.00 None 0 TexSTAR LGIP 9/27/2019 509,939.06 100.00 509,939.06 0.15% None 1 02000-20191 509,939.06 0.13 509,939.06 0.13 0.00 None 0 Prepared by Shamaira Jagrup 20 0' ' "'°- City of Pearland iiiitakiNii Portfolio Holdings by Portfolio Name Report Group: Pearland Date:9/30/2020 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity TexSTAR LGIP 8/26/2016 1,175,639.11 100.00 1,175,639.11 0.36% S&P-AAA 1 02000-11110 1,175,639.11 0.13 1,175,639.11 0.13 0.00 None 0 TexSTAR LGIP 9/27/2019 7,521,817.33 100.00 7,521,817.33 2.28% None 1 02000-20192 7,521,817.33 0.13 7,521,817.33 0.13 0.00 None 0 Third Coast Bank 2 9/2/2021 10/2/2019 4,059,141.41 100.00 4,059,141.41 1.23% None 337 CD38593 4,059,141.41 2.00 4,059,141.41 2.00 20,017.69 0.00 None 0.91 Wells Fargo Sweep Cash 5/31/2006 3,544,911.99 100.00 3,544,911.99 1.08% None 1 WFSWEEP 3,544,911.99 0.01 3,544,911.99 0.01 0.00 None 0 21,567,248.47 21,566,297.18 6.54% 84 Sub Total 501:Certificates of Obligation 21,552,828.47 0.61 21,552,279.63 0.49 26,345.39 14,017.55 0.24 503:Certificates of Obligation 2006 Wells Fargo Sweep Cash 6/30/2006 47,158.23 100.00 47,158.23 0.01% None 1 WFSWEEP 47,158.23 0.01 47,158.23 0.01 0.00 None 0 47,158.23 47,158.23 0.01% 1 Sub Total 503:Certificates of Obligation 47,158.23 0.01 47,158.23 0.01 0.00 0 2006 506:General Obligation Business Bank of St Louis MO 1.8 6/23/2021 6/23/2017 248,000.00 101.26 251,117.79 0.08% None 266 12325EHU9 248,000.00 1.80 248,000.00 0.08 85.61 3,117.79 None 0.73 First National Bank of America 1.25 7/15/2016 248,000.00 100.93 250,311.29 0.08% None 288 7/15/2021 32110YHMO 248,000.00 1.25 248,000.00 0.07 653.97 2,311.29 None 0.79 Lincoln 1st Bank 1.4 6/30/2021 6/30/2016 248,000.00 101.14 250,830.07 • 0.08% None 273 53362LAB0 248,000.00 1.40 248,000.00 -0.12 275.86 2,830.07 None 0.75 Texas Class LGIP 12/20/2016 1,517,397.19 100.00 1,517,397.19 0.46% None 1 TX-01-0615-0001 1,517,397.19 0.25 1,517,397.19 0.25 0.00 None 0 Texas Class LGIP 9/15/2018 2,645,409.85 100.00 2,645,409.85 0.8% None 1 TX-01-0615-0005 2,645,409.85 0.25 2,645,409.85 0.25 0.00 None 0 Prepared by Shamaira Jagrup 21 '• City of Pearland Portfolio Holdings by Portfolio Name ,., Report Group: Pearland Date:9/30/2020 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity TexSTAR LGIP 9/19/2019 1,412,844.58 100.00 1,412,844.58 0.43% None 1 02000-20190 1,412,844.58 0.13 1,412,844.58 0.13 0.00 None 0 TexSTAR LGIP 9/27/2019 491,421.47 100.00 491,421.47 0.15% None 1 02000-20191 491,421.47 0.13 491,421.47 0.13 0.00 None 0 TexSTAR LGIP 8/26/2016 1,665,255.62 100.00 1,665,255.62 0.51% S&P-AAA 1 02000-11110 1,665,255.62 0.13 1,665,255.62 0.13 0.00 None 0 Wells Fargo Sweep Cash 10/30/2008 4,075,419.74 100.00 4,075,419.74 1.24% None 1 WFSWEEP 4,075,419.74 0.01 4,075,419.74 0.01 0.00 None 0 12,551,748.45 12,560,007.60 3.83% 17 Sub Total 506:General Obligation 12,551,748.45 0.21 12,551,748.45 0.13 1,015.44 8,259.15 0.04 507:General Obligation Series 2020 Texas Class LGIP 8/11/2020 10,782,823.70 100.00 10,782,823.70 3.27% None 1 TX-01-0615-0008 10,782,823.70 0.25 10,782,823.70 0.25 0.00 None 0 Wells Fargo Sweep Cash 10/15/2019 2,973,154.19 100.00 2,973,154.19 0.9% None 1 WFSWEEP 2,973,154.19 0.01 2,973,154.19 0.01 0.00 None 0 13,755,977.89 13,755,977.89 4.17% 1 Sub Total 507:General Obligation Series 13,755,977.89 0.20 13,755,977.89 0.20 0.00 0 2020 508:Certificates of Oblg Series 2020 Texas Class LGIP 8/11/2020 4,256,077.46 100.00 4,256,077.46 1.29% None 1 TX-01-0615-0009 4,256,077.46 0.25 4,256,077.46 0.25 0.00 None 0 Wells Fargo Sweep Cash 10/15/2019 3,465,159.86 100.00 3,465,159.86 1.05% None 1 WFSWEEP 3,465,159.86 0.01 3,465,159.86 0.01 0.00 None 0 7,721,237.32 7,721,237.32 2.34% 1 Sub Total 508:Certificates of Oblg Series 7,721,237.32 0.14 7,721,237.32 0.14 0.00 0 2020 509:General Obligation Series 2021 Prepared by Shamaira Jagrup 22 °' City of Pearland _ligiii Portfolio Holdings by Portfolio Name Report Group: Pearland Date:9/30/2020 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash 10/15/2019 -8,609.00 100.00 -8,609.00 0% None 1 WFSWEEP -8,609.00 0.01 -8,609.00 0.01 0.00 None 0 -8,609.00 -8,609.00 0% 1 Sub Total 509:General Obligation Series -8,609.00 0.01 -8,609.00 0.01 0.00 0 2021 511:PEDC Capital Projects Wells Fargo Sweep Cash 12/15/2018 455,506.47 100.00 455,506.47 0.14% None 1 WFSWEEP 455,506.47 0.01 455,506.47 0.01 0.00 None 0 455,506.47 455,506.47 0.14% 1 Sub Total 511:PEDC Capital Projects 455,506.47 0.01 455,506.47 0.01 0.00 0 512:Certificates of Oblg Series 2021 Wells Fargo Sweep Cash 2/15/2020 -99.99 100.00 -99.99 0% None 1 WFSWEEP -99.99 0.01 -99.99 0.01 0.00 None 0 -99.99 -99.99 0% 1 Sub Total 512:Certificates of Oblg Series -99.99 0.01 -99.99 0.01 0.00 0 2021 514:Infrastructure Reinvestment Fund Wells Fargo Sweep Cash 12/15/2019 1,050,559.35 100.00 1,050,559.35 0.32% None 1 WFSWEEP 1,050,559.35 0.01 1,050,559.35 0.01 0.00 None 0 1,050,559.35 1,050,559.35 0.32% 1 Sub Total 514:Infrastructure 1,050,559.35 0.01 1,050,559.35 0.01 0.00 0 Reinvestment Fund 515:Certificates of Oblig 2020 TIRZ Texas Class LGIP 8/11/2020 9,444,544.50 100.00 9,444,544.50 2.86% None 1 TX-01-0615-0010 9,444,544.50 0.25 9,444,544.50 0.25 0.00 None 0 Wells Fargo Sweep Cash 8/15/2020 1,981,819.28 100.00 1,981,819.28 0.6% None 1 WFSWEEP 1,981,819.28 0.01 1,981,819.28 0.01 0.00 None 0 11,426,363.78 11,426,363.78 3.46% 1 Sub Total 515:Certificates of Oblig 2020 11,426,363.78 0.21 11,426,363.78 0.21 0.00 0 TIRZ 550:W/S Impact Fee Prepared by Shamaira Jagrup 23 "" City of Pearland viiiiilikiii Portfolio Holdings by Portfolio Name Report Group: Pearland Date:9/30/2020 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity FAMC 1.82 11/9/2020 11/9/2017 1,000,000.00 100.18 1,001,833.62 0.3% Moodys-Aaa 40 3132X0ZC8 1,000,000.00 1.82 1,000,000.00 0.13 7,128.33 1,833.62 S&P-AA+ 0.11 Texas Class LGIP 12/20/2016 581,212.90 100.00 581,212.90 0.18% None 1 TX-01-0615-0001 581,212.90 0.25 581,212.90 0.25 0.00 None 0 Texas Class LGIP 9/19/2019 801,374.37 100.00 801,374.37 0.24% None 1 TX-01-0615-0007 801,374.37 0.25 801,374.37 0.25 0.00 None 0 Texas Class LGIP 9/15/2018 1,306,121.71 100.00 1,306,121.71 0.4% None 1 TX-01-0615-0004 1,306,121.71 0.25 1,306,121.71 0.25 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 3,743,127.28 100.00 3,743,127.28 1.14% None 1 WFSWEEP 3,743,127.28 0.01 3,743,127.28 0.01 0.00 None 0 Wells Fargo TWDB Cash 11/1/2016 81,776.96 100.00 81,776.96 0.02% None 1 WF4094 81,776.96 0.01 81,776.96 0.01 0.00 None 0 Wells Fargo TWDB Cash 5/15/2018 8,756,471.53 100.00 8,756,471.53 2.66% None 1 WF6624 8,756,471.53 0.01 8,756,471.53 0.01 0.00 None 0 Wells Fargo TWDB Cash 8/6/2019 20,765,821.79 100.00 20,765,821.79 6.3% . None 1 WF2847 20,765,821.79 0.01 20,765,821.79 0.01 0.00 None 0 Wells Fargo TWDB Cash 11/1/2016 904,695.84 100.00 904,695.84 0.27% None 1 WF4102 904,695.84 0.01 904,695.84 0.01 0.00 None 0 Wells Fargo TWDB Cash 3/15/2017 10,841,219.46 100.00 10,841,219.46 3.29% None 1 WF5883 10,841,219.46 0.01 10,841,219.46 0.01 0.00 None 0 48,781,821.84 48,783,655.46 14.8% 2 Sub Total 550:W/S Impact Fee 48,781,821.84 0.06 48,781,821.84 0.03 7,128.33 1,833.62 0 551:Water Impact Fee Fund Wells Fargo Sweep Cash 1/15/2020 1,620,805.73 100.00 1,620,805.73 0.49% None 1 WFSWEEP 1,620,805.73 0.01 1,620,805.73 0.01 0.00 None 0 Prepared by Shamaira Jagrup 24 •r; City of Pearland ii ., Portfolio Holdings by Portfolio Name Report Group: Pearland Date:9/30/2020 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity 1,620,805.73 1,620,805.73 0.49% 1 Sub Total 551:Water Impact Fee Fund 1,620,805.73 0.01 1,620,805.73 0.01 0.00 0 552:Waste Water Impact Fee Fund Wells Fargo Sweep Cash 1/15/2020 1,329,661.57 100.00 1,329,661.57 0.4% None 1 WFSWEEP 1.329,661.57 0.01 1,329,661.57 0.01 0.00 None 0 1,329,661.57 1,329,661.57 0.4% 1 Sub Total 552:Waste Water Impact Fee 1,329,661.57 0.01 1,329,661.57 0.01 0.00 0 Fund 555:Shadow Creek Impact Wells Fargo Sweep Cash 5/31/2006 16,873.98 100.00 16,873.98 0.01% None 1 WFSWEEP '6.873.98 0.01 16,873.98 0.01 0.00 None 0 16,873.98 16,873.98 0.01% 1 Sub Total 555:Shadow Creek Impact 16,873.98 0.01 16,873.98 0.01 0.00 0 565: Revenue Bonds 1999&2003 GNB Bank 1.5 6/30/2021 6/30/2016 248,000.00 101.14 250,828.89 0.08% None 273 36198JCC6 248.000.00 1.50 248,000.00 -0.02 0.00 2,828.89 None 0.75 Texas Class LGIP 1/15/2017 3,871.12 100.00 3,871.12 0% None 1 TX-01-0615-0001 3,871.12 0.25 3,871.12 0.25 0.00 None 0 Texas Class LGIP 9/19/2019 3,297.07 100.00 3,297.07 0% None 1 TX-01-0615-0007 3,297.07 0.25 3,297.07 0.25 0.00 None 0 Texas Class LGIP 9/15/2018 7,018.45 100.00 7,018.45 0% None 1 TX-01-0615-0004 7,018.45 0.25 7,018.45 0.25 0.00 None 0 Third Coast Bank 2 3/2/2021 10/2/2019 2,029,570.71 100.00 2,029,570.71 0.62% None 153 CD38577 2,029,570.71 2.00 2,029,570.71 2.00 10,008.84 0.00 None 0.42 Third Coast Bank 2 6/2/2021 10/2/2019 2,029,570.71 100.00 2,029,570.71 0.62% None 245 CD38585 2,029,570.71 2.00 2,029,570.71 2.00 10,008.84 0.00 None 0.67 Wells Fargo Sweep Cash 5/31/2006 6,108,891.59 100.00 6,108,891.59 1.85% None 1 WFSWEEP 6,108,891.59 0.01 6,108,891.59 0.01 0.00 None 0 Prepared by Shamaira Jagrup 25 �'' '''•r, City of Pearland a Portfolio Holdings by Portfolio Name '`' ,,' Report Group: Pearland Date:9/30/2020 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount I CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Wells Fargo TWDB Cash 9/15/2017 922,197.97 100.00 922,197.97 0.28% None 1 WF5875 922,197.97 0.01 922,197.97 0.01 0.00 None 0 11,352,417.62 11,355,246.51 3.45% 78 Sub Total 565:Revenue Bonds 1999& 11,352,417.62 0.75 11,352,417.62 0.72 20,017.68 2,828.89 0.21 2003 566:Revenue Bonds Series 2020 Texas Class LGIP 8/11/2020 3,883,615.86 100.00 3,883,615.86 1.18% None 1 TX-01-0615-0011 3,883,615.86 0.25 3,883,615.86 0.25 0.00 None 0 Wells Fargo Sweep Cash 10/15/2019 2,461,865.40 100.00 2,461,865.40 0.75% None 1 WFSWEEP 2,461,865.40 0.01 2,461,865.40 0.01 0.00 None 0 6,345,481.26 6,345,481.26 1.93% 1 Sub Total 566:Revenue Bonds Series 6,345,481.26 0.16 6,345,481.26 0.16 0.00 0 2020 567:Water Drinking Bonds Series 2020 Wells Fargo Sweep Cash 10/15/2019 -199,387.00 100.00 -199,387.00 -0.06% None 1 WFSWEEP -199,387.00 0.01 -199,387.00 0.01 0.00 None 0 Wells Fargo TWDB Cash 6/16/2020 105,493,510.11 100.00 105,493,510.11 32% None 1 WF6100 105,493,510.11 0.02 105,493,510.11 0.02 0.00 None 0 105,294,123.11 105,294,123.11 31.94% 1 Sub Total 567:Water Drinking Bonds 105,294,123.11 0.02 105,294,123.11 0.02 0.00 0 Series 2020 568:Revenue Bonds Series 2021 Wells Fargo Sweep Cash 10/15/2019 -23,144.00 100.00 -23,144.00 -0.01% None 1 WFSWEEP -23,144.00 0.01 -23,144.00 0.01 0.00 None 0 -23,144.00 -23,144.00 -0.01% 1 Sub Total 568:Revenue Bonds Series -23,144.00 0.01 -23,144.00 0.01 0.00 0 2021 569:Revenue Bonds Series 2022 Wells Fargo Sweep Cash 10/15/2019 -13,396.00 100.00 -13,396.00 0% None 1 WFSWEEP -13,396.00 0.01 -13,396.00 0.01 0.00 None 0 Prepared by Shamaira Jagrup 26 City of Pearland a liflid 8g4ill Portfolio Holdings by Portfolio Name Report Group: Pearland Date:9/30/2020 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity -13,396.00 -13,396.00 0% 1 Sub Total 569:Revenue Bonds Series -13,396.00 0.01 -13,396.00 0.01 0.00 0 2022 570:W/S Pay As You Go Marine Bank Springfield IL 1.8 6/29/2021 6/29/2017 248,000.00 101.32 251,280.51 0.08% None 272 56817TAB7 248,000,00 1.80 248,000.00 0.03 12.23 3,280.51 None 0.74 Texas Class LGIP 6/15/2020 4,006,213.11 100.00 4,006,213.11 1.22% None 1 TX-01-0615-0001 4,006,213.11 0.25 4,006,213.11 0.25 0.00 None 0 Wells Fargo Sweep Cash 12/31/2007 3,706,638.34 100.00 3,706,638.34 1.12% None 1 WFSWEEP 3,706,638.34 0.01 3,706,638.34 0.01 0.00 None 0 7,960,851.45 7,964,131.96 2.42% 9 Sub Total 570:W/S Pay As You Go 7,960,851.45 0.19 7,960,851.45 0.13 12.23 3,280.51 0.02 575:MUD 4 Capital Programs Wells Fargo Sweep Cash 2/1/2013 25,656.69 100.00 25,656.69 0.01% None 1 WFSWEEP 25,656.69 0.01 25,656.69 0.01 0.00 None 0 25,656.69 25,656.69 0.01% 1 Sub Total 575:MUD 4 Capital Programs 25,656.69 0.01 25,656.69 0.01 0.00 0 600:Water&Sewer a �:l Portage County Bank 1.4 6/24/2021 6/24/2016 248,000.00 101.12 250,768.11 0.08% None 267 73565NBQ5 248,000.00 1.40 248,000.00 -0.12 57.07 2,768.11 None 0.73 Texas Class LGIP 12/20/2016 10,941,772.05 100.00 10,941,772.05 3.32% None . 1 TX-01-0615-0001 10,941,772.05 0.25 • 10,941,772.05 0.25 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 18,408,553.89 100.00 18,408,553.89 5.58% None 1 WFSWEEP 18,408,553.89 0.01 18,408,553.89 0.01 0.00 None 0 29,598,325.94 29,601,094.05 8.98% 3 Sub Total 600:Water&Sewer 29,598,325.94 0.11 29,598,325.94 0.10 57.07 2,768.11 0.01 610:Solidwaste Prepared by Shamaira Jagrup 27 City of Pearland a„Ana@ Portfolio Holdings by Portfolio Name Report Group: Pearland Date:9/30/2020 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash 12/1/2006 207,876.53 100.00 207,876.53 0.06% None 1 WFSWEEP 207,876.53 0.01 207,876.53 0.01 0.00 None 0 207,876.53 207,876.53 0.06% 1 Sub Total 610:Solidwaste 207,876.53 0.01 207,876.53 0.01 0.00 0 700:Property Liability Ins Wells Fargo Sweep Cash 10/31/2006 597,527.27 100.00 597,527.27 0.18% None 1 WFSWEEP 597,527.27 0.01 597,527.27 0.01 0.00 None 0 597,527.27 597,527.27 0.18% 1 Sub Total 700:Property Liability Ins 597,527.27 0.01 597,527.27 0.01 0.00 0 701: Employee Benefit Fund Wells Fargo Sweep Cash 9/1/2007 -118,207.27 100.00 -118,207.27 -0.04% None 1 WFSWEEP -118,207.27 0.01 -118,207.27 0.01 0.00 None 0 -118,207.27 -118,207.27 -0.04% 1 Sub Total 701:Employee Benefit Fund -118,207.27 0.01 -118,207.27 0.01 0.00 0 702:Health Claims Fund Wells Fargo Cash 7/21/2010 392,469.45 100.00 392,469.45 0.12% None 1 WF9871 392,469.45 0.16 392,469.45 0.16 0.00 None 0 Wells Fargo Sweep Cash 9/15/2010 3,648,447.05 100.00 3,648,447.05 1.11% None 1 WFSWEEP 3,648,447.05 0.01 3,648,447.05 0.01 0.00 None 0 4,040,916.50 4,040,916.50 1.23% 1 Sub Total 702:Health Claims Fund 4,040,916.50 0.02 4,040,916.50 0.02 0.00 0 703:Motor Pool Fund Wells Fargo Sweep Cash 10/15/2018 2,504,716.82 100.00 2,504,716.82 0.76% None 1 WFSWEEP 2,504,716.82 0.01 2,504,716.82 0.01 0.00 None 0 2,504,716.82 2,504,716.82 0.76% 1 Sub Total 703:Motor Pool Fund 2,504,716.82 0.01 2,504,716.82 0.01 0.00 0 Prepared by Shamaira Jagrup 28 .. , ; City of Pearland AIg Portfolio Holdings by Portfolio Name Report Group: Pearland Date:9/30/2020 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity 329,680,692.17 329,722,567.21 100.00% 12 TOTAL PORTFOLIO 329,666,272.17 0.16 329,665,723.33 0.12 59,061.89 56,843.88 0.03 Prepared by Shamaira Jagrup 29 ,,," City of Pearland ailialalli Treasury Yield Curve Treasury 6/30/2020 7/31/2020 8/31/2020 9/30/2020 1 Month 0.13 0.11 0.08 0.09 3 Month 0.16 0.13 0.10 0.11 6 Month 0.18 0.14 0.12 0.12 1 Year 0.18 0.15 0.13 0.13 2 Year 0.19 0.15 0.14 0.13 3 Year 0.22 0.18 0.16 0.16 5 Year 0.34 0.28 0.27 0.27 10 Year 0.73 0.63 0.65 0.68 0.80 - 0.70 0.60 0.50 •6/30/2020 0.40 • 7/31/2020 0.30 •8/31/2020 0.20 •9/30/2020 0.10 _ 0.00 1 Month 3 Month 6 Month 1 Year 2 Year 3 Year 5 Year 10 Year Note 1 Note 2 Prepared by Shamaira Jagrup 30 Pledged Collateral Reconciliation Report September 30, 2020 Bank Account Ending Account Name Amount Wells Fargo 3395 Credit Card Account - Wells Fargo 2841 Sweep Account 119,659.00 * Wells Fargo 5455 False Alarm Reduction Program 286,921.87 Wells Fargo 7843 Alvin ISD 6,749,649.15 Wells Fargo 1790 EMS Payments - Wells Fargo 9871 Health Claims 392,469.45 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 2017B - * Wells Fargo 5875 Texas Permanent W&S System Revenue 2017A - Wells Fargo 6624 Escrow W&S Revenue Bonds,Series 2018A - * Wells Fargo 2847 Escrow W&S Revenue Bonds,Series 2019A - Wells Fargo 3025 Massey Oaks Easement Cost Escrow 1,000,000.00 Total of Bank Balances $ 8,548,699.47 Pledged Collateral for City 30,050,209.07 FDIC Insurance 2,000,000.00 $ 32,050,209.07 Over(Under)Collateralized $ 23,501,509.60 Total%Collateralized 374.9% Bank Account Ending Account Name Amount Wells Fargo 4258 Development Authority 13,621,035.46 Total of Bank Balances $ 13,621,035.46 Pledged Collateral for DAP 14,313,600.89 FDIC Insurance 250,000.00 $ 14,563,600.89 Over(Under)Collateralized $ 942,565.43 Total%Collateralized 106.9% Total%Collateralized 210.3% Status Collateralized *Accounts are sweeping to a higher yielding money market fund which does not require collateral.