Answered step by step
Verified Expert Solution
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
*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
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