Question

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 6.3 percent and the standard deviation was 16.3 percent.

a. What is the probability that your return on this asset will be less than –3.7 percent in a given year? Use the NORMDIST function in Excel® to answer this question. (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.)
b.

What range of returns would you expect to see 95 percent of the time? (Enter your answers for the range from lowest to highest. A negative answer should be indicated by a minus sign. Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.)

c. What range of returns would you expect to see 99 percent of the time? (Enter your answers for the range from lowest to highest. A negative answer should be indicated by a minus sign. Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.)
0 0
Add a comment Improve this question Transcribed image text
Answer #1

a) Probability of return less than -3.7% 26.98% =NORMDIST(-3.7%,6.3%,16.3%,TRUE) b) At 95%: Expected range of returns Expecte

Please rate thumbs up

Add a comment
Know the answer?
Add Answer to:
Suppose the returns on an asset are normally distributed. The historical average annual return for the...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Suppose the returns on an asset are normally distributed. The historical average annual return for the asset was 6.7 pe...

    Suppose the returns on an asset are normally distributed. The historical average annual return for the asset was 6.7 percent and the standard deviation was 12.6 percent. a. What is the probability that your return on this asset will be less than -10.1 percent in a given year? Use the NORMDIST function in Excel to answer this question. (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) b.What range of...

  • 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 76 percent and the standard deviation was 8.6 percent. What is the probability that your return on this asset will be less than 93 percent in a given year? Use the NORMDIST function in Excele to answer this question (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) Probability What range of returns...

  • Problem 10-24 Using Return Distributions Assume the returns on an asset are normally distributed. Suppose the...

    Problem 10-24 Using Return Distributions Assume the returns on an asset are normally distributed. Suppose the historical average annual return for the asset was 7.3 percent and the standard deviation was 8.4 percent. What is the probability that your return on this asset will be less than -4.5 percent in a given year? Use the NORMDIST function in Excel to answer this question. (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places,...

  • Suppose the returns on long-term government bonds are normally distributed. Assume long-term government bonds have a...

    Suppose the returns on long-term government bonds are normally distributed. Assume long-term government bonds have a mean return of 6.0 percent and a standard deviation of 9.9 percent. a. What is the approximate probability that your return on these bonds will be less than -3.9 percent in a given year? Use the NORMDIST function in Excel® to answer this question. (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) b....

  • Suppose the returns on long-term government bonds are normally distributed. Assume long-term government bonds have a...

    Suppose the returns on long-term government bonds are normally distributed. Assume long-term government bonds have a mean return of 6.0 percent and a standard deviation of 9.9 percent. a. What is the approximate probability that your return on these bonds will be less than -3.9 percent in a given year? Use the NORMDIST function in Excel® to answer this question. (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) b.What...

  • Suppose the returns on long-term government bonds are normally distributed. Assume long-term government bonds have a...

    Suppose the returns on long-term government bonds are normally distributed. Assume long-term government bonds have a mean return of 5.3 percent and a standard deviation of 8.8 percent. What is the probability that your return on these bonds will be less than −3.5 percent in a given year? Use the NORMDIST function in Excel® to answer this question. (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) Probability             %...

  • Suppose the returns on long-term government bonds are normally distributed. Assume long-term government bonds have a...

    Suppose the returns on long-term government bonds are normally distributed. Assume long-term government bonds have a mean return of 6.0 percent and a standard deviation of 9.9 percent. a. What is the approximate probability that your return on these bonds will be less than -3.9 percent in a given year? Use the NORMDIST function in Excel to answer this question. (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) b....

  • Over a particular period, an asset had an average return of 6.1 percent and a standard...

    Over a particular period, an asset had an average return of 6.1 percent and a standard deviation of 8.8 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.) Expected...

  • Can you answer Part 2 and 3 Problem 10-24 Using Return Distributions Assume the returns on...

    Can you answer Part 2 and 3 Problem 10-24 Using Return Distributions Assume the returns on an asset are normally distributed. Suppose the historical average annual retum for the asset was 4.9 percent and the standard deviation was 10.4 percent What is the probability that your return on this asset will be less than 4.9 percent in a given year? Use the NORMDIST function in Excel® to answer this question. (Do not round Intermediate calculations and enter your answer as...

  • Over a particular period, an asset had an average return of 12.0 percent and a standard...

    Over a particular period, an asset had an average return of 12.0 percent and a standard deviation of 20.4 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.) -...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT