high on Essays logo

Our Services

Get 15% Discount on your First Order

Business Finance – Accounting ACC-370 Data Analytics Assignment 2

Please complete the following steps

Part 1: View the following videos:


MS Video: Add and Format Charts


MS Video: Analyze and Chart Data

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.

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

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit
Reviews

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Homework  Channels and Metrics Note:  At the start of your DQ post,

Homework  Channels and Metrics Note:  At the start of your DQ post, remind us of the company and product/service you have chosen for your marketing campaign. Choose one social media channel and one traditional channel that you plan to use in your marketing campaign. For each channel, answer the following

BUSI46S15 Competitive Strategies & Organisational Fitness

BUSI46S15 Competitive Strategies & Organisational Fitness Postgraduate Programmes 2023/24 SUMMATIVE ASSIGNMENT – BUSI46S15 Competitive Strategies and Organizational Fitness Select an organization, identify its competitive environment (that is, the population it is a member of) [5 marks] Analyse (qualitatively) the ecological and institutional conditions in the population. [10 marks] Provide a