Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create a financial analysis for the company and both years. Consolidated Balance Sheets - USD (S) Jan. 31. 2019 Jan. 31, 2018 in Millions Current

Create a financial analysis for the company and both years.

image text in transcribedimage text in transcribed

image text in transcribed

Consolidated Balance Sheets - USD (S) Jan. 31. 2019 Jan. 31, 2018 in Millions Current assets $7,722 $6,756 Cash and cash equivalents Receivables, net 6,283 5,614 Inventories 44,269 43,783 Prepaid expenses and other Total current assets 3,623 61,897 3,511 59,664 Property and equipment: Property and equipment 185,810 185,154 (81,493) 104.317 (77,479) 107,675 Less accumulated depreciation Property and equipment, net Property under capital lease and financing obligations: Property under capital lease and financing obligations 12,760 12,703 (5,682) Less accumulated amortization (5,560) Property under capital lease and financing obligations, net Goodwill 7,078 7,143 31,181 18,242 Other long-term assets 14,822 219,295 11,798 204,522 Total assets Current liabilities: Short-term borrowings Accounts payable 5,225 5,257 47,060 46,092 Accrued liabilities 22,159 22,122 Accrued income taxes 428 645 Long-term debt due within one year 1,876 3,738 Capital lease and financing obligations due within one year 729 667 Total current liabilities 77,477 78,521 43,520 30,045 Long-term debt Long-term capital lease and financing obligations 6,683 6,780 Deferred income taxes and other 11,981 8,354 Commitments and contingencies Equity: Common stock 288 295 Capital in excess of par value Retained earnings 2,965 2,648 80,785 85,107 Accumulated other comprehensive loss Total Walmart shareholders' equity (11,542) 72,496 (10,181) 77,869 Noncontrolling interest Total equity Total liabilities and equity 7,138 2,953 79,634 80,822 $204,522 $ 219,295 Consolidated Statements of Income 12 Months Ended USD ($) shares in Millions, $ in Millions Jan. 31, 2019 Jan. 31, 2018 Jan. 31, 2017 Revenues: $ 510,329 $ 495,761 Net Sales $481,317 4.076 4,582 500,343 4,556 485,873 Membership and other income 514,405 Total revenues Costs and expenses: Cost of sales 385,301 373,396 361,256 Operating, selling, general and administrative expenses 107,147 106,510 101,853 21,957 20.437 22,764 Operating income Interest: Debt 1,975 1,978 2,044 Capital lease and financing obligations 371 352 323 (100) 2,267 Interest income (217) (152) 2,178 2,129 Interest, net Loss on extinguishment of debt 0 3,136 C C Other (gains) and losses 8,368 11.460 15,123 Income before income taxes 20,497 Provision for income taxes 4,281 4,600 6,204 Consolidated net income 7,179 10,523 14,293 Consolidated net income attributable to noncontrolling interest (509) (661) (650) Consolidated net income attributable to $ 13,643 $6,670 $9,862 Walmart Net income per common share: Basic net income per common share attributable to Walmart $2.28 $3.29 $4.40 Diluted net income per common share attributable to Walmart $ 2.26 $3.28 $4.38 Weighted-average common shares outstanding: Basic 2.929 2,995 3,101 Diluted 2,945 3,010 3,112 $ 2.08 $ 2.04 Dividends declared per common share $2.00 For Balance Sheet references that require an "average" level use the prior & current end-of year balances. Percentage Change from Year 2 Numerical Change (Yr3 - Yr2) Comment (Elaborate on the data in your own words) YEAR 3 Liquidity Ratios YEAR 2 (Yr3-Yr2) divided by Yr2 Current Ratio Receivables Turnover Inventory Turnover Days-Sales-in Inventory Percentage Change from Year 2 Numerical Comment ProfitabilityYEAR 2 (Yr3-Yr2)(Elaborate on the divided by Change (Yr3-Yr2) YEAR 3 data in your own Ratios words) Yr2 Profit Margin Earnings per Share Price earnings Ratio Please show your computations here: COMPUTE THESE RATIOS AND ADD YOUR OWN COMMENTS

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

Fundamentals of Cost Accounting

Authors: William Lanen, Shannon Anderson, Michael Maher

4th edition

78025524, 978-0078025525

More Books

Students also viewed these Accounting questions