Reference no: EM132314915
Asssignment
This homework is about Walmart (NYSE: wan). The questions you are required to answer relate to margins, cash flows, and working capital metrics. Express all margin answers using a percent symbol and to two decimal place
The following questions are based on the information disclosed in Walmart's Fourth Quarter (Q4) News Release, dated February 22, 2018:
1. What is the name of Walmart's CEO and President?
2. How much operating cash flow did Walmart generate in Fiscal 2018?
3. How much provisional benefit did Walmart record as a result of the tax reform?
4. How many associates do Walmart employ worldwide as of Fiscal 2018?
Based on the income statement:
5. Compute the gross margin (%) for Q4 of 2018 (excluding membership and other income).
6. Compute the gross margin (%) for the same period of 2017 (excluding membership and other income).
7. Compute the operating margin (%) for Q4 of 2018 (use total revenue). S. Compute the operating margin (%) for the same period of 2017 (use total revenue).
9. Compute the net margin (%) for Q4 of 2018 (excluding noncontrolling interest and use total revenue).
10. Compute the net margin (%) for the same period of 2017 (excluding noncontrolling interest and use total revenue).
11. Briefly describe the trend in all three margins.
12. Compute the growth rate (%) of Diluted Earnings per Share (Diluted EPS) in Q4 2018 as compared to the same period of 2017.
13. What is the dividend per share for F scal 2018? Based on the balance sheet:
14. Why do we have separate income statements for Q4 and for Fiscal 2018 but only one balance sheet?
15. For the most recent date, what is the single largest asset (not including subtotals) and what is it as a percentage of total assets?
16. For the most recent date, what is the single largest liability (not including subtotals) and what is it as a percentage of total assets (not total liabilities)?
Based on the cash flow statement:
17. What is the net cash provided by operating activities for Fiscal 2018?
18. What was free cash flow (FCF) for Fiscal 2018?
19. How much cash did the company borrow in long-term debt in Fiscal 2018?
Questions on working capital:
20. Compute the Average Age of Receivables for Fiscal 2018.
21. Compute the Average Days to Sell Inventory for Fiscal 2018.
22. Compute the Average Age of Payables for Fiscal 2018.
|
Find the acid-test quick ratio
: Cash is $475,000, Accounts Payable is $200,000, Accounts Receivable is $150,000, Wages Payable is $225,000, Bonds Payable is $700,000, Inventory is $750,000.
|
|
Find the impact to retained earnings
: In 2016 Coulter Corporation had revenues of $625,000, expenses of $150,000, and declared dividends of $85,000. Help find the impact to Retained Earnings?
|
|
What is the total standard cost for one unit of product
: Overhead is applied at $17.00 per direct labor hour. What is the total standard cost for one unit of product that would appear on a standard cost card?
|
|
In which section of the statement should tartech report
: Trading securities are at reported at fair value and included in net income. Collecting rent in advance will result in a deferred tax asset.
|
|
What is the name of walmarts ceo and president
: For the most recent date, what is the single largest asset (not including subtotals) and what is it as a percentage of total assets?
|
|
What is expected number of customers in the barber shop
: MSTE-002: Industrial Statistics Assignment - What is the expected number of customers in the barber shop and in the queue
|
|
Calculate the adjusted book balance on october 31
: The following information was used in reconciling the bank account for Mendez Company on October: Balance per bank, October 31 $8,650.
|
|
What type of reorganization has taken place
: AS a result of the merger , Target's shareholders received common stock in Parent having a fair market* value of $400,000 , and non - convertible bonds.
|
|
Find cash flow from operations using the indirect method
: In analyzing a company's financial statements, which financial statement would a potential investor primarily use to assess the company's liquidity?
|