HOME DEPOT Financial Analysis DUE FRIDAY, MAY 18 @9PM

profilebody_candee
ACT5140DESAIFall2015HW1-AppendixA.doc

ACT 5140 – Accounting for Decision Makers

HW #1 – Appendix A

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.

Question #1

Using the accompanying financial statements (Excel Workbook), assess The Home Depot concerning liquidity, solvency, profitability, and stock performance. For each area, you should calculate the ratios from Appendix A and provide a brief analysis of the ratios calculated. You do not need to perform vertical analysis for this assignment. I include historical stock price information and outstanding common share information below.

You do not need to look beyond the financial statements to complete this assignment.

Fiscal Year Ended

2/1/2015

2/2/2014

2/3/2013

1/29/2012

Adjusted Closing Price

$103.34

$74.44

$63.87

$41.67

Common Shares Outstanding (millions)

1,307

1,380

1,486

1,523