CLA 2 Paper & PPT - Financial Management

profilevoyage
PA1Data-Walmart.xlsx

Sheet1

Walmart Company
Consolidated balance sheet as at January 31st 2019 and 2020
2020 2019
Millions $ Millions $
(Amounts in millions) 2020 2019
ASSETS
Current assets:
Cash and cash equivalents("Basics of financial statement analysis," 2019). $9,465 $7,722
Receivables, net 6,284 6,283
Inventories 44,435 44,269
Prepaid expenses and other 1,622 3,623
Total current assets 61,806 61,897
Non current assets
Property and equipment, net 105,208 104,317
Operating lease right-of-use assets("Basics of financial statement analysis," 2019). 17,424
Finance lease right-of-use assets, net 4,417
Property under capital lease and financing obligations, net 7,078
Goodwill 31,073 31,181
Other long-term assets 16,567 14,822
Total assets 236,495 219,295
LIABILITIES AND EQUITY
Current liabilities:
Short-term borrowings $575 $5,225
Accounts payable 46,973 47,060
Accrued liabilities("Basics of financial statement analysis," 2019). 22,296 22,159
Accrued income taxes 280 428
Long-term debt due within one year 5,362 1,876
Operating lease obligations due within one year 1,793
Finance lease obligations due within one year 511
Capital lease and financing obligations due within one year 729
Total current liabilities 77,790 77,477
Long-term debt 43,714 43,520
Long-term operating lease obligations 16,171
Long-term finance lease obligations 4,307
Long-term capital lease and financing obligations ("Basics of financial statement analysis," 2019). 6,683
Deferred income taxes and other 12,961 11,981
Commitments and contingencies
Equity:
Common stock 284 288
Capital in excess of par value 3,247 2,965
Retained earnings 83,943 80,785
Accumulated other comprehensive loss -12,805 -11,542
Total Walmart shareholders' equity 74,669 72,496
Noncontrolling interest("Basics of financial statement analysis," 2019). 6,883 7,138
Total equity 81,552 79,634
Total liabilities and equity $ 236,495 219,295
Wal-mart company
Income statement for the period ending 31st January 2019 and 2020
2020 2019
(Amounts in millions, except per share data) 2020 2019
Revenues:
Net sales 519,926 510,329
Membership and other income 4,038 4,076 4,
Total revenues, 523,964 510,329
Costs and expenses:
Cost of sales 394,605 385,301
Operating, selling, general and administrative expenses 108,791 107,147
Operating income 20,568 21,957
Interest:
Debt 2,262 1,975
Finance, capital lease and financing obligations("Basics of financial statement analysis," 2019). 337 371
Interest income -189 -217
Interest, net 2,410 2,129
Loss on extinguishment of debt
Other (gains) and losses— -1,958 8,368
Income before income taxes("Basics of financial statement analysis," 2019). 20,116 11,460
Provision for income taxes 4,915 4,281
Consolidated net income 15,201 7,179
Consolidated net income attributable to noncontrolling interest -320 -509
Consolidated net income attributable to Walmart 14,881 6,670
(n.d.). 403 Forbidden. https://s2.q4cdn.com/056532643/files/doc_financials/2020/ar/Walmart_2020_Annual_Report.pdf
Basics of financial statement analysis. (2019). Financial Statements. https://doi.org/10.24053/9783739880143-73
https://s2.q4cdn.com/056532643/files/doc_financials/2020/ar/Walmart_2020_Annual_Report.pdf https://doi.org/10.24053/9783739880143-73

Sheet2

Sheet3