please show work on Question 3 2. The following table shows stock prices (May 1, 2017,...

please show work on Question 3

2. The following table shows stock prices (May 1, 2017, closing), EPS 2016 actual, 2017 forecast, 2018 forecast, and 2016 dividend for the three chemical companies.

	Stock Price	EPS, 2016 Actual	EPS, 2017	EPS, 2018	Dividend
DuPont	79.49	2.77	3.84	4.09	1.52
Dow	62.52	3.52	4.07	4.41	1.84
PPG	109.46	5.82	6.26	6.92	1.56

Given the information above, calculate PE for the three definitions of EPS, dividend yield, and dividend payout.

	Price/Actual EPS	Price/2017 EPS	Price/2018 EPS	Dividend Yield	Dividend Payout
DuPont	28.70	20.70	19.44	1.91%	54.87%
Dow	17.76	15.36	14.18	2.94%	52.27%
PPG	18.81	17.49	15.82	1.43%	26.80%


3. The following table shows historical and projected annual earnings growth rates.

	5-Year Historic Earnings Growth Rates	5-Year Projected Earnings Growth Rates
DuPont	-2.43%	8.06%
Dow	17.39%	6.96%
PPG	10.36%	9.54%

Calculate PE to earnings growth rates (PEG), using the information above and calculations from Question 2.

	Current PE / 5-Yr Historic Growth	1-Yr Ahead PE Forecast / 5-Yr Projected Growth	2-Yr-Ahead PE Forecast / 5-Yr Projected Growth
DuPont	-3.32
Dow	0.40
PPG	0.92

Expert Solution


	Current PE / 5-Yr Historic Growth	1-Yr Ahead PE Forecast / 5-Yr Projected Growth	2-Yr-Ahead PE Forecast / 5-Yr Projected Growth
DuPont	-3.32	2.57	2.41
Dow	0.4	2.21	2.04
PPG	0.92	1.83	1.66


	Formula for PEG = PE ratio/Earnings growth rate

jeff jeffy answered 2 years ago

Part 1: The following table shows historical stock prices of Spider S&P 500 ETF and Amazon...

Part 1: The following table shows historical stock prices of Spider S&P 500 ETF and Amazon stock. The prices listed are the adjusted closing prices on the first day of each month from 9/1/2016 to 8/1/2018. The monthly risk-free rates for the T-bills are also listed in the table. Using the price data, calculate the monthly returns for the Spider S&P 500 ETF and the Amazon stock, respectively, from September 2016 to July 2018 (note that the monthly return for...

Please solve all of the questions, questions 1, 2, and 3. Please show all work and...

Please solve all of the questions, questions 1, 2, and 3. Please show all work and all steps. 1.) Find x(t) = Σ aktk such that tx'' = x 2.) Find x(t) = Σk>=0 aktk such that x'' = tx + 1 and x(0) = 0, x'(0) = 1 3.) Using the Frobenius method, solve t2x'' - 3tx' + (4-t)x = 0

The following table shows the past annual returns for Stock A and Stock B, please find...

The following table shows the past annual returns for Stock A and Stock B, please find the expected return, standard deviation and coefficient of variation for Stock A, Stock B and a Portfolio that puts 40% weight on Stock A and 60% weight on Stock B. Year Stock A Returns Stock B Returns 2005 10.30% 10.71% 2006 -0.10% 25.00% 2007 23.30% 0.38% 2008 2.20% 26.20% 2009 14.00% 11.52%

The following table shows historical end-of-week adjusted close prices (including dividends) for a stock and the...

The following table shows historical end-of-week adjusted close prices (including dividends) for a stock and the S&P 500. A B C 1 Week Stock S&P 500 2 0 39.53 2,758 3 1 40.17 2,700 4 2 43.1 2,742 5 3 42.47 2,783 6 4 39.77 2,836 7 5 42.07 2,762 8 6 43.84 2,829 9 7 39.77 2,768 10 8 40.1 2,866 11 9 40.98 3,019 12 10 42.15 2,982 2. What is the geometric average weekly return for the...

The following table lists the month-end prices from May 2017 to July 2018 of the Spider...

The following table lists the month-end prices from May 2017 to July 2018 of the Spider S&P 500 Index ETF (SPY) and iShares 20+ Treasury Bond ETF (TLT), respectively. During this time period the average annual yield for the one-month Treasury bills is 1.292% or 0.1077% per month. Apply the following equation to calculate the monthly returns from June 2017 to July 2018 for SPY and TLT, respectively. The monthly return for month n: rn = (Current month-end price –...

Show work, no Exel/Spss please!!!! Variable B Variable A 1 2 3 ...

******Show work, no Exel/Spss please!!!!****** Variable B Variable A 1 2 3 1 5 4 4 2 6 9 1 3 7 4 1 5 2 3 4 2 6 6 5 2 7 7 3 4 5 3 3 4 2 3 8 1. Given the following data, what is the value of F crit for the column effect (variable b) *Hint: don't forget to evaluate a numerator (for variable B) and denominator df (within):...

Suppose the following table shows information on the market basket for the CSPI and the prices of each of the goods in 2017, 2018, and 2019

1. Calculating inflation using a simple price index Consider a fictional price index, the College Student Price Index (CSPI), based on a typical college student's annual purchases. Suppose the following table shows information on the market basket for the CSPI and the prices of each of the goods in 2017, 2018, and 2019. The cost of each item in the basket and the total cost of the basket are shown for 2017. Perform these same calculations for 2018 and 2019, and enter the...

Please show all the work Question 1 A manufacturer produces umbrellas with the following parameters: The...

Please show all the work Question 1 A manufacturer produces umbrellas with the following parameters: The monthly demand for umbrellas is 3000 Daily usage is 100 (assume 1 month = 30 days and demand is uniform throughout the month) The production rate is 400 per day Setup cost is $200 for a run Holding cost is $1 per umbrella per month What is the economic production quantity? Question 2 Suppose a gas station has expected sales of 6000 gallons during...

Use the data in Table 2.0, answer questions 1, 2, & 3. Please show all of...

Use the data in Table 2.0, answer questions 1, 2, & 3. Please show all of your working. Table 2.0 Data for a sample of 50 individual in a Cardiovascular Disease Study Participant ID Weight (kg) Height (cm) Smoking status Blood glucose 1 70 165 1 107 2 60 162 0 145 3 62 150 1 237 4 66 165 1 91 5 70 162 0 185 6 59 165 0 106 7 47 160 0 177 8 66 170...

PLEASE SHOW YOUR WORK WITH FORMULAS. 1.At the end of the year 2017 the assets of...

PLEASE SHOW YOUR WORK WITH FORMULAS. 1.At the end of the year 2017 the assets of the company X were 400 mill EUR and equity was 300 mill EUR. At the end of the year 2018 assets in the same company were 500 mill EUR and equity was 400 mill. The net profit in 2018 was 100 mill EUR. a)Calculate ROA and ROE for the year 2018. b)What was indebtedness in the years 2017 and 2018? c)What is the change...

Question