Question

In: Finance

Over the past four years, a stock produced returns of 14 percent, 22 percent, 6 percent,...

Over the past four years, a stock produced returns of 14 percent, 22 percent, 6 percent, and -19 percent. What is the approximate probability that an investor in this stock will not lose more than 30 percent nor earn more than 41 percent in any one given year? How would you calculate this in excel?

Solutions

Expert Solution

Year Return in Percentage
1 14
2 22
3 6
4 -19
SUM 23
Mean Return =23/4= 5.75 %
Standard Deviation 17.19593 %
WILL NOT LOOSE MORE THAN 30%
That means return will be more than -30%
From Cumulative Area Under Standard Normal Distrbution Table
If D=(-30-5.75)/17.19593= -2.07898
N(d)=0.0202
Probability of Return less than30%= 2.02% (Probability of stock will not loose more than 30%=100-2.02=97.98%)
Earn not more than41%
If D=(41-5.75)/17.19593= 2.049904
N(d)=0.9798
Earn not more than41%, Probability 97.98%

Related Solutions

Over the past four years, a stock produced returns of 13, 6, -5, and 18 percent,...
Over the past four years, a stock produced returns of 13, 6, -5, and 18 percent, respectively. What is the standard deviation of these returns? What would be the standard deviation of these returns if they were exactly twice the return shown for each year? please show your work.
Over the past five years, a stock produced returns of 14%, 22%, -16%, 4%, and 11%....
Over the past five years, a stock produced returns of 14%, 22%, -16%, 4%, and 11%. If the returns are normally distributed, what is the probability that an investor in this stock will NOT lose more than 7.4% nor earn more than 21.4% in any one given year? (Hint: Find average return and standard deviation first.)
. Over the past five years, a stock produced returns of 10 percent, 18 percent, 2...
. Over the past five years, a stock produced returns of 10 percent, 18 percent, 2 percent, -9 percent, and 4 percent. a) What is the geometric return? b) What is the arithmetic return? c) What is the variance of the above returns? d) What is the sample standard deviation?
A stock produced returns of 14 percent, 17 percent, and −1 percent over three of the...
A stock produced returns of 14 percent, 17 percent, and −1 percent over three of the past four years, respectively. The arithmetic average for the past four years is 6 percent. Show your work here (please be as detailed and organized as possible): What is the missing return (i.e., the return in the fourth year)? What is the geometric average return over the four years? What is the standard deviation of returns of the stock? (Show work below please).
A stock had returns of 6 percent, 39 percent, and -3 percent over the past 3...
A stock had returns of 6 percent, 39 percent, and -3 percent over the past 3 years. What is the mean of the stock’s returns over the past 3 years minus the sample standard deviation of the stock’s returns from the past 3 years? Answer as a rate in decimal format so that 12.34% would be entered as .1234 and 0.98% would be entered as .0098.
returns of 6 percent, 14 percent, 13 percent, 9 percent, and -4 percent for the past...
returns of 6 percent, 14 percent, 13 percent, 9 percent, and -4 percent for the past five years, respectively. What is the standard deviation of these returns
A stock had returns of 8 percent, –8 percent, 3 percent, and 14 percent over the...
A stock had returns of 8 percent, –8 percent, 3 percent, and 14 percent over the past 4 years. What is the standard deviation of this stock for the past four years? Multiple choice 16.1 percent 4.7 percent 9.3 percent 4.3 percent
Suppose the inflation rate has been 6 percent over the past four years. If the Federal...
Suppose the inflation rate has been 6 percent over the past four years. If the Federal Reserve announces an increase in the growth of the money supply, adaptive expectations would predict an inflation rate of 6 percent: True or False?
You’ve observed the following returns on Bennington Corporation’s stock over the past five years: 17 percent,...
You’ve observed the following returns on Bennington Corporation’s stock over the past five years: 17 percent, −4 percent, 20 percent, 12 percent, and 10 percent. a. What was the arithmetic average return on the company's stock over this five-year period? (Do not round intermediate calculations and enter your answer as a percent rounded to 1 decimal place, e.g., 32.1.) b-1. What was the variance of the company's stock returns over this period? (Do not round intermediate calculations and round your...
You’ve observed the following returns on Yasmin Corporation’s stock over the past five years: 17 percent,...
You’ve observed the following returns on Yasmin Corporation’s stock over the past five years: 17 percent, –15 percent, 19 percent, 29 percent, and 10 percent. a. What was the arithmetic average return on the company's stock over this five-year period? (Do not round intermediate calculations. Enter your answer as a percent rounded to 1 decimal place, e.g., 32.1.) Average return             % b-1 What was the variance of the company's stock returns over this period? (Do not round intermediate calculations...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT