Loading...
R2020-042 2020-02-24RESOLUTION NO. R2020-42 A Resolution of the City Council of the City of Pearland, Texas, accepting the City's Investment Report for the quarter ending December 2019. 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 December 2019. PASSED, APPROVED, AND ADOPTED this 24' day of February, A.D., 2020. ': �), P TOM REID MAYOR TEST: ez `,`��NNIIIIN/j�i STAL N. ROAN, TRMC, CMC `����F•r.•'"• l�'�� CITY SECRETARY : �. • '' `�` . ,, ; APPROVED AS TO FORM: V DARRIN M. COKER CITY ATTORNEY City of Pearland Quarterly Investment Report September 30, 2019 to December 31, 2019 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 10/3112019 229,552.124.24 229,560,489.49 -8,365,25 1.87 1.61 376,327.12 76 1113012019 228,106,128.14 228,112,974.54 -6,646.40 1.73 1.57 328,809.89 67 1213112019 263,269,565.89 263,277,805.67 -8,239.78 1.68 1.55 419,707.34 49 Total/Average 240,309,272.76 240,317,089.90 •7,817.14 1.76 1.58 1,124,844.35 63 Rhonda Daugherty, Director of Finance 1IZi&ZtiZc-) f J ht WcCarter, Assistant Director of Finance Date Shamaira Jagru , Treasury Analyst Date City of Pearland Distribution by Security Type - Book Value Report Group: Peariand Begin Date: 913012019, End Date: 1213V2019 qj 41.26% -Cash 5,13% -Certificate Of.,. 4D 6,53% -Compound CD • 1,29%-FAMC Bond • 0,43%-FFCB Bond 0,43% -FHLB Bond 0 1,59%-FHLMCBond 0 0,43% -FNMA Bond 42,89% -Local Governm.,. 0 5 2.61 %-Cash 3,48% -Certificate Of,,, 41 1 1.51% -Com pound CD * 1,14 %-FAMC Bond • 0%-FFCB Bond 096 -FHLB Bond 0 0,38%-FHLMC Bond ! 0.38% -FNMA Bond 30.5% -Local Governme... Prepared by Shamaira Jagrup 1 of 1 Book Value % of Portfolio Book Value % of Portfolio Security Type 9/3012019 9/3012019 12/3112019 12/31/2019 Cash 95,632,738.46 41.26 138,499,501.73 52.61 Certificate Of Deposit 11,901,000.00 5.13 9,173,000.00 3.48 Compound CD 15,139,816.63 6.53 30,310,344.37 11.51 FAMC Bond 3,000.320.00 1.29 3,000,117.78 1.14 FFCB Bond 1,000,000.00 0.43 0.00 0.00 FHLB Bond 1,000,000.00 0.43 0.00 0.00 FHLMC Bond 3,690,880.98 1.59 996,216.90 0.38 FNMA Bond 1,007,548.33 0.43 1,006,015.08 0.38 Local Govemment Investment Pool 99,394,273.85 42.89 60,292,609.81 30.50 Total 1 Average 231,766,578.25 100.00 263,277,805.67 100.00 Portfolio HoldingSof 9/30/2019 '• • • Holdings as of 12131/2019 qj 41.26% -Cash 5,13% -Certificate Of.,. 4D 6,53% -Compound CD • 1,29%-FAMC Bond • 0,43%-FFCB Bond 0,43% -FHLB Bond 0 1,59%-FHLMCBond 0 0,43% -FNMA Bond 42,89% -Local Governm.,. 0 5 2.61 %-Cash 3,48% -Certificate Of,,, 41 1 1.51% -Com pound CD * 1,14 %-FAMC Bond • 0%-FFCB Bond 096 -FHLB Bond 0 0,38%-FHLMC Bond ! 0.38% -FNMA Bond 30.5% -Local Governme... Prepared by Shamaira Jagrup 1 of 1 City of Pearland ' Distribution by Maturity Range - Book Value Report Group: Pearland Begin Date: 913012019. End Date: 12/31/2019 00 0-1 Month 1-3 Months 3-6 Months 6-9 Months 9-12 Months 1-2 Years 2-3 Years Prepared by Shamaira Jagrup 1 of 1 Book Value % of Portfolio Book Value % of Portfolio Maturity Range 9130/2019 9/30/2019 12/3112019 12/31/2019 0-1 Month 196.019,012.31 84.58 219,536,111.54 83.39 1-3 Months 1,488,000.00 0.64 8,327,131.74 3.16 3-6 Months 9,038,616.29 3,90 5,334,328.28 2,03 6-9 Months 5,301,869.79 2.29 13,585,988.44 5.16 9-12 Months 6,519,650 55 2.81 2,502,015.08 0.95 1-2 Years 12,399,429.31 5.35 13,992,230.59 5.31 2-3 Years 1,000,000.00 0.43 0.00 0.00 Total I Average 231,766,578.25 100.00 263,277,805.67 100.00 Portfolio Holdings 250,000 200,000 - v 150,000 - — 09/30/2019 a 100,000 12%31/2019 c 50,000 00 0-1 Month 1-3 Months 3-6 Months 6-9 Months 9-12 Months 1-2 Years 2-3 Years Prepared by Shamaira Jagrup 1 of 1 City of Pearland Total Rate of Return - Book Value by Month Report Group: Pearland Begin Date: 113112019, End Date: 12/31/2019 Month Beginning BV + Accrued Interest Interest Earned During Period -BV Realized GainlLoss-BV Investment Income -BV Average Capital Base -BV TRR-BV Annualized TRR-BV Treasury 1 Year 1131/2019 230,840,491.15 458.546.59 0.00 458.546.59 238.851,349.56 0.19 2.33 2.58 2/28/2019 245,314,107.68 427.343.46 0.00 427.343.46 236.179.061.59 0.18 2.19 2.55 3131/2019 227,434,896.03 427.655.70 0.00 427.655.70 226.531,402.89 0.19 2.29 2.49 413012019 224,021,812.75 420.639.00 0.00 420.639.00 214.328.263.42 0.20 2.38 2.43 5(3112019 221,152,712.96 432.503.22 0.00 432.503.22 214.548,255.11 0.20 2.45 2.34 613012019 209,887,022.59 390.803.00 0.00 390.803.00 208.783,877.45 0.19 2.27 2.00 7131/2019 205,994,402.24 381.602.55 0.00 381.602.55 204.358,071.11 0.19 2.26 1.96 8(3112019 203,211,850.03 396.726.57 0.00 396,726.57 217.590,574.87 0.18 2.21 1.77 913012019 217,279,662.59 372.004.39 0.00 372,004.39 215.059,648.68 0.17 2.10 1.80 10131/2019 231,853,468.53 376.327.12 0.00 376.327.12 237.221,420.07 0.16 1.92 1.61 11130(2019 229,649,559.76 328.809.89 4,500.12 333,310.01 228,812,115.02 0.15 1.76 1.57 12131/2019 228,220,514.83 419.707.34 0.00 419.707.34 246.753,579.54 0.17 2.06 1.55 3.00 2.50 2.00 1.50 1.00 0.50 0.00 01/2019 02/2019 03/2019 04/2019 05/2019 06/2019 07/2019 08/2019 09/2019 10/2019 11/2019 12/2019 Portfolio Treasury 1 Year Prepared by Shamaira Jagrup 1 of 1 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date. 12f31;2019 Gash Wells Fargo Gash 772112010 452069.70 100.00 452,069.7D 0.17% None 1 WF9871 452.069.70 0.49 452,069.70 0.49 000 None 0 Wells Fargo Sweep Cash 5131/2006 21,914.379.95 100.00 21,914,379.95 8.32% None 1 WFSWEEP 21.914.379.95 1.50 21.914.379.95 1.50 0.00 None 0 Wells Fargo Sweep Cash 5;3172006 1,370.048.88 100 00 1,370,048.88 0.52% None 1 WFSWEEP 1,370,048.158 1.50 1,370,048.86 1.5D 0.00 None 0 Wells Fargo Sweep Cash 5131120D6 -5,244,49 100.D0 -5,244.49 0% None 1 WFSWEEP -5,244.49 1.50 -5,244.49 1.50 0 OO None 0 Wells Fargo Sweep Cash 513112006 24,876,082.77 100 DO 24,876.082.77 9.45% None 1 WFSWEEP 24,876,082.77 1.51) 24,876,082.77 1.50 O.DO None 0 Wells Fargo Sweep Cash 5+31,2006 2,885.807 33 100.00 2.885.807.33 1.1% None 1 WFSWEEP 2,885.807 33 1-50 2,885,807.33 1,50 O.DO None 0 Wells Fargo Sweep Cash 513112006 1.002.44 100.00 1,002.44 0% None 1 WFSWEEP 1.00244 150 1.002.44 1.50 0.00 None 0 Wells Fargo Sweep Cash 5,31120D6 777.514.79 100.00 777,514.79 0.3°% None 1 WFSWEEP 777.514 79 1.5D 777,514.79 1.50 0.00 None 0 Wells Fargo Sweep Cash 573112006 123.438.09 100.00 123.438.09 0.05? None 1 WFSWEEP 123,438.09 1.5D 123,438 09 1.50 0.00 None 0 Wells Fargo Sweep Cash 5,3112005 83.20901 100,00 83.209.01 0.03% None 1 WFSWEEP 83.209,01 1.50 83.209.01 1,50 0-00 None 0 Wells Fargo Sweep Cash 513112006 492,192.55 100.00 -492.192.55 -0.19% None i V%IFSWEEP 492.192.55 1.5D 492,192.55 1.50 0.00 None 0 Wells Fargo Sweep Cash 513112006 1,992.991.20 100.DO 1,992,991.20 0.76% None 1 WFSWEEP 1.992,991.20 1.50 1,992.991.20 1.50 0.00 None 0 Prepared by Shamaira Jagrup 1 of 11 ` City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 12/31/2019 Wells Fargo Sweep Cash 513112006 39.202.75 100. DO 39,202.75 0.01% None 1 WFSWEEP 39,202.75 1.5D 392D2.75 1.5D 0.00 None 0 Wells Fargo Sweep Cash 5/3112006 464.778.07 100.00 464,778.07 0.18% None 1 WFSWEEP 464.778.07 1.50 464.778.07 1.50 0.00 None 0 Wells Fargo Sweep Cash 5.13112006 66.982.67 100.00 66.982.67 0.03% None 1 WFSWEEP 66,982.67 1,50 66.98267 1.50 0.00 None 0 Wells Fargo Sweep Cash 513112DD6 46,451.47 100.00 46,451.47 0.02% None 1 WFSWEEP 46.451.47 15p 46.451.47 1.50 0.00 None 0 Wells Fargo Sweep Cash 5x31.12006 174.996.48 100.00 174.996.48 0.07% None 1 WFSWEEP 174.996.48 1.5D 174.996.48 1.50 0.00 None 0 Wells Fargo Sweep Cash 513112066 428.877.27 100.00 428.877.27 0.16`.•% None 1 WFSWEEP 428.877 27 1.50 428,877.27 1.5D O.DO None 0 Wells Fargo Sweep Cash 5131.12006 13,890.840.57 100.00 13.890.840.57 5.28% None 1 WFSWEEP 13,890,640.57 1.50 13,890,840.57 1.50 000 None 0 Wells Fargo Sweep Cash 513112006 96.748.71 100.00 96.748.71 0.04% None 1 WFSWEEP 96.748.71 1.5D 96.748.71 1.50 O.OD None 0 Wells Fargo Sweep Cash 5131/2006 615,564.43 100.00 615.564.43 0.239,, None 1 WFSWEEP 615.564.43 1.5D 615.564.43 1.50 O.00 None 0 Wells Fargo Sweep Cash 5/3112006 1,209,242.19 100, OD 1,209,24Z 19 0.46% None 1 WFSWEEP 1,2.09.24219 1.50 1,209.242.19 1.50 0.00 None 0 Wells Fargo Sweep Cash 613012006 48,507.70 100.00 48,507.7D 0.02% None 1 WFSWEEP 48.507.70 1.5D 48,507.70 1.50 0, OD None 0 Wells Fargo Sweep Cash 10+3112006 729,767.78 100.00 729.767.78 0.28% None 1 WFSWEEP 729.767.78 1.5D 729.767.78 1.50 0.00 None 0 Wells Fargo Sweep Cash 121112006 984.826.84 tOD.DD 984.826.84 0.37% None 1 WFSWEEP 984.826 84 1.5D 984.82684 1 50 0.00 None 0 Prepared by Shamaira Jagrup 2 of 11 Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP Welts Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP Prepared by Shamaira Jagrup City of Pearland Portfolio Holdings by Security Type Report Group: Pearland -0.01% 91112007 -35,492.40 100.00 -35,492.40 -35.49240 1.50 -35,492.40 1.50 None 0.00 12131,2007 7,008.466.00 1 DD D0 7.008.466.00 7.008,466.00 1.50 7,008.466.00 150 None 0.07% 10130,2006 1,896.412.86 100 DO 1,896.412,66 1,896,412.86 1.50 1,896.412.86 1.50 None O OD 9115/2009 45,350.19 100.00 45,350.19 45.350.19 150 45.350.19 1.50 None -0.45% 9115/2010 2,769.169.40 100.00 2,769,169.40 2.769.169.40 1.50 2,769.169.40 1.60 None 0.00 4115/2012 183,156 91 100.00 183.156.91 183.156 91 1,50 183.156 91 1.50 21112013 25.558.43 100.00 25,558.43 25,558.43 1.50 25,558.43 1.50 1111512015 155,562.26 100.00 155,562.26 155.562.26 1.50 155,56226 1.50 10115/2018 2,301,271.28 100.00 2,301.271.28 2,301.271.28 1.50 2,301.271.28 1.50 12'1512018 47,104.86 100 OD 47,104.86 47,104.88 1.50 47.104.88 1.50 10,1512019 -1,174,328.30 100.00 -1,174.328.30 -1,174,328.30 1.50 -1,174,329.30 1.50 10,15, 2D 19 -2.152.26 100.00 -2.152.26 -2,152.26 1.50 -2.152.26 1.50 10,151'2019 3434.85 100.00 3.434.85 343485 1.50 3.434.85 1.50 -0.01% None 0.00 None 2.66°% None 0.00 None 0.72% None 0.00 None 0.02°% None 000 None 1.05% None O.DO None 0.07% None 000 None 0.01% None 0 O None 0.06% None O OD None 0.87% None 0.00 None 0.02% None 0.00 None -0.45% None O.00 None 0°% None 0.00 None 0% None 0.00 None Date: 12±31;2019 1 4 1 0 1 0 1 D 1 0 1 0 1 0 1 0 3 of 11 Melts Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP Welts Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP Welts Fargo TWD6 Cash WF5875 Wells Fargo TWDS Cash WF4094 Wells Fargo TWD8 Cash WF6624 Wells Fargo T ND8 Cash WF2847 Wells Fargo TWD8 Cash WF4102 Wells Fargo TVJDB Cash WFS883 Sub Total Cash Prepared by Shamaira Jagrup City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 12/3112019 4 of 11 1011512019 -3,348.99 100.00 -3.318.90 0% None 1 -3,348.99 1.50 -3,348.99 1.5D O.OD None 0 1011512019 -5.786.01 100.00 -5,786.01 0% None 1 •5.786.01 1.50 -5.786.01 1.50 0.00 None 0 1011512019 -31,222.57 100.00 -31,222.57 -0.01% None t -31,222.57 1.50 -31,222.57 1,50 0.00 None 0 10115?2019 -17,883.00 1D0.00 -17,883.DD -0.01% None 1 -17.883.00 1.50 -17,883.00 1.50 O.OD None 0 1011512019 -2,350.50 100.00 -2,350.50 0% None 1 -2.350.50 1.50 -2,350.50 1.50 O -DD None 0 12/1512019 -103.377.09 100.00 •103.377.09 -0.04% None 1 -103.377.09 1.50 -10337709 1.50 0.00 None 0 911512017 10,387,654.61 100.00 10,387,654.61 3.95% None 1 10,387,654.61 1.50 10,387,654.61 1.50 000 None 0 111112016 81,501.14 100.00 81,501.14 0.03% None 1 81.501.14 1.50 81,501.14 1.50 0.00 None 0 511512018 8,726,936.87 100.00 8,726.936.87 3.319: None 1 8,726.936.87 1.50 8,726.936.87 1.50 0.00 None 0 81612019 20,695,773.62 100.90 20,695,773.62 7.86°"x, None 1 20,695.773.62 1.50 20,695.773.62 1.50 0.00 None 0 111112016 1,967,542.34 100.00 1,967,542.34 0.75% None 1 1,967,542.34 1.50 1,967.542.34 1.50 0.00 None 0 311512017 10,804,653.16 100. DO 10,804,653.16 4,1% None 1 10,804,653.16 1.50 10,804,653.16 1.50 0 D None 0 138,499,501.73 138,499,501.73 52,62% 1 138,499,501.73 1.50 138,499,501.73 1.5D 0.00 0 4 of 11 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Dale: 1 21 3112 01 9 Cartiflcate Of Deposit 1st Security Bank of Wash 1.1 112212021 7722/2016 248,000.00 99.41 246.529.79 0.09% None 388 33625CAZ2 248.000.00 1.1 D 248,000.00 1.67 6727 -1,47021 None 1 05 Ally Bank Midvale Utah 1.8 6;2912020 6729/2017 248.000.00 100. D7 248.174.23 0,09% None 181 02006L3U5 248.000.00 1.80 248.000.00 1.66 24.46 174.23 None 0.49 Alma Bank 1.35 1212412020 6124/2016 248.000.00 9970 247.250.69 0.09% None 359 020080BB2 248A00.DD 1.35 248.000.00 1.65 64.21 -749.31 None 0-98 American Eagle Bank IL 1.35 711212021 7/1112015 248,000.00 99.72 247.295.98 0.09% None 559 025548CM1 248.000.00 1.35 248,000.00 1.54 183.45 -70402 None 1.52 Bank Leumi USA 1.3 2(2612020 31312016 248.000.00 100.04 248.088.95 0.09% None 57 063248FH6 248.000.00 1.3D 248.000.00 1.06 1.121.78 88.95 None 0.15 Bank of New England NH 1.4 6130.12021 613012016 248.000.00 99.87 247,684.56 0.09% None 547 063847AL 1 248.000 00 1.40 248.000 00 1.49 9.51 -31544 None 1.48 Bankers Bank Oklahoma 1.8 912512020 9/25/2015 248.000 DD 100.44 249.094.97 0.09% None 269 06610QCV1 248,000.1)0 180 248.000.00 1.20 73.38 ............. 1.094.97 None 0.73 Bankwest, Inc. 1.5 1.1312020 3/412015 248,000.00 100.00 247,997.46 0.09% None 3 06652CFA4 248,000.00 1.50 248.000 00 1.63 285.37 -254 None 0 O1 BMW Bank 2.1611912020 6119)2015 248.000.00 100.15 248.373.76 0.09% None 171 05580ABX1 248.000 00 2.10 248.00000 1.77 171.22 373.76 None 0.47 Border State Bank 1 4 613012021 613012016 248.000 00 99.58 246.950.89 0.09% None 547 099703EF3 248,1700 00 1.40 248.000, DO 1,69 9.51 •1.049.11 None 1.48 Business Bank of St Louis MO 1.8 612312021 612312017 248,000.00 100.17 248,417.28 0.09% None 540 12325EHU9 248000.DD 1,130 248.001).00 1.69 97.84 41728 None 1 46 Capital One NA 2.3 9/2512020 912312015 248.000.00 100.44 249.095.21 0,09% None 269 14042RAB7 248.000.00 2.30 248.000.00 1.69 1,515.66 1,095.21 None 0.73 Prepared by Shamaira Jagrup 5 of 11 Carolina Pramser Bank 1.1 7/27/2020 144153AW3 Charter Bank 1.7 2125.+2020 161164BE7 Community Bank Pasadena 1.5 613012021 203507BG2 Community Bankers' Bank 1.4 613WO21 20361LBR4 Discover Bank 2 2125/2020 254672JA7 Exchange Bank NEB 1.05 1/2112020 301074C H 1 First Business Bank 1,7 613012020 31938OP40 First Intl Bank 8 Trust 1,6 1!16!2020 32057GAE9 First National Bank of America 1.25 711512021 32110YHMO GNB Bank 1.5 61130/2021 36198JCC6 Goldman Sachs Bank 2 212512020 38148JLL3 Gulf Coast Bank 8 Trust 1.3 7115x2021-17 402194EXB City of Pearland Portfolio Holdings by Security Type Report Group: Pearland 712712016 248,000.00 248.000 00 1.10 248,OD0.00 2/2512015 248.000.00 248,000.00 1.71) 248,000.00 6130/2016 248.000,00 248.000.00 11.50 248.000.00 248.000.00 248.000.00 248,000 00 248,000.00 248.000. DD 248,000. DD 248,000.00 248.000.00 248.000, 00 613072016 248,000.00 140 248.000.00 212512015 248.000.00 2.DD 248.000.00 712012016 248.000.00 1.05 248.000 00 9130/2015 248.000.00 1.70 248,000.00 1011612015 248.000.00 1.60 248,000 00 711512016 248.000.00 1.25 248.000.00 8130/2016 248,000.00 1.50 248.000.00 212512015 248.000. DO 2.00 248,000.00 711512016 248.000 00 1.30 248.000.DD 99.81 247.524.22 1 44 29.90 100.01 248.027.21 1.63 69.30 99.87 247.684 80 1.59 10.19 99.87 247,684.56 1.49 9.51 100.06 248.138-72 1.62 1.739.40 9997 247.917.46 1 64 7848 100.02 248051 11 1.66 1,062.66 100.00 247,997.57 1.62 163.07 99.34 246.353.87 1.69 1.435.34 99.87 247.684.8D 1.59 10 19 100.06 248.138.72 1.62 1.739.40 99.73 247,328.24 1.48 141.33 Date: 12x31112019 0.09` None 209 -475.76 None 057 0,09% None 6 27.21 None 0.15 0.099:, None 547 •315.20 None 1.48 0.09% None 547 -315 44 None 148 0.09% None 56 138.72 None 0.15 0.091;1 None 21 -82.54 None 006 0.09`1, None 182 51 11 None 0.5 0.09% None 16 -243 None 0.04 0.09% None 562 -1.646.13 None 1.52 0.09% None 547 -315.20 None 1.46 0.09% None 56 138.72 None OAS 0.09% None 15 •671.76 None 1.52 Prepared by Shamaira Jagrup 6 of 11 City of Pearland Portfolio Holdings by Security Type Report Group: Peariand Date: 1213112019 JP Morgan Chase Bk NA Columbus 2.1 21'1,5;201,1 245,000.00 110D.06 245.150.35 0.09% None 15 211512021-17 48126XVW2 245,000.00 2.10 245.000.00 2.05 225.53 150.35 None t 1 Lincoln 1st Bank 1.4 r �30t2021 613012016 248A00.00 99.87 247,684.57 0.09% None 547 53362LASO 248,000.00 1.40 248,000.00 1.49 285.37 -315.43 None 48 Machias Sawngs Bank 1.65 21612020 21612015 248,000.00 100.()6 248.140.48 0,09% None 37 554479DS1 248.000.00 1.65 248,000.00 1.07 280.27 140.48 None 01 Marine Bank Springfield IL 1.8 6129/2021 6/2912017 248.000.00 100.24 248.602.14 0,09% None 546 56817TAB7 248.000.00 1.80 248.000 00 1.64 24.46 602.14 None 1.48 Morgan Stanley Bank NA 2.8 41512421 47572018 248.000.00 101.4D 251,481.59 0.09% None 461 61747MS69 248.000.00 2.80 248,000.00 1.67 1.655.15 3.481.59 None 1.24 National Bank Commerce Supenor 1.25 711512016 248,000.00 99.73 247,328.55 0.09% None 562 711512021-17 63336BEB7 248,000.DD 1.25 248,000.1)0 1.43 135.89 -671.45 None 1.53 Pacific Continental Bank 1,25 650f2020 613012016 248.000 D0 99. B5 247,631 14 0.09% None 182 69413CF06 248,000.00 1.25 248,000.00 1.55 8.49 368.86 None 0.5 Parkside Finl Bank 8 Trust 1.3 7,1912021-17 7118/2016 248,000.00 99.73 247,321.34 0,09%, None 18 70147ABX1 248,000.00 1.30 248,000.00 1.48 114.83 -678.66 None 1.54 Portage County Bank 1.4 612412021 612412016 248.000.00 99.88 247 690.98 0.09% None 541 73565NB05 248.000.00 1.40 248.000.00 1.49 66.59 -309.02 None 1.47 Unity Bank 1,65 1013012020 1073012015 248.000.00 10050 249.234.24 0.09% None 3D4 91330ABCD 248.000.00 1.65 248.00200 1.05 0.00 1,23424 None 0.83 Vision Bank o1 Iowa 1.3 7/12/2021 711172016 248.000.00 99.72 247,297.55 0.09% None 559 92834CBW1 248,000.00 1.30 248,000.00 1.49 1,528.09 -702.45 None 1.51 Washington Federal 1.53!3112021-16 3/31/2016 248.00&D0 100.00 248.011.70 0.09% None 456 938828AC4 248.000 00 1.50 248.000.00 1.50 0.00 1170 None 1.24 Prepared by Shamaira Jagrup 7 of 11 Compound CD City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 12;31;2019 Description Face Arriount., Settlement Data Cost Value Market Price Market Value Portfolio Credit Rating Days To CalliMaturity CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Ga4n]Loss Credit Rating Duration To Maturity Wells Fargo Bank 1.75 611712021 6/20/2016 248,000.00 99.88 247.899 20 QA9`> None 534 94974B5W3 248 000.00 1.75 248,000.00 1 83 66 47 -300 BO None 1.44 9,173,000.00 9,170.758.88 3,33% 310 Sub Total Certificate Of Deposit 9,173.000.00 1.58 9,173,000.00 1.55 14,603.77 -2,24112 0.95 Compound CD East West Bank 2 54 514+2020 413012019 5,086,328.28 100.OD 5.086.328 79 1.93'::6 None 125 CD5845 5.086.328.28 2.54 5,086,328.28 2.54 0, DO O OD None 034 East West Bank 2.56 312/2020 4/3012019 2.034,805.61 100.00 2,034,805.61 0.77% None 62 CDO940 2,034.805.61 2.56 2,034.805.61 2.56 0.00 0.00 None 0.17 East West Bank 2 56 302020 4130/2019 3.052.208 35 10000 3,052.208 35 1.16% None 62 CDO940 3.052,208,35 2.56 3,052.20B.35 2.56 0.00 0.00 None 0.17 Third Coast Bank 2 3/212021 10,72019 2,009,75342 100 -OD 2,009,753.42 0.76% None 427 C038577 2.009,753.42 2.00 2.009.753.42 2.00 9.911,11 0,00 None 115 Third Coast Bank 2 6/212021 101212019 2,009.753.42 100.00 2.009.753.42 0.76% None 519 CD38585 2,009.753.42 2.DD 2.009.753.42 2.00 9,911.11 0.00 None 1.4 Third Coast Bank 2 71212020 101212019 2,009.753 42 100.00 2,009,753.42 0.76% None 1 B4 CD38551 2.009,753.42 2.00 2.009.753.42 2.00 9,911.11 O.00 None 0.5 Third Coast Bank 2 91212020 101212019 5,024,383.56 100 DO 5.024.383.56 1.91% None 246 CD38569 5,024,383.56 2.00 5.024,383.56 200 24.777.78 0.00 None 0.67 Third Coast Bank 2 9.(M021 1012/2019 4,019,506.95 100.00 4,019.506.85 1.53% None 6 t 1 CD38593 4,019,506.85 2.00 4,019,506.85 2.00 19,822.23 0.00 None 164 Wallis Bank 2.539 8/3/2020 413012019 5,063.851.46 100.00 5,063,851.46 1.92° None 216 CD26135 5,063,851.46 2.54 5.063.851.46 2.54 21,487.24 0.00 None 0.59 30,310,344.37 30,310,344.37 11.5% 264 Sub Total Compound CD 30,310,344.37 2.27 30,310,344.37 2.27 95,820.58 0.00 0.71 FAMC Bond 111111L. - Prepared Prepared by Shamaira Jagrup 8 of 11 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 12;31/2019 FAMC 1.675 2t2412020 2+2412017 1,001.200.00 100,00 1,000,011.07 0.38% htoodys-Aaa 55 3132XOPW5 1,000.000.00 1.63 1,000,058.89 1.66 5.909.03 -47.82 S8P-AA+ 015 FAMC 1.6752'2412020 212412017 1,001.20000 100.00 1,000.011.07 0.38% Mood, ys-Aaa 55 3132XOPW5 1.000.000,00 1.63 1.000,058.89 1.66 5.909.03 137.82 S&P -AA* 0.15 FAMC 1.82 111912020 111912017 1,000.000.00 10013 1,001,268 66 0.38% Moodys-Aaa 314 3132XOZC8 1,000 000 DO 1.82 1,000,000.OD 1,67 2.628.89 1.268.66 S8P-AA+ 085 3135GOH55 1.000,000.00 1.25 3,002.400.00 1.63 3,001,290.80 1.14% S&P -AA+ 141 Sub Total FAMC Bond 3,000.000.00 1.70 3,000,117.78 1.66 14,446.95 1,173.02 0.38 FHLMC Bond 1,000,000.00 1.25 1,006,015.08 1.63 156.25 •3,577.83 0.99 FHLMC 1.125 &'121'2021 9+2212016 988.540 00 99.26 992.623 05 0.381110 Moodys-Aaa 590 3137EAEC9 1,000,000 GD 1.37 996216 90 1.59 4 187.50 •3.593.85 S&P -AA* 1.6 988,540.DO 992,623.05 0.38% 590 Sub Total FHLMC Bond 1,000.000.00 1.37 996,216.90 1.59 4.187.50 -3,593.85 1.6 FNMA Bond FNMA 1.875 /212812020 9/2212016 1,025,880.00 100.24 1,002,437.25 0.38% Moodys-Aaa 363 3135GOH55 1.000,000.00 1.25 1,006.015 08 1.63 156.25 -3,577.83 S&P -AA+ 0.99 1,025,880.00 1,002,437.25 0.38% 363 Sub Total FNMA Bond 1,000,000.00 1.25 1,006,015.08 1.63 156.25 •3,577.83 0.99 Local Government Investment Pool Texas Class LGIP 1212012016 10,858,802.67 100.00 10,858.802.67 4.12% None 1 TX -01-0615-0001 10,858.802 6T 1.88 10,858,802.67 1.88 0.00 None 0 Texas Class LGIP 1212012016 10,521,081.37 100.00 10,521,081.37 4% None 1 TX -01-0615-0001 10,521,081.37 1.88 10,521,081.37 1.88 0. OD None 0 Texas Class LGIP 1212012016 15.622.99 100.00 15.622.99 0.01% None 1 TX -01-0615.0001 15.622.99 1.88 15.622.99 1.88 0.00 None 0 Texas Class LGIP 1212012016 5,997.71 100.00 5.997.71 0% None 1 TX -01-0615.0001 5.997.71 1.B8 5997,71 1 8B 0.00 None 0 Prepared by Shamaira Jagrup 9 of 11 Texas Class LGIP TX -01.0615.0001 Texas Class LGIP TX -01-0615.0001 Texas Class LGIP TX -01-0615-0001 Texas Class LGIP TX -01-D615-0001 Texas Class LGIP TX -01-D615-0001 Texas Class LGIP TX -01-0615-0001 Texas Class LGIP Tx -01-0615.0007 Texas Class LGIP TX -01-0615-0007 Texas Class LGIP TX -01-0615.0007 Texas Class LGIP TX -01-0615-0005 Texas Class LGIP TX -01-D615-0004 Texas Class LGIP TX -01-0615.0004 Texas Class LGIP TX -01-0615-0006 Prepared by Shamaira Jagrup City of Pearland Portfolio Holdings by Security Type Report Group: Pearland 9/1512018 1715/2017 3,614,137.08 100.00 3.614.137.08 3,614,137 08 1 88 3,614,137.08 1.88 1,233.689.54 1.68 1.231689 54 1!15/2017 1,059.224.44 100.00 1,059.224.44 1.059.224.44 1.88 1.059,224.44 1.88 None 0.04% 1/1512017 237.494.46 100 DO 237.494,46 237.494.46 1.88 237.494.46 1. B8 91512017 1,130,937.52 1 DO. DO 1,130.937.52 1,130.937.52 1.88 1,130,937.52 1.88 511512017 681.121.75 100.00 681,121.75 681.121.75 1.88 681.121.75 1.88 5/1512017 98.924.43 100,00 98,924.43 98.824,43 1.68 98,924.43 1.88 911912019 2.778,353.42 100.00 2,778.353,42 2,778,353.42 1.BB 2,778,353.42 1.88 911912019 5,774.616.90 100.00 5,774,616.90 5,774,616.90 1.88 5.774,616.90 1.B8 911912019 1,559.000.51 100 -DO 1,559.000.51 1,559.000.51 1.88 1,559.000 51 1.68 911512018 2,626,678.10 100 00 2,626,678.10 2,626.678 10 1. 9B 2.626.678 10 1 B8 9/75/2018 5,265,994.84 100 DO 5,265.994.84 5,265,994.84 1.88 5.265,994.84 1.88 9/1512018 4,170,313-00 100.00 4,170,313.00 1.88 4,170,313.00 1.88 911512018 1,233.689.54 t00.OD 1,233.689.54 1.68 1.231689 54 1.88 Date: 12/3112019 1.37% None 0.00 None 0.4% None OM None 0.09% None 0.00 None 0.43% None 0.00 None 026% None 0. DO None 0.04% None 0.00 None 1,06% None 0.00 None 2.19% None 0.00 None 0,59% None 0.00 None 1% None 0.00 None 2% None 0.00 None 1 0 1 0 i 0 1 0 1 0 i 0 1 0 1 0 t 0 T 0 1 0 4,170.313.00 1.58% None 1 0.00 None 0 1,233.689.54 0,47% None 1 0-00 None 0 10 of 11 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 12!3112019 TexSTAR LGIP 9119!2019 6,390,043.37 100.00 6.390.043 37 2.43% None 1 02000-20190 6.390.043 37 1.56 6,390,043.37 1.56 ODD None 0 TexSTAR LGIP 9/2712019 488.477.07 100 D0 488-477.07 0,19°% None 1 02000.20191 488.477.07 1.56 488.477.07 1.56 0.00 None 0 TexSTAR LGIP 91272019 4,495.982, B5 100.00 4,495.982.85 1.71% None 1 02000-20191 4,495.982.85 1.56 4,495.982.85 1.56 0.00 None 0 TexSTAR LGIP 8/2612016 1,657,731.27 100.00 1,657,731.27 0.63% S&P -AAA 1 02000-11110 1,657.731.27 1.56 1,657,731.27 1.56 0.00 None 0 TexSTAR LGIP 812612016 1,170.327.08 100.00 1,170,327.08 0.44% S&P -AAA 1 02000.11110 1,170.327.08 1.56 1,170,327.08 1.56 0.00 None 0 TexSTAR LGIP 912712019 14.458.057.44 100.00 14.458.057.44 5.49% None 1 02000-20192 14,458.057.44 1.56 14,458.057.44 1.56 0-00 None 0 80.292,609.81 80.292,609.81 30.5% 1 Sub Total Local Government Investment 80,292.609.81 1.77 80,292.609.81 1.77 0.00 0 Pool 263,292,275.91 263.269,565.89 100.00% 47 TOTAL PORTFOLIO 263,275,455.91 1.67 263,277,805.67 1.66 129.215.05 -8,239.78 0.13 Prepared by Shamaira Jagrup 11 of 11 100: General Fund Alma Sank 1.35 1212412020 0200BOBB2 American Eagle Bank IL 1.35 7112/2021 02554BCM1 Bank Leumi USA 1.3 21261202D 063248FH6 Bankers Bank Oklahoma 1.8 9125/2020 06610QC V 1 Capital One NA 2.3 912512020 14042RAB7 Carolina Premier Bank 1.1 7;2712020 144153AW3 Community Bank Pasadena 1.5 6/3012021 2035078G2 Community Bankers' Bank 1.4 6130'2021 20361LBR4 East West Bank 2.54 514!2020 I -- East West Bank 2 56 3.1212020 CD0940 Exchange Bank NEB 1.05 112112020 301074CH1 FAMC 1.675 2124/2020 3132XOPW5 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 12.311'2019 99.70 6/2412016 248,000.00 248.000.00 1.35 248,000.00 64.71 7/1112016 248,000.00 248.000.00 1.35 248.000.00 0.09% 313/2016 248.000,00 248.000.00 1.30 248,000,00 None 912512015 248,000.00 248.000.00 1 B 248,000. DO 57 912312015 248.000-00 248.000.00 2.3D 248,000.00 100.41 7127/2016 248.000 00 248.000 00 1.10 248.000 00 73.38 613012016 248.000 00 248,000.00 1.50 248.000.DD 0.09% 613012016 248,000.00 248,000.00 1.40 248,000.00 None 413012019 5.086.328.28 5.086.328.28 2.54 5.086.328.28 209 413012019 3,052.208 35 3,052.208 35 2.56 3,052,208-35 99.67 712012018 248,000.00 248.000.D0 1.05 248.000.00 1019 2124/2017 1,001.2 DO.00 1,000.000.00 1.63 1,0M058.89 Date: 12.311'2019 99.70 247,250.69 0.091% None 359 1.66 64.71 -749.31 None 098 99.72 247.295.98 0.09% None 559 1.54 183.45 -704.02 None 1.52 100, D4 248.088.95 0.09% None 57 1.06 1.121.78 88.95 None 0.15 100.41 249.094.97 0.09% None 269 1.20 73.38 1.094.97 None 0.73 100.44 249.095.21 0.09% None 269 1.69 1.515.B6 1,095.21 None 0.73 99.81 247.524.22 0.09`M None 209 144 29.90 -475.78 None 0-57 99.67 247.684.80 0.09% None 547 1.59 1019 -31520 None 1.48 99.87 247,684.56 0.09% None 547 1.49 9.51 -315-44 None 148 100.00 5,086.326.28 1.93% None 125 2.54 0.00 0.00 None 0.34 100.00 3,052.208.35 1.16% None 62 2,56 0.00 0.00 None 0.17 99.97 247,917.46 0.09% None 21 1.64 78.48 -82.54 None 006 100.00 1,000.011.07 0.38% Moodys-Aaa 55 1.66 5.909.03 47.82 S&P -AA- 0.15 Prepared by Shamaira Jagrup 1 of 15 JP Morgan Chase Bk NA Columbus 2.1 211512021-17 48126XVW2 Machias Savings Bank 1.65 216/2024 -A-MO� Morgan Slantey Bank NA 2.8 45+2021 61747MS69 Texas Class LGiP TX -01-0615.0001 Unity Bank 1,65 1013012020 91330ABCO Vision Bank of Iowa 1.3 7/1212021 92834CBW1 Wallis Bank 2.539 81312020 CD26135 Washington Federal 1.5 313112021.16 938828AC4 Wells Fargo Bank 1.75 611712021 9497485W3 Wells Fargo Sweep Cash WFSWEEP Sub Total 100: General Fund City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland 100.06 245.150.35 2.05 225.53 100.06 1.07 101.40 1.67 100.00 1.88 100 50 1.05 99.72 1.49 100.00 2.54 10000 1.50 99.88 1.B3 100.00 1.50 1.94 248,140.48 280.27 251.481.59 1,655.15 98,924.43 249.234.24 0.00 247,297.55 1,528.09 5,063,851.46 21,487-24 Date: 12/3112019 0.09% 211512017 245,000.00 245,000.00 2.10 245,000.00 140.48 21612015 248,000.00 248.000.D0 1.65 248,000.01) 0.04% 41512018 248.000.00 248,000.00 2.80 248,000.00 1.234.24 5/1512017 98.924.43 98 924 43 1.68 98.924.43 1.92% 10/3012015 248.000.00 248,000.DO 1.65 248,000.DO 711112016 248,000.00 248.000.00 1.30 248.000.00 413012019 5.063.851.46 5,063,851.46 2.54 5.063.851.46 313112016 248.000. DO 248,000.00 1.50 248.000.00 6,2012016 248.000.1)0 248,000.00 1.75 248.000.00 513112006 13,890.640.57 13,890.840.57 1.50 13,890.840.57 32,158,353.09 32,157,153.09 1.95 32,157,211.98 100.06 245.150.35 2.05 225.53 100.06 1.07 101.40 1.67 100.00 1.88 100 50 1.05 99.72 1.49 100.00 2.54 10000 1.50 99.88 1.B3 100.00 1.50 1.94 248,140.48 280.27 251.481.59 1,655.15 98,924.43 249.234.24 0.00 247,297.55 1,528.09 5,063,851.46 21,487-24 Date: 12/3112019 0.09% None 150.35 None 0.09% None 140.48 None 0.0946 None 3,481.59 None 0.04% None 0.00 None 0109% None 1.234.24 None 0.09% None -702.45 None 1.92% None 0.00 None {5 11T 37 0.1 461 1.24 1 D 304 0.83 559 1 51 216 0.59 248,011.70 0.09% None 456 0-00 11.70 None 1.24 247.699.20 0.09% None 534 16647 -30060 None 1.44 1:3,890.840.57 5.28% None i 0.00 None 0 32.160,816.11 12.15% 102 34,338.54 3,604.13 0.28 200: Debt Services Charter Bank 1.7 2125!2020 212512015 248 000.00 100.01 248.027.21 0.09% None 56 161164BE7 248.000.00 1.7D 248.000.00 1 63 69 30 2771 None 0.15 Prepared by Shamaira Jagrup 2 of 15 Discover Bank 2 212512020 254672JA7 Goldman Sachs Bank 2 22512020 38148JLL3 Texas Class LGIP Tx -01-0615-0001 Wells Fargo Sweep Cash WFSWEEP City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland 26,272,517.03 100.06 21252015 248,000.00 248.000.00 2.00 248,000.00 1.62 212512015 248.000 00 248.000 00 2.00 248.000.00 100 00 111512017 3,614,137.08 3,614.137.08 1.88 3.614,137,OB Ally Bank Midvale Utah f.B 6/29/2020 513ti2006 21,914,379.95 21,914.379.95 150 21,914,379.95 26,272,517.03 100.06 248.138.72 1.62 1,739.4D 100.06 248.136.72 1.62 1.739.40 100 DO 3,614.137.08 1.88 100 00 21,914,379.95 1.50 26,272.821.68 0.09% 13872 0.09% 138.72 1,37°} 0.00 8.32% 0, OD 9.96% None None None None None None None None Date: 12/31/2019 56 015 56 0.15 1 0 1 0 3 Sub Total 200: Debt Services 26,272,517,03 1.57 26,272.517,03 1.56 3,548.10 304.65 0 305: Hotel/Motel Occupancy Ally Bank Midvale Utah f.B 6/29/2020 &2912017 248,000.DD 100 07 248.174.23 0.09% None '81 02006L3U5 248.000.00 1.80 248.000.DO 1.66 24.46 174.23 None 049 Bank of New England NH 1.4 613012021 613012016 248.000.00 99.87 247.684.56 0.09% None 547 063847ALl 248.000.00 1.40 248.000.00 1.49 9.51 -315-44 None 1.48 East West Bank 2.56 3/212020 4/3012019 2.034 805.61 100, DO 2.034.805 61 0.77% None 62 CDO940 2,034,805,61 2.56 2,034-805.61 2.56 0.00 0.00 None 0.17 First Intl Bank 8 Trust 1.6 111612020 10116/2015 248.000.00 100.00 247,997.57 0.09% None 16 32057GAE9 248,000.00 1.60 248,000.00 1.62 163.07 -2.43 None 0.04 Texas Class LGIP 51152017 1,130.937.52 100.00 1,130,937.52 0.43% None t TX -01-0615.0001 1,130,937.52 1,88 1,130,937.52 1.88 0.00 None 0 Wells Fargo Sweep Cash 513112006 1,370,048.88 100DO1,370,048.88 0.52% None 1 WFSWEEP 1,370.048.88 1.50 1.370.048.88 1.50 0.00 None 0 5,279.792.01 5,279,648.37 1.99% 59 Sub Total 305: Hotel/Motel Occupancy 5,279,792.01 2.01 5,279,792.01 2.00 197.04 -143.64 0.16 310: Municipal Court Security Prepared by Shamaira Jagrup 3 of 15 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date. 12131/2019 Wells Fargo Sweep Cash 5131+2006 39,202.75 100 DO 39.202.75 0.01`.ya None 1 WFSWEEP 39.202.75 1 5D 39.202.75 1 5D 000 None 0 39,202.75 39,202.75 0.01% 1 Sub Total 310: Municipal Court Security 39,202.75 1.50 39,202.75 1.50 0.00 0 315: City Wide Donation Wells Fargo Sweep Cash 513112096 123,438.09 100.01) 123.438 09 0.05':' None 1 WFSWEEP 123.438.09 1.50 123,438.09 1.50 0.00 None 0 123,438.09 123,438.09 0.05% 1 Sub Total 315: City Wide Donation 123,438.09 1.50 123,438,09 1.50 0.00 0 320: Court Technology Wells Fargo Sweep Cash 513'12006 -5,244 49 100.00 -5.244.-* 0% None 1 WFSWEEP -5,244.49 1 50 -5.244.49 1.50 non None D -5,244.49 -5.244.49 011: 1 Sub Total 320: Court Technology -5,244.49 1.50 -5,244.49 1.50 0.00 0 330: Parte Donations Wells Fargo Sweep Cash 513'12006 66,982.67 100.00 66.992.67 0.03` None 1 'aVFSWEEP 66,982.6. 1 50 66,982.67 1.50 0 OD None 0 66,982.67 66.982.67 0.03% 1 Sub Total 330: Park Donations 66.982.67 1.50 66,982,67 1.50 0.00 0 331: Tree Trust Fund Wells Fargo Sweep Cash 5/31/2006 464,778 07 10D.00 464 778.07 0.18':6 None 1 WFSWEEP 464.778.07 1.5D 464.778.07 1.5D 000 None 0 464,778.07 464,778.07 0.18% 1 Sub Total 331: Tree Trust Fund 464.778.07 1.SD 464,778.07 1.50 0,00 0 332: Parks Financl Asstance Donations Wells Fargo Sweep Cash _r;1 3.434.85 100.00 3.434.85 0% None 1 WFSWEEP 4. A4 L6 1 _,. 3.434.85 1.50 000 None 0 Prepared by Shamaira Jagrup 4 of 15 Sub Total 332: Parks Flnancl Asstance 3,434.85 Donations City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland 3,434.65 1.50 3,434.85 1.50 3,434.85 Date: 12'3V2019 0% 1 0.00 0 335: Police Stab Seizure Wells Fargo Sweep Cash 5131+2006 83.209.01 100.00 83,209.01 0.03% None 1 WFSWEEP 83.209 01 1.50 83.209.01 1.50 0.00 Norc D 83,209.01 83,209.01 0.03% 1 Sub Total 335: Police State Seizure 83,209.01 1.50 83,209.01 1.50 0.00 0 336: Federal Police Fund Wells Fargo Sweep Cash 5731+2006 96.748.71 100.00 96.748.71 0,04'6 Nore WFSWEEP 96 148 .11 1.5D 9674871 1.50 D DD Wore 96,748.71 96,748.71 0.04% 1 Sub Total 336: Federal Police Fund 96,748.71 1.50 96,748.71 1.50 0.00 0 340: Park & Rec Development Border State Bank 1.4 613012021 6730/2016 248.000.00 9958 246 950.89 0 09'a None 547 099703EF3 248.000.00 1.40 248.000.00 1.69 9.51 -1,049.11 None 1.48 Wells Fargo Sweep Cash 513112006 777.514.79 100.00 777.514 79 0.3% None 1 WFSWEEP 777.5t4 79 1.50 777,514.79 1 5D 0.00 None 0 1,025,514.79 1,024,465.68 0,39% 133 Sub Total 340: Park & Rec Development 1,025,514.79 1.48 1,025.514.79 1,55 9151 -1,049.11 0.36 345: Sidewalk Fund Wells Fargo Sweep Cash 573'72006 46,451.47 100. DO 46.451.47 0.02% Notre 1 WFSWEEP 46 451 s, 1.50 46.451.47 1 50 0.00 None 0 46,451.47 46.451.47 0.02% 1 Sub Total 345: Sidewalk Fund 46,451 47 1.50 46,451,47 1.50 0.00 0 350: Grant: Fund Wells Fargo Sweep Cash C 174 996.48 100.00 174.996.48 0.07% Nor.0 1 WFSWEEP 174 S9r; .a= 174,99648 1 50 n nn Nore 0 Prepared by Shamaira Jagrup j! 1 ci 4 e City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 12x31;2019 Prepared by Shamaira Jagrup 80115 174.996.48 174.996.48 0.07% 1 Sub Total 350: Grant Fund 174.996:48 1.50 174.996.48 1.50 0.00 0 351: CDBG Fund =amo Sweep Cash 11;15f2015 155.562 26 100 DO 155,562.26 0.0614i None 1 562 2r; 1.50 155.562-2E 1.50 000 None 0 155.562.26 155,562.26 0.06% 1 Sub Total 351: CDBG Fund 155,562.26 1.50 155.562.26 1.50 0.00 0 360: Traffic Impact Improvement 615 564 43 no Do 615.564 <1 0.23`0 None 1 °4614:? `D 615,564-4:' 1.5D 0-00 None 0 615 563 43 61 5 564 43 0.23% 1 Sub Total 360: Traffic Impact ir,iprcvcrnent fit S 5E4.43 1.50 C,,15 564.43 1.50 0.00 0 365: Court Juvenile Mgmt - 1 <r.cr 45,350.19 0.02% None 1 a °, s:,o a :, 4 ,..,t; 0.00 None 0 45.350.19 50.15 0.02% 1 Sub Total 365: Court Juvenile Mgmt 45 350 19 1.50 45.350 19 t SO 0.00 0 370: Municipal Channal jo6, Texas Class LGiP 6111151201? 661.121.75 100.00 681,121.75 0.26 a NOW 1 U-01.0816.9001 681,121.75 1.88 881.121.75 1.88 0.00 None 0 Web Fsrpo Sweep Cash 4M V412 183,156.91 100.00 183,158.91 0.07% None 1 WFSWEEP 183.158.91 1.50 183.158:41 1.50 0.00 Nona 0 04,27!.08 q/,275.88 &32% 1 Sub Total 370: Municipal Channel 864,278.66 1,50 •84,27x.06 1,50 0.60 0 380: Reglonal Detention Wolfs Farclo Sweep Cash 5[31!2005 1.002.44 100.00 1,002,A4 0% NWO 1 WFSWEEP 100244 1.50 --002.44 1.50 0.00 None 0 1,002.44 1,0ft.44 0% 1 Sub Total 380: Regional Detention 1.002.44 1.50 1,M2.44 1.00 0.00 0 Prepared by Shamaira Jagrup 80115 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 12/3112019 500: Capital Projects Texas Class LGIP 17157201 r 1,05922.1 44 100.OD 1.059.224.44 0.4' None 1 TX -01-0615-0001 1,059.224.44 1 P.9 1,059 224 44 1.88 0 OD None 0 Wells Fargo Sweep Cash 573/72006 1,992.991.20 100.00 1,992,991.20 0.76% None t WFSWEEP 1.99Z991 20 1.50 1,992.991.20 1.50 0.00 None 0 988.540 00 9926 3,052.215.64 3,052,215.64 1.16% 1 Sud Total 500: Capital Projects 3,052,215.64 1.63 3,052,215.64 1.63 0.00 0 501: Certificates of Obligation 1st Secunty Bank of Wash 1.1 172272021 7.22+2016 248.000.00 99.41 246.529-79 OM% None 388 33625CA72 248 000 DO 1 117 248.000.00 1 67 67.27 -1.470.21 None 1_D5 FHLMC 1.125 8!1212021 972272016 988.540 00 9926 992.623.05 0.38% Moodys-Aaa 590 3137EAEC9 1,000.000 DD 1.37 996,216.90 1.59 4.187.50 -3.593.85 S&P -AA+ 1.6 FNMA 1.875 12728+2020 9+2272016 1,025,880.00 100.24 1,002.437.25 0.38% Moodys-Aaa 363 3135GOH55 1,000.000.00 1.25 1.006,015.08 1.63 156.25 -3.577.83 S&P -AA+ 099 Gulf Coast Bank & Trust 1.3 7715;2021-17 711512016 248,00&00 99.73 247,328.24 0.09% None 15 402194EX8 248.000.00 1.30 24&000.00 1.48 141.33 -671.75 None 1-52 Texas Class LGIP 1272072016 5,997.71 100.00 5.997.71 0% None 1 TX.01-0615-0001 5 997 71 1.118 5,987.71 1 B8 ODD None 0 Texas Class LGIP 9/1912019 1,559,000.51 10000 1,559.000.51 0.59% None 1 TX -01-0615-0007 1,559,000.51 1.88 1,55900051 1.88 0.00 None 0 Texas Class LGIP 911512018 1,233,669.54 100. DO 1,233,689.54 0.47% None 1 TX -01-0615-0006 1,233,689.54 1.88 1,233.689.54 1.8B 0.00 None 0 TexSTAR LGIP 912712019 4,495,982.85 10000 4,495,982.85 1.71% None 1 0200020191 4,495.982.85 1.56 4,495.982.85 1.56 0.00 None 0 TexSTAR LGIP 812612016 1,170.327.06 10000 1.170227.DB 0.44% S&P -AAA 1 02000-11110 1,170.327.08 1.56 1,170.32708 1.56 0.00 None 0 Prepared by Shamaira Jagrup 7 of 15 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 12/31/2019 TexSTAR LGIP 927;2019 14,458.057.44 100. DO 14,458.057.44 5.49% None 1 02000.20192 14,458,057.44 1.56 14,458,057.44 1.56 0.00 None 0 Third Coast Bank 2 9212021 1012+2019 4,019.506.85 /00.00 4,019.506.65 1,53% None 611 CD38593 4,019.506.85 2.OD 4.019.506.85 2.00 19.822.23 O.00 None 1.64 Welts Fargo Sweep Cash 513112DD6 1,209 242.19 100.00 1,209,242.19 0.46% None 1 WFSWEEP 1.209,242.19 1. SO 1.209.242.19 1.50 0.00 None 0 30,662.224.17 30,640.722.50 11.63% 115 Sub Total 501: Certificates of Obligation 30,647.804.17 1.63 30,650.036.15 1.65 24,374.58 -9,313.65 0.32 503: Certificates of Obligation 2006 Wells Fargo Sweep Cash 6130/2006 48 507 70 10000 48.507,70 0.02% None 1 WFSWEEP 48.507 70 1.50 4850770 1.50 0.00 None 0 48,507.70 48,507.70 0.02% 1 Sub Total 503: Certificates of Obligation 48.507.70 1.50 48,507.70 1.50 0.00 0 2006 508: General Obligation Business Bank of St Louis MO 1.8 612312021 612312017 248,000.00 00.17 248,417.28 0.09% None 540 12325EHU9 248.000.00 1 5 248.000.00 1.69 97.84 417.28 None 1.46 First Business Bank 1.7 613012020 913012015 248,000.00 100.02 248.051.11 0,096 None 182 31938OP40 248.00000 1.70 248,00000 166 1,062.66 51.11 None OS First National Bank of America 1,25 711512016 248.000 00 99 34 246.353.87 0.09% None 562 7/15/2021 3211OYHNIG 248.000,00 1.25 248.000.00 1.69 1,435.34 -1,646.13 None 1.52 Lincoln 1st Bank 1.4 6130,2021 6130.12016 248.000.00 99.87 247.684.57 0.09% None 547 53362LABO 248.000.00 1,40 248.000 00 1.49 285.37 -315.43 None 1.48 National Bank Commerce Superior 1.25 711512016 248.000 00 99.73 247.328.55 0.09% None 562 711512021.17 633368EB7 248,000 00 1.25 248,000 00 1.43 135.89 -67145 None 1.53 Texas Class LGIP 12/2012016 15.622.99 100.00 15,622.99 0.01% None 1 TX -01-D615.0001 15,622.99 1.88 15.622.99 1.88 0.00 None 0 Prepared by Shamaira Jagrup 8 of 15 ,aOlt 'torr a Texas Class LGIP TX -01-0615.0005 TexSTAR LGIP 02000.20190 TexSTAR LGIP 02000-20191 TexSTAR LGIP 02000-11110 Third Coast Bank 2 7!2!2020 CD38551 Wells Fargo Sweep Cash WFSWEEP 2.626,678.10 6.390.043.37 488.477 07 1,657.731.27 2,009.753.42 1,896,412,86 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland 91152018 1.88 911912019 1.56 9127/2019 1.56 8126x2016 1,56 1002019 2.00 10130/2008 1.50 2,626.678.10 2,626,678 10 6.390.043.37 6,390,043.37 488.477.07 488.477.07 1,657,731.27 1,657,731.27 2,009.753.42 2,009.753.42 1,896.412.66 1.896.412.66 100, DO 2.626.676.10 106 None 1.88 000 None Date: 12131;2019 100 DO 6,390.043.37 2.43% None t 1.56 6.19% 0.00 None 0 100.00 488.477,07 0.19% None 1 1.56 0.00 None 0 1DD.D0 1,657,731.27 0.63% SAP -AAA 1 1.56 0.00 None 0 100.00 2,009.753.42 0.76% None t 84 2. DO 9,911.11 0.00 None D .5 100.00 1,896,412.86 0.72% None t 1 50 000 None 0 16,324,719.08 16,322,554.46 6.19% 60 Sub Total 506: General Obligation 16,324,719.08 1.66 16,324,719.08 1.66 12,928.21 -2,164.62 0.16 $07: Gerwall Obligation Series 2020 Wells Fargo Sweep Cash 101152019 -1,174 328.30 IOD DO •1,174 328 30 (1.45'.' None 1 WFSWEEP -1.174,328,30 1.50 -1,174 328 3D 1 50 0 00 Nnre 0 -1,174,328.30 -1,174,328.30 -0.454: 1 Sub Total 507: General Obligation Series -1,174,328.30 1.50 -1,174,328.30 1.50 0.00 0 2020 508: C*Mcates of Oblg Series 2020 Wells Fargo Sweep Cash 1011572019 -17 883 W ' 00 DD -17 883 00 -0.0140 None 1 WFSWEEP -17.883. DO 1 5D -17 883 D0 1.50 0 DO Not» 0 -17,883.00 -17,883.00 -0.01%. 1 Sub Total 508: Certificates of Oblg Series -17,883.00 1.50 -17,883,00 1,50 0.00 0 2020 509: General Obligation Series 2021 ,Neils Fargo Sweep Cash 10715+2019 -2.152.26 100.00 2.152.26 0% Nate 1 hNFSWEEP -2,152.26 1.50 -2'52.26 1.50 0.00 None 0 Prepared by Shamaira Jagrup 90f 15 Sub Total S09: General Obllgation Series -2,152.26 2021 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland -2,152.26 1.50 -2,152.26 1.50 -2.152.26 Date: 1213112019 0% 1 0.00 0 511: PEDC Capital Projects Wells Fargo Sweep Cash 1211512019 47.104.88 100.00 47 104.89 0.02"b None 1 WFSWEEP 47.104 B6 1 50 47.104.88 1.50 0 00 None 0 Wells Fargo Sweep Cash 47,104.88 47,104.88 0.02% 1 Sub Total 511: PEOC Capital Projects 47.104.88 1.50 47,104.88 1.50 0.00 0 514: Infrastructure Reinvestment Fund Wells Fargo Sweep Cash 12;-5'2019 -103.377.09 100.00 -103.377.09 -0,04% None 1 WFSWEEP -103 377 09 i 5,. -103.377.09 1.50 0.00 None 0 -103,377.09 -103,377.09 -0.04% 1 Sub Total 514: Infrastructure -103,377.09 1.50 -103,377.09 1.50 0.00 0 Reinvestment Fund 550: W1S Impact Fee Bankwest, Inc 1.5 1;312020 31412015 248,000 00 10000 247.997.46 0.09% None 3 06652CFA4 248.000 00 1.50 248,000,00 1,63 285.37 -2.54 None 0.01 BMW Bank 2.1 611972020 6119/2015 248,000.00 100.15 248.373.76 0.09% None 171 05580ABX1 248.000.00 2 TO 24000.00 1.77 171 77 37376 None 047 FAMC 1.82111912020 111912017 1,000.000.00 100.13 1,001,268-66 0,38`-,': Moodys-Aaa 314 3132XOZC8 1,000.000.00 1.82 1,000,000.00 1.67 2.628.89 1,268 66 S&P -AA• 085 Pacific Continental Bank 1.25 613012020 6.13012016 248.000.00 99.85 247.631 14 0.09% None 182 69413CFD6 248,000,00 1.25 248.00000 1.55 8.49 -368.86 None 0-5 Texas Class LGIP 1212012016 10,521,081.37 100.00 10,521.081.37 4% None 1 TX -01-0615-0001 10,521,081.37 1.88 10,521.081.37 1.88 0.00 None 0 Texas Class LGIP 911912019 2,778.353.42 100.00 2,778,353.42 1.06% None 1 TX -01-0615.0007 2,778,353.42 1.88 2,778,353.42 1.86 0.00 None 0 Texas Class LGIP 9115/2018 5,265.994.84 100.00 5265,994.84 2% NofN 1 TX -01-0615.0004 5,265,994,84 1.68 5,265.994.84 1,88 0.00 None 0 Prepared by Shamaira Jagrup 10 d 15 Third Coast Bank 2 9/212020 CD38569 Wells Fargo Sweep Cash WFSWEEP Wells Fargo TWD6 Cash WF4094 Wens Fargo TWDB Cash WF6624 Wells Fargo TWDB Cash WF2947 Wells Fargo TWDS Cash WF4102 Wells Fargo TWDB Cash W F 58B3 Sub Total 550: W1S Impact Fee City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland 70,496,027.65 1,64 5,024,383.56 5,024,383.56 2.885.807.33 2,885,8D7.33 81,501 14 81,5D1.14 8,726,936.67 8,726.936.87 20,695.773.62 20,695,773.62 1,967,542 34 1,967.542.34 10,804.653,16 10,804,653.16 70,496,027.65 70,496,027.65 100.DO 1002019 5.024,383.56 2.00 100.00 513112006 2.885.807 33 1.50 MOM 11!1!2016 81,501.14 1.50 100.DO 511512D18 8,726.936 87 150 100.00 81612019 20,695.773.62 1.5D 100.00 111112016 1,967,542.34 1.50 1 OD DO 3/1512017 10,804,653.16 1 5D 70,496,027.65 1,64 5,024,383.56 5,024,383.56 2.885.807.33 2,885,8D7.33 81,501 14 81,5D1.14 8,726,936.67 8,726.936.87 20,695.773.62 20,695,773.62 1,967,542 34 1,967.542.34 10,804.653,16 10,804,653.16 70,496,027.65 70,496,027.65 100.DO 5,024.383.56 2 D 24,777 78 100.00 2,885.807.33 1.50 MOM 81.501.14 1.50 212412017 100.DO 8,726,936.67 1.50 0.38% 100.00 20,695,773.62 1.50 1,000.000.00 100.00 1,967.542.34 1.5D 5.909.03 1 OD DO 10,804,653.16 1.5D Wens Fargo Sweep Cash 70,497,298.67 1,64 27,871.75 1.91% O OD 1.1?. 0.00 0.03% 0.00 3.31% 0.00 7,86';',m 0.00 0.75% 0.00 4.1% 000 26.77% 1,271.02 None None None None None None None None None None None None None None Date: 12/31/2019 246 067 1 0 1 0 1 0 1 ti 1 0 1 0 24 0.06 555: Shadow Creek Impact FAhdC 1.675 212412020 212412017 1,001,200.DD 100, DO 1.000.011.07 0.38% Moodys-Aaa 55 3132XOPW5 1,000.000.00 1.63 1,000,058 B9 1.66 5.909.03 -4782 S&P -AA+ 0 15 Wens Fargo Sweep Cash 5131/2006 492,192.55 100.00 492,192.55 •0.19% None 1 WFSWEEP •492,192.55 1.5D -492,192.55 1.50 0.00 None 0 509,007.45 507,818.52 0.19% 107 Sub Total 555: Shadow Creek Impact 507,807.45 1.76 507,866.34 1.81 5,909.03 -47,82 0.3 565: Revenue Bonds 1999 & 2003 GNB Bank 1.5 6130+2021 613012016 248,000.00 99.87 247,684.60 0.09% None 547 36198JCC6 248.000.00 1.50 248.000.00 1.59 10.19 -315.20 None 148 Prepared by Shamaira Jagrup 11 of 15 City of Pearland el Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 12;3112019 Texas Class LGIP 1/15/2017 237.494.46 100.00 237,494.46 0.09% None 1 TX -01-0615-0001 237.494.46 1.88 237.494.46 1.88 0-00 None 0 Texas Class LGIP 911912019 5.774.616.90 100.00 5.774.616.90 2,19% None t TX -01-D615-0007 5.774.616.90 1.88 5,774,616.90 1.88 0.00 None U Texas Class LGIP 911512018 4,170.313.00 10000 4,170.313.00 1.58% None 1 TX -01-0615-0004 4,170.313.00 1.66 4,170.313.00 1.88 0.00 None 0 Third Coast Bank 2 3+•2!2021 101212019 2,009,753.42 100.00 2,009,753,42 0.76% None 427 CD38577 2.009.753 42 Z.OD 2.009.753.42 2.OD 9,911.11 0.00 None 1 15 Third Coast Bank 2 6!212021 101212019 2,009.753.42 100.00 2.009,753.42 0.76% None 5 t 9 CD38585 2,009.75342 2.OD 2.009.75342 2.00 9,911.11 0.00 None 14 Wells Fargo Sweep Cash 5/3112006 428.877, 27 100 DO 428.877.27 0.16`.• None t WFSWEEP 428.877.27 1.50 428,877.27 150 000 None U Wells Fargo TWDB Cash 9/15/2017 10,387.654.61 100, DO 10,387,654.61 3.95% None t WF5B75 10,387,1151.61 1,50 10,387.654.61 1.50 O OD Nome O 25,266.463.08 25,266,147.88 9.58% 81 Sub Total 565: Revenue Bonds 1999 8 25,266.463.08 1.73 25,266.463.08 1.74 19,832.41 -315.20 0.22 2003 566: Revenue Bonds Series 2020 Wolfs Fargo Sweep Cash 1011512019 -31,222.57 100.00 -31.222.57 •0.01% None 1 WFSWEEP -31.222.57 1.5D -31222.57 1.50 0.00 No r. t) -31.222.57 -31.222.57 -0.01% 1 Sub Total 566: Revenue Bonds Series -31,222.57 1.50 -31.222.57 1.50 OM 0 2020 567: Water Drinking Bonds Series 2020 Wells Fargo Sweep Cash 10/1512019 -2,350.50 100.DD -2.3%50 0% None 1 WFSWEEP 1.5D -2.350.50 1.50 0.00 None 0 -2,350.50 -2,350.50 0% 1 Sub Total 567. Water Drinking Bonds t_ t) 50 1.50 -2,350.50 1.50 0.00 0 Series 2020 Prepared by Shamaira Jagrup 12 of 15 City of Pearland Portfolio Holdings by Portfolio Mame Report Group: Pearland Date: 12/31/2019 568: Revenue Bonds Setles 2021 Welts Fargo Sweep Cash 1011512019 -5,786.01 100.00 -5.786.01 0% None 1 WFSWEEP -5.786.01 1.50 -5,786.01 1,50 000 None 0 Sub Total 569: Revenue Bonds Series •5,788.01 -5.786.01 0% 1 Sub Total 568: Revenue Bonds Series -5,786.01 1,50 •5,786.01 1.50 0.00 0 2021 70147ABX1 248,000.00 0 569: Revenue Bonds Series 2022 Wells Fargo Sweep Cash WFSWEEP 1011512019 -3.34899 10000 3.348 99 01:.; None -3,34899 1.50 -3-34899 1 50 0.00 None S00: Weber S Sower -3,34899 -3,348.99 0% 1 Sub Total 569: Revenue Bonds Series -3.348.99 1.50 -3.348.99 1.50 None 0.00 70147ABX1 248,000.00 0 2022 1.48 114 B3 -678.66 None 1-54 Portage County Bank 1 A 6124!2021 612412016 248.000.00 570: WIS Pay As You Go 247.690.98 0.09% None 541 73565NBQ5 248.000 DO 1.40 248.000.00 1.49 Manne Bank Springfield IL 1.8 6;29,12021 -309.02 612912017 248,000.00 100.24 248,602.14 0.09% None 546 56817TAB7 248.000 OD 1.80 248.000.00 1.64 24.46 602 14 None 1 48 Wells Fargo Sweep Cash 12131;2007 7,008,466.00 OO Of, 7,008.466.01) 2,66,- None 1 WFSWEEP 7,008.466.00 1.5D 7,008.466.00 1 50 0 00 Nore 0 7,256.466.00 7,257,068.14 2.75% 20 Sub Total 570: W1S Pay As You Go 7.256,466.00 1.51 7,256,466.00 1.51 24.46 602.14 0.05 575: MUD 4 Capital PMrams W Wells Fargo Sweep Cash 2/112013 25,558.43 'DD OC; 25.SSS.a3 n,n1' : Nope 1 WFSWEEP 25.558.43 1.50 25,558.43 1.50 O OD Nord 0 25,558.43 25,558.43 0.01% 1 Sub Total 575: MUD 4 Capital Programs 25,558.45 1.50 25,558.43 1.50 0.00 0 S00: Weber S Sower Parkside Fin1 Bank 8 Trust 1.3 7119.2021-17 7118/2016 248.000.00 99.73 241 321.34 0.09% None 18 70147ABX1 248,000.00 1.30 248.000.00 1.48 114 B3 -678.66 None 1-54 Portage County Bank 1 A 6124!2021 612412016 248.000.00 99.88 247.690.98 0.09% None 541 73565NBQ5 248.000 DO 1.40 248.000.00 1.49 66.59 -309.02 None 1.47 Prepared by Shamaira Jagrup 13 of 15 City of Pearland 7 ' T� Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 12/31/2019 Texas Class LGIP 1212012016 10.858,602.67 100.00 14858.802.67 4.12% None 1 Tx -01-0615-0001 14858,802.67 1.88 10,858,802.67 1.88 984.826.84 0.00 None 0 Wells Fargo Sweep Cash 513112006 24,876.082.77 100,00 24,876.082.77 9,45% None 1 WFSWEEP 24.876,082.77 1.50 24,876,082.77 150 0.00 0.00 None 0 984,826.64 0.37% 36,230,885.44 1 36,229,897.76 13.75% 1.50 5 Sub Total 600: Water & Sewer 36,230,885.44 1.61 36,230,885.44 1.62 181.42 -987.66 0.02 610: Solidwaste Wells Fargo Cash 7,12112010 452.069.70 Wells Fargo Sweep Cash 0.17% 12'1+2006 984.826.84 100.00 984 826.64 0 37% Nor.c 1 WFSWEEP 984.826.84 1.50 984 826.84 1 50 None 1 000 Noce 0 1 50 0.00 None 0 984,826.64 984,826.64 0.37% 1.22%. 1 Sub Total 610: Solidwaste 984.826.64 1.50 984,826.64 1.50 0 0.00 0 700: Property Liability Ins HIM Wells Fargo Sweep Ca�zh 10+31,2006 729 767 78 100 00 729.7 67.78 028°:r None 1 WFSWEEP 729.767.78 1 50 729 767.78 1 50 0,00 None 0 729,767.78 729,767.78 0.28%. 1 Suh Total 700: Property Liability Ins 729,767.78 1.50 729.767.78 1.50 0.00 0 701: Employee Benefit Fund Wells Fargo Sweep Cash 9,11,12007 -35.492.40 100 or, -35 492 40 -0.01'% None 1 WFSWEEP -35.492.40 1.50 -35,492.40 1.51) 000 None 0 -35,492.40 -35,492.40 -0.01'/ 1 Sub Total 701: Employee Benefit Fund -35,492.40 1.50 -35,492.40 1.50 0.00 0 702: Health Claims Fund Wells Fargo Cash 7,12112010 452.069.70 100.00 452.069.70 0.17% None t WF9871 452.069 70 0.49 452,069.70 0,49 0.00 None 0 Wells Fargo Sweep Cash 9+15,12010 2,769,169.40 100.00 2,769.169.40 1.05% None 1 WFSWEEP 2,769.169 40 1 50 2.769,169 40 1 50 0.00 None 0 3,221,239.10 3,221,239.10 1.22%. 1 Sub Total 702: Health Claims Fund 3,221.239.10 1.36 3,221,239.10 1.36 0.00 0 , Prepared by Shamaira Jagrup 14 of 15 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 12/31/2019 703: Motor Pool Fund tNells Fargo Sweep Cash 1011512019 2,301,271.28 100.D0 2,301,271.28 0.87% None 1 WFSWEEP 2,301,271.28 1.50 2,301,271.28 1.50 0.00 None n 2,301.271.28 2,301,271.28 0.87% 1 Sub Total 703: Motor Pool Fund 2,301,271.28 1.50 2,301,271.28 1.50 0.00 0 263,292,275.91 261269,565.89 100.00% 47 TOTAL PORTFOLIO 263,275,455.91 1.67 263,277,805.67 1.68 129,215.135 -8,238.78 0.13 Prepared by Shamaira Jagrup 15 of 15 City of Pearland Treasury Yield Curve Treasury 9/30/2019 12/3112019 1 Month 1.99 1.55 3 Month 1.94 1.57 6 Month 1.90 1.58 1 Year 1.80 1.55 2 Year 1.65 1.61 3 Year 1.59 1.63 5 Year 1.57 1.68 10 Year 1.70 1.86 2.00 1.80 1.60 1.40 1.20 1.00 0.80 0.60 0.40 0.20 0.00 1 Month 3 Month 6 Month 1 Year 2 Year 3 Year 5 Year 10 Year 9x'30'• 201y A 12/31/2019 Prepared by Shamaira Jagrup 1 of 1 Pledged Collateral Reconciliation Report December 31, 2019 Bank Account Ending Account Name Amount Wells Fargo 3395 Credit Card Account - Wells Fargo 2841 Sweep Account 115,971.00 " Wells Fargo 5455 False Alarm Reduction Program 286,441.38 Wells Fargo 7843 Alvin ISD 9,480,934.50 Wells Fargo 1790 EMS Payments - Wells Fargo 9871 Health Claims 452,069.70 Wells Fargo 4094 Escrow W&S Revenue Bonds, Series 20168 - " Wells Fargo 4102 Escrow W&S Revenue Bonds, Series 2016C - ' Wells Fargo 5883 Texas Permanent W&S System Revenue 20178 - ' 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 S 10,335,416.58 Pledged Collateral for City 16.042,490.53 FDIC Insurance 500,000.00 S 16,542,490.53 Over (Under) Collateralized S 6,207,073.95 Total % Collateralized 160.1% Bank Account Ending Account Name Amount Wells Fargo 4258 Development Authority 1,009,559.68 Total of Bank Balances S 1,009,559.68 Pledged Collateral for DAP 816,683.21 FDIC Insurance 250,000.00 S 1,066,683.21 Over (Under) Collateralized S 57,123.53 Total % Collateralized 105.7% Total % Collateralized 155.2% Status Collateralized ' Accounts are sweeping to a higher yielding money market fund which does not require collateral_