Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started