## (solution) You will see below 4 &quot;green&quot; tabs and 5 &quot;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 &quot;green&quot; tabs and 5 &quot;red tabs&quot;. 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

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

Long-Term

Profitability

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:

yessman@nova.edu ed for Red Tab Answers nswers in these tabs

ired

your calculations for the ratio required

Fiscal Year Ended 1/31/2016 2/1/2015 2/2/2014 2/3/2013

\$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:

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 &amp; Equipment, at cost

Less Accumulated Depreciation and Amortization

Net Property &amp; 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 &amp; 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

Proceeds from sales of property &amp; 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

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)

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

Solution details:

STATUS

QUALITY

Approved

Sep 13, 2020

EXPERT

Tutor