Question

Two Part Question The Price is Right! Utilizing 1 of these public companies—Target, Coke, Pepsi, Wal-Mart,...

Two Part Question

The Price is Right!

Utilizing 1 of these public companies—Target, Coke, Pepsi, Wal-Mart, or J. P. Morgan—determine the right price for that company’s stock in the following 5 easy steps:

Visit this Web site.


Type in your selected company’s name in the Quote Search box, and select your company's stock symbol. Jot down the current stock price. 


Select the Analysis tab, and find the Analyst Recommendation box. Jot down the stock’s Earnings Per Share (EPS) Estimate. 


Select the Price Ratios tab, and jot down the current Price to Earnings Ratio (P/E)  for the industry (not the company).


Using the PE valuation model to determine the right price for this stock, multiply the industry average P/E ratio by the stock’s EPS to estimate the intrinsic price of the stock. 


Answer the following questions:


Is this stock overvalued or undervalued when compared to the current stock price? 


What are the analysts’ recommendations for this stock (buy, sell, or hold)? 

Do you agree with them? Would you consider purchasing this stock? Why?


0 0
Add a comment Improve this question Transcribed image text
Answer #1

Selected Company Name: Target: Current Market Price= $73.00; EPS Estimate: $5.66; Current P/E ratio for Industry is: 30.67; By multiplying the industry average P/E i.e. 30.67 by EPS estimate for Target= $5.66 this will yield the Intrinsic price of the Stock as = $173.59.

Stock is undervalued when intrinsic value is compared with current stock price. Out of the 7 Analysts Recommendations 2 have recommended buying and 5 to hold.

I would agree with the Analysts who have recommended Buying this stock because its General and Overall Profitability both have improved in recent year by outperforming the Industry Averages.

Add a comment
Know the answer?
Add Answer to:
Two Part Question The Price is Right! Utilizing 1 of these public companies—Target, Coke, Pepsi, Wal-Mart,...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • The Price is Right! Utilizing 1 of these public companies—Target, Coke, Pepsi, Wal-Mart, or J. P...

    The Price is Right! Utilizing 1 of these public companies—Target, Coke, Pepsi, Wal-Mart, or J. P. Morgan—determine the right price for that company’s stock in the following 5 easy steps: Visit this Web site. Type in your selected company’s name in the Quote Search box, and select your company's stock symbol. Jot down the current stock price. Select the Analysis tab, and find the Analyst Recommendation box. Jot down the stock’s Earnings Per Share (EPS) Estimate. Select the Price Ratios...

  • Two Part Question: Walmart is the company Type in your selected company’s name in the Quote...

    Two Part Question: Walmart is the company Type in your selected company’s name in the Quote Search box, and select your company's stock symbol. Jot down the current stock price.  Select the Analysis tab, and find the Analyst Recommendation box. Jot down the stock’s Earnings Per Share (EPS) Estimate.  Select the Price Ratios tab, and jot down the current Price to Earnings Ratio (P/E)  for the industry (not the company). Using the PE valuation model to determine the right price...

  • Target (1/31/22) Wal-Mart (1/31/22) Income Statement Data for Year Net sales $67,000 $410,000 Cost of goods...

    Target (1/31/22) Wal-Mart (1/31/22) Income Statement Data for Year Net sales $67,000 $410,000 Cost of goods sold 44,890 287,000 Selling and administrative expenses 16,080 77,900 Interest expense 670 3,280 Other income 20 4,000 Income taxes 1,883 16,037 Net income $ 3,497 $ 29,783 Target Wal-Mart Balance Sheet Data (End of Year) Current assets $21,160 $ 45,360 Noncurrent assets 27,000 111,000 Total assets $48,160 $156,360 Current liabilities $11,500 $ 56,000 Long-term liabilities 22,212 37,816 Total stockholders’ equity 14,448 62,544 Total liabilities...

  • Based on yahoo financial website for 3M, Part A-Fundamental Valuation: a. Estimate a growth rate for...

    Based on yahoo financial website for 3M, Part A-Fundamental Valuation: a. Estimate a growth rate for your firm's Dividends per Share. b. Assume a 12.5% discount rate. c. Calculate an estimated value of a share of the stock using the constant-growth model Ea. 8 - in the textbook), also known as the Gordon growth model. d. Compare and contrast your valuation results with the current share price in the market. e. Respond to this question: What changes in the variables...

  • Wal-Mart Stores Inc. (WMT) Income Statement View: Annual Data All numbers in thousands Jan 31, 2012...

    Wal-Mart Stores Inc. (WMT) Income Statement View: Annual Data All numbers in thousands Jan 31, 2012 Jan 31, 2011 Jan 31, 2013 Period Ending Total Revenue Cost of Revenue 469.162.000 352488,000 446.950.000 335,127.000 4 21.849.000 314,946,000 116,674,000 111,823,000 106,903,000 Gross Profit Operating Expenses Research Development Selling General and Administrative No. Recucina Others 88,873,000 85,265,000 81.361.000 Total Operating Expenses Operating Income or Loss 27,801,000 26,558,000 25,542,000 Income from Continuing Operations 187,000 Total Other Income/Expenses Net Earings Before Interest And Taxes Interest...

  • Wal-Mart Stores Inc. (WMT) Income Statement View. Annual Data All numbers in thousands Period Ending Jan 31, 2...

    Wal-Mart Stores Inc. (WMT) Income Statement View. Annual Data All numbers in thousands Period Ending Jan 31, 2013 Jan 31, 2012 Jan 31, 2011 Total Revenue 469,162,000 446,950,000 335,127.000 Cost of Revenge 352.488,000 421,849,000 314.948.000 106.903.000 116,674,000 111,823,000 Gross Profit Operating Expenses Research Develoment Seling General and Administrative No. Recurrina Others 88,873,000 85,265,000 81,361,000 Total Operating Expenses Operating income or Loss 27.801.000 26.558.000 25.542.000 Income from Continuing Operations Total Other Income/Expenses Net Earnings Before Interest And Taxes Interest Expense Income...

  • Wal-Mart Stores Inc. (WMT) Income Statement View: Annual Data All numbers in thousands Jan 31, 2012 Jan 31, 20...

    Wal-Mart Stores Inc. (WMT) Income Statement View: Annual Data All numbers in thousands Jan 31, 2012 Jan 31, 2011 Period Ending Jan 31, 2013 Total Revenue 469,162.000 121.849,000 314,946,000 Cost of Revenue 446.950,000 335,127,000 111,823,000 352,488,000 Gross Profit 116,674,000 106,903,000 Operating Expenses Research Development Selling General and Administrative 88,873,000 85,265,000 000 Non Recudine Others Total Operating Expenses Operating Income or Loss 27,801.000 26,558,000 25.542.000 Income from Continuing Operations Total Other Income/Expenses Net Eamings Before Interest And Taxes Interest Expense 187,000...

  • Instructions Part 1: Work in two or three person teams or you can work alone. Prepare...

    Instructions Part 1: Work in two or three person teams or you can work alone. Prepare an income statement and classified balance sheet for the period ended Dec 31, 20xx. The balance of inventory on Dec 31 is $30. The company’s stock trades on the NASDAQ exchange for $75 per share. Dilbert is an L.L.C. and does not pay federal income taxes. Dilbert Pharmaceuticals, Inc. Trial Balance    December 31, 20xx    (in Millions) Cash $8 Inventory (Jan. 1, 20xx...

  • 1) An analyst gathered the following financial information about a firm: Estimated (next year’s) EPS                         &nbsp

    1) An analyst gathered the following financial information about a firm: Estimated (next year’s) EPS                                       $10 per share Dividend payout ratio                                                             40% Required rate of return                                                           12% Expected long-term growth rate of dividends                       5% What is the analysts’ estimate of intrinsic value? Show work. 2) An analyst has made the following estimates for a stock: dividends over the next year $.60 long-term growth rate                         13% Intrinsic value                                     $24 per share The current price of the shares is $22. Assuming the...

  • Whenever a stock price changes, one of two things is probably happening investors are updating their...

    Whenever a stock price changes, one of two things is probably happening investors are updating their expectations about Tesla's future cash flows, or investors are updating their beliefs about the appropriate "discount rate to apply to those estimated future cash flows. What discount rate are Tesla's investors using for their cash flows? In this question, we are going to calculate one possible estimate for this discount rate, which is known as the weighted Average Cost of Capital for WACC) The...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT