Closing prices for Sillech and New Mines for the years 1999-2014 are shown below. a. Calculate the total returns for each stock for the years 2000-2014 to three decimal places. Note that the price for 1999 is used to calculate the return for 2000. b. Assume that similar returns will continue in the future (i.e., average returns= expected returns). Calculate the expected return, variance, and standard deviation for both stocks and insert these values in the spreadsheet. Use Average, Var, and STDEV functions.

Closing prices for Sillech and New Mines for the years 1999-2014 are shown below. a. Calculate the total returns for each stock for the years 2000-2014 to three decimal places. Note that the price for 1999 is used to calculate the return for 2000. b. Assume that similar returns will continue in the future (i.e., average returns= expected returns). Calculate the expected return, variance, and standard deviation for both stocks and insert these values in the spreadsheet. Use Average, Var, and STDEV functions.

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

Calculate the rate of return on a price-weighted index of the three stocks for the first period (t = 0 to t = 1). (Do not round intermediate calculations. Round your answer to 2 decimal places.) What will be the divisor for the price-weighted index in year 2? (Do not round intermediate calculations. Round your answer to 2 decimal places.)
The following table represents the rate of returns of two stocks in different economic conditions along with their probabilities (the data are also uploaded on moodle) RATES OF RETURN ON STOCKS EXPECTED ECONOMIC PROBABILITY STOCK A STOCK B CONDITIONS RECESSION 0.55 -0.04 -0.02 STABLE 0.35 0.25 0.30 EXPANDING 0.10 0.15 0.20 Answer the following by using mathematical calculations: a) Calculate the expected rate of return for each stock respectively. Explain what the expected value implies. b) Calculate the standard deviation for each stock respectively. Explain what the standard deviation implies. c) If you were an investor in which stock you were going to invest? Justify your answer. d) Calculate the covariance between Stock A and stock B. Discuss. e) Calculate the expected return and the standard deviation of the portfolio consisting 40% in stock A and 60% in stock B. f) Discuss the risk and return associated with investing i All of your funds in stock A ii. All of your funds in stock…
A challenge we run into when forecasting future stock returns is that stock returns compound. So, when using historical averages to forecast the future, we need to average together the arithmetic and geometric average returns using Blume's Formula: R(T) = T GeoAvg + NT Arith Avg N-1 In this formula, N is the number of historical annual returns you are using to calculate your averages and T is the number of future annual returns you are forecasting. Suppose you gather the following prices for a stock in order to calculate the last 10 (N = 10) annual returns. The stock does not pay dividends. Time 0 1 Time 0 calculate the last 10 (N=10) annual returns. The stock does not pay dividends. 1 2 3 4 5 10 6 . 7 8 9 10 Price $23.16 $32.81 Price $23.16 $32.81 $33.63 $36.83 $41.95 $41.04 $33.83 $37.45 $30.56 $29.90 $47.93 Using Blume's formula, what is the expected return per year for the next 4 years (T = 4)? Enter your answer as a percentage, rounded to the nearest 0.0001. For example, for…
The index model has been estimated using historical excess return data for stocks A, B, and C, with the following results: RA = 0.02 + 0.9RM + eA RB = 0.04 + 1.2RM + eB RC = 0.10 + 1.ORM + eC OM oM = 0.22 o(eA) = 0.21 o(eB ) = 0.11 o(eC ) = 0.23 a. What are the standard deviations of stocks A, B, and C? b. Break down the variances of stocks A, B, and C into their systematic and firm-specific components. c. What is the covariance between the returns on each pair of stocks? d. What is the covariance between each stock and the market index?
Consider the following information: a. Calculate the expected return for the two stocks. Note: Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places. b. Calculate the standard deviation for the two stocks. Note: Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places.
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 that the index model for stocks A and B is estimated from excess returns with the following results: RA = 3.2% + 1.10RM + eA RB = –1.4% + 1.2RM + eB σM = 30%; R-squareA = 0.28; R-squareB = 0.12 What is the standard deviation of each stock? (Do not round intermediate calculations. Round your answers to 2 decimal places.)
You are given the following information: State ofEconomy Return onStock A Return onStock B Bear .112 −.055 Normal .105 .158 Bull .083 .243 Assume each state of the economy is equally likely to happen. a. Calculate the expected return of each stock. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) b. Calculate the standard deviation of each stock. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) c. What is the covariance between the returns of the two stocks? (A negative answer should be indicated by a minus sign, Do not round intermediate calculations and round your answer to 6 decimal places, e.g., .161616.) d. What is the correlation between the returns of the two stocks? (A negative answer should be indicated by a minus sign, Do not round intermediate calculations and round your answer to 4…
You are given the following information: State of Economy Bear Normal Bull Return on Stock A a. Stock A Stock B b. Stock A Stock B 114 103 085 Assume each state of the economy is equally likely to happen. a. Calculate the expected return of each stock. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) b. Calculate the standard deviation of each stock. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) c. What is the covariance between the returns of the two stocks? (A negative answer should be indicated by a minus sign, Do not round intermediate calculations and round your answer to 6 decimal places, e.g., .161616.) d. What is the correlation between the returns of the two stocks? (A negative answer should be indicated by a minus sign, Do not round intermediate calculations and round your answer to 4 decimal places, e.g., .1616.) Return on Stock B C.…
Given the data in the table, calculate Beta and Covariance.
Suppose that the index model for stocks A and B is estimated from excess returns with the following results: RA= 3.2% + 1.10RM + eA RB = -1.4 % + 1.25RM + eB OM= 30%; R-squareд = 0.28; R-squareg = 0.12 What is the covariance between each stock and the market index? Note: Calculate using numbers in decimal form, not percentages. For example use "20" for calculation if standard deviation is provided as 20%. Do not round your intermediate calculations. Round your answers to nearest whole number. Answer is complete but not entirely correct. Stock A Stock B Covariance 93 x 101 x
Consider the following information: State of Economy Probability of State of Economy Rate of Return if State Occurs Stock A Stock B Recession 0.35 0.06 -0.15 Normal 0.40 0.09 0.16 Boom 0.25 0.13 0.36 Calculate the expected return for the two stocks. Note: Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places. Calculate the standard deviation for the two stocks. Note: Do not round your intermediate calculations. Enter your answers as a percent rounded to 2 decimal places.

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