Question

1. Below are the historical arithmetic average returns and standard deviations for different asset classes. Asset...

1. Below are the historical arithmetic average returns and standard deviations for different asset classes.

Asset class Mean return Standard deviation
T-bills 0.035 0.031
Corporate bonds 0.063 0.084
Small company stocks 0.169 0.323
Large company stocks 0.121 0.202

Assume that the returns are normally distributed. Use Excel's NORM.DIST() function to answer the following questions.

a. What is the probability that the return on corporate bonds will be less than 4%?

b. What is the probability that the return on small company stocks will be less than 4%?

c. What is the probability that the return on large company stocks will be greater than 20%?

2. Meraki Inc. has an expected annual return of 8% with a standard deviation of 13%. Assume returns are normally distributed.

a. What is the probability of earning a return between -5% and 21%?

3. Investing Shark Burgers has an expected annual return of 28% and a standard deviation of 14%.

a. What is the probability of losing money on this investment? Assume that returns are normally distributed.

4. Meraki Inc. has an expected annual return of 8% with a standard deviation of 33%. Assume returns are normally distributed.

a. What is the probability of earning a return less than -25%?

b. What is the probability of earning a return less than 74%?

c. What is the probability of earning a return between -25% and 74%?

Homework Answers

Answer #1

1). The probabilities are as follows:

Asset class Mean return Standard deviation return Probability
Corporate bonds 0.063 0.084 <4% 0.39212
Small company stocks 0.169 0.323 <4% 0.34481
Large company stocks 0.121 0.202 >20%               0.3479

Note that the NORM.DIST() function calculates probabilities for less than a given value so for large company stocks (since probability is for MORE than 20% return), the probability is calculated by subtracting the probability for less than 20% return (using NORM.DIST()) by 1.

2). Probability that Meraki earns less than -5% = 0.15866

Probability that Meraki earns less than 21% = 0.84134

Therefore, the probability that return is -5% < return < 21% is 0.84134 - 0.15866 = 0.68269

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 returns on an asset are normally distributed. Suppose the historical average annual return for...
Suppose the returns on an asset are normally distributed. Suppose the historical average annual return for the asset was 5.6 percent and the standard deviation was 10.3 percent. What is the probability that your return on this asset will be less than –2.5 percent in a given year? Use the NORMDIST function in Excel® to answer this question. What range of returns would you expect to see 95 percent of the time? What range would you expect to see 99...
Suppose the returns on an asset are normally distributed. The average annual return for the asset...
Suppose the returns on an asset are normally distributed. The average annual return for the asset over some period was 6.6 percent and the standard deviation of this asset for that period was 9.0 percent.    Based on this information, what is the approximate probability that your return on this asset will be less than -3.1 percent in a given year?            What range of returns would you expect to see 95 percent of the time?            What...
Suppose the returns on Asset Y are normally distributed. The average annual return for this asset...
Suppose the returns on Asset Y are normally distributed. The average annual return for this asset over 50 years was 13.4 percent and the standard deviation of the returns was 23.5 percent. Based on the historical record, use the cumulative normal probability table (rounded to the nearest table value) in the appendix of the text to determine the probability that in any given year you will lose money by investing in common stock. What is the probablility of a return...
The standard deviation of Asset A returns is 36%, while the standard deviation of Asset M...
The standard deviation of Asset A returns is 36%, while the standard deviation of Asset M returns is 24%. The correlation between Asset A and Asset M returns is 0.4. (a) The average of Asset A and Asset M’s standard deviations is (36+24)/2 = 30%. Consider a portfolio, P, with 50% of funds in Asset A and 50% of funds in Asset M. Will the standard deviation of portfolio P’s returns be greater than, equal to, or less than 30%?...
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...
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...
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.,...
Portfolio returns. The Capital Asset Pricing Model is a financial model that assumes returns on a...
Portfolio returns. The Capital Asset Pricing Model is a financial model that assumes returns on a portfolio are normally distributed. Suppose a portfolio has an average annual return of 15.3% (i.e. an average gain of 15.3%) with a standard deviation of 31%. A return of 0% means the value of the portfolio doesn't change, a negative return means that the portfolio loses money, and a positive return means that the portfolio gains money. Round all answers to 4 decimal places....
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...
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...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT