Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The stock/firm in question is COMCAST(CMCSA) I am only asking for the answer to #4. But I showed the rest of the other questions, in

The stock/firm in question is COMCAST(CMCSA) I am only asking for the answer to #4. But I showed the rest of the other questions, in the off chance that someone felt like doing those as well.
image text in transcribed
image text in transcribed
image text in transcribed
Target Company: Walt Disney Competitor: see list Use data from Yahoo!Finance, Google Finance, Bloomberg, the company's annual report, and other public data to complete the following (4) Forecast the Stock price (40 pts). Forecast the stock price for your assigned firm as of November of the tenth year. Compare your forecast price with the actual price to determine whether the stock is underpriced or overpriced. Discuss the rationale for the differences between the forecasted stock value and actual stock value. Use the following models: (No more than 2 pages) a. Dividend Model b. Company Multiples Target Company: Walt Disney Competitor: see list Use data from Yahoo!Finance, Google Finance, Bloomberg, the company's annual report, and other public data to complete the following Assignment: Using the Bloomberg Equity Valuation example, complete the following tasks for the target company and its competitors. SUMMARY REPORT MUST INCLUDE (narrative with supporting charts and graphs; no more than 10 pages): (1) Executive Summary 6 pts). (Total of 1 page) (2) Overview of Companies (20 pts). Summarize the following (No more than 3 pages): a) Each company's market share or market position in the industry/sector. b) Each company's stock performance c) Analyst's Opinion on Buy or Sell d) Your recommendation and rationale about your assigned company's future outlook (3) Stock Price Trend (20 pts). One page per company a. Create a graph of the monthly stock prices for your assigned company compared to the S&P 500 over a ten year period starting on January 1 until September 30 of the tenth year. b. Compare and contrast the stock trends. c. Discuss any spikes in stock price volatility, (4) Forecast the Stock price (40 pts). Forecast the stock price for your assigned firm as of November of the tenth year. Compare your forecast price with the actual price to determine whether the stock is underpriced or overpriced. Discuss the rationale for the differences between the forecasted stock value and actual stock value. Use the following models: (No more than 2 pages) a. Dividend Model b. Company Multiples (5) WACC for each company (10 pts). Using the company's annual report, compute the WACC. Target Company: Walt Disney Competitor: see list Use data from Yahoo!Finance, Google Finance, Bloomberg, the company's annual report, and other public data to complete the following (4) Forecast the Stock price (40 pts). Forecast the stock price for your assigned firm as of November of the tenth year. Compare your forecast price with the actual price to determine whether the stock is underpriced or overpriced. Discuss the rationale for the differences between the forecasted stock value and actual stock value. Use the following models: (No more than 2 pages) a. Dividend Model b. Company Multiples Target Company: Walt Disney Competitor: see list Use data from Yahoo!Finance, Google Finance, Bloomberg, the company's annual report, and other public data to complete the following Assignment: Using the Bloomberg Equity Valuation example, complete the following tasks for the target company and its competitors. SUMMARY REPORT MUST INCLUDE (narrative with supporting charts and graphs; no more than 10 pages): (1) Executive Summary 6 pts). (Total of 1 page) (2) Overview of Companies (20 pts). Summarize the following (No more than 3 pages): a) Each company's market share or market position in the industry/sector. b) Each company's stock performance c) Analyst's Opinion on Buy or Sell d) Your recommendation and rationale about your assigned company's future outlook (3) Stock Price Trend (20 pts). One page per company a. Create a graph of the monthly stock prices for your assigned company compared to the S&P 500 over a ten year period starting on January 1 until September 30 of the tenth year. b. Compare and contrast the stock trends. c. Discuss any spikes in stock price volatility, (4) Forecast the Stock price (40 pts). Forecast the stock price for your assigned firm as of November of the tenth year. Compare your forecast price with the actual price to determine whether the stock is underpriced or overpriced. Discuss the rationale for the differences between the forecasted stock value and actual stock value. Use the following models: (No more than 2 pages) a. Dividend Model b. Company Multiples (5) WACC for each company (10 pts). Using the company's annual report, compute the WACC

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

Finance The Basics

Authors: Erik Banks

1st Edition

0415384575, 9780415384575

More Books

Students also viewed these Accounting questions

Question

How is the atomic number of an atom determined?

Answered: 1 week ago