Question
complete the excel sheet that has ratios for Walmart based on the financial statements Calculation Results Current ratio Accounts receivable turnover Average collection period Inventory
complete the excel sheet that has ratios for Walmart based on the financial statements
| Calculation | Results |
Current ratio |
|
|
Accounts receivable turnover |
|
|
Average collection period |
|
|
Inventory turnover |
|
|
Days in inventory |
|
|
Profit margin |
|
|
Asset turnover |
|
|
Return on assets |
|
|
Return on common stockholder's equity |
|
|
Debt to total assets ratio |
|
|
Times interest earned |
|
|
Free cash flow |
|
|
Current ratio |
|
|
Walmart Inc.
Consolidated Statements of Income
Fiscal Years Ended January 31,
(Amounts in millions, except per share data) 2022 2021 2020
Revenues:
Net sales $ 567,762 $ 555,233 $ 519,926
Membership and other income 4,992 3,918 4,038
Total revenues 572,754 559,151 523,964
Costs and expenses:
Cost of sales 429,000 420,315 394,605
Operating, selling, general and administrative expenses 117,812 116,288 108,791
Operating income 25,942 22,548 20,568
Interest:
Debt 1,674 1,976 2,262
Finance lease 320 339 337
Interest income (158) (121) (189)
Interest, net 1,836 2,194 2,410
Loss on extinguishment of debt 2,410
Other (gains) and losses 3,000 (210) (1,958)
Income before income taxes 18,696 20,564 20,116
Provision for income taxes 4,756 6,858 4,915
Consolidated net income 13,940 13,706 15,201
Consolidated net income attributable to noncontrolling interest (267) (196) (320)
Consolidated net income attributable to Walmart $ 13,673 $ 13,510 $ 14,881
Net income per common share:
Basic net income per common share attributable to Walmart $ 4.90 $ 4.77 $ 5.22
Diluted net income per common share attributable to Walmart 4.87 4.75 5.19
Weighted-average common shares outstanding:
Basic 2,792 2,831 2,850
Diluted 2,805 2,847 2,868
Dividends declared per common share $ 2.20 $ 2.16 $ 2.12
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