Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accountancy Analysis Of Financial Statements Analysis Of Financial Statements

Authors: M. Hanif, A. Mukherjee

1st Edition

1642879762, 9781642879766

More Books

Students also viewed these Accounting questions

Question

What is the main purpose of creating a family health tree

Answered: 1 week ago

Question

Determine miller indices of plane A Z a/2 X a/2 a/2 Y

Answered: 1 week ago