Answered step by step
Verified Expert Solution
Question
1 Approved Answer
help with full answers pls #1&3&4 pls Tableau Dashboard Activity 11-1 (Static) Finding Evidence of Earnings Management in a Tableau Dashboard [LO 11-5] The Sarbanes-Oxley
help with full answers pls
Tableau Dashboard Activity 11-1 (Static) Finding Evidence of Earnings Management in a Tableau Dashboard [LO 11-5] The Sarbanes-Oxley Act of 2002 (SOX) was created, in part, to address cases of companies making fraudulent entries to avoid reporting net losses. To find evidence of this kind of earnings management, review the below Tableau dashboard, which includes available data from all US. public companies for 1985-2017 (except banks, financial institutions, and other regulated companies). By following the requirements below, you will discover whether earnings management occurred during certain periods 1. The graph displays, for more than 148,000 company-years, each company's net income divided by total stockholders' equity, By what name is this ratio known? 2. Select the statement that appropriately explains why the graph suggests evidence of earnings management 3. Using the fiter options in the upper right comer of the Tableau dashboard, select the "pre-SOx: years (1... 1985-2001) to alter the graph to show the number of companies reporting ratios prior to the implementation of SOX a. How many companies reported a ratio near zero (red bar) in the pre-SOX period? b. How many companies reported a ratio near -0.015 in the pre-SOX period? c. How many companies reported a ratio near +0.015 in the pre-SOX period? d. Divide your answer in 3 a by the total of your answers to 3a3c. What fraction of the companies in 3a3c reported a ratio near zero (red bar)? 4. Using the filter options in the upper right corner of the Tableau dashboard, select the "post-SOX: years (L.e. 2003-2017) to alter the graph to show the number of companies reporting ratios after the implementation of SOX. a. How many companies reported a ratio near zero (red bat) in the post-SOX period? b. How many companies reported a ratio near -0.015 in the post-SOX period? c. How many companies reported a ratio near +0.015 in the post-SOX period? d. Divide your answer in 4a by the total of your answers to 4a4c. What fraction of the companies in 4a4c reported a fatio near zero (red bar)? e. Do your answers in 3d and 4d suggest SOX encouraged a greater proportion of companies to honestly report near-zero earnings? Complete this question by entering your answers in the tabs below. The graph displays, for more than 148,000 company-years, each company's net income divided by total stockholders' equity. By what name is this ratio known? Eamines per share Complete this question by entering your answers in the tabs below. Select the statement that appropriately explains why the graph suggests evidence of earnings management. The number of companies reporting a ratio near zero (red bar) is smatier than expected, given the number of companies reporting Slightly more negative (0.015) and slightly more positive (0.015) ratios. The total number of companios reporting a positive rasio is greater than the total number of companies reporting a negative ratio. The total number of companies reporting a negative ratio is greater than the total mumber of companies reporting a positive ratio. None of the above. Using the filter options in the upper right corner of the Tableau dashboard, select the "pre-50x" years (L.e., 1985-2001) to alter the graph to show the number of companies reporting ratios prior to the implementation of SOX. (Round "Fraction of the companies" answer to 3 decimal places.) Using the fitter options in the upper right corner of the Tableau dashboard, select the "post-S0X" years (i.e., 2003-2017) to aiter the graph to show the number of companies reporting ratios after the implementation of SOX. (Round "Fraction of the companies" answer to 3 decimal places.) Tableau Dashboard Activity 11-1 (Static) Finding Evidence of Earnings Management in a Tableau Dashboard [LO 11-5] The Sarbanes-Oxley Act of 2002 (SOX) was created, in part, to address cases of companies making fraudulent entries to avoid reporting net losses. To find evidence of this kind of earnings management, review the below Tableau dashboard, which includes available data from all US. public companies for 1985-2017 (except banks, financial institutions, and other regulated companies). By following the requirements below, you will discover whether earnings management occurred during certain periods 1. The graph displays, for more than 148,000 company-years, each company's net income divided by total stockholders' equity, By what name is this ratio known? 2. Select the statement that appropriately explains why the graph suggests evidence of earnings management 3. Using the fiter options in the upper right comer of the Tableau dashboard, select the "pre-SOx: years (1... 1985-2001) to alter the graph to show the number of companies reporting ratios prior to the implementation of SOX a. How many companies reported a ratio near zero (red bar) in the pre-SOX period? b. How many companies reported a ratio near -0.015 in the pre-SOX period? c. How many companies reported a ratio near +0.015 in the pre-SOX period? d. Divide your answer in 3 a by the total of your answers to 3a3c. What fraction of the companies in 3a3c reported a ratio near zero (red bar)? 4. Using the filter options in the upper right corner of the Tableau dashboard, select the "post-SOX: years (L.e. 2003-2017) to alter the graph to show the number of companies reporting ratios after the implementation of SOX. a. How many companies reported a ratio near zero (red bat) in the post-SOX period? b. How many companies reported a ratio near -0.015 in the post-SOX period? c. How many companies reported a ratio near +0.015 in the post-SOX period? d. Divide your answer in 4a by the total of your answers to 4a4c. What fraction of the companies in 4a4c reported a fatio near zero (red bar)? e. Do your answers in 3d and 4d suggest SOX encouraged a greater proportion of companies to honestly report near-zero earnings? Complete this question by entering your answers in the tabs below. The graph displays, for more than 148,000 company-years, each company's net income divided by total stockholders' equity. By what name is this ratio known? Eamines per share Complete this question by entering your answers in the tabs below. Select the statement that appropriately explains why the graph suggests evidence of earnings management. The number of companies reporting a ratio near zero (red bar) is smatier than expected, given the number of companies reporting Slightly more negative (0.015) and slightly more positive (0.015) ratios. The total number of companios reporting a positive rasio is greater than the total number of companies reporting a negative ratio. The total number of companies reporting a negative ratio is greater than the total mumber of companies reporting a positive ratio. None of the above. Using the filter options in the upper right corner of the Tableau dashboard, select the "pre-50x" years (L.e., 1985-2001) to alter the graph to show the number of companies reporting ratios prior to the implementation of SOX. (Round "Fraction of the companies" answer to 3 decimal places.) Using the fitter options in the upper right corner of the Tableau dashboard, select the "post-S0X" years (i.e., 2003-2017) to aiter the graph to show the number of companies reporting ratios after the implementation of SOX. (Round "Fraction of the companies" answer to 3 decimal places.) #1&3&4 pls
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