80.2K

Verified Solution

Link Copied!

Given the income statement and balance sheet for Walmart use it to calculate:

1. Debt to Assets

2. Cash Debt Coverage

3. Times Interest Earned

4. Return on Assets

5. Return on Equity

6. Gross Profit Rate

7. Profit Margin

Calculate it for the years 2018 and 2019.

Walmart Inc. Consolidated Statements of Income Fiscal Years Ended January 31, (Amounts in millions, except per share data) 2019 2018 2017 Revenues: 510,329 $ 4,076 Net sales 495,761 $ 481,317 Membership and other income 4,582 4,556 500,343 Total revenues 514,405 485,873 Costs and expenses: Cost of sales 385,301 373,396 361,256 Operating, selling, general and administrative 107,147 106,510 101,853 expenses 20,437 Operating income 21,957 22,764 Interest: Debt 1,975 1,978 2,044 Capital lease and financing obligations 371 352 323 (100) 2,267 (152) Interest income (217) Interest, net Loss on extinguishment of debt Other (gains) and losses Income before income taxes 2,129 2,178 3,136 8,368 20,497 6,204 14,293 11,460 4,281 7,179 15,123 4,600 Provision for income taxes Consolidated net income 10,523 Consolidated net income attributable to (509) 6,670 $ (661) 9,862 $ (650) 13,643 noncontrolling interest Consolidated net income attributable to Walmart 2$ Net income per common share: Basic net income per common share attributable 2.28 $ 2$ 3.29 $ 4.40 to Walmart Diluted net income per common share attributable to Walmart 2.26 3.28 4.38 Weighted-average common shares outstanding: Basic 2,929 2,945 2,995 3,010 3,101 3,112 Diluted Dividends declared per common share 2$ 2.08 $ 2.04 $ 2.00 %24 Walmart Inc. Consolidated Balance Sheets As of January 31, (Amounts in millions) 2019 2018 ASSETS Current assets: Cash and cash equivalents 7,722 $ 6,756 Receivables, net 6,283 5,614 Inventories 44,269 43,783 Prepaid expenses and other 3,623 3,511 59,664 Total current assets 61,897 Property and equipment: Property and equipment Less accumulated depreciation Property and equipment, net Property under capital lease and financing obligations: Property under capital lease and financing obligations 185,810 185,154 (81,493) 104,317 (77,479) 107,675 12,760 12,703 (5,560) Less accumulated amortization (5,682) Property under capital lease and financing obligations, net 7,078 7,143 Goodwill 31,181 18,242 11,798 204,522 Other long-tem assets Total assets 14,822 219,295 $ LIABILITIES AND EQUITY Current liabilities: Short-term borowings Accounts payable 2$ 5,225 $ 47,060 22,159 5,257 46,092 22,122 Accrued liabilities Accrued income taxes 428 645 1,876 3,738 Long-tem debt due within one year Capital lease and financing obligations due within one year Total current liabilities 729 667 78,521 77,477 43,520 6,683 11,981 30,045 6,780 8,354 Long-tem debt Long-tem capital lease and financing obligations Deferred income taxes and other Commitments and contingencies Equity: Common stock 288 295 Capital in excess of par value Retained eamings Accumulated other comprehensive loss Total Walmart shareholders' equity Noncontrolling interest Total equity Total liabilities and equity 2,965 80,785 2,648 85,107 (11,542) 72,496 7,138 79,634 219,295 $ (10,181) 77,869 2,953 80,822 204,522 %24 %24 Walmart Inc. Consolidated Statements of Income Fiscal Years Ended January 31, (Amounts in millions, except per share data) 2019 2018 2017 Revenues: 510,329 $ 4,076 Net sales 495,761 $ 481,317 Membership and other income 4,582 4,556 500,343 Total revenues 514,405 485,873 Costs and expenses: Cost of sales 385,301 373,396 361,256 Operating, selling, general and administrative 107,147 106,510 101,853 expenses 20,437 Operating income 21,957 22,764 Interest: Debt 1,975 1,978 2,044 Capital lease and financing obligations 371 352 323 (100) 2,267 (152) Interest income (217) Interest, net Loss on extinguishment of debt Other (gains) and losses Income before income taxes 2,129 2,178 3,136 8,368 20,497 6,204 14,293 11,460 4,281 7,179 15,123 4,600 Provision for income taxes Consolidated net income 10,523 Consolidated net income attributable to (509) 6,670 $ (661) 9,862 $ (650) 13,643 noncontrolling interest Consolidated net income attributable to Walmart 2$ Net income per common share: Basic net income per common share attributable 2.28 $ 2$ 3.29 $ 4.40 to Walmart Diluted net income per common share attributable to Walmart 2.26 3.28 4.38 Weighted-average common shares outstanding: Basic 2,929 2,945 2,995 3,010 3,101 3,112 Diluted Dividends declared per common share 2$ 2.08 $ 2.04 $ 2.00 %24 Walmart Inc. Consolidated Balance Sheets As of January 31, (Amounts in millions) 2019 2018 ASSETS Current assets: Cash and cash equivalents 7,722 $ 6,756 Receivables, net 6,283 5,614 Inventories 44,269 43,783 Prepaid expenses and other 3,623 3,511 59,664 Total current assets 61,897 Property and equipment: Property and equipment Less accumulated depreciation Property and equipment, net Property under capital lease and financing obligations: Property under capital lease and financing obligations 185,810 185,154 (81,493) 104,317 (77,479) 107,675 12,760 12,703 (5,560) Less accumulated amortization (5,682) Property under capital lease and financing obligations, net 7,078 7,143 Goodwill 31,181 18,242 11,798 204,522 Other long-tem assets Total assets 14,822 219,295 $ LIABILITIES AND EQUITY Current liabilities: Short-term borowings Accounts payable 2$ 5,225 $ 47,060 22,159 5,257 46,092 22,122 Accrued liabilities Accrued income taxes 428 645 1,876 3,738 Long-tem debt due within one year Capital lease and financing obligations due within one year Total current liabilities 729 667 78,521 77,477 43,520 6,683 11,981 30,045 6,780 8,354 Long-tem debt Long-tem capital lease and financing obligations Deferred income taxes and other Commitments and contingencies Equity: Common stock 288 295 Capital in excess of par value Retained eamings Accumulated other comprehensive loss Total Walmart shareholders' equity Noncontrolling interest Total equity Total liabilities and equity 2,965 80,785 2,648 85,107 (11,542) 72,496 7,138 79,634 219,295 $ (10,181) 77,869 2,953 80,822 204,522 %24 %24

Answer & Explanation Solved by verified expert

See Answer