Version AiSavedHelpSave & ExitSubmitSuppose the returns on a particular asset are normally distributed. The asset had an average return of 10.9 percent and a standarddeviation of 22.6 percent. Use the NORMDIST function in Excel® to determine the probability that in any given year you will losemoney by investing in this asset.Note: Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.Probability%

Here, let X denote the percentage returns on a particular instrument. It is given that X follows a…

Answered: Version Ai Saved Help Save & Exit…

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

Suppose the returns on an asset are normally distributed. The historical average annual return for the asset was 5.2 percent and the standard deviation was 10.6 percent. a. What is the probability that your return on this asset will be less than -9.7 percent in a given year? Use the NORMDIST function in Excel® to answer this question. Note: 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? Note: 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? Note: 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…
Suppose the returns on an asset are normally distributed. The historical average annual return for the asset was 5.7 percent and the standard deviation was 18.3 percent. a. What is the probability that your return on this asset will be less than –4.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 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…
Ⓡ Suppose the returns on a particular asset are normally distributed. Also suppose the asset had an average return of 11.1% and a standard deviation of 23.4%. Use the NORMDIST function in Excel to determine the probability that in any given year you will lose money by investing in this asset. (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.): Probability %
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.3 percent and the standard deviation of this asset for the period was 33.2 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 rounded to 3 decimal places, e.g., 32.161.) b. What is the approximate probability that your money will triple in value in a single year? (Do not round intermediate calculations and enter your answer as a percent rounded to 8 decimal places, e.g., 32.16161616.)
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 16.3 percent and the standard deviation of this asset for the period was 33.5 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 rounded to 3 decimal places, e.g., 32.161.) b. What is the approximate probability that your money will triple in value in a single year? (Do not round intermediate calculations and enter your answer as a percent rounded to 8 decimal places, e.g., 32.16161616.) a. b. X Answer is complete but not entirely correct. Probability Probability 0.624 % 0.00000200 X %
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 16.3 percent and the standard deviation of this asset for the period was 33.5 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 rounded to 3 decimal places, e.g., 32.161.) b. What is the approximate probability that your money will triple in value in a single year? (Do not round intermediate calculations and enter your answer as a percent rounded to 8 decimal places, e.g., 32.16161616.) a. b. Probability Probability Answer is not complete. 0.624 % %
Suppose the returns on an asset are normally distributed. The historical average annual return for the asset was 6.4 percent and the standard deviation was 12.4 percent. A. 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.) B. 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.)
ok 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.4 percent and the standard deviation of this asset for the period was 33.3 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? Note: Do not round intermediate calculations and enter your answer as a percent rounded to 3 decimal places, e.g., 32.161. b. What is the approximate probability that your money will triple in value in a single year? Note: Do not round intermediate calculations and enter your answer as a percent rounded to 8 decimal places, e.g., 32.16161616. ences a. Probability b. Probability % %
Suppose the returns on an asset are normally distributed. The historical average annual return for the asset was 5.2 percent and the standard deviation was 10.6 percent. a. What is the probability that your return on this asset will be less than –9.7 percent in a given year? Use the NORMDIST function in Excel® to answer this question. b. What range of returns would you expect to see 95 percent of the time? c. What range of returns would you expect to see 99 percent of the time?
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 17.1 percent and the standard deviation of this asset for the period was 35 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? Note: Do not round intermediate calculations and enter your answer as a percent rounded to 3 decimal places, e.g., 32.161. b. What is the approximate probability that your money will triple in value in a single year? Note: Do not round intermediate calculations and enter your answer as a percent rounded to 8 decimal places, e.g., 32.16161616. a. Probability b. Probability % %
Suppose the average return on Asset A is 6.6 percent and the standard deviation is 8.6 percent and the average return and standard deviation on Asset B are 3.8 percent and 3.2 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? (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 11 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.25 percent. How likely is it that such a low return will recur at some point in the future? (Do…
The probability distributions of expected returns for the assets are shown in the following table: Asset A Prob Return 0.2 -5% 0.4 10% 0.4 15% a) Calculate the expected return for asset A. b) Calculate the standard deviation for asset A.

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS