You are given the following set of data: HISTORICAL RATES OF RETURN Year NYSE Stock X 1 - 26.5% - 22.0% 2 37.2 15.0 3 23.8 10.0 4 - 7.2 4.0 5 6.6 11.8 6 7 20.5 30.6 18.9 17.6 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 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. Average return, Aug Standard deviation, σ NYSE Stock X % % % % d. Plot the Security Market Line. Select the correct graph. The correct graph is Security Market Line 10- 10- 10- 05 Security Market Line (%) Security Market Line Security Market Line 201 Beta Beta c. Assume that the situation during Years 1 to 7 is expected to prevail in the future (i.e., x = FX,Average MTM,Average, and both σx and bx in the future will equal their past values). Also assume that Stock X is in equilibrium - that is, it plots on the Security Market Line. What is the risk-free rate? Do not round intermediate calculations. Round your answer to two decimal places. % d. Plot the Security Market Line. 05 Вета e. Suppose you hold a large, well-diversified portfolio and are considering adding to that portfolio either Stock X or another stock, Stock Y, which has the same beta as Stock X but a higher standard deviation of returns. Stocks X and Y have the same expected returns: fx- fy 10.6%. Which stock should you choose?
You are given the following set of data: HISTORICAL RATES OF RETURN Year NYSE Stock X 1 - 26.5% - 22.0% 2 37.2 15.0 3 23.8 10.0 4 - 7.2 4.0 5 6.6 11.8 6 7 20.5 30.6 18.9 17.6 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 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. Average return, Aug Standard deviation, σ NYSE Stock X % % % % d. Plot the Security Market Line. Select the correct graph. The correct graph is Security Market Line 10- 10- 10- 05 Security Market Line (%) Security Market Line Security Market Line 201 Beta Beta c. Assume that the situation during Years 1 to 7 is expected to prevail in the future (i.e., x = FX,Average MTM,Average, and both σx and bx in the future will equal their past values). Also assume that Stock X is in equilibrium - that is, it plots on the Security Market Line. What is the risk-free rate? Do not round intermediate calculations. Round your answer to two decimal places. % d. Plot the Security Market Line. 05 Вета e. Suppose you hold a large, well-diversified portfolio and are considering adding to that portfolio either Stock X or another stock, Stock Y, which has the same beta as Stock X but a higher standard deviation of returns. Stocks X and Y have the same expected returns: fx- fy 10.6%. Which stock should you choose?
Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter20: Activity-based Costing (abc)
Section: Chapter Questions
Problem 5R
Related questions
Question
None
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Fundamentals of Financial Management, Concise Edi…
Finance
ISBN:
9781285065137
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Fundamentals of Financial Management, Concise Edi…
Finance
ISBN:
9781305635937
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Fundamentals of Financial Management, Concise Edi…
Finance
ISBN:
9781285065137
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Fundamentals of Financial Management, Concise Edi…
Finance
ISBN:
9781305635937
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Essentials Of Business Analytics
Statistics
ISBN:
9781285187273
Author:
Camm, Jeff.
Publisher:
Cengage Learning,
College Accounting, Chapters 1-27
Accounting
ISBN:
9781337794756
Author:
HEINTZ, James A.
Publisher:
Cengage Learning,