Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Due back to me via email by 6pm on Saturday, February 29 Due back to me via email by 6pm on Saturday, February 29 Company
Due back to me via email by 6pm on Saturday, February 29 Due back to me via email by 6pm on Saturday, February 29 Company Tieker Name Instructions at bottom Average Median Chipotle Denny's Dunkin' Brands Group Domino's Pizza Starbucks Darden Restaurants Yum! Bmods Jack in the Box Texis Roadhouse McDonald's Cheesecake Factory Cracker Barrel Old Cutry Shake Shack A Cerer Her CMG-US DENN-US DNKN-US DPZ-US SBUX-US DRI-US YUM-US JACK-US TXRH-US MCD-US CAKE-US CBRL-US SHAK-US re Instructions: 1) Go to the Comps Report that we saw in FactSet in the 2/18 and 2/21 classes (Company/Security tab, then "Overviews" in the left margin menu) 2) Make sure the Client-PE Report template is loaded 3) Clear the list of companies, so that you can create an "industry" of the companies listed above... a broad group of restaurant firms 4) Run the report and generate the P/Es 'as of LTM Yesterday... Remember to tell me what "Yesterday's" date is for you, since you may not all do this on the same daylll 5) Focusing on the "Price to Earnings Actual", identify any Amazon-like "giant" P/E ratios that may be distorting the average, then remove them. (make sure you show me the snapshot of the report with them in, and then with them taken out) 6) Create your list of companies which have markedly "High" actual P/Es relative to the average and peer values, and which have markedly "Low" P/Es relative to the average and peer values. The "markedly" means that the difference/gap should be at least 4 to 5x. That is, in P/E terms, 18.9 is not "low" relative to 19.25 ... they're practically the same. In P/E terms, 15.6 is not "high" relative to 14.0 since they are very close to each other. But, 18.7 would be high enough relative to 14.0 to make it onto a "High" list. 7) Identify the majority EPS" type (as we highkghted using the Cisco example) for 4 of the companies on this list. a) Identify the fiscal-year end month for every company on this list. 9) Take ONE company and identify the 4 calendar quarters that are included in the EPS-Actual LTM sum 10) Which two of these companies actually owns several different restaurant chains? Due back to me via email by 6pm on Saturday, February 29 Due back to me via email by 6pm on Saturday, February 29 Company Tieker Name Instructions at bottom Average Median Chipotle Denny's Dunkin' Brands Group Domino's Pizza Starbucks Darden Restaurants Yum! Bmods Jack in the Box Texis Roadhouse McDonald's Cheesecake Factory Cracker Barrel Old Cutry Shake Shack A Cerer Her CMG-US DENN-US DNKN-US DPZ-US SBUX-US DRI-US YUM-US JACK-US TXRH-US MCD-US CAKE-US CBRL-US SHAK-US re Instructions: 1) Go to the Comps Report that we saw in FactSet in the 2/18 and 2/21 classes (Company/Security tab, then "Overviews" in the left margin menu) 2) Make sure the Client-PE Report template is loaded 3) Clear the list of companies, so that you can create an "industry" of the companies listed above... a broad group of restaurant firms 4) Run the report and generate the P/Es 'as of LTM Yesterday... Remember to tell me what "Yesterday's" date is for you, since you may not all do this on the same daylll 5) Focusing on the "Price to Earnings Actual", identify any Amazon-like "giant" P/E ratios that may be distorting the average, then remove them. (make sure you show me the snapshot of the report with them in, and then with them taken out) 6) Create your list of companies which have markedly "High" actual P/Es relative to the average and peer values, and which have markedly "Low" P/Es relative to the average and peer values. The "markedly" means that the difference/gap should be at least 4 to 5x. That is, in P/E terms, 18.9 is not "low" relative to 19.25 ... they're practically the same. In P/E terms, 15.6 is not "high" relative to 14.0 since they are very close to each other. But, 18.7 would be high enough relative to 14.0 to make it onto a "High" list. 7) Identify the majority EPS" type (as we highkghted using the Cisco example) for 4 of the companies on this list. a) Identify the fiscal-year end month for every company on this list. 9) Take ONE company and identify the 4 calendar quarters that are included in the EPS-Actual LTM sum 10) Which two of these companies actually owns several different restaurant chains
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started