Question

In: Finance

Suppose the average return on Asset A is 7.1 percent and the standard deviation is 8.3...

Suppose the average return on Asset A is 7.1 percent and the standard deviation is 8.3 percent, and the average return and standard deviation on Asset B are 4.2 percent and 3.6 percent, respectively. Further assume that the returns are normally distributed. Use the NORMDIST function in Excel® to answer the following questions. a. What is the probability that in any given year, the return on Asset A will be greater than 12 percent? Less than 0 percent? (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) b. What is the probability that in any given year, the return on Asset B will be greater than 12 percent? Less than 0 percent? (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) c-1. In a particular year, the return on Asset A was −4.38 percent. How likely is it that such a low return will recur at some point in the future? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) c-2. Asset B had a return of 10.9 percent in this same year. How likely is it that such a high return will recur at some point in the future?

Solutions

Expert Solution

ASSET A:
Mean 7.1 percent
Standard Deviation 8.3 percent
Return on asset greater than 12 percent
Cumulative value at 12% 0.722526 (Using NORMDIST function of excel with   X=12, mean=7.1, Standard Deviation=8.3, Cumulative=TRUE)
Probability that return is greater than 12 0.277474 (1-0.722526)
Probability in percentage 27.75%
Note: This can also be calculated using Standard Normal Distribution Table as shown below)
D=(X-Mean)/Standard Dev.=(12-7.1)/8.3 0.590361
Using Standard Normal Distribution Table:
Cumulative area under D=0.590361 0.7224
Less Than 0%
Cumulative value at 0% 0.196159 (Using NORMDIST function of excel with X=0, mean=7.1, Standard Deviation=8.3, Cumulative=TRUE)
Probability that return is Less Than 0% 0.196159
Probability in percentage 19.62%
ASSET B:
Mean 4.2 percent 2.166667
Standard Deviation 3.6 percent
Return on asset greater than 12 percent
Cumulative value at 12% 0.98487 (Using NORMDIST function of excel with   X=12, mean=4.2, Standard Deviation=3.6, Cumulative=TRUE)
Probability that return is greater than 12 0.01513 (1-0.98487)
Probability in percentage 1.51%
Less Than 0%
Cumulative value at 0% 0.121673 (Using NORMDIST function of excel with X=0, mean=4.2, Standard Deviation=3.6, Cumulative=TRUE)
Probability that return is Less Than 0% 0.121673
Probability in percentage 12.17%
ASSET A:
Mean 7.1 percent
Standard Deviation 8.3 percent
Return on asset Equal to         (4.38) percent
Cumulative value at (-4.38%) 0.083312 (Using NORMDIST function of excel with   X=-4.38, mean=7.1, Standard Deviation=8.3, Cumulative=TRUE)
Probability that return is LESS than -4.38% 0.083312
Probability in percentage 8.33%
Probability that such low return will occur again 8.33%
ASSET B:
Mean 4.2 percent 2.166667
Standard Deviation 3.6 percent
Return on asset equal to 10.9 percent
Cumulative value at 10.9% 0.968636 (Using NORMDIST function of excel with   X=10.9, mean=4.2, Standard Deviation=3.6, Cumulative=TRUE)
Probability that return is greater than 10.9% 0.031364 (1-0.98487)
Probability in percentage 3.14%
Probability that such HIGH return will occur again 3.14%

Related Solutions

Suppose the average return on Asset A is 7.0 percent and the standard deviation is 8.2...
Suppose the average return on Asset A is 7.0 percent and the standard deviation is 8.2 percent and the average return and standard deviation on Asset B are 4.1 percent and 3.5 percent, respectively. Further assume that the returns are normally distributed. Use the NORMDIST function in Excel® to answer the following questions. a. What is the probability that in any given year, the return on Asset A will be greater than 11 percent? Less than 0 percent? (Round your...
Suppose the average return on an asset is 12.3 percent and the standard deviation is 20.8...
Suppose the average return on an asset is 12.3 percent and the standard deviation is 20.8 percent. Further assume that the returns are normally distributed. Use the NORMDIST function in Excel® to determine the probability that in any given year you will lose money by investing in this asset. Probability?
Suppose the average return on Asset A is 6.8 percent and the standard deviation is 8.8...
Suppose the average return on Asset A is 6.8 percent and the standard deviation is 8.8 percent, and the average return and standard deviation on Asset B are 4 percent and 3.4 percent, respectively. Further, assume that the returns are normally distributed. Use the NORMDIST function in Excel® to answer the following questions. a. What is the probability that in any given year, the return on Asset A will be greater than 10 percent? Less than 0 percent? (Do not...
Suppose the average return on an asset is 12.3 percent and the standard deviation is 21.9...
Suppose the average return on an asset is 12.3 percent and the standard deviation is 21.9 percent. Further assume that the returns are normally distributed. Use the NORMDIST function in Excel® to determine the probability that in any given year you will lose money by investing in this asset.
Suppose the average return on Asset A is 6 percent and the standard deviation is 8...
Suppose the average return on Asset A is 6 percent and the standard deviation is 8 percent, and the average return and standard deviation on Asset B are 3.2 percent and 2.6 percent, respectively. Further assume that the returns are normally distributed. Use the NORMDIST function in Excel® to answer the following questions. a. What is the probability that in any given year, the return on Asset A will be greater than 9 percent? Less than 0 percent? b. What...
The historical average return for Puella Stock is 8.3%. Thehistorical standard deviation is 17.2%. Based...
The historical average return for Puella Stock is 8.3%. The historical standard deviation is 17.2%. Based on those numbers answer the following Puella Stock:a. About one in six years, your return should fall inside the range of ____% to ____%b. About one in twenty years, your return should fall outside the range of ____% to ____%c. About one in two hundred years, your return should be greater than ____%
For Asset A and for Asset B, compute the average annual return, variance, standard deviation, and...
For Asset A and for Asset B, compute the average annual return, variance, standard deviation, and coefficient of variation for the annual returns given below. a. Asset A: 5%, 10%, 15%, 4% b. Asset B: -6%, 20%, 2%, -5%, 10%
suppose asset a has an expected return of 10% and a standard deviation of 20% asset...
suppose asset a has an expected return of 10% and a standard deviation of 20% asset b has an expected return of 16% and a standard deviation of 40%.if the correlation between a and b is 0.6,what are the expected return and standard deviation for a prtifolio comprised of 40% asset a
Asset K has an expected return of 18 percent and a standard deviation of 33 percent....
Asset K has an expected return of 18 percent and a standard deviation of 33 percent. Asset L has an expected return of 6 percent and a standard deviation of 17 percent. The correlation between the assets is 0.42. What are the expected return and standard deviation of the minimum variance portfolio?
You own a stock with an average return of 18.7 percent and a standard deviation of...
You own a stock with an average return of 18.7 percent and a standard deviation of 19.6 percent. In any one given year, you have a 95 percent chance that you will not lose more than ________ percent nor earn more than ________ percent on this stock. A) 57.9; 20.5 B) 20.5; 38.3 C) 20.5; 57.9 D) 0.9; 57.9 E) 0.9; 38.3
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT