Accounting

profileEpic Writer Phd
f12_accounting.xlsx

Sheet1

Wal-Mart Stores Inc.
Ratio Analysis
1. Profit Margin = (Net Income/Net sales or revenue )*100
2015 2014 2013
Net Sales(revenue) $482,130 million 485651 million 476294 million
Net Income $14,694 million $16,363million $16,022million
Gross Margin 3.048% 3.369% 3.364%
2.Current Ratio= current Assets/Current Liabilities
2015 2014 2013
current Assets $60,239 million $63,278 million $61,185 million
Current Liabilities $64,619 million $65,253 million $65,345 million
Current Ratio 0.932 0.97 0.882
3.Debt Eqiuty Ratio= Long term Debts/Total Equity
2015 2014 2013
Long Term Debts $44,030 $43,495 million $44,559 million
Total Equity $80,546 million $81,394 milion $76,255 million
3.Debt Eqiuty Ratio 0.547 0.534 0.584
REFERNCE:https://finance.yahoo.com/quote/WMT/financials?p=WMT

Sheet2

Sheet3