Financial data of target

Assignment Help Financial Accounting
Reference no: EM13949425

Suppose selected financial data of Target and Wal-Mart for 2014 are presented here (in millions).

 

 

Target
Corporation

 

Wal-Mart
Stores, Inc.

 

 

Income Statement Data for Year

Net sales

 

$65,058

 

 

$412,070

 

Cost of goods sold

 

44,493

 

 

300,265

 

Selling and administrative expenses

 

14,313

 

 

80,030

 

Interest expense

 

670

 

 

2,152

 

Other income (expense)

 

(88)

 

 

(395)

 

Income tax expense

 

1,470

 

 

7,329

 

Net income

 

$ 4,024

 

 

$ 21,899

 

 

 

 

 

 

 

 

 

 

Balance Sheet Data
(End of Year)

Current assets

 

$18,846

 

 

$48,777

 

Noncurrent assets

 

25,173

 

 

120,791

 

Total assets

 

$44,019

 

 

$169,568

 

Current liabilities

 

$10,432

 

 

$55,783

 

Long-term debt

 

17,183

 

 

44,562

 

Total stockholders' equity

 

16,404

 

 

69,223

 

Total liabilities and stockholders' equity

 

$44,019

 

 

$169,568

 

 

 

 

 

 

 

 

 

 

Beginning-of-Year Balances

Total assets

 

$43,699

 

 

$164,440

 

Total stockholders' equity

 

14,470

 

 

65,233

 

Current liabilities

 

10,130

 

 

55,092

 

Total liabilities

 

29,229

 

 

99,207

 

 

 

 

 

 

 

 

 

 

Other Data

Average net accounts receivable

 

$7,545

 

 

$3,954

 

Average inventory

 

6,834

 

 

34,287

 

Net cash provided by operating activities

 

5,765

 

 

26,622

 

Capital expenditures

 

1,799

 

 

11,751

 

Dividends

 

512

 

 

4,215

 

                           


(a) For each company, compute the following ratios. (Round all answers to 2 decimal places, e.g. 1.83 or 12.61%.)

 

 

 

 

Target

 

Wal-Mart

(1)

 

Current ratio.

 

https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

:1

 

https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

:1

(2)

 

Accounts receivable turnover.

 

https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

times

 

https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

times

(3)

 

Average collection period.

 

https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

days

 

https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

days

(4)

 

Inventory turnover.

 

https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

times

 

https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

times

(5)

 

Days in inventory.

 

https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

days

 

https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

days

(6)

 

Profit margin.

 

https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

%

 

https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

%

(7)

 

Asset turnover.

 

https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

times

 

https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

times

(8)

 

Return on assets.

 

https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

%

 

https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

%

(9)

 

Return on common stockholders' equity.

 

https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

%

 

https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

%

(10)

 

Debt to assets ratio.

 

https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

%

 

https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

%

(11)

 

Times interest earned.

 

https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

times

 

https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

times

(12)

 

Current cash debt coverage.

 

https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

times

 

https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

times

(13)

 

Cash debt coverage.

 

https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

times

 

https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

times

(14)

 

Free cash flow.

 

$https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

 

 

$https://edugen.wileyplus.com/edugen/art2/common/pixel.gif

 

Reference no: EM13949425

Questions Cloud

Is higgins liable for glenwood''s malpractice explain : Two lawyers, Glenwood and Higgins, formed a partnership. Glenwood failed to file Client's paperwork on time in a case, with adverse financial consequences to Client.
The three potential conflicts of interest : What are the three potential conflicts of interest that can take place during the auditing process? Explain.
Design an information system for grades, review &management : Design an information system for grades, review and management to be used by faculty, department administration and students.
Hector was employed by a machine shop : Hector was employed by a machine shop. One day he made a delivery for his employer and proceeded back to the shop. When he was four miles from the shop and on the road where it was located, he turned left onto another road to visit a friend. The frie..
Financial data of target : Suppose selected financial data of Target and Wal-Mart for 2014 are presented here in millions.
Empathy should be part of the criminal justice system : Take a position on this statement: Empathy should be part of the criminal justice system. Explain your position.
Critical legal thinking : Read the call-of-the-question carefully, and follow the instructions for each subject. Prepare four briefing papers using the APA format for research papers, and upload them as one document for your response.
Write an essay on famous defamation case : Write an essay on famous defamation case and  5 pages, list why the party is liable, list all steps for defamation, difference between actual malice, ect
Find cost per patient day using a functional-based approach : Calculate the cost per patient day using a functional-based approach. Calculate the cost per patient day using an activity-based approach.

Reviews

Write a Review

Financial Accounting Questions & Answers

  Financial statement analysis and preparation

Financial Statement Analysis and Preparation

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Financial and accounting principles

An understanding of financial and accounting principles can be a valuable tool for managers. While not all managers will find themselves calculating financial ratios or preparing annual financial data.

  Prepare a statement of cash flow using the direct method

Prepare a Statement of Cash Flow using the Direct Method and Prepare the Operations section of the Statement of Cash Flow using the Indirect Method.

  Financial accounting assignment

This assignment has one case study and two question apart from case study. Questions related to document Liquidation question and Company financial statements question - Torquay Limited

  Prepare general journal entries for goela

Prepare general journal entries for Goela Ltd

  Principles of financial accounting

Prepare the journal entry to record the acquisition of the assets.

  Prepare general journal entries to record the transactions

Prepare general journal entries to record the transactions, assuming use of the periodic inventory system

  Global reporting initiative

Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

  Explain the iasb conceptual frameworks

Explain the IASB Conceptual Framework's perspective of users and their decisions.

  Determine the company''s financial statements

T he focus of the report is to determine the extent to which you are comfortable relying on the financial statements as presented by management .

  Computation of free cash flow

Computation of Free Cash Flow

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd