Evaluate the data about stock performance of target corp

Assignment Help Business Management
Reference no: EM131401431

Assignment

OBJECTIVE

The specific objective of this graded written research exercise is to prepare an "executive level financial report" to the Chief Financial Officer (CFO) of a mythical company in which you are employed as a financial analyst. This report will pertain to the financial evaluation of a real, publicly-traded, company. It will require independent research (web-based or library), careful financial analysis, and the proper application of key financial theories and formulas.

The company that is to be analyzed for this project is Target Corporation.

SITUATION

You are a financial analyst with the mythical High Technology Corporation ("HTC"). HTC is an established manufacturer of a line of electronic components, which services an international market. HTC is currently a new fully-integrated wireless communication service for world-wide use. A competitive technical and economic product evaluation has determined that Target Corporation is the best potential candidate for a long-term commitment.

Target Corporation is offering a competitively favorable deal. However, based on some serious general concerns about the fallout of companies in the industry in general, the CEO has asked your CFO to conduct a financial analysis of Target Corp. to determine if it is prudent to commit to this company's communication system. The cost of cutting over to the new communications system is significant and any interruption in support during the next few years would adversely affect HTC's performance and profit.

Specifically, the primary question is will Target Corp. be financially viable over the next two to three years?

YOUR SPECIFIC ASSIGNMENT

Your specific assignment is to research, analyze, and prepare a report for the CFO on the actual financial performance of Target Corp. In addition to reviewing the traditional financial performance indicators, you are also to review Target Corp's past and current stock performance. Your report includes three parts:

(1) An evaluation of Target's financial performance for the last three years. (See detailed description below)

(2) An evaluation of Target's stock performance for the last one year. (See detailed description below)

(3) Finally, a specific recommendation, with supporting rationale, as to whether or not Target's recent trend in financial and stock performance is of sufficient financial strength to warrant entering into a long-term commitment.

To assist you in your task, the CFO has provided the following general guidance. Since it is recognized that the industry is undergoing a major contraction, it is very important to comparatively evaluate Target Corporation's financial and stock performance trends against its Industry or major competitor.

SUGGESTED WEBSITES

• www.marketwatch.com -To find the information for your company you need to type the stock symbol in the Search window to get into the company's page.

• www.morningstar.com - To find the information for your company you need to type the stock symbol in the Quotes window to get into the company's page.

• www.money.cnn.com -To find the information for your company you need to type the stock symbol in the Search window to get into the company's page.

• www.finance.yahoo.com - To find the information for your company you need to type the stock symbol in the Search window to get into the company's page.

• www.nyse.com - Click on Data, then click on Stocks (under Quotes), and type the name of the company or the stock symbol in the window "Keyword or symbol" to get into the company's page.

• www.nasdaq.com - To find the information for your company you need to type the stock symbol in the Search window to get into the company's page.

• https://investors.target.com/phoenix.zhtml?c=65828&p=irol-stockquotechart

YOUR SPECIFIC ASSIGNMENT

Using the information from the websites the students have to develop evaluation of the financial and stock performance for Target Coporation.

OUTLINE

1. Background and Industry (one short paragraph).

2. Analysis of the most significant financial performance results.

Select of most significant financial performance results for the company. Create a table that contains the Target's financial performance results for the last three years and for the major competitor or industry for the last year: Revenue, net income, working capital, and other financial performance results of your choice. Present the table with this information in your report.

Write about 1 page of the trend analysis of these financial performance results.

3. Financial ratio analysis.

Find financial ratios for the company for the last 1-3 years and its major competitor for the last year in the Internet.

Present the ratios as the table(s) in your project.

Write about 2 pages of analysis of the ratio results that you found. Compare the ratio results against the industry or main competitor. In your analysis you should answer the following questions:

How liquid is the company?
How is the company financing its assets?
Is management generating a substantial profit on the company's assets?

4. Evaluate Return on Equity for the company for the last three years using the DuPont analysis.

Taking the information from the Income statements and the Balance sheets, calculate Target's net profit margin, total assets turnover equity multiplier, and return on equity using the DuPont formula for the company for three years. Show your calculation!

ROE = Net profit margin x Total assets turnover x Equity multiplier

= Net income/Sales x Sales/Total assets x Total assets/Common equity

You can use Revenue instead of Sales.

b. Compare the results to Wal-Mart Stores Inc. You can use ratios from the Internet or calculate them for the last year.

Write about 1 page of analysis of the results that you received. In your report please answer the question:

If the management of the company would like to improve their return on equity, what should the management of these companies do?

5. Evaluate other areas of financial analysis: capital spending, Beta values, credit rating service valuations (if possible), bond rating valuations (if possible), etc.

a) Find the data for capital spending. How much did Target Corp. spend on research, development, and engineering in the most recent year? How did this compare with the previous year?

b) Find the current beta for the company and its major competitor in the Internet.

Present beta results as the table in your project.

Write about 0.5 page of analysis of beta values that you found. Compare the beta values against the main competitor. In your report please answer the question: How risky the company is?

6. Collect and evaluate the data about stock performance of Target Corp. for the last one year.

a) Find the market ratios for Target for the last 1-3 years and its major competitor for the last year in the Internet.

Present the market ratios as the table(s) in your project.

Write about 1 page of analysis of the market ratio results that you found. Compare the market ratio results against the industry or main competitor. In your report please answer the question: Are the common stockholders receiving an adequate return on their investment?

b) Analysis of the historical stock prices trend for the last year.

Collect and evaluate the data about stock prices of Target for the last one year for the company and its major competitor.

Create the chart(s) using the stock price chart tools on the websites or Excel. Present the chart(s) in your project.

Write about 0.5 page of analysis the historic stock prices trend for the last year.

3) Apply the Capital Asset Pricing Model (CAPM) Security Market Line to estimate the required return on Target Corp's stock. Note that you will need the risk-free rate and the market return. Show this information in your project.

To get the current yield on 10-year Treasury securities go to Finance!Yahoo's at www.finance.yahoo.com -click on Market Data - Bonds. You will use the current yield on 10-year Treasury securities as the risk-free rate to estimate the required rate of return on stocks. Show this information in your project.

To get the market return go to money.cnn.com , Click on Market, then click on S&P 500.You will use 52-weeks change for S&P500 listed as "Year-to-Date" percentage change. Show this information in your project.

Calculate the required return on Target Corp's stock using the Capital Asset Pricing Model (CAPM) Security Market Line. Please show your work.

Find on the Internet the 52-weeks change of the stock price. Compare the required return on the stock calculated using CAPM against it's historical return over the last 52 weeks, found on the Internet. Is there a difference between these returns? Is Target's stock overvalued, undervalued, or properly valued? Why? Explain your answer.

7) Develop a specific recommendation, with supporting rationale, as to whether or not the assigned company's recent trend in financial and stock performance is of sufficient financial strength to warrant entering into a long-term commitment (about 1 page)

PRESENTATION OF PAPER AND WRITING:

-Organization, Format and Presentation of Paper including the Title page, Introduction, Body, and Summary

Use of Tables, Figures and Other Graphics to Summarize and Support Analysis Presented in the Paper

Logical and Smooth Flowing Transitions and Relationships among Sections of the Written Report

Research Sources and Significance of Research Information and Data, Use of APA Citation Methodology

Your final report is to be an executive-level financial report, directed to the CFO. This report should be 10 double-spaced typewritten pages (not including tables). Include suitable comparative, quantitative and qualitative analyses and conclude with a specific and supported recommendation on the projected financial viability of Target Corporation for the next several years.

Essential research data, financial calculations and other documentation as necessary to support your recommendation should be referred to in summary form in your report and attached in detail as enclosures. All major sources should be referenced. There is no set limit to the size of the enclosures, but it is recommended that only essential enclosures be attached. You should use references and bibliography to identify any remaining supporting documents you wish to include.

Reference no: EM131401431

Questions Cloud

Undertake project work : You are employed as a supervisor at the local mail distribution centre. The centre wishes to develop a new staff recruitment and selection process, to be implemented within the next three months.
What challenge were japanese facing in livingston : What challenge were Japanese facing in Livingston, and how did they attempt to overcome/endure it? What was the Gentlemen's Agreement
Identify an area of opportunity for your chosen company : Identify an area of opportunity for your chosen company. Then develop a PIC for your chosen company. You can find examples and more about a PIC through searching online.
Explore the long-lasting impact of emtala : Explore the long-lasting impact of EMTALA as it relates to cost, quality, and access. Be sure to briefly explore the pros and cons of this piece of legislation.
Evaluate the data about stock performance of target corp : Collect and evaluate the data about stock performance of Target Corp. for the last one year. Find the market ratios for Target for the last 1-3 years and its major competitor for the last year in the Internet.
Summarize your thoughts and opinions about the video : summarize your thoughts and opinions about the suggestion the video is producing. Share your opinion over whether you agree or disagree with the message the video is presenting
Former place of employment : CAREER CONNECTION: Mission, Vision, and You Think about your current or former place of employment or a business where you would like to work.
Discuss about the 3d television with outstanding displays : To start off this assignment, first make sure to review the required background materials carefully and make sure you have a solid understanding of the various pricing strategies and when they are typically used. There is also a listing of option..
Identify a human attribute that you can define : First name a common social expression that you can identify as a mentalism and then identify a human attribute that you can operationally define by your understanding of associated behaviors to this attribute

Reviews

Write a Review

 

Business Management Questions & Answers

  Purpose of the declaration of helsinki

What is the purpose of the Declaration of Helsinki? Discuss considerations when balancing risks, burdens, and benefits of medical research. What is a goal of informed consent?  Please contain a minimum of 2-3 peer-reviewed references.

  What is the role of perceived risk in the decision process

Explain habitual decision making, limited problem solving, and extended problem solving. What is the role of perceived risk in the decision process?

  Describe the infrastructure in detail including hardware

Infrastructure. Describe the infrastructure in detail including hardware and software capabilities that will make up the software testing environment in the following areas:

  Three examples of key strategic alternatives

Provide and discuss at least three examples of key strategic alternatives that are available to health care organizations today but were not available to them 20 years ago.

  High cultural intelligence display

What qualities would a person with a high cultural intelligence display? What are the effects of ethnocentrism on cross-cultural relationships?

  Main ideas and theories in globalisation studies

A few instructions on the word count of the Research Proposal. The annotated bibliography is becoming long in many of your Research Proposals that I have seen. This is not a problem. However, what I suggest is that you only count the 'annotated' b..

  Distribution of crime stories in newspapers

(Hypothetical) A random sample of 1000 daily newspapers found that on average, each edition contained 3.01 local crime stories per day, with a standard deviation of 2.65. Answer the following questions assuming that the distribution of crime stori..

  Oregon lottery and the oregon department

Discuss ways the Oregon Lottery and the Oregon Department of Education could have avoided the negative editorial written by the Oregon Center for Public Policy. Were there techniques used by these two departments that you disagree with?

  Consider for penetration into europe

Using a retail product as an example, what methods of distribution would you consider for penetration into Europe? Would the considerations be different if the proposed market was in Africa? Would this product be a candidate for foreign direct inv..

  Partnership for the purpose of raising cows and pigs

In 2005, Hardy and Dorn entered into a partnership for the purpose of raising cows and pigs. The two men were to share equally all costs, labor, losses, and profits.

  Name some products that have a high degree of quality

part 2 Outline the steps in the design of a quality control system. These steps can be found in narrative form within section 9.1 of your textbook. Discuss how the steps can lead to higher efficiency in an organization.

  Investors in a typical partnership

A disadvantage of the corporate form of organization is that corporate stockholders are more exposed to personal liabilities in the event of bankruptcy than are investors in a typical partnership.

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!

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