1 september 2015 bender trust research project overview greg francfort
TRANSCRIPT
![Page 1: 1 September 2015 Bender Trust Research Project Overview Greg Francfort](https://reader035.vdocuments.us/reader035/viewer/2022062422/56649ee55503460f94bf445a/html5/thumbnails/1.jpg)
1September 2015
Bender TrustResearch Project
OverviewGreg Francfort
![Page 2: 1 September 2015 Bender Trust Research Project Overview Greg Francfort](https://reader035.vdocuments.us/reader035/viewer/2022062422/56649ee55503460f94bf445a/html5/thumbnails/2.jpg)
The Bender Trust
Started by alumni David Bender $120,000 principal in 1980 Currently worth $2,500,000 Used to fund scholarships LIBOR is my research department
2
![Page 3: 1 September 2015 Bender Trust Research Project Overview Greg Francfort](https://reader035.vdocuments.us/reader035/viewer/2022062422/56649ee55503460f94bf445a/html5/thumbnails/3.jpg)
Greg Francfort
Rutgers undergraduate in engineering Wharton MBA LIBOR co-founder with students in 1994 First Boston Corp.
Sell-side analyst, Assoc. Research Director Neuberger Berman
Portfolio Manager, Research Director Securities Analysis at Columbia University
3
![Page 4: 1 September 2015 Bender Trust Research Project Overview Greg Francfort](https://reader035.vdocuments.us/reader035/viewer/2022062422/56649ee55503460f94bf445a/html5/thumbnails/4.jpg)
Why start LIBOR?
Jobs, jobs, jobs Wall Street to Old Queens 38 miles Where are the Rutgers Alum?
![Page 5: 1 September 2015 Bender Trust Research Project Overview Greg Francfort](https://reader035.vdocuments.us/reader035/viewer/2022062422/56649ee55503460f94bf445a/html5/thumbnails/5.jpg)
Why do Bender Research Project?
Learn about yourself; Lockheed at $2; 10-Ks at mid-night
Build your resume; Prep for Interviews Prep for SMF Prep for Retirement Winning presentation and runner-up
recognized at LIBOR summit
![Page 6: 1 September 2015 Bender Trust Research Project Overview Greg Francfort](https://reader035.vdocuments.us/reader035/viewer/2022062422/56649ee55503460f94bf445a/html5/thumbnails/6.jpg)
6
Part I: Fundamentals
![Page 7: 1 September 2015 Bender Trust Research Project Overview Greg Francfort](https://reader035.vdocuments.us/reader035/viewer/2022062422/56649ee55503460f94bf445a/html5/thumbnails/7.jpg)
Investing in a Business
Offer to let RU students invest in restaurant start-up
Raising $1,000 from each of 25 students Will fully distribute annual profits Is this an attractive opportunity?
Forecast the annual profits Value the profits
7
![Page 8: 1 September 2015 Bender Trust Research Project Overview Greg Francfort](https://reader035.vdocuments.us/reader035/viewer/2022062422/56649ee55503460f94bf445a/html5/thumbnails/8.jpg)
Balance Sheet
Assets = $100,000 Food prep equipment Inventory and receivables
Liabilities = $50,000 in debt Equity = $50,000
$25,000 from GF $25,000 from students
8
![Page 9: 1 September 2015 Bender Trust Research Project Overview Greg Francfort](https://reader035.vdocuments.us/reader035/viewer/2022062422/56649ee55503460f94bf445a/html5/thumbnails/9.jpg)
Projected earnings
Profit = Revenue - Expenses Revenue = f (?) Expenses = f (?)
9
![Page 10: 1 September 2015 Bender Trust Research Project Overview Greg Francfort](https://reader035.vdocuments.us/reader035/viewer/2022062422/56649ee55503460f94bf445a/html5/thumbnails/10.jpg)
Revenue forecast
?
10
![Page 11: 1 September 2015 Bender Trust Research Project Overview Greg Francfort](https://reader035.vdocuments.us/reader035/viewer/2022062422/56649ee55503460f94bf445a/html5/thumbnails/11.jpg)
Revenue forecast
Open 24 weeks/yr; 8 hours/day Serve 8 meals/hour = 10,800/year Average ticket $7.00 Revenue = $75,000
11
![Page 12: 1 September 2015 Bender Trust Research Project Overview Greg Francfort](https://reader035.vdocuments.us/reader035/viewer/2022062422/56649ee55503460f94bf445a/html5/thumbnails/12.jpg)
Expenses forecast
?
12
![Page 13: 1 September 2015 Bender Trust Research Project Overview Greg Francfort](https://reader035.vdocuments.us/reader035/viewer/2022062422/56649ee55503460f94bf445a/html5/thumbnails/13.jpg)
Expenses forecast
Labor: 24wks X 7d X 8hrs X $12 X 1.5 = $24,000 Food = 40% of revenue = $30,000 Rent and Utilities = $10,000 Interest = $50,000 X 6% = $3,000
13
![Page 14: 1 September 2015 Bender Trust Research Project Overview Greg Francfort](https://reader035.vdocuments.us/reader035/viewer/2022062422/56649ee55503460f94bf445a/html5/thumbnails/14.jpg)
Net Profit
Revenue = $75,000 Expenses = $24,000 + 30,000 + 10,000 +
3,000 = 67,000 Profit = $8,000 Taxes = 40% Net Profit = $4,800
14
![Page 15: 1 September 2015 Bender Trust Research Project Overview Greg Francfort](https://reader035.vdocuments.us/reader035/viewer/2022062422/56649ee55503460f94bf445a/html5/thumbnails/15.jpg)
Valuation
Equity raised = $50,000 Net profit = $4,800 P/E = 10.4X Earnings yield = 9.6%
15
![Page 16: 1 September 2015 Bender Trust Research Project Overview Greg Francfort](https://reader035.vdocuments.us/reader035/viewer/2022062422/56649ee55503460f94bf445a/html5/thumbnails/16.jpg)
16
SummaryInvestors buy “stories” without calculating valuation. They chase performance.
“There is no such thing as present tense in performance management.”
1980-2005S&P 500 12.5%Average mutual fund 10%Mutual fund investor 7.3%
![Page 17: 1 September 2015 Bender Trust Research Project Overview Greg Francfort](https://reader035.vdocuments.us/reader035/viewer/2022062422/56649ee55503460f94bf445a/html5/thumbnails/17.jpg)
17
Starbucks (SBUX) $56.51
52 week range: $36.10 – 59.01
S&P 500: 1,961
2014A 2015E 2016E
EPS $1.33 $1.58 $1.87
P/E 42.5 35.8 30.2
S&P EPS $118 $120 $130
S&P P/E 16.6 16.3 15.1
Relative P/E 256% 220% 200%
![Page 18: 1 September 2015 Bender Trust Research Project Overview Greg Francfort](https://reader035.vdocuments.us/reader035/viewer/2022062422/56649ee55503460f94bf445a/html5/thumbnails/18.jpg)
18
Wells Fargo (WFC) $52.62
52 week range: 47.85 – 58.52
S&P 500: 1,961
2014A 2015E 2016E
EPS $3.89 $4.12 $4.28
P/E 13.5 12.8 12.3
S&P EPS $118 $120 $130
S&P P/E 16.6 16.3 15.1
Relative P/E 81% 78% 81%
![Page 19: 1 September 2015 Bender Trust Research Project Overview Greg Francfort](https://reader035.vdocuments.us/reader035/viewer/2022062422/56649ee55503460f94bf445a/html5/thumbnails/19.jpg)
19
Company Description
One paragraph What does the company do to make money? What products / services do they sell? What are the costs of production?
![Page 20: 1 September 2015 Bender Trust Research Project Overview Greg Francfort](https://reader035.vdocuments.us/reader035/viewer/2022062422/56649ee55503460f94bf445a/html5/thumbnails/20.jpg)
20
Competitive Analysis
One page: Porters Five Forces Identify customers / suppliers What are the competitive advantages /
disadvantages? Size, market share? Is the business getting more or less
competitive? Is there a moat around the company? Be succinct!
![Page 21: 1 September 2015 Bender Trust Research Project Overview Greg Francfort](https://reader035.vdocuments.us/reader035/viewer/2022062422/56649ee55503460f94bf445a/html5/thumbnails/21.jpg)
21
Part II: Forecast and Valuation
![Page 22: 1 September 2015 Bender Trust Research Project Overview Greg Francfort](https://reader035.vdocuments.us/reader035/viewer/2022062422/56649ee55503460f94bf445a/html5/thumbnails/22.jpg)
Preeminence of future EPS
A robust forecast of EPS is the essence of Security Analysis
22
![Page 23: 1 September 2015 Bender Trust Research Project Overview Greg Francfort](https://reader035.vdocuments.us/reader035/viewer/2022062422/56649ee55503460f94bf445a/html5/thumbnails/23.jpg)
23
Earnings Outlook
What are the prospects the company can grow it’s business?
Growth from price or volume increases? What is the danger of cost increases? Likelihood of positive or negative earnings
surprise compared to consensus estimate of EPS for 2015?
![Page 24: 1 September 2015 Bender Trust Research Project Overview Greg Francfort](https://reader035.vdocuments.us/reader035/viewer/2022062422/56649ee55503460f94bf445a/html5/thumbnails/24.jpg)
24
Build a Model? Revenue minus expenses = profits Profits / shares outstanding = EPS
Earnings Outlook
![Page 25: 1 September 2015 Bender Trust Research Project Overview Greg Francfort](https://reader035.vdocuments.us/reader035/viewer/2022062422/56649ee55503460f94bf445a/html5/thumbnails/25.jpg)
Forecast Revenue
Use 2014 as a base to forecast 2015 revenue Project 2015 growth for the industry What factors will drive growth? Try to use units or volume How might your company’s market share
change? Price change in 2015 vs. 2014?
25
![Page 26: 1 September 2015 Bender Trust Research Project Overview Greg Francfort](https://reader035.vdocuments.us/reader035/viewer/2022062422/56649ee55503460f94bf445a/html5/thumbnails/26.jpg)
Forecast 2015 Revenue
Use 2014 as a base Use 2014 growth as the starting point for
the 2015 growth rate Eg. HD 2013 $83,180mm vs 79,023
G = 5.3% 2015 Rev forecast $87.5 billion Consensus is at $87.8 billion
26
![Page 27: 1 September 2015 Bender Trust Research Project Overview Greg Francfort](https://reader035.vdocuments.us/reader035/viewer/2022062422/56649ee55503460f94bf445a/html5/thumbnails/27.jpg)
2015 Revenue
Identify factors driving revenue acceleration or slowdown
Understand drivers to 2014 growth Use “Unit Economics” if possible Start with Industry if possible
27
![Page 28: 1 September 2015 Bender Trust Research Project Overview Greg Francfort](https://reader035.vdocuments.us/reader035/viewer/2022062422/56649ee55503460f94bf445a/html5/thumbnails/28.jpg)
Industry Growth for HD
???? Use your creative intellect
28
![Page 29: 1 September 2015 Bender Trust Research Project Overview Greg Francfort](https://reader035.vdocuments.us/reader035/viewer/2022062422/56649ee55503460f94bf445a/html5/thumbnails/29.jpg)
Industry growth for HD
Housing construction/storm activity Remodel trigger: sales of existing houses Building products inflation Product cycles: Nest, marble, appliances U.s. GDP and Consumer spending Consumer spending on residential
investment
29
![Page 30: 1 September 2015 Bender Trust Research Project Overview Greg Francfort](https://reader035.vdocuments.us/reader035/viewer/2022062422/56649ee55503460f94bf445a/html5/thumbnails/30.jpg)
2015 Market share
Number of stores Traffic Sales per store Price New product categories Advertising/promotion
30
![Page 31: 1 September 2015 Bender Trust Research Project Overview Greg Francfort](https://reader035.vdocuments.us/reader035/viewer/2022062422/56649ee55503460f94bf445a/html5/thumbnails/31.jpg)
Market share
Competitor actions (Sears) to expand or cede share
Lowes’ actions New entrants Acquisitions/divestitures New geographies (Mexico)
31
![Page 32: 1 September 2015 Bender Trust Research Project Overview Greg Francfort](https://reader035.vdocuments.us/reader035/viewer/2022062422/56649ee55503460f94bf445a/html5/thumbnails/32.jpg)
Unit Economics
Sales per store X store count Sales per square foot X sq ft Number of customer transactions Average ticket
32
![Page 33: 1 September 2015 Bender Trust Research Project Overview Greg Francfort](https://reader035.vdocuments.us/reader035/viewer/2022062422/56649ee55503460f94bf445a/html5/thumbnails/33.jpg)
Other factors
53 weeks in a year Calendar shift shortens holiday season The internet
33
![Page 34: 1 September 2015 Bender Trust Research Project Overview Greg Francfort](https://reader035.vdocuments.us/reader035/viewer/2022062422/56649ee55503460f94bf445a/html5/thumbnails/34.jpg)
34
Case Study: BUD
![Page 35: 1 September 2015 Bender Trust Research Project Overview Greg Francfort](https://reader035.vdocuments.us/reader035/viewer/2022062422/56649ee55503460f94bf445a/html5/thumbnails/35.jpg)
35
U.S. Beer Industry Unit Demand
Population Beer consumer specific
population Weather Income Gasoline prices, employment
rate Consumer taste Health issues Mad cow for beer? Low carb/healthier diets
Social trends Price of beer Price of substitutes Advertising by suppliers of
beer Advertising by suppliers of
substitutes Legal issues
Stricter penalties for DWI Changes in legal drinking age
New Products or Market segments
![Page 36: 1 September 2015 Bender Trust Research Project Overview Greg Francfort](https://reader035.vdocuments.us/reader035/viewer/2022062422/56649ee55503460f94bf445a/html5/thumbnails/36.jpg)
Profit = revenue - expenses
HD COGS = 65.3% of Revenue S,G&A = 23.1% Operating profit = 11.6% Interest Expense
36
![Page 37: 1 September 2015 Bender Trust Research Project Overview Greg Francfort](https://reader035.vdocuments.us/reader035/viewer/2022062422/56649ee55503460f94bf445a/html5/thumbnails/37.jpg)
37
Expenses
COGS Variable costs: Fixed costs: depreciation S,G&A Own or lease stores? Interest expense Income taxes
![Page 38: 1 September 2015 Bender Trust Research Project Overview Greg Francfort](https://reader035.vdocuments.us/reader035/viewer/2022062422/56649ee55503460f94bf445a/html5/thumbnails/38.jpg)
EPS
Net Income/ fully diluted shares outstanding
HD consensus is $5.30 per share Are you above or below?
38
![Page 39: 1 September 2015 Bender Trust Research Project Overview Greg Francfort](https://reader035.vdocuments.us/reader035/viewer/2022062422/56649ee55503460f94bf445a/html5/thumbnails/39.jpg)
39
Valuing the Earnings
Calculate P/E on your 2015 EPS forecast Relative P/E to:
S&P500 at 1961; S&P500 EPS 2015 est $120 S&P500 P/E on 2015 = 16.3x Does our Company deserve a premium or a
discount? Depends on growth and on risk
![Page 40: 1 September 2015 Bender Trust Research Project Overview Greg Francfort](https://reader035.vdocuments.us/reader035/viewer/2022062422/56649ee55503460f94bf445a/html5/thumbnails/40.jpg)
Other Valuation Tools
DCF P/Book Value per Share P/Asset value EV/EBITDA
40
![Page 41: 1 September 2015 Bender Trust Research Project Overview Greg Francfort](https://reader035.vdocuments.us/reader035/viewer/2022062422/56649ee55503460f94bf445a/html5/thumbnails/41.jpg)
41
Recommendation
Convincing case of earnings surprise (positive or negative)
Persuasively assert the stock deserves a larger / smaller relative P/E multiple on 2015 EPS than present level
Possible takeover potential or some other corporate event that unlocks or reduces value
![Page 42: 1 September 2015 Bender Trust Research Project Overview Greg Francfort](https://reader035.vdocuments.us/reader035/viewer/2022062422/56649ee55503460f94bf445a/html5/thumbnails/42.jpg)
42
Summary
Maximum three pages Five minute presentation
Only the important information
More effort = more knowledge “If I had more time I could have written a
shorter report”
![Page 43: 1 September 2015 Bender Trust Research Project Overview Greg Francfort](https://reader035.vdocuments.us/reader035/viewer/2022062422/56649ee55503460f94bf445a/html5/thumbnails/43.jpg)
43
Resources
Yahoo! Finance EDGAR
10-K, 10-Q, etc. Company websites Customers, employees, competitors,
suppliers Creative intellect!
![Page 44: 1 September 2015 Bender Trust Research Project Overview Greg Francfort](https://reader035.vdocuments.us/reader035/viewer/2022062422/56649ee55503460f94bf445a/html5/thumbnails/44.jpg)
44
Possible Stock List
Marlin Business Svcs. Corp. MRLN Traveler’s Insurance TRV
Avis Budget Group CAR Fedex FDX
Apple AAPL BP BP
Wal-Mart Stores Inc. WMT Blackstone Mortgage Trust BXMT
Lowe's Companies Inc. LOW Viacom, Inc. VIA-B
The Home Depot, Inc HD Valero Energy Corp. VLO
Comcast Corp. CMCSA Boeing Co. BA
CarMax Inc. KMX WCI Communities WCIC
Cabot Oil & Gas COG Intel INTC
Packaging Corp. of America
AT&T
Pandora Media
Microsoft
PKG
T
P
MSFT
Cedar Fair LP
Ubiquiti Networks
ASML
Sandisk
FUN
UBNT
ASML
SNDK
![Page 45: 1 September 2015 Bender Trust Research Project Overview Greg Francfort](https://reader035.vdocuments.us/reader035/viewer/2022062422/56649ee55503460f94bf445a/html5/thumbnails/45.jpg)
45
Timeline
Form groups: NOW Chose stock to analyze: VERY SOON Meet with e-Board advisor: SOON Report and Presentation: October 2015
In time for internship interviews
![Page 47: 1 September 2015 Bender Trust Research Project Overview Greg Francfort](https://reader035.vdocuments.us/reader035/viewer/2022062422/56649ee55503460f94bf445a/html5/thumbnails/47.jpg)
Announcements
Bender Trust Applications due Sunday, September 20th
Look out for email tomorrow morning w/ details LIBOR Financial Applications due Friday, September 18th
Look out for email tomorrow morning w/ details Rutgers Student Managed Fund (RSMF)
Applications due TOMORROW at 11:59 PM Freshmen, Sophomores, and Juniors are encouraged to apply http://rusmf.com/join-us
NEXT MEETING: Bender Trust Breakdown & Resume Critique Wednesday, September 16th 9:30 PM Dress code: Casual