Company Data

FIN 488 Make-up Exam due on Friday at  4pm.

Don't use plagiarized sources. Get Your Custom Essay on
Company Data
Get a plagiarism free paper Just from \$13/Page

Is the Price Right?

1. For company data, visit YAHOO! Finance (or any other financial database such as Mergent Online).

1. Choose a company that pays dividends and retrieve the monthly stock prices from 1/15/2010 to 1/15/2020.

1. Compute the Required Rate of Return (rs) using the CAPM

Step 1: Find the risk-free rate

• From any database, research articles, text books, or internet e.g.

https://ycharts.com/indicators/10_year_treasury_rate

Step 2: Compute beta

• Using regression analysis
• Use SP500 or Dow Jones as the market portfolio

Step 3: Research past articles to get the market return or market risk premium  (rm – rf )

• Use the text, research articles, or internet e.g.

d).  Using the required return from CAPM above, compute the intrinsic stock price using the Gordon Growth Model:

P0  = D1 / (rs –g)

= D0 (1 +g)/(rs –g)

Steps to compute growth

Get dividends from yahoo Finance

Add up dividends for each year

Calculate the annual percentage change in dividends using the formula:

= (Ending Dividend – Beginning Dividend) / Beginning Dividend

Example:

= (2011 Dividend – 2010 Dividend) / 2010 Dividend

The average of the percentage changes in dividends is the growth rate

Steps to compute D1

The total dividends for 2019 is D0

D1  = D0 (1 + g)

Steps to compute the intrinsic value

Put the variables in the formula to find P0

P0  = D1 / (rs –g)

e).  Determine whether the stock is over-valued or under-valued?

Compare the computed stock price (intrinsic value) to the current market price on

Yahoo! Finance

If the intrinsic value > listed stock price, the stock is undervalued

If the intrinsic value < listed stock price, the stock is overvalued

f).  Make your recommendations to investors whether to buy, sell or hold the stock.

Deliverables:

1. Excel file with all the data and calculation
2. WORD document with your recommendations and an explanation of both models

Order Now And Get A 20% Discount!
Pages (550 words)
Approximate price: -

Advantages of using our writing services

Custom Writing From Scratch

All our custom papers are written by qualified writers according to your instructions, thus evading any case of plagiarism. Our team consists of native writers from the USA, Canada, and the Uk, making it convenient for us to find the best to handle your order.

Unlimited Free Revisions

If you feel your paper didn't meet all your requirements, we won't stop till it's perfect. You're entitled to request a free revision within 7 days after we submit your paper.

Quality Writing In Any Format

If you have issues with citing sources and referencing, you need not worry. Our writers are highly knowledgeable in referencing, including APA/MLA/Havard/Chicago/Turabian and all other formatting styles.

All our custom papers are delivered on time, even the most urgent. If we need more time to perfect your paper, we may contact you via email or phone regarding the deadline extension.

Originality & Security

At Master Homework, your security and privacy is our greatest concern. For this reason, we never share your personal information with third parties. We use several writing tools to ensure your paper is original and free from plagiarism.

Our agents are online 24 hours a day, 7 days a week, and are always ready to serve you. Feel free to contact us through email or talk to our live agents whenever you need assistance with your order.

Try it now!

Calculate the price of your order

We'll send you the first draft for approval by at
Total price:
\$0.00

How it works?

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Our Services

We work nonstop to see the best client experience.

Flexible Pricing

We offer pocket-friendly prices that coincide with the preferred client's deadline.