Compute Walmart's times interest earned ratio and liability-to-debt ratio for fiscal year ended on 1/31/2019. vs....

Transcribed Image Text:

Compute Walmart's times interest earned ratio and liability-to-debt ratio for fiscal year ended on 1/31/2019. vs. Walmart Created by EDGAR Online, Inc. WALMART INC. INCOME STATEMENT Form Type: 10-K Period End: Jan 31, 2019 Date Filed: Mar 28, 2019 Table Of Contents Walmart Inc. Consolidated Statements of Income Fiscal Years Ended January 31, (Amounts in millions, except per share data) 2019 2018 2017 Revenues: Net sales 510329 495761 481317 Membership and other income Total revenues 4076 4582 4556 514405 500343 485873 Costs and expenses: Cost of sales 385301 373396 361256 Operating, selling, general and administrative expenses 107147 106510 101853 Operating income 21957 20437 22764 Interest: Debt 1975 1978 2044 Capital lease and financing obligations 371 352 323 Interest income -217 -152 -100 Interest, net 2129 2178 2267 Loss on extinguishment of debt Other (gains) and losses 3136 8368 Income before income taxes 11460 15123 20497 Provision for income taxes 4281 4600 6204 Consolidated net income 7179 10523 14293 Consolidated net income attributable to noncontrolling interest -509 -661 -650 Consolidated net income attributable to Walmart 6670 9862 13643 Net income per common share: Basic net income per common share attributable 2.28 3.29 4.4 to Walmart Diluted net income per common share 2.26 3.28 4.38 attributable to Walmart Weighted-average common shares outstanding: Basic 2929 2995 3101 Diluted 2945 3010 3112 Dividends declared per common share 2.08 2.04 Created by EDGAR Online, Inc. WALMART INC. BALANCE SHEET Form Type: 10-K Period End: Jan 31, 2019 Date Filed: Mar 2s, 2019 Table Or Contents Walmart Inc. Consolidated Balance Sheets As of January 31. (Amounts in millions) 2019 2018 ASSETS Current assets: Cash and cash equivalents Receivables, net Inventories Prepaid expenses and other Total current assets 7722 6756 6283 5614 44269 43783 3623 3511 61897 59664 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 Less accumulated amortization 1858IO 185154 -81493 -77479 104317 107675 12760 12703 -5682 -5560 Property under capital lease and financing obligations, net 7078 7143 Goodwill 31181 18242 Other long-term assets Total assets 14822 11798 219295 204522 LIABILITIES AND EQUITY Current liabilities: Short-term borrowings Accounts payable 5225 3257 47060 46092 Accrued liabilities 22159 22122 Accrued income taxes 428 645 Long-term debt due within one year 1876 3738 Capital lease and financing obligations due within one year 729 667 Total current liabilities 77477 78521 Long-term debt Long-term capital lease and financing obligations Deferred income taxes and other 43520 30045 6683 6780 11981 8354 Commitments and contingencies Equity: Common stock 288 295 Capital in excess of par value Retained earmings 2965 2648 80785 85107 Accumulated other comprehensive loss Total Walmart sharcholders' equity Noncontrolling interest Total equity -11542 -10181 72496 77869 7138 2953 79634 8O822 Total liabilities and equity 219295 204522 Compute Walmart's times interest earned ratio and liability-to-debt ratio for fiscal year ended on 1/31/2019. vs. Walmart Created by EDGAR Online, Inc. WALMART INC. INCOME STATEMENT Form Type: 10-K Period End: Jan 31, 2019 Date Filed: Mar 28, 2019 Table Of Contents Walmart Inc. Consolidated Statements of Income Fiscal Years Ended January 31, (Amounts in millions, except per share data) 2019 2018 2017 Revenues: Net sales 510329 495761 481317 Membership and other income Total revenues 4076 4582 4556 514405 500343 485873 Costs and expenses: Cost of sales 385301 373396 361256 Operating, selling, general and administrative expenses 107147 106510 101853 Operating income 21957 20437 22764 Interest: Debt 1975 1978 2044 Capital lease and financing obligations 371 352 323 Interest income -217 -152 -100 Interest, net 2129 2178 2267 Loss on extinguishment of debt Other (gains) and losses 3136 8368 Income before income taxes 11460 15123 20497 Provision for income taxes 4281 4600 6204 Consolidated net income 7179 10523 14293 Consolidated net income attributable to noncontrolling interest -509 -661 -650 Consolidated net income attributable to Walmart 6670 9862 13643 Net income per common share: Basic net income per common share attributable 2.28 3.29 4.4 to Walmart Diluted net income per common share 2.26 3.28 4.38 attributable to Walmart Weighted-average common shares outstanding: Basic 2929 2995 3101 Diluted 2945 3010 3112 Dividends declared per common share 2.08 2.04 Created by EDGAR Online, Inc. WALMART INC. BALANCE SHEET Form Type: 10-K Period End: Jan 31, 2019 Date Filed: Mar 2s, 2019 Table Or Contents Walmart Inc. Consolidated Balance Sheets As of January 31. (Amounts in millions) 2019 2018 ASSETS Current assets: Cash and cash equivalents Receivables, net Inventories Prepaid expenses and other Total current assets 7722 6756 6283 5614 44269 43783 3623 3511 61897 59664 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 Less accumulated amortization 1858IO 185154 -81493 -77479 104317 107675 12760 12703 -5682 -5560 Property under capital lease and financing obligations, net 7078 7143 Goodwill 31181 18242 Other long-term assets Total assets 14822 11798 219295 204522 LIABILITIES AND EQUITY Current liabilities: Short-term borrowings Accounts payable 5225 3257 47060 46092 Accrued liabilities 22159 22122 Accrued income taxes 428 645 Long-term debt due within one year 1876 3738 Capital lease and financing obligations due within one year 729 667 Total current liabilities 77477 78521 Long-term debt Long-term capital lease and financing obligations Deferred income taxes and other 43520 30045 6683 6780 11981 8354 Commitments and contingencies Equity: Common stock 288 295 Capital in excess of par value Retained earmings 2965 2648 80785 85107 Accumulated other comprehensive loss Total Walmart sharcholders' equity Noncontrolling interest Total equity -11542 -10181 72496 77869 7138 2953 79634 8O822 Total liabilities and equity 219295 204522

Answer rating: 100% (QA)

Answer 1 Calculate the current ratio as follows Current assets Curren... View the full answer