Required information

Skip to question

[The following information applies to the questions displayed below.] 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. Required: For each section, review the Tableau visualizations and answer the questions.

Refer to the Net Change in Cash 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.)

4a. Which of the following statements are true with respect to Visualization 1: Summary of Quarterly Cash Flows?

check all that apply 1

• It summarizes the operating, investing, and financing cash flows on a quarterly basis beginning with the first quarter of year 1 and trending downward toward the first quarter of year 5.unanswered
• It summarizes the operating, investing, and financing cash flows on a quarterly basis beginning with the first quarter of years 1-5 and trending downward toward the fourth quarter of years 1-4.unanswered
• It depicts financing cash flows in blue and investing cash flows in green.unanswered

4b. Which of the following statements are true with respect to Visualization 2: Summary of Changes in the Cash Balance?

check all that apply 2

• The trend line included in the visualization tracks the ending cash balance on a year-over-year basis from the first quarter of years 1-5 through the fourth quarter of years 1-4.unanswered
• The trend line included in the visualization tracks the ending cash balance from the first quarter of year 1 through the first quarter of year 5.unanswered
• The trend line depicts the ending cash balance whereas the bars depict the change in the cash balance from one quarter to the next.unanswered

4c. Which of the following statements are true with respect to Visualization 1: Summary of Quarterly Cash Flows?

check all that apply 3

• The company has only one quarter out of 17 quarters where it had net cash provided by financing activities, rather than net cash used in financing activities.unanswered
• The company has only one quarter out of 17 quarters where it had net cash used in financing activities, rather than net cash provided by financing activities.unanswered
• The company does not have net cash provided by investing activities in any of the 17 quarters.unanswered

4d. Which of the following statements are true with respect to Visualization 2: Summary of Changes in the Cash Balance?

check all that apply 4

• The cash balance has increased from approximately $10 billion at the end of the first quarter of year 1 to approximately $23 billion by the end of the first quarter of year 5.unanswered
• The cash balance always declines in the first quarter of every year and spikes upward in the fourth quarter of every year.unanswered
• The largest drop in the cash balance occurred during the first quarter of year 5.unanswered

4e. Which of the following statements are true when comparing Visualizations 1 and 2?

check all that apply 5

• The first visualization focuses on the overall cash balance whereas the second visualization provides insights with respect to the three types of cash flows summarized in a statement of cash flowsoperating, investing, and financing cash flows.unanswered
• The first visualization provides insights with respect to the three types of cash flows summarized in a statement of cash flowsoperating, investing, and financing cash flowswhereas the second visualization focuses on the overall cash balance.unanswered
• Both visualizations track cash flow data beginning with the first quarter of year 1 and concluding with the first quarter of year 5.

Required information

Skip to question

[The following information applies to the questions displayed below.] 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. Required: For each section, review the Tableau visualizations and answer the questions

Which of the following statements are true based on all of the visualizations contained in this activity? (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.)

check all that apply

• The company has huge operating cash inflows in the first quarter of every year and modest operating cash outflows in the fourth quarter of years 1-4.unanswered
• The companys quarterly investments in property, plant, and equipment are usually less than its quarterly depreciation charges.unanswered
• The companys cash flow margins are greater than 20% in the fourth quarter of every year and its cash flow margins are negative in the first quarter of years 1-4.unanswered
• The companys quarterly net cash provided by financing activities consistently exceed its quarterly net cash provided by operating activities.unanswered
• The biggest quarterly decline in the cash balance occurred during the first quarter of year 3.

Summary of Quarterly Cash Flows Operating Activities Investing Activities Financing Activities Year - Quar.. Y4-01 (PU. ($2.16) Y4 - Q2 $7.45 ($2.69) ($1.39) Y4-03 $8.59 mivesting ACTIVITIES Financing Activities Operating Activities Investing Activities Financing Activities Operating Activities Investing Activities Financing Activities Operating Activities Investing Activities Financing Activities Operating Activities Investing Activities Financing Activities ($5.57) ($2.37) Y4-04 $16.48 Y5-01 ($3.57) ($1.76) $1.85 ($8.12) ($2.38) ($10) $0 Cash Flow (in billions) ($20) $10 $20 Summary of Changes in the Cash Balance Change in Cash Year - Quarter ($8.67) $11.14 $40 Ending Cash Balance $40 $30 $30 $20 $20 Quarter to Quarter change in Cash (in billions) $11.14 $5.18 $7.76 $10 Ending Cash Balance (in billions) $10 $0.03 $0.44 $0.05 $1.14 $5.68 $2.92 $0.50 $0 $0 ($4.32) (6885) ($3.42) ($10) ($2.24) ($0.44) ($4.24) ($10) ($8.67) ($20) ($20) TO - IX Y1-22 Y1 - 23 Y1-04 Y2-01 Y2-22 Y2-03 Y2-04 Y3 - Q1 Y3-02 Y3-03 Y3-24 YA - Q1 YA - Q2 Y4-03 Y4-04 Y5-01