For this exercise you would need to use the spreadsheet, Ask an Expert

Finance

For this exercise you would need to use the spreadsheet ps2.xls posted on the Blackboard.

The file contains information about monthly returns of twelve stocks, AMGN, AMZN, STX, MSFT, BA, WMT, PFE, ABB, YHOO, AAPL, VZ, GOOG, as well as the value-weighted market index excess return (MKT-RF), and the risk-free rate (RF). The sample period begins on January 2004 and ends December 2012.

The spreadsheet is set in a way that you would only need to change the values in cells H122 and T123 in order to control the portfolio weights and the stock/portfolio chosen for the regression calculation.

(a) Calculate the Beta and of each stock by running a regression of the monthly returns of the stock (excess of the risk-free rate) on the monthly returns of the value-weighted market index (excess of the risk-free rate ). The latter are denoted MKT-RF and they are located on Column P (notice the risk-free rate has already been subtracted from the index). You can choose different stocks by changing the values in cell T123. This would immediately provide you with the excess returns of each stock in Column T. These returns should be used for the regression.

View complete question

Financial Management, Finance

Category:- Financial Management
Reference No.:- M92845555

Have any Question?Write your Review or question?

Related Questions in Financial Management

Part a-budgeting amp financial analysisassume the following

Part A-Budgeting & Financial Analysis Assume the following data for Spring Break Corp: Statement of Income: Balance Sheet: 2017 ...

Corporate financial management questions -part a -q1 200

Corporate Financial Management Questions - Part A - Q1. $200 invested today and earning 8 per cent per annum compounded semi-annually will grow to what amount at the end of three years? (A) $158.80 (B) $251.94 (C) $380.7 ...

Reflection papernbsp instructionsas you continue on your

Reflection Paper : Instructions As you continue on your quest for academic success, it is important to share your knowledge with others. In fact, you have been asked to provide advice to future students on academic inte ...

Assignmentthe purpose of this assignment is to allow you

Assignment The purpose of this assignment is to allow you the chance to evaluate the role of social responsibility in society. After you complete this assignment, you will analyze a written article, be able to ascertain ...

Company x is an american manufacturing company getting

Company X is an American manufacturing company getting ready to start selling its products in Mexico. You are the manager of a team tasked with assessing the potential risks to the company as it gets ready to expand to a ...

Assignment - capital asset pricing model and required

Assignment - Capital asset pricing model and required returns 1. Select two stocks that have prices available for the last ten years. (You may find it more interesting if you select one stock that is relatively risky and ...

Part 1 conduct internet research sources must be documented

Part 1. Conduct Internet research, (sources must be documented using MLA format), and write a brief analysis of the current status of the U.S. economy. Include current values and trends for at least three of the followin ...

1 from everything youve learned in the past weeks did your

1. From everything you've learned in the past weeks, did your decision-making skills improve based on the problem-solving model? Please provide an explanation. 2. Did the analysis tools provided throughout the course hel ...

Qestionsforecast 2019 revenue column m by estimating the

Questions: Forecast 2019 revenue (Column M) by estimating the % growth drivers (Column R). Forecast 2019 expenses (Column M) by estimating the expense as % of revenue drivers (Column X). Write your rationale for each ass ...

Question spirituality is a fundamental and universal

Question : Spirituality is a fundamental and universal aspect of human existence and is a critical component in working with clients, groups, communities, etc. There is a vast diversity in spiritual beliefs and religious ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Financial Management Expert