Question

In: Finance

Purpose of Assignment The purpose of this assignment is to allow students the opportunity to research...

Purpose of Assignment

The purpose of this assignment is to allow students the opportunity to research a Fortune 500 company stock using the popular online research tool, Yahoo Finance. The tool allows the student to review analyst reports and other key financial information necessary to evaluate the stock value and make an educated decision on whether to invest.

Assignment Steps

Select a Fortune 500 company from one of the following industries:

Pharmaceutical
Energy
Retail
Automotive
Computer Hardware
Manufacturing
Mining

Review the financial information and statistics provided for the stock you selected and answer the following:

What is the ticker symbol of the company you chose?
What is the Current Stock Price?
What is the Market Cap for the stock you chose?
What is the Price to Earnings Ratio?
What is the Dividend and Yield?
What is the Enterprise Value?
What is the Beta?
Was there a Stock Split, and if so, when?
What was the closing stock price for the last 5 days?
What was the 52 Week High for this stock?
What is the Book Value per Share?
What type of rating are analysts recommending (i.e. buy, hold, etc.)?
What is the target price analysts are predicting for this stock?
What is the analyst's average revenue estimate for next year?
What are some of the significant news items and press releases made by the company over the last year?

Expert Solution

The Fortune 500 Company that I have selected is Walmart and the company belongs to the ‘retail’ industry.

Ticker for Walmart is WMT.

Current stock price is $107.28

Market cap = $3071.6 billion

P/E ratio (TTM) = 37.54

Dividend (forward) = 2.12 and trailing annual dividend = 2.09

Forward Yield = 1.95% and trailing yield = 1.93%

Enterprise Value = $383.16 billion

Beta = 0.67

Yes, there was a stock split and it was on 20^th April 1999.

Closing price for the last 5 days is shown below:

Date	Closing price ($)
9 Aug 2019	107.28
8 Aug 2019	108.52
7 Aug 2019	107.67
6 Aug 2019	106.74
5 Aug 2019	105.30

52 week high is $115.49

Book value per share = $23.83

As of August the stock of Walmart has largely hold and buy ratings. The stock has a total of 1 sell rating, 1 underperform rating, 15 hold ratings, 7 buy ratings and 8 strong buy ratings.

Target price that analysts are predicting is $111.93

Analyst's average revenue estimate for next year is around $520 billion.

Some of the significant news items and press releases made by Walmart over the last year are:

(i) Walmart will intensify its focus on online retail and will take Amazon heads on. For this purpose the company is looking to make several acquisitions in important markets. Recently the company purchased online giant Flipkart in India to establish its presence in the rapidly growing online retail market in the region.

(ii) In its press release dated 16th May 2019 the company said that it will focus more on innovation, speed and flexibility to grow the company and better serve its customers.

(iii) The company also announced the introduction of its online pet pharmacy - Walmartpetrx.com

jeff jeffy answered 7 months ago

Purpose of Assignment The purpose of this assignment is to allow the students to understand and...

Purpose of Assignment The purpose of this assignment is to allow the students to understand and practice the measurement of present value, future value, and interest rate using Microsoft® Excel®. Assignment Steps Resources: Microsoft® Office® 2013 Accessibility Tutorials, Microsoft® Excel®, Time Value of Money Calculations Template Calculate the following time value of money problems using Microsoft® Excel®: If we place $8,592.00 in a savings account paying 7.5 percent interest compounded annually, how much will our account accrue to in 9.5 years? What is the present value of...

Purpose of Assignment The purpose of this assignment is to allow the students to become familiar...

Purpose of Assignment The purpose of this assignment is to allow the students to become familiar with and practice the measurement of Net Present Value (NPV), payback, and Weighted Average Cost of Capital (WACC) using Microsoft® Excel®. Assignment Steps Resources: Microsoft® Excel®, Capital Budgeting Decision Models Template Calculate the following problems using Microsoft® Excel®: Calculate the NPV for each project and determine which project should be accepted. Project A Project B Project C Project D Inital Outlay (105,000.000) (99,000.00) (110,000.00)...

The purpose of this assignment is to allow the student an opportunity to explain what it...

The purpose of this assignment is to allow the student an opportunity to explain what it means to have an efficient capital market. Students will gain an understanding of the different levels of market efficiency and how behavioral finance can inhibit reaching market transparency. Explain in 525 words what it means to have efficient capital market, including: Describe the behavioral challenges in achieving efficiency. Discuss the three forms of market efficiency. What are the implications to corporate finance? Would you...

The purpose of this assignment is to provide students with an opportunity to develop a framework...

The purpose of this assignment is to provide students with an opportunity to develop a framework for the development of a database that would support a Post-operative Follow-Up Module in an Ambulatory Surgery Center. Please read the article contained in this link and answer the following questions: [Article about Structured Vs. Unstructured Data]. What are the critical issues that Post-Anesthesia Care Unit (PACU) staff must address when contemplating the development of a Post-operative Follow-Up Module? When considering the issue of...

The purpose of this assignment is to provide an opportunity for students to apply the nursing...

The purpose of this assignment is to provide an opportunity for students to apply the nursing process while planning education to meet the needs of patients. Instructions: Develop a teaching plan based on an assigned scenario or case. Determine what elements you would include in your assessment of the learner. Identify anticipated or expected learner needs. Select and prioritize evidence based teaching strategies that would best meet the needs of the learner. Describe the resources you would provide to enhance...

Purpose of the Assignment: The assignment is designed to provide learners the opportunity to demonstrate their...

Purpose of the Assignment: The assignment is designed to provide learners the opportunity to demonstrate their ability to develop effective and well-structured questionnaires that will enable them to gather the required data for their re- search. The goal of this assignment is to monitor student learning and provide ongoing feedback. Your task is: Please develop and upload a well-structured Survey / Questionnaire (12 - 15 questions) that will enable you to gathering valuable data for your research.

Purpose of Assignment The purpose of the assignment is to develop students' abilities in using data...

Purpose of Assignment The purpose of the assignment is to develop students' abilities in using data sets to apply the concepts of sampling distributions and confidence intervals to make management decisions. Assignment Steps Resources: Microsoft Excel®, The Payment Time Case Study, The Payment Time Case Data Set Review the Payment Time Case Study and Data Set. Develop a 700-word report including the following calculations and using the information to determine whether the new billing system has reduced the mean bill...

Purpose The purpose of this assignment is to give you an opportunity to demonstrate your ability...

Purpose The purpose of this assignment is to give you an opportunity to demonstrate your ability to identify emerging ethical issues in business, interpret the multitude of perspectives inherent in your case study, and model appropriate behaviour by recommending specific solutions. How to Proceed Select a case. It can be one of the textbook cases that we have not discussed during the course. It can also come from the outside world, perhaps a case you have been following in the...

PURPOSE: The purpose of this assignment is to enable the students to enhance their knowledge on...

PURPOSE: The purpose of this assignment is to enable the students to enhance their knowledge on the environmental engineering and sustainable development for environmental engineering. TASK 1 (DOCUMENTATION) Development in science and technology has increase the level of human lifestyle which leads to technology advancement. However, everything good comes with a price. One of the greatest problems that the world is facing today is that of environmental pollution, increasing with every passing year and causing grave and irreparable damage to...

The purpose of this assignment is to allow you to examine both an in-house software development...

The purpose of this assignment is to allow you to examine both an in-house software development and a commercially purchased software package. Scenario: CSU has a sporting goods shop that sells sports equipment, as well as hiking and camping supplies. The CSU shop owner, Peter, wants to develop a customer-order entry system and has hired your IT consulting firm to advise him about software alternatives. Peter is leaning toward in-house development because he does not want to depend on a...