QUESTION 1 You have observed a particular stock over the past year. Monthly returns have been as follows: -7%, -7%, 11%, -8%, 0%, 2%, 2%, -5%, -1%, -2%, -4%, 11%. Using Excel, calculate the average monthly returns to the nearest hundredth of a percent (.01). The average function is =average(). QUESTION 2 You have observed a particular stock over the past year. Monthly returns have been as follows: 1%, -6%, 9%, -7%, 12%, -4% , -9%, -1%, 11%, 2%, -6%, -11%. Using Excel, calculate the standard deviation. For the standard deviation of a sample, use =stdev.s(). 7.886986 8.005207 6.680478 6.939129

QUESTION 1 You have observed a particular stock over the past year. Monthly returns have been as follows: -7%, -7%, 11%, -8%, 0%, 2%, 2%, -5%, -1%, -2%, -4%, 11%. Using Excel, calculate the average monthly returns to the nearest hundredth of a percent (.01). The average function is =average(). QUESTION 2 You have observed a particular stock over the past year. Monthly returns have been as follows: 1%, -6%, 9%, -7%, 12%, -4% , -9%, -1%, 11%, 2%, -6%, -11%. Using Excel, calculate the standard deviation. For the standard deviation of a sample, use =stdev.s(). 7.886986 8.005207 6.680478 6.939129

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

Calculating Real Returns and Risk Premiums You’ve observed the following returns on Bennington Corporation’s stock over the past five years: 13 percent, −8 percent, 16 percent, 16 percent, and 10 percent. Suppose the average inflation rate over this period was 1.5 percent and the average T-bill rate over the period was 5 percent. a. What was the average real return on the company's stock? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) b. What was the average nominal risk premium on the company's stock?
Problem 3:Here are the annual returns for five different stocks. Determine the expected return and risk for a period of five years for each of the stocks. Problem 4:a. Find the coefficient of variation (CV) for each of the actions in problem 3.b. Explain which of the investments a risk averse investor would prefer and which a risk lover investor would prefer. Answer clearly and in detail. Show all the computations that led to the result.
Based on five years of monthly data, you derive the following information forthe companies listed: Company SDi rm Padma 11.10% 0.82 Meghna 12.60% 0.63 Jamuna 6.60% 0.45 Karnafully 9.70% 0.70 SD on Market 7.60% 1.00 Plot the following estimated returns for the nest year on the SML and indicate which stocks are undervalued or overvalued.a. Padma – 22 percentb. Meghan – 17 percentc. Jamuna – 16 percentd. Karnafully – 12 percent.
22
You find a certain stock that had returns of 16 percent, −23 percent, 24 percent, and 9 percent for four of the last five years. The average return of the stock over this period was 10.2 percent. a. What was the stock’s return for the missing year? (Do not round intermediate calculations and enter your answer as a percent rounded to 1 decimal place, e.g., 32.1.) b. What is the standard deviation of the stock’s returns? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.)
Suppose that a stock gave a realized return of 15% over a two-year time period and a 5% return over the third year. The geometric average annual return is: ..... O A. 5.78% В. 8.67% C. 9.83% O D. 11.57%
You find a certain stock that had returns of 10 percent, −17 percent, 23 percent, and 15 percent for four of the last five years. The average return of the stock over this period was 10 percent. a. What was the stock’s return for the missing year? b. What is the standard deviation of the stock’s returns?
The last four years of returns for a stock are as follows: Year Return 1 - 4.3% 2 28.1% 3 11.6% a. What is the average annual return? b. What is the variance of the stock's returns? c. What is the standard deviation of the stock's returns? a. What is the average annual return? The average return is%. (Round to two decimal places.) 4 3.7%
A stock has had returns of 11 percent, -8 percent, 6 percent, 21 percent, 24 percent, and 16 percent over the last six years. What is the geometric retúrn for this stock? O 10.82 percent 11.13 percent O 11.31 percent O 11.42 percent O 11.47 percent
The figure in the popup window, a. The expected return. b. The standard deviation of the return. Note: Make sure to round all intermediate calculations to at least five decimal places. Graph/chart Probability (%) 35- 30- 25- 20 15- 10- 5 9 -25% shows the one-year return distribution for RCS stock. Calculate -10% 0% Return 10% 25% - Q Q 2 X
Bhupatbhai
How is this set-up to solve? Ford Stock I) & II) were in previous question GM stock produced the following monthly returns (January - May): 5%, 8%, -2%, 12%, and 15%. Ford stock produced the following monthly returns (January - May): 1%, 10%, 6%, 3%, and 2%. I) Calculate the average return for each stock. II) Calculate the standard deviation of monthly return for each stock. III) Calculate the correlation coefficient between GM and Ford stocks.

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