Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need these numbers for my finance classdone and compiled to be turned in? thanks Your project and what I look for ... 100pts Each

image text in transcribed

I need these numbers for my finance classdone and compiled to be turned in? thanks

image text in transcribed Your project and what I look for ... 100pts Each team member should present their information to the team leader in the format below. The team leader will collect team member's write ups and will present respective accounts in the format below. The idea of the leader posting your write up with bullet points keeps things orderly. The introduction explaining what you have done. For the ratio work...you'll need to embed the Excel worksheet in the Word doc final paper And go on to explain, Current Ratio changed by $$$ from year to year --this was good or bad good --the cause of this change in this ratio from one year to the next could be the result of --if this a positive change the company should continue to continue to what? -- if this a negative change the company should take the following action to reverse the trend... Liquidity C&Q Current , accurate and described in proper context Quick, accurate and described in proper context Liquidity/Turns set 2 A/Payable Turns, accurate and described in proper context A/Receivable Turns, accurate and described in proper context Profitability Returns Return on Equity %, accurate and described in proper context Return on Assets%, accurate and described in proper context Profitability Operating margins Operating (pr- tax) Margin %, accurate and described in proper context Net Profit (after tax) Margin %, accurate and described in proper context Market Value Earnings per Share, accurate and described in proper context Price to Earnings ratio/Market- The report is free of writing and grammar errors I look for: Excellent presentation and format, more importantly- a layman could understand the material- that is a real task at times! Rubric per Assignment Content: 50 20 Response successfully answers the Assignment question(s); thoroughly uses the text and other literature. The work includes a strong thesis statement, introduction, and conclusion. All arguments are supported well (no errors in logic) using outside sources as assigned 20-Sources are primarily academic journals, with thoughtful use Web sources. References are applied substantively to the paper topic. Skillfully addresses counter-arguments and does not ignore data contradicting its claim. Refers to sources both in-text and in the reference page. 20 10 -Achievement of a well-synthesized paper using contributions from team participants to achieve a paper that resembles the collective talents of the group. A clear and constant peer analysis of team members are of proper response. Team member performed with integrity and respect towards other participants of the team (peer evaluation). Points will be deducted if the Peer Evaluation Form is not submitted to the Dropbox.10 Analysis 30 10Response exhibits strong higher-order critical thinking and analysis (e.g., evaluation). Paper shows original thought. 10 10Analysis includes proper classifications, explanations, comparisons and inferences. 10 10 Critical thinking includes appropriate judgments, conclusions and assessment based on evaluation and synthesis of information. Writing: 20 points Grammatical skills are strong with typically less than one error per page. Correct use of APA. 6 Appropriate to the Assignment, fresh (interesting to read), accurate, (no far-fetched, unsupported comments), precise(say what you mean), and concise (not wordy). 8 Project is in 12-point font. Narrative sections are double spaced with a double space between. Project is free of serious errors; grammar, punctuation, and spelling help to clarify the meaning by following accepted conventions.6 Wal-Mart Inc Income Statement(s) Adjusted for March 2016 Period Ending 31-Jan-15 31-Jan-14 31-Jan-13 Total Sales 485,651,000 476,294,000 468,651,000 (Supplier Purchases) Cost of Goods Sold 365,086,000 358,069,000 352,297,000 Gross Profit 120,565,000 118,225,000 116,354,000 Selling and General 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,034,000 26,753,000 27,539,000 Interest Expense 2,461,000 2,335,000 2,249,000 Income Before Tax 24,573,000 24,418,000 25,290,000 Income Tax Expense 7,985,000 8,105,000 7,958,000 Income tabs Net Income From Continuing Ops Statement -see other 16,588,000 16,313,000 17,332,000 below for the Balance Sheet and Discontinued Operations ratio 'worksheet'. 285,000 144,000 52,000 Net Income (Net Profit) (for ratio) 16,303,000 16,169,000 17,280,000 14,000,000 shares outstanding USE THESE PRICES Price per share $ 10.00 $ 9.00 $ 8.00 Wal-Mart Inc Balance Sheet(s) 31-Jan-15 Period Ending 31-Jan-14 31-Jan-13 Assets Current Assets Cash And Cash Equivalents 9,135,000 Accounts Receivable 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 C&Q 2015 2014 Current Quick Student B Liquidity- Turns Accts Receivable Turns Accts Payable Turns Student C Profitability Returns Return on Equity % Return on Assets% Student D Profitability Margins Operating (pre tax) Margin % Net Profit (after tax) Margin % Student E Market Value Use of three years of data (2013, 2014, and 2015). Enter ratio outcomes here and expand your comments per the doc share/instructions. Earnings per Share Price to Earnings ratio 14,000,000 shares outstanding Price per share $ 10.00 $ 9.00 2013 $ 8.00 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 to Expert-Tailored 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

International Financial Management

Authors: Geert Bekaert, Robert Hodrick

3rd edition

1107111820, 110711182X, 978-1107111820

More Books

Students also viewed these Finance questions