Answered step by step
Verified Expert Solution
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.
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
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