Required information Applying Tableau Analytics 15-01 (Static) Cash Flow Analysis [LO15-3] To complete this exercise, you will need to download and install Tableau on your computer. Tableau provides free instructor and student licenses as well as free videos and support for utilizing and learning the software. Once you are up and running with Tableau, watch the three "Getting Started" Tableau videos. All of Tableau's short training videos can be found here. [The following information applies to the questions displayed below.] Gala Corporation has provided 16 quarters of financial data and asked you to create some visualizations that summarize its cash flows during this time period. Download the Excel file, which you will use to create the Tableau visualizations that summarize the company's cash flows over the past 16 quarters. Upload the Excel file into Tableau by doing the following: 1. Open the Tableau Desktop application. 2. On the left-hand side, under the "Connect" header and the "To a file" sub-header, click on "Microsoft Excel." 3. Choose the Excel file and click "Open." 4. Since the only worksheet in the Excel File is "Gala Corporation" it will default as a selection with no further import steps needed Applying Tableau Analytics 15-01 (Static) Part 4 Create a line chart that compares each quarter's net cash provided by operating activities to its net income. Double click on "new sheet" at the bottom of the workbook and change the name of the newly created "Sheet" to "Net Cash Provided by Operating Activities vs. Net Income". On the left-hand side under "Dimensions" (sometimes labeled as Tables), double-click on "Year - Quarter". On the left-hand side under "Measures", click on "Net Income" and drag and drop it into the "Columns" area. On the left-hand side under "Measures", click on "Operating Activities" and drag and drop it into the "Columns" area. Click on the dropdown on the resulting green pill "Sum(Operating Activities)" and choose "Dual Axis" In the "Marks" area, click on "All" and change the dropdown from "Automatic" to "Line" Next click on the button to swap the rows and columns ( ) above the "Columns" area. Right-click on the right "Y-axis" and choose "Synchronize Axis". Right-click on the right "Y-axis" and choose "Show Header" Right click on the Y-axis label and choose "Edit Axis" In the "Axis Titles" section, change the title from "Net cash provided by (used in) operating activities" to "(in billions)". Right click on the Y-axis label and choose "Format" Under the "Axis" tab, under the "Scale" section, click on the 'numbers drop down and choose "Currency (Custom)" and change the decimal to 0. Right click on the header titled "Year Quarter" and choose the option "Hide Field Labels for Columns" To improve viewing, locate the "Standard" dropdown option in the menu bar at the top of the screen. Click on that dropdown and choose "Entire View". Your visualization should appear as follows: SUM Oursting & Net Cash Provided by Operating Activities vs. Net Income 4 1100 SUB ces M 14 Required: B T TH F D I D 10-26 D-EA B 8 & 5 & 0 T 2 2 Required: (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 is true with respect to this visualization? The net cash provided by operating activities and net income are always the highest during the first quarter of each year The net cash provided by operating activities is always the highest during the first quarter of each year, but this is not the case for net income. The net income is always the highest during the first quarter of each year, but this is not the case for net cash provided by operating activities. The net cash provided by operating activities and net income are always the lowest during the first quarter of each year. 4b. Which of the following statements is true with respect to this visualization? It suggests that the company has comparable amounts of cash flows and profits throughout each quarter of each year. It suggests that the company has random quarterly swings in cash flows and profits that differ from one year to the next. 7 It suggests that the company has seasonal trends in quarterly cash flows and profits that repeat from one year to the next. It suggests that the company has seasonal trends in quarterly cash flows and profits that repeat in years 1 and 2 nd then disappear in years 3 and 4. 4c. Which of the following statements is true with respect to this visualization? The net cash provided by operating activities and net income tend to move in opposite directions, thereby suggesting a high level of earnings quality The net cash provided by operating activities and net income tend to move in tandem, thereby suggesting a high level of earnings quality. The net cash provided by operating activities and net income tend to move in opposite directions, thereby suggesting a low level of eamings quality