Question

In: Finance

For the 3 companies, what conclusions can you make about the trends? 2014 2015 2016 2017...

For the 3 companies, what conclusions can you make about the trends?

2014

2015

2016

2017

2018

Stock Price

Ford

$15.50

$10.95

$10.61

$11.62

$7.52

General Motors

$29.67

$29.49

$32.16

$42.66

$33.46

Honda

$26.70

$29.40

$27.70

$22.89

$26.44

PE Ratio

Ford

15.50

6.93

9.23

6.02

8.17

General Motors

17.98

4.99

5.36

n/a

6.05

Honda

8.67

11.95

12.31

4.41

7.07

EPS

Ford

$1.00

$1.58

$1.15

$1.93

$0.92

General Motors

$1.65

$5.91

$6.00

-$2.60

$5.53

Honda

$3.08

$2.46

$2.25

$5.19

$3.74

Solutions

Expert Solution

PE ratio = Market price per share / Earnings per share

PE ratio helps investors analyze how much investor should pay for a stock based on it's earnings. A company with high PE ratio usually indicated positive future performance and investors are willing to pay more for this company's share.

i) Ford :

Stock price of Ford company is in decreasing trend & at the same time earnings are in increasing trend upto year 2017 but in 2018 it suddenly got decreased. Further PE ratio is decreasing approx 50% rate over years.

This indicates inefficient performance of Ford.

ii) General Motors :

General motors price & earnings are in increasing trend except in year 2017. The trends are in such a way that it results into decrease in PE ratio approx. 3 times than it was in 2014.

This results into weak performance of General Motors in terms of PE ratio.

iii) Honda :

Honda's stock price & earnings are in opposite trend. When stock price increases then earning decreases & vice versa. PE ratio is increasing upto year 2016 & then lower PE ratio in 2017 again increased in 2018. The trends of PE ratio shows an average rate.

This indicates average satisfactory performance of Honda.


Related Solutions

Exercise 17-3 Computation and analysis of trend percents LO P1 2017 2016 2015 2014 2013 Sales...
Exercise 17-3 Computation and analysis of trend percents LO P1 2017 2016 2015 2014 2013 Sales $ 441,811 $ 292,590 $ 239,828 $ 168,300 $ 127,500 Cost of goods sold 232,292 153,697 128,061 89,366 66,300 Accounts receivable 21,339 17,146 16,428 9,829 8,708
2018 2017 2016 2015 2014 Sales $ 80,000 $ 73,000 $ 61,000 $ 57,000 $ 50,000...
2018 2017 2016 2015 2014 Sales $ 80,000 $ 73,000 $ 61,000 $ 57,000 $ 50,000 Cost of goods sold 72,600 53,400 45,600 33,300 30,000 Dollar amounts stated above are in thousands. a. Compute trend percentages for the above items taken from the financial statements of Lopez Plumbing over a five-year period. Treat 2014 as the base year. b. State whether the trends are favorable or unfavorable. Required A Required B Compute trend percentages for the above items taken from...
2018 2017 2016 2015 2014 Sales $ 672,729 $ 434,019 $ 347,215 $ 242,808 $ 181,200...
2018 2017 2016 2015 2014 Sales $ 672,729 $ 434,019 $ 347,215 $ 242,808 $ 181,200 Cost of goods sold 332,087 214,419 173,535 120,176 88,788 Accounts receivable 32,560 25,434 23,715 14,180 12,376 Compute trend percents for the above accounts, using 2014 as the base year. (Round the percents to whole numbers.)
2017 2016 2015 2014 2013 Sales $ 699,332 $ 466,221 $ 368,554 $ 252,434 $ 189,800...
2017 2016 2015 2014 2013 Sales $ 699,332 $ 466,221 $ 368,554 $ 252,434 $ 189,800 Cost of goods sold 352,166 234,761 187,327 128,167 94,900 Accounts receivable 33,918 27,227 25,283 14,767 13,001 Compute trend percents for the above accounts, using 2013 as the base year. Trend Percent for Net Sales: Choose Numerator: / Choose Denominator: / = Sales 2017: / = % 2016: / = % 2015: / = % 2014: / = % Trend Percent for Cost of Goods...
Pepsi 2013 2014 2015 2016 2017 Sales/Revenue 66.42B 66.68B 63.05B 62.8B 63.53B Coca-Cola 2013 2014 2015...
Pepsi 2013 2014 2015 2016 2017 Sales/Revenue 66.42B 66.68B 63.05B 62.8B 63.53B Coca-Cola 2013 2014 2015 2016 2017 Sales/Revenue 46.76B 46B 43.7B 41.38B 35.02B Using the year 2013-2017 financial data of Coca-Cola and PepsiCo companies, determine their 5-year average growth rates related to net sales and income from continuing operations. Coca Cola: Net Sales: 7.86% Increase. PepsiCo: Net Sales: 3.11% Increase. And what data to use to calculate.
Innovative Components, Inc. reported the following income statement data for 2013-2017.    2017 2016 2015 2014 2013...
Innovative Components, Inc. reported the following income statement data for 2013-2017.    2017 2016 2015 2014 2013 Net Sales $3,144.6 $2,993.1 $2,790.5 $2,654.0 $2,478.9 What would be an appropriate sales growth rate based on the historical data?
(3) Discussion of finance and accounting and Apple. What conclusions can draw about Apple and the...
(3) Discussion of finance and accounting and Apple. What conclusions can draw about Apple and the evolution of their business during this timeframe? Do you believe the same dynamics exist today? How would you determine that? (4) We are now in the midst of one of the largest periods of employment loss since the great depression. Walmart and Amazon have announced they will hire 250,000 workers. based on greater online shopping demand. Still, most other industries continued to see a...
WIPER, INC. Condensed Balance Sheets December 31, 2017, 2016, 2015 (in millions) 2017 2016 2015 Current...
WIPER, INC. Condensed Balance Sheets December 31, 2017, 2016, 2015 (in millions) 2017 2016 2015 Current assets $ 683 $ 915 $ 763 Other assets 2,416 1,923 1,722 Total assets $ 3,099 $ 2,838 $ 2,485 Current liabilities $ 576 $ 806 $ 713 Long-term liabilities 1,513 1,003 851 Stockholders’ equity 1,010 1,029 921 Total liabilities and stockholders' equity $ 3,099 $ 2,838 $ 2,485 WIPER, INC Selected Income Statement and Other Data For the year Ended December 31, 2017...
What is the Interpretation between the two companies' ratios for The 2015 & 2016 Celgene &...
What is the Interpretation between the two companies' ratios for The 2015 & 2016 Celgene & 2015 & 2016 Gilead Financial statements used to calculate these ratios. Gilead Sciences Inc. Celgene Corp. Earnings per Share of Common Stock (basic - common) As given in the income statement $           10.08 $             2.57 Current Ratio Current Assets $20,445.0 = 2.22 $10,867.5 = 3.67 Current Liabilities $9,219.0 $2,959.2 Gross (Profit) Margin Percentage Gross Margin $26,129.0 = 86.0% $10,746.6 = 96.1% Net Sales $30,390.0...
Time series is given: Year 2012 2013 2014 2015 2016 2017 2018 2019 Amount 65 61...
Time series is given: Year 2012 2013 2014 2015 2016 2017 2018 2019 Amount 65 61 73 68 67 72 75 70 Calculate and interpret the characteristics of it; Make the time series next value forecast by using any method.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT