Compute the average monthly return for intc

Assignment Help Finance Basics
Reference no: EM133071728

The Stock Data below contains monthly data for several stocks and the S&P 500 Index (i.e., the market).  

  1. Compute the average monthly return for INTC and the S&P 500.
  2. Compute the annualized return on a Simple Basis for INTC and the S&P 500.
  3. Compute the annual variance and the annual standard deviation for INTC and the S&P 500.
  4. Compute the annual variance and the annual standard deviation for a stock if the stock's quarterly variance is 3%.

Monthly Return Data for Several Stocks and the S & P 500

 

 

 

Month

Cin

Dell

INTC

MSFT

NT

PFE

S&P 500

1

-2.90%

-9.51%

1.94%

-16.18%

-3.23%

4.31%

2.40%

2

4.79%

10.51%

10.47%

12.03%

16.66%

7.61%

5.20%

3

2.91%

7.93%

12.07%

8.29%

-0.72%

-0.56%

4.00%

4

4.25%

-7.34%

-10.77%

-12.40%

2.16%

-5.94%

-0.50%

5

5.30%

-14.27%

5.18%

3.30%

13.38%

14.35%

9.00%

6

-0.88%

3.70%

-1.64%

7.31%

10.56%

6.54%

1.90%

7

3.54%

1.78%

7.50%

16.59%

-3.93%

-0.90%

-0.40%

8

3.76%

-15.77%

4.65%

19.34%

5.85%

-1.45%

-2.30%

9

2.94%

-4.16%

2.96%

6.42%

-2.76%

10.47%

2.10%

10

2.86%

-4.34%

-0.72%

0.00%

5.11%

-6.24%

2.40%

11

-0.86%

-15.88%

14.50%

6.32%

1.08%

-1.44%

-6.70%

12

0.41%

35.06%

1.90%

6.76%

3.74%

-13.12%

1.30%

13

-2.85%

21.97%

3.73%

12.15%

2.06%

2.76%

2.60%

14

-3.05%

11.46%

-5.39%

4.74%

-4.55%

-6.39%

-2.50%

15

4.85%

29.49%

22.15%

25.86%

17.46%

17.24%

9.80%

16

1.26%

14.75%

-2.59%

4.11%

-0.45%

-2.66%

-0.70%

17

5.82%

-6.92%

-5.32%

-12.50%

-1.81%

18.13%

-0.30%

18

-7.20%

0.00%

-24.99%

-7.52%

-11.98%

-5.49%

-9.00%

19

-0.86%

-25.57%

-0.38%

2.44%

-2.09%

-0.53%

-4.90%

20

5.10%

21.51%

0.75%

1.19%

12.84%

3.01%

-0.40%

21

1.69%

23.49%

11.94%

13.33%

-2.37%

11.90%

6.40%

22

-0.83%

40.97%

2.66%

4.16%

9.71%

0.00%

2.70%

23

0.86%

22.31%

18.83%

30.40%

-1.77%

11.30%

4.40%

24

4.66%

11.58%

4.37%

5.73%

5.86%

17.59%

7.20%

25

4.45%

12.89%

-2.10%

2.29%

6.81%

1.90%

2.40%

26

0.34%

-17.99%

5.35%

-6.71%

11.55%

1.87%

0.30%

27

0.00%

5.87%

13.20%

10.86%

7.14%

8.65%

4.30%

28

1.18%

-1.01%

-16.59%

-6.89%

-2.67%

-5.73%

-4.60%

29

6.25%

17.36%

1.08%

7.89%

8.90%

11.49%

4.70%

30

0.37%

13.46%

5.32%

15.99%

0.31%

6.43%

2.40%

31

5.95%

2.32%

-14.65%

4.40%

-1.57%

-0.57%

-1.60%

32

0.00%

-25.48%

-3.83%

5.48%

6.69%

9.98%

1.30%

33

6.43%

-5.52%

0.91%

3.59%

4.18%

-6.88%

-4.00%

34

7.72%

9.03%

19.51%

14.40%

3.15%

26.55%

11.40%

35

-6.22%

24.39%

22.21%

8.09%

3.89%

-13.09%

-1.90%

Reference no: EM133071728

Questions Cloud

Compute pv of difference between two alternatives : You can purchase a car for $15,000. The dealer offers you the choice between $2,500 dollars cash back or a promotional 2.0% annual rate on a loan.
What amount will lenny pay for the t-note : After holding the Treasury note for 60 days, Lenny sells it to another trader for $996. What amount will Lenny pay for the T-note
What is the total return in one month : 1. If you buy Disney stock at $85/ share and sell it for $90/ share and they pay a $1 dividend during that month. What is the total return (expressed as a perce
Company return on equity : Madonna, Inc. ROE last year was only 5%; but its management has developed a new operating plan that calls for a debt-to-capital ratio of 40%, which will result
Compute the average monthly return for intc : The Stock Data below contains monthly data for several stocks and the S&P 500 Index (i.e., the market).
Prepare general journal entries for jimmy ltd : Prepare general journal entries for Jimmy Ltd to record all the above events in 2020 for its investment in Fallon Ltd, using the equity method
Compute the firm annualized cost of equity : Assume the current selling price of a firm's stock is: $72. Using the Excel data below, Dividend Data, compute the firm's annualized cost of equity using the G
Does the determined cost compare favorably with a cost : Does the determined cost compare favorably with a cost that is determined based on 130% of the variable cost per unit, which is currently $ 18
What was the operating income : If Trasher uses absorption costing and allocate actual fixed manufacturing costs to inventory on the basis of actual tons produced. What was operating income

Reviews

Write a Review

Finance Basics Questions & Answers

  Discuss the multiattribute attitude model

Using the multiattribute attitude model, identify the probable choice of a local car dealer for a young, single woman and for a retired couple.

  Comment on priceline’s method of booking revenue

Why do you think that the SEC is clamping down on unethical accounting practices of Internet companies-most importantly, including as revenue "gross" versus "net" bookings?

  How many members serve on the gasb

Could a profit-oriented enterprise use fund accounting practices? Comment.- How many members serve on the GASB? How many votes are needed to issue a pronouncement?

  Technologies onslaught on morality

Technologies onslaught on morality discussing, amongst other things, the moral dilemmas raised by cloning.

  What was the average real risk-free rate over time

The average inflation rate over this period was 3.34 percent and the average T-bill rate over the period was 4.3 percent.

  Prepare a written report addressing the company management

ASB 2202 - Finance Assignment. Working alone, you are required to prepare a written report addressing the company's management

  Find the equivalent annual annuity value

The cost of funds is 6%. Find the equivalent annual annuity value needed to compare it to a six year project.

  How much are dave’s cash flows reduced over the coming year

Assuming that Dave's marginal tax bracket is 25%, by how much should his federal taxes decline this year if he contributes $7,000 to his retirement account?

  Examples on issues with the world trade organisation

Provide examples on issues with the World Trade Organisation (WTO).

  In addition to using financial options

In addition to using financial options, what do you think Porsche should do to manage its USD economic exposure?

  Computation of profit margin

Computation of profit margin and total asset turnover and return on total assets for two consecutive years and Comment on such results

  What will the balance on charlene loan be at the end

What will the balance on Charlene's loan be at the end of the fourth year (that is, immediately after Charlene makes her 48th payment on the loan)?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd