#### Question Details

##### [solution] » You will see below 4 &quot;green&quot; tabs and 5 &quot;red

Brief item decscription

Step-by-step solution file

Item details:

You will see below 4 &quot;green&quot; tabs and 5 &quot;red
More:

I have completed part one of the assignment, I did all of the calculations. I would just like for someone to complete the assessment which is part two of the assignment and most importantly perform an horizontal analysis of the income statement and balance sheet, vertical is not required. I have attached a previous answer from a course hero person of how this answer should look like or you can look at the Home Depot analysis to help complete the rest of the assignment. It's not difficult, I just do not have the time.

Everything you will need should be attach. If not please let me know. Thank you.

Perform  a horizontal analysis of Lowes Companies income statements and balance sheets as of January 29, 2016.

In performing this analysis, consider any notable trends or changes that you observe that may provide useful information concerning its financial condition. Be as detail as possible.

Also use as many years? worth of statements as you feel are necessary. You should write up your results in paragraph form. Use as many analyses as necessary to show a good picture of the company.

Use the Excel area below to set up your analyses and place text boxes below your Excel analyses to

 Lowes Companies Inc 10-K Income Statement (Horizontal Analysis ONLY) (Amounts in millions except per share data) Fiscal Year Ended 1/29/2016 1/30/2015 1/31/2014 2/1/2013 Net Sales \$  59,074 \$  56,223 \$   53,417 \$  50,521 Cost of Sales 38,504 36,665 34,941 33,194 Gross Margin 20,570 19,558 18,476 17,327 Expenses: Selling, General and Administrative 14,115 13,281 12,865 12,244 Depreciation 1,484 1,485 1,462 1,523 Interest - Net 552 516 476 423 Total Expenses 16,151 15,282 14,803 14,190 Pre-Tax Earnings 4,419 4,276 3,673 3,137 Income Tax Provision 1,873 1,578 1,387 1,178 Net Earnings \$    2,546 \$    2,698 \$     2,286 \$    1,959 Basic EPS \$2.73 \$2.71 \$2.14 \$1.69 Diluted EPS \$2.73 \$2.71 \$2.14 \$1.69 Dividends Per Share \$1.07 \$0.87 \$0.70 \$0.62
 Lowes Companies Inc 10-K Balance Sheet (Horizontal Analysis ONLY) (Amounts in millions) Fiscal Year Ended 1/29/2016 1/30/2015 1/31/2014 2/1/2013 ASSETS Current assets: Cash and cash equivalents \$       405 \$       466 \$       391 \$       541 Short-term investments 307 125 185 125 Merchandise inventories - net 9,458 8,911 9,127 8,600 Other current assets 391 349 341 301 Total current assets \$  10,561 \$    9,851 \$   10,044 \$    9,567 Property, less accumulated depreciation 19,577 20,034 20,834 21,477 Long-term investments 222 354 279 271 Deferred income taxes - net 241 133 - - Other assets 665 1,349 1,323 1,134 Total assets \$  31,266 \$   31,721 \$   32,480 \$  32,449 LIABILITIES AND SHAREHOLDERS EQUITY Current liabilities: Short-term borrowings \$         43 \$         - \$       386 \$         - Current maturities of long-term debt 1,061 552 49 47 Accounts payable 5,633 5,124 5,008 4,657 Accrued compensation & employee benefits 820 773 785 670 Deferred revenue 1,078 979 892 824 Other current liabilities 1,857 1,920 1,756 1,510 Total current liabilities \$  10,492 \$    9,348 \$    8,876 \$    7,708 Long-term debt, excluding current maturities 11,545 10,806 10,086 9,030 Deferred income taxes - net - - 39 238 Deferred revenue - extended protection plans 729 730 730 715 Other liabilities 846 869 896 901 Total liabilties \$  23,612 \$   21,753 \$   20,627 \$  18,592 Shareholders' equity: Common stock \$       455 \$       480 \$       515 \$       555 Capital in excess of par value - - - 26 Retained earnings 7,593 9,591 11,355 13,224 Accumulated other comprehensive income (loss) (394) (103) (17) 52 Total shareholders' equity 7,654 9,968 11,853 13,857 Total liabilities and shareholders equity \$  31,266 \$   31,721 \$   32,480 \$  32,449

Part 2

Ratio Analysis

Assess Lowes Companies concerning liquidity, solvency, profitability, and stock performance as of January 29, 2016. For each area, you should calculate the ratios we discussed in class and provide an analysis of the ratios calculated. It would also be helpful to compare Lowes?s ratios with Home Depot?s ratios. I include historical stock price information and outstanding common share information below.

 Liquidity Ratios Fiscal Year Ended 1/31/2016 2/1/2015 2/2/2014 2/3/2013 Current ratio 1.01 1.05 1.13 1.24 Working capital \$69 \$503 \$1,168 \$1,859 Acid-test ratio 0.07 0.06 0.06 0.09 Inventory turnover (times) 4.19 4.07 3.94 Days sales in inventory 87.06 89.78 92.59 Accounts receivable turnover (times) 273.49 362.73 344.63 Days sales in receivables 1.33 1.01 1.06 Free cash flow \$3,587 \$4,049 \$3,171 \$2,551 Average inventory \$9,184.5 \$9,019.0 \$8,863.5 Average A/R \$216.0 \$155.0 \$155.0

Assessment:

 Solvency Ratios Fiscal Year Ended 1/31/2016 2/1/2015 2/2/2014 2/3/2013 Debt to equity 1.71 1.24 0.99 0.79 Interest coverage 9.01 9.29 8.72 8.42 Long term liabilities \$13,120 \$12,405 \$11,751 \$10,884

Assessment:

 Profitability Ratios Fiscal Year Ended 1/31/2016 2/1/2015 2/2/2014 2/3/2013 Asset turnover \$1.22 \$1.75 \$1.65 Return on sales 4.85% 5.38% 4.83% 4.40% Gross margin % 34.82% 34.79% 34.59% 34.30% Return on assets 9.09% 9.42% 7.95% Return on equity 28.90% 24.73% 17.78% Average interest rate 2.43% 2.44% 2.43% Average total assets \$31,493.5 \$32,100.5 \$32,464.5 Income tax rate 42.39% 36.90% 37.76% 37.55% Net of tax interest expense \$318.03 \$325.58 \$296.25 \$264.16 Adjusted net income \$2,864.0 \$3,023.6 \$2,582.3 \$2,223.2 Average equity \$8,811.0 \$10,910.5 \$12,855.0 Average total liabilities \$22,682.5 \$21,190.0 \$19,609.5

Assessment:

 DuPont Analysis of ROA Fiscal Year Ended 1/31/2016 2/1/2015 2/2/2014 Return on assets (calculated) 9.09% 9.42% 7.95% Return on sales 4.85% 5.38% 4.83% Asset turnover \$1.22 \$1.75 \$1.65 Product 5.93% 9.42% 7.95%

Assessment:

 Stock Ratios Fiscal Year Ended 1/31/2016 2/1/2015 2/2/2014 2/3/2013 Book value per common share \$8.41 \$10.38 \$11.51 \$12.48 Earnings per share (basic) \$2.73 \$2.71 \$2.14 \$1.69 Earnings per share (diluted) \$2.73 \$2.71 \$2.14 \$1.69 P/E Ratio 26.15 24.54 20.88 21.68 Dividend yield 1.50% 1.31% 1.57% 1.69% Dividend payout 39.19% 32.10% 32.71% 36.69% Book value of equity \$7,654 \$9,968 \$11,853 \$13,857 Common shares outstanding (millions) 910 960 1,030 1,110 Adjusted closing price \$71.40 \$66.50 \$44.68 \$36.64 Dividends per share \$1.07 \$0.87 \$0.70 \$0.62

Assessment:

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 s), assess The Home Depot concerning

, you should calculate the ratios we

You do not need to perform vertical 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

mean in the text box. 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

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 \$4,467

Acid-test ratio

0.33

Inventory turnover (times)

5.09

Days sales in inventory

71.70

Accounts receivable turnover (times)

52.47

Days sales in receivables

6.96

Free cash flow \$7,870 2/1/2015

1.36

\$4,033

0.28

4.95

73.74

57.72

6.32

\$6,800 2/2/2014

1.42

\$4,530

0.31

4.77

76.55

56.44

6.47

\$6,239 Average inventory \$11,444.0 \$11,068.0 \$10,883.5

Average A/R \$1,687.0

\$1,441.0 \$1,396.5 2/3/2013

1.34

\$3,910

0.34 \$5,663 Solvency Ratios

Calculate the Ratios Below:

Fiscal Year Ended 1/31/2016

Debt to equity

3.75

Interest coverage

12.81 2/1/2015

2.08

12.61 2/2/2014

1.38

12.89 2/3/2013

0.67

12.29 Long term liabilities \$19,355 \$17,247 \$11,845 \$23,707 Profitability Ratios

Calculate the Ratios Below:

Fiscal Year Ended 1/31/2016

Asset turnover

\$2.15

Return on sales

8.58%

Gross margin % 34.19%

Return on assets 18.41%

Return on equity 89.64%

Average interest rate

2.75% 2/1/2015

\$2.07

8.26%

34.13%

17.08%

58.09%

2.83% 2/2/2014

\$1.93

7.41%

34.15%

14.31%

35.55%

2.77% 2/3/2013

6.60%

34.57% Average total assets \$41,247.5 \$40,232.0 \$40,801.0

Income tax rate 36.40%

36.40%

36.40%

37.20%

Net of tax interest expense \$584.45

\$527.90

\$452.19

\$396.91

\$6,872.9 \$5,837.2 \$4,931.9

Average equity \$7,819.0 \$10,922.0 \$15,149.5

Average total liabilities \$33,428.5 \$29,310.0 \$25,651.5 DuPont Analysis of ROA

Calculate the Ratios Below:

Fiscal Year Ended 1/31/2016

Return on assets (calculated) 18.41% 2/1/2015

17.08% 2/2/2014

14.31% Return on sales

Asset turnover

Product 8.26%

\$2.07

17.08% 7.41%

\$1.93

14.31% 8.58%

\$2.15

18.41% Stock Ratios

Calculate the Ratios Below:

Fiscal Year Ended 1/31/2016

Book value per common share

\$5.04

Earnings per share (basic)

\$5.49

Earnings per share (diluted)

\$5.46

P/E Ratio

22.91

Dividend yield

1.89%

Dividend payout 43.22%

Book value of equity

Common shares outstanding (millions)

Dividends per share \$6,316

1,252

\$125.07

\$2.36 2/1/2015

\$7.13

\$4.74

\$4.71

21.61

1.85%

39.92% 2/2/2014

\$9.07

\$3.78

\$3.76

19.51

2.13%

41.49% 2/3/2013

\$11.96

\$3.03

\$3.00

20.97

1.84%

38.67% \$9,322

1,307

\$101.80

\$1.88 \$12,522

1,380

\$73.34

\$1.56 \$17,777

1,486

\$62.92

\$1.16

STATUS
QUALITY
Approved

This question was answered on: Feb 21, 2020

Solution~00065719662.zip (18.37 KB)