Historical returns for large company stocks

Reference no: EM13216659

The following table shows the historical returns for large company stocks from 1980-1999. Let's find the average return and the standard deviation of the large firm returns.

Data: Yearly Historical Returns for U. S. Large Company Stocks 1980-1999.

	Year	Large Company Stocks
	1980	32.61%			Step 1: Average Return
	1981	-4.97%
	1982	21.67%			Calculate the historical average return for large co. stocks
	1983	22.57%
	1984	6.19%			Use the Excel function: =average(cell range)/100
	1985	31.85%			We need to divide by 100 because the values are in per cent.
	1986	18.68%
	1987	5.22%			A. In cell J116 enter: = average(C108:C127)
	1988	16.58%
	1989	31.75%
	1990	-3.13%			Step 2: Return Distribution
	1991	30.53%
	1992	7.62%			Calculate the variance and standard deviation of large firm
	1993	10.07%			historical returns.
	1994	1.27%
	1995	37.80%			Variance is the average of the squared deviations from the mean.
	1996	22.74%			We calculate the deviation of each individual return from the mean (average), square those numbers, sum the squares, and then divide
	1997	33.43%
	1998	28.13%			by the number of returns minus one.
	1999	21.03%
					The standard deviation is the square root of the variance. It is in
					percentage form and is used to make comparisons.


	Year	Large Co. Return	Average Return	Deviation	Squared Deviation
1	1980	32.61%
2	1981	-4.97%
3	1982	21.67%
4	1983	22.57%				Steps for calculating standard deviation:
5	1984	6.19%
6	1985	31.85%				Hint: range means a row or column of cells
7	1986	18.68%
8	1987	5.22%				A. Enter the 1980-1999 historical average
9	1988	16.58%				from J116. Copy from year 1 to 20.
10	1989	31.75%
11	1990	-3.13%				B. Find the yearly deviation by subtracting
12	1991	30.53%				the average return from the Lg Co Ret.
13	1992	7.62%				Copy from year 1 to 20.
14	1993	10.07%
15	1994	1.27%				C. Find the squared deviation by multiplying
16	1995	37.80%				the deviation by itself. Copy.
17	1996	22.74%
18	1997	33.43%				D. In cell F153 enter: =sum(range)/(20-1)
19	1998	28.13%
20	1999	21.03%				E. In cell F154 take the square root of F153
	st dev			variance		Enter: = sqrt(F153)
				st dev


	F. We can use the built-in formula: in cell C153 enter: =stdev(range). C153 should be equal to F154 (13.13%).


Test Your Skills:

	Question 1:	A stock had annual returns of 9 percent, -5 percent, 14 percent, 16 percent, 11 percent, & 12 percent
		each for the past six years. What is the average return and standard deviation for this
		stock?

			Year	Return
			1
			2
			3
			4
			5
			6

		Average return
		Standard deviation


	Question 2:	A stock had annual returns of -1 percent, -5 percent, 0 percent, 16 percent, 25 percent, and 50 percent
		each for the past six years. What is the average return and standard deviation for this stock?

			Year	Return
			1
			2
			3
			4
			5
			6

		Average return
		Standard deviation

Reference no: EM13216659

Questions Cloud

What is comb drive actuator simulation steps in software : what is comb drive actuator simulation steps in ansys software?

How many pounds of downward pressure is placed : approximately how many pounds of downward pressure is placed on a piston in an internal combustion engine at the moment of ignition? I know this will vary some depending on the type fuel, the size of the combustion chamber and ect.

Explain entrepreneurial attitudes and characteristics : Describe the entrepreneurial profile. In what ways does Larry Slotnick display these entrepreneurial attitudes and characteristics? Be sure to include examples from the video in your response.

Determine the air velocity : A Pitot-static probe connected to a water manometer is used to measure the velocity of air. If the de?ection (thevertical distance between the ?uid levels in the two arms) is 7.3 cm, determine the air velocity. Take the density of air to be 1.25 k..

Historical returns for large company stocks : The historical returns for large company stocks from 1980-1999. Let's find the average return and the standard deviation of the large firm returns.

Describe educational methods : Describe “educational methods” used by missionary/teachers in the residential schools to change Native American children’s sense of identity/culture

Find the stresses in a point of a rod that is fixed : find the stresses in a point of a rod that is fixed to a wall and have a load in the edge or better known as a cantilever.

Explain what is the benefit of rfid for reducing inventory : Read the case study Coca-Cola's RFID-based Dispenser Serves a New Type of Business Intelligence and to answer the four questions

Determine cutting time to complete the facing operation : determine: (a) the cutting time to complete the facing operation, (b) the cutting speeds and metal removal rates at the beginning and end of the cut.

User Account

All Pages