Calculate the ratios based on the following data Consolidate

Calculate the ratios (based on the following data)

Consolidated Statement of Income
		Fiscal Years Ended
		January 31,
(Amounts in millions, except per share data)	2017	2016
Revenues:
	Net sales	$481,317	$478,614
	Membership and other income	4,556	3,516
Total revenues	485,873	482,130
Costs and expenses:
	Cost of sales	361,256	360,984
	Operating, selling, general and administrative expenses	101,853	97,041
Operating income	22,764	24,105
Interest:
	Debt	2,044	2,027
	Capital lease and financing obligations	323	521
	Interest income	(100)	(81)
	Interest, net	2,267	2,467
Income from continuing operations before income taxes	20,497	21,638
Provision for income taxes	6,204	6,558
Income from continuing operations	14,293	15,080
Income from discontinued operations, net of income taxes
Consolidated net income	14,293	15,080
Consolidated net income attributable to noncontrolling interest	(650)	(386)
Consolidated net income attributable to Walmart	$13,643	$14,694
Basic net income per common share:
	Basic income per common share from continuing operations attributable to Walmart	$4.40	$4.58
	Basic income per common share from discontinued operations attributable to Walmart
Basic net income per common share attributable to Walmart	$4.40	$4.58
Diluted net income per common share:
	Diluted income per common share from continuing operations attributable to Walmart	$4.38	$4.57
	Diluted income per common share from discontinued operations attributable to Walmart
Diluted net income per common share attributable to Walmart	$4.38	$4.57
Weighted-average common shares outstanding:
	Basic	3,101	3,207
	Diluted	3,112	3,217
Dividends declared per common share	$2.00	$1.96
See accompanying notes.

Solution

Please hit LIKE button if this helped. For any further explanation, please put your query in comment, will get back to you. 2017 2016 Current Ratio Current Assets/Current Liabilities 57689/66928                                     0.86 60239/64619                0.93 Acid-Test Ratio Current Assets Less Stock and Prepaid/Current Liabilities (57689-1941-43036)/66928                                     0.19 (60239-1441-44469)/64619                0.22 Accounts Receivable turnover Net Credit Sales/AVERAGE accounts Receivable 481317/5835                                   82.49 478614/5624              85.10 Days Sales Uncollected 365/Accounts Receivable Turnover 365/82.49                                     4.42 365/85.1                4.29 Inventory Turnover COGS/Average Inventory 361256/43046                                     8.39 101853/44469                2.29 Days Sales in inventory 365/Inventory Turnover 365/8.39                                   43.50 365/2.29            159.39 Debt Ratio Total Liabilities/Total Assets (66928+36015+6003+9344)/198825 59.49% (64619+38214+5816+7321)/199581 58.11% Equity Ratio 1-Debt Ratio 40.51% 41.89% Debt to Equity Ratio Total Liabilities/Total Equity (66928+36015+6003+9344)/77798 152.05% (64619+38214+5816+7321)/80546 143.98% Gross Margin Gross Margin/Sales (481317+4556-361256)/(481317+4556) 25.65% (478614+3516-360984)/(478614+3516) 25.13%