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.

Refer to the Profitability Analysis Dashboard below and answer the questions.

(Note that for all questions below 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.) 4a-1. Which of the following statements are true with respect to Visualization 1: Net Income Growth?

check all that apply 1

• It provides a trend analysis of quarterly net income as a percent of sales beginning with the first quarter of year 1 and running consecutively through the first quarter of year 5.unanswered
• It provides a trend analysis of quarterly net income beginning with the first quarter of year 1 and running consecutively through the first quarter of year 5.unanswered
• It provides a trend analysis of quarterly net income as a percent of stockholders equity beginning with the first quarter of year 1 and running consecutively through the first quarter of year 5.unanswered

4a-2. Which of the following statements are true with respect to Visualization 2: Net Profit Margin Percentage?

check all that apply 2

• It provides a trend analysis of quarterly net income as a percent of sales beginning with the first quarter of year 1 and running consecutively through the first quarter of year 5.unanswered
• It provides a trend analysis of quarterly net income beginning with the first quarter of year 1 and running consecutively through the first quarter of year 5.unanswered
• It provides a trend analysis of quarterly net income as a percent of stockholders equity beginning with the first quarter of year 1 and running consecutively through the first quarter of year 5.unanswered

4a-3. Which of the following statements are true with respect to Visualization 3: Return on Equity (ROE)?

check all that apply 3

• It provides a trend analysis of quarterly net income as a percent of sales beginning with the first quarter of year 1 and running consecutively through the first quarter of year 5.unanswered
• It provides a trend analysis of quarterly net income beginning with the first quarter of year 1 and running consecutively through the first quarter of year 5.unanswered
• It provides a trend analysis of quarterly net income as a percent of stockholders equity beginning with the first quarter of year 1 and running consecutively through the first quarter of year 5.unanswered

4b-1. Which of the following statements are true with respect to Visualization 1: Net Income Growth?

check all that apply 4

• The net income never exceeded $1 billion between the first quarter of year 1 and the third quarter of year 3.unanswered
• The net income increased every quarter from the fourth quarter of year 3 until the first quarter of year 5.unanswered
• The net income hit its highest peak during the 17-month span during the first quarter of year 5.unanswered

4b-2. Which of the following statements are true with respect to Visualization 2: Net Profit Margin Percentage?

check all that apply 5

• The net profit margin percentage never dropped below 2% between the fourth quarter of year 3 and the first quarter of year 5.unanswered
• The net profit margin percentage dropped from the second quarter of year 2 to the third quarter of year 2.unanswered
• The net profit margin percentage never exceeded 2% between the first quarter of year 1 and the third quarter of year 3.unanswered

4b-3. Which of the following statements are true with respect to Visualization 3: Return on Equity (ROE)?

check all that apply 6

• The return on equity ranges from 4.9% to 28.9%.unanswered
• The return on equity is higher towards the end of the 17-quarter time period than it is at the beginning of this time period.unanswered
• The return on equity has increased every quarter from the beginning to the end of the 17-quarter period depicted in the chart.unanswered

4c. Which of the following statements are true with respect to the three visualizations contained in the Profitability Analysis Dashboard?

check all that apply 7

• A trend analysis of net income growth and net profit margin percentage reveal that the two measures have been moving in opposite directions over the course of the 17-quarter period.unanswered
• The third visualization is the only one of the three that looks at net income relative to the owners investment.unanswered
• All three visualizations indicate improving performance from the third quarter of year 3 through the first quarter of year 5.

Net Income Growth Year/Quarter $3 Net Income (in billions) $2 $0 ITO-TA Y1-Q2 Y1-23 Y1-Q4 Y2-01 Y2-Q2 Y2-03 Y2-04 Y3-01 Y3-02 Y3-03 Y3-04 Y4-Q1 Y4 - Q2 Y4 - Q3 Y4-04 Y5-01 Net Profit Margin Percentage Year/Quarter 6.0% 4.0% 2.0% 0.0% TO-TA Y1-02 Y1-Q3 Y1 - 24 Y2-01 Y2-22 Y2-03 Y2-04 Y3 - Q1 Y3-22 Y3-03 Y3-04 Y4-01 Y4-02 Y4-03 Y4 - 24 Y5-01 Return on Equity (ROE) Year/Quarter 28.9% 30.0% 26.7% 27.0% 21.1% 20.0% 13.5% 13.5% 13.9% 13.7% 14.7% 12.5% 8.9% 9.4% 10.0% 8.7% 4.9% 0.0% Y101 - Y104 Y1Q2-Y201 Y1Q3-Y202 Y104-Y203 8 Y2Q1-Y204 Y2Q2-Y3Q1 Y2Q3-Y3Q2 Y204-Y3Q3 Y3Q1-Y3Q4 302.44Q1 Y3Q3-Y4Q2 Y3Q4-Y4Q3 Y4Q1-Y404 Y4Q2-Y5Q1 The first bar in this chart is computed by summing the net incomes earned during the four quarters of year 1 and then dividing this cumulative net income by the average stockholders' equity during those same four quarters. Each subsequent bar in the chart rolls forward one quarter at a time. So, for example, the second bar sums the four quarterly net incomes from the second quarter of year 1 through the first quarter of year 2. It then divides this cumulative net income by the average stockholders' equity during those same four quarters. Net Income Growth Year/Quarter $3 Net Income (in billions) $2 $0 ITO-TA Y1-Q2 Y1-23 Y1-Q4 Y2-01 Y2-Q2 Y2-03 Y2-04 Y3-01 Y3-02 Y3-03 Y3-04 Y4-Q1 Y4 - Q2 Y4 - Q3 Y4-04 Y5-01 Net Profit Margin Percentage Year/Quarter 6.0% 4.0% 2.0% 0.0% TO-TA Y1-02 Y1-Q3 Y1 - 24 Y2-01 Y2-22 Y2-03 Y2-04 Y3 - Q1 Y3-22 Y3-03 Y3-04 Y4-01 Y4-02 Y4-03 Y4 - 24 Y5-01 Return on Equity (ROE) Year/Quarter 28.9% 30.0% 26.7% 27.0% 21.1% 20.0% 13.5% 13.5% 13.9% 13.7% 14.7% 12.5% 8.9% 9.4% 10.0% 8.7% 4.9% 0.0% Y101 - Y104 Y1Q2-Y201 Y1Q3-Y202 Y104-Y203 8 Y2Q1-Y204 Y2Q2-Y3Q1 Y2Q3-Y3Q2 Y204-Y3Q3 Y3Q1-Y3Q4 302.44Q1 Y3Q3-Y4Q2 Y3Q4-Y4Q3 Y4Q1-Y404 Y4Q2-Y5Q1 The first bar in this chart is computed by summing the net incomes earned during the four quarters of year 1 and then dividing this cumulative net income by the average stockholders' equity during those same four quarters. Each subsequent bar in the chart rolls forward one quarter at a time. So, for example, the second bar sums the four quarterly net incomes from the second quarter of year 1 through the first quarter of year 2. It then divides this cumulative net income by the average stockholders' equity during those same four quarters