Walmart Annual Report

Instructions for final project:

  1. Locate the audited financial statements in the 2019 Walmart Annual Report and 2019 Target Annual Report.
  2. Using the 2019 income statement, prepare a horizontal analysis for both companies. (you will also need 2018 to complete this step)
  3. Using the 2019 balance sheet, prepare a vertical analysis for both companies. You can perform this using only the key accounts/subtotals. Ie. Cash, A/R, Inventory, current assets, PP&E, Total Assets, A/P, current liabilities, Debt, Owners Equity. Each company may have a little different account structure, but the main subtotals will be available for both companies.
  4. Perform the following ratios from chapter 24: Current, Quick, Inventory Turnover, Days of Inventory, Debt to Equity, Interest Coverage, gross profit, operating margin, return on assets,
  5. List 3 observations from your calculations that demonstrate you have analyzed both companies.

 

 

 

Utilize your resources – textbook – chapter 24, Investopedia.com, yahoo finance, etc.

Submit your project on an excel spreadsheet.

Rubric:

Assignment turned in using Excel – one sheet for each step answers highlighted. 20%
Horizontal Analysis completed correctly – formulas are in the spreadsheet (0 points if formulas are not used) 20%
Vertical Analysis completed correctly – formulas are in the spreadsheet (0 points if formulas are not used) 20%
Ratios formulas are provided and each number is identified then calculated (see example provided in Moodle) 20%
Thoughtful observations are presented that demonstrate an understanding of the meaning of the ratios. 20%
  100%

 

LOOKING FOR THIS ASSIGNMENT OR A SIMILAR ONE? WE HAVE HAD A GOOD SUCCESS RATE ON THIS PAPER! ORDER WITH US TODAY FOR QUALITY WORK AND GET A DISCOUNT!

ORDER NOW

Disclaimer:

All types of paper that Discount Writers provides is only for the purpose of assistance! No text, paper, assignment, discussion would be similar with another student therefore guaranteeing Uniqueness and can be used with proper references only!

More tools: Better Grades: Choose your Homework Help:

Assignment Help: We would write your papers according to the instructions provided and guarantee you timely work

 

Entire Online Class Help: We are here for you and we would do your entire Class work from discussions, assignments, Replies, Exams and Quizzes at a Cost

 

Exam/ Quiz Help: We have a team of writers who specialize on exams from any specific field and we would give you an A+ Grade!

 

ORDER NOW