Obtain the balance sheet of publicly traded company WAL-MART. 2 Compute the curr
ID: 2702983 • Letter: O
Question
Obtain the balance sheet of publicly traded company WAL-MART.2
Compute the current, quick, debt to equity and debt ratios.
Assets
Fiscal year is February-January. All values USD millions. 2009 2010 2011 2012 2013 Cash & Short Term Investments 7.28B 7.91B 7.4B 6.55B 7.78B Cash Only - 3.07B 1.7B 1.75B 7.78B Short-Term Investments - 4.84B 5.69B 4.8B 0 Total Accounts Receivable 3.91B 4.14B 5.09B 5.94B 6.77B Accounts Receivables, Net 3.91B 4.14B 5.09B 5.94B 6.77B Accounts Receivables, Gross 3.91B 4.14B 5.09B 5.94B 6.88B Bad Debt/Doubtful Accounts - - - - (115M) Other Receivables 0 0 0 0 0 Inventories 34.51B 33.16B 36.32B 40.71B 43.8B Finished Goods 34.51B 33.16B 36.32B 40.71B 43.8B Work in Progress 0 0 0 0 0 Raw Materials 0 0 0 0 0 Progress Payments & Other 0 - - 0 0 Other Current Assets 3.26B 3.12B 3.09B 1.77B 1.59B Miscellaneous Current Assets 3.26B 3.12B 3.09B 1.77B 1.59B Total Current Assets 48.95B 48.33B 51.89B 54.98B 59.94B
2009 2010 2011 2012 2013 Net Property, Plant & Equipment 95.65B 102.31B 107.88B 112.32B 116.68B Property, Plant & Equipment - Gross 131.16B 143.52B 154.49B 160.94B 171.72B Buildings 73.81B 77.45B 79.05B 84.28B 90.69B Land & Improvements 19.85B 22.59B 24.39B 23.5B 25.61B Computer Software and Equipment - - - - - Other Property, Plant & Equipment - 35.45B 38.29B 39.23B 40.9B Accumulated Depreciation 35.51B 41.21B 46.61B 48.61B 55.04B Total Investments and Advances 0 0 0 0 0 Other Long-Term Investments 0 0 0 0 0 Long-Term Note Receivable 0 0 0 0 0 Intangible Assets 15.26B 16.13B 16.76B 20.65B 20.5B Net Goodwill 15.26B 16.13B 16.76B 20.65B 20.5B Net Other Intangibles 0 0 0 0 0 Other Assets 3.37B 3.94B 4.13B 4.72B 5.23B Tangible Other Assets 0 3.94B 4.13B 4.72B 5.23B Total Assets 163.43B 175.41B 185.3B 193.41B 203.11B
Liabilities & Shareholders' Equity
2009 2010 2011 2012 2013 ST Debt & Current Portion LT Debt 7.67B 4.92B 6.02B 6.35B 12.72B Short Term Debt 1.51B 523M 1.03B 4.05B 6.81B Current Portion of Long Term Debt 6.16B 4.4B 4.99B 2.3B 5.91B Accounts Payable 28.85B 30.45B 33.56B 36.61B 38.08B Income Tax Payable 701M 1.37B 157M 1.21B 2.33B Other Current Liabilities 18.17B 18.83B 18.75B 18.14B 18.69B Dividends Payable - - - - - Accrued Payroll 5.58B 5.99B 5.9B 5.09B 5.06B Miscellaneous Current Liabilities 12.59B 12.84B 12.85B 13.05B 13.63B Total Current Liabilities 55.39B 55.56B 58.48B 62.3B 71.82B Long-Term Debt 34.55B 36.4B 43.84B 47.08B 41.42B Long-Term Debt excl. Capitalized Leases 31.35B 33.23B 40.69B 44.07B 38.39B Non-Convertible Debt 31.35B 33.23B 40.69B 44.07B 38.39B Convertible Debt 0 0 0 0 0 Capitalized Lease Obligations 3.2B 3.17B 3.15B 3.01B 3.02B Provision for Risks & Charges 0 0 0 0 684M Deferred Taxes 2.87B 1.04B 1.7B 3.88B 3.62B Deferred Taxes - Credit 3.08B 5.74B 6.34B 4.62B 4.37B Deferred Taxes - Debit 202M 4.71B 4.64B 738M 757M Other Liabilities 2.94B 4.47B 4.99B 3.25B 2.56B Other Liabilities (excl. Deferred Income) 2.94B 4.47B 4.99B 3.25B 2.56B Deferred Income - - - - - Total Liabilities 95.95B 102.18B 113.65B 117.24B 120.85B Non-Equity Reserves 0 0 0 0 0 Preferred Stock (Carrying Value) 0 0 0 0 0 Redeemable Preferred Stock 0 0 0 0 0 Non-Redeemable Preferred Stock 0 0 0 0 0 Common Equity (Total) 65.29B 70.75B 68.54B 71.32B 76.34B Common Stock Par/Carry Value 393M 378M 352M 342M 332M Retained Earnings 63.66B 66.64B 63.97B 68.69B 72.98B ESOP Debt Guarantee 0 0 0 0 0 Cumulative Translation Adjustment/Unrealized For. Exch. Gain (2.41B) - 1.29B (813M) 176M Unrealized Gain/Loss Marketable Securities 0 0 0 0 0 Revaluation Reserves 0 0 0 0 0 Treasury Stock 0 0 0 0 0 Total Shareholders' Equity 65.29B 70.75B 68.54B 71.32B 76.34B Accumulated Minority Interest 2.19B 2.49B 3.11B 4.85B 5.91B Total Equity 67.48B 73.24B 71.66B 76.17B 82.26B Liabilities & Shareholders' Equity 163.43B 175.41B 185.3B 193.41B 203.11B Copyright 2013 FactSet Research Systems Inc. All rights reserved. Source FactSet Fundamentals.
Accumulated Minority Interest 2.19B 2.49B 3.11B 4.85B 5.91B Total Equity 67.48B 73.24B 71.66B 76.17B 82.26B Liabilities & Shareholders' Equity 163.43B 175.41B 185.3B 193.41B 203.11B
Obtain the balance sheet of publicly traded company WAL-MART.
2
Compute the current, quick, debt to equity and debt ratios.
Assets
Fiscal year is February-January. All values USD millions. 2009 2010 2011 2012 2013 Cash & Short Term Investments 7.28B 7.91B 7.4B 6.55B 7.78B Cash Only - 3.07B 1.7B 1.75B 7.78B Short-Term Investments - 4.84B 5.69B 4.8B 0 Total Accounts Receivable 3.91B 4.14B 5.09B 5.94B 6.77B Accounts Receivables, Net 3.91B 4.14B 5.09B 5.94B 6.77B Accounts Receivables, Gross 3.91B 4.14B 5.09B 5.94B 6.88B Bad Debt/Doubtful Accounts - - - - (115M) Other Receivables 0 0 0 0 0 Inventories 34.51B 33.16B 36.32B 40.71B 43.8B Finished Goods 34.51B 33.16B 36.32B 40.71B 43.8B Work in Progress 0 0 0 0 0 Raw Materials 0 0 0 0 0 Progress Payments & Other 0 - - 0 0 Other Current Assets 3.26B 3.12B 3.09B 1.77B 1.59B Miscellaneous Current Assets 3.26B 3.12B 3.09B 1.77B 1.59B Total Current Assets 48.95B 48.33B 51.89B 54.98B 59.94B
2009 2010 2011 2012 2013 Net Property, Plant & Equipment 95.65B 102.31B 107.88B 112.32B 116.68B Property, Plant & Equipment - Gross 131.16B 143.52B 154.49B 160.94B 171.72B Buildings 73.81B 77.45B 79.05B 84.28B 90.69B Land & Improvements 19.85B 22.59B 24.39B 23.5B 25.61B Computer Software and Equipment - - - - - Other Property, Plant & Equipment - 35.45B 38.29B 39.23B 40.9B Accumulated Depreciation 35.51B 41.21B 46.61B 48.61B 55.04B Total Investments and Advances 0 0 0 0 0 Other Long-Term Investments 0 0 0 0 0 Long-Term Note Receivable 0 0 0 0 0 Intangible Assets 15.26B 16.13B 16.76B 20.65B 20.5B Net Goodwill 15.26B 16.13B 16.76B 20.65B 20.5B Net Other Intangibles 0 0 0 0 0 Other Assets 3.37B 3.94B 4.13B 4.72B 5.23B Tangible Other Assets 0 3.94B 4.13B 4.72B 5.23B Total Assets 163.43B 175.41B 185.3B 193.41B 203.11B
Liabilities & Shareholders' Equity
2009 2010 2011 2012 2013 ST Debt & Current Portion LT Debt 7.67B 4.92B 6.02B 6.35B 12.72B Short Term Debt 1.51B 523M 1.03B 4.05B 6.81B Current Portion of Long Term Debt 6.16B 4.4B 4.99B 2.3B 5.91B Accounts Payable 28.85B 30.45B 33.56B 36.61B 38.08B Income Tax Payable 701M 1.37B 157M 1.21B 2.33B Other Current Liabilities 18.17B 18.83B 18.75B 18.14B 18.69B Dividends Payable - - - - - Accrued Payroll 5.58B 5.99B 5.9B 5.09B 5.06B Miscellaneous Current Liabilities 12.59B 12.84B 12.85B 13.05B 13.63B Total Current Liabilities 55.39B 55.56B 58.48B 62.3B 71.82B Long-Term Debt 34.55B 36.4B 43.84B 47.08B 41.42B Long-Term Debt excl. Capitalized Leases 31.35B 33.23B 40.69B 44.07B 38.39B Non-Convertible Debt 31.35B 33.23B 40.69B 44.07B 38.39B Convertible Debt 0 0 0 0 0 Capitalized Lease Obligations 3.2B 3.17B 3.15B 3.01B 3.02B Provision for Risks & Charges 0 0 0 0 684M Deferred Taxes 2.87B 1.04B 1.7B 3.88B 3.62B Deferred Taxes - Credit 3.08B 5.74B 6.34B 4.62B 4.37B Deferred Taxes - Debit 202M 4.71B 4.64B 738M 757M Other Liabilities 2.94B 4.47B 4.99B 3.25B 2.56B Other Liabilities (excl. Deferred Income) 2.94B 4.47B 4.99B 3.25B 2.56B Deferred Income - - - - - Total Liabilities 95.95B 102.18B 113.65B 117.24B 120.85B Non-Equity Reserves 0 0 0 0 0 Preferred Stock (Carrying Value) 0 0 0 0 0 Redeemable Preferred Stock 0 0 0 0 0 Non-Redeemable Preferred Stock 0 0 0 0 0 Common Equity (Total) 65.29B 70.75B 68.54B 71.32B 76.34B Common Stock Par/Carry Value 393M 378M 352M 342M 332M Retained Earnings 63.66B 66.64B 63.97B 68.69B 72.98B ESOP Debt Guarantee 0 0 0 0 0 Cumulative Translation Adjustment/Unrealized For. Exch. Gain (2.41B) - 1.29B (813M) 176M Unrealized Gain/Loss Marketable Securities 0 0 0 0 0 Revaluation Reserves 0 0 0 0 0 Treasury Stock 0 0 0 0 0 Total Shareholders' Equity 65.29B 70.75B 68.54B 71.32B 76.34B Accumulated Minority Interest 2.19B 2.49B 3.11B 4.85B 5.91B Total Equity 67.48B 73.24B 71.66B 76.17B 82.26B Liabilities & Shareholders' Equity 163.43B 175.41B 185.3B 193.41B 203.11B Copyright 2013 FactSet Research Systems Inc. All rights reserved. Source FactSet Fundamentals.
Accumulated Minority Interest 2.19B 2.49B 3.11B 4.85B 5.91B Total Equity 67.48B 73.24B 71.66B 76.17B 82.26B Liabilities & Shareholders' Equity 163.43B 175.41B 185.3B 193.41B 203.11B
Explanation / Answer
currrent ratio= current asset/current liability
2009= 48.95/55.39=0.8837
2010=48.33/55.56=0.869
2011=51.89/58.48=0.8873
2012=54.98/62.3=0.8825
2013=59.94/71.82=0.8345
Quick ratio
2009=14.44/55.39=0.26
2010=15.17/55.56=0.273
2011= 15.57/58.48=0.266
2012=14.27/62.3=0.229
Debt -equity ratio
2009=95.95/67.48=1.422
2010=102.18/73.24=1.395
2011=113.65/71.66=1.585
2012=117.24/76.17=1.539
2013=120.85/82.26=1.469
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.