Item 3B1 Financial ReportReference
Page 3
Page 3
Page 4
Page 4
Page 5
MONTHLY FINANCIAL REPORT
July 2019
= Negative Variance of > 4% compared to seasonal trends.
Warning
Negative
PERFORMANCE AT A GLANCE
Year to Date 3 year Trend
Positive
PERFORMANCE INDICATORS
Positive
Warning
Permit Revenues
Positive Positive
Departmental Expenditures Summary Positive
= Negative variance of 1-4% compared to seasonal trends
= Positive variance or negative variance <1% compared to seasonal trends.
GENERAL FUND
PositiveGeneral Fund Exp. Vs. Rev.
Sales Tax Revenue (2 months prior activity)
Property Tax Revenue
Positive
Positive Negative
Positive
City of Southlake Monthly Financial Report 1 8/14/2019
National GDP:
Housing Starts:
Housing starts in June 2019 were at a seasonally
adjusted rate of 1,253,000, which is 0.9% below the
revised May figure of 1,265,000, but 6.2% above
the same month last year.
0.9%
UNEMPLOYMENT RATES
3.7%
The Dallas/Fort Worth/Arlington Metropolitan Area
unemployment rate for June 2019 increased to
3.3% (preliminary) when compared to 2.7% in May
2019.
3.3%
State-wide:3.4%
The Texas Unemployment rate for June 2019
decreased to 3.4% (preliminary) when compared to
3.5% in May 2019.
DFW Area:
ECONOMIC INDICATORS
NATIONAL ECONOMY
FINANCIAL ACTIVITY2.10%
GDP is defined as the output of goods and
services 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 2nd quarter of 2019
increased at a rate of 2.1%. In the 1st quarter of
2019, GDP increased at a rate of 3.1%.
The National Unemployment rate for July 2019
remains unchanged at 3.7% when compared to
June 2019.
National:
5 YEAR TREND OF NEW CONSTRUCTION PERMIT VALUES
$-
$50,000,000
$100,000,000
$150,000,000
$200,000,000
$250,000,000
2015*2016*2017*2018*2019*
Construction permit values*October-July
City of Southlake Monthly Financial Report 2 8/14/2019
FY 2019
REVENUE
FY 2019
EXPENDITURE VARIANCE
Oct 1,961,498$ 2,322,392$ (360,894)$
Nov 2,186,077$ 3,557,416$ (1,371,339)$
Dec 12,013,491$ 3,156,232$ 8,857,259$
Jan 11,895,339$ 2,736,019$ 9,159,320$
Feb 6,213,131$ 3,254,819$ 2,958,312$
Mar 1,920,968$ 3,504,128$ (1,583,160)$
Apr 1,984,450$ 2,792,483$ (808,033)$
May 2,861,030$ 3,286,854$ (425,824)$
Jun 2,109,311$ 2,715,569$ (606,258)$
Jul 930,899$ 2,975,685$ (2,044,786)$
Aug -$ -$ -$
Sep -$
Tot 44,076,194$ 30,301,597$ 13,774,597$
POSITIVE
FY 2019 FY 2018 FY 2017
Oct 1,253,417$ 1,214,148$ 1,198,502$
Nov 1,140,440$ 1,272,500$ 1,449,661$
Dec 1,613,337$ 1,744,684$ 1,556,737$
Jan 1,030,047$ 1,135,430$ 1,129,266$
Feb 1,094,354$ 1,055,400$ 853,929$
Mar 1,321,691$ 1,251,079$ 1,326,630$
Apr 1,294,023$ 1,096,365$ 1,195,811$
May 1,295,321$ 1,363,921$ 1,185,530$
Jun 1,274,338$ 1,292,089$ 1,243,537$
Jul -$ 1,206,050$ 1,155,660$
Aug 1,265,360$ 1,262,402$
Sep $1,227,621 1,318,543$
Tot 11,316,967$ 15,124,646$ 14,876,208$
GENERAL FUND REVENUE VS EXPENDITURES 2019
OVERALL FUND PERFORMANCE:
REVENUE ANALYSIS
GENERAL FUND SALES TAX 2019-2017 COMPARISON
CHART OUTLOOK:
GENERAL FUND
CHART OUTLOOK:
The outlook for the year is positive as revenues are outpacing expenditures by $13.8M.
Year to date sales tax collections are trending below the 2 previous years with the largest variance in the first quarter (October-December)which is primarily related to construction and a few retailers trending in the
red. YTD the FY 2019 collections are 1.59% above FY 2017 and 1.0% below FY 2018 collections. Staff will continue to closely monitor collections.
Warning
$-
$200,000
$400,000
$600,000
$800,000
$1,000,000
$1,200,000
$1,400,000
$1,600,000
$1,800,000
$2,000,000
FY 2019 FY 2018 FY 2017
$-
$2,000,000
$4,000,000
$6,000,000
$8,000,000
$10,000,000
$12,000,000
$14,000,000
Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep
FY 2019 REVENUE FY 2019 EXPENDITURE 2018 EXPEND.
City of Southlake Monthly Financial Report 3 8/14/2019
FY 2019 FY 2018 FY 2017
Oct 1,151,812$ 217,086$ 658,177$
Nov 1,552,708$ 1,832,023$ 1,237,982$
Dec 10,397,278$ 6,601,683$ 9,403,107$
Jan 9,985,201$ 12,435,268$ 8,618,274$
Feb 3,385,436$ 3,744,931$ 2,935,185$
Mar 395,710$ 196,116$ 341,747$
Apr 156,647$ 102,531$ 161,330$
May -$ 99,690$ 111,591$
Jun 312,620$ 426,191$ -$
Jul *(1,295,201)$ (1,431,282)$ (614,593)$
Aug -$ -$ 44,839$
Sep -$ 70,888$ 15,952$
Tot 26,042,211$ 24,295,125$ 22,913,591$
POSITIVE
FY 2019 FY 2018 FY 2017
Oct 85,534$ 126,131$ 81,765$
Nov 75,588$ 145,755$ 121,569$
Dec 160,859$ 87,701$ 133,374$
Jan 121,526$ 126,075$ 120,595$
Feb 121,533$ 199,087$ 66,545$
Mar 186,152$ 229,059$ 159,631$
Apr 111,970$ 126,788$ 208,205$
May 601,621$ 98,364$ 153,442$
Jun 111,503$ 162,515$ 243,119$
Jul 163,760$ 168,508$ 108,137$
Aug -$ 185,552$ 114,751$
Sep 223,441$ 154,374$
Tot 1,740,046$ 1,878,976$ 1,665,507$
PERMIT REVENUE 2018-2016 COMPARISON
CHART OUTLOOK:
GENERAL FUND
REVENUE ANALYSIS (continued)
PROPERTY TAX 3 YEAR TREND
CHART OUTLOOK:
2019 YTD property tax collections ($26,042,211)are approximately 7.5%higher than 2018 YTD ($24,224,237)as of July.As indicated on the chart,the majority of the property tax revenue is collected in the first few
months of the fiscal year.
* Net transfer of TIF revenues to
TIF fund
The value of new construction permits ($128.7M+)issued for FY 2019 YTD is approximately 6.45%and .61%below when compared to FY 2018 and FY 2017 respectively.Until May,FY 2019 permit values were
trending approximately 20% below FY 2018 and 2017 the noted change is specifically due to two new construction permits issued in early May 2019.
Warning
$(4,000,000)
$(2,000,000)
$-
$2,000,000
$4,000,000
$6,000,000
$8,000,000
$10,000,000
$12,000,000
$14,000,000
Oct Nov Dec Jan Feb Mar Apr May Jun Jul *Aug
FY 2019 FY 2018 FY 2017
$-
$100,000
$200,000
$300,000
$400,000
$500,000
$600,000
$700,000
Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep
FY 2019 FY 2018 FY 2017
City of Southlake Monthly Financial Report 4 8/14/2019
FY 2019 YTD
(JULY)
FY 2018 YTD
(JULY)FY 2019 BUDGET
B
U
D FY 2019 % SPENT
766,664$ 729,176$ 975,301$ 78.61%
335,352$ 335,108$ 451,642$ 74.25%
4,515,674$ 4,915,596$ 5,962,023$ 75.74%
365,203$ 357,710$ 525,624$ 69.48%
13,805,262$ 13,383,958$ 17,814,605$ 77.49%
97,823$ 116,742$ 141,254$ 69.25%
1,881,509$ 1,779,726$ 2,443,295$ 77.01%
613,226$ 597,144$ 820,876$ 74.70%
1,754,917$ 1,442,363$ 2,118,827$ 82.82%
1,690,687$ 1,667,592$ 2,275,733$ 74.29%
3,482,425$ 3,503,815$ 4,925,899$ 70.70%
994,233$ 941,009$ 1,429,329$ 69.56%
30,302,975$ 29,769,939$ 39,884,408$ 75.98%
EXPENDITURE ANALYSIS
POSITIVE
(312,554)$
160,421$
4,009,343$
43,431$
561,786$
207,650$
363,910$
CSO
DPS
ED
FIN
HR
IT
DEPARTMENTAL EXPENDITURES SUMMARY
(244)$ 116,290$
BUDGET VARIANCE
208,637$
1,446,349$
(23,095)$
21,390$
(53,224)$
(533,036)$
As indicated on the chart the 2019 expenditures are comparable to 2018 expenditures for the same period with an increase of 1.79%primarily due to approved pay plan adjustments.The outlook is positive
expenditures are on pace to be below budgeted expenditures for the fiscal year.
FY 2018/2019 YTD
VARIANCE
(37,488)$
399,922$
(7,493)$
(421,304)$
18,919$
(101,783)$
SS
Totals
PW
CMO
CS
COMM
9,581,433$
CHART OUTLOOK:
435,096$
1,443,474$
(16,082)$
585,046$ PDS
$-
$2,000,000
$4,000,000
$6,000,000
$8,000,000
$10,000,000
$12,000,000
$14,000,000
$16,000,000
$18,000,000
CMO COMM CS CSO DPS ED FIN HR IT PDS PW SS
FY 2019 YTD (JULY)FY 2018 YTD (JULY)FY 2019 BUDGET
City of Southlake Monthly Financial Report 5 8/14/2019
City of Southlake
Investment Portfolio Summary
June 30, 2019
For the Quarter Ended
Prepared by
HilltopSecurities Asset Management
Table of Contents / Market Recap
Report Name
Executive Summary
Benchmark Comparison
Detail of Security Holdings
Change in Value
Earned Income
Investment Transactions
Amortization and Accretion
Projected Fixed Income Cash Flows
Certification Page
MARKET RECAP - JUNE 2019:
June started off on a sour note as trade tensions ramped up after the administration threatened tariffs
on Mexican imports in an attempt to address issues with immigration and border security. A week
later, it was announced the tariffs would not take effect as the Mexican government had agreed to step
up their efforts at the border. The trade outlook with China dimmed after the President reiterated his
firm stance on tariffs and China pledged to “fight to the end.” All eyes were on the G-20 Summit in late
June in hope of something resembling a resolution. The meeting ultimately resulted in a cease-fire and
an agreement to restart negotiations, sending the S&P 500 to a new all-time high.
Factory managers are feeling the effects of tariffs, while their more domestically focused service sector
counterparts appear better insulated. The ISM manufacturing index continued its descent in May,
sliding to the lowest level since October 2016 at 52.1. In contrast, the ISM non-manufacturing index
rose to 56.9 in May, its highest level since February, with the employment component reaching a
two-year high. Nonfarm payrolls added just 75k jobs in May, falling well below the Bloomberg median
forecast for 175k. Downward revisions to March and April subtracted a net 75k jobs, completely
negating the May gains. Headline unemployment held steady at a five-decade low of 3.6%, but this
was bit deceptive as the participation rate has retreated over the last three months and was back near
a 40-year low. May retail sales rose by +0.5%, just below the median forecast, but the big surprise was
a recalculation of April sales, revised significantly higher from -0.2% to +0.3%. The important “control
group” figure used in GDP calculations climbed +0.5% in May, while April was revised upward from
0.0% to +0.4%. The Consumer Price Index showed less price pressure than expected as both
headline and core CPI rose by just +0.1% during May. On a year-over-year basis, overall consumer
inflation slowed from +2.0% to +1.8%, while core CPI slowed from +2.1% to +2.0%. Fed Chair Jerome
Powell has said on a number of occasions that the lack of price pressures early in the year is
transitory, suggesting that the Fed was willing to wait patiently for inflation to turn upward. The weak
CPI report disputes this transitory idea and supports the market’s belief that the Fed will cut the
overnight rate this summer.
At its mid-June meeting, the FOMC voted to hold the fed funds target rate steady in a range from
2.25% to 2.50%. However, the decision was not unanimous as St. Louis Fed President James Bullard
preferred an immediate 25 basis point cut. As expected, the committee altered its message, shifting
dovishly and opening the door to rate cuts in the near future. Following the FOMC meeting, a wave of
new rate forecasts were published, with many Wall Street economists completely shifting gears.
Bloomberg unexpectedly released a mid-month update to its survey of economists because so many
opinions had changed. The majority surveyed now expect between 25 and 75 basis points of easing
this year, with the first rate cut expected at the end of July. Bond yields continued their slide with the
two-year Treasury note closing the month at 1.76% and the 10-year at 2.00%.
Page 2 of 15
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 report
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.
June 30, 2019
For the Quarter Ended
Officer Names and Titles:
Name: Sharen Jackson Title: Chief Financial Officer
Name: Mary Morgan Title: Deputy Director of Finance
Page 3 of 15
Sharen Jackson
Mary Morgan
Executive Summary
As of 06/30/19
City of Southlake
131,565,173.01
131,597,855.07
131,655,013.01
(32,682.06)Unrealized Gain /(Loss)
Par Value
Book Value
Beginning Values as of 03/31/19
Market Value
Market Value % 99.98%
Weighted Avg. YTW
Weighted Avg. YTM 2.313%
2.313%
Account Summary
Ending Values as of 06/30/19
162,235,497.34
162,144,111.41
162,335,586.24
91,385.93
100.06%
2.333%
2.333%
Allocation by Security Type
AGCY BULLET 17%
AGCY CALL 5%
CP 7%
LGIP 68%
TREASURY 3%
Total:100%
TEXPOOL 42%
TEXSTAR 21%
FNMA 10%
FHLB 7%
FFCB 5%
TXCLASS 3%
Other Issuers 13%
Total:100%
Allocation by Issuer
0%
10%
20%
30%
40%
50%
60%
70%
Overnight 2 - 90 Days 91 - 180 Days 6 - 12 Months 1 - 2 Years
68%
8%6%
12%
6%
Maturity Distribution %
Weighted Average Days to Maturity: 75
A-1+7%
AAA 93%
Total:100%
Credit Quality
Page 1 of 1Print Date: 7/12/2019 Print Time: 8:13 am
Page 4 of 15
As of 06/30/2019
Benchmark Comparison
City of Southlake
0.00%
0.40%
0.80%
1.20%
1.60%
2.00%
2.40%
2.80%
Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 Jan-19 Feb-19 Mar-19 Apr-19 May-19 Jun-19
1-YR CMT 3-MO CMT 6-MO CMT TEXPOOL City of Southlake
Note 2: Benchmark data for TexPool is the monthly average yield.
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 CMT's are the daily averages for the previous 12-months.
Page 1 of 1Print Time: 8:14 amPrint Date: 7/12/2019
Page 5 of 15
Mty DateCUSIPSec. Description CPN Par Value Orig Cost Book Value Market Value
Detail of Security Holdings
As of 06/30/2019
Sec. Type
Mkt
Price
Days
to Mty
Days
to CallNext Call
City of Southlake
YTM
Settle
Date YTWCall Type
Purch
Price
Crime Control District
4,132,191.07 4,132,191.07 4,132,191.07 4,132,191.07TEXSTARTexSTAR 1LGIP 100.000 100.000 2.379 2.379
4,132,191.07 4,132,191.07 4,132,191.07 4,132,191.07 1Total for Crime Control District 100.000 100.000 2.379 2.379
General Operating
1,097,487.95 1,097,487.95 1,097,487.95 1,097,487.95LNSTCRPLoneStar Corp O/N 1LGIP 100.000 100.000 2.500 2.500
2,644,242.10 2,644,242.10 2,644,242.10 2,644,242.10LNSTGOVLoneStar Gov O/N 1LGIP 100.000 100.000 2.380 2.380
67,842,137.69 67,842,137.69 67,842,137.69 67,842,137.69TEXPOOLTexPool 1LGIP 100.000 100.000 2.381 2.381
24,952,739.35 24,952,739.35 24,952,739.35 24,952,739.35TEXSTARTexSTAR 1LGIP 100.000 100.000 2.379 2.379
5,217,984.09 5,217,984.09 5,217,984.09 5,217,984.09TXCLASSTexas CLASS 1LGIP 100.000 100.000 2.500 2.500
3,000,000.00 2,996,250.00 2,999,985.84 2,999,632.2007/12/16 1.123 1.123FFCB3133EGJX4AGCY CALL Anytime 1.080 07/05/19 CONT 99.875 99.988 5 5
5,000,000.00 5,000,230.00 5,000,012.40 4,995,795.0008/23/17 1.408 1.408FHLB3130ABZX7AGCY BULET 1.410 08/07/19 100.005 99.916 38
5,000,000.00 5,000,000.00 5,000,000.00 5,000,400.0006/18/19 2.350 2.350State of CA13068CDR3CP - INT 2.350 09/16/19 100.000 100.008 78
5,000,000.00 4,905,800.00 4,976,543.75 4,981,573.0007/16/18 2.513 2.513FNMA3135G0R39AGCY BULET 1.000 10/24/19 98.116 99.631 116
5,000,000.00 5,000,000.00 5,000,000.00 4,999,100.0006/14/19 2.350 2.350TX A&M Univ88213M5E5CP - INT 2.350 11/05/19 100.000 99.982 128
2,000,000.00 1,961,884.44 1,971,555.56 1,974,940.8004/24/19 2.610 2.610J.P.Morgan Sec46640PAH6CP - DISC 01/17/20 98.094 98.747 201
6,000,000.00 5,969,700.00 5,976,115.80 5,991,707.4004/23/19 2.452 2.452FHLB313378J77AGCY BULET 1.875 03/13/20 99.495 99.862 257
5,000,000.00 4,999,250.00 4,999,314.85 5,010,483.5005/31/19 2.325 2.325FFCB3133EKMP8AGCY BULET 2.310 05/28/20 99.985 100.210 333
6,000,000.00 5,934,660.00 5,945,197.32 5,971,264.2004/23/19 2.454 2.454FNMA3135G0D75AGCY BULET 1.500 06/22/20 98.911 99.521 358
5,000,000.00 4,965,625.00 4,968,154.55 4,983,023.0005/31/19 2.360 2.360FNMA3136G4PC1AGCY CALL 7/24/2019 1.750 07/24/20 QRTLY 99.313 99.660 390 24
5,000,000.00 4,969,921.88 4,971,645.10 4,991,992.0005/31/19 2.172 2.172U.S. Treasury9128283G3TREAS NOTE 1.750 11/15/20 99.398 99.840 504
153,754,591.18 153,457,912.50 153,563,116.35 153,654,502.28 79Total for General Operating 99.808 99.935 2.331 2.331
Parks Development Corporation
4,448,803.99 4,448,803.99 4,448,803.99 4,448,803.99TEXSTARTexSTAR 1LGIP 100.000 100.000 2.379 2.379
4,448,803.99 4,448,803.99 4,448,803.99 4,448,803.99 1Total for Parks Development Corporation 100.000 100.000 2.379 2.379
162,335,586.24 162,038,907.56 162,144,111.41 162,235,497.34 75Total for City of Southlake 99.818 99.939 2.333 2.333 0
Print Date: 7/12/2019 Print Time: 8:14 am Page 1 of 1
Page 6 of 15
CUSIP
Change in Value
From 03/31/2019 to 06/30/2019
Amortization /
Accretion
Realized
Gain/(Loss) Book Value
Cost of
Purchases
Market ValueMarket Value
Book Value
Maturities /
Calls / Sales
City of Southlake
Change in
Mkt Value
03/31/19 06/30/19 06/30/1903/31/19Security Type Security Description
Community Enhancement Dev Corp
TEXPOOL 0.00 0.00 22,711,378.61 0.00 22,711,378.61 91,839.39 0.00 (22,803,218.00)LGIP (22,711,378.61)TexPool
0.00 0.00 Total for Community Enhancement Dev Corp 22,711,378.61 0.00 22,711,378.61 91,839.39 (22,803,218.00) 0.00 (22,711,378.61)
Crime Control District
TEXSTAR 0.00 4,132,191.07 4,107,537.30 4,132,191.07 4,107,537.30 24,653.77 0.00 0.00 LGIP 24,653.77 TexSTAR
4,132,191.07 0.00 Total for Crime Control District 4,107,537.30 4,132,191.07 4,107,537.30 24,653.77 0.00 0.00 24,653.77
General Operating
LNSTCRP 0.00 1,097,487.95 1,090,578.82 1,097,487.95 1,090,578.82 6,909.13 0.00 0.00 LGIP 6,909.13 LoneStar Corp O/N
LNSTGOV 0.00 2,644,242.10 2,628,489.81 2,644,242.10 2,628,489.81 15,752.29 0.00 0.00 LGIP 15,752.29 LoneStar Gov O/N
TEXPOOL 0.00 67,842,137.69 29,025,600.96 67,842,137.69 29,025,600.96 41,439,528.97 0.00 (2,622,992.24)LGIP 38,816,536.73 TexPool
TEXSTAR 0.00 24,952,739.35 24,803,864.79 24,952,739.35 24,803,864.79 148,874.56 0.00 0.00 LGIP 148,874.56 TexSTAR
TXCLASS 0.00 5,217,984.09 5,184,940.15 5,217,984.09 5,184,940.15 33,043.94 0.00 0.00 LGIP 33,043.94 Texas CLASS
3130A7R72 0.00 0.00 4,995,650.00 0.00 4,999,868.30 0.00 131.70 (5,000,000.00)AGCY CALL (4,995,650.00)FHLB 1.250 04/29/19
912828R85 0.00 0.00 4,983,600.00 0.00 4,985,342.25 0.00 14,657.75 (5,000,000.00)TREAS NOTE (4,983,600.00)U.S. Treasury 0.875 06/15/19
3133EGJX4 0.00 2,999,985.84 2,990,160.00 2,999,632.20 2,999,667.06 0.00 318.78 0.00 AGCY CALL 9,472.20 FFCB 1.080 07/05/19
3130ABZX7 0.00 5,000,012.40 4,981,650.00 4,995,795.00 5,000,043.40 0.00 (31.00) 0.00 AGCY BULET 14,145.00 FHLB 1.410 08/07/19
13068CDR3 0.00 5,000,000.00 0.00 5,000,400.00 0.00 5,000,000.00 0.00 0.00 CP - INT 5,000,400.00 State of CA 2.350 09/16/19
3135G0R39 0.00 4,976,543.75 4,959,100.00 4,981,573.00 4,957,921.05 0.00 18,622.70 0.00 AGCY BULET 22,473.00 FNMA 1.000 10/24/19
88213M5E5 0.00 5,000,000.00 0.00 4,999,100.00 0.00 5,000,000.00 0.00 0.00 CP - INT 4,999,100.00 TX A&M Univ 2.350 11/05/19
46640PAH6 0.00 1,971,555.56 0.00 1,974,940.80 0.00 1,961,884.44 9,671.12 0.00 CP - DISC 1,974,940.80 J.P.Morgan Sec 0.000 01/17/20
313378J77 0.00 5,976,115.80 0.00 5,991,707.40 0.00 5,969,700.00 6,415.80 0.00 AGCY BULET 5,991,707.40 FHLB 1.875 03/13/20
3133EKMP8 0.00 4,999,314.85 0.00 5,010,483.50 0.00 4,999,250.00 64.85 0.00 AGCY BULET 5,010,483.50 FFCB 2.310 05/28/20
3135G0D75 0.00 5,945,197.32 0.00 5,971,264.20 0.00 5,934,660.00 10,537.32 0.00 AGCY BULET 5,971,264.20 FNMA 1.500 06/22/20
3136G4PC1 0.00 4,968,154.55 0.00 4,983,023.00 0.00 4,965,625.00 2,529.55 0.00 AGCY CALL 4,983,023.00 FNMA 1.750 07/24/20
9128283G3 0.00 4,971,645.10 0.00 4,991,992.00 0.00 4,969,921.88 1,723.22 0.00 TREAS NOTE 4,991,992.00 U.S. Treasury 1.750 11/15/20
153,563,116.35 0.00 Total for General Operating 85,643,634.53 153,654,502.28 85,676,316.59 80,445,150.21 (12,622,992.24) 64,641.79 68,010,867.75
Print Date: 7/12/2019 Print Time: 8:14 am Page 1 of 2
Page 7 of 15
CUSIP
Change in Value
From 03/31/2019 to 06/30/2019
Amortization /
Accretion
Realized
Gain/(Loss) Book Value
Cost of
Purchases
Market ValueMarket Value
Book Value
Maturities /
Calls / Sales
City of Southlake
Change in
Mkt Value
03/31/19 06/30/19 06/30/1903/31/19Security Type Security Description
Parks Development Corporation
TEXPOOL 0.00 0.00 14,680,361.29 0.00 14,680,361.29 59,363.85 0.00 (14,739,725.14)LGIP (14,680,361.29)TexPool
TEXSTAR 0.00 4,448,803.99 4,422,261.28 4,448,803.99 4,422,261.28 26,542.71 0.00 0.00 LGIP 26,542.71 TexSTAR
4,448,803.99 0.00 Total for Parks Development Corporation 19,102,622.57 4,448,803.99 19,102,622.57 85,906.56 (14,739,725.14) 0.00 (14,653,818.58)
0.00 162,144,111.41 Total for City of Southlake 131,565,173.01 162,235,497.34 131,597,855.07 80,647,549.93 (50,165,935.38) 64,641.79 30,670,324.33
Print Date: 7/12/2019 Print Time: 8:14 am Page 2 of 2
Page 8 of 15
From 03/31/2019 to 06/30/2019
City of Southlake
Beg. Accrued Net Income Security DescriptionCUSIP Disc Accr /
Prem Amort
Earned Income
Interest Earned Interest Rec'd /
Sold / Matured
Interest Purchased Ending AccruedSecurity Type
Community Enhancement Dev Corp
TEXPOOL TexPool 0.00 91,839.39 0.00 0.00 91,839.39 91,839.39 LGIP 0.00
0.00 91,839.39 0.00 91,839.39 0.00 91,839.39 Total for Community Enhancement Dev Corp 0.00
Crime Control District
TEXSTAR TexSTAR 0.00 24,653.77 0.00 0.00 24,653.77 24,653.77 LGIP 0.00
0.00 24,653.77 0.00 24,653.77 0.00 24,653.77 Total for Crime Control District 0.00
General Operating
LNSTCRP LoneStar Corp O/N 0.00 6,909.13 0.00 0.00 6,909.13 6,909.13 LGIP 0.00
LNSTGOV LoneStar Gov O/N 0.00 15,752.29 0.00 0.00 15,752.29 15,752.29 LGIP 0.00
TEXPOOL TexPool 0.00 238,820.59 0.00 0.00 238,820.59 238,820.59 LGIP 0.00
TEXSTAR TexSTAR 0.00 148,874.56 0.00 0.00 148,874.56 148,874.56 LGIP 0.00
TXCLASS Texas CLASS 0.00 33,043.94 0.00 0.00 33,043.94 33,043.94 LGIP 0.00
3130A7R72 FHLB 1.250 04/29/19 0.00 4,992.81 26,388.89 0.00 4,861.11 31,250.00 AGCY CALL 131.70
912828R85 U.S. Treasury 0.875 06/15/19 0.00 23,672.17 12,860.58 0.00 9,014.42 21,875.00 TREAS NOTE 14,657.75
3133EGJX4 FFCB 1.080 07/05/19 0.00 8,418.78 7,740.00 15,840.00 8,100.00 0.00 AGCY CALL 318.78
3130ABZX7 FHLB 1.410 08/07/19 0.00 17,594.00 10,575.00 28,200.00 17,625.00 0.00 AGCY BULET (31.00)
13068CDR3 State of CA 2.350 09/16/19 0.00 4,184.93 0.00 4,184.93 4,184.93 0.00 CP - INT 0.00
3135G0R39 FNMA 1.000 10/24/19 0.00 31,122.70 21,805.56 9,305.56 12,500.00 25,000.00 AGCY BULET 18,622.70
88213M5E5 TX A&M Univ 2.350 11/05/19 0.00 5,472.60 0.00 5,472.60 5,472.60 0.00 CP - INT 0.00
46640PAH6 J.P.Morgan Sec 0.000 01/17/20 0.00 9,671.12 0.00 0.00 0.00 0.00 CP - DISC 9,671.12
313378J77 FHLB 1.875 03/13/20 (12,500.00) 27,665.80 0.00 33,750.00 21,250.00 0.00 AGCY BULET 6,415.80
3133EKMP8 FFCB 2.310 05/28/20 (962.50) 9,689.85 0.00 10,587.50 9,625.00 0.00 AGCY BULET 64.85
3135G0D75 FNMA 1.500 06/22/20 (30,250.00) 27,537.32 0.00 2,250.00 17,000.00 45,000.00 AGCY BULET 10,537.32
3136G4PC1 FNMA 1.750 07/24/20 (30,868.06) 9,821.21 0.00 38,159.72 7,291.66 0.00 AGCY CALL 2,529.55
9128283G3 U.S. Treasury 1.750 11/15/20 (3,804.35) 9,094.14 0.00 11,175.27 7,370.92 0.00 TREAS NOTE 1,723.22
(78,384.91) 632,337.94 158,925.58 567,696.15 79,370.03 566,525.51 Total for General Operating 64,641.79
Print Time: 8:14 amPrint Date: 7/12/2019 Page 1 of 2
Page 9 of 15
From 03/31/2019 to 06/30/2019
City of Southlake
Beg. Accrued Net Income Security DescriptionCUSIP Disc Accr /
Prem Amort
Earned Income
Interest Earned Interest Rec'd /
Sold / Matured
Interest Purchased Ending AccruedSecurity Type
Parks Development Corporation
TEXPOOL TexPool 0.00 59,363.85 0.00 0.00 59,363.85 59,363.85 LGIP 0.00
TEXSTAR TexSTAR 0.00 26,542.71 0.00 0.00 26,542.71 26,542.71 LGIP 0.00
0.00 85,906.56 0.00 85,906.56 0.00 85,906.56 Total for Parks Development Corporation 0.00
(78,384.91) 834,737.66 79,370.03 158,925.58 770,095.87 768,925.23 Total for City of Southlake 64,641.79
Print Time: 8:14 amPrint Date: 7/12/2019 Page 2 of 2
Page 10 of 15
Investment Transactions
CUSIP Price Total AmountSecurity Description
From 04/01/2019 to 06/30/2019
Security
Type Coupon Mty Date Call Date
Trade
Date
Settle
Date Par Value
City of Southlake
Realized
Gain / Loss YTM YTW
Principal
Amount
Int Purchased /
Received
General Operating
Maturities
100.00004/29/19 1.250FHLBAGCY CALL3130A7R7204/29/1904/29/19 5,000,000.00 5,000,000.00 1.284 0.00 5,000,000.00
100.00006/15/19 0.875U.S. TreasuryTREAS NOTE912828R8506/15/1906/15/19 5,000,000.00 5,000,000.00 2.314 0.00 5,000,000.00
10,000,000.00 10,000,000.00 Total for: Maturities 1.799 10,000,000.00 0.00
Purchases
99.49503/13/20 1.875FHLBAGCY BULET313378J7704/23/1904/22/19 6,000,000.00 5,982,200.00 2.452 2.452 12,500.00 5,969,700.00
98.91106/22/20 1.500FNMAAGCY BULET3135G0D7504/23/1904/22/19 6,000,000.00 5,964,910.00 2.454 2.454 30,250.00 5,934,660.00
98.09401/17/20J.P.Morgan SecCP - DISC46640PAH604/24/1904/23/19 2,000,000.00 1,961,884.44 2.610 2.610 0.00 1,961,884.44
99.39811/15/20 1.750U.S. TreasuryTREAS NOTE9128283G305/31/1905/30/19 5,000,000.00 4,973,726.23 2.172 2.172 3,804.35 4,969,921.88
99.31307/24/20 1.750FNMAAGCY CALL3136G4PC105/31/1905/30/19 5,000,000.00 4,996,493.06 2.360 2.360 30,868.06 4,965,625.00 07/24/19
99.98505/28/20 2.310FFCBAGCY BULET3133EKMP805/31/1905/30/19 5,000,000.00 5,000,212.50 2.325 2.325 962.50 4,999,250.00
100.00011/05/19 2.350TX A&M UnivCP - INT88213M5E506/14/1906/14/19 5,000,000.00 5,000,000.00 2.350 2.350 0.00 5,000,000.00
100.00009/16/19 2.350State of CACP - INT13068CDR306/18/1906/18/19 5,000,000.00 5,000,000.00 2.350 2.350 0.00 5,000,000.00
38,879,426.23 39,000,000.00 Total for: Purchases 2.370 2.370 38,801,041.32 78,384.91
Income Payments
10/24/19 1.000FNMAAGCY BULET3135G0R3904/24/1904/24/19 25,000.00 25,000.00 0.00
04/29/19 1.250FHLBAGCY CALL3130A7R7204/29/1904/29/19 31,250.00 31,250.00 0.00
06/15/19 0.875U.S. TreasuryTREAS NOTE912828R8506/15/1906/17/19 21,875.00 21,875.00 0.00
06/22/20 1.500FNMAAGCY BULET3135G0D7506/22/1906/24/19 45,000.00 45,000.00 0.00
123,125.00 Total for: Income Payments 0.00 123,125.00
Page 1 of 2Print Date: 7/12/2019 Print Time: 8:14 am
Page 11 of 15
Investment Transactions
CUSIP Price Total AmountSecurity Description
From 04/01/2019 to 06/30/2019
Security
Type Coupon Mty Date Call Date
Trade
Date
Settle
Date Par Value
City of Southlake
Realized
Gain / Loss YTM YTW
Principal
Amount
Int Purchased /
Received
YTWYTMRealized G/LTotal AmountQuantityTransaction Type
10,000,000.00 10,000,000.00Total Maturities 1.799
38,879,426.23 39,000,000.00Total Purchases 2.370 2.370
123,125.00 0.00Total Income Payments
Total for All Portfolios
Page 2 of 2Print Date: 7/12/2019 Print Time: 8:14 am
Page 12 of 15
CUSIP
Amortization and Accretion
From 03/31/2019 to 06/30/2019
Purchase QtySettle Date
Orig
Price Original Cost
Amrt/Accr
for Period
Total Amrt/Accr
Since Purch
Remaining
Disc / Prem Book ValueNext Call Date
City of Southlake
Security DescriptionSecurity Type
General Operating
3130A7R72 0.00 131.70 0.00 0.00 0.0004/29/16 99.900 0.00FHLB 1.250 04/29/19AGCY CALL
912828R85 0.00 14,657.75 0.00 0.00 0.0006/04/18 98.543 0.00U.S. Treasury 0.875 06/15/19TREAS NOTE
3133EGJX4 2,996,250.00 318.78 3,735.84 14.16 3,000,000.0007/12/16 99.875 2,999,985.84FFCB 1.080 07/05/19AGCY CALL
3130ABZX7 5,000,230.00 (31.00)(217.60)(12.40) 5,000,000.0008/23/17 100.005 5,000,012.40FHLB 1.410 08/07/19AGCY BULET
13068CDR3 5,000,000.00 0.00 0.00 0.00 5,000,000.0006/18/19 100.000 5,000,000.00State of CA 2.350 09/16/19CP - INT
3135G0R39 4,905,800.00 18,622.70 70,743.75 23,456.25 5,000,000.0007/16/18 98.116 4,976,543.75FNMA 1.000 10/24/19AGCY BULET
88213M5E5 5,000,000.00 0.00 0.00 0.00 5,000,000.0006/14/19 100.000 5,000,000.00TX A&M Univ 2.350 11/05/19CP - INT
46640PAH6 1,961,884.44 9,671.12 9,671.12 28,444.44 2,000,000.0004/24/19 98.094 1,971,555.56J.P.Morgan Sec 0.000 01/17/20CP - DISC
313378J77 5,969,700.00 6,415.80 6,415.80 23,884.20 6,000,000.0004/23/19 99.495 5,976,115.80FHLB 1.875 03/13/20AGCY BULET
3133EKMP8 4,999,250.00 64.85 64.85 685.15 5,000,000.0005/31/19 99.985 4,999,314.85FFCB 2.310 05/28/20AGCY BULET
3135G0D75 5,934,660.00 10,537.32 10,537.32 54,802.68 6,000,000.0004/23/19 98.911 5,945,197.32FNMA 1.500 06/22/20AGCY BULET
3136G4PC1 4,965,625.00 2,529.55 2,529.55 31,845.45 5,000,000.0005/31/19 99.313 4,968,154.55FNMA 1.750 07/24/20AGCY CALL 07/24/19
9128283G3 4,969,921.88 1,723.22 1,723.22 28,354.90 5,000,000.0005/31/19 99.398 4,971,645.10U.S. Treasury 1.750 11/15/20TREAS NOTE
64,641.79 51,703,321.32Total for General Operating 105,203.85 191,474.83 52,000,000.00 51,808,525.17
51,703,321.32 64,641.79 Total for City of Southlake 105,203.85 191,474.83 52,000,000.00 51,808,525.17 0.00 0
Print Date: 7/12/2019 Print Time: 8:14 am Page 1 of 1
Page 13 of 15
CUSIP Pay Date Interest
City of Southlake
Projected Cash Flows
Total AmountSecurity Type
Cash Flows for next 180 days from 06/30/2019
Security Description Principal
General Operating
16,200.00 3,016,200.003133EGJX4AGCY CALL FFCB 1.080 07/05/19 07/05/19 3,000,000.00
43,750.00 43,750.003136G4PC1AGCY CALL FNMA 1.750 07/24/20 07/24/19 0.00
35,250.00 5,035,250.003130ABZX7AGCY BULET FHLB 1.410 08/07/19 08/07/19 5,000,000.00
56,250.00 56,250.00313378J77AGCY BULET FHLB 1.875 03/13/20 09/13/19 0.00
28,972.60 5,028,972.6013068CDR3CP - INT State of CA 2.350 09/16/19 09/16/19 5,000,000.00
25,000.00 5,025,000.003135G0R39AGCY BULET FNMA 1.000 10/24/19 10/24/19 5,000,000.00
46,356.16 5,046,356.1688213M5E5CP - INT TX A&M Univ 2.350 11/05/19 11/05/19 5,000,000.00
43,750.00 43,750.009128283G3TREAS NOTE U.S. Treasury 1.750 11/15/20 11/15/19 0.00
57,750.00 57,750.003133EKMP8AGCY BULET FFCB 2.310 05/28/20 11/28/19 0.00
45,000.00 45,000.003135G0D75AGCY BULET FNMA 1.500 06/22/20 12/22/19 0.00
23,398,278.76Total for General Operating 398,278.76 23,000,000.00
Page 1 of 2Print Date: 7/12/2019 Print Time: 8:14 am
Page 14 of 15
CUSIP Pay Date Interest
City of Southlake
Projected Cash Flows
Total AmountSecurity Type
Cash Flows for next 180 days from 06/30/2019
Security Description Principal
59,950.00 3,059,950.00July 2019 3,000,000.00
35,250.00 5,035,250.00August 2019 5,000,000.00
85,222.60 5,085,222.60September 2019 5,000,000.00
25,000.00 5,025,000.00October 2019 5,000,000.00
147,856.16 5,147,856.16November 2019 5,000,000.00
45,000.00 45,000.00December 2019 0.00
398,278.76 23,398,278.76Total Projected Cash Flows for City of Southlake 23,000,000.00
Total for All Portfolios
Page 2 of 2Print Date: 7/12/2019 Print Time: 8:14 am
Page 15 of 15
The Marq Financial Highlights
August 1, 2019
As of August 1, 2019
2018 and 2019 Comparison
251
623
194
FY 2019 Events = 1,068
300
660
187
FY 2018 Events = 1,147
Private Events Senior Programs City/Community Events
October -June
Questions?