Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

*Could you help me complete the vertical analysis for each year, and could you include the formulas so I understand the calculations? Walmart Inc. Consolidated

image text in transcribedimage text in transcribed*Could you help me complete the vertical analysis for each year, and could you include the formulas so I understand the calculations?

Walmart Inc. Consolidated Balance Sheet As of January 31, 2021, January 31, 2020, January 31, 2019 (In Millions, Except per Share Amounts) Fiscal Years End January 31 January 31, 2021 January 31, 2020 January 31, 2019 $ Assets Current Assets: Cash and Cash Equivalents Receivable, Net Inventories Prepaid Expenses and Other Total Current Asstes 17,741 $ 6,516 44,949 20,861 90,067 9,465 $ 6,284 44,435 1,622 61,806 7,722 6,283 44,269 3,623 61,897 104,317 92,201 13,642 4,005 105,208 17,424 4,417 Property and Equipment, Net Operating Lease Right-Of-Use Assets Finance Lease Right-Of-Use Assets, Net Property Under Capital Lease and Financing Obligations, Net Goodwill Other Long Term Assets Total Assets 28,983 23,598 252,49 $ 31,073 16,567 236,495 7,078 31,181 14,822 219,295 $ $ $ $ Liabilities and Equity Current Liabilities: Short Term Borrowings Accounts Payable Accrued Liabilities Accrued Income Taxes Long-Term Debt Due Without One Year Operating Lease Obligations Due Within One Year Financing Lease Obligations Due Within One Year Capital Lease and Financing Obligations due Within One Year Total Current Liabilities 224 $ 49,141 37,966 242 3,115 575 46,973 22,296 280 5,362 1,793 511 5,225 47,060 22,159 428 1,876 1,466 491 ---- ---- 729 77,477 92,645 77,790 43,520 Long Term Debt Long-Term Operating Lease Obligations Long-Term Finances Lease Obligations Long-Term Capital Lease and Financing Obligations Deferred Income Taxes and Other 41,194 12,909 3,847 43,714 16,171 4,307 6,683 11,981 14,370 12,961 Commitments and Contingencies Equity: Common Stock Capital in Excess of Par Value Retained Earnings Accumulated Other Comprehensive Losee Total Walmart Shareholders' Equity Nonconrtolling Interest Total Equity Total Liabilities and Equity 282 3,646 88,763 (11,766) 80,925 6,606 87,531 252,496 $ 284 3,247 83,943 (12,805) 74,669 6,883 81,552 236,495 $ 288 2,965 80,785 (11,542) 72,496 7,138 79,634 219,295 $

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

Beyond Agile Auditing Three Core Components To Revolutionize Your Internal Audit Practices

Authors: Clarissa Lucas

1st Edition

1950508676, 978-1950508679

More Books

Students also viewed these Accounting questions

Question

Explain how labour relations practices differ around the world.

Answered: 1 week ago