Question Details

[solution] » You will see below 4 "green" tabs and 5 "red

Brief item decscription

Step-by-step solution file


Item details:

You will see below 4 "green" tabs and 5 "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

explain your answer.

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 "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 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

 

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 Remember, ratio answers in the boxes and written answers on w

 

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

 

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 boxes and written answers on what the 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 $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

 

Adjusted net income $7,593.5

 

$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)

 

Adjusted closing price

 

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

 







About this question:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Feb 21, 2020

PRICE: $24

Solution~00065719662.zip (18.37 KB)

Buy this answer for only: $24

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free copy (Deadline assured. Flexible pricing. TurnItIn Report provided)

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

Need a similar solution fast, written anew from scratch? Place your own custom order

We have top-notch tutors who can help you with your essay at a reasonable cost and then you can simply use that essay as a template to build your own arguments. This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student. New solution orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

Order Now