Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Value 8 5K - 10K 15K- 20K - 25K 30K 35K 31,530 27,389 28,564 23,257 25,591 24,255 23,643 26,249 26,843 21,854 Big Store 2012 2013
Value 8 5K - 10K 15K- 20K - 25K 30K 35K 31,530 27,389 28,564 23,257 25,591 24,255 23,643 26,249 26,843 21,854 Big Store 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 Count of Sheet1 1 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 Count of Sheet1 1 Opreationg cash flows: Discont Goods vs. Big store Store | 24,160 26,480 19,729 28,978 23,667 24,151 | 23,427 26,138 27,617 23,316 Discount Goods Value -20K -10K OK 30K 40K 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 Count of Sheet1 14,293 15,080 17,099 16,695 17,756 16,387 16,993 14,883 20,866 13,708 Discont Goods vs. Big store Big Store Store 2012 2013 2014 | 24,329 29,893 -14,542 2015 2016 2017 2018 2019 2020 2021 Count of Sheet1 17,520 26,658 26,036 25,956 22,116 29,111 18,282 Discount Goods 2 LLO2-7 In the Chapter 1 Data Analytics Case, you applied Tableau to examine a data set and create bar charts to compare ten-year trends in operating cash flows and net income for our two (hypothetical) publicly traded companies: Discount Goods and Big Store. In this case you continue in your role as an analyst conducting introductory research into the relative merits of investing in one or both of these companies, this time comparing the proportional composition of the assets, liabilities, and stockholders' equity of the two companies. You want to create pie charts to visualize the relative size of the components of the balance sheets for each of the two companies to garner some initial insights. Required: Total assets are equal to Total liabilities plus Total shareholders' equity. This equation is based on the fact that a company's assets come from these two sources: (1) amounts borrowed and (2) amounts provided by owners ([a] amounts invested by shareholders in the corporation, reported as paid-in capital and [b] amounts earned by the corporation on behalf of its shareholders, reported as retained earnings). The relative proportion of assets provided by liabilities can be an indication of the riskiness of an investment, making these relationships valuable when analyzing a company's financial position. Use Tableau to create pie charts depicting the relative size of the assets, liabilities, and stockholders' equity for each of the two companies in 2021. Based upon what you find, answer the following questions: 1. For Discount Goods, do liabilities or shareholders' equity provide the greater proportion of the company's total assets? Page 107 2. For Big Store, do liabilities or shareholders' equity provide the greater proportion of the company's total assets? 3. Which of the two companies has the highest ratio of current liabilities to total liabilities? What is the ratio for that company (rounded to nearest whole percentage point)? 4. Which of the two companies has the highest ratio of current assets to current liabilities? What is the ratio for that company (rounded to nearest whole percentage point)? Discount Goods 2021 Balance sheet -3,326 -13,127 25,948 0 184,796 Big store 2021 Balance sheet -4,246 -13,642 29,049 4,090 159,901 Value 8 5K - 10K 15K- 20K - 25K 30K 35K 31,530 27,389 28,564 23,257 25,591 24,255 23,643 26,249 26,843 21,854 Big Store 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 Count of Sheet1 1 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 Count of Sheet1 1 Opreationg cash flows: Discont Goods vs. Big store Store | 24,160 26,480 19,729 28,978 23,667 24,151 | 23,427 26,138 27,617 23,316 Discount Goods Value -20K -10K OK 30K 40K 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 Count of Sheet1 14,293 15,080 17,099 16,695 17,756 16,387 16,993 14,883 20,866 13,708 Discont Goods vs. Big store Big Store Store 2012 2013 2014 | 24,329 29,893 -14,542 2015 2016 2017 2018 2019 2020 2021 Count of Sheet1 17,520 26,658 26,036 25,956 22,116 29,111 18,282 Discount Goods 2 LLO2-7 In the Chapter 1 Data Analytics Case, you applied Tableau to examine a data set and create bar charts to compare ten-year trends in operating cash flows and net income for our two (hypothetical) publicly traded companies: Discount Goods and Big Store. In this case you continue in your role as an analyst conducting introductory research into the relative merits of investing in one or both of these companies, this time comparing the proportional composition of the assets, liabilities, and stockholders' equity of the two companies. You want to create pie charts to visualize the relative size of the components of the balance sheets for each of the two companies to garner some initial insights. Required: Total assets are equal to Total liabilities plus Total shareholders' equity. This equation is based on the fact that a company's assets come from these two sources: (1) amounts borrowed and (2) amounts provided by owners ([a] amounts invested by shareholders in the corporation, reported as paid-in capital and [b] amounts earned by the corporation on behalf of its shareholders, reported as retained earnings). The relative proportion of assets provided by liabilities can be an indication of the riskiness of an investment, making these relationships valuable when analyzing a company's financial position. Use Tableau to create pie charts depicting the relative size of the assets, liabilities, and stockholders' equity for each of the two companies in 2021. Based upon what you find, answer the following questions: 1. For Discount Goods, do liabilities or shareholders' equity provide the greater proportion of the company's total assets? Page 107 2. For Big Store, do liabilities or shareholders' equity provide the greater proportion of the company's total assets? 3. Which of the two companies has the highest ratio of current liabilities to total liabilities? What is the ratio for that company (rounded to nearest whole percentage point)? 4. Which of the two companies has the highest ratio of current assets to current liabilities? What is the ratio for that company (rounded to nearest whole percentage point)? Discount Goods 2021 Balance sheet -3,326 -13,127 25,948 0 184,796 Big store 2021 Balance sheet -4,246 -13,642 29,049 4,090 159,901
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started