Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
R2020-087 2020-05-18
RESOLUTION NO. R2020-87 A Resolution of the City Council of the City of Pearland, Texas, accepting the City's Investment Report for the quarter ending March 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 March 2020. PASSED, APPROVED, AND ADOPTED this 18th day of May, A.D., 2020. OYI? "y TOM REID MAYOR ATTEST: (2,4441! ,„,,,,,,,,,,„,,,,,, CRY•.TAL N. ROAN, TRMC, CMC '.R /1i0,,,,, CITY SECRETARY = O: APPROVED AS TO FORM: "..". ,,,, ,,,,,,, ,,,,,,,,,,,,,, DARRIN M. COKER CITY ATTORNEY �,�. City of Pearland Quarterly Investment Report MMUS December 31, 2019 to March 31, 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 1/31/2020 274,533,77151 274,534.388.74 -617.23 1.63 1.53 293,973.37 42 2/29/2020 249,167,237.85 249.144,363.56 22,874.29 163 1.41 351,220.18 41 3/31/2020 241,188.320.73 241.135.818.85 52.501.88 0.80 0.33 228,240.21 37 Total/Average 254,963,110.03 254,938,190.38 24,919.65 1.37 1.09 873,433.76 40 ictlti.....) 5/71'116016 Li_iluj 1/2-it nktk- t / 17:1-1: ,_ . _ / 4-3L- '-i1791-'• C thea Pearson, Di ctorr of Finance ce Date Rhonda Daugherty. Assistant Director of Finance Date Digitally signed by John Mccarter John Mccarter DN:cn=John Mccarter,o=City of Pearland, ou=Finance,email=jmccarter@pearlandtxgov,rUS 5/1/2020 , Date:2020.05.01 09:21:24-0500' ,2,111 "`l ✓Z70I2-0Z0 John McCarter, Assistant Director of Finance Date Shamaira Jagrup, re Bury Manager Date 1 0 ° "ti,� City of Pearland MIMS Distribution by Security Type - Book Value Report Group: Pearland Begin Date: 12/31/2019, End Date:3/31/2020 Security Type Allocation Book Value %of Portfolio Book Value %of Portfolio Security Type 12/31/2019 12/31/2019 3/31/2020 3/31/2020 Cash 138,499,501.73 52.61 140,810,521.60 58.39 Certificate Of Deposit 9,173,000.00 3.48 6,944,000.00 2.88 Compound CD 30,310,344.37 11.51 25,288,048.14 10.49 FAMC Bond 3,000,117.78 1.14 1,000,000.00 0.41 FHLMC Bond 996,216.90 0.38 996,802.92 0.41 FNMA Bond 1,006,015.08 0.38 1,004,498.67 0.42 Local Government Investment Pool 80,292,609.81 30.50 65,091,947.52 26.99 Total/Average 263,277,805.67 100.00 241,135,818.85 100.00 Portfolio Holdings as of 12/31/2019 Portfolio Holdings as of 3/31/2020 4 • 52.61%-Cash •• 58.39%-Cash I 3.48%-Certificate Of... 2.88%-Certificate Of... ,,„ • 1 1.5 1%-Compound CD1 1 k' • 10.49% Compound CD • 1.14% FAMC Bond >r 0.4 1% FAMC Bond • 0.38%-FHLMC Bond « 0.4 1%-FHLMC Bond 0.38%-FNMA Bond 0.42%-FNMA Bond • 30,5%-Local Governme... • 26.99%-Local Governm._ Prepared by Shamaira Jagrup 2 City of Pearland OWN Distribution by Maturity Range - Book Value `$. 00- Report Group: Pearland Begin Date: 12/31/2019,End Date:3/31/2020 Maturity Range Allocation Book Value %of Portfolio Book Value %of Portfolio Maturity Range 12/31/2019 12/31/2019 3/31/2020 3/31/2020 0-1 Month 219,536,111.54 83.39 205,902,469.12 85.39 1-3 Months 8,327,131.74 3.16 5,614,639.03 2.33 3-6 Months 5,334,328.28 2.03 13,370,395.42 5.54 6-9 Months 13,585,988.44 5.16 1,496,000.00 0.62 9-12 Months 2,502,015.08 0.95 3,510,252.09 1.46 1-2 Years 13,992,230.59 5.31 11,242,063.19 4.66 Total/Average 263,277,805.67 100.00 241,135,818.85 100.00 Portfolio Holdings 250,000 200,000 -o c 150,000 � • 12/31/2019 0 L3/31/2020 H 100,000 C 50,000 00s 0-1 M 1-3 M 3-6 M 6-9 M 9-12 M 1-2 Y Prepared by Shamaira Jagrup 3 ,„ e hiss City of Pearland IMMO Total Rate of Return - Book Value by Month Report Group: Pearland Begin Date:4/30/2019, End Date: 3/31/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 4/30/2019 224,021,812.75 420,639.00 0.00 420,639.00 214,328,263.42 0.20 2.38 2.43 5/31/2019 221,152,712.96 432,503.22 0.00 432,503.22 214,548,255.11 0.20 2.45 2.34 6/30/2019 209,887,022.59 390,803.00 0.00 390,803.00 208,783,877.46 0.19 2.27 2.00 7/31/2019 205,994,402.24 381,602.55 0.00 381,602.55 204,358,071.11 0.19 2.26 1.96 8/31/2019 203,211,850.03 396,726.57 0.00 396,726.57 217,590,574.87 0.18 2.21 1.77 9/30/2019 217,279,662.59 372,004.39 0.00 372,004.39 215,059,648.68 0.17 2.10 1.80 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 Total/Average 224,021,812.75 4,392,556.84 4,500.12 4,397,056.96 228,337,614.67 1.93 1.93 1.69 Annualized TRR-BV 2.50 jII11IiIiIuui ��'r�,;t 04/2019 05/2019 06/2019 07/2019 08/2019 09/2019 10/2019 11/2019 12/2019 01/2020 021'2020 03/2020 Prepared by Shamaira Jagrup 4 "-4. City of Pearland 4 Mikan Portfolio Holdings by Security Type r'►. ,*`' Report Group: Pearland Date:3/31/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 Cash Wells Fargo Cash 7/21/2010 645,404.53 100.00 645,404.53 0.27% None 1 WF9871 645,404.53 0.17 645,404.53 0.17 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 13,959,155.72 100.00 13,959,155.72 5.79% None 1 WFSWEEP 13,959,155.72 0.28 13,959,155.72 0.28 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 3,846,323.70 100.00 3,846,323.70 1.6% None 1 WFSWEEP 3,846,323.70 0.28 3,846,323.70 0.28 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 3,049.80 100.00 3,049.80 0% None 1 WFSWEEP 3,049.80 0.28 3,049.80 0.28 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 25,355,496.00 100.00 25,355,496.00 10.52% None 1 WFSWEEP 25,355,496.00 0.28 25,355,496.00 0.28 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 -9,758.36 100.00 -9,758.36 0% None 1 WFSWEEP -9,758.36 0.28 -9,758.36 0.28 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 78,759.92 100.00 78,759.92 0.03% None 1 WFSWEEP 78,759.92 0.28 78,759.92 0.28 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 30,979.30 100.00 30,979.30 0.01% None 1 WFSWEEP 30,979.30 0.28 30,979.30 0.28 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 42,449.02 100.00 42,449.02 0.02% None 1 WFSWEEP 42,449.02 0.28 42,449.02 0.28 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 350,291.96 100.00 350,291.96 0.15% None 1 WFSWEEP 350,291.96 0.28 350,291.96 0.28 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 1,811,139.13 100.00 1,811,139.13 0.75% None 1 WFSWEEP 1,811,139.13 0.28 1,811,139.13 0.28 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 450,809.01 100.00 450,809.01 0.19% None 1 WFSWEEP 450,809.01 0.28 450,809.01 0.28 0.00 None 0 Prepared by Shamaira Jagrup 5 City of Pearland [E1, ' Portfolio Holdings by Security Type Report Group: Pearland Date.3/31/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 812,174.20 100.00 812,174.20 0.34% None 1 WFSWEEP 812,174.20 0.28 812,174.20 0.28 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 131,403.82 100.00 131,403.82 0.05% None 1 WFSWEEP 131,403.82 0.28 131,403.82 0.28 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 753,798.50 100.00 753,798.50 0.31% None 1 WFSWEEP 753,798.50 0.28 753,798.50 0.28 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 226,599.50 100.00 226,599.50 0.09% None 1 WFSWEEP 226,599.50 0.28 226,599.50 0.28 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 46,610.56 100.00 46,610.56 0.02% None 1 WFSWEEP 46,610.56 0.28 46,610.56 0.28 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 59,622.40 100.00 59,622.40 0.02% None 1 WFSWEEP 59,622.40 0.28 59,622.40 0.28 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 25,796,832.56 100.00 25,796,832.56 10.7% None 1 WFSWEEP 25,796,832.56 0.28 25,796,832.56 0.28 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 617,672.60 100.00 617,672.60 0.26% None 1 WFSWEEP 617,672.60 0.28 617,672.60 0.28 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 595,641.60 100.00 595,641.60 0.25% None 1 WFSWEEP 595,641.60 0.28 595,641.60 0.28 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 168,559.99 100.00 168,559.99 0.07% None 1 WFSWEEP 168,559.99 0.28 168,559.99 0.28 0.00 None 0 Wells Fargo Sweep Cash 6/30/2006 48,161.24 100.00 48,161.24 0.02% None 1 WFSWEEP 48.161.24 0.28 48,161.24 0.28 0.00 None 0 Wells Fargo Sweep Cash 10/31/2006 559,993.68 100.00 559,993.68 0.23% None 1 WFSWEEP 559,993.68 0.28 559,993.68 0.28 0.00 None 0 Prepared by Shamaira Jagrup 6 .4 '''t,'.%< City of Pearland iiiiiiliatkliPortfolio Holdings by Security Type Report Group: Pearland Date:3/31/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 369,916.53 100.00 369,916.53 0.15% None 1 WFSWEEP 369,916.53 0.28 369,916.53 0.28 0.00 None 0 Wells Fargo Sweep Cash 9/1/2007 -72,436.37 100.00 -72,436.37 -0.03% None 1 WFSWEEP -72,436.37 0.28 -72,436.37 0.28 0.00 None 0 Wells Fargo Sweep Cash 12/31/2007 7,030,311.29 100.00 7,030,311.29 2.92% None 1 WFSWEEP 7,030,311.29 0.28 7,030,311.29 0.28 0.00 None 0 Wells Fargo Sweep Cash 10/30/2008 1,701,874.76 100.00 1,701,874.76 0.71% None 1 WFSWEEP 1,701,874.76 0.28 1,701,874.76 0.28 0.00 None 0 Wells Fargo Sweep Cash 9/15/2009 42,047.02 100.00 42,047.02 0.02% None 1 WFSWEEP 42,047.02 0.28 42,047.02 0.28 0.00 None 0 Wells Fargo Sweep Cash 9/15/2010 2,777,277.22 100.00 2,777,277.22 1.15% None 1 WFSWEEP 2,777,277.22 0.28 2,777,277.22 0.28 0.00 None 0 Wells Fargo Sweep Cash 4/15/2012 281,619.14 100.00 281,619.14 0.12% None 1 WFSWEEP 281,619.14 0.28 281,619.14 0.28 0.00 None 0 Wells Fargo Sweep Cash 2/1/2013 25,645.96 100.00 25,645.96 0.01% None 1 WFSWEEP 25,645.96 0.28 25,645.96 0.28 0.00 None 0 Wells Fargo Sweep Cash 11/15/2015 43,474.42 100.00 43,474.42 0.02% None 1 WFSWEEP 43,474.42 0.28 43,474.42 0.28 0.00 None 0 Wells Fargo Sweep Cash 10/15/2018 2,402,300.36 100.00 2,402,300.36 1% None 1 WFSWEEP 2,402,300.36 0.28 2,402,300.36 0.28 0.00 None 0 Wells Fargo Sweep Cash 10/15/2019 -2,072,649.35 100.00 -2,072,649.35 -0.86% None 1 WFSWEEP -2,072,649.35 0.28 -2,072,649.35 0.28 0.00 None 0 Wells Fargo Sweep Cash 10/15/2019 -4,304.52 100.00 -4,304.52 0% None 1 WFSWEEP -4,304.52 0.28 -4,304.52 0.28 0.00 None 0 Prepared by Shamaira Jagrup 7 z.t' .'t, City of Pearland , AMMAR Portfolio Holdings by Security Type ,,, Report Group: Pearland Date:3/31/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 -6,697.98 100.00 -6,697.98 0% None 1 WFSWEEP -6,697.98 0.28 -6,697.98 0.28 0.00 None 0 Wells Fargo Sweep Cash 10/15/2019 5,032.03 100.00 5,032.03 0% None 1 WFSWEEP 5,032.03 0.28 5,032.03 0.28 0.00 None 0 Wells Fargo Sweep Cash 10/15/2019 -4,701.00 100.00 -4,701.00 0% None 1 WFSWEEP -4,701.00 0.28 -4,701.00 0.28 0.00 None 0 Wells Fargo Sweep Cash 10/15/2019 -35,766.00 100.00 -35,766.00 -0.01% None 1 WFSWEEP -35,766.00 0.28 -35,766.00 0.28 0.00 None 0 Wells Fargo Sweep Cash 10/15/2019 -558,024.72 100.00 -558,024.72 -0.23% None 1 WFSWEEP -558,024.72 0.28 -558,024.72 0.28 0.00 None 0 Wells Fargo Sweep Cash 10/15/2019 -11,572.02 100.00 -11,572.02 0% None 1 WFSWEEP -11,572.02 0.28 -11,572.02 0.28 0.00 None 0 Wells Fargo Sweep Cash 12/15/2019 -188,914.64 100.00 -188,914.64 -0.08% None 1 WFSWEEP -188,914.64 0.28 -188,914.64 0.28 0.00 None 0 Wells Fargo Sweep Cash 1/15/2020 166,351.91 100.00 166,351.91 0.07% None 1 WFSWEEP 166,351.91 0.28 166,351.91 0.28 0.00 None 0 Wells Fargo Sweep Cash 1/15/2020 76.20 100.00 76.20 0% None 1 WFSWEEP 76.20 0.28 76.20 0.28 0.00 None 0 Wells Fargo Sweep Cash 1/15/2020 190,946.99 100.00 190,946.99 0.08% None 1 WFSWEEP 190,946.99 0.28 190,946.99 0.28 0.00 None 0 Wells Fargo Sweep Cash 2/15/2020 -99.99 100.00 -99.99 0% None 1 WFSWEEP -99.99 0.28 -99.99 0.28 0.00 None 0 Wells Fargo TWDB Cash 9/15/2017 10,419,379.19 100.00 10,419,379.19 4.32% None 1 WF5875 10,419,379.19 0.28 10,419,379.19 0.28 0.00 None 0 Prepared by Shamaira Jagrup 8 .. E it, CCity of Pearland Portfolio Holdings by Security Type `'' +*',b Report Group: Pearland Date: 3/31/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 TWDB Cash 11/1/2016 81,750.05 100.00 81,750.05 0.03% None 1 WF4094 81,750.05 0.28 81,750.05 0.28 0.00 None 0 Wells Fargo TWDB Cash 5/15/2018 8,753,589.52 100.00 8,753,589.52 3.63% None 1 WF6624 8,753,589.52 0.28 8,753,589.52 0.28 0.00 None 0 Wells Fargo TWDB Cash 8/6/2019 20,758,987.01 100.00 20,758,987.01 8.61% None 1 WF2847 20,758,987.01 0.28 20,758,987.01 0.28 0.00 None 0 Wells Fargo TWDB Cash 11/1/2016 1,496,286.93 100.00 1,496,286.93 0.62% None 1 WF4102 1,496,286.93 0.28 1,496,286.93 0.28 0.00 None 0 Wells Fargo TWDB Cash 3/15/2017 10,837,651.28 100.00 10,837,651.28 4.49% None 1 WF5883 10,837,651.28 0.28 10,837,651.28 0.28 0.00 None 0 140,810,521.60 140,810,521.60 58.43% 1 Sub Total Cash 140,810,521.60 0.28 140,810,521.60 0.28 0.00 0 Certificate Of Deposit 1st Security Bank of Wash 1.1 1/22/2021 7/22/2016 248,000.00 99.97 247,917.22 0.1% None 297 33625CAZ2 248,000.00 1.10 248,000.00 1.14 67.27 -82.78 None 0.81 Ally Bank Midvale Utah 1.8 6/29/2020 6/29/2017 248,000.00 100.20 248,492.14 0.1% None 90 02006L3U5 248,000.00 1.80 248,000.00 0.99 1,137.40 492.14 None 0.25 Alma Bank 1.35 12/24/2020 6/24/2016 248,000.00 100.18 248,455.36 0.1% None 268 020080BB2 248,000.00 1.35 248,000.00 1.10 64.21 455.36 None 0.73 American Eagle Bank IL 1.35 7/12/2021 7/11/2016 248,000.00 100.28 248,700.41 0.1% None 468 02554BCM1 248,000.00 1.35 248,000.00 1.13 183.45 700.41 None 1.27 Bank of New England NH 1.4 6/30/2021 6/30/2016 248,000.00 100.40 249,000.53 0.1% None 456 063847AL1 248,000.00 1.40 248,000.00 1.07 9.51 1,000.53 None 1.24 Bankers Bank Oklahoma 1.8 9/25/2020 9/25/2015 248,000.00 100.58 249,445.85 0.1% None 178 06610QCV1 248,000.00 1.80 248,000.00 0.59 73.38 1,445.85 None 0.48 Prepared by Shamaira Jagrup 9 City of Pearland Portfolio Holdings by Security Type ;t, 4+«, Report Group: Pearland Date:3/31/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 BMW Bank 2.1 6/19/2020 6/19/2015 248,000.00 100.22 248,544.49 0.1% None 80 05580ABX1 248,000.00 2.10 248,000.00 1.09 1,469.65 544.49 None 0.22 Border State Bank 1.4 6/30/2021 6/30/2016 248,000.00 100.16 248,384.44 0.1% None 456 099703EF3 248,000.00 1.40 248,000.00 1.28 9.51 384.44 None 1.24 Business Bank of St Louis MO 1.8 6/23/2021 6/23/2017 248,000.00 100.64 249,594.83 0.1% None 449 12325EHU9 248,000.00 1.80 248,000.00 1.27 97.84 1,594.83 None 1.22 Capital One NA 2.3 9/25/2020 9/23/2015 248,000.00 100.59 249,461.63 0.1% None 178 14042RAB7 248,000.00 2.30 248,000.00 1.08 93.76 1,461.63 None 0.48 Carolina Premier Bank 1.1 7/27/2020 7/27/2016 248,000.00 100.10 248,245.12 0.1% None 118 144153AW3 248,000.00 1.10 248,000.00 0.79 29.90 245.12 None 0.32 Community Bank Pasadena 1.5 6/30/2021 6/30/2016 248,000.00 100.40 248,999.86 0.1% None 456 203507BG2 248,000.00 1.50 248,000.00 1.17 10.19 999.86 None 1.24 Community Bankers'Bank 1.4 6/30/2021 6/30/2016 248,000.00 100.40 249,000.53 0.1% None 456 20361LBR4 248,000.00 1.40 248,000.00 1.07 9.51 1,000.53 None 1.24 First Business Bank 1.7 6/30/2020 9/30/2015 248,000.00 100.18 248,437.45 0.1% None 91 31938QP40 248,000.00 1.70 248,000.00 0.99 11.55 437.45 None 0.25 First National Bank of America 1.25 7/15/2016 248,000.00 99.96 247,906.57 0.1% None 471 7/15/2021 32110YHM0 248,000.00 1.25 248,000.00 1.28 645.48 -93.43 None 1.28 GNB Bank 1.56/30/2021 6/30/2016 248,000.00 100.40 248,999.86 0.1% None 456 36198JCC6 248,000.00 1.50 248,000.00 1.17 10.19 999.86 None 1.24 Gulf Coast Bank&Trust 1.3 7/15/2021-17 7/15/2016 248,000.00 100.02 248,060.16 0.1% None 15 402194EX8 248,000.00 1.30 248,000.00 1.28 141.33 60.16 None 1.28 Lincoln 1st Bank 1.4 6/30/2021 6/30/2016 248,000.00 100.40 249,000.53 0.1% None 456 53362LAB0 248,000.00 1.40 248,000.00 1.08 285.37 1,000.53 None 1.24 Prepared by Shamaira Jagrup 10 ''44, City of Pearland e 11.4444441 Portfolio Holdings by Security Type `'l Report Group: Pearland Date:3/31/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 Marine Bank Springfield IL 1.8 6/29/2021 6/29/2017 248,000.00 100.71 249,764.58 0.1% None 455 56817TAB7 248,000.00 1.80 248,000.00 1.22 24.46 1,764.58 None 1.23 Morgan Stanley Bank NA 2.8 4/5/2021 4/5/2018 248,000.00 101.56 251,857.06 0.1% None 370 61747MS69 248,000.00 2.80 248,000.00 1.25 3,386.39 3,857.06 None 0.99 National Bank Commerce Superior 1.25 7/15/2016 248,000.00 100.02 248,060.17 0.1% None 471 7/15/2021-17 633368E67 248,000.00 1.25 248,000.00 1.23 135.89 60.17 None 1.28 Pacific Continental Bank 1.25 6/30/2020 6/30/2016 248,000.00 100.09 248,222.61 0.1% None 91 69413CFD6 248,000.00 1.25 248,000.00 0.89 8.49 222.61 None 0.25 Parkside Finl Bank&Trust 1.3 7/19/2021-17 7/18/2016 248,000.00 100.03 248,073.17 0.1% None 18 70147ABX1 248,000.00 1.30 248,000.00 1.28 114.83 73.17 None 1.29 Portage County Bank 1.4 6/24/2021 6/24/2016 248,000.00 100.40 248,992.25 0.1% None 450 73565NBQ5 248,000.00 1.40 248,000.00 1.07 66.59 992.25 None 1.22 Unity Bank 1.65 10/30/2020 10/30/2015 248,000.00 100.69 249,707.28 0.1% None 213 91330ABC0 248,000.00 1.65 248,000.00 0.47 0.00 1,707.28 None 0.58 Vision Bank of Iowa 1.3 7/12/2021 7/11/2016 248,000.00 100.28 248,699.53 0.1% None 468 92834CBW1 248,000.00 1.30 248,000.00 1.08 706.63 699.53 None 1.27 Washington Federal 1.5 3/31/2021-16 3/31/2016 248,000.00 100.06 248,151.93 0.1% None 365 938828AC4 248,000.00 1.50 248,000.00 1.44 0.00 151.93 None 0.99 Wells Fargo Bank 1.75 6/17/2021 6/20/2016 248,000.00 100.40 248,980.20 0.1% None 443 9497485W3 248,000.00 1.75 248,000.00 1.42 166.47 980.20 None 1.2 6,944,000.00 6,967,155.76 2.8% 314 Sub Total Certificate Of Deposit 6,944,000.00 1.56 6,944,000.00 1.10 8,959.25 23,155.76 0.94 Compound CD East West Bank 2.54 5/4/2020 4/30/2019 5,118,639.03 100.00 5,118,639.03 2.12% None 34 CD5845 5,118,639.03 2.54 5,118,639.03 2.54 0.00 0.00 None 0.09 Prepared by Shamaira Jagrup 11 �y r City of Pearland MUNI Portfolio Holdings by Security Type `'' Report Group: Pearland Date:3/31/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 Third Coast Bank 2 3/2/2021 10/2/2019 2,009,753.42 100.00 2,009,753.42 0.83% None 336 CD38577 2,009,753.42 2.00 2,009,753.42 2.00 9,800.98 0.00 None 0.91 Third Coast Bank 2 6/2/2021 10/2/2019 2,009,753.42 100.00 2,009,753.42 0.83% None 428 CD38585 2,009,753.42 2.00 2,009,753.42 2.00 9,800.98 0.00 None 1.16 Third Coast Bank 2 7/2/2020 10/2/2019 2,009,753.42 100.00 2,009,753.42 0.83% None 93 CD38551 2,009,753.42 2.00 2,009,753.42 2.00 9,800.98 0.00 None 0.25 Third Coast Bank 2 9/2/2020 10/2/2019 5,024,383.56 100.00 5,024,383.56 2.08% None 155 CD38569 5,024.383.56 2.00 5,024,383.56 2.00 24,502.47 0.00 None 0.42 -- Third Coast Bank 2 9/2/2021 10/2/2019 4,019,506.85 100.00 4,019,506.85 1.67% None 520 CD38593 4,019.506.85 2.00 4,019,506.85 2.00 19,601.98 0.00 None 1.4 Wallis Bank 2.539 8/3/2020 4/30/2019 5,096,258.44 100.00 5,096,258.44 2.11% None 125 CD26135 5,096,258.44 2.54 5,096,258.44 2.54 21,270.25 0.00 None 0.34 25,288,048.14 25,288,048.14 10.47% 214 Sub Total Compound CD 25,288,048.14 2.22 25,288,048.14 2.22 94,777.64 0.00 0.58 FAMC Bond FAMC 1.82 11/9/2020 11/9/2017 1,000,000.00 100.96 1,009,564.90 0.41% Moodys-Aaa 223 3132X0ZC8 1,000,000.00 1.82 1,000,000.00 0.24 7,178.89 9,564.90 S&P-AA+ 0.6 1,000,000.00 1,009,564.90 0.41% 223 Sub Total FAMC Bond 1,000,000.00 1.82 1,000,000.00 0.24 7,178.89 9,564.90 0.6 FHLMC Bond FHLMC 1.1258/12/2021 9/22/2016 988,540.00 101.03 1,010,274.40 0.41% Moodys-Aaa 499 3137EAEC9 1,000,000.00 1.37 996,802.92 0.37 1,375.00 13,471.48 S&P-AA+ 1.36 988,540.00 1,010,274.40 0.41% 499 Sub Total FHLMC Bond 1,000,000.00 1.37 996,802.92 0.37 1,375.00 13,471.48 1.36 FNMA Bond FNMA 1.875 12/28/2020 9/22/2016 1,025,880.00 101.08 1,010,808.41 0.42% Moodys-Aaa 272 3135G0H55 1,000,000.00 1.25 1,004,498.67 0.41 4,843.75 6,309.74 S&P-AA+ 0.74 Prepared by Shamaira Jagrup 12 ''�, City of Pearland f. Portfolio Holdings by Security Type ,5. oo' Report Group: Pearland Date:3/31/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,025,880.00 1,010,808.41 0.42% 272 Sub Total FNMA Bond 1,000,000.00 1.25 1,004,498.67 0.41 4,843.75 6,309.74 0.74 Local Government Investment Pool Texas Class LGIP 12/20/2016 10,904,716.14 100.00 10,904,716.14 4.52% None 1 TX-01-0615-0001 10,904,716.14 1.47 10,904,716.14 1.47 0.00 None 0 Texas Class LGIP 12/20/2016 8,565,233.45 100.00 8,565,233.45 3.55% None 1 TX-01-0615-0001 8,565,233.45 1.47 8,565,233.45 1.47 0.00 None 0 Texas Class LGIP 12/20/2016 15,689.05 100.00 15,689.05 0.01% None 1 TX-01-0615-0001 15,689.05 1.47 15,689.05 1.47 0.00 None 0 Texas Class LGIP 12/20/2016 6,023.08 100.00 6,023.08 0% None 1 TX-01-0615-0001 6,023.08 1.47 6,023.08 1.47 0.00 None 0 Texas Class LGIP 1/15/2017 3,629,418.47 100.00 3,629,418.47 1.51% None 1 TX-01-0615-0001 3,629,418.47 1.47 3,629,418.47 1.47 0.00 None 0 Texas Class LGIP 1/15/2017 1,063,703.08 100.00 1,063,703.08 0.44% None 1 TX-01-0615-0001 1,063,703.08 1.47 1,063,703.08 1.47 0.00 None 0 Texas Class LGIP 1/15/2017 238,498.64 100.00 238,498.64 0.1% None 1 TX-01-0615-0001 238,498.64 1.47 238,498.64 1.47 0.00 None 0 Texas Class LGIP 5/15/2017 1,135,719.38 100.00 1,135,719.38 0.47% None 1 TX-01-0615-0001 1,135,719.38 1.47 1,135,719.38 1.47 0.00 None 0 Texas Class LGIP 5/15/2017 684,001.68 100.00 684,001.68 0.28% None 1 TX-01-0615-0001 684,001.68 1.47 684,001.68 1.47 0.00 None 0 Texas Class LGIP 5/15/2017 99,342.68 100.00 99,342.68 0.04% None 1 TX-01-0615-0001 99,342.68 1.47 99,342.68 1.47 0.00 None 0 Texas Class LGIP 9/19/2019 2,792,493.25 100.00 2,792,493.25 1.16% None 1 TX-01-0615-0007 2,792,493.25 1.47 2,792,493.25 1.47 0.00 None 0 Prepared by Shamaira Jagrup 13 , � City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date:3/31/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/19/2019 2,296,649.95 100.00 2,296,649.95 0.95% None 1 TX-01-0615-0007 2,296,649.95 1.47 2,296,649.95 1.47 0.00 None 0 Texas Class LGIP 9/19/2019 564,833.10 100.00 564,833.10 0.23% None 1 TX-01-0615-0007 564,833.10 1.47 564,833.10 1.47 0.00 None 0 Texas Class LGIP 9/15/2018 2,637,784.32 100.00 2,637,784.32 1.09% None 1 TX-01-0615-0005 2,637,784.32 1.47 2,637,784.32 1.47 0.00 None 0 Texas Class LGIP 9/15/2018 5,292,822.89 100.00 5,292,822.89 2.19% None 1 TX-01-0615-0004 5,292,822.89 1.47 5,292,822.89 1.47 0.00 None 0 Texas Class LGIP 9/15/2018 175,110.15 100.00 175,110.15 0.07% None 1 TX-01-0615-0004 175,110.15 1.47 175,110.15 1.47 0.00 None 0 Texas Class LGIP 9/15/2018 236,107.67 100.00 236,107.67 0.1% None 1 TX-01-0615-0006 236,107.67 1.47 236,107.67 1.47 0.00 None 0 TexSTAR LGIP 9/19/2019 4,409,822.95 100.00 4,409,822.95 1.83% None 1 02000-20190 4,409,822.95 0.96 4,409,822.95 0.96 0.00 None 0 TexSTAR LGIP 9/27/2019 490,505.11 100.00 490,505.11 0.2% None 1 02000-20191 490,505.11 0.96 490,505.11 0.96 0.00 None 0 TexSTAR LGIP 9/27/2019 2,508,988.18 100.00 2,508,988.18 1.04% None 1 02000-20191 2,508,988.18 0.96 2,508,988.18 0.96 0.00 None 0 TexSTAR LGIP 8/26/2016 1,663,328.77 100.00 1,663,328.77 0.69% S&P-AAA 1 02000-11110 1,663,328.77 0.96 1,663,328.77 0.96 0.00 None 0 TexSTAR LGIP 8/26/2016 1,174,278.81 100.00 1,174,278.81 0.49% S&P-AAA 1 02000-11110 1,174,278.81 0.96 1,174,278.81 0.96 0.00 None 0 TexSTAR LGIP 9/27/2019 14,506,876.72 100.00 14,506,876.72 6.02% None 1 02000-20192 14,506,876.72 0.96 14,506,876.72 0.96 0.00 None 0 Prepared by Shamaira Jagrup 14 4 "�t, City of Pearland likaitata�.. � Portfolio Holdings by Security Type ,.., .0' Report Group: Pearland Date:3/31/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 65,091,947.52 65,091,947.52 26.98% 1 Sub Total Local Government Investment 65,091,947.52 1.27 65,091,947.52 1.27 0.00 0 Pool 241,148,937.26 241,188,320.73 100.00% 36 TOTAL PORTFOLIO 241,134,517.26 0.80 241,135,818.85 0.77 117,134.53 52,501.88 0.1 Prepared by Shamaira Jagrup 15 0 "4., City of Pearland , g ,l Portfolio Holdings by Portfolio Name ti, Report Group: Pearland Date:3/31/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.18 248,455.36 0.1% None 268 020080682 248,000.00 1.35 248,000.00 1.10 64.21 455.36 None 0.73 American Eagle Bank IL 1.35 7/12/2021 7/11/2016 248,000.00 100.28 248,700.41 0.1% None 468 02554BCM1 248,000.00 1.35 248,000.00 1.13 183.45 700.41 None 1.27 Bankers Bank Oklahoma 1.8 9/25/2020 9/25/2015 248,000.00 100.58 249,445.85 0.1% None 178 06610QCV1 248,000.00 1.80 248,000.00 0.59 73.38 1,445.85 None 0.48 Capital One NA 2.3 9/25/2020 9/23/2015 248,000.00 100.59 249,461.63 0.1% None 178 14042RAB7 248,000.00 2.30 248,000.00 1.08 93.76 1,461.63 None 0.48 Carolina Premier Bank 1.1 7/27/2020 7/27/2016 248,000.00 100.10 248,245.12 0.1% None 118 144153AW3 248,000.00 1.10 248,000.00 0.79 29.90 245.12 None 0.32 Community Bank Pasadena 1.5 6/30/2021 6/30/2016 248,000.00 100.40 248,999.86 0.1% None 456 2035076G2 248,000.00 1.50 248,000.00 1.17 10.19 999.86 None 1.24 Community Bankers'Bank 1.4 6/30/2021 6/30/2016 248,000.00 100.40 249,000.53 0.1% None 456 20361LBR4 248,000.00 1.40 248,000.00 1.07 9.51 1,000.53 None 1.24 East West Bank 2.54 5/4/2020 4/30/2019 5,118,639.03 100.00 5,118,639.03 2.12% None 34 CD5845 5,118,639.03 2.54 5,118,639.03 2.54 0.00 0.00 None 0.09 Morgan Stanley Bank NA 2.8 4/5/2021 4/5/2018 248,000.00 101.56 251,857.06 0.1% None 370 61747MS69 248,000.00 2.80 248,000.00 1.25 3,386.39 3,857.06 None 0.99 Texas Class LGIP 5/15/2017 99,342.68 100.00 99,342.68 0.04% None 1 TX-01-0615-0001 99,342.68 1.47 99,342.68 1.47 0.00 None 0 Unity Bank 1.65 10/30/2020 10/30/2015 248,000.00 100.69 249,707.28 0.1% None 213 91330ABC0 248,000.00 1.65 248,000.00 0.47 0.00 1,707.28 None 0.58 Vision Bank of Iowa 1.3 7/12/2021 7/11/2016 248,000.00 100.28 248,699.53 0.1% None 468 92834CBW1 248,000.00 1.30 248,000.00 1.08 706.63 699.53 None 1.27 Prepared by Shamaira Jagrup 16 dk' 'f, City of Pearland 9, Portfolio Holdings by Portfolio Name '', °' Report Group: Pearland Date:3/31/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 Wallis Bank 2.539 8/3/2020 4/30/2019 5,096,258.44 100.00 5,096,258.44 2.11% None 125 CD26135 5,096,258.44 2.54 5,096,258.44 2.54 21,270.25 0.00 None 0.34 Washington Federal 1.5 3/31/2021-16 3/31/2016 248,000.00 100.06 248,151.93 0.1% None 365 938828AC4 248,000.00 1.50 248,000.00 1.44 0.00 151.93 None 0.99 Wells Fargo Bank 1.75 6/17/2021 6/20/2016 248,000.00 100.40 248,980.20 0.1% None 443 9497485W3 248,000.00 1.75 248,000.00 1.42 166.47 980.20 None 1.2 Wells Fargo Sweep Cash 5/31/2006 25,796,832.56 100.00 25,796,832.56 10.7% None 1 WFSWEEP 25,796,832.56 0.28 25,796,832.56 0.28 0.00 None 0 39,087,072.71 39,100,777.47 16.17% 47 Sub Total 100:General Fund 39,087,072.71 0.98 39,087,072.71 0.93 25,994.14 13,704.76 0.12 200: Debt Services Texas Class LGIP 1/15/2017 3,629,418.47 100.00 3,629,418.47 1.51% None 1 TX-01-0615-0001 3,629,418.47 1.47 3,629,418.47 1.47 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 13,959,155.72 100.00 13,959,155.72 5.79% None 1 WFSWEEP 13,959,155.72 0.28 13,959,155.72 0.28 0.00 None 0 17,588,574.19 17,588,574.19 7.3% 1 Sub Total 200:Debt Services 17,588,574.19 0.52 17,588,574.19 0.52 0.00 0 305: Hotel/Motel Occupancy Ally Bank Midvale Utah 1.8 6/29/2020 6/29/2017 248,000.00 100.20 248,492.14 0.1% None 90 02006L3U5 248,000.00 1.80 248,000.00 0.99 1,137.40 492.14 None 0.25 Bank of New England NH 1.4 6/30/2021 6/30/2016 248,000.00 100.40 249,000.53 0.1% None 456 063847AL1 248,000.00 1.40 248,000.00 1.07 9.51 1,000.53 None 1.24 Texas Class LGIP 5/15/2017 1,135,719.38 100.00 1,135,719.38 0.47% None 1 TX-01-0615-0001 1,135,719.38 1.47 1,135,719.38 1.47 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 3,846,323.70 100.00 3,846,323.70 1.6% None 1 WFSWEEP 3,846,323.70 0.28 3,846,323.70 0.28 0.00 None 0 Prepared by Shamaira Jagrup 17 e, " '' City of Pearland _ i m Portfolio Holdings by Portfolio Name ''t .+'' Report Group: Pearland Date:3/31/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 5,478,043.08 5,479,535.75 2.27% 26 Sub Total 305:Hotel/Motel Occupancy 5,478,043.08 0.64 5,478,043.08 0.59 1,146.91 1,492.67 0.07 310:Municipal Court Security Wells Fargo Sweep Cash 5/31/2006 42,449.02 100.00 42,449.02 0.02% None 1 WFSWEEP 42,449.02 0.28 42,449.02 0.28 0.00 None 0 42,449.02 42,449.02 0.02% 1 Sub Total 310:Municipal Court Security 42,449.02 0.28 42,449.02 0.28 0.00 0 315: City Wide Donation Wells Fargo Sweep Cash 5/31/2006 131,403.82 100.00 131,403.82 0.05% None 1 WFSWEEP 131,403.82 0.28 131,403.82 0.28 0 00 None 0 131,403.82 131,403.82 0.05% 1 Sub Total 315:City Wide Donation 131,403.82 0.28 131,403.82 0.28 0.00 0 320:Court Technology Wells Fargo Sweep Cash 5/31/2006 3,049.80 100.00 3,049.80 0% None 1 WFSWEEP 3,049.80 0.28 3,049.80 0.28 0.00 None 0 3,049.80 3,049.80 0% 1 Sub Total 320:Court Technology 3,049.80 0.28 3,049.80 0.28 0.00 0 330:Park Donations Wells Fargo Sweep Cash 5/31/2006 59,622.40 100.00 59,622.40 0.02% None 1 WFSWEEP 59,622.40 0.28 59,622.40 0.28 0.00 None 0 59,622.40 59,622.40 0.02% 1 Sub Total 330:Park Donations 59,622.40 0.28 59,622.40 0.28 0.00 0 331:Tree Trust Fund Wells Fargo Sweep Cash 5/31/2006 450,809.01 100.00 450,809.01 0.19% None 1 WFSWEEP 450,809 01 0.28 450,809.01 0.28 0.00 None 0 450,809.01 450,809.01 0.19% 1 Sub Total 331:Tree Trust Fund 450,809.01 0.28 450,809.01 0.28 0.00 0 332: Parks Financl Asstance Donations Prepared by Shamaira Jagrup 18 , City of Pearland E_.Ri `y'v. Portfolio Holdings by Portfolio Name Report Group: Pearland Date:3/31/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 5,032.03 100.00 5,032.03 0% None 1 WFSWEEP 5,032.03 0.28 5,032.03 0.28 0.00 None 0 5,032.03 5,032.03 0% 1 Sub Total 332:Parks Financl Asstance 5,032.03 0.28 5,032.03 0.28 0.00 0 Donations 335:Police State Seizure Wells Fargo Sweep Cash 5/31/2006 78,759.92 100.00 78,759.92 0.03% None 1 WFSWEEP 78,759.92 0.28 78,759.92 0.28 0.00 None 0 78,759.92 78,759.92 0.03% 1 Sub Total 335:Police State Seizure 78,759.92 0.28 78,759.92 0.28 0.00 0 336:Federal Police Fund Wells Fargo Sweep Cash 5/31/2006 168,559.99 100.00 168,559.99 0.07% None 1 WFSWEEP 168,559.99 0.28 168,559.99 0.28 0.00 None 0 168,559.99 168,559.99 0.07% 1 Sub Total 336:Federal Police Fund 168,559.99 0.28 168,559.99 0.28 0.00 0 340:Park&Rec Development Border State Bank 1.4 6/30/2021 6/30/2016 248,000.00 100.16 248,384.44 0.1% None 456 099703EF3 248,000.00 1.40 248,000.00 1.28 9.51 384.44 None 1.24 Wells Fargo Sweep Cash 5/31/2006 812,174.20 100.00 812,174.20 0.34% None 1 WFSWEEP 812,174.20 0.28 812,174.20 0.28 0.00 None 0 1,060,174.20 1,060,558.64 0.44% 107 Sub Total 340:Park&Rec Development 1,060,174.20 0.54 1,060,174.20 0.51 9.51 384.44 0.29 345:Sidewalk Fund Wells Fargo Sweep Cash 5/31/2006 46,610.56 100.00 46,610.56 0.02% None 1 WFSWEEP 46,610.56 0.28 46,610.56 0.28 0.00 None 0 46,610.56 46,610.56 0.02% 1 Sub Total 345:Sidewalk Fund 46,610.56 0.28 46,610.56 0.28 0.00 0 350:Grant Fund Prepared by Shamaira Jagrup 19 4 ' `,, City of Pearland ' a t3lf Portfolio Holdings by Portfolio Name '`r .`'' Report Group: Pearland Date:3/31/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 226,599.50 100.00 226,599.50 0.09% None 1 WFSWEEP 226,599.50 0.28 226,599.50 0.28 0.00 None 0 226,599.50 226,599.50 0.09% 1 Sub Total 350:Grant Fund 226,599.50 0.28 226,599.50 0.28 0.00 0 351:CDBG Fund Wells Fargo Sweep Cash 11/15/2015 43,474.42 100.00 43,474.42 0.02% None 1 WFSWEEP 43,474.42 0.28 43,474.42 0.28 0.00 None 0 43,474.42 43,474.42 0.02% 1 Sub Total 351:CDBG Fund 43,474.42 0.28 43,474.42 0.28 0.00 0 360:Traffic Impact Improvement Wells Fargo Sweep Cash 5/31/2006 617,672.60 100.00 617,672.60 0.26% None 1 WFSWEEP 617,672.60 0.28 617,672.60 0.28 0.00 None 0 617,672.60 617,672.60 0.26% 1 Sub Total 360:Traffic Impact Improvement 617,672.60 0.28 617,672.60 0.28 0.00 0 365:Court Juvenile Mgmt Wells Fargo Sweep Cash 9/15/2009 42,047.02 100.00 42,047.02 0.02% None 1 WFSWEEP 42,047.02 0.28 42,047.02 0.28 0.00 None 0 42,047.02 42,047.02 0.02% 1 Sub Total 365:Court Juvenile Mgmt 42,047.02 0.28 42,047.02 0.28 0.00 0 366:Municipal Jury Fund Wells Fargo Sweep Cash 1/15/2020 76.20 100.00 76.20 0% None 1 WFSWEEP 76.20 0.28 76.20 0.28 0.00 None 0 76.20 76.20 0% 1 Sub Total 366:Municipal Jury Fund 76.20 0.28 76.20 0.28 0.00 0 370:Municipal Channel Texas Class LGIP 5/15/2017 684,001.68 100.00 684,001.68 0.28% None 1 TX-01-0615-0001 684,001.68 1.47 684,001.68 1.47 0.00 None 0 Prepared by Shamaira Jagrup 20 .: City of Pearland laiBikiNi? Portfolio Holdings by Portfolio Name ' . Report Group: Pearland Date:3/31/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 4/15/2012 281,619.14 100.00 281,619.14 0.12% None 1 WFSWEEP 281,619.14 0.28 281,619.14 0.28 0.00 None 0 965,620.82 965,620.82 0.4% 1 Sub Total 370:Municipal Channel 965,620.82 1.12 965,620.82 1.12 0.00 0 380:Regional Detention Wells Fargo Sweep Cash 5/31/2006 30,979.30 100.00 30,979.30 0.01% None 1 WFSWEEP 30,979.30 0.28 30,979.30 0.28 0.00 None 0 30,979.30 30,979.30 0.01% 1 Sub Total 380:Regional Detention 30,979.30 0.28 30,979.30 0.28 0.00 0 500:Capital Projects Texas Class LGIP 1/15/2017 1,063,703.08 100.00 1,063,703.08 0.44% None 1 TX-01-0615-0001 1,063,703.08 1.47 1,063,703.08 1.47 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 1,811,139.13 100.00 1,811,139.13 0.75% None 1 WFSWEEP 1,811,139.13 0.28 1,811,139.13 0.28 0.00 None 0 2,874,842.21 2,874,842.21 1.19% 1 Sub Total 500:Capital Projects 2,874,842.21 0.72 2,874,842.21 0.72 0.00 0 501:Certificates of Obligation 1st Security Bank of Wash 1.1 1/22/2021 7/22/2016 248,000.00 99.97 247,917.22 0.1% None 297 33625CAZ2 248,000.00 1.10 248,000.00 1.14 67.27 -82.78 None 0.81 FHLMC 1.125 8/12/2021 9/22/2016 988,540.00 101.03 1,010,274.40 0.41% Moodys-Aaa 499 3137EAEC9 1,000,000.00 1.37 996,802.92 0.37 1,375.00 13,471.48 S&P-AA+ 1.36 FNMA 1.875 12/28/2020 9/22/2016 1,025,880.00 101.08 1,010,808.41 0.42% Moodys-Aaa 272 3135G0H55 1,000,000.00 1.25 1,004,498.67 0.41 4,843.75 6,309.74 S&P-AA+ 0.74 Gulf Coast Bank&Trust 1.3 7/15/2021-17 7/15/2016 248,000.00 100.02 248,060.16 0.1% None 15 402194EX8 248,000.00 1.30 248,000.00 1.28 141.33 60.16 None 1.28 Texas Class LGIP 12/20/2016 6,023.08 100.00 6,023.08 0% None 1 TX-01-0615-0001 6,023.08 1.47 6,023.08 1.47 0.00 None 0 Prepared by Shamaira Jagrup 21 City of Pearland PEAa;,�. Portfolio Holdings by Portfolio Name Report Group: Pearland Date:3/31/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/19/2019 564,833.10 100.00 564,833.10 0.23% None 1 TX-01-0615-0007 564,833.10 1.47 564,833.10 1.47 0.00 None 0 Texas Class LGIP 9/15/2018 236,107.67 100.00 236,107.67 0.1% None 1 TX-01-0615-0006 236,107.67 1.47 236,107.67 1.47 0.00 None 0 TexSTAR LGIP 9/27/2019 2,508,988.18 100.00 2,508,988.18 1.04% None 1 02000-20191 2,508,988.18 0.96 2,508,988.18 0.96 0.00 None 0 TexSTAR LGIP 8/26/2016 1,174,278.81 100.00 1,174,278.81 0.49% S&P-AAA 1 02000-11110 1,174,278.81 0.96 1,174,278.81 0.96 0.00 None 0 TexSTAR LGIP 9/27/2019 14,506,876.72 100.00 14,506,876.72 6.02% None 1 02000-20192 14,506,876.72 0.96 14,506,876.72 0.96 0.00 None 0 Third Coast Bank 2 9/2/2021 10/2/2019 4,019,506.85 100.00 4,019,506.85 1.67% None 520 CD38593 4,019,506.85 2.00 4,019,506.85 2.00 19,601.98 0.00 None 1.4 Wells Fargo Sweep Cash 5/31/2006 595,641.60 100.00 595,641.60 0.25% None 1 WFSWEEP 595,641.60 0.28 595,641.60 0.28 0.00 None 0 26,122,676.01 26,129,316.20 10.83% 113 Sub Total 501:Certificates of Obligation 26,108,256.01 1.15 26,109,557.60 1.08 26,029.33 19,758.60 0.32 503:Certificates of Obligation 2006 Wells Fargo Sweep Cash 6/30/2006 48,161.24 100.00 48,161.24 0.02% None 1 WFSWEEP 48,161.24 0.28 48,161.24 0.28 0.00 None 0 48,161.24 48,161.24 0.02% 1 Sub Total 503:Certificates of Obligation 48,161.24 0.28 48,161.24 0.28 0.00 0 2006 506:General Obligation Business Bank of St Louis MO 1.8 6/23/2021 6/23/2017 248,000.00 100.64 249,594.83 0.1% None 449 12325EHU9 248,000.00 1.80 248,000.00 1.27 97.84 1,594.83 None 1.22 First Business Bank 1.7 6/30/2020 9/30/2015 248,000.00 100.18 248,437.45 0.1% None 91 31938QP40 248,000.00 1.70 248,000.00 0.99 11.55 437.45 None 0.25 Prepared by Shamaira Jagrup 22 City of Pearland " Portfolio Holdings by Portfolio Name Report Group: Pearland Date:3/31/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 First National Bank of America 1.25 7/15/2016 248,000.00 99.96 247,906.57 0.1% None 471 7/15/2021 32110YHMO 248,000.00 1.25 248,000.00 1.28 645.48 -93.43 None 1.28 Lincoln 1st Bank 1.4 6/30/2021 6/30/2016 248,000.00 100.40 249,000.53 0.1% None 456 53362LAB0 248,000.00 1.40 248,000.00 1.08 285.37 1,000.53 None 1.24 National Bank Commerce Superior 1.25 7/15/2016 248,000.00 100.02 248,060.17 0.1% None 471 7/15/2021-17 633368E67 248,000.00 1.25 248,000.00 1.23 135.89 60.17 None 1.28 Texas Class LGIP 12/20/2016 15,689.05 100.00 15,689.05 0.01% None 1 TX-01-0615-0001 15,689.05 1.47 15,689.05 1.47 0.00 None 0 Texas Class LGIP 9/15/2018 2,637,784.32 100.00 2,637,784.32 1.09% None 1 TX-01-0615-0005 2,637,784.32 1.47 2,637,784.32 1.47 0.00 None 0 TexSTAR LGIP 9/19/2019 4,409,822.95 100.00 4,409,822.95 1.83% None 1 02000-20190 4,409,822.95 0.96 4,409,822.95 0.96 0.00 None 0 TexSTAR LGIP 9/27/2019 490,505.11 100.00 490,505.11 0.2% None 1 02000-20191 490,505.11 0.96 490,505.11 0.96 0.00 None 0 TexSTAR LGIP 8/26/2016 1,663,328.77 100.00 1,663,328.77 0.69% S&P-AAA 1 02000-11110 1,663,328.77 0.96 1,663,328.77 0.96 0.00 None 0 Third Coast Bank 2 7/2/2020 10/2/2019 2,009,753.42 100.00 2,009,753.42 0.83% None 93 CD38551 2,009,753.42 2.00 2,009,753.42 2.00 9,800.98 0.00 None 0.25 Wells Fargo Sweep Cash 10/30/2008 1,701,874.76 100.00 1,701,874.76 0.71% None 1 WFSWEEP 1,701,874.76 0.28 1,701,874.76 0.28 0.00 None 0 14,168,758.38 14,171,757.93 5.86% 48 Sub Total 506:General Obligation 14,168,758.38 1.17 14,168,758.38 1.14 10,977.11 2,999.55 0.13 507:General Obligation Series 2020 ; Wells Fargo Sweep Cash 10/15/2019 -2,072,649.35 100.00 -2,072,649.35 -0.86% None 1 WFSWEEP -2,072,649.35 0.28 -2,072,649.35 0.28 0.00 None 0 Prepared by Shamaira Jagrup 23 '',,4, City of Pearland iiiikakatai Portfolio Holdings by Portfolio Name ''r ,i.' Report Group: Pearland Date:3/31/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 -2,072,649.35 -2,072,649.35 -0.86% 1 Sub Total 507:General Obligation Series -2,072,649.35 0.28 -2,072,649.35 0.28 0.00 0 2020 508:Certificates of Oblg Series 2020 Wells Fargo Sweep Cash 10/15/2019 -35,766.00 100.00 -35,766.00 -0.01% None 1 WFSWEEP -35,766.00 0.28 -35,766.00 0.28 0.00 None 0 -35,766.00 -35,766.00 -0.01% 1 Sub Total 508:Certificates of Oblg Series -35,766.00 0.28 -35,766.00 0.28 0.00 0 2020 509: General Obligation Series 2021 Wells Fargo Sweep Cash 10/15/2019 -4,304.52 100.00 -4,304.52 0% None 1 WFSWEEP -4,304.52 0.28 -4,304.52 0.28 0.00 None 0 -4,304.52 -4,304.52 0% 1 Sub Total 509:General Obligation Series -4,304.52 0.28 -4,304.52 0.28 0.00 0 2021 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.28 -99.99 0.28 0.00 None 0 -99.99 -99.99 0% 1 Sub Total 512:Certificates of Oblg Series -99.99 0.28 .99.99 0.28 0.00 0 2021 514:Infrastructure Reinvestment Fund Wells Fargo Sweep Cash 12/15/2019 -188,914.64 100.00 -188,914.64 -0.08% None 1 WFSWEEP -188,914.64 0.28 -188,914.64 0.28 0.00 None 0 -188,914.64 -188,914.64 -0.08% 1 Sub Total 514:Infrastructure -188,914.64 0.28 -188,914.64 0.28 0.00 0 Reinvestment Fund 550:W/S Impact Fee BMW Bank 2.1 6/19/2020 6/19/2015 248,000.00 100.22 248,544.49 0.1% None 80 05580ABX1 248,000.00 2.10 248,000.00 1.09 1,469.65 544.49 None 0.22 Prepared by Shamaira Jagrup 24 ,; City of Pearland E. 4, `�,NU Portfolio Holdings by Portfolio Name Report Group: Pearland Date:3/31/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.96 1,009,564.90 0.41% Moodys-Aaa 223 3132X0ZC8 1,000,000.00 1.82 1,000,000.00 0.24 7,178.89 9,564.90 S&P-AA+ 0.6 Pacific Continental Bank 1.25 6/30/2020 6/30/2016 248,000.00 100.09 248,222.61 0.1% None 91 69413CFD6 248,000.00 1.25 248,000.00 0.89 8.49 222.61 None 0.25 Texas Class LGIP 12/20/2016 8,565,233.45 100.00 8,565,233.45 3.55% None 1 TX-01-0615-0001 8,565,233.45 1.47 8,565,233.45 1.47 0.00 None 0 Texas Class LGIP 9/19/2019 2,792,493.25 100.00 2,792,493.25 1.16% None 1 TX-01-0615-0007 2,792,493.25 1.47 2,792,493.25 1.47 0.00 None 0 Texas Class LGIP 9/15/2018 5,292,822.89 100.00 5,292,822.89 2.19% None 1 TX-01-0615-0004 5,292,822.89 1.47 5,292,822.89 1.47 0.00 None 0 Third Coast Bank 2 9/2/2020 10/2/2019 5,024,383.56 100.00 5,024,383.56 2.08% None 155 CD38569 5,024,383.56 2.00 5,024,383.56 2.00 24,502.47 0.00 None 0.42 Wells Fargo Sweep Cash 5/31/2006 -9,758.36 100.00 -9,758.36 0% None 1 WFSWEEP -9,758.36 0.28 -9,758.36 0.28 0.00 None 0 Wells Fargo TWDB Cash 11/1/2016 81,750.05 100.00 81,750.05 0.03% None 1 WF4094 81,750.05 0.28 81,750.05 0.28 0.00 None 0 Wells Fargo TWDB Cash 5/15/2018 8,753,589.52 100.00 8,753,589.52 3.63% None 1 WF6624 8,753,589.52 0.28 8,753,589.52 0.28 0.00 None 0 Wells Fargo TWDB Cash 8/6/2019 20,758,987.01 100.00 20,758,987.01 8.61% None 1 WF2847 20,758,987.01 0.28 20,758,987.01 0.28 0.00 None 0 Wells Fargo TWDB Cash 11/1/2016 1,496,286.93 100.00 1,496,286.93 0.62% None 1 WF4102 1,496,286.93 0.28 1,496,286.93 0.28 0.00 None 0 Wells Fargo TWDB Cash 3/15/2017 10,837,651.28 100.00 10,837,651.28 4.49% None 1 WF5883 10,837,651.28 0.28 10,837,651.28 0.28 0.00 None 0 65,089,439.58 65,099,771.58 26.97% 17 Sub Total 550:W/S Impact Fee 65,089,439.58 0.75 65,089,439.58 0.72 33,159.50 10,332.00 0.04 Prepared by Shamaira Jagrup 25 ° . City of Pearland a libeiblakii Portfolio Holdings by Portfolio Name ''* ,+•' Report Group: Pearland Date:3/31/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 551:Water Impact Fee Fund Wells Fargo Sweep Cash 1/15/2020 190,946.99 100.00 190,946.99 0.08% None 1 WFSWEEP 190,946.99 0.28 190,946.99 0.28 0.00 None 0 190,946.99 190,946.99 0.08% 1 Sub Total 551:Water Impact Fee Fund 190,946.99 0.28 190,946.99 0.28 0.00 0 552:Waste Water Impact Fee Fund Wells Fargo Sweep Cash 1/15/2020 166,351.91 100.00 166,351.91 0.07% None 1 WFSWEEP 166,351.91 0.28 166,351.91 0.28 0.00 None 0 166,351.91 166,351.91 0.07% 1 Sub Total 552:Waste Water Impact Fee 166,351.91 0.28 166,351.91 0.28 0.00 0 Fund 555:Shadow Creek Impact Wells Fargo Sweep Cash 5/31/2006 350,291.96 100.00 350,291.96 0.15% None 1 WFSWEEP 350,291.96 0.28 350,291.96 0.28 0.00 None 0 350,291.96 350,291.96 0.15% 1 Sub Total 555:Shadow Creek Impact 350,291.96 0.28 350,291.96 0.28 0.00 0 565:Revenue Bonds 1999&2003 GNB Bank 1.56/30/2021 6/30/2016 248,000.00 100.40 248,999.86 0.1% None 456 36198JCC6 248,000.00 1.50 248,000.00 1.17 10.19 999.86 None 1.24 Texas Class LGIP 1/15/2017 238,498.64 100.00 238,498.64 0.1% None 1 TX-01-0615-0001 238,498.64 1.47 238,498.64 1.47 0.00 None 0 Texas Class LGIP 9/19/2019 2,296,649.95 100.00 2,296,649.95 0.95% None 1 TX-01-0615-0007 2,296,649.95 1.47 2,296,649.95 1.47 0.00 None 0 Texas Class LGIP 9/15/2018 175,110.15 100.00 175,110.15 0.07% None 1 TX-01-0615-0004 175,110.15 1.47 175,110.15 1.47 0.00 None 0 Third Coast Bank 2 3/2/2021 10/2/2019 2,009,753.42 100.00 2,009,753.42 0.83% None 336 CD38577 2,009,753.42 2.00 2,009,753.42 2.00 9,800.98 0.00 None 0.91 Prepared by Shamaira Jagrup 26 City of Pearland i' %::, .NL Portfolio Holdings by Portfolio Name Report Group: Pearland Date:3/31/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 Third Coast Bank 2 6/2/2021 10/2/2019 2,009,753.42 100.00 2,009,753.42 0.83% None 428 CD38585 2,009,753.42 2.00 2,009,753.42 2.00 9,800.98 0.00 None 1.16 Wells Fargo Sweep Cash 5/31/2006 753,798.50 100.00 753,798.50 0.31% None 1 WFSWEEP 753,798.50 0.28 753,798.50 0.28 0.00 None 0 Wells Fargo TWDB Cash 9/15/2017 10,419,379.19 100.00 10,419,379.19 4.32% None 1 WF5875 10,419,379.19 0.28 10,419,379.19 0.28 0.00 None 0 18,150,943.27 18,151,943.13 7.51% 92 Sub Total 565:Revenue Bonds 1999& 18,150,943.27 0.85 18,150,943.27 0.85 19,612.15 999.86 0.25 2003 566:Revenue Bonds Series 2020 1 Wells Fargo Sweep Cash 10/15/2019 -558,024.72 100.00 -558,024.72 -0.23% None 1 WFSWEEP -558,024.72 0.28 -558,024.72 0.28 0.00 None 0 -558,024.72 -558,024.72 -0.23% 1 Sub Total 566:Revenue Bonds Series -558,024.72 0.28 -558,024.72 0.28 0.00 0 2020 567:Water Drinking Bonds Series 2020 Wells Fargo Sweep Cash 10/15/2019 -4,701.00 100.00 -4,701.00 0% None 1 WFSWEEP -4,701.00 0.28 -4,701.00 0.28 0.00 None 0 -4,701.00 -0,701.00 0% 1 Sub Total 567:Water Drinking Bonds -4,701.00 0.28 -4,701.00 0.28 0.00 0 Series 2020 568:Revenue Bonds Series 2021 Wells Fargo Sweep Cash 10/15/2019 -11,572.02 100.00 -11,572.02 0% None 1 WFSWEEP -11,572.02 0.28 -11,572.02 0.28 0.00 None 0 -11,572.02 -11,572.02 0% 1 Sub Total 568:Revenue Bonds Series -11,572.02 0.28 -11,572.02 0.28 0.00 0 2021 569:Revenue Bonds Series 2022 Wells Fargo Sweep Cash 10/15/2019 -6,697.98 100.00 -6,697.98 0% None 1 WFSWEEP -6,697.98 0.28 -6,697.98 0.28 0.00 None 0 Prepared by Shamaira Jagrup 27 0 "4.,, City of Pearland _ Portfolio Holdings by Portfolio Name ',, Report Group: Pearland Date:3/31/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 -6,697.98 -6,697.98 0% 1 Sub Total 569:Revenue Bonds Series -6,697.98 0.28 -6,697.98 0.28 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 100.71 249,764.58 0.1% None 455 56817TAB7 248,000.00 1.80 248,000.00 1.22 24.46 1,764.58 None 1.23 Wells Fargo Sweep Cash 12/31/2007 7,030,311.29 100.00 7,030,311.29 2.92% None 1 WFSWEEP 7,030,311.29 0.28 7,030,311.29 0.28 0.00 None 0 7,278,311.29 7,280,075.87 3.02% 16 Sub Total 570:W/S Pay As You Go 7,278,311.29 0.33 7,278,311.29 0.31 24.46 1,764.58 0.04 575:MUD 4 Capital Programs Wells Fargo Sweep Cash 2/1/2013 25,645.96 100.00 25,645.96 0.01% None 1 WFSWEEP 25,645.96 0.28 25,645.96 0.28 0.00 None 0 25,645.96 25,645.96 0.01% 1 Sub Total 575:MUD 4 Capital Programs 25,645.96 0.28 25,645.96 0.28 0.00 0 600:Water&Sewer Parkside Finl Bank&Trust 1.3 7/19/2021-17 7/18/2016 248,000.00 100.03 248,073.17 0.1% None 18 70147ABX1 248,000.00 1.30 248,000.00 1.28 114.83 73.17 None 1.29 Portage County Bank 1.4 6/24/2021 6/24/2016 248,000.00 100.40 248,992.25 0.1% None 450 73565NBQ5 248,000.00 1.40 248,000.00 1.07 66.59 992.25 None 1.22 Texas Class LGIP 12/20/2016 10,904,716.14 100.00 10,904,716.14 4.52% None 1 TX-01-0615-0001 10,904,716.14 1.47 10,904,716.14 1.47 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 25,355,496.00 100.00 25,355,496.00 10.52% None 1 WFSWEEP 25,355,496.00 0.28 25,355,496.00 0.28 0.00 None 0 36,756,212.14 36,757,277.56 15.24% 4 Sub Total 600:Water&Sewer 36,756,212.14 0.65 36,756,212.14 0.64 181.42 1,065.42 0.02 610:Solidwaste Prepared by Shamaira Jagrup 28 ��"` F City of Pearland iiiiitkaill Portfolio Holdings by Portfolio Name •1 Report Group: Pearland Date:3/31/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 369,916.53 100.00 369,916.53 0.15% None 1 WFSWEEP 369,916.53 0.28 369,916.53 0.28 0.00 None 0 369,916.53 369,916.53 0.15% 1 Sub Total 610:Solidwaste 369,916.53 0.28 369,916.53 0.28 0.00 0 700:Property Liability Ins Wells Fargo Sweep Cash 10/31/2006 559,993.68 100.00 559,993.68 0.23% None 1 WFSWEEP 559,993.68 0.28 559,993.68 0.28 0.00 None 0 559,993.68 559,993.68 0.23% 1 Sub Total 700:Property Liability Ins 559,993.68 0.28 559,993.68 0.28 0.00 0 701:Employee Benefit Fund Wells Fargo Sweep Cash 9/1/2007 -72,436.37 100.00 -72,436.37 -0.03% None 1 WFSWEEP -72,436.37 0.28 -72,436.37 0.28 0.00 None 0 -72,436.37 -72,436.37 -0.03% 1 Sub Total 701:Employee Benefit Fund -72,436.37 0.28 -72,436.37 0.28 0.00 0 702:Health Claims Fund Wells Fargo Cash 7/21/2010 645,404.53 100.00 645,404.53 0.27% None 1 WF9871 645,404.53 0.17 645,404.53 0.17 0.00 None 0 Wells Fargo Sweep Cash 9/15/2010 2,777,277.22 100.00 2,777,277.22 1.15% None 1 WFSWEEP 2,777,277.22 0.28 2,777,277.22 0.28 0.00 None 0 3,422,681.75 3,422,681.75 1.42% 1 Sub Total 702:Health Claims Fund 3,422,681.75 0.26 3,422,681.75 0.26 0.00 0 703:Motor Pool Fund Wells Fargo Sweep Cash 10/15/2018 2,402,300.36 100.00 2,402,300.36 1% None 1 WFSWEEP 2,402,300.36 0.28 2,402,300.36 0.28 0.00 None 0 2,402,300.36 2,402,300.36 1% 1 Sub Total 703:Motor Pool Fund 2,402,300.36 0.28 2,402,300.36 0.28 0.00 0 Prepared by Shamaira Jagrup 29 a I "y, City of Pearland Wg p Portfolio Holdings by Portfolio Name Report Group: Pearland Date.3/31/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 241,148,937.26 241,188,320.73 100.00% 36 TOTAL PORTFOLIO 241,134,517.26 0.80 241,135,818.85 0.77 117,134.53 52,501.88 0.1 Prepared by Shamaira Jagrup 30 ''��. City of Pearland & 9 Treasury Yield Curve 5tt , Treasury 12/31/2019 1/31/2020 2/29/2020 3/31/2020 1 Month 1.55 1.53 1.58 0.37 3 Month 1.57 1.55 1.54 0.30 6 Month 1.58 1.56 1.51 0.30 1 Year 1.55 1.53 1.41 0.33 2 Year 1.61 1.52 1.33 0.45 3 Year 1.63 1.52 1.31 0.50 5 Year 1.68 1.56 1.32 0.59 10 Year 1.86 1.76 1.50 0.87 2.00 1.80 1.60 -- 1.40 1.20 • 12/31/2019 1.00 • 1/31/2020 0.80 2/29/2020 0.60 r 3/31/2020 0.40 0.20 0.00 i 1 Month 3 Month 6 Month 1 Year 2 Year 3 Year 5 Year 10 Year Note 1 Note 2 Prepared by Shamaira Jagrup Center Footer 31 Pledged Collateral Reconciliation Report March 31, 2020 Bank Account Ending Account Name Amount Wells Fargo 3395 Credit Card Account - Wells Fargo 2841 Sweep Account 22,057.00 * Wells Fargo 5455 False Alarm Reduction Program 286,661.80 Wells Fargo 7843 Alvin ISD 13,568,970.27 Wells Fargo 1790 EMS Payments - Wells Fargo 9871 Health Claims 645,404.53 Wells Fargo 4094 Escrow W&S Revenue Bonds, Series 2016B - * Wells Fargo 4102 Escrow W&S Revenue Bonds, Series 2016C - * Wells Fargo 5883 Texas Permanent W&S System Revenue 2017B - * Wells Fargo 5875 Texas Permanent W&S System Revenue 2017A - * Wells Fargo 6624 Escrow W&S Revenue Bonds, Series 2018A - Wells Fargo 2847 Escrow W&S Revenue Bonds, Series 2019A - * Total of Bank Balances $ 14,523,093.60 Pledged Collateral for City 19,056,417.09 FDIC Insurance 1,000,000.00 $ 20,056,417.09 Over(Under)Collateralized $ 5,533,323.49 Total%Collateralized 138.1% Bank Account Ending Account Name Amount Wells Fargo 4258 Development Authority 978,018.59 Total of Bank Balances $ 978,018.59 Pledged Collateral for DAP 817,014.82 FDIC Insurance 250,000.00 $ 1,067,014.82 Over(Under)Collateralized $ 88,996.23 Total%Collateralized 109.1% Total%Collateralized 136.3% Status Collateralized * Accounts are sweeping to a higher yielding money market fund which does not require collateral.