Reference no: EM131277009
Assignment
1. Select a public company other than Pfizer.
2. Go to https://finance.yahoo.com
Click on Market Data on the left of the screen.
Type name of company in Search Box on top of the screen and click on Search Financebutton.
3. Write down the information on the stock such as last closing price, beta of stock, EPS and Dividend in dollars and cents.
4. On the left side of screen, click on Key Statistics under Company. Note ROE as you scroll down.
5. You have the basic information to calculate the intrinsic value of the stock using the constant growth assumption in the Dividend Discount Model (refer to text readings).
6. a) Calculate the required rate of return (r) for the stock using the Capital Asset Pricing Model (CAPM).
r = (10-year Treasury Bond Yield) + [Beta (S&P 500 Index Return - 10-year Treasury Bond Yield)]
Search for 10-year Treasury Bond Yield using the Search box at finance.yahoo.com.
S&P 500 Index Return for 2014 can be obtained at google.com. Since the return for 2015 was negative, we can use the 2014 value of 11.39%.
Plug in the data and calculate the required rate of return using the value for beta.
b) The constant growth rate of dividends, g = retention ratio x ROE
= (1 - payout ratio) x ROE
= [1 - (dividend per share/EPS)] x ROE.
g will be a percentage. Convert to a decimal by dividing by 100.
c) Intrinsic value of stock = Po = [Do (1 + g)]/(r - g)
Do is the dividend just paid while D1 = Do (1 + g) is the dividend to be paid.
Knowing Do or D1, r and g, you can calculate the intrinsic value.
7. Compare the intrinsic value above to the stock's current market price. Explain any differences using information gleaned by studying assigned text chapters.
Application Assignment
As a manager, it is important to understand how decisions can be analyzed in terms of alternative courses of action and their likely impact on a firm's value. Thus, it is necessary to know how stock prices can be estimated before attempting to measure how a particular decision might affect a firm's market value.
To prepare for this Assignment, choose a publicly-traded company, and then estimate your company's common stock price, using one of the valuation models presented in the assigned readings or outside readings. (If you want to analyze a dividend paying company, you can find a robust list at http:/www.dividenddetective.com/big_dividend_list.htm.)
Defend your choice of model, and explain why it is appropriate to use for your company's stock. Be sure to explain how you arrived at any assumptions regarding values used in the model. Determine whether your company appears to be correctly valued, overvalued, or undervalued based on your company's stock current price and model result. Check Yahoo Finance for current stock prices. Finally, explain why your company's stock appears to be over-, under-, or correctly valued.
Attachment:- Spreadsheet.xlsx
|
Why are global communication tools valuable to businesses
: Describe how Web 2.0 and Web 3.0 are different. How do LANs and WANs differ? How are they the same? Why are global communication tools valuable to businesses?
|
|
Find variance for a security that has three one-year returns
: Find the variance for a security that has three one-year returns of -5%, 15%, and 20%. Find the variance for a security that has three one-year returns of 5%, 10%, and 15%.
|
|
Reasonable parameters for the picnic
: Write a scope statement to include the reasonable parameters for the picnic (location requirements, numbers of people, entertainment, menu, etc.). This should include the purpose and desired outcomes for the event. It should include the estim..
|
|
List the information the companys executives would have
: Select a company in a field in which you have a career interest and look up information on this firm in your library or on the Internet. - List the information the company's executives would have needed to make these decisions.
|
|
Determine whether your company appear to be correctly valued
: Determine whether your company appears to be correctly valued, overvalued, or undervalued based on your company's stock current price and model result.
|
|
Determine specific weight density and specific gravity
: A liquid when poured into a graduated cylinder is found to weigh 8 N when occupying a volume of 500 ml (milliliters). Determine its specific weight, density, and specific gravity
|
|
What could they do to create this consumer environment
: What is a brand community, and what value can it bring to a brand? Would you say that Freitag has created a strong brand community? If so, how... or if not, what could they do to create this consumer environment?
|
|
Explain why you chose that particular company
: Explain why you chose that particular company. Describe the specific characteristics of the company; for example: which markets they operate in and where their investments have been focused to date.
|
|
What do you think should count as ethical workplace behavior
: Apply one or more of the five business ethics myths described in your text to your own ethical perspective. The author of the text believes many people are victims of these myths. How might one or more of these myths affect you—or how might they not ..
|