A. use any data source to find the annual cash dividend. if any. paid by the...

A. use any data source to find the annual cash dividend. if any. paid by the company in each of the past five calendar years.
B. find the closing price of the stock for 6 years
C. calculate the return for each of the five one year periods
D. create a graph that shows the return on an x and y axis.
E. estimate the return for the coming year and explain why.
use the company PepsiCo

show all work

Expert Solution

A)

Cash dividend paid history (Source: nasdaq.com)

EX/EFF DATE	TYPE	CASH AMOUNT	DECLARATION DATE	RECORD DATE	PAYMENT DATE
09-05-19	Cash	$0.96	07-11-19	09-06-19	09/30/2019
06-06-19	Cash	$0.96	04/30/2019	06-07-19	06/28/2019
02/28/2019	Cash	$0.93	02/13/2019	03-01-19	03/29/2019
12-06-18	Cash	$0.93	11/15/2018	12-07-18	01-07-19
09-06-18	Cash	$0.93	07/13/2018	09-07-18	09/28/2018
05/31/2018	Cash	$0.93	05-01-18	06-01-18	06/29/2018
03-01-18	Cash	$0.81	02-05-18	03-02-18	03/30/2018
11/30/2017	Cash	$0.81	11/17/2017	12-01-17	01-08-18
08/30/2017	Cash	$0.81	07/14/2017	09-01-17	09/29/2017
05/31/2017	Cash	$0.81	05-02-17	06-02-17	06/30/2017
03-01-17	Cash	$0.75	02-02-17	03-03-17	03/31/2017
11/30/2016	Cash	$0.75	11/17/2016	12-02-16	01-06-17
08/31/2016	Cash	$0.75	07/14/2016	09-02-16	09/30/2016
06-01-16	Cash	$0.75	05-03-16	06-03-16	06/30/2016
03-02-16	Cash	$0.70	02-04-16	03-04-16	03/31/2016
12-02-15	Cash	$0.70	11/19/2015	12-04-15	01-07-16
09-02-15	Cash	$0.70	07/16/2015	09-04-15	09/30/2015
06-03-15	Cash	$0.70	05-05-15	06-05-15	06/30/2015
03-04-15	Cash	$0.66	02-05-15	03-06-15	03/31/2015
12-03-14	Cash	$0.66	11/20/2014	12-05-14	01-07-15
09-03-14	Cash	$0.66	07/17/2014	09-05-14	09/30/2014
06-04-14	Cash	$0.66	05-06-14	06-06-14	06/30/2014
03-05-14	Cash	$0.57	02-06-14	03-07-14	03/31/2014
12-04-13	Cash	$0.57	11/21/2013	12-06-13	01-02-14
09-04-13	Cash	$0.57	07/19/2013	09-06-13	09/30/2013
06-05-13	Cash	$0.57	04/30/2013	06-07-13	06/28/2013
02/27/2013	Cash	$0.54	02-07-13	03-01-13	03/29/2013

B)

Monthly Closing price of the stock for past 6 years

Date	Close	Adj Close
01-11-13	84.46	70.89
01-12-13	82.94	69.61
01-01-14	80.36	67.91
01-02-14	80.07	67.66
01-03-14	83.50	70.56
01-04-14	85.89	73.09
01-05-14	88.33	75.17
01-06-14	89.34	76.03
01-07-14	88.10	75.53
01-08-14	92.49	79.30
01-09-14	93.09	79.81
01-10-14	96.17	83.04
01-11-14	100.10	86.43
01-12-14	94.56	81.65
01-01-15	93.78	81.51
01-02-15	98.98	86.03
01-03-15	95.62	83.11
01-04-15	95.12	83.23
01-05-15	96.43	84.37
01-06-15	93.34	81.67
01-07-15	96.35	84.93
01-08-15	93.60	82.50
01-09-15	94.30	83.12
01-10-15	102.19	90.77
01-11-15	100.16	88.97
01-12-15	99.92	88.76
01-01-16	99.30	88.82
01-02-16	97.82	87.50
01-03-16	102.48	91.67
01-04-16	102.96	92.75
01-05-16	101.17	91.14
01-06-16	105.94	95.44
01-07-16	108.92	98.86
01-08-16	106.75	96.89
01-09-16	108.77	99.42
01-10-16	107.20	97.99
01-11-16	100.10	91.50
01-12-16	104.63	96.34
01-01-17	103.78	95.56
01-02-17	110.38	101.64
01-03-17	111.86	103.00
01-04-17	113.28	105.03
01-05-17	116.87	108.35
01-06-17	115.49	107.81
01-07-17	116.61	108.86
01-08-17	115.73	108.03
01-09-17	111.43	104.75
01-10-17	110.23	103.62
01-11-17	116.52	109.53
01-12-17	119.92	113.51
01-01-18	120.30	113.87
01-02-18	109.73	103.87
01-03-18	109.15	103.32
01-04-18	100.94	96.25
01-05-18	100.25	95.59
01-06-18	108.87	104.77
01-07-18	115.00	110.67
01-08-18	112.01	107.79
01-09-18	111.80	107.59
01-10-18	112.38	109.04
01-11-18	121.94	118.32
01-12-18	110.48	107.20
01-01-19	112.67	110.19
01-02-19	115.64	113.09
01-03-19	122.55	120.82
01-04-19	128.05	126.25
01-05-19	128.00	126.20
01-06-19	131.13	129.28
01-07-19	127.81	126.93
01-08-19	136.73	135.79
01-09-19	137.10	136.16
01-10-19	136.96	136.96
18-10-19	136.45	136.45

C)

Five one year returns of the stock

Year	Return
2013 - 2014	22%
2014 - 2015	3%
2015 - 2016	3%
2016 - 2017	20%
2017 - 2018	8%
2018 - 2019	15%

D)

Graphs:

For your reference:

jeff jeffy answered 1 week ago

The company has paid a constant cash dividend of 7$ on an annual basis for the...

The company has paid a constant cash dividend of 7$ on an annual basis for the last decade. For the dividend payment it used all its earnings. The business outlook is stable with no growth. Currently there are 250.000 outstanding shares at 50$ per share. The company earned again just about the right amount to pay its dividend. The CFO decides to switch instantly from cash dividends to repurchases for this year (T0). Project and compare the stock price for...

Dragon Trucking just paid its annual regular cash dividend of $4.04 a share, along with a...

Dragon Trucking just paid its annual regular cash dividend of $4.04 a share, along with a special dividend of $0.57 a share. The company follows a policy of increasing its dividend by 4.6 percent annually. Which one of the following is the best estimate of the firm's next annual dividend payment?

Please find any two articles from any source (google or any other source, please mention the...

Please find any two articles from any source (google or any other source, please mention the source), each of which satisfies one of the criteria below. Do not use two articles with the same analytical technique. The article uses correlation or multiple regression. The article uses a cluster analysis. Describe the purpose of each of the two articles. Explain how the complex analysis used satisfies this purpose, and what it demonstrates. The limit is one page (300 words) per article.

A company just paid out an annual dividend of $4. If the dividend will grow by...

A company just paid out an annual dividend of $4. If the dividend will grow by 20% for each of the next 2 years, and by 7% annually thereafter, what should be the price of a share today? Assume that the required rate of return for the stock is 15%. $60.00 $66.78 $71.14 $55.65

A stock just paid an annual dividend of $2.7. The dividend is expected to grow by...

A stock just paid an annual dividend of $2.7. The dividend is expected to grow by 6% per year for the next 4 years. The growth rate of dividends will then fall steadily by 0.25% per year, from 6% in year 4 to 5% in year 8 and stay at that level forever. The required rate of return is 12%. What is the expected dividend in 8 years? What is the expected stock price in 8 years? What should be...

A stock just paid an annual dividend of $1.4. The dividend is expected to grow by...

A stock just paid an annual dividend of $1.4. The dividend is expected to grow by 10% per year for the next 4 years. The growth rate of dividends will then fall steadily from 10% after 4 years to 4% in year 8. The required rate of return is 12%. Question: 1. What is the stock price if the dividend growth rate will stay 4% forever after 8 years? 2. In 8 years, the P/E ratio is expected to be...

A stock just paid an annual dividend of $1.6. The dividend is expected to grow by...

A stock just paid an annual dividend of $1.6. The dividend is expected to grow by 9% per year for the next 4 years. The growth rate of dividends will then fall steadily from 9% after 4 years to 4% in year 8. The required rate of return is 12%. What is the stock price if the dividend growth rate will stay 4% forever after 8 years?

Condensed financial data of Monopoly Corporation appear below: A cash dividend was declared and paid in...

Condensed financial data of Monopoly Corporation appear below: A cash dividend was declared and paid in full to stockholders during the year. Required: Solve for the missing numbers. Balance Sheet Income Stmt Cash Flow Stmt Solve for the missing numbers. MONOPOLY CORPORATION Comparative Balance Sheet December 31 Current Year Prior Year Assets Cash $34,040 $22,400 Accounts receivable 31,600 Inventories 69,600 Prepaid rent 2,060 1,600 Property, plant, and equipment 218,000 196,000 Accumulated depreciation (52,600) (38,000) Total assets $324,300 $283,200 Liabilities and...

The last dividend paid by New Technologies was an annual dividend of $1.40 a share. Dividends...

The last dividend paid by New Technologies was an annual dividend of $1.40 a share. Dividends for the next 3 years will be increased at an annual rate of 8 percent. After that, dividends are expected to increase by 3 percent each year. The discount rate is 16 percent. What is the current value of this stock?

JAM Co just paid a dividend of $5.00, and expects an annual dividend growth rate of...

JAM Co just paid a dividend of $5.00, and expects an annual dividend growth rate of 5% indefinitely. What is the expected dividend a year from now? XYZ Co just paid a dividend of $3.00, and expects an annual dividend growth rate of 5% indefinitely. What is the expected dividend a year from now? PDQ Co just paid a dividend of $2.00, and expects an annual dividend growth rate of 6% indefinitely. What is the expected dividend a year from now? RAM Co...

Question