can i get this lab answer? can i get this lab answer? can i get


Question Description:

30

Jun 03, 2016. can i get this lab answer?   can i get this lab answer?   can i get this lab answer?   can i get this lab answer?   can i get this lab answer?   can i get this lab answer?   can i get this lab answer?   can i get this lab answer? ATTACHMENT PREVIEW Download attachment Lab 3 Instructions (1).pdf Lab 3 – Financial Statement Analysis Instructor: Nicole Harris Points Possible: 10 Name:___________________________ Class Hour:________ Instructions: Print this lab and then answer the questions below by hand. To receive full credit for this lab, you need to do your OWN work and answer in your OWN words. Part 1 – Increase/decrease in Cash • • • • I would recommend using Chrome instead of Internet Explorer for this lab. Go to www.walmart.com and click on the “Corporate” link at the VERY bottom of the website. Scroll down to the “Investors” section and click on “Annual Reports” Click on “2016 Annual Report PDF”. This will open up Walmart’s 2016 Annual Report. Find the 4 main financial statements for Walmart (Hint: they start on pg. 35). What does Walmart call their 4 main financial statements? Write them below: ___________________________________________________________________________________________ ___________________________________________________________________________________________ • On which financial statement would we find the net increase/decrease in cash for 2016? (Hint: we studied this financial statement extensively this quarter). _____________________________________________________ • What is the net increase/decrease in cash for Walmart for the year 2016? (NOTE: The amounts shown on the financial statements are in MILLIONS) __________________________________________________________ • What is the net increase/decrease in cash for Walmart for the year 2015? ____________________________ Part 2 – Ratio Calculations • Calculate the Receivables Turnover Ratio for 2016. Assume “net sales” = “net credit sales”. SHOW YOUR WORK! Receivables Turnover Ratio for 2016:____________________________________ What does this number mean?________________________________________________________________ _________________________________________________________________________________________ If the industry average is 100, is Walmart doing a good job collecting its accounts receivable? Yes/No_________ • Calculate the company’s current ratio for 2016 and 2015. SHOW YOUR WORK! Current Ratio for 2016:__________________________________________ Current Ratio for 2015:__________________________________________ • Does the current ratio inform us of the company’s liquidity or its solvency? And WHY? (Hint: you need to know what the terms liquidity and solvency mean to answer this question ) _________________________________________________________________________________________ __________________________________________________________________________________________ • Calculate the company’s 2016 and 2015 Return on Assets. (Use the “Consolidated Net Income Attributable to Walmart” to calculate this). (For the 2015 ROA, the beginning balance for assets = $204,751). Return on Assets for 2016:_________________________________________________________ Return on Assets for 2015:_________________________________________________________ In which year did investors get a better return on assets?________________________ Part 3 – Price Earnings Ratio and comparison to Industry • • • Go to www.yahoo.com and click on the “FINANCE” section on the left of the screen. In the search bar at the top, type in “Walmart” and click “Search Finance” The current stock price for Walmart’s stock should show up as a large black number directly under the “WalMart Stores Inc. (WMT)”. What is the current stock price for Walmart?:_________________________ What day and time did you find this stock price?:____________________________ • Walmart’s earnings per share for 2016 is $4.57. Using the stock price you f…

Answer

30