Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider two companies. CVS Health Corporation (ticker: CVS, the CEO is Karen Lynch) is a healthcare conglomerate that operates pharmacies, sells health insurance, and provides

Consider two companies. CVS Health Corporation (ticker: CVS, the CEO is Karen Lynch) is a healthcare conglomerate that operates pharmacies, sells health insurance, and provides a variety of other healthcare services. Citigroup (ticker: C, the CEO is Jane Fraser) is a financial services conglomerate that provides both traditional and investment banking services. Find monthly stock price data for both companies for the past 5 years up to and including February 1, 2023. Do the following for both companies: From prices, calculate monthly returns. Calculate average arithmetic monthly and annual returns. Calculate monthly and annual standard deviations. Calculate the covariance of the two stocks’ returns, and the correlation. Using the monthly price data for the S&P 500 for the past 5 years available on Canvas in the AMZN Excel file, compute the beta for each stock (CVS and C) relative to the S&P 500. Compare the beta you have calculated to a published beta from some source such as Yahoo! Finance. How close did you get? Suppose that the risk-free rate is 3.5% and the equity market risk premium for large stocks is 8.7%. What is your estimate of the expected return for each stock? Suppose you want to construct a portfolio of just CVS and C. You want to minimize the standard deviation of this portfolio. How much of your portfolio would you invest in each stock? What is this portfolio's expected return?


Step by Step Solution

3.47 Rating (154 Votes )

There are 3 Steps involved in it

Step: 1

CVS Monthly returns DateReturn 20180301074 20180401118 20180501101 Average arithmetic monthly return ... 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

Business Ethics Ethical Decision Making and Cases

Authors: O. C. Ferrell

11th Edition

1305500846, 1305500849, 9781305856233 , 978-1305500846

More Books

Students also viewed these Finance questions

Question

Is it eyewitness or hearsay evidence?

Answered: 1 week ago

Question

Describe the ethical issues that Daniel is encountering.

Answered: 1 week ago