ACG 2071 Managerial Accounting
Chapter 13 Financial Statement Analysis Project
This assignment is due Tuesday, Nov 12th by midnight via Canvas email. It will not be accepted late for any reason, but you can submit it early.
Students should read chapter 13, as well as complete the pre-work quiz and Learn Smart for chapter 13 in Connect prior to attempting this project.
Use the following data in addition to the financial statements provided:
After your financial analysis is complete, please answer:
Which stock would you buy and why?
Write three detailed paragraphs addressing the strengths and weaknesses of each company, as well as your reasons for purchasing Target or Wal-Mart stock. The strengths, weaknesses, and your investment choice should be described in 1.5 to 2 pages typed, 12-point font, double spaced with one inch margins.
Important: The financial calculations should be completed for 2016 only. Annual reports provide several prior years information so investors and creditors can spot trends from year to year. You will not use 2012, 2013, or 2014 information for any of your calculations. You need 2015 for all ratios that require an average. For example:
(end of year 2015 + end of year 2016) / 2 = average
All ratios should include the numerators and denominators in columns F and I, and answers in columns G and J. Do NOT add zeros. Use the numbers provided. Show your work!
Email the following when submitting your assignment:
1) Excel worksheet file “saved as” the following file name…lastnamefirstname.xlsx
If I were sending the file, I would save it as
2) Your paper typed in Word. The file should be saved in the same name format.
3) The Excel and Word file should also include your name in the heading on the worksheet and written paper. Your name needs to appear on the papers when I print the documents.
Points will be deducted for not following directions.
Please let me know if you have any questions.