Data is to be collected from yaho finaance

The four companies

Apple (AAPL)

Microsoft(MSFT)

Texas Instruments (TXN)

Oracle (ORCL)

1. Select ONE of the four companies provided by your professor for analysis.
2. Write a 1-2 page (approximately 500 words) paper on the following:
   1. Part A Fundamental Valuation:
      1. Estimate a growth rate for your firms Dividends per Share.
      2. Assume a 12.5% discount rate.
      3. Calculate an estimated value of a share of the stock using the constant-growth model (Eq. 8-6 in the textbook), also know as the Gordon growth model.
      4. Compare and contrast your valuation with the current share price in the market. Provide the date of the current share price.
      5. Respond to this question: What changes in the variables would be necessary in your valuation to best approximate the current market valuation?
   2. Part B Relative Valuation:
      1. Estimate a growth rate for your firms Earnings per Share (EPS).
      2. Determine an applicable Price-Earnings (P/E) ratio for your firm in 5 years.
      3. Calculate an estimated value of a share of the stock in 5 years using the P/E ratio model