Question: This question requires data collection. You can find all numbers on finance.yahoo.com. The questions concern Microsoft (ticker: MSFT). (a) What is the current price and

This question requires data collection. You can find all numbers on finance.yahoo.com. The questions concern Microsoft (ticker: MSFT).

(a) What is the current price and the current price-earnings ratio?

(b) What is the current plowback ratio?

(c) What is the growth rate of earnings for the next 5 years according to the analysts? Hint: look for annual growth rates under \analyst estimates"

(d) What is the beta of MSFT? Hint: look for \key statistics". If the risk-free rate ( R f ) is 4% and the market risk premium E [ R M R f ] is 6%, what is the required rate of return on MSF according to the CAPM?

(e) Assume that Microsoft will have earnings and dividends that will grow at the analysts forecasted rate forever after; i.e., the Gordon growth model (GGM) applies. What is the price-earnings ratio that the GGM predicts for Microsoft?

(f) What growth rate does the market price-earnings ratio price in/imply?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Q1 Suppose that there are two securities RAIN and SUN. RAIN pays $100 if there is any rain during the next world cup soccer final. SUN pays $100 if there is no rain. Suppose that the world cup soccer...

11. This question requires data collection. You can find all numbers on finance.yahoo.com The questions concern Microsoft (ticker: MSFT) (a) What are the current price and the current price-earnings...

This question requires data collection. You can find all numbers on finance.yahoo.com. The questions concern Microsoft (ticker: MSFT). (a) What are the current price and the current price-earnings...

This question requires data collection. You can find all numbers on finance.yahoo.com. The questions concern Microsoft (ticker: MSFT). (a) What is the current price and the current price-earnings...

4. This question requires data collection. You can find all numbers on finance.yahoo.com. The questions concern Walmart (ticker: WMT). (a) What is the current price and the current price-earnings...

3. This question requires data collection. You can find all numbers on http://finance.yahoo.com. The questions concern HP Inc. (ticker: HPQ). On April 7, 2022, Warren Buffetts firm Berkshire Hathaway...

1. XYZ Inc. has expected earnings over the next year of $2/share (E1 = 2). The company is expected to maintain an earnings retention rate of 40%, i.e., 60% of earnings are expected to be paid out as...

Excel question: This question requires data collection. You can find all numbers at http://finance.yahoo.com/. The questions concern Walmart Inc. (ticker: WMT). (a) What is the current price and the...

Question 1: A hedge fund expects that proposed elimination of the personal taxation on dividends will be enacted and that this tax reform will benefit particularly stocks paying high dividends. The...

The following purchase transactions occurred during August for Elegance Catering Service: Aug. 11. Purchased party supplies for $390, on account from Party Zone Supplies Inc. 14. Purchased party...

Mike Greenberg opened Pina Colada Window Washing Inc. on July 1, 2022. During July, the following transactions were completed. Issued 11,500 shares of common stock for $11,500 cash. Purchased used...

1. How much would Annette (a) receive in initial loan proceeds and (b) be required to repay at maturity under the California State Bank loan?

5. Develop a scenario comparing two PH programs and involving the use of a CBA.

(Appendices) Select a commonly used product, such as gasoline or milk, and track the prices of this product over a 20-year period by creating a line graph. Explain price increases and decreases based...

(Appendices) Search magazines, newspapers, and the Internet for advertisements. Collect or print out ads that offer the following: (a) something for nothing, (b) bonus for early reply, (c) offers of...

(Appendices) Brandon, age 32, is married and has a son, age one. Six months ago, Brandon purchased an individual health insurance policy covering the entire family. His son was recently diagnosed...