What is mmm beta from regression

Assignment Help Finance Basics
Reference no: EM133121568

Below is the 60 months of monthly data on the excess returns on MMM Company and the US stock market. Run a linear regression (SCL regression) of the returns on MMM on the returns on the market portfolio, using the regression tool in Excel.

a. What is MMM's beta from this regression?

b. What is MMM's monthly alpha?

c. What percentage of MMM's total risk (variance) is systematic?

 

Excess Returns

Month

MMM-rF

rM-rF

1

10.38%

9.54%

2

-2.88%

3.88%

3

0.33%

0.60%

4

2.75%

6.82%

5

1.87%

1.99%

6

5.52%

3.49%

7

1.37%

0.45%

8

3.97%

2.90%

9

-2.34%

-1.27%

10

0.50%

-1.75%

11

-8.13%

-2.36%

12

-4.14%

-5.99%

13

-13.49%

-7.59%

14

10.07%

11.35%

15

3.28%

-0.28%

16

0.85%

0.74%

17

6.09%

5.05%

18

1.71%

4.42%

19

1.84%

3.11%

20

0.17%

-0.85%

21

-4.90%

-6.19%

22

6.15%

3.89%

23

1.82%

0.79%

24

2.14%

2.55%

25

-0.20%

2.73%

26

-5.23%

-1.76%

27

4.50%

0.78%

28

2.08%

1.18%

29

8.29%

5.57%

30

4.07%

1.29%

31

2.22%

4.03%

32

-1.50%

1.55%

33

5.91%

2.80%

34

-0.83%

-1.20%

35

7.39%

5.65%

36

-2.74%

-2.71%

37

5.13%

3.77%

38

5.39%

4.18%

39

6.61%

3.12%

40

5.05%

2.81%

41

-8.60%

-3.32%

42

5.79%

4.65%

43

0.69%

0.43%

44

2.53%

-0.19%

45

3.11%

2.06%

46

0.48%

2.61%

47

-1.64%

-2.04%

48

2.81%

4.24%

49

-1.61%

-1.97%

50

8.53%          

2.52%

51

4.67%

2.55%

52

2.64%

-0.06%

53

-1.23%

-3.11%

54

4.56%

6.13%

55

-2.19%

-1.12%

56

-5.19%

0.59%

57

2.36%

1.36%

58

-3.00%

-1.53%

59

-1.92%

1.54%

60

-5.42%

-6.04%

Reference no: EM133121568

Questions Cloud

Value of a stock according to the dividend-growth model : What variables affect the value of a stock according to the dividend-growth model? What role do earnings play in this model?
What is the dollar cost of debt : The Copper Mountain Group, a private equity firm headquartered in Boulder, Colorado (US), borrows £5,000,000 for one year at 7.395% interest.
Russian-ukrainian crisis : What impact do you expect due to the "Russian-Ukrainian crisis" in terms of cryptocurrency valuation? In doing so, address both microeconomic and macroeconomic
What is the optimal hedge ratio : You have been working as a futures trader at Deutsche Bank, New York. You have collected the following information on Lean Hog. The standard deviation of monthl
What is mmm beta from regression : Below is the 60 months of monthly data on the excess returns on MMM Company and the US stock market. Run a linear regression (SCL regression) of the returns on
Show Globaltel journal entry to record its purchase of land : A recent appraisal of the land valued it at $625,000. Show Globaltel's journal entry to record its purchase of the land
Retirement of all of vitrex debt : Assume that Hi-Tech LLC operates in the tech industry. The company has an estimated beta of 1.75 and is planning on merging with Vitrex, a company that operates
Abnormal earnings model analysis : The company's actual Book Value and its forecasted earnings and dividends as well their actual and forecasted numbers of shares are given below. The expected gr
What is the correct amount of bond interest expense : Interest is paid annually on December 31. What is the correct amount of bond interest expense to be recorded on December 31, 2022 using GAAP

Reviews

Write a Review

Finance Basics Questions & Answers

  Describe organisational budgetary requirements

Describe organisational budgetary requirements and principles in relation to managing customer service engagement.

  What is the yield to maturity of the bond

What is the yield to maturity of the bond? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places.)

  What is the npv of the project

A project with a 12 year life and a cost of $250,000 generates revenue of $32,000 each year. If the discount rate is 4%, what is the NPV of the project?

  Develop an analysis of the real state market

Develop an analysis of the real state market of Loudon County, Virginia. In your analysis includes what it has changed and what it has achieved (what cause the Loudon County residential keeps increasing such as transportation, school, etc.).

  Evaluate the financial statements and the financial position

Evaluate the financial statements and the financial position of health care institutions

  Net income of 360 million roa of 10 and interest expense of

minivanluv a maker of minivans has the following financial information. net income of 3.60 million roa of 10 and

  Calculate cost of debt

Calculate the company's weighted average cost of capital assuming that its new financing will consist of 40% debt, 10% preferred stock, and 50% retained earnings.

  Examine the financial policy within the company

Find a healthcare company (department or company-wide) of your choosing and examine the financial policy within that company that supports or negates.

  Compute the expected return of akron''s equity

Compute the expected return of Akron's equity and its WACC assuming a 40 percent corporate tax rate.

  Create and validate an assessment system

Describe how you would create and validate an assessment system.

  What is the irr of opportunity

You have an investment opportunity that requires an initial investment of $8,500 today and will pay $8,000 in one year. What is the IRR of this opportunity.

  Difference between the two population means

Sum of the two samples, The difference between the two population means, The difference between the two sample means, or The sum of the two population means? Please explain your answer.

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