Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Financial statements are a crucial part to identifying a company's financial situation. Given the ratios below, how would you describe WalMart's financial situation? LIQUIDITY RATIOS

Financial statements are a crucial part to identifying a company's financial situation. Given the ratios below, how would you describe WalMart's financial situation?

image text in transcribed
LIQUIDITY RATIOS Amounts in Millions (except per share dat=] Amounts in Millions (except per share data] Amounts from 2021 Amounts from 202 Name of Ratio Formula Financial Statements 2021 Ratio Financial Statements 2020 Rutic Current Ratio Current Assets 80.067 100 Times 81,805 Current Liabilities 92,649 77,790 0.80 Times Cash Ratio Cash and Cash Equivalent 17,741 Current Liabilities 92,649 0.20 Times 9,453 77,790 0.10 Times Quick Ratio Current Assets - Inventor 90.057 44,949 51,806 92,649 050 Times 44,435 Current Liabilities 77,790 0.20 Times ASSET MANAGEMENT RATIOS Amounts in Millions (except per share data] Amounts in Millions (except per share data] Amounts from 2021 Amounts from 2020 Name of Ratio Formula Financial Statements 2021 Ratio Financial Statements 2020 Rutic Inventory Turnover Cost of Sales 420 315 354,605 Inventory 44 949 9.35 Times 44,435 3.88 Times Days Sales in Inventory 39.04 Days 353 Inventory Turnover 935 8.85 41 10 Days Receivables Turnover Net Sales (assume all sales on credit 553 23 3 319,925 Receivables, Net 8516 :3.21 Times 3.284 82.74 Times 365 Average Collection Period 383 Receivables Turnover 85 21 4.30 Days 353 32.74 4.40 Days Accounts Payable Turnover Cost of Sales 420,315 194, 605 Accounts Payable 49,141 8.50 Times 46,973 8.40 Times Average Payment Period 365 353 Accounts Payable Turnover 8.30 42.90 Days 8.4 43.40 Days Fixed Asset Turnover Total Revenue 359,151 Net Filed Assets reed note below 162,429 3.40 Times 323,954 174,689 3.00 Times sales to Working Capital Total Revenue 723,954 Net Working Capital [2.578] -217.00 Times 19.984] -32.80 Times Total Asset Turnover Total Revenue 323,954 Total Assets 252 496 2.20 Times 236,495 2.20 Times Capital Intensity Totell Assets 252.496 0.45 Times 236,495 Total Revenue 359,151 328,954 0.45 Times Note: net fixed assets indude all assets except current assets. DEBT MANAGEMENT RATIOS Amounts in Millions (except per share date] Amounts in Millions (except per share data] Amounts from 2021 Name of Ratio Amounts from 2020 Formula Financial Statements 2021 Ratio Financial Statements 2020 Ratio Debt Ratio Total Liebilities 92 645 Totell Assets 52 496 36. 70%% 71,790 136,495 32.89% Debt-to-Equity Ratio Total Liabilities 92 649 105 84 77,790 Total Equity 87,534 81,532 95 395 Equity Multiplie Totell Assets 52 498 2.90 Times 36,493 Total Equity 1,552 290 Times Times Interest Earned " Net Income + Interest Expense + Income Tax Expense 13 510 2.184 6.813 10.28 Times 14,881 2,410 4,915 Interest Expense 2 194 2,410 9.21 Times Cash Coverage EBIT + Depreciation and Amortization Expense ." 22 549 11 152 10.987 Interest Expense assume no other fixed charges 2 194 5.36 Times 20,968 2,410 13.10 Times "The Interest asper Wal Mart does not repor anse on the face of its Incom count can be found on the stint ment ofcuh flows. PROFITABILITY RATIOS Amounts in Millions (except per share date] Amounts in Millions (except per share data] Amounts from 202 Amounts from 2020 Name of Rutic Formula Financial Statements 2021 Ratio Financial Statements 2020 Ratio Gross Profit Margin Net Sales - Cost of Sales 355,283 420 315 24 30% 319,926 354,605 Net Sales 355 233 2410% 119,928 Operating Profit Margin #1 Net Income + Interest Expense + Income Tax Expense 13.706 2.184 6.808 Net Sales 4.10%% 15,201 2 410 4,915 55 233 4.30% 919,925 Profit Margin 3) Net Income 13,70 15,201 Total Revenue 2.401% 3.00% Basic Earnings Power?) Net Income + Interest Expense + Income Tax Expense 13 706 2.194 6.898 15 201 2410 4915 Totell Assets 252.496 9.90%% 236,495 Return on Assets #1 Net Income 13.70 15,20 Totell Accent 5.40%% 252 496 5.40% 236,495 Fleturn on Equity Net Income 13.706 Total Equity 15.65% 15,201 1,552 Dividend Fayout Dividends Declared per Share 2 16 2.12 Jet Income per Share (diluted] 4.73 45.47%% 4.19 90.60% MARKET VALUE RATIOS Amounts in Millions (except per share dat=] Amounts in Millions (except per share data] Amounts from 2021 Name of Ratio Formula Financial Statements 2021 Ratio Amounts from 2020 2020 Ratio Market-to-Book Value Market Price per Share (at Jan. 31] S 138.83 per Share Total equity / Total Common shares outstanding at year-and | $ 87 531] 4.47 Times 411.29 2 821 $ 81,392 2.832 3.86 Times

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

A Survey of Mathematics with Applications

Authors: Allen R. Angel, Christine D. Abbott, Dennis Runde

10th edition

134112105, 134112342, 9780134112343, 9780134112268, 134112261, 978-0134112107

Students also viewed these Accounting questions

Question

=+c) Compare your forecast to the actual value (by computing APE).

Answered: 1 week ago