Purchase Solution

Analyze XYZ Company Financial Data and Stock Performance

Not what you're looking for?

Ask Custom Question

See attached data for XYZ Company.

Guidelines:

Find an estimate of the risk-free rate of interest (krf). To obtain this value, go to

http://www.bloomberg.com/markets/home_v2

Use the "U.S. 10-year Treasury" bond rate (middle column) as the risk-free rate. In addition, you also need a value for the market risk premium.

Use an assumed market risk premium of 7.5

Using the information from the XYZ Stock Information document, record the following values:
XYZ's beta (Ã??)
XYZ's current annual dividend
XYZ's 3-year dividend growth rate (g)
Industry P/E
XYZ's EPS

With the information you recorded, use the CAPM to calculate XYZ's required rate of return (ks).
Use the CGM to find the current stock price for XYZ. We will call this the theoretical price (Po).

Now use the XYZ Stock Information document to find XYZ's current stock quote (P). Compare Po and P and answer the following questions:

Are there any differences?
What factors may be at work for such a difference in the two prices?

Now assume the market risk premium has increased from 7.5% to 10% and this increase is due only to the increased risk in the market. In other words, assume the krf and the stock's beta remain the same for this exercise.
What will the new price be? Explain.

Recalculate XYZ's stock price using the P/E ratio model and the needed info found in the XYZ Stock Information file.
Why is the present stock price different from the price arrived at using CGM (Constant Growth Model)?

If you used Microsoft Word to arrive at your answers, then you must provide an explanation of the formulas and calculations.

This paper must include the following:

All of the numerical values listed in the assignment guidelines.
Your answers to the four questions in the assignment guidelines.
The formulas and calculations that you used to arrive at your answers

You must include your explanation of how you used Microsoft Excel for your calculations if applicable.

Purchase this Solution

Solution Summary

This solution calculates the theoretical price of Microsoft using CAPM and CGM and discusses the difference between this number and the current stock prive.

Solution Preview

Please see the attached file for better format.

I have taken Microsoft as a company

Information for Microsoft is following:
Beta: 1.01
Current annual dividend : 0.64
3-year dividend growth rate (g) : 13.3% but I have normalized to 8%
EPS = 2.69
Industry P/E : 19.7
http://moneycentral.msn.com/investor/invsub/results/statemnt.aspx?symbol=MSFT
With the information you recorded, use the CAPM to calculate XYZ's required rate of return (ks).

The cost of equity for Microsoft= Here Beta of Microsoft= 1.01
Risk free rate=2.22%
http://www.bloomberg.com/markets/rates-bonds/government-bonds/us/

Hence cost of equity As per CAPM= Risk free rate+ Beta * Risk Premium
=2.22%+1.01*7.5%
=9.8%

Use the CGM to find the current stock price for XYZ. We will call this ...

Purchase this Solution


Free BrainMass Quizzes
Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

IPOs

This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

Paradigms and Frameworks of Management Research

This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.

SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.