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 Margin 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.) Refer to the Operating Cash Flow Margin 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.) Cash Flow Margin Percentage: Year-Over-Year Year - Quarter 24.79624.496 13.796 15.296 8.696 11.4910.196 0.396 8.896 20.49622.896 ow Margi... 20% 14.19610 -7.496 3.196 0% -6.696 -4.596 -3.596 m 2 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 Marg. Net Profit Marg. Year - Quarter 2096 10% AW 0% Y1-01 Y1-02 Y1-03 11-04 Y2-01 Y2-02 Y2-03 Y2-04 13-01 Y3Q2 Y3 - 03 Y3-04 Y4-01 Y4-02 Y4-03 Y 4-04 Y5-01 2a. Which of the following statements are true with respect to Visualization 1: Cash Flow Margin Percentage: Year-Over-Year? 1 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. ? 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? ? 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? 1 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. 1 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. 2 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? 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. 2 The company's net profit margin percentage does not exceed 10% in any quarter. 2e. Which of the following statements are true when comparing Visualizations 1 and 2? 2 The bar chart focuses solely on the net profit margin percentage whereas the graph beneath it provides additional insights by comparing the cash flow margin percentage to the net profit margin percentage. The bar chart focuses solely on the cash flow margin percentage whereas the graph beneath it provides additional insights by comparing the cash flow margin percentage to the net profit margin percentage. 1 The cash flow margin percentage exceeds 20% in every fourth quarter, whereas the net profit margin percentage never exceeds 10% in every quarter of year 4
