Ask Corporate Finance Expert

Assignment

1. Select a public company other than Pfizer.

2. Go to http://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

Corporate Finance, Finance

  • Category:- Corporate Finance
  • Reference No.:- M92031722
  • Price:- $40

Priced at Now at $40, Verified Solution

Have any Question?


Related Questions in Corporate Finance

Business finance case study assignment -instructions - you

BUSINESS FINANCE CASE STUDY ASSIGNMENT - Instructions - You must do Questions 1-5a, 8 and 10 on a spreadsheet. Eternal Youth Ltd (EY) is a New Zealand company which produces and sells cosmetics. Its financial year is 1 J ...

Q1 delta hedgingon sept 30th 2011 exxon mobil xom stock was

Q1 (Delta Hedging) On Sept 30th, 2011, Exxon Mobil (XOM) stock was traded at $72.63 while the December XOM put option with $75 exercise price is traded at $5.00 and the December XOM call option with $70 exercise price is ...

Q1 delta hedgingon sept 30th 2011 exxon mobil xom stock was

Q1 (Delta Hedging) On Sept 30th, 2011, Exxon Mobil (XOM) stock was traded at $72.63 while the December XOM put option with $75 exercise price is traded at $5.00 and the December XOM call option with $70 exercise price is ...

Assignment -part a - saturn petcare australia and new

Assignment - Part A - Saturn Petcare Australia and New Zealand is Australia's largest manufacturer of pet care products. Saturn have been part of the Australian and New Zealand pet care landscape since opening their firs ...

Mini case assignment -problems - use internet to identify a

Mini Case Assignment - Problems - Use internet to identify a house or condo that you may be interested in investing as a rental property for 10+ years. (Suggested price range between $250k - $1 million) 1. Estimate the a ...

Descriptionstudents are required to study undertake

Description: Students are required to study, undertake research, analyse and conduct academic work within the areas of corporate finance. The assignment should examine the main issues, including underlying theories, impl ...

Corporate finance assignment - required this assessment

Corporate Finance Assignment - Required: This assessment task is a written report and analysis of the financial performance of a selected company in order to provide financial advice to a wealthy investor. It will be bas ...

Interest swap valueabc bank has agreed to receive 3-month

Interest swap value ABC bank has agreed to receive 3-month LIBOR and pay 8% per annum on a notional principal of $100 million. The swap has a remaining life of 11 months. The LIBOR spot rates for 2-month, 5-month, 8-mont ...

Graph an event study relationshipthe event in consideration

Graph an event study relationship. The event in consideration here is: "Environmental performance, being green, clean-tech, corporate sustainability, and many other "green" issues are on the forefront of the current econ ...

Question - assume that the average firm in your companys

Question - Assume that the average firm in your company's industry is expected to grow at aconstant rate of 6 percent and its dividend yield is 7 percent. Your company is about as risky as the average firm in the industr ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As