Description of this paper

ACC - The Home Depot

Description

solution


Question

Question;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/2011Adjusted Closing Price $75.97 $65.17 $42.52 $33.77HOME DEPOT INC$ in millionsAs of2/2/20142/3/20131/29/20121/30/2011ASSETSCurrent assets:Cash and cash equivalents$1,929$2,494$1,987$545Accounts receivable, net1,3981,3951,2451,085Merechandise inventories11,05710,71010,32510,625Other current assets8957739631,224Total Current Assets15,27915,37214,52013,479Property & Equipment, at cost39,06438,49138,97538,385Less Accumulated Depreciation and Amortization15,71614,42214,52713,325Net Property & Equipment23,34824,06924,44825,060Goodwill1,2891,1701,1201,187Other assets602473430399TOTAL ASSETS$40,518$41,084$40,518$40,125LIABILITIES AND SHAREHOLDERS EQUITYCurrent liabilities:Accounts payable$5,797$5,376$4,856$4,717Accrued salaries & related expenses1,4281,4141,3721,290Sales taxes payable396472391368Deferred revenue1,3371,2701,1471,177Income taxes payable12222313Current installments of long-term debt331,321301,042Other accrued expenses1,7461,5871,5571,515Total current liabilities10,74911,4629,37610,122Long-term debt, excluding current installments14,6919,47510,7588,707Other long-term liabilities2,0422,0512,1462,135Deferred income taxes514319340272Total liabilities27,99623,30722,62021,236Shareholders equity:Common stock88888786Paid-in capital8,4027,9486,9666,556Retained earnings23,18020,03817,24614,995Accumulated other comprehensive income (loss)46397293445Treasury stock, at cost(19,194)(10,694)(6,694)(3,193)Total shareholders equity12,52217,77717,89818,889TOTAL LIABILITIES AND SHAREHOLDERS EQUITY$40,518$41,084$40,518$40,125

 

Paper#40775 | Written in 18-Jul-2015

Price : $32
SiteLock