Item 3B2CITY OF
SOUTHLAI<,,.-E
MONTHLY FINANCIAL
REPORT
April 2020
PERFORMANCE AT A GLANCE
Year to Date
3 year Trend
Reference
General Fund Exp. Vs. Rev.
Positive
Positive
Page 3
Sales Tax Revenue (2 months prior activity)
Positive
Positive
Page 3
Property Tax Revenue
Positive
Positive
Page 4
Permit Revenues
Positive
Positive
Page 4
Departmental Expenditures Summary
Positive
Positive
Page 5
Positive = Positive variance or negative variance <1 % compared to seasonal trends.
Warning = Negative variance of 1-4% compared to seasonal trends
Negative = Negative Variance of > 4% compared to seasonal trends.
City of Southlake Monthly Financial Report 1 5/14/2020
ECONOMIC INDICATORS
0.048
National GDP:
GDP is defined as the output of goods and service
produced by labor and property located in the
United States, The Bureau of Labor and Economic
Analysis reported that the "advance" estimated
GDP for the 1 st quarter of 2020 decreased at a
rate of 4.8%.
9%
x -22.3%
Housing starts in March 2020 were at a seasonally
adjusted rate of 1,216,000, which is 22.3% below
the revised previous month figure of 1,564,000, but
1.4% above the same month last year. 64f,
UNEMPLOYMENT RATES
National: x 14.7%
The National Unemployment rate jumped to 14.7%
in April 2020 due to the COVID-19 crisis threw
millions out of work. Workers in the leisure and
hospitality industry suffered the highest
unemployment rate of any industry at 39.3% as of
April 2020.
State-wide: 4 4.70%
The Texas Unemployment rate for March 2020
increased to 4.7% from 3.5% in February 2020.
Based on recent unemployment claims, the Texas
unemployment rate is anticipated to be higher for
April and May. In a short seven -week period during
March and April, more than 1.8M Texans applied
For unemployment insurance, which is more than in
all of 2019.
DFW Area: 4.30%
The Dallas/Fort Worth/Arlington Metropolitan Area
unemployment rate for March increased to 4.3%
when compared to 3.2% in February 2020. April
and May unemployment rates will see a larger
COVID-19 impact. Following the 2008 financial
crisis, the DFW area unemployment average was
iust under 8% in 2009 and 2010.
FINANCIAL ACTIVITY
0%
2008 2010 2012 2014 2016
Source: Bureau of Labor Statistics
2019 2020
4.7%
in March 2020
City of Southlake Monthly Financial Report 2 5/14/2020
GENERAL FUND
OVERALL FUND PERFORMANCE:
GENERAL FUND REVENUE VS EXPENDITURES 2020
FY 2020
FY 2020
FY 2020 REVENUE FY 2020 EXPENDITURE 2019 EXPEND.
REVENUE
EXPENDITURE
VARIANCE
Oct $ 1,222,686
$ 2,363,689
$ (1,141,003)
$14,000,000
Nov $ 2,040,190
$ 1,533,381
$ 506,809
Dec $ 11,056,112
$ 2,902,978
$ 8,153,134
$12,000,000
Jan $ 12,177,688
$ 4,005,943
$ 8,171,745
Feb $ 7,400,320
$ 3,154,520
$ 4,245,800
$10,000,000
Mar $ 2,082,521
$ 3,187,863
$ (1,105,342)
$8000,000
Apr $ 1,393,145
$ 2,904,795
$ (1,511,650)
May $
$
$
$6,000,000
Jun $
$
$
Jul $
$
$
$4,000,000
Aug $
$
$
Sep
$
$2,000,000
Tot $ 37,372,662
$ 20,053,169
$ 17,319,493
N
CHART OUTLOOK:—F
POSITIVE
Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep
The outlook for the year was positive
for the reporting period ending April 30, 2020. However in the current environment with COVID -19, the executive team will closely monitor and adjust financial forecast
accordingly.
REVENUE ANALYSIS
GENERAL FUND SALES TAX 2020-2018 COMPARISON
FY 2020
FY 2019
FY 2018
� FY 2020 � FY 2019 FY 2018
Oct $ 1,278,635
Nov $ 1,309,584
$ 1,253,417
$ 1,140,440
$ 1,214,148
$ 1,272,500
$2,500,000
Dec $ 1,993,686
$ 1,613,337
$ 1,744,684
Jan $ 1,360,873
$ 1,030,047
$ 1,135,430
$2,000,000
$ 1,011,429
$ 1,094,354
$ 1,055,400
Imp
Mar $ 1,162,936
$ 1,321,691
$ 1,251,079
$1,500,000
Apr $ -
$ 1,294,023
$ 1,096,365
May $ -
$ 1,295,321
$ 1,363,921
$1,000,000
Jun $
$ 1,274,338
$ 1,292,089
Jul $ -
$ 1,179,145
$ 1,206,050
Aug
$ 1,344,868
$ 1,265,360
$500,000
Sep
$ 1,354,327
$1,227,621
Tot $ 8,117,142
$ 15,195,307
$ 15,124,646
$-
Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep
CHART OUTLOOK:
POSITIVE
FY 2020 was off to
a great start, year
to date sales
tax collections (sales from October 2019 through March 2020) are above the two previous years. FY 2020 collections are 8.91 % and 5.79% above FY 2019 and
2018, respectively.
The economic
impact from COVID-19 will necessitate an amendment to the sales tax projections. As indicated on the chart, March 2020 sales were below both 2019 and 2018 sales for the same
period. The city will not receive collections from the sales that occurred in April until June.
City of Southlake Monthly Financial Report 3 5/14/2020
0
GENERAL FUND
REVENUE ANALYSIS (continued)
PROPERTY TAX 3 YEAR TREND
FY 2020
FY 2019 FY 2018
■ FY 2020 FY 2019 FY 2018
Oct $ 790,236
$ 1,151,812 $ 217,086
$14,000,000
Nov $ 1,426,054
$ 1,552,708 $ 1,832,023
$12,000,000
Dec $ 9,161,119
$ 10,397,278 $ 6,601,683
$10,000,000
Jan $ 10,088,389
$ 9,985,201 $ 12,435,268
$8,000,000
Feb $ 4,237,797
$ 3,385,436 $ 3,744,931
Mar $ 420,930
$ 395,710 $ 196,116
$S,000,000
Apr $ 55,958
$ 156,647 $ 102,531
$4,000,000
May $ -
$ - $ 99,690
$2,000,000
Jun $ -
$ 312,620 $ 426,191
$-
Jul * $ -
$ (1,295,201) $ (1,431,282)
$(2,000,000) Oct Nov Dec Jan Feb Mar Apr May Jun u Aug
Aug $ -
$ 59,318 $ -
$(4,000,000)
Sep $
$ 46,464 $ 137,747
Tot $ 26,180,483
$ 26,147,993 $ 24,361,984
* Net transfer of TIF revenues to
CHART OUTLOOK:
POSITIVE
TIF fund
2020 YTD property
tax collections ($26,180,483) are approximately
3.12% lower than 2019 YTD ($27,024,792) as of April. The tax rate reduction from .447 to .41 per $100 is the primary reason for the reduction in
revenue. As indicated
on the chart, the majority of the property tax revenue is collected in the first few months of the fiscal year.
PERMIT REVENUE 2020-2018 COMPARISON
FY 2020
FY 2019 FY 2018
� FY 2020 � FY 2019 FY 2018
Oct $ 134,067
$ 85,534 $ 126,131 $700,000
Nov $ 238,528
$ 75,588 $ 145,755
Dec $ 135,168
$ 160,859 $ 87,701 $600,000
Jan $ 204,931
$ 121,526 $ 126,075
Feb $ 212,195
$ 121,533 $ 199,087 $500,000
Mar $ 126,842
$ 186,152 $ 229,059
Apr $ 188,968
$ 111,970 $ 126,788 $400,000
May $ -
$ 601,621 $ 98,364
Jun $ -
$ 111,503 $ 162,515 $300,000
Jul $
$ 163,760 $ 168,508
Aug $ -
$200,000
$ 155,328 $ 185,552
,
Sep
$ 474,884 $ 223,441 $100,000
mom
Tot $ 1,240,699
$ 2,370,258 $ 1,878,976
Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep
CHART OUTLOOK: POSITIVE
The value of new construction permits ($58.OM+) issued for FY 2020 YTD is approximately 6.0% and 35.3% lower when compared to FY 2019 and FY 2018 respectively. However, as indicated on the chart the overall
permit revenue is trending higher than the FY 2019 and FY 2018 by 43.7% and 19.2%, respectively.
City of Southlake Monthly Financial Report 4 5/14/2020
EXPENDITURE ANALYSIS
DEPARTMENTAL EXPENDITURES SUMMARY
FY 2020 YTD
FY 2019 YTD
FY 2019/2020 YTD
(APRIL)
(APRIL)
FY 2020 BUDGET
VARIANCE BUDGET VARIANCE
FY 2020 % SPENT
CMO
$
558,658
$
536,610
$
1,034,611
$
(22,048) $
475,953
54.00%
COMM
$
256,463
$
251,922
$
486,472
$
(4,541) $
230,009
52.72%
CS
$
2,980,204
$
3,074,942
$
6,076,456
$
94,738 $
3,096,252
49.05%
CSO
$
273,313
$
258,853
$
527,181
$
(14,460) $
253,868
51.84%
DPS
$
9,964,857
$
9,674,291
$
18,451,018
$
(290,566) $
8,486,161
54.01%
ED
$
78,045
$
71,132
$
154,872
$
(6,913) $
76,827
50.39%
FIN
$
1,333,364
$
1,408,345
$
2,509,163
$
74,981 $
1,175,799
53.14%
HR
$
417,901
$
413,044
$
866,157
$
(4,857) $
448,256
48.25%
IT
$
1,463,242
$
1,264,262
$
2,858,866
$
(198,980) $
1,395,624
51.18%
PDS
$
1,158,309
$
1,204,383
$
2,293,889
$
46,074 $
1,135,580
50.50%
PW
$
2,534,522
$
2,419,227
$
4,846,636
$
(115,295) $
2,312,114
52.29%
SS
$
1,087,101
$
820,809
$
1,781,845
$
(266,292) $
694,744
61.01%
Totals
$
22,105,979
$
21,397,820
$
41,887,166
$
(708,159) $
19,781,187
52.78%
FY 2020 YTD (APRIL)
FY 2019 YTD (APRIL) FY 2020 BUDGET
$20,000,000
$18,000,000
$16,000,000
$14,000,000
$12,000,000
$10,000,000
$8,000,000
$6,000,000
$4,000,000
$2,000,000
$-
CMO
COMM
CS
CSO
DPS
ED FIN HR
IT PDS PW SS
CHART OUTLOOK:
POSITIVE
As indicated on the
chart the 2020 expenditures are
higher when comparable to 2019 expenditures for the same period with an increase of 3.31 % primarily
due to approved public safety pay plan adjustments and true -
up of IT investments. Overall fund expenditures are
trending
below budget.
City of Southlake Monthly Financial Report 5 5/14/2020
HilitopSecurities
Asset Management -
City of Southlake
Investment Portfolio Summary
CITY OF
SOUTH LAKE
For the Quarter Ended
March 31, 2020
Prepared by
HilltopSecurities Asset Management
rt� � :a
HilltopSecurities
Asset Management.,
Report Name
Certification Page
Executive Summary
Benchmark Comparison
Detail of Security Holdings
Change in Value
Earned Income
Investment Transactions
Amortization and Accretion
Projected Fixed Income Cash Flows
MARKET RECAP - MARCH 2O20:
On February 24th the World Health Organization's director general told journalists that the COVID-19
virus was not yet a global pandemic and that "it is still possible to contain the virus." But within days,
the reality could no longer be denied and on March 11th the WHO finally made it official. Financial
markets had determined weeks earlier that the novel coronavirus was going to be a big problem and
stocks around the world were hammered. The ensuing flight to safety rally sent U.S. Treasury yields to
record lows. Meanwhile, other fixed income sectors came under enormous selling pressure as
investors foresaw massive credit deterioration and companies worked to build up cash reserves to
weather the storm. On March 3rd, in an emergency move, the Federal Reserve cut the fed funds
target rate by 50 basis points, noting in typically understated fashion, "The coronavirus poses evolving
risks to economic activity." At the time, many market participants saw the Fed's move as a panicked
reaction and they responded by panicking themselves, sending stock markets tumbling. The hits kept
coming: outbreaks of COVID-19 erupted in Seattle and New York and have now spread to most major
metropolitan areas; sports leagues began suspending and then cancelling games, seasons, and
tournaments; conference organizers around the nation cancelled events; schools sent students home;
local governments started by ordering restaurants to close and banning public gatherings before
eventually issuing mandatory "stay-at-home" orders for all non -essential activities." This list goes on
and on.
With the economic engine switched to off, policy makers were forced to respond. On Sunday, March
15th, the Fed pulled out all the stops, slicing the fed funds rate by a full percentage point to a range of
0%-0.25%. The Fed also implemented massive quantitative easing, expanded repo operations,
lowered the interest rate on excess reserves, and established a lending facility to support money
market funds and the commercial paper market. There was more to come. By the third week of March,
first time claims for unemployment benefits would skyrocket with nearly 3.3 million Americans filing for
benefits. This would spur Congress to pass the Coronavirus Aid, Relief, and Economic Security Act, or
"CARES Act", a massive $2 trillion relief package intended to cushion the blow for both employees and
employers, as well as provide support for the many companies buckling under the strain of the sudden
stoppage of business. Central banks and governments around the world would join the U.S. in cutting
interest rates and passing relief measures.
We won't bother recapping March's slate of economic data. Suffice it to say, in the weeks and months
ahead we will bear witness to an abrupt economic downturn unlike anything we have ever seen. While
the data will be terrible, the impact on lives and livelihoods will be worse. The major U.S. stock indexes
suffered declines of more than 30% from the record highs reached in mid -February, clawing back
three years of gains. A post -CARES Act rally in the final week of the month would briefly stem the
slide. U.S. Treasury yields plummeted during March with the two-year note closing the month at 0.25%
and the 10-year at 0.67%. At one point in late March, much of the curve inside of a year was trading at
negative yields. It appears a deep (hopefully short-lived) recession is imminent. A zero rate
environment is the new norm for the foreseeable future.
Page 2 of 17
J�*
HilltopSecurities
Asset Management_
For the Quarter Ended
March 31, 2020
City of Southlake
Investment Officers' Certification
This report is prepared for the City of Southlake (the "Entity") in accordance with Chapter 2256 of the Texas Public Funds Investment Act ("PFIA"). Section
2256.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 reporl
of the investment transactions for all funds covered by this chapter for the preceding reporting period." This report is signed by the Entity's investment officers
and includes the disclosures required in the PFIA. To the extent possible, market prices have been obtained from independent pricing sources.
The investment portfolio complied with the PFIA and the Entity's approved Investment Policy and Strategy throughout the period. All investment transactions
made in the portfolio during this period were made on behalf of the Entity and were made in full compliance with the PFIA and the approved Investment Policy.
Officer Names and Titles:
Sharen Jackson
Name: Sharen Jackson Title: Chief Financial Officer
Mary Morgan
Name: Mary Morgan Title: Deputy Director of Finance
Page 3 of 17
J�*
HilltopSecurities
Asset Management..
Beginning Values as of 12/31/19 Ending Values as of 03131120
Par Value
146,481,719.99
168,867,802.19
Market Value
146,491,069.29
169,555,695.79
Book Value
146,409,983.36
168,947,335.12
Unrealized Gain /(Loss)
81,085.93
608,360.67
Market Value %
100.06%
100.36%
Weighted Avg. YTW
1.805%
1.405%
Weighted Avg. YTM
1.805%
1.405%
■ USTREAS 24%
■ TEXSTAR 22%
■ TEXPOOL 20%
■ FHLB 6%
■ FNMA 4%
■ TXCLASS 3%
■ Other Issuers 21%
Total: 100%
50%
40%
30%
20%
10%
0%
Overnight 2 - 90 Days 91 - 180 Days 6 - 12 Months
Weighted Average Days to Maturity: 100
City of Southlake
Executive Summary
As of 03/31/20
■ AGCY BULLET
12%
■ CID
13%
■ LGIP
47%
■ MUNICIPAL
3%
■ TREASURY
24%
Total:
100%
■ A-1+ 16%
r AAA 84%
Total: 100%
Print Date: 4/23/2020 Print Time: 3:24 pm
Page 4 of 17
Page 1 of 1
J�w
HilltopSecurities
Asset Management_
2.80%
2.40%
2.00%
1.60%
1.20%
0.80%
0.40%
City of Southlake
Benchmark Comparison
As of 03/31/2020
0.00%
Oct-18 Nov-18 Dec-18 Jan-19 Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 Jan-20 Feb-20 Mar-20
�— 1 YR CMT 3-MO CMT 6-MO CMT - TEXPOOL f City of Southlake
Note 1: CMT stands for Constant Maturity Treasury. This data is published in Federal Reserve Statistical Release H.15 and represents an average of all actively traded Treasury securities having that time remaining until maturity. This is a
standard industry benchmark for Treasury securities. The CMT benchmarks are moving averages. The 3-month CMT is the daily average for the previous 3 months, the 6-month CMT is the daily average for the previous 6 months, and the
1-year and 2-year CMTs are the daily averages for the previous 12-months.
Note 2: Benchmark data for TexPool is the monthly average yield.
Print Date: 4/23/2020 Print Time: 3:25 pm Page 1 of 1
Page 5 of 17
J�*
HilltopSecurities
Asset Management.
City of Southlake
Detail of Security Holdings
As of 03/31/2020
Settle Purch Mkt Days Days
CUSIP Date Sec. Type Sec. Description CPN Mty Date Next Call Call Type Par Value Price Orig Cost Book Value Price Market Value to Mty to Call YTM YTW
Crime Control District
TEXSTAR LGIP TexSTAR 4,186,921.72 100.000 4,186,921.72 4,186,921.72 100.000 4,186,921.72 1 0.957 0.957
Total for Crime Control District 4,186,921.72 100.000 4,186,921.72 4,186,921.72 100.000 4,186,921.72 1 0.957 0.957
LNSTCRP
LGIP
LoneStar Corp O/N
1,113,855.59
100.000
1,113,855.59
1,113,855.59
100.000
1,113,855.59
1
1.500
1.500
LNSTGOV
LGIP
LoneStar GovO/N
2,680,125.62
100.000
2,680,125.62
2,680,125.62
100.000
2,680,125.62
1
1.110
1.110
TEXPOOL
LGIP
TexPool
33,439,261.47
100.000
33,439,261.47
33,439,261.47
100.000
33,439,261.47
1
1.003
1.003
TEXSTAR
LGIP
TexSTAR
29,293,163.39
100.000
29,293,163.39
29,293,163.39
100.000
29,293,163.39
1
0.957
0.957
TXCLASS
LGIP
Texas CLASS
5,296,746.17
100.000
5,296,746.17
5,296,746.17
100.000
5,296,746.17
1
1.470
1.470
19865BAG4
03/19/20
CP - INT
Columbia Univ
2.000
05/13/20
5,000,000.00
100.000
5,000,000.00
5,000,000.00
100.132
5,006,600.00
43
2.000
2.000
07287CEMO
03/12/20
CP - DISC
Baylor Scott & White
05/21/20
5,000,000.00
99.806
4,990,277.78
4,993,055.55
99.814
4,990,706.50
51
1.002
1.002
3133EKMP8
05/31/19
AGCY BULET
FFCB
2.310
05/28/20
5,000,000.00
99.985
4,999,250.00
4,999,880.45
100.397
5,019,838.00
58
2.325
2.325
30229AF46
03/11/20
CP- DISC
Exxon Mobil
06/04/20
5,000,000.00
99.764
4,988,194.44
4,991,111.10
99.618
4,980,924.50
65
1.002
1.002
09657TGJ6
09/17/19
CP - INT
Univ of NC
1.980
06/11/20
2,350,000.00
100.000
2,350,000.00
2,350,000.00
99.917
2,348,049.50
72
1.980
1.980
3135GOD75
04/23/19
AGCY BULET
FNMA
1.500
06/22/20
6,000,000.00
98.911
5,934,660.00
5,987,278.08
100.277
6,016,602.60
83
2.454
2.454
882724PY7
03/23/20
MUNICIPAL
State of TX
4.000
08/27/20
5,000,000.00
100.439
5,021,950.00
5,020,691.70
101.128
5,056,400.00
149
2.922
2.922
78009AKD5
01/21/20
CP- DISC
Royal Bank of Canada
10/13/20
5,000,000.00
98.729
4,936,455.56
4,953,416.65
99.243
4,962,134.00
196
1.742
1.742
9128282Z2
02/21/20
TREAS NOTE
U.S. Treasury
1.625
10/15/20
5,000,000.00
100.070
5,003,515.63
5,002,942.75
100.801
5,040,039.00
198
1.514
1.514
3130AHEM1
10/25/19
AGCY BULET
FHLB
1.625
10/23/20
5,000,000.00
99.995
4,999,750.00
4,999,859.30
100.723
5,036,131.50
206
1.630
1.630
3130AHEM1
10/25/19
AGCY BULET
FHLB
1.625
10/23/20
5,000,000.00
99.995
4,999,750.00
4,999,859.30
100.723
5,036,131.50
206
1.630
1.630
9128283G3
05/31/19
TREAS NOTE
U.S. Treasury
1.750
11/15/20
5,000,000.00
99.398
4,969,921.88
4,987,080.90
101.023
5,051,172.00
229
2.172
2.172
9128283G3
02/21/20
TREAS NOTE
U.S. Treasury
1.750
11/15/20
5,000,000.00
100.168
5,008,398.44
5,007,153.70
101.023
5,051,172.00
229
1.517
1.517
91282831-2
01/17/20
TREAS NOTE
U.S. Treasury
1.875
12115/20
5,000,000.00
100.250
5,012,500.00
5,009,703.45
101.234
5,061,719.00
259
1.597
1.597
9128283Q1
02/21/20
TREAS NOTE
U.S. Treasury
2.000
01/15/21
5,000,000.00
100.445
5,022,265.63
5,019,556.80
101.500
5,075,000.00
290
1.498
1.498
9128283X6
02/21/20
TREAS NOTE
U.S. Treasury
2.250
02/15/21
5,000,000.00
100.746
5,037,304.69
5,033,152.75
101.867
5,093,359.50
321
1.483
1.483
9128284133
02/21/20
TREAS NOTE
U.S. Treasury
2.375
03/15/21
5,000,000.00
100.945
5,047,265.63
5,042,451.70
102.148
5,107,422.00
349
1.475
1.475
912828C57
01/17/20
TREAS NOTE
U.S. Treasury
2.250
03/31/21
5,000,000.00
100.777
5,038,867.19
5,032,338.75
102.090
5,104,492.00
365
1.594
1.594
Total for General Operating
160,173,152.24
100.008
160,183,479.11
160,252,685.17
100.431
160,861,045.84
105
1.429
1.429
Print Date: 4/23/2020 Print Time: 3:26 pm Page 1 of 2
Page 6 of 17
J�*
HilltopSecurities
Asset Management_
City of Southlake
Detail of Security Holdings
As of 03/31/2020
Settle Purch Mkt Days Days
CUSIP Date Sec. Type Sec. Description CPN Mty Date Next Call Call Type Par Value Price Orig Cost Book Value Price Market Value to Mty to Call YTM YTW
Parks Development Corporation
TEXSTAR LGIP TexSTAR 4,507,728.23 100.000 4,507,728.23 4,507,728.23 100.000 4,507,728.23 1 0.957 0.957
Total for Parks Development Corporation 4,507,728.23 100.000 4,507,728.23 4,507,728.23 100.000 4,507,728.23 1 0.957 0.957
Total for City of Southlake 168,867,802.19 100.007 168,878,129.06 168,947,335.12 100.409 169,555,695.79 100 1.405 1.405
Print Date: 4/23/2020 Print Time: 3:26 pm
Page 7 of 17
Page 2 of 2
J�*
HilltopSecurities
Asset Management.
City of Southlake
Change in Value
From 1213112019 to 03/31/2020
CUSIP Security Type Security Description 12/31119 Cost of Maturities / Amortization I Realized 03/31120 12/31119 03/31120 Change in
Book Value Purchases Calls I Sales Accretion Gainl(Loss) Book Value Market Value Market Value Mkt Value
Community Enhancement Dev Co�
TEXPOOL LGIP TexPool 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Total for Community Enhancement Dev Corp
Crime Control District
TEXSTAR LGIP TexSTAR
Total for Crime Control District
General Operating
LNSTCRP
LGIP
LoneStar Corp O/N
LNSTGOV
LGIP
LoneStar Gov O/N
TEXPOOL
LGIP
TexPool
TEXSTAR
LGIP
TexSTAR
TXCLASS
LGIP
Texas CLASS
46640PAH6
CP - DISC
J.P.Morgan Sec 0.000 01/17/20
13068CEA9
CP - INT
State of CA 1.730 03/11/20
3113378,177
AGCY BULET
FHLB 1.875 03/13/20
19865BAG4
CP - INT
Columbia Univ 2.000 05/13/20
07287CEMO
CP - DISC
Baylor Scott & White 0.000 05/21/20
3133EKMP8
AGCY BULET
FFCB 2.310 05/28/20
30229AF46
CP - DISC
Exxon Mobil 0.000 06/04/20
09657TGJ6
CP-INT
Univ of NC 1.980 06/11/20
3135GOD75
AGCY BULET
FNMA 1.500 06/22/20
3136G4PC1
AGCY CALL
FNMA 1.750 07/24/20
882724PY7
MUNICIPAL
State of TX 4.000 08/27/20
78009AKD5
CP - DISC
Royal Bank of Canada 0.000 10/13/20
9128282Z2
TREAS NOTE
U.S. Treasury 1.625 10/15/20
3130AHEM1
AGCY BULET
FHLB 1.625 10/23/20
9128283G3
TREAS NOTE
U.S. Treasury 1.750 11/15/20
91282831-2
TREAS NOTE
U.S. Treasury 1.875 12/15/20
912828301
TREAS NOTE
U.S. Treasury 2.000 01/15/21
9128283X6
TREAS NOTE
U.S. Treasury 2.250 02/15/21
0.00 0.00 0.00 0.00
4,172,831.72 14,090.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 4,186,921.72 4,172,831.72 4,186,921.72 14,090.00
4,172,831.72 14,090.00 0.00 0.00 0.00 4,186,921.72 4,172,831.72 4,186,921.72 14,090.00
1,109,244.30
4,611.29
0.00
0.00
0.00
1,113,855.59
1,109,244.30
1,113,855.59
4,611.29
2,670,715.39
9,410.23
0.00
0.00
0.00
2,680,125.62
2,670,715.39
2,680,125.62
9,410.23
47,213,772.42
7,438,179.80
(21,212,690.75)
0.00
0.00
33,439,261.47
47,213,772.42
33,439,261.47
(13,774,510.95)
25,198,152.94
4,095,010.45
0.00
0.00
0.00
29,293,163.39
25,198,152.94
29,293,163.39
4,095,010.45
5,274,444.65
22,301.52
0.00
0.00
0.00
5,296,746.17
5,274,444.65
5,296,746.17
22,301.52
1,997,724.44
0.00
(2,000,000.00)
2,275.56
0.00
0.00
1,998,469.00
0.00
(1,998,469.00)
5,000,000.00
0.00
(5,000,000.00)
0.00
0.00
0.00
5,000,781.50
0.00
(5,000,781.50)
5,993,163.60
0.00
(6,000,000.00)
6,836.40
0.00
0.00
6,002,509.20
0.00
(6,002,509.20)
0.00
5,000,000.00
0.00
0.00
0.00
5,000,000.00
0.00
5,006,600.00
5,006,600.00
0.00
4,990,277.78
0.00
2,777.77
0.00
4,993,055.55
0.00
4,990,706.50
4,990,706.50
4,999,691.70
0.00
0.00
188.75
0.00
4,999,880.45
5,015,370.50
5,019,838.00
4,467.50
0.00
4,988,194.44
0.00
2,916.66
0.00
4,991,111.10
0.00
4,980,924.50
4,980,924.50
2,350,000.00
0.00
0.00
0.00
0.00
2,350,000.00
2,351,245.50
2,348,049.50
(3,196.00)
5,973,142.68
0.00
0.00
14,135.40
0.00
5,987,278.08
5,995,782.60
6,016,602.60
20,820.00
4,983,024.35
0.00
(5,000,000.00)
16,975.65
0.00
0.00
5,000,551.00
0.00
(5,000,551.00)
0.00
5,021,950.00
0.00
(1,258.30)
0.00
5,020,691.70
0.00
5,056,400.00
5,056,400.00
0.00
4,936,455.56
0.00
16,961.09
0.00
4,953,416.65
0.00
4,962,134.00
4,962,134.00
0.00
5,003,515.63
0.00
(572.88)
0.00
5,002,942.75
0.00
5,040,039.00
5,040,039.00
9,999,592.50
0.00
0.00
126.10
0.00
9,999,718.60
9,997,042.00
10,072,263.00
75,221.00
4,981,924.10
5,008,398.44
0.00
3,912.06
0.00
9,994,234.60
5,004,006.00
10,102,344.00
5,098,338.00
0.00
5,012,500.00
0.00
(2,796.55)
0.00
5,009,703.45
0.00
5,061,719.00
5,061,719.00
0.00
5,022,265.63
0.00
(2,708.83)
0.00
5,019,556.80
0.00
5,075,000.00
5,075,000.00
0.00
5,037,304.69
0.00
(4,151.94)
0.00
5,033,152.75
0.00
5,093,359.50
5,093,359.50
Print Date: 4/23/2020 Print Time: 3:26 pm Page 1 of 2
Page 8 of 17
J�w
HilltopSecurities
Asset Management_
City of Southlake
Change in Value
From 1213112019 to 03/31/2020
CUSIP
Security Type
Security Description
12/31119
Cost of
Maturities /
Amortization I
Realized
03/31120
12/31119
03/31120
Change in
Book Value
Purchases
Calls I Sales
Accretion
Gainl(Loss)
Book Value
Market Value
Market Value
Mkt Value
General Operati
9128284B3
TREAS NOTE
U.S. Treasury 2.375 03/15/21
0.00
5,047,265.63
0.00
(4,813.93)
0.00
5,042,451.70
0.00
5,107,422.00
5,107,422.00
912828C57
TREAS NOTE
U.S. Treasury 2.250 03/31/21
0.00
5,038,867.19
0.00
(6,528.44)
0.00
5,032,338.75
0.00
5,104,492.00
5,104,492.00
3134GULE8
AGCY CALL
FHLMC 2.000 10/28/21
10,000,000.00
0.00
(10,000,000.00)
0.00
0.00
0.00
9,993,592.00
0.00
(9,993,592.00)
Total for General Operating
137,744,593.07
71,676,508.28
(49,212,690.75)
44,274.57
0.00
160,252,685.17
137,825,679.00
160,861,045.84
23,035,366.84
Parks Development Corporation
TEXPOOL LGIP TexPool
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TEXSTAR LGIP TexSTAR
4,492,558.57
15,169.66
0.00
0.00
0.00
4,507,728.23
4,492,558.57
4,507,728.23
15,169.66
Total for Parks Development Corporation
4,492,558.57
15,169.66
0.00
0.00
0.00
4,507,728.23
4,492,558.57
4,507,728.23
15,169.66
Total for City of Southlake
146,409,983.36
71,705,767.94
(49,212,690.75)
44,274.57
0.00
168,947,335.12
146,491,069.29
169,555,695.79
23,064,626.50
Print Date: 4/23/2020 Print Time: 3:26 pm Page 2 of 2
Page 9 of 17
J�*
HilltopSecurities
Asset Management..
City of Southlake
Earned Income
From 1213112019 to 03/31/2020
CUSIP Security Type Security Description Beg. Accrued Interest Earned Interest Rec'd I Interest Purchased Ending Accrued Disc Accr / Net Income
Sold I Matured Prem Amort
Community Enhancement Dev Corp
Total for Community Enhancement Dev Corp
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Crime Control
District
TEXSTAR
LGIP
TexSTAR
0.00
14,090.00
14,090.00
0.00
0.00
0.00
14,090.00
Total for Crime Control District
0.00
14,090.00
14,090.00
0.00
0.00
0.00
14,090.00
General Operating
LNSTCRP
LGIP
LoneStar Corp O/N
0.00
4,611.29
4,611.29
0.00
0.00
0.00
4,611.29
LNSTGOV
LGIP
LoneStar Gov O/N
0.00
9,410.23
9,410.23
0.00
0.00
0.00
9,410.23
TEXPOOL
LGIP
TexPool
0.00
169,292.45
169,292.45
0.00
0.00
0.00
169,292.45
TEXSTAR
LGIP
TexSTAR
0.00
95,010.45
95,010.45
0.00
0.00
0.00
95,010.45
TXCLASS
LGIP
Texas CLASS
0.00
22,301.52
22,301.52
0.00
0.00
0.00
22,301.52
46640PAH6
CP - DISC
J.P.Morgan Sec 0.000 01/17/20
0.00
0.00
0.00
0.00
0.00
2,275.56
2,275.56
13068CEA9
CP - INT
State of CA 1.730 03/11/20
4,739.73
16,543.71
21,283.44
0.00
0.00
0.00
16,543.71
3113378,177
AGCY BULET
FHLB 1.875 03/13/20
33,750.00
22,500.00
56,250.00
0.00
0.00
6,836.40
29,336.40
19865BAG4
CP - INT
Columbia Univ 2.000 05/13/20
0.00
3,611.11
0.00
(277.78)
3,888.89
0.00
3,611.11
07287CEMO
CP - DISC
Baylor Scott & White 0.000 05/21/20
0.00
0.00
0.00
0.00
0.00
2,777.77
2,777.77
3133EKMP8
AGCY BULET
FFCB 2.310 05/28/20
10,587.50
28,875.00
0.00
0.00
39,462.50
188.75
29,063.75
30229AF46
CP - DISC
Exxon Mobil 0.000 06/04/20
0.00
0.00
0.00
0.00
0.00
2,916.66
2,916.66
09657TGJ6
CP - INT
Univ of NC 1.980 06/11/20
13,700.50
11,761.75
0.00
0.00
25,462.25
0.00
11,761.75
3135GOD75
AGCY BULET
FNMA 1.500 06/22/20
2,250.00
22,500.00
0.00
0.00
24,750.00
14,135.40
36,635.40
3136G4PC1
AGCY CALL
FNMA 1.750 07/24/20
38,159.72
5,590.28
43,750.00
0.00
0.00
16,975.65
22,565.93
882724PY7
MUNICIPAL
State of TX 4.000 08/27/20
0.00
4,918.03
0.00
(109,836.07)
114,754.10
(1,258.30)
3,659.73
78009AKD5
CP - DISC
Royal Bank of Canada 0.000 10/13/20
0.00
0.00
0.00
0.00
0.00
16,961.09
16,961.09
9128282Z2
TREAS NOTE
U.S. Treasury 1.625 10/15/20
0.00
8,879.78
0.00
(28,637.30)
37,517.08
(572.88)
8,306.90
3130AHEM1
AGCY BULET
FHLB 1.625 10/23/20
30,694.44
40,625.00
0.00
0.00
71,319.44
126.10
40,751.10
9128283G3
TREAS NOTE
U.S. Treasury 1.750 11/15/20
11,298.08
31,490.39
0.00
(23,557.69)
66,346.16
3,912.06
35,402.45
91282831-2
TREAS NOTE
U.S. Treasury 1.875 12/15/20
0.00
19,211.06
0.00
(8,452.87)
27,663.93
(2,796.55)
16,414.51
9128283Q1
TREAS NOTE
U.S. Treasury 2.000 01/15/21
0.00
10,989.01
0.00
(10,164.84)
21,153.85
(2,708.83)
8,280.18
9128283X6
TREAS NOTE
U.S. Treasury 2.250 02/15/21
0.00
12,362.63
0.00
(1,854.40)
14,217.03
(4,151.94)
8,210.69
912828463
TREAS NOTE
U.S. Treasury 2.375 03/15/21
0.00
12,989.16
59,375.00
(51,871.57)
5,485.73
(4,813.93)
8,175.23
912828C57
TREAS NOTE
U.S. Treasury 2.250 03/31/21
0.00
23,053.28
56,250.00
(33,504.10)
307.38
(6,528.44)
16,524.84
Print Date: 4/23/2020 Print Time: 3:26 pm Page 1 of 2
Page 10 of 17
J�*
HilltopSecurities
Asset Management.
City of Southlake
Earned Income
From 12/31/2019 to 03/31/2020
CUSIP Security Type Security Description Beg. Accrued Interest Earned Interest Rec'd / Interest Purchased Ending Accrued Disc Accr / Net Income
Sold / Matured Prem Amort
General Operating
3134GULE8 AGCY CALL FHLMC 2.000 10/28/21
35,000.00
15,000.00
50,000.00
0.00
0.00
0.00
15,000.00
Total for General Operating
Parks Development Corporation
TEXSTAR LGIP TexSTAR
180,179.97
0.00
591,526.13
15,169.66
587,534.38
15,169.66
(268,156.62)
0.00
452,328.34
0.00
44,274.57
0.00
635,800.70
15,169.66
Total for Parks Development Corporation
0.00
15,169.66
15,169.66
0.00
0.00
0.00
15,169.66
Total for City of Southlake
180,179.97
620,785.79
616,794.04
(268,156.62)
452,328.34
44,274.57
665,060.36
Print Date: 4/23/2020 Print Time: 3:26 pm Page 2 of 2
Page 11 of 17
J�w
HilltopSecurities
Asset Management.
City of Southlake
Investment Transactions
From 0110112020 to 03/31/2020
Trade Settle Security Principal Int Purchased / Realized
Date Date CUSIP Type Security Description Coupon Mty Date Call Date Par Value Price Amount Received Total Amount Gain / Loss YTM YTW
calls
01/23/20
01/24/20
3136G4PC1
AGCY CALL
FNMA
1.750
07/24/20 01/24/20
5,000,000.00
100.000
5,000,000.00
0.00
5,000,000.00
2.360
1.750
01/27/20
01/28/20
3134GULE8
AGCY CALL
FHLMC
2.000
10/28/21 01/28/20
10,000,000.00
100.000
10,000,000.00
50,000.00
10,050,000.00
2.000
1.999
Total for:
Calls
15,000,000.00
15,000,000.00
50,000.00
15,050,000.00
2.120
1.916
Maturities
01/17/20
01/17/20
46640PAH6
CP - DISC
J.P.Morgan Sec
01/17/20
2,000,000.00
100.000
2,000,000.00
0.00
2,000,000.00
2.610
03/11/20
03/11/20
13068CEA9
CP - INT
State of CA
1.730
03/11/20
5,000,000.00
100.000
5,000,000.00
21,283.44
5,021,283.44
1.730
03/13/20
03/13/20
313378,177
AGCY BULET
FHLB
1.875
03/13/20
6,000,000.00
100.000
6,000,000.00
0.00
6,000,000.00
2.452
Total for:
Maturities
13,000,000.00
13,000,000.00
21,283.44
13,021,283.44
2.198
Purchases
01/16/20
01/17/20
912828C57
TREAS NOTE
U.S. Treasury
2.250
03/31/21
5,000,000.00
100.777
5,038,867.19
33,504.10
5,072,371.29
1.594
1.594
01/16/20
01/17/20
91282831-2
TREAS NOTE
U.S. Treasury
1.875
12/15/20
5,000,000.00
100.250
5,012,500.00
8,452.87
5,020,952.87
1.597
1.597
01/17/20
01/21/20
78009AKD5
CP- DISC
Royal Bank of Canada
10/13/20
5,000,000.00
98.729
4,936,455.56
0.00
4,936,455.56
1.742
1.742
02/20/20
02/21/20
9128282Z2
TREAS NOTE
U.S. Treasury
1.625
10/15/20
5,000,000.00
100.070
5,003,515.63
28,637.30
5,032,152.93
1.514
1.514
02/20/20
02/21/20
9128283G3
TREAS NOTE
U.S. Treasury
1.750
11/15/20
5,000,000.00
100.168
5,008,398.44
23,557.69
5,031,956.13
1.517
1.517
02/20/20
02/21/20
9128283Q1
TREAS NOTE
U.S. Treasury
2.000
01/15/21
5,000,000.00
100.445
5,022,265.63
10,164.84
5,032,430.47
1.498
1.498
02/20/20
02/21/20
9128283X6
TREAS NOTE
U.S. Treasury
2.250
02/15/21
5,000,000.00
100.746
5,037,304.69
1,854.40
5,039,159.09
1.483
1.483
02/20/20
02/21/20
9128284133
TREAS NOTE
U.S. Treasury
2.375
03/15/21
5,000,000.00
100.945
5,047,265.63
51,871.57
5,099,137.20
1.475
1.475
03/10/20
03/11/20
30229AF46
CP - DISC
Exxon Mobil
06/04/20
5,000,000.00
99.764
4,988,194.44
0.00
4,988,194.44
1.002
1.002
03/12/20
03/12/20
07287CEMO
CP - DISC
Baylor Scott & White
05/21/20
5,000,000.00
99.806
4,990,277.78
0.00
4,990,277.78
1.002
1.002
03/18/20
03/19/20
19865BAG4
CP - INT
Columbia Univ
2.000
05/13/20
5,000,000.00
100.000
5,000,000.00
277.78
5,000,277.78
2.000
2.000
03/20/20
03/23/20
882724PY7
MUNICIPAL
State of TX
4.000
08/27/20
5,000,000.00
100.439
5,021,950.00
109,836.07
5,131,786.07
2.922
2.922
Total for:
Purchases
60,000,000.00
60,106,994.99
268,156.62
60,375,151.61
1.612
1.612
Income Payments
01/24/20
01/24/20
3136G4PC1
AGCY CALL
FNMA
1.750
07/24/20
0.00
43,750.00
43,750.00
03/13/20
03/13/20
313378,177
AGCY BULET
FHLB
1.875
03/13/20
0.00
56,250.00
56,250.00
03/16/20
03/15/20
912828463
TREAS NOTE
U.S. Treasury
2.375
03/15/21
0.00
59,375.00
59,375.00
03/31/20
03/31/20
912828C57
TREAS NOTE
U.S. Treasury
2.250
03/31/21
0.00
56,250.00
56,250.00
Print Date: 4/23/2020 Print Time: 3:26 pm Page 1 of 3
Page 12 of 17
J�*
HilltopSecurities
Asset Management.
City of Southlake
Investment Transactions
From 0110112020 to 03/31/2020
Trade Settle Security Principal Int Purchased 1 Realized
Date Date CUSIP Type Security Description Coupon Mty Date Call Date Par Value Price Amount Received Total Amount Gain I Loss YTM YTW
General Operating
Total for: Income Payments
0.00 215,625.00 215,625.00
Print Date: 4/23/2020 Print Time: 3:26 pm
Page 13 of 17
Page 2 of 3
J�w
HilltopSecurities
Asset Management.
City of Southlake
Investment Transactions
From 0110112020 to 0313112020
Trade Settle Security Principal Int Purchased 1 Realized
Date Date CUSIP Type Security Description Coupon Mty Date Call Date Par Value Price Amount Received Total Amount Gain I Loss YTM YTW
Transaction Type Quantity Total Amount Realized GIL YTM YTW
Total Calls 15,000,000.00
Total Maturities 13,000,000.00
Total Purchases 60,000,000.00
Total Income Payments 0.00
15,050,000.00 2.120 1.916
13,021,283.44 2.198
60,375,151.61 1.612 1.612
215,625.00
Print Date: 4/23/2020 Print Time: 3:26 pm
Page 14 of 17
Page 3 of 3
J�*
HilltopSecurities
Asset Management.
City of Southlake
Amortization and Accretion
From 1213112019 to 03/31/2020
Orig
Amrt/Accr
Total Amrt/Accr
Remaining
CUSIP Settle Date Security Type Security Description Next Call Date Purchase City Price Original Cost
for Period
Since Purch
Disc I Prem Book Value
46640PAH6
04/24/19
CP - DISC
J.P.Morgan Sec 0.000 01/17/20
0.00
98.094
0.00
2,275.56
0.00
0.00
0.00
13068CEA9
12/12/19
CP - INT
State of CA 1.730 03/11/20
0.00
100.000
0.00
0.00
0.00
0.00
0.00
3113378,177
04/23/19
AGCY BULET
FHLB 1.875 03/13/20
0.00
99.495
0.00
6,836.40
0.00
0.00
0.00
19865BAG4
03/19/20
CP - INT
Columbia Univ 2.000 05/13/20
5,000,000.00
100.000
5,000,000.00
0.00
0.00
0.00
5,000,000.00
07287CEMO
03/12/20
CP - DISC
Baylor Scott & White 0.000 05/21/20
5,000,000.00
99.806
4,990,277.78
2,777.77
2,777.77
6,944.45
4,993,055.55
3133EKMP8
05/31/19
AGCY BULET
FFCB 2.310 05/28/20
5,000,000.00
99.985
4,999,250.00
188.75
630.45
119.55
4,999,880.45
30229AF46
03/11/20
CP - DISC
Exxon Mobil 0.000 06/04/20
5,000,000.00
99.764
4,988,194.44
2,916.66
2,916.66
8,888.90
4,991,111.10
09657TGJ6
09/17/19
CP - INT
Univ of NC 1.980 06/11/20
2,350,000.00
100.000
2,350,000.00
0.00
0.00
0.00
2,350,000.00
3135GOD75
04/23/19
AGCY BULET
FNMA 1.500 06/22/20
6,000,000.00
98.911
5,934,660.00
14,135.40
52,618.08
12,721.92
5,987,278.08
3136G4PC1
05/31/19
AGCY CALL
FNMA 1.750 07/24/20
01/24/20 0.00
99.313
0.00
16,975.65
0.00
0.00
0.00
882724PY7
03/23/20
MUNICIPAL
State of TX 4.000 08/27/20
5,000,000.00
100.439
5,021,950.00
(1,258.30)
(1,258.30)
(20,691.70)
5,020,691.70
78009AKD5
01/21/20
CP- DISC
Royal Bank of Canada 0.000 10/13/20
5,000,000.00
98.729
4,936,455.56
16,961.09
16,961.09
46,583.35
4,953,416.65
9128282Z2
02/21/20
TREAS NOTE
U.S. Treasury 1.625 10/15/20
5,000,000.00
100.070
5,003,515.63
(572.88)
(572.88)
(2,942.75)
5,002,942.75
3130AHEM1
10/25/19
AGCY BULET
FHLB 1.625 10/23/20
10,000,000.00
99.995
9,999,500.00
126.10
218.60
281.40
9,999,718.60
9128283G3
05/31/19
TREAS NOTE
U.S. Treasury 1.750 11/15/20
10,000,000.00
100.168
9,978,320.32
3,912.06
15,914.28
5,765.40
9,994,234.60
91282831-2
01/17/20
TREAS NOTE
U.S. Treasury 1.875 12/15/20
5,000,000.00
100.250
5,012,500.00
(2,796.55)
(2,796.55)
(9,703.45)
5,009,703.45
9128283Q1
02/21/20
TREAS NOTE
U.S. Treasury 2.000 01/15/21
5,000,000.00
100.445
5,022,265.63
(2,708.83)
(2,708.83)
(19,556.80)
5,019,556.80
9128283X6
02/21/20
TREAS NOTE
U.S. Treasury 2.250 02/15/21
5,000,000.00
100.746
5,037,304.69
(4,151.94)
(4,151.94)
(33,152.75)
5,033,152.75
9128284133
02/21/20
TREAS NOTE
U.S. Treasury 2.375 03/15/21
5,000,000.00
100.945
5,047,265.63
(4,813.93)
(4,813.93)
(42,451.70)
5,042,451.70
912828C57
01/17/20
TREAS NOTE
U.S. Treasury 2.250 03/31/21
5,000,000.00
100.777
5,038,867.19
(6,528.44)
(6,528.44)
(32,338.75)
5,032,338.75
3134GULE8
10/28/19
AGCY CALL
FHLMC 2.000 10/28/21
01/28/20 0.00
100.000
0.00
0.00
0.00
0.00
0.00
Total for General Operating
88,350,000.00
88,360,326.87
44,274.57
69,206.06
(79,532.93)
88,429,532.93
Total for City
of Southlake
88,350,000.00
88,360,326.87
44,274.57
69,206.06
(79,532.93)
88,429,532.93
Print Date: 4/23/2020 Print Time: 3:26 pm Page 1 of 1
Page 15 of 17
J�*
HilltopSecurities
Asset Management..
City of Southlake
Projected Cash Flows
Cash Flows for next 180 days from 03/31/2020
CUSIP Security Type Security Description Pay Date Interest Principal Total Amount
General Operating
9128282Z2
TREAS NOTE
U.S. Treasury 1.625 10/15/20
04/15/20
40,625.00
0.00
40,625.00
3130AHEM1
AGCY BULET
FHLB 1.625 10/23/20
04/23/20
81,250.00
0.00
81,250.00
19865BAG4
CP - INT
Columbia Univ 2.000 05/13/20
05/13/20
15,555.55
5,000,000.00
5,015,555.55
9128283G3
TREAS NOTE
U.S. Treasury 1.750 11/15/20
05/15/20
87,500.00
0.00
87,500.00
07287CEMO
CP - DISC
Bavlor Scott & White 0.000 05/21/20
05/21/20
0.00
5,000,000.00
5,000,000.00
3133EKMP8
AGCY BULET
FFCB 2.310 05/28/20
05/28/20
57,750.00
5,000,000.00
5,057,750.00
30229AF46
CP - DISC
Exxon Mobil 0.000 06/04/20
06/04/20
0.00
5,000,000.00
5,000,000.00
09657TGJ6
CP - INT
Univ of NC 1.980 06/11/20
06/11/20
34,071.14
2,350,000.00
2,384,071.14
91282831-2
TREAS NOTE
U.S. Treasury 1.875 12/15/20
06/15/20
46,875.00
0.00
46,875.00
3135GOD75
AGCY BULET
FNMA 1.500 06/22/20
06/22/20
45,000.00
6,000,000.00
6,045,000.00
9128283Q1
TREAS NOTE
U.S. Treasury 2.000 01/15/21
07/15/20
50,000.00
0.00
50,000.00
9128283X6
TREAS NOTE
U.S. Treasury 2.250 02/15/21
08/15/20
56,250.00
0.00
56,250.00
882724PY7
MUNICIPAL
State of TX 4.000 08/27/20
08/27/20
200,000.00
5,000,000.00
5,200,000.00
9128284133
TREAS NOTE
U.S. Treasury 2.375 03/15/21
09/15/20
59,375.00
0.00
59,375.00
Total for General Operating 774,251.69 33,350,000.00 34,124,251.69
Print Date: 4/23/2020 Print Time: 3:26 pm Page 1 of 2
Page 16 of 17
1�*
HilltopSecurities
Asset Management_
City of Southlake
Projected Cash Flows
Cash Flows for next 180 days from 03/31/2020
CUSIP Security Type Security Description Pay Date Interest Principal Total Amount
April 2020
121,875.00
0.00
121,875.00
May 2020
160,805.55
15,000,000.00
15,160,805.55
June 2020
125,946.14
13,350,000.00
13,475,946.14
July 2020
50,000.00
0.00
50,000.00
August 2020
256,250.00
5,000,000.00
5,256,250.00
September 2020
59,375.00
0.00
59,375.00
Total Projected Cash Flows for City of Southlake 774,251.69 33,350,000.00 34,124,251.69
Print Date: 4/23/2020 Print Time: 3:26 pm Page 2 of 2
Page 17 of 17