Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started