Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

use data from yahoo finance and and show in excel please Suppose, you have just begun working for an investment firm called Citigroup Inc. Paul,

use data from yahoo finance and and show in excel please
image text in transcribed
Suppose, you have just begun working for an investment firm called Citigroup Inc. Paul, one of the firm's founders, has been talking to you about the firm's investment portfolio. As with any investment, Paul is concerned about the risk of the investment as well as the potential return. More specifically, because the company holds a diversified portfolio, Paul is concerned about the systematic risk of current and potential investments. The company currently holds positions in stocks of Facebook, Inc. (FB) and Walmart Inc. (WMT). Citigroup 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: 7. Using monthly data for the last 60 months (November, 2017-October, 2022) estimate the average monthly returns and standard deviations for FB, WMT, Three-month Treasury Bill, and S\&P 500 (30 points) 8. Use the market model to estimate the beta for each of the two stocks (FB and WMT) using the last 60 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 ) Suppose, you have just begun working for an investment firm called Citigroup Inc. Paul, one of the firm's founders, has been talking to you about the firm's investment portfolio. As with any investment, Paul is concerned about the risk of the investment as well as the potential return. More specifically, because the company holds a diversified portfolio, Paul is concerned about the systematic risk of current and potential investments. The company currently holds positions in stocks of Facebook, Inc. (FB) and Walmart Inc. (WMT). Citigroup 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: 7. Using monthly data for the last 60 months (November, 2017-October, 2022) estimate the average monthly returns and standard deviations for FB, WMT, Three-month Treasury Bill, and S\&P 500 (30 points) 8. Use the market model to estimate the beta for each of the two stocks (FB and WMT) using the last 60 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 )

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_2

Step: 3

blur-text-image_3

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

Investments

Authors: Zvi Bodie, Alex Kane, Alan J. Marcus

7th Edition

007331465X, 978-0073314655

More Books

Students also viewed these Finance questions

Question

4. Analyzing: Breaking something down into its parts.

Answered: 1 week ago