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 teams 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
