I need the dollar change ratio, percent change, trend percent, common size perce

Question

I need the dollar change ratio, percent change, trend percent, common size percent, current ratio, acid test ratio, accounts receivable turnover inventory turn over,days sales incollected, days sales in inventory, total asset turnover debt to equity, times interest earned, to be checked to make sure they are right if it isnt please show me the right work! Thank you ratios used are for 2016 and 2017

THE HOME DEPOT, INC. AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF EARNINGS Pscal Year Eade Jeneary NET SALES Cost of Sales GROSS PROFIT Operating Expenses: 29, Janeary 31,Febroery I $ 94,595 88,519 83,176 54,787 30,26528,389 62,282 58,254 32,313 7,13216,801 Selling, General and Administrative Depreciation and Amortization 1,690 18,491 13,42711,774 10469 1,754 18,886 16,280 1,640 7,920 Total Opcrating Expenses OPERATING INCOME Interest and Other (Income) Expense: Interest and investment Income Intcrest Expense (36) 972 936 337) 830 493 919 753 Interest and Other, net EARNINGS BEFORE PROVISION FOR INCOME TAXES Provision for Income Taxes NET EARNINGS 11,021 4.012 S 7.957$ 7,009 9.976 ,631 6343 4,534 1,338 S 647 S 549 S4.74 2831:346 1.229 1,277 -- Weighted Average Common Shares BASIC EARNINGS PER SHARE 1,234 Diluted Weighted Average Common Shares DILETED EARNINGS PER SHARE S 6.45S 5.46 .71 Fiscal years ended Janmary 29.2017, January 31. 2016 and February i 2015 imcluste 52 weeks

Explanation / Answer

THE HOME DEPOT INC AND SUBSIDIARIES

CONSOLIDATED STATEMENT OF EARNINGS

Fiscal Ended

Amount in Millions

January 29, 2017

Change % 2017

January 31, 2016

Change % 2016

February 01, 2015

Net Sales

$94,595

6.9%

$88,519

6.4%

$83,176

Cost of Sales

$62,282

6.9%

$58,254

6.3%

$54,787

Gross Profit

$32,313

6.8%

$30,265

6.6%

$28,389

Operating Expenses

Selling, General and Administrative

$17,132

2.0%

$16,801

3.2%

$16,280

Depreciation and Amortization

$1,754

3.8%

$1,690

3.0%

$1,640

Total Operating Expenses

$18,886

2.1%

$18,491

3.2%

$17,920

Operating Income

$13,427

14.0%

$11,774

12.5%

$10,469

Interest and Other Income (Expense)

Interest and Investment Income

($36)

-78.3%

($166)

-50.7%

($337)

Interest Expense

$972

5.8%

$919

10.7%

$830

Interest and Other, net

$936

24.3%

$753

52.7%

$493

Earnings before Provision for Income Taxes

$12,491

13.3%

$11,021

10.5%

$9,976

Provision for Income taxes

$4,534

13.0%

$4,012

10.5%

$3,631

Net Earnings

$7,957

13.5%

$7,009

10.5%

$6,345

CONSOLIDATED BALANCE SHEETS:

Fiscal Ended

Amount in Millions

January 29, 2017

Change % 2017

January 31, 2016

Change % 2016

February 01, 2015

ASSETS

Current Assets

Cash and cash equivalents

$2,538

14.5%

$2,216

28.6%

$1,723

Receivables (net)

$2,029

7.4%

$1,890

27.4%

$1,484

Merchandise Inventories

$12,549

6.3%

$11,809

6.6%

$11,079

Other current assets

$608

6.9%

$569

-44.0%

$1,016

Total Current Assets

$17,724

7.5%

$16,484

7.7%

$15,302

Property, Plant and Equipment, at Cost

$40,426

3.0%

$39,266

2.0%

$38,513

Less: Accumulated depreciation and amortisation

$18,512

8.4%

$17,075

8.1%

$15,793

Net Property and Equipment

$21,914

-1.2%

$22,191

-2.3%

$22,720

Goodwill

$2,093

-0.4%

$2,102

55.4%

$1,353

Other Assets

$1,235

3.3%

$1,196

109.5%

$571

Total Assets

$42,966

2.4%

$41,973

5.1%

$39,946

LIABILITY AND STOCKHOLDERS EQUITY:

Current Liabilities

Short term debt

$710

102.9%

$350

20.7%

$290

Accounts payable

$7,000

6.6%

$6,565

13.1%

$5,807

Accrued Salaries and other expenses

$1,484

-2.0%

$1,515

8.9%

$1,391

Sales tax payable

$508

6.7%

$476

9.7%

$434

Deferred revenue

$1,669

6.6%

$1,566

6.7%

$1,468

Income taxes payable

$25

-26.5%

$34

-2.9%

$35

Current maturities of long term debt

$542

603.9%

$77

102.6%

$38

Other accrued expenses

$2,195

13.1%

$1,941

7.5%

$1,806

Total current liabilities

$14,133

12.8%

$12,524

11.1%

$11,269

Long term debt excluding current instalments

$22,349

7.5%

$20,789

23.2%

$16,869

Other long term liabilities

$1,855

-5.6%

$1,965

6.6%

$1,844

Deferred income taxes

$296

-21.9%

$379

-41.0%

$642

Total Liabilities

$38,633

8.3%

$35,657

16.4%

$30,624

STOCKHOLDER'S EQUITY

Common Stock

$88

0.0%

$88

0.0%

$88

Paid-in Capital

$9,787

4.7%

$9,347

5.2%

$8,885

Retained Earnings

$35,519

14.7%

$30,973

14.7%

$26,995

Accumulated other comprehensive loss

($867)

-3.5%

($898)

98.7%

($452)

Treasury Stock

($40,194)

21.1%

($33,194)

26.7%

($26,194)

Total Stockholder's Equity

$4,333

-31.4%

$6,316

-32.2%

$9,322

Total Liability And Stockholders Equity

$42,966

2.4%

$41,973

5.1%

$39,946

Note: 2015 base numbers are taken from the Annual Report of The Home Depot Inc

Ratios

2017

2016

Current Ratio

1.25

1.32

17,724 / 14,133

16,484 / 12,524

Acid Test Ratio

0.32

0.33

(2,538 + 2,029) / 14,133

(2,216 + 1,890) / 12,524

Note: Short term investments are not available in this Company balance sheet

Accounts receivable Turnover

48.28

52.47

94,595 / ((2,029 + 1,890) / 2)

88,519 / ((1,890 + 1,484) / 2)

Inventory Turnover

5.11

5.09

62,282 / ((12,549 + 11,809) / 2)

58,254 / ((11,809 + 11,079) / 2)

Days sales uncollected

7.56

6.96

1 / 48.28 * 365

1 / 52.47 * 365

Note: Value would be same if it is calculated as per formula given as well

Days sales in inventory

71.43

71.71

1 / 5.11 * 365

1 / 5.09 * 365

Note: Value would be same if it is calculated as per formula given as well

Total asset turnover

2.23

2.16

94,595 / ((42,966 + 41,973) / 2)

88,519 / ((41,973 + 39,946) / 2)

Debt to equity

8.92

5.65

38,633 / 4,333

35,657 / 6,316

Times interest earned

13.81

12.81

13,427 / 972

11,774 / 919

Note: Formulas given in the question are considered for all ratios calculations above.

Fiscal Ended

Amount in Millions

January 29, 2017

Change % 2017

January 31, 2016

Change % 2016

February 01, 2015

Net Sales

$94,595

6.9%

$88,519

6.4%

$83,176

Cost of Sales

$62,282

6.9%

$58,254

6.3%

$54,787

Gross Profit

$32,313

6.8%

$30,265

6.6%

$28,389

Operating Expenses

Selling, General and Administrative

$17,132

2.0%

$16,801

3.2%

$16,280

Depreciation and Amortization

$1,754

3.8%

$1,690

3.0%

$1,640

Total Operating Expenses

$18,886

2.1%

$18,491

3.2%

$17,920

Operating Income

$13,427

14.0%

$11,774

12.5%

$10,469

Interest and Other Income (Expense)

Interest and Investment Income

($36)

-78.3%

($166)

-50.7%

($337)

Interest Expense

$972

5.8%

$919

10.7%

$830

Interest and Other, net

$936

24.3%

$753

52.7%

$493

Earnings before Provision for Income Taxes

$12,491

13.3%

$11,021

10.5%

$9,976

Provision for Income taxes

$4,534

13.0%

$4,012

10.5%

$3,631

Net Earnings

$7,957

13.5%

$7,009

10.5%

$6,345

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.