Google Answers Logo
View Question
 
Q: Calculating Stock Prices Using Real-Time Data ( Answered,   0 Comments )
Question  
Subject: Calculating Stock Prices Using Real-Time Data
Category: Business and Money > Finance
Asked by: go772cute-ga
List Price: $25.00
Posted: 15 Apr 2005 14:54 PDT
Expires: 15 May 2005 14:54 PDT
Question ID: 509847
By walking you through a set of real-time financial data for IBM, this
assignment will help you better understand how theoretical stock
prices are calculated; and how prices may react to market forces such
as risk and interest rates. You will use both the CAPM and the
Constant Growth Model (CGM) to arrive at IBM's stock price. To get
started, complete the following steps.

First, find an estimate of the risk-free rate of interest, krf. To
calcuate this rate, first go to Bloomberg.com: Market Data
[http://www.bloomberg.com/markets/index.html], to find the 10-year
Treasury bond rate. Use this interest rate 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.0%.


Download this IBM Stock Information document (.doc file). This
document was generated from recent financial data for IBM. Using this
document, find an estimate of:
a) IBM's beta (?)
b) IBM's current annual dividend
c) IBM's 3-year dividend growth rate (g)
d) Industry P/E
e) IBM's EPS. 
Also find IBM's current annual dividend and its 3-year growth rate, or g. 
With the information you now have, use the CAPM to calculate IBM's
required rate of return or ks.


Use the CGM to find the current stock price for IBM. We will call this
the theoretical price or Po.


Now use appropriate Web resources to find IBM's current stock quote,
or P. Compare Po and P. Do you see any differences? Can you explain
what factors may be at work for such a difference in the two prices?
This section is especially important?with more weight in grading?so
you may want to do some study before answering such a question.
Explain your thoughts clearly.


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


Recalculate IBM's stock using the P/E ratio model (pp. 350-1) and the
needed info found on the Web. Explain why the present stock price is
different from the price arrived at using CGM.

Please show all work, including formulae and calculations used to
arrive at financial values. Submit your work to your instructor via
the drop box.
Answer  
Subject: Re: Calculating Stock Prices Using Real-Time Data
Answered By: wonko-ga on 15 Apr 2005 15:31 PDT
 
I do not have access to the document to which you referred, so I have
sought data from other sources.

I obtained Kf from the Bloomberg website you provided.  Today
(April 15, 2005) the 10 year Treasury yield is 4.24%.

From Yahoo Finance ("International Business Machines Corp"
http://finance.yahoo.com/q/ks?s=IBM), I obtained the current annual
dividend of IBM of $0.72/sh. and its Beta of 1.638.  Beta is typically
calculated by taking the slope of the line that best fits a plot of
the returns of IBM stock versus the market's returns for a set of
periods.  A discussion of this is found, along with examples, on pages
183-185 of Brealey & Myers.  Presumably appropriate data detailing the
performance of IBM stock versus the market is found in the document
referenced in your question.

From the IBM website ("Stock Information"
http://www.ibm.com/investor/stock/index.phtml), I obtained details
regarding its annual dividend for the last three years.

Using the Compound Annual Growth Rate formula from Investorwords.com
("CAGR" http://www.investorwords.com/666/CAGR.html), I calculated the
CAGR of IBM's dividend:  (0.72/0.60)^(1/3) - 1 = 6.27%.

Using the CAPM model:  Ks = Beta(Km - Kf) + Kf, I obtained Ks =
1.638(7 - 4.24) + 4.24 = 8.76 (page 162 of Brealey & Myers)

The Constant Growth Model:  Po = DIV1/r-g = $0.72/(8.76% - 6.27%) =
$28.91  (page 62 of Brealey & Myers).  From the Yahoo Finance source
above, IBM's current stock price is $76.70.  Possible reasons for the
difference:  The market risk premium is currently lower than the
estimate we used.  Another possibility is that investors expect IBM's
growth rate to increase in the future, making the estimate of its
future growth rate from its previous history inaccurate.

With the new Km of 10%, Ks = 1.638(10-4.24)+4.24 = 13.67.  Po =
$0.72/(13.67%-6.27%) = $9.73.

A riskier stock (increase stock market risk makes each individual
stock riskier) with the same growth prospects results in the share
price being reduced.

The P/E ratio model is Po = P/E ratio * EPS.  From the Yahoo Finance
source above, IBM has a current P/E ratio of 15.74 and an EPS of
$4.873.  Therefore, the share price is $76.70. Source:   "P/E Ratio -
Price to Earnings" http://www.valuebasedmanagement.net/methods_PEratio.html.

If IBM has had a significantly different PE ratio in the past that is
more representative of its expected future prospects, then of course
use of this PE ratio would result in a different Po.  You will want to
consult the document that you have been provided to ensure that you
are not to use a different PE ratio for this calculation, such as the industry one.

It is important to note that "[t]here is no reliable association
between a stock's price-earnings ratio and the capitalization rate
[Ks].  The ratio of EPS to Po measures [Ks] only if [the present value
of growth opportunities] = 0 and only of reported EPS is the average
future earnings the firm could generate under a no-growth policy." 
(Page 61 of Brealey & Myers).

Sincerely,

Wonko

Source: "Principles of Corporate Finance" Fourth Edition by Brealey &
Myers, McGraw-Hill Inc. (1991)
Comments  
There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy