Consider the following sample of annual holding period returns on Masco (a corporation) and theS&P500 Stock Index (includes dividends and capital gains). Assume that the Market Portfiolio iscomposed of individual US stocks only, so that the S&P 500 Stock Index is a good proxy of theMarket Portfolio.Dater S&P5001-Nov-071-Nov-061-Nov-051-Nov-043-Nov-031-Nov-021-Nov-011-Nov-001-Nov-992-Nov-983-Nov-971-Nov-961-Nov-951-Nov-941-Nov-932-Nov-921-Nov-911-Nov-901-Nov-891-Nov-882-Nov-87-0.07490.01650.03520.03860.00710.05710.0752-0.08010.01910.05910.04460.07340.0410-0.0395-0.01290.0303-0.04390.05990.0165-0.0189-0.0853r Masco-0.07560.03740.04440.0294-0.0109-0.01880.06260.0331-0.16840.02420.07240.16410.0488-0.06400.07480.0693-0.12030.06750.0146-0.0806-0.1607a) Use Excel to calculate Masco's beta given the data above.b) Use the data sample and your answer to b) to estimate the expected return on Mascostock according to the CAPM and according to the historical method. Assume that therisk-free rate is 4.5% per year.What is the alpha of Masco? Is the stock underpriced or overpriced according to theCAPM?

The unpredictability or fluctuation of investment results is referred to as risk. Investments with a…

Consider the following sample of annual holding period returns on Masco (a corporation) and the S&P500 Stock Index (includes dividends and capital gains). Assume that the Market Portfiolio is composed of individual US stocks only, so that the S&P 500 Stock Index is a good proxy of the Market Portfolio. Date r S&P500 1-Nov-07 1-Nov-06 1-Nov-05 1-Nov-04 3-Nov-03 1-Nov-02 1-Nov-01 -0.0749 0.0165 0.0352 0.0386 0.0071 0.0571 0.0752 r Masco -0.0756 0.0374 0.0444 0.0294 -0.0109 -0.0188 0.0626

Consider the following sample of annual holding period returns on Masco (a corporation) and the S&P500 Stock Index (includes dividends and capital gains). Assume that the Market Portfiolio is composed of individual US stocks only, so that the S&P 500 Stock Index is a good proxy of the Market Portfolio. Date r S&P500 1-Nov-07 1-Nov-06 1-Nov-05 1-Nov-04 3-Nov-03 1-Nov-02 1-Nov-01 -0.0749 0.0165 0.0352 0.0386 0.0071 0.0571 0.0752 r Masco -0.0756 0.0374 0.0444 0.0294 -0.0109 -0.0188 0.0626

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

(similar to) Question Help Integrative-Risk and Valuation Given the following information for the stock of Foster Company, calculate the risk premium on its common stock. (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) $46.71 D Current price per share of common stock Expected dividend per share next year Constant annual dividend growth rate $4.91 5.2% Risk-free rate of return 5.8% The risk premium on Foster stock is %. (Round to two decimal places.)
Suppose we have the following returns for large-company stocks and Treasury bills over a six-year period: Year Large-Company US Treasury Bill 1 3.91 5.87 14.35 2.51 19.29 3.74 -14.39 7.15 2 23 a. 3 4 5 6 Calculate the arithmetic average returns for large-company stocks and T-bills over this time period. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) b. Calculate the standard deviation of the returns for large-company stocks and T-bills over this time period. (Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) c-1. Calculate the observed risk premium in each year for the large-company stocks versus the T-bills. What was the arithmetic average risk premium over this period? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) -31.88…
(Solving a comprehensive problem) Use the end-of-year stock price data in the popup window,, to answer the following questions for the Harris and Pinwheel companies. a. Compute the annual rates of return for each time period and for both firms. b. Calculate both the arithmetic and the geometric mean rates of return for the entire three-year period using your annual rates of return from part a. (Note: you may assume that neither firm pays any dividends.) c. Compute a three-year rate of return spanning the entire period (i.e., using the ending price for period 1 and ending price for period 4). d. Since the rate of return calculated in part c is a three-year rate of return, convert it to an annual rate of return by using the following equation: 1 + Three-Year Rate of Return 1 + Annual Rate of Return 3 e. How is the annual rate of return calculated in part d related to the geometric rate of return? When you are evaluating the performance of an investment that has been held for several…
Bartman Industries' and Reynolds Inc.'s stock prices and dividends, along with the Winslow 5000 Index, are shown here for the period 2015-2020. The Winslow 5000 data are adjusted to include dividends. Calculate the standard deviations of the returns for Bartman, Reynolds, and the Winslow 5000. (Hint: Use the sample standard deviation formula, STDEV function in Excel). Bartman Industries Reynolds Inc. Winslow 5000 Year Stock Price Dividend Holding period return Stock Price Dividend Holding period return Includes Divs. Holding period return 2020 $17.25 $1.15 $48.75 $3.00 11,663.98 2019 14.75 1.06 52.30 2.90 8,785.70 2018 16.50 1.00 48.75 2.75 8,679.98 2017 10.75 0.95 57.25 2.50 6,434.03 2016 11.37 0.90 60.00 2.25 5,602.28 2015 7.62 55.75 4,705.97
Haresh
None
Please see attached.
None
A stock has had the following year-end prices and dividends: Year 1 Price Dividend $ 43.41 2 48.39 $0.66 3 57.31 0.69 4 45.39 0.80 5 52.31 0.85 6 61.39 0.93 What are the arithmetic and geometric returns for the stock? (Do not round intermediate calculations. Round the final answers to 2 decimal places.)
The following table displays hypothetical stock quotations. Use the information in the table to answer the questions that follow. Listed Stock Quotes Company Ticker High Low Last Price* Net Change** YTD %*** Div. Yield P/E Ratio MarkMin MM 93.06 67.68 84.60 4.56 1.66 0 46 MarlRedBiro MRB 14.00 9.15 10.77 2.01 7.19 6.0 10 TStar TS 341.06 221.69 284.22 2.70 5.02 2.4 26 *Last price for the day **Net change in price from previous day ***Year-to-date percentage change in stock price Of the three stocks listed, a retiree who lives partially off of investment income would be best off holding because of its . You can calculate that MarkMin had per-share earnings for the most recent 12-month period of . If you had purchased 100 shares of TStar stock yesterday at the last price of the day, you would have of if you sold all 100 shares at the last price today.
Use the information in the following stock quote to answer the question: As of February 1, 2XX1 Name Symbol Open High Low Close Net Chg Div Yield PE Target TGT 87.01 87.32 86.75 87.05 -0.32 2.56 2.93 16.76 What was Target’s earnings per share over the last year? (Round your answer to 2 decimal places. (e.g., 32.16))
How can I calculate geometric average in Excel?

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS