Question: Develop common size financials for Walmart for the last 3 years. For that same period, compute for Walmart the ratios such as Liquidity ratios; Solvency

Develop common size financials for Walmart for the last 3 years. For that same period, compute for Walmart the ratios such as Liquidity ratios; Solvency ratios; Activity ratios & Profitability ratios.

  • Given these data, which financial statement items do you believe should have been of particular interest to the auditor in the current year audit.
  • Give 5 examples and rationale of why it is of particular interest.

can use this link : https://d18rn0p25nwr6d.cloudfront.net/CIK-0000104169/598c8825-536a-4371-ab8a-98b9ee761c43.pdf

Consolidated Statements of Income - USD ($) 12 Months Ended
shares in Millions, $ in Millions
Jan. 31, 2021 Jan. 31, 2020 Jan. 31, 2019
Revenues:
Net sales $555,233 $519,926 $510,329
Membership and other income 3,918 4,038 4,076
Total revenues 559,151 523,964 514,405
Costs and expenses:
Cost of sales 420,315 394,605 385,301
Operating, selling, general and administrative expenses 116,288 108,791 107,147
Operating income 22,548 20,568 21,957
Interest:
Debt 1,976 2,262 1,975
Finance, capital lease and financing obligations 339 337 371
Interest income -121 -189 -217
Interest, net 2,194 2,410 2,129
Other (gains) and losses -210 -1,958 8,368
Income before income taxes 20,564 20,116 11,460
Provision for income taxes 6,858 4,915 4,281
Consolidated net income 13,706 15,201 7,179
Consolidated net income attributable to noncontrolling interest -196 -320 -509
Consolidated net income attributable to Walmart $13,510 $14,881 $6,670
Net income per common share:
Basic net income per common share attributable to Walmart (in USD per share) $4.77 $5.22 $2.28
Diluted net income per common share attributable to Walmart (in USD per share) $4.75 $5.19 $2.26
Weighted-average common shares outstanding:
Basic (in shares) 2,831 2,850 2,929
Diluted (in shares) 2,847 2,868 2,945
Dividends declared per common share (in USD per share) $2.16 $2.12 $2.08
Consolidated Balance Sheets - USD ($) Jan. 31, 2021 Jan. 31, 2020 Jan. 31, 2019
$ in Millions
Current assets:
Cash and cash equivalents $17,741 $9,465 $7,722
Receivables, net 6,516 6,284 6,283
Inventories 44,949 44,435 44,269
Prepaid expenses and other 20,861 1,622 3,623
Total current assets 90,067 61,806 61,897
Property and equipment, net 92,201 105,208 104,317
Operating lease right-of-use assets 13,642 17,424 0
Finance lease right-of-use assets, net 4,005 4,417 0
Property under capital lease and financing obligations, net 0 7,078
Goodwill 28,983 31,073 31,181
Other long-term assets 23,598 16,567 14,822
Total assets 252,496 236,495 219,295
Current liabilities:
Short-term borrowings 224 575 5,225
Accounts payable 49,141 46,973 47,060
Accrued liabilities 37,966 22,296 22,159
Accrued income taxes 242 280 428
Long-term debt due within one year 3,115 5,362 1,876
Operating lease obligations due within one year 1,466 1,793 0
Finance lease obligations due within one year 491 511 0
Capital lease and fiancing obligations due within one year 0 729
Total current liabilities 92,645 77,790 77,477
Long-term debt 41,194 43,714 43,520
Long-term operating lease obligations 12,909 16,171 0
Long-term finance lease obligations 3,847 4,307 0
long term capital lease and fianciang obligations 6,683
Deferred income taxes and other 14,370 12,961 11,981
Commitments and contingencies
Equity:
Common stock 282 284 288
Capital in excess of par value 3,646 3,247 2,965
Retained earnings 88,763 83,943 80,785
Accumulated other comprehensive loss -11,766 -12,805 -11,542
Total Walmart shareholders' equity 80,925 74,669 72,496
Noncontrolling interest 6,606 6,883 7,138
Total equity 87,531 81,552 79,634
Total liabilities and equity $252,496 $236,495 $219,295

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!