Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Attached is a group project assignment instructions. For our assignment we chose Walmart. Attached is the data that we have collected and is needed to

Attached is a group project assignment instructions. For our assignment we chose Walmart. Attached is the data that we have collected and is needed to be used.

What I need is for my part of the project is Liquidity ratios & Financing ratios for Walmart 2014, 2015, 2016. and these three questions answered.

1. Does the firm have any problem areas that you would investigate further if you were a manager?

2. Are there any other specific pieces of information that you would request from your management team with regards to this firm? If so, why?

3. Would you invest money in this firm based on your analysis?

image text in transcribed Unit 3 [217: Finance] Assignment: Team Assignment Grading Rubric You have an opportunity to work with your classmates as teams. The ability to interact and solve problems together even at a distance is a key skill in today's business environment. You have been assigned to a Team (i.e., depending on course enrolment, a five or six person group working as a team) to answer the Case Assignment instructions below. One person from the group is to turn in the Assignment for the group in the Dropbox. Each person in the group must turn in their individual peer evaluations to their Dropbox to receive credit for the Assignment. The Team Peer Evaluation Form is found in Course Documents and will be individually submitted in addition to the one group submission of the case analysis. This Assignment will assess your knowledge based on the following outcome: PC-1.1: Engage in a team setting with professional integrity and respect. Supplemental Resource (not required) - The eText below can be found in the Library: Lipsinger, R., & DeRosa, D. (2010). Virtual team success: A practical guide for working and leading from a distance. Hoboken, NJ: John Wiley & Sons, Inc. can be a very helpful resource for this, and subsequent virtual team projects. Please note the sections on social loafing (pp. 67-68, 78-88). Pages 76, 107 and 138 are helpful Reference Guides intended to help you troubleshoot your virtual team. Optional Guideline Experience has shown the following timeline to be helpful. Please do not feel constrained by this time line; it is not a graded item. Unit 3: Wednesday Greet each other in the Team Discussion Board. Unit 3: Thursday Determine who will lead the project, who will do which parts, by when, what your communication expectations are and when you will be meeting next. Unit 3: Friday Confirmation of delegated duties. Delegated parties accept their delegated duty. Unit 3: Saturday Project Leader reassigns any duties not accepted by individuals on the team. Unit 3: Sunday Submit draft parts to Project Leader. Project Leader posts draft of the paper in the Team Discussion Board. Unit 3: Monday Team edits/improves the draft Assignment deliverable. Unit 3: Tuesday One team member submits the paper. Individual Team Peer Evaluation Form must be submitted to receive a grade for the Assignment. 1 of 4 Unit 3 [217: Finance] Some learners have found this to be a helpful guide for their first meeting...or initial DB posts. AGENDA: Determine project leadership. Determine the specifications, resources, and timelines for the project. Determine communication protocol. Determine next meeting. Assignment: Perform Financial Statement Analysis Ratio analysis can provide both internal and external users with a tremendous amount of information about firm performance. Select a publicly traded firm from the list below. Conduct a ratio analysis of the firm and report your findings. Disney Apple General Motors Ford Motor Company Wal-Mart Instructions Complete a ratio analysis on the company for three years. Include the ratio, its results and what the results mean for the company. Were there changes in the ratios, what could have caused the change? (Liquidity ratios, profitability ratios, activity ratios, financing ratios, and market ratios). The paper should include an individual evaluation section for each ratio then an overall comparison to validate your conclusion. Once the ratio analysis is completed answer the following questions. 1. Does the firm have any problem areas that you would investigate further if you were a manager? 2. Are there any other specific pieces of information that you would request from your management team with regards to this firm? If so, why? 3. Would you invest money in this firm based on your analysis? Criteria: Your paper should use correct APA formatting for your in-text citations to justify your discussion and place references at the bottom of the paper. Avoid using quotations, you should paraphrase the material and use an in-text citation to give credit to the reference. Review the APA formats found in the Writing Center. Include in your final paper: Cover page with each team member's name that participated on the team project Introduction Analysis Conclusion Reference page 2 of 4 Unit 3 [217: Finance] Directions for submitting your Team paper Make sure that you save a copy of the paper you submit. 1. To submit your paper, have one member of your group go to the Dropbox and select Unit 3: Assignment and follow the instructions. 2. Individually, each member of the group completes the peer evaluation form and individually submits the peer evaluation to the Unit 3 Team Peer Evaluation Dropbox. (file name: Kris.Kringle.peer.evaluation.unit-3) Unit 3 Assignment: Team Assignment Financial Statement Analysis Possible Points Points Earned Content: 50 points Response successfully answers the Assignment question(s); thoroughly uses the text and other literature. Includes a strong thesis statement, introduction and conclusion. The main points of the paper are developed clearly. All arguments are supported well (no errors in logic) using outside sources as assigned. 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. Achievement of a well-synthesized paper using contributions from team participants to achieve a paper that resembles the collective talents of the group. 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. 20 20 10 Analysis: 30 points Response exhibits strong higher-order critical thinking and analysis (e.g., evaluation). Paper shows original thought. 10 Analysis includes proper classifications, explanations, comparisons and inferences. 10 Critical thinking includes appropriate judgments, conclusions and assessment based on evaluation and synthesis of information. 10 Writing: 20 points Grammatical skills are strong with typically less than one error per page. Correct use of APA. 6 3 of 4 Unit 3 [217: Finance] Appropriate to the Assignment, fresh (interesting to read), accurate, (no far-fetched, unsupported comments), precise (say what you mean), and concise (not wordy). 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. Total 8 6 100 4 of 4 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 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

Fundamentals Of Multinational Finance

Authors: Michael Moffett, Arthur Stonehill, David Eiteman

6th Edition

0134472136, 978-0134472133

More Books

Students also viewed these Finance questions