User Account

All Pages

Consider discounted cash flow analysis on the stock

Assignment Help Financial Management
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.

Reference no: EM131067399

Questions Cloud

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 ..

Reviews

Write a Review

Financial Management Questions & Answers

  How low can the price of each share of DEF

Justin just made a margin purchase of 100 shares of DEF Corp. for $22.50 per share. The initial margin is 70%. The maintenance margin is 30%. How low can the price of each share of DEF be before Justin will have to add equity to his account?

  What was the holding period return for stock

A stock has had returns of 17.02 percent, 12.26 percent, 6.12 percent, 27.22 percent, and ?13.64 percent over the past five years, respectively. What was the holding period return for the stock?

  Delta will be unable to cover its interest expense

Delta, Inc., has a times interest earned ratio of 3.0. Based on this ratio, a creditor knows that Delta's EBIT must decline by more than ______ percent before Delta will be unable to cover its interest expense. Show Work.

  What is the capital gain or loss on your bond

You own a bond with the following features: 9 years to maturity, face value of $1000, coupon rate of 2% (annual coupons) and yield to maturity of 1.1%. Just after you purchase the bond, the yield to maturity rises to 5.4%. What is the capital gain or..

  Assume interest payments are semi-annual

Calculate the price of a 5.8 percent coupon bond with 10 years left to maturity and a market interest rate of 7.0 percent. (Assume interest payments are semi-annual.)

  Net income in dividends and share repurchases

Felt water Furniture has 120,000 shares of stock outstanding. The firm expects to earn net income of $325,000 next year with annual increases of 3 percent per year thereafter. The firm also expects to pay out 75 percent of its net income in dividends..

  Using the appropriate time value of money table

Using the appropriate Time Value of Money table (A)What is the amount a person would have to deposit today (present value) at 2 percent interest rate to have $4250 saved 10 years from now.

  Mutual fund that is expected to earn rate of return

Suppose you invest $1000 into a mutual fund that is expected to earn a rate of return of 11%. How much money will you have in 10 years? If $8000 is invested in a certain business at the start of the year, the investor will receive $2400 at the end of..

  What was the variance of the returns over this period

You’ve observed the following returns on Doyscher Corporation’s stock over the past five years: –28.2 percent, 15.8 percent, 34.6 percent, 3.4 percent, and 22.4 percent. What was the arithmetic average return on the stock over this five-year period? ..

  What is the amount of the firms EBT

Advantage First corporation has sales of $4,236,510; income tax of $408,406; the selling, general and administrative expenses of $295,502; depreciation o f$314,079; cost of goods sold of $2,770.190; and interest expense of $193,151.What is the amount..

  One share of stock and one bond

Norma has one share of stock and one bond. The total value of the two securities is 1,416.3 dollars. The stock pays annual dividends. The next dividend is expected to be 5.84 dollars and paid in one year. In two years, the dividend is expected to be ..

  What are the bonds nominal yield to maturity

Last year TA Co. issued a 10-year, 12% semiannual coupon bond at its par value of $1,000. Currently the bond can be called in 4 years at a price of $1,060 and it sells for $1,100. What are the bond’s nominal yield to maturity and its nominal yield to..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd