Need help with the calculations for 2015, 2014, 2013, 2012 DuPont analysis Debt

Question

Need help with the calculations for 2015, 2014, 2013, 2012

DuPont analysis

Debt Equity Ratio Interest Coverage Long Term Liabilities Asset Turnover Return on sales Gross margin % Return on assets Return on equity Average interest rate Average total assets Income tax rate Net of tax interest expense Adjusted net income Average equity Average total liabilities Book value per common share Earnings per share (basic) Earnings per share (diluted) P/E Ratio Dividend yield Dividend payout Book value of equity Common shares outstanding Adjusted closing price Dividends per share

DuPont analysis

WAL MART STORES INC 10-K Statement of Cash Flows (Amounts in millions) Fiscal Year Ended January 31, 2015 2014 2013 2012 Cash flows from operating activities: Consolidated net income $17,099 $16,695 $17,756 $16,387 (Income) Loss from discontinued operations, net of tax (285) (144) (52) 21 Income from continuing operations 16,814 16,551 17,704 16,408 Adjustments to reconcile income from continuing operations to net cash provided by operating activities Depreciation and amortization 9,173 8,870 8,478 8,106 Deferred income taxes (503) (279) (133) 1,050 Other operating activities 785 938 602 468 Changes in certain assets and liabilities, net of effects of acquisitions: Increase in accounts receivable (569) (566) (614) (796) Increase in inventories (1,229) (1,667) (2,759) (3,727) Increase in accounts payable 2,678 531 1,061 2,687 Increase in accrued liabilities 1,249 103 271 30 (Decrease) Increase in accrued income taxes 166 (1,224) 981 29 Net cash provided by operating activities 28,564 23,257 25,591 24,255 Cash flows from investing activities: Payments for property and equipment (12,174) (13,115) (12,898) (13,510) Proceeds from disposal of property and equipment 570 727 532 580 Proceeds from disposal of certain operations 671 0 0 0 Other investing activities (192) (138) (271) (3,679) Net cash used in investing activities (11,125) (12,526) (12,637) (16,609) Cash flows from financing activities: Net change in short-term borrowings (6,288) 911 2,754 3,019 Proceeds from issuance of long-term debt 5,174 7,072 211 5,050 Payment of long-term debt (3,904) (4,968) (1,478) (4,584) Dividends paid (6,185) (6,139) (5,361) (5,048) Purchase of Company stock (1,015) (6,683) (7,600) (6,298) Dividends paid to noncontrolling interest (600) (426) (282) (526) Purchase of noncontrolling interest (1,844) (296) (132) 0 Other financing activities (409) (260) (58) (71) Net cash used in financing activities (15,071) (10,789) (11,946) (8,458) Effect of exchange rates on cash (514) (442) 223 (33) Net (decrease) increase in cash and cash equivalents 1,854 (500) 1,231 (845) Cash and cash equivalents at beginning of year 7,281 7,781 6,550 7,395 Cash and cash equivalents at end of year $9,135 $7,281 $7,781 $6,550 Supplemental disclosure of cash flow information Income tax paid 8,169 8,641 7,304 5,889 Interest paid 2,433 2,362 2,262 2,346

Explanation / Answer

1). Debt Equity Ratio = Total Debt / Equity
2015 = (203706 - 85937) / 85937 = 1.37
2014 = (204751 - 81339) / 81339 = 1.52
2013 = (203105 - 81738) / 81738 = 1.48
2012 = (193706 - 75761) / 75761 = 1.56

2). Interest Coverage Ratio = Earnings before Interest / Interest expense
2015 = 27147 / 2461 = 11.03
2014 = 26872 / 2335 = 11.51
2013 = 27725 / 2249 = 12.33
2012 = 26491 / 2320 = 11.42

3). Long Term Liabilities = Long term debt + long term obligations + other non current liabilities
2015 = 41086 + 2606 +8805 = $52497
2014 = 41771 + 2788 + 8017 + 1491 = $54067
2013 = 38394 + 3023 + 7613 + 519 = $49549
2012 = 44070 + 3009 + 7862 + 404 = $55345

4). Asset Turnover = Sales / Average Total assets
2015 = 482229 / ((203706 + 204751) /2) = 482229 / 204228.5 = 2.36
2014 = 473076 / ((204751 + 203105) /2) = 473076 / 203928 = 2.32
2013 = 465604 / ((203105 + 193406) / 2) = 465604 / 198255.5 = 2.35

5). Return on Sales = Net Income from continuing operation before Income tax / Net sales
2015 = 24799 / 482229 = 0.0514 or 5.14%
2014 = 24656 / 473076 = 0.0521 or 5.21%
2013 = 25662 / 465604 = 0.0551 or 5.51%
2012 = 24332 / 443416 = 0.0548 or 5.49%

6).Gross margin % = Gross Profit / Net Sales = (Net Sales - Cost of Sales) / Net Sales
2015 = (482229 - 365086) / 482229 = 117143 / 482229 = 0.2429 or 24.30%
2014 = (473076 - 358069) / 473076 = 115007 / 473076 = 0.2431 or 24.31%
2013 = (465604 - 352297) / 465604 = 113307 / 465604 = 0.2433 or 24.33%
2012 = (443416 - 334993) / 443416 = 108423 / 443416 = 0.2445 or 24.45%

7). Return on Assets = Net Income from continuing operation before Income tax / Average Total Assets

8). Return on Equity = Net Income from continuing operation before Income tax / Total Equity

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.