Question: Calculation On each data tab, use formulas to calculate the following financial indicators for each year of data: o Current ratio o Debt/equity ratio o
Calculation On each data tab, use formulas to calculate the following financial indicators for each year of data:
o Current ratio
o Debt/equity ratio
o Free cash flow
o Earnings per share
o Price/earnings ratio
o Return on equity
o Net profit margin
Ratio

51000 -360000 745000 6204000 14293000 -1026000 6558000 15080000 Deferred U.S. state & local income taxes provision (benefit) Deferred international income taxes provision (benefit) Deferred provision (benefit) for income taxes Provision (benefit) for income taxes Income (loss) from continuing operations Income (loss) from discontinued operations, net of income ta Consolidated net income (loss) Less consolidated net income attributable to noncontrolling i Consolidated net income attributable to Walmart Weighted average shares outstanding - basic Weighted average shares outstanding - diluted Year end shares outstanding Income (loss) per share continuing operations - basic Income (loss) per share-discontinued operations - basic Net income (loss) per share - basic Income (loss) per share continuing operations - diluted Income (loss) per share-discontinued operations - diluted Net income (loss) per share - diluted Dividends declared per common share Total number of employees Number of common stockholders 14293000 -650000 13643000 3101000 3112000 3048000 4.4 15080000 -386000 14694000 3207000 3217000 3162000 4.58 -55000 -77000 -519000 7985000 16814000 285000 17099000 -736000 16363000 3230000 3243000 3228000 5.01 0.06 5.07 4.99 0.06 5.05 1.92 2200000 249876 4.4 4.38 4.58 4.57 4.38 2 2300000 236471 4.57 1.96 2200000 243327 Walmart Inc (NYS: WMT) Exchange rate used is that of the Year End reported date As Reported Annual Income Statement Report Date Currency Audit Status Consolidated Scale Net sales Membership & other income Total revenues Cost of sales Operating, selling, general & administrative expenses Operating income (loss) Interest expense on debt Interest expense on finance, capital lease & financing obliga Interest income Interest income (expense), net Gain (loss) on extinguishment of debt Other gains & (losses) Income (loss) before income taxes - United States (U.S.) Income (loss) before income taxes - non-U.S. Income (loss) before income taxes Current U.S. federal income taxes provision (benefit) Current U.S. state & local income taxes provision (benefit) Current international income taxes provision (benefit) Current provision (benefit) for income taxes Deferred U.S. federal income taxes provision (benefit) 01/31/2017 USD Not Qualified Yes Thousands 481317000 4556000 485873000 361256000 101853000 22764000 2044000 323000 100000 -2267000 01/31/2016 USD Not Qualified Yes Thousands 478614000 3516000 482130000 360984000 97041000 24105000 2027000 521000 81000 -2467000 01/31/2015 USD Not Qualified Yes Thousands 482229000 3422000 485651000 365086000 93418000 27147000 2161000 300000 113000 -2348000 21638000 15680000 4817000 20497000 3454000 495000 1510000 5459000 1054000 18610000 6189000 24799000 6165000 810000 1529000 8504000 -387000 7584000 51000 -360000 745000 6204000 14293000 -1026000 6558000 15080000 Deferred U.S. state & local income taxes provision (benefit) Deferred international income taxes provision (benefit) Deferred provision (benefit) for income taxes Provision (benefit) for income taxes Income (loss) from continuing operations Income (loss) from discontinued operations, net of income ta Consolidated net income (loss) Less consolidated net income attributable to noncontrolling i Consolidated net income attributable to Walmart Weighted average shares outstanding - basic Weighted average shares outstanding - diluted Year end shares outstanding Income (loss) per share continuing operations - basic Income (loss) per share-discontinued operations - basic Net income (loss) per share - basic Income (loss) per share continuing operations - diluted Income (loss) per share-discontinued operations - diluted Net income (loss) per share - diluted Dividends declared per common share Total number of employees Number of common stockholders 14293000 -650000 13643000 3101000 3112000 3048000 4.4 15080000 -386000 14694000 3207000 3217000 3162000 4.58 -55000 -77000 -519000 7985000 16814000 285000 17099000 -736000 16363000 3230000 3243000 3228000 5.01 0.06 5.07 4.99 0.06 5.05 1.92 2200000 249876 4.4 4.38 4.58 4.57 4.38 2 2300000 236471 4.57 1.96 2200000 243327 Walmart Inc (NYS: WMT) Exchange rate used is that of the Year End reported date As Reported Annual Income Statement Report Date Currency Audit Status Consolidated Scale Net sales Membership & other income Total revenues Cost of sales Operating, selling, general & administrative expenses Operating income (loss) Interest expense on debt Interest expense on finance, capital lease & financing obliga Interest income Interest income (expense), net Gain (loss) on extinguishment of debt Other gains & (losses) Income (loss) before income taxes - United States (U.S.) Income (loss) before income taxes - non-U.S. Income (loss) before income taxes Current U.S. federal income taxes provision (benefit) Current U.S. state & local income taxes provision (benefit) Current international income taxes provision (benefit) Current provision (benefit) for income taxes Deferred U.S. federal income taxes provision (benefit) 01/31/2017 USD Not Qualified Yes Thousands 481317000 4556000 485873000 361256000 101853000 22764000 2044000 323000 100000 -2267000 01/31/2016 USD Not Qualified Yes Thousands 478614000 3516000 482130000 360984000 97041000 24105000 2027000 521000 81000 -2467000 01/31/2015 USD Not Qualified Yes Thousands 482229000 3422000 485651000 365086000 93418000 27147000 2161000 300000 113000 -2348000 21638000 15680000 4817000 20497000 3454000 495000 1510000 5459000 1054000 18610000 6189000 24799000 6165000 810000 1529000 8504000 -387000 7584000
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
