Required information [The following information applies to the questions displayed below.] This exercise provides a total of 8 data visualizations that describe a real company's performance based on 17 quarters of financial data. The visualizations are grouped into four dashboards that were created in Tableau: (1) operating cash flow analysis, (2) operating cash flow margins analysis, (3) investing cash flow analysis, and (4) net change in cash analysis. Required: For each section, review the Tableau visualizations and answer the questions. Refer to the Operating Cash Flow 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.) Net Cash Provided by Operating Activities: Year-Over-Year Year - Quarter $20 $15 $10 (in billions) ||||| $5 $0 ($1.5) ($5) TO-TA TO-21 Y3-01 4- 21 75-Q1 Y1-02 72-02 Y3 - 02 4- 22 Y1-03 v2.03 3 - 23 4- Q3 (in billions) $0 $5 $10 $15 TO-TA Y1 - 02 Y1 - Q3 Y1 - 04 Y2-Q1 Y2-02 Y2-03 Y2-04 VM Net Cash Provided by Operating Activities vs. Net Income Year - Quarter Operating Activities Net Income Y3 - Q1 Y3 - Q2 Y3-03 Y3-04 Y4-Q1 Y4 - Q2 Y4 - 03 Y4-04 Y5 - Q1 1a. Which of the following statements are true with respect to Visualization 1: Net Cash Provided by Operating Activities: Year-Over- Year? The first five blue bars shown on the left side of the chart depict net cash provided by (used in) operating activities for quarters 1-4 of year 1 and quarter 1 of year 2. The first five blue bars shown on the left side of the chart depict net cash provided by (used in) operating activities for the first quarter of years 1-5. The four orange bars show net cash provided by (used in) operating activities for the third quarter of years 1-4. 1b. Which of the following statements are true with respect to Visualization 2: Net Cash Provided by Operating Activities vs. Net Income? ? It provides a trend analysis of quarterly net cash provided by operating activities and net income beginning with the first quarter of year 1 and running consecutively through the first quarter of year 5. 1 It depicts quarterly net cash provided by operating activities and net income on year-over-year basis beginning with quarter 1 of years 1-5 and ending with quarter 4 of years 1-4. ? It provides a trend analysis of the quarterly net change in the cash balance and the quarterly net income beginning with the first quarter of year 1 and running consecutively through the first quarter of year 5. 1c. Which of the following statements are true with respect to Visualization 1: Net Cash Provided by Operating Activities: Year-Over- Year? The company's net cash provided by operating activities is always much greater in the fourth quarter of every year than in the other three quarters. 2 The net cash provided by operating activities within quarters 2, 3, and 4 has been steadily decreasing over the four-year period. ? The company's net cash provided by operating activities is always much lower in the first quarter of every year than in the other three quarters. 1d. Which of the following statements are true with respect to Visualization 2: Net Cash Provided by Operating Activities vs. Net Income? ? It suggests that the company receives huge cash inflows from customers during the fourth quarter of each year, but defers paying suppliers until the first quarter of the ensuing year. ? The quarterly trend line for net income is much smoother than the trend line for net cash provided by operating activities. 2 The net income is very erratic with peaks in each fourth quarter followed by valleys in each first quarter. 1e. Which of the following statements are true when comparing Visualizations 1 and 2? 7 Visualization 1 focuses solely on cash flows whereas Visualization 2 compares net cash provided by operating activities to net income. ? Visualization 1 compares net cash provided by operating activities to net income whereas Visualization 2 focuses solely on cash flows. ? Both visualizations focus on trends in net income
