Question: You are a data analyst at Chipotle and the Nasdaq headline, Why Are Chipotle Shares Sinking After Strong Earnings has caused a lot of concern
You are a data analyst at Chipotle and the Nasdaq headline, Why Are Chipotle Shares Sinking After Strong Earnings has caused a lot of concern within the company. Investors are worried about their investments. Chipotles executives would like to understand if their competition also experienced a similar effect. The manager of data analytics prepares a data visualization dashboard using data from income statements and historic stock prices to explain to executives how earnings and stock prices compare with Chipotles competitor, McDonalds The manager has asked you to analyze that data and prepare your findings for a presentation to the board.
Chipotle vs McDonalds Earnings Dashboard
Figure : Earnings Per Share vs Earnings Figure : Earnings Per Share vs Earnings
GFigure : Earnings Per Share vs Earnings Growth Chipotle
Measure Names
EPS
EPS Growth
Figure : Earnings Per Share vs Earnings Growth McDonalds
Legend
EPS
EPS Growth
Figure : Stock Price Chipotle
Q
Q
Q
Q
Avg. Close in $
Company
McDonalds Corp.
Figure : Stock Price McDonalds
Q
Q
Q
Q
Q
Q
Avg. Close in $
Dashboard EFigure : Sales Revenue vs Gross Income Chipotle
Q
M
Legend
SalesRevenue
Gross Income
Q
Line
Figure : Sales Revenue vs Gross Income McDonalds
Q Q Q Q
SalesRevenue
Gross Income
QPart A How would you summarize the earnings dashboard findings to your manager? How would you explain why earning per share increased but the stock price dropped?
Part B Is there are correlation between the earnings per share and the stock price for Chipotle?
Part C Is there are correlation between the earnings per share and the stock price for McDonalds
Part D Explain the concept of quality of earnings Based on the data in the earnings dashboard, is there any evidence that Chipotles quality of earnings affected its share price in Q
Part E Are there similarities with Chipotles and McDonalds stock price trend? What factors could be attributed to the trend?
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
