Chap 18: Tableau Exercise (2 pes) 1 1 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: (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, Part 1015 0.4 points Refer to the Operating Cash Row Analysis Dashboard below and answer the questions Net Cash Provided by Operating Activities: Year-Over-Year och 520 Print $16.5 $15 Teferences 2018 $123 530 186 18 in billions) 33.5 BES 545 65 126 $2.0 52.8 50 ST) 19 ) (518 (55) Y3.01 Y5.01 V.02 EDTA O. V6.03 4.04 Net Cash Provided by Operating Activities vs. Net Income Year Quarter Acties $10 SS 30 33 353 0 335 363 328 Required Information 10. Which of the following statements are true with respect to Visualization t 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 bones 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 of year 2. The first five blue bars shown on the left side of the chant depict net cash provided by used in) operating activities for the first quarter of years 1-5. 2. The four orange bars show net cash provided by (used in operating activities for the third quarter of years 1-4 11. 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 bort 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 actities and net income beginning with the first quarter of year 1 and running consecutively through the first quarter of year 5. 2 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 quartet 4 of years 1-4. 2t 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 S. 10. 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 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.) 2 t suggests that the company receives huge cash inflows from customers during the fourth quarter of each year, but defers paying suppllers until the first quarter of the ensuing year The quarterly trend Ine for net income 's 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 flest quarter te. Which of the following statements are true when comparing Visualizations 1 and 27 (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.) Visualization focuses only on cash flows whereas Visualization 2 compares net cath provided by operating activities to net income. Visualization compares net cash provided by operating activities to net income whereas Visunization 2 focuses solely on cash Hows. 2 Bou Visualization focus on trends in net income
