ACC - The Home Depot

ACC - The Home Depot

Question # 00019879 Posted By: expert-mustang Updated on: 07/14/2014 10:31 AM Due on: 07/14/2014
Subject Accounting Topic Accounting Tutorials:
Question
Dot Image

Using the accompanying financial statements (Excel Workbook), assess The Home Depot concerning profitability, liquidity, solvency, management efficiency, investment return, and stock features. For each area, you should calculate the ratios we discussed in class 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 below.

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

Fiscal Year Ended 2/2/2014 2/3/2013 1/29/2012 1/30/2011
Adjusted Closing Price $75.97 $65.17 $42.52 $33.77

HOME DEPOT INC
$ in millions
As of2/2/20142/3/20131/29/20121/30/2011
ASSETS
Current assets:
Cash and cash equivalents$1,929$2,494$1,987$545
Accounts receivable, net1,3981,3951,2451,085
Merechandise inventories11,05710,71010,32510,625
Other current assets8957739631,224
Total Current Assets15,27915,37214,52013,479
Property & Equipment, at cost39,06438,49138,97538,385
Less Accumulated Depreciation and Amortization15,71614,42214,52713,325
Net Property & Equipment23,34824,06924,44825,060
Goodwill1,2891,1701,1201,187
Other assets602473430399
TOTAL ASSETS$40,518$41,084$40,518$40,125
LIABILITIES AND SHAREHOLDERS EQUITY
Current liabilities:
Accounts payable$5,797$5,376$4,856$4,717
Accrued salaries & related expenses1,4281,4141,3721,290
Sales taxes payable396472391368
Deferred revenue1,3371,2701,1471,177
Income taxes payable12222313
Current installments of long-term debt331,321301,042
Other accrued expenses1,7461,5871,5571,515
Total current liabilities10,74911,4629,37610,122
Long-term debt, excluding current installments14,6919,47510,7588,707
Other long-term liabilities2,0422,0512,1462,135
Deferred income taxes514319340272
Total liabilities27,99623,30722,62021,236
Shareholders equity:
Common stock88888786
Paid-in capital8,4027,9486,9666,556
Retained earnings23,18020,03817,24614,995
Accumulated other comprehensive income (loss)46397293445
Treasury stock, at cost(19,194)(10,694)(6,694)(3,193)
Total shareholders equity12,52217,77717,89818,889
TOTAL LIABILITIES AND SHAREHOLDERS EQUITY$40,518$41,084$40,518$40,125
Dot Image
Report this Question as Inappropriate
Tutorials for this Question
  1. expert-mustang
    Tutorial # 00019290 Posted By: expert-mustang Posted on: 07/14/2014 10:32 AM
    Puchased By: 4
    Tutorial Preview
    The solution of ACC - The Home Depot Solution Paper...
      Get the Solution
    Attachments
    ACC_-_The_Home_Depot_Solution_Paper.docx (32.88 KB)
    ACC_-_The_Home_Depot_Worksheet.xlsx (23.32 KB)
    Recent Feedback
    Rated By Feedback Comments Rated On
    c...voe Rating Satisfied with the offered services 02/10/2016
    me...217 Rating Self-explanatory tutorials 09/27/2015
  Get the Solution

Great! We have found the solution of this question!

Related Questions and Answers

Whatsapp Lisa