a. Use a spreadsheet (or a calculator with a linear regression function) to determine Stock X's beta coefficient. Do not round intermediate calculations. Round your answer to two decimal places. Beta = b. Determine the arithmetic average rates of return for Stock X and the NYSE over the period given. Calculate the standard deviations of returns for both Stock X and the NYSE. Do not round intermediate calculations. Round your answers to two decimal places.

a. Use a spreadsheet (or a calculator with a linear regression function) to determine Stock X's beta coefficient. Do not round intermediate calculations. Round your answer to two decimal places. Beta = b. Determine the arithmetic average rates of return for Stock X and the NYSE over the period given. Calculate the standard deviations of returns for both Stock X and the NYSE. Do not round intermediate calculations. Round your answers to two decimal places.

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

Hello, which table would I use to find the ratio of exchange in a stock? I'm attaching the tables, but I'm not sure which table to use. Also, what would be the formula to use when doing that on an excel template?
You have the following information: t1 t2 t3 t4 TSLA Returns 0.05 -0.04 0.1 -0.01 Market Returns 0 -0.04 0.01 0.01 What is the Covariance of TSLA and the Market? Type your answer as decimal (i.e. 0.052 and not 5.2%). Round your answer to the nearest four decimals if needed.
1.) On a single chart, plot the value of $1 invested in each of the five indexes over time. I.e., for all ??, plot the cumulative return series for each index: ?????? = (1 + ?��1)(1 + ?��2)...(1 + ????) What patterns do you observe? (10 points) 2.) Plot a histogram of only the Global index returns. Does the distribution look normal? (5 points) 3.) Estimate the following for each of the indices. In calculating the statistics, “monthly” can be interpreted as “not annualized”. (30 points) a. Arithmetic average of monthly returns, and annualized arithmetic return using the APR method b. Geometric average of monthly returns, and annualized geometric return using the EAR method. Why does the geometric average differ from the arithmetic average? c. Standard deviation of monthly returns, and annualized standard deviation d. Sharpe Ratio of monthly returns, and annualized Sharpe Ratio e. Skewness of monthly returns f. Kurtosis of monthly returns g. 5% Value at Risk (VaR) of…
You have the following information: t1 t2 t3 t4 TSLA Returns 0.05 -0.04 0.1 -0.01 Market Returns 0 -0.04 0.01 0.01 What is the Covariance of TSLA and the Market? Type your answer as decimal (i.e. 0.052 and not 5.2%). Round your answer to the nearest four decimals if needed.
When we test CAPM using historical data, a classic test is to regress excess returns of stocks onto the stock betas, using the following regression specification across stocks: - Rp Rf =α+By+ε where Rup - Rf is the average excess return of a security or portfolio, ẞ is the estimated beta of the security or portfolio, & is the regression residual, and a (Alpha) and y (Gamma) are regression coefficients. Based on the regression, which of the following statements are true if CAPM is true? Select all two correct statements. The Alpha is zero The Alpha is positive The Gamma is positive The Gamma is zero
Comment on the SAS regression output including a-e. Compare and comment on the differences between the two regressions (3- vs. 4-factor model using either OLS or HC results depending upon the White test result) Make conclusions regarding choosing 3- vs. 4-factor model when predicting future stock returns, and explain why.
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…
Given the following information, calculate the expected value for Firm C's EPS. Data for Firms A and B are as follows: E(EPSA) = $5.10, and σA = $3.63; E(EPSB) = $4.20, and σB = $2.94. Do not round intermediate calculations. Round your answer to the nearest cent. Probability 0.1 0.2 0.4 0.2 0.1 Firm A: EPSA ($1.61) $1.80 $5.10 $8.40 $11.81 Firm B: EPSB (1.20) 1.30 4.20 7.10 9.60 Firm C: EPSC (2.59) 1.35 5.10 8.85 12.79 E(EPSC): $ You are given that σc = $4.12. Discuss the relative riskiness of the three firms' earnings using their respective coefficients of variation. Do not round intermediate calculations. Round your answers to two decimal places. CV A B C The most risky firm is .
Vinay
The market and Stock J have the following probability distributions: Probability rM rJ 0.3 15.00 % 19.00 % 0.4 10.00 6.00 0.3 18.00 10.00 The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet Calculate the expected rate of return for the market. Do not round intermediate calculations. Round your answer to two decimal places.fill in the blank %Calculate the expected rate of return for Stock J. Do not round intermediate calculations. Round your answer to two decimal places.fill in the blank % Calculate the standard deviation for the market. Do not round intermediate calculations. Round your answer to two decimal places.fill in the blank %Calculate the standard deviation for Stock J. Do not round intermediate calculations. Round your answer to two decimal places.fill in the blank %
Suppose two asset returns are described by a two factor model, n = 0% + 11 + 1.82 + e1 2 = -1% + 2/1 + 0.52 + e2 where the volatility of first factor is 30%, the volatility of the second factor is 10%, and the correlation between the two factors is 0.5. Suppose also that the volatilities of the error terms ej and ez are both 10%. What is the covariance of n and r2 ? (Nearest 0.0001).
Suppose the utility function is U = E(r) - 0.5Ao2. Draw the indifference curve corresponding to a utility level of 0.2 for an investor with a risk aversion coefficient of 3. Please note the vertical line indicates expected return, and plot standard deviation on the horizontal line.

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