Access the tableau dashboard hereLinks to an external site. to answer the next several questions. https://public.tableau.com/app/profile/asher.curtis/viz/ACCTG215DuPontSupplement/AccountingAnalytics 1.
Question:
Access the tableau dashboard hereLinks to an external site. to answer the next several questions.
https://public.tableau.com/app/profile/asher.curtis/viz/ACCTG215DuPontSupplement/AccountingAnalytics
1. Click on the "DuPont Ratios" tab in the dashboard. Which company, Nordstrom or Walmart, has had a higher return on assets over the last 20 years?
2.Click on the "DuPont Ratios" tab in the dashboard. Which company, Nordstrom or Walmart, has had a higher profit margin over the last 20 years?
3.Click on the "DuPont Ratios" tab in the dashboard. Which company, Nordstrom or Walmart, has had a higher asset turnover over the last 20 years?
4.Click on the "DuPont Ratios" tab in the dashboard. Which company, Nordstrom or Walmart, appears to have been affected more by the pandemic? Explain your answer. You should discuss your interpretation of each of the three ratios above and the trends in ratios pictured in the dashboard.
5.Click on the "DuPont and Strategy" tab in the dashboard. The theory on the trade-off between price differentiator strategies and cost leader strategies suggests that Walmart (which we expect to be a cost leader) will have a higher asset turnover and Nordstrom (which we expect to be a price differentiator) will have a higher profit margin. Use the Company Name Search to identify Walmart and Nordstrom.
Does the theory hold in the data? Discuss what you see in the visualization and how you interpret what you see.
6.Click on the "Company Selector" tab in the dashboard. Choose any two companies you are interested in (except Nordstrom and Walmart). Use the "Company 1" dropdown menu to select the first company, and the "Company 2" dropdown menu to select the second company. Then, use the "DuPont Ratio Selector" dropdown menu to move between the three ratios. Answer the following questions:
1. Describe your understanding of the two companies' businesses. In other words, how do they each generate revenue? What are their strategies?
2. Which company has a higher Return on Assets, Profit Margin, and Asset Turnover over the last 20 years? Explain if the results for these ratios are consistent or inconsistent with the companies' strategies.
3. Which company appears to have been affected more by the pandemic? Explain your answer. You should discuss your interpretation of each of the three ratios above and the trends in ratios pictured in the dashboard.
Principles of Information Systems
ISBN: 978-0324665284
9th edition
Authors: Ralph M. Stair, George W. Reynolds