4 ints Book ference Chapel 3 Loid drys Cases, you use our unser Lisens Compare our w (hypothetical) publicly traded companies, Discount Goods and Big Store, as to their liquidity-their ability to pay short- term debts as they come due. You did so by comparing current ratios and acid-test ratios. In this case, you will expand your assessment of the companies' liquidity by also evaluating other aspects of liquidity as measured by their cash to current liabilities and current liabilities to net worth ratios. The cash to current liabilities ratio (also known as the cash ratio) is measured as cash and cash equivalents/total current liabilities and tells us about the ability of a company to settle its current liabilities using only its cash and highly liquid investments The current liabilities to net worth ratio is measured as current liabilities/shareholders' equity and tells us about the relationship between capital contributed by current obligation creditors and capital contributed by owners. It indicates the ability of a company to safely meet the obligations of current creditors. The higher the ratio, the less security there is for current obligation creditors. Tableau Instructions: You have available to you an extensive data set that includes detailed financial data for Discount Goods and Big Store for 2012-2021. The data set is in the form of four Excel files available to download from Connect or under Student Resources within the Library tab.The one for use in this chapter is named "Discount Goods Big Store Financials.xlsx Download this file and save it to the computer on which you will be using Tableau. For this case, you will create calculations to produce several liquidity ratios allowing you to compare and contrast the two companies. After you view the training videos, follow these steps to create the charts you'll use for this case 1. Open Tableau and connect to the Excel spreadsheet you downloaded. 2. Click on the "Sheet 1" tab at the bottom of the canvas, to the right of the Data Source at the bottom of the screen. Drag "Company" and "Year" under "Dimensions" to the Rows shelf. Change "Year" to discrete by right-clicking and selecting "discrete. Select "Show Filter" and uncheck all the years except 2021. Click "Ok" 3. Create the "Current Ratio" and "Quick Ratio" by following the steps in the Chapter 3 Data Analytics Case. After creating the two ratios, drag them to the Rows shelf. Change the ratios back to continuous by right-clicking and selecting "Continuous." 4. Create a calculated field "Cash Ratio" by dragging "Cash and cash equivalents" under "Measures" into the Calculation Editor window. Type a division sign, then drag the "Total current liabilities" beside it. Make sure the window says that the calculation is valid and click OK. Drag the newly created "Cash Ratio" to the Rows shelf 5. Create a calculated field "Current Liabilities to Net Worth" by dragging "Total current liabilities" from the under "Measures" into the Calculation Editor window. Type a division sign, then drag the "Total shareholders' equity" beside it. Make sure the window says that the calculation is valid and click OK. Drag the newly created "Current Liabilities to Net Worth" to the Rows shelf. 6. Click on the "Show Me" tab in the upper right comer and select "horizontal bars." You should now see for each company, for the year 2021, the four ratios on that horizontal bar chart. Add labels to the bars by clicking on "Label" under the "Marks" card and clicking the box "Show mark label." Format the labels to Times New Roman, bold, black and 9-point font 7. Change the title of the sheet to be "Liquidity Ratios" by right-clicking and selecting "Edit title." Format the title to Times New Roman, bold, black and 15-point font. Format all other labels to be Times New Roman, bold, black and 12- point font. Change the title of "Sheet 1" to match the sheet title by right-clicking, selecting "Rename" and typing in the new title. Drag "Company" to the Color card in the "Marks" card to change the bars to two different colors 8. Once complete, save the file as "DA13 Your initials.twbx" Required: Based upon what you find, answer the following questions: A. Other things being equal, which company appears to have the better liquidity position in terms of their ability to pay short-term debts as they come due as measured by the current ratio? B. Which company appears to offer the better liquidity position in terms of their ability to pay short-term debts as they come due as measured by the acid-test or quick ratio? C. Other things beirig equal, which company appears to have the better liquidity position in terms of ability of the company's current liabilities to be covered using its cash and cash equivalents? D. Which company appears to offer the better security for its current obligation creditors as measured by the current liabilities to net worth ratio? Note: As you assess the liquidity aspect of the companies, keep in mind that liquidity ratios should be evaluated in the context of both profitability and efficiency of managing assets and relative to average liquidity ratios of the industry. A. Better liquidity position in terms of their ability to pay short-term debts as they come due as measured by the current ratio B. Better liquidity position in terms of their ability to pay short-term debts as they come due as measured by the acid-test or quick ratio C. Better liquidity position in terms of ability of the company's current liabilities to be covered using its cash and cash equivalents D. Better security for its current obligation creditors as measured by the current liabilities to net worth ratio