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.

Cash Flow Margin Percentage: Year-Over-Year Year - Quarter 24.7% 24.496 20.49.22.896 20% 15.296 14.196 13.796 11.4% 10.196 10.396 8.896 8.696 Cash Flow Margi. -7.496 3.196 0% -6.696 -4.596 -3.596 Y3- Y1 Y3-.. Y4-.. Y4 Y2 - Y1 This visualization depicts each quarter's net cash provided by operating activities as a percent of that quarter's sales. Cash Flow Margin Percentage vs. Net Profit Margin Percentage Cash Flow Maps Year-Quarter Net Profit Marq... 20% 10% 4 1 0% Y1-01 Y1 - Q2 Y1-Q3 Y1-04 Y2-01 Y 2-Q2 Y 2 - Q3 Y2-04 Y3-01 Y3-Q2 Y3 Q3 Y3-04 Y 4-Q1 Y 4-02 Y 4-Q3 Y4-04 Y5-01 2a. Which of the following statements are true with respect to Visualization 1: Cash Flow Margin Percentage: 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.) 2 It depicts each quarter's sales as a percent of that quarter's net cash provided by (used in) operating activities on a year-over-year basis. 2 It depicts each quarter's net cash provided by (used in) operating activities as a percent of that quarter's sales on a year-over-year basis. The four red bars show net cash provided by (used in) operating activities as a percent of sales for the third quarter of years 1-4. 2b. Which of the following statements are true with respect to Visualization 2: Cash Flow Margin Percentage vs. Net Profit Margin Percentage? (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 the quarterly cash flow margin percentage and the net profit margin percentage beginning with the first quarter of year 1 and running consecutively through the first quarter of year 5. It provides a trend analysis of the quarterly cash flow margin percentage and the net profit margin percentage beginning with the first quarter of years 1-5 and running consecutively through the fourth quarter of years 1-4. 2 It depicts net cash provided by operating activities and net income, each stated as a percent of sales. 2c. Which of the following statements are true with respect to Visualization 1: Cash Flow Margin Percentage: 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 net cash provided by operating activities as a percent of sales shows improvement in the first quarter of year 5 compared to prior first quarters. ? The net cash provided by operating activities as a percent of sales within year 3 took a downturn in quarters 2, 3, and 4 compared to the corresponding quarter in the prior year. ? The company's net cash provided by operating activities as a percent of sales is always much greater in the second quarter of every year than in the other three quarters. 2d. Which of the following statements are true with respect to Visualization 2: Cash Flow Margin Percentage vs. Net Profit Margin Percentage? (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 The cash flow margin percentage shows huge peaks every third quarter followed by big valleys in every subsequent fourth quarter. The quarterly trend line for the net profit margin percentage is much smoother than the trend line for the cash flow margin percentage. 1 The company's net profit margin percentage does not exceed 10% in any quarter