Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Covili and Wyatt currently uses a commercial data vendor for information about its positions. Because of this, Paul is unsure exactly how the numbers provided

Covili and Wyatt currently uses a commercial data vendor for information about its positions. Because of this, Paul is unsure exactly how the numbers provided are calculated. The data provider considers its methods proprietary, and it will not disclose how stock betas and other information are calculated. Paul is uncomfortable with not knowing exactly how these numbers are being computed and also believes that it could be less expensive to calculate the necessary statistics in-house. To explore this question, Paul has asked you to do the following assignments.Questions:6. Using monthly data for the last 73 months estimate the average monthly returns and standard deviations for FB, WMT, Three-month Treasury Bill, and S&P 500 (30 points)7. Use the market model to estimate the beta for each of the two stocks (FB and WMT) using the last 72 months risk premiums. Then, estimate the annual required return for each stock based on CAPM using the estimated betas, the average market risk premium and the average risk free rate. (30 points)Instructions for Task 2:1. You may download data from the following sources:a.Go to www.finance.yahoo.com and download the ending monthly stock prices for the last 73 months. Use the adjusted closing price, which adjusts for dividend payments and stock splits.b. Go to www.finance.yahoo.com and download the ending value of the S&P 500 index (^GSPC) for the last 73 months. c.Go to the St. Louis Federal Reserve website (www.stlouisfed.org) and download the three-month Treasury bill secondary market rate (TB3MS) for the last 73 months. 2. Beta is often estimated by linear regression. A model commonly used is called the market model, which is:Rt Rft = i + i [RMt Rft] + tWhere, Rt = Return on the stock Rft = Risk-free rateRMt = Return on a stock market index such as the S&P 500 indexi = Intercept of the regression i = Slope of the regression (or the stock's estimated beta)

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: 3

blur-text-image

Ace Your Homework with AI

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

Get Started

Recommended Textbook for

Principles Of Managerial Finance

Authors: Chad Zutter, Scott Smart

16th Global Edition

1292400641, 978-1292400648

More Books

Students also viewed these Finance questions

Question

Where do the authors work?

Answered: 1 week ago

Question

What is the role of communication (Chapter 4) in leadership?

Answered: 1 week ago