Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

I need help with this assignment its, can someone guide me in the right direction? Wal-Mart Inc Income Statements Period Ending Total Sales Cost of

I need help with this assignment its, can someone guide me in the right direction?

image text in transcribed Wal-Mart Inc Income Statements Period Ending Total Sales Cost of Goods Gross Profit Selling General and Administrative Operating Profit ( for ratio) Total Other Income/Expenses Net Earnings Before Interest And Taxes Interest Expense Income Before Tax Income Tax Expense Minority Interest Net Income From Continuing Ops Discontinued Operations Net Income (Net Profit) (for ratio) 14,000,000 shares outstanding USE THESE PRICES Price per share 31-Jan-15 485,651,000 365,086,000 120,565,000 93,418,000 27,147,000 113,000 27,260,000 2,461,000 24,799,000 7,985,000 -736,000 16,814,000 285,000 16,363,000 14,000,000 $ 10.00 $ 31-Jan-14 476,294,000 358,069,000 118,225,000 91,353,000 26,872,000 119,000 26,991,000 2,335,000 24,656,000 8,105,000 -673,000 16,551,000 144,000 16,022,000 14,000,000 9.00 $ 31-Jan-13 468,651,000 352,297,000 116,354,000 88,629,000 27,725,000 186,000 27,911,000 2,249,000 25,662,000 7,958,000 -757,000 17,704,000 52,000 16,999,000 14,000,000 8.00 Some rounding.. Income Statement -see other tabs below for the Balance Sheet and ratio 'worksheet'. 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 Net Receivables 6,778,000 Inventory 45,141,000 Other Current Assets 2,224,000 Total Current Assets 63,278,000 Property Plant and Equipment 116,655,000 Goodwill 18,102,000 Other Assets 5,671,000 Total Assets 203,706,000 Liabilities Current Liabilities Accounts Payable 58,583,000 Short/Current Long Term Debt 6,689,000 Other Current Liabilities Total Current Liabilities 65,272,000 Long Term Debt 43,692,000 Deferred Long Term Liability Charges 8,805,000 Minority Interest 4,543,000 Total Liabilities 122,312,000 Misc Stocks Options Warrants 0 Common Stock 323,000 Retained Earnings 85,777,000 Capital Surplus 2,462,000 Other Stockholder Equity -7,168,000 Total Stockholder Equity 81,394,000 Total Liabilities + Stockholder Equity 203,706,000 7,281,000 6,677,000 44,858,000 2,369,000 61,185,000 117,907,000 19,510,000 6,149,000 204,751,000 7,781,000 6,768,000 43,803,000 1,588,000 59,940,000 116,681,000 20,497,000 5,987,000 203,105,000 57,174,000 12,082,000 89,000 69,345,000 44,559,000 8,017,000 5,084,000 127,005,000 0 323,000 76,566,000 2,362,000 -1,505,000 77,746,000 59,099,000 12,719,000 196000 72,014,000 41,417,000 7,613,000 5,395,000 126,439,000 116,000 202,000 72,978,000 4,000,000 -630,000 76,666,000 204,751,000 203,105,000 Balance Sheet -see other tabs below for the Income Statement and ratio 'worksheet'. This worksheet will support your findings MT 217 Financial Statement Ratio Worksheet Student A Liquidity ( set 1) 2015 2014 Current Quick Student B Liquidity (set 2) Accts Receivable Turns Accts Payable Turns Student C Profitability (set 1) Return on Equity % Return on Assets% Student D Profitability (set 2) Operating (pre tax) Margin % Net Profit (after tax) Margin % Student E Market Ratio Earnings per Share Price to Earnings ratio 14,000,000 shares outstanding Price per share $ P/E ratio data 10.00 $ 9.00 2013 $ 8.00 Use of three years of data (2013, 2014, and 2015). Enter ratio outcomes here and expand your comments per the red tab /instructions. 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 valida 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) 2. Trends in Profitability ratios (both sets) 3. Trends in Market ratios 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. 2. Are there any other specific pieces of information that you would request from your management team 3. Would you invest money (yes - no) in this firm based on your analysis? What outcomes lead to this deci This is an explain outlin Word document This is an explain outline you'd prepare in a Word document 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles Of Managerial Finance

Authors: Lawrence J. Gitman, Chad J. Zutter

13th Edition

978-0136119463

Students also viewed these Finance questions