Loading...
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?