Reference no: EM131067399
Provide a relative valuation analysis for ONE of the following stocks: Google (Ticker: GOOG) Morgan Stanley (Ticker: MS) Johnson & Johnson (Ticker: JNJ) We will refer to the chosen stock as “the stock” in the questions below.
a) Use the RV (relative valuation) function in Bloomberg equity analysis to compile a peer group of 6 to 12 stocks in the same industry.
b) Compile a relative valuation table that includes the following statistics for the stock and its peers: • Five price multiples: P/E, P/B, P/S, P/CF, EV/EBIDTA • Four Fundamental factors: Five-year EPS growth, Return on Equity (ROE), Beta, Net Profit Margin (PM) • Other Information: Closing Price, Market Cap, Sales Revenue, EPS, Debt to Equity Ratio, Dividend Payout Ratio
c) Compare the P/E, P/B and P/S of the stock against the average P/E, P/B and P/S of the peer group. Discuss whether this is justified by the fundamental factors.
d) State your recommendation (Buy, Sell, Hold) on the stock based on the relative valuation analysis above.
e) Identify two major limitations of the above analysis. Suggest what and how additional information could help you make a better decision on this relative valuation case. Consider Discounted Cash Flow (DCF) analysis on the stock.
f) Which DCF model (DDM, FCFE or FCFF) would you use to value the stock? Justify your DCF model choice using historical data on the dividend payout ratio and debt to equity ratio of the stock over the last five-year period.
g) Assuming the DCF model choice from f), determine the discount rate that you will use to discount the future cash flows. Using resources from Bloomberg, explain in details how you have arrived at this discount rate estimate.
|
What is the average amount of receivables
: Snider sells on tmrs of 2/10, net 45. Total sales for the year are $1,500,000. 30% pay on the 10th day, 70% - on the 50th. What is the day’s sale outstanding? What is the average amount of receivables? What would have to average receivables if Snider..
|
|
Find one example of a genetically modified bacterium
: Find one example of a genetically modified bacterium used to benefit humans. Provide the genus and species (full scientific name), and discuss the primary uses.
|
|
Calculate the firms cash conversion cycle
: Canadian Products is concerned about managing its operating assets and liabilities efficiently. Inventories have an average age of 140 days, and accounts receivable have an average age of 70 days. Calculate the firm's operating cycle. Calculate the f..
|
|
How do you think that nonfiction writers shape their stories
: Based on the readings from this unit and the previous unit, how do you think nonfiction is like/different from fiction? How do you think that nonfiction writers shape their stories?
|
|
Consider discounted cash flow analysis on the stock
: Provide a relative valuation analysis for ONE of the following stocks: Google (Ticker: GOOG) Morgan Stanley (Ticker: MS) Johnson & Johnson (Ticker: JNJ) We will refer to the chosen stock as “the stock” Identify two major limitations of the above anal..
|
|
Accumulated depreciation for this machine
: On January 1, 2001, Bass Co. purchased a machine for $660,000 and depreciated it by the straight-line method using an estimated useful life of eight years with no salvage value.
|
|
Explain developmental delay and the rationale for services
: Explain developmental delay and the rationale for services to young children who are developmentally delayed or at risk for developmental delay.
|
|
Required rate of return on the stock
: Deluxe company expects to pay a dividend of $2 per share at the end of year 1, $3 per share at the end of year 2, and then be sold for $32 per share at the end of year 2. If the required rate of return on the stock is 15%, what is the current value o..
|
|
Calculate the financial ratios for the assigned
: Review Nash-Finch Company and The Kansai Electric Power Co, Incorporated financial statements from the past three years. Calculate the financial ratios for the assigned company's financial statements, and then interpret those results against company ..
|