[Solved] Business Finance – Accounting ACC-370 Data Analytics Assignment 2

Assignment Prompt & Instructions

– ## ACC-370DataAnalyticsAssignment2.docx – Kieso18e_Ch4_DA4.2_AIA_data_and_student_submission_template.xlsx **## ACC-370DataAnalyticsAssignment2.docx** Please complete the following steps _Part 1: View the following videos:_ | | | | | — | — | — | | ● | | [MS Video: Add and Format Charts](https://support.office.com/en-us/article/video-create-charts-231c42d2-5e58-40e1-99f0-cbe618cfee1d?ui=en-US&rs=en-US&ad=US) | | ● | | [MS Video: Analyze and Chart Data](https://support.office.com/en-us/article/video-quick-analysis-of-data-343e775c-58ee-4a3d-8d52-f4e3f5240d79?ui=en-US&rs=en-US&ad=US) | _Part 2: Complete the following exercise:_ | | | | | — | — | — | | ● | | Download the spreadsheet with select data from most of the DOW 30 companies (excluding some financial and other companies.) | [Click here to view the Excel.](https://education.wiley.com/was/ui/v2/assessment-player/index.html?launchId=9a45a1d3-8f14-4ff5-98b6-cf2d0fd98922) | | | | | — | — | — | | 1. | | Save the spreadsheet you downloaded from your WileyPLUS course or that your instructor provided. On the first tab, you’ll see the data needed for this assignment. On the second tab (Ratios- Student Submission) the first four columns of data have been copied over for you. Please use columns E-W to submit your answers. | | 2. | | Use the select data (tab 1) from most of the DOW 30 companies (excluding some financial and other companies) to calculate liquidity, activity, profitability and coverage ratios. (Reminder, do this on tab 2-Ratios- Student Submission) | | ● | | **Use Tab 3 (Graphs and Short Answers) to submit your graphs and answers to the short answer questions below.** | | | | | | | — | — | — | — | | 3. | | Create a bar graph that compares asset turnover ratios. | | 4. | | Use column W to divide inventory/total assets. (Ratios- Student Submission) | | | | ● | Add this measure to your bar graph. | | 5. | | Pick two other ratios to conduct similar analysis as above. Feel free to create new ratios as we did with the inventory/total assets. | 1-When comparing the companies with a higher percentage of inventory/ assets, what did you notice about these companies relative to their asset turnover? Select answer from the options below a-They have a higher rate of asset turnover b-The asset turnover is flat between all companies c-They have a lower rate of asset turnover d-There is no correlation between companies with a higher inventory/assets and asset turnover 2-What is the current ratio for Verizon? Select answer from the options below 0.76 0.91 0.67 1.80 3- What is Nike’s Accounts Receivable Turnover? Select answer from the options below 9.93 4.73 5.15 6.15 4- What is the Return of Assets for Apple? Select answer from the options below 0.05 0.01 0.03 0.14  ## image1.png **Kieso18e_Ch4_DA4.2_AIA_data_and_student_submission_template.xlsx** This file is too large to display. [View in new window](https://www.sweetstudy.com/files/kieso18e-ch4-da4-2-aia-data-and-student-submission-template-xlsx) **Kieso18e_Ch4_DA4.2_AIA_data_and_student_submission_template.xlsx** This file is too large to display. [View in new window](https://www.sweetstudy.com/files/kieso18e-ch4-da4-2-aia-data-and-student-submission-template-xlsx) **## ACC-370DataAnalyticsAssignment2.docx** Please complete the following steps _Part 1: View the following videos:_ | | | | | — | — | — | | ● | | [MS Video: Add and Format Charts](https://support.office.com/en-us/article/video-create-charts-231c42d2-5e58-40e1-99f0-cbe618cfee1d?ui=en-US&rs=en-US&ad=US) | | ● | | [MS Video: Analyze and Chart Data](https://support.office.com/en-us/article/video-quick-analysis-of-data-343e775c-58ee-4a3d-8d52-f4e3f5240d79?ui=en-US&rs=en-US&ad=US) | _Part 2: Complete the following exercise:_ | | | | | — | — | — | | ● | | Download the spreadsheet with select data from most of the DOW 30 companies (excluding some financial and other companies.) | [Click here to view the Excel.](https://education.wiley.com/was/ui/v2/assessment-player/index.html?launchId=9a45a1d3-8f14-4ff5-98b6-cf2d0fd98922) | | | | | — | — | — | | 1. | | Save the spreadsheet you downloaded from your WileyPLUS course or that your instructor provided. On the first tab, you’ll see the data needed for this assignment. On the second tab (Ratios- Student Submission) the first four columns of data have been copied over for you. Please use columns E-W to submit your answers. | | 2. | | Use the select data (tab 1) from most of the DOW 30 companies (excluding some financial and other companies) to calculate liquidity, activity, profitability and coverage ratios. (Reminder, do this on tab 2-Ratios- Student Submission) | | ● | | **Use Tab 3 (Graphs and Short Answers) to submit your graphs and answers to the short answer questions below.** | | | | | | | — | — | — | — | | 3. | | Create a bar graph that compares asset turnover ratios. | | 4. | | Use column W to divide inventory/total assets. (Ratios- Student Submission) | | | | ● | Add this measure to your bar graph. | | 5. | | Pick two other ratios to conduct similar analysis as above. Feel free to create new ratios as we did with the inventory/total assets. | 1-When comparing the companies with a higher percentage of inventory/ assets, what did you notice about these companies relative to their asset turnover? Select answer from the options below a-They have a higher rate of asset turnover b-The asset turnover is flat between all companies c-They have a lower rate of asset turnover d-There is no correlation between companies with a higher inventory/assets and asset turnover 2-What is the current ratio for Verizon? Select answer from the options below 0.76 0.91 0.67 1.80 3- What is Nike’s Accounts Receivable Turnover? Select answer from the options below 9.93 4.73 5.15 6.15 4- What is the Return of Assets for Apple? Select answer from the options below 0.05 0.01 0.03 0.14  ## image1.png **Kieso18e_Ch4_DA4.2_AIA_data_and_student_submission_template.xlsx** This file is too large to display. [View in new window](https://www.sweetstudy.com/files/kieso18e-ch4-da4-2-aia-data-and-student-submission-template-xlsx) **## ACC-370DataAnalyticsAssignment2.docx** Please complete the following steps _Part 1: View the following videos:_ | | | | | — | — | — | | ● | | [MS Video: Add and Format Charts](https://support.office.com/en-us/article/video-create-charts-231c42d2-5e58-40e1-99f0-cbe618cfee1d?ui=en-US&rs=en-US&ad=US) | | ● | | [MS Video: Analyze and Chart Data](https://support.office.com/en-us/article/video-quick-analysis-of-data-343e775c-58ee-4a3d-8d52-f4e3f5240d79?ui=en-US&rs=en-US&ad=US) | _Part 2: Complete the following exercise:_ | | | | | — | — | — | | ● | | Download the spreadsheet with select data from most of the DOW 30 companies (excluding some financial and other companies.) | [Click here to view the Excel.](https://education.wiley.com/was/ui/v2/assessment-player/index.html?launchId=9a45a1d3-8f14-4ff5-98b6-cf2d0fd98922) | | | | | — | — | — | | 1. | | Save the spreadsheet you downloaded from your WileyPLUS course or that your instructor provided. On the first tab, you’ll see the data needed for this assignment. On the second tab (Ratios- Student Submission) the first four columns of data have been copied over for you. Please use columns E-W to submit your answers. | | 2. | | Use the select data (tab 1) from most of the DOW 30 companies (excluding some financial and other companies) to calculate liquidity, activity, profitability and coverage ratios. (Reminder, do this on tab 2-Ratios- Student Submission) | | ● | | **Use Tab 3 (Graphs and Short Answers) to submit your graphs and answers to the short answer questions below.** | | | | | | | — | — | — | — | | 3. | | Create a bar graph that compares asset turnover ratios. | | 4. | | Use column W to divide inventory/total assets. (Ratios- Student Submission) | | | | ● | Add this measure to your bar graph. | | 5. | | Pick two other ratios to conduct similar analysis as above. Feel free to create new ratios as we did with the inventory/total assets. | 1-When comparing the companies with a higher percentage of inventory/ assets, what did you notice about these companies relative to their asset turnover? Select answer from the options below a-They have a higher rate of asset turnover b-The asset turnover is flat between all companies c-They have a lower rate of asset turnover d-There is no correlation between companies with a higher inventory/assets and asset turnover 2-What is the current ratio for Verizon? Select answer from the options below 0.76 0.91 0.67 1.80 3- What is Nike’s Accounts Receivable Turnover? Select answer from the options below 9.93 4.73 5.15 6.15 4- What is the Return of Assets for Apple? Select answer from the options below 0.05 0.01 0.03 0.14  ## image1.png **Kieso18e_Ch4_DA4.2_AIA_data_and_student_submission_template.xlsx** This file is too large to display. [View in new window](https://www.sweetstudy.com/files/kieso18e-ch4-da4-2-aia-data-and-student-submission-template-xlsx) – 1 – 2