Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The table below gives a sample of artificial historical data for an energy company (Stock A) and a phone company (Stock B). Each indicated return

The table below gives a sample of artificial historical data for an energy company (Stock A) and a phone company (Stock B). Each indicated return rate is end of month to end of month and is based on adjusted closing prices. For example, RA Jan-2012 is the return rate from the last trading day in December 2011 to the last trading day in January 2012. Using the table, express your answers in percentages where appropriate.

image text in transcribed

  1. a) Sketch the graph of the monthly total return rates of each stock as a function of time during 2012. Briefly discuss the movement of the stocks during two equal-length-time periods in 2012.

  2. b) Estimate the expected monthly total return rate of each stock in the table. What is your answer if you use data only from Dec-2011 to Jun-2012? Compute the monthly volatility of each stock for the year 2012.

  3. c) Estimate the monthly variance of each stock and determine the covariance and correlation coefficient between the monthly total return rates for the two stocks during 2012. Is the result what you expected? Briefly discuss.

Date Rmonthly Ronthly Jan-2012 2.45% 2.69% Feb-2012 3.35% 1.81% Mar-2012 3.24% 4.94% Apr-2012 2.93% 5.88% May-2012 6.13% 2.51% Jun-2012 6.19% -0.35% Jul-2012 0.78% 1.59% Aug-2012 -0.19% -3.83% Sep-2012 4.65% 5.24% Oct-2012 3.53% 4.85% Nov-2012 5.03% 2.48% Dec-2012 -1.71% 4.03%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_step_2

Step: 3

blur-text-image_step3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions