Purchase Solution

Wal-Mart ratio analysis

Not what you're looking for?

Ask Custom Question

Resource: Financial Statements for the company assigned by your instructor in Week 2.

Review the assigned company's financial statements from the past three years.

Calculate the financial ratios for the assigned company's financial statements, and then interpret those results against company historical data as well as industry benchmarks:

- Compare the financial ratios with each of the preceding three (3) years (e.g. 2014 with 2013; 2013 with 2012; and 2012 with 2011).
- Compare the calculated financial ratios against the industry benchmarks for the industry of your assigned company.

Write a 500 to 750 word summary of your analysis.

Show financial calculations where appropriate.

Walmart Stores ratio analysis, I am looking for at least 12 comparative ratios (for current and prior year) spread across the four major categories of ratios.

Purchase this Solution

Solution Summary

Ratio analysis of Wal-Mart

Solution Preview

Attached

-

1. Current Ratio = Current assets/current liabilities
Data in $ millions
2014 2013 2012 2011
Current assets 61,185 59,940 54,975 51,893
Current liabilities 69,345 71,818 62,300 58,484
Current ratio 0.88 0.83 0.88 0.89
Industry - 1.14 1.22 1.24

Current ratio deteriorated slightly from 0.89 in 2011 to 0.88 in 2012. In 2013, it further deteriorated to 0.83. However there was an improvement in 2014.
2. Quick Ratio = Total quick assets ÷ Current liabilities
2014 2013 2012 2011
Cash & cash equivalents 7,281 7,781 6,550 7,395
Net receivables 6,677 6,768 5,937 5,089
Total quick assets 13,958 14,549 12,487 12,484
Current liabilities 69,345 71,818 62,300 58,484
Quick Ratio 0.20 0.20 0.20 0.21
Industry 0.60 0.65 0.62

The quick ratio deteriorated slightly from 2011 to 2012. It was then constant from 2013 to 2014. As compared to the industry, quick ratio is much less than it should be.
3. Cash Ratio = Total cash assets/Current liabilities
2014 2013 2012 2011
Cash & cash equivalents 7,281 7,781 6,550 7,395
Current liabilities 69,345 71,818 62,300 58,484
Cash ratio 0.10 0.11 0.11 0.13
Industry 0.29 0.33 0.31

Wal-Mart's cash ratio deteriorated from 2011 to 2012. From 2012 to 2013 it remained constant but decreased in 2014. As compared to the industry average, the cash ratio falls far behind the benchmark.
Wal-Mart's current ratio has been stable but its low due to which there is a concern over company's ...

Purchase this Solution


Free BrainMass Quizzes
Change and Resistance within Organizations

This quiz intended to help students understand change and resistance in organizations

Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.

Paradigms and Frameworks of Management Research

This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.

Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

Motivation

This tests some key elements of major motivation theories.