A stock's beta coefficient can be calculated using the following equation: B₁ = Oi, m σε m a. Write a user-defined function that can calculate the beta coefficient. The argu- ments to the function should be the covariance between the stock and market returns, and the variance of the market's returns. For example, BETA (COVAR AS SINGLE, MARKET VAR AS SINGLE). b. Rewrite your function so that it accepts ranges of returns and then calcu- lates the beta directly from the returns. It should be defined as: BETA(STOCK- RETURNS AS RANGE, MARKETRETURNS AS RANGE). Your function should make use of Application. WorksheetFunction to calculate the covariance and variance (use Excel's COVAR.S and VAR.S functions). In the code, be sure to check to see if the number of stock returns is equal to the number of market returns. The function should return an error if the count of returns is not equal.

A stock's beta coefficient can be calculated using the following equation: B₁ = Oi, m σε m a. Write a user-defined function that can calculate the beta coefficient. The argu- ments to the function should be the covariance between the stock and market returns, and the variance of the market's returns. For example, BETA (COVAR AS SINGLE, MARKET VAR AS SINGLE). b. Rewrite your function so that it accepts ranges of returns and then calcu- lates the beta directly from the returns. It should be defined as: BETA(STOCK- RETURNS AS RANGE, MARKETRETURNS AS RANGE). Your function should make use of Application. WorksheetFunction to calculate the covariance and variance (use Excel's COVAR.S and VAR.S functions). In the code, be sure to check to see if the number of stock returns is equal to the number of market returns. The function should return an error if the count of returns is not equal.

Intermediate Financial Management (MindTap Course List)

13th Edition

ISBN:9781337395083

Author:Eugene F. Brigham, Phillip R. Daves

Publisher:Eugene F. Brigham, Phillip R. Daves

Chapter2: Risk And Return: Part I

Section: Chapter Questions

Problem 6P: The market and Stock J have the following probability distributions: a. Calculate the expected rates...

See similar textbooks

Similar questions

Please fill out the parts in the above table that are shaded in yellow. You will notice that there are nine line items Please answer : Covariance with MP Correlation with Market Index Beta CAPM Req. Return
An ideal value-relevant attribute is one for which the correlation coefficient of the values of the attribute and the stock prices is Group of answer choices a. +2.0 b. zero c. +1.0 d. -1.0
a) Discuss the difference between a price-weighted index and a value-weighted index. Give one example for the price-weighted index and one example for the value-weighted index and discuss any problems/advantages associated with the specific indices. b) We assume that investors use mean-variance utility: U = E(r) – 0.5 × Ao², where E(r) is the expected return, A is the risk aversion coefficient and o? is the variance of returns. Given that the optimal proportion of the risky asset in the complete port- folio is given by the equation y* = E , where r; is the risk-free rate, E(rp) is the expected returm of the risky portfolio, o, is variance of returns, and A is the risk aversion coefficient. For each of the variables on the right side of the equation, discuss the impact of the variable's effect on y* and why the nature of the relationship makes sense intuitively. Assume the investor is risk averse. Ao
The Beta coefficients of TSLA and JPM are 1.99 and 1.18 respectively. What does Beta measure and how is it interpreted? Explain the beta values of TSLA and JPM by providing a calculated example of how they relate to market returns.
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
(c) Consider information given in the table below and answers the question asked thereafter: i. Calculate expected return on each stock? On the basis of this measure, which stock you will choose?ii. Calculate standard deviation of the returns on each stock? On the basis of this measure, which stock you will choose?iii. Calculate coefficient of variance of the returns on each stock? On the basis of this measure, which stock you will choose?iv. Calculate covariance and coefficient of correlation between the returns of the stocks A and B.v. Now suppose you have $100,000 to invest and you want to a hold a portfolio comprising of $35,000 invested in stock A and remaining amount in stock B. Calculate risk and return of your portfolio. (d) Firm A reports a Profit Margin of 6.5% and a Total Asset Turnover Ratio of 3.25. Their total asset level is $8,500,000. Assume there are 700,000 shares outstanding and the PE ratio is 11. Also, assume the Return on Equity is 16%. Based on this, calculate…
Consider the following regression Pt * - Pt = .07(1.4) + .4*Pt (3.6) + et where Pt * is Shiller’s ex post price of a stock, Pt is the actual price and t-ratios are in brackets. Explain in words and analytically what the dependent variable Pt * - Pt should be equal to under the efficient markets theory. Hence interpret the regression. Does it support the efficient markets theory?
When working with the CAPM, which of the following factors can be determined with the most precision? a. The beta coefficient of "the market," which is the same as the beta of an average stock. b. The beta coefficient, bi, of a relatively safe stock. c. The market risk premium (RPM). d. The most appropriate risk-free rate, rRF. e. The expected rate of return on the market, rM.
The correlation with Market index, Beta and CAPM Req. Return worked out manually.
The slope of a regression line when the return on an individual stock's returns are regressed on the return on the market portfolio, would be: OAR BR-₁ B OC none of the answers listed here. ODO im
Using the data generated in the graph, show what the information looks like in a spreadsheet. 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 does it show? Identify undervalued/overvalued investments from the graph.
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.