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

  Calculation of cost of goods solditems 1 and 2 are based on

calculation of cost of goods solditems 1 and 2 are based on the following information.nolan owns 100 percent of the

  How managerial accounting is different from cost accounting

She needs to cut $94,000 in cost. Prioritize those cuts that can be made without impacting the operation or quality care of the organization. how managerial accounting is different from cost accounting.

  Data presented what it be advisable to make carrying case

Matchless computer company has been purchasing carrying cases for its portable computers and delivered cost of $55 per unit the company which is currently operating below full capacity charges factory overhead to production at the rate of 40 percent ..

  Compute the cost of goods available for sale

Compute the cost of goods available for sale and the units available for sale for this four week period. Assume that no sales occur during those four weeks.

  Determine the expected return on barbaras investment

Determine the expected return on Barbaras investment

  Prepare journal entry to record the revaluation of equipment

At the beginning of its 2016 fiscal year, Amershan Co. purchased equipment for $100,000. The equipment is expected to have a five-year life useful life with no residual value. At the end of the year, the company chooses to revalue the equipment. The ..

  Under a modified wage plan an employee earns

Under a modified wage plan, an employee earns $1.50 for each finished unit and is guaranteed $18 per hour as a minimum wage. If the daily quota is 96 units, on a particular day when an employee completes 90 units and works 8 hours, the amount of the ..

  What basic accounting principle is violated

Using the information gained from reading the SEC's Accounting and Auditing Enforcement Release against Federico Quinto, Jr., what stands out to you as the most serious of the charges? Why? In the Delphi Corporation case, why is the recording of the ..

  Calculate the costs transferred out of each department

Sabor Company produces 18-ounce boxes of an oat cereal. Calculate costs transferred out of each department. Prepare journal entries that reflect these cost transfers.

  Straight-line method of depreciation

Caterpillars Inc., a manufacturing company, acquired equipment on January 1, 2012 for $500,000. Estimated useful life of the equipment was 7 years and the estimated residual value was $10,000. On January 1, 2015, after using the equipment for 3 years..

  Eliminating the three options for accounting for investment

Should the FASB consider eliminating the three options for accounting for an investment in a company and create one method for all situations?

  Capital budgeting criteria-ethical considerations

An electric utility is considering a new power plant in northern Arizona. Power from the plant would be sold in the Phoenix area, where it is badly needed. Because the firm has received a permit, the plant would be legal; but it would cause some air ..

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