Purchase Solution

Average monthly return and the standard deviation of returns

Not what you're looking for?

Ask Custom Question

Following you will find the end-of-month prices for both the Standard & Poor's 500 Index and Ford Motor Company common stock.
1. Calculate the average monthly return and the standard deviation of these returns for both the S&P 500 and Ford.

S&P 500 Ford
2003 November 1,055.61 13.20
December 1,108.55 16.00
2004 January 1,131.02 14.54
February 1,142.93 13.75
March 1,123.93 13.57
April 1,118.54 15.36
May 1,120.00 14.85
June 1,134.30 15.65
July 1,099.91 14.72
August 1,102.80 14.11
September 1,111.39 14.05
October 1,125.23 13.03
November 1,180.54 14.18

Attachments
Purchase this Solution
Solution Summary

Calculates average monthly return and the standard deviation of these returns for the S&P 500 and Ford.

Solution Preview

** See ATTACHED Excel file for complete solution, including formulas and calculations **

(Expected return, standard deviation, and capital asset pricing model) Following you will find the end-of-month prices for both the Standard & Poor's 500 Index and Ford Motor Company common stock.

S&P 500 Ford
2003 November 1,055.61 13.20
December 1,108.55 16.00
2004 January 1,131.02 14.54
February 1,142.93 13.75
March 1,123.93 13.57
April 1,118.54 15.36
May 1,120.00 14.85
June 1,134.30 15.65
July 1,099.91 14.72
August 1,102.80 14.11
September 1,111.39 14.05
October 1,125.23 13.03
November 1,180.54 14.18

1.       Calculate the average monthly return and the standard deviation of these returns for both the S&P 500 and Ford.

Step1 : Calculate the monthly returns

S&P ...

Purchase this Solution
Free BrainMass Quizzes
Business Processes

This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.

Motivation

This tests some key elements of major motivation theories.

Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

Operations Management

This quiz tests a student's knowledge about Operations Management

Situational Leadership

This quiz will help you better understand Situational Leadership and its theories.

View More Free Quizzes
Related BrainMass Solutions

  • Measuring risk and rates of return

    monthly returns and standard deviation To annualize these figures multiply monthly return by 12 and standard deviation of returns by √12 Annual average return= 20.04% =1.67% x 12 Annual standard deviation of return

  • Calculate Average Monthly Return, Standard deviation and Beta

    410540 Calculate Average Monthly Return, Standard deviation and Beta See the attached files. a) Following the instructions in the Appendix, obtain monthly returns for these stocks from January 2006 to December 2010.

  • Holding Period Returns and Standard Deviation

    b) Calculate the average monthly holding-period returns and the standard deviation of these returns for the S&P Index, Wal-Mart, and Target.

  • Arithmetic Average, Standard Deviation and Returns

    371195 Arithmetic Average, Standard Deviation and Returns Calculate the arithmetic average, the geometric average, the variance and standard deviation For the S&P 500 index for the decade of 1980-1990.

  • Hedge Fund Return Analysis

    Answer should be as above (ie: 10% expressed as 10.0) 4) What is the annualized standard deviation of the hedge fund return? Note the returns are reported monthly. Need to answer with annual standard deviation.

  • Index Models, CAPM and Arbitrage Pricing Theory

    What is the representative investor's average degree of risk aversion? 2. Stock A has a beta of 1.15 and a standard deviation of return of 35%. Stock B has a beta of 2.50 and a standard deviation of return of 48%.

  • Standard Deviation, correlation coefficient

    Answer: Standard deviation of return on the portfolio= 23.01% (annual) DATA Monthly return DATE Coca-Cola Citigroup Pfizer Portfolio return (weighted average of returns) (equal weights of Coca cola, Citi group and Pfizer

  • Calculating average and standard deviation of the returns

    503096 Calculate average, standard deviation and correlation of stocks by using MS Excel. Below is recent monthly stock return data for Exxon Mobil (XOM) and Microsoft (MSFT).

  • Risk Assessment, Portfolio Management

    Average monthly rate of return for each stock Nike JNJ Monthly rate of return 0.0033 0.0300 b.      Standard deviation of returns for each stock Nike JNJ Standard deviation 0.0572 0.0613 c.      

View More Related Solutions