Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Pick APPLE stocks that you have selected for the Investment Portfolio Project. 1. Go to Yahoo FinanceLinks to an external site. and look up that

Pick APPLE stocks that you have selected for the Investment Portfolio Project.

1. Go to Yahoo FinanceLinks to an external site. and look up that stock (under "Statistics") and report the current valuation metrics below (any time in October is fine as long as the numbers are consistent for all metrics):

a. Trailing Price/Earnings (P/E)

b. Forward Price/Earnings (P/E)

c. Price/Sales (P/S) (Trailing 12 months)

d. Price/Book (P/B)

e. Enterprise Value/EBITDA

2. Look up the stock of a company in the same industry (a competitor would be ideal) on Yahoo FinanceLinks to an external site. and report the same valuation metrics for this competing company. Create an Excel spreadsheet with these metrics side-by-side (example below): Stock A Stock B Is A (overvalued, undervalued, fairly valued) than B? Trailing P/E 29 16 Overvalued Forward P/E 25 14 Overvalued Price/Sales 7 9 Undervalued Price/Book 38 30 Overvalued EV/EBITDA 21 15 Overvalued

3. Based on consensus of these metrics, do you believe your stock is: a. Overvalued? b. Undervalued? c. Fairly Valued?

4. Write a brief summary of what your analysis uncovers.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Finance questions

Question

Question What is a Roth 403 (b) plan?

Answered: 1 week ago