Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

1. what is the price-earnings ratio for the home depot for 2017,2016,2015,2014 2

ID: 2594140 • Letter: 1

Question

1. what is the price-earnings ratio for the home depot for 2017,2016,2015,2014

2. what is the price-earnings ratio for Lowes for 2017,2016,2015,2014.

3.what is the dividend yield for Lowes for 2017,2016,2015,2014.

4.what is the dividend yield for home depot for 2017,2016,2015,2014.

Please show me how you got the result.

Here is a link also for both companies

https://finance.google.com/finance?q=NYSE%3ALOW&fstype=ii&ei=RYMtWvCqK8ep2AbI5KSACg

https://finance.google.com/finance?q=NYSE%3AHD&fstype=ii&ei=gIItWqiBF5CYjAHh6anQCA

H.D (HOME DEPOT)

L (LOWES)

Total Revenue Cost of sale, Total Gross Profit Depreciation/Amortization Total Operating Expense Earning before interest and taxes earning Before Tax Income After Tax Net Income Before Extra. Items 4590088,59.0083,176.0078,812.00 51,897.00 26,915.00 1,754.00 1.690.00 1,640.00 1,627.00 69,646.00 9,166.00 8.467.00 5,385.00 5,385.00 5,385.00 62,282.00 58,254.0054,787.00 28,389.00 32,313.00 30,265.00 81,168.00 13,427.00 12,491.00 7,957.00 7,957.00 7,957.00 76,745.00 1,774.00 11,021.00 7.009.00 7,009.00 7,009.00 72,707.00 10,469.00 9,976.00 6,345.00 6,345.00 6,345.00 Pet.ared Didends Preferred Dividends Income Available to Common Excl. Extra Ite Income Available to Common Incl Extra Iten Basic Weighted Average Shares Basic EPS Excluding Extraordinary Items Basic EPS Including Extraordinary Items Dilution Adjustment Weighted Average Shares Dihuted EPS Excding Extraordinary Items Diluted EPS Including Extraordinary Items Dividends per Share Common Stock Prima Gross Dividends Common Stock Net Income after Stock Based Comp. Expen Basic EPS after Stock Based Comp. Expense 7,957.00 7.957.00 7,009.00 7,009.00 6,345.00 6,345.00 5,385.00 5,385.00 1,234.00 6.45 1,434.00 3.76 1,283.00 1,346.00 2.36 1.88 1.56 Diuted EPS after Stock Based Comp. Expen Depreciation, Supplemental Total Special Items Normalized Income Before Taxes Effect of Special Items on Income Taxes Income Taxes Ex. Impact of Special Items Normalized Income After Taxes Normalized Income Avail to Common Basic Normalized EPS Dinuted Earning per share PS 5.46

Explanation / Answer

1. calculation of Price Earnings ratio for Home depot.

Price Earnings ratio = Market price per share / Earnings per share.

2017: Stock price as on 29/01/2017 is $135.21.

Earnings per share = $6.45 per share

Price Earnings ratio for 2017 = 135.21 / 6.45 = 20.96 times

2016: Stocl price on 31/01/2016 is 120.37

Earnings per share = $5.46

PE Ratio = 120.37 / 5.46 = 22.046 times

2015: Stock price on 01/02/2015 is 97.97

Earnings per share = $4.71

PE Ratio = 97.97 / 4.71 = 20.80 times

2014: Stock price on 02/02/2014 was $70.58

EPS = $3.76

PE Ratio = 70.58 / 3.76 = 18.77 times

2. calculation of Price Earnings ratio for Lowes

2017: Stock price on 03/02/2017 was 80.47

EPS (Normalized) = 3.5

PE ratio = 23 times

2016: Stock on 29/01/2016 was 72.17

EPS = 2.73

PE ratio = 26.43

2015: Stock price on 30/01/2015 was 64.60

EPS = 2.73

PE ratio = 23.66 times

2014: Stock price on 31/01/2014 was 43.41

EPS = 2.17

PE ratio = 20 times

B. Dividend yield is calculated by :

Dividend yield = Dividend paid per share / Market price per share

HD

2017

2016

2015

2014

Dividend paid

2.76

2.36

1.88

1.56

Stock price

135.21.

120.37

97.97

$70.58

Dividend yield

2.04%

1.96%

1.919%

2.21

Lowes

2017

2016

2015

2014

Dividend paid

1.26

1.02

0.82

0.68

Stock price

80.47

72.17

64.60

43.41

Dividend yield

1.565%

1.413%

1.27%

1.566%

HD

2017

2016

2015

2014

Dividend paid

2.76

2.36

1.88

1.56

Stock price

135.21.

120.37

97.97

$70.58

Dividend yield

2.04%

1.96%

1.919%

2.21

Lowes

2017

2016

2015

2014

Dividend paid

1.26

1.02

0.82

0.68

Stock price

80.47

72.17

64.60

43.41

Dividend yield

1.565%

1.413%

1.27%

1.566%