Target & Walmart: Financial Statement Analysis Research Paper

Pages: 15 (4185 words)  ·  Bibliography Sources: 15  ·  File: .docx  ·  Level: Doctorate  ·  Topic: Finance

SAMPLE EXCERPT . . .
93

2015 = 63,278,000 / 65,253,000 = 0.97

ii. Target 2016 = 14,130,000 / 12,622,000 = 1.12

2015 = 13,624,000 / 11,736,000 = 1.16

Working capital

Working Capital = Current Assets -- Current Liabilities

i. Walmart

2016 = 60,239,000-64,619,000 = - 4,380,000

2015 = 63,278,000-65,253,000 = - 1,975,000

iii. Target 2016 = 14,130,000-12,622,000 = 1,508,000

2015 = 13,624,000-11,736,000 = 1,888,000

Inventory turnover ratio (if applicable)

Inventory turnover ratio = Cost of Goods Sold or Net Sales / Average Inventory

i. Walmart

2016 = 360,984,000 / ((44,496,000 + 45,141,000) / 2) = 8.054

2015 = 365,086,000 / ((45,141,000 + 44,858,000) / 2) = 8.113

ii. Target 2016 = 51,997,000 / ((8,601,000 + 8,282,000) / 2) = 6.16

2015 = 51,278,000 / ((8,282,000 + 8,278,000) / 2) = 6.19

Debt-to-equity ratio

Debt to equity ratio = Total Liabilities / Stakeholders' Equity

i. Walmart

2016 = 119,035,000 / 80,546,000 = 1.478

2015 = 122,096,000 / 81,394,000 = 1.5

ii. Target 2016 = 27,305,000 / 12,957,000 = 2.107

Buy full Download Microsoft Word File paper
for $19.77
2015 = 27,175,000 / 13,977,000 = 1.944

Return on assets (ROA)

Return on Assets = Net Income / Total Assets

i. Walmart

2016 = 14,694,000 / 199,581,000 = 0.0736

2015 = 16,363,000 / 203,490,000 = 0.0804

ii. Target 2016 = 3,363,000 / 40,262,000 = 0.0835

2015 = -1,636,000 / 41,172,000 = -0.0397

Return on equity (ROE)

Research Paper on Target & Walmart: Financial Statement Analysis Assignment

Return on Equity = Net Income / Total Equity

i. Walmart

2016 = 14,694,000 / 80,546,000 = 0.182

2015 = 16,363,000 / 81,394,000 = 0.201

ii. Target 2016 = 3,363,000 / 12,957,000 = 0.260

2015 = -1,636,000 / 13,977,000 = -0.117

Earnings per share

Earnings per share = (Net Income -- Preferred Dividends) / Weighted Average Common Shares Outstanding

i. Walmart

2016 = 14,694,000 / 317,000 = 46.21

2015 = 16,363,000 / 323,000 = 50.66

ii. Target 2016 = 3,363,000 / 50,000 = 67.26

2015 = -1,636,000 / 53,000 = -30.87

Current (most recent) balance sheet

i. Walmart balance sheet

Assets

2016

2015

Current Assets

Cash and Cash Equivalents

8705000.00

9135000.00

-4.71%

Short-Term Investments

Net Receivables

5,624,000

6,778,000

-17.03%

Inventory

44,469,000

45,141,000

-1.49%

Other Current Assets

1,441,000

2,224,000

-35.21%

Total Current Assets

60,239,000

63,278,000

-4.80%

Long-Term Investments

Property Plant and Equipment

116,516,000

116,655,000

-0.12%

Goodwill

16,695,000

18,102,000

-7.77%

Intangible Assets

Accumulated Amortization

Other Assets

6,131,000

5,455,000

12.39%

Deferred Long-Term Asset Charges

Total Assets

199,581,000

203,490,000

1.96%

Liabilities

Current Liabilities

Accounts Payable

58,615,000

58,583,000

0.05%

Short/Current Long-Term Debt

60,004,000

6,670,000

Other Current Liabilities

Total Current Liabilities

64,619,000

65,253,000

-0.97%

Long-Term Debt

44,030,000

43,495,000

1.23%

Other Liabilities

Deferred Long-Term Liability Charges

7,321,000

8,805,000

-16.85%

Minority Interest

3,065,000

4,543,000

-32.53%

Negative Goodwill

Total Liabilities

119,035,000

122,096,000

-2.51%

Stockholders' Equity

Misc Stocks Options Warrants

Redeemable Preferred Stock

Preferred Stock

Common Stock

317,000

323,000

-1.86%

Retained Earnings

90,021,000

85,777,000

4.95%

Treasury Stock

Capital Surplus

1,805,000

2,462,000

-26.69%

Other Stockholder Equity

-11,597,000

-7,168,000

61.79%

Total Stockholder Equity

80,546,000

81,394,000

-1.04%

Net Tangible Assets

63,851,000

63,292,000

0.88%

ii. Target Balance Sheet

2016

2015

Assets

Current Assets

Cash and Cash Equivalents

4,046,000

2,210,000

83.08%

Short-Term Investments

Net Receivables

Inventory

8,601,000[END OF PREVIEW] . . . READ MORE

Two Ordering Options:

?
Which Option Should I Choose?
1.  Buy full paper (15 pages)Download Microsoft Word File

Download the perfectly formatted MS Word file!

- or -

2.  Write a NEW paper for me!✍🏻

We'll follow your exact instructions!
Chat with the writer 24/7.

Financial Statements and Ethics Research Paper


Financial Analysis of Brocade Communications Systems, Inc Research Paper


Financial and Management Accounting Essay


Financial Statements: Introduction, by David Harper ) Article Review


Financial Statement Analysis Essay


View 200+ other related papers  >>

How to Cite "Target & Walmart: Financial Statement Analysis" Research Paper in a Bibliography:

APA Style

Target & Walmart: Financial Statement Analysis.  (2016, September 16).  Retrieved April 9, 2020, from https://www.essaytown.com/subjects/paper/indepth-analysis-financial-statement/3710814

MLA Format

"Target & Walmart: Financial Statement Analysis."  16 September 2016.  Web.  9 April 2020. <https://www.essaytown.com/subjects/paper/indepth-analysis-financial-statement/3710814>.

Chicago Style

"Target & Walmart: Financial Statement Analysis."  Essaytown.com.  September 16, 2016.  Accessed April 9, 2020.
https://www.essaytown.com/subjects/paper/indepth-analysis-financial-statement/3710814.