Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

cells in yellow MUST be a formula. please give the formula/cells used D E F Jan. 31, 2017 0 0 0 0 $6,867 5,835 43,046

cells in yellow MUST be a formula. please give the formula/cells used image text in transcribed
image text in transcribed
D E F Jan. 31, 2017 0 0 0 0 $6,867 5,835 43,046 1,941 57,689 0 0 0 0 179,492 (71,782) 107,710 A B 1 Walmart Balance Sheet Verticle Analysis 2 Consolidated Balance Sheets - USD ($) Jan. 31, 2018 3 Current assets: 4 Cash and cash equivalents $ 6,756 5 Receivables, net 5,614 6 Inventories 43,783 7 Prepaid expenses and other 3,511 8 Total current assets 59,664 9 Property and equipment: 10 Property and equipment 185,154 11 Less accumulated depreciation (77,479) 12 Property and equipment, net 107,675 13 Property under capital lease and 14 Property under capital lease and 12,703 15 Less accumulated amortization (5,560) 16 Property under capital lease and 7,143 17 Goodwill 18,242 18 Other assets and deferred charges 11,798 19 Total assets 204,522 20 Current liabilities: 21 Short-term borrowings 5,257 22 Accounts payable 46,092 23 Accrued liabilities 22,122 24 Accrued income taxes 645 25 Long-term debt due within one year 3,738 26 Capital lease and financing obligations 667 27 Total current liabilities 78,521 28 Long-term debt 30,045 29 Long-term capital lease and financing 6,780 30 Deferred income taxes and other 8,354 0 0 0 0 11,637 (5,169) 6,468 17,037 9,921 198,825 0 OOOOOOOOOO 1,099 41,433 20,654 921 2,256 565 66,928 36,015 6,003 9,344 B D E F 30,045 6,780 8,354 0 0 0 36,015 6,003 9,344 A 28 Long-term debt 29 Long-term capital lease and financing 30 Deferred income taxes and other 31 Commitments and contingencies 32 Equity: 33 Common stock 34 Capital in excess of par value 35 Retained earnings 36 Accumulated other comprehensive loss 37 Total Walmart shareholders' equity 38 Noncontrolling interest 39 Total equity 40 Total liabilities and equity 41 42 295 2,648 85,107 (10,181) 77,869 2,953 80,822 $ 204,522 OOOOOOOO 305 2,371 89,354 (14,232) 77,798 2,737 80,535 $ 198,825 0

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

Message Brand And Dollars Auditing Marketing Operations

Authors: J. Mike Jacka, Peter R. Scott

1st Edition

163454000X, 9781634540001

More Books

Students also viewed these Accounting questions

Question

What information is relevant to solve this problem and why?

Answered: 1 week ago