Question Details

(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:

 

yessman@nova.edu 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

 


Solution details:

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Sep 13, 2020

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP/h4>

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • As a reference for in-depth understanding of the subject.
  • As a source of ideas / reasoning for your own research (if properly referenced)
  • For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN A DEADLINE.

Order Now