This exercise provides a total of 8 data visualizations that describe a real companys 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.

in billions) = SO S5 $10 $15 $20 Y1-01 ($1.5) Y2-01 ($2.2) Y3-01 ($1.6) Y4-01 ($1.8) $1.8 Y1-02 Y2-02 Net Cash Provided by Operating Activities: Year-Over-Year Y3-02 $3.8 Y4-02 Year - Quarter Y1-03 Y2-0 -Q3 $4.5 3-03 13.03 $3.9 Y4-Q3 $8.6 Y1-04 $8.8 Y2-04 $10.7 Y3-04 $12.3 Y4.04 $16.5 in billions) $0 $5 $10 $15 +abledu TO-TA 20-TA ED-TA Y1-04 TV Y2-01 72-Q2 Y2-03 Net Cash Provided by Operating Activities vs. Net Income Y2-04 Y3-01 Year - Quarter un Y3-02 Y3 - Q3 Y3-04 Y 4-Q1 Y 4-Q2 Y4-03 Operating Activities Net Income 1 Y4-04 Y5.01 O 1a. Which of the following statements are true with respect to Visualization 1: Net Cash Provided by Operating Activities: Year-Over- Year? (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.) 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? (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.) 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. 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? (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.) 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. 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? (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.) ? 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. 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? (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.) 2 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