Excel Online Structured Activity: CAPM, portfolio risk, and returnConsider the following information for three stocks, Stocks A, B, and C. The returns on the three stocks are positivelycorrelated, but they are not perfectly correlated. (That is, each of the correlation coefficients is between 0 and 1.)Standard DeviationStockAВCExpected Return8.29%10.6412.0514%14Beta0.71.21.5Fund P has one-third of its funds invested in each of the three stocks. The risk-free rate is 5%, and the market is inequilibrium. (That is, required returns equal expected returns.) The data has been collected in the Microsoft Excel Online filebelow. Open the spreadsheet and perform the required analysis to answer the questions below. a. What is the market risk premium (M-FRF)? Round your answer to two decimal places.%b. What is the beta of Fund P? Do not round intermediate calculations. Round your answer to two decimal places.c. What is the required return of Fund P? Do not round intermediate calculations. Round your answer to two decimalplaces.%d. Would you expect the standard deviation of Fund P to be less than 14%, equal to 14%, or greater than 14%?I. less than 14%II. greater than 14%III. equal to 14%

CAPM is the model that is used to show the linear relation between systematic risk…

a. What is the market risk premium (M-FRF)? Round your answer to two decimal places. 96 b. What is the beta of Fund P? Do not round intermediate calculations. Round your answer to two decimal places. c. What is the required return of Fund P? Do not round intermediate calculations. Round your answer to two decimal places. % d. Would you expect the standard deviation of Fund P to be less than 14%, equal to 14%, or greater than 14%? I. less than 14% II. greater than 14% III. equal to 14%

a. What is the market risk premium (M-FRF)? Round your answer to two decimal places. 96 b. What is the beta of Fund P? Do not round intermediate calculations. Round your answer to two decimal places. c. What is the required return of Fund P? Do not round intermediate calculations. Round your answer to two decimal places. % d. Would you expect the standard deviation of Fund P to be less than 14%, equal to 14%, or greater than 14%? I. less than 14% II. greater than 14% III. equal to 14%

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

Consider the following risk-return characteristics for funds A and B: Expected return Risk Fund A (Equity) 12% 20% Fund B (Debt) 9% 16% The correlation coefficient between the returns of fund A and fund B is 0.4. 1. Which Fund is riskier? Write 1 if your answer is Fund A, write 2 if your answer is Fund B, or write 3 if your answer is undetermined. 2.1 What is the weight of fund A in the minimum variance portfolio? 2.4 What is the risk of the minimum variance portfolio? 2.2 What is the weight of Fund B in the minimum variance portfolio? 2.3 What is the expected return of the minimum variance portfolio?
If a fund has a return of 12% and a standard deviation of 15%, and if the risk-free rate is 2%, then what is its Sharpe ratio O a. 0.667 O b. 0.235 O c. 0.435 O d. 0.0.237
Assume the correlation coefficient between Baker Fund and the market index is .70. What percentage of Baker Fund’s total risk is specific (i.e., nonsystematic)?
Compute the residual risk measure for portfolio A. Round off your final answer to three digits after the decimal point. Compute the appraisal ratio for portfolio B. Round off your final answer to three digits after the decimal point.
What is portfolio A's CAPM beta based on your analysis? Round off your answer to three digits after the decimal points. State your answer as a percentage point as 1.234. Compute the Treynor measure for portfolio B. Round off your answer to three digits after the decimal point. State your answer as 1.234
If you plot the relationship between portfolio expected return and portfolio beta, what is the slope of the line that results? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) | Slope of the line %
Suppose that the index model for stocks A and B is estimated from excess returns with the following results: RA = 4.0% + 0.50RM + eA RB = -1.2% + 0.70RM + eB = 17%; R-squarea = 0.26; R-squareB 0.18 Assume you create a portfolio Q, with investment proportions of 0.40 in a risky portfolio P, 0.35 in the market index, and 0.25 in T-bill. Portfolio Pis composed of 70% Stock A and 30% Stock B.
calculate the following M-squared measureT-squared measure, andAppraisal ratio (information ratio) Fund Average return Standard Deviation Beta coefficient Unsystematic Risk A 0.240 0.220 0.800 0.017 B 0.200 0.170 0.900 0.450 C 0.290 0.380 1.200 0.074 D 0.260 0.290 1.100 0.026 E 0.180 0.400 0.900 0.121 F 0.320 0.460 1.100 0.153 G 0.250 0.190 0.700 0.120 Market 0.220 0.180 1.000 0.000 Risk free return 0.050 0.000 Out of the performance measures you calculated in part a., which one would you use undereach of the following circumstances:i. You want to select one of the funds as your risky portfolio.ii. You want to select one of the funds to be mixed with the rest of your portfolio,currently composed solely of holdings in the market-index fund.iii. You want to select one of the funds to form an actively managed stock portfolio
This question assumes the standard mean-variance utility function. A pension scheme offers investors two possible funds to invest in: a cash fund and a balanced fund. The cash fund offers a guaranteed return of 1.90%. The balanced fund offers an expected return of 5.50% with volatility 17.80%. What is the lowest level of risk-aversion that would cause an investor to choose the cash fund? 2.27 0.40 3.47 0.02
Supposing the return from an investment has the following probability distribution Return Probability R (%) 8 0.2 10 0.2 12 0.5 14 0.1 Required: What is the expected return of the investment? What is the risk as measured by the standard deviation of expected returns?
Fill the parts in the above table that are shaded in yellow. You will notice that there are nineline items. Using the data generated in the previous question (Question 1);a) Plot the Security Market Line (SML) b) Superimpose the CAPM’s required return on the SML c) Indicate which investments will plot on, above and below the SML?d) If an investment’s expected return (mean return) does not plot on the SML, what doesit show? Identify undervalued/overvalued investments from the graph Please answer A, B, C & D
On the basis of the utility formula below, which investment would you select if you were risk averse with A = 4? Investment Expected return E(r) Standard deviation σ 1 0.12 0.30 2 0.15 0.50 3 0.21 0.16 4 0.24 0.21

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

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

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