Question
Walmart Income Statement For the year ended January 31, 2018 Walmart Income Statement For the year ended January 31, 2017 Details 2018 Details 2017 $
Walmart Income Statement For the year ended January 31, 2018 |
|
| Walmart Income Statement For the year ended January 31, 2017 |
|
|
Details | 2018 |
| Details | 2017 |
|
| $ |
|
| $ |
|
Total Revenue | $500,343,000 |
| Total Revenue | $485,873,000 |
|
Cost of Revenue | $373,396,000 |
| Cost of Revenue | $361,256,000 |
|
Gross Profit | $126,947,000 |
| Gross Profit | $124,617,000 |
|
Sales, General and Admin. | $106,510,000 |
| Sales, General and Admin. | $101,853,000 |
|
Operating Income | $20,437,000 |
| Operating Income | $22,764,000 |
|
Addl income/expense items | ($2,984,000) |
| Addl income/expense items | $100,000 |
|
Earnings Before Interest and Tax | $17,453,000 |
| Earnings Before Interest and Tax | $22,864,000 |
|
Interest Expense | $2,330,000 |
| Interest Expense | $2,367,000 |
|
Earnings Before Tax | $15,123,000 |
| Earnings Before Tax | $20,497,000 |
|
Income Tax | $4,600,000 |
| Income Tax | $6,204,000 |
|
Minority Interest | ($661,000) |
| Minority Interest | ($650,000) |
|
Net Income-Cont. Operations | $9,862,000 |
| Net Income-Cont. Operations | $13,643,000 |
|
Net Income- | $9,862,000 |
| Net Income- | $13,643,000 |
|
Net Income-Applicable to Common Shareholders | $9,862,000 |
| Net Income-Applicable to Common Shareholders | $13,643,000 |
|
Target Income Statement For the year ended February 23, 2018 |
|
| Target Income Statement For the year ended January 28, 2017 |
|
|
Details | 2018 |
| Details | 2017 |
|
| $ |
|
| $ |
|
Total Revenue | $71,879,000 |
| Total Revenue | $69,495,000 |
|
Cost of Revenue | $51,125,000 |
| Cost of Revenue | $49,145,000 |
|
Gross Profit | $20,754,000 |
| Gross Profit | $20,350,000 |
|
Sales, General and Admin. | $14,248,000 |
| Sales, General and Admin. | $13,356,000 |
|
Other Operating Items | $2,194,000 |
| Other Operating Items | $2,025,000 |
|
Operating Income | $4,312,000 |
| Operating Income | $4,969,000 |
|
Addl income/expense items | 0 |
| Addl income/expense items | 0 |
|
Earnings Before Interest and Tax | $4,312,000 |
| Earnings Before Interest and Tax | $4,969,000 |
|
Interest Expense | $666,000 |
| Interest Expense | $1,004,000 |
|
Earnings Before Tax | $3,646,000 |
| Earnings Before Tax | $3,965,000 |
|
Income Tax | $718,000 |
| Income Tax | $1,296,000 |
|
Minority Interest | 0 |
| Minority Interest | 0 |
|
Net Income-Cont. Operations | $2,928,000 |
| Net Income-Cont. Operations | $2,669,000 |
|
Net Income | $2,934,000 |
| Net Income | $2,737,000 |
|
Net Income-Applicable to Common Shareholders | $2,934,000 |
| Net Income- | $2,737,000 |
|
Target Balance Sheet For the year ended February 3, 2018 |
|
| Target Balance Sheet For the year ended January 28, 2017 |
| Target Balance Sheet For the year ended January 30, 2016 |
|
Details | 2018 |
| Details | 2017 | Details | 2016 |
| $ |
|
| $ |
| $ |
Cash and Cash Equivalents | $2,643,000 |
| Cash and Cash Equivalents | $2,512,000 | Cash and Cash Equivalents | $4,046,000 |
Short-Term Investments | 0 |
| Short-Term Investments | 0 | Short-Term Investments | 0 |
Net Receivables | 0 |
| Net Receivables | 0 | Net Receivables | 0 |
Inventory | $8,657,000 |
| Inventory | $8,309,000 | Inventory | $8,601,000 |
Other Current Assets | $1,264,000 |
| Other Current Assets | $1,169,000 | Other Current Assets | $1,483,000 |
Total Current Assets | $12,564,000 |
| Total Current Assets | $11,990,000 | Total Current Assets | $14,130,000 |
Long-Term Investments | 0 |
| Long-Term Investments | 0 | Long-Term Investments | 0 |
Fixed Assets | $25,018,000 |
| Fixed Assets | $24,658,000 | Fixed Assets | $25,217,000 |
Goodwill
| 0 |
| Goodwill
| 0 | Goodwill
| 0 |
Intangible Assets | 0 |
| Intangible Assets | 0 | Intangible Assets | 0 |
Other Assets | $1,417,000 |
| Other Assets | $783,000 | Other Assets | $915,000 |
Deferred Asset Charges | 0 |
| Deferred Asset Charges | 0 | Deferred Asset Charges | 0 |
Total Assets | $38,999,000 |
| Total Assets | $37,431,000 | Total Assets | $40,262,000 |
Current Liabilities |
|
| Current Liabilities |
| Current Liabilities |
|
Accounts Payable | $12,931,000 |
| Accounts Payable | $10,989,000 | Accounts Payable | $11,654,000 |
Short-Term Debt / Current Portion of Long-Term Debt | $270,000 |
| Short-Term Debt / Current Portion of Long-Term Debt | $1,718,000 | Short-Term Debt / Current Portion of Long-Term Debt | $815,000 |
Other Current Liabilities | 0 |
| Other Current Liabilities | 0 | Other Current Liabilities | $153,000 |
Total Current Liabilities | $13,201,000 |
| Total Current Liabilities | $12,707,000 | Total Current Liabilities | $12,622,000 |
Long-Term Debt | $11,317,000 |
| Long-Term Debt | $11,031,000 | Long-Term Debt | $11,945,000 |
Other Liabilities | $2,059,000 |
| Other Liabilities | $1,879,000 | Other liabilities | $1,915,000 |
Deferred Liability Charges | $713,000 |
| Deferred Liability Charges | $861,000 | Deferred Liability Charges | $823,000 |
Minority Interest | 0 |
| Minority Interest | 0 | Minority Interest | 0 |
Total Liabilities | $27,290,000 |
| Total Liabilities | $26,478,000 | Total Liabilities | $27,305,000 |
Stock Holders Equity |
|
| Stock Holders Equity |
| Stock Holders Equity |
|
Common Stocks | $45,000 |
| Common Stocks | $46,000 | Common Stocks | $50,000 |
Capital Surplus | $5,858,000 |
| Capital Surplus | $5,661,000 | Capital Surplus | $5,348,000 |
Retained Earnings | $6,553,000 |
| Retained Earnings | $5,884,000 | Retained Earnings | $8,188,000 |
Other Equity | ($747,000) |
| Other Equity | ($638,000) | Other Equity | ($629,000) |
Total Equity | $11,709,000 |
| Total Equity | $10,953,000 | Total Equity | $12,957,000 |
Total Liabilities & Equity | $38,999,000 |
| Total Liabilities & Equity | $37,431,000 | Total Liabilities & Equity | $40,262,000 |
1. Compute accounts receivable turnover and days sales outstanding for only the two most recent years. Accounts receivable the following provides some guidelines for analyzing a company's accounts receivable.
Are sales primarily on credit or is a typical sale transacted? Consider the industry and the companies business model.
What is the relative size of the A/R? How has it changed in the last two-year period?
How large is the allowance for doubtful accounts? Determine the balance relative to gross A/R.
What did the company record as bad debt expense? Compute the common size amount.
Compute A/R turnover and days sales outstanding for the last two years reported on the income statement. Obtain additional information on the balance sheet to compute average balances for the denominator. Consider the current economic environment and the companies landscape. Would you expect collections to have slowed down or sped up during the year?
Does the company have any large customers that increased the companys credit risk?
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