(solution) You will see below 4 "green" tabs and 5 "red

(solution) You will see below 4 "green" tabs and 5 "red

I have attached thee assignment as you requested. Can you please it have it back before 9 p.m eastern time today.

You will see below 4 "green" tabs and 5 "red tabs". Green Tabs Represent the information you will need to compute the answers required in the re The Red tabs represent where you will place your answers.
Each red tab requires 2 things: (1) Calculated Answers in Each Box (2) Explanations in the text b
In each red tab you will need to fill in each box where a calcuclated amount is required. The text box found in each red tab area is for you to explain what your calculated answers in th
For instance, if a current ratio goes up then it shows the creditor that the company is has more
are better short term risk. Using the accompanying financial statements (found in the green tabs), assess The Home Depot
liquidity, solvency, profitability, and stock performance. For each area, you should calculate the
discussed in class and provide a brief analysis of the ratios calculated. You do not need to perfo
analysis for this assignment. Legend for Tabs Listed Below answers required in the red tabs. Explanations in the text box area mount is required. r calculated answers in the boxes represent. the company is has more liquidity and they Green Tabs – Information Required for Red Tab Answers
1. SP – Historical Stock Prices
2. IS – Income Statement
3. BS – Balance Sheet
4. CF – Statement of Cash Flows
Red Tabs – You will supply your answers in these tabs
There are 2 sets of answers required
1. In the Boxes you will put your calculations for the ratio
2. In the text box you will write text about what your ratios
outside investor, creditor, etc.
1.
2.
3.
4.
5. Short-Term
– Answers to your short term ratios
Long-Term
– Answers to your long term ratios
Profitability
– Answers to your profitability ratios
DuPont Analysis – Answers to your DuPont Analysis Ratios
Stock
– Answers to your Stock Ratios s), assess The Home Depot concerning
, you should calculate the ratios we
You do not need to perform vertical Once you are done with your answers – ema
to me to the following email address:
[email protected] ed for Red Tab Answers nswers in these tabs
ired
your calculations for the ratio required
write text about what your ratios mean to an your short term ratios
your long term ratios
your profitability ratios
your DuPont Analysis Ratios
your Stock Ratios ith your answers – email them
email address: Historical Stock Prices
Fiscal Year Ended 1/31/2016 2/1/2015 2/2/2014 2/3/2013
Adjusted Closing Price
$125.07 $101.80 $73.34 $62.92
Common Shares Outstanding (m 1,252
1,307
1,380
1,486 HOME DEPOT INC
$ in millions
Year Ending
NET SALES
Cost of sales
GROSS PROFIT
Operating Expenses:
Selling, General and Administrative
Depreciation and Amortization
Total Operating Expenses
OPERATING INCOME
Interest and Other (Income) Expense:
Interest and Investment Income
Interest Expense
Other 1/31/2016
$88,519
58,254
30,265 2/1/2015
$83,176
54,787
28,389 2/2/2014
$78,812
51,897
26,915 2/3/2013
$74,754
48,912
25,842 16,801
1,690
18,491
11,774 16,280
1,640
17,920
10,469 16,122
1,627
17,749
9,166 16,508
1,568
18,076
7,766 (166)
919
0 (337)
830
0 (12)
711
0 (20)
632
(67) 753
11,021
4,012
$7,009 493
9,976
3,631
$6,345 699
8,467
3,082
$5,385 545
7,221
2,686
$4,535 Basic earnings per share
Diluted earnings per share $5.49
$5.46 $4.74
$4.71 $3.78
$3.76 $3.03
$3.00 Dividends per share $2.36 $1.88 $1.56 $1.16 Interest and Other, net
Earnings before income taxes
Provision for Income Taxes
NET EARNINGS HOME DEPOT INC
$ in millions
As of 1/31/2016 2/1/2015 2/2/2014 2/3/2013 ASSETS
Current assets:
Cash and cash equivalents
Accounts receivable, net
Merechandise inventories
Other current assets $2,216
1,890
11,809
1,078 $1,723
1,484
11,079
1,016 $1,929
1,398
11,057
895 $2,494
1,395
10,710
773 Total Current Assets 16,993 15,302 15,279 15,372 Property & Equipment, at cost
Less Accumulated Depreciation and Amortization
Net Property & Equipment 39,266
17,075
22,191 38,513
15,793
22,720 39,064
15,716
23,348 38,491
14,422
24,069 Goodwill
Other assets
TOTAL ASSETS 2,102
1,263
$42,549 1,353
571
$39,946 1,289
602
$40,518 1,170
473
$41,084 LIABILITIES AND SHAREHOLDERS EQUITY
Current liabilities:
Short-term debt
Accounts payable
Accrued salaries & related expenses
Sales taxes payable
Deferred revenue
Income taxes payable
Current installments of long-term debt
Other accrued expenses $350
6,565
1,515
476
1,566
34
77
1,943 $290
5,807
1,391
434
1,468
35
38
1,806 $0
5,797
1,428
396
1,337
12
33
1,746 $0
5,376
1,414
472
1,270
22
1,321
1,587 Total current liabilities 12,526 11,269 10,749 11,462 Long-term debt, excluding current installments
Other long-term liabilities
Deferred income taxes
Total liabilities 20,888
1,965
854
36,233 16,869
1,844
642
30,624 14,691
2,042
514
27,996 9,475
2,051
319
23,307 Shareholders equity:
Common stock
Paid-in capital
Retained earnings
Accumulated other comprehensive income (loss)
Treasury stock, at cost
Total shareholders equity 88
9,347
30,973
(898)
(33,194)
6,316 88
8,885
26,995
(452)
(26,194)
9,322 88
8,402
23,180
46
(19,194)
12,522 88
7,948
20,038
397
(10,694)
17,777 TOTAL LIABILITIES AND SHAREHOLDERS EQUITY $42,549 $39,946 $40,518 $41,084 HOME DEPOT INC
$ in millions
Year Ending
OPERATING ACTIVITIES:
Net earnings
Adjustments to reconcile net earnings to net cash provided by operating activities:
Depreciation and amortization
Stock-based compensation expense
Gain on sales of investments
Changes in Assets and Liabilities, net of the effects of acquisition and disposition
Receivables, net
Merchandise inventories
Other current assets
Accounts payable and accrued expenses
Deferred revenue
Income taxes payable
Deferred income taxes
Other
Net cash provided by operating activities
INVESTING ACTIVITIES:
Capital expenditures
Proceeds from sales of investments
Payments for business acquired
Proceeds from sales of property & equipment
Net cash used by investing activities
FINANCING ACTIVITIES:
Proceeds from short-term borrowings, net
Proceeds from long-term borrowings, net of discount
Repayments of long-term debt
Repurchases of common stock 1/31/2016 2/1/2015 2/2/2014 2/3/2013 $7,009 $6,345 $5,385 $4,535 1,863
244
(144) 1,786
225
(323) 1,757
228
0 1,684
218
97 (181)
(546)
(5)
888
109
154
15
(33) (81)
(124)
(199)
244
146
168
159
(104) (15)
(455)
(5)
605
75
119
(31)
(35) (143)
(350)
93
698
121
87
107
(172) $9,373 $8,242 $7,628 $6,975 (1,503)
144
(1,666)
43 (1,442)
323
(200)
48 (1,389)
0
(206)
88 (1,312)
0
(170)
50 ($2,982) ($1,271) ($1,507) ($1,432) 60
3,991
(39)
(7,000) 290
1,981
(39)
(7,000) 0
5,222
(1,289)
(8,546) 0
0
(32)
(3,984) Proceeds from sales of common stock
Cash dividends paid to stockholders
Other financing activities 228
(3,031)
4 252
(2,530)
(25) 241
(2,243)
(37) 784
(1,743)
(59) Net cash used by financing activities ($5,787) ($7,071) ($6,652) ($5,034) $604
(111) ($100)
(106) ($531)
(34) $509
(2) Cash and cash equivalents at beginning of year
Cash and cash equivalents at end of year 1,723
$2,216 1,929
$1,723 2,494
$1,929 1,987
$2,494 SUPPLEMENTAL DISCLOSURE OF CASH PAYMENTS MADE FOR
Interest, net of capitalized interest
Income taxes $874
$3,853 $782
$3,435 $639
$2,839 $617
$2,482 Change in Cash and Cash Equivalents
Effect of exchange rate changes on cash and cash equivalents Liquidity Ratios
Calculate the Ratios Below:
Fiscal Year Ended 1/31/2016
Current ratio
1.36
Working capital
Acid-test ratio
Inventory turnover (times)
Days sales in inventory
Accounts receivable turnover (times)
Days sales in receivables
Free cash flow
Average inventory
Average A/R 2/1/2015
1.36 2/2/2014 2/3/2013 Solvency Ratios
Calculate the Ratios Below:
Fiscal Year Ended 1/31/2016
Debt to equity
Interest coverage
Long term liabilities 2/1/2015 2/2/2014 2/3/2013 Profitability Ratios
Calculate the Ratios Below:
Fiscal Year Ended 1/31/2016
Asset turnover
Return on sales
Gross margin %
Return on assets
Return on equity
Average interest rate
Average total assets
Income tax rate
Net of tax interest expense
Adjusted net income
Average equity
Average total liabilities 2/1/2015 2/2/2014 2/3/2013 DuPont Analysis of ROA
Calculate the Ratios Below:
Fiscal Year Ended 1/31/2016
Return on assets (calculated)
Return on sales
Asset turnover
Product 2/1/2015 2/2/2014 Stock Ratios
Calculate the Ratios Below:
Fiscal Year Ended 1/31/2016
Book value per common share
Earnings per share (basic)
Earnings per share (diluted)
P/E Ratio
Dividend yield
Dividend payout
Book value of equity
Common shares outstanding (millions)
Adjusted closing price
Dividends per share 2/1/2015 2/2/2014 2/3/2013 Compatibility Report for ACT 5140 Fall 2016 HW 1 (Excel Info) (1).xls
Run on 9/4/2016 11:50
The following features in this workbook are not supported by earlier versions of
Excel. These features may be lost or degraded when opening this workbook in
an earlier version of Excel or if you save this workbook in an earlier file format. Significant loss of functionality
Any effects on this object will be removed. Any text that overflows the
boundaries of this graphic will appear clipped. # of occurrences
1
Instructions'!A1 Version Excel 97-2003