Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Statement of Operations (Income Statement) Fiscal Year end is January 31; years indicated below are the year the majority of activity occurred (so 2018 is

Statement of Operations (Income Statement)

Fiscal Year end is January 31; years indicated below are the year the majority of activity occurred (so 2018 is February 2018 through January 2019)

2018 2017 2016 2015 2014 2013
Net Sales 510,329 495,761 481,317 478,614 482,229 473,076
Membership and other income 4,076 4,582 4,556 3,516 3,422 3,218
total revenues 514,405 500,343 485,873 482,130 485,651 476,294
Cost of Sales 385,301 373,396 361,256 360,984 365,086 358,069
Operating, selling, General and Admin Expenses 107,147 106,510 101,853 97,041 93,418 91,353
Operating income 21,957 20,437 22,764 24,105 27,147 26,872
Interest Expense 2,129 2,178 2,267 2,467 2,348 2,216
other -8,368 -3,136
Income from continuing operations, before taxes 11,460 15,123 20,497 21,638 24,799 24,656
Income taxes, and discontinued operations 4,281 4,600 6,204 6,558 7,985 8,105
Net Income 7,179 10,523 14,293 15,080 16,814 16,551
Non controlling interest, currency translation, and other -565 3,537 -3,682 -4,901 -4,554 -3,091
pension liability 131 -147 397 86 -69 153
comprehensive income attributable to Walmart 6,745 13,913 11,008 10,265 12,191 13,613
Balance Sheet

Fiscal Year end is January 31; years indicated below are the year the majority of activity occurred (so 2018 is February 2018 through January 2019)

2018 2017 2016 2015 2014 2013
Assets
Current assets:
Cash and cash equivalents 7,722 6,756 6,867 8,705 9,135 9,135
Receivables, net 6,283 5,614 5,835 5,624 6,778 6,778
Inventories 44,269 43,783 43,046 44,469 45,141 45,141
Prepaid expenses and other 3,623 3,511 1,941 1,441 2,224 2,224
total current assets 61,897 59,664 57,689 60,239 63,278 63,278
property and equipment net of accumulated depreciation 104,317 107,675 107,710 110,171 114,280 114,280
property under capital lease net of accum amortization 7,078 7,143 6,468 6,345 2,375 2,375
Goodwill 31,181 18,242 17,037 16,695 18,102 18,102
Other 14,822 11,798 9,921 6,131 5,455 5,455
Total assets 219,295 204,522 198,825 199,581 203,490 203,490
Liabilities and Equity
Current liabilities:
Short term borrowings 5,225 5,257 1,099 2,708 1,592 1,592
Accounts payable 47,060 46,092 41,433 38,487 38,410 38,410
Accrued liabilities and other 25,192 27,172 24,396 23,424 25,251 25,251
Total current liabilities 77,477 78,521 66,928 64,619 65,253 65,253
Long Term borrowings 43,520 30,045 36,015 38,214 40,889 40,889
deferred income taxes 11,981 8,354 9,344 7,321 8,805 8,805
other 6,683 6,780 6,003 5,816 2,606 2,606
Total noncurrent liabilities 62,184 45,179 51,362 51,351 52,300 52,300
Equity
Common stock 288 295 305 317 323 323
additional paid in capital 2,965 2,648 2,371 1,805 2,462 2,462
retained earnings 80,785 85,107 89,354 90,021 85,777 85,777
other -4,404 -7,228 -11,495 -8,532 -2,625 -2,625
total equity 79,634 80,822 80,535 83,611 85,937 85,937
total liabilities and equity 219,295 204,522 198,825 199,581 203,490 203,490

You have been assigned two companies to perform ratio analysis and horizontal and vertical analysis. Use this document to summarize your findings. You must show your work in order to get credit for the answer. Using a formula, if you put your company's financial statements on another sheet in this document, counts as showing your work.

Show your work!

2017 2016 2015 2014
walmart
target
Your analysis:

Show your work!

2017 2016 2015 2014
walmart
target
Your analysis:

Show your work!

2017 2016 2015 2014
walmart
target
Your analysis:

Show your work!

2017 2016 2015 2014
walmart
target
Your analysis:

Show your work!

2017 2016 2015 2014
walmart
target
Your analysis:

Show your work!

2017 2016 2015 2014
walmart
target
Your analysis:

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing For Managers The Ultimate Risk Management Tool

Authors: K. H. Spencer Pickett, Jennifer M. Pickett

1st Edition

0470090987, 978-0470090985

More Books

Students also viewed these Accounting questions

Question

Define the following de Broglie matter wavesterms

Answered: 1 week ago