Anyone can fulfill anyone of these tabs....finance
Truly Blessed
TeamdataMT217ThreeYearsWMT-20181.xlsxIncome Statement
| Wal-Mart Inc | |||||||
| Income Statements | |||||||
| Period Ending | 31-Jan-15 | 31-Jan-14 | 31-Jan-13 | ||||
| Total Sales | 485,651,000 | 476,294,000 | 468,651,000 | ||||
| Cost of Goods | 365,086,000 | 358,069,000 | 352,297,000 | ||||
| Gross Profit | 120,565,000 | 118,225,000 | 116,354,000 | ||||
| Selling General and Administrative | 93,418,000 | 91,353,000 | 88,629,000 | ||||
| Operating Profit ( for ratio) | 27,147,000 | 26,872,000 | 27,725,000 | ||||
| Total Other Income/Expenses Net | 113,000 | 119,000 | 186,000 | ||||
| Earnings Before Interest And Taxes | 27,260,000 | 26,991,000 | 27,911,000 | ||||
| Interest Expense | 2,461,000 | 2,335,000 | 2,249,000 | ||||
| Income Before Tax | 24,799,000 | 24,656,000 | 25,662,000 | ||||
| Income Tax Expense | 7,985,000 | 8,105,000 | 7,958,000 | ||||
| Minority Interest | -736,000 | -673,000 | -757,000 | ||||
| Net Income From Continuing Ops | 16,814,000 | 16,551,000 | 17,704,000 | ||||
| Discontinued Operations | 285,000 | 144,000 | 52,000 | ||||
| Net Income (Net Profit) (for ratio) | 16,363,000 | 16,022,000 | 16,999,000 | ||||
| 14,000,000 shares outstanding | |||||||
| USE THESE PRICES Price per share | $ 10.00 | $ 9.00 | $ 8.00 |
Income Statement -see other tabs below for the Balance Sheet and ratio 'worksheet'.
Balance Sheet
| Wal-Mart Inc | ||||||||
| Balance Sheets | ||||||||
| Period Ending | 31-Jan-15 | 31-Jan-14 | 31-Jan-13 | |||||
| Assets | ||||||||
| Current Assets | ||||||||
| Cash And Cash Equivalents | 9,135,000 | 7,281,000 | 7,781,000 | |||||
| Net Receivables | 6,778,000 | 6,677,000 | 6,768,000 | |||||
| Inventory | 45,141,000 | 44,858,000 | 43,803,000 | |||||
| Other Current Assets | 2,224,000 | 2,369,000 | 1,588,000 | |||||
| Total Current Assets | 63,278,000 | 61,185,000 | 59,940,000 | |||||
| Property Plant and Equipment | 116,655,000 | 117,907,000 | 116,681,000 | |||||
| Goodwill | 18,102,000 | 19,510,000 | 20,497,000 | |||||
| Other Assets | 5,671,000 | 6,149,000 | 5,987,000 | |||||
| Total Assets | 203,706,000 | 204,751,000 | 203,105,000 | |||||
| Liabilities | ||||||||
| Current Liabilities | ||||||||
| Accounts Payable | 58,583,000 | 57,174,000 | 59,099,000 | |||||
| Short/Current Long Term Debt | 6,689,000 | 12,082,000 | 12,719,000 | |||||
| Other Current Liabilities | - | 89,000 | 196000 | |||||
| Total Current Liabilities | 65,272,000 | 69,345,000 | 72,014,000 | |||||
| Long Term Debt | 43,692,000 | 44,559,000 | 41,417,000 | |||||
| Deferred Long Term Liability Charges | 8,805,000 | 8,017,000 | 7,613,000 | |||||
| Minority Interest | 4,543,000 | 5,084,000 | 5,395,000 | |||||
| Total Liabilities | 122,312,000 | 127,005,000 | 126,439,000 | |||||
| Misc Stocks Options Warrants | 0 | 0 | 116,000 | |||||
| Common Stock | 323,000 | 323,000 | 202,000 | |||||
| Retained Earnings | 85,777,000 | 76,566,000 | 72,978,000 | |||||
| Capital Surplus | 2,462,000 | 2,362,000 | 4,000,000 | |||||
| Other Stockholder Equity | -7,168,000 | -1,505,000 | -630,000 | |||||
| Total Stockholder Equity | 81,394,000 | 77,746,000 | 76,666,000 | |||||
| Total Liabilities + Stockholder Equity | 203,706,000 | 204,751,000 | 203,105,000 | |||||
Balance Sheet -see other tabs below for the Income Statement and ratio 'worksheet'.
Complete this 3 year worksheet
| This worksheet will support your findings | ||||||||||||
| MT 217 Financial Statement Ratio Worksheet | 2015 | 2014 | 2013 | |||||||||
| CATEGORY | Student A | Liquidity ( set 1) | Current | Group member #1 | ||||||||
| Liquidity | Quick | Group member #1 | ||||||||||
| Student B | Liquidity (set 2) | Accts Receivable Turns | Group member #1 | |||||||||
| Accts Payable Turns | Group member #1 | |||||||||||
| Student C | Profitability (set 1) | Return on Equity % | Group member #2 | |||||||||
| Return on Assets% | Group member #2 | |||||||||||
| Student D | Profitability (set 2) | Operating (pre tax) Margin % | Group member #2 | |||||||||
| Net Profit (after tax) Margin % | Group member #2 | |||||||||||
| Profitability Ratio | Student E | Market Ratio | Earnings per Share | Group member #5 | ||||||||
| 1. Earnings Per Share, | Market Ratio | Price to Earnings ratio | Group member #5 | |||||||||
| 14,000,000 shares outstanding | ||||||||||||
| 2. Price Earnings Ratio | $ 3.00 | Price per share | $ 10.00 | $ 9.00 | $ 8.00 | |||||||
| % 4 decimals | ||||||||||||
| others 2 decimals |
Use of three years of data (2013, 2014, and 2015). Enter ratio outcomes here and expand your comments per the red tab /instructions.
Use Word to present outcome
| MT 217 Wal-Mart | ||
| 2013, 2014, and 2015 Ratio Analysis | ||
| The paper should include an evaluation section for the three groupings of ratio (A) then an overall comparison (B) to validate your team’s conclusion. | ||
| Consider these three area as the body of your 'written review'. | ||
| A. Once each ratio analysis is completed please note: | ||
| 1. Trends in Liquidity ratios ( both sets) | Group member #3 | |
| 2. Trends in Profitability ratios (both sets) | Group member #3 | |
| 3. Trends in Market ratios | Group member #3 | |
| Include any comments based upon these questions | ||
| B. Once the ratio analysis is completed please note: | ||
| 1. Note a couple problem areas that you would investigate further. | Group member #4 | |
| 2. Are there any other specific pieces of information that you would request from your management team with regards to this firm? | Group member #4 | |
| 3. Would you invest money (yes - no) in this firm based on your analysis? What outcomes lead to this decision? | Group member #4 | |
| Group member #5 performs reviews and edits |
This is an explain outline you'd prepare in a Word document
FYI SEC and Common links
| Some common links to financial information | ||
| You'd be surprised to see….page 21 Legal proceedings | ||
| How to access SEC filings | ||
| http://www.sec.gov/Archives/edgar/data/104169/000010416913000011/wmt10-k.htm | ||
| This is the source of the data used in this project | ||
| This same site provides access to the other DJIA 30 stocks | ||
| https://finance.yahoo.com/q/bs?s=WMT+Balance+Sheet&annual |
