Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I was having trouble solving these. I've attached the questions as the first two and the information needed later Use Walmart Corporation's financial statements to

image text in transcribed

image text in transcribed

I was having trouble solving these. I've attached the questions as the first two and the information needed later

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

Use Walmart Corporation's financial statements to compute the following ratios for 2017 and 2016 and answer questions regarding the meaning of the ratios You must write the formula and show your computation to get full credit. 2017 Calculation 2016 Calculation Example of full credit answer Working Capital CA CL 57,689 CA CL 60,239 64,619 66,928 9,239 -4,859 Working capital decreased Formula Current assets- current liabilities WC WC 4,380 Did working capital increase or decrease from 2016 to 20172 Current Ratio Formula Did the company's ability to meet short term obligations improve or decline from 2016 to 2017 Inventory Turnover Formula Did inventory turnover improve from 2016 to 2017? Days in Inventory Formula Did days in inventory improve or decline from 2016 to 2017? Acc 211 FA33O-Project 2 50 points Use Walmart Corporation's financial statements to compute the following ratios for 2017 and 2016 and answer questions regardin meaning of the ratios. You must write the formula and show your computation to get full credit. 2017 Calculation 2016 Calculation Accounts Receivable Turnover Formula Did accounts receivable turnover improve from 2016 to 2017? Average Collection Period Formula Did the average collection period improve or decline from 2016 to 2017? Debt to Asset Ratio Formula Did the company's ability to meet long-term obligations improve or decline from 2016 to 2017 Times Interest Earned Formula Did the company's ability to pay interest on debt improve or decline from 2016 to 2017? Riscal Years Ended January 3 Amouns inmilionexcet per shore dotal Revenues 016 $481,317$478614 $482,229 485,873 482,130 485,651 361,256 360.984 365,086 2017 2015 Net sales Membership and other income 4,556 3516 3,422 Total revenues Costs and expenses Cost of sales Operating seling general and administrative expenses 97041 93,418 27,147 101,853 Operating income Interest 22,764 24105 2027 2,16 2,044 323 100) Capital lease and financing obligations 300 (113) 2,348 24,799 7,985 16,814 285 14,293 15,080 17099 (736) 13,643 $ 14,694 16363 521 (811 nterest income 2,267 2,467 20,497 21,638 6558 Interest, net Income from continuing operations before income taxes Provision for income taxes Income from continuing operations Income from discontinued operations, net of income taxes Consolidated net income Consolidated net income attributable to noncontrolling interest Consolidated net income attributable to Walmart 6,204 14,29315,00 (650) 386) Basic net income per common share Basic income per common share from continuing operations attributable to Walmart Basic income per common share from $ 4.40 458 501 006 operations attributable to Walmart $ 4.40 458507 Basic net income per common share attributable to Walmart Diluted net income per common share Diluted income per common share from continuing operations attributable to Walmat s 438 457 49 Diluted income per common share from discontinued operations attributable to Walmart Diluted net income per common share attributable to Walmart Weighted-average common shares outstanding: 006 4.38 457 S5.05 3,230 3,243 2.00 $ 196 5 192 3,101 3,112 3,207 3,217 Basic Dividends declared per common share Consolidated Statements of Shareholders' Equity and Redeemable Noncontrolling Interest Accumulated To Capital in WalmarNonredeemable Common Stock Escess of Retained Compreheniv Shaveholdens NoncontrollingTNoncontioling Shares Amount ParValueEamings Amounts in maliona) Equty Equity ine Balances as of February 1, 2014 3.233 $323 $2362 $76,566 $ (2.996 $76255 5,084 $81,339 $1491 Consolidated net income 6.363 14,172) 4.172 6,185) 736 17,099 1546) 4718) 6.185 16,363 Other comprehensive loss, net of income taxes Cash dividends declared (5 1.92 per share) Purchase of redeemable Other Balances as of January 31, 2015 6,185 (13) ) 9 950) Purchase of Company stock (980) 1491) noncontrolling interest 1618) 85,937 15,080 1 129 117) 4543 386 2.462 85777 14.694 681.81394 14.694 3228 323 Consolidated net income Other comprehensive loss, net of income taxes 14429) (541) (4,429) - Cash dividends declared (6 294) (102) (4,148) 6294) 4,256) (S1 96 per share) Cash dividend declared to Other Balances as of January 31,2016 Purchase of Company stock (65) (4256) (691) 1691) 1632) (1,195) 83,611 650 14,293 noncontrolling interest 555) (563) 3,162 317 1805 90,021 (11,597) 80.546 3,065 13,643 (2,635) (6,216) 13,643 Consolidated net income Other comprehensive loss, net of income taxes (2,635) (210) (2,845) Cash dividends declared ($2.00 per share) (6,216) (6,216) (8,090) (8,276) (8,276) (120) (12) (174) Purchase of Company stock Cash dividend declared to (519) (519) (249) noncontrolling interest 487 736 740 Balances as of January 31,2017 3,048 5305 $2.371 89,354 $(14,232) 77,798 2.737 See accompanying utes $77,798 $2,737 $80,535 Consolidated Balance Sheets As of unuary 3 Anounts in imionu ASSETS Current dssets 17 306 2013 Cash and cash equivaients Recevables, net 6867 805 9135 5,835 43,046 44,4604519 47 2 224 s624 Prepaid expenies and oher Total current assets Property and equipment 57,689 60239373S 179,49276,958 71,7821 06787) Property and equipment Property and equpment, net Psoperty under capital ease and financng oblgations 107,710 110121H4.28o Property under cepital lease and fnancing oblgations Less accumulated amortization 11,637 5,169) 6,468 17,037 9.921 11,096 14,751 Property under capital lease and financing obligsions,net 2.375 120171Rus 35 Other nsels and delered charges 6.131 5198.825 $199581349 LIABILITIES AND EQUITY Cument Nabiles s1,099 2.708 Short-term bomowings Accounts payable Accrued labiliies Accrued income tawe Long-term debs due within one year Capital lease and financing obligations due within one year 41433 20,654 921 2,256 565 38,487 9,807 52) 2745 551 66,928 64519 63 Total current liabilities Long-term det Long-term capital lease and francing abligations Deferred income taves and other 36,015 3214 yo,s89 6,003 5816 9.344 7321 s, 9 Commitments and coringencie Equity Common srock Capital in excess of par value Retained earnings Accumulated other comprehensive loss 305 2,371 323 89,354 90021 5 777 (14232) (1159) 1es Tetal Walmart shareholders' equity 77,798 00,546 8,35 2,737 3065 5y3 Nonredeemable noncontrolling interest Total equity Total liabilities and equity 80535 83611 6937 5198.825 $199 581 3,4 Frcal Years Ended lanuary 3T Amounts in miion Cash flows from operating activities: Consolidated net income Income from discontinued operations, net of income taxes ncome from continuing operations Adjustments to reconcle income from continuing operations to net cash $ 14,293$15,080 $17099 285) 14293 014814 provided by operating activities Depreciation and amortization Deferred income taxes 10,080 761 206 9454 (672) 1410 G0) 785 Other operating activities Receivables net Accounts payable Changes in certain assets and Sablities, net of effects of acquisitions (19) (703)11,229 1249 31,53027,38928,564 1,021 3,942 1,137 492 2,008 1,303 4721 Accrued labilities Accrued income taxes Net cash provided by operating actiities Cash flows from investing activities: Payments for property and equpment Proceeds from the disposal of property and equipment Proceeds from the disposal of certain operations Puechase of available for sale securities Investment and business acquisitions, net of cash acqured Other nvesting activities (10.619)(A(12,174) 570 635 662 1.901) 2,463 122) Ner cash used in investing activites (13,987) 00675) (01125) Cash flows from financing activities Net change thort-term borrowings Proceeds from asiance of long-term debr Paymets of long-tern debt Dividends pald Purchase of Company shock Dividends paid to noncontrolling interest Purchase of noncontroling interest Other financing activities 1,673)1,2356,288) 137 5,174 12.055) (4432) 3904) 6216) 624 18 (8.298) 4112 (1015) 479) 190) 11326)11,844) (18,929) (16122) (35071) Net cash used in fnancing activities Effect of exchange rates on cash and cash equivalents Net increase ldecrease) in cash and cash equivalents (452) (1.022 1,838) 8,705 1.854 Cash and cash equivalents at beginning of year Cash and cash equivalents at end of year Supplemental disclosure of cash flow information 9,135 6,8678,305 9135 rcome tases paid nterest pad 4,507 2,351 8111 2540 ,169 2433

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

Accounting Principles Volume 1

Authors: Jerry A. Weygandt, Paul D. Kimmel, Donald E. Kieso

11th Edition

1118751752, 978-1118751756

More Books

Students also viewed these Accounting questions