Essentials of Business Analytics (MindTap Course List)
2nd Edition
ISBN: 9781305627734
Author: Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by stepSolved in 2 steps
Knowledge Booster
Similar questions
- uppose 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…arrow_forwardAn asset has an average return of 11.51 percent and a standard deviation of 24.45 percent. What is the most you should expect to lose in any given year with a probability of 2.5 percent? Correct Answer is -37.39 %, just need to know how to get there. This is the correct answer from McGraw Hill Connect.arrow_forwardConsider a position consisting of 200,000 investment in asset A and 300,000 investment in asset B. Assume that the daily volatility of the assets are 1.5% and 1.8% respectively, and that coefficient of correlation between their returns is 0.4. What is the five day 95% VAR for the portfolio (given 95% confidence level represents 1.65 standard deviations on the left side of the normal distribution)?arrow_forward
- For investment A, the probability of the return being 20.0% is 0.5, 10.0% is 0.4, and -10.0% is 0.1 Compute the standard deviation for the investment with the given information. (Round your answer to one decimal place.) a. 85.00% b. 15.00% c. 34.00% d. 17.00% e. 9.00%arrow_forwardPlease find the following: The investment's expected return as a percentage: The investment's standard deviation:arrow_forwardTwo investments generated the following annual returns: % -Select- a. What is the average annual return on each investment? Round your answers to one decimal place. The average annual rate of return on X: The average annual rate of return on Y: b. What is the standard deviation of the return on investments X and Y? Round your answers to two decimal places. Standard deviation of X: % Standard deviation of Y: c. Based on the standard deviation, which investment was riskier? was riskier. 20X0 20X1 20X2 20X3 20X4 Investment X 11% 22 30 16 9 Investment Y 22% 24 10 13 12arrow_forward
- You have been asked for your advice in selecting a portfolio of assets and have been supplied with the following data:. You have been told that you can create two portfolios-one consisting of assets A and B and the other consisting of assets A and C-by investing equal proportions (50%) in each of the two component assets. a. What is the average expected return, r, for each asset over the 3-year period? b. What is the standard deviation, s, for each asset's expected return? c. What is the average expected return, rp, for each of the portfolios? d. How would you characterize the correlations of returns of the two assets making up each of the portfolios identified in part c? e. What is the standard deviation of expected returns, Sp, for each portfolio? f. What would happen if you constructed a portfolio consisting of assets A, B, and C, equally weighted? Would this reduce risk or enhance return?arrow_forwardSuppose 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…arrow_forwardDuring a particular investment period, a wealth management company held an investment portfolio that earned an average return of 13% with standard deviation of 30% and beta of 1.5. The average risk-free rate of return during this investment period was 2%. (full process) (a) Calculate the Sharpe and Treynor measures of performance evaluation for this investment portfolio. This investment portfolio is composed of the following two asset classes: Asset Class Weight Return Equity 0.80 15% Bonds 0.20 5% During this particular investment period, the information on a benchmark portfolio is given in the following table. Asset Class Weight Return Equity (S&P500 Index) 0.50 17% Bonds (Lehman Brothers Index) 0.50 5% (b) Determine whether the investment portfolio of the wealth management company performed better than the benchmark portfolio in terms of the total…arrow_forward
- 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?arrow_forwardPlease answer fast I give you upvote.arrow_forwardⓇ 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 %arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Essentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage Learning
Essentials of Business Analytics (MindTap Course ...
Statistics
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Cengage Learning