Required information

Skip to question

[The following information applies to the questions displayed below.] This exercise provides a total of 13 data visualizations that describe a real companys performance based on 17 quarters of financial data. The visualizations are grouped into five dashboards that were created in Tableau: (1) sales analysis, (2) gross margin analysis, (3) operating expense analysis, (4) profitability analysis, and (5) market performance analysis. Required: For each section, review the Tableau visualizations and answer the questions.

Overall, how would you describe the companys performance during the 17-quarter time period? Which of the following statements are true based on all of the visualizations contained in this exercise? (You may select more than one answer. Single click the box with the question mark to produce a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer. Any boxes left with a question mark will be automatically graded as incorrect.)

check all that apply

• The companys stock price increased from less than $400 to a high of more than $2,000 during the 17-month time period.unanswered
• Sales, net income, gross margin percentage, net profit margin percentage, return on equity, and earnings per share have all been increasing over time.unanswered
• The companys operating expenses as a percent of sales have been plummeting over time.

Price-Earnings Ratio Year/Quarter 600 528.0 400 316.3 314.2 Price-Earnings Ratio 238.4 198.9 200 174.5 187.7 198.8 168.1 177.6 131.3 109.3 72.7 72.6 Y1Q1 - Y104 Y1Q2-Y201 Y103-Y202 Y104-Y203 Y2Q1-Y204 Y2Q2-Y301 Y2Q3-Y3Q2 Y204-Y303 Y3Q1-Y304 Y3Q2-Y401 Y3Q3-Y402 Y304-Y403 Y4Q1-Y404 Y4Q2-Y5Q1 The first bar in this chart is computed by dividing the stock price at the end of year 1 by the sum of that year's quarterly earnings per share. Each subsequent bar in the chart rolls forward one quarter at a time. So, for example, the second bar divides the stock price at the end of the first quarter of year 2 by the sum of the earnings per share from the four most recent quarters. Earnings Per Share (EPS) vs. Stock Price Year/Quarter $2,000 Stock price $1,000 $0 $6.00 Earnings Per Share $4.00 $2.00 $0.00 TO-TA Y1-Q2 Y1-Q3 Y1-Q4 Y2-01 Y2-02 Y2-23 Y2-04 Y3-01 Y3-02 Y3-03 Y3-Q4 TO-DA Y4-22 Y4-03 Y4-04 Y5-01 Price-Earnings Ratio Year/Quarter 600 528.0 400 316.3 314.2 Price-Earnings Ratio 238.4 198.9 200 174.5 187.7 198.8 168.1 177.6 131.3 109.3 72.7 72.6 Y1Q1 - Y104 Y1Q2-Y201 Y103-Y202 Y104-Y203 Y2Q1-Y204 Y2Q2-Y301 Y2Q3-Y3Q2 Y204-Y303 Y3Q1-Y304 Y3Q2-Y401 Y3Q3-Y402 Y304-Y403 Y4Q1-Y404 Y4Q2-Y5Q1 The first bar in this chart is computed by dividing the stock price at the end of year 1 by the sum of that year's quarterly earnings per share. Each subsequent bar in the chart rolls forward one quarter at a time. So, for example, the second bar divides the stock price at the end of the first quarter of year 2 by the sum of the earnings per share from the four most recent quarters. Earnings Per Share (EPS) vs. Stock Price Year/Quarter $2,000 Stock price $1,000 $0 $6.00 Earnings Per Share $4.00 $2.00 $0.00 TO-TA Y1-Q2 Y1-Q3 Y1-Q4 Y2-01 Y2-02 Y2-23 Y2-04 Y3-01 Y3-02 Y3-03 Y3-Q4 TO-DA Y4-22 Y4-03 Y4-04 Y5-01