Example of vertical analysis of financial statements

WAL-MART ANALYSIS

Directions: Answer all the questions. Please submit your work in Word or PDF formats only. Submit an Excel file to support calculations, but please “cut and paste” your solutions into the Word or PDF file. Be sure to show how you did your calculations.

Please run spell check, check your grammar and sentence structure and proofread your answers.

YOUR SUBMISSION WILL BE SUBMITTED TO "TURNITIN" and "GOOGLE" TO CHECK FOR PLAIGIARISM.

PLEASE REVIEW THE TEMPLATE I HAVE ATTACHED TO SEE HOW THE ANALYSIS IS DONE. IT IS JUST AN EXAMPLE YOU DON’T HAVE TO DO EXACTLY THE SAME BUT IT HELPS YOU TO STRUCTURE YOUR ASSIGNMENT IF YOU ARE NOT SURE.

Walmart Analysis Assignment

Directions: Answer all the questions. Please submit your work in Word or PDF formats only. You can submit an Excel file to support calculations, but please “cut and paste” your solutions into the Word or PDF file. Be sure to show how you did your calculations. Also, please be sure to include your name at the top of the first page of your file.

Part 1

Perform a vertical and horizontal analysis of Wal-Mart Stores, Inc.’s income statements and balance sheets as of January 31, 2015. In performing this analysis, consider any notable trends or changes that you observe that may provide useful information concerning its financial condition. Also use as many years’ worth of statements as you feel necessary. You should write up your results in paragraph form.

Part 2

Assess Wal-Mart, Stores Inc. concerning liquidity, solvency, profitability, and stock performance as of January 31, 2015. For each area, you should calculate the ratios we discussed in class and provide an analysis of the ratios calculated. I include historical stock price information and outstanding common share information below.

Fiscal Year Ended

1/31/2015

1/31/2014

1/31/2013

1/31/2012

Adjusted Closing Price

$83.94

$71.97

$65.79

$56.32

Common Shares Outstanding (millions)

3,228

3,233

3,314

3,418