Calculate (show calculations) the following ratios for Wal-mart for the years ended on Janurary 31, 2018, Janurary 31, 2017, Janurary 31, 2018

1. ROE and a DuPont Analysis

2. Common Size Income Statement

3. Fixed Asset Turnover

4. Cash Cycle (show each component separately= days inventory on hand - days payable outstanding + days receivables outstanding)

:

Walmart Inc. Consolidated Statements of Income Fiscal Years Ended January 31, 2017 Amounts in millions, except per share data 2018 2016 478,614 3.516 482,130 Net sales 495,761 S 481,317 $ 4,582 500,343 4.556 485,873 Total revenues Costs and expenses: 361,256 Cost of sales Operating, selling, general and administrative expenses 373,396 106,510 20,437 101,853E 97.041 24,105 Operating income 22,764 2,044 323 100) 2,027 521 Debt 1,978 352 Capital lease and financing obligations Interest income Interest, net 2,178 3,136 15,123 2,267 2,467 Loss on extinguishment of debt Income before income taxes Provision for income taxes 10,523 (661) 9.862 20,497 6.204 14,293 (650) 13,643 21,638 6.558 15,080 386 14.694 Consolidated net income attributable to noncontrolling interest Consolidated net income attributable to Walmart Net income per common share: 4.40 $ 4.38 Basic net income per common share attributable to Walmart 3.29 S 4.58 Weighted-average common shares outstanding: 3,101 Basic Diluted 2,995 3,207 Dividends declared per common share Walmart Inc. Consolidated Statements of Income Fiscal Years Ended January 31, 2017 Amounts in millions, except per share data 2018 2016 478,614 3.516 482,130 Net sales 495,761 S 481,317 $ 4,582 500,343 4.556 485,873 Total revenues Costs and expenses: 361,256 Cost of sales Operating, selling, general and administrative expenses 373,396 106,510 20,437 101,853E 97.041 24,105 Operating income 22,764 2,044 323 100) 2,027 521 Debt 1,978 352 Capital lease and financing obligations Interest income Interest, net 2,178 3,136 15,123 2,267 2,467 Loss on extinguishment of debt Income before income taxes Provision for income taxes 10,523 (661) 9.862 20,497 6.204 14,293 (650) 13,643 21,638 6.558 15,080 386 14.694 Consolidated net income attributable to noncontrolling interest Consolidated net income attributable to Walmart Net income per common share: 4.40 $ 4.38 Basic net income per common share attributable to Walmart 3.29 S 4.58 Weighted-average common shares outstanding: 3,101 Basic Diluted 2,995 3,207 Dividends declared per common share