Question

Suppose the average return on Asset A is 6.8 percent and the standard deviation is 8...

Suppose the average return on Asset A is 6.8 percent and the standard deviation is 8 percent, and the average return and standard deviation on Asset B are 3.9 percent and 3.3 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 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 10 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.35 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.6 percent in this same year. How likely is it that such a high 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.)

Homework Answers

Answer #1

The formula for Normal Distribution function in excel is NORMDIST(value of reference,mean, Standard deviation, True)

By definition, the result that a NORMDIST function gives indicates the less than referene value probability. Hence for identifying the value of more than 10% in Asset A, we have to reduce the value arrived using NORMDIST function by 1. i.e 1-NORMDIST.

Value of Reference Mean SD NORMDIST Result Greater than value Final result
Question 1 Asset A > 10% 6.80% 8% 0.66 =1-0.66 0.34
Question 1 Asset A <0% 6.80% 8% 0.20 0.20
Question 2 Asset B > 10% 3.90% 3% 0.97 =1-0.97 0.03
Question 2 Asset B <0% 3.90% 3% 0.12 0.12

In a continuous distribution, probability of any particular single value from a continuous distribution is always zero. Hence the probability of getting a return of -4.35% from Asset A or 10.6% from Asset B is Zero. Answer to Question C-1 and C-2 is Zero.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Suppose the average return on Asset A is 6.5 percent and the standard deviation is 8.5...
Suppose the average return on Asset A is 6.5 percent and the standard deviation is 8.5 percent, and the average return and standard deviation on Asset B are 3.7 percent and 3 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...
Problem 10-28 Using Probability Distributions [LO 3] Suppose the returns on long-term corporate bonds and T-bills...
Problem 10-28 Using Probability Distributions [LO 3] Suppose the returns on long-term corporate bonds and T-bills are normally distributed. Assume for a certain time period, long-term corporate bonds had an average return of 5.8% and a standard deviation of 8.9%. For the same period, T-bills had an average return of 4.3% and a standard deviation of 3.1%. Use the NORMDIST function in Excel® to answer the following questions: a. What is the probability that in any given year, the return...
Assume that the returns from an asset are normally distributed. The average annual return for this...
Assume that the returns from an asset are normally distributed. The average annual return for this asset over a specific period was 16.8 percent and the standard deviation of the asset was 42.30 percent. Use the NORMDIST function in Excel® to answer this question. What is the approximate probability that your money will double in value in a single year? (Do not round intermediate calculations and enter your answer as a percent rounded to 3 decimal places, e.g., 32.161.) What...
Assume the returns from holding an asset are normally distributed. Also assume the average annual return...
Assume the returns from holding an asset are normally distributed. Also assume the average annual return for holding the asset a period of time was 15.9 percent and the standard deviation of this asset for the period was 33.8 percent. Use the NORMDIST function in Excel® to answer the following questions. a. What is the approximate probability that your money will double in value in a single year? (Do not round intermediate calculations and enter your answer as a percent...
Suppose the returns on an asset are normally distributed. The historical average annual return for the...
Suppose the returns on an asset are normally distributed. The historical average annual return for the asset was 5.9 percent and the standard deviation was 10.5 percent. a. What range of returns would you expect to see 95 percent of the time? (A negative answer should be indicated by a minus sign. Enter your answers for the range from lowest to highest. Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g.,...
Assume that the returns from an asset are normally distributed. The average annual return for this...
Assume that the returns from an asset are normally distributed. The average annual return for this asset over a specific period was 14.7 percent and the standard deviation of those returns in this period was 43.59 percent. a. What is the approximate probability that your money will double in value in a single year? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) b. What about triple in value? (Do...
The market portfolio has an expected return of 11.0 percent and a standard deviation of 21.0...
The market portfolio has an expected return of 11.0 percent and a standard deviation of 21.0 percent. The risk-free rate is 4.0 percent.    a. What is the expected return on a well-diversified portfolio with a standard deviation of 8.0 percent? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places (e.g., 32.16).)      Expected return %    b. What is the standard deviation of a well-diversified portfolio with an expected return of 19.0...
1. Over a particular period, an asset had an average return of 6.9 percent and a...
1. Over a particular period, an asset had an average return of 6.9 percent and a standard deviation of 9.9 percent. What range of returns would you expect to see 95 percent of the time for this asset? (A negative answer should be indicated by a minus sign. Input your answers from lowest to highest to receive credit for your answers. Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.)...
Shadow Corp. has no debt but can borrow at 6.8 percent. The firm’s WACC is currently...
Shadow Corp. has no debt but can borrow at 6.8 percent. The firm’s WACC is currently 8.6 percent, and the tax rate is 35 percent. a. What is the firm’s cost of equity? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) Cost of equity % b. If the firm converts to 30 percent debt, what will its cost of equity be? (Do not round intermediate calculations. Enter your answer as...
Suppose you observe the following situation: State of Probability of Return if State Occurs Economy State...
Suppose you observe the following situation: State of Probability of Return if State Occurs Economy State Stock A Stock B Boom .17 ? .05 ? .06 Normal .72 .18 .17 Bust .11 .46 .31 a. Calculate the expected return on each stock. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) Expected return Stock A % Stock B % b. Assuming the capital asset pricing model holds and Stock A’s...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT