Loading...
RDAP 2020-04 2020-09-28RESOLUTION NO. RDAP 2020-04 A RESOLUTION OF THE DEVELOPMENT AUTHORITY OF PEARLAND (DAP), ACCEPTING THE INVESTMENT REPORT FOR THE QUARTERS ENDING SEPTEMBER 2019, DECEMBER 2019, MARCH 2020, AND JUNE 2020. BE IT RESOLVED BY DAP BOARD OF DIRECTORS: Section 1. That the Development Authority of Pearland, TX hereby accepts the Investment Report for the Quarters ending September 2019, December 2019, March 2020, and June 2020. PASSED, APPROVED, AND ADOPTED this 28th day of September , A.D. 2020. DAP CHAIRMAN ATTEST: DAP SECRETARY Development Authority of Pearland Quarterly Investment Report June 30, 2019 to September 30, 2019 's prepared for the Development Authority of Peariand in accordance with Chapter 2256 of the Public Funds Investment Act (PFIA). 1.023 (a) of the PFIA states that "Not less than quarterly, the investment officer shall prepare and submit to the governing body of written report of the investment transactions for all funds covered by this chapter for the preceding reporting period." This report is le Investment Officer and includes the disclosures required in the PFIA. th Market Value Book Value Unrealized Gain/Loss YTM @ Cost Treasury 1 Year Interest Earned Days To Maturity 19 962,471.69 19 17,278,576.79 19 8,324,601.95 962,471.69 17,278,576.79 8,324.601.95 0.00 0.00 0.00 0.22 1.11 0.40 1.96 1.77 1,80 181.94 1 666.26 1 2,590.67 1 le 8,855,216.81 8,855,216.81 0.00 0.85 1.84 3.438.87 i I Lt01-11A — . 0 a� son, yector of Fi ance Date l0— Irup, Treasury Analyst Date umbt, &�� -- 1 �2 1 Rhonda Daugherty, AYsistant erector of Finance Date port reflects entries through Period 12, and does not include any year-end entries. Security Type City of Pearland Distribution by Security Type - Book Value Report Group: Development Authority Book Value 613012019 Cash 12,388 84 Money Market 951,400.91 Total 1 Average 963,789.75 Portfolio Holdings as of 6/30/2 19 0 1.29% -Cash 0 98.71% -Money Mari:e.. 613012019 Begin Date: 6130/2019, End Date: 9130/2019 Book Value 9/3012019 l: of Portfolio 9/30/2019 1 29 1,157, 701.53 13.91 98.71 7,166,900.42 86.09 100.00 8,324,601.95 100.00 Portfolio Holdings as of 9/3012019 * 13.9196 Cash 86.09% -Money Marks! maira Jagrup iofI Maturity Range 0-1 brl[inII) rota) / Average City of Pearland Distribution by Maturity Range - Book Value Report Group: Development Authority RangeMaturity • • Book Value %of Portfolio 6/3012019 613012019 963,789 75 963,789.75 1n0 00 100.00 Begin Date: 613012019, End Date: 913012019 Book Value % of Portfolio 9!3012019 9130/2019 r3.324.601.95 8.324.601.95 11-1 Month inn nr, 100.00 I0 6/30/2019 0 9/30/2019 maira Jagru p toff City of Pearland J Total Rate of Return - Book Value by Month Report Group: Development Authority Begin Date: 1013112018, End Date: 9/30/2019 ith Beginning BV + Accrued Interest Interest Earned During Period -BV Realized Investment Average Capital Gain/loss-BV Annualized Treasury 1 Income -BV Base -BV TRR-BV TRR-BV Year 118 6,640,175.07 3.307.92 0.00 3,307.92 6,638,917.62 0.05 0.60 2.65 18 6,641,189.99 2.239.66 0.00 2.239.66 4,258,256.66 0.05 0.63 2.70 18 2,175,429.65 1.920.77 0.00 1,920.77 2.175,429.65 0.09 1.06 2.66 19 2,177,350.42 2.047.31 0.00 2,047.31 2,176,527.84 0.09 1.13 2.58 19 2,177,897.73 2.181.46 0.00 2,181.46 2,119,924.59 0.10 1.24 2.55 19 2,064,132.91 1,999.04 0.00 1,999.04 1.460,218.55 0.14 1.66 2.49 19 964,876.36 178.18 0.00 178.18 964,876.36 0.02 0.22 2.43 19 965,054.54 182.63 0.00 182.63 964,163.19 0.02 0.23 2.34 19 963,611.76 177.99 0.00 177.99 963,611.76 0.02 0.22 2.00 19 963,789.75 181.94 0.00 181.94 962,967.17 0.02 0.23 1.96 19 962.471.69 666.26 0.00 666.26 9,909,647.83 0.01 0.08 1.77 19 17,278,576.79 2,590.67 0.00 2.590.67 12.501,741.85 0.02 0,25 1.80 r4u.La IItZUIt$ iZ/Z015 01/2019 02/2019 03/2019 04/2019 05/2019 06/2019 07/2019 08/2019 09/2019 Portfolio Treasury 1 Year maira Jagrup 1of1 City of Pearland j Portfolio Holdings by Security Type Report Group: Development Authority Date: 9130/2019 isn 91112012 897.95 100.OD 891.95 0,01% None 1 897.95 1.69 897.95 1.69 0.00 None p sh 1013MO12 1,156.803.58 100.00 1,156.803.58 13.9% None 1 1,156,803.58 1.69 1,156.803.58 1.69 0.00 None 0 LIO 8,324.601.95 0.40 1,157,701.53 1,157,701.53 0.00 0 1,157,701.53 1.69 1,157,701.53 1.69 0,00 0 MM 9130/2006 7,166.900.42 100.OD 7,166.900.42 86.09% None 1 7,166.900.42 0.19 7,166.900.42 0.19 0.00 Nonr. 0 7,166,900.42 7,166,900,42 86,09% 1 Market 7,166,900.42 0.19 7,166,900.42 0.19 0.00 0 8,324,601.95 8,324,601.95 100.00% 1 LIO 8,324.601.95 0.40 8,324,601.95 0.40 0.00 0 maira Jagrup 1of1 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Development Authority Date: 9/30/2019 lent Authority ! TIRZ 91112012 89195 100 D0 0.01% Nore 1 897.95 169 897.95 1.69 000 None 0 1013'+2012 1.1_56.803 SP. OF) 00 1,1%80.35. 13.9% None 1 1,156.803.58 1 (i-� 1 156 Ri;i3 5e 1 6 0.00 None p aV 9M12DDF 7, 166Gr1042 'Or)00 7,1g,C,W042 86.091% None 1 7,11;6 900 4; 0. 19 7,166 900 4� 0 10 0 0D None p 8,324,601.95 8,324,601.95 100% 1 welopment Authority 1 8,324,601.95 0.40 8,324,601.95 0.40 0.00 0 8,324,601,95 8,324.601.95 100.00% 1 _10 8,324,601.95 0.4D 8,324,601.95 OAD 0.00 0 r�rr�a: J�tri .I 1 of 1 City of Pearland Treasury Yield Curve Bury 6130/2019 9/3012019 Ionth 2.22 1.99 Ionth 2.22 1.94 Ionth 2.17 1.90 Year Y.00 1.80 Year 1.81 1.65 Year 1.78 1.59 Year 1.83 1.57 Year 2.07 1.70 06/30/2019 • 9/30/2019 1 Month 3 Month 6 Month 1 Year 2 Year 3 Year 5 Year 10 Year maira Jagrup 1 of 1 Pledged Collateral Reconciliation Report September 30, 2019 Bank Account Ending Account Name Amount Wells Fargo 3395 Credit Card Account Wells Fargo 2841 Sweep Account 204,694.00 ' Wells Fargo 5455 False Alarm Reduction Program 286,218.68 Wells Fargo 7843 Alvin ISD 9,459,594.19 Wells Fargo 1790 EMS Payments Wells Fargo 9871 Health Claims 375,533.06 Wells Fargo 4094 Escrow W&S Revenue Bonds, Series 20168 Wells Fargo 4102 Escrow W&S Revenue Bonds. Senes 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. Senes 2018A Wells Fargo 2847 Escrow W&S Revenue Bonds. Series 2019A Total of Bank Balances S 10,326,039.93 Pledged Collateral for City 32,580,264.71 FDIC Insurance 500,000.00 S 33,080,264.71 Over (Under) Collateralized S 22,754,224.78 Total % Collateralized 320.4% Bank Account Ending Account Name Amount Wells Fargo 4258 Development Authority 7,166,900.42 Total of Bank Balances S 7,166,900.42 Pledged Collateral for DAP 7,425,196.23 FDIC Insurance 250,000.00 S 7.675,196.23 Over (Under) Collateralized S 508,295.81 Total % Collateralized 107.1% Total % Collateralized 233.0% Status Collateralized Accounts are sweeping to a higher yielding money market fund which does not require collateral. Development Authority of Pearland Quarterly Investment Report September 30, 2019 to December 31, 2019 is prepared for the Development Authority of Pearland in accordance with Chapter 2256 of the Public Funds Investment Act (PF11111111110 IA). >.023 (a) of the PFIA states that "Not less than quarterly, the investment officer shall prepare and submit to the governing body of written report of the investment transactions for all funds covered by this chapter for the preceding reporting period." This report is 1e Investment Officer and includes the disclosures required in the PFIA. th Market Value Book Value Unrealized Gain/Loss YTM @ Cost Treasury 1 Year Interest Earned Days To Maturity 19 3,908,462.83 19 2,172,139.60 19 2,172,604.93 Is 2,751,069.12 3,908.462.83 2.172,139.60 2.172,604.93 2,751,069.12 0.00 0.00 0.00 0.00 0.55 0.76 0.74 0.65 1.61 1.57 1.55 1.58 2,941.88 2,042.77 1,425.33 6,409.98 1 1 1 11 3onpkirector of Finance Date /Z//;;;" }/0 .r, Assistant Director of Finance Date Rhonda Daugherty, Assistantirector of Finance Date 12 Shamaira Jagr easury Analyst Date Security Type City of Pearland Distribution by Security Type - Book Value Report Group: Development Authority 9130/2019 % of Portfolio 9130/2019 Begin Date: 9130/2019, End Date: 12/31/2019 Book Value 12!31!2019 1 213112 01 9 Cash 1,157,701.53 13.91 1,163,045.25 53.53 Money Market 7,166,900.42 86.09 1,009,559.68 46.47 Total / Average 8,324,601.95 100.00 2,172,604.93 100.00 Portfolio • • • of 9130/2019 '• • • Holdings as of 1 19 10 13.9196 -Cash 86.0996 -Monty Marke. � 53.5396 -Cash 46.4796 -Monty Market maira Jagrup 1 of 1 City of Pearland Distribution by Maturity Range - Book Value Report Group: Development Authority Begin Date: 9/3012019, End Date: 1213112019 maira Jagrup I Of i Maturity Range Book Value % POrtfO110 Book Value of Portfolio 913012019 9/30/2019�. 12/3112019 12!3112019 0-1 Month 8,324,601.95 110 nn 2,172,604.93 100.00 Total J Average 8,324,601.95 100.00 2,172,604.93 100.00 Portfolio . • • 09/30/2019 12/31/2019 0.1 Month maira Jagrup I Of i City of Pearland 7 Total Rate of Return - Book Value by Month Report Group: Development Authority Begin Date: 1/3112019, End Date: 12/31/2019 ith Beginning BV + Accrued Interest Interest EarnedRealized During Period -BV Investment Average Capital Gain/Loss-BV Annualized Treasury 1 Income -BV Base -BV TRR-BV TRR-BV Year 19 2,177,350.42 2,047.31 0.00 2,047.31 2.176,527.84 0.09 1.13 2.58 19 2,177,897.73 2.181.46 0.00 2,181.46 2.119,924.59 0.10 1.24 2.55 19 2,064,132.91 1,999.04 0.00 1.999.04 1.460,218.55 0.14 1.66 2.49 19 964,876.36 178.18 0.00 178.18 964,876.36 0.02 0.22 2.43 19 965,054.54 182.63 0.00 182.63 964,163.19 0.02 0.23 2.34 19 963,611.76 177.99 0.00 177.99 963,611.76 0.02 0.22 2.00 19 963,789.75 181.94 0.00 181.94 962,967.17 0.02 0.23 1.96 t9 962,471.69 666.26 0.00 666.26 9,909,647.63 0.01 0.08 1.77 19 17,278,576.79 2.590.67 0.00 2,590.67 12,501,741.85 0.02 0.25 1.80 19 8,324,601.95 2,941.86 0.00 2,941.88 5.901,234.95 0.05 0.60 1.61 19 3,908,462.83 2.042.77 0.00 2,042.77 2,981,334.30 0.07 0.83 1.57 19 2,172,139.60 1.425.33 0.00 1.425.33 2.171,613.15 0.07 0.79 1.55 (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 maira Jagrup 1 of 1 City of Pearland j Portfolio Holdings by Security Type Report Group: Development Authority Date: 12/31/2019 sh 91112012 '.. r 62.21) 100.00 ;'62 ,! D 0.08% Nnne i 1,762.20 1.23 1,762.20 1.23 0.00 None p sh 10131/2012 1,161,283.05 100.00 1,161.283.05 53,45% None 1 1,161.283.05 1.23 1,161.283.05 1.23 0.00 None p 1,163,045.25 1,163,045.25 53.53% 1 1,163,045.25 1.23 1,163,045.25 1.23 0,00 0 MM 9130/2006 1.009.559.68 100.00 1,009.559.68 46,47% None 1 1.009.559.66 0.17 1,009,559.68 0.17 0.00 None 0 1,009,559.99 1,009,559.68 46.47% 1 Mrfbt 110091559.6$ 0.17 1100910.59.96 0.17 0.00 0 UO 2,172,684.93 0.74 2,172,604.93 2,172,604.93 0.74 2,172,604.93 100.00% 0.00 1 0 maira Jagrup 1 of 1 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Development Authority Date: 12/3112019 lent Authority ! TIRZ sh 91112012 1,762.20 100.00 1,162.2u 0.08c"; None 1 762.20 1.23 1,762.20 1.23 0.00 None 0 1013112012 1,161.283.05 100.00 1,161.263.05 53.45% None 1 1,161.283.05 1.23 1,161.283.05 1.23 0.00 None p 913012OD6 1,009.559.68 100.00 1,009.559.68 46.47% None 1,009.559.68 0.17 1,009,559,6B 0.17 0. OD None C, 2,172,604.93 2,172,604.93 100% 1 evelopmentAuthority ! 2172,604.93 0.74 2,172.604.93 0.74 O.OD 0 2,172,604.93 2,172.604.93 100.00°/ 1 LIO 2,172,604.93 0.74 2,172,604.93 0.74 0.00 0 maira Jagrup 1of1 City of Pearland Treasury Yield Curve Bury 9/30/2019 1213112019 lonth 1.99 1.55 lonth 1.94 1.57 lonth 1.90 1.58 Year 1.80 1.55 Year 1.65 1.61 Year 1.59 1.63 Year 1.57 1.68 Year 1.70 1.86 9/30/2019 • 12/31/2019 1 Month 3 Month 6 Month 1 Year 2 Year 3 Year 5 Year 10 Year maira 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 R 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 °rho 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. Development Authority of Pearland Quarterly Investment Report December 31, 2019 to March 31, 2020 L is prepared for the Development Authority of Pearland 1n accordance with Chapter 2256 of the Public Funds Investment Act (PFIA). 56.023 (a) of the PFIA states that "Not less than quarterly, the investment officer shall prepare and submit to the governing body of a written report of the investment transactions for all funds covered by this chapter for the preceding reporting period." This report is the Investment Officer and includes the disclosures required in the PFIA. *nth Market Value Book Value Unrealized Gain/Loss YTM Q Cost Treasury 1 Year Interest Earned Days To Maturity ?020 2,172,485.30 2.172,485.30 000 072 153 1,380.37 1 ?020 2.140.319 40 2.140,319.40 000 0.73 1 41 1.344.00 1 ?020 988.424.63 988.424.63 0 00 017 0.33 1.252.50 1 rage 1,767,076.44 1,767,076.44 0.00 0.62 1.09 3,976.87 1 arson, Uector of Finance Digitally fignea Ey Jahn Mcrartet Mccarter a .FMamer OConga.c.US Date: 2020,054109:22:29 .05,00' Irter, Assistant Director of Finance 5/1/2020 Date �'(1vt)0j - LACLt L Rhonda Daugherty, Assistant Dire for of Finance Date o4o Shamaira Jagrup, wreSsury Manager Date 1 Security Type City of Pearland Distribution by Security Type - Book Value Report Group: Development Authority took Value 1213112019 C,101 1,163,045.25 hAc�ney tvIarket 1,009,559.68 Total I Average 2,172,604.93 Portfolio • • • of 1 � 53.3396 -Cash 46.4796 -Money Market of Portfolio 1213112019 Begin Date: 1213112019, End Date: 3/31/2020 sok Value 313112020 % of Portfolio 3/31/2020 53.53 10.406.04 1105 46.47 978,018.59 98.95 100.00 988,424.63 100.00 Portfolio Holdings as of 3131/2020 * 1.059E. -Cash 098.9 5% -Money Market maira Jagrup 2 City of Pearland Distribution by Maturity Range - Book Value Report Group: Development Authority Begin Date: 12,'3112019, End Date: 3131/2020 RangeMaturity • • Book Value % of Portfolio Book Value % of Portfolio Maturity Range 12/31/2019 12/3112019 3/3112020 313112020 n-1 Month 2,172,604.93 10000 988.424 63 inn nn 11 Total / Average 2,172,604.93 100.00 988,424.63 100.001 Portfolio • • • 0-1 M 0 12/31/2019 3/31/2020 maira Jagrup 3 City of Pearland Total Rate of Return - Book Value by Month Report Group: Development Authority Begin Date: 4130/2019, End Date: 3f31/2020 Beginning BV + Interest Earned Realized Investment Average Capital Annualized Treasury 1 ith Accrued Interest During Period-BV Gain/Loss-BV Income-BV Base-BV TRR-BV TRR-BV Year 19 964,876.36 178.18 0.00 178.18 964,876.36 0.02 0.22 2.43 19 965.054.54 182.63 0.00 182.63 964,163.19 0.02 0.23 2.34 19 963.611.76 177.99 0.00 177.99 963,611.76 0.02 0.22 2.00 19 963.789.75 181.94 0.00 181.94 962,967.17 0.02 0.23 1.96 19 962,471.69 666.26 0.00 666.26 9,909,647.83 0.01 0.08 1.77 19 17.278.576.79 2.590.67 0.00 2,590.67 12,501,741.85 0.02 0.25 1.80 19 8.324.601.95 2,941.88 0.00 2,941.88 5,901,234.95 0.05 0.60 1.61 19 3.908.462.83 2,042.77 0.00 2,042.77 2,981,334.30 0.07 0.83 1.57 19 2,172,139.60 1,425.33 0.00 1,425.33 2,171,613.15 0.07 0.79 1.55 20 2,172,604.93 1,380.37 0.00 1,380.37 2,171,782.35 0.06 0.77 1.53 20 2,172,485.30 1,344.00 0.00 1,344.00 2,155,152.59 0.06 0.75 1.41 20 2.140,319.40 1,252.50 0.00 1,252.50 1,507,948.32 0.08 1.00 0.33 1e 964,876.36 14,364.52 0.00 14,364.52 3,591,095.43 0.49 0.40 1.69 Annualized TRR-BV 0 Portfolio Treasury 1 Year /2019 05/2019 06/2019 07/2019 08/2019 09/2019 10/2019 11/2019 12/2019 01/2020 02/2020 03/2020 maira Jagrup 4 City of Pearland Portfolio Holdings by Security Type Report Group: Development Authority Date: 3131;2020 a!► 91112012 226.54 100.00 228.54 0.02% None 228.54 043 228.54 0.43 0.00 None ish 1013112012 10.177.50 100.00 10,177.50 1.03% None 10.177.50 0.43 10.177.50 0.43 0.00 None 10A00.04 1.A3 10A00.04 1104" 0.43 10.408.04 1.05% 0.00 1 0 NIIN 91301'1006 978,018.59 100.00 978.018.59 98,95% None 978,018.59 0.17 978.018.59 0.17 0.00 None 978,018.59 978,016.59 98.95% 1 ' 01•f11d 070,011.00 0.17 978,016.59 0.17 0.00 p 988,424.63 988,424.63 100.00% 1 LIO 000A34.03 0.17 0001424.03 0.17 0.00 0 City of Pearland Portfolio Holdings by Portfolio Name Report Group: development Authority —t A.Ok—ji . / TIO7 maira Jagrup E 220.54 arlrzuiz OA3 228.54 228.54 100.00 0.43 220.54 0.02% 0.00 None None 1 0 10.177.50 10131/2012 0.45 10.177.50 10.177.50 100.00 0.43 10.177.50 1.03% 0.00 None None I 0 IMM 978.018.59 9130/2006 0.17 978.018.59 978.018.59 100.00 0.17 970.018.69 90.95% 000 None None 1 0 *Velop-MltAvU"ty! 90$oGU3 0.17 988.424.83 988.424.63 0.17 000,414 03 1001.!, 0.00 1 0 LIO 988.424.63 0.17 988.424.63 988,424.63 0,17 OOOA24.03 100.00% 0 00 1 0 maira Jagrup E 1sury tonth lonth lonth Year Year Year Year Year City of Pearland Treasury Yield Curve 12/31/2019 1/31/2020 2/29/2020 3/3112020 1.55 1.5.1 1.58 0.37 1.57 1 r;, 1.54 0.30 1.58 1 >h 1.51 0.30 1.55 1.53 1.41 0.33 1.61 1.52 1.33 0.45 1.63 1.52 1.31 0.50 1.68 1.56 1.32 0.59 1.86 1.76 1.50 n 07 * 12/31/2019 1/31/2020 2/29/2020 r♦ 3/31/2020 1 Month 3 Month 6 Month 1 Year 2 Year 3 Year 5 Year 10 Year maira Jagrup Center Footer 7 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 20166 _ " 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, Senes 2018A Wells Fargo 2847 Escrow W&S Revenue Bonds, Series 2019A Total of Bank Balances S 14,523,093.60 Pledged Collateral for City 19,056,417.09 FDIC insurance 1,000,000.00 S 20,056,417.09 Over (Under) Collateralized S 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 S 978,018.59 Pledged Collateral for DAP 817,014.82 FDIC Insurance 250,000.00 S 1,067,014.82 Over (Under) Collateralized S 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. Development Authority of Pearland Quarterly Investment Report March 31, 2020 to June 30, 2020 is prepared for the Development Authority of Pearland in accordance with Chapter 2256 of the Public Funds Investment Act (PFIA), ;6.023 (a) of the PFIA states that "Not less than quarterly, the investment officer shall prepare and submit to the governing body of 3 written report of the investment transactions for all funds covered by this chapter for the preceding reporting period." This report is :he Investment Officer and includes the disclosures required in the PFIA. Inth Market Value Book Value Unrealized Gain/Loss YTM @ Cost Treasury 1 Year Interest Earned Days To Maturity 020 988,599.21 988,599.21 0.00 0.16 0.19 174.58 1 020 987.233.94 987,233.94 0.00 0.16 0.16 134.73 1 020 987,363.09 987,363.09 0.00 0.16 0.18 12915 1 age 987,732.08 987,732.08 0.00 0.16 0.18 438.46 1 Oig�1,01, 1,ned by John Mccarter 7/2r1/��rlo M c c a rt e r ::� Financ , Maartrr, o -City of Prarta lx L L L cu=finance, emafl=prlccarter�. praAandlxgov, c=US -%ate 20204722 17 1135 .05'00 rter, Interim Director of Finance Date f1lgbLr, rpna:l ty Sowrc:gra Joq,up 1 Ira J a g rU p �_, 4 e_�„,n<h. gat„ t. su.,n ...1»,,,,„ 07/23/2020 ReMam, i an` eppm..y this aoo..+..w Orr 2020 0 /23 11-.20,52 MW agrup, Treasury Manager Date Rhonda Daugherty oaieazozoosyloasaa.asooneny Rhonda Daugherty, Assistant Director of Finance 07/23/2020 Date 1 City of Pearland 1 Distribution by Security Type - Book Value Report Group: Development Authority Security Type 313112020 Cann 10,406.04 Money I.larket 978,018.59 Total 1 Average 988,424.63 Portfolio Holdings as of 1 of Portfolio 3/31/2020 Begin Date: 3x31±2020, End Date: 613012020 )ok Value 613012020 % of Portfolio 613012020 1.05 10,454.65 1, 06 98 95 976,908.44 98,94 100.00 987, 363.09 100.00 Portfolio • • • of 61300020 • 1.06%-C4ksh 98.9496 -Money Market ,inirn Jai-, 2 City of Pearland Distribution by Maturity Range - Book Value Report Group: Development Authority Begin Date: 313112020, End Date: 6/30/2020 AllocationMaturity Range Maturity Range Book Value °/. of Portfolio Book Value % of Portfolio 3/31/2020 3/31/2020 6/3012020 6130/2020 0-1 Month 988,424.63 100.00 987,363.09 inn nn Total / Average 988,424.63 100.00 987,363.09 Portfolio Holdings 0-1 M 100.00 0 3/31/2020 6/30/2020 j maira Jagrup 3 City of Pearland Total Rate of Return - Book Value by Month Report Group: Development Authority Begin Date: 713112019, End Date: 6/30/2020 Beginning BV + Interest Earned Realized Investment Average Capital Annualized Treasury 1 ith Accrued Interest During Period -BV Gain/Loss-BV Income -BV Base -BV TRR-BV TRR-BV vonr 119 963,789.75 181.94 0.00 181.94 962,967.17 0.02 0.23 1.96 119 962,471.69 666.26 0.00 666.26 9,909,647.83 0.01 0.08 1.77 19 17,278,576.79 2,590.67 0.00 2,590.67 12,501,741.85 0.02 0.25 1.80 19 8.324,601.95 2,941.88 0.00 2,941,88 5,901,234.95 0.05 0.60 1.61 19 3.908,462.83 2,042.77 0.00 2,042.77 2,981,334.30 0.07 0.83 1.57 19 2.172.139.60 1,425.33 0.00 1,425.33 2,171,613.15 0.07 0.79 1.55 20 2.172,604.93 1,380.37 0.00 1,380.37 2,171,782.35 0.06 0.77 1.53 20 2.172.485.30 1,344.00 0.00 1,344.00 2,155,152.59 0.06 0.75 1.41 20 2,140,319.40 1,252.50 0.00 1,252.50 1,507,948.32 0.08 1.00 0.33 20 988,424.63 174.58 0.00 174.58 988,424.63 0.02 0.21 0.19 20 988,599.21 134.73 0.00 134.73 987,776.63 0.01 0.16 0.16 20 987.233.94 129.15 0.00 129.15 987,233.94 0.01 0.16 0.18 ;e 963,789.75 14,264.18 0.00 14,264.18 3,593,933.72 0.40 0.40 1.17 rcuty UO/LUlY UYIZUIV 1DYZU19 11/2019 12/2019 01/2020 02/2020 03/2020 04/2020 05/2020 06/2020 • Portfolio Treasury 1 Year maira Jagrup 4 City of Pearland Portfolio Holdings by Security Type Report Group: Development Authority Uatc: t'3r12020 sh 91+2012 266.65 100.00 26665 0.03% None 266.65 001 266.65 0.01 0.00 None sh 10731-2012 10.188.00 100 D0 10,166.00 1.03% None 10.188.00 0.01 10.188.00 001 0.00 Nore 10,454.65 10,454.65 1.06'X. 1 10,454.65 0.01 10,454.65 0.01 0.00 0 MIA 930720D6 976, 908 44 100 00 976,908.44 98.94% Norge 1 976 908 44 0 i Li 976 908 44 0 16 0.00 Nore 976,908.44 976,908.44 98.94% 1 Market 976,906.44 0.16 976,908.44 0.16 0.00 0 987,363.09 987,363.09 100.00% 1 _10 987,363.09 0.16 987,363.09 0.16 0.00 0 maira Jagrup r� City of Pearland Portfolio Holdings by Portfolio Name Report Group: Development Authority Date: 6+30'2020 lent Autiw ty / TIRZ sh 911/2012 266.65 100, D0 266.65 0.03% Nora 1 266.65 0.01 266.65 001 0.00 None sh 1013112012 10.188.00 0.01 MM 913012006 976.908.44 0.16 10.188.00 100.00 10.188.00 1.03% 10,188.00 0.01 0.00 976.908.41 100.00 976.908.14 98.94% 976.908.44 0.16 0.00 987,363.09 987 363 09 None None None None 1 0 1 0 . . 100% 1 evelopment Authority f 987,363.09 0.16 987.363.09 0.16 0.00 0 987.363.09 987,363.09 100.00% 1 alt) 987,363.09 0.16 987,363.09 0,16 0.00 0 maira Jagrup 6 City of Pearland Treasury Yield Curve su ry 3131/2020 4/30/2020 5/3112020 613012020 na^.h 0.37 0.11 0.10 0.13 onth 0.30 0.14 0.13 0.16 onth 0.30 0.17 0.15 0.18 fear 0.33 0.19 0.16 0.18 fear 0.45 0.23 0.17 0.19 fear 0.50 0.28 0.22 0.22 fear 0.59 0.39 0,34 0,34 fear 0.87 0.66 0.67 0.73 0 3/31/2020 ��— 4/30/2020 05/31/2020 6/30/2020 1 Month 3 Month 6 Month 1 Year 2 Year 3 Year 5 Year 10 Year naira Jagrup Center Footer 7 Pledged Collateral Reconciliation Report June 30, 2020 Bank Account Ending Account Name Amount Wells Fargo 3395 Credit Card Account Wells Fargo 2841 Sweep Account 66,013,00 ` Wells Fargo 5455 False Alarm Reduction Program 286,806.18 Wells Fargo 7843 Alvin ISD 18,547,054.40 Wells Fargo 1790 EMS Payments - Wells Fargo 9871 Health Claims 634,601.32 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 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 S 19,534,474.90 Pledged Collateral for City 20,167,382.66 FDIC Insurance 1,987,420.52 S 22,154,803.18 Over (Under) Collateralized S 2,620,328.28 Total % Collateralized 113.4% Bank Account Ending Account Name Wells Fargo 4258 Development Authority Amount 976, 908.44 Total of Bank Balances S 976,908.44 Pledged Collateral for DAP 780,562.48 FDIC Insurance 250,000.00 S 1,030,562.48 Over (Under) Collateralized S 53,654.04 Total % Collateralized 105.5% Total % Collateralized 113.0% Status Collateralized Accounts are sweeping to a higher yielding money market fund which does not require collateral.